|
sheet col row longname input keystrokes comment |
|
|
|
import-python datetime import Python module in the global scope |
|
|
|
open-file Werner.csv o |
|
rename-sheet Vaccinations Person A Rename current sheet |
|
Vaccinations Person A Datum rename-col Date ^ edit name of current column |
|
Vaccinations Person A Impfung rename-col Vaccination ^ edit name of current column |
|
Vaccinations Person A Frist rename-col RefreshTarget ^ edit name of current column |
|
Vaccinations Person A Vaccination key-col ! toggle current column as a key column |
|
Vaccinations Person A Date sort-desc ] sort descending by current column; replace any existing sort criteria |
|
Vaccinations Person A Date aggregate-col max + Add aggregator to current column |
|
Vaccinations Person A Date aggregate-col list + Add aggregator to current column |
|
Vaccinations Person A RefreshTarget type-int # set type of current column to int |
|
Vaccinations Person A RefreshTarget addcol-expr str(date(Date)+datetime.timedelta(weeks=RefreshTarget)) if RefreshTarget else f'{"✔": <10}' = create new column from Python expression, with column names as variables |
|
Vaccinations Person A str(date(Date)+datetime.timedelta(weeks=RefreshTarget)) if RefreshTarget else f'{"✔": <10}' rename-col Refresh ^ rename current column |
|
Vaccinations Person A Refresh aggregate-col max + Add aggregator to current column |
|
Vaccinations Person A resize-cols-max g_ resize all cols to max |
|
Vaccinations Person A Vaccination freq-col Shift+F open Frequency Table grouped on current column, with aggregations of other columns |
|
rename-sheet Vaccination Status Person A Rename current sheet |
|
Vaccination Status Person A Vaccination addcol-expr f', '.join(map(str, Date_list)) = create new column from Python expression, with column names as variables |
|
Vaccination Status Person A f', '.join(map(str, Date_list)) rename-col Vaccinations ^ edit name of current column |
|
Vaccination Status Person A Vaccination addcol-expr f'[:{"red" if Refresh_max<str(datetime.datetime.today()) else "yellow" if Refresh_max<str(datetime.datetime.today()+datetime.timedelta(weeks=26)) else "green"}]{Refresh_max}[:] (#{count}: {Date_max})' = create new column from Python expression, with column names as variables |
|
Vaccination Status Person A f'[:{"red" if Refresh_max<str(datetime.datetime.today()) else "yellow" if Refresh_max<str(datetime.datetime.today()+datetime.timedelta(weeks=26)) else "green"}]{Refresh_max}[:] (#{count}: {Date_max})' rename-col Refresh ^ edit name of current column |
|
Vaccination Status Person A count hide-col - Hide current column |
|
Vaccination Status Person A Date_max hide-col - Hide current column |
|
Vaccination Status Person A Date_list hide-col - Hide current column |
|
Vaccination Status Person A Refresh_max hide-col - Hide current column |
|
Vaccination Status Person A Vaccination sort-asc [ sort ascending by current column; replace any existing sort criteria |
|
Vaccination Status Person A resize-cols-max g_ resize all cols to max |
|
|
|
open-file Angelika.csv o |
|
rename-sheet Vaccinations Person B Rename current sheet |
|
Vaccinations Person B Datum rename-col Date ^ edit name of current column |
|
Vaccinations Person B Impfung rename-col Vaccination ^ edit name of current column |
|
Vaccinations Person B Frist rename-col RefreshTarget ^ edit name of current column |
|
Vaccinations Person B Vaccination key-col ! toggle current column as a key column |
|
Vaccinations Person B Date sort-desc ] sort descending by current column; replace any existing sort criteria |
|
Vaccinations Person B Date aggregate-col max + Add aggregator to current column |
|
Vaccinations Person B Date aggregate-col list + Add aggregator to current column |
|
Vaccinations Person B RefreshTarget type-int # set type of current column to int |
|
Vaccinations Person B RefreshTarget addcol-expr str(date(Date)+datetime.timedelta(weeks=RefreshTarget)) if RefreshTarget else f'{"✔": <10}' = create new column from Python expression, with column names as variables |
|
Vaccinations Person B str(date(Date)+datetime.timedelta(weeks=RefreshTarget)) if RefreshTarget else f'{"✔": <10}' rename-col Refresh ^ rename current column |
|
Vaccinations Person B Refresh aggregate-col max + Add aggregator to current column |
|
Vaccinations Person B resize-cols-max g_ resize all cols to max |
|
Vaccinations Person B Vaccination freq-col Shift+F open Frequency Table grouped on current column, with aggregations of other columns |
|
rename-sheet Vaccination Status Person B Rename current sheet |
|
Vaccination Status Person B Vaccination addcol-expr f', '.join(map(str, Date_list)) = create new column from Python expression, with column names as variables |
|
Vaccination Status Person B f', '.join(map(str, Date_list)) rename-col Vaccinations ^ edit name of current column |
|
Vaccination Status Person B Vaccination addcol-expr f'[:{"red" if Refresh_max<str(datetime.datetime.today()) else "yellow" if Refresh_max<str(datetime.datetime.today()+datetime.timedelta(weeks=26)) else "green"}]{Refresh_max}[:] (#{count}: {Date_max})' = create new column from Python expression, with column names as variables |
|
Vaccination Status Person B f'[:{"red" if Refresh_max<str(datetime.datetime.today()) else "yellow" if Refresh_max<str(datetime.datetime.today()+datetime.timedelta(weeks=26)) else "green"}]{Refresh_max}[:] (#{count}: {Date_max})' rename-col Refresh ^ edit name of current column |
|
Vaccination Status Person B count hide-col - Hide current column |
|
Vaccination Status Person B Date_max hide-col - Hide current column |
|
Vaccination Status Person B Date_list hide-col - Hide current column |
|
Vaccination Status Person B Refresh_max hide-col - Hide current column |
|
Vaccination Status Person B Vaccination sort-asc [ sort ascending by current column; replace any existing sort criteria |
|
Vaccination Status Person B resize-cols-max g_ resize all cols to max |
|
|
|
open-file Tanja.csv o |
|
rename-sheet Vaccinations Person C Rename current sheet |
|
Vaccinations Person C Datum rename-col Date ^ edit name of current column |
|
Vaccinations Person C Impfung rename-col Vaccination ^ edit name of current column |
|
Vaccinations Person C Frist rename-col RefreshTarget ^ edit name of current column |
|
Vaccinations Person C Vaccination key-col ! toggle current column as a key column |
|
Vaccinations Person C Date sort-desc ] sort descending by current column; replace any existing sort criteria |
|
Vaccinations Person C Date aggregate-col max + Add aggregator to current column |
|
Vaccinations Person C Date aggregate-col list + Add aggregator to current column |
|
Vaccinations Person C RefreshTarget type-int # set type of current column to int |
|
Vaccinations Person C RefreshTarget addcol-expr str(date(Date)+datetime.timedelta(weeks=RefreshTarget)) if RefreshTarget else f'{"✔": <10}' = create new column from Python expression, with column names as variables |
|
Vaccinations Person C str(date(Date)+datetime.timedelta(weeks=RefreshTarget)) if RefreshTarget else f'{"✔": <10}' rename-col Refresh ^ rename current column |
|
Vaccinations Person C Refresh aggregate-col max + Add aggregator to current column |
|
Vaccinations Person C resize-cols-max g_ resize all cols to max |
|
Vaccinations Person C Vaccination freq-col Shift+F open Frequency Table grouped on current column, with aggregations of other columns |
|
rename-sheet Vaccination Status Person C Rename current sheet |
|
Vaccination Status Person C Vaccination addcol-expr f', '.join(map(str, Date_list)) = create new column from Python expression, with column names as variables |
|
Vaccination Status Person C f', '.join(map(str, Date_list)) rename-col Vaccinations ^ edit name of current column |
|
Vaccination Status Person C Vaccination addcol-expr f'[:{"red" if Refresh_max<str(datetime.datetime.today()) else "yellow" if Refresh_max<str(datetime.datetime.today()+datetime.timedelta(weeks=26)) else "green"}]{Refresh_max}[:] (#{count}: {Date_max})' = create new column from Python expression, with column names as variables |
|
Vaccination Status Person C f'[:{"red" if Refresh_max<str(datetime.datetime.today()) else "yellow" if Refresh_max<str(datetime.datetime.today()+datetime.timedelta(weeks=26)) else "green"}]{Refresh_max}[:] (#{count}: {Date_max})' rename-col Refresh ^ edit name of current column |
|
Vaccination Status Person C count hide-col - Hide current column |
|
Vaccination Status Person C Date_max hide-col - Hide current column |
|
Vaccination Status Person C Date_list hide-col - Hide current column |
|
Vaccination Status Person C Refresh_max hide-col - Hide current column |
|
Vaccination Status Person C Vaccination sort-asc [ sort ascending by current column; replace any existing sort criteria |
|
Vaccination Status Person C resize-cols-max g_ resize all cols to max |
|
|
|
open-file Markus.csv o |
|
rename-sheet Vaccinations Person D Rename current sheet |
|
Vaccinations Person D Datum rename-col Date ^ edit name of current column |
|
Vaccinations Person D Impfung rename-col Vaccination ^ edit name of current column |
|
Vaccinations Person D Frist rename-col RefreshTarget ^ edit name of current column |
|
Vaccinations Person D Vaccination key-col ! toggle current column as a key column |
|
Vaccinations Person D Date sort-desc ] sort descending by current column; replace any existing sort criteria |
|
Vaccinations Person D Date aggregate-col max + Add aggregator to current column |
|
Vaccinations Person D Date aggregate-col list + Add aggregator to current column |
|
Vaccinations Person D RefreshTarget type-int # set type of current column to int |
|
Vaccinations Person D RefreshTarget addcol-expr str(date(Date)+datetime.timedelta(weeks=RefreshTarget)) if RefreshTarget else f'{"✔": <10}' = create new column from Python expression, with column names as variables |
|
Vaccinations Person D str(date(Date)+datetime.timedelta(weeks=RefreshTarget)) if RefreshTarget else f'{"✔": <10}' rename-col Refresh ^ rename current column |
|
Vaccinations Person D Refresh aggregate-col max + Add aggregator to current column |
|
Vaccinations Person D resize-cols-max g_ resize all cols to max |
|
Vaccinations Person D Vaccination freq-col Shift+F open Frequency Table grouped on current column, with aggregations of other columns |
|
rename-sheet Vaccination Status Person D Rename current sheet |
|
Vaccination Status Person D Vaccination addcol-expr f', '.join(map(str, Date_list)) = create new column from Python expression, with column names as variables |
|
Vaccination Status Person D f', '.join(map(str, Date_list)) rename-col Vaccinations ^ edit name of current column |
|
Vaccination Status Person D Vaccination addcol-expr f'[:{"red" if Refresh_max<str(datetime.datetime.today()) else "yellow" if Refresh_max<str(datetime.datetime.today()+datetime.timedelta(weeks=26)) else "green"}]{Refresh_max}[:] (#{count}: {Date_max})' = create new column from Python expression, with column names as variables |
|
Vaccination Status Person D f'[:{"red" if Refresh_max<str(datetime.datetime.today()) else "yellow" if Refresh_max<str(datetime.datetime.today()+datetime.timedelta(weeks=26)) else "green"}]{Refresh_max}[:] (#{count}: {Date_max})' rename-col Refresh ^ edit name of current column |
|
Vaccination Status Person D count hide-col - Hide current column |
|
Vaccination Status Person D Date_max hide-col - Hide current column |
|
Vaccination Status Person D Date_list hide-col - Hide current column |
|
Vaccination Status Person D Refresh_max hide-col - Hide current column |
|
Vaccination Status Person D Vaccination sort-asc [ sort ascending by current column; replace any existing sort criteria |
|
Vaccination Status Person D resize-cols-max g_ resize all cols to max |
|
|
|
open-file Tom.csv o |
|
rename-sheet Vaccinations Person E Rename current sheet |
|
Vaccinations Person E Datum rename-col Date ^ edit name of current column |
|
Vaccinations Person E Impfung rename-col Vaccination ^ edit name of current column |
|
Vaccinations Person E Frist rename-col RefreshTarget ^ edit name of current column |
|
Vaccinations Person E Vaccination key-col ! toggle current column as a key column |
|
Vaccinations Person E Date sort-desc ] sort descending by current column; replace any existing sort criteria |
|
Vaccinations Person E Date aggregate-col max + Add aggregator to current column |
|
Vaccinations Person E Date aggregate-col list + Add aggregator to current column |
|
Vaccinations Person E RefreshTarget type-int # set type of current column to int |
|
Vaccinations Person E RefreshTarget addcol-expr str(date(Date)+datetime.timedelta(weeks=RefreshTarget)) if RefreshTarget else f'{"✔": <10}' = create new column from Python expression, with column names as variables |
|
Vaccinations Person E str(date(Date)+datetime.timedelta(weeks=RefreshTarget)) if RefreshTarget else f'{"✔": <10}' rename-col Refresh ^ rename current column |
|
Vaccinations Person E Refresh aggregate-col max + Add aggregator to current column |
|
Vaccinations Person E resize-cols-max g_ resize all cols to max |
|
Vaccinations Person E Vaccination freq-col Shift+F open Frequency Table grouped on current column, with aggregations of other columns |
|
rename-sheet Vaccination Status Person E Rename current sheet |
|
Vaccination Status Person E Vaccination addcol-expr f', '.join(map(str, Date_list)) = create new column from Python expression, with column names as variables |
|
Vaccination Status Person E f', '.join(map(str, Date_list)) rename-col Vaccinations ^ edit name of current column |
|
Vaccination Status Person E Vaccination addcol-expr f'[:{"red" if Refresh_max<str(datetime.datetime.today()) else "yellow" if Refresh_max<str(datetime.datetime.today()+datetime.timedelta(weeks=26)) else "green"}]{Refresh_max}[:] (#{count}: {Date_max})' = create new column from Python expression, with column names as variables |
|
Vaccination Status Person E f'[:{"red" if Refresh_max<str(datetime.datetime.today()) else "yellow" if Refresh_max<str(datetime.datetime.today()+datetime.timedelta(weeks=26)) else "green"}]{Refresh_max}[:] (#{count}: {Date_max})' rename-col Refresh ^ edit name of current column |
|
Vaccination Status Person E count hide-col - Hide current column |
|
Vaccination Status Person E Date_max hide-col - Hide current column |
|
Vaccination Status Person E Date_list hide-col - Hide current column |
|
Vaccination Status Person E Refresh_max hide-col - Hide current column |
|
Vaccination Status Person E Vaccination sort-asc [ sort ascending by current column; replace any existing sort criteria |
|
Vaccination Status Person E resize-cols-max g_ resize all cols to max |
|
|
|
sheets-stack Shift+S open Sheets Stack: join or jump between the active sheets on the current stack |
|
|
|
sheets キVaccination Status Person A select-row s select current row |
|
sheets キVaccination Status Person B select-row s select current row |
|
sheets キVaccination Status Person C select-row s select current row |
|
sheets キVaccination Status Person D select-row s select current row |
|
sheets キVaccination Status Person E select-row s select current row |
|
|
|
sheets join-selected full & merge selected sheets with visible columns from all, keeping rows according to jointype |
|
rename-sheet Vaccination Status Overview Rename current sheet |
|
|
|
sheets resize-cols-max g_ resize all cols to max |
|
|
|
Vaccination Status Overview Vaccination Status Person A_Vaccinations hide-col - Hide current column |
|
Vaccination Status Overview Vaccination Status Person B_Vaccinations hide-col - Hide current column |
|
Vaccination Status Overview Vaccination Status Person C_Vaccinations hide-col - Hide current column |
|
Vaccination Status Overview Vaccination Status Person D_Vaccinations hide-col - Hide current column |
|
Vaccination Status Overview Vaccination Status Person E_Vaccinations hide-col - Hide current column |
|
|
|
Vaccination Status Overview Vaccination sort-asc [ sort ascending by current column; replace any existing sort criteria |
|
Vaccination Status Overview resize-cols-max g_ resize all cols to max |
|
|
|
Vaccination Status Overview Vaccination Status Person A_Refresh slide-rightmost gShift+L slide current column all the way to the right of sheet |
|
Vaccination Status Overview Vaccination Status Person B_Refresh slide-rightmost gShift+L slide current column all the way to the right of sheet |
|
Vaccination Status Overview Vaccination Status Person C_Refresh slide-rightmost gShift+L slide current column all the way to the right of sheet |
|
Vaccination Status Overview Vaccination Status Person D_Refresh slide-rightmost gShift+L slide current column all the way to the right of sheet |
|
Vaccination Status Overview Vaccination Status Person E_Refresh slide-rightmost gShift+L slide current column all the way to the right of sheet |
|
|
|
Vaccination Status Person A Vaccination rename-col Impfung ^ edit name of current column |
|
Vaccination Status Person A Refresh rename-col Auffrischung ^ edit name of current column |
|
Vaccination Status Person A Vaccinations rename-col Impfungen ^ edit name of current column |
|
Vaccination Status Person A resize-cols-max g_ resize all cols to max |
|
Vaccinations Person A Vaccination rename-col Impfung ^ edit name of current column |
|
Vaccinations Person A Impfung addcol-expr Date = create new column from Python expression, with column names as variables |
|
Vaccinations Person A Date rename-col Datum ^ edit name of current column |
|
Vaccinations Person A Datum addcol-expr RefreshTarget = create new column from Python expression, with column names as variables |
|
Vaccinations Person A RefreshTarget rename-col Frist ^ edit name of current column |
|
Vaccinations Person A Frist type-int # set type of current column to int |
|
Vaccinations Person A Refresh rename-col Auffrischung ^ edit name of current column |
|
Vaccinations Person A Date hide-col - Hide current column |
|
Vaccinations Person A RefreshTarget hide-col - Hide current column |
|
Vaccinations Person A resize-cols-max g_ resize all cols to max |
|
Vaccination Status Person B Vaccination rename-col Impfung ^ edit name of current column |
|
Vaccination Status Person B Refresh rename-col Auffrischung ^ edit name of current column |
|
Vaccination Status Person B Vaccinations rename-col Impfungen ^ edit name of current column |
|
Vaccination Status Person B resize-cols-max g_ resize all cols to max |
|
Vaccinations Person B Vaccination rename-col Impfung ^ edit name of current column |
|
Vaccinations Person B Impfung addcol-expr Date = create new column from Python expression, with column names as variables |
|
Vaccinations Person B Date rename-col Datum ^ edit name of current column |
|
Vaccinations Person B Datum addcol-expr RefreshTarget = create new column from Python expression, with column names as variables |
|
Vaccinations Person B RefreshTarget rename-col Frist ^ edit name of current column |
|
Vaccinations Person B Frist type-int # set type of current column to int |
|
Vaccinations Person B Refresh rename-col Auffrischung ^ edit name of current column |
|
Vaccinations Person B Date hide-col - Hide current column |
|
Vaccinations Person B RefreshTarget hide-col - Hide current column |
|
Vaccinations Person B resize-cols-max g_ resize all cols to max |
|
Vaccination Status Person C Vaccination rename-col Impfung ^ edit name of current column |
|
Vaccination Status Person C Refresh rename-col Auffrischung ^ edit name of current column |
|
Vaccination Status Person C Vaccinations rename-col Impfungen ^ edit name of current column |
|
Vaccination Status Person C resize-cols-max g_ resize all cols to max |
|
Vaccinations Person C Vaccination rename-col Impfung ^ edit name of current column |
|
Vaccinations Person C Impfung addcol-expr Date = create new column from Python expression, with column names as variables |
|
Vaccinations Person C Date rename-col Datum ^ edit name of current column |
|
Vaccinations Person C Datum addcol-expr RefreshTarget = create new column from Python expression, with column names as variables |
|
Vaccinations Person C RefreshTarget rename-col Frist ^ edit name of current column |
|
Vaccinations Person C Frist type-int # set type of current column to int |
|
Vaccinations Person C Refresh rename-col Auffrischung ^ edit name of current column |
|
Vaccinations Person C Date hide-col - Hide current column |
|
Vaccinations Person C RefreshTarget hide-col - Hide current column |
|
Vaccinations Person C resize-cols-max g_ resize all cols to max |
|
Vaccination Status Person D Vaccination rename-col Impfung ^ edit name of current column |
|
Vaccination Status Person D Refresh rename-col Auffrischung ^ edit name of current column |
|
Vaccination Status Person D Vaccinations rename-col Impfungen ^ edit name of current column |
|
Vaccination Status Person D resize-cols-max g_ resize all cols to max |
|
Vaccinations Person D Vaccination rename-col Impfung ^ edit name of current column |
|
Vaccinations Person D Impfung addcol-expr Date = create new column from Python expression, with column names as variables |
|
Vaccinations Person D Date rename-col Datum ^ edit name of current column |
|
Vaccinations Person D Datum addcol-expr RefreshTarget = create new column from Python expression, with column names as variables |
|
Vaccinations Person D RefreshTarget rename-col Frist ^ edit name of current column |
|
Vaccinations Person D Frist type-int # set type of current column to int |
|
Vaccinations Person D Refresh rename-col Auffrischung ^ edit name of current column |
|
Vaccinations Person D Date hide-col - Hide current column |
|
Vaccinations Person D RefreshTarget hide-col - Hide current column |
|
Vaccinations Person D resize-cols-max g_ resize all cols to max |
|
Vaccination Status Person E Vaccination rename-col Impfung ^ edit name of current column |
|
Vaccination Status Person E Refresh rename-col Auffrischung ^ edit name of current column |
|
Vaccination Status Person E Vaccinations rename-col Impfungen ^ edit name of current column |
|
Vaccination Status Person E resize-cols-max g_ resize all cols to max |
|
Vaccinations Person E Vaccination rename-col Impfung ^ edit name of current column |
|
Vaccinations Person E Impfung addcol-expr Date = create new column from Python expression, with column names as variables |
|
Vaccinations Person E Date rename-col Datum ^ edit name of current column |
|
Vaccinations Person E Datum addcol-expr RefreshTarget = create new column from Python expression, with column names as variables |
|
Vaccinations Person E RefreshTarget rename-col Frist ^ edit name of current column |
|
Vaccinations Person E Frist type-int # set type of current column to int |
|
Vaccinations Person E Refresh rename-col Auffrischung ^ edit name of current column |
|
Vaccinations Person E Date hide-col - Hide current column |
|
Vaccinations Person E RefreshTarget hide-col - Hide current column |
|
Vaccinations Person E resize-cols-max g_ resize all cols to max |
|
|
|
sheets name キVaccination Status Person E edit-cell Impfstatus Tom e edit contents of current cell |
|
sheets name キVaccinations Person E edit-cell Impfungen Tom e edit contents of current cell |
|
Impfstatus Tom disp_displayer set-option full |
|
Vaccination Status Overview Vaccination Status Person E_Refresh rename-col Tom ^ edit name of current column |
|
sheets name キVaccination Status Person D edit-cell Impfstatus Markus e edit contents of current cell |
|
sheets name キVaccinations Person D edit-cell Impfungen Markus e edit contents of current cell |
|
Impfstatus Markus disp_displayer set-option full |
|
Vaccination Status Overview Vaccination Status Person D_Refresh rename-col Markus ^ edit name of current column |
|
sheets name キVaccination Status Person C edit-cell Impfstatus Tanja e edit contents of current cell |
|
sheets name キVaccinations Person C edit-cell Impfungen Tanja e edit contents of current cell |
|
Impfstatus Tanja disp_displayer set-option full |
|
Vaccination Status Overview Vaccination Status Person C_Refresh rename-col Tanja ^ edit name of current column |
|
sheets name キVaccination Status Person B edit-cell Impfstatus Angelika e edit contents of current cell |
|
sheets name キVaccinations Person B edit-cell Impfungen Angelika e edit contents of current cell |
|
Impfstatus Angelika disp_displayer set-option full |
|
Vaccination Status Overview Vaccination Status Person B_Refresh rename-col Angelika ^ edit name of current column |
|
sheets name キVaccination Status Person A edit-cell Impfstatus Werner e edit contents of current cell |
|
sheets name キVaccinations Person A edit-cell Impfungen Werner e edit contents of current cell |
|
Impfstatus Werner disp_displayer set-option full |
|
Vaccination Status Overview Vaccination Status Person A_Refresh rename-col Werner ^ edit name of current column |
|
|
|
Vaccination Status Overview resize-cols-max g_ resize all cols to max |
|
Vaccination Status Overview Vaccination rename-col Impfung ^ edit name of current column |
|
rename-sheet Gesamtimpfstatus Rename current sheet |
|
Gesamtimpfstatus disp_displayer set-option full |
