PDA

View Full Version : Spreadsheets and more.



Kiss Of Death
07-07-2012, 11:44 AM
OK,

I'm trying to work my way through this but there is so much to do in MW and KA around my job, husband and kids... let alone events and the rest....

Latest updates being linked in a minute to google... by the way... why does it look like it does? It's not converting right so if you want copies of the real deal email me on iphone.app.gamer@gmail.com for your Trojan loaded, porn spamming version :)


Oh and officially CC Mark can't tell us how the basic profile stat in MW is worked out... i.e. does it include the building defense values... can't say. Does the boost get applied after working out which units are used and then applied as a whole on each category... or done against each unit and then reordered... Can't tell us. Does 'Power' mean adding to Attack and Defense... or just attack... Can't tell us... and so on.

So my sheet has error margins as I fiddle and play with it trying to narrow down the rounding errors etc. Hopefully most of you will only get a 1% or less error.
Latest updates....

MW

LE and gold item listing as an info page... just because

Drop Rate and Item charts started... going to plagiarize but also double checking every one of them myself includes what, which map, stats, hits required, energy (based on map 5 completion) and exp.

Main page now also gives you the rough Att/Def density of each ally and ave. Att/Def of all units brought to battle.

Hyperlinks now replacing unit names so you can also see an image of each unit itself.. I'm not doing pissy drop units, mostly LE's Gold, Event, Crate and high Drop units...

Main page also displays gold wasted on crates, average attack and def gain ratios to gold spent for all items... crates page summarises your values per crate set and its return on % for rare/uncommon/common etc... and the overall ratio to gold

Def buildings only accurate to level two as I havn't worked the formula in past that yet.. this is a big proect and i build on it as I build on my own account... you'll have to wait for me to actually upgrade a def building past 2 for me to check formula :)


KA.. Getting there... but sloooow as MW absourbing my time... KA is pretty solid so no need to do this one as intensely... feel free to build on it yourself.

Main page has pretty picture.... more hyper links to come... LOTS of armor and weapons yet not added and units... but I will get there eventually you can just add your own anyway...

Crates pages being built so skeleton is there for you to use...

HELP: If you have the sets of crates, the name of the set please advise me by pm or email. If you have good quality screen dumps of units you want me to hyperlink, send the PM to me with the link to download and build in... (KA or MW)


I WILL eventually get to putting in a page for building upgrades and planning... not yet

All feedback should be either email to above or PM me.

Very busy lady but my life revolves around my phone so I know when I get emails...

Cheers.


Samantha

EDIT: I found going to link then choosing to email it to yourself gets the full working copy...

https://docs.google.com/open?id=0B0cTYxc63uCjd0NhQ2MtUXBoQVk MW

https://docs.google.com/open?id=0B0cTYxc63uCjcERIMi11SzVLaGs KA

Kiss Of Death
07-09-2012, 11:52 AM
New update for MW sheet link added:

https://docs.google.com/open?id=0B0cTYxc63uCjZm5kLUluZkJ3ZjQ

Includes 30 more hyperlink images for units (Cash units and Crates)

Download or email yourself a copy now... or email me and I'll flick you one.

manbeast
07-09-2012, 02:24 PM
under defense buildings you have

"total- not included in profile stats"

i could be wrong, but i thought that defense buildings do show up on your profile

edit- thats a ton of info. looks like you've had good luck with the crates. congrats on your oceanic destroyer. i really wanted that one but it wouldnt drop for me. and i love the pics!

Bronson
07-09-2012, 02:25 PM
under defense buildings you have

"total- not included in profile stats"

i could be wrong, but i thought that defense buildings do show up on your profile

You are correct. When the defence building finishes you get a bump in stats.

Kiss Of Death
07-10-2012, 08:50 AM
You are correct. When the defence building finishes you get a bump in stats.

Yes seems I have various experiences with this... mine hasn't done this... this could be why it's so hard to get it to match other player... I will change coding on weekend to add it for other users...

OT in MW... sorry again... hmmm still 103 crates to open... come on 10 item

Arizona
07-10-2012, 08:58 AM
OT in MW... sorry again... hmmm still 103 crates to open... come on 10 item
Is this why you're upso late down under? 103 is gonna take forever. I got two left YAY!:) or NAY!:(

Kiss Of Death
07-16-2012, 12:49 PM
REFER POST # 1 for updated links

Updated MW sheets, added for now a view of just base attack and def totals and modified in groups so you can see total attack and def in category (SEA AIR GROUND etc) totals as well. Don't forget to sort descending by base scores only for attack and then separately for def to calc the two values... sorting by attack ranking will clearly read a wrong def score.

