Excel - anyone familiar with it?

HarryM1BYT · 28th November 2011, 09:41

I need a very simple spreadsheet, to compare my 4/5 timesheets per month against my paid salary over 40 months.

Column for date; basic hours; overtime hours; expenses - all totaled aloong the bottom for the month, with another line below it to enter the paid salary for the month. One complete section per salary month for 40 months, followed by a total showing any discrepancies at the end please.

HarryM1BYT · 28th November 2011, 15:03

Bump.....

I have now got myself part of this done, I have done one month incorporating the calculations for that months figures alone. I just need to add the other 39 months and try to incorporate a running total for all of the months.

Help anyone got any experience of Excell please???

The whole idea is to check claimed on timesheet figures against my actual paid salary, to see if anything has not been properly paid.

uk_dave&gill · 28th November 2011, 16:10

Harry

If you've done some groundwork on this and got the layout, I might be able to do the calculations you need

Can you send what you have so far to me?

Also, how soon do you need it?

HarryM1BYT · 28th November 2011, 16:35

Quote:

Originally Posted by uk_dave&gill

Harry

If you've done some groundwork on this and got the layout, I might be able to do the calculations you need

Can you send what you have so far to me?

Also, how soon do you need it?

Yesterday would be good Dave

I'll need an email address to send it to PM sent.

FredSpencer · 28th November 2011, 17:12

Harry,

I've emailed you from here about one spreadsheet I've done but can't add an attachment so will need you to reply to my email before I can send it.

uk_dave&gill · 28th November 2011, 17:25

Harry, let me know if Fred's is of use as soon as you get it (if it does what you want, then no need for me to duplicate the work! If it doesn't, I'll try to sort something for you!)

28th November 2011, 09:41	#1
HarryM1BYT This is my second home 75 Contemporary SE Mk II 2004 Man. Sal. CDTi 135ps, FBH on red diesel, WinCE6 DD Join Date: May 2010 Location: Leeds Posts: 17,273 Thanks: 2,160 Thanked 2,061 Times in 1,586 Posts	Excel - anyone familiar with it? I need a very simple spreadsheet, to compare my 4/5 timesheets per month against my paid salary over 40 months. Column for date; basic hours; overtime hours; expenses - all totaled aloong the bottom for the month, with another line below it to enter the paid salary for the month. One complete section per salary month for 40 months, followed by a total showing any discrepancies at the end please. __________________ Harry How To's and items I offer for free, or just to cover the cost of my expenses... http://www.the75andztclub.co.uk/foru...40#post1764540 Fix a poor handbrake; DIY ABS diagnostic unit; Loan of the spanner needed to change the CDT belts; free OBD diagnostics +MAF; Correct Bosch MAF cheap; DVB-T install in an ex-hi-line system; DD install with a HK amp; FBH servicing. I've taken a vow of poverty. To annoy me, send money.

28th November 2011, 15:03	#2
HarryM1BYT This is my second home 75 Contemporary SE Mk II 2004 Man. Sal. CDTi 135ps, FBH on red diesel, WinCE6 DD Join Date: May 2010 Location: Leeds Posts: 17,273 Thanks: 2,160 Thanked 2,061 Times in 1,586 Posts	Bump..... I have now got myself part of this done, I have done one month incorporating the calculations for that months figures alone. I just need to add the other 39 months and try to incorporate a running total for all of the months. Help anyone got any experience of Excell please??? The whole idea is to check claimed on timesheet figures against my actual paid salary, to see if anything has not been properly paid. __________________ Harry How To's and items I offer for free, or just to cover the cost of my expenses... http://www.the75andztclub.co.uk/foru...40#post1764540 Fix a poor handbrake; DIY ABS diagnostic unit; Loan of the spanner needed to change the CDT belts; free OBD diagnostics +MAF; Correct Bosch MAF cheap; DVB-T install in an ex-hi-line system; DD install with a HK amp; FBH servicing. I've taken a vow of poverty. To annoy me, send money.

28th November 2011, 16:10	#3
uk_dave&gill This is my second home .. Join Date: Feb 2007 Location: Town Posts: 4,166 Thanks: 1 Thanked 189 Times in 105 Posts	Harry If you've done some groundwork on this and got the layout, I might be able to do the calculations you need Can you send what you have so far to me? Also, how soon do you need it? __________________ Dave

28th November 2011, 17:25	#6
uk_dave&gill This is my second home .. Join Date: Feb 2007 Location: Town Posts: 4,166 Thanks: 1 Thanked 189 Times in 105 Posts	Harry, let me know if Fred's is of use as soon as you get it (if it does what you want, then no need for me to duplicate the work! If it doesn't, I'll try to sort something for you!) __________________ Dave

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Very Familiar MG ZT 190 in Le Mans Green!	MGStephen	Was it you?	6	20th June 2013 10:44
You know when you someone looks familiar	uk_dave&gill	Social Forum	12	29th October 2011 14:34
Excel 2007 vs Excel 2003 - Dilemma	uk_dave&gill	Technology Forum	11	10th April 2009 17:20
Sounds Familiar?	bobthethird	The 75 and ZT Owners Club General Forum	1	21st December 2008 07:49
Excel spreadsheet maybe?	Raistlin	Technology Forum	8	11th October 2008 19:25

28th November 2011, 17:12	#5
FredSpencer Passed Away Typhoon ZT 190+ Saloon Join Date: Aug 2009 Location: Leeds Posts: 6,833 Thanks: 0 Thanked 18 Times in 10 Posts	Harry, I've emailed you from here about one spreadsheet I've done but can't add an attachment so will need you to reply to my email before I can send it.