Pages: [1] 2 3 4 5 6 7 8 9 10 11 12 :: one page |
|
Author |
Thread Statistics | Show CCP posts - 2 post(s) |
hydraSlav's
Pink Fluffy Bounty Hunterz Noir. Mercenary Group
18
|
Posted - 2013.04.03 00:05:00 -
[1] - Quote
After couple months of work, and beta testing, I am ready to present the:
Dust 514 Fitting Tool Short link: http://goo.gl/AU88Q Full link: https://docs.google.com/spreadsheet/ccc?key=0Aq6pdGj-zwyedDBIcnBpQXJLZlRBazQzUUU4YWExNGc
This is a Google Drive spreadsheet, which means that you will need to login to Google Drive and then do "File -> Make a copy" to save an editable copy for yourself.
To use, simply double click the green cells to select values, or start typing the module names in them.
Current Features: - *NEW* Skills and Characters sheet, allowing to save multiple characters, as well as preset ones such as "All LVL5" - *NEW* Online version check to inform you when the new version is available - Same layout as the in-game fitting screen UI - Advanced Fitting Tool mode, showing all calculations from base, after skills, after mods, after fitting, and the rounding. - Skills effecting your Dropsuit, Modules and Weapons stats - Fitting Skills giving reduction in fitting requirements - Proper stacking penalty calculation - Proper compounding bonuses - Indication of invalid fitting - Total cost of fitting - Accurate base data: market info data shows some values rounded only to 1 decimal place, whereas when you own the dropsuit, you can see the real values up to 2 decimal places. This makes a lot of difference.
Upcoming features - Weapon stats displayed in the Simple Fitting Tool sheet (right now, only fitting skills and stats are considered for weapons) - Vehicles *soon (tm)
Community suggested features (When these get moved to "Upcoming", you will know i am actively working on this) - "Clear all" button for fittings - Ability to have a few fittings saved at once (maybe 3 sheets) |
hydraSlav's
Pink Fluffy Bounty Hunterz Noir. Mercenary Group
18
|
Posted - 2013.04.03 00:05:00 -
[2] - Quote
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) - 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
Version History 2.1.0 - April 2nd 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.
2.0.5 - April 1st Fixed Rapid Reload and Rapid Reload Proficiency skills. They were increasing reload time instead of decreasing it. Added link to Chankk Saotome's Character Skill Planner
2.0.4 - March 30th Fixed Knova Knive category. It is now a Sidearm weapon and will be effected by sidearm skills
2.0.3 - March 29th Fixed issue where all weapon slots where using the fitting reduction bonus of the first Light Weapon slot. Fixed a display bug on 'Simple Fitting Tool' where modules' PG usage was displayed twice
2.0.2 Fixed 'Armor' attribute of 'Armor Plates' not giving bonus.
2.0.1 Fixed CPU/PG/Armor/Shield on a lot of dropsuits. If you have 2.0.0 and your base numbers don't match, get this version.
2.0.0 Implemented "Simple Fitting Tool" sheet
1.0.2 Fixed Dropsuit Command skill bonus. 5% -> -5% Fixed Shield Recharge Rate, Movement, Sprint and Stamina to 2 decimal places (from in-game fitting screen) for a lot of suits. Confirmed values in green. Renamed all suits to be inline with in-game names Fixed Scout B-Series Melee Damage. 135 -> 285 Fixed 'Toxin' SMG missing CPU/PG Fixed Issue where Medium and Large Grenade slots were marked "in use" when Small Grenade slot was used. Fixed Shield Control bonus. 3% -> 5%
1.0.1 Added yellow highlight to slots that are not available, before the red errors are displayed Total fittable weapons calculation for Heavy and Sidearm weapons should work correctly now Separated Light and Heavy Weapon slots Added support for two Light Weapon slots Reworked Grenade slots to be inline with other Weapon slots Renamed all slots to be inline with in-game names Added auto-calculated "Total" for available weapons and grenades Fixed Logistics suits high-slots, removed erroneous multiple grenade slots
1.0.0 Initial release |
hydraSlav's
Pink Fluffy Bounty Hunterz Noir. Mercenary Group
18
|
Posted - 2013.04.03 00:05:00 -
[3] - Quote
ver |
N1ck Comeau
Planetary Response Organisation Test Friends Please Ignore
204
|
Posted - 2013.04.03 00:19:00 -
[4] - Quote
I want to change the skills of my character but i don't know how can you tell me. I want to make this accurate.
|
Kreayshawn Coruscanti
Pink Fluffy Bounty Hunterz Noir. Mercenary Group
171
|
Posted - 2013.04.03 00:24:00 -
[5] - Quote
Sounds great :D |
hydraSlav's
Pink Fluffy Bounty Hunterz Noir. Mercenary Group
20
|
Posted - 2013.04.03 01:05:00 -
[6] - 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 Cool. 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 Blink. 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. |
hydraSlav's
Pink Fluffy Bounty Hunterz Noir. Mercenary Group
20
|
Posted - 2013.04.03 01:09:00 -
[7] - Quote
N1ck Comeau wrote:I want to change the skills of my character but i don't know how can you tell me. I want to make this accurate.
Nevermind. I'm an idiot sometimes.
Glad you figured it out, but for the benefit of everyone else out there:
- Go to "Skills & Characters" sheet - Change only the green cells in here - In the column that starts with "Your Char1", rename this to your character name - In the same column, populate your skills - Now, on the "Simple Fitting Tool", under Character dropdown, you can select your character.
|
hydraSlav's
Pink Fluffy Bounty Hunterz Noir. Mercenary Group
23
|
Posted - 2013.04.03 13:46:00 -
[8] - Quote
2100 Angels wrote:This is ridiculously awesome dude. Any plans to include officer weapons?
Adding weapons or suits is very easy. The difficult part is getting the stats. Even for items on the market, the stats are inaccurate as they are rounded off to 1 decimal point, whereas most stats have 2 decimal points when you actually own them and equip them
If you have the stats for specific officer weapons that you want, please post them here or send them to me in-game, and I will definitely include them |
hydraSlav's
Pink Fluffy Bounty Hunterz Noir. Mercenary Group
23
|
Posted - 2013.04.03 15:58:00 -
[9] - Quote
Done
Released version 2.1.1 on April 3rd
New features: 2.1.1 Added Militia suit BPOs (same stats as non-BPO) Added Type-I suit BPOs (same stats as non-BPO) Added all 'Neo' suit AUR variants (same stats as non-AUR counterparts) Added yellow highlight to "Click for update" message
|
Kreayshawn Coruscanti
Pink Fluffy Bounty Hunterz Noir. Mercenary Group
173
|
Posted - 2013.04.03 22:06:00 -
[10] - Quote
Can't wait to get the new suit stats for this |
|
|
CCP Eterne
C C P C C P Alliance
1246
|
Posted - 2013.04.04 12:24:00 -
[11] - Quote
Glue applied. |
|
MJ O'Mally
Planetary Response Organisation Test Friends Please Ignore
4
|
Posted - 2013.04.04 12:34:00 -
[12] - Quote
Hi hydra, firstly, great tool and thanks for sharing it.
Might have a small bug. I've selected the dragonfly suit and when I insert my chosen weapon then add in my sidearm it gives an error saying I've got too many light weapons. Both are in the correct slots. 1 for L and 1 for S.
Hope this makes sense to you?
Cheers........MJ |
hydraSlav's
Pink Fluffy Bounty Hunterz Noir. Mercenary Group
38
|
Posted - 2013.04.04 13:22:00 -
[13] - Quote
CCP Eterne wrote:Glue applied. Thank you, much appreciated
MJ O'Mally wrote:Hi hydra, firstly, great tool and thanks for sharing it. Might have a small bug. I've selected the dragonfly suit and when I insert my chosen weapon then add in my sidearm it gives an error saying I've got too many light weapons. Both are in the correct slots. 1 for L and 1 for S. Hope this makes sense to you? Cheers........MJ
Were you using Knova Knives in the Sidearm slot? I've found the issue. A few fixes back, I've re-categorized Knova Knives from Light Weapon to Sidearm in terms of skills and which slot they appeared in, however I did not fix the slot that was used-up by them for the purposes of dropsuit validation.
This is fixed in 2.1.2. Your "Simple Fitting Tool" sheet should show an update is available.
2.1.2 - April 4th Fixed Knova Knives to actually use Sidearm slot instead of Light Weapon slot when validating dropsuit fitting
If you have an issue with something other than Knova Knives, please let me know and I will debug further. Thanks for bringing this to my attention. |
Daddrobit
Pink Fluffy Bounty Hunterz Noir. Mercenary Group
285
|
Posted - 2013.04.04 17:05:00 -
[14] - Quote
Awesome job on getting stickied Hydra! |
Arkena Wyrnspire
Turalyon Plus
16
|
Posted - 2013.04.05 21:34:00 -
[15] - Quote
Wow, this is fantastic. |
xAkantor
Expert Intervention Caldari State
5
|
Posted - 2013.04.06 01:32:00 -
[16] - Quote
Does the damage stats take into account the stacking penalties of damage mods?
Also, not sure if it shows but could you add a skill point total? Like how many skill points were used per skill? Have it show a total amount of skill points spent for the skills showing. |
hydraSlav's
Pink Fluffy Bounty Hunterz Noir. Mercenary Group
48
|
Posted - 2013.04.06 05:25:00 -
[17] - Quote
xAkantor wrote:Does the damage stats take into account the stacking penalties of damage mods?
Also, not sure if it shows but could you add a skill point total? Like how many skill points were used per skill? Have it show a total amount of skill points spent for the skills showing.
Also, can you see if you can add the AV Grenade direct damage stat? I know it would be hard to get the damage for all of them, I believe you can do it though!
There are compounding bonuses from skills and modules, and stacking penalty on all modules that have it specified (which at this point is every % bonus dropsuit module). There was an issue specifically with damage mods (not any other module) where i disabled stacking penalty on them in the beginning. This was supposed to be fixed in 2.1.0 but is really fixed in 2.1.4
I like the idea of calculating total SP for the currently configured skills. I will add that to the backlog (but this is a Fitting tool first and foremost, so can't promise when i will get to that)
As for AV nade direct damage, i'd like that too :) In a month a new build is coming that would hopefully give us a better in-game fitting tool that would show all stats. CCP also promised to release a table of all item stats before that. |
hydraSlav's
Pink Fluffy Bounty Hunterz Noir. Mercenary Group
51
|
Posted - 2013.04.07 03:49:00 -
[18] - Quote
I've been making a few bugfix and content updates for the past couple of days, but today, we get a new feature:
Weapon stats are now displayed on the main Simple Fitting Tool sheet. These are fully affected by skills, modules, and stacking penalty (note: these were already available on the "Adv Fitting Tool" sheet)
2.2.0 - April 6th Implemented Weapon Stats display below the dropsuit (the values displayed are after skills, modules and stacking penalty are applied). Removed second Light Weapon slot from Simple Fitting Screen (it was there for the `Black Eagle` suit, but now I realise it works differently). Fixed display bug not showing PG consumption of bottom-most Equipment slot (calculations were still correct). Re-added red highlight to "INVALID FITTING" text (probably was broken since 2.1.0) Removed ISK cost from 'Exile' AR. Added missing Allotek Flux Grenade stats Changed all initial category texts to "--- EMPTY ---"
2.1.5 Added missing 'Black Eagle' AR and Shotgun Max Ammo and Reload Time Fixed Mass Driver and 'Tsunami' Mass Driver Damage values
2.1.4 Fixed missing "Type" for modules' attributes that currently have no associated modules (however this was causing the weapon stats to show up blank) Really enabled Stacking Penalty on Damage Modifiers (this was not done in 2.1.0)
2.1.3 Added 'Black Eagle' dropsuit, 'Black Eagle' Shotgun and 'Black Eagle' Assault Rifle Added 'Exile' Assault Rifle, 'Syndicate' SMG, HK4M Shotgun Added missing weapon stats (Damage, ROF, etc) for most weapons (only visible on "Adv Fitting Tool" for now) |
Kevall Longstride
DUST University Ivy League
157
|
Posted - 2013.04.07 18:44:00 -
[19] - Quote
Thanks for creating this. I've the thread in our own forums as its a good training tool. o7 |
Maken Tosch
Planetary Response Organisation
1936
|
Posted - 2013.04.08 20:32:00 -
[20] - Quote
CCP Eterne wrote:Glue applied.
Dev glue is always better than crazy glue. |
|
hydraSlav's
Pink Fluffy Bounty Hunterz Noir. Mercenary Group
67
|
Posted - 2013.04.09 13:36:00 -
[21] - Quote
Kevall Longstride wrote:Thanks for creating this. I've the thread in our own forums as its a good training tool. o7
Glad you like it and use it. Gives me motivation to continue to improve this. Please post here any feedback/suggestions/questions and/or bugs.
Speaking of improvements, here is what I am working on for the next release: - "Reset" fitting button - done - "Load/Save/Delete" fitting buttons - done - "Add Character Slot" button - done - Button to give ability to copy characters/saved fittings from previous versions after the update - still working on this.
|
Chankk Saotome
SyNergy Gaming EoN.
212
|
Posted - 2013.04.09 15:14:00 -
[22] - Quote
Man... I gotta figure out how to do GoogleDocs and drop-boxes and all the fun nifty stuff they've got on there. Way more concise and compressed than the mess of a sheet I've built.
Hopefully I can totally rework the Skill Planner after the new build and get that posted up here in General where people are more likely to see it.
Keep up the great work hydraSlav's |
Beren Hurin
OMNI Endeavors O.M.N.I. Initiative
358
|
Posted - 2013.04.11 17:45:00 -
[23] - Quote
So HydraSlav, one thing I want to try to simulate is a timeline representing hypothetical damage scenarios and tanking scenarios.
I think people don't really respect the benefit of Armor as much as they should, or regen-tanks as much as they should.
Showing the merits of a variety of fittings and their ability to operate in different environemnts could reveal some good data. |
slap26
Pink Fluffy Bounty Hunterz Noir. Mercenary Group
539
|
Posted - 2013.04.11 23:26:00 -
[24] - Quote
should have moved this to the training room,
But more people will see it if it was left in the General Discussion. |
Artificer Ghost
Bojo's School of the Trades
9
|
Posted - 2013.04.11 23:49:00 -
[25] - Quote
You seem to have a typo... Not a big deal, but I don't miss a lot of details.
In the 'Character' box in the middle of the Speadsheet, it has all the classes, and 'Arbiter' is spelled wrong. You spelled 'Arbitrer. :)
Other than that, great tool! Question: Does the whole spreadsheet update if you change the 'Dropsuit' section? That'd be so much easier, use-wise. :P |
hydraSlav's
Pink Fluffy Bounty Hunterz Noir. Mercenary Group
72
|
Posted - 2013.04.12 00:42:00 -
[26] - Quote
Yeah, took me a while to figure out where the thread went. I'd rather if it was in Rookie Training Grounds.
Beren Hurin wrote:So HydraSlav, one thing I want to try to simulate is a timeline representing hypothetical damage scenarios and tanking scenarios.
I think people don't really respect the benefit of Armor as much as they should, or regen-tanks as much as they should.
Showing the merits of a variety of fittings and their ability to operate in different environemnts could reveal some good data.
I know what you are talking about. I saw something like this in EFT, and even in the old Eve-Fit (who remembers that?). I will see if i can do something like this (not any time soon however... the Uprising will have a lot of changes to catch up on).
"Artificer Ghost " wrote:In the 'Character' box in the middle of the Speadsheet, it has all the classes, and 'Arbiter' is spelled wrong. You spelled 'Arbitrer. :)
Other than that, great tool! Question: Does the whole spreadsheet update if you change the 'Dropsuit' section? That'd be so much easier, use-wise. :P
I will fix the typo, thanks for reporting
As for Dropsuit, if you mean "do all displayed stats reflect the currently selected dropsuit?", the answer is yes. You can change the dropsuit at any time, and the whole spreadsheet will recalculate based on the new dropsuit. Similarly, you can change the character/skills at any time, and everything will recalculate. If you change to a lower skilled character that no longer has enough CPU/PG, the dropsuit validation will turn red indicating "Invalid Fitting".
In the coming version, there are buttons to save/load fittings, as well as "reset" button to clear all modules
|
Artificer Ghost
Bojo's School of the Trades
9
|
Posted - 2013.04.12 01:27:00 -
[27] - Quote
Alright. Just wondering, I'm running Windows 7 and using Chrome as my default browser, should I have downloaded it as a Windows Excel file? I don't see the CPU/PG bar and the slots/stats/etc isn't automatically updating. :P |
hydraSlav's
Pink Fluffy Bounty Hunterz Noir. Mercenary Group
72
|
Posted - 2013.04.12 02:49:00 -
[28] - Quote
Artificer Ghost wrote:Alright. Just wondering, I'm running Windows 7 and using Chrome as my default browser, should I have downloaded it as a Windows Excel file? I don't see the CPU/PG bar and the slots/stats/etc isn't automatically updating. :P
"FAQ" wrote:Q: I can't change any values / I get permission error, what to do? A: This is a Google Drive spreadsheet. Before you can use it, you need to be logged in to Google Drive, then select "File -> Make a copy..."
Unfortunately, when downloaded as Excel, some lookup formulas don't get converted, which makes the whole thing useless. The only way to use it is online through Google Drive. And not on the "master" spreadsheet, but by making your own copy. The benefit to making your own copy (besides ability to change fields) is that your Characters and Fittings remain private to yourself.
I could have enabled public editing, but that would have been a chaos with everyone changing stuff at the same time.
Now, if you haven't already made a copy, give me a little time, i am about to release the next version that has many UI improvements including saving/loading of your fittings.
|
hydraSlav's
Pink Fluffy Bounty Hunterz Noir. Mercenary Group
72
|
Posted - 2013.04.12 06:43:00 -
[29] - Quote
Version 2.3.0 is released. This one is all about the UI. Please note some of these scripts can take a while to run. Please don't modify values while the script is running. There are confirmation popup dialogs when the scripts finish.
You now have Saved Fittings management buttons. There is also the ability to import data from previous spreadsheets. Please note the import will overwrite existing data.
You can import Character skills data from your previous spreadsheets. You can also import Saved Fittings from other spreadsheets, but since no version prior to this one had it, it will only be useful in the next release.
However, corps can use this feature to come up with standard fittings for CB or whatnot, and share it with the members
2.3.0 Implemented button 'Save As' to save a new fitting or make a copy of fitting Implemented button 'Save' to save/overwrite as currently selected fitting Implemented button 'Load' to load currently selected fitting Implemented button 'Delete' to delete currently selected fitting Implemented button 'Reset' to remove all modules Implemented button 'Import' to import fittings from earlier/other spreadsheets (would only work on spreadsheets at 2.3.0 and above) Implemented button 'Add Character Slot' to insert new character slot Implemented button 'Replace Character Data' to bring over your character data from earlier/other spreadsheets Unfroze top 4 rows on 'Simple Fitting Tool' to better position new buttons. Let me know if this is cause issues for anyone Fixed spelling of 'Arbiter' starting character Added Fused Locus Grenade |
Artificer Ghost
Bojo's School of the Trades
10
|
Posted - 2013.04.12 19:45:00 -
[30] - Quote
Ok, when I get back on a PC, I'll try that. It probably only let me download (everything else was greed out) because I wasn't logged into Drive. :P
Thanks for the help! |
|
|
|
|
Pages: [1] 2 3 4 5 6 7 8 9 10 11 12 :: one page |
First page | Previous page | Next page | Last page |