|
Author |
Thread Statistics | Show CCP posts - 1 post(s) |
hydraSlav's
Pink Fluffy Bounty Hunterz Noir. Mercenary Group
2
|
Posted - 2013.03.29 21:35:00 -
[1] - Quote
ZiwZih wrote:Excellent work!
Changing values, though, gives an error message (something about changed permission) so going to File > Make a Copy... and then working in the new copy does the trick.
Yes, you have to make your own copy via "File -> Make a copy..." I could open the sheet for public editing, but that would just be a chaos with everyone changing values at once. Plus, once you make your own copy, whatever skills you've set will be saved for you.
In the upcoming release, i will make a new sheet for skills management so you could have multiple characters and switch between them
Damn... just released I posted the OP on the wrong character.... |
hydraSlav's
Pink Fluffy Bounty Hunterz Noir. Mercenary Group
2
|
Posted - 2013.03.30 02:20:00 -
[2] - Quote
I've added an FAQ section (3rd post).
If you have any questions on using this, please post here. I will try to answer all posts and will update the FAQ.
All suggestions and feedback is much appreciated too. And thanks for all the positive comments |
hydraSlav's
Pink Fluffy Bounty Hunterz Noir. Mercenary Group
3
|
Posted - 2013.03.30 15:58:00 -
[3] - Quote
Laheon wrote:D514FT? Doesn't quite have the same ring as EFT.
Maybe we can have a community naming contest :) |
hydraSlav's
Pink Fluffy Bounty Hunterz Noir. Mercenary Group
3
|
Posted - 2013.03.30 23:24:00 -
[4] - Quote
Maken Tosch wrote:I see a problem with the Ishukone Nova Knives. According to my math that I posted on my diary here the base CPU/PG is 48/8 without skills. With level 5 on Sidearm Weapon Upgrade and its Proficiency equivalent, that CPU should drop to 30gF. Quote: [Ishukone Nova Knives] -CPU: 48 gF 48x(1+(-0.25))=36 gF <--- with Sidearm Weapon Upgrade level 5 36x(1+(-0.15))=30 gF <--- with Sidearm Weapon Upgrade Proficiency level 5 -PG: 8 kW
The DFT that you have on Drive has the CPU listed at 45gF which is inaccurate. Can you double check to make sure that's accurate?
I found the issue. I had Knova Knives incorrectly categorized as "Light Weapon", so they weren't getting any Sidearm skills effecting them. As a matter of fact, in 2.0.3 you couldn't fit a Knova Knife into a sidearm slot even (only Light slot).
This is fixed in 2.0.4. Knova Knives are now Sidearm and I checked the fitting, it ends up as 30CPU now. I will update the OP now on the best way to upgrade to new version
Thanks for pointing this out. |
hydraSlav's
Pink Fluffy Bounty Hunterz Noir. Mercenary Group
8
|
Posted - 2013.04.01 01:49:00 -
[5] - Quote
Mechoj Nomreps wrote:One question,
Would it be possible to add the bpo's too?
Absolutely. Are you talking about the Dropsuit BPOs? (i am pretty sure i got all the weapon BPOs that were available on the market).
If someone can make a list specifying which BPO mimics which ISK-based suit, that would be much appreciated too. I haven't looked deeply into this, but from what i understand, the BPOs have the same stats as their ISK-based counterparts, please correct me if i am wrong
|
hydraSlav's
Pink Fluffy Bounty Hunterz Noir. Mercenary Group
10
|
Posted - 2013.04.01 14:22:00 -
[6] - Quote
2100 Angels wrote:Garrett Blacknova wrote:2100 Angels wrote:Garrett Blacknova wrote:2100 Angels wrote:This is ridiculously awesome dude. Any plans to include officer weapons?
EDIT: Also, why when I try to download this to save it as an excel sheet, do all the function equations break? Probably the same reason when I try to download it, I can't even open the resulting file in Excel. Original file doesn't actually match Excel's coding, and doesn't "fit" itself into Excel formatting properly. Yeah I got some strange "code malfunction at line xxx" or something when I tried to reopen it from the file...... is this not an original xlsx? Pretty sure the base file on Google Drive is a proprietary format. I've downloaded spreadsheets with functions intact from google drive before....
This spreadsheet was created in Google Drive from scratch. I've tried exporting to Excel and looks like the lookup functions are not coming over, in particular the FILTER(). Maybe it's proprietary to Google Drive, maybe it's because i am using Named Ranges...
I've also tried this on an iPad. It didn't work through the native Safari (although i didn't try any other browsers). I then tried the Google Drive App, and although it works, you cannot get the dropdown list to appear and have to type the full name of the module, which is a PITA.
If anyone has experience or suggestions to get this fixed, i am all ears
|
hydraSlav's
Pink Fluffy Bounty Hunterz Noir. Mercenary Group
10
|
Posted - 2013.04.01 17:46:00 -
[7] - Quote
Alina Heart wrote:Light Weapon Reload and Proficiency Increases the Time instead of decreases it. Easy to calculate by hand by simple subtraction but I still thought it was worth bringing to your attention.
Fixed in 2.0.5
Thanks for pointing this out!
|
hydraSlav's
Pink Fluffy Bounty Hunterz Noir. Mercenary Group
14
|
Posted - 2013.04.02 19:29:00 -
[8] - Quote
Released version 2.1.0 on April 2nd
New features: 2.1.0 - Implemented "Skills & Characters" sheet. The skills are no longer enterable on "Adv Fitting Tool". - Implemented online version check on "Simple Fitting Tool". Will check against the master. - Enabled Stacking Penalty on Damage Modifiers. - Added slot identifiers in big letters.
How to update from 2.0.5 (and below) to 2.1.0 - To update, make a copy of the new version with a different name (for example prefix the version number) - (Steps below are optional if you want to preserve your skills) - Copy your skills from the previous version's "Adv Fitting Tool" sheet doing the following: --- Click on A3, --- Scroll to A115 (don't click) --- Hold SHIFT and click A115 (you should now have A3:A115 highlighted) --- Then CTRL+C - Paste your skills into new version's "Skills & Characters" sheet by doing the following --- Right-click on first skill level of "Your Char1" (default is I5) --- Select Paste Special -> Paste values only
You can now select either of the 4 default starting characters. You now have an "All LVL5" character for all your theoretical testing . You can now update skills for 3 of your characters (more can be added by following the instructions on the "Skills & Characters" sheet). Don't forget to rename them . Your Character is selectable from the "Simple Fitting Tool" sheet same way you would select a Dropsuit.
I will warn against going wild with this however as the upcoming "Uprising" build of the game will change skills dramatically, and most of these will have to be re-entered.
The spreadsheet copy that you now make, will connect to the "master" spreadsheet and see if there is a newer version available. You will be prompted with a link to update that will take you to the new spreadsheet.
Enjoy
p.s. I will add the missing BPOs soonish |
|
|
|