{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Data","Demographics","Population","Race","Income Distribution","Housing Distribution","Instructions","Definitions"],"not_rendered":{"charts":11,"images":0,"macros":1,"external_links":0,"defined_names":6,"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":"Data","index":0,"n_rows":6,"n_cols":55,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[null,null,null,{"$f":"\"ZIP Code Data for \" & L1","v":"ZIP Code Data for Example Zip Codes"},null,null,null,null,null,null,"Report Name","Example Zip Codes"]
[null,"Your Entry","Distance","City","State","Occurences","Population","Population Estimate","Business Annual Payroll ($1000)","Business First Quarter Payroll ($1000)","Median Age","Male Population","Female Population","Median Age Female","Median Age Male","Households","Persons Per Household","Income Per Household","Number of Businesses","Number of Employees","Delivery Business","Delivery Residential","Delivery Total","Median House Value","CBSA Population","CBSA Division Population","CBSA Name","CBSA Number","CBSA Type","City Alias Name","State Full Name","State FIPS","County Name","County FIPS","Latitude","Longitude","Region","Division","Area Code","DayLight Savings","Land Area","Water Area","Congressional District","Congressional Land Area","Asian Population","Black or African American Population","American Indian or Alaskan Native Population","Native Hawaiian or other Pacific Islander Population","White Population","Other Population","Growing Counties A","Growing Counties B","Growth Increase Number","Growth Increase Percentage","Growth Rank"]
[null,"06830",null,"GREENWICH","CT",1,24027,25298,2872620,993221,42.4,11263,12764,44.1,40.200000000000003,9766,2.4300000000000002,107086,1518,20947,1467,10411,11815,1465100,916829,0,"Bridgeport-Stamford-Norwalk, CT",14860,"Metro","GREENWICH","Connecticut",9,"FAIRFIELD",1,41.039805999999999,-73.625848000000005,"Northeast","New England","203/475","Y",13.538,4.843,4,460.73,1851,1048,107,23,20477,1116,0,0,0,0,0]
[null,"90210",null,"BEVERLY HILLS","CA",1,21741,23625,2570383,590989,47.5,10292,11449,47.1,47.9,8669,2.4900000000000002,149732,2466,37602,1484,9488,10890,2000000,0,9818605,"Los Angeles-Long Beach-Anaheim, CA",31080,"Metro","BEVERLY HILLS","California",6,"LOS ANGELES",37,34.103130999999998,-118.416253,"West","Pacific","310/424","Y",10.125999999999999,6.0999999999999999E-2,"28|30|33","218.45|135.94|288.58",1966,471,80,55,19761,387,0,0,0,0,0]
[null,"78745",null,"AUSTIN","TX",1,55614,64722,774523,181060,33.1,27813,27801,34.1,32.299999999999997,24081,2.2999999999999998,60567,1464,21363,1605,28140,35566,229200,1716289,0,"Austin-Round Rock-Georgetown, TX",12420,"Metro","AUSTIN","Texas",48,"TRAVIS",453,30.200659000000002,-97.797109000000006,"South","West South Central",512,"Y",13.351000000000001,0,"21|25|35","5920.89|7620.7|593.77",1582,3135,1146,105,42252,9643,1024272,1063130,38858,3.8,28]
[null,"90272",null,"PACIFIC PALISADES","CA",1,22986,23179,298837,61908,47.3,10952,12034,47.7,46.8,9212,2.4900000000000002,180962,887,6211,516,9309,10702,2000000,0,9818605,"Los Angeles-Long Beach-Anaheim, CA",31080,"Metro","PACIFIC PALISADES","California",6,"LOS ANGELES",37,34.078344999999999,-118.5475,"West","Pacific",424,"Y",22.832000000000001,0.55000000000000004,33,288.58,1692,288,115,41,21334,265,0,0,0,0,0]

