| Pages: 1 2 [3] 4 :: one page |
|
|
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
hydraSlav's
Ostrakon Agency
Gallente Federation
171
   |
Posted - 2013.05.29 03:45:00 -
[61] - Quote
Driftward wrote:
1. The version updater from hydraslav's fitting tool. How he found out about this function I have no idea, but it's a nice implementation. Also, pretty easy to reverse engineer (the "key" is in the url of your page, literally says "key=....")
Hehe, glad you liked it 
|
Chankk Saotome
SyNergy Gaming
EoN.
323
|
Posted - 2013.05.29 11:04:00 -
[62] - Quote
Driftward wrote:
1. The version updater from hydraslav's fitting tool. How he found out about this function I have no idea, but it's a nice implementation. Also, pretty easy to reverse engineer (the "key" is in the url of your page, literally says "key=....")
I want this!!! But so much stuff going on suddenly that even the updater as a whole is lagging behind... Not that there's much to update, but those "Near Future" elements are quickly becoming SOON*tm
Driftward wrote:
2. Filiter function: I JUST added this. I think it's pretty nice and cuts down on the clutter. Add a seperate column and make a formula that tosses a 1 if the skill is being used and a 0 if it's unused. Put a filter function on the "check box" column and voila.
Not really even sure what this means... but sounds intreaguing.
Drfitward wrote:
3. Conditional formatting for pre-reqs: I realize you already have a nice implementation of your pre-reqs but I think that the strikethrough is a little....unappealing? Hard to see visually? W/e at any rate, I think that conditional formatting for that particular aspect is quite nice and doesn't require reformatting all of your pretty colors either.
Strikethrough XXXXX only stands for skills that don't actually exist yet but are confirmed in the works. Prerequisites should only show "Unavailable". I'll check to confirm this though while I look at it and consider how to recolor Weaponry. (That tab really looks horrible after REALLY looking at it rather than just throwing it down like I did.
Also, I like your CREDITS page. It does what I had considered as a [User's Manual] and I might include all of that in a tab on the end like you've done if you don't mind.
|
Driftward
Subdreddit
Test Alliance Please Ignore
128
|
Posted - 2013.05.29 16:05:00 -
[63] - Quote
Heads up.
WE have an issue. SP is not translating well between the game and our spreadsheets. I just double checked both of them and they are both off (underestimating how much you can get at least but off none the less). I think it's because CCP changed the amount of SP required for levels (independent of the multipliers). I have to check though.... |
Sean Monaghan
Sinq Laison Gendarmes
Gallente Federation
0
|
Posted - 2013.05.29 19:46:00 -
[64] - Quote
What`s that [BASE] at very top stands for ? And "-20% Spreadsheet CPU/PG usage per lvl" ?
edit : Great job for that planner ! |
Chankk Saotome
SyNergy Gaming
EoN.
323
|
Posted - 2013.05.29 22:07:00 -
[65] - Quote
Driftward wrote:
Edit: I was being an idiot and missed a couple multipliers that I f***** up in the new weapons and just generally being an idiot (mixing spreadsheets with 8 hours of studying leads to idiocy apparently....That said, your point totals for multipliers above 1 are slightly wonky (I don't know if that's by design or what...) You have these extra subtractions by like 20 and 40 sp that aren't necessary....
That's... weirdness... Basically I figured the relationship between the base 6220 for lvl1, how that relates to lvl 2, 3, 4, 5... It's not quite a perfect exponential growth so I had to add those -10, -20, to make them match the exact number.
Those are then linked down to multiply by the skill multiplier itself...
So... lvl 1 skill with 2 multiplier is the 6220*2, level 2 is ((6220^3 or whatever)-10)*2
It's a bit of a mess but I did this thinking forward about how CCP might change things and this way rather than having to rewrite every number every time, I can change just one element and all the calculations self-update correctly as far as I can tell.
Sean Monaghan wrote:What`s that [BASE] at very top stands for ? And "-20% Spreadsheet CPU/PG usage per lvl" ?
That is actually just a test line I used to make sure all the calculations and functions work across the board... I left it in but rather than just being a non-skill empty block I decided to throw in a little joke for myself and the other spreadsheet guys like hydraSlav's and Driftward. They got it so I'm just gonna leave it :P |
Driftward
Subdreddit
Test Alliance Please Ignore
128
|
Posted - 2013.05.29 22:36:00 -
[66] - Quote
Apparently CCP thought that was too difficult and decided to say F*** it. They use a straight multiplication system to move to the different sp totals from the base stats on a 1 x skill. Not that it makes a big enough difference to actually effect if you can get a skill or not....just makes for some weird numbers down the line. and like a thousand skill point difference overall... |
Chankk Saotome
SyNergy Gaming
EoN.
324
|
Posted - 2013.05.31 09:25:00 -
[67] - Quote
Among other things:
_0.8.38_(Uprising_5-31)
Complete recolorization of Skills, Modules, and Equipment tabs
Added tabs for Dropsuits, Vehicles, and Vehicle Modules though I still need to collect data
Renamed 'Modules' tab to 'Dropsuit Modules'
Begin data collection for Weaponry, Vehicles, and Vehicle Modules tabs
Added Manual and Credits tab to the end of the spreadsheet. I really need to have level 3-4 Spreadsheet Ops to work on this thing now.
Next version will be FULL colorization finally, just need to get ALL market data... Then I'll finalize CPU/PG info for everything... Then put in the skill requirements and availability of weaponry... That will be 0.8.4 I suppose. |
Driftward
Subdreddit
Test Alliance Please Ignore
129
|
Posted - 2013.05.31 16:26:00 -
[68] - Quote
This might be helpful to you Chankk. Just have to fill in some of the gaps that CCP ommitted.
https://docs.google.com/spreadsheet/ccc?key=0AjhtV2Pl_-oLdExRYnM2TFpOaVN6bC1zdS13RmZPa3c&usp=sharing |
hydraSlav's
Ostrakon Agency
Gallente Federation
178
|
Posted - 2013.05.31 20:25:00 -
[69] - Quote
Yeah, i've got my data from that same spreadsheet, however it's missing CPU/PG for modules, and Slot Layouts for suits.
You can just steal the data from my spreadsheet. I've got most of the modules' CPU/PG filled in, and i've got the real damage from in-game as well (it wasn't a clean 10% boost as CCP said).
And grats on the sticky |
Chankk Saotome
SyNergy Gaming
EoN.
325
|
Posted - 2013.06.04 11:24:00 -
[70] - Quote
hydraSlav's wrote:Yeah, i've got my data from that same spreadsheet, however it's missing CPU/PG for modules, and Slot Layouts for suits.
You can just steal the data from my spreadsheet. I've got most of the modules' CPU/PG filled in, and i've got the real damage from in-game as well (it wasn't a clean 10% boost as CCP said).
And grats on the sticky
Thanks so much for giving me permission. Unable to log in means not being able to just do my own research but I trust your numbers there.
I promise I AM still working on this. The sticky doesn't mean I'm finished by a long shot. Some will note I've been colorizing the current version as it goes on nearly a daily basis. I've added weapons. I need to add in level prerequisites for weaponry.
I'd also like to talk with hydraSlav's about possibly writing up something to link each weapon skill level prereq for his sheet to actually chart out a min-max skill plan to match a dropsuit design made on his tool... I need to figure out how to get his functions and links to work properly offline on OpenOffice first before trying to link it to my own data and ideas but it would be pretty sweet to just merge these two somewhere and make one single ultimate planner.
That's a side project in the corner of my mind until I really finalize the Skill Planner here... or at least solidify all the data we currently have right now. Still need vehicle elements among others...
Seriously, you guys have no idea. And I'm sure hydraSlav's puts more work into his than I do into mine. His functions and linkage elements are just utter madness. Someone give that man a medal. |
|
|
Chankk Saotome
SyNergy Gaming
EoN.
372
|
Posted - 2013.06.11 11:31:00 -
[71] - Quote
New update is taking.... a while.
I'm basically working 100% offline on a full new version. Will upload and fully colorize that when I'm done and then revise the link to connect to the new version. Don't expect colors to look too differently but tabs should look cleaner as should skill effects, skill bonus modifiers, module modifiers. It will include Equipment, Modules, and Weaponry fully completed with prereq skill listings (which I use to calculate out skill requirements for specific fittings). Still short on Vehicles and Vehicle Modules.
It will have a prototype page of my auto-planner based on loadouts... I'm trying to figure out how you might import the data straight from hydraSlav's tool into a page so that you can see on the secondary fitting skill page exactly what skills are necessary. Hopefully once I get my thing up hydraSlav's can take a look at it and think of a way to get them to work. His isn't written to work outside of GoogleDocs as far as I can tell and it's really too complex for me to rewrite the whole thing to make it do so.
As for fitting skill requirements it's actually weird, rather than working down the nodes you have to work backward to calculate for prerequisites. It will be based specifically on the equipment and loadouts itself but thinking of a way for it to also calculate what Electronics/Engineering you would require to get enough CPU/PG in order to fit things to a specific suit... and how to display if it's simply not possible... Would therefore require that I at least calculate out the suit and module CPU/PG effects which means interesting function elements for CPU and PG expansion modules.
Seriously, lots of work, lots of maths, lots of learning new functions in Spreadsheet (I use OpenOffice... deal with it)
Now that I've got LOOKUP and ISERROR figured out I'm groovin pretty nicely. A lot of safety net redundancies but thankfully you will never have to see any of that.
Anyway, it will be a whole new version when it's done, probably jump right up to 0.85 with such severe changes... I've been naming them based on the build title and I don't want to stick a proper 1.0 on it till at least all suits (or their skills) exist in-game... That will be a day of celebration indeed.
I just felt everyone deserved to know why I had been messing with colors and suddenly stopped seeming to work on this for the past week or so. |
hydraSlav's
Ostrakon Agency
Gallente Federation
202
|
Posted - 2013.06.12 15:47:00 -
[72] - Quote
Hey Chankk, i've sent your a share request to your tool. You can ignore the request, but now you have my email address. Please reply.
I've got a prototype working with importing of the skills from your tool, however there are a few things that need to be ironed out. |
TAK3RoftheSOUL
Intara Direct Action
Caldari State
0
|
Posted - 2013.06.14 17:29:00 -
[73] - Quote
This is a very use full tool to have and I applaud the time and energy you used to make this! Just one pointer, and maybe I just didn't see it, but a reference to what the colors of the chart reference would be helpful |
TAK3RoftheSOUL
Intara Direct Action
Caldari State
0
|
Posted - 2013.06.14 20:31:00 -
[74] - Quote
This is a very use full tool to have and I applaud the time and energy you used to make this! Just one pointer, and maybe I just didn't see it, but a reference to what the colors of the chart reference would be helpful |
Dard Sifas
Digital Mercs
0
|
Posted - 2013.06.15 00:45:00 -
[75] - Quote
you've done a great work. thanks for this. |
Alikar Mougar
Kameira Lodge
Amarr Empire
0
|
Posted - 2013.06.19 07:23:00 -
[76] - Quote
Be your own Judge. What game looks like more fun to you? Dust.........Or this.........
Planetside 2
Coming to PS4 this year
Insane Infantry Push
Amazing Night Battle
Night to Day Canyon Battle
Intense Field Battle
Desert Infantry Line
Huge Desert Tank Battle
100 Tank Convoy
150 man Air Raid
65/0 Kill streak in the air
NC Montage
Factions Explained |
Valkary Rising
Zumari Force Projection
Caldari State
3
|
Posted - 2013.06.19 22:56:00 -
[77] - Quote
Amazing work keep it up +1 |
Davey Newcome
Ostrakon Agency
Gallente Federation
0
|
Posted - 2013.06.22 23:07:00 -
[78] - Quote
Great work thanks |
ALAINAgg
Zumari Force Projection
Caldari State
3
|
Posted - 2013.06.24 01:07:00 -
[79] - Quote
Thanks |
PLANETSIDETOOonPS4
Brutor Vanguard
Minmatar Republic
0
|
Posted - 2013.06.27 02:01:00 -
[80] - Quote
This thread is so insightfull. |
|
|
Chankk Saotome
SyNergy Gaming
EoN.
410
|
Posted - 2013.06.27 14:45:00 -
[81] - Quote
Okay, this is driving me utterly insane.
I've had some things happening which have slowed me down with this and other personal projects.
Currently I've got the updated sheet, it's got manual loadout entry for all weapon slots, grenade, 5 high, 5 low, and 4 equip... By entering in whatever modules and suit you should want by clicking on the option tab it will auto-calculate out the skills required and SP totals of course. On top of that, I've done a messy bit of function which will also bump up your Engineering and Electronics should more CPU/PG be required for said fitting and if it's simply not possible it will give a VOID or Insufficient warning.
This is based off of modular effects and base CPU/PG bonuses. It does not account for other skills which may lower equipment levels to auto-calculate other possibilities as it's already a bit of a mess. I will be writing another function list for each PG/CPU lowering skill to affect these later but that element will unfortunately be a manual entry at that point.
Life is... complicated. I'm busy with a lot of things right now and I hope you guys can all understand. I really wish I could make this everything it is inside my head but as I've said I'm literally learning this as I go and it's taken me days to just get what I have done.
I will be uploading and colorizing it in GoogleDocs tomorrow and it should be fully ready for release some time after Friday's downtime.
I apologize for delays and I am also sorry it is not all that I may have promised or intended.
I can't get it to auto-draw from hydraSlav's work but he has my full permission to just cut and copy any sheets or pages of my own work he wants to just import into his own tool to combine them if he's interested.
I have too many other things driving me mad right now to let a personal side project like this get so frustrating it's no longer fun so I'll probably be taking a break from it after I get what's done up, at least until new changes or news and ideas from hydraSlav's.
Again, I apologize for all of this guys and hope no one is too disappointed. |
Chankk Saotome
SyNergy Gaming
EoN.
411
|
Posted - 2013.06.29 11:29:00 -
[82] - Quote
_0.8.40_(Uprising_6-30)
A few coloring retouches and revisions.
Added Fittings Calculator to allow auto skill requirement calculation for various module setups
(manual entry only currently. Simply impossible to load in from hydraSlav's tool as it would require full merge of the two projects and his doesn't work offline)
Included skill adjustments to display proper Weapons CPU/PG usage after skills.
Added vehicles and skill requirements.
New function for skill availability tested on Dropsuit tab (I apologize for the big color bar, but GoogleDocs won't let me copy just the function to all cells)
Learned that, undoubtedly, GoogleDocs is the worst spreadsheet program ever created, which is why:
Maintaining full 100% offline capacity. At least for OpenOffice and I believe Excel.
I'm taking a break from all of this for a while guys. Will watch comments on errors and hopefully get back into updating and correcting things after the next big release. I still need to fix the dropsuit colors again but I'm just so tired of it all at the moment that I need some space. |
dannyMasters11
Vherokior Combat Logistics
Minmatar Republic
0
|
Posted - 2013.07.12 10:10:00 -
[83] - Quote
TAK3RoftheSOUL wrote:This is a very use full tool to have and I applaud the time and energy you used to make this! Just one pointer, and maybe I just didn't see it, but a reference to what the colors of the chart reference would be helpful
What he said +1 |
Beren Hurin
K-A-O-S theory
726
|
Posted - 2013.07.18 14:35:00 -
[84] - Quote
Are your scan radius' on suits correct? I'm logi so i don't know... They are showing 2 or 3 m except for heavy suits which are 10m. |
Chankk Saotome
SyNergy Gaming
EoN.
489
|
Posted - 2013.07.26 10:08:00 -
[85] - Quote
Beren Hurin wrote:Are your scan radius' on suits correct? I'm logi so i don't know... They are showing 2 or 3 m except for heavy suits which are 10m.
Sorry about that. These numbers were taken from the CCP Marketplace Data Dump which was about 80% wrong from day one. hydraSlav's, I, and many others have been slowly working through it to edit and fix it but those numbers weren't really that important for what I was doing so I forgot to rectify that.
All suits have a flat 10.0m scan radius base, one of those silent tweaks CCP made without telling us. |
hydraSlav's
Ostrakon Agency
Gallente Federation
238
|
Posted - 2013.07.29 03:03:00 -
[86] - Quote
Hey Chankk, if you are updating your tool, can you 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.
They don't need to be in any special format or order, just names and levels.
Thanks |
Bears Beets
Subdreddit
Test Alliance Please Ignore
616
|
Posted - 2013.07.31 19:09:00 -
[87] - Quote
Hey, Channk. I just wanted to pop by and say that some of your values seem to be off. I couldn't pinpoint it, but I was getting some funny numbers.
When I plugged in my current build, the SP difference between the spreadsheet and in-game was 1,650 SP. Minimal, I know. I don't know where that SP difference would be coming from.
I double checked and triple checked just to make sure it wasn't user error.
Thanks so much for making this spreadsheet though, bud. It's awesome stuff. I especially like the formatting of it. |
Planetside2PS4F2P
Osmon Surveillance
Caldari State
19
|
Posted - 2013.08.10 02:47:00 -
[88] - Quote
Awesome tool |
Beren Hurin
The Vanguardians
1323
|
Posted - 2013.09.01 00:02:00 -
[89] - Quote
Handheld weapon upgrades is wrong in the description and on the CPU stats for all the weapons. It only affects CPU for the damage mods and not the weapon. |
daishi mk03
Brutor Vanguard
Minmatar Republic
324
|
Posted - 2013.11.11 10:51:00 -
[90] - Quote
You can't plan anything, since depandencies are only checked for "current", not for "planned". So I can't plan "Shield Extensions", after I planned "Shield Upgrades". |
|
|
|
|
| |
|
| Pages: 1 2 [3] 4 :: one page |
| First page | Previous page | Next page | Last page |