Sasha-

This can be achieved with a SharePoint Issue Tracker List, in which you
would capture Task, Month, Team Member etc. as metadata each time you
update a new task.  We’ve used Issue Tracking List in SharePoint 2007 &
2010 to track Records Requests (much like IT Ticket Tracking software) and
run periodically reports out of the list by exporting it to an excel
spreadsheet and running pivot table/pivot chart off the data.  I’ve found
using SharePoint to track performance metrics not only creates a more
transparent environment for service requests/tasks assigned to our
department, it also reduces reporting time and at the same time allows our
employees to submit requests online.  We also publish our reports in
SharePoint to a small number of target audiences including our management,
instead of emailing them as attachments.  I will be happy to discuss it
offline.
Peyyi Lu
Records Technology Advisor
Records and Information
Plains Exploration & Production Company
713-579-6821

[log in to unmask]



On Tue, Mar 6, 2012 at 6:40 PM, sasha babin <[log in to unmask]> wrote:

> Hello to Fellows,
>
>
> Does somebody know how to create in Sharepoint something that was "easy"
> in Excel:
>
> Before we used to do our Monthly Stats in Excel - Rows for task, columns
> for months, sheet for team member.
>
> Now management wants to do the same in  Sharepoint, or to use Sharepoint
> instead Excel.
>
> Could somebody shares with experience of using Sharepoint instead Excel
> spreadsheets, or it is simply misunderstanding what Sharepoint has been
> created for?
>
> Regards,
>
> Alex Babin
> [log in to unmask]
>
> List archives at http://lists.ufl.edu/archives/recmgmt-l.html
> Contact [log in to unmask] for assistance
> To unsubscribe from this list, click the below link. If not already
> present, place UNSUBSCRIBE RECMGMT-L or UNSUB RECMGMT-L in the body of the
> message.
> mailto:[log in to unmask]
>

List archives at http://lists.ufl.edu/archives/recmgmt-l.html
Contact [log in to unmask] for assistance
To unsubscribe from this list, click the below link. If not already present, place UNSUBSCRIBE RECMGMT-L or UNSUB RECMGMT-L in the body of the message.
mailto:[log in to unmask]