Board Thread:The Last Sovereign Discussion/@comment-31763506-20171218040836

OK, I THINK I have everything. EDIT: Worksheet subdivision and formatting changes made in response to Fulminato's entitled whining reasonable feedback.

I made a spreadsheet of all the investment/ProN spending opportunities in Ch4. You can get it here:

http://www.mediafire.com/file/ipriypeqoyloq0v/TLS_Ch4_Investments.xlsx/file

Hopefully people more talented with Wikia can use this to make the new and improved investments page when the time comes.

Note this is subject to change/rebalancing in future revisions.

It has been subdivided into four six worksheets.

HQ Upgrades

Profitable Investments

Non-Profitable Investments

Ch 3 End Investments

Ch1-3 Missed Investments

Old Investment Profits

The spreadsheet has three one field s defining where the investment can be found on the game map, with color coding by the destination crystals in the game's teleportation chamber; the investment name as it appears on the ledger if applicable and a description if otherwise; the internal RPGMaker switch name associated with the investment; necessary preconditions for the investment; the cost in ProN; the effects on the various secret stats; and the RP effects. The ROI per Ch4 investment iteration, an expression of the ROI per iteration as a percentage of the investment cost for priortization (but don't try to sort on it or Ivala help you) and other notes are included where applicable.

The 64 66 possible investments are ordered within the four worksheets in a deranged collation of my own design, which is (roughly) anti-clockwise from 12:00 for each region as it appears in the teleportation chamber; then anti-clockwise from the North center of each map for all investments on that map, then anti-clockwise for each sub-map accessible from the parent map... and so-on. (This seemed appreciably less insanely stupid when I thought of it.)

Updated to version 0.38.1, purged None per will of Decanter, added benefits to Ardan Succession and Erosian Conflict sections.

Updated to version 0.41.4, adding Ardford businesses.

Updated to 0.42.3, added investment effects to army calculations.

Updated to 0.45.6

Updated to 0.49.2 