Index

_

__init__() (otld.append.append.TANFAppend method) (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.append.gui.TANFData method) (otld.append.TANFData.TANFData method) (otld.tableau.gui.FileSelect method) (otld.tableau.TableauDatasets.TableauDatasets method) (otld.utils.checks.CaseloadDataChecker method) (otld.utils.checks.FinancialDataChecker method) (otld.utils.checks.GenericChecker method) (otld.utils.LineTracker.LineTracker method) (otld.utils.MockData.MockData method) (otld.utils.tkinter_utils.ParentFrame method)

A

action (otld.utils.checks.CaseloadDataChecker property) (otld.utils.checks.FinancialDataChecker property) (otld.utils.checks.GenericChecker property) add_table() (in module otld.utils.openpyxl_utils) add_us_total() (in module otld.append.append_1997_2009) after() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) after_cancel() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) after_idle() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method)

analyze_ambiguous_values() (in module otld.utils.caseload_utils) analyze_guam_data() (in module otld.utils.caseload_utils) anchor() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) append() (otld.append.append.TANFAppend method) (otld.append.gui.TANFData method) (otld.append.TANFData.TANFData method) append_clicked() (otld.append.gui.FileSelect method) append_specifications() (otld.utils.MockData.MockData method) appended (otld.append.TANFData.TANFData property)

B

bbox() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) bell() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) bind() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) bind_all() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) bind_class() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method)

bindtags() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) browse_dir() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) browse_file() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) browse_sheets() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method)

C

calculate_pce() (in module otld.tableau.tableau_datasets_financial) caseload_data_checks() (otld.utils.checks.CaseloadDataChecker method) CaseloadDataChecker (class in otld.utils.checks) cget() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) check() (otld.utils.checks.CaseloadDataChecker method) (otld.utils.checks.FinancialDataChecker method) clean_dataset() (in module otld.utils.caseload_utils) clean_pce() (in module otld.utils.clean_pce) clean_state() (in module otld.utils.caseload_utils) clipboard_append() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) clipboard_clear() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method)

clipboard_get() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) close_excel_files() (otld.append.TANFData.TANFData method) columnconfigure() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) config() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) configure() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) confirm_clicked() (otld.tableau.gui.FileSelect method) consolidate_categories() (in module otld.utils.financial_utils) convert_to_numeric() (in module otld.utils.pandas_utils) create_sys_argv() (otld.tableau.gui.FileSelect method)

D

data_specifications() (otld.utils.MockData.MockData method) delete_empty_columns() (in module otld.utils.openpyxl_utils) deletecommand() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) destroy() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method)

df (otld.utils.checks.CaseloadDataChecker property) (otld.utils.checks.FinancialDataChecker property) (otld.utils.checks.GenericChecker property) dict_to_excel() (in module otld.utils.pandas_utils) display_waiting_window() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method)

E

event_add() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) event_delete() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) event_generate() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method)

event_info() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) excel_to_dict() (in module otld.utils.pandas_utils) export() (otld.utils.checks.CaseloadDataChecker method) (otld.utils.checks.FinancialDataChecker method) (otld.utils.checks.GenericChecker method) (otld.utils.LineTracker.LineTracker method) (otld.utils.MockData.MockData method) export_workbook() (in module otld.utils.openpyxl_utils) (otld.append.TANFData.TANFData method) extract_missing_average() (in module otld.utils.caseload_utils)

F

federal_financial_data_checks() (otld.utils.checks.FinancialDataChecker method) FileSelect (class in otld.append.gui) (class in otld.tableau.gui) FinancialDataChecker (class in otld.utils.checks) find_matching_sheet() (in module otld.append.caseload) focus() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) focus_displayof() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) focus_force() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) focus_get() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method)

focus_lastfor() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) focus_set() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) footnotes (otld.append.TANFData.TANFData property) forget() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) format_final_dataset() (in module otld.utils.caseload_utils) format_openpyxl_worksheet() (in module otld.utils.openpyxl_utils) format_pd_columns() (in module otld.append.format_appended_files) format_state_index() (in module otld.append.combine_appended_files)

G

gen_carryover() (in module otld.append.append_1997_2009) gen_consolidation_map() (in module otld.utils.consolidation) generate() (otld.tableau.TableauDatasets.TableauDatasets method) generate_data() (otld.utils.MockData.MockData method) generate_long_data() (in module otld.tableau.tableau_datasets_caseload) (in module otld.tableau.tableau_datasets_financial) (otld.tableau.TableauDatasets.TableauDatasets method) generate_rows() (otld.utils.MockData.MockData method) generate_wide_data() (in module otld.tableau.tableau_datasets_caseload) (in module otld.tableau.tableau_datasets_financial) (otld.tableau.TableauDatasets.TableauDatasets method) GenericChecker (class in otld.utils.checks) get_column_list() (in module otld.append.combine_appended_files) get_column_names() (in module otld.utils.openpyxl_utils) get_consolidated_column() (in module otld.tableau.tableau_datasets_financial) get_cpi_u() (in module otld.utils.get_cpi_u) get_current_sheet() (otld.append.TANFData.TANFData method) get_df() (otld.append.TANFData.TANFData method) get_files() (otld.append.append.TANFAppend method) (otld.append.gui.TANFData method) get_header() (in module otld.utils.pandas_utils) get_header_wrapper() (otld.append.TANFData.TANFData method) get_merged_value() (in module otld.utils.openpyxl_utils) get_note() (in module otld.utils.validation) get_relevant_columns() (in module otld.append.append_1997_2009) get_sheets() (otld.append.append.TANFAppend method) (otld.append.gui.TANFData method) get_tanf_df() (in module otld.append.append_1997_2009) (in module otld.append.append_2010_2014) (in module otld.append.append_2015_2023) get_tanf_files() (in module otld.append.append_1997_2009) get_worksheets() (otld.append.TANFData.TANFData method) getboolean() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) getvar() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) grab_current() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) grab_release() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) grab_set() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) grab_set_global() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method)

grab_status() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) grid() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) grid_anchor() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) grid_bbox() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) grid_columnconfigure() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) grid_configure() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) grid_forget() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) grid_info() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) grid_location() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) grid_propagate() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) grid_remove() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) grid_rowconfigure() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) grid_size() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) grid_slaves() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method)

I

identify() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) identify_workbook_level() (otld.append.TANFData.TANFData method) image_names() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) image_types() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method)

inflation_adjust() (in module otld.tableau.tableau_datasets_financial) info() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) info_patchlevel() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) instate() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method)

K

keys() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method)

kind (otld.utils.checks.CaseloadDataChecker property) (otld.utils.checks.FinancialDataChecker property) (otld.utils.checks.GenericChecker property)

L

level (otld.utils.checks.CaseloadDataChecker property) (otld.utils.checks.FinancialDataChecker property) (otld.utils.checks.GenericChecker property) lift() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) lines_to_names() (otld.utils.checks.FinancialDataChecker method) LineTracker (class in otld.utils.LineTracker)

load_data() (otld.append.TANFData.TANFData method) location() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) long_notes() (in module otld.utils.openpyxl_utils) lower() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method)

M

