Creating a parametric model in a spreadsheet linked to autocad(2d)

Creating a parametric model in a spreadsheet that could automatically draw the model in autocad (2d) based on the spreadsheet data inputs?

I think that would be the best way to do it, we have many layouts to get done as you can see here ;

[login to view URL]

See exemple below :

so the jpeg file is the actual customer order. the customer can choose whatever dimension he wants, and those were the final dimensions chosen. those dimension are the "total shower dimension size" base on the shower "center-line". from those dimension we need to create the actual fabrication size of each glass panel for production. i used autocad to create the pdf file. this pdf file is what i sent to production. it does not even have to be to scale, so i usually simply use template i already have and change the dimension in text accordingly.

essentially each type of hardware is associated with a specific deduction, that is pres set, and the corner junctions too, so we would simply need to establish the rules for all the hardware, but its 95% of the time the same 10 type of hardware...

there is about 10 to 20 drawing to be done per week. more or less

essentially here were the deductions made;

we take out 1/8" (to width and to the height) for the glass to wall clamps hardware. (gap between the wall and the glass.)

we take out 1/2" for the gap at bottom of the door for the door sweep.

we take out 5/16" each side (total 5/8") for the door gap for the door seals.

drawings were made based on centerline measurements, and the fixed panel passes in front of the return panel at the corner,

so i have added half of the thickness of the glass so 3/16" (10mm glass = 3/8" , 3/8"/2 = 3/16" ) to the total width of the fixed panel,

i have removed 3/16" for the return panel width for the same reason and i have also removed 1/8" at the all for the clamp. so return panel width = 38-1/2" - 3/16" -1/8" = 38 3/16"

Compétences : AutoCAD, CAD/CAM, Excel, Architecture du Bâtiment, Modélisation 3D

Concernant l'employeur :
( 29 commentaires ) Mascouche, Canada

Nº du projet : #32650083

17 freelances font une offre moyenne de 22 $/heure pour ce travail


Hi there As a highly skilled CAD/CAM/SolidWorks/3D Max designer, I can help you perfectly. You can see my portfolio. I am very confident with my skills and I'd like to help your business by doing my best. My clients ha Plus

$50 CAD / heure
(60 Commentaires)

Dear, I am very happy bid on your project. I checked your project proposal carefully. I am expert in parametric drawing by using autocad and Microsoft excel software. I will make perfect design as per your requirement Plus

$20 CAD / heure
(31 Commentaires)

Hello there. I have an experience with creating a parametric model in a spreadsheet linked to autocad(2d). If you give chance me, you will get good result. I hope to work with you because your project is very familiar Plus

$25 CAD / heure
(28 Commentaires)

Hi sir I am a mechanical engineer and I have six years of experience in industrial design with SolidWorks software in all technical and engineering fields and I am completely proficient in 3D modeling and I am a profes Plus

$15 CAD / heure
(26 Commentaires)

Hi, I'm a CAD programmer since 1990. I have created many AutoCAD applications using Autolisp, VBA, VB .Net, C # and, C ++ (ObjectARX). I also created Revit plugins using C # and Inventor plugins using VB .Net. I am als Plus

$35 CAD / heure
(6 Commentaires)

Dear I have carefully checked your project description. I am Architect with 7 years of experience. I have wealthy experiences Building Architecture, Modeling and Rendering Animation working on similar projects to desi Plus

$20 CAD / heure
(7 Commentaires)

Dear Employer - the greeting of the day... I am M.Sc. Freelancer product Engineer, specialized for 12 years in many skills such as: -  Product Design (Drawing -Assembly-simulation- Rendering).  3D Modelling (AutoCA Plus

$20 CAD / heure
(20 Commentaires)

Hello, I am a professional CAD CAM and CAE design engineer. I am expert in AutoCAD. I can help you in this project. I hope you contact me as soon as possible. Thankyou regards

$20 CAD / heure
(9 Commentaires)

Hi I am a mechanical engineer with over 15 yeas experience in AutoCAD drafting. I am confident that I can create your parametric model in excellent quality on time. Looking forward to a long term relationship

$15 CAD / heure
(9 Commentaires)

Hello, I have 8+ years of experience in the BIM industry. I have done the Revit project from LOD 300 to LOD 500. I have a team to work properly on your project. Please check the portfolio for sample work. I have below Plus

$15 CAD / heure
(1 Évaluation)
(9 Commentaires)
(2 Commentaires)

Hi, I have read your project description and I am highly interested in your project. As I am expert in SOLIDWORKS, AutoCAD,3D Modeling,3D animation and 3D rendering. So I can complete your project within estimated time Plus

$15 CAD / heure
(4 Commentaires)

Hi! I am a 3D modeler and have been working in this profession +10 years.I have gone through your posted job.I can customise Autocad template with excel VBA. You could open conversation to discuss further. I look forw Plus

$15 CAD / heure
(0 Commentaires)

I am venkatesan from chennai I have 15+years experience in autocad drawings i have clarification if i draw with decimal or mm drawings

$22 CAD / heure
(0 Commentaires)

i am offering my services on short notes . relevante skills and experience please consider me and give me a chance to impress you by my quality service.

$20 CAD / heure
(0 Commentaires)

Hi, I can try to do some of your models in AutoCA. If you are interested I am willing to collaborate on a few examples, but I cannot create a parametric model in a spreadsheet that could automatically draw the model in Plus

$20 CAD / heure
(0 Commentaires)