{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["README","TOOLS","CONFIG","KEYS"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":11,"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":"README","index":0,"n_rows":34,"n_cols":2,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["README","pvCore Excel Add-In"]
[null,"Presidio Vantage Information Systems"]
[]
[null,"This free, open-source add-in provides some basic Excel and VBA utilities."]
[null,{"$f":"CONCATENATE(\"To run tools, use menus in the \"\"\", TOOLS!tabLabel, \"\"\" ribbon tab.\nHold the mouse over a tool (without clicking) to see tool-tip documentation.\")","v":"To run tools, use menus in the \"♠PV\" ribbon tab.\nHold the mouse over a tool (without clicking) to see tool-tip documentation."}]
[null,"The \"Undo\" action is unavailable after running most tools.\nIt is recommended that you \"Save\" current work before running a tool you may want to undo."]
[]
["TOOLS","The \"TOOLS\" tab shows the full list of menu tools and their documentation."]
[]
[null,"Contact Presidio Vantage for:"]
[1,"guidance on how to configure, customize, and extend this add-in"]
[2,"information about pvDEV, our advanced harness for developing Excel Add-Ins"]
[]
[]
[{"$f":"IF(1<SUBTOTAL(103, $B$15:$B$28), \"↓\", \"← expand...\")","v":"↓"},"Advanced:"]
[null,"This add-in (including this README) is configured via its workbook, always hidden for add-ins.\nTo temporarily view and modify configurations, use the \"AddIn > Toggle Add-In Visibility\" menu.\nAlways use the same menu to save and hide the workbook when you are finished."]
[null,"Any changes made to this add-in are lost if you run the \"AddIn > Update pvCore Add-In\" tool."]
[]
["TOOLS","The \"TOOLS\" tab configures the ribbon menus.\nInsert additional rows to add commands."]
[null,"Only the already-existing values in the \"menu\" column are recognized,\nmeaning you cannot configure additional menus which are not already-listed.\nUse the three \"Custom\" menus already-listed if you need additional menus."]
[null,"You may need to restart Excel (to close and reopen the add-in) for changes to affect the menus."]
[]
["CONFIG","The \"CONFIG\" tab stores a registry of global configurations for the add-in."]
[null,"Config values can be (and sometimes are) modified by the scripts themselves."]
[]
["KEYS","The \"KEYS\" tab enables mapping of shortcut keys to VBA subroutines.\nInsert additional rows to bind other VBA subroutines to custom shortcut-keys."]
[null,"Shortcut keys are bound only if CONFIG \"Bind Shortcut Keys?\" is TRUE.\nThe shortcut keys are bound when the add-in loads."]
[]
[]
["MIT LICENSE:"]
[null,"© 2020 Presidio Vantage LLC"]
[null,"Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the \"Software\"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:"]
[null,"The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software."]
[null,"THE SOFTWARE IS PROVIDED \"AS IS\", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE."]

{"sheet":"TOOLS","index":1,"n_rows":70,"n_cols":9,"rows_kept":70,"cut":false,"hidden":false,"merged":[]}
["menu","button","visible","enabled","onAction","imageMso","label","screentip","supertip"]
["Formula","Unformatted_BiDirectional_Fill",true,true,"Unformatted_BiDirectional_Fill","PivotShowDetails","Fill BiDirectional Unformatted","Fill BiDirectional Unformatted","This tool fills formula only, in both directions (from top-left cell).\nWARNING: cannot be un-done.\n\nThe typical \"Fill\" operation is *either* down *or* right.\nLikewise it typically includes formulas and formats."]
["Formula","Hard_Set_Values",true,true,"Hard_Set_Values","FilePermissionRestrictMenu","Hard-set Values","replaces Formulas with their fixed-Values","removes any formulas from the selection, while keeping each respective cell's value unchanged.\n(equivalent to copy + paste-values)"]
["Formula","Soft_Reset_Formulas",true,true,"Soft_Reset_Formulas","Refresh","Soft-reset Formulas","resets Formulas in the Selected Range","this is equivalent to re-entering the Range's Formulas exactly as they are, which can have side-effects like recognizing Dates from text values, or changing value-type according to NumberFormat. these side-effects are rarely, but sometimes, desirable."]
["Formula"]
["Formula","Soft_Reset_Formula_OppositeTextFormat",true,true,"Soft_Reset_Formula_OppositeTextFormat","Refresh","Soft-reset Cell Formula w/ Opposite Text-Formatting","Soft-reset Cell Formula w/ Opposite Text-Formatting","This tool first switches the cell's NumberFormat between Text and Non-Text, then resets the the Formula, then finally sets the NumberFormat back to its original state.\n\nThis can be useful e.g. to set formulas in text-formatted cells."]
["Formula","List_Selection_Formulas",true,true,"List_Selection_Formulas","WatchWindow","List Selection Formulas","List Selection Formulas","Developer tool to view all formulas in a given Range.\nThe selection must be a single Area.\nThis tool lists (transposed) all formulas in the Selection.\n\nHold [Shift] to show A1 references instead of R1C1."]
["Formula"]
["Formula","Toggle_Formula_R1C1",true,true,"Toggle_Formula_R1C1","PivotTableOlapConvertToFormulas","Toggle Formula R1C1/A1","Toggle Formula R1C1/A1","Toggles the formula references between R1C1 and A1 styles."]
["Formula","Toggle_ShowFormulas_AllTabs",true,true,"Toggle_ShowFormulas_AllTabs","ShowFormulas","Toggle ShowFormulas for whole Workbook","Toggle ShowFormulas for whole Workbook","Toggles the active sheet's \"ShowFormulas\" setting, and toggles all other sheets in the book to the same value"]
["Formula","SelectNextRowWithDifferentFormula_UI",true,true,"SelectNextRowWithDifferentFormula_UI","AccessTableEvents","Seek Inconsistent Formula by Column","Seek Inconsistent Formula by Column","Given a single-area Selection (rectangle), this seeks out any cells in the selection which do not have the same formula as the cell above them. It selects the first such cell, if one exists."]
["Formula"]
["Formula","Insert_Timestamp",true,true,"Insert_Timestamp","DateAndTimeInsert","Insert Timestamp","Insert Timestamp (Date+Time)","Inserts the value of the current Date+Time in the selected cells.\n\nHelper tool, primarily to bind shortcut key."]
["Sheet","List_All_Sheets",true,true,"List_All_Sheets","WatchWindow","List all WorkSheet tabs","List all WorkSheet tabs","Lists every tab in the active WorkBook."]
["Sheet","add_toc",true,true,"add_toc","WatchWindow","Create Table-of-Contents","adds a \"Table of Contents\" tab to the active WorkBook","Lists a link to every tab in the active WorkBook\non a new \"Table of Contents\" tab in the same book."]
["Sheet","Select_First_Sheet",true,true,"Select_First_Sheet","OutlinePromoteToHeading","Select First Tab","Select First Tab","Selects the first visible tab in the workbook."]
["Sheet","Select_Last_Sheet",true,true,"Select_Last_Sheet","OutlineDemoteToBodyText","Select Last Tab","Select Last Tab","Selects the last visible tab in the workbook."]
["Sheet","Select_First_Sheet_EXTEND",true,true,"Select_First_Sheet_EXTEND","OutlinePromoteToHeading","Select this and prior tabs","Select this and prior tabs","Selects the the currently selected tab and all visible tabs before it."]
["Sheet","Select_Last_Sheet_EXTEND",true,true,"Select_Last_Sheet_EXTEND","OutlineDemoteToBodyText","Select this and following tabs","Select this and following tabs","Selects the the currently selected tab and all visible tabs after it."]
["Sheet"]
["Sheet","Show_All_Sheets",true,true,"Show_All_Sheets","SourceControlShowDifferences","un-hide All Sheets","show all hidden WorkSheets in the active WorkBook","hold [Shift] to paint previously-hidden Sheet tabs (red)"]
["Sheet","Show_All_Columns",true,true,"Show_All_Columns","SourceControlShowDifferences","un-hide All Columns","show all hidden Columns in the active WorkSheet","hold [Shift] to highlight previously-hidden Ranges yellow"]
["Sheet","Show_All_Rows",true,true,"Show_All_Rows","SourceControlShowDifferences","un-hide All Rows","show all hidden Rows in the active WorkSheet","hold [Shift] to highlight previously-hidden Ranges yellow"]
["Sheet"]
["Sheet","Outline_By_Selection_Value",true,true,"Outline_By_Selection_Value","OutlineGroup","Outline by Selection Value","Outline by Selection Value","Given a selection (of cells in the same row),\nsets the \"outline depth\" (grouping) of each cell's full-column to be that cell's value.\n\nhold [Shift] to use a columnar-selection to group each cell's full Row instead of Column."]
["Sheet","Set_Sheet_Defaults",true,true,"Set_Sheet_Defaults","PivotTableGenerateGetPivotData","Set Sheet Defaults (top-down)","Set Sheet Defaults (top-down)","Sets the active sheet to have top vertical-alignment, and top-and-left grouping.\n\nhold [Shift] to set these defaults for all sheets in the active book"]
["Sheet","unMergeAllCells",true,true,"unMergeAllCells","SplitCells","Un-Merge All Cells","Un-Merge All Cells","Un-Merge all cells in the active worksheet.\n\nhold [Shift] to run on every worksheet in the active workbook."]
["Sheet","Strip_MS365_Comments",true,true,"Strip_MS365_Comments","ReviewDeleteComment","Strip MS365 Threaded Comments","Strip MS365 Threaded Comments",{"$f":"\"Strips this prefix from all comments (which have it) in the active Sheet:\n(hold [Shift] to strip all Sheets in the active Book)\n\n\"&CONFIG!$C$10","v":"Strips this prefix from all comments (which have it) in the active Sheet:\n(hold [Shift] to strip all Sheets in the active Book)\n\n[Threaded comment]\n\nYour version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924\n\nComment:\n    "}]
["Book","Open_Workbook_Readonly",true,true,"Open_Workbook_Readonly","ReadOnly","Open Workbook Readonly","Open Workbook Readonly","Prompts to open a workbook in readonly mode."]
["Book","ReOpen_Workbook_Readonly",true,true,"ReOpen_Workbook_Readonly","ReadOnly","ReOpen Active Workbook Readonly","ReOpen Active Workbook Readonly","Re-opens the currently-active workbook in read-only mode (refreshing to the latest version of the File)."]
["Book","Toggle_Readonly_UI",true,true,"Toggle_Readonly_UI","ReadOnly","Toggle ReadOnly","Toggle ActiveWorkbook ReadOnly","Switches between ReadOnly and Read/Write for the Active Workbook. Offers a chance to cancel if the workbook is not saved."]
["Book"]
["Book","Duplicate_Active_Window",true,true,"Duplicate_Active_Window","WindowNew","Duplicate Active Window","Duplicate Active Window","Creates a new window and copies all window characteristics for each tab."]
["Book"]
["Book","Save_WorkBook_SnapShot",true,true,"Save_WorkBook_SnapShot","Camera","Save ActiveWorkbook Snapshot","Save ActiveWorkbook Snapshot","Saves a copy of the Active Workbook in its current state to a new filename including the current timestamp. This does not save the current workbook itself, and leaves its path/name the same (i.e. does not change the current Active Workbook's path, as SaveAs would do).\n\nhold [Shift] to add a short informative \"tag\" to the end of the snapshot filename."]
["Format","Display_ConditionalFormats",true,true,"Display_ConditionalFormats","WatchWindow","List All ConditionalFormats","List All WorkSheet ConditionalFormats","Shows a full listing of all Conditional Formats for the Active WorkBook."]
["Format"]
["Format","Format_Center_Across_Selection",true,true,"Format_Center_Across_Selection","MergeCenter","Center Across Selection","Center Across Selection","Sets the selected range to have cell format \"Center Across Selection\"\n\nHelper tool, primarily to bind shortcut key."]
["Format"]
["Format","Default_Number_Format",true,true,"Default_Number_Format","CommaStyle","Numeric Format","Set Configured Numeric NumberFormat","Sets the currently-selected Range to have the configured NumberFormat."]
["Format","Default_Time_Format",true,true,"Default_Time_Format","StartAfterPrevious","Time Format","Set Configured Time NumberFormat","Sets the currently-selected Range to have the configured NumberFormat."]
["Format","Default_Date_Format",true,true,"Default_Date_Format","ContentControlDate","Date Format","Set Configured Date NumberFormat","Sets the currently-selected Range to have the configured NumberFormat."]
["Format","Timestamp_Format",true,true,"Timestamp_Format","DateAndTimeInsert","Timestamp Format","Set Configured Timestamp (Date+Time) NumberFormat","Sets the currently-selected Range to have the configured NumberFormat."]
["Format","Default_Percent_Format",true,true,"Default_Percent_Format","PercentStyle","Percent Format","Set Configured Percent NumberFormat","Sets the currently-selected Range to have the configured NumberFormat."]
["Format"]
["Format","Paste_Special_Values",false,true,"Paste_Special_Values","Paste","Paste Values Unformatted","Paste Values without formatting","Paste Values without formatting.\nWARNING: cannot be un-done.\n\n(helper tool)"]
["Format","Paste_Special_Formulas",false,true,"Paste_Special_Formulas","Paste","Paste Formulas Unformatted","Paste Formulas without formatting","Paste Formulas without formatting.\nWARNING: cannot be un-done.\n\n(helper tool)"]
["Name","Display_WorkBook_Names",true,true,"Display_WorkBook_Names","WatchWindow","List All NamedRanges","List All WorkBook NamedRanges","Shows a full listing of all NamedRange definitions\nfor the Active WorkBook."]
["Name","Show_All_Names",true,true,"Show_All_Names","SourceControlShowDifferences","un-hide All Named-Ranges","show all hidden Named-Ranges","makes visible any hidden named-ranges and named-formulas for the ActiveSheet\n\nhold [Shift] to show all names for WorkBook and all WorkSheets"]
["Name"]
["Name","Name_Columns_for_Selection",true,true,"Name_Columns_for_Selection","AutoCorrect","Auto-Name Columns","Auto-Name Columns","Given a selection (of cells in the same row), automatically names the full column by the value of each cell in the selection.\n\nhold [Shift] to name globally at the workbook-level. Each name will be prefixed by the workbook-name. (otherwise names are sheet-level.)"]
["Table","Show_All_Data_Preserve_Sort",true,true,"Show_All_Data_Preserve_Sort","FilterClearAllFilters","ClearFilter PreserveSorts","Clear Filter without clearing Sort config","For a sheet with AutoFilter enabled,\nthis clears the current filter (showing all rows)\n*without* clearing the table's Sorting configuration."]
["Table"]
["Table","Fill_Blanks_Down_From_Above",true,true,"Fill_Blanks_Down_From_Above","OutlineExpandAll","Fill Blanks Down from Above","Fill Blanks Down from Above","Replaces any blank value with the nearest value above it. This is useful to repeat \"hierarchical headers\" down into their data rows in a table.\n\nhold [Shift] to fill Formulas instead of Values"]
["Table"]
["Table","TableRunner_ActiveSheet",false,true,"TableRunner_ActiveSheet","TableExportTableToSharePointList","Execute TableRunner on Selection","Execute TableRunner on Selection","Select a table with a \"method\" field, and this tool will run that value for each row in the table. Optionally include an \"arguments\" field at the far-right of the table to include arguments. Multiple args may be listed in the following columns; nothing else may be right-adjacent to this table. Include optional \"start\", \"end\", and \"error\" fields (outputs) to have the runner store relevant values there."]
["File","File_Tree",true,true,"File_Tree","PivotTableBlankRowsInsert","List File Directory Tree…","List All Files in Directory sub-Tree","Given a FileSystem Directory (Folder),\nthis tool shows the full sub-heirarchy,\nwith metadata wherever available."]
["File","Prompt_Snapshot_File",true,true,"Prompt_Snapshot_File","Camera","Backup File Snapshot","Backup File Snapshot","Prompts for any File and makes a copy with a new filename including the current timestamp. This copies the File as-is, as it was last saved (e.g. disregarding any current un-saved changes in open applications).\n\nhold [Shift] to do this with the Active Workbook's file (i.e. snapshot of its file, *without* current un-saved changes open in Excel.)"]
["File","save_all_in_directory_pdf",true,true,"save_all_in_directory_pdf","FilePrintQuick","Save All Workbooks in Directory as PDF","Save All Workbooks in Directory as PDF","Saves all files in a directory as PDF files. The directory must contain only Excel workbook files."]
["File","Print_All_In_Directory",true,false,"print_all_in_directory","FilePrintQuick","Print All Workbooks in Directory","Print All Workbooks in Directory","Prints all files in a directory with the currently-selected printer. The directory must contain only Excel workbook files.\n\nPrinting is discouraged for environmental reasons. Please only print when necessary. If necessary, enable this menu in the add-in."]
["File","convert_word_directory",true,true,"convert_word_directory","FileSaveAsWordDotx","Convert All MSWord in Directory","Convert All MSWord in Directory","Converts all files in a directory from Word Documents into PDF files.\n\nhold [Shift] to convert into HTML files instead."]
["AddIn","Show_Documentation",true,true,"Show_Documentation","HappyFace","README","Show Documentation","Tips, Instructions, and License information.\nhold [Shift] to show advanced docs/configs"]
["AddIn"]
["AddIn","Toggle_Addin_Visibility",true,true,"Toggle_Addin_Visibility","FileSaveToDocumentManagementServer","Toggle Add-In Visibility","Toggle Add-In Visibility","Displays the Add-In WorkBook for configuration."]
["AddIn","Check_Addin_Status",true,true,"Check_Addin_Status","Help","Check Add-In Status","Check pvCore Add-in Status","Displays a message with the file-path of the add-in and some additional info."]
["AddIn","Save_Close_pvCore",true,true,"Save_Close_pvCore","PrintPreviewClose","Save and Close pvCore Add-In","Save and Close pvCore Add-In","An add-in cannot be closed if there are open workbooks (including other add-ins) which reference it."]
["AddIn","Update_PV_Core",true,true,"Update_PV_Core","FileStartWorkflow","Update pvCore Add-In","Update pvCore Add-In","Update this add-in with a new file you provide.\nWARNING: BETA. this will reset all configurations. any changes you made to the add-in must be re-applied. (e.g. configs, shortcut-keys, custom menus, any additional/modified VBA, etc.)\n\nany workbooks which reference the add-in should be closed before running this, including any such add-ins.\n\nhold [Shift] to update directly from the Presidio Vantage website:\nhttps://presidiovantage.com/xl/pvCore.xlam"]
["Custom1"]
["Custom2"]
["Custom3"]

{"sheet":"CONFIG","index":2,"n_rows":18,"n_cols":10,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Config ID","Value","Notes"]
["Update URL","https://presidiovantage.com/xl/pvCore.xlam"]
["VERSION","0.9.95","0.9.95 2024-05-05: BETA3 release candidate\n0.9.9 2024-03-21: BETA2 release candidate\n0.9.8 2024-02-29: BETA1\n0.9.0 2023-11-19: BETA0 public release for peer review\n0.8.9 2023-10-30: ALPHA private release for peer review"]
["Install Timestamp",null,"initial install of this version of the add-in file"]
["Install Hash",null,"roughly \"unique\" fingerprint of the environment coordinates.\nNOT suitable for cryptographic / unique purposes."]
["Bind Shortcut Keys?",true,"binds shortcut-keys listed in the KEYS tab whenever the addin opens"]
["Warn Unsaved?",false,"Tools warn you to save before making a major change which cannot be un-done."]
["Backup Before Update?",false,"save a timestamped .bkp file when updating the add-in file\nwhen false, a backup is still saved, but without timestamp (always the same path)"]
["Config Timestamp",null,"DISABLED FOR PRODUCTION\nlatest refresh from User Config file (if it exists).\nthis mechanism is disabled for release; it is still under internal review."]
["MS365 Comment Prefix","[Threaded comment]\n\nYour version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924\n\nComment:\n    ",{"$f":"B10","v":"[Threaded comment]\n\nYour version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924\n\nComment:\n    "}]
["DefaultNumberFormat","#,##0.00_);[Red](#,##0.00);-_)"]
["DefaultTimeFormat","h:mm","for System ShortTime, use this code: h:mm\n(this is set by the default CTRL+SHIFT+2 shortcut key)\nfor System LongTime, use this code: [$-x-systime]\n(this is set by the Number Format \"Date\" sub-menu)"]
["DefaultDateFormat","m/d/yyyy","for System ShortDate, use this code: m/d/yyyy\n(only for mechanical NumberFormat, not TEXT formula; cannot be tested below)\nfor System LongDate, use this code: [$-x-sysdate]\n(this is set by the default CTRL+SHIFT+3 shortcut key)"]
["DefaultPercentFormat","#,##0.0%;[Red]-#,##0.0%;-_)"]
["DefaultNumberFormat Example Values",null,"enter example values to test at right:",1234.567,-1234.567,0,"hi",null,0.1,-0.1]
["DefaultNumberFormat Example Display",{"$f":"A11","v":"DefaultNumberFormat"},"example test results at right:\nchoose a format at left.\n(NumberFormat coloration will not show here,\nNumberFormat default-alignment will not show here.)",{"$f":"TEXT(D$15, VLOOKUP($B16, $A:$B, 2, FALSE))","v":"1,234.57 "},"(1,234.57)","- ","hi","- ","0.10 ","(0.10)"]
["FileName w/o Path",{"$f":"MID(CELL(\"filename\"),\n    1+FIND(\"[\", CELL(\"filename\")),\n    -1+FIND(\"]\", CELL(\"filename\"))-FIND(\"[\", CELL(\"filename\")))","v":"pvCore.xlam"},"Formula to get File Name (without path) from CELL(filename)."]
["TabName Example",{"$f":"RIGHT(CELL(\"filename\"), LEN(CELL(\"filename\"))-FIND(\"]\", CELL(\"filename\")))","v":"CONFIG"},"Example formula to get Tab Name from CELL(filename)."]

{"sheet":"KEYS","index":3,"n_rows":17,"n_cols":9,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Command","Enable?","SHIFT","CTRL","ALT","Key","Description","Notes","supertip"]
["Unformatted_BiDirectional_Fill",false,false,true,false,"l",{"$f":"IF($D2, \"[CTRL]\", \"\") & IF($E2, \"[ALT]\", \"\") & IF($C2, \"[SHIFT]\", \"\") & \" \" & $F2","v":"[CTRL] l"},"PVIS recommends this tool as an alternative to \"Fill\" commands CTRL+D and CTRL+R.\nWARNING: cannot be un-done.",{"$f":"VLOOKUP($A2, TOOLS!$B:$I, COLUMNS(TOOLS!$B:$I), FALSE)","v":"This tool fills formula only, in both directions (from top-left cell).\nWARNING: cannot be un-done.\n\nThe typical \"Fill\" operation is *either* down *or* right.\nLikewise it typically includes formulas and formats."}]
["Format_Center_Across_Selection",false,true,true,true,"c",{"$f":"IF($D3, \"[CTRL]\", \"\") & IF($E3, \"[ALT]\", \"\") & IF($C3, \"[SHIFT]\", \"\") & \" \" & $F3","v":"[CTRL][ALT][SHIFT] c"},"This format is not available in stock Excel menu/shortcut customizations.",{"$f":"VLOOKUP($A3, TOOLS!$B:$I, COLUMNS(TOOLS!$B:$I), FALSE)","v":"Sets the selected range to have cell format \"Center Across Selection\"\n\nHelper tool, primarily to bind shortcut key."}]
["Select_First_Sheet",true,false,true,true,"{PgUp}",{"$f":"IF($D4, \"[CTRL]\", \"\") & IF($E4, \"[ALT]\", \"\") & IF($C4, \"[SHIFT]\", \"\") & \" \" & $F4","v":"[CTRL][ALT] {PgUp}"},null,{"$f":"VLOOKUP($A4, TOOLS!$B:$I, COLUMNS(TOOLS!$B:$I), FALSE)","v":"Selects the first visible tab in the workbook."}]
["Select_Last_Sheet",true,false,true,true,"{PgDn}","[CTRL][ALT] {PgDn}",null,{"$f":"VLOOKUP($A5, TOOLS!$B:$I, COLUMNS(TOOLS!$B:$I), FALSE)","v":"Selects the last visible tab in the workbook."}]
["Select_First_Sheet_EXTEND",false,true,true,true,"{PgUp}","[CTRL][ALT][SHIFT] {PgUp}",null,{"$f":"VLOOKUP($A6, TOOLS!$B:$I, COLUMNS(TOOLS!$B:$I), FALSE)","v":"Selects the the currently selected tab and all visible tabs before it."}]
["Select_Last_Sheet_EXTEND",false,true,true,true,"{PgDn}","[CTRL][ALT][SHIFT] {PgDn}",null,{"$f":"VLOOKUP($A7, TOOLS!$B:$I, COLUMNS(TOOLS!$B:$I), FALSE)","v":"Selects the the currently selected tab and all visible tabs after it."}]
["Paste_Special_Values",false,true,true,false,"v","[CTRL][SHIFT] v","Instead of this tool, PVIS recommends that the stock Excel action be used, via shortcut-key to the Quick-Access-Toolbar (e.g. ALT+1).",{"$f":"VLOOKUP($A8, TOOLS!$B:$I, COLUMNS(TOOLS!$B:$I), FALSE)","v":"Paste Values without formatting.\nWARNING: cannot be un-done.\n\n(helper tool)"}]
["Paste_Special_Formulas",false,true,true,true,"v","[CTRL][ALT][SHIFT] v","Instead of this tool, PVIS recommends that the stock Excel action be used, via shortcut-key to the Quick-Access-Toolbar (e.g. ALT+2).",{"$f":"VLOOKUP($A9, TOOLS!$B:$I, COLUMNS(TOOLS!$B:$I), FALSE)","v":"Paste Formulas without formatting.\nWARNING: cannot be un-done.\n\n(helper tool)"}]
["Open_Workbook_Readonly",true,false,true,true,"o","[CTRL][ALT] o",null,{"$f":"VLOOKUP($A10, TOOLS!$B:$I, COLUMNS(TOOLS!$B:$I), FALSE)","v":"Prompts to open a workbook in readonly mode."}]
["ReOpen_Workbook_Readonly",false,true,true,true,"o","[CTRL][ALT][SHIFT] o",null,{"$f":"VLOOKUP($A11, TOOLS!$B:$I, COLUMNS(TOOLS!$B:$I), FALSE)","v":"Re-opens the currently-active workbook in read-only mode (refreshing to the latest version of the File)."}]
["Default_Number_Format",false,true,true,false,1,"[CTRL][SHIFT] 1","Set NumberFormat configured for Numeric.\n(intended to override default shortcut key CTRL+SHIFT+1 which sets NumberFormat \"#,##0.00\")",{"$f":"VLOOKUP($A12, TOOLS!$B:$I, COLUMNS(TOOLS!$B:$I), FALSE)","v":"Sets the currently-selected Range to have the configured NumberFormat."}]
["Default_Time_Format",false,true,true,false,2,"[CTRL][SHIFT] 2","Set NumberFormat configured for Time.\n(by default, CTRL+SHIFT+2 sets NumberFormat to System Short-Date)",{"$f":"VLOOKUP($A13, TOOLS!$B:$I, COLUMNS(TOOLS!$B:$I), FALSE)","v":"Sets the currently-selected Range to have the configured NumberFormat."}]
["Default_Date_Format",false,true,true,false,3,"[CTRL][SHIFT] 3","Set NumberFormat configured for Date.\n(intended to override default shortcut key  CTRL+SHIFT+3 which sets problematic date format \"d-mm-yy\")",{"$f":"VLOOKUP($A14, TOOLS!$B:$I, COLUMNS(TOOLS!$B:$I), FALSE)","v":"Sets the currently-selected Range to have the configured NumberFormat."}]
["Timestamp_Format",false,true,true,true,2,"[CTRL][ALT][SHIFT] 2","Set NumberFormat configured for Timestamp (Date+Time)",{"$f":"VLOOKUP($A15, TOOLS!$B:$I, COLUMNS(TOOLS!$B:$I), FALSE)","v":"Sets the currently-selected Range to have the configured NumberFormat."}]
["Default_Percent_Format",false,true,true,false,5,"[CTRL][SHIFT] 5","Set NumberFormat configured for Percent.\n(intended to override default shortcut key CTRL+SHIFT+5 which sets percent format \"0%\")",{"$f":"VLOOKUP($A16, TOOLS!$B:$I, COLUMNS(TOOLS!$B:$I), FALSE)","v":"Sets the currently-selected Range to have the configured NumberFormat."}]
["Insert_Timestamp",false,true,true,true,";","[CTRL][ALT][SHIFT] ;",null,{"$f":"VLOOKUP($A17, TOOLS!$B:$I, COLUMNS(TOOLS!$B:$I), FALSE)","v":"Inserts the value of the current Date+Time in the selected cells.\n\nHelper tool, primarily to bind shortcut key."}]