clean_format_all {uscoauditlog}

Main Function

Description

Takes in a .xlsx file and returns the formatted data into a new .xlsx and .txt file according to the format of the U.S. Copyright Office SR Audit Data online database.

Usage

clean_format_all(excelfile)

Arguments

excelfile

Input the original raw SR Audit Data spreadsheet

Value

Returns an excel sheet and text file that includes the cleaned and formatted data that are congruent to the format of the U.S. Copyright Office SR Audit Data online database.

Examples

#This is the main function. Users should be only using this function for data cleaning.
## Not run: 
filename = "data.xlsx"
clean_format_all(excelfile)

## End(Not run)