{"text_format":"1","workbook":"xlsx","n_sheets":24,"sheets":["ORGANIZATION INFORMATION","Validation","SITE INFORMATION","BRCGS Packaging Audit","App.Review Packaging","SCOPE OF AUDIT (FOOD)","BRCGS Food Audit","IFS Food Audit","IFS Broker","BRCGS A&B","BRCGS S&D","Appl. Review Food","Revisions","BRCGS Consumer Products","App.Review Consumer","IFS LOGISTICS","Glutten-Free ","Plant-Based Global Standard","IFS ESG Check","Appl. Review Broker","Appl. Review Logistics","Appl. Review GFCP standalone","Review Plant-Based standalone","Review IFS ESG Check"],"not_rendered":{"charts":0,"images":11,"macros":1,"external_links":0,"defined_names":23,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"ORGANIZATION INFORMATION","index":0,"n_rows":47,"n_cols":26,"rows_kept":47,"cut":false,"hidden":false,"merged":[[42,0,42,3],[46,0,46,3],[15,0,15,2],[28,0,28,3],[25,0,25,3],[17,0,17,2],[47,0,47,3],[0,0,0,3],[39,0,39,3],[40,0,40,3],[41,0,41,3],[18,1,18,3],[10,0,10,3],[1,0,1,3],[2,1,2,3],[26,0,26,3],[33,0,33,3],[38,0,38,3],[43,0,43,3],[3,1,3,3],[19,1,19,3],[24,0,24,1],[24,2,24,3],[16,0,16,2],[14,0,14,2],[13,0,13,3],[37,0,37,3],[30,0,30,3],[29,0,29,3],[32,0,32,3],[31,0,31,3]]}
["BRCGS / IFS APPLICATION FORM \n(for all Standards)",null,null,null,{"$f":"IF(Validation!B16<>0,\"You need to fill the form!\",\"Validation Complete!\")","v":"You need to fill the form!"}]
["COMPANY DETAILS – SITE TO BE AUDITED",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes",null,null,null,null,null,null," Ready for Review"]
["Company Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No","X",null,null,null,null,null,"No"]
["Address"]
["Legal Form",null,"Postcode"]
["City",null,"Region/ Country "]
["Phone Number ",null,"VAT Identification Number"]
["E-mail Address",null,"Website Address"]
["Global Location Number (GLN) - GS1 ",null,"GPS data: Latitude "]
["Consultant",null,"GPS data: Longitude "]
["SUPERUSER TO THE IFS DATABASE and/or BRCGS DIRECTORY"]
["Full Name",null,"Position"]
["Phone Number ",null,"Login E-mail"]
[]
["Is there any additional manufacturing and/or storage location owned and managed by the company? (e.g., Off-site storage facilities, additional manufacturing/ processing establishment, etc)",null,null,"No"]
["Please provide the address, size and processes"]
["Please provide the distance (km) from the audited site, that considered as main."]
["Is the company managed by a Head Office? Please complete only if the Head Office has different address from the audited site.",null,null,"No"]
["Head Office Name "]
["Address"]
["City",null,"Postcode"]
["Phone Number ",null,"Region/ Country"]
["E-mail Address (must be different from the login email)",null,"Website Address"]
["Contact Person (must be different person from the login user)",null,"Position"]
["Are there departments that belong to the head office? \nif yes please indicate. (e.g., Sales, supplies, top management)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Please select a Standard"]
["STANDARD(s) TO BE AUDITED",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BRCGS Food"]
["Please select a Standard","Please select a Standard","Please select a Standard","Please select a Standard",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IFS Food"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IFS Logistics","Please select Audit Type","Please select Audit Option"]
["Audit Type",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IFS Broker","Certification","Announced Audit Option"]
["Please select Audit Type",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BRCGS Storage and Distribution","Recertification","BRGCS Blended Audit Option"]
["Audit Option",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BRCGS Agents and Brokers",null,"Scope extension"]
["Please select Audit Option",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gluten-Free Certification Program",null,"Unannounced Voluntary Audit Option"]
["THE MAIN COMMUNICATION AND DOCUMENTATION LANGUAGE OF THE MANAGEMENT SYSTEM IS IN:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Plant-Based Global Standard",null,"Unannounced – mandatory 1 in 3 years (GFSI rule)"]
[null,"English","Greek","Other Language",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IFS ESG Check"]
["Communication Language",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BRCGS Packaging"]
["Documenattion Language",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BRCGS Consumer"]
["IN ADDITION TO THE INFORMATION REQUESTED IN THIS FORM, PLEASE SUBMIT THE FOLLOWING"]
["1. a site plan\n2. organization chart\n3. a summary of the site’s critical control points (CCPs) and the process flow diagrams\n4. description of any special handling requirements (e.g., allergens)\n5. description of the site and building fabrications\n6. any recent quality issues or customer complaints",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Remote Audit "]
["DECLARATION"]
["By signing this Application, we consent and/or agree to the following that applies to both BRCGS and IFS Schemes:\n  • A copy of the audit report and any subsequent certificate or audit result shall be supplied to the Scheme Owner and may be supplied to the accreditation body in the agreed format for the standard used. \n  • As per GFSI-benchmarked standards, records may be viewed in conjunction with any GFSI compliance audit.\n  • Other documents in relation to the audit shall be made available to the Scheme Owners upon request (all provided documents shall be treated as confidential).\n  • Scheme Owners may make audit reports and certificates available to customers of sites or the authorities for earned recognition purposes. \n  • The auditor (s) may be accompanied by other personnel for training, assessment, or calibration purposes. This activity may include:\n    - Training of new auditors by Q-CERT.\n    - Routine Q-CERT’s shadow audit programs.\n    - Witness audits by the accreditation body (ACCREDIA).\n    - Witness audits by the Scheme Owners.\n  • Scheme Owners reserve the right to conduct their own audit or visit a site once certificated in response to complaints or as part of routine compliance activity to ensure the integrity of the scheme (such visits may be announced or unannounced).\n  • Scheme Owners may contact the site directly in relation to its certification status, for feedback on certification body performance, or for an investigation into reported issues.\n  • For the audit dates of the announced scheme proposed and/or agreed between the site and Q-CERT, there will be production ensured with a product with the most complicated production technologies in place during the audit. It is the responsibility of the auditee to inform Q-CERT in case production is not feasible for the planned audit dates"]
["PERSONAL DATA PROTECTION "]
["By signing this Application, Customer is committed to having acquired consent from the subjects of any personal data to be used in the context of the control/certification service (including sending the offer, signing the contract, audit planning / conducting, and alerts)"]
["Optionally, by ticking the following checkbox, the Customer is committed to having acquired consent from the subjects of any personal data to be used: ☐ For receiving on behalf of the Customer any marketing emails regarding new services and certifications"]
["Representative  Name:",null,"Job Title:"]
["Sign Here:",null,"Date:"]
["Guidelines / Notes:\n- This form should be filled in and sent via email to sales@qmscert.com \n- Submitting accurate and complete information facilitates and thus accelerates the delivery of our quotation\n- In case of a Transfer from another Certification Body, please contact our offices, at +30 2310 443041, +30 2310 535765\n- You may find additional information regarding the Certification Procedures and Audit Information & Expectations on our website: www.qmscert.com\nQ-CERT will process all personal data that it collects during the audit in accordance with the relevant laws/regulations for the above purposes. In particular, it will maintain a record that is available to the customer, with a duration as defined by the relevant legislation/regulation. At the end of the scheduled duration of the record, is committed to destroying it in accordance with the applicable provisions. Subjects retain their right to withdraw their consent at any time, by sending a request to privacy@qmscert.com. Additional information on Personal Data Protection is available on the website www.qmscert.com"]

{"sheet":"Validation","index":1,"n_rows":16,"n_cols":2,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
["ORGANIZATION INFORMATION"]
[{"$f":"IF('ORGANIZATION INFORMATION'!B3<>\"\",'ORGANIZATION INFORMATION'!B3,\"\")","v":""},{"$f":"IF(A2=\"\",1,0)","v":1}]
[{"$f":"IF('ORGANIZATION INFORMATION'!B4<>\"\",'ORGANIZATION INFORMATION'!B4,\"\")","v":""},{"$f":"IF(A3=\"\",1,0)","v":1}]
[{"$f":"IF('ORGANIZATION INFORMATION'!B5<>\"\",'ORGANIZATION INFORMATION'!B5,\"\")","v":""},1]
[{"$f":"IF('ORGANIZATION INFORMATION'!B6<>\"\",'ORGANIZATION INFORMATION'!B6,\"\")","v":""},1]
[{"$f":"IF('ORGANIZATION INFORMATION'!D6<>\"\",'ORGANIZATION INFORMATION'!D6,\"\")","v":""},1]
[{"$f":"IF('ORGANIZATION INFORMATION'!B7<>\"\",'ORGANIZATION INFORMATION'!B7,\"\")","v":""},1]
[{"$f":"IF('ORGANIZATION INFORMATION'!D7<>\"\",'ORGANIZATION INFORMATION'!D7,\"\")","v":""},1]
[{"$f":"IF('ORGANIZATION INFORMATION'!B8<>\"\",'ORGANIZATION INFORMATION'!B8,\"\")","v":""},1]
[{"$f":"IF('ORGANIZATION INFORMATION'!D9<>\"\",'ORGANIZATION INFORMATION'!D9,\"\")","v":""},1]
[{"$f":"IF('ORGANIZATION INFORMATION'!D10<>\"\",'ORGANIZATION INFORMATION'!D10,\"\")","v":""},1]
[{"$f":"IF('ORGANIZATION INFORMATION'!B12<>\"\",'ORGANIZATION INFORMATION'!B12,\"\")","v":""},1]
[{"$f":"IF('ORGANIZATION INFORMATION'!D12<>\"\",'ORGANIZATION INFORMATION'!D12,\"\")","v":""},1]
[{"$f":"IF('ORGANIZATION INFORMATION'!B13<>\"\",'ORGANIZATION INFORMATION'!B13,\"\")","v":""},1]
[{"$f":"IF('ORGANIZATION INFORMATION'!D13<>\"\",'ORGANIZATION INFORMATION'!D13,\"\")","v":""},1]
[null,{"$f":"SUM(B2:B15)","v":14}]

{"sheet":"SITE INFORMATION","index":2,"n_rows":29,"n_cols":16,"rows_kept":29,"cut":false,"hidden":false,"merged":[[21,10,22,10],[21,6,22,6],[21,5,22,5],[21,7,21,8],[21,9,22,9],[13,3,13,5],[15,3,15,5],[16,3,16,5],[0,3,0,5],[1,3,1,5],[2,3,2,5],[3,4,3,5],[4,4,4,5],[5,3,5,5],[6,3,6,5],[7,3,7,5],[8,3,8,5],[9,3,9,5],[10,3,10,5],[11,3,11,5],[12,3,12,5],[17,3,17,5],[19,3,19,5],[14,0,14,2],[15,0,15,2],[16,0,16,2],[17,0,17,2],[18,0,18,2],[19,0,19,2],[18,3,18,5],[11,0,11,2],[12,0,12,2],[13,0,13,2],[6,0,6,2],[7,0,7,2],[8,0,8,2],[9,0,9,2],[10,0,10,2],[0,0,0,2],[5,0,5,2],[1,0,1,2],[2,0,2,2],[3,0,3,2],[4,0,4,2],[20,0,20,5],[26,0,26,5],[27,3,27,5],[28,3,28,5],[21,1,22,1],[21,2,21,3],[21,4,22,4],[21,0,22,0],[27,0,27,2],[28,0,28,2]]}
["Details of any significant changes since your last BRCGS/ IFS audit. e.g. a new service, changes of key personnel; new technologies; extension or reduction in the product range",null,null,"Please select",null,null,null,null,null,null,null,null,null,null,null,"Please select"]
["Describe the significant changes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
["Are there any Recalls, Withdrawals, Incidents, penalties - notifications from Authorities since your last Audit?",null,null,"Please select",null,null,null,null,null,null,null,null,null,null,null,"No"]
["Reason",null,null," Product","Recall Date"]
[]
["Are there processes outsourced to Subcontractors? ",null,null,"Please select"]
["Describe the processes"]
["Are other Standards implemented/Certified? ",null,null,"Please select"]
["Which standard?"]
["Is your Management System Integrated?",null,null,"Please select"]
["Are you certified by another CB for the standard(s) BRCGS/ IFS? \nPlease attach to this Application Report(s) and Certificate(s)",null,null,"Please select"]
["Certification Body: "]
["Auditor: "]
["Re-audit due date: "]
[]
["Applicable Legal Requirements and/or Relevant Standards, Licence number"]
["Packaging types – please list all types used (glass bottles/ flow-wrap/ MAP/ bag in box/ other)",null,null,"Please select"]
["Describe the packaging"]
["Exporting Countries"]
["List any retail brands you supply\n(For example ASDA, Tesco, Lidl…)"]
[]
["Site Address\n(only sites which are part of the Certification)","Shift Patterns Operating Hours\n(start & finish times)","Size of the manufacturing facility ",null,"Total Production and Storage \n(in square meters)","Construction/ Renovation Year"]
[null,null,"Production \n(in square meters)","Storage \n(in square meters)"]
[{"$f":"IF('ORGANIZATION INFORMATION'!B4<>\"\",'ORGANIZATION INFORMATION'!B4,\"\")","v":""},null,null,null,{"$f":"SUM(C24:D24)","v":0}]
[null,null,null,null,{"$f":"SUM(C25:D25)","v":0}]
[null,null,null,null,0]
[]
["Total number of employees \nincluding management, seasonal workers (in the peak season)"]
["Maximum number of employees operating in the main shift \nmanagement, production, including seasonal workers"]

{"sheet":"BRCGS Packaging Audit","index":3,"n_rows":48,"n_cols":16,"rows_kept":48,"cut":false,"hidden":true,"merged":[[38,0,38,1],[39,0,39,1],[4,1,4,2],[5,1,5,2],[6,1,6,2],[11,1,11,2],[12,1,12,2],[18,1,18,2],[17,1,17,2],[31,0,31,1],[8,1,8,2],[7,1,7,2],[19,1,19,2],[21,0,21,1],[1,1,1,2],[0,1,0,2],[15,1,15,2],[16,1,16,2],[3,1,3,2],[9,1,9,2],[13,1,13,2],[14,1,14,2],[2,1,2,2]]}
["BRCGS Site Code","Please select",null,null,null,null,null,null,null,null,"Please select",null,null,null,"Start Month","End Month"]
["Please type the BRCGS Site Code",null,null,null,null,null,null,null,null,null,"Yes",null,null,null,"January","January"]
["Please type the Company ID",null,null,null,null,null,null,null,null,null,"No",null,null,null,"February","February"]
["Scope of certification",null,null,null,null,null,null,null,null,null,null,null,null,null,"March","March"]
["Justify if there are products excluded from the Certification scope \n(under exceptional circumstances, please Justify) ","Please select",null,null,null,null,null,null,null,null,null,null,null,null,"April","April"]
["Please describe the exclusions",null,null,null,null,null,null,null,null,null,null,null,null,null,"May","May"]
["Number of HARA studies  \n(hazard analysis & risk assessment)",null,null,null,null,null,null,null,null,null,null,null,null,null,"June","June"]
["Are there Traded products handled by the site included in the certification?\n(Traded Products: Goods that are purchased and sold without any alteration/process)","Please select",null,null,null," ",null,null,null,null,null,null,null,null,"July","July"]
["Please describe the Traded Products",null,null,null,null,null,null,null,null,null,"X",null,null,null,"August","August"]
["Is the site classified as a Seasonal Site? ","Please select",null,null,null,null,null,null,null,null,null,null,null,null,"September","September"]
["Please indicate how many months the site operates per year/ \nSeasonal opening times (start/end date)","Start Month","End Month",null,null,null,null,null,null,null,null,null,null,null,"October","October"]
["Are you handling Seasonal Products? ","Please select",null,null,null,null,null,null,null,null,null,null,null,null,"November","November"]
["Indicate the Season/ start and finish dates per product",null,null,null,null,null,null,null,null,null,null,null,null,null,"December","December"]
["Exporting countries "]
["Exporting Retailers "]
["Are Additional Modules included in the certification? ","Please select"]
["Module 8 - Environmental Awareness"]
["Module 10 - Plastic pellets loss prevention"]
["Module 11 - Meeting HAVI GQS Requirements"]
["Ethical Trade & Responsible Sourcing (ETRS) Risk Assessment"]
[]
["Please Select Manufacturing Categories "]
["01 - Glass manufacture and forming"]
["02 - Papermaking and conversion"]
["03 - Metal forming"]
["04 - Rigid plastics forming"]
["05 - Flexible plastics manufacture"]
["06 - Other manufacturing",null," "]
["07 - Print processes"]
["08 - Chemical processes"]
[]
["PLEASE SELECT PROCESSES CARRIED OUT ON SITE"]
["Injection Moulding"]
["Blow Moulding"]
["Conversion of board"]
["Printing "]
["Other"]
[]
["Applicable for the Unannounced Audit Option"]
["Are there Blackout dates?\nA maximum of 10 operational days when the site is not available for the audit. \nThe blackout dates shall be notified to Q-CERT at the latest 4 weeks before the start of the unannounced audit window and cannot be changed at a later stage.\nNot applicable for seasonal sites and does not include non-operating periods (e.g. Easter and Christmas Holidays)."]
["Start Date","End Date"]
[]
["Reason (for example due to customer visit)"]
["Site entrance requirements"]
["List of contacts when first arriving on site"]
["Specific protective clothing arrangements"]
[null," "]
[null," "]

{"sheet":"App.Review Packaging","index":4,"n_rows":25,"n_cols":25,"rows_kept":25,"cut":false,"hidden":true,"merged":[[24,1,24,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[8,1,8,2],[9,1,9,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[0,0,0,2],[0,6,1,7],[0,8,1,8],[1,0,1,2],[2,1,2,2],[2,6,7,7],[2,8,7,8],[4,1,4,2],[5,1,5,2],[6,1,6,2],[6,4,7,4],[6,5,7,5],[7,1,7,2],[3,1,3,2]]}
["Application Review for BRCGS PACKAGING MATERIALS - Q-CERT USE ONLY\nThe typical duration of a BRCGS Packaging audit is 2 days.\n(Typical audit day is 8 hours, with a maximum of 9 hours in exceptional circumstances)\nAt a typical audit, 30-50% of the total audit duration, e.g. minimum of 4 hours of a 1.5-day audit should be spent within the manufacturing environment.",null,null,null,"Previous BRCGS audits","Auditor (BRCGS)","Is there any need for a concession from the scheme owner for the audit team, e.g. use of a technical expert, 4th consecutive audit for the same auditor?",null,"No",null,null,null,null,null,null,null,null,null,null,null,null,"Manufacturing Categories","Other Processes",null,"Yes"]
["BRCGS Packaging Materials audit duration ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS Packaging Audit'!B23=\"X\",'BRCGS Packaging Audit'!A23,\"\")","v":""},{"$f":"IF('BRCGS Packaging Audit'!B33=\"X\",'BRCGS Packaging Audit'!A33,\"\")","v":""},null,"No"]
["BRCGS Manufacturing Categories ",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,V2:V9)","v":""},null,null,null,null," If ‘’Yes’’, confirmation of concession is required, including date of concession granted before auditor allocation. No auditor allocation is possible without a positive concession from the scheme owner. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS Packaging Audit'!B24=\"X\",'BRCGS Packaging Audit'!A24,\"\")","v":""},{"$f":"IF('BRCGS Packaging Audit'!B34=\"X\",'BRCGS Packaging Audit'!A34,\"\")","v":""}]
["Other Processes carried out on site",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,W2:W9)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS Packaging Audit'!B25=\"X\",'BRCGS Packaging Audit'!A25,\"\")","v":""},{"$f":"IF('BRCGS Packaging Audit'!B35=\"X\",'BRCGS Packaging Audit'!A35,\"\")","v":""}]
["Number of HARA plans \n(corresponds to a family of products with similar hazards and similar manufacturing technology)",{"$f":"IF('BRCGS Packaging Audit'!B7<>\"\",'BRCGS Packaging Audit'!B7,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS Packaging Audit'!B26=\"X\",'BRCGS Packaging Audit'!A26,\"\")","v":""},{"$f":"IF('BRCGS Packaging Audit'!B36=\"X\",'BRCGS Packaging Audit'!A36,\"\")","v":""}]
["Size of the manufacturing facility - \nbuildings, AND any external covered or uncovered storage areas. (in square metres)",{"$f":"SUM('SITE INFORMATION'!E24:E26)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS Packaging Audit'!B27=\"X\",'BRCGS Packaging Audit'!A27,\"\")","v":""},{"$f":"IF('BRCGS Packaging Audit'!B37<>\"\",'BRCGS Packaging Audit'!B37,\"\")","v":""}]
["Maximum number of employees operating in main shift \n(management, production, including seasonal workers)",{"$f":"'SITE INFORMATION'!D29","v":0},null,null,"Proposed Auditor(s) for this year's audit ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS Packaging Audit'!B28=\"X\",'BRCGS Packaging Audit'!A28,\"\")","v":""}]
["MINIMUM AUDIT DURATION BRCGS:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS Packaging Audit'!B29=\"X\",'BRCGS Packaging Audit'!A29,\"\")","v":""}]
["Justification for deviation (no more than 30%) e.g., 1) decrease: Where less than 50% of the total manufacturing and storage facility site size is utilised as manufacturing, the audit duration may be reduced by 30%,\nThe site carries out one simple process, such as the slitting and rewinding of films, \nA separate audit of the central system (head office audit) completed before the manufacturing site audit typically takes a reduction of 2 hours depending on what activities the head office undertakes, \n2) increase: Initial audit, Complexity of the manufacturing process, Number of product lines, Size and age of the site and impact on material flow, Labour-intensity of processes, Communication difficulties, Number of non-conformities recorded in the previous audit, Difficulties experienced during the audit requiring further investigation, The quality of company preparation, Additional storage facilities, locations or head office assessments included within the audit process ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS Packaging Audit'!B30=\"X\",'BRCGS Packaging Audit'!A30,\"\")","v":""}]
["AMENDED AUDIT DURATION for BRCGS:"]
["Combined factor for audit team (2 hours)",null,null," "]
["Translator Presence + 20% minimum "]
["Section 7 (Traded Product) (≥1 hour)",{"$f":"IF('BRCGS Packaging Audit'!B8=\"Yes\",\"X\",\"\")","v":""}]
["Module 8 - Environmental Awareness (4 - 8 hours (0.5 – 1.0 day)",{"$f":"IF('BRCGS Packaging Audit'!B17=\"Yes\",\"X\",\"\")","v":""}]
["Module 10 - Plastic pellets loss prevention (2 -4 hours (0.25 – 0.5 day)",{"$f":"IF('BRCGS Packaging Audit'!B18=\"Yes\",\"X\",\"\")","v":""}]
["Module 11 - Meeting HAVI GQS Requirements (2 -4 hours (0.25 – 0.5 day)",{"$f":"IF('BRCGS Packaging Audit'!B19=\"Yes\",\"X\",\"\")","v":""}]
["Ethical Trade & Responsible Sourcing (ETRS) Risk Assessment (4 hours (0.5 day)",{"$f":"IF('BRCGS Packaging Audit'!B20=\"Yes\",\"X\",\"\")","v":""}]
["Additional time for any other reason (please descripe..)"]
["TOTAL TIME DURATION (BRCGS/IFS):"]
["Preparation Time (BRCGS 1-2 hrs) "]
["Report Time BRCGS (4 - 8 hrs)"]
["Travel Time Round trip"]
["Total Hours (BRCGS)",{"$f":"SUM(C19:C22)","v":0}]
["Reviewed By","LDK/AK"]
["Reviewed Date"]

{"sheet":"SCOPE OF AUDIT (FOOD)","index":5,"n_rows":13,"n_cols":16,"rows_kept":13,"cut":false,"hidden":true,"merged":[[8,1,8,2],[9,1,9,2],[7,1,7,2],[3,1,3,2],[0,1,0,2],[1,1,1,2],[2,1,2,2],[6,1,6,2],[4,1,4,2]]}
["Scope \n(Products produced and manufacturing processes and all packaging types used (glass bottles/ flow-wrap/ MAP/ bag in box/ other).",null,null,null,null,null,null,null,null,null,null,null,null,"Please select","Start Month","End Month"]
["Please indicate the days of the week on which the production activities take place",null,null,null,null,null,null,null,null,null,null,null,null,"Yes","January","January"]
["Please indicate if there are any products and/or processes operating in specific days and times",null,null,null,null,null,null,null,null,null,null,null,null,"No","February","February"]
["Please indicate the production period/time in which the most complicated production technologies take place",null,null,null,null,null,null,null,null,null,null,null,null,null,"March","March"]
["Is the site classified as a Seasonal Site? ","Please select",null,null,null,null,null,null,null,null,null,null,null,null,"April","April"]
["Please indicate how many months the site operates per year/ \nSeasonal opening times (start/end date)","Start Month","End Month",null,null,null,null,null,null,null,null,null,null,null,"May","May"]
["Number of HACCP Studies \n(categories in case of similar HACCP plans)",null,null,null,null,null,null,null,null,null,null,null,null,null,"June","June"]
["Number of Production Lines",null,null,null,null,null,null,null,null,null,null,null,null,null,"July","July"]
["Number of Packaging Lines",null,null,null,null,null,null,null,null,null,null,null,null,null,"August","August"]
["Are you handling Seasonal Products? ","Please select",null,null,null,null,null,null,null,null,null,null,null,null,"September","September"]
["Product","Process"," Season/ Start and finish dates",null,null,null,null,null,null,null,null,null,null,null,"October","October"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"November","November"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"December","December"]

{"sheet":"BRCGS Food Audit","index":6,"n_rows":47,"n_cols":11,"rows_kept":47,"cut":false,"hidden":true,"merged":[[5,2,8,2],[38,0,38,1],[14,0,14,1],[16,0,16,1],[37,0,37,1]]}
["BRCGS Site Code","Please select",null,null,null,null,null,null,null,null,"Please select"]
["Please type the BRCGS Site Code",null,null,null,null,null,null,null,null,null,"Yes"]
["Please type the Company ID",null,null,null,null,null,null,null,null,null,"No"]
["Are there Traded products handled by the site included in the certification?\n(Traded Products: Goods that are purchased and sold without any alteration/process)","Yes"]
["Please describe the Traded Products",null,null,null,null,null,null,null,null,null,"X"]
["Has your risk analysis identified any high-risk, high-care, or ambient high-care areas? per Appendix 2 of the BRCGS Food standard","Please select"]
["high risk (chilled and frozen)"]
["high care (chilled and frozen)"]
["ambient high care"]
["Are Additional Modules included in the certification? ","Please select"]
["Module 13 - Meeting FSMA Requirements for Food"]
["Module 11 - Meat Supply Chain Assurance"]
["Costco GMP"]
["Justify produced or traded products excluded from the Certification scope","Please select"]
[]
[]
["PLEASE SELECT BRCGS FOOD CATEGORIES "]
["1. Raw red meat"]
["2. Raw poultry"]
["3. Raw prepared products"]
["4. Raw fish products and preparations (to include cold smoked)"]
["5. Fruit, vegetables, and nuts"]
["6. Prepared fruit, vegetables, and nuts"]
["7. Dairy, liquid egg"]
["8. Cooked meat/fish products (to include hot smoked)"]
["9. Raw cured/fermented meat and fish"]
["10. Ready meals/sandwiches, ready-to-eat desserts"]
["11. Low / High acid in cans/glass"]
["12. Beverages"]
["13. Alcoholic drinks & fermented /brewed products"]
["14. Bakery"]
["15. Dried foods and ingredients"]
["16. Confectionery"]
["17. Cereals and snacks"]
["18. Oils and fats"]
[]
[]
["Applicable only to the Unannounced Voluntary Audit Option"]
["Are there Blackout dates?\nA maximum of 10 operational days when the site is not available for the audit. \nThe blackout dates shall be notified to Q-CERT at the latest 4 weeks before the start of the unannounced audit window and cannot be changed at a later stage.\nNot applicable for seasonal sites and does not include non-operating periods (e.g. Easter and Christmas Holidays)."]
["Start Date","End Date"]
[]
["Reason (for example due to customer visit)"]
["Site entrance requirements"]
["List of contacts when first arriving on site"]
["Specific protective clothing arrangements"]
[null," "]
[null," "]

{"sheet":"IFS Food Audit","index":7,"n_rows":59,"n_cols":13,"rows_kept":59,"cut":false,"hidden":true,"merged":[[4,0,4,1],[5,0,5,1],[11,0,11,1],[31,0,31,1],[30,0,30,1],[48,0,48,1],[34,2,36,2],[37,2,38,2],[39,2,41,2],[23,0,23,1],[42,2,44,2],[47,0,47,1]]}
["IFS Site Code","Please select",null,null,null,null,null,null,null,null,null,null,"Please select"]
["Please type the IFS Site Code",null,null,null,null,null,null,null,null,null,null,null,"Yes"]
["GS1 GLN number (This number is mandatory for sites located within the European Economic Area (EEA) as well as the United Kingdom if it leaves the EEA on 01.01.2021)",null,null,null,null,null,null,null,null,null,null,null,"No"]
["Justify if there are products excluded from the Certification scope\nExclusions are allowed only when the IFS exclusions questionnaire is applied. Note: Exclusions in not applicable for Private Label Products.","Please select"]
[null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["Water use information"]
["Do you carry out any treatment on the water to be used on site?","Please select"]
["Please describe what treatment performed \ne.g. Filtration, reverse osmosis, chemical (e.g. chlorination), distillation, UV "]
["What the water is used for?\ne.g. ingredient, cleaning only, product transfer"]
[]
[]
["SELECT IFS FOOD CATEGORIES"]
["1. Red and white meat, poultry, and meat products"]
["2. Fish and fish products"]
["3. Egg and egg products"]
["4. Dairy products"]
["5. Fruit and vegetables"]
["6. Grain products, cereals, industrial bakery and pastry, confectionery, snacks"]
["7. Combined products*"]
["8. Beverages"]
["9. Oils and fats"]
["10. Dry goods, other ingredients, and supplements"]
["11. Pet food"]
["* Where category 7 are selected, please describe the individual product groups that are used as ingredients, e.g. fruits and vegetables, dairy, dry goods, etc. that undergo processing before use, e.g. disinfection, cutting, deboning, milling, marinating, etc. Ingredients that are added as purchased without any further processing (apart from mixing) should not be listed in the table below:"]
["Product category (as per the table above)","Process description"]
[5,"Washing, cutting and cooking of vegetables"]
[1,"Cooking of meat"]
[4,"Cutting and breading of cheese"]
[]
[]
["SELECT IFS FOOD TECHNOLOGY SCOPES"]
["IFS processing step – including processing/treating/manipulation/storing",null,"Technology focused classification which takes into consideration product risks"]
["A. P1 - Sterilization (e.g. cans)",null,"Sterilisation (in final packaging) with the purpose to destroy pathogens\nSterilised (e.g. autoclaved) products in final packaging."]
["B. P2 -  Thermal pasteurisation, UHT/aseptic filling, hot filling.\nOther pasteurisation techniques e.g. high-pressure pasteurisation, microwave",null,"Any heat treatment (or high pressure) with the purpose to reduce food safety hazards based on company’s HACCP plan."]
["C. P3 - Irradiation of food",null,"Processed products: Treatment with the purpose to modify the product and/or extend the shelf life and/or reduce food safety hazards by preservation techniques and other processing techniques,\nException: Irradiation is attributed to this category although aimed at the destruction of microorganisms."]
["C. P4 - Preserving: Salting, marinating, sugaring, acidifying/pickling, curing, smoking, etc. Fermentation, acidification"]
["C. P5 - Evaporation/dehydration, vacuum filtration, freeze drying, microfiltration (less than 10μ mesh size)"]
["D. P6 - Freezing (at least –18°C/0°F), including storage, quick freezing, cooling, chilling processes, and respective cool storing",null,"Systems, and treatments to maintain product integrity and or safety.\nTreatment with the purpose to maintain the quality and/or integrity of the products including treatments to remove contamination and/or prevent contamination."]
["D. P7 - Antimicrobial dipping/ spraying, fumigation"]
["E. P8 -  Packing MAP, Packing under vacuum",null,"Systems, and treatments to prevent product contamination\nP9 is applicable in any case when there are at least 2 procedures/methods implemented in a company to guarantee product safety/product hygiene\ne.g.:\n• disinfection of equipment + chilled room temperature (e.g. dissection of meat)\n• disinfection + special hygiene equipment for employees (e.g. hygiene sluice)\n• room with over-pressure + special hygiene equipment for employees (e.g. hygiene sluice),\n• air filtration + room with over-pressure."]
["E. P9 - Processes to prevent product contamination especially microbiological contamination, by means of high hygiene control and specific infrastructure during handling, treatment, and/or processing e.g. clean room technology, “white room”, controlled working room temperature for food safety purposes, disinfection after cleaning, positive air pressure systems (e.g. filtration below 10μ) "]
["E. P10 - Specific separation techniques: e.g. filtration like reverse osmoses, use of active charcoal "]
["F. P11 - Cooking, baking, brewing, fermentation (e.g. wine), drying, frying, roasting, extrusion, churning",null,"Any other manipulation, treatment, or processing not being listed in A, B, C, D, E"]
["F. P12 - Coating, breading, battering, cutting, slicing, dicing, dismembering, mixing/blending, stuffing, slaughtering, sorting, manipulation, packaging storing under controlled conditions (atmosphere) except temperature, labelling"]
["F. P13 - Distillation, purification, steaming, damping, hydrogenating, milling."]
[]
[]
["FOR UNANNOUNCED AUDITS ONLY "]
["Blackout periods \nA maximum of 10 operational days when the site is not available for the audit and can be split into a maximum of 3 periods. \nThe blackout dates shall be notified to Q-CERT at the latest 4 weeks before the start of the unannounced audit window and cannot be changed at a later stage. Not applicable for seasonal sites and does not include non-operating periods (e.g. Easter and Christmas Holidays)."]
["Start Date","End Date"]
[]
["Start Date","End Date"]
[]
["Start Date","End Date"]
[]
["Reason (for example due to customer visit)"]
["Site entrance requirements"]
["List of contacts when first arriving on site"]
["Specific protective clothing arrangements"]

{"sheet":"IFS Broker","index":8,"n_rows":71,"n_cols":11,"rows_kept":71,"cut":false,"hidden":true,"merged":[[60,0,60,1],[1,0,1,1],[5,0,5,1],[8,0,8,1],[10,0,10,1],[13,0,13,1],[23,0,23,1],[24,0,24,1],[32,0,32,1],[45,0,45,1],[51,0,51,1]]}
["IFS Site Code","Please select",null,null,null,null,null,null,null,null,"Please select"]
[null,null,null,null,null,null,null,null,null,null,"Yes"]
["Official registration /approval number ",null,null,null,null,null,null,null,null,null,"No"]
["Does the company operates virtually?","Please select"]
["Please indicate if there are more offices included within the certification","Please select"]
[]
["Scope \nWhich product types are traded? (supplier branded products, own branded products, customer branded products)",null,null,null,null,null,null,null,null,null,"X"]
["Any exclusions from certification (under exceptional circumstances, please Justify) \nPermitted to exclude the broker services only related to whole specific product scopes (see ANNEX 5, Part 1 of the Standard). Not allowed to exclude customer-branded products.","Please select"]
[]
["If there are seasonal breaks in activity during more than one week, please specify: ","Please select"]
[]
["Number of Hazard analysis and assessment of associated risks"]
["List the number of Storage facilities:"]
["List the number of transport operations:"]
["Company owned/ operated:"]
["Contracted to service providers:"]
["Number of product suppliers:"]
["Number of service suppliers:"]
["Languages spoken:"]
["Countries supplied:"]
["Countries sourced from:"]
["Please state your international trading terms (INCO terms): \nFor example: EXW, FOB, DDP etc."]
["Are you seeking approval for a group of offices? \nIf yes, please confirm the names of the trading offices to be included in the audit scope.","Please select"]
[]
["Please select type of IFS Broker Services "]
["Import"]
["Export"]
["Supplier selection"]
["Product development (own (Broker) brands or customer branded products)"]
["Organisation of Logistics Activities"]
["Other ……………."]
[]
["Please select IFS ‘’Food” product categories"]
["1.1 Red and white meat, poultry and meat products"]
["1.2 Fish and fish products"]
["1.3 Egg and egg products"]
["1.4 Dairy products"]
["1.5 Fruit and vegetables"]
["1.6 Grain products, cereals, industrial bakery and pastry, confectionery, snacks"]
["1.7 Combined products"]
["1.8 Beverage"]
["1.9 Oils and fats"]
["1.10 Dry goods, other ingredients and supplements"]
["1.11 Pet food"]
[]
["Please select “Household and personal care products”"]
["2.1 Cosmetic products"]
["2.2 Household chemical products"]
["2.3 Daily use household products "]
["2.4 Personal hygiene products"]
[]
["Please select “Packaging material”"]
["3.1 Flexible packaging"]
["3.2 Rigid plastic"]
["3.3 Paper"]
["3.4 Metal"]
["3.5 Glass"]
["3.6 Other natural materials"]
[]
["FOR UNANNOUNCED AUDITS ONLY "]
["Blackout periods \nA maximum of 10 operational days when the site is not available for the audit and can be split into a maximum of 3 periods. \nThe blackout dates shall be notified to Q-CERT at the latest 4 weeks before the start of the unannounced audit window and cannot be changed at a later stage. Not applicable for seasonal sites and does not include non-operating periods (e.g. Easter and Christmas Holidays)."]
["Start Date","End Date"]
[]
["Start Date","End Date"]
[]
["Start Date","End Date"]
[]
["Reason (for example due to customer visit)"]
["Site entrance requirements"]
["List of contacts when first arriving on site"]
["Specific protective clothing arrangements"]

{"sheet":"BRCGS A&B","index":9,"n_rows":101,"n_cols":11,"rows_kept":101,"cut":false,"hidden":true,"merged":[[94,0,94,1],[9,0,9,1],[21,0,21,1],[26,0,26,1],[37,0,37,1],[43,0,43,1],[44,0,44,1],[63,0,63,1],[71,0,71,1]]}
["BRC Site Code (if applicable)","Please select",null,null,null,null,null,null,null,null,"Please select"]
["Please type the BRCGS Site Code",null,null,null,null,null,null,null,null,null,"Yes"]
["Please type the Company ID",null,null,null,null,null,null,null,null,null,"No"]
["Does the company operates virtually?","No"]
["Scope of audit"]
["Please indicate if there are more offices included within the certification"]
["Any exclusions from certification \n(under exceptional circumstances, please Justify)  \nIt is only permitted to exclude the entire type of product (food, packaging, or consumer)",null,null,null,null,null,null,null,null,null,"X"]
["If there are seasonal breaks in activity during more than one week, please specify"]
["Number of BRCGS Product Safety Plans"]
["List the number of Storage facilities and the number of transport operations:"]
["Company owned/ operated:"]
["Contracted to service providers:"]
["Number of product suppliers:"]
["Number of service suppliers:"]
["Languages spoken:"]
["Countries supplied:"]
["Countries sourced from:"]
["Please state your international trading terms (INCO terms): \nFor example: EXW, FOB, DDP etc."]
["Are you seeking approval for a group of offices? ","Please select"]
["If yes, please confirm the names of the trading offices to be included in the audit scope."]
["Is the Additional Module Meeting FSMA Requirements included in the certification? ","Please select"]
["BRCGS A&B Operations"]
["Agents"]
["Brokers"]
["Agents & Brokers"]
[]
["BRCGS A&B Services"]
["Storage"]
["Importation"]
["Distribution"]
["Export"]
["Product development"]
["Repacking"]
["Product testing"]
["Further processing"]
["Other (please specify) "]
[]
["BRCGS A&B Product categories"]
["1 - Chilled and frozen food"]
["2 - Ambient food"]
["3 - Packaging materials"]
["4 - Consumer Products"]
[]
["BRCGS A&B Product Types"]
["Food Product Types"]
["Raw red meat"]
["Raw poultry"]
["Raw prepared products"]
["Raw fish products and preparations (to include cold smoked)"]
["Fruit, vegetables and nuts"]
["Prepared fruit, vegetables and nuts"]
["Dairy, liquid egg"]
["Cooked meat / fish products (to include hot smoked)"]
["Raw cured / fermented meat and fish"]
["Ready meals / sandwiches, ready to eat desserts"]
["Low / High acid in cans / glass"]
["Beverages"]
["Alcoholic drinks & fermented /brewed products"]
["Bakery"]
["Dried foods and ingredients"]
["Confectionery"]
["Cereals and snacks"]
["Oils and fats"]
["Packaging Product Types"]
["Glass"]
["Paper"]
["Metal"]
["Rigid plastics"]
["Flexible plastics"]
["Other packaging products"]
["Packaging and printing chemicals"]
["Consumer Product Types"]
["Textiles and textile products"]
["Leather and leather products"]
["Wood"]
["Paper and paper mix products"]
["Printing and recording media"]
["Coke, charcoal and refined petroleum products"]
["Chemicals and chemicals products"]
["Gardening products"]
["Plastic and rubber products"]
["Glass, ceramic and non-metallic mineral products"]
["Building goods"]
["Metal products excluding machinery"]
["Machinery and equipment"]
["Computers and electronic communications"]
["Electrical equipment"]
["Transport equipment, cycles and boats"]
["Furniture"]
["Games and toys"]
["Jewellery "]
["Medical devices"]
[]
["Applicable only to the Unannounced Voluntary Audit Option"]
["Blackout dates - A maximum of 10 operational days when the site is not available for the audit \nThe blackout dates shall be notified to Q-CERT at the latest 4 weeks before the start of the unannounced audit window and cannot be changed at a later stage.\nNot applicable for seasonal sites and does not include non-operating periods (e.g. Easter and Christmas Holidays)."]
["Start Date","End Date"]
[]
["Reason (for example due to customer visit)"]
["Site entrance requirements"]
["List of contacts when first arriving on site"]
["Specific protective clothing arrangements"]

{"sheet":"BRCGS S&D","index":10,"n_rows":59,"n_cols":20,"rows_kept":59,"cut":false,"hidden":true,"merged":[[23,1,23,2],[24,1,24,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[8,0,10,0],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[0,1,0,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2],[1,1,1,2],[6,1,6,2],[7,1,7,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[25,1,25,2],[26,1,26,2],[28,0,28,2],[29,1,29,2],[30,1,30,2],[31,1,31,2],[32,1,32,2],[34,0,34,2],[35,1,35,2],[36,1,36,2],[37,1,37,2],[38,1,38,2],[39,1,39,2],[40,1,40,2],[41,1,41,2],[42,1,42,2],[43,1,43,2],[44,1,44,2],[45,1,45,2],[46,1,46,2],[55,1,55,2],[56,1,56,2],[57,1,57,2],[58,1,58,2],[47,1,47,2],[51,0,51,2],[52,0,52,2],[53,1,53,2],[54,1,54,2]]}
["BRC Site Code (if applicable)","Please select",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Please select"]
["Please type the BRCGS Site Code",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
["Please type the Company ID",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No"]
["Scope of audit"]
["Any exclusions from certification \n(under exceptional circumstances, please Justify) "]
["Please indicate if there are additional locations included within the certification. (If yes, please type how many)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["Please describe any additional services other than storage or transport e.g. freezing/ thawing/ intake QC checks"]
["If there are seasonal breaks in activity during more than one week, please specify"]
["Number of transport units (vehicles)","Company owned:"]
[null,"Subcontracted (under site control):"]
[null,"Subcontracted vehicles (not under site control) and the name of subcontractor:"]
["Size of the facility (warehouses, loading/unloading area, and offices combined) square meters per facility"]
["Number of Storage facilities"]
["Are Additional Sections/ Modules included in the certification? ","Please select"]
["Section 9 Handling of open food products"]
["Section 10 Wholesale Module - 10.2  Branded products"]
["Section 10 Wholesale Module - 10.3 Wholesaler-own, wholesaler-exclusive and/or customer-exclusive products"]
["Section 11 Cross-docking module"]
["Section 12 E-commerce module"]
["Section 13 Contracted services modules (all services)"]
["Section14 Product inspection"]
["Section 15 Contract packing (repacking, assembly packing)"]
["Section 16 Quantity control inspection"]
["Section 17 Contract chilling/freezing/ tempering/defrosting and high pressure process operations"]
["Section 18 Contract cleaning of baskets, roll cages and other distribution containers"]
["Section 19 Waste recovery and recycling",null,null,null,null," "]
["Ethical Trade & Responsible Sourcing (ETRS) Risk Assessment"]
[]
["Please select BRCGS products categories"]
["01 - Chilled and Frozen Food"]
["02 - Ambient Food"]
["03 - Packaging and packing materials"]
["04 - Consumer Products"]
[]
["Please select BRCGS service activities"]
["01 - Storage "]
["02 - Distribution"]
["03 - Transport only"]
["04 - Wholesale Module"]
["05 - Contracted services Product Inspection"]
["06 - Contracted Services Contract Packing"]
["07 - Contracted Services Quantity Control Inspection"]
["08 - Contracted Services Contract Operations"]
["09 - Contracted Services Contract Containers"]
["10 - Contracted Services Waste Recovery and Recycling"]
["11 - Open Product Handling"]
["12 - Cross Docking (Remote)"]
["13 - Ecommerce"]
[]
[]
[]
["Applicable only to the Unannounced Voluntary Audit Option"]
["Are there Blackout dates?\nA maximum of 10 operational days when the site is not available for the audit. \nThe blackout dates shall be notified to Q-CERT at the latest 4 weeks before the start of the unannounced audit window and cannot be changed at a later stage.\nNot applicable for seasonal sites and does not include non-operating periods (e.g. Easter and Christmas Holidays)."]
["Start Date","End Date"]
[]
["Reason (for example due to customer visit)"]
["Site entrance requirements"]
["List of contacts when first arriving on site"]
["Specific protective clothing arrangements"]

{"sheet":"Appl. Review Food","index":11,"n_rows":39,"n_cols":26,"rows_kept":39,"cut":false,"hidden":true,"merged":[[37,1,37,2],[38,1,38,2],[30,1,30,2],[31,1,31,2],[33,1,33,2],[34,1,34,2],[35,1,35,2],[36,1,36,2],[32,1,32,2],[2,9,6,9],[0,7,1,8],[0,9,1,9],[16,1,16,2],[14,1,14,2],[15,1,15,2],[0,0,0,2],[1,0,1,2],[17,1,18,2],[19,1,19,2],[20,1,20,2],[2,7,6,8],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2],[10,1,10,2],[5,4,6,4],[5,5,6,5],[5,6,6,6],[13,0,13,2],[11,1,11,2],[12,1,12,2]]}
["Application Review for BRCGS&IFS Food - Q-CERT USE ONLY\nThe typical duration of a BRCGS audit is 2–3 days & the minimum IFS Food audit duration is 2 days.\n(Never in excess of 10 hours/day)",null,null,null,"Previous BRCGS/IFS audits","Auditor (BRCGS)","Auditor (IFS)","Is there any need for a concession from the scheme owner for the audit team, e.g. use of a technical expert, 4th consecutive audit for the same auditor?",null,"No",null,null,null,null,null,null,null,null,null,null,null,null,"BRCGS FOOD CATEGORIES ","IFS FOOD CATEGORIES","IFS FOOD TECHNOLOGY SCOPES","Yes"]
["BRCGS Food audit duration ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS Food Audit'!B18=\"X\",'BRCGS Food Audit'!A18,\"\")","v":""},{"$f":"IF('IFS Food Audit'!B13=\"X\",'IFS Food Audit'!A13,\"\")","v":""},{"$f":"IF('IFS Food Audit'!B33=\"X\",LEFT('IFS Food Audit'!A33,6),\"\")","v":""},"No"]
["BRCGS Food Categories",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,W2:W20)","v":""},null,null,null,null,null," If ‘’Yes’’, confirmation of concession is required, including date of concession granted before auditor allocation. No auditor allocation is possible without a positive concession from the scheme owner. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS Food Audit'!B19=\"X\",'BRCGS Food Audit'!A19,\"\")","v":""},{"$f":"IF('IFS Food Audit'!B14=\"X\",'IFS Food Audit'!A14,\"\")","v":""},{"$f":"IF('IFS Food Audit'!B34=\"X\",LEFT('IFS Food Audit'!A34,6),\"\")","v":""}]
["Number of HACCP Studies (categories in case of similar HACCP plans)",{"$f":"'SCOPE OF AUDIT (FOOD)'!B7","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS Food Audit'!B20=\"X\",'BRCGS Food Audit'!A20,\"\")","v":""},{"$f":"IF('IFS Food Audit'!B15=\"X\",'IFS Food Audit'!A15,\"\")","v":""},{"$f":"IF('IFS Food Audit'!B35=\"X\",LEFT('IFS Food Audit'!A35,6),\"\")","v":""}]
["Size of the manufacturing facility - production and storage (in square metres)",{"$f":"SUM('SITE INFORMATION'!E24:E26)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS Food Audit'!B21=\"X\",'BRCGS Food Audit'!A21,\"\")","v":""},{"$f":"IF('IFS Food Audit'!B16=\"X\",'IFS Food Audit'!A16,\"\")","v":""},{"$f":"IF('IFS Food Audit'!B36=\"X\",LEFT('IFS Food Audit'!A36,6),\"\")","v":""}]
["Maximum number of employees operating in main shift \n(management, production, including seasonal workers)",{"$f":"'SITE INFORMATION'!D29","v":0},null,null,"Proposed Auditor(s) for this year's audit ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS Food Audit'!B22=\"X\",'BRCGS Food Audit'!A22,\"\")","v":""},{"$f":"IF('IFS Food Audit'!B17=\"X\",'IFS Food Audit'!A17,\"\")","v":""},{"$f":"IF('IFS Food Audit'!B37=\"X\",LEFT('IFS Food Audit'!A37,6),\"\")","v":""}]
["Section 8: High risk (chilled and frozen) (2 hours per area)",{"$f":"IF('BRCGS Food Audit'!B7<>\"\",'BRCGS Food Audit'!B7,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS Food Audit'!B23=\"X\",'BRCGS Food Audit'!A23,\"\")","v":""},{"$f":"IF('IFS Food Audit'!B18=\"X\",'IFS Food Audit'!A18,\"\")","v":""},{"$f":"IF('IFS Food Audit'!B38=\"X\",LEFT('IFS Food Audit'!A38,6),\"\")","v":""}]
["Section 8: High care (chilled and frozen) (2 hours per area)",{"$f":"IF('BRCGS Food Audit'!B8<>\"\",'BRCGS Food Audit'!B8,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS Food Audit'!B24=\"X\",'BRCGS Food Audit'!A24,\"\")","v":""},{"$f":"IF('IFS Food Audit'!B19=\"X\",'IFS Food Audit'!A19,\"\")","v":""},{"$f":"IF('IFS Food Audit'!B39=\"X\",LEFT('IFS Food Audit'!A39,6),\"\")","v":""}]
["Section 8: Ambient high care (2 hours per area)",{"$f":"IF('BRCGS Food Audit'!B9<>\"\",'BRCGS Food Audit'!B9,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS Food Audit'!B25=\"X\",'BRCGS Food Audit'!A25,\"\")","v":""},{"$f":"IF('IFS Food Audit'!B20=\"X\",'IFS Food Audit'!A20,\"\")","v":""},{"$f":"IF('IFS Food Audit'!B40=\"X\",LEFT('IFS Food Audit'!A40,6),\"\")","v":""}]
["Section 9: Traded Products (≥1 hour)",{"$f":"IF('BRCGS Food Audit'!B4=\"Yes\",\"X\",\"\")","v":"X"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS Food Audit'!B26=\"X\",'BRCGS Food Audit'!A26,\"\")","v":""},{"$f":"IF('IFS Food Audit'!B21=\"X\",'IFS Food Audit'!A21,\"\")","v":""},{"$f":"IF('IFS Food Audit'!B41=\"X\",LEFT('IFS Food Audit'!A41,6),\"\")","v":""}]
["MINIMUM AUDIT DURATION BRCGS:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS Food Audit'!B27=\"X\",'BRCGS Food Audit'!A27,\"\")","v":""},{"$f":"IF('IFS Food Audit'!B22=\"X\",'IFS Food Audit'!A22,\"\")","v":""},{"$f":"IF('IFS Food Audit'!B42=\"X\",LEFT('IFS Food Audit'!A42,6),\"\")","v":""}]
["Justification for deviation (no more than 30%) e.g., 1) decrease: enclosed production, majority of staff performing same work, 2) increase: complex process/equipment, initial certification audit, communication difficulties",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS Food Audit'!B28=\"X\",'BRCGS Food Audit'!A28,\"\")","v":""},{"$f":"IF('IFS Food Audit'!B23=\"X\",'IFS Food Audit'!A23,\"\")","v":""},{"$f":"IF('IFS Food Audit'!B43=\"X\",LEFT('IFS Food Audit'!A43,6),\"\")","v":""}]
["AMENDED AUDIT DURATION for BRCGS:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS Food Audit'!B29=\"X\",'BRCGS Food Audit'!A29,\"\")","v":""},null,{"$f":"IF('IFS Food Audit'!B44=\"X\",LEFT('IFS Food Audit'!A44,6),\"\")","v":""}]
["IFS Food audit duration ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS Food Audit'!B30=\"X\",'BRCGS Food Audit'!A30,\"\")","v":""},null,{"$f":"IF('IFS Food Audit'!B45=\"X\",LEFT('IFS Food Audit'!A45,6),\"\")","v":""}]
["IFS Food Categories",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,X2:X20)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS Food Audit'!B31=\"X\",'BRCGS Food Audit'!A31,\"\")","v":""}]
["IFS Food Technology Scopes",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,Y2:Y14)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS Food Audit'!B32=\"X\",'BRCGS Food Audit'!A32,\"\")","v":""}]
["Total number of employees including management, seasonal workers (in the peak season)",{"$f":"'SITE INFORMATION'!D28","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS Food Audit'!B33=\"X\",'BRCGS Food Audit'!A33,\"\")","v":""}]
["MINIMUM IFS Duration according to IFS Calculation Tool",null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS Food Audit'!B34=\"X\",'BRCGS Food Audit'!A34,\"\")","v":""}]
["https://time-calculator.ifs-certification.com/"]
["Justification for deviation as per IFS doctrine. Μax reduction 4h: a) decrease reasons: IFS combined Assessments (more than 1 IFS standard), b) Multi-location, c) Multi-legal entity production site, d) Labour-intensive simple repetitive processes (based on a risk assessment), e) Extension audit (the process could not be audited on-site/ seasonal production every year). Max reduction 6 h: a) site with PS 5, performing simple handling b) site with PS 3, 6, 8, 9, 10, and /or 11, that has simple processes as follows sorting, bottling, simple packaging (e.g. no MAP or vacuum), mixing/blending only in the case of PS 10.\nAttention: any other reason for the reduction is not permitted!",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS Food Audit'!B35=\"X\",'BRCGS Food Audit'!A35,\"\")","v":""}]
["AMENDED AUDIT DURATION for IFS:"]
["Combined factor for BRCGS/IFS (2-4 hours)"]
["Combined factor for audit team (2 hours)"]
["Translator Presence + 20% minimum "]
["BRCGS Module 13 - Meeting FSMA Requirements for Food (2-4 hours)",{"$f":"IF('BRCGS Food Audit'!B11<>\"\",'BRCGS Food Audit'!B11,\"\")","v":""}]
["BRCGS Module 11 - Meat Supply Chain Assurance (2-4 hours)",{"$f":"IF('BRCGS Food Audit'!B12<>\"\",'BRCGS Food Audit'!B12,\"\")","v":""}]
["Costco GMP",{"$f":"IF('BRCGS Food Audit'!B13<>\"\",'BRCGS Food Audit'!B13,\"\")","v":""}]
["Combined with other Global Standards GFCP or GFCP plus AOECS or AOECS or Plant-Based: 4 hours"]
["IFS FSMA Module"]
["Additional time for any other reason (please descripe..)"]
["TOTAL TIME DURATION (BRCGS/IFS):"]
["Preparation Time (BRCGS 1-2 hrs) "]
["Preparation Time (IFS 2 hrs) "]
["Report Time BRCGS (4 - 8 hrs)"]
["Report Time IFS (6 hrs)"]
["Travel Time Round trip"]
["Total Hours (BRCGS/IFS)",{"$f":"SUM(B31:C36)","v":0},null,null,null,null," "]
["Reviewed By","LDK/AK"]
["Reviewed Date"]

{"sheet":"Revisions","index":12,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
["Rev. No","Date","Comments","Approved by"]
[0,"Sep 20, 2018","Original Issue","LDK"]
[1,"Feb 04, 2019","Changed title. Removed nonfood standards and kept only food process standards","LDK"]
[2,"May 27, 2019","Revised to include more details for each Standard","LDK/AK"]
[3,"June 18, 2019","Removed IFS unannounced limitation. Entered APPENDIX 6 for product categories for BRCGS","VN/AK"]
[4,"Aug. 26, 2019","Revised to include details for head office, GPS Data, GLN number and list all processes carried out on site.","LDK/AK"]
[5,"Jan. 20, 2020","Revised to include ASDA Private Audit Option, corrected IFS Technology scopes and revised BRCGS duration calculation.","LDK/AK"]
[6,"May 8, 2020","Revised to include clarification for high-risk – high-care – ambient high-care areas.","PD/AK"]
[7,"March 10, 2021","Revised to include IFS audit duration for new version 7, include scope extension from audit type and remove Gluten Free Module from Standard/ Module selection. Amended exclusion section for IFS. Added concession section on contract review section. Replaced BRC with BRCGS. Travel time noted as round trip","PD/KP"]
[8,"Feb 01, 2022","Revised wording and added a fourth column for monitoring the three-year consecutive rule. Added GFCP time requirement","LDK/AK"]
[9,"Nov 29, 2022","Revised to correct GS1 GLN number mandatory for IFS, the number of blackout dates, and the Superuser to the IFS Database and/or BRCGS Directory. Also revised to remove the ASDA Unannounced audits option, and to add a field to indicate the production period/time in which the most complicated production technologies take place and the option for Plant-Based Global Standard. ","LDK/AK"]
[10,"March 30, 2024","Change of the whole document to an excel document","LDK/AK"]
[11,"April 30, 2024","Added a field to select a language for the communication and documentation and added a digital signature for the macros"]

{"sheet":"BRCGS Consumer Products","index":13,"n_rows":59,"n_cols":16,"rows_kept":59,"cut":false,"hidden":true,"merged":[[3,3,4,3],[5,3,6,3],[15,0,15,1],[49,0,49,1],[50,0,50,1],[12,1,12,2],[13,1,13,2],[8,1,8,2],[10,1,10,2],[11,1,11,2],[0,1,0,2],[1,1,1,2],[2,1,2,2],[7,1,7,2],[38,0,38,1]]}
["BRCGS Site Code","Please select",null,null,null,null,null,null,null,null,"Please select",null,null,null,"Start Month","End Month"]
["Please type the BRCGS Site Code",null,null,null,null,null,null,null,null,null,"Yes",null,null,null,"January","January"]
["Please type the Company ID",null,null,null,null,null,null,null,null,null,"No",null,null,null,"February","February"]
["Consumer Products type","Personal Care and Household","General Merchandise",null,null,null,null,null,null,null,null,null,null,null,"March","March"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"April","April"]
["Audit Level","Higher Level","Foundation Level",null,null,null,null,null,null,null,null,null,null,null,"May","May"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"June","June"]
["Scope of the audit",null,null,null,null,null,null,null,null,null,null,null,null,null,"July","July"]
["Is the site classified as a Seasonal Site? ","Please select",null,null,null," ",null,null,null,null,"X",null,null,null,"August","August"]
["Please indicate how many months the site operates per year/ \nSeasonal opening times (start/end date)","Start Month","End Month",null,null,null,null,null,null,null,null,null,null,null,"September","September"]
["Are you handling Seasonal Products? ","Please select",null,null,null,null,null,null,null,null,null,null,null,null,"October","October"]
["Indicate the Season/ start and finish dates per product",null,null,null,null,null,null,null,null,null,null,null,null,null,"November","November"]
["Are Additional Modules included in the certification? ","Please select",null,null,null,null,null,null,null,null,null,null,null,null,"December","December"]
["Capacity & Capability"]
[]
["Please Select Product Categories"]
["01 - Textiles and textile products"]
["02 - Leather, leather products, footwear"]
["03 - Wood, wooden products, cork, straw "]
["04 - Paper & paper products"]
["05 - Printing & recorded media"]
["06 - Coke,charcoal,refined petroleum products",null," "]
["07 - Chemicals & chemical products"]
["08 - Gardening Products"]
["09 - Rubber & plastic products"]
["10 - Glass, clay, ceramic & porcelain products"]
["11 - Concrete, cement, lime, plaster"]
["12 - Metal products exc machinery"]
["13 - Machinery & equipment"]
["14 - Computer, electronic, communications & optical"]
["15 - Electrical equipment, batteries"]
["16 - Transport equipment, cycles, boats"]
["17 - Furniture"]
["18 - Games & toys"]
["19 - Jewellery and accessories"]
["20 - Medical devices"]
["21 - Party & Leisure"]
[]
["Please Select Product Technologies"]
["A1 Chemicals and Formulated Chemicals"]
["A2 Fabricated paper"]
["A3 Wood, straw, cork, bamboo"]
["A4 Rubber and Plastics"]
["A5 Textiles and Textiles Mix"]
["A6 Electrical, Electronic, Batteries"]
["A7 Glass, Ceramics, Gemstones"]
["A8 Metals and Metal Mix"]
["A9 Assembly only"]
[]
["Applicable for the Unannounced Audit Option"]
["Are there Blackout dates?\nA maximum of 10 operational days when the site is not available for the audit. \nThe blackout dates shall be notified to Q-CERT at the latest 4 weeks before the start of the unannounced audit window and cannot be changed at a later stage.\nNot applicable for seasonal sites and does not include non-operating periods (e.g. Easter and Christmas Holidays)."]
["Start Date","End Date"]
[]
["Reason (for example due to customer visit)"]
["Site entrance requirements"]
["List of contacts when first arriving on site"]
["Specific protective clothing arrangements"]
[null," "]
[null," "]

{"sheet":"App.Review Consumer","index":14,"n_rows":22,"n_cols":25,"rows_kept":22,"cut":false,"hidden":true,"merged":[[21,1,21,2],[7,4,8,4],[7,5,8,5],[8,1,8,2],[9,1,9,2],[10,1,10,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[0,0,0,2],[0,6,1,7],[0,8,1,8],[1,0,1,2],[4,1,4,2],[4,6,8,7],[4,8,8,8],[6,1,6,2],[7,1,7,2],[2,1,2,2],[5,1,5,2],[3,1,3,2]]}
["Application Review for BRCGS Consumer Products- Q-CERT USE ONLY\nThe typical duration of an audit is 1 to 1.5 (8 hours/day) at the site at the foundation level and days 2 to 3 days at the higher level. At least 50% of the total audit duration, e.g. minimum of 8 hours of a 2.0-day audit at a higher level should be spent within the production environment. For the foundation level, it is expected that a greater amount of time (60% as a guideline) will be spent within the production environment.",null,null,null,"Previous BRCGS audits","Auditor (BRCGS)","Is there any need for a concession from the scheme owner for the audit team, e.g. use of a technical expert, 4th consecutive audit for the same auditor?",null,"No",null,null,null,null,null,null,null,null,null,null,"Consumer Products type","Audit Level","Product Categories"," Product Technologies",null,"Yes"]
["BRCGS Consumer Products audit duration ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS Consumer Products'!B5=\"X\",'BRCGS Consumer Products'!B4,\"\")","v":""},{"$f":"IF('BRCGS Consumer Products'!B7=\"X\",'BRCGS Consumer Products'!B6,\"\")","v":""},{"$f":"IF('BRCGS Consumer Products'!B17=\"X\",'BRCGS Consumer Products'!A17,\"\")","v":""},{"$f":"IF('BRCGS Consumer Products'!B40=\"X\",'BRCGS Consumer Products'!A40,\"\")","v":""},null,"No"]
["Consumer Products type",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,T2:T3)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS Consumer Products'!C5=\"X\",'BRCGS Consumer Products'!C4,\"\")","v":""},{"$f":"IF('BRCGS Consumer Products'!C7=\"X\",'BRCGS Consumer Products'!C6,\"\")","v":""},{"$f":"IF('BRCGS Consumer Products'!B18=\"X\",'BRCGS Consumer Products'!A18,\"\")","v":""},{"$f":"IF('BRCGS Consumer Products'!B41=\"X\",'BRCGS Consumer Products'!A41,\"\")","v":""}]
["Audit Level",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,U2:U3)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS Consumer Products'!B19=\"X\",'BRCGS Consumer Products'!A19,\"\")","v":""},{"$f":"IF('BRCGS Consumer Products'!B42=\"X\",'BRCGS Consumer Products'!A42,\"\")","v":""}]
["Product Categories",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,V2:V22)","v":""},null,null,null,null," If ‘’Yes’’, confirmation of concession is required, including date of concession granted before auditor allocation. No auditor allocation is possible without a positive concession from the scheme owner. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS Consumer Products'!B20=\"X\",'BRCGS Consumer Products'!A20,\"\")","v":""},{"$f":"IF('BRCGS Consumer Products'!B43=\"X\",'BRCGS Consumer Products'!A43,\"\")","v":""}]
["Product Technologies",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,W2:W10)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS Consumer Products'!B21=\"X\",'BRCGS Consumer Products'!A21,\"\")","v":""},{"$f":"IF('BRCGS Consumer Products'!B44=\"X\",'BRCGS Consumer Products'!A44,\"\")","v":""}]
["Size of the manufacturing facility - production and storage (in square metres)",{"$f":"SUM('SITE INFORMATION'!E24:E26)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS Consumer Products'!B22=\"X\",'BRCGS Consumer Products'!A22,\"\")","v":""},{"$f":"IF('BRCGS Consumer Products'!B45=\"X\",'BRCGS Consumer Products'!A45,\"\")","v":""}]
["Maximum number of employees operating in main shift \n(management, production, including seasonal workers)",{"$f":"'SITE INFORMATION'!D29","v":0},null,null,"Proposed Auditor(s) for this year's audit ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS Consumer Products'!B23=\"X\",'BRCGS Consumer Products'!A23,\"\")","v":""},{"$f":"IF('BRCGS Consumer Products'!B46=\"X\",'BRCGS Consumer Products'!A46,\"\")","v":""}]
["MINIMUM AUDIT DURATION BRCGS:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS Consumer Products'!B24=\"X\",'BRCGS Consumer Products'!A24,\"\")","v":""},{"$f":"IF('BRCGS Consumer Products'!B47=\"X\",'BRCGS Consumer Products'!A47,\"\")","v":""}]
["Justification for deviation (no more than 30%) e.g., 1) decrease: (no more than 30%) e.g. Where less than 50% of the total manufacturing and storage facility site size is utilised as production or storage space,\nThe site carries out one simple process, such as assembly only, \n2) increase: Complexity of the manufacturing process, Number of product lines, Age of the site and impact on material flow, Labour-intensity of processes, Communication difficulties, Number of non-conformities recorded in the previous audit, Difficulties experienced during the audit requiring further investigation, The quality of company preparation. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS Consumer Products'!B25=\"X\",'BRCGS Consumer Products'!A25,\"\")","v":""},{"$f":"IF('BRCGS Consumer Products'!B48=\"X\",'BRCGS Consumer Products'!A48,\"\")","v":""}]
["AMENDED AUDIT DURATION for BRCGS:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS Consumer Products'!B26=\"X\",'BRCGS Consumer Products'!A26,\"\")","v":""}]
["Combined factor for audit team (2 hours)",null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS Consumer Products'!B27=\"X\",'BRCGS Consumer Products'!A27,\"\")","v":""}]
["Translator Presence + 20% minimum ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS Consumer Products'!B28=\"X\",'BRCGS Consumer Products'!A28,\"\")","v":""}]
["Voluntary Module - Capacity & Capability (1 - 2 hours)",{"$f":"IF('BRCGS Consumer Products'!B14<>\"\",'BRCGS Consumer Products'!B14,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS Consumer Products'!B29=\"X\",'BRCGS Consumer Products'!A29,\"\")","v":""}]
["Additional time for any other reason (please descripe..)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS Consumer Products'!B30=\"X\",'BRCGS Consumer Products'!A30,\"\")","v":""}]
["TOTAL TIME DURATION (BRCGS/IFS):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS Consumer Products'!B31=\"X\",'BRCGS Consumer Products'!A31,\"\")","v":""}]
["Preparation Time (BRCGS 1-2 hrs) ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS Consumer Products'!B32=\"X\",'BRCGS Consumer Products'!A32,\"\")","v":""}]
["Report Time BRCGS (4 - 8 hrs)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS Consumer Products'!B33=\"X\",'BRCGS Consumer Products'!A33,\"\")","v":""}]
["Travel Time Round trip",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS Consumer Products'!B34=\"X\",'BRCGS Consumer Products'!A34,\"\")","v":""}]
["Total Hours",{"$f":"SUM(C16:C19)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS Consumer Products'!B35=\"X\",'BRCGS Consumer Products'!A35,\"\")","v":""}]
["Reviewed By","LDK/AK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS Consumer Products'!B36=\"X\",'BRCGS Consumer Products'!A36,\"\")","v":""}]
["Reviewed Date",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS Consumer Products'!B37=\"X\",'BRCGS Consumer Products'!A37,\"\")","v":""}]

{"sheet":"IFS LOGISTICS","index":15,"n_rows":69,"n_cols":14,"rows_kept":69,"cut":false,"hidden":true,"merged":[[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[17,0,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[53,1,53,2],[54,1,54,2],[47,1,47,2],[48,1,48,2],[49,1,49,2],[50,1,50,2],[51,1,51,2],[43,1,43,2],[44,1,44,2],[45,1,45,2],[46,1,46,2],[52,1,52,2],[36,1,36,2],[37,1,37,2],[38,1,38,2],[39,1,39,2],[42,1,42,2],[6,1,6,2],[7,1,7,2],[12,1,12,2],[15,1,15,2],[16,1,16,2],[11,1,11,2],[0,1,0,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2],[1,1,1,2],[57,0,57,1],[58,0,58,2],[59,1,59,2],[60,1,60,2],[8,0,10,0],[14,0,14,2],[28,0,28,2],[41,0,41,2],[26,1,26,2],[29,1,29,2],[30,1,30,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[35,1,35,2],[66,1,66,2],[67,1,67,2],[68,1,68,2],[61,1,61,2],[62,1,62,2],[63,1,63,2],[64,1,64,2],[65,1,65,2]]}
["IFS Site Code","Please select",null,null,null,null,null,null,null,null,null,null,null,"Please select"]
["Please type the IFS Site Code",null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
["Official registration /approval number ",null,null,null,null,null,null,null,null,null,null,null,null,"No"]
["Please indicate if there are additional locations included within the certification \n(If yes, please type how many)"]
["Scope of audit\nType of logistical activities (e.g. transport, incl. type of transport; storage) / Product scope(s) (food, nonfood) / Conditions of handling (e.g. ambient stable, chilled, frozen, etc.)",null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["Any exclusions from certification (under exceptional circumstances, please Justify) "]
["If there are seasonal breaks in activity during more than one week, please specify"]
["Applicable Legal Requirements and/or Relevant Standards"]
["Number of transport units (vehicles)","Company owned:"]
[null,"Subcontracted (under site control):"]
[null,"Subcontracted vehicles (not under site control) and the name of subcontractor:"]
["Size of the facility (warehouses, loading/unloading area, and offices combined) square meters per facility"]
["Number of Storage facilities"]
[]
["Please select IFS logistics service activities"]
["1 - Storage "]
["2 - Transport "]
["Additional services activities other than storage or transport"]
["Freezing"]
["Thawing"]
["Intake"]
["QC Checks"]
["Loading"]
["Off-Loading",null,null,null,null,null," "]
["Handling"]
["Further distribution"]
["Other"]
[]
["Please select IFS logistics ‘’Food product’’ scope group categories"]
["1 - Red and white meat, poultry and meat products"]
["2 - Fish and fish products"]
["3 - Egg and egg products"]
["4 - Dairy products"]
["5 - Fruit and vegetables"]
["6 - Grain products, cereals, industrial bakery and pastry, confectionery, snacks"]
["7 - Combined products"]
["8 - Beverage"]
["9 - Oils and fats"]
["10 - Dry goods, other ingredients and supplements"]
["11 - Pet food"]
[]
["Please select IFS logistics ‘’Non-Food product’’ scope group categories"]
["1 - Household and Personal Care products (cosmetics, household chemical products, daily use household products, personal hygiene)"]
["2 - Packaging materials"]
["3 - Electric / electronic devices:  household equipment (e.g. kitchen equipment, white goods), entertainment electronics (e.g. television and HIFI equipment, computer, telecommunication, cameras, etc.), light engineering (e.g. lamps, bulbs, contactors, etc.)"]
["4 - Housekeeping goods (which are not already included in the HPC scope, like porcelain, dishes, cutlery, pans, etc.)"]
["5 - Textiles (clothing, underwear and shoes, leather, bedclothes and tablecloths, etc.)"]
["6 - Media products (newspapers, books, CDs and other sound storage media, computer games, software, etc.)"]
["7 - Furniture"]
["8 - Tools and technical equipment (DIY)"]
["9 - Stationary / office materials"]
["10 - Toys"]
["11 - Plants and flowers"]
["12 - Gardening equipment"]
["13 - Other"]
[]
[]
["FOR UNANNOUNCED AUDITS ONLY "]
["Blackout periods \nA maximum of 10 operational days when the site is not available for the audit and can be split into a maximum of 3 periods. \nThe blackout dates shall be notified to Q-CERT at the latest 4 weeks before the start of the unannounced audit window and cannot be changed at a later stage. Not applicable for seasonal sites and does not include non-operating periods (e.g. Easter and Christmas Holidays)."]
["Start Date","End Date"]
[]
["Start Date","End Date"]
[]
["Start Date","End Date"]
[]
["Reason (for example due to customer visit)"]
["Site entrance requirements"]
["List of contacts when first arriving on site"]
["Specific protective clothing arrangements"]

{"sheet":"Glutten-Free ","index":16,"n_rows":6,"n_cols":21,"rows_kept":6,"cut":false,"hidden":true,"merged":[[5,0,5,1]]}
["Please select Standard"]
["Will the audit be combined with other audit or as a standalone audit? Please select.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gluten-Free Certification Program (GFCP)","Standalone Audit"]
["If combined, which Scheme?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GFCP plus AOECS ","Combined Audit"]
["Scope of audit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AOECS"]
["Number of HACCP Studies \n(categories in case of similar HACCP plans)"]
["Please submit a Schedule A and/or equivalent approved process to BRCGS and the Program License Agreement. "]

{"sheet":"Plant-Based Global Standard","index":17,"n_rows":4,"n_cols":19,"rows_kept":4,"cut":false,"hidden":true,"merged":[[3,0,3,1]]}
["Will the audit be combined with other audit or as a standalone audit? Please select."]
["If yes, which Scheme?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Standalone Audit"]
["Scope of audit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Combined Audit"]
["Please submit a Schedule A and/or equivalent approved process to BRCGS "]

{"sheet":"IFS ESG Check","index":18,"n_rows":10,"n_cols":21,"rows_kept":10,"cut":false,"hidden":true,"merged":[[9,0,9,1]]}
["Will the audit be combined with other audit or as a standalone audit? Please select.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
["If yes, which Scheme?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Standalone Audit","No"]
["Already IFS certified? IF yes type the COID","No",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Combined Audit"]
["Please type the COID"]
["Scope of audit"]
["ESG Check (main module)"]
["ESG Check plus Carbon Footprint Module"]
["Are there additional extra module?","No"]
["Please type the module"]
["Please complete and attached the Self Assessment form together with the Application Form"]

{"sheet":"Appl. Review Broker","index":19,"n_rows":48,"n_cols":29,"rows_kept":48,"cut":false,"hidden":true,"merged":[[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[37,1,37,2],[36,1,36,2],[35,1,35,2],[34,1,34,2],[33,1,33,2],[32,1,32,2],[31,1,31,2],[30,1,30,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[0,7,2,8],[0,9,2,9],[12,0,12,2],[0,0,0,2],[1,0,1,2],[5,4,6,4],[5,5,6,5],[5,6,6,6],[3,7,6,8],[3,9,6,9],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2],[6,1,6,2],[7,1,7,2]]}
["Application Review IFS Broker & BRCGS Agents and Brokers - Q-CERT USE ONLY",null,null,null,"Previous BRCGS/IFS audits","Auditor (BRCGS)","Auditor (IFS)","Is there any need for a concession from the scheme owner for the audit team, e.g. use of a technical expert, 4th consecutive audit for the same auditor?",null,"No",null,null,null,null,null,null,null,null,null,null,null,null,null,"IFS Broker Services ","IFS ‘’Food” product categories","BRCGS A&B Operations","BRCGS A&B Services","BRCGS A&B Product Types","Yes"]
["BRCGS Agents and Brokers Audit Duration (Minimum audit duration 8 hours)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('IFS Broker'!B26=\"X\",'IFS Broker'!A26,\"\")","v":""},{"$f":"IF('IFS Broker'!B34=\"X\",'IFS Broker'!A34,\"\")","v":""},{"$f":"IF('BRCGS A&B'!B23=\"X\",'BRCGS A&B'!A23,\"\")","v":""},{"$f":"IF('BRCGS A&B'!B28=\"X\",'BRCGS A&B'!A28,\"\")","v":""},{"$f":"IF('BRCGS A&B'!B46=\"X\",'BRCGS A&B'!A46,\"\")","v":""},"No"]
["BRCGS A&B operations e.g. Agents or Brokers or Agents & Brokers",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,Z2:Z4)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('IFS Broker'!B27=\"X\",'IFS Broker'!A27,\"\")","v":""},{"$f":"IF('IFS Broker'!B35=\"X\",'IFS Broker'!A35,\"\")","v":""},{"$f":"IF('BRCGS A&B'!B24=\"X\",'BRCGS A&B'!A24,\"\")","v":""},{"$f":"IF('BRCGS A&B'!B29=\"X\",'BRCGS A&B'!A29,\"\")","v":""},{"$f":"IF('BRCGS A&B'!B47=\"X\",'BRCGS A&B'!A47,\"\")","v":""},"  "]
["Number of Product Types traded (Where a site trades greater than 26 product types, an additional 1 hour shall be added)",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,AB2:AB48)","v":""},null,null,null,null,null," If ‘’Yes’’, confirmation of concession is required, including date of concession granted before auditor allocation. No auditor allocation is possible without a positive concession from the scheme owner. ",null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('IFS Broker'!B28=\"X\",'IFS Broker'!A28,\"\")","v":""},{"$f":"IF('IFS Broker'!B36=\"X\",'IFS Broker'!A36,\"\")","v":""},{"$f":"IF('BRCGS A&B'!B25=\"X\",'BRCGS A&B'!A25,\"\")","v":""},{"$f":"IF('BRCGS A&B'!B30=\"X\",'BRCGS A&B'!A30,\"\")","v":""},{"$f":"IF('BRCGS A&B'!B48=\"X\",'BRCGS A&B'!A48,\"\")","v":""}]
["Number of supplying sites (suppliers)",{"$f":"'BRCGS A&B'!B16","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('IFS Broker'!B29=\"X\",'IFS Broker'!A29,\"\")","v":""},{"$f":"IF('IFS Broker'!B37=\"X\",'IFS Broker'!A37,\"\")","v":""},null,{"$f":"IF('BRCGS A&B'!B31=\"X\",'BRCGS A&B'!A31,\"\")","v":""},{"$f":"IF('BRCGS A&B'!B49=\"X\",'BRCGS A&B'!A49,\"\")","v":""}]
["Number of additional services (e.g. Storage, Distribution, Import, Export, Product development, Repacking) For each additional service offered (i.e. above the 3 services) an additional 1 hour shall be added.",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,AA2:AA10)","v":""},null,null,"Proposed Auditor(s) for this year's audit  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('IFS Broker'!B30=\"X\",'IFS Broker'!A30,\"\")","v":""},{"$f":"IF('IFS Broker'!B38=\"X\",'IFS Broker'!A38,\"\")","v":""},null,{"$f":"IF('BRCGS A&B'!B32=\"X\",'BRCGS A&B'!A32,\"\")","v":""},{"$f":"IF('BRCGS A&B'!B50=\"X\",'BRCGS A&B'!A50,\"\")","v":""}]
["Number of additional office locations (the initial calculation assumes that the company is based on a single office. Where the company has additional offices, locations included within the scope of the audit, will require additional time {min. 2-3 hours added for each additional office location)",{"$f":"'BRCGS A&B'!B6","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('IFS Broker'!B31<>\"\",'IFS Broker'!B31,\"\")","v":""},{"$f":"IF('IFS Broker'!B39=\"X\",'IFS Broker'!A39,\"\")","v":""},null,{"$f":"IF('BRCGS A&B'!B33=\"X\",'BRCGS A&B'!A33,\"\")","v":""},{"$f":"IF('BRCGS A&B'!B51=\"X\",'BRCGS A&B'!A51,\"\")","v":""}]
["Number of employees",{"$f":"'SITE INFORMATION'!D29","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('IFS Broker'!B40=\"X\",'IFS Broker'!A40,\"\")","v":""},null,{"$f":"IF('BRCGS A&B'!B34=\"X\",'BRCGS A&B'!A34,\"\")","v":""},{"$f":"IF('BRCGS A&B'!B52=\"X\",'BRCGS A&B'!A52,\"\")","v":""}]
["MIMIMUM AUDIT DURATION BRC:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('IFS Broker'!B41=\"X\",'IFS Broker'!A41,\"\")","v":""},null,{"$f":"IF('BRCGS A&B'!B35=\"X\",'BRCGS A&B'!A35,\"\")","v":""},{"$f":"IF('BRCGS A&B'!B53=\"X\",'BRCGS A&B'!A53,\"\")","v":""}]
["Justification for deviation: min. 30% e.g. number of employees, communication difficulties, number of non-conformities,  number of non-conformities, difficulties experienced during the audit, the quality of the company’s preparation, and In the event that there is a significant delay in the audit. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('IFS Broker'!B42=\"X\",'IFS Broker'!A42,\"\")","v":""},null,{"$f":"IF('BRCGS A&B'!B36=\"\",\"\",'BRCGS A&B'!B36)","v":""},{"$f":"IF('BRCGS A&B'!B54=\"X\",'BRCGS A&B'!A54,\"\")","v":""}]
["In the case where a company is exceptionally small, a shorter audit duration may be justified. In this situation, the company must meet all of the following criteria:\n• Only operates from a single office location.\n• Only trade one product type \n• Does not offer any additional services.\n• Only employs a small number of staff (i.e. there are less than 5 employees in the company).",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('IFS Broker'!B43=\"X\",'IFS Broker'!A43,\"\")","v":""},null,null,{"$f":"IF('BRCGS A&B'!B55=\"X\",'BRCGS A&B'!A55,\"\")","v":""}]
["AMENDED AUDIT DURATION for BRCGS:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('IFS Broker'!B44=\"X\",'IFS Broker'!A44,\"\")","v":""},null,null,{"$f":"IF('BRCGS A&B'!B56=\"X\",'BRCGS A&B'!A56,\"\")","v":""}]
["IFS BROKER Audit Duration (The minimum audit duration of an IFS Broker audit shall be 6 hours. A normal audit day duration is eight (8) hours and shall never exceed 10 hours)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('IFS Broker'!B45=\"X\",'IFS Broker'!A45,\"\")","v":""},null,null,{"$f":"IF('BRCGS A&B'!B57=\"X\",'BRCGS A&B'!A57,\"\")","v":""}]
["Type of broker services (e.g. supplier selection, product development (own (Broker) brands or customer branded products, organisation of logistics activities)",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,X2:X7)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('IFS Broker'!B46=\"X\",'IFS Broker'!A46,\"\")","v":""},null,null,{"$f":"IF('BRCGS A&B'!B58=\"X\",'BRCGS A&B'!A58,\"\")","v":""}]
["Number and volume of products traded",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,Y2:Y26)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('IFS Broker'!B47=\"X\",'IFS Broker'!A47,\"\")","v":""},null,null,{"$f":"IF('BRCGS A&B'!B59=\"X\",'BRCGS A&B'!A59,\"\")","v":""}]
["Number of origin countries the broker is trading with",{"$f":"'IFS Broker'!B21","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('IFS Broker'!B48=\"X\",'IFS Broker'!A48,\"\")","v":""},null,null,{"$f":"IF('BRCGS A&B'!B60=\"X\",'BRCGS A&B'!A60,\"\")","v":""}]
["Number of destination countries the broker is trading with",{"$f":"'IFS Broker'!B20","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('IFS Broker'!B49=\"X\",'IFS Broker'!A49,\"\")","v":""},null,null,{"$f":"IF('BRCGS A&B'!B61=\"X\",'BRCGS A&B'!A61,\"\")","v":""}]
["Number of personnel employed at the audited office / trading site",{"$f":"'SITE INFORMATION'!D28","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('IFS Broker'!B50=\"X\",'IFS Broker'!A50,\"\")","v":""},null,null,{"$f":"IF('BRCGS A&B'!B62=\"X\",'BRCGS A&B'!A62,\"\")","v":""}]
["Number of deviations and non-conformities found in the previous audit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('IFS Broker'!B51=\"X\",'IFS Broker'!A51,\"\")","v":""},null,null,{"$f":"IF('BRCGS A&B'!B63=\"X\",'BRCGS A&B'!A63,\"\")","v":""}]
["MIMIMUM REQUIRED AUDIT DURATION IFS:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('IFS Broker'!B52=\"X\",'IFS Broker'!A52,\"\")","v":""},null,null,{"$f":"IF('BRCGS A&B'!B64=\"X\",'BRCGS A&B'!A64,\"\")","v":""}]
["Justification for deviation: (an increase of the duration) e.g. the type of broker services, the number and volume of products traded, the number of origin and destination countries the broker is trading with, the number of personnel, and the number of non-conformities.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('IFS Broker'!B53=\"X\",'IFS Broker'!A53,\"\")","v":""},null,null,{"$f":"IF('BRCGS A&B'!B65=\"X\",'BRCGS A&B'!A65,\"\")","v":""}]
["AMENDED AUDIT DURATION for IFS:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('IFS Broker'!B54=\"X\",'IFS Broker'!A54,\"\")","v":""},null,null,{"$f":"IF('BRCGS A&B'!B66=\"X\",'BRCGS A&B'!A66,\"\")","v":""}]
["Is there any need for a concession/approval from scheme owner for this audit?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('IFS Broker'!B55=\"X\",'IFS Broker'!A55,\"\")","v":""},null,null,{"$f":"IF('BRCGS A&B'!B67=\"X\",'BRCGS A&B'!A67,\"\")","v":""}]
["Combined Audit Factor (2 to 4 hrs) ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('IFS Broker'!B56=\"X\",'IFS Broker'!A56,\"\")","v":""},null,null,{"$f":"IF('BRCGS A&B'!B68=\"X\",'BRCGS A&B'!A68,\"\")","v":""}]
["Translator Presence (+ 20% minimum) ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('IFS Broker'!B57=\"X\",'IFS Broker'!A57,\"\")","v":""},null,null,{"$f":"IF('BRCGS A&B'!B69=\"X\",'BRCGS A&B'!A69,\"\")","v":""}]
["IFS Broker/ IFS Logistics min. audit duration 1.5 days",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('IFS Broker'!B58=\"X\",'IFS Broker'!A58,\"\")","v":""},null,null,{"$f":"IF('BRCGS A&B'!B70=\"X\",'BRCGS A&B'!A70,\"\")","v":""}]
["IFS Broker / IFS Product Standard can reduce the total duration (calculated separately for the audit of each Standard) about maximum 0,5 days (4 hours).",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS A&B'!B71=\"X\",'BRCGS A&B'!A71,\"\")","v":""}]
["In the case of auditing multi-location companies with central management, the audit\nduration for each single trading site can be reduced to 4 hours if requirements have already been audited at the central managing site.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS A&B'!B72=\"X\",'BRCGS A&B'!A72,\"\")","v":""}]
["Additional time for Meeting FSMA Requirements (2 to 4 hrs) ",{"$f":"IF('BRCGS A&B'!B21=\"Yes\",\"X\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS A&B'!B73=\"X\",'BRCGS A&B'!A73,\"\")","v":""}]
["Additional time for any other reason (please descripe..)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS A&B'!B74=\"X\",'BRCGS A&B'!A74,\"\")","v":""}]
["TOTAL TIME DURATION (BRC/IFS):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS A&B'!B75=\"X\",'BRCGS A&B'!A75,\"\")","v":""}]
["Preparation Time (BRC 1-2 hrs/IFS 2 hrs) ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS A&B'!B76=\"X\",'BRCGS A&B'!A76,\"\")","v":""}]
["Report Time BRC (4 - 8 hrs)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS A&B'!B77=\"X\",'BRCGS A&B'!A77,\"\")","v":""}]
["Report Time IFS (min 4 hrs)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS A&B'!B78=\"X\",'BRCGS A&B'!A78,\"\")","v":""}]
["Travel Time",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS A&B'!B79=\"X\",'BRCGS A&B'!A79,\"\")","v":""}]
["Total Hours (BRC/IFS)",{"$f":"SUM(B31:C35)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS A&B'!B80=\"X\",'BRCGS A&B'!A80,\"\")","v":""}]
["Reviewed By","LDK/AK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS A&B'!B81=\"X\",'BRCGS A&B'!A81,\"\")","v":""}]
["Reviewed Date",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS A&B'!B82=\"X\",'BRCGS A&B'!A82,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS A&B'!B83=\"X\",'BRCGS A&B'!A83,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS A&B'!B84=\"X\",'BRCGS A&B'!A84,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS A&B'!B85=\"X\",'BRCGS A&B'!A85,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS A&B'!B86=\"X\",'BRCGS A&B'!A86,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS A&B'!B87=\"X\",'BRCGS A&B'!A87,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS A&B'!B88=\"X\",'BRCGS A&B'!A88,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS A&B'!B89=\"X\",'BRCGS A&B'!A89,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS A&B'!B90=\"X\",'BRCGS A&B'!A90,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS A&B'!B91=\"X\",'BRCGS A&B'!A91,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS A&B'!B92=\"X\",'BRCGS A&B'!A92,\"\")","v":""}]

