Google Sheets version of motor torque sim

[kozross]

The sheet is incredibly flaky on anything that's not Windows and Office, which not all of us can, or want to, run. In my case, I literally cannot use this resource at all. Would it be possible to have a Google Sheets version of this?

[e-dreyer]

I also experienced problems on Google Sheets and was only able to open it in Libra Calc 7.3.7.2. It mostly worked there, but I am unable to export or save it to any other format without it breaking.

It seems the macros VLOOKUP and SINGLECOILTORQUE are the problems.

[Jookia]

I spent way too much time debugging this. I don't think the macros are the issue, I think the data source in the 'UI' sheet is: A lot of the motor rows are empty or N/A. Copy pasting over them fixes the errors.

[Jookia]

Fixed version for comparison: fixed.ods

[e-dreyer]

@kozross and I were working on it together, but the files working on my side didn't work on their side.

Could you possibly share a file with us that you think it was resolved in? Because we have a wide array of testing environments already set up.

[kozross]

I can confirm @Jookia's sheet works for me without issue.

[dwaite]

I created a google sheet converting the macros to named functions, and doing a few other cleanups. Currently making sure I didn't break anything. https://docs.google.com/spreadsheets/d/1cBYOoc1_ArdqjLEfQp4BC-urwZ5MOmr4zoeLMxT_l7k/edit?usp=sharing