Pages: [1] 2 :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Driftward
Subdreddit Test Alliance Please Ignore
93
|
Posted - 2013.05.20 20:41:00 -
[1] - Quote
I've revamped my spreadsheet with the latest data concerning the new skill tree changes that are in the works for 5/22. Vehicle skill changes have yet to be described but will be updated as they are rolled out. Enjoy.
https://docs.google.com/spreadsheet/ccc?key=0AjhtV2Pl_-oLdHpGek8zRjd4R183NE9sV09tWU03bnc&usp=sharing\
For the newbros out there, this tool lets you put your skill points into different hypothetical progressions so that you can be sure of where you want to focus your point. Use it well. |
Rynx Sinfar
Subdreddit Test Alliance Please Ignore
681
|
Posted - 2013.05.20 20:54:00 -
[2] - Quote
You forgot to change the other sheets where you actually enter the data. But for anyone wanting to use it, they are decorative |
Driftward
Subdreddit Test Alliance Please Ignore
93
|
Posted - 2013.05.20 20:58:00 -
[3] - Quote
Rynx Sinfar wrote:You forgot to change the other sheets where you actually enter the data. But for anyone wanting to use it, they are decorative I'm sure that you must be mistaken....(ninja edit for the win) |
Chankk Saotome
SyNergy Gaming EoN.
301
|
Posted - 2013.05.21 09:01:00 -
[4] - Quote
Character Skill Planner
I'll update the multipliers when I actually see them confirmed. I've already changed things before only to have CCP statements on the near future vanish on the breeze. Words are wind. |
Driftward
Subdreddit Test Alliance Please Ignore
97
|
Posted - 2013.05.21 17:46:00 -
[5] - Quote
Chankk Saotome wrote:Character Skill PlannerI'll update the multipliers when I actually see them confirmed. I've already changed things before only to have CCP statements on the near future vanish on the breeze. Words are wind. Yah whatever, if it doesn't happen it doesn't. Regardless, at least I don't try and hijack your posts with my skill planner, seriously have some decorum.....(btw my skill planner is prettier and more functional than yours as long as we're being petty )
EDIT: I seem to have forgotten to say neener neener. So there it is. Neener neener. |
Chankk Saotome
SyNergy Gaming EoN.
305
|
Posted - 2013.05.22 11:32:00 -
[6] - Quote
Driftward wrote:Yah whatever, if it doesn't happen it doesn't. Regardless, at least I don't try and hijack your posts with my skill planner, seriously have some decorum.....(btw my skill planner is prettier and more functional than yours as long as we're being petty ) EDIT: I seem to have forgotten to say neener neener. So there it is. Neener neener.
Actually I'd like some help if you could give some ideas. No reason not to combine projects and make a single tool that benefits the community the best it can.
We had a lot of people doing "Fitting Tools" or "Market Listings" and stuff. Reinventing the wheel. It seems a lot of things could be superior all around if we could just work together on a single project.
I would like your opinions on how to display certain skill effects though. But that is a discussion for the other thread. |
Driftward
Subdreddit Test Alliance Please Ignore
101
|
Posted - 2013.05.22 14:53:00 -
[7] - Quote
Chankk Saotome wrote:Driftward wrote:Yah whatever, if it doesn't happen it doesn't. Regardless, at least I don't try and hijack your posts with my skill planner, seriously have some decorum.....(btw my skill planner is prettier and more functional than yours as long as we're being petty ) EDIT: I seem to have forgotten to say neener neener. So there it is. Neener neener. Actually I'd like some help if you could give some ideas. No reason not to combine projects and make a single tool that benefits the community the best it can. We had a lot of people doing "Fitting Tools" or "Market Listings" and stuff. Reinventing the wheel. It seems a lot of things could be superior all around if we could just work together on a single project. I would like your opinions on how to display certain skill effects though. But that is a discussion for the other thread. Toss me an email at [email protected] with any of your questions concerning skill effects and so forth and we can put our heads together. |
Chankk Saotome
SyNergy Gaming EoN.
315
|
Posted - 2013.05.25 00:28:00 -
[8] - Quote
You might consider adding Drop-boxes for all your skill level items...
Right-click one box select 'Data Validation'
Choose "List of Items" and type "0,1,2,3,4,5" Select 'Reject Input' Select 'Display In-Cell button to show list" in Show Help you can add your own message... it works proper on my Office doc but is set to the default "FALSE" on GoogleDocs because I don't want to bother changing all of those currently... though I probably should if I intend on changing all the colors across the board.
ALSO! I like your usage of the total SP calculated up in the top amongst frozen rows... I should probably do the same. Seems very useful for at-a-glance total numbers. Well planned there. |
Chankk Saotome
SyNergy Gaming EoN.
316
|
Posted - 2013.05.26 13:20:00 -
[9] - Quote
I notice you kept the Character Sheet > Skill List method of displaying everything.
I used the same originally but I find a collapsed node version is maybe easier to view initial skills and direct branches.
That's what I use though, and not trying to make your planner mine. If you were to look at the old sheet and yours it lines up directly which can be quite useful. Mine doesn't have that benefit for sure, but I wanted to keep up with the times and CCP's visual adjustments.
As for the specific tabs you might try aligning those in the same manner as the node-tree. It's a little hard to follow with things stair-stacked on top of each other.
I like that element though. Would have been good to think of actually SHOWING the node tree somewhere and then linking current skill and goal skill and required skill info from the top sheet into it... I'll have to think about that... some day. |
Driftward
Subdreddit Test Alliance Please Ignore
115
|
Posted - 2013.05.26 20:18:00 -
[10] - Quote
Chankk Saotome wrote:You might consider adding Drop-boxes for all your skill level items...
Right-click one box select 'Data Validation'
Choose "List of Items" and type "0,1,2,3,4,5" Select 'Reject Input' Select 'Display In-Cell button to show list" in Show Help you can add your own message... it works proper on my Office doc but is set to the default "FALSE" on GoogleDocs because I don't want to bother changing all of those currently... though I probably should if I intend on changing all the colors across the board.
ALSO! I like your usage of the total SP calculated up in the top amongst frozen rows... I should probably do the same. Seems very useful for at-a-glance total numbers. Well planned there.
I'd been wondering (idly) about how to do that ever since I saw hydraslav's fitting tool, question answered.
As to the node progression....to make a really nice looking one would be really difficult in google spreadsheets. All the object tools are bulky and look terrible (so no arrows or lines). The step pattern was the next best thing that I could think of when I was making this sheet. I would like to switch to a nodal system in the list format but not nearly enough motivation to take that on right now. Just thinking about having to switch all the colors again gives me a headache.
Should I add empty rows between skills in my step node system? would that make it easier to view? Not sure where I would want to take that. |
|
Driftward
Subdreddit Test Alliance Please Ignore
120
|
Posted - 2013.05.27 06:18:00 -
[11] - Quote
To those who may be interested, I added a pre-req error/warning column for dropsuit related skills into the sheet. Same for the vehicle skills will be incoming later tomorrow (or I guess it would be today by now). I an staging this because it is finicky as hell (and damn tedious) and I'd rather get it right the first time.... |
Driftward
Subdreddit Test Alliance Please Ignore
125
|
Posted - 2013.05.27 19:15:00 -
[12] - Quote
Update: Pre-req warnings are fully integrated for all categories and linked to specific skill tabs/tree displays. Unless someone posts a really good suggestion the current version will stay the same for a while (or until CCP adds new stuff/changes the skills around)
Current version: v1.63 |
Driftward
Subdreddit Test Alliance Please Ignore
127
|
Posted - 2013.05.28 20:30:00 -
[13] - Quote
Apparently I wasn't quite done innovating....thought of a really nice feature this afternoon. I added a column on the upper left side that allows you to filter down to only those skills you are currently using. Nifty right? I did have to delete the category totals column to do this though. If everyone really liked that feature I can add it back in on the top bar if need to, just let me know if that feature was actually useful.
Current version: v1.64 |
hydraSlav's
Ostrakon Agency Gallente Federation
166
|
Posted - 2013.05.29 03:44:00 -
[14] - Quote
Driftward wrote:Apparently I wasn't quite done innovating....thought of a really nice feature this afternoon. I added a column on the upper left side that allows you to filter down to only those skills you are currently using. Nifty right? I did have to delete the category totals column to do this though. If everyone really liked that feature I can add it back in on the top bar if need to, just let me know if that feature was actually useful.
Current version: v1.64
You should mention the nifty online version check too |
Byozuma Kegawa
The Tritan Industries RISE of LEGION
77
|
Posted - 2013.05.29 04:13:00 -
[15] - Quote
Some of your prerequisites are off. I know System Hacking requires Core Upgrades 4. |
Driftward
Subdreddit Test Alliance Please Ignore
128
|
Posted - 2013.05.29 05:14:00 -
[16] - Quote
Byozuma Kegawa wrote:Some of your prerequisites are off. I know System Hacking requires Core Upgrades 4.
Append: It's also not calculating future SP values together.
Fixed those two issues (somehow I major f***** up the total future sp calculation that was literally just Sum(Q1:Q1xx), amazingly all my other formulas work that end up being like 4 lines.....
All the rest of dropsuit upgrades and dropsuit command look right. The issue was I had the wrong pre-req in the specific skill tab and that's where I iterated from. Just replicated the problem to a more visible location. Regardless, thanks for the catch. |
Byozuma Kegawa
The Tritan Industries RISE of LEGION
78
|
Posted - 2013.05.29 06:25:00 -
[17] - Quote
Still doesn't seem to want to fully calculate future SP values... unless you use the quick level selector on the first page. Makes going into the different sections kind of moot. |
xAckie
Ahrendee Mercenaries
158
|
Posted - 2013.05.29 13:04:00 -
[18] - Quote
A quick heads up. Your numbers arent calculating right.
the spreadsheet tells me I should have approx 70k sp left over from my current amount on screen i have over 374k sp
i have checked and triple checked as I wanted to see how much I need for future spend |
Driftward
Subdreddit Test Alliance Please Ignore
128
|
Posted - 2013.05.29 15:31:00 -
[19] - Quote
xAckie wrote:A quick heads up. Your numbers arent calculating right.
the spreadsheet tells me I should have approx 70k sp left over from my current amount on screen i have over 374k sp
i have checked and triple checked as I wanted to see how much I need for future spend Hmmmm....one if you could post your skill set that would be useful. I have no way of checking those specific skills unless you do that and trying to recheck the entire set is a bit ridiculous. The easiest answer is to say that its likely a multiplier issue (I hope anyways, those are easy fixes) If it's not then I, again, need those skills and specific numbers even more.
I guess it's time to go bug hunting.... |
Byozuma Kegawa
The Tritan Industries RISE of LEGION
78
|
Posted - 2013.05.29 21:09:00 -
[20] - Quote
It doesn't seem to be calculating total future SP correctly. The doc just doesn't want to behave, does it. |
|
xAckie
Ahrendee Mercenaries
158
|
Posted - 2013.05.29 21:34:00 -
[21] - Quote
will check tomorrow and post. Sorry late now |
Driftward
Subdreddit Test Alliance Please Ignore
128
|
Posted - 2013.05.29 21:38:00 -
[22] - Quote
Byozuma Kegawa wrote:It doesn't seem to be calculating total future SP correctly. The doc just doesn't want to behave, does it. It usually helps if I'm actually double checking my work.....I apparently decided that I needed to double the excess SP and add that into your total future sp as well....I fixed it. Again.....grumble....grumble...throws spreadsheet on the floor....kicks it around a bit....then picks it back up because its not Friday. |
Driftward
Subdreddit Test Alliance Please Ignore
129
|
Posted - 2013.05.31 16:34:00 -
[23] - Quote
Driftward wrote:Byozuma Kegawa wrote:It doesn't seem to be calculating total future SP correctly. The doc just doesn't want to behave, does it. It usually helps if I'm actually double checking my work.....I apparently decided that I needed to double the excess SP and add that into your total future sp as well....I fixed it. Again.....grumble....grumble...throws spreadsheet on the floor....kicks it around a bit....then picks it back up because its not Friday.
Yahhh so my first fix was ********. Not going to sugar coat that one. Super dumb. I fixed it about 3 hours later so hopefully nobody got that version of it, but damn.....
Current Version: v1.65 |
Driftward
Subdreddit Test Alliance Please Ignore
131
|
Posted - 2013.06.03 14:47:00 -
[24] - Quote
Added Shopping List/skill queue (Courtesy of Rynx Sinfair) functionality to skill sheet.
Current Version: v1.66 |
Driftward
Subdreddit Test Alliance Please Ignore
223
|
Posted - 2013.06.21 19:36:00 -
[25] - Quote
If you're like me and hate importing your skills over from a skill planning tool....
then you can replace your first character slot (cell E3) in the hydraslav's fitting tool with the formula [=importRange(E2,-¦Importskills-¦)] (without brackets of course) and then replace cell E2 with the key (in the URL from "key=" up to "&usp") to your copy of the skill planner. Or you could just input the key in the formula rather than referencing an adjacent cell.
There would be a way to implement a script of some sort so that it doesn't try and constantly update. Sadly, I do not have the skill set necessary to implement scripts...
Also, I'm not sure if this formula would transfer when the fitting tool gets updated. But all that being said, it's easy enough to just type the formula back in.
Functionality for this import has been added in version 1.67 |
Driftward
Subdreddit Test Alliance Please Ignore
224
|
Posted - 2013.06.24 20:48:00 -
[26] - Quote
New version (v1.68) now available. Scripts have been added to save and load multiple characters in one spreadsheet. More info in the OP.
|
Chankk Saotome
SyNergy Gaming EoN.
409
|
Posted - 2013.06.26 14:52:00 -
[27] - Quote
Congrats on the sticky Driftward! ^_^ |
PLANETSIDETOOonPS4
Brutor Vanguard Minmatar Republic
0
|
Posted - 2013.06.27 02:00:00 -
[28] - Quote
Wow amazing |
Scotty2Hottie6
Circle of Huskarl Minmatar Republic
0
|
Posted - 2013.07.12 09:43:00 -
[29] - Quote
Great stuff. Thanks. |
Driftward
Subdreddit Test Alliance Please Ignore
299
|
Posted - 2013.07.24 16:48:00 -
[30] - Quote
So it's been a while since I updated this both due to RL stuff and because skill tree changes haven't happened in the latest updates.
Any requests for updates or features? Otherwise I'll let this sit for the time being until we get an update that adds/removes skills. |
|
|
|
|
Pages: [1] 2 :: one page |
First page | Previous page | Next page | Last page |