{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["読込","保存","temp"],"not_rendered":{"charts":0,"images":1,"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":"読込","index":0,"n_rows":20,"n_cols":3,"rows_kept":20,"cut":false,"hidden":false,"merged":[[2,1,2,6],[4,1,4,2],[4,3,4,6]]}
[]
[null,"既存のエクセルファイル"]
[]
[]
[null,"シート名リスト"]
[]
[null,null,"シート名リストから取り込むシートを選択してください"]
[]
[]
[]
[null,null,"取り込んだシートにtempシートのマクロコードをコピーする"]
[]
[null,"シート名リスト"]
[]
[]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]

{"sheet":"保存","index":1,"n_rows":23,"n_cols":4,"rows_kept":23,"cut":false,"hidden":false,"merged":[[4,3,4,6],[4,1,4,2],[2,1,2,6],[13,1,13,2],[13,3,13,6],[11,1,11,6],[5,3,5,6],[5,1,5,2]]}
[]
[null,"新規ファイルを保存するフォルダパス"]
[]
[]
[null,"ファイル名",null,"dammy.xlsx"]
[null,"出力するシート名",null,{"$f":"D14","v":""}]
[]
[]
[]
[]
[null,"シート出力ファイル(読込ファイル)"]
[null,{"$f":"IF(読込!B3=\"\",\"\",読込!B3)","v":""}]
[]
[null,"出力するシート名",null,""]
[]
[]
[]
[]
[null,"移動可能なシート名"]
[null,""]
[null,""]
[null,""]
[null,""]

