Production spreadsheet - auto price calculation + invoice

I need solution for existing production sheet.

My customer is filling order in spreadsheet (google docs - grey columns). Then i have to prepare product, calculate price and fill same data in other software to make an invoice. It's time consuming.

I would need solution to calculate price automatically (Column K) according to specific material (fabric) and m2 used. If product is laminated then there is extra cost 1m2 = 10 .

There are 2 kinds products that i produce. They are in Materials tab.

IT would be perfect if i could automatically prepare invoice for all products that have status READY.

Invoice numer should be incremented every time we generate that doc.

Every product should have product ID, material, size and price.

I don't know the best solution for me.

Can we do that is gdocs or we import data from gdocs to excel or make php + mysql scripts.

I prefer simplicity. Please let me know how we can do this.

Evner: Excel, Microsoft, MySQL, PHP, Software Arkitektur

Se mere: production spreadsheet, google scripts spreadsheet, google docs scripts, spreadsheet google, google spreadsheet scripts, google docs status, google docs cost, customer spreadsheet, google docs mysql, fabric php, fill data google spreadsheet, prepare product, price sheet, mysql spreadsheet, mysql excel import data, import data mysql excel, google spreadsheet sheet, need data prepare excel sheet, google doc spreadsheet, mysql production

Om arbejdsgiveren:
( 1 bedømmelse ) Sosnowiec, Poland

Projekt ID: #6723328

Tildelt til:


Loud Thinking- You are getting the order in Google Doc and need the details out of Google Doc where you need to process the same. You have not submitted the format of Google Doc. I presume there is standardization in c Flere

zł166 PLN in 3 dage
(2 bedømmelser)

14 freelancere byder i gennemsnit zł141 på dette job


Hi, I am working as Lead Pricing Analyst in a Fortune 500 MNC. [LinkedIn profile at bottom] I have worked on pricing models, income statements, value-pricing projects etc. I have worked extensively on business analys Flere

zł85 PLN in 2 dage
(30 bedømmelser)

Hello ready to start asap to deliver you, If you can give me your notes and conditions, I can deliver it to you fast, also about me: I am m.s of systems engineering and b.s of industrial engineering, and excel(dashboa Flere

zł166 PLN in 3 dage
(65 bedømmelser)

Try this formula in column K of Orders. =IF(H2="Canvas",VLOOKUP(F2&"X"&G2,canvas,2,FALSE),VLOOKUP(H2,wall,2,FALSE)*N2)+O2 It will work for wallpaper and for canvas where there is an exact match to WidthXHeight Flere

zł250 PLN in 4 dage
(33 bedømmelser)

Hi there, I can work on a customized application for you, the way you really need it. I've been working with Excel since before '98 and I've been using all possible versions of it. I have years of experience worki Flere

zł90 PLN in 2 dage
(34 bedømmelser)

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas and macros. I am also a neat, tidy, and committed to my work person. Check my Flere

zł155 PLN in 3 dage
(23 bedømmelser)

Czesc, moge pomoc. Napisze skrypt dla google docs ktory automatyczie policze cene, zgeneruje invoice i jezeli potrzebne wyszle mejla z linkiem na ten odpowiedni invoice. Przeoprowadze niezbedne instrukcje dla instal Flere

zł200 PLN in 2 dage
(10 bedømmelser)

Hello, I'm expereinced busines analyst working for Makro, so I'm more than able to this simple task. I'll create simple VBA that will be run by hitting button on Excel sheet, and it will do all calculations and mak Flere

zł80 PLN på 1 dag
(23 bedømmelser)

Hi, Thanks for posting this project. I can write the macro in excel for you which will create the invoicing and invoice number can be incremented automatically and also data can be imported as well exported. Flere

zł75 PLN på 1 dag
(17 bedømmelser)

Hi! it is my pleasure to help your project. Excel automation is my masterpiece. Feel free to message me with your actual data. Thank you.

zł100 PLN in 3 dage
(10 bedømmelser)

i understand your need and can help you with your project. Have a good web search/data entry experience can start immediately the simplest way is to do well that via PHP page connected to mysql database can write Flere

zł75 PLN in 3 dage
(7 bedømmelser)

Hi, Greeting for the day. First of all we thanks to you for given us an opportunity to work with you. We have gone through your requirement. We are much interested in your project. I am available on gmail/ Flere

zł366 PLN in 79 dage
(2 bedømmelser)

I can provide you with an access database and forms for entering the price and issue the invoice but wiht higher price. Trust me if you want to do it with good way use access database either I will do it or not. I ca Flere

zł90 PLN på 1 dag
(0 bedømmelser)

Respect - [login to view URL] , i like this ................

zł75 PLN in 3 dage
(0 bedømmelser)