Spreadsheet: 79668d1279881808-getting-counts-from-columns-for-each-row-sample
Sheet: Sheet1

 |  | Printer Number |  |  |  | 2010-07-22 00:00:00 |  |  |  |  |  |  |  | 2010-07-21 00:00:00 |  |  |  |  |  |  |  | 2010-07-20 00:00:00 |  |  |  |  |  |  |  | 2010-07-19 00:00:00 |  |  |  |  |  |  |  | 2010-07-16 00:00:00 |  |  |  |  |  |  |  | 2010-07-15 00:00:00 |  |  |  |  |  |  |  | 2010-07-14 00:00:00 |  |  |  |  |  |  |  | 2010-07-13 00:00:00 |  |  |  |  |  |  |  | 2010-07-12 00:00:00 |  |  |  |  |  |  |  | 2010-07-09 00:00:00 |  |  |  |  |  |  |  | 2010-07-05 00:00:00 |  |  |  |  |  |  |  | 2010-07-02 00:00:00 |  |  |  |  |  |  |  | 2010-07-01 00:00:00
Customer | Serial Number |  | Model | IP Address | TJ | Off | Jam | SR | Door | TxKit | Drum | Maint | Fuser | Off | Jam | SR | Door | TxKit | Drum | Maint | Fuser | Off | Jam | SR | Door | TxKit | Drum | Maint | Fuser | Off | Jam | SR | Door | TxKit | Drum | Maint | Fuser | Off | Jam | SR | Door | TxKit | Drum | Maint | Fuser | Off | Jam | SR | Door | TxKit | Drum | Maint | Fuser | Off | Jam | SR | Door | TxKit | Drum | Maint | Fuser | Off | Jam | SR | Door | TxKit | Drum | Maint | Fuser | Off | Jam | SR | Door | TxKit | Drum | Maint | Fuser | Off | Jam | SR | Door | TxKit | Drum | Maint | Fuser | Off | Jam | SR | Door | TxKit | Drum | Maint | Fuser | Off | Jam | SR | Door | TxKit | Drum | Maint | Fuser | Off | Jam | SR | Door | TxKit | Drum | Maint | Fuser
xxxxxxx | L7873500331 |  | [NAME] | 10.10.6.49 |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
xxxxxxx | V1403900023 |  | Ricoh MPC2800 | 10.10.6.50 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
xxxxxxx | [NAME] |  | [NAME] | 10.10.6.80 |  | 5 |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
xxxxxxx | CNHXN35252 |  | LaserJet 4250 | 10.10.6.103
xxxxxxx | CNCHB94907 |  | LaserJet 2300 series | 10.10.6.106
xxxxxxx | CNCFF97355 |  | LaserJet 2300 series | 10.10.6.138 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
xxxxxxx | [NAME] |  | MP 161 | 10.10.6.144 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
xxxxxxx | V1594500081 |  | [NAME] | 10.10.6.160 |  | 3 |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  | 3 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
xxxxxxx | M5593300027 |  | Ricoh MP4000 | 10.10.6.170 |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
xxxxxxx | CNHXN43491 |  | LaserJet 4250 | 10.10.7.17
xxxxxxx | 79284BL |  | Laser Printer 5210n | 10.10.7.29
xxxxxxx | M5793000063 |  | Ricoh MP5000 | 10.10.7.80 |  | 1 |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  | 1 |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | 1
xxxxxxx | V1494202165 |  | MP C2800 | 10.10.7.90 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
xxxxxxx | V1494202191 |  | MP C2800 | 10.10.7.91 |  | 2 | 4 |  |  |  |  |  |  |  | 2 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  | 2 | 1 |  | 1 |  |  |  |  | 2 |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | 3 |  |  |  |  |  |  |  |  | 1
xxxxxxx | V1494200211 |  | MP C2800 | 10.10.7.92 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1