Spreadsheet: 173831d1344796257-average-last-14-entries-in-a-column-daily-revenue-share-rate-archive-bidify
Sheet: Sheet1

This sheet is where I post the daily reward I have earned on my startup costs as an affiliate at http://wepay.bidify.com. I calculate the daily percent manually and insert it in Column C.
For instance, on Aug 11, 2012, I earned 600 euros on yesterday's balance of 56,032 points, which equates to 1.11% for the day. Which happens to be right at the average lately, about 1.11% per day.
 |  | Daily | 7-day | 14-day | 21-day | 30-day | Running
 | Day | Percent | Average | Average | Average | Average | P/S Rate
1 | 2012-06-18 00:00:00 | 0.0582 | n/a | n/a | n/a | n/a
2 | 2012-06-19 00:00:00 | 0.0248 | n/a | n/a | n/a | n/a |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.23 | < Euro/Dollar conversion
3 | 2012-06-20 00:00:00 | 0.0183 | n/a | n/a | n/a | n/a |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | My leadership bonus…
4 | 2012-06-21 00:00:00 | 0.0202 | n/a | n/a | n/a | n/a |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-03-07 00:00:00 | Daily Reward | 504
5 | 2012-06-22 00:00:00 | 0.0213 | n/a | n/a | n/a | n/a |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-04-07 00:00:00 | Daily Reward | 479
6 | 2012-06-23 00:00:00 | 0.0171 | n/a | n/a | n/a | n/a |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-05-07 00:00:00 | Daily Reward | 432
7 | 2012-06-24 00:00:00 | 0.0134 | n/a | n/a | n/a | n/a |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-06-07 00:00:00 | Daily Reward | 522
8 | 2012-06-25 00:00:00 | 0.0137 |  | n/a | n/a | n/a |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-07-07 00:00:00 | Daily Reward | 435
9 | 2012-06-26 00:00:00 | 0.0161 |  | n/a | n/a | n/a |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-08-07 00:00:00 | Daily Reward | 322
10 | 2012-06-27 00:00:00 | 0.02658 |  | n/a | n/a | n/a |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-09-07 00:00:00 | Daily Reward | 392
11 | 2012-06-28 00:00:00 | 0.0222 |  | n/a | n/a | n/a |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-10-07 00:00:00 | Daily Reward | 380
12 | 2012-06-29 00:00:00 | 0.0251 |  | n/a | n/a | n/a |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-11-07 00:00:00 | Daily Reward | 500
13 | 2012-06-30 00:00:00 | 0.0148 |  | n/a | n/a | n/a |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-12-07 00:00:00 | Daily Reward | 501
14 | 2012-07-01 00:00:00 | 0.01275 |  | n/a | n/a | n/a |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13/07/2012 | Daily Reward | 561
15 | 2012-07-02 00:00:00 | 0.01598 |  |  | n/a | n/a |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14/07/2012 | Daily Reward | 385
16 | 2012-07-03 00:00:00 | 0.01597 |  |  | n/a | n/a |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15/07/2012 | Daily Reward | 316
17 | 2012-07-04 00:00:00 | 0.0149 |  |  | n/a | n/a |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16/07/2012 | Daily Reward | 465
18 | 2012-07-05 00:00:00 | 0.0134 |  |  | n/a | n/a |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17/07/2012 | Daily Reward | 498
19 | 2012-07-06 00:00:00 | 0.0158 |  |  | n/a | n/a |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18/07/2012 | Daily Reward | 515
20 | 2012-07-07 00:00:00 | 0.0129 |  |  | n/a | n/a |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19/07/2013 | Daily Reward | 534
21 | 2012-07-08 00:00:00 | 0.0094 |  |  | n/a | n/a |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20/07/2013 | Daily Reward | 519
22 | 2012-07-09 00:00:00 | 0.0114 |  |  |  | n/a |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21/07/2013 | Daily Reward | 468
23 | 2012-07-10 00:00:00 | 0.0109 |  |  |  | n/a |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22/07/2014 | Daily Reward | 346
24 | 2012-07-11 00:00:00 | 0.0142 |  |  |  | n/a |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23/07/2014 | Daily Reward | 527
25 | 2012-07-12 00:00:00 | 0.0141 |  |  |  | n/a |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24/07/2015 | Daily Reward | 538
26 | 2012-07-13 00:00:00 | 0.0155 |  |  |  | n/a |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25/07/2015 | Daily Reward | 592
27 | 2012-07-14 00:00:00 | 0.0104 |  |  |  | n/a |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26/07/2016 | Daily Reward | 607
28 | 2012-07-15 00:00:00 | 0.0084 |  |  |  | n/a |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 27/07/2017 | Daily Reward | 531
29 | 2012-07-16 00:00:00 | 0.0124 |  |  |  | n/a |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Daily Reward | 497
30 | 2012-07-17 00:00:00 | 0.0131 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29/07/2012 | Daily Reward | 457
31 | 2012-07-18 00:00:00 | 0.0124 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30/07/2012 | Daily Reward | 574
32 | 2012-07-19 00:00:00 | 0.0126 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31/07/2012 | Daily Reward | 629
33 | 2012-07-20 00:00:00 | 0.0122 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-08 00:00:00 | Daily Reward | 585
34 | 2012-07-21 00:00:00 | 0.0107 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-02-08 00:00:00 | Daily Reward | 598
35 | 2012-07-22 00:00:00 | 0.0078 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-03-08 00:00:00 | Daily Reward | 627
36 | 2012-07-23 00:00:00 | 0.0118 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-04-08 00:00:00 | Daily Reward | 542
37 | 2012-07-24 00:00:00 | 0.0119 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-05-08 00:00:00 | Daily Reward | 523
38 | 2012-07-25 00:00:00 | 0.0129 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-06-08 00:00:00 | Daily Reward | 549
39 | 2012-07-26 00:00:00 | 0.0131 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-07-08 00:00:00 | Daily Reward | 650
40 | 2012-07-27 00:00:00 | 0.0113 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-08-08 00:00:00 | Daily Reward | 659
41 | 2012-07-28 00:00:00 | 0.0103 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-09-08 00:00:00 | Daily Reward | 590
42 | 2012-07-29 00:00:00 | 0.0094 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-10-08 00:00:00 | Daily Reward | 635
43 | 2012-07-30 00:00:00 | 0.0118 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-11-08 00:00:00 | Daily Reward | 600
43 | 2012-07-31 00:00:00 | 0.0128
44 | 2012-08-01 00:00:00 | 0.0117
45 | 2012-08-02 00:00:00 | 0.0118
46 | 2012-08-03 00:00:00 | 0.0123
47 | 2012-08-04 00:00:00 | 0.0105
48 | 2012-08-05 00:00:00 | 0.0099
49 | 2012-08-06 00:00:00 | 0.0104
50 | 2012-08-07 00:00:00 | 0.0122
51 | 2012-08-08 00:00:00 | 0.0122 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | avg
52 | 2012-08-09 00:00:00 | 0.0108
53 | 2012-08-10 00:00:00 | 0.0115
54 | 2012-08-11 00:00:00 | 0.0107
55 | 2012-08-12 00:00:00
56 | 2012-08-13 00:00:00
57 | 2012-08-14 00:00:00
58 | 2012-08-15 00:00:00
59 | 2012-08-16 00:00:00
 |  |  |  |  |  |  |  |  | avg since day 1
 |  |  |  |  |  |  |  |  | avg, excluding day 1
 |  |  |  |  |  |  |  |  | avg, last 30 days
 |  |  |  |  |  |  |  |  | avg, last 14 days