Audit Tool for Campaigners (XLS)

5 posts / 0 new
Last post
Roland
Audit Tool for Campaigners (XLS)

hello guys, 
in follow-up of a post from Cycling-Embassy of Britain, I wrote a handy spreadsheet for auditing cycling routes based on the 'Welsh Active Travel Guide' where it was only available in PDF.

The first version is 1.0, newer versions will be uploaded in the comments below.

it features:
  • handy and nice printing configuration in 6 A4 pages per audit
  • custom Title field and auditor field
  • automatic date field
  • protected fields (except 'Score', 'Comments' and 'Actions') - go to 'extras' -> 'protection' to deactivate field protection (without password)
  • sensitive 'Score' fields (only '0','1','2' or 'C' are viable)
  • automatic calculation to Total Score
  • automatic detection and calculation of Critical Scores
  • correction of error in the original welsh spreadsheet (changed columns at 'deviation factor')

feel free to host it and share it.

if questions arise or you want to give feedback, do not hesitate to contact me :)

Roland R.
Radlobby Vienna (Austria)

 

Roland

Hello Friends,  thank you for your support.

The tool is now available in a new Version, additionally also in German
feel free to host it and share it.

AuditTool v1.1:  download
AuditTool v1.1-german: download

The Source Document by the Welsh Government is found here:
https://gov.wales/active-travel-design-guidance

Roland R.
Radlobby Vienna (Austria)

tarquin_foxglove
tarquin_foxglove's picture

Hi Roland,

Both of those links go to the German version.

AuditTool v1.1 - the link is "https://www.dropbox.com/s/7nkt8qritt3tn8u/Cycle_route_audit_tool_Wales_v..."

AuditTool v1.1-german the link is "https://www.dropbox.com/s/7nkt8qritt3tn8u/Cycle_route_audit_tool_Wales_v..."

Roland

thank you. just fixed the link.

tarquin_foxglove
tarquin_foxglove's picture

Thanks for sorting the link out and also for the work to create the spreadsheet in the first place.

Cheers

Log in or register to post comments