Solved

Clould Solution for Members to Access Timesheet

Posted on 2015-02-03
4
151 Views
Last Modified: 2015-02-04
Dear Team,

I have a scenario . I have a team under me around 15 members who works outside office (most of the time) . I would like to monitor the day to day activities , as they have internet access. I need a solution to have timesheet to be filled by employees.
I am suggesting an excel sheet to be uploaded in the cloud, so that members can access and edit the page . Lets say an example, i have excel sheet with 13 tabs meant for 13 members . Only the particular member can access the tab ( or worksheet ) to do his work and admin can access all the table.
Well the vision i have is highlevel and i dont know how can i acheive it sucessfully. I would like your valuable experience , how can i have this timesheet solution deployed in cloud like Azure, Google etc and be benefited for the organisation . Highliy appreciate your kind help and support.

Regards,

SID
0
Comment
Question by:infiniti7181
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 81

Accepted Solution

by:
David Johnson, CD, MVP earned 500 total points
ID: 40588562
This is where you should use a database and not excel that or have an excel file for each of the 13 workers and then link them into your master

http://www.keynotesupport.com/excel-basics/excel-linking-worksheets.shtml
Master.xlsx
Timesheet-1.xlsx
Timesheet-2.xlsx
Timesheet-3.xlsx
0
 

Author Comment

by:infiniti7181
ID: 40588785
Hi David,

Thanks for the info and examples provided. Related with Database, do you mean use Access and a report can be generated .

Regards,
SID .
0
 
LVL 81

Expert Comment

by:David Johnson, CD, MVP
ID: 40588817
precisely now a web app that the workers can use via their browser would be ideal.
0
 

Author Comment

by:infiniti7181
ID: 40588897
Thanks any examples so i can refer .
web app can be tagged with mobile app ( iphone or android) and reports can be stored in cloud . Is it something like that ?
Regards,
SID
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Each year, investment in cloud platforms grows more than 20% (https://www.immun.io/hubfs/Immunio_2016/Content/Marketing/Cloud-Security-Report-2016.pdf?submissionGuid=a8d80a00-6fee-4b85-81db-a4e28f681762) as an increasing number of companies begin to…
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …
Both in life and business – not all partnerships are created equal. Spend 30 short minutes with us to learn:   • Key questions to ask when considering a partnership to accelerate your business into the cloud • Pitfalls and mistakes other partners…

724 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question