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...
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...
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.
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.
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.
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...
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.
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.!
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.
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)
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.
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.
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.
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.
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.
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?
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