{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Exemple indemnisation entrepris","Feuil1"],"not_rendered":{"images":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Exemple indemnisation entrepris","index":0,"n_rows":58,"n_cols":8,"rows_kept":58,"merged":[[3,2,3,7],[4,2,4,7],[5,2,5,7],[6,2,6,5],[8,2,8,7],[9,2,9,7],[10,2,10,7],[12,3,12,7],[14,1,14,7],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[26,3,26,7],[28,1,28,7],[29,1,29,2],[30,1,30,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[35,1,35,2],[38,1,38,2],[40,1,40,2],[41,1,44,7],[48,1,48,7],[50,1,50,2],[50,3,50,4],[50,5,50,6],[51,1,51,2],[51,3,51,4],[51,5,51,6],[52,1,52,2],[52,3,52,4],[52,5,52,6],[53,1,53,2],[53,3,53,4],[53,5,53,6],[54,1,54,2],[54,3,54,4],[54,5,54,6],[57,1,57,4],[57,5,57,6]]}
[null,null,"Service des affaires culturelles"]
[null,null,"Département de la formation, de la jeunesse et de la culture"]
[]
[null,null,"Indemnisation des pertes pour acteurs culturels indépendants"]
[null,null,"Eléments financiers pour le calcul de l'indemnité sur les pertes encourues"]
[null,null,"COVID-19 - Etat de Vaud"]
[]
[]
[null,"Nom :"]
[null,"Prénom :"]
[]
[]
[{"$nulls":3},"Périodes concernées"]
[]
[null,"Pertes encourues"]
[null,"Cachets, salaires et/ou honoraires\nnon perçus *",null,0,0,0,0,0]
[null,"Cachets, salaires et/ou honoraires\ndus à des tiers *",null,0,0,0,0,0]
[null,"Pertes ventes non réalisées",null,0,0,0,0,0]
[null,"Locations non perçues",null,0,0,0,0,0]
[null,"Droits d'auteurs non perçus",null,0,0,0,0,0]
[null,"Pertes de revenus pour contrats non\nplanifiés ou non aboutis (merci de\ncompléter le tableau en page 3)",null,0,0,0,0,0]
[null,"Autres dépenses encourues *",null,0,0,0,0,0]
[null,"Autres revenus manquants *",null,0,0,0,0,0]
[null,"Total des revenus",null,{"$f":"SUM(D16:D23)","v":0},{"$f":"SUM(E16:E23)","v":0},{"$f":"SUM(F16:F23)","v":0},{"$f":"SUM(G16:G23)","v":0},{"$f":"SUM(H16:H23)","v":0}]
[null,"* merci de joindre une liste détaillée"]
[]
[{"$nulls":3},"Périodes concernées"]
[]
[null,"Indemnités reçues"]
[null,"Aide d'urgence - Suisseculture Sociale",null,0,0,0,0,0]
[null,"Allocation de perte de gains (APG) \n\"Corona\"",null,0,0,0,0,0]
[null,"Indemnité RHT pour les employé.e.s",null,0,0,0,0,0]
[null,"Indemnité d'assurance privée",null,0,0,0,0,0]
[null,"Aide publique à la culture (subventions communales, cantonales, Loterie Romande, ...)",null,0,0,0,0,0]
[null,"Autres revenus perçus *",null,0,0,0,0,0]
[null,"Total des indemnités",null,{"$f":"SUM(D30:D35)","v":0},{"$f":"SUM(E30:E35)","v":0},{"$f":"SUM(F30:F35)","v":0},{"$f":"SUM(G30:G35)","v":0},{"$f":"SUM(H30:H35)","v":0}]
[null,"* merci de joindre une liste détaillée"]
[]
[null,"Montant de la perte annoncée",null,{"$f":"D36-D24","v":0},{"$f":"E36-E24","v":0},{"$f":"F36-F24","v":0},{"$f":"G36-G24","v":0},{"$f":"H36-H24","v":0}]
[]
[null,"Remarques / questions :"]
{"$rows_empty":7}
[null,"Pertes de revenus pour des contrats non planifiés ou non aboutis\ncalcul du montant indemnisable"]
[]
[null,"Années",null,"Nombre d'engagements annuels\n(contrats / mandats)",null,"Montant total des cachets / honoraires\nreçus pour lesdits engagements"]
[null,"Exemple :",null,10,null,{"v":10000,"d":"10,000.00"}]
[null,2018]
[null,2019]
[null,"Moyenne annuelle\ncalculée sur deux ans",null,{"$f":"SUM((D53+D54)/2)","v":0},null,{"$f":"SUM((F53+F54)/2)","v":0}]
[null,"Sommes indicatives à utiliser pour calculer la perte de revenus pour la période concernée par la demande d'indemnisation :"]
[]
[null,"Moyenne des cachets / honoraires par mois :",{"$nulls":3},{"$f":"SUM(F55/12)","v":0}]

{"sheet":"Feuil1","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"merged":[[3,2,3,5],[4,2,4,5],[5,2,5,5],[6,2,6,5],[8,3,8,5],[10,1,10,5],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[19,1,19,5],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[28,1,28,2],[30,1,30,2],[31,1,33,5]]}