TUM's Collection Time Calculator

Read and comment on our tutorials and user guides here.

Moderator: Support Moderators

User avatar
The United Mankind
Posts: 742
Joined: Tue 19 Sep, 2006 20:45
Reputation: 21
Guild: III
Galaxy: Alpha

TUM's Collection Time Calculator

Postby The United Mankind » Sat 18 Apr, 2009 16:51

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]

=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. :)

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 Astro Guide
- An Astro Guide

TUM's Pie Calculator
- A handy spreadsheet which calculates everyone's share after a joint attack
User avatar
Platinum Member
Platinum Member
Posts: 2955
Joined: Sun 27 May, 2007 18:18
Reputation: 137
Guild: BSMF
Galaxy: Ceti

Re: TUM's Collection Time Calculator

Postby Rezo » Sat 18 Apr, 2009 16:59

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

I despair.

Honour thy tool, and keep it rigid.
User avatar
Gold Member
Gold Member
Posts: 1483
Joined: Tue 16 Oct, 2007 18:59
Reputation: 37
Guild: Min
Galaxy: Alpha

Re: TUM's Collection Time Calculator

Postby Alucard » Sat 18 Apr, 2009 18:03

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

Eternity is wasted upon the likes of you.
User avatar
Bronze Member
Bronze Member
Posts: 367
Joined: Sun 18 Nov, 2007 23:02
Reputation: 12

Re: TUM's Collection Time Calculator

Postby Unclean » Mon 04 May, 2009 20:01

/+1 rep.

If it helps anyone then it is a good thing.

I say thank-you for taking the trouble.

Ich bin ein Schlachtenbummler
User avatar
Suspended User
Suspended User
Posts: 146
Joined: Thu 09 Jul, 2009 04:38
Reputation: 0
Guild: [MOB]
Galaxy: Gamma
Location: Charlotte, NC

Re: TUM's Collection Time Calculator

Postby HiGloss » Tue 25 Aug, 2009 09:30

Thank you! +rep


Return to “Tutorials & Guides”

Who is online

Users browsing this forum: No registered users and 2 guests