{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Explications","Nature","Base de coûts","Amortissements","Description des coûts","Plan d'affaires","Financement entreprise","Synthese","Aide prévisionnelle","Aide SEM","Synthèse par LOT"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":32,"defined_names":2835,"comments":3,"pivot_tables":5},"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":"Explications","index":0,"n_rows":35,"n_cols":8,"rows_kept":35,"cut":false,"hidden":false,"merged":[[1,1,2,12],[4,3,4,10],[9,3,9,10],[5,3,5,6],[5,7,5,10],[6,3,6,6],[6,7,6,10],[33,3,33,10],[34,3,34,10],[28,3,31,10],[13,3,13,10],[10,3,10,10],[21,3,24,10],[14,3,15,10],[16,3,17,10],[20,3,20,10],[27,3,27,10]]}
[]
[null,"Annexe 2\nConcours d'innovation\nInvestissements d'Avenir ADEME"]
[]
[]
[null,null,null,"  Principes généraux"]
[null,null,null,"Le document contient 2 types d'onglets :",null,null,null,"Les onglets bleus contiennent 2 types de cellules  :"]
[null,null,null,"1/ Onglets blancs : aide au remplissage de la base coûts\n\n2/ Onglets bleus : informations à compléter par le porteur de projet\n\n",null,null,null,"1/ Cellules blanches, qui doivent être complétées par le porteur de projet des différentes informations demandées,\n\n2/ Celulles Grises, qui contiennent des formules de calcul découlant des informations rentrées dans les cellules blanches,"]
[]
[]
[null,null,null," Onglet \"Nature\" : Définitions de la typologie des coûts"]
[null,null,null,"\n1/ Se familiariser avec les différentes natures de coûts possibles\n\n2/ Se familiariser avec les définitions des coûts \"Non retenus\", \"Non éligibles et \"Eligibles\""]
[]
[]
[null,null,null,"  Onglet \"Base de coûts\" : Compléter la base de coûts du projet"]
[null,null,null,"A L'ATTENTION DU PORTEUR DE PROJET:\n\n- L'unité de temps pour décrire le découpage de l'ensemble du projet sur chaque ligne a été fixée ausemestre.Si une tache se déroule sur 2 ans, soit 4 semestres, décomposer les coûts en 4 semestres soit 4 lignes pour la même tâche.\n\n- Ne renseigner qu'une valeur par cellule.\n\n"]
[]
[null,null,null,"1/ Remplir chaque ligne en précisant :\n\n- les informations liées à la structure du planning du projet dans les colonnes A à G,\n\n- le détail des coûts, dans les colonnes H à AA.\n\nLes coûts sont à exprimer hors TVA sauf pour les dépenses de sous-traitance en cas de non assujettissement à la TVA  ou d'assujettissement partiel du bénéficiaire et pour les frais de missions qui doivent toujours être exprimés en TTC.\n\n2/ En cas de besoin, une zone libre a été laissée à l'usage du porteur de projet pour transmettre à l'ADEME des commentaires pertinents pour l'instruction."]
[]
[]
[]
[null,null,null,"  Onglet \"Amortissements\" : Tableau d'amortissement des capex et des équipements de R&D"]
[null,null,null,"Renseigner par lot, par tâche, par sous-tâche :\n\n- la désignation et la description des differents biens acquis pour le projet,\n\n- la valeur d'acquisition, le semestre projet d'acquisition et la durée d'amortissement comptable (en semestre),\n\n- l'estimation de la part d'utilisation du bien affectée au projet (%) et la durée d'utilisation dans le cadre du projet en semestre,\n"]
[]
[]
[]
[]
[]
[null,null,null,"  Onglet \"Descriptions des coûts\" : Tableau de description des coûts"]
[null,null,null,"Renseigner par lot, par tâche, par sous-tache et par partenaire  :\n\n- La nature des coûts, les fournisseurs pressentis, la localisation, les biens achetés et leur montant,\n\n- Tout autre commentaire necessaire à l'instruction et à la bonne compréhension des coûts par l'ADEME par leur validation,\n\nCes éléments seront  utilisés par la suite lors des versements des aides."]
[]
[]
[]
[]
[null,null,null," Onglets \"Plan d'affaires\" et \"Financement entreprise\""]
[null,null,null,"-Plan d'affaires : Concerne les prévisions d'activités de l'entreprise et du projet \n\n- Financement entreprise :  Concerne le prévisionnel de l'entreprise sur l'intégralité de son activité, chaque année, projet déposé inclus."]

{"sheet":"Nature","index":1,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,7],[6,1,6,6],[9,1,9,2],[8,1,8,2],[9,3,9,4],[8,3,8,4],[8,5,8,6],[9,5,9,6]]}
[]
[null,"Définition des différents types de nature des coûts (colonnes S à Y de l'onglet \"base de coûts\")"]
[]
[null,"Salaires chargés non environnés","Frais connexes","Coûts de sous-traitance","Contribution aux amortissements","Coûts de refacturation interne","Frais de mission","Autres coûts"]
[null,"Dépenses de personnel employés exclusivement pour le projet, comprenant les salaires, les charges sociales afférentes et les indémnités de stage, hors frais généraux.","Les frais connexes sont les dépenses qui concourent à la réalisation du projet sans toutefois pouvoir être directement attribués à celui-ci.\n\nLe montant des frais connexes est forfaitaire et est calculé de la façon suivante :\n20% des salaires chargés non environnés","La sous-traitance s’effectue entre entreprises différentes (= SIREN différents), y compris membres d’un même groupe.\n\nSont éligibles les coûts de la recherche contractuelle, des connaissances techniques et d'achat de brevets et les coûts des prestations de services utilisés exclusivement pour l'activité du projet.\n\n","Coûts des instruments et du matériel utilisés pour le projet.\n\nSeuls les coûts d'amortissements correspondant à la durée du projet, calculés conformément aux pratiques comptables, sont admissibles.\n","La refacturation interne s’effectue au sein d’une même entreprise (= même SIREN).\n\nLa refacturation interne peut être éligible sous réserve :\n\n- d'être calculée sur une base précise d'unités identifiées (heure/lots/etc.),\n- d'être justifiée de façon précise quant à sa quotité affectée au projet,\n- de pouvoir faire l'objet d'une certification par un commissaire aux comptes ou expert-comptable.","Frais des déplacements liés à la réalisation du projet.\n\nFrais réels dont les justificatifs seront à fournir. Ils doivent être prévus et exprimés en TTC.","Autres frais d'exploitation résultant directement de l'activité du projet.\n\nCe sont les coûts des instruments et du matériel utilisés pour les besoins du projet. \n\nSi les instruments et le matériel ne sont pas utilisés pendant toute leur durée de vie pour le projet, alors seuls les coûts d'amortissement correspondant à la durée du projet, calculés conformément aux pratiques comptables, sont jugés admissibles"]
[]
[null,"Définition des catégories de coûts (colonne AB \"classification\"de l'onglet \"base de coûts\")"]
[]
[null,"Eligibles (DE)",null,"Non éligibles (NE)",null,"Non retenu (NR)"]
[null,"Les dépenses éligibles et retenues sont détaillées dans le régime d’aide de l’ADEME exempté de notification n° SA.40266 disponible en ligne, relatif aux aides à la Recherche, au Développement et à l’Innovation (RDI) et à la protection de l’environnement (LDE).\n\nLien: http://www.ademe.fr/sites/default/files/assets/documents/regime_exempte_ia_sa_40266.pdf",null,"Les coûts suivants ne sont pas éligibles dans le cas général : \n- les dépenses de communication/marketing, d’homologation/certification/normalisation, de dépôt de brevet ou de mise aux normes ;\n- les coûts de génie civil et les pertes d’exploitation dans la plupart des cas ;\n- une partie des investissements (cf. FAQ, notamment amortissement hors projet)\n\nCette liste n’est pas exhaustive. ",null,"Les coûts hors projet ou non necéssaire au projet ou considéré comme tel suite l’instruction approfondie du projet par les instructeurs de l’ADEME."]

{"sheet":"Base de coûts","index":2,"n_rows":262,"n_cols":36,"rows_kept":262,"cut":false,"hidden":false,"merged":[[0,0,0,4],[4,1,5,1],[2,4,2,6],[1,4,1,6],[4,3,5,4]]}
["Base de données des coûts du projet",null,null,null,null,null,null,"Homme.mois cat 1","Homme.mois cat 2","Homme.mois cat 3","Homme.mois cat 4","Homme.mois cat 5","Total Homme.mois",null,null,null,null,null,"Salaires chargés non environnés","Frais connexes","Coûts de sous-traitance","Contribution aux amortissements","Coût de refacturation interne","Frais de Mission","Autres coûts","Commentaires","Total des coûts",null,null,"Total coûts éligibles et retenus","Total coûts non éligibles","Total coûts non retenus","Total coûts non éligibles et non retenus","Subventions","Avances remboursables","Aide totale"]
[null,null,null,null,"TOTAL =>",null,null,{"$f":"SUM(H8:H262)","v":0},0,0,0,0,0,null,null,null,null,null,{"$f":"SUM(S8:S262)","v":0},0,0,0,0,0,0,null,{"$f":"SUM(AA8:AA262)","v":0},null,null,{"$f":"SUM(AD8:AD262)","v":0},0,0,0,0,0,0]
[null,null,null,"NOM DU PROJET A RENSEIGNER","SOUS-TOTAL =>",null,null,{"$f":"SUBTOTAL(9,H8:H262)","v":0},0,0,0,0,0,null,null,null,null,null,{"$f":"SUBTOTAL(9,S8:S262)","v":0},0,0,0,0,0,0,null,{"$f":"SUBTOTAL(9,AA8:AA262)","v":0},null,null,{"$f":"SUBTOTAL(9,AD8:AD262)","v":0},0,0,0,0,0,0]
[]
[null,"PE",null,"CATEGORIE D'ENTREPRISE A SELECTIONNER\n<=Sélectionner \"PE\" ou \"ME\"",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,"Taux de subventions","Taux d'avances remboursables"]
[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,{"$f":"AH3/AJ3","v":{"$error":"#DIV/0!"}},{"$f":"AI3/AJ3","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,"PASSER LA SOURIS SUR LES CELLULES BLEUES POUR VISUALISER LES COMMENTAIRES",null,null,null,null,null,null,null,"PASSER LA SOURIS SUR LES CELLULES BLEUES POUR VISUALISER LES COMMENTAIRES",null,null,null,null,null,null,null,null,"PASSER LA SOURIS SUR LES CELLULES BLEUES POUR VISUALISER LES COMMENTAIRES"]
["Lot","Tache","Sous-tache","Intitulé de l'activité","Période (semestre)","Livrable","Etape-clef","Homme.mois cat 1","Homme.mois cat 2","Homme.mois cat 3","Homme.mois cat 4","Homme.mois cat 5","Total Homme.mois","Salaires cat 1","Salaires cat 2","Salaires cat 3","Salaires cat 4","Salaires cat 5","Salaires chargés non environnés","Frais connexes (forfaitaires)","Coûts de sous-traitance","Contributions aux amortissements","Coûts de refacturation interne","Frais de mission","Autres coûts : achats,  consommables…","Commentaires","Total des coûts","Classification","Taux aide","Total coûts éligibles et retenus","Total coûts non éligibles","Total coûts non retenus","Total coûts non éligibles et non retenus","Subventions","Avances remboursables","Aide totale"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H9:L9)","v":0},null,null,null,null,null,{"$f":"H9*N9+I9*O9+J9*P9+K9*Q9+L9*R9","v":0},{"$f":"20%*S9","v":0},null,null,null,null,null,null,{"$f":"S9+SUM(T9:Y9)","v":0},null,{"$f":"IF(B$5=\"ME\",0.35,IF(B$5=\"PE\",0.45,0))","v":0.45},{"$f":"IF(AB9=\"DE\",AA9,0)","v":0},{"$f":"IF(AB9=\"NE\",AA9,0)","v":0},{"$f":"IF(AB9=\"NR\",AA9,0)","v":0},{"$f":"AE9+AF9","v":0},{"$f":"AJ9-AI9","v":0},{"$f":"IF(AJ9=0,0,IF($AJ$3*1/3<100000,100000/(COUNTIF($AJ$13:$AJ$261,\"<>0\")),AJ9*1/3))","v":0},{"$f":"AD9*AC9","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H10:L10)","v":0},null,null,null,null,null,{"$f":"H10*N10+I10*O10+J10*P10+K10*Q10+L10*R10","v":0},{"$f":"20%*S10","v":0},null,null,null,null,null,null,{"$f":"S10+SUM(T10:Y10)","v":0},null,0.45,{"$f":"IF(AB10=\"DE\",AA10,0)","v":0},{"$f":"IF(AB10=\"NE\",AA10,0)","v":0},{"$f":"IF(AB10=\"NR\",AA10,0)","v":0},{"$f":"AE10+AF10","v":0},{"$f":"AJ10-AI10","v":0},0,{"$f":"AD10*AC10","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H11:L11)","v":0},null,null,null,null,null,{"$f":"H11*N11+I11*O11+J11*P11+K11*Q11+L11*R11","v":0},{"$f":"20%*S11","v":0},null,null,null,null,null,null,{"$f":"S11+SUM(T11:Y11)","v":0},null,0.45,{"$f":"IF(AB11=\"DE\",AA11,0)","v":0},{"$f":"IF(AB11=\"NE\",AA11,0)","v":0},{"$f":"IF(AB11=\"NR\",AA11,0)","v":0},{"$f":"AE11+AF11","v":0},{"$f":"AJ11-AI11","v":0},0,{"$f":"AD11*AC11","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H12:L12)","v":0},null,null,null,null,null,{"$f":"H12*N12+I12*O12+J12*P12+K12*Q12+L12*R12","v":0},{"$f":"20%*S12","v":0},null,null,null,null,null,null,{"$f":"S12+SUM(T12:Y12)","v":0},null,0.45,{"$f":"IF(AB12=\"DE\",AA12,0)","v":0},{"$f":"IF(AB12=\"NE\",AA12,0)","v":0},{"$f":"IF(AB12=\"NR\",AA12,0)","v":0},{"$f":"AE12+AF12","v":0},{"$f":"AJ12-AI12","v":0},0,{"$f":"AD12*AC12","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H13:L13)","v":0},null,null,null,null,null,{"$f":"H13*N13+I13*O13+J13*P13+K13*Q13+L13*R13","v":0},{"$f":"20%*S13","v":0},null,null,null,null,null,null,{"$f":"S13+SUM(T13:Y13)","v":0},null,0.45,{"$f":"IF(AB13=\"DE\",AA13,0)","v":0},{"$f":"IF(AB13=\"NE\",AA13,0)","v":0},{"$f":"IF(AB13=\"NR\",AA13,0)","v":0},{"$f":"AE13+AF13","v":0},{"$f":"AJ13-AI13","v":0},0,{"$f":"AD13*AC13","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H14:L14)","v":0},null,null,null,null,null,{"$f":"H14*N14+I14*O14+J14*P14+K14*Q14+L14*R14","v":0},{"$f":"20%*S14","v":0},null,null,null,null,null,null,{"$f":"S14+SUM(T14:Y14)","v":0},null,0.45,{"$f":"IF(AB14=\"DE\",AA14,0)","v":0},0,0,{"$f":"AE14+AF14","v":0},{"$f":"AJ14-AI14","v":0},0,{"$f":"AD14*AC14","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,{"$f":"IF(B$5=\"ME\",0.35,IF(B$5=\"PE\",0.45,0))","v":0.45},0,0,0,0,0,{"$f":"IF(AJ73=0,0,IF($AJ$3*1/3<100000,100000/(COUNTIF($AJ$13:$AJ$261,\"<>0\")),AJ73*1/3))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H76:L76)","v":0},null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,{"$f":"H77*N77+I77*O77+J77*P77+K77*Q77+L77*R77","v":0},{"$f":"20%*S77","v":0},null,null,null,null,null,null,{"$f":"S77+SUM(T77:Y77)","v":0},null,0.45,{"$f":"IF(AB77=\"DE\",AA77,0)","v":0},{"$f":"IF(AB77=\"NE\",AA77,0)","v":0},{"$f":"IF(AB77=\"NR\",AA77,0)","v":0},{"$f":"AE77+AF77","v":0},{"$f":"AJ77-AI77","v":0},0,{"$f":"AD77*AC77","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,{"$f":"IF(B$5=\"ME\",0.35,IF(B$5=\"PE\",0.45,0))","v":0.45},0,0,0,0,0,{"$f":"IF(AJ137=0,0,IF($AJ$3*1/3<100000,100000/(COUNTIF($AJ$13:$AJ$261,\"<>0\")),AJ137*1/3))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H140:L140)","v":0},null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,{"$f":"H141*N141+I141*O141+J141*P141+K141*Q141+L141*R141","v":0},{"$f":"20%*S141","v":0},null,null,null,null,null,null,{"$f":"S141+SUM(T141:Y141)","v":0},null,0.45,{"$f":"IF(AB141=\"DE\",AA141,0)","v":0},{"$f":"IF(AB141=\"NE\",AA141,0)","v":0},{"$f":"IF(AB141=\"NR\",AA141,0)","v":0},{"$f":"AE141+AF141","v":0},{"$f":"AJ141-AI141","v":0},0,{"$f":"AD141*AC141","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,{"$f":"IF(B$5=\"ME\",0.35,IF(B$5=\"PE\",0.45,0))","v":0.45},0,0,0,0,0,{"$f":"IF(AJ201=0,0,IF($AJ$3*1/3<100000,100000/(COUNTIF($AJ$13:$AJ$261,\"<>0\")),AJ201*1/3))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H204:L204)","v":0},null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,{"$f":"H205*N205+I205*O205+J205*P205+K205*Q205+L205*R205","v":0},{"$f":"20%*S205","v":0},null,null,null,null,null,null,{"$f":"S205+SUM(T205:Y205)","v":0},null,0.45,{"$f":"IF(AB205=\"DE\",AA205,0)","v":0},{"$f":"IF(AB205=\"NE\",AA205,0)","v":0},{"$f":"IF(AB205=\"NR\",AA205,0)","v":0},{"$f":"AE205+AF205","v":0},{"$f":"AJ205-AI205","v":0},0,{"$f":"AD205*AC205","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H256:L256)","v":0},null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0.45,0,0,0,0,0,0,0]
[null,null,null,"NE PAS COPIER/COLLER DE LIGNE EN-DESSOUS"]

{"sheet":"Amortissements","index":3,"n_rows":52,"n_cols":13,"rows_kept":52,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5]]}
["Tableau d'amortissement d'équipements de R&D",null,null,null,null,null,"(comptes éligibles du PGC : 6122, 6135 et 6811)"]
[null,null,null,null,null,null,null,null,null,"PASSER LA SOURIS SUR LES CELLULES BLEUES POUR VISUALISER LES COMMENTAIRES"]
[null,null,null,null,null,null,null,"ONGLET A REMPLIR OBLIGATOIREMENT"]
["Lot","Tache","Sous-tâche","Partenaire","Désignation et description synthétique\nde l'équipement amorti","Valeur d'acquisition (€)","Semestre projet d'acquisition","Durée d'amortissement comptable (en semestre)","Amortissement semestriel (€)","Part d'utilisation affectée au projet (%)","Durée d'utilisation dans le cadre du projet (en semestre)","Contribution aux amortissements sur la durée du projet (€)","Commentaires"]
[null,null,null,null,null,null,null,null,{"$f":"IF(D5=\"\",\"\",F5/H5)","v":""},null,null,{"$f":"IF(D5=\"\",\"\",IF(I5*J5*K5>F5,F5,I5*J5*K5))","v":""}]
[null,null,null,null,null,null,null,null,"",null,null,{"$f":"IF(D6=\"\",\"\",I6*J6*K6)","v":""}]
[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,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,"",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,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,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,""]
[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,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,"",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,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,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,""]
[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,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,"",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,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]

{"sheet":"Description des coûts","index":4,"n_rows":4,"n_cols":9,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,0,0,4],[1,0,1,4]]}
["Description des coûts"]
[null,null,null,null,null,null,null,"PASSER LA SOURIS SUR LES CELLULES BLEUES POUR VISUALISER LES COMMENTAIRES"]
[null,null,null,null,null,"ONGLET A REMPLIR OBLIGATOIREMENT"]
["Lot","Tache","Partenaire","Nature des coûts","Fournisseur pressenti","Localisation","Bien acheté","Montant unitaire (€)","Commentaires"]

