Crowdfunding Development Spreadsheet Version 2.0
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
3
Date @20:00:00 UTC+1Amount $Increase $CitizensAlpha Slots LeftCommentsGraphs, Models, Predictions, and Other Forms of Analysis:
People with Editing Access
4
2012-11-13$3,438,96348,682Total in October: $2,543,656
StarCitizen -> Google Account
5
2012-11-14$3,551,355$112,39250,256
Shadowrunner -> Michael Espebu
6
2012-11-15$3,666,261$114,90651,676
Ser Erris -> Chistoph Linden
7
2012-11-16$3,891,473$225,212http://i.imgur.com/M9truMY.jpg
Lastof -> James Titmuss
8
2012-11-17$4,239,211$347,73858,132
Nehkara15 -> Eric Olson
Chris' Testing Space - Please Pardon the Mess
9
2012-11-18$4,728,251$489,04073,475
Moon -> Chris Schneider
10
2012-11-19$6,238,563$1,510,31279,461<--campaign ended
Mageoftheyear -> David Watson
Examples:Path:
11
2012-11-20$6,366,930$128,36792,069Day 1 after campaign (website was offline)
Dibesjr -> Jon D
#N/A
""//competitors/competitorsItem[1]/team/name")"
12
2012-11-21$6,499,181$132,251<--$6,500,000 @ 20:06
Steampunk_Penguin --> Stephen Dumbeck
13
2012-11-22$6,581,711$82,53094,906<-- no no no, all time low, not anymore ;)fc -> fastcart
11.03.2014: Still no fix for this bug.
14
2012-11-23$6,661,564$79,853<-$6,600,000 @ ~01:20
15
2012-11-24$6,715,374$53,810<-$6,700,000 @ ~15:10
16
2012-11-25$6,783,761$68,387Last full day of grace period
Original Working Code:
17
2012-11-26$6,832,568$48,80797,496<-$6,800,000 @ ~04:30
18
2012-11-27$6,853,901$21,33398,208
19
2012-11-28$6,868,321$14,42098,560CSS Path
#stretchgoals > div.wrapper.stretchgoal-list > div.goal.in-progress > div.amount-bg > div.campaign-amount-box.current > div.amount
20
2012-11-29$6,878,159$9,83898,657XPath
//*[@id='stretchgoals']/div[3]/div[48]/div[1]/div[1]/div[2]
21
2012-11-30$6,893,303$15,14498,865Total in November: $4,367,877Proper XPath
"//div[@class='goal in-progress']//div[@class='amount-bg']//div[@class='campaign-amount-box current']//div[@class='amount']"
22
2012-12-01$6,911,533$18,230<-$6,900,000 @ ~06:00WIP XPath
*[@id='stretchgoals']/div[@class='wrapper stretchgoal-list']/div[@class='goal in-progress']/div[@class='amount-bg']/div[@class='campaign-amount-box current']/div[@class='amount']
23
2012-12-02$6,929,064$17,531
24
2012-12-03$6,944,814$15,75099,602estimated value (catched from 23:00)URL2
https://robertsspaceindustries.com/funding-goals?_accept=text/xml
25
2012-12-04$6,958,014$13,200URL
https://robertsspaceindustries.com/funding-goals
26
2012-12-05$6,970,114$12,100Test1#N/A
27
2012-12-06$6,980,104$9,990LIVE STATUSTest2 - XMLURL#N/A
28
2012-12-07$6,990,848$10,744
Test3 - NONXML
#N/A
29
2012-12-08$7,007,568$16,720100,336Current Pledge Amount#N/AURL
https://www.google.co.uk/finance?cid=704531
30
2012-12-09$7,021,179$13,611#N/A
31
2012-12-10$7,030,734$9,555$198,329,995#N/APath:Copied
//*[@id="market-data-div"]/div[2]/div[1]/table[1]/tbody/tr[4]/td[1]
32
2012-12-11$7,045,754$15,020Path:Working
//*[@id='market-data-div']//tr[td = 'Vol / Avg.']/td[2]
33
2012-12-12$7,053,584$7,830100,866Increase in pledge amount since Kickstarter campaign ended
34
2012-12-13$7,062,689$9,105101,133RSS Feed URL
https://robertsspaceindustries.com/comm-link/rss
POC - Problem is with RSI Website:
35
2012-12-14$7,073,229$10,540$192,091,432Google#N/A
36
2012-12-15$7,085,756$12,527101,518Average Pledge/Day
Since Grace Period End
RSI
Roberts Space Industries | Follow the development of Star Citizen and
Squadron 42
37
2012-12-16$7,092,221$6,465101,569Slashdot
Slashdot: News for nerds, stuff that matters
38
2012-12-17$7,103,506$11,285101,644$178,486.94
39
2012-12-18$7,111,066$7,560Average Pledge/Day - Full CampaignNotes:
40
2012-12-19$7,120,101$9,035102,048$177,839.06If you want to participate or actively maintain this sheet, please ask in the topic on the official forums.
https://robertsspaceindustries.com/spectrum/community/SC/forum/3/thread/crowdfunding-development-spreadsheet-version-2-0-w
Seems like ImportXML 2.0 doesn't like spaces in class/ID's etc.
41
2012-12-20$7,128,871$8,770102,129Middle Quartiles Average (ALT1)
Original code works in old sheet but not in new sheet.
42
2012-12-21$7,137,616$8,745$46,265.75
Problem is a bug: https://productforums.google.com/forum/?utm_medium=email&utm_source=footer#!msg/docs/JlqjIzioL7M/ihNQFD8O0j4J
43
2012-12-22$7,157,311$19,695Trimmean 10% Average (ALT2)
44
2012-12-23$7,171,691$14,380103,011$72,242.57
45
2012-12-24$7,177,620$5,929Total Pledge Amount 2014-01-01
46
2012-12-25$7,184,525$6,905103,412$35,672,435
Included graph for pledge amount prediction with three different forecast models. The data for this graph is located in the tab 'Forecast Calculations' - Ser Erris
47
2012-12-26$7,193,265$8,740Total Pledge Amount 2015-01-01Ser Erris: Forecast models: ALT1 is the average over quartile 1 and 2, ALT2 is the average over trimmean 10%. Last update for forecast is 09/02/2017
-changed calulation period for forecast (02/17/13 - today) to get a better prediction.
-changed calculations in the background to make less expensive in calculation CPU requirements.
-changed the linear regression starting of 01/01/2015. Will give a good picture if we make some of those jumps every few month
Added linear regression for the last 30 days and forecasting it. This is a good assumption on where we end up, if we continue as we did lately. Basically it is like putting a ruler on the Reality graph and draw a line. Again, taking 2015 values into account only.
2017-09-02: Corrected Linea Regression to take current values into account and have the today value be the same as the real value.
48
2012-12-27$7,201,960$8,695103,786$68,590,679
49
2012-12-28$7,205,918$3,958103,868Total Pledge Amount 2016-01-01
50
2012-12-29$7,212,138$6,220104,087$104,592,187
51
2012-12-30$7,220,318$8,180Total Pledge Amount 2017-01-01
52
2012-12-31$7,226,318$6,000$140,659,959
53
2013-01-01$7,239,348$13,030104,403Total Pledge Amount 2018-01-01
54
2013-01-02$7,245,423$6,075$175,602,845
55
2013-01-03$7,252,423$7,000104,619Estimated totaled pleged by 2019-01-01 on average daily
56
2013-01-04$7,261,033$8,610104,841
57
2013-01-05$7,273,430$12,397$205,043,110
58
2013-01-06$7,283,465$10,035Estimated totaled pleged by 2019-01-01 (ALT1)
59
2013-01-07$7,289,392$5,927
60
2013-01-08$7,299,392$10,000105,363$201,557,058
61
2013-01-09$7,312,536$13,144Estimated totaled pleged by 2019-01-01 (ALT2)
62
2013-01-10$7,330,126$17,590
63
2013-01-11$7,341,025$10,899$203,401,413
64
2013-01-12$7,348,534$7,509Estimated totaled pleged by 2019-01-01 (Linear Regression)
65
2013-01-13$7,356,043$7,509
66
2013-01-14$7,363,552$7,509106,364$205,322,673
67
2013-01-15$7,371,061$7,509106,433
68
2013-01-16$7,378,570$7,509106,552
69
2013-01-17$7,384,633$6,063106,591Total in December: $333,015
70
2013-01-18$7,390,696$6,063106,689
71
2013-01-19$7,396,760$6,064106,799
72
2013-01-20$7,403,633$6,873
73
2013-01-21$7,410,506$6,873
74
2013-01-22$7,417,380$6,874107,119
75
2013-01-23$7,425,360$7,980
76
2013-01-24$7,432,045$6,685107,318
77
2013-01-25$7,441,410$9,365107,365
78
2013-01-26$7,450,775$9,365107,552
79
2013-01-27$7,461,600$10,825
80
2013-01-28$7,469,276$7,676
81
2013-01-29$7,476,952$7,676108,021
82
2013-01-30$7,484,628$7,676108,065
83
2013-01-31$7,492,443$7,815
84
2013-02-01$7,503,298$10,855108,303Total in January: $266,125
85
2013-02-02$7,510,355$7,057$7.5mil in sales with 21 months left in production, because why not?
86
2013-02-03$7,520,023$9,668108,574
87
2013-02-04$7,529,691$9,668108,769Avg between 2/3 and 2/8
88
2013-02-05$7,539,359$9,668$81,744
89
2013-02-06$7,549,027$9,668
90
2013-02-07$7,558,696$9,669109,225$595,862
91
2013-02-08$7,575,131$16,435
92
2013-02-09$7,595,918$20,787115,869Citizen card shipping form posted
93
2013-02-10$7,688,932$93,014119,445
94
2013-02-11$7,735,090$46,158120,884
95
2013-02-12$7,791,091$56,001123,957
96
2013-02-13$7,832,082$40,991
97
2013-02-14$7,951,328$119,246131,408
98
2013-02-15$8,065,540$114,212139,773Metal upgrades for Bronze and Silver cards
99
2013-02-16$8,154,558$89,018The announced citizen card deadline
100
2013-02-17$8,168,011$13,453149,558
Loading...
Main menu