Designing A Random Seating Arrangement

Nov 24, 2008

Designing a Random Seating Arrangement

I have been given a Task of Designing a layout for seating arrangement for an Exam....

I would know the Total Number of Students appearing for the exams and their respective roll nos...

I would also be given the No of Rows and No of Columns that can be accomodated in the Examination Hall to form a Matrix...

Considering that I have around 65 students appearing for the exam and there are 10 Rows and 7 Columns to accomodate students in excess of 65..

So I need to have a mechanism which can give me the Roll Nos allocated from 1 to 65 randomly in the Matrix...in such a way that the Roll Nos don't get repeated as well as they are not in series next to each other...

In Deciding the Size of Matrix providing the No of Rows and No of Columns if possible...
Ex:-
Lets say Sheet1, Column A has a Heading Roll No and all the Roll Nos from 1 to 65 and Column B has all the Names..

Then I would like to have a code which can generate the Matrix Size in C2 which captures from the Max(A:A) and a Matrix Generated in the Sheet2 from the Starting Point being cell B2 till end...as the cell A1 would contain text as Row/Column and from cell $A2 till end will display Row Nos i.e. Row-1,Row-2,Row3 etc.. and cell B$1 and the entire 1st Row would have headings as Column-1,Column-2,Column-3 etc..

Is this possible as these exams are held every week and its a tedious task to Manually design a Random Seating arrangement as well as the Matrix...

ADVERTISEMENT

Table For Seating Arrangements

Oct 26, 2007

I am looking to create a table for seating arrangements. The number of seats (columns) and rows varies from event to event. I need alternating rows to be offset so that seats are not directly aligned so that a viewer looks between the two seats in front. Each seat needs to be numbered and the first cell in each row is +1 the number of the last cell in the previous row. I can build the table manually each time but would like a simpler and more efficiently way to do so.

View 5 Replies View Related

Formula To Populate Seating Assignment?

Feb 24, 2014

I need to assign van seating assignments to a client room census. I have a workbook attached. I am hoping a formula can get me there. The only variables are if the cell in column E has TO BE CLEANED or READY in it, then I want the formula to overlook that particular cell. I don't want to assign a seat to an empty room! My workbook should make what I am attempting to accomplish much more clear.

Also, there are either 12 or 15 seats available in each van, but the workbook reflects that.

View 9 Replies View Related

Designing A Sheet

Dec 16, 2008

What I need the sheet to do:

1.Rows containing; Costumers name, invoice number, date of service, subtotal, tax, total, and whether or not they have paid yet.

2.I then need to take that data and group it to see how much each person still owes, which individual bills they have paid, and which individual bills they have yet to pay.

3.Then take all that data from each separate bill statement, and make an account balance for each person he does work for.

I had already done this for over a yearís worth of work he did. But after all the data was in, for the life of me I couldnít think of a way to do step 2-3. The problem is that on some jobs he does, the people will pay him upfront, in which case he marks paid on the bill. But other times they will send him a check in the mail 1-3+ months later and some times not for the full amount they owe. Now I have a list of all those checks he receives, but I canít find a simple way to subtract those checks from what people still owe him.

I need a way to sub-total each customers bills, but still be able to add in payments, or future bills and payments that person may have. Each month he does more work, and sometimes for the same people, so I need to be able to just sit down, look at each bill, and just type in the data I need off it into each personís separate account.

The only way I could think to do this, is to give each different customer he has their own work sheet. But this makes the file size huge and organizing totals a pain. Not to mention editing the data in individual accounts for future work/payments a pain.

View 9 Replies View Related

Designing A Workbook Patch

Jan 7, 2004

