Spreadsheet: 880563d1728367614-summing-specific-cells-based-on-criiteria-test
Sheet: Copy of Novecom 2xBAM Mains

Novecom 2D shelter for BAMS
PART NUMBER | [NAME] | Usual QTY | UNIT PRICE | LINE TOTAL | CATEGORY TOTAL | MARGIN | UNIT COST PRICE | LINE TOTAL COST | CATEGORY TOTAL
 | ENCLOSURE OPTIONS
Z-SHELT-CP-2DVIC | SHELTER COMPACT 2 DOOR (INSULATED, SUIT 27RU) - LOCAL CABMF16 SPEC + SIDE SUPPORTS FOR A/C | 1 |  |  |  | 0.5 | 5878.1823
H040146 | LADDER TO SUIT PLATFORM (BMKS10 MODIFIED) |  |  |  |  | 0.6 | 173
 | BENCH TOP FOR PM MONITORS | 1 |  |  |  | 0.6 | 200
H040313 | SHELTER BASE FRAME FEET - MOUNTING |  |  |  |  | 0.8 | 16.43
HAR-8525 | LADDER HOOKS SET |  |  |  |  | 0.8 | 85
H030095 | MAX-MIN THERMOMETER & HYGROMETER, DIGITAL | 1 |  |  |  | 0.8 | 20.3
SPECIAL | GLAND-PLATE AND TRIM WALL OF ENCLOSURE | 1 |  |  |  | 0.6 | 250
H040317 | LOAD RING, VLBG M16 2t, | 4 |  |  |  | 0.6 | 169
H040135-01 | MAINS WIRING OF WALK-IN SHELTER |  |  |  |  | 0.5 | 3300
 | MAINS WIRING OF 2D SHELTER | 1 |  |  |  | 0.55
SWI-1108 | THERMOSTAT, CABINET, 0-50C | 1 |  |  |  | 0.7 | 117
S031009-03 | SHELTER TEMPERATURE SENSOR, RS232, 3m CABLE  (NEW AS3580 REQUIREMENT TO RECORD SHELTER TEMPERATURE CONTINUOUSLY) | 1 |  |  |  | 0.7 | 90
[NAME] | EXIT SIGN POLYPROPYLENE |  |  |  |  | 0.8 | 27
S010043 | SURGE ARRESTOR / DIVERTER, SINGLE PHASE PLUS NEUTRAL | 1 |  |  |  | 0.7 | 115
S010044 | SURGE ARRESTOR / DIVERTER, THREE PHASE |  |  |  |  | 0.5 | 209
 | AIR CONDITIONER / CLIMATE CONTROL SYSTEM | .
H040137 | 3.5kW REVERSE CYCLE AIRCON, INCLUDING INSTALLATION |  |  |  |  | 0.55 | 1658
H040137-01 | 2kW REVERSE CYCLE AIRCON, INCLUDING INSTALLATION | 1 |  |  |  | 0.55 | 1420.4
 | RACK FRAME & ACCESSORIES | .
Z-MFB39RU-1 | RACK FRAME 39RU |  |  |  |  | 0.5 | 1022.4336
Z-MFB27RU-1 | RACK FRAME 27RU |  |  |  |  | 0.5 | 557.2314000000001
HAR-855-TP | RACK TOP PANEL 855 DEEP |  |  |  |  | 0.5 | 144.9868
HAR-855-39SP | RACK SIDE PANEL 39RU 855 DEEP |  |  |  |  | 0.5 | 326.427
H040163 | BRACKET OR WALL MOUNT FOR MONITOR |  |  |  |  | 0.5 | 22.83
H030181 | 1RU PANEL GREY (SERINUS) |  |  |  |  | 0.5 | 17.3
H030182 | 2RU PANEL (GREY) |  |  |  |  | 0.5 | 36
H030183 | 3RU PANEL (GREY) |  |  |  |  | 0.5 | 48.17
H030184 | 4RU PANEL (GREY) |  |  |  |  | 0.5 | 45.72
HAR-2911 | BRACKET SHORT EXTENSION TO SUIT HAR-2910 (2/SET) |  |  |  |  | 0.5 | 47
HAR-2910 | TELESCOPIC SHELF |  |  |  |  | 0.5 | 290.7156
HAR-2915 | SHELF FLAT 19" X 600mm MFB |  |  |  |  | 0.5 | 91.0964
S010045 | [NAME], SINGLE PHASE, 250V MAINS POWER 1500VA/750W, 3 OUTLET (EACH) |  |  |  |  | 0.5 | 100.7
[NAME] | POWER BOARD, 6-WAY JACKSON 19", RACK MOUNT TYPE |  |  |  |  | 0.5 | 47
 | MOUNTING HARDWARE FOR PUMPS | .
