Excel Project
$250-750 USD
Paid on delivery
We design wall panels and other building components that are used to construct homes and buildings (Building System)..
There are approximately 15 main components (Components) that make up our Building System; all components are designed by us - such a wall panel or a window or other prefabricated component.
We subcontract manufacture of ALL Components to other Suppliers.
We use a 3D drawing program called Sketchup to draw the house or building.
Sketchup has a library and we have populated the Sketchup library with drawings of each of the Components used in our Building System. Each Component has a unique ITEM CODE
Once we finish the drawing of a house or building in SketchUp; Sketchup can export a CSV file containing all the Item Codes of the Components in the building.
Note - the CSV export from SketchUp: -
a. Only lists all the Components in the building by ITEM Code - no other information is in the CSV export; and
b. The CSV does not calculate the number of identical Components. For example, if there are 10 identical Components in the CSV file ; then the file will have 10 lines of the same Item Code
This project is to build an Excel workbook that can import the CSV file of Components Item Codes from SketchUp auto fill Purchase Order templates (in the workbook) to our Suppliers for all the Components for each house or building
Project ID: #18944125
About the project
Awarded to:
Greetings! I understand your requirements and I can come up with a Excel based solution to take in as its input CSV from Sketchup and generate completed Purchase Orders. Being a full time freelancer working exclu More
27 freelancers are bidding on average $428 for this job
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. More
Hi, my name is Selim. I am from Solihull, UK. I read your `Excel Project` project descriptions carefully before bidding. I checked the attached pdf as well... I got what you need and ready to go ahead as soon as we ca More
I am good at Excel formula and VBA/Macro, I need to see the data so I can understand your requirement, I might have a few question to discuss so I need you to send a message on chat.
Hi There! I am an Australian Business Analyst (based on the Sunshine Coast) with over 15 years professional experience building complex data transformation and checking tools using Excel, Access, SQL Server etc. I h More
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 More
Hello. I have done very similar project recentely and can help you to create such an excel tool to output purchase teamplate in excel, pdf or any other format required. Mentioned previous project is under the lin More
Hi, I am interested. May I propose to create a user friendly MS Access database for the purpose. I have considerable expertise in the design and development of MS Access databases. Results can be generated in MS Excel More
Just send me the a CSV file exported, I will do it for you. If you were content, accept my bid
Hello, I would love to do this project. I have very good experience in excel related work. I assure you to provide best quality work in required time and budget. I am looking forward to hear from you. Thank You.
I'm very interested in taking your project, mainly because I have worked in construction as a warehouse manager and later in the procurement department in a hospital, so I can relate my professional experience to your More