Closed

Inventory- goolge sheets

Description:

Currently, we have multiple restaurants that require us to track and monitor their inventory daily. These include items such as glasses (various types) and silverware (knifes, spoons, forks and ramekins). The goal of this project is to streamline this process into a Google Sheets document. I am looking to automate as much of this process as possible, so that employees can input their numbers at the beginning and end of their shifts. Currently the process is manual, and employees have the means to skip certain fields (cells) by leaving cells blank. Ideally, I would like the form to request an input for each required cell.

I am working with my colleagues to create a conditional access form that can be distributed to my team. Users from each restaurant will only have access to their own sheet.

I will be providing information about the headers required for the form. I will also provide additional details as requested.

An example of the current document has been attached to this request.

Current Process:

Employees: iPads are used to access a Google Form that writes back to a Google Sheets document. The employee clicks an icon (possibly a shortcut) on the iPad and are taken to a Google Forms page where inputs are requested per item. Knifes, forks, etc are some of the items the employees are required to count and document in the form. This form is then written back to a Google Sheets document. The Google Sheets document is then shared with managers.

Managers: During a shift, the managers are required to check the data inputted into the Google Sheets document. This information is required as part of the inventory process set forth by the leadership team. Managers are also responsible to tally the total number of missing items (broken, lost, etc). This information is used to track the inventory per restaurant and place an order to restock accordingly.

Action items:

1. Redevelop the form (Google Sheets format) to facilitate the ask

2. I am open to suggestions and recommendations to improve the process and worksheet

Expectations:

1. I would like this project to be completed in 2-3 weeks

2. I would like to be included in the decisions that are being taken while developing the sheet

3. Column and row titles will be provided by myself

4. A call (preferred), or email thread, set up to gather all the requirements prior to development

Expected outcome:

1. Build logic (sums, aggregates, averages, etc) into the worksheet to allow managers to evaluate the current inventory of items and provide feedback on historical data. Managers should be able to reference data collected daily, weekly, and monthly. The data can be recorded to a new sheet which only managers will have access to.

2. A Google Form that will be written back to a Google Sheets document

Skills: Excel, PHP, Visual Basic, Javascript, Software Architecture

See more: order total modules, total number friends opensocial, pdf2swf total number pages, google sheets home inventory template, google sheets templates, free inventory spreadsheet template google sheets, google inventory management system, google forms templates inventory, google sheets inventory script, how to take inventory in google sheets, google sheets asset management, order total module oscommerce, php mysql order confirmation number, oscommerce order total vendor, sample inventory excel sheets, pseudo code total number words, zen cart order total module, zen cart order total discounts, social media market research total number users online, magento minimum order total paypal

About the Employer:
( 37 reviews ) faridabad, India

Project ID: #21140741

18 freelancers are bidding on average $57 for this job

BaNgan

Hi, Please take a look at my recent gsuite project here: [login to view URL] Regarding to this project: - You are in need of a form that can More

$55 AUD in 7 days
(327 Reviews)
7.4
corporatessc

Hi, I have gone through the project and understood your requirements. You want your employees to fill a google form at the start and end of their shifts. The form will take input of all the current inventory like silve More

$100 AUD in 10 days
(15 Reviews)
4.2
Saimi786

Hello Thanks for your posting. I am a senior developer so i can do it very easily if you want.I’ve read your job description carefully and I am very interested in your project. I am sure that I can finish this project More

$98 AUD in 2 days
(11 Reviews)
3.6
care4rakib

I studied your work.I am good at ecvel vba. I am much interested working on this project and willing to start it immediately. Your project will be delivered in time with high quality. I can ensure you for speed and a More

$10 AUD in 7 days
(7 Reviews)
3.5
sharmapritam311

Hi there. i have built inventory application in excel using VBA. Pls msg me to see my works and how it can be adapted to suit your needs.

$40 AUD in 2 days
(6 Reviews)
2.7
udays419

....................................................................................................................

$55 AUD in 7 days
(0 Reviews)
0.0
jaylinganiola

I can do the work and deliver exceptional and timely manner. As I am currently employed into a corporate company. Being an Administrative Assistant, I am in-charged in handling and monitoring transactions, reorganizing More

$80 AUD in 18 days
(0 Reviews)
0.0
dominguezplc

Hello, I have experience in taking inventories and fill in spreadsheets with data related to products, equipment or else any other elements to be counted, can turn in work on time, any details and issues on the project More

$55 AUD in 7 days
(0 Reviews)
0.0
$61 AUD in 10 days
(0 Reviews)
0.0
DanJecu

Hello. I have a good working experience in Data Entry jobs, (excel, word, web sites, etc.), so I hope, I can help you. Feel free to contact me, so you can tell me exactly what you need and hopefully we can start workin More

$70 AUD in 7 days
(0 Reviews)
0.0
mooreb078

Highly skilled in creating google documents that are easily accessible.

$45 AUD in 10 days
(0 Reviews)
0.0
nayankumar181

i am professional in Excel, word & power point

$45 AUD in 1 day
(0 Reviews)
0.0
Jaitally2535

I have lot of experience in this field please accept my proposal i know tally definition language i have done lot of industrial modules.

$55 AUD in 1 day
(0 Reviews)
0.0
SoloRamos83

As an Audit Inventory employees and excel expert and , I will provide you a fast and accurate output. When hired, submit the data to me and we can start. Suggestion and formulas will be discussed to you. And will be More

$55 AUD in 5 days
(0 Reviews)
0.0
rktewari

I will BE your Virtual Assistant and provide you any type of Data Entry, Data Mining, Web Research or Copy Paste services! If you are looking for an excellent virtual assistant on very reasonable price, then please hir More

$45 AUD in 2 days
(0 Reviews)
0.0
Johnnymangogtong

My main goal is to get a stable job online by providing quality and quantity with accuracy work related services towards my clients. Thanks for your time. You are much welcome to message me anytime.

$55 AUD in 10 days
(0 Reviews)
0.0
rosedeepsea

Have more than eight years experience . have MS certified and would give the 100% work. Always ready to go beyond to complete the work to meet the requirement and do more than expectation.

$55 AUD in 7 days
(0 Reviews)
0.0
iangoodnight

I create google sheet inventory management systems full-time at the company I currently work for. I also have done several freelance jobs centered around creating dashboards and google sheets for the purposes of track More

$55 AUD in 1 day
(0 Reviews)
0.0