GvG - goods costs per siege

Discussion in 'Guides' started by Huscarl, Mar 5, 2014.

  1. Huscarl

    Huscarl Major-General

    Joined:
    May 13, 2012
    If anybody could post their current goods costs per siege, I'll try to compile a list

    What I have so far:


    Siege #Goods Cost (per good)
    15
    210
    315
    420
    530
    645
    760
    880
    9100
    10125
    11155
    12190
    13230
    14275
    15325
    16380
    17440
    18510
    19585
    20670
    21760
    22860
    23965
    241085
    251215
    261350
    271500
    281655
    Thanks to BoD and mink for helping make this.

    edit: here's the formula: [​IMG]
    where y = siege army number - 1
     
    Last edited: Mar 6, 2014
    Sir Wantagame and Elthea like this.
  2. ByeOrDie

    ByeOrDie Emperor

    Joined:
    Oct 24, 2012
    EDIT: looks like there's no need for me to record anymore :) I knew the equation would not be something I could easily guess
     
    Last edited: Mar 5, 2014
  3. Huscarl

    Huscarl Major-General

    Joined:
    May 13, 2012
    [​IMG]

    My guild has 3 sectors on the PE. So our next siege is 20 of each.

    edit: took me a bit to figure out what you were hinting at. I figured it out now :)
     
    Last edited: Mar 5, 2014
  4. mink

    mink Monarch

    Joined:
    Apr 27, 2012
    The next are 1350, 1500 and 1655.
     
  5. FacetiousMike

    FacetiousMike Private

    Joined:
    Feb 16, 2013
    An official answer has now been released here.
     
  6. Surge

    Surge Brigadier-General

    Joined:
    Apr 12, 2012
    I'm afraid that the formula in text is horrifyingly confusing. I tried many times with many numbers and different interpretations to find out how to use it. I made a formula picture thing which should help clear confusion.

    [​IMG]
     
  7. Bartimaeus46

    Bartimaeus46 Second Lieutenant

    Joined:
    Jul 24, 2012
    I have made a siege cost calculator, in .exe form. (So you download it and use it like a normal program)
    All you need to do is input what Siege number you are looking at, and it gives the amount of each good needed.
    Works from siege 1 all the way up to siege 999,999.

    It is available to anyone interested, just PM me and I'll give the download link.

    Screenshot:
    [​IMG]

    This is a completely free program made by myself using the formula given by The Countess.
     
    Last edited: Mar 6, 2014
  8. Kimba Lioness

    Kimba Lioness Lieutenant Colonel

    Joined:
    Sep 18, 2013
    Lol @ Barti's amazing siege cost calculator hahaha :-D kim.
     
    mrbeef likes this.
  9. thanatos100

    thanatos100 Monarch

    Joined:
    Nov 27, 2013
    I'm not a mathematician but looks to me like there is a set of brackets missing from the formula. For those wanting to plug it into a spreadsheet the following works in Excel and openoffice calc.

    Code:
    Excel: ROUND((3*POWER(Y-1,1.5)+0.045*POWER(Y-1,3.1))/5+1,0)*5
    
    Calc: ROUND((3*POWER(Y-1;1.5)+0.045*POWER(Y-1;3.1))/5+1)*5
    Where 'Y' is the siege number which can be replaced with the spreadsheet cell identifier where the siege number is located to make it easier to see the cost for different sieges.

    Example: Siege number is entered in Cell A1. Formula would be;

    Code:
    Excel: ROUND((3*POWER(A1-1,1.5)+0.045*POWER(A1-1,3.1))/5+1,0)*5
    
    Calc: ROUND((3*POWER(A1-1;1.5)+0.045*POWER(A1-1;3.1))/5+1)*5
     
    Last edited: Nov 24, 2015
  10. HRC

    HRC General

    Joined:
    Apr 13, 2012
    I never said thank you for this and i use it a lot - so many thanks to everyone who posted information, especially Huscarl for starting the hard work and thanatos for making my life much easier :)
     
  11. ByeOrDie

    ByeOrDie Emperor

    Joined:
    Oct 24, 2012
    Btw, I did (somewhat) fix the table on this one as I had to reference it today [​IMG] (This one was an easy fix since it was a simple table compared to most of my guides here).
     
  12. Elthea

    Elthea Private

    Joined:
    Nov 8, 2014
  13. 7777777a8

    7777777a8 Private

    Joined:
    Sep 21, 2017
    That is the graph of the function in question. I was curios and had to see for myself. THought I post it for anyone else interested. :)

    GvG.JPG
     

Top