{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["PARAMETRES","COPYRIGHT","HOME","COUTS CESSION"],"not_rendered":{"charts":0,"images":10,"macros":1,"external_links":1,"defined_names":21,"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":"PARAMETRES","index":0,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"PARAMETRES"]
[]
[null,"Taux de change EUR/CHF",0.96499999999999997]
[]
[null,"Taux vacances",8.3299999999999999E-2]
[null,"Charges employeurs",0.19]
[]
[null,"Année de l'exercice",2022]

{"sheet":"COPYRIGHT","index":1,"n_rows":23,"n_cols":3,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Solution pour établir un budget"]
[null,null,"Mandaté Cie Moost"]
[null,null,"Version du 3 octobre 2022"]
[]
[null,null,"Infogestion SA"]
[null,null,"Ch. des Charmettes 9"]
[null,null,"1003 Lausanne"]
[null,null,"rs@infogestion.ch"]
[null,null,"+41 21 711 26 66"]
[]
[null,null,"Support:"]
[null,null,"cf@infogestion.ch"]
[null,null,"+41 21 711 26 65"]

{"sheet":"HOME","index":2,"n_rows":4,"n_cols":9,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,null,null,null,null,null,"COUTS DE CESSION"]

{"sheet":"COUTS CESSION","index":3,"n_rows":89,"n_cols":14,"rows_kept":89,"cut":false,"hidden":false,"merged":[[7,12,7,13],[7,10,7,11],[7,4,7,5],[7,6,7,7],[7,8,7,9]]}
[]
[]
[]
[null,"CIE XXXX"]
[null,"Préparation Coût de cession"]
[null,"Spectacle XXX"]
[null,"Date du fichier:","29.07.2022"]
[null,"I CESSION",null,null,"Première date",null,"Date supplémentaire",null,"Date supplémentaire",null,"Date supplémentaire",null,"Date supplémentaire"]
[null,"Charges artistiques ","salaire chargé / jour",null,"jours","montant CHF","jour","montant","jour","montant","jour","montant","jour","montant"]
[null,"Interprètes",null,null,null,{"$f":"SUM(F11:F14)","v":2700},null,{"$f":"SUM(H11:H14)","v":900},null,{"$f":"SUM(J11:J14)","v":900},null,{"$f":"SUM(L11:L14)","v":900},null,{"$f":"SUM(N11:N14)","v":900}]
[null,"Interprète 1 - Prénom Nom",300,null,3,{"$f":"$C11*E11","v":900},1,{"$f":"$C11*G11","v":300},1,{"$f":"$C11*I11","v":300},1,{"$f":"$C11*K11","v":300},1,{"$f":"$C11*M11","v":300}]
[null,"Interprète 2 - Prénom Nom",300,null,3,900,1,300,1,300,1,300,1,300]
[null,"Interprète 3 - Prénom Nom",300,null,3,900,1,300,1,300,1,300,1,300]
[null,"mettre charges séparément ?"]
[null,"Autres frais artistiques",null,null,null,{"$f":"SUM(F16:F19)","v":550},null,{"$f":"SUM(H16:H19)","v":0},null,{"$f":"SUM(J16:J19)","v":0},null,{"$f":"SUM(L16:L19)","v":0},null,{"$f":"SUM(N16:N19)","v":0}]
[null,"Costumes",400,null,1,{"$f":"$C16*E16","v":400},0,{"$f":"$C16*G16","v":0},0,{"$f":"$C16*I16","v":0},0,{"$f":"$C16*K16","v":0},0,{"$f":"$C16*M16","v":0}]
[null,"Accessoires",100,null,1,100,0,0,0,0,0,0,0,0]
[null,"Autres",50,null,1,50,0,0,0,0,0,0,0,0]
[]
[null,"Total artistique",null,null,null,{"$f":"F10+F15","v":3250},null,{"$f":"H10+H15","v":900},null,{"$f":"J10+J15","v":900},null,{"$f":"L10+L15","v":900},null,{"$f":"N10+N15","v":900}]
[]
[null,"Charges techniques","salaire chargé / service",null,"nb services","montant","nb services","montant","nb services","montant","nb services","montant","nb services","montant"]
[null,"Régisseur·euse·s",null,null,null,{"$f":"SUM(F24:F26)","v":3520},null,{"$f":"SUM(H24:H26)","v":680},null,{"$f":"SUM(J24:J26)","v":680},null,{"$f":"SUM(L24:L26)","v":680},null,{"$f":"SUM(N24:N26)","v":680}]
[null,"Régisseur 1 - Prénom Nom",200,null,6,{"$f":"$C24*E24","v":1200},1,{"$f":"$C24*G24","v":200},1,{"$f":"$C24*I24","v":200},1,{"$f":"$C24*K24","v":200},1,{"$f":"$C24*M24","v":200}]
[null,"Régisseuse 2 - Prénom Nom",200,null,6,1200,1,200,1,200,1,200,1,200]
[null,"Services chargement / déchargement",280,null,4,1120,1,280,1,280,1,280,1,280]
[]
[null,"Autres frais techniques",null,null,null,{"$f":"SUM(F29:F31)","v":500},null,{"$f":"SUM(H29:H31)","v":0},null,{"$f":"SUM(J29:J31)","v":0},null,{"$f":"SUM(L29:L31)","v":0},null,{"$f":"SUM(N29:N31)","v":0}]
[null,"Carnet ATA ",400,null,1,{"$f":"$C29*E29","v":400},0,{"$f":"$C29*G29","v":0},0,{"$f":"$C29*I29","v":0},0,{"$f":"$C29*K29","v":0},0,{"$f":"$C29*M29","v":0}]
[null,"Autres",100,null,1,100,0,0,0,0,0,0,0,0]
[]
[null,"Total technique",null,null,null,{"$f":"F23+F28","v":4020},null,{"$f":"H23+H28","v":680},null,{"$f":"J23+J28","v":680},null,{"$f":"L23+L28","v":680},null,{"$f":"N23+N28","v":680}]
[]
[null,"Charges production","salaire chargé / service",null,"nb services","montant","nb services","montant","nb services","montant","nb services","montant","nb services","montant"]
[null,"Personnel production",null,null,null,{"$f":"SUM(F36:F40)","v":1350},null,{"$f":"SUM(H36:H40)","v":0},null,{"$f":"SUM(J36:J40)","v":0},null,{"$f":"SUM(L36:L40)","v":0},null,{"$f":"SUM(N36:N40)","v":0}]
[null,"Directeur·ice artistique",300,null,1,{"$f":"$C36*E36","v":300},0,{"$f":"$C36*G36","v":0},0,{"$f":"$C36*I36","v":0},0,{"$f":"$C36*K36","v":0},0,{"$f":"$C36*M36","v":0}]
[null,"Directeur·ice technique",300,null,1,300,0,0,0,0,0,0,0,0]
[null,"Directeur·ice administratif·ve",300,null,1,300,0,0,0,0,0,0,0,0]
[null,"Responsable de diffusion",250,null,1,250,0,0,0,0,0,0,0,0]
[null,"Assistant·e de production",200,null,1,200,0,0,0,0,0,0,0,0]
[]
[null,"Autres frais de production",null,null,null,{"$f":"SUM(F43:F44)","v":100},null,{"$f":"SUM(H43:H44)","v":0},null,{"$f":"SUM(J43:J44)","v":0},null,{"$f":"SUM(L43:L44)","v":0},null,{"$f":"SUM(N43:N44)","v":0}]
[null,"Frais administration ",50,null,1,{"$f":"$C43*E43","v":50},0,{"$f":"$C43*G43","v":0},0,{"$f":"$C43*I43","v":0},0,{"$f":"$C43*K43","v":0},0,{"$f":"$C43*M43","v":0}]
[null,"Autres",50,null,1,50,0,0,0,0,0,0,0,0]
[]
[null,"TOTAL PRODUCTION ",null,null,null,{"$f":"F35+F42","v":1450},null,{"$f":"H35+H42","v":0},null,{"$f":"J35+J42","v":0},null,{"$f":"L35+L42","v":0},null,{"$f":"N35+N42","v":0}]
[]
[null,"TOTAL CHARGES ARTISTIQUES + TECHNIQUES + PRODUCTION",null,null,null,{"$f":"F20+F32+F46","v":8720},null,{"$f":"H20+H32+H46","v":1580},null,{"$f":"J20+J32+J46","v":1580},null,{"$f":"L20+L32+L46","v":1580},null,{"$f":"N20+N32+N46","v":1580}]
[]
[null,"COÛTS PAR REPRÉSENTATION","CHF",null,"Moy / date"]
[1,{"$f":"A51&\" Représentation\"","v":"1 Représentation"},{"$f":"SUM(OFFSET($E$48,,,,$A51*2))","v":8720},null,{"$f":"IF(C51<>C50,C51/A51,\"\")","v":8720}]
[{"$f":"A51+1","v":2},{"$f":"A52&\" Représentation\"","v":"2 Représentation"},{"$f":"SUM(OFFSET($E$48,,,,$A52*2))","v":10300},null,{"$f":"IF(C52<>C51,C52/A52,\"\")","v":5150}]
[{"$f":"A52+1","v":3},"3 Représentation",11880,null,3960]
[{"$f":"A53+1","v":4},"4 Représentation",13460,null,{"$f":"IF(C54<>C53,C54/A54,\"\")","v":3365}]
[5,{"$f":"A55&\" Représentation\"","v":"5 Représentation"},15040,null,{"$f":"IF(C55<>C54,C55/A55,\"\")","v":3008}]
[]
[]
[null,"II FRAIS ANNEXES"]
[null,"Déplacements",null,null,"aller","retour","total"]
[null,"Voyages équipe",null,null,{"$f":"SUM(E61:E66)","v":900},{"$f":"SUM(F61:F66)","v":1000},{"$f":"E60+F60","v":1900}]
[null,"Interprète 1 - Prénom Nom","Ville - ville",null,{"$f":"300","v":300},250,550]
[null,"Interprète 2 - Prénom Nom","Ville - ville",null,200,250,450]
[null,"Interprète 3 - Prénom Nom","Ville - ville",null,200,200,400]
[null,"Régisseur 1 - Prénom Nom","Ville - ville",null,100,150,250]
[null,"Régisseur 2 - Prénom Nom","Ville - ville",null,100,150,{"$f":"E65+F65","v":250}]
[]
[]
[null,"Hébergement",null,null,"arrivée","départ","nuitées"]
[null,"Interprète 1 - Prénom Nom","lit double",null,"2022-08-27","2022-09-01",{"$f":"F69-E69","v":5}]
[null,"Interprète 2 - Prénom Nom","lit double",null,"2022-08-27","2022-09-01",5]
[null,"Interprète 3 - Prénom Nom","lit double",null,"2022-08-27","2022-09-01",5]
[null,"Régisseur 1 - Prénom Nom","lit double",null,"2022-08-26","2022-09-01",6]
[null,"Régisseur 2 - Prénom Nom","lit double",null,"2022-08-26","2022-09-01",{"$f":"F73-E73","v":6}]
[]
[]
[null,"Défraiements repas",27,null,null,{"$f":"SUM(F77:F82)","v":1458}]
[null,"Interprète 1 - Prénom Nom",null,null,{"$f":"LOOKUP(B77,$B$69:$B$74,$G$69:$G$74)","v":5},{"$f":"$C$76*E77*2","v":270}]
[null,"Interprète 2 - Prénom Nom",null,null,{"$f":"LOOKUP(B78,$B$69:$B$74,$G$69:$G$74)","v":5},270]
[null,"Interprète 3 - Prénom Nom",null,null,{"$f":"LOOKUP(B79,$B$69:$B$74,$G$69:$G$74)","v":5},270]
[null,"Régisseur 1 - Prénom Nom",null,null,{"$f":"LOOKUP(B80,$B$69:$B$74,$G$69:$G$74)","v":6},324]
[null,"Régisseur 2 - Prénom Nom",null,null,{"$f":"LOOKUP(B81,$B$69:$B$74,$G$69:$G$74)","v":6},{"$f":"$C$76*E81*2","v":324}]
[]
[]
[null,"Transport décor",null,null,null,{"$f":"SUM(F85:F87)","v":2000}]
[null,"Semi-remorque",1000,null,2,{"$f":"C85*E85","v":2000}]
[null,"mettre carnet ATA ici ?"]
[]
[]
[null,"TOTAL FRAIS ANNEXES",null,null,{"$f":"G60+F76+F84","v":5358}]