{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Data","Mike","Bill 1","Bill 2","PowerPivotPivotBill&Mike"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":3},"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":100,"n_cols":4,"rows_kept":100,"cut":false,"hidden":false,"merged":[]}
["Region","Market","Invoice","Revenue"]
["Central","Dallas",1001,224.03]
["West","Portland",1002,56.19]
["Central","Chicago",1003,114.99]
["East","Boston",1004,317.27]
["East","Boston",1005,167.72]
["Central","Milwaukee",1006,28.45]
["East","New York",1007,213.33]
["West","San Francisco",1008,332.41]
["East","Miami",1009,136.56]
["West","Seattle",1010,334.5]
["West","San Francisco",1011,303.20999999999998]
["East","Miami",1012,200.32]
["Central","Milwaukee",1013,58.52]
["Central","Milwaukee",1014,145.63]
["West","San Francisco",1015,224.82]
["Central","Chicago",1016,369.5]
["East","Baltimore",1017,103.43]
["West","Seattle",1018,155.35]
["East","Boston",1019,68.22]
["Central","Milwaukee",1020,43.01]
["Central","Dallas",1021,156.32]
["East","Baltimore",1022,321.8]
["East","Boston",1023,135.58000000000001]
["East","Baltimore",1024,295.66000000000003]
["West","San Francisco",1025,293.75]
["West","Laguna Beach",1026,256.49]
["East","Baltimore",1027,345.55]
["West","Seattle",1028,267.25]
["East","Baltimore",1029,310.51]
["Central","Milwaukee",1030,199.23]
["Central","Milwaukee",1031,306.27]
["East","Boston",1032,354.82]
["West","Seattle",1033,221.16]
["East","Miami",1034,161.49]
["West","Seattle",1035,113.86]
["Central","Dallas",1036,364.16]
["West","San Francisco",1037,159.41999999999999]
["East","Boston",1038,274.31]
["West","Portland",1039,97.75]
["Central","Dallas",1040,279.01]
["East","New York",1041,60.65]
["East","Miami",1042,27.45]
["Central","Milwaukee",1043,346.48]
["East","Boston",1044,127.84]
["Central","Dallas",1045,244.57]
["West","San Francisco",1046,69.180000000000007]
["East","Miami",1047,318.69]
["East","Miami",1048,341.08]
["East","Boston",1049,271.54000000000002]
["West","Laguna Beach",1050,226.8]
["West","Portland",1051,352.62]
["Central","Milwaukee",1052,54.63]
["East","Boston",1053,62.34]
["West","Portland",1054,370.27]
["East","Baltimore",1055,43]
["Central","Milwaukee",1056,367.18]
["Central","Chicago",1057,289.11]
["East","Boston",1058,105.04]
["West","San Francisco",1059,137.82]
["West","Seattle",1060,127.61]
["Central","Milwaukee",1061,243.8]
["East","Baltimore",1062,254.2]
["East","Miami",1063,102.12]
["Central","Milwaukee",1064,57.8]
["East","Miami",1065,256.85000000000002]
["East","Boston",1066,218.87]
["Central","Milwaukee",1067,275.33999999999997]
["Central","Chicago",1068,327.72]
["West","Seattle",1069,219.93]
["West","San Francisco",1070,67.430000000000007]
["West","Seattle",1071,101.14]
["Central","Milwaukee",1072,154.65]
["Central","Chicago",1073,82.87]
["Central","Milwaukee",1074,134.46]
["West","San Francisco",1075,30.48]
["East","New York",1076,310.82]
["East","Boston",1077,102.94]
["East","Baltimore",1078,345.17]
["Central","Milwaukee",1079,351]
["Central","Dallas",1080,143.91]
["Central","Milwaukee",1081,85.18]
["Central","Milwaukee",1082,252.1]
["East","Baltimore",1083,142]
["Central","Milwaukee",1084,371.29]
["Central","Milwaukee",1085,323.92]
["West","Portland",1086,230.09]
["East","Boston",1087,225.65]
["East","Miami",1088,166.66]
["West","Seattle",1089,324.58999999999997]
["Central","Milwaukee",1090,330.19]
["West","San Francisco",1091,299.91000000000003]
["West","Seattle",1092,357.92]
["West","San Francisco",1093,95.07]
["East","New York",1094,315.64]
["West","Seattle",1095,171.03]
["Central","Milwaukee",1096,267.19]
["West","Laguna Beach",1097,322.95999999999998]
["East","Boston",1098,220.46]
["Central","Milwaukee",1099,138.21]

