Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

Is there a spreadsheet that supports units in its cells and GNU Units in formulas? Seems like that would be an amazing open source tool.


to my surprise, it turns out that org-mode's spreadsheet does support units, because it uses emacs calc-eval. But calc seems to have its own dimensional analysis engine rather than using gnu units. i was hoping to get a temperature in this last column, for example:

    | 3 mm | 4 kg | 0.44444444 kg / mm^2 | 44.444444 kg m^2 / (s^2 mm^2) | (44.444444 kg m^2 / (s^2 mm^2 stefanboltzmann))^0.25 |
    | 2 mm | 1 kg | kg / (4 mm^2)        | 25 kg m^2 / (s^2 mm^2)        | (25 kg m^2 / (s^2 mm^2 stefanboltzmann))^0.25        |
    #+TBLFM: $3=$2/$1/$1::$4=$3*(10m/s)**2::$5=($4/ stefanboltzmann)**(1/4)
(edited, previous incorrect version follows)

    | 3 mm | 4 kg | 0.44444444 kg / mm^2 | 300 mm m^2 / s^2 | (300 mm m^2 / (s^2 stefanboltzmann))^0.25 |
    | 2 mm | 1 kg | kg / (4 mm^2)        | 200 mm m^2 / s^2 | (200 mm m^2 / (s^2 stefanboltzmann))^0.25 |
    #+TBLFM: $3=$2/$1/$1::$4=$1*(10m/s)**2::$5=($4/ stefanboltzmann)**(1/4)
similarly here i was hoping to get the time until the laptop charges and i guess i sort of did but not really

    | 22.8 Wh | 16.8 Wh | 6. Wh | 7.4W | 0.81081081 Wh / W |
    #+TBLFM: $3=$1-$2::$5=$3/$4


Not a full spreadsheet, but I have a passion project that can support units:

https://instacalc.com/56734

I wanted a quick, shareable "back of the envelope" tool.




Consider applying for YC's Winter 2026 batch! Applications are open till Nov 10

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: