|

Data Tables – part 1

Here’s a really useful tool for generating various results based upon multiple inputs. It’s a quick way of seeing what happens to results when you vary the input. I usually try each input manually, but I really should set up these data tables to see the results.

I’m attaching a PowerPoint that shows in a very simple manner how to do data tables. I have posted this PowerPoint or rather PDF elsewhere so I thought I would share it here also.

The PowerPoint slide is kind of done in a story form so hopefully it is more interesting that way.

By the way, I have done some posts in the past regarding data tables. In those posts I had some files showing on the page but WordPress has changed their foundations so the little programming that showed the Excel files no longer work. Or maybe it was Microsoft that changed things – that’s another possibility. Anyway, I will need to work on fixing those files.

Here are the links to the old posts in case you’re curious:

November 26, 2017 – Now I Know Why I Don’t Use Data Tables

December 10, 2017 – More Experimentation to Make Data Tables Work

January 18, 2018 – Using Data Tables for Simulations

Yeah, those posts were quite a while ago.

Similar Posts

Automating the Budget

Automating the Budget Process

It’s budget season again and we’re back to trying to make the budget file better. Because of the nature of our business, we have sites that use different sets of GL account codes which makes creating a single budget file problematic. But my boss is a master of Excel. Most people would create three separate files but…

The Failure of Big Data

Big Data’s Election Failure

This election was a perfect example of how data could lead you astray if you are not careful. Before the results of the election came in, all of the polls predicted Clinton had around 85% chance of winning. Well, the 15% chance that he would win happened. This was a black swan event, and I…

Working on Data and Storytelling
|

Working on Data and Storytelling

When you read about data science or data analytics, you read a lot of exhortations that analysis alone is not enough: you have to be able to tell a story with the data if you want to get action or receive respect from your coworkers. That’s easier said than done. It’s one thing to tell…

The 4th Surge?
| |

The 4th Surge?

I haven’t done this is a while so let’s see where we stand with this coronavirus thing. First, it looks like continents around the world are undergoing renewed surges, from frightening so, based upon their almost vertical rise. You can see that Europe, Asia and South America appears to be undergoing an alarming rise, so…

Goal Seek
|

Goal Seek

“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…