Find Jobs
Hire Freelancers

Production spreadsheet - auto price calculation + invoice

zł30-90 PLN

Completed
Posted over 9 years ago

zł30-90 PLN

Paid on delivery
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.
Project ID: 6723328

About the project

14 proposals
Remote project
Active 9 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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 customer orders. I propose following solution. You download the google doc in Excel. You have another excel sheet with macro. On press of one button it process the downloaded google doc data and gives you the desired details. You are silent on how you communicate back with customer. This box has limited space to discuss ......Please initiate dialog. About Myself Good Day!. Let me introduce myself for building your confidence in me. Worked at Sr. position with experience of marketing, Service, Production and IT Excel Expert Group Member Access Expert Group Member Worked on Macro, VB, Pivot, User Form Proficiency in Office tools ,SAP, AutoCAD, 3DMax, Coral, Qualification- Mechanical Engineer Available on Skype Some Projects: Developed complete ERP system for Marketing in DB4 (earlier to Access) SAP implementation as Key Coordinator Community Survey (Near 10 Million Data compilation) in Excel Industrial Project Report in Excel Multilingual Kazien Sheet in Excel with VB Offer Preparation in Access Project Planner in Excel Very Large Database Analysis For Details of my Work 1. Please see my profile 2. Please see Services offered by me. If you initiate dialog, I can submit samples of my work. It will be pleasure working for you. I believe in Customer Delight.
zł166 PLN in 3 days
5.0 (2 reviews)
1.6
1.6
14 freelancers are bidding on average zł141 PLN for this job
User Avatar
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(dashboard, pivot tables, charts, conditions, conditional formatting, statistical, financial, mathematical, string, time, date,..functions), creating pretty charts and vba expert. I have done similar projects and I am confident about my profession, I also accept revisions and removing errors and minor changes in future for free, whenever you are ready lets go. I have good command of English that I think can be useful for this project. I have a base of statistics, data analysis, mathematics, accounting, business analysis, cost calculating, project scheduling and project management and finance that helps in this project.
zł166 PLN in 3 days
4.9 (65 reviews)
5.3
5.3
User Avatar
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 on Materials. If you contact me I will send the file otherwise Freelancer will not let me. I have been developing applications in both Access and Excel for 20 years with extensive use of VBA. I have developed several applications for Freelance clients, please see Feedback and examples in Portfolio. I am UK based, a native English speaker, available on Skype and currently on UTC I am available now and would aim to finish in.
zł250 PLN in 4 days
4.9 (33 reviews)
5.1
5.1
User Avatar
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 working with macros and writing / debugging VBA code. You may check my portfolio images to see few pieces of my work. (This is what I do on daily basis). I am a professional and I can do a very good job. Also accurate. Do not hesitate to contact me for further details. Kind Regards, Jon
zł90 PLN in 2 days
5.0 (34 reviews)
4.9
4.9
User Avatar
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 reviews and chat with me. Kind regards.
zł155 PLN in 3 days
4.9 (23 reviews)
4.5
4.5
User Avatar
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 instalowania skryptu. Pozdrawiam, Viktor
zł200 PLN in 2 days
5.0 (10 reviews)
4.0
4.0
User Avatar
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 making of all invoices. You'll need just to download client files to directory and that is, nothing else. Please check my ratings here, tosee quality of my work. BR, Dusan
zł80 PLN in 1 day
5.0 (23 reviews)
3.8
3.8
User Avatar
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 days
4.9 (10 reviews)
3.0
3.0
User Avatar
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 you a PHP script that will do all the necesary calculations
zł75 PLN in 3 days
5.0 (7 reviews)
2.7
2.7
User Avatar
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/skype for voice/ chat. Looking forward a chance with you. Awaiting reply in anticipation. Thanks & Regards Aashish
zł366 PLN in 79 days
5.0 (2 reviews)
0.0
0.0
User Avatar
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 can do it with lower price but for excel. I think I finished it in excel. if you want full job just contact me. To ensure that I will give a high quality job. Here is the sample: put this formula LOOKUP(H2,Materials!E2:E11,Materials!F2:F11)*N2 and it will give you the solution the whole work delivery 3 hours.
zł90 PLN in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of POLAND
Sosnowiec, Poland
5.0
1
Payment method verified
Member since Jul 8, 2011

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.