{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Europe Map","Data","Control","Pivot"],"not_rendered":{"images":2,"macros":1,"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"Europe Map","index":0,"n_rows":44,"n_cols":1,"rows_kept":44,"merged":[[43,0,43,6]]}
{"$rows_empty":43}
["http://www.spreadsheet1.com"]

{"sheet":"Data","index":1,"n_rows":38,"n_cols":4,"rows_kept":38}
["No.","Abbreviation","Country","Values"]
[1,"ALB","Albania",0]
[{"$f":"A2+1","v":2},"AUT","Austria",158]
[3,"BLR","Belarus",0]
[4,"BEL","Belgium",107]
[5,"BIH","Bosnia & Herzegovina",0]
[6,"BGR","Bulgaria",0]
[7,"HRV","Croatia",0]
[8,"CZE","Czech Republic",0]
[9,"DNK","Denmark",79]
[10,"EST","Estonia",0]
[11,"FIN","Finland",38]
[12,"FRA","France",783]
[13,"DEU","Germany",2303]
[14,"GRC","Greece",31]
[15,"HUN","Hungary",0]
[16,"IRL","Ireland",0]
[17,"ITA","Italy",569]
[18,"LVA","Latvia",0]
[19,"LTU","Lithuania",0]
[20,"LUX","Luxembourg",0]
[21,"MKD","Macedonia",0]
[22,"MAL","Malta",0]
[23,"MDA","Moldova",0]
[24,"NLD","Netherlands",183]
[25,"NOR","Norway",35]
[26,"POL","Poland",0]
[27,"PRT","Portugal",24]
[28,"ROM","Romania",0]
[29,"RUS","Russia",0]
[30,"SR","Serbia",0]
[31,"SVK","Slovakia",0]
[32,"SVN","Slovenia",0]
[33,"ESP","Spain",270]
[34,"SWE","Sweden",103]
[35,"CHE","Switzerland",156]
[36,"GBR","UK",350]
[37,"UKR","Ukraine",0]

{"sheet":"Control","index":2,"n_rows":61,"n_cols":2,"rows_kept":61}
[]
[]
[]
[]
[]
["Selection",7]
["Darkness",{"v":5,"d":"5.00"}]
["Min / Max",{"$f":"MAX(rngValues)","v":2303}]
["Min / Max",{"$f":"MIN(rngValues)","v":0}]
["Min / Max",{"$f":"(B8-B9)/(COUNT($B$12:$B$61)-2)","v":47.979166666666664}]
["Threshold","Steps"]
[{"$f":"B9","v":{"v":0,"d":"0.00"}},{"$f":"B13+$B$7","v":245}]
[{"$f":"A12+$B$10","v":{"v":47.979166666666664,"d":"47.98"}},240]
[{"v":95.95833333333333,"d":"95.96"},235]
[{"v":143.9375,"d":"143.94"},230]
[{"v":191.91666666666666,"d":"191.92"},225]
[{"v":239.89583333333331,"d":"239.90"},220]
[{"v":287.875,"d":"287.88"},215]
[{"v":335.8541666666667,"d":"335.85"},210]
[{"v":383.83333333333337,"d":"383.83"},205]
[{"v":431.81250000000006,"d":"431.81"},200]
[{"v":479.79166666666674,"d":"479.79"},195]
[{"v":527.7708333333334,"d":"527.77"},190]
[575.75,185]
[{"v":623.7291666666666,"d":"623.73"},180]
[{"v":671.7083333333333,"d":"671.71"},175]
[{"v":719.6874999999999,"d":"719.69"},170]
[{"v":767.6666666666665,"d":"767.67"},165]
[{"v":815.6458333333331,"d":"815.65"},160]
[{"v":863.6249999999998,"d":"863.63"},155]
[{"v":911.6041666666664,"d":"911.60"},150]
[{"v":959.583333333333,"d":"959.58"},145]
[{"v":1007.5624999999997,"d":"1,007.56"},140]
[{"v":1055.5416666666663,"d":"1,055.54"},135]
[{"v":1103.520833333333,"d":"1,103.52"},130]
[{"v":1151.4999999999998,"d":"1,151.50"},125]
[{"v":1199.4791666666665,"d":"1,199.48"},120]
[{"v":1247.4583333333333,"d":"1,247.46"},115]
[{"v":1295.4375,"d":"1,295.44"},110]
[{"v":1343.4166666666667,"d":"1,343.42"},105]
[{"v":1391.3958333333335,"d":"1,391.40"},100]
[{"v":1439.3750000000002,"d":"1,439.38"},95]
[{"v":1487.354166666667,"d":"1,487.35"},90]
[{"v":1535.3333333333337,"d":"1,535.33"},{"$f":"B45+$B$7","v":85}]
[{"$f":"A44+$B$10","v":{"v":1583.3125000000005,"d":"1,583.31"}},80]
[{"v":1631.2916666666672,"d":"1,631.29"},75]
[{"v":1679.270833333334,"d":"1,679.27"},70]
[{"v":1727.2500000000007,"d":"1,727.25"},65]
[{"v":1775.2291666666674,"d":"1,775.23"},60]
[{"v":1823.2083333333342,"d":"1,823.21"},55]
[{"v":1871.187500000001,"d":"1,871.19"},50]
[{"v":1919.1666666666677,"d":"1,919.17"},45]
[{"v":1967.1458333333344,"d":"1,967.15"},40]
[{"v":2015.1250000000011,"d":"2,015.13"},35]
[{"v":2063.104166666668,"d":"2,063.10"},30]
[{"v":2111.0833333333344,"d":"2,111.08"},25]
[{"v":2159.062500000001,"d":"2,159.06"},20]
[{"v":2207.0416666666674,"d":"2,207.04"},15]
[{"v":2255.020833333334,"d":"2,255.02"},10]
[{"v":2303.0000000000005,"d":"2,303.00"},5]
[{"v":2350.979166666667,"d":"2,350.98"},0]

{"sheet":"Pivot","index":3,"n_rows":21,"n_cols":6,"rows_kept":21}
[{"$nulls":5},"AUT"]
[{"$nulls":5},{"$f":"VLOOKUP(ControlCell,Data!$B$2:$C$38,2,FALSE)","v":"Austria"}]
[{"$nulls":5},{"$f":"COUNTIF(F7:F21,\">0\")","v":15}]
[]
[{"$nulls":4},"Widget Sales in Europe"]
[{"$nulls":4},"Country","Units"]
[{"$nulls":4},"Germany",2303]
[{"$nulls":4},"France",783]
[{"$nulls":4},"Italy",569]
[{"$nulls":4},"UK",350]
[{"$nulls":4},"Spain",270]
[{"$nulls":4},"Netherlands",183]
[{"$nulls":4},"Austria",158]
[{"$nulls":4},"Switzerland",156]
[{"$nulls":4},"Belgium",107]
[{"$nulls":4},"Sweden",103]
[{"$nulls":4},"Denmark",79]
[{"$nulls":4},"Finland",38]
[{"$nulls":4},"Norway",35]
[{"$nulls":4},"Greece",31]
[{"$nulls":4},"Portugal",24]