9b: FreeCEN CSVCHECK

[9b]

FreeCEN CSVCHECK

Although its essential routine forms part of FCTOOLS, CSVCHECK is prepared as a free-standing, simple-to-operate, routine to enable Spreadsheet workers to test their own work and to ensure compliance with the FreeCEN requirements.

INSTALLATION

CSVCHECK may be installed to any Hard Drive, but must be installed into a main folder named \FCTOOLS\.
RUN CSVCHK.EXE to expand the file contents.
RUN CSVCHECK.EXE to start the programme.

Before starting the programme:

Print out for future reference the document "REPORTS.TXT" which will be found in the \FCTOOLS\ folder.
Until you are familiar with the SSCENS requirements it will be beneficial to test your spreadsheet work frequently to ensure that you are maintaining "good practices".

To Test a Spreadsheet file:

The spreadsheet must have been saved to a floppy disk, using "Comma Separated Variable" format.
The filetype must be ",CSV"; (rename any Apple/Mac ".SLK" file as .CSV in order to test.)
The spreadsheet must start with the three rows used to set up the new spreadsheet. (see SSCENS [4b2])
The spreadsheet, as saved, must comprise exactly 25 columns

Failure to comply with these requirements will result in inability to test the file (which would also not be compliant for conversion to the FreeCEN format).

With the floppy disk in the drive:
RUN CSVCHECK.EXE (or start from a Desktop Icon)
Observe all messages and prompts.
The routine is very rapid and will produce an "Error Report" onto the floppy disk. The report is in the form of a .TXT file and may be viewed or printed from NotePad or other word-processing programme.

The Error Report should be examined quickly on-screen (before closing CSVCHECK) to determine the nature of any reported problems. It will be seen that the report identifies the spreadsheet Row number for each defect.
In the event that more that (say) 200 defects are reported it is useful to browse the report and see whether there is a common fault relating to a significant number of 'events' (e.g. "data missing").
It can be beneficial to revisit the spreadsheet and rectify such matters before retesting the file and getting a much smaller Error Report.

Personal technique for dealing with corrections may vary according to preference:
You may choose to work between two screens, one displaying the spreadsheet, the other displaying the Error Report.,
or to work from a printout of the Error Report,
or to set up your monitor as a "split screen" so that both the spreadsheet and the Error Report are displayed at the same time.
Whichever method is chosen, it will be useful to have the printed document "REPORTS.TXT" handy for reference.

A spreadsheet may need progressive correction and re-testing several times before the Error Report is only advising 'Warnings' for conditions that you are unable to alter, e.g. where schedules were not written in correct sequence by the Enumerator!
ALL defects identified as "ERROR" must be rectified.

Use [Browser Back] .