{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Menù Principale","Gennaio","Febbraio","Marzo","Aprile","Maggio","Giugno","Luglio","Agosto","Settembre","Ottobre","Novembre","Dicembre","Riepilogo"],"not_rendered":{"charts":1,"images":2,"macros":1,"external_links":0,"defined_names":26,"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":"Menù Principale","index":0,"n_rows":25,"n_cols":6,"rows_kept":25,"cut":false,"hidden":false,"merged":[[2,0,2,4],[24,0,24,5]]}
["Gestione  Ore  Anno",null,null,null,null,2020]
[]
["Personale:",null,null,null,null,"Il tuo nome"]
[]
[null,null,null,null,"MENU PRINCIPALE"]
[]
[null,null,null,null,"▪","Gennaio"]
[null,null,null,null,"▪","Febbraio"]
[null,null,null,null,"▪","Marzo"]
[null,null,null,null,"▪","Aprile"]
[null,null,null,null,"▪","Maggio"]
[null,null,null,null,"▪","Giugno"]
[null,null,null,null,"▪","Luglio"]
[null,null,null,null,"▪","Agosto"]
[null,null,null,null,"▪","Settembre"]
[null,null,null,null,"▪","Ottobre"]
[null,null,null,null,"▪","Novembre"]
[null,null,null,null,"▪","Dicembre"]
[]
["Orario giornaliero",null,"08:00:00",null,"▪","Riepilogo & Statistiche"]
[]
[]
[]
[]
["made by Massimo Sgambato SeoBox"]

{"sheet":"Gennaio","index":1,"n_rows":40,"n_cols":11,"rows_kept":40,"cut":false,"hidden":false,"merged":[[44,0,44,6],[43,0,43,6],[40,0,40,4],[41,0,41,4],[0,2,0,6],[3,6,4,6],[2,2,2,3],[3,0,4,0],[3,2,3,5]]}
[null,null,"Prospetto di lavoro:",null,null,null,null,null,null,null,{"$f":"Nome","v":"Il tuo nome"}]
[null,null,null,null,null,"Mese:",{"$f":"'Menù Principale'!F7","v":"Gennaio"}]
[null,null,null,null,"Totale ore Giornaliere*",null,{"$f":"OrarioGiornaliero","v":0.33333333333333331}]
["Data",null,"Ore",null,null,null,"Totale"]
[null,null,"Arrivo","Uscita","Arrivo","Uscita",null,"Esuberi","Condizione di esubero","Ore Seriali","Descrizione Attività"]
["01/01/2020",{"$f":"WEEKDAY(A6,2)","v":3},null,null,null,null,{"$f":"IF((D6-C6)+(F6-E6)=0,0,(D6-C6)+(F6-E6))","v":0},{"$f":"IF(B6>5,G6,IF(G6=0,0,IF(G6=OrarioDiLavoro,0,IF(G6>OrarioDiLavoro,G6-OrarioDiLavoro,OrarioDiLavoro-G6))))","v":"00:00:00"},1,{"$f":"G6","v":0}]
["02/01/2020",{"$f":"WEEKDAY(A7,2)","v":4},null,null,null,null,{"$f":"(D7-C7)+(F7-E7)","v":0},"00:00:00",{"$f":"IF(AND(OR(B7=6,B7=7),C7=\"\"),IF(OR(B7=6,B7=7),1),IF(G7>OrarioDiLavoro,-1,0))","v":0},{"$f":"G7","v":0}]
["03/01/2020",5,null,null,null,null,0,"00:00:00",0,0]
["04/01/2020",6,null,null,null,null,0,"00:00:00",1,0]
["05/01/2020",7,null,null,null,null,0,"00:00:00",1,0]
["06/01/2020",1,null,null,null,null,0,"00:00:00",1,0]
["07/01/2020",2,null,null,null,null,0,"00:00:00",0,0]
["08/01/2020",3,null,null,null,null,0,"00:00:00",0,0]
["09/01/2020",4,null,null,null,null,0,"00:00:00",0,0]
["10/01/2020",5,null,null,null,null,0,"00:00:00",0,0]
["11/01/2020",6,null,null,null,null,0,"00:00:00",1,0]
["12/01/2020",7,null,null,null,null,0,"00:00:00",1,0]
["13/01/2020",1,null,null,null,null,0,"00:00:00",0,0]
["14/01/2020",2,null,null,null,null,0,"00:00:00",0,0]
["15/01/2020",3,null,null,null,null,0,"00:00:00",0,0]
["16/01/2020",4,null,null,null,null,0,"00:00:00",0,0]
["17/01/2020",5,null,null,null,null,0,"00:00:00",0,0]
["18/01/2020",6,null,null,null,null,0,"00:00:00",1,0]
["19/01/2020",7,null,null,null,null,0,"00:00:00",1,0]
["20/01/2020",1,null,null,null,null,0,"00:00:00",0,0]
["21/01/2020",2,null,null,null,null,0,"00:00:00",0,0]
["22/01/2020",3,null,null,null,null,0,"00:00:00",0,0]
["23/01/2020",4,null,null,null,null,0,"00:00:00",0,0]
["24/01/2020",5,null,null,null,null,0,"00:00:00",0,0]
["25/01/2020",6,null,null,null,null,0,"00:00:00",1,0]
["26/01/2020",7,null,null,null,null,0,"00:00:00",1,0]
["27/01/2020",1,null,null,null,null,0,"00:00:00",0,0]
["28/01/2020",2,null,null,null,null,0,"00:00:00",0,0]
["29/01/2020",3,null,null,null,null,0,"00:00:00",0,0]
["30/01/2020",4,null,null,null,null,0,"00:00:00",0,0]
["31/01/2020",5,null,null,null,null,0,"00:00:00",0,0]
[null,null,"Totale Ore",null,null,null,{"$f":"SUM(G6:G36)","v":0},null,null,0]
[null,null,"Ore In esubero",null,null,null,{"$f":"SUMIF(I6:I36,-1,H6:H36)","v":0},null,null,0]
[null,null,"Ore Mancanti",null,null,null,{"$f":"SUMIF(I6:I36,0,H6:H36)","v":0},null,null,0]
[null,null,"Esubero",null,null,null,{"$f":"(IF(J40<0, 0,J40))","v":0},{"$f":"IF(G38>G39,G38-G39,0)","v":0},null,{"$f":"H40","v":0}]

{"sheet":"Febbraio","index":2,"n_rows":40,"n_cols":11,"rows_kept":40,"cut":false,"hidden":false,"merged":[[44,0,44,6],[43,0,43,6],[0,2,0,6],[3,6,4,6],[2,2,2,3],[3,0,4,0],[3,2,3,5]]}
[null,null,{"$f":"Gennaio!C1","v":"Prospetto di lavoro:"},null,null,null,null,null,null,null,{"$f":"'Menù Principale'!F3","v":"Il tuo nome"}]
[null,null,null,null,null,"Mese:",{"$f":"'Menù Principale'!F8","v":"Febbraio"}]
[null,null,null,null,"Totale ore Giornaliere",null,{"$f":"OrarioGiornaliero","v":0.33333333333333331}]
["Data",null,"Ore",null,null,null,"Totale"]
[null,null,"Arrivo","Uscita","Arrivo","Uscita",null,"Esuberi","Condizione di esubero","Ore Seriali","Descrizione Attività"]
["01/02/2017",{"$f":"WEEKDAY(A6,2)","v":3},null,null,null,null,{"$f":"IF((D6-C6)+(F6-E6)=0,0,(D6-C6)+(F6-E6))","v":0},{"$f":"IF(B6>5,G6,IF(G6=0,0,IF(G6=OrarioDiLavoro,0,IF(G6>OrarioDiLavoro,G6-OrarioDiLavoro,OrarioDiLavoro-G6))))","v":"00:00:00"},{"$f":"IF(AND(OR(B6=6,B6=7),C6=\"\"),IF(OR(B6=6,B6=7),1),IF(G6>OrarioDiLavoro,-1,0))","v":0},{"$f":"G6","v":0}]
["02/02/2017",4,null,null,null,null,{"$f":"(D7-C7)+(F7-E7)","v":0},"00:00:00",0,0]
["03/02/2017",5,null,null,null,null,0,"00:00:00",0,0]
["04/02/2017",6,null,null,null,null,0,"00:00:00",1,0]
["05/02/2017",7,null,null,null,null,0,"00:00:00",1,0]
["06/02/2017",1,null,null,null,null,0,"00:00:00",0,0]
["07/02/2017",2,null,null,null,null,0,"00:00:00",0,0]
["08/02/2017",3,null,null,null,null,0,"00:00:00",0,0]
["09/02/2017",4,null,null,null,null,0,"00:00:00",0,0]
["10/02/2017",5,null,null,null,null,0,"00:00:00",0,0]
["11/02/2017",6,null,null,null,null,0,"00:00:00",1,0]
["12/02/2017",7,null,null,null,null,0,"00:00:00",1,0]
["13/02/2017",1,null,null,null,null,0,"00:00:00",0,0]
["14/02/2017",2,null,null,null,null,0,"00:00:00",0,0]
["15/02/2017",3,null,null,null,null,0,"00:00:00",0,0]
["16/02/2017",4,null,null,null,null,0,"00:00:00",0,0]
["17/02/2017",5,null,null,null,null,0,"00:00:00",0,0]
["18/02/2017",6,null,null,null,null,0,"00:00:00",1,0]
["19/02/2017",7,null,null,null,null,0,"00:00:00",1,0]
["20/02/2017",1,null,null,null,null,0,"00:00:00",0,0]
["21/02/2017",2,null,null,null,null,0,"00:00:00",0,0]
["22/02/2017",3,null,null,null,null,0,"00:00:00",0,0]
["23/02/2017",4,null,null,null,null,0,"00:00:00",0,0]
["24/02/2017",5,null,null,null,null,0,"00:00:00",0,0]
["25/02/2017",6,null,null,null,null,0,"00:00:00",1,0]
["26/02/2017",7,null,null,null,null,0,"00:00:00",1,0]
["27/02/2017",1,null,null,null,null,0,"00:00:00",0,0]
["28/02/2017",2,null,null,null,null,0,"00:00:00",0,0]
[null,6,null,null,null,null,0,"00:00:00",1,0]
[null,6,null,null,null,null,0,"00:00:00",1,0]
[null,6,null,null,null,null,0,"00:00:00",1,0]
[null,null,"Totale Ore",null,null,null,{"$f":"SUM(G6:G36)","v":0},null,null,0]
[null,null,"Ore In esubero",null,null,null,{"$f":"SUMIF(I6:I36,-1,H6:H36)","v":0},null,null,0]
[null,null,"Ore Mancanti",null,null,null,{"$f":"SUMIF(I6:I36,0,H6:H36)","v":0},null,null,0]
[null,null,{"$f":"Gennaio!C40","v":"Esubero"},null,null,null,{"$f":"(IF(J40<0, 0,J40))","v":0},{"$f":"IF(G38>G39,G38-G39,0)","v":0},null,{"$f":"H40","v":0}]

{"sheet":"Marzo","index":3,"n_rows":50,"n_cols":11,"rows_kept":50,"cut":false,"hidden":false,"merged":[[44,0,44,6],[43,0,43,6],[0,2,0,6],[3,6,4,6],[2,2,2,3],[3,0,4,0],[3,2,3,5]]}
[null,null,{"$f":"Gennaio!C1","v":"Prospetto di lavoro:"},null,null,null,null,null,null,null,{"$f":"'Menù Principale'!F3","v":"Il tuo nome"}]
[null,null,null,null,null,"Mese:",{"$f":"'Menù Principale'!F9","v":"Marzo"}]
[null,null,null,null,"Totale ore Giornaliere",null,{"$f":"OrarioGiornaliero","v":0.33333333333333331}]
["Data",null,"Ore",null,null,null,"Totale"]
[null,null,"Arrivo","Uscita","Arrivo","Uscita",null,"Esuberi","Condizione di esubero","Ore Seriali","Descrizione Attività"]
["01/03/2017",{"$f":"WEEKDAY(A6,2)","v":3},null,null,null,null,{"$f":"IF((D6-C6)+(F6-E6)=0,0,(D6-C6)+(F6-E6))","v":0},{"$f":"IF(B6>5,G6,IF(G6=0,0,IF(G6=OrarioDiLavoro,0,IF(G6>OrarioDiLavoro,G6-OrarioDiLavoro,OrarioDiLavoro-G6))))","v":"00:00:00"},{"$f":"IF(AND(OR(B6=6,B6=7),C6=\"\"),IF(OR(B6=6,B6=7),1),IF(G6>OrarioDiLavoro,-1,0))","v":0},{"$f":"G6","v":0}]
["02/03/2017",4,null,null,null,null,{"$f":"(D7-C7)+(F7-E7)","v":0},"00:00:00",0,0]
["03/03/2017",5,null,null,null,null,0,"00:00:00",0,0]
["04/03/2017",6,null,null,null,null,0,"00:00:00",1,0]
["05/03/2017",7,null,null,null,null,0,"00:00:00",1,0]
["06/03/2017",1,null,null,null,null,0,"00:00:00",0,0]
["07/03/2017",2,null,null,null,null,0,"00:00:00",0,0]
["08/03/2017",3,null,null,null,null,0,"00:00:00",0,0]
["09/03/2017",4,null,null,null,null,0,"00:00:00",0,0]
["10/03/2017",5,null,null,null,null,0,"00:00:00",0,0]
["11/03/2017",6,null,null,null,null,0,"00:00:00",1,0]
["12/03/2017",7,null,null,null,null,0,"00:00:00",1,0]
["13/03/2017",1,null,null,null,null,0,"00:00:00",0,0]
["14/03/2017",2,null,null,null,null,0,"00:00:00",0,0]
["15/03/2017",3,null,null,null,null,0,"00:00:00",0,0]
["16/03/2017",4,null,null,null,null,0,"00:00:00",0,0]
["17/03/2017",5,null,null,null,null,0,"00:00:00",0,0]
["18/03/2017",6,null,null,null,null,0,"00:00:00",1,0]
["19/03/2017",7,null,null,null,null,0,"00:00:00",1,0]
["20/03/2017",1,null,null,null,null,0,"00:00:00",0,0]
["21/03/2017",2,null,null,null,null,0,"00:00:00",0,0]
["22/03/2017",3,null,null,null,null,0,"00:00:00",0,0]
["23/03/2017",4,null,null,null,null,0,"00:00:00",0,0]
["24/03/2017",5,null,null,null,null,0,"00:00:00",0,0]
["25/03/2017",6,null,null,null,null,0,"00:00:00",1,0]
["26/03/2017",7,null,null,null,null,0,"00:00:00",1,0]
["27/03/2017",1,null,null,null,null,0,"00:00:00",0,0]
["28/03/2017",2,null,null,null,null,0,"00:00:00",0,0]
["29/03/2017",3,null,null,null,null,0,"00:00:00",0,0]
["30/03/2017",4,null,null,null,null,0,"00:00:00",0,0]
["31/03/2017",5,null,null,null,null,0,"00:00:00",0,0]
[null,null,"Totale Ore",null,null,null,{"$f":"SUM(G6:G36)","v":0},null,null,0]
[null,null,"Ore In esubero",null,null,null,{"$f":"SUMIF(I6:I36,-1,H6:H36)","v":0},null,null,0]
[null,null,"Ore Mancanti",null,null,null,{"$f":"SUMIF(I6:I36,0,H6:H36)","v":0},null,null,0]
[null,null,{"$f":"Gennaio!C40","v":"Esubero"},null,null,null,{"$f":"(IF(J40<0, 0,J40))","v":0},{"$f":"IF(G38>G39,G38-G39,0)","v":0},null,{"$f":"H40","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"IF(B36>5,G36,IF(G36>OrarioDiLavoro,G36-OrarioDiLavoro,OrarioDiLavoro-G36))","v":"08:00:00"},{"$f":"IF(AND(OR(B36=6,B36=7),C36=\"\"),IF(OR(B36=6,B36=7),1),IF(G36>OrarioDiLavoro,-1,0))","v":0}]

{"sheet":"Aprile","index":4,"n_rows":40,"n_cols":11,"rows_kept":40,"cut":false,"hidden":false,"merged":[[43,0,43,6],[0,2,0,6],[3,6,4,6],[2,2,2,3],[3,0,4,0],[3,2,3,5]]}
[null,null,{"$f":"Gennaio!C1","v":"Prospetto di lavoro:"},null,null,null,null,null,null,null,{"$f":"'Menù Principale'!F3","v":"Il tuo nome"}]
[null,null,null,null,null,"Mese:",{"$f":"'Menù Principale'!F10","v":"Aprile"}]
[null,null,null,null,"Totale ore Giornaliere",null,{"$f":"OrarioGiornaliero","v":0.33333333333333331}]
["Data",null,"Ore",null,null,null,"Totale"]
[null,null,"Arrivo","Uscita","Arrivo","Uscita",null,"Esuberi","Condizione di esubero","Ore Seriali","Descrizione Attività"]
["01/04/2017",{"$f":"WEEKDAY(A6,2)","v":6},null,null,null,null,{"$f":"IF((D6-C6)+(F6-E6)=0,0,(D6-C6)+(F6-E6))","v":0},{"$f":"IF(B6>5,G6,IF(G6=0,0,IF(G6=OrarioDiLavoro,0,IF(G6>OrarioDiLavoro,G6-OrarioDiLavoro,OrarioDiLavoro-G6))))","v":"00:00:00"},{"$f":"IF(AND(OR(B6=6,B6=7),C6=\"\"),IF(OR(B6=6,B6=7),1),IF(G6>OrarioDiLavoro,-1,0))","v":1},{"$f":"G6","v":0}]
["02/04/2017",7,null,null,null,null,{"$f":"IF((D7-C7)+(F7-E7)=0,0,(D7-C7)+(F7-E7))","v":0},"00:00:00",1,0]
["03/04/2017",1,null,null,null,null,0,"00:00:00",0,0]
["04/04/2017",2,null,null,null,null,0,"00:00:00",0,0]
["05/04/2017",3,null,null,null,null,0,"00:00:00",0,0]
["06/04/2017",4,null,null,null,null,0,"00:00:00",0,0]
["07/04/2017",5,null,null,null,null,0,"00:00:00",0,0]
["08/04/2017",6,null,null,null,null,0,"00:00:00",1,0]
["09/04/2017",7,null,null,null,null,0,"00:00:00",1,0]
["10/04/2017",1,null,null,null,null,0,"00:00:00",0,0]
["11/04/2017",2,null,null,null,null,0,"00:00:00",0,0]
["12/04/2017",3,null,null,null,null,0,"00:00:00",0,0]
["13/04/2017",4,null,null,null,null,0,"00:00:00",0,0]
["14/04/2017",5,null,null,null,null,0,"00:00:00",0,0]
["15/04/2017",6,null,null,null,null,0,"00:00:00",1,0]
["16/04/2017",7,null,null,null,null,0,"00:00:00",1,0]
["17/04/2017",1,null,null,null,null,0,"00:00:00",1,0]
["18/04/2017",2,null,null,null,null,0,"00:00:00",0,0]
["19/04/2017",3,null,null,null,null,0,"00:00:00",0,0]
["20/04/2017",4,null,null,null,null,0,"00:00:00",0,0]
["21/04/2017",5,null,null,null,null,0,"00:00:00",0,0]
["22/04/2017",6,null,null,null,null,0,"00:00:00",1,0]
["23/04/2017",7,null,null,null,null,0,"00:00:00",1,0]
["24/04/2017",1,null,null,null,null,0,"00:00:00",0,0]
["25/04/2017",2,null,null,null,null,0,"00:00:00",1,0]
["26/04/2017",3,null,null,null,null,0,"00:00:00",0,0]
["27/04/2017",4,null,null,null,null,0,"00:00:00",0,0]
["28/04/2017",5,null,null,null,null,0,"00:00:00",0,0]
["29/04/2017",6,null,null,null,null,0,"00:00:00",1,0]
["30/04/2017",7,null,null,null,null,0,"00:00:00",1,0]
[null,6,null,null,null,null,0,"00:00:00",1,0]
[null,null,"Totale Ore",null,null,null,{"$f":"SUM(G6:G36)","v":0},null,null,0]
[null,null,"Ore In esubero",null,null,null,{"$f":"SUMIF(I6:I36,-1,H6:H36)","v":0},null,null,0]
[null,null,"Ore Mancanti",null,null,null,{"$f":"SUMIF(I6:I36,0,H6:H36)","v":0},null,null,0]
[null,null,{"$f":"Gennaio!C40","v":"Esubero"},null,null,null,{"$f":"(IF(J40<0, 0,J40))","v":0},{"$f":"IF(G38>G39,G38-G39,0)","v":0},null,{"$f":"H40","v":0}]

{"sheet":"Maggio","index":5,"n_rows":40,"n_cols":11,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,2,0,6],[3,6,4,6],[2,2,2,3],[3,0,4,0],[3,2,3,5]]}
[null,null,{"$f":"Gennaio!C1","v":"Prospetto di lavoro:"},null,null,null,null,null,null,null,{"$f":"'Menù Principale'!F3","v":"Il tuo nome"}]
[null,null,null,null,null,"Mese:",{"$f":"'Menù Principale'!F11","v":"Maggio"}]
[null,null,null,null,"Totale ore Giornaliere",null,{"$f":"OrarioGiornaliero","v":0.33333333333333331}]
["Data",null,"Ore",null,null,null,"Totale"]
[null,null,"Arrivo","Uscita","Arrivo","Uscita",null,"Esuberi","Condizione di esubero","Ore Seriali","Descrizione Attività"]
["01/05/2017",{"$f":"WEEKDAY(A6,2)","v":1},null,null,null,null,{"$f":"IF((D6-C6)+(F6-E6)=0,0,(D6-C6)+(F6-E6))","v":0},{"$f":"IF(B6>5,G6,IF(G6=0,0,IF(G6=OrarioDiLavoro,0,IF(G6>OrarioDiLavoro,G6-OrarioDiLavoro,OrarioDiLavoro-G6))))","v":"00:00:00"},1,{"$f":"G6","v":0}]
["02/05/2017",2,null,null,null,null,{"$f":"(D7-C7)+(F7-E7)","v":0},"00:00:00",{"$f":"IF(AND(OR(B7=6,B7=7),C7=\"\"),IF(OR(B7=6,B7=7),1),IF(G7>OrarioDiLavoro,-1,0))","v":0},0]
["03/05/2017",3,null,null,null,null,0,"00:00:00",0,0]
["04/05/2017",4,null,null,null,null,0,"00:00:00",0,0]
["05/05/2017",5,null,null,null,null,0,"00:00:00",0,0]
["06/05/2017",6,null,null,null,null,0,"00:00:00",1,0]
["07/05/2017",7,null,null,null,null,0,"00:00:00",1,0]
["08/05/2017",1,null,null,null,null,0,"00:00:00",0,0]
["09/05/2017",2,null,null,null,null,0,"00:00:00",0,0]
["10/05/2017",3,null,null,null,null,0,"00:00:00",0,0]
["11/05/2017",4,null,null,null,null,0,"00:00:00",0,0]
["12/05/2017",5,null,null,null,null,0,"00:00:00",0,0]
["13/05/2017",6,null,null,null,null,0,"00:00:00",1,0]
["14/05/2017",7,null,null,null,null,0,"00:00:00",1,0]
["15/05/2017",1,null,null,null,null,0,"00:00:00",0,0]
["16/05/2017",2,null,null,null,null,0,"00:00:00",0,0]
["17/05/2017",3,null,null,null,null,0,"00:00:00",0,0]
["18/05/2017",4,null,null,null,null,0,"00:00:00",0,0]
["19/05/2017",5,null,null,null,null,0,"00:00:00",0,0]
["20/05/2017",6,null,null,null,null,0,"00:00:00",1,0]
["21/05/2017",7,null,null,null,null,0,"00:00:00",1,0]
["22/05/2017",1,null,null,null,null,0,"00:00:00",0,0]
["23/05/2017",2,null,null,null,null,0,"00:00:00",0,0]
["24/05/2017",3,null,null,null,null,0,"00:00:00",0,0]
["25/05/2017",4,null,null,null,null,0,"00:00:00",0,0]
["26/05/2017",5,null,null,null,null,0,"00:00:00",0,0]
["27/05/2017",6,null,null,null,null,0,"00:00:00",1,0]
["28/05/2017",7,null,null,null,null,0,"00:00:00",1,0]
["29/05/2017",1,null,null,null,null,0,"00:00:00",0,0]
["30/05/2017",2,null,null,null,null,0,"00:00:00",0,0]
["31/05/2017",3,null,null,null,null,0,"00:00:00",0,0]
[null,null,"Totale Ore",null,null,null,{"$f":"SUM(G6:G36)","v":0},null,null,0]
[null,null,"Ore In esubero",null,null,null,{"$f":"SUMIF(I6:I36,-1,H6:H36)","v":0},null,null,0]
[null,null,"Ore Mancanti",null,null,null,{"$f":"SUMIF(I6:I36,0,H6:H36)","v":0},null,null,0]
[null,null,{"$f":"Gennaio!C40","v":"Esubero"},null,null,null,{"$f":"(IF(J40<0, 0,J40))","v":0},{"$f":"IF(G38>G39,G38-G39,0)","v":0},null,{"$f":"H40","v":0}]

{"sheet":"Giugno","index":6,"n_rows":40,"n_cols":11,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,2,0,6],[3,6,4,6],[2,2,2,3],[3,0,4,0],[3,2,3,5]]}
[null,null,{"$f":"Gennaio!C1","v":"Prospetto di lavoro:"},null,null,null,null,null,null,null,{"$f":"'Menù Principale'!F3","v":"Il tuo nome"}]
[null,null,null,null,null,"Mese:",{"$f":"'Menù Principale'!F12","v":"Giugno"}]
[null,null,null,null,"Totale ore Giornaliere",null,{"$f":"OrarioGiornaliero","v":0.33333333333333331}]
["Data",null,"Ore",null,null,null,"Totale"]
[null,null,"Arrivo","Uscita","Arrivo","Uscita",null,"Esuberi","Condizione di esubero","Ore Seriali","Descrizione Attività"]
["01/06/2017",{"$f":"WEEKDAY(A6,2)","v":4},null,null,null,null,{"$f":"IF((D6-C6)+(F6-E6)=0,0,(D6-C6)+(F6-E6))","v":0},{"$f":"IF(B6>5,G6,IF(G6=0,0,IF(G6=OrarioDiLavoro,0,IF(G6>OrarioDiLavoro,G6-OrarioDiLavoro,OrarioDiLavoro-G6))))","v":"00:00:00"},{"$f":"IF(AND(OR(B6=6,B6=7),C6=\"\"),IF(OR(B6=6,B6=7),1),IF(G6>OrarioDiLavoro,-1,0))","v":0},{"$f":"G6","v":0}]
["02/06/2017",5,null,null,null,null,{"$f":"(D7-C7)+(F7-E7)","v":0},"00:00:00",0,0]
["03/06/2017",6,null,null,null,null,0,"00:00:00",1,0]
["04/06/2017",7,null,null,null,null,0,"00:00:00",1,0]
["05/06/2017",1,null,null,null,null,0,"00:00:00",0,0]
["06/06/2017",2,null,null,null,null,0,"00:00:00",0,0]
["07/06/2017",3,null,null,null,null,0,"00:00:00",0,0]
["08/06/2017",4,null,null,null,null,0,"00:00:00",0,0]
["09/06/2017",5,null,null,null,null,0,"00:00:00",0,0]
["10/06/2017",6,null,null,null,null,0,"00:00:00",1,0]
["11/06/2017",7,null,null,null,null,0,"00:00:00",1,0]
["12/06/2017",1,null,null,null,null,0,"00:00:00",0,0]
["13/06/2017",2,null,null,null,null,0,"00:00:00",0,0]
["14/06/2017",3,null,null,null,null,0,"00:00:00",0,0]
["15/06/2017",4,null,null,null,null,0,"00:00:00",0,0]
["16/06/2017",5,null,null,null,null,0,"00:00:00",0,0]
["17/06/2017",6,null,null,null,null,0,"00:00:00",1,0]
["18/06/2017",7,null,null,null,null,0,"00:00:00",1,0]
["19/06/2017",1,null,null,null,null,0,"00:00:00",0,0]
["20/06/2017",2,null,null,null,null,0,"00:00:00",0,0]
["21/06/2017",3,null,null,null,null,0,"00:00:00",0,0]
["22/06/2017",4,null,null,null,null,0,"00:00:00",0,0]
["23/06/2017",5,null,null,null,null,0,"00:00:00",0,0]
["24/06/2017",6,null,null,null,null,0,"00:00:00",1,0]
["25/06/2017",7,null,null,null,null,0,"00:00:00",1,0]
["26/06/2017",1,null,null,null,null,0,"00:00:00",0,0]
["27/06/2017",2,null,null,null,null,0,"00:00:00",0,0]
["28/06/2017",3,null,null,null,null,0,"00:00:00",0,0]
["29/06/2017",4,null,null,null,null,0,"00:00:00",0,0]
["30/06/2017",5,null,null,null,null,0,"00:00:00",0,0]
[null,6,null,null,null,null,0,"00:00:00",1,0]
[null,null,"Totale Ore",null,null,null,{"$f":"SUM(G6:G36)","v":0},null,null,0]
[null,null,"Ore In esubero",null,null,null,{"$f":"SUMIF(I6:I36,-1,H6:H36)","v":0},null,null,0]
[null,null,"Ore Mancanti",null,null,null,{"$f":"SUMIF(I6:I36,0,H6:H36)","v":0},null,null,0]
[null,null,{"$f":"Gennaio!C40","v":"Esubero"},null,null,null,{"$f":"(IF(J40<0, 0,J40))","v":0},{"$f":"IF(G38>G39,G38-G39,0)","v":0},null,{"$f":"H40","v":0}]

