Bounty / Signature Campaign Estimator

[legendster]

So I started working on this sheet a couple weeks ago when I was pitching to various new ICO's for managing their campaigns on Bitcointalk. It turns out its not the easiest thing to convey because there are so many numbers involved.

So I came up with this sheet which I was only able to complete today, as I was away from internet for around a week. If you're a Signature / Bounty manager I am sure you already have a paid tool / calculator like this. So for all the noobs like me who can't afford a paid tool, can feel free to use this.

The point of this post is however not to just give away a valuable tool to my competition. But rather ask for suggestions on how to improve this and refine everything to the point where it can be deployed as an interactive calculator on the web. That way, not only the managers, but the ICO developers can themselves use this, for free, to estimate their campaign budgets.

PS : I have protected the entire sheet except for the values under the MODIFIERS section.

_Link

Also let me know if this sheet is utterly useless lol

~update~

I have a list of 120+ exchanges that support token listing. With links to their google application form / support contact and guidelines where available.
Its nothing that you can't get by researching yourself. But it would be a time saver. If you need it, please PM me. I'll charge only $150 in EQUAL tokens.
$EQL

[1714888886]

1714888886

[1714888886]

1714888886

[1714888886]

1714888886

[RivAngE]

That's a very nice design btw ! 
I won't need such a tool but I got interested in the excel itself. I make complicated excel formulas for my every-day job so this cought my eye. Simple formulas, but seems effective, nice job!

[legendster]

That's a very nice design btw ! 
I won't need such a tool but I got interested in the excel itself. I make complicated excel formulas for my every-day job so this cought my eye. Simple formulas, but seems effective, nice job!

Feel free to deploy a local copy and see if you can improve anything. And let me know. I am sure it'll make life easier for SOMEONE out there. Thanks for the appreciation.

[legendster]

I have a list of 120+ exchanges that support token listing. With links to their google application form / support contact and guidelines where available.
Its nothing that you can't get by researching yourself. But it would be a time saver. If you need it, please PM me. I'll charge only $150 in EQUAL tokens.
$EQL

[Diced90]

Nice tool you have dev legendster but I see a field like Reserve { Row 30} is this one necessary for bounty allocation or you have another one without this entry?

Oh and dev does this come with a bot to count posts for the sig campaign to avoid crediting stakes to users that didn't make the cut 

[legendster]

Nice tool you have dev legendster but I see a field like Reserve { Row 30} is this one necessary for bounty allocation or you have another one without this entry?

Not exactly. When the stakes and tokens get divided up there maybe 200 / 100 / 50 excess tokens sent out per week. Reserve is especially dedicated to count for these unforseen extra expenses.
In some campaigns these extra left over tokens can be termed as 'Performance bonus' distributed amongst really strong participants.

Oh and dev does this come with a bot to count posts for the sig campaign to avoid crediting stakes to users that didn't make the cut  

No but that would be combined a google form / google sheet project where participants would just fill in the form and the sheet would be updated with the links. Not a fool proof solution. Could implemented in a much better way in a website rather than using google sheet / forms.

[legendster]

I have a list of 120+ exchanges that support token listing. With links to their google application form / support contact and guidelines where available.
Its nothing that you can't get by researching yourself. But it would be a time saver. If you need it, please PM me. I'll charge only $150 in EQUAL tokens.
$EQL

Bump