Spreadsheet: 710031d1608673167-countifs-with-yes-in-column-c-new-calibration-logbook
Sheet: Current Equipment Listing

Today's Date |  |  |  |  | Scheduling Calibrations | Total | Necessary |  |  | Cycle Type | # | Calibrations
 |  |  |  |  | Due Within 30 Days |  |  |  |  | Monthly | 1 | Within 30 Days
 |  |  |  |  | Due Within 14 Days |  |  |  |  | Quarterly | 3 | Within 14 Days
 |  |  |  |  | Due Within 7 Days |  |  |  |  | Semi-Annual | 6 | Within 7 Days
 |  |  |  |  | Past Due Calibrations |  |  |  |  | Annual | 12 | Past Due
 |  | Necessary | Found | TEL # | Nomenclature | Model | Manufacturer | Serial Number | Dept/Area | Last Cal Date | Cycle | Due Date
 |  | Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10 | Column11 | Column12
 |  | No | Yes | 607 | 0-100 LBS FORCE GAUGE | DDPH-100 | CHATILLON | N/A | SERV-HGR | 2014-02-26 00:00:00 | Annual
 |  |  | No | 1104 | 0-100 LBS FORCE GAUGE | FDL-100 | WAGNER | 102241 | LINE/INSP | 2020-04-20 00:00:00 | Annual
 |  |  | No | 1414 | 0-1000 LBS FORCE GAUGE | CG1000 | MARK-10 | 3416602 | LINE/INSP |  | Annual
 |  | Yes | Yes | T796 | 0-150 LBS FORCE GAUGE | 80D | CHATILLON | DPPH-150 | PRODUCTION | 2020-04-20 00:00:00 | Annual
 |  | Yes | Yes | 1390 | 0-200 LBS FORCE GAUGE | DFX-200 | CHATILLON | W00372 | STD | 2020-09-20 00:00:00 | Annual
 |  | No | No | 883 | 0-40 VOLT PS | 4005 | POWER DES |  | STD | REF ONLY |  |  |  |  |  |  |  |  |  | =
 |  | No | Yes | 224 | 0-50 LBS FORCE GAUGE | DPP-50 | CHATILLON | N/A | SERV-HGR | 2014-02-25 00:00:00 | Annual
 |  | No | Yes | 1208B | 0-50 LBS FORCE GAUGE | DPP-50 | CHATILLON | N/A | SERV-HGR | 2014-02-26 00:00:00 | Annual
 |  |  | No | 1314 | 0-500 LBS FORCE GAUGE | N/A | [NAME] | N/A | LINE/INSP |  | Annual
 |  | Yes | Yes | 182 | 14V PHOTO GYRO PCB TEST | N/A | CFS | N/A | PRODUCTION | 2019-02-22 00:00:00 | Annual
 |  | Yes | Yes | 1171 | 1C388-2 SUB | 66C315 | CFS | 54 | SERV-HGR | REF ONLY | Annual
 |  | Yes | Yes | 344 | 1C407 ALT HOLD TESTER | N/A | CFS | N/A | LINE/INSP | 2019-02-23 00:00:00 | Annual
 |  | Yes | Yes | 293 | 1C707 OMNI CONVERTER TEST | 66D336 | CFS | N/A | INSP | REF ONLY
 |  | Yes | Yes | 571 | 1C741 ACCELEROMETER |  | CFS |  | PRODUCTION | REF ONLY
 |  | Yes | Yes | 639 | 1C771 TESTER | 1C771 | CFS | N/A | TECH | 2019-03-11 00:00:00 | Annual
 |  |  | No | 636 | 1C774 TESTER | 1C774 | CFS | N/A | TECH |  | Annual
 |  | Yes | Yes | 1217 | 1D960 PRESELECT TEST | 66S431 | CFS | N/A | TECH | 2019-08-12 00:00:00 | Annual
 |  | Yes | Yes | 181 | 28V PHOTO GYRO PCB TEST | N/A | CFS | N/A | PRODUCTION | 2019-02-22 00:00:00 | Annual
 |  | Yes | Yes | 1354 | 400 HZ POWER SUPPLY | 50-C-SK  OSC-1-400 | BEHLMAN | 919 & 16273 | GYRO/BAL | REF ONLY
 |  | Yes | Yes | 1340 | 400 HZ STATIC INVERTOR | PC 125 | MARATHON | 6279 | GYRO/BAL | REF ONLY
 |  | Yes | Yes | 301 | 52D54 TEST BOX | 66D289 | CFS | N/A | GYRO/REP | 2019-09-24 00:00:00 | Annual
 |  |  | No | T800 | 6" CALIPERS | N/A | PRESTIGE | G416036 | LINE/INSP |  | Annual
 |  | No | No | T802 | 6" CALIPERS | 610-5026 | ENCO | 95009430 | ENGINEERING |  | Annual
 |  | No | No | 1364 | 6" DIAL CALIPERS | 40172 | CRAFTSMAN | 594 | GYRO/BAL |  | Annual
 |  |  | No | 1412 | 6" DIGITAL CALIPERS | CD-6"-CSX | MITUTOYO | 10260424 | INSP/REC |  | Annual
 |  |  | No | 1420 | 6" DIGITAL CALIPERS | [NAME] | MITUTOYO | 11932990 | MACH-SH |  | Annual
 |  |  | No | T110 | 8" DIAL CALIPERS | N/A | PRESTIGE | G479898 | INSP/REC |  | Annual
 |  |  | No | 1421 | 8" DIGITAL CALIPERS | D8TN | MITUTOYO | 12905774 | MACH-SH |  | Annual
 |  | Yes | Yes | 1159 | A/C CABLE TENSIOMETER | 19738 TYPE C | WAC ENG | 1327 | SERV-HGR | 2019-04-19 00:00:00 | Annual
 |  | Yes | Yes | 1160 | A/C CABLE TENSION TESTER | T601001-C81A | PACIFIC ENG | 8769 | SERV-HGR | 2018-05-02 00:00:00 | Annual
 |  |  | No | 1370 | AC OUTLET & STRAP TESTER | 98130 | DESCO | 981300416035 | PRODUCTION |  | Annual
 |  | No | Yes | 1164 | AC SCALE 0-10,000 LBS | MD400C | GEN ELEC DY | 18509 | SERV-HGR | - | Annual
 |  | No | Yes | 1165 | AC SCALE 0-10,000 LBS | MD400C | GEN ELEC DY | 18510 | SERV-HGR | - | Annual
 |  | No | Yes | 1166 | AC SCALE 0-10,000 LBS | MD400C | GEN ELEC DY | 18511 | SERV-HGR | - | Annual
 |  | Yes | Yes | 1380 | ADAPTER TO USE ON TEL 1379 | 1C977 & -1 | CFS | . | TECH | REF ONLY
 |  |  | No | 1218 | ALTITUDE ENCODER SIMULATOR | 66S432 | ROSETTA | N/A | TECH |  | Annual
 |  | Yes | Yes | 28 | ALTITUDE HOLD COIL TESTER | 66D120 | CFS | N/A | TECH | 2019-06-20 00:00:00 | Annual
 |  | Yes | Yes | 722 | ALTITUDE HOLD COIL TESTER | 66D120 | CFS | N/A | TECH | 2019-03-11 00:00:00 | Annual
 |  | Yes | Yes | 440 | ALTITUDE HOLD TESTER | N/A | CFS | N/A | SERV-HGR | REF ONLY | Annual
 |  |  | No | 623 | ALTITUDE HOLD TESTER | 1C727 | CFS | N/A | TECH |  | Annual
 |  |  | No | 74 | ALTITUDE SELECT 0-200' | N/A | CFS | N/A | STD |  | Annual
 |  |  | No | 569 | AUDIO GENERATOR | 200AB | H-P | 4511 | STD |  | Annual
 |  | Yes | Yes | 793 | AUDIO GENERATOR | SG-5218 | HEATH-KIT | 40902 | GYRO/REP | REF ONLY
 |  |  | No | 31 | AUDIO OSCILLATOR |  |  |  |  | REF ONLY
 |  | Yes | Yes | 1333 | BALANCE MACHINE | M251/250 & M252W | [NAME] | ARD0602 | GYRO/BAL | 2020-05-19 00:00:00 | Annual
 |  | Yes | No | 1227 | BATTERY INSULATION TESTER | 21822 | BIDDLE | F2442 | SERV-HGR |  | Annual
 |  |  | No | 877 | BELT TESTER | 0-20 | FEDERAL | N/A | INSP |  | Annual
 |  | Yes | Yes | 663 | C21, C31, C41, C2000 TESTER | 66D358 | CFS | N/A | TECH | 2020-03-07 00:00:00 | Annual
 |  | Yes | Yes | 1180 | C21, C31, C41, C2000 TESTER | 66D358 | CFS | N/A | TECH | 2020-04-09 00:00:00 | Annual
 |  | Yes | Yes | 1157 | CI TEST SET | 66D306 | CFS | 160 | SERV-HGR | 2019-03-21 00:00:00 | Annual
 |  | Yes | Yes | 144 | CI TESTER | N/A | CFS | N/A | PRODUCTION | 2019-06-18 00:00:00 | Annual
 |  | Yes | Yes | 922 | CII, CIII, CIV TEST SET | 66D1000 | CFS | N/A | TECH | 2020-03-09 00:00:00 | Annual
 |  | Yes | Yes | 1202 | CII, CIII, CIV TEST SET | 66D1000 | CFS | N/A | TECH | 2020-03-25 00:00:00 | Annual
 |  |  | No | 1320 | COMPONENT TESTER | 815 | B & K | 20805758 | INSP |  | Annual
 |  | Yes | Yes | 10 | CRIMP TOOL | M22520/2-01 | DANIELS | N/A | SERV-HGR | 2020-02-07 00:00:00 | Annual
 |  | Yes | Yes | 1416 | CRIMP TOOL | M22520/2-01 | DANIELS | N/A | PRODUCTION | 2020-03-14 00:00:00 | Annual
 |  | Yes | Yes | T106 | CRIMP TOOL | M22520/2-01 | DANIELS | 11851 | PRODUCTION | 2019-03-05 00:00:00 | Annual
 |  | Yes | Yes | T109 | CRIMP TOOL | M22520/1-01 | BUCHANAN | 25129 | PRODUCTION | 2018-09-27 00:00:00 | Annual
 |  | Yes | Yes | 1404 | CRIMP TOOL ([NAME]) | M22520/2-01 | DANIELS | 601966-1 | GYRO/REP | 2017-04-02 00:00:00 | Annual
 |  |  | No | 1387 | CRIMP TOOL GAUGE | M22520/3-1 | DANIELS | N/A | STD |  | Annual
 |  |  | No | 884 | DC POWER SUPPLY |  |  |  |  | REF ONLY
 |  |  | No | 1240 | DC POWER SUPPLY |  |  |  |  | REF ONLY
 |  | Yes | Yes | 1336 | DC POWER SUPPLY | SPL-603 | SPECTRUM |  | TECH
 |  | Yes | Yes | 1338 | DC POWER SUPPLY | PSV-5 | CSI/SPECO |  | GYRO/BAL | REF ONLY
 |  | Yes | Yes | 1375 | DC POWER SUPPLY |  |  |  |  | REF ONLY
 |  | Yes | Yes | 1396 | DC POWER SUPPLY | 14605PS |  |  | GYRO/REP | REF ONLY
 |  |  | No | T714 | DEPTH MIC 0-3" | 129-127 | MITUTOYO | 56302 | INSP/REC |  | Annual
 |  |  | No | T718 | DEPTH MIC 0-3" | N/A | STARRETT | N/A | MACH-SH |  | Annual
 |  |  | No | 730 | DG TEST | 66D107 | CFS | 30 | STD |  | Annual
 |  | Yes | Yes | 642 | DIGITAL MULTIMETER | 8000A | FLUKE | 955177 | TECH | REF ONLY
 |  |  | No | 1353 | DIGITAL MULTIMETER | JTM-69 | JENSEN | 90803655 | INSP |  | Annual
 |  | Yes | Yes | 1357 | DIGITAL MULTIMETER | 87-3 | FLUKE | 85920047 | STD | 2018-10-09 00:00:00 | Annual
 |  | Yes | Yes | 1365 | DIGITAL MULTIMETER | JTM-69 | JENSEN | 13805228 | TECH | 2018-05-02 00:00:00 | Annual
 |  | Yes | No | 1371 | DIGITAL MULTIMETER | JTM-69 | JENSEN | 13805887 | SERV-HGR |  | Annual
 |  | Yes | Yes | 1372 | DIGITAL MULTIMETER | JTM-69 | JENSEN | 13805837 | TECH | 2019-11-14 00:00:00 | Annual
 |  |  | No | 1368 | DIGITAL RT OSCILLOSCOPE | TDS1012 | TEKTRONIX | C040604 | TECH |  | Annual
 |  |  | No | W-XX | ESD WRIST STRAPS | N/A | CFS | N/A | MFG |  | Annual
 |  | Yes | Yes | 646 | FIXED PS 14/28 VOLT |  | CFS |  | INSP | REF ONLY
 |  |  | No | 478 | FREQUENCY COUNTER | 5740 | DATA PREC | 2047 | STD |  | Annual
 |  |  | No | 413 | [NAME] | 3311A | H-P | 1244A05476 | STD |  | Annual
 |  |  | No | T708 | GAUGE BOX 6 PIECES | 516-102 | MITUTOYO | 708 | STD |  | Annual
 |  |  | No | 1337 | GAUSS/TESLAMETER | 5070 | [NAME] | 9823423 | INSP |  | Annual
 |  |  | No | 1379 | GPSS ANNUNICATOR TESTER | 81B901 | CFS | N/A | TECH | REF ONLY
 |  | Yes | Yes | 1173 | GYRO SUBSTITUTE | 66D141-1 | CFS | 609 | SERV-HGR | 2016-08-17 00:00:00 | Annual
 |  |  | No | 1101 | HEADING ADAPT TEST | 1C930 | CFS | N/A | TECH | REF ONLY
 |  |  | No | 1407 | HYGRO-THERMOMETER | 445715 | EXTECH | 315197 | TECH |  | Annual
 |  |  | No | 1411 | HYGRO-THERMOMETER | 445715 | EXTECH | 325533 | STD |  | Annual
 |  |  | No | 436 | [NAME] |  |  |  |  | REF ONLY
 |  |  | No | 762 | [NAME] | 6920B | H-P | 1533A03996 | STD |  | Annual
 |  |  | No | T797 | MIC 0 - 1" | 293-761 | MITUTOYO | 7174191 | STD |  | Annual
 |  | Yes | Yes | 151 | NAV / COM GEN W CONV. | T-12A / T-12A-1A | TIC | 337B | TECH | 2011-10-17 00:00:00 | Annual
 |  | Yes | Yes | 459 | NSD METER MOVEMENT CAL | N/A | CFS | N/A | LINE/INSP | 2019-02-20 00:00:00 | Annual
 |  | Yes | Yes | 587 | NSD PCB TESTER | 81D399 | CFS | N/A | PRODUCTION | 2018-03-19 00:00:00 | Annual
 |  | Yes | Yes | 85 | NSD POT & SLIP RING TEST |  | CFS |  | INSP | REF ONLY
 |  |  | No | 449 | NSD SLAVING SUBSTITUTE | N/A | CFS | N/A | STD |  | Annual
 |  | Yes | Yes | 433 | NSD TEST BOX | 66D341 | CFS | N/A | PRODUCTION | 2018-09-24 00:00:00 | Annual
 |  | Yes | Yes | 556 | NSD TEST BOX | 66D341 | CFS | N/A | INSP | 2020-04-03 00:00:00 | Annual
 |  |  | No | 511 | OSCILLOSCOPE | T922 | TEKTRONIX | B014442 | TECH | REF ONLY
 |  | Yes | Yes | 647 | OSCILLOSCOPE | T921 | TEKTRONIX | B012161 | TECH | 2019-11-14 00:00:00 | Annual
 |  | Yes | No | 801 | OSCILLOSCOPE | 465B/DM44 | TEKTRONIX | B062193 | GYRO/REP | 2019-11-14 00:00:00 | Annual
 |  |  | No | 812 | OSCILLOSCOPE | 475A/DM44 | TEKTRONIX | B016946 | INSP/REC |  | Annual
 |  |  | No | 1417 | OSCILLOSCOPE | 475 | TEKTRONIX | B279925 | STD |  | Annual
 |  | Yes | Yes | 1422 | OSCILLOSCOPE | TAS465 | TEKTRONIX | B013437 | STD | 2018-10-06 00:00:00 | Annual
 |  | Yes | Yes | 1423 | OSCILLOSCOPE | TA5465 | TEKTRONIX | B031443 |  | 2019-11-14 00:00:00 | Annual
 |  | Yes | Yes | 1344 | OVEN | SW-17TA | BLUE M | S3-5443 | GYRO/BAL | REF ONLY
 |  | Yes | Yes | 1310 | PITOT STATIC TEST SET | 377-4 | CASTLEBERRY | 739 | SERV-HGR | 2019-11-14 00:00:00 | Annual
 |  |  | No | 645 | POWER SUPPLY |  | CFS |  | INSP | REF ONLY
 |  | No | No | 1018 | POWER SUPPLY | 6433B | H-P |  | GYRO/BAL | REF ONLY
 |  |  | No | 600 | PRECISION CURRENT SOURCE | N/A | CFS | N/A | PRODUCTION |  | Annual
 |  |  | No | 68 | PWR/SUP PRECISION SOURCE | 6114A | H-P | 1242A00169 | STD |  | Annual
 |  | Yes | No | 357 | RADIO SUB BOX PN 101 SIM | N/A | CFS | N/A | SERV-HGR |  | Annual
 |  | Yes | Yes | 105 | RATE TABLE | M-34-1707 | U.S. ARMY | N/A | TECH | 2018-10-12 00:00:00 | Annual
 |  |  | No | 719 | RELAY TESTER 1B759 & -1 | 66C368 | CFS | N/A | TECH |  | Annual
 |  |  | No | 277 | RESISTANCE DECADE | [NAME] | BECKMAN | 86868 | STD |  | Annual
 |  | Yes | No | 1405 | ROTOR CALIBRATOR | N/A | CFS | 1 | GYRO/BAL |  | Annual
 |  |  | No | 1406 | SCALE | PC-802 | WEIGH-TRONIX | SRK1970581 | INSP |  | Annual
 |  | Yes | Yes | 9 | SERVO DRIVE RATE TABLE | N/A | CFS | N/A | PRODUCTION | 2019-01-18 00:00:00 | Annual
 |  | Yes | Yes | 398 | SERVO SUBSTITUTE | 66D141-2 | CFS | N/A | SERV-HGR | REF ONLY | Annual
 |  | Yes | Yes | 1212 | SERVO SUBSTITUTE | 66D141-2 | CFS | N/A | SERV-HGR | REF ONLY | Annual
 |  | Yes | Yes | 91 | SERVO TESTER |  | CFS |  | PRODUCTION | REF ONLY
 |  | Yes | Yes | 183 | SERVO TESTER | N/A | CFS | N/A | LINE/INSP | 2020-09-23 00:00:00 | Annual
 |  | Yes | Yes | 778 | SERVO TESTER |  | CFS |  | PRODUCTION | REF ONLY
 |  | Yes | Yes | 552 | SLAVING AMP/BOOTSTRAP TEST | 66D323-2 | CFS | N/A | TECH | 2020-02-20 00:00:00 | Annual
 |  | Yes | Yes | 192 | SPIN MOTOR TESTER |  | CFS |  | GYRO/BAL | REF ONLY
 |  |  | No | 1389 | STANDARD BUFFER SOLUTION | 00654-00 | OAKTON | N/A | STD |  | Annual
 |  | Yes | Yes | 203 | STEERING BAR TEST SET | 52C77-() | CFS | N/A | GYRO/REP | 2019-06-19 00:00:00 | Annual
 |  | No | Yes | 563 | STOP WATCH | N/A | CHESTERFIELD | N/A | SERV-HGR | 2013-04-24 00:00:00 | Annual
 |  |  | No | 683 | STOP WATCH | SINGLE EVENT | CRONUS | N/A | STD |  | Annual
 |  |  | No | 662 | SWEEP GENERATOR | 9063B | KAY | 9015 | STD |  | Annual
 |  | Yes | Yes | 936 | TACH WITH ROTOR STAND |  | CFS |  | GYRO/BAL | REF ONLY
 |  | Yes | Yes | 1214 | TACHOMETER | DT-107 | SHIMPO | 60258510 | LINE/INSP | 2017-01-27 00:00:00 | Annual
 |  | No | No | 1204 | TORQUE WATCH | 651C-2 | WATERS | 29550 | GYRO/BAL |  | Annual
 |  | Yes | Yes | 347 | TORQUE WRENCH 0'-150' | TE12A | SNAP-ON | 128892 | PRODUCTION | 2018-11-11 00:00:00 | Annual
 |  | Yes | No | 393 | TORQUE WRENCH 0'-150' | TE25 | SNAP-ON | 4807 | SERV-HGR | 2019-11-15 00:00:00 | Annual
 |  | Yes | Yes | 1356 | TORQUE WRENCH 0'-150' | TE12A | SNAP-ON | 115969 | SERV-HGR | 2014-09-05 00:00:00 | Annual
 |  | Yes | Yes | 1355 | TORQUE WRENCH 0'-300' | TE25A | SNAP-ON | 28382 | SERV-HGR | 2018-05-02 00:00:00 | Annual
 |  |  | No | 300 | TRANSFORMER TESTER | N/A | CFS | N/A | INSP | REF ONLY
 |  | Yes | Yes | 1399 | TRANSPONDER RAMP TEST SET | T-49C | TIC | 723 | SERV-HGR | 2019-11-14 00:00:00 | Annual
 |  | Yes | Yes | 291 | TRIM SWITCH TESTER |  | CFS |  | PRODUCTION | REF ONLY
 |  | Yes | Yes | 1369 | TRUE RMS MULTIMETER | 179 | FLUKE | 86160626 | TECH | 2019-11-14 00:00:00 | Annual
 |  |  | No | 1378 | TRUE RMS MULTIMETER | JTM-69A | JENSEN | 5123921 | TECH |  | Annual
 |  |  | No | 1408 | TRUE RMS MULTIMETER | 179 | FLUKE | 10440161 | INSP | 2018-10-09 00:00:00 | Annual
 |  | Yes | Yes | 1415 | TRUE RMS MULTIMETER | 179 | FLUKE | 16510081 | TECH | 2018-10-09 00:00:00 | Annual
 |  | Yes | Yes | 1418 | TRUE RMS MULTIMETER | 87V | FLUKE | 19030435 | GYRO/REP | 2019-11-14 00:00:00 | Annual
 |  | Yes | Yes | 850 | VARIABLE PS 0-20 VOLTS | 6284A | H-P | 1149A02532 | PRODUCTION | REF ONLY
 |  | No | No | 517 | [NAME] | 1610M | U-D CORP | 238 | ENGINEERING |  | Annual
 |  | Yes | Yes | 1163 | VOR/ILS RAMP TEST SET | TYPE T-30B/B | TIC | 1259 | SERV-HGR | 2019-11-14 00:00:00 | Annual
 |  |  | No | 1388 | WATERPROOF PH TESTER | 35624-02 | OAKTON | N/A | PRODUCTION |  | Annual
 |  | No | Yes | 358 | [NAME] GAUGE | N/A | FEDERAL | N/A | SERV-HGR | 2013-05-10 00:00:00 | Annual