{"sheet":"Mike","index":1,"n_rows":100,"n_cols":8,"rows_kept":100,"cut":false,"hidden":false,"merged":[]}
["Region","Market","Invoice","Revenue","% Of Parent",null,"Row Labels","Sum of % Of Parent"]
["Central","Dallas",1001,224.03,{"$f":"D2/SUMIF($A$2:$A$100,A2,$D$2:$D$100)","v":3.1417584760024229E-2},null,"Central",1]
["West","Portland",1002,56.19,{"$f":"D3/SUMIF($A$2:$A$100,A3,$D$2:$D$100)","v":8.889402168324366E-3},null,"Chicago",0.16606878407790518]
["Central","Chicago",1003,114.99,1.6126001301411359E-2,null,"Dallas",0.19801646958511904]
["East","Boston",1004,317.27,4.2726628761659023E-2,null,"Milwaukee",0.63591474633697576]
["East","Boston",1005,167.72,2.2586787833408298E-2,null,"East",1]
["Central","Milwaukee",1006,28.45,3.9897794332129149E-3,null,"Baltimore",0.29106413236407125]
["East","New York",1007,213.33,2.8729068975083431E-2,null,"Boston",0.35722462083769885]
["West","San Francisco",1008,332.41,5.2588114874047028E-2,null,"Miami",0.23044933863752057]
["East","Miami",1009,136.56,1.8390482628966358E-2,null,"New York",0.12126190816070934]
["West","Seattle",1010,334.5,5.2918758236421073E-2,null,"West",1]
["West","San Francisco",1011,303.20999999999998,4.7968599954754061E-2,null,"Laguna Beach",0.12755081861917636]
["East","Miami",1012,200.32,2.6977017283498394E-2,null,"Portland",0.17511758405697825]
["Central","Milwaukee",1013,58.52,8.20674490093567E-3,null,"San Francisco",0.31854086609576637]
["Central","Milwaukee",1014,145.63,2.0422902596091277E-2,null,"Seattle",0.37879073122807905]
["West","San Francisco",1015,224.82,3.5567100827241217E-2,null,"Grand Total",2.9999999999999996]
["Central","Chicago",1016,369.5,5.1818049229250339E-2]
["East","Baltimore",1017,103.43,1.3928878282908541E-2]
["West","Seattle",1018,155.35,2.4576768586032926E-2]
["East","Boston",1019,68.22,9.1871611375811714E-3]
["Central","Milwaukee",1020,43.01,6.0316489779433206E-3]
["Central","Dallas",1021,156.32,2.19220499472704E-2]
["East","Baltimore",1022,321.8,4.3336682117760497E-2]
["East","Boston",1023,135.58000000000001,1.8258506406233589E-2]
["East","Baltimore",1024,295.66000000000003,3.9816418380786422E-2]
["West","San Francisco",1025,293.75,4.6472003682955731E-2]
["West","Laguna Beach",1026,256.49,4.0577376083885328E-2]
["East","Baltimore",1027,345.55,4.6535085474804665E-2]
["West","Seattle",1028,267.25,4.2279635691131634E-2]
["East","Baltimore",1029,310.51,4.1816262164032975E-2]
["Central","Milwaukee",1030,199.23,2.7939675095922989E-2]
["Central","Milwaukee",1031,306.27,4.2950781968721249E-2]
["East","Boston",1032,354.82,4.7783472806164635E-2]
["West","Seattle",1033,221.16,3.4988079436672301E-2]
["East","Miami",1034,161.49,2.1747796131749979E-2]
["West","Seattle",1035,113.86,1.8012944133927962E-2]
["Central","Dallas",1036,364.16,5.1069176745125316E-2]
["West","San Francisco",1037,159.41999999999999,2.5220653028550814E-2]
["East","Boston",1038,274.31,3.6941222099822507E-2]
["West","Portland",1039,97.75,1.5464300800030374E-2]
["Central","Dallas",1040,279.01,3.9127886104068033E-2]
["East","New York",1041,60.65,8.1677121517780421E-3]
["East","Miami",1042,27.45,3.696680932667886E-3]
["Central","Milwaukee",1043,346.48,4.8589763726524113E-2]
["East","Boston",1044,127.84,1.7216163585874775E-2]
["Central","Dallas",1045,244.57,3.4298079296340336E-2]
["West","San Francisco",1046,69.180000000000007,1.0944453497146817E-2]
["East","Miami",1047,318.69,4.2917859615006507E-2]
["East","Miami",1048,341.08,4.5933112295605191E-2]
["East","Boston",1049,271.54000000000002,3.6568187266179886E-2]
["West","Laguna Beach",1050,226.8,3.5880341907385052E-2]
["West","Portland",1051,352.62,5.5785388727434382E-2]
["Central","Milwaukee",1052,54.63,7.6612179415262412E-3]
["East","Boston",1053,62.34,8.3953038011845543E-3]
["West","Portland",1054,370.27,5.8577664012554952E-2]
["East","Baltimore",1055,43,5.7907934464378544E-3]
["Central","Milwaukee",1056,367.18,5.1492696389705384E-2]
["Central","Chicago",1057,289.11,4.0544292862431844E-2]
["East","Boston",1058,105.04,1.4145696363112378E-2]
["West","San Francisco",1059,137.82,2.1803477608799859E-2]
["West","Seattle",1060,127.61,2.0188229412704616E-2]
["Central","Milwaukee",1061,243.8,3.4190095810801714E-2]
["East","Baltimore",1062,254.2,3.423301614150006E-2]
["East","Miami",1063,102.12,1.3752461087214736E-2]
["Central","Milwaukee",1064,57.8,8.1057733300424067E-3]
["East","Miami",1065,256.85000000000002,3.4589890621338673E-2]
["East","Boston",1066,218.87,{"$f":"D67/SUMIF($A$2:$A$100,A67,$D$2:$D$100)","v":2.9475138642368677E-2}]
["Central","Milwaukee",1067,275.33999999999997,3.8613211569098208E-2]
["Central","Chicago",1068,327.72,4.5958893351583013E-2]
["West","Seattle",1069,219.93,3.4793490280825373E-2]
["West","San Francisco",1070,67.430000000000007,1.0667599007120698E-2]
["West","Seattle",1071,101.14,1.6000607497852398E-2]
["Central","Milwaukee",1072,154.65,2.1687851998115196E-2]
["Central","Chicago",1073,82.87,1.1621547333228623E-2]
["Central","Milwaukee",1074,134.46,1.8856440864316648E-2]
["West","San Francisco",1075,30.48,4.8220142034263508E-3]
["East","New York",1076,310.82,4.1858009744693343E-2]
["East","Boston",1077,102.94,1.3862890171542155E-2]
["East","Baltimore",1078,345.17,4.6483911021091957E-2]
["Central","Milwaukee",1079,351,4.9223640810465139E-2]
["Central","Dallas",1080,143.91,2.0181692732290708E-2]
["Central","Milwaukee",1081,85.18,1.1945497789844505E-2]
["Central","Milwaukee",1082,252.1,3.5354073641932368E-2]
["East","Baltimore",1083,142,1.9123085334748262E-2]
["Central","Milwaukee",1084,371.29,5.2069075773554421E-2]
["Central","Milwaukee",1085,323.92,4.5425987838535242E-2]
["West","Portland",1086,230.09,3.6400828348634159E-2]
["East","Boston",1087,225.65,3.0388198632295391E-2]
["East","Miami",1088,166.66,2.2444038041472856E-2]
["West","Seattle",1089,324.58999999999997,5.135097081004459E-2]
["Central","Milwaukee",1090,330.19,4.6305281935064058E-2]
["West","San Francisco",1091,299.91000000000003,4.7446531487847672E-2]
["West","Seattle",1092,357.92,5.6623862325799197E-2]
["West","San Francisco",1093,95.07,1.5040317923876088E-2]
["East","New York",1094,315.64,4.2507117289154517E-2]
["West","Seattle",1095,171.03,2.7057384816666957E-2]
["Central","Milwaukee",1096,267.19,3.7470269481903649E-2]
["West","Laguna Beach",1097,322.95999999999998,5.109310062790598E-2]
["East","Boston",1098,220.46,2.9689263330271845E-2]
["Central","Milwaukee",1099,138.21,1.9382334462719052E-2]