{"sheet":"Plan d'affaires","index":5,"n_rows":74,"n_cols":11,"rows_kept":74,"cut":false,"hidden":false,"merged":[[34,1,48,1],[50,1,64,1],[40,2,40,3],[41,2,41,3],[42,2,42,3],[36,2,36,3],[38,2,38,3],[45,2,45,3],[63,2,63,3],[52,2,52,3],[62,2,62,3],[57,2,57,3],[50,2,50,3],[51,2,51,3],[46,2,46,3],[56,2,56,3],[35,2,35,3],[39,2,39,3],[26,2,26,3],[31,2,31,3],[28,2,28,3],[30,2,30,3],[29,2,29,3],[27,2,27,3],[21,2,21,3],[22,2,22,3],[24,2,24,3],[5,2,5,3],[32,2,32,3],[19,2,19,3],[23,2,23,3],[20,2,20,3],[25,2,25,3],[6,1,16,1],[6,2,6,10],[7,2,9,2],[10,2,12,2],[13,2,15,2],[16,2,16,3],[73,2,73,3],[66,1,69,1],[70,1,73,1],[67,2,67,3],[68,2,68,3],[69,2,69,3],[70,2,70,3],[71,2,71,3],[72,2,72,3],[66,2,66,3],[18,1,32,1],[60,2,60,3],[61,2,61,3],[64,2,64,3],[54,2,54,3],[55,2,55,3],[58,2,58,3],[59,2,59,3],[47,2,47,3],[48,2,48,3],[53,2,53,3],[34,2,34,3],[43,2,43,3],[44,2,44,3],[37,2,37,3],[18,2,18,3]]}
[null,"Prévision d'activités de l'entreprise et du projet  : OBLIGATOIRE"]
[null,"Copier / coller le 1er tableau (CHIFFRE D'AFFAIRES ISSU DU PROJET) dans le dossier de candidature (PARTIE 2, paragraphe 8)"]
[null,"Année de départ = année du dépôt du projet"]
[null,"Durée à considérer = Durée du projet + 3 ans "]
[null,"Charges à comptabiliser en négatif, produits en positif"]
[null,null,"Montants exprimés en (€)",null,"Année de départ",{"$f":"IF($E$6=\"Année de départ\",\"\",E6+1)","v":""},"","","","",""]
[null,"PROJET","CHIFFRE D'AFFAIRES ISSU DU PROJET\nà décliner par unité d'œuvre : produits, services, royalties, licences, … "]
[null,null,"-Unité d'œuvre 1","Chiffre d'affaires",{"$f":"E10*E9","v":0},0,0,0,0,0,0]
[null,null,null,"Nombre d'unités vendues"]
[null,null,null,"Prix unitaire"]
[null,null,"-Unité d'œuvre 2","Chiffre d'affaires",{"$f":"E12*E13","v":0},0,0,0,0,0,0]
[null,null,null,"Nombre d'unités vendues"]
[null,null,null,"Prix unitaire"]
[null,null,"-Unité d'œuvre 3","Chiffre d'affaires",{"$f":"E15*E16","v":0},0,0,0,0,0,0]
[null,null,null,"Nombre d'unités vendues"]
[null,null,null,"Prix unitaire"]
[null,null,"TOTAL CHIFFRE D'AFFAIRES GENERE PAR LES RESULTATS DU PROJET",null,{"$f":"SUM(E8,E11,E14)","v":0},{"$f":"SUM(F8,F11,F14)","v":0},0,0,0,0,0]
[]
[null,"PROJET","Autres produits liés au projet (dont subventions d'exploit.)"]
[null,null,"Produits du projet",null,{"$f":"E17+E19","v":0},{"$f":"F17+F19","v":0},0,0,0,0,0]
[null,null,"Achats (marchandises et matières premières)"]
[null,null," +/- Variation de stock de matières et marchandises (inclus prod. Immobilisée et stockée)"]
[null,null,"Charges du personnel (Salaires & cotisations sociales)"]
[null,null,"Sous-traitance"]
[null,null,"Refacturation interne"]
[null,null,"Frais de mission"]
[null,null,"Autres coûts"]
[null,null,"Frais connexes"]
[null,null,"Impôts, taxes et versements assimilés"]
[null,null,"Crédit-bail et location"]
[null,null,"Excédent brut d'exploitation projet",null,{"$f":"E20+SUM(E21:E30)","v":0},{"$f":"F20+SUM(F21:F30)","v":0},0,0,0,0,0]
[null,null,"Dotations aux amortissements d'exploitation"]
[null,null,"Dotations aux provisions"]
[]
[null,"HORS PROJET","TOTAL CHIFFRE D'AFFAIRE  HORS PROJET "]
[null,null,"Achats (marchandises et matières premières)"]
[null,null," +/- Variation de stock de matières et marchandises (inclus prod. Immobilisée et stockée)"]
[null,null,"Charges du personnel (Salaires & cotisations sociales)"]
[null,null,"Sous-traitance"]
[null,null,"Crédit-bail"]
[null,null,"Location"]
[null,null,"Interim"]
[null,null,"Autres charges externes"]
[null,null,"Subventions d'exploitation reçues"]
[null,null,"Impôts et taxes"]
[null,null,"Autres produits et charges d'exploitation"]
[null,null,"Excédent brut d'exploitation hors projet",null,{"$f":"E35+SUM(E36:E46)","v":0},{"$f":"F35+SUM(F36:F46)","v":0},0,0,0,0,0]
[null,null,"Dotations aux amortissements d'exploitation"]
[null,null,"Dotations aux provisions"]
[]
[null,"TOTAL ENTREPRISE","Chiffre d'affaires total",null,{"$f":"E35+E17","v":0},{"$f":"F35+F17","v":0},0,0,0,0,0]
[null,null,"Excédent brut d'exploitation total",null,{"$f":"E47+E31","v":0},{"$f":"F47+F31","v":0},0,0,0,0,0]
[null,null,"Excédent brut d'exploitation/chiffre d'affaires total",null,{"$f":"E52/E51","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"Produits financiers"]
[null,null,"Charges financières"]
[null,null,"Amortissements et provisions financières"]
[null,null,"Résultat courant avant impôts hors projet",null,{"$f":"E47+E31+SUM(E54:E56)+SUM(E32:E33,E48:E49)","v":0},{"$f":"F47+F31+SUM(F54:F56)+SUM(F32:F33,F48:F49)","v":0},0,0,0,0,0]
[null,null,"Résultat courant avant impôts/chiffre d'affaires total",null,{"$f":"E57/E51","v":{"$error":"#DIV/0!"}},{"$f":"F57/F51","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"Produits exceptionnels"]
[null,null,"Charges exceptionnelles"]
[null,null,"Amortissements et provisions exceptionnelles"]
[null,null,"Impôts sur les bénéfices (dont crédit impôt recherche)"]
[null,null,"RESULTAT DE L'EXERCICE",null,{"$f":"E57+SUM(E59:E62)","v":0},{"$f":"F57+SUM(F59:F62)","v":0},0,0,0,0,0]
[null,null,"Résultat de l'exercice/chiffre d'affaires total",null,{"$f":"E63/E51","v":{"$error":"#DIV/0!"}},{"$f":"F63/F51","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"CAF",null,{"$f":"E63+E56+E61+E48+E49+E33+E32","v":0},{"$f":"F63+F56+F61+F48+F49+F33+F32","v":0},0,{"$f":"H63+H56+H61+H48+H49+H33+H32","v":0},0,0,0]
[]
[null,"PROJET","Emplois créés grâce au projet :",null,{"$f":"SUM(E68:E70)","v":0},{"$f":"SUM(F68:F70)","v":0},0,0,0,0,0]
[null,null,"-R&D"]
[null,null,"-Industriel"]
[null,null,"-Autres"]
[null,"ENTREPRISE","Effectif global de l'entreprise :",null,{"$f":"SUM(E72:E74)","v":0},{"$f":"SUM(F72:F74)","v":0},0,0,0,0,0]
[null,null,"-R&D"]
[null,null,"-Industriel"]
[null,null,"-Autres"]

{"sheet":"Financement entreprise","index":6,"n_rows":26,"n_cols":16,"rows_kept":26,"cut":false,"hidden":false,"merged":[[15,1,15,5],[4,1,4,5],[5,1,5,5],[6,1,6,5],[10,1,10,3],[10,4,10,5],[11,1,11,3],[11,4,11,5],[12,1,12,5],[13,1,13,5],[14,1,14,5],[8,1,8,5],[9,1,9,5],[7,1,7,5],[16,1,16,5],[17,1,17,5],[18,1,18,5],[19,1,20,3],[19,4,19,5],[20,4,20,5],[21,1,21,5],[22,1,22,5],[23,1,23,5],[24,1,24,5],[25,1,25,5],[13,15,13,20],[14,15,14,20],[18,15,18,20],[21,15,21,21],[15,15,16,21],[17,15,17,21],[19,15,20,21]]}
[null," Plan de financement prévisionnel de l'entreprise (phases R&D et d’exploitation des résultats) : OBLIGATOIRE"]
[null,null,"Année de départ = année du dépôt du projet"]
[null,null,"Concerne le prévisionnel de l'entreprise sur l'intégralité de son activité, chaque année, projet déposé inclus."]
[null,null,"Durée à considérer = Durée du projet + 3 ans "]
[null,"Montants exprimés en (€)",null,null,null,null,"Année de départ",{"$f":"IF($G$5=\"Année de départ\",\"\",G5+1)","v":""},"","","","",""]
[null,"Dépenses du projet - (Phase R&D, investissement et exploitation)"]
[null,"Investissements liés au lancement industriel et commercial \ndes résultats du projet"]
[null,"Dépenses liées à la R&D de l'entreprise (hors projet déposé)"]
[null,"Autre investissements de l'entreprise (hors projets R&D, hors projet déposé)"]
[null,"Dépenses fixes et variables de l'entreprise (hors projets R&D, hors projet déposé)"]
[null,"Besoin en fonds",null,null,"Augmentation (+)"]
[null,"de roulement ",null,null,"Diminution (-)"]
[null,"Remboursement de crédit"]
[null,"Remboursement des Avances récupérables du Concours d'innovation ",null,null,null,null,null,null,null,null,null,null,null,null,null,"* Information sur les versements de l'aide (à titre indicatif, qui pourra être recalculé durant l'instruction ) :"]
[null,"Divers (dont distribution de dividendes)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Projet dont le coût total < 800 k € : "]
[null,"TOTAL DES BESOINS",null,null,null,null,{"$f":"G6+G7+G11-G12+G13-G14+G15","v":0},{"$f":"H6+H7+H11-H12+H13-H14+H15","v":0},0,0,0,0,0,null,null," - 1er versement lors de l'année de dépôt du projet, correspondant à 70% du montant de l'aide dans la limite de 200 k€ maximum,"]
[null,"Augmentation de capital"]
[null,"Apports en comptes courants",null,null,null,null,null,null,null,null,null,null,null,null,null," - 2e versement correspondant au complémentaire de l'aide, à la clôture du projet "]
[null,"Capacité d'autofinancement",null,null,null,null,{"$f":"'Plan d''affaires'!E65","v":0},{"$f":"'Plan d''affaires'!F65","v":0},{"$f":"'Plan d''affaires'!G65","v":0},{"$f":"'Plan d''affaires'!H65","v":0},{"$f":"'Plan d''affaires'!I65","v":0},{"$f":"'Plan d''affaires'!J65","v":0},{"$f":"'Plan d''affaires'!K65","v":0},null,null,"Projet dont le coûts total ≥ 800 k€ : "]
[null,"Emprunts ",null,null,"Déjà négociés",null,null,null,null,null,null,null,null,null,null," - 1er versement lors de l'année de dépôt du projet, correspondant à 70% du montant de l'aide dans la limite de 200 k€ maximum,"]
[null,null,null,null,"Restant à négocier"]
[null,"Aide Concours d'innovation demandée *",null,null,null,null,null,null,null,null,null,null,null,null,null," - Dernier versement correspondant au minimum à 20% de l'aide, lors du solde du projet"]
[null,"Autres aides publiques prévues (dont Crédit Impôt Recherche)",null,null,null,null,null,null,null,null,null,null,null,null,null," - Un versement par année sur la durée du projet (valeur moyenne, par an, sur le montant restant)"]
[null,"TOTAL DES RESSOURCES",null,null,null,null,{"$f":"SUM(G17:G23)","v":0},{"$f":"SUM(H17:H23)","v":0},0,0,0,0,0]
[null,"SOLDE DE TRESORERIE",null,null,null,null,{"$f":"G24-G16","v":0},0,0,0,0,0,0]
[null,"CUMUL DE TRESORERIE ",null,null,null,null,{"$f":"F26+G25","v":0},0,0,0,0,0,0]

{"sheet":"Synthese","index":7,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":true,"merged":[[0,0,0,4]]}
["Synthèse des coûts du projet"]
[]
["Copier / coller ce tableau dans le dossier de candidature"]
[]
["Salaires chargés environnés :",0]
["Frais connexes (forfaitaires) :",0]
["Coûts de sous-traitance :"]
["Contributions aux amortissements :"]
["Frais de mission :"]
["Coûts de refacturation interne :"]
["Autres coûts :"]
["Total des coûts :",0]

{"sheet":"Aide prévisionnelle","index":8,"n_rows":23,"n_cols":2,"rows_kept":23,"cut":false,"hidden":true,"merged":[[0,0,0,4]]}
["Aide prévisionnelle au projet"]
[]
[]
[]
["Coûts totaux (€)",0]
["Coûts éligibles et retenus (€)",0]
["Subventions (€)",0]
["Avances remboursables (€)",0]
["Aide totale (€)",0]
["Taux d'aide sur éligibles et retenus",0]
["Part d'avances remboursables",0]
[]
[]
[]
[]
[]
[]
[]
[null,"(vide)"]
["Coûts totaux (€)",0]
["Somme de Avances remboursables",0]
["Somme de Subventions",0]
["Somme de Aide totale",0]

{"sheet":"Aide SEM","index":9,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
[]
["A usage exclusif ADEME : tableau intermédiaire de calcul ne représentant pas la réalité des versements aux bénéficiaires"]
[]
[null,"(vide)","Total général"]
["Aide / semestre",0,0]

{"sheet":"Synthèse par LOT","index":10,"n_rows":603,"n_cols":7,"rows_kept":603,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,null,"Étiquettes de colonnes"]
["Étiquettes de lignes","Valeurs","(vide)","Total général"]
["(vide)","Salaires chargés non environnés ",0,0]
[null,"Frais connexes (forfaitaires) ",0,0]
[null,"Frais de mission "]
[null,"Contributions aux amortissements "]
[null,"Coûts de sous-traitance "]
[null,"Coûts totaux ",0,0]
["Total Salaires chargés non environnés ",null,0,0]
["Total Frais connexes (forfaitaires) ",null,0,0]
["Total Frais de mission "]
["Total Contributions aux amortissements "]
["Total Coûts de sous-traitance "]
["Total Coûts totaux ",null,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"ISNA(N(HLOOKUP(C$307,Synth_lots,1,FALSE)))","v":false},null,{"$f":"ISNA(N(HLOOKUP(E$307,Synth_lots,1,FALSE)))","v":true},{"$f":"ISNA(N(HLOOKUP(F$307,Synth_lots,1,FALSE)))","v":true},{"$f":"ISNA(N(HLOOKUP(G$307,Synth_lots,1,FALSE)))","v":true}]
[null,"Classification par lots","Total général","Total éligibles et retenus","DE","NE","NR"]
[{"$f":"LEFT(A5,5)","v":"(vide"},{"$f":"IF(LEFT(A5,5)=\"Total\",RIGHT(A5, LEN(A5)-6),IF(ISBLANK(B5),\"\",B5))","v":"Salaires chargés non environnés "},{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B308),FALSE)))","v":0},{"$f":"E308","v":0},{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B308),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B308),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B308),FALSE)))","v":0}]
[{"$f":"LEFT(A6,5)","v":""},{"$f":"IF(LEFT(A6,5)=\"Total\",RIGHT(A6, LEN(A6)-6),IF(ISBLANK(B6),\"\",B6))","v":"Frais connexes (forfaitaires) "},{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B309),FALSE)))","v":0},{"$f":"E309","v":0},{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B309),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B309),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B309),FALSE)))","v":0}]
["","Frais de mission ",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B310),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B310),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B310),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B310),FALSE)))","v":0}]
["","Contributions aux amortissements ",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B311),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B311),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B311),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B311),FALSE)))","v":0}]
["","Coûts de sous-traitance ",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B312),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B312),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B312),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B312),FALSE)))","v":0}]
["","Coûts totaux ",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B313),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B313),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B313),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B313),FALSE)))","v":0}]
["Total","Salaires chargés non environnés ",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B314),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B314),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B314),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B314),FALSE)))","v":0}]
["Total","Frais connexes (forfaitaires) ",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B315),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B315),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B315),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B315),FALSE)))","v":0}]
["Total","Frais de mission ",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B316),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B316),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B316),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B316),FALSE)))","v":0}]
["Total","Contributions aux amortissements ",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B317),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B317),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B317),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B317),FALSE)))","v":0}]
["Total","Coûts de sous-traitance ",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B318),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B318),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B318),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B318),FALSE)))","v":0}]
["Total","Coûts totaux ",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B319),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B319),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B319),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B319),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B320),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B320),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B320),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B320),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B321),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B321),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B321),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B321),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B322),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B322),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B322),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B322),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B323),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B323),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B323),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B323),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B324),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B324),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B324),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B324),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B325),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B325),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B325),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B325),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B326),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B326),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B326),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B326),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B327),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B327),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B327),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B327),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B328),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B328),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B328),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B328),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B329),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B329),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B329),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B329),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B330),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B330),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B330),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B330),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B331),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B331),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B331),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B331),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B332),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B332),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B332),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B332),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B333),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B333),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B333),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B333),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B334),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B334),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B334),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B334),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B335),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B335),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B335),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B335),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B336),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B336),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B336),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B336),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B337),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B337),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B337),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B337),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B338),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B338),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B338),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B338),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B339),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B339),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B339),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B339),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B340),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B340),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B340),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B340),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B341),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B341),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B341),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B341),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B342),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B342),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B342),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B342),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B343),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B343),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B343),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B343),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B344),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B344),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B344),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B344),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B345),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B345),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B345),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B345),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B346),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B346),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B346),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B346),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B347),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B347),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B347),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B347),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B348),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B348),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B348),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B348),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B349),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B349),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B349),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B349),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B350),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B350),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B350),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B350),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B351),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B351),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B351),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B351),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B352),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B352),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B352),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B352),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B353),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B353),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B353),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B353),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B354),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B354),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B354),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B354),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B355),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B355),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B355),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B355),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B356),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B356),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B356),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B356),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B357),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B357),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B357),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B357),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B358),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B358),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B358),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B358),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B359),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B359),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B359),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B359),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B360),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B360),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B360),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B360),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B361),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B361),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B361),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B361),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B362),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B362),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B362),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B362),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B363),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B363),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B363),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B363),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B364),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B364),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B364),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B364),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B365),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B365),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B365),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B365),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B366),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B366),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B366),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B366),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B367),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B367),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B367),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B367),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B368),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B368),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B368),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B368),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B369),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B369),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B369),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B369),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B370),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B370),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B370),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B370),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B371),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B371),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B371),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B371),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B372),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B372),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B372),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B372),FALSE)))","v":0}]
[{"$f":"LEFT(A70,5)","v":""},{"$f":"IF(LEFT(A70,5)=\"Total\",RIGHT(A70, LEN(A70)-6),IF(ISBLANK(B70),\"\",B70))","v":""},{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B373),FALSE)))","v":0},{"$f":"E373","v":0},{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B373),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B373),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B373),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B374),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B374),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B374),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B374),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B375),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B375),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B375),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B375),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B376),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B376),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B376),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B376),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B377),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B377),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B377),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B377),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B378),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B378),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B378),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B378),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B379),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B379),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B379),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B379),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B380),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B380),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B380),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B380),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B381),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B381),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B381),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B381),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B382),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B382),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B382),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B382),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B383),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B383),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B383),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B383),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B384),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B384),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B384),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B384),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B385),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B385),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B385),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B385),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B386),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B386),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B386),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B386),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B387),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B387),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B387),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B387),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B388),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B388),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B388),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B388),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B389),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B389),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B389),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B389),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B390),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B390),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B390),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B390),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B391),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B391),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B391),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B391),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B392),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B392),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B392),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B392),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B393),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B393),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B393),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B393),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B394),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B394),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B394),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B394),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B395),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B395),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B395),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B395),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B396),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B396),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B396),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B396),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B397),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B397),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B397),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B397),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B398),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B398),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B398),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B398),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B399),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B399),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B399),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B399),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B400),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B400),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B400),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B400),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B401),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B401),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B401),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B401),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B402),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B402),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B402),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B402),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B403),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B403),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B403),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B403),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B404),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B404),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B404),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B404),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B405),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B405),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B405),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B405),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B406),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B406),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B406),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B406),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B407),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B407),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B407),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B407),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B408),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B408),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B408),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B408),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B409),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B409),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B409),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B409),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B410),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B410),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B410),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B410),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B411),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B411),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B411),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B411),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B412),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B412),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B412),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B412),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B413),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B413),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B413),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B413),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B414),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B414),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B414),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B414),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B415),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B415),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B415),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B415),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B416),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B416),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B416),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B416),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B417),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B417),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B417),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B417),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B418),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B418),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B418),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B418),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B419),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B419),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B419),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B419),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B420),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B420),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B420),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B420),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B421),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B421),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B421),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B421),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B422),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B422),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B422),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B422),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B423),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B423),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B423),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B423),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B424),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B424),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B424),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B424),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B425),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B425),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B425),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B425),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B426),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B426),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B426),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B426),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B427),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B427),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B427),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B427),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B428),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B428),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B428),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B428),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B429),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B429),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B429),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B429),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B430),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B430),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B430),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B430),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B431),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B431),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B431),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B431),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B432),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B432),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B432),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B432),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B433),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B433),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B433),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B433),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B434),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B434),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B434),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B434),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B435),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B435),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B435),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B435),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B436),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B436),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B436),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B436),FALSE)))","v":0}]
[{"$f":"LEFT(A134,5)","v":""},{"$f":"IF(LEFT(A134,5)=\"Total\",RIGHT(A134, LEN(A134)-6),IF(ISBLANK(B134),\"\",B134))","v":""},{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B437),FALSE)))","v":0},{"$f":"E437","v":0},{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B437),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B437),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B437),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B438),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B438),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B438),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B438),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B439),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B439),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B439),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B439),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B440),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B440),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B440),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B440),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B441),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B441),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B441),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B441),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B442),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B442),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B442),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B442),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B443),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B443),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B443),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B443),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B444),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B444),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B444),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B444),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B445),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B445),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B445),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B445),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B446),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B446),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B446),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B446),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B447),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B447),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B447),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B447),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B448),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B448),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B448),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B448),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B449),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B449),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B449),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B449),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B450),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B450),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B450),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B450),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B451),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B451),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B451),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B451),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B452),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B452),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B452),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B452),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B453),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B453),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B453),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B453),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B454),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B454),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B454),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B454),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B455),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B455),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B455),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B455),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B456),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B456),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B456),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B456),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B457),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B457),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B457),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B457),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B458),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B458),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B458),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B458),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B459),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B459),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B459),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B459),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B460),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B460),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B460),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B460),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B461),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B461),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B461),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B461),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B462),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B462),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B462),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B462),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B463),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B463),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B463),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B463),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B464),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B464),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B464),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B464),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B465),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B465),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B465),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B465),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B466),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B466),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B466),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B466),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B467),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B467),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B467),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B467),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B468),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B468),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B468),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B468),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B469),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B469),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B469),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B469),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B470),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B470),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B470),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B470),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B471),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B471),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B471),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B471),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B472),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B472),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B472),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B472),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B473),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B473),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B473),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B473),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B474),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B474),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B474),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B474),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B475),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B475),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B475),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B475),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B476),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B476),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B476),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B476),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B477),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B477),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B477),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B477),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B478),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B478),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B478),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B478),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B479),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B479),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B479),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B479),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B480),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B480),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B480),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B480),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B481),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B481),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B481),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B481),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B482),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B482),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B482),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B482),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B483),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B483),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B483),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B483),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B484),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B484),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B484),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B484),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B485),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B485),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B485),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B485),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B486),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B486),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B486),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B486),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B487),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B487),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B487),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B487),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B488),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B488),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B488),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B488),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B489),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B489),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B489),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B489),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B490),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B490),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B490),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B490),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B491),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B491),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B491),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B491),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B492),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B492),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B492),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B492),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B493),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B493),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B493),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B493),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B494),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B494),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B494),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B494),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B495),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B495),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B495),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B495),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B496),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B496),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B496),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B496),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B497),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B497),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B497),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B497),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B498),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B498),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B498),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B498),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B499),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B499),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B499),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B499),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B500),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B500),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B500),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B500),FALSE)))","v":0}]
[{"$f":"LEFT(A198,5)","v":""},{"$f":"IF(LEFT(A198,5)=\"Total\",RIGHT(A198, LEN(A198)-6),IF(ISBLANK(B198),\"\",B198))","v":""},{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B501),FALSE)))","v":0},{"$f":"E501","v":0},{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B501),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B501),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B501),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B502),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B502),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B502),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B502),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B503),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B503),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B503),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B503),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B504),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B504),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B504),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B504),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B505),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B505),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B505),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B505),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B506),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B506),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B506),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B506),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B507),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B507),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B507),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B507),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B508),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B508),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B508),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B508),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B509),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B509),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B509),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B509),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B510),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B510),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B510),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B510),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B511),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B511),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B511),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B511),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B512),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B512),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B512),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B512),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B513),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B513),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B513),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B513),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B514),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B514),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B514),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B514),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B515),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B515),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B515),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B515),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B516),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B516),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B516),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B516),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B517),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B517),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B517),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B517),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B518),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B518),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B518),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B518),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B519),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B519),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B519),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B519),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B520),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B520),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B520),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B520),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B521),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B521),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B521),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B521),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B522),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B522),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B522),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B522),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B523),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B523),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B523),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B523),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B524),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B524),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B524),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B524),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B525),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B525),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B525),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B525),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B526),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B526),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B526),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B526),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B527),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B527),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B527),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B527),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B528),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B528),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B528),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B528),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B529),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B529),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B529),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B529),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B530),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B530),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B530),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B530),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B531),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B531),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B531),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B531),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B532),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B532),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B532),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B532),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B533),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B533),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B533),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B533),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B534),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B534),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B534),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B534),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B535),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B535),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B535),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B535),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B536),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B536),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B536),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B536),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B537),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B537),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B537),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B537),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B538),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B538),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B538),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B538),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B539),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B539),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B539),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B539),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B540),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B540),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B540),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B540),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B541),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B541),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B541),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B541),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B542),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B542),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B542),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B542),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B543),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B543),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B543),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B543),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B544),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B544),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B544),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B544),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B545),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B545),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B545),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B545),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B546),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B546),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B546),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B546),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B547),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B547),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B547),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B547),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B548),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B548),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B548),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B548),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B549),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B549),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B549),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B549),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B550),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B550),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B550),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B550),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B551),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B551),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B551),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B551),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B552),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B552),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B552),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B552),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B553),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B553),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B553),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B553),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B554),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B554),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B554),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B554),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B555),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B555),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B555),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B555),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B556),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B556),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B556),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B556),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B557),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B557),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B557),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B557),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B558),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B558),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B558),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B558),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B559),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B559),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B559),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B559),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B560),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B560),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B560),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B560),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B561),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B561),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B561),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B561),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B562),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B562),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B562),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B562),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B563),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B563),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B563),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B563),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B564),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B564),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B564),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B564),FALSE)))","v":0}]
[{"$f":"LEFT(A262,5)","v":""},{"$f":"IF(LEFT(A262,5)=\"Total\",RIGHT(A262, LEN(A262)-6),IF(ISBLANK(B262),\"\",B262))","v":""},{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B565),FALSE)))","v":0},{"$f":"E565","v":0},{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B565),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B565),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B565),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B566),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B566),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B566),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B566),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B567),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B567),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B567),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B567),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B568),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B568),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B568),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B568),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B569),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B569),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B569),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B569),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B570),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B570),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B570),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B570),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B571),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B571),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B571),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B571),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B572),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B572),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B572),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B572),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B573),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B573),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B573),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B573),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B574),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B574),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B574),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B574),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B575),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B575),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B575),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B575),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B576),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B576),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B576),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B576),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B577),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B577),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B577),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B577),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B578),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B578),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B578),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B578),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B579),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B579),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B579),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B579),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B580),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B580),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B580),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B580),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B581),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B581),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B581),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B581),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B582),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B582),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B582),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B582),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B583),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B583),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B583),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B583),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B584),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B584),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B584),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B584),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B585),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B585),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B585),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B585),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B586),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B586),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B586),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B586),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B587),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B587),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B587),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B587),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B588),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B588),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B588),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B588),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B589),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B589),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B589),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B589),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B590),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B590),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B590),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B590),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B591),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B591),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B591),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B591),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B592),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B592),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B592),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B592),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B593),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B593),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B593),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B593),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B594),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B594),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B594),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B594),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B595),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B595),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B595),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B595),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B596),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B596),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B596),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B596),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B597),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B597),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B597),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B597),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B598),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B598),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B598),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B598),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B599),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B599),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B599),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B599),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B600),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B600),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B600),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B600),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B601),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B601),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B601),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B601),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B602),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B602),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B602),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B602),FALSE)))","v":0}]
["","",{"$f":"IF(C$306=TRUE,0,N(HLOOKUP(C$307,Synth_lots,COUNTA($B$307:$B603),FALSE)))","v":0},0,{"$f":"IF(E$306=TRUE,0,N(HLOOKUP(E$307,Synth_lots,COUNTA($B$307:$B603),FALSE)))","v":0},{"$f":"IF(F$306=TRUE,0,N(HLOOKUP(F$307,Synth_lots,COUNTA($B$307:$B603),FALSE)))","v":0},{"$f":"IF(G$306=TRUE,0,N(HLOOKUP(G$307,Synth_lots,COUNTA($B$307:$B603),FALSE)))","v":0}]