Excel or similar program need help

waspie · 01-01-2015 9:51pm #1

Hi looking for some one / student in cork area to create a spread sheet for small jobs done over 1to2 days to be able to make a job card for jobs then feed in to a weekly summary sheet. So I have a sheet for every job and a weekly summary sheet. If this could feed into a montly sheet brill. So basically I have a sheet for every job/a weekly summary sheet/monthly sheet/yearly summary.
Have asked people but don't know if can be done on excel. Anyone help what program suggest anyone in cork area do this type of work.

bluferbl · 03-01-2015 1:09pm

What kind of information do you need to enter on the 'job card'?

waspie · 03-01-2015 2:05pm

Hi.
What I want is a spread sheet for each job we do, which will consist of about eight headings, where labour ie. Foreman, tech, app, hours are entered. Then materials used and quantity are enter. Unit cost of materials, sheet then summarise each column and gives overall total for job.
This sheet then feeds into a weekly summary sheet. If this can then feed into a monthly sheet brill.
I have a kind of prototype which I can show you.

tech · 03-01-2015 4:20pm

id be interested in something similar

bluferbl · 03-01-2015 5:39pm

Just sent you a PM re your prototype.

Amirani · 03-01-2015 8:08pm

Best using a database solution based on your description I reckon. Should be something an IT student could put together for you easily enough. Obviously if you're looking for something more professional then someone qualified could build this in a couple of hours.

You could do it in Excel, but you'd be limiting your functionality.

Excel or similar program need help

Comments