{"sheet":"Appl. Review Logistics","index":20,"n_rows":48,"n_cols":26,"rows_kept":48,"cut":false,"hidden":true,"merged":[[47,1,47,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[42,1,42,2],[43,1,43,2],[44,1,44,2],[45,1,45,2],[46,1,46,2],[40,1,40,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[41,1,41,2],[0,0,0,2],[1,0,1,2],[11,0,11,2],[5,4,6,4],[5,5,6,5],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[5,6,6,6],[3,7,6,8],[0,7,2,8],[0,9,2,9],[3,9,6,9]]}
["Application Review IFS Logistics & BRCGS Storage and Distribution - Q-CERT USE ONLY",null,null,null,"Previous BRCGS/IFS audits","Auditor (BRCGS)","Auditor (IFS)","Is there any need for a concession from the scheme owner for the audit team, e.g. use of a technical expert, 4th consecutive audit for the same auditor?",null,"No",null,null,null,null,null,null,null,null,null,null,null,null,"BRCGS S&D CATEGORIES ","IFS logistics service activities","IFS LOGISTICS SCOPES","Yes"]
["BRCGS Storage and Distribution - Audit Duration \n(Minimum audit duration 8 hours and shall not exceed the maximum of 10 hours per day)\nA ‘typical’ operation is considered to be where the scope of the operation is simple storage (storage area <25000m2) and distribution(<25 vehicles); product types are chilled, frozen and/or ambient; with ≤50 staff on site.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS S&D'!B36=\"X\",'BRCGS S&D'!A36,\"\")","v":""},{"$f":"IF('IFS LOGISTICS'!B16=\"X\",'IFS LOGISTICS'!A16,\"\")","v":""},{"$f":"IF('IFS LOGISTICS'!B30=\"X\",'IFS LOGISTICS'!A30,\"\")","v":""},"No"]
["BRCGS S&D service activities (e.g. Storage, Distribution, Wholesale, Transport only)",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,W2:W14)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS S&D'!B37=\"X\",'BRCGS S&D'!A37,\"\")","v":""},{"$f":"IF('IFS LOGISTICS'!B17=\"X\",'IFS LOGISTICS'!A17,\"\")","v":""},{"$f":"IF('IFS LOGISTICS'!B31=\"X\",'IFS LOGISTICS'!A31,\"\")","v":""}]
["Size of the facility (warehouses, loading/unloading area, and offices combined)",{"$f":"'BRCGS S&D'!B12","v":0},null,null,null,null,null," If ‘’Yes’’, confirmation of concession is required, including date of concession granted before auditor allocation. No auditor allocation is possible without a positive concession from the scheme owner. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS S&D'!B38=\"X\",'BRCGS S&D'!A38,\"\")","v":""},{"$f":"IF('IFS LOGISTICS'!B19=\"X\",'IFS LOGISTICS'!A19,\"\")","v":""},{"$f":"IF('IFS LOGISTICS'!B32=\"X\",'IFS LOGISTICS'!A32,\"\")","v":""}]
["Max no. employees on main shift during busiest season including seasonal staff and drivers",{"$f":"'SITE INFORMATION'!D29","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS S&D'!B39=\"X\",'BRCGS S&D'!A39,\"\")","v":""},{"$f":"IF('IFS LOGISTICS'!B20=\"X\",'IFS LOGISTICS'!A20,\"\")","v":""},{"$f":"IF('IFS LOGISTICS'!B33=\"X\",'IFS LOGISTICS'!A33,\"\")","v":""}]
["Number of transport units involved (addit. time for more than 25 vehicles managed by the site, based on the size and type of vehicles)",{"$f":"'BRCGS S&D'!C9","v":0},null,null,"Proposed Auditor(s) for this year's audit ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS S&D'!B40=\"X\",'BRCGS S&D'!A40,\"\")","v":""},{"$f":"IF('IFS LOGISTICS'!B21=\"X\",'IFS LOGISTICS'!A21,\"\")","v":""},{"$f":"IF('IFS LOGISTICS'!B34=\"X\",'IFS LOGISTICS'!A34,\"\")","v":""}]
["More than one location (consider size and distance to any additional locations)\n(Min. 2 hours depending on size of site and operation + travel time)",{"$f":"'BRCGS S&D'!B6","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS S&D'!B41=\"X\",'BRCGS S&D'!A41,\"\")","v":""},{"$f":"IF('IFS LOGISTICS'!B22=\"X\",'IFS LOGISTICS'!A22,\"\")","v":""},{"$f":"IF('IFS LOGISTICS'!B35=\"X\",'IFS LOGISTICS'!A35,\"\")","v":""}]
["The complexity of the operation and associated risk - the interface/interaction between the site and other operations/departments; product flows and volumes at SKU; increased product types and product lines; the complexity of stock and inventory management processes e.g. case picking, pallet picking, inbound product profiles, and handling requirements; cross-docking completed at the main certificated site, trans-shipping. Where required this should be discussed and agreed between the site and CB.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS S&D'!B42=\"X\",'BRCGS S&D'!A42,\"\")","v":""},{"$f":"IF('IFS LOGISTICS'!B23=\"X\",'IFS LOGISTICS'!A23,\"\")","v":""},{"$f":"IF('IFS LOGISTICS'!B36=\"X\",'IFS LOGISTICS'!A36,\"\")","v":""}]
["MIMIMUM AUDIT DURATION BRCGS:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS S&D'!B43=\"X\",'BRCGS S&D'!A43,\"\")","v":""},{"$f":"IF('IFS LOGISTICS'!B24=\"X\",'IFS LOGISTICS'!A24,\"\")","v":""},{"$f":"IF('IFS LOGISTICS'!B37=\"X\",'IFS LOGISTICS'!A37,\"\")","v":""}]
["Justification for deviation min. 30% \ninitial audit, communication difficulties, a large number of non-conformities at the last audit, difficulties experienced during the audit requiring further investigation, the quality of company preparation, e.g. documentation, HARA or HACCP, QMS, sites applying only for distribution or storage, limited product, and process diversity, ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS S&D'!B44=\"X\",'BRCGS S&D'!A44,\"\")","v":""},{"$f":"IF('IFS LOGISTICS'!B25=\"X\",'IFS LOGISTICS'!A25,\"\")","v":""},{"$f":"IF('IFS LOGISTICS'!B38=\"X\",'IFS LOGISTICS'!A38,\"\")","v":""}]
["AMENDED AUDIT DURATION for BRCGS:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS S&D'!B45=\"X\",'BRCGS S&D'!A45,\"\")","v":""},{"$f":"IF('IFS LOGISTICS'!B26=\"X\",'IFS LOGISTICS'!A26,\"\")","v":""},{"$f":"IF('IFS LOGISTICS'!B39=\"X\",'IFS LOGISTICS'!A39,\"\")","v":""}]
["IFS Logistic audit duration (A min. audit duration shall be 8 hrs)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS S&D'!B46=\"X\",'BRCGS S&D'!A46,\"\")","v":""},{"$f":"IF('IFS LOGISTICS'!B27<>\"\",'IFS LOGISTICS'!B27,\"\")","v":""},{"$f":"IF('IFS LOGISTICS'!B40=\"X\",'IFS LOGISTICS'!A40,\"\")","v":""}]
["IFS Logistics service activities (e.g. storage, transport)",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,X2:X12)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS S&D'!B47=\"X\",'BRCGS S&D'!A47,\"\")","v":""},null,{"$f":"IF('IFS LOGISTICS'!B41=\"X\",'IFS LOGISTICS'!A41,\"\")","v":""}]
["Size of the facility (warehouses, loading/unloading area, and offices combined)",{"$f":"'IFS LOGISTICS'!B12","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('BRCGS S&D'!B48=\"X\",'BRCGS S&D'!A48,\"\")","v":""},null,{"$f":"IF('IFS LOGISTICS'!B42=\"X\",'IFS LOGISTICS'!A42,\"\")","v":""}]
["Type of services offered (e.g. group categories)",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,Y2:Y27)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('IFS LOGISTICS'!B43=\"X\",'IFS LOGISTICS'!A43,\"\")","v":""}]
["Number of transport units involved",{"$f":"'IFS LOGISTICS'!C9","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('IFS LOGISTICS'!B44=\"X\",'IFS LOGISTICS'!A44,\"\")","v":""}]
["Number of storage units involved",{"$f":"'IFS LOGISTICS'!B13","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('IFS LOGISTICS'!B45=\"X\",'IFS LOGISTICS'!A45,\"\")","v":""}]
["Total number of employees (part-time workers, shift workers, temporary staff, administrative people, etc.)",{"$f":"'SITE INFORMATION'!D28","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('IFS LOGISTICS'!B46=\"X\",'IFS LOGISTICS'!A46,\"\")","v":""}]
["The number of non-conformities identified during previous audits",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('IFS LOGISTICS'!B47=\"X\",'IFS LOGISTICS'!A47,\"\")","v":""}]
["MIMIMUM REQUIRED AUDIT DURATION IFS:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('IFS LOGISTICS'!B48=\"X\",'IFS LOGISTICS'!A48,\"\")","v":""}]
["Justification for deviation (a reduction of the audit duration to 6 hrs is possible, only in\nthe following cases): If there are not more than 50 employees, \nIf only one service (transport or storage) or only one kind of handling (e.g. chilled/frozen) is performed, or if only one product group is handled,\nIn the case of auditing multi-site companies with central management, the audit duration\nfor each single site can be reduced to 0,5 day, if requirements have already been\naudited at the central managing site ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('IFS LOGISTICS'!B49=\"X\",'IFS LOGISTICS'!A49,\"\")","v":""}]
["AMENDED AUDIT DURATION for IFS:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('IFS LOGISTICS'!B50=\"X\",'IFS LOGISTICS'!A50,\"\")","v":""}]
["Combined Audit Factor (2 to 4 hrs) ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('IFS LOGISTICS'!B51=\"X\",'IFS LOGISTICS'!A51,\"\")","v":""}]
["Translator Presence (+ 20% minimum) ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('IFS LOGISTICS'!B52=\"X\",'IFS LOGISTICS'!A52,\"\")","v":""}]
["IFS Broker/ IFS Logistics min audit duration 1,5 days",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('IFS LOGISTICS'!B53=\"X\",'IFS LOGISTICS'!A53,\"\")","v":""}]
["Addition of Section 9 Handling of open food products - 1- 2 hours",{"$f":"IF('BRCGS S&D'!B15<>\"\",'BRCGS S&D'!B15,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('IFS LOGISTICS'!B54=\"X\",'IFS LOGISTICS'!A54,\"\")","v":""}]
["Addition of Section 10 Wholesale Module - 10.2 Branded products only: 1- 2 hours",{"$f":"IF('BRCGS S&D'!B16<>\"\",'BRCGS S&D'!B16,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('IFS LOGISTICS'!B55<>\"\",'IFS LOGISTICS'!B55,\"\")","v":""}]
["Addition of Section 10 Wholesale Module - 10.3 Wholesaler-own, wholesaler-exclusive and/or customer-exclusive products only: 3- 4 hours",{"$f":"IF('BRCGS S&D'!B17<>\"\",'BRCGS S&D'!B17,\"\")","v":""}]
["Addition of Section 10 Wholesale Module - combined 10.2 & 10.3: 4- 5 hours"]
["Section 11 Cross-docking module (Remote Offsite Location) - Min. 1 hour + travel time/ addit. site",{"$f":"IF('BRCGS S&D'!B18<>\"\",'BRCGS S&D'!B18,\"\")","v":""}]
["Section 12 E-commerce module - 1- 2 hours, addit. Activity",{"$f":"IF('BRCGS S&D'!B19<>\"\",'BRCGS S&D'!B19,\"\")","v":""}]
["Section 13 Contracted services modules (all services) - 1- 2 hours, addit. Activity",{"$f":"IF('BRCGS S&D'!B20<>\"\",'BRCGS S&D'!B20,\"\")","v":""}]
["Section 14 Product inspection - 1- 2 hours, addit. Activity",{"$f":"IF('BRCGS S&D'!B21<>\"\",'BRCGS S&D'!B21,\"\")","v":""}]
["Section 15 Contract packing (repacking, assembly packing) - 1- 2 hours, addit. Activity",{"$f":"IF('BRCGS S&D'!B22<>\"\",'BRCGS S&D'!B22,\"\")","v":""}]
["Section 16 Quantity control inspection - 1- 2 hours, addit. Activity",{"$f":"IF('BRCGS S&D'!B23<>\"\",'BRCGS S&D'!B23,\"\")","v":""}]
["Section 17 Contract chilling/freezing/ tempering/defrosting and high pressure process operations - 1- 2 hours, addit. Activity",{"$f":"IF('BRCGS S&D'!B24<>\"\",'BRCGS S&D'!B24,\"\")","v":""}]
["Section 18 Contract cleaning of baskets, roll cages and other distribution containers - 1- 2 hours, addit. Activity",{"$f":"IF('BRCGS S&D'!B25<>\"\",'BRCGS S&D'!B25,\"\")","v":""}]
["Section 19 Waste recovery and recycling - 1- 2 hours, addit. Activity",{"$f":"IF('BRCGS S&D'!B26<>\"\",'BRCGS S&D'!B26,\"\")","v":""}]
["Ethical Trade & Responsible Sourcing (ETRS) Risk Assessment - 4 hours",{"$f":"IF('BRCGS S&D'!B27<>\"\",'BRCGS S&D'!B27,\"\")","v":""}]
["Additional time for any other reason (please descripe..)"]
["TOTAL TIME DURATION (BRCGS/IFS):"]
["Preparation Time (BRCGS 1-2 hrs/IFS 2 hrs) "]
["Report Time BRCGS (4 - 8 hrs)"]
["Report Time IFS (min 4 hrs)"]
["Travel Time"]
["Total Hours (BRCGS/IFS)",{"$f":"SUM(B41:C45)","v":0}]
["Reviewed By","LDK/AK"]
["Reviewed Date"]

