{"text_format":"3","workbook":"xls","n_sheets":3,"sheets":["protocols","protocolProducts","protocolToPatients"],"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"protocols","index":0,"n_rows":8,"n_cols":4,"rows_kept":8,"flags":["formulas_cached_only"]}
["attribute(ORO)","Type(ORO)","attribute(IFS)","Comment"]
["customerUser","CustomerUser","CustomerContact(personId)","personId + customerId?"]
["store","Customer","CustomerId","sample: 1340106"]
["name","string (64)","name","required"]
["description","string (1024)","description"]
["note","string (1024)","note"]
["createdAt","Date","createdAt","format: Y-m-d H:i:s"]
["updatedAt","Date","updatedAt","format: Y-m-d H:i:s"]

{"sheet":"protocolProducts","index":1,"n_rows":9,"n_cols":4,"rows_kept":9,"flags":["formulas_cached_only"]}
["attribute(ORO)","Type(ORO)","attribute(IFS)","Comment"]
["protocol","Protocol",null,"protocol id"]
["product","Product","partNo"]
["quantity","int (4)","Quantity","quantity"]
["unit","string (255)","unit","product unit: each"]
["price","numeric(19, 4)","price","product price: 13.51"]
["note","string (1024)","note","product note"]
["createdAt","Date","createdAt","format: Y-m-d H:i:s"]
["updatedAt","Date","updatedAt","format: Y-m-d H:i:s"]

{"sheet":"protocolToPatients","index":2,"n_rows":7,"n_cols":4,"rows_kept":7,"flags":["formulas_cached_only"]}
["attribute(ORO)","Type(ORO)","attribute(IFS)","Comment"]
["protocol","Protocol",null,"protocol id"]
["patient","CustomerUser","customerContact","personId + customerId?"]
["note","string (1024)","note"]
["createdAt","Date","createdAt","format: Y-m-d H:i:s"]
["updatedAt","Date","updatedAt","format: Y-m-d H:i:s"]
["protocolProductNote","json","protocolProductNote","note for each product, sample:\nL0324 is partNo\n {\n  \"L0324\": \"note fo 7100\", \n   \"L0327\": \"7030note\"\n }"]