p01 Kansas City Southern
Skip to main content

Recent Topics

xx

clip

xx
Ink Rotation?
by AaronH
Today at 01:36:24 PM

xx
New Windows 10 PC
by Joe
Today at 08:23:07 AM

clip
Rename PDF from text in PDF
by swampymarsh
January 15, 2019, 08:08:08 PM

question
Best way to flatten a pdf ?
by mc hristel
January 15, 2019, 05:57:40 PM

xx
HAPPY NEW YEARS TO ALL!
by DPSprint
January 13, 2019, 02:47:00 PM

clip

clip

xx
Embedding fonts, Indesign export
by scottrsimons
January 09, 2019, 02:51:42 PM

xx
Prepress/Sheetfed for Dummies
by born2print
January 09, 2019, 02:35:47 PM

Topic: GrepHeatStyle (Read 228 times) previous topic - next topic

GrepHeatStyle

At Wits end and wanting advice on how to fix. (easily please).

So I've just spent the last 5+ months working on a massive project. I mean massive as this is a Heatmap designed to show us visually where things happen in our State. I have drawn the map in Illy and imported and linked to Layers and Variable Data so i can view by Name/Postcode (zip)/ distribution areas yada yada yada. see attachments.

All was going great until they now I've been informed the client wants a recap of the last few months which pushes the numbers past my range of 1% to 100% of a colour. You will see by looking at the numbers represented in the Heatmap (Let's call them beers consumed for that area) that it works perfectly except for once it goes above 100. If above 100 it only displays the first two digits for the colour %. (circled in yellow). The GrepHeatStyle script will only allow for 100 (I believe).

Looking for advice on how to display the numbers above 100 in total to be a different colour or background pattern?
I know I could change them manually but there are 420+ area variables so far and I nowhere near finished.

Any advice from you scripting pros will be greatly appreciated.

Cheers  :drunk3:





 
You can’t polish a Turd, but you can roll it in glitter!

Re: GrepHeatStyle

Reply #1
Yeah I think it can only do 100, ie...1% to 100%. Can your values display in a percentage instead of number of beers. For example if the max number of beers is 200 than one beer would be .5 (%), 2 beers would display as 1 (%) and 200 beers would display as 100 (%). Probably not a good solution but it is all I've got.
Mac OS 10.12 Sierra | Prinergy 7.5 | Adobe Creative Cloud 2017 | Two Luscher XPose 160 CTP units

Prepress: One who does precision guess work based on unreliable data provided by those of questionable knowledge.

Re: GrepHeatStyle

Reply #2
wow! wish I knew how to help, that looks fascinating.
I think DCurry knows about GREPS
You can't get those to a random color obviously to select similar and recolor

Re: GrepHeatStyle

Reply #3
Thanks for the props, Tracy, but I really know very little about GREPs. I've used them a couple times to format some price tags.

The only idea I can think of to do this is instead of using the numbers to create a screened percentage, could you instead create individual color swatches and name the swatch the number? For instance, you would have a color called 1, another called 2, etc. For the swatches 1-100 you would make it its corresponding screen percentage, then when it goes over 100 you'd have to figure out a different color and make it whatever you want.

Of course, with 420 swatches that would mean lot of work, but I think you might be in for a lot of work no matter how you slice it.

Also, I have no clue how you'd implement my idea, but you've gotten pretty far with the way you have it now so I suspect you can get there if you like the idea.
Prinergy 8.1.1.286 • Preps 8 (Not a fan) • SmartStream Designer

Build a man a fire, and he'll be warm for a night. But set a man on fire, and he'll be warm for the rest of his life!

Re: GrepHeatStyle

Reply #4
Might want to float it by the IndesignSecrets folks, there's a few GREP Wizards over there. I think that part of their Forum is open to non-subscribers too.

Wish I'd learned that aspect of InDy, just never seems to be enough time or brain power left in a day.
A little diddie ‘bout black 'n cyan...two reflective colors doin’ the best they can.

Re: GrepHeatStyle

Reply #5
I know some regex/grep – however this sounds more like an Illustrator script?

Hard to comment without knowing more of the technical details.

Re: GrepHeatStyle

Reply #6
Cheers for the input guys n gals. I eventually just went back and modified the GREP script (100 times) so it now sees the colours in groups of 2%.

I will eventually re-modify the script later this week so I have ranges of 5%. So in theory I can go to 500.


Time for a  :drunk3:
You can’t polish a Turd, but you can roll it in glitter!

 

Re: GrepHeatStyle

Reply #7
Good job Diddler!