Google Spread Sheet Automation & Analytics
Budget: ₹1,500 – ₹12,500 INR
We have retail sales executives who work at retail stores & sell products.These retail executives sell FMCG products like cooking oil,ice cream,cosmectics etc.Retail executive report to Supervisors who fill there opening stock & closing stock for each product in google form.This data is captured in google spreadsheet in backend.MIS team will copy this data & then put formulas in there sheet like day sales(which is opening minus closing stock),till date sales(sum of everyday sales),target achievement etc.
Requirement
We want someone to create format wherein all these google sheet of different supervisors are automatically entered in master sheet as these supervisor sheets are linked.Master sheet should have dashboard which change as data is captured in supervisor sheet
We have multiple running projects & data captured in google form by supervisor.All these data should be automated & we should have dashboard with us
For your reference sharing below mentioned documents
1) Arvind form captured in google sheet-Arvind has google form in which he enters date,store name,promoter name,attendance,promoters opening & closing stock for each variant i.e PSC,PI,Total Balance,Khichdi Punjabi,khichdi Bengali,khichdi pao bhaji,khichdi mexician,khichdi gujarati
Same ways other supervisors will also enter this data of there team members
All these supervisor wise data is captured in google sheet which is shown in attached files”Arvind form response” & data captured in form
2) MIS team currently download these files of all supervisor mergers same in excel & put formulas to derive the results.Attached file “final report” show how data for all supervisors is captured in excel i.e opening stock & closing stock of all variants
3) Attached sheet”final report more column” shows formulas are applied to achieve results likewise for each variant sales will be opening minus closing & sales is also calculated in litres.Till date sales store is sales of particular store for month till that date.promoter till date sales is sales achieved till date by promoter
4) Attached sheet”dashboard” shows dashboard of stores
Check we need to have –
1)If for one store closing store doesn’t match next day opening stock there can be two reasons one supervisor has entered wrong opening closing or fresh stock has been received so we need to get alert for that
2) All stores have benchmark sales for day so dashboard should show low performing stores & stores which have outperformed should also show
3) It should store comparison of corresponding months as in if raj mandir burari was doing 150 litre sales till 5th July & 5th august its just 80 litres so dashboard sheet have month wise comparison of stores
Requirement
We want someone to create format wherein all these google sheet of different supervisors are automatically entered in master sheet as these supervisor sheets are linked.Master sheet should have dashboard which change as data is captured in supervisor sheet
We have multiple running projects & data captured in google form by supervisor.All these data should be automated & we should have dashboard with us
For your reference sharing below mentioned documents
1) Arvind form captured in google sheet-Arvind has google form in which he enters date,store name,promoter name,attendance,promoters opening & closing stock for each variant i.e PSC,PI,Total Balance,Khichdi Punjabi,khichdi Bengali,khichdi pao bhaji,khichdi mexician,khichdi gujarati
Same ways other supervisors will also enter this data of there team members
All these supervisor wise data is captured in google sheet which is shown in attached files”Arvind form response” & data captured in form
2) MIS team currently download these files of all supervisor mergers same in excel & put formulas to derive the results.Attached file “final report” show how data for all supervisors is captured in excel i.e opening stock & closing stock of all variants
3) Attached sheet”final report more column” shows formulas are applied to achieve results likewise for each variant sales will be opening minus closing & sales is also calculated in litres.Till date sales store is sales of particular store for month till that date.promoter till date sales is sales achieved till date by promoter
4) Attached sheet”dashboard” shows dashboard of stores
Check we need to have –
1)If for one store closing store doesn’t match next day opening stock there can be two reasons one supervisor has entered wrong opening closing or fresh stock has been received so we need to get alert for that
2) All stores have benchmark sales for day so dashboard should show low performing stores & stores which have outperformed should also show
3) It should store comparison of corresponding months as in if raj mandir burari was doing 150 litre sales till 5th July & 5th august its just 80 litres so dashboard sheet have month wise comparison of stores