Excel Sample Sheet 41112 | 6 Stars Data Entry Template

Partial file snippet.

Sheet 1: Intro

	
	
		
 
		
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
 
		
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		

 


Sheet 2: Data Entry

	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
		If missing, leave blank. Do NOT use 99. 
		1_Date
		
		Must press spacebar after time is entered and incidate AM or PM.  Indicate missing values by leaving cell blank - DO NOT USE 99. 
		1a_ST
		
		Must press spacebar after time is entered and incidate AM or PM. Indicate missing values by leaving cell blank - DO NOT USE 99. 
		1b_ET
		
		Surveys with a blank cell for ST and ET should also have a blank cell for Duration.  Drag formula down to make sure that all surveys with a valid ST and ET have a Duration.  The formula is =C2-B2
		1c_Duration
		
		Coder Name/ID

		2_CN
		
		Store Name/ID.
		3a_SN
		
		Store name matches assigned store name. Leave blank if box is not checked. 
		3b_SNMatch
		
		Store Address. Enter store address if available.

		4a_SA
		
		Enter "1" if actual address matches assigned address (box checked).  Leave blank if box is not checked.
		4b_SAMatch
		5a_Access
		5b_Other
		6a_Cigs
		6b_CigsMenthol
		6c_Cigarillos
		6d_LargeCigs
		6e_Chew
		6f_Ecigs
		7_StoreType
		7_Other
		8_TobaccoSold
		9_PharmCounter
		10_Alcohol
		11_GraphicWarning
		12a_Cigs
		12b_Menthol
		12c_CigNearCandy
		12d_CigAd3ft
		12e_CigPricePromo
		12f_MentholPricePromo
		13a_Cigarillos
		13b_CigarillosFlavored
		13c_CigarilloSingles
		13d_CigarillosBelow1
		13e_CigarillosNearCandy
		13f_CigarilloAd3Ft
		13g_CigarillosSelfService
		13h_CigarillosPricePromo
		14a_LargeCigars
		14b_LargeCigarsFlavored
		14e_LargeCigarsNearCandy
		14f_LargeCigarsAd3Ft
		14g_LargeCigarsSelfService
		15a_Chew
		15b_ChewFlavored
		15e_ChewNearCandy
		15f_ChewAd3Ft
		15h_ChewPricePromo
		15i_ChewCrossProductPromo
		16a_Ecigs
		16b_EcigsFlavored
		16e_EcigsNearCandy
		16f_EcigsAd3Ft
		16g_EcigsSelfService
		16h_EcigsPricePromo
		16i_EcigsCrossProductPromo
		17a_WIC
		17b_SNAP
		18a_CheapSold
		
		If missing price, leave cell blank. DO NOT ENTER 99. 
		18b_CheapPrice
		18c_CheapTax
		18d_CheapObt
		19a_NewportSold
		
		If missing price, leave cell blank. DO NOT ENTER 99. 
		19b_NewportPrice
		19c_NewportTax
		19dNewportObt
		20a_BluSold
		
		If missing price, leave cell blank. DO NOT ENTER 99. 
		20b_BluPrice
		20c_BluTax
		20d_BluObt
		
		This retail environment provides a great photo opportunity. Enter "1" if box is checked, "0" if unchecked."
		PhotoOp
		Field notes
	
	
		1/25/2014
		2:00 PM
		2:09 PM
		0:09:00
		TN
		2259
		1
		

		1
		1
		

		1
		1
		0
		0
		0
		0
		1
		

		1
		0
		1
		0
		1
		1
		0
		1
		0
		0
		1
		1
		1
		1
		0
		0
		0
		0
		0
		0
		0
		0
		0
		1
		1
		0
		0
		1
		0
		1
		1
		0
		1
		0
		0
		0
		1
		0
		1
		$8.06 
		0
		1
		1
		$9.37 
		0
		1
		1
		$9.99 
		0
		1
		0
		

	
	
		1/25/2014
		2:20 PM
		2:30 PM
		0:10:00
		TN
		1151
		1
		

		1
		1
		

		1
		1
		0
		0
		0
		0
		1
		

		1
		0
		1
		0
		1
		1
		0
		0
		0
		0
		1
		1
		1
		1
		0
		0
		1
		0
		0
		0
		0
		0
		0
		1
		1
		0
		0
		1
		0
		1
		1
		0
		1
		1
		0
		0
		1
		1
		1
		$8.00 
		1
		1
		1
		$10.10 
		1
		99
		0
		$9.99 
		0
		1
		0
		

	
	
		1/25/2014
		2:35 PM
		2:40 PM
		0:05:00
		TN
		2553
		1
		25589 West Acadia Ln. Palo Alto, CA
		

		1
		

		0
		0
		0
		0
		0
		0
		2
		

		1
		1
		0
		0
		1
		1
		0
		0
		0
		0
		1
		1
		1
		1
		0
		0
		1
		0
		0
		0
		0
		0
		0
		1
		1
		0
		0
		0
		0
		1
		1
		0
		1
		1
		0
		0
		1
		1
		1
		$10.00 
		1
		1
		1
		$10.00 
		1
		1
		1
		$8.97 
		1
		1
		0
		

	
	
		1/29/2014
		4:03 PM
		4:15 PM
		0:12:00
		SB
		The Corner Store
		1
		

		1
		1
		

		0
		0
		0
		0
		0
		0
		1
		

		1
		0
		1
		0
		1
		1
		1
		0
		0
		0
		1
		1
		1
		1
		1
		0
		1
		0
		1
		1
		0
		0
		99
		1
		1
		0
		0
		0
		0
		1
		1
		0
		0
		0
		0
		0
		1
		1
		1
		$7.60 
		0
		1
		1
		$9.23 
		99
		1
		1
		$10.99 
		99
		1
		1
		Cigarillos and cigarettes located near candy 
	
	
		1/29/2014
		5:30 PM
		5:32 PM
		0:02:00
		TJ
		Smoke Shop
		

		223 Lakewood Dr. Palo Alto, CA
		

		4
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		1/28/2014
		9:10 AM
		9:18 AM
		0:08:00
		CP
		Mike's shop
		

		1592 Downtown Ln. Palo Alto, CA 
		

		1
		

		0
		0
		0
		0
		0
		0
		4
		

		1
		1
		1
		0
		1
		1
		0
		0
		0
		0
		1
		1
		1
		1
		0
		0
		0
		0
		1
		1
		0
		0
		0
		1
		1
		0
		0
		1
		0
		1
		1
		0
		0
		0
		0
		0
		0
		0
		1
		$7.10 
		0
		1
		1
		$9.35 
		0
		1
		0
		$9.99 
		0
		2
		1
		Other e-cigarettes in store had cartoon characters on packaging
	
	
		1/28/2014
		10:00 AM
		10:07 AM
		0:07:00
		CP
		Walgreens
		

		979 East Broadway Rd. Palo Alto, CA
		

		1
		

		1
		1
		0
		0
		1
		0
		2
		

		1
		1
		0
		0
		1
		1
		0
		0
		0
		0
		1
		1
		1
		1
		0
		0
		0
		0
		0
		0
		0
		0
		0
		1
		0
		0
		0
		0
		0
		1
		1
		0
		0
		0
		0
		0
		0
		0
		1
		

		99
		99
		1
		$9.96 
		0
		1
		1
		$9.99 
		0
		2
		0
		

	
	
		

		

		

		

		CP
		Safeway 
		

		5252 Troon Cir. Palo Alto, CA
		

		1
		

		0
		0
		0
		0
		0
		0
		4
		

		1
		1
		1
		0
		1
		1
		0
		0
		0
		0
		1
		1
		1
		1
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		1
		1
		0
		0
		0
		0
		0
		0
		0
		1
		$6.99 
		0
		1
		1
		$9.37 
		0
		1
		1
		$9.99 
		0
		1
		0
		

	
	
		1/29/2014
		4:23 PM
		4:30 PM
		0:07:00
		CP
		Exxon 
		

		42 North Golden Ave. Palo Alto, CA
		

		1
		

		0
		1
		0
		0
		0
		0
		1
		

		1
		0
		1
		0
		1
		1
		0
		0
		0
		0
		1
		1
		1
		1
		1
		0
		0
		1
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		1
		1
		0
		0
		0
		0
		0
		0
		0
		1
		$7.95 
		1
		1
		1
		$10.05 
		1
		1
		1
		$10.61 
		1
		1
		99
		

	
	
		1/29/2014
		5:12 PM
		5:20 PM
		0:08:00
		CP
		Dave's liquor
		

		492 Park Ln. Palo Alto, CA 
		

		1
		

		1
		1
		1
		0
		0
		1
		3
		

		1
		0
		1
		0
		1
		1
		0
		0
		1
		1
		1
		1
		0
		1
		0
		0
		0
		0
		1
		1
		0
		0
		1
		0
		0
		0
		0
		0
		0
		1
		1
		0
		0
		0
		1
		0
		0
		0
		1
		$7.85 
		1
		1
		1
		$9.95 
		1
		1
		1
		$9.99 
		1
		1
		0

