Shadow Posted June 26, 2012 Share Posted June 26, 2012 I like to make spreadsheets, and apparently it's been too long since I took economics to do a semi-basic calculation of input vs. time. Basically I wanted to make an EVE spreadsheet that could take some arbitrary numbers and calculate your rate of gathering, and output your profit per hour (along with an override column for custom numbers). I can easily find the gross numbers for this but to calculate net rate in regards to hull capacity vs # of trips... I'm fumbling and for some reason cannot seem to find the perfect formula. What I've got now L11 / ( M11 + F11 ) * 60, or more simply: #collected / (Timecollected + Roundtriptime) * 60 This is clearly wrong, as my denominator is much too large and I expect this to be an exponential function, and to be honest I'm just kaput on the whole thing. It's been too long since I took a math course, so I'm asking for input from you. At the very least this should give me a record of my own thinking. The spreadsheet: https://docs.google.com/spreadsheet/ccc?key=0Av8qymsPh1AOdGw4R0hXcm53czlkcHpyRFMteC13Z3c I've thought this over multiple times, and in the effort of not misleading whoever posts I chose not to include my own ideas. They were all wrong. Looks like I'm posting them anyways. Link to comment Share on other sites More sharing options...
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!Register a new account
Already have an account? Sign in here.Sign In Now