{"text_format":"3","workbook":"xls","n_sheets":11,"sheets":["About...","Ritz Template","Setup","Data Tables","Message Info","Content Entry Form","Export Content","Instructions","Scratch","Content BackUp Form","Content Review"],"not_rendered":{"images":5,"macros":1,"external_links":3,"defined_names":22},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"About...","index":0,"n_rows":18,"n_cols":4,"rows_kept":18,"merged":[[1,1,7,48],[9,1,9,48],[12,2,12,47],[13,3,13,47],[14,3,14,47],[15,3,15,47]],"flags":["formulas_cached_only"]}
[]
[null,"Content Upload Form\nVersion 2.0\nSeptember 2001\n© 2001, @Once.com"]
{"$rows_empty":7}
[null,"This workbook is used to facilitate the acquisition of product data from @Once.com clients for subsequent upload into the @Once database. \nThe intended use is as follows:"]
[]
[]
[null,null,"Rules, Restrictions, & Guidelines"]
[null,null," 1)","If you find that you need more space to submit content, you may insert ROWS (not COLUMNS) into the CUF."]
[null,null," 2)","Do NOT delete COLUMNS from the CUF.  If there are ROWS which you're not using, then you may delete them as needed."]
[null,null," 3)","Columns and row dimensions (width x height) CAN be modified as needed."]
[null,null," 4)","Please refer to the Template Specifications for limitations on characters, words, and image sizes within the various sections of your Template."]
[null,null," 5)","Do not submit content within cells which are shaded.  All valid content entry cells should appear white."]

