Title: Tester: Product: Focus: Revisions: Test Assumptions:
MARKETVIEW REPORTS Acceptance Criteria Dong Tran OCS MarketView Reports Do reports and all apps perform the minimum necessary criteria.
Windows 95 and Windows 98 only.
Functional Area ID Import/Validate IVMF01 MarketView File IVMF02 IVMF03 IVMF04 IVMF05 IVMF06 IVMF07 IVMF08 IVMF09 IVMF10 IVMF11 IVMF12 IVMF13 IVMF14 IVMF15 IVMF16 IVMF17 IVMF18 IVMF19 IVMF20 IVMF21 IVMF22 IVMF23 Import/Validate IVARF1 Agency Ref File IVARF2
Spec ID
Business Rule Verify bogus entry at Text File text box when click Process and return to wizard. Verify non entry at PDS Year pops up error warning that entry required and return to wizard. Verify Cancel will kill dialog without changing data. Verify "Verify File Structure" operation works on correct Outcome tape file format (only item checked). Verify "Verify File Structure" operation precludes incorrect Outcome tape file format (only item checked). Verify "Import Data" operation creates mdb file and table(s) (only item checked). Verify "Scrub Data" operation creates table(s) (only item checked). Verify "Scrub Data" operation scrubs values (only item checked). Verify "Verify Data in File" operation creates table (only item checked). Verify "Verify Data in File" S1 Null check. Verify "Verify Data in File" S9 Null check. Verify "Verify Data in File" S22 Null check. Verify "Verify Data in File" S23 Null check. Verify "Verify Data in File" S25 Null check. Verify "Verify Data in File" S10/S11 end date - start date < 11 = throwaway check. Verify "Verify Data in File" Missing fields check (if 70% or more then throwaway record). Verify [Error Fields] field has no trailing comma or space Verify Fatal vs. Accepted [XErrorFatal] value Verify [CountOfMissingFields] count Verify final warehouse database + tables created Verify proper records uploaded to warehouse Verify proper numeric values in all fields, where RAW table right character is non-numeric (ASK LISA how on all fields) VERY IMPORTANT CHANGE occurred here. Verify proper numeric values in all fields, where decimal = 2 (ASK LISA how on all fields) Verify Cancel will kill dialog without changing data if user decide not want to run. Verify REF_Agency data updated for fields: [Address1], [City], [Zipcode], and [PhoneNumber] P/F P P P P P P P P P
P P P
P P
Functional Area ID Upload Agency UAC1 Contacts UAC2 UAC3 UAC4 UAC5 Build Report Batches UAC6 BRB1 BRB2 BRB3 BRB4 BRB5 BRB6 BRB7 BRB8 BRB9 AdmBEW1 AdmBEW2 AdmBEW3 AdmBEW4 AdmBEW5 AdmBEW6 AdmBEW7 AdmBEW8 AdmBEW9 AdmBEW10 AdmBEW11 AdmBEW12 AdmBEW13 AdmBEW14 AdmBEW15 AdmBEW16 AdmBEW17 AdmBEW18 AdmBEW19 AdmBEW20 AdmBEW21 AdmBEW22 AdmBEW23 AdmBEW24
Spec ID
Business Rule Verify cannot leave Product Year blank and run wizard Verify "REF_Agency_Contact" table populated by correct records from internal app Verify that only [ContactType]=9 are uploaded. Verify that all fields have correct data from [ProspectContacts] table Verify that if contacts are deleted from internal app, also deleted from REF_Agency_Contact Verify that if contacts are updated from internal app, also revised from REF_Agency_Contact Verify that re-entering and building same batch twice results in error. Verify that only product years (drop down, Step 2) having data available are displayed Verify that Admin only reports can be created. Verify that Agency only reports can be created. Verify that both Admin and Agency reports can be created. Verify creation RPT_Batch record for new batch. Verify that leaving PDS Year drop down blank results in pre-empted error--not unhandled error. Verify that leaving batch name blank results in pre-empted error--not unhandled error. Verify that leaving all checkboxes blank will result in pre-empted error--not unhandler error. Verify that leaving report batch blank will result in pre-empted error message--not unhandled error. Verify that can print Data Integrity report only (leave Admin blank) Verify that can print Admin report only (leave Data Integrity blank) Verify that can print all combinations of Admin reports (leave MSA/State/City all blank) Verify that can print specific MSA Admin reports Verify that can print specific State Admin reports Verify that can print specific County Admin reports Verify that print preview works Verify that print to printer works Verify Data Integrity Report: Number of Parent Companies Verify Data Integrity Report: Number Agencies (or Records) Verify Data Integrity Report: Number MSA Codes Verify Data Integrity Report: Number Agencies/Records with Fatal Errors Verify Data Integrity Report: Number Agencies/Records with Non-Fatal (Accepted) Errors Verify Data Integrity Report: Percent with Incomplete Records Verify Data Integrity Report: Percent Missing MSA Code Verify Data Integrity Report: Percent Missing County Code Verify Data Integrity Report: Percent Missing State Code Verify Data Integrity Report: Percent with Too Short a Submittal Period Verify Agency List Report: only MSA selected is printed for third grouping tier Verify Agency List Report: only State selected is printed for second grouping tier Verify Agency List Report: only County selected is printed for highest level tier Verify Agency List Report: MSA belongs to County, County belongs to State, State belongs to Region Verify Agency List Report: Medicare number belongs to Agency name in report P/F P P
P P
Admin Batch Execution Wizard
P P P P
Functional Area Admin Batch Execution Wizard
ID AdmBEW25
Spec ID
Business Rule P/F Verify Agency List Report: Parent ID belongs to medicare number (S1)
AdmBEW26 AdmBEW27 AdmBEW28 AdmBEW29 AdmBEW30 Agency Batch AgBEW1 Execution AgBEW2 Wizard AgBEW3 AgBEW4 AgBEW5 AgBEW6 AgBEW7 AgBEW8 AgBEW9 AgBEW10 AgBEW11 AgBEW12 AgBEW13 AgBEW14 AgBEW15 AgBEW16 AgBEW17 AgBEW18 AgBEW19 AgBEW20 AgBEW21 AgBEW22 AgBEW23 AgBEW24 AgBEW25 AgBEW26
Verify Agency List Report: Address belongs to medicare number (S1) Verify Agency List Report: Phone number belongs to medicare number (S1) Verify Agency List Report: Count belongs to medicare number (S1) Verify Agency List Report: Type of Control belongs to medicare number (S1) [Check for at least one that should print and be sure it does] Verify Agency List Report: Small HHA belongs to medicare number (S1) [Check for at least one that should print and be sure it does] Verify that leaving report batch blank will result in pre-empted error message--not unhandled error. Verify that can print Title Page report only Verify that can print Competitor Profile report only Verify that can print Competitor Profile Drill Down Total Visits report only Verify that can print Competitor Profile Drill Down Cost/Visit report only Verify that can print Drugs, Supplies, and DME report only Verify that can print Market Share graph only Verify that can print Market Share Bubble graph only Verify that can print Competitor Profile Total Visits graph only Verify that can print Competitor Profile Cost/Visit graph only Verify that print preview works Verify that print to printer works Verify that leaving agency blank results in pre-empted error message--not unhandled error. Verify that all/only agencies who purchased MarketView available in Step 3 pick Agency listbox Verify Title Page Report: Medicare ID, OCSID, and Agency Name Verify Title Page Report: Period against WH_MarketView_01 for agency Verify Title Page Report: Contact info fields (person, address, phone, fax, email, etc.) Verify Competitor Profile Report: Organization, Area, and Period page header values match selection in wizard Verify Competitor Profile Report: All providers in detail section of report belong to same MSA as main agency Verify Competitor Profile Report: Total Patients = S82 value for all agencies Verify Competitor Profile Report: % of Total = S82 / Sum(S82) for all agencies on page (not for all in MSA) Verify Competitor Profile Report: Total Visits = S76 for all agencies Verify Competitor Profile Report: Total Visits Per Patient = S76 / S82 Verify Competitor Profile Report: VAR Total Visits Per Patient = Total Visits Per Patient first row - Total Visits Per Patient current row. Verify Competitor Profile Report: Total Cost Per Visit = (S262+S263+S264+S265+S266) / S76 Verify Competitor Profile Report: VAR Total Cost Per Visit = Total Cost Per Visit first row - Total Cost Per Visit current row.
P P P P P P P P P P P P P
Functional Area
ID AgBEW27 AgBEW28 AgBEW29 AgBEW30 AgBEW31 AgBEW32 AgBEW33 AgBEW34 AgBEW35 AgBEW36 AgBEW37 AgBEW38 AgBEW39 AgBEW40 AgBEW41 AgBEW42 AgBEW43 AgBEW44 AgBEW45 AgBEW46 AgBEW47 AgBEW48 AgBEW49 AgBEW50
Spec ID
Business Rule P/F Verify Competitor Profile Report: Sorting order (field and direction) Verify Competitor Profile Report: Note #3 should be visible if more than 11 agencies including main report agency exist. Verify Competitor Profile Report: Note #3 should be *not* visible if less than 11 agencies including main report agency exist. Verify Market Share Graph: Organization, Area, and Period page header values match selection in wizard Verify Market Share Graph: All providers in detail section of report belong to same MSA as main agency Verify Market Share Graph: S82 Values (and % of Total) Verify Market Share Graph: No values / markers go off of the page/get truncated are too small to distinguish, etc. Verify Market Share Graph: Note #1 should be visible if more than 11 agencies including main report agency exist. Verify Market Share Graph: Note #1 should be *not* visible if less than 11 agencies including main report agency exist. Verify Market Share Graph: Agency values sorted properly, so only largest 11 (by sort column) are displayed Verify Market Share Bubble Graph: Organization, Area, and Period page header values match selection in wizard Verify Market Share Bubble Graph: All providers in detail section of report belong to same MSA as main agency Verify Market Share Bubble Graph: S82 Values (and % of Total) = Size of bubble Verify Market Share Bubble Graph: Total Visits/Patient (y-axis) matches value in Competitor Profile Report Verify Market Share Bubble Graph: Total Cost/Visit (x-axis) matches value in Competitor Profile Report Verify Market Share Bubble Graph: No values / markers go off of the page/get truncated are too small to distinguish, etc. Verify Market Share Bubble Graph: Note #1 should be visible if more than 11 agencies including main report agency exist. Verify Market Share Bubble Graph: Note #1 should be *not* visible if less than 11 agencies including main report agency exist. Verify Market Share Bubble Graph: Smaller bubbles should never be hidden behind larger bubbles (order displayed should preclude this). Verify Market Share Bubble Graph: Agency values sorted properly, so only largest 11 (by sort column) are displayed Verify Competitor Profile Graph Cost/Visit: Organization, Area, and Period page header values match selection in wizard Verify Competitor Profile Graph Cost/Visit: All providers in detail section of report belong to same MSA as main agency Verify Competitor Profile Graph Cost/Visit: Total Cost Per Visit = (S262+S263+S264+S265+S266) / S76 bar value Verify Competitor Profile Graph Cost/Visit: No values / markers go off of the page/get truncated are too small to distinguish, etc.
Functional Area
ID AgBEW51 AgBEW52 AgBEW53 AgBEW54 AgBEW55 AgBEW56 AgBEW57 AgBEW58 AgBEW59 AgBEW60 AgBEW61 AgBEW62 AgBEW63 AgBEW64 AgBEW65 AgBEW66 AgBEW67 AgBEW68 AgBEW69 AgBEW70 AgBEW71 AgBEW72 AgBEW73 AgBEW74 AgBEW75
Spec ID
Business Rule P/F Verify Competitor Profile Graph Cost/Visit: Note #1 should be visible if more than 11 agencies including main report agency exist. Verify Competitor Profile Graph Cost/Visit: Note #1 should be *not* visible if less than 11 agencies including main report agency exist. Verify Competitor Profile Graph Cost/Visit: At right edge of bar, value in dollars and cents listed Verify Competitor Profile Graph Cost/Visit: Agency values sorted properly, so only largest 11 (by sort column) are displayed Verify Competitor Profile Graph Visits/Patient: Organization, Area, and Period page header values match selection in wizard Verify Competitor Profile Graph Visits/Patient: All providers in detail section of report belong to same MSA as main agency Verify Competitor Profile Graph Visits/Patient: Total Visits/Patient = S76/S82 bar value Verify Competitor Profile Graph Visits/Patient: No values / markers go off of the page/get truncated are too small to distinguish, etc. Verify Competitor Profile Graph Visits/Patient: Note #1 should be visible if more than 11 agencies including main report agency exist. Verify Competitor Profile Graph Visits/Patient: Note #1 should be *not* visible if less than 11 agencies including main report agency exist. Verify Competitor Profile Graph Visits/Patient: At right edge of bar, value as whole number is listed Verify Competitor Profile Graph Visits/Patient: Agency values sorted properly, so only largest 11 (by sort column) are displayed Verify Competitor Profile Drill-Down Total Visits Report: Organization, Area, and Period page header values match selection in wizard Verify Competitor Profile Drill-Down Total Visits Report: All providers in detail section of report belong to same MSA as main agency Verify Competitor Profile Drill-Down Total Visits Report: Note #3 should be visible if more than 11 agencies including main report agency exist. Verify Competitor Profile Drill-Down Total Visits Report: Note #3 should be *not* visible if less than 11 agencies including main report agency exist. Verify Competitor Profile Drill-Down Total Visits Report: Agency values sorted properly, so only largest 11 (by sort column) are displayed Verify Competitor Profile Drill-Down Total Visits Report: All VARIANCE columns should equal the value in the top row of column to the left minus the value in the same row of column to the left Verify Competitor Profile Drill-Down Total Visits Report: All values shown should be in numeric long integer, with no decimal portion, with commas present as 1000's separator, bold at variance column values, etc. Verify Competitor Profile Drill-Down Total Visits Report: Skilled Nursing = S38 for agency Verify Competitor Profile Drill-Down Total Visits Report: PT = S44 for agency Verify Competitor Profile Drill-Down Total Visits Report: OT = S50 for agency Verify Competitor Profile Drill-Down Total Visits Report: Speech Path = S56 for agency Verify Competitor Profile Drill-Down Total Visits Report: Social Svcs = S62 for agency Verify Competitor Profile Drill-Down Total Visits Report: HH Aide = S68 for agency
Functional Area
ID AgBEW76 AgBEW77 AgBEW78 AgBEW79 AgBEW80 AgBEW81 AgBEW82 AgBEW83
Spec ID
Business Rule P/F Verify Competitor Profile Drill-Down Total Visits Report: Total = S76 for agency Verify Competitor Profile Drill-Down Cost/Visit Report: Organization, Area, and Period page header values match selection in wizard Verify Competitor Profile Drill-Down Cost/Visit Report: All providers in detail section of report belong to same MSA as main agency Verify Competitor Profile Drill-Down Cost/Visit Report: Note #3 should be visible if more than 11 agencies including main report agency exist. Verify Competitor Profile Drill-Down Cost/Visit Report: Note #3 should be *not* visible if less than 11 agencies including main report agency exist. Verify Competitor Profile Drill-Down Cost/Visit Report: Agency values sorted properly, so only largest 11 (by sort column) are displayed Verify Competitor Profile Drill-Down Cost/Visit Report: All VARIANCE columns should equal the value in the top row of column to the left minus the value in the same row of column to the left Verify Competitor Profile Drill-Down Cost/Visit Report: All values shown should be in dollars (no cents/decimal portion), with commas present as 1000's separator, bold at variance column values, () for negative values, etc. Verify Competitor Profile Drill-Down Cost/Visit Report: Verify Competitor Profile Drill-Down Cost/Visit Report: Verify Competitor Profile Drill-Down Cost/Visit Report: Verify Competitor Profile Drill-Down Cost/Visit Report: Verify Competitor Profile Drill-Down Cost/Visit Report: Skilled Nursing = S825 / S38 PT = S835 / S44 OT = S845 / S50 Speech Path = S855 / S56 Social Svcs = S865 / S62
AgBEW84 AgBEW85 AgBEW86 AgBEW87 AgBEW88
Functional Area
ID AgBEW89 AgBEW90 AgBEW91 AgBEW92 AgBEW93 AgBEW94 AgBEW95 AgBEW96 AgBEW97 AgBEW98 AgBEW99 AgBEW100 AgBEW101 AgBEW102 AgBEW103 AgBEW104 AgBEW105 AgBEW106
Spec ID
Business Rule P/F Verify Competitor Profile Drill-Down Cost/Visit Report: HH Aide = S875 / S68 Verify Competitor Profile Drill-Down Cost/Visit Report: Total = Sum(S825+S835+S845+S855+S865+S875)/S76 Verify Drugs, DME, and Supplies Report: Organization, Area, and Period page header values match selection in wizard Verify Drugs, DME, and Supplies Report: All providers in detail section of report belong to same MSA as main agency Verify Drugs, DME, and SuppliesReport: Note #3 should be visible if more than 11 agencies including main report agency exist. Verify Drugs, DME, and Supplies Report: Note #3 should be *not* visible if less than 11 agencies including main report agency exist. Verify Drugs, DME, and Supplies Cost/Visit Report: Agency values sorted properly, so only largest 11 (by sort column) are displayed Verify Drugs, DME, and Supplies Report: All VARIANCE columns should equal the value in the top row of column to the left minus the value in the same row of column to the left Verify Drugs, DME, and Supplies Report: All values shown should be in dollars (no cents/decimal portion), with commas present as 1000's separator, bold at variance column values, () for negative values, etc. Verify Drugs, DME, and Supplies Report: Drugs, Total Cost = S894 Verify Drugs, DME, and Supplies Report: Drugs, Total Cost/Patient = S894 / S82 Verify Drugs, DME, and Supplies Report: Drugs, Non-PT Sales = S1132 Verify Drugs, DME, and Supplies Report: DME, Total Cost = S904 Verify Drugs, DME, and Supplies Report: DME, Total Cost/Patient = S904 / S82 Verify Drugs, DME, and Supplies Report: DME, Non-PT Sales = S1131 Verify Drugs, DME, and Supplies Report: Supplies, Total Cost = S885 Verify Drugs, DME, and Supplies Report: Supplies, Total Cost/Patient = S885 / S82 Verify Drugs, DME, and Supplies Report: Supplies, Non-PT Sales = S1130
Pass: Fail: Removed: Not Tested: Total:
35 21%
0% 0% 133 79%
168
ID
IVMF01 IVMF02 IVMF03 IVMF04 IVMF05 IVMF06 IVMF07 IVMF08 IVMF09 IVMF10 IVMF11 IVMF12 IVMF13 IVMF14 IVMF15 IVMF16 IVMF17 IVMF18 IVMF19 IVMF20 IVMF21 Load good file Load bogus file
Details
MV_Raw.mdb file has new table created called RAW_MarketView_01. Table should be complete load of all records in the text file. MV_Raw.mdb file has new tables SCR_MarketView_01, and SCR_MarketView_02, etc. if multiple tables included in REF_ImportSpec All right char "{"'s are stripped out of SCR_MarketView_01 (compare against RAW_MarketView_01 file). Also, verify PDS ID (Year) field and value are added to every record as PK field. MV_Raw.mdb file has new table SCR_MarketView_IDX. Query all recs with Null in S1, they should have this error in SCR_MarketView_IDX table, Errors field. Query all recs with Null in S9, they should have this error in SCR_MarketView_IDX table, Errors field. Query all recs with Null in S22, they should have this error in SCR_MarketView_IDX table, Errors field. Query all recs with Null in S23, they should have this error in SCR_MarketView_IDX table, Errors field. Query all recs with Null in S25, they should have this error in SCR_MarketView_IDX table, Errors field. Query all recs with S11-S10 should be greater than 11 months, else they should have this error in SCR_MarketView_IDX table, Errors field. Looks for all recs missing 70% or more of the fields (nulls). No comma or space after last field. Any record with S1, S11-S10, or 70% Blank errors should be flagged with 'Y'; all other errors get an 'A'; all non-errored fields are left Null. The count in table "SCR_MarketView_IDX" of blank fields should equal the number in field [CntMissFlds]. Final step of import/validate wizard is to create database "MV_Warehouse.mdb" and table "WH_MarketView_01". Query against SCR_MarketView_IDX table in Scrub database; only records without Fatal errors should be in the final warehouse (can double check record counts too).
IVMF23 IVARF1 IVARF2
Need to ask Lisa to be sure certain fields should be divided by 100 (2 decimal places), etc.
Click the wizard button at main form, click ok (assuming you have built REF table manually as message box describes); double check all fields listed to ensure now populated with correct data.
ID
UAC1 UAC2 UAC3 UAC4 UAC5 UAC6 BRB1 BRB2 BRB3 BRB4 BRB5 BRB6 BRB7 BRB8 BRB9 AdmBEW1 AdmBEW2 AdmBEW3 AdmBEW4 AdmBEW5 AdmBEW6 AdmBEW7 AdmBEW8 AdmBEW9 AdmBEW10 AdmBEW11 AdmBEW12 AdmBEW13 AdmBEW14 AdmBEW15 AdmBEW16 AdmBEW17 AdmBEW18 AdmBEW19 AdmBEW20 AdmBEW21 AdmBEW22 AdmBEW23 AdmBEW24 SELECT COUNT(S1) FROM SCR_MarketView_01 WHERE S3 IS NOT NULL SELECT COUNT(S1) FROM SCR_MarketView_01 SELECT S25 FROM SCR_MarketView_01 GROUP BY S25 SELECT COUNT(S1) FROM SCR_MarketView_IDX WHERE XErrFatal = 'Y' SELECT COUNT(S1) FROM SCR_MarketView_IDX WHERE XErrFatal = 'A' SELECT COUNT(S1) FROM SCR_MarketView_IDX WHERE XErrDescr LIKE '*Missing Values*' SELECT COUNT(S1) FROM SCR_MarketView_01 WHERE S25 IS NULL SELECT COUNT(S1) FROM SCR_MarketView_01 WHERE S23 IS NULL SELECT COUNT(S1) FROM SCR_MarketView_01 WHERE S22 IS NULL SELECT COUNT(S1) FROM SCR_MarketView_01 WHERE CDATE(S11) - CDATE(S10) < 11 * 30.4 Be sure email is not in the phone number field, etc.
Details Click Upload wiz button, select PDS Year, Click Ok. View REF_Agency_Contact. Should contain recs from InternalApplication.mdb, table [Prospect_Contacts] where provider number [S1] field equals [M0010] field in [AgencyCharacteristics] table that in turn links to [Prospect_Contacts].
Temporarily change type of contact in production internal app table (BE SURE to change back as this is live data). This in effect is similar to deleting rec. Rec should be deleted from REF_Agency_Contact table next time run Upload Wizard. Temporarily change name of contact person in internal app table (BE SURE to change back). Rec should also change in REF_Agency_Contact table next time run Upload wizard. Step 1 of this wizard, re-enter name from a previous batch. Should fail. Cross-check against WH_MarketView_01 records, PDS_ID Run wizard. At step 3, check mark only Admin. Click Finish. Goto RPT_Definition table and count records. Should be only RPT_Type_ID 2 and 3 (Data Integrity and Agency List) types only. Should be only 1 data integrity report (for the single year dataset loaded), and over a thousand agency list reports (one for each MSA/State/and city). Run wizard. At step 3, check mark only Agency. Click Finish. Goto RPT_Definition table and count records. Should be one of every report type for each agency (except admin report types 2 and 3). Only agencies that have purchased the data will have reports generated as indicated by [bPurchasedMarketView] flag field in REF_Agency table. Run wizard. At step 3, check mark both Admin and Agency. Click Finish. Expected results are combined results of previous two test cases. RPT_Batch table should have new record built. Record should have correct count of reports built in corresponding field.
'11 months times 30.4 days/months
Query data to confirm that all report output (multiple different report types) follows this business rule using field S22, S23, S25, etc (see table spec paper copy, or table REF_ImportSpec)
ID
AdmBEW25
Details
AdmBEW26 AdmBEW27 AdmBEW28 AdmBEW29
AdmBEW30
AgBEW1 AgBEW2 AgBEW3 AgBEW4 AgBEW5 AgBEW6 AgBEW7 AgBEW8 AgBEW9 AgBEW10 AgBEW11 AgBEW12 AgBEW13 AgBEW14 AgBEW15 AgBEW16 AgBEW17 AgBEW18 REF_Agency_Contact table values should sink up for this agency. Cross compare to internal app [Prospect_Contacts] linked table (ContactType=9 for MarketView) SELECT * FROM REF_Agency WHERE bPurchasedMarketView = True … should be same agencies listed in this query as those in list box. ALSO, further check to be sure that only agencies for which data for the given PDS year are selected. Cross compare to REF_Agency in this database, and AgencyCharacteristics table of internal app (linked table).
AgBEW19
AgBEW20 AgBEW21 AgBEW22 AgBEW23 AgBEW24
Lookup field in WH_MarketView_01
AgBEW25 AgBEW26
ID
AgBEW27 AgBEW28 If 54 agencies in MSA, then 43 should be the number of agencies in note #3 which should be visible.
Details
AgBEW29
If 8 agencies in MSA, then note #3 not displayed.
AgBEW30 AgBEW31 AgBEW32 AgBEW33 Add up S82 values for those agencies in Competitor Profile Report and divide each separate S82 by this sum. Also, the % of Total on the Competitor Profile Report should also show up with identical values on the graph.
AgBEW34
If 54 agencies in MSA, then 43 should be the number of agencies in note #1 which should be visible.
AgBEW35
If 8 agencies in MSA, then note #1 not displayed.
AgBEW36 AgBEW37
AgBEW38
AgBEW39 AgBEW40 AgBEW41 AgBEW42
AgBEW43
AgBEW44
AgBEW45
AgBEW46
AgBEW47
AgBEW48
AgBEW49
AgBEW50
ID
AgBEW51
Details
AgBEW52
AgBEW53 AgBEW54
Values should match Competitor Profile report.
AgBEW55
AgBEW56
AgBEW57 AgBEW58
AgBEW59
AgBEW60
AgBEW61 AgBEW62
AgBEW63
AgBEW64
AgBEW65
AgBEW66
AgBEW67
AgBEW68
AgBEW69
AgBEW70 AgBEW71 AgBEW72 AgBEW73 AgBEW74 AgBEW75
ID
AgBEW76 AgBEW77
Details
AgBEW78
AgBEW79
AgBEW80
AgBEW81
AgBEW82
AgBEW83
AgBEW84 AgBEW85 AgBEW86 AgBEW87 AgBEW88
ID
AgBEW89 AgBEW90 AgBEW91
Details
AgBEW92
AgBEW93
AgBEW94
AgBEW95
AgBEW96
AgBEW97
AgBEW98 AgBEW99 AgBEW100 AgBEW101 AgBEW102 AgBEW103 AgBEW104 AgBEW105 AgBEW106 0 0