{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["SimpleExamples","Fittings"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":21,"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":"1904"}

{"sheet":"SimpleExamples","index":0,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[null,"ISMT E-130 Spreadsheet Models for Managers"]
[null,"Examples for Session 14: Using Macros II"]
[]
[]
[null,null,1,3,5]
[null,null,2.7,13,-8]
[null,null,4,2,1]
[null,null,null,null,null,null,null,"C"]
[null,"ArraySum",{"$f":"ArraySum(C6:E8,C14:E16)","v":2.1},6.3,10.5,null,null,{"$f":"\"{=ArraySum(C6:E8,C14:E16)}\"","v":"{=ArraySum(C6:E8,C14:E16)}"}]
[null,null,5.67,27.3,-16.8,null,null,{"$f":"\"{=ArraySum(C6:E8,C14:E16)}\"","v":"{=ArraySum(C6:E8,C14:E16)}"}]
[null,null,8.4,4.2,2.1,null,null,{"$f":"\"{=ArraySum(C6:E8,C14:E16)}\"","v":"{=ArraySum(C6:E8,C14:E16)}"}]
[]
[null,null,1.1000000000000001,3.3,5.5]
[null,null,2.97,14.3,-8.8000000000000007]
[null,null,4.4000000000000004,2.2000000000000002,1.1000000000000001]
[]
[null,"Multiply",{"$f":"Multiply(C14:E16,2)","v":2.2000000000000002},6.6,11,null,null,{"$f":"\"{=Multiply(C14:E16,2)}\"","v":"{=Multiply(C14:E16,2)}"}]
[null,null,5.94,28.6,-17.600000000000001,null,null,{"$f":"\"{=Multiply(C14:E16,2)}\"","v":"{=Multiply(C14:E16,2)}"}]
[null,null,8.8000000000000007,4.4000000000000004,2.2000000000000002,null,null,{"$f":"\"{=Multiply(C14:E16,2)}\"","v":"{=Multiply(C14:E16,2)}"}]

{"sheet":"Fittings","index":1,"n_rows":38,"n_cols":13,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[]
[null,"ISMT E-130 Spreadsheet Models for Managers"]
[null,"Examples for Session 14: Using Macros II"]
[]
[]
[null,"Brass Content (kgm)","4 Inch","6 Inch","8 Inch"]
[null,"T-Joint",2.5,3.2,5.0999999999999996]
[null,"L-Joint",3.6,4.3,6.2]
[null,"Y-Joint",4.25,5.44,8.67]
[]
[null,"Labels",null,null,null,"Definitions",null,null,null,null,"B"]
[null,{"$f":"B7:B9&\" \"&C6:E6","v":"T-Joint 4 Inch"},"T-Joint 6 Inch","T-Joint 8 Inch",null,null,"BrassContent","$C$7:$E$9",null,null,{"$f":"\"{=B7:B9&\"\" \"\"&C6:E6}\"","v":"{=B7:B9&\" \"&C6:E6}"}]
[null,"L-Joint 4 Inch","L-Joint 6 Inch","L-Joint 8 Inch",null,null,"BrassContentLineup","$C$18:$C$26"]
[null,"Y-Joint 4 Inch","Y-Joint 6 Inch","Y-Joint 8 Inch",null,null,"Labels","$B$12:$D$14"]
[null,null,null,null,null,null,"ProjectedSales","$C$29:$H$37"]
[]
[null,null,null,null,null,null,null,null,null,null,"B","C","D"]
[null,{"$f":"VLineUp(Labels)","v":"T-Joint 4 Inch"},{"$f":"VLineUp(BrassContent)","v":2.5},{"$f":"INDEX(BrassContent,0,1)","v":2.5},null,null,null,null,null,null,{"$f":"\"={VLineUp(Labels)}\"","v":"={VLineUp(Labels)}"},{"$f":"\"={VLineUp(BrassContent)}\"","v":"={VLineUp(BrassContent)}"},{"$f":"\"={INDEX(BrassContent,0,1)}\"","v":"={INDEX(BrassContent,0,1)}"}]
[null,"L-Joint 4 Inch",3.6,3.6,null,null,null,null,null,null,"={VLineUp(Labels)}","={VLineUp(BrassContent)}",{"$f":"\"={INDEX(BrassContent,0,1)}\"","v":"={INDEX(BrassContent,0,1)}"}]
[null,"Y-Joint 4 Inch",4.25,4.25,null,null,null,null,null,null,"={VLineUp(Labels)}","={VLineUp(BrassContent)}",{"$f":"\"={INDEX(BrassContent,0,1)}\"","v":"={INDEX(BrassContent,0,1)}"}]
[null,"T-Joint 6 Inch",3.2,{"$f":"INDEX(BrassContent,0,2)","v":3.2},null,null,null,null,null,null,"={VLineUp(Labels)}","={VLineUp(BrassContent)}",{"$f":"\"={INDEX(BrassContent,0,2)}\"","v":"={INDEX(BrassContent,0,2)}"}]
[null,"L-Joint 6 Inch",4.3,4.3,null,null,null,null,null,null,"={VLineUp(Labels)}","={VLineUp(BrassContent)}",{"$f":"\"={INDEX(BrassContent,0,2)}\"","v":"={INDEX(BrassContent,0,2)}"}]
[null,"Y-Joint 6 Inch",5.44,5.44,null,null,null,null,null,null,"={VLineUp(Labels)}","={VLineUp(BrassContent)}",{"$f":"\"={INDEX(BrassContent,0,2)}\"","v":"={INDEX(BrassContent,0,2)}"}]
[null,"T-Joint 8 Inch",5.0999999999999996,{"$f":"INDEX(BrassContent,0,3)","v":5.0999999999999996},null,null,null,null,null,null,"={VLineUp(Labels)}","={VLineUp(BrassContent)}",{"$f":"\"={INDEX(BrassContent,0,3)}\"","v":"={INDEX(BrassContent,0,3)}"}]
[null,"L-Joint 8 Inch",6.2,6.2,null,null,null,null,null,null,"={VLineUp(Labels)}","={VLineUp(BrassContent)}",{"$f":"\"={INDEX(BrassContent,0,3)}\"","v":"={INDEX(BrassContent,0,3)}"}]
[null,"Y-Joint 8 Inch",8.67,8.67,null,null,null,null,null,null,"={VLineUp(Labels)}","={VLineUp(BrassContent)}",{"$f":"\"={INDEX(BrassContent,0,3)}\"","v":"={INDEX(BrassContent,0,3)}"}]
[]
[null,"Projected Shipments","Oct","Nov","Dec","Jan","Feb","Mar"]
[null,{"$f":"VLineUp(Labels)","v":"T-Joint 4 Inch"},515,170,436,419,528,357]
[null,"L-Joint 4 Inch",543,205,570,276,140,395]
[null,"Y-Joint 4 Inch",371,369,133,489,566,215]
[null,"T-Joint 6 Inch",572,149,138,314,506,592]
[null,"L-Joint 6 Inch",229,579,413,295,228,568]
[null,"Y-Joint 6 Inch",531,166,594,458,416,218]
[null,"T-Joint 8 Inch",217,236,311,291,566,404]
[null,"L-Joint 8 Inch",462,511,306,259,458,574]
[null,"Y-Joint 8 Inch",273,167,374,544,405,257,null,null,"C"]
[null,"Total Brass Required",{"$f":"MMULT(TRANSPOSE(BrassContentLineup),ProjectedSales)","v":16860.800000000003},12420.48,15881.990000000002,16690.55,18329.689999999999,16598.359999999997,null,null,{"$f":"\"{=MMULT(TRANSPOSE(BrassContentLineup),ProjectedSales)}\"","v":"{=MMULT(TRANSPOSE(BrassContentLineup),ProjectedSales)}"}]