{"sheet":"Ritz Template","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}

{"sheet":"Setup","index":2,"n_rows":50,"n_cols":6,"rows_kept":50,"hidden":true,"flags":["formulas_cached_only"]}
["Data Column Name","Use","Friendly Name"]
["DIVISION","EXTERNAL","NEWSLETTER"]
["DEPARTMENT","EXTERNAL","DEPARTMENT"]
["NAME","EXTERNAL","REPORTING NAME"]
["MISC_STRING1","EXTERNAL","LINE OF BUSINESS"]
["CATEGORY","EXTERNAL","TEMPLATE SECTION"]
["SUBCATEGORY","EXTERNAL",null,null,"sa"]
["DESCRIPTION2","EXTERNAL","SKU/CAT#"]
["SEC_INFERRED_INTEREST","EXTERNAL","LINK NAME"]
["MISC_STRING2","EXTERNAL","C-LINK"]
["HLINK","EXTERNAL","URL"]
["DESCRIPTION1","EXTERNAL","TITLE",null,null," "]
["MISC_NUM1","EXTERNAL","#"]
["COGS","EXTERNAL"]
["OWNER","EXTERNAL"]
["LANGUAGE_CODE","EXTERNAL"]
["HAS_PRODUCT_LINKS","EXTERNAL"]
["TEXT_AREA1","EXTERNAL","HTML COPY"]
["QUANTITY","EXTERNAL","#"]
["TEXT_AREA3","EXTERNAL","AOL COPY"]
["PRIORITY1","EXTERNAL","#"]
["TEXT_AREA2","EXTERNAL","TEXT COPY"]
["PRIORITY2","EXTERNAL","#"]
["LIST_PRICE","EXTERNAL","PRICE"]
["SALE_PRICE","EXTERNAL"]
["PROMOTION_CODE","EXTERNAL"]
["POSITION_CODE","INTERNAL"]
["FULL_IMAGE1","EXTERNAL","IMAGE FILENAME"]
["DESCRIPTION3","EXTERNAL","I-LINK"]
["FULL_IMAGE_WIDTH1","EXTERNAL"]
["FULL_IMAGE_HEIGHT1","EXTERNAL"]
["FULL_IMAGE2","EXTERNAL"]
["FULL_IMAGE_WIDTH2","EXTERNAL"]
["FULL_IMAGE_HEIGHT2","EXTERNAL"]
["FULL_IMAGE3","EXTERNAL"]
["FULL_IMAGE_WIDTH3","EXTERNAL"]
["FULL_IMAGE_HEIGHT3","EXTERNAL"]
["AUDIO_FILE","EXTERNAL"]
["VIDEO_FILE","EXTERNAL"]
["INFERRED_INTEREST","EXTERNAL","PRIMARY INFERRED"]
["MISC_NUM2","EXTERNAL"]
["MISC_DATE1","EXTERNAL"]
["MISC_DATE2","EXTERNAL"]
["CREATED_BY","EXTERNAL"]
["CREATED_DATETIME","EXTERNAL"]
["MODIFIED_BY","EXTERNAL"]
["MODIFY_DATETIME","EXTERNAL"]
["IS_VERIFIED","EXTERNAL"]
["VERIFIED_BY","EXTERNAL"]
["VERIFIED_DATETIME","EXTERNAL"]

{"sheet":"Data Tables","index":3,"n_rows":71,"n_cols":14,"rows_kept":71,"hidden":true,"flags":["formulas_cached_only"]}
[]
[null,"LINE OF BUSINESS CODES:",null,"PRODUCT DETAIL LINKS",null,"MENU & CATEGORY LINKS",null,"VLOOKUP TABLE (Menu Titles)"]
[null,"< Select LOB >"]
[null,"BOATERS_WORLD","NLB",{"$error":"#N/A"},null,{"$error":"#N/A"},null,"GPS CHARTPLOTTERS","FISH FINDERS","VHF RADIOS","RADAR AUTOPILOTS","ROD/REEL COMBOS"]
[null,"CAMERA_WORLD","NLC",{"$error":"#N/A"},null,{"$error":"#N/A"},null,"DIGITAL CAMERAS","CAMCORDERS","35MM POINT & SHOOT","SLR CAMERAS","MEMORY"]
[null,"OUTER_BANKS_OUTFITTERS","NLO",{"$error":"#N/A"},null,{"$error":"#N/A"},null,"GPS CHARTPLOTTERS","FISH FINDERS","VHF RADIOS","RADAR AUTOPILOTS","ROD/REEL COMBOS"]
[null,"PHOTO_ALLEY","NLP",{"$error":"#N/A"},null,{"$error":"#N/A"},null,"35MM POINT & SHOOT","DIGITAL CAMERAS","APS POINT & SHOOT","SLR CAMERAS"]
[null,"RITZ_CAMERA","NLR",{"$error":"#N/A"},null,{"$error":"#N/A"},null,"DIGITAL","VIDEO","35MM COMPACT","35MM SLR","PRO","PRINTERS","MEMORY"]
[null,"RITZ_ELECTRONICS","NLE",{"$error":"#N/A"},null,{"$error":"#N/A"},null,"TV, DVD, & VIDEO","PHONES","GAME SUPPLIES","SPEAKERS","HOME A/V","CAR PRODUCTS"]
[null,"WOLF_CAMERA","NLW",{"$error":"#N/A"},null,{"$error":"#N/A"},null,"DIGITAL","VIDEO","35MM COMPACT","35MM SLR","PRO","PRINTERS","MEMORY"]
[null,"MONTH CODES:",null,"VLOOKUP TABLE (months sorted ascending)",null,"VLOOKUP TABLE (Category ID's)",null,"Coremetrics Values"]
[null,"<Select Month>",{"$nulls":3},"35MM COMPACT",1005,"35mm_compact"]
[null,"JANUARY","01","APRIL","04","35MM POINT & SHOOT",1005,"35mm_point_&_shoot"]
[null,"FEBRUARY","02","AUGUST","08","35MM SLR",1006,"35mm_slr"]
[null,"MARCH","03","DECEMBER","12","APS POINT & SHOOT",1007,"aps_point_&_shoot"]
[null,"APRIL","04","FEBRUARY","02","CAMCORDERS",1008,"camcorders"]
[null,"MAY","05","JANUARY","01","CAR PRODUCTS",7954343,"car_products"]
[null,"JUNE","06","JULY","07","DIGITAL",1009,"digital"]
[null,"JULY","07","JUNE","06","DIGITAL CAMERAS",1009,"digital_cameras"]
[null,"AUGUST","08","MARCH","03","FISH FINDERS",249089,"fish_finders"]
[null,"SEPTEMBER","09","MAY","05","GAME SUPPLIES",7994183,"game_supplies"]
[null,"OCTOBER","10","NOVEMBER","11","GPS CHARTPLOTTERS",249090,"gps_chartplotters"]
[null,"NOVEMBER","11","OCTOBER","10","HOME A/V",7954162,"home_av"]
[null,"DECEMBER","12","SEPTEMBER","09","MEMORY",5739563,"memory"]
[null,"WEEK CODES:",{"$nulls":3},"PHONES",7954434,"phones"]
[null,"< Select Week >",{"$nulls":3},"PRINTERS",5739564,"printers"]
[null,"Week 1","A",null,null,"PRO",1010,"pro"]
[null,"Week 2","B",null,null,"RADAR AUTOPILOTS",249091,"radar_autopilots"]
[null,"Week 3","C",null,null,"ROD/REEL COMBOS",249096,"rod_reel_combos"]
[null,"Week 4","D",null,null,"SLR CAMERAS",1006,"slr_cameras"]
[null,"Line of Business",null,"Feature & Article Links","Banner Links","SPEAKERS",7953846,"speakers"]
[null,"< Select LOB >",{"$nulls":3},"TELESCOPES",1017,"telescopes"]
[null,"BOATERS_WORLD",null,{"$error":"#N/A"},{"$error":"#N/A"},"TV, DVD, & VIDEO",7991883,"tv_dvd_video"]
[null,"CAMERA_WORLD",null,{"$error":"#N/A"},{"$error":"#N/A"},"VHF RADIOS",249092,"vhf_radios"]
[null,"OUTER_BANKS_OUTFITTERS",null,{"$error":"#N/A"},{"$error":"#N/A"},"VIDEO",1008,"video"]
[null,"PHOTO_ALLEY",null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"RITZ_CAMERA",null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"RITZ_ELECTRONICS",null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"WOLF_CAMERA",null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Line of Business","Logo - Title","Logo & Tagline - HTML","Logo & Tagline - AOL/Text","Disclosure - HTML ","Disclosure - AOL/Text"]
[null,"< Select LOB >"]
[null,"BOATERS_WORLD","Boater's World","No Sales Tax & FREE Shipping*<br>\nOn Qualifying Orders  ","No Sales Tax & FREE Shipping*\nOn Qualifying Orders  ","*Free ground shipping & handling on all merchandise over $100 and under 20 lbs.","*Free ground shipping & handling on all merchandise over $100 and under 20 lbs."]
[null,"CAMERA_WORLD","Camera World","No Sales Tax*<br> \nFree Shipping Over $100.00 ","No Sales Tax* \nFree Shipping Over $100.00 ","* No Tax<br><br>You never pay sales tax! We are not required to collect sales and use tax on deliveries throughout the US, except where we have business locations and in those states we pay ALL sales taxes (California, Georgia, Kansas and Maryland). For customers in these states, our price includes all applicable taxes.<br>\n<br>\nTo satisfy Maryland consumer reporting rules, we will show sales tax and an amount equal to the sales tax will be discounted from our regular low price.  The order total will be the same as our regular low prices without tax.<br>\n<br>\nFree shipping & handling on all new merchandise orders over $100...excludes Auction, Clearance, Oversized and Heavier Items, and UPS service to AK & HI.  See website for complete details.<br>\n<br>","* No Tax\n\nYou never pay sales tax! We are not required \nto collect sales and use tax on deliveries throughout \nthe US, except where we have business locations \nand in those states we pay ALL sales taxes (California, \nGeorgia, Kansas and Maryland). For customers in \nthese states, our price includes all applicable taxes.\n\nTo satisfy Maryland consumer reporting rules, we will \nshow sales tax and an amount equal to the sales tax \nwill be discounted from our regular low price.The \norder total will be the same as our regular low prices \nwithout tax.\n\nFree shipping & handling on all new merchandise orders \nover $100...excludes Auction, Clearance, Oversized and \nHeavier Items, and UPS service to AK & HI.  See website \nfor complete details."]
[null,"OUTER_BANKS_OUTFITTERS","Outer Bank Outfitters","No Sales Tax & FREE Shipping*<br>\nOn Qualifying Orders  ","No Sales Tax & FREE Shipping*\nOn Qualifying Orders  ","*Free ground shipping & handling on all merchandise over $100 and under 20","*Free ground shipping & handling on all merchandise over $100 and under 20"]
[null,"PHOTO_ALLEY","Photo Alley","No Sales Tax*<br> \nFree Shipping Over $100.00 ","No Sales Tax* \nFree Shipping Over $100.00 ","* No Tax<br><br>You never pay sales tax! We are not required to collect sales and use tax on deliveries throughout the US, except where we have business locations and in those states we pay ALL sales taxes (California, Georgia, Kansas and Maryland). For customers in these states, our price includes all applicable taxes.<br>\n<br>\nTo satisfy Maryland consumer reporting rules, we will show sales tax and an amount equal to the sales tax will be discounted from our regular low price.  The order total will be the same as our regular low prices without tax.<br>\n<br>\nFree shipping & handling on all new merchandise orders over $100...excludes Auction, Clearance, Oversized and Heavier Items, and UPS service to AK & HI.  See website for complete details.<br>\n<br>","* No Tax\n\nYou never pay sales tax! We are not required \nto collect sales and use tax on deliveries throughout \nthe US, except where we have business locations \nand in those states we pay ALL sales taxes (California, \nGeorgia, Kansas and Maryland). For customers in \nthese states, our price includes all applicable taxes.\n\nTo satisfy Maryland consumer reporting rules, we will \nshow sales tax and an amount equal to the sales tax \nwill be discounted from our regular low price.The \norder total will be the same as our regular low prices \nwithout tax.\n\nFree shipping & handling on all new merchandise orders \nover $100...excludes Auction, Clearance, Oversized and \nHeavier Items, and UPS service to AK & HI.  See website \nfor complete details."]
[null,"RITZ_CAMERA","Ritz Camera","No Sales Tax*<br> \nFree Shipping Over $100.00 ","No Sales Tax* \nFree Shipping Over $100.00 ","* No Tax<br><br>You never pay sales tax! We are not required to collect sales and use tax on deliveries throughout the US, except where we have business locations and in those states we pay ALL sales taxes (California, Georgia, Kansas and Maryland). For customers in these states, our price includes all applicable taxes.<br>\n<br>\nTo satisfy Maryland consumer reporting rules, we will show sales tax and an amount equal to the sales tax will be discounted from our regular low price.  The order total will be the same as our regular low prices without tax.<br>\n<br>\nFree shipping & handling on all new merchandise orders over $100...excludes Auction, Clearance, Oversized and Heavier Items, and UPS service to AK & HI.  See website for complete details.<br>\n<br>","* No Tax\n\nYou never pay sales tax! We are not required \nto collect sales and use tax on deliveries throughout \nthe US, except where we have business locations \nand in those states we pay ALL sales taxes (California, \nGeorgia, Kansas and Maryland). For customers in \nthese states, our price includes all applicable taxes.\n\nTo satisfy Maryland consumer reporting rules, we will \nshow sales tax and an amount equal to the sales tax \nwill be discounted from our regular low price.The \norder total will be the same as our regular low prices \nwithout tax.\n\nFree shipping & handling on all new merchandise orders \nover $100...excludes Auction, Clearance, Oversized and \nHeavier Items, and UPS service to AK & HI.  See website \nfor complete details."]
[null,"RITZ_ELECTRONICS","Ritz Electronics","No Sales Tax*<br>100% Safe & Secure","No Sales Tax*\n100% Safe & Secure","* No Tax<br><br>You never pay sales tax! We are not required to collect sales and use tax on deliveries throughout the US, except where we have business locations and in those states we pay ALL sales taxes (California, Georgia, Kansas and Maryland). For customers in these states, our price includes all applicable taxes.<br>\n<br>\nTo satisfy Maryland consumer reporting rules, we will show sales tax and an amount equal to the sales tax will be discounted from our regular low price.  The order total will be the same as our regular low prices without tax.<br>\n<br>\nFree shipping & handling on all new merchandise orders over $100...excludes Auction, Clearance, Oversized and Heavier Items, and UPS service to AK & HI.  See website for complete details.<br>\n<br>","* No Tax\n\nYou never pay sales tax! We are not required \nto collect sales and use tax on deliveries throughout \nthe US, except where we have business locations \nand in those states we pay ALL sales taxes (California, \nGeorgia, Kansas and Maryland). For customers in \nthese states, our price includes all applicable taxes.\n\nTo satisfy Maryland consumer reporting rules, we will \nshow sales tax and an amount equal to the sales tax \nwill be discounted from our regular low price.The \norder total will be the same as our regular low prices \nwithout tax.\n\nFree shipping & handling on all new merchandise orders \nover $100...excludes Auction, Clearance, Oversized and \nHeavier Items, and UPS service to AK & HI.  See website \nfor complete details."]
[null,"WOLF_CAMERA","Wolf Camera","No Sales Tax*<br> \nFree Shipping Over $100.00 ","No Sales Tax* \nFree Shipping Over $100.00 ","* No Tax<br><br>You never pay sales tax! We are not required to collect sales and use tax on deliveries throughout the US, except where we have business locations and in those states we pay ALL sales taxes (California, Georgia, Kansas and Maryland). For customers in these states, our price includes all applicable taxes.<br>\n<br>\nTo satisfy Maryland consumer reporting rules, we will show sales tax and an amount equal to the sales tax will be discounted from our regular low price.  The order total will be the same as our regular low prices without tax.<br>\n<br>\nFree shipping & handling on all new merchandise orders over $100...excludes Auction, Clearance, Oversized and Heavier Items, and UPS service to AK & HI.  See website for complete details.<br>\n<br>","* No Tax\n\nYou never pay sales tax! We are not required \nto collect sales and use tax on deliveries throughout \nthe US, except where we have business locations \nand in those states we pay ALL sales taxes (California, \nGeorgia, Kansas and Maryland). For customers in \nthese states, our price includes all applicable taxes.\n\nTo satisfy Maryland consumer reporting rules, we will \nshow sales tax and an amount equal to the sales tax \nwill be discounted from our regular low price.The \norder total will be the same as our regular low prices \nwithout tax.\n\nFree shipping & handling on all new merchandise orders \nover $100...excludes Auction, Clearance, Oversized and \nHeavier Items, and UPS service to AK & HI.  See website \nfor complete details."]
[null,"Sections","CoreMetrics Values"]
[null,"*DISCLOSURE","disclosure"]
[null,"ARTICLE 1","article"]
[null,"ARTICLE 2","article"]
[null,"BANNER 1","banner"]
[null,"BANNER 2","banner"]
[null,"BANNER 3","banner"]
[null,"BANNER 4","banner"]
[null,"BANNER 5","banner"]
[null,"CATEGORY 1","header"]
[null,"CATEGORY 2","header"]
[null,"CATEGORY 3","header"]
[null,"CATEGORY 4","header"]
[null,"CATEGORY 5","header"]
[null,"CATEGORY 6","header"]
[null,"CATEGORY 7","header"]
[null,"FEATURE","feature"]
[null,"LOGO & TAGLINE","logo"]
[null,"MENU","menu"]
[null,"Product 1","product"]
[null,"Product 2","product"]
[null,"Product 3","product"]
[null,"SPECIAL OFFER","specialoffer"]

{"sheet":"Message Info","index":4,"n_rows":36,"n_cols":8,"rows_kept":36,"merged":[[6,2,6,7]],"flags":["formulas_cached_only"]}
[]
[]
[]
[]
[]
[]
[null,null,"MESSAGE INFORMATION"]
[]
[{"$nulls":3},"Line of Business: ","< Select LOB >","Job Number:"]
[]
[{"$nulls":3},"Month: ","<Select Month>"]
[]
[{"$nulls":3},"Week Number: ","< Select Week >"]
[]
[{"$nulls":3},"CoreMetrics Mailing Name:"]
[]
[{"$nulls":7},"Ritz CUF Version 4.4"]
[]
[]
[]
[]
[null,"DROP-DOWN VALUES"]
[null,"Line of Business:","Month:","Week Number:"]
[null,"< Select LOB >","<Select Month>","< Select Week >"]
[null,"BOATERS_WORLD","JANUARY","Week 1"]
[null,"CAMERA_WORLD","FEBRUARY","Week 2"]
[null,"OUTER_BANKS_OUTFITTERS","MARCH","Week 3"]
[null,"PHOTO_ALLEY","APRIL","Week 4"]
[null,"RITZ_CAMERA","MAY"]
[null,"RITZ_ELECTRONICS","JUNE"]
[null,"WOLF_CAMERA","JULY"]
[null,null,"AUGUST"]
[null,null,"SEPTEMBER"]
[null,null,"OCTOBER"]
[null,null,"NOVEMBER"]
[null,null,"DECEMBER"]

{"sheet":"Content Entry Form","index":5,"n_rows":86,"n_cols":21,"rows_kept":86,"flags":["formulas_cached_only"]}
["NEWSLETTER","DEPARTMENT","REPORTING NAME","LINE OF BUSINESS","TEMPLATE SECTION","SKU/CAT# or NAME","LINK NAME","C-LINK","URL","TITLE","#","HTML COPY","#","AOL COPY","#","TEXT COPY","#","PRICE","IMAGE FILENAME","I-LINK","PRIMARY INFERRED"]
["riz",null,"X - NO CONTENT","< Select LOB >","SENDER LINE",{"$nulls":4},"Ritz Camera",14]
["riz",null,"X - NO CONTENT","< select lob >","SUBJECT LINE",{"$nulls":5},100]
["riz","< select lob >_logo_tagline","< SELECT LOB >: LOGO & TAGLINE","< select lob >","LOGO & TAGLINE",null,"main logo","< Link >","&capture=TRUE&tmreturn=true&cm_ven=atonce&cm_cat=&cm_placement=logo&cm_ite=main%20logo&__cm_a1em=@profile.USER_ID@","",null,"No Sales Tax*<br> \nFree Shipping Over $100.00 ",4,null,50,"No Sales Tax* \nFree Shipping Over $100.00 ",8,null,"logo_< select lob >.gif","View Image"]
["riz","< select lob >_disclosure","< SELECT LOB >: *DISCLOSURE","< select lob >","*DISCLOSURE",{"$nulls":6},"* No Tax<br><br>You never pay sales tax! We are not required to collect sales and use tax on deliveries throughout the US, except where we have business locations and in those states we pay ALL sales taxes (California, Georgia, Kansas and Maryland). For customers in these states, our price includes all applicable taxes.<br>\n<br>\nTo satisfy Maryland consumer reporting rules, we will show sales tax and an amount equal to the sales tax will be discounted from our regular low price.  The order total will be the same as our regular low prices without tax.<br>\n<br>\nFree shipping & handling on all new merchandise orders over $100...excludes Auction, Clearance, Oversized and Heavier Items, and UPS service to AK & HI.  See website for complete details.<br>\n<br>",null,null,"n/a","* No Tax\n\nYou never pay sales tax! We are not required \nto collect sales and use tax on deliveries throughout \nthe US, except where we have business locations \nand in those states we pay ALL sales taxes (California, \nGeorgia, Kansas and Maryland). For customers in \nthese states, our price includes all applicable taxes.\n\nTo satisfy Maryland consumer reporting rules, we will \nshow sales tax and an amount equal to the sales tax \nwill be discounted from our regular low price.The \norder total will be the same as our regular low prices \nwithout tax.\n\nFree shipping & handling on all new merchandise orders \nover $100...excludes Auction, Clearance, Oversized and \nHeavier Items, and UPS service to AK & HI.  See website \nfor complete details."]
["riz","NO_CONTENT","X - NO CONTENT","< select lob >","MENU","","","< Link >","","",40]
["riz","NO_CONTENT","X - NO CONTENT","< select lob >","MENU","","","< Link >","","",40]
["riz","NO_CONTENT","X - NO CONTENT","< select lob >","MENU","","","< Link >","","",40]
["riz","NO_CONTENT","X - NO CONTENT","< select lob >","MENU","","","< Link >","","",40]
["riz","NO_CONTENT","X - NO CONTENT","< select lob >","MENU","","","< Link >","","",40]
["riz","NO_CONTENT","X - NO CONTENT","< select lob >","MENU","","","< Link >","","",40]
["riz","NO_CONTENT","X - NO CONTENT","< select lob >","MENU","","","< Link >","","",40]
["riz","< select lob >_f","X - NO CONTENT","< select lob >","FEATURE",{"$nulls":3},"",null,45,null,400,null,400,null,400,null,null,""]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","CATEGORY 1",null,null,"","",null,20]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","SUBHEADER",{"$nulls":5},50]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","Product 1",null,null,"","",null,30,null,50,null,50,null,50,null,"",""]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","Product 2",null,null,"","",null,30,null,50,null,50,null,50,null,"",""]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","Product 3",null,null,"","",null,30,null,50,null,50,null,50,null,"",""]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","Product 4",null,null,"","",null,30,null,50,null,50,null,50,null,"",""]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","Product 5",null,null,"","",null,30,null,50,null,50,null,50,null,"",""]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","Product 6",null,null,"","",null,30,null,50,null,50,null,50,null,"",""]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","CATEGORY 2",null,null,"","",null,20]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","SUBHEADER",{"$nulls":5},50]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","Product 1",null,null,"","",null,30,null,50,null,50,null,50,null,"",""]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","Product 2",null,null,"","",null,30,null,50,null,50,null,50,null,"",""]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","Product 3",null,null,"","",null,30,null,50,null,50,null,50,null,"",""]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","Product 4",null,null,"","",null,30,null,50,null,50,null,50,null,"",""]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","Product 5",null,null,"","",null,30,null,50,null,50,null,50,null,"",""]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","Product 6",null,null,"","",null,30,null,50,null,50,null,50,null,"",""]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","CATEGORY 3",null,null,"","",null,20]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","SUBHEADER",{"$nulls":5},50]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","Product 1",null,null,"","",null,30,null,50,null,50,null,50,null,"",""]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","Product 2",null,null,"","",null,30,null,50,null,50,null,50,null,"",""]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","Product 3",null,null,"","",null,30,null,50,null,50,null,50,null,"",""]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","CATEGORY 4",null,null,"","",null,20]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","SUBHEADER",{"$nulls":5},50]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","Product 1",null,null,"","",null,30,null,50,null,50,null,50,null,"",""]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","Product 2",null,null,"","",null,30,null,50,null,50,null,50,null,"",""]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","Product 3",null,null,"","",null,30,null,50,null,50,null,50,null,"",""]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","CATEGORY 5",null,null,"","",null,20]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","SUBHEADER",{"$nulls":5},50]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","Product 1",null,null,"","",{"$nulls":5},50,{"$nulls":3},"",""]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","Product 2",null,null,"","",null,30,null,50,null,50,null,50,null,"",""]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","Product 3",null,null,"","",null,30,null,50,null,50,null,50,null,"",""]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","CATEGORY 6",null,null,"","","",20]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","SUBHEADER",{"$nulls":5},50]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","Product 1",null,null,"","",null,30,null,50,null,50,null,50,null,"",""]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","Product 2",null,null,"","",null,30,null,50,null,50,null,50,null,"",""]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","Product 3",null,null,"","",null,30,null,50,null,50,null,50,null,"",""]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","CATEGORY 7",null,null,"","","",20]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","SUBHEADER",{"$nulls":5},50]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","Product 1",null,null,"","",null,30,null,50,null,50,{"$nulls":3},"",""]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","Product 2",null,null,"","",null,30,null,50,null,50,null,50,null,"",""]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","Product 3",null,null,"","",null,30,null,50,null,50,null,50,null,"",""]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","SPECIAL OFFER",null,null,"","",null,40,null,50,null,50,null,50,null,null,""]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","ARTICLE 1",null,null,"","",null,40,null,90,null,90,null,90]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","BANNER 1",null,null,"","",{"$nulls":5},60,null,60]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","ARTICLE 2",null,null,"","",null,40,null,90,null,90,null,90]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","BANNER 2",null,null,"","",{"$nulls":5},60,null,60]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","ARTICLE 3",null,null,"","",null,40,null,90,null,90,null,90]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","BANNER 3",null,null,"","",{"$nulls":5},60,null,60]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","ARTICLE 4",null,null,"","",null,40,null,90,null,90,null,90]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","BANNER 4",null,null,"","",{"$nulls":5},60,null,60]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","ARTICLE 5",null,null,"","",null,40,null,90,null,90,null,90]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","BANNER 5",null,null,"","",{"$nulls":5},60,null,60]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","ARTICLE 6",null,null,"","",null,40,null,90,null,90,null,90]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","BANNER 6",null,null,"","",{"$nulls":5},60,null,60]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","ARTICLE 7",null,null,"","",null,40,null,90,null,90,null,90]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","BANNER 7",null,null,"","",{"$nulls":5},60,null,60]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","ARTICLE 8",null,null,"","",null,40,null,90,null,90,null,90]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","BANNER 8",null,null,"","",{"$nulls":5},60,null,60]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","ARTICLE 9",null,null,"","",null,40,null,90,null,90,null,90]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","BANNER 9",null,null,"","",{"$nulls":5},60,null,60]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","ARTICLE 10",null,null,"","",null,40,null,90,null,90,null,90]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","BANNER 10",null,null,"","",{"$nulls":5},60,null,60]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","PARTNER LINK 1",null,null,"",null,null,23]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","PARTNER LINK 2",null,null,"",null,null,23]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","PARTNER LINK 3",null,null,"",null,null,23]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","PARTNER LINK 4",null,null,"",null,null,23]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","PARTNER LINK 5",null,null,"",null,null,23]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","PARTNER LINK 6",null,null,"",null,null,23]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","PARTNER LINK 7",null,null,"",null,null,23]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","PARTNER LINK 8",null,null,"",null,null,23]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","PARTNER LINK 9",null,null,"",null,null,23]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","PARTNER LINK 10",null,null,"",null,null,23]
["EOF"]