Buildings now adding to def totals... still stumped to error margins and have tried doing individual unit boosts, ranking by modified stats, adjusting decimal numbers, but still getting an error under 0.5% on attack score compared to actual profile and between 0.5-0.8% on Def scores...

A dozen or more hyperlinks added. Still haven't made a pretty Main page like KA's so sorry about that

Additional crate and event items added that I have... don't forget you can edit your own sheets....

any suggestions now ?

KA also updated adding def scores for buildings to profile, attack and def now sorts into Units/Ar/Wpns and totals

A few hyperlinks... have hundreds now to crop and upload... weekend job.

DON'T FORGET TO EMAIL YOURSELF THE FILE FORM THE LINK don;t waste time downloading it unless you can get the actual excel file that way... I find 'FILE' then 'Email as attachment' the way to go.

CAPT.GIN
07-16-2012, 12:53 PM
Hey kod is that a real pic of you?

Kiss Of Death
07-16-2012, 12:56 PM
Hey kod is that a real pic of you?

Yes, are you a friend on my list? if so go to my profile and look at my al'bum' because that's were Aidan spends all his spare time. The miss spelling of album will make more sense if you know Aidan like I do.

EDIT: REFER POST #7 please for UPDATE info... now that Capt.gin has hijacked the thread ;) lol

CAPT.GIN
07-16-2012, 01:07 PM
krikie mate.....

Kiss Of Death
08-01-2012, 10:31 PM
Ok MW link reloaded... more units, a few chnages... still a crazy mess... can SOMEONE please help me work out the old crates... I don't know what was in each of the earlier sets... I can locate units but can't tell the set they go in.

Khimsoo
08-01-2012, 10:56 PM
Based on my testing few weeks back, the defense score is closest to my stat by adding all building defenses. Most buildings has its own defense and as u upgrade, there should be an increase in def stat also.

List of units brought to battle is based on boosted score and sorted by atk/def respectively.

The unknown things are
1)how much additional defense do we get from upgrading money, boost and def building, if any?
2)how are the atk/def skill points used in battle?

Jp lfs
08-02-2012, 12:00 AM
Based on my testing few weeks back, the defense score is closest to my stat by adding all building defenses. Most buildings has its own defense and as u upgrade, there should be an increase in def stat also.

List of units brought to battle is based on boosted score and sorted by atk/def respectively.

The unknown things are
1)how much additional defense do we get from upgrading money, boost and def building, if any?
2)how are the atk/def skill points used in battle?
There was an email from someone official explaining skill points and how they work. It revolutionized our previous understanding of the system.

Copenhagen
08-02-2012, 12:12 AM
Manbeast shared an email from Cj explaining skill points and how they work. It revolutionized our previous understanding of the system.

Where? Please provide the link.

Copenhagen
08-02-2012, 12:17 AM
Running a search, but can't find anything. I'll PM him. Btw -where has that dog been?

Kiss Of Death
08-02-2012, 02:14 AM
Based on my testing few weeks back, the defense score is closest to my stat by adding all building defenses. Most buildings has its own defense and as u upgrade, there should be an increase in def stat also.

List of units brought to battle is based on boosted score and sorted by atk/def respectively.

The unknown things are
1)how much additional defense do we get from upgrading money, boost and def building, if any?
2)how are the atk/def skill points used in battle?

Hi Khismo, I have made so many adjustments since a few weeks back. Building def ads. The only thing I need is a sheet showing all building def scores for all levels to modify the table which is only accurate to level 2 def building until I upgrade my own or get the data.

Is it in your app..? I didn't think to check.

I'll get around to building a Macro.

By the way sorting by unmodified order and modified order of attack or def can be done easy on my sheet but the variation is so small for me that I am still uncertain if they pick units to battle on mod stat or unmod stat. The other key issue is at the lower end when you have 300 different types os units all with thw same value... what order do they select in as the boosted values will change... I think that is a key area my margins go out on as i can;t know thier select order or I could actually build it in.

And lastly lastly I have tested boosting each unit singularly or sorting types (Sea/Air etc) and applying boost to the whole... obvioulsy no difference when comparing sort orders both by base... but only minimal if any variation if comparing say sort by mod individually or sort by base and apply mod to all...

I get what I'm saying... do any of you?

MadManDK
08-02-2012, 03:52 AM
Hi KOD, very nice work.

I know there are a lot of speculations on all of this, but here are some of my experiences with a sheet I made 1-2 months ago.

