Okay... a bash at a spreadsheet. I hope it's clear enough in its thinking, conjectural elements abounding here. Am putting up in the hope that by parading my ignorance, you all feel free to fill me in!
A few notes:
- Parameters up top, the printer cost is more for info really.
- The ink per sq ft is a guide I've come across a few times, can be changed and values will shift.
- The total printed ink presumes (of course incorrectly) that all the ink is used at equal levels and speed. But variances are beyond my time and computational willingness, unless someone has a sensible suggestion.
- I figured 20% for waste (can be changed). I didn't add a cost in for wasted paper, which would actually be a higher cost than ink.
- Paper costs etc. are my local prices.
- Again, I limited it to two basic sizes of output, the print area rather than the paper area.
- You can change the no of prints per type of size and paper
- The total Ink used gets a conditional highlight in Numbers but the Excel conversion kills it, it should be less than the Actual Printed Ink amount calculated in the Parameters area.
- I read a guideline of 6 months for trouble free ink, so number of prints per week and associated costs might be of interest.
- The cost of paper you would use per set is computed.
- I wondered about offering a printing service for friends/colleagues of their own work, and worked out the levels to cover a full set of cartridges over the course of six months. Might help.