{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Welcome","Defaults","Data"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":67,"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":"Welcome","index":0,"n_rows":35,"n_cols":5,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["url","https://tis.obss.io"]
["tisjwt"]
["outputType","csv"]
["filterType","project"]
["user",null,null,"Status:","Import complete - ready for next"]
["projectKey","SSP"]
["jqlFilterID"]
["customjql"]
["sprintID"]
["columnsBy","statusDuration",null,"v9 - 24.12.2024"]
["timePeriod",null,null,"How to use this document"]
["averageDenominator",null,null,"Use the colored cells in column B to define report parameters (you need to set at least a token and a projectkey)"]
["multiVisitBehavior",null,null,"Click the RUN button"]
["fields",null,null,"Follow the status of the import in the Status cell just below the Run button"]
["historyFields",null,null,"Your data will be imported to the Data sheet"]
["groupByFields"]
["statuses",null,null,"More Info"]
["assignees",null,null,"This document is designed to get data from Timepiece - Time in Status for Jira by OBSS for Jira Cloud."]
["groups",null,null,"If you want to get data from Timepiece by OBSS for Jira Server / Data Center, see the product documentation to get the relevant file."]
["dbsMetrics",null,null,"For instructions on the use of this document, see the link below:"]
["includeDeletedStatuses","true",null,"Sample Spreadsheet Integration Files"]
["startDate",null,null,"For details on how to get a tisjwt and which parameter values to use, see the link below:"]
["endDate",null,null,"How to start an export?"]
["dateRangeField",null,null,"For further support, e-mail to appsupport@obss.tech or go to appsupport.obss.tech"]
["trimHistoryStartDate",null,null,"Liked Timepiece and this document? Leave us a quick review:"]
["trimHistoryEndDate",null,null,"Review Us"]
["calendar","normalHours"]
["dayLength"]
["viewFormat","hours"]
["dateFormat"," "]
["dateTimeFormat"]
["sortBy"]
["sortDir"]
["filter"]
["emptyValueToken","noChar"]

{"sheet":"Defaults","index":1,"n_rows":19,"n_cols":18,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["statusDuration","statusDuration","fields","groupByFields","dateRangeField","sortDir","viewFormat","groups","calendar","columnsBy","timePeriod","includeDeletedStatuses","filterType","dateTimeFormat","dateFormat","averageDenominator","multiVisitBehavior","emptyValueToken"]
["csv","24HourDays","assignee","assignee","created","desc","humanReadable","jira-administrators","normalHours","statusDuration","Year","true","user","yyyy-MM-dd hh:mm a","yyyy-MM-dd","nonNull","total","hyphen"]
["csvaverage","businessDays","customfield_10020","customfield_10140","updated","asc","ddhhmmss","jira-users",0,"durationBetweenStatuses","Month","false","project","dd/MM/yy HH:mm","dd/MM/yy","rowCount","first","zero"]
["csvsum",null,"customfield_10007",null,"resolved",null,"hhmmss","jira-administrators",1,"statusDurationByTimePeriod","Week",null,"jqlfilter","dd/MMM/yyyy HH:mm:ss","dd/MMM/yyyy",null,"last","null"]
["csvmedian",null,"description",null,null,null,"days",null,2,"timePeriodDurationByStatus","Day",null,"customjql",null,null,null,"average","noChar"]
["csvstddev",null,"fixVersions",null,null,null,"hours",null,null,"assigneeDuration",null,null,"sprint",null,null,null,null,"singleSpace"]
[null,null,null,null,null,null,"minutes",null,null,"statusDurationByAssignee",null,null,null,null,null,null,null,"noToken"]
[null,null,null,null,null,null,"seconds",null,null,"assigneeDurationByStatus"]
[null,null,null,null,null,null,null,null,null,"groupDuration"]
[null,null,null,null,null,null,null,null,null,"statusDurationByGroup"]
[null,null,null,null,null,null,null,null,null,"groupDurationByStatus"]
[null,null,null,null,null,null,null,null,null,"anyFieldDuration"]
[null,null,null,null,null,null,null,null,null,"statusCount"]
[null,null,null,null,null,null,null,null,null,"transitionCount"]
[null,null,null,null,null,null,null,null,null,"anyFieldCount"]
[null,null,null,null,null,null,null,null,null,"firstTransitionFromStatusDate"]
[null,null,null,null,null,null,null,null,null,"firstTransitionToStatusDate"]
[null,null,null,null,null,null,null,null,null,"lastTransitionFromStatusDate"]
[null,null,null,null,null,null,null,null,null,"lastTransitionToStatusDate"]

{"sheet":"Data","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}