Unlocking the secrets of your P&L data by customising Results Summary

An email from a purchaser of Results Summary spreadshee asked to be able to analyse their P&L by course in the "Horse racing - type & distance" tab in a similar way that it works for race type and distance. Rather than just adding another table to do this I thought it would be more powerful to show all purchasers how to customise and manipulate their spreadsheet in even more ways.

Note: Horse racing P&L shown by racecourse is now built-in to v3 of the spreadsheet, please see this post.  

The method shown below can still be used if you have other requirements for analysing your data.

This means you can set up your P&L results to display exactly how you want, and as before, you keep your P&L results private - there is NO uploading your results to someone else's website.

I hope that this is quite a revelation for those who want to look at their results from new angles and perhaps inspire new strategies.

Please make a backup of your spreadsheet before you try any of the techniques in the video! You've been warned! For instance, if the "Market type" field is moved up from the bottom of the hierachy you will get an error message (Run-time '1004') when pressing the "Collapse all drill downs" button. So it's best if you copy over a fresh version of the table first (as shown near the end of video "part 2").

Whilst I hope you enjoy this please note that I can't be giving free tech support for Excel related questions. Please leave a comment if you have found this useful.

Video part 1 of 2 (older v2 spreadsheet)


Video part 2 of 2 (older v2 spreadsheet)