Updated Loot Spreadsheet

GREE

DECAGAMES Forum - Powered by vBulletin
Page 1 of 6 123 ... LastLast
Results 1 to 15 of 87

Thread: Updated Loot Spreadsheet

  1. #1
    Consistent Contributor itzkakarot's Avatar
    Member Since
    Jan 2012
    Post Count
    156

    Updated Loot Spreadsheet

    Hey guys,

    The Loot spreadsheet had some bad data in it, so I went through the CC files for 2.2.1 and pulled out the current drop rates & info. You can find it all here:
    https://docs.google.com/spreadsheet/...jdvQ3FZWmF3eWc

    Easiest way to use the spreadsheet is to make yourself a copy and filter/sort it to suit your needs.


    Edit: Updated for 20120405_0 dataset


    Happy looting.

    -itz
    Last edited by itzkakarot; 04-05-2012 at 08:06 PM.
    CC Hood Planner: http://goo.gl/W5mKh
    CC Loot Spreadsheet: http://goo.gl/efYtu
    CC: 706 262 372 (Shoot me a PM when you send an invite)

    Nico's Bracketing Strategy
    Nico's No-Bank Strategy

  2. #2

  3. #3
    Consistent Contributor
    Member Since
    Sep 2011
    Post Count
    141
    Thank you itzkakarot.

  4. #4
    Verbose Veteran
    Member Since
    Feb 2012
    Location
    North Pole
    Post Count
    971
    Amazing! Did you make all that yourself?

    +1

    This should be stickied.
    RETIRED

  5. #5
    Consistent Contributor itzkakarot's Avatar
    Member Since
    Jan 2012
    Post Count
    156
    Quote Originally Posted by Santa View Post
    Amazing! Did you make all that yourself?
    Yeah, the data wasn't too hard to relate, Funzio did their part setting up a properly normalized database. I did it last night for the Modern War loot, once I finished MW the CC one was easy to do.

    I just wish I could figure out the darned algorithm for calculating building upgrade costs and timers for MW. There's nothing in the data for upgrades, just the initial build price. So it must be calculated, but I can't figure out the pattern.
    CC Hood Planner: http://goo.gl/W5mKh
    CC Loot Spreadsheet: http://goo.gl/efYtu
    CC: 706 262 372 (Shoot me a PM when you send an invite)

    Nico's Bracketing Strategy
    Nico's No-Bank Strategy

  6. #6
    Verbose Veteran
    Member Since
    Feb 2012
    Location
    North Pole
    Post Count
    971
    Quote Originally Posted by itzkakarot View Post
    Yeah, the data wasn't too hard to relate, Funzio did their part setting up a properly normalized database. I did it last night for the Modern War loot, once I finished MW the CC one was easy to do.

    I just wish I could figure out the darned algorithm for calculating building upgrade costs and timers for MW. There's nothing in the data for upgrades, just the initial build price. So it must be calculated, but I can't figure out the pattern.
    I don't understand but whatever. As long as the data is correct...
    RETIRED

  7. #7
    Master of Musings iteachem's Avatar
    Member Since
    Nov 2011
    Location
    A tepee near you
    Post Count
    2,645
    Will throw my thanks in as well... I have definitely become a better player as a result of your work

  8. #8
    Verbose Veteran
    Member Since
    Feb 2012
    Location
    North Pole
    Post Count
    971
    One fairly major problem. Under the "drops per 1000 energy" tab, most only show 0's with no decimals.
    RETIRED

  9. #9
    Verbose Veteran
    Member Since
    Mar 2012
    Location
    NY
    Post Count
    700
    Nice job itz. I was always wondering how the loot spreadsheet was populated and I guess you can data mine the database. How is it possible to get access to the database? Wouldn't it be protected or is it badly protected?

  10. #10
    Consistent Contributor itzkakarot's Avatar
    Member Since
    Jan 2012
    Post Count
    156
    Quote Originally Posted by Santa View Post
    One fairly major problem. Under the "drops per 1000 energy" tab, most only show 0's with no decimals.
    I realized I'm missing drops from a lot of the multi-drop bosses. I'm going through that data now and will update the sheet shortly.

    Also keep in mind that the sheet shows all jobs, and not all jobs have loot rewards.
    Last edited by itzkakarot; 03-30-2012 at 06:50 PM.
    CC Hood Planner: http://goo.gl/W5mKh
    CC Loot Spreadsheet: http://goo.gl/efYtu
    CC: 706 262 372 (Shoot me a PM when you send an invite)

    Nico's Bracketing Strategy
    Nico's No-Bank Strategy

  11. #11
    Prominent Poet Swifty's Avatar
    Member Since
    Jan 2012
    Location
    A Gulag in the Other Siberia
    Post Count
    1,953
    Many thanks for your efforts.
    GREE(D) is trying to put the fun back into Funzio.

  12. #12
    Supreme Scholar mnju_03's Avatar
    Member Since
    Nov 2011
    Location
    Minnesota
    Post Count
    5,379
    Quote Originally Posted by itzkakarot View Post
    I realized I'm missing drops from a lot of the multi-drop bosses. I'm going through that data now and will update the sheet shortly.

    Also keep in mind that the sheet shows all jobs, and not all jobs have loot rewards.
    You rock! I don't catch half the stuff you pros catch.
    Quote Originally Posted by Crime City Mark View Post
    Hahaha,

    I have a story about that. I probably shouldn't share it. Kinda lame, actually. Forget I said anything.

  13. #13
    Prominent Poet Boom's Avatar
    Member Since
    Mar 2012
    Post Count
    2,491
    Thank you! I tried doing the 5x195 spa for a NATO gas mask and got it on first try (did it for fun)
    Last edited by Boom; 03-30-2012 at 09:32 PM.

  14. #14
    Consistent Contributor itzkakarot's Avatar
    Member Since
    Jan 2012
    Post Count
    156
    Ok, sheet's updated. It should now contain all job and boss loot data. Note that the sheet does list all jobs, including the ones without loot rewards. You can easily filter out the Blanks on Column K, if that's desired.
    CC Hood Planner: http://goo.gl/W5mKh
    CC Loot Spreadsheet: http://goo.gl/efYtu
    CC: 706 262 372 (Shoot me a PM when you send an invite)

    Nico's Bracketing Strategy
    Nico's No-Bank Strategy

  15. #15
    Articulate Author Chiefer's Avatar
    Member Since
    Sep 2011
    Location
    Fort Lauderdale
    Post Count
    382
    Doesn't matter at all. 3 weeks ago the m4-a1 was on that list. You guys need to open your wallets and spread your bills. Please stop trying to farm. You are not allowed.
    The coolest thing every written,
    .........Is elsewhere.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •