Reference

Workflow
folder_setup()	Setup Folder Structure in Project
return_latest()	Return Latest File
set_paths()	Set SI local folder paths
setup_gitignore()	Setup gitignore in Project
setup_readme()	Setup README with Disclaimer in Project
si_path()	Access SI folderpath
si_setup()	Default SI Project Setup
extract_excel_data()	Extract data from excel link
extract_tbl_data()	Extract table data from web page
Authentication
datim_pwd()	Return DATIM password
datim_user()	Return DATIM username
pano_pwd()	Return PEPFAR Panorama password
pano_user()	Return PEPFAR Panorama username
pdap_access()	Store PDAP Access Key credentials
pdap_secret()	Store PDAP Secret Access Key credentials
pdap_bucket()	Access PDAP read/write bucket
get_s3key()	Get S3 Credentials - Access or Secret Access Key
load_secrets()	Load credentials
is_stored()	Test if service is stored in credential manager
get_key()	Get value of service key name
get_keys()	Get Service Keys
get_services()	Get Services
get_account()	Get account details
Authentication Setup
set_datim()	Store DATIM credentials
set_email()	Store USAID email
set_pano()	Store PEPFAR Panorama credentials
set_s3keys()	Store S3 Credentials
set_key()	Set value for service name
set_account()	Create / Update account
Google Drive
gdrive_folder()	Get id of googledrive folder
import_drivefile()	Import file from a Google Drive folder
export_drivefile()	Export local files for googledrive folder
gdrive_metadata()	Unpack Google Drive Metadata
Tidying
clean_countries()	Clean Natural Earth Country names to match PEPFAR Data
clean_filename()	Clean Filename
connect_text()	Clean and connect parts of text together
extract_text()	Extract text
lookup_country()	Lookup official Country name
Date Conversion
curr_date()	Get formatted current date
convert_date_to_qtr()	Convert Date to FY Quarter/Period
convert_datim_pd_to_qtr()	Convert DATIM CY Quarter/Period to FY Quarter
convert_qtr_to_date()	Convert FY Quarter/Period to Date
convert_fy_qtr_to_pd()	Convert Fiscal Year and Quarter into Period
Utilities
`%ni%`	Negate in
reexports %%	Assignment Pipe Operator
gen_ref_id()	Generate Reference ID
prinf()	Print All Rows
package_check()	Check if package exists
temp_folder()	Generate Temporary Folder
open_path()	Open directory explorer or files
Data Sets
pepfar_country_list	Current List of PEPFAR OUs/Countries and their ISO codes
pepfar_country_xwalk	Cross-walk of Country names
pepfar_data_calendar	Current PEPFAR Data Calendar