Track your SIGNATURE CAMPAIGN EARNINGS with this EXCEL sheet.

[MICRO]

Can u guys see how my post count and earning is going along ?
http://1drv.ms/1odWlJo

[sed]

Can u guys see how my post count and earning is going along ?
http://1drv.ms/1odWlJo

What?  Is this like a bump for your thread about your sheet?  I'm confused by this message.

[MICRO]

Can u guys see how my post count and earning is going along ?
http://1drv.ms/1odWlJo

What?  Is this like a bump for your thread about your sheet?  I'm confused by this message.

No just want to know opinions on my post count so far and graphs stats and so on.

[skottiejay]

It seems to work alright for me, I changed it up a little bit to account for USD, however I wish the final post count for the day would just automatically update with how many posts I input. Also it's kind of a hassle to manually just inject each post I post. Maybe I'm doing it the wrong way but I have zero knowledge of Excel.

[MICRO]

It seems to work alright for me, I changed it up a little bit to account for USD, however I wish the final post count for the day would just automatically update with how many posts I input. Also it's kind of a hassle to manually just inject each post I post. Maybe I'm doing it the wrong way but I have zero knowledge of Excel.

U should only put final post count at each day end. For example its 0:00 am here atm and i put final post count i have for today , its 1446, that is all input u need to give each day and it will do the rest for u.

When u put final post count for that day it will auto update everything. U only should change all red boxes once, and then 1 green box each day. Dont edit any other green box except the one for current day , u can imput post count for that day mulitple times but i usually do it when i am finished that day at 00:00 or earlier if i got to bed earlier.

Here u can take a look http://1drv.ms/1odWlJo . When i put in 1446 it auto changed everything , and put that post count for all days till the end in case i dont make any post on some days. So when i start again i just fill in post count for that day i started again.

[skottiejay]

Oh ok, then I probably am doing it wrong. Thanks for the info, I didn't know if I was or not and I manually was putting in all of the posts I'd made in a single day. I had to recount everything a number of times just to see if I was doing it right. Thanks for the info though, I guess I should brush up on my excel. How did you get the graphs to work? That's probably my favorite part, and I was gonna do something similar for another project involving words and twitter, how did you get that equation or macro to work?

[devthedev]

Oh ok, then I probably am doing it wrong. Thanks for the info, I didn't know if I was or not and I manually was putting in all of the posts I'd made in a single day. I had to recount everything a number of times just to see if I was doing it right. Thanks for the info though, I guess I should brush up on my excel. How did you get the graphs to work? That's probably my favorite part, and I was gonna do something similar for another project involving words and twitter, how did you get that equation or macro to work?

Oh crap, I was doing the same thing...

[Acidyo]

Nice sheet Micro, thanks.

[MICRO]

Oh ok, then I probably am doing it wrong. Thanks for the info, I didn't know if I was or not and I manually was putting in all of the posts I'd made in a single day. I had to recount everything a number of times just to see if I was doing it right. Thanks for the info though, I guess I should brush up on my excel. How did you get the graphs to work? That's probably my favorite part, and I was gonna do something similar for another project involving words and twitter, how did you get that equation or macro to work?

There is no macro. Graphs use data from the sheet its rly simple . Maybe i can explain it to u. U make ur sheet , and i will help u out on making a graphs for it.

I suggest for next month start with downloading a cleen copy of my sheet, and only fill in red boxes . And then only 1 green each day . U just need to go to ur profile read total post count and fill it in green box for that day. And u wont mess up any formulas. If u change content of cell with formula it wont update coz u delete formula that way.

[MICRO]

Oh ok, then I probably am doing it wrong. Thanks for the info, I didn't know if I was or not and I manually was putting in all of the posts I'd made in a single day. I had to recount everything a number of times just to see if I was doing it right. Thanks for the info though, I guess I should brush up on my excel. How did you get the graphs to work? That's probably my favorite part, and I was gonna do something similar for another project involving words and twitter, how did you get that equation or macro to work?

