{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Hotkeys","Custom","Tables"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Hotkeys","index":0,"n_rows":20,"n_cols":11,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,3,1],[1,2,3,2],[1,3,1,5],[1,6,2,7],[1,8,3,8]]}
[]
[null,"#","Narration","Launch Options (user customizable)",null,null,"Actions",null,"Customization"]
[null,null,null,"Shortcut keys"]
[null,null,null,"Main Key 1","Main Key 2","Second Key","First","Subsequent"]
[null,1,{"$f":"Custom!B3","v":"Base_format"},"Alt","","x","Apply Format 1","Apply Format 2 (3, 1)","Custom",{"$f":"IF(Hotkeys!D5=\"\",\"\",IF(Hotkeys!D5=\"Alt\",\"%\",IF(Hotkeys!D5=\"Ctrl\",\"^\",\"+\")))&IF(Hotkeys!E5=\"\",\"\",IF(Hotkeys!E5=\"Alt\",\"%\",IF(Hotkeys!E5=\"Ctrl\",\"^\",\"+\")))&Hotkeys!F5","v":"%x"},"AllG"]
[null,{"$f":"B5+1","v":2},{"$f":"Custom!B9","v":"Number_format"},"Alt","Shift","c","Apply Cell Format 1","Apply Cell Format 2 (3, 1)","Custom",{"$f":"IF(Hotkeys!D6=\"\",\"\",IF(Hotkeys!D6=\"Alt\",\"%\",IF(Hotkeys!D6=\"Ctrl\",\"^\",\"+\")))&IF(Hotkeys!E6=\"\",\"\",IF(Hotkeys!E6=\"Alt\",\"%\",IF(Hotkeys!E6=\"Ctrl\",\"^\",\"+\")))&Hotkeys!F6","v":"%+c"},"formats"]
[null,{"$f":"B6+1","v":3},{"$f":"Custom!B16","v":"Date_format"},"Ctrl","Shift","z","Apply Date Format 1","Apply Date Format 2 (3, 1)","Custom",{"$f":"IF(Hotkeys!D7=\"\",\"\",IF(Hotkeys!D7=\"Alt\",\"%\",IF(Hotkeys!D7=\"Ctrl\",\"^\",\"+\")))&IF(Hotkeys!E7=\"\",\"\",IF(Hotkeys!E7=\"Alt\",\"%\",IF(Hotkeys!E7=\"Ctrl\",\"^\",\"+\")))&Hotkeys!F7","v":"^+z"},"dateformats"]
[null,4,{"$f":"Custom!B23","v":"Styles"},"Alt","Shift","q","Apply Cell Style 1","Apply Cell Style 2 (3, 1)","Custom",{"$f":"IF(Hotkeys!D8=\"\",\"\",IF(Hotkeys!D8=\"Alt\",\"%\",IF(Hotkeys!D8=\"Ctrl\",\"^\",\"+\")))&IF(Hotkeys!E8=\"\",\"\",IF(Hotkeys!E8=\"Alt\",\"%\",IF(Hotkeys!E8=\"Ctrl\",\"^\",\"+\")))&Hotkeys!F8","v":"%+q"},"Style"]
[null,5,{"$f":"Custom!B29","v":"Font_color"},"Alt","Shift","x","Apply Font Color 1","Apply Font Color 2 (3, 1)","Custom",{"$f":"IF(Hotkeys!D9=\"\",\"\",IF(Hotkeys!D9=\"Alt\",\"%\",IF(Hotkeys!D9=\"Ctrl\",\"^\",\"+\")))&IF(Hotkeys!E9=\"\",\"\",IF(Hotkeys!E9=\"Alt\",\"%\",IF(Hotkeys!E9=\"Ctrl\",\"^\",\"+\")))&Hotkeys!F9","v":"%+x"},"FontCol"]
[null,6,{"$f":"Custom!B35","v":"Fill_color"},"Alt","Shift","z","Apply Fill Color 1","Apply Fill Color 2 (3, 1)","Custom",{"$f":"IF(Hotkeys!D10=\"\",\"\",IF(Hotkeys!D10=\"Alt\",\"%\",IF(Hotkeys!D10=\"Ctrl\",\"^\",\"+\")))&IF(Hotkeys!E10=\"\",\"\",IF(Hotkeys!E10=\"Alt\",\"%\",IF(Hotkeys!E10=\"Ctrl\",\"^\",\"+\")))&Hotkeys!F10","v":"%+z"},"PattCol"]
[null,7,"Divide by thousand","","Alt","\\","Divide by 10^3","Remove dividing","n/a",{"$f":"IF(Hotkeys!D11=\"\",\"\",IF(Hotkeys!D11=\"Alt\",\"%\",IF(Hotkeys!D11=\"Ctrl\",\"^\",\"+\")))&IF(Hotkeys!E11=\"\",\"\",IF(Hotkeys!E11=\"Alt\",\"%\",IF(Hotkeys!E11=\"Ctrl\",\"^\",\"+\")))&Hotkeys!F11","v":"%\\"},"thDivide"]
[null,8,"Divide by mln","Ctrl","Alt","\\","Divide by 10^6","Remove dividing","n/a",{"$f":"IF(Hotkeys!D12=\"\",\"\",IF(Hotkeys!D12=\"Alt\",\"%\",IF(Hotkeys!D12=\"Ctrl\",\"^\",\"+\")))&IF(Hotkeys!E12=\"\",\"\",IF(Hotkeys!E12=\"Alt\",\"%\",IF(Hotkeys!E12=\"Ctrl\",\"^\",\"+\")))&Hotkeys!F12","v":"^%\\"},"mlnDivide"]
[null,9,"Multiply by -1","","Alt","-","Multiply by -1","Remove multiplying","n/a",{"$f":"IF(Hotkeys!D13=\"\",\"\",IF(Hotkeys!D13=\"Alt\",\"%\",IF(Hotkeys!D13=\"Ctrl\",\"^\",\"+\")))&IF(Hotkeys!E13=\"\",\"\",IF(Hotkeys!E13=\"Alt\",\"%\",IF(Hotkeys!E13=\"Ctrl\",\"^\",\"+\")))&Hotkeys!F13","v":"%-"},"darkside"]
[null,10,"Center Across Alignment","Ctrl","Shift","y","Align text between selected cells","n/a","n/a",{"$f":"IF(Hotkeys!D14=\"\",\"\",IF(Hotkeys!D14=\"Alt\",\"%\",IF(Hotkeys!D14=\"Ctrl\",\"^\",\"+\")))&IF(Hotkeys!E14=\"\",\"\",IF(Hotkeys!E14=\"Alt\",\"%\",IF(Hotkeys!E14=\"Ctrl\",\"^\",\"+\")))&Hotkeys!F14","v":"^+y"},"CenterAcrossColumns"]
[null,11,"Formula to comment","Shift","Ctrl","q","Copy formula to comment and kill formula","n/a","n/a",{"$f":"IF(Hotkeys!D15=\"\",\"\",IF(Hotkeys!D15=\"Alt\",\"%\",IF(Hotkeys!D15=\"Ctrl\",\"^\",\"+\")))&IF(Hotkeys!E15=\"\",\"\",IF(Hotkeys!E15=\"Alt\",\"%\",IF(Hotkeys!E15=\"Ctrl\",\"^\",\"+\")))&Hotkeys!F15","v":"+^q"},"FTC"]
[null,12,"Fill right","Ctrl","Shift","r","Fill right","n/a","n/a",{"$f":"IF(Hotkeys!D16=\"\",\"\",IF(Hotkeys!D16=\"Alt\",\"%\",IF(Hotkeys!D16=\"Ctrl\",\"^\",\"+\")))&IF(Hotkeys!E16=\"\",\"\",IF(Hotkeys!E16=\"Alt\",\"%\",IF(Hotkeys!E16=\"Ctrl\",\"^\",\"+\")))&Hotkeys!F16","v":"^+r"},"FillRight"]
[null,13,"Fill down","Ctrl","Shift","d","Fill down","n/a","n/a",{"$f":"IF(Hotkeys!D17=\"\",\"\",IF(Hotkeys!D17=\"Alt\",\"%\",IF(Hotkeys!D17=\"Ctrl\",\"^\",\"+\")))&IF(Hotkeys!E17=\"\",\"\",IF(Hotkeys!E17=\"Alt\",\"%\",IF(Hotkeys!E17=\"Ctrl\",\"^\",\"+\")))&Hotkeys!F17","v":"^+d"},"FillDown"]
[null,14,"Table format","Ctrl","Shift","t","Apply table format","n/a","Custom",{"$f":"IF(Hotkeys!D18=\"\",\"\",IF(Hotkeys!D18=\"Alt\",\"%\",IF(Hotkeys!D18=\"Ctrl\",\"^\",\"+\")))&IF(Hotkeys!E18=\"\",\"\",IF(Hotkeys!E18=\"Alt\",\"%\",IF(Hotkeys!E18=\"Ctrl\",\"^\",\"+\")))&Hotkeys!F18","v":"^+t"},"tableformat"]
[null,15,"Select all sheets","Ctrl","Shift","a","Select all visible sheets","n/a","n/a",{"$f":"IF(Hotkeys!D19=\"\",\"\",IF(Hotkeys!D19=\"Alt\",\"%\",IF(Hotkeys!D19=\"Ctrl\",\"^\",\"+\")))&IF(Hotkeys!E19=\"\",\"\",IF(Hotkeys!E19=\"Alt\",\"%\",IF(Hotkeys!E19=\"Ctrl\",\"^\",\"+\")))&Hotkeys!F19","v":"^+a"},"SAT"]
[null,16,"Kill formula","","Ctrl","q","Copy selections as values","n/a","n/a",{"$f":"IF(Hotkeys!D20=\"\",\"\",IF(Hotkeys!D20=\"Alt\",\"%\",IF(Hotkeys!D20=\"Ctrl\",\"^\",\"+\")))&IF(Hotkeys!E20=\"\",\"\",IF(Hotkeys!E20=\"Alt\",\"%\",IF(Hotkeys!E20=\"Ctrl\",\"^\",\"+\")))&Hotkeys!F20","v":"^q"},"KF"]

