{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Example receiving report","Example_Change_tracking_file"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"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":"Example receiving report","index":0,"n_rows":17,"n_cols":15,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["File name and path:",{"$f":"IF(ISNA(CELL(\"filename\",B1)),\"After the file is saved this formula will display the path and name\",SUBSTITUTE(LEFT(CELL(\"filename\",B1),FIND(\"]\",CELL(\"filename\",B1),1)-1),\"[\",\"\",1))","v":"C:\\Users\\blamil\\Desktop\\Hold_then_delete_later\\200106_ICPA_Example_file.xlsm"},{"$f":"\"Today's Date: \"&TEXT(NOW(),\" dd mmm yyyyy\")","v":"Today's Date:  06 Jan 2020"}]
[{"$f":"IF(ISNA(CELL(\"filename\",A2)),\"After the file is saved this formula will display the tab name\",\"Tab: \"&RIGHT(CELL(\"filename\",A2),LEN(CELL(\"filename\",A2))-FIND(\"]\",CELL(\"filename\",A2),1)))","v":"Tab: Example receiving report"},{"$f":"IF(ISNA(CELL(\"filename\",B2)),\"\",HYPERLINK(LEFT(CELL(\"filename\",B2),FIND(\"[\",CELL(\"filename\",B2),1)-1), \"Saved in: \"&MID(CELL(\"filename\",B2),FIND(\"\\[[\",SUBSTITUTE(CELL(\"filename\",B2),\"\\\",\"\\[[\",-1+SUMPRODUCT(LEN(CELL(\"filename\",B2))-LEN(SUBSTITUTE(CELL(\"filename\",B2),\"\\\",\"\")))),1)+1,(FIND(\"\\[\",CELL(\"filename\",B2))-2)-FIND(\"\\[[\",SUBSTITUTE(CELL(\"filename\",B2),\"\\\",\"\\[[\",-1+SUMPRODUCT(LEN(CELL(\"filename\",B2))-LEN(SUBSTITUTE(CELL(\"filename\",B2),\"\\\",\"\")))),1)+1)))","v":"Saved in: Hold_then_delete_later"}]
[]
["Part number","Part_Desc","HTS_on_File","COO_on_File","Vendor","Reciept_Date","Number_Received","Price_on_PO","Last_Receipt","Vendor_Change","COO_tied_to_vendor_part","Days_beteen_receipts","Difference_between_vendor_Part_COO_and_COO","Flag_COO_issue"]
["Widget_1","High performance widget, optimized for beer flows at or above 25L per second.","3924.90.5650","GB","Smitty's Pub Supply, LLC","2019-12-01",500,0.25,{"$f":"_xlfn.MAXIFS(F:F,A:A,A5)=F5","v":true},{"$f":"IF(AND(A5=A6,E5<>E6),\"Change\",\"no\")","v":"no"},"GB",{"$f":"IF(AND(A5=A6),F5-F6,\"\")","v":30},{"$f":"K5<>D5","v":false},{"$f":"IF(AND(I5=TRUE,M5=TRUE),\"Last receipt should have had COO change\",\"\")","v":""}]
["Widget_1","High performance widget, optimized for beer flows at or above 25L per second.","3924.90.5650","GB","Smitty's Pub Supply, LLC","2019-11-01",100,0.25,{"$f":"_xlfn.MAXIFS(F:F,A:A,A6)=F6","v":false},{"$f":"IF(AND(A6=A7,E6<>E7),\"Change\",\"no\")","v":"no"},"GB",{"$f":"IF(AND(A6=A7),F6-F7,\"\")","v":31},{"$f":"K6<>D6","v":false},{"$f":"IF(AND(I6=TRUE,M6=TRUE),\"Last receipt should have had COO change\",\"\")","v":""}]
["Widget_1","High performance widget, optimized for beer flows at or above 25L per second.","3924.90.5650","GB","Smitty's Pub Supply, LLC","2019-10-01",125,0.25,{"$f":"_xlfn.MAXIFS(F:F,A:A,A7)=F7","v":false},"no","GB",30,false,""]
["Widget_1","High performance widget, optimized for beer flows at or above 25L per second.","3924.90.5650","GB","Smitty's Pub Supply, LLC","2019-09-01",5000,0.25,{"$f":"_xlfn.MAXIFS(F:F,A:A,A8)=F8","v":false},"no","GB",31,false,""]
["Widget_1","High performance widget, optimized for beer flows at or above 25L per second.","3924.90.5650","GB","Smitty's Pub Supply, LLC","2019-08-01",250,0.25,{"$f":"_xlfn.MAXIFS(F:F,A:A,A9)=F9","v":false},"no","GB","",false,""]
["Faucet_1","Beer tap, specialized for Guiness and dark brews","8481.80.3090","DE","Duetsch Bier est Gemutlich Gmbh.","2019-12-01",250,47.5,{"$f":"_xlfn.MAXIFS(F:F,A:A,A10)=F10","v":true},"Change","DE",16,false,""]
["Faucet_1","Beer tap, specialized for Guiness and dark brews","8481.80.3090","DE","Joe's Home Brewing, Inc.","2019-11-15",25,52,{"$f":"_xlfn.MAXIFS(F:F,A:A,A11)=F11","v":false},"Change","US",14,true,"","<== Note no change.  If this had been run on 17 Nov, it would have flagged as needing a change."]
["Faucet_1","Beer tap, specialized for Guiness and dark brews","8481.80.3090","DE","Duetsch Bier est Gemutlich Gmbh.","2019-11-01",250,43.5,{"$f":"_xlfn.MAXIFS(F:F,A:A,A12)=F12","v":false},"no","DE",31,false,""]
["Faucet_1","Beer tap, specialized for Guiness and dark brews","8481.80.3090","DE","Duetsch Bier est Gemutlich Gmbh.","2019-10-01",250,41,{"$f":"_xlfn.MAXIFS(F:F,A:A,A13)=F13","v":false},"no","DE","",{"$f":"K13<>D13","v":false},{"$f":"IF(AND(I13=TRUE,M13=TRUE),\"Last receipt should have had COO change\",\"\")","v":""}]
["Keg_1","The good keg. All steel, tested to 10 ATM pressure, can be used at all pressure levels from la grange points to the bottom of the marianas trench.","7309.00.0030","BE","Mike's Welding","2020-01-01",5000,25,{"$f":"_xlfn.MAXIFS(F:F,A:A,A14)=F14","v":true},{"$f":"IF(AND(A14=A15,E14<>E15),\"Change\",\"no\")","v":"Change"},"US",16,true,"Last receipt should have had COO change"]
["Keg_1","The good keg. All steel, tested to 10 ATM pressure, can be used at all pressure levels from la grange points to the bottom of the marianas trench.","7309.00.0030","BE","Belgian Bier ist Best Gmbh.","2019-12-16",250,45,false,"no","BE",30,false,""]
["Keg_1","The good keg. All steel, tested to 10 ATM pressure, can be used at all pressure levels from la grange points to the bottom of the marianas trench.","7309.00.0030","BE","Belgian Bier ist Best Gmbh.","2019-11-16",250,45,false,"no","BE",31,false,""]
["Keg_1","The good keg. All steel, tested to 10 ATM pressure, can be used at all pressure levels from la grange points to the bottom of the marianas trench.","7309.00.0030","BE","Belgian Bier ist Best Gmbh.","2019-10-16",250,45,false,"no","BE","",false,""]

{"sheet":"Example_Change_tracking_file","index":1,"n_rows":10,"n_cols":22,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["File name and path:",{"$f":"IF(ISNA(CELL(\"filename\",B1)),\"After the file is saved this formula will display the path and name\",SUBSTITUTE(LEFT(CELL(\"filename\",B1),FIND(\"]\",CELL(\"filename\",B1),1)-1),\"[\",\"\",1))","v":"C:\\Users\\blamil\\Desktop\\Hold_then_delete_later\\200106_ICPA_Example_file.xlsm"},{"$f":"\"Today's Date: \"&TEXT(NOW(),\" dd mmm yyyyy\")","v":"Today's Date:  06 Jan 2020"},null,null,null,null,null,null,null,null,"Columns formatted like this are keyed into the Excel file used to control the update script."]
[{"$f":"IF(ISNA(CELL(\"filename\",A2)),\"After the file is saved this formula will display the tab name\",\"Tab: \"&RIGHT(CELL(\"filename\",A2),LEN(CELL(\"filename\",A2))-FIND(\"]\",CELL(\"filename\",A2),1)))","v":"Tab: Example_Change_tracking_file"},{"$f":"IF(ISNA(CELL(\"filename\",B2)),\"\",HYPERLINK(LEFT(CELL(\"filename\",B2),FIND(\"[\",CELL(\"filename\",B2),1)-1), \"Saved in: \"&MID(CELL(\"filename\",B2),FIND(\"\\[[\",SUBSTITUTE(CELL(\"filename\",B2),\"\\\",\"\\[[\",-1+SUMPRODUCT(LEN(CELL(\"filename\",B2))-LEN(SUBSTITUTE(CELL(\"filename\",B2),\"\\\",\"\")))),1)+1,(FIND(\"\\[\",CELL(\"filename\",B2))-2)-FIND(\"\\[[\",SUBSTITUTE(CELL(\"filename\",B2),\"\\\",\"\\[[\",-1+SUMPRODUCT(LEN(CELL(\"filename\",B2))-LEN(SUBSTITUTE(CELL(\"filename\",B2),\"\\\",\"\")))),1)+1)))","v":"Saved in: Hold_then_delete_later"},null,null,null,null,null,null,null,null,null,"Columns formated liks this can be provided by the user."]
[null,null,null,null,null,null,null,null,null,null,null,"Columns formatted like this get data back from the script or the ERP"]
[null,null,null,null,null,null,null,null,null,null,null,"Columns like this are generated by the script or the control mactro."]
[]
[]
["Item_Number","Item_Desc","Item_Desc_Ln_2","HTS_in_system_at_Start","COO_in_system_at_Start","Date_of_Action","Action","HTS_to_apply","COO_to_apply","Date_Reviewed","Who_Reviewed","Notes_about_the_decision","HTS_now_on_file","COO_now_on_file","Instructions_Sent_to_Script","Scripting_Changes","Spare_column_2","System","Flag_HTS_Change","Flag_COO_Change","Change_Flag","Add_Flag"]
["Widget_1","High performance widget, optimized for beer flows at or above 25L per second.",null," ",null,"2020-01-06","Add","3924.90.5650","GB","2020-01-06","Bam2","Widget floats at the top of beer stream in a high flow environment. Liquid movement causes the widget to run and paddles on the widget then froth the liquid as it moves past the widget, forming a mechanical frothing action. Optimized for Grolsch dispensing during October fest.","3924.90.5650","GB","Inquire","Inquire action updated to ADD when script found that the part was not in the compliance data table.",null,"JD Edwards",1,1,1,1]
["Faucet_1","Beer tap, specialized for Guiness and dark brews",null,"8481.80.3090","DE","2019-01-06","Inquire",null,null,"2019-01-06","Bam2","Using Inquire function to get this into the change table so that it is listed and flagged as being reviewed. All details check for HTS and COO. No updates needed.","8481.80.3090","DE","Inquire",null,null,"JD Edwards",0,0,0,0]
["Keg_1","The good keg. All steel, tested to 10 ATM pressure, can be used at all pressure levels from la grange points to the bottom of the marianas trench.",null,"7309.00.0030","BE","2020-01-06","Change",null,"US","2020-01-06","Bam2","Vendor and COO changed. Updating COO accordingly.","7309.00.0030","US","Change",null,null,"JD Edwards",0,1,1,0]