Our approach to calculating the carbon saving of our tool library is describe in this explainer

Here is a link to a spreadsheet of data using in the video, so you can see the formulas

Video 1 of 2:

https://www.loom.com/share/4c56628a605d40ca90eb3ababecc8438

Video 2 of 2:

https://www.loom.com/share/ffe72c4b6a89407fb74e08dd87eca038

Note: Video may mention using “LOOKUP” function. Please use “VLOOKUP” instead, as detailed below.

To create your own

Create a spreadsheet of relevant member loans

Open a new google sheet/excel file

Log into myturn with admin account

Go to Reports > Loan Reports

Choose a time period. Select the date you want to start and end on

Export the csv file and save it on your computer. Open it in google sheets/excel

Delete all personal information! You don't need name, address, phone etc.

Delete all the renewals - members don't save carbon by borrowing the same item twice. Sort the sheet by the Renewal column and delete those rows

Members often borrow the same tool again later, which doesn't show as a renewal. List all the unique borrows by using the formula =UNIQUE(range). On a new column write =UNIQUE( and then highlight the memberID, toolID and tool description columns.

This generates a list of borrows that don't have any repeats.

Create an inventory of tool, weight and carbon emission factor

This is time-consuming, but you only need to do this once.