{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["B地区集計用","配布エリア地図"],"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":"B地区集計用","index":0,"n_rows":106,"n_cols":29,"rows_kept":106,"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],[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],[105,1,105,3],[105,4,105,6],[104,1,104,3],[104,4,104,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],[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],[58,1,58,3],[58,4,58,6],[57,1,57,3],[57,4,57,6],[56,1,56,3],[56,4,56,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]]}
["■姫路市北部B地区　 料金設定(価格はすべて税別)■"]
[]
["配布エリア",null,null,null,null,"B地区"]
["A4サイズ以下基本価格",null,null,null,null,"8円/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":8},null,null,null,null,"A4サイズ以下",8,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サイズ",10,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}]
["B地区配布指定単価",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M11:P13)","v":8}]
["B地区配布指定枚数",null,null,null,null,null,null,{"$f":"MAX(J22,K22)+MAX(M22,N22)","v":0}]
["B地区配布料（税抜）",null,null,null,null,null,null,{"$f":"+M14*H15","v":0}]
["消費税（10％）",null,null,null,null,null,null,{"$f":"+H16*0.1","v":0}]
["B地区配布料（税込）",null,null,null,null,null,null,{"$f":"SUM(H16:P17)","v":0}]
[]
["姫路市A地区配布合計世帯数",null,null,null,null,null,null,null,"一戸建数",null,{"$f":"SUM(J24:J106)","v":36191},"集合住宅数",null,{"$f":"SUM(M24:M106)","v":21464},"全世帯数",{"$f":"SUM(O24:O106)","v":57655}]
["区番号","町名",null,null,"カタカナ",null,null,"配布ランク","全区選択▼","一戸建数Ⓐ","個別選択枚数","全区選択▼","集合住宅数Ⓑ","個別選択枚数","Ⓐ＋Ⓑ","個別選択枚数"]
[null,null,null,null,null,null,null,null,false,{"$f":"IF(I22=TRUE,SUM(J24:J106), \"\")","v":""},{"$f":"SUM(K24:K106)","v":0},false,{"$f":"IF(L22=TRUE,SUM(M24:M106), \"\")","v":""},{"$f":"SUM(N24:N106)","v":0},{"$f":"IF(OR(I22=TRUE,L22=TRUE),IF(I22=TRUE,J22,0)+IF(L22=TRUE,M22,0),\"\")","v":""},{"$f":"SUM(P24:P106)","v":0}]
[null,null,null,null,null,null,null,null,"▼個別選択Ⓐ",null,null,"▼個別選択Ⓑ",null,null,"Ⓐ＋Ⓑ"]
[141,"花田町高木",null,null,"ハナダチヨウ　タカギ",null,null,"B",null,227,{"$f":"IF(I24=TRUE, J24, \"\")","v":""},null,75,{"$f":"IF(L24=TRUE, M24, \"\")","v":""},{"$f":"+J24+M24","v":302},{"$f":"IF(OR(I24=TRUE,L24=TRUE),IF(I24=TRUE,J24,0)+IF(L24=TRUE,M24,0),\"\")","v":""}]
[142,"花田町小川",null,null,"ハナダチヨウ　オガワ",null,null,"B",null,514,"",null,576,"",1090,{"$f":"IF(OR(I25=TRUE,L25=TRUE),IF(I25=TRUE,J25,0)+IF(L25=TRUE,M25,0),\"\")","v":""}]
[143,"花田町勅旨",null,null,"ハナダチヨウ　チヨウシ",null,null,"B",null,309,"",null,176,"",485,""]
[144,"花田町一本松",null,null,"ハナダチヨウ　イツポンマツ",null,null,"B",null,146,"",null,66,"",212,""]
[145,"花田町加納原田",null,null,"ハナダチヨウ　カノウハラダ",null,null,"B",null,684,"",null,337,"",1021,""]
[146,"花田町上原田",null,null,"ハナダチヨウ　カミハラダ",null,null,"B",null,339,"",null,311,"",650,""]
[147,"御国野町深志野",null,null,"ミクニノチヨウ　フカシノ",null,null,"B",null,817,"",null,123,"",940,""]
[148,"御国野町国分寺",null,null,"ミクニノチヨウ　コクブンジ",null,null,"B",null,825,"",null,477,"",1302,""]
[149,"御国野町御着",null,null,"ミクニノチヨウ　ゴチヤク",null,null,"B",null,814,"",null,498,"",1312,""]
[150,"別所町佐土",null,null,"ベツシヨチヨウ　サヅチ",null,null,"B",null,262,"",null,801,"",1063,""]
[151,"別所町家具町",null,null,"ベツシヨチヨウ　カグマチ",null,null,"B",null,91,"",null,52,"",143,""]
[152,"別所町佐土新",null,null,"ベツシヨチヨウ　サヅチシン",null,null,"B",null,182,"",null,15,"",197,""]
[153,"別所町別所",null,null,"ベツシヨチヨウ　ベツシヨ",null,null,"B",null,422,"",null,679,"",1101,""]
[154,"別所町北宿",null,null,"ベツシヨチヨウ　キタジユク",null,null,"B",null,329,"",null,87,"",416,""]
[155,"別所町小林",null,null,"ベツシヨチヨウ　コバヤシ",null,null,"B",null,346,"",null,210,"",556,""]
[156,"東夢前台",null,null,"ヒガシユメサキダイ　　",null,null,"B",null,181,"",null,346,"",527,""]
[157,"北夢前台",null,null,"キタユメサキダイ　　",null,null,"B",null,159,"",null,16,"",175,""]
[158,"上手野",null,null,"カミテノ",null,null,"B",null,297,"",null,176,"",473,""]
[159,"藤ケ台",null,null,"フジガダイ",null,null,"B",null,115,"",null,3,"",118,""]
[160,"山吹",null,null,"ヤマブキ　　",null,null,"B",null,266,"",null,138,"",404,""]
[161,"田寺",null,null,"タデラ　　",null,null,"B",null,1088,"",null,874,"",1962,""]
[162,"御立西",null,null,"ミタチニシ　　",null,null,"B",null,1001,"",null,301,"",1302,""]
[163,"御立中",null,null,"ミタチナカ　　",null,null,"B",null,1137,"",null,476,"",1613,""]
[164,"御立北",null,null,"ミタチキタ　　",null,null,"B",null,205,"",null,56,"",261,""]
[165,"大寿台",null,null,"ダイジユダイ　　",null,null,"B",null,316,"",null,115,"",431,""]
[166,"西大寿台",null,null,"ニシダイジユダイ",null,null,"B",null,92,"",null,0,"",92,""]
[167,"御立東",null,null,"ミタチヒガシ　　",null,null,"B",null,978,"",null,473,"",1451,""]
[168,"田寺東",null,null,"タデラヒガシ　　",null,null,"B",null,987,"",null,546,"",1533,""]
[169,"田寺山手町",null,null,"タデラヤマテチヨウ",null,null,"B",null,94,"",null,1,"",95,""]
[170,"辻井",null,null,"ツジイ　　",null,null,"B",null,1140,"",null,323,"",1463,""]
[171,"東辻井",null,null,"ヒガシツジイ　　",null,null,"B",null,500,"",null,310,"",810,""]
[172,"新在家",null,null,"シンザイケ　　",null,null,"B",null,226,"",null,251,"",477,""]
[173,"新在家中の町",null,null,"シンザイケナカノチヨウ",null,null,"B",null,154,{"$f":"IF(I56=TRUE, J56, \"\")","v":""},null,51,{"$f":"IF(L56=TRUE, M56, \"\")","v":""},{"$f":"+J56+M56","v":205},""]
[174,"西新在家",null,null,"ニシシンザイケ　　",null,null,"B",null,247,"",null,21,"",268,""]
[175,"新在家本町",null,null,"シンザイケホンチヨウ　　",null,null,"B",null,479,"",null,161,"",640,""]
[176,"北新在家",null,null,"キタシンザイケ　　",null,null,"B",null,331,"",null,79,"",410,""]
[177,"梅ケ谷町",null,null,"ウメガタニチヨウ",null,null,"B",null,386,"",null,120,"",506,""]
[178,"北平野台町",null,null,"キタヒラノダイチヨウ",null,null,"B",null,39,"",null,4,"",43,""]
[179,"上大野",null,null,"カミオオノ　　",null,null,"B",null,604,"",null,293,"",897,""]
[180,"北平野奥垣内",null,null,"キタヒラノオクガイチ",null,null,"B",null,25,"",null,2,"",27,""]
[181,"北平野",null,null,"キタヒラノ　　",null,null,"B",false,954,"",null,551,"",1505,""]
[182,"北平野南の町",null,null,"キタヒラノミナミノチヨウ",null,null,"B",false,342,"",null,145,"",487,""]
[183,"八代緑ケ丘町",null,null,"ヤシロ　ミドリガオカチヨウ",null,null,"B",false,135,"",null,27,"",162,""]
[184,"八代宮前町",null,null,"ヤシロ　ミヤマエチヨウ",null,null,"B",false,147,"",null,53,"",200,""]
[185,"城北本町",null,null,"ジヨウホクホンチヨウ",null,null,"B",false,131,"",null,249,"",380,""]
[186,"北八代",null,null,"キタヤシロ　　",null,null,"B",false,174,"",null,103,"",277,""]
[187,"八代東光寺町",null,null,"ヤシロ　トウコウジチヨウ",null,null,"B",false,162,"",null,126,"",288,""]
[188,"八代",null,null,"ヤシロ",null,null,"B",false,321,"",null,161,"",482,""]
[189,"伊伝居",null,null,"イデイ",null,null,"B",false,669,"",null,516,"",1185,""]
[190,"城北新町",null,null,"ジヨウホクシンマチ　　",null,null,"B",false,483,"",null,411,"",894,""]
[191,"広峰",null,null,"ヒロミネ　　",null,null,"B",false,146,"",null,124,"",270,""]
[192,"峰南町",null,null,"ホウナンチヨウ",null,null,"B",false,0,"",null,0,"",0,""]
[193,"増位本町",null,null,"マスイホンマチ　　",null,null,"B",false,103,"",null,176,"",279,""]
[194,"西中島",null,null,"ニシナカシマ",null,null,"B",false,404,"",null,383,"",787,""]
[195,"増位新町",null,null,"マスイシンマチ　　",null,null,"B",false,22,"",null,1008,"",1030,""]
[196,"保城",null,null,"ホウシロ",null,null,"B",false,803,"",null,734,"",1537,""]
[197,"城見台",null,null,"シロミダイ　　",null,null,"B",false,986,"",null,12,"",998,""]
[199,"白国",null,null,"シラクニ　　",null,null,"B",false,841,"",null,633,"",1474,""]
[214,"飾西",null,null,"シキサイ",null,null,"B",false,635,"",null,183,"",818,""]
[219,"川西台",null,null,"カワニシダイ",null,null,"B",false,145,"",null,6,"",151,""]
[220,"川西",null,null,"カワニシ",null,null,"B",false,96,"",null,20,"",116,""]
[221,"飾西台",null,null,"シキサイダイ",null,null,"B",false,74,"",null,3,"",77,""]
[222,"青山北",null,null,"アオヤマキタ　　",null,null,"B",false,617,"",null,309,"",926,""]
[223,"西夢前台",null,null,"ニシユメサキダイ　　",null,null,"B",false,168,"",null,80,"",248,""]
[224,"青山",null,null,"アオヤマ",null,null,"B",false,1260,{"$f":"IF(I88=TRUE, J88, \"\")","v":""},null,537,{"$f":"IF(L88=TRUE, M88, \"\")","v":""},{"$f":"+J88+M88","v":1797},""]
[225,"青山西",null,null,"アオヤマニシ　　",null,null,"B",false,445,"",null,699,"",1144,{"$f":"IF(OR(I89=TRUE,L89=TRUE),IF(I89=TRUE,J89,0)+IF(L89=TRUE,M89,0),\"\")","v":""}]
[226,"青山南",null,null,"アオヤマミナミ　　",null,null,"B",false,238,"",null,481,"",719,""]
[227,"広畑区西蒲田",null,null,"ヒロハタク　ニシカマダ",null,null,"B",false,1115,"",null,572,"",1687,""]
[228,"広畑区東夢前台",null,null,"ヒロハタク　ヒガシユメサキダイ　　",null,null,"B",false,118,"",null,5,"",123,""]
[229,"広畑区蒲田",null,null,"ヒロハタク　カマダ",null,null,"B",false,1368,"",null,677,"",2045,""]
[230,"広畑区城山町",null,null,"ヒロハタク　シロヤマチヨウ",null,null,"B",false,35,"",null,306,"",341,""]
[231,"広畑区西夢前台",null,null,"ヒロハタク　ニシユメサキダイ　　",null,null,"B",false,442,"",null,439,"",881,""]
[232,"苫編",null,null,"トマミ",null,null,"B",false,452,"",null,168,"",620,""]
[233,"飾磨区富士見ケ丘町",null,null,"シカマク　フジミガオカチヨウ",null,null,"B",false,186,"",null,0,"",186,""]
[234,"飾磨区山崎",null,null,"シカマク　ヤマサキ",null,null,"B",false,402,"",null,306,"",708,""]
[235,"広畑区才",null,null,"ヒロハタク　サイ",null,null,"B",false,1123,"",null,797,"",1920,""]
[236,"広畑区則直",null,null,"ヒロハタク　ノリナオ",null,null,"B",false,617,"",null,181,"",798,""]
[237,"広畑区京見町",null,null,"ヒロハタク　キヨウミチヨウ",null,null,"B",false,279,"",null,0,"",279,""]
[238,"勝原区勝山町",null,null,"カツハラク　カツヤマチヨウ",null,null,"B",false,188,"",null,1,"",189,""]
[239,"勝原区丁",null,null,"カツハラク　ヨロ",null,null,"B",false,626,"",null,136,"",762,""]
[240,"勝原区朝日谷",null,null,"カツハラク　アサヒダニ",null,null,"B",false,571,"",null,183,"",754,""]
[241,"勝原区下太田",null,null,"カツハラク　シモオオタ",null,null,"B",false,345,"",null,184,"",529,""]
[242,"勝原区大谷",null,null,"カツハラク　オオタニ",null,null,"B",false,469,"",null,160,"",629,""]

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