{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet2"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":2,"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":"Sheet2","index":0,"n_rows":68,"n_cols":8,"rows_kept":68,"cut":false,"hidden":false,"merged":[[2,4,4,4],[2,7,12,17],[0,3,1,3],[0,0,0,2],[2,3,4,3]]}
[null,null,null,"формула делить  124 OTHERS на два. Хотя  124 OTHERS не имеет подразделов."]
[null,null,null,null,"формула правильна."]
["Area name","Mother tongue name","Total","Всего население в Area","% по родным языкам",null,null,"Дан список териитории штата Индии. Численность носителей родного языка. У каждого языка есть свой подязык. Поэтому в сумме территория дает почти в два раза выше чем на самом деле. Почти употребляется так как 124 OTHERS не повторяется. Надо посчитать процент каждого родного языка по территориям.  Для этого надо посчитать сумму каждого Area name."]
[null,null,"Population"]
[null,null,"1"]
[]
["CHHATTISGARH","1 ASSAMESE",1595,{"$f":"SUMIF(A:A,A7,G:G)","v":249633},{"$f":"C7/D7*100","v":0.63893796092664024},null,{"$f":"C7*a","v":1595}]
["CHHATTISGARH"," Assamese",1582,{"$f":"SUMIF(A:A,A8,G:G)","v":249633},0.63373031610404074,null,{"$f":"C8*a","v":0}]
["CHHATTISGARH","1 Others",13,{"$f":"SUMIF(A:A,A9,G:G)","v":249633},5.2076448225995761E-3,null,{"$f":"C9*a","v":0}]
["CHHATTISGARH","2 BENGALI ",243597,249633,97.582050450060692,null,{"$f":"C10*a","v":243597}]
["CHHATTISGARH"," Bengali",243570,249633,97.571234572352211,null,{"$f":"C11*a","v":0}]
["CHHATTISGARH"," Chakma",7,249633,2.8041164429382331E-3,null,{"$f":"C12*a","v":0}]
["CHHATTISGARH"," Haijong/Hajong",4,249633,1.6023522531075618E-3,null,{"$f":"C13*a","v":0}]
["CHHATTISGARH"," Rajbangsi",1,249633,4.0058806327689046E-4,null,{"$f":"C14*a","v":0}]
["CHHATTISGARH","2 Others",15,249633,6.0088209491533564E-3,null,{"$f":"C15*a","v":0}]
["CHHATTISGARH","3 BODO ",88,249633,3.525174956836636E-2,null,{"$f":"C16*a","v":88}]
["CHHATTISGARH"," Bodo/Boro",87,249633,3.4851161505089476E-2,null,{"$f":"C17*a","v":0}]
["CHHATTISGARH","124 OTHERS",4353,249633,{"$f":"C18/D18*100","v":1.7437598394443043},null,{"$f":"C18*a","v":4353}]
["Koriya","1 ASSAMESE",8,{"$f":"SUMIF(A:A,A19,G:G)","v":628303},1.273271017327627E-3,null,{"$f":"C19*a","v":8}]
["Koriya"," Assamese",8,{"$f":"SUMIF(A:A,A20,G:G)","v":628303},1.273271017327627E-3,null,{"$f":"C20*a","v":0}]
["Koriya","2 BENGALI ",6112,628303,0.97277905723830693,null,{"$f":"C21*a","v":6112}]
["Koriya"," Bengali",6112,628303,0.97277905723830693,null,{"$f":"C22*a","v":0}]
["Koriya","4 DOGRI ",15,628303,2.3873831574893005E-3,null,{"$f":"C23*a","v":15}]
["Koriya"," Dogri",15,628303,2.3873831574893005E-3,null,{"$f":"C24*a","v":0}]
["Koriya","5 GUJARATI",637,628303,0.1013842047547123,null,{"$f":"C25*a","v":637}]
["Koriya"," Gujarati",366,628303,5.8252149042738934E-2,null,{"$f":"C26*a","v":0}]
["Koriya","5 Others",271,628303,4.3132055711973365E-2,null,{"$f":"C27*a","v":0}]
["Koriya","6 HINDI ",621319,628303,98.888434401872985,null,{"$f":"C28*a","v":621319}]
["Koriya"," Awadhi",245,628303,3.8993924905658575E-2,null,{"$f":"C29*a","v":0}]
["Koriya"," Bagheli/Baghel Khandi",30218,628303,4.8094629502007793,null,{"$f":"C30*a","v":0}]
["Koriya"," Banjari",29,628303,4.615607437812648E-3,null,{"$f":"C31*a","v":0}]
["Koriya"," Bhagoria",20752,628303,3.3028650189478639,null,{"$f":"C32*a","v":0}]
["Koriya"," Bharmauri/Gaddi",1,628303,1.5915887716595338E-4,null,{"$f":"C33*a","v":0}]
["Koriya"," Bhojpuri",8240,628303,1.3114691478474558,null,{"$f":"C34*a","v":0}]
["Koriya"," Brajbhasha",121,628303,1.9258224137080358E-2,null,{"$f":"C35*a","v":0}]
["Koriya"," Bundeli/Bundel khandi",682,628303,0.10854635422718019,null,{"$f":"C36*a","v":0}]
["Koriya"," Chhattisgarhi",27364,628303,4.3552235147691478,null,{"$f":"C37*a","v":0}]
["Koriya"," Garhwali",18,628303,2.8648597889871603E-3,null,{"$f":"C38*a","v":0}]
["Koriya","22 Others",1,628303,{"$f":"C39/D39*100","v":1.5915887716595338E-4},null,{"$f":"C39*a","v":0}]
["Koriya","26 ANGAMI ",3,628303,4.7747663149786009E-4,null,{"$f":"C40*a","v":3}]
["Koriya"," Lushai/Mizo",1,628303,{"$f":"C41/D41*100","v":1.5915887716595338E-4},null,{"$f":"C41*a","v":0}]
["Koriya","91 MUNDA",12,628303,1.9099065259914404E-3,null,{"$f":"C42*a","v":12}]
["Koriya"," Munda",11,628303,1.7507476488254872E-3,null,{"$f":"C43*a","v":0}]
["Koriya","91 Others ",1,628303,1.5915887716595338E-4,null,{"$f":"C44*a","v":0}]
["Koriya","92 MUNDARI ",12,628303,1.9099065259914404E-3,null,{"$f":"C45*a","v":12}]
["Koriya"," Mundari",12,628303,1.9099065259914404E-3,null,{"$f":"C46*a","v":0}]
["Koriya","124 OTHERS",185,628303,2.9444392275701371E-2,null,{"$f":"C47*a","v":185}]
["Bharatpur","2 BENGALI ",37,88330,4.1888373146156462E-2,null,{"$f":"C48*a","v":37}]
["Bharatpur"," Bengali",37,88330,4.1888373146156462E-2,null,{"$f":"C49*a","v":0}]
["Bharatpur","5 GUJARATI",7,88330,7.9248273519755465E-3,null,{"$f":"C50*a","v":7}]
["Bharatpur"," Gujarati",3,88330,3.3963545794180915E-3,null,{"$f":"C51*a","v":0}]
["Bharatpur","5 Others",4,88330,4.528472772557455E-3,null,{"$f":"C52*a","v":0}]
["Bharatpur","6 HINDI ",88286,88330,99.950186799501878,null,{"$f":"C53*a","v":88286}]
["Bharatpur"," Awadhi",1,88330,1.1321181931393638E-3,null,{"$f":"C54*a","v":0}]
["Bharatpur"," Bagheli/Baghel Khandi",25451,88330,28.813540133589949,null,{"$f":"C55*a","v":0}]
["Bharatpur"," Banjari",1,88330,1.1321181931393638E-3,null,{"$f":"C56*a","v":0}]
["Bharatpur"," Bhagoria",20737,88330,23.476734971130988,null,{"$f":"C57*a","v":0}]
["Bharatpur"," Bhojpuri",205,88330,0.23208422959356956,null,{"$f":"C58*a","v":0}]
["Baikunthpur"," Koda/Kora",13,7498,{"$f":"C59/D59*100","v":0.17337956788476927},null,{"$f":"C59*a","v":0}]
["Baikunthpur","68 KORWA ",198,7498,2.6407041877834088,null,{"$f":"C60*a","v":198}]
["Baikunthpur"," Koraku",198,7498,2.6407041877834088,null,{"$f":"C61*a","v":0}]
["Baikunthpur","72 KURUKH/ORAON ",7266,7498,96.90584155774873,null,{"$f":"C62*a","v":7266}]
["Baikunthpur"," Kurukh/Oraon",7266,7498,96.90584155774873,null,{"$f":"C63*a","v":0}]
["Baikunthpur","91 MUNDA",6,7498,8.0021339023739674E-2,null,{"$f":"C64*a","v":6}]
["Baikunthpur"," Munda",6,7498,8.0021339023739674E-2,null,{"$f":"C65*a","v":0}]
["Baikunthpur","92 MUNDARI ",9,7498,0.1200320085356095,null,{"$f":"C66*a","v":9}]
["Baikunthpur"," Mundari",9,7498,0.1200320085356095,null,{"$f":"C67*a","v":0}]
["Baikunthpur","124 OTHERS",19,7498,0.25340090690850897,null,{"$f":"C68*a","v":19}]