Ditutup

Create formulas on specialized Excel Document for me.

My company uses several online spreadsheets to track orders and inventory levels. There are three spreadsheets on Google Docs with the data you will need for the Excel document.

I have already created an Excel file that has three sheets on it. Each sheet contains live data from one of the three Google Doc spreadsheets. This data is updated by my company every day, and the updated data automatically updates itself on the Excel document as well.

I already tried to make this document with Google Docs, but it is to large for Google Docs and does not work well, so I am choosing to do it with Excel which does not have the same limitations.

I can supply you the Excel document that already has the three sheets with the live data on it.

Here is the data types supplied by the three sheets:

#1 a list of every item's name, manufacturer, and item-number (SKU), plus a column that combines the SKU, manufacturer, and product name together. This list will grow over time, so the excel document must use this data dynamically.

#2 a list of every order, which includes the Date, SKU, and Quantity, and Category Number. New orders will appear every day.

#3 a list of every item that is received into inventory to restock supplies. This includes date, SKU, and quantity received.

I need a document that tracks the sales every day, starting from 1/1/2012, and continuing into the future. I call this a "Sell-Through Rate" spreadsheet. The document needs to use the data on sheet #3, so that the document will know if an item is sold out.

Since we sell hundreds of different items, I would like there to be additional sheets that show only the "Sell-Through Rate" for items with a certain Category Number, or items by a certain manufacturer.

If you would prefer not to create the additional sheets, then I should be able to create the additional sheets once you have created the main sheet, by copying/modifying your formulas.

It would be great if this document could also show a graph of sales by item, or by category number/manufacturer if that is easier.

I can modify the live data slightly if you need me to.

This is not a data-entry job.

Kemahiran: Excel

Lihat lebih lanjut: specialized formulas excel, create specialized formulas excel, work online for google, work for google online, which graph to use for data, starting an online sales company, sell excel spreadsheets, online work on google, online manufacturer, online create graph, need a manufacturer of my product, my excel online, manufacturer order, manufacturer online, make an online graph, list of graph types, list graph, i have a product i need a manufacturer, data on a graph, data for a graph, create online graph, create graph, create an online graph, create a graph online, create a graph

Tentang Majikan:
( 11 ulasan ) oakland, United States

ID Projek: #1575287

27 pekerja bebas membida secara purata $3879 untuk pekerjaan ini

pishty

I am interested in your project.

$150 USD dalam 7 hari
(28 Ulasan)
5.6
danielgpratidya

Hi, count me in please

$100 USD dalam 3 hari
(68 Ulasan)
5.5
Krusche

Creating Formulas in Excel is our core specialization. Have a glance at PMB

$240 USD dalam 4 hari
(21 Ulasan)
5.2
best4best

I am an Excel expert. Can you please provide the existing spreadsheet? Thanks.

$100 USD dalam 3 hari
(55 Ulasan)
4.9
srinichal

Let us discuss further

$250 USD dalam 12 hari
(3 Ulasan)
4.4
ethicalboy

Please see what I said.

$220 USD dalam 10 hari
(23 Ulasan)
4.4
hemi

Please, check PMB for more details. Thanks

$200 USD dalam 7 hari
(12 Ulasan)
3.8
Petros73

Hi, I am a Finance Professional with extensive experience in data analysis. You can be assured that I can provide you with quality work and results. Regards Petros

$350 USD dalam 5 hari
(1 Ulasan)
3.6
ahmedmayeen

Hi, I placed my formal bidding letter in a private message. Please refer to that. Regards, Mayeen

$250 USD dalam 7 hari
(4 Ulasan)
3.4
David3110

Hello, I am a MS Excel expert. I have a lot of experience in spreadsheet database construction as I do this on nearly a daily basis in my day job. I am a reliable, accurate freelancer. I complete on time and my work is Lagi

$220 USD dalam 6 hari
(1 Ulasan)
3.3
shagoon2u

Excel & VBA Experts are ready to start immediately

$200 USD dalam 3 hari
(3 Ulasan)
2.9
sumshank

Thanks for your time in reading my bid. Here is what I can offer: - Excellent MS Excel skills, having used it extensively during my work with the Information Technology industry. - My Excel work includes usage of Lagi

$100 USD dalam 5 hari
(3 Ulasan)
2.4
CSJain

Hello Mr Schooner, I am interested for the job. Pls check your pm for more details. Thanks, Chaitanya

$200 USD dalam 5 hari
(0 Ulasan)
0.0
Yuren

Hi .. I am ready to take this [url removed, login to view] provide the data & sample file.. thanks yuren

$200 USD dalam 5 hari
(0 Ulasan)
0.0
pooja2012

Hi, I am a software engineer by profession and has worked a lot in excel and VBA.I can take this project.

$65 USD dalam 7 hari
(0 Ulasan)
0.0
jinxterminate

I perfectly Understand the Nature of Job, Experienced Excel VBA Programmer

$70 USD dalam 2 hari
(0 Ulasan)
0.0
azaddomar

PMB Please see PMB

$220 USD dalam 180 hari
(0 Ulasan)
0.0
mlpraveena

Please check pmb

$100 USD dalam 3 hari
(0 Ulasan)
0.0
jimar

Hello good day im a newbie here in freelancer but im expert about excel i like your project sir it so easy for me to do this.

$90 USD dalam 3 hari
(0 Ulasan)
0.0
vkankipa

Dear Sir, I have good knowledge on excel and macros in excel. I assure of the highest quality throughout the project. Vamsi

$200 USD dalam 7 hari
(0 Ulasan)
0.0