{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["AdaptData"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"AdaptData","index":0,"n_rows":9,"n_cols":1,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,1,8],[3,0,7,8],[8,0,60,8],[2,0,2,8]]}
["Macro to format data for use in Pkanalix"]
[]
["Version March 21st 2022"]
[]
[]
[]
[]
[]
["Steps to follow to adapt the data format:\n* Click on the button \"Adapt data for PKanalix\" and choose the dataset file to open in Excel\n* Fill the form to give information on the dataset:\n-- In case of several sheets, select the name of the sheet to adapt\n-- Select the columns containing ID, TIME and OBSERVATION information\n-- If individual concentrations should be split in different profiles by occasions, check the option \"Occasions: by sort variables\", select one or two levels, and select the column(s) containing the OCCASION information\n-- If individual concentrations should be split by intervals of successive times, check the option \"Occasion: by time intervals\"\n--In case of urine data, change the corresponding radio button and select the columns containing each collection interval START TIME and END TIME, and the column containing VOLUME information.\n-- Give treatment information: single/multiple dose, time of first dose, dose amount (individual dose amounts can be read from a column of the dataset), number of doses, inter-dose interval, and infusion duration in case of IV infusion.\n-- In case of censored observations, indicate the tag(s) representing censored observations in the dataset if it is different than the default tags (several tags can be entered, separated by commas without spaces), and give the value of LLOQ or the header of a column containing LLOQ values.\n* Click on \"Format data\" and wait for the result.\n\nResult:\n* The formatted dataset is saved in a new .xlsx file with a name derived from the original name.\n* If requested in the form, the formatted dataset is also saved in a new .csv file. If the initial file has several sheets, the sheet name is added to the CSV file name.\n* If the file already exists, a new sheet is added to the file, unless a sheet with the same name already exists.\n* All changes are highlighted with colors: \n-- blue = dosing time or amount,\n-- gray = missing observation, \n-- orange = censored observations, \n-- green = urine volume at dosing time, \n-- yellow = new occasions as integers.\n\nActions performed by the macro:\n* A column AMT is added, containing the same dosing regimen for all subjects or subject-occasions (with an option to read individual dose amounts from a column of the dataset). The column is colored in blue, as well as dosing times. Note that the dosing times are correct in the column tagged as TIME in the form, but other time columns will not be consistent.\n* In case of urine data, the volume is set to 0 at dosing times (colored in green) to avoid format errors, and both start and end times of the interval are set to the dosing time. The macro checks that time intervals are continuous (no gaps allowed). Only the column END TIME should be used as TIME in PKanalix.\n* In case of censored observations, a column CENS is added and colored in orange, containing 0 for non-censored observations and 1 for censored observations. The LLOQ is written instead of the censoring tag in the column of observations and colored as well.\n* Missing observations (all values that are not numbers) are replaced by \".\" and colored in gray.\n* In case of occasions, for each column tagged as containing occasions, a new column with the same header concatenated with \"_OCC\" is added with occasion numbers and colored in yellow. If the column tagged already contained numbers, this just duplicates the column, but the initial column can then be used as categorical covariate.\n* In case of occasions by time intervals, two identical columns named Interval_OCC and Interval_CATCOV are created next to the column Time, with indexes of intervals of successive times for each individual.\n* The first lines that do not contain data are concatenated into a single header row.\n* Rows that do not contain data are deleted.\n* Formatting is adapted for correct exporting to CSV format.\n"]