{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["wksRules","Services and Fees USD","Order Form","QueryResult","Country Selection","BG Use Only","Subscription Agreement","Survey Access","Survey Contacts","Invoices"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":1,"defined_names":84,"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":62,"n_cols":5,"rows_kept":62,"cut":false,"hidden":false,"merged":[[61,4,61,6],[57,2,57,3],[58,2,58,3],[59,2,59,3],[60,2,60,3],[57,4,57,6],[58,4,58,6],[59,4,59,6],[60,4,60,6],[4,2,4,5],[5,2,5,5],[55,2,55,7],[7,2,7,5],[10,3,10,4],[12,4,14,4],[15,2,17,2],[15,3,17,5]]}
[]
[]
[]
[]
[null,null,"Community™ Market"]
[null,null,"Compensation & Benefits Survey"]
[]
[null,null,"Survey Pricing for International Public Sector Organizations1,2"]
[]
[null,null,null,"Indigo™ Interactive Data Subscription ","Report\nSubscription"]
[null,null,"Number of Countries","- - - - - All fees are Per Country (USD) - - - - - "]
[null,null,"1 to 9 countries  ",2100,1840]
[null,null,"10 to 64 countries",1900,1650]
[null,null,"65 to 129 countries",1800]
[null,null,"130 or more countries",1700]
[null,null,"Multi-year discount","A 10% discount applies  to base survey fee for three-year Indigo™ contracts\n(minimum: 10 countries)"]
[]
[]
[null,null,"1Fees above are for participants.  A surcharge of 100% applies for non-participants."]
[null,null,"2This pricing schedule applies to international public sector organizations, including bi-laterals and multi-laterals."]
[]
[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 - over 150 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,"  per 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,"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,"Multiple Users Included"]
[null,null,"Your 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,null,null,"Philippines"]

{"sheet":"Order Form","index":2,"n_rows":236,"n_cols":82,"rows_kept":236,"cut":false,"hidden":false,"merged":[[37,18,37,20],[129,83,129,86],[224,40,224,48],[224,49,224,56],[225,40,225,48],[225,49,225,56],[226,40,226,48],[226,49,226,56],[219,40,219,48],[219,49,219,56],[220,40,220,48],[220,49,220,56],[221,40,221,48],[221,49,221,56],[222,40,222,48],[222,49,222,56],[223,40,223,48],[223,49,223,56],[214,40,214,48],[214,49,214,56],[215,40,215,48],[215,49,215,56],[216,40,216,48],[216,49,216,56],[217,40,217,48],[217,49,217,56],[218,40,218,48],[218,49,218,56],[209,40,209,48],[209,49,209,56],[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],[204,40,204,48],[204,49,204,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],[199,40,199,48],[199,49,199,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],[194,40,194,48],[194,49,194,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],[189,40,189,48],[189,49,189,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],[184,40,184,48],[184,49,184,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],[179,40,179,48],[179,49,179,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],[174,40,174,48],[174,49,174,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],[169,40,169,48],[169,49,169,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],[54,19,54,27],[54,9,54,18],[54,29,54,46],[129,31,129,34],[130,31,130,34],[6,1,6,57],[15,2,15,12],[15,25,15,26],[15,27,15,36],[17,2,17,11],[17,14,17,23],[17,27,17,36],[9,2,10,57],[12,2,12,57],[14,2,14,23],[14,25,14,26],[14,27,14,36],[14,39,14,56],[15,39,15,50],[17,39,17,56],[21,2,21,5],[21,6,21,23],[21,27,21,30],[21,31,21,36],[21,44,21,56],[20,2,20,5],[20,6,20,23],[20,27,20,30],[20,31,20,56],[32,6,32,23],[22,2,22,13],[22,14,22,23],[26,2,26,23],[26,25,26,26],[26,27,26,36],[38,2,38,7],[38,8,38,17],[26,39,26,56],[29,39,29,56],[32,31,32,56],[57,3,57,54],[59,3,59,55],[60,3,60,55],[62,3,62,52],[33,6,33,23],[33,31,33,36],[34,14,34,23],[36,2,36,18],[33,44,33,56],[36,27,36,56],[41,2,41,6],[41,8,41,17],[52,8,52,18],[52,19,52,27],[43,3,43,52],[50,3,50,52],[29,2,29,11],[29,14,29,23],[29,27,29,36],[67,40,67,44],[68,40,68,44],[69,40,69,44],[67,31,67,34],[68,31,68,34],[69,31,69,34],[67,26,67,30],[67,13,67,25],[67,35,67,39],[69,26,69,30],[68,26,68,30],[68,13,68,25],[69,13,69,25],[68,35,68,39],[69,35,69,39],[66,3,66,10],[66,26,66,30],[65,26,65,30],[66,13,66,25],[65,13,65,25],[65,35,65,39],[66,35,66,39],[65,40,65,44],[65,31,65,34],[66,31,66,34],[65,3,65,12],[73,26,73,30],[72,26,72,30],[72,13,72,25],[73,13,73,25],[72,35,72,39],[73,35,73,39],[72,40,72,44],[73,40,73,44],[72,31,72,34],[73,31,73,34],[71,26,71,30],[70,26,70,30],[70,13,70,25],[71,13,71,25],[70,35,70,39],[71,35,71,39],[70,40,70,44],[71,40,71,44],[70,31,70,34],[71,31,71,34],[75,26,75,30],[74,26,74,30],[74,13,74,25],[75,13,75,25],[74,35,74,39],[75,35,75,39],[74,40,74,44],[75,40,75,44],[74,31,74,34],[75,31,75,34],[77,26,77,30],[76,26,76,30],[76,13,76,25],[77,13,77,25],[76,35,76,39],[77,35,77,39],[76,40,76,44],[77,40,77,44],[76,31,76,34],[77,31,77,34],[79,26,79,30],[78,26,78,30],[78,13,78,25],[79,13,79,25],[78,35,78,39],[79,35,79,39],[78,40,78,44],[79,40,79,44],[78,31,78,34],[79,31,79,34],[81,26,81,30],[80,26,80,30],[80,13,80,25],[81,13,81,25],[80,35,80,39],[81,35,81,39],[80,40,80,44],[81,40,81,44],[80,31,80,34],[81,31,81,34],[83,26,83,30],[82,26,82,30],[82,13,82,25],[83,13,83,25],[82,35,82,39],[83,35,83,39],[82,40,82,44],[83,40,83,44],[82,31,82,34],[83,31,83,34],[85,26,85,30],[84,26,84,30],[84,13,84,25],[85,13,85,25],[84,35,84,39],[85,35,85,39],[84,40,84,44],[85,40,85,44],[84,31,84,34],[85,31,85,34],[87,26,87,30],[86,26,86,30],[86,13,86,25],[87,13,87,25],[86,35,86,39],[87,35,87,39],[86,40,86,44],[87,40,87,44],[86,31,86,34],[87,31,87,34],[89,26,89,30],[88,26,88,30],[88,13,88,25],[89,13,89,25],[88,35,88,39],[89,35,89,39],[88,40,88,44],[89,40,89,44],[88,31,88,34],[89,31,89,34],[91,26,91,30],[90,26,90,30],[90,13,90,25],[91,13,91,25],[90,35,90,39],[91,35,91,39],[90,40,90,44],[91,40,91,44],[90,31,90,34],[91,31,91,34],[93,26,93,30],[92,26,92,30],[92,13,92,25],[93,13,93,25],[92,35,92,39],[93,35,93,39],[92,40,92,44],[93,40,93,44],[92,31,92,34],[93,31,93,34],[95,26,95,30],[94,26,94,30],[94,13,94,25],[95,13,95,25],[94,35,94,39],[95,35,95,39],[94,40,94,44],[95,40,95,44],[94,31,94,34],[95,31,95,34],[97,26,97,30],[96,26,96,30],[96,13,96,25],[97,13,97,25],[96,35,96,39],[97,35,97,39],[96,40,96,44],[97,40,97,44],[96,31,96,34],[97,31,97,34],[99,26,99,30],[98,26,98,30],[98,13,98,25],[99,13,99,25],[98,35,98,39],[99,35,99,39],[98,40,98,44],[99,40,99,44],[98,31,98,34],[99,31,99,34],[101,26,101,30],[100,26,100,30],[100,13,100,25],[101,13,101,25],[100,35,100,39],[101,35,101,39],[100,40,100,44],[101,40,101,44],[100,31,100,34],[101,31,101,34],[103,26,103,30],[102,26,102,30],[102,13,102,25],[103,13,103,25],[102,35,102,39],[103,35,103,39],[102,40,102,44],[103,40,103,44],[102,31,102,34],[103,31,103,34],[105,26,105,30],[104,26,104,30],[104,13,104,25],[105,13,105,25],[104,35,104,39],[105,35,105,39],[104,40,104,44],[105,40,105,44],[104,31,104,34],[105,31,105,34],[107,26,107,30],[106,26,106,30],[106,13,106,25],[107,13,107,25],[106,35,106,39],[107,35,107,39],[106,40,106,44],[107,40,107,44],[106,31,106,34],[107,31,107,34],[109,26,109,30],[108,26,108,30],[108,13,108,25],[109,13,109,25],[108,35,108,39],[109,35,109,39],[108,40,108,44],[109,40,109,44],[108,31,108,34],[109,31,109,34],[111,26,111,30],[110,26,110,30],[110,13,110,25],[111,13,111,25],[110,35,110,39],[111,35,111,39],[110,40,110,44],[111,40,111,44],[110,31,110,34],[111,31,111,34],[114,31,114,34],[115,31,115,34],[113,26,113,30],[112,26,112,30],[112,13,112,25],[113,13,113,25],[112,35,112,39],[113,35,113,39],[112,40,112,44],[113,40,113,44],[112,31,112,34],[113,31,113,34],[114,40,114,44],[152,2,152,57],[153,2,158,57],[142,2,142,57],[143,2,143,57],[144,2,144,57],[146,2,146,57],[148,2,148,29],[140,2,140,57],[126,26,126,30],[126,13,126,25],[126,35,126,39],[129,35,129,39],[141,2,141,57],[126,40,126,44],[126,31,126,34],[130,35,130,39],[130,40,130,44],[129,40,129,44],[129,26,129,30],[130,26,130,30],[130,15,130,25],[137,4,137,19],[137,20,137,25],[131,23,131,44],[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],[161,3,161,57],[162,3,162,57],[163,3,163,39],[165,31,166,39],[166,4,166,12],[166,13,166,21],[166,22,166,30],[165,40,166,48],[165,49,166,56],[167,40,167,48],[167,49,167,56],[168,40,168,48],[168,49,168,56],[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],[207,4,207,12],[207,13,207,21],[207,22,207,30],[207,31,207,39],[208,4,208,12],[208,13,208,21],[208,22,208,30],[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],[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],[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],[215,4,215,12],[215,13,215,21],[215,22,215,30],[215,31,215,39],[216,4,216,12],[216,13,216,21],[216,22,216,30],[216,31,216,39],[213,4,213,12],[213,13,213,21],[213,22,213,30],[213,31,213,39],[214,4,214,12],[214,13,214,21],[214,22,214,30],[214,31,214,39],[220,22,220,30],[220,31,220,39],[217,4,217,12],[217,13,217,21],[217,22,217,30],[217,31,217,39],[218,4,218,12],[218,13,218,21],[218,22,218,30],[218,31,218,39],[232,14,232,25],[225,4,225,12],[225,13,225,21],[225,22,225,30],[225,31,225,39],[226,4,226,12],[226,13,226,21],[226,22,226,30],[226,31,226,39],[7,2,7,58],[229,2,229,57],[224,31,224,39],[221,4,221,12],[221,13,221,21],[221,22,221,30],[221,31,221,39],[222,4,222,12],[222,13,222,21],[222,22,222,30],[222,31,222,39],[223,4,223,12],[223,13,223,21],[223,22,223,30],[223,31,223,39],[224,4,224,12],[224,13,224,21],[224,22,224,30],[219,4,219,12],[219,13,219,21],[219,22,219,30],[219,31,219,39],[220,4,220,12],[220,13,220,21],[62,68,62,71],[8,2,8,57],[136,4,136,19],[136,20,136,25],[125,26,125,30],[124,26,124,30],[124,13,124,25],[125,13,125,25],[124,35,124,39],[125,35,125,39],[124,40,124,44],[125,40,125,44],[124,31,124,34],[125,31,125,34],[123,26,123,30],[122,26,122,30],[122,13,122,25],[123,13,123,25],[122,35,122,39],[123,35,123,39],[122,40,122,44],[123,40,123,44],[122,31,122,34],[123,31,123,34],[62,63,62,67],[121,26,121,30],[120,26,120,30],[120,13,120,25],[121,13,121,25],[120,35,120,39],[121,35,121,39],[120,40,120,44],[121,40,121,44],[120,31,120,34],[121,31,121,34],[119,26,119,30],[118,26,118,30],[118,13,118,25],[119,13,119,25],[118,35,118,39],[119,35,119,39],[118,40,118,44],[119,40,119,44],[118,31,118,34],[119,31,119,34],[117,26,117,30],[116,26,116,30],[116,13,116,25],[37,2,37,7],[37,8,37,17],[39,2,39,7],[39,8,39,17],[136,27,136,29],[136,30,136,55],[40,2,40,7],[40,8,40,17],[39,25,39,56],[40,27,40,56],[117,13,117,25],[116,35,116,39],[117,35,117,39],[116,40,116,44],[117,40,117,44],[116,31,116,34],[117,31,117,34],[115,26,115,30],[114,26,114,30],[114,13,114,25],[115,13,115,25],[114,35,114,39],[115,35,115,39],[115,40,115,44]]}
[]
[]
[]
[]
[]
[]
[null,"Community™ Market Compensation & Benefits Survey"]
[null,null,"International Public Sector Organizations"]
[null,null,"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,"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,null,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,null,"To proceed with your order, press the Select Countries button below.  After you select your countries, you will be returned to this form."]
[]
[]
[]
[]
[]
[]
[null,null,null,"Please indicate the start date for your subscription.  It will apply to all countries in this order."]
[]
[null,null,null,null,null,null,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,"You must enter a DATE"]
[]
[null,null,null,null,null,null,null,null,null,"Subscription Period:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"The duration selection must apply for all countries"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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","Customer 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 EndDate","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,{"$f":"IF(C27=\"\",C15,C27)","v":0},{"$f":"AccountNumber","v":0},{"$f":"OrderNumber","v":0},{"$f":"IF(AB27=\"\",Z15&\" \"&AB15&\" \"&AN15,Z27&\" \"&AB27&\" \"&AN27)","v":"  "},{"$f":"IF(C30=\"\",C18,C30)","v":0},{"$f":"IF(G33=\"\",G21,G33)","v":0},{"$f":"IF(AF33=\"\",AF21,AF21)","v":0},{"$f":"IF(O35=\"\",\", \"&VLOOKUP(O23,StateAbbr,2,FALSE),\", \"&VLOOKUP(O35,StateAbbr,2,FALSE))","v":{"$error":"#N/A"}},{"$f":"IF(G34=\"\",G22,G34)","v":0},{"$f":"IF(AS34=\"\",AS22,AS34)","v":0},{"$f":"IF(AF34=\"\",AF22,AF34)","v":0},{"$f":"IF(AB30=\"\",AB18,AB30)","v":0},{"$f":"IF(O30=\"\",O18,O30)","v":0},"IO/Bilateral","Not applicable",{"$f":"SubmitDataStart","v":"00:00:00"},{"$f":"IF(T55=\"3 Years\",DATE(YEAR(CA58)+3,MONTH(CA58),DAY(CA58)-1),DATE(YEAR(CA58)+1,MONTH(CA58),DAY(CA58)-1))","v":"1900-12-30"},{"$f":"Currency","v":"USD"},{"$f":"IF(ISBLANK(AB37),\"\",AB37)","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,"For multi-year subscriptions only:",null,null,null,null,null,null,null,"Billing Year",{"$f":"IF(T55=\"3 Years\",IF(TODAY()>CA58+730,\"Year 3\",IF(TODAY()>CA58+365,\"Year 2\",\"Year 1\")),\"\")","v":""}]
[null,null,null,"  1)  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,null,null,null,null,"Item",{"$f":"IF(T55=\"3 Years\",\"Credit/ Revenue Share Discount:Discount-Multi\",\"\")","v":""},null,null,"Invoice Description:",{"$f":"IF(T55=\"3 Years\",\"Less multi-year discount (\"&BZ59&\")\",\"\")","v":""}]
[null,null,null,"  2)  Reports or Indigo™ Access.  For each country, indicate if you would like a Report Subscription or Indigo™ Access.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Amount",{"$f":"IF(T55=\"3 Years\",AF131,\"\")","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,"cc Emails",null,null,null,null,"Sales Rep"]
[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,{"$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":"U138","v":0}]
[]
[]
[null,null,null,"Country",null,null,null,null,null,null,null,null,null,"Survey Option",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,"Organization Name","Order Number","Class",{"$f":"IF(SubPeriod=\"1 Year\",\"Data: Annual Report Purchase:Annual\",\"Data: Annual Report Purchase:Multi-year\")","v":"Data: Annual Report Purchase:Multi-year"},{"$f":"IF(SubPeriod=\"1 Year\",\"Data:Annual Indigo Purchase:Subscription\",\"Data:Multi-year Indigo Purchase:10 to 64 countries\")","v":"Data:Multi-year Indigo Purchase:10 to 64 countries"},"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,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(N68),\"\",VLOOKUP(TotalIndigo,IF(PriorPrice=\"No\",Prices,Prior_Prices),IF('Order Form'!N68=\"Report Subscription\",3,2),TRUE))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AF68=\"Yes\",0,IF(ISBLANK(N68),\"\",IF(PriorPrice=\"No\",AA68,AA68*0.5)))","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,{"$f":"OrgName","v":0},{"$f":"OrderNumber","v":0},{"$f":"IF(ISBLANK(D68),\"\",D68)","v":""},{"$f":"IF(N68=\"Report Subscription\",AA68,0)","v":0},{"$f":"IF(N68=\"Indigo™ Interactive Access\",AA68,0)","v":0},{"$f":"IF(ISBLANK(AO68),\"\",AO68)","v":""},{"$f":"IF(AO68=\"All Cycles\",CustomAll,0)+IF(OR(AO68=\"Cycle 1 (Apr)\",AO68= \"Cycle 2 (Jul)\",AO68= \"Cycle 3 (Oct)\"),CustomCut,0)","v":0},{"$f":"AJ68","v":""},{"$f":"SUM(BS68,BO68,BP68,BR68)","v":0},{"$f":"IF($T$55=\"1 Year\",\"\",IF($BZ$59=\"Year 1\",EDATE($CA$58,0),IF($BZ$59=\"Year 2\",EDATE($CA$58,12),EDATE($CA$58,24))))","v":"1901-12-31"},{"$f":"IF(BU68=\"\",\"\",DATE(YEAR(BU68)+1,MONTH(BU68),DAY(BU68)-1))","v":"1902-12-30"}]
[null,null,{"$f":"C68+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,{"$f":"IF(ISBLANK(N69),\"\",VLOOKUP(TotalIndigo,IF(PriorPrice=\"No\",Prices,Prior_Prices),IF('Order Form'!N69=\"Report Subscription\",3,2),TRUE))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AF69=\"Yes\",0,IF(ISBLANK(N69),\"\",IF(PriorPrice=\"No\",AA69,AA69*0.5)))","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,{"$f":"OrgName","v":0},0,"",0,0,"",0,"",0,"1901-12-31",{"$f":"IF(BU69=\"\",\"\",BU69+364)","v":"1902-12-30"}]
[null,null,{"$f":"C69+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,{"$f":"IF(ISBLANK(N70),\"\",VLOOKUP(TotalIndigo,IF(PriorPrice=\"No\",Prices,Prior_Prices),IF('Order Form'!N70=\"Report Subscription\",3,2),TRUE))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AF70=\"Yes\",0,IF(ISBLANK(N70),\"\",IF(PriorPrice=\"No\",AA70,AA70*0.5)))","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,0,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,{"$f":"IF(ISBLANK(N71),\"\",VLOOKUP(TotalIndigo,IF(PriorPrice=\"No\",Prices,Prior_Prices),IF('Order Form'!N71=\"Report Subscription\",3,2),TRUE))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AF71=\"Yes\",0,IF(ISBLANK(N71),\"\",IF(PriorPrice=\"No\",AA71,AA71*0.5)))","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,0,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,{"$f":"IF(ISBLANK(N72),\"\",VLOOKUP(TotalIndigo,IF(PriorPrice=\"No\",Prices,Prior_Prices),IF('Order Form'!N72=\"Report Subscription\",3,2),TRUE))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AF72=\"Yes\",0,IF(ISBLANK(N72),\"\",IF(PriorPrice=\"No\",AA72,AA72*0.5)))","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,0,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,{"$f":"IF(ISBLANK(N73),\"\",VLOOKUP(TotalIndigo,IF(PriorPrice=\"No\",Prices,Prior_Prices),IF('Order Form'!N73=\"Report Subscription\",3,2),TRUE))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AF73=\"Yes\",0,IF(ISBLANK(N73),\"\",IF(PriorPrice=\"No\",AA73,AA73*0.5)))","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,0,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,{"$f":"IF(ISBLANK(N74),\"\",VLOOKUP(TotalIndigo,IF(PriorPrice=\"No\",Prices,Prior_Prices),IF('Order Form'!N74=\"Report Subscription\",3,2),TRUE))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AF74=\"Yes\",0,IF(ISBLANK(N74),\"\",IF(PriorPrice=\"No\",AA74,AA74*0.5)))","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,0,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,{"$f":"IF(ISBLANK(N75),\"\",VLOOKUP(TotalIndigo,IF(PriorPrice=\"No\",Prices,Prior_Prices),IF('Order Form'!N75=\"Report Subscription\",3,2),TRUE))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AF75=\"Yes\",0,IF(ISBLANK(N75),\"\",IF(PriorPrice=\"No\",AA75,AA75*0.5)))","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,0,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,{"$f":"IF(ISBLANK(N76),\"\",VLOOKUP(TotalIndigo,IF(PriorPrice=\"No\",Prices,Prior_Prices),IF('Order Form'!N76=\"Report Subscription\",3,2),TRUE))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AF76=\"Yes\",0,IF(ISBLANK(N76),\"\",IF(PriorPrice=\"No\",AA76,AA76*0.5)))","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,0,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,{"$f":"IF(ISBLANK(N77),\"\",VLOOKUP(TotalIndigo,IF(PriorPrice=\"No\",Prices,Prior_Prices),IF('Order Form'!N77=\"Report Subscription\",3,2),TRUE))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AF77=\"Yes\",0,IF(ISBLANK(N77),\"\",IF(PriorPrice=\"No\",AA77,AA77*0.5)))","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,0,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,{"$f":"IF(ISBLANK(N78),\"\",VLOOKUP(TotalIndigo,IF(PriorPrice=\"No\",Prices,Prior_Prices),IF('Order Form'!N78=\"Report Subscription\",3,2),TRUE))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AF78=\"Yes\",0,IF(ISBLANK(N78),\"\",IF(PriorPrice=\"No\",AA78,AA78*0.5)))","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,0,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,{"$f":"IF(ISBLANK(N79),\"\",VLOOKUP(TotalIndigo,IF(PriorPrice=\"No\",Prices,Prior_Prices),IF('Order Form'!N79=\"Report Subscription\",3,2),TRUE))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AF79=\"Yes\",0,IF(ISBLANK(N79),\"\",IF(PriorPrice=\"No\",AA79,AA79*0.5)))","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,0,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,{"$f":"IF(ISBLANK(N80),\"\",VLOOKUP(TotalIndigo,IF(PriorPrice=\"No\",Prices,Prior_Prices),IF('Order Form'!N80=\"Report Subscription\",3,2),TRUE))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AF80=\"Yes\",0,IF(ISBLANK(N80),\"\",IF(PriorPrice=\"No\",AA80,AA80*0.5)))","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,0,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,{"$f":"IF(ISBLANK(N81),\"\",VLOOKUP(TotalIndigo,IF(PriorPrice=\"No\",Prices,Prior_Prices),IF('Order Form'!N81=\"Report Subscription\",3,2),TRUE))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AF81=\"Yes\",0,IF(ISBLANK(N81),\"\",IF(PriorPrice=\"No\",AA81,AA81*0.5)))","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,0,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,{"$f":"IF(ISBLANK(N82),\"\",VLOOKUP(TotalIndigo,IF(PriorPrice=\"No\",Prices,Prior_Prices),IF('Order Form'!N82=\"Report Subscription\",3,2),TRUE))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AF82=\"Yes\",0,IF(ISBLANK(N82),\"\",IF(PriorPrice=\"No\",AA82,AA82*0.5)))","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,0,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,{"$f":"IF(ISBLANK(N83),\"\",VLOOKUP(TotalIndigo,IF(PriorPrice=\"No\",Prices,Prior_Prices),IF('Order Form'!N83=\"Report Subscription\",3,2),TRUE))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AF83=\"Yes\",0,IF(ISBLANK(N83),\"\",IF(PriorPrice=\"No\",AA83,AA83*0.5)))","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,0,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,{"$f":"IF(ISBLANK(N84),\"\",VLOOKUP(TotalIndigo,IF(PriorPrice=\"No\",Prices,Prior_Prices),IF('Order Form'!N84=\"Report Subscription\",3,2),TRUE))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AF84=\"Yes\",0,IF(ISBLANK(N84),\"\",IF(PriorPrice=\"No\",AA84,AA84*0.5)))","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,0,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,{"$f":"IF(ISBLANK(N85),\"\",VLOOKUP(TotalIndigo,IF(PriorPrice=\"No\",Prices,Prior_Prices),IF('Order Form'!N85=\"Report Subscription\",3,2),TRUE))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AF85=\"Yes\",0,IF(ISBLANK(N85),\"\",IF(PriorPrice=\"No\",AA85,AA85*0.5)))","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,0,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,{"$f":"IF(ISBLANK(N86),\"\",VLOOKUP(TotalIndigo,IF(PriorPrice=\"No\",Prices,Prior_Prices),IF('Order Form'!N86=\"Report Subscription\",3,2),TRUE))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AF86=\"Yes\",0,IF(ISBLANK(N86),\"\",IF(PriorPrice=\"No\",AA86,AA86*0.5)))","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,0,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,{"$f":"IF(ISBLANK(N87),\"\",VLOOKUP(TotalIndigo,IF(PriorPrice=\"No\",Prices,Prior_Prices),IF('Order Form'!N87=\"Report Subscription\",3,2),TRUE))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AF87=\"Yes\",0,IF(ISBLANK(N87),\"\",IF(PriorPrice=\"No\",AA87,AA87*0.5)))","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,0,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,{"$f":"IF(ISBLANK(N88),\"\",VLOOKUP(TotalIndigo,IF(PriorPrice=\"No\",Prices,Prior_Prices),IF('Order Form'!N88=\"Report Subscription\",3,2),TRUE))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AF88=\"Yes\",0,IF(ISBLANK(N88),\"\",IF(PriorPrice=\"No\",AA88,AA88*0.5)))","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,0,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,{"$f":"IF(ISBLANK(N89),\"\",VLOOKUP(TotalIndigo,IF(PriorPrice=\"No\",Prices,Prior_Prices),IF('Order Form'!N89=\"Report Subscription\",3,2),TRUE))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AF89=\"Yes\",0,IF(ISBLANK(N89),\"\",IF(PriorPrice=\"No\",AA89,AA89*0.5)))","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,0,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,{"$f":"IF(ISBLANK(N90),\"\",VLOOKUP(TotalIndigo,IF(PriorPrice=\"No\",Prices,Prior_Prices),IF('Order Form'!N90=\"Report Subscription\",3,2),TRUE))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AF90=\"Yes\",0,IF(ISBLANK(N90),\"\",IF(PriorPrice=\"No\",AA90,AA90*0.5)))","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,0,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,{"$f":"IF(ISBLANK(N91),\"\",VLOOKUP(TotalIndigo,IF(PriorPrice=\"No\",Prices,Prior_Prices),IF('Order Form'!N91=\"Report Subscription\",3,2),TRUE))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AF91=\"Yes\",0,IF(ISBLANK(N91),\"\",IF(PriorPrice=\"No\",AA91,AA91*0.5)))","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,0,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,{"$f":"IF(ISBLANK(N92),\"\",VLOOKUP(TotalIndigo,IF(PriorPrice=\"No\",Prices,Prior_Prices),IF('Order Form'!N92=\"Report Subscription\",3,2),TRUE))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AF92=\"Yes\",0,IF(ISBLANK(N92),\"\",IF(PriorPrice=\"No\",AA92,AA92*0.5)))","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,0,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,{"$f":"IF(ISBLANK(N93),\"\",VLOOKUP(TotalIndigo,IF(PriorPrice=\"No\",Prices,Prior_Prices),IF('Order Form'!N93=\"Report Subscription\",3,2),TRUE))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AF93=\"Yes\",0,IF(ISBLANK(N93),\"\",IF(PriorPrice=\"No\",AA93,AA93*0.5)))","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,0,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,{"$f":"IF(ISBLANK(N94),\"\",VLOOKUP(TotalIndigo,IF(PriorPrice=\"No\",Prices,Prior_Prices),IF('Order Form'!N94=\"Report Subscription\",3,2),TRUE))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AF94=\"Yes\",0,IF(ISBLANK(N94),\"\",IF(PriorPrice=\"No\",AA94,AA94*0.5)))","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,0,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,{"$f":"IF(ISBLANK(N95),\"\",VLOOKUP(TotalIndigo,IF(PriorPrice=\"No\",Prices,Prior_Prices),IF('Order Form'!N95=\"Report Subscription\",3,2),TRUE))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AF95=\"Yes\",0,IF(ISBLANK(N95),\"\",IF(PriorPrice=\"No\",AA95,AA95*0.5)))","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,0,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,{"$f":"IF(ISBLANK(N96),\"\",VLOOKUP(TotalIndigo,IF(PriorPrice=\"No\",Prices,Prior_Prices),IF('Order Form'!N96=\"Report Subscription\",3,2),TRUE))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AF96=\"Yes\",0,IF(ISBLANK(N96),\"\",IF(PriorPrice=\"No\",AA96,AA96*0.5)))","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,0,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,{"$f":"IF(ISBLANK(N97),\"\",VLOOKUP(TotalIndigo,IF(PriorPrice=\"No\",Prices,Prior_Prices),IF('Order Form'!N97=\"Report Subscription\",3,2),TRUE))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AF97=\"Yes\",0,IF(ISBLANK(N97),\"\",IF(PriorPrice=\"No\",AA97,AA97*0.5)))","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,0,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,{"$f":"IF(ISBLANK(N98),\"\",VLOOKUP(TotalIndigo,IF(PriorPrice=\"No\",Prices,Prior_Prices),IF('Order Form'!N98=\"Report Subscription\",3,2),TRUE))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AF98=\"Yes\",0,IF(ISBLANK(N98),\"\",IF(PriorPrice=\"No\",AA98,AA98*0.5)))","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,0,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,{"$f":"IF(ISBLANK(N99),\"\",VLOOKUP(TotalIndigo,IF(PriorPrice=\"No\",Prices,Prior_Prices),IF('Order Form'!N99=\"Report Subscription\",3,2),TRUE))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AF99=\"Yes\",0,IF(ISBLANK(N99),\"\",IF(PriorPrice=\"No\",AA99,AA99*0.5)))","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,0,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,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(N100),\"\",VLOOKUP(TotalIndigo,IF(PriorPrice=\"No\",Prices,Prior_Prices),IF('Order Form'!N100=\"Report Subscription\",3,2),TRUE))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AF100=\"Yes\",0,IF(ISBLANK(N100),\"\",IF(PriorPrice=\"No\",AA100,AA100*0.5)))","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,0,0,{"$f":"IF(ISBLANK(D100),\"\",D100)","v":""},{"$f":"IF(N100=\"Report Subscription\",AA100,0)","v":0},{"$f":"IF(N100=\"Indigo™ Interactive Access\",AA100,0)","v":0},{"$f":"IF(ISBLANK(AO100),\"\",AO100)","v":""},{"$f":"IF(AO100=\"All Cycles\",CustomAll,0)+IF(OR(AO100=\"Cycle 1 (Apr)\",AO100= \"Cycle 2 (Jul)\",AO100= \"Cycle 3 (Oct)\"),CustomCut,0)","v":0},{"$f":"AJ100","v":""},{"$f":"SUM(BS100,BO100,BP100,BR100)","v":0},{"$f":"IF($T$55=\"1 Year\",\"\",IF($BZ$59=\"Year 1\",EDATE($CA$58,0),IF($BZ$59=\"Year 2\",EDATE($CA$58,12),EDATE($CA$58,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,{"$f":"IF(ISBLANK(N101),\"\",VLOOKUP(TotalIndigo,IF(PriorPrice=\"No\",Prices,Prior_Prices),IF('Order Form'!N101=\"Report Subscription\",3,2),TRUE))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AF101=\"Yes\",0,IF(ISBLANK(N101),\"\",IF(PriorPrice=\"No\",AA101,AA101*0.5)))","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,0,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,{"$f":"IF(ISBLANK(N102),\"\",VLOOKUP(TotalIndigo,IF(PriorPrice=\"No\",Prices,Prior_Prices),IF('Order Form'!N102=\"Report Subscription\",3,2),TRUE))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AF102=\"Yes\",0,IF(ISBLANK(N102),\"\",IF(PriorPrice=\"No\",AA102,AA102*0.5)))","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,0,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,{"$f":"IF(ISBLANK(N103),\"\",VLOOKUP(TotalIndigo,IF(PriorPrice=\"No\",Prices,Prior_Prices),IF('Order Form'!N103=\"Report Subscription\",3,2),TRUE))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AF103=\"Yes\",0,IF(ISBLANK(N103),\"\",IF(PriorPrice=\"No\",AA103,AA103*0.5)))","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,0,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,{"$f":"IF(ISBLANK(N104),\"\",VLOOKUP(TotalIndigo,IF(PriorPrice=\"No\",Prices,Prior_Prices),IF('Order Form'!N104=\"Report Subscription\",3,2),TRUE))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AF104=\"Yes\",0,IF(ISBLANK(N104),\"\",IF(PriorPrice=\"No\",AA104,AA104*0.5)))","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,0,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,{"$f":"IF(ISBLANK(N105),\"\",VLOOKUP(TotalIndigo,IF(PriorPrice=\"No\",Prices,Prior_Prices),IF('Order Form'!N105=\"Report Subscription\",3,2),TRUE))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AF105=\"Yes\",0,IF(ISBLANK(N105),\"\",IF(PriorPrice=\"No\",AA105,AA105*0.5)))","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,0,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,{"$f":"IF(ISBLANK(N106),\"\",VLOOKUP(TotalIndigo,IF(PriorPrice=\"No\",Prices,Prior_Prices),IF('Order Form'!N106=\"Report Subscription\",3,2),TRUE))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AF106=\"Yes\",0,IF(ISBLANK(N106),\"\",IF(PriorPrice=\"No\",AA106,AA106*0.5)))","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,0,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,{"$f":"IF(ISBLANK(N107),\"\",VLOOKUP(TotalIndigo,IF(PriorPrice=\"No\",Prices,Prior_Prices),IF('Order Form'!N107=\"Report Subscription\",3,2),TRUE))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AF107=\"Yes\",0,IF(ISBLANK(N107),\"\",IF(PriorPrice=\"No\",AA107,AA107*0.5)))","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,0,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,{"$f":"IF(ISBLANK(N108),\"\",VLOOKUP(TotalIndigo,IF(PriorPrice=\"No\",Prices,Prior_Prices),IF('Order Form'!N108=\"Report Subscription\",3,2),TRUE))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AF108=\"Yes\",0,IF(ISBLANK(N108),\"\",IF(PriorPrice=\"No\",AA108,AA108*0.5)))","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,0,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,{"$f":"IF(ISBLANK(N109),\"\",VLOOKUP(TotalIndigo,IF(PriorPrice=\"No\",Prices,Prior_Prices),IF('Order Form'!N109=\"Report Subscription\",3,2),TRUE))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AF109=\"Yes\",0,IF(ISBLANK(N109),\"\",IF(PriorPrice=\"No\",AA109,AA109*0.5)))","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,0,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,{"$f":"IF(ISBLANK(N110),\"\",VLOOKUP(TotalIndigo,IF(PriorPrice=\"No\",Prices,Prior_Prices),IF('Order Form'!N110=\"Report Subscription\",3,2),TRUE))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AF110=\"Yes\",0,IF(ISBLANK(N110),\"\",IF(PriorPrice=\"No\",AA110,AA110*0.5)))","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,0,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,{"$f":"IF(ISBLANK(N111),\"\",VLOOKUP(TotalIndigo,IF(PriorPrice=\"No\",Prices,Prior_Prices),IF('Order Form'!N111=\"Report Subscription\",3,2),TRUE))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AF111=\"Yes\",0,IF(ISBLANK(N111),\"\",IF(PriorPrice=\"No\",AA111,AA111*0.5)))","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,0,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,{"$f":"IF(ISBLANK(N112),\"\",VLOOKUP(TotalIndigo,IF(PriorPrice=\"No\",Prices,Prior_Prices),IF('Order Form'!N112=\"Report Subscription\",3,2),TRUE))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AF112=\"Yes\",0,IF(ISBLANK(N112),\"\",IF(PriorPrice=\"No\",AA112,AA112*0.5)))","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,0,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,{"$f":"IF(ISBLANK(N113),\"\",VLOOKUP(TotalIndigo,IF(PriorPrice=\"No\",Prices,Prior_Prices),IF('Order Form'!N113=\"Report Subscription\",3,2),TRUE))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AF113=\"Yes\",0,IF(ISBLANK(N113),\"\",IF(PriorPrice=\"No\",AA113,AA113*0.5)))","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,0,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,{"$f":"IF(ISBLANK(N114),\"\",VLOOKUP(TotalIndigo,IF(PriorPrice=\"No\",Prices,Prior_Prices),IF('Order Form'!N114=\"Report Subscription\",3,2),TRUE))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AF114=\"Yes\",0,IF(ISBLANK(N114),\"\",IF(PriorPrice=\"No\",AA114,AA114*0.5)))","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,0,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,{"$f":"IF(ISBLANK(N115),\"\",VLOOKUP(TotalIndigo,IF(PriorPrice=\"No\",Prices,Prior_Prices),IF('Order Form'!N115=\"Report Subscription\",3,2),TRUE))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AF115=\"Yes\",0,IF(ISBLANK(N115),\"\",IF(PriorPrice=\"No\",AA115,AA115*0.5)))","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,0,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,{"$f":"IF(ISBLANK(N116),\"\",VLOOKUP(TotalIndigo,IF(PriorPrice=\"No\",Prices,Prior_Prices),IF('Order Form'!N116=\"Report Subscription\",3,2),TRUE))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AF116=\"Yes\",0,IF(ISBLANK(N116),\"\",IF(PriorPrice=\"No\",AA116,AA116*0.5)))","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,0,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,{"$f":"IF(ISBLANK(N117),\"\",VLOOKUP(TotalIndigo,IF(PriorPrice=\"No\",Prices,Prior_Prices),IF('Order Form'!N117=\"Report Subscription\",3,2),TRUE))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AF117=\"Yes\",0,IF(ISBLANK(N117),\"\",IF(PriorPrice=\"No\",AA117,AA117*0.5)))","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,0,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,{"$f":"IF(ISBLANK(N118),\"\",VLOOKUP(TotalIndigo,IF(PriorPrice=\"No\",Prices,Prior_Prices),IF('Order Form'!N118=\"Report Subscription\",3,2),TRUE))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AF118=\"Yes\",0,IF(ISBLANK(N118),\"\",IF(PriorPrice=\"No\",AA118,AA118*0.5)))","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,0,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,{"$f":"IF(ISBLANK(N119),\"\",VLOOKUP(TotalIndigo,IF(PriorPrice=\"No\",Prices,Prior_Prices),IF('Order Form'!N119=\"Report Subscription\",3,2),TRUE))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AF119=\"Yes\",0,IF(ISBLANK(N119),\"\",IF(PriorPrice=\"No\",AA119,AA119*0.5)))","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,0,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,{"$f":"IF(ISBLANK(N120),\"\",VLOOKUP(TotalIndigo,IF(PriorPrice=\"No\",Prices,Prior_Prices),IF('Order Form'!N120=\"Report Subscription\",3,2),TRUE))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AF120=\"Yes\",0,IF(ISBLANK(N120),\"\",IF(PriorPrice=\"No\",AA120,AA120*0.5)))","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,0,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,{"$f":"IF(ISBLANK(N121),\"\",VLOOKUP(TotalIndigo,IF(PriorPrice=\"No\",Prices,Prior_Prices),IF('Order Form'!N121=\"Report Subscription\",3,2),TRUE))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AF121=\"Yes\",0,IF(ISBLANK(N121),\"\",IF(PriorPrice=\"No\",AA121,AA121*0.5)))","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,0,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,{"$f":"IF(ISBLANK(N122),\"\",VLOOKUP(TotalIndigo,IF(PriorPrice=\"No\",Prices,Prior_Prices),IF('Order Form'!N122=\"Report Subscription\",3,2),TRUE))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AF122=\"Yes\",0,IF(ISBLANK(N122),\"\",IF(PriorPrice=\"No\",AA122,AA122*0.5)))","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,0,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,{"$f":"IF(ISBLANK(N123),\"\",VLOOKUP(TotalIndigo,IF(PriorPrice=\"No\",Prices,Prior_Prices),IF('Order Form'!N123=\"Report Subscription\",3,2),TRUE))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AF123=\"Yes\",0,IF(ISBLANK(N123),\"\",IF(PriorPrice=\"No\",AA123,AA123*0.5)))","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,0,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,{"$f":"IF(ISBLANK(N124),\"\",VLOOKUP(TotalIndigo,IF(PriorPrice=\"No\",Prices,Prior_Prices),IF('Order Form'!N124=\"Report Subscription\",3,2),TRUE))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AF124=\"Yes\",0,IF(ISBLANK(N124),\"\",IF(PriorPrice=\"No\",AA124,AA124*0.5)))","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,0,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,{"$f":"IF(ISBLANK(N125),\"\",VLOOKUP(TotalIndigo,IF(PriorPrice=\"No\",Prices,Prior_Prices),IF('Order Form'!N125=\"Report Subscription\",3,2),TRUE))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AF125=\"Yes\",0,IF(ISBLANK(N125),\"\",IF(PriorPrice=\"No\",AA125,AA125*0.5)))","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,0,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,{"$f":"IF(ISBLANK(N126),\"\",VLOOKUP(TotalIndigo,IF(PriorPrice=\"No\",Prices,Prior_Prices),IF('Order Form'!N126=\"Report Subscription\",3,2),TRUE))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AF126=\"Yes\",0,IF(ISBLANK(N126),\"\",IF(PriorPrice=\"No\",AA126,AA126*0.5)))","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,0,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,{"$f":"IF(ISBLANK(N127),\"\",VLOOKUP(TotalIndigo,IF(PriorPrice=\"No\",Prices,Prior_Prices),IF('Order Form'!N127=\"Report Subscription\",3,2),TRUE))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AF127=\"Yes\",0,IF(ISBLANK(N127),\"\",IF(PriorPrice=\"No\",AA127,AA127*0.5)))","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,0,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,"Order Summary"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Base\nSurvey Fee",null,null,null,null,"(10%) Multi-year Discount (Indigo™ Only)",null,null,null,"Non-Particiption Fee",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":"[0]!TotalIndigo","v":0},null,{"$f":"SUM(BP68:BP127)","v":0},null,{"$f":"SUM(BR68:BR127)","v":0},{"$f":"SUM(BS68:BS127)","v":0},{"$f":"SUM(BT68:BT127)","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(AA68:AE127)","v":0},null,null,null,null,{"$f":"ROUND(IF(AND(T55=\"3 Years\",COUNTIF(N68:Z127,\"=Indigo™ Interactive Access\")>=10),0.1,0)*-AA131,0)","v":0},null,null,null,{"$f":"SUM(AJ68:AJ127)","v":0},null,null,null,null,{"$f":"AA131+AF131+AJ131","v":0}]
[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(T55=\"3 Years\",\"Total Contract Amount for 3 Years:      \"&TEXT(AO131*3,\"$#,###0\"),\"\")","v":""}]
[]
[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 :"},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(AB137=\"\",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(U137=\"Not Applicable\",0,ROUND((AO131/(1-U137))-AO131,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.\nClick on the column header for further help."]
[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(AO168,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(AO200,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 REGISTRATION@BIRCHESGROUP.COM"]
[]
[]
[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":3,"n_rows":5,"n_cols":9,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["Region","Country","Type x to Select",null,"All Countries",null,null,null,{"$f":"TotalIndigo","v":0}]
["Africa","South Africa","x",null,"South Africa"]
["Asia","South Korea","x",null,"South Korea"]
["Africa","South Sudan","x",null,"South Sudan"]
["Asia","Sri Lanka","x",null,"Sri Lanka"]

{"sheet":"Country Selection","index":4,"n_rows":197,"n_cols":235,"rows_kept":197,"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],[169,1,169,3],[173,2,174,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:D165,\"=x\")","v":0}]
["Please type an X in the boxes corresponding to your survey choices"]
["After completing your selections, press SUMBIT 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,"Asia","Azerbaijan"]
[null,"Americas","Bahamas"]
[null,"Asia","Bahrain"]
[null,"Asia","Bangladesh"]
[null,"Americas","Barbados"]
[null,"Europe","Belarus"]
[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","Ethiopia"]
[null,"Oceania","Fiji"]
[null,"Africa","Gabon"]
[null,"Africa","Gambia"]
[null,"Asia","Georgia"]
[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","India"]
[null,"Asia","Indonesia"]
[null,"Asia","Iran"]
[null,"Asia","Iraq"]
[null,"Asia","Israel"]
[null,"Americas","Jamaica"]
[null,"Asia","Jordan"]
[null,"Asia","Kazakhstan"]
[null,"Africa","Kenya"]
[null,"Asia","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,"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,"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,"Americas","Sint Maarten"]
[null,"Europe","Slovakia"]
[null,"Oceania","Solomon Islands"]
[null,"Africa","Somalia"]
[null,"Africa","South Africa"]
[null,"Asia","South Korea"]
[null,"Africa","South Sudan"]
[null,"Asia","Sri Lanka"]
[null,"Africa","Sudan"]
[null,"Americas","Suriname"]
[null,"Africa","Swaziland"]
[null,"Asia","Syria"]
[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,"Asia","Turkmenistan"]
[null,"Africa","Uganda"]
[null,"Europe","Ukraine"]
[null,"Asia","United Arab Emirates"]
[null,"Americas","Uruguay"]
[null,"Asia","Uzbekistan"]
[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":5,"n_rows":396,"n_cols":21,"rows_kept":396,"cut":false,"hidden":true,"merged":[]}
["State",null,"Country","Select","Salutation"]
["US States",null,"United States","X","Mr"]
["Alabama","AL","Afghanistan",null,"Ms"]
["Alaska","AK","Albania",null,"Mrs"]
["Arizona","AZ","Algeria",null,"Dr"]
["Arkansas","AR","American Samoa"]
["California","CA","Andorra"]
["Colorado","CO","Angola"]
["Connecticut","CT","Anguilla","SurveyChoice"]
["DC","DC","Antarctica","Indigo™ Interactive Access"]
["Delaware","DE","Antigua And Barbuda","Report Subscription"]
["Florida","FL","Argentina"]
["Georgia","GA","Armenia"]
["Hawaii","HI","Aruba","Yes"]
["Idaho","ID","Australia","No"]
["Illinois","IL","Austria"]
["Indiana","IN","Azerbaijan"]
["Iowa","IA","Bahamas","Non-Participant Surcharge",null,"Pay Cycles"]
["Kansas","KS","Bahrain",{"$f":"IF(OR(MultiPart=\"Yes\",SinglePart=\"Yes\"),0,0.5)","v":{"$error":"#NAME?"}},null,"Annual"]
["Kentucky","KY","Bangladesh",null,null,"Every 2 Years"]
["Louisiana","LA","Barbados",null,null,"Ad-hoc"]
["Maine","ME","Belarus"]
["Maryland","MD","Belgium","Product Selection"]
["Massachusetts","MA","Belize","Preferred Partner",null,"January","Cycle 1"]
["Michigan","MI","Benin","Ad-hoc Subscriber",null,"February","Cycle 1"]
["Minnesota","MN","Bermuda",null,null,"March","Cycle 2"]
["Mississippi","MS","Bhutan",null,null,"April","Cycle 2"]
["Missouri","MO","Bolivia","Custom Cut Select",null,"May","Cycle 2"]
["Montana","MT","Bosnia And Herzegovina","Cycle 1 (Apr)",null,"June","Cycle 3"]
["Nebraska","NE","Botswana","Cycle 2 (Jul)",null,"July","Cycle 3"]
["Nevada","NV","Bouvet Island","Cycle 3 (Oct)",null,"August","Cycle 3"]
["New Hampshire","NH","Brazil","All Cycles",null,"September","Cycle 1"]
["New Jersey","NJ","British Indian Ocean Territory",null,null,"October","Cycle 1"]
["New Mexico","NM","Brunei Darussalam",null,null,"November","Cycle 1"]
["New York","NY","Bulgaria",null,null,"December","Cycle 1"]
["North Carolina","NC","Burkina Faso"]
["North Dakota","ND","Burundi"]
["Ohio","OH","Cambodia"]
["Oklahoma","OK","Cameroon"]
["Oregon","OR","Canada"]
["Pennsylvania","PA","Cape Verde"]
["Rhode Island","RI","Cayman Islands"]
["South Carolina","SC","Central African Republic"]
["South Dakota","SD","Chad"]
["Tennessee","TN","Chile"]
["Texas","TX","China"]
["Utah","UT","Christmas Island"]
["Vermont","VT","Cocos (Keeling) Islands"]
["Virginia","VA","Colombia"]
["Washington","WA","Comoros"]
["West Virginia","WV","Congo, DR"]
["Wisconsin","WI","Congo, Republic of"]
["Wyoming","WY","Cook Islands"]
["Canadian Provinces and Territories",null,"Costa Rica"]
["Alberta","AB","Cote D'Ivoire"]
["British Columbia","BC","Croatia"]
["Manitoba","MB","Cuba"]
["New Brunswick","NB","Cyprus"]
["Newfoundland","NL","Czech Republic"]
["Northwest Territories","NT","Denmark"]
["Nova Scotia","NS","Djibouti"]
["Nunavut","NU","Dominica"]
["Ontario","ON","Dominican Republic"]
["Prince Edward Island","PE","Ecuador"]
["Quebec","QC","Egypt"]
["Saskatchewan","SK","El Salvador"]
["Yukon Territory","YT","Equatorial Guinea"]
[null,null,"Eritrea"]
[null,null,"Estonia"]
[null,null,"Eswatini"]
[null,null,"Ethiopia"]
[null,null,"Falkland Islands"]
[null,null,"Faroe Islands"]
[null,null,"Fiji"]
[null,null,"Finland"]
[null,null,"France"]
[null,null,"French Guiana"]
[null,null,"French Polynesia"]
[null,null,"French Southern Territories"]
[null,null,"Gabon"]
[null,null,"Gambia"]
[null,null,"Georgia"]
[null,null,"Germany"]
[null,null,"Ghana"]
[null,null,"Gibraltar"]
[null,null,"Greece"]
[null,null,"Greenland"]
[null,null,"Grenada"]
[null,null,"Guadeloupe"]
[null,null,"Guam"]
[null,null,"Guatemala"]
[null,null,"Guinea"]
[null,null,"Guinea-Bissau"]
[null,null,"Guyana"]
[null,null,"Haiti"]
[null,null,"Heard Island & Mcdonald Islands"]
[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,null,null,null,null,null,null,null,"Currency"]
[null,null,"Maldives",null,null,null,null,null,null,null,null,null,"USD"]
[null,null,"Mali",null,null,null,null,null,null,null,null,null,"EUR"]
[null,null,"Malta",null,null,null,null,null,null,null,null,null,"GBP"]
[null,null,"Marshall Islands",null,null,null,null,null,null,null,null,null,"CAD"]
[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,null,null,null,null,null,null,null,"first 0"]
[null,null,"Netherlands Antilles",null,null,null,null,null,null,null,null,null,"Range of selected"]
[null,null,"New Caledonia"]
[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,null,"Northern Mariana Islands"]
[null,null,"Norway"]
[null,null,"Oman"]
[null,null,"Pakistan"]
[null,null,"Palau"]
[null,null,"Panama"]
[null,null,"Papua New Guinea"]
[null,null,"Paraguay"]
[null,null,"Peru"]
[null,null,"Philippines"]
[null,null,"Pitcairn"]
[null,null,"Poland"]
[null,null,"Portugal"]
[null,null,"Puerto Rico"]
[null,null,"Qatar"]
[null,null,"Reunion"]
[null,null,"Romania"]
[null,null,"Russian Federation"]
[null,null,"Rwanda"]
[null,null,"Saint Helena"]
[null,null,"Saint Kitts And Nevis"]
[null,null,"Saint Lucia"]
[null,null,"Saint Pierre And Miquelon",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IO Fees"]
[null,null,"Saint Vincent And The Grenadines"]
[null,null,"Samoa",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Indigo™","Reports"]
[null,null,"San Marino",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2100,1840]
[null,null,"Sao Tome And Principe",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,1900,1650]
[null,null,"Saudi Arabia",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,65,1800,{"$f":"U186","v":1650}]
[null,null,"Senegal",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,130,1700,{"$f":"U186","v":1650}]
[null,null,"Serbia"]
[null,null,"Seychelles"]
[null,null,"Sierra Leone",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Prior Fees"]
[null,null,"Singapore"]
[null,null,"Slovak Republic",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Indigo™","Reports"]
[null,null,"Slovenia",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2000,1750]
[null,null,"Solomon Islands",null,null,null,null,null,null,null,null,"Product Option",null,"Count",null,null,null,null,10,{"$f":"T194*0.9","v":1800},1575]
[null,null,"Somalia",null,"1 Year",null,null,null,null,null,null,null,null,{"$f":"TotalIndigo","v":0},null,null,null,null,65,{"$f":"T194*0.85","v":1700},1575]
[null,null,"South Africa",null,"3 Years",null,null,null,null,null,null,null,null,null,null,null,null,null,130,{"$f":"T194*0.8","v":1600},1575]
[null,null,"South Sudan",null,null,null,null,null,null,null,null,"Indigo™ "]
[null,null,"Spain",null,null,null,null,null,null,null,null,"Reports",null,{"$f":"VLOOKUP(N196,L185:O189,4,TRUE)","v":{"$error":"#N/A"}}]
[null,null,"Sri Lanka",null,null,null,null,null,null,null,null,"Custom Cut"]
[null,null,"Sudan",null,null,null,null,null,null,null,null,"Custom Cut (All Cycles)"]
[null,null,"Suriname"]
[null,null,"Svalbard And Jan Mayen Islands"]
[null,null,"Sweden"]
[null,null,"Switzerland"]
[null,null,"Syria"]
[null,null,"Taiwan","Fields to report in Order Form section:"]
[null,null,"Tajikistan"]
[null,null,"Tanzania","Type of Purchase",{"$f":"IF(E202=TRUE,E194,IF(F202=TRUE,F194,IF(G202=TRUE,G194,\"\")))","v":""}]
[null,null,"Thailand","Number of Countries",{"$f":"IF(ISNA(HLOOKUP(E209,BillingCountries,2,FALSE)),\"\",HLOOKUP(E209,BillingCountries,2,FALSE))","v":""},false,"<-- This cell tracks if the Subscription Agreement is acknowledged or not"]
[null,null,"Togo","Price per Country",{"$f":"IF(ISNA(HLOOKUP(E209,BillingCountries,7,FALSE)),\"\",HLOOKUP(E209,BillingCountries,7,FALSE))","v":""}]
[null,null,"Tokelau","SubTotal",{"$f":"IF(BGSurveys=\"\",\"\",BGSurveys*UnitPrice)","v":{"$error":"#NAME?"}}]
[null,null,"Tonga","Non-Participant Surcharge",{"$f":"IF(BGSurveys=\"\",\"\",TotalInvoice*Surcharge)","v":{"$error":"#NAME?"}}]
[null,null,"Trinidad And Tobago","GrandTotal",{"$f":"IF(BGSurveys=\"\",\"\",TotalInvoice+E213)","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,"COUNTRY","Tax Rate for Services"]
[null,null,"Tunisia",null,null,null,null,null,null,null,null,null,"Chad",0.25]
[null,null,"Turkey",null,null,null,null,null,null,null,null,null,"Burkina Faso",0.2]
[null,null,"Turkmenistan",null,null,null,null,null,null,null,null,null,"Cambodia",0.14000000000000001]
[null,null,"Turks And Caicos Islands",null,null,null,null,null,null,null,null,null,"China",6.7900000000000002E-2]
[null,null,"Tuvalu",null,null,null,null,null,null,null,null,null,"Ethiopia",0.15]
[null,null,"Uganda",null,null,null,null,null,null,null,null,null,"Gabon",0.1]
[null,null,"Ukraine",null,null,null,null,null,null,null,null,null,"Ghana",0.2]
[null,null,"United Arab Emirates",null,null,null,null,null,null,null,null,null,"Haiti",0.2]
[null,null,"United Kingdom",null,null,null,null,null,null,null,null,null,"India",0.3]
[null,null,"United States Minor Outlying Islands",null,null,null,null,null,null,null,null,null,"Kenya",0.2]
[null,null,"Uruguay",null,null,null,null,null,null,null,null,null,"Laos",0.1]
[null,null,"Uzbekistan",null,null,null,null,null,null,null,null,null,"Lebanon",7.4999999999999997E-2]
[null,null,"Vanuatu",null,null,null,null,null,null,null,null,null,"Malawi",0.15]
[null,null,"Vatican City State (Holy See)",null,null,null,null,null,null,null,null,null,"Mongolia",0.2]
[null,null,"Venezuela",null,null,null,null,null,null,null,null,null,"Mozambique",0.15]
[null,null,"Viet Nam",null,null,null,null,null,null,null,null,null,"Nicaragua",0.15]
[null,null,"Virgin Islands (British)",null,null,null,null,null,null,null,null,null,"Pakistan",0.15]
[null,null,"Virgin Islands (U.S.)",null,null,null,null,null,null,null,null,null,"Philippines",0.1]
[null,null,"Wallis And Futuna Islands",null,null,null,null,null,null,null,null,null,"Rwanda",0.15]
[null,null,"Western Sahara",null,null,null,null,null,null,null,null,null,"Sierra Leone ",0.1]
[null,null,"Yemen",null,null,null,null,null,null,null,null,null,"South Africa",0.2]
[null,null,"Zambia",null,null,null,null,null,null,null,null,null,"South Sudan",0.15]
[null,null,"Zimbabwe",null,null,null,null,null,null,null,null,null,"Turkmenistan",0.1]
[null,null,null,null,null,null,null,null,null,null,null,null,"Uganda",0.15]
[null,null,null,null,null,null,null,null,null,null,null,null,"Tanzania",0.15]
[]
[null,null,"Afghanistan"]
[null,null,"Albania"]
[null,null,"Algeria "]
[null,null,"Angola "]
[null,null,"Argentina"]
[null,null,"Armenia"]
[null,null,"Azerbaijan"]
[null,null,"Bahamas"]
[null,null,"Bahrain"]
[null,null,"Bangladesh"]
[null,null,"Barbados"]
[null,null,"Belarus "]
[null,null,"Benin "]
[null,null,"Belize"]
[null,null,"Bermuda"]
[null,null,"Bhutan"]
[null,null,"Bolivia "]
[null,null,"Bosnia and Herzegovina"]
[null,null,"Botswana"]
[null,null,"Brazil"]
[null,null,"Brunei"]
[null,null,"Bulgaria"]
[null,null,"Burkina Faso"]
[null,null,"Burundi"]
[null,null,"Cambodia"]
[null,null,"Cameroon"]
[null,null,"Cape Verde"]
[null,null,"Cayman Islands"]
[null,null,"Central African Republic"]
[null,null,"Chad"]
[null,null,"Chile"]
[null,null,"China"]
[null,null,"Colombia"]
[null,null,"Comoros"]
[null,null,"Congo, Dem Republic of"]
[null,null,"Congo, Republic of the"]
[null,null,"Costa Rica"]
[null,null,"Cote D'Ivoire"]
[null,null,"Croatia"]
[null,null,"Cuba"]
[null,null,"Curaçao"]
[null,null,"Djibouti"]
[null,null,"Dominican Republic"]
[null,null,"Ecuador"]
[null,null,"Egypt"]
[null,null,"El Salvador"]
[null,null,"Equatorial Guinea"]
[null,null,"Eritrea"]
[null,null,"Estonia"]
[null,null,"Ethiopia"]
[null,null,"Fiji"]
[null,null,"Gabon"]
[null,null,"Gambia"]
[null,null,"Georgia"]
[null,null,"Ghana"]
[null,null,"Grenada"]
[null,null,"Guatemala"]
[null,null,"Guinea"]
[null,null,"Guinea-Bissau"]
[null,null,"Guyana "]
[null,null,"Haiti "]
[null,null,"Honduras "]
[null,null,"Iceland"]
[null,null,"India "]
[null,null,"Indonesia"]
[null,null,"Iran "]
[null,null,"Iraq "]
[null,null,"Israel"]
[null,null,"Jamaica "]
[null,null,"Jordan"]
[null,null,"Kazakhstan"]
[null,null,"Kenya"]
[null,null,"Kiribati"]
[null,null,"Kosovo"]
[null,null,"Kuwait"]
[null,null,"Kyrgyzstan "]
[null,null,"Laos "]
[null,null,"Latvia"]
[null,null,"Lebanon"]
[null,null,"Lesotho "]
[null,null,"Liberia "]
[null,null,"Libya "]
[null,null,"Lithuania"]
[null,null,"Macedonia, fYro"]
[null,null,"Madagascar"]
[null,null,"Malawi"]
[null,null,"Malaysia"]
[null,null,"Maldives"]
[null,null,"Mali"]
[null,null,"Malta"]
[null,null,"Marshall Islands"]
[null,null,"Mauritania"]
[null,null,"Mauritius"]
[null,null,"Micronesia, Fed. States of"]
[null,null,"Moldova"]
[null,null,"Mongolia"]
[null,null,"Montenegro"]
[null,null,"Morocco"]
[null,null,"Mozambique "]
[null,null,"Myanmar "]
[null,null,"Namibia "]
[null,null,"Nepal "]
[null,null,"Nicaragua"]
[null,null,"Niger"]
[null,null,"Nigeria"]
[null,null,"Oman"]
[null,null,"Pakistan"]
[null,null,"Palau"]
[null,null,"Panama"]
[null,null,"Papua New Guinea"]
[null,null,"Paraguay"]
[null,null,"Peru"]
[null,null,"Philippines"]
[null,null,"Poland"]
[null,null,"Qatar"]
[null,null,"Romania"]
[null,null,"Russia"]
[null,null,"Rwanda"]
[null,null,"Samoa"]
[null,null,"Sao Tome & Principe"]
[null,null,"Saudi Arabia"]
[null,null,"Senegal"]
[null,null,"Serbia"]
[null,null,"Seychelles"]
[null,null,"Sierra Leone"]
[null,null,"Slovakia"]
[null,null,"Solomon Islands"]
[null,null,"Somalia"]
[null,null,"South Africa"]
[null,null,"South Korea"]
[null,null,"South Sudan"]
[null,null,"Sri Lanka"]
[null,null,"Sudan"]
[null,null,"Suriname"]
[null,null,"Swaziland"]
[null,null,"Syria"]
[null,null,"Tajikistan"]
[null,null,"Tanzania"]
[null,null,"Thailand"]
[null,null,"Timor-Leste"]
[null,null,"Togo"]
[null,null,"Tonga"]
[null,null,"Trinidad and Tobago"]
[null,null,"Tunisia"]
[null,null,"Turkey"]
[null,null,"Turkmenistan"]
[null,null,"Uganda"]
[null,null,"Ukraine"]
[null,null,"United Arab Emirates"]
[null,null,"Uruguay"]
[null,null,"Uzbekistan"]
[null,null,"Venezuela"]
[null,null,"Vietnam"]
[null,null,"Yemen"]
[null,null,"Zambia"]
[null,null,"Zimbabwe"]

{"sheet":"Subscription Agreement","index":6,"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 50% of the survey fee for each country for which data is not submitted."]
[]
[null,"17.  Data Storage and Transference","The data collected in our compensation and benefits surveys can be processed by Birches Group and any Aon entity 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 and Aon 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,"18.  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":7,"n_rows":200,"n_cols":128,"rows_kept":200,"cut":false,"hidden":false,"merged":[[48,26,48,34],[48,35,48,45],[48,46,48,63],[48,64,48,77],[48,78,48,91],[8,2,8,48],[6,1,6,83],[47,78,47,91],[199,3,199,12],[199,13,199,25],[199,26,199,34],[199,35,199,45],[199,46,199,63],[199,64,199,77],[199,78,199,91],[48,3,48,12],[48,13,48,25],[47,3,47,12],[47,13,47,25],[47,26,47,34],[47,35,47,45],[47,46,47,63],[47,64,47,77],[45,78,45,91],[46,3,46,12],[46,13,46,25],[46,26,46,34],[46,35,46,45],[46,46,46,63],[46,64,46,77],[46,78,46,91],[45,3,45,12],[45,13,45,25],[45,26,45,34],[45,35,45,45],[45,46,45,63],[45,64,45,77],[43,78,43,91],[44,3,44,12],[44,13,44,25],[44,26,44,34],[44,35,44,45],[44,46,44,63],[44,64,44,77],[44,78,44,91],[43,3,43,12],[43,13,43,25],[43,26,43,34],[43,35,43,45],[43,46,43,63],[43,64,43,77],[41,78,41,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],[42,78,42,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],[39,78,39,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],[40,78,40,91],[39,3,39,12],[39,13,39,25],[39,26,39,34],[39,35,39,45],[39,46,39,63],[39,64,39,77],[37,78,37,91],[38,3,38,12],[38,13,38,25],[38,26,38,34],[38,35,38,45],[38,46,38,63],[38,64,38,77],[38,78,38,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],[35,78,35,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],[36,78,36,91],[35,3,35,12],[35,13,35,25],[35,26,35,34],[35,35,35,45],[35,46,35,63],[35,64,35,77],[33,78,33,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],[34,78,34,91],[33,3,33,12],[33,13,33,25],[33,26,33,34],[33,35,33,45],[33,46,33,63],[33,64,33,77],[31,78,31,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],[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],[29,3,29,12],[29,13,29,25],[29,26,29,34],[29,35,29,45],[29,46,29,63],[29,64,29,77],[27,3,27,12],[27,13,27,25],[27,26,27,34],[27,35,27,45],[27,46,27,63],[27,64,27,77],[27,78,27,91],[29,78,29,91],[29,96,29,113],[26,35,26,45],[26,46,26,63],[26,64,26,77],[26,78,26,91],[28,13,28,25],[28,26,28,34],[28,35,28,45],[28,46,28,63],[28,64,28,77],[28,78,28,91],[49,3,49,12],[49,13,49,25],[49,26,49,34],[49,35,49,45],[49,46,49,63],[49,64,49,77],[49,78,49,91],[12,2,12,134],[14,2,14,72],[22,2,22,54],[24,2,24,25],[24,26,24,45],[25,3,25,12],[25,13,25,25],[25,26,25,34],[25,35,25,45],[25,46,25,63],[27,96,28,115],[28,3,28,12],[25,64,25,77],[25,78,25,91],[26,3,26,12],[26,13,26,25],[26,26,26,34]]}
[]
[]
[]
[]
[]
[]
[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,"Adhoc Range",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,"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(\",\",AA27)),1,IF($DO$20=\"PP\",1,IF(AA27=\"All Countries\",1,IF(VLOOKUP(AA27,AdHocRange,11,FALSE)=\"Indigo™ Interactive Access\",1,0))))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,"Ms",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(\",\",AA50)),1,IF($DO$20=\"PP\",1,IF(AA50=\"All Countries\",1,IF(VLOOKUP(AA50,AdHocRange,11,FALSE)=\"Indigo™ Interactive Access\",1,0))))","v":{"$error":"#N/A"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(\",\",AA200)),1,IF($DO$20=\"PP\",1,IF(AA200=\"All Countries\",1,IF(VLOOKUP(AA200,AdHocRange,11,FALSE)=\"Indigo™ Interactive Access\",1,0))))","v":{"$error":"#N/A"}}]

{"sheet":"Survey Contacts","index":8,"n_rows":26,"n_cols":136,"rows_kept":26,"cut":false,"hidden":false,"merged":[[175,94,175,107],[175,108,175,121],[175,122,175,135],[6,1,6,83],[8,2,8,48],[175,2,175,10],[175,11,175,18],[175,19,175,36],[175,37,175,54],[175,55,175,72],[175,73,175,93],[47,122,47,135],[48,2,48,10],[48,11,48,18],[48,19,48,36],[48,37,48,54],[48,55,48,72],[48,73,48,93],[48,94,48,107],[48,108,48,121],[48,122,48,135],[46,108,46,121],[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],[45,94,45,107],[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],[45,2,45,10],[45,11,45,18],[45,19,45,36],[45,37,45,54],[45,55,45,72],[45,73,45,93],[44,2,44,10],[44,11,44,18],[44,19,44,36],[44,37,44,54],[44,55,44,72],[44,73,44,93],[44,94,44,107],[44,108,44,121],[44,122,44,135],[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],[41,94,41,107],[41,108,41,121],[41,122,41,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],[41,2,41,10],[41,11,41,18],[41,19,41,36],[41,37,41,54],[41,55,41,72],[41,73,41,93],[42,108,42,121],[42,122,42,135],[40,2,40,10],[40,11,40,18],[40,19,40,36],[40,37,40,54],[40,55,40,72],[40,73,40,93],[40,94,40,107],[40,108,40,121],[40,122,40,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],[37,94,37,107],[37,108,37,121],[37,122,37,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],[37,2,37,10],[37,11,37,18],[37,19,37,36],[37,37,37,54],[37,55,37,72],[37,73,37,93],[38,108,38,121],[38,122,38,135],[36,2,36,10],[36,11,36,18],[36,19,36,36],[36,37,36,54],[36,55,36,72],[36,73,36,93],[36,94,36,107],[36,108,36,121],[36,122,36,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],[33,94,33,107],[33,108,33,121],[33,122,33,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],[33,2,33,10],[33,11,33,18],[33,19,33,36],[33,37,33,54],[33,55,33,72],[33,73,33,93],[34,108,34,121],[34,122,34,135],[32,2,32,10],[32,11,32,18],[32,19,32,36],[32,37,32,54],[32,55,32,72],[32,73,32,93],[32,94,32,107],[32,108,32,121],[32,122,32,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],[29,94,29,107],[29,108,29,121],[29,122,29,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],[29,2,29,10],[29,11,29,18],[29,19,29,36],[29,37,29,54],[29,55,29,72],[29,73,29,93],[30,108,30,121],[30,122,30,135],[28,2,28,10],[28,11,28,18],[28,19,28,36],[28,37,28,54],[28,55,28,72],[28,73,28,93],[28,94,28,107],[28,108,28,121],[28,122,28,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],[25,122,25,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],[9,2,9,57],[11,2,11,114],[19,2,19,14],[20,2,21,90],[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]]}
[]
[]
[]
[]
[]
[]
[null,"Individuals to Provide Data to the Survey"]
[]
[]
[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"]

{"sheet":"Invoices","index":9,"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 values should be automatically populated):"]
[]
[null,null,"a)","Type of Registration",null,"Order Form","Order Form"]
[null,null,"b)","Name of Client",null,{"$f":"IF(ISBLANK(BillingOrgName),OrgName,BillingOrgName)","v":0}]
[null,null,"c)","Order Number",null,{"$f":"OrderNumber","v":0}]
[null,null,"c)","Customer Number",null,{"$f":"AccountNumber","v":0},"This must be entered 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."]