{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Start","KNOWLEDGE MANAGEMENT REPORT","USER ACTIVITY"],"not_rendered":{"charts":2,"images":1},"unopened":[{"sheet":"USER ACTIVITY","index":2,"reason":"not_a_worksheet"}],"read":"whole","date_system":"1900"}

{"sheet":"Start","index":0,"n_rows":8,"n_cols":2,"rows_kept":8}
[null,"ABOUT THIS TEMPLATE"]
[null,"Track Knowledge Management Statistics using this workbook."]
[null,"Fill in Date and Company Name in Knowledge Management Report.  "]
[null,"Enter details in tables."]
[null,"The User Activity chart is auto updated in the other worksheet."]
[null,"Note: "]
[null,"Additional instructions have been provided in column A in KNOWLEDGE MANAGEMENT REPORT worksheet. This text has been intentionally hidden. To remove text, select column A or cell A1, then select DELETE. "]
[null,"To learn more about tables, press SHIFT and then F10 within a table, select the TABLE option, and then select ALTERNATIVE TEXT."]

{"sheet":"KNOWLEDGE MANAGEMENT REPORT","index":1,"n_rows":27,"n_cols":5,"rows_kept":27}
["Create a Knowledge Management Report in this worksheet. Helpful instructions on how to use this worksheet are in cells in this column. Title of the worksheet is in cell at right. Enter Date in cell E1.","Knowledge Management Report",null,null,"Date"]
["Tip is in cell at right.","Blue cells are calculated for you. You do not need to enter anything in them."]
["Enter Company Name in cell at right.","Company Name"]
["Knowledge Management Statistics label is in cell at right.","Knowledge Management Statistics"]
["Enter details in Content table starting in cell at right. Next instruction is in cell A10.","Knowledge content","Knowledge area 1","Knowledge area 2","Knowledge area 3"]
[null,"Number of pieces of content",95,90,90]
[null,"Estimated total number of pieces of content required",100,150,100]
[null,"Percentage completed",{"$f":"C6/C7","v":{"v":0.95,"d":"95.00%"}},{"$f":"D6/D7","v":{"v":0.6,"d":"60.00%"}},{"$f":"E6/E7","v":{"v":0.9,"d":"90.00%"}}]
[]
["Enter details in Infrastructure Annual Costs table starting in cell at right. Next instruction is in cell A17.","Knowledge infrastructure — annual costs","Knowledge area 1","Knowledge area 2","Knowledge area 3"]
[null,"Presentation and search capability",{"v":50000,"d":"£50,000.00"},{"v":50000,"d":"£50,000.00"},{"v":50000,"d":"£50,000.00"}]
[null,"Document management capability",{"v":40000,"d":"£40,000.00"},{"v":40000,"d":"£40,000.00"},{"v":40000,"d":"£40,000.00"}]
[null,"File storage and network access",{"v":35000,"d":"£35,000.00"},{"v":35000,"d":"£35,000.00"},{"v":35000,"d":"£35,000.00"}]
[null,"Other",{"v":0,"d":"£0.00"},{"v":0,"d":"£0.00"},{"v":0,"d":"£0.00"}]
[null,"Total infrastructure costs",{"$f":"SUBTOTAL(109,'KNOWLEDGE MANAGEMENT REPORT'!$C$11:$C$14)","v":{"v":125000,"d":"£125,000.00"}},{"$f":"SUBTOTAL(109,'KNOWLEDGE MANAGEMENT REPORT'!$D$11:$D$14)","v":{"v":125000,"d":"£125,000.00"}},{"$f":"SUBTOTAL(109,'KNOWLEDGE MANAGEMENT REPORT'!$E$11:$E$14)","v":{"v":125000,"d":"£125,000.00"}}]
[]
["Enter details in End User Statistics table starting in cell at right. Next instruction is in cell A24.","End-user statistics","Knowledge area 1","Knowledge area 2","Knowledge area 3"]
[null,"Number of active users with access",450,500,500]
[null,"Number of users logging in within last 7 days",49,233,93]
[null,"Percentage",{"$f":"C19/C18","v":{"v":0.10888888888888888,"d":"10.89%"}},{"$f":"D19/D18","v":{"v":0.466,"d":"46.60%"}},{"$f":"E19/E18","v":{"v":0.186,"d":"18.60%"}}]
[null,"Number of users logging in within last 30 days",89,387,237]
[null,"Percentage",{"$f":"C21/C18","v":{"v":0.19777777777777777,"d":"19.78%"}},{"$f":"D21/D18","v":{"v":0.774,"d":"77.40%"}},{"$f":"E21/E18","v":{"v":0.474,"d":"47.40%"}}]
[]
["Enter details in Content Submission table starting in cell at right.","Content submission","Knowledge area 1","Knowledge area 2","Knowledge area 3"]
[null,"Number of pieces of content submitted by users",134,78,215]
[null,"Number of pieces of content accepted",93,68,186]
[null,"Acceptance rate",{"$f":"C26/C25","v":{"v":0.6940298507462687,"d":"69.40%"}},{"$f":"D26/D25","v":{"v":0.8717948717948718,"d":"87.18%"}},{"$f":"E26/E25","v":{"v":0.8651162790697674,"d":"86.51%"}}]