TUM's Collection Time Calculator

[The United Mankind]

Hi guys, as part of my plans to update my Pie Calculator I was going to include this Collection Time Calculator. Unfortunately University has been a *beep* and the project just keeps getting pushed back further and further. Well I had already completed the Collection Time Calculator so I thought, what the hell I'll post it up as is.

It's effectively a little spreadsheet that tells you how long you should remain on the debris patch and with how many recyclers to get your share of the debris. More details explanation below ^^



[Designed to be used with MS Excel 97 and higher. Open Office can be used but it looks awful in Open Office]
DOWNLOAD TUMS COLLECTION TIME CALCULATOR

=Using It=
The calculator allows you to enter three things. The time of your first collection (ie, 19:30), the amount of debris (or your share of the debris) and how many recyclers you have. With this data the calculator works out how many hours you should be on the pile, how many recyclers you should have on it for the last hour and displays this as a graphic.

Simple to use, simple to read.

=Updates=
I am open to suggestions for updates to the calculator though there isn't much in the way of features that I could add. If you find any bugs please drop me a line. I've tested it as best I can but you know how these things are, something always seems to make it through ^^

Thanks, and hope you find it useful.

[Rezo]

... There are people who can't calculate that in their head?

I despair.

[Alucard]

ceiling($AMT_DEBRIS / ($AMT_RCS * 10))

[Unclean]

/+1 rep.

If it helps anyone then it is a good thing.

I say thank-you for taking the trouble.

[HiGloss]

Thank you! +rep