The Pipe Sizing Spreadsheet was developed by Peter Wenning to be used in conjunction, and based on the book by Barrie Smith “Selection and sizing of copper tubes for water piping systems”.
There is both the Excel Spreadsheet and a Pipe Sizing Guide at the links below. More information on the use of the spreadsheet and worked examples are in Appendix B of the Hydraulic Service Design Guide on page 192.
Pipe-sizing-tabulation-sheet and Pipe-sizing-guide
The book by Barrie Smith “Selection and sizing of copper tubes for water piping systems” is sold by The Institute of Plumbing Australia on their website at https://plumbing.org.au/shop/