A042 INFORMATICA GESTIONE INCASSI CINEMA biglietto intero bigletto ridotto 8 4,5 sala1 sala2 sala3 sala4 sala5 totali percentuali martedi interi ridotti 1 3 2 7 3 11 4 15 5 19 =SOMMA(B6:B10) =SOMMA(C6:C10) =(B11+C11)/$R$17 mercoledi interi ridotti 5 7 12 17 19 27 26 37 33 47 =SOMMA(D6:D10) =SOMMA(E6:E10) =(D11+E11)/$R$17 interi 9 22 35 48 61 =SOMMA(F6:F10) =(F11+G11)/$R$17 giovedi ridotti 11 27 43 59 75 =SOMMA(G6:G10) spettatori venerdi ridotti 15 37 59 81 103 =SOMMA(I6:I10) interi 13 32 51 70 89 =SOMMA(H6:H10) =(H11+I11)/$R$17 interi 17 42 67 92 117 =SOMMA(J6:J10) =(J11+K11)/$R$17 14/04/2015 sabato ridotti 19 47 75 103 131 =SOMMA(K6:K10) domenica interi ridotti 21 23 52 57 83 91 114 125 145 159 =SOMMA(L6:L10) =SOMMA(M6:M10) =(L11+M11)/$R$17 incassi martedi sala1 sala2 sala3 sala4 sala5 totali percentuali =$B$1*B6+$B$2*C6 =$B$1*B7+$B$2*C7 =$B$1*B8+$B$2*C8 =$B$1*B9+$B$2*C9 =$B$1*B10+$B$2*C10 =SOMMA(B18:B22) =B23/$R$20 mercoledi =$B$1*D6+$B$2*E6 =$B$1*D7+$B$2*E7 =$B$1*D8+$B$2*E8 =$B$1*D9+$B$2*E9 =$B$1*D10+$B$2*E10 =SOMMA(D18:D22) =D23/$R$20 giovedi =$B$1*F6+$B$2*G6 =$B$1*F7+$B$2*G7 =$B$1*F8+$B$2*G8 =$B$1*F9+$B$2*G9 =$B$1*F10+$B$2*G10 =SOMMA(F18:F22) =F23/$R$20 venerdi =$B$1*H6+$B$2*I6 =$B$1*H7+$B$2*I7 =$B$1*H8+$B$2*I8 =$B$1*H9+$B$2*I9 =$B$1*H10+$B$2*I10 =SOMMA(H18:H22) =H23/$R$20 sabato =$B$1*J6+$B$2*K6 =$B$1*J7+$B$2*K7 =$B$1*J8+$B$2*K8 =$B$1*J9+$B$2*K9 =$B$1*J10+$B$2*K10 =SOMMA(J18:J22) =J23/$R$20 domenica =$B$1*L6+$B$2*M6 =$B$1*L7+$B$2*M7 =$B$1*L8+$B$2*M8 =$B$1*L9+$B$2*M9 =$B$1*L10+$B$2*M10 =SOMMA(L18:L22) =L23/$R$20 totali Totale interi ridotti =B6+D6+F6+H6+J6+L6 =C6+E6+G6+I6+K6+M6 =N6+O6 =B7+D7+F7+H7+J7+L7 =C7+E7+G7+I7+K7+M7 =N7+O7 =B8+D8+F8+H8+J8+L8 =C8+E8+G8+I8+K8+M8 =N8+O8 =B9+D9+F9+H9+J9+L9 =C9+E9+G9+I9+K9+M9 =N9+O9 =B10+D10+F10+H10+J10+L10 =C10+E10+G10+I10+K10+M10 =N10+O10 perc% =P6/$R$17 =P7/$R$17 =P8/$R$17 =P9/$R$17 =P10/$R$17 Totale interi venduti Totale ridotti venduti Totale biglietti venduti =SOMMA(N6:N10) =SOMMA(O6:O10) =SOMMA(R15:R16) Incasso Totale =SOMMA(B23:L23)
© Copyright 2024 ExpyDoc
