{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Turni"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"1904"}

{"sheet":"Turni","index":0,"n_rows":38,"n_cols":59,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,1,0,27],[37,38,37,39],[36,38,36,39],[35,38,35,39],[26,32,26,33],[29,38,29,39],[28,38,28,39],[34,38,34,39],[33,38,33,39],[32,38,32,39],[31,38,31,39],[30,38,30,39],[26,38,26,39],[1,23,3,23],[1,22,3,22],[1,12,3,12],[1,0,3,0],[37,35,37,36],[36,35,36,36],[35,35,35,36],[34,35,34,36],[33,35,33,36],[1,28,3,28],[1,27,3,27],[1,31,2,36],[32,35,32,36],[30,35,30,36],[29,35,29,36],[28,35,28,36],[1,26,3,26],[1,25,3,25],[1,24,3,24],[1,21,3,21],[1,20,3,20],[1,19,3,19],[1,18,3,18],[1,17,3,17],[1,1,3,1],[1,29,3,29],[1,6,3,6],[1,5,3,5],[1,4,3,4],[1,3,3,3],[1,2,3,2],[1,11,3,11],[1,10,3,10],[1,9,3,9],[1,8,3,8],[1,7,3,7],[1,16,3,16],[1,15,3,15],[1,14,3,14],[1,13,3,13]]}
[null,"INSERIMENTO DEI TURNI"]
["PIANIFICAZIONE SETTIMANALE E NOMINATIVI","LUN","MAR","MER","GIO","VEN","SAB","DOM","LUN","MAR","MER","GIO","VEN","SAB","DOM","LUN","MAR","MER","GIO","VEN","SAB","DOM","LUN","MAR","MER","GIO","VEN","SAB","DOM","TOTALE ORE",null,"CONTROLLO TURNI E ORE"]
[]
[]
["Nome1","M","S","M","P","R","R","R","M","S","M","N","R","R","R","P","M","M","R","M","R","R","S","P","N","R","M","R","R",{"$f":"SUM(AF5:BG5)","v":83},null,{"$f":"VLOOKUP(B5,$AG$29:$AH$38,2,0)","v":7},{"$f":"VLOOKUP(C5,$AG$29:$AH$38,2,0)","v":0},7,7,0,0,0,7,0,7,3,0,0,0,7,7,7,0,7,0,0,0,7,3,0,7,0,0]
["Nome2","M","M","S","PN","N","R","R","MN","M","P","M","R","R","R","P","N","R","M","M","R","R","M","PN","S","N","R","R","R",{"$f":"SUM(AF6:BG6)","v":93},null,{"$f":"VLOOKUP(B6,$AG$29:$AH$38,2,0)","v":7},{"$f":"VLOOKUP(C6,$AG$29:$AH$38,2,0)","v":7},{"$f":"VLOOKUP(D6,$AG$29:$AH$38,2,0)","v":0},{"$f":"VLOOKUP(E6,$AG$29:$AH$38,2,0)","v":7},{"$f":"VLOOKUP(F6,$AG$29:$AH$38,2,0)","v":3},{"$f":"VLOOKUP(G6,$AG$29:$AH$38,2,0)","v":0},{"$f":"VLOOKUP(H6,$AG$29:$AH$38,2,0)","v":0},{"$f":"VLOOKUP(I6,$AG$29:$AH$38,2,0)","v":7},{"$f":"VLOOKUP(J6,$AG$29:$AH$38,2,0)","v":7},{"$f":"VLOOKUP(K6,$AG$29:$AH$38,2,0)","v":7},{"$f":"VLOOKUP(L6,$AG$29:$AH$38,2,0)","v":7},{"$f":"VLOOKUP(M6,$AG$29:$AH$38,2,0)","v":0},{"$f":"VLOOKUP(N6,$AG$29:$AH$38,2,0)","v":0},{"$f":"VLOOKUP(O6,$AG$29:$AH$38,2,0)","v":0},{"$f":"VLOOKUP(P6,$AG$29:$AH$38,2,0)","v":7},{"$f":"VLOOKUP(Q6,$AG$29:$AH$38,2,0)","v":3},{"$f":"VLOOKUP(R6,$AG$29:$AH$38,2,0)","v":0},{"$f":"VLOOKUP(S6,$AG$29:$AH$38,2,0)","v":7},{"$f":"VLOOKUP(T6,$AG$29:$AH$38,2,0)","v":7},{"$f":"VLOOKUP(U6,$AG$29:$AH$38,2,0)","v":0},{"$f":"VLOOKUP(V6,$AG$29:$AH$38,2,0)","v":0},{"$f":"VLOOKUP(W6,$AG$29:$AH$38,2,0)","v":7},{"$f":"VLOOKUP(X6,$AG$29:$AH$38,2,0)","v":7},{"$f":"VLOOKUP(Y6,$AG$29:$AH$38,2,0)","v":0},{"$f":"VLOOKUP(Z6,$AG$29:$AH$38,2,0)","v":3},{"$f":"VLOOKUP(AA6,$AG$29:$AH$38,2,0)","v":0},{"$f":"VLOOKUP(AB6,$AG$29:$AH$38,2,0)","v":0},{"$f":"VLOOKUP(AC6,$AG$29:$AH$38,2,0)","v":0}]
["Nome3","M","P","P","M","N","R","R","M","P","P","S","R","R","R","M","M","N","R","M","R","R","M","M","S","P","R","R","R",97,null,7,7,7,7,3,0,0,7,7,7,0,0,0,0,7,7,3,0,7,0,0,7,7,0,7,0,0,0]
["Nome4","P","M","MN","N","S","R","R","P","R","MN","R","M","R","R","P","P","R","M","P","R","R","P","S","R","M","M","R","R",94,null,7,7,7,3,0,0,0,7,0,7,0,7,0,0,7,7,0,7,7,0,0,7,0,0,7,7,0,0]
["Nome5","M","P","P","M","R","R","R","M","P","P","PN","R","R","R","M","M","P","R","P","R","R","M","P","N","R","MN","R","R",108,null,7,7,7,7,0,0,0,7,7,7,7,0,0,0,7,7,7,0,7,0,0,7,7,3,0,7,0,0]
["Nome6","P","M","M","R","P","R","R","P","M","M","R","P","R","R","p","p","R","MN","P","R","R","M","s","R","P","M","R","R",105,null,7,7,7,0,7,0,0,7,7,7,0,7,0,0,7,7,0,7,7,0,0,7,0,0,7,7,0,0]
["Nome7","N","R","M","R","M","R","R","N","R","M","M","MN","R","R","M","M","N","R","N","R","R","P","M","P","M","R","R","R",89,null,3,0,7,0,7,0,0,3,0,7,7,7,0,0,7,7,3,0,3,0,0,7,7,7,7,0,0,0]
["Nome8","PN","S","MN","R","M","R","R","P","S","M","N","R","R","R","PN","M","MN","R","M","R","R","S","PN","R","R","M","R","R",80,null,7,0,7,0,7,0,0,7,0,7,3,0,0,0,7,7,7,0,7,0,0,0,7,0,0,7,0,0]
["Nome9","M","P","S","P","M","R","R","M","P","S","R","MN","R","R","M","P","R","P","M","R","R","P","M","MN","S","R","R","R",98,null,7,7,0,7,7,0,0,7,7,0,0,7,0,0,7,7,0,7,7,0,0,7,7,7,0,0,0,0]
["Nome10","P","M","PN","R","R","R","R","P","M","PN","M","R","R","R","M","PN","S","M","R","R","R","MN","P","n","R","P","R","R",94,null,7,7,7,0,0,0,0,7,7,7,7,0,0,0,7,7,0,7,0,0,0,7,7,3,0,7,0,0]
["Nome11","M","S","R","MN","P","R","R","M","S","R","R","R","R","R","S","M","R","M","MN","R","R","S","M","R","M","M","R","R",70,null,7,0,0,7,7,0,0,7,0,0,0,0,0,0,0,7,0,7,7,0,0,0,7,0,7,7,0,0]
["Nome12","M","P","M","P","M","R","R","M","P","M","M","N","R","R","P","M","M","P","R","R","R","P","s","M","R","P","R","R",115,null,7,7,7,7,7,0,0,7,7,7,7,3,0,0,7,7,7,7,0,0,0,7,0,7,0,7,0,0]
["Nome13","R","R","R","P","P","R","R","P","S","R","M","MN","R","R","S","MN","P","M","P","R","R","n","R","P","M","S","R","R",80,null,0,0,0,7,7,0,0,7,0,0,7,7,0,0,0,7,7,7,7,0,0,3,0,7,7,0,0,0]
["Nome14","PN","MN","M","P","S","R","R","P","M","M","N","R","R","R","P","S","R","P","M","R","R","s","P","n","R","M","R","R",90,null,7,7,7,7,0,0,0,7,7,7,3,0,0,0,7,0,0,7,7,0,0,0,7,3,0,7,0,0]
["Nome15","M","P","P","M","N","R","R","M","P","P","R","N","R","R","M","P","R","M","M","R","R","PN","S","R","M","P","R","R",104,null,7,7,7,7,3,0,0,7,7,7,0,3,0,0,7,7,0,7,7,0,0,7,0,0,7,7,0,0]
["Nome16","N","M","M","M","R","R","R","M","M","M","PN","R","R","R","PN","M","S","R","S","R","R","M","P","P","R","M","R","R",94,null,3,7,7,7,0,0,0,7,7,7,7,0,0,0,7,7,0,0,0,0,0,7,7,7,0,7,0,0]
["Nome17","P","R","P","R","P","R","R","P","R","P","M","S","R","R","M","P","R","M","N","R","R","P","N","R","MN","M","R","R",90,null,7,0,7,0,7,0,0,7,0,7,7,0,0,0,7,7,0,7,3,0,0,7,3,0,7,7,0,0]
["Nome18","S","N","R","S","M","R","R","S","N","R","P","P","R","R","N","R","M","P","S","R","R","M","PN","S","R","N","R","R",61,null,0,3,0,0,7,0,0,0,3,0,7,7,0,0,3,0,7,7,0,0,0,7,7,0,0,3,0,0]
["Nome19","P","S","M","N","R","R","R","P","S","M","PN","R","R","R","P","M","M","R","M","R","R","S","P","N","R","M","R","R",83,null,7,0,7,3,0,0,0,7,0,7,7,0,0,0,7,7,7,0,7,0,0,0,7,3,0,7,0,0]
["Nome20","M","M","R","N","N","R","R","M","M","R","P","M","R","R","M","P","P","N","R","R","R","M","S","N","R","P","R","R",89,null,7,7,0,3,3,0,0,7,7,0,7,7,0,0,7,7,7,3,0,0,0,7,0,3,0,7,0,0]
[]
["VERIFICA COPERTURA"]
["Mattino-Notte",{"$f":"COUNTIF(B5:B24,\"mn\")","v":0},{"$f":"COUNTIF(C5:C24,\"mn\")","v":1},2,1,0,0,0,1,0,1,0,3,0,0,0,1,1,1,1,0,0,1,0,1,1,1,0,0,null,null,null,"LEGENDA",null,null,null,null,null,"ORARI"]
["Mattino",{"$f":"COUNTIF(B5:B24,\"m\")","v":9},{"$f":"COUNTIF(C5:C24,\"m\")","v":6},7,4,5,0,0,9,6,8,6,2,0,0,8,9,4,7,8,0,0,7,4,1,5,9,0,0,null,null,null,"TIPO","ORE"]
["Pomeriggio",{"$f":"COUNTIF(B5:B24,\"p\")","v":5},{"$f":"COUNTIF(C5:C24,\"p\")","v":5},4,5,4,0,0,8,5,5,2,2,0,0,7,6,3,4,4,0,0,5,6,3,2,4,0,0,null,null,null,"MN",7,null,"Mattino-Notte",null,null,"(es: 06-13)"]
["Pomeriggio-Notte",{"$f":"COUNTIF(B5:B24,\"pn\")","v":2},{"$f":"COUNTIF(C5:C24,\"pn\")","v":0},1,1,0,0,0,0,0,1,3,0,0,0,2,1,0,0,0,0,0,1,3,0,0,0,0,0,null,null,null,"M",7,null,"Mattino",null,null,"(es: 07-13)"]
["Notte",{"$f":"COUNTIF(B6:B25,\"N\")","v":2},{"$f":"COUNTIF(C6:C25,\"N\")","v":1},0,3,4,0,0,1,1,0,2,2,0,0,1,1,2,1,2,0,0,1,1,5,1,1,0,0,null,null,null,"P",7,null,"Pomeriggio",null,null,"(es: 13-19)"]
["Smontante",{"$f":"COUNTIF(B7:B26,\"s\")","v":1},{"$f":"COUNTIF(C7:C26,\"s\")","v":3},1,1,2,0,0,1,4,1,1,1,0,0,2,1,2,0,2,0,0,4,5,2,1,1,0,0,null,null,null,"PN",7,null,"Pomeriggio-Notte",null,null,"(es: 15-22)"]
[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,null,null,null,null,"N",3,null,"Notte",null,null,"(es: 22-24)"]
[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,null,null,null,null,"S",0,null,"Smontante",null,null,"(es: 24-06)"]
[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,null,null,null,null,"R",0,null,"Riposo",null,null,0]
[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,null,null,null,null,"PR",0,null,"Permessi",null,null,0]
[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,null,null,null,null,"FE",0,null,"Ferie",null,null,0]
[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,null,null,null,null,"MA",0,null,"MAlattia",null,null,0]