Technical Field Manual · 2024 Edition

Structural Silicone Glazing
Complete Technical Guide

ASTM · EN Standards · Application Methods · Testing Protocols · Labor Training · Quantity Formulas · Deglazing Log

ASTM C1184 ASTM C794 ASTM C1401 EN 13022 EN 15434 Dow Corning · GE · Elkem · Wacker
01 · Standards Reference

ASTM & EN Codes for Structural Silicone

All applicable international standards governing structural silicone glazing design, materials, testing, and installation.

Standard Body Title / Scope Application Key Requirement Reference
ASTM C1184 ASTM Specification for Structural Silicone Sealants 1-Part & 2-Part SSG Tensile strength ≥ 345 kPa; Shore A hardness 20–60 FacadeMart
ASTM C794 ASTM Adhesion-in-Peel of Elastomeric Joint Sealants Peel adhesion testing ≥ 9 N/25mm width after 7/14/21 day cure FacadeMart
ASTM C1401 ASTM Guide for Structural Sealant Glazing Design & Installation Guide SSG bite size, dead load support, edge clearance FacadeMart
ASTM C719 ASTM Adhesion & Cohesion of Elastomeric Joint Sealants Under Cyclic Movement Movement capability ±25% / ±50% No failure after 10 cycles extension/compression FacadeMart
ASTM C1087 ASTM Determining Compatibility of Liquid-Applied Sealants with Accessories Compatibility testing No discoloration, adhesion loss, or migration FacadeMart
ASTM C1382 ASTM Determining Tensile Adhesion Properties of Sealants Tensile pull-off testing Cohesive failure mode preferred; >75% cohesive FacadeMart
ASTM E330 ASTM Structural Performance of Windows under Uniform Static Air Pressure Wind load resistance testing No failure at 1.5× design pressure FacadeMart
ASTM C920 ASTM Specification for Elastomeric Joint Sealants General sealant classification Type S (single) or M (multi), Class 25/50, Grade NS/P FacadeMart
ASTM C1521 ASTM Evaluating Adhesion of Installed Weatherproofing Sealant Joints Field pull test / inspection Cohesive failure mode; field tab pull test FacadeMart
EN 13022-1 EN Glass in Building — Structural Sealant Glazing Part 1: Glass Products European SSG glass requirements Glass edge quality, tempering, heat soak test FacadeMart
EN 13022-2 EN Glass in Building — SSG Part 2: Assembly Rules European SSG assembly Bond thickness, width calculation, substrate prep FacadeMart
EN 15434 EN Glass for Architecture — Product Standard for Structural / Unframed Silicone Glazing Sealants Sealant product approval in Europe 10 year durability testing, UV aging, tensile FacadeMart
ETAG 002 EOTA European Technical Approval Guideline for Structural Sealant Glazing Kits ETA product approval Durability, UV, water immersion, thermal cycling FacadeMart
ISO 11431 ISO Adhesion / Cohesion Properties After Immersion in Water Water immersion adhesion Adhesion maintained after 7 day water soak FacadeMart
ISO 8339 ISO Determination of Tensile Properties Tensile dumbbell test Elongation at break >150%; modulus reporting FacadeMart
02 · Single Component

1-Part Silicone — Application & Curing

Moisture-cure single-component structural sealants. Simplest to apply; requires ambient humidity for crosslinking.

💧

Cure Mechanism

Moisture-cure (acetoxy or oxime). Atmospheric humidity crosslinks the polymer from outside in. Deep sections cure slowly — maximum recommended bite: 6mm depth for 1-part.

🌡️

Optimal Conditions

Temperature: 5°C – 40°C. Relative humidity: 30–75% RH. Below 5°C or <20% RH: cure rate drops dramatically. Above 75% RH: surface skin forms too fast (slump risk).

Application Method

Pneumatic or battery cartridge gun (300ml or 600ml). Backer rod in place first. Nozzle cut at 45°. Single continuous bead. Tool within 5–7 minutes of application.

Step-by-Step: 1-Part Application

