{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Instructions","Activity Template","Ag Project Template","Site Template","Organization Template","Contact Template","Associated Organizations","picklists","disablePickLists"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":43,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":21,"n_cols":2,"rows_kept":21,"cut":false,"hidden":false,"merged":[[3,0,3,1],[11,0,11,1],[19,0,19,1]]}
[]
[null,"Agriculture Sector Data Entry Workbook"]
[]
["Basic Information about the Workbook"]
[]
[" Overview","This workbook captures data for agriculture sector activities (projects and studies). The workbook is divided into several tabs based on the type of information being collected. Each tab is described in more detail in the \"Entering Data\" section below.\n"]
[" Linked Tabs","The first row on each worksheet indicates which fields contain values that are linked to other tabs (see \"Relationships\" below).\n\nGreen indicates that additional details for \neach entry will be collected on a separate tab.\n\nPurple indicates that the values for that column are \nbased on entries made in another tab. Entries must \nbe made to the related tab first. For example, Site \nNames entered on the \"Activity Template\" tab are \nused to create a picklist on the \"Site Template\" tab.\n\n"]
[" Field Names","The second row on each tab \ncontains the data field names.\n"]
[" Examples","The third row, shaded in grey, \nprovides an example. \n"]
[" Instructions","To help guide data entry for each \nfield, instructions will appear on \nthe screen in a light yellow box.\n"]
[" Pick Lists","Predefined pick lists make the data entry easier  \nand quicker. \n\nSome pick lists provide for a single selection, \nwhile others allow you to select multiple items. \n\nTo use the pick list, simply click on the cell.  \nThe list will pop up in a form.  Choose your \nselection(s) and press OK."]
["Entering Data"]
[null,"Not all fields will apply to all projects or studies.  Please fill in as much information as possible, but do not worry if you cannot fill in everything.\n"]
["Relationships","Several data fields in this workbook are related to each other. In other words, the same value is entered in multiple places. The diagram below illustrates the relationships.\n"]
["Activity Template","BEGIN DATA ENTRY HERE. This tab collects general information about activities, such as anaerobic digester projects or feasibility studies. This tab also captures the names of sites and organizations involved in the activity.  Additional technical details for each activity are provided on the Ag Project Template tab and more detailed information about the sites and organizations are collected on the Site Template and Organization Template tabs.\n"]
["Ag Project Template","Collects detailed technical data about anaerobic digester projects or studies.\n"]
["Site Template","Captures general information about the site at which the activity is located.\n"]
["Organization Template","Includes fields to collect information about organizations associated with the activity, such as funding organizations, developers and technology providers.\n"]
["Contact Template","Collects information for individuals associated with the activity.\n"]
["Submitting Data to GMI"]
["Send Completed File","Send the completed Excel file by email to asg@globalmethane.org.\n"]

{"sheet":"Activity Template","index":1,"n_rows":50,"n_cols":26,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
["This field links to the Ag Project Template.  Please provide additional technical data for each activity on the Ag Project Template.",null,"This field links to the Site Template. Please provide additional details for each site on the Site Template.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"This field links to the Organization Template. For each organization, please provide additional details on the Organization Template."]
["ACTIVITY NAME","COUNTRY","SITE NAME","POST ON GMI SITE?","ACTIVITY TYPE","SUB CATEGORY","STATUS","GMI FUNDED","ACTIVITY START YEAR","ACTIVITY END YEAR","REASON FOR CLOSURE","DESCRIPTION","SECTORS","USDOE FUNDING","USAID FUNDING","USDA FUNDING","USTDA FUNDING","WB FUNDING","OTHER OUTSIDE LEVERAGED FUNDING","OUTSIDE FUNDING ORGANIZATIONS","OUTSIDE LEVERAGED FUNDING NOTES","CARBON CREDITS INVOLVED?","CARBON FUND REGISTRY","PROJECT END USE TYPE","PROJECT LIFETIME YEARS","ADDITIONAL COMMENTS"]
["Ag USA Farm A Digester","USA","Farm A","Yes","Project","Project","Operational ","Yes",2009,null,null,null,"Agriculture",null,null,null,null,null,null,"Generic Financial Organization (GFO) (50000)",null,null,null,"Power Generation; On-site Heat"]
[{"$f":"IF((E4&C4&B4&I4)<>\"\",IF(E4<>\"Study\",\"Ag \",IF(I4=\"\",\"[Year]\",I4)&\" Ag \")&IF(B4=\"\",\"[Country]\",B4)&\" \"&IF(C4=\"\",\"[Site Name]\",C4)&\" Digester\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A4<>\"\",\"Agriculture\",\"\")","v":""}]
["",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A5<>\"\",\"Agriculture\",\"\")","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,null,null,""]
["",null,null,null,null,null,null,null,null,null,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":"Ag Project Template","index":2,"n_rows":3,"n_cols":90,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,1,0,16]]}
["Pick list generated from ACTIVITY NAME in the Activity Template.","Average annual animal populations (AAP) for static populations (e.g., dairy cows) may be estimated by performing an animal inventory or review of facility records.  \n\nAverage AAP for growing populations (e.g., meat animals such as beef and market swine) may be estimated using the equation:   \nAAP = Days onsite x (NAPA/365), where Days onsite = Average number of days the animal is kept at the facility, by animal type, and NAPA = Number of animals produced annually. The equation is derived from Equation 10.1 in 2006 IPCC Guidelines for National Greenhouse Gas Inventories, Volume 4, Chapter 10.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"This field links to the Organization Template. For each organization, please provide additional details on the Organization Template.",null,null,null,null,null,"Pick list generated from the Contact Template."]
["ACTIVITY NAME","DAIRY LACTATING","DAIRY DRY","DAIRY HEIFER","CATTLE","SWINE SOWS","SWINE FARROW TO WEAN","SWINE WEAN TO FEED (NURSERY)","SWINE FEED TO FINISH (GROWERS)","SWINE BOARS","SWINE TOTAL","POULTRY","POULTRY BROILERS","POULTRY LAYERS","POULTRY DUCKS","ANIMALS OTHER","OTHER ANIMAL TYPE","ANIMALS DESIGN VS ACTUAL","BASELINE WASTE STORAGE SYSTEM","MANURE COLLECTION PROCESS","PRETREATMENT TANKS","PRETREATMENT SOLIDS SEPARATION","SOLIDS SEPARATION METHOD","DAIRY MILK PROCESSING","TAPIOCA PRODUCTION","DISTILLERIES","FRUIT VEGETABLE PROCESSING","PALM OIL","SLAUGHTER HOUSES","FOOD WASTES","AG RESIDUES","FATS, OILS, GREASES","PROCESS WATER","FEED-STOCK OTHER","FEEDSTOCK OTHER TYPE","FEEDSTOCK DESIGN VS ACTUAL","DIGESTER TYPE","DIGESTER OTHER TYPE","HRT DAYS","HRT DESIGN VS ACTUAL","SRT DAYS","SRT DESIGN VS ACTUAL","DIGESTER MIX TANK","DIGESTER OPERATING VOLUME","POST TREATMENT SOLIDS SEPARATION","EFFLUENT","DIGESTER HEATING","DIGESTER MATERIALS","OTHER DIGESTER MATERIAL","OTHER GAS STORAGE TYPE","BIOGAS PRODUCTION","BIOGAS DESIGN VS ACTUAL","BIOGAS USE","BIOGAS CLEANING PROCESS","GENERATOR SET TYPE","GENERATOR SET SIZE","GENERATOR SET OUTPUT","GENSET OUTPUT DESIGN VS ACTUAL","BOILER FURNACE SIZE","BOILER SIZE DESIGN VS ACTUAL","TOTAL TCI","TCI DESIGN VS ACTUAL","TOTAL O&M","TOTAL O&M DESIGN VS ACTUAL","DIGESTER TCI","DIGESTER TCI DESIGN VS ACTUAL","DIGESTER O&M","DIGESTER O&M DESIGN VS ACTUAL","GAS USE TCI","GAS USE TCI DESIGN VS ACTUAL","GAS USE O&M","GAS USE O&M DESIGN VS ACTUAL","EFFLUENT STORAGE TCI","EFFLUENT STORAGE TCI DESIGN VS ACTUAL","EFFLUENT STORAGE O&M","EFFLUENT STORAGE O&M DESIGN VS ACTUAL","ELECTRICITY GENERATED","ELECTRICITY GENERATED DESIGN VS ACTUAL","HEAT GENERATED BTU YR","HEAT GENERATED DESIGN VS ACTUAL","UTILITY CONTRACT TYPE","UTILITY CONTRACT TYPE OTHER","ASSOCIATED DEVELOPERS AND TECHNOLOGY PROVIDERS","BASELINE FUEL REPLACED","GHG CREDITS","RECS","GRANT AMOUNT GMI","GRANT AMOUNT NON GMI","DATA COLLECTED BY","DATA COLLECTED ON"]
["Ag USA Farm A Digester",null,null,null,null,1300,5000,5000,6000,200,12500,null,null,null,null,null,null,"Actual","Storage Lagoon","Swine: flush",false,false,null,null,null,null,null,null,null,null,null,null,null,275,"Farm processing : washing","Design","Plug Flow",null,10,"Design",40,"Design",false,3000,false,"Liquid Effluent Storage: Pond","Unheated","In-ground Digester;Digester Material: Concrete;Digester Cover: Flexible",null,null,800,"Design","Electricity; Boiler/Furnace Fuel",null,"Engine",120,110,"Design",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,750000,"Design",null,null,"No Sale",null,"Digester Projects, LLC (Developer); DEUTZ Power Systems (Engine/Generator Set Manufacturer)",null,null,null,null,null,"Ms. Ann Aerobic","2011-01-01"]

{"sheet":"Site Template","index":3,"n_rows":50,"n_cols":23,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
["Pick list generated from the Activity Template.",null,null,null,null,null,null,null,"Pick list generated from the Contact Template.","Pick list generated from the Contact Template.","Pick list generated from the Organization Template.","Pick list generated from the Contact Template.","Pick list generated from the Organization Template."]
["SITE NAME","RECORD TYPE","COUNTRY","SITE TYPE","FARM TYPE","OTHER FARM TYPE","SITE STATUS","SITE DESCRIPTION","PRIMARY CONTACT ","OWNER CONTACT","OWNER (Organization)","OPERATOR CONTACT","OPERATOR (Organization)","LOCATION DETAIL","LATITUDE","LONGITUDE","STREET ADDRESS","CITY","STATE PROVINCE","DISTRICT","REGION","POSTAL CODE","SECTOR"]
["Farm A","Ag Site","USA","\"Multiple Farm/Facility\"","Swine",null,"Active",null,"Ms. Ann Aerobic",null,null,null,null,null,null,null,"123 Hog Lane","Swineville",null,null,null,null,"Agriculture"]
[null,{"$f":"IF(A4<>\"\",\"Ag Site\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A4<>\"\",\"Agriculture\",\"\")","v":""}]
[null,{"$f":"IF(A5<>\"\",\"Ag Site\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A5<>\"\",\"Agriculture\",\"\")","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,null,null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"Organization Template","index":4,"n_rows":3,"n_cols":10,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
["ORGANIZATION NAME","NAME IN NATIVE LANGUAGE","ORGANIZATION CATEGORY","WEBSITE","EXPERTISE","COUNTRY","STREET ADDRESS","CITY","STATE","POSTAL CODE"]
["Data Collectors LLC",null,"Other",null,null,"USA","123 Hog Lane","Swineville"]

{"sheet":"Contact Template","index":5,"n_rows":50,"n_cols":21,"rows_kept":50,"cut":false,"hidden":false,"merged":[[0,10,0,12],[0,0,0,1]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pick list generated from the Organization Template."]
["LAST NAME","FIRST NAME","SALUTATION","POST ON GMI SITE?","COUNTRY","MAILING STREET","MAILING CITY","MAILING STATE","MAILING POSTAL CODE","MAILING COUNTRY","PHONE","FAX","MOBILE PHONE","EMAIL","ORGANIZATION","DIVISION DEPARTMENT","TITLE","STATUS","AREAS OF INTEREST","ALTERNATE EMAIL ADDRESSES","SKYPE ID"]
["Aerobic","Ann","Ms.","Yes","USA",null,null,null,null,null,"(01) 23 4567890",null,null,null,"Data Collectors LLC",null,null,"Active","Agriculture"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($A4<>\"\",\"Active\",\"\")","v":""},{"$f":"IF($A4<>\"\",\"Agriculture\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($A5<>\"\",\"Active\",\"\")","v":""},{"$f":"IF($A5<>\"\",\"Agriculture\",\"\")","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,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":"Associated Organizations","index":6,"n_rows":4,"n_cols":4,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["Name of the activity/project that is associated with the organization\n\nShould match \"ACTIVITY NAME\" in Activity Template tab.","Name of the organization that provided outside funding. \n\nTranspose from OUTSIDE FUNDING ORGANIZATIONS field in Activity Template and\nASSOCIATED DEVELOPERS AND TECHNOLOGY PROVIDERS field in Ag Project Template.\n\n","Role of organization in project/activity\n\nFor funding organizations, will usually be \"Grant Provider\"\nFor technology providers, transpose from ASSOCIATED DEVELOPERS AND TECHNOLOGY PROVIDERS field of Ag Project Template.","Amount of funding provided by organization ($). \n\nTranspose from OUTSIDE FUNDING ORGANIZATIONS field of Activity Template.\n\n"]
["ACTIVITY NAME","OUTSIDE FUNDING ORGANIZATIONS","ORGANIZATION ROLE","FUNDING AMOUNT"]
["2010 Ag Country X Sample Farm Digester","Generic Financial Organization (GFO)","Grant Provider",50000]
["2010 Ag Country X Sample Farm Digester","DEUTZ Power Systems","Engine/Generator Set Manufacturer"]

{"sheet":"picklists","index":7,"n_rows":50,"n_cols":31,"rows_kept":50,"cut":false,"hidden":true,"merged":[]}
["plYesNo","plTrueFalse","plDesignActual","plActivityType","plSitetype","plSiteStatus","plSolidsSepMethod","plDigesterType","plDigesterHeating","plGenSetType","plUtilityContractType","plOrgCat","plSalutation","pldSubCat","pldStatus","plmSectors","plmProjectEndUseType","plmFarmType","plmBaselineWasteStorageSystem","plmManureCollectionProcess","plmEffluent","plmDigesterMaterials","plmBiogasUse","fixedRecordType","fixedAgriculture","fixedStatus",null,"Dynamic Ranges","Formula",null,"uniqueDynCountry"]
["Yes","TRUE","Design","Project","Farm Scale","Active","Gravity","Covered Lagoon","Mesophilic","Engine","Surplus Sale","Association","Ms.","------ Sub Categories for Projects -----","------ Status for Projects -----","Agriculture","Gas Sales to Pipeline","Dairy","Storage Pit: Deep Pit","Dairy Drylot: scrape or vacuum","Liquid Effluent Storage: Tank","In-ground Digester","Flared Full-time","Ag Site","Agriculture","Active",null,"dynActivityName","=OFFSET('Activity Template'!$A$4,0,0,MATCH(\"*\",'Activity Template'!$A$4:$A$50,-1),1)",null,{"$f":"IFERROR(INDEX(dynCountry, MATCH(0, FREQUENCY(IF(EXACT(dynCountry, TRANSPOSE($AE$1:AE1)), MATCH(ROW(dynCountry), ROW(dynCountry)), \"\"), MATCH(ROW(dynCountry), ROW(dynCountry))), 0)), \"\")","v":""}]
["No","FALSE","Actual","Study","Facility Scale","Inactive","Mechanical","Plug Flow","Thermophilic","Microturbine","Sell All","Contractor","Mrs.","Demonstration","Planned","Coal Mines","Electricity Generation","Swine","Storage Pit: Shallow Pit","Dairy Drylot: flush","Liquid Effluent Storage: Pond","Above-ground Digester","Electricity",null,null,null,null,"dynSiteName","=OFFSET('Activity Template'!$E$4,0,0,MATCH(\"*\",'Activity Template'!$E$4:$E$50,-1),1)",null,{"$f":"IFERROR(INDEX(dynCountry, MATCH(0, FREQUENCY(IF(EXACT(dynCountry, TRANSPOSE($AE$1:AE2)), MATCH(ROW(dynCountry), ROW(dynCountry)), \"\"), MATCH(ROW(dynCountry), ROW(dynCountry))), 0)), \"\")","v":""}]
[null,null,null,"Conference / Meeting","Multiple Farm/Facility","Potential","Other/Unknown","Complete Mix","Unheated",null,"Net Metering","Financial Institution","Mr.","Project","Construction","Landfills","Gas to LNG","Caged Layer","Storage Tank or Pond","Dairy Drylot Feedlane: scrape or vacuum","Solid Effluent Storage: Stack","Digester Material: Concrete","Cogeneration",null,null,null,null,"dynCountry","=OFFSET('Activity Template'!$F$4,0,0,MATCH(\"*\",'Activity Template'!$F$4:$F$50,-1),1)",null,{"$f":"IFERROR(INDEX(dynCountry, MATCH(0, FREQUENCY(IF(EXACT(dynCountry, TRANSPOSE($AE$1:AE3)), MATCH(ROW(dynCountry), ROW(dynCountry)), \"\"), MATCH(ROW(dynCountry), ROW(dynCountry))), 0)), \"\")","v":""}]
[null,null,null,"Conference Presentation","Centralized/Regional",null,null,"Attached Media",null,null,"No Sale","Government","Dr.","----- Sub Categories for Studies -----","Operational","Oil & Gas","Gas to CNG","Beef","Storage Lagoon","Dairy Drylot Feedlane: flush","Liquids Disposal: On-site","Digester Material: Steel ","Cook Fuel",null,null,null,null,"dynOrgs","=OFFSET('Organization Template'!$A$4,0,0,MATCH(\"*\",'Organization Template'!$A$4:$A$50,-1),1)",null,{"$f":"IFERROR(INDEX(dynCountry, MATCH(0, FREQUENCY(IF(EXACT(dynCountry, TRANSPOSE($AE$1:AE4)), MATCH(ROW(dynCountry), ROW(dynCountry)), \"\"), MATCH(ROW(dynCountry), ROW(dynCountry))), 0)), \"\")","v":""}]
[null,null,null,"Expo",null,null,null,"Fixed Dome",null,null,"Other","International","Prof.","Pre-feasibility Study","Shutdown",null,"Off-site Heat or Cook Fuel","Duck","Storage Stack","Dairy Milking Center: scrape","Liquids Disposal: Off-site","Digester Material: Other","Boiler/Furnace Fuel",null,null,null,null,"dynContacts","=OFFSET('Contact Template'!$V$4,0,0,MATCH(\"*\",'Contact Template'!$V$4:$V$50,-1),1)",null,{"$f":"IFERROR(INDEX(dynCountry, MATCH(0, FREQUENCY(IF(EXACT(dynCountry, TRANSPOSE($AE$1:AE5)), MATCH(ROW(dynCountry), ROW(dynCountry)), \"\"), MATCH(ROW(dynCountry), ROW(dynCountry))), 0)), \"\")","v":""}]
[null,null,null,"Expo Poster",null,null,null,"Bag Digester",null,null,null,"NGO","Hon.","Feasibility Study","Cancelled",null,"Industrial Use","Broiler",null,"Dairy Milking Center: flush","Solids Disposal: On-site","Digester Cover: Rigid","Boiler/Furnace Back-Up Only",null,null,null,null,"dynUniqueDynCountry","=IF(picklists!$AE$2=\"\",OFFSET(picklists!$AE$3,0,0,MATCH(\"*\",picklists!$AE$3:$AE$50,-1),1),OFFSET(picklists!$AE$2,0,0,MATCH(\"*\",picklists!$AE$2:$AE$50,-1),1))",null,{"$f":"IFERROR(INDEX(dynCountry, MATCH(0, FREQUENCY(IF(EXACT(dynCountry, TRANSPOSE($AE$1:AE6)), MATCH(ROW(dynCountry), ROW(dynCountry)), \"\"), MATCH(ROW(dynCountry), ROW(dynCountry))), 0)), \"\")","v":""}]
[null,null,null,"Inventory/Assessment",null,null,null,"Floating Cover",null,null,null,"Private Sector",null,"Measurement Study","Unknown",null,"Flaring Assigned","Dairy Plant (milk processing)",null,"Dairy Freestall Barn: scrape or vacuum","Solids Disposal: Off-site","Digester Cover: Flexible","Refrigeration",null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(dynCountry, MATCH(0, FREQUENCY(IF(EXACT(dynCountry, TRANSPOSE($AE$1:AE7)), MATCH(ROW(dynCountry), ROW(dynCountry)), \"\"), MATCH(ROW(dynCountry), ROW(dynCountry))), 0)), \"\")","v":""}]
[null,null,null,"Site Visit / Study Tour",null,null,null,"Other",null,null,null,"Research",null,"Other Study","----- Status for Other Activities -----",null,"Back-up Flare","Tapioca Production",null,"Dairy Freestall Barn: flush",null,"Digester Cover: Modular Lagoon Cover","Pipeline Gas",null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(dynCountry, MATCH(0, FREQUENCY(IF(EXACT(dynCountry, TRANSPOSE($AE$1:AE8)), MATCH(ROW(dynCountry), ROW(dynCountry)), \"\"), MATCH(ROW(dynCountry), ROW(dynCountry))), 0)), \"\")","v":""}]
[null,null,null,"Tech Demonstration",null,null,null,null,null,null,null,"University",null,null,"Completed",null,"Hot Water","Distilleries",null,"Swine: flush",null,"Other Gas Storage","Methanol",null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(dynCountry, MATCH(0, FREQUENCY(IF(EXACT(dynCountry, TRANSPOSE($AE$1:AE9)), MATCH(ROW(dynCountry), ROW(dynCountry)), \"\"), MATCH(ROW(dynCountry), ROW(dynCountry))), 0)), \"\")","v":""}]
[null,null,null,"Technical Assistance",null,null,null,null,null,null,null,"Other",null,null,"On-going",null,"On-site Heat","Fruit and Vegetable Processing",null,"Swine: pull plug pit or pit recharge",null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(dynCountry, MATCH(0, FREQUENCY(IF(EXACT(dynCountry, TRANSPOSE($AE$1:AE10)), MATCH(ROW(dynCountry), ROW(dynCountry)), \"\"), MATCH(ROW(dynCountry), ROW(dynCountry))), 0)), \"\")","v":""}]
[null,null,null,"Tools & Outreach",null,null,null,null,null,null,null,null,null,null,"Not Started",null,"On-site Cook Fuel","Palm Oil",null,"Swine: deep pit",null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(dynCountry, MATCH(0, FREQUENCY(IF(EXACT(dynCountry, TRANSPOSE($AE$1:AE11)), MATCH(ROW(dynCountry), ROW(dynCountry)), \"\"), MATCH(ROW(dynCountry), ROW(dynCountry))), 0)), \"\")","v":""}]
[null,null,null,"Workshop/Training",null,null,null,null,null,null,null,null,null,null,null,null,"Other","Slaughterhouses",null,"Poultry: flush",null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(dynCountry, MATCH(0, FREQUENCY(IF(EXACT(dynCountry, TRANSPOSE($AE$1:AE12)), MATCH(ROW(dynCountry), ROW(dynCountry)), \"\"), MATCH(ROW(dynCountry), ROW(dynCountry))), 0)), \"\")","v":""}]
[null,null,null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,null,"Other",null,"Poultry: pull plug pit or pit recharge",null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(dynCountry, MATCH(0, FREQUENCY(IF(EXACT(dynCountry, TRANSPOSE($AE$1:AE13)), MATCH(ROW(dynCountry), ROW(dynCountry)), \"\"), MATCH(ROW(dynCountry), ROW(dynCountry))), 0)), \"\")","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,{"$f":"IFERROR(INDEX(dynCountry, MATCH(0, FREQUENCY(IF(EXACT(dynCountry, TRANSPOSE($AE$1:AE14)), MATCH(ROW(dynCountry), ROW(dynCountry)), \"\"), MATCH(ROW(dynCountry), ROW(dynCountry))), 0)), \"\")","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,{"$f":"IFERROR(INDEX(dynCountry, MATCH(0, FREQUENCY(IF(EXACT(dynCountry, TRANSPOSE($AE$1:AE15)), MATCH(ROW(dynCountry), ROW(dynCountry)), \"\"), MATCH(ROW(dynCountry), ROW(dynCountry))), 0)), \"\")","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,{"$f":"IFERROR(INDEX(dynCountry, MATCH(0, FREQUENCY(IF(EXACT(dynCountry, TRANSPOSE($AE$1:AE16)), MATCH(ROW(dynCountry), ROW(dynCountry)), \"\"), MATCH(ROW(dynCountry), ROW(dynCountry))), 0)), \"\")","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,{"$f":"IFERROR(INDEX(dynCountry, MATCH(0, FREQUENCY(IF(EXACT(dynCountry, TRANSPOSE($AE$1:AE17)), MATCH(ROW(dynCountry), ROW(dynCountry)), \"\"), MATCH(ROW(dynCountry), ROW(dynCountry))), 0)), \"\")","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,{"$f":"IFERROR(INDEX(dynCountry, MATCH(0, FREQUENCY(IF(EXACT(dynCountry, TRANSPOSE($AE$1:AE18)), MATCH(ROW(dynCountry), ROW(dynCountry)), \"\"), MATCH(ROW(dynCountry), ROW(dynCountry))), 0)), \"\")","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,{"$f":"IFERROR(INDEX(dynCountry, MATCH(0, FREQUENCY(IF(EXACT(dynCountry, TRANSPOSE($AE$1:AE19)), MATCH(ROW(dynCountry), ROW(dynCountry)), \"\"), MATCH(ROW(dynCountry), ROW(dynCountry))), 0)), \"\")","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,{"$f":"IFERROR(INDEX(dynCountry, MATCH(0, FREQUENCY(IF(EXACT(dynCountry, TRANSPOSE($AE$1:AE20)), MATCH(ROW(dynCountry), ROW(dynCountry)), \"\"), MATCH(ROW(dynCountry), ROW(dynCountry))), 0)), \"\")","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,{"$f":"IFERROR(INDEX(dynCountry, MATCH(0, FREQUENCY(IF(EXACT(dynCountry, TRANSPOSE($AE$1:AE21)), MATCH(ROW(dynCountry), ROW(dynCountry)), \"\"), MATCH(ROW(dynCountry), ROW(dynCountry))), 0)), \"\")","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,{"$f":"IFERROR(INDEX(dynCountry, MATCH(0, FREQUENCY(IF(EXACT(dynCountry, TRANSPOSE($AE$1:AE22)), MATCH(ROW(dynCountry), ROW(dynCountry)), \"\"), MATCH(ROW(dynCountry), ROW(dynCountry))), 0)), \"\")","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,{"$f":"IFERROR(INDEX(dynCountry, MATCH(0, FREQUENCY(IF(EXACT(dynCountry, TRANSPOSE($AE$1:AE23)), MATCH(ROW(dynCountry), ROW(dynCountry)), \"\"), MATCH(ROW(dynCountry), ROW(dynCountry))), 0)), \"\")","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,{"$f":"IFERROR(INDEX(dynCountry, MATCH(0, FREQUENCY(IF(EXACT(dynCountry, TRANSPOSE($AE$1:AE24)), MATCH(ROW(dynCountry), ROW(dynCountry)), \"\"), MATCH(ROW(dynCountry), ROW(dynCountry))), 0)), \"\")","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,{"$f":"IFERROR(INDEX(dynCountry, MATCH(0, FREQUENCY(IF(EXACT(dynCountry, TRANSPOSE($AE$1:AE25)), MATCH(ROW(dynCountry), ROW(dynCountry)), \"\"), MATCH(ROW(dynCountry), ROW(dynCountry))), 0)), \"\")","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,{"$f":"IFERROR(INDEX(dynCountry, MATCH(0, FREQUENCY(IF(EXACT(dynCountry, TRANSPOSE($AE$1:AE26)), MATCH(ROW(dynCountry), ROW(dynCountry)), \"\"), MATCH(ROW(dynCountry), ROW(dynCountry))), 0)), \"\")","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,{"$f":"IFERROR(INDEX(dynCountry, MATCH(0, FREQUENCY(IF(EXACT(dynCountry, TRANSPOSE($AE$1:AE27)), MATCH(ROW(dynCountry), ROW(dynCountry)), \"\"), MATCH(ROW(dynCountry), ROW(dynCountry))), 0)), \"\")","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,{"$f":"IFERROR(INDEX(dynCountry, MATCH(0, FREQUENCY(IF(EXACT(dynCountry, TRANSPOSE($AE$1:AE28)), MATCH(ROW(dynCountry), ROW(dynCountry)), \"\"), MATCH(ROW(dynCountry), ROW(dynCountry))), 0)), \"\")","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,{"$f":"IFERROR(INDEX(dynCountry, MATCH(0, FREQUENCY(IF(EXACT(dynCountry, TRANSPOSE($AE$1:AE29)), MATCH(ROW(dynCountry), ROW(dynCountry)), \"\"), MATCH(ROW(dynCountry), ROW(dynCountry))), 0)), \"\")","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,{"$f":"IFERROR(INDEX(dynCountry, MATCH(0, FREQUENCY(IF(EXACT(dynCountry, TRANSPOSE($AE$1:AE30)), MATCH(ROW(dynCountry), ROW(dynCountry)), \"\"), MATCH(ROW(dynCountry), ROW(dynCountry))), 0)), \"\")","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,{"$f":"IFERROR(INDEX(dynCountry, MATCH(0, FREQUENCY(IF(EXACT(dynCountry, TRANSPOSE($AE$1:AE31)), MATCH(ROW(dynCountry), ROW(dynCountry)), \"\"), MATCH(ROW(dynCountry), ROW(dynCountry))), 0)), \"\")","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,{"$f":"IFERROR(INDEX(dynCountry, MATCH(0, FREQUENCY(IF(EXACT(dynCountry, TRANSPOSE($AE$1:AE32)), MATCH(ROW(dynCountry), ROW(dynCountry)), \"\"), MATCH(ROW(dynCountry), ROW(dynCountry))), 0)), \"\")","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,{"$f":"IFERROR(INDEX(dynCountry, MATCH(0, FREQUENCY(IF(EXACT(dynCountry, TRANSPOSE($AE$1:AE33)), MATCH(ROW(dynCountry), ROW(dynCountry)), \"\"), MATCH(ROW(dynCountry), ROW(dynCountry))), 0)), \"\")","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,{"$f":"IFERROR(INDEX(dynCountry, MATCH(0, FREQUENCY(IF(EXACT(dynCountry, TRANSPOSE($AE$1:AE34)), MATCH(ROW(dynCountry), ROW(dynCountry)), \"\"), MATCH(ROW(dynCountry), ROW(dynCountry))), 0)), \"\")","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,{"$f":"IFERROR(INDEX(dynCountry, MATCH(0, FREQUENCY(IF(EXACT(dynCountry, TRANSPOSE($AE$1:AE35)), MATCH(ROW(dynCountry), ROW(dynCountry)), \"\"), MATCH(ROW(dynCountry), ROW(dynCountry))), 0)), \"\")","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,{"$f":"IFERROR(INDEX(dynCountry, MATCH(0, FREQUENCY(IF(EXACT(dynCountry, TRANSPOSE($AE$1:AE36)), MATCH(ROW(dynCountry), ROW(dynCountry)), \"\"), MATCH(ROW(dynCountry), ROW(dynCountry))), 0)), \"\")","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,{"$f":"IFERROR(INDEX(dynCountry, MATCH(0, FREQUENCY(IF(EXACT(dynCountry, TRANSPOSE($AE$1:AE37)), MATCH(ROW(dynCountry), ROW(dynCountry)), \"\"), MATCH(ROW(dynCountry), ROW(dynCountry))), 0)), \"\")","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,{"$f":"IFERROR(INDEX(dynCountry, MATCH(0, FREQUENCY(IF(EXACT(dynCountry, TRANSPOSE($AE$1:AE38)), MATCH(ROW(dynCountry), ROW(dynCountry)), \"\"), MATCH(ROW(dynCountry), ROW(dynCountry))), 0)), \"\")","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,{"$f":"IFERROR(INDEX(dynCountry, MATCH(0, FREQUENCY(IF(EXACT(dynCountry, TRANSPOSE($AE$1:AE39)), MATCH(ROW(dynCountry), ROW(dynCountry)), \"\"), MATCH(ROW(dynCountry), ROW(dynCountry))), 0)), \"\")","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,{"$f":"IFERROR(INDEX(dynCountry, MATCH(0, FREQUENCY(IF(EXACT(dynCountry, TRANSPOSE($AE$1:AE40)), MATCH(ROW(dynCountry), ROW(dynCountry)), \"\"), MATCH(ROW(dynCountry), ROW(dynCountry))), 0)), \"\")","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,{"$f":"IFERROR(INDEX(dynCountry, MATCH(0, FREQUENCY(IF(EXACT(dynCountry, TRANSPOSE($AE$1:AE41)), MATCH(ROW(dynCountry), ROW(dynCountry)), \"\"), MATCH(ROW(dynCountry), ROW(dynCountry))), 0)), \"\")","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,{"$f":"IFERROR(INDEX(dynCountry, MATCH(0, FREQUENCY(IF(EXACT(dynCountry, TRANSPOSE($AE$1:AE42)), MATCH(ROW(dynCountry), ROW(dynCountry)), \"\"), MATCH(ROW(dynCountry), ROW(dynCountry))), 0)), \"\")","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,{"$f":"IFERROR(INDEX(dynCountry, MATCH(0, FREQUENCY(IF(EXACT(dynCountry, TRANSPOSE($AE$1:AE43)), MATCH(ROW(dynCountry), ROW(dynCountry)), \"\"), MATCH(ROW(dynCountry), ROW(dynCountry))), 0)), \"\")","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,{"$f":"IFERROR(INDEX(dynCountry, MATCH(0, FREQUENCY(IF(EXACT(dynCountry, TRANSPOSE($AE$1:AE44)), MATCH(ROW(dynCountry), ROW(dynCountry)), \"\"), MATCH(ROW(dynCountry), ROW(dynCountry))), 0)), \"\")","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,{"$f":"IFERROR(INDEX(dynCountry, MATCH(0, FREQUENCY(IF(EXACT(dynCountry, TRANSPOSE($AE$1:AE45)), MATCH(ROW(dynCountry), ROW(dynCountry)), \"\"), MATCH(ROW(dynCountry), ROW(dynCountry))), 0)), \"\")","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,{"$f":"IFERROR(INDEX(dynCountry, MATCH(0, FREQUENCY(IF(EXACT(dynCountry, TRANSPOSE($AE$1:AE46)), MATCH(ROW(dynCountry), ROW(dynCountry)), \"\"), MATCH(ROW(dynCountry), ROW(dynCountry))), 0)), \"\")","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,{"$f":"IFERROR(INDEX(dynCountry, MATCH(0, FREQUENCY(IF(EXACT(dynCountry, TRANSPOSE($AE$1:AE47)), MATCH(ROW(dynCountry), ROW(dynCountry)), \"\"), MATCH(ROW(dynCountry), ROW(dynCountry))), 0)), \"\")","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,{"$f":"IFERROR(INDEX(dynCountry, MATCH(0, FREQUENCY(IF(EXACT(dynCountry, TRANSPOSE($AE$1:AE48)), MATCH(ROW(dynCountry), ROW(dynCountry)), \"\"), MATCH(ROW(dynCountry), ROW(dynCountry))), 0)), \"\")","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,{"$f":"IFERROR(INDEX(dynCountry, MATCH(0, FREQUENCY(IF(EXACT(dynCountry, TRANSPOSE($AE$1:AE49)), MATCH(ROW(dynCountry), ROW(dynCountry)), \"\"), MATCH(ROW(dynCountry), ROW(dynCountry))), 0)), \"\")","v":""}]

{"sheet":"disablePickLists","index":8,"n_rows":19,"n_cols":2,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
["To disable the picklists on a worksheet, enter any character into the designated cell. If the designated cell is not empty, the pickoists will be inactive."]
[]
["Worksheet","Disable Cell"]
["Activity Template","AB1"]
["Ag Project Template","CM1"]
["Site Template","X1"]
["Organization Template","K1"]
["Contact Template","V1"]
[]
["To change the disable cell for any of the worksheets, edit the Visual Basic code."]
["From the Developer tab in the menu ribbon, click \"Visual Basic\" and select the code for the relevant worksheet.  For example:"]
[]
["VBAProject (GMI_AgSector_Data_Entry_Workbook.xlsm)"]
["Microsoft Excel Objects"]
["Sheet2 (Activity Template)"]
[]
["On or about Line 18, edit the cell reference (shown in red below) to the desitred disable cell."]
[]
["If Me.Range(\"X1\").Value <> \"\" Then GoTo exitHandler"]