search

eddietheengineer / documentation

109 stars 14 forks source link

Google Sheets version of motor torque sim #9

Open kozross opened 1 year ago

kozross commented 1 year ago

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 commented 1 year ago

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 commented 1 year ago

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 commented 1 year ago

Fixed version for comparison: fixed.ods

e-dreyer commented 1 year ago

@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 commented 1 year ago

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

dwaite commented 6 months ago

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