Todays rubbish job £18.12 per hour

[escapeUK]

Shudder indeed.

Shudder my ass.

So client wants a spreadsheet showing all their live orders, and then broke down by which are on which production line. They want graphs showing capacity on each production line so they can spot over resource levels into the future.

It must be a spreadsheet as various departments want to sort it , colour it in, and enter additional info to assist them with their job.

What is your proposed solution, that is shudder free?

[BoredBloke]

No, but the point I was making doing a bit of vba, excel and powerpoint and creating a few databases wasnt that taxing and if it was a permie job that wages wouldnt have been that unreasonable.

But you have already said that your client has Access databases around that nobody knows what they do and are development dead ends. How does that reconcile with VBA being a £100 a day skill set.

You still have not said what you use to write your magic spreadsheets

[EternalOptimist]

But you have already said that your client has Access databases around that nobody knows what they do and are development dead ends. How does that reconcile with VBA being a £100 a day skill set.

You still have not said what you use to write your magic spreadsheets

wasting your time BB
i like the idea that you can put 'if' in front of something then answer a totally different question, and then talk cr@p for the rest of the thread.
you have the patience of a saint BB.

[BoredBloke]

Shudder my ass.

So client wants a spreadsheet showing all their live orders, and then broke down by which are on which production line. They want graphs showing capacity on each production line so they can spot over resource levels into the future.

It must be a spreadsheet as various departments want to sort it , colour it in, and enter additional info to assist them with their job.

What is your proposed solution, that is shudder free?

A multi user database that each one can use to filter and run their own report. In exactly the same way you populate a spreadsheet so would I. I just use standard tools that are easy to maintain (because VBA is such a common skill set) using tools that are readily available.

Presumably all you do is create a connection to the data, throw a bit of SQL at it to grab the data and push it into Excel and format it in Excel using the Excel Object model (VBA).