me: my budget should be a spreadsheet not a ~program~ also me: writing half the logic in google sheets API calls
-
-
Prikaži ovu nit
-
like, my budget contains a bunch of things where I need tax calculations -- this was a bunch of rows that did all the logic but I don't want that cluttering up the thing, and having to copy-paste that whole section for every use, so I replaced it with javascript?
Prikaži ovu nit -
-
what is the normal means of abstraction in spreadsheets? I never really learned how to use them properly
Prikaži ovu nit -
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 -
Č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.