Skip to content

Latest commit

 

History

History
14 lines (8 loc) · 603 Bytes

File metadata and controls

14 lines (8 loc) · 603 Bytes

R Scripts

R Scripts for daily, monthly and quarterly data cleaning

ACR-reconciliation.R: R script that takes ACR data and cross checks against our internal database to import missing records

Append.R: R script that appends two csv files through the gtools package's smartbind function.

Reporting.R: R script that cleans and merges data from many files for grant reporting

excelDatesFunction.R: If the variable is a factor, converts excel dates in the format Jan 01, 1990 to 1990-01-01

chart_of_accounts.R: Script that cleans the Chart of Accounts document for format to upload into TrackVia