Quote from: Tracy on Today at 10:12:04 AMThese particular data files were not for mailing
They were for cards, badges, and envelopes
the customer redid the data with shorter titles for the badges.
the didn't like the small font they ended up with. 

I had a training course to take online and they showed this and I thought of you, Tracy

Hard to put 10lbs. of shit in a 5lb. bag.

At my last job, we had an in-house guy that did all the list fixing/sorting using Satori. If there was any kind of issue, we kicked it back to him and he took care of it.

Previously, we worked with a mail house. That's what I recommend you do. You send them the file and they sort it/correct it and send it back to you. Usually as long as they do the folding/stuffing/mailing, they discount the cost of list work. If you do that in-house, then your boss needs to get you the software and training.

If it's VDP only with no mailing/sorting (this is based on mail permits and if you use a permit it has to be done and bundled a certain way before it goes to the post office), then the salespeople need to be retrained to sell the additional work it takes to fix the lists.

Since we're posting rules, if you ever adopt or are gifted a Mogwai,

Don't get it wet

Don't expose it to bright lights; sunlight will kill them

Never, ever feed them after midnight

Those I can see, and now the original screenshots are showing up in the previous posting too.

I tested out my Excel template and I had actually done what you posted previously, and while it does blank out the cell (It shows empty vs the 0.00 it normally displays), if you go back and try to type a letter my little error window pops up, so it works. I *think* this is all I need for now. All my drop downs work, all my cells are protected from editing, and all the math adds up. Thanks!

Here's what I see:

OK... I figured out the number part of it through Data Validation, so now I just need to protect the cell, so they can enter a value, but not delete the formatting... it still removes it if you hit backspace or delete.

Well, I have columns for prepress, wide format, scanning, press time and bindery. The formula in the final cell is the total hours. That one is locked and cannot be changed. In the other columns, I want the operator to enter their time in a XX.XX formatting. Right now if someone enters an "f" the cell accepts that (although in the total column I get an ERR, which is what should happen), and it displays as, "f." If you hit delete, it erases the formatting and formula.

I want to force that cell to display an ERR if anything other than a number is entered. And I want it to convert the number to a decimal (if they enter 5, I want it to display 5.00). I have 90% of it formatted correctly - just need to make it so you can only enter a number and can't delete the formatting. I have it currently defined as a number, but it's not working (see screenshots), and if you delete out the f, it blanks out the formatting.

Well, I don't want a cell to be uneditable, but I do. I have a formula in the cell that does a math problem. I want the user to be forced to enter a number (not a letter - I want it to return an error), but not be able to edit or delete the math formula.

I have a spreadsheet I'm creating in Excel to track jobs through the shop. In it I have some formulas to math for me. Problem is, it's really easy to accidentally delete or erase the formula and screw up the cell, so is there a way (without locking or requiring a password) to protect the formula inside that cell so it doesn't lose it's format and can still be typed in to? I know how to lock it, but then you can't add any new information, and the only other trick I know requires a password every time you want to add new information. Also, without the use of a 3rd party plug-in, is there a way to make a cell have a date finder calendar?

So I just want to clarify:

J imposes a file in the QI plugin in Acrobat. J saves it to your server directory. The Digital Press Operator opens his RIP and navigates in the software to J's file and clicks, import, and it's right side up, peachy and smelling like a rose.

You impose the same file the same way in the QI plugin in Acrobat. You save it to your server directory. The Digital Press Operator opens his RIP and navigates in the software to your file and clicks, import, and it's upside down?

Have you seen any demogorgons or made an offering to Vecna?

Is anyone there from Australia? Everything is all upside down and bass-ackwards down there.

Quote from: Tracy on April 18, 2024, 10:47:48 AMYeah that happens to me too when I Print to the que an 18x12
when dragged into the que it's correct somehow the Printing to que 12x18 is fine.
I think Digi was referring to that
But I'm not working with an indigo

Exactly.

Do you drag-and-drop PDFs into the queue or do you Cmd-P Print them into the queue?

On the latest build of Illustrator, I am trying to create a new document and I set the bleed to 0 all around, and when it creates the new page, it's adding 1/8" of bleed to the top. You can't set the document defaults like you can in InDesign, so how do I fix? It's not a deal-breaker, but it really is an annoyance.