{"sheet":"Luglio","index":7,"n_rows":40,"n_cols":11,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,2,0,6],[3,6,4,6],[2,2,2,3],[3,0,4,0],[3,2,3,5]]}
[null,null,{"$f":"Gennaio!C1","v":"Prospetto di lavoro:"},null,null,null,null,null,null,null,{"$f":"'Menù Principale'!F3","v":"Il tuo nome"}]
[null,null,null,null,null,"Mese:",{"$f":"'Menù Principale'!F13","v":"Luglio"}]
[null,null,null,null,"Totale ore Giornaliere",null,{"$f":"OrarioGiornaliero","v":0.33333333333333331}]
["Data",null,"Ore",null,null,null,"Totale"]
[null,null,"Arrivo","Uscita","Arrivo","Uscita",null,"Esuberi","Condizione di esubero","Ore Seriali","Descrizione Attività"]
["01/07/2017",{"$f":"WEEKDAY(A6,2)","v":6},null,null,null,null,{"$f":"IF((D6-C6)+(F6-E6)=0,0,(D6-C6)+(F6-E6))","v":0},{"$f":"IF(B6>5,G6,IF(G6=0,0,IF(G6=OrarioDiLavoro,0,IF(G6>OrarioDiLavoro,G6-OrarioDiLavoro,OrarioDiLavoro-G6))))","v":"00:00:00"},{"$f":"IF(AND(OR(B6=6,B6=7),C6=\"\"),IF(OR(B6=6,B6=7),1),IF(G6>OrarioDiLavoro,-1,0))","v":1},{"$f":"G6","v":0}]
["02/07/2017",7,null,null,null,null,{"$f":"(D7-C7)+(F7-E7)","v":0},"00:00:00",1,0]
["03/07/2017",1,null,null,null,null,0,"00:00:00",0,0]
["04/07/2017",2,null,null,null,null,0,"00:00:00",0,0]
["05/07/2017",3,null,null,null,null,0,"00:00:00",0,0]
["06/07/2017",4,null,null,null,null,0,"00:00:00",0,0]
["07/07/2017",5,null,null,null,null,0,"00:00:00",0,0]
["08/07/2017",6,null,null,null,null,0,"00:00:00",1,0]
["09/07/2017",7,null,null,null,null,0,"00:00:00",1,0]
["10/07/2017",1,null,null,null,null,0,"00:00:00",0,0]
["11/07/2017",2,null,null,null,null,0,"00:00:00",0,0]
["12/07/2017",3,null,null,null,null,0,"00:00:00",0,0]
["13/07/2017",4,null,null,null,null,0,"00:00:00",0,0]
["14/07/2017",5,null,null,null,null,0,"00:00:00",0,0]
["15/07/2017",6,null,null,null,null,0,"00:00:00",1,0]
["16/07/2017",7,null,null,null,null,0,"00:00:00",1,0]
["17/07/2017",1,null,null,null,null,0,"00:00:00",0,0]
["18/07/2017",2,null,null,null,null,0,"00:00:00",0,0]
["19/07/2017",3,null,null,null,null,0,"00:00:00",0,0]
["20/07/2017",4,null,null,null,null,0,"00:00:00",0,0]
["21/07/2017",5,null,null,null,null,0,"00:00:00",0,0]
["22/07/2017",6,null,null,null,null,0,"00:00:00",1,0]
["23/07/2017",7,null,null,null,null,0,"00:00:00",1,0]
["24/07/2017",1,null,null,null,null,0,"00:00:00",0,0]
["25/07/2017",2,null,null,null,null,0,"00:00:00",0,0]
["26/07/2017",3,null,null,null,null,0,"00:00:00",0,0]
["27/07/2017",4,null,null,null,null,0,"00:00:00",0,0]
["28/07/2017",5,null,null,null,null,0,"00:00:00",0,0]
["29/07/2017",6,null,null,null,null,0,"00:00:00",1,0]
["30/07/2017",7,null,null,null,null,0,"00:00:00",1,0]
["31/07/2017",1,null,null,null,null,0,"00:00:00",0,0]
[null,null,"Totale Ore",null,null,null,{"$f":"SUM(G6:G36)","v":0},null,null,0]
[null,null,"Ore In esubero",null,null,null,{"$f":"SUMIF(I6:I36,-1,H6:H36)","v":0},null,null,0]
[null,null,"Ore Mancanti",null,null,null,{"$f":"SUMIF(I6:I36,0,H6:H36)","v":0},null,null,0]
[null,null,{"$f":"Gennaio!C40","v":"Esubero"},null,null,null,{"$f":"(IF(J40<0, 0,J40))","v":0},{"$f":"IF(G38>G39,G38-G39,0)","v":0},null,{"$f":"H40","v":0}]

