__config SHEET START
Notes: (blank) (Editable) (Editable) (VBA Hard-coded) (VBA Hard-coded) (VBA Hard-coded or Editable - TBD) (Editable) (Editable) (Editable)
Header: (blank) Update Time Type Unique ID/Key/Var Range/Location Value Actual VBA wording Logical Name Note
__map_sheet_header_rows_avoid "Worksheets(""__map"").Rows(""1:2"")" Inform VBA scrlipts where editable headers are and ignore the headers
__map_sheet_id_column "Worksheets(""__map"").Columns(""E:E"")"
__map_sheet_range_column "Worksheets(""__map"").Columns(""F:F"")"
__map_sheet_value_column "Worksheets(""__map"").Columns(""G:G"")"
__config SHEET END
__map SHEET START
Notes: (blank) (Editable) (Editable) (VBA Hard-coded) (Ref. by VBA) (Ref. by VBA) (Editable) (Editable)
Header: (blank) Update Time Value Type Unique ID/Key/Var Value Variable Value Descriptions Actual VBA wording
Worksheet ytSubDL_VBA_subDLsheet_sheet "Worksheets(""subDL"")" Video sheet wsVideo / VIDEO_SHEET_NUMBER
Range ytSubDL_VBA_subDLsheet_video_id "Worksheets(""subDL"").Columns(""A:A"")" Video ID / row-selection column VIDEO_COL_ID
Range ytSubDL_VBA_subDLsheet_process_forceStop "Worksheets(""subDL"").Columns(""B:B"")"
Range ytSubDL_VBA_subDLsheet_process_parameter "Worksheets(""subDL"").Columns(""C:C"")" Parameters for subtile download operation
Range ytSubDL_VBA_subDLsheet_process_already "Worksheets(""subDL"").Columns(""D:D"")" Whether or not any subtitles for given video has been downloaded before
Range ytSubDL_VBA_subDLsheet_video_url "Worksheets(""subDL"").Columns(""E:E"")" Video URL videoUrl / VIDEO_COL_URL
Range ytSubDL_VBA_subDLsheet_channel "Worksheets(""subDL"").Columns(""G:G"")" Channel vidChannel / VIDEO_COL_CHANNEL
Range ytSubDL_VBA_subDLsheet_medium "Worksheets(""subDL"").Columns(""H:H"")" Medium vidMedium / VIDEO_COL_MEDIUM
Range ytSubDL_VBA_subDLsheet_program_name "Worksheets(""subDL"").Columns(""I:I"")" Program vidProgrameName / VIDEO_COL_PROGRAM
Range ytSubDL_VBA_subDLsheet_title "Worksheets(""subDL"").Columns(""J:J"")" Title vidTitle / VIDEO_COL_TITLE
Range ytSubDL_VBA_subDLsheet_subLang_normal_zh_hant "Worksheets(""subDL"").Columns(""K:K"")" Normal Chinese Traditional normalZhHantResult / VIDEO_COL_NORMAL_ZH_HANT
Range ytSubDL_VBA_subDLsheet_subLang_normal_zh_hans "Worksheets(""subDL"").Columns(""L:L"")" Normal Chinese Simplified normalZhHansResult / VIDEO_COL_NORMAL_ZH_HANS
Range ytSubDL_VBA_subDLsheet_subLang_normal_en "Worksheets(""subDL"").Columns(""M:M"")" Normal English normalEnResult / VIDEO_COL_NORMAL_EN
Range ytSubDL_VBA_subDLsheet_subLang_auto_zh_hant "Worksheets(""subDL"").Columns(""N:N"")" Auto Chinese Traditional autoZhHantResult / VIDEO_COL_AUTO_ZH_HANT
Range ytSubDL_VBA_subDLsheet_subLang_auto_zh_hans "Worksheets(""subDL"").Columns(""O:O"")" Auto Chinese Simplified autoZhHansResult / VIDEO_COL_AUTO_ZH_HANS
Range ytSubDL_VBA_subDLsheet_subLang_auto_en "Worksheets(""subDL"").Columns(""P:P"")" Auto English autoEnResult / VIDEO_COL_AUTO_EN
Variable ytSubDL_VBA_xlsm_foldPath G:\ytSubDL_VBA\Script\ Folder path for xlsm with VBA script
Variable ytSubDL_VBA_log_fileName ytSubDL_VBA_log.log File name for log of xlsm with VBA script
Variable ytSubDL_VBA_log_foldPath G:\ytSubDL_VBA\Script\ Folder path for log of xlsm with VBA script
Variable (may or may not be used by any VBA modules) ytSubDL_VBA_subDLer_fileName ytSubDL_VBA_worker_log.log File name for log of sub downloader VBA script (worker script)
Variable (may or may not be used by any VBA modules) ytSubDL_VBA_subDLer_log_foldPath G:\ytSubDL_VBA\Script\ Folder path for sub downloader VBA script (worker script)
Variable ytSubDL_VBA_log_ctriErrMsg_fileName ytSubDL_VBA_ctriErrMsg.log File name for crtical error message from VBA controller script
Variable ytSubDL_VBA_log_ctriErrMsg_foldPath G:\ytSubDL_VBA\Script\ Folder path for crtical error message from VBA controller script
Variable ytSubDL_VBA_sub_foldPath G:\ytSubDL_VBA\Subtitle\ Folder path for subtitles downloaded
Variable ytSubDL_VBA_yt-dlp_log_fileName ytSubDL_VBA_yt-dlp_log.log Folder path for yt-dlp log
Variable ytSubDL_VBA_yt-dlp_exe_filePath C:\yt-dlp.exe yt-dlp executable path ytDlpPATH
Variable ytSubDL_VBA_logExpert_exe_filePath C:\Program Files (x86)\LogExpert\LogExpert.exe LogExpert executable path logExpertPath
Parameter parmLogExpert 1 1=auto launch and close LogExpert
Parameter parmReDLsub 0 "0=don't re-DL sub, 1=re-DL sub"
Parameter parmSubLangDL 1 "1=DL zh only, 2=DL en only, 0=DL all lang"
Parameter paramSubDLfoldPath 0 "1=""$ytSubDL_VBA_sub_foldPath$\$vidChannel$\$vidProgrameName$\"" |~| 2=""$ytSubDL_VBA_sub_foldPath$\""" """"" around folder path, |~| as delimiter, $ refers to name of VBA variable"
__map SHEET END
__subDL SHEET START
"(rule: paramA=""1"" |~| paramB=""0"")"
VideoID ForceStop Parameter Processed? $videoUrl $subDir $vidChannel $vidMedium $vidProgrameName $vidTitle $normalZhHantResult $normalZhHansResult $normalEnResult $autoZhHantResult $autoZhHansResult $autoEnResult
vidNo1 https://www.youtube.com/watch?v=EG8rIcfyDQU G:\ytSubDL\Subtitles\ FayFan TV Monnn happyTITLE 1
vidNo2 https://www.youtube.com/watch?v=EG8rIcfyDQU G:\ytSubDL\Subtitles\ FayFan TV Monnn happyTITLE 2
vidNo3 https://www.youtube.com/watch?v=EG8rIcfyDQU G:\ytSubDL\Subtitles\ FayFan TV Monnn happyTITLE 3
vidNo4 https://www.youtube.com/watch?v=EG8rIcfyDQU G:\ytSubDL\Subtitles\ FayFan TV Monnn happyTITLE 4
vidNo5 https://www.youtube.com/watch?v=EG8rIcfyDQU G:\ytSubDL\Subtitles\ FayFan TV Monnn happyTITLE 5
__subDL SHEET END0 views