{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Title","Q1","Q2","Q4","Total","CreateLinks","Recap"],"not_rendered":{"charts":0,"images":5,"macros":0,"external_links":2,"defined_names":13,"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":"Title","index":0,"n_rows":25,"n_cols":13,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,2046]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Image credit: 4volvos / Pixabay"]

{"sheet":"Q1","index":1,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Name","Jan","Feb","Mar"]
["James WSLCB Tallman",75,75,69]
["Michael Seeley",98,90,83]
["David Colman",62,53,88]
["P B Rayudu",71,86,93]
["Fr. Tony Azzarto",71,84,70]
["Erik Svensen",62,91,81]

{"sheet":"Q2","index":2,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Name","Apr","May","Jun","Jul","Aug"]
["Michael Seeley",62,56,83,78,98]
["David Colman",92,58,83,81,67]
["P B Rayudu",84,97,69,58,60]
["Erik Svensen",71,69,65,91,68]
["Michael Karpfen",52,80,89,83,73]
["Victor E. Scelba II",93,70,54,90,81]
["Emily Mathews",80,57,51,62,69]

{"sheet":"Q4","index":3,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Name","Sep","Oct","Nov","Dec"]
["Michael Seeley",94,79,86,92]
["P B Rayudu",75,83,85,90]
["Erik Svensen",81,79,87,97]
["Michael Karpfen",78,86,93,91]
["Emily Mathews",64,93,92,90]
["Robert Mika",99,84,93,99]
["David Ringstrom",71,80,93,94]

{"sheet":"Total","index":4,"n_rows":12,"n_cols":13,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Name","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
["David Colman",62,53,88,92,58,83,81,67,0,0,0,0]
["David Ringstrom",0,0,0,0,0,0,0,0,71,80,93,94]
["Emily Mathews",0,0,0,80,57,51,62,69,64,93,92,90]
["Erik Svensen",62,91,81,71,69,65,91,68,81,79,87,97]
["Fr. Tony Azzarto",71,84,70,0,0,0,0,0,0,0,0,0]
["James WSLCB Tallman",75,75,69,0,0,0,0,0,0,0,0,0]
["Michael Karpfen",0,0,0,52,80,89,83,73,78,86,93,91]
["Michael Seeley",98,90,83,62,56,83,78,98,94,79,86,92]
["P B Rayudu",71,86,93,84,97,69,58,60,75,83,85,90]
["Robert Mika",0,0,0,0,0,0,0,0,99,84,93,99]
["Victor E. Scelba II",0,0,0,93,70,54,90,81,0,0,0,0]

{"sheet":"CreateLinks","index":5,"n_rows":23,"n_cols":10,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[null,null,"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug"]
[null,"Otherworkbook",{"$f":"[2]Sheet1!$B$2","v":75},{"$f":"[2]Sheet1!$C$2","v":75},{"$f":"[2]Sheet1!$D$2","v":69}]
["James WSLCB Tallman",null,{"$f":"SUM(C2)","v":75},{"$f":"SUM(D2)","v":75},{"$f":"SUM(E2)","v":69}]
[null,"Otherworkbook",{"$f":"[2]Sheet1!$B$3","v":98},{"$f":"[2]Sheet1!$C$3","v":90},{"$f":"[2]Sheet1!$D$3","v":83}]
[null,"Otherworkbook",null,null,null,{"$f":"[2]Sheet1!$H$2","v":62},{"$f":"[2]Sheet1!$I$2","v":56},{"$f":"[2]Sheet1!$J$2","v":83},{"$f":"[2]Sheet1!$K$2","v":78},{"$f":"[2]Sheet1!$L$2","v":98}]
["Michael Seeley",null,{"$f":"SUM(C4:C5)","v":98},90,83,62,56,83,78,98]
[null,"Otherworkbook",{"$f":"[2]Sheet1!$B$4","v":62},{"$f":"[2]Sheet1!$C$4","v":53},{"$f":"[2]Sheet1!$D$4","v":88}]
[null,"Otherworkbook",null,null,null,{"$f":"[2]Sheet1!$H$3","v":92},{"$f":"[2]Sheet1!$I$3","v":58},{"$f":"[2]Sheet1!$J$3","v":83},{"$f":"[2]Sheet1!$K$3","v":81},{"$f":"[2]Sheet1!$L$3","v":67}]
["David Colman",null,{"$f":"SUM(C7:C8)","v":62},53,88,92,58,83,81,67]
[null,"Otherworkbook",{"$f":"[2]Sheet1!$B$5","v":71},{"$f":"[2]Sheet1!$C$5","v":86},{"$f":"[2]Sheet1!$D$5","v":93}]
[null,"Otherworkbook",null,null,null,{"$f":"[2]Sheet1!$H$4","v":84},{"$f":"[2]Sheet1!$I$4","v":97},{"$f":"[2]Sheet1!$J$4","v":69},{"$f":"[2]Sheet1!$K$4","v":58},{"$f":"[2]Sheet1!$L$4","v":60}]
["P B Rayudu",null,{"$f":"SUM(C10:C11)","v":71},86,93,84,97,69,58,60]
[null,"Otherworkbook",{"$f":"[2]Sheet1!$B$6","v":71},{"$f":"[2]Sheet1!$C$6","v":84},{"$f":"[2]Sheet1!$D$6","v":70}]
["Fr. Tony Azzarto",null,{"$f":"SUM(C13)","v":71},{"$f":"SUM(D13)","v":84},{"$f":"SUM(E13)","v":70}]
[null,"Otherworkbook",{"$f":"[2]Sheet1!$B$7","v":62},{"$f":"[2]Sheet1!$C$7","v":91},{"$f":"[2]Sheet1!$D$7","v":81}]
[null,"Otherworkbook",null,null,null,{"$f":"[2]Sheet1!$H$5","v":71},{"$f":"[2]Sheet1!$I$5","v":69},{"$f":"[2]Sheet1!$J$5","v":65},{"$f":"[2]Sheet1!$K$5","v":91},{"$f":"[2]Sheet1!$L$5","v":68}]
["Erik Svensen",null,{"$f":"SUM(C15:C16)","v":62},91,81,71,69,65,91,68]
[null,"Otherworkbook",null,null,null,{"$f":"[2]Sheet1!$H$6","v":52},{"$f":"[2]Sheet1!$I$6","v":80},{"$f":"[2]Sheet1!$J$6","v":89},{"$f":"[2]Sheet1!$K$6","v":83},{"$f":"[2]Sheet1!$L$6","v":73}]
["Michael Karpfen",null,null,null,null,{"$f":"SUM(F18)","v":52},{"$f":"SUM(G18)","v":80},{"$f":"SUM(H18)","v":89},{"$f":"SUM(I18)","v":83},{"$f":"SUM(J18)","v":73}]
[null,"Otherworkbook",null,null,null,{"$f":"[2]Sheet1!$H$7","v":93},{"$f":"[2]Sheet1!$I$7","v":70},{"$f":"[2]Sheet1!$J$7","v":54},{"$f":"[2]Sheet1!$K$7","v":90},{"$f":"[2]Sheet1!$L$7","v":81}]
["Victor E. Scelba II",null,null,null,null,{"$f":"SUM(F20)","v":93},{"$f":"SUM(G20)","v":70},{"$f":"SUM(H20)","v":54},{"$f":"SUM(I20)","v":90},{"$f":"SUM(J20)","v":81}]
[null,"Otherworkbook",null,null,null,{"$f":"[2]Sheet1!$H$8","v":80},{"$f":"[2]Sheet1!$I$8","v":57},{"$f":"[2]Sheet1!$J$8","v":51},{"$f":"[2]Sheet1!$K$8","v":62},{"$f":"[2]Sheet1!$L$8","v":69}]
["Emily Mathews",null,null,null,null,{"$f":"SUM(F22)","v":80},{"$f":"SUM(G22)","v":57},{"$f":"SUM(H22)","v":51},{"$f":"SUM(I22)","v":62},{"$f":"SUM(J22)","v":69}]

{"sheet":"Recap","index":6,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Episode Recap"]
[]
[null,"Consolidate is an ancient feature in Excel"]
[null,"Specify multiple ranges to consolidate"]
[null,"Use labels in Top row & Left column"]
[null,"Annoyances: A1 is always blank, column A is not sorted, blanks in data"]
[null,"Go to Special, Blanks, 0, Ctrl+Enter"]
[null,"Consolidate can point to external workbooks"]