{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["記録","編集","運用パターン","記録表","QSL1","JARL向封筒印刷","設定、履歴"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":3,"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":46,"n_cols":14,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"ﾜｰｸｴﾘｱ"]
[null,null,"ﾚｺｰﾄﾞ番号",1728,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(FIND(\"/\",D7)),D7,LEFT(D7,FIND(\"/\",D7)-1))","v":0},{"$f":"IF(M4=M5,1,0)","v":1}]
[null,null,"交信日時(JST)","2023-03-09T23:06:00",null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(FIND(\"/\",H7)),H7,LEFT(H7,FIND(\"/\",H7)-1))","v":0}]
[null,null,null,null,null,null,null,"前回"]
[null,null,"相手局ｺｰﾙｻｲﾝ",null,null,null,"相手局ｺｰﾙｻｲﾝ"]
[null,null,"周波数(MHz)",null,null,null,"QSO回数",null,null,"日時","ﾚｺｰﾄﾞ番号","編集シートへ記録を呼出"]
[null,null,"電波型式",null,null,null,"LAST-QSO",null,"3回前>","2022-03-06T14:57:00",1651]
[null,null,"相手RS(T)ﾚﾎﾟｰﾄ",null,"<相手に送ったﾚﾎﾟｰﾄ",null,"　周波数(MHz)",null,"前々回>","2022-03-06T16:27:00",1657]
[null,null,"自局RS(T)ﾚﾎﾟｰﾄ",null,"<相手からもらったﾚﾎﾟｰﾄ",null,"　電波型式",null,"前回>","2023-03-04T16:32:00",1717]
[null,null,"相手QRA",null,null,null,"　相手QRA"]
[null,null,"相手QTH",null,null,null,"　相手QTH"]
[null,null,"相手JCC/JCG",null,null,null,"　相手JCC/JCG"]
[null,null,"相手GL",null,null,null,"　相手GL"]
[null,null,"メモ１",null,null,null,"　メモ１"]
[]
[null,null,"自局ｺｰﾙｻｲﾝ",null,"運用ﾊﾟﾀｰﾝ",1]
[null,null,"自局ｵﾍﾟﾚｰﾀ",null,null,null,"①レコード番号は自動で設定されます。"]
[null,null,"自局QTH",null,null,null,"　　　と　　のセルに交信に合った内容を入力し、交信日時更新+記録を押します。"]
[null,null,"自局JCC/JCG",null,null,null,"　　　と　　全部に入力しなくてもかまいません。"]
[null,null,"自局GL",null,null,null,"③交信日時は現在日時を押してもセットされますが、交信日時更新+記録を押せば"]
[null,null,"自局無線機",null,null,null,"　記録時に交信日時が自動でセットされます。"]
[null,null,"自局出力(W)",null,null,null,"④記録を押した場合は　　にセットされている交信日時のまま、記録されます。"]
[null,null,"自局ｱﾝﾃﾅ",null,null,null,"　交信しながら入力される方は交信日時更新+記録を押せば良いかも知れませんが"]
[null,null,"メモ２",null,null,null,"　一度メモ帳等に手で書いたものを、あとでこのソフトを使って入力する時は"]
[null,null,null,null,null,null,"　　　の交信日時をキーボードで修正し　　と　　を入力し記録を押すほうが"]
[null,null,"QSL送り",null,null,null,"　便利かも知れません。"]
[null,null,"QSL受け",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,"　また　　の右側に直近3回の記録が表示されます。"]
[null,null,null,null,null,null,"　※交信記録が無い場合は日時1900/01/00、ﾚｺｰﾄﾞ0が表示されます。"]
[null,null,null,null,null,null,"　<編集を押すと、左の番号のﾚｺｰﾄﾞを編集ｼｰﾄに呼び出せます。"]
[null,null,null,null,null,null,"⑦データ流用を押すと   内の相手QRA,相手QTH,相手JCC/JCG番号,手GLが今回データである"]
[null,null,null,null,null,null,"　　　内の相手QRA,相手QTH,相手JCC/JCG,相手GLにセットされます。"]
[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,"⑩QSL送り、QSL受けはJARL経由で交換する予定であるならJARL未等を入力するといかがでしょうか？"]
[null,null,null,null,null,null,"　ノーカードならノーカード、ダイレクトならダイレクト未などでいかがでしょうか？"]
[null,null,null,null,null,null,"　カード交換の話題が無ければ何も入力しなくて良いと思います。"]

{"sheet":"編集","index":1,"n_rows":29,"n_cols":11,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,"ﾚｺｰﾄﾞ番号",1717]
[null,null,"交信日時(JST)"]
[]
[null,null,"相手局ｺｰﾙｻｲﾝ",null,null,"①編集したいレコード番号を　　セルに入力し呼出を押します。"]
[null,null,"周波数(MHz)",null,null,"　記録シートの編集を押してここへ来た場合は呼出を押す必要はありません。"]
[null,null,"電波型式",null,null,"　該当の番号の交信記録が無い場合は　　内の表示が空白になります。"]
[null,null,"相手RS(T)ﾚﾎﾟｰﾄ",null,null,"②呼出したレコード番号の情報を削除したい場合は削除を押します。"]
[null,null,"自局RS(T)ﾚﾎﾟｰﾄ",null,null,"③呼出したレコード番号の情報を編集したい場合は"]
[null,null,"相手QRA",null,null,"　　　内の　　と　　セルで情報を入力または修正し書換を押します。"]
[null,null,"相手QTH",null,null,"④レコード番号を変更することはできません。"]
[null,null,"相手JCC/JCG"]
[null,null,"相手GL"]
[null,null,"メモ１"]
[]
[null,null,"自局ｺｰﾙｻｲﾝ"]
[null,null,"自局ｵﾍﾟﾚｰﾀ"]
[null,null,"自局QTH",null,null,null,null,"QSL送り",null,"QSL送り"]
[null,null,"自局JCC/JCG",null,null,null,null,"書換前",null,"書換後"]
[null,null,"自局GL",null,null,null,null,"JARL未",null,"印刷済","←QSL送り書換ボタンを押したらD28セルに入れる文字列を　　で指定してください。"]
[null,null,"自局無線機",null,null,null,null,null,null,{"$f":"CONCATENATE(\"押すとD28セルを\",J22,\"に書き換え、データファイルも更新します。\")","v":"押すとD28セルを印刷済に書き換え、データファイルも更新します。"}]
[null,null,"自局出力(W)",null,null,null,null,null,null,"誤って押してしまった場合は、H22セルに押す前の値が入っているので参考にしてください。"]
[null,null,"自局ｱﾝﾃﾅ",null,null,null,null,"QSL受け",null,"QSL受け"]
[null,null,"メモ２",null,null,null,null,"書換前",null,"書換後"]
[null,null,null,null,null,null,null,"JARL未",null,"●","←QSL受け書換ボタンを押したらD29セルに入れる文字列を　　で指定してください。"]
[null,null,"QSL送り",null,null,null,null,null,null,{"$f":"CONCATENATE(\"押すとD29セルを\",J27,\"に書き換え、データファイルも更新します\")","v":"押すとD29セルを●に書き換え、データファイルも更新します"}]
[null,null,"QSL受け",null,null,null,null,null,null,"誤って押してしまった場合は、H27セルに押す前の値が入っているので参考にしてください。"]

{"sheet":"運用パターン","index":2,"n_rows":51,"n_cols":11,"rows_kept":51,"cut":false,"hidden":false,"merged":[[40,3,40,4],[41,3,41,4],[42,3,42,4],[43,3,43,4],[50,3,50,4],[48,3,48,4],[49,3,49,4],[44,3,44,4],[45,3,45,4],[46,3,46,4],[47,3,47,4]]}
[]
[]
[null,null,1,2,3,4,5,6,7,8,9]
[null,"自局ｺｰﾙｻｲﾝ","JR5HJJ","JR5HJJ","JR5HJJ","JR5HJJ/5","JR5HJJ/5","JR5HJJ/5","JR5HJJ/5","JR5HJJ/5","JR5HJJ/5"]
[null,"自局ｵﾍﾟﾚｰﾀ","せんべえ１","せんべえ2","せんべえ3","せんべえ4","せんべえ5","せんべえ6","せんべえ7","せんべえ8","せんべえ9"]
[null,"自局QTH","徳島市","徳島市","徳島市","徳島市","徳島市","徳島市","徳島市","徳島市","徳島市"]
[null,"自局JCC/JCG",3701,3701,3701,3701,3701,3701,3701,3701,3701]
[null,"自局GL","PM74GB","PM74GB","PM74GB","PM74GB","PM74GB","PM74GB","PM74GB","PM74GB","PM74GB"]
[null,"自局無線機","TR-751","TS-50V","IC-S35","IC-S25","IC-S35","TR-751","IC-S35","ポケロク","FT-104"]
[null,"自局出力(W)",10,10,0.5,2.2999999999999998,1,10,5,0.02,1]
[null,"自局ｱﾝﾃﾅ","自作J型ｱﾝﾃﾅ(ｽﾘﾑｼﾞﾑ)6mH","逆L型ﾜｲﾔｱﾝﾃﾅ3mH","5/8λ2段(HV7CX)","ﾊﾝﾃﾞｨﾎｲｯﾌﾟ","ﾊﾝﾃﾞｨﾎｲｯﾌﾟ","10ELE YAGI 2mH","5/8λ2段(AZ510)1mH","自作V型ﾀﾞｲﾎﾟｰﾙ4mH","ﾊﾝﾃﾞｨﾎｲｯﾌﾟ"]
[null,"メモ２","自宅から送信１","自宅から送信2","自宅から送信3","自宅から送信4","自宅から送信5","自宅から送信6","自宅から送信7","自宅から送信8","自宅から送信9"]
[]
[]
[null,null,null,null,null,null,"ここで運用パターンが9種類登録できます。"]
[null,null,null,null,null,null,"記録シートから呼び出しできます。"]
[]
[null,"自局無線機","TR-751","TR-751"]
[null,"自局出力(W)",10,1]
[]
[null,"自局無線機","DR-420DX","DR-420DX","DR-420DX"]
[null,"自局出力(W)",20,10,3]
[]
[null,"自局無線機","FT-705","FT-705","FT-705","FT-705"]
[null,"自局出力(W)",5,3,1.5,0.5]
[]
[null,"自局無線機","IC-S25","IC-S25","IC-S25"]
[null,"自局出力(W)",7,4,0.5]
[]
[null,"自局無線機","IC-S35","IC-S35","IC-S35"]
[null,"自局出力(W)",5,2,0.5]
[]
[null,"自局無線機","FT-104","FT-104"]
[null,"自局出力(W)",1,0.1]
[]
[null,"自局無線機","ポケロク"]
[null,"自局出力(W)",0.02]
[]
[]
[]
[null,null,"自作J型ｱﾝﾃﾅ(ｽﾘﾑｼﾞﾑ)6mH"]
[null,null,"1/2λ(HV7CX)3mH"]
[null,null,"5/8λ2段(HV7CX)3mH"]
[null,null,"5ELE YAGI 2mH","ﾏｽﾌﾟﾛ144MHz6.5dB"]
[null,null,"8ELE YAGI 1.5m","ﾏｽﾌﾟﾛ430MHz10dB"]
[null,null,"10ELE YAGI 2mH","ﾀﾞｲﾔﾓﾝﾄﾞ144MHz11.6dBi"]
[null,null,"1/2λ(AZ510)1.5mH","ﾀﾞｲﾔﾓﾝﾄﾞﾓｰﾋﾞﾙﾎｲｯﾌﾟ2.15dBi"]
[null,null,"5/8λ2段(AZ510)1.5mH","ﾀﾞｲﾔﾓﾝﾄﾞﾓｰﾋﾞﾙﾎｲｯﾌﾟ5.5dBi"]
[null,null,"ﾊﾝﾃﾞｨﾎｲｯﾌﾟ"]
[null,null,"逆L型ﾜｲﾔｱﾝﾃﾅ3mH"]
[null,null,"自作V型ﾀﾞｲﾎﾟｰﾙ4mH"]

{"sheet":"記録表","index":3,"n_rows":64,"n_cols":26,"rows_kept":64,"cut":false,"hidden":false,"merged":[[16,7,17,12],[59,4,59,20],[60,4,60,20]]}
[]
[]
[]
[null,null,null,"ﾚｺｰﾄﾞ番号","交信日時","相手局",null,null,"電波型式","周波数","出力(W)","QSL","QSL","相手","相手","相手","相手","自局","自局","自局","自局","自局","自局","自局","ﾒﾓ1","ﾒﾓ2"]
[null,null,"自",null,null,null,null,null,null,null,null,"送り","受け","QRA","QTH","JCC/JCG","GL","ｵﾍﾟﾚｰﾀ","ｺｰﾙｻｲﾝ","RIG","ANT","QTH","JCC/JCG","GL"]
[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,{"$f":"IF('設定、履歴'!C10=1,\"★自動レコード更新あり★\",\"レコード更新無し\")","v":"レコード更新無し"}]
[]
[null,null,"DATA"]
[null,null,"CHK",{"$f":"IF(D5*D6+D5+D6=0,1,IF(D5<=D10,IF(D10<=D6,1,0),0))","v":1},{"$f":"IF(E5*E6+E5+E6=0,1,IF(E5<=E10,IF(E10<=E6,1,0),0))","v":1},{"$f":"IF(ISERROR(SEARCH(F6,F10)),0,1)","v":0},null,null,{"$f":"IF(ISERROR(SEARCH(I6,I10)),0,1)","v":0},{"$f":"IF(J5*J6+J5+J6=0,1,IF(J5<=J10,IF(J10<=J6,1,0),0))","v":1},{"$f":"IF(K5*K6+K5+K6=0,1,IF(K5<=K10,IF(K10<=K6,1,0),0))","v":1},{"$f":"IF(L6=\"\",1,IF(ISERROR(SEARCH(L6,L10)),0,1))","v":1},{"$f":"IF(M6=\"\",1,IF(ISERROR(SEARCH(M6,M10)),0,1))","v":1},{"$f":"IF(N6=\"\",1,IF(ISERROR(SEARCH(N6,N10)),0,1))","v":1},{"$f":"IF(O6=\"\",1,IF(ISERROR(SEARCH(O6,O10)),0,1))","v":1},{"$f":"IF(P6=\"\",1,IF(ISERROR(SEARCH(P6,P10)),0,1))","v":1},1,1,1,1,1,1,1,1,1,1]
[]
[null,null,"CHK-TOTAL",null,{"$f":"D11*E11*F11*I11*J11*K11*L11*M11*N11*O11*P11*Q11*R11*S11*T11*U11*V11*W11*X11*Y11*Z11","v":0},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,{"$f":"NOW()","v":"2023-05-01T19:35:45.960"}]
[]
[null,null,null,"ﾚｺｰﾄﾞ番号","交信日時","相手局","相手","自局","電波型式","周波数","空中線電力","QSL","QSL","相手","相手","相手","相手","自局","自局","自局","自局","自局","自局","自局","ﾒﾓ1","ﾒﾓ2"]
[null,null,null,null,null,null,"RS(T)","RS(T)",null,"(MHz)","(W)","送り","受け","QRA","QTH","JCC/JCG","GL","ｵﾍﾟﾚｰﾀ","ｺｰﾙｻｲﾝ","RIG","ANT","QTH","JCC/JCG","GL"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"JARL.COMのQSLカード転送チェック用文字列編集"]
[null,null,null,"1～20行",{"$f":"CONCATENATE(IF(ISERROR(FIND(\"/\",F22)),F22,LEFT(F22,FIND(\"/\",F22)-1)),\" \",IF(ISERROR(FIND(\"/\",F23)),F23,LEFT(F23,FIND(\"/\",F23)-1)),\" \",IF(ISERROR(FIND(\"/\",F24)),F24,LEFT(F24,FIND(\"/\",F24)-1)),\" \",IF(ISERROR(FIND(\"/\",F25)),F25,LEFT(F25,FIND(\"/\",F25)-1)),\" \",IF(ISERROR(FIND(\"/\",F26)),F26,LEFT(F26,FIND(\"/\",F26)-1)),\" \",IF(ISERROR(FIND(\"/\",F27)),F27,LEFT(F27,FIND(\"/\",F27)-1)),\" \",IF(ISERROR(FIND(\"/\",F28)),F28,LEFT(F28,FIND(\"/\",F28)-1)),\" \",IF(ISERROR(FIND(\"/\",F29)),F29,LEFT(F29,FIND(\"/\",F29)-1)),\" \",IF(ISERROR(FIND(\"/\",F30)),F30,LEFT(F30,FIND(\"/\",F30)-1)),\" \",IF(ISERROR(FIND(\"/\",F31)),F31,LEFT(F31,FIND(\"/\",F31)-1)),\" \",IF(ISERROR(FIND(\"/\",F32)),F32,LEFT(F32,FIND(\"/\",F32)-1)),\" \",IF(ISERROR(FIND(\"/\",F33)),F33,LEFT(F33,FIND(\"/\",F33)-1)),\" \",IF(ISERROR(FIND(\"/\",F34)),F34,LEFT(F34,FIND(\"/\",F34)-1)),\" \",IF(ISERROR(FIND(\"/\",F35)),F35,LEFT(F35,FIND(\"/\",F35)-1)),\" \",IF(ISERROR(FIND(\"/\",F36)),F36,LEFT(F36,FIND(\"/\",F36)-1)),\" \",IF(ISERROR(FIND(\"/\",F37)),F37,LEFT(F37,FIND(\"/\",F37)-1)),\" \",IF(ISERROR(FIND(\"/\",F38)),F38,LEFT(F38,FIND(\"/\",F38)-1)),\" \",IF(ISERROR(FIND(\"/\",F39)),F39,LEFT(F39,FIND(\"/\",F39)-1)),\" \",IF(ISERROR(FIND(\"/\",F40)),F40,LEFT(F40,FIND(\"/\",F40)-1)),\" \",IF(ISERROR(FIND(\"/\",F41)),F41,LEFT(F41,FIND(\"/\",F41)-1)))","v":"                   "}]
[null,null,null,"21～30行",{"$f":"CONCATENATE(IF(ISERROR(FIND(\"/\",F42)),F42,LEFT(F42,FIND(\"/\",F42)-1)),\" \",IF(ISERROR(FIND(\"/\",F43)),F43,LEFT(F43,FIND(\"/\",F43)-1)),\" \",IF(ISERROR(FIND(\"/\",F44)),F44,LEFT(F44,FIND(\"/\",F44)-1)),\" \",IF(ISERROR(FIND(\"/\",F45)),F45,LEFT(F45,FIND(\"/\",F45)-1)),\" \",IF(ISERROR(FIND(\"/\",F46)),F46,LEFT(F46,FIND(\"/\",F46)-1)),\" \",IF(ISERROR(FIND(\"/\",F47)),F47,LEFT(F47,FIND(\"/\",F47)-1)),\" \",IF(ISERROR(FIND(\"/\",F48)),F48,LEFT(F48,FIND(\"/\",F48)-1)),\" \",IF(ISERROR(FIND(\"/\",F49)),F49,LEFT(F49,FIND(\"/\",F49)-1)),\" \",IF(ISERROR(FIND(\"/\",F50)),F50,LEFT(F50,FIND(\"/\",F50)-1)),\" \",IF(ISERROR(FIND(\"/\",F51)),F51,LEFT(F51,FIND(\"/\",F51)-1)))","v":"         "}]
[]
[null,null,null,"交信記録集計ボタンを押した後、下のセルをコピーしてJARL.COMのWebサイトの検索文字列へペーストしてください。"]
[null,null,null,"1～20行","JR3OWV JR5QJR JS2HEY JH5ABR JQ3DZQ JH5DAH JH5SDZ JA5NNF JI5CTL JI5VSG JA5BXG JA5ICH JA5WPR JH5ABR JJ5GBT JL3AQX JA5ICH JR5GYB JH5BIZ JJ5OFE"]
[null,null,null,"21～30行","JR5YBV JO3RFX JI3WWB JE3UQM JA5OSL JJ5LXO JR5CVJ JJ5GBT JJ5GBT JG5RVQ"]
[]
[null,null,null,"JARL.COM　（JARL QSLビューローを経由して、QSLカードの転送ができる会員検索）"]
[null,null,null,"https://www.jarl.com/Page/Search/MemberSearch.aspx?Language=Jp"]

{"sheet":"QSL1","index":4,"n_rows":59,"n_cols":21,"rows_kept":59,"cut":false,"hidden":false,"merged":[[10,9,10,11],[13,14,13,21],[17,8,17,21]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"To Radio"]
[null,null,null,null,null,null,null,null,{"$f":"D12","v":"00:00:00"},null,{"$f":"MID(D12,1,1)","v":"0"},null,{"$f":"MID(D12,2,1)","v":""},null,{"$f":"MID(D12,3,1)","v":""},null,{"$f":"MID(D12,4,1)","v":""},null,{"$f":"MID(D12,5,1)","v":""},null,{"$f":"MID(D12,6,1)","v":""}]
[]
[null,null,"ﾚｺｰﾄﾞ番号",{"$f":"編集!D4","v":1717},null,null,null,null,"Confirming Our QSO"]
[null,null,"交信日時(JST)",{"$f":"編集!D5","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,"DATE(年/月/日)","TIME(JST)",null,null,"MHz",null,null,{"$f":"IF(D14=\"CW\",\"2WAY\",IF(D14=\"SSB\",\"2WAY\",IF(D14=\"FM\",\"2WAY\",IF(D14=\"AM\",\"2WAY\",IF(D14=\"USB\",\"2WAY\",IF(D14=\"LSB\",\"2WAY\",\"MODE\"))))))","v":"MODE"},null,null,null,{"$f":"IF(D14=\"CW\",\"RST\",\"RS\")","v":"RS"}]
[null,null,"相手局ｺｰﾙｻｲﾝ",{"$f":"編集!D7","v":"00:00:00"},null,null,null,null,{"$f":"D10","v":"00:00:00"},{"$f":"D10","v":"00:00:00"},null,null,{"$f":"D59","v":1.9},null,null,{"$f":"D14","v":0},null,null,null,{"$f":"E15","v":"0"}]
[null,null,"周波数(MHz)",{"$f":"編集!D8","v":0}]
[null,null,"電波型式",{"$f":"編集!D9","v":0},{"$f":"IF(ISERROR(FIND(\"CW\",D14)),2,3)","v":2},null,null,null,{"$f":"CONCATENATE(\"RIG  \",D28)","v":"RIG  0"},null,null,null,null,null,{"$f":"CONCATENATE(\"OUTPUT  \",IF(D29<=0.5,\"QRPp \",IF(D29<=5,\"QRP \",\"\")),D29,\" W\")","v":"OUTPUT  QRPp 0 W"}]
[null,null,"相手RS(T)ﾚﾎﾟｰﾄ",{"$f":"編集!D10","v":0},{"$f":"LEFT(D15,E14)","v":"0"},null,null,null,{"$f":"CONCATENATE(\"ANT  \",D30)","v":"ANT  0"}]
[null,null,"自局RS(T)ﾚﾎﾟｰﾄ",{"$f":"編集!D11","v":0},null,null,null,null,{"$f":"CONCATENATE(\"RMKS  \",D39)","v":"RMKS  TNX FB QSO"}]
[null,null,"相手QRA",{"$f":"編集!D12","v":0},null,null,null,null,{"$f":"IF(ISERROR(FIND(D36,D34)),\"PSE QSL\",\"QSL TNX！(^^)\")","v":"PSE QSL"}]
[null,null,"相手QTH",{"$f":"編集!D13","v":0},null,null,null,null,{"$f":"CONCATENATE(\"OP  \",D23,\"  \",D31)","v":"OP  0  0"}]
[null,null,"相手JCC/JCG",{"$f":"編集!D14","v":0}]
[null,null,"相手GL",{"$f":"編集!D15","v":0}]
[null,null,"メモ１",{"$f":"編集!D16","v":0}]
[]
[null,null,"自局ｺｰﾙｻｲﾝ",{"$f":"編集!D18","v":0}]
[null,null,"自局ｵﾍﾟﾚｰﾀ",{"$f":"編集!D19","v":0}]
[null,null,"自局QTH",{"$f":"編集!D20","v":0}]
[null,null,"自局JCC/JCG",{"$f":"編集!D21","v":0}]
[null,null,"自局GL",{"$f":"編集!D22","v":0}]
[null,null,"自局無線機",{"$f":"編集!D23","v":0}]
[null,null,"自局出力(W)",{"$f":"ROUND(編集!D24,3)","v":0}]
[null,null,"自局ｱﾝﾃﾅ",{"$f":"編集!D25","v":0}]
[null,null,"メモ２",{"$f":"編集!D26","v":0}]
[]
[null,null,"QSL送り",{"$f":"編集!D28","v":0}]
[null,null,"QSL受け",{"$f":"編集!D29","v":0}]
[]
[null,null,"QSL受けに","●","を含む時は"]
[null,null,"QSL TNX!(^^)を記載、違う時はPSE QSLを記載する。"]
[]
[null,null,"RMKSの記載は","TNX FB QSO","とする。"]
[]
[]
[]
[null,null,"周波数帯判定",{"$f":"IF(D13<3.5,1.9,0)","v":1.9}]
[null,null,null,{"$f":"IF(D13>1.9125,IF(D13<3.8,3.5,0),0)","v":0}]
[null,null,null,{"$f":"IF(D13>3.575,IF(D13<7,3.8,0),0)","v":0}]
[null,null,null,{"$f":"IF(D13>3.805,IF(D13<10,7,0),0)","v":0}]
[null,null,null,{"$f":"IF(D13>7.1,IF(D13<14,10,0),0)","v":0}]
[null,null,null,{"$f":"IF(D13>10.15,IF(D13<18,14,0),0)","v":0}]
[null,null,null,{"$f":"IF(D13>14.35,IF(D13<21,18,0),0)","v":0}]
[null,null,null,{"$f":"IF(D13>18.168,IF(D13<24,21,0),0)","v":0}]
[null,null,null,{"$f":"IF(D13>21.45,IF(D13<28,24,0),0)","v":0}]
[null,null,null,{"$f":"IF(D13>24.99,IF(D13<50,28,0),0)","v":0}]
[null,null,null,{"$f":"IF(D13>29.7,IF(D13<144,50,0),0)","v":0}]
[null,null,null,{"$f":"IF(D13>54,IF(D13<430,144,0),0)","v":0}]
[null,null,null,{"$f":"IF(D13>146,IF(D13<1200,430,0),0)","v":0}]
[null,null,null,{"$f":"IF(D13>440,IF(D13<2400,1200,0),0)","v":0}]
[null,null,null,{"$f":"IF(D13>1300,IF(D13<5600,2400,0),0)","v":0}]
[null,null,null,{"$f":"IF(D13>2450,IF(D13<10000,5600,0),0)","v":0}]
[null,null,null,{"$f":"SUM(D43:D58)","v":1.9}]

{"sheet":"JARL向封筒印刷","index":5,"n_rows":34,"n_cols":2,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"①角８封筒と洋２封筒の宛名書き等に使います。"]
[null,"　ボタンを押すとセットアップだけしますので、印刷はメニューバーからファイル－印刷で印刷してください。"]
[null,"②テキストボックスを使っているので位置を調整したい時は自由に調整できます。"]

{"sheet":"設定、履歴","index":6,"n_rows":44,"n_cols":9,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,"■はハードディスクの適当なフォルダでファイルを指定してください。フォルダは事前に作って置いてください。"]
[null,null,null,null,null,null,null,"■はクラッシュ対策です。使えるドライブでファイルを指定してください。"]
[null,"データファイル","a:\\logbook.dat",null,null,null,null,"←日誌データ本体です。"]
[null,"バップアップファイル","a:\\logbook.bak",null,null,null,null,"←データファイルに処理が実行された時、同じ内容で作られるコピーです。"]
[null,"最終レコード番号ファイル","a:\\logbook.rec",null,null,null,null,"←最後に記録したレコード番号を保存しておくファイルです。"]
[null,"指定最終レコード番号",3,null,null,null,null,"←レコード番号を強制設定する時に使います。"]
[null,"作業ファイル","a:\\logbook.wrk",null,null,null,null,"←データファイル処理中に生成されます。"]
[null,"予備バップアップファイル","a:\\logbook.yob",null,null,null,null,"←フロッピーディスクへのバックアップふぁいるです。データファイルのコピーです。"]
[null,"QSLカード印刷時のファイル更新",0,null,null,null,null,"←1にすると記録表シートの”下記レコード番号のＱＳＬカード印刷”を押した時に編集シートのＱＳＬ送り\n書換を押す処理も実行されます。使わない場合は0にしてください。"]
[]
[]
[null,null,null,null,null,null,null,null,"①上のファイルの指定が終わったら、このブックを使う最初にデータファイル初期化を1回だけ押してください。"]
[null,null,null,null,null,null,null,null,"　　上で指定したlogbook.datが指定されたフォルダに作られたことを確認してください。"]
[null,null,null,null,null,null,null,null,"②①同様に、このブックを使う最初にレコード番号ファイル初期化を1回だけ押してください。"]
[null,null,null,null,null,null,null,null,"　　上で指定したlogbook.recが指定されたフォルダに作られたことを確認してください。"]
[null,null,null,null,null,null,null,null,"このブックを使い始めたあとで①や②を実行する場合は業務日誌が使えなく恐れがあるため"]
[null,null,null,null,null,null,null,null,"logbook.dat　logbook.bak　logbook.recの控えを必ず取ってから①や②を実行してください。"]
[null,null,null,null,null,null,null,null,"③このブックのバージョンアップをしてもデータやレコード番号はそのまま使う必要があるため①や②の初期化処理は不要です。"]
[null,null,"最新バージョン","3A"]
[]
[null,null,"2007-07-15","張","開発開始"]
[null,null,"2008-02-08","張","VER1B","記録表シートのバグを修正"]
[null,null,"2008-03-21","張","VER1C","QSLのモード表示をMODEと2WAYに自動切換え"]
[null,null,"2009-01-18","張","VER1D","フロッピーディスクへのバックアップを追加"]
[null,null,"2009-01-18","張","VER1E","記録表シートから編集呼出を追加"]
[null,null,null,null,null,"条件検索で件数がオーバーした時に件数を表示できるようにした"]
[null,null,"2009-04-24","張","VER1F","JCC/JCG番号の書式を標準から文字列に変えた"]
[null,null,null,null,null,"記録表シートの上段3件をボタンにより編集画面に呼び出せるようにした"]
[null,null,"2009-05-01","張","VER1G","記録表シートで検索条件に相手QRAと相手QTHを追加、お助けボタンを追加した"]
[null,null,null,null,null,"記録シートの説明書きを見直し"]
[null,null,null,null,null,"編集シートでQSLの送り受けの文字列を任意設定できるようにした"]
[null,null,null,null,null,"その他もろもろ、少々の追加、変更"]
[null,null,"2009-06-01","張","VER1H","記録表シートで条件検索時に相手QRAまたは相手QTHがブランクになっていると"]
[null,null,null,null,null,"ピックアップできない誤りを修正"]
[null,null,"2009-10-17","張","VER1I","記録表シートで編集ボタンを追加"]
[null,null,"2010-02-13","張","VER1J","マクロで変数名が間違っていたものを見つけたので修正、若干のスピードアップがあったかも"]
[null,null,"2010-09-25","張","VER1K","QSLカードの出力表示不具合の修正"]
[null,null,"2010-10-10","張","VER2A","交信記録の検索機能で/移動地があってもなくても検索できるようにした"]
[null,null,null,null,null,"RSレポートにコンテストナンバーを入れてもQSLカードにはRSレポートまたはRSTレポートが入るようにした"]
[null,null,null,null,null,"記録表に集計したQSOに対するQSLカード一括印刷と一括印刷時にQSL送り書換の処理もできるようにした。"]
[null,null,"2012-09-02","張","VER2B","記録表シートで編集ボタンを追加"]
[null,null,"2023-01-07","張","VER3A","記録シートで過去の交信記録3回を表示し詳細を編集シートへ呼び出せるようにした"]
[null,null,null,null,null,"記録表シートの下余白にJARL.comのQSLカード転送用の文字列生成機能を追加"]