tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 838023d1690623595-identify-unique-rows-with-conditions-deletion-with-conditions-problem
Sheet: Target Data

Reference | Questionnaire
ABB0090002 | 1 - Sent & not returned
ACF0010001 | 3 - Sent & returned complete
ACO0030001 | 3 - Sent & returned complete
ACT0010001 | 3 - Sent & returned complete
[NAME]
ADA0120001 | 3 - Sent & returned complete
ADA0120002
ADA0120003 | 3 - Sent & returned complete
ADA0120004 | 3 - Sent & returned complete
ADA0120005 | 3 - Sent & returned complete
ADD0040002
AEG0010001 | 1 - Sent & not returned
[NAME] | 1 - Sent & not returned
ALB0010010 | 3 - Sent & returned complete
[NAME] | 3 - Sent & returned complete
ALI0300001 | 1 - Sent & not returned
ALP0010001 | 1 - Sent & not returned
AME0010001 | 1 - Sent & not returned
AME0010002 | 1 - Sent & not returned
AND0180001 | 1 - Sent & not returned
AND0180002 | 1 - Sent & not returned
ANG0020006 | 3 - Sent & returned complete
APE0010003 | 1 - Sent & not returned
APE0010004 | 1 - Sent & not returned
APL0010001 | 3 - Sent & returned complete
ARC0070004 | 1 - Sent & not returned
ARD0010003 | 3 - Sent & returned complete
ARU0010006
ARU0010007 | 3 - Sent & returned complete
ARU0040002
ARU0040003
ASH0030007
ASH0030008
ASH0030009
ASH0090003 | 3 - Sent & returned complete
ASH0090004 | 3 - Sent & returned complete
ASH0220001 | 3 - Sent & returned complete
ASP0040002 | 1 - Sent & not returned
[NAME] | 1 - Sent & not returned
ATR0010003
AUC0010004 | 1 - Sent & not returned
AVE0030002 | 3 - Sent & returned complete
AVE0060005
AVE0060007
AVO0010002
AVO0010003 | 3 - Sent & returned complete
Spreadsheet: 157693d1337848956-conditional-drop-down-dependent-on-2-entries-entries1
Sheet: Sheet1