SPECIAL | SHELF FLAT 19" X 400mm MFB MOUNTED UPSIDE DOWN FOR 2 x LOOSE PUMPS (EASY MAINTENANCE) |  |  |  |  | 0.5 | 60
H030023 | PUMP STAND SIDE BRACKETS |  |  |  |  | 0.5 | 13.78
H030024 | PUMP STAND WALL MOUNT L-BRACKET |  |  |  |  | 0.5 | 4.505
H030185 | 5RU PANEL GREY |  |  |  |  | 0.5 | 20.2354
H030159 | WAFFLE MAT 457 x 457 x 8mm (1 PER PUMP) | 2 |  |  |  | 0.8 | 26.01
[NAME] | GREEN SYLOMER PUMP MAT 440 X 330 X 12MM (INSTEAD OF FEET AND MOUNTING PLATE) |  |  |  |  | 0.5 | 83.32
SPECIAL | PUMP MOUNTING HARDWARE - TRAILER DESIGN |  |  |  |  | 0.5 | 345
 | PARTICULATE MONITORS - BAM1020 PM10
E031030-01 | BAM V3 WITH TOUCH SCREEN | 1 |  |  |  | 0.5 | 13052.554224
ZMM-83781 | ACOEM PM10 KIT TO SUIT SPIRANT BAM | 1 |  |  |  | 0.55 | 1735.572026
ZMM-BX830 | SMART HEATER (240 VOLTS -50HZ) COMPLETE ASSEMBLY TO SUIT BAM 1020 & SPIRANT BAM | 1 |  |  |  | 0.55 | 1566.306562
E031038 | 230V PUMP (GAST ROTARY VANE) |  |  |  |  | 0.5 | 1471.893104
E031040 | 230V PUMP (MEDO LINEAR) | 1 |  |  |  | 0.55 | 1442.307232
ECO-1001P | FLANGE SET 32MM NOMINAL FOR BAM | 1 |  |  |  | 0.7 | 144.67251
 | PARTICULATE MONITORS - BAM1020 PM2.5 FEM
E031030-01 | BAM V3 WITH TOUCH SCREEN | 1 |  |  |  | 0.5 | 13052.554224
ZMM-83783 | [NAME] (BX-FEM 2.5B URG-2000-30EGN) TO SUIT SPIRANT BAM | 1 |  |  |  | 0.55 | 3543.054982
ZMM-BX830 | SMART HEATER (240 VOLTS -50HZ) COMPLETE ASSEMBLY TO SUIT BAM 1020 & SPIRANT BAM | 1 |  |  |  | 0.55 | 1566.306562
E031038 | 230V PUMP (GAST ROTARY VANE) |  |  |  |  | 0.55 | 1471.893104
E031040 | 230V PUMP (MEDO LINEAR) | 1 |  |  |  | 0.55 | 1442.307232
ECO-1001P | FLANGE SET 32MM NOMINAL FOR BAM | 1 |  |  |  | 0.7 | 144.67251
 | DATA MANAGEMENT & REMOTE COMMUNICATION | .
