-Please make sure you have verified your forum account email address.
For security reasons logins using your Username is disabled.
-If you created your forum account prior to October 2013 and did not login to that account on the Vanilla hosted forum between June 2015 - July 2018 then all password reset attempts will fail. You will need to create a new account to fully access the forum.

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

Jack O'ConnerJack O'Conner (Forum Moderator)
edited February 2017 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?
  • 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.
  • 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...
  • edited February 2017
    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 Administrator)
    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.
    Support your game. Head over to the BSN-store:
    Pirates of the Burning Sea Store
  • 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...
  • 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.