CustomerService | Phone | CustomerSuggestion | General | Other | Blank | <1st Column
PositiveFeedback | PositiveFeedback | For Customer Service | Positive Feedback | PositiveFeedback |  | <2nd Column
NegativeFeedback | NegativeFeedback | General | Negative Feedback | NegativeFeedback
Agent Communication/Understanding | Phone - Time to Resolve |  | Not satisfied with content |  |  | <Negative Entries for 3rd column
Processes | Phone - Wait Time |  | updates
General | Phone - IVR |  | Merge
Knowledge Gaps | Phone - Voice/Quality/Connection Issues
Unresolved Issue
Behavior | Phone - Time to Resolve |  |  |  |  | < Positive Entries for 3rd column
Communication | Phone - Wait Time |  | Loves the Game
Processes | Phone - IVR
General | Phone - Voice/Quality/Connection Issues
Knowledge
Spreadsheet: 58895e76-03c5-4e40-ae98-1de933095536
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
QCMV | Test | QCMV | Cytomegalovirus, Molecular Detection, Quantitative PCR, Plasma | [NAME], Quant, P | Real-Time Polymerase Chain Reaction (PCR)/DNA [NAME] (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | EDTA (lavender-top) tube: EDTA |  |  | 3 | mL | Container/Tube: Lavender top (EDTA) [NAME]: 1 mL Collection Instructions: Spin down and separate plasma within 24 hours of draw. Forms: If not ordering electronically, submit a Microbiology Request Form (Supply T244) with the specimen. | 0.3 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK  Lipemia	NA Icterus	NA Other	NA | None detected | Monday through Saturday; Varies | Same day/1 day | 3 days | 1 | 87497 |  |  |  |  | Rochester
QCMV | [NAME] | PLEDTA | [NAME] |  |  |  | Refrigerated | 7 days
QCMV | Result | 82986 | [NAME], Quant, P | [NAME], Quant, P | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 34720-3
QCMV | Result | 21863 | Copies/mL | Copies/mL | Numeric |  |  |  |  | copies/mL |  |  |  |  |  |  |  |  |  | 29604-6
QCMV | Result | 23521 | Lower 95% Confidence Interval | Lower 95% Confidence Interval | Numeric |  |  |  |  | copies/mL
QCMV | Result | 23522 | Upper 95% Confidence Interval | Upper 95% Confidence Interval | Numeric |  |  |  |  | copies/mL
Spreadsheet: 0f976898-0cfe-42ee-8f54-02f3cddc58a3
Sheet: FHA - VA Rates

 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax |  |  |  | Loan Level Price Adjustment
 |  | Rate Sheet Effective:
Product: FHA / VA Fixed Rate 30 Year |  |  |  |  |  | Price adjustments are cumulative
(Prices DO NOT include SRP)
Rate |  | 30 Day | 45 Day | 60 Day | 75 Day | and are added to price quote
 |  |  |  |  |  | Credit Score Adjustment
 |  |  |  |  |  | 640 - 659 | -0.375
 |  |  |  |  |  | 660 - 719 | 0
 |  |  |  |  |  | 720 + | 0.125
 |  |  |  |  |  | VA Adjustment | -0.25
Product: FHA / VA Fixed Rate 15 Year |  |  |  |  |  | FHA Streamline [NAME] | -0.5
(Prices DO NOT include SRP)
Rate |  | 30 Day | 45 Day | 60 Day | 75 Day | SRPs
 |  |  |  |  |  | See Government [NAME]
 |  |  |  |  |  | - 240 Terms Priced with 30 Yr base and 15 Yr SRP
 |  |  |  |  |  | Fees:
 |  |  |  |  |  | Fees for Loans TIB Underwrites
 |  | TIB FHA Fulfillment Loans |  |  |  | Underwriting | 450
Product: FHA Fixed Rate 30 Year |  |  |  |  |  | Insuring | 100
(Prices include SRP) |  |  |  |  |  | Fees for Loans Not Underwritten by TIB
Tier 1 : Rate | Rate | 30 Day | 45 Day |  |  | Administration | 150
 |  |  |  |  |  | TIB Fulfillment Loans
[NAME] : Rate
 |  |  |  |  |  | - Credit Score Adjustments Still Apply
Tier 3 : Rate |  |  |  |  |  | -SRPs are Included
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | 30 Year | 0.025
Product: FHA Fixed Rate 15 Year
(Prices include SRP) |  |  |  |  |  | 15 Year | 0.025
Tier 1 : Rate |  | 30 Day | 45 Day
 |  |  |  |  |  | State Tiers
 |  |  |  |  |  | Tier 1  -  AL, AR, FL, GA, IN, KS, KY, LA,
[NAME] : Rate |  |  |  |  |  | MO, MS, ND, NE, OH, OK, PA, TX, WI
Tier 3 : Rate |  |  |  |  |  | [NAME], CT, DE, IA, MA, ME, MI, NC,
 |  |  |  |  |  | NH, NY, RI, SC, TN, UT, VT, WY
 |  |  |  |  |  | Tier 3  -  AZ, CA, CO, DC, HI, ID, IL, MD,
Foot Notes: |  |  |  |  |  | NM, MT, NJ, NM, NV, OR, VA, WA, WV
Loans must be AUS Approved / Eligible from FHA Scorecard
 |  |  |  |  |  | Expiration Dates
Seasoning - No loans older than 60 days from Note Date to TIB |  |  |  |  |  | 15 Day
 |  |  |  |  |  | 30 Day
 | Call: [NAME], [PHONE] |  |  |  |  | 45 Day
 | E-Mail: [EMAIL] |  |  |  |  | 60 Day
Spreadsheet: 75895d1276512825-average-of-value-in-different-cells-in-multiple-worksheet-test-vsb-reco-201011-and-summary-sheet
Sheet: June'10

 |  | [NAME]
 |  | Monthly Reconciliation
 |  | 2010-06-30 00:00:00
 |  | Summary of Stocks
 |  | New Stock | Fully Paid |  | Int. Bearing |  | Free Funded |  | Totals
 |  |  | Units | Value | Units | Value | Units | Value | Units | Value
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Used Stock | Fully Paid |  | Int. Bearing |  | Free Funded |  | Totals |  | Units over | % Of Stock
 |  |  | Units | Value | Units | Value | Units | Value | Units | Value | 70 Days | Overage
 |  | Stock 1 |  |  |  |  |  |  | 0 | 0
 |  | Stock 2 |  |  |  |  |  |  | 0 | 0
 |  | Stock 3 |  |  |  |  |  |  | 0 | 0
 |  | Stock 4 |  |  |  |  |  |  | 0 | 0
 |  | Stock 5 |  |  |  |  |  |  | 0 | 0
 |  | Stock 6 |  |  |  |  |  |  | 0 | 0
 |  | Totals | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 159398d1338614722-excel-2007-data-validation-with-multiple-references-example
Sheet: January

 |  |  | Applicant Information |  |  |  |  |  |  | Policy Information |  |  |  |  | Premium Information |  |  |  | Commission Information |  |  |  |  | Premium Information |  |  |  | Life Premium Information |  |  |  |  | Annuity Premium Information |  |  |  |  |  |  | Board Call Totals
[NAME] | Age | Street Address | City | State | Zip Code | Phone |  | Policy Type | Carrier | Plan | [NAME] | Application/ Policy Number |  | Modal Premium | Multiplier | Annual Premium |  | Commission % | Total Commission | Split% | Splitting Agent | Total Split |  | Annual Premium | Split% | Total Premium |  | Annual Premium | Policy type | Split% | Total Premium |  | Annual Premium | Policy type | Split% | Total Premium |  | App | Life | Annuity | Total Premium | FYC
 | Age |  |  | State |  |  |  | Policy Type |  |  |  |  |  | 0 | 12 |  |  | 1 |  | [NAME] |  |  |  |  | [NAME] |  |  | 0 |  | 1 |  |  | 0 |  | 1
 | Age |  |  | State |  |  |  | Policy Type |  |  |  |  |  | 0 | 12 |  |  | 1 |  | [NAME] |  |  |  |  | [NAME] |  |  | 0 |  | 1 |  |  | 0 |  | 1
Age= Applicants Age
State = State of residence
Policy Type= type of product applied for
Carrier= Vendor client is applying with and is activated based on Policy Type selection
Plan Code= type of plan applied for and activates based on previous cell
Med Status= clients health status and is not dependent on previous selections
Commision % is the cumulative result of all the above stated data entered so as to auto populate the correct commision % without the user having to verify by external data
Spreadsheet: 0a379928-a7f3-47bb-908f-f8e3939b92db
Sheet: Kanal5 (Macedonia)

Kanal5 (Macedonia)
Date | Start (CET) | End (CET) | Notes
2010-11-21 00:00:00 | 15:00:00 | 17:00:00 | Round [NAME] (Singles)
2010-11-21 00:00:00 | 21:00:00 | 23:00:00 | Round [NAME] (Singles)
2010-11-22 00:00:00 | 15:00:00 | 17:00:00 | Round [NAME] (Singles)
2010-11-22 00:00:00 | 21:00:00 | 23:00:00 | Round [NAME] (Singles)
2010-11-23 00:00:00 | 15:00:00 | 17:00:00 | Round [NAME] (Singles)
2010-11-23 00:00:00 | 21:00:00 | 23:00:00 | Round [NAME] (Singles)
2010-11-24 00:00:00 | 15:00:00 | 17:00:00 | Round [NAME] (Singles)
2010-11-24 00:00:00 | 21:00:00 | 23:00:00 | Round [NAME] (Singles)
2010-11-25 00:00:00 | 15:00:00 | 17:00:00 | Round [NAME] (Singles)
2010-11-25 00:00:00 | 21:00:00 | 23:00:00 | Round [NAME] (Singles)
2010-11-26 00:00:00 | 15:00:00 | 17:00:00 | Round [NAME] (Singles)
2010-11-26 00:00:00 | 21:00:00 | 23:00:00 | Round [NAME] (Singles)
2010-11-27 00:00:00 | 15:00:00 | 17:30:00 | Semi-Final 1 - Live (Singles)
2010-11-27 00:00:00 | 21:00:00 | 23:30:00 | Semi-Final 2 - Live (Singles)
2010-11-28 00:00:00 | 18:30:00 | 21:30:00 | Singles Final - Live
Spreadsheet: chris_germany__2124__DecCohCHOICE-ENA
Sheet: Dec 18

 | COH CHOICE NOMINATIONS TO ACTUALS
 | FOR GAS DAY |  |  |  |  |  |  |  | 2000-12-18 00:00:00
 |  | MA | NOM ID |  | FT |  | AT |  | FORECASTED |  | ACTUALS |  | CONTRACT # | % Storage | Over | Sto | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FT DROP |  | AT DROP
 | COH 3-15 | 22-15 | 3342 |  |  |  |  |  | 1731 |  | 1558 |  | 67694 |  |  |  |  |  | 17 | 1 | 18
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 | 2 | 19
 | COH 5-2 | 23N-02 | 3343 |  |  |  |  |  | 7398 |  | 7721 |  | 67694 |  |  |  |  |  | 18 | 3 | 20 |  |  | 15
 |  |  |  |  |  |  |  |  | 5000 |  | 5000 |  | 68918 | 0 |  |  |  |  | 19 | 4 | 18 |  |  | 23
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22 | 5 | 22 |  |  | 15
 | COH 5-7 | 23N-07 | 3344 |  |  |  |  |  | 2905 |  | 3033 |  | 67694 |  |  |  |  |  | 19 | 6 | 20 |  |  | 22
 |  |  |  |  |  |  |  |  | 1535 |  | 1535 |  | 68915 | 0 |  |  |  |  | 19 | 7 | 18 |  |  | 15
 |  |  |  |  |  |  |  |  | 1540 |  | 1540 |  | 69693 | 0 |  |  |  |  | 22 | 8 | 23 |  |  | 14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21 | 9 | 22 |  |  | 20
 | COH 7-1 | 23-01 | 3788 |  |  |  |  |  | 20297 |  | 19644 |  | 67694 |  |  |  |  |  | 24 | 15 | 28 |  |  | 16
 |  |  |  |  |  |  |  |  | 673 |  | 673 |  | 69149 | 0 |  |  |  |  | 21 | 35 | 20 |  |  | 17
 |  |  |  |  |  |  |  |  |  |  |  |  | 68915 | 0 |  |  |  |  | 19 | 39 | 18 |  |  | 17
 |  |  |  |  |  |  |  |  |  |  |  |  | 68918 | 0 |  |  |  |  |  |  |  |  |  | 17
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22
 | COH 7-3 | 23-03 | 3789 |  |  |  |  |  | 2352 |  | 2152 |  | 67694
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | %
 | COH 7-4 | 23-04 | 3345 |  |  |  |  |  | 1761 |  | 1839 |  | 67694 |  |  |  |  |  | Storage
 |  |  |  |  |  |  |  |  | 1915 |  | 1915 |  | 68916 | 0 |  |  |  |  | #67694
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.4
 | COH 7-5 | 23-05 | 2777 |  |  |  |  |  | 17266 |  | 17266 |  | 67694
 | COH 7-6 | 23-06 | 3346 |  |  |  |  |  | 2870 |  | 2765 |  | 67694
 | COH 7-8 | 23-08 | 3790 |  |  |  |  |  | 4954 |  | 4839 |  | 67694
 | COH 7-9 | 23-09 | 3791 |  |  |  |  |  | 5184 |  | 5040 |  | 67694
 | COH 8-35 | 24-35 | 3348 |  |  |  |  |  | 1367 |  | 1446 |  | 67694 | 1
 |  |  |  |  |  |  |  |  | 1000 |  | 1000 |  | 69823 | 0
 | COH 8-39 | 24-39 | 3792 |  |  |  |  |  | 53 |  | 54 |  | 67694 | 1
 |  |  |  |  |  |  |  | x | 1.Nom to COH |  | 1. Email to COH |  |  |  |  |  |  | FOM
 |  |  |  |  |  |  |  | x | 2.Email to ENA |  | 2. Email to ENA |  |  |  |  |  |  | [NAME] from/(Sell to) ENA
Spreadsheet: richard_ring__31677__EMR Prices
Sheet: Sheet1

 |  | Peak |  | Off-Peak
Region | Delivery Date | Low | High | Low | High
Red numbers indicate flat, 24-hour products.
NW/N. Rock | 2001-10-21 00:00:00 | 23 | 25.5 | 21.5 | 22.25
Mid-Columbia | 2001-10-21 00:00:00 | 23 | 25.5 | 21.5 | 22.25
COB | 2001-10-21 00:00:00 | 25.25 | 27 | 22 | 24
N. California | 2001-10-21 00:00:00 | 25.5 | 26.75 | 23 | 24.5
Midway/Sylmar | 2001-10-21 00:00:00 | NA | NA | NA | NA
S. California | 2001-10-21 00:00:00 | 25.75 | 27.15 | 21 | 22.5
Mead | 2001-10-21 00:00:00 | 25.5 | 26.5 | 20 | 22.5
Palo Verde | 2001-10-21 00:00:00 | 25.5 | 28 | 20.5 | 22.25
Inland SW | 2001-10-21 00:00:00 | 25.5 | 28 | 20.5 | 22.5
4-Corners | 2001-10-21 00:00:00 | 23 | 26 | 20 | 21.25
Central Rockies | 2001-10-21 00:00:00 | 21 | 23.5 | 13.5 | 18
NW/N. Rock | 2001-10-22 00:00:00 | 23 | 25.5 | 21.5 | 22.25
Mid-Columbia | 2001-10-22 00:00:00 | 23 | 25.5 | 21.5 | 22.25
COB | 2001-10-22 00:00:00 | 25.25 | 27 | 22 | 24
N. California | 2001-10-22 00:00:00 | 25.5 | 26.75 | 23 | 24.5
Midway/Sylmar | 2001-10-22 00:00:00 | NA | NA | NA | NA
S. California | 2001-10-22 00:00:00 | 25.75 | 27.15 | 21 | 22.5
Mead | 2001-10-22 00:00:00 | 25.5 | 26.5 | 20 | 22.5
Palo Verde | 2001-10-22 00:00:00 | 25.5 | 28 | 20.5 | 22.25
Inland SW | 2001-10-22 00:00:00 | 25.5 | 28 | 20.5 | 22.5
4-Corners | 2001-10-22 00:00:00 | 23 | 26 | 20 | 21.25
Central Rockies | 2001-10-22 00:00:00 | 21 | 23.5 | 13.5 | 18
Spreadsheet: 824127d1680319532-auto-fill-cell-book1
Sheet: sheet1

 |  |  |  | AM |  |  | PM
 |  |  | Sign on |  | Sign Off |  | Sign on |  | Sign Off
 |  | 1 |  |  |  |  | 14:45:00 |  | 16:45:00
 |  | 5551 | 07:15:00 |  | 08:50:00 |  | 14:45:00 |  | 17:30:00
 |  | 5552 | 07:00:00 |  | 08:50:00 |  | 14:45:00 |  | 16:40:00
 |  | 5553 | 06:30:00 |  | 09:00:00 |  | 14:00:00 |  | 17:00:00
 |  | 5554 | 07:00:00 |  | 08:50:00 |  | 14:00:00 |  | 16:30:00
 | MONDAY | DATE: | 2023-03-31 00:00:00
 |  | ID # | SIGN ON |  | SIGN OFF |  | Sign on |  | Sign Off
 |  | 5551 | 07:15:00 | AM | 08:50:00 | AM | 14:45:00 | PM | 16:45:00 | PM
 |  | 5554 |  | AM |  | AM |  | PM |  | PM |  | auto fill time from 5554
 |  | 0
 | TUESDAY | DATE:
 |  | ID # | SIGN ON |  | SIGN OFF
 |  | 1 | 00:00:00 | AM | 00:00:00 | AM |  | PM | 0 | PM |  | auto fill time from 001
 |  | 5552 | 00:00:00 | AM | 00:00:00 | AM |  | PM | 0 | PM |  | auto fill time from 5552
 | WEDNESDAY | DATE:
 |  | ID # | SIGN ON |  | SIGN OFF
 |  | 5553 | 00:00:00 | AM | 00:00:00 | AM |  | PM | 0 | PM |  | auto fill time from 5553
 |  | 1 | 00:00:00 | AM | 00:00:00 | AM |  | PM | 0 | PM |  | auto fill time from 001
 |  | how do I autofill the time slots according to the ID# input
Spreadsheet: john_griffith__16136__1_24_02OH
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | HO G2 | 53 | 200 | 275 | 45.1 | 62.1 | 1.79 | 2002-01-24 10:44:00
 | [NAME] | 53 | 600 | 680 | 48.1 | 54.5 | 1.71 | 2002-01-24 10:44:00
 | HO J2 | 53 | 825 | 925 | 48.5 | 54.4 | 1.71 | 2002-01-24 10:44:00
 | HO K2 | 53 | 960 | 1040 | 46 | 49.9 | 1.6 | 2002-01-24 10:44:00
 | HO M2 | 54 | 1150 | 1250 | 46.6 | 50.6 | 1.65 | 2002-01-24 10:44:00
 | HO N2 | 54 | 1125 | 1225 | 41.3 | 45 | 1.46 | 2002-01-24 10:44:00
 | HO Q2 | 55 | 1200 | 1300 | 39.6 | 42.9 | 1.43 | 2002-01-24 10:44:00
 | HO U2 | 57 | 1250 | 1375 | 36.8 | 40.5 | 1.39 | 2002-01-24 10:44:00
 | [NAME] | 57 | 1300 | 1450 | 36.1 | 40.3 | 1.37 | 2002-01-24 10:44:00
 | HO X2 | 57 | 1400 | 1550 | 36.7 | 40.6 | 1.39 | 2002-01-24 10:44:00
 | [NAME] | 58 | 1400 | 1550 | 34.5 | 38.2 | 1.33 | 2002-01-24 10:44:00
 | HO F3 | 59 | 1425 | 1575 | 33.1 | 36.6 | 1.29 | 2002-01-24 10:44:00
 | [NAME] |  |  |  | 33.2 | 36.5 | 1.31 | 2001-12-31 13:18:00
 | HO H3
 | HO J3 |  |  |  |  |  | 0.72 | 2001-07-18 22:45:00
 | [NAME]
Spreadsheet: 231504d1367098248-two-misaligned-cells-16-team-planning-bracket
Sheet: 113

[NAME] | Aztec | 1
bl113 | Bloomfield
cib113 | Cibola
cle113 | Cleveland
far113 | Farmington
gal113 | Gallup
grt113 | Grants | 8
kc113 | [NAME]
miy113 | Miyamura | 5
new113 | Newcomb
pv113 | Piedra Vista
rr113 | Rio Rancho
sf113 | Santa Fe
ship113 | Shiprock
vv113 | [NAME] | 4
win113 | Wingate
 |  | 3
Paste Value - CTRL-N
 |  | 6
 |  | 7
 |  | 2
Spreadsheet: 754409d1636144491-how-many-in-column-b-for-each-in-column-a-how-many-in-column-b-for-each-in-column-a
Sheet: Sheet1

 |  |  |  | [NAME] needed:
Our Name | VDR Full Name |  |  | If ACTUAL name is in Column A, How many UNIQUE values correspond to that name in Column B?
Abalos,Kristal | Crystal
Abalos,Kristal | [NAME]
Abalos,Kristal | [NAME]
Abodunrin,Kolapo [NAME] | Kolapo Aboduaria
Abodunrin,Kolapo [NAME] | Kolapo Abodunria
Abodunrin,Kolapo [NAME] | Kolapo Abodunrin
Abodunrin,Kolapo [NAME] | Kolapo Aodunria
Abodunrin,Kolapo [NAME] | Kolapo O Abodunrin
Acevedo,[NAME] | Maria
Adlam,Shacole D | [NAME]
Adlam,Shacole D | [NAME]
Adlam,Shacole D | [NAME]
Adlam,Shacole D | Shacolle B Adlan
[NAME],[NAME] | [NAME]
[NAME],[NAME] | [NAME]
Akiri,[NAME] O | Bridgid O Akiri
Akiri,[NAME] O | Brigid
Akiri,[NAME] O | Brigid O Akiri
Akiri,[NAME] O | Brizid
Akiri,[NAME] O | Brigit
Akiri,[NAME] O | Bridged Apiri O
Akiri,[NAME] O | Brigette O Akiri
Akiri,[NAME] O | Brigid
Akiri,[NAME] O | Brigid O Akiri
Akiri,[NAME] O | [NAME] O Tkiri
Akiri,[NAME] O | Brigid O. Akiri
Akiri,[NAME] O | Brigid Oakiri
Akiri,[NAME] O | [NAME]
Akiri,[NAME] O | Brigit O Akiri
Akiri,[NAME] O | [NAME]
Akiri,[NAME] O | Bridged
Akiri,[NAME] O | Akiri
Akiri,[NAME] O | Brigid O. Akgri
Akiri,[NAME] O | Breged O Akiri
Alamutu,[NAME] | [NAME]
Alcoser,[NAME] | [NAME]
Alcoser,[NAME] | [NAME]
Alcoser,[NAME] | [NAME]
Alcoser,[NAME] | [NAME]
Aleman,[NAME] | [NAME]
Aleman,[NAME] | [NAME]
Aleman,[NAME] | [NAME]
Aleman,[NAME] | [NAME]
[NAME],[NAME] | [NAME]
[NAME],[NAME] | [NAME]
Alexis,Jovia | [NAME]
Alimeke,Trissa | [NAME]
Alimeke,Trissa | Trissa A Alimeke
Alimeke,Trissa | [NAME]
Alimeke,Trissa | [NAME]
Alimeke,Trissa | [NAME]
[NAME],[NAME] | [NAME]
[NAME],[NAME] | [NAME]
[NAME],[NAME] | [NAME]
[NAME],[NAME] | [NAME]
[NAME],[NAME] | [NAME]
[NAME],[NAME] | [NAME]
[NAME],[NAME] | [NAME]
[NAME],[NAME] | [NAME]
[NAME],[NAME] | [NAME]
[NAME],[NAME] | [NAME]
Almanza,[NAME] | Alexandra
Almanza,[NAME] | Alexandra Almanza
Almstead,[NAME] | [NAME]
Almstead,[NAME] | [NAME]
Almstead,[NAME] | [NAME]
Almstead,[NAME] | [NAME]
Alpough,Yolanda E
Alpough,Yolanda E | Yolanda Alpouch
Alpough,Yolanda E | Yolanda E Alpo
Alpough,Yolanda E | Yolanda E Alpough
Alpough,Yolanda E | [NAME]
Alpough,Yolanda E | Yolanda
Alpough,Yolanda E | Yolanda
Alsup,[NAME] | [NAME]
[NAME],[NAME] | Maria
[NAME],[NAME] | [NAME]
[NAME],[NAME] | [NAME]
[NAME],[NAME] | [NAME]
[NAME],[NAME] | [NAME]
Anders,[NAME] | [NAME]
Anders,[NAME] | Tara
Anders,[NAME] | [NAME]
[NAME],[NAME] | [NAME]
[NAME],[NAME] | [NAME]
[NAME],Rasheeda | Rasheeda
[NAME],Rasheeda | Rasheeda Amfela
[NAME],Rasheeda | [NAME]
[NAME],Rasheeda | Rashida Ansela
Spreadsheet: 863847d1711227700-return-largest-value-from-array-derived-from-specific-criteria-forum-query
Sheet: Sheet1

 |  | Write a formula in X1 that will firstly check Row 1 for K,D,S,0,1 and 2, then find their corresponding values from Row A (along their columns) i.e. 19, 12, 11, 5 & 23, and finally return the highest number from these (i.e. 23). The formula can be pulled down in the subsequent yellow rows but all other rows must get corresponding values from Row A using the same criteria,
 |  | ROW A | 19 | 0 | 12 | 0 | 11 | 0 | 66 | 0 | 5 | 0 | 23 | 0 | Highest
 |  | ROW 1 | 1 | W | 0 | B | D | B | _ | _ | K | B | 0 | W | X1 | Ans = 23
 |  | ROW 2
 |  | ROW 3
Spreadsheet: 874100d1720666973-reshaping-data-reshaping-data-in-excel
Sheet: Output

 | The training was interesting and engaging | The training content was clear to understand | The training was relevant to your work/job role | The instructor(s) demonstrated command over the subject | Queries were responded in a timely manner | I felt part of a learning community | I am likely to apply this new knowledge to my current/future work. | I am likely to recommend this course to a colleague.
Strongly agree
Agree
Neither agree nor disagree
Disagree
Strongly disagree
Spreadsheet: 2a942495-7425-4e64-a4aa-87b62d1d43dd
Sheet: Table 2.1

 | 2.1 Average weekly ordinary time earnings
 | Quarter | 2009–10 | 2010–11 | 2011–12 | 2012–13 | 2013-14
 | AWOTE – $ per week
 | November | 1226.8 | 1275.2 | 1330.1 | 1396 | 1437
 | May | 1250.1 | 1304.7 | 1349.2 | 1420.9 | 1454.1
 | Annual average | 1238.5 | 1289.95 | 1339.65 | 1408.45 | 1445.55
 | AWOTE annual change – per cent
 | November | 5.9 | 3.9 | 4.3 | 5 | 2.9
 | May | 5.2 | 4.4 | 3.4 | 5.3 | 2.3
 | Annual average | 5.6 | 4.2 | 3.85 | 5.1 | 2.6
 | Real AWOTE (a) – $ per week
 | November | 1369.95927698033 | 1384.98 | 1399.736998997996 | 1438.811579980373 | 1445.602729885058
 | May | 1374.782748691099 | 1387.61 | 1414.874987518722 | 1454.483650097466 | 1445.497893989588
 | Annual average | 1372.444869427592 | 1386.362240982349 | 1407.371767941986 | 1446.725794621027 | 1445.6
 | Real AWOTE annual change – per cent
 | November | 4.251624507964835 | 1.096672757232553 | 1.065265725931175 | 2.791565916336292 | 0.4719971676053314
 | May | 2.159273733216138 | 0.9327658850583287 | 1.965163697697103 | 2.799446094400615 | -0.6177969829551433
 | Annual average | 3.19756559813742 | 1.014056875054048 | 1.515442814191936 | 2.796277968300354 | -0.0778167241651917
 | (a) Expressed in average 2013-14 dollars; converted to real terms using the consumer price index.
 | Sources:
 | ABS, Average weekly earnings, Cat. no. 6302.0
 | ABS, Consumer price index, Cat. no. 6401.0
 |  |  |  |  |  |  |  |  | Update
 |  |  |  |  |  |  |  |  | 2014-10-10 00:00:00
Spreadsheet: 64287d1265151173-sum-array-issue-sample-sum-array-issue
Sheet: Details

Base? (Y/N)  Client? (C) | N's [NAME] (A) | Dept Num | Acct Num | G/L Acct Name | Item Description | HW: Depr or [NAME]? DMSP: Pass-Thru or [NAME]? | Budget Purchase Date | [NAME] (Years) | Budget Term Date | Budget Amount | Is this a Renewal? (Y/ ) | Actual Purchase Date | Actual Term (Years) | Actual Term Date | Actual Amount | SpCol
Y |  | 1 |  | [NAME] |  | Hosting |  |  |  |  |  | 2007-07-02 00:00:00 | 3 |  | 670
Y | A | 2 |  | [NAME] |  | Hosting |  |  |  |  |  | 2010-01-01 00:00:00 | 3 |  | 2292.5
Y |  | 1 |  | DP |  | Hosting |  |  |  |  |  | 2010-01-01 00:00:00 | 3 |  | 2292.5
Y |  | 2 |  | DP |  | Pass-Thru | 2008-01-01 00:00:00 | 3 |  | 2500 |  | 2008-02-01 00:00:00 | 3
C |  | 1 |  | HWDep |  | Pass-Thru |  |  |  |  |  | 2008-02-01 00:00:00 | 3
Y |  | 1 |  | DP |  | Hosting |  |  |  |  |  | 2007-07-02 00:00:00 | 3 |  | 670
Y |  | 2 |  | DP |  | Hosting |  |  |  |  |  | 2010-01-01 00:00:00 | 0.6 |  | 670
Y |  | 3 |  | HWDep |  | Hosting | 2007-09-15 00:00:00 | 3 |  | 4000 |  | 2007-08-02 00:00:00 | 3 |  | 4120
Y | A | 1 |  | DP |  | Hosting |  |  |  |  |  | 2007-07-02 00:00:00 | 3 |  | 3600
Y |  | 1 |  | [NAME] |  |  |  |  |  |  |  | 2007-11-22 00:00:00 | 3 |  | 9737
Y |  | 1 |  | [NAME] |  |  | 2009-04-01 00:00:00 | 1 |  | 8099 |  | 2009-03-15 00:00:00 | 1 |  | 7713
NO DATA BELOW THIS POINT ADD NEW LINES ABOVE RED