Recent content by Corridor Chronicler

  1. C

    Excel Traveller Trade

    I am still plugging away at this, promise. I even found another mistake I made in not correctly copying a formula on the Planets Tab in cell I54. A flowchart is turning into a novella as I write it all out to make sure I understand it first. On the Trade Goods Tab, Passengers section, do we...
  2. C

    Excel Traveller Trade

    Thanks, Colin I've lived with Traveller since about 1982, its a bit of a passion project for me. Frankly I like pushing myself and seeing what I can do. And I learn more computer and data systems. I just wanted to explain why someone who'd been posting every day for several days was suddenly...
  3. C

    Excel Traveller Trade

    I hate to tell you this, but I can't find any other problems. In Libreoffice Calc anyway. It all seems to work as a layer over Arkathan's original, brilliant, system. Im a bit tired and frazzled of adding Sectors for the sake of it and I don't see much benefit to it anyway unless people want...
  4. C

    Excel Traveller Trade

    Doh!
  5. C

    Excel Traveller Trade

    I havent looked yet. H8 and L8 are size and H10 and L10 are the Hydro? Does that go above 10/A? I didnt change that as the tables starting R87 and T87 stops at 10/A Admittedly it shouldnt matter as the Hex2Dec only checks and does its thing if necessary. I cannot get corner drag/extend to...
  6. C

    Excel Traveller Trade

    I know there is something wrong with me when I can't let this go. Inter alia amendments Extended the size of Buy-Buy Hex-Sell-Sell Hex table again as some subsectors exceeded the current search range Data Validity of H2 and L2 for the new, expanded range Corrected copy paste errors in I column...
  7. C

    Excel Traveller Trade

    Oh, this isn't too hard. He said I can do this. He said I should add Deneb so you could work from the Trojan Reach to Corridor in one go. He said What could go wrong? He honestly believed. As it turns out, quite a lot can go wrong. I have had a stab at Deneb. Now Deneb has subsectors that...
  8. C

    Excel Traveller Trade

    Found and corrected some silly copy/paste errors in Column H of the Planets Tab. Had a stab at creating Corridor sector data. Harder than I thought, even following the well presented instructions. Any comments, debug or other warmly welcomed.
  9. C

    Excel Traveller Trade

    Okay, here is a very much WIP. But if it works I will try to add Corridor Sector next.
  10. C

    Excel Traveller Trade

    Still plugging away on this and lots is coming together. Changing LookUp to Index and Match on the Planets Tab and trying to save time with some conditional references. But this makes my eyes bleed. IF(K53="","",INDEX(INDIRECT("'"&Sector_Name&"'!"&"$AK$2:$AK$1281"), MATCH(INDIRECT("R[-2]C"...
  11. C

    Excel Traveller Trade

    I think that Index and Match might work better, there is something with the formatting or formulae in the sector data cells that is causing LookUp to hiccough. Back to ChatGPT to explain it all to me. I hope your life is better than the earlier posts about some difficult situations (without...
  12. C

    Excel Traveller Trade

    *cough I would But I still can't get the extra sheets to work as I think they should. But I think its a VLookup issue in Libreoffice not returning the result anticipated. I will try it in GoogleDocs later in case that's a factor. My current personal WIP version is a mess of notes and...
  13. C

    Excel Traveller Trade

    I apologise wholly if I came across as critical of your work or as though I was calling you out for additional input. I did not intend that at all. The work is amazing. I was just pointing up some issues with the expansion for bug fixing purposes. The core functionality works as intended.
  14. C

    Excel Traveller Trade

    This is an excellent and wonderful tool. The only 'bug' I found is that the formulae are set up for subsectors up to 32 worlds and so it doesnt work fully for, as an example, Tobia/Trojan Reaches which has 34 systems. The data is there but you have to edit the formulae that look to the sector...
Back
Top