- Attack order is based on boosted stats, I have some units that changes spaces, when I moved to UK and the numbers fit when I chose my units based on boosted (greater difference if I sort based on not boosted)
- For me the numbers are more accurate, if i multiply the boosts (e.g. Level 6 comp + Level 5 naval + UK = 36% boost)
- I don't use att and def skill points at all in my calculations
- I use all the defense buildings def and add it as the last thing (after boosting units and adding them together)

My error margin between calculated and actual stats has been below 0.02% for a month now, so I'm pretty happy with it. E.g. with a current boosted att of over 50K I'm 1 off and a defense of close to 56K I'm 6 off.

Maybe this can help and if not, just ignore it.

Kiss Of Death
08-02-2012, 07:41 PM
Hi KOD, very nice work.

I know there are a lot of speculations on all of this, but here are some of my experiences with a sheet I made 1-2 months ago.

- Attack order is based on boosted stats, I have some units that changes spaces, when I moved to UK and the numbers fit when I chose my units based on boosted (greater difference if I sort based on not boosted)
- For me the numbers are more accurate, if i multiply the boosts (e.g. Level 6 comp + Level 5 naval + UK = 36% boost)
- I don't use att and def skill points at all in my calculations
- I use all the defense buildings def and add it as the last thing (after boosting units and adding them together)

My error margin between calculated and actual stats has been below 0.02% for a month now, so I'm pretty happy with it. E.g. with a current boosted att of over 50K I'm 1 off and a defense of close to 56K I'm 6 off.

Maybe this can help and if not, just ignore it.

Thanks,

I don't use att/def skill points in calcs either... here's a summary of the sheets calcs.

You can elect to sort by Base or Boosted stat order. You sort by Attack to determin attack order and points. Or by Def for Def ranking etc.


The Main page will show both attack and Def but only the one you have elected to sort by will be accurate. Hence the manual text box you can enter the value into before flicking to units again and sorting the opposite value and returning to main page.

As you manually enter in your profile figure, once you enter in the returned value for attack and def in the record column it will show you the error margins +/- as a percentage

If you believe they sort by Base then you can actually enter in all countries stats at one time by simply changing country code on main page and noting the jump/drop in attack or defense depending on what you are sorting by. If you believe it is by modified values that units come to battle you would need to resort the unit column after each nation change as it will change the priorities of close units.

Defense building values are added to defence in full after sorting and boosts have been applied.

I understand your accuracy will be closer. Those who have large ally lists and as a result have not been able to field enough higher value attack and def units for every ally will find like me now that the last 100-200 units brought to battle are made up of perhaps 30-40 different drop and base units all with say 3 attack... as we don;t know Funzio's ranking order there may be 100 unit types all with 3 attack, so which 30-40 of those are selected? as some are AIR/SEA/INFANTRY/GROUND.. the selection of these is paramount to calculating the corrected boosts. So the error is in this lower section for players. I have found when I dropped allies and every single unit brought to battle was gold/crate/event or valor.. my def and attack calcs were to 0% error on attack and 0.05% error in def. So it is in fact a margin only caused by the lack of ranking order known at these 'bulk' unit types. I.e. if alphabetically (which excel uses) it selects 30 unit types all of which are infantry in the spreadsheet and you are UK/Russia/German, then the attack/def score will have error when in fact Funzio might have selected a mixed bag of unit types by their own ranking codes.

Try cutting and pasting your units into the new spreadsheet. Let me know if its more accurate. (Err will occur in def buildings if you have any > lvl 3 until i know the def values of those buildings to make calcs correct)

MadManDK
08-03-2012, 02:09 AM
Your last post made me look at my top 49 attack units, so that I could verify my theory. The good news is that I believe that I have the units in my top 49 to both identify the sort order (for country and building boosts, don’t have other boosts) and whether boosts are added or multiplied.

With the quick look and calculations (more detailed documentation will follow for others to take apart) it seems that sorting is done with country boost only and that boosts are multiplied.

I updated my sheet and this new sort order caused me to change some defense units in and out, so now I have an accurate defense number, while my attack is 1 off (out of 52K).

I’ll post calculations and pictures later, when I have had time to document it in a (hopefully) readable way.

Wambo
08-03-2012, 02:54 AM
krikie mate.....

I like the one dressed up as a kinky copper, she can frisk me anytime...

MadManDK
08-03-2012, 03:59 AM
Purpose
The purpose of this is to identify the following:
• What is the sort order used in Modern War to find the units being used during attack (and defense)
• Are boosts from buildings and country added or multiplied

