{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["事件","訴訟委任状","期日請書","オプション","マニュアル"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":125,"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":5,"n_cols":28,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["事件番号","現況区分","事件区分","担当区分","事件呼名","依頼人氏名","ふりがな","生年月日","住所","電話番号","相談内容","関係者氏名","相手方氏名","相手方ふりがな","相手方生年月日","相手方住所","相手方電話番号","受任内容","相手方代理人","代理人住所","代理人電話番号","データフォルダ","裁判所名","裁判所事件番号","裁判所事件名","依頼人立場","次回期日","備考"]
[2100301,"未了","個人一般","正義太郎","甲山太郎（離婚）","甲山太郎","こうやまたろう","1962-04-01","000-0000○○市〇〇町○条○丁目○-○","000-0000-0000","離婚","甲山次郎","甲山花子","こうやまはなこ","1962-04-01","000-0000○○市〇〇町○条○丁目○-○","000-0000-0000","離婚請求","乙野花子","000-0000○○市〇〇町○条○丁目○-○","0000-00-0000","X:事件\\個人一般\\甲山太郎\\","旭川家庭裁判所","令和3年(X)第1号","離婚請求事件","原告","2021/8/6  10:00\n2021/9/6 11:00"]
[2100302,"未了","個人一般","正義太郎","甲山太郎（養育費）","甲山太郎","こうやまたろう","1962-04-01","000-0000○○市〇〇町○条○丁目○-○","000-0000-0000","養育費","乙山次郎","乙山花子","おつやまはなこ","1962-04-01","000-0000○○市〇〇町○条○丁目○-○","000-0000-0000","養育費請求","乙野花子","000-0000○○市〇〇町○条○丁目○-○","0000-00-0000","X:事件\\個人一般\\甲山太郎\\","旭川家庭裁判所","令和3年(X)第2号","養育費請求事件","被告"]
[2100201,"終了","刑事","人権次郎","甲川太郎","甲川太郎","こうかわたろう","1962-04-02","000-0000○○市〇〇町○条○丁目○-○","000-0000-0000","窃盗",null,"乙川太郎","おつかわたろう","1962-04-02","000-0000○○市〇〇町○条○丁目○-○","000-0000-0000",null,null,null,null,"X:事件\\個人一般\\甲川太郎\\"]
[2100101,"相談のみ","個人一般","愛情花子","甲野","甲野太郎\n甲野花子","こうのたろう\nこうのはなこ","1962/4/3\n1962/4/4","000-0000○○市〇〇町○条○丁目○-○","000-0000-0000","雇用問題",null,"乙野太郎\n乙野次郎\n乙野三郎","おつのたろう\nおつのじろう\nおつのさぶろう","1962/4/3\n1962/4/4\n1962/4/5","000-0000○○市〇〇町○条○丁目○-○","000-0000-0000"]

{"sheet":"訴訟委任状","index":1,"n_rows":33,"n_cols":7,"rows_kept":33,"cut":false,"hidden":false,"merged":[[18,0,18,6],[3,0,3,6],[32,1,32,6],[29,1,29,6],[30,1,30,6],[31,1,31,6],[27,1,27,6],[28,1,28,6]]}
[1]
[{"$f":"INDEX(事件[依頼人立場],事件行)","v":"原告"}]
[]
["訴　訟　委　任　状"]
[null,null,null,null,null,null,{"$f":"DBCS(TEXT(TODAY(),\"ggge年m月d日\"))","v":"令和３年８月９日"}]
[]
[null,null,null,"住　所",{"$f":"\"〒\"&DBCS(LEFT(SPLITF(INDEX(事件[住所],事件行),1),8))","v":"〒０００－００００"}]
[null,null,null,null,{"$f":"MID(SPLITF(INDEX(事件[住所],事件行),1),9,LEN(SPLITF(INDEX(事件[住所],事件行),1)))","v":"○○市〇〇町○条○丁目○-○"}]
[null,null,null,"委任者",{"$f":"SPLITF(INDEX(事件[依頼人氏名],事件行),0)","v":"甲山太郎"},null,"印"]
[]
["　私は，次の弁護士を訴訟代理人と定め，下記の事件に関する各事項を委任します。"]
[null,null,"弁護士",{"$f":"INDEX(事件[担当区分],事件行)","v":"正義太郎"}]
[null,null,"○○弁護士会所属"]
[null,null,"住　所","〒○○○－○○○○"]
[null,null,null,"○○市〇条○丁目○番○号○○ビル○階"]
[null,null,"法律太郎法律事務所"]
[null,null,"電　話","○○－○○○○－○○○○"]
[null,null,"ＦＡＸ","○○－○○○○－○○○○"]
["記"]
["第１","　事件"]
["　１","　相手方"]
[null,{"$f":"\"　\"&_xlfn.SWITCH(立場,\n\"原告\",\"被告\",\"被告\",\"原告\",\n\"申立人\",\"相手方\",\"相手方\",\"申立人\",\n\"債権者\",\"債務者\",\"債務者\",\"債権者\",\n\"控訴人\",\"被控訴人\",\"被控訴人\",\"控訴人\")\n&\"　\"\n&INDEX(事件[相手方氏名],事件行)","v":"　被告　甲山花子"}]
["　２","　裁判所"]
[null,{"$f":"\"　\"&SPLITF(INDEX(事件[裁判所名],事件行),0)","v":"　旭川家庭裁判所"}]
["　３","　事件の表示"]
[null,{"$f":"\"　\"&SPLITF(INDEX(事件[裁判所事件名],事件行),0)","v":"　離婚請求事件"}]
["第２","　委任事項"]
["　１","　原告がする一切の行為を代理する権限"]
["　２","　反訴の提起"]
["　３","　訴えの取下げ，和解，請求の放棄若しくは認諾又は訴訟参加若しくは訴訟引受けによる脱退"]
["　４","　控訴，上告若しくは上告受理の申立て又はこれらの取下げ"]
["　５","　手形訴訟，小切手訴訟又は少額訴訟の終局判決に対する異議の取下げ又はその取下げについての同意"]
["　６","　復代理人の選任"]

{"sheet":"期日請書","index":2,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":false,"merged":[[3,0,3,2],[7,0,7,4],[18,0,18,4]]}
[1]
[{"$f":"INDEX(事件[依頼人立場],事件行)","v":"原告"}]
[]
[{"$f":"DBCS(SPLITF(INDEX(事件[裁判所事件番号],事件行),0)&\"　\"&SPLITF(INDEX(事件[裁判所事件名],事件行),0))","v":"令和３年（Ｘ）第１号　離婚請求事件"}]
[{"$f":"_xlfn.SWITCH(立場,\n\"原告\",\"原告\",\"被告\",\"原告\",\n\"申立人\",\"申立人\",\"相手方\",\"申立人\",\n\"債権者\",\"債権者\",\"債務者\",\"債権者\",\n\"控訴人\",\"控訴人\",\"被控訴人\",\"控訴人\")","v":"原告"},{"$f":"IF($A5<>立場,\nINDEX(事件[相手方氏名],事件行),\nINDEX(事件[依頼人氏名],事件行))","v":"甲山太郎"}]
[{"$f":"_xlfn.SWITCH(立場,\n\"原告\",\"被告\",\"被告\",\"被告\",\n\"申立人\",\"相手方\",\"相手方\",\"相手方\",\n\"債権者\",\"債務者\",\"債務者\",\"債務者\",\n\"控訴人\",\"被控訴人\",\"被控訴人\",\"被控訴人\")","v":"被告"},{"$f":"IF($A6<>立場,\nINDEX(事件[相手方氏名],事件行),\nINDEX(事件[依頼人氏名],事件行))","v":"甲山花子"}]
[]
["口頭弁論期日請書"]
[]
[null,null,null,null,{"$f":"DBCS(TEXT(TODAY(),\"ggge年m月d日\"))","v":"令和３年８月９日"}]
[]
[]
[{"$f":"SPLITF(INDEX(事件[裁判所名],事件行),0)&\"　御中\"","v":"旭川家庭裁判所　御中"}]
[]
[]
[null,null,null,null,{"$f":"立場&\"訴訟代理人弁護士　\"&INDEX(事件[担当区分],事件行)","v":"原告訴訟代理人弁護士　正義太郎"}]
[]
[]
[{"$f":"\"　頭書の事件に付き，口頭弁論期日を\"&DBCS(TEXT(SPLITF(INDEX(事件[次回期日],事件行),0),\"ggge年m月d日[$-411]AM/PMh時mm分\"))&\"と指定告知されましたので，同日時に出頭します。\"","v":"　頭書の事件に付き，口頭弁論期日を令和３年９月６日午前１１時００分と指定告知されましたので，同日時に出頭します。"}]

{"sheet":"オプション","index":3,"n_rows":19,"n_cols":8,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
["リストアイテム"]
[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,"法人"]
[null,null,null,"国賠"]
[null,null,null,"償還"]
[]
[]
[]
["コマンド"]
[null,"並び替え",null,"実行"]

{"sheet":"マニュアル","index":4,"n_rows":26,"n_cols":10,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["事件データベース"]
[]
[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,"同一の事件番号に複数のデータ（依頼人氏名、相手方氏名、裁判所事件番号、相手方代理人氏名など）の入力が必要な場合は、同一セル内に改行（Alt+Enter）して入力してください。"]
[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,"変更履歴","2021-08-04","新規作成",null,null,null,null,null,"Ver.1.00"]