Spreadsheet: 58033d1258353071-exclude-non-mature-data-copy-of-monthly-cancels-v2
Sheet: 2009

Monthly Billing [NAME]: 2009
Printed on: | 2009-11-17 00:00:00
 | 2009-01-01 00:00:00 |  | 2009-02-01 00:00:00 |  | 2009-03-01 00:00:00 |  | 2009-04-01 00:00:00 |  | 2009-05-01 00:00:00 |  | 2009-06-01 00:00:00 |  | 2009-07-01 00:00:00 |  | 2009-08-01 00:00:00 |  | 2009-09-01 00:00:00 |  | 2009-10-01 00:00:00 |  | 2009-11-01 00:00:00 |  | 2009-12-01 00:00:00 |  | Total
Primary price point | 8.97 |  | 8.97 |  | 8.97 |  | 8.97 |  | 9.97 |  | 9.97 |  | 9.97 |  | 11.97 |  | 11.97 |  | 11.97
Joins | 10338 |  | 34267 |  | 6796 |  | 26895 |  | 119766 |  | 11081 |  | 9553 |  | 8210 |  | 11650 |  | 13500 |  |  |  |  |  | 252056
Trial cancel | 4055 |  | 14439 |  | 2552 |  | 10190 |  | 43000 |  | 3864 |  | 3465 |  | 2983 |  | 4397 |  | 2778 |  |  |  |  |  | 91723
Trial % | 0.3922422131940414 |  | 0.421367496425132 |  | 0.3755150088287228 |  | 0.3788808328685629 |  | 0.3590334485580215 |  | 0.3487049905243209 |  | 0.3627132837851983 |  | 0.3633373934226553 |  | 0.3774248927038626 |  | 0.2057777777777778 |  |  |  |  |  | 0.3638992922207763
Bad card | 424 |  | 1655 |  | 393 |  | 1051 |  | 4620 |  | 514 |  | 436 |  | 368 |  | 261 |  | 0 |  |  |  |  |  | 9722
Bad Card % (Joins) | 0.04101373573224995 |  | 0.04829719555257245 |  | 0.05782813419658623 |  | 0.03907789551961331 |  | 0.03857522168228045 |  | 0.04638570526125801 |  | 0.04564011305349105 |  | 0.04482338611449452 |  | 0.02240343347639485 |  | 0 |  |  |  |  |  | 0.03857079379185578
Bad Card % (Billed) | 0.0674836861371956 |  | 0.08346782328020981 |  | 0.09260131950989632 |  | 0.0629152948219096 |  | 0.0601828934684626 |  | 0.07122072883469585 |  | 0.07161629434954007 |  | 0.07040367323512531 |  | 0.03598510960981663 |  | 0 |  |  |  |  |  | 4.205138710231434e-07
Month 1 Bill | 5858 |  | 18173 |  | 3850 |  | 15652 |  | 72134 |  | 6703 |  | 5652 |  | 4859 |  | 6751 |  | 4180 |  |  |  |  |  | 143812
Month 1 Cancel | 1777 | 0.1718901141420004 | 5620 | 0.164006186710246 | 1062 | 0.1562683931724544 | 4324 | 0.1607733779512921 | 20152 | 0.1682614431474709 | 1690 | 0.1525133110730079 | 1534 | 0.1605778289542552 | 1192 | 0.1451887941534714 | 862 | 0.07399141630901288 | 71 | 0.00525925925925926 |  | 0 |  | 0 | 38284 | 0.1518868822801282
Month 2 Bill | 4081 |  | 12553 |  | 2760 |  | 11328 |  | 51981 |  | 5012 |  | 4118 |  | 3584 |  | 2343 |  |  |  |  |  |  |  | 97760
Month 2 Cancel | 979 | 0.0946991681176243 | 3032 | 0.08848162955613273 | 631 | 0.09284873454973513 | 2462 | 0.09154117865774307 | 11688 | 0.09759030108711989 | 1110 | 0.1001714646692537 | 854 | 0.0893960012561499 | 361 | 0.04397076735688185 | 38 | 0.003261802575107296 |  | 0 |  | 0 |  | 0 | 21155 | 0.08392976164027041
Month 3 Bill | 3102 |  | 9474 |  | 2145 |  | 8865 |  | 40296 |  | 3902 |  | 3193 |  | 1506 |  |  |  |  |  |  |  |  |  | 72483
Month 3 Cancel | 577 | 0.05581350357902883 | 1789 | 0.05220766334957831 | 439 | 0.06459682165979988 | 1690 | 0.06283695854248002 | 7707 | 0.0643504834427133 | 622 | 0.05613211803988809 | 278 | 0.02910080602951952 | 23 | 0.002801461632155907 |  | 0 |  | 0 |  | 0 |  | 0 | 13125 | 0.05207176183070429
Month 4 Bill | 2516 |  | 7727 |  | 1718 |  | 7175 |  | 32583 |  | 3232 |  | 1659 |  |  |  |  |  |  |  |  |  |  |  | 56610
Month 4 Cancel | 371 | 0.03588701876571871 | 1368 | 0.03992179064405988 | 285 | 0.04193643319599764 | 1224 | 0.04551031790295594 | 5221 | 0.04359334034701001 | 213 | 0.01922209186896489 | 20 | 0.002093583167591333 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 8702 | 0.03452407401529819
Month 5 Bill | 2147 |  | 6363 |  | 1433 |  | 5950 |  | 27312 |  | 1749 |  |  |  |  |  |  |  |  |  |  |  |  |  | 44954
Month 5 Cancel | 298 | 0.02882569162313794 | 939 | 0.02740245717454111 | 217 | 0.03193054738081224 | 680 | 0.02528350994608663 | 2447 | 0.02043150810747624 | 16 | 0.001443913004241495 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 4597 | 0.01823801060081887
Month 6 Bill | 1856 |  | 5424 |  | 1215 |  | 5079 |  | 22248 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35822
Month 6 Cancel | 265 | 0.02563358483265622 | 742 | 0.02165348586103248 | 170 | 0.02501471453796351 | 192 | 0.007138873396542109 | 249 | 0.002079054155603427 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 1618 | 0.006419208429872727
Month 7 Bill | 1591 |  | 4682 |  | 1033 |  | 1384 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8690
Month 7 Cancel | 189 | 0.01828206616366802 | 607 | 0.01771383546852657 | 57 | 0.008387286639199529 | 12 | 0.0004461795872838818 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 865 | 0.003431777065414035
Month 8 Bill | 1402 |  | 4043 |  | 650 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6095
Month 8 Cancel | 178 | 0.01721803056684078 | 236 | 0.006887092538010331 | 7 | 0.001030017657445556 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 421 | 0.001670263750912496
Month 9 [NAME] | 1198 |  | 3170 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4368
Month 9 Cancel | 46 | 0.00444960340491391 | 14 | 0.0004085563370006128 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 60 | 0.0002380423397975053
Month 10 Bill | 622 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 622
Month 10 Cancel | 2 | 0.0001934610176049526 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 2 | 7.934744659916844e-06
Month 11 Bill |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Month 11 Cancel |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 0 | 0
Month 12 Bill |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Month 12 Cancel |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 0 | 0
Total: | 24373 |  | 71609 |  | 14804 |  | 55433 |  | 246554 |  | 20598 |  | 14622 |  | 9949 |  | 9094 |  | 4180 |  | 0 |  | 0 |  | 471216
86 Last 2 datapoints | 24373 |  | 71609 |  | 14804 |  | 55433 |  | 246554 |  | 20598 |  | 14622 |  | 9949 |  | 9094 |  | 4180 |  | 0 |  | 0 |  | 471216
Billing Events: | 2.357612691042755 |  | 2.089736481162634 |  | 2.178340200117716 |  | 2.061089421825618 |  | 2.058630997111033 |  | 1.858857503835394 |  | 1.530618653826023 |  | 1.211814859926918 |  | 0.7806008583690988 |  | 0.3096296296296296 |  | 0 |  | 0 |  | 1.869489319833688
Example 1
Rows to Grab | 16 | 16 | 14 | 16 | 12 | 16 | 10 | 16 | 8 | 16 | 6 | 16 | 4 | 16 | 2 | 16 | 0 | 16 | -2 | 16 | -4 | 16 | -6 | 16
Result | 22553 | 0 | 64396 | 0 | 13121 | 0 | 48970 | 0 | 196994 | 0 | 15617 | 0 | 9770 | 0 | 4859 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Example 2 | ...?