{"sheet":"Export Content","index":6,"n_rows":16,"n_cols":30,"rows_kept":16,"hidden":true,"merged":[[1,2,1,29],[3,3,3,11],[5,3,5,24],[7,3,7,16],[11,3,11,6],[25,2,25,12]],"flags":["formulas_cached_only"]}
[]
[null,null,"Export Content"]
[]
[null,null,"Client Code: ","riz_< select lob >"]
[]
[null,null,"Exported Data File Path: ","\\\\FILESHARES\\production\\riz\\content\\"]
[]
[null,null,"Exported Data Filename: ","riz_< select lob >_.dat"]
[]
[null,null,"Separator:","^",null,"dfd"]
[]
[null,null,"First Product ID Number: ","002"]
[{"$nulls":29},"Ritz CUF Version 4.4"]
[]
[null,null,"** DO NOT SAVE THE CUF FOLLOWING THE EXPORT PROCESS **"]
[null,null,"ALL CUF CHANGES NEED TO BE SAVED PRIOR TO EXPORTING IN ORDER TO PRESERVE THE FUNCTIONS AND FORMATTING OF THE 'CONTENT ENTRY FORM' WORKSHEET."]

{"sheet":"Instructions","index":7,"n_rows":14,"n_cols":2,"rows_kept":14,"hidden":true,"merged":[[1,1,1,30],[2,1,2,30],[3,1,3,30],[4,1,4,30],[5,1,5,30],[6,1,6,30],[7,1,7,30],[8,1,8,30],[9,1,9,30],[10,1,10,30],[11,1,11,30],[12,1,12,30],[13,1,13,30]],"flags":["formulas_cached_only"]}
[]
[null,"CUF Instructions for Use"]
[]
[null,"1. Define the required columns to be supplied by the client on the Setup worksheet."]
[null,"2. Click the \"Setup Date Entry Headers\" button"]
[null,"3. Hide the non-client worksheets by executing the \"HideSheets\" macro. (ctrl-h)"]
[null,"4. Deliver the CUF to the client for data entry"]
[null,"5. Upon return of the CUF from the client, unhide the non-client worksheets by executing \"ShowSheets\" macro (ctrl-s)"]
[null,"6. Complete the form on the Process worksheet"]
[null,"7. Click \"Create/Update Data Review Web Pages\" to create a set of web pages for reviewing the HTML rendering behavior of the data."]
[null,"AND/OR"]
[null,"8. Click the \"Review Data\" link to review the data in a browser."]
[null,"AND/OR"]
[null,"9. Click \"Export Data Load File\" to produce an external text file for loading the data into the database."]

