Spreadsheet: 26269d1218251518-gathering-and-listing-data-from-another-sheet-master-file
Sheet: CLIP

Daily Record Summary |  |  |  |  |  |  |  |  |  |  |  |  | Daily Operational Summary |  |  |  | CLIP Summary |  |  |  |  |  |  |  | PH206 Silver Fern Farms, [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PH366 Silver Fern Farms, Islington |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ME69 Alliance Group, Sockburn |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PF161 Whakatu Processing, [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Supply Date | Docket No | ED No | [NAME] | Gut (kgs) | M&B (kgs) | Blood (kgs) | H/O? | [NAME]/O | Gut H/O | M&B H/O | Blood H/O | Process Date |  |  | Supply Date | Docket No | ED No | [NAME] | Gut (kgs) | M&B (kgs) | Blood (kgs) | H/O? | [NAME]/O | Gut H/O | M&B H/O | Blood H/O | Process Date |  |  | Supply Date | Docket No | ED No | [NAME] | Gut (kgs) | M&B (kgs) | Blood (kgs) | H/O? | [NAME]/O | Gut H/O | M&B H/O | Blood H/O | Process Date |  |  | Supply Date | Docket No | ED No | [NAME] | Gut (kgs) | M&B (kgs) | Blood (kgs) | H/O? | [NAME]/O | Gut H/O | M&B H/O | Blood H/O | Process Date |  |  | ED Numbers
 | CLIP  Nº |  |  |  |  |  |  |  |  |  | 1001 |  |  | Total Gut (emptied) | 3620.2 |  |  | CLIP  Nº |  |  | 1001
 | Date |  |  |  |  |  |  |  |  |  | 2008-07-08 00:00:00 |  |  | Total Meat & Bone | 3995 |  |  | Date |  |  | 2008-07-08 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ü |  |  |  |  |  |  |  |  |  | Yes |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yes |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yes |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yes
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | Total Blood | 1550 |  |  | [NAME] |  |  | 0 |  |  |  | 2008-07-07 00:00:00 | 178163 | 416 | 22 | 207 |  | 650 |  |  |  |  |  |  |  |  | 2008-07-07 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2008-07-07 00:00:00 | 138537 | 239929 | 91 | 782 |  |  |  |  |  |  |  |  |  |  | 2008-07-07 00:00:00 | 272764 | 380 | 50 |  | 899 |  | Yes | 50 | 0 | 899 | 0 | 2008-07-10 00:00:00 |  |  | PH206 / 416
 | Production Week |  |  |  |  |  |  |  |  |  | 1 |  |  | Blood / Offal ratio | 0.2035402878453619 |  |  | Production Week |  |  | 1 |  |  |  |  |  |  | 9 | 786 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 415 |  |  |  |  |  |  |  |  |  |  |  |  |  | 103 |  | 1055 |  | Yes | 103 | 0 | 1055 | 0 | 2008-07-12 00:00:00
 | Offal brought forward |  |  |  |  |  |  |  |  |  | 0 |  |  | Gut / M&B ratio | 0.9061827284105132 |  |  | Meal Production |  |  | 0 |  |  |  |  |  |  | 6 | 630 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29 |  | 1255 |  |  |  |  |  |  |  |  |  |  |  |  | 31 |  | 1236 |  | Yes | 31 | 0 | 1236 | 0 | 2008-07-17 00:00:00
 | [NAME] received |  |  |  |  |  |  |  |  |  | 14102 |  |  | Desired MDM % |  |  |  | Tallow Production |  |  | 0 |  |  |  |  |  |  | 19 | 718 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 900 |  |  |  |  |  |  |  |  |  |  |  | 54 |  | 1239 |  | Yes | 54 | 0 | 1239 | 0 | 2008-07-11 00:00:00 |  |  | ME69 / 239929
 | Blood received |  |  |  |  |  |  |  |  |  | 1550 |  |  | Calculated MDM weight | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 688 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 34 |  | 252 |  | Yes | 34 | 0 | 252 | 0 | 2008-07-23 00:00:00
 | Offal on hand |  |  |  |  |  |  |  |  |  | 15652 |  |  | Resulting Ash % |  |  |  | Offal Received |  |  |  |  |  |  |  |  |  | 24 |  | 984 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 44 |  | 1200 |  | Yes | 44 | 0 | 1200 | 0 | 2008-07-19 00:00:00 |  |  | PF161 / 380
 | Offal processed |  |  |  |  |  |  |  |  |  | 9771 |  |  | Weekly Operational Summary |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 |  | 1052
 | Offal held over |  |  |  |  |  |  |  |  |  | 5881 |  |  |  |  |  |  | Supplier Nos | Docket Nos | ED Nos | Offal (kgs) | Blood (kgs) |  |  |  |  |  | 15 |  | 704
 | Season's Total [NAME] |  |  |  |  |  |  |  |  |  | 1550
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | Daily Meal Production |  |  |  |  |  |  |  |  |  |  |  |  | Meal Production |  |  |  | PH206 | 178163 | 416 | 5769 | 650
 | Ash % |  |  |  |  |  |  |  |  |  | 0 |  |  | Tallow Production |  |  |  | PH366 | 0 | 0 | 0 | 0
 | Season's Meal Production |  |  |  |  |  |  |  |  |  | 0 |  |  | Rendering % | #N/A |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Cooker Hours |  |  |  | ME69 | 138537 | 239929 | 2452 | 900
 | Daily Tallow Production |  |  |  |  |  |  |  |  |  |  |  |  | Season's Cooker Hours | 0 |  |  |  | 0 | 0 | 0 | 0 |  |  | Night Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Night Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Night Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Night Shift
 | FFA |  |  |  |  |  |  |  |  |  |  |  |  | Offal Throughput / hr | #N/A |  |  | PF161 | 272764 | 380 | 5881 | 0
 | [NAME] 4 |  |  |  |  |  |  |  |  |  | 0 |  |  | Hammer Mill Hours
 | Load In |  |  |  |  |  |  |  |  |  |  |  |  | Season's Hammer Mill Hours | 0
 | Load Out |  |  |  |  |  |  |  |  |  |  |  |  | Meal Throughput / hr | #N/A
 | [NAME] |  |  |  |  |  |  |  |  |  | 2300 |  |  | Oil used
 | Load In |  |  |  |  |  |  |  |  |  |  |  |  | Season's Oil Usage | 0
 | Load Out |  |  |  |  |  |  |  |  |  |  |  |  | Oil used / tonne meal | #N/A
 | Season's [NAME] |  |  |  |  |  |  |  |  |  | 0 |  |  | Power Units used |  |  |  | ED's checked |  |  |  | ü
 | Load In |  |  |  |  |  |  |  |  |  |  |  |  | Season's Power Usage | 0 |  |  | CLIP form emailed to main office |  |  |  | ü |  |  | 2008-07-07 00:00:00 | 178163 | 416 | 8 | 3029 | 2740 | 650 |  |  | 0 | 0 | 0 |  |  |  | 2008-07-07 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 |  |  |  | 2008-07-07 00:00:00 | 138537 | 239929 | 3 | 1197 | 1255 | 900 |  |  | 0 | 0 | 0 |  |  |  | 2008-07-07 00:00:00 | 272764 | 380 | 6 | 0 | 5881 | 0 |  |  | 0 | 5881 | 0
 | Season's Tallow Production |  |  |  |  |  |  |  |  |  | 0 |  |  | Power Units used / tonne meal | #N/A |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0