I'll be over around 7 tonight.

Here's a slighty modified Excel/Open Office spreadsheet file I used to generate numbers for a numbering job, courtesy of the mighty Youston. For this example it's for 5,000 tickets running 10-up and we wanted a cut & stack setup for bindery, so I have 10 columns with 500 numbers in each column. The cells in column 1 are filled with actual numbers, the other 9 columns are formulas working off the values in column 1. I also selected all the cells and applied formatting of 4 leading zeros to everything, so 1 will print as 0001. Saved as CSV, check "Edit filter settings" and make sure "Save cell content as shown" is checked so the CSV contains all the numbers as you see them, and not the formulas.

You will need a tiny bit of spreadsheet knowledge to change this to suit your job (eg: different qty, different n-up)

This also ties in with another recent thread of mine where I created a non-number database for a multi-up Data Merge project that will cut & stack in bindery.
https://www.b4print.com/index.php?topic=4966.0

Quote from: gnubler on July 28, 2010, 11:22:07 AMHere's a slighty modified Excel/Open Office spreadsheet file I used to generate numbers for a numbering job, courtesy of the mighty Youston. For this example it's for 5,000 tickets running 10-up and we wanted a cut & stack setup for bindery, so I have 10 columns with 500 numbers in each column. The cells in column 1 are filled with actual numbers, the other 9 columns are formulas working off the values in column 1. I also selected all the cells and applied formatting of 4 leading zeros to everything, so 1 will print as 0001. Saved as CSV, check "Edit filter settings" and make sure "Save cell content as shown" is checked so the CSV contains all the numbers as you see them, and not the formulas.

You will need a tiny bit of spreadsheet knowledge to change this to suit your job (eg: different qty, different n-up)

This also ties in with another recent thread of mine where I created a non-number database for a multi-up Data Merge project that will cut & stack in bindery.
https://www.b4print.com/index.php?topic=4966.0

Well done, grasshopper. Perhaps a promotion to Mantis is in order.

See how easy it was?  :grin:

Quote from: youston on July 28, 2010, 11:38:27 AMPerhaps a promotion to Mantis is in order.

I will accept. Two evenings ago I spotted a baby mantis in my garden. Do you think it was a good sign?

My favorite insect of all time. If I find one, I name it Eugene and coddle it until it's death. The bastards don't live very long.

I do like them as well. Don't the females murder & consume their mates? Makes sense.

I also saw a black widow sitting near an egg pouch a few days ago. I don't like them too much, but I don't believe in just killing spiders on sight.