Excel Guru needed to create a Tracking sheet
- or -
Post a project like this1247
€200(approx. $214)
- Posted:
- Proposals: 11
- Remote
- #3046167
- OPPORTUNITY
- Awarded
|BPR|Research|Marketing|Translations|Design|Technical Support|Assistance|more... much more...
Quilmes
Website Developer, Graphic Designer, Transcriber, Content writer, CAD Expert, Python Developer, Photo Editor, Web Scrapper, JAVA developer, Android developer, Wix/Shopify Expert,
Regensburg
Microsoft Azure Office 365 Sharepoint Google Workspace Online Marketing Consultant,
Brighton
208270956183149756224544412543778276831238734913896584501267250415915060615
Description
Experience Level: Entry
I need a simple Excel file to track the following:
Context:
A team of engineers will work in sprints of each 1 month long ( 12 sprint in total per year)
In that sprint a list of ticket will be selected and worked on by the team members.
This list of ticket is coming from an external software,
input:
Manually inserted:
Ressource ID
Ressource Name
Ressource Availability mandays during that sprint (can vary from sprint to sprint)
Manually inserted (extract from the ticketing software)
Ticket ID
Ticket Title
Ticket effort required in mandays
Output:
A Dashboard with:
the total availability of the all the teammembers in mandays;
The total amount of mandays needed to complete all the tickets
total cost of tickets (calculation of total mandays tickets multiplied by a variable number)
At the end of the sprint,
Input:
- How much tickets have been resolved
- What ticket will be re-scheduled to next sprint (with a specific color to have priority)
This doesn't need to be fancy, just useful;
I need this urgently (have to deliver end of coming week)
Also I need to easily be able to adapt stuff (like new column of attribute)
Context:
A team of engineers will work in sprints of each 1 month long ( 12 sprint in total per year)
In that sprint a list of ticket will be selected and worked on by the team members.
This list of ticket is coming from an external software,
input:
Manually inserted:
Ressource ID
Ressource Name
Ressource Availability mandays during that sprint (can vary from sprint to sprint)
Manually inserted (extract from the ticketing software)
Ticket ID
Ticket Title
Ticket effort required in mandays
Output:
A Dashboard with:
the total availability of the all the teammembers in mandays;
The total amount of mandays needed to complete all the tickets
total cost of tickets (calculation of total mandays tickets multiplied by a variable number)
At the end of the sprint,
Input:
- How much tickets have been resolved
- What ticket will be re-scheduled to next sprint (with a specific color to have priority)
This doesn't need to be fancy, just useful;
I need this urgently (have to deliver end of coming week)
Also I need to easily be able to adapt stuff (like new column of attribute)
El oudghiri M.
100% (23)Projects Completed
10
Freelancers worked with
9
Projects awarded
44%
Last project
21 Dec 2021
Belgium
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hello Sir,
I have a problem with my Visa and I am out of bids now so kindly consider this as proposal and invite me for the project. I have created similar sheet before for another company but I need to ask who will be responsible to assign this ticket as completed or not? Will the sheet locate on a shared folder or onedrive or it will be a google sheet?
953568
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies