{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Question","Start","DD","Mike","Bill"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":1},"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":"Question","index":0,"n_rows":194,"n_cols":5,"rows_kept":194,"cut":false,"hidden":false,"merged":[]}
["Industry","Customer","Amount",null,"Alex asks:  is there a way to show the top 2 customers per industry?"]
["A","Acct 8375",59948.701198641109]
["A","Acct 1119",57571.432058516744]
["A","Acct 5201",51158.299885325156]
["A","Acct 4408",23608.901998540343]
["B","Acct 2516",99568.567525250037]
["B","Acct 3743",81646.665885651004]
["B","Acct 4045",79274.823478148726]
["B","Acct 7206",64366.495318589732]
["B","Acct 4007",52577.103164786662]
["B","Acct 3806",13796.142644822095]
["B","Acct 1910",12138.442495236857]
["B","Acct 7089",8774.8026805944846]
["C","Acct 4308",45239.218902719978]
["C","Acct 5600",25193.714664525236]
["C","Acct 6115",17495.623050845155]
["D","Acct 2337",98475.307688900779]
["D","Acct 8136",97846.31589242247]
["D","Acct 4816",26444.325750543539]
["E","Acct 3149",72092.199651957693]
["E","Acct 7662",65470.184284119059]
["E","Acct 4289",64944.26296356738]
["E","Acct 7792",62998.694120045839]
["E","Acct 5617",62734.08329937575]
["E","Acct 7210",50013.311746072031]
["E","Acct 4341",39233.444282046439]
["E","Acct 6062",29832.458673877827]
["E","Acct 1364",17251.793375353474]
["E","Acct 5119",10396.892563135962]
["F","Acct 3626",83709.062277228455]
["F","Acct 7853",67756.829240491483]
["F","Acct 6976",59664.026927225699]
["F","Acct 5891",48310.794809471889]
["F","Acct 7434",43426.488050126041]
["F","Acct 1805",20969.511691952881]
["F","Acct 3479",2233.0877044513641]
["G","Acct 4572",98032.383611700527]
["G","Acct 3463",78194.091269626821]
["G","Acct 4202",76665.750257587832]
["G","Acct 6885",56257.227525234288]
["G","Acct 6445",40864.926055360163]
["G","Acct 5336",6883.7709958614932]
["H","Acct 7000",95458.07830050755]
["H","Acct 3609",89821.418741519999]
["H","Acct 4633",89361.942591034429]
["H","Acct 3846",86798.501207525958]
["H","Acct 1067",43392.063969875504]
["H","Acct 5766",24277.339010315001]
["H","Acct 2003",20094.052456190082]
["H","Acct 6171",19433.15046207772]
["H","Acct 3929",7789.3703568382207]
["H","Acct 8365",3466.3045130392866]
["H","Acct 8318",1854.4621656475856]
["H","Acct 5742",68.401019163055736]
["I","Acct 2335",96986.478946464005]
["I","Acct 7761",94931.171086085713]
["I","Acct 7297",90699.261858278114]
["I","Acct 5300",87789.328269525518]
["I","Acct 3853",86204.595435424795]
["I","Acct 1079",74531.421535208792]
["I","Acct 4623",74069.427022633623]
["I","Acct 2401",66564.803428470259]
["I","Acct 5360",53569.205169452172]
["I","Acct 8371",23389.143038519091]
["I","Acct 2234",12050.678952141358]
["J","Acct 6172",93547.891564467995]
["J","Acct 4394",88084.334500708588]
["J","Acct 7933",87655.308899984651]
["J","Acct 7673",82293.104880033716]
["J","Acct 8868",81510.467506900051]
["J","Acct 1385",69549.267947399916]
["J","Acct 1353",64993.578410125861]
["J","Acct 3839",62790.980512658687]
["J","Acct 7937",37230.676759181959]
["J","Acct 3572",27859.12782444404]
["J","Acct 8285",16955.51182875994]
["J","Acct 4583",9687.6331415009954]
["K","Acct 7565",84888.3557188181]
["K","Acct 6510",70681.601631156314]
["K","Acct 6891",59407.130969918151]
["K","Acct 2455",56457.318323541193]
["K","Acct 5001",37382.501380440444]
["L","Acct 8898",98419.82694628532]
["L","Acct 8210",72573.353135136334]
["L","Acct 8361",57832.389120664964]
["L","Acct 8038",41764.529772309797]
["L","Acct 3155",33360.942138445571]
["L","Acct 5975",10963.989377962658]
["L","Acct 3693",5145.0679813428878]
["M","Acct 1839",93012.868685983034]
["M","Acct 8666",89585.223662240242]
["M","Acct 5486",83186.624258868935]
["M","Acct 7791",71962.025844609889]
["M","Acct 7844",70209.460628448345]
["M","Acct 3951",65416.931332410903]
["M","Acct 5535",59374.365818534447]
["M","Acct 5922",53247.285606027915]
["M","Acct 1928",53083.049022911968]
["M","Acct 1489",30363.21523896942]
["M","Acct 2671",19973.06971246413]
["M","Acct 8409",18684.296007320787]
["M","Acct 1029",12275.341687067708]
["M","Acct 5378",5989.472665921614]
["N","Acct 7568",75958.520399238434]
["N","Acct 1881",68036.179783628075]
["N","Acct 2572",35387.666055635462]
["N","Acct 6471",26247.804740380965]
["N","Acct 3287",16958.805359766848]
["N","Acct 5385",16270.326629001696]
["N","Acct 6968",3441.5438593462522]
["O","Acct 2274",98826.453609775665]
["O","Acct 4857",80257.656503568927]
["O","Acct 3449",42019.850448222431]
["O","Acct 8704",28612.064572513373]
["O","Acct 3511",28534.865024923994]
["P","Acct 7506",98371.957216768133]
["P","Acct 8246",85292.137879763279]
["P","Acct 7863",85194.239646258648]
["P","Acct 1457",81855.218059321414]
["P","Acct 2682",47153.535610922416]
["P","Acct 8012",42087.342515283024]
["P","Acct 2752",41447.981980571625]
["P","Acct 6769",37767.112763393619]
["P","Acct 3180",13917.201059140294]
["Q","Acct 3599",83535.147175419741]
["Q","Acct 1289",44824.408958438311]
["Q","Acct 3068",31145.337098534397]
["Q","Acct 1496",14932.955485635446]
["R","Acct 4164",88970.843076139776]
["R","Acct 7397",85708.50929882683]
["R","Acct 6023",74273.508848181009]
["R","Acct 4100",43672.911787917968]
["R","Acct 8152",36607.047572390074]
["R","Acct 7092",29185.529257034559]
["R","Acct 2588",25304.69252127334]
["R","Acct 4783",7744.3144514072856]
["S","Acct 2814",76834.025919695297]
["S","Acct 4150",56289.341835275176]
["S","Acct 8643",47809.554028744547]
["S","Acct 6269",41921.984416262072]
["S","Acct 1034",34929.233956985816]
["S","Acct 8653",30915.561620566979]
["S","Acct 1315",6428.7769890917998]
["T","Acct 2211",77993.273405303655]
["T","Acct 7416",52875.38074087417]
["T","Acct 4526",34201.873974298614]
["T","Acct 6104",34131.139663162045]
["T","Acct 8943",18023.937649358435]
["T","Acct 1804",11937.654793067864]
["T","Acct 7464",11534.378379106869]
["T","Acct 2776",10598.165394744552]
["U","Acct 6175",94460.225887369714]
["U","Acct 3099",69380.535860821517]
["U","Acct 3368",50397.749597289985]
["U","Acct 4996",27407.916767624385]
["U","Acct 5124",20942.261918338823]
["U","Acct 1799",19966.876355848693]
["V","Acct 2893",90009.426074220391]
["V","Acct 6058",89086.219281350044]
["V","Acct 8919",80698.698876596623]
["V","Acct 3637",77526.661323302294]
["V","Acct 7968",76227.680486931786]
["V","Acct 6752",72064.545259473292]
["V","Acct 5203",69539.252716050803]
["V","Acct 4579",51261.581782236441]
["V","Acct 2607",44606.242804784924]
["V","Acct 6361",35569.629642003863]
["W","Acct 5113",84485.285822197315]
["W","Acct 3607",84196.837223824099]
["W","Acct 5655",83233.555443191712]
["W","Acct 5177",60065.297803779948]
["W","Acct 7776",56415.591684292442]
["W","Acct 8156",28647.069512270285]
["W","Acct 4708",22122.262555228601]
["W","Acct 1970",17766.844024179351]
["W","Acct 8513",13218.842175105949]
["X","Acct 1468",96875.666033515285]
["X","Acct 8421",91985.651518750223]
["X","Acct 5176",67364.968983625469]
["X","Acct 5243",39771.947012448916]
["Y","Acct 6120",67790.265221296489]
["Y","Acct 8634",54469.545793770703]
["Y","Acct 2377",36832.298898686]
["Y","Acct 2318",23587.42117057553]
["Y","Acct 5888",6870.4628633050379]
["Z","Acct 7408",99579.82654280118]
["Z","Acct 2468",82730.192313480526]
["Z","Acct 6122",80274.179806068685]
["Z","Acct 1782",35550.520792141171]
["Z","Acct 8453",24668.664993029066]
["Z","Acct 8259",17226.994831884102]
["Z","Acct 2300",15073.748208474048]
["Z","Acct 4734",14909.96885258835]
["Z","Acct 2666",12675.218539484102]

