I have devised a Dashboard to check that a Crane is SAFE to operate:
Here are the criteria:
CELL L21 & N21 are Windspeeds CONSTANT & GUSTING
CONSTANT CRITERIA (CELL L21)
GREEN 25 or less
GUSTING CRITERIA (CELL N21)
GREEN 44 or less
RED GREATER THAN 56
I think its ok here but I may have missed something. Would appreciate a SANITY check please.
Also the crane arrives on site on a given date. From that date onwards there is to be a 12 week interval for a CRANE SAFETY CHECK
From the date of arrival also there is to be a SIX MONTHLY Maintenance overhaul of crane.
Can you please check spreadsheet for any obvious errors.
Is there any way we can devise an arrival date and set that as a president for 12 weekly checks. Say arrives today 12th May, next inspection due 4th August, next 27th October and so on. Add this to the dashboard in row fashion in REctangle 3 and have it initialled by OPERATOR, to clear its use after maintenance.
ExExversionCRANE.xls ExExversionCRANE.xls ExExversionCRANE.xls ExExversionCRANE.xls