Oh crap, I was doing the same thing...

If instructions are not clear enough i will try to explain better.
Sheet is made that way so u do minimal work. U only put ur total post count at the end of each day in that cell and it will do the rest for u.

U dont need to calculate anything just copy post count from ur profile and put it in that day. U can change that cell multiple times per day with ur post count and it will update everything. BUT DONT EDIT ANY OTHER CELL . Dont edit some cell for next day or day after u will mess up formula.

[skottiejay]

Yeah I royally messed up my sheet now, and I'm probably going to have to start over and redo it, but I'll figure something out once I get there. Thanks for the info, I really appreciate having something like this around so I know when I get paid from FXO that I'll be getting X amount.

[Swordsoffreedom]

Thanks for sharing Micro personally I keep a track on the Blockchain and keep an estimate of where I want to go
But it has a limit range of 125 in this campaign so its a bit easier
Primedice has a larger limit becuase its monthly so I can see why it would be convinient to have

[skottiejay]

Yeah I'm going to have to start tracking it per week, which will be a pain but I'd imagine that all I'd have to do is put a fresh sheet and what not. At least it's handy to know whether or not I'm just crap posting and what I'm earning. Thank you for this macro I really appreciate it, if I had any BTC to tip you with I'd do it.

[MICRO]

Yeah I'm going to have to start tracking it per week, which will be a pain but I'd imagine that all I'd have to do is put a fresh sheet and what not. At least it's handy to know whether or not I'm just crap posting and what I'm earning. Thank you for this macro I really appreciate it, if I had any BTC to tip you with I'd do it.

Its rly simple to use and hard to mess up when u follow instructions. And will make ur life much easier.

Only thing u need to do is copy ur post count from ur profile and fill it in each day that is all .

If u guys need some modified versions for weekly payout or need some extra info on that sheet just say so i will try to make it happen .

Btw tips are not for me, they are for people that lost everything in floods, i already donated almost my whole wallet balance. Its rly terrible what happened and it will take years to recover from it. But we are strong nation we can do it .
Tnx for support.

[skottiejay]

Haha yeah, I'm pretty good at messing things like this up, like I said I have little to zero experience with Excel, especially when it comes to formulas and what not. I'm gonna have to look into how to make graphs and what not and formulas so I can do this tweet thing I've been talking about doing.

Anyways thanks again for the sheet MICRO (spelled your nick wrong last time sorry haha) I really appreciate being able to keep track of what I'm doing!

[MICRO]

Haha yeah, I'm pretty good at messing things like this up, like I said I have little to zero experience with Excel, especially when it comes to formulas and what not. I'm gonna have to look into how to make graphs and what not and formulas so I can do this tweet thing I've been talking about doing.

Anyways thanks again for the sheet MICRO (spelled your nick wrong last time sorry haha) I really appreciate being able to keep track of what I'm doing!

For tutorials go to youtube , u will find plenty of good tutorials on excel.
Also i suggest office 2010  or 2007 not 2013

[skottiejay]

Yeah even the Microsoft website is kind of confusing to navigate, and I know more about 2010 than 2013, it seems the revamped interface is a tad more confusing to me than what I'm used to. Anyways now that I know to go about the right way of doing this I can actually keep better track without manually tracking each post.

[Rigon]

Thanks Micro for this sheet, will Def Use it for my campaign.   I think I might do a few edits on it to customize it for my fitting but is close to perfect.

[jeffersonairplane]

Yeah I royally messed up my sheet now, and I'm probably going to have to start over and redo it, but I'll figure something out once I get there. Thanks for the info, I really appreciate having something like this around so I know when I get paid from FXO that I'll be getting X amount.

This kinda was my point. I previously posted it is kinda difficult.

[skottiejay]

difficult because of the weekly basis? yeah it probably is, but still it's kind of nice to know how much i'm posting on a day to day basis, the sig campaign is earning me a little dough that i need to restart my life so that's always a plus since there's no way now i can mine worth a damn.