This site under reconstruction.
“I wish you could reverse engineer the answer.” When we do the forecasting, pricing or some kind of modeling, we move forward in spreadsheets by inputting the values for the variables and letting the formulas calculate the end results such as net income or gross margin. However, sometimes, we know what kind of end results…
It’s been a while since I’ve done one of these types of problems, but I wanted to look at some data that resided in text files (.txt) and I had never tried to pull in data from text files into Excel. The itch I wanted to scratch was Zoom call attendance: was attendance declining and…
The topic is going to be a little bit denser today as I will try to discuss creating measures for when you have several layers of roll ups. By roll ups, I mean you have granular detail data such as counties rolling up to state level details and then rolling up to USA level kind…
Our vendor did it again: the data format changed – basically, the columns shifted – so that my formulas did not pull in the right numbers or any numbers at all. None of the 60+ files worked. Fortunately I quickly spotted the issue (and some of the managers are getting comfortable with numbers and excel…
Revising a code is way different from creating a code from scratch. My company switched over to a new payroll vendor and the new vendor’s data file is almost – but not quite – the same as the old data layout, but it is that tiny little variance that broke the code. Most of the…
BP put this puzzle out in LinkedIn. I am not sure why and quite a few people did not give the same answer as in the Answer tab. Hmmm, either I’m wrong and I don’t think so or that 36% percent figure is about right.Click on the tabs to get at the puzzle and then…