Spreadsheet EnRAGEd - official thread

    enRAGEd
    Created by TheClansman[RAGE] (Ogame.org Uni22)


    I worked on this for two years. At principle was simple and was for personal use, but time has passed and the spreadsheet has improved.
    During the last two months I have prepared a launch to the public. I had planned to launch it during last weeks of June, but with the recent update to the ReDesign in all universes, I decided to release it with the current level of development.


    enRAGEd Aye-Aye
    Version 10.06
    This is the first published version.


    RECOMMENDATIONS:
    For proper use of enRAGEd spreadsheet.
    - EnRAGEd is in Microsoft Office Excel 2007 format. I can NOT guarantee that all features to function properly in other formats or programs. for example: Excel 2003 or OpenOffice.
    Copies in other standard formats are distributed in the same package, along with the spreadsheet in original format. These files might not contain all the features.
    - To avoid accidental damage, all spreadsheets are protected/locked. To enter your data, do not need to unlock it.
    - ONLY green cells are for data entry. Do NOT overwrite ANY cell.
    - If you want to do any other modification (Not player data), you must unprotect/unlock each sheet to be modified.
    - If you play in more than one universe, I recommend using a copy of this file for each universe.


    FEEDBACK and SUPPORT:
    If you find a bug/error or want to propose something, please give to know in this thread.


    SCREENSHOTS:
    All Sheets:

    Display Spoiler


    LINK:
    https://dl.dropboxusercontent.…0Gorilla%20(2014.04).xlsx


    ..::Edit by NoMoreAngel|Updated the link|27.4.2016|22:10:31::..

    Edited once, last by TheClansman ().

    Oh my god, that is actually insane.. theres so much i can't comprehend using it lol, but it's for sure the ultimatum in OGame management. A very nice job indeed.
    But tell me this.. was it worth 3% of your life?

    I have been using this thanks to you.^^


    I'm aware of problem? in Resources sheet.


    In Resources sheet, from U10 to V19, Deuterium productions are not real.


    If you don't consier Fusion Reactor consumes Deuterium for just points, the values are real.


    How do you think about this?

    I think Product energy of Fusion Reactor is wrong.


    Actually, the product energy is smaller than real product energy.

    Quote from Code Riddle

    I think Product energy of Fusion Reactor is wrong.


    Actually, the product energy is smaller than real product energy.


    First, thank you for wanting to help improve this Spreadsheet.


    I reviewed the formulas of deuterium production and the formulas of Fusion Reactor. they are correct.

    Deuterium Synthesizer:
    (10 * (level) * 1.1 ^ (level)) * (1.28 - 0.002 * (max temperature)) deuterium


    Used formula in the Energy production of the fusion plant:
    30 * [Level Fusion Plant] * (1,05 + [Level Energy Technology] * 0,01) ^ [Level Fusion Plant]


    Fusion Reactor:
    10 * (level) * 1.1 ^ (level) deuterium


    But they may have slight variations, the results have a error factor of ±1 or 2 per hour, and ±24 or 48 per day.
    However, some days ago I worked in this and I improved the accuracy of all results in the sheet "Resources". The Changes will be available in the next version, which I plan to publish the next weekend.



    To "Code Riddle"
    Also, verifies that the Maximum Temperatures of each planet are correct.

    Quote from TheClansman

    I reviewed the formulas of deuterium production and the formulas of Fusion Reactor. they are correct.

    Yes, they are correct.


    I made a stupid mistake.


    I didn't input Research sheet.


    sorry

    Quote from TheClansman

    But they may have slight variations, the results have a error factor of ±1 or 2 per hour, and ±24 or 48 per day.
    However, some days ago I worked in this and I improved the accuracy of all results in the sheet "Resources". The Changes will be available in the next version, which I plan to publish the next weekend.

    I'll anticipate that . ^^

    enRAGEd Baboon
    Version 10.10


    Like the previous version, it supports "Expedition Technology" and "Astrophysics".


    CHANGES:
    Game's Update: The formula for energy production of the Solar Satellites, has been updated to the ReDesign version.
    Game's Update: The cost of the storages has been updated to the ReDesign version.
    Game's Update: The Officers icons have been updated to the icons in the ReDesign. Added support for the Officer "Admiral".
    Change: The sheets "Flight", "Expedition", "FS" and "Recyclers" are no longer exclusive. "BlindHit" is still exclusive for members of Alliance RAGE.
    Change: The sheet labels were renamed, re-ordered and re-colored.
    Change: The character "▲" was added to the label of the six sheets for player data entry.
    Fixed Bug: On sheet "Resources". Now the new colonies have Basic Income, when its mines are in level 0.
    Improvement: New sheet "Expedition".
    Improvement: On sheet "Mines", added Storage Capacity in ReDesign.
    Improvement: Now support for Speed Universes in all sheets.
    Improvement: On sheets "FS", "Flying", "BlindHit" and "Recyclers". Added the "Phalanxable / No Phalanxable" info.
    Improvement: On sheet "BlindHit". Added "Investment" and "Debris Field" of the fleet.
    Improvement: On sheets "Resources" and "Mines", improved the accuracy of the formulas.
    and other small changes.


    LINK:
    http://www.megaupload.com/?d=I3AI8IT2


    working for update the production formula of Deuterium Synthesizer.


    enRAGEd Coati
    Version 10.10.12


    CHANGES:
    Game's Update: The hold cost of the Small Cargo has been updated to the ReDesign version.
    Game's Update: The production formula of the Deuterium Synthesizer, has been updated to the ReDesign version.


    DOWNLOAD:
    http://www.megaupload.com/?d=1888UJGD
    .

    On you spreadsheet... how would one shut off the use of a fusion reactor...

    Quote from Izune


    On you spreadsheet... how would one shut off the use of a fusion reactor...


    in this current version, all the mines and energy sources work 100%. but on the next version I'll add a percentage of operation for Fusion Reactor.
    Thank you for your observation

    enRAGEd Dromedary
    Version 10.10.16


    CHANGES:
    Improvement: Added option "Import" for users of ogameEmpire.xls "oGame Empire management spreasheet (by VA Skaare)" version of 22-7-2009 or later.
    Improvement: Added percentage of operation for Fusion Reactor.
    Change: On sheets "Resources" and "Mines". Yellow color was applied to Energy. Order in the tables on "Resources" has been changed.


    SCREENSHOT:


    DOWNLOAD:
    http://www.megaupload.com/?d=XOZPLZWC
    .

    very nice, only noticed one thing that may not be right and will check it again tommrow when i am not dog tired and thinking str8, but my point total on the overview page does not seem to match up with my points in game off by maybe 1000 or more, but will check tmr

    i have noticed a small error, i know i have entered everything correctly as i update the second something changes, but the point totals on the overview tab, they dont seem to match up, always seem to be a few thousand off of what ogame says i have, just throwing that out there

    Hey


    First of all, great sheet, its wonderful and it has anything a person can ask for, however, there are a couple things I'd like to change, like changing tabs order or names for my stupid portuguese friends, so if you'd share the password to unlock the sheets, it would be great


    Thanks for your work :)

    apologize for the delay, but I do not know what to do to receive automatic notification of any replies in my e-mail. If anyone knows how to do it, please let me know (I will continue looking for anyway).


    thanks by your replies.


    Quote from doublediamonds

    i have noticed a small error, i know i have entered everything correctly as i update the second something changes, but the point totals on the overview tab, they dont seem to match up, always seem to be a few thousand off of what ogame says i have, just throwing that out there


    First, make sure you use the latest version.
    I've used it for months and have had no problems in calculating the points. crease I'll check when I have more time. if it is possible to compare with other tools for calculating points. But attention, most still use the old formulas.
    The only mistake I found is sometimes the total varies by 1 point, but only 1 point.


    Quote from Quetzalma

    Hey
    First of all, great sheet, its wonderful and it has anything a person can ask for, however, there are a couple things I'd like to change, like changing tabs order or names for my stupid portuguese friends, so if you'd share the password to unlock the sheets, it would be great


    Thanks for your work :)


    regarding the labels order of the sheets, I receive suggestions.


    regarding the password:
    I give the possibility to change my work, and if someone wants to change it, do it (most sheets no password). but I protected with password some things to:
    1- so that no one is attributed as the author of this project, not so much self-pride, but to avoid plagiarism.
    2- disclose this official thread, and thus help answer questions and improve this spreadsheet. Even when it is published in another forum or site.


    If you want renamed tags, I can do and then I send you an modified copy (but still protected), only you must publish here the translation of each of the labels.


    Also, If you want, when you are finished completely the translation, could be published in this post or another thread in www.ogame.com.br or www.ogame.com.pt
    if so, I would be muito obrigado.
    and you will have the credits of the translation into Portuguese. I can add you in the protected sheet :D

    Nice work on the sheet. I'm pretty sure I have the latest version so a couple of observations:


    First: Satellites can provide more than 50 energy


    Second: You state a maximum of 9 planets. Untrue for redesign. Do you plan on updating the sheets for more than 9 planets?

    Quote from Jeteki

    Nice work on the sheet. I'm pretty sure I have the latest version so a couple of observations:


    First: Satellites can provide more than 50 energy


    Second: You state a maximum of 9 planets. Untrue for redesign. Do you plan on updating the sheets for more than 9 planets?


    respect to the energy produced by the satetites. I do not know if I understood. you mean that now, with the redesign, there is no maximum limit of 50 energy?



    about the maximum of 9 planets. yes, I will update to allow enter more planets. maybe even 12, although I have not calculated how many planets are profitably possible (without be insane) to colonize the speed universes.
    but for that, will spend at least a month. because now, I don't have time to do it.

    Sorry - went away for work for a bit.


    Yes in the redesign universes a satellite can produce more then 50 energy.