hopefully this is a quick and easy question
I know how and am comfortable with export\import and using SQL Lite Studio (still prefer Access or Excel, but I understand the reasons for the SQL lite...)
I want to make what should be a simple adjustment to all player salaries (basically a formula that sets all salaries at 10% of current value - so X*.10)
why? because players are all whiny overpaid ninnys? No - just trying to run a fictional historical side by side with the NCAA game that starts in 1980. this https://www.spotrac.com/nba/cba/ shows me the salary cap back in 1984 was 3.6M (so I am starting there as a close enough) so now I have a perfectly configured file for both NCAA and Pro - but every single pro salary is way too high and every team is at 50x over the cap. not a huge deal, but immersion is everything and I would love for this league to have a finance structure that mostly mirrors the real rise in NBA finances. So I am all clear on what I want to do.
THE QUESTION - can anyone show me an easy way to use SQL Lite Studio to apply a simple formula to those salary columns - for example in excel I would simply copy the modifier value I want (so as an example .1 for 10%) select all of the 9 contract columns and all data and then paste special - choosing multiply. just like that every contract would be at 10% of original value. takes longer to type this then it would take to do in excel. But I have been poking around SQL Lite Studio and have yet to find a solution. Hopefully someone reads this and knows a quick and easy way to accomplish this.
also bonus credit - on a different modern league I edited Warriors owner Joe Lacob to be a 5 in spending money (in game I think he was a 2, in real life he has proven he has that dial jacked up to 11!) it shows correctly in the SQL data - and other data I have edited has come into league on edit - but for some reason the owner qualities dont seem to work in import - anyone else done this with success (or even failure which means it could be a bug)
any help would be appreciated.