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
