Schedule, Organizing
Oct 15, 2008
I make our employee schedule at work, and so in Excel I have eight sheets for one workbook. (Employee schedule, then each day of the week) On each day is a table separating the shifts. Morning, Split and Night.
I was wondering if there was a way for Excel to look at the schedule sheet, and then automatically place each employee and their shift on the following day sheets. (example: Joe has 2-10 on Monday, 10-6 on Thursday and Friday) So the Excel puts Joe underneath Split 2-10 for Monday, and Morning 10-6 on Thursday and Friday.
View 10 Replies
ADVERTISEMENT
Jun 8, 2006
I have attached a file that I need a little guidance on. The list of information on the left needs to be organized and put in the appropriate tables on the right. Each row represents one person and I need to know how many people from the list fall into each category. For example: The first row has a gender of "1" and the age is "46" and the status is "1". Therefore, this person falls into the category associated with "K11", I filled it in already. My list will vary in length from 20 rows to 20,000. I am not sure how to go about this and have been frustrated by failed attempts.
View 6 Replies
View Related
Jun 27, 2013
I'm looking for a opinion on what might be the best way to organize some data for sorting later.
I work for a company and we have a lot of equipment. I have a spreadsheet with each piece of equipment in a row. Column A has the equipment name with all the following columns having info about the equipment. One example would be voltage, some equipment runs at 120v and some runs at 208v, some runs either or and some runs at other odd ball voltages, although this is rare. I am trying to determine what the best way to enter data like this would be. Would I be better off entering one column labeled voltage and filling in the voltage, but this becomes problematic when a piece of equipment can run multiple voltages. The other though is to do multiple columns, one labeled 120v, one 208v, one 480v or whatever and go from there. Than put a "X" or Yes or something in the columns that apply.
I have this same scenario for multiple variables like connectors, hardware accessories and things like that. I am trying to think this through before entering all my data of what could be the negative effects of this.
Would it be possible/make sense to do a radio box?
My end result is hopefully to be able to say I want a piece of equipment that meets multiple scenarios like runs 120v, this accessory and this connector. Ideally setting up some sort of easy sort method in my column headers.
View 2 Replies
View Related
Nov 26, 2013
I have a spreadsheet converted from pdf having more than 30 Columns .for Example( name, address, tel. website , products etc).
Problem is that data is not consistent in all columns.Some have full range(all 30+ columns having data) and in some not( only some columns having data )
I want to organize data as per headers and leave cell blanks or fill in (N/A) where data is not available for that field. How can I correctly populate it.I need data as per headers in rows.
Here i am dealing with 2k rows with 30+ columns.
View 3 Replies
View Related
Nov 16, 2011
I have a list of 35k files and the number of files keep changing every week. At the end of the month I manually have to sort the files i.e move files to the respective folders, delete them or take no action. This takes me an entire day. There are useless files which needs to be deleted.
Si NoFile nameFile PathNew PathAction
1Store C:Jay PersonalDesktopRXProjectSix SigmaStore.xlsC:Jay PersonalDesktopNewProjectSix SigmaMove
2AppointmentC:Jay PersonalTeam QualityAppointment.pptC:Jay PersonalTeam QualityAppointment.pptDo Nothing
3QualityC:Jay PersonalDesktopRXProjectSix SigmaQuality.docDelete
The format is as follows. File name is the file which I intend to move, File path is the current file path, New path is the path where I want the file to be moved, Action (Move, Do nothing, Delete) is the action i intend to take on the file.
View 3 Replies
View Related
Jul 11, 2014
I'm setting up a type of form in excel where I have some validated drop down lists and I'm trying to use a macro that will, upon a button click, take the data from the drop down lists that are entered into the boxes, and organize them into a chart on a different sheet of the document. This would be the form with some drop down lists.
Juice Type
Apple
Juice Size
8 oz.
Juice Buyer
Ronald
I want to add it in to a table with every button click filling in a new row in a table like this,
Juice Type
Juice Size
Juice Buyer
Apple
8 oz.
Ronald
View 3 Replies
View Related
Apr 19, 2007
Is there a way to sort the worksheets in a workbook after they have already been entered. My clerk put 200+ worksheets in one workbook....out of order.
View 7 Replies
View Related
Sep 11, 2013
I have a question on how to organize cells from lead sheets that I load inside excel, when it loads it shows as is:
Name, Last, Address, City, State, Zip, Phone #
I need it to be organized so when I print they read:
Name
Address
City, State
Phone#
Instead Of them All together in a landscape view.
View 1 Replies
View Related
Dec 31, 2011
I'm looking for a formula that would arrange the numbers from column K into the sum table, according to their sum total from column L, the formula should begging in cell P3 to maybe T3 and down to T30 I suppose ?
KLMNOPQRSTU1NumberSum Sum Table     2Â
30235Â 0Â Â Â Â Â Â Â 40246Â 1Â Â Â Â Â Â Â 50279Â 2Â Â Â Â Â Â Â 602810Â 3Â Â Â Â Â Â Â 702911Â 4Â Â Â Â Â Â Â 80347Â 5Â 023Â Â Â Â Â 903710Â 6Â 024Â Â Â Â Â 1003811Â 7Â 034Â Â Â Â Â
1103912Â 8Â Â Â Â Â Â Â 1204711Â 9Â 027234Â Â Â Â 1304812Â 10Â 028037Â Â Â Â 1404913Â 11Â 029038047Â Â Â 1507815Â 12Â 039048237Â Â Â 1607916Â 13Â
049238247Â Â Â 1708917Â 14Â 239248347Â Â Â 182349Â 15Â 078249348Â Â Â 1923712Â 16Â 079349Â Â Â Â 2023813Â 17Â 089278Â Â Â Â 2123914Â 18Â 279Â Â Â Â Â
2224713Â 19Â 289478Â Â Â Â 2324814Â 20Â 479Â Â Â Â Â 2424915Â 21Â Â Â Â Â Â Â 2527817Â 22Â Â Â Â Â Â Â 2627918Â 23Â Â Â Â Â Â Â 2728919Â 24Â 789Â Â Â Â Â 2834714Â 25Â Â Â Â Â Â Â
2934815Â 26Â Â Â Â Â Â Â 3034916Â 27Â Â Â Â Â Â Â 3147819Â Â Â Â Â Â Â Â Â 3247920Â Â Â Â Â Â Â Â Â 3378924Â Â Â Â Â Â Â Â Â 34
View 9 Replies
View Related
May 13, 2014
I am in process of making an appraisal system for my organization through excel templates .Each employee will Have 2 KRA templates .One specific to their roles and other in the area of their interest.
So while rating i will select role of the person and his interest area.Then the comprehensive template integrating both templates should be generated from the master templates which are in place.If i make any edits in Integrated template,it should not be reflected in master templates
View 2 Replies
View Related
Jan 31, 2014
I have a bar chart that monitors month over month activity. I use Layout 5, which allows for the numbers data to neatly be organized in a table below the bar chart. However, i recently started using the data on a secondary axis to accurately reflect trend lines. It works great, but now the data table below displays redundant information. see attachment.
example.jpg
I just want that data in the data table to be displayed once, completely leaving of the axis legend.
View 2 Replies
View Related
Jan 31, 2009
I'm a novice in VB and can't work out how to solve the following problem:
I have imported NMEA-data in text format from a GPS into Excel. This data is acquired in real-time at 10Hz, which borders what the GPS in capable of calculating. As a result the data isn't quite reliable enough - there are strings missing and some lines have been skipped by the GPS. This is a typical example of what sometimes happens: ...
View 15 Replies
View Related
May 13, 2009
Sub SplitOut()
Dim DataSH As Worksheet, OutSH As Worksheet
Set DataSH = Sheets("Input")
DataSH.Activate
lastrow = Cells(Rows.Count, "D").End(xlUp).Row
For Each ce In Range("D2:D" & lastrow)
Application.StatusBar = "Actioning " & ce.Row & " of " & lastrow.............
I am working on this spreadsheet that has a lot of information that will only get bigger as time goes on. I would like to organize the contents of one column into separate spreadsheets. So if I have "stacking" in one cell of that column, the whole row associated with that cell will go to a new spreadsheet labeled "stacking".
I have attached the sheet. I would like column D (Type_Code) to be organized by the words in that column. So I would have 5 or so worksheets labeled stacking, cartoner, wheel, inspection, etc. The data here is input by a machine.
View 3 Replies
View Related
Mar 30, 2009
I want to manipulate team statistics and having a bit of trouble trying to figure out how to do it. I am relatively new to excel and am using Excel 2007.
I have attached the excel file for your reference (the same file).
What I need to do is first find out the team number using the table on first sheet named "Teams". User will enter team name on call B4 of sheet "Team entry" then in cell C4 there should be a formula to find the team number (is beside name on sheet "Teams) and displays it (on C4). Then on cell D4 of the same sheet "Team entry" there should be a formula that displays cell A1 (shows a statistic for that team) of the team sheet. Each team has its own stat sheet named by its team number (easier for me to keep track). So basically D4 should show cell A1 of the sheet that shows stats of the team entered. In addition cell E4 of "Team entry" should display stat2 (of the sheet "stat2")for the team entered.
View 2 Replies
View Related
Jan 15, 2009
Is there a way to take the values between C2 & D2 and have them automatically post in column F ?
View 2 Replies
View Related
Nov 15, 2008
I am trying to schedule a macro to run at 11:45 pm every time. I use system scheduler to open the excel file and when I use this command to run the macro nothing happens. The workbook opens fine but the macro does not run. I only wants to run the macro once day even if I open the workbook during the day I do not want it to run.
View 13 Replies
View Related
Oct 16, 2009
We have huge restrictions on hours, and to avoid inputting, then revising the schedule into my companies scheduling module, then having to change it again when the boss looks it over, it's just confusing.
Anyway, I'll get to the point, I want to add the hours up in a row of cells for the week sunday through saturday. Like so:
1100-2100 | 1100-2100 | OFF | 1100-2100 etc... I want it to add these cells hours up and have the total end up in the 8th cell.
Is this possible? I am a new excel user, or at least, setting up my own sheet.
View 10 Replies
View Related
Dec 2, 2006
The table posted above is the schedule for my employee. I need an input box which asks for a date. When the user supplies date, it should look for people who are scheduled for that particular date and who are on leave and put the result in the next worksheet at the last occupied row.
For instance, if I supply the date as 2nd Dec then the next worksheet should be filled with @ row # 2 (Row1 has headings)
EmployeeEmp IDSchedule
A123409:00 PM - 06:00 AM
B123511:30 PM - 08:30 AM
C123602:30 AM - 11:30 AM
E123811:30 PM - 08:30 AM
G124009:00 PM - 06:00 AM
Then if I select 3rd Dec, the next worksheet should be filled with the following data starting fom row number 7 (just below the above data)
A123409:00 PM - 06:00 AM
B123511:30 PM - 08:30 AM
D123705:30 AM - 03:00 PM
G124009:00 PM - 06:00 AM
View 9 Replies
View Related
Feb 9, 2007
Excel is a new program for me sorry to say it but i have been try to figure out how to write a schedule on it and tally the hours for each employee i have them set up in rows right now and i hope i can keep it that way but i am tired of add hours up for each employee every week i'm sure it is really easy but can some one let me in no the little secret
View 9 Replies
View Related
Feb 24, 2009
Have a basic weekly schedule for 300 employees. Need to be able to identify the last day off in previous week so the following week isn't scheduled to work on the 6th or 7th day without a day off. For example, if schedule is Mon - Sun and employee #1 has Mon & Tues off this week, next week Mon would be the 6th day so I wouldn't schedule that person on Monday the following week. Calculate last column "Next Wk Mon" instead of manually figuring it out... Need to be able to identify last day off, count the days from that point to the next monday. It becomes difficult when days off are split...
MonTueWedThuFriSatSunNext Wk
23-Feb24-Feb25-Feb26-Feb27-Feb28-Feb1-MarMon
Emp 1OffOff6
Emp 2OffOff5
Emp 3OffOff4
Emp 4OffOff3
Emp 5OffOff2
Emp 6OffOff1
Emp 7OffOff1
Emp 8OffOff4
Emp 9OffOff2
View 9 Replies
View Related
Apr 6, 2009
Im having trouble with getting a macro to run at a specific time and day (Every Thursday at 7PM).
Here's what I have done so far..
1. I added my excel file to the task scheduler
2. created a class module and place the code below into it.
In testing the workbook opened but it asked if i wanted to enable or disable the macros - how do I get around this? And it does seem to kick off the macro (create_all).
Private Sub Workbook_Open()
If Hour(Now) = 1130 And Weekday(Now, vbMonday) < 7 Then
' TheNameOfYourCurrentProcedureHere
create_all
If Workbooks.Count = 1 Then
Me.Save
Application.Quit
Else
Me.Close True 'save the changes and close the workbook
End If
End If
End Sub
View 9 Replies
View Related
Jun 12, 2009
I am Cuttently creating a schedule in excel for work. the schedule will look like this:
Name.........................Shift
Andrew.......................6-3
Jonathon....................12-7
Kim............................9-5
etc etc
the thing is though this is simple enough but i am trying to use a bar chart to help me show how many people i will have on shift at anytime e.g ...
View 9 Replies
View Related
Aug 27, 2009
which is row D on my excel sheet. I need to fill into another form who works shift D, shift E and shift N. Is there a formula I can use to do this? I have given a small sample of my schedule below.
AB CD 252627ShaunD DDNicoleD EDEmilyE DECathyENEJohnNEN
View 9 Replies
View Related
Jun 26, 2014
run a spreadsheet for Vendor Deliveries and got as far as promised delivery date and actual delivery date with a late or on time comment. Im trying to get a percentage from this data.the excel spreadsheet that i have uploaded.Delivery Schedule.xls
View 5 Replies
View Related
Jan 8, 2014
Combing these two formulas. I have a work schedule spreadsheet. If the employee is Off I want the value to = 0 (zero hours). But if the cell has a start time I need it to calculate those hours. I know both of the formulas work individually. But I need them to work together.
Formula for when cell says OFF:
=IF(C11="Off",0)
And the second
Formula to calculate hours (based on start time/finish time is the same for all employees)
=($X$4-C11+($X$4<C11))*24
View 2 Replies
View Related
Mar 2, 2009
I am trying setup a maintenance schedule checklist for a large list of items. Each item has a cycle in weeks for the checklist. I set up a nested if statement to check if the item is overdue or done based on the cycle and the current date. The if statement checks when the last time the item was done or overdue and populates an "X" for the next due date. It works fine as long as the cycle is 4 or less. After that there are too many if statements and I get an error. I'd rather not have to use a macro to get this to work. Any ideas?
View 14 Replies
View Related
Jul 2, 2009
I have attahced an example of what I need to do. I need to project due dates for each of our 8 departments based on a ship date of the final product. Each of the 8 dept. have a number of operations (ops) and given number of hours for each op. These alocated hours change on every job plus I have 2 outside operations that may or maynot be added to the mix. I don't have a clue on where to even start with this formula.
View 2 Replies
View Related
Nov 21, 2009
I need to do is calculate the hours between two clock times minus 30 minutes.
Example:
Cell A1 - 4:00am
Cell B1 - 16:30
I need Cell C1 to say 12 (hours)
Also:
Cell A2 - 17:30
Cell B2 - 02:00am
I need cell c2 to say 8 (hours)
View 6 Replies
View Related
Dec 19, 2009
I have made a work schedule for my local business and have set up a series of formulas that will fill out time cards that I could print out directly onto the paper time cards. The formulas that I have work except that if there are two subsequent entries that later will not return a value and result in an error.
If you could take a look at it that would be awesome. To use it you just need to type a name into the name column and a work time into the time column for that day. then in the other sheets( one for each worker ) it will set up the time card. The the error happens on Thursday, when Bob has an entry right after Fred. Then on Bobs sheet it gives me a #N/A.
View 10 Replies
View Related
Jan 28, 2010
I'm trying to automate the calculation of my prepayment schedule. The linked image http://img402.imageshack.us/img402/2...mentqueryp.jpg shows the basic layout of how it will look. The yellow cells are going to be the only input cells but i'm unsure what formula will achieve the desired result i'm looking for across the remainder of the spreadsheet. Essentially I need the formula to look at the period (start and end dates) the invoice covers and apportion it correctly. The apportionment isn't a straight equal division per month though as it has to be calculated according to what element of the expenditure hasn't been realised yet.
For example in the car park rent line the figure of £8,000 in July is derived from the fact that that is how much hasn't effectively been incurred yet as it relates to the remainder of the invoiced period (Aug - Mar) and is calculated as 8/12 x £12000.
I hope you understand what i'm requesting, if not, let me know and i'll try to provide a better explanation.
View 7 Replies
View Related
