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.
TUM's Collection Time Calculator
Moderator: Support Moderators
- The United Mankind
- Volunteer
- Posts: 742
- Joined: Tue 19 Sep, 2006 20:45
- Guild: III
- Galaxy: Alpha
TUM's Collection Time Calculator
TUM's Astro Guide
- An Astro Guide
TUM's Pie Calculator
- A handy spreadsheet which calculates everyone's share after a joint attack
- An Astro Guide
TUM's Pie Calculator
- A handy spreadsheet which calculates everyone's share after a joint attack
Re: TUM's Collection Time Calculator
... There are people who can't calculate that in their head?
I despair.
I despair.
Honour thy tool, and keep it rigid.
Re: TUM's Collection Time Calculator
ceiling($AMT_DEBRIS / ($AMT_RCS * 10))
Eternity is wasted upon the likes of you.
Re: TUM's Collection Time Calculator
/+1 rep.
If it helps anyone then it is a good thing.
I say thank-you for taking the trouble.
If it helps anyone then it is a good thing.
I say thank-you for taking the trouble.
Ich bin ein Schlachtenbummler
- HiGloss
- Suspended User
- Posts: 146
- Joined: Thu 09 Jul, 2009 04:38
- Guild: [MOB]
- Galaxy: Gamma
- Location: Charlotte, NC
- Contact:
Re: TUM's Collection Time Calculator
Thank you! +rep
MEN OF ILL REPUTE HAVE CRATED PROBLEMS OF DIABOLICAL PROPORTIONS
Who is online
Users browsing this forum: No registered users and 1 guest