Using spreadsheets (Excel) for simple computations and approximations

RE: Using spreadsheets (Excel) for simple computations and approximations

mcb1 — Thu, 14 Sep 2017 06:52:39 GMT

Nice work.

Us humans seem happier with graphical representation of things.

I used to do Pivot Tables of data we received for alarms from sites.

The results showed the ones that needed further investigation or explanation.

VBA (Visual Basic for Applications) is able to be used to manipulate or even provide the data, but you can use Visual Basic with all the other aspects (forms, etc) to interact with it as well.

Mark

RE: Using spreadsheets (Excel) for simple computations and approximations

jw0752 — Sat, 26 Aug 2017 05:58:03 GMT

Hi David,

Thank you for a relevant description of a powerful tool that is available to us. I need to take the time to explore and practice with Xcel. Thanks for the inspiration.

John

RE: Using spreadsheets (Excel) for simple computations and approximations

jack.chaney56 — Fri, 25 Aug 2017 16:38:35 GMT

I like the detail. I used a spreadsheet for testing some spark map calculations when I was doing engine management stuff.

Jack

RE: Using spreadsheets (Excel) for simple computations and approximations

DAB — Sat, 19 Aug 2017 16:17:19 GMT

Nice post,

Somewhere in my stash is a little book that provides tips for doing science and engineering using Excel.

I may have to dig it out and see what things I might be able to upgrade and use.

Thanks

DAB