{"sheet":"Appl. Review GFCP standalone","index":21,"n_rows":17,"n_cols":2,"rows_kept":17,"cut":false,"hidden":true,"merged":[[0,0,0,1],[1,0,1,1]]}
["Application Review Standalone GFCP - Q-CERT USE ONLY"]
["Standalone GFCP Audit Duration\n(Audit duration shall be 1.5 to 2 days)"]
["Number of HACCP Studies (categories in case of similar HACCP plans)",{"$f":"'Glutten-Free '!B5","v":0}]
["Size of the manufacturing facility - production and storage (in square meters)",{"$f":"SUM('SITE INFORMATION'!E24:E26)","v":0}]
["Maximum number of employees operating in main shift (management, production, including seasonal workers)",{"$f":"'SITE INFORMATION'!D29","v":0}]
["MINIMUM AUDIT DURATION BRCGS:"]
["Justification for deviation (no more than 30%) e.g., initial audit, the complexity of the manufacturing process, number of product lines, size and age of site and impact on material flow, labour-intensity of processes, communication difficulties, the number of non-conformities, difficulties experienced during the audit requiring further investigation, the quality of company preparation, additional storage facilities, locations or head office assessments included within the audit process"]
["AMENDED AUDIT DURATION for BRCGS:"]
["Translator Presence + 20% minimum (if applicable)"]
["Additional time for any other reason (please descripe..)"]
["TOTAL TIME DURATION (BRCGS/IFS):"]
["Preparation Time (1-2 hrs)"]
["Report Time  (4 - 8 hrs)"]
["Travel Time Round trip"]
["Total Hours ",{"$f":"SUM(B11:B14)","v":0}]
["Reviewed By","LDK/AK"]
["Reviewed Date"]