{"sheet":"Agosto","index":8,"n_rows":40,"n_cols":11,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,2,0,6],[3,6,4,6],[2,2,2,3],[3,0,4,0],[3,2,3,5]]}
[null,null,{"$f":"Gennaio!C1","v":"Prospetto di lavoro:"},null,null,null,null,null,null,null,{"$f":"'Menù Principale'!F3","v":"Il tuo nome"}]
[null,null,null,null,null,"Mese:",{"$f":"'Menù Principale'!F14","v":"Agosto"}]
[null,null,null,null,"Totale ore Giornaliere",null,{"$f":"OrarioGiornaliero","v":0.33333333333333331}]
["Data",null,"Ore",null,null,null,"Totale"]
[null,null,"Arrivo","Uscita","Arrivo","Uscita",null,"Esuberi","Condizione di esubero","Ore Seriali","Descrizione Attività"]
["01/08/2017",{"$f":"WEEKDAY(A6,2)","v":2},null,null,null,null,{"$f":"IF((D6-C6)+(F6-E6)=0,0,(D6-C6)+(F6-E6))","v":0},{"$f":"IF(B6>5,G6,IF(G6=0,0,IF(G6=OrarioDiLavoro,0,IF(G6>OrarioDiLavoro,G6-OrarioDiLavoro,OrarioDiLavoro-G6))))","v":"00:00:00"},{"$f":"IF(AND(OR(B6=6,B6=7),C6=\"\"),IF(OR(B6=6,B6=7),1),IF(G6>OrarioDiLavoro,-1,0))","v":0},{"$f":"G6","v":0}]
["02/08/2017",3,null,null,null,null,{"$f":"(D7-C7)+(F7-E7)","v":0},"00:00:00",0,0]
["03/08/2017",4,null,null,null,null,0,"00:00:00",0,0]
["04/08/2017",5,null,null,null,null,0,"00:00:00",0,0]
["05/08/2017",6,null,null,null,null,0,"00:00:00",1,0]
["06/08/2017",7,null,null,null,null,0,"00:00:00",1,0]
["07/08/2017",1,null,null,null,null,0,"00:00:00",0,0]
["08/08/2017",2,null,null,null,null,0,"00:00:00",0,0]
["09/08/2017",3,null,null,null,null,0,"00:00:00",0,0]
["10/08/2017",4,null,null,null,null,0,"00:00:00",0,0]
["11/08/2017",5,null,null,null,null,0,"00:00:00",0,0]
["12/08/2017",6,null,null,null,null,0,"00:00:00",1,0]
["13/08/2017",7,null,null,null,null,0,"00:00:00",1,0]
["14/08/2017",1,null,null,null,null,0,"00:00:00",0,0]
["15/08/2017",2,null,null,null,null,0,"00:00:00",1,0]
["16/08/2017",3,null,null,null,null,0,"00:00:00",0,0]
["17/08/2017",4,null,null,null,null,0,"00:00:00",0,0]
["18/08/2017",5,null,null,null,null,0,"00:00:00",0,0]
["19/08/2017",6,null,null,null,null,0,"00:00:00",1,0]
["20/08/2017",7,null,null,null,null,0,"00:00:00",1,0]
["21/08/2017",1,null,null,null,null,0,"00:00:00",0,0]
["22/08/2017",2,null,null,null,null,0,"00:00:00",0,0]
["23/08/2017",3,null,null,null,null,0,"00:00:00",0,0]
["24/08/2017",4,null,null,null,null,0,"00:00:00",0,0]
["25/08/2017",5,null,null,null,null,0,"00:00:00",0,0]
["26/08/2017",6,null,null,null,null,0,"00:00:00",1,0]
["27/08/2017",7,null,null,null,null,0,"00:00:00",1,0]
["28/08/2017",1,null,null,null,null,0,"00:00:00",0,0]
["29/08/2017",2,null,null,null,null,0,"00:00:00",0,0]
["30/08/2017",3,null,null,null,null,0,"00:00:00",0,0]
["31/08/2017",4,null,null,null,null,0,"00:00:00",0,0]
[null,null,"Totale Ore",null,null,null,{"$f":"SUM(G6:G36)","v":0},null,null,0]
[null,null,"Ore In esubero",null,null,null,{"$f":"SUMIF(I6:I36,-1,H6:H36)","v":0},null,null,0]
[null,null,"Ore Mancanti",null,null,null,{"$f":"SUMIF(I6:I36,0,H6:H36)","v":0},null,null,0]
[null,null,{"$f":"Gennaio!C40","v":"Esubero"},null,null,null,{"$f":"(IF(J40<0, 0,J40))","v":0},{"$f":"IF(G38>G39,G38-G39,0)","v":0},null,{"$f":"H40","v":0}]

