Spreadsheets for Variable Data i.e Room numbers, Phone numbers etc.

Master Index of all Visual Communication Products

Indoff    - offices nationwide
860-632-2026
860-632-2028 Fax
ahutton@ahutton.com

 

Back to  Variable Data

How to put data on board

Hoe to layout SpreedSheet

  • Rules for Data
     

  • All Data for each board is to be in one row

  • Entry in cell to be just like you want it on board.
    i.e.  if you can do(860)-632-2026 or 860-632-2026 or
    (860) 632-2026  however you put it in a cell is how we will print it on your board

  • Each column is for a different item. i.e a column will have the room number in it for example

  • font style and size will be put in by Indoff to match what we have on layout

  • any questions call Al or Jen

  done Correctly      
  MICU style boards   ------       
  UNIT ROOM PHONE NUMBER Respiratoru Therapy box
Font==> TNR 36-italic bold blue TNR 72 B TNR 72 B TNR 26 Bold Black
    left justified     left justified
1 NEURO INTENSIVE CARE 201 303-629-6700 Respiratory Therapist:
2 NEURO INTENSIVE CARE 202 303-629-6700 Respiratory Therapist:
3 NEURO INTENSIVE CARE 203 303-629-6700 Respiratory Therapist:
4 NEURO INTENSIVE CARE 204 303-629-6700 Respiratory Therapist:
5 NEURO INTENSIVE CARE 205 303-629-6700 Respiratory Therapist:
6 NEURO INTENSIVE CARE 206 303-629-6700 Respiratory Therapist:
7 NEURO INTENSIVE CARE 207 303-629-6700 Respiratory Therapist:
8 NEURO INTENSIVE CARE 208 303-629-6700 Respiratory Therapist:
9 NEURO INTENSIVE CARE 209 303-629-6700 Respiratory Therapist:
10 NEURO INTENSIVE CARE 210 303-629-6700 Respiratory Therapist:
11 NEURO INTENSIVE CARE 211 303-629-6700 Respiratory Therapist:
12 NEURO INTENSIVE CARE 212 303-629-6700 Respiratory Therapist:
13 TRAUMA INTENSIVE CARE 253 303-629-4355 Respiratory Therapist:

 

do not leave spaces in rows to make it neater or help your layout

we have to feed columns into a computer so all the rows must be continuous

 

there can be extra columns - it just needs to be clear what columns get printed

Variable data need to be typed on spreadsheet exactly how you want it to appear on board.  For example if you want (860)632-2026 you need to type it this exact way not 860-632-2026 because we will print what is on the spreadsheet