{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["C地区集計用","配布エリア地図"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":0,"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":"C地区集計用","index":0,"n_rows":56,"n_cols":29,"rows_kept":56,"cut":false,"hidden":false,"merged":[[3,0,3,4],[4,0,4,4],[4,5,4,15],[13,0,13,6],[8,0,8,4],[8,5,8,15],[12,7,12,11],[13,7,13,11],[5,0,5,4],[5,5,5,15],[6,0,6,4],[6,5,6,15],[7,0,7,4],[7,5,7,15],[12,0,12,6],[54,1,54,3],[54,4,54,6],[53,1,53,3],[53,4,53,6],[52,1,52,3],[52,4,52,6],[51,1,51,3],[51,4,51,6],[55,1,55,3],[55,4,55,6],[46,1,46,3],[46,4,46,6],[45,1,45,3],[45,4,45,6],[44,1,44,3],[44,4,44,6],[43,1,43,3],[43,4,43,6],[50,1,50,3],[50,4,50,6],[49,1,49,3],[49,4,49,6],[48,1,48,3],[48,4,48,6],[47,1,47,3],[47,4,47,6],[38,1,38,3],[38,4,38,6],[37,1,37,3],[37,4,37,6],[36,1,36,3],[36,4,36,6],[35,1,35,3],[35,4,35,6],[42,1,42,3],[42,4,42,6],[41,1,41,3],[41,4,41,6],[40,1,40,3],[40,4,40,6],[39,1,39,3],[39,4,39,6],[30,1,30,3],[30,4,30,6],[29,1,29,3],[29,4,29,6],[28,1,28,3],[28,4,28,6],[27,1,27,3],[27,4,27,6],[34,1,34,3],[34,4,34,6],[33,1,33,3],[33,4,33,6],[32,1,32,3],[32,4,32,6],[31,1,31,3],[31,4,31,6],[22,8,22,10],[22,11,22,13],[20,0,22,0],[20,1,22,3],[20,4,22,6],[20,7,22,7],[19,0,19,7],[26,1,26,3],[26,4,26,6],[25,1,25,3],[25,4,25,6],[24,1,24,3],[24,4,24,6],[23,1,23,3],[23,4,23,6],[22,14,22,15],[0,0,1,15],[2,0,2,4],[19,8,19,9],[19,11,19,12],[15,0,15,6],[14,0,14,6],[9,7,9,11],[16,0,16,6],[15,7,15,15],[16,7,16,15],[10,12,10,15],[11,12,11,15],[12,12,12,15],[13,12,13,15],[14,7,14,15],[10,7,10,11],[11,7,11,11],[2,5,2,15],[3,5,3,15],[17,0,17,6],[17,7,17,15],[10,0,10,6],[11,0,11,6]]}
["■姫路市北部C地区　 料金設定(価格はすべて税別)■"]
[]
["配布エリア",null,null,null,null,"C地区"]
["A4サイズ以下基本価格",null,null,null,null,"20円/1枚"]
["一戸建てのみ配布",null,null,null,null,"規定価格に＋3円"]
["B4/A3",null,null,null,null,"上記価格に＋2円"]
["その他の変形サイズ",null,null,null,null,"応相談"]
["配布期間",null,null,null,null,"配布期間は要相談"]
["その他加工済チラシ",null,null,null,null,"折り加工済の場合は上記価格＋1円"]
[null,null,null,null,null,null,null,"▼ご選択ください"]
["配布サイズ",null,null,null,null,null,null,"A4サイズ以下",null,null,null,null,{"$f":"_xlfn.XLOOKUP(H11,R:R,S:S,\"\")","v":20},null,null,null,null,"A4サイズ以下",20,null,null,null,"一戸建てのみ",3,null,null,null,"有り",1]
["一戸建てのみ配布指定",null,null,null,null,null,null,"指定なし",null,null,null,null,{"$f":"_xlfn.XLOOKUP(H12,W:W,X:X,\"\")","v":0},null,null,null,null,"B4/A3サイズ",22,null,null,null,"指定なし",0,null,null,null,"無し",0]
["折り加工有無",null,null,null,null,null,null,"無し",null,null,null,null,{"$f":"_xlfn.XLOOKUP(H13,AB:AB,AC:AC,\"\")","v":0}]
["C地区配布指定単価",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M11:P13)","v":20}]
["C地区配布指定枚数",null,null,null,null,null,null,{"$f":"MAX(J22,K22)+MAX(M22,N22)","v":0}]
["C地区配布料（税抜）",null,null,null,null,null,null,{"$f":"+M14*H15","v":0}]
["消費税（10％）",null,null,null,null,null,null,{"$f":"+H16*0.1","v":0}]
["C地区配布料（税込）",null,null,null,null,null,null,{"$f":"SUM(H16:P17)","v":0}]
[]
["姫路市A地区配布合計世帯数",null,null,null,null,null,null,null,"一戸建数",null,{"$f":"SUM(J24:J56)","v":9917},"集合住宅数",null,{"$f":"SUM(M24:M56)","v":3590},"全世帯数",{"$f":"SUM(O24:O56)","v":13507}]
["区番号","町名",null,null,"カタカナ",null,null,"配布ランク","全区選択▼","一戸建数Ⓐ","個別選択枚数","全区選択▼","集合住宅数Ⓑ","個別選択枚数","Ⓐ＋Ⓑ","個別選択枚数"]
[null,null,null,null,null,null,null,null,false,{"$f":"IF(I22=TRUE,SUM(J24:J56), \"\")","v":""},{"$f":"SUM(K24:K56)","v":0},false,{"$f":"IF(L22=TRUE,SUM(M24:M56), \"\")","v":""},{"$f":"SUM(N24:N56)","v":0},{"$f":"IF(OR(I22=TRUE,L22=TRUE),IF(I22=TRUE,J22,0)+IF(L22=TRUE,M22,0),\"\")","v":""},{"$f":"SUM(P24:P56)","v":0}]
[null,null,null,null,null,null,null,null,"▼個別選択Ⓐ",null,null,"▼個別選択Ⓑ",null,null,"Ⓐ＋Ⓑ"]
[201,"砥堀",null,null,"トホリ",null,null,"C",null,1001,{"$f":"IF(I24=TRUE, J24, \"\")","v":""},null,785,{"$f":"IF(L24=TRUE, M24, \"\")","v":""},{"$f":"+J24+M24","v":1786},{"$f":"IF(OR(I24=TRUE,L24=TRUE),IF(I24=TRUE,J24,0)+IF(L24=TRUE,M24,0),\"\")","v":""}]
[202,"仁豊野",null,null,"ニブノ",null,null,"C",null,639,"",null,205,"",844,{"$f":"IF(OR(I25=TRUE,L25=TRUE),IF(I25=TRUE,J25,0)+IF(L25=TRUE,M25,0),\"\")","v":""}]
[203,"書写",null,null,"シヨシヤ",null,null,"C",null,2374,"",null,1343,"",3717,""]
[204,"刀出",null,null,"カタナデ",null,null,"C",null,178,"",null,8,"",186,""]
[205,"緑台",null,null,"ミドリダイ　　",null,null,"C",null,596,"",null,8,"",604,""]
[206,"打越",null,null,"ウチコシ",null,null,"C",null,213,"",null,4,"",217,""]
[207,"六角",null,null,"ロツカク",null,null,"C",null,108,"",null,10,"",118,""]
[208,"菅生台",null,null,"スゴウダイ",null,null,"C",null,186,"",null,192,"",378,""]
[209,"白鳥台",null,null,"ハクチヨウダイ　　",null,null,"C",null,977,"",null,25,"",1002,""]
[210,"石倉",null,null,"イシクラ",null,null,"C",null,109,"",null,0,"",109,""]
[211,"西脇",null,null,"ニシワキ",null,null,"C",null,241,"",null,5,"",246,""]
[212,"相野",null,null,"アイノ",null,null,"C",null,129,"",null,2,"",131,""]
[213,"太市中",null,null,"オオイチナカ",null,null,"C",null,124,"",null,6,"",130,""]
[215,"実法寺",null,null,"ジホウジ",null,null,"C",null,177,"",null,110,"",287,""]
[216,"書写台",null,null,"シヨシヤダイ　　",null,null,"C",null,205,"",null,366,"",571,""]
[217,"町田",null,null,"チヨウダ",null,null,"C",null,182,"",null,31,"",213,""]
[218,"田井台",null,null,"タイダイ",null,null,"C",null,68,"",null,22,"",90,""]
[344,"飾東町佐良和",null,null,"シキトウチヨウ　サロオ",null,null,"C",null,552,"",null,206,"",758,""]
[345,"飾東町庄",null,null,"シキトウチヨウ　シヨウ",null,null,"C",null,469,"",null,204,"",673,""]
[346,"飾東町豊国",null,null,"シキトウチヨウ　トヨクニ",null,null,"C",null,353,"",null,22,"",375,""]
[347,"飾東町山崎",null,null,"シキトウチヨウ　ヤマサキ",null,null,"C",null,203,"",null,0,"",203,""]
[348,"飾東町塩崎",null,null,"シキトウチヨウ　シオザキ",null,null,"C",null,111,"",null,6,"",117,""]
[349,"飾東町北山",null,null,"シキトウチヨウ　キタヤマ",null,null,"C",null,76,"",null,1,"",77,""]
[350,"飾東町志吹",null,null,"シキトウチヨウ　シブキ",null,null,"C",null,79,"",null,0,"",79,""]
[351,"飾東町夕陽ケ丘",null,null,"シキトウチヨウ　ユウヒガオカ",null,null,"C",null,90,"",null,23,"",113,""]
[352,"飾東町唐端新",null,null,"シキトウチヨウ　カラハタシン",null,null,"C",null,43,"",null,1,"",44,""]
[353,"飾東町清住",null,null,"シキトウチヨウ　キヨスミ",null,null,"C",null,59,"",null,1,"",60,""]
[354,"飾東町大釜",null,null,"シキトウチヨウ　オオガマ",null,null,"C",null,38,"",null,0,"",38,""]
[355,"飾東町大釜新",null,null,"シキトウチヨウ　オオガマシン",null,null,"C",null,26,"",null,0,"",26,""]
[356,"飾東町八重畑",null,null,"シキトウチヨウ　ヤエバタ",null,null,"C",null,185,"",null,2,"",187,""]
[357,"飾東町北野",null,null,"シキトウチヨウ　キタノ",null,null,"C",null,49,"",null,1,"",50,""]
[358,"飾東町小原",null,null,"シキトウチヨウ　オハラ",null,null,"C",null,51,"",null,1,"",52,""]
[359,"飾東町小原新",null,null,"シキトウチヨウ　オハラシン",null,null,"C",null,26,{"$f":"IF(I56=TRUE, J56, \"\")","v":""},null,0,{"$f":"IF(L56=TRUE, M56, \"\")","v":""},{"$f":"+J56+M56","v":26},""]

{"sheet":"配布エリア地図","index":1,"n_rows":3,"n_cols":7,"rows_kept":3,"cut":false,"hidden":false,"merged":[[2,0,2,1],[2,2,2,3],[2,4,2,5],[2,6,2,7],[1,0,1,7]]}
[]
["姫路市北部配布可能エリア"]
["A地区",null,"B地区",null,"C地区",null,"D地区"]