{"sheet":"Settembre","index":9,"n_rows":40,"n_cols":11,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,2,0,6],[3,6,4,6],[2,2,2,3],[3,0,4,0],[3,2,3,5]]}
[null,null,{"$f":"Gennaio!C1","v":"Prospetto di lavoro:"},null,null,null,null,null,null,null,{"$f":"'Menù Principale'!F3","v":"Il tuo nome"}]
[null,null,null,null,null,"Mese:",{"$f":"'Menù Principale'!F15","v":"Settembre"}]
[null,null,null,null,"Totale ore Giornaliere*",null,{"$f":"OrarioGiornaliero","v":0.33333333333333331}]
["Data",null,"Ore",null,null,null,"Totale"]
[null,null,"Arrivo","Uscita","Arrivo","Uscita",null,"Esuberi","Condizione di esubero","Ore Seriali","Descrizione Attività"]
["01/09/2017",{"$f":"WEEKDAY(A6,2)","v":5},null,null,null,null,{"$f":"IF((D6-C6)+(F6-E6)=0,0,(D6-C6)+(F6-E6))","v":0},{"$f":"IF(B6>5,G6,IF(G6=0,0,IF(G6=OrarioDiLavoro,0,IF(G6>OrarioDiLavoro,G6-OrarioDiLavoro,OrarioDiLavoro-G6))))","v":"00:00:00"},{"$f":"IF(AND(OR(B6=6,B6=7),C6=\"\"),IF(OR(B6=6,B6=7),1),IF(G6>OrarioDiLavoro,-1,0))","v":0},{"$f":"G6","v":0}]
["02/09/2017",6,null,null,null,null,{"$f":"IF((D7-C7)+(F7-E7)=0,0,(D7-C7)+(F7-E7))","v":0},"00:00:00",1,0]
["03/09/2017",7,null,null,null,null,0,"00:00:00",1,0]
["04/09/2017",1,null,null,null,null,0,"00:00:00",0,0]
["05/09/2017",2,null,null,null,null,0,"00:00:00",0,0]
["06/09/2017",3,null,null,null,null,0,"00:00:00",0,0]
["07/09/2017",4,null,null,null,null,0,"00:00:00",0,0]
["08/09/2017",5,null,null,null,null,0,"00:00:00",0,0]
["09/09/2017",6,null,null,null,null,0,"00:00:00",1,0]
["10/09/2017",7,null,null,null,null,0,"00:00:00",1,0]
["11/09/2017",1,null,null,null,null,0,"00:00:00",0,0]
["12/09/2017",2,null,null,null,null,0,"00:00:00",0,0]
["13/09/2017",3,null,null,null,null,0,"00:00:00",0,0]
["14/09/2017",4,null,null,null,null,0,"00:00:00",0,0]
["15/09/2017",5,null,null,null,null,0,"00:00:00",0,0]
["16/09/2017",6,null,null,null,null,0,"00:00:00",1,0]
["17/09/2017",7,null,null,null,null,0,"00:00:00",1,0]
["18/09/2017",1,null,null,null,null,0,"00:00:00",0,0]
["19/09/2017",2,null,null,null,null,0,"00:00:00",0,0]
["20/09/2017",3,null,null,null,null,0,"00:00:00",0,0]
["21/09/2017",4,null,null,null,null,0,"00:00:00",0,0]
["22/09/2017",5,null,null,null,null,0,"00:00:00",0,0]
["23/09/2017",6,null,null,null,null,0,"00:00:00",1,0]
["24/09/2017",7,null,null,null,null,0,"00:00:00",1,0]
["25/09/2017",1,null,null,null,null,0,"00:00:00",0,0]
["26/09/2017",2,null,null,null,null,0,"00:00:00",0,0]
["27/09/2017",3,null,null,null,null,0,"00:00:00",0,0]
["28/09/2017",4,null,null,null,null,0,"00:00:00",0,0]
["29/09/2017",5,null,null,null,null,0,"00:00:00",0,0]
["30/09/2017",6,null,null,null,null,0,"00:00:00",1,0]
[null,6,null,null,null,null,null,"00:00:00",1,0]
[null,null,"Totale Ore",null,null,null,{"$f":"SUM(G6:G36)","v":0},null,null,0]
[null,null,"Ore In esubero",null,null,null,{"$f":"SUMIF(I6:I36,-1,H6:H36)","v":0},null,null,0]
[null,null,"Ore Mancanti",null,null,null,{"$f":"SUMIF(I6:I36,0,H6:H36)","v":0},null,null,0]
[null,null,{"$f":"Gennaio!C40","v":"Esubero"},null,null,null,{"$f":"(IF(J40<0, 0,J40))","v":0},{"$f":"IF(G38>G39,G38-G39,0)","v":0},null,{"$f":"H40","v":0}]