E042010 | CONGREGO LOGGER INC 1 YEAR SOFTWARE MAINTENANCE |  |  |  |  | 0.55 | 3173.832814
E021400 | CONGREGO 2 YEAR SOFTWARE MAINTENANCE EXTENSION |  |  |  |  | 0.55 | 668
H040202 | LOGGER MOUNTING RACK |  |  |  |  | 0.7 | 42
E042002 | TERMINATION PANEL (FOR RACK TEMPERATURE SENSORS, ANALOG SENSORS) INCL POWER SUPPLY |  |  |  |  | 0.55 | 925.690156
HAR-3012 | TERMINATION PANEL SHELF |  |  |  |  | 0.7 | 89.38980000000001
COM-1091 | SCREEN, 19" LCD |  |  |  |  | 0.7 | 197
C040110 | [NAME] |  |  |  |  | 0.8 | 11
C040111 | KEYBOARD, MNI, USB & PS2, BLACK 89 KEYS, 10 HOT KEYS |  |  |  |  | 0.8 | 21
S010034 | NETWORK HUB/SWITCH, 8-PORT, INDUSTRIAL |  |  |  |  | 0.7 | 171
C020117 | [NAME], 1m (CONGREGO TO SWITCH) |  |  |  |  | 0.8 | 3
C020145 | [NAME], 3m (SWITCH TO SERINUS ANALYSERS & CALIBRATOR) |  |  |  |  | 0.8 | 12
C020184 | [NAME], 5m (SWITCH TO MODEM) |  |  |  |  | 0.8 | 12
M030012 | MULTITECH MTR 4G ROUTER MODEM (INCL PLUGPACK/POWER SUPPLY) (EACH) |  |  |  |  | 0.55 | 610
M030006 | ADAPTER SMA M TO FME M |  |  |  |  | 0.8 | 4
COM-1328-3 | ANTENNA FME W 6.5dB DUAL BAND |  |  |  |  | 0.7 | 105
E021350 | [NAME], WITH ONE USER LICENSE |  |  |  |  | 0.55 | 1105
E021354 | AIRODIS STANDARD STATION LICENCE |  |  |  |  | 0.55 | 767
 | PAIRED DIFF TEMP SENSORS WITH FAN ASPIRATED RADIATION SHIELDS
