Simple Dedicated Server Setup with Excel

A simple way for anyone to open a dedicated server without having to search for long codes.

I understand that you may find some images missing or that you don't like the quality, so feel free to modify them to your liking. If you find any errors, which are bound to occur, please let me know, and I'll try to fix them within my capabilities.

If it helps, I'm glad.

Other answers:

Spoiler: You must unlock the file, right click and Properties

Spoiler: You must allow the use of macros

Spoiler: How do I set up a multiclass event?

 

Hello, is it possible to download the file? i visited youtube channel and https://adictosalgas.es
bht I did not understand if there is an online configurator or an excel to download,
thanks fot the help

 

Hello... The link is in the video description.

 

Hello friend!

First of all, thank you for your help and for creating this excellent tool.
Let's go!

I put 32 players, but 26 appear
The weather was not clear, only 1
Laps
Track limit, cuts
Mandatory pit and other options were not correct on the server.

Thank you.

 

I compared the two files, sms_motd_config.json did not receive exactly the same information from server.cfg and spreadsheet, I changed it manually and it seems to be correct now, I will test it.

Thanks.

 

Problem? Choose a circuit with 32 boxes. If the capacity exceeds the circuit, it will even change circuits.
Here's a video showing it working correctly.

The rest of the climates and such... exactly the same. When you add a combo, remember to save the files before launching the server.

"sms_motd_config.json didn't receive exactly the same information as server.cfg"
Why are you comparing two different files?
sms_motd_config.json
It only contains messages sent to the chat: welcome, and in this case, the default is the welcome message and the weather.

server.cfg
Contains the room configuration.

If you want to modify the code manually, you can do so.
In fact, I encourage you to do so, but if you use this Excel file and then modify things, you're more likely to make a mistake since Excel only copies and pastes.

 

Commands? You don't need to enter any commands.
You can customize the room however you want; just click on the desired options, and most importantly, click "SAVE.".

 

HI!

I reported that when I save the preferred options in Excel, they are not being sent to the server.

The rotation file had other information than the one I chose, do you understand?
Other options were also not being sent to the rotation file.

I will download it again and test it, but I had to enter my manual choices.

 

I deleted what I had and I'm going to configure and test again.

Now, configuring again, I noticed that the first option "CLASS 1" doesn't have the arrow to select it, and below CLASS 4 it's not possible to add other classes, is this normal?

 

I looked here and the combos up to the 10th one were not included in sms_rotate_config.json
could this be the reason?

 

I usually understand what I need to understand, when it is explained to me well.

Have you stopped to read the text that appears in classes 1 and 2?
Just hover over those two classes.

 

Good morning!

Don't worry, there are some minor errors.
But it must be my OFFICE, since it is not activated it may be causing minor problems, which I can fix manually.

Thank you

 

Spoiler: Where is the scroll bar?

Spoiler: You must unlock the file, right click and Properties

 

My errors!

Cortes permitidos = 3 não aceita, somente 2
F. Ayudas Realista = quero OFF, mas fica apenas ON
Classe del rival, não funciona corretamente:
( misma classe = entra apenas 1 modelo de carro e não a classe GT3 com todos os carros, por exemplo e se eu quiser todos carros GT3 tenho que informar "Multiclase" e GT3 nas 4 caixas




Estou com este erro.

But if you don't have these errors, the problem is my office.

 

Safety Car turned off, it appeared on the server

 

Something very strange happened, I had put Watings only GT3, and now it appears together with F3

 

Hi....
I still don't see the scroll bar in your screenshot.
That means that file or the macros aren't unlocked.
It won't work properly.
_____________________________________________________

 

"DS-AMS2_v506,9.xlsm" and the file is unlocked

 

hi, I required the access to the file on google drive but never received a reply or authorization.. could you please check?

 

Spoiler: Branzo, post: 327664

Hi. I'm sure I missed it. I don't see any email address, so you'll have to request it again and you'll definitely have access. Best regards.