Back to quotes list Update
#12282022-06-28 15:35:51
< thraust> guys I have a problem
< thraust> my boss needed help with some excel stuff, getting a chart to output a percent based on some values
< thraust> so I figured out a formula for it
< thraust> I kinda liked it...
< mech> You monster
< thraust> what's wrong with me?
< mech> As long as you don’t use it for major projects that should have a legit DB I think you are fine
< mech> It has its place and can do some really cool stuff.
< mech> I made one the other day to track the computers I image at work
< thraust> is it terminal?
< thraust> she had a bunch of small charts for different years of when cases started and how many we still have open
< thraust> so I got a formula to check if the cells were blank in the still open column, if they were then they used the values from the other column
< thraust> then do math on the totals to get the percent of closed cases
< mech> The precise use for excel.
< thraust> neat
< thraust> time to build a VB backend to pull data from salesforce
* thraust snorts a line of crushed word documents
copyright LOLOLOL valve corporation