ZRM-43502 | COMPACT ASPIRATED RADIATION SHIELD - 2 EACH REQ. PER JOB |  |  |  |  | 0.5 | 692.3075180000001
POW-1017 | POWER PACK 12VDC 3.8A SWITCHMODE (FOR RADIATION SHIELDS) |  |  |  |  | 0.5 | 33.92
E031224 | SENSOR, TEMPERATURE HIGH PRECISION |  |  |  |  | 0.5 | 278.956702
ZZ-SC-8400-10 | TEMPERATURE PROBE CAL. |  |  |  |  | 0.5 | 233.2
CAB-1302 | 4-CORE CABLE (21m) |  |  |  |  | 0.5 | 156.7422
NOTE | 4-CORE CABLE (CAB-1302 TYPE) 6M LENGTH BOOTLACE AT BOTH ENDS, AND SHIELD AT ONE END |  |  |  |  | 0.5
NOTE | 4-CORE CABLE (CAB-1302 TYPE) 15M LENGTH BOOTLACE AT BOTH ENDS, AND SHIELD AT ONE END |  |  |  |  | 0.5
POW-1016 | POWER PACK 24V 40W |  |  |  |  | 0.5 | 33.92
C040002 | POWER LEAD, AUST. FIGURE 8 (1 REQ'D PER POW-1016 or POW-1017) |  |  |  |  | 0.5 | 5.141
POW-1017-1 | BRACKET TO SUIT SSL40C POWER (1 REQ'D PER POW-1016 or POW-1017) |  |  |  |  | 0.5 | 10.6
UTB-30SP | TRANSIENT BARRIER FOR POWER SUPPLY |  |  |  |  | 0.5 | 110
 | ULTRASONIC WIND SENSOR WITH MOUNTING KIT | . |  |  |  |  |  |  |  | .
S031007 | WIND SENSOR, WINDSONIC ULTRASONIC 2D ANEMOMETER, [NAME] AND ANALOG OUTPUT (EACH) |  |  |  |  | 0.5 | 2183.6 |  |  | 1
H060045-01 | MOUNTING TUBE KIT, WINDSONIC, |  |  |  |  | 0.5 | 55.3673 |  |  | 1
ZZ-SC-6020-00 | LOW [NAME] (0.3-15m/s) & WIND DIRECTION - NATA CALIBRATION 25PTS |  |  |  |  | 0.5 | 420
ZZ-SC-6020-05 | LOW.HIGH SP.&WIND DIRECT.CAL NATA ENDOR.CERT.(0.30TO30M/S) 37 POINTS MEASURED (MINIMUM) |  |  |  |  | 0.5 | 750 |  |  | 1
SPECIAL | 6 CORE SHIELDED CABLE 12M |  |  |  |  | 0.5 | 2 |  |  | 15
 | METEOROLOGICAL - TEMP & RH
S031003 | HMP155A  TEMP & RH |  |  |  |  | 0.5 | 980.288
C030013 | CABLE KIT HMP155A, 10M |  |  |  |  | 0.5 | 72.08
ECO-DTR503A | RADIATION SHIELD FOR HMP155A |  |  |  |  | 0.5 | 506.256
ECO-VREF2.5 | 2.5V REFERENCE VOLTAGE SOURCE |  |  |  |  | 0.5 | 121.439642 |  |  | 1
ZMM-085A-35 | RH & TEMP SENSOR VOLTAGE OUTPUT (0-1V) |  |  |  |  | 0.5 | 1176.035126 |  |  | 1
[NAME] | CABLE KIT FOR 085A, 10m |  |  |  |  | 0.5 | 212.321604 |  |  | 1
ZMM-5980 | [NAME] FOR 083E, 5 PLATE |  |  |  |  | 0.5 | 273.668574 |  |  | 1
 | METEOROLOGICAL - SOLAR RADIATION
ECO-SKO1D2 | SOLAR RADIATION SENSOR, SK01D2, 3m CABLE LENGTH (SECOND CLASS NOT CONFIRMED) - AVOID |  |  |  |  | 0.5 | 1113
SPECIAL | SPECIFY CABLE LENGTH ON ORDER - 12m |  |  |  |  | 0.5 | 80
S030018 | SENSOR, SOLAR RADIATION, PYRANOMETER, SECOND CLASS DELTA-OHM, 0-1V, 5M CABLE |  |  |  |  | 0.5 | 997
S030018-15 | SENSOR, SOLAR RADIATION, PYRANOMETER, SECOND CLASS DELTA-OHM, 0-1V, 15M CABLE |  |  |  |  | 0.5 | 1044.1 |  |  | 1
 | METEOROLOGICAL - AMBIENT PRESSURE SENSOR
ZMM-092 | SENSOR BAROMETRIC PRESSURE 600-1100mBar, 0.1mBar RESOLUTION, -40 to +55°C OPERATING RANGE |  |  |  |  | 0.5 | 861.468572 |  |  | 1
ZMM-1169 | CABLE TO SUIT BAROMETRIC PRESS (3 METRE LENGTH - 10FT) |  |  |  |  | 0.5 | 17.4 |  |  | 1
 | METEOROLOGICAL - TIPPING BUCKET RAIN GAUGE
E050018 | RAIN GAUGE TIPPING BUCKET MODEL TB4 WITH SIPHON 0.2mm CALIBRATION |  |  |  |  | 0.5 | 757.0520000000001
E050020 | RAIN GAUGE TIPPING BUCKET MODEL TB7 - 0.2mm CALIBRATION |  |  |  |  | 0.5 | 371 |  |  | 1
CAB-1300 | SPECIFY CABLE LENGTH ON ORDER - 10m |  |  |  |  | 0.5 | 318 |  |  | 10
E050002 | MOUNTING PLATE FOR TB6 RAINGAUGE |  |  |  |  | 0.5 | 180.2 |  |  | 1
 | MET MAST INCL MOUNTING HARDWARE & LIGHTNING PROTECTION | . |  |  |  |  | Unit Cost |  |  | .
H030096 | SMCOMMS MAST NH9 2.30-9.00m 13kg LOAD |  |  |  |  | 0.5 | 3493.422072
H030096-01 | SMCOMMS MAST NH9.4 2.39-9.40m 13kg LOAD, 38mm TOP, 147kph GUYED |  |  |  |  | 0.5 | 3493.422072 |  |  | 1
H030097 | SMCOMMS MAST BRACKETS, SIDE MOUNTING SUIT NH9 |  |  |  |  | 0.5 | 622.690004 |  |  | 1
H030097-01 | BRACKETS, SIDE MOUNT UPPER, FOOT PLATE LOWER, TO SUIT NH SERIES MAST |  |  |  |  | 0.5 | 577.206888
H030098 | SMCOMMS MAST FOOT PUMP TO SUIT SMCOMMS MASTS (NH9/NK9) |  |  |  |  | 0.5 | 91.178126 |  |  | 1
H030099 | SMCOMMS MAST, GUY COLLAR ASSEMBLY FOR NH9 MAST |  |  |  |  | 0.5 | 125.957998 |  |  | 1
HAR-8517 | GUY WIRE KIT, 14m x 3mm, SET OF 3 |  |  |  |  | 0.5 | 174.9 |  |  | 1
HAR-8512 | LIGHTNING PROTECTION KIT FOR 10M TELESCOPIC MAST |  |  |  |  | 0.5 | 74.5922 |  |  | 1
HAR-8513 | LIGHTNING ROD MOUNT TO SUIT SQUARE PLATE --- AND SCREWS TO SUIT |  |  |  |  | 0.5 | 28.09 |  |  | 1
HAR-8516-1.0M | CROSS ARM, MET GEAR, 1.0m |  |  |  |  | 0.5 | 29.4256
HAR-8516-2M | CROSS ARM, MET GEAR, 2.0m |  |  |  |  | 0.5 | 44.9546 |  |  | 1
SPECIAL | CROSS-ARM, SQUARE STEEL WITH CAPS AND BOLTS, SUIT SOLAR RAD, TEMPERATURE, GALVANISED |  |  |  |  | 0.5 | 60 |  |  | 1
HAR-8506 | CROSS-ARM MOUNTING PLATE RECTANGULAR |  |  |  |  | 0.5 | 24.22 |  |  | 1
HAR-8510 | CROSS-ARM MOUNTING PLATE SUITE 25MM TUBE |  |  |  |  | 0.5 | 17.6914 |  |  | 2
FAS-IMPSS-U1 | U-BOLT 1" SS, SUIT 25mm TUBE |  |  |  |  | 0.5 | 4.611 |  |  | 8
FAS-IMPSS-U2 | U-BOLT 1 3/8" SS, SUIT 50mm TUBE |  |  |  |  | 0.5 | 5.088 |  |  | 2
FAS-IMPSS-U3 | U-BOLT, 1-1/4" NB, 1/4 UNC, |  |  |  |  | 0.5 | 5.141 |  |  | 2
HAR-8512-1 | MET SENSOR LIGHTNING PROTECTION KIT 6 CHANNEL - WITH ENCLOSURE / JUNCTION BOX |  |  |  |  | 0.5 | 385 |  |  | 1
POW-1017 | POWER PACK 12VDC 3.8A SWITCHMODE |  |  |  |  | 0.5 | 33.92 |  |  | 1
C040002 | POWER LEAD, AUST. FIGURE 8 (1 REQ'D PER POW-1016 or POW-1017) |  |  |  |  | 0.5 | 5.141
POW-1017-1 | BRACKET TO SUIT SSL40C POWER (1 REQ'D PER POW-1016 or POW-1017) |  |  |  |  | 0.5 | 10.6
HAR-8512-2 | LIGHTNING PROTECTION EXTENSION BOARD 6 CH |  |  |  |  | 0.5 | 192 |  |  | 1
 | MISCELLANEOUS HARDWARE & SUNDRIES | . |  |  |  | 0.5 |  |  |  | .
SPECIAL | [NAME] COST | 1 |  |  |  | 0.65 | 800 |  |  | 1
 | ENGINEERING AND INTEGRATION | .
LABOUR | BUILD, TEST & QA (HOURS) - STANDARD INSTRUMENTS (PER UNIT) | 40 | 150 |  |  |  | 63
LABOUR | ENGINEERING PROJECT MANAGEMENT, HOURS (PER UNIT) | 20 | 175 |  |  |  | 94
LABOUR | ENGINEERING, DRAWINGS, HOURS (PER UNIT) | 20 | 175 |  |  |  | 94
 | CRANAGE, PACKAGING & FREIGHT | .
Melb. Local | LOCAL FREIGHT OF SHELTER TO ECOTECH | 1 | 300 |  |  |  | 180
SPECIAL | PACKING OF SYSTEM AND SHELTER (MATERIALS AND LABOUR) (PER UNIT) | 10 | 150 |  |  |  | 63
SPECIAL | FREIGHT EXCLUDED - EXW MELBOURNE WAREHOUSE | 1
 | PRICE SUMMARY | .
 | TOTAL (EXCL GST) [NAME], VIC | . |  |  |  | O/All Margin
 | 10% GST | .
 | TOTAL (INCL GST) [NAME], VIC | .