{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Foglio Presenze"],"not_rendered":{"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"Foglio Presenze","index":0,"n_rows":22,"n_cols":8,"rows_kept":22,"merged":[[1,1,1,4],[2,1,2,4]]}
[]
[null,"FOGLIO PRESENZE"]
[null,"Nome società",{"$nulls":5}," "]
[]
[null,"Dati del dipendente",null,null,"Dati del manager"]
[null,"Immettere il nome del dipendente",null,null,"Immettere il nome del manager"]
[null,"Immettere il numero di telefono del dipendente",null,null,"Immettere il numero di telefono del manager"]
[null,"Totale ore settimana lavorativa",null,null,"Totale ore lavorate"]
[null,40,null,null,{"$f":"SUM(Table_Timesheet[Ore lavorate])","v":{"v":0,"d":"0.00"}}]
[null,"Ore straordinario",null,null,"Ore regolari"]
[null,{"$f":"Totaleorelavorate-Orenormali","v":{"v":0,"d":"0.00"}},null,null,{"$f":"IF(Totaleorelavorate<=WorkWeekHours,Totaleorelavorate,WorkWeekHours)","v":{"v":0,"d":"0.00"}}]
[null,"Periodo del foglio presenze"]
[null,"Inizio periodo",null,null,"Fine periodo"]
[null,"Immettere la data di inizio",null,null,"Immettere la data di fine"]
[null,"Data","Ora entrata","Inizio pausa","Fine pausa","Ora uscita","Ore lavorate"]
[{"$nulls":6},{"$f":"IFERROR(IF(COUNT(Table_Timesheet[[#This Row],[Ora entrata]:[Ora uscita]])=4,(IF(Table_Timesheet[[#This Row],[Ora uscita]]<Table_Timesheet[[#This Row],[Ora entrata]],1,0)+Table_Timesheet[[#This Row],[Ora uscita]])-Table_Timesheet[[#This Row],[Fine pausa]]+Table_Timesheet[[#This Row],[Inizio pausa]]-Table_Timesheet[[#This Row],[Ora entrata]],IF(AND(LEN(Table_Timesheet[[#This Row],[Ora entrata]])<>0,LEN(Table_Timesheet[[#This Row],[Ora uscita]])<>0),(IF(Table_Timesheet[[#This Row],[Ora uscita]]<Table_Timesheet[[#This Row],[Ora entrata]],1,0)+Table_Timesheet[[#This Row],[Ora uscita]])-Table_Timesheet[[#This Row],[Ora entrata]],0))*24,0)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":6},{"$f":"IFERROR(IF(COUNT(Table_Timesheet[[#This Row],[Ora entrata]:[Ora uscita]])=4,(IF(Table_Timesheet[[#This Row],[Ora uscita]]<Table_Timesheet[[#This Row],[Ora entrata]],1,0)+Table_Timesheet[[#This Row],[Ora uscita]])-Table_Timesheet[[#This Row],[Fine pausa]]+Table_Timesheet[[#This Row],[Inizio pausa]]-Table_Timesheet[[#This Row],[Ora entrata]],IF(AND(LEN(Table_Timesheet[[#This Row],[Ora entrata]])<>0,LEN(Table_Timesheet[[#This Row],[Ora uscita]])<>0),(IF(Table_Timesheet[[#This Row],[Ora uscita]]<Table_Timesheet[[#This Row],[Ora entrata]],1,0)+Table_Timesheet[[#This Row],[Ora uscita]])-Table_Timesheet[[#This Row],[Ora entrata]],0))*24,0)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":6},{"$f":"IFERROR(IF(COUNT(Table_Timesheet[[#This Row],[Ora entrata]:[Ora uscita]])=4,(IF(Table_Timesheet[[#This Row],[Ora uscita]]<Table_Timesheet[[#This Row],[Ora entrata]],1,0)+Table_Timesheet[[#This Row],[Ora uscita]])-Table_Timesheet[[#This Row],[Fine pausa]]+Table_Timesheet[[#This Row],[Inizio pausa]]-Table_Timesheet[[#This Row],[Ora entrata]],IF(AND(LEN(Table_Timesheet[[#This Row],[Ora entrata]])<>0,LEN(Table_Timesheet[[#This Row],[Ora uscita]])<>0),(IF(Table_Timesheet[[#This Row],[Ora uscita]]<Table_Timesheet[[#This Row],[Ora entrata]],1,0)+Table_Timesheet[[#This Row],[Ora uscita]])-Table_Timesheet[[#This Row],[Ora entrata]],0))*24,0)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":6},{"$f":"IFERROR(IF(COUNT(Table_Timesheet[[#This Row],[Ora entrata]:[Ora uscita]])=4,(IF(Table_Timesheet[[#This Row],[Ora uscita]]<Table_Timesheet[[#This Row],[Ora entrata]],1,0)+Table_Timesheet[[#This Row],[Ora uscita]])-Table_Timesheet[[#This Row],[Fine pausa]]+Table_Timesheet[[#This Row],[Inizio pausa]]-Table_Timesheet[[#This Row],[Ora entrata]],IF(AND(LEN(Table_Timesheet[[#This Row],[Ora entrata]])<>0,LEN(Table_Timesheet[[#This Row],[Ora uscita]])<>0),(IF(Table_Timesheet[[#This Row],[Ora uscita]]<Table_Timesheet[[#This Row],[Ora entrata]],1,0)+Table_Timesheet[[#This Row],[Ora uscita]])-Table_Timesheet[[#This Row],[Ora entrata]],0))*24,0)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":6},{"$f":"IFERROR(IF(COUNT(Table_Timesheet[[#This Row],[Ora entrata]:[Ora uscita]])=4,(IF(Table_Timesheet[[#This Row],[Ora uscita]]<Table_Timesheet[[#This Row],[Ora entrata]],1,0)+Table_Timesheet[[#This Row],[Ora uscita]])-Table_Timesheet[[#This Row],[Fine pausa]]+Table_Timesheet[[#This Row],[Inizio pausa]]-Table_Timesheet[[#This Row],[Ora entrata]],IF(AND(LEN(Table_Timesheet[[#This Row],[Ora entrata]])<>0,LEN(Table_Timesheet[[#This Row],[Ora uscita]])<>0),(IF(Table_Timesheet[[#This Row],[Ora uscita]]<Table_Timesheet[[#This Row],[Ora entrata]],1,0)+Table_Timesheet[[#This Row],[Ora uscita]])-Table_Timesheet[[#This Row],[Ora entrata]],0))*24,0)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":6},{"$f":"IFERROR(IF(COUNT(Table_Timesheet[[#This Row],[Ora entrata]:[Ora uscita]])=4,(IF(Table_Timesheet[[#This Row],[Ora uscita]]<Table_Timesheet[[#This Row],[Ora entrata]],1,0)+Table_Timesheet[[#This Row],[Ora uscita]])-Table_Timesheet[[#This Row],[Fine pausa]]+Table_Timesheet[[#This Row],[Inizio pausa]]-Table_Timesheet[[#This Row],[Ora entrata]],IF(AND(LEN(Table_Timesheet[[#This Row],[Ora entrata]])<>0,LEN(Table_Timesheet[[#This Row],[Ora uscita]])<>0),(IF(Table_Timesheet[[#This Row],[Ora uscita]]<Table_Timesheet[[#This Row],[Ora entrata]],1,0)+Table_Timesheet[[#This Row],[Ora uscita]])-Table_Timesheet[[#This Row],[Ora entrata]],0))*24,0)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":6},{"$f":"IFERROR(IF(COUNT(Table_Timesheet[[#This Row],[Ora entrata]:[Ora uscita]])=4,(IF(Table_Timesheet[[#This Row],[Ora uscita]]<Table_Timesheet[[#This Row],[Ora entrata]],1,0)+Table_Timesheet[[#This Row],[Ora uscita]])-Table_Timesheet[[#This Row],[Fine pausa]]+Table_Timesheet[[#This Row],[Inizio pausa]]-Table_Timesheet[[#This Row],[Ora entrata]],IF(AND(LEN(Table_Timesheet[[#This Row],[Ora entrata]])<>0,LEN(Table_Timesheet[[#This Row],[Ora uscita]])<>0),(IF(Table_Timesheet[[#This Row],[Ora uscita]]<Table_Timesheet[[#This Row],[Ora entrata]],1,0)+Table_Timesheet[[#This Row],[Ora uscita]])-Table_Timesheet[[#This Row],[Ora entrata]],0))*24,0)","v":{"v":0,"d":"0.00"}}]