WindVista Shear Checker

Web-app tables vs the Wind Pioneers Shear macro — fills a copy of the macro per case, calculates it, adds a green / red comparison sheet.

1Add your files

Drop or click. The text file is optional — if a case has only a zip, the time series inside the zip is used as the macro input.
Macro template (.xlsm)
one file
Web-app zip files
one per case
Text files (optional)
Windographer .txt
Or: a whole folder
sub folders, each with one case zip (+ its .txt)
Or: a folder on the server / network share
results are saved back into each sub folder

2Cases found

Case (output file)Folder / zipInput for the macroWeb file saysTarget heights (tick)

Options

Target heights — tick them for each case in the table above (each height is a full recalculation of the macro — more heights = longer)
Same heights for every case (ticks them in all cases that have that height; you can still change single cases):

3Progress

CaseProgressStatus

4Results & download

Each workbook is the macro template, filled and calculated, with a Comparison sheet added at the end. Files are kept on the machine running the tool for 7 days (), then deleted automatically.
Download all workbooks (.zip)