ABCDEFGHIJKLMNOPQRS
1
UPDATE: 2012-11-29 : Automatic Updating temporarily disabled until I get a chance to optimize the scriptsUpdate 2013-01-05: Moved a bunch of code out of scripts and turned off some bits to get the main stuff working again.
2
See instructions at the bottom if necessary. For discussion, see: http://social.bioware.com/forum/1/topic/343/index/13560038
3
TotalrandomfooArtificial-IgnoranceWadmaasiFireKetchupTrandra1MagnolieJetblackmoonGuyBladeShooter_Mc6avin
4
Credits Spent336,699,00078,210,00035,442,00036,333,0002,871,00039,303,0004,950,000103,455,00033,759,0002,376,000
5
PSPs340179035836729397501,04534124
6
% of Total Packs23.23%10.53%10.79%0.85%11.67%1.47%30.73%10.03%0.71%
7
8
UR Drop Rate0.88%0.51%1.12%1.09%0.00%1.26%0.00%0.96%0.88%0.00%
9
Confidence Interval0.31%0.65%0.97%0.96%3.40%0.92%2.59%0.57%0.75%2.84%
10
UR Count304440501030
11
UR Weapon Drop Rate#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!
12
Expected Number of PSPs to Max UR weapons (from zero)#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!
13
UR Weapon Count#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!
14
Avg Credits/UR11,223,30019,552,5008,860,5009,083,250#DIV/0!7,860,600#DIV/0!10,345,50011,253,000#DIV/0!
15
Longest Losing StreakLoading...Loading...Loading...Loading...Loading...Loading...Loading...Loading...Loading...Loading...
16
Current Losing StreakLoading...Loading...Loading...Loading...Loading...Loading...Loading...Loading...Loading...
17
18
Armor-Piercing Rounds 4#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!
19
Cryo Rounds 4#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!
20
Disruptor Rounds 4#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!
21
Incendiary Rounds 4#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!
22
Warp Rounds 4#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!
23
24
Cyclonic Modulator 4#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!
25
Power Amplifier Module 4#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!
26
27
Earth Rare GearLoading...Loading...Loading...Loading...Loading...Loading...Loading...Loading...Loading...Loading...
28
Earth Uncommon GearLoading...Loading...Loading...Loading...Loading...Loading...Loading...Loading...Loading...Loading...
29
30
Cobra Missile Launcher#DIV/0!100.00%#DIV/0!#DIV/0!100.00%100.00%100.00%100.00%100.00%#DIV/0!
31
Ops Survival Packs#DIV/0!100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%#DIV/0!
32
Thermal Clip Packs#DIV/0!100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%#DIV/0!
33
Medi-Gel100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%
34
35
Gender Bias (Higher = more female)50.35%49.02%64.00%44.79%70.00%50.00%54.55%49.21%46.67%50.00%
36
37
38
DO NOT EDIT:8/25/2015 0:00:004/12/2013 23:05:381/7/2013 13:41:218/25/2015 0:00:008/14/2012 18:00:575/22/2013 19:04:1510/10/2012 12:35:024/10/2013 20:42:5211/16/2013 21:13:5410/19/2012 17:57:57
39
40
41
42
* PLEASE only use this sheet if you have GOOD DATA and use it consistently or have a good contiguous block of purchases (ie no cherry-picking, which would skew results)
* This sheet currently only tracks stats for PSPs.
* This sheet dynamically calculates drop rates based on logged data (you must log every single item in the packs you buy to the log sheet!)
* Create a sheet for your user (you can duplicate example_user to start)
** Color in URs with middle grey (183 or 204) BG (I use this for counting so that I don't need to track a list of the names of every UR)
** Note: your spelling for lvl4 gear must match below! For my logging, I type out the complete name as printed on the cards except for changing the roman numeral to a number for easier future filtering
** Once you have the basics filled out, it goes quick since autocomplete does most of the work
* You can add you summary column to the stats by copying and making sure you're pointing to the right cell/sheet name
* You can force Earth Rare and Uncommon Gear to stop counting by typing 'stop EarthRareDLC' and 'stop EarthUncommonDLC' in the Notes field next to your last pack
43
44
45
TODO:* Create distribution chart for Losing Streaks
46
Add delay parameter (or delay based on call, stochastic)
47
Add Cache - can find location of call?
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100