I offer it here - along with my reply - for possible information/education
of other visitors who may have similar needs or requirements:
-------------------------------
On Fri, January 23, 2009 10:18 am, <email deleted> wrote:
> On 2009-01-23 at 01:18:42,
> The following information was submitted:
> From Host: 217.14.90.14
> name = Abe <rest of name deleted>
> submit_by = <email deleted>
> company = Gates & Wood Ltd
> address = Nil
> city = Lagos
> states = Lagos
> country = Nigeria
> phone = <deleted>
> how_found = Online Search for phones that run EXCEL
> interest = Applications
> comments = My company is going into the design and construction of prefab
> houses. to this end we want to develop an application that will rapidly
> model houses in 3D. I want to use excel to generate a autocad script
> capable of modelling a house in 3D.
>
> I have seen samples that insert simple objects but I want to develop
> something more comprehensive. It will involve an input page where I can
> insert wall details, lenght, direction, and utilities. Excel will then
> generate a notepad document with the correct insertion for individual
> blocks ( three types), on each level (6 levels). the script will then
> insert window and door blocks based on the input sheet and delete any
> clashing block.
>
> I can supply all the required command in autocad, and the there is a
> sample spreadsheet that I did that manually makes this decision
>
>
> A similar sample can be found on www.lazydrafters.com
>
>
Below is the response I sent to the enquirer. If you have a similar need, contact me.
-------------------------
Subject: Re: Excel app to generate 3D modelling autocad script
From: "Tayo K. Solagbade" <tayo@spontaneousdevelopment.com>
Date: Sat, January 24, 2009 7:31 am
To: <email deleted>
Hi Abe,
Thanks for your mail. Your request (and the phone no. you supplied)
suggest you are the same person who called me yesterday.
Just checked http://www.lazydrafter.com and went through 2 posts (e.g.
http://www.lazydrafter.com/autocad-tips/writing-autocad-scripts-with-excel/)
that I found by doing a search on the site using the search strings
"excel, script, 3d".
What you want can be done i.e automation of the entire process etc. Next
step is for us to meet and discuss specific details of your requirements.
Pre-project startup, I always work with clients to produce a Functional
Requirements Specification (FRS) document, which is a detailed list - that
can be ticked off by the client during program test-run - specifying what
the client WANTS the program to be able to do.
Preparing/agreeing a formal FRS document allows accurate estimation of
work to be done + project costing, in addition to ensuring that both
parties know what is expected to be in place at the end of the project.
If you wish to take this further, please call me on 0803-302-1263.
Warm Regards,
tayo.
-------------------------
Back
to Stories Index
