Help in setting up new spreadsheet
Help in setting up new spreadsheet
(OP)
Hi all.
I am hoping to find some help here on how to set up my spreadsheets to pull data from several sheets and compile it in a new sheet based on job numbers...
I currently have about four guys working under me and their time is kept on a spreadsheet...However, all the time is divided between several jobs each day and some of the jobs are quoted and some are time and material...I need to find a way to pull this data out based on job numbers and compile it on a single spreadsheet.All the time for my time and material jobs needs to be on one sheets and all the time for the different quotes need to go to an indvidual sheets based on which quote it is...
Any help would be aprreciated...
I am hoping to find some help here on how to set up my spreadsheets to pull data from several sheets and compile it in a new sheet based on job numbers...
I currently have about four guys working under me and their time is kept on a spreadsheet...However, all the time is divided between several jobs each day and some of the jobs are quoted and some are time and material...I need to find a way to pull this data out based on job numbers and compile it on a single spreadsheet.All the time for my time and material jobs needs to be on one sheets and all the time for the different quotes need to go to an indvidual sheets based on which quote it is...
Any help would be aprreciated...





RE: Help in setting up new spreadsheet
1. There are a number of ready made timesheet solutions for Excel. A quick google will find several free ones as well as some paid ones. For example http://
2. Microsoft give several examples. A quick search on Office Online found for example:
http://o
3. You could do a proper problem analysis which will probably lead you to a properly written database app. or a ready made timesheet program
Remember that using a spreadsheet as a database is like using a hammer to drive woodscrews - it's possible to do, but there is a proper tool for the job!
Good Luck
johnwm
________________________________________________________
To get the best from these forums read FAQ731-376: Eng-Tips.com Forum Policies before posting
Steam Engine enthusiasts
Steam Engine Prints
RE: Help in setting up new spreadsheet
Do yourself a favour, spend the $300 and buy Quickbooks Pro.
It's the best thing we ever did.
tg
RE: Help in setting up new spreadsheet
I agree with the posted comments.
The easiest thing is to either get some free software and/or buy some software over the Internet.
You can also develop some MS Excel spreadsheet type applications. I would suggest to get the data in a single spreadsheet and then use Data -- Subtotal feature.
Also, you could use SQL as another way of sorting out the data and generating reports.
Good luck!
Thanks,
G. Feric, PE
http://engware.i-dentity.com
RE: Help in setting up new spreadsheet
It is a web-based spreadsheet that multiple people can edit at the same time. This way you can keep all the data on one spreadsheet - all you need is internet access with a browser. You can also import/export MS Excel spreadsheets to/from Google Docs.
-ok
BridgeArt.net ~ Structural Wiki ~ AEC Software Database
RE: Help in setting up new spreadsheet
Google Spreadsheets is not a wise choice because of the sensitivity of the data; it's unlikely that other employees should see each others' time sheets, let alone Google.