{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["LEGGIMI","Esempio Gennaio","Gennaio","Febbraio","Marzo","Aprile","Maggio","Giugno","Luglio","Agosto","Settembre","Ottobre","Novembre","Dicembre","TOTALI","Grafici"],"not_rendered":{"charts":13,"images":1,"macros":1,"external_links":0,"defined_names":7,"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":"LEGGIMI","index":0,"n_rows":19,"n_cols":1,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,0,1,0],[16,0,17,0],[18,0,19,0]]}
["QUESTO FILE UTILIZZA IL PROGRAMMA DI EXCEL"]
[]
["Questo semplice programma, serve per conteggiare ogni giorno le ore di lavoro,"]
["gli straordinari, le ore di ferie, i permessi retribuiti ed eventuali giorni di malattia."]
["N.B. I fogli di lavoro sono protetti da scrittura, per evitare cancellazioni accidentali e/o errori di battitura."]
["Le celle che sono utilizzate per i dati, sono libere per l'inserimento e/o la modifica degli stessi."]
["L'inserimento dei dati su (ORARIO MATTINE e ORARIO POMERIGGI: Entrata, entrata mensa, uscita"]
["mensa e Uscita, sono da inserire come funzione ORARIO). Per agevolare l'immissione dei dati Orario,"]
["utilizzare i menu a tendina dove troverete gli orari maggiormente utilizzati per le varie Entrate e Uscite."]
["Inserimenti: le FERIE (ore 4-8), i P.A.R. (ore 0,25-1-1,5-2-4 ecc.), la MALATTIA è un giorno (1)"]
["Nella colonna Note Varie c'è una formula che inserisce, in automatico, FERIE - P.A.R. - MALATTIA,"]
["(vedi esempio) è però possibile, inserire nello spazio Note Varie, qualsiasi commento a Vostro piacimento"]
["(nel foglio di \"Esempio Gennaio\", c'è riportato un esempio d'inserimento ORARIO, per visualizzarne il formato)."]
["Nel foglio di Gennaio, inserite nelle caselle ORE FERIE e ORE P.A.R. i rispettivi valori inerenti alle"]
["Vostre Ferie e P.A.R. spettanti, negli altri fogli, il calcolo è automatico (preleva i dati dalle caselle \"restanti\")."]
["Spero che Vi torni utile una serie di fogli di lavoro gestiti così, (segnando tutte le ore di lavoro che si effettuano giornalmente)."]
["Un cordiale saluto - Buon Lavoro - Program By Maurizio Vignazzi."]
[]
["E-mail: maurivi53@libero.it"]

