Pages:
Author

Topic: Track your SIGNATURE CAMPAIGN EARNINGS with this EXCEL sheet. - page 3. (Read 3852 times)

legendary
Activity: 2464
Merit: 1037
CEO @ Stake.com and Primedice.com
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.
full member
Activity: 140
Merit: 110
bitcoinnaire
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.
legendary
Activity: 2464
Merit: 1037
CEO @ Stake.com and Primedice.com
Can u guys see how my post count and earning is going along ? Smiley
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.
sed
hero member
Activity: 532
Merit: 500
Can u guys see how my post count and earning is going along ? Smiley
http://1drv.ms/1odWlJo

What?  Is this like a bump for your thread about your sheet?  I'm confused by this message.
legendary
Activity: 2464
Merit: 1037
CEO @ Stake.com and Primedice.com
Can u guys see how my post count and earning is going along ? Smiley
http://1drv.ms/1odWlJo
legendary
Activity: 2464
Merit: 1037
CEO @ Stake.com and Primedice.com
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 .
full member
Activity: 140
Merit: 110
bitcoinnaire
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??
legendary
Activity: 2464
Merit: 1037
CEO @ Stake.com and Primedice.com
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?


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


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.
legendary
Activity: 2464
Merit: 1037
CEO @ Stake.com and Primedice.com
Wow, this is really awesome. Big thanks for you (Although I'm not from the primedice campaign, haha).

U can change first part to fit ur sig . So on the end u have all u need there dor collecting.
legendary
Activity: 2464
Merit: 1037
CEO @ Stake.com and Primedice.com
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)

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.
hero member
Activity: 574
Merit: 500
Wow, this is really awesome. Big thanks for you (Although I'm not from the primedice campaign, haha).
legendary
Activity: 3766
Merit: 1742
Join the world-leading crypto sportsbook NOW!
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)
hero member
Activity: 546
Merit: 500
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?


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
legendary
Activity: 2464
Merit: 1037
CEO @ Stake.com and Primedice.com
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.
311
full member
Activity: 230
Merit: 100
Come original.
Spreadsheet looks great but whos is that adress? Is it official?
sed
hero member
Activity: 532
Merit: 500
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.

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.

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

you are right, i was being off topic and assholeish, i'm going to constrain myself for now on. 
b!z
legendary
Activity: 1582
Merit: 1010
Cool spreadsheet. I don't need it myself, but thanks for sharing it.
full member
Activity: 224
Merit: 100
VocalPlatform.com
Nice work OP, i just changed mine to my local currency and it works perfectly, will donate some as fast as i get paid  Wink
full member
Activity: 140
Merit: 110
bitcoinnaire
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.
hero member
Activity: 742
Merit: 502
Circa 2010
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?

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.
Pages:
Jump to: