Tools & Plugins
[OT] Setvar "editor" sheet in MS Excel
A simple Excel setvar "editor" with archiving function.
197 Downloads
1 Versionen
<p><span style="font-size: 12pt;">Good morning,</span></p><p><span style="font-size: 12pt;"><br></span></p><p><span style="font-size: 12pt;">Today I have something interesting for you. I was often bothered by entering setvars manually into Notepad (for large projects, one or two paintings can be entered manually, but not e.g. 30 or so as I did in one of the last packages for Staedtedreieck). I decided to make a simple sheet that makes it easier to work on a larger number of models, and it's even worse when there are a lot of setvars. The Kajot's DLC has 33 vehicles and, note, 73 setvars <img src="https://reboot.omsi-webdisk.de/net/images/smilies/smiley110.png" class="smiley" alt="xD" height="23" srcset="https://reboot.omsi-webdisk.de/net/images/smilies/smiley110@2x.png 2x"> This cannot be done in notepad, unless it is done once. in addition, frequent editing of setvars causes us to accidentally remove a bracket or a letter from the setvar and then it starts to get annoying <img src="https://reboot.omsi-webdisk.de/net/images/smilies/smiley110.png" class="smiley" alt="xD" height="23" srcset="https://reboot.omsi-webdisk.de/net/images/smilies/smiley110@2x.png 2x"></span></p><p><br></p><p><span style="font-size: 12pt;">There are a total of 3 sections in the sheet:</span></p><ul><li>section devoted to cataloging models and carriers. In the basic version, there are 12 slots for carriers and 33 (as in Citaro) for vehicles. This can be modified as you wish</li><li>section dedicated to hated setvars. here we enter appropriate values for specific setvars. we can also enter our own setvars if we are working on another modification/DLC</li><li>and the last, most important section, a ready list with already setvars. we just select the entire column and copy to specific .cti</li></ul>
<p><span style="font-size: 12pt;"><br></span></p><p class="text-center"><span style="font-size: 12pt;">I hope that my private help will be useful to someone. <img src="https://reboot.omsi-webdisk.de/net/images/smilies/smiley108.png" alt=":hugging:" class="smiley" srcset="https://reboot.omsi-webdisk.de/net/images/smilies/smiley108@2x.png 2x" height="23"></span></p><p><span style="font-size: 12pt;"><br></span></p><p><span style="font-size: 12pt;">Finally, the license: Of course, I allow you to modify it for your own needs, but I do not allow you to distribute copies of this workbook. If you want to recommend my work to someone, I suggest linking to this source <img src="https://reboot.omsi-webdisk.de/net/images/smilies/smiley3.png" class="smiley" alt=";)" height="23" srcset="https://reboot.omsi-webdisk.de/net/images/smilies/smiley3@2x.png 2x"></span></p><p><br></p><p><br></p><p><br></p><p><woltlab-metacode data-name="attach" data-attributes="WyIyMTc4MTYiLCJub25lIiwiZmFsc2UiXQ=="></woltlab-metacode></p><p><br></p><p><woltlab-metacode data-name="attach" data-attributes="WyIyMTc4MTciLCJub25lIiwiZmFsc2UiXQ=="></woltlab-metacode></p><p><br></p><woltlab-spoiler><p class="text-center"><span style="font-size: 12pt;">And finally, an example of what it might look like (here on the previous version)</span></p><p class="text-center"><br></p><p class="text-center"><woltlab-metacode data-name="attach" data-attributes="WyIyMTc4MTkiLCJub25lIiwiZmFsc2UiXQ=="></woltlab-metacode></p><p><br></p></woltlab-spoiler>
<p><br></p><p><br></p><p class="text-center"><span style="font-size: 12pt;">Regards and nice editing <img src="https://reboot.omsi-webdisk.de/net/images/smilies/smiley3.png" class="smiley" alt=";)" height="23" srcset="https://reboot.omsi-webdisk.de/net/images/smilies/smiley3@2x.png 2x"><br></span></p><p class="text-center"><span style="font-size: 12pt;"></span></p>
<p><span style="font-size: 12pt;"><br></span></p><p class="text-center"><span style="font-size: 12pt;">I hope that my private help will be useful to someone. <img src="https://reboot.omsi-webdisk.de/net/images/smilies/smiley108.png" alt=":hugging:" class="smiley" srcset="https://reboot.omsi-webdisk.de/net/images/smilies/smiley108@2x.png 2x" height="23"></span></p><p><span style="font-size: 12pt;"><br></span></p><p><span style="font-size: 12pt;">Finally, the license: Of course, I allow you to modify it for your own needs, but I do not allow you to distribute copies of this workbook. If you want to recommend my work to someone, I suggest linking to this source <img src="https://reboot.omsi-webdisk.de/net/images/smilies/smiley3.png" class="smiley" alt=";)" height="23" srcset="https://reboot.omsi-webdisk.de/net/images/smilies/smiley3@2x.png 2x"></span></p><p><br></p><p><br></p><p><br></p><p><woltlab-metacode data-name="attach" data-attributes="WyIyMTc4MTYiLCJub25lIiwiZmFsc2UiXQ=="></woltlab-metacode></p><p><br></p><p><woltlab-metacode data-name="attach" data-attributes="WyIyMTc4MTciLCJub25lIiwiZmFsc2UiXQ=="></woltlab-metacode></p><p><br></p><woltlab-spoiler><p class="text-center"><span style="font-size: 12pt;">And finally, an example of what it might look like (here on the previous version)</span></p><p class="text-center"><br></p><p class="text-center"><woltlab-metacode data-name="attach" data-attributes="WyIyMTc4MTkiLCJub25lIiwiZmFsc2UiXQ=="></woltlab-metacode></p><p><br></p></woltlab-spoiler>
<p><br></p><p><br></p><p class="text-center"><span style="font-size: 12pt;">Regards and nice editing <img src="https://reboot.omsi-webdisk.de/net/images/smilies/smiley3.png" class="smiley" alt=";)" height="23" srcset="https://reboot.omsi-webdisk.de/net/images/smilies/smiley3@2x.png 2x"><br></span></p><p class="text-center"><span style="font-size: 12pt;"></span></p>