Adapting and automating Google tables under us

Data Processing — incorrectly specified categories?

67 USD

Project translated automatically. Log in or register, to view the original Auto-tracking data from the 2023 Cash table to the Statistics list.And the transfer of data to a particular apartment with statistics with dates (Na Neklance byt 5, byt-3...).Add the specific cost of the service so that the Technical list will draw the percentage of payment based on the data of the cash.Get statistics on all the sold orders, seeds, temporary guard.Where can we set ourselves for what period we are interested in statistics.Automatic commission in case of a 100% payment.(for the manager) Column "from", "to", "telephone number" Excerpt in the list Technical of all services: return, urgency, sedlo, p with mail, p without mail, timely security.Add to the statistics a call call and a note for the telephone operator.To people who end the period of 30-1 days, transfer to the call section (a separate "Call" sheet, 2 "Yes" sheets "No" (yes - extends, remains in this sheet / purchased - is removed; no - is removed from this sheet) Example Simon Yurii is the right name but then made a mistake Simoh Yuri.That it pulls if the similarity is 90-100%.Or another way of solving this problem.Set up so that our table takes information from the payment manager table.And when we pay for orders we showed we paid for the outcome or not.And when such orders should be included in the return list.After Customer's designation as a return transfer to the return table and removal from other tables.Automatically make the commission of Aluf + Sergey.To set the mark in the manager's cash with the mail A1 here is the Aluf commission( all in the percentage of the amount).2 of Sergey.In this way, a payment will be formed in our cash.It is desirable that all of these payments are collected in one list in a week.Automatic calculation of profits.and expenses (restaurant, advertising, etc.)Excerpting the order from the office.The name and telephone number are transferred.And the Count with the date of receipt to the office.After the release, the manager is removed from the list.The price is discussed!