Create formula in Google Sheet

$30-250 USD

Imekamilika

Imechapishwa

over 6 years ago

$30-250 USD

Kulipwa wakati wa kufikishwa

File:(Google Sheet) Master Sheet Van Wingerden [login to view URL] Create a formula in the google sheet "Inventory" for each column named (week #). The formula will move inventory from one column to the next based on the time (Sunday evening at 12:00AM PST.) It will also look up the week# according to SKU in the "production" sheet as well as "sales" sheet to add (production) and minus (sales). Additionally, it will remove the number appearing in the production sheet "waste#" column. The number in the current week then should give us the total inventory we have available 1.) Sheet: Inventory: COL M-BL = The formula in each column will look in previous week# column and move all existing inventory to the current week. 2.) The formula will look up the same SKU and add the number appearing in sheet "Production" in the current week. 3.) The formula will look up the same SKU and minus the number appearing in sheet "Sales" in the current week. 4.) The formula will look up the same SKU and minus the number appearing in the Sheet "Production" in the current week "waste" Notes: Determin Week: =WEEKNUM(TODAY())

Excel

Kitambulisho cha mradi: 15741565

Kuhusu mradi

7 mapendekezo

Fungua kutolewa zabuni

Mradi wa mbali

Inatumika 6 yrs ago

Weka zabuni yako

Kiasi cha zabuni

USD

Barua pepe

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa

Pata malipo kwa kazi yako

Eleza pendekezo lako

Ni bure kujiandikisha na kutoa zabuni kwa kazi

Imetolewa kwa:

@cgullapalli

Hi, I am good at Google sheet formulas. I have referred the google sheet link to work on as described. I would like to discuss further in the chat and start working on it right now. -Chandra Relevant Skills and Experience Excel, Google sheets formulas. Proposed Milestones $60 USD - Milestone

$60 USD ndani ya siku 0

5.0

(572 hakiki)

7.6

7 wafanyakazi huru wana zabuni kwa wastani $138 USD kwa kazi hii

@SBITServices

Hello , I have read your project description and understood your requirement. I am an Expert in Excel and can complete task within time with 100% accuracy. Relevant Skills and Experience Skills : Excel, Macros,VB.net, Web scraping, Data entry, Copy typing, Transcription works Proposed Milestones $50 USD - Project

$50 USD ndani ya siku 1

4.9

(192 hakiki)

6.9

@KulfiSoftwares

I am an expert with Excel and Google Spreadsheets. Have setup advanced formulas on both the platforms, and can do this for you. Relevant Skills and Experience Please read my 260+ reviews. I am here to impress you with my work. Proposed Milestones $100 USD - To setup the spreadsheet, as described

$100 USD ndani ya siku 3

5.0

(153 hakiki)

6.9

@schoudhary1553

Hello Sir, I am the expert freelancer for Create formula in Google Sheet job . i have deliver more than 250 projects with 100% client satisfaction. so please give me chance to work on your job. Relevant Skills and Experience I have more than 5 years of experience in Excel Proposed Milestones $250 USD - Create formula in Google Sheet

$250 USD ndani ya siku 4

4.9

(191 hakiki)

7.1

@asin1987

Respected Sir/Mam I will do any formula, function, formatting, calculation, modification, automation, graphs, charts on Excel. I hope to work with you. Thanks!! Relevant Skills and Experience Excel VBA Proposed Milestones $250 USD - Project

$250 USD ndani ya siku 3

5.0

(21 hakiki)

5.2

@devi222

Hi Sir, I am expert in Excel formula. I can create the formulas as you mentioned in way by tomorrow. I can start right now. I have done 150+ excel tasks so far. Message me we can start now Relevant Skills and Experience excel Proposed Milestones $100 USD - Milestone

$100 USD ndani ya siku 1