Period Comparison Spreadsheet
The Period Comparison template allows you to compare budgets, actuals, and budget-net-actuals over two user-defined periods with sorting and sparkline functionality.
About the Period Comparison Spreadsheet
The Period Comparison template allows you to compare budgets, actuals, and budget-net-actuals over two user-defined periods with sorting and sparkline functionality.
Hey @susandennis!
This is a cool idea. I’ve wanted something similar too. I gave it a try this afternoon.
Just
copy theinstall the Period Comparison template using the Tiller Community Solutions add-on.Period Comparison
sheet from this spreadsheet into your spreadsheetI haven’t done a ton of testing and the features are pretty sparing. Let me know what you think.
Cheers,
Randy
Randy, This is very cool. It’s pretty much exactly what I wanted! I deleted the budget and available columns because all I really wanted was to see the actuals and this makes that spot on easy to see them perfectly clearly. Thank you!!
Glad to hear it is helpful, @susandennis.
Just made an improvement where the Budget value will prorate partial months.
The equation in
N3:N
is… unpleasant but serviceable.(Since you deleted these columns, this won’t help you, @susandennis… but I did add some period dropdown selectors that you might appreciate.)
Ok those date drop downs are sexy!! Wonderful choices. Plus, it lets me hide the two columns I don’t need instead of having to delete them.
This is just EXCELLENT. Thank you!