{"sheet":"Esempio Gennaio","index":1,"n_rows":37,"n_cols":13,"rows_kept":37,"cut":false,"hidden":false,"merged":[[33,0,36,5],[33,12,36,12],[0,10,1,10],[0,11,1,11],[33,10,36,10],[33,11,36,11],[33,6,36,6],[33,7,36,7],[1,0,1,1],[0,2,0,3],[0,4,0,5],[0,6,1,6],[0,0,0,1]]}
["FOGLIO DI ESEMPIO",null,"ORARIO MATTINE",null,"ORARIO POMERIGGI",null,"O R E  LAVORO","ORE straord.","ORE F E R I E","ORE P. A. R.","GIORNI DI MALATTIA","TOTALE     O R E"]
["GIORNO",null,"Entrata","entrata mensa","uscita mensa","Uscita",null,"al 25%",160,104,null,null,"NOTE VARIE"]
[1,"D",null,null,null,null,{"$f":"IF(D3-C3+F3-E3<0,TIME(0,0,0),IF(D3-C3+F3-E3>TIME(8,0,0),TIME(8,0,0),D3-C3+F3-E3))","v":"00:00:00"},{"$f":"IF(D3-C3+F3-E3>TIME(8,0,0),L3-G3,TIME(0,0,0))","v":"00:00:00"},null,null,null,{"$f":"IF(D3-C3+F3-E3<0,TIME(0,0,0),D3-C3+F3-E3)","v":"00:00:00"},{"$f":"IF(AND(I3<>\"\",J3=\"\",K3=\"\"),\"F E R I E\",IF(AND(I3=\"\",J3<>\"\",K3=\"\"),\"P E R M E S S O   R E T R I B U I T O\",IF(AND(I3=\"\",J3=\"\",K3=1),\"M A L A T T I A\",IF(AND(I3=\"\",J3=\"\",K3=\"\"),\"\",\"IMMETTERE UN SOLO VALORE\"))))","v":""}]
[2,"L",null,null,null,null,{"$f":"IF(D4-C4+F4-E4<0,TIME(0,0,0),IF(D4-C4+F4-E4>TIME(8,0,0),TIME(8,0,0),D4-C4+F4-E4))","v":"00:00:00"},{"$f":"IF(D4-C4+F4-E4>TIME(8,0,0),L4-G4,TIME(0,0,0))","v":"00:00:00"},null,null,null,{"$f":"IF(D4-C4+F4-E4<0,TIME(0,0,0),D4-C4+F4-E4)","v":"00:00:00"},""]
[3,"M",null,null,null,null,{"$f":"IF(D5-C5+F5-E5<0,TIME(0,0,0),IF(D5-C5+F5-E5>TIME(8,0,0),TIME(8,0,0),D5-C5+F5-E5))","v":"00:00:00"},{"$f":"IF(D5-C5+F5-E5>TIME(8,0,0),L5-G5,TIME(0,0,0))","v":"00:00:00"},null,null,null,{"$f":"IF(D5-C5+F5-E5<0,TIME(0,0,0),D5-C5+F5-E5)","v":"00:00:00"},""]
[4,"M",null,null,null,null,{"$f":"IF(D6-C6+F6-E6<0,TIME(0,0,0),IF(D6-C6+F6-E6>TIME(8,0,0),TIME(8,0,0),D6-C6+F6-E6))","v":"00:00:00"},{"$f":"IF(D6-C6+F6-E6>TIME(8,0,0),L6-G6,TIME(0,0,0))","v":"00:00:00"},null,null,null,{"$f":"IF(D6-C6+F6-E6<0,TIME(0,0,0),D6-C6+F6-E6)","v":"00:00:00"},""]
[5,"G","08:00:00","12:30:00","13:00:00","17:00:00",{"$f":"IF(D7-C7+F7-E7<0,TIME(0,0,0),IF(D7-C7+F7-E7>TIME(8,0,0),TIME(8,0,0),D7-C7+F7-E7))","v":"08:00:00"},{"$f":"IF(D7-C7+F7-E7>TIME(8,0,0),L7-G7,TIME(0,0,0))","v":"00:30:00"},null,null,null,{"$f":"IF(D7-C7+F7-E7<0,TIME(0,0,0),D7-C7+F7-E7)","v":"08:30:00"},""]
[6,"V",null,null,null,null,{"$f":"IF(D8-C8+F8-E8<0,TIME(0,0,0),IF(D8-C8+F8-E8>TIME(8,0,0),TIME(8,0,0),D8-C8+F8-E8))","v":"00:00:00"},{"$f":"IF(D8-C8+F8-E8>TIME(8,0,0),L8-G8,TIME(0,0,0))","v":"00:00:00"},null,null,null,{"$f":"IF(D8-C8+F8-E8<0,TIME(0,0,0),D8-C8+F8-E8)","v":"00:00:00"},""]
[7,"S",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[8,"D",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[9,"L",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[10,"M",null,null,null,null,"00:00:00","00:00:00",8,null,null,"00:00:00","F E R I E"]
[11,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[12,"G",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[13,"V",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[14,"S",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[15,"D",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[16,"L",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[17,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[18,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[19,"G",null,null,null,null,"00:00:00","00:00:00",4,null,null,"00:00:00","F E R I E"]
[20,"V",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[21,"S",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[22,"D",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[23,"L",null,null,null,null,"00:00:00","00:00:00",null,0.25,null,"00:00:00","P E R M E S S O   R E T R I B U I T O"]
[24,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[25,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[26,"G",null,null,null,null,"00:00:00","00:00:00",null,0.75,null,"00:00:00","P E R M E S S O   R E T R I B U I T O"]
[27,"V",null,null,null,null,"00:00:00","00:00:00",null,null,1,"00:00:00",{"$f":"IF(AND(I29<>\"\",J29=\"\",K29=\"\"),\"F E R I E\",IF(AND(I29=\"\",J29<>\"\",K29=\"\"),\"P E R M E S S O   R E T R I B U I T O\",IF(AND(I29=\"\",J29=\"\",K29=1),\"M A L A T T I A\",IF(AND(I29=\"\",J29=\"\",K29=\"\"),\"\",\"IMMETTERE UN SOLO VALORE\"))))","v":"M A L A T T I A"}]
[28,"S",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",{"$f":"IF(AND(I30<>\"\",J30=\"\",K30=\"\"),\"F E R I E\",IF(AND(I30=\"\",J30<>\"\",K30=\"\"),\"P E R M E S S O   R E T R I B U I T O\",IF(AND(I30=\"\",J30=\"\",K30=1),\"M A L A T T I A\",IF(AND(I30=\"\",J30=\"\",K30=\"\"),\"\",\"IMMETTERE UN SOLO VALORE\"))))","v":""}]
[29,"D",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",{"$f":"IF(AND(I31<>\"\",J31=\"\",K31=\"\"),\"F E R I E\",IF(AND(I31=\"\",J31<>\"\",K31=\"\"),\"P E R M E S S O   R E T R I B U I T O\",IF(AND(I31=\"\",J31=\"\",K31=1),\"M A L A T T I A\",IF(AND(I31=\"\",J31=\"\",K31=\"\"),\"\",\"IMMETTERE UN SOLO VALORE\"))))","v":""}]
[30,"L",null,null,null,null,"00:00:00","00:00:00",4,null,null,"00:00:00",{"$f":"IF(AND(I32<>\"\",J32=\"\",K32=\"\"),\"F E R I E\",IF(AND(I32=\"\",J32<>\"\",K32=\"\"),\"P E R M E S S O   R E T R I B U I T O\",IF(AND(I32=\"\",J32=\"\",K32=1),\"M A L A T T I A\",IF(AND(I32=\"\",J32=\"\",K32=\"\"),\"\",\"IMMETTERE UN SOLO VALORE\"))))","v":"F E R I E"}]
[31,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",{"$f":"IF(AND(I33<>\"\",J33=\"\",K33=\"\"),\"F E R I E\",IF(AND(I33=\"\",J33<>\"\",K33=\"\"),\"P E R M E S S O   R E T R I B U I T O\",IF(AND(I33=\"\",J33=\"\",K33=1),\"M A L A T T I A\",IF(AND(I33=\"\",J33=\"\",K33=\"\"),\"\",\"IMMETTERE UN SOLO VALORE\"))))","v":""}]
["VISUALIZZA I TOTALI",null,null,null,null,null,{"$f":"SUM(G3:G33)*24","v":8},{"$f":"SUM(H3:H33)*24","v":0.50000000000000488},{"$f":"SUM(I3:I33)","v":16},{"$f":"SUM(J3:J33)","v":1},{"$f":"SUM(K3:K33)","v":1},{"$f":"SUM(L3:L33)*24","v":8.5000000000000036},"grafico"]
[null,null,null,null,null,null,null,null,"USATE","USATE"]
[null,null,null,null,null,null,null,null,{"$f":"I2-I34","v":144},{"$f":"J2-J34","v":103}]
[null,null,null,null,null,null,null,null,"RESTANTI","RESTANTI"]

{"sheet":"Gennaio","index":2,"n_rows":37,"n_cols":13,"rows_kept":37,"cut":false,"hidden":false,"merged":[[33,12,36,12],[0,10,1,10],[0,11,1,11],[1,0,1,1],[33,6,36,6],[33,0,36,5],[33,7,36,7],[33,10,36,10],[33,11,36,11],[0,0,0,1],[0,2,0,3],[0,4,0,5],[0,6,1,6]]}
["GENNAIO '2017",null,"ORARIO MATTINE",null,"ORARIO POMERIGGI",null,"O R E  LAVORO","ORE straord.","ORE F E R I E","ORE P. A. R.","GIORNI DI MALATTIA","TOTALE     O R E"]
["GIORNO",null,"Entrata","entrata mensa","uscita mensa","Uscita",null,"al 25%",160,104,null,null,"NOTE VARIE"]
[1,"D",null,null,null,null,{"$f":"IF(D3-C3+F3-E3<0,TIME(0,0,0),IF(D3-C3+F3-E3>TIME(8,0,0),TIME(8,0,0),D3-C3+F3-E3))","v":"00:00:00"},{"$f":"IF(D3-C3+F3-E3>TIME(8,0,0),L3-G3,TIME(0,0,0))","v":"00:00:00"},null,null,null,{"$f":"IF(D3-C3+F3-E3<0,TIME(0,0,0),D3-C3+F3-E3)","v":"00:00:00"},{"$f":"IF(AND(I3<>\"\",J3=\"\",K3=\"\"),\"F E R I E\",IF(AND(I3=\"\",J3<>\"\",K3=\"\"),\"P E R M E S S O   R E T R I B U I T O\",IF(AND(I3=\"\",J3=\"\",K3=1),\"M A L A T T I A\",IF(AND(I3=\"\",J3=\"\",K3=\"\"),\"\",\"IMMETTERE UN SOLO VALORE\"))))","v":""}]
[2,"L",null,null,null,null,{"$f":"IF(D4-C4+F4-E4<0,TIME(0,0,0),IF(D4-C4+F4-E4>TIME(8,0,0),TIME(8,0,0),D4-C4+F4-E4))","v":"00:00:00"},{"$f":"IF(D4-C4+F4-E4>TIME(8,0,0),L4-G4,TIME(0,0,0))","v":"00:00:00"},null,null,null,{"$f":"IF(D4-C4+F4-E4<0,TIME(0,0,0),D4-C4+F4-E4)","v":"00:00:00"},{"$f":"IF(AND(I4<>\"\",J4=\"\",K4=\"\"),\"F E R I E\",IF(AND(I4=\"\",J4<>\"\",K4=\"\"),\"P E R M E S S O   R E T R I B U I T O\",IF(AND(I4=\"\",J4=\"\",K4=1),\"M A L A T T I A\",IF(AND(I4=\"\",J4=\"\",K4=\"\"),\"\",\"IMMETTERE UN SOLO VALORE\"))))","v":""}]
[3,"M",null,null,null,null,{"$f":"IF(D5-C5+F5-E5<0,TIME(0,0,0),IF(D5-C5+F5-E5>TIME(8,0,0),TIME(8,0,0),D5-C5+F5-E5))","v":"00:00:00"},{"$f":"IF(D5-C5+F5-E5>TIME(8,0,0),L5-G5,TIME(0,0,0))","v":"00:00:00"},null,null,null,{"$f":"IF(D5-C5+F5-E5<0,TIME(0,0,0),D5-C5+F5-E5)","v":"00:00:00"},{"$f":"IF(AND(I5<>\"\",J5=\"\",K5=\"\"),\"F E R I E\",IF(AND(I5=\"\",J5<>\"\",K5=\"\"),\"P E R M E S S O   R E T R I B U I T O\",IF(AND(I5=\"\",J5=\"\",K5=1),\"M A L A T T I A\",IF(AND(I5=\"\",J5=\"\",K5=\"\"),\"\",\"IMMETTERE UN SOLO VALORE\"))))","v":""}]
[4,"M",null,null,null,null,{"$f":"IF(D6-C6+F6-E6<0,TIME(0,0,0),IF(D6-C6+F6-E6>TIME(8,0,0),TIME(8,0,0),D6-C6+F6-E6))","v":"00:00:00"},{"$f":"IF(D6-C6+F6-E6>TIME(8,0,0),L6-G6,TIME(0,0,0))","v":"00:00:00"},null,null,null,{"$f":"IF(D6-C6+F6-E6<0,TIME(0,0,0),D6-C6+F6-E6)","v":"00:00:00"},{"$f":"IF(AND(I6<>\"\",J6=\"\",K6=\"\"),\"F E R I E\",IF(AND(I6=\"\",J6<>\"\",K6=\"\"),\"P E R M E S S O   R E T R I B U I T O\",IF(AND(I6=\"\",J6=\"\",K6=1),\"M A L A T T I A\",IF(AND(I6=\"\",J6=\"\",K6=\"\"),\"\",\"IMMETTERE UN SOLO VALORE\"))))","v":""}]
[5,"G",null,null,null,null,{"$f":"IF(D7-C7+F7-E7<0,TIME(0,0,0),IF(D7-C7+F7-E7>TIME(8,0,0),TIME(8,0,0),D7-C7+F7-E7))","v":"00:00:00"},{"$f":"IF(D7-C7+F7-E7>TIME(8,0,0),L7-G7,TIME(0,0,0))","v":"00:00:00"},null,null,null,{"$f":"IF(D7-C7+F7-E7<0,TIME(0,0,0),D7-C7+F7-E7)","v":"00:00:00"},{"$f":"IF(AND(I7<>\"\",J7=\"\",K7=\"\"),\"F E R I E\",IF(AND(I7=\"\",J7<>\"\",K7=\"\"),\"P E R M E S S O   R E T R I B U I T O\",IF(AND(I7=\"\",J7=\"\",K7=1),\"M A L A T T I A\",IF(AND(I7=\"\",J7=\"\",K7=\"\"),\"\",\"IMMETTERE UN SOLO VALORE\"))))","v":""}]
[6,"V",null,null,null,null,{"$f":"IF(D8-C8+F8-E8<0,TIME(0,0,0),IF(D8-C8+F8-E8>TIME(8,0,0),TIME(8,0,0),D8-C8+F8-E8))","v":"00:00:00"},{"$f":"IF(D8-C8+F8-E8>TIME(8,0,0),L8-G8,TIME(0,0,0))","v":"00:00:00"},null,null,null,{"$f":"IF(D8-C8+F8-E8<0,TIME(0,0,0),D8-C8+F8-E8)","v":"00:00:00"},{"$f":"IF(AND(I8<>\"\",J8=\"\",K8=\"\"),\"F E R I E\",IF(AND(I8=\"\",J8<>\"\",K8=\"\"),\"P E R M E S S O   R E T R I B U I T O\",IF(AND(I8=\"\",J8=\"\",K8=1),\"M A L A T T I A\",IF(AND(I8=\"\",J8=\"\",K8=\"\"),\"\",\"IMMETTERE UN SOLO VALORE\"))))","v":""}]
[7,"S",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[8,"D",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[9,"L",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[10,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[11,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[12,"G",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[13,"V",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[14,"S",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[15,"D",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[16,"L",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[17,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[18,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[19,"G",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[20,"V",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[21,"S",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[22,"D",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[23,"L",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[24,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[25,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[26,"G",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[27,"V",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[28,"S",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[29,"D",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[30,"L",null,null,null,null,{"$f":"IF(D32-C32+F32-E32<0,TIME(0,0,0),IF(D32-C32+F32-E32>TIME(8,0,0),TIME(8,0,0),D32-C32+F32-E32))","v":"00:00:00"},{"$f":"IF(D32-C32+F32-E32>TIME(8,0,0),L32-G32,TIME(0,0,0))","v":"00:00:00"},null,null,null,{"$f":"IF(D32-C32+F32-E32<0,TIME(0,0,0),D32-C32+F32-E32)","v":"00:00:00"},{"$f":"IF(AND(I32<>\"\",J32=\"\",K32=\"\"),\"F E R I E\",IF(AND(I32=\"\",J32<>\"\",K32=\"\"),\"P E R M E S S O   R E T R I B U I T O\",IF(AND(I32=\"\",J32=\"\",K32=1),\"M A L A T T I A\",IF(AND(I32=\"\",J32=\"\",K32=\"\"),\"\",\"IMMETTERE UN SOLO VALORE\"))))","v":""}]
[31,"M",null,null,null,null,{"$f":"IF(D33-C33+F33-E33<0,TIME(0,0,0),IF(D33-C33+F33-E33>TIME(8,0,0),TIME(8,0,0),D33-C33+F33-E33))","v":"00:00:00"},{"$f":"IF(D33-C33+F33-E33>TIME(8,0,0),L33-G33,TIME(0,0,0))","v":"00:00:00"},null,null,null,{"$f":"IF(D33-C33+F33-E33<0,TIME(0,0,0),D33-C33+F33-E33)","v":"00:00:00"},{"$f":"IF(AND(I33<>\"\",J33=\"\",K33=\"\"),\"F E R I E\",IF(AND(I33=\"\",J33<>\"\",K33=\"\"),\"P E R M E S S O   R E T R I B U I T O\",IF(AND(I33=\"\",J33=\"\",K33=1),\"M A L A T T I A\",IF(AND(I33=\"\",J33=\"\",K33=\"\"),\"\",\"IMMETTERE UN SOLO VALORE\"))))","v":""}]
["VISUALIZZA I TOTALI",null,null,null,null,null,{"$f":"SUM(G3:G33)*24","v":0},{"$f":"SUM(H3:H33)*24","v":0},{"$f":"SUM(I3:I33)","v":0},{"$f":"SUM(J3:J33)","v":0},{"$f":"SUM(K3:K33)","v":0},{"$f":"SUM(L3:L33)*24","v":0},"grafico"]
[null,null,null,null,null,null,null,null,"USATE","USATE"]
[null,null,null,null,null,null,null,null,{"$f":"I2-I34","v":160},{"$f":"J2-J34","v":104}]
[null,null,null,null,null,null,null,null,"RESTANTI","RESTANTI"]

{"sheet":"Febbraio","index":3,"n_rows":37,"n_cols":13,"rows_kept":37,"cut":false,"hidden":false,"merged":[[33,12,36,12],[0,10,1,10],[0,11,1,11],[1,0,1,1],[33,6,36,6],[33,0,36,5],[33,7,36,7],[33,10,36,10],[33,11,36,11],[0,0,0,1],[0,2,0,3],[0,4,0,5],[0,6,1,6]]}
["FEBBRAIO '2017",null,"ORARIO MATTINE",null,"ORARIO POMERIGGI",null,"O R E  LAVORO","ORE straord.","ORE F E R I E","ORE P. A. R.","GIORNI DI MALATTIA","TOTALE     O R E"]
["GIORNO",null,"Entrata","entrata mensa","uscita mensa","Uscita",null,"al 25%",{"$f":"Gennaio!I36","v":160},{"$f":"Gennaio!J36","v":104},null,null,"NOTE VARIE"]
[1,"M",null,null,null,null,{"$f":"IF(D3-C3+F3-E3<0,TIME(0,0,0),IF(D3-C3+F3-E3>TIME(8,0,0),TIME(8,0,0),D3-C3+F3-E3))","v":"00:00:00"},{"$f":"IF(D3-C3+F3-E3>TIME(8,0,0),L3-G3,TIME(0,0,0))","v":"00:00:00"},null,null,null,{"$f":"IF(D3-C3+F3-E3<0,TIME(0,0,0),D3-C3+F3-E3)","v":"00:00:00"},{"$f":"IF(AND(I3<>\"\",J3=\"\",K3=\"\"),\"F E R I E\",IF(AND(I3=\"\",J3<>\"\",K3=\"\"),\"P E R M E S S O   R E T R I B U I T O\",IF(AND(I3=\"\",J3=\"\",K3=1),\"M A L A T T I A\",IF(AND(I3=\"\",J3=\"\",K3=\"\"),\"\",\"IMMETTERE UN SOLO VALORE\"))))","v":""}]
[2,"G",null,null,null,null,{"$f":"IF(D4-C4+F4-E4<0,TIME(0,0,0),IF(D4-C4+F4-E4>TIME(8,0,0),TIME(8,0,0),D4-C4+F4-E4))","v":"00:00:00"},{"$f":"IF(D4-C4+F4-E4>TIME(8,0,0),L4-G4,TIME(0,0,0))","v":"00:00:00"},null,null,null,{"$f":"IF(D4-C4+F4-E4<0,TIME(0,0,0),D4-C4+F4-E4)","v":"00:00:00"},{"$f":"IF(AND(I4<>\"\",J4=\"\",K4=\"\"),\"F E R I E\",IF(AND(I4=\"\",J4<>\"\",K4=\"\"),\"P E R M E S S O   R E T R I B U I T O\",IF(AND(I4=\"\",J4=\"\",K4=1),\"M A L A T T I A\",IF(AND(I4=\"\",J4=\"\",K4=\"\"),\"\",\"IMMETTERE UN SOLO VALORE\"))))","v":""}]
[3,"V",null,null,null,null,{"$f":"IF(D5-C5+F5-E5<0,TIME(0,0,0),IF(D5-C5+F5-E5>TIME(8,0,0),TIME(8,0,0),D5-C5+F5-E5))","v":"00:00:00"},{"$f":"IF(D5-C5+F5-E5>TIME(8,0,0),L5-G5,TIME(0,0,0))","v":"00:00:00"},null,null,null,{"$f":"IF(D5-C5+F5-E5<0,TIME(0,0,0),D5-C5+F5-E5)","v":"00:00:00"},{"$f":"IF(AND(I5<>\"\",J5=\"\",K5=\"\"),\"F E R I E\",IF(AND(I5=\"\",J5<>\"\",K5=\"\"),\"P E R M E S S O   R E T R I B U I T O\",IF(AND(I5=\"\",J5=\"\",K5=1),\"M A L A T T I A\",IF(AND(I5=\"\",J5=\"\",K5=\"\"),\"\",\"IMMETTERE UN SOLO VALORE\"))))","v":""}]
[4,"S",null,null,null,null,{"$f":"IF(D6-C6+F6-E6<0,TIME(0,0,0),IF(D6-C6+F6-E6>TIME(8,0,0),TIME(8,0,0),D6-C6+F6-E6))","v":"00:00:00"},{"$f":"IF(D6-C6+F6-E6>TIME(8,0,0),L6-G6,TIME(0,0,0))","v":"00:00:00"},null,null,null,{"$f":"IF(D6-C6+F6-E6<0,TIME(0,0,0),D6-C6+F6-E6)","v":"00:00:00"},{"$f":"IF(AND(I6<>\"\",J6=\"\",K6=\"\"),\"F E R I E\",IF(AND(I6=\"\",J6<>\"\",K6=\"\"),\"P E R M E S S O   R E T R I B U I T O\",IF(AND(I6=\"\",J6=\"\",K6=1),\"M A L A T T I A\",IF(AND(I6=\"\",J6=\"\",K6=\"\"),\"\",\"IMMETTERE UN SOLO VALORE\"))))","v":""}]
[5,"D",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[6,"L",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[7,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[8,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[9,"G",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[10,"V",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[11,"S",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[12,"D",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[13,"L",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[14,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[15,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[16,"G",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[17,"V",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[18,"S",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[19,"D",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[20,"L",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[21,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[22,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[23,"G",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[24,"V",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[25,"S",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[26,"D",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[27,"L",null,null,null,null,{"$f":"IF(D29-C29+F29-E29<0,TIME(0,0,0),IF(D29-C29+F29-E29>TIME(8,0,0),TIME(8,0,0),D29-C29+F29-E29))","v":"00:00:00"},{"$f":"IF(D29-C29+F29-E29>TIME(8,0,0),L29-G29,TIME(0,0,0))","v":"00:00:00"},null,null,null,{"$f":"IF(D29-C29+F29-E29<0,TIME(0,0,0),D29-C29+F29-E29)","v":"00:00:00"},{"$f":"IF(AND(I29<>\"\",J29=\"\",K29=\"\"),\"F E R I E\",IF(AND(I29=\"\",J29<>\"\",K29=\"\"),\"P E R M E S S O   R E T R I B U I T O\",IF(AND(I29=\"\",J29=\"\",K29=1),\"M A L A T T I A\",IF(AND(I29=\"\",J29=\"\",K29=\"\"),\"\",\"IMMETTERE UN SOLO VALORE\"))))","v":""}]
[28,"M",null,null,null,null,{"$f":"IF(D30-C30+F30-E30<0,TIME(0,0,0),IF(D30-C30+F30-E30>TIME(8,0,0),TIME(8,0,0),D30-C30+F30-E30))","v":"00:00:00"},{"$f":"IF(D30-C30+F30-E30>TIME(8,0,0),L30-G30,TIME(0,0,0))","v":"00:00:00"},null,null,null,{"$f":"IF(D30-C30+F30-E30<0,TIME(0,0,0),D30-C30+F30-E30)","v":"00:00:00"},{"$f":"IF(AND(I30<>\"\",J30=\"\",K30=\"\"),\"F E R I E\",IF(AND(I30=\"\",J30<>\"\",K30=\"\"),\"P E R M E S S O   R E T R I B U I T O\",IF(AND(I30=\"\",J30=\"\",K30=1),\"M A L A T T I A\",IF(AND(I30=\"\",J30=\"\",K30=\"\"),\"\",\"IMMETTERE UN SOLO VALORE\"))))","v":""}]
[]
[]
[]
["VISUALIZZA I TOTALI",null,null,null,null,null,{"$f":"SUM(G3:G33)*24","v":0},{"$f":"SUM(H3:H33)*24","v":0},{"$f":"SUM(I3:I33)","v":0},{"$f":"SUM(J3:J33)","v":0},{"$f":"SUM(K3:K33)","v":0},{"$f":"SUM(L3:L33)*24","v":0},"grafico"]
[null,null,null,null,null,null,null,null,"USATE","USATE"]
[null,null,null,null,null,null,null,null,{"$f":"I2-I34","v":160},{"$f":"J2-J34","v":104}]
[null,null,null,null,null,null,null,null,"RESTANTI","RESTANTI"]

{"sheet":"Marzo","index":4,"n_rows":37,"n_cols":13,"rows_kept":37,"cut":false,"hidden":false,"merged":[[33,12,36,12],[0,10,1,10],[0,11,1,11],[1,0,1,1],[33,6,36,6],[33,0,36,5],[33,7,36,7],[33,10,36,10],[33,11,36,11],[0,0,0,1],[0,2,0,3],[0,4,0,5],[0,6,1,6]]}
["MARZO '2017",null,"ORARIO MATTINE",null,"ORARIO POMERIGGI",null,"O R E  LAVORO","ORE straord.","ORE F E R I E","ORE P. A. R.","GIORNI DI MALATTIA","TOTALE     O R E"]
["GIORNO",null,"Entrata","entrata mensa","uscita mensa","Uscita",null,"al 25%",{"$f":"Febbraio!I36","v":160},{"$f":"Febbraio!J36","v":104},null,null,"NOTE VARIE"]
[1,"M",null,null,null,null,{"$f":"IF(D3-C3+F3-E3<0,TIME(0,0,0),IF(D3-C3+F3-E3>TIME(8,0,0),TIME(8,0,0),D3-C3+F3-E3))","v":"00:00:00"},{"$f":"IF(D3-C3+F3-E3>TIME(8,0,0),L3-G3,TIME(0,0,0))","v":"00:00:00"},null,null,null,{"$f":"IF(D3-C3+F3-E3<0,TIME(0,0,0),D3-C3+F3-E3)","v":"00:00:00"},{"$f":"IF(AND(I3<>\"\",J3=\"\",K3=\"\"),\"F E R I E\",IF(AND(I3=\"\",J3<>\"\",K3=\"\"),\"P E R M E S S O   R E T R I B U I T O\",IF(AND(I3=\"\",J3=\"\",K3=1),\"M A L A T T I A\",IF(AND(I3=\"\",J3=\"\",K3=\"\"),\"\",\"IMMETTERE UN SOLO VALORE\"))))","v":""}]
[2,"G",null,null,null,null,{"$f":"IF(D4-C4+F4-E4<0,TIME(0,0,0),IF(D4-C4+F4-E4>TIME(8,0,0),TIME(8,0,0),D4-C4+F4-E4))","v":"00:00:00"},{"$f":"IF(D4-C4+F4-E4>TIME(8,0,0),L4-G4,TIME(0,0,0))","v":"00:00:00"},null,null,null,{"$f":"IF(D4-C4+F4-E4<0,TIME(0,0,0),D4-C4+F4-E4)","v":"00:00:00"},{"$f":"IF(AND(I4<>\"\",J4=\"\",K4=\"\"),\"F E R I E\",IF(AND(I4=\"\",J4<>\"\",K4=\"\"),\"P E R M E S S O   R E T R I B U I T O\",IF(AND(I4=\"\",J4=\"\",K4=1),\"M A L A T T I A\",IF(AND(I4=\"\",J4=\"\",K4=\"\"),\"\",\"IMMETTERE UN SOLO VALORE\"))))","v":""}]
[3,"V",null,null,null,null,{"$f":"IF(D5-C5+F5-E5<0,TIME(0,0,0),IF(D5-C5+F5-E5>TIME(8,0,0),TIME(8,0,0),D5-C5+F5-E5))","v":"00:00:00"},{"$f":"IF(D5-C5+F5-E5>TIME(8,0,0),L5-G5,TIME(0,0,0))","v":"00:00:00"},null,null,null,{"$f":"IF(D5-C5+F5-E5<0,TIME(0,0,0),D5-C5+F5-E5)","v":"00:00:00"},{"$f":"IF(AND(I5<>\"\",J5=\"\",K5=\"\"),\"F E R I E\",IF(AND(I5=\"\",J5<>\"\",K5=\"\"),\"P E R M E S S O   R E T R I B U I T O\",IF(AND(I5=\"\",J5=\"\",K5=1),\"M A L A T T I A\",IF(AND(I5=\"\",J5=\"\",K5=\"\"),\"\",\"IMMETTERE UN SOLO VALORE\"))))","v":""}]
[4,"S",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[5,"D",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[6,"L",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[7,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[8,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[9,"G",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[10,"V",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[11,"S",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[12,"D",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[13,"L",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[14,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[15,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[16,"G",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[17,"V",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[18,"S",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[19,"D",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[20,"L",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[21,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[22,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[23,"G",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[24,"V",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[25,"S",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[26,"D",null,null,null,null,{"$f":"IF(D28-C28+F28-E28<0,TIME(0,0,0),IF(D28-C28+F28-E28>TIME(8,0,0),TIME(8,0,0),D28-C28+F28-E28))","v":"00:00:00"},{"$f":"IF(D28-C28+F28-E28>TIME(8,0,0),L28-G28,TIME(0,0,0))","v":"00:00:00"},null,null,null,{"$f":"IF(D28-C28+F28-E28<0,TIME(0,0,0),D28-C28+F28-E28)","v":"00:00:00"},{"$f":"IF(AND(I28<>\"\",J28=\"\",K28=\"\"),\"F E R I E\",IF(AND(I28=\"\",J28<>\"\",K28=\"\"),\"P E R M E S S O   R E T R I B U I T O\",IF(AND(I28=\"\",J28=\"\",K28=1),\"M A L A T T I A\",IF(AND(I28=\"\",J28=\"\",K28=\"\"),\"\",\"IMMETTERE UN SOLO VALORE\"))))","v":""}]
[27,"L",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[28,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[29,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[30,"G",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[31,"V",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
["VISUALIZZA I TOTALI",null,null,null,null,null,{"$f":"SUM(G3:G33)*24","v":0},{"$f":"SUM(H3:H33)*24","v":0},{"$f":"SUM(I3:I33)","v":0},{"$f":"SUM(J3:J33)","v":0},{"$f":"SUM(K3:K33)","v":0},{"$f":"SUM(L3:L33)*24","v":0},"grafico"]
[null,null,null,null,null,null,null,null,"USATE","USATE"]
[null,null,null,null,null,null,null,null,{"$f":"I2-I34","v":160},{"$f":"J2-J34","v":104}]
[null,null,null,null,null,null,null,null,"RESTANTI","RESTANTI"]

{"sheet":"Aprile","index":5,"n_rows":37,"n_cols":13,"rows_kept":37,"cut":false,"hidden":false,"merged":[[33,12,36,12],[0,10,1,10],[0,11,1,11],[1,0,1,1],[33,6,36,6],[33,0,36,5],[33,7,36,7],[33,10,36,10],[33,11,36,11],[0,0,0,1],[0,2,0,3],[0,4,0,5],[0,6,1,6]]}
["APRILE '2017",null,"ORARIO MATTINE",null,"ORARIO POMERIGGI",null,"O R E  LAVORO","ORE straord.","ORE F E R I E","ORE P. A. R.","GIORNI DI MALATTIA","TOTALE     O R E"]
["GIORNO",null,"Entrata","entrata mensa","uscita mensa","Uscita",null,"al 25%",{"$f":"Marzo!I36","v":160},{"$f":"Marzo!J36","v":104},null,null,"NOTE VARIE"]
[1,"S",null,null,null,null,{"$f":"IF(D3-C3+F3-E3<0,TIME(0,0,0),IF(D3-C3+F3-E3>TIME(8,0,0),TIME(8,0,0),D3-C3+F3-E3))","v":"00:00:00"},{"$f":"IF(D3-C3+F3-E3>TIME(8,0,0),L3-G3,TIME(0,0,0))","v":"00:00:00"},null,null,null,{"$f":"IF(D3-C3+F3-E3<0,TIME(0,0,0),D3-C3+F3-E3)","v":"00:00:00"},{"$f":"IF(AND(I3<>\"\",J3=\"\",K3=\"\"),\"F E R I E\",IF(AND(I3=\"\",J3<>\"\",K3=\"\"),\"P E R M E S S O   R E T R I B U I T O\",IF(AND(I3=\"\",J3=\"\",K3=1),\"M A L A T T I A\",IF(AND(I3=\"\",J3=\"\",K3=\"\"),\"\",\"IMMETTERE UN SOLO VALORE\"))))","v":""}]
[2,"D",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[3,"L",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[4,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[5,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[6,"G",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[7,"V",null,null,null,null,{"$f":"IF(D9-C9+F9-E9<0,TIME(0,0,0),IF(D9-C9+F9-E9>TIME(8,0,0),TIME(8,0,0),D9-C9+F9-E9))","v":"00:00:00"},{"$f":"IF(D9-C9+F9-E9>TIME(8,0,0),L9-G9,TIME(0,0,0))","v":"00:00:00"},null,null,null,{"$f":"IF(D9-C9+F9-E9<0,TIME(0,0,0),D9-C9+F9-E9)","v":"00:00:00"},{"$f":"IF(AND(I9<>\"\",J9=\"\",K9=\"\"),\"F E R I E\",IF(AND(I9=\"\",J9<>\"\",K9=\"\"),\"P E R M E S S O   R E T R I B U I T O\",IF(AND(I9=\"\",J9=\"\",K9=1),\"M A L A T T I A\",IF(AND(I9=\"\",J9=\"\",K9=\"\"),\"\",\"IMMETTERE UN SOLO VALORE\"))))","v":""}]
[8,"S",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[9,"D",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[10,"L",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[11,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[12,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[13,"G",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[14,"V",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[15,"S",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[16,"D",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[17,"L",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[18,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[19,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[20,"G",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[21,"V",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[22,"S",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[23,"D",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[24,"L",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[25,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[26,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[27,"G",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[28,"V",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[29,"S",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[30,"D",null,null,null,null,{"$f":"IF(D32-C32+F32-E32<0,TIME(0,0,0),IF(D32-C32+F32-E32>TIME(8,0,0),TIME(8,0,0),D32-C32+F32-E32))","v":"00:00:00"},{"$f":"IF(D32-C32+F32-E32>TIME(8,0,0),L32-G32,TIME(0,0,0))","v":"00:00:00"},null,null,null,{"$f":"IF(D32-C32+F32-E32<0,TIME(0,0,0),D32-C32+F32-E32)","v":"00:00:00"},{"$f":"IF(AND(I32<>\"\",J32=\"\",K32=\"\"),\"F E R I E\",IF(AND(I32=\"\",J32<>\"\",K32=\"\"),\"P E R M E S S O   R E T R I B U I T O\",IF(AND(I32=\"\",J32=\"\",K32=1),\"M A L A T T I A\",IF(AND(I32=\"\",J32=\"\",K32=\"\"),\"\",\"IMMETTERE UN SOLO VALORE\"))))","v":""}]
[]
["VISUALIZZA I TOTALI",null,null,null,null,null,{"$f":"SUM(G3:G33)*24","v":0},{"$f":"SUM(H3:H33)*24","v":0},{"$f":"SUM(I3:I33)","v":0},{"$f":"SUM(J3:J33)","v":0},{"$f":"SUM(K3:K33)","v":0},{"$f":"SUM(L3:L33)*24","v":0},"grafico"]
[null,null,null,null,null,null,null,null,"USATE","USATE"]
[null,null,null,null,null,null,null,null,{"$f":"I2-I34","v":160},{"$f":"J2-J34","v":104}]
[null,null,null,null,null,null,null,null,"RESTANTI","RESTANTI"]

{"sheet":"Maggio","index":6,"n_rows":37,"n_cols":13,"rows_kept":37,"cut":false,"hidden":false,"merged":[[33,12,36,12],[0,10,1,10],[0,11,1,11],[1,0,1,1],[33,6,36,6],[33,0,36,5],[33,7,36,7],[33,10,36,10],[33,11,36,11],[0,0,0,1],[0,2,0,3],[0,4,0,5],[0,6,1,6]]}
["MAGGIO '2017",null,"ORARIO MATTINE",null,"ORARIO POMERIGGI",null,"O R E  LAVORO","ORE straord.","ORE F E R I E","ORE P. A. R.","GIORNI DI MALATTIA","TOTALE     O R E"]
["GIORNO",null,"Entrata","entrata mensa","uscita mensa","Uscita",null,"al 25%",{"$f":"Aprile!I36","v":160},{"$f":"Aprile!J36","v":104},null,null,"NOTE VARIE"]
[1,"L",null,null,null,null,{"$f":"IF(D3-C3+F3-E3<0,TIME(0,0,0),IF(D3-C3+F3-E3>TIME(8,0,0),TIME(8,0,0),D3-C3+F3-E3))","v":"00:00:00"},{"$f":"IF(D3-C3+F3-E3>TIME(8,0,0),L3-G3,TIME(0,0,0))","v":"00:00:00"},null,null,null,{"$f":"IF(D3-C3+F3-E3<0,TIME(0,0,0),D3-C3+F3-E3)","v":"00:00:00"},{"$f":"IF(AND(I3<>\"\",J3=\"\",K3=\"\"),\"F E R I E\",IF(AND(I3=\"\",J3<>\"\",K3=\"\"),\"P E R M E S S O   R E T R I B U I T O\",IF(AND(I3=\"\",J3=\"\",K3=1),\"M A L A T T I A\",IF(AND(I3=\"\",J3=\"\",K3=\"\"),\"\",\"IMMETTERE UN SOLO VALORE\"))))","v":""}]
[2,"M",null,null,null,null,{"$f":"IF(D4-C4+F4-E4<0,TIME(0,0,0),IF(D4-C4+F4-E4>TIME(8,0,0),TIME(8,0,0),D4-C4+F4-E4))","v":"00:00:00"},{"$f":"IF(D4-C4+F4-E4>TIME(8,0,0),L4-G4,TIME(0,0,0))","v":"00:00:00"},null,null,null,{"$f":"IF(D4-C4+F4-E4<0,TIME(0,0,0),D4-C4+F4-E4)","v":"00:00:00"},{"$f":"IF(AND(I4<>\"\",J4=\"\",K4=\"\"),\"F E R I E\",IF(AND(I4=\"\",J4<>\"\",K4=\"\"),\"P E R M E S S O   R E T R I B U I T O\",IF(AND(I4=\"\",J4=\"\",K4=1),\"M A L A T T I A\",IF(AND(I4=\"\",J4=\"\",K4=\"\"),\"\",\"IMMETTERE UN SOLO VALORE\"))))","v":""}]
[3,"M",null,null,null,null,{"$f":"IF(D5-C5+F5-E5<0,TIME(0,0,0),IF(D5-C5+F5-E5>TIME(8,0,0),TIME(8,0,0),D5-C5+F5-E5))","v":"00:00:00"},{"$f":"IF(D5-C5+F5-E5>TIME(8,0,0),L5-G5,TIME(0,0,0))","v":"00:00:00"},null,null,null,{"$f":"IF(D5-C5+F5-E5<0,TIME(0,0,0),D5-C5+F5-E5)","v":"00:00:00"},{"$f":"IF(AND(I5<>\"\",J5=\"\",K5=\"\"),\"F E R I E\",IF(AND(I5=\"\",J5<>\"\",K5=\"\"),\"P E R M E S S O   R E T R I B U I T O\",IF(AND(I5=\"\",J5=\"\",K5=1),\"M A L A T T I A\",IF(AND(I5=\"\",J5=\"\",K5=\"\"),\"\",\"IMMETTERE UN SOLO VALORE\"))))","v":""}]
[4,"G",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[5,"V",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[6,"S",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[7,"D",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[8,"L",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[9,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[10,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[11,"G",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[12,"V",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[13,"S",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[14,"D",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[15,"L",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[16,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[17,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[18,"G",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[19,"V",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[20,"S",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[21,"D",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[22,"L",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[23,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[24,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[25,"G",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[26,"V",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[27,"S",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[28,"D",null,null,null,null,{"$f":"IF(D30-C30+F30-E30<0,TIME(0,0,0),IF(D30-C30+F30-E30>TIME(8,0,0),TIME(8,0,0),D30-C30+F30-E30))","v":"00:00:00"},{"$f":"IF(D30-C30+F30-E30>TIME(8,0,0),L30-G30,TIME(0,0,0))","v":"00:00:00"},null,null,null,{"$f":"IF(D30-C30+F30-E30<0,TIME(0,0,0),D30-C30+F30-E30)","v":"00:00:00"},{"$f":"IF(AND(I30<>\"\",J30=\"\",K30=\"\"),\"F E R I E\",IF(AND(I30=\"\",J30<>\"\",K30=\"\"),\"P E R M E S S O   R E T R I B U I T O\",IF(AND(I30=\"\",J30=\"\",K30=1),\"M A L A T T I A\",IF(AND(I30=\"\",J30=\"\",K30=\"\"),\"\",\"IMMETTERE UN SOLO VALORE\"))))","v":""}]
[29,"L",null,null,null,null,{"$f":"IF(D31-C31+F31-E31<0,TIME(0,0,0),IF(D31-C31+F31-E31>TIME(8,0,0),TIME(8,0,0),D31-C31+F31-E31))","v":"00:00:00"},{"$f":"IF(D31-C31+F31-E31>TIME(8,0,0),L31-G31,TIME(0,0,0))","v":"00:00:00"},null,null,null,{"$f":"IF(D31-C31+F31-E31<0,TIME(0,0,0),D31-C31+F31-E31)","v":"00:00:00"},{"$f":"IF(AND(I31<>\"\",J31=\"\",K31=\"\"),\"F E R I E\",IF(AND(I31=\"\",J31<>\"\",K31=\"\"),\"P E R M E S S O   R E T R I B U I T O\",IF(AND(I31=\"\",J31=\"\",K31=1),\"M A L A T T I A\",IF(AND(I31=\"\",J31=\"\",K31=\"\"),\"\",\"IMMETTERE UN SOLO VALORE\"))))","v":""}]
[30,"M",null,null,null,null,{"$f":"IF(D32-C32+F32-E32<0,TIME(0,0,0),IF(D32-C32+F32-E32>TIME(8,0,0),TIME(8,0,0),D32-C32+F32-E32))","v":"00:00:00"},{"$f":"IF(D32-C32+F32-E32>TIME(8,0,0),L32-G32,TIME(0,0,0))","v":"00:00:00"},null,null,null,{"$f":"IF(D32-C32+F32-E32<0,TIME(0,0,0),D32-C32+F32-E32)","v":"00:00:00"},{"$f":"IF(AND(I32<>\"\",J32=\"\",K32=\"\"),\"F E R I E\",IF(AND(I32=\"\",J32<>\"\",K32=\"\"),\"P E R M E S S O   R E T R I B U I T O\",IF(AND(I32=\"\",J32=\"\",K32=1),\"M A L A T T I A\",IF(AND(I32=\"\",J32=\"\",K32=\"\"),\"\",\"IMMETTERE UN SOLO VALORE\"))))","v":""}]
[31,"M",null,null,null,null,{"$f":"IF(D33-C33+F33-E33<0,TIME(0,0,0),IF(D33-C33+F33-E33>TIME(8,0,0),TIME(8,0,0),D33-C33+F33-E33))","v":"00:00:00"},{"$f":"IF(D33-C33+F33-E33>TIME(8,0,0),L33-G33,TIME(0,0,0))","v":"00:00:00"},null,null,null,{"$f":"IF(D33-C33+F33-E33<0,TIME(0,0,0),D33-C33+F33-E33)","v":"00:00:00"},{"$f":"IF(AND(I33<>\"\",J33=\"\",K33=\"\"),\"F E R I E\",IF(AND(I33=\"\",J33<>\"\",K33=\"\"),\"P E R M E S S O   R E T R I B U I T O\",IF(AND(I33=\"\",J33=\"\",K33=1),\"M A L A T T I A\",IF(AND(I33=\"\",J33=\"\",K33=\"\"),\"\",\"IMMETTERE UN SOLO VALORE\"))))","v":""}]
["VISUALIZZA I TOTALI",null,null,null,null,null,{"$f":"SUM(G3:G33)*24","v":0},{"$f":"SUM(H3:H33)*24","v":0},{"$f":"SUM(I3:I33)","v":0},{"$f":"SUM(J3:J33)","v":0},{"$f":"SUM(K3:K33)","v":0},{"$f":"SUM(L3:L33)*24","v":0},"grafico"]
[null,null,null,null,null,null,null,null,"USATE","USATE"]
[null,null,null,null,null,null,null,null,{"$f":"I2-I34","v":160},{"$f":"J2-J34","v":104}]
[null,null,null,null,null,null,null,null,"RESTANTI","RESTANTI"]

{"sheet":"Giugno","index":7,"n_rows":37,"n_cols":13,"rows_kept":37,"cut":false,"hidden":false,"merged":[[33,12,36,12],[0,10,1,10],[0,11,1,11],[1,0,1,1],[33,6,36,6],[33,0,36,5],[33,7,36,7],[33,10,36,10],[33,11,36,11],[0,0,0,1],[0,2,0,3],[0,4,0,5],[0,6,1,6]]}
["GIUGNO '2017",null,"ORARIO MATTINE",null,"ORARIO POMERIGGI",null,"O R E  LAVORO","ORE straord.","ORE F E R I E","ORE P. A. R.","GIORNI DI MALATTIA","TOTALE     O R E"]
["GIORNO",null,"Entrata","entrata mensa","uscita mensa","Uscita",null,"al 25%",{"$f":"Maggio!I36","v":160},{"$f":"Maggio!J36","v":104},null,null,"NOTE VARIE"]
[1,"G",null,null,null,null,{"$f":"IF(D3-C3+F3-E3<0,TIME(0,0,0),IF(D3-C3+F3-E3>TIME(8,0,0),TIME(8,0,0),D3-C3+F3-E3))","v":"00:00:00"},{"$f":"IF(D3-C3+F3-E3>TIME(8,0,0),L3-G3,TIME(0,0,0))","v":"00:00:00"},null,null,null,{"$f":"IF(D3-C3+F3-E3<0,TIME(0,0,0),D3-C3+F3-E3)","v":"00:00:00"},{"$f":"IF(AND(I3<>\"\",J3=\"\",K3=\"\"),\"F E R I E\",IF(AND(I3=\"\",J3<>\"\",K3=\"\"),\"P E R M E S S O   R E T R I B U I T O\",IF(AND(I3=\"\",J3=\"\",K3=1),\"M A L A T T I A\",IF(AND(I3=\"\",J3=\"\",K3=\"\"),\"\",\"IMMETTERE UN SOLO VALORE\"))))","v":""}]
[2,"V",null,null,null,null,{"$f":"IF(D4-C4+F4-E4<0,TIME(0,0,0),IF(D4-C4+F4-E4>TIME(8,0,0),TIME(8,0,0),D4-C4+F4-E4))","v":"00:00:00"},{"$f":"IF(D4-C4+F4-E4>TIME(8,0,0),L4-G4,TIME(0,0,0))","v":"00:00:00"},null,null,null,{"$f":"IF(D4-C4+F4-E4<0,TIME(0,0,0),D4-C4+F4-E4)","v":"00:00:00"},{"$f":"IF(AND(I4<>\"\",J4=\"\",K4=\"\"),\"F E R I E\",IF(AND(I4=\"\",J4<>\"\",K4=\"\"),\"P E R M E S S O   R E T R I B U I T O\",IF(AND(I4=\"\",J4=\"\",K4=1),\"M A L A T T I A\",IF(AND(I4=\"\",J4=\"\",K4=\"\"),\"\",\"IMMETTERE UN SOLO VALORE\"))))","v":""}]
[3,"S",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[4,"D",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[5,"L",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[6,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[7,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[8,"G",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[9,"V",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[10,"S",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[11,"D",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[12,"L",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[13,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[14,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[15,"G",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[16,"V",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[17,"S",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[18,"D",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[19,"L",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[20,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[21,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[22,"G",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[23,"V",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[24,"S",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[25,"D",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[26,"L",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[27,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[28,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[29,"G",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[30,"V",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[]
["VISUALIZZA I TOTALI",null,null,null,null,null,{"$f":"SUM(G3:G33)*24","v":0},{"$f":"SUM(H3:H33)*24","v":0},{"$f":"SUM(I3:I33)","v":0},{"$f":"SUM(J3:J33)","v":0},{"$f":"SUM(K3:K33)","v":0},{"$f":"SUM(L3:L33)*24","v":0},"grafico"]
[null,null,null,null,null,null,null,null,"USATE","USATE"]
[null,null,null,null,null,null,null,null,{"$f":"I2-I34","v":160},{"$f":"J2-J34","v":104}]
[null,null,null,null,null,null,null,null,"RESTANTI","RESTANTI"]

{"sheet":"Luglio","index":8,"n_rows":37,"n_cols":13,"rows_kept":37,"cut":false,"hidden":false,"merged":[[33,12,36,12],[0,10,1,10],[0,11,1,11],[1,0,1,1],[33,6,36,6],[33,0,36,5],[33,7,36,7],[33,10,36,10],[33,11,36,11],[0,0,0,1],[0,2,0,3],[0,4,0,5],[0,6,1,6]]}
["LUGLIO '2017",null,"ORARIO MATTINE",null,"ORARIO POMERIGGI",null,"O R E  LAVORO","ORE straord.","ORE F E R I E","ORE P. A. R.","GIORNI DI MALATTIA","TOTALE     O R E"]
["GIORNO",null,"Entrata","entrata mensa","uscita mensa","Uscita",null,"al 25%",{"$f":"Giugno!I36","v":160},{"$f":"Giugno!J36","v":104},null,null,"NOTE VARIE"]
[1,"S",null,null,null,null,{"$f":"IF(D3-C3+F3-E3<0,TIME(0,0,0),IF(D3-C3+F3-E3>TIME(8,0,0),TIME(8,0,0),D3-C3+F3-E3))","v":"00:00:00"},{"$f":"IF(D3-C3+F3-E3>TIME(8,0,0),L3-G3,TIME(0,0,0))","v":"00:00:00"},null,null,null,{"$f":"IF(D3-C3+F3-E3<0,TIME(0,0,0),D3-C3+F3-E3)","v":"00:00:00"},{"$f":"IF(AND(I3<>\"\",J3=\"\",K3=\"\"),\"F E R I E\",IF(AND(I3=\"\",J3<>\"\",K3=\"\"),\"P E R M E S S O   R E T R I B U I T O\",IF(AND(I3=\"\",J3=\"\",K3=1),\"M A L A T T I A\",IF(AND(I3=\"\",J3=\"\",K3=\"\"),\"\",\"IMMETTERE UN SOLO VALORE\"))))","v":""}]
[2,"D",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[3,"L",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[4,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[5,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[6,"G",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[7,"V",null,null,null,null,{"$f":"IF(D9-C9+F9-E9<0,TIME(0,0,0),IF(D9-C9+F9-E9>TIME(8,0,0),TIME(8,0,0),D9-C9+F9-E9))","v":"00:00:00"},{"$f":"IF(D9-C9+F9-E9>TIME(8,0,0),L9-G9,TIME(0,0,0))","v":"00:00:00"},null,null,null,{"$f":"IF(D9-C9+F9-E9<0,TIME(0,0,0),D9-C9+F9-E9)","v":"00:00:00"},{"$f":"IF(AND(I9<>\"\",J9=\"\",K9=\"\"),\"F E R I E\",IF(AND(I9=\"\",J9<>\"\",K9=\"\"),\"P E R M E S S O   R E T R I B U I T O\",IF(AND(I9=\"\",J9=\"\",K9=1),\"M A L A T T I A\",IF(AND(I9=\"\",J9=\"\",K9=\"\"),\"\",\"IMMETTERE UN SOLO VALORE\"))))","v":""}]
[8,"S",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[9,"D",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[10,"L",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[11,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[12,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[13,"G",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[14,"V",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[15,"S",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[16,"D",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[17,"L",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[18,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[19,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[20,"G",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[21,"V",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[22,"S",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[23,"D",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[24,"L",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[25,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[26,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[27,"G",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[28,"V",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[29,"S",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[30,"D",null,null,null,null,{"$f":"IF(D32-C32+F32-E32<0,TIME(0,0,0),IF(D32-C32+F32-E32>TIME(8,0,0),TIME(8,0,0),D32-C32+F32-E32))","v":"00:00:00"},{"$f":"IF(D32-C32+F32-E32>TIME(8,0,0),L32-G32,TIME(0,0,0))","v":"00:00:00"},null,null,null,{"$f":"IF(D32-C32+F32-E32<0,TIME(0,0,0),D32-C32+F32-E32)","v":"00:00:00"},{"$f":"IF(AND(I32<>\"\",J32=\"\",K32=\"\"),\"F E R I E\",IF(AND(I32=\"\",J32<>\"\",K32=\"\"),\"P E R M E S S O   R E T R I B U I T O\",IF(AND(I32=\"\",J32=\"\",K32=1),\"M A L A T T I A\",IF(AND(I32=\"\",J32=\"\",K32=\"\"),\"\",\"IMMETTERE UN SOLO VALORE\"))))","v":""}]
[31,"L",null,null,null,null,{"$f":"IF(D33-C33+F33-E33<0,TIME(0,0,0),IF(D33-C33+F33-E33>TIME(8,0,0),TIME(8,0,0),D33-C33+F33-E33))","v":"00:00:00"},{"$f":"IF(D33-C33+F33-E33>TIME(8,0,0),L33-G33,TIME(0,0,0))","v":"00:00:00"},null,null,null,{"$f":"IF(D33-C33+F33-E33<0,TIME(0,0,0),D33-C33+F33-E33)","v":"00:00:00"},{"$f":"IF(AND(I33<>\"\",J33=\"\",K33=\"\"),\"F E R I E\",IF(AND(I33=\"\",J33<>\"\",K33=\"\"),\"P E R M E S S O   R E T R I B U I T O\",IF(AND(I33=\"\",J33=\"\",K33=1),\"M A L A T T I A\",IF(AND(I33=\"\",J33=\"\",K33=\"\"),\"\",\"IMMETTERE UN SOLO VALORE\"))))","v":""}]
["VISUALIZZA I TOTALI",null,null,null,null,null,{"$f":"SUM(G3:G33)*24","v":0},{"$f":"SUM(H3:H33)*24","v":0},{"$f":"SUM(I3:I33)","v":0},{"$f":"SUM(J3:J33)","v":0},{"$f":"SUM(K3:K33)","v":0},{"$f":"SUM(L3:L33)*24","v":0},"grafico"]
[null,null,null,null,null,null,null,null,"USATE","USATE"]
[null,null,null,null,null,null,null,null,{"$f":"I2-I34","v":160},{"$f":"J2-J34","v":104}]
[null,null,null,null,null,null,null,null,"RESTANTI","RESTANTI"]

{"sheet":"Agosto","index":9,"n_rows":37,"n_cols":13,"rows_kept":37,"cut":false,"hidden":false,"merged":[[33,12,36,12],[0,10,1,10],[0,11,1,11],[1,0,1,1],[33,6,36,6],[33,0,36,5],[33,7,36,7],[33,10,36,10],[33,11,36,11],[0,0,0,1],[0,2,0,3],[0,4,0,5],[0,6,1,6]]}
["AGOSTO '2017",null,"ORARIO MATTINE",null,"ORARIO POMERIGGI",null,"O R E  LAVORO","ORE straord.","ORE F E R I E","ORE P. A. R.","GIORNI DI MALATTIA","TOTALE     O R E"]
["GIORNO",null,"Entrata","entrata mensa","uscita mensa","Uscita",null,"al 25%",{"$f":"Luglio!I36","v":160},{"$f":"Luglio!J36","v":104},null,null,"NOTE VARIE"]
[1,"M",null,null,null,null,{"$f":"IF(D3-C3+F3-E3<0,TIME(0,0,0),IF(D3-C3+F3-E3>TIME(8,0,0),TIME(8,0,0),D3-C3+F3-E3))","v":"00:00:00"},{"$f":"IF(D3-C3+F3-E3>TIME(8,0,0),L3-G3,TIME(0,0,0))","v":"00:00:00"},null,null,null,{"$f":"IF(D3-C3+F3-E3<0,TIME(0,0,0),D3-C3+F3-E3)","v":"00:00:00"},{"$f":"IF(AND(I3<>\"\",J3=\"\",K3=\"\"),\"F E R I E\",IF(AND(I3=\"\",J3<>\"\",K3=\"\"),\"P E R M E S S O   R E T R I B U I T O\",IF(AND(I3=\"\",J3=\"\",K3=1),\"M A L A T T I A\",IF(AND(I3=\"\",J3=\"\",K3=\"\"),\"\",\"IMMETTERE UN SOLO VALORE\"))))","v":""}]
[2,"M",null,null,null,null,{"$f":"IF(D4-C4+F4-E4<0,TIME(0,0,0),IF(D4-C4+F4-E4>TIME(8,0,0),TIME(8,0,0),D4-C4+F4-E4))","v":"00:00:00"},{"$f":"IF(D4-C4+F4-E4>TIME(8,0,0),L4-G4,TIME(0,0,0))","v":"00:00:00"},null,null,null,{"$f":"IF(D4-C4+F4-E4<0,TIME(0,0,0),D4-C4+F4-E4)","v":"00:00:00"},{"$f":"IF(AND(I4<>\"\",J4=\"\",K4=\"\"),\"F E R I E\",IF(AND(I4=\"\",J4<>\"\",K4=\"\"),\"P E R M E S S O   R E T R I B U I T O\",IF(AND(I4=\"\",J4=\"\",K4=1),\"M A L A T T I A\",IF(AND(I4=\"\",J4=\"\",K4=\"\"),\"\",\"IMMETTERE UN SOLO VALORE\"))))","v":""}]
[3,"G",null,null,null,null,{"$f":"IF(D5-C5+F5-E5<0,TIME(0,0,0),IF(D5-C5+F5-E5>TIME(8,0,0),TIME(8,0,0),D5-C5+F5-E5))","v":"00:00:00"},{"$f":"IF(D5-C5+F5-E5>TIME(8,0,0),L5-G5,TIME(0,0,0))","v":"00:00:00"},null,null,null,{"$f":"IF(D5-C5+F5-E5<0,TIME(0,0,0),D5-C5+F5-E5)","v":"00:00:00"},{"$f":"IF(AND(I5<>\"\",J5=\"\",K5=\"\"),\"F E R I E\",IF(AND(I5=\"\",J5<>\"\",K5=\"\"),\"P E R M E S S O   R E T R I B U I T O\",IF(AND(I5=\"\",J5=\"\",K5=1),\"M A L A T T I A\",IF(AND(I5=\"\",J5=\"\",K5=\"\"),\"\",\"IMMETTERE UN SOLO VALORE\"))))","v":""}]
[4,"V",null,null,null,null,{"$f":"IF(D6-C6+F6-E6<0,TIME(0,0,0),IF(D6-C6+F6-E6>TIME(8,0,0),TIME(8,0,0),D6-C6+F6-E6))","v":"00:00:00"},{"$f":"IF(D6-C6+F6-E6>TIME(8,0,0),L6-G6,TIME(0,0,0))","v":"00:00:00"},null,null,null,{"$f":"IF(D6-C6+F6-E6<0,TIME(0,0,0),D6-C6+F6-E6)","v":"00:00:00"},{"$f":"IF(AND(I6<>\"\",J6=\"\",K6=\"\"),\"F E R I E\",IF(AND(I6=\"\",J6<>\"\",K6=\"\"),\"P E R M E S S O   R E T R I B U I T O\",IF(AND(I6=\"\",J6=\"\",K6=1),\"M A L A T T I A\",IF(AND(I6=\"\",J6=\"\",K6=\"\"),\"\",\"IMMETTERE UN SOLO VALORE\"))))","v":""}]
[5,"S",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[6,"D",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[7,"L",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[8,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[9,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[10,"G",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[11,"V",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[12,"S",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[13,"D",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[14,"L",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[15,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[16,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[17,"G",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[18,"V",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[19,"S",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[20,"D",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[21,"L",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[22,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[23,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[24,"G",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[25,"V",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[26,"S",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[27,"D",null,null,null,null,{"$f":"IF(D29-C29+F29-E29<0,TIME(0,0,0),IF(D29-C29+F29-E29>TIME(8,0,0),TIME(8,0,0),D29-C29+F29-E29))","v":"00:00:00"},{"$f":"IF(D29-C29+F29-E29>TIME(8,0,0),L29-G29,TIME(0,0,0))","v":"00:00:00"},null,null,null,{"$f":"IF(D29-C29+F29-E29<0,TIME(0,0,0),D29-C29+F29-E29)","v":"00:00:00"},{"$f":"IF(AND(I29<>\"\",J29=\"\",K29=\"\"),\"F E R I E\",IF(AND(I29=\"\",J29<>\"\",K29=\"\"),\"P E R M E S S O   R E T R I B U I T O\",IF(AND(I29=\"\",J29=\"\",K29=1),\"M A L A T T I A\",IF(AND(I29=\"\",J29=\"\",K29=\"\"),\"\",\"IMMETTERE UN SOLO VALORE\"))))","v":""}]
[28,"L",null,null,null,null,{"$f":"IF(D30-C30+F30-E30<0,TIME(0,0,0),IF(D30-C30+F30-E30>TIME(8,0,0),TIME(8,0,0),D30-C30+F30-E30))","v":"00:00:00"},{"$f":"IF(D30-C30+F30-E30>TIME(8,0,0),L30-G30,TIME(0,0,0))","v":"00:00:00"},null,null,null,{"$f":"IF(D30-C30+F30-E30<0,TIME(0,0,0),D30-C30+F30-E30)","v":"00:00:00"},{"$f":"IF(AND(I30<>\"\",J30=\"\",K30=\"\"),\"F E R I E\",IF(AND(I30=\"\",J30<>\"\",K30=\"\"),\"P E R M E S S O   R E T R I B U I T O\",IF(AND(I30=\"\",J30=\"\",K30=1),\"M A L A T T I A\",IF(AND(I30=\"\",J30=\"\",K30=\"\"),\"\",\"IMMETTERE UN SOLO VALORE\"))))","v":""}]
[29,"M",null,null,null,null,{"$f":"IF(D31-C31+F31-E31<0,TIME(0,0,0),IF(D31-C31+F31-E31>TIME(8,0,0),TIME(8,0,0),D31-C31+F31-E31))","v":"00:00:00"},{"$f":"IF(D31-C31+F31-E31>TIME(8,0,0),L31-G31,TIME(0,0,0))","v":"00:00:00"},null,null,null,{"$f":"IF(D31-C31+F31-E31<0,TIME(0,0,0),D31-C31+F31-E31)","v":"00:00:00"},{"$f":"IF(AND(I31<>\"\",J31=\"\",K31=\"\"),\"F E R I E\",IF(AND(I31=\"\",J31<>\"\",K31=\"\"),\"P E R M E S S O   R E T R I B U I T O\",IF(AND(I31=\"\",J31=\"\",K31=1),\"M A L A T T I A\",IF(AND(I31=\"\",J31=\"\",K31=\"\"),\"\",\"IMMETTERE UN SOLO VALORE\"))))","v":""}]
[30,"M",null,null,null,null,{"$f":"IF(D32-C32+F32-E32<0,TIME(0,0,0),IF(D32-C32+F32-E32>TIME(8,0,0),TIME(8,0,0),D32-C32+F32-E32))","v":"00:00:00"},{"$f":"IF(D32-C32+F32-E32>TIME(8,0,0),L32-G32,TIME(0,0,0))","v":"00:00:00"},null,null,null,{"$f":"IF(D32-C32+F32-E32<0,TIME(0,0,0),D32-C32+F32-E32)","v":"00:00:00"},{"$f":"IF(AND(I32<>\"\",J32=\"\",K32=\"\"),\"F E R I E\",IF(AND(I32=\"\",J32<>\"\",K32=\"\"),\"P E R M E S S O   R E T R I B U I T O\",IF(AND(I32=\"\",J32=\"\",K32=1),\"M A L A T T I A\",IF(AND(I32=\"\",J32=\"\",K32=\"\"),\"\",\"IMMETTERE UN SOLO VALORE\"))))","v":""}]
[31,"G",null,null,null,null,{"$f":"IF(D33-C33+F33-E33<0,TIME(0,0,0),IF(D33-C33+F33-E33>TIME(8,0,0),TIME(8,0,0),D33-C33+F33-E33))","v":"00:00:00"},{"$f":"IF(D33-C33+F33-E33>TIME(8,0,0),L33-G33,TIME(0,0,0))","v":"00:00:00"},null,null,null,{"$f":"IF(D33-C33+F33-E33<0,TIME(0,0,0),D33-C33+F33-E33)","v":"00:00:00"},{"$f":"IF(AND(I33<>\"\",J33=\"\",K33=\"\"),\"F E R I E\",IF(AND(I33=\"\",J33<>\"\",K33=\"\"),\"P E R M E S S O   R E T R I B U I T O\",IF(AND(I33=\"\",J33=\"\",K33=1),\"M A L A T T I A\",IF(AND(I33=\"\",J33=\"\",K33=\"\"),\"\",\"IMMETTERE UN SOLO VALORE\"))))","v":""}]
["VISUALIZZA I TOTALI",null,null,null,null,null,{"$f":"SUM(G3:G33)*24","v":0},{"$f":"SUM(H3:H33)*24","v":0},{"$f":"SUM(I3:I33)","v":0},{"$f":"SUM(J3:J33)","v":0},{"$f":"SUM(K3:K33)","v":0},{"$f":"SUM(L3:L33)*24","v":0},"grafico"]
[null,null,null,null,null,null,null,null,"USATE","USATE"]
[null,null,null,null,null,null,null,null,{"$f":"I2-I34","v":160},{"$f":"J2-J34","v":104}]
[null,null,null,null,null,null,null,null,"RESTANTI","RESTANTI"]

{"sheet":"Settembre","index":10,"n_rows":37,"n_cols":13,"rows_kept":37,"cut":false,"hidden":false,"merged":[[33,12,36,12],[0,10,1,10],[0,11,1,11],[1,0,1,1],[33,6,36,6],[33,0,36,5],[33,7,36,7],[33,10,36,10],[33,11,36,11],[0,0,0,1],[0,2,0,3],[0,4,0,5],[0,6,1,6]]}
["SETTEMBRE '2017",null,"ORARIO MATTINE",null,"ORARIO POMERIGGI",null,"O R E  LAVORO","ORE straord.","ORE F E R I E","ORE P. A. R.","GIORNI DI MALATTIA","TOTALE     O R E"]
["GIORNO",null,"Entrata","entrata mensa","uscita mensa","Uscita",null,"al 25%",{"$f":"Agosto!I36","v":160},{"$f":"Agosto!J36","v":104},null,null,"NOTE VARIE"]
[1,"V",null,null,null,null,{"$f":"IF(D3-C3+F3-E3<0,TIME(0,0,0),IF(D3-C3+F3-E3>TIME(8,0,0),TIME(8,0,0),D3-C3+F3-E3))","v":"00:00:00"},{"$f":"IF(D3-C3+F3-E3>TIME(8,0,0),L3-G3,TIME(0,0,0))","v":"00:00:00"},null,null,null,{"$f":"IF(D3-C3+F3-E3<0,TIME(0,0,0),D3-C3+F3-E3)","v":"00:00:00"},{"$f":"IF(AND(I3<>\"\",J3=\"\",K3=\"\"),\"F E R I E\",IF(AND(I3=\"\",J3<>\"\",K3=\"\"),\"P E R M E S S O   R E T R I B U I T O\",IF(AND(I3=\"\",J3=\"\",K3=1),\"M A L A T T I A\",IF(AND(I3=\"\",J3=\"\",K3=\"\"),\"\",\"IMMETTERE UN SOLO VALORE\"))))","v":""}]
[2,"S",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[3,"D",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[4,"L",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[5,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[6,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[7,"G",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[8,"V",null,null,null,null,{"$f":"IF(D10-C10+F10-E10<0,TIME(0,0,0),IF(D10-C10+F10-E10>TIME(8,0,0),TIME(8,0,0),D10-C10+F10-E10))","v":"00:00:00"},{"$f":"IF(D10-C10+F10-E10>TIME(8,0,0),L10-G10,TIME(0,0,0))","v":"00:00:00"},null,null,null,{"$f":"IF(D10-C10+F10-E10<0,TIME(0,0,0),D10-C10+F10-E10)","v":"00:00:00"},{"$f":"IF(AND(I10<>\"\",J10=\"\",K10=\"\"),\"F E R I E\",IF(AND(I10=\"\",J10<>\"\",K10=\"\"),\"P E R M E S S O   R E T R I B U I T O\",IF(AND(I10=\"\",J10=\"\",K10=1),\"M A L A T T I A\",IF(AND(I10=\"\",J10=\"\",K10=\"\"),\"\",\"IMMETTERE UN SOLO VALORE\"))))","v":""}]
[9,"S",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[10,"D",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[11,"L",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[12,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[13,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[14,"G",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[15,"V",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[16,"S",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[17,"D",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[18,"L",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[19,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[20,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[21,"G",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[22,"V",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[23,"S",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[24,"D",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[25,"L",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[26,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[27,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[28,"G",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[29,"V",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[30,"S",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[]
["VISUALIZZA I TOTALI",null,null,null,null,null,{"$f":"SUM(G3:G33)*24","v":0},{"$f":"SUM(H3:H33)*24","v":0},{"$f":"SUM(I3:I33)","v":0},{"$f":"SUM(J3:J33)","v":0},{"$f":"SUM(K3:K33)","v":0},{"$f":"SUM(L3:L33)*24","v":0},"grafico"]
[null,null,null,null,null,null,null,null,"USATE","USATE"]
[null,null,null,null,null,null,null,null,{"$f":"I2-I34","v":160},{"$f":"J2-J34","v":104}]
[null,null,null,null,null,null,null,null,"RESTANTI","RESTANTI"]

{"sheet":"Ottobre","index":11,"n_rows":37,"n_cols":13,"rows_kept":37,"cut":false,"hidden":false,"merged":[[33,12,36,12],[0,10,1,10],[0,11,1,11],[1,0,1,1],[33,6,36,6],[33,0,36,5],[33,7,36,7],[33,10,36,10],[33,11,36,11],[0,0,0,1],[0,2,0,3],[0,4,0,5],[0,6,1,6]]}
["OTTOBRE '2017",null,"ORARIO MATTINE",null,"ORARIO POMERIGGI",null,"O R E  LAVORO","ORE straord.","ORE F E R I E","ORE P. A. R.","GIORNI DI MALATTIA","TOTALE     O R E"]
["GIORNO",null,"Entrata","entrata mensa","uscita mensa","Uscita",null,"al 25%",{"$f":"Settembre!I36","v":160},{"$f":"Settembre!J36","v":104},null,null,"NOTE VARIE"]
[1,"D",null,null,null,null,{"$f":"IF(D3-C3+F3-E3<0,TIME(0,0,0),IF(D3-C3+F3-E3>TIME(8,0,0),TIME(8,0,0),D3-C3+F3-E3))","v":"00:00:00"},{"$f":"IF(D3-C3+F3-E3>TIME(8,0,0),L3-G3,TIME(0,0,0))","v":"00:00:00"},null,null,null,{"$f":"IF(D3-C3+F3-E3<0,TIME(0,0,0),D3-C3+F3-E3)","v":"00:00:00"},{"$f":"IF(AND(I3<>\"\",J3=\"\",K3=\"\"),\"F E R I E\",IF(AND(I3=\"\",J3<>\"\",K3=\"\"),\"P E R M E S S O   R E T R I B U I T O\",IF(AND(I3=\"\",J3=\"\",K3=1),\"M A L A T T I A\",IF(AND(I3=\"\",J3=\"\",K3=\"\"),\"\",\"IMMETTERE UN SOLO VALORE\"))))","v":""}]
[2,"L",null,null,null,null,{"$f":"IF(D4-C4+F4-E4<0,TIME(0,0,0),IF(D4-C4+F4-E4>TIME(8,0,0),TIME(8,0,0),D4-C4+F4-E4))","v":"00:00:00"},{"$f":"IF(D4-C4+F4-E4>TIME(8,0,0),L4-G4,TIME(0,0,0))","v":"00:00:00"},null,null,null,{"$f":"IF(D4-C4+F4-E4<0,TIME(0,0,0),D4-C4+F4-E4)","v":"00:00:00"},{"$f":"IF(AND(I4<>\"\",J4=\"\",K4=\"\"),\"F E R I E\",IF(AND(I4=\"\",J4<>\"\",K4=\"\"),\"P E R M E S S O   R E T R I B U I T O\",IF(AND(I4=\"\",J4=\"\",K4=1),\"M A L A T T I A\",IF(AND(I4=\"\",J4=\"\",K4=\"\"),\"\",\"IMMETTERE UN SOLO VALORE\"))))","v":""}]
[3,"M",null,null,null,null,{"$f":"IF(D5-C5+F5-E5<0,TIME(0,0,0),IF(D5-C5+F5-E5>TIME(8,0,0),TIME(8,0,0),D5-C5+F5-E5))","v":"00:00:00"},{"$f":"IF(D5-C5+F5-E5>TIME(8,0,0),L5-G5,TIME(0,0,0))","v":"00:00:00"},null,null,null,{"$f":"IF(D5-C5+F5-E5<0,TIME(0,0,0),D5-C5+F5-E5)","v":"00:00:00"},{"$f":"IF(AND(I5<>\"\",J5=\"\",K5=\"\"),\"F E R I E\",IF(AND(I5=\"\",J5<>\"\",K5=\"\"),\"P E R M E S S O   R E T R I B U I T O\",IF(AND(I5=\"\",J5=\"\",K5=1),\"M A L A T T I A\",IF(AND(I5=\"\",J5=\"\",K5=\"\"),\"\",\"IMMETTERE UN SOLO VALORE\"))))","v":""}]
[4,"M",null,null,null,null,{"$f":"IF(D6-C6+F6-E6<0,TIME(0,0,0),IF(D6-C6+F6-E6>TIME(8,0,0),TIME(8,0,0),D6-C6+F6-E6))","v":"00:00:00"},{"$f":"IF(D6-C6+F6-E6>TIME(8,0,0),L6-G6,TIME(0,0,0))","v":"00:00:00"},null,null,null,{"$f":"IF(D6-C6+F6-E6<0,TIME(0,0,0),D6-C6+F6-E6)","v":"00:00:00"},{"$f":"IF(AND(I6<>\"\",J6=\"\",K6=\"\"),\"F E R I E\",IF(AND(I6=\"\",J6<>\"\",K6=\"\"),\"P E R M E S S O   R E T R I B U I T O\",IF(AND(I6=\"\",J6=\"\",K6=1),\"M A L A T T I A\",IF(AND(I6=\"\",J6=\"\",K6=\"\"),\"\",\"IMMETTERE UN SOLO VALORE\"))))","v":""}]
[5,"G",null,null,null,null,{"$f":"IF(D7-C7+F7-E7<0,TIME(0,0,0),IF(D7-C7+F7-E7>TIME(8,0,0),TIME(8,0,0),D7-C7+F7-E7))","v":"00:00:00"},{"$f":"IF(D7-C7+F7-E7>TIME(8,0,0),L7-G7,TIME(0,0,0))","v":"00:00:00"},null,null,null,{"$f":"IF(D7-C7+F7-E7<0,TIME(0,0,0),D7-C7+F7-E7)","v":"00:00:00"},{"$f":"IF(AND(I7<>\"\",J7=\"\",K7=\"\"),\"F E R I E\",IF(AND(I7=\"\",J7<>\"\",K7=\"\"),\"P E R M E S S O   R E T R I B U I T O\",IF(AND(I7=\"\",J7=\"\",K7=1),\"M A L A T T I A\",IF(AND(I7=\"\",J7=\"\",K7=\"\"),\"\",\"IMMETTERE UN SOLO VALORE\"))))","v":""}]
[6,"V",null,null,null,null,{"$f":"IF(D8-C8+F8-E8<0,TIME(0,0,0),IF(D8-C8+F8-E8>TIME(8,0,0),TIME(8,0,0),D8-C8+F8-E8))","v":"00:00:00"},{"$f":"IF(D8-C8+F8-E8>TIME(8,0,0),L8-G8,TIME(0,0,0))","v":"00:00:00"},null,null,null,{"$f":"IF(D8-C8+F8-E8<0,TIME(0,0,0),D8-C8+F8-E8)","v":"00:00:00"},{"$f":"IF(AND(I8<>\"\",J8=\"\",K8=\"\"),\"F E R I E\",IF(AND(I8=\"\",J8<>\"\",K8=\"\"),\"P E R M E S S O   R E T R I B U I T O\",IF(AND(I8=\"\",J8=\"\",K8=1),\"M A L A T T I A\",IF(AND(I8=\"\",J8=\"\",K8=\"\"),\"\",\"IMMETTERE UN SOLO VALORE\"))))","v":""}]
[7,"S",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[8,"D",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[9,"L",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[10,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[11,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[12,"G",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[13,"V",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[14,"S",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[15,"D",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[16,"L",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[17,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[18,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[19,"G",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[20,"V",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[21,"S",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[22,"D",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[23,"L",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[24,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[25,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[26,"G",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[27,"V",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[28,"S",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[29,"D",null,null,null,null,{"$f":"IF(D31-C31+F31-E31<0,TIME(0,0,0),IF(D31-C31+F31-E31>TIME(8,0,0),TIME(8,0,0),D31-C31+F31-E31))","v":"00:00:00"},{"$f":"IF(D31-C31+F31-E31>TIME(8,0,0),L31-G31,TIME(0,0,0))","v":"00:00:00"},null,null,null,{"$f":"IF(D31-C31+F31-E31<0,TIME(0,0,0),D31-C31+F31-E31)","v":"00:00:00"},{"$f":"IF(AND(I31<>\"\",J31=\"\",K31=\"\"),\"F E R I E\",IF(AND(I31=\"\",J31<>\"\",K31=\"\"),\"P E R M E S S O   R E T R I B U I T O\",IF(AND(I31=\"\",J31=\"\",K31=1),\"M A L A T T I A\",IF(AND(I31=\"\",J31=\"\",K31=\"\"),\"\",\"IMMETTERE UN SOLO VALORE\"))))","v":""}]
[30,"L",null,null,null,null,{"$f":"IF(D32-C32+F32-E32<0,TIME(0,0,0),IF(D32-C32+F32-E32>TIME(8,0,0),TIME(8,0,0),D32-C32+F32-E32))","v":"00:00:00"},{"$f":"IF(D32-C32+F32-E32>TIME(8,0,0),L32-G32,TIME(0,0,0))","v":"00:00:00"},null,null,null,{"$f":"IF(D32-C32+F32-E32<0,TIME(0,0,0),D32-C32+F32-E32)","v":"00:00:00"},{"$f":"IF(AND(I32<>\"\",J32=\"\",K32=\"\"),\"F E R I E\",IF(AND(I32=\"\",J32<>\"\",K32=\"\"),\"P E R M E S S O   R E T R I B U I T O\",IF(AND(I32=\"\",J32=\"\",K32=1),\"M A L A T T I A\",IF(AND(I32=\"\",J32=\"\",K32=\"\"),\"\",\"IMMETTERE UN SOLO VALORE\"))))","v":""}]
[31,"M",null,null,null,null,{"$f":"IF(D33-C33+F33-E33<0,TIME(0,0,0),IF(D33-C33+F33-E33>TIME(8,0,0),TIME(8,0,0),D33-C33+F33-E33))","v":"00:00:00"},{"$f":"IF(D33-C33+F33-E33>TIME(8,0,0),L33-G33,TIME(0,0,0))","v":"00:00:00"},null,null,null,{"$f":"IF(D33-C33+F33-E33<0,TIME(0,0,0),D33-C33+F33-E33)","v":"00:00:00"},{"$f":"IF(AND(I33<>\"\",J33=\"\",K33=\"\"),\"F E R I E\",IF(AND(I33=\"\",J33<>\"\",K33=\"\"),\"P E R M E S S O   R E T R I B U I T O\",IF(AND(I33=\"\",J33=\"\",K33=1),\"M A L A T T I A\",IF(AND(I33=\"\",J33=\"\",K33=\"\"),\"\",\"IMMETTERE UN SOLO VALORE\"))))","v":""}]
["VISUALIZZA I TOTALI",null,null,null,null,null,{"$f":"SUM(G3:G33)*24","v":0},{"$f":"SUM(H3:H33)*24","v":0},{"$f":"SUM(I3:I33)","v":0},{"$f":"SUM(J3:J33)","v":0},{"$f":"SUM(K3:K33)","v":0},{"$f":"SUM(L3:L33)*24","v":0},"grafico"]
[null,null,null,null,null,null,null,null,"USATE","USATE"]
[null,null,null,null,null,null,null,null,{"$f":"I2-I34","v":160},{"$f":"J2-J34","v":104}]
[null,null,null,null,null,null,null,null,"RESTANTI","RESTANTI"]

{"sheet":"Novembre","index":12,"n_rows":37,"n_cols":13,"rows_kept":37,"cut":false,"hidden":false,"merged":[[33,12,36,12],[0,10,1,10],[0,11,1,11],[1,0,1,1],[33,6,36,6],[33,0,36,5],[33,7,36,7],[33,10,36,10],[33,11,36,11],[0,0,0,1],[0,2,0,3],[0,4,0,5],[0,6,1,6]]}
["NOVEMBRE '2017",null,"ORARIO MATTINE",null,"ORARIO POMERIGGI",null,"O R E  LAVORO","ORE straord.","ORE F E R I E","ORE P. A. R.","GIORNI DI MALATTIA","TOTALE     O R E"]
["GIORNO",null,"Entrata","entrata mensa","uscita mensa","Uscita",null,"al 25%",{"$f":"Ottobre!I36","v":160},{"$f":"Ottobre!J36","v":104},null,null,"NOTE VARIE"]
[1,"M",null,null,null,null,{"$f":"IF(D3-C3+F3-E3<0,TIME(0,0,0),IF(D3-C3+F3-E3>TIME(8,0,0),TIME(8,0,0),D3-C3+F3-E3))","v":"00:00:00"},{"$f":"IF(D3-C3+F3-E3>TIME(8,0,0),L3-G3,TIME(0,0,0))","v":"00:00:00"},null,null,null,{"$f":"IF(D3-C3+F3-E3<0,TIME(0,0,0),D3-C3+F3-E3)","v":"00:00:00"},{"$f":"IF(AND(I3<>\"\",J3=\"\",K3=\"\"),\"F E R I E\",IF(AND(I3=\"\",J3<>\"\",K3=\"\"),\"P E R M E S S O   R E T R I B U I T O\",IF(AND(I3=\"\",J3=\"\",K3=1),\"M A L A T T I A\",IF(AND(I3=\"\",J3=\"\",K3=\"\"),\"\",\"IMMETTERE UN SOLO VALORE\"))))","v":""}]
[2,"G",null,null,null,null,{"$f":"IF(D4-C4+F4-E4<0,TIME(0,0,0),IF(D4-C4+F4-E4>TIME(8,0,0),TIME(8,0,0),D4-C4+F4-E4))","v":"00:00:00"},{"$f":"IF(D4-C4+F4-E4>TIME(8,0,0),L4-G4,TIME(0,0,0))","v":"00:00:00"},null,null,null,{"$f":"IF(D4-C4+F4-E4<0,TIME(0,0,0),D4-C4+F4-E4)","v":"00:00:00"},{"$f":"IF(AND(I4<>\"\",J4=\"\",K4=\"\"),\"F E R I E\",IF(AND(I4=\"\",J4<>\"\",K4=\"\"),\"P E R M E S S O   R E T R I B U I T O\",IF(AND(I4=\"\",J4=\"\",K4=1),\"M A L A T T I A\",IF(AND(I4=\"\",J4=\"\",K4=\"\"),\"\",\"IMMETTERE UN SOLO VALORE\"))))","v":""}]
[3,"V",null,null,null,null,{"$f":"IF(D5-C5+F5-E5<0,TIME(0,0,0),IF(D5-C5+F5-E5>TIME(8,0,0),TIME(8,0,0),D5-C5+F5-E5))","v":"00:00:00"},{"$f":"IF(D5-C5+F5-E5>TIME(8,0,0),L5-G5,TIME(0,0,0))","v":"00:00:00"},null,null,null,{"$f":"IF(D5-C5+F5-E5<0,TIME(0,0,0),D5-C5+F5-E5)","v":"00:00:00"},{"$f":"IF(AND(I5<>\"\",J5=\"\",K5=\"\"),\"F E R I E\",IF(AND(I5=\"\",J5<>\"\",K5=\"\"),\"P E R M E S S O   R E T R I B U I T O\",IF(AND(I5=\"\",J5=\"\",K5=1),\"M A L A T T I A\",IF(AND(I5=\"\",J5=\"\",K5=\"\"),\"\",\"IMMETTERE UN SOLO VALORE\"))))","v":""}]
[4,"S",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[5,"D",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[6,"L",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[7,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[8,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[9,"G",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[10,"V",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[11,"S",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[12,"D",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[13,"L",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[14,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[15,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[16,"G",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[17,"V",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[18,"S",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[19,"D",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[20,"L",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[21,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[22,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[23,"G",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[24,"V",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[25,"S",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[26,"D",null,null,null,null,{"$f":"IF(D28-C28+F28-E28<0,TIME(0,0,0),IF(D28-C28+F28-E28>TIME(8,0,0),TIME(8,0,0),D28-C28+F28-E28))","v":"00:00:00"},{"$f":"IF(D28-C28+F28-E28>TIME(8,0,0),L28-G28,TIME(0,0,0))","v":"00:00:00"},null,null,null,{"$f":"IF(D28-C28+F28-E28<0,TIME(0,0,0),D28-C28+F28-E28)","v":"00:00:00"},{"$f":"IF(AND(I28<>\"\",J28=\"\",K28=\"\"),\"F E R I E\",IF(AND(I28=\"\",J28<>\"\",K28=\"\"),\"P E R M E S S O   R E T R I B U I T O\",IF(AND(I28=\"\",J28=\"\",K28=1),\"M A L A T T I A\",IF(AND(I28=\"\",J28=\"\",K28=\"\"),\"\",\"IMMETTERE UN SOLO VALORE\"))))","v":""}]
[27,"L",null,null,null,null,{"$f":"IF(D29-C29+F29-E29<0,TIME(0,0,0),IF(D29-C29+F29-E29>TIME(8,0,0),TIME(8,0,0),D29-C29+F29-E29))","v":"00:00:00"},{"$f":"IF(D29-C29+F29-E29>TIME(8,0,0),L29-G29,TIME(0,0,0))","v":"00:00:00"},null,null,null,{"$f":"IF(D29-C29+F29-E29<0,TIME(0,0,0),D29-C29+F29-E29)","v":"00:00:00"},{"$f":"IF(AND(I29<>\"\",J29=\"\",K29=\"\"),\"F E R I E\",IF(AND(I29=\"\",J29<>\"\",K29=\"\"),\"P E R M E S S O   R E T R I B U I T O\",IF(AND(I29=\"\",J29=\"\",K29=1),\"M A L A T T I A\",IF(AND(I29=\"\",J29=\"\",K29=\"\"),\"\",\"IMMETTERE UN SOLO VALORE\"))))","v":""}]
[28,"M",null,null,null,null,{"$f":"IF(D30-C30+F30-E30<0,TIME(0,0,0),IF(D30-C30+F30-E30>TIME(8,0,0),TIME(8,0,0),D30-C30+F30-E30))","v":"00:00:00"},{"$f":"IF(D30-C30+F30-E30>TIME(8,0,0),L30-G30,TIME(0,0,0))","v":"00:00:00"},null,null,null,{"$f":"IF(D30-C30+F30-E30<0,TIME(0,0,0),D30-C30+F30-E30)","v":"00:00:00"},{"$f":"IF(AND(I30<>\"\",J30=\"\",K30=\"\"),\"F E R I E\",IF(AND(I30=\"\",J30<>\"\",K30=\"\"),\"P E R M E S S O   R E T R I B U I T O\",IF(AND(I30=\"\",J30=\"\",K30=1),\"M A L A T T I A\",IF(AND(I30=\"\",J30=\"\",K30=\"\"),\"\",\"IMMETTERE UN SOLO VALORE\"))))","v":""}]
[29,"M",null,null,null,null,{"$f":"IF(D31-C31+F31-E31<0,TIME(0,0,0),IF(D31-C31+F31-E31>TIME(8,0,0),TIME(8,0,0),D31-C31+F31-E31))","v":"00:00:00"},{"$f":"IF(D31-C31+F31-E31>TIME(8,0,0),L31-G31,TIME(0,0,0))","v":"00:00:00"},null,null,null,{"$f":"IF(D31-C31+F31-E31<0,TIME(0,0,0),D31-C31+F31-E31)","v":"00:00:00"},{"$f":"IF(AND(I31<>\"\",J31=\"\",K31=\"\"),\"F E R I E\",IF(AND(I31=\"\",J31<>\"\",K31=\"\"),\"P E R M E S S O   R E T R I B U I T O\",IF(AND(I31=\"\",J31=\"\",K31=1),\"M A L A T T I A\",IF(AND(I31=\"\",J31=\"\",K31=\"\"),\"\",\"IMMETTERE UN SOLO VALORE\"))))","v":""}]
[30,"G",null,null,null,null,{"$f":"IF(D32-C32+F32-E32<0,TIME(0,0,0),IF(D32-C32+F32-E32>TIME(8,0,0),TIME(8,0,0),D32-C32+F32-E32))","v":"00:00:00"},{"$f":"IF(D32-C32+F32-E32>TIME(8,0,0),L32-G32,TIME(0,0,0))","v":"00:00:00"},null,null,null,{"$f":"IF(D32-C32+F32-E32<0,TIME(0,0,0),D32-C32+F32-E32)","v":"00:00:00"},{"$f":"IF(AND(I32<>\"\",J32=\"\",K32=\"\"),\"F E R I E\",IF(AND(I32=\"\",J32<>\"\",K32=\"\"),\"P E R M E S S O   R E T R I B U I T O\",IF(AND(I32=\"\",J32=\"\",K32=1),\"M A L A T T I A\",IF(AND(I32=\"\",J32=\"\",K32=\"\"),\"\",\"IMMETTERE UN SOLO VALORE\"))))","v":""}]
[]
["VISUALIZZA I TOTALI",null,null,null,null,null,{"$f":"SUM(G3:G33)*24","v":0},{"$f":"SUM(H3:H33)*24","v":0},{"$f":"SUM(I3:I33)","v":0},{"$f":"SUM(J3:J33)","v":0},{"$f":"SUM(K3:K33)","v":0},{"$f":"SUM(L3:L33)*24","v":0},"grafico"]
[null,null,null,null,null,null,null,null,"USATE","USATE"]
[null,null,null,null,null,null,null,null,{"$f":"I2-I34","v":160},{"$f":"J2-J34","v":104}]
[null,null,null,null,null,null,null,null,"RESTANTI","RESTANTI"]

{"sheet":"Dicembre","index":13,"n_rows":37,"n_cols":13,"rows_kept":37,"cut":false,"hidden":false,"merged":[[33,12,36,12],[0,10,1,10],[0,11,1,11],[1,0,1,1],[33,6,36,6],[33,0,36,5],[33,7,36,7],[33,10,36,10],[33,11,36,11],[0,0,0,1],[0,2,0,3],[0,4,0,5],[0,6,1,6]]}
["DICEMBRE '2017",null,"ORARIO MATTINE",null,"ORARIO POMERIGGI",null,"O R E  LAVORO","ORE straord.","ORE F E R I E","ORE P. A. R.","GIORNI DI MALATTIA","TOTALE     O R E"]
["GIORNO",null,"Entrata","entrata mensa","uscita mensa","Uscita",null,"al 25%",{"$f":"Novembre!I36","v":160},{"$f":"Novembre!J36","v":104},null,null,"NOTE VARIE"]
[1,"V",null,null,null,null,{"$f":"IF(D3-C3+F3-E3<0,TIME(0,0,0),IF(D3-C3+F3-E3>TIME(8,0,0),TIME(8,0,0),D3-C3+F3-E3))","v":"00:00:00"},{"$f":"IF(D3-C3+F3-E3>TIME(8,0,0),L3-G3,TIME(0,0,0))","v":"00:00:00"},null,null,null,{"$f":"IF(D3-C3+F3-E3<0,TIME(0,0,0),D3-C3+F3-E3)","v":"00:00:00"},{"$f":"IF(AND(I3<>\"\",J3=\"\",K3=\"\"),\"F E R I E\",IF(AND(I3=\"\",J3<>\"\",K3=\"\"),\"P E R M E S S O   R E T R I B U I T O\",IF(AND(I3=\"\",J3=\"\",K3=1),\"M A L A T T I A\",IF(AND(I3=\"\",J3=\"\",K3=\"\"),\"\",\"IMMETTERE UN SOLO VALORE\"))))","v":""}]
[2,"S",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[3,"D",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[4,"L",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[5,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[6,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[7,"G",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[8,"V",null,null,null,null,{"$f":"IF(D10-C10+F10-E10<0,TIME(0,0,0),IF(D10-C10+F10-E10>TIME(8,0,0),TIME(8,0,0),D10-C10+F10-E10))","v":"00:00:00"},{"$f":"IF(D10-C10+F10-E10>TIME(8,0,0),L10-G10,TIME(0,0,0))","v":"00:00:00"},null,null,null,{"$f":"IF(D10-C10+F10-E10<0,TIME(0,0,0),D10-C10+F10-E10)","v":"00:00:00"},{"$f":"IF(AND(I10<>\"\",J10=\"\",K10=\"\"),\"F E R I E\",IF(AND(I10=\"\",J10<>\"\",K10=\"\"),\"P E R M E S S O   R E T R I B U I T O\",IF(AND(I10=\"\",J10=\"\",K10=1),\"M A L A T T I A\",IF(AND(I10=\"\",J10=\"\",K10=\"\"),\"\",\"IMMETTERE UN SOLO VALORE\"))))","v":""}]
[9,"S",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[10,"D",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[11,"L",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[12,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[13,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[14,"G",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[15,"V",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[16,"S",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[17,"D",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[18,"L",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[19,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[20,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[21,"G",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[22,"V",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[23,"S",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[24,"D",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[25,"L",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[26,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[27,"M",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[28,"G",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[29,"V",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[30,"S",null,null,null,null,"00:00:00","00:00:00",null,null,null,"00:00:00",""]
[31,"D",null,null,null,null,{"$f":"IF(D33-C33+F33-E33<0,TIME(0,0,0),IF(D33-C33+F33-E33>TIME(8,0,0),TIME(8,0,0),D33-C33+F33-E33))","v":"00:00:00"},{"$f":"IF(D33-C33+F33-E33>TIME(8,0,0),L33-G33,TIME(0,0,0))","v":"00:00:00"},null,null,null,{"$f":"IF(D33-C33+F33-E33<0,TIME(0,0,0),D33-C33+F33-E33)","v":"00:00:00"},{"$f":"IF(AND(I33<>\"\",J33=\"\",K33=\"\"),\"F E R I E\",IF(AND(I33=\"\",J33<>\"\",K33=\"\"),\"P E R M E S S O   R E T R I B U I T O\",IF(AND(I33=\"\",J33=\"\",K33=1),\"M A L A T T I A\",IF(AND(I33=\"\",J33=\"\",K33=\"\"),\"\",\"IMMETTERE UN SOLO VALORE\"))))","v":""}]
["VISUALIZZA I TOTALI",null,null,null,null,null,{"$f":"SUM(G3:G33)*24","v":0},{"$f":"SUM(H3:H33)*24","v":0},{"$f":"SUM(I3:I33)","v":0},{"$f":"SUM(J3:J33)","v":0},{"$f":"SUM(K3:K33)","v":0},{"$f":"SUM(L3:L33)*24","v":0},"grafico"]
[null,null,null,null,null,null,null,null,"USATE","USATE"]
[null,null,null,null,null,null,null,null,{"$f":"I2-I34","v":160},{"$f":"J2-J34","v":104}]
[null,null,null,null,null,null,null,null,"RESTANTI","RESTANTI"]

{"sheet":"TOTALI","index":14,"n_rows":48,"n_cols":14,"rows_kept":48,"cut":false,"hidden":false,"merged":[[0,0,0,13]]}
[]
["GRAFICO TOTALI","ORE LAVORATE",null,"Straordinari al 25%",null,"TOTALE ORE",null,"ORE FERIE GODUTE",null,"ORE P.A.R. GODUTE",null,"ORE DI MALATTIA",null,"TOTALI MENSILI"]
["Gennaio",{"$f":"Gennaio!G34","v":0},null,{"$f":"Gennaio!H34","v":0},null,{"$f":"B3+D3","v":0},null,{"$f":"Gennaio!I34","v":0},null,{"$f":"Gennaio!J34","v":0},null,{"$f":"Gennaio!K34*8","v":0},null,{"$f":"F3+H3+J3+L3","v":0}]
["Febbraio",{"$f":"Febbraio!G34","v":0},null,{"$f":"Febbraio!H34","v":0},null,0,null,{"$f":"Febbraio!I34","v":0},null,{"$f":"Febbraio!J34","v":0},null,{"$f":"Febbraio!K34*8","v":0},null,0]
["Marzo",{"$f":"Marzo!G34","v":0},null,{"$f":"Marzo!H34","v":0},null,0,null,{"$f":"Marzo!I34","v":0},null,{"$f":"Marzo!J34","v":0},null,{"$f":"Marzo!K34*8","v":0},null,0]
["Aprile",{"$f":"Aprile!G34","v":0},null,{"$f":"Aprile!H34","v":0},null,0,null,{"$f":"Aprile!I34","v":0},null,{"$f":"Aprile!J34","v":0},null,{"$f":"Aprile!K34*8","v":0},null,0]
["Maggio",{"$f":"Maggio!G34","v":0},null,{"$f":"Maggio!H34","v":0},null,0,null,{"$f":"Maggio!I34","v":0},null,{"$f":"Maggio!J34","v":0},null,{"$f":"Maggio!K34*8","v":0},null,0]
["Giugno",{"$f":"Giugno!G34","v":0},null,{"$f":"Giugno!H34","v":0},null,0,null,{"$f":"Giugno!I34","v":0},null,{"$f":"Giugno!J34","v":0},null,{"$f":"Giugno!K34*8","v":0},null,0]
["Luglio",{"$f":"Luglio!G34","v":0},null,{"$f":"Luglio!H34","v":0},null,0,null,{"$f":"Luglio!I34","v":0},null,{"$f":"Luglio!J34","v":0},null,{"$f":"Luglio!K34*8","v":0},null,0]
["Agosto",{"$f":"Agosto!G34","v":0},null,{"$f":"Agosto!H34","v":0},null,0,null,{"$f":"Agosto!I34","v":0},null,{"$f":"Agosto!J34","v":0},null,{"$f":"Agosto!K34*8","v":0},null,0]
["Settembre",{"$f":"Settembre!G34","v":0},null,{"$f":"Settembre!H34","v":0},null,0,null,{"$f":"Settembre!I34","v":0},null,{"$f":"Settembre!J34","v":0},null,{"$f":"Settembre!K34*8","v":0},null,0]
["Ottobre",{"$f":"Ottobre!G34","v":0},null,{"$f":"Ottobre!H34","v":0},null,0,null,{"$f":"Ottobre!I34","v":0},null,{"$f":"Ottobre!J34","v":0},null,{"$f":"Ottobre!K34*8","v":0},null,0]
["Novembre",{"$f":"Novembre!G34","v":0},null,{"$f":"Novembre!H34","v":0},null,0,null,{"$f":"Novembre!I34","v":0},null,{"$f":"Novembre!J34","v":0},null,{"$f":"Novembre!K34*8","v":0},null,0]
["Dicembre",{"$f":"Dicembre!G34","v":0},null,{"$f":"Dicembre!H34","v":0},null,0,null,{"$f":"Dicembre!I34","v":0},null,{"$f":"Dicembre!J34","v":0},null,{"$f":"Dicembre!K34*8","v":0},null,0]
["TOTALI  ANNO",{"$f":"SUM(B3:B14)","v":0},null,{"$f":"SUM(D3:D14)","v":0},null,{"$f":"SUM(F3:F14)","v":0},null,{"$f":"SUM(H3:H14)","v":0},null,{"$f":"SUM(J3:J14)","v":0},null,{"$f":"SUM(L3:L14)","v":0},null,{"$f":"SUM(N3:N14)","v":0}]
[]
[null,{"$f":"TIME(6,0,0)","v":"06:00:00"},null,{"$f":"TIME(12,0,0)","v":"12:00:00"},null,{"$f":"TIME(12,30,0)","v":"12:30:00"},null,{"$f":"TIME(11,0,0)","v":"11:00:00"},null,4,null,0.25,null,1]
[null,{"$f":"TIME(6,30,0)","v":"06:30:00"},null,{"$f":"TIME(12,30,0)","v":"12:30:00"},null,{"$f":"TIME(13,0,0)","v":"13:00:00"},null,{"$f":"TIME(11,30,0)","v":"11:30:00"},null,8,null,0.5]
[null,{"$f":"TIME(7,0,0)","v":"07:00:00"},null,{"$f":"TIME(13,0,0)","v":"13:00:00"},null,{"$f":"TIME(13,30,0)","v":"13:30:00"},null,{"$f":"TIME(12,0,0)","v":"12:00:00"},null,null,null,0.75]
[null,{"$f":"TIME(7,30,0)","v":"07:30:00"},null,{"$f":"TIME(13,30,0)","v":"13:30:00"},null,{"$f":"TIME(14,0,0)","v":"14:00:00"},null,{"$f":"TIME(12,30,0)","v":"12:30:00"},null,null,null,1]
[null,{"$f":"TIME(8,0,0)","v":"08:00:00"},null,null,null,null,null,{"$f":"TIME(13,0,0)","v":"13:00:00"},null,null,null,1.25]
[null,{"$f":"TIME(8,30,0)","v":"08:30:00"},null,null,null,null,null,{"$f":"TIME(13,30,0)","v":"13:30:00"},null,null,null,1.5]
[null,{"$f":"TIME(9,0,0)","v":"09:00:00"},null,null,null,null,null,{"$f":"TIME(16,0,0)","v":"16:00:00"},null,null,null,1.75]
[null,null,null,null,null,null,null,{"$f":"TIME(16,30,0)","v":"16:30:00"},null,null,null,2]
[null,null,null,null,null,null,null,{"$f":"TIME(17,0,0)","v":"17:00:00"},null,null,null,2.25]
[null,null,null,null,null,null,null,{"$f":"TIME(17,30,0)","v":"17:30:00"},null,null,null,2.5]
[null,null,null,null,null,null,null,{"$f":"TIME(18,0,0)","v":"18:00:00"},null,null,null,2.75]
[null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,3.25]
[null,null,null,null,null,null,null,null,null,null,null,3.5]
[null,null,null,null,null,null,null,null,null,null,null,3.75]
[null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,4.25]
[null,null,null,null,null,null,null,null,null,null,null,4.5]
[null,null,null,null,null,null,null,null,null,null,null,4.75]
[null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,5.25]
[null,null,null,null,null,null,null,null,null,null,null,5.5]
[null,null,null,null,null,null,null,null,null,null,null,5.75]
[null,null,null,null,null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,null,null,6.25]
[null,null,null,null,null,null,null,null,null,null,null,6.5]
[null,null,null,null,null,null,null,null,null,null,null,6.75]
[null,null,null,null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,null,null,null,null,7.25]
[null,null,null,null,null,null,null,null,null,null,null,7.5]
[null,null,null,null,null,null,null,null,null,null,null,7.75]
[null,null,null,null,null,null,null,null,null,null,null,8]

{"sheet":"Grafici","index":15,"n_rows":68,"n_cols":29,"rows_kept":68,"cut":false,"hidden":false,"merged":[[16,0,16,8],[33,0,33,8],[50,0,50,8],[67,0,67,8],[41,28,41,36],[16,9,16,17],[33,9,33,17],[50,9,50,17],[16,19,16,27],[67,9,67,17],[67,19,67,27],[50,19,50,27],[33,19,33,27]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Settembre_07!A1"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["RITORNO",null,null,null,null,null,null,null,null,"RITORNO",null,null,null,null,null,null,null,null,null,"RITORNO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ottobre_07!A1"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["RITORNO",null,null,null,null,null,null,null,null,"RITORNO",null,null,null,null,null,null,null,null,null,"RITORNO"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RITORNO"]
[]
[]
[]
[]
[]
[]
[]
[]
["RITORNO",null,null,null,null,null,null,null,null,"RITORNO",null,null,null,null,null,null,null,null,null,"RITORNO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dicembre_07!A1"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["RITORNO",null,null,null,null,null,null,null,null,"RITORNO",null,null,null,null,null,null,null,null,null,"RITORNO"]