LE03 / LE04 calculator – number of habitat types rows

Unfortunately, due to the complexity of the calculator tool it takes a significant amount of time to add additional rows, but in cases where there are more than 20 habitat types, the following method can be followed to calculate the overall ecological value and number of credits achieved:

  1. Open two LE03&LE04 calculator tools (LE03&LE04 Ecology Calculator 2)
  2. Enter 20 habitat types into the first tool
  3. Take the total Ecological Value for pre-development (cell H51) from the first tool and enter this into the first habitat row of the second tool (cell F8 in NC 2011 v1.10 and cell F9 in NC 2014 v.2.0)
  4. Take the total site area for pre-development (cell H49) from the first tool and enter this into the first habitat row of the second calculator (cell H8 in NC 2011 and H9 in NC 2014)
  5. Take the total Ecological Value for post-development (cell K51) from the first tool and enter this into the second habitat row of the second calculator (cell F10 in NC 2011 and cell F11 in NC 2014)
  6. Take the total site area for post-development (cell K49) from the first tool and enter this into the second habitat row of the second calculator (cell K10 in NC 2011 and cell K11 in NC 2014)
  7. This will combine 20 species types into 2 rows, leaving space for a further 18 habitat types
  8. Send in both tools as evidence at QA, including this compliance note.

For a project which needs even more rows, this process can be repeated using a third tool if required. In this case all tools need to be send as evidence to QA, including this KBCN.