Excel Traveller Trade

[Terry Mixon]

Brain yes, Life no.
Been dealing with a frivolous lawsuit from a litigious inmate that is currently over five years old. Coincidentally, I've been retired for nearly that long.
Since the legal system does not charge him money for making false allegations, and instead appoints lawyers to assist him, the fact that he has no case does not deter him from a campaign of harassment while he sits in prison for at least another ten years.
The inmate did not like an agency policy that prevented inmates from getting mail soaked in K2 and Raid (yes, Raid - we had eleven inmates go to the hospital in one night from a bad batch, and in lieu of dying, one inmate admitted to what they'd been smoking) so he sued me personally over the agency policy, and a liberal appellate judge reversed the sane judge's decision and allowed the suit to continue. At least the judge DID drop the part where we took his cane after he checked himself out of the medical dorm against medical advice. (Can't have weapons in general pop. That's why we have a medical dorm so that they can have those accommodations).
TMI, I know, but that is what is keeping me from attacking more important problems like RPG trade and skip and hop drives in the ship designer.

I’m sorry to hear that. Hugs.

 

[Terry Mixon]

Brain yes, Life no.
Been dealing with a frivolous lawsuit from a litigious inmate that is currently over five years old. Coincidentally, I've been retired for nearly that long.
Since the legal system does not charge him money for making false allegations, and instead appoints lawyers to assist him, the fact that he has no case does not deter him from a campaign of harassment while he sits in prison for at least another ten years.
The inmate did not like an agency policy that prevented inmates from getting mail soaked in K2 and Raid (yes, Raid - we had eleven inmates go to the hospital in one night from a bad batch, and in lieu of dying, one inmate admitted to what they'd been smoking) so he sued me personally over the agency policy, and a liberal appellate judge reversed the sane judge's decision and allowed the suit to continue. At least the judge DID drop the part where we took his cane after he checked himself out of the medical dorm against medical advice. (Can't have weapons in general pop. That's why we have a medical dorm so that they can have those accommodations).
TMI, I know, but that is what is keeping me from attacking more important problems like RPG trade and skip and hop drives in the ship designer.

I'm no excel guru, but I think I made it work on a sheet I modified. First, I added two new columns so that there is both a Buy and Sell DM for BOTH the origin world and the destination. It was easy enough to change where the visible part of the spreadsheet pointed to and isolate the two so the codes for the correct world are being used for selling and buying as appropriate.

Then I looked at the trade code modifiers and there were only two fields with potential negative modifiers. I changed both of them to check for negative modifiers and use them before getting the max of the positive numbers

Common Consumables BUY: =IF(N3,-4,MAX(IF(N2,3,0),IF(N19,2,0),IF(N7,1,0)))

Radioactives SELL: =IF(N2,-3,IF(N15,-2,MAX(IF(N11,3,0),IF(N9,1,0))))

For the issues I was seeing, that fixed it for me, but as you said earlier, there are other implications for the changes. I just wanted to share what I'd done in case it proved helpful.
.
EDIT: Because only having one roll for buying AND selling was bugging me bad, I added a separate cell for the selling roll and then referenced it in the sales price chart. It was easier than I expected and now one calculation gets buying and selling in one go with appropriately different results for the ORG and DEST.

 

[deHap]

I'm no excel guru, but I think I made it work on a sheet I modified. First, I added two new columns so that there is both a Buy and Sell DM for BOTH the origin world and the destination. It was easy enough to change where the visible part of the spreadsheet pointed to and isolate the two so the codes for the correct world are being used for selling and buying as appropriate.

Then I looked at the trade code modifiers and there were only two fields with potential negative modifiers. I changed both of them to check for negative modifiers and use them before getting the max of the positive numbers

Common Consumables BUY: =IF(N3,-4,MAX(IF(N2,3,0),IF(N19,2,0),IF(N7,1,0)))

Radioactives SELL: =IF(N2,-3,IF(N15,-2,MAX(IF(N11,3,0),IF(N9,1,0))))

For the issues I was seeing, that fixed it for me, but as you said earlier, there are other implications for the changes. I just wanted to share what I'd done in case it proved helpful.
.
EDIT: Because only having one roll for buying AND selling was bugging me bad, I added a separate cell for the selling roll and then referenced it in the sales price chart. It was easier than I expected and now one calculation gets buying and selling in one go with appropriately different results for the ORG and DEST.

Maybe possible you share your edited version?

 

[Terry Mixon]

Maybe possible you share your edited version?

I likely broke some of the elements that I don't use in making these changes. Also, I don't want to muddy the waters. It would be far better if the main spreadsheet were updated so that we all have access to the same file. This is Arkathan's baby and he will likely get around to making the changes when life cooperates.

​