Cases
For this purpose I’ll use 3 groups of units, that show up in my 49 top attack and are boosted differently based on my different boosts. I’ll create 4 cases
1. Unboosted
2. Country boost only
3. Country and building boosts added
4. Country and building boosts multiplied
And based on these estimate the sort orders and compare it to the actual sorting as seen on pictures taken from a recent attack.

Assumptions
I’m assuming that if I can prove something for Attack that it also applies for Defense. I’m also assuming that the Composite Building is just another boost building and not treated specially.

Boosts
I am UK (10% boost on Sea). I also have Genetics Lab (level 5 – 10% boost on Infantry), Electronics Factory (level 5 – 10% boost on Ground), Airship Hangar (level 2 – 4% boost on Air), Naval Research Lab (level 5 – 10% boost on Sea).

Groups
1. Lethal Tiger – Air – 291 att., Black Dragon Fighter – Air – 311 att., Super Heavy – Ground – 311 att., Heavy Carrier – Sea – 287 att.
2. Flanker Jet – Air – 156 att., Night Eagle – Sea – 140 att., Quick Fighter – Infantry – 155 att.
3. Veteran Fighter – Infantry – 103 att., Battle Command – Sea – 100 att., Reinforced Vehicle – Ground – 110 att., Armored Transport – Ground – 110 att.

Details
The detailed calculations can be found here:
• https://docs.google.com/spreadsheet/ccc?key=0AsLYSj85i1LcdHV4MTVpV0QtNFNqdkwtTXp5Wi1QX 1E
The images of the three groups can be found here:
1. http://i46.tinypic.com/2iussoz.png
2. http://i45.tinypic.com/34j9krp.png
3. http://i46.tinypic.com/nf60d0.png

Conclusion
Based on one attack where all this data is from there is only one case that matches all groups, which is Case 2. This implies (if all my data is true) that
• Sorting is done based on country boost only
• Country and building boosts are multiplied

Final Words
Now somebody please pick this apart, as I surly have made a mistake somewhere.

Kiss Of Death
08-03-2012, 04:12 AM
......

Final Words
Now somebody please pick this apart, as I surly have made a mistake somewhere.

Abslolutley not (did you get my PM?) also I will rekey my entire army late tonight while watching some empowering chick flick you'll all hate... Marg Thatcher's life (movie)...

I'll run a parallel set of calcs to compare results on my own list in full and see if the margin narrows.

MadManDK
08-03-2012, 04:23 AM
Abslolutley not (did you get my PM?) also I will rekey my entire army late tonight while watching some empowering chick flick you'll all hate... Marg Thatcher's life (movie)...

I'll run a parallel set of calcs to compare results on my own list in full and see if the margin narrows.

Looking forward to the results and assume you are talking about "The Iron Lady", which is a descent movie (not that I would know of course :rolleyes:).

spectra
08-08-2012, 10:23 AM
Abslolutley not (did you get my PM?) also I will rekey my entire army late tonight while watching some empowering chick flick you'll all hate... Marg Thatcher's life (movie)...

I'll run a parallel set of calcs to compare results on my own list in full and see if the margin narrows.

KoD let me know who was the movie, I love the way Meryl acts...
My wife and I want to see it, just because of her, but if the plot is good, that would be a bonus

Big John
08-08-2012, 10:44 AM
KoD let me know who was the movie, I love the way Meryl acts...
My wife and I want to see it, just because of her, but if the plot is good, that would be a bonus

The plot sucks, I lived the plot.

Kiss Of Death
08-09-2012, 02:31 AM
The plot sucks, I lived the plot.Really?!... So which British prime minister were you?

Kiss Of Death
08-09-2012, 09:47 AM
Corrected KA sheet attached. NEW boosted stats showing, working on breakdown recording of RAW stats in each category ie BEAST, MACHINE etc... will get to that... Also fixed bug on units and wepaons not being able to sort or add/delete.

MadManDK
08-13-2012, 01:32 PM
Hi KoD,

Here is some more info from my tests.

I just had Bronson (fellow UK player) check my stats and from his point of view he is seeing my "raw" states (raw unit stats added together) multiplied by my country boost and added the defense buildings. I'm seeing my "raw" stats multiplied by country boost and boost buildings (comp. only defense the others both defense and attack) and then added the defense buildings. Both these numbers are also calculated in my own sheet based on units and buildings and are accurate to +/-1 (out of around 50K), which is pretty darn accurate.

So this should make it possible to predict what different people are seeing based on their nation, might be a nifty feature for your sheet.

Hope this makes sense.