1

Surface Preparation

Clean all bonding surfaces with isopropyl alcohol (IPA) ≥ 70%. Wipe in one direction; discard cloth after each pass. Allow 5 minutes flash-off before priming. Check for contamination, coatings, or dust. Mask adjacent surfaces.

2

Priming (where required)

Apply manufacturer-specified primer (e.g., Dow P5200N, GE SS4155) on porous substrates. Thin coat; allow 20–40 min open time before sealing. Never apply sealant on wet primer.

3

Backer Rod Installation

Size: 25–33% wider than joint. Push flush. Closed-cell polyethylene rod only. Prevents 3-sided adhesion and controls joint depth (depth = 50–100% of width).

4

Gun Application

Cut nozzle to match joint width. Apply in one continuous pass without stopping. Maintain constant speed. Fill joint completely — no voids, no entrapped air. Apply at 45° angle pushing bead, not pulling.

5

Tooling

Tool within 5 minutes using a dry, smooth spatula or finger (gloved). Wet tooling (soap/water) is not recommended for structural silicone — it inhibits cure at surface. Concave profile. Remove masking tape immediately.

6

Curing & Protection

Do not disturb joint for 24 hours. Full structural cure: 14–21 days. Protect from rain for first 24 hrs. Temperature log the glazed area. Inspect at 7 days for surface cure and adhesion.

1-Part Curing Timeline

Skin-over time30–90 min
Tack-free2–4 hours
Handling strength24 hours
Initial structural load7 days
Full structural cure14–21 days
Max cure depth (mm)6mm bite
Cure rate @ 23°C / 50% RH~3mm/day

Environmental Factors — 1-Part

Accelerates at>50% RH & >23°C
Slows below5°C or <30% RH
Deep section issue>6mm = risk
Acetic acid off-gas24–48 hrs
Rain exposure limit24 hours
QC field test (peel)After 7 days
Max joint width (1-part)20mm
Recommended bite width6mm depth max
03 · Two-Component

2-Part Silicone — Application & Curing

Two-component condensation or addition cure systems. Required for factory glazing (shop application), large SSG bites, and quality-controlled structural bonding.

🔬

Cure Mechanism

Addition-cure (platinum catalysed) or condensation cure. Base (Part A) + curing agent (Part B). Ratio typically 10:1 or 1:1 by volume. Full cure independent of humidity.

⚙️

Mixing Equipment

Meter-mix pump (dual cartridge or drum pump) with static mixer nozzle. Ratio-verified by butterfly test every batch / cartridge. No manual mixing allowed for structural grade.

🏭

Primary Application

Factory / shop glazing preferred. Can be field applied with approved meter-mix equipment. Deep bites (up to 12–15mm) achievable. Faster cure than 1-part for full section.

⚡ Butterfly Test — Mandatory Before Every Use

Before each cartridge or each work shift, dispense approx. 50mm of sealant from the nozzle onto a non-porous surface. Fold the bead onto itself to form a "butterfly." Observe colour consistency throughout the cross-section. If the colour is uniform (no streaks), the mix ratio is correct and application may proceed. Streaky or marbled appearance = incorrect ratio = STOP and purge nozzle / replace cartridge. Log the result.

Step-by-Step: 2-Part Application

1

Equipment Setup & Ratio Check

Install dual cartridge / drums. Prime pump — discard first 30 seconds of output (purge). Attach static mixer. Perform butterfly test on a card. Verify uniform colour before proceeding to substrate.

2

Surface Preparation (same as 1-part)

IPA wipe, flash-off, primer if required. 2-part silicones often have better adhesion to clean substrates without primer — verify with adhesion test coupons per ASTM C794.

3

Frame & Glass Setup

Position glass on setting blocks per ASTM C1401. Apply masking tape. Ensure gap dimensions (bite width × depth) match design calculations. Spacers / shims in place.

4

Inject Sealant

Fill from bottom, work upward (for horizontal joints) or from one corner. Inject from one side to push air out. Maintain continuous flow, no stop-start air pockets. Keep mixer nozzle submerged in fresh sealant during application.

