{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"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":"Sheet1","index":0,"n_rows":29,"n_cols":14,"rows_kept":29,"cut":false,"hidden":false,"merged":[[28,9,28,10],[15,9,15,10],[16,9,16,10],[17,9,17,10],[18,9,18,10],[19,9,19,10],[23,9,23,10],[24,9,24,10],[25,9,25,10],[26,9,26,10],[27,9,27,10],[14,9,14,10],[9,6,9,8],[20,9,20,10],[21,9,21,10],[22,9,22,10],[9,9,9,10],[10,9,10,10],[11,9,11,10],[12,9,12,10],[13,9,13,10],[3,7,3,10],[8,9,8,10],[6,1,6,2],[6,4,6,5],[6,7,6,10],[28,6,28,8],[15,6,15,8],[16,6,16,8],[17,6,17,8],[18,6,18,8],[19,6,19,8],[20,6,20,8],[21,6,21,8],[26,6,26,8],[27,6,27,8],[23,6,23,8],[24,6,24,8],[25,6,25,8],[1,1,1,10],[22,6,22,8],[10,6,10,8],[11,6,11,8],[12,6,12,8],[13,6,13,8],[14,6,14,8],[4,1,5,2],[3,1,3,2],[3,4,3,5],[4,4,5,5],[8,6,8,8],[4,7,5,10]]}
[]
[null,"予　約　予　定　表"]
[null,null,null,null,null,null,null,null,null,null,"BeeKidsClub"]
[null,"合計日数",null,null,"合計時間",null,null,"合計保育料"]
[null,{"$f":"COUNTA(B10:B29)","v":"00:00:00"},null,null,{"$f":"SUM(M10:M29)","v":0},null,null,{"$f":"SUM(G10:I29)","v":0}]
[]
[null,null,null,null,"上限120ｈまで",null,null,"定期は最低保育料18,000円"]
[null,null,"のセルのみ入力してください。"]
[null,"日付","開始時間",null,"終了時間","利用時間","保育料",null,null,"備考欄"]
[null,null,null,"～",null,{"$f":"IF(E10=\"\",\"\",M10)","v":""},{"$f":"IF(AND(M10>=0.5,M10<=1),300,M10*300)","v":0},null,null,null,null,null,{"$f":"IF(E10=\"\",0,IFERROR((DAY(N10)*24+HOUR(N10))+MINUTE(N10)/60,\" \"))","v":0},{"$f":"TIME(HOUR(E10-C10),CEILING(MINUTE(E10-C10),30),SECOND(E10-C10))","v":"00:00:00"}]
[null,null,null,"～",null,{"$f":"IF(E11=\"\",\"\",M11)","v":""},{"$f":"IF(AND(M11>=0.5,M11<=1),300,M11*300)","v":0},null,null,null,null,null,{"$f":"IF(E11=\"\",0,IFERROR((DAY(N11)*24+HOUR(N11))+MINUTE(N11)/60,\" \"))","v":0},{"$f":"TIME(HOUR(E11-C11),CEILING(MINUTE(E11-C11),30),SECOND(E11-C11))","v":"00:00:00"}]
[null,null,null,"～",null,"",0,null,null,null,null,null,0,"00:00:00"]
[null,null,null,"～",null,"",0,null,null,null,null,null,0,"00:00:00"]
[null,null,null,"～",null,"",0,null,null,null,null,null,0,"00:00:00"]
[null,null,null,"～",null,"",0,null,null,null,null,null,0,"00:00:00"]
[null,null,null,"～",null,"",0,null,null,null,null,null,0,"00:00:00"]
[null,null,null,"～",null,"",0,null,null,null,null,null,0,"00:00:00"]
[null,null,null,"～",null,"",0,null,null,null,null,null,0,"00:00:00"]
[null,null,null,"～",null,"",0,null,null,null,null,null,0,"00:00:00"]
[null,null,null,"～",null,"",0,null,null,null,null,null,0,"00:00:00"]
[null,null,null,"～",null,"",0,null,null,null,null,null,0,"00:00:00"]
[null,null,null,"～",null,"",0,null,null,null,null,null,0,"00:00:00"]
[null,null,null,"～",null,"",0,null,null,null,null,null,0,"00:00:00"]
[null,null,null,"～",null,"",{"$f":"IF(AND(M24>=0.5,M24<=1),300,M24*300)","v":0},null,null,null,null,null,{"$f":"IF(E24=\"\",0,IFERROR((DAY(N24)*24+HOUR(N24))+MINUTE(N24)/60,\" \"))","v":0},{"$f":"TIME(HOUR(E24-C24),CEILING(MINUTE(E24-C24),30),SECOND(E24-C24))","v":"00:00:00"}]
[null,null,null,"～",null,"",0,null,null,null,null,null,0,"00:00:00"]
[null,null,null,"～",null,"",0,null,null,null,null,null,0,"00:00:00"]
[null,null,null,"～",null,"",{"$f":"IF(AND(M27>=0.5,M27<=1),300,M27*300)","v":0},null,null,null,null,null,{"$f":"IF(E27=\"\",0,IFERROR((DAY(N27)*24+HOUR(N27))+MINUTE(N27)/60,\" \"))","v":0},{"$f":"TIME(HOUR(E27-C27),CEILING(MINUTE(E27-C27),30),SECOND(E27-C27))","v":"00:00:00"}]
[null,null,null,"～",null,"",0,null,null,null,null,null,0,"00:00:00"]
[null,null,null,"～",null,"",0,null,null,null,null,null,0,"00:00:00"]