I have 7 teams (82 staff in total) staff who work for several production line. we currently record all leave on the wall calender. I want start recording these on a spreadsheet and I wonder if any of you have already designed a annual leave planner that I could have a copy?
Staff can request for 1/2 annual leave as we all full day. Each Team is listed on a seperate sheet and if a team has more than 2 person on leave, it will go red.
Due to work, I need to creat the captioned file for our company.
View 2 Replies View RelatedI was created an annual leave planner and I would like the box in Colum A to reduce the number of days they have left every time they book leave. I would like it to start off as 25 days leave including UK bank holidays.
View 4 Replies View RelatedIs there any weekly leave planner that shows the dates of the mondays in the month? eg in Jan we have 4,11,18,2
View 3 Replies View RelatedI've put together an annual leave tracker for the department and am trying to make it as automated as possible. It currently consists of two sheets, 'Leave Applications' and 'Leave Tracker 13'.
If you look at the 'Leave Applications' sheet, I wish to be able to take this data to fill the calendar on 'Leave Tracker 13' with either AL or HL to demonstrate whether the day is annual leave or half day leave. This only wants to happen if the leave has been accepted, represented by an 'A' on the 'Leave Applications' sheet. The calendar obviously doesn't have any dates in the cells but I've got around this when it comes to shading in weekends by concatenating the date above and to the left of the cells and assume I must be able to do the same for populating it.
It's also complicated by the 'Leave Applications' consisting of multiple members of staff, though this may be ordered by date.
I am trying to create simple leave data base using Excel. Is it easy or complicated?
View 2 Replies View RelatedI need to create a leave tracker wherein i will get the names of the person who want to take leave in that particular month. I have prepared a calendar to make an entry. I need to take care of the following things
1) The person must have sufficient leave balance available to take the leave. so i have to first check if he/she has sufficient leave balance.
2) There are four team leaders and each team has around 13-14 members. so if lots of people from the same team apply for the leave then they will not be eligible for leave. this i want to know in percentage as to how much percentage of people are taking leave from that particular team.
I have a copy of a year planner that calculates the days of the month and adjusts them according to the year input into the header area.
Would anyone please modify it so that the first column reads August and the last column reads July (instead of Jan to Dec) and still maintain the calculations as required?
In the past the Manpower Company has put out a yearly spreadsheet allowing an employer to keep track of employee time off. They are not making one this year. Looking at last years sheet, all the calculations are locked. Has anyone seen this sheet in the past and know how it works? You can put in something like v8 in a dated cell and excel subtracts 8 hours from a yearly vacation total. The v in front of the 8 stands for vacation and you can also put in a p for personal time etc..
View 9 Replies View RelatedI have one workbook with two worksheets (Jan-JUly and Aug-Dec). I am using a userform to add data into worksheet ("Jan-July"). But I do not have any clue - How do I update the other worksheet (same data like name,join year etc)worksheet("Aug-Dec") at the same time. I used two worksheets because worksheet doesn't support 370 columns, and to make my life easy. UserForm add data into Column A to M (worksheets Jan-July), rest is done manually. I have also attached the file.
Private Sub dataAddButton_Click()
Dim dataCheck, eMsg As String
Dim strLastRow As Integer
Dim x As Double
strLastRow = xlLastRow("Jan-July")
'get Last Row
With dataInput
'dataInput name of userform
If (.fNameBox.Value <> vbNullString And .fNameBox.Value <> vbNullString And .joinYearBox.Value <> vbNullString) Then
'textbox validation value can not be empty......................
I love the set up of the "Monthly Meal Planner" template in Excel 2013 and would like to do something similar for another file I want to set up. How do I learn how to make those tabs across the top - "Meal Plan", "Ingredients" etc?
View 3 Replies View RelatedI wish to have a simple planner displaying the academic year with only mondays' dates.
ROW 3 displays the dates
Column B is Week 1
Cell B3 is the first date (10.08.09)
Cell C3 should read 17.08.09
Cell D3 should read 24.08.09
ETC
I have managed to do it using autofill before but I can't get it to do it now. Is there a preferred way to achieve this?
A1 is a date
I need B1 to show 1 year from A1, unless it has already passed, in which case I will need additional years added until the date being displayed is either today or in the future.
For example, if A1 is 1/1/2010, B1 should be 1/1/2015
I have daily streamflow data for a large number of years. One column is the date and the second column is the streamflow value. I want to compute the maximum value and the 3-day maximum (largest average value for any consecutive 3-day period)for each water year (starts on October 1 and ends on Sept 30). Of course the number of days each year varies by one during leap years.
View 5 Replies View RelatedThere are two tabs in my workbook right now. The first is where users will input information and annual budget number for consulting fees. The second tab spreads the annual budget by the 12 months. I don’t want the users to see or touch this tab containing the spread. Once the annual budget number is entered, I would like them to use a combobox to choice how they would like to spread the budget monthly. One choice is evenly which is the default and the other would be manually. If they choice manually I would like a userform or something where they than input each month’s amount that will total the annual budget. See attachment, this is all I got so far.
View 2 Replies View RelatedI'll try to be as concise yet informative as possible. In the included attachment you will find a list of names in column A. These names have each have an event that is due at the end of his/her month, once annually. The due month for each person is listed in column B. Once that person completes the event, it is recorded in column C. The event will then not be due until the following year by the end of their due month.
I need column D to reflect the last day of their due month.
This date will change once the event is completed and recorded in column C. There are of course a few additional requirements that puts this out of my ability. They are listed below:
The person may complete the event at any time within three months of their due month. So if Tom's due month is September, he may complete the event anytime in July, August, or September. This would then need to reset the "Due by" date (column D).
If the person does not complete the event, the original "due by" date should not change until the event is completed.
Last note: this attachment is from Excel for Mac, The actual sheet this will be used on will be windows (so no worries about the formula changes for Mac).
Recurring due date help.xlsx
I have list with 20000 rows, I need to count total annual issued qty. find attached sample for more details. I have solved. I used pivot table.
View 5 Replies View RelatedI am trying to calculate the compound annual growth and my starting point is a negative number. The example is that I have (273,000) for the YE 2003 and have Growth to the amount of +767,000 at YE 2006. The formula I have been using for other calculations where the starting point is positive is =POWER(J23/C23,1/O$1)-1. Where J23 = a positive amount and C23 = a positive number. This formula works fine, but when C23 = a negative number the formula does not work and the % does not make sense.
View 6 Replies View RelatedI'm doing an exercise for school and I'm totally confused here. I have to:
With the original assumptions, goal seek to determine what the Annual Rate Increase would be for the total expenses to be $175,000 (answer = 20.77%). Here's what I have: through the process?
I have the data as below. And to submit this to the third party is needs to be compressed (a total for each Full time ANNUAL salary).
RULES
All total monthly earnings must start from 0 when a "Full time ANNUAL Salary" is added or endedIf the Annual amount misses a month I need to assume the salary has ended
I hope this makes sense.
Below is test data for one person. And the result i am hoping to get with some comments.
Employee
Full time ANNUAL salary
Monthly earnings
Pay date from
Pay Date to
[Code]....
The result of the above would be:
Employee
Full time ANNUAL salary
Monthly earnings
Pay date from
Pay Date to
Comments
[Code]...
15k started 01/06/2013 so the total for the 10k starts again, alongside total for 15k
Chris
£15,000.00
£450.00
01/06/2013
31/08/2013
[Code]...
15k started 01/12/2013 so the total for the 10k starts again, alongside total for 15k
Chris
£15,000.00
£150.00
01/12/2013
31/12/2013
[Code]...
10k ended, 20k started 01/01/2014 so total for 15k starts again, alongside total for 20k
Chris
£20,000.00
£400.00
01/01/2014
28/02/2014
[Code]...
20k ended so total for 15k starts again
If I invested $350 per hectare into a project and at the end of 12 years that investment yielded me $150,000, what would my rate of return be over the life of the project?
View 9 Replies View RelatedI am trying to calculate APR (Annual Percentage Rate) for a mortgage loan that has a balloon feature. I have tried to the the RATE function but it only gives me the APR for a loan that is ammortized over 30 yrs and paid in 30 years. I need the APR for a loan that is ammortized for 30 years with a baloon in 5 years.
View 9 Replies View RelatedWhat would be the best way to put together a cancel curve on an annual membership model?
View 5 Replies View RelatedI have been trying to compile some monthly and annual data from our main sheet to a FY09 sheet (for the fiscal year 2009). The 2 tabs in the uploaded example are the Distribution tab which we use to track the status of every item and the FY09 tab where I need the totals to be calculated for each month as well as the entire year. I have tried several formulas I found while searching the forum but I can not seem to get any of them to work, (I am sure it is because I don't understand them very well).
Since any formulas used will need to be copied 200 or so times, I would really like a VB solution which should also reduce the physical size of the file. I also tried a pivot table but I do not think it will show everything I need.
Basically, I need all the items separated by month on the FY09 tab. Then column 'F' on the Distribution tab needs to be summed up for each item in column 'D' of the FY09 tab for the respective month and multiplied by the respective item price in column'C' with the total value going in column 'E'. Column 'D' and 'E' need to be summed up for each month and cumulative for the entire year. There needs to be an average items and value for each month as well as for the year.
I need to design a spreadsheet in Excel that keeps track of annual expenses for the company car, but have no numerical data.
The only information given is the labels needed to be used, such as main heading, date, mileage, petrol, maintenance, registration, insurance, subtotals, averages and main totals. I've designed the spreadsheet with date - subtotal at the top of each column, with total and averages on the left hand side, under all the months (so the answers to both the total and averages would be in each column)
I also need to write a formula to work out the averages of everything and the formula I thought would be right is giving me this error message: #DIV/0!
How can I get the median of a column that contains both hourly and annual rates? I would like to either multiply the hourly rate * 2080 or divide the annual rate by 2080 then get the median.
View 6 Replies View RelatedI am trying to figure a formula that will give me a monthly increase with a annual target. Example:
2006 sales were $100,000 and December 2006 sales were $9,000.
For 2007 I would like a 10% increase in sales which means I should end up with $110,000 at the end of 2007.
The formula should figure a gradual sales increase each month until December 2007. I am assuming the business sales trend is upward with no seasonality so that January 2007 should be the annualized increase over December 2006.
.
I have used the formula =100000*((1+.1)^(1/12)-1) which works for 2007, but it gives me a large jump between December 2006 and January 2007 and then a slight increases each month.
I have 200 items that have 22 months of usage information each and need to:
1. In one column, show trend (up or down) based on the 22 months' activity for each item.
2. In another column, show/ forecast how much inventory will be needed for the next 12 months.
What I need is a worksheet which will generate fields from a set of variables (similar to a loan amortization schedule).
I don't know how to write the field code to include the annual percentage rate increase based on that additional input variable.
Input variables would be:
starting rate: (ex: 8¢/kilowatt hour)
starting date: (ex: July 2013)
average kw hours/month: (ex: 1062.5 kw hours)
annual rate increase: (ex: 3% *default 0%)
years to display: (ex: 25 years, *shown in months in fields below)
service months per year: (ex: 12 *default 12)
[code].....
So, data fields below the variables would be blank until these are entered.
Assume I would protect the sheet to avoid messing it up.
this would generate a chart showing rates over time from the fields below.
Also it would generate fields in a summary area to show the rate per year for future years.
Secondary, if there were a way to input actual usage and rates from specific months in the past, that would be useful but not part of this forecast model.
The goal of this model is to forecast electrical costs for residential power users compared to independent solar power generation to 25 years forward.
I want to make this because I am skeptical of the advertised savings that solar installers use to convince clients that their return on investment is so high. I believe their data to be greatly inflated projections.
Using this in comparison with other data such as inflation and wages will allow me to get a very good economic picture of the future of independent solar energy generation and its impact on the average home owner.
I am trying to make a worksheet that will track the annual inspection dates for my equipment and basically change color when the inspections are comming due or are overdue. Im using conditional foramtting what would the formula be if i did an inspection on 6-sep-05 and i want excel to tell me when it is 5 days before the due date which would be 6-sep-06.
View 5 Replies View Related