Helpful documents for players in Economy, PvP, RvR & Overhaul Shaders

Jack O'ConnerJack O'Conner (Forum Moderator)
edited February 9 in Game Help
Click here for Google docs which link to helpful documents focused in Economy, PvP, RvR & Overhaul Shaders!

Fair winds!
Post edited by Jack O'Conner on
Forum Rules and Policies - Click here
Forum Rules and Policies direct link - http://portalusgames.com/policy/website-rules/
If you don't like the way I moderate, message me and it'll help both of us! Click here to message me
Download Pirates of the Burning Sea Helpful Documents - Contains Economy Tracker, PvP + RvR guides, Guides for Fishing and Graphics overhaul mod!


Comments

  • Did you get the README I sent you for the graphics overhaul?
    "I'm only one third crazy!"
    -NightOwlKOJ
    Low Rezzolution Entertainment
    My Discord: The Roost
  • Jack O'ConnerJack O'Conner (Forum Moderator)

    Did you get the README I sent you for the graphics overhaul?

    Aye! Indeed!
    Forum Rules and Policies - Click here
    Forum Rules and Policies direct link - http://portalusgames.com/policy/website-rules/
    If you don't like the way I moderate, message me and it'll help both of us! Click here to message me
    Download Pirates of the Burning Sea Helpful Documents - Contains Economy Tracker, PvP + RvR guides, Guides for Fishing and Graphics overhaul mod!


  • These spreadsheets do not work for me locally in excel 2010, LibreOffice or remotely at google docs.

    Which version of libreoffice/excel is required? Maybe the file at google docs is broken? Since anyone can edit it?
  • Which documents in particular? I can open everything on Office 2007, I'll open them and send Jack some screenshots to post for those who can't open them, if you'd like.
    "I'm only one third crazy!"
    -NightOwlKOJ
    Low Rezzolution Entertainment
    My Discord: The Roost
  • Which documents in particular? I can open everything on Office 2007, I'll open them and send Jack some screenshots to post for those who can't open them, if you'd like.

    The downloads in google docs - none of them work with the excel 2010 or libre office i have.

    and i just downloaded Production Planner 2.15 Beta.3 (2.15.40.0) from the forum thread, and that doesnt work either. For example i try to set the structures i have, i click on forge, turn its selection to "Yes", but it doesnt switch to 'Yes' at all.

    Formulas etc never calculate of course...
  • Jack O'ConnerJack O'Conner (Forum Moderator)
    unity said:

    Which documents in particular? I can open everything on Office 2007, I'll open them and send Jack some screenshots to post for those who can't open them, if you'd like.

    The downloads in google docs - none of them work with the excel 2010 or libre office i have.

    and i just downloaded Production Planner 2.15 Beta.3 (2.15.40.0) from the forum thread, and that doesnt work either. For example i try to set the structures i have, i click on forge, turn its selection to "Yes", but it doesnt switch to 'Yes' at all.

    Formulas etc never calculate of course...
    I've not had a problem with them at all. Have you tried to enable edit mode once you downloaded the file?
    Forum Rules and Policies - Click here
    Forum Rules and Policies direct link - http://portalusgames.com/policy/website-rules/
    If you don't like the way I moderate, message me and it'll help both of us! Click here to message me
    Download Pirates of the Burning Sea Helpful Documents - Contains Economy Tracker, PvP + RvR guides, Guides for Fishing and Graphics overhaul mod!


  • Do you get an error message when you try to open them? If so, could you imgur the error message to me? I can take a crack at fixing it if I know what's wrong...
    "I'm only one third crazy!"
    -NightOwlKOJ
    Low Rezzolution Entertainment
    My Discord: The Roost
  • edited February 28
    I dont get an error message, but it opens in compatibility mode. I enabled editing. This is excel 2010

    I fill out some structures in the settings tab. For various structures, proper selections are not there - for example i cant say that my iron mine is in New Orleans. It doesnt give new orleans in dropdown option. This happens with entries which have 2 selectors in their location column. Some of the selections in settings menu have a single location selector, some of them have 2 selectors with one location and one labor (days, hours) etc as seen below.

    http://i.imgur.com/xesFflN.png

    The Prices tab seems to be making calculations, but there is no way to set any buying price for anything as seen below. I click on those white cells, nothing happens. Any way to set any price is not visible.

    http://i.imgur.com/2hYYmO8.png

    Shipyard planner and production planner tabs are full kaput there is a warning for not being updated to 2.15 though

    http://i.imgur.com/Pdt2XRt.png
    http://i.imgur.com/llIB7JP.png

    ........
    When i try to save file, it says there are features which would not work in earlier version of excel (it detects the file as 2003) and it asks me to save it in a newer format to keep functionality too.

    Maybe im not using this document right. I will appreciate any pointers.


  • KasparKKasparK (Forum Moderator)
    unity said:

    I dont get an error message, but it opens in compatibility mode. I enabled editing. This is excel 2010

    I fill out some structures in the settings tab. For various structures, proper selections are not there - for example i cant say that my iron mine is in New Orleans. It doesnt give new orleans in dropdown option. This happens with entries which have 2 selectors in their location column. Some of the selections in settings menu have a single location selector, some of them have 2 selectors with one location and one labor (days, hours) etc as seen below.

    http://i.imgur.com/xesFflN.png

    The Prices tab seems to be making calculations, but there is no way to set any buying price for anything as seen below. I click on those white cells, nothing happens. Any way to set any price is not visible.

    http://i.imgur.com/2hYYmO8.png

    Shipyard planner and production planner tabs are full kaput there is a warning for not being updated to 2.15 though

    http://i.imgur.com/Pdt2XRt.png
    http://i.imgur.com/llIB7JP.png

    ........
    When i try to save file, it says there are features which would not work in earlier version of excel (it detects the file as 2003) and it asks me to save it in a newer format to keep functionality too.

    Maybe im not using this document right. I will appreciate any pointers.


    Port location of structure have no active function ie not required to set for calculations to work - it is an ease-of-use option - to help keep track of which structure you'd have in which ports.

    It was added before the Economy Pack 2.14 - before a bunch of new structures was added.
    Hence why some of the port selection field look differently, f.ex all the 'Large x' structures, the port selection option wasnt added for all the new structures or the wholes added them created.

    Also there was an idea of adding a function so that you'd only need to put in infrastructure settings for each port once and then that got transferred to each structure set to be in x port.

    The options for 'Iron Mine' includes New Orleans.
    But options for 'Large Iron Mine' have not been added (the fields have not been corrected) - it show options for the above 'working' field(the one with Select Port in it) - in this case the 'Hunting Lodge'.
    This happens/ happened as new structures was added between 'Hunting Lodge' and 'Logging Camp, Fir'.


    Buy price - say you want to set a price for 'Prize Bronze 16lb Cannon'
    Go to row 84 as shown on your screeny is next to 'Price Bronze Cannons' - click the + shown a bit to the left of 84.

    Find 'Prize Bronze 16lb Cannon' - enter your buy price in the Purchase Price column

    so on and so forth :-)


    In the Settings - dont forget to set the 'Upkeep Provision Packs'-settings.
    Player and Moderator: Moderator-comments are in [ ].
    Occasionally you will see a moderation related comment without [ ]. This is meant as a friendly advice - a 'pre-warning'.




    Production Planner Version 2.15 Beta 3 [26/8-2015] : Forum thread - Download via Forum - Download via hosted site
  • When i follow your instructions, it indeed calculates cost in the prices tab. I understand other tabs like production planner or shipyard do not work then. Thanks.

    It would be extremely difficult for me to be able to make out the instructions you described by myself. Maybe these should be present in the initial post of this topic or in the excel itself.
  • Hey, Jacky, while we're building this little POTBS museum of documents, would you want the old installer to throw up there for archival purposes? I've still got it, and I use the icon on my launcher...
    "I'm only one third crazy!"
    -NightOwlKOJ
    Low Rezzolution Entertainment
    My Discord: The Roost
  • Jack O'ConnerJack O'Conner (Forum Moderator)
    I can do. :)
    Forum Rules and Policies - Click here
    Forum Rules and Policies direct link - http://portalusgames.com/policy/website-rules/
    If you don't like the way I moderate, message me and it'll help both of us! Click here to message me
    Download Pirates of the Burning Sea Helpful Documents - Contains Economy Tracker, PvP + RvR guides, Guides for Fishing and Graphics overhaul mod!


Sign In or Register to comment.