{"sheet":"Start","index":1,"n_rows":194,"n_cols":5,"rows_kept":194,"cut":false,"hidden":false,"merged":[]}
["Industry","Customer","Amount",null,"Alex asks:  is there a way to show the top 2 customers per industry?"]
["A","Acct 8375",59948.701198641109]
["A","Acct 1119",57571.432058516744]
["A","Acct 5201",51158.299885325156]
["A","Acct 4408",23608.901998540343]
["B","Acct 2516",99568.567525250037]
["B","Acct 3743",81646.665885651004]
["B","Acct 4045",79274.823478148726]
["B","Acct 7206",64366.495318589732]
["B","Acct 4007",52577.103164786662]
["B","Acct 3806",13796.142644822095]
["B","Acct 1910",12138.442495236857]
["B","Acct 7089",8774.8026805944846]
["C","Acct 4308",45239.218902719978]
["C","Acct 5600",25193.714664525236]
["C","Acct 6115",17495.623050845155]
["D","Acct 2337",98475.307688900779]
["D","Acct 8136",97846.31589242247]
["D","Acct 4816",26444.325750543539]
["E","Acct 3149",72092.199651957693]
["E","Acct 7662",65470.184284119059]
["E","Acct 4289",64944.26296356738]
["E","Acct 7792",62998.694120045839]
["E","Acct 5617",62734.08329937575]
["E","Acct 7210",50013.311746072031]
["E","Acct 4341",39233.444282046439]
["E","Acct 6062",29832.458673877827]
["E","Acct 1364",17251.793375353474]
["E","Acct 5119",10396.892563135962]
["F","Acct 3626",83709.062277228455]
["F","Acct 7853",67756.829240491483]
["F","Acct 6976",59664.026927225699]
["F","Acct 5891",48310.794809471889]
["F","Acct 7434",43426.488050126041]
["F","Acct 1805",20969.511691952881]
["F","Acct 3479",2233.0877044513641]
["G","Acct 4572",98032.383611700527]
["G","Acct 3463",78194.091269626821]
["G","Acct 4202",76665.750257587832]
["G","Acct 6885",56257.227525234288]
["G","Acct 6445",40864.926055360163]
["G","Acct 5336",6883.7709958614932]
["H","Acct 7000",95458.07830050755]
["H","Acct 3609",89821.418741519999]
["H","Acct 4633",89361.942591034429]
["H","Acct 3846",86798.501207525958]
["H","Acct 1067",43392.063969875504]
["H","Acct 5766",24277.339010315001]
["H","Acct 2003",20094.052456190082]
["H","Acct 6171",19433.15046207772]
["H","Acct 3929",7789.3703568382207]
["H","Acct 8365",3466.3045130392866]
["H","Acct 8318",1854.4621656475856]
["H","Acct 5742",68.401019163055736]
["I","Acct 2335",96986.478946464005]
["I","Acct 7761",94931.171086085713]
["I","Acct 7297",90699.261858278114]
["I","Acct 5300",87789.328269525518]
["I","Acct 3853",86204.595435424795]
["I","Acct 1079",74531.421535208792]
["I","Acct 4623",74069.427022633623]
["I","Acct 2401",66564.803428470259]
["I","Acct 5360",53569.205169452172]
["I","Acct 8371",23389.143038519091]
["I","Acct 2234",12050.678952141358]
["J","Acct 6172",93547.891564467995]
["J","Acct 4394",88084.334500708588]
["J","Acct 7933",87655.308899984651]
["J","Acct 7673",82293.104880033716]
["J","Acct 8868",81510.467506900051]
["J","Acct 1385",69549.267947399916]
["J","Acct 1353",64993.578410125861]
["J","Acct 3839",62790.980512658687]
["J","Acct 7937",37230.676759181959]
["J","Acct 3572",27859.12782444404]
["J","Acct 8285",16955.51182875994]
["J","Acct 4583",9687.6331415009954]
["K","Acct 7565",84888.3557188181]
["K","Acct 6510",70681.601631156314]
["K","Acct 6891",59407.130969918151]
["K","Acct 2455",56457.318323541193]
["K","Acct 5001",37382.501380440444]
["L","Acct 8898",98419.82694628532]
["L","Acct 8210",72573.353135136334]
["L","Acct 8361",57832.389120664964]
["L","Acct 8038",41764.529772309797]
["L","Acct 3155",33360.942138445571]
["L","Acct 5975",10963.989377962658]
["L","Acct 3693",5145.0679813428878]
["M","Acct 1839",93012.868685983034]
["M","Acct 8666",89585.223662240242]
["M","Acct 5486",83186.624258868935]
["M","Acct 7791",71962.025844609889]
["M","Acct 7844",70209.460628448345]
["M","Acct 3951",65416.931332410903]
["M","Acct 5535",59374.365818534447]
["M","Acct 5922",53247.285606027915]
["M","Acct 1928",53083.049022911968]
["M","Acct 1489",30363.21523896942]
["M","Acct 2671",19973.06971246413]
["M","Acct 8409",18684.296007320787]
["M","Acct 1029",12275.341687067708]
["M","Acct 5378",5989.472665921614]
["N","Acct 7568",75958.520399238434]
["N","Acct 1881",68036.179783628075]
["N","Acct 2572",35387.666055635462]
["N","Acct 6471",26247.804740380965]
["N","Acct 3287",16958.805359766848]
["N","Acct 5385",16270.326629001696]
["N","Acct 6968",3441.5438593462522]
["O","Acct 2274",98826.453609775665]
["O","Acct 4857",80257.656503568927]
["O","Acct 3449",42019.850448222431]
["O","Acct 8704",28612.064572513373]
["O","Acct 3511",28534.865024923994]
["P","Acct 7506",98371.957216768133]
["P","Acct 8246",85292.137879763279]
["P","Acct 7863",85194.239646258648]
["P","Acct 1457",81855.218059321414]
["P","Acct 2682",47153.535610922416]
["P","Acct 8012",42087.342515283024]
["P","Acct 2752",41447.981980571625]
["P","Acct 6769",37767.112763393619]
["P","Acct 3180",13917.201059140294]
["Q","Acct 3599",83535.147175419741]
["Q","Acct 1289",44824.408958438311]
["Q","Acct 3068",31145.337098534397]
["Q","Acct 1496",14932.955485635446]
["R","Acct 4164",88970.843076139776]
["R","Acct 7397",85708.50929882683]
["R","Acct 6023",74273.508848181009]
["R","Acct 4100",43672.911787917968]
["R","Acct 8152",36607.047572390074]
["R","Acct 7092",29185.529257034559]
["R","Acct 2588",25304.69252127334]
["R","Acct 4783",7744.3144514072856]
["S","Acct 2814",76834.025919695297]
["S","Acct 4150",56289.341835275176]
["S","Acct 8643",47809.554028744547]
["S","Acct 6269",41921.984416262072]
["S","Acct 1034",34929.233956985816]
["S","Acct 8653",30915.561620566979]
["S","Acct 1315",6428.7769890917998]
["T","Acct 2211",77993.273405303655]
["T","Acct 7416",52875.38074087417]
["T","Acct 4526",34201.873974298614]
["T","Acct 6104",34131.139663162045]
["T","Acct 8943",18023.937649358435]
["T","Acct 1804",11937.654793067864]
["T","Acct 7464",11534.378379106869]
["T","Acct 2776",10598.165394744552]
["U","Acct 6175",94460.225887369714]
["U","Acct 3099",69380.535860821517]
["U","Acct 3368",50397.749597289985]
["U","Acct 4996",27407.916767624385]
["U","Acct 5124",20942.261918338823]
["U","Acct 1799",19966.876355848693]
["V","Acct 2893",90009.426074220391]
["V","Acct 6058",89086.219281350044]
["V","Acct 8919",80698.698876596623]
["V","Acct 3637",77526.661323302294]
["V","Acct 7968",76227.680486931786]
["V","Acct 6752",72064.545259473292]
["V","Acct 5203",69539.252716050803]
["V","Acct 4579",51261.581782236441]
["V","Acct 2607",44606.242804784924]
["V","Acct 6361",35569.629642003863]
["W","Acct 5113",84485.285822197315]
["W","Acct 3607",84196.837223824099]
["W","Acct 5655",83233.555443191712]
["W","Acct 5177",60065.297803779948]
["W","Acct 7776",56415.591684292442]
["W","Acct 8156",28647.069512270285]
["W","Acct 4708",22122.262555228601]
["W","Acct 1970",17766.844024179351]
["W","Acct 8513",13218.842175105949]
["X","Acct 1468",96875.666033515285]
["X","Acct 8421",91985.651518750223]
["X","Acct 5176",67364.968983625469]
["X","Acct 5243",39771.947012448916]
["Y","Acct 6120",67790.265221296489]
["Y","Acct 8634",54469.545793770703]
["Y","Acct 2377",36832.298898686]
["Y","Acct 2318",23587.42117057553]
["Y","Acct 5888",6870.4628633050379]
["Z","Acct 7408",99579.82654280118]
["Z","Acct 2468",82730.192313480526]
["Z","Acct 6122",80274.179806068685]
["Z","Acct 1782",35550.520792141171]
["Z","Acct 8453",24668.664993029066]
["Z","Acct 8259",17226.994831884102]
["Z","Acct 2300",15073.748208474048]
["Z","Acct 4734",14909.96885258835]
["Z","Acct 2666",12675.218539484102]