main() (in module otld.append.append) (in module otld.append.append_1997_2009) (in module otld.append.append_2010_2014) (in module otld.append.append_2015_2023) (in module otld.append.caseload) (in module otld.append.combine_appended_files) (in module otld.append.format_appended_files) (in module otld.append.gui) (in module otld.tableau.gui) (in module otld.tableau.tableau_datasets_caseload) (in module otld.tableau.tableau_datasets_financial) (in module otld.tableau.TableauDatasets) (in module otld.utils.generate_column_dict_196) (in module otld.utils.generate_column_dict_196_r) (in module otld.utils.missingness) (in module otld.utils.validation) mainloop() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) make_negative_string() (in module otld.utils.string_utils) map_columns() (in module otld.utils.crosswalk_2014_2015) merge_datasets() (in module otld.utils.caseload_utils) MockData (class in otld.utils.MockData) module otld otld.append otld.append.append otld.append.append_1997_2009 otld.append.append_2010_2014 otld.append.append_2015_2023 otld.append.caseload otld.append.combine_appended_files otld.append.format_appended_files otld.append.gui otld.append.TANFData otld.paths otld.tableau otld.tableau.gui otld.tableau.tableau_datasets_caseload otld.tableau.tableau_datasets_financial otld.tableau.TableauDatasets otld.utils otld.utils.caseload_utils otld.utils.checks otld.utils.clean_pce otld.utils.consolidation otld.utils.crosswalk_2014_2015 otld.utils.crosswalk_dict otld.utils.financial_utils otld.utils.generate_column_dict_196 otld.utils.generate_column_dict_196_r otld.utils.get_cpi_u otld.utils.LineTracker otld.utils.missingness otld.utils.MockData otld.utils.openpyxl_utils otld.utils.pandas_utils otld.utils.states otld.utils.string_utils otld.utils.tableau_utils otld.utils.tkinter_utils otld.utils.validate_data_frame otld.utils.validation

N

names_to_lines() (otld.utils.checks.FinancialDataChecker method) nametowidget() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method)

O

option_add() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) option_clear() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) option_get() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) option_readfile() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) otld module otld.append module otld.append.append module otld.append.append_1997_2009 module otld.append.append_2010_2014 module otld.append.append_2015_2023 module otld.append.caseload module otld.append.combine_appended_files module otld.append.format_appended_files module otld.append.gui module otld.append.TANFData module otld.paths module otld.tableau module otld.tableau.gui module otld.tableau.tableau_datasets_caseload module otld.tableau.tableau_datasets_financial module

otld.tableau.TableauDatasets module otld.utils module otld.utils.caseload_utils module otld.utils.checks module otld.utils.clean_pce module otld.utils.consolidation module otld.utils.crosswalk_2014_2015 module otld.utils.crosswalk_dict module otld.utils.financial_utils module otld.utils.generate_column_dict_196 module otld.utils.generate_column_dict_196_r module otld.utils.get_cpi_u module otld.utils.LineTracker module otld.utils.missingness module otld.utils.MockData module otld.utils.openpyxl_utils module otld.utils.pandas_utils module otld.utils.states module otld.utils.string_utils module otld.utils.tableau_utils module otld.utils.tkinter_utils module otld.utils.validate_data_frame module otld.utils.validation module

P

pack() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) pack_append_button() (otld.append.gui.FileSelect method) pack_appended() (otld.append.gui.FileSelect method) (otld.tableau.gui.FileSelect method) pack_configure() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) pack_confirm_button() (otld.tableau.gui.FileSelect method) pack_destination() (otld.tableau.gui.FileSelect method) pack_footnotes() (otld.append.gui.FileSelect method) pack_forget() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) pack_inflation() (otld.tableau.gui.FileSelect method) pack_info() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) pack_propagate() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) pack_sheets() (otld.append.gui.FileSelect method) pack_slaves() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) pack_to_append() (otld.append.gui.FileSelect method) pack_type() (otld.append.gui.FileSelect method) (otld.tableau.gui.FileSelect method)

pandas (otld.utils.MockData.MockData property) ParentFrame (class in otld.append.gui) (class in otld.utils.tkinter_utils) parse_args() (otld.append.append.TANFAppend method) (otld.append.gui.TANFData method) (otld.tableau.TableauDatasets.TableauDatasets method) parse_arguments() (in module otld.utils.validation) place() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) place_configure() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) place_forget() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) place_info() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) place_slaves() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) process_1997_1998_1999_data() (in module otld.utils.caseload_utils) process_sheet() (in module otld.utils.caseload_utils) process_workbook() (in module otld.append.caseload) propagate() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method)

