Separate thread because this is not at all useful to your average player and it's a message I wanted to get directly to you.

I think the format describing which grids the patrols take place in are formatted incorrectly in the sandbox.xlsx

It looks like it could be a basic copy paste mess up.

For example in vanilla f(x) for the patrol cell reads "Ports=La Rochelle Port,Port of Brest;Difficulty=Easy;Squares="

while in the UBexpanded sandbox.xlsx it reads "Group=La Rochelle;Port=La Rochelle Port;Difficulty=Medium;Replace=True;Squares=BD1-BD4:0.1,BD1-BD2-BD3:0.1,BD4-BD7:0.1,BD7-BD8:0.1,BD8-BD9:0.1,BD3-BD6:0.1,BD6-BD9:0.1"

Three very significant format differences.

One, Port of Brest is always listed with La Rochelle.

Second, The addition of "Group=La Rochelle Port" seems superfluous.

Third, the way the actual data is formatted. notice the grid designations dont show up in the f(x) the same way in the vanilla one.

Finally, rather than the kind of run on sentence format for the ubexpanded entry - after the line ending in "Squares=" it stops, then a paragraph break (i mean hitting enter) and they include one set of cells per line. as if each line pertains to one possible mission option.


This is all I've learned. Now you know this way better than me. Perhaps what i've noticed is none of it anything that actually matters. I'm no database expert, I'm just using my general knowledge and trying to apply it so forgive me if this information is actually useless.

I just had to check after I realized that Kiel missions were wrong too. they all direct you to patrol locations west of great britain with none of them being to the east of the island instead.