{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["初期設定","最上位"],"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":"初期設定","index":0,"n_rows":4,"n_cols":4,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[null,"プロセス全体名称","保守業務"]
[null,"最上位レベル名称","保守メインプロセス"]
[null,"最上位番号",1,"ブランク　もしくは　1  或いは　1.1　などの半角数字を入力してください"]

{"sheet":"最上位","index":1,"n_rows":24,"n_cols":12,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,10,0,11],[0,0,0,2],[0,3,0,4],[0,5,0,7],[0,8,0,9]]}
[{"$f":"初期設定!C2","v":"保守業務"},null,null,{"$f":"G14","v":1},null,{"$f":"G15","v":"保守メインプロセス"},null,null,"備考"]
[]
[]
[null,{"$f":"IF(ISBLANK(B5),\"\",$C$6&\".1\")","v":"1.1.1"},{"$f":"IF(ISBLANK(C5),\"\",$C$6&\".2\")","v":"1.1.2"},{"$f":"IF(ISBLANK(D5),\"\",$C$6&\".3\")","v":"1.1.3"},null,{"$f":"IF(ISBLANK(F5),\"\",$G$6&\".1\")","v":"1.2.1"},{"$f":"IF(ISBLANK(G5),\"\",$G$6&\".2\")","v":"1.2.2"},{"$f":"IF(ISBLANK(H5),\"\",$G$6&\".3\")","v":"1.2.3"},null,{"$f":"IF(ISBLANK(J5),\"\",$K$6&\".1\")","v":"1.3.1"},{"$f":"IF(ISBLANK(K5),\"\",$K$6&\".2\")","v":"1.3.2"},{"$f":"IF(ISBLANK(L5),\"\",$K$6&\".3\")","v":"1.3.3"}]
[null,"当該月に更新となる契約を確認する","保守の内容と品目を決定する","見積価格を算定する",null,"契約書を作成する","社印を押印する","契約書を送付する",null,"作業日程を決める","資材を発注する","作業員をアサインする"]
[null,{"$f":"IF(ISBLANK(B7),\"\",$C$6&\".8\")","v":""},{"$f":"F12","v":"1.1"},{"$f":"IF(ISBLANK(D7),\"\",$C$6&\".4\")","v":"1.1.4"},null,{"$f":"IF(ISBLANK(F7),\"\",$G$6&\".8\")","v":""},{"$f":"G12","v":"1.2"},{"$f":"IF(ISBLANK(H7),\"\",$G$6&\".4\")","v":""},null,{"$f":"IF(ISBLANK(J7),\"\",$K$6&\".8\")","v":""},{"$f":"H12","v":"1.3"},{"$f":"IF(ISBLANK(L7),\"\",$K$6&\".4\")","v":"1.3.4"}]
[null,null,{"$f":"IF(ISBLANK(F13),\"\",F13)","v":"契約更新の見積を作成する"},"見積書を作成・送付する",null,null,{"$f":"IF(ISBLANK(G13),\"\",G13)","v":"契約書を作成する"},null,null,null,{"$f":"IF(ISBLANK(H13),\"\",H13)","v":"作業を実施する"},"資材納品を確認する"]
[null,{"$f":"IF(ISBLANK(B9),\"\",$C$6&\".7\")","v":""},{"$f":"IF(ISBLANK(C9),\"\",$C$6&\".6\")","v":"1.1.6"},{"$f":"IF(ISBLANK(D9),\"\",$C$6&\".5\")","v":"1.1.5"},null,{"$f":"IF(ISBLANK(F9),\"\",$G$6&\".7\")","v":""},{"$f":"IF(ISBLANK(G9),\"\",$G$6&\".6\")","v":""},{"$f":"IF(ISBLANK(H9),\"\",$G$6&\".5\")","v":""},null,{"$f":"IF(ISBLANK(J9),\"\",$K$6&\".7\")","v":"1.3.7"},{"$f":"IF(ISBLANK(K9),\"\",$K$6&\".6\")","v":"1.3.6"},{"$f":"IF(ISBLANK(L9),\"\",$K$6&\".5\")","v":"1.3.5"}]
[null,null,"保守契約データベースを更新する","更新請書を作成・送付する",null,null,null,null,null,"顧客検収を完了する","作業を実施する","資材請求書・納品書を確認する"]
[]
[]
[null,{"$f":"IF(ISBLANK(B13),\"\",$C$14&\".1\")","v":""},{"$f":"IF(ISBLANK(C13),\"\",$C$14&\".2\")","v":""},{"$f":"IF(ISBLANK(D13),\"\",$C$14&\".3\")","v":""},null,{"$f":"IF(ISBLANK(F13),\"\",IF($G$14<>\"\",$G$14&\".1\",\"1\"))","v":"1.1"},{"$f":"IF(ISBLANK(G13),\"\",IF($G$14<>\"\",$G$14&\".2\",\"2\"))","v":"1.2"},{"$f":"IF(ISBLANK(H13),\"\",IF($G$14<>\"\",$G$14&\".3\",\"3\"))","v":"1.3"},null,{"$f":"IF(ISBLANK(J13),\"\",$K$14&\".1\")","v":"1.4.1"},{"$f":"IF(ISBLANK(K13),\"\",$K$14&\".2\")","v":"1.4.2"},{"$f":"IF(ISBLANK(L13),\"\",$K$14&\".3\")","v":"1.4.3"}]
[null,null,null,null,null,"契約更新の見積を作成する","契約書を作成する","作業を実施する",null,"請求予定一覧を作成する","検収書を確認する","請求書を作成する"]
[null,{"$f":"IF(ISBLANK(B15),\"\",$C$14&\".8\")","v":""},{"$f":"F14","v":""},{"$f":"IF(ISBLANK(D15),\"\",$C$14&\".4\")","v":""},null,{"$f":"IF(ISBLANK(F15),\"\",IF($G$14<>\"\",$G$14&\".8\",\"8\"))","v":""},{"$f":"IF(ISBLANK(初期設定!C4),\"\",初期設定!C4)","v":1},{"$f":"IF(ISBLANK(H15),\"\",IF($G$14<>\"\",$G$14&\".4\",\"4\"))","v":"1.4"},null,{"$f":"IF(ISBLANK(J15),\"\",$K$14&\".8\")","v":""},{"$f":"H14","v":"1.4"},{"$f":"IF(ISBLANK(L15),\"\",$K$14&\".4\")","v":"1.4.4"}]
[null,null,{"$f":"IF(ISBLANK(F15),\"\",F15)","v":""},null,null,null,{"$f":"初期設定!C3","v":"保守メインプロセス"},"請求を行う",null,null,{"$f":"IF(ISBLANK(H15),\"\",H15)","v":"請求を行う"},"売上を計上する"]
[null,{"$f":"IF(ISBLANK(B17),\"\",$C$14&\".7\")","v":""},{"$f":"IF(ISBLANK(C17),\"\",$C$14&\".6\")","v":""},{"$f":"IF(ISBLANK(D17),\"\",$C$14&\".5\")","v":""},null,{"$f":"IF(ISBLANK(F17),\"\",IF($G$14<>\"\",$G$14&\".7\",\"7\"))","v":""},{"$f":"IF(ISBLANK(G17),\"\",IF($G$14<>\"\",$G$14&\".6\",\"6\"))","v":"1.6"},{"$f":"IF(ISBLANK(H17),\"\",IF($G$14<>\"\",$G$14&\".5\",\"5\"))","v":"1.5"},null,{"$f":"IF(ISBLANK(J17),\"\",$K$14&\".7\")","v":""},{"$f":"IF(ISBLANK(K17),\"\",$K$14&\".6\")","v":""},{"$f":"IF(ISBLANK(L17),\"\",$K$14&\".5\")","v":"1.4.5"}]
[null,null,null,null,null,null,"保守営業を行う","入金を確認する",null,null,null,"請求書を送付する"]
[]
[]
[null,{"$f":"IF(ISBLANK(B21),\"\",$C$22&\".1\")","v":""},{"$f":"IF(ISBLANK(C21),\"\",$C$22&\".2\")","v":""},{"$f":"IF(ISBLANK(D21),\"\",$C$22&\".3\")","v":""},null,{"$f":"IF(ISBLANK(F21),\"\",$G$22&\".1\")","v":"1.6.1"},{"$f":"IF(ISBLANK(G21),\"\",$G$22&\".2\")","v":"1.6.2"},{"$f":"IF(ISBLANK(H21),\"\",$G$22&\".3\")","v":"1.6.3"},null,{"$f":"IF(ISBLANK(J21),\"\",$K$22&\".1\")","v":"1.5.1"},{"$f":"IF(ISBLANK(K21),\"\",$K$22&\".2\")","v":"1.5.2"},{"$f":"IF(ISBLANK(L21),\"\",$K$22&\".3\")","v":"1.5.3"}]
[null,null,null,null,null,"顧客ニーズを伺う","新規保守メニューを開発する","営業活動を行う",null,"入金明細を確認する","売掛金を消し込む","未入金先をリストアップする"]
[null,{"$f":"IF(ISBLANK(B23),\"\",$C$22&\".8\")","v":""},{"$f":"F16","v":""},{"$f":"IF(ISBLANK(D23),\"\",$C$22&\".4\")","v":""},null,{"$f":"IF(ISBLANK(F23),\"\",$G$22&\".8\")","v":""},{"$f":"G16","v":"1.6"},{"$f":"IF(ISBLANK(H23),\"\",$G$22&\".4\")","v":""},null,{"$f":"IF(ISBLANK(J23),\"\",$K$22&\".8\")","v":""},{"$f":"H16","v":"1.5"},{"$f":"IF(ISBLANK(L23),\"\",$K$22&\".4\")","v":"1.5.4"}]
[null,null,{"$f":"IF(ISBLANK(F17),\"\",F17)","v":""},null,null,null,{"$f":"IF(ISBLANK(G17),\"\",G17)","v":"保守営業を行う"},null,null,null,{"$f":"IF(ISBLANK(H17),\"\",H17)","v":"入金を確認する"},"未入金先に連絡する"]
[null,{"$f":"IF(ISBLANK(B25),\"\",$C$22&\".7\")","v":""},{"$f":"IF(ISBLANK(C25),\"\",$C$22&\".6\")","v":""},{"$f":"IF(ISBLANK(D25),\"\",$C$22&\".5\")","v":""},null,{"$f":"IF(ISBLANK(F25),\"\",$G$22&\".7\")","v":""},{"$f":"IF(ISBLANK(G25),\"\",$G$22&\".6\")","v":""},{"$f":"IF(ISBLANK(H25),\"\",$G$22&\".5\")","v":""},null,{"$f":"IF(ISBLANK(J25),\"\",$K$22&\".7\")","v":""},{"$f":"IF(ISBLANK(K25),\"\",$K$22&\".6\")","v":""},{"$f":"IF(ISBLANK(L25),\"\",$K$22&\".5\")","v":""}]