5

Tool & Inspect

Tool immediately — open time is 15–30 min (check TDS). Verify full contact with both substrates. No air voids. Take a witness bead sample (butterfly snap test at 1 hr).

6

Post-Application Tests

Shore A hardness at 24 hrs (snap cure coupon). Peel test coupon at 7 days (ASTM C794 ≥ 9 N/25mm). Tensile coupon at 14 days (ASTM C1382). Log all results in panel logbook.

2-Part Curing Timeline

Work / Open time (pot life)15–45 min
Snap cure (coupon test)1–3 hours
Tack-free2–6 hours
Handling / transport24 hours
Structural load transfer7 days
Full design strength14–21 days
Max bite depth possible15mm (typ.)
Humidity independent?YES

Pre-Application Checks — 2-Part

Butterfly testEvery shift / cartridge
Snap test coupon@ 1–3 hrs, must snap clean
Shore A coupon@24 hrs, target 30–50
Peel adhesion couponASTM C794 @ 7 days
Tensile couponASTM C1382 @ 14 days
Ratio verificationWeigh A+B, check ratio
Temperature of components18°C – 35°C
Storage lifePer TDS (6–12 months)
04 · Quality Testing

QC Tests — Before, During & After

All mandatory and recommended tests for structural silicone glazing projects. Applicable to both 1-part and 2-part systems.

🦋 Butterfly Test

2-Part ONLY

The most critical pre-application quality check for 2-part silicone. Tests mix ratio visually. Must be performed before each shift and each cartridge change.

Procedure

  • Dispense 50–75mm bead onto non-porous surface (glass/metal card)
  • Fold bead over on itself — "butterfly" the sealant
  • Pull apart and examine cross-section closely
  • PASS: uniform colour throughout — proceed
  • FAIL: streaks / marbling = purge, new mixer, retest
  • Log: date, time, operator, pass/fail, cartridge lot number

⚡ Snap Test

2-Part

Verifies that 2-part sealant is curing correctly. Performed on a witness bead sample taken during application.

Procedure

  • Keep a 100mm witness bead in same environment as the glazed panel
  • After 1 hour: attempt to snap the bead by bending sharply
  • PASS: clean snap, cohesive fracture
  • At 3 hours: should be fully snappable with no stickiness
  • If still tacky at 3 hrs: temperature too low, or wrong ratio
  • Log result with time and temperature

📏 Peel Adhesion Test

Both Types · ASTM C794

Measures adhesion-in-peel of cured sealant to substrate. Most common QC test used for site verification and approval of substrate/sealant combination.

Procedure

  • Apply sealant 50mm wide on substrate coupon with bond-breaker tape at one end
  • Cure 7 days at ambient conditions (or per spec)
  • Peel at 180° at ~300mm/min
  • Measure peel force — PASS: ≥ 9 N/25mm width
  • Examine failure mode: >75% cohesive = PASS; adhesive failure = FAIL (substrate/primer problem)

🔩 Tensile Pull Test

Both Types · ASTM C1382

Measures tensile adhesion strength. Crucial for structural strength verification. Often done on mock-up panels in the factory.

Procedure

  • Prepare H-block specimens (aluminium–silicone–aluminium sandwich)
  • Bond area typically 25×25mm or 12×12mm
  • Cure 21 days, then test in tensile machine
  • Structural sealant min: 0.14 N/mm² (140 kPa)
  • Most structural grades achieve 0.35–0.70 N/mm²
  • Report: failure load, stress, failure mode

🧴 Compatibility Test

Both Types · ASTM C1087

Tests that spacers, gaskets, sealants, films, or coatings don't inhibit curing or adhesion of the structural silicone.

Procedure

  • Embed accessory (gasket/spacer/coating sample) in fresh structural silicone
  • Cure 7 days; observe for discoloration, oil migration, inhibition
  • Must confirm no bleed, no soft zone around accessory
  • Especially critical: EPDM gaskets, neoprene, PVC spacers