Q

quit() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method)

R

register() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) reindex_state_year() (in module otld.utils.financial_utils) rename_columns() (in module otld.append.append_1997_2009) (in module otld.append.append_2010_2014) (in module otld.append.append_2015_2023) (otld.append.TANFData.TANFData method)

reorder_alpha_numeric() (in module otld.append.combine_appended_files) rowconfigure() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method)

S

selection_clear() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) selection_get() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) selection_handle() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) selection_own() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) selection_own_get() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) send() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) set_column_widths() (in module otld.utils.openpyxl_utils) set_sheets() (otld.append.TANFData.TANFData method) setup() (otld.append.append.TANFAppend method) (otld.append.gui.TANFData method)

setvar() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) sheet_dict (otld.append.TANFData.TANFData property) show_error() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) size() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) slaves() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) split_line() (in module otld.utils.generate_column_dict_196) (in module otld.utils.generate_column_dict_196_r) split_year_month() (in module otld.utils.clean_pce) standardize_file_name() (in module otld.utils.string_utils) standardize_line_number() (in module otld.utils.string_utils) state() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method)

T

tableau (otld.append.TANFData.TANFData property) TableauDatasets (class in otld.tableau.TableauDatasets) TANFAppend (class in otld.append.append) TANFData (class in otld.append.gui) (class in otld.append.TANFData) tk_bisque() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) tk_focusFollowsMouse() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) tk_focusNext() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) tk_focusPrev() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method)

tk_setPalette() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) tk_strictMotif() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) tkraise() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) to_append (otld.append.TANFData.TANFData property) transform_caseload_long() (in module otld.tableau.tableau_datasets_caseload) transform_financial_long() (in module otld.tableau.tableau_datasets_financial) type (otld.append.TANFData.TANFData property) (otld.utils.MockData.MockData property)

U

unbind() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) unbind_all() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) unbind_class() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method)

update() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) update_consolidation_map() (in module otld.utils.consolidation) update_idletasks() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method)

V

validate() (otld.tableau.TableauDatasets.TableauDatasets method) (otld.utils.MockData.MockData method)

validate_data_frame() (otld.append.TANFData.TANFData method) validate_values() (in module otld.utils.validation) validate_wide_format() (in module otld.utils.validation)

W

wait_variable() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) wait_visibility() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) wait_window() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) waitvar() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) wide_with_index() (in module otld.utils.tableau_utils) winfo_atom() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) winfo_atomname() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) winfo_cells() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) winfo_children() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) winfo_class() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) winfo_colormapfull() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) winfo_containing() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) winfo_depth() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) winfo_exists() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) winfo_fpixels() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) winfo_geometry() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) winfo_height() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) winfo_id() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) winfo_interps() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) winfo_ismapped() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) winfo_manager() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) winfo_name() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) winfo_parent() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) winfo_pathname() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) winfo_pixels() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) winfo_pointerx() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) winfo_pointerxy() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) winfo_pointery() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method)

winfo_reqheight() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) winfo_reqwidth() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) winfo_rgb() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) winfo_rootx() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) winfo_rooty() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) winfo_screen() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) winfo_screencells() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) winfo_screendepth() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) winfo_screenheight() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) winfo_screenmmheight() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) winfo_screenmmwidth() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) winfo_screenvisual() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) winfo_screenwidth() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) winfo_server() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) winfo_toplevel() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) winfo_viewable() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) winfo_visual() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) winfo_visualid() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) winfo_visualsavailable() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) winfo_vrootheight() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) winfo_vrootwidth() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) winfo_vrootx() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) winfo_vrooty() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) winfo_width() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) winfo_x() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) winfo_y() (otld.append.gui.FileSelect method) (otld.append.gui.ParentFrame method) (otld.tableau.gui.FileSelect method) (otld.utils.tkinter_utils.ParentFrame method) workbooks (otld.utils.MockData.MockData property)

Y

year (otld.utils.MockData.MockData property)