Solved

Clould Solution for Members to Access Timesheet

Posted on 2015-02-03
4
140 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
  • 2
  • 2
4 Comments
 
LVL 79

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 79

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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Steve Terp was featured in a video created by CRN about how "Channel Is Crucial To Market Disruption". Click on View source to see the video and article
For cloud, the “train has left the station” and in the Microsoft ERP & CRM world, that means the next generation of enterprise software from Microsoft is here: Dynamics 365 is Microsoft’s new integrated business solution that unifies CRM and ERP fun…
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
how to add IIS SMTP to handle application/Scanner relays into office 365.

863 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now