{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Temp","Summary","Forecast","Actual","Help"],"not_rendered":{"charts":1,"images":3,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":2},"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":"Temp","index":0,"n_rows":55,"n_cols":100,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
["Project","Group","DDate","Value","Type",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[1001,"DOC","2009-10-31",4850,"Act"]
[1001,"DOC","2009-11-30",3132,"Act"]
[1001,"DOC","2009-12-31",1965,"Act"]
[1002,"GES","2009-10-31",219,"Act"]
[1002,"GES","2009-11-30",375,"Act"]
[1002,"GES","2009-12-31",89,"Act"]
[1003,"COM","2009-10-31",8965,"Act"]
[1003,"COM","2009-11-30",1308,"Act"]
[1003,"COM","2009-12-31",7972,"Act"]
[1011,"DOC","2009-10-31",6810,"Act"]
[1011,"DOC","2009-11-30",11377,"Act"]
[1011,"DOC","2009-12-31",12607,"Act"]
[1012,"GES","2009-10-31",598,"Act"]
[1012,"GES","2009-11-30",875,"Act"]
[1012,"GES","2009-12-31",325,"Act"]
[1013,"COM","2009-10-31",11456,"Act"]
[1013,"COM","2009-11-30",19257,"Act"]
[1013,"COM","2009-12-31",18791,"Act"]
[1021,"DOC","2009-10-31",4685,"Act"]
[1021,"DOC","2009-11-30",507,"Act"]
[1021,"DOC","2009-12-31",5218,"Act"]
[1022,"GES","2009-10-31",493,"Act"]
[1022,"GES","2009-11-30",146,"Act"]
[1022,"GES","2009-12-31",316,"Act"]
[1023,"COM","2009-10-31",13264,"Act"]
[1023,"COM","2009-11-30",18210,"Act"]
[1023,"COM","2009-12-31",20994,"Act"]
[1001,"DOC","2009-10-31",5000,"Fcst"]
[1001,"DOC","2009-11-30",4547,"Fcst"]
[1001,"DOC","2009-12-31",1358,"Fcst"]
[1002,"GES","2009-10-31",100,"Fcst"]
[1002,"GES","2009-11-30",73,"Fcst"]
[1002,"GES","2009-12-31",52,"Fcst"]
[1003,"COM","2009-10-31",10000,"Fcst"]
[1003,"COM","2009-11-30",15431,"Fcst"]
[1003,"COM","2009-12-31",12964,"Fcst"]
[1011,"DOC","2009-10-31",6000,"Fcst"]
[1011,"DOC","2009-11-30",10107,"Fcst"]
[1011,"DOC","2009-12-31",13785,"Fcst"]
[1012,"GES","2009-10-31",200,"Fcst"]
[1012,"GES","2009-11-30",124,"Fcst"]
[1012,"GES","2009-12-31",367,"Fcst"]
[1013,"COM","2009-10-31",15000,"Fcst"]
[1013,"COM","2009-11-30",15513,"Fcst"]
[1013,"COM","2009-12-31",22869,"Fcst"]
[1021,"DOC","2009-10-31",7000,"Fcst"]
[1021,"DOC","2009-11-30",13190,"Fcst"]
[1021,"DOC","2009-12-31",6268,"Fcst"]
[1022,"GES","2009-10-31",300,"Fcst"]
[1022,"GES","2009-11-30",458,"Fcst"]
[1022,"GES","2009-12-31",574,"Fcst"]
[1023,"COM","2009-10-31",20000,"Fcst"]
[1023,"COM","2009-11-30",24664,"Fcst"]
[1023,"COM","2009-12-31",13595,"Fcst"]

{"sheet":"Summary","index":1,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,"PivotTable2"]
[null,null,null,"Group","DOC"]
[null,null,null,"DDate","2009-10-31"]
["PivotTable1"]
["Sum of Value",null,null,"Sum of Value","Type"]
[394343,null,null,"Project","Fcst","Act","Var"]
[null,null,null,1001,5000,4850,150]
[null,null,null,1002,0,0,0]
[null,null,null,1003,0,0,0]
[null,null,null,1011,6000,6810,-810]
[null,null,null,1012,0,0,0]
[null,null,null,1013,0,0,0]
[null,null,null,1021,7000,4685,2315]
[null,null,null,1022,0,0,0]
[null,null,null,1023,0,0,0]

{"sheet":"Forecast","index":2,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Table2"]
[null,"Project","Group","PG","10/31/09","11/30/09","12/31/09"]
[null,1001,"DOC",{"$f":"[Project]&\";\"&[Group]","v":"1001;DOC"},5000,4547,1358]
[null,1002,"GES",{"$f":"[Project]&\";\"&[Group]","v":"1002;GES"},100,73,52]
[null,1003,"COM",{"$f":"[Project]&\";\"&[Group]","v":"1003;COM"},10000,15431,12964]
[null,1011,"DOC",{"$f":"[Project]&\";\"&[Group]","v":"1011;DOC"},6000,10107,13785]
[null,1012,"GES",{"$f":"[Project]&\";\"&[Group]","v":"1012;GES"},200,124,367]
[null,1013,"COM",{"$f":"[Project]&\";\"&[Group]","v":"1013;COM"},15000,15513,22869]
[null,1021,"DOC",{"$f":"[Project]&\";\"&[Group]","v":"1021;DOC"},7000,13190,6268]
[null,1022,"GES",{"$f":"[Project]&\";\"&[Group]","v":"1022;GES"},300,458,574]
[null,1023,"COM",{"$f":"[Project]&\";\"&[Group]","v":"1023;COM"},20000,24664,13595]

{"sheet":"Actual","index":3,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Table1"]
[null,"Project","Group","PG","10/31/09","11/30/09","12/31/09"]
[null,1001,"DOC",{"$f":"[Project]&\";\"&[Group]","v":"1001;DOC"},4850,3132,1965]
[null,1002,"GES",{"$f":"[Project]&\";\"&[Group]","v":"1002;GES"},219,375,89]
[null,1003,"COM",{"$f":"[Project]&\";\"&[Group]","v":"1003;COM"},8965,1308,7972]
[null,1011,"DOC",{"$f":"[Project]&\";\"&[Group]","v":"1011;DOC"},6810,11377,12607]
[null,1012,"GES",{"$f":"[Project]&\";\"&[Group]","v":"1012;GES"},598,875,325]
[null,1013,"COM",{"$f":"[Project]&\";\"&[Group]","v":"1013;COM"},11456,19257,18791]
[null,1021,"DOC",{"$f":"[Project]&\";\"&[Group]","v":"1021;DOC"},4685,507,5218]
[null,1022,"GES",{"$f":"[Project]&\";\"&[Group]","v":"1022;GES"},493,146,316]
[null,1023,"COM",{"$f":"[Project]&\";\"&[Group]","v":"1023;COM"},13264,18210,20994]

{"sheet":"Help","index":4,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"PivotTable1"]
[null,"ALT+D+P"]