{"sheet":"Demographics","index":1,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[{"$f":"\"Demographic Totals and Averages for \" & Data!L1","v":"Demographic Totals and Averages for Example Zip Codes"}]
[null,"Population",{"$f":"SUM(Data!G3:G100000)","v":124368},"Delivery Business",{"$f":"SUM(Data!U3:U100000)","v":5072}]
[null,"Population Estimate",{"$f":"SUM(Data!H3:H100000)","v":136824},"Delivery Residential",{"$f":"SUM(Data!V3:V100000)","v":57348}]
[null,"Business Annual Payroll ($1000)",{"$f":"SUM(Data!I3:I100000)","v":6516363},"Delivery Total",{"$f":"SUM(Data!W4:W100000)","v":57158}]
[null,"Business First Quarter ($1000)",{"$f":"SUM(Data!J3:J100000)","v":1827178},"Median Housing Value",{"$f":"SUMPRODUCT(Data!$F$3:$F$100000,Data!$X$3:$X$100000*($W$3:$W$100000<>\"0\"))/SUMIF(Data!$X$3:$X$100000,\"<>0\",Data!$F$3:$F$100000)","v":1423575}]
[null,"Median Age",{"$f":"SUMPRODUCT(Data!$F$3:$F$100000,Data!$K$3:$K$100000*($K$3:$K$100000<>\"0\"))/SUMIF(Data!$K$3:$K$100000,\"<>0\",Data!$F$3:$F$100000)","v":42.575000000000003},"Income Per Household",{"$f":"SUMPRODUCT(Data!$F$3:$F$100000,Data!$R$3:$R$100000*($R$3:$R$100000<>\"0\"))/SUMIF(Data!$R$3:$R$100000,\"<>0\",Data!$F$3:$F$100000)","v":124586.75}]
[null,"Median Age Female",{"$f":"SUMPRODUCT(Data!$F$3:$F$100000,Data!$N$3:$N$100000*($N$3:$N$100000<>\"0\"))/SUMIF(Data!$N$3:$N$100000,\"<>0\",Data!$F$3:$F$100000)","v":43.25},"Number of Businesses",{"$f":"SUM(Data!S3:S1000000)","v":6335},null,null,null,null,null," "]
[null,"Median Age Male",{"$f":"SUMPRODUCT(Data!$F$3:$F$100000,Data!$O$3:$O$100000*($O$3:$O$100000<>\"0\"))/SUMIF(Data!$O$3:$O$100000,\"<>0\",Data!$F$3:$F$100000)","v":41.8},"Number of Employees",{"$f":"SUM(Data!T3:T100000)","v":86123}]
[null,"Households",{"$f":"SUM(Data!P3:P100000)","v":51728},"Persons Per Household",{"$f":"SUMPRODUCT(Data!$F$3:$F$100000,Data!$Q$3:$Q$100000*($P$3:$P$100000<>\"0\"))/SUMIF(Data!$Q$3:$Q$100000,\"<>0\",Data!$F$3:$F$100000)","v":2.4275000000000002}]

{"sheet":"Population","index":2,"n_rows":5,"n_cols":7,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[{"$f":"\"Gender Information for \" & Data!L1","v":"Gender Information for Example Zip Codes"}]
[null,null,null,null,null,"Number","Percent"]
[null,null,null,null,"Male",{"$f":"SUM(Data!L3:L100000)","v":60320},{"$f":"F3/(F$5+0.000001)","v":0.48501222178948755}]
[null,null,null,null,"Female",{"$f":"SUM(Data!M3:M100000)","v":64048},{"$f":"F4/(F$5+0.000001)","v":0.51498777820247177}]
[null,null,null,null,"Total Population",{"$f":"SUM(F3,F4)","v":124368},1]

{"sheet":"Race","index":3,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[{"$f":"\"Race Information for \"& Data!L1","v":"Race Information for Example Zip Codes"}]
[null,null,null,"Number","Percent"]
[null,null,"Asian",{"$f":"SUM(Data!AS$3:AS$100000)","v":7091},{"$f":"D3/($D$9+0.000000001)","v":5.4994571118349191E-2}]
[null,null,"Black or African American",{"$f":"SUM(Data!AT$3:AT$100000)","v":4942},{"$f":"D4/($D$9+0.000000001)","v":3.8327904451682653E-2}]
[null,null,"American Indian or Alaskan Native",{"$f":"SUM(Data!AU$3:AU$100000)","v":1448},1.1230029471071729E-2]
[null,null,"Native Hawaiian or other Pacific Islander",{"$f":"SUM(Data!AV$3:AV$100000)","v":224},1.7372421281215934E-3]
[null,null,"White",{"$f":"SUM(Data!AW$3:AW$100000)","v":103824},0.80521172638435856]
[null,null,"Other",{"$f":"SUM(Data!AX$3:AX$100000)","v":11411},8.8498526446408488E-2]
[null,null,"Total Population",{"$f":"SUM(D3:D8)","v":128940},0.99999999999999223]

{"sheet":"Income Distribution","index":4,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[{"$f":"\"Household Income Distribution for \"& Data!L1","v":"Household Income Distribution for Example Zip Codes"}]
[null,null,null,"Number","Percent"]
[null,null,"0-25K*",{"$f":"SUMIFS(Data!$F$3:$F$100000,Data!$R$3:$R$100000,\"<=25000\")+SUMIFS(Data!$F$3:$F$100000,Data!$R$3:$R$100000,\"\")","v":0},{"$f":"D3/($D$9+0.000000001)","v":0}]
[null,null,">25K to 50K",{"$f":"SUMIFS(Data!$F$3:$F$100000,Data!$R$3:$R$100000,\"<=50000\",Data!$R$3:$R$100000,\">25000\")","v":0},{"$f":"D4/($D$9+0.000000001)","v":0}]
[null,null,"50K to 75K",{"$f":"SUMIFS(Data!$F$3:$F$100000,Data!$R$3:$R$100000,\"<=75000\",Data!$R$3:$R$100000,\">50000\")","v":1},0.24999999993749999]
[null,null,"75K-100K",{"$f":"SUMIFS(Data!$F$3:$F$100000,Data!$R$3:$R$100000,\"<=100000\",Data!$R$3:$R$100000,\">75000\")","v":0},0]
[null,null,"100K - 125K",{"$f":"SUMIFS(Data!$F$3:$F$100000,Data!$R$3:$R$100000,\"<=125000\",Data!$R$3:$R$100000,\">100000\")","v":1},0.24999999993749999]
[null,null,">125K",{"$f":"SUMIFS(Data!$F$3:$F$100000,Data!$R$3:$R$100000,\">125000\")","v":2},0.49999999987499999]
[null,null,"Total Zip Codes",{"$f":"SUM(D3:D8)","v":4},0.99999999974999998]
[null,null,"Total Unique Zip Codes",{"$f":"COUNTA(Data!B3:B100000)","v":4}]
[null,null,"*May include zip codes with no data"]

{"sheet":"Housing Distribution","index":5,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[{"$f":"\"House Value Distribution for \"& Data!L1","v":"House Value Distribution for Example Zip Codes"}]
[null,null,null,"Number","Percent"]
[null,null,"0-100K*",{"$f":"SUMIFS(Data!$F$3:$F$100000,Data!$X$3:$X$100000,\"<=100000\")+SUMIFS(Data!$F$3:$F$100000,Data!$X$3:$X$100000,\"\")","v":0},{"$f":"D3/($D$9+0.000000001)","v":0}]
[null,null,">100K to 150K",{"$f":"SUMIFS(Data!$F$3:$F$100000,Data!$X$3:$X$100000,\"<=150000\",Data!$X$3:$X$100000,\">100000\")","v":0},{"$f":"D4/($D$9+0.000000001)","v":0}]
[null,null,">150K to 250K",{"$f":"SUMIFS(Data!$F$3:$F$100000,Data!$X$3:$X$100000,\"<=250000\",Data!$X$3:$X$100000,\">150000\")","v":1},0.24999999993749999]
[null,null,">250K-500K",{"$f":"SUMIFS(Data!$F$3:$F$100000,Data!$X$3:$X$100000,\"<=500000\",Data!$X$3:$X$100000,\">250000\")","v":0},0]
[null,null,">500K - 750K",{"$f":"SUMIFS(Data!$F$3:$F$100000,Data!$X$3:$X$100000,\"<=750000\",Data!$X$3:$X$100000,\">500000\")","v":0},0]
[null,null,">750K",{"$f":"SUMIFS(Data!$F$3:$F$100000,Data!$X$3:$X$100000,\">750000\")","v":3},0.74999999981249998]
[null,null,"Total Zip Codes",{"$f":"SUM(D3:D8)","v":4},0.99999999974999998]
[null,null,"Total Unique Zip Codes",{"$f":"COUNTA(Data!B3:B100000)","v":4}]
[null,null,"*May include zip codes with no data"]

{"sheet":"Instructions","index":6,"n_rows":42,"n_cols":16,"rows_kept":42,"cut":false,"hidden":false,"merged":[[14,2,14,15],[19,2,19,15]]}
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CDX Technologies Support     "]
[null,null,null,"CDXZipStream Demographic Report",null,null,null,null,null,null,null,null,null,null,null,"(973) 895-5542     "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"support@CDXTech.com      "]
[]
[null,null,"Note:  This template works with Microsoft Excel 2010 and later for Windows.  It is designed to be used for up to 100,000 rows of data. "]
[null,null,"If you need to analyze more data or require additional customization, please email customsolutions@cdxtech.com or call (877) 239-8321."]
[]
[null,null,"This template will produce a summary report of the most popular demographic items available with CDXZipStream Premium database."]
[]
[null,null,"If you haven't already done so, please enable macros for this Excel file.  Please refer to our website at the following link for"]
[null,null,"instructions:"]
[null,null,"Enabling Macros in our CDXZipStream Templates"]
[]
[null,null,"You will have to close the file prior to following these instructions."]
[]
[null,null,"You must also have CDXZipStream with Premium data installed for this template to work."]
[null,null,"Download a free trial of CDXZipStream"]
[]
[null,null,"If you are using our demo you will only be able to retrieve demographic data for the ZIP Codes:  06830, 90210, 78746, and 90272."]
[]
[null,null,"Begin by pressing the \"Get Started\" button above.  This will take you to the \"Data\" worksheet where you can set up your report. "]
[null,null,"First enter your ZIP Code list in column B.  You can use the CDXZipStream ZipList or Radius functions to create lists.  Then press "]
[null,null,"the \"GET DATA\" button to bring in demographic data.  "]
[]
[null,null,"Press CTRL-Break or ESC (for Windows) on your keyboard to cancel data retrieval."]
[]
[null,null,"You can review the report data on the \"Demographics\", \"Population\", \"Race\"  and other tabs.  A description of each of the "]
[null,null,"demographic factors can be found on the \"Definitions\" tab."]
[]
[null,null,"The data items that total ZIP Code data such as population will only be accurate if your list of ZIP Codes does not contain duplicates. "]
[null,null,"After importing data, if the program finds duplicate ZIP Codes you will be given the option to consolidate and weight results.  The end"]
[null,null,"report will be sorted by ZIP Codes with the highest number of occurences first.  This is useful in analyzing customer lists."]
[]
[null,null,"The report name on the chart worksheets can be changed by updating cell L1 on the \"Data\" tab to reflect the nature of your ZIP Code list."]
[null,null,"Use the File \"Save As\" option to save the updated template under a new name.  This ensures the original template will remain unchanged."]
[]
[]
[null,null,"Copyright © 2022 Hughes Financial Services, Inc."]
[null,null,"Version 2.01"]

{"sheet":"Definitions","index":7,"n_rows":62,"n_cols":2,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
[null,"Definitions"]
[null,"Population - The population of the ZIP Code from the Year 2010 U.S. Census.  The total on the \"Demographics\" page is the total for all ZIP Codes on the \"Data\" sheet."]
[]
[null,"Population Estimate - The current estimated household population of the ZIP Code.  The total on the \"Demographics\" page is the total for all ZIP Codes on the \"Data\" sheet."]
[]
[null,"Business Annual Payroll - The total annual payroll for this ZIP Code from the U.S. Business Census.  The total on the \"Demographics\" page is the total for all ZIP Codes on the \"Data\" sheet."]
[]
[null,"Business First Quarter Payroll - The first quarter payroll for this ZIP Code from the U.S. Business Census.  The total on the \"Demographics\" page is the total for all ZIP Codes on the \"Data\" sheet."]
[]
[null,"Median Age - The Median Age in the ZIP Code the from the Year 2010 U.S. Census.   The age on the \"Demographics\"sheet is the weighted average of all non-zero ZIP Codes on the \"Data\" sheet."]
[]
[null,"Median Age Female - The Female Median Age in the ZIP Code from the Year 2010 U.S. Census.  The age on the \"Demographics\"sheet is the weighted average of all non-zero ZIP Codes on the \"Data\" sheet."]
[]
[null,"Median Age Male - The Male Median Age in the ZIP Code the Year 2010 U.S. Census.  The age on the \"Demographics\"sheet is the weighted average of all all non-zero ZIP Codes on the \"Data\" sheet."]
[]
[null,"Persons Per Household - The Persons per Household in the ZIP Code from the Year 2010 U.S. Census.  The number on the \"Demographics\"sheet is the weighted average of all all non-zero ZIP Codes on the \"Data\" sheet."]
[]
[null,"IncomePerHousehold - The Income per Household in the ZIP Code from the Year 2010 U.S. Census.  The income on the \"Demographics\"sheet is the weighted average of all all non-zero ZIP Codes on the \"Data\" sheet."]
[]
[null,"Number of Businesses - The total number of Business Establishments for this ZIP Code from the U.S. Business Census.  The total on the \"Demographics\" page is the total for all ZIP Codes on the \"Data\" sheet."]
[]
[null,"Number of Employees - The total number of employees for this ZIP Code from the U.S. Business Census.  The total on the \"Demographics\" page is the total for all ZIP Codes on the \"Data\" sheet."]
[]
[null,"Delivery Business - This field provides the number of active business delivery mailboxes and centralized units for this ZIP Code.  The total on the \"Demographics\" page is the total for all ZIP Codes on the \"Data\" sheet."]
[]
[null,"Delivery Residential - This field provides the number of active residential delivery mailboxes and centralized units for this ZIP Code.  The total on the \"Demographics\" page is the total for all ZIP Codes on the \"Data\" sheet."]
[]
[null,"Delivery Total - This field provides the total number of active delivery mailboxes and centralized units for this ZIP Code.  The total on the \"Demographics\" page is the total for all ZIP Codes on the \"Data\" sheet."]
[]
[null,"Average House Value - The Average House Value in the ZIP Code from the Year 2010 U.S. Census.   The value on the \"Demographics\"sheet is the weighted average of all ZIP Codes on the \"Data\" sheet."]
[]
[null,"Growing Counties A - The estimated number of housing units in this county as of July 1, 2010. Source: Population Division, U.S. Census. Bureau."]
[]
[null,"Growing Counties B - The estimated number of housing units in this county as of. July 1, 2011. Source: Population Division, U.S. Census. Bureau"]
[]
[null,"Growth Increase Number - The change in housing units from 2003 to 2004, expressed as a number according to the US Census."]
[]
[null,"Growth Increase Percentage - The change in housing units from 2010 to 2011, expressed as a percentage according to the US Census."]
[]
[null,"Growth Rank - The growth rank for this county according to the US Census."]
[]
[null,"CBSA Population - The estimated population for the selected CBSA in 2010."]
[]
[null,"CBSA Division Population - The estimated population for the selected CBSA Division in 2010."]
[]
[null,"CBSA Division - Core Based Statistical Area Division name"]
[]
[null,"Male Population - The Male population in the ZIP Code from the Year 2010 U.S. Census. The total on the \"Demographics\" page is the total for all ZIP Codes on the \"Data\" sheet."]
[]
[null,"Female Population - The Female population in the ZIP Code from the Year 2010 U.S. Census. The total on the \"Demographics\" page is the total for all ZIP Codes on the \"Data\" sheet."]
[]
[null,"Asian Population - The Asian population in the ZIP Code from the Year 2010 U.S. Census. The total on the \"Race\" page is the total for all ZIP Codes on the \"Data\" sheet."]
[]
[null,"Black Population - The Black population in the ZIP Code from the Year 2010 U.S. Census.  The total on the \"Race\" page is the total for all ZIP Codes on the \"Data\" sheet."]
[]
[null,"Indian Population - The American Indian and Alaska Native population in the ZIP Code from the Year 2010 U.S. Census.  The total on the \"Race\" page is the total for all ZIP Codes on the \"Data\" sheet."]
[]
[null,"Hawaiian Population - The Hawaiian population in the ZIP Code from the Year 2010 U.S. Census.  The total on the \"Race\" page is the total for all ZIP Codes on the \"Data\" sheet."]
[]
[null,"White Population – The white population in the ZIP Code from the Year 2010 U.S. Census.  The total on the \"Race\" page is the total for all ZIP Codes on the \"Data\" sheet."]
[]
[null,"Other Population - The non classified population in the ZIP Code from the Year 2010 U.S. Census.  The total on the \"Race\" page is the total for all ZIP Codes on the \"Data\" sheet."]