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...
View 13 Replies
ADVERTISEMENT
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
