Editing XLXS files and using console.

How to work on those *.xlxs files
and the console to take the grind out of game at this point.

You can use this guide to edit :xlxs files, then create a new game + eventually save the game.

But why?
Maybe because your career/save you used hours for just won't load anymore for some reason.

Or whatever other shenanigan reasons.

Disclaimer.

Be careful when editing game files, in this case, those xlxs excel / calc files.
Or using the in game console.
You can easily render you game to a useless pile of dung.
If that happens, use the steam Verify Game Files command to
download those broken files. (and start modding again ;) )
I take no responsibility for anything, really, use this guide at your own risk.
You have been warned.

Also, at the creation of this guide the game was in UNSTABLE/Early Access/Beta stage:
B119 Preview 9 - Unstable branch (Updated 15.05.2019 00:35)

So, the game might be something totally different later on when you're reading this
therefore this guide might be not so useful anymore.

I used information I found in these links and I'd like to thank them:
L34T's console guide:

Console commands [EN/RU] 

A Guide for UBOAT

By: GKV2403

To open console press "~" (area specific: @ / ñ / :æ / Ö or Ctrl+Alt+~)

Finny's Console Help - Some quickie helpers for the masses:
https://steamcommunity.com/app/494840/discussions/0/1651043958639996365/

- ossi

Information, tools, etc.

As the game is in Beta/Unstable mode, its bugged, saves won't always load etc...
I was playing sandbox mode but I got frustrated of bugs/restarts/loading save errors.
So, what else there is to do? Well, we can mess with those files and learn about the console.

Editing those *.xlxs files:

They are located at ...\Steam\steamapps\common\UBOAT\UBOAT_Data\Data Sheets folder.
For editing, I used LibreOffice Calc and/or Microsoft Excel, both works,
LibreOffice is free to download:
https://www.libreoffice.org/

Use latest patch and files!

Always use the latest game files, keep the game updated!
Im on B119 Preview 9 - Unstable branch (Updated 15.05.2019 00:35)
when I started doing this guide and them files keep updating almost everyday.

It's important to back up those files before editing or you can mess up the game.
If that happens, use the Steams own "Verify files" option to download original files again:
Right-click on the game in your Libraries and choose Properties:



..then:



and all is good to go again:




You don't need to uninstall + reinstall the whole game as
Steam will know what files are not original anymore.

I'm an old subsimmer and I use JSGME app to quickly swap files in that Data Sheets folder.
I use that in many games where I need to swap files easily from original to my edited files.
JSGME's task option "Generate snapshot of game files" does not like really big files,
so I would not use that, instead, I would use Steams own Verify files option...

Subsim JSGME download[www.subsim.com] (needs registration to download)
Download without reagistration: https://www.filecroco.com/download-jsgme/
How to use it? Google it,
here's couple of videos about JSGME:

YouTube™ Video: JSGME How to Guide for DCS (skip snapshot for DCS 2.5 or higher) 

Views: 24,406

I now recommend using OVGME, if you want to use JSGME continue reading *********************** IN DCS 2.5 OR HIGHER SKIP THE SNAPSHOT SECTION because the file size of some of the Nevada files is too...

https://www.youtube.com/results?search_query=JSGME

http://www.subsim.com/radioroom/index.php
Subsim forums has a lot of cool info about JSGME and other submarine games too.

About the console:

Couple of links where I got the info about console commands:

L34T's console guide: and

Finny's Console Help - Some quickie helpers for the masses:


To bring up the Debug Console:
~ (tilde)
And for the guys with the german keyboard layout it is the "Ö" oe-key for opening/closing
the console.
Ø if u use scandinavian KB.

You can also copy/paste these commands to game console.
Copy the command from this guide and paste it with CTRL+V in the console in game.
If you get errors in console, it's most likely because you didn't type it right.
For example, a word "Budget" works but "budget" will not.
Words are case sensitive.

Okay, since we got the basics outlined, lets dig into the game files in the next section of this guide.

Backup files before editing.

