{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Raw Data","KPI Calculations","Dashboard"],"not_rendered":{"charts":7},"read":"whole","date_system":"1900"}

{"sheet":"Raw Data","index":0,"n_rows":41,"n_cols":7,"rows_kept":41}
["Date","Equipment ID","Downtime (hrs)","Repair Time (hrs)","Is Failure","Is PM","PM Scheduled"]
["2024-03-21","EQ01",0,0,0,1,1]
["2024-03-09","EQ03",1.5,1.2,1,1,1]
["2024-03-27","EQ03",2.5,1.6,1,0,0]
["2024-01-28","EQ02",0,0,0,1,0]
["2024-01-23","EQ02",2.4,1.2,1,1,1]
["2024-03-16","EQ02",1.7,2.3,1,0,0]
["2024-02-10","EQ01",3,0.9,1,0,0]
["2024-01-28","EQ02",2.3,1.2,1,1,0]
["2024-03-09","EQ03",2.2,2.1,1,0,0]
["2024-03-06","EQ01",0,0,0,1,0]
["2024-03-10","EQ03",0,0,0,1,1]
["2024-02-18","EQ03",0,0,0,1,0]
["2024-03-07","EQ01",2.9,0.9,1,0,1]
["2024-02-28","EQ02",2.1,1.1,1,1,0]
["2024-01-26","EQ01",0,0,0,0,1]
["2024-02-16","EQ03",0,1.3,1,0,1]
["2024-01-04","EQ03",1.2,0.7,1,0,0]
["2024-01-10","EQ03",2.3,2.2,1,1,0]
["2024-03-13","EQ01",0,0,0,1,0]
["2024-03-04","EQ01",2.9,2.1,1,0,1]
["2024-02-18","EQ03",2.1,0.8,1,1,0]
["2024-02-22","EQ03",2,1.7,1,1,1]
["2024-03-07","EQ01",0,0,0,0,1]
["2024-02-14","EQ01",0,0,0,1,1]
["2024-02-02","EQ02",2.5,1.9,1,0,0]
["2024-03-30","EQ03",0.6,1.2,1,0,1]
["2024-03-14","EQ03",0,0,0,1,1]
["2024-01-08","EQ01",0.1,2.4,1,1,1]
["2024-02-13","EQ02",0,0,0,0,0]
["2024-02-13","EQ03",2.1,0.9,1,1,1]
["2024-03-11","EQ01",1.8,1.6,1,0,0]
["2024-02-10","EQ03",3.8,2,1,0,0]
["2024-01-04","EQ01",0,0,0,1,0]
["2024-02-01","EQ02",0,0,0,0,1]
["2024-03-08","EQ02",0,0,0,0,0]
["2024-03-10","EQ03",0,0,0,0,1]
["2024-02-28","EQ01",0.3,1.2,1,1,1]
["2024-03-17","EQ02",0,0,0,0,0]
["2024-01-30","EQ02",2.7,2.3,1,1,1]
["2024-01-28","EQ03",0,0,0,0,0]

{"sheet":"KPI Calculations","index":1,"n_rows":4,"n_cols":8,"rows_kept":4}
["Month","MTTR (hrs)","MTBF (hrs)","Downtime (hrs)","Completed Work Orders","Planned Maintenance %","OEE (%)","PMC (%)"]
["Jan",{"$f":"AVERAGEIFS(Raw Data!D2:D100, Raw Data!E2:E100, 1, TEXT(Raw Data!A2:A100, \"MM\"), \"01\")","v":null},{"$f":"IF(COUNTIFS(TEXT(Raw Data!A2:A100,\"MM\"),\"01\",Raw Data!E2:E100,1)=0,0, 720/COUNTIFS(TEXT(Raw Data!A2:A100,\"MM\"),\"01\",Raw Data!E2:E100,1))","v":null},{"$f":"SUMIFS(Raw Data!C2:C100, TEXT(Raw Data!A2:A100, \"MM\"), \"01\")","v":null},{"$f":"COUNTIFS(TEXT(Raw Data!A2:A100,\"MM\"),\"01\")","v":null},{"$f":"IF(COUNTIFS(TEXT(Raw Data!A2:A100,\"MM\"),\"01\", Raw Data!F2:F100,1)=0,0, COUNTIFS(TEXT(Raw Data!A2:A100,\"MM\"),\"01\", Raw Data!F2:F100,1)/COUNTIFS(TEXT(Raw Data!A2:A100,\"MM\"),\"01\", Raw Data!G2:G100,1))","v":null},{"$f":"100 - C2","v":null},{"$f":"IF(COUNTIFS(TEXT(Raw Data!A2:A100,\"MM\"),\"01\", Raw Data!G2:G100,1)=0,0, COUNTIFS(TEXT(Raw Data!A2:A100,\"MM\"),\"01\", Raw Data!F2:F100,1)/COUNTIFS(TEXT(Raw Data!A2:A100,\"MM\"),\"01\", Raw Data!G2:G100,1))","v":null}]
["Feb",{"$f":"AVERAGEIFS(Raw Data!D2:D100, Raw Data!E2:E100, 1, TEXT(Raw Data!A2:A100, \"MM\"), \"02\")","v":null},{"$f":"IF(COUNTIFS(TEXT(Raw Data!A2:A100,\"MM\"),\"02\",Raw Data!E2:E100,1)=0,0, 720/COUNTIFS(TEXT(Raw Data!A2:A100,\"MM\"),\"02\",Raw Data!E2:E100,1))","v":null},{"$f":"SUMIFS(Raw Data!C2:C100, TEXT(Raw Data!A2:A100, \"MM\"), \"02\")","v":null},{"$f":"COUNTIFS(TEXT(Raw Data!A2:A100,\"MM\"),\"02\")","v":null},{"$f":"IF(COUNTIFS(TEXT(Raw Data!A2:A100,\"MM\"),\"02\", Raw Data!F2:F100,1)=0,0, COUNTIFS(TEXT(Raw Data!A2:A100,\"MM\"),\"02\", Raw Data!F2:F100,1)/COUNTIFS(TEXT(Raw Data!A2:A100,\"MM\"),\"02\", Raw Data!G2:G100,1))","v":null},{"$f":"100 - C3","v":null},{"$f":"IF(COUNTIFS(TEXT(Raw Data!A2:A100,\"MM\"),\"02\", Raw Data!G2:G100,1)=0,0, COUNTIFS(TEXT(Raw Data!A2:A100,\"MM\"),\"02\", Raw Data!F2:F100,1)/COUNTIFS(TEXT(Raw Data!A2:A100,\"MM\"),\"02\", Raw Data!G2:G100,1))","v":null}]
["Mar",{"$f":"AVERAGEIFS(Raw Data!D2:D100, Raw Data!E2:E100, 1, TEXT(Raw Data!A2:A100, \"MM\"), \"03\")","v":null},{"$f":"IF(COUNTIFS(TEXT(Raw Data!A2:A100,\"MM\"),\"03\",Raw Data!E2:E100,1)=0,0, 720/COUNTIFS(TEXT(Raw Data!A2:A100,\"MM\"),\"03\",Raw Data!E2:E100,1))","v":null},{"$f":"SUMIFS(Raw Data!C2:C100, TEXT(Raw Data!A2:A100, \"MM\"), \"03\")","v":null},{"$f":"COUNTIFS(TEXT(Raw Data!A2:A100,\"MM\"),\"03\")","v":null},{"$f":"IF(COUNTIFS(TEXT(Raw Data!A2:A100,\"MM\"),\"03\", Raw Data!F2:F100,1)=0,0, COUNTIFS(TEXT(Raw Data!A2:A100,\"MM\"),\"03\", Raw Data!F2:F100,1)/COUNTIFS(TEXT(Raw Data!A2:A100,\"MM\"),\"03\", Raw Data!G2:G100,1))","v":null},{"$f":"100 - C4","v":null},{"$f":"IF(COUNTIFS(TEXT(Raw Data!A2:A100,\"MM\"),\"03\", Raw Data!G2:G100,1)=0,0, COUNTIFS(TEXT(Raw Data!A2:A100,\"MM\"),\"03\", Raw Data!F2:F100,1)/COUNTIFS(TEXT(Raw Data!A2:A100,\"MM\"),\"03\", Raw Data!G2:G100,1))","v":null}]

{"sheet":"Dashboard","index":2,"n_rows":0,"n_cols":0,"rows_kept":0}