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

{"sheet":"Foglio Presenze","index":0,"n_rows":33,"n_cols":12,"rows_kept":33,"merged":[[1,1,1,5],[1,6,1,11],[3,1,3,3],[3,6,3,7],[3,8,3,9],[4,1,4,3],[4,6,4,7],[4,8,4,9],[5,1,5,3],[5,6,5,7],[5,8,5,9],[6,1,6,3],[29,1,29,3],[30,1,30,3],[31,1,31,3],[32,1,32,3],[32,6,32,9],[32,10,32,11]]}
[]
[null,"FOGLIO PRESENZE",{"$nulls":4},"NOD PUBLISHERS"]
[]
[null,"Piazza Martedì 222",{"$nulls":4},"Nome dipendente:",null,"Pupetta Costa"]
[null,"Appartamento 100",{"$nulls":4},"Nome del manager:",null,"Nazzareno Romani"]
[null,"Segrate, 54321 MI",{"$nulls":4},"Settimana a partire dal:",null,{"$f":"TODAY()","v":"2023-03-20"}]
[null,"(502) 555-0123"]
[]
[null,"Giorno della settimana","Ora entrata","Pause\n(minuti)","Ora uscita",null,"Totale\n[h]:mm","Normale\n[h]:mm","Straordinario\n[h]:mm","Malattia\n[h]:mm","Festività\n[h]:mm","Ferie\n[h]:mm"]
[null,{"$f":"Inizio_Settimana","v":"2023-03-20"},"09:05:00",15,"18:00:00",null,{"$f":"MROUND((IF(OR(C10=\"\",E10=\"\"),0,IF(E10<C10,E10+1-C10,E10-C10))-D10/1440),1/1440)","v":"08:40:00"},"08:00:00","00:40:00"]
[null,{"$f":"B10+1","v":"2023-03-21"},"09:05:00",30,"17:45:00",null,{"$f":"MROUND((IF(OR(C11=\"\",E11=\"\"),0,IF(E11<C11,E11+1-C11,E11-C11))-D11/1440),1/1440)","v":"08:10:00"},"08:00:00","00:10:00"]
[null,"2023-03-22","09:00:00",45,"18:30:00",null,"08:45:00","08:00:00","00:45:00"]
[null,"2023-03-23","09:00:00",45,"18:30:00",null,"08:45:00","08:00:00","00:45:00"]
[null,"2023-03-24",{"$nulls":4},"00:00:00",null,null,"08:00:00"]
[null,"2023-03-25",{"$nulls":4},"00:00:00"]
[null,"2023-03-26",{"$nulls":4},"00:00:00"]
[{"$nulls":6},"Totale",{"$f":"SUM(ScomposizioneSettimana1[Normale\n'[h']:mm])","v":1.3333333333333333},{"$f":"SUM(I10:I16)","v":"02:20:00"},{"$f":"SUM(J10:J16)","v":"08:00:00"},{"$f":"SUM(K10:K16)","v":"00:00:00"},{"$f":"SUM(L10:L16)","v":"00:00:00"}]
[]
[null,"Giorno della settimana","Ora entrata","Pause\n(minuti)","Ora uscita",null,"Totale\n[h]:mm","Normale\n[h]:mm","Straordinario\n[h]:mm","Malattia\n[h]:mm","Festività\n[h]:mm","Ferie\n[h]:mm"]
[null,{"$f":"B16+1","v":"2023-03-27"},{"$nulls":4},{"$f":"MROUND((IF(OR(C20=\"\",E20=\"\"),0,IF(E20<C20,E20+1-C20,E20-C20))-D20/1440),1/1440)","v":"00:00:00"}]
[null,{"$f":"B20+1","v":"2023-03-28"},{"$nulls":4},{"$f":"MROUND((IF(OR(C21=\"\",E21=\"\"),0,IF(E21<C21,E21+1-C21,E21-C21))-D21/1440),1/1440)","v":"00:00:00"}]
[null,"2023-03-29",{"$nulls":4},"00:00:00"]
[null,"2023-03-30",{"$nulls":4},"00:00:00"]
[null,"2023-03-31",{"$nulls":4},"00:00:00"]
[null,"2023-04-01",{"$nulls":4},"00:00:00"]
[null,"2023-04-02",{"$nulls":4},"00:00:00"]
[{"$nulls":6},"Totale",{"$f":"SUM(H20:H26)","v":"00:00:00"},{"$f":"SUM(I20:I26)","v":"00:00:00"},{"$f":"SUM(J20:J26)","v":"00:00:00"},{"$f":"SUM(K20:K26)","v":"00:00:00"},{"$f":"SUM(L20:L26)","v":"00:00:00"}]
[]
[{"$nulls":6}," ","Normale","Straordinario","Malattia","Festività","Ferie"]
[{"$nulls":6},"Retribuzione oraria:",{"v":15,"d":"15.00"},{"$f":"1.5*H30","v":{"v":22.5,"d":"22.50"}},{"v":15,"d":"15.00"},{"v":15,"d":"15.00"},{"v":15,"d":"15.00"}]
[null,"Firma del dipendente",null,null,"Data",null,"Retribuzione totale:",{"$f":"ROUND((H27+H17)*24*H30,2)","v":{"v":480,"d":"480.00"}},{"$f":"ROUND((I27+I17)*24*I30,2)","v":{"v":52.5,"d":"52.50"}},{"$f":"ROUND((J27+J17)*24*J30,2)","v":{"v":120,"d":"120.00"}},{"$f":"ROUND((K27+K17)*24*K30,2)","v":0},{"$f":"ROUND((L27+L17)*24*L30,2)","v":0}]
[]
[null,"Firma del manager",null,null,"Data",null,"Totale complessivo retribuzione:",{"$nulls":3},{"$f":"SUM(H31:L31)","v":{"v":652.5,"d":"652.50"}}]