{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Sheet1","Sheet3","Sheet2","DataSources"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":5,"comments":0,"pivot_tables":1},"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":"Sheet1","index":0,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Sheet1LineNo","Item","Rev","AllocateTo","Qty","ItemRevKey"]
[{"$f":"ROW()","v":2},"Europa","P1-A","HW-Dev",5,{"$f":"tblSheet1DB[[#This Row],[Item]] & \":\" & tblSheet1DB[[#This Row],[Rev]]","v":"Europa:P1-A"}]
[{"$f":"ROW()","v":3},"Europa","P2-A","SW-Dev",3,{"$f":"tblSheet1DB[[#This Row],[Item]] & \":\" & tblSheet1DB[[#This Row],[Rev]]","v":"Europa:P2-A"}]
[{"$f":"ROW()","v":4},"Io","P1-A","HW-Dev",2,{"$f":"tblSheet1DB[[#This Row],[Item]] & \":\" & tblSheet1DB[[#This Row],[Rev]]","v":"Io:P1-A"}]
[{"$f":"ROW()","v":5},"Io","P2-B","SQA",8,{"$f":"tblSheet1DB[[#This Row],[Item]] & \":\" & tblSheet1DB[[#This Row],[Rev]]","v":"Io:P2-B"}]
[]
[{"$f":"\"=row()\"","v":"=row()"},null,"TableName \"tblSheet1DB\""]
[null,null,"so VBA creates named range \"rngSheet1DB\""]

{"sheet":"Sheet3","index":1,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Sum of Qty",null,null,"FQ","Date"]
[null,null,null,"3FQ2017",null,"1FQ2018",null,"Grand Total"]
["qSheet1DB.Item","qSheet1DB.ItemRevKey","AllocateTo","2017-09-17","2017-09-19","2018-01-03","2018-01-20"]
["Europa","Europa:P1-A","HW-Dev",5,null,null,null,5]
[null,"Europa:P2-A","SW-Dev",null,null,3,null,3]
["Io","Io:P1-A","HW-Dev",null,2,null,null,2]
[null,"Io:P2-B","SQA",null,null,null,8,8]
["Grand Total",null,null,5,2,3,8,18]

{"sheet":"Sheet2","index":2,"n_rows":6,"n_cols":6,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Sheet2LineNo","Item","Rev","Date","FQ","ItemRevKey"]
[{"$f":"ROW()","v":2},"Io","P1-A","2017-09-19","3FQ2017",{"$f":"tblSheet2DB[[#This Row],[Item]] & \":\" & tblSheet2DB[[#This Row],[Rev]]","v":"Io:P1-A"}]
[{"$f":"ROW()","v":3},"Io","P2-A","2018-01-06","1FQ2018",{"$f":"tblSheet2DB[[#This Row],[Item]] & \":\" & tblSheet2DB[[#This Row],[Rev]]","v":"Io:P2-A"}]
[{"$f":"ROW()","v":4},"Io","P2-B","2018-01-20","1FQ2018",{"$f":"tblSheet2DB[[#This Row],[Item]] & \":\" & tblSheet2DB[[#This Row],[Rev]]","v":"Io:P2-B"}]
[{"$f":"ROW()","v":5},"Europa","P1-A","2017-09-17","3FQ2017",{"$f":"tblSheet2DB[[#This Row],[Item]] & \":\" & tblSheet2DB[[#This Row],[Rev]]","v":"Europa:P1-A"}]
[{"$f":"ROW()","v":6},"Europa","P2-A","2018-01-03","1FQ2018",{"$f":"tblSheet2DB[[#This Row],[Item]] & \":\" & tblSheet2DB[[#This Row],[Rev]]","v":"Europa:P2-A"}]

{"sheet":"DataSources","index":3,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Tab (this workbook)","Database File Spec","MSAccess Table","Linkage within this workbook"]
["Sheet3",{"$f":"B7","v":"linked_tables.accdb"},"drive_linked_excel"]
["end"]
["Insert between orange fields","For convenience only, linked to source path below."]
[null,null,"RangePrefix"]
[null,"Common database source, path relative to this workbook:","rng"]
[null,"linked_tables.accdb"]
[]
[]
[]
[]
[]
[]
["Field","DisplayWidth"]
["Column1",15]
["Heading1",15]
["qSheet1DB.Column1",20]
["DisplayWidth"]
["Keep sorted"]