{"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":65,"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":34,"n_cols":5,"rows_kept":34,"cut":false,"hidden":false,"merged":[[24,3,24,6]]}
["Jira URL"]
["username"]
["password"]
["token"]
["outputType","csv"]
["filterType","project",null,null,"Import complete - ready for next"]
["user",null,null,"Status:","Import complete - ready for next"]
["projectKey","SSP"]
["jqlFilterID"]
["customjql"]
["sprintID"]
["columnsBy","statusDuration",null,"v7 - 13.10.2025"]
["averageDenominator",null,null,"How to use this document"]
["multiVisitBehavior",null,null,"Use the colored cells in column B to define report parameters (you need to set at least a Jira URL and a projectkey) Also you need to define username / password or acces token for authentication"]
["fields",null,null,"Click the RUN button"]
["historyFields",null,null,"Follow the status of the import in the Status cell just below the Run button"]
["groupByFields",null,null,"Your data will be imported to the Data sheet"]
["statuses"]
["assignees",null,null,"More Info"]
["groups",null,null,"This document is designed to get data from Timepiece - Time in Status for Jira by OBSS for Jira Server / DataCenter"]
["dbsMetrics",null,null,"If you want to get data from Timepiece - Time in Status for Jira by OBSS for Jira Server / Data Center, see the product documentation to get the relevant file."]
["includeDeletedStatuses","true",null,"For instructions on the use of this document, see the link below:"]
["startDate",null,null,"Sample Speadsheet Integration Files"]
["endDate",null,null,"For details on which parameter values to use, see the link below:"]
["dateRangeField",null,null,"REST Reporting"]
["trimHistoryStartDate",null,null,"For further support, e-mail to appsupport@obss.tech or go to appsupport.obss.tech"]
["trimHistoryEndDate",null,null,"Liked Timepiece and this document? Leave us a quick review:"]
["calendar","normalHours",null,"Review Us"]
["dayLength"]
["viewFormat","hours"]
["dateFormat"," "]
["dateTimeFormat"]
["sortBy"]
["sortDir"]

{"sheet":"Defaults","index":1,"n_rows":17,"n_cols":16,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["statusDuration","statusDuration","fields","groupByFields","dateRangeField","sortDir","viewFormat","groups","calendar","columnsBy","includeDeletedStatuses","filterType","dateTimeFormat","dateFormat","averageDenominator","multiVisitBehavior"]
["csv","24HourDays","assignee","assignee","created","desc","humanReadable","jira-administrators","normalHours","statusDuration","true","user","yyyy-MM-dd hh:mm a","yyyy-MM-dd","nonNull","total"]
["csvaverage","businessDays","customfield_10020","customfield_10140","updated","asc","ddhhmmss","jira-users",0,"durationBetweenStatuses","false","project","dd/MM/yy HH:mm","dd/MM/yy","rowCount","first"]
["csvsum",null,"customfield_10007",null,"resolved",null,"hhmmss","jira-administrators",1,"assigneeDuration",null,"jqlfilter","dd/MMM/yyyy HH:mm:ss","dd/MMM/yyyy",null,"last"]
["csvmedian",null,"description",null,null,null,"days",null,2,"statusDurationByAssignee",null,"customjql",null,null,null,"average"]
["csvstddev",null,"fixVersions",null,null,null,"hours",null,null,"assigneeDurationByStatus",null,"sprint"]
[null,null,null,null,null,null,"minutes",null,null,"groupDuration"]
[null,null,null,null,null,null,"seconds",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":7,"n_cols":5,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Key","Summary","Backlog","Selected for Development","In Progress"]
["DP-6","Tst",52038431633333,"-","-"]
["DP-5","Subtask1",1413605455,72957821713889,"-"]
["DP-4","Test Task 2",25676995872222,"-",61416983269444]
["DP-3","Test Task 3",102492432733333,"-","-"]
["DP-2","Test Task 2",102492481519444,"-","-"]
["DP-1","Test Task 1",102492536130556,"-","-"]