Quote:
Originally Posted by pig4bill
Today we learn that Diesel is an Excel expert. Instead of just embedding the number 1000 in a formula, he creates a separate column and puts 1000 in every row, then includes that cell in his formula.
didn't watch the video but it's a good habit to build things flexibly where you can modify a cell rather than rewriting the code
having said that,from the sound of it, it doesn't seem like he's doing it in a manner that's optimal, especially since if it's always 1k then he just have the formula direct to a single cell etc so i'm sure he's doing it in a wildly inefficient manner but i'm just saying i often take seemingly unnecessary steps now when building something new strictly because i know later on i'm going to be tweaking it and doing so is much easier when things are all comparmentalized