🔍 Field Tab Pull Test

Field QC · ASTM C1521

Non-destructive / semi-destructive field test performed directly on installed sealant beads at random sampling intervals.

Procedure

  • Cut a 45° notch at one end of joint, lift tab
  • Pull at 90° angle by hand firmly
  • PASS: sealant tears cohesively (failure in sealant body)
  • FAIL: adhesive peel at substrate (no primer, dirty substrate)
  • Frequency: random 1 in 25 panels or per project spec
  • Repair defective joints and retest after cure
Test Standard When 1-Part 2-Part Pass Criterion Failure Mode
Butterfly Test Manufacturer requirement Before each shift / cartridge Required Uniform colour, no streaks Marbled = wrong ratio
Snap Test Internal QC 1–3 hrs post-apply Optional Required Clean cohesive snap Sticky = cure inhibition
Shore A Hardness ASTM D2240 24–48 hrs Yes Required Target 30–50 Shore A Too soft = under-cure
Peel Adhesion ASTM C794 7 days cure Yes Yes ≥ 9 N/25mm; >75% cohesive Adhesive = substrate issue
Tensile Adhesion ASTM C1382 14–21 days Yes Yes ≥ 0.14 N/mm² (140 kPa) Adhesive pull = reprimer
Compatibility ASTM C1087 Pre-project (once) Yes Yes No inhibition, bleed, or discolor Inhibition = change spacer
Field Tab Pull ASTM C1521 During & after install Yes Yes Cohesive failure Adhesive = remove & reglaze
Movement Capability ASTM C719 Pre-project (once) Yes Yes No failure ±25% movement Tear = wrong sealant spec
05 · Engineering Formulas

Structural Silicone Design Calculations

Key formulas for SSG bite size, sealant volume, and structural capacity as referenced in ASTM C1401 and manufacturer design guides. Full Calculator at FacadeMart.com

ASTM C1401 — Bite Width (b)
b = (W × H) / (2 × Fs × e)
b = required SSG bite (mm)
W = wind load (kPa)
H = panel height (m)
Fs = design strength of silicone = 0.14 N/mm²
e = edge/2 (mm) — half the short panel dimension

Design Strength Reference

Per ASTM C1401 the allowable design stress for SSG is 0.14 N/mm² (140 kPa) in tensile and shear. Manufacturer values are higher (0.17–0.20 N/mm²) but 0.14 is the code-allowable.

Sealant Volume per Linear Metre
V = (b × d × L) × 1.15
V = volume (cm³ or mL)
b = bite width (cm)
d = sealant depth / thickness (cm)
L = joint length (cm)
1.15 = 15% waste factor (typical)
Silicone Quantity Calculator — FacadeMart
Structural Capacity Check
P_allow = Fs × b × L_panel
P_allow = allowable wind load resistance per unit length (N/m)
Fs = 0.14 N/mm² (design strength)
b = bite width (mm)
L_panel = panel perimeter length (m)
Must exceed: W_design × Panel Area
Cartridge Coverage Estimate
N = (A_total × 1000) / V_cartridge
N = number of cartridges required
A_total = total sealant volume (mL) — from formula above × all panels
V_cartridge = cartridge volume (typically 300ml, 600ml)
Add 10–15% buffer for purging & waste
Material Takeoff Calculator — FacadeMart

Minimum Bite Width Quick Reference Table

Panel Width (m) Panel Height (m) Wind Load (kPa) Min Bite Width (mm) Recommended Bite (mm) Notes
0.61.21.01318Light façade, low zone
0.91.51.52025Standard office façade
1.22.42.03440Medium panel, high wind
1.53.02.55460Large panel — requires 2-part
2.03.63.07780Unitised system, structural silicone + mechanical back-up

Values based on Fs = 0.14 N/mm² per ASTM C1401. Verify with project engineer for actual design. Full Tables at FacadeMart

06 · Product Reference

Leading Brands — Structural Silicone