The words contained in this file might help you see if this file matches what you are looking for:

...Sheet intro data entry if missing leave blank do not use date must press spacebar after time is entered and incidate am or pm indicate values by leaving cell a st b et surveys with for should also have duration drag formula down to make sure that all valid the cb c coder nameid cn store sn name matches assigned box checked snmatch address enter available sa quot actual samatch access other cigs cigsmenthol cigarillos d largecigs e chew f ecigs storetype tobaccosold pharmcounter alcohol graphicwarning menthol cignearcandy cigadft cigpricepromo mentholpricepromo cigarillosflavored cigarillosingles cigarillosbelow cigarillosnearcandy cigarilloadft g cigarillosselfservice h cigarillospricepromo largecigars largecigarsflavored largecigarsnearcandy largecigarsadft largecigarsselfservice chewflavored chewnearcandy chewadft chewpricepromo i chewcrossproductpromo ecigsflavored ecigsnearcandy ecigsadft ecigsselfservice ecigspricepromo ecigscrossproductpromo wic snap cheapsold price cheapprice ch...

Related files

Share

Andy yahya

Help

If missing, leave blank. Do NOT use 99. 1_Date	Must press spacebar after time is entered and incidate AM or PM. Indicate missing values by leaving cell blank - DO NOT USE 99. 1a_ST	Must press spacebar after time is entered and incidate AM or PM. Indicate missing values by leaving cell blank - DO NOT USE 99. 1b_ET	Surveys with a blank cell for ST and ET should also have a blank cell for Duration. Drag formula down to make sure that all surveys with a valid ST and ET have a Duration. The formula is =C2-B2 1c_Duration	Coder Name/ID 2_CN	Store Name/ID. 3a_SN	Store name matches assigned store name. Leave blank if box is not checked. 3b_SNMatch	Store Address. Enter store address if available. 4a_SA	Enter "1" if actual address matches assigned address (box checked). Leave blank if box is not checked. 4b_SAMatch	5a_Access	5b_Other	6a_Cigs	6b_CigsMenthol	6c_Cigarillos	6d_LargeCigs	6e_Chew	6f_Ecigs	7_StoreType	7_Other	8_TobaccoSold	9_PharmCounter	10_Alcohol	11_GraphicWarning	12a_Cigs	12b_Menthol	12c_CigNearCandy	12d_CigAd3ft	12e_CigPricePromo	12f_MentholPricePromo	13a_Cigarillos	13b_CigarillosFlavored	13c_CigarilloSingles	13d_CigarillosBelow1	13e_CigarillosNearCandy	13f_CigarilloAd3Ft	13g_CigarillosSelfService	13h_CigarillosPricePromo	14a_LargeCigars	14b_LargeCigarsFlavored	14e_LargeCigarsNearCandy	14f_LargeCigarsAd3Ft	14g_LargeCigarsSelfService	15a_Chew	15b_ChewFlavored	15e_ChewNearCandy	15f_ChewAd3Ft	15h_ChewPricePromo	15i_ChewCrossProductPromo	16a_Ecigs	16b_EcigsFlavored	16e_EcigsNearCandy	16f_EcigsAd3Ft	16g_EcigsSelfService	16h_EcigsPricePromo	16i_EcigsCrossProductPromo	17a_WIC	17b_SNAP	18a_CheapSold	If missing price, leave cell blank. DO NOT ENTER 99. 18b_CheapPrice	18c_CheapTax	18d_CheapObt	19a_NewportSold	If missing price, leave cell blank. DO NOT ENTER 99. 19b_NewportPrice	19c_NewportTax	19dNewportObt	20a_BluSold	If missing price, leave cell blank. DO NOT ENTER 99. 20b_BluPrice	20c_BluTax	20d_BluObt	This retail environment provides a great photo opportunity. Enter "1" if box is checked, "0" if unchecked." PhotoOp	Field notes
1/25/2014	2:00 PM	2:09 PM	0:09:00	TN	2259	1		1	1		1	1	0	0	0	0	1		1	0	1	0	1	1	0	1	0	0	1	1	1	1	0	0	0	0	0	0	0	0	0	1	1	0	0	1	0	1	1	0	1	0	0	0	1	0	1	$8.06	0	1	1	$9.37	0	1	1	$9.99	0	1	0
1/25/2014	2:20 PM	2:30 PM	0:10:00	TN	1151	1		1	1		1	1	0	0	0	0	1		1	0	1	0	1	1	0	0	0	0	1	1	1	1	0	0	1	0	0	0	0	0	0	1	1	0	0	1	0	1	1	0	1	1	0	0	1	1	1	$8.00	1	1	1	$10.10	1	99	0	$9.99	0	1	0
1/25/2014	2:35 PM	2:40 PM	0:05:00	TN	2553	1	25589 West Acadia Ln. Palo Alto, CA		1		0	0	0	0	0	0	2		1	1	0	0	1	1	0	0	0	0	1	1	1	1	0	0	1	0	0	0	0	0	0	1	1	0	0	0	0	1	1	0	1	1	0	0	1	1	1	$10.00	1	1	1	$10.00	1	1	1	$8.97	1	1	0
1/29/2014	4:03 PM	4:15 PM	0:12:00	SB	The Corner Store	1		1	1		0	0	0	0	0	0	1		1	0	1	0	1	1	1	0	0	0	1	1	1	1	1	0	1	0	1	1	0	0	99	1	1	0	0	0	0	1	1	0	0	0	0	0	1	1	1	$7.60	0	1	1	$9.23	99	1	1	$10.99	99	1	1	Cigarillos and cigarettes located near candy
1/29/2014	5:30 PM	5:32 PM	0:02:00	TJ	Smoke Shop		223 Lakewood Dr. Palo Alto, CA		4
1/28/2014	9:10 AM	9:18 AM	0:08:00	CP	Mike's shop		1592 Downtown Ln. Palo Alto, CA		1		0	0	0	0	0	0	4		1	1	1	0	1	1	0	0	0	0	1	1	1	1	0	0	0	0	1	1	0	0	0	1	1	0	0	1	0	1	1	0	0	0	0	0	0	0	1	$7.10	0	1	1	$9.35	0	1	0	$9.99	0	2	1	Other e-cigarettes in store had cartoon characters on packaging
1/28/2014	10:00 AM	10:07 AM	0:07:00	CP	Walgreens		979 East Broadway Rd. Palo Alto, CA		1		1	1	0	0	1	0	2		1	1	0	0	1	1	0	0	0	0	1	1	1	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	1	1	0	0	0	0	0	0	0	1		99	99	1	$9.96	0	1	1	$9.99	0	2	0
				CP	Safeway		5252 Troon Cir. Palo Alto, CA		1		0	0	0	0	0	0	4		1	1	1	0	1	1	0	0	0	0	1	1	1	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	1	0	0	0	0	0	0	0	1	$6.99	0	1	1	$9.37	0	1	1	$9.99	0	1	0
1/29/2014	4:23 PM	4:30 PM	0:07:00	CP	Exxon		42 North Golden Ave. Palo Alto, CA		1		0	1	0	0	0	0	1		1	0	1	0	1	1	0	0	0	0	1	1	1	1	1	0	0	1	0	0	0	0	0	0	0	0	0	0	0	1	1	0	0	0	0	0	0	0	1	$7.95	1	1	1	$10.05	1	1	1	$10.61	1	1	99
1/29/2014	5:12 PM	5:20 PM	0:08:00	CP	Dave's liquor		492 Park Ln. Palo Alto, CA		1		1	1	1	0	0	1	3		1	0	1	0	1	1	0	0	1	1	1	1	0	1	0	0	0	0	1	1	0	0	1	0	0	0	0	0	0	1	1	0	0	0	1	0	0	0	1	$7.85	1	1	1	$9.95	1	1	1	$9.99	1	1	0

Related files

Share

Share to social media

Andy yahya

Help

Login Area