|
|
| 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. |
Driftward
Subdreddit
Test Alliance Please Ignore
93
|
Posted - 2013.05.20 20:58:00 -
[2] - 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) |
Driftward
Subdreddit
Test Alliance Please Ignore
97
|
Posted - 2013.05.21 17:46:00 -
[3] - 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. |
Driftward
Subdreddit
Test Alliance Please Ignore
101
|
Posted - 2013.05.22 14:53:00 -
[4] - 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. |
Driftward
Subdreddit
Test Alliance Please Ignore
115
|
Posted - 2013.05.26 20:18:00 -
[5] - 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 -
[6] - 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 -
[7] - 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 -
[8] - 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 |
Driftward
Subdreddit
Test Alliance Please Ignore
128
|
Posted - 2013.05.29 05:14:00 -
[9] - 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. |
Driftward
Subdreddit
Test Alliance Please Ignore
128
|
Posted - 2013.05.29 15:31:00 -
[10] - 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.... |
|
|
Driftward
Subdreddit
Test Alliance Please Ignore
128
|
Posted - 2013.05.29 21:38:00 -
[11] - 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 -
[12] - 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 -
[13] - 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 -
[14] - 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 -
[15] - 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.
|
Driftward
Subdreddit
Test Alliance Please Ignore
299
|
Posted - 2013.07.24 16:48:00 -
[16] - 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. |
Driftward
Subdreddit
Test Alliance Please Ignore
302
|
Posted - 2013.07.24 17:44:00 -
[17] - Quote
hydraSlav's wrote:Driftward wrote: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. They've added Amarr Commando skill in Uprising 1.3 Also, please add the following for me: "SkillsList" named range, identifies your column with all the skill names listed. "SkillsValues" named range, identifies your column with all the levels for the skills. Should be same size as previous one. Even if you already have named ranges for those columns, you can make these ones overlapping them. I will use that for import functions
Those names have been added to the ranges in the fitting import/export tab. The way it's set up, the spacing should exactly match the spacing for your skills tab in the fitting sheet. This means you can directly copy/paste values between those two sheets. That tab shows the currently selected character (if you have more than one saved) and gives the values of both quick level select and tabbed level select in one column. If you'd rather have a different setup for those ranges toss me an email. I'm not usually this quick replying to the forums.
Thanks for reminding me about the Amarr Commando skill, I'll add that as soon as I get a chance to look at the skill list in game and make sure that I can match the position correctly. |
Driftward
Subdreddit
Test Alliance Please Ignore
309
|
Posted - 2013.07.28 18:11:00 -
[18] - Quote
Updated for the Amarr Commando skill and added some technical changes to make certain portions of the sheet compatable with hydraslav's fitting tool. Hopefully I'll have some more work to do (aka more new dropsuits) coming in the next couple updates. I'll be more than happy to update when those come out.
Current version: v1.69 |
Driftward
Subdreddit
Test Alliance Please Ignore
344
|
Posted - 2013.08.09 19:00:00 -
[19] - Quote
KNOWN ISSUE in v1.69: Import script won't give the correct skill values from sheet v1.68;
Adding the commando skill added an extra row that isn't accounted for in 1.68, hence the shift in values when you load the new character. So, if you want to save your old skills and avoid re-entering everything....go into the saved character tab, add a new row between row 6 and 7 after importing your characters. That will make sure that your skills line up correctly.
Also, there was an issue of the load and save scripts not properly handling the weaponry skill after 1.69. This has been fixed as of now. (for those who are interested, also caused by adding an extra row of skills) |
Driftward
Subdreddit
Test Alliance Please Ignore
355
|
Posted - 2013.08.10 20:12:00 -
[20] - Quote
hydraSlav's wrote:Driftward wrote:KNOWN ISSUE in v1.69: Import script won't give the correct skill values from sheet v1.68;
Adding the commando skill added an extra row that isn't accounted for in 1.68, hence the shift in values when you load the new character. =ARRAYFORMULA(IF(ISERROR(VLOOKUP(A1:A,'Data Import'!A1:H226,4*SIGN(ROW(A1:A)),FALSE)),"",VLOOKUP(A1:A,'Data Import'!A1:H226,4*SIGN(ROW(A1:A)),FALSE))) Look up my replaceCharFromSheetNew() function Took me several days of research to get that to work
Ughhhh I was hoping to avoid reworking the scripts....now I may just have to, there goes my weekend.... |
|
|
Driftward
Subdreddit
Test Alliance Please Ignore
450
|
Posted - 2013.09.04 22:07:00 -
[21] - Quote
Hobo on Fire wrote:Cool tool. It looks like you still have at least one prerequisite problem though: the sheet has sidearm operation 3 as a requirement for SMG operation. SMGs only require sidearm operation 2.
You're totally right. Changing that in the current version now. I think I also need to go back into all the weaponry skills and some of the ammo/reload skill multipliers changed. When I get home, will work on it. |
Driftward
Subdreddit
Test Alliance Please Ignore
453
|
Posted - 2013.09.05 21:36:00 -
[22] - Quote
Updated to 1.4 skill changes. (ie the rapid reload is now 3x skill). Will be working on streamlining some of the scripts in anticipation of some new content (here's hoping) in 1.5 and at the very least some skill changes in the vehicle tree. |
|
|
| |
|