{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Calcs","ProjectData","Data"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Calcs","index":0,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Ratio","value"]
["Projects Completed in Budget",0.8]
["Projects Completed on Time",0.6]
["Projects with One Doc",0.4]
["Projects with Two Docs",0.4]
["Projects with Three Docs",0.2]
["Projects Customers Satisfied With",0]
["Projects having CPI greater than 1",0.6]
["Projects having SPI greater than 1",0.4]

{"sheet":"ProjectData","index":1,"n_rows":6,"n_cols":15,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["ProjectID","Project","BudgetAtCompletion","Actual_Expenditure","Percent_Complete","Planned","Earned Value","Planned Value","Cost Variance","Schedule Variance","Cost Performance Index","Schedule Performance Index","Estimate at Completion","Estimate to Complete","To-Complete Performance Index"]
[1,"Project1",1278280,164176,0.24769295454025267,0.48795228004455565,316620.9499297142,623739.64053535461,152444.9499297142,-307118.69060564041,1.9285458893487124,0.50761716805101409,662820.62929375609,498644.62929375609,0.86316811542754157]
[2,"Project2",1186013,333344,0.19842878580093384,0.37478287220001222,235339.11953412296,444497.35860655311,-98004.880465877039,-209158.23907243015,0.7059947667698323,0.52944998429660728,1679917.5515512889,1346573.5515512889,1.114938951065275]
[3,"Project3",1631743,351057,0.40707381963729861,0.15878429412841796,664239.85567642457,259095.1604539871,313182.85567642457,405144.6952224375,1.8921139748713871,2.5636907092843497,862391.49526439852,511334.49526439852,0.75545695379162059]
[4,"Project4",1916164,272104,0.5567686200141907,0.40147235393524172,1066859.9860008718,769286.87160596857,794755.98600087175,297573.11439490318,3.9207802384414481,1.3868168369670568,488720.07189102127,216616.07189102127,0.51658942739263058]
[5,"Project5",1243845,491632,0.18654974699020385,0.33417487144470215,232038.97004503012,415661.74297213554,-259593.02995496988,-183622.77292710543,0.47197694626271303,0.558239900515899,2635393.5501494766,2143761.5501494766,1.3451057479131174]

{"sheet":"Data","index":2,"n_rows":6,"n_cols":16,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["ProjectID","Project","Estimated_Resources","Actual_Resources","Estimated_Budget","Actual_Budget","Estimated_Timeline","Actual_Timeline","Doc1","Doc2","Doc3","FinishedInBudget","FinishedInTimeline","NumberofDocs","Scopechange","CustomerSatisfied"]
[1,"Project1",129,138,16,20,50,35,null,"Doc1_1","Doc1_1","No","Yes",2,"Yes","No"]
[2,"Project2",141,141,19,13,45,30,null,null,"Doc1_2","Yes","Yes",1,"No","No"]
[3,"Project3",191,126,19,14,39,48,"Doc1_3","Doc1_3","Doc1_3","Yes","No",3,"No","No"]
[4,"Project4",156,170,20,19,35,39,null,"Doc1_4","Doc1_4","Yes","No",2,"Yes","No"]
[5,"Project5",151,146,17,14,39,26,null,null,"Doc1_5","Yes","Yes",1,"No","No"]