{"sheet":"Bill 1","index":2,"n_rows":100,"n_cols":8,"rows_kept":100,"cut":false,"hidden":false,"merged":[]}
["Region","Market","Invoice","Revenue"]
["Central","Dallas",1001,224.03,null,"Row Labels","Sum of Revenue","Sum of Revenue2"]
["West","Portland",1002,56.19,null,"East",7425.58,0.35567704843200587]
["Central","Chicago",1003,114.99,null,"Baltimore",2161.3200000000002,0.29106413236407125]
["East","Boston",1004,317.27,null,"Boston",2652.6,0.35722462083769885]
["East","Boston",1005,167.72,null,"Miami",1711.22,0.23044933863752057]
["Central","Milwaukee",1006,28.45,null,"New York",900.43999999999994,0.12126190816070932]
["East","New York",1007,213.33,null,"Central",7130.7199999999993,0.34155358137614472]
["West","San Francisco",1008,332.41,null,"Chicago",1184.19,0.16606878407790521]
["East","Miami",1009,136.56,null,"Dallas",1412,0.19801646958511906]
["West","Seattle",1010,334.5,null,"Milwaukee",4534.53,0.63591474633697587]
["West","San Francisco",1011,303.20999999999998,null,"West",6321.01,0.30276937019184946]
["East","Miami",1012,200.32,null,"Laguna Beach",806.25,0.12755081861917636]
["Central","Milwaukee",1013,58.52,null,"Portland",1106.9199999999998,0.17511758405697819]
["Central","Milwaukee",1014,145.63,null,"San Francisco",2013.5000000000002,0.31854086609576637]
["West","San Francisco",1015,224.82,null,"Seattle",2394.34,0.37879073122807905]
["Central","Chicago",1016,369.5,null,"Grand Total",20877.309999999998,1]
["East","Baltimore",1017,103.43]
["West","Seattle",1018,155.35]
["East","Boston",1019,68.22]
["Central","Milwaukee",1020,43.01]
["Central","Dallas",1021,156.32]
["East","Baltimore",1022,321.8]
["East","Boston",1023,135.58000000000001]
["East","Baltimore",1024,295.66000000000003]
["West","San Francisco",1025,293.75]
["West","Laguna Beach",1026,256.49]
["East","Baltimore",1027,345.55]
["West","Seattle",1028,267.25]
["East","Baltimore",1029,310.51]
["Central","Milwaukee",1030,199.23]
["Central","Milwaukee",1031,306.27]
["East","Boston",1032,354.82]
["West","Seattle",1033,221.16]
["East","Miami",1034,161.49]
["West","Seattle",1035,113.86]
["Central","Dallas",1036,364.16]
["West","San Francisco",1037,159.41999999999999]
["East","Boston",1038,274.31]
["West","Portland",1039,97.75]
["Central","Dallas",1040,279.01]
["East","New York",1041,60.65]
["East","Miami",1042,27.45]
["Central","Milwaukee",1043,346.48]
["East","Boston",1044,127.84]
["Central","Dallas",1045,244.57]
["West","San Francisco",1046,69.180000000000007]
["East","Miami",1047,318.69]
["East","Miami",1048,341.08]
["East","Boston",1049,271.54000000000002]
["West","Laguna Beach",1050,226.8]
["West","Portland",1051,352.62]
["Central","Milwaukee",1052,54.63]
["East","Boston",1053,62.34]
["West","Portland",1054,370.27]
["East","Baltimore",1055,43]
["Central","Milwaukee",1056,367.18]
["Central","Chicago",1057,289.11]
["East","Boston",1058,105.04]
["West","San Francisco",1059,137.82]
["West","Seattle",1060,127.61]
["Central","Milwaukee",1061,243.8]
["East","Baltimore",1062,254.2]
["East","Miami",1063,102.12]
["Central","Milwaukee",1064,57.8]
["East","Miami",1065,256.85000000000002]
["East","Boston",1066,218.87]
["Central","Milwaukee",1067,275.33999999999997]
["Central","Chicago",1068,327.72]
["West","Seattle",1069,219.93]
["West","San Francisco",1070,67.430000000000007]
["West","Seattle",1071,101.14]
["Central","Milwaukee",1072,154.65]
["Central","Chicago",1073,82.87]
["Central","Milwaukee",1074,134.46]
["West","San Francisco",1075,30.48]
["East","New York",1076,310.82]
["East","Boston",1077,102.94]
["East","Baltimore",1078,345.17]
["Central","Milwaukee",1079,351]
["Central","Dallas",1080,143.91]
["Central","Milwaukee",1081,85.18]
["Central","Milwaukee",1082,252.1]
["East","Baltimore",1083,142]
["Central","Milwaukee",1084,371.29]
["Central","Milwaukee",1085,323.92]
["West","Portland",1086,230.09]
["East","Boston",1087,225.65]
["East","Miami",1088,166.66]
["West","Seattle",1089,324.58999999999997]
["Central","Milwaukee",1090,330.19]
["West","San Francisco",1091,299.91000000000003]
["West","Seattle",1092,357.92]
["West","San Francisco",1093,95.07]
["East","New York",1094,315.64]
["West","Seattle",1095,171.03]
["Central","Milwaukee",1096,267.19]
["West","Laguna Beach",1097,322.95999999999998]
["East","Boston",1098,220.46]
["Central","Milwaukee",1099,138.21]