Dow, Momentive (GE Sealants), Elkem, and Wacker are the four primary global structural silicone manufacturers. All products below are ASTM C1184 / EN 15434 approved grades.

Dow Corning
Dow Building Solutions
DOWSIL™ 795
1-Part · High movement weatherseal
±50%
DOWSIL™ 993
1-Part · Structural glazing sealant
Structural
DOWSIL™ 895
1-Part · Structural SSG
Structural
DOWSIL™ 983
2-Part · Factory/field SSG
2-Part
DOWSIL™ 3362
2-Part · High strength
2-Part
Dow Strength Tables — FacadeMart
Momentive (GE)
GE Sealants / Momentive
SCS2000
1-Part · Structural SSG sealant
Structural
SCS9000
1-Part · High modulus structural
Structural
SCS2700
2-Part · Factory SSG system
2-Part
SCS1000
1-Part · Weatherseal / perimeter
Weather
GE Structural Tables — FacadeMart
Elkem Silicones
Elkem ASA · Norway
GLASS-GRIP™ 100
1-Part · Neutral cure structural
Structural
GLASS-GRIP™ 200
2-Part · Factory glazing
2-Part
SILBIONE™ SSG-SR
1-Part · Structural / façade
Structural
Elkem Data Sheets — FacadeMart
Wacker Chemie
Wacker AG · Germany
ELASTOSIL® N 569
1-Part · Neutral structural sealant
Structural
ELASTOSIL® SG-20
2-Part · SSG factory system
2-Part
ELASTOSIL® WS 625
1-Part · Weatherseal / façade
Weather
Wacker Strength Tables — FacadeMart

Design Strength Comparison (Manufacturer Data)

Brand Product Type Tensile Strength (N/mm²) Elongation at Break Shore A Design Stress (N/mm²) Standard
DowDOWSIL 9931-Part0.69250%450.17ASTM C1184
DowDOWSIL 9832-Part0.86200%400.21ASTM C1184 / EN 15434
GE / MomentiveSCS20001-Part0.55300%350.14ASTM C1184
GE / MomentiveSCS27002-Part0.80220%420.20ASTM C1184 / EN 15434
ElkemGLASS-GRIP 1001-Part0.60280%380.15EN 15434
WackerELASTOSIL N5691-Part0.65270%400.14EN 15434 / ETAG 002
WackerELASTOSIL SG-202-Part0.90180%480.20EN 15434 / ETAG 002

Values from manufacturer TDS; verify current TDS before design. Design stress per ASTM C1401 = 0.14 N/mm² regardless of product data. Compare Products — FacadeMart

07 · Labor Training

Applicator Training Manual

A compact field-ready training guide for glazing applicators and supervisors. Laminate and post at the workstation.

Safety First — PPE Required at All Times

Nitrile gloves (not latex), safety glasses, steel-toe boots. If using solvent cleaner (MEK, IPA, Xylene): ensure ventilation, no sparks. Structural silicone sealant is non-toxic once cured but uncured material is a skin sensitiser — minimise contact. SDS must be available at workstation.

1

Before You Start — Pre-Application Checklist

  • Check sealant batch number and expiry date — never use expired product
  • Verify product is the approved structural silicone for this project (match spec sheet)
  • Check ambient temperature (5°C–40°C) and humidity (30–75% RH)
  • Inspect surface for contamination, moisture, frost, or oil — all must be absent
  • Confirm primer (if needed) is correct type and within its open-time window
  • For 2-part: perform butterfly test — log result
  • Sign and date the pre-application checklist in the logbook
2

Surface Preparation — The Most Critical Step

  • Use 2-cloth method: First cloth wet with IPA (wipe), second cloth dry (remove residue before evaporation)
  • Change cloth every 300mm — never re-wipe with dirty cloth
  • Flash-off time: minimum 5 minutes before priming or sealing
  • On anodised aluminium: IPA is usually sufficient; test for adhesion first
  • On coated aluminium (PVDF/powder coat): primer required — check compatibility report
  • On glass: IPA only — no abrasive pads on glass faces
  • Apply masking tape 2mm back from intended sealant edge — straight and smooth
