{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Guide d'utilisateur","Prévision des Ventes"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":1,"comments":1,"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":"Guide d'utilisateur","index":0,"n_rows":40,"n_cols":3,"rows_kept":40,"cut":false,"hidden":false,"merged":[[33,0,33,10],[11,2,11,10],[12,2,12,10],[16,2,16,10],[22,2,22,10],[24,2,24,10],[25,2,25,10],[29,2,29,10],[18,2,18,10],[13,2,13,10],[14,2,14,10],[19,2,19,10],[20,2,20,10],[27,2,27,10],[26,2,26,10],[21,2,21,10],[30,2,30,10],[10,2,10,10],[1,1,1,10],[2,1,2,10],[4,1,7,10],[9,2,9,10]]}
[]
[null,"PRÉVISION DES VENTES D'AGNEAUX ET/OU DE SUJETS REPRODUCTEURS"]
[null,"L'objectif de cet outil est de permettre une planification des ventes d'agneaux et de sujets de reproduction en considérant différents facteurs de la régie du troupeau."]
[]
[null,"Une bonne planification des ventes permet d'arrimer les revenus potentiels et les besoins financiers pour couvrir les différentes dépenses encourues. En combinaison avec un plan d'affaires complet, cet outil permet de bonifier un budget prévisionnel en considérant les ventes d'ovins selon une planification des groupes d'accouplement et des performances attendues. Voici donc les différentes étapes pour bien utiliser le chiffrier."]
[]
[]
[]
[]
[null,null,"INSTRUCTIONS :  Remplir les cases grises de l'onglet prévision des ventes et suivre les 15 étapes"]
[null,null,"Nombre de brebis : Indiquer le nombre de brebis que vous allez posséder."]
[null,null,"Nombre de groupes : Indiquer le nombre de groupes pour répartir vos saillies en utilisant le menu déroulant (de 1 à 8 groupes)"]
[null,null,"Rythme de production : Déterminer le rythme de votre production en utilisant le menu déroulant (de 8 à 12 mois). Sachez que 8 mois représentent un rythme d'agnelage visé de 1,5 par année, alors que 12 mois représentent un rythme de 1 agnelage par année. "]
[null,null,"Date de la 1re saillie : Cette date déterminera le positionnement de tous les autres groupes. Il est donc important de bien la choisir. Pour ce faire, considérer l'âge des agnelles ou le stade physiologique des sujets achetés. "]
[null,null,"Période de saillie en contre-saison : Déterminer la séquence des mois pouvant affecter l'activité de reproduction des sujets. Le choix de la race et de la technique de désaisonnement sont des facteurs importants à considérer."]
[]
[null,null,"Taux de fécondité : En fonction de la période d'accouplement, prévoir un taux de fécondité en fonction de la race des brebis, des performances historiques du troupeau ou tout autre facteur de régie pouvant influencer le taux de fécondité. \n \n\n\n\n\n\n"]
[]
[null,null,"Nombre d'agnelles gardées : Prévoir un taux de remplacement pour les agnelles gardées. Si vous envisagez d'acheter votre remplacement, inscrire 0 %. Le nombre d'agnelles gardées sera déduit des agneaux vendables. "]
[null,null,"Sujets sélectionnés pour la vente : Pour ceux qui envisagent de vendre des sujets de reproduction, inscrire le nombre d'agnelles et de béliers qui seront sélectionnés pour la vente au cours de la prochaine année."]
[null,null,"Nombre de sujets par groupe : Au besoin, vous pouvez modifier le nombre de sujets par groupe. Assurez-vous d'avoir une répartition adéquate en fonction de la taille du troupeau et du nombre de groupes prévus."]
[null,null,"Date de saillie : À partir de la date de la première saillie inscrite à l'étape 4 ainsi que des choix déterminés aux étapes 2 et 3, une planification automatique de la fréquence des saillies est générée. Si vous devez changer certaines dates, il est possible de le faire manuellement sans affecter la séquence. Vous devrez vous assurer du réalisme dans le temps de la fréquence pour chaque groupe modifié.   "]
[null,null,"Prolificité : Établir le taux de prolificité moyen de chaque groupe en fonction de la race, de l'âge, de la saison ou de toute autre information connue à propos des groupes. Pour vous aider, vous pouvez vous référer au tableau des performances annuelles par race évaluées sur GenOvis. (https://genovis.ca/performance-des-races-evaluees/)"]
[]
[null,null,"Mortalité : Établir le taux de mortalité moyen de chaque groupe en fonction de sa prolificité, de la saison ou de toute autre information pertinente. Le taux de mortalité doit inclure toutes les pertes d'agneaux avant et après sevrage. Pour vous aider, vous pouvez vous référer au même tableau sur GenOvis (https://genovis.ca/performance-des-races-evaluees/)"]
[null,null,"Sélection de la répartition des ventes d'agneaux : Établir en pourcentage la répartition des agneaux selon la catégorie lait et léger. Les autres catégories se calculeront automatiquement. "]
[null,null,"Durée de la croissance/finition des agneaux et des sujets de remplacement : Établir le nombre de jours moyen correspondant à la période de croissance à partir de la date de naissance (date moyenne) du groupe jusqu'à la vente pour chaque catégorie."]
[null,null,"Le poids des ovins à la vente : Établir pour chaque catégorie d'ovins le poids à la vente en kilogramme de poids vif. Concernant les sujets reproducteurs, assurez-vous de respecter les conditions d'admissibilité au programme ASRA : https://www.fadq.qc.ca/fileadmin/fr/assurance-stabilisation/resume-agneaux-2021.pdf"]
[]
[null,null,"Une fois toutes les étapes réalisées, il vous sera possible de consulter un rapport des performances annuelles attendues ainsi qu'une prévision de la répartition annuelle des ventes des différentes catégories d'ovins. "]
[null,null,"Profitez de ce chiffrier pour peaufiner votre plan d'affaires ou pour faire des scénarios de prévisions des ventes."]
[]
[]
["Une réalisation du CEPOQ \net Stéphanie Landry, agronome au ministère de l'Agriculture, des Pêcheries et de l'Alimentation (MAPAQ).                                                                         \nAvec la collaboration de l'équipe des Références économiques du CRAAQ."]
[]
[]
[]
[]
[]
[null,null,"Un remerciement spécial à Pierre-Luc Faucher, agronome, pour ses précieux commentaires."]

{"sheet":"Prévision des Ventes","index":1,"n_rows":93,"n_cols":54,"rows_kept":93,"cut":false,"hidden":false,"merged":[[26,1,31,1],[52,22,53,31],[52,2,53,15],[18,22,18,31],[55,28,55,29],[55,30,55,31],[55,22,55,23],[55,24,55,25],[55,26,55,27],[55,11,56,13],[55,14,56,15],[15,10,16,10],[15,12,16,12],[21,2,22,15],[55,7,56,10],[55,4,56,5]]}
[]
[null,null,"PRÉVISION DES VENTES D'AGNEAUX ET/OU DE SUJETS REPRODUCTEURS",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,null,null,"SECTION À CACHER"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(H11,$R$67:$S$78,2,FALSE)","v":2},{"$f":"VLOOKUP(I11,$R$67:$S$78,2,FALSE)","v":8}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(S4=12,1,S4+1)","v":9},{"$f":"IF(R4=1,12,R4-1)","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Validation remplacement"]
[null,1,"Nombre de brebis au troupeau",null,null,100,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,"Intervalle saillie",{"$f":"+F8*30","v":240},null,{"$f":"YEAR(F9)","v":2020},{"$f":"SUMIF($S$27:$S$50,AP6,$O$27:$O$50)","v":0}]
[null,2,"Nombre de groupe",null,null,4,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,"Intervalle entre deux groupes",{"$f":"AN6/F7","v":60},null,{"$f":"+AP6+1","v":2021},{"$f":"SUMIF($S$27:$S$50,AP7,$O$27:$O$50)","v":20.399999999999999}]
[null,3,"Rythme de production (mois)",null,null,8,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,"saillie à agnelage",143,null,{"$f":"+AP7+1","v":2022},{"$f":"SUMIF($S$27:$S$50,AP8,$O$27:$O$50)","v":20.399999999999999}]
[null,4,"Date 1ère saillie (groupe 1)",null,null,"2020-10-01",null,null,null,null,"Fécondité",6,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,"Nbre agnelle total/an",{"$f":"+F6*L14","v":20},null,2023,{"$f":"SUMIF($S$27:$S$50,AP9,$O$27:$O$50)","v":20.399999999999999},"*manque de ligne…"]
[]
[null,5,"Période de saillies en contre-saison",null,null,null,null,"Février","Août",null,"Taux :",0.7]
[null,null,"Période de saillies en saison",null,null,null,null,{"$f":"VLOOKUP(R5,$R$82:$S$93,2,FALSE)","v":"Septembre"},{"$f":"VLOOKUP(S5,$R$82:$S$93,2,FALSE)","v":"Janvier"},null,"Taux :",0.85]
[]
[null,7,"Nombre d'agnelles gardées pour le remplacement par année (% du troupeau)",null,null,null,null,null,null,null,null,0.2,{"$f":"L14*F6","v":20},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,"Nbre à prendre/groupe agnelage",{"$f":"ROUNDUP(AN9/AQ23,1)","v":3.4}]
[]
[null,null,"Taux de sélection prévu annuellement pour la vente (%)",null,null,null,null,null,{"$f":"I17/(I59/2)","v":0.26315789473684209},null,"Agnelles",{"$f":"L17/(I59/2)","v":1.7543859649122806E-2},"Béliers",null,null,null,null,"Mois en chiffre"]
[null,8,"Sujets sélectionnés pour la vente (nb/année):",null,null,null,null,null,30,null,null,2,null,null,null,null,null,null,null,null,null,null,null,13]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Prévision des ventes d'agneaux et sujets de remplacement",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Agnelage to agnelage"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,14,null,null,null,null,null,null,0.05,null,0.05,null,{"$f":"(100%-(W20+Y20+AC20+AE20))","v":0.75964912280701757},null,{"$f":"I17/I59","v":0.13157894736842105},null,{"$f":"L17/I59","v":8.771929824561403E-3},null,null,null,null,null,null,null,null,null,null,"1er",{"$f":"H27","v":"2021-02-23"},null,null,"Choix:",{"$f":"F7","v":4}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AGNEAUX LAIT",null,"AGNEAUX LÉGERS",null,"AGNEAUX LOURDS",null,"AGNELLES ",null,"BÉLIERS ",null,null,null,null,null,null,null,null,null,"*enlever 10 à 365 pour que ca arrive correct. Sinon chevauchement de mois","max",{"$f":"AQ20+355","v":"2022-02-13"},null,null,null,"Table des groupes"]
[null,null,"Prévision des ventes en fonction de la répartition des groupes d'agnelages et des performances techniques",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,"jours d'âge à la vente",90,"jours d'âge à la vente",180,"jours d'âge à la vente",180,"jours d'âge à la vente",300,"jours d'âge à la vente"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23,"Poids vif\n vendu (kg)",34,"Poids vif\nvendu (kg)",40,"Poids vif\n vendu (kg)",40,"Poids vif vendu\n(kg)",48.2,"Poids vif vendu\n(kg)",null,null,null,null,null,null,null,null,null,"Total agnelage/an",{"$f":"SUM(AQ27:AQ44)","v":6},null,null,"Choix valide:",{"$f":"IF(AU25=$AU$20,1,0)","v":0},{"$f":"IF(AV25=$AU$20,1,0)","v":0},0,1,0,0,0,0]
[]
[null,null,"Groupe"," 9  Nombre\nBrebis","10  Date \nSaillie","Fin \nSaillie",null,"Début \nAgnelage","Fin \nAgnelage",null,"Fécondité\nÉchographie","Brebis \nGestantes","11  Prolificité","12  Mortalité\n totale","Remplacement (tête)","Agneaux \nvendables",null,"Mois","Année",null,null,null,"DATES","NOMBRE","DATES","NOMBRE","DATES","NOMBRE","DATES","NOMBRE","DATES","NOMBRE",null,null,null,"Date saillie programmée",null,null,null,null,null,null,"Nbre agnelage possible/an",null,null,"Réponse",1,2,3,4,5,6,7,8]
[]
[null,null,{"$f":"AT27","v":1},{"$f":"F6/F7","v":25},{"$f":"AJ27","v":"2020-10-01"},{"$f":"E27+35","v":"2020-11-05"},null,{"$f":"E27+145","v":"2021-02-23"},"2021-03-30",null,{"$f":"VLOOKUP(R27,$S$67:$T$78,2,FALSE)","v":0.85},{"$f":"D27*K27","v":21.25},2.75,0.23,{"$f":"$AN$14","v":3.4},{"$f":"ROUND((L27*M27)-(N27*(L27*M27))-O27,0)","v":42},null,{"$f":"MONTH(E27)","v":10},{"$f":"YEAR(H27)","v":2021},null,null,null,{"$f":"(H27+I27)/2+W22","v":"2021-05-11T12:00:00"},{"$f":"ROUND(P27*W$20,0)","v":2},{"$f":"(H27+I27)/2+Y22","v":"2021-06-10T12:00:00"},{"$f":"ROUND(P27*Y$20,0)","v":2},{"$f":"(H27+I27)/2+AA22","v":"2021-09-08T12:00:00"},{"$f":"ROUND(P27*AA$20,0)","v":32},{"$f":"(H27+I27)/2+AC22","v":"2021-09-08T12:00:00"},{"$f":"ROUND(P27*AC$20,0)","v":6},{"$f":"(H27+I27)/2+AE22","v":"2022-01-06T12:00:00"},{"$f":"(P27*AE$20)","v":0.36842105263157893},null,null,null,{"$f":"F9","v":"2020-10-01"},null,null,null,null,null,null,{"$f":"IF(AND(H27>=$AQ$20,H27<=$AQ$21),1,0)","v":1},null,null,{"$f":"SUM(AU27:BB27)","v":1},{"$f":"IF($AU$23=1,1,0)","v":0},{"$f":"IF($AV$23=1,1,0)","v":0},{"$f":"IF($AW$23=1,1,0)","v":0},{"$f":"IF($AX$23=1,1,0)","v":1},{"$f":"IF($AY$23=1,1,0)","v":0},{"$f":"IF($AZ$23=1,1,0)","v":0},{"$f":"IF($BA$23=1,1,0)","v":0},{"$f":"IF($BB$23=1,1,0)","v":0}]
[null,null,{"$f":"AT28","v":2},{"$f":"F6/F7","v":25},{"$f":"AJ28","v":"2020-11-30"},"2021-01-04",null,"2021-04-24","2021-05-29",null,0.85,21.25,2.75,0.23,{"$f":"$AN$14","v":3.4},{"$f":"ROUND((L28*M28)-(N28*(L28*M28))-O28,0)","v":42},null,{"$f":"MONTH(E28)","v":11},{"$f":"YEAR(H28)","v":2021},null,null,null,{"$f":"(H28+I28)/2+W22","v":"2021-07-10T12:00:00"},2,{"$f":"(H28+I28)/2+Y22","v":"2021-08-09T12:00:00"},2,{"$f":"(H28+I28)/2+AA22","v":"2021-11-07T12:00:00"},32,{"$f":"(H28+I28)/2+AC22","v":"2021-11-07T12:00:00"},6,{"$f":"(H28+I28)/2+AE22","v":"2022-03-07T12:00:00"},0.36842105263157893,null,null,null,{"$f":"+AJ27+$AN$7","v":"2020-11-30"},null,null,null,null,null,null,{"$f":"IF(AND(H28>=$AQ$20,H28<=$AQ$21),1,0)","v":1},null,null,{"$f":"SUM(AU28:BB28)","v":2},{"$f":"IF($AU$23=1,1,0)","v":0},{"$f":"IF($AV$23=1,2,0)","v":0},{"$f":"IF($AW$23=1,2,0)","v":0},{"$f":"IF($AX$23=1,2,0)","v":2},{"$f":"IF($AY$23=1,2,0)","v":0},{"$f":"IF($AZ$23=1,2,0)","v":0},{"$f":"IF($BA$23=1,2,0)","v":0},{"$f":"IF($BB$23=1,2,0)","v":0}]
[null,null,3,{"$f":"F6/F7","v":25},{"$f":"AJ29","v":"2021-01-29"},"2021-03-05",null,"2021-06-23","2021-07-28",null,0.85,21.25,2.75,0.23,3.4,{"$f":"ROUND((L29*M29)-(N29*(L29*M29))-O29,0)","v":42},null,1,2021,null,null,null,{"$f":"(H29+I29)/2+W22","v":"2021-09-08T12:00:00"},2,{"$f":"(H29+I29)/2+Y22","v":"2021-10-08T12:00:00"},2,{"$f":"(H29+I29)/2+AA22","v":"2022-01-06T12:00:00"},32,{"$f":"(H29+I29)/2+AC22","v":"2022-01-06T12:00:00"},6,{"$f":"(H29+I29)/2+AE22","v":"2022-05-06T12:00:00"},0.36842105263157893,null,null,null,{"$f":"+AJ28+$AN$7","v":"2021-01-29"},null,null,null,null,null,null,1,null,null,3,0,{"$f":"IF($AV$23=1,1,0)","v":0},{"$f":"IF($AW$23=1,3,0)","v":0},{"$f":"IF($AX$23=1,3,0)","v":3},{"$f":"IF($AY$23=1,3,0)","v":0},{"$f":"IF($AZ$23=1,3,0)","v":0},{"$f":"IF($BA$23=1,3,0)","v":0},{"$f":"IF($BB$23=1,3,0)","v":0}]
[null,null,4,{"$f":"F6/F7","v":25},"2021-03-30","2021-05-04",null,{"$f":"E30+145","v":"2021-08-22"},"2021-09-26",null,0.7,17.5,2.75,0.23,3.4,{"$f":"ROUND((L30*M30)-(N30*(L30*M30))-O30,0)","v":34},null,3,2021,null,null,null,{"$f":"(H30+I30)/2+W22","v":"2021-11-07T12:00:00"},2,{"$f":"(H30+I30)/2+Y22","v":"2021-12-07T12:00:00"},2,{"$f":"(H30+I30)/2+AA22","v":"2022-03-07T12:00:00"},26,{"$f":"(H30+I30)/2+AC22","v":"2022-03-07T12:00:00"},4,{"$f":"(H30+I30)/2+AE22","v":"2022-07-05T12:00:00"},0.2982456140350877,null,null,null,"2021-03-30",null,null,null,null,null,null,1,null,null,4,0,{"$f":"IF($AV$23=1,2,0)","v":0},{"$f":"IF($AW$23=1,1,0)","v":0},{"$f":"IF($AX$23=1,4,0)","v":4},{"$f":"IF($AY$23=1,4,0)","v":0},{"$f":"IF($AZ$23=1,4,0)","v":0},{"$f":"IF($BA$23=1,4,0)","v":0},{"$f":"IF($BB$23=1,4,0)","v":0}]
[null,null,1,{"$f":"F6/F7","v":25},{"$f":"AJ31","v":"2021-05-29"},"2021-07-03",null,"2021-10-21","2021-11-25",null,0.7,17.5,2.75,0.23,3.4,34,null,5,2021,null,null,null,{"$f":"(H31+I31)/2+W22","v":"2022-01-06T12:00:00"},2,{"$f":"(H31+I31)/2+Y22","v":"2022-02-05T12:00:00"},2,{"$f":"(H31+I31)/2+AA22","v":"2022-05-06T12:00:00"},26,{"$f":"(H31+I31)/2+AC22","v":"2022-05-06T12:00:00"},4,{"$f":"(H31+I31)/2+AE22","v":"2022-09-03T12:00:00"},0.2982456140350877,null,null,null,"2021-05-29",null,null,null,null,null,null,1,null,null,1,0,{"$f":"IF($AV$23=1,1,0)","v":0},{"$f":"IF($AW$23=1,2,0)","v":0},{"$f":"IF($AX$23=1,1,0)","v":1},{"$f":"IF($AY$23=1,5,0)","v":0},{"$f":"IF($AZ$23=1,5,0)","v":0},{"$f":"IF($BA$23=1,5,0)","v":0},{"$f":"IF($BB$23=1,5,0)","v":0}]
[null,null,2,{"$f":"F6/F7","v":25},"2021-07-28","2021-09-01",null,"2021-12-20","2022-01-24",null,0.7,17.5,2.75,0.23,3.4,34,null,7,2021,null,null,null,{"$f":"(H32+I32)/2+W22","v":"2022-03-07T12:00:00"},2,{"$f":"(H32+I32)/2+Y22","v":"2022-04-06T12:00:00"},2,{"$f":"(H32+I32)/2+AA22","v":"2022-07-05T12:00:00"},26,{"$f":"(H32+I32)/2+AC22","v":"2022-07-05T12:00:00"},4,{"$f":"(H32+I32)/2+AE22","v":"2022-11-02T12:00:00"},0.2982456140350877,null,null,null,"2021-07-28",null,null,null,null,null,null,1,null,null,2,0,{"$f":"IF($AV$23=1,2,0)","v":0},{"$f":"IF($AW$23=1,3,0)","v":0},{"$f":"IF($AX$23=1,2,0)","v":2},{"$f":"IF($AY$23=1,1,0)","v":0},{"$f":"IF($AZ$23=1,6,0)","v":0},{"$f":"IF($BA$23=1,6,0)","v":0},{"$f":"IF($BB$23=1,6,0)","v":0}]
[null,null,3,{"$f":"F6/F7","v":25},"2021-09-26","2021-10-31",null,"2022-02-18","2022-03-25",null,0.85,21.25,2.75,0.23,3.4,42,null,9,2022,null,null,null,{"$f":"(H33+I33)/2+W22","v":"2022-05-06T12:00:00"},2,{"$f":"(H33+I33)/2+Y22","v":"2022-06-05T12:00:00"},2,{"$f":"(H33+I33)/2+AA22","v":"2022-09-03T12:00:00"},32,{"$f":"(H33+I33)/2+AC22","v":"2022-09-03T12:00:00"},6,{"$f":"(H33+I33)/2+AE22","v":"2023-01-01T12:00:00"},0.36842105263157893,null,null,null,"2021-09-26",null,null,null,null,null,null,0,null,null,3,0,{"$f":"IF($AV$23=1,1,0)","v":0},{"$f":"IF($AW$23=1,1,0)","v":0},{"$f":"IF($AX$23=1,3,0)","v":3},{"$f":"IF($AY$23=1,2,0)","v":0},{"$f":"IF($AZ$23=1,1,0)","v":0},{"$f":"IF($BA$23=1,7,0)","v":0},{"$f":"IF($BB$23=1,7,0)","v":0}]
[null,null,4,{"$f":"F6/F7","v":25},"2021-11-25","2021-12-30",null,"2022-04-19","2022-05-24",null,0.85,21.25,2.75,0.23,3.4,42,null,11,2022,null,null,null,{"$f":"(H34+I34)/2+W22","v":"2022-07-05T12:00:00"},2,{"$f":"(H34+I34)/2+Y22","v":"2022-08-04T12:00:00"},2,{"$f":"(H34+I34)/2+AA22","v":"2022-11-02T12:00:00"},32,{"$f":"(H34+I34)/2+AC22","v":"2022-11-02T12:00:00"},6,{"$f":"(H34+I34)/2+AE22","v":"2023-03-02T12:00:00"},0.36842105263157893,null,null,null,"2021-11-25",null,null,null,null,null,null,0,null,null,4,0,{"$f":"IF($AV$23=1,2,0)","v":0},{"$f":"IF($AW$23=1,2,0)","v":0},{"$f":"IF($AX$23=1,4,0)","v":4},{"$f":"IF($AY$23=1,3,0)","v":0},{"$f":"IF($AZ$23=1,2,0)","v":0},{"$f":"IF($BA$23=1,1,0)","v":0},{"$f":"IF($BB$23=1,8,0)","v":0}]
[null,null,1,{"$f":"F6/F7","v":25},"2022-01-24","2022-02-28",null,"2022-06-18","2022-07-23",null,0.85,21.25,2.75,0.23,3.4,42,null,1,2022,null,null,null,{"$f":"(H35+I35)/2+W22","v":"2022-09-03T12:00:00"},2,{"$f":"(H35+I35)/2+Y22","v":"2022-10-03T12:00:00"},2,{"$f":"(H35+I35)/2+AA22","v":"2023-01-01T12:00:00"},32,{"$f":"(H35+I35)/2+AC22","v":"2023-01-01T12:00:00"},6,{"$f":"(H35+I35)/2+AE22","v":"2023-05-01T12:00:00"},0.36842105263157893,null,null,null,"2022-01-24",null,null,null,null,null,null,0,null,null,1,0,{"$f":"IF($AV$23=1,1,0)","v":0},{"$f":"IF($AW$23=1,3,0)","v":0},{"$f":"IF($AX$23=1,1,0)","v":1},{"$f":"IF($AY$23=1,4,0)","v":0},{"$f":"IF($AZ$23=1,3,0)","v":0},{"$f":"IF($BA$23=1,2,0)","v":0},{"$f":"IF($BB$23=1,1,0)","v":0}]
[null,null,2,{"$f":"F6/F7","v":25},"2022-03-25","2022-04-29",null,{"$f":"E36+145","v":"2022-08-17"},"2022-09-21",null,0.7,{"$f":"D36*K36","v":17.5},2.75,0.23,3.4,34,null,3,2022,null,null,null,{"$f":"(H36+I36)/2+W22","v":"2022-11-02T12:00:00"},2,{"$f":"(H36+I36)/2+Y22","v":"2022-12-02T12:00:00"},2,{"$f":"(H36+I36)/2+AA22","v":"2023-03-02T12:00:00"},26,{"$f":"(H36+I36)/2+AC22","v":"2023-03-02T12:00:00"},4,{"$f":"(H36+I36)/2+AE22","v":"2023-06-30T12:00:00"},0.2982456140350877,null,null,null,"2022-03-25",null,null,null,null,null,null,0,null,null,2,0,{"$f":"IF($AV$23=1,2,0)","v":0},{"$f":"IF($AW$23=1,1,0)","v":0},{"$f":"IF($AX$23=1,2,0)","v":2},{"$f":"IF($AY$23=1,5,0)","v":0},{"$f":"IF($AZ$23=1,4,0)","v":0},{"$f":"IF($BA$23=1,3,0)","v":0},{"$f":"IF($BB$23=1,2,0)","v":0}]
[null,null,3,{"$f":"F6/F7","v":25},"2022-05-24","2022-06-28",null,"2022-10-16","2022-11-20",null,0.7,{"$f":"D37*K37","v":17.5},2.75,0.23,3.4,34,null,5,2022,null,null,null,{"$f":"(H37+I37)/2+W22","v":"2023-01-01T12:00:00"},2,{"$f":"(H37+I37)/2+Y22","v":"2023-01-31T12:00:00"},2,{"$f":"(H37+I37)/2+AA22","v":"2023-05-01T12:00:00"},26,{"$f":"(H37+I37)/2+AC22","v":"2023-05-01T12:00:00"},4,{"$f":"(H37+I37)/2+AE22","v":"2023-08-29T12:00:00"},0.2982456140350877,null,null,null,"2022-05-24",null,null,null,null,null,null,0,null,null,3,0,{"$f":"IF($AV$23=1,1,0)","v":0},{"$f":"IF($AW$23=1,2,0)","v":0},{"$f":"IF($AX$23=1,3,0)","v":3},{"$f":"IF($AY$23=1,1,0)","v":0},{"$f":"IF($AZ$23=1,5,0)","v":0},{"$f":"IF($BA$23=1,4,0)","v":0},{"$f":"IF($BB$23=1,3,0)","v":0}]
[null,null,4,{"$f":"F6/F7","v":25},"2022-07-23","2022-08-27",null,"2022-12-15","2023-01-19",null,0.7,{"$f":"D38*K38","v":17.5},2.75,0.23,3.4,34,null,7,2022,null,null,null,{"$f":"(H38+I38)/2+W22","v":"2023-03-02T12:00:00"},2,{"$f":"(H38+I38)/2+Y22","v":"2023-04-01T12:00:00"},2,{"$f":"(H38+I38)/2+AA22","v":"2023-06-30T12:00:00"},26,{"$f":"(H38+I38)/2+AC22","v":"2023-06-30T12:00:00"},4,{"$f":"(H38+I38)/2+AE22","v":"2023-10-28T12:00:00"},0.2982456140350877,null,null,null,"2022-07-23",null,null,null,null,null,null,0,null,null,4,0,{"$f":"IF($AV$23=1,2,0)","v":0},{"$f":"IF($AW$23=1,3,0)","v":0},{"$f":"IF($AX$23=1,4,0)","v":4},{"$f":"IF($AY$23=1,2,0)","v":0},{"$f":"IF($AZ$23=1,6,0)","v":0},{"$f":"IF($BA$23=1,5,0)","v":0},{"$f":"IF($BB$23=1,4,0)","v":0}]
[null,null,1,{"$f":"F6/F7","v":25},"2022-09-21","2022-10-26",null,{"$f":"E39+145","v":"2023-02-13"},{"$f":"F39+145","v":"2023-03-20"},null,0.85,{"$f":"D39*K39","v":21.25},2.75,0.23,3.4,42,null,9,2023,null,null,null,{"$f":"(H39+I39)/2+W22","v":"2023-05-01T12:00:00"},2,{"$f":"(H39+I39)/2+Y22","v":"2023-05-31T12:00:00"},2,{"$f":"(H39+I39)/2+AA22","v":"2023-08-29T12:00:00"},32,{"$f":"(H39+I39)/2+AC22","v":"2023-08-29T12:00:00"},6,{"$f":"(H39+I39)/2+AE22","v":"2023-12-27T12:00:00"},0.36842105263157893,null,null,null,"2022-09-21",null,null,null,null,null,null,0,null,null,1,0,{"$f":"IF($AV$23=1,1,0)","v":0},{"$f":"IF($AW$23=1,1,0)","v":0},{"$f":"IF($AX$23=1,1,0)","v":1},{"$f":"IF($AY$23=1,3,0)","v":0},{"$f":"IF($AZ$23=1,1,0)","v":0},{"$f":"IF($BA$23=1,6,0)","v":0},{"$f":"IF($BB$23=1,5,0)","v":0}]
[null,null,2,{"$f":"F6/F7","v":25},"2022-11-20","2022-12-25",null,"2023-04-14","2023-05-19",null,0.85,21.25,2.75,0.23,3.4,42,null,11,2023,null,null,null,{"$f":"(H40+I40)/2+W22","v":"2023-06-30T12:00:00"},2,{"$f":"(H40+I40)/2+Y22","v":"2023-07-30T12:00:00"},2,{"$f":"(H40+I40)/2+AA22","v":"2023-10-28T12:00:00"},32,{"$f":"(H40+I40)/2+AC22","v":"2023-10-28T12:00:00"},6,{"$f":"(H40+I40)/2+AE22","v":"2024-02-25T12:00:00"},0.36842105263157893,null,null,null,"2022-11-20",null,null,null,null,null,null,0,null,null,2,0,{"$f":"IF($AV$23=1,2,0)","v":0},{"$f":"IF($AW$23=1,2,0)","v":0},{"$f":"IF($AX$23=1,2,0)","v":2},{"$f":"IF($AY$23=1,4,0)","v":0},{"$f":"IF($AZ$23=1,2,0)","v":0},{"$f":"IF($BA$23=1,7,0)","v":0},{"$f":"IF($BB$23=1,6,0)","v":0}]
[null,null,3,{"$f":"F6/F7","v":25},"2023-01-19","2023-02-23",null,"2023-06-13","2023-07-18",null,0.85,21.25,2.75,0.23,3.4,42,null,1,2023,null,null,null,{"$f":"(H41+I41)/2+W22","v":"2023-08-29T12:00:00"},2,{"$f":"(H41+I41)/2+Y22","v":"2023-09-28T12:00:00"},2,{"$f":"(H41+I41)/2+AA22","v":"2023-12-27T12:00:00"},32,{"$f":"(H41+I41)/2+AC22","v":"2023-12-27T12:00:00"},6,{"$f":"(H41+I41)/2+AE22","v":"2024-04-25T12:00:00"},0.36842105263157893,null,null,null,"2023-01-19",null,null,null,null,null,null,0,null,null,3,0,{"$f":"IF($AV$23=1,1,0)","v":0},{"$f":"IF($AW$23=1,3,0)","v":0},{"$f":"IF($AX$23=1,3,0)","v":3},{"$f":"IF($AY$23=1,5,0)","v":0},{"$f":"IF($AZ$23=1,3,0)","v":0},{"$f":"IF($BA$23=1,1,0)","v":0},{"$f":"IF($BB$23=1,7,0)","v":0}]
[null,null,4,{"$f":"F6/F7","v":25},"2023-03-20","2023-04-24",null,"2023-08-12","2023-09-16",null,0.7,{"$f":"D42*K42","v":17.5},2.75,0.23,3.4,34,null,3,2023,null,null,null,{"$f":"(H42+I42)/2+W22","v":"2023-10-28T12:00:00"},2,{"$f":"(H42+I42)/2+Y22","v":"2023-11-27T12:00:00"},2,{"$f":"(H42+I42)/2+AA22","v":"2024-02-25T12:00:00"},26,{"$f":"(H42+I42)/2+AC22","v":"2024-02-25T12:00:00"},4,{"$f":"(H42+I42)/2+AE22","v":"2024-06-24T12:00:00"},0.2982456140350877,null,null,null,"2023-03-20",null,null,null,null,null,null,0,null,null,4,0,{"$f":"IF($AV$23=1,2,0)","v":0},{"$f":"IF($AW$23=1,1,0)","v":0},{"$f":"IF($AX$23=1,4,0)","v":4},{"$f":"IF($AY$23=1,1,0)","v":0},{"$f":"IF($AZ$23=1,4,0)","v":0},{"$f":"IF($BA$23=1,2,0)","v":0},{"$f":"IF($BB$23=1,8,0)","v":0}]
[null,null,1,{"$f":"F6/F7","v":25},"2023-05-19","2023-06-23",null,"2023-10-11","2023-11-15",null,0.7,17.5,2.75,0.23,3.4,34,null,5,2023,null,null,null,{"$f":"(H43+I43)/2+W22","v":"2023-12-27T12:00:00"},2,{"$f":"(H43+I43)/2+Y22","v":"2024-01-26T12:00:00"},2,{"$f":"(H43+I43)/2+AA22","v":"2024-04-25T12:00:00"},26,{"$f":"(H43+I43)/2+AC22","v":"2024-04-25T12:00:00"},4,{"$f":"(H43+I43)/2+AE22","v":"2024-08-23T12:00:00"},0.2982456140350877,null,null,null,"2023-05-19",null,null,null,null,null,null,0,null,null,1,0,{"$f":"IF($AV$23=1,1,0)","v":0},{"$f":"IF($AW$23=1,2,0)","v":0},{"$f":"IF($AX$23=1,1,0)","v":1},{"$f":"IF($AY$23=1,2,0)","v":0},{"$f":"IF($AZ$23=1,5,0)","v":0},{"$f":"IF($BA$23=1,3,0)","v":0},{"$f":"IF($BB$23=1,1,0)","v":0}]
[null,null,2,{"$f":"F6/F7","v":25},"2023-07-18",{"$f":"E44+35","v":"2023-08-22"},null,{"$f":"E44+145","v":"2023-12-10"},{"$f":"F44+145","v":"2024-01-14"},null,0.7,17.5,2.75,0.23,3.4,34,null,7,2023,null,null,null,{"$f":"(H44+I44)/2+W22","v":"2024-02-25T12:00:00"},2,{"$f":"(H44+I44)/2+Y22","v":"2024-03-26T12:00:00"},2,{"$f":"(H44+I44)/2+AA22","v":"2024-06-24T12:00:00"},26,{"$f":"(H44+I44)/2+AC22","v":"2024-06-24T12:00:00"},4,{"$f":"(H44+I44)/2+AE22","v":"2024-10-22T12:00:00"},0.2982456140350877,null,null,null,"2023-07-18",null,null,null,null,null,null,0,null,null,2,0,{"$f":"IF($AV$23=1,2,0)","v":0},{"$f":"IF($AW$23=1,3,0)","v":0},{"$f":"IF($AX$23=1,2,0)","v":2},{"$f":"IF($AY$23=1,3,0)","v":0},{"$f":"IF($AZ$23=1,6,0)","v":0},{"$f":"IF($BA$23=1,4,0)","v":0},{"$f":"IF($BB$23=1,2,0)","v":0}]
[null,null,3,{"$f":"F6/F7","v":25},"2023-09-16","2023-10-21",null,"2024-02-08","2024-03-14",null,0.85,21.25,2.75,0.23,3.4,42,null,9,2024,null,null,null,{"$f":"(H45+I45)/2+W22","v":"2024-04-25T12:00:00"},2,{"$f":"(H45+I45)/2+Y22","v":"2024-05-25T12:00:00"},2,{"$f":"(H45+I45)/2+AA22","v":"2024-08-23T12:00:00"},32,{"$f":"(H45+I45)/2+AC22","v":"2024-08-23T12:00:00"},6,{"$f":"(H45+I45)/2+AE22","v":"2024-12-21T12:00:00"},0.36842105263157893,null,null,null,"2023-09-16",null,null,null,null,null,null,0,null,null,3,0,{"$f":"IF($AV$23=1,1,0)","v":0},{"$f":"IF($AW$23=1,1,0)","v":0},{"$f":"IF($AX$23=1,3,0)","v":3},{"$f":"IF($AY$23=1,4,0)","v":0},{"$f":"IF($AZ$23=1,1,0)","v":0},{"$f":"IF($BA$23=1,5,0)","v":0},{"$f":"IF($BB$23=1,3,0)","v":0}]
[null,null,4,{"$f":"F6/F7","v":25},"2023-11-15","2023-12-20",null,"2024-04-08","2024-05-13",null,0.85,21.25,2.75,0.23,3.4,42,null,11,2024,null,null,null,{"$f":"(H46+I46)/2+W22","v":"2024-06-24T12:00:00"},2,{"$f":"(H46+I46)/2+Y22","v":"2024-07-24T12:00:00"},2,{"$f":"(H46+I46)/2+AA22","v":"2024-10-22T12:00:00"},32,{"$f":"(H46+I46)/2+AC22","v":"2024-10-22T12:00:00"},6,{"$f":"(H46+I46)/2+AE22","v":"2025-02-19T12:00:00"},0.36842105263157893,null,null,null,"2023-11-15",null,null,null,null,null,null,0,null,null,4,0,{"$f":"IF($AV$23=1,2,0)","v":0},{"$f":"IF($AW$23=1,2,0)","v":0},{"$f":"IF($AX$23=1,4,0)","v":4},{"$f":"IF($AY$23=1,5,0)","v":0},{"$f":"IF($AZ$23=1,2,0)","v":0},{"$f":"IF($BA$23=1,6,0)","v":0},{"$f":"IF($BB$23=1,4,0)","v":0}]
[null,null,1,{"$f":"F6/F7","v":25},"2024-01-14","2024-02-18",null,"2024-06-07","2024-07-12",null,0.85,21.25,2.75,0.23,3.4,42,null,1,2024,null,null,null,{"$f":"(H47+I47)/2+W22","v":"2024-08-23T12:00:00"},2,{"$f":"(H47+I47)/2+Y22","v":"2024-09-22T12:00:00"},2,{"$f":"(H47+I47)/2+AA22","v":"2024-12-21T12:00:00"},32,{"$f":"(H47+I47)/2+AC22","v":"2024-12-21T12:00:00"},6,{"$f":"(H47+I47)/2+AE22","v":"2025-04-20T12:00:00"},0.36842105263157893,null,null,null,"2024-01-14",null,null,null,null,null,null,0,null,null,1,0,{"$f":"IF($AV$23=1,1,0)","v":0},{"$f":"IF($AW$23=1,3,0)","v":0},{"$f":"IF($AX$23=1,1,0)","v":1},{"$f":"IF($AY$23=1,1,0)","v":0},{"$f":"IF($AZ$23=1,3,0)","v":0},{"$f":"IF($BA$23=1,7,0)","v":0},{"$f":"IF($BB$23=1,5,0)","v":0}]
[null,null,2,{"$f":"F6/F7","v":25},"2024-03-14","2024-04-18",null,{"$f":"E48+145","v":"2024-08-06"},{"$f":"F48+145","v":"2024-09-10"},null,0.7,17.5,2.75,0.23,3.4,34,null,3,2024,null,null,null,{"$f":"(H48+I48)/2+W22","v":"2024-10-22T12:00:00"},2,{"$f":"(H48+I48)/2+Y22","v":"2024-11-21T12:00:00"},2,{"$f":"(H48+I48)/2+AA22","v":"2025-02-19T12:00:00"},26,{"$f":"(H48+I48)/2+AC22","v":"2025-02-19T12:00:00"},4,{"$f":"(H48+I48)/2+AE22","v":"2025-06-19T12:00:00"},0.2982456140350877,null,null,null,"2024-03-14",null,null,null,null,null,null,0,null,null,2,0,{"$f":"IF($AV$23=1,2,0)","v":0},{"$f":"IF($AW$23=1,1,0)","v":0},{"$f":"IF($AX$23=1,2,0)","v":2},{"$f":"IF($AY$23=1,2,0)","v":0},{"$f":"IF($AZ$23=1,4,0)","v":0},{"$f":"IF($BA$23=1,1,0)","v":0},{"$f":"IF($BB$23=1,6,0)","v":0}]
[null,null,3,{"$f":"F6/F7","v":25},"2024-05-13","2024-06-17",null,"2024-10-05","2024-11-09",null,0.7,17.5,2.75,0.23,3.4,34,null,5,2024,null,null,null,{"$f":"(H49+I49)/2+W22","v":"2024-12-21T12:00:00"},2,{"$f":"(H49+I49)/2+Y22","v":"2025-01-20T12:00:00"},2,{"$f":"(H49+I49)/2+AA22","v":"2025-04-20T12:00:00"},26,{"$f":"(H49+I49)/2+AC22","v":"2025-04-20T12:00:00"},4,{"$f":"(H49+I49)/2+AE22","v":"2025-08-18T12:00:00"},0.2982456140350877,null,null,null,"2024-05-13",null,null,null,null,null,null,0,null,null,3,0,{"$f":"IF($AV$23=1,1,0)","v":0},{"$f":"IF($AW$23=1,2,0)","v":0},{"$f":"IF($AX$23=1,3,0)","v":3},{"$f":"IF($AY$23=1,3,0)","v":0},{"$f":"IF($AZ$23=1,5,0)","v":0},{"$f":"IF($BA$23=1,2,0)","v":0},{"$f":"IF($BB$23=1,7,0)","v":0}]
[null,null,4,{"$f":"F6/F7","v":25},"2024-07-12","2024-08-16",null,"2024-12-04","2025-01-08",null,0.7,17.5,2.75,0.23,3.4,34,null,7,2024,null,null,null,{"$f":"(H50+I50)/2+W22","v":"2025-02-19T12:00:00"},2,{"$f":"(H50+I50)/2+Y22","v":"2025-03-21T12:00:00"},2,{"$f":"(H50+I50)/2+AA22","v":"2025-06-19T12:00:00"},26,{"$f":"(H50+I50)/2+AC22","v":"2025-06-19T12:00:00"},4,{"$f":"(H50+I50)/2+AE22","v":"2025-10-17T12:00:00"},0.2982456140350877,null,null,null,"2024-07-12",null,null,null,null,null,null,0,null,null,4,0,{"$f":"IF($AV$23=1,2,0)","v":0},{"$f":"IF($AW$23=1,3,0)","v":0},{"$f":"IF($AX$23=1,4,0)","v":4},{"$f":"IF($AY$23=1,4,0)","v":0},{"$f":"IF($AZ$23=1,6,0)","v":0},{"$f":"IF($BA$23=1,3,0)","v":0},{"$f":"IF($BB$23=1,8,0)","v":0}]
[]
[]
[null,null,"Prévisionnel des performances annuelles",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Prévision des ventes totales  par année "]
[]
[]
[null,null,null,null,"Rythme d'agnelage",null,null,"Prévisionnel d'agneaux réchappés excluant le remplacement par année",null,null,null,"Kg d'agneaux vendus (incluant les agnelles et béliers)",null,null,"Kg d'agneaux vendus par brebis (incluant les agnelles et béliers)",null,null,null,null,null,null,null,{"$f":"W21","v":"AGNEAUX LAIT"},null,{"$f":"Y21","v":"AGNEAUX LÉGERS"},null,{"$f":"AA21","v":"AGNEAUX LOURDS"},null,{"$f":"AC21","v":"AGNELLES "},null,{"$f":"AE21","v":"BÉLIERS "}]
[]
[null,null,null,{"$f":"DATE(YEAR(I27),1,1)","v":"2021-01-01"},{"$f":"12/$F$8*((IF(AND(I27>=$D$58,I27<$D$59),K27*D27,0))+(IF(AND(I28>=$D$58,I28<$D$59),K28*D28,0))+(IF(AND(I29>=$D$58,I29<$D$59),K29*D29,0))+(IF(AND(I30>=$D$58,I30<$D$59),K30*D30,0))+(IF(AND(I31>=$D$58,I31<$D$59),K31*D31,0))+(IF(AND(I32>=$D$58,I32<$D$59),K32*D32,0))+(IF(AND(I33>=$D$58,I33<$D$59),K33*D33,0))+(IF(AND(I34>=$D$58,I34<$D$59),K34*D34,0))+(IF(AND(I35>=$D$58,I35<$D$59),K35*D35,0))+(IF(AND(I36>=$D$58,I36<$D$59),K36*D36,0))+(IF(AND(I37>=$D$58,I37<$D$59),K37*D37,0))+(IF(AND(I38>=$D$58,I38<$D$59),K38*D38,0))+(IF(AND(I39>=$D$58,I39<$D$59),K39*D39,0))+(IF(AND(I40>=$D$58,I40<$D$59),K40*D40,0))+(IF(AND(I41>=$D$58,I41<$D$59),K41*D41,0))+(IF(AND(I42>=$D$58,I42<$D$59),K42*D42,0))+(IF(AND(I43>=$D$58,I43<$D$59),K43*D43,0))+(IF(AND(I44>=$D$58,I44<$D$59),K44*D44,0))+(IF(AND(I45>=$D$58,I45<$D$59),K45*D45,0))+(IF(AND(I46>=$D$58,I46<$D$59),K46*D46,0))+(IF(AND(I47>=$D$58,I47<$D$59),K47*D47,0))+(IF(AND(I48>=$D$58,I48<$D$59),K48*D48,0))+(IF(AND(I49>=$D$58,I49<$D$59),K49*D49,0))+(IF(AND(I50>=$D$58,I50<$D$59),K50*D50,0)))/((IF(AND(I27>=$D$58,I27<$D$59),D27,0))+(IF(AND(I28>=$D$58,I28<$D$59),D28,0))+(IF(AND(I29>=$D$58,I29<$D$59),D29,0))+(IF(AND(I30>=$D$58,I30<$D$59),D30,0))+(IF(AND(I31>=$D$58,I31<$D$59),D31,0))+(IF(AND(I32>=$D$58,I32<$D$59),D32,0))+(IF(AND(I33>=$D$58,I33<$D$59),D33,0))+(IF(AND(I34>=$D$58,I34<$D$59),D34,0))+(IF(AND(I35>=$D$58,I35<$D$59),D35,0))+(IF(AND(I36>=$D$58,I36<$D$59),D36,0))+(IF(AND(I37>=$D$58,I37<$D$59),D37,0))+(IF(AND(I38>=$D$58,I38<$D$59),D38,0))+(IF(AND(I39>=$D$58,I39<$D$59),D39,0))+(IF(AND(I40>=$D$58,I40<$D$59),D40,0))+(IF(AND(I41>=$D$58,I41<$D$59),D41,0))+(IF(AND(I42>=$D$58,I42<$D$59),D42,0))+(IF(AND(I43>=$D$58,I43<$D$59),D43,0))+(IF(AND(I44>=$D$58,I44<$D$59),D44,0))+(IF(AND(I45>=$D$58,I45<$D$59),D45,0))+(IF(AND(I46>=$D$58,I46<$D$59),D46,0))+(IF(AND(I47>=$D$58,I47<$D$59),D47,0))+(IF(AND(I48>=$D$58,I48<$D$59),D48,0))+(IF(AND(I49>=$D$58,I49<$D$59),D49,0))+(IF(AND(I50>=$D$58,I50<$D$59),D50,0)))","v":1.1850000000000001},null,null,null,{"$f":"ROUND((IF(AND(I27>=$D$58,I27<$D$59),P27,0))+(IF(AND(I28>=$D$58,I28<$D$59),P28,0))+(IF(AND(I29>=$D$58,I29<$D$59),P29,0))+(IF(AND(I30>=$D$58,I30<$D$59),P30,0))+(IF(AND(I31>=$D$58,I31<$D$59),P31,0))+(IF(AND(I32>=$D$58,I32<$D$59),P32,0))+(IF(AND(I33>=$D$58,I33<$D$59),P33,0))+(IF(AND(I34>=$D$58,I34<$D$59),P34,0))+(IF(AND(I35>=$D$58,I35<$D$59),P35,0))+(IF(AND(I36>=$D$58,I36<$D$59),P36,0))+(IF(AND(I37>=$D$58,I37<$D$59),P37,0))+(IF(AND(I38>=$D$58,I38<$D$59),P38,0))+(IF(AND(I39>=$D$58,I39<$D$59),P39,0))+(IF(AND(I40>=$D$58,I40<$D$59),P40,0))+(IF(AND(I41>=$D$58,I41<$D$59),P41,0))+(IF(AND(I42>=$D$58,I42<$D$59),P42,0))+(IF(AND(I43>=$D$58,I43<$D$59),P43,0))+(IF(AND(I44>=$D$58,I44<$D$59),P44,0))+(IF(AND(I45>=$D$58,I45<$D$59),P45,0))+(IF(AND(I46>=$D$58,I46<$D$59),P46,0))+(IF(AND(I47>=$D$58,I47<$D$59),P47,0))+(IF(AND(I48>=$D$58,I48<$D$59),P48,0))+(IF(AND(I49>=$D$58,I49<$D$59),P49,0))+(IF(AND(I50>=$D$58,I50<$D$59),P50,0)),0)","v":194},null,null,null,{"$f":"X58*$W$23+Z58*$Y$23+AB58*$AA$23+AD58*$AC$23+AF58*$AE$23","v":3496},null,{"$f":"(X58*$W$23+Z58*$Y$23+AB58*$AA$23+AD58*$AC$23+AF58*$AE$23)/$F$6","v":34.96},null,null,null,null,null,null,null,{"$f":"DATE(YEAR(W27),1,1)","v":"2021-01-01"},{"$f":"ROUND((IF(AND(W27>=$W$58,W27<$W$59),X27,0))+(IF(AND(W28>=$W$58,W28<$W$59),X28,0))+(IF(AND(W29>=$W$58,W29<$W$59),X29,0))+(IF(AND(W30>=$W$58,W30<$W$59),X30,0))+(IF(AND(W31>=$W$58,W31<$W$59),X31,0))+(IF(AND(W32>=$W$58,W32<$W$59),X32,0))+(IF(AND(W33>=$W$58,W33<$W$59),X33,0))+(IF(AND(W34>=$W$58,W34<$W$59),X34,0))+(IF(AND(W35>=$W$58,W35<$W$59),X35,0))+(IF(AND(W36>=$W$58,W36<$W$59),X36,0))+(IF(AND(W37>=$W$58,W37<$W$59),X37,0))+(IF(AND(W38>=$W$58,W38<$W$59),X38,0))+(IF(AND(W39>=$W$58,W39<$W$59),X39,0))+(IF(AND(W40>=$W$58,W40<$W$59),X40,0))+(IF(AND(W41>=$W$58,W41<$W$59),X41,0))+(IF(AND(W42>=$W$58,W42<$W$59),X42,0))+(IF(AND(W43>=$W$58,W43<$W$59),X43,0))+(IF(AND(W44>=$W$58,W44<$W$59),X44,0))+(IF(AND(W45>=$W$58,W45<$W$59),X45,0))+(IF(AND(W46>=$W$58,W46<$W$59),X46,0))+(IF(AND(W47>=$W$58,W47<$W$59),X47,0))+(IF(AND(W48>=$W$58,W48<$W$59),X48,0))+(IF(AND(W49>=$W$58,W49<$W$59),X49,0))+(IF(AND(W50>=$W$58,W50<$W$59),X50,0)),0)","v":8},null,{"$f":"ROUND((IF(AND(Y27>=$W$58,Y27<$W$59),Z27,0))+(IF(AND(Y28>=$W$58,Y28<$W$59),Z28,0))+(IF(AND(Y29>=$W$58,Y29<$W$59),Z29,0))+(IF(AND(Y30>=$W$58,Y30<$W$59),Z30,0))+(IF(AND(Y31>=$W$58,Y31<$W$59),Z31,0))+(IF(AND(Y32>=$W$58,Y32<$W$59),Z32,0))+(IF(AND(Y33>=$W$58,Y33<$W$59),Z33,0))+(IF(AND(Y34>=$W$58,Y34<$W$59),Z34,0))+(IF(AND(Y35>=$W$58,Y35<$W$59),Z35,0))+(IF(AND(Y36>=$W$58,Y36<$W$59),Z36,0))+(IF(AND(Y37>=$W$58,Y37<$W$59),Z37,0))+(IF(AND(Y38>=$W$58,Y38<$W$59),Z38,0))+(IF(AND(Y39>=$W$58,Y39<$W$59),Z39,0))+(IF(AND(Y40>=$W$58,Y40<$W$59),Z40,0))+(IF(AND(Y41>=$W$58,Y41<$W$59),Z41,0))+(IF(AND(Y42>=$W$58,Y42<$W$59),Z42,0))+(IF(AND(Y43>=$W$58,Y43<$W$59),Z43,0))+(IF(AND(Y44>=$W$58,Y44<$W$59),Z44,0))+(IF(AND(Y45>=$W$58,Y45<$W$59),Z45,0))+(IF(AND(Y46>=$W$58,Y46<$W$59),Z46,0))+(IF(AND(Y47>=$W$58,Y47<$W$59),Z47,0))+(IF(AND(Y48>=$W$58,Y48<$W$59),Z48,0))+(IF(AND(Y49>=$W$58,Y49<$W$59),Z49,0))+(IF(AND(Y50>=$W$58,Y50<$W$59),Z50,0)),0)","v":8},null,{"$f":"ROUND((IF(AND(AA27>=$W$58,AA27<$W$59),AB27,0))+(IF(AND(AA28>=$W$58,AA28<$W$59),AB28,0))+(IF(AND(AA29>=$W$58,AA29<$W$59),AB29,0))+(IF(AND(AA30>=$W$58,AA30<$W$59),AB30,0))+(IF(AND(AA31>=$W$58,AA31<$W$59),AB31,0))+(IF(AND(AA32>=$W$58,AA32<$W$59),AB32,0))+(IF(AND(AA33>=$W$58,AA33<$W$59),AB33,0))+(IF(AND(AA34>=$W$58,AA34<$W$59),AB34,0))+(IF(AND(AA35>=$W$58,AA35<$W$59),AB35,0))+(IF(AND(AA36>=$W$58,AA36<$W$59),AB36,0))+(IF(AND(AA37>=$W$58,AA37<$W$59),AB37,0))+(IF(AND(AA38>=$W$58,AA38<$W$59),AB38,0))+(IF(AND(AA39>=$W$58,AA39<$W$59),AB39,0))+(IF(AND(AA40>=$W$58,AA40<$W$59),AB40,0))+(IF(AND(AA41>=$W$58,AA41<$W$59),AB41,0))+(IF(AND(AA42>=$W$58,AA42<$W$59),AB42,0))+(IF(AND(AA43>=$W$58,AA43<$W$59),AB43,0))+(IF(AND(AA44>=$W$58,AA44<$W$59),AB44,0))+(IF(AND(AA45>=$W$58,AA45<$W$59),AB45,0))+(IF(AND(AA46>=$W$58,AA46<$W$59),AB46,0))+(IF(AND(AA47>=$W$58,AA47<$W$59),AB47,0))+(IF(AND(AA48>=$W$58,AA48<$W$59),AB48,0))+(IF(AND(AA49>=$W$58,AA49<$W$59),AB49,0))+(IF(AND(AA50>=$W$58,AA50<$W$59),AB50,0)),0)","v":64},null,{"$f":"ROUND((IF(AND(AC27>=$W$58,AC27<$W$59),AD27,0))+(IF(AND(AC28>=$W$58,AC28<$W$59),AD28,0))+(IF(AND(AC29>=$W$58,AC29<$W$59),AD29,0))+(IF(AND(AC30>=$W$58,AC30<$W$59),AD30,0))+(IF(AND(AC31>=$W$58,AC31<$W$59),AD31,0))+(IF(AND(AC32>=$W$58,AC32<$W$59),AD32,0))+(IF(AND(AC33>=$W$58,AC33<$W$59),AD33,0))+(IF(AND(AC34>=$W$58,AC34<$W$59),AD34,0))+(IF(AND(AC35>=$W$58,AC35<$W$59),AD35,0))+(IF(AND(AC36>=$W$58,AC36<$W$59),AD36,0))+(IF(AND(AC37>=$W$58,AC37<$W$59),AD37,0))+(IF(AND(AC38>=$W$58,AC38<$W$59),AD38,0))+(IF(AND(AC39>=$W$58,AC39<$W$59),AD39,0))+(IF(AND(AC40>=$W$58,AC40<$W$59),AD40,0))+(IF(AND(AC41>=$W$58,AC41<$W$59),AD41,0))+(IF(AND(AC42>=$W$58,AC42<$W$59),AD42,0))+(IF(AND(AC43>=$W$58,AC43<$W$59),AD43,0))+(IF(AND(AC44>=$W$58,AC44<$W$59),AD44,0))+(IF(AND(AC45>=$W$58,AC45<$W$59),AD45,0))+(IF(AND(AC46>=$W$58,AC46<$W$59),AD46,0))+(IF(AND(AC47>=$W$58,AC47<$W$59),AD47,0))+(IF(AND(AC48>=$W$58,AC48<$W$59),AD48,0))+(IF(AND(AC49>=$W$58,AC49<$W$59),AD49,0))+(IF(AND(AC50>=$W$58,AC50<$W$59),AD50,0)),0)","v":12},null,{"$f":"ROUND((IF(AND(AE27>=$W$58,AE27<$W$59),AF27,0))+(IF(AND(AE28>=$W$58,AE28<$W$59),AF28,0))+(IF(AND(AE29>=$W$58,AE29<$W$59),AF29,0))+(IF(AND(AE30>=$W$58,AE30<$W$59),AF30,0))+(IF(AND(AE31>=$W$58,AE31<$W$59),AF31,0))+(IF(AND(AE32>=$W$58,AE32<$W$59),AF32,0))+(IF(AND(AE33>=$W$58,AE33<$W$59),AF33,0))+(IF(AND(AE34>=$W$58,AE34<$W$59),AF34,0))+(IF(AND(AE35>=$W$58,AE35<$W$59),AF35,0))+(IF(AND(AE36>=$W$58,AE36<$W$59),AF36,0))+(IF(AND(AE37>=$W$58,AE37<$W$59),AF37,0))+(IF(AND(AE38>=$W$58,AE38<$W$59),AF38,0))+(IF(AND(AE39>=$W$58,AE39<$W$59),AF39,0))+(IF(AND(AE40>=$W$58,AE40<$W$59),AF40,0))+(IF(AND(AE41>=$W$58,AE41<$W$59),AF41,0))+(IF(AND(AE42>=$W$58,AE42<$W$59),AF42,0))+(IF(AND(AE43>=$W$58,AE43<$W$59),AF43,0))+(IF(AND(AE44>=$W$58,AE44<$W$59),AF44,0))+(IF(AND(AE45>=$W$58,AE45<$W$59),AF45,0))+(IF(AND(AE46>=$W$58,AE46<$W$59),AF46,0))+(IF(AND(AE47>=$W$58,AE47<$W$59),AF47,0))+(IF(AND(AE48>=$W$58,AE48<$W$59),AF48,0))+(IF(AND(AE49>=$W$58,AE49<$W$59),AF49,0))+(IF(AND(AE50>=$W$58,AE50<$W$59),AF50,0)),0)","v":0}]
[null,null,null,{"$f":"DATE(YEAR(I27+365),1,1)","v":"2022-01-01"},{"$f":"12/$F$8*((IF(AND(I27>=$D$59,I27<$D$60),K27*D27,0))+(IF(AND(I28>=$D$59,I28<$D$60),K28*D28,0))+(IF(AND(I29>=$D$59,I29<$D$60),K29*D29,0))+(IF(AND(I30>=$D$59,I30<$D$60),K30*D30,0))+(IF(AND(I31>=$D$59,I31<$D$60),K31*D31,0))+(IF(AND(I32>=$D$59,I32<$D$60),K32*D32,0))+(IF(AND(I33>=$D$59,I33<$D$60),K33*D33,0))+(IF(AND(I34>=$D$59,I34<$D$60),K34*D34,0))+(IF(AND(I35>=$D$59,I35<$D$60),K35*D35,0))+(IF(AND(I36>=$D$59,I36<$D$60),K36*D36,0))+(IF(AND(I37>=$D$59,I37<$D$60),K37*D37,0))+(IF(AND(I38>=$D$59,I38<$D$60),K38*D38,0))+(IF(AND(I39>=$D$59,I39<$D$60),K39*D39,0))+(IF(AND(I40>=$D$59,I40<$D$60),K40*D40,0))+(IF(AND(I41>=$D$59,I41<$D$60),K41*D41,0))+(IF(AND(I42>=$D$59,I42<$D$60),K42*D42,0))+(IF(AND(I43>=$D$59,I43<$D$60),K43*D43,0))+(IF(AND(I44>=$D$59,I44<$D$60),K44*D44,0))+(IF(AND(I45>=$D$59,I45<$D$60),K45*D45,0))+(IF(AND(I46>=$D$59,I46<$D$60),K46*D46,0))+(IF(AND(I47>=$D$59,I47<$D$60),K47*D47,0))+(IF(AND(I48>=$D$59,I48<$D$60),K48*D48,0))+(IF(AND(I49>=$D$59,I49<$D$60),K49*D49,0))+(IF(AND(I50>=$D$59,I50<$D$60),K50*D50,0)))/((IF(AND(I27>=$D$59,I27<$D$60),D27,0))+(IF(AND(I28>=$D$59,I28<$D$60),D28,0))+(IF(AND(I29>=$D$59,I29<$D$60),D29,0))+(IF(AND(I30>=$D$59,I30<$D$60),D30,0))+(IF(AND(I31>=$D$59,I31<$D$60),D31,0))+(IF(AND(I32>=$D$59,I32<$D$60),D32,0))+(IF(AND(I33>=$D$59,I33<$D$60),D33,0))+(IF(AND(I34>=$D$59,I34<$D$60),D34,0))+(IF(AND(I35>=$D$59,I35<$D$60),D35,0))+(IF(AND(I36>=$D$59,I36<$D$60),D36,0))+(IF(AND(I37>=$D$59,I37<$D$60),D37,0))+(IF(AND(I38>=$D$59,I38<$D$60),D38,0))+(IF(AND(I39>=$D$59,I39<$D$60),D39,0))+(IF(AND(I40>=$D$59,I40<$D$60),D40,0))+(IF(AND(I41>=$D$59,I41<$D$60),D41,0))+(IF(AND(I42>=$D$59,I42<$D$60),D42,0))+(IF(AND(I43>=$D$59,I43<$D$60),D43,0))+(IF(AND(I44>=$D$59,I44<$D$60),D44,0))+(IF(AND(I45>=$D$59,I45<$D$60),D45,0))+(IF(AND(I46>=$D$59,I46<$D$60),D46,0))+(IF(AND(I47>=$D$59,I47<$D$60),D47,0))+(IF(AND(I48>=$D$59,I48<$D$60),D48,0))+(IF(AND(I49>=$D$59,I49<$D$60),D49,0))+(IF(AND(I50>=$D$59,I50<$D$60),D50,0)))","v":1.1625000000000001},null,null,null,{"$f":"ROUND((IF(AND(I27>=$D$59,I27<$D$60),P27,0))+(IF(AND(I28>=$D$59,I28<$D$60),P28,0))+(IF(AND(I29>=$D$59,I29<$D$60),P29,0))+(IF(AND(I30>=$D$59,I30<$D$60),P30,0))+(IF(AND(I31>=$D$59,I31<$D$60),P31,0))+(IF(AND(I32>=$D$59,I32<$D$60),P32,0))+(IF(AND(I33>=$D$59,I33<$D$60),P33,0))+(IF(AND(I34>=$D$59,I34<$D$60),P34,0))+(IF(AND(I35>=$D$59,I35<$D$60),P35,0))+(IF(AND(I36>=$D$59,I36<$D$60),P36,0))+(IF(AND(I37>=$D$59,I37<$D$60),P37,0))+(IF(AND(I38>=$D$59,I38<$D$60),P38,0))+(IF(AND(I39>=$D$59,I39<$D$60),P39,0))+(IF(AND(I40>=$D$59,I40<$D$60),P40,0))+(IF(AND(I41>=$D$59,I41<$D$60),P41,0))+(IF(AND(I42>=$D$59,I42<$D$60),P42,0))+(IF(AND(I43>=$D$59,I43<$D$60),P43,0))+(IF(AND(I44>=$D$59,I44<$D$60),P44,0))+(IF(AND(I45>=$D$59,I45<$D$60),P45,0))+(IF(AND(I46>=$D$59,I46<$D$60),P46,0))+(IF(AND(I47>=$D$59,I47<$D$60),P47,0))+(IF(AND(I48>=$D$59,I48<$D$60),P48,0))+(IF(AND(I49>=$D$59,I49<$D$60),P49,0))+(IF(AND(I50>=$D$59,I50<$D$60),P50,0)),0)","v":228},null,null,null,{"$f":"X59*$W$23+Z59*$Y$23+AB59*$AA$23+AD59*$AC$23+AF59*$AE$23","v":8940.4},null,{"$f":"(X59*$W$23+Z59*$Y$23+AB59*$AA$23+AD59*$AC$23+AF59*$AE$23)/$F$6","v":89.403999999999996},null,null,null,null,null,null,null,{"$f":"DATE(YEAR(W27+365),1,1)","v":"2022-01-01"},{"$f":"ROUND((IF(AND(W27>=$W$59,W27<$W$60),X27,0))+(IF(AND(W28>=$W$59,W28<$W$60),X28,0))+(IF(AND(W29>=$W$59,W29<$W$60),X29,0))+(IF(AND(W30>=$W$59,W30<$W$60),X30,0))+(IF(AND(W31>=$W$59,W31<$W$60),X31,0))+(IF(AND(W32>=$W$59,W32<$W$60),X32,0))+(IF(AND(W33>=$W$59,W33<$W$60),X33,0))+(IF(AND(W34>=$W$59,W34<$W$60),X34,0))+(IF(AND(W35>=$W$59,W35<$W$60),X35,0))+(IF(AND(W36>=$W$59,W36<$W$60),X36,0))+(IF(AND(W37>=$W$59,W37<$W$60),X37,0))+(IF(AND(W38>=$W$59,W38<$W$60),X38,0))+(IF(AND(W39>=$W$59,W39<$W$60),X39,0))+(IF(AND(W40>=$W$59,W40<$W$60),X40,0))+(IF(AND(W41>=$W$59,W41<$W$60),X41,0))+(IF(AND(W42>=$W$59,W42<$W$60),X42,0))+(IF(AND(W43>=$W$59,W43<$W$60),X43,0))+(IF(AND(W44>=$W$59,W44<$W$60),X44,0))+(IF(AND(W45>=$W$59,W45<$W$60),X45,0))+(IF(AND(W46>=$W$59,W46<$W$60),X46,0))+(IF(AND(W47>=$W$59,W47<$W$60),X47,0))+(IF(AND(W48>=$W$59,W48<$W$60),X48,0))+(IF(AND(W49>=$W$59,W49<$W$60),X49,0))+(IF(AND(W50>=$W$59,W50<$W$60),X50,0)),0)","v":12},null,{"$f":"ROUND((IF(AND(Y27>=$W$59,Y27<$W$60),Z27,0))+(IF(AND(Y28>=$W$59,Y28<$W$60),Z28,0))+(IF(AND(Y29>=$W$59,Y29<$W$60),Z29,0))+(IF(AND(Y30>=$W$59,Y30<$W$60),Z30,0))+(IF(AND(Y31>=$W$59,Y31<$W$60),Z31,0))+(IF(AND(Y32>=$W$59,Y32<$W$60),Z32,0))+(IF(AND(Y33>=$W$59,Y33<$W$60),Z33,0))+(IF(AND(Y34>=$W$59,Y34<$W$60),Z34,0))+(IF(AND(Y35>=$W$59,Y35<$W$60),Z35,0))+(IF(AND(Y36>=$W$59,Y36<$W$60),Z36,0))+(IF(AND(Y37>=$W$59,Y37<$W$60),Z37,0))+(IF(AND(Y38>=$W$59,Y38<$W$60),Z38,0))+(IF(AND(Y39>=$W$59,Y39<$W$60),Z39,0))+(IF(AND(Y40>=$W$59,Y40<$W$60),Z40,0))+(IF(AND(Y41>=$W$59,Y41<$W$60),Z41,0))+(IF(AND(Y42>=$W$59,Y42<$W$60),Z42,0))+(IF(AND(Y43>=$W$59,Y43<$W$60),Z43,0))+(IF(AND(Y44>=$W$59,Y44<$W$60),Z44,0))+(IF(AND(Y45>=$W$59,Y45<$W$60),Z45,0))+(IF(AND(Y46>=$W$59,Y46<$W$60),Z46,0))+(IF(AND(Y47>=$W$59,Y47<$W$60),Z47,0))+(IF(AND(Y48>=$W$59,Y48<$W$60),Z48,0))+(IF(AND(Y49>=$W$59,Y49<$W$60),Z49,0))+(IF(AND(Y50>=$W$59,Y50<$W$60),Z50,0)),0)","v":12},null,{"$f":"ROUND((IF(AND(AA27>=$W$59,AA27<$W$60),AB27,0))+(IF(AND(AA28>=$W$59,AA28<$W$60),AB28,0))+(IF(AND(AA29>=$W$59,AA29<$W$60),AB29,0))+(IF(AND(AA30>=$W$59,AA30<$W$60),AB30,0))+(IF(AND(AA31>=$W$59,AA31<$W$60),AB31,0))+(IF(AND(AA32>=$W$59,AA32<$W$60),AB32,0))+(IF(AND(AA33>=$W$59,AA33<$W$60),AB33,0))+(IF(AND(AA34>=$W$59,AA34<$W$60),AB34,0))+(IF(AND(AA35>=$W$59,AA35<$W$60),AB35,0))+(IF(AND(AA36>=$W$59,AA36<$W$60),AB36,0))+(IF(AND(AA37>=$W$59,AA37<$W$60),AB37,0))+(IF(AND(AA38>=$W$59,AA38<$W$60),AB38,0))+(IF(AND(AA39>=$W$59,AA39<$W$60),AB39,0))+(IF(AND(AA40>=$W$59,AA40<$W$60),AB40,0))+(IF(AND(AA41>=$W$59,AA41<$W$60),AB41,0))+(IF(AND(AA42>=$W$59,AA42<$W$60),AB42,0))+(IF(AND(AA43>=$W$59,AA43<$W$60),AB43,0))+(IF(AND(AA44>=$W$59,AA44<$W$60),AB44,0))+(IF(AND(AA45>=$W$59,AA45<$W$60),AB45,0))+(IF(AND(AA46>=$W$59,AA46<$W$60),AB46,0))+(IF(AND(AA47>=$W$59,AA47<$W$60),AB47,0))+(IF(AND(AA48>=$W$59,AA48<$W$60),AB48,0))+(IF(AND(AA49>=$W$59,AA49<$W$60),AB49,0))+(IF(AND(AA50>=$W$59,AA50<$W$60),AB50,0)),0)","v":174},null,{"$f":"ROUND((IF(AND(AC27>=$W$59,AC27<$W$60),AD27,0))+(IF(AND(AC28>=$W$59,AC28<$W$60),AD28,0))+(IF(AND(AC29>=$W$59,AC29<$W$60),AD29,0))+(IF(AND(AC30>=$W$59,AC30<$W$60),AD30,0))+(IF(AND(AC31>=$W$59,AC31<$W$60),AD31,0))+(IF(AND(AC32>=$W$59,AC32<$W$60),AD32,0))+(IF(AND(AC33>=$W$59,AC33<$W$60),AD33,0))+(IF(AND(AC34>=$W$59,AC34<$W$60),AD34,0))+(IF(AND(AC35>=$W$59,AC35<$W$60),AD35,0))+(IF(AND(AC36>=$W$59,AC36<$W$60),AD36,0))+(IF(AND(AC37>=$W$59,AC37<$W$60),AD37,0))+(IF(AND(AC38>=$W$59,AC38<$W$60),AD38,0))+(IF(AND(AC39>=$W$59,AC39<$W$60),AD39,0))+(IF(AND(AC40>=$W$59,AC40<$W$60),AD40,0))+(IF(AND(AC41>=$W$59,AC41<$W$60),AD41,0))+(IF(AND(AC42>=$W$59,AC42<$W$60),AD42,0))+(IF(AND(AC43>=$W$59,AC43<$W$60),AD43,0))+(IF(AND(AC44>=$W$59,AC44<$W$60),AD44,0))+(IF(AND(AC45>=$W$59,AC45<$W$60),AD45,0))+(IF(AND(AC46>=$W$59,AC46<$W$60),AD46,0))+(IF(AND(AC47>=$W$59,AC47<$W$60),AD47,0))+(IF(AND(AC48>=$W$59,AC48<$W$60),AD48,0))+(IF(AND(AC49>=$W$59,AC49<$W$60),AD49,0))+(IF(AND(AC50>=$W$59,AC50<$W$60),AD50,0)),0)","v":30},null,{"$f":"ROUND((IF(AND(AE27>=$W$59,AE27<$W$60),AF27,0))+(IF(AND(AE28>=$W$59,AE28<$W$60),AF28,0))+(IF(AND(AE29>=$W$59,AE29<$W$60),AF29,0))+(IF(AND(AE30>=$W$59,AE30<$W$60),AF30,0))+(IF(AND(AE31>=$W$59,AE31<$W$60),AF31,0))+(IF(AND(AE32>=$W$59,AE32<$W$60),AF32,0))+(IF(AND(AE33>=$W$59,AE33<$W$60),AF33,0))+(IF(AND(AE34>=$W$59,AE34<$W$60),AF34,0))+(IF(AND(AE35>=$W$59,AE35<$W$60),AF35,0))+(IF(AND(AE36>=$W$59,AE36<$W$60),AF36,0))+(IF(AND(AE37>=$W$59,AE37<$W$60),AF37,0))+(IF(AND(AE38>=$W$59,AE38<$W$60),AF38,0))+(IF(AND(AE39>=$W$59,AE39<$W$60),AF39,0))+(IF(AND(AE40>=$W$59,AE40<$W$60),AF40,0))+(IF(AND(AE41>=$W$59,AE41<$W$60),AF41,0))+(IF(AND(AE42>=$W$59,AE42<$W$60),AF42,0))+(IF(AND(AE43>=$W$59,AE43<$W$60),AF43,0))+(IF(AND(AE44>=$W$59,AE44<$W$60),AF44,0))+(IF(AND(AE45>=$W$59,AE45<$W$60),AF45,0))+(IF(AND(AE46>=$W$59,AE46<$W$60),AF46,0))+(IF(AND(AE47>=$W$59,AE47<$W$60),AF47,0))+(IF(AND(AE48>=$W$59,AE48<$W$60),AF48,0))+(IF(AND(AE49>=$W$59,AE49<$W$60),AF49,0))+(IF(AND(AE50>=$W$59,AE50<$W$60),AF50,0)),0)","v":2}]
[null,null,null,{"$f":"DATE(YEAR(I27+(365*2)),1,1)","v":"2023-01-01"},{"$f":"12/$F$8*((IF(AND(I27>=$D$60,I27<$D$61),K27*D27,0))+(IF(AND(I28>=$D$60,I28<$D$61),K28*D28,0))+(IF(AND(I29>=$D$60,I29<$D$61),K29*D29,0))+(IF(AND(I30>=$D$60,I30<$D$61),K30*D30,0))+(IF(AND(I31>=$D$60,I31<$D$61),K31*D31,0))+(IF(AND(I32>=$D$60,I32<$D$61),K32*D32,0))+(IF(AND(I33>=$D$60,I33<$D$61),K33*D33,0))+(IF(AND(I34>=$D$60,I34<$D$61),K34*D34,0))+(IF(AND(I35>=$D$60,I35<$D$61),K35*D35,0))+(IF(AND(I36>=$D$60,I36<$D$61),K36*D36,0))+(IF(AND(I37>=$D$60,I37<$D$61),K37*D37,0))+(IF(AND(I38>=$D$60,I38<$D$61),K38*D38,0))+(IF(AND(I39>=$D$60,I39<$D$61),K39*D39,0))+(IF(AND(I40>=$D$60,I40<$D$61),K40*D40,0))+(IF(AND(I41>=$D$60,I41<$D$61),K41*D41,0))+(IF(AND(I42>=$D$60,I42<$D$61),K42*D42,0))+(IF(AND(I43>=$D$60,I43<$D$61),K43*D43,0))+(IF(AND(I44>=$D$60,I44<$D$61),K44*D44,0))+(IF(AND(I45>=$D$60,I45<$D$61),K45*D45,0))+(IF(AND(I46>=$D$60,I46<$D$61),K46*D46,0))+(IF(AND(I47>=$D$60,I47<$D$61),K47*D47,0))+(IF(AND(I48>=$D$60,I48<$D$61),K48*D48,0))+(IF(AND(I49>=$D$60,I49<$D$61),K49*D49,0))+(IF(AND(I50>=$D$60,I50<$D$61),K50*D50,0)))/((IF(AND(I27>=$D$60,I27<$D$61),D27,0))+(IF(AND(I28>=$D$60,I28<$D$61),D28,0))+(IF(AND(I29>=$D$60,I29<$D$61),D29,0))+(IF(AND(I30>=$D$60,I30<$D$61),D30,0))+(IF(AND(I31>=$D$60,I31<$D$61),D31,0))+(IF(AND(I32>=$D$60,I32<$D$61),D32,0))+(IF(AND(I33>=$D$60,I33<$D$61),D33,0))+(IF(AND(I34>=$D$60,I34<$D$61),D34,0))+(IF(AND(I35>=$D$60,I35<$D$61),D35,0))+(IF(AND(I36>=$D$60,I36<$D$61),D36,0))+(IF(AND(I37>=$D$60,I37<$D$61),D37,0))+(IF(AND(I38>=$D$60,I38<$D$61),D38,0))+(IF(AND(I39>=$D$60,I39<$D$61),D39,0))+(IF(AND(I40>=$D$60,I40<$D$61),D40,0))+(IF(AND(I41>=$D$60,I41<$D$61),D41,0))+(IF(AND(I42>=$D$60,I42<$D$61),D42,0))+(IF(AND(I43>=$D$60,I43<$D$61),D43,0))+(IF(AND(I44>=$D$60,I44<$D$61),D44,0))+(IF(AND(I45>=$D$60,I45<$D$61),D45,0))+(IF(AND(I46>=$D$60,I46<$D$61),D46,0))+(IF(AND(I47>=$D$60,I47<$D$61),D47,0))+(IF(AND(I48>=$D$60,I48<$D$61),D48,0))+(IF(AND(I49>=$D$60,I49<$D$61),D49,0))+(IF(AND(I50>=$D$60,I50<$D$61),D50,0)))","v":1.1625000000000001},null,null,null,{"$f":"ROUND((IF(AND(I27>=$D$60,I27<$D$61),P27,0))+(IF(AND(I28>=$D$60,I28<$D$61),P28,0))+(IF(AND(I29>=$D$60,I29<$D$61),P29,0))+(IF(AND(I30>=$D$60,I30<$D$61),P30,0))+(IF(AND(I31>=$D$60,I31<$D$61),P31,0))+(IF(AND(I32>=$D$60,I32<$D$61),P32,0))+(IF(AND(I33>=$D$60,I33<$D$61),P33,0))+(IF(AND(I34>=$D$60,I34<$D$61),P34,0))+(IF(AND(I35>=$D$60,I35<$D$61),P35,0))+(IF(AND(I36>=$D$60,I36<$D$61),P36,0))+(IF(AND(I37>=$D$60,I37<$D$61),P37,0))+(IF(AND(I38>=$D$60,I38<$D$61),P38,0))+(IF(AND(I39>=$D$60,I39<$D$61),P39,0))+(IF(AND(I40>=$D$60,I40<$D$61),P40,0))+(IF(AND(I41>=$D$60,I41<$D$61),P41,0))+(IF(AND(I42>=$D$60,I42<$D$61),P42,0))+(IF(AND(I43>=$D$60,I43<$D$61),P43,0))+(IF(AND(I44>=$D$60,I44<$D$61),P44,0))+(IF(AND(I45>=$D$60,I45<$D$61),P45,0))+(IF(AND(I46>=$D$60,I46<$D$61),P46,0))+(IF(AND(I47>=$D$60,I47<$D$61),P47,0))+(IF(AND(I48>=$D$60,I48<$D$61),P48,0))+(IF(AND(I49>=$D$60,I49<$D$61),P49,0))+(IF(AND(I50>=$D$60,I50<$D$61),P50,0)),0)","v":228},null,null,null,{"$f":"X60*$W$23+Z60*$Y$23+AB60*$AA$23+AD60*$AC$23+AF60*$AE$23","v":10506.4},null,105.06399999999999,null,null,null,null,null,null,null,{"$f":"DATE(YEAR(W27+(365*2)),1,1)","v":"2023-01-01"},{"$f":"ROUND((IF(AND(W27>=$W$60,W27<$W$61),X27,0))+(IF(AND(W28>=$W$60,W28<$W$61),X28,0))+(IF(AND(W29>=$W$60,W29<$W$61),X29,0))+(IF(AND(W30>=$W$60,W30<$W$61),X30,0))+(IF(AND(W31>=$W$60,W31<$W$61),X31,0))+(IF(AND(W32>=$W$60,W32<$W$61),X32,0))+(IF(AND(W33>=$W$60,W33<$W$61),X33,0))+(IF(AND(W34>=$W$60,W34<$W$61),X34,0))+(IF(AND(W35>=$W$60,W35<$W$61),X35,0))+(IF(AND(W36>=$W$60,W36<$W$61),X36,0))+(IF(AND(W37>=$W$60,W37<$W$61),X37,0))+(IF(AND(W38>=$W$60,W38<$W$61),X38,0))+(IF(AND(W39>=$W$60,W39<$W$61),X39,0))+(IF(AND(W40>=$W$60,W40<$W$61),X40,0))+(IF(AND(W41>=$W$60,W41<$W$61),X41,0))+(IF(AND(W42>=$W$60,W42<$W$61),X42,0))+(IF(AND(W43>=$W$60,W43<$W$61),X43,0))+(IF(AND(W44>=$W$60,W44<$W$61),X44,0))+(IF(AND(W45>=$W$60,W45<$W$61),X45,0))+(IF(AND(W46>=$W$60,W46<$W$61),X46,0))+(IF(AND(W47>=$W$60,W47<$W$61),X47,0))+(IF(AND(W48>=$W$60,W48<$W$61),X48,0))+(IF(AND(W49>=$W$60,W49<$W$61),X49,0))+(IF(AND(W50>=$W$60,W50<$W$61),X50,0)),0)","v":14},null,{"$f":"ROUND((IF(AND(Y27>=$W$60,Y27<$W$61),Z27,0))+(IF(AND(Y28>=$W$60,Y28<$W$61),Z28,0))+(IF(AND(Y29>=$W$60,Y29<$W$61),Z29,0))+(IF(AND(Y30>=$W$60,Y30<$W$61),Z30,0))+(IF(AND(Y31>=$W$60,Y31<$W$61),Z31,0))+(IF(AND(Y32>=$W$60,Y32<$W$61),Z32,0))+(IF(AND(Y33>=$W$60,Y33<$W$61),Z33,0))+(IF(AND(Y34>=$W$60,Y34<$W$61),Z34,0))+(IF(AND(Y35>=$W$60,Y35<$W$61),Z35,0))+(IF(AND(Y36>=$W$60,Y36<$W$61),Z36,0))+(IF(AND(Y37>=$W$60,Y37<$W$61),Z37,0))+(IF(AND(Y38>=$W$60,Y38<$W$61),Z38,0))+(IF(AND(Y39>=$W$60,Y39<$W$61),Z39,0))+(IF(AND(Y40>=$W$60,Y40<$W$61),Z40,0))+(IF(AND(Y41>=$W$60,Y41<$W$61),Z41,0))+(IF(AND(Y42>=$W$60,Y42<$W$61),Z42,0))+(IF(AND(Y43>=$W$60,Y43<$W$61),Z43,0))+(IF(AND(Y44>=$W$60,Y44<$W$61),Z44,0))+(IF(AND(Y45>=$W$60,Y45<$W$61),Z45,0))+(IF(AND(Y46>=$W$60,Y46<$W$61),Z46,0))+(IF(AND(Y47>=$W$60,Y47<$W$61),Z47,0))+(IF(AND(Y48>=$W$60,Y48<$W$61),Z48,0))+(IF(AND(Y49>=$W$60,Y49<$W$61),Z49,0))+(IF(AND(Y50>=$W$60,Y50<$W$61),Z50,0)),0)","v":12},null,{"$f":"ROUND((IF(AND(AA27>=$W$60,AA27<$W$61),AB27,0))+(IF(AND(AA28>=$W$60,AA28<$W$61),AB28,0))+(IF(AND(AA29>=$W$60,AA29<$W$61),AB29,0))+(IF(AND(AA30>=$W$60,AA30<$W$61),AB30,0))+(IF(AND(AA31>=$W$60,AA31<$W$61),AB31,0))+(IF(AND(AA32>=$W$60,AA32<$W$61),AB32,0))+(IF(AND(AA33>=$W$60,AA33<$W$61),AB33,0))+(IF(AND(AA34>=$W$60,AA34<$W$61),AB34,0))+(IF(AND(AA35>=$W$60,AA35<$W$61),AB35,0))+(IF(AND(AA36>=$W$60,AA36<$W$61),AB36,0))+(IF(AND(AA37>=$W$60,AA37<$W$61),AB37,0))+(IF(AND(AA38>=$W$60,AA38<$W$61),AB38,0))+(IF(AND(AA39>=$W$60,AA39<$W$61),AB39,0))+(IF(AND(AA40>=$W$60,AA40<$W$61),AB40,0))+(IF(AND(AA41>=$W$60,AA41<$W$61),AB41,0))+(IF(AND(AA42>=$W$60,AA42<$W$61),AB42,0))+(IF(AND(AA43>=$W$60,AA43<$W$61),AB43,0))+(IF(AND(AA44>=$W$60,AA44<$W$61),AB44,0))+(IF(AND(AA45>=$W$60,AA45<$W$61),AB45,0))+(IF(AND(AA46>=$W$60,AA46<$W$61),AB46,0))+(IF(AND(AA47>=$W$60,AA47<$W$61),AB47,0))+(IF(AND(AA48>=$W$60,AA48<$W$61),AB48,0))+(IF(AND(AA49>=$W$60,AA49<$W$61),AB49,0))+(IF(AND(AA50>=$W$60,AA50<$W$61),AB50,0)),0)","v":206},null,{"$f":"ROUND((IF(AND(AC27>=$W$60,AC27<$W$61),AD27,0))+(IF(AND(AC28>=$W$60,AC28<$W$61),AD28,0))+(IF(AND(AC29>=$W$60,AC29<$W$61),AD29,0))+(IF(AND(AC30>=$W$60,AC30<$W$61),AD30,0))+(IF(AND(AC31>=$W$60,AC31<$W$61),AD31,0))+(IF(AND(AC32>=$W$60,AC32<$W$61),AD32,0))+(IF(AND(AC33>=$W$60,AC33<$W$61),AD33,0))+(IF(AND(AC34>=$W$60,AC34<$W$61),AD34,0))+(IF(AND(AC35>=$W$60,AC35<$W$61),AD35,0))+(IF(AND(AC36>=$W$60,AC36<$W$61),AD36,0))+(IF(AND(AC37>=$W$60,AC37<$W$61),AD37,0))+(IF(AND(AC38>=$W$60,AC38<$W$61),AD38,0))+(IF(AND(AC39>=$W$60,AC39<$W$61),AD39,0))+(IF(AND(AC40>=$W$60,AC40<$W$61),AD40,0))+(IF(AND(AC41>=$W$60,AC41<$W$61),AD41,0))+(IF(AND(AC42>=$W$60,AC42<$W$61),AD42,0))+(IF(AND(AC43>=$W$60,AC43<$W$61),AD43,0))+(IF(AND(AC44>=$W$60,AC44<$W$61),AD44,0))+(IF(AND(AC45>=$W$60,AC45<$W$61),AD45,0))+(IF(AND(AC46>=$W$60,AC46<$W$61),AD46,0))+(IF(AND(AC47>=$W$60,AC47<$W$61),AD47,0))+(IF(AND(AC48>=$W$60,AC48<$W$61),AD48,0))+(IF(AND(AC49>=$W$60,AC49<$W$61),AD49,0))+(IF(AND(AC50>=$W$60,AC50<$W$61),AD50,0)),0)","v":36},null,{"$f":"ROUND((IF(AND(AE27>=$W$60,AE27<$W$61),AF27,0))+(IF(AND(AE28>=$W$60,AE28<$W$61),AF28,0))+(IF(AND(AE29>=$W$60,AE29<$W$61),AF29,0))+(IF(AND(AE30>=$W$60,AE30<$W$61),AF30,0))+(IF(AND(AE31>=$W$60,AE31<$W$61),AF31,0))+(IF(AND(AE32>=$W$60,AE32<$W$61),AF32,0))+(IF(AND(AE33>=$W$60,AE33<$W$61),AF33,0))+(IF(AND(AE34>=$W$60,AE34<$W$61),AF34,0))+(IF(AND(AE35>=$W$60,AE35<$W$61),AF35,0))+(IF(AND(AE36>=$W$60,AE36<$W$61),AF36,0))+(IF(AND(AE37>=$W$60,AE37<$W$61),AF37,0))+(IF(AND(AE38>=$W$60,AE38<$W$61),AF38,0))+(IF(AND(AE39>=$W$60,AE39<$W$61),AF39,0))+(IF(AND(AE40>=$W$60,AE40<$W$61),AF40,0))+(IF(AND(AE41>=$W$60,AE41<$W$61),AF41,0))+(IF(AND(AE42>=$W$60,AE42<$W$61),AF42,0))+(IF(AND(AE43>=$W$60,AE43<$W$61),AF43,0))+(IF(AND(AE44>=$W$60,AE44<$W$61),AF44,0))+(IF(AND(AE45>=$W$60,AE45<$W$61),AF45,0))+(IF(AND(AE46>=$W$60,AE46<$W$61),AF46,0))+(IF(AND(AE47>=$W$60,AE47<$W$61),AF47,0))+(IF(AND(AE48>=$W$60,AE48<$W$61),AF48,0))+(IF(AND(AE49>=$W$60,AE49<$W$61),AF49,0))+(IF(AND(AE50>=$W$60,AE50<$W$61),AF50,0)),0)","v":2}]
[null,null,null,{"$f":"DATE(YEAR(I27+(365*3)),1,1)","v":"2024-01-01"},{"$f":"12/$F$8*((IF(AND(I27>=$D$61,I27<$D$62),K27*D27,0))+(IF(AND(I28>=$D$61,I28<$D$62),K28*D28,0))+(IF(AND(I29>=$D$61,I29<$D$62),K29*D29,0))+(IF(AND(I30>=$D$61,I30<$D$62),K30*D30,0))+(IF(AND(I31>=$D$61,I31<$D$62),K31*D31,0))+(IF(AND(I32>=$D$61,I32<$D$62),K32*D32,0))+(IF(AND(I33>=$D$61,I33<$D$62),K33*D33,0))+(IF(AND(I34>=$D$61,I34<$D$62),K34*D34,0))+(IF(AND(I35>=$D$61,I35<$D$62),K35*D35,0))+(IF(AND(I36>=$D$61,I36<$D$62),K36*D36,0))+(IF(AND(I37>=$D$61,I37<$D$62),K37*D37,0))+(IF(AND(I38>=$D$61,I38<$D$62),K38*D38,0))+(IF(AND(I39>=$D$61,I39<$D$62),K39*D39,0))+(IF(AND(I40>=$D$61,I40<$D$62),K40*D40,0))+(IF(AND(I41>=$D$61,I41<$D$62),K41*D41,0))+(IF(AND(I42>=$D$61,I42<$D$62),K42*D42,0))+(IF(AND(I43>=$D$61,I43<$D$62),K43*D43,0))+(IF(AND(I44>=$D$61,I44<$D$62),K44*D44,0))+(IF(AND(I45>=$D$61,I45<$D$62),K45*D45,0))+(IF(AND(I46>=$D$61,I46<$D$62),K46*D46,0))+(IF(AND(I47>=$D$61,I47<$D$62),K47*D47,0))+(IF(AND(I48>=$D$61,I48<$D$62),K48*D48,0))+(IF(AND(I49>=$D$61,I49<$D$62),K49*D49,0))+(IF(AND(I50>=$D$61,I50<$D$62),K50*D50,0)))/((IF(AND(I27>=$D$61,I27<$D$62),D27,0))+(IF(AND(I28>=$D$61,I28<$D$62),D28,0))+(IF(AND(I29>=$D$61,I29<$D$62),D29,0))+(IF(AND(I30>=$D$61,I30<$D$62),D30,0))+(IF(AND(I31>=$D$61,I31<$D$62),D31,0))+(IF(AND(I32>=$D$61,I32<$D$62),D32,0))+(IF(AND(I33>=$D$61,I33<$D$62),D33,0))+(IF(AND(I34>=$D$61,I34<$D$62),D34,0))+(IF(AND(I35>=$D$61,I35<$D$62),D35,0))+(IF(AND(I36>=$D$61,I36<$D$62),D36,0))+(IF(AND(I37>=$D$61,I37<$D$62),D37,0))+(IF(AND(I38>=$D$61,I38<$D$62),D38,0))+(IF(AND(I39>=$D$61,I39<$D$62),D39,0))+(IF(AND(I40>=$D$61,I40<$D$62),D40,0))+(IF(AND(I41>=$D$61,I41<$D$62),D41,0))+(IF(AND(I42>=$D$61,I42<$D$62),D42,0))+(IF(AND(I43>=$D$61,I43<$D$62),D43,0))+(IF(AND(I44>=$D$61,I44<$D$62),D44,0))+(IF(AND(I45>=$D$61,I45<$D$62),D45,0))+(IF(AND(I46>=$D$61,I46<$D$62),D46,0))+(IF(AND(I47>=$D$61,I47<$D$62),D47,0))+(IF(AND(I48>=$D$61,I48<$D$62),D48,0))+(IF(AND(I49>=$D$61,I49<$D$62),D49,0))+(IF(AND(I50>=$D$61,I50<$D$62),D50,0)))","v":1.1625000000000001},null,null,null,{"$f":"ROUND((IF(AND(I27>=$D$61,I27<$D$62),P27,0))+(IF(AND(I28>=$D$61,I28<$D$62),P28,0))+(IF(AND(I29>=$D$61,I29<$D$62),P29,0))+(IF(AND(I30>=$D$61,I30<$D$62),P30,0))+(IF(AND(I31>=$D$61,I31<$D$62),P31,0))+(IF(AND(I32>=$D$61,I32<$D$62),P32,0))+(IF(AND(I33>=$D$61,I33<$D$62),P33,0))+(IF(AND(I34>=$D$61,I34<$D$62),P34,0))+(IF(AND(I35>=$D$61,I35<$D$62),P35,0))+(IF(AND(I36>=$D$61,I36<$D$62),P36,0))+(IF(AND(I37>=$D$61,I37<$D$62),P37,0))+(IF(AND(I38>=$D$61,I38<$D$62),P38,0))+(IF(AND(I39>=$D$61,I39<$D$62),P39,0))+(IF(AND(I40>=$D$61,I40<$D$62),P40,0))+(IF(AND(I41>=$D$61,I41<$D$62),P41,0))+(IF(AND(I42>=$D$61,I42<$D$62),P42,0))+(IF(AND(I43>=$D$61,I43<$D$62),P43,0))+(IF(AND(I44>=$D$61,I44<$D$62),P44,0))+(IF(AND(I45>=$D$61,I45<$D$62),P45,0))+(IF(AND(I46>=$D$61,I46<$D$62),P46,0))+(IF(AND(I47>=$D$61,I47<$D$62),P47,0))+(IF(AND(I48>=$D$61,I48<$D$62),P48,0))+(IF(AND(I49>=$D$61,I49<$D$62),P49,0))+(IF(AND(I50>=$D$61,I50<$D$62),P50,0)),0)","v":228},null,null,null,{"$f":"X61*$W$23+Z61*$Y$23+AB61*$AA$23+AD61*$AC$23+AF61*$AE$23","v":8940.4},null,89.403999999999996,null,null,null,null,null,null,null,{"$f":"DATE(YEAR(W27+(365*3)),1,1)","v":"2024-01-01"},{"$f":"ROUND((IF(AND(W27>=$W$61,W27<$W$62),X27,0))+(IF(AND(W28>=$W$61,W28<$W$62),X28,0))+(IF(AND(W29>=$W$61,W29<$W$62),X29,0))+(IF(AND(W30>=$W$61,W30<$W$62),X30,0))+(IF(AND(W31>=$W$61,W31<$W$62),X31,0))+(IF(AND(W32>=$W$61,W32<$W$62),X32,0))+(IF(AND(W33>=$W$61,W33<$W$62),X33,0))+(IF(AND(W34>=$W$61,W34<$W$62),X34,0))+(IF(AND(W35>=$W$61,W35<$W$62),X35,0))+(IF(AND(W36>=$W$61,W36<$W$62),X36,0))+(IF(AND(W37>=$W$61,W37<$W$62),X37,0))+(IF(AND(W38>=$W$61,W38<$W$62),X38,0))+(IF(AND(W39>=$W$61,W39<$W$62),X39,0))+(IF(AND(W40>=$W$61,W40<$W$62),X40,0))+(IF(AND(W41>=$W$61,W41<$W$62),X41,0))+(IF(AND(W42>=$W$61,W42<$W$62),X42,0))+(IF(AND(W43>=$W$61,W43<$W$62),X43,0))+(IF(AND(W44>=$W$61,W44<$W$62),X44,0))+(IF(AND(W45>=$W$61,W45<$W$62),X45,0))+(IF(AND(W46>=$W$61,W46<$W$62),X46,0))+(IF(AND(W47>=$W$61,W47<$W$62),X47,0))+(IF(AND(W48>=$W$61,W48<$W$62),X48,0))+(IF(AND(W49>=$W$61,W49<$W$62),X49,0))+(IF(AND(W50>=$W$61,W50<$W$62),X50,0)),0)","v":12},null,{"$f":"ROUND((IF(AND(Y27>=$W$61,Y27<$W$62),Z27,0))+(IF(AND(Y28>=$W$61,Y28<$W$62),Z28,0))+(IF(AND(Y29>=$W$61,Y29<$W$62),Z29,0))+(IF(AND(Y30>=$W$61,Y30<$W$62),Z30,0))+(IF(AND(Y31>=$W$61,Y31<$W$62),Z31,0))+(IF(AND(Y32>=$W$61,Y32<$W$62),Z32,0))+(IF(AND(Y33>=$W$61,Y33<$W$62),Z33,0))+(IF(AND(Y34>=$W$61,Y34<$W$62),Z34,0))+(IF(AND(Y35>=$W$61,Y35<$W$62),Z35,0))+(IF(AND(Y36>=$W$61,Y36<$W$62),Z36,0))+(IF(AND(Y37>=$W$61,Y37<$W$62),Z37,0))+(IF(AND(Y38>=$W$61,Y38<$W$62),Z38,0))+(IF(AND(Y39>=$W$61,Y39<$W$62),Z39,0))+(IF(AND(Y40>=$W$61,Y40<$W$62),Z40,0))+(IF(AND(Y41>=$W$61,Y41<$W$62),Z41,0))+(IF(AND(Y42>=$W$61,Y42<$W$62),Z42,0))+(IF(AND(Y43>=$W$61,Y43<$W$62),Z43,0))+(IF(AND(Y44>=$W$61,Y44<$W$62),Z44,0))+(IF(AND(Y45>=$W$61,Y45<$W$62),Z45,0))+(IF(AND(Y46>=$W$61,Y46<$W$62),Z46,0))+(IF(AND(Y47>=$W$61,Y47<$W$62),Z47,0))+(IF(AND(Y48>=$W$61,Y48<$W$62),Z48,0))+(IF(AND(Y49>=$W$61,Y49<$W$62),Z49,0))+(IF(AND(Y50>=$W$61,Y50<$W$62),Z50,0)),0)","v":12},null,{"$f":"ROUND((IF(AND(AA27>=$W$61,AA27<$W$62),AB27,0))+(IF(AND(AA28>=$W$61,AA28<$W$62),AB28,0))+(IF(AND(AA29>=$W$61,AA29<$W$62),AB29,0))+(IF(AND(AA30>=$W$61,AA30<$W$62),AB30,0))+(IF(AND(AA31>=$W$61,AA31<$W$62),AB31,0))+(IF(AND(AA32>=$W$61,AA32<$W$62),AB32,0))+(IF(AND(AA33>=$W$61,AA33<$W$62),AB33,0))+(IF(AND(AA34>=$W$61,AA34<$W$62),AB34,0))+(IF(AND(AA35>=$W$61,AA35<$W$62),AB35,0))+(IF(AND(AA36>=$W$61,AA36<$W$62),AB36,0))+(IF(AND(AA37>=$W$61,AA37<$W$62),AB37,0))+(IF(AND(AA38>=$W$61,AA38<$W$62),AB38,0))+(IF(AND(AA39>=$W$61,AA39<$W$62),AB39,0))+(IF(AND(AA40>=$W$61,AA40<$W$62),AB40,0))+(IF(AND(AA41>=$W$61,AA41<$W$62),AB41,0))+(IF(AND(AA42>=$W$61,AA42<$W$62),AB42,0))+(IF(AND(AA43>=$W$61,AA43<$W$62),AB43,0))+(IF(AND(AA44>=$W$61,AA44<$W$62),AB44,0))+(IF(AND(AA45>=$W$61,AA45<$W$62),AB45,0))+(IF(AND(AA46>=$W$61,AA46<$W$62),AB46,0))+(IF(AND(AA47>=$W$61,AA47<$W$62),AB47,0))+(IF(AND(AA48>=$W$61,AA48<$W$62),AB48,0))+(IF(AND(AA49>=$W$61,AA49<$W$62),AB49,0))+(IF(AND(AA50>=$W$61,AA50<$W$62),AB50,0)),0)","v":174},null,{"$f":"ROUND((IF(AND(AC27>=$W$61,AC27<$W$62),AD27,0))+(IF(AND(AC28>=$W$61,AC28<$W$62),AD28,0))+(IF(AND(AC29>=$W$61,AC29<$W$62),AD29,0))+(IF(AND(AC30>=$W$61,AC30<$W$62),AD30,0))+(IF(AND(AC31>=$W$61,AC31<$W$62),AD31,0))+(IF(AND(AC32>=$W$61,AC32<$W$62),AD32,0))+(IF(AND(AC33>=$W$61,AC33<$W$62),AD33,0))+(IF(AND(AC34>=$W$61,AC34<$W$62),AD34,0))+(IF(AND(AC35>=$W$61,AC35<$W$62),AD35,0))+(IF(AND(AC36>=$W$61,AC36<$W$62),AD36,0))+(IF(AND(AC37>=$W$61,AC37<$W$62),AD37,0))+(IF(AND(AC38>=$W$61,AC38<$W$62),AD38,0))+(IF(AND(AC39>=$W$61,AC39<$W$62),AD39,0))+(IF(AND(AC40>=$W$61,AC40<$W$62),AD40,0))+(IF(AND(AC41>=$W$61,AC41<$W$62),AD41,0))+(IF(AND(AC42>=$W$61,AC42<$W$62),AD42,0))+(IF(AND(AC43>=$W$61,AC43<$W$62),AD43,0))+(IF(AND(AC44>=$W$61,AC44<$W$62),AD44,0))+(IF(AND(AC45>=$W$61,AC45<$W$62),AD45,0))+(IF(AND(AC46>=$W$61,AC46<$W$62),AD46,0))+(IF(AND(AC47>=$W$61,AC47<$W$62),AD47,0))+(IF(AND(AC48>=$W$61,AC48<$W$62),AD48,0))+(IF(AND(AC49>=$W$61,AC49<$W$62),AD49,0))+(IF(AND(AC50>=$W$61,AC50<$W$62),AD50,0)),0)","v":30},null,{"$f":"ROUND((IF(AND(AE27>=$W$61,AE27<$W$62),AF27,0))+(IF(AND(AE28>=$W$61,AE28<$W$62),AF28,0))+(IF(AND(AE29>=$W$61,AE29<$W$62),AF29,0))+(IF(AND(AE30>=$W$61,AE30<$W$62),AF30,0))+(IF(AND(AE31>=$W$61,AE31<$W$62),AF31,0))+(IF(AND(AE32>=$W$61,AE32<$W$62),AF32,0))+(IF(AND(AE33>=$W$61,AE33<$W$62),AF33,0))+(IF(AND(AE34>=$W$61,AE34<$W$62),AF34,0))+(IF(AND(AE35>=$W$61,AE35<$W$62),AF35,0))+(IF(AND(AE36>=$W$61,AE36<$W$62),AF36,0))+(IF(AND(AE37>=$W$61,AE37<$W$62),AF37,0))+(IF(AND(AE38>=$W$61,AE38<$W$62),AF38,0))+(IF(AND(AE39>=$W$61,AE39<$W$62),AF39,0))+(IF(AND(AE40>=$W$61,AE40<$W$62),AF40,0))+(IF(AND(AE41>=$W$61,AE41<$W$62),AF41,0))+(IF(AND(AE42>=$W$61,AE42<$W$62),AF42,0))+(IF(AND(AE43>=$W$61,AE43<$W$62),AF43,0))+(IF(AND(AE44>=$W$61,AE44<$W$62),AF44,0))+(IF(AND(AE45>=$W$61,AE45<$W$62),AF45,0))+(IF(AND(AE46>=$W$61,AE46<$W$62),AF46,0))+(IF(AND(AE47>=$W$61,AE47<$W$62),AF47,0))+(IF(AND(AE48>=$W$61,AE48<$W$62),AF48,0))+(IF(AND(AE49>=$W$61,AE49<$W$62),AF49,0))+(IF(AND(AE50>=$W$61,AE50<$W$62),AF50,0)),0)","v":2}]
[null,null,null,{"$f":"DATE(YEAR(I27+(365*4)),1,1)","v":"2025-01-01"},{"$f":"12/$F$8*((IF(AND(I27>=$D$62,I27<$D$63),K27*D27,0))+(IF(AND(I28>=$D$62,I28<$D$63),K28*D28,0))+(IF(AND(I29>=$D$62,I29<$D$63),K29*D29,0))+(IF(AND(I30>=$D$62,I30<$D$63),K30*D30,0))+(IF(AND(I31>=$D$62,I31<$D$63),K31*D31,0))+(IF(AND(I32>=$D$62,I32<$D$63),K32*D32,0))+(IF(AND(I33>=$D$62,I33<$D$63),K33*D33,0))+(IF(AND(I34>=$D$62,I34<$D$63),K34*D34,0))+(IF(AND(I35>=$D$62,I35<$D$63),K35*D35,0))+(IF(AND(I36>=$D$62,I36<$D$63),K36*D36,0))+(IF(AND(I37>=$D$62,I37<$D$63),K37*D37,0))+(IF(AND(I38>=$D$62,I38<$D$63),K38*D38,0))+(IF(AND(I39>=$D$62,I39<$D$63),K39*D39,0))+(IF(AND(I40>=$D$62,I40<$D$63),K40*D40,0))+(IF(AND(I41>=$D$62,I41<$D$63),K41*D41,0))+(IF(AND(I42>=$D$62,I42<$D$63),K42*D42,0))+(IF(AND(I43>=$D$62,I43<$D$63),K43*D43,0))+(IF(AND(I44>=$D$62,I44<$D$63),K44*D44,0))+(IF(AND(I45>=$D$62,I45<$D$63),K45*D45,0))+(IF(AND(I46>=$D$62,I46<$D$63),K46*D46,0))+(IF(AND(I47>=$D$62,I47<$D$63),K47*D47,0))+(IF(AND(I48>=$D$62,I48<$D$63),K48*D48,0))+(IF(AND(I49>=$D$62,I49<$D$63),K49*D49,0))+(IF(AND(I50>=$D$62,I50<$D$63),K50*D50,0)))/((IF(AND(I27>=$D$62,I27<$D$63),D27,0))+(IF(AND(I28>=$D$62,I28<$D$63),D28,0))+(IF(AND(I29>=$D$62,I29<$D$63),D29,0))+(IF(AND(I30>=$D$62,I30<$D$63),D30,0))+(IF(AND(I31>=$D$62,I31<$D$63),D31,0))+(IF(AND(I32>=$D$62,I32<$D$63),D32,0))+(IF(AND(I33>=$D$62,I33<$D$63),D33,0))+(IF(AND(I34>=$D$62,I34<$D$63),D34,0))+(IF(AND(I35>=$D$62,I35<$D$63),D35,0))+(IF(AND(I36>=$D$62,I36<$D$63),D36,0))+(IF(AND(I37>=$D$62,I37<$D$63),D37,0))+(IF(AND(I38>=$D$62,I38<$D$63),D38,0))+(IF(AND(I39>=$D$62,I39<$D$63),D39,0))+(IF(AND(I40>=$D$62,I40<$D$63),D40,0))+(IF(AND(I41>=$D$62,I41<$D$63),D41,0))+(IF(AND(I42>=$D$62,I42<$D$63),D42,0))+(IF(AND(I43>=$D$62,I43<$D$63),D43,0))+(IF(AND(I44>=$D$62,I44<$D$63),D44,0))+(IF(AND(I45>=$D$62,I45<$D$63),D45,0))+(IF(AND(I46>=$D$62,I46<$D$63),D46,0))+(IF(AND(I47>=$D$62,I47<$D$63),D47,0))+(IF(AND(I48>=$D$62,I48<$D$63),D48,0))+(IF(AND(I49>=$D$62,I49<$D$63),D49,0))+(IF(AND(I50>=$D$62,I50<$D$63),D50,0)))","v":1.05},null,null,null,{"$f":"ROUND((IF(AND(I27>=$D$62,I27<$D$63),P27,0))+(IF(AND(I28>=$D$62,I28<$D$63),P28,0))+(IF(AND(I29>=$D$62,I29<$D$63),P29,0))+(IF(AND(I30>=$D$62,I30<$D$63),P30,0))+(IF(AND(I31>=$D$62,I31<$D$63),P31,0))+(IF(AND(I32>=$D$62,I32<$D$63),P32,0))+(IF(AND(I33>=$D$62,I33<$D$63),P33,0))+(IF(AND(I34>=$D$62,I34<$D$63),P34,0))+(IF(AND(I35>=$D$62,I35<$D$63),P35,0))+(IF(AND(I36>=$D$62,I36<$D$63),P36,0))+(IF(AND(I37>=$D$62,I37<$D$63),P37,0))+(IF(AND(I38>=$D$62,I38<$D$63),P38,0))+(IF(AND(I39>=$D$62,I39<$D$63),P39,0))+(IF(AND(I40>=$D$62,I40<$D$63),P40,0))+(IF(AND(I41>=$D$62,I41<$D$63),P41,0))+(IF(AND(I42>=$D$62,I42<$D$63),P42,0))+(IF(AND(I43>=$D$62,I43<$D$63),P43,0))+(IF(AND(I44>=$D$62,I44<$D$63),P44,0))+(IF(AND(I45>=$D$62,I45<$D$63),P45,0))+(IF(AND(I46>=$D$62,I46<$D$63),P46,0))+(IF(AND(I47>=$D$62,I47<$D$63),P47,0))+(IF(AND(I48>=$D$62,I48<$D$63),P48,0))+(IF(AND(I49>=$D$62,I49<$D$63),P49,0))+(IF(AND(I50>=$D$62,I50<$D$63),P50,0)),0)","v":34},null,null,null,{"$f":"X62*$W$23+Z62*$Y$23+AB62*$AA$23+AD62*$AC$23+AF62*$AE$23","v":3878.4},null,38.783999999999999,null,null,null,null,null,null,null,{"$f":"DATE(YEAR(W27+(365*4)),1,1)","v":"2025-01-01"},{"$f":"ROUND((IF(AND(W27>=$W$62,W27<$W$63),X27,0))+(IF(AND(W28>=$W$62,W28<$W$63),X28,0))+(IF(AND(W29>=$W$62,W29<$W$63),X29,0))+(IF(AND(W30>=$W$62,W30<$W$63),X30,0))+(IF(AND(W31>=$W$62,W31<$W$63),X31,0))+(IF(AND(W32>=$W$62,W32<$W$63),X32,0))+(IF(AND(W33>=$W$62,W33<$W$63),X33,0))+(IF(AND(W34>=$W$62,W34<$W$63),X34,0))+(IF(AND(W35>=$W$62,W35<$W$63),X35,0))+(IF(AND(W36>=$W$62,W36<$W$63),X36,0))+(IF(AND(W37>=$W$62,W37<$W$63),X37,0))+(IF(AND(W38>=$W$62,W38<$W$63),X38,0))+(IF(AND(W39>=$W$62,W39<$W$63),X39,0))+(IF(AND(W40>=$W$62,W40<$W$63),X40,0))+(IF(AND(W41>=$W$62,W41<$W$63),X41,0))+(IF(AND(W42>=$W$62,W42<$W$63),X42,0))+(IF(AND(W43>=$W$62,W43<$W$63),X43,0))+(IF(AND(W44>=$W$62,W44<$W$63),X44,0))+(IF(AND(W45>=$W$62,W45<$W$63),X45,0))+(IF(AND(W46>=$W$62,W46<$W$63),X46,0))+(IF(AND(W47>=$W$62,W47<$W$63),X47,0))+(IF(AND(W48>=$W$62,W48<$W$63),X48,0))+(IF(AND(W49>=$W$62,W49<$W$63),X49,0))+(IF(AND(W50>=$W$62,W50<$W$63),X50,0)),0)","v":2},null,{"$f":"ROUND((IF(AND(Y27>=$W$62,Y27<$W$63),Z27,0))+(IF(AND(Y28>=$W$62,Y28<$W$63),Z28,0))+(IF(AND(Y29>=$W$62,Y29<$W$63),Z29,0))+(IF(AND(Y30>=$W$62,Y30<$W$63),Z30,0))+(IF(AND(Y31>=$W$62,Y31<$W$63),Z31,0))+(IF(AND(Y32>=$W$62,Y32<$W$63),Z32,0))+(IF(AND(Y33>=$W$62,Y33<$W$63),Z33,0))+(IF(AND(Y34>=$W$62,Y34<$W$63),Z34,0))+(IF(AND(Y35>=$W$62,Y35<$W$63),Z35,0))+(IF(AND(Y36>=$W$62,Y36<$W$63),Z36,0))+(IF(AND(Y37>=$W$62,Y37<$W$63),Z37,0))+(IF(AND(Y38>=$W$62,Y38<$W$63),Z38,0))+(IF(AND(Y39>=$W$62,Y39<$W$63),Z39,0))+(IF(AND(Y40>=$W$62,Y40<$W$63),Z40,0))+(IF(AND(Y41>=$W$62,Y41<$W$63),Z41,0))+(IF(AND(Y42>=$W$62,Y42<$W$63),Z42,0))+(IF(AND(Y43>=$W$62,Y43<$W$63),Z43,0))+(IF(AND(Y44>=$W$62,Y44<$W$63),Z44,0))+(IF(AND(Y45>=$W$62,Y45<$W$63),Z45,0))+(IF(AND(Y46>=$W$62,Y46<$W$63),Z46,0))+(IF(AND(Y47>=$W$62,Y47<$W$63),Z47,0))+(IF(AND(Y48>=$W$62,Y48<$W$63),Z48,0))+(IF(AND(Y49>=$W$62,Y49<$W$63),Z49,0))+(IF(AND(Y50>=$W$62,Y50<$W$63),Z50,0)),0)","v":4},null,{"$f":"ROUND((IF(AND(AA27>=$W$62,AA27<$W$63),AB27,0))+(IF(AND(AA28>=$W$62,AA28<$W$63),AB28,0))+(IF(AND(AA29>=$W$62,AA29<$W$63),AB29,0))+(IF(AND(AA30>=$W$62,AA30<$W$63),AB30,0))+(IF(AND(AA31>=$W$62,AA31<$W$63),AB31,0))+(IF(AND(AA32>=$W$62,AA32<$W$63),AB32,0))+(IF(AND(AA33>=$W$62,AA33<$W$63),AB33,0))+(IF(AND(AA34>=$W$62,AA34<$W$63),AB34,0))+(IF(AND(AA35>=$W$62,AA35<$W$63),AB35,0))+(IF(AND(AA36>=$W$62,AA36<$W$63),AB36,0))+(IF(AND(AA37>=$W$62,AA37<$W$63),AB37,0))+(IF(AND(AA38>=$W$62,AA38<$W$63),AB38,0))+(IF(AND(AA39>=$W$62,AA39<$W$63),AB39,0))+(IF(AND(AA40>=$W$62,AA40<$W$63),AB40,0))+(IF(AND(AA41>=$W$62,AA41<$W$63),AB41,0))+(IF(AND(AA42>=$W$62,AA42<$W$63),AB42,0))+(IF(AND(AA43>=$W$62,AA43<$W$63),AB43,0))+(IF(AND(AA44>=$W$62,AA44<$W$63),AB44,0))+(IF(AND(AA45>=$W$62,AA45<$W$63),AB45,0))+(IF(AND(AA46>=$W$62,AA46<$W$63),AB46,0))+(IF(AND(AA47>=$W$62,AA47<$W$63),AB47,0))+(IF(AND(AA48>=$W$62,AA48<$W$63),AB48,0))+(IF(AND(AA49>=$W$62,AA49<$W$63),AB49,0))+(IF(AND(AA50>=$W$62,AA50<$W$63),AB50,0)),0)","v":78},null,{"$f":"ROUND((IF(AND(AC27>=$W$62,AC27<$W$63),AD27,0))+(IF(AND(AC28>=$W$62,AC28<$W$63),AD28,0))+(IF(AND(AC29>=$W$62,AC29<$W$63),AD29,0))+(IF(AND(AC30>=$W$62,AC30<$W$63),AD30,0))+(IF(AND(AC31>=$W$62,AC31<$W$63),AD31,0))+(IF(AND(AC32>=$W$62,AC32<$W$63),AD32,0))+(IF(AND(AC33>=$W$62,AC33<$W$63),AD33,0))+(IF(AND(AC34>=$W$62,AC34<$W$63),AD34,0))+(IF(AND(AC35>=$W$62,AC35<$W$63),AD35,0))+(IF(AND(AC36>=$W$62,AC36<$W$63),AD36,0))+(IF(AND(AC37>=$W$62,AC37<$W$63),AD37,0))+(IF(AND(AC38>=$W$62,AC38<$W$63),AD38,0))+(IF(AND(AC39>=$W$62,AC39<$W$63),AD39,0))+(IF(AND(AC40>=$W$62,AC40<$W$63),AD40,0))+(IF(AND(AC41>=$W$62,AC41<$W$63),AD41,0))+(IF(AND(AC42>=$W$62,AC42<$W$63),AD42,0))+(IF(AND(AC43>=$W$62,AC43<$W$63),AD43,0))+(IF(AND(AC44>=$W$62,AC44<$W$63),AD44,0))+(IF(AND(AC45>=$W$62,AC45<$W$63),AD45,0))+(IF(AND(AC46>=$W$62,AC46<$W$63),AD46,0))+(IF(AND(AC47>=$W$62,AC47<$W$63),AD47,0))+(IF(AND(AC48>=$W$62,AC48<$W$63),AD48,0))+(IF(AND(AC49>=$W$62,AC49<$W$63),AD49,0))+(IF(AND(AC50>=$W$62,AC50<$W$63),AD50,0)),0)","v":12},null,{"$f":"ROUND((IF(AND(AE27>=$W$62,AE27<$W$63),AF27,0))+(IF(AND(AE28>=$W$62,AE28<$W$63),AF28,0))+(IF(AND(AE29>=$W$62,AE29<$W$63),AF29,0))+(IF(AND(AE30>=$W$62,AE30<$W$63),AF30,0))+(IF(AND(AE31>=$W$62,AE31<$W$63),AF31,0))+(IF(AND(AE32>=$W$62,AE32<$W$63),AF32,0))+(IF(AND(AE33>=$W$62,AE33<$W$63),AF33,0))+(IF(AND(AE34>=$W$62,AE34<$W$63),AF34,0))+(IF(AND(AE35>=$W$62,AE35<$W$63),AF35,0))+(IF(AND(AE36>=$W$62,AE36<$W$63),AF36,0))+(IF(AND(AE37>=$W$62,AE37<$W$63),AF37,0))+(IF(AND(AE38>=$W$62,AE38<$W$63),AF38,0))+(IF(AND(AE39>=$W$62,AE39<$W$63),AF39,0))+(IF(AND(AE40>=$W$62,AE40<$W$63),AF40,0))+(IF(AND(AE41>=$W$62,AE41<$W$63),AF41,0))+(IF(AND(AE42>=$W$62,AE42<$W$63),AF42,0))+(IF(AND(AE43>=$W$62,AE43<$W$63),AF43,0))+(IF(AND(AE44>=$W$62,AE44<$W$63),AF44,0))+(IF(AND(AE45>=$W$62,AE45<$W$63),AF45,0))+(IF(AND(AE46>=$W$62,AE46<$W$63),AF46,0))+(IF(AND(AE47>=$W$62,AE47<$W$63),AF47,0))+(IF(AND(AE48>=$W$62,AE48<$W$63),AF48,0))+(IF(AND(AE49>=$W$62,AE49<$W$63),AF49,0))+(IF(AND(AE50>=$W$62,AE50<$W$63),AF50,0)),0)","v":2}]
[null,null,null,{"$f":"DATE(YEAR(I27+(365*5)),1,1)","v":"2026-01-01"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATE(YEAR(W27+(365*5)),1,1)","v":"2026-01-01"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Liste déroulante"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mois","Mois","Résultats"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Janvier",1,{"$f":"IF(AND(S67>=$R$4,S67<=$S$4),$L$11,$L$12)","v":0.85}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Février",2,0.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mars",3,0.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Avril",4,0.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mai",5,0.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Juin",6,0.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Juillet",7,0.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Août",8,0.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Septembre",9,0.85]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Octobre",10,0.85]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Novembre",11,0.85]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Décembre",12,0.85]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Liste déroulante"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mois","Mois","Résultats"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Janvier",{"$f":"IF(AND(R82>=$R$4,R82<=$S$4),$L$11,$L$12)","v":0.85}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Février",0.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Mars",0.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"Avril",0.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"Mai",0.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"Juin",0.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"Juillet",0.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"Août",0.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"Septembre",0.85]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"Octobre",0.85]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"Novembre",0.85]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,"Décembre",0.85]