Post #2005561

2026-05-03 10:25 UTC

Oh gawd. This is incredibly difficult. I thought I'd got it about right, but having just punched in all my numbers the spreadsheet values are nowhere near the actual ones. Turns out buildings and planet designations make a biiiig difference, which I haven't accounted for. #Stellaris

Replies (3)

@Hyperlynx@aus.social 2026-05-03 10:26

Also, I seem to have become Spiritualist by accident. I suspect I pushed the wrong button in an event at some point. Not what I wanted to happen. Kids, don't run an interstellar empire while you're drinking!... #Stellaris

Open ##2005562
@Hyperlynx@aus.social 2026-05-04 00:37

Well, at least I know how to use VLOOKUP now. Tell you what, this is all still a pain in the backside without decent variable names, having to use column letters instead! I guess there might be a way in LibreOffice to give a column a name, but I haven't found it (though there's plenty of slop that offers obviously wrong answers) #spreadsheets #LibreOffice

Open ##2005564
@Hyperlynx@aus.social 2026-05-04 05:48

So, apparently, "job efficiency" is indeed a direct percentage plus to the input and output of a job, per pop. It is not a percentage increase to the number of pops who can work a job, as the random Steam thread I found would suggest. So, I went and removed all the pop increases I'd put in and moved them to the relevant income/expendidures. I think. The numbers aren't what I think they ought to be, but that could just be my poor maths. I would have thought that 100 artisans working 10% better should produce the same amount of trade goods and use the same amount of minerals as 110 normal artisans, but the numbers aren't quite lining up. And spreadsheets are a pig to debug. I did put in district specialisations properly, since solar farm specialisation in an energy district adds farmers instead of more technicians. Then I started to finally look at buildings, and despaired. That's going to be such an enormous pain in the backside! They each have their own upkeep, and they either add to number of jobs or they add to the production of a job or they modify the upkeep or the efficiency!... I started to just add fudge factor columns, instead of a column per building, but that's almost as complicated. This project is definitely one of those "oh, that shouldn't be hard, it'll take two seconds" things that absolutely is not, in actual practice 😅 #Stellaris

Open ##2005565