ChatGPT is either mad, or drunk. I asked it for a basic benchmark for consolidating 382 Budgets at 4 group and sub-group levels. It said to expect an average duration of 30-40 minutes. I don’t believe it. I think it will be much quicker in the hands of an expert.
So, here is a benchmarking test.
In this zip file (Budget Templates 383.zip) there are 382 Budgets with exactly the same layout. The numbers are, of course, different. On the top right is the City, Country, Region, of each Budget. There are 90 Cities, 50 Countries, 4 Regions, and 1 All. The requirement is a consolidation in each of these sub-groups – 145 in total.
Please create this on your machine with Power Query.
Time the refresh time.
Note it in the comments in the LinkedIn post.
Outline your steps if possible.
NOTE: there are only 382 Budgets. Number 200 went AWOL.
Add comment