{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Basic info","Scorecards","Measures","Series","Roles","Metadata"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":10,"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":"Basic info","index":0,"n_rows":27,"n_cols":6,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Server name","localhost"]
["Server port",20761,"(default is 20761)",null,null,"DESCRIPTION OF THE OPERATIONS:"]
["username","qpr",null,null,null,"- Create new model button creates a new Metrics model."]
["password","demo",null,null,null,"- Export from Metrics button transfers scorecards, measures and Metrics model metadata from Metrics to this Excel."]
["Metrics model name","Dentorex Group Scorecard",null,null,null,"- Export Metadata from Metrics transfer only Metrics model's metadata from Metrics to this Excel."]
["v.1.0.0",null,null,null,null,"- Import to Metrics transfers scorecards and measures from this Excel to a Metrics model."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"IMPORTANT NOTES:"]
[null,"- Series and roles are edited in an own sheet by double clicking Series or Roles column in Measures sheet."]
[null,"- Using all the operation requires connection to Metrics. Excel editing may be done offline."]
[null,"- Don't edit \"Scorecard ID\" and \"Measure ID\" manually. In the import they are used to identify, whether an element has already been created."]
[null,"- When creating new scorecards and measures, the symbol may be left empty."]
[null,"- Scorecard's and measure's order is freely selectable. You can also sort and filter scorecards and measures."]
[null,"- In reference measures only scorecard name and parent element name may be changed (other properties have no effect)."]
[null,"- You may use Excel's copy features to edit properties, e.g. copy same property to many measures."]
[null,"- Value settings, period level, accumulation rule and measure type cannot be set empty in Metrics. If those are set empty in Excel, the importing ignores these properties."]
[null,"- It is not possible update element type using this Excel tool (QPR API doesn't support it)."]
[null,"- When changing value settings, series specific settings are removed."]
[null,"- Empty graph template in Excel means Custom template in Metrics."]
[null,"- Known issue: Every element type must have at least one role defined (otherwise error will result) (appears at least in QPR 2012)."]

{"sheet":"Scorecards","index":1,"n_rows":2,"n_cols":25,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["ScorecardId","NAME","IDENTIFIER","PARENTSCORECARDID","DESCRIPTION","BASESCORECARD","OWNER","INHERITANCEOPTIONS:name","INHERITANCEOPTIONS:description","INHERITANCEOPTIONS:elementtype","INHERITANCEOPTIONS:measureunit","INHERITANCEOPTIONS:roles","INHERITANCEOPTIONS:valuesettings","INHERITANCEOPTIONS:periodlevel","INHERITANCEOPTIONS:accumulationrule","INHERITANCEOPTIONS:indicatorproperties","INHERITANCEOPTIONS:chartproperties","INHERITANCEOPTIONS:viewsettings","INHERITANCEOPTIONS:seriessettings","INHERITANCEOPTIONS:values","INHERITANCEOPTIONS:scorecardstructure","INHERITANCEOPTIONS:scorecardstructure_noref","INHERITANCEOPTIONS:scorecardstructure_addonly","INHERITANCEOPTIONS:graphlayoutproperties","index"]
["Scorecard ID","Scorecard name","Symbol","Parent scorecard name","Description","Base scorecard name","Scorecard owner","Inheritance:\nElement name","Inheritance:\nElement description","Inheritance:\nElement type","Inheritance:\nMeasurement unit","Inheritance:\nRoles","Inheritance:\nValue settings","Inheritance:\nPeriod level","Inheritance:\nPeriodic accumulation","Inheritance:\nLayout properties","Inheritance:\nChart properties","Inheritance:\nView settings","Inheritance:\nSeries settings","Inheritance:\nValues","Scorecard structure\n(with references)","Scorecard structure\n(no references)","Scorecard structure\n(add only)","Graph layout properties"]

{"sheet":"Measures","index":2,"n_rows":179,"n_cols":22,"rows_kept":179,"cut":false,"hidden":false,"merged":[]}
["ID","SCORECARDID","NAME","IDENTIFIER","ELEMENTTYPEID","PARENTELEMENTID","DESCRIPTION","MEASUREUNITID","VALUESETTINGID","PERIODLEVELID","ACCUMULATIONRULE","CHARTTEMPLATE","enableautomaticreferencing","drilldowndepth","referencewithidentifier","referencewithname","removeunmatching","series","referenceMeasure","referenceScorecard","roles","index"]
["Measure ID","Scorecard name","Measure name","Symbol","Measure type","Parent element name","Description","Measure unit","Value settings","Period level","Periodic accumulation","Graph template","Drilldown enabled","Drilldown depth","Reference with symbol","Reference with name","Remove unmatching","Series","Original measure\n(for reference measures)","Original scorecard\n(for reference measures)","Roles"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1775013582:1;"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1775013582:1;"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1775013582:1;2031715850:1;"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1775013582:1;2031715850:1;"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1:1;"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1775013582:1;2031715850:1;"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1775013582:1;2031715850:1;"]

{"sheet":"Series","index":3,"n_rows":4,"n_cols":7,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["Scorecard"]
["Measure"]
[]
["Series","Series label","Input type","Measure unit","Accumulation rule","Formula","Id"]

{"sheet":"Roles","index":4,"n_rows":4,"n_cols":3,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["Scorecard"]
["Measure"]
[]
["Role name","User","Id"]

{"sheet":"Metadata","index":5,"n_rows":2,"n_cols":30,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30"]
["valuesetting id","valuesetting name","series id","series name","valuesetting id","range id","range name","valuesetting id","periodlevel id","periodlevel name","period id","period name","periodlevel id","measureunit id","measureunit name","charttemplate id","charttemplate name","username","user full name","user id","elementtype id","elementtype name","elementtype id","role id","role name","Periodic accumulation name","Value","Inheritance","Input type name","Value"]