{"sheet":"Bill 2","index":3,"n_rows":100,"n_cols":4,"rows_kept":100,"cut":false,"hidden":false,"merged":[]}
["Region","Market","Invoice","Revenue"]
["Central","Dallas",1001,224.03]
["West","Portland",1002,56.19]
["Central","Chicago",1003,114.99]
["East","Boston",1004,317.27]
["East","Boston",1005,167.72]
["Central","Milwaukee",1006,28.45]
["East","New York",1007,213.33]
["West","San Francisco",1008,332.41]
["East","Miami",1009,136.56]
["West","Seattle",1010,334.5]
["West","San Francisco",1011,303.20999999999998]
["East","Miami",1012,200.32]
["Central","Milwaukee",1013,58.52]
["Central","Milwaukee",1014,145.63]
["West","San Francisco",1015,224.82]
["Central","Chicago",1016,369.5]
["East","Baltimore",1017,103.43]
["West","Seattle",1018,155.35]
["East","Boston",1019,68.22]
["Central","Milwaukee",1020,43.01]
["Central","Dallas",1021,156.32]
["East","Baltimore",1022,321.8]
["East","Boston",1023,135.58000000000001]
["East","Baltimore",1024,295.66000000000003]
["West","San Francisco",1025,293.75]
["West","Laguna Beach",1026,256.49]
["East","Baltimore",1027,345.55]
["West","Seattle",1028,267.25]
["East","Baltimore",1029,310.51]
["Central","Milwaukee",1030,199.23]
["Central","Milwaukee",1031,306.27]
["East","Boston",1032,354.82]
["West","Seattle",1033,221.16]
["East","Miami",1034,161.49]
["West","Seattle",1035,113.86]
["Central","Dallas",1036,364.16]
["West","San Francisco",1037,159.41999999999999]
["East","Boston",1038,274.31]
["West","Portland",1039,97.75]
["Central","Dallas",1040,279.01]
["East","New York",1041,60.65]
["East","Miami",1042,27.45]
["Central","Milwaukee",1043,346.48]
["East","Boston",1044,127.84]
["Central","Dallas",1045,244.57]
["West","San Francisco",1046,69.180000000000007]
["East","Miami",1047,318.69]
["East","Miami",1048,341.08]
["East","Boston",1049,271.54000000000002]
["West","Laguna Beach",1050,226.8]
["West","Portland",1051,352.62]
["Central","Milwaukee",1052,54.63]
["East","Boston",1053,62.34]
["West","Portland",1054,370.27]
["East","Baltimore",1055,43]
["Central","Milwaukee",1056,367.18]
["Central","Chicago",1057,289.11]
["East","Boston",1058,105.04]
["West","San Francisco",1059,137.82]
["West","Seattle",1060,127.61]
["Central","Milwaukee",1061,243.8]
["East","Baltimore",1062,254.2]
["East","Miami",1063,102.12]
["Central","Milwaukee",1064,57.8]
["East","Miami",1065,256.85000000000002]
["East","Boston",1066,218.87]
["Central","Milwaukee",1067,275.33999999999997]
["Central","Chicago",1068,327.72]
["West","Seattle",1069,219.93]
["West","San Francisco",1070,67.430000000000007]
["West","Seattle",1071,101.14]
["Central","Milwaukee",1072,154.65]
["Central","Chicago",1073,82.87]
["Central","Milwaukee",1074,134.46]
["West","San Francisco",1075,30.48]
["East","New York",1076,310.82]
["East","Boston",1077,102.94]
["East","Baltimore",1078,345.17]
["Central","Milwaukee",1079,351]
["Central","Dallas",1080,143.91]
["Central","Milwaukee",1081,85.18]
["Central","Milwaukee",1082,252.1]
["East","Baltimore",1083,142]
["Central","Milwaukee",1084,371.29]
["Central","Milwaukee",1085,323.92]
["West","Portland",1086,230.09]
["East","Boston",1087,225.65]
["East","Miami",1088,166.66]
["West","Seattle",1089,324.58999999999997]
["Central","Milwaukee",1090,330.19]
["West","San Francisco",1091,299.91000000000003]
["West","Seattle",1092,357.92]
["West","San Francisco",1093,95.07]
["East","New York",1094,315.64]
["West","Seattle",1095,171.03]
["Central","Milwaukee",1096,267.19]
["West","Laguna Beach",1097,322.95999999999998]
["East","Boston",1098,220.46]
["Central","Milwaukee",1099,138.21]

