Safety Worksheet 1-R – interactive Excel Worksheet
The QuakeStar Residential Worksheets are used in a similar way to the corresponding Commercial Worksheets.
They are designed to apply to small residential buildings such as houses and low-rise apartment blocks.
Values entered on this Safety Worksheet are the %NBS values for each item adjusted for building importance if the building is used for IL3 or IL4 purposes.
Values for each direction are required. The spreadsheet examines the values entered and determines the rating based on the lowest value in each category and then overall.
Damage and Repair Time Worksheet 2A-R – interactive Excel Worksheet
Vulnerability Method
Assessors enter values in the User Input columns for Damage and Repair Time. The Worksheet assigns star ratings based on the figures entered.
Damage Worksheet
This is one of two methods, the Vulnerability Method and the Damage Ratio Method (see next slide). In this Vulnerability Method the engineer is required only to rate each element as High, Moderate or Low vulnerability to the effects of 500-year shaking on the building. Pre-assigned values are used to compute the estimate damage. Users may alter the pre-assigned values if they wish.
The Worksheet computes an estimate of overall damage based on entered values and assigns the Damage Rating accordingly.
Repair Time Worksheet
Engineers are required to assess the time from start of design work through to completion of the stated item. They then enter a code (1-5 in red) to match the assessed time – which then appears in the Repair Time column. The Worksheet then looks for the longest time and assigns the star rating based on that.
The effect of External Services supplying the building is included and the ratings made with and without considering these.
Damage and Repair Time Worksheet 2B-R – interactive Excel Worksheet
Damage Ratio Method
Assessors enter values in the User Input columns for Damage and Repair Time. The Worksheet assigns star ratings based on the figures entered.
Damage Worksheet
This is one of two methods, the Vulnerability Method and the Damage Ratio Method (see next slide). In this Damage Ratio Method the engineer enters damage ratio assessments for each item based on the effects of 500-year shaking on the building.
The Worksheet computes an estimate of overall damage based on entered values and assigns the Damage Rating accordingly.
Repair Time Worksheet
Engineers are required to assess the time from start of design work through to completion of the stated item. They then enter a code (1-5 in red) to match the assessed time – which then appears in the Repair Time column. The Worksheet then looks for the longest time and assigns the star rating based on that.
The effect of External Services supplying the building is included and the ratings made with and without considering these.
External Factor Worksheet 3R – interactive Excel spreadsheet
Factors beyond the subject site can influence the earthquake performance of a building. For example, a vulnerable building next door may collapse on to the subject building. It is difficult and not practicable to assess the likely effects of the External Factors on the rating of the subject building. The External Factor Worksheet allows engineers to record the existence or not of the listed external factors and to make notes for information of interested parties.
However the External Factor sheet asks engineers to broadly assess the reduction in rating, for each of Safety, Damage and Repair Time, that would result from the worst External Factor effect. They indicate this at the top right of the sheet.
The ratings for Safety, Damage and Repair Time remain unchanged but where there is an External Factor effect, the reduction in rating is indicated by displaying the stars as hollow rather than solid.
For example, if a reduction of two stars was identified for External Factors:
A three star rating: ★★★
Would be shown as: ★☆☆