Hornresp - Page 192 - diyAudio
Go Back   Home > Forums > Loudspeakers > Subwoofers

Please consider donating to help us continue to serve you.

Ads on/off / Custom Title / More PMs / More album space / Advanced printing & mass image saving
Reply
 
Thread Tools Search this Thread
Old 25th May 2011, 06:03 AM   #1911
diyAudio Member
 
Join Date: May 2007
Quote:
Comma separated values files can be opened directly in Excel.
Hello David,
Itereting, tried it and for me it wasn´t easier than pasting the file from the opened *.txt-fil. Haven´t used *.csv before, are there any advantages using it?
  Reply With Quote
Old 25th May 2011, 06:20 AM   #1912
diyAudio Member
 
Join Date: Jun 2007
Quote:
Originally Posted by revintage View Post
Haven´t used *.csv before, are there any advantages using it?
Hi Lars,

It removes the need to manually copy and paste the data into the spreadsheet.

Simply double-click on the *.csv filename in the Hornresp\Export folder to automatically open the file in Excel.

Kind regards,

David
__________________
www.hornresp.net
  Reply With Quote
Old 25th May 2011, 02:18 PM   #1913
DrDyna is offline DrDyna  United States
diyAudio Member
 
DrDyna's Avatar
 
Join Date: May 2007
Blog Entries: 3
Quote:
Originally Posted by David McBean View Post
Hi DrDyna,

Hornresp data values can optionally be exported as 'comma separated values' or *.csv files, rather than 'text' or *.txt files, if this is preferred. Comma separated values files can be opened directly in Excel. Note 15 on page 20 of the Help file may also be of interest.

Kind regards,

David
Thanks for the response!

I was also considering the csv export. It does make hiding columns and copying data a little easier, however I'm still confronted with a wall of text, I.E: attached image.

I do understand that these numbers can be worked with by those used to it, and I'm sure if I read note 15 a few dozen more times and quintuple check my work to make sure I haven't fat fingered a number I can eventually make it work, but as this is my first foray into using Hornresp, I'm absolutely terrified that I'm going to make a mistake.

I have a little bit of ADD when it comes to numbers. I've never had a problem with any of the standard cabinet work that I've done in the last decade or so (h, w, d, yay volume) however this is quite confounding, considering the nature of a horn, where a measurement being off by half a centimeter could be the difference between a sub that brings tears to my eyes and one that has the drivers removed after one song and tossed back down into my pile of wood.

I love the program so far, and I'm trying my absolute best to use it properly, however it just seems that exporting a 3 dimensional object into a format that can be directly utilized (Second attached image) could be easier.
Attached Images
File Type: jpg csvandtext.jpg (295.4 KB, 147 views)
File Type: jpg 3dexample.jpg (17.1 KB, 141 views)
  Reply With Quote
Old 25th May 2011, 03:34 PM   #1914
diyAudio Member
 
Join Date: May 2007
Quote:
Simply double-click on the *.csv filename in the Hornresp\Export folder to automatically open the file in Excel.
Yes that is the way to go. but in my Excel, I get tiresome questions in two steps.

So copy and paste isn´t to bad.

Eventually not so much to discuss the result is the same.

Any one found a working, easy to use, Excel to CAD-program converter?
  Reply With Quote
Old 25th May 2011, 04:13 PM   #1915
DrDyna is offline DrDyna  United States
diyAudio Member
 
DrDyna's Avatar
 
Join Date: May 2007
Blog Entries: 3
Quote:
Originally Posted by revintage View Post
Yes that is the way to go. but in my Excel, I get tiresome questions in two steps.

So copy and paste isn´t to bad.

Eventually not so much to discuss the result is the same.

Any one found a working, easy to use, Excel to CAD-program converter?
I'm sure there are some types of Excel to CAD conversions available, however it's all going to depend on the source application that produces the Excel data that needs to be converted. It would have to be specifically designed for Hornresp's output.

I wish I had the programming expertise to make a conversion plugin for Sketchup that could handle a hornresp csv/txt.
  Reply With Quote
Old 25th May 2011, 04:21 PM   #1916
diyAudio Member
 
Join Date: May 2007
Think we see different use for the conversion. I see it only for straight mid- and HF-horns that later should be cut with a router.
  Reply With Quote
Old 25th May 2011, 04:25 PM   #1917
NEO Dan is offline NEO Dan  United States
diyAudio Member
 
NEO Dan's Avatar
 
Join Date: Jun 2008
Location: N.E. Ohio
Quote:
Originally Posted by DrDyna View Post
I'm sure there are some types of Excel to CAD conversions available, however it's all going to depend on the source application that produces the Excel data that needs to be converted. It would have to be specifically designed for Hornresp's output.
Sounds like you need to go find the converter and then create an Excel macro to massage the HR CSV output to work with the converter.

Quote:
Originally Posted by DrDyna View Post
I wish I had the programming expertise to make a conversion plugin for Sketchup that could handle a hornresp csv/txt.

Here it is...
Google SketchUp Ruby API - Google Code
Sketchup Ruby API Documentation - Google SketchUp Ruby API - Google Code
__________________
Regards,
Dan
  Reply With Quote
Old 25th May 2011, 04:25 PM   #1918
DrDyna is offline DrDyna  United States
diyAudio Member
 
DrDyna's Avatar
 
Join Date: May 2007
Blog Entries: 3
Quote:
Originally Posted by revintage View Post
Think we see different use for the conversion. I see it only for straight mid- and HF-horns that later should be cut with a router.
Well, I'm imagining something that can be used for anything that Hornresp is capable of producing.
  Reply With Quote
Old 25th May 2011, 04:30 PM   #1919
DrDyna is offline DrDyna  United States
diyAudio Member
 
DrDyna's Avatar
 
Join Date: May 2007
Blog Entries: 3
Quote:
Originally Posted by NEO Dan View Post
Sounds like you need to go find the converter and then create an Excel macro to massage the HR CSV output to work with the converter.



Here it is...
Google SketchUp Ruby API - Google Code
Sketchup Ruby API Documentation - Google SketchUp Ruby API - Google Code
I was looking at this earlier. I suppose it's time to watch the video.
  Reply With Quote
Old 25th May 2011, 04:34 PM   #1920
Jmmlc is offline Jmmlc  France
R.I.P.
 
Join Date: Oct 2005
Hello David,

Could you add to Hornresp some controls for the coffee machine?

;-)

Best regards from Paris, France

Jean-Michel Le Cléac'h


Quote:
Originally Posted by David McBean View Post
Hi Lars,

It removes the need to manually copy and paste the data into the spreadsheet.

Simply double-click on the *.csv filename in the Hornresp\Export folder to automatically open the file in Excel.

Kind regards,

David
  Reply With Quote

Reply


Hide this!Advertise here!
Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hornresp Class FlipC Subwoofers 8 3rd November 2008 06:23 PM
Some questions about hornresp brsanko Full Range 4 18th October 2008 09:36 PM
Hornresp help / JX150 316a Multi-Way 0 11th February 2004 03:56 PM


New To Site? Need Help?

All times are GMT. The time now is 04:50 PM.


vBulletin Optimisation provided by vB Optimise (Pro) - vBulletin Mods & Addons Copyright © 2014 DragonByte Technologies Ltd.
Copyright ©1999-2014 diyAudio

Content Relevant URLs by vBSEO 3.3.2