{"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":2,"defined_names":21},"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#"]
["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"]
["SEC_INFERRED_INTEREST","EXTERNAL","SECONDARY 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":48,"n_cols":14,"rows_kept":48,"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,"<Select Month>",{"$nulls":3},"35MM COMPACT",1005]
[null,"JANUARY","01","APRIL","04","35MM POINT & SHOOT",1005]
[null,"FEBRUARY","02","AUGUST","08","35MM SLR",1006]
[null,"MARCH","03","DECEMBER","12","APS POINT & SHOOT",1007]
[null,"APRIL","04","FEBRUARY","02","CAMCORDERS",1008]
[null,"MAY","05","JANUARY","01","CAR PRODUCTS",7954343]
[null,"JUNE","06","JULY","07","DIGITAL",1009]
[null,"JULY","07","JUNE","06","DIGITAL CAMERAS",1009]
[null,"AUGUST","08","MARCH","03","FISH FINDERS",249089]
[null,"SEPTEMBER","09","MAY","05","GAME SUPPLIES",7994183]
[null,"OCTOBER","10","NOVEMBER","11","GPS CHARTPLOTTERS",249090]
[null,"NOVEMBER","11","OCTOBER","10","HOME A/V",7954162]
[null,"DECEMBER","12","SEPTEMBER","09","MEMORY",5739563]
[null,"WEEK CODES:",{"$nulls":3},"PHONES",7954434]
[null,"< Select Week >",{"$nulls":3},"PRINTERS",5739564]
[null,"Week 1","A",null,null,"PRO",1010]
[null,"Week 2","B",null,null,"RADAR AUTOPILOTS",249091]
[null,"Week 3","C",null,null,"ROD/REEL COMBOS",249096]
[null,"Week 4","D",null,null,"SLR CAMERAS",1006]
[null,"Line of Business",null,"Feature & Article Links","Banner Links","SPEAKERS",7953846]
[null,"< Select LOB >",{"$nulls":3},"TELESCOPES",1017]
[null,"BOATERS_WORLD",null,{"$error":"#N/A"},{"$error":"#N/A"},"TV, DVD, & VIDEO",7991883]
[null,"CAMERA_WORLD",null,{"$error":"#N/A"},{"$error":"#N/A"},"VHF RADIOS",249092]
[null,"OUTER_BANKS_OUTFITTERS",null,{"$error":"#N/A"},{"$error":"#N/A"},"VIDEO",1008]
[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.<br>\n<br>\nFree ground shipping & handling on Qualifying orders OVER $100...excludes Auction, Clearance, Oversized and Heavier Items, and UPS service to AK & HI. Oversized and Heavier Items will incur an additional charge.  See website for complete details.<br>\n<br>","*Free ground shipping & handling on all merchandise over $100 and under 20 lbs.\n\nFree ground shipping & handling on Qualifying orders OVER $100...excludes Auction, Clearance, Oversized and Heavier Items, and UPS service to AK & HI. Oversized and Heavier Items will incur an additional charge.  See website for complete details."]
[null,"CAMERA_WORLD","Camera World","No Sales Tax*<br> \nFree Shipping Over $100.00 ","No Sales Tax* \nFree Shipping Over $100.00 "]
[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 lbs.<br>\n<br>\nFree ground shipping & handling on Qualifying orders OVER $100...excludes Auction, Clearance, Oversized and Heavier Items, and UPS service to AK & HI. Oversized and Heavier Items will incur an additional charge.  See website for complete details.<br>\n<br>","*Free ground shipping & handling on all merchandise over $100 and under 20 lbs.\n\nFree ground shipping & handling on Qualifying orders OVER $100...excludes Auction, Clearance, Oversized and Heavier Items, and UPS service to AK & HI. Oversized and Heavier Items will incur an additional charge.  See website for complete details."]
[null,"PHOTO_ALLEY","Photo Alley","No Sales Tax*<br> \nFree Shipping Over $100.00 ","No Sales Tax* \nFree Shipping Over $100.00 "]
[null,"RITZ_CAMERA","Ritz Camera","No Sales Tax*<br> \nFree Shipping Over $100.00 ","No Sales Tax* \nFree Shipping Over $100.00 "]
[null,"RITZ_ELECTRONICS","Ritz Electronics","No Sales Tax*<br>100% Safe & Secure","No Sales Tax*\n100% Safe & Secure"]
[null,"WOLF_CAMERA","Wolf Camera","No Sales Tax*<br> \nFree Shipping Over $100.00 ","No Sales Tax* \nFree Shipping Over $100.00 "]

{"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:","0000"]
[]
[{"$nulls":3},"Month: ","<Select Month>"]
[]
[{"$nulls":3},"Week Number: ","< Select Week >"]
[]
[]
[]
[{"$nulls":7},"Ritz CUF Version 3.3"]
[]
[]
[]
[]
[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","C-LINK","URL","TITLE","#","HTML COPY","#",null,null,"TEXT COPY","#","PRICE","IMAGE FILENAME","I-LINK","PRIMARY INFERRED","SECONDARY INFERRED"]
["riz",null,"X - NO CONTENT","< Select LOB >","SENDER LINE",{"$nulls":4},25]
["riz",null,"X - NO CONTENT","< select lob >","SUBJECT LINE",{"$nulls":4},100]
["riz","< select lob >_logo_tagline","< SELECT LOB >: LOGO & TAGLINE - ","< select lob >","LOGO & TAGLINE",null,"< Link >","","",null,"No Sales Tax*<br> \nFree Shipping Over $100.00 ",4,null,null,"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":5},"* 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>",{"$nulls":3},"* 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",null,null,"",null,45,null,400,{"$nulls":3},400,null,null,""]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","CATEGORY 1",null,"","",null,20]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","SUBHEADER",{"$nulls":4},50]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","Product 1",null,"","",null,30,null,50,{"$nulls":3},50,null,"",""]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","Product 2",null,"","",null,30,null,50,{"$nulls":3},50,null,"",""]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","Product 3",null,"","",null,30,null,50,{"$nulls":3},50,null,"",""]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","Product 4",null,"","",null,30,null,50,{"$nulls":3},50,null,"",""]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","Product 5",null,"","",null,30,null,50,{"$nulls":3},50,null,"",""]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","Product 6",null,"","",null,30,null,50,{"$nulls":3},50,null,"",""]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","CATEGORY 2",null,"","",null,20]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","SUBHEADER",{"$nulls":4},50]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","Product 1",null,"","",null,30,null,50,{"$nulls":3},50,null,"",""]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","Product 2",null,"","",null,30,null,50,{"$nulls":3},50,null,"",""]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","Product 3",null,"","",null,30,null,50,{"$nulls":3},50,null,"",""]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","Product 4",null,"","",null,30,null,50,{"$nulls":3},50,null,"",""]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","Product 5",null,"","",null,30,null,50,{"$nulls":3},50,null,"",""]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","Product 6",null,"","",null,30,null,50,{"$nulls":3},50,null,"",""]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","CATEGORY 3",null,"","",null,20]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","SUBHEADER",{"$nulls":4},50]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","Product 1",null,"","",null,30,null,50,{"$nulls":3},50,null,"",""]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","Product 2",null,"","",null,30,null,50,{"$nulls":3},50,null,"",""]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","Product 3",null,"","",null,30,null,50,{"$nulls":3},50,null,"",""]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","CATEGORY 4",null,"","",null,20]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","SUBHEADER",{"$nulls":4},50]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","Product 1",null,"","",null,30,null,50,{"$nulls":3},50,null,"",""]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","Product 2",null,"","",null,30,null,50,{"$nulls":3},50,null,"",""]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","Product 3",null,"","",null,30,null,50,{"$nulls":3},50,null,"",""]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","CATEGORY 5",null,"","",null,20]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","SUBHEADER",{"$nulls":4},50]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","Product 1",null,"","",null,30,null,50,{"$nulls":3},50,null,"",""]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","Product 2",null,"","",null,30,null,50,{"$nulls":3},50,null,"",""]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","Product 3",null,"","",null,30,null,50,{"$nulls":3},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":4},50]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","Product 1",null,"","",null,30,null,50,{"$nulls":3},50,null,"",""]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","Product 2",null,"","",null,30,null,50,{"$nulls":3},50,null,"",""]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","Product 3",null,"","",null,30,null,50,{"$nulls":3},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":4},50]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","Product 1",null,"","",null,30,null,50,{"$nulls":3},50,null,"",""]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","Product 2",null,"","",null,30,null,50,{"$nulls":3},50,null,"",""]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","Product 3",null,"","",null,30,null,50,{"$nulls":3},50,null,"",""]
["riz","< select lob >_special_offer","X - NO CONTENT","< select lob >","SPECIAL OFFER",null,"","",null,40,null,50,{"$nulls":3},50,null,"",""]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","ARTICLE 1",null,null,"",null,40,null,90,{"$nulls":3},90]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","BANNER 1",null,"","",{"$nulls":7},60]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","ARTICLE 2",null,"","",null,40,null,90,{"$nulls":3},60]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","BANNER 2",null,null,"",{"$nulls":7},90]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","ARTICLE 3",null,"","",null,40,null,90,{"$nulls":3},60]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","BANNER 3",null,"","",{"$nulls":7},60]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","ARTICLE 4",null,null,"",null,40,null,90,{"$nulls":3},90]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","BANNER 4",null,null,"",{"$nulls":7},90]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","ARTICLE 5",null,"","",null,40,null,90,{"$nulls":3},60]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","BANNER 5",null,"","",{"$nulls":7},60]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","ARTICLE 6",null,null,"",null,40,null,90,{"$nulls":3},90]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","BANNER 6",null,"","",{"$nulls":7},60]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","ARTICLE 7",null,null,"",null,40,null,90,{"$nulls":3},90]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","BANNER 7",null,null,"",{"$nulls":7},90]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","ARTICLE 8",null,"","",null,40,null,90,{"$nulls":3},60]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","BANNER 8",null,"","",{"$nulls":7},60]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","ARTICLE 9",null,null,"",null,40,null,90,{"$nulls":3},90]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","BANNER 9",null,"","",{"$nulls":7},60]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","ARTICLE 10",null,"","",null,40,null,90,{"$nulls":3},60]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","BANNER 10",null,"","",{"$nulls":7},60]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","PARTNER LINK 1",null,"",null,null,23]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","PARTNER LINK 2",null,"",null,null,23]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","PARTNER LINK 3",null,"",null,null,23]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","PARTNER LINK 4",null,"",null,null,23]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","PARTNER LINK 5",null,"",null,null,23]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","PARTNER LINK 6",null,"",null,null,23]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","PARTNER LINK 7",null,"",null,null,23]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","PARTNER LINK 8",null,"",null,null,23]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","PARTNER LINK 9",null,"",null,null,23]
["riz","X - NO CONTENT","X - NO CONTENT","< select lob >","PARTNER LINK 10",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 >_0000.dat"]
[]
[null,null,"Separator:","^",null,"dfd"]
[]
[null,null,"First Product ID Number: ","000000"]
[{"$nulls":29},"Ritz CUF Version 3.3"]
[]
[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^MISC_STRING2^HLINK^DESCRIPTION1^MISC_NUM1^TEXT_AREA1^QUANTITY^TEXT_AREA3^PRIORITY1^TEXT_AREA2^PRIORITY2^LIST_PRICE^FULL_IMAGE1^DESCRIPTION3^INFERRED_INTEREST^SEC_INFERRED_INTEREST"]
["columnForTextArea1",11]

{"sheet":"Content BackUp Form","index":9,"n_rows":38,"n_cols":21,"rows_kept":38,"hidden":true,"flags":["formulas_cached_only"]}
["NEWSLETTER","DEPARTMENT","REPORTING NAME","LINE OF BUSINESS","TEMPLATE SECTION","SKU/CAT# or NAME","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":3},"RitzCamera.com",11]
["riz",null,"< SELECT LOB > - SUBJECT LINE","< select lob >","SUBJECT LINE",{"$nulls":3},"How to Take Great Haloween Pictures & More!",57]
["riz","< select lob >_logo_tagline","< SELECT LOB >: LOGO & TAGLINE","< select lob >","LOGO & TAGLINE",null,{"$error":"#N/A"},{"$error":"#N/A"},"",null,"",50,"",50,"",50,null,"logo_< select lob >.gif","View Image"]
["riz","< select lob >_disclosure","< SELECT LOB >: *DISCLOSURE","< select lob >","*DISCLOSURE",{"$nulls":5},"",550,"",550,"",550]
["riz","NO_CONTENT","< SELECT LOB >: MENU - ","< select lob >","MENU","","< Link >","","",40]
["riz","NO_CONTENT","< SELECT LOB >: MENU - ","< select lob >","MENU","","< Link >","","",40]
["riz","NO_CONTENT","< SELECT LOB >: MENU - ","< select lob >","MENU","","< Link >","","",40]
["riz","NO_CONTENT","< SELECT LOB >: MENU - ","< select lob >","MENU","","< Link >","","",40]
["riz","NO_CONTENT","< SELECT LOB >: MENU - ","< select lob >","MENU","","< Link >","","",40]
["riz","NO_CONTENT","< SELECT LOB >: MENU - ","< select lob >","MENU","","< Link >","","",40]
["riz","NO_CONTENT","< SELECT LOB >: MENU - ","< select lob >","MENU","","< Link >","","",40]
["riz","ritz_camera_f","< SELECT LOB >: FEATURE - How to Take Great Halloween Photographs","< select lob >","FEATURE","oct_tips.html","< Link >","oct_tips.html","How to Take Great Halloween Photographs",6,"October is a great month to take pictures. The humid hazy days of summer have given way to crisp cool days with clear air and bright blue skies. The perfect combination for sparkling photographs! The sun is lower in the sky, providing wonderful long shadows in early morning and late afternoon. So conditions are perfect for photographers - amateur or professional ...",32,"October is a great month to take pictures. The\nhumid hazy days of summer have given way to crisp\ncool days with clear air and bright blue skies.\nThe perfect combination for sparkling photographs!\nThe sun is lower in the sky, providing wonderful\nlong shadows in early morning and late afternoon.\nSo conditions are perfect for photographers -\namateur or professional ...",32,"October is a great month to take pictures. The\nhumid hazy days of summer have given way to crisp\ncool days with clear air and bright blue skies.\nThe perfect combination for sparkling photographs!\nThe sun is lower in the sky, providing wonderful\nlong shadows in early morning and late afternoon.\nSo conditions are perfect for photographers -\namateur or professional ...",32,null,"hal131097.jpg"]
["riz","<_select_lob_>_cat1_header","< SELECT LOB >: CATEGORY 1 - DIGITAL CAMERAS","< select lob >","CATEGORY 1",1009,"< Link >","1009&capture=TRUE&tmreturn=true","DIGITAL CAMERAS",5]
["riz","<_select_lob_>_cat1_p1","< SELECT LOB >: Product 1 - Fuji A200 - New xD Technology!","< select lob >","Product 1",541243291,"< Link >","541243291&capture=TRUE&tmreturn=true","Fuji A200 - New xD Technology!",0,"2MP for images to 8x10, Easy to use, Lightweight",2,"2MP for images to 8x10, Easy to use, Lightweight",2,"2MP for images to 8x10, Easy to use, Lightweight",2,{"v":179.95,"d":"$179.95"},"541243291_sm.jpg","Get Image"]
["riz","<_select_lob_>_cat1_p2","< SELECT LOB >: Product 2 - Fuji A303 - New xD Technology!","< select lob >","Product 2",541243309,"< Link >","541243309&capture=TRUE&tmreturn=true","Fuji A303 - New xD Technology!",0,"3.24 MP, 3X Zoom, User Friendly with Room to Grow",1,"3.24 MP, 3X Zoom, User Friendly with Room to Grow",1,"3.24 MP, 3X Zoom, User Friendly with Room to Grow",1,{"v":349.95,"d":"$349.95"},"541243309_sm.jpg","Get Image"]
["riz","<_select_lob_>_cat1_p3","< SELECT LOB >: Product 3 - Fuji 3800 - New xD Technology!","< select lob >","Product 3",541243283,"< Link >","541243283&capture=TRUE&tmreturn=true","Fuji 3800 - New xD Technology!",0,"3.24 MP, 6X Zoom, Manual Control, Shoot Like a Pro",0,"3.24 MP, 6X Zoom, Manual Control, Shoot Like a Pro",0,"3.24 MP, 6X Zoom, Manual Control, Shoot Like a Pro",0,{"v":449.95,"d":"$449.95"},"541243283_sm.jpg","Get Image"]
["riz","<_select_lob_>_cat2_header","< SELECT LOB >: CATEGORY 2 - DIGITAL ACCESSORIES","< select lob >","CATEGORY 2",1020,"< Link >","1020&capture=TRUE&tmreturn=true","DIGITAL ACCESSORIES",1]
["riz","<_select_lob_>_cat2_p1","< SELECT LOB >: Product 1 - Fuji xD 32MB Memory Card - NEW","< select lob >","Product 1",101240125,"< Link >","101240125&capture=TRUE&tmreturn=true","Fuji xD 32MB Memory Card - NEW",0,"Like a extra roll of film for your digital camera!",0,"Like a extra roll of film for your digital camera!",0,"Like a extra roll of film for your digital camera!",0,{"v":29.99,"d":"$29.99"},"101240125_sm.jpg","Get Image"]
["riz","<_select_lob_>_cat2_p2","< SELECT LOB >: Product 2 - Fuji xD 64MB Memory Card - NEW","< select lob >","Product 2",101240133,"< Link >","101240133&capture=TRUE&tmreturn=true","Fuji xD 64MB Memory Card - NEW",0,"Never miss a shot with 64MB of memory!",12,"Never miss a shot with 64MB of memory!",12,"Never miss a shot with 64MB of memory!",12,{"v":49.99,"d":"$49.99"},"101240133_sm.jpg","Get Image"]
["riz","<_select_lob_>_cat2_p3","< SELECT LOB >: Product 3 - Fuji xD Memory Card Reader NEW","< select lob >","Product 3",811240308,"< Link >","811240308&capture=TRUE&tmreturn=true","Fuji xD Memory Card Reader NEW",0,"Transfer images from xD cards to your computer.",3,"Transfer images from xD cards to your computer.",3,"Transfer images from xD cards to your computer.",3,{"v":69.99,"d":"$69.99"},"811240308_sm.jpg","Get Image"]
["riz","<_select_lob_>_cat3_header","< SELECT LOB >: CATEGORY 3 - 35MM SLR","< select lob >","CATEGORY 3",1006,"< Link >","1006&capture=TRUE&tmreturn=true","35MM SLR",12]
["riz","<_select_lob_>_cat3_p1","< SELECT LOB >: Product 1 - Canon EOS Rebel G Kit w/28-80","< select lob >","Product 1","SLR1047","< Link >","SLR1047&capture=TRUE&tmreturn=true","Canon EOS Rebel G Kit w/28-80",1," New Low Price!  Fully Automatic, Point & Shoot",3," New Low Price!  Fully Automatic, Point & Shoot",3," New Low Price!  Fully Automatic, Point & Shoot",3,{"v":249.95,"d":"$249.95"},"SLR1047_sm.jpg","Get Image"]
["riz","<_select_lob_>_cat3_p2","< SELECT LOB >: Product 2 - Nikon N80 w/Nikon 28-80 Zoom","< select lob >","Product 2","SLR1024","< Link >","SLR1024&capture=TRUE&tmreturn=true","Nikon N80 w/Nikon 28-80 Zoom",2,"Rebate!  Advance your picture taking techniques.",2,"Rebate!  Advance your picture taking techniques.",2,"Rebate!  Advance your picture taking techniques.",2,{"v":544.95,"d":"$544.95"},"SLR1024_sm.jpg","Get Image"]
["riz","<_select_lob_>_cat3_p3","< SELECT LOB >: Product 3 - Canon EOS Rebel 2000 w/28-80","< select lob >","Product 3","SLR1045","< Link >","SLR1045&capture=TRUE&tmreturn=true","Canon EOS Rebel 2000 w/28-80",2," New Low Price! Automatic with Advanced Features",2," New Low Price! Automatic with Advanced Features",2," New Low Price! Automatic with Advanced Features",2,{"v":299.95,"d":"$299.95"},"SLR1045_sm.jpg","Get Image"]
["riz","<_select_lob_>_cat4_header","< SELECT LOB >: CATEGORY 4 - CAMERA ACCESSORIES","< select lob >","CATEGORY 4",1014,"< Link >","1014&capture=TRUE&tmreturn=true","CAMERA ACCESSORIES",2]
["riz","<_select_lob_>_cat4_p1","< SELECT LOB >: Product 1 - Sunpak 8001 UT Series Tripod ","< select lob >","Product 1",291400018,"< Link >","291400018&capture=TRUE&tmreturn=true","Sunpak 8001 UT Series Tripod ",1,"Special Purchase!  3-way pan head & more!",9,"Special Purchase!  3-way pan head & more!",9,"Special Purchase!  3-way pan head & more!",9,{"v":39.99,"d":"$39.99"},"291400018_sm.jpg","Get Image"]
["riz","<_select_lob_>_cat4_p2","< SELECT LOB >: Product 2 - PZ-1 TTL Flash for Canon","< select lob >","Product 2",531660876,"< Link >","531660876&capture=TRUE&tmreturn=true","PZ-1 TTL Flash for Canon",6,"with Power Zoom, bounce head, made by SunPak ",5,"with Power Zoom, bounce head, made by SunPak ",5,"with Power Zoom, bounce head, made by SunPak ",5,{"v":139.95,"d":"$139.95"},"531660876_sm.jpg","Get Image"]
["riz","<_select_lob_>_cat4_p3","< SELECT LOB >: Product 3 - PZ-1 TTL Flash for Nikon","< select lob >","Product 3",531660884,"< Link >","531660884&capture=TRUE&tmreturn=true","PZ-1 TTL Flash for Nikon",6,"with Power Zoom, bounce head, made by SunPak ",5,"with Power Zoom, bounce head, made by SunPak ",5,"with Power Zoom, bounce head, made by SunPak ",5,{"v":139.95,"d":"$139.95"},"531660884_sm.jpg","Get Image"]
["riz","< select lob >_special_offer","< SELECT LOB >: SPECIAL OFFER - Canon Elura 40MC Digital Video Camcorder","< select lob >","SPECIAL OFFER",591161765,"< Link >","591161765&capture=TRUE&tmreturn=true","Canon Elura 40MC Digital Video Camcorder",0,"Free Canon Printer & ShowBiz Video Edit Software!",1,"Free Canon Printer & ShowBiz Video Edit Software ",1,"Free Canon Printer & ShowBiz Video Edit Software ",1,{"v":999.99,"d":"$999.99"},"591161765.jpg","Get Image"]
["riz","< select lob >_article_1","< SELECT LOB >: ARTICLE 1 - New xD-Picture Cards & Digital Cameras","< select lob >","ARTICLE 1","xdinfo.html","< Link >","xdinfo.html","New xD-Picture Cards & Digital Cameras",2,"The new xD-Picture Card is the smallest storage format of its kind on the market…",9,"The new xD-Picture Card is the smallest storage\nformat of its kind on the market…",9,"The new xD-Picture Card is the smallest storage\nformat of its kind on the market…",9,null,"xD.jpg"]
["riz","< select lob >_banner_1","< SELECT LOB >: BANNER 1 - ","< select lob >","BANNER 1","&cat=10860&capture=TRUE&tmreturn=true","< Link >","&cat=10860&capture=TRUE&tmreturn=true",{"$nulls":4},"Clearance Center Bargains",35,"Clearance Center Bargains",35,null,"150x50_Clearance.gif"]
["riz","< select lob >_banner_2","< SELECT LOB >: BANNER 2 - ","< select lob >","BANNER 2","&cat=1989473&capture=TRUE&tmreturn=true","< Link >","&cat=1989473&capture=TRUE&tmreturn=true",{"$nulls":4},"Looking for the Perfect Gift?  Visit our Gift Center.",7,"Looking for the Perfect Gift?  Visit our Gift Center.",7,null,"150x50_GiftCenter.gif"]
["riz","< select lob >_article_2","< SELECT LOB >: ARTICLE 2 - Incident and GrayCard Readings\nfrom NYIP","< select lob >","ARTICLE 2","tip_graycard.html","< Link >","tip_graycard.html","Incident and GrayCard Readings\nfrom NYIP",0,"How do you meter a sunset? Or a flag backlit by the sun? Or any other \"tricky\" situation?",1,"How do you meter a sunset? Or a flag backlit by\nthe sun? Or any other \"tricky\" situation?",1,"How do you meter a sunset? Or a flag backlit by\nthe sun? Or any other \"tricky\" situation?",1,null,"meterb0198.jpg"]
["riz","< select lob >_banner_3","< SELECT LOB >: BANNER 3 - ","< select lob >","BANNER 3","&capture=TRUE&tmreturn=true&page=articles&content=contest/mirage/index.htm","< Link >","&capture=TRUE&tmreturn=true&page=articles&content=contest/mirage/index.htm",{"$nulls":4},"Enter to Win a Trip to the Mirage Hotel in Las Vegas!",7,"Enter to Win a Trip to the Mirage Hotel in Las Vegas!",7,null,"150x50Newsletter_mirage_2.gif"]
["riz","< select lob >_banner_4","< SELECT LOB >: BANNER 4 - ","< select lob >","BANNER 4","&page=articles&content=bigprintgallery.html","< Link >","&page=articles&content=bigprintgallery.html",{"$nulls":4},"BIGPRINT GALLERY - Display Your Best Photos Here!",11,"BIGPRINT GALLERY - Display Your Best Photos Here!\nGo to ->",2,null,"BigPrintGallery150x50.gif "]
["riz","< select lob >_banner_5","< SELECT LOB >: BANNER 5 - ","< select lob >","BANNER 5","&page=articles&content=mock.htm","< Link >","&page=articles&content=mock.htm",{"$nulls":4},"INTERACTIVE FILTER DEMO - Click Here",24,"INTERACTIVE FILTER DEMO - Click Here",24,null,"filter_demo.gif"]
["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"]