I created a large workbook (let's call it Workbook X) that might not be completed yet. As a large group of colleagues use a copy of this workbook and already entered their data... I need a quick way to upgrade their copy with the changes I made in my version.

I learned before that running a macro from within one workbook could alter things in another workbook. Based on that idea... and the knowledge that I am more a designer than a programmer... I need help to bring my ideas into practice.

The idea is as follows. I record any changes made in the mother workbook into a macro. I migrate the module with the code into an empty workbook and rename it auto_open. I send the patch workbook to the colleagues and ask them to place the workbook in the same folder as the workbook X. When opened the patch workbook the code is executed; it opens the workbook X, it shuts off the use of macro's in workbook X, executes the change-code and finally saves and closes workbook X as well as the patch workbook.

Need isn't? Well, is it possible to create such a patch workbook and how can this be done? Other suggestions are welcome too...

View 9 Replies View Related

Designing A Macro To Copy Data From Web Pages Into Spreadsheet

May 17, 2006

I have a folder full of uniformed web pages ( name and design) and I was wondering if it's possible to create a macro that will open up each page, copy specific data from each page, and paste it into an Excel 2002 spreadsheet. Unfortunately, my skills in VBA are very limited at best and I'm not sure if this is doable or is it something I'll have to go into each page and copy the data.

View 3 Replies View Related

Arrangement

Mar 16, 2009

I've vertically data in each cell like this.

A1 john
A2 sam
A3 robin
A4 xxx
A5 xxx
A6 yourself
A7 xxx
A8 no need

So on..... in very large amount.

But need substitution here.
I dont want "xxx".

I mean I need data in B row vertically but like this.

B1 john
B2 sam
B3 robin
B6 yourself
B8 no need

Please suggest any formula for the "B" cells.

View 9 Replies View Related

Pivot Table Arrangement But Without Calculations

Apr 25, 2014

I am trying to get my data to be visualized on a monthly basis. A Pivot Table works perfectly in getting the right arrangement, except that it performs a calculation in the values summary field. Is there a solution that allows the Pivot Table to plop the actual text values that it is pulling from? Maybe Excel Pivot Tables aren't the right solution, so maybe another type of software might be useful? Or perhaps a change in the VBA script? The original table looks like this:

ID Description Date Code Building
10223 Package/Split 02/01/2015 ALRM1 A
10223 Package/Split 02/01/2015 PLMB1 A
10992 Pump Test 03/13/2015 ALRM1 B
10992 Pump Test 03/13/2015 PLMB1 B
10992 Pump Test 03/13/2015 ALRM1 B
11432 Inspection 03/13/2015 ALRM1 C

The way I would like for it to look is this:

January February March
Building ID Description Building ID Description Building ID Description
A 10223 Package/Split B 10992 Pump Test
C 11432 Inspection

In the original report, there can be multiple codes for the same ID (ALRM1 and PLMB1 for 10223). In such cases, Pivot Table works by summing up the values, therefore displaying the ID in just one row. I would like for it to do the same thing (spit a multiple row ID as one row) but display the actual text values of Building, ID, and Description as shown. I don't need the code in the table, but it's there in the original data simply to differentiate between the two IDs.!

View 14 Replies View Related

Arrangement Of Vehicle In Form Of Report

Jan 15, 2013

I have a problem regarding making a report in excel.

My problem is :

I have a excel file where columns are
Collapse | Copy Code

S.no. Date. From To Mode_of_Transport Depart. Arrival NameRemarks

So my job is to find the persons who arrived at interval of 30 min so that vehicle can be arranged for them.

View 5 Replies View Related

Change The Arrangement Of Text In A Cell

Jun 10, 2009

I have a range of cells that have text formatted in the following way;......

I need to change the arrangement of the cells so that the Brackets and numbers appear in the cell before the text, how can I achieve that? Poor example but each cell will only contain one of the above variants, not all of the variants.

View 2 Replies View Related

Copy Cell And Paste In Different Arrangement

Aug 25, 2013

I want to change arrangements of cell by using macro

A
B
C

1
Code
C1
C2

2
Dr2890
2150
2670

[Code] .........

View 8 Replies View Related

Lookup Functions & Data Arrangement

Apr 21, 2006

I'm at an impass and need some help please. I'm trying to create a spreadsheet that will look up UNSORTED data in Column A and return the value of the corresponding Row data in the adjacent column. Can this be done? It is my understanding that LOOKUP functions only work with sorted, ascending data, but this is not possible with the data I'm trying to analyze.

(eg. COLUMN A - contains unsorted list of names
COLUMN B - contains numbers indicating skill level of the person in the next column

I need the formula to look at column A, pick out "Joe Smith" and return the number value from COLUMN B)

View 3 Replies View Related

Charts Colour Fills And Sequence Of Arrangement

Feb 22, 2009

If is there a way to get more styles or increase the colour schemes for the charts.

View 2 Replies View Related

Generate Random Numbers In Random Cells

Sep 18, 2009

I am working on a Random Cycle Count Generator that provides random SKU#s based on 3 separate columns of SKU listings. The user clicks a button to generate the SKU#s to cycle count for that day. What I would like to see is a date stamp in the columns next(B,D,F) to the referenced SKU listing(A,C,E) based on which SKU#s are generated. This will let me see the last date that the SKU was generated. I would also like it to automatically save after generating.

View 2 Replies View Related

All Possible Random

Aug 18, 2007

I have eight teams and i want them to play each other i.e

1 v 2
3 v 4

and so on till all teams have played each other, can i do this randomly

View 9 Replies View Related

Sum Up From Random Table?

Aug 1, 2014

Since the range selection is going to be changing at time intervals( automatically), they can not be pre -defined( as above in g2,h2)

Suppose we want to know the sum of all the values against 11(now which is described as =g6 in cell J2),

HOW DO WE SET THE RANGE (E6:H11) ?

( AUTOMATICALLY, SUBJECT TO CHANGING THE SELECTION G2,H2 WHICH WILL THEN BE SOMETHING ELSE(EXAMPLE G2=1 TO H2=5)

View 6 Replies View Related

Random Number

Dec 10, 2006

How do I make a row of 5 random numbers in A2:A6 that are not the same as each other. It's basically for a Bingo card. I have a formula that can calculate the random numbers =INT(RAND()*15)+1 under the B's for example, but I can't seem to figure out how to make it so they are not the same.

View 14 Replies View Related

Random Input

Feb 26, 2009

First time poster, long time viewer for help.

this one should be an easy one for you experts.

i am in charge of making an assignment list in my classroom .

cells A1 all the way to A20 have a single childs name in them.

in the corresponding box ,B1 which is next to the first name and B2 next to name 2 , etc etc. i would like to put 3 random chores they need to do for the week. the first chore being in column B the second chore in C and thirs chore in D . in other words, each child listed in column A , 1-20 will have 3 chores to do over the week .

all 3 chores for each child will be in the same numbered row as their name.

i have a list of all the chores at the bottom of the spreadsheet, theyre from A20 to A40 (20 chores in a row) . i want excel to randomly put A20-A40 in the corresponding boxes next to the kids names.

im tired of having to mix all their chores up for the week next to their names.

View 10 Replies View Related

Random Name Generator

Jun 20, 2009

I'd like a spreadsheet that pulls out a random name.

I'll put in a lookup table, George, Fred, Ralf, Steve, Peter.

Sometimes Fred will come up, sometimes George will.

View 14 Replies View Related

Random Number In VBA

Oct 13, 2009

How can I make sure that I can generate random numbers that don't repeat using the rnd function in VBA.

View 14 Replies View Related

Random Numbers (1 To 40)

Sep 9, 2005

What do I need to do please to have a number in a row 1 to 40 as an example below

1,23,9,25,33,40 each row needs to be 1 to 40 but number no more than once
six rows deep yes the other rows can have the same numbers as above or below

=INDEX(ROW($A$1:$F$10),RANK($H1,$H$1:$H$60))

=RAND() copied H1:H60

View 14 Replies View Related

How To Set Up Random Name Generator

Jan 22, 2012

I need a formula that generates random names that i have in column a (a2:a30) I need the name to be in b1 to j1 there can't be any duplicate names

View 3 Replies View Related

VBA Random Name Select

Dec 12, 2012

I have been thinking about a name selection tool that would automatically pick a few names for internal audit. I can handle the useform launch and other basics but here is what I see happening.

1. The empname! sheet contains a list of all the company employees, with employee number in column A, names in column B and an "X" or blank in column C.

2. The main sheet called auditmaster! contains nothing currently

3. When the code is ran the userform prompts the user to select how many individuals to audit by entering an integer in a textbox.

4. If the user selects 5 for instance, the code will run and will select 5 random employees for internal audit. It does this by first checking column A of the empname! sheet and seeing what the highest and lowest numbers are. This would create the range for the random function.

Next if there is an "X" in column C of empname! sheet, those employees numbers are excluded from the random choice.

Following this the function will select the appropriate number of individuals to audit using random again and place their names/number on the masteraudit! sheet.

The detail should be placed as the following, employee number goes to column F, name to column G. Starting with row 10. The code should also number the results 1 - however many were selected for audit in column E.

View 2 Replies View Related

VBA For Random Numbers?

Apr 6, 2014

How can I use a macro on a button in SHEET 1 to generate random numbers on SHEET 2 as follows?

Cell A1: (1-10)
Cell A2: (1-6)
Cell A3: (1-100)
Cell A4: (1-12)

I've got it working with formulas, but every time I press "DELETE" the random numbers jump to new values.

View 1 Replies View Related

Random Numbering

Jan 30, 2007

I have a list of names in Column A going from row 2 to 15. I want to randomly assign them a number ranging from 1-14, but that random number can not be assigned twice. I only need each number once.

I am putting the formula in column B.

View 9 Replies View Related

Random Numbers ...

Aug 13, 2008

I have had some difficulty searching this on the web, but how would I generate a random number between 1 and n?

View 9 Replies View Related

Random Select.

Sep 14, 2008

I want to random select one of the following,red,yellow,blue,green,orange & white. (as text) in cells A2:A1001.

View 9 Replies View Related

Random Draw

Dec 1, 2008

I was looking for some code to randomly generate a number for a prize draw I am doing. I found a great piece on this site, which I have slightly changed to give me what I have below.

It works great except for one thing I cannot work out, I have the code below working on cell "C1", I would like it to work in cell "C5", but I can't seem to work this out.

Sub SlotsNum()
Dim w As Long, x As String, y As Long
Randomize
x = Format(Int((Range("B2") - Range("B1") + 1) * Rnd + Range("B1")), "0000")
For y = 1 To 1
For w = 1 To 250
Range("C" & y) = Int(8000 * Rnd)
Next w
Range("C" & y) = CInt(Mid(x, y, 4))
Next y
End Sub

Also, whilst here. i will have one other problem, with it being a prize draw I do not want to draw the same number twice. At the moment I have a small macro that copies the winning name that appears on the main screen (via a vlookup) onto a winners spreadsheet. I am thinking of then creating another macro that replaces the winning name on the master list with an "Already Won" entry, so we can just select again.

View 9 Replies View Related

Random Assignments

Oct 30, 2009

I have a worksheet that has weekly meeting dates in column A and in columns B through M different responsibilities/task. Each week, I have to schedule 1 person to perform each task. A person can only perform 1 task each week. I have a list of 40 people that are eligible to do this.

Currently I am assigning each person to a task while trying to evenly assign people and space out the timing as to how often they're assigned. Of course, being human has led my results to both favor and overlook some people. Is there a way to randomly assign any 12 people from my list into each week?

View 9 Replies View Related

Random List

Nov 25, 2006

i have entered some values in excel like this

A1 B1
1 a
2 b
3 c
4 d
etc

i will put a command button, like "Randomise"
what i wanted is , if i click that command button, the Value in cell A1 should be remain same. but the values in B1 has to be randomly changed that is, eachtime i click the randomise button the value of b1 must keep changing for every click. someting like this
A1 B1
1 d
2 f
3 h
4 a
etc

View 11 Replies View Related

Random Sorting ...

Dec 18, 2006

When I sort a list of names to rand next to it for some reason it doesnt seem to work anymore. I've done this before and its never given me problems

rand() john
rand() Jack

etc.

I sort it to the rand column

It should shuffle the names by pressing f9 but its not working.

View 9 Replies View Related

Random Shuffle

Apr 6, 2007

I am making a barrel racing spreadsheet. In Column B I am putting the participants names, in Column C I am putting the name of their horse. So Row 1 will be my header row. What I am trying to do is a random shuffle, but the participant and their horse have to stay together. Also is there a way, where I can put the stipulation, that if a person is randomly put in number 5, that she has to be at least 3 spots away from that number.

View 3 Replies View Related

Random Number Between Two Numbers VBA

Jan 3, 2014

I have build a system that needs a lot of random numbers generated to work.

I have used what I thought would work to generate me these numbers like this example:

VB:
Lastrow = ThisWorkbook.Sheets("RPlay").Range("A" & Rows.Count).End(xlUp).Row
RPlayerNum = Int((Lastrow - 2 + 1) * Rnd + 2)

This would generate a random number into RPlayerNum variable, based on the list in sheet RPlay, missing off row 1 as the header.

However we have noticed a massive flaw in this code.... It works as long as the excel file is open, each time run it gives a different random number. However if you close the excel file and open it, then run it, it ALWAYS gives the same number first run, every time.

View 3 Replies View Related

Random Number For Group

May 18, 2014

How to generate random 50 number with 10 group..

View 6 Replies View Related

Generate Random Numbers?

Aug 19, 2014

I am creating an excel spread sheet for a project I am doing, I need to create a daily chart for 6 months of water usage that results in averaging set targets.

I have made a chart with the average uses per day but would like to have daily numbers that average out to what i have but in a random sequence e.g. i have that a shower uses 320 litres per day for 2 people is there a way i can make a chart that says: 300 (a1) 340(a2) 260(a3) 360(a4) etc i need to do this for 180 days with random numbers generated to average the same overall. I dont know even how to generate random numbers.

View 4 Replies View Related

Random Numbers Without Macro?

Feb 3, 2014

Any way to make say cells A1 thru A10 produce random numbers from 0 to 9.

I would like to do it without a macro if possible. I also need a button to generate those random numbers. I know this button may make it impossible to not use a macro. If it has to be done with a macro then so be it.

View 12 Replies View Related

Summing Random Numbers?

Feb 23, 2014

I have a process that generates the value X in cell A1 randomly. So I can change the value of X in A1 by clicking on F9. I want to sum a sequence of X values. I can do this by manually copying each X to a row of cells and then summing the row values. But that is tedious. Can the summation be done automatically without being regarded as being circuler?

View 8 Replies View Related

Random Data Selection

Jan 13, 2009

I have data for number of firms as :

year firm
1 1
2 1
3 1
1 2
2 2
3 2
1 3
2 3
3 3
.............
.............
1 1000
2 1000
3 1000

how can one chose random samlpe from this population.

View 3 Replies View Related

Generate Random Numbers Between 0-9

Feb 1, 2009

I am trying to generate random numbers between 0 - 9 in ten cells that do not repeat an always include every value 0 - 9 (0, 1, 2, 3, 4,...9). The object is to have the numbers randomize each time. So cells A1:A10 could look like this:

3
9
4
5
1
0
6
8
7
2

Or, they could look like this:

9
7
5
2
8
4.................

View 4 Replies View Related

Random Sampling Without Replacement

Jun 5, 2009

I'm trying to take a random sample without replacement. The sample is also partially representative, e.g. if a certain proportion of the data are Class A and a certain proportion is Class B, that proportion is maintained in the sample. After the proportions are set, the observations within each class are randomized.

Is there anyway to sample a number of rows, where the number of rows is based on the value in another cell, without having to use a lookup function or index match? Sorry if the question is a little unclear; please let me know if you need any clarification.

View 10 Replies View Related

Sampling/Random Selection

Jun 28, 2009

I have a file (see SAMPLE file attached) with over 2000 records. I need to know if there is a way to do a sampling or random selection by ethnicity and gender in order to get a diverse population for only 60 individuals. The selection criteria should be on ethinicity and gender.

Is this possible?

View 10 Replies View Related

ADVERTISEMENT