{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["企画確認書第1次 ","企画確認書第2次","【提出用】TVCM制作見積確認スケジュール(企画)","内容リスト設定(企画)"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":3,"comments":1,"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":"企画確認書第1次 ","index":0,"n_rows":39,"n_cols":43,"rows_kept":39,"cut":false,"hidden":false,"merged":[[36,0,36,3],[36,4,36,16],[36,24,36,27],[36,31,36,34],[37,0,37,3],[37,4,37,16],[37,24,37,27],[37,31,37,34],[34,0,34,3],[34,4,34,16],[34,24,34,27],[34,31,34,34],[35,0,35,3],[35,4,35,16],[35,24,35,27],[35,31,35,34],[32,0,33,3],[32,4,32,16],[32,24,32,27],[32,31,32,34],[33,4,33,16],[33,24,33,27],[33,31,33,34],[29,0,29,3],[29,4,29,16],[29,24,29,27],[29,31,29,34],[30,0,31,3],[30,4,30,16],[30,24,30,27],[30,31,30,34],[31,4,31,16],[31,24,31,27],[31,31,31,34],[28,0,28,3],[28,4,28,16],[28,24,28,27],[28,31,28,34],[27,31,27,34],[24,0,27,3],[24,4,24,16],[24,24,24,27],[24,31,24,34],[25,4,25,16],[25,24,25,27],[25,31,25,34],[26,4,26,16],[26,24,26,27],[23,0,23,3],[23,4,23,16],[23,24,23,27],[23,31,23,34],[22,20,22,22],[20,5,20,19],[22,4,22,16],[22,17,22,19],[27,4,27,16],[27,24,27,27],[22,23,22,34],[26,31,26,34],[16,0,16,3],[16,4,16,16],[18,0,18,3],[18,4,18,16],[19,0,19,3],[19,4,19,16],[14,0,14,3],[14,4,14,16],[14,23,14,25],[15,0,15,3],[15,4,15,16],[12,20,12,22],[12,23,12,25],[13,20,13,22],[13,23,13,25],[13,27,13,34],[5,27,5,34],[6,15,9,17],[7,0,7,3],[7,4,7,14],[8,0,8,3],[5,0,6,3],[5,4,6,14],[5,15,5,17],[5,20,5,22],[5,23,5,25],[8,4,8,14],[8,27,11,34],[9,0,9,3],[9,4,9,14],[11,0,12,3],[11,4,12,19],[1,0,1,14],[1,28,1,34],[3,0,3,5],[3,7,3,11],[3,14,3,15],[3,26,3,28],[3,29,3,34]]}
[]
["ＴＶＣＭ　企画フェーズ仕様書[1次]",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,"No."]
[]
["○○○広告",null,null,null,null,null,"[","○○",null,null,null,null,"局","]","御中",null,null,null,null,null,null,null,null,null,null,null,"作成日：",null,null,{"$f":"TODAY()","v":"2018-05-22"}]
[]
["制作責任者",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,null,null,null,null,null,null,null,null,null,null,null,null,"\n"]
[]
["担当営業",null,null,null,"　 第○営業局　○○部：○○○○"]
["担当ＣＤ",null,null,null,"○CR局 ○○部：○○○○",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"〒1XX-XXXXX\n\n東京都\n\n"]
["担当ＣＰ",null,null,null,"○CRP局：○○○○"]
[]
["企画作業予定額"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," 連絡先：",null,null,null,"03-0000-0000　x-y@XXX.co.jp"]
["オリエン日",null,null,null,"  20   　  年　　　月　　　日",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," 担当者："]
["プレゼン日",null,null,null,"  20   　  年　　　月　　　日"]
["決済日",null,null,null,"  20   　  年　　　月　　　日"]
[]
["広告主"]
["商品名"]
[]
[]
[null,null,null,null,"内容",null,null,null,null,null,null,null,null,null,null,null,null,"発注",null,null,"確認\n(受注）",null,null,"備考"]
[1,null,null,null,"企画打ち合わせ"]
[2,null,null,null,"クリエイティブディレクター手配"]
[null,null,null,null,"コピーライター手配"]
[null,null,null,null,"プランナー手配"]
[null,null,null,null,"アートディレクター手配"]
[3,null,null,null,"企画プレゼン　コンテ　制作"]
[4,null,null,null,"企画プレゼン　企画書　制作"]
[5,null,null,null,"企画資料集め（写真・動画・音楽・タレント）"]
[null,null,null,null,"企画資料集め　他社事例（競合ＣＭ検索）"]
[6,null,null,null,"企画プレゼン（コンセプトビデオ・ビデオコンテ制作・映像資料編集）"]
[null,null,null,null,"企画プレゼン（プレゼン用音楽制作）"]
[7,null,null,null,"企画プレゼン　プリントアウト"]
[8,null,null,null,"企画時　見積作成"]
[9,null,null,null,"企画プレゼン立会い"]
[10,null,null,null,"その他"]
[null,null,null,null,"*資料はプレゼン後廃棄いたします。ご要望があれば、保管費を計上し1年間保管いたします。"]

{"sheet":"企画確認書第2次","index":1,"n_rows":39,"n_cols":43,"rows_kept":39,"cut":false,"hidden":false,"merged":[[36,0,36,3],[36,4,36,16],[36,24,36,27],[36,31,36,34],[37,0,37,3],[37,4,37,16],[37,24,37,27],[37,31,37,34],[34,0,34,3],[34,4,34,16],[34,24,34,27],[34,31,34,34],[35,0,35,3],[35,4,35,16],[35,24,35,27],[35,31,35,34],[31,31,31,34],[32,0,33,3],[32,4,32,16],[32,24,32,27],[32,31,32,34],[33,4,33,16],[33,24,33,27],[33,31,33,34],[29,0,29,3],[29,4,29,16],[29,24,29,27],[29,31,29,34],[30,0,31,3],[30,4,30,16],[30,24,30,27],[30,31,30,34],[31,4,31,16],[31,24,31,27],[27,4,27,16],[27,24,27,27],[27,31,27,34],[28,0,28,3],[28,4,28,16],[28,24,28,27],[28,31,28,34],[24,0,27,3],[24,4,24,16],[24,24,24,27],[24,31,24,34],[25,4,25,16],[25,24,25,27],[25,31,25,34],[26,4,26,16],[26,24,26,27],[26,31,26,34],[20,5,20,19],[22,4,22,16],[22,17,22,19],[22,20,22,22],[22,23,22,34],[23,0,23,3],[23,4,23,16],[23,24,23,27],[23,31,23,34],[16,0,16,3],[16,4,16,16],[18,0,18,3],[18,4,18,16],[19,0,19,3],[19,4,19,16],[12,27,12,34],[13,23,13,25],[14,0,14,3],[14,4,14,16],[14,23,14,25],[15,0,15,3],[15,4,15,16],[11,4,11,6],[11,7,11,13],[11,14,11,16],[11,17,11,19],[11,20,11,22],[11,23,11,25],[12,4,12,6],[12,7,12,13],[12,14,12,16],[12,17,12,19],[12,20,12,22],[12,23,12,25],[1,0,1,14],[1,28,1,34],[3,0,3,5],[3,7,3,11],[3,14,3,15],[3,26,3,28],[3,29,3,34],[5,0,6,3],[5,4,6,14],[5,15,5,17],[5,20,5,22],[5,23,5,25],[5,27,5,34],[6,15,8,17],[7,0,7,3],[7,4,7,14],[8,0,8,3],[8,4,8,14],[8,27,10,34],[10,0,12,3],[10,4,10,6],[10,7,10,13],[10,14,10,16],[10,17,10,19]]}
[]
["ＴＶＣＭ　企画フェーズ仕様書[2次]",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,"No."]
[]
["○○○広告",null,null,null,null,null,"[","○○",null,null,null,null,"局","]","御中",null,null,null,null,null,null,null,null,null,null,null,"作成日：",null,null,{"$f":"TODAY()","v":"2018-05-22"}]
[]
["制作責任者",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,null,null,null,null,null,null,null,null,null,null,null,null,"\n"]
[]
["担当営業",null,null,null,"　 第○営業局　○○部：○○○○"]
["担当ＣＤ",null,null,null,"○CR局 ○○部：○○○○",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"〒1XX-XXXXX\n\n東京都\n\n"]
[]
["企画見積額",null,null,null,"企画実費",null,null,null,null,null,null,null,null,null,"間接費",null,null,0.1]
[null,null,null,null,"人件費",null,null,null,null,null,null,null,null,null,"間接費",null,null,0.1,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,null," 連絡先：",null,null,null,"03-0000-0000　x-y@XXX.co.jp"]
[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,"  20   　  年　　　月　　　日"]
["プレゼン日",null,null,null,"  20   　  年　　　月　　　日"]
["決済日",null,null,null,"  20   　  年　　　月　　　日"]
[]
["広告主"]
["商品名"]
[]
[]
[null,null,null,null,"内容",null,null,null,null,null,null,null,null,null,null,null,null,"発注",null,null,"確認\n(受注）",null,null,"備考"]
[1,null,null,null,"企画打ち合わせ"]
[2,null,null,null,"クリエイティブディレクター手配"]
[null,null,null,null,"コピーライター手配"]
[null,null,null,null,"プランナー手配"]
[null,null,null,null,"アートディレクター手配"]
[3,null,null,null,"企画プレゼン　コンテ　制作"]
[4,null,null,null,"企画プレゼン　企画書　制作"]
[5,null,null,null,"企画資料集め（写真・動画・音楽・タレント）"]
[null,null,null,null,"企画資料集め　他社事例（競合ＣＭ検索）"]
[6,null,null,null,"企画プレゼン（コンセプトビデオ・ビデオコンテ制作・映像資料編集）"]
[null,null,null,null,"企画プレゼン（プレゼン用音楽制作）"]
[7,null,null,null,"企画プレゼン　プリントアウト"]
[8,null,null,null,"企画時　見積作成"]
[9,null,null,null,"企画プレゼン立会い"]
[10,null,null,null,"その他"]
[null,null,null,null,"*資料はプレゼン後廃棄いたします。ご要望があれば、保管費を計上し1年間保管いたします。"]

{"sheet":"【提出用】TVCM制作見積確認スケジュール(企画)","index":2,"n_rows":79,"n_cols":25,"rows_kept":79,"cut":false,"hidden":false,"merged":[[39,1,39,5],[39,7,39,8],[39,9,39,11],[42,1,42,22],[40,1,40,5],[40,7,40,8],[40,9,40,11],[40,12,40,16],[40,17,40,22],[41,1,41,5],[41,7,41,8],[41,9,41,11],[41,12,41,16],[41,17,41,22],[39,12,39,16],[39,17,39,22],[13,4,13,16],[14,4,14,16],[15,4,15,16],[28,4,28,16],[29,4,29,16],[18,4,18,16],[19,4,19,16],[20,4,20,16],[21,4,21,16],[22,4,22,16],[16,4,16,16],[24,4,24,16],[25,4,25,16],[26,4,26,16],[27,4,27,16],[38,17,38,22],[17,4,17,16],[30,4,30,16],[31,4,31,16],[32,4,32,16],[23,4,23,16],[33,4,33,16],[34,4,34,16],[35,4,35,16],[36,1,36,14],[38,1,38,5],[38,7,38,8],[38,9,38,11],[38,12,38,16],[1,19,1,22],[2,1,2,4],[2,5,2,6],[2,18,2,22],[1,1,1,7],[1,9,2,9],[1,10,2,17],[11,4,11,16],[12,4,12,16],[4,4,4,16],[5,4,5,16],[6,4,6,16],[7,4,7,16],[8,4,8,16],[9,4,9,16],[10,4,10,16]]}
[]
[null,"ＴＶＣＭ　制作確認スケジュール　[1次]",null,null,null,null,null,null,null,"題名","●●●●篇",null,null,null,null,null,null,null,"No.",11111]
[null,"スケジュール･種別",null,null,null,"ＴＶ-ＣＭ企画",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2018-05-22"}]
[]
[null,"月","日","曜","内　容",null,null,null,null,null,null,null,null,null,null,null,null,"P1","PM1","PA1","PA2","PA3","PA4",null,"【かんたんガイド・使用上の注意】"]
[null,"2018-05-01",{"$f":"B6","v":"2018-05-01"},{"$f":"get_aweekday()","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"mod_manhour_cal()","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},null,"◎このエクセルワークシートは、マクロの設定された特殊なものです。"]
[null,{"$f":"IF(C7=\"\",\"\",IF(DAY(C7)=1,C7,\"\"))","v":""},{"$f":"C6+1","v":"2018-05-02"},{"$f":"get_aweekday()","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"mod_manhour_cal()","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},null,"\n　必ずしも通常のワークシートと同様の使用感とはなっていないことに留意し、下記に沿って使用してください。"]
[null,{"$f":"IF(C8=\"\",\"\",IF(DAY(C8)=1,C8,\"\"))","v":""},{"$f":"C7+1","v":"2018-05-03"},{"$f":"get_aweekday()","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"mod_manhour_cal()","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},null,"◇入力したいスケジュール上の内容セルを選択して、「内容リスト」の項目をダブルクリックすると、その文字列が入力でき、"]
[null,{"$f":"IF(C9=\"\",\"\",IF(DAY(C9)=1,C9,\"\"))","v":""},"2018-05-04",{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"mod_manhour_cal()","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},null,"　 別シート「内容リスト設定(制作)」で設定した通りの「工数」が自動入力され、ページ最下部に「累計」が表示されます。"]
[null,"","2018-05-05",{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"mod_manhour_cal()","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},null,"◇スケジュール「内容」欄の工数自動入力対象となる「内容リスト」の単位は「、」で区切られるものと設定されています。"]
[null,"","2018-05-06",{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"mod_manhour_cal()","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},null,"◇スケジュールページの追加や削除は、全て「内容リスト」のボタンから行います。他のやり方はできません。しないでください。"]
[null,"","2018-05-07",{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"mod_manhour_cal()","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},null,"◇P1、PM1、PA1等「工数欄」の追加や削除も全て「内容リスト」のボタンから行います。"]
[null,"","2018-05-08",{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"mod_manhour_cal()","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},null,"◇別シート「内容リスト設定(制作)」で、「内容リスト」の文字列、「工数」、「P1」等の名称は、自由に設定できます。"]
[null,"","2018-05-09",{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"mod_manhour_cal()","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},null,"◇土日祝の工数倍率もこのシートで設定できます。"]
[null,"","2018-05-10",{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"mod_manhour_cal()","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},null,"◇スケジュールの日付(月セル、日セル、曜セル)は、全て「B6セルダブルクリック→カレンダーから選択」での入力となります。"]
[null,"","2018-05-11",{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"mod_manhour_cal()","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},null,"◆月セル、日セル、曜セルへの直接入力はできません。これらのセルは選択もできません。"]
[null,"","2018-05-12",{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"mod_manhour_cal()","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},null,"◆内容セルには全てマクロが設定されていますので、「前回入力取り消し」は一切できません。"]
[null,"","2018-05-13",{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"mod_manhour_cal()","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},null,"◆列や行の消去はできません。消去しようとしないでください。"]
[null,"","2018-05-14",{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"mod_manhour_cal()","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},null,"◇「内容リスト」からダブルクリック入力した後、工数を変更したい場合は、工数セルに直接手入力してください。"]
[null,"","2018-05-15",{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"mod_manhour_cal()","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},null,"◆ただし、内容セルに追加手入力すると、工数は自動計算にリセットされますので、ご注意ください。"]
[null,"","2018-05-16",{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"mod_manhour_cal()","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},null,"◆従って、内容セルに手入力する場合は、そのセルへの入力を全て完成させてから、工数を手入力する必要があります。"]
[null,"","2018-05-17",{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"mod_manhour_cal()","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},null,"◆そのようにして完成させた内容セルで追加入力やダブルクリックをすると、工数はリセットされますので、ご注意ください。"]
[null,"","2018-05-18",{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"mod_manhour_cal()","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},null,"◇単一の内容セルから別の単一内容セルへの「コピペ」は可能です。"]
[null,"","2018-05-19",{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"mod_manhour_cal()","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},null,"◆ただし、セルの「カット」を行うと不具合が起きますので、「セルカット」はしないでください。"]
[null,"","2018-05-20",{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"mod_manhour_cal()","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},null,"◇別シート「内容リスト設定」の【スケジュール作成例(制作)】から内容セルへは、複数選択セルのコピペが可能です。"]
[null,"","2018-05-21",{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"mod_manhour_cal()","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},null,"◆しかし複数の内容セルのコピペをすると不具合が起きますので行わないでください。"]
[null,"","2018-05-22",{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"mod_manhour_cal()","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},null,"◇土日祝セルの「グレイ」は、自動計算で色指定していますので、平日の白セルから単一セルコピペしてもグレイは保持されます。"]
[null,"","2018-05-23",{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"mod_manhour_cal()","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},null,"　 土日祝のグレイセルから平日セルに単一セルコピペしても、同様に白は保持されます。"]
[null,"","2018-05-24",{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"mod_manhour_cal()","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},null,"◇スケジュール表の開始日を任意の月の「1日」とすると、1ページにつきちょうど1ヶ月のスケジュールとすることができます。"]
[null,"","2018-05-25",{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"mod_manhour_cal()","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},null,"◆列や行の消去はできません。消去しようとしないでください。"]
[null,"","2018-05-26",{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"mod_manhour_cal()","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},null,"※(2018.5.21)不具合報告…調査中(使用PCに「Dropbox」等がインストールされている場合に起きる?)／次Ver.で改修予定。"]
[null,"","2018-05-27",{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"mod_manhour_cal()","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},null,"　「パスワード画面が表示されることがある。」→キャンセルを数回押すと消える。"]
[null,"","2018-05-28",{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"mod_manhour_cal()","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[null,"",{"$f":"IF(AND(DAY(C6)=1,IF(C33=\"\",1,DAY(C33+1)=1)),\"\",C33+1)","v":"2018-05-29"},{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"mod_manhour_cal()","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[null,"",{"$f":"IF(AND(DAY(C6)=1,IF(C34=\"\",1,DAY(C34+1)=1)),\"\",C34+1)","v":"2018-05-30"},{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"mod_manhour_cal()","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[null,{"$f":"IF(C36=\"\",\"\",IF(DAY(C36)=1,C36,\"\"))","v":""},{"$f":"IF(C35=\"\",\"\",IF(DAY(C35+1)=1,\"\",C35+1))","v":"2018-05-31"},{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"mod_manhour_cal()","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[null,{"$f":"mod_manhour_com()","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"累計",{"$f":"SUM(R6:R36)","v":{"$error":"#NAME?"}},{"$f":"SUM(S6:S36)","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[]
[]
[]
[]
[]
[null,1]
[]
[]
[]
[]
[]
[{"$f":"mod_manhour_cal()","v":{"$error":"#NAME?"}}]
[{"$error":"#NAME?"}]
[{"$error":"#NAME?"}]
[{"$error":"#NAME?"}]
[{"$error":"#NAME?"}]
[{"$error":"#NAME?"}]
[{"$error":"#NAME?"}]
[{"$error":"#NAME?"}]
[{"$error":"#NAME?"}]
[{"$error":"#NAME?"}]
[{"$error":"#NAME?"}]
[{"$error":"#NAME?"}]
[{"$error":"#NAME?"}]
[{"$error":"#NAME?"}]
[{"$error":"#NAME?"}]
[{"$error":"#NAME?"}]
[{"$error":"#NAME?"}]
[{"$error":"#NAME?"}]
[{"$error":"#NAME?"}]
[{"$error":"#NAME?"}]
[{"$error":"#NAME?"}]
[{"$error":"#NAME?"}]
[{"$error":"#NAME?"}]
[{"$error":"#NAME?"}]
[{"$error":"#NAME?"}]
[{"$error":"#NAME?"}]
[{"$error":"#NAME?"}]
[{"$error":"#NAME?"}]
[{"$error":"#NAME?"}]
[{"$error":"#NAME?"}]
[{"$error":"#NAME?"}]

{"sheet":"内容リスト設定(企画)","index":3,"n_rows":33,"n_cols":19,"rows_kept":33,"cut":false,"hidden":false,"merged":[[18,16,18,28],[26,16,26,28],[27,16,27,28],[13,16,13,28],[14,16,14,28],[15,16,15,28],[16,16,16,28],[17,16,17,28],[29,16,29,18],[6,16,6,18],[19,16,19,28],[20,16,20,28],[21,16,21,28],[22,16,22,28],[23,16,23,28],[24,16,24,28],[25,16,25,28],[28,16,28,28],[7,16,7,28],[8,16,8,28],[9,16,9,28],[10,16,10,28],[11,16,11,28],[12,16,12,28]]}
[]
[null,null,"制作内容リスト項目設定"]
[]
[null,null,"内容リスト設定","P1","P2","P3","PM1","PM2","PM3","PA1","PA2","PA3","PA4","PA5","PA6"]
[]
[null,null,"企画オリエンテーション",0.2,null,null,null,null,null,null,null,null,null,null,null,null,"土曜・日曜・祝日倍率　",2,"倍"]
[null,null,"企画仕様書作成",0.2,null,null,0,null,null,null,null,null,null,null,null,null,"【スケジュール作成例】\n※下記セルをスケジュール表にコピペすることもできます。"]
[null,null,"各所リサーチ",0.2,null,null,0.2,null,null,null,null,null,null,null,null,null,"企画オリエンテーション、企画仕様書作成"]
[null,null,"各所スケジュール調整",0.2,null,null,0.2,null,null,null,null,null,null,null,null,null,"各所リサーチ、各所スケジュール調整"]
[null,null,"見積書・工数スケジュール作成・企画仕様書案作成",0.5,null,null,0.5,null,null,null,null,null,null,null,null,null,"見積書・工数スケジュール作成・企画仕様書案作成"]
[null,null,"企画方針案提出・方針策定打合せ",0.2,null,null,0.2,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,"見積書・工数スケジュール・企画仕様書提出",0.2,null,null,null,null,null,null,null,null,null,null,null,null,"企画打合せ"]
[null,null,"企画打合せ",0.5,null,null,0.5,null,null,null,null,null,null,null,null,null,"企画打合せ、企画資料リサーチ・資料作成"]
[null,null,"企画資料リサーチ・資料作成",0,null,null,0.5,null,null,1.5,1,0,null,null,null,null,"企画資料リサーチ・資料作成"]
[null,null,"企画選定打合せ",0.2,null,null,0.2,null,null,0.2,null,null,null,null,null,null,"企画打合せ、企画資料リサーチ・資料作成"]
[null,null,"コンテ発注",0.2,null,null,0.5,null,null,0.5,null,null,null,null,null,null,"企画資料リサーチ・資料作成"]
[null,null,"プレゼン資料リサーチ・資料作成",null,null,null,0.5,null,null,1.5,1,null,null,null,null,null,"企画選定打合せ、企画資料リサーチ・資料作成"]
[null,null,"概算制作見積書作成",0.2,null,null,1,null,null,0.5,null,null,null,null,null,null,"コンテ発注、プレゼン資料リサーチ・資料作成"]
[null,null,"プレゼン資料作成・確認",0.5,null,null,1,null,null,1.5,1.5,null,null,null,null,null,"プレゼン資料リサーチ・資料作成"]
[null,null,"コンテ作業・確認",0.5,null,null,1,null,null,1.5,0,null,null,null,null,null,"プレゼン資料作成・確認、概算制作見積書作成"]
[null,null,"プレゼン",null,null,null,null,null,null,null,null,null,null,null,null,null,"プレゼン資料作成・確認、コンテ作業・確認"]
[null,null,"制作リサーチ・制作スケジュール調整",0.5,null,null,1,null,null,1,null,null,null,null,null,null,"プレゼン資料作成・確認、コンテ作業・確認"]
[null,null,"企画決定後打合せ",0.2,null,null,0.2,null,null,null,null,null,null,null,null,null,"プレゼン"]
[null,null,"事後企画見積書作成",0.2,null,null,0.2,null,null,null,null,null,null,null,null,null,"企画決定後打合せ"]
[null,null,"精算など事後処理業務",0.5,null,null,0.5,null,null,0.5,0.5,null,null,null,null,null,"事後企画見積書作成、精算など事後処理業務"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-05-21T17:34:51"]
[]
[0]
[0]