Excel Project

In Progress Posted 5 years ago Paid on delivery
In Progress 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

Excel

Project ID: #18944125

About the project

27 proposals Remote project Active 4 years ago

Awarded to:

ksriniravi

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

$250 USD in 7 days
(176 Reviews)
6.7

27 freelancers are bidding on average $428 for this job

schoudhary1553

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

$550 USD in 5 days
(299 Reviews)
7.8
seaanddream

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

$400 USD in 5 days
(271 Reviews)
7.7
paris2785

Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an application in Excel to import a CSV file and manipulate data inside it. I've More

$500 USD in 5 days
(190 Reviews)
7.2
Tanmoy236

"I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. Completed mor More

$400 USD in 2 days
(210 Reviews)
6.8
dgled

I’ve read your proposal regarding creating a database from CSV files to Excel and manipulating the data in a structured database. During the process, Excel validates the data and prepares reports and documents based on More

$500 USD in 10 days
(78 Reviews)
7.0
seoguru17

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.

$333 USD in 5 days
(76 Reviews)
6.3
periyannas

Ok Sure

$722 USD in 7 days
(98 Reviews)
6.1
aimefx

Hi, I am an expert in Excel, Access, VBA and Power bi. I have read your pdf file and create the invoicing system that imports CSV files and print and exports invoice as pdf. I am ready to start your project, Ple More

$350 USD in 10 days
(70 Reviews)
5.9
nvchien94

Hello there, I am an Excel VBA coder and I also work as management accounting. I worked with BOM 4 years+ and understand your CSV file is 1 kind of BOM. I can give your script to complete your task. Fast and correc More

$250 USD in 1 day
(98 Reviews)
5.5
katiewells3

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

$350 USD in 10 days
(28 Reviews)
5.1
afenache

Hi, I can build the excel tool that you need for your orders. I can create an VBA script to import the csv file and to summarize all components in the order form with one click on a button. Best regards, Florin Enac More

$250 USD in 3 days
(19 Reviews)
5.2
zu02

Hi, there I hope all's well with you. I carefully viewed your pdf file. Best solution will be Ms Access software with csv,Excel automation. I can build very friendly ms Access app for your "Building System" pro More

$750 USD in 10 days
(18 Reviews)
5.2
sonarkaushik

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

$444 USD in 5 days
(43 Reviews)
5.5
KozlouAlex

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

$270 USD in 2 days
(21 Reviews)
4.4
dionisiotumbaga

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

$290 USD in 5 days
(5 Reviews)
3.6
mehranica

Just send me the a CSV file exported, I will do it for you. If you were content, accept my bid

$250 USD in 1 day
(4 Reviews)
2.3
Mish1106

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.

$250 USD in 2 days
(1 Review)
1.4
liejuni

Hi, are you using 2019 SU2XL? extension for the import? we also create a simple design using SketchUp, we are designing aquarium all you need next is the macro to filter the data that you need and put the data in More

$555 USD in 10 days
(1 Review)
0.8
gmcentenom

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

$500 USD in 14 days
(0 Reviews)
0.0
dugite

Hello. You have certainly given a lot of information so that makes it easier to prepare a bid. I have been working with Excel for over twenty years so your project should be easy enough to complete. You made mention More

$666 USD in 7 days
(0 Reviews)
0.0