Spreadsheet: 688057d1595545162-populate-a-spread-sheet-based-on-data-that-is-structured-differently-example-workbook-updated1-3-
Sheet: Sheet4

Help/Support |  | Help/Support |  | Help/Support
Enter Corrective Action Download PDF View Images |  | Enter Corrective Action Download PDF View Images |  | Enter Corrective Action Download PDF View Images
Product has not been accepted, to handle your stock appropriately : |  | Product has not been accepted, to handle your stock appropriately : |  | FRESH PRODUCE ASSESSMENT FORM
 |  |  |  | Product:
 |  |  |  | APPLE
 |  |  |  | Vendor:
 |  |  |  | Grower:
FRESH PRODUCE ASSESSMENT FORM |  | FRESH PRODUCE ASSESSMENT FORM |  | NINE MILE FRESH PTY LTD
Product: |  | Product: |  | NINE MILE FRESH / VIC
105919-Apple Pink [NAME] |  | 105919-Apple Pink [NAME] |  | Delivery Date:
Vendor: |  | Vendor: |  | Total Ordered:
Grower: |  | Grower: |  | 2020-07-17 00:00:00
NINE MILE FRESH PTY LTD |  | NINE MILE FRESH PTY LTD |  | 72
NINE MILE FRESH VIC |  | NINE MILE FRESH VIC |  | Type / Variety:
Delivery Date: |  | Delivery Date: |  | PINK LADY
Total Ordered: |  | Total Ordered: |  | P.O. Number:
2020-07-19 00:00:00 |  | 2020-07-18 00:00:00 |  | 101490512
144 |  | 72 |  | Total Received:
Type / Variety: |  | Type / Variety: |  | 72
 |  |  |  | Class:
P.O. Number: |  | P.O. Number: |  | ONE
101490514 |  | 101489325 |  | Packed On:
Total Received: |  | Total Received: |  | Use By:
0 |  | 0 |  | 2020-07-16 00:00:00
Class: |  | Class: |  | Harvest Date:
ONE |  | ONE |  | Best Before:
Packed On: |  | Packed On: |  | Total Rejected:
Use By: |  | Use By: |  | Receival Temp:
2020-07-16 00:00:00 |  | 2020-07-16 00:00:00 |  | 0
Harvest Date: |  | Harvest Date: |  | 4.2 °C
Best Before: |  | Best Before: |  | QUALITY CRITERIA
Total Rejected: |  | Total Rejected: |  | ACTION
Receival Temp: |  | Receival Temp: |  | DEFECT
144 |  | 72 |  | [NAME]
4.9 °C |  | 9.1 °C |  | DEFECT CRITERIA
QUALITY CRITERIA |  | QUALITY CRITERIA |  | MAJOR
ACTION |  | ACTION |  | MINOR
DEFECT |  | DEFECT |  | DEFECT
[NAME] |  | [NAME] |  | [NAME]
DEFECT CRITERIA |  | DEFECT CRITERIA |  | Unit of Measurement
MAJOR |  | MAJOR |  | KG
MINOR |  | MINOR |  | Bruises
DEFECT |  | DEFECT |  | 0
[NAME] |  | [NAME] |  | 3.61
Unit of Measurement |  | Unit of Measurement |  | Minor Bruising
KG |  | KG |  | With minor superficial bruises which are distinctly darker than skin colour affecting greater than 1 sq cm but less than or equal to 2 sq cm and which have affected the underlying flesh by equal to or less than 3mm
Bruises |  | Foreign Material |  | Cuts/Splits/Mechanical damage
8.9 |  | 4.59 |  | 0
0 |  | 0 |  | 3.8
Bruising |  | Insects |  | Stem Puncture
With soft bruises affecting the underlying flesh by greater than 3mm OR which are distinctly darker than skin colour and exceed 2 sq cm of surface area |  | NIL tolerance per consignment (0%) of contamination of live/prominent insects/pests (i.e. [NAME], grubs, slugs/snails, beetles, spiders etc). |  | Shallow stem punctures penetrating fruit flesh greater than 1mm
Cuts/Splits/Mechanical damage |  | No. Products With Defects |  | No. Products With Defects
0 |  | Total Units Assessed |  | Total Units Assessed
4.2 |  | 4.6 |  | 0
Stem Puncture |  | 0 |  | 7.4
Shallow stem punctures penetrating fruit flesh greater than 1mm |  | 72 |  | 72
No. Products With Defects |  | No Cartons used for Assessment |  | No Cartons used for Assessment
Total Units Assessed |  | 3 |  | 3
8.9 |  | Total % Out of Spec |  | Total % Out of Spec
4.2 |  | 0.063 |  | 0
72 |  | 0 |  | 0.102
No Cartons used for Assessment |  | Quantity Rejected |  | Quantity Rejected
6 |  | 72 |  | 0
Total % Out of Spec |  | Use X to Designate |  | Use X to Designate
0.123 |  | Accept |  | Accept
0.058 |  | Reject |  | X
Quantity Rejected |  | X |  | Reject
144 |  | Digital Image |  | Digital Image
Use X to Designate |  | Yes |  | Yes
Accept |  | X |  | X
Reject |  | No |  | No
X |  | Comments: |  | Comments:
Digital Image |  | ASSESSED BY |  | ASSESSED BY
Yes |  | [NAME] 1946 |  | [NAME] 1986
X |  | ASSESSMENT DATE |  | ASSESSMENT DATE
No |  | 2020-07-18 00:00:00 |  | 2020-07-17 00:00:00
Comments: |  | QCRF 006 |  | QCRF 006
ASSESSED BY
[NAME] 1986
ASSESSMENT DATE
2020-07-19 00:00:00
QCRF 006