A bit off topic, but what I've wanted forever and never found is a spreadsheet that deals in units natively. So if one cell is in Newtons and I divide it by a cell that is in m/s^2 I want the resulting cell to be in grams. Units should propagate through the sheet automatically. Unit prefixes can either be automatic (km, m, mm, um, etc) or fixed as you would with a format setting.
Google calculator is the closest thing I've seen to this, but it isnt in spreadsheet form.
Anyone know of a system that provides this functionality?
Interestingly, it seems there's a Sheets add-on which provides at least some of what you want— unfortunately not with cell metadata, but rather using pairs of adjacent cells for the quantity and units:
I remember Mathematica being a bit weak with units actually. Natively there's no support, you have to rely on add-on packages and I didn't have much success with the popular one. But my experience is from version 8 (a while ago) so it may have improved since.
spreadsheets barely have distinction between strings and numbers. Units would be another level! I hope that at some point something like a strongly typed jupyter notebook tailored specifically for table inputs would arise and replace some current usages of spreadsheets in office/consumer space.
GNU units does this, but is definitely not a spreadsheet or anything like a spreadsheet. It might be possible for a spreadsheet to arrange to call it as a back-end, though.
You have: 100 N / (50 m/s^2)
You want:
Definition: 2 kg
1-2-3 would allow you to plot a function on your graphs. Something that I haven't seen since. The solution now is to build a range and values, but that just adds one extra column of data to massage versus having a reference line covering the domain and range of that particular graph.
Interesting! I do this on paper a lot because that's how I learned in college.
Thinking of it. It's composing converters. That should be fairly easy to automate!
Not a spreadsheet, no, (it is more of a freeform worksheet) but SMath Studio is a breeze to work on with units.
It has complete support for units of measurement and comes with most built-in. It can also decompose derived units into simpler forms if it finds a match.
In python there’s the pint module, which works with pandas dataframes, which can read/write excel sheets. So yeah, maybe. Why do anything in excel, except for data entry?
Google calculator is the closest thing I've seen to this, but it isnt in spreadsheet form.
Anyone know of a system that provides this functionality?