Hi I need some help with setting up an accrual spreasheet to keep track of staff holidays, can someone help me with the formula? i need the formula to calculate the holiday from the start date of the employee to the current date. Any Ideas?
I guess you mean vacation accrual. It's hard to help you here, without knowing the exact accrual formula.
However here are some tips:
Set up a column with the start date for each employee and use the today() function to get today's date.
You can use the days360() funtion to calculate the number of days between two dates, assuming regular 30 days/month.
For more date related functions, click on the Fx (letter f with an subscript x) to the left of the value/formula entry field at the top of the spreadsheet. Thsi gives you a wizard with a list of functions. Select the Data/Time group and you see all available functions and can interactively pull them together.
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
Yes, additional track is available from several places, such as Hobbylinc.com, and TowerHobbies.com. At this time, just after Christmas, they are out of stock, however. Walthers.com has them in stock (1-4-2011). You can find extra track on sale on eBay, as well. Be sure to get the track with the brass covers, as New Bright sells battery powered trains that use bare plastic track, which will not work with the 384. A Google search will turn up more sources.
This is too complicated for a help site like this, you are going to want to consult an excel forum, or some excel professional in your area. This is far beyond the scope of what you can expect for $15, which I'm sure you now realize after 10 days of trying.
Not sure what instructions you need, but the setup is very simple.
1. Put your track together
2. Attach the track power connector by slipping it under the track and pushing, then lift up the other side. This will make the two metal contacts connect to the track.
3. Plug the connector from the power pack into the track module (It should only go one way)
4. Plug the control box (looks like a telephone cord) into the track module, Will only go one way
5. Place the locomotive on the track.
6. Place the Treetop Tender on the track (you need both to make it run)
7. Connect the large connector from the treetop tender to the loco
8. Turn on the command module and press forward ...
I had a similar problem with my 11000 Holiday Tradition Express. I cleaned the track with an eraser (pencil-type) and then used a soft cloth to clean any possible residue. After doing this twice, my train is now running.
This train set is very particular and getting it to work each Christmas is a family tradition in frustration. First you must make sure that all the pieces of track are connected properly and that the track is perfectly symmetrical and flat. We double-check the battery positions every year and find one in wrong. There are + and - signs, but they're hard to see; use a flashlight. There is a black toggle switch below and behind the red stack that toggles forward (to make the train go forward) and backwards (reverse); straight out perpendicular to the train is the "stop" position. Also, you have to start at a stop/switch station. One other note: behind the red stack, there is a smaller black stack. If you turn this, you can make smoke come out of the stack. I think I remember someone suggesting a drop of cooking oil. Hope this helps!!! Hope you get it set up for Christmas!!!
Here is one way to do it: 1. In column A enter the name 2. In column B enter their start date in the format day-month-2008 (31-12-2008 for Dec. 31, 2008); if a day is less than 10, put zero in front (03, 04, etc.) 3. In column C put 31-12-2008 (December 31, 2008, the last day of the year) 4. In column D, put C1-B1 and format as a number with 2 places after the period (10.25 for example) if you want to track partial days, other format for no zeroes after the period (13) 5. In column E, put this formula: (D2/30)*1.25 (assuming this is line 2) You can then copy these lines as many times as you need to, total them, etc.
go to the field with the number of day formula and modify the formula just add to it this *8. The result will be in hrs.
Assuming a holiday uses 8 hrs of pay. It sounds like everyone starts with 25 holiday X 8 hrs or 200 total hours,