Master Index of all Visual Communication Products
ahutton@ahutton.com
(860)632-2026

Variable Data - How to enter in Excell

 * Back To *

Home VD Pricing

There needs to be one ROW for every Board
There needs to be one column for each data item

There needs to be one ROW for every Board
There needs to be one column for each data item
 This format below is wrong in fact we PUT ICU on all the boards!
see spreedsheet example at bottom for correct format
Room # Phone #   Room #   Phone #
ICU   ICU   SNU   SNU
214   562-3214   301   562-3301
215   562-3215   302   562-3302
216   562-3216   303   562-3303
217   562-3217   304   562-3304  
218   562-3218   305   562-3305
219   562-3219   306   562-3306
220   562-3220   307   562-3307
221   562-3221   308   562-3308
222   562-3222   309   562-3309
           
ACU   ACU   Different Design (wording)
223   562-3223   OB   OB
224   562-3224   205   562-3205
225   562-3225   206   562-3206
226   562-3226   207   562-3207
227   562-3227   208   562-3208
228   562-3228   209   562-3209
229   562-3229   210   562-3210
230   562-3230   211   562-3211
231   562-3231   212   562-3212
232   562-3232        
233   562-3233        

This format below is correct
note  each row tells all the data for a board

ICU 214 562-3214
ICU 215 562-3215
ICU 216 562-3216
ICU 217 562-3217
ICU 218 562-3218
ICU 219 562-3219
ICU 220 562-3220
ICU 221 562-3221
ICU 222 562-3222
SNU 301 562-3301
SNU 302 562-3302
SNU 303 562-3303
SNU 304 562-3304
SNU 305 562-3305
SNU 306 562-3306
SNU 307 562-3307
SNU 308 562-3308
SNU 309 562-3309
ACU 223 562-3223
ACU 224 562-3224
ACU 225 562-3225
ACU 226 562-3226
ACU 227 562-3227
ACU 228 562-3228
ACU 229 562-3229
ACU 230 562-3230
ACU 231 562-3231
ACU 232 562-3232
ACU 233 562-3233
ACU 234 562-3234
ACU 235 562-3235
ACU 236 562-3236
ACU 237 562-3237
ACU 238 562-3238
ACU 239 562-3239

Also if you want it to be

(860) 632-2026
do not give me 860-632-2026
you get what is put in spreedsheet
we only give it a font, size and color

 

 

This is wrong and had to

ROOM NUMBER BED PHONE NUMBER
126 A 933-9126
  B 933-9926
127 A 933-9127
  B 933-9927
128 A 933-9128
  B 933-9928
129 A 933-9129
  B 933-9929
130 A 933-9130
  B 933-9930

 be corrected to layout below

is correct below

126A   933-9126
126B   933-9926
127A   933-9127
127B   933-9927
128A   933-9128
128B   933-9928
129A   933-9129
129B   933-9929

 

About Our Boards and US!
Indoff CT is a master at producing quality custom printed dry erase boards. 

Remember Pricing on web is List and does not include resale and volume discounts   2/01/07