Spreadsheet: 885594d1735326787-excel-2016-bug-with-power-query-get-data-from-csv-del-p
Sheet: pt

Column4 | All
Row Labels | Count of Column8_2 | Sum of Column8
A000122806U | 1 | 568965.52
A000194473O | 2 | 1000000
[NAME] | 1 | 120687.93
A002203235A | 1 | 7800
A002296448Y | 2 | 54750
A002389276J | 1 | 862.07
A002868450J | 4 | 36000
A002870133M | 3 | 37600
A003332368Q | 1 | 3448.28
A003617564G | 2 | 97980
A003675524Y | 1 | 24137.93
A003827320V | 2 | 274051.73
A005797481S | 1 | 34482.76
A006947097W | 1 | 19181.03
A007406938B | 3 | 39517.24
A007554575H | 1 | 1725.04
A008394546Z | 1 | 9913.79
A008861180Z | 3 | 6897.049999999999
[NAME] | 3 | 179645.69
A012339017L | 1 | 41034.48
P000591096X | 12 | 1212008.59
P000591147N | 2 | 31293.14
P000591167T | 3 | 4114975.14
P000591252N | 6 | 1571490.05
P000591674X | 3 | 1682578.34
P000591931N | 8 | 27654.03
P000592975G | 18 | 4893922.419999999
P000593000E | 1 | 14655.17
P000593054U | 19 | 850713.5
P000593540R | 348 | 32580326.22000001
P000593726V | 1 | 1493382
P000593754B | 49 | 165229.28
P000593835X | 1 | 145862.07
P000593847B | 1 | 18103.45
P000593951A | 49 | 24136601.71999999
P000594138V | 1 | 17706.89
P000595019S | 5 | 2461087.8
P000595387M | 3 | 291662.08
P000595543A | 2 | 38823.27
P000595898U | 1 | 172.41
P000596247D | 318 | 22740463.36
P000596981O | 2 | 24405.17
P000597083J | 2 | 45600
P000598426E | 1 | 71109.52
P000599330B | 9 | 679852.74
P000599397W | 10 | 2211180
P000599641H | 15 | 3787233.6
P000600012S | 4 | 504807.24
P000600201U | 2 | 6274468.45
P000600807G | 40 | 5207697.219999998
P000601243D | 1 | 49349.64
P000601336F | 9 | 347413.8200000001
[NAME] | 2 | 53448.28
P000602568W | 2 | 71500
P000602724K | 1 | 7327.59
P000602849U | 1 | 19655.17
P000602855U | 2 | 596220
P000605924U | 7 | 908548.41
P000605947B | 1 | 19300
P000606225Q | 1 | 1068965.52
P000607275E | 1 | 52664
P000607337X | 2 | 695600
P000607572E | 1 | 8720.69
P000607761D | 1 | 1830374.71
[NAME] | 1 | 29138
P000608476J | 17 | 590741.3800000001
P000608914V | 3 | 54137.94
P000609122S | 1 | 44497.01
P000609289O | 6 | 109919.49
P000609554G | 2 | 609000
P000609738G | 15 | 168736.8
P000610870Q | 1 | 1400
P000611437I | 1 | 104160
P000612054M | 11 | 671390
P000613055P | 23 | 4590226.979999999
P000613151M | 5 | 501598.02
P000613307I | 2 | 2005
P000614225L | 1 | 14200
P000614571W | 3 | 14137.93
P000618339C | 6 | 166944.75
P000618404S | 20 | 2690517.81
P000618582J | 5 | 100349.45
P000618741A | 6 | 850753.1699999999
P000618782L | 10 | 1220862
P000619056E | 1 | 319466.58
P000619517X | 2 | 99840
P000619536D | 1 | 98000
P000623096Z | 1 | 100000
P000626389L | 1 | 24612.07
P000632908P | 3 | 59500
P051091110Y | 2 | 452.59
P051091210Z | 2 | 1118804.02
P051093550W | 3 | 146530.51
P051094522S | 64 | 4083001.92
P051096302S | 1 | 3189.7
P051098601Y | 5 | 571551.8
P051099009C | 9 | 4252191.2
[NAME] | 20 | 39207496.82
P051100126A | 1 | 385000
[NAME] | 3 | 329741
P051101397S | 21 | 927206.6
P051101689V | 1 | 1724.14
P051102301X | 8 | 1083380
P051102526I | 23 | 925101.69
P051103498B | 1 | 48200
P051106696J | 1 | 19200
P051107525T | 1 | 27750
P051108133R | 1 | 25000
P051109614S | 1 | 18375
P051112828Z | 13 | 9730720
P051116193C | 13 | 7354781.779999999
P051116728X | 13 | 264466.52
P051116910M | 1 | 17144.07
P051118168F | 2 | 284000
P051118598P | 2 | 9745.69
P051120450H | 1 | 344.83
P051120877W | 1 | 2155.17
P051120928M | 1 | 4310.34
P051123223G | 24 | 14930.98
P051123882Z | 1 | 455172.41
P051124636R | 2 | 164000
P051126254X | 1 | 9823.55
P051127382E | 2 | 21887.58
P051127693K | 13 | 5814452.59
[NAME] | 5 | 41024.52
P051129820X | 46 | 118841.56
P051130271L | 3 | 13834.48
P051130348L | 7 | 124809.11
P051131284P | 8 | 3098926.09
P051131507D | 2 | 0
P051131780Q | 3 | 16350.95
P051132716I | 3 | 405318.98
P051135528V | 2 | 124074.83
P051136980H | 1 | 250000
P051140186S | 1 | 47568.92
P051140354M | 2 | 37328.45
P051140749R | 1 | 11900
P051142421G | 14 | 926413.7500000001
P051142583X | 1 | 1793103.45
P051144974E | 1 | 1180000
P051145241Q | 8 | 83879.29999999999
P051145349Z | 1 | 545000
P051146897Q | 1 | 5607.35
P051147807Y | 6 | 4310.33
P051148225W | 9 | 1955172.42
P051149654J | 7 | 917498.2799999999
P051150942N | 2 | 47070
P051151297W | 1 | 3637.5
P051151486V | 1 | 646.55
P051152544P | 9 | 26388.16
P051157855J | 1 | 1163.79
P051158110M | 6 | 2497944
P051158346D | 2 | 7586.21
P051158711T | 1 | 8000
P051160072N | 3 | 34883.78
P051161349Z | 4 | 36637.93
[NAME] | 2 | 95000
P051166312N | 6 | 3226724.15
P051169829K | 1 | 256032
P051170316E | 3 | 36162.41
P051170664U | 1 | 1325832.03
P051171407G | 19 | 30372798.2
P051171485W | 3 | 27265.7
P051172035L | 6 | 4960344.83
P051175330R | 1 | 39375
P051176354D | 1 | 103423.2
P051177317V | 1 | 1706896.55
P051179811Y | 62 | 9601839.200000003
P051180008F | 3 | 162705.17
P051180977D | 2 | 21000
P051186282H | 6 | 96465.48999999999
P051188356K | 3 | 25431.03
P051188806D | 3 | 1400.85
P051189489W | 1 | 16822.03
P051190035J | 1 | 237068.97
P051191777B | 3 | 841397.75
P051193989Z | 1 | 2155.17
P051196344B | 4 | 423379.08
P051197854M | 1 | 15000
[NAME] | 10 | 1546563
P051205057Z | 1 | 441000
P051206090C | 7 | 53000
P051208292K | 1 | 2586.21
P051213646V | 1 | 1273
P051214980E | 5 | 648560
P051215746C | 1 | 431.03
P051217302Q | 3 | 28350
P051232411F | 2 | 238881.6
P051238885U | 5 | 807957.3500000001
P051238971P | 2 | 3143758.62
P051239191N | 1 | 129.31
P051240352P | 1 | 22940
P051242086A | 20 | 9320732.760000002
P051246307W | 1 | 4310.34
P051301514D | 2 | 1956894.83
P051307297P | 4 | 195000
P051313216K | 1 | 40500
[NAME] | 1 | 4056
P051318424B | 1 | 9240
P051318504Y | 3 | 43103.45
P051319221Y | 2 | 100000
P051326962L | 2 | 8319836
P051331397C | 1 | 862.07
P051334745B | 1 | 235000
P051335641A | 1 | 1810.34
P051336238D | 1 | 2521.58
P051344610N | 1 | 19575
P051344856I | 1 | 2557440
P051349335I | 1 | 21336.21
P051351982D | 2 | 1139913.8
P051354119S | 24 | 13231767.28
P051360973E | 2 | 38000
P051363219S | 1 | 137.93
[NAME] | 26 | 52973.86
P051378490T | 5 | 155000
P051379409K | 3 | 862.0699999999999
P051379823M | 1 | 327.58
P051382234U | 3 | 438693.93
P051383716W | 1 | 305172.41
P051388515F | 1 | 615000
P051389762V | 14 | 928715.9500000001
P051394728G | 8 | 165852.9
P051402277B | 3 | 105137.93
P051408720B | 1 | 1367700
P051410445Q | 1 | 15000
P051415866N | 2 | 36558
P051417224Z | 2 | 357358.66
P051424451Z | 1 | 15517.24
P051428779Y | 19 | 4609748
P051429622G | 2 | 34482.76
P051437600X | 1 | 17500
P051439119E | 3 | 187000
P051464925E | 6 | 47934.48
P051466372N | 4 | 8445
P051466676U | 22 | 391448.2800000001
P051473038Z | 1 | 200000
P051501282X | 2 | 268965.52
P051504929G | 1 | 13448.28
P051507905G | 1 | 12000
P051510199H | 1 | 1200000
[NAME] | 1 | 249827.59
P051513103N | 8 | 780464
P051515043A | 1 | 3620.69
P051522497N | 2 | 10662.1
P051524398R | 1 | 1896.55
[NAME] | 1 | 72810
P051540248Y | 1 | 215.52
P051541631S | 4 | 428016.15
[NAME] | 9 | 1219500
[NAME] | 2 | 423763.2
P051551335U | 1 | 38793.1
P051555301X | 2 | 517241.37
P051556536M | 1 | 5172.41
P051561540U | 1 | 948.28
P051564713Z | 2 | 157241.38
P051572738I | 9 | 2103827.58
P051573743H | 1 | 22500
P051574469S | 1 | 31024.14
P051585510A | 1 | 129800
P051587392Z | 1 | 554353.45
P051596471U | 1 | 34482.76
P051604886S | 1 | 221842.05
P051606956T | 2 | 422976.49
P051608516G | 1 | 51724.14
P051611109Z | 2 | 1476293.11
P051622508X | 6 | 18147.43
P051622952H | 1 | 1770706.9
P051632593N | 1 | 1724.01
P051636086T | 2 | 410000
P051637464T | 1 | 93860
P051640447B | 27 | 3494755.44
P051646896E | 2 | 1293.1
P051653560I | 3 | 148965.52
P051663513X | 3 | 18318.97
P051666275V | 3 | 18403.45
P051673657Q | 1 | 12500
P051684706H | 1 | 5913.79
P051689331Q | 3 | 12420700
P051689678K | 1 | 474.14
P051708736R | 1 | 215000
P051708993E | 1 | 24500
P051721096H | 2 | 26700
P051730846F | 1 | 30000
P051731845D | 12 | 2103689.66
P051740510Z | 1 | 31420
P051743577S | 1 | 258620.69
P051747157U | 3 | 142241.37
P051764900D | 26 | 6355663.76
P051765163Q | 1 | 5250
P051769529Y | 1 | -600
P051782176P | 1 | 2500
P051789601P | 7 | 517206.74
[NAME] | 4 | 213000
P051815514D | 3 | 442241.37
P051822696U | 5 | 62080
P051830863K | 1 | 4337.07
P051831499R | 1 | 1100
P051841479Z | 4 | 1941637.93
P051841830Z | 3 | 9181.04
P051851302R | 1 | 21982.76
P051874473U | 3 | 490000.56
P051879739F | 8 | 93000
P051896480B | 3 | 945000
P051919622R | 34 | 6523796.589999999
P051927616N | 1 | 43965.52
P051941577P | 7 | 1377855
P051969231T | 1 | 20000
P051975771B | 3 | 12506.89
P051994956C | 82 | 2124097.24
P051997929F | 1 | 94784.31
P052015034Z | 1 | 582500
P052016803R | 1 | 198000
P052025493G | 2 | 1256034.48
P052033168X | 1 | 8000
P052039251D | 3 | 31186.21
P052070129M | 1 | 23275.86
P052081467X | 1 | 12284.48
P052094481F | 1 | 1431034.48
P052109715V | 7 | 47605.18
P052121143D | 3 | 1698275.86
P052123852U | 1 | 5603.45
[NAME] | 4 | 5128181.039999999
[NAME] | 2 | 71337.34
P052181474V | 1 | 396560
P052205648D | 2 | 3189655.18
P052220500C | 1 | 2586.21
P052231370Q | 1 | 5824.14
P052236119V | 1 | 43103.45
P052245081E | 1 | 160000
P052249266P | 2 | 5295700
P052252869J | 1 | 450000
P052255998X | 1 | 1077586.21
P052262509T | 4 | 240000
P052300528Z | 5 | 15517.24
P052301516G | 10 | 4536318.98
P052309371L | 1 | 1164709.48
P052373338B | 1 | 6206.9
Grand Total | 2348 | 418413153.6599993