Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-21-2019, 10:32 AM
bmjsingleton86 bmjsingleton86 is offline Tallies - Real time counting? Windows 10 Tallies - Real time counting? Office 2013
Novice
Tallies - Real time counting?
 
Join Date: Dec 2018
Posts: 3
bmjsingleton86 is on a distinguished road
Default Tallies - Real time counting?

At work, I have an intake person to assign all incoming mail to our team. Currently she tracks using a piece of paper and tick marks.



To make it easily reviewed, we want to build a spreadsheet for this process.

The main things needed are

for the intake person to determine who she last assigned to

management to look at it and verify the load is evenly disbursed


My thought for how this would work is attached, but if there is another way (presumably a better way too) I would love to know it.

TIA!
Attached Images
File Type: jpg Tall examp.JPG (83.7 KB, 17 views)
Reply With Quote
  #2  
Old 08-22-2019, 12:44 AM
ArviLaanemets ArviLaanemets is offline Tallies - Real time counting? Windows 8 Tallies - Real time counting? Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

Having separate tables for specific period is really bad idea! This means you have continuously edit the workbook. Attached is an example where you have a single sheet where you register all mails, and a report sheet where you select a month, and wanted statistics are displayed.


Currently there is a table where you can see how many mails were assigned to every member of team at every date of month. Also is there a column, where total number of unsolved mails from previous months for every member is displayed.


You can add similar tables below current one, where some other statistics are calculated (e.g. the number of mails solved for every day of month for every member of group).


Managing such workbook is simple. Let's assume a year is a proper period for workbook, and you had a similar workbook for previous year (e.g. Mails2018.xlsx). You save the old workbook as Mails2019.xlsx, and remove all records from sheet Mails which were resolved. Unresolved mails are remaining (you can change the mail date for them to 31.12.2018, so do have only December of previous year in months list in new workbook). When there are some employees which did left before year 2019, you can remove them from sheet Team. and that's all! You can start registering mails arriving in year 2019!
Attached Files
File Type: xlsx EmailsTally.xlsx (19.7 KB, 14 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Display real time data in power point lilahm PowerPoint 0 01-22-2019 06:25 AM
How to save versions of Word doc to OneDrive in real time? shmu Word 3 06-14-2017 02:53 AM
Share/sync mail categories among pst files in real time Tassadar Outlook 0 04-11-2017 11:14 AM
Tallies - Real time counting? Real Time calculations wgutshall Excel 3 07-10-2015 08:44 AM
Display txt in real-time Prostrelov Word 13 06-21-2014 08:48 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:11 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft