Bitcoin Forum

Hey guys i am in Primedice sig campaign and it crossed my mind that would be nice to have good day to day stats of how much u posted , how much u earned and something that calculates ur final post count that u need to send to claim payment. Also with some charts of earnings :) .

So i made this: http://1drv.ms/1odWlJo (http://1drv.ms/1odWlJo)

That is read only exel file on OneDrive. And how it should look like when u start filling it in . You can see there are loads of stats and useful information , and some charts.
All u need to do is to fill red cells once and one green each day with ur final post count .

But u have detailed instructions on the template sheet which u can download here:
 http://1drv.ms/1odVUyR (http://1drv.ms/1odVUyR) (click file -> save as -> download a copy )

Or download it from here: http://www.filedropper.com/signature (http://www.filedropper.com/signature)

*Note: Its for office 2007 and newer if u need version for office 2003 post comment and i will post link.

This excel sheet is free for everybody, but if u guys heard about terrible floods in Serbia (where i am from) , and u like this and want to continue using it pls donate something, to people who lost everything, and dont have enough food and water, so any help is welcomed.

Paypal on this site: http://floodrelief.gov.rs/ (http://floodrelief.gov.rs/) (its official Serbian gov site)
Or Bitcoin to: 1HELPrsqi6vt7BgN2X6K8xGMRDZPTb96iT (https://blockchain.info/address/1HELPrsqi6vt7BgN2X6K8xGMRDZPTb96iT)

Here is the SS of how it looks like when u start filling it in:
https://i.imgur.com/CpoHQ68.png

Wow, this is a beautiful spreadsheet and it works fantastic.

Thanks!

EDIT: How hard is it to add USD values?
Posted from Bitcointa.lk - #Ccn0D1LXJKDoKvVP

Not hard at all .
Just change cell S8 to usd value. And date and time are optional for ur reference.
Optional:
And select all cells with din. after the number then right click-> format cells -> tab "number" -> menu item "currency" , and there u will find $ in list.

edit: All other instructions u have on first sheet.

Well done MICRO

I'm going to make the modifications for USD and upload it here for the US users.

Thanks MICRO
Posted from Bitcointa.lk - #hfRCmdg5wLC5yCEC

Tnx, and everybody feel free to post suggestions of what else info u would like to see on that sheet and i will update.

If u run into any problems tell me i will do it and upload that to .

Only mine filled in version is for din. "signature" not filled in version is already made for USD .

Will do
Posted from Bitcointa.lk - #grLy2AGIvh9zhSDn

i really appreciate your work thanks for your contribution

Np, my man, i had some free time and thinking that it might be useful to some people .
Also trying to get some donations for people here, im not to much affected, but many people lost houses , and everything.

Just created one for myself :) using google Docs :)  as I don't go offline much..! Nice Idea.. thanks

I guess I'm trolling just a little bit here: EXCEL? , Microsoft?  Groooooss.

Can't folks just use GNU/Linux and write some python code?

Ok, but I admit, it looks like you did a good job based on the screenshot, but I'll never know for myself because gross.

Yeah u can copy everything from mine, i did not protect formulas so u can see whats going on.
And mine is online to on onedrive , so i can access, edit it from my pc and phone.

Well , opinions are diferent. I love and use windows 8.1 and windows phone 8.1 . And all microsoft services. I have that excel file synced with my pc and phone.

Ok i admit, i maybe coulda made it like app. But why would i ? Excel is made for this stuff and works perfectly.

Cool I'll check this out because I find it a pain to keep subtracting from my total.

Really helpful excel sheet, tnx MICRO. Is there a way to make btc price synchronization so we can see current price and dont make changes everyday?

Ah... I dont think that is posible. I will try to work that out somehow. Im working on preev api so i will see if i can implement that. Till then u will need to change rate manually . But u can set refereamce rate and no need to change every day.

And one more can you add dropdown menu for other currenties so we can change fast. I like to see how much I earn in € and $

Hm... That is quite a good idea. When i get some free time i will make that. Tnx for suggestion.

"works perfectly" assuming that someone else pwning your computer is part of your definition of perfect.  i can never run a computer that i'm not root on.  and i can never install an OS if i can't see source code.  i'm not so trusting.  ok, i'll stop trolling you now.  good job on your excel sheet.

Np, man i respect everybody opinion. I never used linux so i cant comment on it. I love windows and i use it.

This is not a topic about linux vs windows. I use excel anade it in excel if u think there is need for linux version, u make it. U have all the formulas u need on my sheet , they are not locked.

Works!  Thanks a lot, it's so annoying actually trying to track your posts (constructive ones) and monies, blah blah blah.
So thank you for that, hopefully you can add more currency conversions soon?  CAD?

I just had a chance to thoroughly look through the sheet, it's even more awesome than I thought it would be.
I'll shoot you a tip after this month's payment period is over. (Don't have much in my hot wallet right now)

I'm going to be honest when I say this is over complicated and pointless. You don't need to track posts with this detail with the whole "post goal" and such. I mean, tracking how many constructive posts is probably the most you would ever do. Not many people would use this for what it is cut out to be. Would be more work filling things in more than anything, even though it's almost all calculated for you.

If you change the currency value in the box on the right and you change the formatting options you can easily change the currency into CAD or USD or whatever you like.

Thanks for this, with this spreadsheet I realized that I probably didn't make as many constructive posts as I should have, haha.

I still don't know if I have the USD values right, it seems a little high but oh well thanks for this. It's actually a really handy thing to have.

Nice work OP, i just changed mine to my local currency and it works perfectly, will donate some as fast as i get paid  ;)