{"sheet":"Ottobre","index":10,"n_rows":40,"n_cols":11,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,2,0,6],[3,6,4,6],[2,2,2,3],[3,0,4,0],[3,2,3,5]]}
[null,null,{"$f":"Gennaio!C1","v":"Prospetto di lavoro:"},null,null,null,null,null,null,null,{"$f":"'Menù Principale'!F3","v":"Il tuo nome"}]
[null,null,null,null,null,"Mese:",{"$f":"'Menù Principale'!F16","v":"Ottobre"}]
[null,null,null,null,"Totale ore Giornaliere*",null,{"$f":"OrarioGiornaliero","v":0.33333333333333331}]
["Data",null,"Ore",null,null,null,"Totale"]
[null,null,"Arrivo","Uscita","Arrivo","Uscita",null,"Esuberi","Condizione di esubero","Ore Seriali","Descrizione Attività"]
["01/10/2017",{"$f":"WEEKDAY(A6,2)","v":7},null,null,null,null,{"$f":"IF((D6-C6)+(F6-E6)=0,0,(D6-C6)+(F6-E6))","v":0},{"$f":"IF(B6>5,G6,IF(G6=0,0,IF(G6=OrarioDiLavoro,0,IF(G6>OrarioDiLavoro,G6-OrarioDiLavoro,OrarioDiLavoro-G6))))","v":"00:00:00"},{"$f":"IF(AND(OR(B6=6,B6=7),C6=\"\"),IF(OR(B6=6,B6=7),1),IF(G6>OrarioDiLavoro,-1,0))","v":1},{"$f":"G6","v":0}]
["02/10/2017",1,null,null,null,null,{"$f":"IF((D7-C7)+(F7-E7)=0,0,(D7-C7)+(F7-E7))","v":0},"00:00:00",0,0]
["03/10/2017",2,null,null,null,null,0,"00:00:00",0,0]
["04/10/2017",3,null,null,null,null,0,"00:00:00",0,0]
["05/10/2017",4,null,null,null,null,0,"00:00:00",0,0]
["06/10/2017",5,null,null,null,null,0,"00:00:00",0,0]
["07/10/2017",6,null,null,null,null,0,"00:00:00",1,0]
["08/10/2017",7,null,null,null,null,0,"00:00:00",1,0]
["09/10/2017",1,null,null,null,null,0,"00:00:00",0,0]
["10/10/2017",2,null,null,null,null,0,"00:00:00",0,0]
["11/10/2017",3,null,null,null,null,0,"00:00:00",0,0]
["12/10/2017",4,null,null,null,null,0,"00:00:00",0,0]
["13/10/2017",5,null,null,null,null,0,"00:00:00",0,0]
["14/10/2017",6,null,null,null,null,0,"00:00:00",1,0]
["15/10/2017",7,null,null,null,null,0,"00:00:00",1,0]
["16/10/2017",1,null,null,null,null,0,"00:00:00",0,0]
["17/10/2017",2,null,null,null,null,0,"00:00:00",0,0]
["18/10/2017",3,null,null,null,null,0,"00:00:00",0,0]
["19/10/2017",4,null,null,null,null,0,"00:00:00",0,0]
["20/10/2017",5,null,null,null,null,0,"00:00:00",0,0]
["21/10/2017",6,null,null,null,null,0,"00:00:00",1,0]
["22/10/2017",7,null,null,null,null,0,"00:00:00",1,0]
["23/10/2017",1,null,null,null,null,0,"00:00:00",0,0]
["24/10/2017",2,null,null,null,null,0,"00:00:00",0,0]
["25/10/2017",3,null,null,null,null,0,"00:00:00",0,0]
["26/10/2017",4,null,null,null,null,0,"00:00:00",0,0]
["27/10/2017",5,null,null,null,null,0,"00:00:00",0,0]
["28/10/2017",6,null,null,null,null,0,"00:00:00",1,0]
["29/10/2017",7,null,null,null,null,0,"00:00:00",1,0]
["30/10/2017",1,null,null,null,null,0,"00:00:00",0,0]
["31/10/2017",2,null,null,null,null,0,"00:00:00",0,0]
[null,null,"Totale Ore",null,null,null,{"$f":"SUM(G6:G36)","v":0},null,null,0]
[null,null,"Ore In esubero",null,null,null,{"$f":"SUMIF(I6:I36,-1,H6:H36)","v":0},null,null,0]
[null,null,"Ore Mancanti",null,null,null,{"$f":"SUMIF(I6:I36,0,H6:H36)","v":0},null,null,0]
[null,null,{"$f":"Gennaio!C40","v":"Esubero"},null,null,null,{"$f":"(IF(J40<0, 0,J40))","v":0},{"$f":"IF(G38>G39,G38-G39,0)","v":0},null,{"$f":"H40","v":0}]

