Closed

Excel Project

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

Skills: Excel

See more: project management dashboard excel template free, excel project management template with gantt schedule creation, free project management templates excel 2007, project management dashboard excel, excel project timeline template, free excel project management tracking templates, free excel project management template, multiple project tracking template excel, access project templates, project rate card graphic design, excel project manage template web design, access 2007 project templates, project management tool database design, best project manager software web design, project templates bank, project templates web design projects, microsoft project templates web design, project templates web design, microsoft project templates free web design, excel workbook templates project

About the Employer:
( 0 reviews ) Brisbane, Australia

Project ID: #18944125

27 freelancers are bidding on average $428 for this job

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community ( More

$600 USD in 5 days
(659 Reviews)
8.4
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
(288 Reviews)
7.7
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
(265 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
(177 Reviews)
7.1
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
(75 Reviews)
7.0
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
(198 Reviews)
6.8
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
(164 Reviews)
6.6
SShtv

Hi, I'm interested in your proposal. Your task is clear to me and I am ready to solve it. I have a large and successful practical experience of processing and analyzing data in Excel, including using the VBA. These a More

$250 USD in 4 days
(75 Reviews)
5.9
periyannas

Ok Sure

$722 USD in 7 days
(89 Reviews)
6.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
(72 Reviews)
6.3
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
(61 Reviews)
5.8
aubrey03

I am an MS Excel and Access Specialist and an experienced Freelancer who is dedicated to provide quality results within a reasonable timeline and budget. Accuracy is my priority so I believe I am the best freelancer fo More

$300 USD in 5 days
(81 Reviews)
5.5
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.3
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.6
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
(26 Reviews)
4.9
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
(17 Reviews)
4.3
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
(42 Reviews)
4.4
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
(9 Reviews)
3.6
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
(4 Reviews)
3.1
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
(2 Reviews)
0.9