Re: Excel ConVersion
I hope this helps, I’ll post some examples when I get to post an updated Version of the sci-fi crossover mod.
Converting data files into Excel files is a little complicated.
Here’s how I do it:
1- Open the data file in word and erase heading and ending.
2- replace all black lines ^p^p with a marking symbol I use html symbol <br>
3- replace all enters ^p and all := with tabs ^t
4- replace all marking symbols <br> with enters ^p
5- copy and paste into excel
6- edit to remove all redundant columns, add top cells and align columns of items with different number of req techs, number of abilities etc.
To convert the Excel spreadsheet into se4-like text just use Word’s mailmerge function.
|