Attendance register and invoice sheets

[Pauline]

Hiya. This spreadsheet sounds perfect but it won't let me open it. I have just joined the site yesterday. How long before I have privileges? Thank you x

It won't take you long Claire, just get joining in

More details here: http://childmindinghelp.co.uk/forum/...ad.php?t=38984

[Bridey]

I've only just seen this - it looks awesome!

I do before and afterschool care and have divided my fees into equal monthly payments to help the parents who claim tax credits - this spreadsheet will help me compare the monthly payments with the actual charges due so I can make sure we end the school year with a balanced account

[Pauline]

Pete has kindly sent the latest version, I have put it in the first post of this thread to replace the older version that was there.

Thanks Pete

[child_friendly]

I have had a look at this and it is great, but I can't seem to change the arrival and departure times on the attendance sheet, it asks for a password to unprotect it?? How do I change the times?

[Pauline]

I have had a look at this and it is great, but I can't seem to change the arrival and departure times on the attendance sheet, it asks for a password to unprotect it?? How do I change the times?

I will see if I can find out for you.

[sonia ann]

I have had a look at this and it is great, but I can't seem to change the arrival and departure times on the attendance sheet, it asks for a password to unprotect it?? How do I change the times?

you should be able to, I can ...............are you using the attendance sheet to change the times on, you must input data onto the attendance sheet not the invoice sheets. All information will be passed on from the attendance sheet

just had another look ..........you cannot delete the total hours on the attendance register ,you must delete the time of arrival and departure............the total hours is a function box that cannot be changed .

[catlyn]

when I click on the link it wont show me an excel document??? what am I doing wrong please????
Just opens a blank page with nothing on at all

[sonia ann]

when I click on the link it wont show me an excel document??? what am I doing wrong please????
Just opens a blank page with nothing on at all

have you got microsoft excel on your computer, if not you can download a viewer to be able to see the document

[catlyn]

yes sonia got excel on my computer I use it for my end of year accounts....its version 2007...when i click the link I get a message on the screen thats full of numbers and stuff when I take the message off theres just a blank page??

[Bridey]

I use OpenOffice to use my copy as I'm on a mac.

[catlyn]

this is the message I get when I click the link

[excel pete]

I have had a look at this and it is great, but I can't seem to change the arrival and departure times on the attendance sheet, it asks for a password to unprotect it? How do I change the times?

Hi all

A couple of you have had a problem opening this sheet.
It is saved as a 2007 excel document so you must have excel 2007 or newer on your pc.
just having the viewer given free from microsoft will not enable you to use the sheet as the viewer is incapable of carrying out the calculations. so I am told.
alternatively you can email me and I can send you a copy direct.
If you require a copy in excel2003 i can save you a copy but there may be a few probs to sort out.
My email: peter.mantell@tiscali.co.uk
Pete

[Pauline]

Hi all

A couple of you have had a problem opening this sheet.
It is saved as a 2007 excel document so you must have excel 2007 or newer on your pc.
just having the viewer given free from microsoft will not enable you to use the sheet as the viewer is incapable of carrying out the calculations. so I am told.
alternatively you can email me and I can send you a copy direct.
If you require a copy in excel2003 i can save you a copy but there may be a few probs to sort out.
My email: peter.mantell@tiscali.co.uk
Pete

That's really kind of you Pete

[catlyn]

thanks Pete...the e mailed version has opened up no problems x x Thank You

[Pauline]

New version sent by Pete which he hopes will sort out the problems

:

[lizduncan72]

love this!!! Will make my life soooooooo much easier, thank you

[sineadquinn]

I took this a little while ago and just used it :-) it has saved me so much time and looks great. Thank you :-)

[Little miss]

This looks great!

[Rubybubbles]

I use this all the time now and love it thanks again Pete

[susanrich]

A very kind gentleman called Pete has kindly shared an Excel document for creating attendance registers and invoice sheets.

Sheet 1 you put in the name address you want to see on the paperwork and it will place it on all the forms.
Sheet 2 is the attendance sheet name of the child time of arrival etc (times
need to be entered 24 hr style with the colon: in between the hours and
minutes for the auto calculations to take place.

Any feedback would be appreciated by Pete

You will need Excel on your computer for it to work.


Edit to add that Peter has updated the sheet to a newer version following your questions and comments.
EDIT 17/7/12 - another updated version!

Is there anyway of removing the little picture and putting my own in its place. Apart from that I think it is wonderful.
Now just need one for expensise.. ;-)