cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 
Collaborate forum

data transfer from calculation lists to word/excel/access

Anonymous
Not applicable
if anyone finds time consumeing transfering calculation lists from archicad to word/excel/access or to get it organized the fastest way of doing it is
to copy data from list and paste to word document. then replace spacebars
(press one time spacebar in 'find what' window) with nothing (dont touch 'replace with' at all) and replace 'I' with tab(one or more and it has to be copied from word doc. and pasted to 'replace with' ). than easyli it can be copied to table, excel or acces.
hope it will helpful.
1 ACCEPTED SOLUTION
2 REPLIES 2

Rick Thompson
Advocate
I have found it very fast. easy and smooth to pre define an Excel workwook with all the appropriate sheets titles, cover sheet, fonts etc. and save the AC list as tabbed text... then import into the appropriate sheet and nothing else is required but saving as a PDF. An example can be downloaded at http://www.thompsonplans.com/plans/pages/details/1313A where it says "sample".
Rick Thompson

Mac Ventura AC 25

http://www.thompsonplans.com
iMac 3.4GHz Quad i5 24 GB w/SSD Monterey

Solution
Djordje
Mentor
Saving any Calc text output as text, and then opening in Excel specifying | as separator does even better job IMHO. The only replacement you have to do is insert formulas in the totals fileds.
Djordje



ArchiCAD since 4.55 ... 1995
HP Omen

Start a new conversation!

Still looking?

Browse more topics

Back to forum

See latest solutions

Accepted solutions

Start a new discussion!