How Many Formulas In Your File?
The other day I was working on a financial model. During a break I saw on Twitter that @JesseH77 posted the following: My budget files have 180,850 and 160,191 formulas and 11 lines of code to count the formulas. This
The other day I was working on a financial model. During a break I saw on Twitter that @JesseH77 posted the following: My budget files have 180,850 and 160,191 formulas and 11 lines of code to count the formulas. This
Since I know I have a few charting guys that follow this, I figured that I'd ask this question here. Hopefully the response will help someone! I'm creating a food & beverage function evaluation form, and threw a chart on
I came across this a while ago in a weather app on my iPhone, and thought it was interesting. Then there was a conversation on Twitter in which I brought it up as well. I'm not a huge fan of
Clark asks: I am trying to copy two different operations into a "This workbook". One is the "disable cut copy paste" function that I found and the other is the "force user to enable macros" so that the disable cut
Last week I was working through creating some more DAX measures. And while I was successful, I still don't feel that I've really truly wrapped my head around how they work. (I notice that Dick Moffat feels similarly, too.) The
Over the last couple of days I've been trying to build some stuff with PowerPivot and I've come up with some other things that I would find pretty helpful. Here's one of them. One of the big challenges I found
After all my evangelizing (or complaining if you like), I think it's important to acknowledge when someone does/announces something that addresses my concerns. Post titles are the first things that come up in search engines. So if someone is searching
Yesterday Rob Collie made a post on his blog about sizing considerations for PowerPivot implementations on Sharepoint. The main thrust of the post was directed at end users and making sure that their server farms have adequate resources to efficiently
I am an information worker. A big part of my job is to provide our staff and team members with useful information so that they can perform better in their jobs roles. In addition to this, as the Controller of
I was playing a version of 21 with my daughter this weekend, and mentioned Blackjack to her. After a few questions, I thought it might be entertaining to build a version of Blackjack for her to play so I did.
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
