TUM's Pie Calculator!

Read and comment on our tutorials and user guides here.

Moderator: Support Moderators

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

TUM's Pie Calculator!

Postby The United Mankind » Mon 19 Jan, 2009 22:25

Hi guys, I was in a battle a few days ago and had to calculate out everyone's profits etc. I put together a wee spreadsheet to do the calculations and thought, wouldn't it be nice to have a calculator like this on offer on the forums? So I spent the past 4 days making it pretty (Well maybe ^^), hiding the background calculations and testing it.

Well here is the finished product, TUM's Pie Calculator 1.0.

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

=Using it=
Simple to use, all you need to do is enter the players name, their fleet lost and the total debris generated. You can add pillage and trade route pillage if they are applicable. The spreadsheet then calculates the amount of debris each member should get and allows you to copy and paste it out easily. It calculates how much each member gets in two ways so you can choose which your team would prefer,

Equal Profit - Each member gets their fleet loses back then an equal share of whats left regardless of how much fleet they used.
By fleet - Each member gets their fleet loses back and the % of the profit to the value of how much fleet they lost.


=Updates=
Pass any errors or problems you find here and I'll try to get them fixed. I've tested it as best I can but you know some things always slip through. Also I am open to feature requests for later versions :)

Thanks, and hope you find it useful. :D
Last edited by The United Mankind on Sat 18 Apr, 2009 16:39, edited 2 times in total.

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
Fibrizio Catadelli
Silver Member
Silver Member
Posts: 710
Joined: Sun 29 Apr, 2007 19:36
Reputation: 17
Guild: [NECRO] Necromongers
Location: Joensuu, Finland
Contact:

Re: TUM's Pie Calculator!

Postby Fibrizio Catadelli » Mon 19 Jan, 2009 22:33

:clap: well done mate... i think i've seen this once ;)

Image
User avatar
aSp
Volunteer
Volunteer
Posts: 961
Joined: Wed 10 Jan, 2007 17:33
Reputation: 1
Galaxy: Beta
Location: England
Contact:

Re: TUM's Pie Calculator!

Postby aSp » Mon 19 Jan, 2009 22:33

The only flaw I notice is that it will only accept that one player pillaged the base and plundered trades. It's possible that different players would plunder trades, possibly several players, maybe make a trade plunder column?

Image
User avatar
taxie
Bronze Member
Bronze Member
Posts: 139
Joined: Thu 07 Dec, 2006 10:46
Reputation: 6
Contact:

Re: TUM's Pie Calculator!

Postby taxie » Mon 19 Jan, 2009 22:34

maybe add a row with debri/ trades already taken to make it easy to calculate what share people are allowed to collect.

Never agrue with an idiot, they'll pull you down to their level and beat you on experience.

Nathan wrote: Alpha > P&W is POLITICS AND WAR??!!! I always thought it was Alpha > Pissing & Whining
User avatar
The United Mankind
Volunteer
Volunteer
Posts: 742
Joined: Tue 19 Sep, 2006 20:45
Reputation: 21
Guild: III
Galaxy: Alpha
Contact:

Re: TUM's Pie Calculator!

Postby The United Mankind » Mon 19 Jan, 2009 22:35

aSp wrote:The only flaw I notice is that it will only accept that one player pillaged the base and plundered trades. It's possible that different players would plunder trades, possibly several players, maybe make a trade plunder column?


Interesting, yes that might well be in V1.2 :wink:

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
The United Mankind
Volunteer
Volunteer
Posts: 742
Joined: Tue 19 Sep, 2006 20:45
Reputation: 21
Guild: III
Galaxy: Alpha
Contact:

Re: TUM's Pie Calculator!

Postby The United Mankind » Mon 19 Jan, 2009 22:36

taxie wrote:maybe add a row with debri/ trades already taken to make it easy to calculate what share people are allowed to collect.


I'm not sure what you mean ^^

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
Pegar
Bronze Member
Bronze Member
Posts: 171
Joined: Mon 29 Jan, 2007 19:56
Reputation: 0

Re: TUM's Pie Calculator!

Postby Pegar » Mon 19 Jan, 2009 22:38

awesome!

Can you also make it automatically boot your jerk guildmate who takes too much derb, then attack his recyclers?

