You forgot to change the other sheets where you actually enter the data. But for anyone wanting to use it, they are decorative

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.

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.

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.

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

Some of your prerequisites are off. I know System Hacking requires Core Upgrades 4.

Append: It's also not calculating future SP values together.

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

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.

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

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

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.