This page contains a Flash digital edition of a book.
Benefi t:Cost Ratio Calculator


CLICK HERE TO DOWNLOAD THE BCR CALCULATOR


User Guide


A screen grab of the blank spreadsheet is provided above. This shows where the user will need to make entries (pink boxes) for:


• name of scheme, • the number of vehicles, and • cost (in this case the funding from Carplus).


The number of predicted members uses the national average for members per car (40) and for mileage per vehicle (8,176). These are default values and are shown in spreadsheet. If scheme specifi c forecasts are available, these can be entered instead. The factor entry in column J allows for greater than average reductions in carbon where electric vehicles are part of the specifi cation (rising to 1.75 or a scheme specifi c factor if known).


Along the bottom of the screen shot the spreadsheet tabs (worksheets) can be seen. These make explicit the assumptions behind the automatic calculations and reference them.

Page 1  |  Page 2  |  Page 3  |  Page 4  |  Page 5  |  Page 6  |  Page 7  |  Page 8  |  Page 9  |  Page 10  |  Page 11  |  Page 12  |  Page 13  |  Page 14  |  Page 15  |  Page 16  |  Page 17  |  Page 18  |  Page 19  |  Page 20  |  Page 21  |  Page 22