Re: Floor Plan Sketch in Excel
From: Alan (anonymous_at_discussions.microsoft.com)
Date: 02/27/04
- Next message: Dave Peterson: "Re: Prevent excel to auto format and auto apply formula to a cell when opening a file"
- Previous message: Dave Peterson: "Re: printing format"
- In reply to: Bob Phillips: "Re: Floor Plan Sketch in Excel"
- Next in thread: Frank Kabel: "Re: Floor Plan Sketch in Excel"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 26 Feb 2004 18:35:34 -0800
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.
>-----Original Message-----
>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)
>
>"Frank Kabel" <frank.kabel@freenet.de> wrote in message
>news:uoAMAxL$DHA.3712@tk2msftngp13.phx.gbl...
>> 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
>>
>> --
>> Regards
>> Frank Kabel
>> Frankfurt, Germany
>>
>> Bob Phillips wrote:
>> > like Visio.
>> >
>> >
>> > "Frank Kabel" <frank.kabel@freenet.de> wrote in
message
>> > news:OlTXSVL$DHA.2316@tk2msftngp13.phx.gbl...
>> >> 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.
>>
>
>
>.
>
- Next message: Dave Peterson: "Re: Prevent excel to auto format and auto apply formula to a cell when opening a file"
- Previous message: Dave Peterson: "Re: printing format"
- In reply to: Bob Phillips: "Re: Floor Plan Sketch in Excel"
- Next in thread: Frank Kabel: "Re: Floor Plan Sketch in Excel"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
