bohdanszymanik

# data was closed incidents in a tab separated txt file that looked like this
# week  category  P1  P2  P3
# sucked up into R it formed a data frame like so
# 1 28/05/2012  some category1  NA  NA  1
# 2 28/05/2012  some category2  NA  2   1
# 3 28/05/2012  some category3  1   NA  1
# 4 28/05/2012  some category4  NA  NA  2

# as it happens, this data was manually collected from excel spreadsheets
# unfortunately the spreadsheets were for differing week ranges and there was some overlap with

bohdanszymanik

open System
open System.IO

let cSs = File.ReadAllLines(@"C:\Extras\kfoundry1.6.4\520x50a.txt")
(* 
    Raw form data exported from kfoundry with baseline at the waterline looks like this:

    Form Position, X (mm), Y (mm)
    ...
    Form at 52 cm, 60, 39.3333