Avatar

Lost password?
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

sp_Feed Topic RSS sp_TopicIcon
Cutting list to Excell
October 4, 2017
6:41 am
Avatar
Ness

Forum Posts: 1586
Member Since:
October 4, 2012
Thanked 457 times in 1586 posts
Reputation: 19361
sp_UserOfflineSmall Offline

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
October 4, 2017
3:47 am
Avatar
Thusitha Karunatilake

Forum Posts: 52
Member Since:
July 13, 2017
Thanked 0 times in 52 posts
Reputation: 261
sp_UserOfflineSmall Offline

Dear Ness,

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

Thank you.

Thusitha.

October 3, 2017
12:24 pm
Avatar
Ness

Forum Posts: 1586
Member Since:
October 4, 2012
Thanked 457 times in 1586 posts
Reputation: 19361
sp_UserOfflineSmall Offline

HI Thusitha,

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

best regards,

Ness

October 3, 2017
12:15 pm
Avatar
Thusitha Karunatilake

Forum Posts: 52
Member Since:
July 13, 2017
Thanked 0 times in 52 posts
Reputation: 261
sp_UserOfflineSmall Offline

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

October 3, 2017
11:37 am
Avatar
Stefan

Forum Posts: 585
Member Since:
November 8, 2013
Thanked 115 times in 585 posts
Reputation: 5805
sp_UserOfflineSmall Offline

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

October 3, 2017
7:18 am
Avatar
Thusitha Karunatilake

Forum Posts: 52
Member Since:
July 13, 2017
Thanked 0 times in 52 posts
Reputation: 261
sp_UserOfflineSmall Offline

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: 58

Currently Online: brian Swain, Rafal Meckovski
14 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

terry: 253

mark nichols: 119

jimbouk: 105

Christopher Paré: 97

Jack Travis: 66

Peter Brown: 62

Rafal Meckovski: 57

Duayne Naugle: 56

Thusitha Karunatilake: 52

Antony S Brighton: 47

Member Stats:

Guest Posters: 2

Members: 82967

Moderators: 4

Admins: 3

Forum Stats:

Groups: 2

Forums: 8

Topics: 881

Posts: 5296

Newest Members:

Massimiliano Fanni, Nicki Virina, David Coles, Hermann Coetzee, Adithya Pradeep, Grzegorz Dumała, jay sharma, Clint Goldie, Dale Bucy, Todor Milchev

Moderators: michel melon: 231, D-Alexandre: 85, admin: 0, urbanelement: 0

Administrators: Ness: 1586, Stefan: 585, Carole Bosy: 16