{"sheet":"PowerPivotPivotBill&Mike","index":4,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Row Labels","Sum of Revenue","RevenueForRegion","PctOfRegion","MikeRevenueForRegion"]
[null,"Central",7130.72,7130.72,1,1]
[null,"Chicago",1184.19,7130.72,0.16606878407790518,0.16606878407790518]
[null,"Dallas",1412,7130.72,0.19801646958511904,0.19801646958511904]
[null,"Milwaukee",4534.53,7130.72,0.63591474633697576,0.63591474633697576]
[null,"East",7425.58,7425.58,1,1]
[null,"Baltimore",2161.3200000000002,7425.58,0.29106413236407125,0.29106413236407125]
[null,"Boston",2652.6,7425.58,0.35722462083769885,0.35722462083769885]
[null,"Miami",1711.22,7425.58,0.23044933863752057,0.23044933863752057]
[null,"New York",900.44,7425.58,0.12126190816070934,0.12126190816070934]
[null,"West",6321.01,6321.01,1,1]
[null,"Laguna Beach",806.25,6321.01,0.12755081861917636,0.12755081861917636]
[null,"Portland",1106.92,6321.01,0.17511758405697825,0.17511758405697825]
[null,"San Francisco",2013.5,6321.01,0.31854086609576632,0.31854086609576632]
[null,"Seattle",2394.34,6321.01,0.37879073122807905,0.37879073122807905]
[null,"Grand Total",20877.310000000001,20877.310000000001,1,1]