{"sheet":"DD","index":2,"n_rows":53,"n_cols":3,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
["Industry","Customer","Amount"]
["A","Acct 8375",59948.701198641109]
["A","Acct 1119",57571.432058516744]
["B","Acct 2516",99568.567525250037]
["B","Acct 3743",81646.665885651004]
["C","Acct 4308",45239.218902719978]
["C","Acct 5600",25193.714664525236]
["D","Acct 2337",98475.307688900779]
["D","Acct 8136",97846.31589242247]
["E","Acct 3149",72092.199651957693]
["E","Acct 7662",65470.184284119059]
["F","Acct 3626",83709.062277228455]
["F","Acct 7853",67756.829240491483]
["G","Acct 4572",98032.383611700527]
["G","Acct 3463",78194.091269626821]
["H","Acct 7000",95458.07830050755]
["H","Acct 3609",89821.418741519999]
["I","Acct 2335",96986.478946464005]
["I","Acct 7761",94931.171086085713]
["J","Acct 6172",93547.891564467995]
["J","Acct 4394",88084.334500708588]
["K","Acct 7565",84888.3557188181]
["K","Acct 6510",70681.601631156314]
["L","Acct 8898",98419.82694628532]
["L","Acct 8210",72573.353135136334]
["M","Acct 1839",93012.868685983034]
["M","Acct 8666",89585.223662240242]
["N","Acct 7568",75958.520399238434]
["N","Acct 1881",68036.179783628075]
["O","Acct 2274",98826.453609775665]
["O","Acct 4857",80257.656503568927]
["P","Acct 7506",98371.957216768133]
["P","Acct 8246",85292.137879763279]
["Q","Acct 3599",83535.147175419741]
["Q","Acct 1289",44824.408958438311]
["R","Acct 4164",88970.843076139776]
["R","Acct 7397",85708.50929882683]
["S","Acct 2814",76834.025919695297]
["S","Acct 4150",56289.341835275176]
["T","Acct 2211",77993.273405303655]
["T","Acct 7416",52875.38074087417]
["U","Acct 6175",94460.225887369714]
["U","Acct 3099",69380.535860821517]
["V","Acct 2893",90009.426074220391]
["V","Acct 6058",89086.219281350044]
["W","Acct 5113",84485.285822197315]
["W","Acct 3607",84196.837223824099]
["X","Acct 1468",96875.666033515285]
["X","Acct 8421",91985.651518750223]
["Y","Acct 6120",67790.265221296489]
["Y","Acct 8634",54469.545793770703]
["Z","Acct 7408",99579.82654280118]
["Z","Acct 2468",82730.192313480526]

{"sheet":"Mike","index":3,"n_rows":194,"n_cols":6,"rows_kept":194,"cut":false,"hidden":false,"merged":[]}
["Industry","Customer","Amount","No",null,"Alex asks:  is there a way to show the top 2 customers per industry?"]
["A","Acct 8375",59948.701198641109,{"$f":"COUNTIF(A$2:A2,A2)","v":1}]
["A","Acct 1119",57571.432058516744,{"$f":"COUNTIF(A$2:A3,A3)","v":2}]
["A","Acct 5201",51158.299885325156,{"$f":"COUNTIF(A$2:A4,A4)","v":3}]
["A","Acct 4408",23608.901998540343,{"$f":"COUNTIF(A$2:A5,A5)","v":4}]
["B","Acct 2516",99568.567525250037,{"$f":"COUNTIF(A$2:A6,A6)","v":1}]
["B","Acct 3743",81646.665885651004,{"$f":"COUNTIF(A$2:A7,A7)","v":2}]
["B","Acct 4045",79274.823478148726,{"$f":"COUNTIF(A$2:A8,A8)","v":3}]
["B","Acct 7206",64366.495318589732,{"$f":"COUNTIF(A$2:A9,A9)","v":4}]
["B","Acct 4007",52577.103164786662,{"$f":"COUNTIF(A$2:A10,A10)","v":5}]
["B","Acct 3806",13796.142644822095,{"$f":"COUNTIF(A$2:A11,A11)","v":6}]
["B","Acct 1910",12138.442495236857,{"$f":"COUNTIF(A$2:A12,A12)","v":7}]
["B","Acct 7089",8774.8026805944846,{"$f":"COUNTIF(A$2:A13,A13)","v":8}]
["C","Acct 4308",45239.218902719978,{"$f":"COUNTIF(A$2:A14,A14)","v":1}]
["C","Acct 5600",25193.714664525236,{"$f":"COUNTIF(A$2:A15,A15)","v":2}]
["C","Acct 6115",17495.623050845155,{"$f":"COUNTIF(A$2:A16,A16)","v":3}]
["D","Acct 2337",98475.307688900779,{"$f":"COUNTIF(A$2:A17,A17)","v":1}]
["D","Acct 8136",97846.31589242247,{"$f":"COUNTIF(A$2:A18,A18)","v":2}]
["D","Acct 4816",26444.325750543539,{"$f":"COUNTIF(A$2:A19,A19)","v":3}]
["E","Acct 3149",72092.199651957693,{"$f":"COUNTIF(A$2:A20,A20)","v":1}]
["E","Acct 7662",65470.184284119059,{"$f":"COUNTIF(A$2:A21,A21)","v":2}]
["E","Acct 4289",64944.26296356738,{"$f":"COUNTIF(A$2:A22,A22)","v":3}]
["E","Acct 7792",62998.694120045839,{"$f":"COUNTIF(A$2:A23,A23)","v":4}]
["E","Acct 5617",62734.08329937575,{"$f":"COUNTIF(A$2:A24,A24)","v":5}]
["E","Acct 7210",50013.311746072031,{"$f":"COUNTIF(A$2:A25,A25)","v":6}]
["E","Acct 4341",39233.444282046439,{"$f":"COUNTIF(A$2:A26,A26)","v":7}]
["E","Acct 6062",29832.458673877827,{"$f":"COUNTIF(A$2:A27,A27)","v":8}]
["E","Acct 1364",17251.793375353474,{"$f":"COUNTIF(A$2:A28,A28)","v":9}]
["E","Acct 5119",10396.892563135962,{"$f":"COUNTIF(A$2:A29,A29)","v":10}]
["F","Acct 3626",83709.062277228455,{"$f":"COUNTIF(A$2:A30,A30)","v":1}]
["F","Acct 7853",67756.829240491483,{"$f":"COUNTIF(A$2:A31,A31)","v":2}]
["F","Acct 6976",59664.026927225699,{"$f":"COUNTIF(A$2:A32,A32)","v":3}]
["F","Acct 5891",48310.794809471889,{"$f":"COUNTIF(A$2:A33,A33)","v":4}]
["F","Acct 7434",43426.488050126041,{"$f":"COUNTIF(A$2:A34,A34)","v":5}]
["F","Acct 1805",20969.511691952881,{"$f":"COUNTIF(A$2:A35,A35)","v":6}]
["F","Acct 3479",2233.0877044513641,{"$f":"COUNTIF(A$2:A36,A36)","v":7}]
["G","Acct 4572",98032.383611700527,{"$f":"COUNTIF(A$2:A37,A37)","v":1}]
["G","Acct 3463",78194.091269626821,{"$f":"COUNTIF(A$2:A38,A38)","v":2}]
["G","Acct 4202",76665.750257587832,{"$f":"COUNTIF(A$2:A39,A39)","v":3}]
["G","Acct 6885",56257.227525234288,{"$f":"COUNTIF(A$2:A40,A40)","v":4}]
["G","Acct 6445",40864.926055360163,{"$f":"COUNTIF(A$2:A41,A41)","v":5}]
["G","Acct 5336",6883.7709958614932,{"$f":"COUNTIF(A$2:A42,A42)","v":6}]
["H","Acct 7000",95458.07830050755,{"$f":"COUNTIF(A$2:A43,A43)","v":1}]
["H","Acct 3609",89821.418741519999,{"$f":"COUNTIF(A$2:A44,A44)","v":2}]
["H","Acct 4633",89361.942591034429,{"$f":"COUNTIF(A$2:A45,A45)","v":3}]
["H","Acct 3846",86798.501207525958,{"$f":"COUNTIF(A$2:A46,A46)","v":4}]
["H","Acct 1067",43392.063969875504,{"$f":"COUNTIF(A$2:A47,A47)","v":5}]
["H","Acct 5766",24277.339010315001,{"$f":"COUNTIF(A$2:A48,A48)","v":6}]
["H","Acct 2003",20094.052456190082,{"$f":"COUNTIF(A$2:A49,A49)","v":7}]
["H","Acct 6171",19433.15046207772,{"$f":"COUNTIF(A$2:A50,A50)","v":8}]
["H","Acct 3929",7789.3703568382207,{"$f":"COUNTIF(A$2:A51,A51)","v":9}]
["H","Acct 8365",3466.3045130392866,{"$f":"COUNTIF(A$2:A52,A52)","v":10}]
["H","Acct 8318",1854.4621656475856,{"$f":"COUNTIF(A$2:A53,A53)","v":11}]
["H","Acct 5742",68.401019163055736,{"$f":"COUNTIF(A$2:A54,A54)","v":12}]
["I","Acct 2335",96986.478946464005,{"$f":"COUNTIF(A$2:A55,A55)","v":1}]
["I","Acct 7761",94931.171086085713,{"$f":"COUNTIF(A$2:A56,A56)","v":2}]
["I","Acct 7297",90699.261858278114,{"$f":"COUNTIF(A$2:A57,A57)","v":3}]
["I","Acct 5300",87789.328269525518,{"$f":"COUNTIF(A$2:A58,A58)","v":4}]
["I","Acct 3853",86204.595435424795,{"$f":"COUNTIF(A$2:A59,A59)","v":5}]
["I","Acct 1079",74531.421535208792,{"$f":"COUNTIF(A$2:A60,A60)","v":6}]
["I","Acct 4623",74069.427022633623,{"$f":"COUNTIF(A$2:A61,A61)","v":7}]
["I","Acct 2401",66564.803428470259,{"$f":"COUNTIF(A$2:A62,A62)","v":8}]
["I","Acct 5360",53569.205169452172,{"$f":"COUNTIF(A$2:A63,A63)","v":9}]
["I","Acct 8371",23389.143038519091,{"$f":"COUNTIF(A$2:A64,A64)","v":10}]
["I","Acct 2234",12050.678952141358,{"$f":"COUNTIF(A$2:A65,A65)","v":11}]
["J","Acct 6172",93547.891564467995,{"$f":"COUNTIF(A$2:A66,A66)","v":1}]
["J","Acct 4394",88084.334500708588,{"$f":"COUNTIF(A$2:A67,A67)","v":2}]
["J","Acct 7933",87655.308899984651,{"$f":"COUNTIF(A$2:A68,A68)","v":3}]
["J","Acct 7673",82293.104880033716,{"$f":"COUNTIF(A$2:A69,A69)","v":4}]
["J","Acct 8868",81510.467506900051,{"$f":"COUNTIF(A$2:A70,A70)","v":5}]
["J","Acct 1385",69549.267947399916,{"$f":"COUNTIF(A$2:A71,A71)","v":6}]
["J","Acct 1353",64993.578410125861,{"$f":"COUNTIF(A$2:A72,A72)","v":7}]
["J","Acct 3839",62790.980512658687,{"$f":"COUNTIF(A$2:A73,A73)","v":8}]
["J","Acct 7937",37230.676759181959,{"$f":"COUNTIF(A$2:A74,A74)","v":9}]
["J","Acct 3572",27859.12782444404,{"$f":"COUNTIF(A$2:A75,A75)","v":10}]
["J","Acct 8285",16955.51182875994,{"$f":"COUNTIF(A$2:A76,A76)","v":11}]
["J","Acct 4583",9687.6331415009954,{"$f":"COUNTIF(A$2:A77,A77)","v":12}]
["K","Acct 7565",84888.3557188181,{"$f":"COUNTIF(A$2:A78,A78)","v":1}]
["K","Acct 6510",70681.601631156314,{"$f":"COUNTIF(A$2:A79,A79)","v":2}]
["K","Acct 6891",59407.130969918151,{"$f":"COUNTIF(A$2:A80,A80)","v":3}]
["K","Acct 2455",56457.318323541193,{"$f":"COUNTIF(A$2:A81,A81)","v":4}]
["K","Acct 5001",37382.501380440444,{"$f":"COUNTIF(A$2:A82,A82)","v":5}]
["L","Acct 8898",98419.82694628532,{"$f":"COUNTIF(A$2:A83,A83)","v":1}]
["L","Acct 8210",72573.353135136334,{"$f":"COUNTIF(A$2:A84,A84)","v":2}]
["L","Acct 8361",57832.389120664964,{"$f":"COUNTIF(A$2:A85,A85)","v":3}]
["L","Acct 8038",41764.529772309797,{"$f":"COUNTIF(A$2:A86,A86)","v":4}]
["L","Acct 3155",33360.942138445571,{"$f":"COUNTIF(A$2:A87,A87)","v":5}]
["L","Acct 5975",10963.989377962658,{"$f":"COUNTIF(A$2:A88,A88)","v":6}]
["L","Acct 3693",5145.0679813428878,{"$f":"COUNTIF(A$2:A89,A89)","v":7}]
["M","Acct 1839",93012.868685983034,{"$f":"COUNTIF(A$2:A90,A90)","v":1}]
["M","Acct 8666",89585.223662240242,{"$f":"COUNTIF(A$2:A91,A91)","v":2}]
["M","Acct 5486",83186.624258868935,{"$f":"COUNTIF(A$2:A92,A92)","v":3}]
["M","Acct 7791",71962.025844609889,{"$f":"COUNTIF(A$2:A93,A93)","v":4}]
["M","Acct 7844",70209.460628448345,{"$f":"COUNTIF(A$2:A94,A94)","v":5}]
["M","Acct 3951",65416.931332410903,{"$f":"COUNTIF(A$2:A95,A95)","v":6}]
["M","Acct 5535",59374.365818534447,{"$f":"COUNTIF(A$2:A96,A96)","v":7}]
["M","Acct 5922",53247.285606027915,{"$f":"COUNTIF(A$2:A97,A97)","v":8}]
["M","Acct 1928",53083.049022911968,{"$f":"COUNTIF(A$2:A98,A98)","v":9}]
["M","Acct 1489",30363.21523896942,{"$f":"COUNTIF(A$2:A99,A99)","v":10}]
["M","Acct 2671",19973.06971246413,{"$f":"COUNTIF(A$2:A100,A100)","v":11}]
["M","Acct 8409",18684.296007320787,{"$f":"COUNTIF(A$2:A101,A101)","v":12}]
["M","Acct 1029",12275.341687067708,{"$f":"COUNTIF(A$2:A102,A102)","v":13}]
["M","Acct 5378",5989.472665921614,{"$f":"COUNTIF(A$2:A103,A103)","v":14}]
["N","Acct 7568",75958.520399238434,{"$f":"COUNTIF(A$2:A104,A104)","v":1}]
["N","Acct 1881",68036.179783628075,{"$f":"COUNTIF(A$2:A105,A105)","v":2}]
["N","Acct 2572",35387.666055635462,{"$f":"COUNTIF(A$2:A106,A106)","v":3}]
["N","Acct 6471",26247.804740380965,{"$f":"COUNTIF(A$2:A107,A107)","v":4}]
["N","Acct 3287",16958.805359766848,{"$f":"COUNTIF(A$2:A108,A108)","v":5}]
["N","Acct 5385",16270.326629001696,{"$f":"COUNTIF(A$2:A109,A109)","v":6}]
["N","Acct 6968",3441.5438593462522,{"$f":"COUNTIF(A$2:A110,A110)","v":7}]
["O","Acct 2274",98826.453609775665,{"$f":"COUNTIF(A$2:A111,A111)","v":1}]
["O","Acct 4857",80257.656503568927,{"$f":"COUNTIF(A$2:A112,A112)","v":2}]
["O","Acct 3449",42019.850448222431,{"$f":"COUNTIF(A$2:A113,A113)","v":3}]
["O","Acct 8704",28612.064572513373,{"$f":"COUNTIF(A$2:A114,A114)","v":4}]
["O","Acct 3511",28534.865024923994,{"$f":"COUNTIF(A$2:A115,A115)","v":5}]
["P","Acct 7506",98371.957216768133,{"$f":"COUNTIF(A$2:A116,A116)","v":1}]
["P","Acct 8246",85292.137879763279,{"$f":"COUNTIF(A$2:A117,A117)","v":2}]
["P","Acct 7863",85194.239646258648,{"$f":"COUNTIF(A$2:A118,A118)","v":3}]
["P","Acct 1457",81855.218059321414,{"$f":"COUNTIF(A$2:A119,A119)","v":4}]
["P","Acct 2682",47153.535610922416,{"$f":"COUNTIF(A$2:A120,A120)","v":5}]
["P","Acct 8012",42087.342515283024,{"$f":"COUNTIF(A$2:A121,A121)","v":6}]
["P","Acct 2752",41447.981980571625,{"$f":"COUNTIF(A$2:A122,A122)","v":7}]
["P","Acct 6769",37767.112763393619,{"$f":"COUNTIF(A$2:A123,A123)","v":8}]
["P","Acct 3180",13917.201059140294,{"$f":"COUNTIF(A$2:A124,A124)","v":9}]
["Q","Acct 3599",83535.147175419741,{"$f":"COUNTIF(A$2:A125,A125)","v":1}]
["Q","Acct 1289",44824.408958438311,{"$f":"COUNTIF(A$2:A126,A126)","v":2}]
["Q","Acct 3068",31145.337098534397,{"$f":"COUNTIF(A$2:A127,A127)","v":3}]
["Q","Acct 1496",14932.955485635446,{"$f":"COUNTIF(A$2:A128,A128)","v":4}]
["R","Acct 4164",88970.843076139776,{"$f":"COUNTIF(A$2:A129,A129)","v":1}]
["R","Acct 7397",85708.50929882683,{"$f":"COUNTIF(A$2:A130,A130)","v":2}]
["R","Acct 6023",74273.508848181009,{"$f":"COUNTIF(A$2:A131,A131)","v":3}]
["R","Acct 4100",43672.911787917968,{"$f":"COUNTIF(A$2:A132,A132)","v":4}]
["R","Acct 8152",36607.047572390074,{"$f":"COUNTIF(A$2:A133,A133)","v":5}]
["R","Acct 7092",29185.529257034559,{"$f":"COUNTIF(A$2:A134,A134)","v":6}]
["R","Acct 2588",25304.69252127334,{"$f":"COUNTIF(A$2:A135,A135)","v":7}]
["R","Acct 4783",7744.3144514072856,{"$f":"COUNTIF(A$2:A136,A136)","v":8}]
["S","Acct 2814",76834.025919695297,{"$f":"COUNTIF(A$2:A137,A137)","v":1}]
["S","Acct 4150",56289.341835275176,{"$f":"COUNTIF(A$2:A138,A138)","v":2}]
["S","Acct 8643",47809.554028744547,{"$f":"COUNTIF(A$2:A139,A139)","v":3}]
["S","Acct 6269",41921.984416262072,{"$f":"COUNTIF(A$2:A140,A140)","v":4}]
["S","Acct 1034",34929.233956985816,{"$f":"COUNTIF(A$2:A141,A141)","v":5}]
["S","Acct 8653",30915.561620566979,{"$f":"COUNTIF(A$2:A142,A142)","v":6}]
["S","Acct 1315",6428.7769890917998,{"$f":"COUNTIF(A$2:A143,A143)","v":7}]
["T","Acct 2211",77993.273405303655,{"$f":"COUNTIF(A$2:A144,A144)","v":1}]
["T","Acct 7416",52875.38074087417,{"$f":"COUNTIF(A$2:A145,A145)","v":2}]
["T","Acct 4526",34201.873974298614,{"$f":"COUNTIF(A$2:A146,A146)","v":3}]
["T","Acct 6104",34131.139663162045,{"$f":"COUNTIF(A$2:A147,A147)","v":4}]
["T","Acct 8943",18023.937649358435,{"$f":"COUNTIF(A$2:A148,A148)","v":5}]
["T","Acct 1804",11937.654793067864,{"$f":"COUNTIF(A$2:A149,A149)","v":6}]
["T","Acct 7464",11534.378379106869,{"$f":"COUNTIF(A$2:A150,A150)","v":7}]
["T","Acct 2776",10598.165394744552,{"$f":"COUNTIF(A$2:A151,A151)","v":8}]
["U","Acct 6175",94460.225887369714,{"$f":"COUNTIF(A$2:A152,A152)","v":1}]
["U","Acct 3099",69380.535860821517,{"$f":"COUNTIF(A$2:A153,A153)","v":2}]
["U","Acct 3368",50397.749597289985,{"$f":"COUNTIF(A$2:A154,A154)","v":3}]
["U","Acct 4996",27407.916767624385,{"$f":"COUNTIF(A$2:A155,A155)","v":4}]
["U","Acct 5124",20942.261918338823,{"$f":"COUNTIF(A$2:A156,A156)","v":5}]
["U","Acct 1799",19966.876355848693,{"$f":"COUNTIF(A$2:A157,A157)","v":6}]
["V","Acct 2893",90009.426074220391,{"$f":"COUNTIF(A$2:A158,A158)","v":1}]
["V","Acct 6058",89086.219281350044,{"$f":"COUNTIF(A$2:A159,A159)","v":2}]
["V","Acct 8919",80698.698876596623,{"$f":"COUNTIF(A$2:A160,A160)","v":3}]
["V","Acct 3637",77526.661323302294,{"$f":"COUNTIF(A$2:A161,A161)","v":4}]
["V","Acct 7968",76227.680486931786,{"$f":"COUNTIF(A$2:A162,A162)","v":5}]
["V","Acct 6752",72064.545259473292,{"$f":"COUNTIF(A$2:A163,A163)","v":6}]
["V","Acct 5203",69539.252716050803,{"$f":"COUNTIF(A$2:A164,A164)","v":7}]
["V","Acct 4579",51261.581782236441,{"$f":"COUNTIF(A$2:A165,A165)","v":8}]
["V","Acct 2607",44606.242804784924,{"$f":"COUNTIF(A$2:A166,A166)","v":9}]
["V","Acct 6361",35569.629642003863,{"$f":"COUNTIF(A$2:A167,A167)","v":10}]
["W","Acct 5113",84485.285822197315,{"$f":"COUNTIF(A$2:A168,A168)","v":1}]
["W","Acct 3607",84196.837223824099,{"$f":"COUNTIF(A$2:A169,A169)","v":2}]
["W","Acct 5655",83233.555443191712,{"$f":"COUNTIF(A$2:A170,A170)","v":3}]
["W","Acct 5177",60065.297803779948,{"$f":"COUNTIF(A$2:A171,A171)","v":4}]
["W","Acct 7776",56415.591684292442,{"$f":"COUNTIF(A$2:A172,A172)","v":5}]
["W","Acct 8156",28647.069512270285,{"$f":"COUNTIF(A$2:A173,A173)","v":6}]
["W","Acct 4708",22122.262555228601,{"$f":"COUNTIF(A$2:A174,A174)","v":7}]
["W","Acct 1970",17766.844024179351,{"$f":"COUNTIF(A$2:A175,A175)","v":8}]
["W","Acct 8513",13218.842175105949,{"$f":"COUNTIF(A$2:A176,A176)","v":9}]
["X","Acct 1468",96875.666033515285,{"$f":"COUNTIF(A$2:A177,A177)","v":1}]
["X","Acct 8421",91985.651518750223,{"$f":"COUNTIF(A$2:A178,A178)","v":2}]
["X","Acct 5176",67364.968983625469,{"$f":"COUNTIF(A$2:A179,A179)","v":3}]
["X","Acct 5243",39771.947012448916,{"$f":"COUNTIF(A$2:A180,A180)","v":4}]
["Y","Acct 6120",67790.265221296489,{"$f":"COUNTIF(A$2:A181,A181)","v":1}]
["Y","Acct 8634",54469.545793770703,{"$f":"COUNTIF(A$2:A182,A182)","v":2}]
["Y","Acct 2377",36832.298898686,{"$f":"COUNTIF(A$2:A183,A183)","v":3}]
["Y","Acct 2318",23587.42117057553,{"$f":"COUNTIF(A$2:A184,A184)","v":4}]
["Y","Acct 5888",6870.4628633050379,{"$f":"COUNTIF(A$2:A185,A185)","v":5}]
["Z","Acct 7408",99579.82654280118,{"$f":"COUNTIF(A$2:A186,A186)","v":1}]
["Z","Acct 2468",82730.192313480526,{"$f":"COUNTIF(A$2:A187,A187)","v":2}]
["Z","Acct 6122",80274.179806068685,{"$f":"COUNTIF(A$2:A188,A188)","v":3}]
["Z","Acct 1782",35550.520792141171,{"$f":"COUNTIF(A$2:A189,A189)","v":4}]
["Z","Acct 8453",24668.664993029066,{"$f":"COUNTIF(A$2:A190,A190)","v":5}]
["Z","Acct 8259",17226.994831884102,{"$f":"COUNTIF(A$2:A191,A191)","v":6}]
["Z","Acct 2300",15073.748208474048,{"$f":"COUNTIF(A$2:A192,A192)","v":7}]
["Z","Acct 4734",14909.96885258835,{"$f":"COUNTIF(A$2:A193,A193)","v":8}]
["Z","Acct 2666",12675.218539484102,{"$f":"COUNTIF(A$2:A194,A194)","v":9}]

{"sheet":"Bill","index":4,"n_rows":56,"n_cols":3,"rows_kept":56,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Industry","Customer","Sum of Amount"]
["A","Acct 1119",57571.432058516744]
["A","Acct 8375",59948.701198641109]
["B","Acct 2516",99568.567525250037]
["B","Acct 3743",81646.665885651004]
["C","Acct 4308",45239.218902719978]
["C","Acct 5600",25193.714664525236]
["D","Acct 2337",98475.307688900779]
["D","Acct 8136",97846.31589242247]
["E","Acct 3149",72092.199651957693]
["E","Acct 7662",65470.184284119059]
["F","Acct 3626",83709.062277228455]
["F","Acct 7853",67756.829240491483]
["G","Acct 3463",78194.091269626821]
["G","Acct 4572",98032.383611700527]
["H","Acct 3609",89821.418741519999]
["H","Acct 7000",95458.07830050755]
["I","Acct 2335",96986.478946464005]
["I","Acct 7761",94931.171086085713]
["J","Acct 4394",88084.334500708588]
["J","Acct 6172",93547.891564467995]
["K","Acct 6510",70681.601631156314]
["K","Acct 7565",84888.3557188181]
["L","Acct 8210",72573.353135136334]
["L","Acct 8898",98419.82694628532]
["M","Acct 1839",93012.868685983034]
["M","Acct 8666",89585.223662240242]
["N","Acct 1881",68036.179783628075]
["N","Acct 7568",75958.520399238434]
["O","Acct 2274",98826.453609775665]
["O","Acct 4857",80257.656503568927]
["P","Acct 7506",98371.957216768133]
["P","Acct 8246",85292.137879763279]
["Q","Acct 1289",44824.408958438311]
["Q","Acct 3599",83535.147175419741]
["R","Acct 4164",88970.843076139776]
["R","Acct 7397",85708.50929882683]
["S","Acct 2814",76834.025919695297]
["S","Acct 4150",56289.341835275176]
["T","Acct 2211",77993.273405303655]
["T","Acct 7416",52875.38074087417]
["U","Acct 3099",69380.535860821517]
["U","Acct 6175",94460.225887369714]
["V","Acct 2893",90009.426074220391]
["V","Acct 6058",89086.219281350044]
["W","Acct 3607",84196.837223824099]
["W","Acct 5113",84485.285822197315]
["X","Acct 1468",96875.666033515285]
["X","Acct 8421",91985.651518750223]
["Y","Acct 6120",67790.265221296489]
["Y","Acct 8634",54469.545793770703]
["Z","Acct 2468",82730.192313480526]
["Z","Acct 7408",99579.82654280118]
["Grand Total",null,4177558.7904472379]