Pegar wrote:I eat pieces of sh*t like you for dinner
User avatar
Shadowcast
Bronze Member
Bronze Member
Posts: 100
Joined: Fri 02 May, 2008 13:21
Reputation: 1
Guild: ~13~
Galaxy: Beta

Re: TUM's Pie Calculator!

Postby Shadowcast » Mon 19 Jan, 2009 22:38

i disagree aSpy

trades are easy enough just to deduct from someone's share as they're usually nice round numbers ;)

as far as the calculator goes, mad props :clap: :dance: :D

Lightswitch Master of Snayke
Image
User avatar
The United Mankind
Volunteer
Volunteer
Posts: 742
Joined: Tue 19 Sep, 2006 20:45
Reputation: 21
Guild: III
Galaxy: Alpha
Contact:

Re: TUM's Pie Calculator!

Postby The United Mankind » Mon 19 Jan, 2009 22:41

Pegar wrote:awesome!

Can you also make it automatically boot your jerk guildmate who takes too much derb, then attack his recyclers?


I could but I think that would violate ToS :paranoid:

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
taxie
Bronze Member
Bronze Member
Posts: 139
Joined: Thu 07 Dec, 2006 10:46
Reputation: 6
Contact:

Re: TUM's Pie Calculator!

Postby taxie » Mon 19 Jan, 2009 22:45

The United Mankind wrote:
taxie wrote:maybe add a row with debri/ trades already taken to make it easy to calculate what share people are allowed to collect.


I'm not sure what you mean ^^


Next to "by fleet looses" you add two more. I called collected debri and one Debri left to collect. That way you can see in one look how much debri every one has left to collect.

Never agrue with an idiot, they'll pull you down to their level and beat you on experience.

Nathan wrote: Alpha > P&W is POLITICS AND WAR??!!! I always thought it was Alpha > Pissing & Whining
User avatar
burYMore11
Bronze Member
Bronze Member
Posts: 107
Joined: Tue 10 Jul, 2007 23:44
Reputation: 0
Location: Canada
Contact:

Re: TUM's Pie Calculator!

Postby burYMore11 » Mon 19 Jan, 2009 23:12

The United Mankind wrote:Hi guys, I was in a battle a few days ago


Good times. Nice TUM, good work ^^

Pew Pew Bang Bang
User avatar
aSp
Volunteer
Volunteer
Posts: 961
Joined: Wed 10 Jan, 2007 17:33
Reputation: 1
Galaxy: Beta
Location: England
Contact:

Re: TUM's Pie Calculator!

Postby aSp » Mon 19 Jan, 2009 23:43

Shadowcast wrote:i disagree aSpy

trades are easy enough just to deduct from someone's share as they're usually nice round numbers ;)


It's not as simple as deducting the value of the trade from that player, the additional amount of debris has to be assigned over all the players :)

Image
User avatar
Ikari
Retired Moderator
Retired Moderator
Posts: 4010
Joined: Tue 20 Nov, 2007 19:32
Reputation: 2
Guild: NERV
Location: Tokyo 3
Contact:

Re: TUM's Pie Calculator!

Postby Ikari » Tue 20 Jan, 2009 00:27

Moved to Tutorials & Guides

striker
Platinum Member
Platinum Member
Posts: 3124
Joined: Tue 15 May, 2007 03:57
Reputation: 9
Galaxy: Alpha
Location: Canada

Re: TUM's Pie Calculator!

Postby striker » Tue 20 Jan, 2009 04:23

id like to use it, but when I open it up, it just goes to microsoft excel and I cant enter in anything :(

Ask for the broom with the funny name!
User avatar
The United Mankind
Volunteer
Volunteer
Posts: 742
Joined: Tue 19 Sep, 2006 20:45
Reputation: 21
Guild: III
Galaxy: Alpha
Contact:

Re: TUM's Pie Calculator!

Postby The United Mankind » Tue 20 Jan, 2009 14:30

striker wrote:id like to use it, but when I open it up, it just goes to microsoft excel and I cant enter in anything :(


If you download Open Office you can use it. It looks ugly as all hell but it works.

TUM's Astro Guide
- An Astro Guide

TUM's Pie Calculator
- A handy spreadsheet which calculates everyone's share after a joint attack

Return to “Tutorials & Guides”

Who is online

Users browsing this forum: No registered users and 3 guests