2019_reference_at_the_metcalfe_seminar
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
2019_reference_at_the_metcalfe_seminar [2020/12/03 22:09] – ellen.forsyth_sl.nsw.gov.au | 2019_reference_at_the_metcalfe_seminar [2020/12/03 22:17] (current) – ellen.forsyth_sl.nsw.gov.au | ||
---|---|---|---|
Line 34: | Line 34: | ||
1.25 - 1.40 Michael Doran, Information and Customer Services Librarian, City of Parramatta Libraries Analysing customer enquiries as a pathway to service improvement | 1.25 - 1.40 Michael Doran, Information and Customer Services Librarian, City of Parramatta Libraries Analysing customer enquiries as a pathway to service improvement | ||
- | {{slideshare& | + | [[https:// |
- | {{ :wiki:blank_copy_of_customer_questions.xlsx |Blank copy of form described in presentation}} Excel with macros can not be loaded in this wiki. Contact Michel directly for a copy of the spreadsheet with macros. | + | {{ :wiki:copy_of_customer_questions_-_blank.xlsx |Blank copy of form described in presentation}} |
+ | |||
+ | Excel with macros can not be loaded in this wiki. Contact Michel directly for a copy of the spreadsheet with macros. | ||
+ | |||
+ | Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) | ||
+ | With Target | ||
+ | If Target.Count > 1 Then Exit Sub | ||
+ | If .Cells.Count = 1 And .Column = 1 And .Value <> vbNullString Then | ||
+ | With .Offset(0, 1) | ||
+ | .Value = Val(.Text) + 1 | ||
+ | End With | ||
+ | End If | ||
+ | End With | ||
+ | End Sub | ||
- | {{ : | ||
The question clicking functionality of the macro has been, a key component in making the spreadsheet usable, and achieving a reasonable level of compliance from staff already engaged in serving customers. | The question clicking functionality of the macro has been, a key component in making the spreadsheet usable, and achieving a reasonable level of compliance from staff already engaged in serving customers. | ||
Line 50: | Line 62: | ||
1.45 – 2.05 Enquiry completion rate data. What the new forms are helping with and a request for state wide data – Ellen Forsyth | 1.45 – 2.05 Enquiry completion rate data. What the new forms are helping with and a request for state wide data – Ellen Forsyth | ||
- | {{slideshare& | + | [[https:// |
2.05 – 2.45 ALIA TIK – Rob Thompson will talk about the truth, integrity, knowledge (TIK) campaign being run by ALIA @robthomson2528 | 2.05 – 2.45 ALIA TIK – Rob Thompson will talk about the truth, integrity, knowledge (TIK) campaign being run by ALIA @robthomson2528 | ||
- | {{slideshare& | + | [[https:// |
2.50 - 3.00 stand and stretch and discuss with those around you one idea from the talks today you will take back to your workplace | 2.50 - 3.00 stand and stretch and discuss with those around you one idea from the talks today you will take back to your workplace |
2019_reference_at_the_metcalfe_seminar.1607054962.txt.gz · Last modified: 2020/12/03 22:09 by ellen.forsyth_sl.nsw.gov.au