{"text_format":"1","workbook":"xlsx","n_sheets":38,"sheets":["Data Input Tab","Table of Content","Barcode Labels - Each","Barcode Labels - Package","Serial No","DD250","DD1222","QA 011 - Packing List","QA 012 - Final Accept-CoC","QA 012-1 - Special - CoC","QA 012-2 - Special - CoC","QA 012-3 Prime & Paint CoC","QA 013 - Contract Review","QA 015a - Top Assy","QA 015b - Det-Sub Assy","QAP 111 AQL","Packaging Instructions","RFP Mailing Template","831 Test Report - Cover Page","831 - Table of Content","831 - Appendix","831 Test Report Tech Data Cert","QA 001 CAR","QA 002 Audit","QA 005 QDR","QA 009 FAI","Commercial Invoice","QA 011-Com - Packing List","QA 010 QCP","ME 001 SOP","DDC Shpg Inst Reqt","Discount Extension Request","TDP CDRL","Packaging Waiver Request","FAT Waiver Letter","VECP","Cost Breakdown","Images"],"not_rendered":{"charts":0,"images":85,"macros":1,"external_links":0,"defined_names":227,"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":"Data Input Tab","index":0,"n_rows":45,"n_cols":31,"rows_kept":45,"cut":false,"hidden":false,"merged":[[20,12,26,16],[33,3,33,6],[29,3,29,7],[26,5,26,7],[27,5,27,7],[27,3,27,4],[28,3,28,7],[26,3,26,4],[1,1,1,2],[1,6,1,7],[6,6,6,7],[5,6,5,7],[4,6,4,7],[3,6,3,7],[2,6,2,7],[3,3,3,4],[4,3,4,4],[5,3,5,4],[6,1,7,1],[7,3,7,4],[6,3,6,4],[41,1,42,1],[37,1,40,1],[25,5,25,7],[20,5,20,6],[24,5,24,6],[29,1,30,1],[30,2,30,3],[25,3,25,4],[22,5,22,6],[23,5,23,6],[21,5,21,6],[37,3,37,4],[37,5,38,7],[36,3,36,7],[35,3,35,7],[0,14,7,16],[7,6,7,7],[8,6,8,7],[10,8,13,9],[10,6,11,7],[9,6,9,7],[12,5,12,7],[13,5,13,7],[13,13,17,16],[16,10,17,11],[15,5,15,7],[17,5,17,6],[18,5,18,6],[14,5,14,6],[16,5,16,7],[12,12,12,17],[9,3,9,5],[12,3,12,4],[17,8,19,8],[18,13,18,16],[18,3,18,4],[19,5,19,6],[17,3,17,4],[14,3,14,4]]}
[null,null,null,null,null,null,null,null,"QA Data Record Rel 36c"]
[null,"Part & Contract Information",null,null,"Manufacturer Info: -->",null,"Industrial Welding & Engineering",null,"<-Company Drop-Down",null,null,null,null,null,null,null,null,null,null,null,{"$f":"OR(TDPFAT=\"FAT Package\",CLIN0001>=9000,B19=\"TE\",B19=\"Qty\")","v":false}]
[]
[null,"CUSTOMER",null,"For Commercial only",null,null,{"$f":"VLOOKUP(Company, CompanyTable, 2, FALSE)","v":"747 Carle Ave."},null,"<-Street",null,null,null,null,null,null,null,null,null,null,null,null,null,"Company","Address","State","Phone","Fax","Email","Web","Cage","Shpg Prefix"]
[null,"v-Blk #7 DoDACC Code-v","Ship to Address",null,null,null,{"$f":"VLOOKUP(Company, CompanyTable, 3, FALSE)","v":"Lewis Center, OH 43035"},null,"<-State",null,null,null,null,null,null,null,null,null,null,null,null,"Select Code A, B or C","MTC Engineering","747 Carle Ave.","Lewis Center, OH 43035","614-657-8666","614-540-7442","mtcengineering@att.net","www.mtcengco.com","3BTS1","MTC"]
[null,null,"Ship to State",null,null,null,{"$f":"VLOOKUP(Company, CompanyTable, 4, FALSE)","v":"614-883-6109"},null,"<-Phone",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(DoDACC=\"S3605A\",1,\" \")","v":" "},"A","Industrial Welding & Engineering","747 Carle Ave.","Lewis Center, OH 43035","614-883-6109","email only","iwe@columbus.rr.com","www.iweohio.com","3NBK9","IWE"]
[null,{"$f":"IF(U9<2,\"Check DoDAAC Code for Error.\",\"DoDAAC Good\")","v":"Check DoDAAC Code for Error."},"Customer Phone",null,null,null,{"$f":"VLOOKUP(Company, CompanyTable, 5, FALSE)","v":"email only"},null,"<-Fax:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(DoDACC=\"S0512A\",1,\" \")","v":" "},"B","MTC Engineering, LLC","747 Carle Ave.","Lewis Center, OH 43035","614-657-8666","614-540-7442","mtcengllc@att.net","www.mtcengco.com","5TVD6","MTC"]
[null,null,"Customer PO-->:",null,null,null,{"$f":"VLOOKUP(Company, CompanyTable, 6, FALSE)","v":"iwe@columbus.rr.com"},null,"<-Email:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(InspectPoint=\"S\",1,\" \")","v":" "},"C","Alannas Engineer","9710-A Owensmouth Ave.","Chatsworth, CA 91311","818-701-1522","818-701-0316","alannasengineer@yahoo.com",null,"5KBD7","ALE"]
[null,{"$f":"IF(TDPFAT<>\"TDP Package\",\"GOV CONTRACT #-->:\",\"SOLICITATION #-->:\")","v":"GOV CONTRACT #-->:"},null,null,null,null,{"$f":"VLOOKUP(Company, CompanyTable, 7, FALSE)","v":"www.iweohio.com"},null,"<-Website:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U6:U8)","v":0},null,"LCG Machine & Tool","2923 Grasemere Ave.","Columbus, OH 43224","614-261-1651","614-447-8051","sales@lcgmachine.com","www.lcgmachine.com","4HYL7","LCG"]
[null,"Blk #6 PCO (Email) --->:",null,"<---Click link to send email to PCO.",null,null,{"$f":"VLOOKUP(Company, CompanyTable, 8, FALSE)","v":"3NBK9"},null,"<-Cage Code:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"~QA \"&WO&\" (\"&NSN&\")\"","v":"~QA  ()"},null,"Westerville Mfg","935 Schrock Road","Columbus, OH 43229","614-888-9088","614-888-9188","wmfginc@sbcglobal.net","www.wmfginc.com","7Y162","WMFG"]
[null,{"$f":"IF(TDPFAT<>\"TDP Package\",\"Contract Issue Date:\",\"Solicitation Due Date:\")","v":"Contract Issue Date:"},null,null,null,null,"Please set TDP or FAT with drop-down",null,"<-Drop-down list for TDP / FAT Package only. Leave blank for Source/Destination shipments",null,null,null,null,null,null,null,null,null,null,null,"For Barcode- No (-)'s ->",{"$f":"SUBSTITUTE(C9,\"-\",\"\")","v":""},"Boehm Machine","1297 Memory Lane, N","Columbus, OH 43209","614-252-3778","614-237-5262","gkboehm@wideopenwest.com",null,"1P723","GKT"]
[null,"Criticality (Priority) Codes:","Select Code A, B or C","Block #5","Priority Code",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FOLDER LIST",null,"RC Industries, Inc.","7755 Alabama Ave., Ste 6/8","Canoga Park, CA 91304","818-883-0855","818-883-2537","rcind@sbcglobal.net","www.rcingcorp.com","6CH54","RCI"]
[null,"NSN---->:",null,"<---Include (-) Dash's",null,{"$f":"IF(TDPFAT=\"TDP Package\", \"(Est) FAT DUE DATE\",\"FAT DUE DATE\")","v":"FAT DUE DATE"},null,null,null,null,null,null,"<--Double click to open DD1694 form.",null,null,null,null,null,null,null,"DRAWINGS","Please set TDP or FAT with drop-down","DSE Development","747 Carle Ave.","Lewis Center, OH 43035","614-843-5523","email only","dse.ohio@hotmail.com",null,"713G7","DSE"]
[null,"PART NAME:",null,"Days FAT Due:",null,{"$f":"IF(E14>=30,DwgRvw+E14,\"\")","v":""},null,null,null,null,null,null,"<- - - -","NOTE: Numbering should begin with \"D\" for Pre-Production or \"W\" for Post-Production. Example: D (Job #-Contract last 4) i.e. Pre-Production for Job 1056, contract ending with E562 would be numbered as:",null,null,null,null,null,null,"PO","TDP Package","DuLond Tool & Engineering, Inc.","2306 Whitfield Park Loop","Sarasota, FL 34243","941-758-4489","941-753-5592","gbrunette@dulondtool.com","www.dulondtool.com","9M680","DTE"]
[null,"(Drawing)/ Part Number:",null,"<---Include (-) Dash #",null,"FAT Cost--->",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PROJECT MANAGEMENT","FAT Package","Maven Engineering Corporation","15946 Derwood Rd.","Rockville, MD 20855","301-519-3400","301-947-6271","sales@mavencorporation.com","www.mavencorporation.com","46YF5","MAV"]
[null,"REV (or NC for No Chg):",null,null,null,{"$f":"IF(TDPFAT=\"TDP Package\", \"(Est) DELIVERY DUE DATE\",\"DELIVERY DUE DATE\")","v":"DELIVERY DUE DATE"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"QUALITY",null,"ADJ Finishing","7845 Gloria Ave.","Van Nuys, CA 91406","818-786-5131","818-786-6165","adjfinishing@hotmail.com","www.adjfinishing.com","6NVY2","ADJ"]
[null,"FSCM (Design Cage):",null,"Unit Wt (Lbs):",null,null,null,null,null,null,"§ - DD1694 Instructions",null,null,null,null,null,null,null,null,null,"RFQ",null,"Lewis Center Mfg.","747 Carle Ave.","Lewis Center, OH 43035","614-560-6122","614-737-9320","Lewiscentermfg@gmail.com","Www.lewiscentermfg.com","6QCA7","LCM"]
[null,{"$f":"IF(TDPFAT<>\"TDP Package\",\"WO (Job Number)\",\"RFQ/RFP reference #\")","v":"WO (Job Number)"},null,"Weight is needed for label printing",null,"Unit Cost--->",null,null,{"$f":"IF(FastPay=\"Fast Pay\", \"Check for TCN-FMS WAWF Invoice Only\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,"Shipping",null,"Fourply Design House","747 Carle Ave.","Lewis Center, OH 43035","910-381-3110","614-737-9320","Njsanna@fourplydesign.com","www.fourplydesign.com","6Q2Z8","FDH"]
[null,{"$f":"IF(TDPFAT<=\"FAT Package\",\"Enter TE QTY = 1\",\"QTY (Total parts to Ship)\")","v":"QTY (Total parts to Ship)"},null,{"$f":"IF(TDPFAT<=\"FAT Package\",\"<=Enter the TE QTY as 1\",\"<=Enter the Total Qty to ship\")","v":"<=Enter the Total Qty to ship"},null,"Fast Pay?->",null,null,null,null,null,null,null,"D1056E562",null,null,null,null,null,null,"For Barcode- No (-)'s ->",{"$f":"SUBSTITUTE(C13,\"-\",\"\")","v":""},"GTA Containers Inc.","4201 Linden Ave.","South Bend, IN.  46619","574-288-3459","574-288-1997","victoria@gtacontainers.com","www.gtacontainers.com","1YFX5","GTA"]
[null,{"$f":"UPPER(IF(TDPFAT=\"FAT Package\",\"^_Enter TE Qty, Not Ship Qty_^\",\"\"))","v":""},"v---CLIN---v","Packaged QUP",{"$f":"IF(TDPFAT<=\"FAT Package\",\"# Units per TE\",\"QUP per Box\")","v":"QUP per Box"},"Boxes / Shipment",null,"Ship-to Code",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Acromil Corp.","18421 Railroad St.","City of Industry, CA 91748","626-694-2522","626-810-6100","jkonheim@acromil.com","www.acromil.com","4F112","ACI"]
[null,{"$f":"IF(TDPFAT=\"FAT Package\",\"Enter FAT CLIN (WT: \"&WT*Unit_Qty*Qty_Packages&\")\",\"CLIN (WT: \"&WT*Unit_Qty*Qty_Packages&\")\")","v":"CLIN (WT: 0)"},null,null,null,null,null,null,{"$f":"VLOOKUP(FAT_Code, ShipCodeTable, 2,FALSE )","v":{"$error":"#N/A"}},null,null,null,"NOTE: ALL SHADED BOXES ON THIS PAGE ARE REQUIRED FOR AUTO-LOAD FEATURE TO WORK ON ADDITIONAL SHEETS IN THIS WORKBOOK.",null,null,null,null,null,null,null,null,"Fast Pay","C. O. W. Industries, Inc.","1875 Progress Ave.","Columbus, OH 43207","614-445-5516","614-443-5530","james.dailey@cowind.com","www.cowind.com","73320/5A106","COW"]
[null,{"$f":"IF(TDPFAT=\"FAT Package\",\"Prod CLIN (WT: \"&WT*Unit_Qty_2*Qty_Packages_2&\")\",\"CLIN (WT: \"&WT*Unit_Qty_2*Qty_Packages_2&\")\")","v":"CLIN (WT: 0)"},null,null,null,null,null,null,{"$f":"VLOOKUP(Ship_2, ShipCodeTable, 2, FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"IF(TDPFAT=\"FAT Package\",\"Prod CLIN (WT: \"&WT*Unit_Qty_3*Qty_Packages_3&\")\",\"CLIN (WT: \"&WT*Unit_Qty_3*Qty_Packages_3&\")\")","v":"CLIN (WT: 0)"},null,null,null,null,null,null,{"$f":"VLOOKUP(Ship_3, ShipCodeTable, 2, FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"IF(TDPFAT=\"FAT Package\",\"Prod CLIN (WT: \"&WT*Unit_Qty_4*Qty_Packages_4&\")\",\"CLIN (WT: \"&WT*Unit_Qty_4*Qty_Packages_4&\")\")","v":"CLIN (WT: 0)"},null,null,null,null,null,null,{"$f":"VLOOKUP(Ship_4, ShipCodeTable, 2, FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"IF(TDPFAT=\"FAT Package\",\"Prod CLIN (WT: \"&WT*Unit_Qty_5*Qty_Packages_5&\")\",\"CLIN (WT: \"&WT*Unit_Qty_5*Qty_Packages_5&\")\")","v":"CLIN (WT: 0)"},null,null,null,null,null,null,{"$f":"VLOOKUP(Ship_5, ShipCodeTable, 2, FALSE)","v":{"$error":"#N/A"}}]
[null,"(M) PRESERVE METHOD:",null,{"$f":"IF(PackageMethod=\"ASTM D3951\",\"ASTM D3951\",\"MIL-STD-2073-1D\")","v":"MIL-STD-2073-1D"},null,"<---MIL SPEC Pkg Reference (If noted)"]
[null,"INSPECTION POINT:",null,{"$f":"IF(InspectPoint=\"\",\"<--D=Dest, S=Origin, O=Other\",IF(InspectPoint=\"D\",\"<- Inspect @ Destination\", IF(InspectPoint=\"S\", \"<- Inspect @ Prime-Cage Loaction\",IF(InspectPoint=\"O\",\"<- Inspect @ Other Source location\",\"<Please select Inspect Point\"))))","v":"<--D=Dest, S=Origin, O=Other"},null,{"$f":"IF(InspectPoint=\"D\",\"<--(Section E - FAR 52.246-9007)\",\"<--(See Contract Section E for details)\")","v":"<--(See Contract Section E for details)"}]
[null,"ACCEPTANCE POINT:",null,{"$f":"IF(AcceptPoint=\"\",\"<--D=Dest, S=Origin, O=Other\",IF(AcceptPoint=\"D\",\"<- Accept Packing @ Destination\", IF(AcceptPoint=\"S\", \"<- Accept Packing @ Prime Loction\",IF(AcceptPoint=\"O\",\"<- Accept Packing @ Other-Alt location\",\"<Please select Accept Point\"))))","v":"<--D=Dest, S=Origin, O=Other"},null,{"$f":"IF(AcceptPoint=\"D\",\"<--(Section E - FAR 52.246-9007)\",\"<--(See Contract Section E for details)\")","v":"<--(See Contract Section E for details)"}]
[null,"CLIN FOB:",null,{"$f":"IF(FOB=\"\",\"<--D=Dest, S=Origin, O=Other\",IF(FOB=\"D\",\"<-  Vendor Paid Shipment\", IF(FOB=\"S\", \"<- Gov reimbursed or Gov pickup. SEE CONTRACT DETAILS\",IF(FOB=\"O\",\"<-  Ship from or Gov pickup @ alt location. SEE CONTRACT DETAILS\",\"<Please select FOB Point\"))))","v":"<--D=Dest, S=Origin, O=Other"}]
[null,{"$f":"IF(FOB=\"S\",\"CHECK SHIPPING CHARGE FOR WAWF\",IF(FOB=\"O\",\"CHECK SHIPPING CHARGE FOR WAWF\",\"\"))","v":""},null,"^-- Check Contract Section D for RFID requirement per FAR 52.246-7006-^"]
[null,null,"Job Master Schedule Summary"]
[null,"Activity","Date"]
[]
[null,"Inspector-Project Mgr Name:",null,"<--Project Manager Drop-Down menu"]
[]
[null,{"$f":"IF(TDPFAT=\"FAT Package\", \"FAT Requirements Review\",\"(FAI) First-Part Review:\")","v":"(FAI) First-Part Review:"},null,"<-- Fill in @ FAI inspection acceptance."]
[null,{"$f":"IF(TDPFAT=\"FAT Package\", \"(FAI) First-Part Review:\",\"(Production) Start Release:\")","v":"(Production) Start Release:"},null,"<-- Fill in AFTER FAI acceptance to authorize production run."]
[null,"MRB Action (If required)","CAR/QDR #:",null,null,"<--Use DCMA-QAS assigned number or WO-Contract Last 4"]
[null,null,"QDR Issue Date:"]
[null,null,"Rwk Date:"]
[null,null,"QDR Closed Date:"]
[null,"Corrective Action Summary (CAR)","CAR Issued"]
[null,null,"CAR Closed"]
[null,{"$f":"IF(TDPFAT=\"TDP Package\", \"(Est) QA Final Inspection:\",IF(TDPFAT=\"FAT Package\",\"(Est) FAT Final Inspection:\",\"(Est) Final Acceptance\"))","v":"(Est) Final Acceptance"}]
[null,"(Est) Ship Date:"]

{"sheet":"Table of Content","index":1,"n_rows":41,"n_cols":6,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,1,0,7],[2,1,2,7],[1,6,1,7]]}
[null,"QA  Contract Workbook"]
[]
[null,"TABLE OF CONTENT"]
[]
[null,"Tab 1","Input Data Tab",{"$f":"CHAR(214)","v":"Ö"},null,"To show a sheet, Put a check in the box"]
[]
[null,"Tab 2","Barcode Labels, Parts",null,null,"To hide a sheet, remove the check from the box."]
[]
[null,"Tab 3","Barcode Labels, Package",null,"VECP","VECP Form w/Performa"]
[]
[null,"Tab 4","DD250",null,"Tab 20","Packaging Waiver Request"]
[]
[null,"Tab 5","DD1222",null,"Tab 21","QA 001 CAR"]
[]
[null,"Tab 6 ","QA 011 - Packing List",null,"Tab 22","QA 002 Audit"]
[]
[null,"Tab 7","QA 012 - Final Accept-CoC",null,"Tab 23","QA 005 QDR"]
[]
[null,"Tab 8 ","QA 013 - Contract Review",null,"Tab 24","QA 009 FAI"]
[]
[null,"Tab 9","QA 015a - Top Assy",null,"Tab 25","QA 010 QCP"]
[]
[null,"Tab 10","QA 015b - Det-Sub Assy",null,"Tab 26","QAP 111 AQL"]
[]
[null,"Tab 11","831 Test Report - Cover Page",null,"Tab 27","ME 001 SOP"]
[]
[null,"Tab 12","831 Test Report T of C",null,"Tab 28","Serial Number Sheet"]
[]
[null,"Tab 13","831 Test Repory Appendix",null,"Tab 29","FAT Waiver Letter for TDP"]
[]
[null,"Tab 14","831 Test Report Tech Data Cert",null,"Tab 30","Commercial - Invoice"]
[]
[null,"Tab 15","QA 012-1 - Special - CoC",null,"Tab 31","Commercial - Packing List"]
[]
[null,"Tab 16","QA 012-2 - Special - CoC",null,"Tab 32","DDC Shpg Inst Reqt"]
[]
[null,"Tab 17","QA 012-3 Prime & Paint CoC",null,"Tab 33","(SAR)/TDP Cost Breakdown"]
[]
[null,"Tab 18","Packaging Instructions",null,"Tab 34","TDP CDRL"]
[]
[null,"Tab 19","RFP Mailing Label",null,"Tab 35","Discount Extension Request"]

{"sheet":"Barcode Labels - Each","index":2,"n_rows":55,"n_cols":17,"rows_kept":55,"cut":false,"hidden":false,"merged":[[44,6,44,8],[38,6,38,7],[39,5,39,7],[41,5,41,6],[42,7,42,8],[16,1,16,2],[49,1,49,2],[50,0,50,2],[52,0,52,1],[53,2,53,3],[32,0,32,3],[36,0,36,1],[47,0,47,1],[45,1,45,3],[43,0,43,3],[44,1,44,3],[38,1,38,2],[39,0,39,2],[41,0,41,1],[42,2,42,3],[21,0,21,3],[25,0,25,1],[25,5,25,6],[17,0,17,2],[5,1,5,2],[6,0,6,2],[8,0,8,1],[9,2,9,3],[20,2,20,3],[11,1,11,3],[16,6,16,7],[10,0,10,3],[12,1,12,3],[11,6,11,8],[12,6,12,8],[14,0,14,1],[5,6,5,7],[30,0,30,1],[31,2,31,3],[27,6,27,7],[28,5,28,7],[30,5,30,6],[31,7,31,8],[0,1,0,3],[0,6,0,8],[1,1,1,3],[1,6,1,8],[3,0,3,1],[3,5,3,6],[6,5,6,7],[8,5,8,6],[9,7,9,8],[54,5,54,8],[17,5,17,7],[14,5,14,6],[10,5,10,8],[49,6,49,7],[50,5,50,7],[52,5,52,6],[53,7,53,8],[32,5,32,8],[36,5,36,6],[47,5,47,6],[45,6,45,8],[43,5,43,8],[54,0,54,3],[12,10,12,13],[22,1,22,3],[22,6,22,8],[19,5,19,6],[20,7,20,8],[23,6,23,8],[23,1,23,3],[34,1,34,3],[34,6,34,8],[33,1,33,3],[33,6,33,8],[27,1,27,2],[21,5,21,8],[19,0,19,1],[28,0,28,2]]}
[null,{"$f":"NSN_2","v":""},null,null,null,null,{"$f":"NSN_2","v":""},null,null,null,null,null,null,null,null,null,{"$f":"\"001\"","v":"001"}]
[null,{"$f":"NSN_2","v":""},null,null,null,null,{"$f":"NSN_2","v":""},null,null,null,null,null,null,null,null,null,{"$f":"\"00\"&Q1+1","v":"002"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"00\"&Q2+1","v":"003"}]
[{"$f":"NSN","v":0},null,null,null,null,{"$f":"NSN","v":0},null,null,null,null,null,null,null,null,null,null,"004"]
["CAGE",{"$f":"UPPER(Cage)","v":"3NBK9"},"CDA",{"$f":"FSCM","v":0},null,"CAGE",{"$f":"UPPER(Cage)","v":"3NBK9"},"CDA",{"$f":"FSCM","v":0},null,null,null,null,null,null,null,"005"]
["PN",{"$f":"PN","v":0},null,null,null,"PN",{"$f":"PN","v":0},null,null,null,null,null,null,null,null,null,"006"]
[{"$f":"PROPER(Name)","v":""},{"$f":"UPPER(IF(A7>1,\"Per Pack\",\"EA\"))","v":"PER PACK"},null,null,null,{"$f":"PROPER(Name)","v":""},{"$f":"UPPER(IF(F7>1,\"Per Pack\",\"EA\"))","v":"PER PACK"},null,null,null,null,null,null,null,null,null,"007"]
[{"$f":"Unit_Qty","v":0},{"$f":"(IF(A8>1,\"Per Pack\",\"EA\"))","v":"EA"},{"$f":"IF(M11<1,\"\",\"S/N\")","v":""},{"$f":"IF(M11>=1,REPLACE(Contract,1,12,)&Q1,\"\")","v":""},null,{"$f":"IF(Unit_Qty_2>1,Unit_Qty_2,Unit_Qty)","v":0},{"$f":"(IF(F8>1,\"Per Pack\",\"EA\"))","v":"EA"},{"$f":"IF(M11<1,\"\",\"S/N\")","v":""},{"$f":"IF(M11>=1,REPLACE(Contract,1,12,)&Q2,\"\")","v":""},null,null,null,null,null,null,null,"008"]
[{"$f":"UPPER(Contract)","v":""},null,null,null,null,{"$f":"UPPER(Contract)","v":""},null,null,null,null,null,null,null,null,null,null,"009"]
[null,{"$f":"MCode&\" - \"","v":" - "},{"$f":"ShipDate","v":"00:00:00"},null,null,null,{"$f":"MCode&\" - \"","v":" - "},{"$f":"ShipDate","v":"00:00:00"},null,null,null,null,null,null,null,null,{"$f":"\"0\"&Q9+1","v":"010"}]
[{"$f":"IF(TDPFAT=\"FAT Package\",\"FIRST ARTICLE TEST - DO NOT POST\",IF(M12>0,N12,\"\"))","v":""},null,null,null,null,{"$f":"IF(TDPFAT=\"FAT Package\",\"FIRST ARTICLE TEST - DO NOT POST\",IF(M12>0,N12,\"\"))","v":""},null,null,null,null,null,"Serialization:",null,"<-- \"X\" will serialize Labels",null,null,{"$f":"\"0\"&Q10+1","v":"011"}]
[null,{"$f":"NSN_2","v":""},null,null,null,null,{"$f":"NSN_2","v":""},null,null,null,null,"Mark Labels->\"X\":",null,"\"FOR MILITARY USE ONLY\"",null,null,"012"]
[null,{"$f":"NSN_2","v":""},null,null,null,null,{"$f":"NSN_2","v":""},null,null,null,"^--- NOTE: DO NOT USE WITH FAT ---^",null,null,null,null,null,"013"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"014"]
[{"$f":"NSN","v":0},null,null,null,null,{"$f":"NSN","v":0},null,null,null,null,null,null,null,null,null,null,"015"]
["CAGE",{"$f":"UPPER(Cage)","v":"3NBK9"},"CDA",{"$f":"FSCM","v":0},null,"CAGE",{"$f":"UPPER(Cage)","v":"3NBK9"},"CDA",{"$f":"FSCM","v":0},null,null,null,null,null,null,null,"016"]
["PN",{"$f":"PN","v":0},null,null,null,"PN",{"$f":"PN","v":0},null,null,null,null,null,null,null,null,null,"017"]
[{"$f":"PROPER(Name)","v":""},{"$f":"UPPER(IF(A18>1,\"Per Pack\",\"EA\"))","v":"PER PACK"},null,null,null,{"$f":"PROPER(Name)","v":""},{"$f":"UPPER(IF(F18>1,\"Per Pack\",\"EA\"))","v":"PER PACK"},null,null,null,null,null,null,null,null,null,"018"]
[{"$f":"IF(Unit_Qty_3>1,Unit_Qty_3,Unit_Qty)","v":0},{"$f":"(IF(A19>1,\"Per Pack\",\"EA\"))","v":"EA"},{"$f":"IF(M11<1,\"\",\"S/N\")","v":""},{"$f":"IF(M11>=1,REPLACE(Contract,1,12,)&Q3,\"\")","v":""},null,{"$f":"IF(Unit_Qty_4>1,Unit_Qty_4,Unit_Qty)","v":0},{"$f":"(IF(F19>1,\"Per Pack\",\"EA\"))","v":"EA"},{"$f":"IF(M11<1,\"\",\"S/N\")","v":""},{"$f":"IF(M11>=1,REPLACE(Contract,1,12,)&Q4,\"\")","v":""},null,null,null,null,null,null,null,"019"]
[{"$f":"UPPER(Contract)","v":""},null,null,null,null,{"$f":"UPPER(Contract)","v":""},null,null,null,null,null,null,null,null,null,null,"020"]
[null,{"$f":"MCode&\" - \"","v":" - "},{"$f":"ShipDate","v":"00:00:00"},null,null,null,{"$f":"MCode&\" - \"","v":" - "},{"$f":"ShipDate","v":"00:00:00"},null,null,null,null,null,null,null,null,"021"]
[{"$f":"IF(TDPFAT=\"FAT Package\",\"FIRST ARTICLE TEST - DO NOT POST\",IF(M23>0,N23,\"\"))","v":""},null,null,null,null,{"$f":"IF(TDPFAT=\"FAT Package\",\"FIRST ARTICLE TEST - DO NOT POST\",IF(R23>0,S23,\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"\"0\"&Q21+1","v":"022"}]
[null,{"$f":"NSN_2","v":""},null,null,null,null,{"$f":"NSN_2","v":""}]
[null,{"$f":"NSN_2","v":""},null,null,null,null,{"$f":"NSN_2","v":""}]
[]
[{"$f":"NSN","v":0},null,null,null,null,{"$f":"NSN","v":0}]
["CAGE",{"$f":"UPPER(Cage)","v":"3NBK9"},"CDA",{"$f":"FSCM","v":0},null,"CAGE",{"$f":"UPPER(Cage)","v":"3NBK9"},"CDA",{"$f":"FSCM","v":0}]
["PN",{"$f":"PN","v":0},null,null,null,"PN",{"$f":"PN","v":0}]
[{"$f":"PROPER(Name)","v":""},{"$f":"UPPER(IF(A29>1,\"Per Pack\",\"EA\"))","v":"PER PACK"},null,null,null,{"$f":"PROPER(Name)","v":""},{"$f":"UPPER(IF(F29>1,\"Per Pack\",\"EA\"))","v":"PER PACK"}]
[{"$f":"IF(Unit_Qty_5>1,Unit_Qty_5,Unit_Qty)","v":0},{"$f":"(IF(A30>1,\"Per Pack\",\"EA\"))","v":"EA"},{"$f":"IF(M11<1,\"\",\"S/N\")","v":""},{"$f":"IF(M11>=1,REPLACE(Contract,1,12,)&Q5,\"\")","v":""},null,{"$f":"Unit_Qty","v":0},{"$f":"(IF(F30>1,\"Per Pack\",\"EA\"))","v":"EA"},{"$f":"IF(M11<1,\"\",\"S/N\")","v":""},{"$f":"IF(M11>=1,REPLACE(Contract,1,12,)&Q6,\"\")","v":""}]
[{"$f":"UPPER(Contract)","v":""},null,null,null,null,{"$f":"UPPER(Contract)","v":""}]
[null,{"$f":"MCode&\" - \"","v":" - "},{"$f":"ShipDate","v":"00:00:00"},null,null,null,{"$f":"MCode&\" - \"","v":" - "},{"$f":"ShipDate","v":"00:00:00"}]
[{"$f":"IF(TDPFAT=\"FAT Package\",\"FIRST ARTICLE TEST - DO NOT POST\",IF(M34>0,N34,\"\"))","v":""},null,null,null,null,{"$f":"IF(TDPFAT=\"FAT Package\",\"FIRST ARTICLE TEST - DO NOT POST\",IF(R34>0,S34,\"\"))","v":""}]
[null,{"$f":"NSN_2","v":""},null,null,null,null,{"$f":"NSN_2","v":""}]
[null,{"$f":"NSN_2","v":""},null,null,null,null,{"$f":"NSN_2","v":""}]
[]
[{"$f":"NSN","v":0},null,null,null,null,{"$f":"NSN","v":0}]
["CAGE",{"$f":"UPPER(Cage)","v":"3NBK9"},"CDA",{"$f":"FSCM","v":0},null,"CAGE",{"$f":"UPPER(Cage)","v":"3NBK9"},"CDA",{"$f":"FSCM","v":0}]
["PN",{"$f":"PN","v":0},null,null,null,"PN",{"$f":"PN","v":0}]
[{"$f":"PROPER(Name)","v":""},{"$f":"UPPER(IF(A40>1,\"Per Pack\",\"EA\"))","v":"PER PACK"},null,null,null,{"$f":"PROPER(Name)","v":""},{"$f":"UPPER(IF(F40>1,\"Per Pack\",\"EA\"))","v":"PER PACK"}]
[{"$f":"Unit_Qty","v":0},{"$f":"(IF(A41>1,\"Per Pack\",\"EA\"))","v":"EA"},{"$f":"IF(M11<1,\"\",\"S/N\")","v":""},{"$f":"IF(M11>=1,REPLACE(Contract,1,12,)&Q7,\"\")","v":""},null,{"$f":"Unit_Qty","v":0},{"$f":"(IF(F41>1,\"Per Pack\",\"EA\"))","v":"EA"},{"$f":"IF(M11<1,\"\",\"S/N\")","v":""},{"$f":"IF(M11>=1,REPLACE(Contract,1,12,)&Q8,\"\")","v":""}]
[{"$f":"UPPER(Contract)","v":""},null,null,null,null,{"$f":"UPPER(Contract)","v":""}]
[null,{"$f":"MCode&\" - \"","v":" - "},{"$f":"ShipDate","v":"00:00:00"},null,null,null,{"$f":"MCode&\" - \"","v":" - "},{"$f":"ShipDate","v":"00:00:00"}]
[{"$f":"IF(TDPFAT=\"FAT Package\",\"FIRST ARTICLE TEST - DO NOT POST\",IF(M45>0,N45,\"\"))","v":""},null,null,null,null,{"$f":"IF(TDPFAT=\"FAT Package\",\"FIRST ARTICLE TEST - DO NOT POST\",IF(R45>0,S45,\"\"))","v":""}]
[null,{"$f":"NSN_2","v":""},null,null,null,null,{"$f":"NSN_2","v":""}]
[null,{"$f":"NSN_2","v":""},null,null,null,null,{"$f":"NSN_2","v":""}]
[]
[{"$f":"NSN","v":0},null,null,null,null,{"$f":"NSN","v":0}]
["CAGE",{"$f":"UPPER(Cage)","v":"3NBK9"},"CDA",{"$f":"FSCM","v":0},null,"CAGE",{"$f":"UPPER(Cage)","v":"3NBK9"},"CDA",{"$f":"FSCM","v":0}]
["PN",{"$f":"PN","v":0},null,null,null,"PN",{"$f":"PN","v":0}]
[{"$f":"PROPER(Name)","v":""},{"$f":"UPPER(IF(A51>1,\"Per Pack\",\"EA\"))","v":"PER PACK"},null,null,null,{"$f":"PROPER(Name)","v":""},{"$f":"UPPER(IF(F51>1,\"Per Pack\",\"EA\"))","v":"PER PACK"}]
[{"$f":"Unit_Qty","v":0},{"$f":"(IF(A52>1,\"Per Pack\",\"EA\"))","v":"EA"},{"$f":"IF(M11<1,\"\",\"S/N\")","v":""},{"$f":"IF(M11>=1,REPLACE(Contract,1,12,)&Q9,\"\")","v":""},null,{"$f":"Unit_Qty","v":0},{"$f":"(IF(F52>1,\"Per Pack\",\"EA\"))","v":"EA"},{"$f":"IF(M11<1,\"\",\"S/N\")","v":""},{"$f":"IF(M11>=1,REPLACE(Contract,1,12,)&Q10,\"\")","v":""}]
[{"$f":"UPPER(Contract)","v":""},null,null,null,null,{"$f":"UPPER(Contract)","v":""}]
[null,{"$f":"MCode&\" - \"","v":" - "},{"$f":"ShipDate","v":"00:00:00"},null,null,null,{"$f":"MCode&\" - \"","v":" - "},{"$f":"ShipDate","v":"00:00:00"}]
[{"$f":"IF(TDPFAT=\"FAT Package\",\"FIRST ARTICLE TEST - DO NOT POST\",IF(M56>0,N56,\"\"))","v":""},null,null,null,null,{"$f":"IF(TDPFAT=\"FAT Package\",\"FIRST ARTICLE TEST - DO NOT POST\",IF(R56>0,S56,\"\"))","v":""}]

{"sheet":"Barcode Labels - Package","index":3,"n_rows":59,"n_cols":14,"rows_kept":59,"cut":false,"hidden":false,"merged":[[36,0,38,2],[36,3,37,3],[39,0,39,2],[40,3,41,3],[41,0,43,2],[8,0,9,2],[12,0,14,2],[12,3,13,3],[15,0,15,2],[16,3,17,3],[17,0,19,2],[8,3,9,3],[0,0,2,2],[0,3,1,3],[3,0,3,2],[4,3,5,3],[5,0,7,2],[18,7,18,8],[20,5,20,9],[24,5,24,9],[0,5,0,9],[10,6,10,9],[8,5,8,9],[9,5,9,9],[21,5,21,9],[6,7,6,8],[12,5,12,9],[3,5,3,7],[15,5,15,7],[5,5,5,8],[17,5,17,8],[20,0,21,2],[24,0,26,2],[24,3,25,3],[27,0,27,2],[56,5,56,9],[30,7,30,8],[32,5,32,9],[36,5,36,9],[42,7,42,8],[33,5,33,9],[28,3,29,3],[29,0,31,2],[32,0,33,2],[44,0,45,2],[48,0,50,2],[48,3,49,3],[51,0,51,2],[57,5,57,9],[54,7,54,8],[52,3,53,3],[53,0,55,2],[56,0,57,2],[51,5,51,7],[56,3,57,3],[48,5,48,9],[53,5,53,8],[44,5,44,9],[45,5,45,9],[24,11,24,12],[33,11,33,12],[26,12,27,12],[28,12,29,12],[30,12,31,12],[36,12,37,12],[38,12,39,12],[20,3,21,3],[32,3,33,3],[44,3,45,3],[39,5,39,7],[27,5,27,7],[29,5,29,8],[41,5,41,8],[26,13,27,14],[28,13,29,14],[30,13,31,14],[36,13,37,14],[38,13,39,14]]}
[{"$f":"NSN_2","v":""},null,null,{"$f":"IF(F11>0.1,F11,\" \")","v":" "},null,{"$f":"NSN","v":0}]
[]
[null,null,null,{"$f":"IF(F11>0.1,F11,\" \")","v":" "},null,"CAGE",{"$f":"Cage","v":"3NBK9"},null,"PN",{"$f":"PN","v":0}]
[{"$f":"NSN_2","v":""},null,null,null,null,{"$f":"Name","v":0},null,null,"CDA",{"$f":"FSCM","v":0}]
[null,null,null,{"$f":"D7","v":"IWE0000"},null,{"$f":"Qty_Packages","v":0},{"$f":"IF(Unit_Qty>1,\"Packs\",\"Ea\")","v":"Ea"},{"$f":"IF(TDPFAT=\"FAT Package\",\"(1 TE)\",\"\")","v":""},{"$f":"IF(G5=\"Packs\",Qty_Packages*Unit_Qty,\"\")","v":""},{"$f":"IF(G5=\"Packs\",\"Total Units\",\"\")","v":""}]
[{"$f":"Contract2","v":""},null,null,null,null,{"$f":"Contract","v":0},null,null,null,{"$f":"IF(FastPay=\"Fast Pay\",FastPay&\" Item\",\"\")","v":""}]
[null,null,null,{"$f":"IF(TDPFAT=\"FAT Package\",VLOOKUP(Company,CompanyTable,9,FALSE)&\"0001\",IF(CLIN0002=CLIN0001,VLOOKUP(Company,CompanyTable,9,FALSE)&\"000\"&F11,IF(CLIN0002<1,VLOOKUP(Company,CompanyTable,9,FALSE)&\"000\"&F11&\"Z\",VLOOKUP(Company,CompanyTable,9,FALSE)&\"000\"&F11)))","v":"IWE0000"},null,{"$f":"IF(PackageMethod=\"ASTM D3951\",\" \",IF(PackageMethod<1,\" \",PackageMethod))","v":" "},{"$f":"ShipDate","v":"00:00:00"},{"$f":"IF(MilSpec>1,MilSpec,\" \")","v":"MIL-STD-2073-1D"},null,{"$f":"IF(H7=\"ASTM D3951\",\"(M-CP)\",\"\")","v":""}]
[null,null,null,null,null,"WT",{"$f":"IF(Qty_Packages*Unit_Qty<1,\" \",IF(Qty_Packages*Unit_Qty>=1,IF(WT*Qty_Packages*Unit_Qty<1,1,WT*Qty_Packages*Unit_Qty)))","v":" "},null,null,{"$f":"IF(TDPFAT=\"FAT Package\",\"\",IF(CLIN0005=1,\"Box 1 of \"&Qty_Boxes_4,IF(CLIN0004=1,\"Box 1 of \"&Qty_Boxes_3,IF(CLIN0003=1,\"Box 1 of \"&Qty_Boxes_2,IF(CLIN0003=2,\"Box 1 of \"&Qty_Boxes_2,IF(CLIN0001=2,\" \",IF(CLIN0002=1,\"Box 1 of \"&Qty_Boxes,\" \")))))))","v":" "}]
[{"$f":"Contract2","v":""},null,null,{"$f":"VLOOKUP(Company, CompanyTable, 8, FALSE)","v":"3NBK9"},null,{"$f":"Company","v":"Industrial Welding & Engineering"}]
[null,null,null,null,null,{"$f":"State","v":"Lewis Center, OH 43035"}]
[null,null,null,{"$f":"VLOOKUP(Company, CompanyTable, 8, FALSE)","v":"3NBK9"},null,{"$f":"CLIN0001","v":0},{"$f":"IF(TDPFAT=\"FAT Package\",\"FIRST ARTICLE TEST UNIT\",\" \")","v":" "}]
[]
[{"$f":"NSN_2","v":""},null,null,{"$f":"IF(F23>0.1,F23,\"\")","v":" "},null,{"$f":"NSN","v":0}]
[]
[null,null,null,{"$f":"IF(F23>0.1,F23,\"\")","v":" "},null,"CAGE",{"$f":"Cage","v":"3NBK9"},null,"PN",{"$f":"PN","v":0}]
[{"$f":"NSN_2","v":""},null,null,null,null,{"$f":"Name","v":0},null,null,"CDA",{"$f":"FSCM","v":0}]
[null,null,null,{"$f":"D19","v":"IWE"},null,{"$f":"IF(CLIN0002=1,Qty_Packages_2,IF(CLIN0002=2,Qty_Packages_2,\" \"))","v":" "},{"$f":"IF(Unit_Qty_2>1,\"Packs\",\"Ea\")","v":"Ea"},null,{"$f":"IF(G17=\"Packs\",Qty_Packages_2*Unit_Qty_2,\"\")","v":""},{"$f":"IF(G17=\"Packs\",\"Total Units\",\"\")","v":""}]
[{"$f":"Contract2","v":""},null,null,null,null,{"$f":"Contract","v":0},null,null,null,{"$f":"IF(FastPay=\"Fast Pay\",FastPay&\" Item\",\"\")","v":""}]
[null,null,null,{"$f":"IF(TDPFAT=\"FAT Package\",VLOOKUP(Company,CompanyTable,9,FALSE)&\"0002\",IF(F23>9000,VLOOKUP(Company,CompanyTable,9,FALSE)&CLIN0002,IF(CLIN0003=CLIN0002,VLOOKUP(Company,CompanyTable,9,FALSE)&\"000\"&F23,IF(CLIN0003<1,VLOOKUP(Company,CompanyTable,9,FALSE)&\"000\"&F23&\"Z\",VLOOKUP(Company,CompanyTable,9,FALSE)&\"000\"&F23))))","v":"IWE"},null,{"$f":"IF(PackageMethod=\"ASTM D3951\",\" \",IF(PackageMethod<1,\" \",PackageMethod))","v":" "},{"$f":"ShipDate","v":"00:00:00"},{"$f":"IF(MilSpec>1,MilSpec,\" \")","v":"MIL-STD-2073-1D"},null,{"$f":"IF(H19=\"ASTM D3951\",\"(M-CP)\",\"\")","v":""}]
[null,null,null,null,null,"WT",{"$f":"IF(Qty_Packages_2*Unit_Qty_2<1,\" \",IF(Qty_Packages_2*Unit_Qty_2>=1,IF(WT*Qty_Packages_2*Unit_Qty_2<1,1,WT*Qty_Packages_2*Unit_Qty_2)))","v":" "},null,null,{"$f":"IF(CLIN0005=1,\"Box 2 of \"&Qty_Boxes_4,IF(CLIN0004=1,\"Box 2 of \"&Qty_Boxes_3,IF(CLIN0003=1,\"Box 2 of \"&Qty_Boxes_2,IF(CLIN0001=2,\" \",IF(CLIN0002=1,\"Box 2 of \"&Qty_Boxes,IF(CLIN0003=2,\"Box 1 of \"&Qty_Boxes,\" \"))))))","v":" "}]
[{"$f":"Contract2","v":""},null,null,{"$f":"VLOOKUP(Company, CompanyTable, 8, FALSE)","v":"3NBK9"},null,{"$f":"Company","v":"Industrial Welding & Engineering"}]
[null,null,null,null,null,{"$f":"State","v":"Lewis Center, OH 43035"}]
[null,null,null,{"$f":"VLOOKUP(Company, CompanyTable, 8, FALSE)","v":"3NBK9"},null,{"$f":"IF(CLIN0002=2,2,IF(CLIN0002=1,1,\" \"))","v":" "}]
[]
[{"$f":"NSN_2","v":""},null,null,{"$f":"IF(F35>0.1,F35,\"\")","v":" "},null,{"$f":"NSN","v":0},null,null,null,null,null,{"$f":"IF(M27<1,\"Serial No:\",\"\")","v":""}]
[]
[null,null,null,{"$f":"IF(F35>0.1,F35,\"\")","v":" "},null,"CAGE",{"$f":"Cage","v":"3NBK9"},null,"PN",{"$f":"PN","v":0},null,null,{"$f":"'Barcode Labels - Each'!D8","v":""},{"$f":"M27","v":""}]
[{"$f":"NSN_2","v":""},null,null,null,null,{"$f":"Name","v":0},null,null,"CDA",{"$f":"FSCM","v":0}]
[null,null,null,{"$f":"D31","v":"IWE"},null,{"$f":"IF(CLIN0003=2,Qty_Packages_3,Qty_Packages_3)","v":0},{"$f":"IF(Unit_Qty_3>1,\"Packs\",\"Ea\")","v":"Ea"},null,{"$f":"IF(G29=\"Packs\",Qty_Packages_3*Unit_Qty_3,\"\")","v":""},{"$f":"IF(G29=\"Packs\",\"Total Units\",\"\")","v":""},null,null,{"$f":"'Barcode Labels - Each'!I8","v":""},{"$f":"M29","v":""}]
[{"$f":"Contract2","v":""},null,null,null,null,{"$f":"Contract","v":0},null,null,null,{"$f":"IF(FastPay=\"Fast Pay\",FastPay&\" Item\",\"\")","v":""}]
[null,null,null,{"$f":"IF(F35>9000,VLOOKUP(Company,CompanyTable,9,FALSE)&CLIN0003,IF(CLIN0004=CLIN0003,VLOOKUP(Company,CompanyTable,9,FALSE)&\"000\"&F35,IF(CLIN0004<1,VLOOKUP(Company,CompanyTable,9,FALSE)&\"000\"&F35&\"Z\",VLOOKUP(Company,CompanyTable,9,FALSE)&\"000\"&F35)))","v":"IWE"},null,{"$f":"IF(PackageMethod=\"ASTM D3951\",\" \",IF(PackageMethod<1,\" \",PackageMethod))","v":" "},{"$f":"ShipDate","v":"00:00:00"},{"$f":"IF(MilSpec>1,MilSpec,\" \")","v":"MIL-STD-2073-1D"},null,{"$f":"IF(H31=\"ASTM D3951\",\"(M-CP)\",\"\")","v":""},null,null,{"$f":"'Barcode Labels - Each'!D19","v":""},{"$f":"M31","v":""}]
[null,null,null,null,null,"WT",{"$f":"IF(Qty_Packages_3*Unit_Qty_3<1,\" \",IF(Qty_Packages_3*Unit_Qty_3>=1,IF(WT*Qty_Packages_3*Unit_Qty_3<1,1,WT*Qty_Packages_3*Unit_Qty_3)))","v":" "},null,null,{"$f":"IF(CLIN0005=1,\"Box 3 of \"&Qty_Boxes_4,IF(CLIN0004=1,\"Box 3 of \"&Qty_Boxes_3,IF(CLIN0003=1,\"Box 3 of \"&Qty_Boxes_2,IF(CLIN0003=2,\"Box 2 of \"&Qty_Boxes_2,\"\"))))","v":""}]
[{"$f":"Contract2","v":""},null,null,{"$f":"VLOOKUP(Company, CompanyTable, 8, FALSE)","v":"3NBK9"},null,{"$f":"Company","v":"Industrial Welding & Engineering"}]
[null,null,null,null,null,{"$f":"State","v":"Lewis Center, OH 43035"},null,null,null,null,null,{"$f":"IF(M37<1,\"Serial No:\",\"\")","v":""}]
[null,null,null,{"$f":"VLOOKUP(Company, CompanyTable, 8, FALSE)","v":"3NBK9"},null,{"$f":"IF(CLIN0003=3,3,IF(CLIN0003=2,2,IF(CLIN0003=1,1,\" \")))","v":" "}]
[]
[{"$f":"NSN_2","v":""},null,null,{"$f":"F47","v":" "},null,{"$f":"NSN","v":0},null,null,null,null,null,null,{"$f":"'Barcode Labels - Each'!I19","v":""},{"$f":"M37","v":""}]
[]
[null,null,null,{"$f":"F47","v":" "},null,"CAGE",{"$f":"Cage","v":"3NBK9"},null,"PN",{"$f":"PN","v":0},null,null,{"$f":"'Barcode Labels - Each'!D30","v":""},{"$f":"M39","v":""}]
[{"$f":"NSN_2","v":""},null,null,null,null,{"$f":"Name","v":0},null,null,"CDA",{"$f":"FSCM","v":0}]
[null,null,null,{"$f":"D43","v":"IWE"},null,{"$f":"IF(Qty_Packages_4>0.9,Qty_Packages_4,\" \")","v":" "},{"$f":"IF(Unit_Qty_4>1,\"Packs\",\"Ea\")","v":"Ea"},null,{"$f":"IF(G41=\"Packs\",Qty_Packages_4*Unit_Qty_4,\"\")","v":""},{"$f":"IF(G41=\"Packs\",\"Total Units\",\"\")","v":""}]
[{"$f":"Contract2","v":""},null,null,null,null,{"$f":"Contract","v":0},null,null,null,{"$f":"IF(FastPay=\"Fast Pay\",FastPay&\" Item\",\"\")","v":""}]
[null,null,null,{"$f":"IF(F47>9000,VLOOKUP(Company,CompanyTable,9,FALSE)&CLIN0004,IF(CLIN0005=CLIN0004,VLOOKUP(Company,CompanyTable,9,FALSE)&\"000\"&F47,IF(CLIN0005<1,VLOOKUP(Company,CompanyTable,9,FALSE)&\"000\"&F47&\"Z\",VLOOKUP(Company,CompanyTable,9,FALSE)&\"000\"&F47)))","v":"IWE"},null,{"$f":"IF(PackageMethod=\"ASTM D3951\",\" \",IF(PackageMethod<1,\" \",PackageMethod))","v":" "},{"$f":"ShipDate","v":"00:00:00"},{"$f":"IF(MilSpec>1,MilSpec,\" \")","v":"MIL-STD-2073-1D"},null,{"$f":"IF(H43=\"ASTM D3951\",\"(M-CP)\",\"\")","v":""}]
[null,null,null,null,null,"WT",{"$f":"IF(Qty_Packages_4*Unit_Qty_4<1,\" \",IF(Qty_Packages_4*Unit_Qty_4>=1,IF(WT*Qty_Packages_4*Unit_Qty_4<1,1,WT*Qty_Packages_4*Unit_Qty_4)))","v":" "},null,null,{"$f":"IF(CLIN0005=1,\"Box 4 of \"&Qty_Boxes_4,IF(CLIN0004=1,\"Box 4 of \"&Qty_Boxes_3,IF(CLIN0004=2,\"Box 1 of \"&Qty_Boxes_2,IF(CLIN0004=3,\"Box 2 of \"&Qty_Boxes_2,\" \"))))","v":" "}]
[{"$f":"Contract2","v":""},null,null,{"$f":"VLOOKUP(Company, CompanyTable, 8, FALSE)","v":"3NBK9"},null,{"$f":"Company","v":"Industrial Welding & Engineering"}]
[null,null,null,null,null,{"$f":"State","v":"Lewis Center, OH 43035"}]
[null,null,null,{"$f":"VLOOKUP(Company, CompanyTable, 8, FALSE)","v":"3NBK9"},null,{"$f":"IF(CLIN0004=4,4,IF(CLIN0004=3,3,IF(CLIN0004=2,2,IF(CLIN0004=1,1,\" \"))))","v":" "}]
[]
[{"$f":"IF(CLIN0004>0.09,NSN_2,\"\")","v":""},null,null,{"$f":"F59","v":" "},null,{"$f":"IF(CLIN0004>0.09,NSN,\" \")","v":" "}]
[]
[null,null,null,{"$f":"F59","v":" "},null,{"$f":"IF(CLIN0004>0.09,\"CAGE\",\" \")","v":" "},{"$f":"IF(CLIN0004>0.09,Cage,\" \")","v":" "},null,{"$f":"IF(CLIN0004>0.09,\"PN\",\" \")","v":" "},{"$f":"IF(CLIN0004>0.09,PN,\" \")","v":" "}]
[{"$f":"IF(CLIN0004>0.09,NSN_2,\" \")","v":" "},null,null,null,null,{"$f":"Name","v":0},null,null,"CDA",{"$f":"FSCM","v":0}]
[null,null,null,{"$f":"D55","v":"IWE"},null,{"$f":"IF(Qty_Packages_5>0.9,Qty_Packages_5,\" \")","v":" "},{"$f":"IF(Unit_Qty_5>1,\"Packs\",\"Ea\")","v":"Ea"},null,{"$f":"IF(G53=\"Packs\",Qty_Packages_5*Unit_Qty_5,\"\")","v":""},{"$f":"IF(G53=\"Packs\",\"Total Units\",\"\")","v":""}]
[{"$f":"IF(CLIN0004>0.09,Contract2,\"\")","v":""},null,null,null,null,{"$f":"IF(CLIN0004>0.09,Contract,\" \")","v":" "},null,null,null,{"$f":"IF(FastPay=\"Fast Pay\",FastPay&\" Item\",\"\")","v":""}]
[null,null,null,{"$f":"IF(F59>9000,VLOOKUP(Company,CompanyTable,9,FALSE)&CLIN0005,IF(CLIN0005>1,VLOOKUP(Company,CompanyTable,9,FALSE)&\"000\"&F59&\"Z\",IF(CLIN0005<1,VLOOKUP(Company,CompanyTable,9,FALSE)&\"000\"&F59&\"Z\",\" \")))","v":"IWE"},null,{"$f":"IF(PackageMethod=\"ASTM D3951\",\" \",IF(PackageMethod<1,\" \",PackageMethod))","v":" "},{"$f":"IF(CLIN0004>0.09,ShipDate,\" \")","v":" "},{"$f":"IF(CLIN0004>0.09,MilSpec,IF(MilSpec=\"ASTM D4951\",\"ASTM D4951\",\" \"))","v":" "},null,{"$f":"IF(H55=\"ASTM D3951\",\"(M-CP)\",\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(CLIN0004>0.09,\"WT\",\" \")","v":" "},{"$f":"IF(Qty_Packages_5*Unit_Qty_5<1,\" \",IF(Qty_Packages_5*Unit_Qty_5>=1,IF(WT*Qty_Packages_5*Unit_Qty_5<1,1,WT*Qty_Packages_5*Unit_Qty_5)))","v":" "},null,null,{"$f":"IF(CLIN0005=1,\"Box 5 of \"&Qty_Boxes_5,IF(CLIN0004=2,\"Box 2 of \"&Qty_Boxes_4,IF(CLIN0005=3,\"Box 2 of \"&Qty_Boxes_3,IF(CLIN0005=2,\"Box 2 of \"&Qty_Boxes_2,\" \"))))","v":" "}]
[{"$f":"IF(CLIN0004>0.09,Contract2,\" \")","v":" "},null,null,{"$f":"VLOOKUP(Company, CompanyTable, 8, FALSE)","v":"3NBK9"},null,{"$f":"IF(CLIN0004>0.09,Company,\" \")","v":" "}]
[null,null,null,null,null,{"$f":"IF(CLIN0004>0.09,State,\" \")","v":" "}]
[null,null,null,{"$f":"VLOOKUP(Company, CompanyTable, 8, FALSE)","v":"3NBK9"},null,{"$f":"IF(CLIN0005>=1,CLIN0005,\" \")","v":" "}]

{"sheet":"Serial No","index":4,"n_rows":26,"n_cols":15,"rows_kept":26,"cut":false,"hidden":true,"merged":[]}
["SERIAL NUMBER DATA",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Serial_No","v":"001"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"002"]
[43160023,null,43160023,null,43160028,null,43160028,null,null,null,null,null,null,null,"003"]
[43160033,null,43160033,null,43160044,null,43160044,null,null,null,null,null,null,null,"004"]
[43160050,null,43160050,null,43160051,null,43160051,null,null,null,null,null,null,null,"005"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"006"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"007"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"008"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"015"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"016"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"017"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"018"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"019"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"020"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"021"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"022"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"}]

{"sheet":"DD250","index":5,"n_rows":61,"n_cols":25,"rows_kept":61,"cut":false,"hidden":false,"merged":[[7,24,7,26],[0,24,0,26],[2,24,2,26],[6,24,6,26],[1,24,1,26],[5,24,5,26],[3,24,3,26],[4,24,4,26],[47,6,47,8],[47,9,47,12],[40,0,40,12],[40,13,40,17],[41,0,41,1],[41,6,41,12],[41,13,42,17],[43,13,43,14],[43,15,43,17],[44,13,44,14],[44,15,44,17],[42,4,42,5],[42,9,42,12],[43,0,45,5],[43,6,45,12],[38,14,38,16],[51,13,51,17],[47,15,47,17],[51,9,51,12],[48,0,48,2],[48,3,48,5],[48,6,48,8],[48,9,48,12],[49,13,49,17],[50,3,50,5],[50,9,50,12],[50,13,50,17],[51,3,51,5],[46,0,47,2],[46,3,47,5],[46,13,46,14],[46,15,46,17],[60,0,60,17],[56,0,56,5],[56,6,56,12],[56,13,58,17],[52,13,52,17],[53,0,53,5],[53,6,53,12],[53,13,53,17],[54,0,54,5],[54,6,54,12],[54,13,54,15],[54,16,55,17],[55,0,55,5],[55,6,55,12],[59,0,59,4],[57,0,57,4],[57,6,57,10],[58,2,58,5],[39,0,39,1],[39,2,39,3],[39,4,39,10],[39,11,39,12],[39,14,39,16],[38,0,38,1],[38,2,38,3],[38,4,38,10],[38,11,38,12],[36,14,36,16],[37,0,37,1],[37,2,37,3],[37,4,37,10],[37,11,37,12],[37,14,37,16],[36,0,36,1],[36,2,36,3],[36,4,36,10],[36,11,36,12],[34,4,34,10],[34,11,34,12],[34,14,34,16],[35,0,35,1],[35,2,35,3],[35,4,35,10],[35,11,35,12],[35,14,35,16],[34,0,34,1],[34,2,34,3],[32,4,32,10],[32,11,32,12],[32,14,32,16],[33,0,33,1],[33,2,33,3],[33,4,33,10],[33,11,33,12],[33,14,33,16],[32,0,32,1],[32,2,32,3],[30,4,30,10],[30,11,30,12],[30,14,30,16],[31,0,31,1],[31,2,31,3],[31,4,31,10],[31,11,31,12],[31,14,31,16],[30,0,30,1],[30,2,30,3],[29,14,29,16],[28,0,28,1],[28,2,28,3],[28,6,28,10],[28,14,28,16],[29,0,29,1],[29,2,29,3],[29,8,29,10],[29,11,29,12],[28,11,28,12],[29,4,29,5],[29,6,29,7],[26,14,26,16],[27,0,27,3],[27,4,27,10],[27,11,27,12],[27,14,27,16],[26,0,26,3],[26,4,26,5],[26,6,26,10],[26,11,26,12],[25,0,25,9],[25,10,25,17],[21,0,21,3],[21,5,21,9],[21,10,21,14],[21,16,21,17],[22,0,22,9],[22,10,22,17],[23,0,23,9],[23,10,23,17],[24,0,24,9],[24,10,24,17],[16,0,16,4],[16,7,16,9],[16,10,16,14],[16,15,16,16],[17,0,17,9],[17,10,17,17],[19,0,19,9],[19,10,19,17],[20,10,20,17],[20,1,20,3],[20,5,20,7],[18,0,18,9],[18,10,18,17],[12,0,12,9],[12,10,12,17],[13,0,13,9],[13,10,13,17],[11,0,11,3],[11,5,11,9],[11,10,11,14],[11,15,11,16],[15,10,15,17],[15,1,15,3],[15,5,15,7],[14,0,14,9],[14,10,14,17],[10,4,10,5],[10,6,10,7],[10,8,10,11],[8,16,8,17],[9,12,9,17],[8,0,8,5],[10,12,10,17],[10,0,10,3],[8,6,8,9],[8,10,8,11],[9,0,9,3],[9,4,9,5],[9,6,9,7],[9,8,9,11],[1,16,2,17],[3,0,3,17],[4,0,4,17],[1,0,2,15],[8,12,8,13],[5,0,5,17],[6,0,6,17],[7,0,7,5],[7,6,7,9],[7,10,7,13],[7,16,7,17]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DCMA QAR"]
["MATERIAL INSPECTION AND RECEIVING REPORT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Form Approved OMB No. 0704-0248",null,null,null,null,null,null,"Contact Name","Mark Monroe"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DCMA Local DoDACC","S3605A"]
["The public reporting burden for this collection of information is estimated to average 30 minutes per response, including the time for reviewing instructions, searching existing data sources, gathering and maintaining the data needed, and completing and reviewing the collection of information. Send comments regarding this burden estimate or any other aspect of this collection of information,",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mailing Address","3990 East Broad St."]
["including suggestions for reducing the burden, to the Department of Defense, Executive Services and Communications Directorate (0704-0248). Respondents should be aware that notwithstanding any other provision of law, no person shall be subject to any penalty for failing to comply with a collection of information if it does not display a currently valid OMB control number.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Columbus, OH 43218"]
["PLEASE DO NOT RETURN YOUR COMPLETED FORM TO THE ABOVE ORGANIZATION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"QAR Phone","614-692-6495"]
["SEND THIS FORM IN ACCORDANCE WITH THE INSTRUCTIONS CONTAINED IN THE DFARS, APPENDIX F-401.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"QAR Fax"]
["1. PROCUREMENT INSTRUMENT IDENTIFICATION (CONTRACT) NO.",null,null,null,null,null,"ORDER NO.",null,null,null,"6. INVOICE NO./DATE",null,null,null,"7. PAGE","OF","8. ACCEPTANCE POINT",null,null,null,"<--Fill In Data",null,null,"Email","Mark.Monroe@dcma.mil"]
[{"$f":"Contract","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"ShipDate","v":"00:00:00"},null,1,1,{"$f":"IF(AcceptPoint=\"S - CONTRACT CAGE LOCATION\",\"S\",\"D\")","v":"D"}]
["2. SHIPMENT NO.",null,null,null,"3. DATE SHIPPED",null,"4. B/L",null,null,null,null,null,"5. DISCOUNT TERMS"]
[null,null,null,null,{"$f":"ShipDate","v":"00:00:00"},null,"TCN",null,null,null,null,null,"1/2% 12, NET 30"]
["9. PRIME CONTRACTOR",null,null,null,"CODE",{"$f":"Cage","v":"3NBK9"},null,null,null,null,"10. ADMINISTERED BY",null,null,null,null,"CODE",null,{"$f":"DoDACC","v":0}]
[{"$f":"Company","v":"Industrial Welding & Engineering"},null,null,null,null,null,null,null,null,null,{"$f":"IF(QARAddress>=1,QARAddress,\"\")","v":"3990 East Broad St."}]
[{"$f":"Street","v":"747 Carle Ave."},null,null,null,null,null,null,null,null,null,{"$f":"IF(QARState>=1,QARState,\"\")","v":"Columbus, OH 43218"}]
[{"$f":"State","v":"Lewis Center, OH 43035"},null,null,null,null,null,null,null,null,null,{"$f":"IF(QARPhone>=1,QARPhone,\"\")","v":"614-692-6495"}]
["Phone:",{"$f":"Phone","v":"614-883-6109"},null,null,"Fax:",{"$f":"Fax","v":"email only"}]
["11. SHIPPED FROM (If other than 9) CODE",null,null,null,null,{"$f":"Cage","v":"3NBK9"},"FOB:",{"$f":"IF(FOB=\"D\",\"DEST\",IF(FOB=\"S\",\"ORG\",\"Other\"))","v":"Other"},null,null,"12. PAYMENT WILL BE MADE BY",null,null,null,null,"CODE",null,"SL4701"]
[{"$f":"Company","v":"Industrial Welding & Engineering"},null,null,null,null,null,null,null,null,null,"DFAS BVDP (SL4701)"]
[{"$f":"Street","v":"747 Carle Ave."},null,null,null,null,null,null,null,null,null,"PO BOX 369031"]
[{"$f":"State","v":"Lewis Center, OH 43035"},null,null,null,null,null,null,null,null,null,"Columbus OH 43236-9031"]
["Phone:",{"$f":"Phone","v":"614-883-6109"},null,null,"Fax:",{"$f":"Fax","v":"email only"},null,null,null,null,"EFT:T"]
["13. SHIPPED TO",null,null,null,"CODE",null,null,null,null,null,"14. MARKED FOR",null,null,null,null,"CODE"]
[{"$f":"VLOOKUP(FATDoDACC2, FATTable, 2, FALSE)","v":{"$error":"#N/A"}}]
[{"$f":"VLOOKUP(FATDoDACC2, FATTable, 3, FALSE)","v":{"$error":"#N/A"}}]
[{"$f":"VLOOKUP(FATDoDACC2, FATTable, 4, FALSE)","v":{"$error":"#N/A"}}]
[{"$f":"VLOOKUP(FATDoDACC2, FATTable, 5, FALSE)","v":{"$error":"#N/A"}}]
["15.",null,null,null,"16. STOCK/PART NO.",null,"DESCRIPTION",null,null,null,null,"17. QUANTITY",null,"18.","19.",null,null,"20."]
[" ITEM NO.",null,null,null," (Indicate number of shipping containers -type ofcontainer -container number.)",null,null,null,null,null,null,"SHIP/REC'D*",null,"UNIT","UNIT PRICE",null,null,"AMOUNT"]
[null,null,{"$f":"CLIN0001","v":0},null,{"$f":"NSN","v":0},"-",{"$f":"Name","v":0},null,null,null,null,{"$f":"IF(CLIN0001>=9906,1,QTY)","v":0},null,{"$f":"IF(TDPFAT=\"FAT Package\",\"TE\",\"EA\")","v":"EA"},{"$f":"IF(TDPFAT=\"FAT Package\",FAT_Cost,Unit_Cost)","v":0},null,null,{"$f":"IF(L29>0.1,O29*L29,\" \")","v":" "}]
[null,null,null,null,{"$f":"PN","v":0},null,"Rev",null,{"$f":"REV","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(L30>0.1,O30*L30,\" \")","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L31>0.1,O31*L31,\" \")","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,{"$f":"IF(FOB=\"O\",\"Shipping Cost\",\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(FOB=\"O\",1,\"\")","v":""},null,{"$f":"IF(FOB=\"O\",\"EA\",\"\")","v":""},null,null,null,{"$f":"IF(N33=\"EA\",O33*L33,\" \")","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,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,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,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L39>0.1,O39*L39,\" \")","v":" "}]
[null,null,null,null,"GROSS WEIGHT:",null,null,null,null,null,null,{"$f":"IF(WT<1,1*QTY,WT*QTY)","v":0},null,{"$f":"IF(L40>=1,\"LBS\",\"\")","v":""},"TOTAL:",null,null,{"$f":"SUM(R29:R39)","v":0}]
["21. CONTRACT QUALITY ASSURANCE",null,null,null,null,null,null,null,null,null,null,null,null,"22. RECEIVER'S USE"]
["a. ORIGIN",null,null,null,null,null,"b. DESTINATION",null,null,null,null,null,null,"Quantities shown in column 17 were received in apparent good condition except as noted."]
[null,"CQA",null,null,"ACCEPTANCE of listed items",null,null,"CQA",null,"ACCEPTANCE of listed items has"]
["has been made by me or under my supervision and they conform to contract, except as noted herein or on supporting documents.",null,null,null,null,null,"been made by me or under my supervision and they conform to contract, except as noted herein or on supporting documents."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"DATE RECEIVED",null,"SIGNATURE OF AUTHORIZED GOVERNMENT REPRESENTATIVE"]
[]
[{"$f":"NOW()","v":"2015-01-07T11:27:39.020"},null,null,null,null,null,null,null,null,null,null,null,null,"TYPED NAME:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"TITLE:"]
["DATE",null,null,"SIGNATURE - GOV REP",null,null,"DATE",null,null,"SIGNATURE - GOV REP",null,null,null,"MAILING ADDRESS:"]
[]
["TYPED NAME:",null,null,{"$f":"IF(QARName>=1,QARName,\"\")","v":"Mark Monroe"},null,null,"TYPED NAME:"]
["TITLE:",null,null,{"$f":"\"DCMA QAR\"&\" - \"&QARDoDACC","v":"DCMA QAR - S3605A"},null,null,"TITLE:"]
["MAILING ADDRESS:",null,null,null,null,null,"MAILING ADDRESS:"]
[{"$f":"IF(QARAddress>=1,QARAddress,\"\")","v":"3990 East Broad St."}]
[{"$f":"IF(QARState>=1,QARState,\"\")","v":"Columbus, OH 43218"},null,null,null,null,null,null,null,null,null,null,null,null,"COMMERCIAL TELEPHONE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"NUMBER:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"* If quantity received by the Government is the same as quantity shipped, indicate by (X) mark; if different, enter actual quantity received below quantity shipped and encircle."]
["COMMERCIAL TELEPHONE",null,null,null,null,null,"COMMERCIAL TELEPHONE"]
["NUMBER:",null,{"$f":"IF(QARPhone>=1,QARPhone,\"\")","v":"614-692-6495"},null,null,null,"NUMBER:"]
["23. CONTRACTOR USE ONLY"]
[{"$f":"\"Please fax complete DD250 to Attn:\"&\" \"&Inspector&\" - \"&Fax","v":"Please fax complete DD250 to Attn:  - email only"}]

{"sheet":"DD1222","index":6,"n_rows":56,"n_cols":27,"rows_kept":56,"cut":false,"hidden":false,"merged":[[55,0,55,8],[55,13,55,14],[39,0,40,14],[43,0,43,3],[43,4,43,9],[43,10,43,14],[52,1,52,8],[52,9,52,14],[53,0,54,0],[53,1,54,8],[44,3,44,6],[44,0,44,2],[51,0,51,2],[51,3,51,6],[51,7,51,10],[51,11,51,14],[48,0,48,2],[49,0,49,2],[50,3,50,6],[49,11,49,14],[50,0,50,2],[47,0,47,2],[48,3,48,6],[50,11,50,14],[53,9,54,14],[9,13,9,14],[20,2,21,4],[20,5,21,7],[23,0,24,4],[22,5,22,7],[23,5,24,7],[22,0,22,4],[21,0,21,1],[9,0,9,5],[19,5,19,7],[19,8,19,14],[15,8,15,12],[15,13,15,14],[15,0,15,4],[14,0,14,2],[12,0,12,5],[45,0,45,2],[16,13,18,14],[15,6,15,7],[16,6,18,7],[13,0,13,1],[13,3,13,5],[32,0,32,14],[37,0,37,14],[16,0,18,4],[14,6,14,7],[14,3,14,5],[14,8,14,14],[23,8,24,10],[23,11,24,14],[19,0,19,1],[19,2,19,4],[20,0,20,1],[22,8,22,14],[26,0,26,14],[30,0,30,14],[36,0,36,14],[29,0,29,14],[28,0,28,14],[34,0,34,14],[35,0,35,14],[31,0,31,14],[33,0,33,14],[27,0,27,7],[27,8,27,9],[50,7,50,10],[47,11,47,14],[45,7,45,10],[48,11,48,14],[47,3,47,6],[48,7,48,10],[49,7,49,10],[49,3,49,6],[38,0,38,14],[41,10,41,14],[44,11,44,14],[44,7,44,10],[41,4,41,9],[41,0,41,3],[47,7,47,10],[45,3,45,6],[45,11,45,14],[9,6,9,12],[13,6,13,7],[13,9,13,10],[25,0,25,14],[11,6,11,14],[12,6,12,14],[10,0,10,5],[11,0,11,5],[10,6,10,14],[16,8,18,12],[20,8,21,12],[20,13,20,14],[21,13,21,14],[0,12,0,13],[0,0,1,11],[1,12,1,13],[4,0,4,5],[2,0,2,14],[8,0,8,5],[5,6,5,14],[6,6,6,14],[8,6,8,14],[7,6,7,7],[7,9,7,10],[5,0,5,5],[6,0,6,5],[7,0,7,5],[4,6,4,14],[3,6,3,14],[3,0,3,2],[3,3,3,5]]}
["REQUEST FOR AND RESULTS TESTS",null,null,null,null,null,null,null,null,null,null,null,"PAGE NO.",null,"NO. OF PAGES",null,null,null,null,null,"No.","Facility","DoDAAC","Ship To:"]
[null,null,null,null,null,null,null,null,null,null,null,null,1,null,1,null,null,null,null,null,1]
["SECTION A – REQUEST FOR TEST",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Brooks AFB","FA2080","311 HSW/YAPT","ATTN: TEXTILE / FIRST ARTICLE MONITOR","7980 LINDBERGH LANDING, MATERIAL LABORATORY, BLDG. 578","BROOKS CITY-BASE, TX. 78235-5119"]
["1.  TO: (Include ZIP Code)",null,null,null,null,null,"2.  FROM: (Include ZIP Code)",null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Tinker ALC","FA8111","SHIP MATERIAL CERTIFICATIONS AND CONTRACT COPY","ATTN:  FIRST ARTICLE MONITOR","3001 STAFF DRIVE, STE 1AB-85A, 448 MSUG/GBMUED ","TINKER AFB,  OK   73145-3036"]
[{"$f":"VLOOKUP(FATDoDACC2, FATTable, 2, FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,{"$f":"Company&\"    (\"&Cage&\")\"","v":"Industrial Welding & Engineering    (3NBK9)"},null,null,null,null,null,null,null,null,null,null,null,null,null,4,"Hill ALC","FB2029","FIRST ARTICLE EXHIBIT AND TEST REPORT","DEAR JOHN BAY, MARK FOR: FAT INSPECTION AND TEST","809 MXSS/MXDEB, BLDG 849","HILL AFB, UT. 84056-5713"]
[{"$f":"VLOOKUP(FATDoDACC2, FATTable, 3, FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,{"$f":"Street","v":"747 Carle Ave."},null,null,null,null,null,null,null,null,null,null,null,null,null,5,"Warner Robins ALC"," FD2060","INSPECTION REPORTS:","ATTN: FIRST ARTICLE TEST LAB","450 THIRD ST. BLDG 323, 402 MXSG/MXRILM","ROBINS AFB, GA. 31098-1640"]
[{"$f":"VLOOKUP(FATDoDACC2, FATTable, 4, FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,{"$f":"State","v":"Lewis Center, OH 43035"},null,null,null,null,null,null,null,null,null,null,null,null,null,6,"Robins AFB","FD2060","DLA CENTRAL RECEIVING, SPECIAL HANDLING, FIRST ARTICLE UNIT","DDWG ER, WR-ALC","455 BYRON STREET","ROBINS AFB, GA 31098-1887"]
[{"$f":"VLOOKUP(FATDoDACC2, FATTable, 5, FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,{"$f":"Phone","v":"614-883-6109"},null,"fax:",{"$f":"Fax","v":"email only"},null,null,null,null,null,null,null,null,null,null,7,"Tinker ALC","FY2303","DDOO-SOP(FIRST ARTICLE)  DODAAC FY2303","ATTN:  DDOO-SOP","8080 PERIMETER RD., BLDG 18  DOOR 16  (405) 739-7667","TINKER AFB,  OK  73145-8000"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"RTTC Redstone","W31P0W","TRANSPORTATION OFFICER, BUILDING 8022","REDSTONE TECHNICAL TEST CENTER, TEDT-RT-EMC","BUILDING 4500 ATTN: CHARLES EAKES","REDSTONE ARSENAL, AL 35898"]
["3. PRIME CONTRACTOR AND ADDRESS (Include ZIP Code)",null,null,null,null,null,"4. MANUFACTURING PLANT NAME AND ADDRESS (Include ZIP Code)",null,null,null,null,null,null,null,null,null,null,null,null,null,9,"Hunter AAF, Ft. Stewart, GA","W33KD9","AMCOM/PROJECT OLR(EAST)","ATTN: LARRY SYLVESTER","872 NORTH LIGHTNING RD., BLDG 835T HUNTER AAF","SAVANNAH, GA 31409"]
[{"$f":"Company&\"    (\"&Cage&\")\"","v":"Industrial Welding & Engineering    (3NBK9)"},null,null,null,null,null,{"$f":"Company&\"    (\"&Cage&\")\"","v":"Industrial Welding & Engineering    (3NBK9)"},null,null,null,null,null,null,null,null,null,null,null,null,null,10,"Ft. Drum, NY","W81GJX","DIRECTORATE OF LOGISTICS, ATTN: FIRST ARTICLE TEST","AVIATION INTERMEDIATE MAINTENANCE FACILITY ","P2050 MUNNS CORNER RD.","FT. DRUM, NY 13612"]
[{"$f":"Street","v":"747 Carle Ave."},null,null,null,null,null,{"$f":"Street","v":"747 Carle Ave."},null,null,null,null,null,null,null,null,null,null,null,null,null,11,"Ft. Hood (San Angelo)","W90JT5 ","AMCOM PROJECT OLR","ATTN: FIRST ARTICLE TEST LAB","HANGAR RD., BLDG. 8154","SAN ANGELO, TX. 76904"]
[{"$f":"State","v":"Lewis Center, OH 43035"},null,null,null,null,null,{"$f":"State","v":"Lewis Center, OH 43035"},null,null,null,null,null,null,null,null,null,null,null,null,null,12,"NSWC Crane, Indiana","N00164","COMMANDER, NAVAL SURFACE WARFARE CENTER","(ATTN: ALAN GOODMAN, CODE 6095, ext. 6151)","300 HIWAY 361, BUILDING 3287","CRANE, IN   47522-5000"]
["614-657-8666",null,"FAX:",{"$f":"Fax","v":"email only"},null,null,{"$f":"Phone","v":"614-883-6109"},null,"FAX:",{"$f":"Fax","v":"email only"},null,null,null,null,null,null,null,null,null,null,13,"NSWC Crane, Indiana","N00164","COMMANDER","NAVSURFWARCENDIV CRANE","300 HIGHWAY 361, BUILDING 3235 CODE 6093","CRANE, IN 47522-5000"]
["CONTRACT NUMBER                                 ",null,null,{"$f":"Contract","v":0},null,null," P.O. NUMBER               ",null,null,null,null,null,null,null,null,null,null,null,null,null,14,"Keyport, WA","N00253","COMMANDER (CODE 70(Y))","NAVAL UNDERSEA WARFARE CENTER DIVISION, KEYPORT","610 DOWELL STREET","KEYPORT, WA 98345"]
["5.  END ITEM AND/OR PROJECT",null,null,null,null,"6.  CLIN  #","7.  LOT NO.",null,"8.  REASON FOR SUBMITTAL",null,null,null,null,"9. DATE SUBMITTED",null,null,null,null,null,null,15,"NAWC Patuxent River (AIR)"," N00421","COMMANDING OFFICER, NAVAL AWC AIRCRAFT DIVISION","ATTN: DR. ROBERT POLANOWSKI ALDAC - MSD","47671 RANCH ROAD; BLDG 2186","PATUXENT RIVER, MD. 20670-1539 "]
[{"$f":"PN&\" - \"&Name","v":" - "},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"InspectDate","v":"00:00:00"},null,null,null,null,null,null,16,"NAWC Patuxent River ","N00421","QUALITY ASSURANCE MONITOR","ATTN: ROBERT J. HUDSON, HUMAN SYSTEMS DEPARTMENT CODE 4.6.8.3","48110 SHAW RD, BUILDING 2187 RM 1240 F-10","PATUXENT RIVER, MD 20670-1906"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,"FRCSW North Island, CA","N3096A ","COMMANDER, FLEET READINESS CENTER SOUTHWEST","ATTN:  TESTING COORDINATOR","CUSTOMER SERVICE BLDG 341 CODE 93001","SAN DIEGO, CA  92135"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,"FRCSE JAX, FL (old DoDAAC N65886)","N50068","FLEET READINESS CENTER SOUTHEAST","ATTN: TESTING COORDINATOR, CECIL COMMERCE CENTER","6206 AVIATION AVE., CODE 41900","JACKSONVILLE, FL 32221-8112"]
["10.  MATERIAL BEING TESTED",null,"10a.  QUANTITY SUBMITTED",null,null,"11.  QUANTITY REPRESENTED",null,null,"12.  SPEC. & AMEND AN OR DRAWING NO. & REV. FOR SAMPLE  & DATE",null,null,null,null,null,null,null,null,null,null,null,19,"MCAS Cherry Point, NC","N50078","IN SERVICE SUPPORT CENTER CHERRY POINT","FIRST ARTICLE TEST-STA. 31B, ATTN: 3.3.2  (252) 464-7748","BLDG 154B CLEVELAND DR.","MCAS CHERRY POINT, NC 28533"]
[{"$f":"PN","v":0},null,null,null,null,null,null,null,{"$f":"PN &\" REV \" &REV","v":" REV "},null,null,null,null,"Rev Release Date",null,null,null,null,null,null,20,"NAWC China Lake, CA","N60530","COMMANDER, CODE 466200D","NAVAIRWARCENWPNDIV","1 ADMINISTRATION CIRCLE, BLDG 20210, STOP 1118","CHINA LAKE, CA 93555-6100 "]
[{"$f":"Contract","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,"NSWC Carderock Div.","N65540","NAVAL SURFACE WARFARE CENTER, CODE 9532, BUILDING #4","SHIP SYSTEMS ENGINEERING STATION, CARDEROCK DIVISION","5001 SOUTH BROAD STREET","PHILADELPHIA  PA  19112-1403"]
["13.  PURCHASED FROM OR SOURCE",null,null,null,null,"14.  SHIPMENT METHOD",null,null,"15.  DATE SAMPLED AND SUBMITTED BY",null,null,null,null,null,null,null,null,null,null,null,22,"FRCSW North Island (Bearings)","N65888","FLEET READINESS CENTER SOUTHWEST","ATTN: JEFFREY MALLERY, CUSTOMER SERVICE","BLDG 341, CODE 93000","SAN DIEGO, CA.  92135"]
["N/A",null,null,null,null,"UPS Ground",null,null,{"$f":"ShipDate","v":"00:00:00"},null,null,{"$f":"IF(QARDoDACC>=1,QARName&\" - DCMA QAR - \"&QARDoDACC,\" \")","v":"Mark Monroe - DCMA QAR - S3605A"}]
[]
["16.  REMARKS AND/OR SPECIAL INSTRUCTIONS AND/OR WAIVERS"]
[]
[{"$f":"IF(QARDoDACC>=1,QARName&\" - DCMA QAR - \"&QARDoDACC&\" - \"&QARPhone,\" \")","v":"Mark Monroe - DCMA QAR - S3605A - 614-692-6495"},null,null,null,null,null,null,null,{"$f":"NOW()","v":"2015-01-07T11:27:39.020"}]
[]
[]
[]
[]
[]
[]
[]
["17.  SEND TEST REPORT TO"]
[]
[{"$f":"IF(QARDoDACC>=1,QARName&\" - DCMA QAR - \"&QARDoDACC&\" - \"&QARAddress&\", \"&QARState&\" - \"&QAReMail,\" \")","v":"Mark Monroe - DCMA QAR - S3605A - 3990 East Broad St., Columbus, OH 43218 - Mark.Monroe@dcma.mil"}]
[]
["SECTION B - RESULTS OF TEST (Continue on plain white paper if more space is required)"]
[]
["1.  DATE SAMPLE RECEIVED",null,null,null,"2. DATE RESULTS REPORTED",null,null,null,null,null,"3.  LAB REPORT NUMBER"]
[]
[]
["4.     TEST PERFORMED                                         ",null,null,"RESULTS OF TEST",null,null,null,"SAMPLE RESULT       ",null,null,null,"REQUIREMENTS"]
[]
[]
[]
[]
[]
[]
[]
["DATE","TYPED NAME AND TITLE OF PERSON CONDUCTING TEST",null,null,null,null,null,null,null,"SIGNATURE"]
[]
[]
["DD FORM 1222, (2000)                              REPLACES DD FORM 1222, 1JUL 58, WHICH IS OBSOLETE.",null,null,null,null,null,null,null,null,null,null,null,null,"PerFORM (DLA)"]

{"sheet":"QA 011 - Packing List","index":7,"n_rows":38,"n_cols":13,"rows_kept":38,"cut":false,"hidden":false,"merged":[[18,5,18,7],[19,5,19,7],[20,5,20,7],[13,1,14,7],[5,1,5,3],[16,5,16,7],[34,1,34,7],[6,2,6,3],[7,1,7,7],[10,5,10,7],[28,1,28,3],[31,1,31,7],[32,1,32,7],[29,1,29,7],[30,1,30,7],[12,5,12,6],[9,1,9,7],[12,3,12,4],[17,5,17,7]]}
[{"$f":"VLOOKUP(Company, PicTable2, 2, FALSE)","v":"Picture2"},null,null,null,null,null,null,null,null,null,null,"COMPANY","PHOTO"]
[null,null,null,null,null,{"$f":"Company","v":"Industrial Welding & Engineering"},null,null,null,null,null,"MTC Engineering","Picture1"]
[null,null,null,null,null,{"$f":"Street","v":"747 Carle Ave."},null,null,null,null,null,"Industrial Welding & Engineering","Picture2"]
[null,null,null,null,null,{"$f":"State","v":"Lewis Center, OH 43035"},null,null,null,null,null,"MTC Engineering, LLC","Picture1"]
[null,null,null,null,null,{"$f":"Email","v":"iwe@columbus.rr.com"},null,null,null,null,null,"LCG Machine & Tool","Picture3"]
[null,null,null,null,null,{"$f":"\"Phone: \"&Phone","v":"Phone: 614-883-6109"},null,{"$f":"IF(Web>0.1,Web,\"\")","v":"www.iweohio.com"},null,null,null,"Alannas Engineer","Picture4"]
[null,null,null,null,null,{"$f":"\"Fax: \"&Fax","v":"Fax: email only"},null,null,null,null,null,"Westerville Mfg","Picture5"]
[null,"\"A Defense Contractor for Machined and Fabricated Spare Parts and Assemblies.\"",null,null,null,null,null,null,null,null,null,"Boehm Machine","Picture7"]
[null,null,null,null,null,null,null,null,null,null,null,"RC Industries, Inc.","Picture 3"]
[null,"INSPECTION/ACCEPTANCE RELEASE",null,null,null,null,null,null,null,null,null,"DSE Development","Picture 19"]
[null,null,null,null,null,null,null,null,null,null,null,"DuLond Tool & Engineering, Inc.","Picture 8"]
[null,null,null,null,null,null,null,null,null,null,null,"Maven Engineering Corporation","Picture 9"]
[null,"WORK ORDER#:",null,{"$f":"WO","v":0},null,"(est) SHIPPING DATE:",null,{"$f":"IF(ShipDate>1,ShipDate,\" \")","v":" "},null,null,null,"Fourply Design House","Picture 6"]
[null,{"$f":"IF(FAT_Code=\"TCN\",\"[X] - This is a TCN Shipment. Shipping Instructions required.\",IF(TDPFAT=\"FAT Package\",\"[X] - This is a FAT, Non-Post Shipment\",\" \"))","v":" "},null,null,null,null,null,null,null,null,null,"Lewis Center Mfg.","Picture 11"]
[null,null,null,null,null,null,null,null,null,null,null,"GTA Containers Inc.","Picture 12"]
[null,null,null,"CLIN #",null,"SHIP TO:"]
[null,null,null,{"$f":"IF(E17=\"X\",CLIN0001,\"\")","v":""},{"$f":"IF(FAT_Code>1,\"X\",\"\")","v":""},{"$f":"IF(E17=\"X\",FAT_Code&\" - \"&L22,\"\")","v":""},null,null,null,null,null,"Acromil Corp","Picture 20"]
[null,null,null,{"$f":"IF(E18=\"X\",CLIN0002,\"\")","v":""},{"$f":"IF(F17=\"FAT - *Per 52.209-4\",\" \",IF(Ship_2>1,\"X\",\"\"))","v":""},{"$f":"IF(F17=\"FAT - *Per 52.209-4\",\" \",IF(E18=\"X\",Ship_2&\" - \"&L23,\"\"))","v":""},null,null,null,null,null,"C. O. W. Industries, Inc.","Picture6"]
[null,null,null,{"$f":"IF(E19=\"X\",CLIN0003,\"\")","v":""},{"$f":"IF(Ship_3>1,\"X\",\"\")","v":""},{"$f":"IF(E19=\"X\",Ship_3&\" - \"&L24,\" \")","v":" "}]
[null,null,null,{"$f":"IF(E20=\"X\",CLIN0004,\"\")","v":""},{"$f":"IF(Ship_4>1,\"X\",\"\")","v":""},{"$f":"IF(E20=\"X\",Ship_4&\" - \"&L25,\"\")","v":""}]
[null,null,null,{"$f":"IF(E21=\"X\",CLIN0005,\"\")","v":""},{"$f":"IF(Ship_5>1,\"X\",\"\")","v":""},{"$f":"IF(E21=\"X\",Ship_5&\" - \"&L26,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(FAT_Code, ShipCodeTable, 2,FALSE )","v":{"$error":"#N/A"}}]
[null,"QUANTITY:",null,{"$f":"QTY","v":0},null,"ITEM DESCIRPTION:",null,{"$f":"Name","v":0},null,null,null,{"$f":"VLOOKUP(Ship_2, ShipCodeTable, 2, FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,"P/N",null,{"$f":"PN","v":0},null,null,null,{"$f":"VLOOKUP(Ship_3, ShipCodeTable, 2, FALSE)","v":{"$error":"#N/A"}}]
[null,"(I) Inspection Release",null,null,null,"REV",null,{"$f":"REV","v":0},null,null,null,{"$f":"VLOOKUP(Ship_4, ShipCodeTable, 2, FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(Ship_5, ShipCodeTable, 2, FALSE)","v":{"$error":"#N/A"}}]
[null,"(A) Acceptance Release to WAWF",null,null,null,"NSN:",null,{"$f":"NSN","v":0}]
[null,null,null,null,null,"CONTRACT #:",null,{"$f":"Contract","v":0}]
[null,"ADDITIONAL NOTES OR COMMENTS:"]
[]
[]
[]
[]
[]
[null,"THE REQUIRED CQA HAS BEEN PREFORMED ON THE ABOVE LISTED ITEMS"]
[]
[null,"DATE:",null,{"$f":"IF(AcceptDate>1,AcceptDate,\" \")","v":" "},null,"SIGNED:"]
[null,null,null,null,null,null,null,{"$f":"IF(DoDACC<\"SP\",DoDACC&\", DCMA-QAR\",\"\")","v":", DCMA-QAR"}]

{"sheet":"QA 012 - Final Accept-CoC","index":8,"n_rows":40,"n_cols":11,"rows_kept":40,"cut":false,"hidden":false,"merged":[[39,10,42,11],[30,8,30,9],[30,10,30,11],[37,8,37,9],[37,10,37,11],[35,8,35,9],[35,10,35,11],[33,8,33,9],[33,10,33,11],[32,8,32,9],[32,10,32,11],[31,8,31,9],[31,10,31,11],[34,8,34,9],[34,10,34,11],[36,8,36,9],[36,10,36,11],[9,4,10,5],[5,4,6,4],[4,5,7,5],[23,1,24,2],[5,1,5,2],[9,0,9,3],[8,1,8,2],[21,1,21,2]]}
[{"$f":"VLOOKUP(Company, PicTable3, 2, FALSE)","v":"Picture2"},null,{"$f":"Company","v":"Industrial Welding & Engineering"},null,null,null,null,"COMPANY","PHOTO"]
[null,null,{"$f":"Street","v":"747 Carle Ave."},null,null,null,null,"MTC Engineering","Pic6"]
[null,null,{"$f":"State","v":"Lewis Center, OH 43035"},null,null,null,null,"Industrial Welding & Engineering","Picture2"]
[null,null,{"$f":"\"Phone: \"&Phone&\"  -  \"&Email","v":"Phone: 614-883-6109  -  iwe@columbus.rr.com"},null,null,null,null,"MTC Engineering, LLC","Pic6"]
[null,null,{"$f":"\"Fax: \"&Fax","v":"Fax: email only"},null,"Inspection Release Type","<-Select Contract Clause",null,"LCG Machine & Tool","Pic8"]
[null,"\"A Defense Contractor for Machined and Fabricated Spare Parts and Assemblies.\"",null,null,"Source-General FAR 52.246-1 or 52.246-2",null,null,"Alannas Engineer","Picture4"]
[null,null,null,null,null,null,null,"Westerville Mfg","Pic10"]
[null,null,null,null,"See Contract Clause Section \"E\"",null,null,"Boehm Machine","Boehm"]
[null,{"$f":"IF(TDPFAT=\"TDP Package\",\"SOLICITATION REQUIREMENT(S) REVIEW\",IF(TDPFAT=\"FAT Package\",\"FAT Review and Final Acceptance\",\"FINAL ACCEPTANCE\"))","v":"FINAL ACCEPTANCE"},null,null,null,null,null,"RC Industries, Inc.","Picture 3"]
[{"$f":"IF(InspectClause=\"Source CoQC Contract FAR 52.246-9000\",\"CERTIFICATE OF QUALITY COMPLIANCE\",\"CERTIFICATE OF COMPLIANCE\")","v":"CERTIFICATE OF COMPLIANCE"},null,null,null,{"$f":"IF(InspectClause=\"Source CoGC Contract FAR 52.246-9000\",\"NOTE: With a CofGC, you must attach the Contract Review sheet and upload into WAWF.\",\"\")","v":""},null,null,"DuLond Tool & Engineering, Inc.","Picture 1"]
[null,null,null,null,null,null,null,"Maven Engineering Corporation","Picture 9"]
[null,"CUSTOMER",{"$f":"IF(Customer>0.1,Customer,\" \")","v":" "},null,null,null,null,"Fourply Design House","Picture 6"]
[null,{"$f":"IF(TDPFAT<>\"TDP Package\",\"CONTRACT/PO\",\"SOLICITATION\")","v":"CONTRACT/PO"},{"$f":"IF(Customer_PO>=Contract,Customer_PO,Contract)","v":0},null,null,null,null,"Lewis Center Mfg.","Picture 11"]
[null,{"$f":"IF(TDPFAT<>\"TDP Package\",\"WORK ORDER No.\",\"RFQ/RFP Reference No.:\")","v":"WORK ORDER No."},{"$f":"IF(WO>0.1,WO,\" \")","v":" "},null,null,null,null,"ADJ Finishing","Picture 4"]
[null,null,null,null,null,null,null,"GTA Containers Inc.","Picture 12"]
[null,"NSN",{"$f":"IF(NSN>0.1,NSN,\" \")","v":" "},null,null,null,null,"Acromil Corp.","Picture 20"]
[null,"NAME",{"$f":"IF(Name>0.1,Name,\" \")","v":" "},null,null,null,null,"C. O. W. Industries, Inc.","Picture6"]
[null,"P/N - DRAWING",{"$f":"IF(PN>0.1,PN,\" \")","v":" "},null,null,null,null,"DSE Development","Picture 23"]
[null,"REVISION LEVEL",{"$f":"IF(REV>0.1,REV,\" \")","v":" "}]
[null,"QUANTITY",{"$f":"IF(QTY>0.1,QTY,\" \")","v":" "}]
[null,"SPECIAL NOTES:",{"$f":"IF(TDPFAT=\"FAT Package\",FAT_FAR,\"\")","v":""},null,null,null,null,"Note: FAT units are herein certified to be representative of production units as required per contract clause FAR 52.209-901(G)."]
[null,{"$f":"VLOOKUP(InspectClause, InspClauseTable, 2, FALSE)","v":"I, the undersigned, certify that on this date of execution and as the representative agent for the above forgoing company and/or legal entity did furnish the supplies or services as duly noted by hereon referenced contract/purchase order and which said items/services were shipped in accordance with all applicable requirements as noted per FAR 52.246-1 & 52.246-2 and duly noted on attached shipping documents."}]
[]
[null,{"$f":"VLOOKUP(InspectClause, InspClauseTable, 4, FALSE)","v":" I further certify that the supplies or services are of the quality specified, including inspection to a higher-level quality standard based on a tailored ISO QMS, which meets the requirements of FAR 52.246-11 and conform in all respects with the contract requirements, including specifications, drawings, preservation, packaging, packing, marking requirements, and physical item identification as noted and described above, and are in the quantity shown on this or on the attached acceptance document."}]
[]
[]
[null,null,{"$f":"IF(AcceptDate>1,AcceptDate,\" \")","v":" "}]
[null,{"$f":"IF(Inspector>1,Inspector,\"Enter Inspector Name - Use Dropdown\")","v":"Enter Inspector Name - Use Dropdown"},"Date of Execution"]
[]
[]
[null,null,null,null,null,null,null,"Inspection C of C Clauses","Clauses",null,"Clauses"]
[null,null,null,null,null,null,null,"Source-General FAR 52.246-1 or 52.246-2","I, the undersigned, certify that on this date of execution and as the representative agent for the above forgoing company and/or legal entity did furnish the supplies or services as duly noted by hereon referenced contract/purchase order and which said items/services were shipped in accordance with all applicable requirements as noted per FAR 52.246-1 & 52.246-2 and duly noted on attached shipping documents.",null," I further certify that the supplies or services are of the quality specified, including inspection to a higher-level quality standard based on a tailored ISO QMS, which meets the requirements of FAR 52.246-11 and conform in all respects with the contract requirements, including specifications, drawings, preservation, packaging, packing, marking requirements, and physical item identification as noted and described above, and are in the quantity shown on this or on the attached acceptance document."]
[null,null,null,null,null,null,null,"Source C of C Contract FAR 52.246-15","I, the undersigned, certify that on this date of execution and as the representative agent for the above forgoing company and/or legal entity did furnish the supplies or services as duly noted by hereon referenced contract/purchase order and which said items/services were shipped in accordance with all applicable requirements as noted per FAR Clause 52.246-15 and duly noted on attached shipping documents.",null," I further certify that the supplies or services are of the quality specified, including inspection to a higher-level quality standard based on a tailored ISO QMS, which meets the requirements of FAR 52.246-11, and conform in all respects with the contract requirements, including specifications, drawings, preservation, packaging, packing, marking requirements, and physical item identification as noted and described above, and are in the quantity shown on this or on the attached acceptance document."]
[null,null,null,null,null,null,null,"Source ARP Contract DFARS 246.471","I, the undersigned, certify that on this date of execution and as the representative agent for the above forgoing company and/or legal entity did furnish the supplies or services as duly noted by hereon referenced contract/purchase order and which said items/services were shipped in accordance with all applicable requirements as noted per DFARS Clause 246.471 and duly noted on attached shipping documents.",null," I further certify that the supplies or services are of the quality specified, including inspection to a higher-level quality standard based on a tailored ISO QMS, which meets the requirements of FAR 52.246-11, and conform in all respects with the contract requirements, including specifications, drawings, preservation, packaging, packing, marking requirements, and physical item identification as noted and described above, and are in the quantity shown on this or on the attached acceptance document."]
[null,null,null,null,null,null,null,"FAT 52.209-4 with ISO QMS Tailored","We certify that the product listed above was manufactured and inspected in accordance with company quality system standards and all applicable specifications, drawings, customer and/or purchase order/contract requirements including a higher-level quality standards based on a tailored ISO9000 QMS, which may be required per FAR 52.246-11.",null,"We certify that the items supplied on the above referenced purchase order/contract have no mercury or mercury components and that no mercury bearing instruments and/or equipment have been used in any manner which may cause contamination in the manufacture, assembly, testing or final processing of said material."]
[null,null,null,null,null,null,null,"TDP 52.246-11 with ISO QMS Tailored","We certify that the product listed above was manufactured and inspected in accordance with company quality system standards and all applicable specifications, drawings, customer and/or purchase order/contract requirements including a higher-level quality standards based on a tailored ISO9000 QMS, which may be required per FAR 52.246-11.",null,"We certify that the items supplied on the above referenced purchase order/contract have no mercury or mercury components and that no mercury bearing instruments and/or equipment have been used in any manner which may cause contamination in the manufacture, assembly, testing or final processing of said material."]
[null,null,null,null,null,null,null,"Source CoQC Contract FAR 52.246-9000",{"$f":"Company &\" herein certifies that per 52.246-9000, all quality requirements and  specifications have been adhered to and fully comply as attested to in this certificate and defined on attached supplemental sheets.\" &\" We further certify that (i) the lot has been produced, sampled, tested, and inspected, and marked in accordance with all contract and specification requirements; and (ii) the material complies with all of the contract and specification requirements.\"","v":"Industrial Welding & Engineering herein certifies that per 52.246-9000, all quality requirements and  specifications have been adhered to and fully comply as attested to in this certificate and defined on attached supplemental sheets. We further certify that (i) the lot has been produced, sampled, tested, and inspected, and marked in accordance with all contract and specification requirements; and (ii) the material complies with all of the contract and specification requirements."},null," We further certify that the supplies or services are of the quality specified, including inspection to a higher-level quality standard based on a tailored ISO QMS, which meets the requirements of FAR 52.246-11, and conform in all respects with the contract requirements, including specifications, drawings, preservation, packaging, packing, marking requirements, and physical item identification as noted and described above, and are in the quantity shown on this or on the attached acceptance document."]
[null,null,null,null,null,null,null,"Commercial & Destination General C of C","We certify that the product listed above was manufactured and inspected in accordance with company quality system standards and all applicable specifications, drawings, customer and/or purchase order/contract requirements including a higher-level quality standards based on a tailored ISO9000 QMS, which may be required per FAR 52.246-11.",null,"We certify that the items supplied on the above referenced purchase order/contract have no mercury or mercury components and that no mercury bearing instruments and/or equipment have been used in any manner which may cause contamination in the manufacture, assembly, testing or final processing of said material."]
[]
[null,null,null,null,null,null,null,null,null,null,"I certify that on ______ [insert date], the ____ [insert Contractor’s name] furnished the supplies or services called for by Contract No._____ via ____ [Carrier] on ________ [identify the bill of lading or shipping document] in accordance with all applicable requirements."]

{"sheet":"QA 012-1 - Special - CoC","index":9,"n_rows":32,"n_cols":15,"rows_kept":32,"cut":false,"hidden":true,"merged":[[0,2,0,3],[6,0,6,3],[8,0,8,3],[15,1,15,3],[20,1,20,3],[21,1,21,3],[18,0,21,0],[18,1,18,3],[19,1,19,3],[31,2,31,3],[30,2,30,3],[27,2,27,3],[28,2,28,3],[22,0,22,3],[24,0,24,3]]}
[{"$f":"VLOOKUP(Company4, PicTable7, 2, FALSE)","v":"Picture2"},null,"Industrial Welding & Engineering",null,null,"<- Company Drop-Down",null,"COMPANY","PHOTO","Address","State","Phone","Fax","Email","Web"]
[null,null,{"$f":"VLOOKUP(Company4, PicTable7, 3, FALSE)","v":"747 Carle Ave."},{"$f":"VLOOKUP(Company4, PicTable7, 8, FALSE)","v":"www.iweohio.com"},null,null,null,"MTC Engineering","Pic11","747 Carle Ave.","Lewis Center, OH 43035","614-657-8666","FX: 614-540-7442","mtcengineering@att.net","www.mtcengco.com"]
[null,null,{"$f":"VLOOKUP(Company4, PicTable7, 4, FALSE)","v":"Lewis Center, OH 43035"},null,null,null,null,"Industrial Welding & Engineering","Picture2","747 Carle Ave.","Lewis Center, OH 43035","614-883-6109","FX: 614-737-9320","iwe@columbus.rr.com","www.iweohio.com"]
[null,null,{"$f":"VLOOKUP(Company4, PicTable7, 7, FALSE)","v":"iwe@columbus.rr.com"},null,null,null,null,"MTC Engineering, LLC","Pic11","747 Carle Ave.","Lewis Center, OH 43035","614-657-8666","FX: 614-540-7442","mtcengllc@att.net","www.mtcengco.com"]
[null,null,{"$f":"VLOOKUP(Company4, PicTable7, 5, FALSE)","v":"614-883-6109"},{"$f":"VLOOKUP(Company4, PicTable7, 6, FALSE)","v":"FX: 614-737-9320"},null,null,null,"Alannas Engineer","Picture4","9710-A Owensmouth Ave.","Chatsworth, CA 91311","818-701-1522","FX: 818-701-0316","alannasengineer@yahoo.com"]
[null,null,null,null,null,null,null,"LCG Machine & Tool","Pic13","2923 Grasemere Ave.","Columbus, OH 43224","614-261-1651","FX: 614-447-8051","sales@lcgmachine.com","www.lcgmachine.com"]
["Defense Contractors- Spare Parts and Assemblies Machined, Welded and Fabricated",null,null,null,null,null,null,"Westerville Mfg","Pic15","935 Schrock Rd.","Columbus, OH 43229","614-888-9088","FX: 614-888-9188","wmfginc@sbcglobal.net","www.wmfginc.com"]
[null,null,null,null,null,null,null,"Boehm Machine","Boehm","1297 Memory Lane, N","Columbus, OH 43209","614-252-3778","FX: 614-237-5262","gkboehm@wideopenwest.com"]
["CERTIFICATE OF CONFORMANCE & TESTING",null,null,null,null,null,null,"RC Industries, Inc.","Picture 3","7755 Alabama Ave., Ste 6/8","Canoga, CA 91304","818-883-0855","FX: 818-883-2537","rcind@sbcglobal.net","www.rcindcorp.com"]
[null,null,null,null,null,null,null,"Lewis Center Mfg.","Picture 11","747 Carle Ave.","Lewis Center, OH 43035","614-560-6122","614-737-9320","Lewiscentermfg@gmail.com"]
["Customer",{"$f":"Customer","v":0},"NSN",{"$f":"NSN","v":0},null,null,null,"Fourply Design House","Picture 5","747 Carle Ave.","Lewis Center, OH 43035","910-381-3110","614-737-9320","njsanna@fourplydesign.com","www.fourplydesign.com"]
["Date",{"$f":"ShipDate","v":"00:00:00"},"Rev",{"$f":"UPPER(REV)","v":""},null,null,null,"DuLond Tool & Engineering, Inc.","Picture 1","2306 Whitfield Park Loop","Sarasota, FL 34243","941-758-4489","FX: 941-753-5592","gbrunette@dulondtool.com","www.dulondtool.com"]
["Customer PO #",{"$f":"IF(Customer_PO>0.1,Customer_PO,Contract)","v":0},"Part Number",{"$f":"UPPER(PN)","v":""},null,null,null,"ADJ Finishing","Picture 4","7845 Gloria Ave.","Van Nuys, CA 91406","818-786-5131","818-786-6165","adjfinishing@hotmail.com","www.adjfinishing.com"]
["Work Order #",{"$f":"WO","v":0},"Order Quantity",{"$f":"QTY","v":0},null,null,null,"GTA Containers Inc.","Picture 12","4201 Linden Ave.","South Bend, IN.  46619","574-288-3459","574-288-1997","victoria@gtacontainers.com","www.gtacontainers.com"]
[null,null,null,null,null,null,null,"C. O. W. Industries, Inc.","Picture6","1875 Progress Ave.","Columbus, OH 43207","614-445-5516","FX: 614-443-5530","james.dailey@cowind.com","www.cowind.com"]
["Special Requirement:","Water Washable Fluorescent Penetrant testing and visual inspection was preformed on (QTY) (PN) per MIL-STD-6866 (Supr by ASTM E1417). No relevant indications were found and parts were found acceptable."]
[]
["Test Quantity",null,"Acceptance Quantity"]
["Special Material Requirements:","Magnaflux Penetrant Zyglo, Batch # 99H047"]
[null,"Magnaflux Cleaner SKC-S, Batch # 01G12K"]
[null,"Magnaflux Developer SKD-S2, Batch # 88L043"]
[null,"Water Remover"]
[{"$f":"VLOOKUP(InspectClause, InspClauseTable, 2, FALSE)","v":"I, the undersigned, certify that on this date of execution and as the representative agent for the above forgoing company and/or legal entity did furnish the supplies or services as duly noted by hereon referenced contract/purchase order and which said items/services were shipped in accordance with all applicable requirements as noted per FAR 52.246-1 & 52.246-2 and duly noted on attached shipping documents."}]
[]
[{"$f":"VLOOKUP(InspectClause, InspClauseTable, 4, FALSE)","v":" I further certify that the supplies or services are of the quality specified, including inspection to a higher-level quality standard based on a tailored ISO QMS, which meets the requirements of FAR 52.246-11 and conform in all respects with the contract requirements, including specifications, drawings, preservation, packaging, packing, marking requirements, and physical item identification as noted and described above, and are in the quantity shown on this or on the attached acceptance document."}]
[]
[]
[null,"Signed/Dated:",null,null,null,"<--Select from Drop-down"]
[null,null,"QE/Quality Tech"]
[]
[null,"Signed/Dated:",null,null,null,"<--Select from Drop-down"]
[null,null,"Engineering/QA"]

{"sheet":"QA 012-2 - Special - CoC","index":10,"n_rows":32,"n_cols":15,"rows_kept":32,"cut":false,"hidden":true,"merged":[[0,2,0,3],[28,2,28,3],[30,2,30,3],[31,2,31,3],[22,0,22,3],[24,0,24,3],[27,2,27,3],[6,0,6,3],[8,0,8,3],[15,1,15,3],[18,0,21,0],[18,1,18,3],[19,1,19,3],[20,1,20,3],[21,1,21,3]]}
[{"$f":"VLOOKUP(Company3, PicTable6, 2, FALSE)","v":"Picture2"},null,"Industrial Welding & Engineering",null,null,"<-Company Drop-Down",null,"COMPANY","PHOTO","Address","State","Phone","Fax","Email","Web"]
[null,null,{"$f":"VLOOKUP(Company3, PicTable6, 3, FALSE)","v":"747 Carle Ave."},{"$f":"VLOOKUP(Company3, PicTable6, 8, FALSE)","v":"www.iweohio.com"},null,null,null,"MTC Engineering","Pic11","747 Carle Ave.","Lewis Center, OH 43035","614-657-8666","FX: 614-540-7442","mtcengineering@att.net","www.mtcengco.com"]
[null,null,{"$f":"VLOOKUP(Company3, PicTable6, 4, FALSE)","v":"Lewis Center, OH 43035"},null,null,null,null,"Industrial Welding & Engineering","Picture2","747 Carle Ave.","Lewis Center, OH 43035","614-883-6109","FX: 614-737-9320","iwe@columbus.rr.com","www.iweohio.com"]
[null,null,{"$f":"VLOOKUP(Company3, PicTable6, 7, FALSE)","v":"iwe@columbus.rr.com"},null,null,null,null,"MTC Engineering, LLC","Pic11","747 Carle Ave.","Lewis Center, OH 43035","614-657-8666","FX: 614-540-7442","mtcengllc@att.net","www.mtcengco.com"]
[null,null,{"$f":"VLOOKUP(Company3, PicTable6, 5, FALSE)","v":"614-883-6109"},{"$f":"VLOOKUP(Company3, PicTable6, 6, FALSE)","v":"FX: 614-737-9320"},null,null,null,"Alannas Engineer","Picture4","9710-A Owensmouth Ave.","Chatsworth, CA 91311","818-701-1522","FX: 818-701-0316","alannasengineer@yahoo.com"]
[null,null,null,null,null,null,null,"LCG Machine & Tool","Pic13","2923 Grasemere Ave.","Columbus, OH 43224","614-261-1651","FX: 614-447-8051","sales@lcgmachine.com","www.lcgmachine.com"]
["Defense Contractors- Spare Parts and Assemblies Machined, Welded and Fabricated",null,null,null,null,null,null,"Westerville Mfg","Pic15","935 Schrock Rd.","Columbus, OH 43229","614-888-9088","FX: 614-888-9188","wmfginc@sbcglobal.net","www.wmfginc.com"]
[null,null,null,null,null,null,null,"Boehm Machine","Boehm","1297 Memory Lane, N","Columbus, OH 43209","614-252-3778","FX: 614-237-5262","gkboehm@wideopenwest.com"]
["CERTIFICATE OF CONFORMANCE & TESTING",null,null,null,null,null,null,"RC Industries, Inc.","Picture 3","7755 Alabama Ave., Ste 6/8","Canoga, CA 91304","818-883-0855","FX: 818-883-2537","rtcind@sbcglobal.net","www.rcindcorp.com"]
[null,null,null,null,null,null,null,"Lewis Center Mfg.","Picture 11","747 Carle Ave.","Lewis Center, OH 43035","614-560-6122","614-737-9320","Lewiscentermfg@gmail.com"]
["Customer",{"$f":"Customer","v":0},"NSN",{"$f":"NSN","v":0},null,null,null,"Fourply Design House","Picture 5","747 Carle Ave.","Lewis Center, OH 43035","910-381-3110","614-737-9320","njsanna@fourplydesign.com","www.fourplydesign.com"]
["Date",{"$f":"ShipDate","v":"00:00:00"},"Rev",{"$f":"UPPER(REV)","v":""},null,null,null,"DuLond Tool & Engineering, Inc.","Picture 1","2306 Whitfield Park Loop","Sarasota, FL 34243","941-758-4489","FX: 941-753-5592","gbrunette@dulondtool.com","www.dulondtool.com"]
["Customer PO #",{"$f":"IF(Customer_PO>0.1,Customer_PO,Contract)","v":0},"Part Number",{"$f":"UPPER(PN)","v":""},null,null,null,"ADJ Finishing","Picture 4","7845 Gloria Ave.","Van Nuys, CA 91406","818-786-5131","818-786-6165","adjfinishing@hotmail.com","www.adjfinishing.com"]
["Work Order #",{"$f":"WO","v":0},"Order Quantity",{"$f":"QTY","v":0},null,null,null,"GTA Containers Inc.","Picture 12","4201 Linden Ave.","South Bend, IN.  46619","574-288-3459","574-288-1997","victoria@gtacontainers.com","www.gtacontainers.com"]
[null,null,null,null,null,null,null,"C. O. W. Industries, Inc.","Picture6","1875 Progress Ave.","Columbus, OH 43207","614-445-5516","FX: 614-443-5530","james.dailey@cowind.com","www.cowind.com"]
["Special Requirement:","Weld per"]
[]
["Test Quantity",null,"Acceptance Quantity"]
["Special Material Requirements:"]
[]
[]
[]
[{"$f":"VLOOKUP(InspectClause, InspClauseTable, 2, FALSE)","v":"I, the undersigned, certify that on this date of execution and as the representative agent for the above forgoing company and/or legal entity did furnish the supplies or services as duly noted by hereon referenced contract/purchase order and which said items/services were shipped in accordance with all applicable requirements as noted per FAR 52.246-1 & 52.246-2 and duly noted on attached shipping documents."}]
[]
[{"$f":"VLOOKUP(InspectClause, InspClauseTable, 4, FALSE)","v":" I further certify that the supplies or services are of the quality specified, including inspection to a higher-level quality standard based on a tailored ISO QMS, which meets the requirements of FAR 52.246-11 and conform in all respects with the contract requirements, including specifications, drawings, preservation, packaging, packing, marking requirements, and physical item identification as noted and described above, and are in the quantity shown on this or on the attached acceptance document."}]
[]
[]
[null,"Signed/Dated:",null,null,null,"<--Select from Drop-down"]
[null,null,"QE/Quality Tech"]
[]
[null,"Signed/Dated:",null,null,null,"<--Select from Drop-down"]
[null,null,"Engineering Authorization"]

{"sheet":"QA 012-3 Prime & Paint CoC","index":11,"n_rows":36,"n_cols":18,"rows_kept":36,"cut":false,"hidden":true,"merged":[[6,1,6,3],[10,1,10,3],[4,0,4,6],[0,3,0,6],[12,0,12,6],[7,1,7,3],[8,1,8,3],[9,1,9,3],[28,1,28,6],[36,5,36,6],[31,4,31,6],[32,0,32,1],[30,4,30,6],[34,4,34,6],[35,4,35,6],[34,0,34,2],[35,0,35,2]]}
[{"$f":"VLOOKUP(Company2, PicTable5, 2, FALSE)","v":"Picture2"},null,null,"Industrial Welding & Engineering",null,null,null,null,null,null,"COMPANY","PHOTO","Address","State","Phone","Fax","Email","Web"]
[null,null,null,{"$f":"VLOOKUP(Company2, PicTable5, 3, FALSE)","v":"747 Carle Ave."},null,null,null,null,null,null,"MTC Engineering","Pic16","747 Carle Ave.","Lewis Center, OH 43035","614-657-8666","614-540-7442","mtcengineering@att.net","www.mtcengco.com"]
[null,null,null,{"$f":"VLOOKUP(Company2, PicTable5, 4, FALSE)","v":"Lewis Center, OH 43035"},null,null,null,null,null,null,"Industrial Welding & Engineering","Picture2","747 Carle Ave.","Lewis Center, OH 43035","614-883-6109","614-737-9320","iwe@columbus.rr.com","www.iweohio.com"]
[null,null,null,"Phone:",{"$f":"VLOOKUP(Company2, PicTable5, 5, FALSE)","v":"614-883-6109"},"Fax:",{"$f":"VLOOKUP(Company2, PicTable5, 6, FALSE)","v":"614-737-9320"},null,null,null,"MTC Engineering, LLC","Pic16","747 Carle Ave.","Lewis Center, OH 43035","614-657-8666","614-540-7442","mtcengllc@att.net","www.mtcengco.com"]
["CERTIFICATION",null,null,null,null,null,null,null,null,null,"Alannas Engineer","Picture4","9710-A Owensmouth Ave.","Chatsworth, CA 91311","818-701-1522","818-701-0316","alannasengineer@yahoo.com"]
[null,null,null,null,null,null,null,null,null,null,"LCG Machine & Tool","Pic18","2923 Grasemere Ave.","Columbus, OH 43224","614-261-1651","614-447-8051","sales@lcgmachine.com","www.lcgmachine.com"]
["DATE:",{"$f":"IF(AcceptDate>1,AcceptDate-2,\" \")","v":" "},null,null,null,null,null,null,null,null,"Westerville Mfg","Pic20","935 Schrock Rd.","Columbus, OH 43229","614-888-9088","614-888-9188","wmfginc@sbcglobal.net","www.wmfginc.com"]
["Part Number:",{"$f":"PN","v":0},null,null,null,null,null,null,null,null,"Boehm Machine","Boehm","1297 Memory Lane, N","Columbus, OH 43209","614-252-3778","614-237-5262","gkboehm@wideopenwest.com"]
["Description:",{"$f":"Name","v":0},null,null,null,null,null,null,null,null,"RC Industries, Inc.","Picture 3","7755 Alabama Ave., Ste 6/8","Canoga, CA 91304","818-883-0855","818-883-2537","tcind@sbcglobal.net"]
["Order Quantity:",{"$f":"QTY","v":0},null,null,null,null,null,null,null,null,"DuLond Tool & Engineering, Inc.","Picture 1","2306 Whitfield Park Loop","Sarasota, FL 34243","941-758-4489","941-753-5592","gbrunette@dulondtool.com","www.dulondtool.com"]
["Purchase Order:",{"$f":"WO","v":0},null,null,null,null,null,null,null,null,"Lewis Center Mfg.","Picture 11","747 Carle Ave.","Lewis Center, OH 43035","614-560-6122","614-737-9320","Lewiscentermfg@gmail.com"]
[null,null,null,null,null,null,null,null,null,null,"Fourply Design House","Picture 5","747 Carle Ave.","Lewis Center, OH 43035","910-381-3110","614-737-9320","nic@iweohio.com","www.fourplydesign.com"]
["        This is to certify that the parts listed below were processed, tested, and inspected in accordance with the applicable specifications.",null,null,null,null,null,null,null,null,null,"ADJ Finishing","Picture 4","7845 Gloria Ave.","Van Nuys, CA 91406","818-786-5131","818-786-6165","adjfinishing@hotmail.com","www.adjfinishing.com"]
[null,null,null,null,null,null,null,null,null,null,"GTA Containers Inc.","Picture 12","4201 Linden Ave.","South Bend, IN.  46619","574-288-3459","574-288-1997","victoria@gtacontainers.com","www.gtacontainers.com"]
["Process","Description","Spec","Rev","Mfg","Batch","Exp",null,null,null,"C. O. W. Industries, Inc.","Picture6","1875 Progress Ave.","Columbus, OH 43207","614-445-5516","614-443-5530","james.dailey@cowind.com","www.cowind.com"]
[]
["Cleaning:"]
[]
["Pretreatment:","Wash Prime","MIL-B-15328","D","SW","0L0369H","2010-02-05"]
[]
["Primer:","Epoxy, Corr-Inh","MIL-P-53022","C","SW","0L0689J","2010-03-09"]
[]
["Paint:","CARC","MIL-DTL-53039","B","SW","0X3508C","2009-12-15"]
[]
["Powder:"]
[]
["Color:","383 (Green)","FED-STD-595","C"]
[]
["Application:"]
[]
["Test Procedure:","Standard Test","FED-STD-141","D","* TESTING NOTES:"]
[null,null,null,null,"NOTE: Minimum testing required for non-aircraft application is Visual, Adhesion, Knife & Flexibility. Additional tests for Aircraft applications include *Salt Spray, *Jet Fuel Soak and *Abrasion."]
[{"$f":"Company","v":"Industrial Welding & Engineering"},null,{"$f":"Cage","v":"3NBK9"}]
[]
[]
["Tony Casillas",null,null,null,"*Tests performed by Sherwin-Williams"]

{"sheet":"QA 013 - Contract Review","index":12,"n_rows":58,"n_cols":9,"rows_kept":58,"cut":false,"hidden":false,"merged":[[0,0,1,5],[4,3,4,6],[6,5,6,6],[11,2,11,3],[11,4,11,6],[2,1,3,6],[47,2,47,6],[9,3,9,6],[25,1,25,8],[6,7,6,8],[7,5,7,6],[7,7,7,8],[12,2,12,3],[12,4,12,6],[13,2,13,3],[13,4,13,6],[14,2,14,3],[14,4,14,6],[15,2,15,3],[15,4,15,6],[22,4,22,6],[23,2,23,3],[51,1,51,2],[51,4,51,5],[58,1,58,8],[53,1,53,2],[53,3,53,4],[54,1,54,3],[54,4,54,8],[55,1,55,8],[56,4,56,8],[57,4,57,5],[51,6,51,8],[52,6,52,8],[23,4,23,6],[19,2,19,3],[52,1,52,2],[52,4,52,5],[41,1,41,8],[46,2,46,6],[38,2,38,3],[38,4,38,6],[39,2,39,3],[39,4,39,6],[43,2,43,6],[44,2,44,6],[45,2,45,6],[49,1,49,8],[29,2,29,3],[29,4,29,6],[16,2,16,3],[16,4,16,6],[17,2,17,3],[17,4,17,6],[28,2,28,3],[28,4,28,6],[27,2,27,3],[27,4,27,6],[19,4,19,6],[20,2,20,3],[20,4,20,6],[21,2,21,3],[21,4,21,6],[18,2,18,3],[18,4,18,6],[22,2,22,3],[30,2,30,3],[30,4,30,6],[31,2,31,3],[31,4,31,6],[32,2,32,3],[32,4,32,6],[36,2,36,3],[36,4,36,6],[37,2,37,3],[37,4,37,6],[33,2,33,3],[33,4,33,6],[34,2,34,3],[34,4,34,6],[35,2,35,3],[35,4,35,6]]}
[{"$f":"Company","v":"Industrial Welding & Engineering"}]
[null,null,null,null,null,null,null,"Page:"]
[null,{"$f":"IF(InspectClause=\"Source CoQC Contract FAR 52.246-9000\",\"CoQC Process/Qualification Standards Summary (FAR 52.246-9000)\",\"\")","v":""},null,null,null,null,null,"Pages:"]
[]
[null,null,null,{"$f":"IF(TDPFAT<>\"TDP Package\",\"CONTRACT REVIEW SHEET\",\"SOLICITATION REVIEW SHEET\")","v":"CONTRACT REVIEW SHEET"},null,null,null,"DATE",{"$f":"IF(DwgRvw>1,DwgRvw,\" \")","v":" "}]
[]
[null,"CONTRACT #",{"$f":"Contract","v":0},"QUANTITY",{"$f":"QTY","v":0},"NAME",null,"ASSEMBLY P/N"]
[null,"N.S.N",{"$f":"NSN","v":0},"Rev:",{"$f":"UPPER(REV)","v":""},{"$f":"Name","v":0},null,{"$f":"PN","v":0}]
[]
[null,null,null,{"$f":"IF(TDPFAT<>\"TDP Package\",\"CONTRACT DRAWING REVIEW SHEET\",\"SOLICITATION DRAWING REVIEW SHEET\")","v":"CONTRACT DRAWING REVIEW SHEET"}]
[]
[null,null,"DRAWINGS NUMBER",null,"DESCRIPTION",null,null,"REVISION","REV DATE"]
[null,1]
[null,{"$f":"B13+1","v":2}]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[]
[null,{"$f":"IF(TDPFAT<>\"TDP Package\",\"CONTRACT UNIQUE MATERIAL/PROCESSING SPECIFICATION REVIEW\",\"SOLICITATION UNIQUE MATERIAL/PROCESSING SPECIFICATION REVIEW\")","v":"CONTRACT UNIQUE MATERIAL/PROCESSING SPECIFICATION REVIEW"}]
[]
[null,"DRAWING","SPECIFICATION",null,"DESCRIPTION",null,null,"REVISION","REV DATE"]
[null,1]
[null,{"$f":"B29+1","v":2}]
[null,{"$f":"B30+1","v":3}]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[]
[null,{"$f":"IF(TDPFAT<>\"TDP Package\",\"CONTRACT UNIQUE QAP/CDRL/SPI - QUALITY REQUIREMENTS & SPECIAL INSTRUCTIONS REVIEW\",\"SOLICITATION UNIQUE QAP/CDRL/SPI - QUALITY REQUIREMENTS & SPECIAL INSTRUCTIONS REVIEW\")","v":"CONTRACT UNIQUE QAP/CDRL/SPI - QUALITY REQUIREMENTS & SPECIAL INSTRUCTIONS REVIEW"}]
[]
[null,null,"QAP/CDRL/SPI NUMBER",null,"REVISION",null,null,"REVISION","REV DATE"]
[null,1]
[null,{"$f":"B45+1","v":2}]
[null,{"$f":"B46+1","v":3}]
[null,{"$f":"B47+1","v":4}]
[]
[null,"IDENTIFICATION TYPE (see detail sheets for specifics)"]
[]
[null,"SPECIFICATION",null,"REVISION","DESCRIPTIVE",null,"TYPE"]
[null,"MIL-STD-130",null,"N","Parts Identification",null,"Rubber Stamp"]
[]
[]
[]
[null,"REVIEW BY:"]
[null,null,null,null,"Signature"]

{"sheet":"QA 015a - Top Assy","index":13,"n_rows":41,"n_cols":29,"rows_kept":41,"cut":false,"hidden":false,"merged":[[1,25,2,25],[6,1,7,1],[6,2,7,3],[6,4,7,4],[6,5,7,6],[4,4,4,5],[4,6,5,7],[6,11,10,13],[0,1,0,3],[0,4,0,9],[2,1,2,2],[2,5,2,7],[3,2,3,3],[3,5,3,7],[6,8,7,8],[8,2,8,3],[9,2,9,3],[10,2,10,3],[6,9,7,9],[0,27,0,28],[1,17,2,17],[1,20,2,21],[1,22,2,24],[1,26,2,28],[4,15,7,15],[4,16,7,16],[4,18,5,28],[6,18,7,18],[6,20,7,20],[6,21,7,21],[6,22,7,22],[6,23,7,23],[6,24,7,24],[6,25,7,25],[6,26,7,26],[6,27,7,27],[6,28,7,28],[0,15,2,16],[1,18,2,19],[0,21,0,22],[0,25,0,26],[4,17,7,17],[6,19,7,19],[27,2,27,3],[28,2,28,3],[29,2,29,3],[12,2,12,3],[18,2,18,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[17,2,17,3],[11,2,11,3],[40,1,40,2],[40,3,40,5],[40,8,40,9],[31,2,31,3],[32,2,32,3],[33,2,33,3],[34,2,34,3],[35,2,35,3],[37,1,37,9],[38,1,39,2],[38,3,39,5],[38,6,38,7],[38,8,38,9],[39,8,39,9],[30,2,30,3],[19,2,19,3],[20,2,20,3],[21,2,21,3],[22,2,22,3],[23,2,23,3],[24,2,24,3],[25,2,25,3],[26,2,26,3],[41,1,41,2],[41,3,41,5],[41,8,41,9],[42,1,42,2],[42,3,42,5],[42,8,42,9],[43,1,43,2],[43,3,43,5],[43,8,43,9],[51,1,51,2],[51,3,51,5],[51,8,51,9],[49,1,49,2],[49,3,49,5],[49,8,49,9],[50,1,50,2],[50,3,50,5],[50,8,50,9],[47,1,47,2],[47,3,47,5],[47,8,47,9],[44,1,44,2],[44,3,44,5],[44,8,44,9],[48,1,48,2],[48,3,48,5],[48,8,48,9],[45,1,45,2],[45,3,45,5],[45,8,45,9],[46,1,46,2],[46,3,46,5],[46,8,46,9]]}
[null,{"$f":"Company","v":"Industrial Welding & Engineering"},null,null,{"$f":"IF(TDPFAT<>\"TDP Package\",\"RECEIVING/IN-PROCESS/FINAL INSPECTION REPORT - Assembly/Subassembly\",\"(Proposed) RECEIVING/IN-PROCESS/FINAL INSPECTION REPORT - Detail/Subassembly\")","v":"RECEIVING/IN-PROCESS/FINAL INSPECTION REPORT - Assembly/Subassembly"},null,null,null,null,null,null,null,null,null,null,{"$f":"Company","v":"Industrial Welding & Engineering"},null,null,null,null,"Part Number:",{"$f":"PN","v":0},null,"Revision:",{"$f":"REV","v":0},"Inspection Date:",null,{"$f":"InspectDate","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Contract/PO:",{"$f":"Contract","v":0},null,"Part Name:",null,{"$f":"Name","v":0},null,null,"Customer:",{"$f":"Customer","v":0}]
[null,"CONTRACT",null,{"$f":"IF(Contract>1,Contract,\" \")","v":" "},"N.S.N",{"$f":"IF(NSN>1,NSN,\" \")","v":" "},null,null,"PAGE/PAGES"]
[null,"P/N",{"$f":"IF(PN>1,PN,\" \")","v":" "},null,"NAME",{"$f":"IF(Name>1,Name,\" \")","v":" "},null,null,"WORK ORDER",{"$f":"IF(WO>1,WO,\" \")","v":" "}]
[null,"REV",{"$f":"IF(REV>1,REV,\" \")","v":" "},"INSPECTOR",{"$f":"IF(Inspector>1,Inspector,\" \")","v":" "},null,{"$f":"IF(TDPFAT<>\"TDP Package\",\" \",\"(Suggested) Inspection Plan may vary with contract issue.\")","v":" "},null,"LOT QTY",{"$f":"IF(QTY>1,QTY,\" \")","v":" "},null,null,null,null,null,"Dwg Spec/Dim","Tolerance","Inspection Method","INSPECTION DATA RECORD"]
[]
[null,"NUMBER","PRINT DIM",null,"TOLERANCE","ACTUAL (Min-Max) DIM RANGE",null,"AQL","SAMPLE SIZE","ACCEPT QTY",null,"<<--NOTE: Once you enter the first dimension, the tab will be re-name to the assy part number.",null,null,null,null,null,null,5,6,7,8,9,10,11,12,13,14,15]
[null,null,null,null,null,null,null,"(If Specified)"]
[null,1,null,null,null,null,null,null,{"$f":"IF(C9<=0,\" \",IF(AQLSize=\"A\",QTY,AQLSize))","v":" "},null,null,null,null,null,null,{"$f":"IF(C9>0,C9,\" \")","v":" "},{"$f":"IF(E9>0,E9,\" \")","v":" "}]
[null,{"$f":"IF(C10>0.001,B9+1,\" \")","v":" "},null,null,null,null,null,null," ",null,null,null,null,null,null,{"$f":"IF(C10>0,C10,\" \")","v":" "},{"$f":"IF(E10>0,E10,\" \")","v":" "}]
[null,{"$f":"IF(C11>0.001,B10+1,\" \")","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,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,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,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,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,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," ",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,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,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,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,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,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," "," "]
[null," ",null,null,null,null,null,null," ",null,null,null,null,null,null," "," "]
[]
[null,{"$f":"IF(TDPFAT<>\"TDP Package\",\"PROCESSING REVIEW SUMMARY\",\"(Proposed) PROCESSING REVIEW SUMMARY\")","v":"PROCESSING REVIEW SUMMARY"}]
[null,"Process Specs and Stds",null,"Process Spec & Description",null,null,"Accept",null,"Comments"]
[null,null,null,null,null,null,"Yes","No"]
[null,"Material(s)"]

{"sheet":"QA 015b - Det-Sub Assy","index":14,"n_rows":44,"n_cols":29,"rows_kept":44,"cut":false,"hidden":false,"merged":[[0,4,0,9],[2,1,2,2],[2,5,2,7],[3,2,3,3],[3,5,3,7],[7,2,7,5],[9,1,10,1],[9,2,10,3],[9,4,10,4],[9,5,10,6],[7,6,8,7],[5,1,6,1],[5,3,5,7],[6,3,6,9],[21,2,21,3],[9,9,10,9],[11,2,11,3],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[9,8,10,8],[16,2,16,3],[17,2,17,3],[18,2,18,3],[19,2,19,3],[20,2,20,3],[33,2,33,3],[22,2,22,3],[23,2,23,3],[24,2,24,3],[25,2,25,3],[26,2,26,3],[27,2,27,3],[28,2,28,3],[29,2,29,3],[30,2,30,3],[31,2,31,3],[32,2,32,3],[45,8,45,9],[43,1,43,2],[43,3,43,5],[43,8,43,9],[34,2,34,3],[35,2,35,3],[36,2,36,3],[37,2,37,3],[38,2,38,3],[40,1,40,9],[41,1,42,2],[41,3,42,5],[41,6,41,7],[41,8,41,9],[42,8,42,9],[11,11,18,13],[51,1,51,2],[51,3,51,5],[51,8,51,9],[50,1,50,2],[50,3,50,5],[50,8,50,9],[48,1,48,2],[48,3,48,5],[48,8,48,9],[49,1,49,2],[49,3,49,5],[49,8,49,9],[46,1,46,2],[46,3,46,5],[46,8,46,9],[47,1,47,2],[47,3,47,5],[47,8,47,9],[44,1,44,2],[44,3,44,5],[44,8,44,9],[45,1,45,2],[45,3,45,5],[7,15,10,15],[7,16,10,16],[7,17,10,17],[7,18,8,28],[9,18,10,18],[9,19,10,19],[9,20,10,20],[9,21,10,21],[9,22,10,22],[9,23,10,23],[9,24,10,24],[9,25,10,25],[9,26,10,26],[9,27,10,27],[9,28,10,28],[6,19,6,21],[6,22,6,26],[1,26,2,28],[0,19,0,20],[3,18,3,28],[4,16,5,16],[4,17,5,18],[4,19,5,19],[4,20,5,20],[4,21,5,21],[4,22,5,28],[0,15,2,16],[1,18,2,19],[0,21,0,22],[0,25,0,26],[0,27,0,28],[1,17,2,17],[1,20,2,21],[1,22,2,24],[1,25,2,25]]}
[null,{"$f":"Company","v":"Industrial Welding & Engineering"},null,null,{"$f":"IF(TDPFAT<>\"TDP Package\",\"RECEIVING/IN-PROCESS/FINAL INSPECTION REPORT - Detail/Subassembly\",\"(Proposed) RECEIVING/IN-PROCESS INSPECTION/FINAL REPORT - Detail/Subassembly\")","v":"RECEIVING/IN-PROCESS/FINAL INSPECTION REPORT - Detail/Subassembly"},null,null,null,null,null,null,null,null,null,null,{"$f":"Company","v":"Industrial Welding & Engineering"},null,null,null,"Assembly/Sub Part Number:",null,{"$f":"PN","v":0},null,"Revision:",{"$f":"REV","v":0},"Inspection Date:",null,{"$f":"InspectDate","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Contract/PO:",{"$f":"Contract","v":0},null,"Part Name:",null,{"$f":"Name","v":0},null,null,"Customer:",{"$f":"Customer","v":0}]
[null,"CONTRACT",null,{"$f":"IF(Contract>1,Contract,\" \")","v":" "},"N.S.N",{"$f":"IF(NSN>1,NSN,\" \")","v":" "},null,null,"PAGE/PAGES"]
[null,"P/N",{"$f":"IF(PN>1,PN,\" \")","v":" "},null,"NAME",{"$f":"IF(Name>1,Name,\" \")","v":" "},null,null,"WORK ORDER",{"$f":"IF(WO>1,WO,\" \")","v":" "},null,null,null,null,null,null,null,null,"DETAIL / SUB-ASSY:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P/N:",{"$f":"D6","v":0},null,"REV:",{"$f":"J6","v":0},"NAME:",{"$f":"D7","v":0}]
[null,"DETAIL / SUB-ASSY","P/N",null,null,null,null,null,"REV"]
[null,null,"NAME",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INSPECTOR",{"$f":"IF(Inspector>1,Inspector,\"\")","v":""},null,null,{"$f":"IF(TDPFAT<>\"TDP Package\",\" \",\"This suggested Inspection Plan may vary with contract issue.\")","v":" "},null,null,null,null,"LOT QTY",{"$f":"J8","v":" "}]
[null,"INSPECTOR",{"$f":"IF(Inspector>1,Inspector,\"\")","v":""},null,null,null,{"$f":"IF(TDPFAT<>\"TDP Package\",\" \",\"This suggested Inspection Plan may vary with contract issue.\")","v":" "},null,"LOT QTY",{"$f":"IF(QTY>1,QTY,\" \")","v":" "},null,null,null,null,null,"Dwg Spec/Dim","Tolerance","Inspection Method","INSPECTION DATA RECORD"]
[]
[null,"NUMBER","PRINT DIM",null,"TOLERANCE","ACTUAL DIM RANGE",null,"AQL","SAMPLE SIZE","ACCEPT QTY",null,null,null,null,null,null,null,null,5,6,7,8,9,10,11,12,13,14,15]
[null,null,null,null,null,null,null,"(If Specified)"]
[null,1,null,null,null,null,null,null,{"$f":"IF(C12<=0,\" \",IF(AQLSize=\"A\",QTY,AQLSize))","v":" "},null,null,"<<--CAUTION: Once you enter the part number on this sheet, the tab will be renamed and you CAN NOT use the \"Copy Sub\" button. If you need additional Sub Sheets, use the Sub- button and create all the sheets you need first.",null,null,null,{"$f":"IF(C12>0,C12,\" \")","v":" "},{"$f":"IF(E12>0,E12,\" \")","v":" "}]
[null,{"$f":"IF(C13>0.001,B12+1,\" \")","v":" "},null,null,null,null,null,null," ",null,null,null,null,null,null,{"$f":"IF(C13>0,C13,\" \")","v":" "},{"$f":"IF(E13>0,E13,\" \")","v":" "}]
[null,{"$f":"IF(C14>0.001,B13+1,\" \")","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,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,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,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,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,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," ",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,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,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,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,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,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," "," "]
[null," ",null,null,null,null,null,null," ",null,null,null,null,null,null," "," "]
[]
[null,{"$f":"IF(TDPFAT<>\"TDP Package\",\"PROCESSING REVIEW SUMMARY\",\"(Proposed) PROCESSING REVIEW SUMMARY\")","v":"PROCESSING REVIEW SUMMARY"}]
[null,"Process Specs and Stds",null,"Process Spec & Description",null,null,"Accept",null,"Comments"]
[null,null,null,null,null,null,"Yes","No"]
[null,"Material(s)",null,""]

{"sheet":"QAP 111 AQL","index":15,"n_rows":54,"n_cols":50,"rows_kept":54,"cut":false,"hidden":false,"merged":[[37,7,37,9],[38,7,38,9],[44,7,44,9],[46,7,46,9],[45,7,45,9],[39,7,39,9],[40,7,40,9],[53,7,53,9],[52,7,52,9],[51,7,51,9],[50,7,50,9],[49,7,49,9],[48,7,48,9],[47,7,47,9],[41,7,41,9],[42,7,42,9],[43,7,43,9],[36,1,36,3],[25,16,26,16],[25,17,26,17],[27,1,28,1],[27,2,28,6],[25,13,27,14],[25,1,25,6],[33,2,33,6],[36,5,36,10],[21,16,22,16],[21,17,22,17],[23,13,24,13],[23,14,24,14],[23,16,24,16],[23,17,24,17],[19,16,20,16],[17,13,18,14],[17,16,18,17],[12,13,13,13],[14,13,15,13],[23,2,23,6],[30,2,31,6],[30,1,31,1],[3,13,4,14],[5,13,6,14],[19,13,20,13],[21,3,21,5],[21,13,22,13],[21,14,22,14],[1,1,1,6],[3,2,3,5],[1,13,2,16],[10,13,11,16],[8,13,8,16],[3,16,4,16],[5,16,6,16],[5,10,7,10]]}
[]
[null,"ZERO BASED ACEPTANCE PLAN",null,null,null,null,null,null,null,null,null,null,"sss","C=0 Sampling Size Calculator",null,null,null,null,null,null,"Sample Size","AQL Level",null,null,"0.010","0.015","0.025","0.040","0.065","0.10","0.15","0.25","0.40","0.65","1.0","1.5","2.5","4.0","6.5","10","15","25","40","65","100","150","250","400","600","1000"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2 to 8","0.010",null,"A",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,2,3,5,7,10,14,21,30]
[null,null,"C=0 TABLE",null,null,null,null,null,null,null,null,null,null,"Quantity",null,null,"91-150",null,null,null,"9 to 15","0.015",null,"B",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,2,3,5,7,10,14,21,30,44]
[null,null,"LOT SIZE","CRITICAL*(.010%)","MAJOR (1.0%)","MINOR (4.0%)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"16 to 25","0.025",null,"C",0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,2,3,5,7,10,14,21,30,44,44]
[null,null,null,null,null,null,null,null,null,null,"DCMA Sampling Chart",null,null,"Insp. Level",null,null,"MAJOR (1.0%)",null,null,null,"26 to 50","0.040",null,"D",0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,2,3,5,7,10,14,21,30,44,44,44]
[null,null,"1-8","A","A",3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"51 to 90","0.065",null,"E",0,0,0,0,0,0,0,0,0,0,0,0,1,1,2,3,5,7,10,14,21,30,44,44,44,44]
[null,null,"9-15","A",13,3,null,null,null,null,null,null,null,"C=0 Sample Size:",{"$f":"OFFSET(AQLTable,MATCH(Q4:Q5,OFFSET(AQLTable,0,0,ROWS(AQLTable),1),0)-1,MATCH(Q6:Q7,OFFSET(AQLTable,0,0,1,COLUMNS(AQLTable)))-1)","v":13},null,null,null,null,null,"91 to 150","0.10",null,"F",0,0,0,0,0,0,0,0,0,0,0,1,1,2,3,5,7,10,14,21,21,30,44,44,44,44]
[null,null,"16-25","A",13,3,null,null,null,null,null,null,null,{"$f":"IF(O8=\"A\",C24,IF(O8=\"1250*\",D22,\"\"))","v":""},null,null,null,null,null,null,"151 to 280","0.15",null,"G",0,0,0,0,0,0,0,0,0,0,1,1,2,3,5,7,10,14,21,21,21,30,44,44,44,44]
[null,null,"26-50","A",13,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"281 to 500","0.25",null,"H",0,0,0,0,0,0,0,0,0,1,1,2,3,5,7,10,14,21,21,21,21,30,44,44,44,44]
[null,null,"51-90","A",13,6,null,null,null,null,null,null,null,"AQL Based Sample",null,null,null,null,null,null,"501 to 1,200","0.40",null,"J",0,0,0,0,0,0,0,0,1,1,2,3,5,7,10,14,21,21,21,21,21,30,44,44,44,44]
[null,null,"91-150","A",13,7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1,201 to 3,200","0.65",null,"K",0,0,0,0,0,0,0,1,1,2,3,5,7,10,14,21,21,21,21,21,21,30,44,44,44,44]
[null,null,"151-280","A",20,10,null,null,null,null,null,null,null,"Quantity",null,null,null,null,null,null,"3,201 to 10,000","1.0",null,"L",0,0,0,0,0,0,1,1,2,3,5,7,10,14,21,21,21,21,21,21,21,30,44,44,44,44]
[null,null,"281-500","A",29,11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10,001 to 35,000","1.5",null,"M",0,0,0,0,0,1,1,2,3,5,7,10,14,21,21,21,21,21,21,21,21,30,44,44,44,44]
[null,null,"501-1200","A",34,15,null,null,null,null,null,null,null,"Insp. Level",null,null,null,null,null,null,"35,001 to 150,000","2.5",null,"N",0,0,0,0,1,1,2,3,5,7,10,14,21,21,21,21,21,21,21,21,21,30,44,44,44,44]
[null,null,"1201-3200","1250*",42,18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"150,001 to 500,000","4.0",null,"P",0,0,0,1,1,2,3,5,7,10,14,21,21,21,21,21,21,21,21,21,21,30,44,44,44,44]
[null,null,"3201-10,000","1250*",50,22,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"500,001 and Over","6.5",null,"Q",0,0,1,1,2,3,5,7,10,14,21,21,21,21,21,21,21,21,21,21,21,30,44,44,44,44]
[null,null,"10,001-35,000","1250*",60,29,null,null,null,null,null,null,null,"MAJOR Defects",null,null,"MINOR Defects",null,null,null,null,"10",null,"R",0,0,1,2,3,5,7,10,14,21,21,21,21,21,21,21,21,21,21,21,21,30,44,44,44,44]
[null,null,"35,001-150,000","1250*",74,29,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"15"]
[null,null,"150,001-500,000","1250*",90,29,null,null,null,null,null,null,null,"AQL",null,null,"AQL",null,null,null,null,"25",null,"A",1250,800,500,315,200,125,80,50,32,20,13,8,5,3,2,5,3,2,2,2,2,2,2,2,2,2]
[null,null,"500,001 & OVER","1250*",102,29,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"40",null,"B",1250,800,500,315,200,125,80,50,32,20,13,8,5,3,2,5,3,3,3,3,3,3,3,3,3,3]
[null,null,null,"*Use standard SPC methodology.",null,null,null,null,null,null,null,null,null,"Sampling Size",{"$f":"IF(R6=\"\",INDEX('QAP 111 AQL'!Y20:AX35,'QAP 111 AQL'!AK46,'QAP 111 AQL'!AJ46),R6)","v":3},null,"Sampling Size",{"$f":"IF(R6=\"\",INDEX('QAP 111 AQL'!Y20:AX35,'QAP 111 AQL'!AK45,'QAP 111 AQL'!AJ45),R6)","v":13},null,null,null,"65",null,"C",1250,800,500,315,200,125,80,50,32,20,13,8,5,3,8,5,5,5,5,5,5,5,5,5,5,3]
[null,null,"NOTES:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"100",null,"D",1250,800,500,315,200,125,80,50,32,20,13,8,5,13,8,8,8,8,8,8,8,8,8,8,5,3]
[null,null,"\"A\" INDICATES ENTIRE LOT MUST BE INSPECTED",null,null,null,null,null,null,null,null,null,null,"Max. Rejectable",{"$f":"IF(Q6=\"\",INDEX('QAP 111 AQL'!Y3:AX18,'QAP 111 AQL'!AK46,'QAP 111 AQL'!AJ46),\"N/A\")","v":"N/A"},null,"Max. Rejectable",{"$f":"IF(Q6=\"\",INDEX('QAP 111 AQL'!Y3:AX18,'QAP 111 AQL'!AK45,'QAP 111 AQL'!AJ45),\"N/A\")","v":"N/A"},null,null,null,"150",null,"E",1250,800,500,315,200,125,80,50,32,20,13,8,20,13,13,13,13,13,13,13,13,13,13,8,5,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"250",null,"F",1250,800,500,315,200,125,80,50,32,20,13,32,20,20,20,20,20,20,20,20,13,13,13,8,5,3]
[null,"GENERAL DEFINITIONS",null,null,null,null,null,null,null,null,null,null,null,"Critical Defect:",null,null,"Sampling Size",{"$f":"IF(O22>R22,O22,R22)","v":13},null,null,null,"400",null,"G",1250,800,500,315,200,125,80,50,32,20,50,32,32,32,32,32,32,32,32,20,13,13,13,8,5,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"600",null,"H",1250,800,500,315,200,125,80,50,32,80,50,50,50,50,50,50,50,50,32,20,13,13,13,8,5,3]
[null,"CRITICAL","A DEFECT THAT IS LIKELY TO CAUSE A HAZADOUS OR UNSAFE CONDITION DIAMETRICAL AND LINEAR DIMENSIONS HAVING A TOTAL TOLERANCE OF .0001 INCH SURFACE FINISHS HAVING A 16 RMS VALUE OR LESS GEOMETRIC TOLERANCES HAVING A TOLERANCE OF .0002 IN OR LESS NONDESTRUCTIVE TESTS.",null,null,null,null,null,null,null,null,null,null,null,null,null,"Max. Rejectable",0,null,null,null,"1000",null,"J",1250,800,500,315,200,125,80,50,125,80,80,80,80,80,80,80,80,50,32,20,13,13,13,8,5,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"K",1250,800,500,315,200,125,80,200,125,125,125,125,125,125,125,125,80,50,32,20,13,13,13,8,5,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L",1250,800,500,315,200,125,315,200,200,200,200,200,200,200,200,125,80,50,32,20,13,13,13,8,5,3]
[null,"MAJOR","A DEFECT OTHER THAN CRITICAL THAT WILL CAUSE FAILURE DIAMETRICAL AND LINEAR DIMENSIONS HAVING A TOLERANCE BETWEEN .001-.005 IN SURFACE FINISH HAVING AN RMS BETWEEN 16 AND 63 GEOEMTRIC TOLERANCE BETWEEN .002-.008 IN.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M",1250,800,500,315,200,500,315,315,315,315,315,315,315,315,200,125,80,50,32,20,13,13,13,8,5,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N",1250,800,500,315,800,500,500,500,500,500,500,500,500,315,200,125,80,50,32,20,13,13,13,8,5,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P",1250,800,500,1250,800,800,800,800,800,800,800,800,500,315,200,125,80,50,32,20,13,13,13,8,5,3]
[null,"MINOR","A DEFECT THAT IS UNLIKELY TO THE USABILITY OF THE PRODUCT DIAMETRICAL AND LINEAR DIMENSIONS GREATER THAN .005 IN SURFACE RMS IN EXCESS OF 63.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q",1250,800,2000,1250,1250,1250,1250,1250,1250,1250,1250,800,500,315,200,125,80,50,32,20,13,13,13,8,5,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R",1250,800,2000,2000,2000,2000,2000,2000,2000,2000,1250,800,500,315,200,125,80,50,32,20,13,13,13,8,5,3]
[]
[null,"General Inspection Levels",null,null,null,"Special Inspection Levels",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Level S-1","Level S-2","Level S-3","Level S-4","Level I","Level II","Level III",null,null,"Level S-1"]
[null,"I","II","III",null,"S-1","S-2","S-3",null,null,"S-4",null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,1,1,1,1,2,null,null,"Level S-2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,1,1,1,1,1,2,3,null,null,"Level S-3"]
[null,"A","A","B",null,"A","A","A",null,null,"A",null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,2,2,2,3,4,null,null,"Level S-4"]
[null,"A","B","C",null,"A","A","A",null,null,"A",null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,2,3,3,4,5,null,null,"Level I"]
[null,"B","C","D",null,"A","A","B",null,null,"B",null,null,null,null,null,null,null,null,null,null,null,null,null,2,2,3,3,3,5,6,null,null,"Level II"]
[null,"C","D","E",null,"A","B","B",null,null,"C",null,null,null,null,null,null,null,null,null,null,null,null,null,2,2,3,4,4,6,7,null,null,"Level III"]
[null,"C","E","F",null,"B","B","C",null,null,"C",null,null,null,null,null,null,null,null,null,null,null,null,null,2,3,4,5,5,7,8]
[null,"D","F","G",null,"B","B","C",null,null,"D",null,null,null,null,null,null,null,null,null,null,null,null,null,2,3,4,5,6,8,9,"minor",null,{"$f":"INDEX(Y3:AX18,AK45,AJ45)","v":0},{"$f":"INDEX($Y$20:$AX$35,AK45,AJ45)","v":13},11,{"$f":"INDEX($Y$38:$AE$52,X38,X39)","v":1}]
[null,"E","G","H",null,"B","C","D",null,null,"E",null,null,null,null,null,null,null,null,null,null,null,null,null,3,3,5,6,7,9,10,"major",null,{"$f":"INDEX(Y3:AX18,AK46,AJ46)","v":0},{"$f":"INDEX(Y20:AX35,AK46,AJ46)","v":3},14,{"$f":"INDEX($Y$38:$AE$52,X38,X39)","v":1}]
[null,"F","H","J",null,"B","C","D",null,null,"E",null,null,null,null,null,null,null,null,null,null,null,null,null,3,4,5,7,8,10,11]
[null,"G","J","K",null,"C","C","E",null,null,"F",null,null,null,null,null,null,null,null,null,null,null,null,null,3,4,6,7,9,11,12]
[null,"H","K","L",null,"C","D","E",null,null,"G",null,null,null,null,null,null,null,null,null,null,null,null,null,3,4,6,8,10,12,13]
[null,"J","L","M",null,"C","D","F",null,null,"G",null,null,null,null,null,null,null,null,null,null,null,null,null,4,5,7,9,11,13,14]
[null,"K","M","N",null,"C","D","F",null,null,"H",null,null,null,null,null,null,null,null,null,null,null,null,null,4,5,7,9,12,14,15]
[null,"L","N","P",null,"D","E","G",null,null,"J",null,null,null,null,null,null,null,null,null,null,null,null,null,4,5,8,10,13,15,16]
[null,"M","P","Q",null,"D","E","G",null,null,"J"]
[null,"N","Q","R",null,"D","E","H",null,null,"K"]

{"sheet":"Packaging Instructions","index":16,"n_rows":28,"n_cols":14,"rows_kept":28,"cut":false,"hidden":false,"merged":[[27,1,27,3],[27,4,27,9],[24,1,24,2],[24,4,24,9],[25,1,25,2],[25,4,25,9],[26,1,26,2],[26,4,26,9],[21,1,21,2],[21,4,21,9],[22,1,22,2],[22,4,22,9],[23,1,23,2],[23,4,23,9],[18,1,18,2],[18,4,18,9],[19,1,19,2],[19,4,19,9],[20,1,20,2],[20,4,20,9],[15,1,15,2],[15,4,15,9],[16,1,16,2],[16,4,16,9],[17,1,17,2],[17,4,17,9],[14,1,14,2],[14,4,14,9],[4,4,4,5],[5,1,5,2],[5,4,5,5],[6,1,6,2],[6,4,6,5],[7,1,7,2],[7,4,7,5],[8,1,8,9],[9,1,9,9],[12,1,12,9],[13,1,13,2],[13,4,13,9],[0,1,0,9],[1,1,1,2],[1,4,1,5],[1,8,1,9],[2,1,2,2],[2,4,2,5],[2,8,7,9],[3,1,3,2],[3,4,3,5],[4,1,4,2]]}
[null,{"$f":"IF(TDPFAT<>\"TDP Package\",\"Packaging\",\"(Proposed) Packaging Procedure\")","v":"Packaging"},null,null,null,null,null,null,null,null,null,null,null,"OPI"]
[null,"QUP:",null,"1","Pre Mthd:",null,{"$f":"[0]!MCode","v":0},"Packaging Data","Comments"]
[null,"Clng/Dry:",null,"","Presv Mat:",null,"",null,{"$f":"IF(G2=\"ASTM D3951\",\"This shipment requires commercial standard packaging for foreign military sale (FMS) and fully sealed on all opening sides. RFID Label may not be required. Attached (2) copies of DD250 to Packing List.\" &\"  (See contract Section D for 252.211-7006 RFID required.)\",\"\")","v":""},null,null,null,null,"A"]
[null,"Wrap Mat:",null,"","Cush/Dunn Mat:",null,"",null,null,null,null,null,null,"E"]
[null,"Cush/Dunn Thkness:",null,"","Unit Cont:",null,"",null,null,null,null,null,null,"F"]
[null,"OPI:",null,"","Intrmdte Cont:",null,"",null,null,null,null,null,null,"M"]
[null,"Intrmdte Cont Qty:",null,"","Packing Code:",null,"",null,null,null,null,null,null,"O"]
[null,"Packing Level:",null,"","Special Markings Code:",null,"",null,null,null,null,null,null,"P"]
[null,"Supplemental Packaging and Marking Requirements",null,null,null,null,null,null,null,null,null,null,null,"R"]
[null,""]
[]
[]
[null,"MIL-STD-2073-1D Packaging Requirements"]
[null,"Quantity Per Unit Pack:",null,"","",null,null,null,null,null,null,{"$f":"E14","v":""}]
[null,"Method of Preservation:",null,"","",null,null,null,null,null,null,{"$f":"E15","v":""}]
[null,"Cleaning and Drying:",null,"","",null,null,null,null,null,null,""]
[null,"Preservation Material:",null,"","",null,null,null,null,null,null,""]
[null,"Wrapping Material:",null,"","",null,null,null,null,null,null,""]
[null,"Cushioning Material:",null,"","",null,null,null,null,null,null,""]
[null,"Cushioning Thickness:",null,"","",null,null,null,null,null,null,""]
[null,"Unit Container:",null,"","",null,null,null,null,null,null,""]
[null,"OPI:",null,"","",null,null,null,null,null,null,""]
[null,"Intermediate Container:",null,"","",null,null,null,null,null,null,""]
[null,"Intermediate Cont. Qty.:",null,"","",null,null,null,null,null,null,""]
[null,"Packing Code:",null,"","",null,null,null,null,null,null,""]
[null,"Unit Container Level:",null,"","",null,null,null,null,null,null,""]
[null,"Special Markings:",null,"","",null,null,null,null,null,null,""]
[null,"Supplemental Packaging and Marking Requirements:",null,null,"",null,null,null,null,null,null,null,{"$f":"B28","v":"Supplemental Packaging and Marking Requirements:"}]

{"sheet":"RFP Mailing Template","index":17,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":true,"merged":[[3,2,3,3],[4,2,4,3],[1,0,1,1],[2,0,2,1],[0,0,0,2]]}
[{"$f":"Company&\" (\"&Cage&\")\"","v":"Industrial Welding & Engineering (3NBK9)"}]
[{"$f":"Street","v":"747 Carle Ave."}]
[{"$f":"State","v":"Lewis Center, OH 43035"}]
["POC:",{"$f":"Inspector","v":0},"SOLICITATION NUMBER:"]
[null,{"$f":"Email","v":"iwe@columbus.rr.com"},"SPM4A5-11-R-1510"]
[null,null,"DATE (YYMMDD)","LOCAL TIME"]
[null,null,"2011-07-18","14:00:00"]
[null,null,null,null,"To:","ATTN:"]
[null,null,null,null,null,null,"DLA - Aviation Supply Chain"]
[null,null,null,null,null,null,{"$f":"VLOOKUP(DLAGroup, DLATable, 2, FALSE)","v":"Aviation Supply Chain"}]
[null,null,null,null,null,null,{"$f":"VLOOKUP(DLAGroup, DLATable, 3, FALSE)","v":"8000 Jefferson Davis Hwy"}]
[null,null,null,null,null,null,{"$f":"VLOOKUP(DLAGroup, DLATable, 4, FALSE)","v":"Richmond, VA 23297-5770"}]

{"sheet":"831 Test Report - Cover Page","index":18,"n_rows":32,"n_cols":14,"rows_kept":32,"cut":false,"hidden":true,"merged":[[24,0,24,1],[26,0,26,1],[26,6,26,7],[27,2,27,3],[26,2,26,3],[26,4,26,5],[27,6,27,7],[20,2,20,5],[19,2,19,5],[13,3,13,7],[14,3,14,7],[28,4,28,5],[27,4,27,5],[0,5,0,8],[22,1,22,2],[22,3,22,5],[25,0,25,1],[12,0,15,0],[12,3,12,7],[25,2,25,3],[25,4,25,5],[21,2,21,5],[18,2,18,5],[25,6,25,7],[15,3,15,7],[7,0,7,3],[6,0,6,3],[9,5,9,7],[9,1,9,3],[28,0,28,1],[28,2,28,3],[27,0,27,1],[31,6,31,7],[29,6,29,7],[30,0,30,1],[30,6,30,7],[29,0,29,1],[29,2,29,3],[29,4,29,5],[30,2,30,3],[30,4,30,5],[31,0,31,1],[31,2,31,3],[31,4,31,5],[28,6,28,7],[1,0,1,4],[1,5,1,8],[19,11,19,12],[2,5,3,8],[4,5,7,7],[1,10,2,10],[3,0,3,2],[4,0,4,2],[5,0,5,2],[2,0,2,2]]}
[{"$f":"VLOOKUP(Company, PicTable9, 2, FALSE)","v":"Picture2"},null,null,null,null,{"$f":"IF(TDPFAT=\"TDP Package\",\"(SAR)/Tech Data Package\",IF(TDPFAT=\"FAT Package\",\"FAT Package\",\"\"))","v":""},null,null,null,null,null,"COMPANY","PHOTO"]
[{"$f":"Company","v":"Industrial Welding & Engineering"},null,null,null,null,null,null,null,null,null,{"$f":"IF(F1=\"(SAR)/Tech Data Package\",\"<--Select a SAR Category.\",\"\")","v":""},"MTC Engineering","Pic41"]
[{"$f":"Street","v":"747 Carle Ave."},null,null,null,null,{"$f":"IF(Category<1,\"\",VLOOKUP(Category, CategoryTable, 2, FALSE))","v":""},null,null,null,null,null,"Industrial Welding & Engineering","Picture2"]
[{"$f":"State","v":"Lewis Center, OH 43035"},null,null,null,null,null,null,null,null,null,null,"MTC Engineering, LLC","Pic41"]
[{"$f":"Phone","v":"614-883-6109"},null,null,null,null,{"$f":"IF(Category<1,\"\",VLOOKUP(Category, CategoryTable, 3, FALSE))","v":""},null,null,null,null,null,"LCG Machine & Tool","Pic43"]
[{"$f":"Fax","v":"email only"},null,null,null,null,null,null,null,null,null,null,"Alannas Engineer","Picture4"]
[{"$f":"Email","v":"iwe@columbus.rr.com"},null,null,null,null,null,null,null,null,null,null,"Westerville Mfg","Pic45"]
[{"$f":"Web","v":"www.iweohio.com"},null,null,null,null,null,null,null,null,null,null,"Boehm Machine","Boehm"]
[null,null,null,null,null,null,null,null,null,null,null,"RC Industries, Inc.","Picture 3"]
["DLA Assigned Report No.:",null,null,null,{"$f":"IF(TDPFAT<>\"TDP Package\",\"Report No.:\",\"TDP Ref No.:\")","v":"Report No.:"},{"$f":"REPLACE(Contract,1,12,)&\"-\"&WO","v":"-"},null,null,null,null,null,"DSE Development","Picture 22"]
[null,null,null,null,null,"Revision No.:",null,"N/C",null,null,null,"DuLond Tool & Engineering, Inc.","Picture 1"]
[null,null,null,null,null,null,null,null,null,null,null,"Fourply Design House","Picture 6"]
[{"$f":"IF(TDPFAT<>\"TDP Package\",\"REPORT OF TEST ON\",\"(Proposed) 831 TEST REPORT ON\")","v":"REPORT OF TEST ON"},null,"Description:",{"$f":"Name","v":0},null,null,null,null,null,null,null,"Lewis Center Mfg.","Picture 11"]
[null,null,"NSN:",{"$f":"NSN","v":0},null,null,null,null,null,null,null,"Maven Engineering Corporation","Picture 9"]
[null,null,"P/N:",{"$f":"PN","v":0},null,null,null,null,null,null,null,"ADJ Finishing","Picture 4"]
[null,null,"Rev:",{"$f":"REV","v":0},null,null,null,null,null,null,null,"GTA Containers Inc.","Picture 12"]
[null,null,null,null,null,null,null,null,null,null,null,"Acromil Corp.","Picture 20"]
[null,null,null,null,null,null,null,null,null,null,null,"C. O. W. Industries, Inc.","Picture6"]
[null,null,{"$f":"IF(TDPFAT<>\"TDP Package\",\"TEST PREFORMED BY:\",\"PROJECT MANAGER FOR TEST:\")","v":"TEST PREFORMED BY:"}]
[null,null,null,null,null,null,null,null,null,null,null,"CATEGORY"]
[null,null,{"$f":"IF(TDPFAT<>\"TDP Package\",\"TEST AUTHORIZED BY:\",\"GOVERNMENT CONTACT:\")","v":"TEST AUTHORIZED BY:"}]
[null,null,{"$f":"PCO","v":0},null,null,null,null,null,null,null,null,"Category I","Same Part","Item previously provided to Original Equipment Manufacturer (OEM). "]
[null,{"$f":"IF(TDPFAT=\"TDP Package\",\"SOLICATION NO.:\",\"CONTRACT NO.:\")","v":"CONTRACT NO.:"},null,{"$f":"Contract","v":0},null,null,null,null,null,null,null,"Category II","Similar Part","Item is similar to item previously provided to the OEM or Department of Defense (DoD)."]
[null,null,null,null,null,null,null,null,null,null,null,"Category III","New Manufacturer","Manufacturer has not provided any item similar to item being solicited to the OEM or DoD. "]
[{"$f":"IF(TDPFAT=\"TDP Package\",\"(Proposed)\",\" \")","v":" "},null,null,null,null,null,null,null,null,null,null,"Category IV"]
[null,null,"Date",null,"Signature",null,"Department",null,null,null,null,"Category V"]
["Test Engineer",null,null,null,null,null,"Engineering",null,null,null,null,"Category VI"]
["Technician",null,null,null,null,null,"Quality"]
["Test Initiated"]
["Test Completed"]
["Report Written By",null,null,null,null,null,"Quality"]
["Government Rep. (If Applicable)",null,null,null,null,null,"DCMA-QAR"]

{"sheet":"831 - Table of Content","index":19,"n_rows":43,"n_cols":2,"rows_kept":43,"cut":false,"hidden":true,"merged":[[16,0,16,1],[0,0,0,1],[40,1,41,1]]}
["TABLE OF CONTENTS"]
[]
["SECTION ","TITLE"]
[]
["1.0","REASON FOR TEST"]
[1.1000000000000001,"DESCRIPTION OF TEST SAMPLE"]
["1.2","DISPOSITION OF TEST SAMPLE"]
["1.3","DESCRIPTION OF TEST APPARATUS"]
["1.4","SUMMARY RESULTS"]
["2","COC"]
["3","INSPECTION PRINTS WITH INSPECTION DATA REPORTS"]
["4","MATERIAL CERT "]
[5,"PROCESSING CERTS"]
[6,"DD250"]
[7,"DD1122"]
[]
["STATEMENT OF WORK"]
[]
["SECTION","REASON FOR WORK"]
["1.0",{"$f":"IF(TDPFAT=\"FAT Package\",\"CONTRACT CALLS OUT FOR FAT REPORT FOR 1 TE, CONSISTING OF \" &Qty_Packages &\" UNITS.\",\"CONTRACT CALLS OUT FOR 1 SHIPMENT CONSISTING OF \" &Qty_Packages &\" UNITS.\")","v":"CONTRACT CALLS OUT FOR 1 SHIPMENT CONSISTING OF  UNITS."}]
[null,"FOR DIMENSIONAL AND PROCESS REQURIEMENTS PER PRINT"]
[]
[]
[]
[null,"DESCRIPTION OF SAMPLE"]
["1.1",{"$f":"\"ONE REPORT ON 1 TE, \"&\"(\"& Qty_Packages &\")\" &\" SAMPLES TO PRINT AND CONTRACT\"","v":"ONE REPORT ON 1 TE, () SAMPLES TO PRINT AND CONTRACT"}]
[null,{"$f":"PN","v":0}]
[]
[]
[null,"DISPOSITION OF SAMPLE"]
["1.2",{"$f":"IF(Qty_Packages=1,\"1 SAMPLE WILL BE SHIPPED\",Qty_Packages&\" SAMPLES WILL BE SHIPPED\")","v":" SAMPLES WILL BE SHIPPED"}]
[]
[]
[]
[null,"DESCRIPTION OF TEST APPARATUS"]
["1.3","DIMENSIONS WILL BE CHECKED WITH A CALIPER, "]
[null,"HEIGHT GAGE, RADIUS GAGE, & GAGE PINS"]
[]
[]
[null,"SUMMARY OF TEST RESULTS"]
["1.4","ALL DIMENSIONS WERE CHECKED AND WERE WITH IN THE TOLERANCES SPECIFIED BY THE PRINT."]
[]
[null,"ALL MATERIAL AND PROCESS CERTS WERE REVIEWED AND ACCEPTED"]

{"sheet":"831 - Appendix","index":20,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":true,"merged":[[0,0,1,1]]}
["APPENDIX"]
[]
[]
["CERTS FOR",{"$f":"IF(TDPFAT=\"TDP Package\",\"[Proposed] CERTIFIED BY (Company)\",\"CERTIFIED BY (Company)\")","v":"CERTIFIED BY (Company)"}]
["Material(s)"]

{"sheet":"831 Test Report Tech Data Cert","index":21,"n_rows":62,"n_cols":3,"rows_kept":62,"cut":false,"hidden":true,"merged":[]}
["CERTIFICATION"]
[]
[{"$f":"\"I hereby represent and certify that thetechnical data that \"&Company&\"intends to use or has used to manufacture \"&Company&\", \"&PN&\" (\"&Name&\") under and resulting DoD Contract, was obtained or\"","v":"I hereby represent and certify that thetechnical data that Industrial Welding & Engineeringintends to use or has used to manufacture Industrial Welding & Engineering,  () under and resulting DoD Contract, was obtained or"}]
[{"$f":"\"developed in a legal mannar and that \"&Company&\" has the right to use the the data to manufacture \"&PN&\" (\"&Name&\") for the U. S. Government. All appicable specifications required to manufacture this item are in the possession of \"&Company&\".\"","v":"developed in a legal mannar and that Industrial Welding & Engineering has the right to use the the data to manufacture  () for the U. S. Government. All appicable specifications required to manufacture this item are in the possession of Industrial Welding & Engineering."}]
[{"$f":"\"Signature: ______________________________ Date: (______________)\"","v":"Signature: ______________________________ Date: (______________)"}]
[{"$f":"Inspector&\" - Engineer/Project Manager\"","v":" - Engineer/Project Manager"}]
[]
["ACTS of DISCLAIMER"]
[]
["Disclaimer of liability from Act of Transmittal"]
[]
["When Government drawings, specifications, or other data are used for any purpose other than in connection with a definitely related Government procurement operation, the United States Government thereby incurs no responsibility nor any obligation whatsoever; and the fact that the Government may have formulated, furnished, or in any way supplied the said drawings, specifications, or other data, is not to be regarded by implication or otherwise as in any manner licensing the holder or any other person or corporation, or conveying any rights or permission to manufacturer, use or sell any patented invention that may in any way be related thereto."]
["Any information disseminated by the offices of data interchange programs is intended to promote test data utilization in the national interest among groups engaged in missile, space vehicle and related programs."]
["Dissemination of said information does not imply verification or endorsement of the information. The originator, in submitting the material is acting in accordance with the requirements of his contract, and neither the originator nor the disseminator assumes any liability to parties adopting any product, process or practice based upon the usage of the information. Its presenting the success or failure of one (or several) part number(s), model(s), lot(s) under specific environment and output requirements, does not imply that other products not herein reported on are either inferior or superior."]
[]
["Omission of Charges for Follow-on Access"]
[]
["Any compliance by the report originator with requests from recipients for more detailed information on reports originated under Government contracts will be considered within the scope of present contractual obligations. Compliance with such requests will be at the discretion of the report originator and will be performed without cost or obligation to the requestor unless otherwise negotiated in advance."]
[]
["Reproduction of this Report"]
[]
["Reproduction or duplication of any portion of this report is expressly forbidden, except by those contractors receiving it directly from authorized data interchange offices or the originator , for their internal use or the use of their subcontractors. Reproduction or display of all or any portion of this material for any sales, advertising or publicity purposes is prohibited."]
[]
[]
[{"$f":"DwgRvw","v":"00:00:00"}]
[]
["Commander"]
["US Army Aviation and Missile Command"]
["Project Management Office Address"]
["Building XXXX"]
["Redstone Arsenal, Alabama  35898-5000 "]
[]
["To Whom It May Concern:"]
[]
[{"$f":"\"Our company, \"&Company&\", would like to become an approved source per the CASL as an Actual Manufacturer for the following item:\"","v":"Our company, Industrial Welding & Engineering, would like to become an approved source per the CASL as an Actual Manufacturer for the following item:"}]
[]
[{"$f":"\"Part Number: \"&PN","v":"Part Number: "}]
[{"$f":"\"NSN: \"&NSN","v":"NSN: "}]
[{"$f":"\"Nomenclature: \"&Name","v":"Nomenclature: "}]
[]
["We also wish to become approved for the following subassembly parts:"]
["Part Number:  <Insert Part Number>"]
["NSN:  <Insert NSN>"]
["Nomenclature:  <Insert Nomenclature>"]
[]
["Our company information is as follows:"]
[]
[{"$f":"Company&\" (\"&Cage&\")\"","v":"Industrial Welding & Engineering (3NBK9)"}]
[{"$f":"Street","v":"747 Carle Ave."}]
[{"$f":"\"Telephone: \"&Phone","v":"Telephone: 614-883-6109"}]
[{"$f":"\"Fax: \"&Fax","v":"Fax: email only"}]
[]
["Our Quality System is based on the following:"]
["ISO9002 Tailored and has been audited by our local Government QAS and accepted as complient."]
[]
["A current copy of our Quality Manual is available upon request."]
[]
["If you have any questions concerning this submittal, please contact the noted Engineer/Project Manager noted on page 1 of the attached (SAR)/TDP Package."]
[]
["Sincerely,"]
[]
["Tony Casillas",null,"<----Select Mgr Name"]

{"sheet":"QA 001 CAR","index":22,"n_rows":61,"n_cols":6,"rows_kept":61,"cut":false,"hidden":true,"merged":[[26,1,26,5],[0,4,0,5],[1,4,1,5],[7,4,7,5],[9,4,9,5],[8,4,8,5],[0,0,0,3],[19,1,19,5],[6,1,6,3],[23,1,23,5],[20,1,20,5],[21,1,21,5],[22,1,22,5],[24,1,24,5],[25,1,25,5],[40,2,40,3],[29,3,29,4],[28,3,28,4],[39,2,39,3],[37,1,37,5],[36,1,36,5],[33,1,33,5],[34,1,34,5],[35,1,35,5],[32,1,32,5],[60,2,60,3],[43,1,43,4],[44,1,44,4],[42,1,42,4],[45,1,45,4],[55,2,56,5],[55,1,56,1],[49,2,49,3],[50,2,50,3],[46,1,46,4],[47,1,47,4],[51,0,51,5]]}
[{"$f":"Company","v":"Industrial Welding & Engineering"},null,null,null,"CAR"]
[{"$f":"Street","v":"747 Carle Ave."},null,null,null,"Corrective Action Report"]
[{"$f":"State","v":"Lewis Center, OH 43035"},null,"C.A.R. Number:",{"$f":"IF(QDR>1,QDR,\" \")","v":" "},"Issue Date:",{"$f":"IF(QDRDate>1,QDRDate,\" \")","v":" "}]
[{"$f":"Email","v":"iwe@columbus.rr.com"},null,null,null,"Work Order Number:",{"$f":"WO","v":0}]
[{"$f":"\"Phone: \"&Phone","v":"Phone: 614-883-6109"},null,null,null,"Purchase Order Number:",{"$f":"Contract","v":0}]
[{"$f":"\"Fax: \"&Fax","v":"Fax: email only"},null,null,null,"# Attached Pages:"]
[null,"Circle one below:"]
["Initiated by:",null,null,null,"(If multiples, see below)"]
["Issue for:",null,null,"Part Number"]
[null,null,null,"Part/Process Description:"]
[]
["Part Number","Description","Order Qty","Sample Size","Qty Rejected","Qty Accepted"]
[{"$f":"PN","v":0},{"$f":"Name","v":0},{"$f":"QTY","v":0}]
["     ","     ","     ","     ","     ","     "]
["     ","     ","     ","     ","     ","     "]
["     ","     ","     ","     ","     ","     "]
["     ","     ","     ","     ","     ","     "]
[]
["DISCREPANCY:"]
["Item","Discrepancy"]
[1]
[2]
[3]
[4]
[5]
["     ","     "]
["     ","     "]
[]
[]
[null,null,null,"Quality Assurance Representative",null,"Date"]
[]
["ROOT CAUSE:"]
["Item","Root Cause"]
[1]
[2]
[3]
[4]
[5]
[]
[]
[null,null,"Department Representative",null,"Title","Date"]
["CORRECTIVE ACTION TO BE INITIATED:"]
["Item","Corrective Action",null,null,null,"Effectively"]
[1]
[2]
[3]
[4]
[5]
[]
[]
["Comments:",null,"Department Representative",null,"Title","Date"]
[]
["Follow up activity:"]
[null,"1. Audit Review:","Date:"]
[null,"2. Additional Action Required:"]
[null,"(If Yes, Define):"]
[]
[]
[null,"3. Final Effectively Date:",null,null,"QA Approval:"]
[]
[null,"CAR CLOSED: ",null,null,"Date:"]

{"sheet":"QA 002 Audit","index":23,"n_rows":30,"n_cols":4,"rows_kept":30,"cut":false,"hidden":true,"merged":[[24,3,24,4],[3,0,6,0],[17,0,17,4],[18,0,18,4],[21,0,21,4],[22,0,22,4],[23,0,23,4],[20,1,20,4],[0,3,0,4],[1,3,1,4],[9,0,9,4],[10,0,10,4],[16,0,16,4],[11,0,11,4],[15,0,15,4],[12,0,12,4],[13,0,13,4],[14,0,14,4]]}
["Date:",null,"Audit #"]
["Subject:",null,"Auditor:"]
[]
["Contact List","Name","Title","Department"]
[]
[]
[]
[]
["Reference/Items Inspected"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Findings:"]
[]
[]
[]
[null,"Signature","Date","Corrective Action Request Required"]
["Auditor:"]
["Dept. Supervisor:",null,null,"CAR Closed Date"]
["CAR.No.",null,null,"Signatures/Date"]
["Date:",null,null,"MFG . Manager"]
[null,null,null,"GEN. Manager"]

{"sheet":"QA 005 QDR","index":24,"n_rows":47,"n_cols":8,"rows_kept":47,"cut":false,"hidden":true,"merged":[[1,5,3,7],[4,6,4,7],[33,4,33,7],[27,1,27,7],[14,1,14,7],[15,1,15,7],[16,1,16,7],[8,2,8,3],[9,2,9,3],[17,1,17,7],[13,4,13,7],[11,2,11,3],[36,2,36,7],[30,2,30,3],[31,2,31,3],[7,2,7,3],[10,2,10,3],[21,3,21,5],[29,5,29,6],[30,5,30,6],[31,5,31,6],[29,2,29,3],[35,2,35,7],[45,2,45,3],[39,1,39,7],[46,2,46,3],[37,2,37,7],[45,5,45,7],[46,5,46,7],[44,5,44,7],[44,2,44,3],[42,2,42,7],[43,2,43,7],[41,2,41,7]]}
[]
[null,{"$f":"Company","v":"Industrial Welding & Engineering"},null,null,null,"QDR (Quality Discrepancy Report)"]
[null,{"$f":"Street","v":"747 Carle Ave."}]
[null,{"$f":"State","v":"Lewis Center, OH 43035"}]
[null,"Phone:",{"$f":"Phone","v":"614-883-6109"},null,null,"Control #:",{"$f":"IF(QDR>1,QDR,\" \")","v":" "}]
[null,"Fax:",{"$f":"Fax","v":"email only"},null,null,null,null,{"$f":"Email","v":"iwe@columbus.rr.com"}]
[]
[null,"CONTRACT",{"$f":"Contract","v":0},null,null,"QTY. RE'C","QTY. REJ."]
[null,"PART NAME",{"$f":"Name","v":0},null,null,{"$f":"QTY","v":0}]
[null,"P/N",{"$f":"PN","v":0}]
[null,"REV",{"$f":"REV","v":0}]
[null,"NSN",{"$f":"NSN","v":0}]
[]
[null,"DESCRIPTION OF DEFICIENCY"]
[]
[]
[]
[]
[]
[null,"DISPOSITION","REWORK",null,"USE AS IS",null,"SCRAP"]
[]
[null,"AUTHORIZED SIGNATURE",null,null,null,null,"DATE"]
[]
[null,"VENDOR TO SUPPLY IN WRITING  THE CAUSE OF DEFICIENCY AND THE CORRECTIVE ACTION"]
[null,"TO BE TAKEN TO ELIMINATE RECURRENCE IN THE FUTURE  ",null,null,null,null,"YES   "]
[null,null,null,null,null,null,"NO"]
[]
[null,"VENDOR NOTIFICATION"]
[]
[null,"NAME",null,null,"DATE"]
[null,"INVOICE#",null,null,"PACKING SLIP "]
[null,"SHIP METHOD",null,null,"ACCOUNT"]
[]
[null,"FIRM DELIVERY OF CORRECTED MATERIAL"]
[]
[null,"COMMENTS"]
[]
[]
[]
[null,"SHIPPING REQUEST"]
[]
[null,"SHIP TO"]
[]
[]
[null,"ATTN"]
[null,"REQUESTED BY",null,null,"DATE"]
[null,"SHIPPED BY",null,null,"DATE"]

{"sheet":"QA 009 FAI","index":25,"n_rows":37,"n_cols":13,"rows_kept":37,"cut":false,"hidden":true,"merged":[[33,0,33,1],[33,2,33,5],[31,8,31,10],[15,2,15,3],[15,10,15,12],[31,2,31,5],[32,0,32,1],[31,0,31,1],[32,8,32,10],[27,8,28,10],[22,10,22,12],[20,10,20,12],[21,10,21,12],[30,0,30,1],[33,8,33,10],[32,2,32,5],[11,2,11,3],[14,2,14,3],[12,2,12,3],[17,2,17,3],[20,2,20,3],[25,2,25,3],[27,2,28,5],[27,6,27,7],[17,10,17,12],[12,10,12,12],[13,10,13,12],[14,10,14,12],[19,10,19,12],[5,10,5,12],[29,0,29,1],[36,0,36,1],[36,2,36,8],[36,10,36,12],[34,0,34,1],[34,2,34,5],[34,8,34,10],[27,0,28,1],[29,8,29,10],[16,10,16,12],[5,8,5,9],[7,4,8,7],[27,11,27,12],[7,10,8,12],[16,2,16,3],[0,0,0,3],[0,4,0,7],[1,0,1,2],[1,3,1,5],[7,8,7,9],[3,0,3,4],[5,0,5,1],[0,8,0,9],[6,8,6,12],[0,10,0,12],[3,11,3,12],[4,6,4,8],[4,9,4,10],[3,6,3,8],[4,11,4,12],[3,9,3,10],[9,10,9,12],[30,2,30,5],[29,2,29,5],[30,8,30,10],[23,2,23,3],[25,10,25,12],[23,10,23,12],[18,10,18,12],[10,10,10,12],[11,10,11,12],[19,2,19,3],[18,2,18,3],[9,2,9,3],[13,2,13,3],[24,10,24,12],[24,2,24,3],[4,0,4,4],[5,2,5,7],[7,0,8,0],[7,2,8,3],[10,2,10,3],[6,0,6,7],[7,1,8,1]]}
["Contract/PO Number:",null,null,null,{"$f":"Contract","v":0},null,null,null,"Job Number:",null,{"$f":"WO","v":0}]
["Inspection Date:",null,null,{"$f":"FAIDate","v":"00:00:00"},null,null,null,null,null,"Page","1","Of"]
[]
["Part Number",null,null,null,null,"Rev","Part Name",null,null,"Lot Qty",null,"FAI Qty"]
[{"$f":"PN","v":0},null,null,null,null,{"$f":"REV","v":0},{"$f":"Name","v":0},null,null,{"$f":"QTY","v":0}]
["Customer:",null,null,null,null,null,null,null,"Material:"]
[]
["Item","BP Zone","Drawing Dimension",null,"Actual Dimension",null,null,null,"Accept",null,"Comments"]
[null,null,null,null,null,null,null,null,"Yes","No"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Process Specs and Stds",null,"Processing",null,null,null,"Accept",null,"Processing",null,null,"Accept"]
[null,null,null,null,null,null,"Yes","No",null,null,null,"Yes","No"]
["Heat Treat"]
["Pre-Treat"]
["Prime/Finish"]
["Weld/Etc."]
["Other:"]
["Other:"]
[]
["Inspector:",null,null,null,null,null,null,null,null,"Date:"]

{"sheet":"Commercial Invoice","index":26,"n_rows":37,"n_cols":13,"rows_kept":37,"cut":false,"hidden":true,"merged":[[2,7,2,8],[6,1,6,2],[0,7,1,8],[6,5,6,6],[8,2,8,3],[8,6,8,8],[7,6,7,8],[7,2,7,3],[3,7,3,8],[4,6,4,8],[13,7,13,8],[17,3,17,6],[15,3,15,5],[13,3,13,5],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[14,7,14,8],[14,3,14,5],[9,2,9,3],[10,6,10,8],[10,2,10,3],[9,6,9,8],[12,3,12,5],[12,7,12,8],[36,3,36,5],[36,6,36,7],[20,3,20,6],[33,6,33,7],[34,6,34,7],[33,1,33,3],[28,3,28,6],[29,3,29,6],[32,6,32,7],[27,3,27,6],[24,3,24,6],[25,3,25,6],[26,3,26,6],[36,1,36,2],[35,6,35,7],[35,1,35,2],[35,3,35,5],[15,7,15,8],[21,3,21,6],[22,3,22,6],[23,3,23,6],[19,3,19,6],[30,3,30,6],[31,3,31,6]]}
[{"$f":"VLOOKUP(Company, PicTable, 2, FALSE)","v":"Picture2"},null,null,{"$f":"Company","v":"Industrial Welding & Engineering"},null,null,null,"INVOICE",null,null,null,"COMPANY","PHOTO"]
[null,null,null,{"$f":"Street","v":"747 Carle Ave."},null,null,null,null,null,null,null,"MTC Engineering","MTC"]
[null,null,null,{"$f":"State","v":"Lewis Center, OH 43035"},null,null,"Number:",{"$f":"WO","v":0},null,null,null,"Industrial Welding & Engineering","Picture2"]
[null,null,null,{"$f":"\"Phone: \"&Phone","v":"Phone: 614-883-6109"},null,null,null,{"$f":"Web","v":"www.iweohio.com"},null,null,null,"MTC Engineering, LLC","MTC"]
[null,null,null,{"$f":"\"FAX: \"&Fax","v":"FAX: email only"},null,"eMail:",{"$f":"Email","v":"iwe@columbus.rr.com"},null,null,null,null,"LCG Machine & Tool","LCG"]
[null,null,null,null,null,null,null,null,null,null,null,"Alannas Engineer","Picture4"]
[null,"SOLD TO:",null,null,null,"SHIP TO:",null,"(Circle if same)",null,null,null,"Westerville Mfg","WMFG"]
[null,null,{"$f":"Customer","v":0},null,null,null,{"$f":"Customer","v":0},null,null,null,null,"Boehm Machine","Boehm"]
[null,null,{"$f":"CustomerStreet","v":0},null,null,null,{"$f":"CustomerStreet","v":0},null,null,null,null,"RC Industries, Inc.","Picture 3"]
[null,null,{"$f":"CustomerState","v":0},null,null,null,{"$f":"CustomerState","v":0},null,null,null,null,"DSE Development","Picture 24"]
[null,null,{"$f":"CustomerPhone","v":0},null,null,null,{"$f":"CustomerPhone","v":0},null,null,null,null,"Maven Engineering Corporation","Picture 9"]
[null,null,null,null,null,null,null,null,null,null,null,"ADJ Finishing","Picture 4"]
[null,"Salesman:",null,{"$f":"IF(Company=\"MTC Engineering\",\"Tony Casillas, Sr. Engineer\",IF(Company=\"MTC Engineering, LLC\",\"Tony Casillas, POC/Sr. Engineer\",IF(Company=\"Industrial Welding & Engineering\",\"Brian Hoheisel, Owner\",IF(Company=\"Westerville Manufacturing\",\"Dietmar Hoheisel, Owner\",IF(Company=\"Alannas Engineer\",\"Severino Perez, Owner\",\"Signature\")))))","v":"Brian Hoheisel, Owner"},null,null,"Invoice Date:",{"$f":"ShipDate","v":"00:00:00"},null,null,null,"Fourply Design House","Picture 10"]
[null,"Terms:",null,"TBD",null,null,"Ship Date:",{"$f":"ShipDate","v":"00:00:00"},null,null,null,"Lewis Center Mfg.","Picture 11"]
[null,"Shipped Via:",null,"UPS",null,null,"FOB Point",{"$f":"IF(FOB=\"S\",\"Origin\",IF(FOB=\"D\",\"Dest\",\" \"))","v":" "},null,null,null,"Acromil Corp.","Picture 20"]
[null,"Customer Order #:",null,{"$f":"Customer_PO","v":0},null,null,null,null,null,null,null,"C. O. W. Industries, Inc.","COW"]
[]
[null,"ITEM #","QTY.","DESCRIPTION",null,null,null,"PRICE EACH","TOTAL"]
[null,{"$f":"IF(C19>0.1,1,\" \")","v":" "},{"$f":"QTY","v":0},{"$f":"Name","v":0},null,"Rev",{"$f":"REV","v":0},{"$f":"Unit_Cost","v":0},{"$f":"C19*H19","v":0}]
[null,{"$f":"IF(C20>0.1,B19+1,\" \")","v":" "},null,{"$f":"PN","v":0},null,null,null,null,{"$f":"IF(H20>0.0001,C20*H20,\" \")","v":" "}]
[null,{"$f":"IF(C21>0.1,MAX(B19:B20)+1,\" \")","v":" "},null,null,null,null,null,null,{"$f":"IF(H21>0.0001,C21*H21,\" \")","v":" "}]
[null,{"$f":"IF(C22>0.1,MAX(B19:B21)+1,\"\")","v":1},{"$f":"IF(Customer_PO>0.1,1,\"\")","v":""},{"$f":"IF(Customer_PO>0.1,\"Copies of Processing C of C's\",\"General C of C - No Charge\")","v":"General C of C - No Charge"},null,null,null,{"$f":"IF(Customer_PO>0.1,25,0)","v":0}," "]
[null,{"$f":"IF(C23>0.1,MAX(B19:B22)+1,\" \")","v":" "},null,{"$f":"IF(H22>25,\"Includes Processing Procedures\",\"\")","v":""},null,null,null,null," "]
[null,{"$f":"IF(C24>0.1,MAX(B19:B23)+1,\" \")","v":" "},null,null,null,null,null,null," "]
[null,{"$f":"IF(C25>0.1,MAX(B19:B24)+1,\" \")","v":" "},null,null,null,null,null,null," "]
[null,{"$f":"IF(C26>0.1,MAX(B19:B25)+1,\" \")","v":" "},null,null,null,null,null,null," "]
[null,{"$f":"IF(C27>0.1,MAX(B19:B26)+1,\" \")","v":" "},null,null,null,null,null,null," "]
[null,{"$f":"IF(C28>0.1,MAX(B19:B27)+1,\" \")","v":" "},null,null,null,null,null,null," "]
[null,{"$f":"IF(C29>0.1,MAX(B19:B28)+1,\" \")","v":" "},null,null,null,null,null,null," "]
[null,{"$f":"IF(C30>0.1,MAX(B19:B29)+1,\" \")","v":" "},null,null,null,null,null,null," "]
[null,{"$f":"IF(C31>0.1,MAX(B19:B30)+1,\" \")","v":" "},null,null,null,null,null,null," "]
[null,{"$f":"IF(C32>0.1,MAX(B19:B31)+1,\" \")","v":" "},null,null,null,null,null,null," "]
[null,null,null,null,null,null,"SUB TOTAL:",null,{"$f":"SUM(I19:I32)","v":0}]
[null,"Thank you for the order.",null,null,null,null,"SHIPPING/HANDLING:"]
[null,null,null,null,null,null,"PREVIOUS AMOUNT:"]
[null,{"$f":"ShipDate","v":"00:00:00"},null,null,null,null,"CREDIT:"]
[null,"Date",null,{"$f":"IF(Inspector>=1,\"Signature\"&\" - \"&Inspector,\"Signature\")","v":"Signature"},null,null,"AMOUNT DUE:",null,{"$f":"SUM(I33:I36)","v":0}]

{"sheet":"QA 011-Com - Packing List","index":27,"n_rows":36,"n_cols":8,"rows_kept":36,"cut":false,"hidden":true,"merged":[[20,3,20,4],[9,1,9,7],[3,1,3,3],[4,1,4,3],[5,1,5,3],[6,1,6,3],[21,3,21,4],[28,1,28,7],[27,1,27,7],[23,3,23,4],[35,1,35,5],[30,1,30,7],[26,1,26,3],[29,1,29,7],[34,1,34,5],[31,1,31,7],[22,3,22,4]]}
[]
[null,null,null,null,null,null,null,"PACKING LIST"]
[null,"SHIP TO:",null,null,null,"FROM:",null,{"$f":"Web","v":"www.iweohio.com"}]
[null,{"$f":"Customer","v":0},null,null,null,{"$f":"Company","v":"Industrial Welding & Engineering"}]
[null,{"$f":"CustomerStreet","v":0},null,null,null,{"$f":"Street","v":"747 Carle Ave."}]
[null,{"$f":"CustomerState","v":0},null,null,null,{"$f":"State","v":"Lewis Center, OH 43035"}]
[null,{"$f":"CustomerPhone","v":0},null,null,"Ph:",{"$f":"Phone","v":"614-883-6109"},"Fx:",{"$f":"Fax","v":"email only"}]
[null,null,null,null,null,null,"eMail:",{"$f":"Email","v":"iwe@columbus.rr.com"}]
[]
[null,"\"A Defense Contractor for Machined and Fabricated Spare Parts and Assemblies.\""]
[]
[null,"CONTRACT/PO #:",null,{"$f":"IF(Customer_PO>=Contract,Customer_PO,Contract)","v":0},null,"SHIPPING DATE:",null,{"$f":"AcceptDate","v":"00:00:00"}]
[]
[null,"QUANTITY:",null,{"$f":"QTY","v":0},null,"ITEM DESCRIPTION:",null,{"$f":"Name","v":0}]
[null,null,null,null,null,"P/N",null,{"$f":"PN","v":0}]
[null,null,null,null,null,"REV",null,{"$f":"REV","v":0}]
[null,null,null,null,null,"NSN:",null,{"$f":"NSN","v":0}]
[null,null,null,null,null,"WORK ORDER#:",null,{"$f":"WO","v":0}]
[]
[]
[null,"CONTRACT/PO #:",null,{"$f":"Contract","v":0},null,null,"WORK ORDER#:",{"$f":"WO","v":0}]
[null,"P/N",null,{"$f":"PN","v":0},null,null,"REV",{"$f":"REV","v":0}]
[null,"DESCRIPTION:",null,{"$f":"Name","v":0},null,null,"NSN:",{"$f":"NSN","v":0}]
[null,"QUANTITY:",null,{"$f":"QTY","v":0},null,null,"SHIPPING DATE:",{"$f":"ShipDate","v":"00:00:00"}]
[]
[]
[null,"ADDITIONAL NOTES OR COMMENTS:"]
[null,"*CERTIFICATE OF COMPLIANCE ATTACHED"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"ShipDate","v":"00:00:00"}]
[null,{"$f":"IF(Inspector>=1,\"Signature\"&\" - \"&Inspector,\"Signature\")","v":"Signature"},null,null,null,null,null,"DATE"]

{"sheet":"QA 010 QCP","index":28,"n_rows":47,"n_cols":10,"rows_kept":47,"cut":false,"hidden":true,"merged":[[0,2,0,3],[0,6,0,9],[1,6,1,9],[1,1,1,2],[5,8,6,8],[2,0,2,9],[3,0,3,9],[4,6,4,7],[5,9,6,9],[5,5,6,5],[5,6,6,7],[7,6,7,7],[8,6,8,7],[10,6,10,7],[11,6,11,7],[13,6,13,7],[12,6,12,7],[9,6,9,7],[32,7,32,8],[31,7,31,8],[29,4,29,5],[43,4,43,5],[36,4,36,5],[37,4,37,5],[38,4,38,5],[41,7,41,8],[36,7,36,8],[34,7,34,8],[33,7,33,8],[32,4,32,5],[33,4,33,5],[34,4,34,5],[45,4,45,5],[46,4,46,5],[40,4,40,5],[24,6,24,7],[25,6,25,7],[41,4,41,5],[42,4,42,5],[31,4,31,5],[28,4,28,5],[28,7,28,8],[35,7,35,8],[39,4,39,5],[44,4,44,5],[46,7,46,8],[35,4,35,5],[27,4,27,5],[26,0,26,9],[30,4,30,5],[30,7,30,8],[29,7,29,8],[27,7,27,8],[45,7,45,8],[38,7,38,8],[37,7,37,8],[42,7,42,8],[44,7,44,8],[43,7,43,8],[40,7,40,8],[39,7,39,8],[21,6,21,7],[25,1,25,3],[5,0,6,0],[5,1,6,1],[5,3,6,3],[5,4,6,4],[5,2,6,2],[19,6,19,7],[15,6,15,7],[17,6,17,7],[18,6,18,7],[20,6,20,7],[16,6,16,7],[22,6,22,7],[23,6,23,7],[14,6,14,7]]}
["WO:",{"$f":"WO","v":0},"Quality Schedule:",null,{"$f":"QTY","v":0},"Contract:",{"$f":"Contract","v":0}]
["Part No:",{"$f":"PN","v":0},null,"Rev:",{"$f":"REV","v":0},"Part Name:",{"$f":"Name","v":0}]
["**NOTE: All documentation must be at each machine or operation before submitting first piece to the Quality Auditor!!"]
["Quality Schedules: A = 1/Shift; B = 4/Shift; C = 1/Hour; D = 5/Hour; E = 1/25 Parts; F = 100% Inspection  (*First and Last Piece Only)"]
[1,2,3,4,5,6,7,null,8,9]
["Operation","Characteristic","Drawing/Spec & Tolerance","Sample Plan","Inspection Equipment","Recording Format","Department Responsible",null,"Process Capability","Reject Plan"]
[]
[null,null,null,"C = 0",null,null,null,null,null,"MR"]
[null,null,null,"C = 0",null,null,null,null,null,"MR"]
[null,null,null,"C = 0",null,null,null,null,null,"MR"]
[null,null,null,"C = 0",null,null,null,null,null,"MR"]
[null,null,null,"C = 0",null,null,null,null,null,"MR"]
[null,null,null,"C = 0",null,null,null,null,null,"MR"]
[null,null,null,"C = 0",null,null,null,null,null,"MR"]
[null,null,null,"C = 0",null,null,null,null,null,"MR"]
[null,null,null,"C = 0",null,null,null,null,null,"MR"]
[null,null,null,"C = 0",null,null,null,null,null,"MR"]
[null,null,null,"C = 0",null,null,null,null,null,"MR"]
[null,null,null,"C = 0",null,null,null,null,null,"MR"]
[null,null,null,"C = 0",null,null,null,null,null,"MR"]
[null,null,null,"C = 0",null,null,null,null,null,"MR"]
[null,null,null,"C = 0",null,null,null,null,null,"MR"]
[null,null,null,"C = 0",null,null,null,null,null,"MR"]
[null,null,null,"C = 0",null,null,null,null,null,"MR"]
[null,null,null,"C = 0",null,null,null,null,null,"MR"]
["ALL","SURFACE DEFECTS: Rust; Cracks; Burrs; Pulled Metal; Double Metal; Pitts; Dents; Weak Areas; Splits; Orange Peel; Slug & Die Marks",null,null,"VISL","IDS","ALL",null,"N/A","MR"]
["((Quality Control Plan is to Remain With Shop Order Planning Sheet))"]
[null,null,null,null,"Calipers - Vernier",null,"VRCL","Gauge - Taper",null,"TAGA"]
[null,null,null,null,"Check Fixture",null,"CKFX","     -Telescope",null,"TELG"]
[null,null,null,null,"Check Gauge",null,"CKGA","     -Thread Plug",null,"THPG"]
[null,null,null,null,"Check Template",null,"CKTP","     -Thread Ring",null,"THRG"]
[null,null,null,null,"Conductivity Meter",null,"COND","     -Pin",null,"PING"]
[null,null,null,null,"Coordinate Measuring",null,"CMM","Hardness Tester",null,"HDTE"]
[null,null,null,null,"Machine - CNC",null,"CMMC","Micrometer - Depth",null,"DMIC"]
[null,null,null,null,"Dial Indicator",null,"DIIN","     -Inside",null,"IMIC"]
[null,null,null,null,"Gauge - Ball",null,"BALG","     -Outside",null,"OMIC"]
[null,null,null,null,"     -Bore",null,"BOGA","     -Pin",null,"PMIC"]
[null,null,null,null,"     -Chamfer",null,"CFGA","     -Sht Metal",null,"SMMC"]
[null,null,null,null,"     -Countersink",null,"CSKG","Olson Test",null,"OLSN"]
[null,null,null,null,"     -Depth",null,"DPGA","Protractor",null,"PROT"]
[null,null,null,null,"     -Feeler",null,"FEGA","Rule (Linear)",null,"RULE"]
[null,null,null,null,"     -Groove",null,"GRGA","Scale (Weight)",null,"SCAL"]
[null,null,null,null,"     -Height",null,"HTGA","Square",null,"SQVR"]
[null,null,null,null,"     -Hole",null,"HOGA","Tape Measure",null,"TAPE"]
[null,null,null,null,"     -Radius",null,"RAGA","Thickness Meter",null,"TKME"]
[null,null,null,null,"     -Ring",null,"RIGA","Visual Inspection",null,"VISL"]
[null,null,null,null,"     -Snap",null,"SNGA"," - (A)ccept \\ (R)eject"]

{"sheet":"ME 001 SOP","index":29,"n_rows":43,"n_cols":10,"rows_kept":43,"cut":false,"hidden":true,"merged":[[41,1,41,2],[41,3,41,5],[42,3,42,5],[2,1,2,5],[4,2,4,3],[5,2,5,3],[3,1,3,5],[37,2,37,8],[40,2,40,8],[32,2,32,8],[21,2,21,8],[22,2,22,8],[23,2,23,8],[24,2,24,8],[25,2,25,8],[10,1,10,9],[16,2,16,8],[17,2,17,8],[18,2,18,8],[19,2,19,8],[12,5,12,9],[1,6,1,7],[8,7,8,9],[8,1,8,2],[4,6,4,7],[3,6,3,7],[2,6,2,7],[1,8,1,9],[2,8,2,9],[3,8,3,9],[0,1,1,5],[6,1,6,3],[8,3,8,4],[4,8,4,9],[5,8,5,9],[38,1,38,2],[38,3,38,5],[39,3,39,5],[14,3,14,9],[13,2,13,9],[26,2,26,8],[20,2,20,8],[33,2,33,8],[34,2,34,8],[35,2,35,8],[36,2,36,8],[27,2,27,8],[28,2,28,8],[29,2,29,8],[30,2,30,8],[31,2,31,8]]}
[null,{"$f":"Company","v":"Industrial Welding & Engineering"}]
[null,null,null,null,null,null,"WO/Job Number:",null,{"$f":"IF(WO>0.1,WO,\" \")","v":" "}]
[null,{"$f":"Street","v":"747 Carle Ave."},null,null,null,null,"Due:",null,{"$f":"IF(Due_Date_CLIN>0.1,Due_Date_CLIN-14,\" \")","v":" "}]
[null,{"$f":"State","v":"Lewis Center, OH 43035"},null,null,null,null,"Part Number:",null,{"$f":"UPPER(IF(PN>0.1,PN,\" \"))","v":" "}]
[null,"Phone:",{"$f":"Phone","v":"614-883-6109"},null,null,null,"Part Name:",null,{"$f":"PROPER(Name)","v":""}]
[null,"Fax:",{"$f":"Fax","v":"email only"},null,null,null,null,"Rev:",{"$f":"UPPER(REV)","v":""}]
[null,{"$f":"Email","v":"iwe@columbus.rr.com"},null,null,null,null,null,"Qty:"]
[]
[null,"Contract:",null,{"$f":"UPPER(Contract)","v":""},null,null,"Main NSN:",{"$f":"NSN","v":0}]
[]
[null,"SHOP ORDER/REWORK SUPPLEMENTAL PLANNING SHEET"]
[]
[null,"If items to be reworked, describe defect:"]
[]
[]
[]
[null,"STEP","ACTION",null,null,null,null,null,null,"COMPLETE"]
[null,1]
[null,{"$f":"B18+1","v":2}]
[null,{"$f":"B19+1","v":3}]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[]
[null,"Ordered By:",null,null,null,null,"DATE:"]
[null,null,"TITLE:","MRB/Project Manager"]
[]
[null,"APPROVED BY:",null,null,null,null,"DATE:"]
[null,null,"TITLE:","Inspector/Engineering"]

{"sheet":"DDC Shpg Inst Reqt","index":30,"n_rows":32,"n_cols":8,"rows_kept":32,"cut":false,"hidden":true,"merged":[[31,1,31,3],[31,4,31,6],[31,7,31,8],[29,1,29,3],[29,4,29,6],[29,7,29,8],[30,1,30,3],[30,4,30,6],[30,7,30,8],[28,1,28,3],[28,4,28,6],[28,7,28,8],[20,1,20,5],[20,7,20,8],[21,1,21,5],[21,7,21,8],[22,0,22,8],[23,0,23,8],[24,0,24,8],[25,0,25,8],[26,0,26,8],[27,4,27,6],[27,7,27,8],[19,1,19,5],[19,7,19,8],[14,1,14,4],[14,5,14,6],[14,7,14,8],[15,1,15,4],[15,5,15,6],[15,7,15,8],[16,0,16,8],[17,1,17,5],[17,7,17,8],[18,1,18,5],[18,7,18,8],[12,1,12,4],[12,5,12,6],[12,7,12,8],[13,1,13,4],[13,5,13,6],[13,7,13,8],[11,1,11,4],[11,5,11,6],[11,7,11,8],[7,1,7,4],[7,5,7,6],[7,7,7,8],[8,1,8,4],[8,5,8,6],[8,7,8,8],[9,1,9,2],[9,3,9,4],[9,5,10,6],[9,7,10,8],[10,1,10,4],[0,0,0,4],[0,7,0,8],[1,0,1,4],[1,7,1,8],[3,1,3,2],[3,3,3,6],[2,0,2,4],[2,7,2,8],[5,1,5,4],[5,5,6,6],[5,7,6,8],[6,1,6,4],[4,1,4,4],[4,5,4,6],[4,7,4,8]]}
["Vendor Request for Shipping",null,null,null,null,null,null,"FAX:  717-770-2701"]
["Instructions",null,null,null,null,null,null," Phone:  1-800-456-5507"]
["DDC Logistics Support",null,null,null,null,null,null,"E-Mail:  delivery@dla.mil"]
["Non ESOC",null,null,"VENDOR DATA",null,null,null,"ESOC"]
["Company Name:",{"$f":"Company","v":"Industrial Welding & Engineering"},null,null,null,"Requestor Name:",null,{"$f":"Inspector","v":0}]
["CAGE CODE:",{"$f":"Cage","v":"3NBK9"},null,null,null,"Requestor Phone No.:",null,{"$f":"Phone","v":"614-883-6109"}]
["Origin Shipping Address:",{"$f":"Street","v":"747 Carle Ave."}]
[null,{"$f":"State","v":"Lewis Center, OH 43035"},null,null,null,"Requestor FAX No.:",null,{"$f":"Fax","v":"email only"}]
["Requestor E-Mail:",{"$f":"Email","v":"iwe@columbus.rr.com"},null,null,null,"Requestor Website:",null,{"$f":"Web","v":"www.iweohio.com"}]
["Contract No./Call No. / Line Item No. ",{"$f":"Contract","v":0},null,null,null,"TCN/REQUISITION No."]
["   / Delivery Order:"]
["Supplemental Address/ Signal Code:",null,null,null,null,"Priority:"]
["Project Code:",null,null,null,null,"RDD (If known):"]
["Gross Weight:",null,null,null,null,"Nomenclature:"]
["No. / Type of Pieces:",null,null,null,null,"NSN (not req'd):"]
["Cube or Dimensions:",null,null,null,null,"HAZMAT Information PSN, Class, U.N., PG:"]
["SHIPPING INSTRUCTIONS"]
["POE/Ship To:",null,null,null,null,null,"POD (If Applicable):"]
[null,null,null,null,null,null,"Special Delivery Instructions:"," "]
["Ultimate Consignee Address (Mark For):"]
[]
[]
["FOR FOB ORIGIN CONTRACTS, ENTER THE APPLICABLE CBL ANNOTATION ON THE BILL OF LADING:"]
["If the Government is shown as the consignor or the consignee, the annotation shall be:   Transportation is for the Defense Logistics Agency and the actual total transportation charges paid to the carrier(s) by the consignor or consignee are assignable to, and shall be reimbursed by, the Government. "]
["If the Government is not shown as the consignor or the consignee, the annotation shall be:   Transportation is for the Defense Logistics Agency and the actual total transportation charges paid to the carrier(s) by the consignor or consignee shall be reimbursed by the Government, pursuant to cost-reimbursement contract No. _______________________________. This may be confirmed by contacting Defense Distribution Center, 1-800-456-5507.  Note to vendor:   Add the name and address of the Contract Administration Office listed in the contract. "]
["Overseas shipments of hazardous materials are to be marked, labeled and certified based upon the final mode of shipment from CONUS.  If the shipment is moving through a military aerial port of embarkation, the shipment shall be certified in accordance with the DLAI 4145.3, Preparing Hazardous Material for Military Air Shipments.  DLAI 4145.3 is available on the internet at http://www.dlaps.hq.dla.mil/dlai/i4145.3.pdf.  Shipments moving through surface/water ports shall be certified in accordance with the International Maritime Dangerous Goods (IMDG) Code.  "]
["DDC SUPPORT"]
["Initials:",null," ",null,"Date/Time Rec’d:"]
["ESOC/NON ESOC:","ESOC                    NON ESOC ",null,null,"Date/Time Address Provided:"]
["TP:",null,null,null,"Date/Time FACTS Offer:"]
[null,null,null,null,"IBS Booking Request Date/Time:"]
["Systems Problems:",null,null,null,"Area Code:"]

{"sheet":"Discount Extension Request","index":31,"n_rows":33,"n_cols":7,"rows_kept":33,"cut":false,"hidden":true,"merged":[[17,1,17,2],[22,4,22,6],[18,4,18,6],[10,2,10,3],[11,2,11,4],[15,0,15,6],[8,2,8,3],[8,5,8,6],[6,0,6,6],[9,2,9,3],[9,5,9,6],[24,1,24,6],[25,1,25,6],[18,1,18,2],[22,1,22,2],[32,1,32,2],[32,3,32,4],[27,1,27,4],[31,1,31,2],[31,3,31,4],[23,1,23,2],[19,1,19,2],[19,4,19,6],[20,1,20,2],[21,1,21,2],[0,3,0,6],[1,1,2,3],[1,4,1,6],[2,4,2,6],[5,5,5,6],[3,4,3,6],[4,4,4,6],[5,3,5,4]]}
[null,null,null,{"$f":"Company","v":"Industrial Welding & Engineering"}]
[null,"Facsimile Transmittal",null,null,{"$f":"Street","v":"747 Carle Ave."}]
[null,null,null,null,{"$f":"State","v":"Lewis Center, OH 43035"}]
[null,null,null,null,{"$f":"\"Phone: \"&Phone","v":"Phone: 614-883-6109"}]
[null,null,null,null,{"$f":"\"Fax: \"&Fax","v":"Fax: email only"}]
[null,null,null,{"$f":"Email","v":"iwe@columbus.rr.com"},null,{"$f":"IF(Web>0.1,Web,\" \")","v":"www.iweohio.com"}]
[]
[]
[null,"To:","DFAS Discount Extension Team",null,"From:"]
[null,"Fax:","216-367-3360",null,"Date:","2010-01-19"]
[null,"Phone:","614-693-8507, #2, #2",null,"Cover+:",3,"Pages"]
[null,"Subject:","Contract Discount Payment Extension",null,null,"CAGE: ",{"$f":"Cage","v":"3NBK9"}]
[]
[]
[]
["Please extend the discount period on the following contract as noted below:"]
[]
[null,"CONTRACT NUMBER: ",null,{"$f":"Contract","v":0},null,"COMMENTS"]
[null,"INVOICE NUMBER: ",null,72101]
[null,"INVOICE AMOUNT: ",null,6871.4]
[null,"RECEIVE/POSTED DATE: ",null,"2010-01-07"]
[null,"ACCEPTANCE DATE: ",null,"2010-01-16"]
[null,"CURRENT DISCOUNT TERMS: ",null," .5% 10, Net 30 "]
[null,"EXTENDED DISCOUNT DATE: ",null,"2010-01-22","Discount % offered:",0.01]
[]
[]
[]
[null,"If you have additional questions, please feel free to call or email"]
[]
[null,"Sincerely,"]
[]
[]
[null,"Signature",null,"Type Name - Title"]

{"sheet":"TDP CDRL","index":32,"n_rows":48,"n_cols":20,"rows_kept":48,"cut":false,"hidden":true,"merged":[[46,0,46,5],[46,6,46,9],[46,10,46,14],[42,0,42,11],[43,0,43,11],[44,0,44,11],[45,0,45,11],[46,15,46,17],[47,0,47,5],[47,6,47,9],[47,10,47,14],[47,15,47,17],[37,12,37,14],[38,12,38,14],[39,12,39,14],[40,12,40,14],[41,12,41,14],[42,12,42,14],[43,12,43,14],[44,12,44,14],[45,12,45,14],[14,18,47,19],[15,4,15,7],[15,8,15,11],[16,12,16,14],[17,12,17,14],[18,12,18,14],[19,12,19,14],[20,12,20,14],[21,12,21,14],[22,12,22,14],[23,12,23,14],[24,12,24,14],[25,12,25,14],[26,12,26,14],[27,12,27,14],[28,12,28,14],[29,12,29,14],[30,12,30,14],[31,12,31,14],[32,12,32,14],[33,12,33,14],[34,12,34,14],[35,12,35,14],[36,12,36,14],[0,20,1,20],[1,0,1,12],[1,13,1,17],[2,0,2,17],[3,0,3,2],[3,3,3,8],[3,9,3,17],[4,0,4,2],[4,3,4,8],[4,14,4,17],[17,0,17,11],[18,0,18,11],[19,0,19,11],[20,0,20,11],[21,0,21,11],[0,0,0,12],[0,13,0,17],[0,18,13,18],[0,19,6,19],[5,0,5,4],[5,5,5,10],[5,11,5,17],[6,0,6,4],[6,5,6,10],[6,11,6,17],[7,0,7,1],[7,2,7,10],[7,11,7,17],[8,19,9,19],[10,0,10,6],[10,7,10,11],[10,12,10,17],[11,0,11,6],[11,7,11,11],[27,0,27,11],[28,0,28,11],[29,0,29,11],[30,0,30,11],[31,0,31,11],[22,0,22,11],[23,0,23,11],[24,0,24,11],[25,0,25,11],[26,0,26,11],[37,0,37,11],[38,0,38,11],[39,0,39,11],[40,0,40,11],[41,0,41,11],[32,0,32,11],[33,0,33,11],[34,0,34,11],[35,0,35,11],[36,0,36,11],[16,0,16,1],[16,2,16,11],[14,1,14,3],[15,1,15,3],[8,0,8,1],[9,0,9,1],[8,2,8,10],[9,2,9,10],[8,11,8,17],[9,11,9,17],[11,12,11,17],[12,1,12,3],[12,4,12,7],[12,8,12,11],[12,12,12,17],[13,1,13,3],[13,4,13,7],[13,8,13,11],[13,12,15,14],[13,15,13,17],[14,4,14,7],[14,8,14,11],[14,15,15,15],[14,16,14,17]]}
["CONTRACT DATA REQUIREMENTS LIST (CDRL)",null,null,null,null,null,null,null,null,null,null,null,null,"Form Approved"]
["(1 Data Item)",null,null,null,null,null,null,null,null,null,null,null,null,"OMB No. 0704-0188"]
["The public reporting burden for this collection of information is estimated to average 110 hours per response, including the time for reviewing instructions, searching existing data sources, gathering and maintaining the data needed, and completing and reviewing the collection of information.  Send comments regarding this burden estimate or any other aspect of this collection of information, including suggestions for reducing the burden, to the Department of Defense, Executive Services Directorate (0704-0188).  Respondents should be aware that notwithstanding any other provision of law, no person shall be subject to any penalty for failing to comply with a collection of information if it does not display a currently valid OMB control number.  Please do not return your form to the above organization.  Send completed form to the Government Issuing Contracting Officer for the Contract/PR No. listed in Block E."]
[" A. CONTRACT LINE ITEM NO.",null,null," B. EXHIBIT",null,null,null,null,null," C.  CATEGORY:"]
["     ",null,null,"     ",null,null,null,null,null,"       TDP:",null,"TM:",null,"OTHER:"]
[" D. SYSTEM/ITEM",null,null,null,null," E. CONTRACT/PR NO.",null,null,null,null,null," F. CONTRACTOR"]
["     ",null,null,null,null,"     ",null,null,null,null,null,{"$f":"Company","v":"Industrial Welding & Engineering"}]
[" 1. DATA ITEM NO.",null," 2. TITLE OF DATA ITEM",null,null,null,null,null,null,null,null," 3. SUBTITLE",null,null,null,null,null,null,null," 17. PRICE GROUP"]
["     ",null,"     ",null,null,null,null,null,null,null,null,"     ",null,null,null,null,null,null,null,"     "]
[]
[" 4. AUTHORITY (Data Acquisition Document No.)",null,null,null,null,null,null," 5. CONTRACT REFERENCE",null,null,null,null," 6. REQUIRING OFFICE",null,null,null,null,null,null," 18. ESTIMATED"]
["     ",null,null,null,null,null,null,"     ",null,null,null,null,"          ",null,null,null,null,null,null,"TOTAL PRICE"]
[" 7. DD 250 REQ"," 9. DIST STATEMENT",null,null," 10. FREQUENCY",null,null,null," 12. DATE OF FIRST SUBMISSION",null,null,null," 14.                     DISTRIBUTION",null,null,null,null,null,null,"     "]
["     ","REQUIRED",null,null,"     ",null,null,null,"     ",null,null,null,"       a. ADDRESSEE",null,null,"      b. COPIES"]
[" 8. APP CODE","     ",null,null," 11.  AS OF DATE",null,null,null," 13. DATE IF SUBSEQUENT SUBM.",null,null,null,null,null,null,"Draft","      Final"]
["     ",null,null,null,"     ",null,null,null,"     ",null,null,null,null,null,null,null,"Reg","Repro"]
[" 16.  REMARKS",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,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,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,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,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,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,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,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,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,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,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,"     ",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,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,"     ","     ","     "]
["     ",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,null,null,null,null,null,null,null,null,null,null,"  15.  TOTAL   ▬▬▬▬►",null,null,"     ","     ","     "]
[" G. PREPARED BY",null,null,null,null,null," H. DATE",null,null,null," I. APPROVED BY",null,null,null,null," J. DATE"]
["     PREPARER'S NAME, AIR-XXXX",null,null,null,null,null,"     ",null,null,null,"    PD'S NAME, AIR-XXXX",null,null,null,null,"     "]

{"sheet":"Packaging Waiver Request","index":33,"n_rows":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":true,"merged":[[44,0,44,3],[44,8,44,9],[45,0,45,11],[44,4,44,5],[12,0,12,1],[16,6,16,9],[16,0,16,1],[34,6,34,11],[35,0,35,11],[36,0,36,11],[41,6,41,11],[42,5,42,11],[13,3,13,4],[14,3,14,4],[15,5,15,6],[39,5,40,11],[7,1,7,3],[7,9,7,10],[7,5,7,7],[16,2,16,5],[18,0,18,11],[9,0,9,2],[8,3,8,7],[8,9,8,10],[10,3,10,6],[10,0,10,2],[11,0,11,3],[11,9,11,11],[12,8,12,11],[12,2,12,7],[13,1,13,2],[14,1,14,2],[3,0,3,11],[5,0,6,1],[5,8,6,8],[5,5,6,6],[5,2,6,4],[5,7,6,7],[5,9,6,9],[5,10,6,10],[5,11,6,11],[0,5,0,6],[0,8,0,9],[1,5,1,6],[1,8,1,9],[0,1,0,3],[1,1,1,3],[39,0,42,1],[40,3,40,4],[24,8,31,11],[23,0,23,2],[25,0,25,3],[37,0,37,11],[23,3,23,4],[23,5,23,11]]}
["  FROM:",{"$f":"Company","v":"Industrial Welding & Engineering"},null,null,"Name:",null,null,"Phone:",null,null,"Date:"]
["TO:","DSCC Packaging",null,null,"Name:",null,null,"Phone:",null,null,"Date:"]
[]
[" REQUEST FOR PRESERVATION, PACKAGING, PACKING & MARKING WAIVER BY VENDOR"]
[]
["Contract #:",null,{"$f":"Contract","v":0},null,null,"CLIN's Effected:: "]
[]
["NSN:",{"$f":"NSN","v":0},null,null," P/N:",{"$f":"PN","v":0},null,null,null,"Contractor’s CAGE:",null,{"$f":"Cage","v":"3NBK9"}]
["Contractor's POC & Phone #:",null,null,{"$f":"Inspector&\" - \"&Phone","v":" - 614-883-6109"},null,null,null,null,"Fax:",{"$f":"Fax","v":"email only"}]
["Item weight and dimensions:",null,null,"WT:",null,"Length:",null,"Width:",null,"Heigth:"]
["Item (material) composition:",null,null,null,null,null,null," ESD Sensitive:",null,"(Yes/No)"]
["Proposed Packaging Design attached.:",null,null,null,null,"YES",null,"NO"," Attachments:"]
["Unit Container is:",null,null,null,null,null,null,null,"(If fiberboard container specify the following information:)"]
[null,"Bursting Strength:"]
[null,"Stacking Strength:"]
[null,null,null,"Single Wall:",null,"Double Wall:",null,null,null,"Triple Wall:"]
["Exterior Container is:",null,null,null,null,null,"(ie. Bag, Fiberboard box, Wood box, Crate, etc) "]
[]
["RECEIVING LOCATIONS"]
[null,"CLIN"," Location","Quantity",null,"CLIN"," Location","Quantity",null,"CLIN"," Location","Quantity"]
[]
[]
[]
["Military requirements on PR:",null,null," SEE ATTACHED.",null," (Must include a complete copy of solicitation/contract and offeror’s documentation.)"]
[null,null,null,null,null,null,null,null,"Photo"]
["Vendor proposes to comply with:"]
[]
[null,"a. MIL-STD 2073 - 1E",null,null,null,"YES",null,"NO"]
[null,"b. Quantity Unit Pack (QUP)",null,null,null,"YES",null,"NO"]
[null,"c. MIL-STD 129 Marking",null,null,null,"YES",null,"NO"]
[null,"d. Barcode (AIM BC-1)",null,null,null,"YES",null,"NO"]
[]
[]
[]
["Additional Remarks/Comments/Reasons for requesting waiver:"]
[]
[]
["**Please provide a copy of the completed form to DSCC-VSP via mail, e-mail (packaging@dscc.dla.mil) or facsimile 2-1901.** "]
[]
["Waiver has been:",null,null,null,null,"(Letter will be sent to applicable depots, upon receipt of contract number. Buyer is required to follow up & provide contract number to VSP. Contract number required to request depot to properly package IAW military packaging requirements within CTDF. Letter also notifies depot of authorized packaging waiver and ensures no Reports of Discrepancy shall be issued to Center on this contract and specified CLINs.)"]
[null,null,null,"Approved"]
[null,null,null,"Declined",null," Reason:"]
[]
[]
["Authorizing Packaging Specialist Signature:",null,null,null,null,null,null,"DSCC-VSP Phone #:",null,null,"Date:"]
[]
["DSCC.Packaging@dla.mil"]

{"sheet":"FAT Waiver Letter","index":34,"n_rows":98,"n_cols":8,"rows_kept":98,"cut":false,"hidden":true,"merged":[[14,3,14,6],[7,0,7,7],[13,1,13,2],[14,1,14,2],[10,1,10,3],[11,1,11,4],[11,5,11,6],[10,5,10,6],[13,3,13,5],[15,3,15,5],[16,5,16,6],[22,2,22,4],[19,5,19,7],[20,3,20,7],[19,2,19,4],[97,1,97,3],[22,5,22,7],[24,1,24,6],[18,1,18,5],[25,3,25,7],[92,1,92,3],[93,1,93,3],[94,1,94,4],[95,1,95,4],[96,1,96,3],[93,4,93,5],[92,4,92,5],[95,5,95,7],[96,4,96,5],[91,1,91,3],[28,3,28,7],[45,3,45,7],[26,3,26,7],[35,3,35,4],[36,3,36,4],[37,3,37,4],[38,3,38,4],[30,3,30,7],[27,3,27,5],[39,3,39,6],[40,3,40,7],[41,3,41,7],[43,3,43,7],[44,3,44,7],[32,3,33,7],[47,3,47,7],[51,3,51,7],[61,3,61,7],[59,3,60,7],[49,3,50,7],[74,3,74,7],[52,3,52,7],[53,3,53,5],[54,3,54,7],[56,3,56,7],[63,3,63,4],[64,3,64,4],[65,3,65,4],[66,3,66,4],[67,3,67,6],[68,3,68,7],[69,3,69,7],[71,3,71,7],[72,3,72,7],[89,1,89,7],[91,4,91,6],[75,3,75,7],[81,3,81,7],[86,3,86,7],[88,1,88,5],[77,1,77,6],[78,3,79,7],[83,3,84,7],[5,0,5,4],[5,5,5,6],[0,0,0,6],[1,0,1,4],[2,0,2,4],[3,0,3,4],[4,0,4,4]]}
[{"$f":"Company","v":"Industrial Welding & Engineering"}]
[{"$f":"Street","v":"747 Carle Ave."}]
[{"$f":"State","v":"Lewis Center, OH 43035"}]
[{"$f":"Phone","v":"614-883-6109"},null,null,null,null,null,null,{"$f":"NOW()","v":"2015-01-07T11:27:39.020"}]
[{"$f":"Fax","v":"email only"}]
[{"$f":"Email","v":"iwe@columbus.rr.com"},null,null,null,null,{"$f":"IF(Web>0,Web,\" \")","v":"www.iweohio.com"}]
[]
["FIRST ARTICLE WAIVER VALIDATION SUMMARY"]
[]
[1,"CURRENT ACQUISITIOIN INFORMATION"]
[null,"Buyer’s name:",null,null,null,{"$f":"PCO","v":0}]
[null,"Solicitation/Contractor No.: ",null,null,null,{"$f":"Contract","v":0}]
[]
[null,"NSN: ",null,{"$f":"NSN","v":0}]
[null,"NOUN: ",null,{"$f":"Name","v":0}]
[null,"P/N: ",null,{"$f":"PN","v":0}]
[null,"Drawing No./Revision Level: ",null,null,null,{"$f":"PN&\" - Rev \"&REV","v":" - Rev "}]
[]
[2,"TYPE OF WAIVER REQUEST"]
[null,null,"Partial Waiver",null,null,"Waiver of only specific test(s) of the First Article Test as required by the TDPL and/or solicitation as noted below:"]
[]
[null,null,null,null,null," "]
[null,null,"Full Waiver",null,null,"Waiver of all First Article Testing as required by the TDPL and/or solicitation."]
[]
[3,"JUSTIFICATION TO SUPPORT WAIVER REQUEST"]
[null,null,"a.","Successful completion of a First Article Test on a recent contract for the same item(s):"]
[null,null,null,"Contract number and date of the First Article Test acceptance."]
[null,null,null,null,null,null,"Date:"]
[null,null,null,"Above contract was manufactured at the same facilities in which the current item would be manufacturered and/or assembled?"]
[null,null,null,null,"Yes",null,"No, As noted below:"]
[]
[]
[null,null,"b.","Successful completion of a First Article Test on a similar item on a recent contract and the item has been tested on the same or substantially similar specification(s) as those herein referenced."]
[]
[]
[null,null,null,"Contract number ",null,null,"SPM4A7-09-M-4316"]
[null,null,null,"Nomenclature ",null,null,"Swivel, Hydraulic, Landing Gearing"]
[null,null,null,"Part Number ",null,null,"16H1717-809"]
[null,null,null,"NSN ",null,null,"1650-01-053-3667"]
[null,null,null,"Date of First Article Test Approval ",null,null,null,"2011-07-13"]
[null,null,null,"Major differences between the similar item and the item being procured are:"]
[null,null,null,"There is only one distinct difference between a 16H1717-809/810 and a 16H1717-801/802. 16H1717-809/810 requires a 16H1716-21 base. The 16H1717-801/802 requires a 16H1716-13 base. The pressure, flow and torque test are all per ECN661H6."]
[null,null,null,"Attachements:"]
[null,null,null,"FAT Approval letter and test reports are attached."]
[]
[null,null,null,"Above contract was manufactured at the same facilities in which the current item would be manufacturered and/or assembled?"]
[null,null,null,null,"Yes",null,"No, As noted below:"]
[]
[]
[null,null,"c.","Material has been in continuous production.  Last production run and date of last successful First Article Test. Documentation attached."]
[]
[]
[null,null,null,"Contract number and date of the First Article Test acceptance."]
[null,null,null,null,null,null,"Date:"]
[null,null,null,"Above contract was manufactured at the same facilities in which the current item would be manufacturered and/or assembled?"]
[null,null,null,null,"Yes",null,"No, As noted below:"]
[]
[]
[]
[null,null,"d.","Recent and successful performance of a first article test on the next higher assembly. A waiver will eliminate duplication of testing on the lower assembly. The following is the next higher assembly and attach supporting documentation:"]
[]
[]
[]
[null,null,null,"Contract number ",null,null,"SPM4A7-09-M-4316"]
[null,null,null,"Nomenclature ",null,null,"Swivel, Hydraulic, Landing Gearing"]
[null,null,null,"Part Number ",null,null,"16H1717-809"]
[null,null,null,"NSN ",null,null,"1650-01-053-3667"]
[null,null,null,"Date of First Article Test Approval ",null,null,null,"2011-07-13"]
[null,null,null,"Justification why duplicate testing is unnecessary:"]
[null,null,null,"There is only one distinct difference between a 16H1717-809/810 and a 16H1717-801/802. 16H1717-809/810 requires a 16H1716-21 base. The 16H1717-801/802 requires a 16H1716-13 base. The pressure, flow and torque test are all per ECN661H6."]
[null,null,null,"Attachements:"]
[null,null,null,"FAT Approval letter and test reports are attached."]
[]
[]
[null,null,"e.","Other. A waiver or partial waiver of the FAT is being requested based on the following:  "]
[]
[]
[4,"OTHER PERTINENT INFORMATION"]
[null,null,"a.","There are quality issues which affect the fit, form, or function of the item being procured, which may not be known by the Government as noted below."]
[]
[]
[]
[]
[null,null,"b.","There have been changes made to the item, processes or subcontractors used to manufacture the item, which may not be known by the Government as noted below:"]
[]
[]
[]
[]
[5,"CERTIFICATION OF FACT "]
[null,"The submitter, as an authorized agent of the company herein list below, certifies that the above statements and facts to be true and correct to the best of said agents’ knowledge and ability."]
[]
[null," Signature:"]
[null,"Printed Name: "]
[null,"Title: ",null,null,"Project Manager"]
[null,"Company Name: ",null,null,null,{"$f":"Company","v":"Industrial Welding & Engineering"}]
[null,"Company Address:",null,null,null,{"$f":"Street&\", \"&State","v":"747 Carle Ave., Lewis Center, OH 43035"}]
[null,"Phone Number:",null,null,{"$f":"Phone","v":"614-883-6109"}]
[null,"Cage Code:",null,null,{"$f":"Cage","v":"3NBK9"}]

{"sheet":"VECP","index":35,"n_rows":111,"n_cols":9,"rows_kept":111,"cut":false,"hidden":true,"merged":[[0,0,0,5],[2,0,2,1],[2,3,2,4],[3,0,3,1],[3,3,3,4],[4,0,4,1],[4,3,4,4],[10,0,10,1],[10,4,10,5],[11,0,11,1],[11,4,11,5],[12,0,12,5],[13,1,13,4],[5,0,5,1],[5,3,5,4],[7,0,7,1],[7,4,7,5],[8,0,8,2],[9,0,9,1],[9,4,9,5],[20,1,20,4],[21,0,21,5],[22,0,22,5],[23,0,23,5],[24,0,24,5],[25,0,25,5],[14,0,14,4],[15,1,15,4],[16,1,16,4],[17,1,17,4],[18,1,18,4],[19,1,19,4],[32,0,32,2],[32,3,32,5],[33,0,33,5],[34,0,34,5],[35,0,35,5],[36,0,36,5],[26,0,26,5],[27,0,27,5],[28,0,28,5],[29,0,29,5],[30,0,30,5],[31,0,31,2],[31,3,31,5],[42,1,42,2],[42,4,42,5],[43,1,43,2],[43,4,43,5],[44,2,44,3],[44,4,44,5],[37,0,37,5],[38,1,38,3],[38,4,38,5],[39,4,39,5],[40,4,40,5],[41,4,41,5],[52,0,52,5],[53,1,53,4],[54,0,54,4],[55,1,55,4],[56,1,56,4],[57,1,57,4],[46,4,46,5],[48,1,48,3],[48,4,48,5],[49,0,49,4],[50,0,50,5],[51,0,51,5],[64,0,64,5],[65,0,65,5],[66,0,66,5],[67,0,67,5],[68,0,68,5],[69,0,69,5],[58,1,58,4],[59,1,59,4],[60,1,60,4],[61,1,61,5],[62,0,62,5],[63,0,63,5],[76,0,76,2],[76,3,76,5],[77,0,77,5],[78,0,78,5],[79,0,79,5],[80,0,80,5],[70,0,70,5],[71,0,71,5],[72,0,72,5],[73,0,73,5],[75,0,75,2],[75,3,75,5],[86,1,86,2],[86,4,86,5],[87,2,87,3],[87,4,87,5],[89,4,89,5],[90,1,90,2],[81,1,81,3],[81,4,81,5],[82,4,82,5],[83,4,83,5],[84,4,84,5],[85,1,85,2],[85,4,85,5],[95,0,95,3],[96,0,96,3],[97,0,97,5],[98,0,98,3],[99,0,99,5],[100,0,100,3],[91,1,91,3],[91,4,91,5],[92,1,92,2],[93,1,93,2],[94,1,94,3],[94,4,94,5],[107,0,107,5],[108,0,108,5],[109,0,109,5],[110,0,110,5],[101,0,101,5],[102,0,102,3],[103,0,103,5],[104,0,104,3],[105,0,105,5],[106,0,106,3]]}
["Note: Items with a \"*\" indicate areas or heading zones that are to be filled in by the Government only"]
[]
["*Date Received by Government:",null,"*Government Representative:","*VECP No:",null,"*Approved?"]
[null,null,null,null,null,"*YES / NO"]
["Contract No:",null,"*Instant Contract Savings:","*Government Share:",null,"*"]
[null,null,"$","$"]
[]
["From (Prime Contractor):",null,null,"Submit Date:"]
[]
["To (Contracting Officer):",null,null,"Date change order must be issued to achieve savings:",null,null,null,null,"Yes"]
["Project Name:",null,null,"Contractor Representative:",null,null,null,null,"No"]
["Location of Work:",null,null,"Phone/FAX:"]
["It is recommended that the contractor examine the Contracting Officer Evaluation Section to determine if their proposal fits the criteria for a Value Engineering Change Proposal (VECP). If the it does not meet these requirements, they may need to submit this proposal under a different clause of the contract."]
["Item No.","INFORMATION REQUIRED OF THE CONTRACTOR",null,null,null,"YES / NO"]
["(When the answer to any of the following questions is \"YES\", include an explanation in remarks section"]
[1,"Does this proposed change affect the time of completion of the contract as stated in the general clauses?"]
[2,"Has the contractor previously submitted this proposed change to this office or any other Government Agency?"]
[3,"Does this change affect other costs to the Government, such as Government- furnished property or costs of contract related items?"]
[4,"Does this proposed change increase the maintenance or operation costs of original or proposed items?"]
[5,"Is a subcontractor involved in this proposed change to the original contract?"]
[6,"Does the contractor intend to restrict the Government's right to use any data described in this proposed change?"]
["CHANGES AND/OR REVISIONS TO DRAWINGS AND SPECIFICATIONS"]
["(Attach applicable contract drawings and specifications, including shop drawings or literature with all changes clearly marked.)"]
["Remarks (add sheets as needed):"]
[]
["SUMMARY OF PROPOSED CHANGE (add sheets if necessary)"]
[]
["Description of original (before change) contract condition (include discussion of any foreseen problems):"]
[]
["Description of after change to contract requirement:"]
[]
["Describe advantages of making change:",null,null,"Describe disadvantages of making change:"]
[]
["Describe any known or foreseen risks associated with making change:"]
[]
[]
["CONTRACTOR'S COST SUMMARY ESTIMATE"]
["Cost must be estimated in accordance with the change provisions contained within the general clauses of the contract. Attach detailed estimates (item, quantity, price, and totals) of the before and after condition for the change proposal and its development and implementation."]
["ID:","Description",null,null,"Total Dollar Amount"]
["A.","Original:"]
["B.","Proposed:"]
["C.","Construction Savings (A-B):"]
["D.","Gross Savings (C + Overhead + Other):"]
["E.","Contractor development and implementation costs (if any):"]
["F.",null,"Instant Contract Savings (D-E):"]
["G.","Government implementation costs (e.g., redesign, added inspections etc):"]
["H.","Contractor's share of savings (55% of [F - G]):"]
["I.","Contract Price Reduction (F - H):"]
["J.","Total Actual Government Savings (include reason if not the same as (I) above, e.g., affect of collateral savings and contractor share of same):"]
["Thank you for submitting a VECP. "]
["Please remember that it is important to make this change proposal summary and cost assessment as complete and accurate as possible.  If the proposal is accepted, the Government will use this information in generating its estimates and evaluation of the benefit to the public."]
["*CONTRACTING OFFICER EVALUATION SECTION"]
["(Government Use Only)"]
["Item No.","*REQUIRED CONTRACTING OFFICER EVALUATION",null,null,null,"YES / NO"]
["(The proposal will not qualify under the VE Incentive Clause if the answer to any of the following are \"NO\")"]
[1,"Does this proposed change originate voluntarily from an active contact by the contractor having the primary contract with the Government?"]
[2,"Does the proposal require a contract change by the Government Agency?"]
[3,"Does the proposed change result in an actual overall reduction in the contract price and/or estimated cost to the Government agency?"]
[4,"Does this proposed change involve a valid change in the contract. Invalid changes are, for example, changes in deliverable end item quantities only; research and development (R&D) end items, or R&D test quantities that are due solely to the result of previous testing of the involved contract; or to the contract type only."]
[5,"Does this proposed change retain all of the essential functions or characteristics for which the original contract was awarded, without impairing, compromising, or eliminating any of the functions or characteristics?"]
[6,"Does the submitted contractor proposed change documents include enough information, pursuant to FAR 52-248-1(c), so that it can be evaluated, and are critical issues such as time requirements included?"]
["Note:","Pursuant to the Federal Acquisition Regulations (FAR's), valid VECP's must be responded to within 45-days of receipt, or the time frame specified (if less than 45 days). Interior policy is to attempt to respond within 21-days."]
["*GOVERNMENT ASSESSMENT OF CHANGE PROPOSAL"]
[]
["(Attach additional contract drawings and specifications, with notations clearly marked, as needed)"]
[]
["*Remarks (add sheets as needed):"]
[]
["*GOVERNMENT SUMMARY OF PROPOSED CHANGE (add sheets if necessary)"]
[]
["*Description of original (before change) contract condition (include discussion of any foreseen problems):"]
[]
["*Description of after change to contract requirement:"]
[]
[]
["*Describe advantages of making change",null,null,"*Describe disadvantages of making change:"]
[]
["*Describe any known or foreseen risks associated with making change:"]
[]
["*GOVERNMENT COST SUMMARY ESTIMATE"]
["Cost must be estimated in accordance with the change provisions contained within the general clauses of the contract. Attach detailed estimates (item, quantity, price, and totals) of the before and after condition for the change proposal and its development and implementation."]
["ID:","Description",null,null,"Total Dollar Amount"]
["A.","Original:"]
["B.","Proposed:"]
["C.","Construction Savings (A-B):"]
["D.","Gross Savings (C + Overhead + Other):"]
["E.","Contractor development and implementation costs (if any):"]
["F.",null,"Instant Contract Savings (D-E):"]
["G.","Government implementation costs (e.g., redesign, added inspections etc):"]
["H.","Contractor's share of savings (55% of [F - G]):"]
["I.","Contract Price Reduction (F - H):"]
["J.","Total Actual Government Savings (include reason if not the same as (I) above, e.g., affect of collateral savings and contractor share of same):"]
["K.","Unreimbursed Government implementation (45% OF G):"]
["L.","Added Government evaluations costs due to VECP review (e.g., legal review, estimating review, design reviews, etc.):"]
["M.","Actual Government savings realized (J - K - L):"]
[]
["NOTES:"]
["1. When a proposal has a reasonable chance for full or partial acceptance, it is recommended that Government personnel advise and assist the contractor as necessary to obtain an acceptable proposal that actually saves Government resources (funds, etc.)."]
[]
["2. The cost of evaluating a valid VECP is not an implementation cost. It is a cost of the administration of the contract and may not be included in G above. However, if it determined that the evaluation costs are excessive and negate the benefits of the proposal, those costs can be considered as an evaluation parameter for acceptance or denial of the VECP (under the disadvantages section in the evaluation)."]
[]
["3. The regional and local Value Program Coordinator shall be informed upon receipt of any valid VECP. This is so they may report to OMB, Interior and others as to the number, status, and savings related to the VECP's pursuant to their responsibilities under PL 104-106, OMB A-131, DM369-1, and other laws and directives."]
[]
["4. Government personnel should review FAR clauses and guidance documents as needed to maintain their understanding of the intent of the VE Incentive Clause and practices regarding them."]
[]
["5. Items F and J are two of the figures reported in the periodic Value Program Summary of Activities and Office of Management and Budget (OMB) reports."]
[]
["\"An effective VECP program benefits everyone\""]
["*Additional Government Comments or Notations (if any):"]
[]
["Print, fill in, and transmit to the Contracting Officer (CO)."]

{"sheet":"Cost Breakdown","index":36,"n_rows":47,"n_cols":21,"rows_kept":47,"cut":false,"hidden":true,"merged":[[0,0,0,1],[0,2,0,4],[1,2,1,3],[1,8,1,9],[0,14,0,15],[2,2,2,3],[2,10,3,11],[1,14,1,15],[3,0,4,1],[3,2,4,3],[2,13,3,13],[2,14,3,15],[4,8,4,9],[5,0,5,3],[8,2,8,5],[8,8,8,15],[9,8,9,9],[10,2,10,5],[10,8,10,15],[11,2,11,5],[11,8,11,15],[12,2,12,5],[12,8,12,15],[13,2,13,5],[13,8,13,15],[14,2,14,5],[14,8,14,15],[15,2,15,5],[15,8,15,15],[16,2,16,5],[16,8,16,15],[17,2,17,5],[17,8,17,15],[18,2,18,5],[18,8,18,15],[19,2,19,5],[19,8,19,15],[27,8,27,15],[22,0,22,3],[22,8,22,15],[23,8,23,15],[24,8,24,15],[23,2,23,5],[24,2,24,5],[41,14,41,15],[46,14,46,15],[34,2,34,6],[34,8,34,15],[35,2,35,6],[35,8,35,15],[37,0,37,2],[38,11,38,12],[33,0,33,3],[33,8,33,15],[10,18,10,19],[39,11,39,12],[39,13,40,13],[39,14,40,14],[39,15,40,15],[29,2,29,6],[29,8,29,15],[30,2,30,6],[30,8,30,15],[20,2,20,5],[20,8,20,15],[26,0,26,3],[26,8,26,15],[27,2,27,6],[28,2,28,5],[28,8,28,15],[31,2,31,6],[31,8,31,15],[32,2,32,6],[32,8,32,15]]}
["Customer: ",null,{"$f":"Customer","v":0},null,null,null,null,"RFQ Received: ",{"$f":"DwgRvw","v":"00:00:00"},null,null,null,null,"RFQ Due Date: ",{"$f":"Due_Date_CLIN","v":"00:00:00"}]
[null,"Part Number: ",{"$f":"PN","v":0},null,"Rev: ",{"$f":"REV","v":0},null,"Contact : ",{"$f":"PCO","v":0},null,null,null,null,"Quote Ref: ","00-03-10"]
[null,"Description: ",{"$f":"Name","v":0},null,"Contract Qty: ",{"$f":"QTY","v":0},null,"Phone: ","800-457-0557","Address:","400 Aylworth Ave. South Haven, MI 49090",null,null,"Quote Status / Comments"]
["Special Requirements: ",null,"Requires (2) Inspection Gages built. (Supplied by customer)",null,"Run Qty: ",25,null,"FAX: ","616-637-8315"]
[null,null,null,null,"Lot Size: ",25,null,"Purchase Order Number: ",{"$f":"Contract","v":0}]
["RAW MATERIAL DATA (per piece) - [in inches]"]
["Item","Material Type","Material Specs","Length","Width","Height","Diameter","Wall Thickness","Cost/unit","Buy Unit","Unit Weight (Lbs)","Extended Cost","Specific Density","Cubic Inches","Unit Base","Total Length (in ft.)"]
[1,"Stl Tube","304SS",2,null,null,0.625,0.125,4.45,"Feet",{"$f":"IF(Height<Diameter>Width,Spec_Density*Cubic_Inches,Length*Width*Height*Spec_Density)","v":0.11113384012073892},{"$f":"IF(J8=\"LBS\",I8*K8,IF(J8=\"Each\",I8,IF(I8>0.001,(D8/O8)*I8,\" \")))","v":0.7416666666666667},{"$f":"IF(B8=\"Steel\",0.283,IF(B8=\"Almn\",0.036,IF(B8=\"Almn Tube\",0.036,IF(B8=\"Stl Tube\",0.283,IF(B8=\"Other\",0.025,\" \")))))","v":0.28299999999999997},{"$f":"IF(Diameter<Height,Length*Width*Height,IF(Width<Diameter>Height,IF(Thickness<0.0001,Length*(PI()*(Diameter/2)^2),Length*((PI()*(Diameter/2)^2)-(PI()*((Diameter-(Thickness*2))/2)^2)))))","v":0.39269908169872414},{"$f":"IF(J8=\"FEET\",12,IF(J8=\"LBS\",1,IF(J8=\"EACH\",1,IF(J8=\"INCH\",1,\" \"))))","v":12},{"$f":"IF(J8=\"Inch\",(D8*QTY)/12,D8*QTY)","v":0}]
["OPR","CODE","DESCRIPTION",null,null,null,"SET UP TIME (Mins)","RUN TIME (Mins)","COMMENTS"]
[]
["005","61-0001","Cut to length and Turn end OD's",null,null,null,10,0.5,null,null,null,null,null,null,null,null,null,null,"Material Type",null,"Buy Unit"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Steel",null,"Inch"]
["010","61-1000","Turn Dia #1",null,null,null,15,0.5,null,null,null,null,null,null,null,null,null,null,"Almn",null,"Feet"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other",null,"Each"]
["020","61-1000","Turn Dia #2",null,null,null,15,0.5,null,null,null,null,null,null,null,null,null,null,"Almn Tube",null,"Lbs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stl Tube"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H11:H21)","v":1.53},"Run_Time"]
["099","61-1999","Final Inspect, Deburr, Package and Ship",null,null,null,5,0.03,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G11:G21)","v":45},"Setup"]
[]
["Assembly Cost"]
[{"$f":"IF(C24>1,\"AS\",\" \")","v":"AS"},"ASSY","Assembly of details",null,null,null,20,15,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H24:H25)","v":15},"Assy_Time"]
[{"$f":"IF(C25>1,\"PK2\",\" \")","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G24:G25)","v":20},"Assy_Setup"]
[]
["Processing/Miscelleneous Cost per Run"]
["OPR","V CODE","PROCESS/ITEM DESCRIPTION",null,null,null,null,"Cost","COMMENTS"]
[]
["P01","MSC","Expendable Tooling (Cutting Oil, Cut-off tool Inserts, Chamfer tool inserts)",null,null,null,null,25]
[{"$f":"IF(C31>1,\"P02\",\" \")","v":" "}]
[{"$f":"IF(C32>1,\"P03\",\" \")","v":" "}]
[{"$f":"IF(C33>1,\"P04\",\" \")","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H30:H33)","v":25},"Misc_Cost"]
["Packaging Cost per Lot"]
[{"$f":"IF(C35>1,\"PK1\",\" \")","v":"PK1"},"PAC","Packaging Materials",null,null,null,null,2.5]
[{"$f":"IF(C36>1,\"PK2\",\" \")","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H35:H36)","v":2.5},"Pkg_Cost"]
[]
["COST SUMMARY"]
[null,null,"COST BASE PER HOUR","SET UP (Mins)","RUN (Mins)","RUN QUANTITY",null,"Amortized Set Up Cost","Per Piece Run Cost","Total Material","Off-Fall Allowance","Total Material Footage required to Build",null,null,"SET UP COST","RUN COST"]
[null,"MATERIAL ",null,null,null,{"$f":"IF(RUN_Qty>1,RUN_Qty,PO_Qty)","v":25},null,null,{"$f":"Matl_Cost*1.1","v":0.81583333333333341},{"$f":"Total_Length","v":0},{"$f":"J40*0.1","v":0},{"$f":"J40+K40","v":0},null,"Per Piece:",{"$f":"H41+H42+H43+H44","v":3.1786111111111115},{"$f":"SUM(I40:I42)","v":1.5993416666666669}]
[null,"DETAILS ",26.6,{"$f":"Setup/60","v":0.75},{"$f":"Run_Time/60","v":2.5500000000000002E-2},null,null,{"$f":"IF(D41+E41>0.01,(C41*D41)/F40,\" \")","v":0.79800000000000015},{"$f":"C41*E41","v":0.67830000000000013}]
[null,"ASSEMBLY ",25.25,{"$f":"Assy_Setup/60","v":0.33333333333333331},{"$f":"Assy_Time/60","v":0.25},null,null,{"$f":"IF(D42+E42>0.01,(C42*D42)/F40/60,\" \")","v":5.611111111111111E-3},{"$f":"C42*E42/60","v":0.10520833333333333},null,null,null,null,"Piece Cost: ",{"$f":"O40+P40","v":4.7779527777777782}]
[null,null,null,null,null,"TOOLING ",25,{"$f":"IF(Tooling>1,Tooling/F40,\" \")","v":1},null,null,null,null,null,"Burden: ",1.5,{"$f":"O42*O43","v":7.1669291666666677}]
[null,null,null,null,null,null,"PROCESS/MISC. ",{"$f":"IF(Misc_Cost>1,IF(Pkg_Cost>1,(((Misc_Cost/RUN_Qty))+(Pkg_Cost/LOT_Size))*1.25,\" \"))","v":1.375},null,null,null,null,null,"Profit:",0.05,{"$f":"P43*O44","v":0.3583464583333334}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Commission: ",0,{"$f":"P43*O45","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Piece Price:",{"$f":"SUM(P43:P45)","v":7.5252756250000008}]

{"sheet":"Images","index":37,"n_rows":62,"n_cols":34,"rows_kept":62,"cut":false,"hidden":true,"merged":[[0,25,0,33]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COMPANY","PHOTO",null,"DLA Group","Supply Chain","Address","Sate",null,"Gage Type",null,"`","GD&T Fonts"]
[null,null,null,null,null,null,null,null,null,null,null,"Material(s)",null,null,"MTC Engineering","Picture1",null,null,null,null,null,null,"Calipers (VRCL)",null,"q","w","e","r","t","y","u","i","o","p"]
[null,null,null,null,null,null,null,null,null,null,null,"Purchased Details (Hdwr, etc.)",null,null,"Industrial Welding & Engineering","Picture2",null,"DLA - Aviation Supply Chain","Aviation Supply Chain","8000 Jefferson Davis Hwy","Richmond, VA 23297-5770",null,"Chk Fixture (CHFX)",null,"a","s","d","f","g","h","j","k","l"]
[null,null,null,null,null,null,null,null,null,null,null,"Machine (EDM, Laser, etc.)",null,null,"MTC Engineering, LLC","Picture1",null,"DLA - Land Supply Chain","Land Supply Chain","PO Box 3990","Columbus, OH 43218-3990",null,"Chk Gage (CKGA)",null,"z","x","c","v","b","n","m"]
[null,null,null,null,null,null,null,null,null,null,null,"Form/Fabricate",null,null,"LCG Machine & Tool","Picture3",null,"DLA - Maritime Supply Chain","Maritime Supply Chain","PO Box 3990","Columbus, OH 43218-3990",null,"Template (CKTP)",null,"q","w","e","r","t","y","u","i","o","p"]
[null,null,null,null,null,null,null,null,null,null,null,"Weld",null,null,"Alannas Engineer","Picture4",null,"DLA - Land Detachment","Land Detachment","700 Robbins Ave.","Philadelphia, PA 19111-5096",null,"Conductivity Meter (COND)",null,"a","s","d","f","g","h","j","k","l"]
[null,null,null,null,null,null,null,null,null,null,null,"Anneal",null,null,"Westerville Mfg","Picture5",null,"DLA - Troop Support","Construction & Eqpt","700 Robbins Ave.","Philadelphia, PA 19111-5096",null,"Dial Indicator (DIIN)",null,"z","x","c","v","b","n","m"]
[null,null,null,null,null,null,null,null,null,null,null,"Heat Treat-Stress Relief, etc.",null,null,"Boehm Machine","Picture7",null,null,null,null,null,null,"Gauge - Ball (BALG)"]
[null,null,null,null,null,null,null,null,null,null,null,"Grind/Polish/Hone/Etc.",null,null,"DuLond Tool & Engineering, Inc.","Picture 8",null,"Ship Code","Location","Preservation Method Codes","Priority Rating Codes",null,"Gauge - Block (BKGA)"]
[null,null,null,null,null,null,null,null,null,null,null,"Special Process (Shot Peen, etc.)",null,null,"DSE Development",null,null,null,null,null,"Block #5",null,"Gauge - Bore (BOGA)"]
[null,null,null,null,null,null,null,null,null,null,null,"Assembly",null,null,"Maven Engineering Corporation","Picture 9",null,"N/A","Commercial","ASTM D3951","Non-Rated",null,"Gauge - Chamfer (CFGA"]
[null,null,null,null,null,null,null,null,null,null,null,"Testing (Mechanical)",null,null,"ADJ Finishing","Picture 4",null,"TCN","DD250 Site","M10","DX",null,"Gauge - C'sink (CSKG)"]
[null,null,null,null,null,null,null,null,null,null,null,"NDT (MPI, WPI, X-ray)",null,null,"Fourply Design House","Picture 10",null,"FMS","Foreign Military Sell","M20","DO",null,"Gauge - Depth (DPGA)"]
[null,null,null,null,null,null,null,null,null,null,null,"Clean, Pre (TT-C-490, Etc.)",null,null,"LC Mfg.","Picture 11",null,"FAT","*Per 52.209-4","M30",null,null,"Gauge - Feeler (FEGA)"]
[null,null,null,null,null,null,null,null,null,null,null,"Pre-Treat (Carbon Stls)",null,null,"C. O. W. Industries, Inc.","Picture6",null,"TDP","* Buyer Direct","M31","Program Code",null,"Gauge - Groove (GRGA)"]
[null,null,null,null,null,null,null,null,null,null,null,"Pre-Treat (Almn)",null,null,null,null,null,"W25G1U","Susquehanna, PA 17070","M32","Priority Code",null,"Gauge - Height (HTGA)"]
[null,null,null,null,null,null,null,null,null,null,null,"Pre-Treat (SS, TI, etc)",null,null,"Inspectors","Signatures",null,"W62G2T","Tracy, CA 95304","M33","A1",null,"Gauge - Hole (HOGA)"]
[null,null,null,null,null,null,null,null,null,null,null,"Prime",null,null,null,null,null,"N00253","Keyport, WA 98345","M40","A2",null,"Gauge - Radius (RAGA)"]
[null,null,null,null,null,null,null,null,null,null,null,"Top Coat",null,null,"Tony Casillas","PicTony",null,"N0534A","Kekaha, HI 96752","M41","A3",null,"Gauge - Ring (RIGA)"]
[null,null,null,null,null,null,null,null,null,null,null,"Finish Processing (Noted)",null,null,"Brian Hoheisel",null,null,"N35266","Pearl Habor, HI 96860","M42","A4",null,"Gauge - Snap (SNGA)"]
[null,null,null,null,null,null,null,null,null,null,null,"Plating (Cad, Chrome, etc)",null,null,"Lou Spiezio","PicLou",null,"N53845","San Diego, CA 92106","M43","A5",null,"Gauge - Taper (TAGA)"]
[null,null,null,null,null,null,null,null,null,null,null,"Special Coating (Dri-Lub, etc)",null,null,"Shane Englert",null,null,"N55262","San Diego, CA 92136","M44","A6",null,"Gauge - Telescope (TELG)"]
[null,null,null,null,null,null,null,null,null,null,null,"Special Packing (SPI-Special)",null,null,"Mike Cencula",null,null,"R21901","Norfolk, VA 23512","M45","A7",null,"Gauge - Thrd Plug (THPG)"]
[null,null,null,null,null,null,null,null,null,null,null,"Identification (Over 130 Std)",null,null,"Joe Casillas","PicJoe",null,"SW0400","Richmond, VA 23297","M50","B1",null,"Gauge - Thrd Ring (THRG)"]
[null,null,null,null,null,null,null,null,null,null,null,"Special ID Data (UID, S/N, Etc.)",null,null,"Nic Sanna",null,null,"SW0700","Columbus, OH 43213","M51","B8",null,"Gauge - Pin (PING)"]
[null,null,null,null,null,null,null,null,null,null,null,"Other, Noted:",null,null,"Debra Arenstein",null,null,"SW3100","Susquehanna, PA 17070","M52","B9",null,"Hardness Tester (HDTE)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Severino Perez","PicSeven",null,"SW3108","Susquehanna, PA 17070","M53","C1",null,"Depth Mic (DMIC)"]
[null,null,null,null,null,null,null,null,null,null,null,"FOB List",null,null,"George Boehm","PicGeorge",null,"SW3113","Cherry Point, NC 28533","M54","C2",null,"ID Mic (IMIC)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lowell Garrett","PicLowell",null,"SW3114","Tobyhanna, PA 18466","M55","C3",null,"OD Mic (OMIC)"]
[null,null,null,null,null,null,null,null,null,null,null,"D",null,null,"Dietmar Hoheisel","PicDietmar",null,"SW3117","Norfolk, VA 23512","Z","C9",null,"Pin Mic (PMIC)"]
[null,null,null,null,null,null,null,null,null,null,null,"S",null,null,"Christy Varner","PicChristy",null,"SW3119","Warner Robins, GA 31098","ZZ","D1",null,"Sht Mtl Mic (SMMC)"]
[null,null,null,null,null,null,null,null,null,null,null,"O",null,null,"Robert Chicaskz",null,null,"SW3120","Anniston, AL 36201","AE","D2",null,"Protractor (PROT)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tabatha Chicaskz",null,null,"SW3121","Albany, GA 31704","AH","D3",null,"Sin Bar (SINB)"]
[null,null,null,null,null,null,null,null,null,null,null,"IA List",null,null,"Greg Brunette",null,null,"SW3122","Jacksonville, FL 32212","AU","G1",null,"Ruler - Linear (RULE)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Luis Gomez",null,null,"SW3124","Susquehanna, PA 17070","AW","G2",null,"Scale, Weight (SCAL)"]
[null,null,null,null,null,null,null,null,null,null,null,"D",null,null,"David Hernandez",null,null,"SW3200","San Joaquin, CA 95376","BC","G3",null,"Square (SQVR)"]
[null,null,null,null,null,null,null,null,null,null,null,"S",null,null,"Victoria Moreland",null,null,"SW3210","Hill AFB, UT 84056","BD","J1",null,"Tape Measure (TAPE)"]
[null,null,null,null,null,null,null,null,null,null,null,"O",null,null,"Sherwin-Williams","PicKeith",null,"SW3211","Oklahoma City, OK 73145","BL","E1",null,"Thickness Meter (TKME)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW3212","McClellan, CA 95652","DB","E2",null,"Visual (VISL)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Engineers",null,null,"SW3213","San Antonio, TX 78241","DC","E3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tony Casillas - Sr. Engineer",null,null,"SW3215","Barstow, CA 92311","DR","F1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brian Hoheisel - Weld Engineer",null,null,"SW3216","Puget Sound NSY, WA 98314","DW","F2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Debra Arenstein - QA Manager",null,null,"SW3218","San Diego, CA 92136","EK","F3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lou Spiezio - Project Manager",null,null,"SW3222","Corpus Christi, TX 78419","GS","H1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nic Sanna - Project Manager",null,null,"SW3224","San Joaquin, CA 95376","GX","H5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Level II, M.T., P.T.",null,null,"SW3227","Red River, TX 75507","HM","H6"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sr. Engineer",null,null,"UY8615","Phoenix, AZ 85043","JF","H7"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Weld Engineer",null,null,"V55576","Bastion, Afghanistan","JM","H8"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Project Engineer",null,null,"W25G1Q","Chambersburg, PA 17201","KD","K1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Project Manager",null,null,"W25G1V","Tobyhanna, PA 18466","KF","N1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W25G1W","Tobyhanna, PA 18466","KG","N2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W31G1Y","Anniston, AL 36201","KH","N3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W31G1Z","Anniston, AL 36201",null,"N4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W33M8Q","Ft. Gordon, GA",null,"N5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W33M8U","Ft. Gordon, GA",null,"N6"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W45G18","Texarkana, TX 75507",null,"N7"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W45G19","Red River, TX 75507",null,"N8"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W45H08","Corpus Christi, TX 78419"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W73BF0","Fort Myer, VA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W806MT","Cortlandt Manor, NY 10567"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W80TWT","Fort Irwin, CA 92310"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W81K69","Ft. Sill, OK 73503"]