Floor Plan Sketch in Excel

[Alan]

Is there a way to draw a floor plan sketch in Excel, then
calculate the area? The Excel freeform polygon drawing
tool lets you draw a polygon, but I haven't found a way
to caclulate the polygon area.

Is there an excel sketch addin (or other utility) which
allows you to draw a floor plan sketch and calculate the
sq footage?

Is there an area calculation utility which will calculate
the area for an excel freeform polygon?

For reference, I posted this in the Excel Programming
forum also, no response so far.

thanks.

 

[Frank Kabel]

Hi Alan
AFAIK there is no such Add-In for Excel (Excel has just some simple
drawing capabilities). Your probably should look for a specific
application to do this (try a Google search for this)

 

[Bob Phillips]

like Visio.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Frank Kabel]

Does that calculate areas? - not quite sure and just curious .
I just entered 'floor sketch plan' in Google and received a lot of
useful looking hits

 

[Bob Phillips]

You can do it with VBA, although it has a seriously odd object model.

I have a great example that builds a visual job-schedule, you add a job,
start and end times, and it puts a arc on the 24 hour clock/wheel.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Alan]

Thanks for the suggestions.

I already have Excel hooked up to a popular 3rd party 2d
sketch package via VBA. I can start the 3rd party
package, draw the diagram, transfer the image, sq footage
and other info to excel and include this in the excel
report.

After playing with the Excel drawing package, I think
Excel can provide similar functionality with a little VBA
code. I consider some of the Excel drawing options
easier to work with than the 3rd party sketch packages.
This will be really slick if I can get it to work, you'll
be able to fill out the entire report and sketch in excel.

The only piece missing from Excel which I don't think I
can provide is the area calculation for a freeform shape
object. I'm sure somebody has already done this, I just
need to find it. I've been searching google and other
forums trying to find an Excel compatible area
calculation tool, no luck so far.

I think the Excel drawing option already uses some area
calculations to provide fill color, I'm surprised they
did not make this available in the interface.

 

[Frank Kabel]

Hi Bob
I'm definitely interested in your example. I have used Visio only in
combination with Access/SAP to automatically create organizational
charts.
And yes Visio's VBA implementation is a completely different thing

 

[Bob Phillips]

Frank,

It's on another machine, so I will dig it out and mail directly to you.

Regards

Bob

 

[Sequoia]

or AutoCAD ... what the original poster describes is
basically an AutoCAD function.

- Sequoia

-----Original Message-----
like Visio.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

<snip>

Hi Alan
AFAIK there is no such Add-In for Excel (Excel has just
some simple
drawing capabilities). Your probably should look for a
specific
application to do this (try a Google search for this)

--
Regards
Frank Kabel
Frankfurt, Germany

Alan wrote:
Is there a way to draw a floor plan sketch in Excel, then
calculate the area? The Excel freeform polygon drawing
tool lets you draw a polygon, but I haven't found a way
to caclulate the polygon area.
Is there an excel sketch addin (or other utility) which
allows you to draw a floor plan sketch and calculate the
sq footage?

Is there an area calculation utility which will calculate
the area for an excel freeform polygon?

For reference, I posted this in the Excel Programming
forum also, no response so far.

thanks.