{"sheet":"Scratch","index":8,"n_rows":4,"n_cols":2,"rows_kept":4,"hidden":true,"flags":["formulas_cached_only"]}
["cRows",100]
["cCols",21]
["headerRow","^DIVISION^DEPARTMENT^NAME^MISC_STRING1^CATEGORY^DESCRIPTION2^SEC_INFERRED_INTEREST^MISC_STRING2^HLINK^DESCRIPTION1^MISC_NUM1^TEXT_AREA1^QUANTITY^TEXT_AREA3^PRIORITY1^TEXT_AREA2^PRIORITY2^LIST_PRICE^FULL_IMAGE1^DESCRIPTION3^INFERRED_INTEREST"]
["columnForTextArea1",12]

{"sheet":"Content BackUp Form","index":9,"n_rows":50,"n_cols":22,"rows_kept":50,"hidden":true,"flags":["formulas_cached_only"]}
["NEWSLETTER","DEPARTMENT","REPORTING NAME","LINE OF BUSINESS","TEMPLATE SECTION","SKU/CAT# or NAME",null,"C-LINK","URL","TITLE","#","HTML COPY","#","AOL COPY","#","TEXT COPY","#","PRICE","IMAGE FILENAME","I-LINK","PRIMARY INFERRED","SECONDARY INFERRED"]
["riz",null,"< Select LOB > - SENDER LINE","< Select LOB >","SENDER LINE",{"$nulls":5},25]
["riz",null,"< SELECT LOB > - SUBJECT LINE","< select lob >","SUBJECT LINE",{"$nulls":5},100]
["riz","< select lob >_logo_tagline","< SELECT LOB >: LOGO & TAGLINE","< select lob >","LOGO & TAGLINE",null,null,"< Link >","","",null,"",50,"",50,"",50,null,"logo_< select lob >.gif","View Image"]
["riz","< select lob >_disclosure","< SELECT LOB >: *DISCLOSURE","< select lob >","*DISCLOSURE",{"$nulls":6},"",550,"",550,"",550]
["riz","NO_CONTENT","< SELECT LOB >: MENU - ","< select lob >","MENU","",null,"< Link >","","",40]
["riz","NO_CONTENT","< SELECT LOB >: MENU - ","< select lob >","MENU","",null,"< Link >","","",40]
["riz","NO_CONTENT","< SELECT LOB >: MENU - ","< select lob >","MENU","",null,"< Link >","","",40]
["riz","NO_CONTENT","< SELECT LOB >: MENU - ","< select lob >","MENU","",null,"< Link >","","",40]
["riz","NO_CONTENT","< SELECT LOB >: MENU - ","< select lob >","MENU","",null,"< Link >","","",40]
["riz","NO_CONTENT","< SELECT LOB >: MENU - ","< select lob >","MENU","",null,"< Link >","","",40]
["riz","NO_CONTENT","< SELECT LOB >: MENU - ","< select lob >","MENU","",null,"< Link >","","",40]
["riz","< select lob >_f","< SELECT LOB >: FEATURE - ","< select lob >","FEATURE","/etc/content/rcarticles/ixp.html",null,"< Link >","/etc/content/rcarticles/ixp.html",null,45,null,400,null,400,null,400,null,"","Get Image"]
["riz","<_select_lob_>_cat1_header","< SELECT LOB >: CATEGORY 1 - ","< select lob >","CATEGORY 1",1009,null,"< Link >","1009&capture=TRUE&tmreturn=true",null,20]
["riz","<_select_lob_>_cat1_p1","< SELECT LOB >: Product 1 - ","< select lob >","Product 1",542081179,null,"< Link >","542081179&capture=TRUE&tmreturn=true",null,30,null,50,null,50,null,50,null,"542081179_sm.jpg","Get Image"]
["riz","<_select_lob_>_cat1_p2","< SELECT LOB >: Product 2 - ","< select lob >","Product 2",541243283,null,"< Link >","541243283&capture=TRUE&tmreturn=true",null,30,null,50,null,50,null,50,null,"541243283_sm.jpg","Get Image"]
["riz","<_select_lob_>_cat1_p3","< SELECT LOB >: Product 3 - ","< select lob >","Product 3",541538427,null,"< Link >","541538427&capture=TRUE&tmreturn=true",null,30,null,50,null,50,null,50,null,"541538427_sm.jpg","Get Image"]
["riz","X - NO CONTENT","< SELECT LOB >: CATEGORY 2 - ","< select lob >","CATEGORY 2",null,null,"","",null,20]
["riz","X - NO CONTENT","< SELECT LOB >: Product 1 - ","< select lob >","Product 1",null,null,"","",null,30,null,50,null,50,null,50,null,"",""]
["riz","X - NO CONTENT","< SELECT LOB >: Product 2 - ","< select lob >","Product 2",null,null,"","",null,30,null,50,null,50,null,50,null,"",""]
["riz","X - NO CONTENT","< SELECT LOB >: Product 3 - ","< select lob >","Product 3",null,null,"","",null,30,null,50,null,50,null,50,null,"",""]
["riz","X - NO CONTENT","< SELECT LOB >: CATEGORY 3 - ","< select lob >","CATEGORY 3",null,null,"","",null,20]
["riz","X - NO CONTENT","< SELECT LOB >: Product 1 - ","< select lob >","Product 1",null,null,"","",null,30,null,50,null,50,null,50,null,"",""]
["riz","X - NO CONTENT","< SELECT LOB >: Product 2 - ","< select lob >","Product 2",null,null,"","",null,30,null,50,null,50,null,50,null,"",""]
["riz","X - NO CONTENT","< SELECT LOB >: Product 3 - ","< select lob >","Product 3",null,null,"","",null,30,null,50,null,50,null,50,null,"",""]
["riz","X - NO CONTENT","< SELECT LOB >: CATEGORY 4 - ","< select lob >","CATEGORY 4",null,null,"","",null,20]
["riz","X - NO CONTENT","< SELECT LOB >: Product 1 - ","< select lob >","Product 1",null,null,"","",null,30,null,50,null,50,null,50,null,"",""]
["riz","X - NO CONTENT","< SELECT LOB >: Product 2 - ","< select lob >","Product 2",null,null,"","",null,30,null,50,null,50,null,50,null,"",""]
["riz","X - NO CONTENT","< SELECT LOB >: Product 3 - ","< select lob >","Product 3",null,null,"","",null,30,null,50,null,50,null,50,null,"",""]
["riz","X - NO CONTENT","< SELECT LOB >: CATEGORY 5 - ","< select lob >","CATEGORY 5",null,null,"","",null,20]
["riz","X - NO CONTENT","< SELECT LOB >: Product 1 - ","< select lob >","Product 1",null,null,"","",null,30,null,50,null,50,null,50,null,"",""]
["riz","X - NO CONTENT","< SELECT LOB >: Product 2 - ","< select lob >","Product 2",null,null,"","",null,30,null,50,null,50,null,50,null,"",""]
["riz","X - NO CONTENT","< SELECT LOB >: Product 3 - ","< select lob >","Product 3",null,null,"","",null,30,null,50,null,50,null,50,null,"",""]
["riz","X - NO CONTENT","< SELECT LOB >: CATEGORY 6 - ","< select lob >","CATEGORY 6",null,null,"","",null,20]
["riz","X - NO CONTENT","< SELECT LOB >: Product 1 - ","< select lob >","Product 1",null,null,"","",null,30,null,50,null,50,null,50,null,"",""]
["riz","X - NO CONTENT","< SELECT LOB >: Product 2 - ","< select lob >","Product 2",null,null,"","",null,30,null,50,null,50,null,50,null,"",""]
["riz","X - NO CONTENT","< SELECT LOB >: Product 3 - ","< select lob >","Product 3",null,null,"","",null,30,null,50,null,50,null,50,null,"",""]
["riz","X - NO CONTENT","< SELECT LOB >: CATEGORY 7 - ","< select lob >","CATEGORY 7",null,null,"","",null,20]
["riz","X - NO CONTENT","< SELECT LOB >: Product 1 - ","< select lob >","Product 1",null,null,"","",null,30,null,50,null,50,null,50,null,"",""]
["riz","X - NO CONTENT","< SELECT LOB >: Product 2 - ","< select lob >","Product 2",null,null,"","",null,30,null,50,null,50,null,50,null,"",""]
["riz","X - NO CONTENT","< SELECT LOB >: Product 3 - ","< select lob >","Product 3",null,null,"","",null,30,null,50,null,50,null,50,null,"",""]
["riz","< select lob >_special_offer","< SELECT LOB >: SPECIAL OFFER - ","< select lob >","SPECIAL OFFER",541538153,null,"< Link >","541538153&capture=TRUE&tmreturn=true",null,40,null,50,null,50,null,50,null,"541538153.jpg","Get Image"]
["riz","< select lob >_article_1","< SELECT LOB >: ARTICLE 1 - ","< select lob >","ARTICLE 1","&cat=1020&capture=TRUE&tmreturn=true",null,"< Link >","&cat=1020&capture=TRUE&tmreturn=true",null,40,null,90,null,90,null,90]
["riz","< select lob >_banner_1","< SELECT LOB >: BANNER 1 - ","< select lob >","BANNER 1","http://www.ritzcards.com/?ritzcamera",null,"< Link >","http://www.ritzcards.com/?ritzcamera",{"$nulls":5},60,null,60]
["riz","< select lob >_banner_2","< SELECT LOB >: BANNER 2 - ","< select lob >","BANNER 2","http://www.ritzelectronics.com/?location=NLR08A&capture=TRUE&tmreturn=true&cat=13001001",null,"< Link >","http://www.ritzelectronics.com/?location=NLR08A&capture=TRUE&tmreturn=true&cat=13001001",{"$nulls":5},60,null,60]
["riz","X - NO CONTENT","< SELECT LOB >: ARTICLE 2 - ","< select lob >","ARTICLE 2",null,null,"","",null,40,null,90,null,90,null,90]
["riz","X - NO CONTENT","< SELECT LOB >: BANNER 3 - ","< select lob >","BANNER 3",null,null,"","",{"$nulls":5},60,null,60]
["riz","X - NO CONTENT","< SELECT LOB >: BANNER 4 - ","< select lob >","BANNER 4",null,null,"","",{"$nulls":5},60,null,60]
["riz","X - NO CONTENT","< SELECT LOB >: BANNER 5 - ","< select lob >","BANNER 5",null,null,"","",{"$nulls":5},60,null,60]
["EOF"]

{"sheet":"Content Review","index":10,"n_rows":24,"n_cols":22,"rows_kept":24,"hidden":true,"merged":[[1,2,1,25],[3,3,3,11],[5,3,5,24],[8,3,8,4],[13,21,13,25],[23,2,23,12]],"flags":["formulas_cached_only"]}
[]
[null,null,"Content Review"]
[]
[null,null,"Client Code:","riz_< select lob >"]
[]
[null,null,"Data Review  Files Path:","\\\\Fileshares\\production\\riz\\cuf\\templates\\products"]
[]
[]
[null,null,"First Product ID Number:",1]
[]
[]
[]
[]
[{"$nulls":21},"Content Review"]
{"$rows_empty":9}
[{"$nulls":13},"s"]