MICRO (OP)
Legendary
Offline
Activity: 2464
Merit: 1037
CEO @ Stake.com and Primedice.com
|
|
June 09, 2014, 04:07:15 PM |
|
Can u guys see how my post count and earning is going along ? http://1drv.ms/1odWlJo
|
|
|
|
sed
|
|
June 09, 2014, 06:21:52 PM |
|
What? Is this like a bump for your thread about your sheet? I'm confused by this message.
|
|
|
|
MICRO (OP)
Legendary
Offline
Activity: 2464
Merit: 1037
CEO @ Stake.com and Primedice.com
|
|
June 09, 2014, 06:32:42 PM |
|
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
Full Member
Offline
Activity: 140
Merit: 110
bitcoinnaire
|
|
June 09, 2014, 10:23:20 PM |
|
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.
|
What else could I say?
|
|
|
MICRO (OP)
Legendary
Offline
Activity: 2464
Merit: 1037
CEO @ Stake.com and Primedice.com
|
|
June 09, 2014, 10:32:00 PM |
|
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
Full Member
Offline
Activity: 140
Merit: 110
bitcoinnaire
|
|
June 09, 2014, 10:34:22 PM |
|
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?
|
What else could I say?
|
|
|
devthedev
Legendary
Offline
Activity: 1050
Merit: 1004
|
|
June 09, 2014, 10:36:26 PM |
|
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
|
|
June 09, 2014, 10:39:22 PM |
|
Nice sheet Micro, thanks.
|
|
|
|
MICRO (OP)
Legendary
Offline
Activity: 2464
Merit: 1037
CEO @ Stake.com and Primedice.com
|
|
June 09, 2014, 10:39:35 PM |
|
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 (OP)
Legendary
Offline
Activity: 2464
Merit: 1037
CEO @ Stake.com and Primedice.com
|
|
June 09, 2014, 10:42:40 PM |
|
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
Full Member
Offline
Activity: 140
Merit: 110
bitcoinnaire
|
|
June 09, 2014, 10:45:57 PM |
|
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.
|
What else could I say?
|
|
|
Swordsoffreedom
Legendary
Offline
Activity: 2926
Merit: 1115
Leading Crypto Sports Betting & Casino Platform
|
|
June 09, 2014, 10:49:00 PM |
|
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
|
..Stake.com.. | | | ▄████████████████████████████████████▄ ██ ▄▄▄▄▄▄▄▄▄▄ ▄▄▄▄▄▄▄▄▄▄ ██ ▄████▄ ██ ▀▀▀▀▀▀▀▀▀▀ ██████████ ▀▀▀▀▀▀▀▀▀▀ ██ ██████ ██ ██████████ ██ ██ ██████████ ██ ▀██▀ ██ ██ ██ ██████ ██ ██ ██ ██ ██ ██ ██████ ██ █████ ███ ██████ ██ ████▄ ██ ██ █████ ███ ████ ████ █████ ███ ████████ ██ ████ ████ ██████████ ████ ████ ████▀ ██ ██████████ ▄▄▄▄▄▄▄▄▄▄ ██████████ ██ ██ ▀▀▀▀▀▀▀▀▀▀ ██ ▀█████████▀ ▄████████████▄ ▀█████████▀ ▄▄▄▄▄▄▄▄▄▄▄▄███ ██ ██ ███▄▄▄▄▄▄▄▄▄▄▄▄ ██████████████████████████████████████████ | | | | | | ▄▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▄ █ ▄▀▄ █▀▀█▀▄▄ █ █▀█ █ ▐ ▐▌ █ ▄██▄ █ ▌ █ █ ▄██████▄ █ ▌ ▐▌ █ ██████████ █ ▐ █ █ ▐██████████▌ █ ▐ ▐▌ █ ▀▀██████▀▀ █ ▌ █ █ ▄▄▄██▄▄▄ █ ▌▐▌ █ █▐ █ █ █▐▐▌ █ █▐█ ▀▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▀█ | | | | | | ▄▄█████████▄▄ ▄██▀▀▀▀█████▀▀▀▀██▄ ▄█▀ ▐█▌ ▀█▄ ██ ▐█▌ ██ ████▄ ▄█████▄ ▄████ ████████▄███████████▄████████ ███▀ █████████████ ▀███ ██ ███████████ ██ ▀█▄ █████████ ▄█▀ ▀█▄ ▄██▀▀▀▀▀▀▀██▄ ▄▄▄█▀ ▀███████ ███████▀ ▀█████▄ ▄█████▀ ▀▀▀███▄▄▄███▀▀▀ | | | ..PLAY NOW.. |
|
|
|
skottiejay
Full Member
Offline
Activity: 140
Merit: 110
bitcoinnaire
|
|
June 09, 2014, 10:53:49 PM |
|
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.
|
What else could I say?
|
|
|
MICRO (OP)
Legendary
Offline
Activity: 2464
Merit: 1037
CEO @ Stake.com and Primedice.com
|
|
June 09, 2014, 11:02:56 PM |
|
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
Full Member
Offline
Activity: 140
Merit: 110
bitcoinnaire
|
|
June 09, 2014, 11:23:08 PM |
|
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!
|
What else could I say?
|
|
|
MICRO (OP)
Legendary
Offline
Activity: 2464
Merit: 1037
CEO @ Stake.com and Primedice.com
|
|
June 10, 2014, 10:44:25 AM |
|
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
Full Member
Offline
Activity: 140
Merit: 110
bitcoinnaire
|
|
June 10, 2014, 10:46:47 PM |
|
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.
|
What else could I say?
|
|
|
Rigon
|
|
June 10, 2014, 11:38:19 PM |
|
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
Legendary
Offline
Activity: 1522
Merit: 1000
www.bitkong.com
|
|
June 11, 2014, 12:00:01 AM |
|
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
Full Member
Offline
Activity: 140
Merit: 110
bitcoinnaire
|
|
June 11, 2014, 12:35:34 AM |
|
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.
|
What else could I say?
|
|
|
|