{"sheet":"Novembre","index":11,"n_rows":40,"n_cols":11,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,2,0,6],[3,6,4,6],[2,2,2,3],[3,0,4,0],[3,2,3,5]]}
[null,null,{"$f":"Gennaio!C1","v":"Prospetto di lavoro:"},null,null,null,null,null,null,null,{"$f":"'Menù Principale'!F3","v":"Il tuo nome"}]
[null,null,null,null,null,"Mese:",{"$f":"'Menù Principale'!F17","v":"Novembre"}]
[null,null,null,null,"Totale ore Giornaliere*",null,{"$f":"OrarioGiornaliero","v":0.33333333333333331}]
["Data",null,"Ore",null,null,null,"Totale"]
[null,null,"Arrivo","Uscita","Arrivo","Uscita",null,"Esuberi","Condizione di esubero","Ore Seriali","Descrizione Attività"]
["01/11/2017",{"$f":"WEEKDAY(A6,2)","v":3},null,null,null,null,{"$f":"IF((D6-C6)+(F6-E6)=0,0,(D6-C6)+(F6-E6))","v":0},{"$f":"IF(B6>5,G6,IF(G6=0,0,IF(G6=OrarioDiLavoro,0,IF(G6>OrarioDiLavoro,G6-OrarioDiLavoro,OrarioDiLavoro-G6))))","v":"00:00:00"},1,{"$f":"G6","v":0}]
["02/11/2017",4,null,null,null,null,{"$f":"IF((D7-C7)+(F7-E7)=0,0,(D7-C7)+(F7-E7))","v":0},"00:00:00",{"$f":"IF(AND(OR(B7=6,B7=7),C7=\"\"),IF(OR(B7=6,B7=7),1),IF(G7>OrarioDiLavoro,-1,0))","v":0},0]
["03/11/2017",5,null,null,null,null,0,"00:00:00",0,0]
["04/11/2017",6,null,null,null,null,0,"00:00:00",1,0]
["05/11/2017",7,null,null,null,null,0,"00:00:00",1,0]
["06/11/2017",1,null,null,null,null,0,"00:00:00",0,0]
["07/11/2017",2,null,null,null,null,0,"00:00:00",0,0]
["08/11/2017",3,null,null,null,null,0,"00:00:00",0,0]
["09/11/2017",4,null,null,null,null,0,"00:00:00",0,0]
["10/11/2017",5,null,null,null,null,0,"00:00:00",0,0]
["11/11/2017",6,null,null,null,null,0,"00:00:00",1,0]
["12/11/2017",7,null,null,null,null,0,"00:00:00",1,0]
["13/11/2017",1,null,null,null,null,0,"00:00:00",0,0]
["14/11/2017",2,null,null,null,null,0,"00:00:00",0,0]
["15/11/2017",3,null,null,null,null,0,"00:00:00",0,0]
["16/11/2017",4,null,null,null,null,0,"00:00:00",0,0]
["17/11/2017",5,null,null,null,null,0,"00:00:00",0,0]
["18/11/2017",6,null,null,null,null,0,"00:00:00",1,0]
["19/11/2017",7,null,null,null,null,0,"00:00:00",1,0]
["20/11/2017",1,null,null,null,null,0,"00:00:00",0,0]
["21/11/2017",2,null,null,null,null,0,"00:00:00",0,0]
["22/11/2017",3,null,null,null,null,0,"00:00:00",0,0]
["23/11/2017",4,null,null,null,null,0,"00:00:00",0,0]
["24/11/2017",5,null,null,null,null,0,"00:00:00",0,0]
["25/11/2017",6,null,null,null,null,0,"00:00:00",1,0]
["26/11/2017",7,null,null,null,null,0,"00:00:00",1,0]
["27/11/2017",1,null,null,null,null,0,"00:00:00",0,0]
["28/11/2017",2,null,null,null,null,0,"00:00:00",0,0]
["29/11/2017",3,null,null,null,null,0,"00:00:00",0,0]
["30/11/2017",4,null,null,null,null,0,"00:00:00",0,0]
[null,6,null,null,null,null,null,"00:00:00",1,0]
[null,null,"Totale Ore",null,null,null,{"$f":"SUM(G6:G36)","v":0},null,null,0]
[null,null,"Ore In esubero",null,null,null,{"$f":"SUMIF(I6:I36,-1,H6:H36)","v":0},null,null,0]
[null,null,"Ore Mancanti",null,null,null,{"$f":"SUMIF(I6:I36,0,H6:H36)","v":0},null,null,0]
[null,null,{"$f":"Gennaio!C40","v":"Esubero"},null,null,null,{"$f":"(IF(J40<0, 0,J40))","v":0},{"$f":"IF(G38>G39,G38-G39,0)","v":0},null,{"$f":"H40","v":0}]

