{"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],[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"]
[null,null,null,null,null,"Формула","Проверка"]
["CHHATTISGARH","1 ASSAMESE",1595,{"$f":"SUMIF(A:A,A7:A7,C:C)/2","v":247456},{"$f":"C7/D7*100","v":0.64455903271692749},{"$f":"SUMPRODUCT(Жир)","v":249633},{"$f":"C7+C10+C16+C18","v":249633}]
["CHHATTISGARH"," Assamese",1582,{"$f":"SUMIF(A:A,A8:A8,C:C)/2-IF(B8=\"124 OTHERS\",C8,0)/2","v":247456},0.63930557351609985,{"$f":"SUMPRODUCT(Жир)","v":249633}]
["CHHATTISGARH","1 Others",13,247456,5.2534592008276221E-3,{"$f":"SUMPRODUCT(Жир)","v":249633}]
["CHHATTISGARH","2 BENGALI ",243597,247456,98.440530841846623,{"$f":"SUMPRODUCT(Жир)","v":249633}]
["CHHATTISGARH"," Bengali",243570,247456,98.429619811198748,{"$f":"SUMPRODUCT(Жир)","v":249633}]
["CHHATTISGARH"," Chakma",7,247456,2.8287857235225655E-3,{"$f":"SUMPRODUCT(Жир)","v":249633}]
["CHHATTISGARH"," Haijong/Hajong",4,247456,1.6164489848700377E-3,{"$f":"SUMPRODUCT(Жир)","v":249633}]
["CHHATTISGARH"," Rajbangsi",1,247456,4.0411224621750942E-4,{"$f":"SUMPRODUCT(Жир)","v":249633}]
["CHHATTISGARH","2 Others",15,247456,6.06168369326264E-3,{"$f":"SUMPRODUCT(Жир)","v":249633}]
["CHHATTISGARH","3 BODO ",88,247456,3.5561877667140827E-2,{"$f":"SUMPRODUCT(Жир)","v":249633}]
["CHHATTISGARH"," Bodo/Boro",87,247456,3.5157765420923318E-2,{"$f":"SUMPRODUCT(Жир)","v":249633}]
["CHHATTISGARH","124 OTHERS",4353,245279.5,{"$f":"C18/D18*100","v":1.7747100756483929},{"$f":"SUMPRODUCT(Жир)","v":249633}]
["Koriya","1 ASSAMESE",8,361385.5,2.2137025420223004E-3,{"$f":"SUMPRODUCT(Жир)","v":628303},{"$f":"C19+C21+C23+C25+C28+C40+C42+C45+C47","v":628303}]
["Koriya"," Assamese",8,361385.5,2.2137025420223004E-3,{"$f":"SUMPRODUCT(Жир)","v":628303}]
["Koriya","2 BENGALI ",6112,361385.5,1.6912687421050374,{"$f":"SUMPRODUCT(Жир)","v":628303}]
["Koriya"," Bengali",6112,361385.5,1.6912687421050374,{"$f":"SUMPRODUCT(Жир)","v":628303}]
["Koriya","4 DOGRI ",15,361385.5,4.1506922662918133E-3,{"$f":"SUMPRODUCT(Жир)","v":628303}]
["Koriya"," Dogri",15,361385.5,4.1506922662918133E-3,{"$f":"SUMPRODUCT(Жир)","v":628303}]
["Koriya","5 GUJARATI",637,361385.5,0.17626606490852564,{"$f":"SUMPRODUCT(Жир)","v":628303}]
["Koriya"," Gujarati",366,361385.5,0.10127689129752024,{"$f":"SUMPRODUCT(Жир)","v":628303}]
["Koriya","5 Others",271,361385.5,7.4989173611005419E-2,{"$f":"SUMPRODUCT(Жир)","v":628303}]
["Koriya","6 HINDI ",621319,361385.5,171.9269312133442,{"$f":"SUMPRODUCT(Жир)","v":628303}]
["Koriya"," Awadhi",245,361385.5,6.7794640349432944E-2,{"$f":"SUMPRODUCT(Жир)","v":628303}]
["Koriya"," Bagheli/Baghel Khandi",30218,361385.5,8.3617079268537342,{"$f":"SUMPRODUCT(Жир)","v":628303}]
["Koriya"," Banjari",29,361385.5,8.0246717148308375E-3,{"$f":"SUMPRODUCT(Жир)","v":628303}]
["Koriya"," Bhagoria",20752,361385.5,5.7423443940058467,{"$f":"SUMPRODUCT(Жир)","v":628303}]
["Koriya"," Bharmauri/Gaddi",1,361385.5,2.7671281775278755E-4,{"$f":"SUMPRODUCT(Жир)","v":628303}]
["Koriya"," Bhojpuri",8240,361385.5,2.2801136182829693,{"$f":"SUMPRODUCT(Жир)","v":628303}]
["Koriya"," Brajbhasha",121,361385.5,3.3482250948087294E-2,{"$f":"SUMPRODUCT(Жир)","v":628303}]
["Koriya"," Bundeli/Bundel khandi",682,361385.5,0.18871814170740109,{"$f":"SUMPRODUCT(Жир)","v":628303}]
["Koriya"," Chhattisgarhi",27364,361385.5,7.5719695449872777,{"$f":"SUMPRODUCT(Жир)","v":628303}]
["Koriya"," Garhwali",18,361385.5,4.9808307195501758E-3,{"$f":"SUMPRODUCT(Жир)","v":628303}]
["Koriya","22 Others",1,361385.5,{"$f":"C39/D39*100","v":2.7671281775278755E-4},{"$f":"SUMPRODUCT(Жир)","v":628303}]
["Koriya","26 ANGAMI ",3,{"$f":"SUMIF(A:A,A40:A40,C:C)/2-IF(B40=\"124 OTHERS\",C40,0)/2","v":361385.5},8.301384532583625E-4,{"$f":"SUMPRODUCT(Жир)","v":628303}]
["Koriya"," Lushai/Mizo",1,361385.5,{"$f":"C41/D41*100","v":2.7671281775278755E-4},{"$f":"SUMPRODUCT(Жир)","v":628303}]
["Koriya","91 MUNDA",12,361385.5,3.32055381303345E-3,{"$f":"SUMPRODUCT(Жир)","v":628303}]
["Koriya"," Munda",11,361385.5,3.0438409952806629E-3,{"$f":"SUMPRODUCT(Жир)","v":628303}]
["Koriya","91 Others ",1,361385.5,2.7671281775278755E-4,{"$f":"SUMPRODUCT(Жир)","v":628303}]
["Koriya","92 MUNDARI ",12,361385.5,3.32055381303345E-3,{"$f":"SUMPRODUCT(Жир)","v":628303}]
["Koriya"," Mundari",12,361385.5,3.32055381303345E-3,{"$f":"SUMPRODUCT(Жир)","v":628303}]
["Koriya","124 OTHERS",185,361293,5.1204977677397567E-2,{"$f":"SUMPRODUCT(Жир)","v":628303}]
["Bharatpur","2 BENGALI ",37,67384.5,5.4908769820952892E-2,{"$f":"SUMPRODUCT(Жир)","v":88330},{"$f":"C48+C50+C53","v":88330}]
["Bharatpur"," Bengali",37,67384.5,5.4908769820952892E-2,{"$f":"SUMPRODUCT(Жир)","v":88330}]
["Bharatpur","5 GUJARATI",7,67384.5,1.0388145641801898E-2,{"$f":"SUMPRODUCT(Жир)","v":88330}]
["Bharatpur"," Gujarati",3,67384.5,4.4520624179150989E-3,{"$f":"SUMPRODUCT(Жир)","v":88330}]
["Bharatpur","5 Others",4,67384.5,5.9360832238867988E-3,{"$f":"SUMPRODUCT(Жир)","v":88330}]
["Bharatpur","6 HINDI ",88286,67384.5,131.01826087601748,{"$f":"SUMPRODUCT(Жир)","v":88330}]
["Bharatpur"," Awadhi",1,67384.5,1.4840208059716997E-3,{"$f":"SUMPRODUCT(Жир)","v":88330}]
["Bharatpur"," Bagheli/Baghel Khandi",25451,67384.5,37.769813532785726,{"$f":"SUMPRODUCT(Жир)","v":88330}]
["Bharatpur"," Banjari",1,67384.5,1.4840208059716997E-3,{"$f":"SUMPRODUCT(Жир)","v":88330}]
["Bharatpur"," Bhagoria",20737,67384.5,30.77413945343514,{"$f":"SUMPRODUCT(Жир)","v":88330}]
["Bharatpur"," Bhojpuri",205,67384.5,0.30422426522419843,{"$f":"SUMPRODUCT(Жир)","v":88330}]
["Baikunthpur"," Koda/Kora",13,7495,{"$f":"C59/D59*100","v":0.17344896597731821},{"$f":"SUMPRODUCT(Жир)","v":7498},{"$f":"C60+C62+C64+C66+C68","v":7498}]
["Baikunthpur","68 KORWA ",198,7495,2.6417611741160774,{"$f":"SUMPRODUCT(Жир)","v":7498}]
["Baikunthpur"," Koraku",198,7495,2.6417611741160774,{"$f":"SUMPRODUCT(Жир)","v":7498}]
["Baikunthpur","72 KURUKH/ORAON ",7266,7495,96.944629753168783,{"$f":"SUMPRODUCT(Жир)","v":7498}]
["Baikunthpur"," Kurukh/Oraon",7266,7495,96.944629753168783,{"$f":"SUMPRODUCT(Жир)","v":7498}]
["Baikunthpur","91 MUNDA",6,7495,8.0053368912608405E-2,{"$f":"SUMPRODUCT(Жир)","v":7498}]
["Baikunthpur"," Munda",6,7495,8.0053368912608405E-2,{"$f":"SUMPRODUCT(Жир)","v":7498}]
["Baikunthpur","92 MUNDARI ",9,7495,0.1200800533689126,{"$f":"SUMPRODUCT(Жир)","v":7498}]
["Baikunthpur"," Mundari",9,7495,0.1200800533689126,{"$f":"SUMPRODUCT(Жир)","v":7498}]
["Baikunthpur","124 OTHERS",19,7485.5,0.25382405984904149,{"$f":"SUMPRODUCT(Жир)","v":7498}]