已完成

Google Sheet for internal product transfer

**** I only review bids from freelancers who send me the name of the keyword, found somewhere in the description below. ****

We transfer product from one store location to another.

We need a google sheet that will allow a manager to request quantities of goods to be transferred, and following the data entry by the manager, a new sheet will be generated showing the items to be shipped. This shipping list should only show the items with a 1 or greater quantity ordered. Shipping list should be a new sheet inside a workbook.

A summary of items ordered for a monthly - period should be updated each time the employee creates a new order.

1) Output Data

After entering data

a) a new sheet should be generated including all items, where a quantity was defined. The output should summarize item, ordered quantity and price of ordered item under the respective category.

Items, which were not selected, should not appear in this report.

2) Further the total for Coffee – 5110, Tea – 5115, Hard Goods – 5120, Beverage Supplies – 5130 and Foods – 5140 should be calculated.

b) This spreadsheet should be saved with output date in a defined folder (“Order Forms”) OR as a dated sheet within that workbook.

c) if possible, an email should be send to defined persons including spreadsheet generated for (A)

3) d) Another sheet should be generated displaying a summary of this data entry by month (January, February) and yearly summary should be also displayed. The keyword you need is coffee. All data generated at a later time should be added for the respective month. It should be possible to revise these data.

e) the input data should be reset, that it is ready to be filled out for the next week

技能: Excel

查看更多: product transfer outsourced project, google checkout type product, transfer programs hard drive, google sheets formulas sum, how to move data to cloud storage, google cloud transfer appliance, google sheets functions, google transfers, google cloud storage transfer, gcp storage transfer service, google transfer appliance, transfer files hard drives, transfer files hard drive hard drive, transfer files hard drive linux, transfer files hard drive secondary drive, transfer files hard drive, transfer files hard disk disk, google checkout time payment transfer, product transfer, google base bulk product upload creator

关于此雇主:
( 9个评论 ) Thuwal, Saudi Arabia

项目ID: #18095695

授予:

supper5guy

coffee Hello there, As an expert in google sheet and GAS (google app script), i can use GAS to automate the creation of your required sheets and the necessary emailing to the specific persons as you have specified. 更多

$100 USD 在3天内
(75条评论)
5.5

13 威客就此工作平均出价 $141

zekovicm

Hi there,I am Miljan,Excel expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it within the ag 更多

$166 USD 在3天内
(80条评论)
6.8
asadkhan3533

Please review my profile as i have relevant skills and experience required for this project. Kindly send me a message to discuss further. Thanks, Asad Khan

$250 USD 在3天内
(71条评论)
5.7
sonarkaushik

Sir, I am well versed in these kind of jobs and can do your project as per requirement. I have over 12 years of experiences. I am very much able to work on this. ***I am ready to start Waiting to hear from you 更多

$155 USD 在5天内
(43条评论)
5.6
pilotarif

I can perfectly do your project work and able to complete full work in the shortest possible of time with 100% accuracy, perfection and according to your given instruction. I am ready to show you cost-free sample 更多

$88 USD 在0天内
(34条评论)
4.7
parthapaul0001

Hi, I am very happy to bid in this project. I read your description very carefully and i am experienced in your project. I will complete your project on time with 100% accuracy. Please drop me a message so that we can 更多

$50 USD 在3天内
(6条评论)
2.9
Atik131

HI, I am hoping that you'll find me to be a suitable candidate for the job. I am looking forward to hearing from you and thank you very much for your time as well as any consideration you may give me one chance.

$155 USD 在3天内
(0条评论)
0.0
konanhenry1111

Keyword: data entry Let us discuss in chat I can help u well because we are Arabs. >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

$250 USD 在3天内
(1条评论)
0.0
alimransikder432

Hi there..! I am Emran . I am very professional in any kind of data entry jobs and have valuable experience. I perform data entry related tasks like copy paste, data collection, Web scraping etc.I'm comfortable workin 更多

$83 USD 在3天内
(0条评论)
0.0
omniareda8

The keyword is coffee. This is Omnia Mazroa, I am an Industrial Engineer who is an expert user of Microsoft office especially Excel. I had an internship project which was about transforming the used excel sheet for 更多

$30 USD 在2天内
(0条评论)
0.0
saqibraza2262

coffee

$250 USD 在3天内
(0条评论)
0.0
ameuraekilyes

COMPUTER SKILLS • Programming Languages: Delphi 6-7, Network Simulator 2, Tcl, Perl, C, C++, Java, Pascal, FORTRAN, Matlab, HTML, CSS, Python, JavaScript and SQL. • Assembler: x86, Intel. • Operating Systems: Linux 更多

$35USD 在1天里
(0条评论)
0.0
Sajibchandra

Dear sir, I am expert at Data entry and lead generation. I have a two years experience on the google sheet. So you give me work, I done the work properly. Thank you sir Relevant Skills and Experience Dear sir, I hav 更多

$222 USD 在3天内
(0条评论)
0.0