{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Redmine Data","User Data","Order Data"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":2},"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":"Redmine Data","index":0,"n_rows":127,"n_cols":8,"rows_kept":127,"cut":false,"hidden":false,"merged":[]}
["User","Order","Order Activity","Date","Hours"]
["Sam Q","1100-00 ICT Systems Support","Consultancy","2014-36",2.75]
["Sam Q","1100-00 ICT Systems Support","Consultancy","2014-37",0.5]
["Sam Q","1100-00 ICT Systems Support","Consultancy","2014-38",2.1]
["Sam Q","1100-00 ICT Systems Support","Troubleshooting","2014-36",4,null,null,"Instructions"]
["Sam Q","1100-00 ICT Systems Support","Troubleshooting","2014-37",1,null,null,"1. Run the Spent time Report in Redmine - Select User, Order & Order Activity"]
["Sam Q","1100-00 ICT Systems Support","Troubleshooting","2014-38",1.5,null,null,"2. Save the .csv file (right at the bottom of the report)"]
["Sam Q","1100-00 ICT Systems Support","Default","2014-36",3.95,null,null,"3. Open the Excel workbook and Hit the Refresh button and select the .csv file when prompted"]
["Sam Q","1100-00 ICT Systems Support","Default","2014-37",2.25,null,null,"4. Look at the Pivot Tables in the other tabs to see what you can do with the data"]
["Sam Q","1100-00 ICT Systems Support","Default","2014-38",3.5]
["Sam Q","1100-00 ICT Systems Support","Default","2014-39",0.3]
["Sam Q","1100-00 ICT Systems Support","Testing","2014-36",0.5]
["Sam Q","4599-00 SRS Support","Default","2014-36",0.2]
["Sam Q","4599-00 SRS Support","Default","2014-37",0.3]
["Sam Q","4599-00 SRS Support","Default","2014-38",0.4]
["Sam Q",".Administration","Default","2014-38",14.1]
["Sam Q","4200-00 Test IT","Default","2014-36",1]
["Sam Q","4200-00 Test IT","Default","2014-37",0.5]
["Sam Q","4200-00 Test IT","Default","2014-38",1.6]
["Sam Q","4200-00 Test IT","Consultancy","2014-36",3]
["Sam Q","1100-02 Systems Maintenance","BAU Activities","2014-36",6.7]
["Sam Q","1100-02 Systems Maintenance","BAU Activities","2014-37",7.5]
["Sam Q","1100-02 Systems Maintenance","BAU Activities","2014-38",4]
["Sam Q","1100-02 Systems Maintenance","Default","2014-36",8.1999999999999993]
["Sam Q","1100-02 Systems Maintenance","Default","2014-37",4.3]
["Sam Q","1100-02 Systems Maintenance","Default","2014-38",1]
["Sam Q","1100-02 Systems Maintenance","Default","2014-39",1.3]
["Sam Q","1100-02 Systems Maintenance","Consultancy","2014-36",1.1000000000000001]
["Sam Q","4900-02 Respite Seeker","Default","2014-37",0.5]
["Sam Q","4499-01 S2S V8","Default","2014-36",0.2]
["Sam Q","4499-01 S2S V8","Default","2014-38",0.5]
["Sam Q","4499-01 S2S V8","Consultancy","2014-36",0.75]
["Sam Q","4499-01 S2S V8","Implementation","2014-36",3]
["Sam Q","4199-01 Web Hosting","Default","2014-36",1.1000000000000001]
["Sam Q","4199-01 Web Hosting","Default","2014-38",1.9]
["Sam Q",".Management","Default","2014-36",1]
["Sam Q",".Management","Default","2014-37",0.5]
["Sam Q",".Management","Default","2014-38",1.5]
["Sam Q",".Business Development - Digital Incl","Default","2014-37",1.5]
["Sam Q",".Business Development - Digital Incl","Default","2014-38",0.2]
["Sam Q","4401-00 HSNet","Testing","2014-36",3]
["Sam Q","4401-00 HSNet","Default","2014-36",0.5]
["Sam Q","4401-00 HSNet","Default","2014-37",4.5999999999999996]
["Sam Q","4300-01 ISS Clean Skin","Default","2014-38",2.5]
["Sam Q","4499-00 S2S Support","Default","2014-36",0.45]
["Sam Q","4499-00 S2S Support","Default","2014-37",7.8]
["Sam Q","4499-00 S2S Support","Default","2014-38",0.9]
["Sam Q","4300-00 ISS Support","Default","2014-36",0.35]
["Sam Q","4300-00 ISS Support","Default","2014-39",1]
["Sam Q","4300-00 ISS Support","Planning","2014-38",1]
["Sam Q","3200-00 Connected Communities","Default","2014-38",1.6]
["Sam Q",".Non-working","Leave","2014-37",7.6]
["George P","1100-00 ICT Systems Support","Default","2014-36",7.1]
["George P","1100-00 ICT Systems Support","Default","2014-37",3.1]
["George P","1100-00 ICT Systems Support","Default","2014-38",6]
["George P","1100-00 ICT Systems Support","BAU Activities","2014-38",0.5]
["George P",".Administration","Default","2014-36",9.5]
["George P",".Administration","Default","2014-37",4.8]
["George P",".Administration","Default","2014-38",3.9]
["George P","4199-00 Web Support","Consultancy","2014-37",0.5]
["George P","4199-00 Web Support","Consultancy","2014-38",0.7]
["George P","4900-00 Other Applications Support","Default","2014-36",1]
["George P","4900-00 Other Applications Support","Default","2014-37",18.100000000000001]
["George P","4900-00 Other Applications Support","Default","2014-38",8.5]
["George P","4900-00 Other Applications Support","Post Implementation Support","2014-38",3]
["George P","1100-02 Systems Maintenance","Default","2014-36",15.6]
["George P","1100-02 Systems Maintenance","Default","2014-37",9.8000000000000007]
["George P","1100-02 Systems Maintenance","Default","2014-38",11.6]
["George P","4499-01 S2S V8","Default","2014-36",10.5]
["George P","4499-01 S2S V8","Default","2014-37",1.5]
["George P","4401-00 HSNet","Default","2014-36",0.5]
["George P","4401-00 HSNet","Default","2014-37",0.3]
["George P","4199-01 Web Hosting","Implementation","2014-38",0.5]
["George P","4199-01 Web Hosting","Default","2014-37",0.5]
["George P","3200-00 Connected Communities","Default","2014-38",1.3]
["George P","4300-02 ISS Update","Default","2014-38",1]
["George P","4700-00 CRM","Default","2014-36",0.6]
["George P","4700-00 CRM","Default","2014-37",0.4]
["George P","4599-00 SRS Support","Default","2014-38",1]
["Greg J","1200-05 Phones","Default","2014-36",3.25]
["Greg J","1200-05 Phones","Default","2014-37",0.75]
["Greg J","1200-05 Phones","Default","2014-38",0.75]
["Greg J","1200-05 Phones","BAU Activities","2014-36",1.5]
["Greg J","1200-05 Phones","BAU Activities","2014-37",1.5]
["Greg J","1200-05 Phones","BAU Activities","2014-38",0.5]
["Greg J","1200-02 Facilities","BAU Activities","2014-36",8.5]
["Greg J","1200-02 Facilities","BAU Activities","2014-37",7]
["Greg J","1200-02 Facilities","BAU Activities","2014-38",4]
["Greg J","1200-02 Facilities","Default","2014-36",10]
["Greg J","1200-02 Facilities","Default","2014-37",8.6999999999999993]
["Greg J","1200-02 Facilities","Default","2014-38",3.75]
["Greg J","1200-06 Reception","BAU Activities","2014-36",10]
["Greg J","1200-06 Reception","BAU Activities","2014-37",12]
["Greg J","1200-06 Reception","BAU Activities","2014-38",4]
["Greg J","1200-03 Fleet","Default","2014-37",0.4]
["Greg J","1200-03 Fleet","Default","2014-38",1.5]
["Greg J","1200-04 Office Supplies","Default","2014-36",2.7]
["Greg J","1200-04 Office Supplies","Default","2014-37",2.75]
["Greg J","1200-04 Office Supplies","BAU Activities","2014-37",2]
["Greg J",".Non-working","Leave","2014-36",1]
["Greg J",".Non-working","Leave","2014-38",22.8]
["Greg J",".Administration","Default","2014-37",1.7]
["Greg J","1200-01 Admin Support","BAU Activities","2014-36",1]
["Greg J","1200-01 Admin Support","BAU Activities","2014-37",2.2999999999999998]
["Greg J","1200-01 Admin Support","BAU Activities","2014-38",0.7]
["Kat L",".Non-working","Regular Absence","2014-36",14]
["Kat L",".Non-working","Regular Absence","2014-37",14.3]
["Kat L",".Non-working","Regular Absence","2014-38",15.2]
["Kat L",".Non-working","Regular Absence","2014-39",15.2]
["Kat L",".Non-working","Leave","2014-37",11.1]
["Kat L",".Non-working","Leave","2014-39",4.0999999999999996]
["Kat L","4499-01 S2S V8","Planning","2014-36",15.1]
["Kat L","4499-01 S2S V8","Planning","2014-37",11.5]
["Kat L","4499-01 S2S V8","Planning","2014-38",9.5]
["Kat L","4499-01 S2S V8","Planning","2014-39",2.75]
["Kat L","4499-01 S2S V8","Testing","2014-36",1.2]
["Kat L","4499-01 S2S V8","Testing","2014-38",4.75]
["Kat L","4499-01 S2S V8","Testing","2014-39",0.25]
["Kat L","4499-02 S2S Support Plan","Planning","2014-36",1]
["Kat L","4499-02 S2S Support Plan","Planning","2014-37",0.5]
["Kat L","4499-02 S2S Support Plan","Planning","2014-38",8.75]
["Kat L","4499-02 S2S Support Plan","Planning","2014-39",0.25]
["Kat L",".Administration","Default","2014-37",0.6]
["Kat L",".Administration","Default","2014-38",0.5]
["Kat L",".Administration","Default","2014-39",0.25]
["Kat L","4499-00 S2S Support","Consultancy","2014-38",0.1]
["Kat L","4499-00 S2S Support","Training","2014-36",11.75]