{"sheet":"temp","index":2,"n_rows":35,"n_cols":31,"rows_kept":35,"cut":false,"hidden":false,"merged":[[27,26,27,29],[27,30,27,32],[28,1,28,2],[28,3,28,4],[28,5,29,13],[28,14,28,15],[28,16,28,17],[28,18,28,19],[28,20,28,21],[28,22,28,23],[28,24,28,25],[28,26,28,27],[28,28,28,29],[28,30,28,32],[29,14,29,17],[29,18,29,21],[29,22,29,25],[29,26,29,29],[29,30,29,32],[25,26,25,27],[25,28,25,29],[25,30,25,32],[26,14,26,17],[26,18,26,21],[26,22,26,25],[26,26,26,29],[26,30,26,32],[24,26,24,29],[24,30,24,32],[25,3,25,4],[25,5,26,13],[25,14,25,15],[25,16,25,17],[25,18,25,19],[25,20,25,21],[25,22,25,23],[25,24,25,25],[23,1,23,2],[23,14,23,17],[23,18,23,21],[23,22,23,25],[23,26,23,29],[23,30,23,32],[21,22,21,23],[21,24,21,25],[21,26,21,27],[21,28,21,29],[21,30,21,32],[22,14,22,17],[22,18,22,21],[22,22,22,25],[22,26,22,29],[22,30,22,32],[19,2,19,3],[19,5,20,13],[19,14,19,15],[19,16,19,17],[19,18,19,19],[19,20,19,21],[21,2,21,3],[21,5,22,13],[21,14,21,15],[21,16,21,17],[21,18,21,19],[21,20,21,21],[17,26,17,27],[17,28,17,29],[17,30,17,32],[18,26,18,29],[18,30,18,32],[19,28,19,29],[19,30,19,32],[20,14,20,17],[20,18,20,21],[20,22,20,25],[20,26,20,29],[20,30,20,32],[19,22,19,23],[19,24,19,25],[19,26,19,27],[17,2,17,3],[17,5,18,13],[17,14,17,15],[17,16,17,17],[17,18,17,19],[17,20,17,21],[18,14,18,17],[18,18,18,21],[18,22,18,25],[17,22,17,23],[17,24,17,25],[12,30,12,32],[13,14,13,17],[13,18,13,21],[13,22,13,25],[13,26,13,29],[13,30,13,32],[14,26,14,29],[14,30,14,32],[15,2,15,3],[15,5,16,13],[15,14,15,15],[15,16,15,17],[15,18,15,19],[15,20,15,21],[15,22,15,23],[15,24,15,25],[15,26,15,27],[15,28,15,29],[15,30,15,32],[16,14,16,17],[16,18,16,21],[16,22,16,25],[16,26,16,29],[16,30,16,32],[12,2,12,3],[12,5,13,13],[12,14,12,15],[12,16,12,17],[12,18,12,19],[12,20,12,21],[10,22,10,23],[10,24,10,25],[10,26,10,27],[12,22,12,23],[12,24,12,25],[12,26,12,27],[11,14,11,17],[11,18,11,21],[11,22,11,25],[11,26,11,29],[12,28,12,29],[6,2,6,3],[6,5,7,13],[6,14,6,15],[6,16,6,17],[6,18,6,19],[6,20,6,21],[11,30,11,32],[10,2,10,3],[10,5,11,13],[10,14,10,15],[10,16,10,17],[10,18,10,19],[10,20,10,21],[8,28,8,29],[8,30,8,32],[9,14,9,17],[9,18,9,21],[9,22,9,25],[9,26,9,29],[9,30,9,32],[10,28,10,29],[10,30,10,32],[8,2,8,3],[8,5,9,13],[6,22,6,23],[6,24,6,25],[6,26,6,27],[8,26,8,27],[6,28,6,29],[6,30,6,32],[7,14,7,17],[7,18,7,21],[7,22,7,25],[7,26,7,29],[7,30,7,32],[8,14,8,15],[8,16,8,17],[8,18,8,19],[8,20,8,21],[8,22,8,23],[8,24,8,25],[3,26,3,29],[3,30,3,32],[4,2,4,3],[4,5,5,13],[4,14,4,15],[4,16,4,17],[4,18,4,19],[4,20,4,21],[4,22,4,23],[4,24,4,25],[4,26,4,27],[4,28,4,29],[4,30,4,32],[5,14,5,17],[5,18,5,21],[5,22,5,25],[5,26,5,29],[5,30,5,32],[2,1,2,2],[2,14,2,17],[2,18,2,21],[2,22,2,25],[2,26,2,29],[2,30,2,32],[0,1,0,32],[1,1,1,13],[1,14,1,17],[1,18,1,21],[1,22,1,25],[1,26,1,29],[1,30,1,32]]}
[null,"進　捗　報　告　書"]
[null,"項目",null,null,null,null,null,null,null,null,null,null,null,null,"先週実績",null,null,null,"今週実績",null,null,null,"来週予定",null,null,null,"作業量見込み",null,null,null,"完了予定"]
["A",1,null,"大項目名１"]
[null,"中",{"$f":"$B$3","v":1},1,"中項目名１",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIFS(AA5:AB14,AC5:AD14,\"=ページ\")","v":0},null,null,null,{"$f":"IF(SUMIF(AA5:AA14,\"<>(先週完了予定)\",AE5:AE14)=0,\"\",_xlfn.MAXIFS(AE5:AE14,AA5:AA14,\"<>(先週完了予定)\"))","v":""}]
["C",null,{"$f":"CONCATENATE($C$4,\"-\",$D$4,\".\")","v":"1-1."},null,1,"小項目名A",null,null,null,null,null,null,null,null,0,null,"単位",null,0,null,"単位",null,0,null,"単位",null,0,null,"単位"]
["D",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AA5=0,0,IF($AA5=\"\",\"\",O5/$AA5))","v":0},null,null,null,{"$f":"IF($AA5=0,0,IF($AA5=\"\",\"\",S5/$AA5))","v":0},null,null,null,{"$f":"IF($AA5=0,0,IF($AA5=\"\",\"\",W5/$AA5))","v":0},null,null,null,"(先週完了予定)"]
["C",null,{"$f":"CONCATENATE($C$4,\"-\",$D$4,\".\")","v":"1-1."},null,{"$f":"E5+1","v":2},"小項目名B",null,null,null,null,null,null,null,null,0,null,"単位",null,0,null,"単位",null,0,null,"単位",null,0,null,"単位"]
["D",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AA7=0,0,IF($AA7=\"\",\"\",O7/$AA7))","v":0},null,null,null,{"$f":"IF($AA7=0,0,IF($AA7=\"\",\"\",S7/$AA7))","v":0},null,null,null,{"$f":"IF($AA7=0,0,IF($AA7=\"\",\"\",W7/$AA7))","v":0},null,null,null,"(先週完了予定)"]
["C",null,{"$f":"CONCATENATE($C$4,\"-\",$D$4,\".\")","v":"1-1."},null,{"$f":"E7+1","v":3},"小項目名C",null,null,null,null,null,null,null,null,0,null,"単位",null,0,null,"単位",null,0,null,"単位",null,0,null,"単位"]
["D",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AA9=0,0,IF($AA9=\"\",\"\",O9/$AA9))","v":0},null,null,null,{"$f":"IF($AA9=0,0,IF($AA9=\"\",\"\",S9/$AA9))","v":0},null,null,null,{"$f":"IF($AA9=0,0,IF($AA9=\"\",\"\",W9/$AA9))","v":0},null,null,null,"(先週完了予定)"]
["C",null,{"$f":"CONCATENATE($C$4,\"-\",$D$4,\".\")","v":"1-1."},null,{"$f":"E9+1","v":4},"小項目名C",null,null,null,null,null,null,null,null,0,null,"単位",null,0,null,"単位",null,0,null,"単位",null,0,null,"単位"]
["D",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AA11=0,0,IF($AA11=\"\",\"\",O11/$AA11))","v":0},null,null,null,{"$f":"IF($AA11=0,0,IF($AA11=\"\",\"\",S11/$AA11))","v":0},null,null,null,{"$f":"IF($AA11=0,0,IF($AA11=\"\",\"\",W11/$AA11))","v":0},null,null,null,"(先週完了予定)"]
["C",null,{"$f":"CONCATENATE($C$4,\"-\",$D$4,\".\")","v":"1-1."},null,{"$f":"E11+1","v":5},"小項目名D",null,null,null,null,null,null,null,null,0,null,"単位",null,0,null,"単位",null,0,null,"単位",null,0,null,"単位"]
["D",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AA13=0,0,IF($AA13=\"\",\"\",O13/$AA13))","v":0},null,null,null,{"$f":"IF($AA13=0,0,IF($AA13=\"\",\"\",S13/$AA13))","v":0},null,null,null,{"$f":"IF($AA13=0,0,IF($AA13=\"\",\"\",W13/$AA13))","v":0},null,null,null,"(先週完了予定)"]
[null,"中",{"$f":"$B$3","v":1},{"$f":"D4+1","v":2},"中項目名１",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIFS(AA16:AB23,AC16:AD23,\"=module\")","v":0},null,null,null,{"$f":"IF(SUMIF(AA16:AA25,\"<>(先週完了予定)\",AE16:AE25)=0,\"\",_xlfn.MAXIFS(AE16:AE25,AA16:AA25,\"<>(先週完了予定)\"))","v":""}]
[null,null,{"$f":"CONCATENATE($C$15,\"-\",$D$15,\".\")","v":"1-2."},null,1,"小項目名AA",null,null,null,null,null,null,null,null,0,null,"単位",null,0,null,"単位",null,0,null,"単位",null,0,null,"単位"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AA16=0,0,IF($AA16=\"\",\"\",O16/$AA16))","v":0},null,null,null,{"$f":"IF($AA16=0,0,IF($AA16=\"\",\"\",S16/$AA16))","v":0},null,null,null,{"$f":"IF($AA16=0,0,IF($AA16=\"\",\"\",W16/$AA16))","v":0},null,null,null,"(先週完了予定)"]
[null,null,{"$f":"CONCATENATE($C$4,\"-\",$D$4,\".\")","v":"1-1."},null,{"$f":"E16+1","v":2},"小項目名BB",null,null,null,null,null,null,null,null,0,null,"単位",null,0,null,"単位",null,0,null,"単位",null,0,null,"単位"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AA18=0,0,IF($AA18=\"\",\"\",O18/$AA18))","v":0},null,null,null,{"$f":"IF($AA18=0,0,IF($AA18=\"\",\"\",S18/$AA18))","v":0},null,null,null,{"$f":"IF($AA18=0,0,IF($AA18=\"\",\"\",W18/$AA18))","v":0},null,null,null,"(先週完了予定)"]
[null,null,{"$f":"CONCATENATE($C$4,\"-\",$D$4,\".\")","v":"1-1."},null,{"$f":"E18+1","v":3},"小項目名CC",null,null,null,null,null,null,null,null,0,null,"単位",null,0,null,"単位",null,0,null,"単位",null,0,null,"単位"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AA20=0,0,IF($AA20=\"\",\"\",O20/$AA20))","v":0},null,null,null,{"$f":"IF($AA20=0,0,IF($AA20=\"\",\"\",S20/$AA20))","v":0},null,null,null,{"$f":"IF($AA20=0,0,IF($AA20=\"\",\"\",W20/$AA20))","v":0},null,null,null,"(先週完了予定)"]
[null,null,{"$f":"CONCATENATE($C$4,\"-\",$D$4,\".\")","v":"1-1."},null,{"$f":"E20+1","v":4},"小項目名DD",null,null,null,null,null,null,null,null,0,null,"単位",null,0,null,"単位",null,0,null,"単位",null,0,null,"単位"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AA22=0,0,IF($AA22=\"\",\"\",O22/$AA22))","v":0},null,null,null,{"$f":"IF($AA22=0,0,IF($AA22=\"\",\"\",S22/$AA22))","v":0},null,null,null,{"$f":"IF($AA22=0,0,IF($AA22=\"\",\"\",W22/$AA22))","v":0},null,null,null,"(先週完了予定)"]
[null,2,null,"大項目名２"]
[null,"中",{"$f":"$B$24","v":2},1,"中項目名１",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIFS(AA26:AB27,AC26:AD27,\"=ページ\")","v":0},null,null,null,{"$f":"IF(SUMIF(AA26:AA27,\"<>(先週完了予定)\",AE26:AE27)=0,\"\",_xlfn.MAXIFS(AE26:AE27,AA26:AA27,\"<>(先週完了予定)\"))","v":""}]
[null,null,null,"1.1.1 ",null,"小項目名AAA",null,null,null,null,null,null,null,null,0,null,"単位",null,0,null,"単位",null,0,null,"単位",null,0,null,"単位"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AA26=0,0,IF($AA26=\"\",\"\",O26/$AA26))","v":0},null,null,null,{"$f":"IF($AA26=0,0,IF($AA26=\"\",\"\",S26/$AA26))","v":0},null,null,null,{"$f":"IF($AA26=0,0,IF($AA26=\"\",\"\",W26/$AA26))","v":0},null,null,null,"(先週完了予定)"]
[null,"中",{"$f":"$B$24","v":2},{"$f":"D25+1","v":2},"中項目名１",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIFS(AA29:AB30,AC29:AD30,\"=module\")","v":0},null,null,null,{"$f":"IF(SUMIF(AA29:AA30,\"<>(先週完了予定)\",AE29:AE30)=0,\"\",_xlfn.MAXIFS(AE29:AE30,AA29:AA30,\"<>(先週完了予定)\"))","v":""}]
[null,null,null,"1.2.1 ",null,"小項目名BBB",null,null,null,null,null,null,null,null,0,null,"単位",null,0,null,"単位",null,0,null,"単位",null,0,null,"単位"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AA29=0,0,IF($AA29=\"\",\"\",O29/$AA29))","v":0},null,null,null,{"$f":"IF($AA29=0,0,IF($AA29=\"\",\"\",S29/$AA29))","v":0},null,null,null,{"$f":"IF($AA29=0,0,IF($AA29=\"\",\"\",W29/$AA29))","v":0},null,null,null,"(先週完了予定)"]
[]
[]
[]
[]
[null,"備考："]