• Announcements

    • IMPORTANT - REACH US IN THE NEW FORUM   05/04/2017

      Ladies and gentlemen ATTENTION please:
      It's time to move into a new house!
        As previously announced, from now on IT WON'T BE POSSIBLE TO CREATE THREADS OR REPLY in the old forums. From now on the old forums will be readable only. If you need to move/copy/migrate any post/material from here, feel free to contact the staff in the new home. We’ll be waiting for you in the NEW Forums!

      https://community.blackdesertonline.com/index.php

      *New features and amazing tools are waiting for you, even more is yet to come in the future.. just like world exploration in BDO leads to new possibilities.
      So don't be afraid about changes, click the link above and follow us!
      Enjoy and see you on the other side!  
    • WICHTIG: Das Forum ist umgezogen!   05/04/2017

      Damen und Herren, wir bitten um Eure Aufmerksamkeit, es ist an der Zeit umzuziehen!
        Wie wir bereits angekündigt hatten, ist es ab sofort nicht mehr möglich, neue Diskussionen in diesem Forum zu starten. Um Euch Zeit zu geben, laufende Diskussionen abzuschließen, könnt Ihr noch für zwei Wochen in offenen Diskussionen antworten. Danach geht dieses Forum hier in den Ruhestand und das NEUE FORUM übernimmt vollständig.
      Das Forum hier bleibt allerdings erhalten und lesbar.   Neue und verbesserte Funktionen warten auf Euch im neuen Forum und wir arbeiten bereits an weiteren Erweiterungen.
      Wir sehen uns auf der anderen Seite!

      https://community.blackdesertonline.com/index.php Update:
      Wie angekündigt könen ab sofort in diesem Forum auch keine neuen Beiträge mehr veröffentlicht werden.
    • IMPORTANT: Le nouveau forum   05/04/2017

      Aventurières, aventuriers, votre attention s'il vous plaît, il est grand temps de déménager!
      Comme nous vous l'avons déjà annoncé précédemment, il n'est désormais plus possible de créer de nouveau sujet ni de répondre aux anciens sur ce bon vieux forum.
      Venez visiter le nouveau forum!
      https://community.blackdesertonline.com
      De nouvelles fonctionnalités ainsi que de nouveaux outils vous attendent dès à présent et d'autres arriveront prochainement! N'ayez pas peur du changement et rejoignez-nous! Amusez-vous bien et a bientôt dans notre nouveau chez nous

Contribution Point Management Spreadsheet

10 posts in this topic

Posted

Don't you hate when you're out of available Contribution Points and so you have to go clicking through housing units in all the various cities and towns, or through all the nodes that you are invested in to try to figure out where you have CP invested that you can free up? Or maybe you were wondering how many storage units or worker lodgings you are renting in a particular city? Or, what if you want to invest some CP into storage in one of those "off the beaten path" towns but you don't know what city that storage adds to?

 

To help resolve these and many other CP related questions, I have created a BDO CP Management spreadsheet. In this spreadsheet, via the use of handy little dropdown lists, You can indicate what nodes you are investing CP into, and what housing units (Storage, Lodging, Workshops, Shipyards, etc...) you are invested in for every city/town location in the game. All the units and nodes in the game are built into the spreadsheet (As of 3/24/2017, North America Version). It might take you a little time to get your situation entered into the spreadsheet, but it may be worth your time. For others, especially those who change their investments very often, this may be a little too much. but you may still find some use for it.

 

Here's a quick rundown of the different Worksheets included:

 

Summary:          This is the main sheet to use to see where your CP Investments are. The only thing you have to do on this sheet is select the dropdowns available in the Highlighted Yellow cells. Doing this will give you the ability to quickly drill down to a city, Housing Unit type, and harvestable node type to see how many CP you have invested in those specific items. All other cells on this sheet autoupdate.

 

