{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["wksRules","Services and Fees USD","Order Form","Order Form (Preferred Partner)","Order Form (Ad-Hoc)","QueryResult","Country Selection","BG Use Only","Subscription Agreement","Survey Access","Data Collection Contacts","SO Notification","ChangeLog","Invoices"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":3,"defined_names":114,"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":"wksRules","index":0,"n_rows":220,"n_cols":11,"rows_kept":220,"cut":false,"hidden":true,"merged":[[20,5,20,8],[113,5,113,8],[135,5,135,8],[136,5,136,8],[45,5,45,8],[23,5,23,8],[134,5,134,8],[68,5,68,8],[95,5,95,8],[100,5,100,8],[73,5,73,8],[124,5,124,8],[89,5,89,8],[101,5,101,8],[119,5,119,8],[22,5,22,8],[156,5,156,8],[132,5,132,8],[138,5,138,8],[152,5,152,8],[146,5,146,8],[148,5,148,8],[149,5,149,8],[150,5,150,8],[19,5,19,8],[34,5,34,8],[215,5,215,8],[201,5,201,8],[172,5,172,8],[179,5,179,8],[185,5,185,8],[202,5,202,8],[199,5,199,8],[181,5,181,8],[157,5,157,8],[164,5,164,8],[171,5,171,8],[75,5,75,8],[163,5,163,8],[170,5,170,8],[219,5,219,8],[8,5,8,14],[112,5,112,8],[115,5,115,8],[71,5,71,8],[178,5,178,8],[184,5,184,8],[198,5,198,8],[182,5,182,8],[9,5,9,6],[13,5,13,8],[96,5,96,8],[123,5,123,8],[111,5,111,8],[70,5,70,8],[109,5,109,8]]}
[]
[null,null,"2011 Global Order Form Calculation Descriptions & Settings"]
[null,null,"Cells highlighted in yellow can be modified as needed"]
[]
[null,null,null,"Named Formula"]
[]
[null,"Order Forms"]
[]
[null,null,"Order Form Sheet Name",null,null,"Global Order Form Svys 1-2"]
[null,null,"Value used to indicate an order","ORDER",null,"x",null,null,null,null,"Case insensitive value required for an item on the order forms to be identified by the formulas."]
[]
[null,"Discounts"]
[]
[null,null,"Text displayed if product is free","CASH_PREV_FREE_TEXT",null," Complimentary"]
[]
[null,null,"TCM 3 Year Commitment"]
[]
[null,null,"Range Address","TCM_COMMIT_RNG",null,{"$f":"CONCATENATE(ADDRESS(ROW(TCM_COMMIT_RNG),COLUMN(TCM_COMMIT_RNG),,,$F$9),\":\",ADDRESS(ROW(TCM_COMMIT_RNG)+ROWS(TCM_COMMIT_RNG)-1,COLUMN(TCM_COMMIT_RNG)))","v":{"$error":"#NAME?"}}]
[]
[null,null,"Discount %","TCM_COMMIT_BASE_DISCOUNT",null,0.1]
[null,null,"Current Discount %","TCM_COMMIT_CURRENT_DISCOUNT",null,{"$f":"IF(TCM_COMMIT_ORDERS>=TCM_COMMIT_MARKETS,TCM_COMMIT_BASE_DISCOUNT,0)","v":{"$error":"#NAME?"}}]
[]
[null,null,"Market Threshold","TCM_COMMIT_MARKETS",null,10]
[null,null,"Total Current Commitments","TCM_COMMIT_ORDERS",null,{"$f":"COUNTIF(TCM_COMMIT_RNG,\"<>\")","v":{"$error":"#NAME?"}}]
[]
[null,null,"Discount Details"]
[null,null,"Eligibility Requirement",null,null,"Market Threshold must be met"]
[null,null,"Who gets the discount",null,null,"All TCM Markets"]
[null,null,"Product(s) discounted",null,null,"All TCM products except TCM Light & All TCM Caps (See TCM Cash Online and TCM Gen Ind Cash & Prev sections)"]
[null,null,"How the discount is applied",null,null,"Discount is added to the TCM + VCM Bundle discount and applied to the Fee (See \"Fee\" column)"]
[null,null,"How the discount is displayed",null,null,"N/A"]
[]
[null,null,"VCM 3 Year Commitment"]
[]
[null,null,"Discount %","VCM_COMMIT_BASE_DISCOUNT",null,0.1]
[]
[null,null,"Discount Details"]
[null,null,"Eligibility Requirement",null,null,"VCM 3 Year Commitment"]
[null,null,"Who gets the discount",null,null,"Market(s) meeting the eligibility requirements"]
[null,null,"Product(s) discounted",null,null,"VCM Survey"]
[null,null,"How the discount is applied",null,null,"VCM Survey price is reduced"]
[null,null,"How the discount is displayed",null,null,"N/A"]
[]
[null,null,"TCM + VCM Bundle"]
[]
[null,null,"Discount %","TCM_BUNDLE_BASE_DISCOUNT",null,0.05]
[]
[null,null,"Discount Details"]
[null,null,"Eligibility Requirements",null,null,"1) TCM 3 Year Commitment must be active (ie Market Threshold being met)"]
[null,null,null,null,null,"2) TCM 3 Year Commitment"]
[null,null,null,null,null,"3) VCM 3 Year Commitment"]
[null,null,"Who gets the discount",null,null,"Market(s) meeting the eligibility requirements"]
[null,null,"Product(s) discounted",null,null,"All TCM products except TCM Light"]
[null,null,"How the discount is applied",null,null,"Discount is added to the TCM 3 Year Commitment discount and applied to the Total Fee (See \"Total Fee\" column)"]
[null,null,"How the discount is displayed",null,null,"N/A"]
[]
[null,null,"TCM Gen Ind Cash & Prev"]
[null,null,"See TCM Gen Ind Cash & Prev section"]
[]
[null,null,"Salary Increase Survey (SIS)"]
[null,null,"See Salary Increase Survey (SIS) section"]
[]
[null,"TCM Gen Ind Cash & Prev"]
[]
[null,null,"Pay Orders"]
[]
[null,null,"Range Address","CASH_PREV_PAY_RNG",null,{"$f":"CONCATENATE(ADDRESS(ROW(CASH_PREV_PAY_RNG),COLUMN(CASH_PREV_PAY_RNG),,,$F$9),\":\",ADDRESS(ROW(CASH_PREV_PAY_RNG)+ROWS(CASH_PREV_PAY_RNG)-1,COLUMN(CASH_PREV_PAY_RNG)))","v":{"$error":"#NAME?"}}]
[]
[null,null,"Base Cap","CASH_PREV_BASE_CAP",null,25600]
[]
[null,null,"Base Price","CASH_PREV_BASE_PRICE",null,1600]
[null,null,"Adjusted Price","CASH_PREV_ADJUSTED_PRICE",null,{"$f":"IF(CASH_PREV_BASE_PRICE*CASH_PREV_PAY_ORDERS>CASH_PREV_BASE_CAP, CASH_PREV_BASE_CAP/CASH_PREV_PAY_ORDERS, CASH_PREV_BASE_PRICE)","v":{"$error":"#NAME?"}},null,null,null,null,"Once the Base Cap is exceeded the individual price adjusts so that all ordering markets that are not receiving a free report,"]
[null,null,null,null,null,null,null,null,null,null,"pay the same amount for the product"]
[null,null,"Current Price",null,null,"MKT",null,null,null,null,"Determined at the individual market level."]
[]
[null,null,"Total Pay Orders","CASH_PREV_PAY_ORDERS",null,{"$f":"SUM((CASH_PREV_PAY_RNG<>\"\")*(CASH_PREV_FREE_RNG=\"\"))","v":{"$error":"#NAME?"}}]
[]
[null,null,"Discount Details"]
[null,null,"Eligibility Requirement",null,null,"Market orders a TCM Cash Online report or a TCM Gen Ind Cash & LTI report."]
[null,null,null,null,null,"For GPCG clients, market orders TCM Cash Online, TCM Gen Ind Cash & LTI, TCM GPCG Cash & Prev. or TCM GPCG Cash & LTI"]
[null,null,"Who gets the discount",null,null,"Only the market(s) meeting the eligibility requirement"]
[null,null,"Product(s) discounted",null,null,"TCM Gen Ind Cash & Prev report"]
[null,null,"How the discount is applied",null,null,"TCM Gen Ind Cash & Prev report is reduced by 100%"]
[null,null,"How the discount is displayed",null,null,"When the Eligibility Requirement is met the space to the right of the Gen Ind Cash & Prev report will read \"Complimentary\""]
[]
[null,null,"Complimentary Orders"]
[]
[null,null,"Range Address",null,null,{"$f":"CONCATENATE(ADDRESS(ROW(CASH_PREV_FREE_RNG),COLUMN(CASH_PREV_FREE_RNG),,,$F$9),\":\",ADDRESS(ROW(CASH_PREV_FREE_RNG)+ROWS(CASH_PREV_FREE_RNG)-1,COLUMN(CASH_PREV_FREE_RNG)))","v":{"$error":"#NAME?"}}]
[]
[null,null,"Total Complimentary Orders","CASH_PREV_FREE_ORDERS",null,{"$f":"COUNTIF(CASH_PREV_FREE_RNG,FREE_TEXT)","v":{"$error":"#NAME?"}}]
[]
[null,"TCM Light"]
[]
[null,null,"Standard"]
[]
[null,null,"Base Price","TCM_LIGHT_BASE_PRICE",null,900,null,null,null,null,"No discounts or caps apply to this product"]
[null,null,"Current Price",null,null,"MKT",null,null,null,null,"Varies by market.  Becomes the Base Price for markets that place a TCM Light Report order unless the market falls into a special"]
[null,null,null,null,null,null,null,null,null,null,"category as indicated by its market code (see below) "]
[null,null,"Special1"]
[]
[null,null,"Base Price","TCM_LIGHT_SPECIAL1_BASE_PRICE",null,2250]
[null,null,"Market Code","TCM_LIGHT_SPECIAL1_CODE",null,"M31",null,null,null,null,"This price applies to New Zealand only"]
[]
[null,"TCM Cash Online"]
[]
[null,null,"Single Comparator Group"]
[]
[null,null,"Range Address","CASH_ONLINE_RNG",null,{"$f":"CONCATENATE(ADDRESS(ROW(CASH_ONLINE_RNG),COLUMN(CASH_ONLINE_RNG),,,$F$9),\":\",ADDRESS(ROW(CASH_ONLINE_RNG)+ROWS(CASH_ONLINE_RNG)-1,COLUMN(CASH_ONLINE_RNG)))","v":{"$error":"#NAME?"}}]
[]
[null,null,"Base Cap","CASH_ONLINE_BASE_CAP",null,38400]
[]
[null,null,"Base Price","CASH_ONLINE_BASE_PRICE",null,2400]
[null,null,"Adjusted Price","CASH_ONLINE_ADJUSTED_PRICE",null,{"$f":"IF(CASH_ONLINE_BASE_PRICE*CASH_ONLINE_ORDERS>CASH_ONLINE_BASE_CAP,CASH_ONLINE_BASE_CAP/CASH_ONLINE_ORDERS,CASH_ONLINE_BASE_PRICE)","v":{"$error":"#NAME?"}},null,null,null,null,"Once the Base Cap is exceeded the individual price adjusts so that all ordering markets pay the same amount for the product,"]
[null,null,"Current Price",null,null,"MKT",null,null,null,null,"Determined at the individual market level."]
[]
[null,null,"Total Current Orders","CASH_ONLINE_ORDERS",null,{"$f":"COUNTIF(CASH_ONLINE_RNG,\"<>\")","v":{"$error":"#NAME?"}}]
[]
[null,null,"Each additional Comparator Group"]
[]
[null,null,"Base Price","CASH_ONLINE_ADDITIONAL_GROUP",null,250,null,null,null,null,"This is not currently used in any calculations"]
[]
[null,"TCM Gen Ind Cash & LTI"]
[]
[null,null,"Base Price","CASH_LTI_BASE_PRICE",null,4500]
[null,null,"Current Price",null,null,"MKT",null,null,null,null,"Determined at the individual market level."]
[]
[null," TCM GPCG Cash & Prev."]
[]
[null,null,"Standard"]
[]
[null,null,"Range Address","GPCG_CASH_PREV_RNG",null,{"$f":"CONCATENATE(ADDRESS(ROW(GPCG_CASH_PREV_RNG),COLUMN(GPCG_CASH_PREV_RNG),,,$F$9),\":\",ADDRESS(ROW(GPCG_CASH_PREV_RNG)+ROWS(GPCG_CASH_PREV_RNG)-1,COLUMN(GPCG_CASH_PREV_RNG)))","v":{"$error":"#NAME?"}}]
[]
[null,null,"Base Cap","GPCG_CASH_PREV_BASE_CAP",null,32400]
[]
[null,null,"Base Price","GPCG_CASH_PREV_BASE_PRICE",null,1800]
[null,null,"Adjusted Price","GPCG_CASH_PREV_ADJUSTED_PRICE",null,{"$f":"IF(GPCG_CASH_PREV_BASE_PRICE * GPCG_CASH_PREV_ORDERS > GPCG_CASH_PREV_BASE_CAP, GPCG_CASH_PREV_BASE_CAP / GPCG_CASH_PREV_ORDERS, GPCG_CASH_PREV_BASE_PRICE)","v":{"$error":"#NAME?"}},null,null,null,null,"Once the Base Cap is exceeded the individual price adjusts so that all ordering markets pay the same amount for the product,"]
[null,null,"Current Price",null,null,"MKT",null,null,null,null,"Determined at the individual market level."]
[]
[null,null,"Total Current Orders","GPCG_CASH_PREV_ORDERS",null,{"$f":"COUNTIF(GPCG_CASH_PREV_RNG,\"<>\")","v":{"$error":"#NAME?"}}]
[]
[null," TCM GPCG Cash & LTI"]
[]
[null,null,"Standard"]
[]
[null,null,"Range Address","GPCG_CASH_LTI_RNG",null,{"$f":"CONCATENATE(ADDRESS(ROW(GPCG_CASH_LTI_RNG),COLUMN(GPCG_CASH_LTI_RNG),,,$F$9),\":\",ADDRESS(ROW(GPCG_CASH_LTI_RNG)+ROWS(GPCG_CASH_LTI_RNG)-1,COLUMN(GPCG_CASH_LTI_RNG)))","v":{"$error":"#NAME?"}}]
[]
[null,null,"Base Cap","GPCG_CASH_LTI_BASE_CAP",null,73800]
[]
[null,null,"Base Price","GPCG_CASH_LTI_BASE_PRICE",null,4100]
[null,null,"Adjusted Price","GPCG_CASH_LTI_ADJUSTED_PRICE",null,{"$f":"IF(GPCG_CASH_LTI_BASE_PRICE * GPCG_CASH_LTI_ORDERS > GPCG_CASH_LTI_BASE_CAP, GPCG_CASH_LTI_BASE_CAP / GPCG_CASH_LTI_ORDERS, GPCG_CASH_LTI_BASE_PRICE)","v":{"$error":"#NAME?"}},null,null,null,null,"Once the Base Cap is exceeded the individual price adjusts so that all ordering markets pay the same amount for the product,"]
[null,null,"Current Price",null,null,"MKT",null,null,null,null,"Determined at the individual market level."]
[]
[null,null,"Total Current Orders","GPCG_CASH_LTI_ORDERS",null,{"$f":"COUNTIF(GPCG_CASH_LTI_RNG,\"<>\")","v":{"$error":"#NAME?"}}]
[]
[null,"eGuides"]
[]
[null,null,"Base Cap","EGUIDE_BASE_CAP",null,5100]
[null,null,"Cap is met or exceeded","EGUIDE_CAP_MET",null,{"$f":" OR(#REF!=ORDER,( EGUIDE_MARKET_BASE_PRICE * EGUIDE_MARKET_ORDERS ) >= EGUIDE_BASE_CAP)","v":{"$error":"#REF!"}}]
[null,null,"Special Display Rule",null,null,null,null,null,null,null,"The Global Country eGuide box and all Market Country eGuide boxes receive green shading to indicate their inclusion if"]
[null,null,null,null,null,null,null,null,null,null,"1) Global Country eGuides are ordered or;"]
[null,null,null,null,null,null,null,null,null,null,"2) The Base Cap is met"]
[null,null,"Global"]
[]
[null,null,"Base Price","EGUIDE_GLOBAL_BASE_PRICE",null,5100]
[null,null,"Current Price","EGUIDE_GLOBAL_CURRENT_PRICE",null,{"$f":" EGUIDE_CAP_MET * EGUIDE_GLOBAL_BASE_PRICE","v":{"$error":"#NAME?"}},null,null,null,null,"This becomes the Base Price if the Global Country eGuides are ordered or;"]
[null,null,null,null,null,null,null,null,null,null,"the Base Cap price if the Base Cap is met through individual market orders"]
[null,null,"Market"]
[]
[null,null,"Range Address","EGUIDE_RNG",null,{"$f":"CONCATENATE(ADDRESS(ROW(EGUIDE_RNG),COLUMN(EGUIDE_RNG),,,$F$9),\":\",ADDRESS(ROW(EGUIDE_RNG)+ROWS(EGUIDE_RNG)-1,COLUMN(EGUIDE_RNG)))","v":{"$error":"#NAME?"}}]
[]
[null,null,"Base Price","EGUIDE_MARKET_BASE_PRICE",null,1000]
[null,null,"Total Market Orders","EGUIDE_MARKET_ORDERS",null,{"$f":"COUNTIF(EGUIDE_RNG,\"<>\")","v":{"$error":"#NAME?"}}]
[null,null,"Total Market Cost",null,null,{"$f":" ( NOT(EGUIDE_CAP_MET) ) * EGUIDE_MARKET_ORDERS * EGUIDE_MARKET_BASE_PRICE","v":{"$error":"#NAME?"}},null,null,null,null,"Once the Base Cap is met, this becomes zero and the price is recorded in the Global Country eGuide line item"]
[]
[null,"Salary Increase Survey (SIS)"]
[]
[null,null,"Global"]
[]
[null,null,"Base Price","SIS_GLOBAL_BASE_PRICE",null,300]
[null,null,"Current Price","SIS_GLOBAL_CURRENT_PRICE",null,{"$f":" IF(#REF!=ORDER,SIS_GLOBAL_BASE_PRICE * (1 - SIS_COMMIT_CURRENT_DISCOUNT),0)","v":{"$error":"#REF!"}}]
[]
[null,null,"Market Threshold","SIS_COMMIT_MARKETS",null,10]
[null,null,"Total Current Commitments","SIS_COMMIT_ORDERS",null,{"$f":"COUNTIF(SIS_COMMIT_RNG,\"<>\")","v":{"$error":"#NAME?"}}]
[]
[null,null,"Base Discount %","SIS_COMMIT_BASE_DISCOUNT",null,1]
[null,null,"Current Discount %","SIS_COMMIT_CURRENT_DISCOUNT",null,{"$f":"IF(SIS_COMMIT_ORDERS>=SIS_COMMIT_MARKETS,SIS_COMMIT_BASE_DISCOUNT,0)","v":{"$error":"#NAME?"}}]
[]
[null,null,"Discount Details"]
[null,null,"Eligibility Requirement",null,null,"Market Threshold must be met"]
[null,null,"Who gets the discount",null,null,"N/A"]
[null,null,"Product(s) discounted",null,null,"Global SIS Report Purchase"]
[null,null,"How the discount is applied",null,null,"Global SIS Report Purchase Price is reduced by the Current Discount % (100%)"]
[null,null,"How the discount is displayed",null,null,"When the Market Threshold is met the space to the right of the Global SIS Report Purchase will read \"Complimentary\""]
[]
[null,null,"Market"]
[]
[null,null,"Range Address","SIS_COMMIT_RNG",null,{"$f":"CONCATENATE(ADDRESS(ROW(SIS_COMMIT_RNG),COLUMN(SIS_COMMIT_RNG),,,$F$9),\":\",ADDRESS(ROW(SIS_COMMIT_RNG)+ROWS(SIS_COMMIT_RNG)-1,COLUMN(SIS_COMMIT_RNG)))","v":{"$error":"#NAME?"}}]
[]
[null,null,"Base Price","SIS_MARKET_BASE_PRICE",null,600]
[null,null,"Current Price",null,null,"MKT",null,null,null,null,"Determined at the individual market level."]
[]
[null,null,"Base Discount %","SIS_MARKET_BASE_DISCOUNT",null,1]
[null,null,"Current Discount %",null,null,"MKT",null,null,null,null,"Determined at the individual market level."]
[]
[null,null,"Discount Details"]
[null,null,"Eligibility Requirement",null,null,"SIS Participation Commitment box is marked with an \"x\""]
[null,null,"Who gets the discount",null,null,"Only the market(s) meeting the eligibility requirement"]
[null,null,"Product(s) discounted",null,null,"Market SIS Report Purchase"]
[null,null,"How the discount is applied",null,null,"Market SIS Report Purchase Price is reduced by the Current Discount % (100%)"]
[null,null,"How the discount is displayed",null,null,"When a market makes a SIS Participation Commitment the space to the right of the SIS Report Purchase will read \"Complimentary\""]
[]
[null,"Global Variable Pay"]
[]
[null,null,"Variable Pay - Globally Consistent Plan"]
[]
[null,null,"Base Price","VAR_PAY_GCP_BASE_PRICE",null,2000]
[]
[null,null,"Variable Pay - All Countries Summary"]
[]
[null,null,"Base Price","VAR_PAY_ACS_BASE_PRICE",null,1000]

{"sheet":"Services and Fees USD","index":1,"n_rows":76,"n_cols":6,"rows_kept":76,"cut":false,"hidden":false,"merged":[[68,2,68,7],[4,1,4,7],[6,2,6,5],[74,4,74,6],[70,2,70,3],[71,2,71,3],[72,2,72,3],[73,2,73,3],[70,4,70,6],[71,4,71,6],[72,4,72,6],[73,4,73,6]]}
[]
[]
[]
[]
[null,"Community™ Market Compensation & Benefits Survey"]
[]
[null,null,"Survey Pricing for Private Sector Participants1,2"]
[]
[null,null,null,"Indigo™ Interactive Data Subscription ","Preferred Partner Program\n(3 Year Commitment)","Report Subscription"]
[null,null,"Number of Countries","- - - - - - - -- - - - - - - - - - - - All fees are Per Country - - - - - - - - - - - - - - - - - - - "]
[null,null,"1 to 9 countries  ",2300,{"$error":"#N/A"},2015]
[null,null,"10 to 24 countries",2070,1395,1815]
[null,null,"25 to 34 countries",1955,1200,1815]
[null,null,"35 to 44 countries",1840,1085,1815]
[null,null,"45 or more countries",1610,1020,1815]
[]
[null,null,"1Fees above are for participants.  A surcharge of 100% applies for non-participants."]
[null,null,"2All fees are net of tax.  If any income tax, withholding tax, VAT or similar taxes are payable, the invoice amount will be"]
[null,null,"  increased (grossed-up) and taxes will be withheld from the resulting balance."]
[null,null,"3Minimum: 10 countries"]
[]
[null,null,"Note:  All invoices are provided electronically in PDF format.  An additional charge of $25 will be assessed for any"]
[null,null,"  requests to send paper invoices by post."]
[]
[null,null,"Description of Services"]
[]
[null,null,"About Birches Group Surveys"]
[null,null,"Our surveys provide market intelligence for developing countries on a global basis - 156 countries in all.  Using"]
[null,null,"  our unique survey methodology designed especially for developing markets, we provide a consistent and"]
[null,null,"  reliable market profile across leading employers in all sectors.  "]
[]
[null,null,"Our markets are dynamic - and so are our surveys.  Every country is updated on an ongoing basis three times"]
[null,null,"  a year, in April, July and October.  You can join the survey at any time."]
[]
[null,null,"We collect data from employers following their annual reviews using a simple and easy interview.  Our process"]
[null,null,"  is designed to be convenient for employers and minimize the time you  spend to prepare and submit data."]
[]
[null,null,"Indigo™ Interactive Data Subscription "]
[null,null,"Our proprietary software, Indigo™ provides interactive access to your selected survey countries for 12 months. "]
[null,null,"  Using Indigo™, you can change survey assumptions (e.g., currency, percentiles), filter survey data by job or"]
[null,null,"  grade, and create customized outputs in Excel or PDF format.  If you use a survey aggregator to manage"]
[null,null,"  survey data from multiple suppliers, we can create a customized output for you for a modest fee."]
[]
[null,null,"All Indigo™ users also get access to Birches Group Trends™, our tool to estimate market movement based"]
[null,null,"  on historical survey data."]
[]
[null,null,"Preferred Partner Program"]
[null,null,"If you need data in a minimum of ten countries, consider becoming a Preferred Partner.  Preferred Partners"]
[null,null,"  agree to subscribe via Indigo™ for three consecutive years.   Preferred fees make this option very cost-effective.  "]
[null,null,"  Clients partner with us to help expand survey participation to other employers of interest."]
[]
[null,null,"Report Subscription"]
[null,null,"If you prefer to access survey data using preformatted reports, the Birches Group Report Subscription is the"]
[null,null,"  perfect solution.  Your 12-month subscription provides access to your selected survey countries via the"]
[null,null,"  Birches Group website.  All survey releases during the year are available, on demand, whenever you need data."]
[]
[null,null,"Custom Cuts"]
[null,null,"It is often helpful to base market comparisons on a selected group of peer employers, typically sharing some"]
[null,null,"  important characteristics such as size, location, or sector.  We offer Custom Cuts to enable clients to"]
[null,null,"  analyze their market position against selected peers.  The first cut per country is free.  Note:  Custom cuts may"]
[null,null,"  not be available in every market, because a minimum of seven (7) is required.  Check with your Birches Group"]
[null,null,"  contact for more information."]
[]
[null,null,"Multiple Users Included"]
[null,null,"You can include multiple users to either subscription option at no extra charge.  You can also combine different"]
[null,null,"  subscription options (e.g., Indigo™ access at headquarters, reports in country offices)."]
[]
[]
[null,null,"Birches Group LLC"]
[]
[null,null,"Global Headquarters:",null,"Operations Centre:"]
[null,null,"228 East 45th Street, 12th Floor South",null,"Multinational Bancorporation Center, Unit 19B"]
[null,null,"New York, NY 10017",null,"6805 Ayala Avenue"]
[null,null,"USA",null,"1226 Makati City,"]
[null,null,"+1-212-972-6970",null,"Philippines"]
[null,null,null,null,"+63-2-4031541"]

{"sheet":"Order Form","index":2,"n_rows":102,"n_cols":72,"rows_kept":102,"cut":false,"hidden":false,"merged":[[4,0,4,56],[6,0,6,55],[7,2,7,48],[75,2,82,48],[16,27,16,30],[17,2,17,5],[17,6,17,23],[17,27,17,30],[55,3,55,55],[39,2,39,57],[11,39,11,50],[40,2,40,57],[42,3,42,55],[43,3,43,53],[44,3,44,55],[45,3,45,55],[46,3,46,55],[18,14,18,23],[22,2,22,23],[22,25,22,26],[22,27,22,36],[36,27,36,56],[35,25,35,56],[36,2,36,7],[16,6,16,23],[35,2,35,7],[98,14,98,25],[89,2,89,13],[89,14,89,23],[89,24,89,34],[91,2,91,13],[91,14,91,23],[91,24,91,34],[93,2,93,13],[93,14,93,23],[93,24,93,34],[96,2,96,48],[93,35,93,48],[91,35,91,48],[92,2,92,13],[92,14,92,23],[92,24,92,34],[92,35,92,48],[89,35,89,48],[90,2,90,13],[90,14,90,23],[90,24,90,34],[90,35,90,48],[11,27,11,36],[16,31,16,56],[66,11,66,27],[66,29,66,57],[13,2,13,11],[13,14,13,23],[13,27,13,36],[65,2,65,10],[65,11,65,27],[65,29,65,57],[59,3,59,55],[36,8,36,17],[17,44,17,56],[22,39,22,56],[25,39,25,56],[53,3,53,55],[47,3,47,55],[48,3,48,55],[49,3,49,55],[13,39,13,56],[17,31,17,36],[28,31,28,56],[29,44,29,56],[32,27,32,56],[33,2,33,7],[33,8,33,17],[50,3,50,55],[51,3,51,55],[62,3,62,55],[63,2,63,9],[63,10,63,13],[60,3,60,55],[61,3,61,55],[56,3,56,55],[57,3,57,55],[58,3,58,55],[52,3,52,55],[67,2,67,10],[67,11,67,27],[67,29,67,57],[8,2,8,50],[10,2,10,23],[10,25,10,26],[10,27,10,36],[35,8,35,17],[10,39,10,56],[30,14,30,23],[32,2,32,18],[34,2,34,7],[34,8,34,17],[28,6,28,23],[29,6,29,23],[29,31,29,36],[25,2,25,11],[25,14,25,23],[25,27,25,36],[18,2,18,13],[33,18,33,20],[16,2,16,5],[11,2,11,12],[11,25,11,26]]}
[]
[]
[]
[]
["Community™ Market Compensation & Benefits Survey"]
[]
["Private Sector Survey Order Form"]
[null,null,"Please complete the information below."]
[null,null,"Click on a cell to enter data.  Use TAB to move to the next field."]
[null,null,"Purchase Authorized by"]
[]
[null,null,"Organization (Subscriber)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Title",null,"Given Name(s)",null,null,null,null,null,null,null,null,null,null,null,"Surname(s)"]
[]
[]
[null,null,"Job Title",null,null,null,null,null,null,null,null,null,null,null,"Email",null,null,null,null,null,null,null,null,null,null,null,null,"Phone (including country code)",null,null,null,null,null,null,null,null,null,null,null,"Skype Address"]
[]
[null,null,"Address 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Address 2"]
[null,null,"City",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Country",null,null,null,"Algeria",null,null,null,null,null,null,null,"Postal Code"]
[null,null,"State/Province (US/Canada only)"]
[]
[]
[null,null,"Billing Contact Information (if different than purchaser)"]
[]
[null,null,"Company",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Title",null,"Given Name(s)",null,null,null,null,null,null,null,null,null,null,null,"Surname(s)"]
[]
[]
[null,null,"Job Title",null,null,null,null,null,null,null,null,null,null,null,"Email",null,null,null,null,null,null,null,null,null,null,null,null,"Phone (including country code)",null,null,null,null,null,null,null,null,null,null,null,"Skype Address"]
[]
[null,null,"Address 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Address 2"]
[null,null,"City",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Country",null,null,null,null,null,null,null,null,null,null,null,"Postal Code"]
[null,null,"State/Province (US/Canada only)"]
[]
[null,null,"(Birches Group use only)"]
[null,null,"Currency:",null,null,null,null,null,"USD",null,null,null,null,null,null,null,null,null,"No",null,null,null,null,null,null,null,null,"Purchase Order Number (optional)"]
[null,null,"Order Number:"]
[null,null,"Account Number:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Please send invoice copies to (enter email addresses with commas in between):"]
[null,null,"Sales Rep:"]
[]
[]
[]
[null,null,"    Product Selection"]
[]
[null,null,null,"Birches Group offers two (2) different options for survey participation.  You must select one option in order to continue with your order:"]
[]
[null,null,null,"Option 1 - Preferred Partner"]
[]
[null,null,null,"  The requirements for Preferred Partner subscriptions are:"]
[]
[null,null,null,"    1)  Registration in a minimum of ten (10) countries"]
[null,null,null,"    2)  Registration commitment for three (3) years"]
[null,null,null,"    3)  This form can be used for subscriptions up to sixty (60) countries.  For larger subscriptions, please contact us."]
[]
[null,null,null,"Preferred Partners automatically get Indigo™ access for all subscribed countries, and a reduced rate on custom cuts."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"`"]
[]
[null,null,null,"Option 2 - Ad-Hoc Subscription"]
[]
[null,null,null,"  The requirements for Ad-Hoc Subscriptions are:"]
[]
[null,null,null,"    1)  Registration for one (1) or more countries"]
[null,null,null,"    2)  Registration commitment for one (1) year"]
[]
[]
[null,null,"      Make entries in the ",null,null,null,null,null,null,null,"YELLOW",null,null,null,"cells only in this section."]
[]
[null,null,"      Product Option:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"You must select a PRODUCT OPTION"]
[]
[null,null,"Subscription Start Date:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"You must enter a DATE"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"User Information"]
[null,null,"Please provide the information below for each user who should have access to your subscription.  If you need more space please"]
[null,null,"attached a separate sheet with the additional users."]
[]
[null,null,"Full Name (including Mr/Ms/Dr)",null,null,null,null,null,null,null,null,null,null,null,"Job Title",null,null,null,null,null,null,null,null,null,"Email Address",null,null,null,null,null,null,null,null,null,null,"Countries for Access"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"To complete your order, SAVE THIS FILE. "]
[]
[null,null,null,null,"Then, send an email to:",null,null,null,null,null,null,null,null,null,"registration@birchesgroup.com",null,null,null,null,null,null,null,null,null,null,null,null,"and ATTACH THIS FILE to your email."]
[]
[]
[null,null,"© 2017 Birches Group LLC"]

{"sheet":"Order Form (Preferred Partner)","index":3,"n_rows":225,"n_cols":83,"rows_kept":225,"cut":false,"hidden":false,"merged":[[210,40,210,48],[210,49,210,56],[211,40,211,48],[211,49,211,56],[212,40,212,48],[212,49,212,56],[213,40,213,48],[213,49,213,56],[205,40,205,48],[205,49,205,56],[206,40,206,48],[206,49,206,56],[207,40,207,48],[207,49,207,56],[208,40,208,48],[208,49,208,56],[209,40,209,48],[209,49,209,56],[200,40,200,48],[200,49,200,56],[201,40,201,48],[201,49,201,56],[202,40,202,48],[202,49,202,56],[203,40,203,48],[203,49,203,56],[204,40,204,48],[204,49,204,56],[195,40,195,48],[195,49,195,56],[196,40,196,48],[196,49,196,56],[197,40,197,48],[197,49,197,56],[198,40,198,48],[198,49,198,56],[199,40,199,48],[199,49,199,56],[190,40,190,48],[190,49,190,56],[191,40,191,48],[191,49,191,56],[192,40,192,48],[192,49,192,56],[193,40,193,48],[193,49,193,56],[194,40,194,48],[194,49,194,56],[185,40,185,48],[185,49,185,56],[186,40,186,48],[186,49,186,56],[187,40,187,48],[187,49,187,56],[188,40,188,48],[188,49,188,56],[189,40,189,48],[189,49,189,56],[180,40,180,48],[180,49,180,56],[181,40,181,48],[181,49,181,56],[182,40,182,48],[182,49,182,56],[183,40,183,48],[183,49,183,56],[184,40,184,48],[184,49,184,56],[175,40,175,48],[175,49,175,56],[176,40,176,48],[176,49,176,56],[177,40,177,48],[177,49,177,56],[178,40,178,48],[178,49,178,56],[179,40,179,48],[179,49,179,56],[170,40,170,48],[170,49,170,56],[171,40,171,48],[171,49,171,56],[172,40,172,48],[172,49,172,56],[173,40,173,48],[173,49,173,56],[174,40,174,48],[174,49,174,56],[165,40,165,48],[165,49,165,56],[166,40,166,48],[166,49,166,56],[167,40,167,48],[167,49,167,56],[168,40,168,48],[168,49,168,56],[169,40,169,48],[169,49,169,56],[160,40,160,48],[160,49,160,56],[161,40,161,48],[161,49,161,56],[162,40,162,48],[162,49,162,56],[163,40,163,48],[163,49,163,56],[164,40,164,48],[164,49,164,56],[155,40,155,48],[155,49,155,56],[156,40,156,48],[156,49,156,56],[157,40,157,48],[157,49,157,56],[158,40,158,48],[158,49,158,56],[159,40,159,48],[159,49,159,56],[49,64,49,68],[49,69,49,72],[19,2,19,5],[19,6,19,23],[19,27,19,30],[19,31,19,57],[20,2,20,5],[20,6,20,23],[20,27,20,30],[20,31,20,36],[20,44,20,57],[28,2,28,11],[28,14,28,23],[28,27,28,36],[28,39,28,57],[31,6,31,23],[31,31,31,57],[21,2,21,13],[21,14,21,23],[25,2,25,23],[25,25,25,26],[25,27,25,36],[25,39,25,57],[39,8,39,17],[6,1,6,57],[14,2,14,12],[14,25,14,26],[14,27,14,36],[14,39,14,57],[16,2,16,11],[16,14,16,23],[16,27,16,36],[16,39,16,57],[9,2,10,57],[11,2,11,57],[13,2,13,23],[13,25,13,26],[13,27,13,36],[13,39,13,57],[8,2,8,57],[55,29,55,35],[32,6,32,23],[32,31,32,36],[32,44,32,57],[33,14,33,23],[35,2,35,18],[35,27,35,57],[53,24,53,27],[51,3,51,10],[51,24,51,27],[52,24,52,27],[50,3,50,10],[50,24,50,27],[37,2,37,7],[37,8,37,17],[36,2,36,7],[36,8,36,17],[61,24,61,27],[60,24,60,27],[59,24,59,27],[58,24,58,27],[57,24,57,27],[56,24,56,27],[55,24,55,27],[54,24,54,27],[38,2,38,7],[38,8,38,17],[46,3,46,54],[45,3,45,55],[48,3,48,52],[50,14,50,22],[52,14,52,22],[53,14,53,22],[54,14,54,22],[55,14,55,22],[56,14,56,22],[57,14,57,22],[50,29,50,35],[52,29,52,35],[53,29,53,35],[54,29,54,35],[76,24,76,27],[69,24,69,27],[68,24,68,27],[67,24,67,27],[66,24,66,27],[65,24,65,27],[64,24,64,27],[63,24,63,27],[62,24,62,27],[73,24,73,27],[72,24,72,27],[71,24,71,27],[70,24,70,27],[90,24,90,27],[89,24,89,27],[88,24,88,27],[87,24,87,27],[86,24,86,27],[88,29,88,35],[89,29,89,35],[90,29,90,35],[77,24,77,27],[85,24,85,27],[84,24,84,27],[83,24,83,27],[82,24,82,27],[81,24,81,27],[80,24,80,27],[79,24,79,27],[78,24,78,27],[77,29,77,35],[78,29,78,35],[95,24,95,27],[94,24,94,27],[93,24,93,27],[92,24,92,27],[91,24,91,27],[91,29,91,35],[92,29,92,35],[93,29,93,35],[94,29,94,35],[95,29,95,35],[100,24,100,27],[99,24,99,27],[98,24,98,27],[97,24,97,27],[96,24,96,27],[96,29,96,35],[97,29,97,35],[98,29,98,35],[99,29,99,35],[100,29,100,35],[105,24,105,27],[104,24,104,27],[103,24,103,27],[102,24,102,27],[101,24,101,27],[101,29,101,35],[102,29,102,35],[103,29,103,35],[104,29,104,35],[105,29,105,35],[128,2,128,57],[129,2,129,57],[130,2,130,57],[132,2,132,57],[133,2,133,57],[134,2,134,57],[127,2,127,57],[116,17,116,23],[115,17,115,23],[117,17,117,23],[117,35,117,39],[116,9,116,16],[117,9,117,16],[116,29,116,33],[117,29,117,33],[123,4,123,19],[123,20,123,25],[124,4,124,19],[124,20,124,25],[123,30,123,55],[123,27,123,29],[135,2,135,57],[138,2,138,57],[139,2,145,57],[148,3,148,57],[149,3,149,57],[150,3,150,39],[152,40,153,48],[152,49,153,56],[154,40,154,48],[154,49,154,56],[155,4,155,12],[155,13,155,21],[155,22,155,30],[155,31,155,39],[156,4,156,12],[156,13,156,21],[156,22,156,30],[156,31,156,39],[152,31,153,39],[153,4,153,12],[153,13,153,21],[153,22,153,30],[154,4,154,12],[154,13,154,21],[154,22,154,30],[154,31,154,39],[159,4,159,12],[159,13,159,21],[159,22,159,30],[159,31,159,39],[160,4,160,12],[160,13,160,21],[160,22,160,30],[160,31,160,39],[157,4,157,12],[157,13,157,21],[157,22,157,30],[157,31,157,39],[158,4,158,12],[158,13,158,21],[158,22,158,30],[158,31,158,39],[163,4,163,12],[163,13,163,21],[163,22,163,30],[163,31,163,39],[164,4,164,12],[164,13,164,21],[164,22,164,30],[164,31,164,39],[161,4,161,12],[161,13,161,21],[161,22,161,30],[161,31,161,39],[162,4,162,12],[162,13,162,21],[162,22,162,30],[162,31,162,39],[167,4,167,12],[167,13,167,21],[167,22,167,30],[167,31,167,39],[168,4,168,12],[168,13,168,21],[168,22,168,30],[168,31,168,39],[165,4,165,12],[165,13,165,21],[165,22,165,30],[165,31,165,39],[166,4,166,12],[166,13,166,21],[166,22,166,30],[166,31,166,39],[171,4,171,12],[171,13,171,21],[171,22,171,30],[171,31,171,39],[172,4,172,12],[172,13,172,21],[172,22,172,30],[172,31,172,39],[169,4,169,12],[169,13,169,21],[169,22,169,30],[169,31,169,39],[170,4,170,12],[170,13,170,21],[170,22,170,30],[170,31,170,39],[175,4,175,12],[175,13,175,21],[175,22,175,30],[175,31,175,39],[176,4,176,12],[176,13,176,21],[176,22,176,30],[176,31,176,39],[173,4,173,12],[173,13,173,21],[173,22,173,30],[173,31,173,39],[174,4,174,12],[174,13,174,21],[174,22,174,30],[174,31,174,39],[179,4,179,12],[179,13,179,21],[179,22,179,30],[179,31,179,39],[180,4,180,12],[180,13,180,21],[180,22,180,30],[180,31,180,39],[177,4,177,12],[177,13,177,21],[177,22,177,30],[177,31,177,39],[178,4,178,12],[178,13,178,21],[178,22,178,30],[178,31,178,39],[183,4,183,12],[183,13,183,21],[183,22,183,30],[183,31,183,39],[184,4,184,12],[184,13,184,21],[184,22,184,30],[184,31,184,39],[181,4,181,12],[181,13,181,21],[181,22,181,30],[181,31,181,39],[182,4,182,12],[182,13,182,21],[182,22,182,30],[182,31,182,39],[187,4,187,12],[187,13,187,21],[187,22,187,30],[187,31,187,39],[188,4,188,12],[188,13,188,21],[188,22,188,30],[188,31,188,39],[185,4,185,12],[185,13,185,21],[185,22,185,30],[185,31,185,39],[186,4,186,12],[186,13,186,21],[186,22,186,30],[186,31,186,39],[191,4,191,12],[191,13,191,21],[191,22,191,30],[191,31,191,39],[192,4,192,12],[192,13,192,21],[192,22,192,30],[192,31,192,39],[189,4,189,12],[189,13,189,21],[189,22,189,30],[189,31,189,39],[190,4,190,12],[190,13,190,21],[190,22,190,30],[190,31,190,39],[195,4,195,12],[195,13,195,21],[195,22,195,30],[195,31,195,39],[196,4,196,12],[196,13,196,21],[196,22,196,30],[196,31,196,39],[193,4,193,12],[193,13,193,21],[193,22,193,30],[193,31,193,39],[194,4,194,12],[194,13,194,21],[194,22,194,30],[194,31,194,39],[199,4,199,12],[199,13,199,21],[199,22,199,30],[199,31,199,39],[200,4,200,12],[200,13,200,21],[200,22,200,30],[200,31,200,39],[197,4,197,12],[197,13,197,21],[197,22,197,30],[197,31,197,39],[198,4,198,12],[198,13,198,21],[198,22,198,30],[198,31,198,39],[203,4,203,12],[203,13,203,21],[203,22,203,30],[203,31,203,39],[204,4,204,12],[204,13,204,21],[204,22,204,30],[204,31,204,39],[201,4,201,12],[201,13,201,21],[201,22,201,30],[201,31,201,39],[202,4,202,12],[202,13,202,21],[202,22,202,30],[202,31,202,39],[210,4,210,12],[210,13,210,21],[210,22,210,30],[205,4,205,12],[205,13,205,21],[205,22,205,30],[205,31,205,39],[206,4,206,12],[206,13,206,21],[206,22,206,30],[206,31,206,39],[207,31,207,39],[208,4,208,12],[208,13,208,21],[208,22,208,30],[208,31,208,39],[209,4,209,12],[209,13,209,21],[209,22,209,30],[209,31,209,39],[210,31,210,39],[207,4,207,12],[207,13,207,21],[207,22,207,30],[221,14,221,25],[213,4,213,12],[213,13,213,21],[213,22,213,30],[213,31,213,39],[216,2,216,57],[219,2,219,57],[211,4,211,12],[211,13,211,21],[211,22,211,30],[211,31,211,39],[212,4,212,12],[212,13,212,21],[212,22,212,30],[212,31,212,39],[76,14,76,22],[77,14,77,22],[86,37,86,43],[87,37,87,43],[88,37,88,43],[69,37,69,43],[70,37,70,43],[71,37,71,43],[72,37,72,43],[73,37,73,43],[74,37,74,43],[75,37,75,43],[76,37,76,43],[77,37,77,43],[78,37,78,43],[79,37,79,43],[80,37,80,43],[81,37,81,43],[82,37,82,43],[83,37,83,43],[84,37,84,43],[85,37,85,43],[75,24,75,27],[74,24,74,27],[67,14,67,22],[68,14,68,22],[69,14,69,22],[70,14,70,22],[71,14,71,22],[72,14,72,22],[73,14,73,22],[74,14,74,22],[75,14,75,22],[58,14,58,22],[59,14,59,22],[60,14,60,22],[61,14,61,22],[62,14,62,22],[63,14,63,22],[64,14,64,22],[65,14,65,22],[66,14,66,22],[114,9,114,16],[115,9,115,16],[113,35,113,39],[114,35,114,39],[115,35,115,39],[113,17,113,23],[114,17,114,23],[111,24,111,27],[110,24,110,27],[115,29,115,33],[114,29,114,33],[113,29,113,33],[114,41,114,45],[113,41,113,45],[115,41,115,45],[116,41,116,45],[117,41,117,45],[116,35,116,39],[108,24,108,27],[107,24,107,27],[106,24,106,27],[109,24,109,27],[107,37,107,43],[110,37,110,43],[111,37,111,43],[109,29,109,35],[110,29,110,35],[111,29,111,35],[106,37,106,43],[78,14,78,22],[79,14,79,22],[80,14,80,22],[81,14,81,22],[82,14,82,22],[83,14,83,22],[84,14,84,22],[89,14,89,22],[90,14,90,22],[85,14,85,22],[86,14,86,22],[87,14,87,22],[88,14,88,22],[91,14,91,22],[92,14,92,22],[93,14,93,22],[94,14,94,22],[95,14,95,22],[96,14,96,22],[97,14,97,22],[98,14,98,22],[99,14,99,22],[100,14,100,22],[101,14,101,22],[102,14,102,22],[103,14,103,22],[104,14,104,22],[105,14,105,22],[106,14,106,22],[107,14,107,22],[108,14,108,22],[109,14,109,22],[110,14,110,22],[111,14,111,22],[50,46,50,56],[50,37,50,43],[52,37,52,43],[53,37,53,43],[54,37,54,43],[55,37,55,43],[56,37,56,43],[57,37,57,43],[58,37,58,43],[59,37,59,43],[60,37,60,43],[61,37,61,43],[62,37,62,43],[63,37,63,43],[64,37,64,43],[65,37,65,43],[66,37,66,43],[67,37,67,43],[68,37,68,43],[89,37,89,43],[90,37,90,43],[91,37,91,43],[92,37,92,43],[93,37,93,43],[94,37,94,43],[95,37,95,43],[96,37,96,43],[97,37,97,43],[108,37,108,43],[109,37,109,43],[98,37,98,43],[99,37,99,43],[100,37,100,43],[101,37,101,43],[102,37,102,43],[103,37,103,43],[104,37,104,43],[105,37,105,43],[56,29,56,35],[57,29,57,35],[58,29,58,35],[59,29,59,35],[60,29,60,35],[61,29,61,35],[62,29,62,35],[63,29,63,35],[64,29,64,35],[65,29,65,35],[66,29,66,35],[67,29,67,35],[68,29,68,35],[69,29,69,35],[70,29,70,35],[106,29,106,35],[107,29,107,35],[108,29,108,35],[79,29,79,35],[80,29,80,35],[81,29,81,35],[82,29,82,35],[83,29,83,35],[84,29,84,35],[85,29,85,35],[86,29,86,35],[87,29,87,35],[76,29,76,35],[71,29,71,35],[72,29,72,35],[73,29,73,35],[74,29,74,35],[75,29,75,35]]}
[]
[]
[]
[]
[]
[]
[null,"Community™ Market Compensation & Benefits Survey"]
[]
[null,null,"Private Sector Preferred Partner Survey Order Form"]
[null,null,"Please fill out this form completely in order to ensure your subscription can be processed quickly"]
[]
[]
[null,null,"Purchase Authorized by"]
[null,null,{"$f":"IF(ISBLANK(OrgName),\"\",OrgName)","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,{"$f":"IF(ISBLANK(SubscriberFirstName),\"\",SubscriberFirstName)","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(SubscriberLastName),\"\",SubscriberLastName)","v":""}]
[null,null,"Organization (Subscriber)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Title",null,"Given Name(s)",null,null,null,null,null,null,null,null,null,null,null,"Surname(s)"]
[]
[null,null,{"$f":"IF(ISBLANK(SubscriberTitle),\"\",SubscriberTitle)","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(SubscriberEmail),\"\",SubscriberEmail)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(SubscriberPhone),\"\",SubscriberPhone)","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(SubscriberSkype),\"\",SubscriberSkype)","v":""}]
[null,null,"Job Title",null,null,null,null,null,null,null,null,null,null,null,"Email",null,null,null,null,null,null,null,null,null,null,null,null,"Phone (including country code)",null,null,null,null,null,null,null,null,null,null,null,"Skype Address"]
[]
[null,null,"Address 1",null,null,null,{"$f":"IF(ISBLANK(SubscriberAddress1),\"\",SubscriberAddress1)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Address 2",null,null,null,{"$f":"IF(ISBLANK(SubscriberAddress2),\"\",SubscriberAddress2)","v":""}]
[null,null,"City",null,null,null,{"$f":"IF(ISBLANK(SubscriberCity),\"\",SubscriberCity)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Country",null,null,null,{"$f":"IF(ISBLANK(SubscriberCountry),\"\",SubscriberCountry)","v":"Algeria"},null,null,null,null,null,null,null,"Postal Code",null,null,null,null,{"$f":"IF(ISBLANK(SubscriberPostalCode),\"\",SubscriberPostalCode)","v":""}]
[null,null,"State/Province (US/Canada only)"]
[]
[]
[null,null,"Billing Contact Information (if different than purchaser)"]
[null,null,{"$f":"IF(ISBLANK(BillingOrgName),\"\",BillingOrgName)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(BillingSalutation),\"\",BillingSalutation)","v":""},null,{"$f":"IF(ISBLANK(BillingGivenNames),\"\",BillingGivenNames)","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(BillingSurnames),\"\",BillingSurnames)","v":""}]
[null,null,"Company",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Title",null,"Given Name(s)",null,null,null,null,null,null,null,null,null,null,null,"Surname(s)"]
[]
[null,null,{"$f":"IF(ISBLANK(BillingJobTitle),\"\",BillingJobTitle)","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(BillingEMail),\"\",BillingEMail)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(BillingPhone),\"\",BillingPhone)","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(BillingSkype),\"\",BillingSkype)","v":""}]
[null,null,"Job Title",null,null,null,null,null,null,null,null,null,null,null,"Email",null,null,null,null,null,null,null,null,null,null,null,null,"Phone (including country code)",null,null,null,null,null,null,null,null,null,null,null,"Skype Address"]
[]
[null,null,"Address 1",null,null,null,{"$f":"IF(ISBLANK(BillingAddress1),\"\",BillingAddress1)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Address 2",null,null,null,{"$f":"IF(ISBLANK(BillingAddress2),\"\",BillingAddress2)","v":""}]
[null,null,"City",null,null,null,{"$f":"IF(ISBLANK(BillingCity),\"\",BillingCity)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Country",null,null,null,{"$f":"IF(ISBLANK(BillingCountry),\"\",BillingCountry)","v":""},null,null,null,null,null,null,null,"Postal Code",null,null,null,null,{"$f":"IF(ISBLANK(BillingPostalCode),\"\",BillingPostalCode)","v":""}]
[null,null,"State/Province (US/Canada only)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(BillingState),\"\",BillingState)","v":""}]
[]
[null,null,"(Birches Group use only)",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":"IF(ISBLANK(PurchaseOrderNo),\"\",PurchaseOrderNo)","v":""}]
[null,null,"Currency:",null,null,null,null,null,{"$f":"Currency","v":"USD"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Purchase Order Number (optional)"]
[null,null,"Account Number:",null,null,null,null,null,{"$f":"AccountNumber","v":0}]
[null,null,"Order Number:",null,null,null,null,null,{"$f":"OrderNumber","v":0}]
[null,null,"Effective Date:",null,null,null,null,null,{"$f":"'Order Form'!L68","v":"00:00:00"}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Organization Name","Account Number","Order Number","Billing Contact","Billing Title","Address1","Address2","Billing State","Billing City","Billing Postal Code","Billing Country","Billing Phone","Billing E-Mail","Organization Type","Subscription Type","Subscription Start Date","Subscription End Date","Currency","Purchase Order"]
[null,null,null,"For each of the countries you have selected, please indicate the following information:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"IF(C26=\"\",C14,C26)","v":""},{"$f":"AccountNumber","v":0},{"$f":"OrderNumber","v":0},{"$f":"IF(AB26=\"\",Z14&\" \"&AB14&\" \"&AN14,Z26&\" \"&AB26&\" \"&AN26)","v":"  "},{"$f":"IF(C29=\"\",C17,C29)","v":""},{"$f":"IF(G32=\"\",G20,G32)","v":""},{"$f":"IF(AF32=\"\",AF20,AF32)","v":""},{"$f":"IF(O34=\"\",IF(O22=\"\",\"\",\", \"&VLOOKUP(O22,StateAbbr,2,FALSE)),\", \"&VLOOKUP(O34,StateAbbr,2,FALSE))","v":""},{"$f":"IF(G33=\"\",G21,G33)","v":""},{"$f":"IF(AS33=\"\",AS21,AS33)","v":""},{"$f":"IF(AF33=\"\",AF21,AF33)","v":"Algeria"},{"$f":"IF(AB29=\"\",AB17,AB29)","v":""},{"$f":"IF(O29=\"\",O17,O29)","v":""},"Private Sector","Preferred Partner",{"$f":"SubscriptionStartDate","v":"00:00:00"},{"$f":"DATE(YEAR(CB47)+3,MONTH(CB47),DAY(CB47)-1)","v":"1902-12-30"},{"$f":"Currency","v":"USD"},{"$f":"IF(ISBLANK(PurchaseOrderNo),\"\",PurchaseOrderNo)","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,"Billing Year",{"$f":"IF(TODAY()>CB47+730,\"Year 3\",IF(TODAY()>CB47+365,\"Year 2\",\"Year 1\"))","v":"Year 3"}]
[null,null,null,"Note:  You can use copy/paste commands, or drag values down, to copy information to multiple lines.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"cc Emails",null,null,null,null,"Sales Rep"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"ccemails","v":0},null,null,null,null,{"$f":"IF(ISBLANK(SalesRep),\"support@birchesgroup.com\",SalesRep)","v":"support@birchesgroup.com"},null,null,null,"Tax Gross-Up",{"$f":"U125","v":0}]
[null,null,null,"Country",null,null,null,null,null,null,null,null,null,null,{"$f":"\"Survey\nFee\"&CHAR(10)&\"(\"&\nTEXT(PPYR1,\"$#,##0\")&\" Year 1,\"&CHAR(10)&\nTEXT(PPYR2,\"$#,##0\")&\" Year 2,\"&CHAR(10)&\nTEXT(PPYR3,\"$#,##0\")&\" Year 3)\"","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"Will You Submit Data (Y/N)?",null,null,null,null,{"$f":"\"Non-Participation Surcharge\"\n&CHAR(10)&\"(\"&\nTEXT(PPNPYR1,\"$#,##0\")&\" Year 1,\"&CHAR(10)&\nTEXT(PPNPYR2,\"$#,##0\")&\" Year 2,\"&CHAR(10)&\nTEXT(PPNPYR3,\"$#,##0\")&\" Year 3)\"","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,"Custom Cut \n(if available)",null,null,null,null,null,null,null,null,"Note: \nCustom Cuts may not be available in every country. Consult your Birches Group representative for more information."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"choose",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Organization Name","Order Number","Class",{"$f":"VLOOKUP('Country Selection'!TotalIndigo,PreferredPartnerItem,2,TRUE)","v":{"$error":"#N/A"}},"Custom Cut Description","Data:Specialized Data:Custom Cut","Data:General Fees:Non-Participant Fee","Group Total","Billing Period StartDate","Billing Period End Date"]
[null,null,1,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(D53),\"\",PPYR1)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(D53),\"\",IF(Y53<>\"Yes\",PPNPYR1,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,null,null,null,null,{"$f":"OrgName","v":0},{"$f":"OrderNumber","v":0},{"$f":"IF(ISBLANK(D53),\"\",D53)","v":""},{"$f":"O53","v":""},{"$f":"IF(ISBLANK(AL53),\"\",AL53)","v":""},{"$f":"IF(AL53=\"All Cycles\",CustomAll,0)+IF(OR(AL53=\"Cycle 1 (Apr)\",AL53= \"Cycle 2 (Jul)\",AL53= \"Cycle 3 (Oct)\"),CustomCut,0)","v":0},{"$f":"AD53","v":""},{"$f":"SUM(BS53,BP53,BR53)","v":0},{"$f":"IF($CA$48=\"Year 1\",$CB$47,IF($CA$48=\"Year 2\",EDATE($CB$47,12),EDATE($CB$47,24)))","v":"1901-12-31"},{"$f":"IF(BU53=\"\",\"\",DATE(YEAR(BU53)+1,MONTH(BU53),DAY(BU53)-1))","v":"1902-12-30"}]
[null,null,{"$f":"C53+1","v":2},null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"IF(ISBLANK(D54),\"\",D54)","v":""},{"$f":"T54","v":0},"",0,"",0,"1901-12-31",{"$f":"IF(BU54=\"\",\"\",DATE(YEAR(BU54)+1,MONTH(BU54),DAY(BU54)-1))","v":"1902-12-30"}]
[null,null,{"$f":"C54+1","v":3},null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,"",0,"",0,"1901-12-31","1902-12-30"]
[null,null,4,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,"",0,"",0,"1901-12-31","1902-12-30"]
[null,null,5,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,"",0,"",0,"1901-12-31","1902-12-30"]
[null,null,6,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,"",0,"",0,"1901-12-31","1902-12-30"]
[null,null,7,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,"",0,"",0,"1901-12-31","1902-12-30"]
[null,null,8,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,"",0,"",0,"1901-12-31","1902-12-30"]
[null,null,9,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,"",0,"",0,"1901-12-31","1902-12-30"]
[null,null,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,0,0,"",0,"",0,"",0,"1901-12-31","1902-12-30"]
[null,null,11,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,"",0,"",0,"1901-12-31","1902-12-30"]
[null,null,12,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,"",0,"",0,"1901-12-31","1902-12-30"]
[null,null,13,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,"",0,"",0,"1901-12-31","1902-12-30"]
[null,null,14,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,"",0,"",0,"1901-12-31","1902-12-30"]
[null,null,15,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,"",0,"",0,"1901-12-31","1902-12-30"]
[null,null,16,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,"",0,"",0,"1901-12-31","1902-12-30"]
[null,null,17,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,"",0,"",0,"1901-12-31","1902-12-30"]
[null,null,18,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,"",0,"",0,"1901-12-31","1902-12-30"]
[null,null,19,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,"",0,"",0,"1901-12-31","1902-12-30"]
[null,null,20,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,"",0,"",0,"1901-12-31","1902-12-30"]
[null,null,21,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,"",0,"",0,"1901-12-31","1902-12-30"]
[null,null,22,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,"",0,"",0,"1901-12-31","1902-12-30"]
[null,null,23,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,"",0,"",0,"1901-12-31","1902-12-30"]
[null,null,24,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,"",0,"",0,"1901-12-31","1902-12-30"]
[null,null,25,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,"",0,"",0,"1901-12-31","1902-12-30"]
[null,null,26,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,"",0,"",0,"1901-12-31","1902-12-30"]
[null,null,27,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,"",0,"",0,"1901-12-31","1902-12-30"]
[null,null,28,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,"",0,"",0,"1901-12-31","1902-12-30"]
[null,null,29,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,"",0,"",0,"1901-12-31","1902-12-30"]
[null,null,30,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,"",0,"",0,"1901-12-31","1902-12-30"]
[null,null,31,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,"",0,"",0,"1901-12-31","1902-12-30"]
[null,null,32,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,"",0,"",0,"1901-12-31","1902-12-30"]
[null,null,33,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(D85),\"\",PPYR1)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(D85),\"\",IF(Y85<>\"Yes\",PPNPYR1,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,null,null,null,null,0,0,"",{"$f":"T85","v":0},{"$f":"IF(ISBLANK(AL85),\"\",AL85)","v":""},{"$f":"IF(AL85=\"All Cycles\",CustomAll,0)+IF(OR(AL85=\"Cycle 1 (Apr)\",AL85= \"Cycle 2 (Jul)\",AL85= \"Cycle 3 (Oct)\"),CustomCut,0)","v":0},{"$f":"AD85","v":""},{"$f":"SUM(BS85,BP85,BR85)","v":0},{"$f":"IF($CA$48=\"Year 1\",$CB$47,IF($CA$48=\"Year 2\",EDATE($CB$47,12),EDATE($CB$47,24)))","v":"1901-12-31"},"1902-12-30"]
[null,null,34,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,"",0,"",0,"1901-12-31","1902-12-30"]
[null,null,35,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,"",0,"",0,"1901-12-31","1902-12-30"]
[null,null,36,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,"",0,"",0,"1901-12-31","1902-12-30"]
[null,null,37,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,"",0,"",0,"1901-12-31","1902-12-30"]
[null,null,38,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,"",0,"",0,"1901-12-31","1902-12-30"]
[null,null,39,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,"",0,"",0,"1901-12-31","1902-12-30"]
[null,null,40,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,"",0,"",0,"1901-12-31","1902-12-30"]
[null,null,41,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,"",0,"",0,"1901-12-31","1902-12-30"]
[null,null,42,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,"",0,"",0,"1901-12-31","1902-12-30"]
[null,null,43,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,"",0,"",0,"1901-12-31","1902-12-30"]
[null,null,44,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,"",0,"",0,"1901-12-31","1902-12-30"]
[null,null,45,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,"",0,"",0,"1901-12-31","1902-12-30"]
[null,null,46,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,"",0,"",0,"1901-12-31","1902-12-30"]
[null,null,47,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,"",0,"",0,"1901-12-31","1902-12-30"]
[null,null,48,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,"",0,"",0,"1901-12-31","1902-12-30"]
[null,null,49,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,"",0,"",0,"1901-12-31","1902-12-30"]
[null,null,50,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,"",0,"",0,"1901-12-31","1902-12-30"]
[null,null,51,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,"",0,"",0,"1901-12-31","1902-12-30"]
[null,null,52,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,"",0,"",0,"1901-12-31","1902-12-30"]
[null,null,53,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,"",0,"",0,"1901-12-31","1902-12-30"]
[null,null,54,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,"",0,"",0,"1901-12-31","1902-12-30"]
[null,null,55,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,"",0,"",0,"1901-12-31","1902-12-30"]
[null,null,56,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,"",0,"",0,"1901-12-31","1902-12-30"]
[null,null,57,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,"",0,"",0,"1901-12-31","1902-12-30"]
[null,null,58,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,"",0,"",0,"1901-12-31","1902-12-30"]
[null,null,59,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,"",0,"",0,"1901-12-31","1902-12-30"]
[null,null,60,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,"",0,"",0,"1901-12-31","1902-12-30"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Surveys",null,null,null,null,null,null,null,null,null,null,null,"Non-Particiption Fee",null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"OrgName","v":0},{"$f":"OrderNumber","v":0},{"$f":"'Country Selection'!TotalIndigo","v":0},{"$f":"SUM(BP53:BP112)","v":0},null,{"$f":"SUM(BR53:BR112)","v":0},{"$f":"SUM(BS53:BS112)","v":0},{"$f":"SUM(BT53:BT112)","v":0}]
[null,null,null,null,null,null,null,null,null,"1st Year",null,null,null,null,null,null,null,{"$f":"PPYR1*COUNTA($D$53:$D$112)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIFS(D53:D112,\"<>\"&\"\",Y53:Y112,\"<>Yes\")*PPNPYR1","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R115:AH115)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,"2nd Year",null,null,null,null,null,null,null,{"$f":"PPYR2*COUNTA($D$53:$D$112)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIFS(D53:D112,\"<>\"&\"\",Y53:Y112,\"<>Yes\")*PPNPYR2","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,{"$f":"AP115","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,"3rd Year",null,null,null,null,null,null,null,{"$f":"PPYR3*COUNTA($D$53:$D$112)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIFS(D53:D112,\"<>\"&\"\",Y53:Y112,\"<>Yes\")*PPNPYR3","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,{"$f":"AP116","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,"Total Fees\n(3 Years)",null,null,null,null,null,null,null,{"$f":"SUM(R115:X117)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AD115:AG117)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R118:AH118)","v":{"$error":"#N/A"}}]
[]
[]
[null,null,null,null,"Note:  All fees are net of tax.  If any  income tax, withholding tax, VAT or similar taxes are payable, the invoice amount will be"]
[null,null,null,null,"increased (grossed-up) and taxes will be withheld from the resulting balance."]
[]
[null,null,null,null,{"$f":"\"Tax rate applicable in \"&IF(AF33=\"\",AF21,AF33)&\":\"","v":"Tax rate applicable in Algeria:"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP(IF(AF33=\"\",AF21,AF33),GrossUps,2,FALSE)*IF(AB124=\"\",1,0),\"Not Applicable\")","v":"Not Applicable"},null,null,null,null,null,null,null,null,null,"Type X to cancel application of tax"]
[null,null,null,null,"Tax Gross-up Amount:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U124=\"Not Applicable\",0,ROUND((AP115/(1-U124))-AP115,2))","v":0}]
[]
[]
[null,null,"Subscription Agreement"]
[null,null,"All data is sold via subscription for a 12-month period, beginning on the Subscription Start Date you entered on the first Order Form Page"]
[null,null,"Three survey updates are issued annually, in April, July and October.  Participants must contribute their organization's data once per year,"]
[null,null,"  within 60 days following annual pay review, or be subject to a non-participant surcharge (see Subscription Agreement, paragraph 18)."]
[]
[null,null,"All subscriptions require confirmation of Terms and Conditions via our Subscription Agreement.  "]
[]
[null,null,"Click HERE to review the Terms and Conditions and confirm your agreement."]
[]
[null,null,{"$f":"IF(Agreement=TRUE,\"Agreement Confirmed\",\"Agreement NOT Confirmed\")","v":"Agreement NOT Confirmed"},null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[]
[null,null,"Notes / Special Billing Requests"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Country Information"]
[null,null,null,"Please indicate below, for each country in which you registered, the requested information."]
[null,null,null,"When finished, click on Go to Survey Access to continue."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pay Review Frequency",null,null,null,null,null,null,null,null,"Data Submission Month",null,null,null,null,null,null,null,null,"Data Submission Cycle"]
[null,null,null,null,"Survey Country",null,null,null,null,null,null,null,null,"Total Staff Count",null,null,null,null,null,null,null,null,"Next Pay Review Date"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(VLOOKUP(AO155,DataCycles,2,FALSE),\"\")","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(VLOOKUP(AO187,DataCycles,2,FALSE),\"\")","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[null,null,"RETURN COMPLETED FORM TO YOUR ACCOUNT EXECUTIVE"]
[]
[]
[null,null,"To complete your order, SAVE THIS FILE. "]
[]
[null,null,null,null,"Then, send an email to:",null,null,null,null,null,null,null,null,null,"registration@birchesgroup.com",null,null,null,null,null,null,null,null,null,null,null,null,"and ATTACH THIS FILE to your email."]
[]
[]
[null,null,"© 2013 Birches Group LLC"]

{"sheet":"Order Form (Ad-Hoc)","index":4,"n_rows":220,"n_cols":83,"rows_kept":220,"cut":false,"hidden":false,"merged":[[206,40,206,48],[206,49,206,56],[207,40,207,48],[207,49,207,56],[208,40,208,48],[208,49,208,56],[209,40,209,48],[209,49,209,56],[210,40,210,48],[210,49,210,56],[201,40,201,48],[201,49,201,56],[202,40,202,48],[202,49,202,56],[203,40,203,48],[203,49,203,56],[204,40,204,48],[204,49,204,56],[205,40,205,48],[205,49,205,56],[196,40,196,48],[196,49,196,56],[197,40,197,48],[197,49,197,56],[198,40,198,48],[198,49,198,56],[199,40,199,48],[199,49,199,56],[200,40,200,48],[200,49,200,56],[191,40,191,48],[191,49,191,56],[192,40,192,48],[192,49,192,56],[193,40,193,48],[193,49,193,56],[194,40,194,48],[194,49,194,56],[195,40,195,48],[195,49,195,56],[186,40,186,48],[186,49,186,56],[187,40,187,48],[187,49,187,56],[188,40,188,48],[188,49,188,56],[189,40,189,48],[189,49,189,56],[190,40,190,48],[190,49,190,56],[181,40,181,48],[181,49,181,56],[182,40,182,48],[182,49,182,56],[183,40,183,48],[183,49,183,56],[184,40,184,48],[184,49,184,56],[185,40,185,48],[185,49,185,56],[176,40,176,48],[176,49,176,56],[177,40,177,48],[177,49,177,56],[178,40,178,48],[178,49,178,56],[179,40,179,48],[179,49,179,56],[180,40,180,48],[180,49,180,56],[171,40,171,48],[171,49,171,56],[172,40,172,48],[172,49,172,56],[173,40,173,48],[173,49,173,56],[174,40,174,48],[174,49,174,56],[175,40,175,48],[175,49,175,56],[166,40,166,48],[166,49,166,56],[167,40,167,48],[167,49,167,56],[168,40,168,48],[168,49,168,56],[169,40,169,48],[169,49,169,56],[170,40,170,48],[170,49,170,56],[161,40,161,48],[161,49,161,56],[162,40,162,48],[162,49,162,56],[163,40,163,48],[163,49,163,56],[164,40,164,48],[164,49,164,56],[165,40,165,48],[165,49,165,56],[156,40,156,48],[156,49,156,56],[157,40,157,48],[157,49,157,56],[158,40,158,48],[158,49,158,56],[159,40,159,48],[159,49,159,56],[160,40,160,48],[160,49,160,56],[151,40,151,48],[151,49,151,56],[152,40,152,48],[152,49,152,56],[153,40,153,48],[153,49,153,56],[154,40,154,48],[154,49,154,56],[155,40,155,48],[155,49,155,56],[8,2,8,57],[121,20,121,25],[49,64,49,68],[49,69,49,72],[20,2,20,5],[20,6,20,23],[20,27,20,30],[20,31,20,57],[6,1,6,57],[15,2,15,12],[15,25,15,26],[15,27,15,36],[15,39,15,57],[17,2,17,11],[17,14,17,23],[17,27,17,36],[17,39,17,57],[9,2,10,57],[12,2,12,57],[14,2,14,23],[14,25,14,26],[14,27,14,36],[14,39,14,57],[21,2,21,5],[21,6,21,23],[21,27,21,30],[21,31,21,36],[21,44,21,57],[29,2,29,11],[29,14,29,23],[29,27,29,36],[29,39,29,57],[32,6,32,23],[32,31,32,57],[22,2,22,13],[22,14,22,23],[26,2,26,23],[26,25,26,26],[26,27,26,36],[26,39,26,57],[39,2,39,7],[39,8,39,17],[42,3,42,54],[44,3,44,55],[45,3,45,55],[47,3,47,52],[33,6,33,23],[33,31,33,36],[33,44,33,57],[34,14,34,23],[36,2,36,18],[36,27,36,57],[43,3,43,55],[40,8,40,17],[37,2,37,7],[37,8,37,17],[38,2,38,7],[38,8,38,17],[52,40,52,44],[53,40,53,44],[54,40,54,44],[52,31,52,34],[53,31,53,34],[54,31,54,34],[52,26,52,30],[52,13,52,25],[52,35,52,39],[54,26,54,30],[53,26,53,30],[53,13,53,25],[54,13,54,25],[53,35,53,39],[54,35,54,39],[51,3,51,10],[51,26,51,30],[50,26,50,30],[51,13,51,25],[50,13,50,25],[50,35,50,39],[51,35,51,39],[50,40,50,44],[50,31,50,34],[51,31,51,34],[50,3,50,12],[58,26,58,30],[57,26,57,30],[57,13,57,25],[58,13,58,25],[57,35,57,39],[58,35,58,39],[57,40,57,44],[58,40,58,44],[57,31,57,34],[58,31,58,34],[56,26,56,30],[55,26,55,30],[55,13,55,25],[56,13,56,25],[55,35,55,39],[56,35,56,39],[55,40,55,44],[56,40,56,44],[55,31,55,34],[56,31,56,34],[60,26,60,30],[59,26,59,30],[59,13,59,25],[60,13,60,25],[59,35,59,39],[60,35,60,39],[59,40,59,44],[60,40,60,44],[59,31,59,34],[60,31,60,34],[62,26,62,30],[61,26,61,30],[61,13,61,25],[62,13,62,25],[61,35,61,39],[62,35,62,39],[61,40,61,44],[62,40,62,44],[61,31,61,34],[62,31,62,34],[64,26,64,30],[63,26,63,30],[63,13,63,25],[64,13,64,25],[63,35,63,39],[64,35,64,39],[63,40,63,44],[64,40,64,44],[63,31,63,34],[64,31,64,34],[66,26,66,30],[65,26,65,30],[65,13,65,25],[66,13,66,25],[65,35,65,39],[66,35,66,39],[65,40,65,44],[66,40,66,44],[65,31,65,34],[66,31,66,34],[68,26,68,30],[67,26,67,30],[67,13,67,25],[68,13,68,25],[67,35,67,39],[68,35,68,39],[67,40,67,44],[68,40,68,44],[67,31,67,34],[68,31,68,34],[70,26,70,30],[69,26,69,30],[69,13,69,25],[70,13,70,25],[69,35,69,39],[70,35,70,39],[69,40,69,44],[70,40,70,44],[69,31,69,34],[70,31,70,34],[72,26,72,30],[71,26,71,30],[71,13,71,25],[72,13,72,25],[71,35,71,39],[72,35,72,39],[71,40,71,44],[72,40,72,44],[71,31,71,34],[72,31,72,34],[74,26,74,30],[73,26,73,30],[73,13,73,25],[74,13,74,25],[73,35,73,39],[74,35,74,39],[73,40,73,44],[74,40,74,44],[73,31,73,34],[74,31,74,34],[76,26,76,30],[75,26,75,30],[75,13,75,25],[76,13,76,25],[75,35,75,39],[76,35,76,39],[75,40,75,44],[76,40,76,44],[75,31,75,34],[76,31,76,34],[78,26,78,30],[77,26,77,30],[77,13,77,25],[78,13,78,25],[77,35,77,39],[78,35,78,39],[77,40,77,44],[78,40,78,44],[77,31,77,34],[78,31,78,34],[80,26,80,30],[79,26,79,30],[79,13,79,25],[80,13,80,25],[79,35,79,39],[80,35,80,39],[79,40,79,44],[80,40,80,44],[79,31,79,34],[80,31,80,34],[82,26,82,30],[81,26,81,30],[81,13,81,25],[82,13,82,25],[81,35,81,39],[82,35,82,39],[81,40,81,44],[82,40,82,44],[81,31,81,34],[82,31,82,34],[84,26,84,30],[83,26,83,30],[83,13,83,25],[84,13,84,25],[83,35,83,39],[84,35,84,39],[83,40,83,44],[84,40,84,44],[83,31,83,34],[84,31,84,34],[86,26,86,30],[85,26,85,30],[85,13,85,25],[86,13,86,25],[85,35,85,39],[86,35,86,39],[85,40,85,44],[86,40,86,44],[85,31,85,34],[86,31,86,34],[88,26,88,30],[87,26,87,30],[87,13,87,25],[88,13,88,25],[87,35,87,39],[88,35,88,39],[87,40,87,44],[88,40,88,44],[87,31,87,34],[88,31,88,34],[90,26,90,30],[89,26,89,30],[89,13,89,25],[90,13,90,25],[89,35,89,39],[90,35,90,39],[89,40,89,44],[90,40,90,44],[89,31,89,34],[90,31,90,34],[92,26,92,30],[91,26,91,30],[91,13,91,25],[92,13,92,25],[91,35,91,39],[92,35,92,39],[91,40,91,44],[92,40,92,44],[91,31,91,34],[92,31,92,34],[94,26,94,30],[93,26,93,30],[93,13,93,25],[94,13,94,25],[93,35,93,39],[94,35,94,39],[93,40,93,44],[94,40,94,44],[93,31,93,34],[94,31,94,34],[96,26,96,30],[95,26,95,30],[95,13,95,25],[96,13,96,25],[95,35,95,39],[96,35,96,39],[95,40,95,44],[96,40,96,44],[95,31,95,34],[96,31,96,34],[98,26,98,30],[97,26,97,30],[97,13,97,25],[98,13,98,25],[97,35,97,39],[98,35,98,39],[97,40,97,44],[98,40,98,44],[97,31,97,34],[98,31,98,34],[100,26,100,30],[99,26,99,30],[99,13,99,25],[100,13,100,25],[99,35,99,39],[100,35,100,39],[99,40,99,44],[100,40,100,44],[99,31,99,34],[100,31,100,34],[102,26,102,30],[101,26,101,30],[101,13,101,25],[102,13,102,25],[101,35,101,39],[102,35,102,39],[101,40,101,44],[102,40,102,44],[101,31,101,34],[102,31,102,34],[104,26,104,30],[103,26,103,30],[103,13,103,25],[104,13,104,25],[103,35,103,39],[104,35,104,39],[103,40,103,44],[104,40,104,44],[103,31,103,34],[104,31,104,34],[106,26,106,30],[105,26,105,30],[105,13,105,25],[106,13,106,25],[105,35,105,39],[106,35,106,39],[105,40,105,44],[106,40,106,44],[105,31,105,34],[106,31,106,34],[108,26,108,30],[107,26,107,30],[107,13,107,25],[108,13,108,25],[107,35,107,39],[108,35,108,39],[107,40,107,44],[108,40,108,44],[107,31,107,34],[108,31,108,34],[110,26,110,30],[109,26,109,30],[109,13,109,25],[110,13,110,25],[109,35,109,39],[110,35,110,39],[109,40,109,44],[110,40,110,44],[109,31,109,34],[110,31,110,34],[126,2,126,57],[127,2,127,57],[128,2,128,57],[130,2,130,57],[132,2,132,29],[124,2,124,57],[111,26,111,30],[111,13,111,25],[111,35,111,39],[114,35,114,39],[125,2,125,57],[111,40,111,44],[114,40,114,44],[115,40,115,44],[111,31,111,34],[115,35,115,39],[115,46,115,50],[114,46,114,50],[114,26,114,30],[115,26,115,30],[115,15,115,25],[120,4,120,19],[120,20,120,25],[121,4,121,19],[145,3,145,57],[146,3,146,57],[147,3,147,39],[149,31,150,39],[150,4,150,12],[150,13,150,21],[150,22,150,30],[136,2,136,57],[137,2,142,57],[149,40,150,48],[149,49,150,56],[153,4,153,12],[153,13,153,21],[153,22,153,30],[153,31,153,39],[154,4,154,12],[154,13,154,21],[154,22,154,30],[154,31,154,39],[151,4,151,12],[151,13,151,21],[151,22,151,30],[151,31,151,39],[152,4,152,12],[152,13,152,21],[152,22,152,30],[152,31,152,39],[157,4,157,12],[157,13,157,21],[157,22,157,30],[157,31,157,39],[158,4,158,12],[158,13,158,21],[158,22,158,30],[158,31,158,39],[155,4,155,12],[155,13,155,21],[155,22,155,30],[155,31,155,39],[156,4,156,12],[156,13,156,21],[156,22,156,30],[156,31,156,39],[161,4,161,12],[161,13,161,21],[161,22,161,30],[161,31,161,39],[162,4,162,12],[162,13,162,21],[162,22,162,30],[162,31,162,39],[159,4,159,12],[159,13,159,21],[159,22,159,30],[159,31,159,39],[160,4,160,12],[160,13,160,21],[160,22,160,30],[160,31,160,39],[165,4,165,12],[165,13,165,21],[165,22,165,30],[165,31,165,39],[166,4,166,12],[166,13,166,21],[166,22,166,30],[166,31,166,39],[163,4,163,12],[163,13,163,21],[163,22,163,30],[163,31,163,39],[164,4,164,12],[164,13,164,21],[164,22,164,30],[164,31,164,39],[169,4,169,12],[169,13,169,21],[169,22,169,30],[169,31,169,39],[170,4,170,12],[170,13,170,21],[170,22,170,30],[170,31,170,39],[167,4,167,12],[167,13,167,21],[167,22,167,30],[167,31,167,39],[168,4,168,12],[168,13,168,21],[168,22,168,30],[168,31,168,39],[173,4,173,12],[173,13,173,21],[173,22,173,30],[173,31,173,39],[174,4,174,12],[174,13,174,21],[174,22,174,30],[174,31,174,39],[171,4,171,12],[171,13,171,21],[171,22,171,30],[171,31,171,39],[172,4,172,12],[172,13,172,21],[172,22,172,30],[172,31,172,39],[177,4,177,12],[177,13,177,21],[177,22,177,30],[177,31,177,39],[178,4,178,12],[178,13,178,21],[178,22,178,30],[178,31,178,39],[175,4,175,12],[175,13,175,21],[175,22,175,30],[175,31,175,39],[176,4,176,12],[176,13,176,21],[176,22,176,30],[176,31,176,39],[181,4,181,12],[181,13,181,21],[181,22,181,30],[181,31,181,39],[182,4,182,12],[182,13,182,21],[182,22,182,30],[182,31,182,39],[179,4,179,12],[179,13,179,21],[179,22,179,30],[179,31,179,39],[180,4,180,12],[180,13,180,21],[180,22,180,30],[180,31,180,39],[185,4,185,12],[185,13,185,21],[185,22,185,30],[185,31,185,39],[186,4,186,12],[186,13,186,21],[186,22,186,30],[186,31,186,39],[183,4,183,12],[183,13,183,21],[183,22,183,30],[183,31,183,39],[184,4,184,12],[184,13,184,21],[184,22,184,30],[184,31,184,39],[189,4,189,12],[189,13,189,21],[189,22,189,30],[189,31,189,39],[190,4,190,12],[190,13,190,21],[190,22,190,30],[190,31,190,39],[187,4,187,12],[187,13,187,21],[187,22,187,30],[187,31,187,39],[188,4,188,12],[188,13,188,21],[188,22,188,30],[188,31,188,39],[193,4,193,12],[193,13,193,21],[193,22,193,30],[193,31,193,39],[194,4,194,12],[194,13,194,21],[194,22,194,30],[194,31,194,39],[191,4,191,12],[191,13,191,21],[191,22,191,30],[191,31,191,39],[192,4,192,12],[192,13,192,21],[192,22,192,30],[192,31,192,39],[197,4,197,12],[197,13,197,21],[197,22,197,30],[197,31,197,39],[198,4,198,12],[198,13,198,21],[198,22,198,30],[198,31,198,39],[195,4,195,12],[195,13,195,21],[195,22,195,30],[195,31,195,39],[196,4,196,12],[196,13,196,21],[196,22,196,30],[196,31,196,39],[201,4,201,12],[201,13,201,21],[201,22,201,30],[201,31,201,39],[202,4,202,12],[202,13,202,21],[202,22,202,30],[202,31,202,39],[199,4,199,12],[199,13,199,21],[199,22,199,30],[199,31,199,39],[200,4,200,12],[200,13,200,21],[200,22,200,30],[200,31,200,39],[207,22,207,30],[207,31,207,39],[208,4,208,12],[208,13,208,21],[208,22,208,30],[203,4,203,12],[203,13,203,21],[203,22,203,30],[203,31,203,39],[204,4,204,12],[204,13,204,21],[204,22,204,30],[204,31,204,39],[120,27,120,29],[120,30,120,55],[49,46,50,56],[213,2,213,57],[216,14,216,25],[209,4,209,12],[209,13,209,21],[209,22,209,30],[209,31,209,39],[210,4,210,12],[210,13,210,21],[210,22,210,30],[210,31,210,39],[208,31,208,39],[205,4,205,12],[205,13,205,21],[205,22,205,30],[205,31,205,39],[206,4,206,12],[206,13,206,21],[206,22,206,30],[206,31,206,39],[207,4,207,12],[207,13,207,21]]}
[]
[]
[]
[]
[]
[]
[null,"Community™ Market Compensation & Benefits Survey"]
[]
[null,null,"Private Sector Order Form"]
[null,null,"Please fill out this form completely in order to ensure your subscription can be processed quickly"]
[]
[]
[]
[null,null,"Purchase Authorized by"]
[null,null,{"$f":"IF(ISBLANK(OrgName),\"\",OrgName)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(SubscriberSalutation),\"\",SubscriberSalutation)","v":""},null,{"$f":"IF(ISBLANK(SubscriberFirstName),\"\",SubscriberFirstName)","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(SubscriberLastName),\"\",SubscriberLastName)","v":""}]
[null,null,"Organization (Subscriber)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Title",null,"Given Name(s)",null,null,null,null,null,null,null,null,null,null,null,"Surname(s)"]
[]
[null,null,{"$f":"IF(ISBLANK(SubscriberTitle),\"\",SubscriberTitle)","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(SubscriberEmail),\"\",SubscriberEmail)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(SubscriberPhone),\"\",SubscriberPhone)","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(SubscriberSkype),\"\",SubscriberSkype)","v":""}]
[null,null,"Job Title",null,null,null,null,null,null,null,null,null,null,null,"Email",null,null,null,null,null,null,null,null,null,null,null,null,"Phone (including country code)",null,null,null,null,null,null,null,null,null,null,null,"Skype Address"]
[]
[null,null,"Address 1",null,null,null,{"$f":"IF(ISBLANK(SubscriberAddress1),\"\",SubscriberAddress1)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Address 2",null,null,null,{"$f":"IF(ISBLANK(SubscriberAddress2),\"\",SubscriberAddress2)","v":""}]
[null,null,"City",null,null,null,{"$f":"IF(ISBLANK(SubscriberCity),\"\",SubscriberCity)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Country",null,null,null,{"$f":"IF(ISBLANK(SubscriberCountry),\"\",SubscriberCountry)","v":"Algeria"},null,null,null,null,null,null,null,"Postal Code",null,null,null,null,{"$f":"IF(ISBLANK(SubscriberPostalCode),\"\",SubscriberPostalCode)","v":""}]
[null,null,"State/Province (US/Canada only)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(SubscriberState),\"\",SubscriberState)","v":""}]
[]
[]
[null,null,"Billing Contact Information (if different than purchaser)"]
[null,null,{"$f":"IF(ISBLANK(BillingOrgName),\"\",BillingOrgName)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(BillingSalutation),\"\",BillingSalutation)","v":""},null,{"$f":"IF(ISBLANK(BillingGivenNames),\"\",BillingGivenNames)","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(BillingSurnames),\"\",BillingSurnames)","v":""}]
[null,null,"Company",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Title",null,"Given Name(s)",null,null,null,null,null,null,null,null,null,null,null,"Surname(s)"]
[]
[null,null,{"$f":"IF(ISBLANK(BillingJobTitle),\"\",BillingJobTitle)","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(BillingEMail),\"\",BillingEMail)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(BillingPhone),\"\",BillingPhone)","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(BillingSkype),\"\",BillingSkype)","v":""}]
[null,null,"Job Title",null,null,null,null,null,null,null,null,null,null,null,"Email",null,null,null,null,null,null,null,null,null,null,null,null,"Phone (including country code)",null,null,null,null,null,null,null,null,null,null,null,"Skype Address"]
[]
[null,null,"Address 1",null,null,null,{"$f":"IF(ISBLANK(BillingAddress1),\"\",BillingAddress1)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Address 2",null,null,null,{"$f":"IF(ISBLANK(BillingAddress2),\"\",BillingAddress2)","v":""}]
[null,null,"City",null,null,null,{"$f":"IF(ISBLANK(BillingCity),\"\",BillingCity)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Country",null,null,null,{"$f":"IF(ISBLANK(BillingCountry),\"\",BillingCountry)","v":""},null,null,null,null,null,null,null,"Postal Code",null,null,null,null,{"$f":"IF(ISBLANK(BillingPostalCode),\"\",BillingPostalCode)","v":""}]
[null,null,"State/Province (US/Canada only)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(BillingState),\"\",BillingState)","v":""}]
[]
[null,null,"(Birches Group use only)",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":"IF(ISBLANK(PurchaseOrderNo),\"\",PurchaseOrderNo)","v":""}]
[null,null,"Currency:",null,null,null,null,null,{"$f":"Currency","v":"USD"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Purchase Order Number (optional)"]
[null,null,"Account Number:",null,null,null,null,null,{"$f":"AccountNumber","v":0}]
[null,null,"Order Number:",null,null,null,null,null,{"$f":"OrderNumber","v":0}]
[null,null,"Effective Date:",null,null,null,null,null,{"$f":"'Order Form'!L68","v":"00:00:00"}]
[]
[null,null,null,"For each of the countries you have selected, please indicate the following information:"]
[]
[null,null,null,"  1)  Reports or Indigo™ Access.  For each country, indicate if you would like a Report Subscription or Indigo™ Access."]
[null,null,null,"  2)  Data Submission.  Indicate Yes or No for Data Submission.  Note there is an additional fee if you do not submit your data,",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Organization Name","Account Number","Order Number","Billing Contact","Billing Title","Address1","Address2","Billing State","Billing City","Billing Postal Code","Billing Country","Billing Phone","Billing E-Mail","Organization Type","Subscription Type","Subscription Start Date","Subscription End Date","Currency","Purchase Order"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"IF(C27=\"\",C15,C27)","v":""},{"$f":"AccountNumber","v":0},{"$f":"OrderNumber","v":0},{"$f":"IF(AB27=\"\",Z15&\" \"&AB15&\" \"&AN15,Z27&\" \"&AB27&\" \"&AN27)","v":"  "},{"$f":"IF(C30=\"\",C18,C30)","v":""},{"$f":"IF(G33=\"\",G21,G33)","v":""},{"$f":"IF(AF33=\"\",AF21,AF33)","v":""},{"$f":"IF(O35=\"\",IF(O23=\"\",\"\", \", \"&VLOOKUP(O23,StateAbbr,2,FALSE)), \", \"&VLOOKUP(O35,StateAbbr,2,FALSE))","v":""},{"$f":"IF(G34=\"\",G22,G34)","v":""},{"$f":"IF(AS34=\"\",AS22,AS34)","v":""},{"$f":"IF(AF34=\"\",AF22,AF34)","v":"Algeria"},{"$f":"IF(AB30=\"\",AB18,AB30)","v":""},{"$f":"IF(O30=\"\",O18,O30)","v":""},"Private Sector",{"$f":"ProductSelectionChoice","v":0},{"$f":"SubscriptionStartDate","v":"00:00:00"},{"$f":"DATE(YEAR(CB47)+1,MONTH(CB47),DAY(CB47)-1)","v":"1900-12-30"},{"$f":"Currency","v":"USD"},{"$f":"IF(ISBLANK(PurchaseOrderNo),\"\",PurchaseOrderNo)","v":""}]
[null,null,null,"Note:  You can use copy/paste commands, or drag values down, to copy information to multiple lines."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"cc Emails",null,null,null,null,"Sales Rep"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Note: \nCustom Cuts may not be available in every country. Consult your Birches Group representative for more information.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ccemails","v":0},null,null,null,null,{"$f":"IF(ISBLANK(SalesRep),\"support@birchesgroup.com\",SalesRep)","v":"support@birchesgroup.com"},null,null,null,"Tax Gross-Up",{"$f":"U122","v":0}]
[null,null,null,"Country",null,null,null,null,null,null,null,null,null,{"$f":"\"Survey Option\"&CHAR(10)&\n\"(Indigo Subscription - \"&TEXT(UnitPrice,\"$#,###\")&CHAR(10)&\n\" Report Subscription - \"&TEXT(Reports,\"$#,###\")&\")\"","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,"Fee",null,null,null,null,"Will You Submit Data (Y/N)?",null,null,null,"Non-Participation Surcharge",null,null,null,null,"Custom Cut \n(if available)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"choose",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"choose",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Organization Name","Order Number","Class","Data:Annual Report Purchase:Annual","Data:Annual Indigo Purchase:Subscription","Custom Cut Description","Data:Specialized Data:Custom Cut","Data:General Fees:Non-Participant Fee","Group Total"]
[null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(N53),\"\",IF(N53=\"Report Subscription\",Reports,UnitPrice))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AF53=\"Yes\",0,IF(ISBLANK(N53),\"\",AA53))","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,{"$f":"OrgName","v":0},{"$f":"OrderNumber","v":0},{"$f":"IF(ISBLANK(D53),\"\",D53)","v":""},{"$f":"IF(N53=\"Report Subscription\",AA53,0)","v":0},{"$f":"IF(N53=\"Indigo™ Interactive Access\",AA53,0)","v":0},{"$f":"IF(ISBLANK(AO53),\"\",AO53)","v":""},{"$f":"IF(AO53=\"All Cycles\",CustomAll,0)+IF(OR(AO53=\"Cycle 1 (Apr)\",AO53= \"Cycle 2 (Jul)\",AO53= \"Cycle 3 (Oct)\"),CustomCut,0)","v":0},{"$f":"AJ53","v":""},{"$f":"SUM(BT53,BP53,BQ53,BS53)","v":0}]
[null,null,{"$f":"C53+1","v":2},null,null,null,null,null,null,null,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":"IF(AF54=\"Yes\",0,IF(ISBLANK(N54),\"\",AA54))","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,0,0,"",0,0,"",0,"",0]
[null,null,{"$f":"C54+1","v":3},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,0,"",0,"",0]
[null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,0,"",0,"",0]
[null,null,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,0,"",0,"",0]
[null,null,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,0,"",0,"",0]
[null,null,7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,0,"",0,"",0]
[null,null,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,0,"",0,"",0]
[null,null,9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,0,"",0,"",0]
[null,null,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,0,0,"",0,0,"",0,"",0]
[null,null,11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,0,"",0,"",0]
[null,null,12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,0,"",0,"",0]
[null,null,13,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,0,"",0,"",0]
[null,null,14,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,0,"",0,"",0]
[null,null,15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,0,"",0,"",0]
[null,null,16,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,0,"",0,"",0]
[null,null,17,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,0,"",0,"",0]
[null,null,18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,0,"",0,"",0]
[null,null,19,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,0,"",0,"",0]
[null,null,20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,0,"",0,"",0]
[null,null,21,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,0,"",0,"",0]
[null,null,22,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,0,"",0,"",0]
[null,null,23,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,0,"",0,"",0]
[null,null,24,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,0,"",0,"",0]
[null,null,25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,0,"",0,"",0]
[null,null,26,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,0,"",0,"",0]
[null,null,27,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,0,"",0,"",0]
[null,null,28,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,0,"",0,"",0]
[null,null,29,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,0,"",0,"",0]
[null,null,30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,0,"",0,"",0]
[null,null,31,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,0,"",0,"",0]
[null,null,32,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,0,"",0,"",0]
[null,null,33,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(N85),\"\",IF(N85=\"Report Subscription\",Reports,UnitPrice))","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,0,0,{"$f":"IF(ISBLANK(D85),\"\",D85)","v":""},{"$f":"IF(N85=\"Report Subscription\",AA85,0)","v":0},{"$f":"IF(N85=\"Indigo™ Interactive Access\",AA85,0)","v":0},{"$f":"IF(ISBLANK(AO85),\"\",AO85)","v":""},{"$f":"IF(AO85=\"All Cycles\",CustomAll,0)+IF(OR(AO85=\"Cycle 1 (Apr)\",AO85= \"Cycle 2 (Jul)\",AO85= \"Cycle 3 (Oct)\"),CustomCut,0)","v":0},{"$f":"AJ85","v":""},{"$f":"SUM(BT85,BP85,BQ85,BS85)","v":0}]
[null,null,34,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,0,"",0,"",0]
[null,null,35,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,0,"",0,"",0]
[null,null,36,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,0,"",0,"",0]
[null,null,37,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,0,"",0,"",0]
[null,null,38,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,0,"",0,"",0]
[null,null,39,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,0,"",0,"",0]
[null,null,40,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,0,"",0,"",0]
[null,null,41,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,0,"",0,"",0]
[null,null,42,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,0,"",0,"",0]
[null,null,43,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,0,"",0,"",0]
[null,null,44,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,0,"",0,"",0]
[null,null,45,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,0,"",0,"",0]
[null,null,46,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,0,"",0,"",0]
[null,null,47,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,0,"",0,"",0]
[null,null,48,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,0,"",0,"",0]
[null,null,49,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,0,"",0,"",0]
[null,null,50,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,0,"",0,"",0]
[null,null,51,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,0,"",0,"",0]
[null,null,52,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,0,"",0,"",0]
[null,null,53,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,0,"",0,"",0]
[null,null,54,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,0,"",0,"",0]
[null,null,55,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,0,"",0,"",0]
[null,null,56,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,0,"",0,"",0]
[null,null,57,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,0,"",0,"",0]
[null,null,58,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,0,"",0,"",0]
[null,null,59,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,0,"",0,"",0]
[null,null,60,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"",0,0,"",0,"",0]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Surveys",null,null,null,null,null,null,null,null,"Non-Particiption Fee",null,null,null,null,null,null,null,null,null,null,"Total",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"OrgName","v":0},{"$f":"OrderNumber","v":0},{"$f":"'Country Selection'!TotalIndigo","v":0},null,{"$f":"SUM(BQ53:BQ112)","v":0},null,{"$f":"SUM(BS53:BS112)","v":0},{"$f":"SUM(BT53:BT112)","v":0},{"$f":"SUM(BU53:BU112)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Fees",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AA53:AE112)","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(AJ53:AJ112)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"AA116+AJ116","v":0}]
[]
[null,null,null,null,"Note:  All fees are net of tax.  If any  income tax, withholding tax, VAT or similar taxes are payable, the invoice amount will be"]
[null,null,null,null,"increased (grossed-up) and taxes will be withheld from the resulting balance."]
[]
[null,null,null,null,{"$f":"\"Tax rate applicable in \"&IF(AF34=\"\",AF22,AF34)&\":\"","v":"Tax rate applicable in Algeria:"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP(IF(AF34=\"\",AF22,AF34),GrossUps,2,FALSE)*IF(AB121=\"\",1,0),\"Not Applicable\")","v":"Not Applicable"},null,null,null,null,null,null,null,null,null,"Type X to cancel application of tax"]
[null,null,null,null,"Tax Gross-up Amount:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U121=\"Not Applicable\",0,ROUND((AU116/(1-U121))-AU116,2))","v":0}]
[]
[]
[]
[null,null,"Subscription Agreement"]
[null,null,"All data is sold via subscription for a 12-month period, beginning on the Subscription Start Date you entered on the first Order Form Page"]
[null,null,"Three survey updates are issued annually, in April, July and October.  Participants must contribute their organization's data once "]
[null,null,"  per year, within 60 days following annual pay review, or be subject to a non-participant surcharge (see Subscription Agreement, paragraph 18)."]
[]
[null,null,"All subscriptions require confirmation of Terms and Conditions via our Subscription Agreement.  "]
[]
[null,null,"Click HERE to review the terms and conditions and confirm your agreement."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,{"$f":"IF(Agreement=TRUE,\"Agreement Confirmed\",\"Agreement NOT Confirmed\")","v":"Agreement NOT Confirmed"}]
[]
[null,null,"Notes / Special Billing Requests"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Country Information"]
[null,null,null,"Please indicate below, for each country in which you registered, the requested information."]
[null,null,null,"When finished, click on Go to Survey Access to continue."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pay Review Frequency",null,null,null,null,null,null,null,null,"Data Submission Month",null,null,null,null,null,null,null,null,"Data Submission Cycle"]
[null,null,null,null,"Survey Country",null,null,null,null,null,null,null,null,"Total Staff Count",null,null,null,null,null,null,null,null,"Next Pay Review Date"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(VLOOKUP(AO152,DataCycles,2,FALSE),\"\")","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(VLOOKUP(AO184,DataCycles,2,FALSE),\"\")","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[null,null,"RETURN COMPLETED FORM TO YOUR ACCOUNT EXECUTIVE"]
[]
[]
[null,null,null,null,"Then, send an email to:",null,null,null,null,null,null,null,null,null,"registration@birchesgroup.com",null,null,null,null,null,null,null,null,null,null,null,null,"and ATTACH THIS FILE to your email."]
[]
[]
[null,null,"© 2013 Birches Group LLC"]

{"sheet":"QueryResult","index":5,"n_rows":69,"n_cols":9,"rows_kept":69,"cut":false,"hidden":true,"merged":[]}
["Region","Country","Type x to Select",null,"All Countries",null,null,null,{"$f":"'Country Selection'!TotalIndigo","v":0}]
[null,null,null,null,"Country"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Brazil"]
[null,null,null,null,"British Virgin Islands"]
[null,null,null,null,"Cayman Islands"]
[null,null,null,null,"Chile"]
[null,null,null,null,"Colombia"]
[null,null,null,null,"Costa Rica"]
[null,null,null,null,"Cuba"]
[null,null,null,null,"Curaçao"]

{"sheet":"Country Selection","index":6,"n_rows":213,"n_cols":235,"rows_kept":213,"cut":false,"hidden":false,"merged":[[1,74,1,81],[1,0,1,3],[1,42,1,49],[1,50,1,57],[1,58,1,65],[1,66,1,73],[1,170,1,177],[1,82,1,89],[1,90,1,97],[1,98,1,105],[1,106,1,113],[1,114,1,121],[1,122,1,129],[1,226,1,233],[1,234,1,241],[2,0,2,3],[185,1,185,3],[189,2,190,2],[1,178,1,185],[1,186,1,193],[1,194,1,201],[1,202,1,209],[1,210,1,217],[1,218,1,225],[1,130,1,137],[1,138,1,145],[1,146,1,153],[1,154,1,161],[1,162,1,169]]}
[]
["Birches Group Surveys",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2012 Birches Group Surveys",null,null,null,null,null,null,null,"2012 Birches Group Surveys",null,null,null,null,null,null,null,"2012 Birches Group Surveys",null,null,null,null,null,null,null,"2012 Birches Group Surveys",null,null,null,null,null,null,null,"2012 Birches Group Surveys",null,null,null,null,null,null,null,"2012 Birches Group Surveys",null,null,null,null,null,null,null,"2012 Birches Group Surveys",null,null,null,null,null,null,null,"2012 Birches Group Surveys",null,null,null,null,null,null,null,"2012 Birches Group Surveys",null,null,null,null,null,null,null,"2012 Birches Group Surveys",null,null,null,null,null,null,null,"2012 Birches Group Surveys",null,null,null,null,null,null,null,"2012 Birches Group Surveys",null,null,null,null,null,null,null,"2012 Birches Group Surveys",null,null,null,null,null,null,null,"2012 Birches Group Surveys",null,null,null,null,null,null,null,"2012 Birches Group Surveys",null,null,null,null,null,null,null,"2012 Birches Group Surveys",null,null,null,null,null,null,null,"2012 Birches Group Surveys",null,null,null,null,null,null,null,"2012 Birches Group Surveys",null,null,null,null,null,null,null,"2012 Birches Group Surveys",null,null,null,null,null,null,null,"2012 Birches Group Surveys",null,null,null,null,null,null,null,"2012 Birches Group Surveys",null,null,null,null,null,null,null,"2012 Birches Group Surveys",null,null,null,null,null,null,null,"2012 Birches Group Surveys",null,null,null,null,null,null,null,"2012 Birches Group Surveys",null,null,null,null,null,null,null,"2012 Birches Group Surveys"]
["Country Selection Form",null,null,null,"Total Countries",{"$f":"COUNTIF(D8:D181,\"=x\")","v":0}]
["Please type an X in the boxes corresponding to your survey choices"]
["After completing your selections, press SUBMIT on the right of this page -->"]
[]
[null,"Region","Country","Type x to Select"]
[null,"Asia","Afghanistan"]
[null,"Europe","Albania"]
[null,"Africa","Algeria"]
[null,"Africa","Angola"]
[null,"Americas","Argentina"]
[null,"Asia","Armenia"]
[null,"Oceania","Australia"]
[null,"Europe","Austria"]
[null,"Asia","Azerbaijan"]
[null,"Americas","Bahamas"]
[null,"Asia","Bahrain"]
[null,"Asia","Bangladesh"]
[null,"Americas","Barbados"]
[null,"Europe","Belarus"]
[null,"Europe","Belgium"]
[null,"Americas","Belize"]
[null,"Africa","Benin"]
[null,"Americas","Bermuda"]
[null,"Asia","Bhutan"]
[null,"Americas","Bolivia"]
[null,"Europe","Bosnia and Herzegovina"]
[null,"Africa","Botswana"]
[null,"Americas","Brazil"]
[null,"Americas","British Virgin Islands"]
[null,"Asia","Brunei"]
[null,"Europe","Bulgaria"]
[null,"Africa","Burkina Faso"]
[null,"Africa","Burundi"]
[null,"Asia","Cambodia"]
[null,"Africa","Cameroon"]
[null,"Africa","Cape Verde"]
[null,"Americas","Cayman Islands"]
[null,"Africa","Central African Republic"]
[null,"Africa","Chad"]
[null,"Americas","Chile"]
[null,"Asia","China"]
[null,"Americas","Colombia"]
[null,"Africa","Comoros"]
[null,"Africa","Congo, DR"]
[null,"Africa","Congo, Republic of the"]
[null,"Americas","Costa Rica"]
[null,"Africa","Cote D'Ivoire"]
[null,"Europe","Croatia"]
[null,"Americas","Cuba"]
[null,"Americas","Curaçao"]
[null,"Africa","Djibouti"]
[null,"Americas","Dominican Republic"]
[null,"Americas","Ecuador"]
[null,"Africa","Egypt"]
[null,"Americas","El Salvador"]
[null,"Africa","Equatorial Guinea"]
[null,"Africa","Eritrea"]
[null,"Europe","Estonia"]
[null,"Africa","Eswatini"]
[null,"Africa","Ethiopia"]
[null,"Oceania","Fiji"]
[null,"Europe","France"]
[null,"Africa","Gabon"]
[null,"Africa","Gambia"]
[null,"Asia","Georgia"]
[null,"Europe","Germany"]
[null,"Africa","Ghana"]
[null,"Americas","Grenada"]
[null,"Americas","Guatemala"]
[null,"Africa","Guinea"]
[null,"Africa","Guinea-Bissau"]
[null,"Americas","Guyana"]
[null,"Americas","Haiti"]
[null,"Americas","Honduras"]
[null,"Asia","Hong Kong"]
[null,"Asia","India"]
[null,"Asia","Indonesia"]
[null,"Asia","Iran"]
[null,"Asia","Iraq"]
[null,"Asia","Israel"]
[null,"Europe","Italy"]
[null,"Americas","Jamaica"]
[null,"Asia","Japan"]
[null,"Asia","Jordan"]
[null,"Asia","Kazakhstan"]
[null,"Africa","Kenya"]
[null,"Oceania","Kiribati"]
[null,"Europe","Kosovo"]
[null,"Asia","Kuwait"]
[null,"Asia","Kyrgyzstan"]
[null,"Asia","Laos"]
[null,"Europe","Latvia"]
[null,"Asia","Lebanon"]
[null,"Africa","Lesotho"]
[null,"Africa","Liberia"]
[null,"Africa","Libya"]
[null,"Europe","Lithuania"]
[null,"Africa","Madagascar"]
[null,"Africa","Malawi"]
[null,"Asia","Malaysia"]
[null,"Asia","Maldives"]
[null,"Africa","Mali"]
[null,"Europe","Malta"]
[null,"Oceania","Marshall Islands"]
[null,"Africa","Mauritania"]
[null,"Africa","Mauritius"]
[null,"Americas","Mexico"]
[null,"Oceania","Micronesia, Federated States of"]
[null,"Europe","Moldova"]
[null,"Asia","Mongolia"]
[null,"Europe","Montenegro"]
[null,"Africa","Morocco"]
[null,"Africa","Mozambique"]
[null,"Asia","Myanmar"]
[null,"Africa","Namibia"]
[null,"Asia","Nepal"]
[null,"Europe","Netherlands"]
[null,"Americas","Nicaragua"]
[null,"Africa","Niger"]
[null,"Africa","Nigeria"]
[null,"Europe","North Macedonia"]
[null,"Asia","Oman"]
[null,"Asia","Pakistan"]
[null,"Oceania","Palau"]
[null,"Americas","Panama"]
[null,"Oceania","Papua New Guinea"]
[null,"Americas","Paraguay"]
[null,"Americas","Peru"]
[null,"Asia","Philippines"]
[null,"Europe","Poland"]
[null,"Europe","Portugal"]
[null,"Asia","Qatar"]
[null,"Europe","Romania"]
[null,"Europe","Russia"]
[null,"Africa","Rwanda"]
[null,"Oceania","Samoa"]
[null,"Africa","Sao Tome & Principe"]
[null,"Asia","Saudi Arabia"]
[null,"Africa","Senegal"]
[null,"Europe","Serbia"]
[null,"Africa","Seychelles"]
[null,"Africa","Sierra Leone"]
[null,"Asia","Singapore",null,"  International Public Sector only"]
[null,"Americas","Sint Maarten"]
[null,"Europe","Slovakia"]
[null,"Europe","Slovenia"]
[null,"Oceania","Solomon Islands"]
[null,"Africa","Somalia",null,"  International Public Sector only"]
[null,"Africa","South Africa",null,"  International Public Sector only"]
[null,"Asia","South Korea",null,"  International Public Sector only"]
[null,"Africa","South Sudan"]
[null,"Asia","Sri Lanka"]
[null,"Africa","Sudan"]
[null,"Americas","Suriname"]
[null,"Europe","Switzerland"]
[null,"Asia","Syria"]
[null,"Asia","Taiwan"]
[null,"Asia","Tajikistan"]
[null,"Africa","Tanzania"]
[null,"Asia","Thailand"]
[null,"Asia","Timor-Leste"]
[null,"Africa","Togo"]
[null,"Oceania","Tonga"]
[null,"Americas","Trinidad and Tobago"]
[null,"Africa","Tunisia"]
[null,"Asia","Turkey",null,"  International Public Sector only"]
[null,"Asia","Turkmenistan"]
[null,"Africa","Uganda",null,"  International Public Sector only"]
[null,"Europe","Ukraine"]
[null,"Asia","United Arab Emirates"]
[null,"Europe","United Kingdom"]
[null,"Americas","Uruguay"]
[null,"Asia","Uzbekistan"]
[null,"Oceania","Vanuatu"]
[null,"Americas","Venezuela"]
[null,"Asia","Vietnam"]
[null,"Asia","Yemen"]
[null,"Africa","Zambia"]
[null,"Africa","Zimbabwe"]
[null,null,""]
[]
[null,null,""]
[]
[null,"After selecting your countrie(s), press SUBMIT above to continue"]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[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":"BG Use Only","index":7,"n_rows":416,"n_cols":31,"rows_kept":416,"cut":false,"hidden":true,"merged":[[194,28,194,30],[194,13,194,15],[194,16,194,18],[194,19,194,21],[194,22,194,24],[194,25,194,27]]}
["State",null,"Country",null,"Select","Salutation"]
["US States",null,"United States",null,"X","Mr","DataCycles"]
["Alabama","AL","Afghanistan",null,null,"Ms","January","Cycle 1"]
["Alaska","AK","Albania",null,null,"Mrs","February","Cycle 2"]
["Arizona","AZ","Algeria",null,null,"Dr","March","Cycle 2"]
["Arkansas","AR","American Samoa",null,null,null,"April","Cycle 2"]
["California","CA","Andorra",null,null,null,"May","Cycle 3"]
["Colorado","CO","Angola",null,null,null,"June","Cycle 3"]
["Connecticut","CT","Anguilla",null,"SurveyChoice",null,"July","Cycle 3"]
["District of Columbia","DC","Antarctica",null,"Indigo™ Interactive Access",null,"August","Cycle 1"]
["Delaware","DE","Antigua And Barbuda",null,"Report Subscription",null,"September","Cycle 1"]
["Florida","FL","Argentina",null,null,null,"October","Cycle 1"]
["Georgia","GA","Armenia",null,null,null,"November","Cycle 1"]
["Hawaii","HI","Aruba",null,"Yes",null,"December","Cycle 1"]
["Idaho","ID","Australia",null,"No"]
["Illinois","IL","Austria"]
["Indiana","IN","Azerbaijan"]
["Iowa","IA","Bahamas",null,"Non-Participant Surcharge",null,"Pay Cycles"]
["Kansas","KS","Bahrain",null,{"$f":"IF(OR(MultiPart=\"Yes\",SinglePart=\"Yes\"),0,0.5)","v":{"$error":"#NAME?"}},null,"Annual"]
["Kentucky","KY","Bangladesh",null,null,null,"Every 2 Years"]
["Louisiana","LA","Barbados",null,null,null,"Ad-hoc"]
["Maine","ME","Belarus"]
["Maryland","MD","Belgium",null,"Product Selection"]
["Massachusetts","MA","Belize",null,"Preferred Partner",null,"Controls for SO Extract"]
["Michigan","MI","Benin",null,"Ad-hoc Subscriber"]
["Minnesota","MN","Bermuda",null,null,null,"Select"]
["Mississippi","MS","Bhutan",null,null,null,"MS"]
["Missouri","MO","Bolivia",null,"Custom Cut Select",null,"NGO"]
["Montana","MT","Bosnia And Herzegovina",null,"Cycle 1 (Apr)",null,"MS & NGO"]
["Nebraska","NE","Botswana",null,"Cycle 2 (Jul)"]
["Nevada","NV","Bouvet Island",null,"Cycle 3 (Oct)",null,"Select"]
["New Hampshire","NH","Brazil",null,"All Cycles",null,"New"]
["New Jersey","NJ","British Indian Ocean Territory",null,null,null,"Update"]
["New Mexico","NM","British Virgin Islands",null,null,null,"Update (treat as NEW)"]
["New York","NY","Brunei Darussalam"]
["North Carolina","NC","Bulgaria",null,null,null,"Select"]
["North Dakota","ND","Burkina Faso",null,null,null,"English"]
["Ohio","OH","Burundi",null,null,null,"French"]
["Oklahoma","OK","Cambodia",null,null,null,"Spanish"]
["Oregon","OR","Cameroon",null,null,null,"Multi-language"]
["Pennsylvania","PA","Canada"]
["Rhode Island","RI","Cape Verde",null,null,null,"Select"]
["South Carolina","SC","Cayman Islands",null,null,null,"Data Collection and Entry"]
["South Dakota","SD","Central African Republic",null,null,null,"Data Entry Only"]
["Tennessee","TN","Chad"]
["Texas","TX","Chile",null,null,null,"Select"]
["Utah","UT","China",null,null,null,"Paying"]
["Vermont","VT","Christmas Island",null,null,null,"Non-Paying"]
["Virginia","VA","Cocos (Keeling) Islands"]
["Washington","WA","Colombia"]
["West Virginia","WV","Comoros"]
["Wisconsin","WI","Congo, DR"]
["Wyoming","WY","Congo, Republic of"]
["Canadian Provinces and Territories",null,"Cook Islands"]
["Alberta","AB","Costa Rica"]
["British Columbia","BC","Cote D'Ivoire"]
["Manitoba","MB","Croatia"]
["New Brunswick","NB","Cuba"]
["Newfoundland","NL","Cyprus"]
["Northwest Territories","NT","Czech Republic"]
["Nova Scotia","NS","Denmark"]
["Nunavut","NU","Djibouti"]
["Ontario","ON","Dominica"]
["Prince Edward Island","PE","Dominican Republic"]
["Quebec","QC","Ecuador"]
["Saskatchewan","SK","Egypt"]
["Yukon Territory","YT","El Salvador"]
[null,null,"Equatorial Guinea"]
[null,null,"Eritrea"]
[null,null,"Estonia"]
[null,null,"Eswatini"]
[null,null,"Ethiopia",null,null,null,null,null,null,null,"COUNTRY","Tax Rate for Services"]
[null,null,"Falkland Islands",null,null,null,null,null,null,null,"Chad",0.25]
[null,null,"Faroe Islands",null,null,null,null,null,null,null,"Burkina Faso",0.2]
[null,null,"Fiji",null,null,null,null,null,null,null,"Cambodia",0.14000000000000001]
[null,null,"Finland",null,null,null,null,null,null,null,"China",6.7900000000000002E-2]
[null,null,"France",null,null,null,null,null,null,null,"Ethiopia",0.15]
[null,null,"French Guiana",null,null,null,null,null,null,null,"Gabon",0.1]
[null,null,"French Polynesia",null,null,null,null,null,null,null,"Ghana",0.2]
[null,null,"French Southern Territories",null,null,null,null,null,null,null,"Haiti",0.2]
[null,null,"Gabon",null,null,null,null,null,null,null,"India",0.3]
[null,null,"Gambia",null,null,null,null,null,null,null,"Kenya",0.2]
[null,null,"Georgia",null,null,null,null,null,null,null,"Laos",0.1]
[null,null,"Germany",null,null,null,null,null,null,null,"Lebanon",7.4999999999999997E-2]
[null,null,"Ghana",null,null,null,null,null,null,null,"Malawi",0.15]
[null,null,"Gibraltar",null,null,null,null,null,null,null,"Mongolia",0.2]
[null,null,"Greece",null,null,null,null,null,null,null,"Mozambique",0.15]
[null,null,"Greenland",null,null,null,null,null,null,null,"Nicaragua",0.15]
[null,null,"Grenada",null,null,null,null,null,null,null,"Pakistan",0.15]
[null,null,"Guadeloupe",null,null,null,null,null,null,null,"Philippines",0.1]
[null,null,"Guam",null,null,null,null,null,null,null,"Rwanda",0.15]
[null,null,"Guatemala",null,null,null,null,null,null,null,"Sierra Leone ",0.1]
[null,null,"Guinea",null,null,null,null,null,null,null,"South Africa",0.15]
[null,null,"Guinea-Bissau",null,null,null,null,null,null,null,"South Sudan",0.2]
[null,null,"Guyana",null,null,null,null,null,null,null,"Turkmenistan",0.1]
[null,null,"Haiti",null,null,null,null,null,null,null,"Uganda",0.15]
[null,null,"Heard Island & Mcdonald Islands",null,null,null,null,null,null,null,"Tanzania",0.15]
[null,null,"Honduras"]
[null,null,"Hong Kong"]
[null,null,"Hungary"]
[null,null,"Iceland"]
[null,null,"India"]
[null,null,"Indonesia"]
[null,null,"Iran"]
[null,null,"Iraq"]
[null,null,"Ireland"]
[null,null,"Israel"]
[null,null,"Italy"]
[null,null,"Jamaica"]
[null,null,"Japan"]
[null,null,"Jordan"]
[null,null,"Kazakhstan"]
[null,null,"Kenya"]
[null,null,"Kiribati"]
[null,null,"Korea, Republic Of"]
[null,null,"Kuwait"]
[null,null,"Kyrgyzstan"]
[null,null,"Lao"]
[null,null,"Latvia"]
[null,null,"Lebanon"]
[null,null,"Lesotho"]
[null,null,"Liberia"]
[null,null,"Libya"]
[null,null,"Liechtenstein"]
[null,null,"Lithuania"]
[null,null,"Luxembourg"]
[null,null,"Macau"]
[null,null,"Madagascar"]
[null,null,"Malawi"]
[null,null,"Malaysia"]
[null,null,"Maldives"]
[null,null,"Mali"]
[null,null,"Malta"]
[null,null,"Marshall Islands"]
[null,null,"Martinique"]
[null,null,"Mauritania"]
[null,null,"Mauritius"]
[null,null,"Mayotte"]
[null,null,"Mexico"]
[null,null,"Micronesia"]
[null,null,"Moldova"]
[null,null,"Monaco"]
[null,null,"Mongolia"]
[null,null,"Montserrat"]
[null,null,"Morocco"]
[null,null,"Mozambique"]
[null,null,"Myanmar"]
[null,null,"Namibia"]
[null,null,"Nauru"]
[null,null,"Nepal"]
[null,null,"Netherlands"]
[null,null,"Netherlands Antilles",null,null,null,null,null,null,null,null,null,null,"first 0"]
[null,null,"New Caledonia",null,null,null,null,null,null,null,null,null,null,"Range of selected"]
[null,null,"New Zealand"]
[null,null,"Nicaragua"]
[null,null,"Niger"]
[null,null,"Nigeria"]
[null,null,"Niue"]
[null,null,"Norfolk Island"]
[null,null,"North Macedonia",null,"2024-04-01"]
[null,null,"Northern Mariana Islands",null,null,"Indigo™ Interactive Data Subscription ","Preferred Partner Program\n(3 Year Commitment)","Report Subscription"]
[null,null,"Norway",null,"Number of Countries","- - - - - - - -- - - - - - - - - - - - All fees are Per Country - - - - - - - - - - - - - - - - - - - "]
[null,null,"Oman",null,1,2300,{"$error":"#N/A"},2015]
[null,null,"Pakistan",null,10,2070,1395,1815]
[null,null,"Palau",null,25,1955,1200,1815]
[null,null,"Panama",null,35,1840,1085,1815]
[null,null,"Papua New Guinea",null,45,1610,1020,1815]
[null,null,"Paraguay"]
[null,null,"Peru"]
[null,null,"Philippines"]
[null,null,"Pitcairn"]
[null,null,"Poland",null,"2023-04-01"]
[null,null,"Portugal",null,null,"Indigo™ Interactive Data Subscription ","Preferred Partner Program\n(3 Year Commitment)","Report Subscription"]
[null,null,"Puerto Rico",null,"Number of Countries","- - - - - - - -- - - - - - - - - - - - All fees are Per Country - - - - - - - - - - - - - - - - - - - ",null,null,null,null,null,"Disc"]
[null,null,"Qatar",null,1,2200,{"$f":"NA()","v":{"$error":"#N/A"}},1925]
[null,null,"Reunion",null,10,1980,1340,1735,null,null,null,{"$f":"1-(G177/$G$176)","v":0.10447761194029848}]
[null,null,"Romania",null,25,1870,1200,{"$f":"H176","v":1735},null,null,null,{"$f":"1-(G178/$G$176)","v":0.17910447761194026}]
[null,null,"Russian Federation",null,35,1765,1100,{"$f":"H176","v":1735},null,null,null,0.29104477611940294]
[null,null,"Rwanda",null,45,1560,950,{"$f":"H176","v":1735}]
[null,null,"Saint Helena"]
[null,null,"Saint Kitts And Nevis"]
[null,null,"Saint Lucia"]
[null,null,"Saint Pierre And Miquelon"]
[null,null,"Saint Vincent And The Grenadines"]
[null,null,"Samoa",null,"2022-04-01",null,null,null,null,null,null,null,"This table is impacted by prior price flag",null,null,null,null,null,null,"This table is fed from table to the left"]
[null,null,"San Marino",null,null,"Indigo™ Interactive Data Subscription ","Preferred Partner Program\n(3 Year Commitment)","Report Subscription",null,null,null,null,"countries","Indigo™","Preferred Partner","Report Sub"]
[null,null,"Sao Tome And Principe",null,"Number of Countries","- - - - - - - -- - - - - - - - - - - - All fees are Per Country - - - - - - - - - - - - - - - - - - - ",null,null,null,null,null,null,1,{"$f":"IF(PriorPrice=\"Yes\",F197,F188)","v":2100},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"H188","v":1840},null,null,null,1,{"$f":"N187","v":2100},{"$f":"O187","v":{"$error":"#N/A"}}]
[null,null,"Saudi Arabia",null,1,2100,{"$f":"NA()","v":{"$error":"#N/A"}},1840,null,null,null,null,10,{"$f":"IF(PriorPrice=\"Yes\",F198,F189)","v":1900},{"$f":"IF(PriorPrice=\"Yes\",G198,G189)","v":1270},1650,null,null,null,10,{"$f":"N188","v":1900},{"$f":"O188","v":1270}]
[null,null,"Senegal",null,10,1900,1270,1650,null,null,null,{"$f":"1-(F189/$F$188)","v":9.5238095238095233E-2},25,{"$f":"IF(PriorPrice=\"Yes\",F199,F190)","v":1800},1100,1650,null,null,null,25,1800,1100]
[null,null,"Serbia",null,25,1800,1100,{"$f":"H189","v":1650},null,null,null,{"$f":"1-(F190/$F$188)","v":0.1428571428571429},35,{"$f":"IF(PriorPrice=\"Yes\",F200,F191)","v":1700},995,1650,null,null,null,35,1700,995]
[null,null,"Seychelles",null,35,1700,995,{"$f":"H189","v":1650},null,null,null,{"$f":"1-(F191/$F$188)","v":0.19047619047619047},45,{"$f":"IF(PriorPrice=\"Yes\",F201,F192)","v":1500},900,1650,null,null,null,45,1500,900]
[null,null,"Sierra Leone",null,45,1500,900,{"$f":"H189","v":1650},null,null,null,{"$f":"1-(F192/$F$188)","v":0.2857142857142857}]
[null,null,"Singapore"]
[null,null,"Sint Maarten",null,"Prior Pricing Schedule",null,null,null,null,null,null,null,1,{"$f":"1+M194","v":2},{"$f":"1+N194","v":3},4,5,6,7,8,9,10,11,12,13,14,15,16,{"$f":"1+AB194","v":17},{"$f":"1+AC194","v":18},{"$f":"1+AD194","v":19}]
[null,null,"Slovak Republic",null,null,"Indigo™ Interactive Data Subscription ","Preferred Partner Program\n(3 Year Commitment)","Report Subscription",null,null,null,null,null,2021,null,null,2022,null,null,2023,null,null,2024,null,null,2025,null,null,2025]
[null,null,"Slovenia",null,"Number of Countries","- - - - - - - -- - - - - - - - - - - - All fees are Per Country - - - - - - - - - - - - - - - - - - - ",null,null,null,null,null,null,"countries","Indigo™","Preferred Partner","Report Sub","Indigo™","Preferred Partner","Report Sub","Indigo™","Preferred Partner","Report Sub","Indigo™","Preferred Partner","Report Sub","Indigo™","Preferred Partner","Report Sub","Indigo™","Preferred Partner","Report Sub"]
[null,null,"Solomon Islands",null,1,2000,{"$f":"NA()","v":{"$error":"#N/A"}},1750,null,null,null,null,1,2000,{"$f":"NA()","v":{"$error":"#N/A"}},1750,2100,{"$error":"#N/A"},1840,2200,{"$error":"#N/A"},1925,2300,{"$error":"#N/A"},2015,2420,{"$error":"#N/A"},2120,2420,{"$error":"#N/A"},2120]
[null,null,"Somalia",null,10,{"$f":"F197*0.9","v":1800},1200,1575,null,null,null,null,10,{"$f":"N197*0.9","v":1800},1200,1575,1900,1270,1650,1980,1325,1735,2070,1395,1815,2180,1460,1910,2180,1460,1910]
[null,null,"South Africa",null,25,{"$f":"F197*0.85","v":1700},1050,1575,null,null,null,null,25,{"$f":"N197*0.85","v":1700},1050,1575,1800,1100,1650,1870,1145,1735,1955,1200,1815,2050,1250,1910,2050,1250,1910]
[null,null,"South Sudan",null,35,{"$f":"F197*0.8","v":1600},925,1575,null,null,null,null,35,{"$f":"N197*0.8","v":1600},925,1575,1700,995,1650,1760,1030,1735,1840,1085,1815,1935,1130,1910,1935,1130,1910]
[null,null,"Spain",null,45,1400,800,1575,null,null,null,null,45,1400,800,1575,1500,900,1650,1540,960,1735,1610,1020,1815,1700,1060,1910,1700,1060,1910]
[null,null,"Sri Lanka"]
[null,null,"Sudan"]
[null,null,"Suriname"]
[null,null,"Svalbard And Jan Mayen Islands"]
[null,null,"Sweden"]
[null,null,"Switzerland"]
[null,null,"Syria"]
[null,null,"Taiwan"]
[null,null,"Tajikistan",null,null,null,null,null,null,null,null,null,"Prior Year Flag",null,{"$f":"'Order Form'!S34","v":"No"},"This determines which year's pricing serves as the base under a three-year contract",null,null,null,null,null,null,null,null,"Prior Year Flag","Indigo™","Reports"]
[null,null,"Tanzania",null,null,null,null,null,null,null,null,null,"Column Pointer",null,{"$f":"VLOOKUP(O210,PriorYearColumn,2,FALSE)","v":11},"This determines the lookup column in the appropriate year",null,null,null,null,null,null,null,null,"No",11,{"$f":"Z211+2","v":13}]
[null,null,"Thailand",null,null,null,false,"<-- This cell tracks if the Subscription Agreement is acknowledged or not",null,null,null,null,"Product Option",null,"Count",null,null,null,null,null,null,null,null,null,"Yes22",8,{"$f":"Z212+2","v":10}]
[null,null,"Timor-Leste",null,null,null,null,null,null,null,null,null,{"$f":"ProductSelectionChoice","v":0},null,{"$f":"'Country Selection'!TotalIndigo","v":0},{"$f":"IF(M213=\"Ad-hoc Subscriber\",0,1)","v":1},null,null,null,null,null,null,null,null,"Yes21",5,{"$f":"Z213+2","v":7}]
[null,null,"Togo",null,null,null,null,null,null,null,null,null,"Reports Calc",null,{"$f":"VLOOKUP(O210,Y211:AA213,3,FALSE)","v":13}]
[null,null,"Tokelau",null,null,null,null,null,null,null,null,null,"Reports",null,{"$f":"VLOOKUP(O213,M197:Y201,O214,TRUE)","v":{"$error":"#N/A"}}]
[null,null,"Tonga",null,null,null,null,null,null,null,null,null,"Ad-hoc Indigo™ ",null,{"$f":"VLOOKUP(O213,M197:AB201,O211,TRUE)","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(O213,M197:Y201,O211,TRUE)","v":{"$error":"#N/A"}}]
[null,null,"Trinidad And Tobago",null,null,null,null,null,null,null,null,null,"Ad-hoc Indigo™ 2",null,{"$f":"VLOOKUP(O213,M197:AB201,O211+3,TRUE)","v":{"$error":"#N/A"}}]
[null,null,"Tunisia",null,null,null,null,null,null,null,null,null,"Ad-hoc Indigo™ 3",null,{"$f":"VLOOKUP(O213,M197:AE201,O211+6,TRUE)","v":{"$error":"#N/A"}}]
[null,null,"Turkey",null,null,null,null,null,null,null,null,null,"Preferred Partner YR1",null,{"$f":"VLOOKUP(O213,M197:AB201,O211+P213,TRUE)","v":{"$error":"#N/A"}}]
[null,null,"Turkmenistan",null,null,null,null,null,null,null,null,null,"Preferred Partner YR2",null,{"$f":"IF(O210=\"Yes21\",VLOOKUP(O213,M197:O201,3,TRUE),VLOOKUP(O213,M197:AB201,O211+P213+3,TRUE))","v":{"$error":"#N/A"}}]
[null,null,"Turks And Caicos Islands",null,null,null,null,null,null,null,null,null,"Preferred Partner YR3",null,{"$f":"IF(O210=\"Yes21\",VLOOKUP(O213,M197:O201,3,TRUE),VLOOKUP(O213,M197:AE201,O211+P213+6,TRUE))","v":{"$error":"#N/A"}}]
[null,null,"Tuvalu",null,null,null,null,null,null,null,null,null,"Custom Cut",null,0]
[null,null,"Uganda",null,null,null,null,null,null,null,null,null,"Custom Cut (All Cycles)",null,0]
[null,null,"Ukraine",null,null,null,null,null,null,null,null,null,"Ad-hoc Non-Participation",null,1]
[null,null,"United Arab Emirates",null,null,null,null,null,null,null,null,null,"NP Preferred Partner Yr 1",null,{"$f":"IF($O$210=\"Yes21\",$O$219,(2*UnitPrice)-O219)","v":{"$error":"#N/A"}}]
[null,null,"United Kingdom",null,null,null,null,null,null,null,null,null,"NP Preferred Partner Yr 2",null,{"$f":"IF($O$210=\"Yes21\",$O$219,(2*O217)-O220)","v":{"$error":"#N/A"}}]
[null,null,"United States Minor Outlying Islands",null,null,null,null,null,null,null,null,null,"NP Preferred Partner Yr 3",null,{"$f":"IF($O$210=\"Yes21\",$O$219,(2*O218)-O221)","v":{"$error":"#N/A"}}]
[null,null,"Uruguay"]
[null,null,"Uzbekistan"]
[null,null,"Vanuatu"]
[null,null,"Vatican City State (Holy See)"]
[null,null,"Venezuela"]
[null,null,"Vietnam"]
[null,null,"Virgin Islands (British)"]
[null,null,"Virgin Islands (U.S.)"]
[null,null,"Wallis And Futuna Islands",null,null,null,null,null,null,null,null,null,null,"Currency"]
[null,null,"Western Sahara",null,null,null,null,null,null,null,null,null,null,"USD"]
[null,null,"Yemen",null,null,null,null,null,null,null,null,null,null,"EURO"]
[null,null,"Zambia",null,null,null,null,null,null,null,null,null,null,"GBP"]
[null,null,"Zimbabwe",null,null,null,null,null,null,null,null,null,null,"CAD"]
[]
[]
[]
[null,null,"Afghanistan","AFG"]
[null,null,"Albania","ALB"]
[null,null,"Algeria","DZA"]
[null,null,"Angola","AGO"]
[null,null,"Argentina","ARG"]
[null,null,"Armenia","ARM"]
[null,null,"Australia","AUS"]
[null,null,"Austria","AUT"]
[null,null,"Azerbaijan","AZE"]
[null,null,"Bahamas","BHS"]
[null,null,"Bahrain","BHR"]
[null,null,"Bangladesh","BGD"]
[null,null,"Barbados","BRB"]
[null,null,"Belarus","BLR"]
[null,null,"Belgium","BEL"]
[null,null,"Belize","BEN"]
[null,null,"Benin","BEL"]
[null,null,"Bermuda","BMU"]
[null,null,"Bhutan","BTN"]
[null,null,"Bolivia","BOL"]
[null,null,"Bosnia and Herzegovina","BIH"]
[null,null,"Botswana","BWA"]
[null,null,"Brazil","BRA"]
[null,null,"British Virgin Islands","VGB"]
[null,null,"Brunei","BRN"]
[null,null,"Bulgaria","BGR"]
[null,null,"Burkina Faso","BFA"]
[null,null,"Burundi","BDI"]
[null,null,"Cambodia","KHM"]
[null,null,"Cameroon","CMR"]
[null,null,"Cape Verde","CPV"]
[null,null,"Cayman Islands","CYM"]
[null,null,"Central African Republic","CAF"]
[null,null,"Chad","TCD"]
[null,null,"Chile","CHL"]
[null,null,"China","CHN"]
[null,null,"Colombia","COL"]
[null,null,"Comoros","COM"]
[null,null,"Congo, Dem Republic of","COD"]
[null,null,"Congo, Republic of the","COG"]
[null,null,"Costa Rica","CRI"]
[null,null,"Cote D'Ivoire","CIV"]
[null,null,"Croatia","HRV"]
[null,null,"Cuba","CUB"]
[null,null,"Curaçao","CUW"]
[null,null,"Djibouti","DJI"]
[null,null,"Dominican Republic","DOM"]
[null,null,"Ecuador","ECU"]
[null,null,"Egypt","EGY"]
[null,null,"El Salvador","SLV"]
[null,null,"Equatorial Guinea","GNQ"]
[null,null,"Eritrea","ERI"]
[null,null,"Estonia","EST"]
[null,null,"Eswatini","SWZ"]
[null,null,"Ethiopia","ETH"]
[null,null,"Fiji","FJI"]
[null,null,"France","FRA"]
[null,null,"Gabon","GAB"]
[null,null,"Gambia","GMB"]
[null,null,"Georgia","GEO"]
[null,null,"Germany","DEU"]
[null,null,"Ghana","GHA"]
[null,null,"Grenada","GRD"]
[null,null,"Guatemala","GTM"]
[null,null,"Guinea","GIN"]
[null,null,"Guinea-Bissau","GNB"]
[null,null,"Guyana","GUY"]
[null,null,"Haiti","HTI"]
[null,null,"Honduras","HND"]
[null,null,"Hong Kong","HKG"]
[null,null,"Iceland","ISL"]
[null,null,"India","IND"]
[null,null,"Indonesia","IDN"]
[null,null,"Iran","IRN"]
[null,null,"Iraq","IRQ"]
[null,null,"Israel","ISR"]
[null,null,"Italy","ITA"]
[null,null,"Jamaica","JAM"]
[null,null,"Japan","JPN"]
[null,null,"Jordan","JOR"]
[null,null,"Kazakhstan","KAZ"]
[null,null,"Kenya","KEN"]
[null,null,"Kiribati","KIR"]
[null,null,"Kosovo","XKX"]
[null,null,"Kuwait","KWT"]
[null,null,"Kyrgyzstan","KGZ"]
[null,null,"Laos","LAO"]
[null,null,"Latvia","LVA"]
[null,null,"Lebanon","LBN"]
[null,null,"Lesotho","LSO"]
[null,null,"Liberia","LBR"]
[null,null,"Libya","LBY"]
[null,null,"Lithuania","LTU"]
[null,null,"Madagascar","MDG"]
[null,null,"Malawi","MWI"]
[null,null,"Malaysia","MYS"]
[null,null,"Maldives","MDV"]
[null,null,"Mali","MLI"]
[null,null,"Malta","MLT"]
[null,null,"Marshall Islands","MHL"]
[null,null,"Mauritania","MRT"]
[null,null,"Mauritius","MUS"]
[null,null,"Micronesia, Federated States of","FSM"]
[null,null,"Moldova","MDA"]
[null,null,"Mongolia","MNG"]
[null,null,"Montenegro","MNE"]
[null,null,"Morocco","MAR"]
[null,null,"Mozambique","MOZ"]
[null,null,"Myanmar","MMR"]
[null,null,"Namibia","NAM"]
[null,null,"Nepal","NPL"]
[null,null,"Netherlands","NLD"]
[null,null,"Nicaragua","NIC"]
[null,null,"Niger","NER"]
[null,null,"Nigeria","NGA"]
[null,null,"North Macedonia","MKD"]
[null,null,"Oman","OMN"]
[null,null,"Pakistan","PAK"]
[null,null,"Palau","PLW"]
[null,null,"Panama","PAN"]
[null,null,"Papua New Guinea","PNG"]
[null,null,"Paraguay","PRY"]
[null,null,"Peru","PER"]
[null,null,"Philippines","PHL"]
[null,null,"Poland","POL"]
[null,null,"Portugal","PRT"]
[null,null,"Qatar","QAT"]
[null,null,"Romania","ROU"]
[null,null,"Russia","RUS"]
[null,null,"Rwanda","RWA"]
[null,null,"Samoa","WSM"]
[null,null,"Sao Tome & Principe","STP"]
[null,null,"Saudi Arabia","SAU"]
[null,null,"Senegal","SEN"]
[null,null,"Serbia","SRB"]
[null,null,"Seychelles","SYC"]
[null,null,"Sierra Leone","SLE"]
[null,null,"Singapore","SGP"]
[null,null,"Sint Maarten","ANT"]
[null,null,"Slovakia","SVK"]
[null,null,"Slovenia","SVN"]
[null,null,"Solomon Islands","SLB"]
[null,null,"Somalia","SOM"]
[null,null,"South Africa","ZAF"]
[null,null,"South Korea","KOR"]
[null,null,"South Sudan","SSD"]
[null,null,"Sri Lanka","LKA"]
[null,null,"Sudan","SDN"]
[null,null,"Suriname","SUR"]
[null,null,"Switzerland","CHE"]
[null,null,"Syria","SYR"]
[null,null,"Taiwan","TWN"]
[null,null,"Tajikistan","TJK"]
[null,null,"Tanzania","TZA"]
[null,null,"Thailand","THA"]
[null,null,"Timor-Leste","TLS"]
[null,null,"Togo","TGO"]
[null,null,"Tonga","TON"]
[null,null,"Trinidad and Tobago","TTO"]
[null,null,"Tunisia","TUN"]
[null,null,"Turkey","TUR"]
[null,null,"Turkmenistan","TKM"]
[null,null,"Uganda","UGA"]
[null,null,"Ukraine","UKR"]
[null,null,"United Arab Emirates","ARE"]
[null,null,"United Kingdom","GBR"]
[null,null,"Uruguay","URY"]
[null,null,"Uzbekistan","UZB"]
[null,null,"Venezuela","VEN"]
[null,null,"Vietnam","VNM"]
[null,null,"Yemen","YEM"]
[null,null,"Zambia","ZMB"]
[null,null,"Zimbabwe","ZWE"]

{"sheet":"Subscription Agreement","index":8,"n_rows":41,"n_cols":3,"rows_kept":41,"cut":false,"hidden":false,"merged":[[39,1,39,2],[13,1,13,2],[15,1,15,2],[17,1,17,2],[19,1,19,2],[21,1,21,2],[23,1,23,2],[25,1,25,2],[27,1,27,2],[31,1,31,2],[35,1,35,2],[37,1,37,2],[29,1,29,2],[33,1,33,2],[11,1,11,2],[1,1,1,2],[0,1,0,2],[3,1,3,2],[5,1,5,2],[7,1,7,2],[9,1,9,2]]}
[null,"SUBSCRIPTION AGREEMENT"]
[null,"The Terms and Conditions of participation and access to Birches Group surveys are listed in the Subscription Agreement below.  \nKindly indicate your acceptance of the Agreement by checking the appropriate box at the end of the Agreement."]
[null,"1.  Parties",{"$f":"\"This Subscription Agreement (“Agreement”) is made between Birches Group, LLC, a limited liability company registered in the state of New York of the United States of America (“Service Provider” or “Birches Group”) and \"&OrgName&\", the subscriber named on the Order Form page of this document.\"","v":"This Subscription Agreement (“Agreement”) is made between Birches Group, LLC, a limited liability company registered in the state of New York of the United States of America (“Service Provider” or “Birches Group”) and , the subscriber named on the Order Form page of this document."}]
[]
[null,"2.  Definition of \"Subscriber\"","“Subscriber” means the subscriber company or organization indicated above, including all individuals who are provided UserIDs and passwords under the Subscriber’s account(s)."]
[]
[null,"3.  Service Provider Content","“Service Provider Content” means all information, data, materials, products and services that Service Provider provides to Subscriber or makes available to Subscriber through a paid subscription, including but not limited to: all Labor Market Data, computer software and any related technology, idea or information contained therein, software upgrades, online or electronic documentation, associated media, and printed materials."]
[]
[null,"4.  Proprietary Rights","Service Provider is the owner of all right, title, and interest in and to the Service Provider Content, including copyright, trademark, trade dress (including information formats), translation rights, redistribution rights, and the right to reproduce the Service Provider Content in alternate media. The Service Provider Content is subject to copyright, trademark, trade dress (including information formats and “look and feel”) and database protections and other rights of Service Provider under the laws of the United States and foreign jurisdictions. Subscriber acknowledges that Subscriber has no claim to ownership in such Service Provider Content by reason of this Agreement or the use of the Service Provider Content."]
[]
[null,"5.  License Grant","Subject to Subscriber’s continued compliance with this Agreement and in consideration for the fee paid or to be paid by Subscriber, Service Provider grants Subscriber a non-exclusive, personal, revocable, nontransferable license to access and use the Service Provider Content."]
[]
[null,"6.  Confidential Information","The parties recognize that they may come in contact with or become familiar with information which the Subscriber or the Service Provider may consider confidential. This information may include, but is not limited to, information pertaining to the Subscriber or Service Provider which may be of value to a competitor. Subscriber and Service Provider agree to keep all such information confidential and not to discuss or divulge it to any third party except that Service Provider may include Subscriber’s compensation data in Service Provider’s general labour market reports in such a manner that the data is not specifically attributed to Subscriber. The Parties recognize that it is customary to provide such general labour market reports as feedback to other participants in a salary survey. Subscriber acknowledges that the Service Provider Content contains proprietary and confidential property of the Birches Group (collectively, “Confidential Information”)."]
[]
[null,"7.  Conditions of Use","a. The Service Provider Content shall be used only by Subscriber solely for Subscriber’s internal business purposes and is not to be republished or distributed (either in hard copy or electronic form) in whole or in part to any third party for use by any party other than the Subscriber.\n\nb. Subscriber shall only direct questions regarding the Service Provider Content to Birches Group. Subscriber will not contact any entity external to Birches Group concerning the Service Provider Content or relating to the substance or scheduling of salary surveys conducted by Birches Group, without obtaining prior written authorization from Birches Group.\n\nc. Subscriber shall not decompile, disassemble, reverse engineer or attempt to reconstruct, identify or discover any source code, underlying ideas, underlying user interface techniques or algorithms of the Service Provider Content by any means whatsoever, or disclose any of the foregoing.\n\nd. Except as expressly permitted herein, Subscriber may not modify, create derivatives of, copy, distribute, broadcast, transmit, reproduce, publish, license, transfer, sell, mirror, frame, data mine or otherwise use any Service Provider Content or any Confidential Information.\n\ne. Subscriber shall not knowingly take any action that would cause the Service Provider Content or source code, if derived by Subscriber or otherwise derived, thereof to be placed in the public domain. Subscriber may not post any Service Provider Content to forums, newsgroups, list serves, mailing lists, electronic bulletin boards or web sites without the prior written consent of Service Provider.\n\nf. Subscriber agrees that any use of the Service Provider Content other than as permitted herein is a violation of this Agreement. Subscriber further agrees that access to Service Provider Content via a Service Provider web site or web services may be subject to additional terms of use posted on such site.\n\ng. Subscriber agrees to participate in the Birches Group salary survey for the Subscribed Locations listed in section 12 of this agreement provided that Subscriber maintains offices and/or operations in the countries of the Subscribed Locations. Birches Group may at its sole discretion provide Subscriber with access to the Service Provider Content for a Subscribed Location prior to Subscriber’s participation in the survey for that Subscribed Location."]
[]
[null,"8.  UserID and Password","Subscriber agrees to maintain as private and confidential information any UserID and password that provides Subscriber with access to the Service Provider Content. Unauthorized use of Subscriber’s UserID(s) and password(s), with or without Subscriber’s knowledge, is a breach of this Agreement. Subscriber agrees to be solely responsible for the use of Subscriber’s UserID(s) and password(s) and to immediately notify Service Provider if Subscriber becomes aware of any loss, theft or unauthorized use of the same."]
[]
[null,"9.  Limitation of Liabilities","IN NO EVENT SHALL THE BIRCHES GROUP OR SUBSCRIBER BE LIABLE TO THE OTHER PARTY OR ANY THIRD PARTY FOR ANY INCIDENTAL, CONSEQUENTIAL, INDIRECT, SPECIAL, OR EXEMPLARY DAMAGES OF ANY NATURE, INCLUDING, BUT NOT LIMITED TO, LOSS OF PROFITS, DATA, BUSINESS OR GOODWILL, EVEN IF THE OTHER PARTY HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. IN NO EVENT SHALL BIRCHES GROUP BE LIABLE TO THE SUBSCRIBER FOR DIRECT DAMAGES IN EXCESS OF THE AMOUNTS PAID UNDER THIS AGREEMENT FOR THE SERVICES WHICH ARE THE SUBJECT OF THE CLAIM."]
[]
[null,"10.  Initial Subscription Term","This Agreement shall take effect on the date (“Effective Date”) the UserID(s) and password(s) to the online Service Provider Content is sent to Subscriber via email. This Agreement shall remain in effect for one year from the Effective Date, unless renewed in accordance to section 12 of this agreement. Notwithstanding the foregoing, Service Provider may terminate this Agreement and suspend Subscriber’s access to the Service Provider Content in the unlikely event that Subscriber fails to comply with any term or condition contained herein."]
[]
[null,"11.  Renewal","This Agreement may be renewed for successive terms of one year upon agreement of the Parties, provided that the applicable fees are paid and subject to any new terms and conditions required by Service Provider at the time of renewal. Service Provider will provide Subscriber with written notice of any such terms and conditions in advance of such renewal. In the absence of another written agreement to the contrary, this Agreement shall renew and apply to any future subscriptions to Service Provider Content. The issuance of an invoice by the Service Provider for a new subscription to the Service Provider Content and the payment thereof by the Subscriber shall be sufficient evidence of Parties’ agreement to renew this Agreement."]
[]
[null,"12.  Subscribed Locations","Subscribed locations will include those countries designated on the Order Form and Country Selection tabs of this document."]
[]
[null,"13.  Subscription Fees","Subscription fees are detailed in the Order Form under Subscription Fees.  All subscription fees are per country per year."]
[]
[null,"14.  Taxes","All fees are expressed net of tax.  If any income tax, withholding tax, VAT or similar taxes are payable, the invoice amount will be increased (grossed-up) and taxes will be withheld from the resulting balance.  This ensures full compliance with local laws and requirements."]
[]
[null,"15.  Payment Schedule","Subscription fees will be invoiced in full upon the execution of this Agreement."]
[]
[null,"16.  Payments","All payments are due net thirty (30) days of invoice date. Late payments are subject to late payment fees equal to the lesser of 1.5% per month on any outstanding balance or the maximum permitted by law. Subscriber shall be responsible for all collection costs associated with the collection of late payments, including attorneys’ fees and bank fees for returned checks or refused transactions. Service Provider may suspend or terminate Subscriber’s subscription if any payment is more than thirty (30) days late."]
[]
[null,"17. Data Submission Requirements","Subscriber understands and agrees that submission of Subscriber's data for Subscribed Locations is required, or a non-participant surcharge shall apply.  Data submissions are expected to be completed within 60 days following Subscriber's annual compensation review.\n\nFailure to provide data within 60 days after registration/pay review will result in suspension of all accounts until data is received; a reconnection fee of $200 per account shall be applied.\n\nAfter an additional 30 days, Subscriber will be billed a non-participation surcharge of 100% of the survey fee for each country for which data is not submitted."]
[]
[null,"18.  Data Storage and Transference","The data collected in our compensation and benefits surveys can be processed by Birches Group that provides services to clients related to compensation, benefits administration or employee engagement. The data may also be transferred or stored in a destination outside of its country or region of origin. Participation in the survey indicates your acceptance of these terms and requires Birches Group to take steps to protect the data in a manner consistent with our respective Privacy Policies and to limit our use of the data solely for the purposes of survey analysis and administration. If you do not find these terms acceptable, you can opt-out by sending an email to: support@birchesgroup.com."]
[]
[null,"19.  General","a. This Agreement constitutes the entire Agreement between the parties and supersedes all prior oral and written agreements and all contemporaneous oral negotiations, commitments and understandings.\n\nb. The headings of this Agreement are informational only and do not limit the scope or content of the subject matter contained therein.\n\nc. No waiver, amendment, or modification of this Agreement shall be effective unless it is in writing and signed by both parties.\n\nd. Subscriber may not assign or transfer Subscriber’s rights under this Agreement.\n\ne. Should any provision of this Agreement be held to be void or unenforceable, the remaining provisions shall remain in full force and effect to be read and construed as if the void or unenforceable provisions were originally deleted.\n\nf. The validity, interpretation and performance of this Agreement shall be governed by the laws of the State of New York, excluding its conflicts of laws provisions"]
[]
[null,"Acceptance of Terms and Conditions","On behalf of the Subscriber, I confirm acceptance of the terms and conditions for participation and access to Birches Group Surveys, as outlined in the Subscription Agreement above.  (Check the box below to complete.)"]

{"sheet":"Survey Access","index":9,"n_rows":178,"n_cols":128,"rows_kept":178,"cut":false,"hidden":false,"merged":[[39,3,39,12],[39,13,39,25],[39,26,39,34],[39,35,39,45],[39,46,39,63],[39,64,39,77],[39,78,39,91],[38,3,38,12],[43,3,43,12],[43,13,43,25],[43,26,43,34],[43,35,43,45],[43,46,43,63],[43,64,43,77],[43,78,43,91],[40,3,40,12],[40,13,40,25],[40,26,40,34],[40,35,40,45],[40,46,40,63],[40,64,40,77],[38,13,38,25],[38,26,38,34],[38,35,38,45],[8,2,8,48],[6,1,6,83],[177,3,177,12],[177,13,177,25],[177,26,177,34],[177,35,177,45],[177,46,177,63],[177,64,177,77],[177,78,177,91],[42,78,42,91],[42,3,42,12],[42,13,42,25],[42,26,42,34],[42,35,42,45],[42,46,42,63],[42,64,42,77],[40,78,40,91],[41,3,41,12],[41,13,41,25],[41,26,41,34],[41,35,41,45],[41,46,41,63],[41,64,41,77],[41,78,41,91],[38,46,38,63],[38,64,38,77],[36,78,36,91],[37,3,37,12],[37,13,37,25],[37,26,37,34],[37,35,37,45],[37,46,37,63],[37,64,37,77],[37,78,37,91],[36,3,36,12],[36,13,36,25],[36,26,36,34],[36,35,36,45],[36,46,36,63],[36,64,36,77],[38,78,38,91],[34,78,34,91],[34,96,34,113],[32,96,33,115],[33,3,33,12],[35,3,35,12],[35,13,35,25],[35,26,35,34],[35,35,35,45],[35,46,35,63],[35,64,35,77],[35,78,35,91],[34,3,34,12],[34,13,34,25],[34,26,34,34],[34,35,34,45],[34,46,34,63],[34,64,34,77],[33,13,33,25],[33,26,33,34],[33,35,33,45],[33,46,33,63],[33,64,33,77],[33,78,33,91],[32,3,32,12],[32,13,32,25],[32,26,32,34],[32,35,32,45],[32,46,32,63],[32,64,32,77],[32,78,32,91],[31,3,31,12],[31,13,31,25],[31,26,31,34],[31,35,31,45],[31,46,31,63],[31,64,31,77],[31,78,31,91],[12,2,12,134],[14,2,14,72],[22,2,22,54],[29,2,29,25],[29,26,29,45],[30,3,30,12],[30,13,30,25],[30,26,30,34],[30,35,30,45],[30,46,30,63],[30,64,30,77],[30,78,30,91],[27,26,27,54],[24,26,26,54]]}
[]
[]
[]
[]
[]
[]
[null,"Individuals to Receive Access to Survey Results"]
[]
[]
[]
[null,null,"This section is used to confirm the contact information for those individuals who will receive access to the survey.  Each person listed below will receive a separate User Account and Password."]
[]
[null,null,"When finished, use the buttons to navigate to the next contacts sheet or return to the Order Form."]
[]
[null,null,"Note:  If Indigo™ access is included in your subscription, be sure to indicate if users should have access to Indigo™ or if their access should be limited to Reports Only."]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"IF(ProductSelectionChoice=\"Ad-Hoc Subscriber\",\"AdhocRange\",\"PP\")","v":"PP"},null,"Range to Check"]
[]
[null,null,"Survey Access"]
[null,null,"Please indicate below, for each country in which you registered, the persons who should have access to the survey results."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Note: You may select multiple survey countries on the same line by simply making additional selections  before moving the cursor to the next line."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"To edit, first delete the text and then start over."]
[]
[null,null,"Name"]
[null,null,"Salutation","First or Given Name",null,null,null,null,null,null,null,null,null,"Last or Surname(s)",null,null,null,null,null,null,null,null,null,null,null,null,"Survey Country",null,null,null,null,null,null,null,null,"Type of Access",null,null,null,null,null,null,null,null,null,null,"Job Title",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Phone Number \n(including country code)",null,null,null,null,null,null,null,null,null,null,null,null,null,"E-mail Address",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Indigo™ Check"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"IF(ISNUMBER(SEARCH(\",\",AA32)),1,IF($DO$20=\"PP\",1,IF(AA32=\"All Countries\",1,IF(VLOOKUP(AA32,AdHocRange,11,FALSE)=\"Indigo™ Interactive Access\",1,0))))","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"IF(ISNUMBER(SEARCH(\",\",AA178)),1,IF($DO$20=\"PP\",1,IF(AA178=\"All Countries\",1,IF(VLOOKUP(AA178,AdHocRange,11,FALSE)=\"Indigo™ Interactive Access\",1,0))))","v":1}]

{"sheet":"Data Collection Contacts","index":10,"n_rows":48,"n_cols":136,"rows_kept":48,"cut":false,"hidden":false,"merged":[[174,94,174,107],[174,108,174,121],[174,122,174,135],[6,2,6,83],[8,2,8,48],[174,2,174,10],[174,11,174,18],[174,19,174,36],[174,37,174,54],[174,55,174,72],[174,73,174,93],[46,122,46,135],[47,2,47,10],[47,11,47,18],[47,19,47,36],[47,37,47,54],[47,55,47,72],[47,73,47,93],[47,94,47,107],[47,108,47,121],[47,122,47,135],[45,108,45,121],[45,122,45,135],[46,2,46,10],[46,11,46,18],[46,19,46,36],[46,37,46,54],[46,55,46,72],[46,73,46,93],[46,94,46,107],[46,108,46,121],[44,94,44,107],[44,108,44,121],[44,122,44,135],[45,2,45,10],[45,11,45,18],[45,19,45,36],[45,37,45,54],[45,55,45,72],[45,73,45,93],[45,94,45,107],[44,2,44,10],[44,11,44,18],[44,19,44,36],[44,37,44,54],[44,55,44,72],[44,73,44,93],[43,2,43,10],[43,11,43,18],[43,19,43,36],[43,37,43,54],[43,55,43,72],[43,73,43,93],[43,94,43,107],[43,108,43,121],[43,122,43,135],[42,2,42,10],[42,11,42,18],[42,19,42,36],[42,37,42,54],[42,55,42,72],[42,73,42,93],[42,94,42,107],[42,108,42,121],[42,122,42,135],[40,94,40,107],[40,108,40,121],[40,122,40,135],[41,2,41,10],[41,11,41,18],[41,19,41,36],[41,37,41,54],[41,55,41,72],[41,73,41,93],[41,94,41,107],[40,2,40,10],[40,11,40,18],[40,19,40,36],[40,37,40,54],[40,55,40,72],[40,73,40,93],[41,108,41,121],[41,122,41,135],[39,2,39,10],[39,11,39,18],[39,19,39,36],[39,37,39,54],[39,55,39,72],[39,73,39,93],[39,94,39,107],[39,108,39,121],[39,122,39,135],[38,2,38,10],[38,11,38,18],[38,19,38,36],[38,37,38,54],[38,55,38,72],[38,73,38,93],[38,94,38,107],[38,108,38,121],[38,122,38,135],[36,94,36,107],[36,108,36,121],[36,122,36,135],[37,2,37,10],[37,11,37,18],[37,19,37,36],[37,37,37,54],[37,55,37,72],[37,73,37,93],[37,94,37,107],[36,2,36,10],[36,11,36,18],[36,19,36,36],[36,37,36,54],[36,55,36,72],[36,73,36,93],[37,108,37,121],[37,122,37,135],[35,2,35,10],[35,11,35,18],[35,19,35,36],[35,37,35,54],[35,55,35,72],[35,73,35,93],[35,94,35,107],[35,108,35,121],[35,122,35,135],[34,2,34,10],[34,11,34,18],[34,19,34,36],[34,37,34,54],[34,55,34,72],[34,73,34,93],[34,94,34,107],[34,108,34,121],[34,122,34,135],[32,94,32,107],[32,108,32,121],[32,122,32,135],[33,2,33,10],[33,11,33,18],[33,19,33,36],[33,37,33,54],[33,55,33,72],[33,73,33,93],[33,94,33,107],[32,2,32,10],[32,11,32,18],[32,19,32,36],[32,37,32,54],[32,55,32,72],[32,73,32,93],[33,108,33,121],[33,122,33,135],[31,2,31,10],[31,11,31,18],[31,19,31,36],[31,37,31,54],[31,55,31,72],[31,73,31,93],[31,94,31,107],[31,108,31,121],[31,122,31,135],[30,2,30,10],[30,11,30,18],[30,19,30,36],[30,37,30,54],[30,55,30,72],[30,73,30,93],[30,94,30,107],[30,108,30,121],[30,122,30,135],[28,94,28,107],[28,108,28,121],[28,122,28,135],[29,2,29,10],[29,11,29,18],[29,19,29,36],[29,37,29,54],[29,55,29,72],[29,73,29,93],[29,94,29,107],[28,2,28,10],[28,11,28,18],[28,19,28,36],[28,37,28,54],[28,55,28,72],[28,73,28,93],[29,108,29,121],[29,122,29,135],[27,2,27,10],[27,11,27,18],[27,19,27,36],[27,37,27,54],[27,55,27,72],[27,73,27,93],[27,94,27,107],[27,108,27,121],[27,122,27,135],[26,2,26,10],[26,11,26,18],[26,19,26,36],[26,37,26,54],[26,55,26,72],[26,73,26,93],[26,94,26,107],[26,108,26,121],[26,122,26,135],[24,122,24,135],[25,2,25,10],[25,11,25,18],[25,19,25,36],[25,37,25,54],[25,55,25,72],[25,73,25,93],[25,94,25,107],[25,108,25,121],[25,122,25,135],[9,2,9,57],[11,2,11,114],[19,2,19,14],[20,2,21,90],[24,2,24,10],[24,11,24,18],[24,19,24,36],[24,37,24,54],[24,55,24,72],[24,73,24,93],[24,94,24,107],[24,108,24,121]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"This section is used to indicate the names of individuals who will provide your organization's data for the survey"]
[]
[null,null,"When finished, use the buttons to navigate to the next contacts sheet or return to the Order Form."]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Survey  DATA Contacts"]
[null,null,"Please indicate below, for each country in which you registered, the contact information for the individual who will provide the data for the survey.  If you need more space, click the Add Another Row button.   If there is just one individual, please copy the necessary information for each country."]
[]
[null,null,1,2,3,4,5,6,7,8,9,null,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134]
[]
[null,null,"Survey Country",null,null,null,null,null,null,null,null,"Salutation",null,null,null,null,null,null,null,"First or Given Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Last or Surname(s)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Job Title",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Phone Number (including country code)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E-mail Address",null,null,null,null,null,null,null,null,null,null,null,null,null,"Skype Name",null,null,null,null,null,null,null,null,null,null,null,null,null,"Country Where Located"]
[{"$f":"ROW()","v":26},{"$f":"A26&C26","v":"26"}]
[{"$f":"ROW()","v":27},{"$f":"A27&C27","v":"27"}]
[{"$f":"ROW()","v":28},"28"]
[{"$f":"ROW()","v":29},"29"]
[{"$f":"ROW()","v":30},"30"]
[{"$f":"ROW()","v":31},"31"]
[{"$f":"ROW()","v":32},"32"]
[{"$f":"ROW()","v":33},"33"]
[{"$f":"ROW()","v":34},"34"]
[{"$f":"ROW()","v":35},"35"]
[{"$f":"ROW()","v":36},"36"]
[{"$f":"ROW()","v":37},"37"]
[{"$f":"ROW()","v":38},"38"]
[{"$f":"ROW()","v":39},"39"]
[{"$f":"ROW()","v":40},"40"]
[{"$f":"ROW()","v":41},"41"]
[{"$f":"ROW()","v":42},"42"]
[{"$f":"ROW()","v":43},"43"]
[{"$f":"ROW()","v":44},"44"]
[{"$f":"ROW()","v":45},"45"]
[{"$f":"ROW()","v":46},"46"]
[{"$f":"ROW()","v":47},"47"]
[{"$f":"ROW()","v":48},"48"]

{"sheet":"SO Notification","index":11,"n_rows":87,"n_cols":17,"rows_kept":87,"cut":false,"hidden":true,"merged":[[0,0,0,13],[23,3,34,6],[51,11,51,16],[60,11,60,16],[62,10,62,16]]}
["This sheet is used to create export files for notification email to Survey Operations"]
[]
[]
[null,"Step 1","Review the Order Form and ensure all sections are completed.  If necessary, contact client to confirm any corrections."]
[]
[null,"Step 2","Select the export parameters (fields 2a through 2d should be automatically populated):"]
[]
[null,null,"a)","Type of Registration",null,{"$f":"ProductSelectionChoice","v":0},{"$f":"IF(F8=\"Ad-Hoc Subscriber\",\"Order Form (Ad-Hoc)\",IF(F8=\"Sustaining Contributor\",\"Order Form (SC)\",\"Order Form (SP)\"))","v":"Order Form (SP)"}]
[null,null,"b)","Name of Client",null,{"$f":"IF(ISBLANK(BillingOrgName),OrgName,BillingOrgName)","v":0},"This field must be entered on the Order Form Tab"]
[null,null,"c)","Order Number",null,{"$f":"IF(ISBLANK(OrderNumber),\"\",OrderNumber)","v":""},"This field must be entered on the Order Form Tab"]
[null,null,"d)","Account Number",null,{"$f":"AccountNumber","v":0},"This field must be entered on the Order Form Tab"]
[]
[null,"Step 3","Indicate in the following fields additional information required by survey operations (entries in yellow cells only):"]
[]
[null,null,"a)","Survey Type:",null,"MS"]
[null,null,"b)","Participation Type:",null,"Update (treat as NEW)",{"$f":"IF(F16=\"Update (treat as NEW)\",\"Last Participation Year:    \",\"\")","v":"Last Participation Year:    "},2018,"<----- If Update (treat as NEW), enter last participation year in H16; otherwise, leave blank"]
[null,null,"c)","Registration Type:",null,"Paying"]
[null,null,"d)","Language:",null,"Multi-language"]
[null,null,"e)","SDM:",null,null,"(enter name if applicable; otherwise leave blank)"]
[null,null,"f)","DA Action:",null,"Data Entry Only"]
[]
[null,null,"g)","Special Notes (enter special notes in box below):"]
[]
[null,null,null,"Message"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Step 3","Click the button below to create a new file with the data needed for survey operations notification email."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Export for SO"]
[]
[]
[null,null,null,null,null,null,null,null,null,1,"Employer Name:",{"$f":"OrgName","v":0}]
[null,null,null,null,null,null,null,null,null,2,"Countries:",{"$f":"_xlfn.TEXTJOIN(\"; \",TRUE,QueryResult!E2:E61)","v":"Country"}]
[]
[null,null,null,null,null,null,null,null,null,3,"Survey Type: ",{"$f":"SurveyTypeChoice","v":"MS"}]
[null,null,null,null,null,null,null,null,null,4,"Participation Type:",{"$f":"ParticipationTypeChoice","v":"Update (treat as NEW)"},null,{"$f":"IF(ISBLANK(LastPartYear),\"\",\"Last Participation Year: \"&LastPartYear)","v":"Last Participation Year: 2018"}]
[null,null,null,null,null,null,null,null,null,5,"Registration Type:",{"$f":"RegistrationTypeChoice","v":"Paying"}]
[null,null,null,null,null,null,null,null,null,6,"Language:",{"$f":"LanguageTypeChoice","v":"Multi-language"}]
[null,null,null,null,null,null,null,null,null,7,"Account Executive:",{"$f":"SalesRep","v":0}]
[null,null,null,null,null,null,null,null,null,8,"Survey Data Manager:",{"$f":"IF(ISBLANK(SDMName),\"\",SDMName)","v":""}]
[null,null,null,null,null,null,null,null,null,9,"Action for Data Analyst",{"$f":"DAActionChoice","v":"Data Entry Only"}]
[null,null,null,null,null,null,null,null,null,10,"Special Notes:",{"$f":"SpecialNotesText","v":"Message"}]
[]
[null,null,null,null,null,null,null,null,null,11,"Data Contact Information"]
[null,null,null,null,null,null,null,null,null,null,"Countries:","ISO","Name","Title","Location","Email","Phone"]
[null,null,null,null,null,null,null,null,26,null,{"$f":"IF(ISBLANK('Data Collection Contacts'!C26),\"\",'Data Collection Contacts'!C26)","v":""},{"$f":"IF(ISERROR(IF(K65=\"All Countries\",\"All\",VLOOKUP(K65,SurveyElections,2,FALSE))),\"\",IF(K65=\"All Countries\",\"All\",VLOOKUP(K65,SurveyElections,2,FALSE)))","v":""},{"$f":"IF(L65=\"\",\"\",_xlfn.TEXTJOIN(\" \",TRUE,VLOOKUP(I65&K65,DataCollectionContacts,11,FALSE),VLOOKUP(I65&K65,DataCollectionContacts,19,FALSE),VLOOKUP(I65&K65,DataCollectionContacts,37,FALSE)))","v":""},{"$f":"IF(L65=\"\",\"\",VLOOKUP(I65&K65,DataCollectionContacts,55,FALSE))","v":""},{"$f":"IF(L65=\"\",\"\",VLOOKUP(I65&K65,DataCollectionContacts,122,FALSE))","v":""},{"$f":"IF(L65=\"\",\"\",VLOOKUP(I65&K65,DataCollectionContacts,94,FALSE))","v":""},{"$f":"IF(L65=\"\",\"\",VLOOKUP(I65&K65,DataCollectionContacts,73,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,27,null,{"$f":"IF(ISBLANK('Data Collection Contacts'!C27),\"\",'Data Collection Contacts'!C27)","v":""},"","","","","",""]
[null,null,null,null,null,null,null,null,28,null,{"$f":"IF(ISBLANK('Data Collection Contacts'!C28),\"\",'Data Collection Contacts'!C28)","v":""},"","","","","",""]
[null,null,null,null,null,null,null,null,29,null,{"$f":"IF(ISBLANK('Data Collection Contacts'!C29),\"\",'Data Collection Contacts'!C29)","v":""},"","","","","",""]
[null,null,null,null,null,null,null,null,30,null,{"$f":"IF(ISBLANK('Data Collection Contacts'!C30),\"\",'Data Collection Contacts'!C30)","v":""},"","","","","",""]
[null,null,null,null,null,null,null,null,31,null,{"$f":"IF(ISBLANK('Data Collection Contacts'!C31),\"\",'Data Collection Contacts'!C31)","v":""},"","","","","",""]
[null,null,null,null,null,null,null,null,32,null,{"$f":"IF(ISBLANK('Data Collection Contacts'!C32),\"\",'Data Collection Contacts'!C32)","v":""},"","","","","",""]
[null,null,null,null,null,null,null,null,33,null,{"$f":"IF(ISBLANK('Data Collection Contacts'!C33),\"\",'Data Collection Contacts'!C33)","v":""},"","","","","",""]
[null,null,null,null,null,null,null,null,34,null,{"$f":"IF(ISBLANK('Data Collection Contacts'!C34),\"\",'Data Collection Contacts'!C34)","v":""},"","","","","",""]
[null,null,null,null,null,null,null,null,35,null,{"$f":"IF(ISBLANK('Data Collection Contacts'!C35),\"\",'Data Collection Contacts'!C35)","v":""},"","","","","",""]
[null,null,null,null,null,null,null,null,36,null,{"$f":"IF(ISBLANK('Data Collection Contacts'!C36),\"\",'Data Collection Contacts'!C36)","v":""},"","","","","",""]
[null,null,null,null,null,null,null,null,37,null,{"$f":"IF(ISBLANK('Data Collection Contacts'!C37),\"\",'Data Collection Contacts'!C37)","v":""},"","","","","",""]
[null,null,null,null,null,null,null,null,38,null,{"$f":"IF(ISBLANK('Data Collection Contacts'!C38),\"\",'Data Collection Contacts'!C38)","v":""},"","","","","",""]
[null,null,null,null,null,null,null,null,39,null,{"$f":"IF(ISBLANK('Data Collection Contacts'!C39),\"\",'Data Collection Contacts'!C39)","v":""},"","","","","",""]
[null,null,null,null,null,null,null,null,40,null,{"$f":"IF(ISBLANK('Data Collection Contacts'!C40),\"\",'Data Collection Contacts'!C40)","v":""},"","","","","",""]
[null,null,null,null,null,null,null,null,41,null,{"$f":"IF(ISBLANK('Data Collection Contacts'!C41),\"\",'Data Collection Contacts'!C41)","v":""},"","","","","",""]
[null,null,null,null,null,null,null,null,42,null,{"$f":"IF(ISBLANK('Data Collection Contacts'!C42),\"\",'Data Collection Contacts'!C42)","v":""},"","","","","",""]
[null,null,null,null,null,null,null,null,43,null,{"$f":"IF(ISBLANK('Data Collection Contacts'!C43),\"\",'Data Collection Contacts'!C43)","v":""},"","","","","",""]
[null,null,null,null,null,null,null,null,44,null,{"$f":"IF(ISBLANK('Data Collection Contacts'!C44),\"\",'Data Collection Contacts'!C44)","v":""},"","","","","",""]
[null,null,null,null,null,null,null,null,45,null,{"$f":"IF(ISBLANK('Data Collection Contacts'!C45),\"\",'Data Collection Contacts'!C45)","v":""},"","","","","",""]
[null,null,null,null,null,null,null,null,46,null,{"$f":"IF(ISBLANK('Data Collection Contacts'!C46),\"\",'Data Collection Contacts'!C46)","v":""},"","","","","",""]
[null,null,null,null,null,null,null,null,47,null,{"$f":"IF(ISBLANK('Data Collection Contacts'!C47),\"\",'Data Collection Contacts'!C47)","v":""},"","","","","",""]
[null,null,null,null,null,null,null,null,48,null,{"$f":"IF(ISBLANK('Data Collection Contacts'!C48),\"\",'Data Collection Contacts'!C48)","v":""},"","","","","",""]

{"sheet":"ChangeLog","index":12,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["Date","Change"]
["2020-04-27","Added four new IO only survey countries to country list"]
["2020-04-27","Fixed numbering of Subscription Agreement"]
["2020-04-27","Added SO Notification functionality"]

{"sheet":"Invoices","index":13,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":true,"merged":[[0,0,0,13]]}
["This sheet is used to create export files for QuickBooks Invoicing"]
[]
[]
[null,"Step 1","Review the Order Form and ensure all sections are completed.  If necessary, contact client to confirm any corrections."]
[]
[null,"Step 2","Select the export parameters (all fields should be automatically populated):"]
[]
[null,null,"a)","Type of Registration",null,{"$f":"ProductSelectionChoice","v":0},{"$f":"IF(F8=\"Ad-Hoc Subscriber\",\"Order Form (Ad-Hoc)\",\"Order Form (Preferred Partner)\")","v":"Order Form (Preferred Partner)"}]
[null,null,"b)","Name of Client",null,{"$f":"IF(ISBLANK(BillingOrgName),OrgName,BillingOrgName)","v":0},"This should be completed on the Order Form TAB"]
[null,null,"c)","Order Number",null,{"$f":"OrderNumber","v":0},"This should be completed on the Order Form TAB"]
[null,null,"c)","Customer Number",null,{"$f":"AccountNumber","v":0},"This should be completed on the Order Form TAB"]
[]
[null,"Step 3","Run the Export to QuickBooks Macro to create a new file with the data needed to invoice by clicking the button below."]