{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Begin","InputSheet","Statistics","Report","ReadMe"],"not_rendered":{"charts":3,"images":1,"macros":1,"external_links":0,"defined_names":25,"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":"Begin","index":0,"n_rows":19,"n_cols":9,"rows_kept":19,"cut":false,"hidden":false,"merged":[[12,7,12,9]]}
[]
[null,null,"Step 0.","Make sure you have the latest version of this file.  http://www.fullcontact.com/developer/docs/libraries"]
[null,null,"Step 1.","Save the file in a format that allows macros (.xlsm)."]
[null,null,"Step 2.","Clear the workbook of any old data by select \"Wipe Data\" below."]
[null,null,"Step 3.","Below, select the form of enrichment that you will be using (email, twitter, etc.).  "]
[null,null,"Step 4.","Enter your list of email addresses (or proper query param) in column A of \"InputSheet\".  The first entry should be in Cell A2."]
[null,null,"Step 5.","Enter your FullContact API Key below and adjust other variables.  You can get a key at http://fullcontact.com/developer"]
[null,null,"Step 6.","Click on \"Populate Contacts\" below."]
[null,null,"Step 7.","Generate a Report based on your results."]
[null,null,"Step 8.","Export the results to csv. (note: this uses a custom function to export as UTF-8 so allow a couple minutes for large files)"]
[null,null,null,"Last Updated: 9 June 2014"]
[]
[null,null,null,null,null,null,"FullContact API Key:"]
[]
[null,null,null,null,null,null,"Number of Seeding Passes:",2]
[]
[null,null,null,null,null,null,"Rate Limit:",5,"qps"]
[]
[null,null,null,null,null,null,"Enrich Contacts Using:"]

{"sheet":"InputSheet","index":1,"n_rows":1,"n_cols":32,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Email","Status","First Name","Last Name","Full Name","Age","Gender","General Location","Company","Occupation","Photo","# Photos","LinkedIn","Facebook","Twitter","MySpace","Klout","Flickr","YouTube","Google Plus","Other Profiles (see readme for explanation)","# Profiles","Klout Topics","Deprecated","Klout Score","Enhanced Data","Followers","Following","Bio","RSS","IM","Likelihood"]

{"sheet":"Statistics","index":2,"n_rows":151,"n_cols":11,"rows_kept":151,"cut":false,"hidden":false,"merged":[]}
[null,null,"File",{"$f":"MID(CELL(\"filename\"),SEARCH(\"[\",CELL(\"filename\"))+1, SEARCH(\"]\",CELL(\"filename\"))-SEARCH(\"[\",CELL(\"filename\"))-1)","v":"FullContact Person Enrichment - Template.xlsm"}]
[null,null,"Stats",1,null,null,null,null,null,"enrich type",1]
[null,null,"Number Processed",{"$f":"COUNTIF(InputSheet!B:B,\"200\")","v":0},{"$f":"D3/D5","v":0}]
[null,null,"Number of Blanks",{"$f":"COUNTBLANK(InputSheet!A:A)","v":1048575}]
[null,null,"Number Total",6]
[null,null,"Remaining"]
[null,null,"Number Nothing Found",{"$f":"COUNTIF(InputSheet!B:B,\"202\")+COUNTIF(InputSheet!B:B,\"404\")","v":0},{"$f":"D7/D5","v":0}]
[null,null,"Number Bad Email Addresses",{"$f":"COUNTIF(InputSheet!B:B,\"422\")","v":0},{"$f":"D8/D5","v":0}]
[null,null,"Loop Count",3,null,null,"Avg. Resp. Time"]
[null,null,"Current Row",7,{"$f":"D10/D5","v":1.1666666666666667},null,27,"ms"]
[]
[null,null,"Match",null,"%"]
[null,null,"Has IM",{"$f":"IF($D$2=1,COUNTA(InputSheet!AE:AE)-1,\"\")","v":0},{"$f":"D13/$D$3","v":{"$error":"#DIV/0!"}}]
[null,null,"Has RSS",{"$f":"IF($D$2=1,COUNTA(InputSheet!AD:AD)-1,\"\")","v":0},{"$error":"#DIV/0!"}]
[null,null,"Enhanced Data",{"$f":"IF($D$2=1,COUNTA(InputSheet!Z:Z)-1,\"\")","v":0},{"$error":"#DIV/0!"}]
[null,null,"Has Bio",{"$f":"IF($D$2=1,COUNTA(InputSheet!AC:AC)-1,\"\")","v":0},{"$error":"#DIV/0!"}]
[null,null,"Has Followers",{"$f":"IF($D$2=1,COUNTA(InputSheet!AA:AA)-1,\"\")","v":0},{"$error":"#DIV/0!"}]
[null,null,"Is Following",{"$f":"IF($D$2=1,COUNTA(InputSheet!AB:AB)-1,\"\")","v":0},{"$error":"#DIV/0!"}]
[null,null,"Flickr",{"$f":"IF($D$2=1,COUNTA(InputSheet!R:R)-1,\"\")","v":0},{"$error":"#DIV/0!"}]
[null,null,"MySpace",{"$f":"IF($D$2=1,COUNTA(InputSheet!P:P)-1,\"\")","v":0},{"$error":"#DIV/0!"}]
[null,null,"YouTube",{"$f":"IF($D$2=1,COUNTA(InputSheet!S:S)-1,\"\")","v":0},{"$error":"#DIV/0!"}]
[null,null,"Google+",{"$f":"IF($D$2=1,COUNTA(InputSheet!T:T)-1,\"\")","v":0},{"$error":"#DIV/0!"}]
[null,null,"Klout",{"$f":"IF($D$2=1,COUNTA(InputSheet!Q:Q)-1,\"\")","v":0},{"$error":"#DIV/0!"}]
[null,null,"Twitter",{"$f":"IF($D$2=1,COUNTA(InputSheet!O:O)-1,\"\")","v":0},{"$error":"#DIV/0!"}]
[null,null,"Company",{"$f":"IF($D$2=1,COUNTA(InputSheet!I:I)-1,\"\")","v":0},{"$error":"#DIV/0!"}]
[null,null,"Occupation",{"$f":"IF($D$2=1,COUNTA(InputSheet!J:J)-1,\"\")","v":0},{"$error":"#DIV/0!"}]
[null,null,"LinkedIn",{"$f":"IF($D$2=1,COUNTA(InputSheet!M:M)-1,\"\")","v":0},{"$error":"#DIV/0!"}]
[null,null,"Facebook",{"$f":"IF($D$2=1,COUNTA(InputSheet!N:N)-1,\"\")","v":0},{"$error":"#DIV/0!"}]
[null,null,"Name",{"$f":"IF($D$2=1,COUNTA(InputSheet!E:E)-1,\"\")","v":0},{"$error":"#DIV/0!"}]
[null,null,"Photo Present",{"$f":"IF($D$2=1,COUNTIF(InputSheet!L:L,\">0\"),\"\")","v":0},{"$error":"#DIV/0!"}]
[null,null,"Other Url",{"$f":"IF($D$2=1,COUNTA(InputSheet!U:U)-1,\"\")","v":0},{"$error":"#DIV/0!"}]
[null,null,"Age",{"$f":"IF($D$2=1,COUNTA(InputSheet!F:F)-1,\"\")","v":0},{"$error":"#DIV/0!"}]
[null,null,"General Location",{"$f":"IF($D$2=1,COUNTA(InputSheet!H:H)-1,\"\")","v":0},{"$error":"#DIV/0!"}]
[null,null,"Url Present",{"$f":"IF($D$2=1,COUNTIF(InputSheet!V:V,\">0\"),\"\")","v":0},{"$error":"#DIV/0!"}]
[null,null,"Gender",{"$f":"IF($D$2=1,COUNTA(InputSheet!G:G)-1,\"\")","v":0},{"$error":"#DIV/0!"}]
[]
[]
[]
[null,null,null,"Male","Female"]
[null,null,"Gender",{"$f":"IF(D2=1,COUNTIF(InputSheet!G:G,$D$39),\"\")","v":0},{"$f":"IF(D2=1,COUNTIF(InputSheet!G:G,$E$39),\"\")","v":0}]
[null,null,null,{"$f":"D40/(D40+E40)","v":{"$error":"#DIV/0!"}},{"$f":"E40/(D40+E40)","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"Age","18-20",{"$f":"IF($D$2=1,COUNTIF(InputSheet!F:F,Statistics!D43),\"\")","v":0}]
[null,null,null,"21-24",{"$f":"IF($D$2=1,COUNTIF(InputSheet!F:F,Statistics!D44),\"\")","v":0}]
[null,null,null,"25-34",{"$f":"IF($D$2=1,COUNTIF(InputSheet!F:F,Statistics!D45),\"\")","v":0}]
[null,null,null,"35-44",{"$f":"IF($D$2=1,COUNTIF(InputSheet!F:F,Statistics!D46),\"\")","v":0}]
[null,null,null,"45-54",{"$f":"IF($D$2=1,COUNTIF(InputSheet!F:F,Statistics!D47),\"\")","v":0}]
[null,null,null,"55-64",{"$f":"IF($D$2=1,COUNTIF(InputSheet!F:F,Statistics!D48),\"\")","v":0}]
[null,null,null,"65+",{"$f":"IF($D$2=1,COUNTIF(InputSheet!F:F,Statistics!D49),\"\")","v":0}]
[null,null,null,"Total",{"$f":"SUM(E43:E49)","v":0}]
[]
[null,null,null,"18-24",{"$f":"(E43+E44)/E50","v":{"$error":"#DIV/0!"}}]
[null,null,null,"25-34",{"$f":"E45/$E$50","v":{"$error":"#DIV/0!"}}]
[null,null,null,"35-44",{"$f":"E46/$E$50","v":{"$error":"#DIV/0!"}}]
[null,null,null,"45-54",{"$f":"E47/$E$50","v":{"$error":"#DIV/0!"}}]
[null,null,null,"55-64",{"$f":"E48/$E$50","v":{"$error":"#DIV/0!"}}]
[null,null,null,"65+",{"$f":"E49/$E$50","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[]
[]
[null,"State","Count"]
[null,"Alabama",{"$f":"COUNTIF(InputSheet!H:H,\"*Alabama*\")","v":0}]
[null,"Alaska",{"$f":"COUNTIF(InputSheet!H:H,\"*Alaska*\")","v":0}]
[null,"Arizona",{"$f":"COUNTIF(InputSheet!H:H,\"*Arizona*\")","v":0}]
[null,"Arkansas",{"$f":"COUNTIF(InputSheet!H:H,\"*Arkansas*\")","v":0}]
[null,"California",{"$f":"COUNTIF(InputSheet!H:H,\"*California*\")","v":0}]
[null,"Colorado",{"$f":"COUNTIF(InputSheet!H:H,\"*Colorado*\")","v":0}]
[null,"Connecticut",{"$f":"COUNTIF(InputSheet!H:H,\"*Connecticut*\")","v":0}]
[null,"Delaware",{"$f":"COUNTIF(InputSheet!H:H,\"*Delaware*\")","v":0}]
[null,"Florida",{"$f":"COUNTIF(InputSheet!H:H,\"*Florida*\")","v":0}]
[null,"Georgia",{"$f":"COUNTIF(InputSheet!H:H,\"*Georgia*\")","v":0}]
[null,"Hawaii",{"$f":"COUNTIF(InputSheet!H:H,\"*Hawaii*\")","v":0}]
[null,"Idaho",{"$f":"COUNTIF(InputSheet!H:H,\"*Idaho*\")","v":0}]
[null,"Illinois",{"$f":"COUNTIF(InputSheet!H:H,\"*Illinois*\")","v":0}]
[null,"Indiana",{"$f":"COUNTIF(InputSheet!H:H,\"*Indiana*\")","v":0}]
[null,"Iowa",{"$f":"COUNTIF(InputSheet!H:H,\"*Iowa*\")","v":0}]
[null,"Kansas",{"$f":"COUNTIF(InputSheet!H:H,\"*Kansas*\")","v":0}]
[null,"Kentucky",{"$f":"COUNTIF(InputSheet!H:H,\"*Kentucky*\")","v":0}]
[null,"Louisiana",{"$f":"COUNTIF(InputSheet!H:H,\"*Louisiana*\")","v":0}]
[null,"Maine",{"$f":"COUNTIF(InputSheet!H:H,\"*Maine*\")","v":0}]
[null,"Maryland",{"$f":"COUNTIF(InputSheet!H:H,\"*Maryland*\")","v":0}]
[null,"Massachusetts",{"$f":"COUNTIF(InputSheet!H:H,\"*Massachusetts*\")","v":0}]
[null,"Michigan",{"$f":"COUNTIF(InputSheet!H:H,\"*Michigan*\")","v":0}]
[null,"Minnesota",{"$f":"COUNTIF(InputSheet!H:H,\"*Minnesota*\")","v":0}]
[null,"Mississippi",{"$f":"COUNTIF(InputSheet!H:H,\"*Mississippi*\")","v":0}]
[null,"Missouri",{"$f":"COUNTIF(InputSheet!H:H,\"*Missouri*\")","v":0}]
[null,"Montana",{"$f":"COUNTIF(InputSheet!H:H,\"*Montana*\")","v":0}]
[null,"Nebraska",{"$f":"COUNTIF(InputSheet!H:H,\"*Nebraska*\")","v":0}]
[null,"Nevada",{"$f":"COUNTIF(InputSheet!H:H,\"*Nevada*\")","v":0}]
[null,"New_Hampshire",{"$f":"COUNTIF(InputSheet!H:H,\"*New Hampshire*\")","v":0}]
[null,"New_Jersey",{"$f":"COUNTIF(InputSheet!H:H,\"*New Jersey*\")","v":0}]
[null,"New_Mexico",{"$f":"COUNTIF(InputSheet!H:H,\"*New Mexico*\")","v":0}]
[null,"New_York",{"$f":"COUNTIF(InputSheet!H:H,\"*New York*\")","v":0}]
[null,"North_Carolina",{"$f":"COUNTIF(InputSheet!H:H,\"*North Carolina*\")","v":0}]
[null,"North_Dakota",{"$f":"COUNTIF(InputSheet!H:H,\"*North Dakota*\")","v":0}]
[null,"Ohio",{"$f":"COUNTIF(InputSheet!H:H,\"*Ohio*\")","v":0}]
[null,"Oklahoma",{"$f":"COUNTIF(InputSheet!H:H,\"*Oklahoma*\")","v":0}]
[null,"Oregon",{"$f":"COUNTIF(InputSheet!H:H,\"*Oregon*\")","v":0}]
[null,"Pennsylvania",{"$f":"COUNTIF(InputSheet!H:H,\"*Pennsylvania*\")","v":0}]
[null,"Rhode_Island",{"$f":"COUNTIF(InputSheet!H:H,\"*Rhode Island*\")","v":0}]
[null,"South_Carolina",{"$f":"COUNTIF(InputSheet!H:H,\"*South Carolina*\")","v":0}]
[null,"South_Dakota",{"$f":"COUNTIF(InputSheet!H:H,\"*South Dakota*\")","v":0}]
[null,"Tennessee",{"$f":"COUNTIF(InputSheet!H:H,\"*Tennessee*\")","v":0}]
[null,"Texas",{"$f":"COUNTIF(InputSheet!H:H,\"*Texas*\")","v":0}]
[null,"Utah",{"$f":"COUNTIF(InputSheet!H:H,\"*Utah*\")","v":0}]
[null,"Vermont",{"$f":"COUNTIF(InputSheet!H:H,\"*Vermont*\")","v":0}]
[null,"Virginia",{"$f":"COUNTIF(InputSheet!H:H,\"*Virginia*\")","v":0}]
[null,"Washington",{"$f":"COUNTIF(InputSheet!H:H,\"*, Washington*\")","v":0},null,null,""]
[null,"West_Virginia",{"$f":"COUNTIF(InputSheet!H:H,\"*West Virginia*\")","v":0}]
[null,"Wisconsin",{"$f":"COUNTIF(InputSheet!H:H,\"*Wisconsin*\")","v":0}]
[null,"Wyoming",{"$f":"COUNTIF(InputSheet!H:H,\"*Wyoming*\")","v":0}]
[null,"District_of_Columbia",{"$f":"COUNTIF(InputSheet!H:H,\"*District of Columbia*\")","v":0}]
[null,"Yukon",{"$f":"COUNTIF(InputSheet!H:H,\"*Yukon*\")","v":0}]
[null,"Northwest_Territories",{"$f":"COUNTIF(InputSheet!H:H,\"*Northwest Territories*\")","v":0}]
[null,"Nunavut",{"$f":"COUNTIF(InputSheet!H:H,\"*Nunavut*\")","v":0}]
[null,"British_Columbia",{"$f":"COUNTIF(InputSheet!H:H,\"*British Columbia*\")","v":0}]
[null,"Alberta",{"$f":"COUNTIF(InputSheet!H:H,\"*Alberta*\")","v":0}]
[null,"Saskatchewan",{"$f":"COUNTIF(InputSheet!H:H,\"*Saskatchewan*\")","v":0}]
[null,"Manitoba",{"$f":"COUNTIF(InputSheet!H:H,\"*Manitoba*\")","v":0}]
[null,"Ontario",{"$f":"COUNTIF(InputSheet!H:H,\"*, Ontario*\")","v":0}]
[null,"Quebec",{"$f":"COUNTIF(InputSheet!H:H,\"*, Quebec*\")","v":0}]
[null,"Newfoundland_Labrador",{"$f":"COUNTIF(InputSheet!H:H,\"*Newfoundland and Labrador*\")","v":0}]
[null,"Prince_Edward_Island",{"$f":"COUNTIF(InputSheet!H:H,\"*Prince Edward Island*\")","v":0}]
[null,"New_Brunswick",{"$f":"COUNTIF(InputSheet!H:H,\"*New Brunswick*\")","v":0}]
[null,"Nova_scotia",{"$f":"COUNTIF(InputSheet!H:H,\"*Nova Scotia*\")","v":0}]
[null,"Total",{"$f":"SUM(C65:C128)","v":0}]
[]
[null,null,"Active Region","Nova_scotia","actReg"]
[null,null,"Value",{"$f":"VLOOKUP(actReg,regData,2,FALSE)","v":0},"actRegValue"]
[null,null,"Code",{"$f":"VLOOKUP(actRegValue,classValues,2,TRUE)","v":"class5"},"actRegCode"]
[]
[]
[]
[null,null,0,"class0"]
[null,null,{"$f":"ROUNDUP((MAX($C$65:$C$128)*0.1167),0)","v":0},"class1"]
[null,null,{"$f":"ROUNDUP((MAX($C$65:$C$128)*0.334),0)","v":0},"class2"]
[null,null,{"$f":"ROUNDUP((MAX($C$65:$C$128)*0.5),0)","v":0},"class3"]
[null,null,{"$f":"ROUNDUP((MAX($C$65:$C$128)*0.667),0)","v":0},"class4"]
[null,null,{"$f":"ROUNDUP((MAX($C$65:$C$128)*0.833),0)","v":0},"class5"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Data for Topic Cloud"]

{"sheet":"Report","index":3,"n_rows":146,"n_cols":15,"rows_kept":146,"cut":false,"hidden":false,"merged":[[136,14,136,15]]}
[]
[null,{"$f":"CONCATENATE(\"Results for \",Statistics!D1)","v":"Results for FullContact Person Enrichment - Template.xlsm"}]
[]
[]
[null,null,null,null,"Count","% of Total"]
[null,"Total Inputs",null,null,{"$f":"IF(Statistics!D2=1,Statistics!D5,\"\")","v":6}]
[null,"# Matched",null,null,{"$f":"IF(Statistics!D2=1,Statistics!D3,\"\")","v":0},{"$f":"E7/E6","v":0}]
[null,"# No Match",null,null,{"$f":"IF(Statistics!D2=1,Statistics!D7,\"\")","v":0},{"$f":"E8/E6","v":0}]
[null,"# Bad Input",null,null,{"$f":"IF(Statistics!D2=1,Statistics!D8,\"\")","v":0},{"$f":"E9/E6","v":0}]
[]
[]
[null,"Match Fill Rate"]
[]
[null,null,null,"Matches",null,"Match Rate"]
[null,null,null,"Basic Contact Info"]
[null,{"$f":"Statistics!C13","v":"Has IM"},null,{"$f":"Statistics!D13","v":0},null,{"$f":"Statistics!E13","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"Statistics!C14","v":"Has RSS"},null,{"$f":"Statistics!D14","v":0},null,{"$f":"Statistics!E14","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"Statistics!C15","v":"Enhanced Data"},null,{"$f":"Statistics!D15","v":0},null,{"$f":"Statistics!E15","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"Statistics!C16","v":"Has Bio"},null,{"$f":"Statistics!D16","v":0},null,{"$f":"Statistics!E16","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"Statistics!C17","v":"Has Followers"},null,{"$f":"Statistics!D17","v":0},null,{"$f":"Statistics!E17","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"Statistics!C18","v":"Is Following"},null,{"$f":"Statistics!D18","v":0},null,{"$f":"Statistics!E18","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"Statistics!C19","v":"Flickr"},null,{"$f":"Statistics!D19","v":0},null,{"$f":"Statistics!E19","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"Statistics!C20","v":"MySpace"},null,{"$f":"Statistics!D20","v":0},null,{"$f":"Statistics!E20","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"Statistics!C21","v":"YouTube"},null,{"$f":"Statistics!D21","v":0},null,{"$f":"Statistics!E21","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"Statistics!C22","v":"Google+"},null,{"$f":"Statistics!D22","v":0},null,{"$f":"Statistics!E22","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"Statistics!C23","v":"Klout"},null,{"$f":"Statistics!D23","v":0},null,{"$f":"Statistics!E23","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"Statistics!C24","v":"Twitter"},null,{"$f":"Statistics!D24","v":0},null,{"$f":"Statistics!E24","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"Statistics!C25","v":"Company"},null,{"$f":"Statistics!D25","v":0},null,{"$f":"Statistics!E25","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"Statistics!C26","v":"Occupation"},null,{"$f":"Statistics!D26","v":0},null,{"$f":"Statistics!E26","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"Statistics!C27","v":"LinkedIn"},null,{"$f":"Statistics!D27","v":0},null,{"$f":"Statistics!E27","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"Statistics!C28","v":"Facebook"},null,{"$f":"Statistics!D28","v":0},null,{"$f":"Statistics!E28","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"Statistics!C29","v":"Name"},null,{"$f":"Statistics!D29","v":0},null,{"$f":"Statistics!E29","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"Statistics!C30","v":"Photo Present"},null,{"$f":"Statistics!D30","v":0},null,{"$f":"Statistics!E30","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"Statistics!C31","v":"Other Url"},null,{"$f":"Statistics!D31","v":0},null,{"$f":"Statistics!E31","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"Statistics!C32","v":"Age"},null,{"$f":"Statistics!D32","v":0},null,{"$f":"Statistics!E32","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"Statistics!C33","v":"General Location"},null,{"$f":"Statistics!D33","v":0},null,{"$f":"Statistics!E33","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"Statistics!C34","v":"Url Present"},null,{"$f":"Statistics!D34","v":0},null,{"$f":"Statistics!E34","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"Statistics!C35","v":"Gender"},null,{"$f":"Statistics!D35","v":0},null,{"$f":"Statistics!E35","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Klout Topic Cloud "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"(top 25 topics if available)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Legend"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(Statistics!C137,\"-\",Statistics!C138-1)","v":"0--1"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(Statistics!C138,\"-\",Statistics!C139-1)","v":"0--1"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(Statistics!C139,\"-\",Statistics!C140-1)","v":"0--1"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(Statistics!C140,\"-\",Statistics!C141-1)","v":"0--1"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(Statistics!C141,\"-\",Statistics!C142-1)","v":"0--1"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(Statistics!C142,\"+\")","v":"0+"}]
[]
[]
[null,null,null,null,"Heat Map - Approximate Matches in North America"]

{"sheet":"ReadMe","index":4,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
["Notes:"]
[null,"This has only been tested on Excel 2010 and Excel 2013 for Windows.  It does not run on Excel for Apple probably due to use of MSXML."]
[null,"You can obtain an api key at http://fullcontact.com/developer"]
[null,"It is recommended that you run several \"seed\" passes prior to getting your final results.  This allows FullContact to look for new data on email addresses it has not seen before or updated recently."]
[null,"The seeding pass uses the parameter queue=1 which will return a 202 in all cases (i.e. these don't count as \"hits\" for your key)."]
[null,"\"Other Profiles\" is a list of key-value pairs.  They are delimited as such:  key:::value|||key2:::value2|||key3:::value3"]
[null,"If you are running this on a large data set, make sure your computer hard drive or power savings modes keep it from shutting down."]
[null,"If you need to take your computer offline while it is still processing, open visual basic and \"pause\" the macro.  You can re-start it at any time."]
[null,"The file will automatically save after every 50,000 email addresses are processed, as well as at the end."]
[null,"The rate limit is approximate and was implemented in a way that should not blocking you from using Excel while the macro runs."]