Create a "People on board" table
Hi Everyone,
First let me put everyone who is reading this into context, currently in the company I am working for, there is an Excel document in order to know how many people is currently working in an specific location, however, this is a lot of information that is hard to arrange and process manually in an Excel document, this information contains some basic information of the people working in different locations, including, full names, gender, job role, company the worker belongs to etc... This information is provided DAILY by several of our contractors that are currently working in these specific (and by the way) REMOTE locations, so yes it is a lot of data, one contractor can have up to 300 people working in one of our locations, so creating an attendance list to check if the person is working in the location or not is "NOT AN OPTION" so here is where I need your help builders, what would you do in this case, this is what I figured out.
Create an standard Excel Template for every single one of the contractors, after building a table with the necessary fields, so they upload this Excel daily (instead of sending it via email and avoid receiving hundreds of emails from our different contractors), and that way we can know how many people from which company is currently working in an specific location, how many are women and men etc... this is the easiest solution I found I don't know if you guys have done something similar before.
Let me know if you need any further details or have any other idea or how could I start developing this.
Many thanks,
Regards.
Israel
------------------------------
Israel Albornoz
------------------------------
First let me put everyone who is reading this into context, currently in the company I am working for, there is an Excel document in order to know how many people is currently working in an specific location, however, this is a lot of information that is hard to arrange and process manually in an Excel document, this information contains some basic information of the people working in different locations, including, full names, gender, job role, company the worker belongs to etc... This information is provided DAILY by several of our contractors that are currently working in these specific (and by the way) REMOTE locations, so yes it is a lot of data, one contractor can have up to 300 people working in one of our locations, so creating an attendance list to check if the person is working in the location or not is "NOT AN OPTION" so here is where I need your help builders, what would you do in this case, this is what I figured out.
Create an standard Excel Template for every single one of the contractors, after building a table with the necessary fields, so they upload this Excel daily (instead of sending it via email and avoid receiving hundreds of emails from our different contractors), and that way we can know how many people from which company is currently working in an specific location, how many are women and men etc... this is the easiest solution I found I don't know if you guys have done something similar before.
Let me know if you need any further details or have any other idea or how could I start developing this.
Many thanks,
Regards.
Israel
------------------------------
Israel Albornoz
------------------------------
