Cutting list to Excell|Forum|WOOD DESIGNER

Avatar
Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
sp_Feed sp_TopicIcon
Cutting list to Excell
Avatar
Ness
Forum Posts: 1939
Subscriber Since:
October 4, 2012
sp_UserOfflineSmall Offline
6
October 4, 2017 - 6:41 am
sp_Permalink sp_Print

Hi Thusitha,

The problem is that when importing you text file Excel interprets the thickness expressed as a fraction like “3/4” as a date, so inserts  03-april.

Depending on the Excel version you are using, one way to avoid this, when importing, you can set the column type to “text” :

import-010.pngImage Enlarger

Note that if you need to calculate the column you’ll have to change the formatting back to fractions.

I’m not an Excel expert so there might be a better way to do this, so you might want to search the internet for another solution that keeps the value  as a fraction.

hope this is helpful,

Ness

sp_PlupAttachments Attachments
Avatar
Guest
5
October 4, 2017 - 3:47 am
sp_Permalink sp_Print

Dear Ness,

Please find the attached files, let us know the solution.

Thank you.

Thusitha.

Avatar
Ness
Forum Posts: 1939
Subscriber Since:
October 4, 2012
sp_UserOfflineSmall Offline
4
October 3, 2017 - 12:24 pm
sp_Permalink sp_Print

HI Thusitha,

Please post the Polyboard file and the exported text file so we can compare.

best regards,

Ness

Avatar
Guest
3
October 3, 2017 - 12:15 pm
sp_Permalink sp_Print

Dear Stefan,

We only found from you, the same attachment we had uploaded for your perusal. Kindly check the mail and send us the solution, and a video as well, that would be much helpful.

Thusitha

Avatar
Stefan

Forum Posts: 924
Subscriber Since:
November 8, 2013
sp_UserOfflineSmall Offline
2
October 3, 2017 - 11:37 am
sp_Permalink sp_Print

Here’s the file uploaded. These files are now allowed on the forum. If you have a problem with the file types, one solution is to upload them inside a zip file. Best regards, Stefan

Avatar
Guest
1
October 3, 2017 - 7:18 am
sp_Permalink sp_Print

cutting-list-excel.JPGImage Enlarger

Dear Ness,

How are you?

We checked and followed the video you sent us on transferring cutting lists to Excell sheet. Thank you for that.

The attached shows that we don’t get the thickness correct. Please advice us the way to get it. If you could send a video for that as well, we would much appreciate that.

We will mail you excell document which is not possible to attach here.

Thank you.

Thusitha.

sp_PlupAttachments Attachments
Forum Timezone: Europe/London
Most Users Ever Online: 365
Currently Online: Brian Serrao
Guest(s) 17
Top Posters:
Ness: 1939
Tom Cleaver: 162
mark nichols: 160
Conor Devoy: 145
brendan kavanagh: 141
Duayne Naugle: 130
Blake Simpson: 104
Zaheer Abbas: 100
Patrick Maylor: 64
Robert Coxhead: 63
Newest Members:
alkisgr
Johannes Hellesøy
charalampous.m@outlook.com
Jarek Nurkowski
p33t
Zallo
Cormack Fallon
wimpie33
Rune Fagerli
IAN GILLIGAN
Forum Stats:
Groups: 2
Forums: 7
Topics: 2200
Posts: 11941

 

Member Stats:
Guest Posters: 4
Members: 316
Moderators: 0
Admins: 11
Administrators: Stefan, Michel, Carole, Alex, admin, Laly, ipatrick, Crystal, Fatima, Darren, Isaac