3 ms·
> As long as it's not tedious to set a few thousand that sounds great. How are you setting them? Grab and drag? I can support that. > SUM, COUNT and IF (if-
by dotancohen 5y ago
> As long as it's not tedious to set a few thousand that sounds great.
How are you setting them? Grab and drag? I can support that.
> SUM, COUNT and IF (if-then)
Perfect, thank you.
Right now I've started a Git repo with a roadmap but I've not uploaded any code yet as I'm still deciding on the architecture:
https://github.com/dotancohen/structuresheet https://github.com/dotancohen/structuresheet
- magicalhippo 5y ago> How are you setting them? I'm old school, so ctrl+c, shift+end (maybe tweak selection area with cursors if Excel is being dumb) and ctrl+v.
- dotancohen 5y agoTerrific, thanks.
- magicalhippo 5y agoWhile I'm at it... One thing I find annoying in Excel is that it's rather tedious to reference an absolute cell ($B$2) vs a relative cell (C3), especially when I need to reference a handful of each. The way I work, it would have been better to mark a cell itself as being a "constant" or "input parameter", so that when I reference the cell it is treated as an absolute reference when pasting. That is, if I reference cell B2 in a formula and paste that formula in a different cell, it is B2 itself that determines if it's a relative or absolute reference, not the way I typed it in the formula. It's not a huge deal, but it would be one of those nice things that makes life more enjoyable.
- dotancohen 5y agoWould it not be tedious to mark each cell as constant or input parameter? Perhaps it would be preferable to just ask the fine user when copying a cell with a formula?
- magicalhippo 5y agoI almost always have <5 such cells in a sheet, typically just 2-3, so I don't think it would be that tedious given you only have to set that once. In comparison, I often have formulas with over 20 cell references and/or multiple formulas referencing the "constants", so getting asked for each would indeed be tedious.