{"sheet":"Review Plant-Based standalone","index":22,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":true,"merged":[[0,0,0,1],[1,0,1,1]]}
["Application Review Standalone Plant-Based - Q-CERT USE ONLY"]
["Standalone Plant-Based Audit Duration\n(Audit duration shall be 1 day)"]
["Standalone Plant-Based "]
["Translator Presence + 20% minimum (if applicable)"]
["Additional time for any other reason (please descripe..)"]
["TOTAL TIME DURATION:"]
["Preparation Time (1-2 hrs)"]
["Report Time  (4 - 8 hrs)"]
["Travel Time Round trip"]
["Total Hours ",{"$f":"SUM(B6:B9)","v":0}]
["Reviewed By","LDK/AK"]
["Reviewed Date"]

{"sheet":"Review IFS ESG Check","index":23,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":true,"merged":[[0,0,0,1],[1,0,1,1]]}
["Application Review IFS ESG CHECK - Q-CERT USE ONLY"]
["IFS ESG Check Audit Duration\n(Audit duration shall be 1 day)"]
["Only ESG Check (main module): a minimum of 2 to 4 hours"]
["ESG Check plus one additional module: a minimum of 4  up to 6 hours"]
["Additional extra module: 2 hours up to 4 hours"]
["Translator Presence + 20% minimum (if applicable)"]
["Additional time for any other reason (please descripe..)"]
["TOTAL TIME DURATION:"]
["Preparation Time (1 hr) "]
["Report Time (1,5 hrs)"]
["Travel Time Round trip"]
["Total Hours",{"$f":"SUM(B8:B11)","v":0}]
["Reviewed By","LDK/AK"]
["Reviewed Date"]