Ditutup

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

Kemahiran: Excel

Lihat lagi: 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

Tentang Majikan:
( 0 ulasan ) Brisbane, Australia

ID Projek: #18944125

27 pekerja bebas membida secara purata $428 untuk pekerjaan ini

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 ( Lagi

$600 USD dalam 5 hari
(659 Ulasan)
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. Lagi

$550 USD dalam 5 hari
(288 Ulasan)
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 Lagi

$400 USD dalam 5 hari
(265 Ulasan)
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 Lagi

$500 USD dalam 5 hari
(177 Ulasan)
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 Lagi

$500 USD dalam 10 hari
(75 Ulasan)
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 Lagi

$400 USD dalam 2 hari
(198 Ulasan)
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 Lagi

$250 USD dalam 7 hari
(164 Ulasan)
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 Lagi

$250 USD dalam 4 hari
(75 Ulasan)
5.9
periyannas

Ok Sure

$722 USD dalam 7 hari
(89 Ulasan)
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 dalam 5 hari
(72 Ulasan)
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 Lagi

$350 USD dalam 10 hari
(61 Ulasan)
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 Lagi

$300 USD dalam 5 hari
(81 Ulasan)
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 Lagi

$750 USD dalam 10 hari
(18 Ulasan)
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 Lagi

$444 USD dalam 5 hari
(43 Ulasan)
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 Lagi

$350 USD dalam 10 hari
(26 Ulasan)
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 Lagi

$250 USD dalam 3 hari
(17 Ulasan)
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 Lagi

$250 USD dalam sehari
(42 Ulasan)
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 Lagi

$270 USD dalam 2 hari
(9 Ulasan)
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 Lagi

$290 USD dalam 5 hari
(4 Ulasan)
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 dalam sehari
(2 Ulasan)
0.9