Solved

Clould Solution for Members to Access Timesheet

Posted on 2015-02-03
4
149 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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Suggested Solutions

Adoption of Microsoft’s Enterprise Mobility and Security solution and Office 365 will re-order the File Sync and Share market Microsoft has stated that its Enterprise Mobility + Security (EMS) is the fastest growing product in the history of the …
In-place Upgrading Dirsync to Azure AD Connect
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

739 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