Make a backup of those xlxs files somewhere, or use JSGME app like I do.

You can also do it manually. Create folder somewhere and copy those xlxs files from
game directory to your newly created folder. I just use JSGME to make the file swap
from original files to my edited files faster.

Before launching the game...

Edits must be done before starting the game. The game executable will read our edits when it starts.
I think the game loads those xlxs files only at the start and/or loading a save.
So lets start by editing a single file.

How to get all research done right at start before going to patrol/mission,
with zero cost and using no time at all?

Take a look at this pic to learn about Sheet, Rows and Columns in excel files.
It will come handy later in this guide.


Open up Sandbox.xlxs for editing.


Some explanation of that pic:
Number 1 is name of the file we're working on.

Number 2 is Reputation Purchases SHEET at the bottom.

Number 3 are those ROW numbers on the left, Rows 1 to 6

Number 4 are those COLUMNs
Change column D (Cost) cell values from 1 to 0.

All costs 0 now, you can get those right at the game start
since we got zero reputation.

Lets change to the Tasks sheet that is the first sheet in this file.
It's in the same file but different sheet, take a look:

ROWs 12,13 and from 76 up to 96

COLUMN C (also named as Duration)
Change values to 0 those cells, this will take the time off from research.

COLUMN J (Slots)
Change values in cells to Radioman, this will make the game need only a radioman for the research.

Now, save and close the file.

Launch the game...

Start a new Sandbox mode game and after you're in the dock,

Use the console:

Bring up the console and type Budget 500000 , hit enter and close the console.
Now that we've got the cash, you can go buy some stuff:
and you can buy more Officers from recruiter, but I used the starter Officers in this guide.

Using the console to add XP points to officers

click on the sea so that no single officer is selected,
that way we get XP points on all of them.

Type in the console XP 250 and close it

Now we can get to those new skills:
Again, add 250 XP's until officers get promoted, choose a new skills for them, rinse and repeat the process.

OR, you could add XP 10000 but then the game (at this point) will add random skills,
at UNSTABLE branch game, I think the skill tree is a bit bugged.
But the same method should work no matter what version the game is.

Lets see what we did on the Sandbox.xlxs file:

So, our edit got us free stuff. Lets get to Headquarters and do some research:


This info should get you started, when you got the stuff/upgrades you need, save the game,
or just go have some fun with patrol mission, or freeroam...

Shenanigans...

What else we could do? Quite a lot at this point, refer to the first image if you got trouble finding
where you can edit stuff. I'm talkin' about Sheets, Rows and Columns here only, no pics anymore
since you should understand by now how to edit excel files.
If not, well, check out youtube, it has bunch of videos about using excel:

https://www.youtube.com/results?search_query=excel+for+sheet+row+column+cell

YouTube™ Video: Understanding spreadsheet rows, columns, cells, workbooks, and sheets 

Views: 1,928

http://courses.robobunnyattack.com/courses/step-by-step-spreadsheets-for-absolute-beginners Meet your spreadsheet! Start up a new spreadsheet, and let's have look around.

So, I make simple text files for myself about what I've found and edited.
Here's some examples:


************************************

Crew getting sleepy too fast?

Open General.xlxs
Go to Settings SHEET
ROW 59 right under under /Energy and COLUMN B
Original value was : 0,00035
New: 0,00000035
Edit the number value, add some zeros so it looks like that new value,
and now the crew energy level drops very much slower

************************************

Make that pump get rid of water faster:

Parameters.xlsx
SHEET Trim Pump
ROW 2 and COLUMN B LitresPerSecond was 0.06 , and now edit it have 100 (liters per second)

We have other file to edit for Noise and EnergyUsage:
In the Entities.xlxs
Equipment SHEET
ROW 97 Trim Pump
COLUMN P
Values:
ORIG:
LitresPerSecond = 0.06, Noise = 0.4, EnergyUsage = 0.0002
NEW:
LitresPerSecond = 100, Noise = 0.1, EnergyUsage = 0.0001
Here's also that "LitresPerSecond" so make sure it's the same in both files.
And now noise and energy usage is lower too.

************************************

Ventilation faster:

Entities.xlxs
SHEET Equipment
ROW 252
COLUMN P (Parameters)
Ventilation, fixed for less energy more oxygen etc.
ORIG: EnergyUsage = 0.0002, Noise = 0.4, OxygenGain = 0.003, RegenerationLimit = 2.0, ItemsMassLimit = 50
NEW: EnergyUsage = 0.00001, Noise = 0.1, OxygenGain = 0.3, RegenerationLimit = 4.0, ItemsMassLimit = 50

************************************

You want instakill torpedoes?

T1 torps may still be duds, but I try to use T2's and T3's most of the time.
You could teleport to other ports and get more gear and better torps.

It might help to upgrade/promote the engineer to get less duds. (Use console to add XP and skills)
You can "fix" all the torpedos to have these values. Example here is for T1 but you can easily
edit so all torps have the same punch:

Entities.xlxs
SHEET Types
ROW 36 G7a Torpedo (T1)
COLUMN Q (Parameters)

ORIG:
Range1 = 5000, Range2 = 7500, Range3 = 12000, Speed1 = 81, Speed2 = 74, Speed3 = 56, DudChance = 0.25, Damage = 4.2, CrewDamage = 0.8, DamageRadius = 20, DamageEffectsRadius = 7.0, DamageEffectsIntensity = 1.0, IndirectVisualDetectability *= 0.0, HullBaseVisibilityFactor *= 0.08, ArmDelay = 11.0

NEW:
Range1 = 7000, Range2 = 7500, Range3 = 12000, Speed1 = 81, Speed2 = 74, Speed3 = 56, DudChance = 0, Damage = 80.2, CrewDamage = 4.8, DamageRadius = 90, DamageEffectsRadius = 15.0, DamageEffectsIntensity = 1.0, IndirectVisualDetectability *= 0.0, HullBaseVisibilityFactor *= 0.08, ArmDelay = 2.0

Also in the
SHEET Equipment
ROW 56 G7a Torpedo (T1)
COLUMN P (Parameters)
(values are not the same as in Types sheet, look out)

ORIG:
Range1 = 5000, Range2 = 7500, Range3 = 12000, Speed1 = 22.5, Speed2 = 20.5555, Speed3 = 15.5555, DudChance = 0.19, Damage = 4.2, CrewDamage = 0.8, DamageRadius = 40, DamageEffectsRadius = 7.0, DamageEffectsIntensity = 1.0, MaintenanceCooldown = 1200

NEW:
Range1 = 7000, Range2 = 7500, Range3 = 12000, Speed1 = 81, Speed2 = 74, Speed3 = 56, DudChance = 0, Damage = 80.2, CrewDamage = 4.8, DamageRadius = 90, DamageEffectsRadius = 15.0, DamageEffectsIntensity = 1.0, MaintenanceCooldown = 1200

************************************

AA guns goes instakill.

If you raise the radius of a bullet/ammo/torp, you could damage your sub/crew,
if you accidentally shoot waves close to your sub or somehow shoot your on sub.
I know, happened to me :D

Entities.xlsx
SHEET Equipment
ROW 136 MG C30 (first TURM you get with new game)
COLUMN P (Parameters)
ORIG:
Calibre = 20, Range = 3000, ReloadTime = 5, MagazineSize = 30, HorizontalRecoil = 1, MinVerticalRecoil = -0.3, MaxVerticalRecoil = 0.7, SeriesTimeOffset = 0.1, RecoilDuration = 0.3, RecoilRecovery = 0.2, RecoilGrowthRate = 0.07, RecoilRecoveryRate = 0.99, SkippedShells = 1

(most useful is to atleast change reload time from 5 to 1 second)
NEW:
Calibre = 20, Range = 3000, ReloadTime = 1, MagazineSize = 60, HorizontalRecoil = 0.1, MinVerticalRecoil = -0.1, MaxVerticalRecoil = 0.2, SeriesTimeOffset = 0.1, RecoilDuration = 0.1, RecoilRecovery = 0.1, RecoilGrowthRate = 0.01, RecoilRecoveryRate = 0.1, SkippedShells = 1

