{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":1,"images":0,"macros":0,"external_links":0,"defined_names":9,"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":"Sheet1","index":0,"n_rows":49,"n_cols":12,"rows_kept":49,"cut":false,"hidden":false,"merged":[[24,5,24,6],[24,8,24,11],[4,9,4,10],[22,0,22,11],[0,0,0,7]]}
["DYNAMIC RANGES TO CHANGE CHART SERIES"]
[null,null,null,null,null,null,null,null,null,"www.excelnaccess.com"]
[]
[]
[null,null,null,null,null,null,null,null,null,"DYNAMIC NAMED RANGE",null,"FORMULA"]
[null,null,null,null,null,null,null,null,null,"MySeries",null,"=CHOOSE(myselection,Years,Quarters,Months)"]
[null,null,null,null,null,null,null,null,null,"MyAxis",null,"=CHOOSE(myselection,Y_Axis,Q_Axis,M_Axis)"]
[]
[]
[null,null,null,null,null,null,null,null,null,"CELL LINK FOR OPTION BUTTONS"]
[null,null,null,null,null,null,null,null,null,1]
[]
[]
[null,null,null,null,null,null,null,null,null,"DYNAMIC CHART TITLE"]
[null,null,null,null,null,null,null,null,null,{"$f":"CHOOSE(myselection,F25,A25,I25)","v":"YEARLY TREND"}]
[]
[]
[]
[]
[]
[]
[]
["DATA FOR CHART"]
[]
["QUARTERLY TREND",null,null,null,null,"YEARLY TREND",null,null,"MONTHLY TREND"]
[2014,"Q1",{"$f":"B26&CHAR(10)&A26","v":"Q1\n2014"},450560065,null,2010,{"$f":"G27*0.95","v":2025689110.242332},null,2015,"Jan",{"$f":"J26&CHAR(10)&RIGHT(I26,2)","v":"Jan\n15"},218159194.25325432]
[2014,"Q2",{"$f":"B27&CHAR(10)&A27","v":"Q2\n2014"},505670000,null,2011,{"$f":"G28*0.95","v":2132304326.5708759},null,2015,"Feb",{"$f":"J27&CHAR(10)&RIGHT(I27,2)","v":"Feb\n15"},174527355.40260345]
[2014,"Q3",{"$f":"B28&CHAR(10)&A28","v":"Q3\n2014"},621753703.62177479,null,2012,{"$f":"G29*0.95","v":2244530870.0746064},null,2015,"Mar","Mar\n15",174527355.40260345]
[2014,"Q4",{"$f":"B29&CHAR(10)&A29","v":"Q4\n2014"},909031045.8653245,null,2013,{"$f":"G30*0.95","v":2362664073.7627439},null,2015,"Apr","Apr\n15",209432826.48312414]
[2015,"Q1",{"$f":"B30&CHAR(10)&A30","v":"Q1\n2015"},509216370.90807587,null,2014,{"$f":"G31*0.95","v":2487014814.4870992},null,2015,"May","May\n15",251319391.77974898]
[2015,"Q2",{"$f":"B31&CHAR(10)&A31","v":"Q2\n2015"},660203740.94740605,null,2015,{"$f":"SUM(D30:D33)","v":2617910331.039052},null,2015,"Jun","Jun\n15",226187452.60177407]
[2015,"Q3","Q3\n2015",598251884.99973679,null,2016,{"$f":"SUM(D34:D37)","v":3385761600.7078362},null,2015,"Jul","Jul\n15",248806197.8619515]
[2015,"Q4","Q4\n2015",850238334.18383336,null,null,null,null,2015,"Aug","Aug\n15",248806197.8619515]
[2016,"Q1","Q1\n2016",687148462.25942457,null,null,null,null,2015,"Sep","Sep\n15",199044958.28956121]
[2016,"Q2","Q2\n2016",893475270.462286,null,null,null,null,2015,"Oct","Oct\n15",218949454.11851734]
[2016,"Q3","Q3\n2016",755285001.53205609,null,null,null,null,2015,"Nov","Nov\n15",175159563.29481387]
[2016,"Q4","Q4\n2016",1049852866.4540689,null,null,null,null,2015,"Dec","Dec\n15",272990383.68914795]
[null,null,null,null,null,null,null,null,2016,"Jan","Jan\n16",282146800.05898637]
[null,null,null,null,null,null,null,null,2016,"Feb","Feb\n16",253932120.05308771]
[null,null,null,null,null,null,null,null,2016,"Mar","Mar\n16",330111756.06901401]
[null,null,null,null,null,null,null,null,2016,"Apr","Apr\n16",264089404.8552112]
[null,null,null,null,null,null,null,null,2016,"May","May\n16",237680464.36969009]
[null,null,null,null,null,null,null,null,2016,"Jun","Jun\n16",285216557.24362814]
[null,null,null,null,null,null,null,null,2016,"Jul","Jul\n16",199651590.07053971]
[null,null,null,null,null,null,null,null,2016,"Aug","Aug\n16",259547067.0917016]
[null,null,null,null,null,null,null,null,2016,"Sep","Sep\n16",337411187.21921206]
[null,null,null,null,null,null,null,null,2016,"Oct","Oct\n16",269928949.77536964]
[null,null,null,null,null,null,null,null,2016,"Nov","Nov\n16",242936054.79783267]
[null,null,null,null,null,null,null,null,2016,"Dec","Dec\n16",423109649.10356331]