{"sheet":"User Data","index":1,"n_rows":50,"n_cols":6,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Sum of Hours","Date"]
["Row Labels","2014-36","2014-37","2014-38","2014-39","Grand Total"]
["George P",44.800000000000004,39,38,null,121.80000000000001]
[".Administration",9.5,4.8,3.9,null,18.2]
["1100-00 ICT Systems Support",7.1,3.1,6.5,null,16.7]
["1100-02 Systems Maintenance",15.6,9.8000000000000007,11.6,null,37]
["3200-00 Connected Communities",null,null,1.3,null,1.3]
["4199-00 Web Support",null,0.5,0.7,null,1.2]
["4199-01 Web Hosting",null,0.5,0.5,null,1]
["4300-02 ISS Update",null,null,1,null,1]
["4401-00 HSNet",0.5,0.3,null,null,0.8]
["4499-01 S2S V8",10.5,1.5,null,null,12]
["4599-00 SRS Support",null,null,1,null,1]
["4700-00 CRM",0.6,0.4,null,null,1]
["4900-00 Other Applications Support",1,18.100000000000001,11.5,null,30.6]
["Greg J",37.950000000000003,39.099999999999994,38,null,115.05000000000001]
[".Administration",null,1.7,null,null,1.7]
[".Non-working",1,null,22.8,null,23.8]
["1200-01 Admin Support",1,2.2999999999999998,0.7,null,4]
["1200-02 Facilities",18.5,15.7,7.75,null,41.95]
["1200-03 Fleet",null,0.4,1.5,null,1.9]
["1200-04 Office Supplies",2.7,4.75,null,null,7.45]
["1200-05 Phones",4.75,2.25,1.25,null,8.25]
["1200-06 Reception",10,12,4,null,26]
["Kat L",43.05,38,38.799999999999997,22.799999999999997,142.64999999999998]
[".Administration",null,0.6,0.5,0.25,1.35]
[".Non-working",14,25.4,15.2,19.299999999999997,73.899999999999991]
["4499-00 S2S Support",11.75,null,0.1,null,11.85]
["4499-01 S2S V8",16.3,11.5,14.25,3,45.05]
["4499-02 S2S Support Plan",1,0.5,8.75,0.25,10.5]
["Sam Q",41.750000000000007,38.849999999999994,38.299999999999997,2.6,121.49999999999999]
[".Administration",null,null,14.1,null,14.1]
[".Business Development - Digital Incl",null,1.5,0.2,null,1.7]
[".Management",1,0.5,1.5,null,3]
[".Non-working",null,7.6,null,null,7.6]
["1100-00 ICT Systems Support",11.2,3.75,7.1,0.3,22.349999999999998]
["1100-02 Systems Maintenance",15.999999999999998,11.8,5,1.3,34.099999999999994]
["3200-00 Connected Communities",null,null,1.6,null,1.6]
["4199-01 Web Hosting",1.1000000000000001,null,1.9,null,3]
["4200-00 Test IT",4,0.5,1.6,null,6.1]
["4300-00 ISS Support",0.35,null,1,1,2.35]
["4300-01 ISS Clean Skin",null,null,2.5,null,2.5]
["4401-00 HSNet",3.5,4.5999999999999996,null,null,8.1]
["4499-00 S2S Support",0.45,7.8,0.9,null,9.15]
["4499-01 S2S V8",3.95,null,0.5,null,4.45]
["4599-00 SRS Support",0.2,0.3,0.4,null,0.9]
["4900-02 Respite Seeker",null,0.5,null,null,0.5]
["Grand Total",167.54999999999995,154.95000000000002,153.1,25.4,501.00000000000006]

{"sheet":"Order Data","index":2,"n_rows":80,"n_cols":6,"rows_kept":80,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Sum of Hours","Weeks"]
["Row Labels","2014-36","2014-37","2014-38","2014-39","Grand Total"]
[".Administration",9.5,7.1,18.5,0.25,35.35]
["Default",9.5,7.1,18.5,0.25,35.35]
[".Business Development - Digital Incl",null,1.5,0.2,null,1.7]
["Default",null,1.5,0.2,null,1.7]
[".Management",1,0.5,1.5,null,3]
["Default",1,0.5,1.5,null,3]
[".Non-working",15,33,38,19.299999999999997,105.30000000000001]
["Leave",1,18.7,22.8,4.0999999999999996,46.6]
["Regular Absence",14,14.3,15.2,15.2,58.7]
["1100-00 ICT Systems Support",18.3,6.85,13.6,0.3,39.049999999999997]
["BAU Activities",null,null,0.5,null,0.5]
["Consultancy",2.75,0.5,2.1,null,5.35]
["Default",11.05,5.35,9.5,0.3,26.2]
["Testing",0.5,null,null,null,0.5]
["Troubleshooting",4,1,1.5,null,6.5]
["1100-02 Systems Maintenance",31.599999999999998,21.6,16.600000000000001,1.3,71.099999999999994]
["BAU Activities",6.7,7.5,4,null,18.2]
["Consultancy",1.1000000000000001,null,null,null,1.1000000000000001]
["Default",23.799999999999997,14.100000000000001,12.6,1.3,51.8]
["1200-01 Admin Support",1,2.2999999999999998,0.7,null,4]
["BAU Activities",1,2.2999999999999998,0.7,null,4]
["1200-02 Facilities",18.5,15.7,7.75,null,41.95]
["BAU Activities",8.5,7,4,null,19.5]
["Default",10,8.6999999999999993,3.75,null,22.45]
["1200-03 Fleet",null,0.4,1.5,null,1.9]
["Default",null,0.4,1.5,null,1.9]
["1200-04 Office Supplies",2.7,4.75,null,null,7.45]
["BAU Activities",null,2,null,null,2]
["Default",2.7,2.75,null,null,5.45]
["1200-05 Phones",4.75,2.25,1.25,null,8.25]
["BAU Activities",1.5,1.5,0.5,null,3.5]
["Default",3.25,0.75,0.75,null,4.75]
["1200-06 Reception",10,12,4,null,26]
["BAU Activities",10,12,4,null,26]
["3200-00 Connected Communities",null,null,2.9000000000000004,null,2.9000000000000004]
["Default",null,null,2.9000000000000004,null,2.9000000000000004]
["4199-00 Web Support",null,0.5,0.7,null,1.2]
["Consultancy",null,0.5,0.7,null,1.2]
["4199-01 Web Hosting",1.1000000000000001,0.5,2.4,null,4]
["Default",1.1000000000000001,0.5,1.9,null,3.5]
["Implementation",null,null,0.5,null,0.5]
["4200-00 Test IT",4,0.5,1.6,null,6.1]
["Consultancy",3,null,null,null,3]
["Default",1,0.5,1.6,null,3.1]
["4300-00 ISS Support",0.35,null,1,1,2.35]
["Default",0.35,null,null,1,1.35]
["Planning",null,null,1,null,1]
["4300-01 ISS Clean Skin",null,null,2.5,null,2.5]
["Default",null,null,2.5,null,2.5]
["4300-02 ISS Update",null,null,1,null,1]
["Default",null,null,1,null,1]
["4401-00 HSNet",4,4.8999999999999995,null,null,8.8999999999999986]
["Default",1,4.8999999999999995,null,null,5.8999999999999995]
["Testing",3,null,null,null,3]
["4499-00 S2S Support",12.2,7.8,1,null,21]
["Consultancy",null,null,0.1,null,0.1]
["Default",0.45,7.8,0.9,null,9.15]
["Training",11.75,null,null,null,11.75]
["4499-01 S2S V8",30.749999999999996,13,14.75,3,61.5]
["Consultancy",0.75,null,null,null,0.75]
["Default",10.7,1.5,0.5,null,12.7]
["Implementation",3,null,null,null,3]
["Planning",15.1,11.5,9.5,2.75,38.85]
["Testing",1.2,null,4.75,0.25,6.2]
["4499-02 S2S Support Plan",1,0.5,8.75,0.25,10.5]
["Planning",1,0.5,8.75,0.25,10.5]
["4599-00 SRS Support",0.2,0.3,1.4,null,1.9]
["Default",0.2,0.3,1.4,null,1.9]
["4700-00 CRM",0.6,0.4,null,null,1]
["Default",0.6,0.4,null,null,1]
["4900-00 Other Applications Support",1,18.100000000000001,11.5,null,30.6]
["Default",1,18.100000000000001,8.5,null,27.6]
["Post Implementation Support",null,null,3,null,3]
["4900-02 Respite Seeker",null,0.5,null,null,0.5]
["Default",null,0.5,null,null,0.5]
["Grand Total",167.54999999999995,154.95000000000002,153.10000000000002,25.4,500.99999999999994]