Cool spreadsheet. I don't need it myself, but thanks for sharing it.

you are right, i was being off topic and assholeish, i'm going to constrain myself for now on. 

Spreadsheet looks great but whos is that adress? Is it official?

Paypal on that .gov.rs site is gov official . Bitcoin addres is not. Its mine.
If u send money there u need to trust me thatvi will forward it to red cross in fiat. Coz when i aksed them to create btc , ltc and doge wallets for donations they said they cant do that, coz of paperwork. So... I made it and will send them everything in fiat.

I made modified version with price synchronisation (USD) on every startup of excel. Price is taken from bitstamp - last price.
You must allow macros to run.
Link: https://www.dropbox.com/s/zi4c90sh1sdakrg/SIGNATURE.xlsm

Donations is appreciated: 1PdHRDrRxBsohPRJMxTa5cVLNriEbJUhdP

Awesome work, thanks for sharing it with the community. Just a question: how can i exclude past days from the avg posts calculation/day, if for example i've started a sig campaign not in the first day of the month? (for pd the 17th)

Wow, this is really awesome. Big thanks for you (Although I'm not from the primedice campaign, haha).

Just edit the date column , on first cell add ur starting date. And then click on small box on the bottom right corner of that cell and drag it down to the bottom . It will auto fill in all the dates for u.

U can change first part to fit ur sig . So on the end u have all u need there dor collecting.

Yes macros are one way to do it. But not safe at all.
I would not trust it on my pc.

Im not saying u would do any harm. Just fair warning.

I screwed up my post count, how exactly do you get a post per day, do you just go through your posts in your profile per day? Somewhere I screwed up and ended up with a higher amount than I expected. How do you get your post count per day??

Dayly post count goal is : Total amount of post that u need to reach ur btc goal u set / the number of days u have to post.

U can download new un changed copy and seecthe formula there .

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.

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.

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...

Nice sheet Micro, thanks. :)

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.

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.

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.

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

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.

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

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.

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.

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

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.

When i get some free time i will do one for weekly payouts , to suit different campaigns .

You should sell it for a small fee. Or campaigns that start using it should give you a tip for setting it up. :)

Its free, and tips go to people who needs it after the floods. U have addy upthere ^ .
I hope u guys enjoy it :) . And hope some of u would rly send something , even like 1$ or something to that addy or paypal to helpout. Its rly bad around here some people dont have what to eat or drink , our county doesnt give enough.

Hello,
Nice job doing that!
One question:
Can you change the currency and how to do that?
I will enjoy using this excel table.
BR
Thanks!

Tnx.

U have in first couple of posts explained how to change currency its rly easy . If u have any further questions feel free to ask.

Very well done, thanks! :)

Im glad u guys like it . If u would love anything to change /improve , i am open to any suggestions :)

Nice job micro! Even thought Stunna and other signature campaign offerers may get a bit pissed as they still repeat that they point is that you shouldn't take is as option to earning money but only as a bonus for posts that you would do anyway.

Yeah that is correct , but its nice that u can track ur post count, u know see on what day u was more active , see this nice graphs and well how much u earned while having fun on the forum. :) .

Yep i'm not saying it's not nice, you have actually done very good job! :)

Tnx , tomorrow i should finish up custom version for this weekly post limit , so u would need to put in ur post count like only at the end of each week and see if u did reach goal/post count cap and how far from it u are .

But again, rules will change probably on this 17th. So then i will again make custom one for post count tracking but we will probably get paid per rank, but this is also usable for other sig campaigns. So there will be more versions to suit everybody.

Yep PD rules change often lately, maybe Stunna should have solved it by limiting how many users can join not by this. Yep i'd like to see the weekly one as i'd like to use it for FXO one.

He needs to find perfect option for reducing spam, making users happy and not paying to much.
Last month he paid 28btc for campaign. That is huge amount of money.

Im not at my main pc atm as soon as i get home i will start working on weekly sheet .

That's why i think he should maybe have closed it for new users it's the main reason for that high payment.
The 400/month rule would be fine...okay i'll be monitoring this thread and try it out as soon as it gets here.

I have done a weekly sheet, for shorter signature campaign (like xbtec)

Features:
> Made with gdrive, so you can just download it, upload in your google account and access wherever you are with the last changes already updated
> No need of excel or other paid software
> Bitcoin price in € that is updating dynamically (a refresh should do the work)
> All the other features that MICRO sheet already has

http://bit.ly/1t1nEwX

Going to look into this, thank you!

Cool, i was having something other in mind, like full month in same sheet, but kinda separated stats per week and for full month. That way would evade starting and filling in new sheet every week. But urs is cool to.

Well i have some problem with these sheets even when i enter only red boxes it also fills the green ones and when i correct them it shows total nonsense for example that for 2 posts done i would earn 0.015 btc for that day and i've entered right price into these boxes i even triple checked.

With his or mine ? On mine sheet its supposed to will all the dates with ur starting post count then as u edit day by day it will fill rest with ur latest post count. So it calculates properly .

The alexrossis one showed mi nonsense i didn't try out the monthly one as i have weekly payment from this one.

Wow this is great... does it work with other sigs such as Updown? Thats the one I currently am using...

Try it and let us know please as i had some problems with it.

I will finish mine in like 4-6 hours and it will be posted here for download , i dont use gdocs thou but i think i can make that one also.

I downloaded it so that may be the problem but i don't think so. I don't use google docs myself.

Great job, suits good for PD campaign :)