Holiday Roster Templates
Aug 19, 2007where I might find some?
View 3 Replies
ADVERTISEMENT
Saving Templates As .xls?
Mar 22, 2007Is there a way to automatically save a template as an xls file using the macro below?
ThisWorkbook.Activate
Sheets(" SCHEDULE").Select
ChDir "C:Documents and SettingsChrisDesktopRainforestMASTER LABOR"
ActiveWorkbook.SaveAs Filename:=Sheets("Schedule"). Range("v77").Value
I am trying to make a code that was written for the master schedule available when the workbook is renamed?
How To Work With Forecasting Templates
Dec 27, 2013I do forecasting for my company. We have a forecast every quarter. Any good templates (simple or complex) for presenting different quarters (or time periods) and the actual results for management?
View 5 Replies View RelatedLoading Email Templates
Aug 17, 2007I'm trying to achieve: -
I want to create a spreadsheet which will include a column with email addresses in it.
Here's my problem.......
I want users to be able to click on an email address (like a hyperlink) and by doing this open their mail client (in this case Microsoft Outlook) and send an email. I would like the mail client to load a specific template just by clicking on the link from Excel. I'm not sure if this is possible, but there doesn't seem to be many things you can't do on Excel.
Combining Multiple Templates Into One
Aug 17, 2009A member of my team has created numerous templates in Excel 2007 for various customers. Each template has some columns that are identical for each (Cust Name, for example), and some columns are unique to each customer. I want to combine all of these individual templates into one Excel workbook and be able to click (select from a dropdown list) the customer name, and have only those columns that pertain to that customer appear. Select another customer name, different columns appear, and so on. Is this possible to do in Excel 2007? [This is my first post, so please forgive any offenses if my question is too long.]
View 9 Replies View RelatedMaking A Roster
Mar 30, 2007I have been asked to make a formula that sums up the hours in a week and then tells me whether I am below or over the budgeted hours for that week!
I cant get it to work since I cant figure out how to have the same formula in all the cell that sums up early, mid and late shifts, ie 06-14, 14-22, 22-06.
The graveyard shift is a problem there since I get negative hours.
Further more, I need to have the formula ignore cells to be added up if it has letters in it, we write an R for Rostered day off.
Existing Templates Monthly Class Attendance?
Sep 2, 2010I would like to have a workbook with class lists for 21 classrooms.
Then I would like to use this each month to generate a workbook that has one sheet per class with the teacher name and class name as an overall header. The row stubs would be the student names. The 2 column headers would be the weekdays (Mon through Fri) and the day of the month as a number.
It seems that this could very well be an application that already exists. It seems like the kind of thing a business would create and put on the web as a free download as a good will thing.
Does such an application already exist? If not, is there a small example of populating a workbook with information in another workbook?
Macro Definitions - File Name Changes From Master Templates
Apr 10, 2014I am currently working on a performance document. I am working on the principle of having a master template which people can then access, Save As, and use to monitor performance around KPI's.
The issue I am having is around the name of the document changing when it is saved as, as all records have to retained. The macro I am struggling with is designed to unlock the workbook & worksheet, copy the worksheet specified into a new workbook and then return to the workbook the macro is held within and lock it back up. However, when the name changes it just locks the new workbook rather that the version I am asking it to.
ActiveWorkbook.Unprotect Password:="KPIreview"
ActiveSheet.Unprotect Password:="KPIreview"
Sheets("EID Graphs").Select
Sheets("EID Graphs").Copy
[Code] ....
Is there anyway I can change the “Kent – Monthly Activity & Performance Review – Version 17 – Master.xlsm” statement within the macro to reflect the change in name of the document?
Code To Create/modify/save Templates..
Dec 11, 2009I have quite a few Excel templates that need to be modified by changing/adding information or sheets to them. Instead of working through the lot manually, it would be good if I could do the same through code. With my little knowledge I can do this for workbooks. Need to typical code snippets or suggestions? e.g. to open a template file, save it with the original name, etc. The usual Dim srcWB as workbook, Set srcWB= ABC.xls and Workbooks(ABC.xls). open do not seem to work with template files (ABC.xlt)
View 5 Replies View RelatedInvoice Templates To Copy The Names And Addresses From Them To Another Worksheet
Nov 19, 2009I'm trying to figure out a way to get my invoice templates to copy the names and addresses from them to another worksheet to form a customer database if you will.
View 14 Replies View RelatedSumproduct- Database That Shows Repeated Templates Down The Page
Feb 26, 2007I have a database that shows repeated templates down the page...ex.
"Site" (here) Remnant
Jan
Feb
Mar
"Site"(here) Remnant
Jan
Feb
Mar
All after another using the same template.
I am trying to sum all the occurances that fit the criteria Jan and Remnant:
I have this:
=SUMPRODUCT(--('"STATIONS"'!$A$4:$A$300='"GROUP"'!$A3)*('"STATIONS"'!C$3:R$3='"GROUP"'!C$2),'"STATIONS"'!$A$4:R$300)
But I get a N/A , my reference A3 matches the dates in the database and C2 matches the repeated occurances of Remnant...
Is this possible since my templates keep repeating down my database?
Basically, each template in the database is related to different stations, and I am trying to sum all the stations details in the database for each month and Header"Remant"
Formula For Costing Roster
Aug 6, 2008Been trying to come up with a formula that I can use in cells to cost a roster.
What I want to be able to do is just input start times into cells and the hours worked is automatically costed out in another cell. The trouble I have been having is that different start times attract a shift allowance eg. before 05:00 you get a 20% loading for the whole shift, between 07:00 and 19:00 is 10% and any finishing time after 19:00 is 15%, don't know how to write the formula to do this.
To Set Up A Web Query That Gets The Player Roster
Mar 13, 2007I'm trying to set up a web query that gets the Player Roster from Indians.com and one column is giving me trouble.
On the web site, this column is the player's height, listed as, for example, 6-2.
When the web query import is complete, this column displays a date instead of the height.... so 6-2 comes in as 2-June.
How do I massage this column to display the height and not a date?
Rotate The Names In The Roster
May 28, 2007Need excel formula (not a marco) to rotate the names in the roster.
View 2 Replies View RelatedExcel 2003 :: Templates For Personal Bank Account Management
Dec 10, 2013I really need a comprehensive excel file which can manage my bank account id, savings, transactions, withdrawals, transfers etc etc. could be better if it can show any graphical interface with charts as well. I am willing to have a file so that i can manage more than one bank accounts. ( Excel 2003 is my version)
View 3 Replies View RelatedExcel 2010 :: Add Files / Templates To Customize Scroll Bars?
Feb 15, 2012How does one add files/templates to excel2010 to customize scroll bars, graphic-like or clip-art type?
View 1 Replies View RelatedEmployee Shift Roster Template
Nov 19, 2008Any non-commercial roster template that would suit 7 day/24 hour/4 person shifts?
Currently we use a totally manual spreadsheet which looks like a Rubik's Cube and does not offer any form of automation in order to speed up entry adn ensure no doubling-up or missing shifts.
Calculating Total Number Of Hrs In A Roster
Jan 2, 2007I am working on this for two days , but I got stuck on the last step. I have a roster for about 35 employees. Calculating the daily hrs was not a problem. But I am doing the roster for one week. And I want employee wise total of hrs worked. I am quite confused as the "sum" formula works for some totals and for others it does not, although all the cells are in the right format. I tried to change the "result" cell to "number" and multiply by 24 to get the hr total as a number, but it does not work.
for example "SUMIF(E1:E57,"rafik",H1:H57)" ( this is the formula for calculating hrs for "rafik" on monday. the result cell is in "hh:mm" format and gives me the right total.
Likewise upto sunday the totals are right. What I want to do is calculate the total number of hrs from mon to sun. This seems to be impossible. the formula =SUM(H60:AL60) in a dd:mm format does not work, even =SUM(H60:AL60)*24 in a "number format" does not work.
I have tried "excel help" , tried to change the format but nothing works. The result should be 52 hrs and I cant get it no matter what I do.
Rotational Roster For Groups Of People
Jun 10, 2009I manage an emergency response team which consists of around 50 people, made of 5 different teams and these folks need to take part in emergency exercise to keep their skills up. I'm currently building a training/exercise/ roster database in Excel and would like to add a function that tells me who in each team is due to take part in the next exercise. For info: In the actual workbook, I have names defined on the team members and using vlookup to populate the roster via a drop down list.
To explain the attached example; once the person who is at the top of the list (Name1) has done their exercise, they move to the bottom of the list. Then over time, as the others also take part in execises, Name1 is eventually is back at the top of the list the and it is their turn again (this is quite often known as a Squash Ladder, here in the UK). Is there a way I can vba this process via a button or even better (!) by a drop down list?
Random Assignment To Work Roster
Jan 28, 2008i was asked to make a fair rota and i found this 1 on this website its useful but i need to add to it. if you download this work rota you will understand what i mean
http://www.ozgrid.com/forum/attachme...0&d=1154640274. i need to find out what the formula/macro is used in this work rota ...its exactly what i need but i need to add saturday and sunday to this rota and more duty columns as their is more employees and when i click the button it randomply places employees in different positions.
How To Know Available Seats Left For Contact Center Roster
Feb 5, 2014I would like to know that if i have seat count available according to floor and weekly off are planned according to team, also seat allocations is given floor wise, however i want to know how many seats are available on each floor or any given day.
I have attached excel sheet : Seat Allocation.xlsx
FIFO Roster Calendar Identifying Same Days Off
May 10, 2014Make an interactive calendar in excel. I would like to have 3 sheets. One were I can enter the names and corresponding reoccurring roster, that would be days on days off, a second sheet that does all the calcs etc and returns days of which all or most of the people are going to have off at the same time, so we can organise things in advance and maybe a third sheet that shows an actual graphical display of this information like a traditional calendar.
View 2 Replies View RelatedTime Format - Add Hours In Total At The End Of Roster
Mar 26, 2013When I enter L into B3 I want B3 to show a message.
i.e. B3 is blank, I enter L into B3, it the changes L to 0645 - 1515.
And it needs to be in time format so at the end of the roster i can add how many hours in total.
Finding Duplicates And Highlight Enteries In A Roster
Sep 4, 2008I have a roster for a large group in excel and would like to have an easy way to highlight if there are duplicate entries in the roster as we are merging multiple smaller lists together.
View 9 Replies View RelatedWork Rota/Roster Calculating Hours
Aug 11, 2004I am currently trying to create a rota / rosta for work which will show people what hours they are required to work, in a format similar to below:
NAME | SAT | SUN | MON | TUE |etc >
Person A| 8:00 - 17:00 | 13:00 - 22:00 | OFF | 8:00 - 13:00|
Person B| OFF | 17:00 - 22:00 | 8:00 - 17:00| OFF |
This is simple enough to create but I also need Excel to calculate how many hours each person is working in a week and the total number of hours used per day and per week. I found out that I can do this using a formula to work out hours and minutes between two times. However what I would also like Excel to do is deduct the unpaid breaks which the person is entitled to, however this depends on the times that they work, i.e. in the example above Person A would be entitled to a 1 hour unpaid lunch on Saturday, a half hour unpaid tea on Sunday and no unpaid break on Tuesday. Therefore 1 hour would be deducted off the Saturday total hours, 30 minutes would be deducted from the Sunday total hours and nothing taken off the Tuesday.
Holiday Pay
Nov 16, 2008I need a formula to compute holiday pay. I am having problems when there are two holidays during the month and the hire date of the employee is after the first holiday. For instance in November, November 11 and November 26 are holidays. If the employee is hired before November 11, he gets paid for the two holidays. If he is hired after November 11, he only gets the second holiday.
A B C 1 HOLIDAYS 2 HIRE DATE RATE/ 11-Nov-09 3 HOUR 26-Nov-09 4 5 10/15/2009 60.00 6 11/16/2009 60.00 7 11/28/2009 60.00 8
Come Up With Automated Excel Table That Can Be Used To Create Car Park Roster?
Feb 7, 2014I am trying to comeup with an automated excel table that can be used to create a carpark roster.
The carpark has 6 slots for whch I need to roster 9 staff on a weekly rotating basis. This needs to be done in an equitable manner. For example, at the end of a certain period of time, all staff memebers should have had equal chance and on the other hand we shouldnt have instance where a staff member goes two consecutive weeks without a car slot.
how i can optimally use excel to acheve the same?
Generating A Repeating List Of Names From An Ever Changing Roster.
May 2, 2006I have a workbook where Sheet 1 Col A is a list of dates. Sheet 2 Col A is a relatively short list of constantly changing names. I need to put this list of names in a repeating fashion in Sheet 1 Col B. Ideally I would like for Sheet 1 to regenerate Col B each time the roster list is changed.
View 5 Replies View RelatedHoliday Pay Calculation
Jan 17, 2007I have a problem with a cell displaying the correct number of days.
We work a 38 hour week and therefore each day is 7.6hrs
I have a start date and current date and calculate the number of days employed. I know that each day employed is worth 24 minutes, so over the year it calculates to 20 days per annum.
as I have not entered all the hours taken off yet, my current holiday entitlement is 767:04 (hh:mm).
when I process this on the calculator it tells me I have nearly 101 days holiday due, but I can not get excel to display XX:XX:XX (DD:HH:MM)
What would like to know is how many days that equates to using the 7.6 hour days
Staff Holiday Analysis?
Dec 17, 2012My boss wants me to take the holiday info from SAGE for 80 employees and create a record on excel. He wants to know what holidays each employee has taken and is due to take throughout the year. As each employee works a different amount of hours and a different shift pattern, SAGE records their holiday entitlement in hours rather than days. I have attached an example of one employees details and if come up with an excel document containing similar information for 80 individuals - all starting on different dates and all having a different amount of holiday entitlement. He wants to be able to look at each employees record for the year and see not only holiday data but sick days too. I don't know where to start with this - I've thought about creating a workbook with 80 pages and create a 12 month calendar for each individual with days off marked on it?
View 4 Replies View Related