| Pages: 1 [2] :: one page |
|
|
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
hydraSlav's
Ostrakon Agency
Gallente Federation
237
   |
Posted - 2013.07.24 17:29:00 -
[31] - Quote
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 |
Driftward
Subdreddit
Test Alliance Please Ignore
302
|
Posted - 2013.07.24 17:44:00 -
[32] - 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 -
[33] - 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 -
[34] - 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) |
hydraSlav's
Ostrakon Agency
Gallente Federation
250
|
Posted - 2013.08.09 21:15:00 -
[35] - Quote
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 |
Driftward
Subdreddit
Test Alliance Please Ignore
355
|
Posted - 2013.08.10 20:12:00 -
[36] - 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.... |
Planetside2PS4F2P
Osmon Surveillance
Caldari State
25
|
Posted - 2013.08.11 19:01:00 -
[37] - Quote
Wow im so impressed |
Needless Sacermendor
Red Fox Brigade
369
|
Posted - 2013.08.30 20:48:00 -
[38] - Quote
black is a horrible colour for unused cells :-(
otherwise great tool +1 |
Hobo on Fire
Goonfeet
Top Men.
55
|
Posted - 2013.08.31 15:38:00 -
[39] - Quote
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. |
Driftward
Subdreddit
Test Alliance Please Ignore
450
|
Posted - 2013.09.04 22:07:00 -
[40] - 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 -
[41] - 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. |
DRE PrEaCh
Subsonic Synthetics
43
|
Posted - 2013.10.31 12:46:00 -
[42] - Quote
hey there just wanna say this is a great sheet. Really allows me to plan out my skills wisely. Thank you for your hard work |
|
|
| |
|
| Pages: 1 [2] :: one page |
| First page | Previous page | Next page | Last page |