excel hell

[pspdfppdfxhd]

today i say, fark powerpoint.

get a job from a hotel chain, not mentioning which one but one of the founders decendents has the first name of the capital of france.

so first they send their graphics standards manual in.... very professional. outlines pms and cmyk numbers that must be followed. in comes the file ... 4/4 flyer done in powerpoint, no bleeds, rgb crap.

after arguing with the boss.... and spending 3 hours basically rebuilding the file, its approved! quantity 100, delivery in 2 days.

cost to bill about 80 dollars.

they are happy with the work we did. i guess so, who else would be  stupid enough to do it for them. 

[born2print]

That's alright pspdfppdfx, at least now they think their crappy files "work just fine"
THANKS!  :laugh:

[Joe]

That's alright pspdfppdfx, at least now they think their crappy files "work just fine"
THANKS!  :laugh:

Yep...and they will tell the next printer, "My last printer didn't have any problem with it".

[DigiCorn]

have the customer print it out how they want it to look, and then just scan it

[pspdfppdfxhd]

That's alright pspdfppdfx, at least now they think their crappy files "work just fine"
THANKS!  :laugh:

Yeah, well, despite ardent protests before hand, the guy who signs the paycheques told me to do it.


 

[born2print]

That's alright pspdfppdfx, at least now they think their crappy files "work just fine"
THANKS!  :laugh:

Yeah, well, despite ardent protests before hand, the guy who signs the paycheques told me to do it.


 

Oh yeah, that's understood, just like 
 

[Designia(o_O)]

Did you ever figure out how to insert alternating blank rows in Excel? Here's a link.
http://www.pcmag.com/article2/0,2817,1785247,00.asp

[pspdfppdfxhd]

Didn't actually need to do this trick but thanks anyways.

You are Excel-erating my knowledge of Excel! Might need it one day.
 

[Designia(o_O)]

Yea, that one's handy

[Tracy]

For Monday:
I have an excel file that has what looks like glyphs as separators
can anyone tell me how to convert this over?
I tried saving as txt and open in excel and using fixed widths- no worky

[Joe]

For Monday:
I have an excel file that has what looks like glyphs as separators
can anyone tell me how to convert this over?
I tried saving as txt and open in excel and using fixed widths- no worky

Can you send me the excel file to take a look at?

[Tracy]

linked it to you 
I guess if I can figure out how to type tab I can find replace
but I can't get the tab into replace

[Joe]

Tracy,

It appears they used the | key to place between the fields. (Vertical bar key right above the return key on the Mac keyboard.) I was able to do a search & replace in Open Office calc searching for regular expressions as show here:

[attachimg=1]

Then I saved a Tab delimited text file (.csv) and also saved an open office calc file (.odt). They are attached. See if any of that helps. If you need another type of file or if for some reason these won't work let me know and I'll try something else.

[Tracy]

Thanks Joe!
The guy at the mail house showed me how you can
do it by going to text to columns and selecting other
and typing the character, it was above the slash key
above the Return

I think your way is easier!  :wink:

[Tracy]

   I just saw that you did it in open office :laugh: