{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Описание","Настройки","QSO","Cabrillo","Setup"],"not_rendered":{"charts":0,"images":2,"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":35,"n_cols":3,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[]
[null,"За основу формирования Cabrillo-отчета вязты следующие документы:"]
[]
[null,"Cabrillo Specification V3. Last update: 26 December 2018"]
[null,"https://wwrof.org/cabrillo/cabrillo-specification-v3/"]
[]
[null,"Cabrillo QSO Templates. Last update: 21 September 2018"]
[null,"http://wwrof.org/cabrillo/cabrillo-qso-templates/"]
[]
[null,"Алгорим работы с таблицей следующий:"]
[null,"0. Не забываем разрешить запуск макросов, вверху таблицы."]
[]
[]
[]
[null,"1. На листе \"Настройки\" заполняем параметры, касающиеся соревнований. Все поля заполнять не обязательно."]
[null,null,"Важные и не заполненные поля выделяются цветом."]
[]
[null,"2. На листе \"QSO\" нажимаем кнопку \"Сформировать шаблон\". В результате появляется подготовленная таблица для ввода данных о проведенных связях."]
[null,null,"ВНИМАНИЕ!!! Если у Вас на листе были данные по проведенным связям, по нажатию кнопки \"Сформировать шаблон\", все данные будут удалены."]
[]
[null,"3. Вводим данные о проведенных в ходе соревнования связях"]
[null,null,"ВНИМАНИЕ!!! Вид модуляции может быть обозначен только 2-мя символами. Желательно выбирать стандартный из предлагаемого списка."]
[]
[null,"4. После ввода всех данных нажимаем кнопку \"Создать Cabrillo отчет\""]
[]
[null,"5. Визуально оцениваем получившийся отчет. Если нет явных ошибок, то нажимаем кнопку \"Сохранить текущий отчет\"."]
[null,null,"Выбираем папку, куда хотим сохранить отчет и нажимаем кнопку \"Выбрать папку\"."]
[]
[null,"Все."]
[null,"Отчет сформирован в указанной папке, о чем Вас уведомят."]
[]
[]
[]
[null,"УБЕДИТЕЛЬНАЯ ПРОСЬБА!!!"]
[null,"Для сохранения работоспособности скриптов, на листах \"Настройки\" и \"Setup\" не удалять строки и не вставлять новые."]

{"sheet":"Настройки","index":1,"n_rows":34,"n_cols":6,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[null,"Общие настройки протокола работы в соревнованиях"]
[]
[null,"ПАРАМЕТР ЗАГОЛОВКА",null,"ЗНАЧЕНИЕ","ВОЗМОЖНЫЕ ВАРИАНТЫ ЗНАЧЕНИЙ","ОПИСАНИЕ"]
[]
[null,"ДАТА:",null,"2019-03-21",null,"Дата проведения соревнований в формате ГГГГ-ММ-ДД"]
[null,"CALLSIGN:",null,"UN7FGO",null,"Позывной радиостанции участника."]
[null,"CONTEST:",null,"OPEN UN PV UHF CONTEST 1tur",null,"Наименование соревнования."]
[null,"CATEGORY-ASSISTED:",null,null,"NON-ASSISTED, ASSISTED","Категория по наличию помошников."]
[null,"CATEGORY-BAND:",null,"ALL","ALL, 160M, 80M, 2M, 432, 1.2G, 2.3G ","Категория по используемым диапазонам. Может быть оговорена правилами соревнований."]
[null,"CATEGORY-MODE:",null,"FM","SSB, CW, RTTY, FM, DG, MIXED","Категория по виду модуляции."]
[null,"CATEGORY-OPERATOR:",null,"SINGLE-OP","SINGLE-OP, MULTI-OP, CHECKLOG","Категория по типу операторов (один, много, контроллер)."]
[null,"CATEGORY-POWER:",null,null,"HIG, LOW, QRP","Категория по мощности передатчика (HIG - 100+ ватт, LOW - <=100 ватт, QRP - <=10 ватт)."]
[null,"CATEGORY-STATION:",null,"FIXED","FIXED, MOBILE, PORTABLE","Категория по типу радиостанции."]
[null,"CATEGORY-TIME:",null,null,"6-HOURS, 12-HOURS, 24-HOURS","Категория по времени участия в соревнованиях."]
[null,"CATEGORY-TRANSMITTER:",null,null,"ONE, TWO, LIMITED, UNLIMITED, SWL","Категория по количеству передатчиков."]
[null,"CATEGORY-OVERLAY:",null,null,"JR-19, JR-13, CLASSIC, ROOKIE, TB-WIRES, NOVICE-TECH","Категория оператора. Оговаривается условиями соревнований."]
[null,"CERTIFICATE:",null,null,"YES | NO","Хотите ли получить бумажный сертификат об участии в соревнованиях?"]
[null,"CLAIMED-SCORE:",null,null,null,"Заявляемое количество очков в виде целого числа."]
[null,"CLUB:",null,null,null,"Наименование радиолюбительского клуба, для подсчета командных очков."]
[null,"CREATED-BY:",null,"XLS-CC-0.1",null,"Наименование программы, которая сформировала файл отчета (EXCEL Cabrillo Creater)."]
[null,"EMAIL:",null,"un7fgo@gmail.com",null,"Контактный адресс электронной почты."]
[null,"LOCATION:",null,"MO82LG59CX",null,"Местоположение радиостанции (QTH-локатор, RDA, KDA и т.д. в зависимости от типа соревнований)"]
[null,"NAME:",null,"Кузьмичёв Геннадий Геннадьевич",null,"Имя оператора, не более 75 символов"]
[null,"ADDRESS:",null,"140006, Павлодарская обл., г.Павлодар, ул.Лермонтова 96/1",null,"Почтовый адрес. Допускается до 6 строк, каждая не длиннее 45 символов."]
[null,"ADDRESS:"]
[null,"ADDRESS:"]
[null,"ADDRESS-CITY: ",null,null,null,"Дополнительно - название города."]
[null,"ADDRESS-STATE-PROVINCE:",null,null,null,"Дополнительно - название области или провинции."]
[null,"ADDRESS-POSTALCODE:",null,null,null,"Дополнительно - почтовый индекс."]
[null,"ADDRESS-COUNTRY:",null,null,null,"Дополнительно - название страны."]
[null,"OPERATORS:",null,null,null,"Для коллективных радиостанций, позывные операторов, разделенные пробелом. Не более 75 символов."]
[null,"OFFTIME:",null,null,null,"Время начала и окончания перерыва в работе радиостанции, в формате yyyy-mm-dd nnnn yyyy-mm-dd nnnn."]
[null,"SOAPBOX:",null,"ALINCO DR-605 + LY2SS MOXON 144/430 antenna",null,"Комментарий. Не длиннее 75 символов."]
[null,"X-COMMENT:"]

{"sheet":"QSO","index":2,"n_rows":55,"n_cols":9,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
["Номер","Дата","Диаппазон","Модуляция","Время\nЧЧММ","Принятый позывной","Принятый рапорт","Принятый номер","Отправленный рапорт"]
[" 1","2019-03-21","144","FM","0500","UN7FO","59","3","59"]
[" 2","2019-03-21","144","FM","0501","UN8FR","59","2","59"]
[" 3","2019-03-21","430","FM","0503","UN8FR","59","5","59"]
[" 4","2019-03-21","70","FM","0503","UN8FR","59","6","59"]
[" 5","2019-03-21","70","FM","0510","UN8FF","59","7","59"]
[" 6","2019-03-21","144","FM","0518","UN7FO","59","9","59"]
[" 7","2019-03-21","430","FM","0519","UN8FR","59","14","59"]
[" 8","2019-03-21","70","FM","0520","UN8FF","59","14","59"]
[" 9","2019-03-21","70","FM","0522","UN8FR","59","17","59"]
[" 10","2019-03-21","144","FM","0522","UN8FR","59","18","59"]
[" 11","2019-03-21","144","FM","0530","UN7FO","59","13","59"]
[" 12","2019-03-21","144","FM","0531","UN8FR","59","22","59"]
[" 13","2019-03-21","70","FM","0535","UN8FR","59","27","59"]
[" 14","2019-03-21","70","FM","0535","UN8FF","59","23","59"]
[" 15","2019-03-21","430","FM","0536","UN8FR","59","28","59"]
[" 16","2019-03-21","144","FM","0545","UN8FR","59","30","59"]
[" 17","2019-03-21","430","FM","0546","UN8FR","59","31","59"]
[" 18","2019-03-21","70","FM","0546","UN8FR","59","32","59"]
[" 19","2019-03-21","144","FM","0547","UN7FO","59","20","59"]
[" 20","2019-03-21","70","FM","0548","UN8FF","59","32","59"]
[" 21","2019-03-21","","FM","","","59","","59"]
[" 22","2019-03-21","","FM","","","59","","59"]
[" 23","2019-03-21","","FM","","","59","","59"]
[" 24","2019-03-21","","FM","","","59","","59"]
[" 25","2019-03-21","","FM","","","59","","59"]
[" 26","2019-03-21","","FM","","","59","","59"]
[" 27","2019-03-21","","FM","","","59","","59"]
[" 28","2019-03-21","","FM","","","59","","59"]
[" 29","2019-03-21","","FM","","","59","","59"]
[" 30","2019-03-21","","FM","","","59","","59"]
[" 31","2019-03-21","","FM","","","59","","59"]
[" 32","2019-03-21","","FM","","","59","","59"]
[" 33","2019-03-21","","FM","","","59","","59"]
[" 34","2019-03-21","","FM","","","59","","59"]
[" 35","2019-03-21","","FM","","","59","","59"]
[" 36","2019-03-21","","FM","","","59","","59"]
[" 37","2019-03-21","","FM","","","59","","59"]
[" 38","2019-03-21","","FM","","","59","","59"]
[" 39","2019-03-21","","FM","","","59","","59"]
[" 40","2019-03-21","","FM","","","59","","59"]
[" 41","2019-03-21","","FM","","","59","","59"]
[" 42","2019-03-21","","FM","","","59","","59"]
[" 43","2019-03-21","","FM","","","59","","59"]
[" 44","2019-03-21","","FM","","","59","","59"]
[" 45","2019-03-21","","FM","","","59","","59"]
[" 46","2019-03-21","","FM","","","59","","59"]
[" 47","2019-03-21","","FM","","","59","","59"]
[" 48","2019-03-21","","FM","","","59","","59"]
[" 49","2019-03-21","","FM","","","59","","59"]
[" 50","2019-03-21","","FM","","","59","","59"]

{"sheet":"Cabrillo","index":3,"n_rows":41,"n_cols":1,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
["START-OF-LOG: 3.0"]
["CALLSIGN: UN7FGO"]
["CONTEST: OPEN UN PV UHF CONTEST 1tur"]
["CATEGORY-BAND: ALL"]
["CATEGORY-MODE: FM"]
["CATEGORY-OPERATOR: SINGLE-OP"]
["CATEGORY-STATION: FIXED"]
["CREATED-BY: XLS-CC-0.1"]
["EMAIL: un7fgo@gmail.com"]
["LOCATION: MO82LG59CX"]
["NAME: Кузьмичёв Геннадий Геннадьевич"]
["ADDRESS: 140006, Павлодарская обл., г.Павлодар, ул.Лермонтова 96/1"]
["SOAPBOX: ALINCO DR-605 + LY2SS MOXON 144/430 antenna"]
["QSO: 144   FM 2019-03-21 0500 UN7FGO        59  1      UN7FO         59  3      0"]
["QSO: 144   FM 2019-03-21 0501 UN7FGO        59  2      UN8FR         59  2      0"]
["QSO: 430   FM 2019-03-21 0503 UN7FGO        59  3      UN8FR         59  5      0"]
["QSO: 70    FM 2019-03-21 0503 UN7FGO        59  4      UN8FR         59  6      0"]
["QSO: 70    FM 2019-03-21 0510 UN7FGO        59  5      UN8FF         59  7      0"]
["QSO: 144   FM 2019-03-21 0518 UN7FGO        59  6      UN7FO         59  9      0"]
["QSO: 430   FM 2019-03-21 0519 UN7FGO        59  7      UN8FR         59  14     0"]
["QSO: 70    FM 2019-03-21 0520 UN7FGO        59  8      UN8FF         59  14     0"]
["QSO: 70    FM 2019-03-21 0522 UN7FGO        59  9      UN8FR         59  17     0"]
["QSO: 144   FM 2019-03-21 0522 UN7FGO        59  10     UN8FR         59  18     0"]
["QSO: 144   FM 2019-03-21 0530 UN7FGO        59  11     UN7FO         59  13     0"]
["QSO: 144   FM 2019-03-21 0531 UN7FGO        59  12     UN8FR         59  22     0"]
["QSO: 70    FM 2019-03-21 0535 UN7FGO        59  13     UN8FR         59  27     0"]
["QSO: 70    FM 2019-03-21 0535 UN7FGO        59  14     UN8FF         59  23     0"]
["QSO: 430   FM 2019-03-21 0536 UN7FGO        59  15     UN8FR         59  28     0"]
["QSO: 144   FM 2019-03-21 0545 UN7FGO        59  16     UN8FR         59  30     0"]
["QSO: 430   FM 2019-03-21 0546 UN7FGO        59  17     UN8FR         59  31     0"]
["QSO: 70    FM 2019-03-21 0546 UN7FGO        59  18     UN8FR         59  32     0"]
["QSO: 144   FM 2019-03-21 0547 UN7FGO        59  19     UN7FO         59  20     0"]
["QSO: 70    FM 2019-03-21 0548 UN7FGO        59  20     UN8FF         59  32     0"]
["END-OF-LOG:"]
[""]
[""]
[""]
[""]
[""]
[""]
[""]

{"sheet":"Setup","index":4,"n_rows":16,"n_cols":2,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Общие настройки программы"]
[]
["Begin_Log","START-OF-LOG: 3.0"]
["End_Log","END-OF-LOG:"]
["QSO в шаблоне",50]
["Папка сохранения отчета","D:\\Dropbox\\"]
["Расширение для файла отчета",".log"]
[]
[]
[]
[]
["Виды модуляции:","FM"]
[null,"PH"]
[null,"CW"]
[null,"RY"]
[null,"DG"]