************************************

After upgraded for TURM-IV with 43U, I changed only the reload time to 1 second

Entities.xlxs
SHEET Equipment
ROW 138 43U
COLUMN P (Parameters)
ORIG:
Calibre = 20, Range = 3000, ReloadTime = 5, MagazineSize = 120, HorizontalRecoil = 1, MinVerticalRecoil = -0.3, MaxVerticalRecoil = 0.7, SeriesTimeOffset = 0.1, RecoilDuration = 0.3, RecoilRecovery = 0.2, RecoilGrowthRate = 0.07, RecoilRecoveryRate = 0.99, SkippedShells = 3

My values: only change is reload time to 1sec, it helps a lot
Calibre = 20, Range = 3000, ReloadTime = 1, MagazineSize = 120, HorizontalRecoil = 1, MinVerticalRecoil = -0.3, MaxVerticalRecoil = 0.7, SeriesTimeOffset = 0.1, RecoilDuration = 0.3, RecoilRecovery = 0.2, RecoilGrowthRate = 0.07, RecoilRecoveryRate = 0.99, SkippedShells = 3

************************************

Ammo for 20mm AA-guns

Very much overpowered as you could shoot at targets and instakill anything,
even your own ship/crew if the bullet hits close enough!

Keep in mind, if you mod ammo, it's not always just for player ship,
I think other ships/planes might use the same ammo and shoot you back! :D
I'm not 100% sure of that, thought, but if that happens, you know why.

Entities.xlxs
SHEET Equipment
ROW 198 Ammo Small Calibre HE - 20 mm
ORIG:
DamageRadius = 6, Damage = 0.085, CrewDamage = 0.65, DamageEffectsRadius = 0.2, DamageEffectsIntensity = 1.0, InitialVelocity = 900, MinDetonationVelocity = 150, ArmorPiercing = 0.0, Mass = 0.12, SelfDestructDelay = 3.5, ProximityExplosion = 0, TracerDuration = 26

NEW:
DamageRadius = 60, Damage = 50, CrewDamage = 50, DamageEffectsRadius = 5, DamageEffectsIntensity = 1.0, InitialVelocity = 1500, MinDetonationVelocity = 150, ArmorPiercing = 1.0, Mass = 0.12, SelfDestructDelay = 3.5, ProximityExplosion = 0, TracerDuration = 26

************************************
17th. of May,
I did some edits for layout and formatting.
Fixed some typos.
Added 1 more pic.

Have fun!

[Astolfo]

Yup, it's broken, aaaahh i love when games devs don't want us to be able to play the game how we would like to...even tho we paid.... :)

[=7Cav=SPC.Crimzon.E]

Doesn't seem to work anymore
File stays corrupt no matter how you edit it

[555eatshit]

Err... I'm a bit confused.
I changed some values, started a new game, but it doesn't seem to do anything in the game.
What am I doing wrong?
Do I need to move the xls somewhere else?

[L34T]

@Hydrazombie
You could try change cell format from Auto to Text. Maybe this helps

[Hydrazombie]

I edited generals xlsx settings tab, enable developer console to True. In game pressing the squiggly key does nothing

[Cervecero]

Nice but... how to get a Blueprint? :)

[Airplayn]

Now we need the same thing for the new UBE *.dat file modification if possible without programming with Python or whatever they used.

[El Nachos]

unlimited battery plssssssssssssssssss plssssssssssssssssss

[beast902]

how about longer career ?

[ossi]

For "How do I...." questions, answer is I don't know, you need to explore the files and try something yourself. This guide is not up to date on details but hopefully gives you ideas how to do modifications on XLXS files.

I think I'll do some sort of update after release but we'll see about that later...

Right now the game moves forward so fast it'll be silly for me to try to keep this guide updated
plus I have so much stuff to do in real life atm. that I can't keep up with this guide.