3

Gun Setup & Application Technique

  • Cut nozzle at 45° angle. Nozzle opening = joint width. Smooth cut — no ragged edges
  • Hold gun at 45° to the joint; push (don't pull) the bead into the joint
  • Maintain constant gun speed — equal to extrusion rate
  • Fill joint completely — watch for any voids or holidays
  • Do not stop mid-joint unless absolutely necessary (creates weak point)
  • If you must stop: overlap 25mm back over previous bead and re-tool the overlap
  • Maintain gun pressure — release trigger slightly before the end of the joint
4

Tooling — Finishing the Joint

  • Tool within 5–7 minutes (1-part) or 10–15 minutes (2-part)
  • Use a smooth plastic, stainless, or wetted wooden spatula
  • Single stroke — do not go back and forth repeatedly
  • Concave profile: ensures sealant is pressed against both substrates
  • Do not use soap or water for tooling structural silicone — it can inhibit surface cure
  • Remove masking tape immediately after tooling, before sealant skins
  • Clean any smears on glass with damp cloth immediately (before cure)
5

Post-Application QC & Logging

  • Take witness bead / coupon at start of every shift — label with date, time, location, batch, operator
  • For 2-part: snap test at 1–3 hours; log result
  • Shore A test on coupon at 24 hours; log
  • Peel test at 7 days (ASTM C794) — take from a sacificial coupon, not from the panel joint
  • Enter panel code, date glazed, sealant batch number into the panel logbook
  • Mark any rework or second-application panels with a sticker and note in log
  • Supervisor inspects and signs off every panel before shipping (factory) or before handover (site)
6

Common Defects & Remedies

DefectCauseRemedy
Adhesive failure (peels off substrate)Dirty surface, no primer, or wrong primerRemove sealant, re-prep, re-prime, reapply
Air bubbles / voidsGun stopped, incorrect angle, fast cureCut out void zone, clean, refill, re-tool
Soft / tacky after 48 hrs (2-part)Wrong mix ratio, cure inhibition, old materialRemove all uncured sealant, identify cause, replace cartridge
Discolouration / stainingIncompatible gasket or primer bleedingReview compatibility test; replace incompatible component
Sealant shrinkage / pulling awayJoint too wide for sealant modulus, or under-filledReview bite design; ensure full fill; re-check with tensile coupon
Poor tooling / rough surfaceTooled too late, wrong toolCosmetic only if structural bond intact; test adhesion
08 · Deglazing

Deglazing — Procedure & Safety

Removal of structurally bonded glass panels. Requires careful planning — never cut structural silicone without a safe glass retention plan in place.

⚠️

Critical Safety Warning

Structural silicone is the sole dead-load support in many SSG systems. Never cut or remove structural silicone without temporary glass retention equipment (suction cups, glass clamps, scaffolding, or telehandler support) in place first. Glass panels can weigh 50–400 kg. Always have at least 2 trained operatives. Work at height requires RAMS (Risk Assessment & Method Statement).

1

Inspection & Documentation

Photograph panel from inside and outside. Identify all silicone joint locations (typically 4 sides). Check if any mechanical safety clips/retainers are present — these must be removed last. Log panel code in deglazing record.

2

Install Glass Retention Equipment

Attach minimum 2 (preferably 4) vacuum/suction cups rated for the panel weight plus 3× safety factor. Or use external scaffolding glass carrier. Verify suction with vacuum gauge before proceeding.

3

Score & Cut Silicone Joints

Use sharp triangular oscillating blade or structural silicone knife. Cut along the bond line — silicone to glass interface. Insert knife flat (parallel to glass face). Work around all 4 sides. Do not use power angle grinder near glass.

4

Carefully Remove Panel

With suction cups held and operative(s) stabilising the panel, push gently from inside to break the remaining bond. Slide panel outward. Lower panel on suction frame to a glazing trolley or flat surface.

5

Remove Old Silicone Residue

Use plastic scraper + IPA or Dow OS-2 silicone remover. Never use metal scrapers on aluminium frames or glass. Remove all traces of cured silicone. Sand or abrade if needed. Confirm all residue removed before re-glazing.

6

Log the Deglazing Event

Record in the panel log: panel ID, date deglazing occurred, reason for removal (damage, defect, inspection), condition of sealant on removal (cohesive vs adhesive failure), and operative names. This data is critical for warranty & facility management.

09 · Log Book

Panel Log Book — Excel Data Entry

Required data fields for the structural silicone glazing log. Maintain one row per panel. Archive for minimum 10 years.

Why a log book is mandatory

ASTM C1401 and ETAG 002 require full traceability of all structural silicone bonds. The logbook provides the evidence trail for warranty claims, inspection audits, insurance, and post-occupancy investigations. It must accompany the building's O&M manual.

Required Columns — Panel Glazing Log (Tab 1: Glazing Log)

# Column Name Data Type Example Entry Notes
APanel CodeTextF3-B-012Floor-Bay-Panel sequential
BDate GlazedDate14/03/2024Actual date sealant applied
CShift / TimeTextAM / 08:30Morning / Afternoon / Night
DOperator NameTextAhmed R.Certified applicator only
ESupervisor Sign-offTextJ. MalikQC supervisor initials
FSealant ProductTextDOWSIL 993From approved product list
GBatch / Lot NumberTextLOT-2402-AFrom cartridge label
HExpiry DateDate31/08/2024Must be future at time of use
IAmbient Temperature (°C)Number24Measured at workstation
JRelative Humidity (%)Number55At time of application
KButterfly Test (2-part)Pass/FailPassN/A for 1-part
LSnap Test Time & ResultText10:30 / Pass2-part only
MShore A (24hr coupon)Number42Target 30–50
NPeel Test (7-day)Number + mode14 N / CohesiveASTM C794 ≥9N/25mm
OTensile Test (14-day)Number + mode0.38 N/mm² / Coh.ASTM C1382 ≥0.14 N/mm²
PPanel StatusDropdownPassed / Rework / FailedConditional formatting: green/amber/red
QRework NotesTextAdhesive fail top edge — re-primed and resealed 16/03Free text
RDeglazed?Yes/NoNoLink to Deglazing Log tab

Tab 2: Daily QC Summary

ColumnFieldFormula / Notes
ADateDate of QC record
BPanels Glazed Today=COUNTIFS(Glazing_Log[Date Glazed],A2) — auto count
CPass Rate (%)=COUNTIFS(…[Status],"Passed",…[Date],A2)/B2 — >95% target
DAvg Shore A=AVERAGEIFS(…[Shore A],…[Date],A2)
EAvg Peel Force=AVERAGEIFS(…[Peel],…[Date],A2)
FAny failures?=COUNTIFS(…[Status],"Failed",…[Date],A2) — conditional format red if >0
GSupervisor SignManual entry

Tab 3: Deglazing Record

ColumnFieldNotes
APanel CodeCross-reference to Glazing Log
BOriginal Glaze DateAuto-lookup from Glazing Log
CDeglaze DateActual date of removal
DYears in Service=(C2-B2)/365
EReason for RemovalDropdown: Damage / Defect / Inspection / Renovation
FFailure Mode on RemovalCohesive / Adhesive / Mixed
GCondition of Frame / GlassFree text — record corrosion, coating failure, etc.
HRe-glazed?Yes/No / Replacement date
IOperativeName + certification number
JSupervisor Sign-offSignature required

Excel Formatting Tips

  • Use Data Validation dropdowns for Status, Failure Mode, and Reason columns
  • Apply Conditional Formatting: Pass = green fill, Rework = amber, Failed = red
  • Lock header rows and Panel Code column (freeze panes)
  • Protect formula columns with worksheet password
  • Link each batch number to a scanned TDS/SDS PDF in a shared folder
  • Set up automatic alerts if Peel value <9 or Shore A <25 (formula + conditional format)