Nice work @artemcrystal I like the initiative you have taken with your spreadsheet
and this could be a good way to see all projects one has participated in and also help not to miss any current post requirements to programs and have a general idea of how much you likely to get.
1. Do not know which bounty campaign to join?
2. Do not know how to count stakes?
3. Do not know how to calculate your profits?
4. Do not have time to follow the good bounty campaigns?
how do you count stakes when ICO is ongoing and how do you know the profits when price after ico increases
I count stakes according to the formula. The information is taken from the already added stakes in the spreadsheet of campaign. There I select the average value of the earned stakes. And then I calculate everything by formula. (ERROR +- 20%)
The price is taken from the pre-ico campaign (icobench price etc). As a rule, they enter the market of idex, etherdelta with a price of ~ x1.1-x1.5, and then falls until the coin comes out on a good stock exchange.
Those campaigns that do not have spreadsheet with stakes or did not find the price pre-ico - I leave for later. But if there is a price, you can roughly calculate and without a spreadsheet. The error will be approximately +- 40-50%