Spreadsheet: 110848d1307444381-formula-for-counting-date-and-time-range-new-formula-test-file
Sheet: Data

Date & Time | [NAME] | User Name & Cell Selected | Cell Text | PDF Document Opened |  | Document Name | Total Click Count |  | Assembly Area | Area Total Click Count |  | Date | Daily Click Count
06/06/2011 08:59:06 | Opening Log File | genfalk1 |  |  |  | Section 1 |  |  | Section 1 | 0 |  | 2011-06-06 00:00:00 | #N/A
06/06/2011 08:59:06 | Index_File_Opened |  |  |  |  |  |  |  | Section 2 | 3 |  | 2011-06-07 00:00:00
06/06/2011 08:59:23 | PDF_File_Opened | $F$58 | Click Here | Load Module Fitting |  | Trolley Wheels Fitting | 0 |  | Section 3 | 1 |  | 2011-06-08 00:00:00
06/06/2011 09:28:57 | PDF_File_Opened | $F$59 | Click Here | [NAME] |  | [NAME] | 0 |  | Section 4 | 0 |  | 2011-06-09 00:00:00
06/06/2011 09:46:24 | Opening Log File | genfalk1 |  |  |  | Drill Holes In Chassis | 0 |  | Section 5 | 0 |  | 2011-06-10 00:00:00
06/06/2011 09:46:24 | Index_File_Opened |  |  |  |  | Chassis Earthing Points | 0 |  | Section 6 | 0 |  | 2011-06-11 00:00:00
06/06/2011 09:47:40 | PDF_File_Opened | $F$201 | Click Here | Check Curtis Controller Cover |  | Auxiliary Motor & Pump Prep | 0 |  | Section 7 | 1 |  | 2011-06-12 00:00:00
06/06/2011 09:49:26 | PDF_File_Opened | $F$60 | Click Here | Chassis Automotive & Iqan Loom Positioning |  | Auxiliary Motor & Pump Fitting | 0 |  | Prep Assembly's | 0 |  | 2011-06-13 00:00:00
06/06/2011 10:57:30 | PDF_File_Opened | $F$89 | Click Here | [NAME] |  | Pressure Filter | 0 |  | Sub Assembly's | 1 |  | 2011-06-14 00:00:00
06/06/2011 11:34:05 | Opening Log File | bdy |  |  |  | Compressor & Motor Assembly Mounting Brackets | 0 |  | Additional Notes | 0 |  | 2011-06-15 00:00:00
06/06/2011 11:34:05 | Index_File_Opened |  |  |  |  | Battery Mounting Pads | 0 |  |  |  |  | 2011-06-16 00:00:00
06/06/2011 12:11:31 | Opening Log File | bdy |  |  |  | Hopper Dump Valve Bulkhead Adaptor | 0 |  |  |  |  | 2011-06-17 00:00:00
06/06/2011 12:11:31 | Index_File_Opened |  |  |  |  | Sequence Valve Prep | 0 |  |  |  |  | 2011-06-18 00:00:00
06/06/2011 12:44:03 | Opening Log File | bdy |  |  |  | Sequence Valve Fitting | 0 |  |  |  |  | 2011-06-19 00:00:00
06/06/2011 12:44:03 | Index_File_Opened |  |  |  |  | Hopper Dump Valve Prep | 0 |  |  |  |  | 2011-06-20 00:00:00
06/06/2011 12:44:17 | Index_File_BeforeClose |  |  |  |  | Hopper Dump Valve Fitting | 0 |  |  |  |  | 2011-06-21 00:00:00
06/06/2011 12:44:17 | Closing Log File |  |  |  |  | [NAME] | 0 |  |  |  |  | 2011-06-22 00:00:00
06/06/2011 14:27:54 | Opening Log File | bdy |  |  |  | Water Pump Assembly | 0 |  |  |  |  | 2011-06-23 00:00:00
06/06/2011 14:27:54 | Index_File_Opened |  |  |  |  | Water Pump Fitting | 0 |  |  |  |  | 2011-06-24 00:00:00
06/06/2011 14:28:18 | Index_File_BeforeClose |  |  |  |  | Water Manifold Assembly | 0 |  |  |  |  | 2011-06-25 00:00:00
06/06/2011 14:28:18 | Closing Log File |  |  |  |  | Water Manifold Fitting | 0 |  |  |  |  | 2011-06-26 00:00:00
06/06/2011 14:36:33 | PDF_File_Opened | $[NAME] | Click Here | Rear Water Tank Assembly |  | Water Strainer Assembly | 0 |  |  |  |  | 2011-06-27 00:00:00
06/06/2011 15:41:17 | Opening Log File | bdy |  |  |  | Water Strainer Fitting | 0 |  |  |  |  | 2011-06-28 00:00:00
06/06/2011 15:41:17 | Index_File_Opened |  |  |  |  | Hopper Cylinders Fitting | 0 |  |  |  |  | 2011-06-29 00:00:00
06/06/2011 15:41:26 | Index_File_BeforeClose |  |  |  |  | Side Panel Pivots Prep | 0 |  |  |  |  | 2011-06-30 00:00:00
06/06/2011 15:41:26 | Closing Log File |  |  |  |  | Side Panel Pivots Fitting | 0
06/06/2011 16:21:52 | Opening Log File | bdy |  |  |  | Side Panel Latch Mounting Brackets | 0
06/06/2011 16:21:52 | Index_File_Opened |  |  |  |  | Chassis Gas [NAME] Joints | 0
06/06/2011 16:22:10 | Index_File_BeforeClose |  |  |  |  | [NAME] | 0
06/06/2011 16:22:10 | Closing Log File |  |  |  |  | Chassis Conical Stops | 0
06/06/2011 16:53:07 | Opening Log File | bdy |  |  |  | Battery Locating Pins | 0
06/06/2011 16:53:07 | Index_File_Opened |  |  |  |  | [NAME] | 0
06/06/2011 16:53:12 | Index_File_BeforeClose |  |  |  |  | Front Axle Fitting | 0
06/06/2011 16:53:12 | Closing Log File |  |  |  |  | Rear Axle Fitting | 0
06/06/2011 17:05:09 | Index_File_BeforeClose |  |  |  |  | Handbrake Cables Fitting | 0
06/06/2011 17:05:09 | Closing Log File |  |  |  |  | Battery Pack Plungers | 0
 |  |  |  |  |  | Hydraulic Tank Assembly | 0
 |  |  |  |  |  | Hydraulic Tank Fitting | 0
 |  |  |  |  |  | Chassis Brake Pipes | 0
 |  |  |  |  |  | Water Hoses | 0
 |  |  |  |  |  | Screenwash Hose & Chassis Camera Cable | 0
 |  |  |  |  |  | Section 2
 |  |  |  |  |  | Hydraulic Block HC158 Prep | 0
 |  |  |  |  |  | Hydraulic Block HC182 Prep | 0
 |  |  |  |  |  | Hydraulic Block HC158 Fitting | 0
 |  |  |  |  |  | Hydraulic Block HC182 Fitting | 0
 |  |  |  |  |  | XS2 Unit | 0
 |  |  |  |  |  | [NAME] | 0
 |  |  |  |  |  | Stop Light Prep | 0
 |  |  |  |  |  | Rear Reverse & Fog Lights | 0
 |  |  |  |  |  | Rear Indicator & Stop Lights | 0
 |  |  |  |  |  | Rubber Bumpers Prep | 0
 |  |  |  |  |  | Rubber Bumpers Fitting | 0
 |  |  |  |  |  | Load Module Fitting | 1
 |  |  |  |  |  | [NAME] | 1
 |  |  |  |  |  | Chassis Automotive & Iqan Loom Positioning | 1
 |  |  |  |  |  | Rear Lights Connection | 0
 |  |  |  |  |  | Reverse Beeper Fitting | 0
 |  |  |  |  |  | Spare Beacon Wire | 0
 |  |  |  |  |  | Hopper Dump Valve Connection | 0
 |  |  |  |  |  | Hydraulic Blocks Connection | 0
 |  |  |  |  |  | Water Level Sensor Connection | 0
 |  |  |  |  |  | Oil Level Sensor Connection | 0
 |  |  |  |  |  | Water Pump Connection | 0
 |  |  |  |  |  | [NAME] | 0
 |  |  |  |  |  | Cylinder Hoses & Rear Loom Secure | 0
 |  |  |  |  |  | Front Return Hose Assembly | 0
 |  |  |  |  |  | Brush Arms Fitting | 0
 |  |  |  |  |  | Chassis Earth Straps | 0
 |  |  |  |  |  | [NAME] | 0
 |  |  |  |  |  | Section 3
 |  |  |  |  |  | [NAME] | 0
 |  |  |  |  |  | Goalpost Fitting | 0
 |  |  |  |  |  | Curtis [NAME] | 0
 |  |  |  |  |  | Mosfet Junction Box Fitting | 0
 |  |  |  |  |  | Mosfet Junction Box Wiring | 0
 |  |  |  |  |  | Screenwash Pump Connection | 0
 |  |  |  |  |  | [NAME] | 0
 |  |  |  |  |  | Horn & Voice Box Connection | 0
 |  |  |  |  |  | Curtis [NAME] | 0
 |  |  |  |  |  | Traction Motor Cooling Fans Relay Box | 0
 |  |  |  |  |  | Traction Motor Cooling Fans | 0
 |  |  |  |  |  | [NAME] | 1
 |  |  |  |  |  | Section 4
 |  |  |  |  |  | Prepare Hoses & Looms For Cab Fitting | 0
 |  |  |  |  |  | [NAME] | 0
 |  |  |  |  |  | Cloudmaker Fitting | 0
 |  |  |  |  |  | Rear Water Tank Fitting | 0
 |  |  |  |  |  | Rear Water Tank Hose | 0
 |  |  |  |  |  | [NAME] | 0
 |  |  |  |  |  | [NAME] | 0
 |  |  |  |  |  | Chassis I.D. Plate | 0
 |  |  |  |  |  | Brake System Bleeding | 0
 |  |  |  |  |  | Cloudmaker Connection | 0
 |  |  |  |  |  | Section 5
 |  |  |  |  |  | Inspect Section Checklists | 0
 |  |  |  |  |  | Wheels | 0
 |  |  |  |  |  | Wheel Trim Mounting Brackets | 0
 |  |  |  |  |  | [NAME] | 0
 |  |  |  |  |  | Hopper Hand Pump Prep | 0
 |  |  |  |  |  | Hopper Hand Pump Fitting | 0
 |  |  |  |  |  | Hopper Hand Pump Hosing | 0
 |  |  |  |  |  | Fill Hydraulic Tank | 0
 |  |  |  |  |  | Rear Mudguards | 0
 |  |  |  |  |  | 12V Battery Connection | 0
 |  |  |  |  |  | 12V Battery Cover | 0
 |  |  |  |  |  | Screenwash | 0
 |  |  |  |  |  | Check 12V System Functions | 0
 |  |  |  |  |  | Windscreen Wiper Fitting | 0
 |  |  |  |  |  | MD3 Unit Prep | 0
 |  |  |  |  |  | MD3 Unit Setup | 0
 |  |  |  |  |  | Hopper Hand Pump Testing | 0
 |  |  |  |  |  | Handbrake Cables Adjustment | 0
 |  |  |  |  |  | Rear Water Tank Chain Retaining Bracket | 0
 |  |  |  |  |  | MD3 Unit [NAME] | 0
 |  |  |  |  |  | Program Curtis Controllers | 0
 |  |  |  |  |  | Functional Test 1 | 0
 |  |  |  |  |  | Hydraulic Tank Top Up | 0
 |  |  |  |  |  | Front Number Plate Mounting Bracket | 0
 |  |  |  |  |  | Nozzle To Hopper Alignment | 0
 |  |  |  |  |  | Hopper Lifting Bracket Removal | 0
 |  |  |  |  |  | Curtis [NAME] | 0
 |  |  |  |  |  | Check Brush Arms & Nozzle | 0
 |  |  |  |  |  | [NAME] | 0
 |  |  |  |  |  | Charge & Test Air Conditioning System | 0
 |  |  |  |  |  | [NAME] | 0
 |  |  |  |  |  | [NAME] | 0
 |  |  |  |  |  | [NAME] | 0
 |  |  |  |  |  | Test Emergency Brake Release | 0
 |  |  |  |  |  | Section 6
 |  |  |  |  |  | In Cab Checks | 0
 |  |  |  |  |  | Functional Test 2 | 0
 |  |  |  |  |  | Engine Compartment Inspection | 0
 |  |  |  |  |  | Under Cab Inspection | 0
 |  |  |  |  |  | Exterior Body Checks | 0
 |  |  |  |  |  | Snagging | 0
 |  |  |  |  |  | Battery Packs Fitting | 0
 |  |  |  |  |  | Cyclic Test | 0
 |  |  |  |  |  | Test Brushes Fitting | 0
 |  |  |  |  |  | Test Panels Fitting | 0
 |  |  |  |  |  | Test Mudguards Fitting | 0
 |  |  |  |  |  | Trade Plates | 0
 |  |  |  |  |  | Fill Water Tank | 0
 |  |  |  |  |  | Check Water System | 0
 |  |  |  |  |  | Test Cab Lockdown Bracket Fitting | 0
 |  |  |  |  |  | Set Headlights | 0
 |  |  |  |  |  | Road Test | 0
 |  |  |  |  |  | Clean Hopper | 0
 |  |  |  |  |  | Section 7
 |  |  |  |  |  | Remove Test Panels | 0
 |  |  |  |  |  | Check Air Conditioning System | 0
 |  |  |  |  |  | Check Brush Functions | 0
 |  |  |  |  |  | Check Fan Functions | 0
 |  |  |  |  |  | Check Water System (Repeat From Section 6) | 0
 |  |  |  |  |  | Check Windscreen Wiper Function | 0
 |  |  |  |  |  | Drain Water From System | 0
 |  |  |  |  |  | Check Safety Decals | 0
 |  |  |  |  |  | Check Hydraulic Oil Level | 0
 |  |  |  |  |  | Check Screenwash Level | 0
 |  |  |  |  |  | [NAME] | 0
 |  |  |  |  |  | Remove Test Brushes | 0
 |  |  |  |  |  | Cloudmaker Cover | 0
 |  |  |  |  |  | Replace Test Mudguards | 0
 |  |  |  |  |  | [NAME] | 0
 |  |  |  |  |  | Seal Off Air Conditioning System | 0
 |  |  |  |  |  | Inspect Central Chassis Area | 0
 |  |  |  |  |  | [NAME] | 0
 |  |  |  |  |  | Side Access Doors | 0
 |  |  |  |  |  | Side Panels Prep | 0
 |  |  |  |  |  | Side Panels Fitting | 0
 |  |  |  |  |  | [NAME] | 0
 |  |  |  |  |  | [NAME] | 0
 |  |  |  |  |  | Visual Check Under Cab Area | 0
 |  |  |  |  |  | [NAME] | 0
 |  |  |  |  |  | Brushes Prep | 0
 |  |  |  |  |  | Brushes Fitting | 0
 |  |  |  |  |  | [NAME] | 0
 |  |  |  |  |  | Steering Pipe Cover | 0
 |  |  |  |  |  | Pillar Cover | 0
 |  |  |  |  |  | Steering Wheel Cap | 0
 |  |  |  |  |  | [NAME] | 0
 |  |  |  |  |  | [NAME] | 0
 |  |  |  |  |  | Clean Vehicle | 0
 |  |  |  |  |  | Check 12V System Functions (Repeat From Section 5) | 0
 |  |  |  |  |  | Inspect PDI Sheet | 0
 |  |  |  |  |  | Snagging (Repeat From Section 6) | 0
 |  |  |  |  |  | Check Curtis Controller Cover | 1
 |  |  |  |  |  | Prep Assembly's
 |  |  |  |  |  | Brush Arm Pivots Prep | 0
 |  |  |  |  |  | Brush Arms Prep | 0
 |  |  |  |  |  | Cloudmaker Assembly | 0
 |  |  |  |  |  | Condenser Assembly | 0
 |  |  |  |  |  | Evaporator Assembly | 0
 |  |  |  |  |  | Hopper Hand Pump Lever Prep | 0
 |  |  |  |  |  | [NAME] | 0
 |  |  |  |  |  | Front Headliner Assembly | 0
 |  |  |  |  |  | [NAME] | 0
 |  |  |  |  |  | Voice Box Prep | 0
 |  |  |  |  |  | Sub Assembly's
 |  |  |  |  |  | Brush Arms Assembly | 0
 |  |  |  |  |  | LH Battery Pack Assembly | 0
 |  |  |  |  |  | RH Battery Pack Assembly | 0
 |  |  |  |  |  | Cab Assembly Part 1 | 0
 |  |  |  |  |  | Cab Assembly Part 2 | 0
 |  |  |  |  |  | Cab Assembly Part 3 | 0
 |  |  |  |  |  | Curtis Controller Box Assembly | 0
 |  |  |  |  |  | Front Axle Assembly | 0
 |  |  |  |  |  | Goalpost Assembly | 0
 |  |  |  |  |  | Hopper Assembly | 0
 |  |  |  |  |  | Mosfet Junction Box Assembly | 0
 |  |  |  |  |  | Nozzle Assembly | 0
 |  |  |  |  |  | Rear Axle Assembly | 0
 |  |  |  |  |  | Rear Water Tank Assembly | 1
 |  |  |  |  |  | Additional Notes
 |  |  |  |  |  | Battery Charger Tests | 0
 |  |  |  |  |  | Autolube System | 0