| A | B | |
|---|---|---|
1 | Got a comment, bug report, question or feature request? Leave a message here! (or PM /u/drakeiddon on reddit) | Replies from C'eve |
2 | DONGER | ヽ༼ຈل͜ຈ༽ﾉ |
3 | Amazing spreadsheet, one suggestion: The "Current (total) XP:" should be "XP into level" and the other formulas can figure out total XP from that. The current XP into level is much easier to enter and moves all the calculations to the spreadsheet instead of the user. | Having the user input Total XP instead of "XP into level" allows me to cut the code of 90% of the cells by over half. (At some point I will put a screenshot or something to show people where they can see thier total XP ingame, they dont have to calculate it) Edit: The screenshot has been implemented in V3.2, it will only show when the sheet asks for total xp in red text |
4 | I want to see how many FL matches it'll take me to gear out my alt class in i100 if I were to only do FL - ideally using my current FL win stats to calculate this. | Implemented in V3.1 |
5 | Total EXP is off by 10. Does not include rank 0, should be 113710 (The exp progression includes rank 0 but the "Total EXP required" to the right does not | Fixed in v4.1 |
6 | The values in 26 I are way off right now. Specifically, they're showing about 10x the exp required to get to the next level. | Fixed in V5.3, Googledocs sometimes does not apply the cell lock settings to the ones i dont want to change, so it can mess everything up every so often >:( |
7 | 1st and 2nd place frontlines percentage is the same, which messes up the predicated wins calculation. I think? | Once again google's shoddy settings are fucking with the sheet, fixed in v5.6 |
8 | This doesn't account for weekly xp bonuses (via Challenge Log) | Accounting for weekly bonuses assumes people take the bonuses and takes a long time to code into the sheet, for simplicity sake i decided to keep it as a separate entity |
9 | I am unable to create a new copy of this form. The page that opens hangs at "Loading...". I went around this by downloading the sheet in the excel format. | Thats actually an issue with googledocs, not this sheet ( have the same issue everytime i make a backup of a new version) once you get to loading, open a new tab and go to the googlesheets on googledocs for your account and the copied spreadsheet will be in there for you to use (downloading as an excel file also works, but i dont think the version checker works in excel) |
10 | Cells J33, J34 reference the wrong cells in their calculations. | Fixed in v6.3 |
11 | "Challange" log reward should be changed to "Challenge". Thanks for all your hard work! This sheet makes me realize how futile it is to try to fully gear all of my PvP classes... since I have nearly all of them and use them for PvP and PvE. I have just about every weapon and main body piece though! :) | Wow I didn't even realise that i spelt that wrong :I Thanks for the heads up, Changed in v7.1 As for gearing all pvp classes, I;m thinking of doing a BiS analysis page for all classes for Frontlines, but thats something for the future |
12 | Make pvp blue cells just with numbers and limited ones, people keep spamins stuff in there | Added in V8.1, the tool now rejects text and ranks above 45 |
13 | Having to enter EXP and rank seem reduntent. Seeing how you check LVL vs EXP. Why not just calulate Current rank Based on EXP entered? | The way the level is checked vs exp is if the xp needed to rank up once is either higher than what it should be, or less than zero, so that code isnt relevent to calculating rank from total XP Similar answer to a question asked previously, its a fairly big overhaul to some of the cells for a pretty minimal gain, plus alot of people put the wrong xp in (not the total one) and then would be annoyed its giving them the wrong rank It's certainly doable, but i'd need to set aside some time to figure out how to do it and don't have much spare time currently due to personal events |
14 | Is Materia worth it, if so, which on what? | Currently they are only used in lvl 50 (not i80 synced) wolves den matches, in i80 and i150 synced matches all materia is disabled I'm currently stocking up on all of the pvp materia in anticipation for ranked wolves den in 3.1 and/or 3.2, if pvp materia becomes relevent i will make a page based on thier effects (understandably, 99.99% of people dont understand what they do becuase they are just never used) If they are used again, they are definately worth it |
15 | ||
16 | ||
17 | ||
18 | ||
19 | ||
20 | ||
21 | ||
22 | ||
23 | ||
24 | ||
25 | ||
26 | ||
27 | ||
28 | ||
29 | ||
30 | ||
31 | ||
32 | ||
33 | ||
34 | ||
35 | ||
36 | ||
37 | ||
38 | ||
39 | ||
40 | ||
41 | ||
42 | ||
43 | ||
44 | ||
45 | ||
46 | ||
47 | ||
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 |