{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["初期設定","取説","def_yousi","def_hyusi","処理シート","カウンタ","Bak_chek"],"not_rendered":{"charts":0,"images":35,"macros":1,"external_links":0,"defined_names":18,"comments":3,"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":8,"n_cols":14,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,1,0,14],[2,3,10,8],[2,10,2,12],[2,13,2,14],[3,10,3,14],[4,10,4,14],[5,10,5,14],[6,10,6,14],[7,10,7,14],[8,10,8,14],[9,10,9,14],[10,10,10,14],[1,3,1,14]]}
[null,"工　 事　 報　 告　 書"]
[]
[null,null,null,null,null,null,null,null,null,null,"  写真　№",null,null,{"$f":"IF(ISERROR(INDIRECT(\"n\"&ROW()-10)+1),\"\",INDIRECT(\"n\"&ROW()-10)+1)","v":""}]
[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,"（ 説明 ）"]

{"sheet":"取説","index":1,"n_rows":589,"n_cols":6,"rows_kept":589,"cut":false,"hidden":false,"merged":[[492,1,492,10],[493,1,493,10],[494,1,494,10],[495,1,495,10],[487,1,487,10],[488,1,488,10],[489,1,489,10],[490,1,490,10],[491,1,491,10],[473,1,473,10],[474,1,474,10],[475,1,475,10],[476,1,476,10],[477,1,477,10],[1,0,1,10],[418,0,418,10],[419,0,419,10],[411,0,411,10],[59,0,59,10],[60,0,60,10],[61,0,61,10],[64,0,64,8],[188,0,188,8],[26,0,26,8],[62,0,62,8],[63,0,63,8],[9,0,9,8],[4,0,4,8],[5,0,5,8],[6,0,6,8],[7,0,7,8],[8,0,8,8],[547,5,547,10],[548,5,548,10],[542,0,542,10],[543,0,543,10],[346,0,346,10],[386,0,386,10],[388,0,388,10],[546,5,546,10],[545,5,545,10],[393,0,393,10],[410,0,410,10],[412,0,412,10],[413,0,413,10],[414,0,414,10],[579,5,579,10],[580,5,580,10],[569,5,569,10],[574,5,574,10],[575,5,575,10],[576,5,576,10],[577,5,577,10],[578,5,578,10],[570,5,570,10],[573,5,573,10],[566,5,566,10],[567,5,567,10],[568,5,568,10],[560,5,560,10],[562,5,562,10],[563,5,563,10],[564,5,564,10],[415,0,415,10],[416,0,416,10],[417,0,417,10],[565,5,565,10],[559,5,559,10],[550,5,550,10],[551,5,551,10],[549,5,549,10],[555,5,555,10],[556,5,556,10],[557,5,557,10],[558,5,558,10],[552,5,552,10],[553,5,553,10],[554,5,554,10],[472,1,472,10]]}
[]
["工事写真台帳取扱い説明"]
["【はじめに】"]
[]
["この台帳ファイルは、『表紙』・『台帳』シートを作成・編集し、別ファイルに保存します。"]
["A列は、写真名のデーターがありますので、削除しないでください。"]
["写真は、写真を貼り付ける部分（コメントで表示してある場所）をダブルクリックしてください。"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["【基本概念】"]
[]
["この工事写真台帳は、表紙と台帳シートを作るためのファイルですので、終了時は、表紙と台帳シートは削除されて"]
["保存されます。"]
[]
["終了するときは、かならず【用紙】タブの『終了ボタン』をおして終了してください。"]
["作成した表紙シートと台帳は、『台帳EXCEL保存』ボタンを押してから別ファイルに保存してください。"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["【メニューの表示の仕方】"]
["表示方法"]
["・台帳シートのセルをどこでも良いのでセルをクリックすると表示されます。"]
["・マウスを右クリックし、エクセルの右クリックメニュー最初"]
["の『写真台帳』→『写真操作メニュー』をクリックしてください。"]
["各メニューの紹介"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["写真の管理について"]
[]
["A列に貼り付けた横の写真の図名が入力されてあります。この名前をもとに写真を制御しますので、"]
["A列は、通常は、非表示になってます。"]
[]
["必ず、写真をはりつけるときは、セルを"]
["ダブルクリックしていただき、貼り付けて"]
["ください。"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["エクセルメニューの図の挿入操作すると"]
["写真の制御ができなくなります。"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["操作説明"]
["【1】","ファイルを開くとはじめに新規台帳シートの用紙が作成されます。"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["【2】","写真貼付け"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["【３】","写真ファイルの選択"]
[]
[null,"『前回の開いたフォルダ先』を開くか、PCのカレントフォルダ先を開くか選択して"]
[null,"『次へ』ボタンをクリックします。"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"ファイルを選択するとき、単独ファイル・複数ファイルを選択することも可能です。"]
[null,"（おすすめは、とりあえず全部貼り付けして、そのあと写真を削除するほうが楽です）"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["【４】","貼り付け完了！！　　"]
[]
[null,"写真は、設定により『撮影日順』　または、『ファイル名順』に並び替えて貼り付けられます。"]
[null,"撮影日は、ファイル情報から取得して、表示します。"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["行の削除・挿入"]
["【+行挿入】"]
[null,"緑の範囲のセル（写真の横のセル）して、『＋行挿入』ボタンを押すと"]
[null,"挿入したい枚数を選択するフォームが表示されますので、入力し、OKをおしてください。"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"そうすると選択した写真の上に入力した枚数分の貼り付け用紙が挿入されます。"]
["【-行削除】"]
[null,"削除したい行にある写真もしくは、行挿入と同じようにセルを選択して"]
[null,"『-行削除』ボタンを押す"]
[null,"（選択は、1つのセルまたは、写真限定です）"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"そうすると上の図のように削除する行を選択しますので、削除する範囲を確認していただいて"]
[null,"『はい』ボタンにて削除されます"]
[]
["【写真が貼り付いて無い行の削除】"]
[]
["写真と写真の間に写真が貼られてない空白の貼り付け範囲がある場合にその部分を削除します"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["この機能があるので、活用方法は、とりあえずフォルダ内の写真をすべて削除し、『-行削除』ボタンを押して"]
[]
["不要な写真を削除したあと、このボタンにて空白の部分を削除する手順をおすすめします"]
[]
[]
["上下写真移動"]
[]
["台帳シートの写真を上下に移動することができます。"]
[]
["①移動したい写真を選択します。"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["②『▲写真を上に移動』ボタン又は『▼写真を下に移動』ボタンで移動させることができます。"]
["移動した際に、写真横の撮影日・撮影場所・説明も上下に移動します。"]
[]
["　移動の設定を変更することができます。"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["入力補助"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["写真削除"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["●　","全ての写真を削除する"]
[null,"『全ての写真を削除する』オプションボタンをおして、『削除実行』ボタンを押す"]
[]
["●　","選択した写真のみ削除する"]
[null,"写真を選択後に『選択した写真のみ削除する』オプションボタンを押すと選択写真が削除されます"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["用紙の初期設定"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["写真の大きさを変更したいときは、初期設定シートのセルの大きさを変更してみてください。"]
["行・列の削除さえ行わなければ、正常に動作いたします。"]
[]
["保存と作成台帳開く"]
[]
["作成した台帳シートと表紙シートを保存します。"]
[]
[]
[null,null,null,null,null,"『台帳エクセル保存』をして保存します。"]
[null,null,null,null,null,"台帳シートと表紙シートのみ別ファイルにて保存します。"]
[null,null,null,null,null,"終了時には、削除されますので事前に保存処理してください。"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["『PDF保存』"]
[]
["　　　　　　　　表紙と台帳を印刷した状態のようにPDFにて保存します。"]
[null,"保存後には、PDFが表示されますので、ご確認ください。"]
[]
[null,null,null,null,null,"PDFにするとき、表紙も先頭に付けるか、台帳シートのみ"]
[null,null,null,null,null,"PDFするか選択できます。"]
[null,null,null,null,null,"表紙を印刷するときは、チェックをいれてください。"]
[null,null,null,null,null,"実行でPDFにするファイル名を入力するとPDFファイルが"]
[null,null,null,null,null,"完成です"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["『終了』"]

{"sheet":"def_yousi","index":2,"n_rows":8,"n_cols":14,"rows_kept":8,"cut":false,"hidden":true,"merged":[[13,10,13,14],[14,10,14,14],[19,10,19,14],[20,10,20,14],[17,10,17,14],[18,10,18,14],[0,1,0,14],[2,3,10,8],[2,10,2,12],[2,13,2,14],[3,10,3,14],[4,10,4,14],[5,10,5,14],[6,10,6,14],[7,10,7,14],[8,10,8,14],[9,10,9,14],[10,10,10,14],[12,13,12,14],[12,3,20,8],[12,10,12,12],[22,3,30,8],[22,10,22,12],[22,13,22,14],[23,10,23,14],[24,10,24,14],[25,10,25,14],[26,10,26,14],[27,10,27,14],[28,10,28,14],[29,10,29,14],[15,10,15,14],[16,10,16,14],[30,10,30,14]]}
[null,"工　 事　 報　 告　 書"]
[]
[null,null,null,"ここダブルクリック\nして写真貼付します。",null,null,null,null,null,null,"  写真　№",null,null,{"$f":"IF(ISERROR(INDIRECT(\"n\"&ROW()-10)+1),\"\",INDIRECT(\"n\"&ROW()-10)+1)","v":""}]
[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,"（ 説明 ）"]

{"sheet":"def_hyusi","index":3,"n_rows":27,"n_cols":8,"rows_kept":27,"cut":false,"hidden":true,"merged":[[26,4,26,6],[3,2,3,7],[6,4,6,6],[8,4,8,7],[10,4,10,7],[12,4,12,7]]}
[]
[]
[]
[null,null,"工　事　写　真　帳"]
[]
[]
[null,null,"工事番号"]
[]
[null,null,"現場名"]
[]
[null,null,"工事箇所"]
[]
[null,null,"現場住所"]
[]
[null,null,"工期",null,"着工",null,null,"から"]
[]
[null,null,null,null,"竣工",null,null,"まで"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"工事施工者"]

{"sheet":"処理シート","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"カウンタ","index":5,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["初回日付","最終日"]
["2012-07-24","2015-07-24"]

{"sheet":"Bak_chek","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}