I know spreadsheets are just programming but they feel like programming where you have to do everything with inline assembly
Prikaži ovu nit
what is the normal means of abstraction in spreadsheets? I never really learned how to use them properly
-
-
before: a whole sheet just to do my tax calculation after: 50 lines of javascript me: why did I do this again
Prikaži ovu nit -
what I actually want is the ability to treat cells as input/output to functions: what would the value of cell X be if I put these values in cells A, B, C
Prikaži ovu nit -
if you have a sheet that does your taxes, you should be able to abstract over that without writing code
Prikaži ovu nit -
but, you can't? so it's literally just writing assembly where you have to paste each routine inline instead of using registers and jumps
Prikaži ovu nit -
the other thing is that gsheets doesn't recompute cells that use a user-defined function that loads data from another part *of the same spreadsheet*
Prikaži ovu nit -
so I have an income_tax() function that just takes a number as input, not all the bands and rates info b/c that would be unusable; the function looks those up from another sheet
Prikaži ovu nit -
if you do all this work *inside the spreadsheet* then any change to the bands/rates recomputes everything, but not if those are implicit input to a custom function
Prikaži ovu nit
Kraj razgovora
Novi razgovor -
-
-
My process in the past (with excel) would be to have a couple of hidden sheets with the intermediate steps in, and reference values, so you could have one visible sheet with inputs, one with everything formatted correctly for the output
-
sure but what happens when you want to repeat the calculation with different inputs
Kraj razgovora
Novi razgovor -
Čini se da učitavanje traje već neko vrijeme.
Twitter je možda preopterećen ili ima kratkotrajnih poteškoća u radu. Pokušajte ponovno ili potražite dodatne informacije u odjeljku Status Twittera.