Skip to content

Program to drive proprietary GUI to automatically convert batch of CPF and CDF exports into Excel format.

Notifications You must be signed in to change notification settings

jbowen102/ctrl_export_preprocessor

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

86 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Applies to fix_cpf_export_format.py:
Create .exe from the .py file using PyInstaller in cmd.exe.

Copy this .exe to a folder that contains .XLS exports from CPFs.
When double-clicked, the program will transcribe the data from each .XLS export
to one .xlsx file.
Now you can easily reference the data in those exports from another spreadsheet
(like the CPF fault aggregator spreadsheet).

To get the CPF fault aggregator spreadsheet to read values from the other
spreadsheets, you have to have the source file open. Once all the data appears
in the sheet though, you can copy the whole thing and paste it over itself
("paste as values") to lock it in.

About

Program to drive proprietary GUI to automatically convert batch of CPF and CDF exports into Excel format.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages