{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["連絡網","一覧表","予算・出欠管理"],"not_rendered":{"charts":2,"images":1,"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"連絡網","index":0,"n_rows":74,"n_cols":13,"rows_kept":74,"merged":[[4,4,4,5],[7,1,7,2],[7,4,7,5],[7,7,7,8],[10,1,10,2],[10,4,10,5],[10,7,10,8],[13,1,13,2],[13,4,13,5],[13,7,13,8],[16,1,16,2],[16,4,16,5],[16,7,16,8],[19,1,19,2],[19,4,19,5],[19,7,19,8],[22,1,22,2],[22,4,22,5],[22,7,22,8],[25,1,25,2],[25,4,25,5],[25,7,25,8],[28,1,28,2],[28,4,28,5],[28,7,28,8],[31,1,31,2],[31,4,31,5],[31,7,31,8],[34,1,34,2],[34,4,34,5],[34,7,34,8],[37,1,37,2],[37,4,37,5],[37,7,37,8],[40,12,40,13],[41,12,41,13],[42,12,42,13],[43,12,43,13],[44,12,44,13],[45,12,45,13],[46,12,46,13],[47,12,47,13],[48,12,48,13],[49,12,49,13],[50,12,50,13],[51,12,51,13],[52,12,52,13],[53,12,53,13],[54,12,54,13],[55,12,55,13],[56,12,56,13],[57,12,57,13],[58,12,58,13],[59,12,59,13],[60,12,60,13],[61,12,61,13],[62,12,62,13],[63,12,63,13],[64,12,64,13],[65,12,65,13],[66,12,66,13],[67,12,67,13],[68,12,68,13],[69,12,69,13],[70,12,70,13],[71,12,71,13],[72,12,72,13],[73,12,73,13]]}
[]
[]
[]
[{"$nulls":4},1,"鈴木 太朗"]
[{"$nulls":4},"03-0000-0000"]
[]
[null,2,"宮内 亮",null,3,"香川 真治",null,4,"本多 慶介"]
[null,"00-0000-0000",null,null,"00-0000-0000",null,null,"00-0000-0000"]
[]
[null,6,"苗字 名前",null,5,"苗字 名前",null,7,"苗字 名前"]
[null,"00-0000-0000",null,null,"00-0000-0000",null,null,"00-0000-0000"]
[]
[null,12,"苗字 名前"]
[null,"06-0000-0000"]
{"$rows_empty":26}
[{"$nulls":10},{"$f":"IF(E4=\"\",\"\",E4)","v":1},{"$f":"IF(F4=\"\",\"\",F4)","v":"鈴木 太朗"},{"$f":"IF(E5=\"\",\"\",E5)","v":"03-0000-0000"}]
[{"$nulls":10},{"$f":"IF(B7=\"\",\"\",B7)","v":2},{"$f":"IF(C7=\"\",\"\",C7)","v":"宮内 亮"},{"$f":"IF(B8=\"\",\"\",B8)","v":"00-0000-0000"}]
[{"$nulls":10},{"$f":"IF(E7=\"\",\"\",E7)","v":3},{"$f":"IF(F7=\"\",\"\",F7)","v":"香川 真治"},{"$f":"IF(E8=\"\",\"\",E8)","v":"00-0000-0000"}]
[{"$nulls":10},{"$f":"IF(H7=\"\",\"\",H7)","v":4},{"$f":"IF(I7=\"\",\"\",I7)","v":"本多 慶介"},{"$f":"IF(H8=\"\",\"\",H8)","v":"00-0000-0000"}]
[{"$nulls":10},{"$f":"IF(B10=\"\",\"\",B10)","v":6},{"$f":"IF(C10=\"\",\"\",C10)","v":"苗字 名前"},{"$f":"IF(B11=\"\",\"\",B11)","v":"00-0000-0000"}]
[{"$nulls":10},{"$f":"IF(E10=\"\",\"\",E10)","v":5},{"$f":"IF(F10=\"\",\"\",F10)","v":"苗字 名前"},{"$f":"IF(E11=\"\",\"\",E11)","v":"00-0000-0000"}]
[{"$nulls":10},{"$f":"IF(H10=\"\",\"\",H10)","v":7},{"$f":"IF(I10=\"\",\"\",I10)","v":"苗字 名前"},{"$f":"IF(H11=\"\",\"\",H11)","v":"00-0000-0000"}]
[{"$nulls":10},{"$f":"IF(B13=\"\",\"\",B13)","v":12},{"$f":"IF(C13=\"\",\"\",C13)","v":"苗字 名前"},{"$f":"IF(B14=\"\",\"\",B14)","v":"06-0000-0000"}]
[{"$nulls":10},{"$f":"IF(E13=\"\",\"\",E13)","v":""},{"$f":"IF(F13=\"\",\"\",F13)","v":""},{"$f":"IF(E14=\"\",\"\",E14)","v":""}]
[{"$nulls":10},{"$f":"IF(H13=\"\",\"\",H13)","v":""},{"$f":"IF(I13=\"\",\"\",I13)","v":""},{"$f":"IF(H14=\"\",\"\",H14)","v":""}]
[{"$nulls":10},{"$f":"IF(B16=\"\",\"\",B16)","v":""},{"$f":"IF(C16=\"\",\"\",C16)","v":""},{"$f":"IF(B17=\"\",\"\",B17)","v":""}]
[{"$nulls":10},{"$f":"IF(E16=\"\",\"\",E16)","v":""},{"$f":"IF(F16=\"\",\"\",F16)","v":""},{"$f":"IF(E17=\"\",\"\",E17)","v":""}]
[{"$nulls":10},{"$f":"IF(H16=\"\",\"\",H16)","v":""},{"$f":"IF(I16=\"\",\"\",I16)","v":""},{"$f":"IF(H17=\"\",\"\",H17)","v":""}]
[{"$nulls":10},{"$f":"IF(B19=\"\",\"\",B19)","v":""},{"$f":"IF(C19=\"\",\"\",C19)","v":""},{"$f":"IF(B20=\"\",\"\",B20)","v":""}]
[{"$nulls":10},{"$f":"IF(E19=\"\",\"\",E19)","v":""},{"$f":"IF(F19=\"\",\"\",F19)","v":""},{"$f":"IF(E20=\"\",\"\",E20)","v":""}]
[{"$nulls":10},{"$f":"IF(H19=\"\",\"\",H19)","v":""},{"$f":"IF(I19=\"\",\"\",I19)","v":""},{"$f":"IF(H20=\"\",\"\",H20)","v":""}]
[{"$nulls":10},{"$f":"IF(B22=\"\",\"\",B22)","v":""},{"$f":"IF(C22=\"\",\"\",C22)","v":""},{"$f":"IF(B23=\"\",\"\",B23)","v":""}]
[{"$nulls":10},{"$f":"IF(E22=\"\",\"\",E22)","v":""},{"$f":"IF(F22=\"\",\"\",F22)","v":""},{"$f":"IF(E23=\"\",\"\",E23)","v":""}]
[{"$nulls":10},{"$f":"IF(H22=\"\",\"\",H22)","v":""},{"$f":"IF(I22=\"\",\"\",I22)","v":""},{"$f":"IF(H23=\"\",\"\",H23)","v":""}]
[{"$nulls":10},{"$f":"IF(B25=\"\",\"\",B25)","v":""},{"$f":"IF(C25=\"\",\"\",C25)","v":""},{"$f":"IF(B26=\"\",\"\",B26)","v":""}]
[{"$nulls":10},{"$f":"IF(E25=\"\",\"\",E25)","v":""},{"$f":"IF(F25=\"\",\"\",F25)","v":""},{"$f":"IF(E26=\"\",\"\",E26)","v":""}]
[{"$nulls":10},{"$f":"IF(H25=\"\",\"\",H25)","v":""},{"$f":"IF(I25=\"\",\"\",I25)","v":""},{"$f":"IF(H26=\"\",\"\",H26)","v":""}]
[{"$nulls":10},{"$f":"IF(B28=\"\",\"\",B28)","v":""},{"$f":"IF(C28=\"\",\"\",C28)","v":""},{"$f":"IF(B29=\"\",\"\",B29)","v":""}]
[{"$nulls":10},{"$f":"IF(E28=\"\",\"\",E28)","v":""},{"$f":"IF(F28=\"\",\"\",F28)","v":""},{"$f":"IF(E29=\"\",\"\",E29)","v":""}]
[{"$nulls":10},{"$f":"IF(H28=\"\",\"\",H28)","v":""},{"$f":"IF(I28=\"\",\"\",I28)","v":""},{"$f":"IF(H29=\"\",\"\",H29)","v":""}]
[{"$nulls":10},{"$f":"IF(B31=\"\",\"\",B31)","v":""},{"$f":"IF(C31=\"\",\"\",C31)","v":""},{"$f":"IF(B32=\"\",\"\",B32)","v":""}]
[{"$nulls":10},{"$f":"IF(E31=\"\",\"\",E31)","v":""},{"$f":"IF(F31=\"\",\"\",F31)","v":""},{"$f":"IF(E32=\"\",\"\",E32)","v":""}]
[{"$nulls":10},{"$f":"IF(H31=\"\",\"\",H31)","v":""},{"$f":"IF(I31=\"\",\"\",I31)","v":""},{"$f":"IF(H32=\"\",\"\",H32)","v":""}]
[{"$nulls":10},{"$f":"IF(B34=\"\",\"\",B34)","v":""},{"$f":"IF(C34=\"\",\"\",C34)","v":""},{"$f":"IF(B35=\"\",\"\",B35)","v":""}]
[{"$nulls":10},{"$f":"IF(E34=\"\",\"\",E34)","v":""},{"$f":"IF(F34=\"\",\"\",F34)","v":""},{"$f":"IF(E35=\"\",\"\",E35)","v":""}]
[{"$nulls":10},{"$f":"IF(H34=\"\",\"\",H34)","v":""},{"$f":"IF(I34=\"\",\"\",I34)","v":""},{"$f":"IF(H35=\"\",\"\",H35)","v":""}]
[{"$nulls":10},{"$f":"IF(B37=\"\",\"\",B37)","v":""},{"$f":"IF(C37=\"\",\"\",C37)","v":""},{"$f":"IF(B38=\"\",\"\",B38)","v":""}]
[{"$nulls":10},{"$f":"IF(E37=\"\",\"\",E37)","v":""},{"$f":"IF(F37=\"\",\"\",F37)","v":""},{"$f":"IF(E38=\"\",\"\",E38)","v":""}]
[{"$nulls":10},{"$f":"IF(H37=\"\",\"\",H37)","v":""},{"$f":"IF(I37=\"\",\"\",I37)","v":""},{"$f":"IF(H38=\"\",\"\",H38)","v":""}]

{"sheet":"一覧表","index":1,"n_rows":36,"n_cols":4,"rows_kept":36}
[]
[]
[null,1,{"$f":"IFERROR(VLOOKUP($B3,連絡網!$K$41:$N$74,2,FALSE),\"\")","v":"鈴木 太朗"},{"$f":"IFERROR(VLOOKUP($B3,連絡網!$K$41:$N$74,3,FALSE),\"\")","v":"03-0000-0000"}]
[null,2,{"$f":"IFERROR(VLOOKUP($B4,連絡網!$K$41:$N$74,2,FALSE),\"\")","v":"宮内 亮"},{"$f":"IFERROR(VLOOKUP($B4,連絡網!$K$41:$N$74,3,FALSE),\"\")","v":"00-0000-0000"}]
[null,3,{"$f":"IFERROR(VLOOKUP($B5,連絡網!$K$41:$N$74,2,FALSE),\"\")","v":"香川 真治"},{"$f":"IFERROR(VLOOKUP($B5,連絡網!$K$41:$N$74,3,FALSE),\"\")","v":"00-0000-0000"}]
[null,4,{"$f":"IFERROR(VLOOKUP($B6,連絡網!$K$41:$N$74,2,FALSE),\"\")","v":"本多 慶介"},{"$f":"IFERROR(VLOOKUP($B6,連絡網!$K$41:$N$74,3,FALSE),\"\")","v":"00-0000-0000"}]
[null,5,{"$f":"IFERROR(VLOOKUP($B7,連絡網!$K$41:$N$74,2,FALSE),\"\")","v":"苗字 名前"},{"$f":"IFERROR(VLOOKUP($B7,連絡網!$K$41:$N$74,3,FALSE),\"\")","v":"00-0000-0000"}]
[null,6,{"$f":"IFERROR(VLOOKUP($B8,連絡網!$K$41:$N$74,2,FALSE),\"\")","v":"苗字 名前"},{"$f":"IFERROR(VLOOKUP($B8,連絡網!$K$41:$N$74,3,FALSE),\"\")","v":"00-0000-0000"}]
[null,7,{"$f":"IFERROR(VLOOKUP($B9,連絡網!$K$41:$N$74,2,FALSE),\"\")","v":"苗字 名前"},{"$f":"IFERROR(VLOOKUP($B9,連絡網!$K$41:$N$74,3,FALSE),\"\")","v":"00-0000-0000"}]
[null,8,{"$f":"IFERROR(VLOOKUP($B10,連絡網!$K$41:$N$74,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B10,連絡網!$K$41:$N$74,3,FALSE),\"\")","v":""}]
[null,9,{"$f":"IFERROR(VLOOKUP($B11,連絡網!$K$41:$N$74,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B11,連絡網!$K$41:$N$74,3,FALSE),\"\")","v":""}]
[null,10,{"$f":"IFERROR(VLOOKUP($B12,連絡網!$K$41:$N$74,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B12,連絡網!$K$41:$N$74,3,FALSE),\"\")","v":""}]
[null,11,{"$f":"IFERROR(VLOOKUP($B13,連絡網!$K$41:$N$74,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B13,連絡網!$K$41:$N$74,3,FALSE),\"\")","v":""}]
[null,12,{"$f":"IFERROR(VLOOKUP($B14,連絡網!$K$41:$N$74,2,FALSE),\"\")","v":"苗字 名前"},{"$f":"IFERROR(VLOOKUP($B14,連絡網!$K$41:$N$74,3,FALSE),\"\")","v":"06-0000-0000"}]
[null,13,{"$f":"IFERROR(VLOOKUP($B15,連絡網!$K$41:$N$74,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B15,連絡網!$K$41:$N$74,3,FALSE),\"\")","v":""}]
[null,14,{"$f":"IFERROR(VLOOKUP($B16,連絡網!$K$41:$N$74,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B16,連絡網!$K$41:$N$74,3,FALSE),\"\")","v":""}]
[null,15,{"$f":"IFERROR(VLOOKUP($B17,連絡網!$K$41:$N$74,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B17,連絡網!$K$41:$N$74,3,FALSE),\"\")","v":""}]
[null,16,{"$f":"IFERROR(VLOOKUP($B18,連絡網!$K$41:$N$74,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B18,連絡網!$K$41:$N$74,3,FALSE),\"\")","v":""}]
[null,17,{"$f":"IFERROR(VLOOKUP($B19,連絡網!$K$41:$N$74,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B19,連絡網!$K$41:$N$74,3,FALSE),\"\")","v":""}]
[null,18,{"$f":"IFERROR(VLOOKUP($B20,連絡網!$K$41:$N$74,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B20,連絡網!$K$41:$N$74,3,FALSE),\"\")","v":""}]
[null,19,{"$f":"IFERROR(VLOOKUP($B21,連絡網!$K$41:$N$74,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B21,連絡網!$K$41:$N$74,3,FALSE),\"\")","v":""}]
[null,20,{"$f":"IFERROR(VLOOKUP($B22,連絡網!$K$41:$N$74,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B22,連絡網!$K$41:$N$74,3,FALSE),\"\")","v":""}]
[null,21,{"$f":"IFERROR(VLOOKUP($B23,連絡網!$K$41:$N$74,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B23,連絡網!$K$41:$N$74,3,FALSE),\"\")","v":""}]
[null,22,{"$f":"IFERROR(VLOOKUP($B24,連絡網!$K$41:$N$74,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B24,連絡網!$K$41:$N$74,3,FALSE),\"\")","v":""}]
[null,23,{"$f":"IFERROR(VLOOKUP($B25,連絡網!$K$41:$N$74,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B25,連絡網!$K$41:$N$74,3,FALSE),\"\")","v":""}]
[null,24,{"$f":"IFERROR(VLOOKUP($B26,連絡網!$K$41:$N$74,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B26,連絡網!$K$41:$N$74,3,FALSE),\"\")","v":""}]
[null,25,{"$f":"IFERROR(VLOOKUP($B27,連絡網!$K$41:$N$74,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B27,連絡網!$K$41:$N$74,3,FALSE),\"\")","v":""}]
[null,26,{"$f":"IFERROR(VLOOKUP($B28,連絡網!$K$41:$N$74,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B28,連絡網!$K$41:$N$74,3,FALSE),\"\")","v":""}]
[null,27,{"$f":"IFERROR(VLOOKUP($B29,連絡網!$K$41:$N$74,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B29,連絡網!$K$41:$N$74,3,FALSE),\"\")","v":""}]
[null,28,{"$f":"IFERROR(VLOOKUP($B30,連絡網!$K$41:$N$74,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B30,連絡網!$K$41:$N$74,3,FALSE),\"\")","v":""}]
[null,29,{"$f":"IFERROR(VLOOKUP($B31,連絡網!$K$41:$N$74,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B31,連絡網!$K$41:$N$74,3,FALSE),\"\")","v":""}]
[null,30,{"$f":"IFERROR(VLOOKUP($B32,連絡網!$K$41:$N$74,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B32,連絡網!$K$41:$N$74,3,FALSE),\"\")","v":""}]
[null,31,{"$f":"IFERROR(VLOOKUP($B33,連絡網!$K$41:$N$74,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B33,連絡網!$K$41:$N$74,3,FALSE),\"\")","v":""}]
[null,32,{"$f":"IFERROR(VLOOKUP($B34,連絡網!$K$41:$N$74,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B34,連絡網!$K$41:$N$74,3,FALSE),\"\")","v":""}]
[null,33,{"$f":"IFERROR(VLOOKUP($B35,連絡網!$K$41:$N$74,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B35,連絡網!$K$41:$N$74,3,FALSE),\"\")","v":""}]
[null,34,{"$f":"IFERROR(VLOOKUP($B36,連絡網!$K$41:$N$74,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B36,連絡網!$K$41:$N$74,3,FALSE),\"\")","v":""}]

{"sheet":"予算・出欠管理","index":2,"n_rows":21,"n_cols":11,"rows_kept":21,"merged":[[1,1,1,4],[1,6,1,10],[2,3,2,4],[3,3,3,4],[4,3,4,4],[5,3,5,4],[6,3,6,4],[7,3,7,4],[8,3,8,4],[9,3,9,4],[10,3,10,4],[11,3,11,4],[12,3,12,4],[13,3,13,4],[14,3,14,4],[15,3,15,4],[16,3,16,4],[17,3,17,4],[18,3,18,4],[20,7,20,9]]}
[]
[null,"メンバー表",{"$nulls":4},"予算管理"]
[null,"No","名前","備考",null,null,"項目","数量","単価","金額","備考"]
[null,1,"宮内　亮",{"$nulls":3},"サッカーボール",4,{"v":1200,"d":"¥1,200"},{"$f":"SUM(H4*I4)","v":{"v":4800,"d":"¥4,800"}}]
[null,2,"香川　真治",{"$nulls":3},"ビブス",10,{"v":500,"d":"¥500"},{"v":5000,"d":"¥5,000"}]
[null,3,"本多　慶介",{"$nulls":3},"ストップウォッチ",2,{"v":980,"d":"¥980"},{"v":1960,"d":"¥1,960"}]
[null,4,{"$nulls":4},"コート使用代金",1,{"v":10000,"d":"¥10,000"},{"v":10000,"d":"¥10,000"}]
[null,5,{"$nulls":7},{"v":0,"d":"¥0"}]
[null,6,{"$nulls":7},{"v":0,"d":"¥0"}]
[null,7,{"$nulls":7},{"v":0,"d":"¥0"}]
[null,8,{"$nulls":7},{"v":0,"d":"¥0"}]
[null,9,{"$nulls":7},{"v":0,"d":"¥0"}]
[null,10,{"$nulls":7},{"v":0,"d":"¥0"}]
[null,11,{"$nulls":7},{"v":0,"d":"¥0"}]
[null,12,{"$nulls":7},{"v":0,"d":"¥0"}]
[null,13,{"$nulls":7},{"v":0,"d":"¥0"}]
[null,14,{"$nulls":7},{"v":0,"d":"¥0"}]
[null,15,{"$nulls":7},{"v":0,"d":"¥0"}]
[null,"合計",{"$f":"COUNTA(C4:C18)","v":3},{"$nulls":3},"合計金額",null,null,{"$f":"SUM(J4:J18)","v":{"v":21760,"d":"¥21,760"}}]
[]
[{"$nulls":7},"一人当たりの金額",null,null,{"$f":"SUM(J19/C19)","v":{"v":7253.333333333333,"d":"¥7,253"}}]