|
|
| Author |
Thread Statistics | Show CCP posts - 2 post(s) |
Chankk Saotome
SyNergy Gaming
EoN.
212
   |
Posted - 2013.04.09 15:14:00 -
[1] - 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 |
Chankk Saotome
SyNergy Gaming
EoN.
263
|
Posted - 2013.05.13 10:46:00 -
[2] - Quote
Uprising Dropsuit Data Charts
Cleaned up from the mess we had posted. After the good word from hydraSlav's on my Skill Planner, I figured |
Chankk Saotome
SyNergy Gaming
EoN.
276
|
Posted - 2013.05.14 11:42:00 -
[3] - Quote
I've actually gone through and checked all the numbers and added the High/Low/Equip/Weapon slots manually. This means I could only look at the stats of suits either on the market or that I actually have myself in assets. An explanation for why I don't have Vanity Suit slots (though they match their respective level).
I'm really disappointed I never got those back but as they have heavy Skill requirements they're as useless to me as two of three MAG suits I collected.
I also gathered all the specific skill bonuses for my own Skill Planner the same way.
I have way too much free time and spend too much DUST time just gathering numbers. |
Chankk Saotome
SyNergy Gaming
EoN.
276
|
Posted - 2013.05.14 15:55:00 -
[4] - Quote
Never were my thing... My friend Nod Keras had a damage calc based on old Chromosome but don't think I've checked the marketplace data dump sheet to get weapon numbers to help design a new one...
I'm also a bit lazy about certain things I know are likely to change drastically at any moment like modifier %'s... I'm still waiting to see the proper stacking penalties math'd out, or at least get an idea of reduction percentages. There have been a lot of presumptions made from EVE-side, but don't know if anyone's got it quite down here in DUST as the whole situation is a bit of a mess.
Heck, I haven't even used Scanner Modules to re-write that little writeup on General Tactics Overview...
I think a lot of that info and advice still stands, but I need to discuss with more people as I'd like to add a writeup on different benefits of each separate race. A lot of work ahead if I even bother with half of it to be honest.
Several projects may just drop dead if IWS and the QQers get their way in destroying my Min Logi suit just because the Caldari Logis are the most broken thing since.... well... something really, really broken. |
Chankk Saotome
SyNergy Gaming
EoN.
280
|
Posted - 2013.05.15 14:59:00 -
[5] - Quote
This will be mad useful when I add in item availability related to skill levels to my sheet... from every single skill effect, modifier, and all equipment, module, and weapon data gathered and listed... manually...
Except that my whole spirit and desire to help the DUST community has quite thoroughly been stomped into the ground the past week with the Logistic witch-hunts. "He's yellow! BURN HIM!"
I know it's just redundant listings of some of what you've got there, and what others have posted, but for a while I was interested in it. Now I just want the headaches from all these people to go away which is unlikely as when I open my eyes they're still there, QQing and screaming to ruin other people's gameplay styles because of one clearly poorly designed and heavily abused mechanic. |
Chankk Saotome
SyNergy Gaming
EoN.
284
|
Posted - 2013.05.16 09:12:00 -
[6] - Quote
hydraSlav's wrote:Ahh bummer! It's missing grenades info. Do we just assume each suit has 1 grenade? Small for Scout Medium for Logi Large for Heavy What about assault? It's a medium frame, but last build it had "small" grenades
There's only the one grenade size type as it stands now and everybody gets one...
Also, that function doesn't seem to calculate out properly for me. It starts dropping off well before 1.
0.5^(((n) / 2.22292081)^2)
If I could get some numbers on bonuses I could figure out the raw % and find the function to match the graphed curve as well... I had heard it was like 100%, 88%, 69%, 25% or something... and the closest I can just fiddle around with to get near there is... Everybody take a deep breath...
1*(((1/10)^(n-1))^((5*2^(n-2))/100))
(Also, someone please make that prettier... I have no idea how I even got there... blegh)
N being which module you're calculating out effective bonus for. So first module is 1, second is 2, etc etc.
It returns 1=1.0, 2=0.89, 3=0.63, 4=0.25 and 5 is all of 0.02
If I had %'s or even just raw bonus numbers I could do this more properly than just dicking about with things I've heard or read in some distant past. Chart some data points, estimate a graph, and math that kitten out! |
Chankk Saotome
SyNergy Gaming
EoN.
287
|
Posted - 2013.05.16 13:32:00 -
[7] - Quote
hydraSlav's wrote:Chankk Saotome wrote:There's only the one grenade size type as it stands now and everybody gets one... All grenades are "small", but different suits have different grenade slots. The "higher" slots allow fitting "smaller" grenades, just like you can fit a Light Weapon into Heavy Weapon slot
Just looked at my suits and noticed it DOES say, "Infantry Medium Capacity Grenade" on my Logi suits, Small on the Dragonfly, and Large on the Skinweave Heavy. Good catch.
Also, as for precise numbers, those are awesome useful. Only confirming. I shouldn't be as lazy as I have done. Just wish I had my proto logi suit to get up to 4 modules. 3 from the Advanced isn't really enough data points but can confirm at least. It's not that I don't trust you, I just like to have my own data to back it up is all.
Gonna be a kitten and a half to get these functions done up and then merged into skill effect bonuses... blegh blegh blegh.
Working with modules I don't have skills for though (of which there aren't many) to give me a decent baseline curve.
I'm sure there's something to express that 2.22292081 you've found there. I'll get to it eventually. Feeling better now that people are getting off the "BURN ALL LOGIs!" train with PC gone live and better things to worry about. |
Chankk Saotome
SyNergy Gaming
EoN.
287
|
Posted - 2013.05.16 22:20:00 -
[8] - Quote
Yes, 3 modules all the same... Same for
militia cardiac regulator
Stamina:
120 base > 150 > 182.59 > 208.64, Absolute gains: 30 > 32.59 > 26.05
Sta recovery:
12 base> 18 > 25.82 > 33.19, Absolute gains: 6 > 7.82, 7.37 (still above original increase??
militia shield recharger
20 base > 23 > 26 > 28.22, absolute gains: 3 > 3 > 2.22
I don't even think these all fit the same graph... I'm wondering if they messed up and rather than decreasing based off the original it decreases a % based on the Absolute... which could explain this. But that's just bad function writing by some programmer somewhere using incorrect variables. |
Chankk Saotome
SyNergy Gaming
EoN.
287
|
Posted - 2013.05.17 09:04:00 -
[9] - Quote
hydraSlav's wrote: THERE BE MATH UP IN THIS KITTEN RIGHT HERE!
So everything is spot on.
I apologize for always "tl;dr" re-quoting you. I do it a lot so you're not alone.
Yeah, I figured this too... and everything IS spot on... if modules are affecting a cumulative total statistic and not only each affecting the base stat independently which is what I would have expected. |
Chankk Saotome
SyNergy Gaming
EoN.
325
|
Posted - 2013.06.04 11:29:00 -
[10] - Quote
As you gave me permission to use your tool, would you mind if I did some reverse engineering? If I can get this to work offline on OpenOffice as it's intended I think I'd like to take the Module, Equipment, and Weaponry and skill prereq elements to write out an automatic skill planner to match a particular dropsuit design.
Then link those numbers into a unique Skill Planner sheet from my own tool and possibly find a way to merge them.
If I have your permission just to work on this and get thinking I'd love to send prototypes your way once I get on it so we can maybe get something together.
Just because it's ONLY a spreadsheet, doesn't mean it can't be the most beautiful and amazing thing ever. Who needs flash applets or website graphics designs? Pfffttth. |
|
|
Chankk Saotome
SyNergy Gaming
EoN.
364
|
Posted - 2013.06.10 11:57:00 -
[11] - Quote
Just an update... Trying to figure out how to get hydraSlav's tool to work offline in OpenOffice... but that's another story. I'm working with the current function:
=IF(ISERROR(VLOOKUP(A51;$G$23:$H$37;2;0));0;VLOOKUP(A51;$G$23:$H$37;2;0))
Where G23:H37 is actually an Array that lists G: Relative Skill, and H: Skill Level requirement
This is linked via function: =VLOOKUP($C29;$'Dropsuit Modules'.$B$3:$K$155;3;0)
Where C# is a linked dropdown list of related modules and the following relates to the aforementioned Relative Skill and Level Requirement as listed in my own Skill Planner chart.
I've segmented this down to High Slot module selection, Low Slot module selection, and Equipment currently on a test sheet... https://docs.google.com/spreadsheet/ccc?key=0AmaDmQ0quOz3dDZ3WXUyVE9QdENGMUcwN01BRnhMYmc#gid=0
It's a mess there honestly, but I'm working on it... Have to basically work BACKWARDS up the prerequisite skills and it requires writing the function elements for every teir of prereq... i.e. one skill requires lvl3 of something, another requires lvl2... etc, etc... Its a nightmare, wondering why I started this as I'm not updating my own piece... but still, I really want to see this happen... |
|
|
| |
|