3 ms·

I'm an engineer/scientist and I find it super hard to follow other people's excel files. All you see if some data/numbers instead of the actual code/calculation

by s0rce 2y ago

I'm an engineer/scientist and I find it super hard to follow other people's excel files. All you see if some data/numbers instead of the actual code/calculations.

ekianjo 2y ago
Excel sheets are built visually so there is absolutely no sane way to parse them. Just the same thing as trying to restructure a pdf at the end of the day.
- wkat4242 2y ago
  Yeah this is what Microsoft is trying to do with copilot. But they couldn't figure it out either so it's limited to data formatted as table.
  - freeAgent 2y ago
    They’ve removed that limitation now, I think. That said, I still haven’t found any use-case for Copilot within an Excel workbook that works (probably because I’ve only ever asked it to do very difficult things since I don’t need it for easy stuff). So there’s that.
analog31 2y ago
I wrote a VB macro that displays the formula for a cell, next to the cell. Granted you have to add a cell (typically a column) to make space for it. It returns either a formula, or "constant" if the cell doesn't contain a formula. I could make it more sophisticated, but just those two things are enough to make spreadsheets a lot easier for me to follow. Following spreadsheets is like trying to find something in my garage if all of the boxes have lids. But if the boxes are all open, I can find stuff in a jiffy, even if the boxes are disorganized.
- accrual 2y ago
  The closed toolbox is a nice analogy for opening a sheet full of numbers. A foreign Excel sheet can take a lot of clicking around to get an idea of how it works sometimes.
- keithalewis 2y ago
  Control-backtick toggles formulas. No need for VB(A).
  - analog31 2y ago
    Ah, I didn't know that. So I tried it. It does display formulas, but by hiding the values. What my macro does is allow the formula to be displayed permanently in its own column. Granted I'm one user out of many, and have switched to programming for any kind of quantitative work. but I'm still quite supportive of Excel.
    - keithalewis 2y ago
      Do you realize it toggles data and formula display? That ought to be fine for anyone with more short term memory than a gnat.

by s0rce 2y ago

I'm an engineer/scientist and I find it super hard to follow other people's excel files. All you see if some data/numbers instead of the actual code/calculations.

ekianjo 2y ago

Excel sheets are built visually so there is absolutely no sane way to parse them. Just the same thing as trying to restructure a pdf at the end of the day.

wkat4242 2y ago
Yeah this is what Microsoft is trying to do with copilot. But they couldn't figure it out either so it's limited to data formatted as table.
- freeAgent 2y ago
  They’ve removed that limitation now, I think. That said, I still haven’t found any use-case for Copilot within an Excel workbook that works (probably because I’ve only ever asked it to do very difficult things since I don’t need it for easy stuff). So there’s that.

analog31 2y ago

I wrote a VB macro that displays the formula for a cell, next to the cell. Granted you have to add a cell (typically a column) to make space for it. It returns either a formula, or "constant" if the cell doesn't contain a formula. I could make it more sophisticated, but just those two things are enough to make spreadsheets a lot easier for me to follow. Following spreadsheets is like trying to find something in my garage if all of the boxes have lids. But if the boxes are all open, I can find stuff in a jiffy, even if the boxes are disorganized.

accrual 2y ago
The closed toolbox is a nice analogy for opening a sheet full of numbers. A foreign Excel sheet can take a lot of clicking around to get an idea of how it works sometimes.
keithalewis 2y ago
Control-backtick toggles formulas. No need for VB(A).
- analog31 2y ago
  Ah, I didn't know that. So I tried it. It does display formulas, but by hiding the values. What my macro does is allow the formula to be displayed permanently in its own column. Granted I'm one user out of many, and have switched to programming for any kind of quantitative work. but I'm still quite supportive of Excel.
  - keithalewis 2y ago
    Do you realize it toggles data and formula display? That ought to be fine for anyone with more short term memory than a gnat.