{"sheet":"Dicembre","index":12,"n_rows":40,"n_cols":11,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,2,0,6],[3,6,4,6],[2,2,2,3],[3,0,4,0],[3,2,3,5]]}
[null,null,{"$f":"Gennaio!C1","v":"Prospetto di lavoro:"},null,null,null,null,null,null,null,{"$f":"'Menù Principale'!F3","v":"Il tuo nome"}]
[null,null,null,null,null,"Mese:",{"$f":"'Menù Principale'!F18","v":"Dicembre"}]
[null,null,null,null,"Totale ore Giornaliere",null,{"$f":"OrarioGiornaliero","v":0.33333333333333331}]
["Data",null,"Ore",null,null,null,"Totale"]
[null,null,"Arrivo","Uscita","Arrivo","Uscita",null,"Esuberi","Condizione di esubero","Ore Seriali","Descrizione Attività"]
["01/12/2017",{"$f":"WEEKDAY(A6,2)","v":5},null,null,null,null,{"$f":"IF((D6-C6)+(F6-E6)=0,0,(D6-C6)+(F6-E6))","v":0},{"$f":"IF(B6>5,G6,IF(G6=0,0,IF(G6=OrarioDiLavoro,0,IF(G6>OrarioDiLavoro,G6-OrarioDiLavoro,OrarioDiLavoro-G6))))","v":"00:00:00"},{"$f":"IF(AND(OR(B6=6,B6=7),C6=\"\"),IF(OR(B6=6,B6=7),1),IF(G6>OrarioDiLavoro,-1,0))","v":0},{"$f":"G6","v":0}]
["02/12/2017",6,null,null,null,null,{"$f":"(D7-C7)+(F7-E7)","v":0},"00:00:00",1,0]
["03/12/2017",7,null,null,null,null,0,"00:00:00",1,0]
["04/12/2017",1,null,null,null,null,0,"00:00:00",0,0]
["05/12/2017",2,null,null,null,null,0,"00:00:00",0,0]
["06/12/2017",3,null,null,null,null,0,"00:00:00",0,0]
["07/12/2017",4,null,null,null,null,0,"00:00:00",0,0]
["08/12/2017",5,null,null,null,null,0,"00:00:00",1,0]
["09/12/2017",6,null,null,null,null,0,"00:00:00",1,0]
["10/12/2017",7,null,null,null,null,0,"00:00:00",1,0]
["11/12/2017",1,null,null,null,null,0,"00:00:00",0,0]
["12/12/2017",2,null,null,null,null,0,"00:00:00",0,0]
["13/12/2017",3,null,null,null,null,0,"00:00:00",0,0]
["14/12/2017",4,null,null,null,null,0,"00:00:00",0,0]
["15/12/2017",5,null,null,null,null,0,"00:00:00",0,0]
["16/12/2017",6,null,null,null,null,0,"00:00:00",1,0]
["17/12/2017",7,null,null,null,null,0,"00:00:00",1,0]
["18/12/2017",1,null,null,null,null,0,"00:00:00",0,0]
["19/12/2017",2,null,null,null,null,0,"00:00:00",0,0]
["20/12/2017",3,null,null,null,null,0,"00:00:00",0,0]
["21/12/2017",4,null,null,null,null,0,"00:00:00",0,0]
["22/12/2017",5,null,null,null,null,0,"00:00:00",0,0]
["23/12/2017",6,null,null,null,null,0,"00:00:00",1,0]
["24/12/2017",7,null,null,null,null,0,"00:00:00",1,0]
["25/12/2017",1,null,null,null,null,0,"00:00:00",1,0]
["26/12/2017",2,null,null,null,null,0,"00:00:00",1,0]
["27/12/2017",3,null,null,null,null,0,"00:00:00",0,0]
["28/12/2017",4,null,null,null,null,0,"00:00:00",0,0]
["29/12/2017",5,null,null,null,null,0,"00:00:00",0,0]
["30/12/2017",6,null,null,null,null,0,"00:00:00",1,0]
["31/12/2017",7,null,null,null,null,0,"00:00:00",1,0]
[null,null,"Totale Ore",null,null,null,{"$f":"SUM(G6:G36)","v":0},null,null,0]
[null,null,"Ore In esubero",null,null,null,{"$f":"SUMIF(I6:I36,-1,H6:H36)","v":0},null,null,0]
[null,null,"Ore Mancanti",null,null,null,{"$f":"SUMIF(I6:I36,0,H6:H36)","v":0},null,null,0]
[null,null,{"$f":"Gennaio!C40","v":"Esubero"},null,null,null,{"$f":"(IF(J40<0, 0,J40))","v":0},{"$f":"IF(G38>G39,G38-G39,0)","v":0},null,{"$f":"H40","v":0}]

{"sheet":"Riepilogo","index":13,"n_rows":38,"n_cols":6,"rows_kept":38,"cut":false,"hidden":false,"merged":[[2,0,2,4],[2,5,2,9],[37,0,37,5]]}
["Gestione  Ore  Anno",null,null,null,{"$f":"AnnoInCorso","v":2020}]
[]
["Personale:",null,null,null,null,{"$f":"Nome","v":"Il tuo nome"}]
[]
[null,null,null,"Mese","Totale Ore"]
[null,null,null,{"$f":"'Menù Principale'!F7","v":"Gennaio"},{"$f":"Gennaio!G37","v":0}]
[null,null,null,{"$f":"'Menù Principale'!F8","v":"Febbraio"},{"$f":"Febbraio!G37","v":0}]
[null,null,null,{"$f":"'Menù Principale'!F9","v":"Marzo"},{"$f":"Marzo!G37","v":0}]
[null,null,null,{"$f":"'Menù Principale'!F10","v":"Aprile"},{"$f":"Aprile!G37","v":0}]
[null,null,null,{"$f":"'Menù Principale'!F11","v":"Maggio"},{"$f":"Maggio!G37","v":0}]
[null,null,null,{"$f":"'Menù Principale'!F12","v":"Giugno"},{"$f":"Giugno!G37","v":0}]
[null,null,null,{"$f":"'Menù Principale'!F13","v":"Luglio"},{"$f":"Luglio!G37","v":0}]
[null,null,null,{"$f":"'Menù Principale'!F14","v":"Agosto"},{"$f":"Agosto!G37","v":0}]
[null,null,null,{"$f":"'Menù Principale'!F15","v":"Settembre"},{"$f":"Settembre!G37","v":0}]
[null,null,null,{"$f":"'Menù Principale'!F16","v":"Ottobre"},{"$f":"Ottobre!G37","v":0}]
[null,null,null,{"$f":"'Menù Principale'!F17","v":"Novembre"},{"$f":"Novembre!G37","v":0}]
[null,null,null,{"$f":"'Menù Principale'!F18","v":"Dicembre"},{"$f":"Dicembre!G37","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["made by Massimo Sgambato SeoBox"]