So I made this spreadsheet to help me with my SQL and it has sped things up significantly. It has no VBA or anything, just formulas. I'd like to post it, but I wasn't sure if that was allowed. I know a lot of forums frown on that. I also know there are a lot of tools out there, but I made this to help me avoid typos and speed up my modding. I was able to modify the cost of 80 buildings in about 20 minutes with this.
Anyway, it is pretty simple. It is made to put the code you need in the far left column. the rest is how it writes it. The blue cells are the main ones you change for that entire table and they change the sql commands throughout that spreadsheet. The yellow is the parameters for each line item. The two "Ands" are to add more criteria for your match if needed, if not leave them blank. The notes section appends at the end of the code, and you can't see it, but it does a simple check for spaces in certain parts fo the code. It doesn't display anything unless you mess it up.
Also, it is useful that if you want to leave out any code, you can just hide those rows and it won't copy when you paste it into the .sql. Between this and DB Browser for SQLite, modding has been a breeze.
Moderators if it is alright to post it let me know and I will put it up first thing tomorrow. If not, and someone wants acopy, just PM me.
Anyway, it is pretty simple. It is made to put the code you need in the far left column. the rest is how it writes it. The blue cells are the main ones you change for that entire table and they change the sql commands throughout that spreadsheet. The yellow is the parameters for each line item. The two "Ands" are to add more criteria for your match if needed, if not leave them blank. The notes section appends at the end of the code, and you can't see it, but it does a simple check for spaces in certain parts fo the code. It doesn't display anything unless you mess it up.
Also, it is useful that if you want to leave out any code, you can just hide those rows and it won't copy when you paste it into the .sql. Between this and DB Browser for SQLite, modding has been a breeze.
Moderators if it is alright to post it let me know and I will put it up first thing tomorrow. If not, and someone wants acopy, just PM me.
