excell help

[Retro-Man]

I am trying to create a worksheet that will simplify the creation of WOC'S (Weekly Operating Controls).

I have set up all the basic formula's but now want to save it as a more idiot proof file.
aims are
1. lock all data cells that require no input, the only cells requireing editing are yellow

2. hide the excell grid to make it more easily visible

3. if poss I want to set the sheet to open with as little excell toolbars available as is possible

basically I just want to clean it up to make it less scary to non pc people.

cheers peeps
Retro
____________________
https://domharnessphotography.webs.com

[veeeffarr]

Can't help you with the locking and hiding toolbars, as I'm using Gnumeric.

Does this work for you?

[veeeffarr]

Sorted out point number 1 for you

[Retro-Man]

cheer's

excellent work
____________________
https://domharnessphotography.webs.com

[veeeffarr]

Regarding hiding the toolbars,

I really wouldn't bother, you'll just piss people off that want to use them, and you might have to code to remove them anyway.

[Retro-Man]

ok I'l bow to you experience on toolbars

cheers
Retro
____________________
https://domharnessphotography.webs.com

[veeeffarr]

This anymore readable? Brain has gone to sleep now so I'm not very constructive.

[Retro-Man]

fook me silly
if thats you braindead you are one clever guy


lots of thanks to Toby r and Dav/\/\

____________________
https://domharnessphotography.webs.com

[veeeffarr]

What does "Expenses Mtd" mean?

If you explain some of the stuff you need to me I can organise the data more effectively, you have things placed randomly which will cause confusion in itself

I don't understand Labour Costs... Is this how much it's costing you to work on things?

[Retro-Man]

expenses are based on a monthly budget worked out annually

expenses mtd is expense month to date

labour cost is wages relating to salarys an techy bonus which are affected by labour sales

expenses are effectivly the cost of opening the front doors whilst all other costs are cost of sale so are inproportion to sold units
____________________
https://domharnessphotography.webs.com

[djr]

Not sure whether it's just me but in the spreadsheets Toby has posted I am still able to modify the cells that contain formulae e.t.c

Unfortunately the version of the spreadsheet I have modified now weighs in at over 1 meg in size so I have uploaded it to my own site and you can download it here - right click and save target as please.

You should get asked for a password if you try an edit any of the non-yellow cells although I'm not sure whether this will work for toby in open office but be interesting to find out.

I have removed most of the empty cells from the spread sheet and the grid lines have been removed.

Hope that helps.

[Retro-Man]

labour cost is also forecast in budget so for example might be set at 22k for month hence formula divides this by days in month x days gone.
____________________
https://domharnessphotography.webs.com

[veeeffarr]

[Retro-Man]

virtual pints to both the lads for a top effort

Thanks


ps my 1st bike was a cg125 as well, rock solid
____________________
https://domharnessphotography.webs.com

[djr]

[veeeffarr]

I've got one too...

Just spent 3 hours cleaning it, and now it's raining :S

I'm waiting for tax man to drop a cheque in my lap then I'm doing my DAS and getting something with fairing!

[djr]

Sorry Retro for assisting in taking your thread offtopic here, hope you don't mind too much.

Toby, have you decided what bike you're getting yet?

[veeeffarr]

[Retro-Man]

toby I'm liking your layout, any chance of locking the formula cells like dav ^^'s version

please


____________________
https://domharnessphotography.webs.com

[djr]

I'll do it for you but it may take a while... just had a look and I can't remember what I did last night, should be sorted in next couple of hours. .

[djr]

Right, have updated Toby's excel spreadsheet to require a password if editing the non yellow squares.

You can find it here.

Hope that helps, time to do some work now .

[ashley_46]

Dav did you just select the cells he wanted protecting and go into the format cell options to that or is there another way i don't know about.

[djr]

[Retro-Man]

well this is what I ended up with which is a damn good job, thanks fella's

even added anothe formula for forcast month end profit

all goals reached

it looks clean
it's idiot proof ( no one can fook about with any cells except red ones)
tabbing between data input cells woks a treat


and above all my superior is looking at using it across all our service depts (over 40)

WELL DONE
____________________
https://domharnessphotography.webs.com

[djr]