City Unit Usage: On this sheet, you will record all the housing Units ("Housing Units" are the buildings you rent to use as Storage, Lodging, Workshops, etc.) being used for each city or town. For each unit you are invested in, select the Region, City, and Location that the unit is in using the dropdowns. When you select a Region, such as "Balenos Region" for example, only the Cities within that region will show up on the next dropdown (For Balenos, it shows Olvia, Velia, and Iliya Island). Then you select the Location Dropdown. If you select Olvia for the city, then the Location dropdown will the give you a list of Locations whose rental units apply to that City, such as Olvia city itself, Casta Farm, Wale Farm, and Lema Island. (This will help you learn what cities those remote locations' storage applies to). After selecting a location, then you can select which building unit you are renting (1-1, 1-2 Level 2, etc...). Once you select the Unit, the CP cost of that unit populates and you can then select the Unit Type dropdown to select the purpose the unit is being rented for (Storage, Crop Workbench, Horse Ranch, Shipyard, etc...). The Unit Type dropdown will only show you the Unit Types available for that specific unit so there's no guessing involved. You can use this sheet to add all the units you are invested in, or even to figure out how much CP certain situations would cost. Anything selected on this sheet is reflected on the Summary sheet.

 

 

Node List:           This is a listing of all the nodes in the game that you can invest into. I added these so that when you indicate that you're invested in a node, if it has subnodes, those subnodes investments will become available. For instance, You can invest 1 CP into Casta Farm without investing into the G----- node at Casta Farm, but you cannot invest into the g----- node, without first investing into Casta Farm. To add all the nodes you're invested in, simply go through the list of nodes and indicate Yes in the "Invested?" column for each. Each Row on that sheet lists the node, and each subnode located at that location is listed to the right of the main node. You must indicate investment in the main node (by indicating "Yes" in Column D) before you can invest in the subnodes. With this sheet, you can either use it to actually record all your invested nodes so you know how much CP you're using on your node empire, or you can use it for research. With every node in the game listed, it's easy to figure out where all the potato nodes are, or where to get Trace of Savagery from. As you mark nodes as being invested in, the cost of those nodes are reflected on the Summary sheet.

 

Rentals:              The Rentals tab was a quick addition to help account for CP used by Fence rentals and such. I didn't want to try to identify every rentable item in game so instead, I made this sheet a Fill in the blank. Simply add into the table the items that you are renting for Contribution Points, such as Gardening fences, practice muskets, remote storage containers, accessories, etc…, add the CP cost of them and how many of each, and the total CP will auto calculate. Then those items will be accounted for on the main Summary sheet for your total CP Usage.

 

I encourage you to download a copy of this spreadsheet to use, play with, extract data out of it, whatever. I hope it help some of you. It took a long time to gather and enter all the node and unit location into this sheet in the format I needed to make this work, let alone figure out all the formulas needed to get those dropdowns to work right. I welcome your feedback, and I hope this is useful to you.

Simply download a copy of it to your local computer and open it with Excel.

BDO_CP_Management.xlsx

3 people like this

Share this post


Link to post
Share on other sites

Posted

While I was going through the spreadsheet adding my node and housing unit investments, I found that I forgot to add the Bernianto Farm and Excavation node into the spreadsheet. In the attached revision, I have that node added properly.

 

A few other additions I made include:

              -You can enter your total CP in the Top Center Yellow cell on the Summary page and with all your investements entered, it will show you how much you are using as well as how much CP of total you have remaining(Available/Total), just like you see in game.

              -Total # of housing Units occupied for the selected City on top left of Summary page. I added this so that you can quickly see the number here and compare it to the number listed in game when you hover over a City. Only thing is, this will be off if you invest into outlying locations that attach to the city.

              -Full listing of how many of each unit is occupied in addition to the already existing list of how much CP is invested into each type.

              -Total # of Main nodes invested into. I added this to help when adding your nodes. If you go in game and change your map view to see only nodes, and you count the number of nodes you’re invested in, it should equal the number listed here.

              -For each resource, I also now have a total of how many nodes you are invested in.

 

After entering all the information for how I am set up in game, all the numbers match properly. This version I’m uploading as Revision 1a is how I left it after entering all my CP investment information.

BDO_CP_Management_Rev1a.xlsx

Share this post


Link to post
Share on other sites

Posted

That will be very useful to me personally, I will check out your spreadsheet once I am home from work.

I have been thinking about analyzing my cp investments for a while now and optimizing it, cp is like gold dust and I am always starved. Haha! I'd really like to know where the hell all of my 257 cp points are tied up in. (Hint: Most likely storage)  

I was planning on doing all the tedious work myself but am usually too burnt out after work and kept procrastinating! So thanks for your effort :)

 

 

Share this post


Link to post
Share on other sites

Posted

whoa, nice. thanks dude. will nerd out on this at home

Share this post


Link to post
Share on other sites

Posted

Is there a way to get this on google sheets? I can 't use the exl program on my computer :/

Share this post


Link to post
Share on other sites

Posted (edited)

Is there a way to get this on google sheets? I can 't use the exl program on my computer :/

yeah, just uploading it should work.

nvm i actually opened the spreadsheet. I'll see if i can do anything with this but chances are... meh haha. He's done a lot of work on this ss.

Nvm you can just upload it.

Edited by War

Share this post


Link to post
Share on other sites

Posted

Nvm you can just upload it.

Checks out. 

Share this post


Link to post
Share on other sites

Posted

Yeah, I saw that full chart after I had manually entered all the info into my sheet. But, I don't think his chart has Valencia region yet.

Share this post


Link to post
Share on other sites

Posted (edited)

just started filling it out but i have an issue starting in velia I can not register my lodgings , any idea why ?

 

EDIT: nvm I something got corrupt.

 

thank you for this made a lot of peoples life much easier :) !

Edited by Infused

Share this post


Link to post
Share on other sites