Help in setting up new spreadsheet

[drizzt19]

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...

 

[johnwm]

There are a few alternatives.

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://www.vertex42.com/ExcelTemplates/free-timesheet-template.html

2. Microsoft give several examples. A quick search on Office Online found for example:

http://office.microsoft.com/en-us/excel/HA011133131033.aspx?pid=CL100570551033

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 before posting
Steam Engine enthusiasts
Steam Engine Prints

 

[trainguy]

drizzt19,

Do yourself a favour, spend the $300 and buy Quickbooks Pro.

It's the best thing we ever did.

tg

 

[Feric]

Hi there:

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

 

[bridgeart]

To drizzt19: if you want to keep using spreadsheet, I would recommend trying out Google Docs Spreadsheet (

http://docs.google.com

).

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

 

[francesca]

You are wanting to use a spreadsheet for a database application. Instead of entering their time sheet in a spreadsheet, you should have them enter it in a database form, which writes to a table, and set up reports to give you the output you require.

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.