Formula Question Creator Tool

[StewartPrince]

I have written a tool to create Canvas formula question equations based on Google Sheets.  I found formula questions almost impossible to use except for simple equations, but I teach Mechanical Engineering and needed something that reflected problem solving using Excel, or Google Sheets.

After creating a set of inputs and equations in Google Sheets, the tool uses precedence to produce a single equation that can be copied into a formula question.

I tested it all semester and (now) it works fairly well, I am looking for others interested in formula questions to help test it.  My goal is to make it available to the Canvas community via Anvil.

Thanks!

[Greg_CPP]

I'm really interested in testing it myself. If you need beta testers I'm game

[StewartPrince]

Google sheets changed their api, I had to re-write my solution, now it is embedded in an Excel spreadsheet, I can send you a copy of the file if you are still interested.

[pdaves]

I'd like to see it. Would  you send it to me? pdaves@utk.edu thanks! Phillip Daves

[StewartPrince]

Sure, attached is the .xls version

[pdaves]

Thank you so much! That is such a nice community service!

[reynlds]

@stewm I'd love to see this also. Thanks!

[StewartPrince]

See attached

[StewartPrince]

I tested it using the most common functions, but others can easily be added, the macro isn't protected just alter as needed.  Designed for formula style Canvas questions.