Recent content by myrmidon009

Here is v1.4.1. The major changes are as follows: Added a subsector map on the 'Input' tab. This shows all subsectors adjacent to the purchase sector, as well as all adjacent subsectors and their corresponding sectors. Updated lookups on 'Input' tab to filter system info based on system name...

Okay, thanks. And just checking - it looks like there are no repeats on subsector names, so I should be able to use sector or subsector to find the correct system. I blame the Imperial Scout Services for not doing a more thorough checking of system names to ensure no duplication occurs when...

Right now my main goal is having a tool for the trade rules from the Core Rulebook. The two you mentioned (finetuning the price tables and tariffs) are outside of that scope. I want to stay focused on getting the core trade rules working. Of course feel free to make any mods you like! User...

In case didn't see them, there are actual maps on the 'Mapping' tab over in columns X and AC for the purchase sector and sale sector, respectively.

Here is v1.4. The major changes are as follows: Corrected the look-up for the Sale Subsector drop-down on the 'Input' tab. (This should fix problems with the subsectors not updating.) Fixed jump distance calculations. (This should fix problems with the jump distance calculations.)...

This is a conditional formatting thing. I identified the source. It will be fixed in the next version.

For updating the subsector list or the systems list, you have to click the 'Update Systems Box' button after selecting a new sector or subsector. This brings in the new subsectors (for a new sector) or new systems (for a new subsector). This process is covered in step 2 of how to use the tool...

I have a busy week and so may not have time to revise the tool for a little while. In the interim, I figured I'd let you know at least what's going on and provide some working solutions. The code failing on the highlighted line (with the range "PurPurPrice"): The "PurPurPrice" range name is a...

It's not using the law level difference. I'm not seeing any issues on my end. Could you send me your file and I'll take a look at it?

Here is v1.3.1. The major changes are as follows: Updated the tool to use named ranges for all cells from which or into which data is copied. Updated code to use named ranges instead of column numbers. (Note: this should allow users to add columns without throwing off the macro. Adding rows...

To your earlier question - Yes, you are correct. Adding the column threw off the macro. It's just copying values from a specific column, so if a column gets added, that throws off the code. To fix that, I think I can use named ranges instead of columns. The named ranges should stay linked to...

Please, tinker away! I hope people adjust this to best fit their needs. I'll have to think about adding that. My hesitation is that the listed purchase price may not represent the price at which they actually bought the goods. For instance, in the campaign I'm running, the players bought...

Here is v1.3. The major changes are as follows: Added check to see if jump distance exceeds ship's jump range on 'Input' tab. Added way to indicate manual generation of trade goods on 'Input' tab. Added conditional formatting on 'Purchases' tab when manually generating trade goods. Moved 'Tons...

Here is v1.2. The major changes are as follows: Corrected the label for selling on the black market on the 'Input' tab. Terry Mixon, the formulas for the DMs are correct. If you look in the 'Roll' columns on v1.1, you will see that it uses all four DMs. The 'Known DM' columns are where the...

Here is v1.1. The major changes are as follows: Added some clarifications to the 'Instructions' tab. Moved the modding instructions to the 'Modding Instructions' tab, which is hidden. Added details and illustrations for clarity. Fixed the labels for freight on the 'Sales' tab. Corrected the...