{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["D地区集計用","配布エリア地図"],"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":"D地区集計用","index":0,"n_rows":104,"n_cols":29,"rows_kept":104,"cut":false,"hidden":false,"merged":[[56,1,56,3],[56,4,56,6],[57,1,57,3],[57,4,57,6],[58,1,58,3],[58,4,58,6],[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],[54,1,54,3],[54,4,54,6],[53,1,53,3],[53,4,53,6],[102,1,102,3],[102,4,102,6],[101,1,101,3],[101,4,101,6],[100,1,100,3],[100,4,100,6],[99,1,99,3],[99,4,99,6],[103,1,103,3],[103,4,103,6],[94,1,94,3],[94,4,94,6],[93,1,93,3],[93,4,93,6],[92,1,92,3],[92,4,92,6],[91,1,91,3],[91,4,91,6],[98,1,98,3],[98,4,98,6],[97,1,97,3],[97,4,97,6],[96,1,96,3],[96,4,96,6],[95,1,95,3],[95,4,95,6],[86,1,86,3],[86,4,86,6],[85,1,85,3],[85,4,85,6],[84,1,84,3],[84,4,84,6],[83,1,83,3],[83,4,83,6],[90,1,90,3],[90,4,90,6],[89,1,89,3],[89,4,89,6],[88,1,88,3],[88,4,88,6],[87,1,87,3],[87,4,87,6],[78,1,78,3],[78,4,78,6],[77,1,77,3],[77,4,77,6],[76,1,76,3],[76,4,76,6],[75,1,75,3],[75,4,75,6],[82,1,82,3],[82,4,82,6],[81,1,81,3],[81,4,81,6],[80,1,80,3],[80,4,80,6],[79,1,79,3],[79,4,79,6],[70,1,70,3],[70,4,70,6],[69,1,69,3],[69,4,69,6],[68,1,68,3],[68,4,68,6],[67,1,67,3],[67,4,67,6],[74,1,74,3],[74,4,74,6],[73,1,73,3],[73,4,73,6],[72,1,72,3],[72,4,72,6],[71,1,71,3],[71,4,71,6],[62,1,62,3],[62,4,62,6],[61,1,61,3],[61,4,61,6],[60,1,60,3],[60,4,60,6],[59,1,59,3],[59,4,59,6],[66,1,66,3],[66,4,66,6],[65,1,65,3],[65,4,65,6],[64,1,64,3],[64,4,64,6],[63,1,63,3],[63,4,63,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],[12,0,12,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]]}
["■姫路市北部D地区　 料金設定(価格はすべて税別)■"]
[]
["配布エリア",null,null,null,null,"D地区"]
["A4サイズ以下基本価格",null,null,null,null,"50円/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":50},null,null,null,null,"A4サイズ以下",50,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サイズ",52,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}]
["D地区配布指定単価",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M11:P13)","v":50}]
["D地区配布指定枚数",null,null,null,null,null,null,{"$f":"MAX(J22,K22)+MAX(M22,N22)","v":0}]
["D地区配布料（税抜）",null,null,null,null,null,null,{"$f":"+M14*H15","v":0}]
["消費税（10％）",null,null,null,null,null,null,{"$f":"+H16*0.1","v":0}]
["D地区配布料（税込）",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":3418},"集合住宅数",null,{"$f":"SUM(M24:M56)","v":402},"全世帯数",{"$f":"SUM(O24:O56)","v":3820}]
["区番号","町名",null,null,"カタカナ",null,null,"配布ランク","全区選択▼","一戸建数Ⓐ","個別選択枚数","全区選択▼","集合住宅数Ⓑ","個別選択枚数","Ⓐ＋Ⓑ","個別選択枚数"]
[null,null,null,null,null,null,null,null,false,{"$f":"IF(I22=TRUE,SUM(J24:J104), \"\")","v":""},{"$f":"SUM(K24:K56)","v":0},false,{"$f":"IF(L22=TRUE,SUM(M24:M104), \"\")","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,"Ⓐ＋Ⓑ"]
[243,"安富町関",null,null,"ヤストミチヨウセキ",null,null,"D",null,17,{"$f":"IF(I24=TRUE, J24, \"\")","v":""},null,0,{"$f":"IF(L24=TRUE, M24, \"\")","v":""},{"$f":"+J24+M24","v":17},{"$f":"IF(OR(I24=TRUE,L24=TRUE),IF(I24=TRUE,J24,0)+IF(L24=TRUE,M24,0),\"\")","v":""}]
[244,"安富町皆河",null,null,"ヤストミチヨウミナゴ",null,null,"D",null,82,"",null,0,"",82,{"$f":"IF(OR(I25=TRUE,L25=TRUE),IF(I25=TRUE,J25,0)+IF(L25=TRUE,M25,0),\"\")","v":""}]
[245,"安富町杤原",null,null,"ヤストミチヨウトチワラ",null,null,"D",null,68,"",null,0,"",68,""]
[246,"安富町末広",null,null,"ヤストミチヨウスエヒロ",null,null,"D",null,80,"",null,1,"",81,""]
[247,"安富町名坂",null,null,"ヤストミチヨウナサカ",null,null,"D",null,145,"",null,2,"",147,""]
[248,"安富町三森",null,null,"ヤストミチヨウミツモリ",null,null,"D",null,69,"",null,3,"",72,""]
[249,"安富町安志",null,null,"ヤストミチヨウアンジ",null,null,"D",null,551,"",null,63,"",614,""]
[250,"安富町長野",null,null,"ヤストミチヨウナガノ",null,null,"D",null,100,"",null,204,"",304,""]
[251,"安富町塩野",null,null,"ヤストミチヨウシオノ",null,null,"D",null,113,"",null,21,"",134,""]
[252,"安富町植木野",null,null,"ヤストミチヨウウエキノ",null,null,"D",null,106,"",null,7,"",113,""]
[253,"安富町狭戸",null,null,"ヤストミチヨウセバト",null,null,"D",null,96,"",null,3,"",99,""]
[254,"安富町瀬川",null,null,"ヤストミチヨウセガワ",null,null,"D",null,34,"",null,0,"",34,""]
[255,"安富町三坂",null,null,"ヤストミチヨウミサカ",null,null,"D",null,36,"",null,0,"",36,""]
[256,"林田町松山",null,null,"ハヤシダチヨウ　マツヤマ",null,null,"D",null,89,"",null,0,"",89,""]
[257,"林田町山田",null,null,"ハヤシダチヨウ　ヤマダ",null,null,"D",null,60,"",null,0,"",60,""]
[258,"林田町奥佐見",null,null,"ハヤシダチヨウ　オクサミ",null,null,"D",null,70,"",null,1,"",71,""]
[259,"林田町大堤",null,null,"ハヤシダチヨウ　オオヅツミ",null,null,"D",null,40,"",null,0,"",40,""]
[260,"林田町上伊勢",null,null,"ハヤシダチヨウ　カミイセ",null,null,"D",null,125,"",null,0,"",125,""]
[261,"林田町下伊勢",null,null,"ハヤシダチヨウ　シモイセ",null,null,"D",null,145,"",null,0,"",145,""]
[262,"林田町林谷",null,null,"ハヤシダチヨウ　ハヤシダニ",null,null,"D",null,161,"",null,15,"",176,""]
[263,"林田町口佐見",null,null,"ハヤシダチヨウ　クチサミ",null,null,"D",null,67,"",null,1,"",68,""]
[264,"林田町八幡",null,null,"ハヤシダチヨウ　ヤハタ",null,null,"D",null,70,"",null,1,"",71,""]
[265,"林田町中山下",null,null,"ハヤシダチヨウ　ナカヤマシタ",null,null,"D",null,23,"",null,0,"",23,""]
[266,"林田町六九谷",null,null,"ハヤシダチヨウ　ムクダニ",null,null,"D",null,180,"",null,10,"",190,""]
[267,"林田町上構",null,null,"ハヤシダチヨウ　カミカマエ",null,null,"D",null,70,"",null,1,"",71,""]
[268,"林田町林田",null,null,"ハヤシダチヨウ　ハヤシダ",null,null,"D",null,43,"",null,2,"",45,""]
[269,"林田町新町",null,null,"ハヤシダチヨウ　シンマチ",null,null,"D",null,76,"",null,0,"",76,""]
[270,"林田町久保",null,null,"ハヤシダチヨウ　クボ",null,null,"D",null,53,"",null,2,"",55,""]
[271,"林田町下構",null,null,"ハヤシダチヨウ　シモカマエ",null,null,"D",null,102,"",null,51,"",153,""]
[272,"林田町中構",null,null,"ハヤシダチヨウ　ナカカマエ",null,null,"D",null,62,"",null,0,"",62,""]
[273,"夢前町山之内",null,null,"ユメサキチヨウヤマノウチ",null,null,"D",null,215,"",null,3,"",218,""]
[274,"夢前町莇野",null,null,"ユメサキチヨウアゾノ",null,null,"D",null,166,"",null,11,"",177,""]
[275,"夢前町神種",null,null,"ユメサキチヨウコノクサ",null,null,"D",null,104,{"$f":"IF(I56=TRUE, J56, \"\")","v":""},null,0,{"$f":"IF(L56=TRUE, M56, \"\")","v":""},{"$f":"+J56+M56","v":104},""]
[276,"夢前町新庄",null,null,"ユメサキチヨウシンジヨウ",null,null,"D",null,228,{"$f":"IF(I57=TRUE, J57, \"\")","v":""},null,1,{"$f":"IF(L57=TRUE, M57, \"\")","v":""},{"$f":"+J57+M57","v":229},{"$f":"IF(OR(I57=TRUE,L57=TRUE),IF(I57=TRUE,J57,0)+IF(L57=TRUE,M57,0),\"\")","v":""}]
[277,"夢前町前之庄",null,null,"ユメサキチヨウマエノシヨウ",null,null,"D",null,1245,"",null,132,"",1377,""]
[278,"夢前町高長",null,null,"ユメサキチヨウコウチヨウ",null,null,"D",null,23,"",null,0,"",23,""]
[279,"夢前町戸倉",null,null,"ユメサキチヨウトクラ",null,null,"D",null,83,"",null,3,"",86,""]
[280,"夢前町野畑",null,null,"ユメサキチヨウノハタケ",null,null,"D",null,73,"",null,1,"",74,""]
[281,"夢前町護持",null,null,"ユメサキチヨウゴジ",null,null,"D",null,441,"",null,23,"",464,""]
[282,"夢前町古瀬畑",null,null,"ユメサキチヨウコセバタ",null,null,"D",null,54,"",null,3,"",57,""]
[283,"夢前町芦田",null,null,"ユメサキチヨウアシダ",null,null,"D",false,63,"",null,0,"",63,""]
[284,"夢前町寺",null,null,"ユメサキチヨウテラ",null,null,"D",false,553,"",null,55,"",608,""]
[285,"夢前町古知之庄",null,null,"ユメサキチヨウコチノシヨウ",null,null,"D",false,164,"",null,1,"",165,""]
[286,"夢前町杉之内",null,null,"ユメサキチヨウスギノウチ",null,null,"D",false,148,"",null,2,"",150,""]
[287,"夢前町塩田",null,null,"ユメサキチヨウシオタ",null,null,"D",false,102,"",null,1,"",103,""]
[288,"夢前町糸田",null,null,"ユメサキチヨウイトダ",null,null,"D",false,176,"",null,1,"",177,""]
[289,"夢前町又坂",null,null,"ユメサキチヨウマタサカ",null,null,"D",false,57,"",null,1,"",58,""]
[290,"夢前町塚本",null,null,"ユメサキチヨウツカモト",null,null,"D",false,38,"",null,27,"",65,""]
[291,"夢前町菅生澗",null,null,"ユメサキチヨウスゴウダニ",null,null,"D",false,1021,"",null,46,"",1067,""]
[292,"夢前町宮置",null,null,"ユメサキチヨウミヤオキ",null,null,"D",false,309,"",null,3,"",312,""]
[293,"夢前町置本",null,null,"ユメサキチヨウオキモト",null,null,"D",false,321,"",null,144,"",465,""]
[294,"夢前町山冨",null,null,"ユメサキチヨウヤマトミ",null,null,"D",false,143,"",null,23,"",166,""]
[295,"夢前町玉田",null,null,"ユメサキチヨウタマダ",null,null,"D",false,39,"",null,0,"",39,""]
[296,"香寺町久畑",null,null,"コウデラチヨウクハタ",null,null,"D",false,49,"",null,1,"",50,""]
[297,"香寺町中村",null,null,"コウデラチヨウナカムラ",null,null,"D",false,68,"",null,0,"",68,""]
[298,"香寺町恒屋",null,null,"コウデラチヨウツネヤ",null,null,"D",false,276,"",null,1,"",277,""]
[299,"香寺町中寺",null,null,"コウデラチヨウナカデラ",null,null,"D",false,495,"",null,20,"",515,""]
[300,"香寺町土師",null,null,"コウデラチヨウハゼ",null,null,"D",false,442,"",null,2,"",444,""]
[301,"香寺町溝口",null,null,"コウデラチヨウミゾグチ",null,null,"D",false,700,"",null,283,"",983,""]
[302,"香寺町野田",null,null,"コウデラチヨウノダ",null,null,"D",false,74,"",null,34,"",108,""]
[303,"香寺町行重",null,null,"コウデラチヨウユキシゲ",null,null,"D",false,78,"",null,0,"",78,""]
[304,"香寺町矢田部",null,null,"コウデラチヨウヤタベ",null,null,"D",false,80,"",null,0,"",80,""]
[305,"香寺町相坂",null,null,"コウデラチヨウアイサカ",null,null,"D",false,171,"",null,8,"",179,""]
[306,"香寺町香呂",null,null,"コウデラチヨウコウロ",null,null,"D",false,550,"",null,346,"",896,""]
[307,"香寺町岩部",null,null,"コウデラチヨウイワベ",null,null,"D",false,170,"",null,17,"",187,""]
[308,"香寺町広瀬",null,null,"コウデラチヨウヒロセ",null,null,"D",false,304,"",null,114,"",418,""]
[309,"香寺町中仁野",null,null,"コウデラチヨウナカニノ",null,null,"D",false,391,"",null,185,"",576,""]
[310,"香寺町中屋",null,null,"コウデラチヨウナカヤ",null,null,"D",false,147,"",null,74,"",221,""]
[311,"香寺町田野",null,null,"コウデラチヨウタノ",null,null,"D",false,549,"",null,9,"",558,""]
[312,"香寺町須加院",null,null,"コウデラチヨウスカイン",null,null,"D",false,956,"",null,19,"",975,""]
[313,"香寺町犬飼",null,null,"コウデラチヨウイヌカイ",null,null,"D",false,317,"",null,58,"",375,""]
[314,"船津町",null,null,"フナツチヨウ",null,null,"D",false,1326,"",null,34,"",1360,""]
[315,"山田町多田",null,null,"ヤマダチヨウ　タダ",null,null,"D",false,222,"",null,13,"",235,""]
[316,"山田町北山田",null,null,"ヤマダチヨウ　キタヤマダ",null,null,"D",false,109,"",null,1,"",110,""]
[317,"山田町南山田",null,null,"ヤマダチヨウ　ミナミヤマダ",null,null,"D",false,208,"",null,18,"",226,""]
[318,"山田町西山田",null,null,"ヤマダチヨウ　ニシヤマダ",null,null,"D",false,169,"",null,0,"",169,""]
[319,"山田町牧野",null,null,"ヤマダチヨウ　マキノ",null,null,"D",false,117,"",null,3,"",120,""]
[340,"豊富町甲丘",null,null,"トヨトミチヨウ　カブトオカ　　",null,null,"D",false,180,"",null,570,"",750,""]
[341,"豊富町豊富",null,null,"トヨトミチヨウ　トヨトミ",null,null,"D",false,763,"",null,26,"",789,""]
[342,"豊富町神谷",null,null,"トヨトミチヨウ　コダニ",null,null,"D",false,271,"",null,1,"",272,""]
[343,"豊富町御蔭",null,null,"トヨトミチヨウ　ミカゲ",null,null,"D",false,940,"",null,46,"",986,""]

{"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地区"]