{"sheet":"Custom","index":1,"n_rows":58,"n_cols":5,"rows_kept":58,"cut":false,"hidden":false,"merged":[[56,1,56,4],[53,1,53,4],[50,1,50,4],[2,1,2,4],[8,1,8,4],[15,1,15,4],[22,1,22,4],[28,1,28,4],[29,4,31,4],[34,1,34,4],[35,4,37,4],[40,1,40,4],[44,1,44,4],[47,1,47,4]]}
[]
[null,"#","Action / Method","Property","Comment"]
[null,"Base_format"]
[null,1,"Font","Arial"]
[null,2,"Size",10]
[null,3,"Number format",1000]
[null,4,"Number format, float",-1000]
[]
[null,"Number_format"]
[null,1,"Format 1",10000]
[null,2,"Format 2",-300]
[null,3,"Format 3",3]
[null,4,"Format 4",300]
[null,5,"Object","Selection","If you want to consider every cell in selection independently, set cell D14 equal \"Cell\", otherwise - \"Selection\"."]
[]
[null,"Date_format"]
[null,1,"Format 1","2013-06-20"]
[null,2,"Format 2","2013-06-20"]
[null,3,"Format 3","2013-06-20"]
[null,4,"Format 4","2013-06-20"]
[null,5,"Object","Selection","If you want to consider every cell in selection independently, set cell D21 equal \"Cell\", otherwise - \"Selection\"."]
[]
[null,"Styles"]
[null,1,"Style 1"]
[null,2,"Style 2"]
[null,3,"Style 3"]
[null,4,"Object","Selection","If you want to consider every cell in selection independently, set cell D27 equal \"Cell\", otherwise - \"Selection\"."]
[]
[null,"Font_color"]
[null,1,"Color 1","Text","If you need only 2 colors (except for black), leave 'x\" in cell D32. If you need additional color - delete \"x\" from cell D32 and apply your color of choice."]
[null,2,"Color 2","Text"]
[null,3,"Color 3","Text"]
[null,4,"Object","Selection","If you want to consider every cell in selection independently, set cell D33 equal \"Cell\", otherwise - \"Selection\"."]
[]
[null,"Fill_color"]
[null,1,"Color 1",null,"If you need only 2 colors (except for white), leave 'x\" in cell D38. If you need additional color - delete \"x\" from cell D38 and apply your color of choice."]
[null,2,"Color 2"]
[null,3,"Color 3"]
[null,4,"Object","Selection","If you want to consider every cell in selection independently, set cell D39 equal \"Cell\", otherwise - \"Selection\"."]
[]
[null,"Sheets color"]
[null,1,"Separator",">","Select symbol for sheets separation."]
[null,2,"Gridlines",false,"If you want to retain Gridlines after macros execution - set parameter to True. This parameter is also linked to other macros."]
[]
[null,"Zoom"]
[null,1,"Percentage",75,"Preferable zoom level"]
[]
[null,"Split text"]
[null,1,"Number of symbols",180,"Set number of symbols per line"]
[]
[null,"Formula Consistency"]
[null,1,"Fill color",null,"Fill color for inconsistent formulas"]
[]
[null,"Formula Consistency"]
[null,1,"Color 1",null,"Color for positive values"]
[null,2,"Color 2",null,"Color for negative values"]
[null,"Enable F1"]
[null,1,"Enable",false,"If for any reason you want to enable Excel Help, set parameter to True."]

{"sheet":"Tables","index":2,"n_rows":2,"n_cols":10,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Table Format - 1 Header Row",null,null,null,"Table Format - 2 Header Rows",null,null,null,"Table Format - 3+ Header Rows"]