tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 86962d1286900735-return-results-based-on-rows-and-columns-sumrange-1-
Sheet: Case3

YEAR | JUL | AUG | SEP | OCT | NOV | DEC
06-07 | 26.03734121464915 | 27.67678728610295 | 26.39404707099829 | 25.65252894177307 | 24.07280567834216 | 21.7612481066913
07-08 | 23.58629102868086 | 24.37720109665566 | 25.11968989093254 | 25.15895762051949 | 23.8947314037999 | 21.62759381779009
08-09 | 23.37135725287002 | 24.21504711715565 | 24.99373593612633 | 25.0795051225508 | 23.82792014313219 | 21.59241587288115
09-10 | 23.39868025041551 | 24.21219511580908 | 24.96231276604664 | 25.00739778486865 | 23.72574183405291 | 21.48573637984501
10-11 | 24.21300320051716 | 25.11211331450493 | 25.92517842319175 | 26.01131100958998 | 24.6898021101284 | 22.38650771991447
11-12 | 25.34422908521563 | 26.26344044577377 | 27.08929404701049 | 27.15358581164696 | 25.74174680256245 | 23.32081272613373
12-13 | 25.21440833469498 | 26.16788697188074 | 27.01688752425673 | 27.09865030255859 | 25.70706635220106 | 23.32455735453999
13-14 | 25.39904447835167 | 26.34439204052673 | 27.18455569918643 | 27.25811886346099 | 25.8395671313372 | 23.4276488454201
14-15 | 25.39763861775513 | 26.38035179130738 | 27.25008540825249 | 27.35305297869138 | 25.95335560870272 | 23.55920564299233
09-10
JUL
23.39868025041551
A1:G10 = Case3
Spreadsheet: 199844d1355337693-removing-certain-values-from-long-matrix-tigeravatar-example-for-gerdee
Sheet: Sheet1

1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  | 1 | 1 | 1
1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  | 1 | 1 | 1
1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  | 1 | 1 | 1
1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  | 1 | 1 | 1
1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  | 1 | 1 | 1
1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  | 1 | 1 | 1
Spreadsheet: 885834d1735698005-granulating-weekly-timesheet-to-days-vlookup-index-formula-timesheet-demo-v2
Sheet: Original

Week Start | Employee | Pay Item | Class/Project | Service/Role | Hours | Description | Sun | Mon | Tue | Wed | Thu | Fri | Sat
2024-12-01 00:00:00 | [NAME] | Regular Pay | [NAME] | Management | 12 | Working on this stupid spreadsheet |  | 4 | 8 |  | 2 | 2
2024-12-01 00:00:00 | [NAME] | Sick | HR | Stat/Vac/Sick | 8 | [NAME] |  |  |  | 4
2024-12-01 00:00:00 | Bojangles | Regular Pay | Lodge | Reporting | 7 | Building walls |  | 4 | 2 | 1
2024-12-01 00:00:00 | Slugger | Regular Pay | Geese | Reporting | 1 | Reporting on Geese etc |  |  | 1
 |  |  |  |  |  |  | 8
 |  |  |  |  |  |  | 2
 |  |  |  |  |  |  | 2
 |  |  |  |  |  |  | 4
 |  |  |  |  |  |  | 4
 |  |  |  |  |  |  | 2
 |  |  |  |  |  |  | 1
 |  |  |  |  |  |  | 1
Spreadsheet: 490509d1479902874-count-the-number-of-cases-that-match-the-criteria-example
Sheet: Sheet1

A | 1 |  | A
B |  |  | AA
C | 1 |  | G
D |  |  | M
E |  |  | O
F | 1 |  | Z
G
H | 1
I
J
K
L
M | 1
N
O
P | 1
Q
R
S | 1
T
U
V | 1
W
X
Y | 1
Z | 1
Spreadsheet: 267201d1380008712-vlookup-function-0a215
Sheet: Log

Umpire | Player | Team | Position | Votes | Team Margin | K | H | D | CP | UP | DE% | CLG | M | CM | M50 | HO | CLR | CC | ST | R50 | FF | FA | T | 0.01 | Bo | [NAME] | G | B | GA | G% | TG% | DT
[NAME], [NAME]
Mitchell, [NAME]
Mitchell, [NAME]
[NAME], [NAME]
Margetts, [NAME]
Margetts, [NAME]
Mitchell, [NAME]
[NAME], [NAME]
Nash, Nick
Parker, [NAME]
Mitchell, [NAME]
Margetts, [NAME]
Mitchell, [NAME]
[NAME], [NAME]
Margetts, [NAME]
[NAME], [NAME]
Parker, [NAME]
Spreadsheet: 05e396a2-a75c-41a6-bcde-36b0cde4073b
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
5954 | 45469 | Ariane | Pinheiro | BRA | 0 | 01:05:57 | 00:00:00 | 02:32:36 | 00:00:00 | 01:40:02 | 1 | 05:18:36
5954 | 45525 | [NAME] | [NAME] | BRA | 0 | 01:06:01 | 00:00:00 | 03:08:54 | 00:00:00 | [NAME] | 2 | 06:11:47
Spreadsheet: 320c023c-abde-46cd-8c7c-ba7ab66ed96f
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2011-11-10 09:23:00.920000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.5 | 101.875 | 101.75 | 101.625 | 101.25 |  | and are added to price quote
4.375 | 101.558 | 101.433 | 101.308 | 100.933
4.25 | 100.866 | 100.741 | 100.616 | 100.241 |  | Note: | Refer To Price [NAME]
4.125 | 100.378 | 100.253 | 100.128 | 99.753 |  |  | For all Price Adjs
4 | 99.923 | 99.798 | 99.673 | 99.048
3.875 | 99.36 | 99.235 | 99.11 | 98.485
3.75 | 98.535 | 98.41 | 98.285 | 97.66
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.875 | 101.477 | 101.352 | 101.227 | 100.852
3.75 | 101.029 | 100.904 | 100.779 | 100.404
3.625 | 100.649 | 100.524 | 100.399 | 100.024
3.5 | 100.298 | 100.173 | 100.048 | 99.673
3.375 | 99.914 | 99.789 | 99.664 | 99.039
3.25 | 99.401 | 99.276 | 99.151 | 98.526
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2011-11-24 09:23:00.920000
30 DAY | 2011-12-09 09:23:00.920000
45 DAY | 2011-12-24 09:23:00.920000
60 DAY | 2012-01-08 09:23:00.920000
90 DAY | 2012-02-07 09:23:00.920000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 705736d1606288852-data-comparison-and-aggregation-looking-for-help-copy-template-1-
Sheet: amount

ID | Name | Acc num | Product | Total Value
111 | Name 1 | 1111 | Product 1 | 1133059.89
111 | Name 1 | 1112 | Product 2 | 3984.4
222 | Name 2 | 1113 |  | 199959.2
222 | Name 2 | 1114 |  | 716513.7
222 | Name 2 | 1115 |  | 55676.77
333 | Name 3 | 1116 |  | 38657.34
333 | Name 3 | 1117 |  | 445112.3
444 | Name 4 | 1118 |  | 121
444 | Name 4 | 1119 |  | 157763.62
555 | Name 5 | 1120 |  | 612748.12
555 | Name 5 | 1121 |  | 906128.44
666 | Name 6 | 1122 |  | 5678224.49
777 | Name 7 | 1123 |  | 456034.94
777 | Name 7 | 1124 |  | 123456.29
888 | Name 8 | 1125 |  | 2509.43
888 | Name 8 | 1126 |  | 75748.43
888 | Name 8 | 1127 |  | 12745.31
999 | Name 9 | 1128 |  | 123461.02
999 | Name 9 | 1129 |  | 509000.2
1000 | Name 10 | 1130 |  | 131575.33
1000 | Name 10 | 1131 |  | 31040.95
Spreadsheet: 6545ec62-fac3-4f39-b076-43de8d13de0e
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
43112585 | 2014-09-11 13:47:54 | ALLIES | 1 | 6 | 4 | 919860 | DobermanVO | 6154 | mediterranean | 1944-08-20 | 1944-08-26 | Toulon | Toulon
43112746 | 2014-09-11 14:07:09 | AXIS | 1 | 6 | 5 | 919860 | DobermanVO | 6154 | mediterranean | 1944-08-20 | 1944-08-26 | Toulon | Toulon
43131919 | 2014-09-12 22:23:51 | ALLIES | 1 | 6 | 3 | 1633743 | player1633743 | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
43132061 | 2014-09-12 22:36:24 | AXIS | 1 | 6 | 3 | 1633743 | player1633743 | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
43158553 | 2014-09-14 19:00:16 | AXIS | 1 | 6 | 1 | 500348 | souricette76 | 8043 | eastern | 1939-09-08 | 1939-09-26 | Battle of Warsaw | Bataille de Varsovie
43183399 | 2014-09-16 13:20:49 | AXIS | 0 | 4 | 7 | 364821 | Quit | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
43183511 | 2014-09-16 13:42:18 | AXIS | 1 | 7 | 5 | 364821 | Quit | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
43183934 | 2014-09-16 14:34:58 | AXIS | 0 | 3 | 7 | 364821 | Quit | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
43184021 | 2014-09-16 14:51:30 | AXIS | 0 | 6 | 7 | 364821 | Quit | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
Spreadsheet: 938e248f-25ee-4f04-b63e-58cde807ed89
Sheet: Weekly Changes

 |  |  | Rail to port--Week to Week Changes |  |  |  |  |  |  |  |  | Rail to port--Changes in 4-week averages
 |  |  | MS | TX | Cross-Border-2 | Cross-Border | PNW | East coast | Total |  |  | MS | TX | Cross-Border-2 | Cross | PNW | East coast | Total
% chg from prior week |  |  |  |  |  | n/a |  |  |  |  | % chg from prior week |  |  |  | n/a
% chg from prior year |  |  |  |  |  | n/a |  |  |  |  | % chg from prior year |  |  |  | n/a
% chg from 4-yr avg. |  |  |  |  |  | n/a |  |  |  |  | % chg from 4-yr avg. |  |  |  | n/a
 |  |  | 4-yr avg |  |  |  |  |  | 4-yr avg |  |  | 4-yr avg |  |  |  |  |  | 4-yr avg
1st Quarter 2014 |  |  |  |  |  | n/a
1st Quarter 2013 |  |  |  |  |  | n/a
Change |  |  |  |  |  | n/a
Spreadsheet: 265223d1379111631-writing-formulas-to-move-data-from-one-worksheet-to-another-userdata
Sheet: MES

ROW | RANDOM | RANDOM2 | INITIALS | CRITERIA
Spreadsheet: 693085d1598744961-mortgage-calculator-calculate-loan-amount-from-monthly-payment-mortgage
Sheet: Sheet1

Loan Amount | 535268
VA Funding Rate | 0.023 | 0.023
VA Funding Fee
Annual Interest Rate | 0.03 | 0.03
Life Loan (in years) | 30 | 30
Number of Payments per Year | 12 | 12
Total Number of Payments
Payment per Period
Sum of Payments
Interest Cost
Property Tax Rate | 0.0125 | 0.0125
Property Tax Monthly Cost
Property Tax Annual Cost
Home Insurance Rate | 0.003 | 0.003
Home Insurance Monthly Cost
Home Insurance Annual Cost
Total Monthly Payment |  | 3000
Yellow fields are variables.
Gray fields are problem areas.
Spreadsheet: 189717d1351291490-divide-and-distribute-costs-to-multiple-participants-based-on-individual-amount-owed-vacation-cost-calculator
Sheet: Family9

Family9 |  |  |  |  | Receipts for Group Items | Cost | Total Paid
Family Members at Parker | 2 |  |  |  |  |  | 0
Family Days at Parker | 3
Family Members: | Days at Parker
Family_Member1 | 1
Family_Member2 | 0
Family_Member3 | 0
Family_Member4 | 0
Family_Member5 | 2
Spreadsheet: 702349d1604311708-if-function-smart-formula
Sheet: Sheet1

 | Basic Task (m) | Total Output | Basic Output | Expected Formula Output | Comment
 | 120 | 106 | 106
 | 120 | 120 | 120
 | 120 | 134 | 134 |  | If Total Output is more than the Basic Task, return the Basic Task, i.e. 120
 | 115 | 85 | 85
 | 115 | 115 | 115
 | 115 | 125 | 125 |  | If Total Output is more than the Basic Task, return the Basic Task, i.e. 115
 | 75 | 65 | 65
 | 75 | 75 | 75
 | 75 | 85 | 76 |  | If Total Output is more than the Basic Task, return the Basic Task, i.e. 75
 | 105 | 95 | 95
 | 105 | 105 | 105
 | 105 | 122 | 122 |  | If Total Output is more than the Basic Task, return the Basic Task, i.e. 105
Spreadsheet: 3c078da7-480d-4db8-8dc0-ecb226c8758a
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
House Lights Media | 855332003119 | Various | Little Baby Disciples: Vol 3: The Lord Is My Savior | 2013-11-12 | DVD | Children | 12.99 | Y | Available
Warner Home Video | 883929355716 | Various | Snoopy'S Holiday Collection | 2013-11-08 | DVD | Children | 19.98 | Y | Available
Big Idea | 820413114596 | Veggietales | [NAME]: A Story Of Joyful Giving | 2009-10-03 | DVD | Children | 14.99 | Y | Available
Warner Home Video | 883929006472 | Peanuts | [NAME] Christmas, A | 2009-10-06 | DVD | Children | 19.98 | Y | Available
Big Idea | 820413117597 | Veggietales | It'S A Meaningful Life | 2010-10-02 | DVD | Children | 14.99 | Y | Available
Image Entertainment | 14381610628 | Various | Magical Christmas Collection | 2010-10-05 | DVD | Children | 14.98 | Y | Available
Warner Home Video | 883929006489 | Peanuts | [NAME] Thanksgiving, A | 2010-10-05 | DVD | Children | 19.97 | Y | Available
Warner Home Video | 883929081974 | Peanuts | I Want A Dog For Christmas [NAME] | 2010-10-05 | DVD | Children | 19.97 | Y | Available
Warner Home Video | 883929084579 | Peanuts | [NAME] Christmas Tales | 2010-10-05 | DVD | Children | 14.97 | Y | Available
Big Idea | 820413120399 | Veggietales | Little [NAME], The | 2011-10-01 | DVD | Children | 14.99 | Y | Available
Big Idea | 820413122195 | Veggietales | Toy That Saved Christmas Super Sale | 2013-10-22 | DVD | Children | 6.97 | N | Available
Big Idea | 80689519796 | Veggietales | Toy That Saved Christmas, The | 2002-10-12 | DVD | Children | 9.99 | Y | Available
Big Idea | 820413100094 | Veggietales | Star Of Christmas, The | 2002-10-12 | DVD | Children | 9.99 | Y | Available
Spreadsheet: 134892d1325691337-excel-need-help-with-formulas-exclearn
Sheet: Sheet1

 |  | R | Date | Home | Score | Away | 1 | X | 2 | res |  | best line
 |  | 5 | 2009-08-29 00:00:00 | Barnsley | 1   -   3 | Reading | 31.2 | 33.3 | 35.5 | 0 - 1 |  |  | M4 to check H4, [NAME], [NAME] and return the highest value i.e. in this line J4 is the highest thus a return of 2
 |  | 5 | 2009-08-29 00:00:00 | Blackpool | 3   -   0 | Coventry City | 39.7 | 31.7 | 28.6 | 0 - 1 |  |  | M5 to check H5, I5, J5 39.7 is the highest value thus a return of 1
 |  | 5 | 2009-08-29 00:00:00 | Bristol City | 2   -   1 | Middlesbrough | 34 | 32 | 34 | 2 - 2 |  |  | M6 to check H6, I6, J6 columns 1 and 2 have both the highest value thus a return of 12 is needed.
 |  | 5 | 2009-08-29 00:00:00 | Doncaster | 2   -   0 | Cardiff City | 27.1 | 28.5 | 44.5 | 0 - 2
 |  | 5 | 2009-08-29 00:00:00 | Ipswich Town | 1   -   1 | Preston | 26.6 | 27.9 | 45.5 | 0 - 2
 |  | 5 | 2009-08-29 00:00:00 | Nottm Forest | 3   -   2 | Derby County | 29.5 | 31.3 | 39.3 | 0 - 1
 |  | 5 | 2009-08-29 00:00:00 | Plymouth Argyle | 1   -   3 | Sheffield Wed | 30 | 31.8 | 38.2 | 0 - 1
 |  | 5 | 2009-08-29 00:00:00 | Scunthorpe Utd | 0   -   1 | [NAME] | 31.4 | 39.6 | 29 | 0 - 0
 |  | 5 | 2009-08-29 00:00:00 | Sheffield Utd | 2   -   2 | West Bromwich | 31.4 | 33.6 | 35 | 1 - 2
 |  | 5 | 2009-08-29 00:00:00 | Swansea city | 1   -   1 | Watford | 31.2 | 33.3 | 35.5 | 0 - 2
 |  | 5 | 2009-08-31 00:00:00 | Newcastle Utd | 1   -   0 | Leicester City | 36 | 37.9 | 22.9 | 0 - 0
 |  | 5 | 2009-08-31 00:00:00 | Peterborough | 1   -   1 | Crystal Palace | 30.2 | 32.1 | 37.7 | 1 - 2
 | my needs are:
 |  | 1 | hi, I need to check colums H, I and J and return 1 if H is the higest, return X if I is the highest, return 2 if J is the highest or if two values are the same return 1X or 12 or X2.
 |  | 2 | to sum the res column i.e. 1 - 2 returns 3
 |  | 3 | the scores column i.e 1 - 3 returns 2 for an away win, 3 - 0 returns 1 for a home win & 1-1 returns 3 for a draw
Spreadsheet: 65214d1265914340-tie-breaker-copy-of-rank-tiebreaking_test
Sheet: Others

 |  |  |  |  | Tie Rank | TieBreak Rank
Forecaster A: | 6 | of | 6 | 1 | 1 | 2
Forecaster B: | 3 | of | 3 | 1 | 1 | 3
Forecaster C: | 1 | of | 2 | 0.5 | 5 | 5
Forecaster D: | 12 | of | 12 | 1 | 1 | 1
Forecaster E: | 30 | of | 40 | 0.75 | 4 | 4
 |  |  |  |  |  | This tie is broken by giving rank
 |  |  |  |  |  | to the forecaster who achieved the
 |  |  |  |  |  | same percentage but from a higher
 |  |  |  |  |  | number of events
Spreadsheet: 886499d1736520140-doing-sum-doing-sum
Sheet: Required1

 | New Testament |  | 1 | 2
 | List | Code | Papermint | Papermint
 | [NAME] | 119232628 |  | 0
 | Amit Chaudary | 119212921 | 16720.27 | 19283.31
 | Arjun PD Yadav |  | 16720.27 | 19283.31
 | Arjun Razzak | 119232448 | 16720.27 | 19283.31
 | Ajal Kumar Mukhiya | 139420531 | 15675.25 | 19283.31
 | [NAME] | 119213117 | 0 | 0
 | [NAME] | 119228041 | 21469.68 | 24032.72
 | [NAME] |  | 15392.36 | 20474.15
 | [NAME]. Mandal | 119227334 | 0 | 0
 | Total
Spreadsheet: tracy_geaccone__40532__ETS - Transwestern IC 10-19
Sheet: Invoice

 | Enron Net Works
 | 1400 Smith Street
 | Houston, Texas 77002
 | Intercompany billing for 2002
 | Revised 10/19/2001
To: ETS - Transwestern Pipeline Co.
 | Accounting Contact: | [NAME]
 | Other Contact: | [NAME]
Description | Assessment Information | Amount
EXPENSE
EnronOnline | 2002 Assessments will be based on actuals | 104143.8021363895
IT Development | 2002 Assessments will be based on actuals
IT Infrastructure | 2002 Assessments will be plan with periodic true up
 | TOTAL ALLOCATED EXPENSE
IT Infrastructure - Controllable* | Will not be assessed.  Billed to and budgeted at cost center.
 | (For information purposes only)
Footnotes:
*Consistent with 2001, pass through billings (long distance, market data, WAN, etc.) will not be included in the
standard assessments ("8xxxxxxx" accounts).  They will be posted directly to direct expenses ("52502000" account)
at the cost center level.  This pass through number is only a high level place holder and is not intended to replace
the dollars already being budgeted for by each cost center owner.
Spreadsheet: 681333d1591487690-vlookup-query-vlookup
Sheet: Sheet1

Location A | Location B | Distance |  |  |  | Table A | Distance
Birmingham | [NAME] |  |  |  |  | London | 0
London | Liverpool |  |  |  |  | [NAME] | 1
[NAME] | Cornwall |  |  |  |  | Bristol | 2
[NAME] | Cheshire |  |  |  |  | Cornwall | 3
Liverpool | [NAME] |  |  |  |  | York | 4
Cornwall | [NAME] |  |  |  |  | Birmingham | 5
 |  |  |  |  |  | Portsmouth | 6
 |  |  |  |  |  | Liverpool | 7
 |  |  |  |  |  | [NAME] | 8
 |  |  |  |  |  | Cheshire | 9
Spreadsheet: 47177d1246063320-lookup-and-result-on-condition-referencestest-5
Sheet: Data

Supplier | Account | Month | Code | Date | Jef1 | Jef2 | Amount | Key
Dabs | 11010 | 1 | 20811 | 2008-07-31 00:00:00 | JE: S/J  2008091 | Monthly charge | -119.49
Dabs | 11010 | 1 | 22525 | 2008-07-31 00:00:00 | JE: S/J  2008091 | Monthly charge | -119.49
Dabs | 11010 | 1 | 22898 | 2008-07-31 00:00:00 | JE: S/J  2008091 | Monthly charge | -119.49
Dabs | 11010 | 7 | 23393 | 2008-07-31 00:00:00 | JE: S/J  2008091 | Monthly charge | -119.49
Dabs | 11010 | 8 | 23931 | 2008-07-31 00:00:00 | JE: S/J  2008091 | Monthly charge | -119.49
Dabs | 11010 | 9 | 24429 | 2009-03-31 00:00:00 | JE: S/J  2008091 | Monthly charge | -119.49
Dabs | 11010 | 10 | 25025 | 2009-04-30 00:00:00 | JE: S/J  2008091 | Monthly charge | -119.49
Currys | 13020 | 9 | 20811 | 2009-03-31 00:00:00 | JE: S/J  2008091 | Monthly charge | -6.71
Currys | 13020 | 10 | 25025 | 2009-04-30 00:00:00 | JE: S/J  2008091 | Monthly charge | -6.71
Dell | 13021 | 10 | 25025 | 2009-04-30 00:00:00 | JE: S/J  2008091 | RB Adjustment | -39.77 | 1
Dell | 13021 | 10 | 25025 | 2009-04-30 00:00:00 | JE:m/a journal | RB adjust P1-9 | 196.33 | 2
GB | 14010 | 1 | 23477 | 2009-01-01 00:00:00 | JE:m/a journal |  | 6099.43
GB | 14010 | 8 | 23478 | 2009-01-01 00:00:00 | JE: S/J  2008091 | Monthly charge | -659.94
GB | 14010 | 9 | 23479 | 2009-01-01 00:00:00 | JE: S/J  2008091 | Monthly charge | -659.94
GB | 14010 | 10 | 23480 | 2009-01-01 00:00:00 | JE: S/J  2008091 | Monthly charge | -659.94
GB | 14011 | 6 | 23089 | 2009-01-01 00:00:00 | JE:m/a journal |  | -3415.54
Total | 14012 | 7 | 23089 | 2009-01-01 00:00:00 | JE: S/J  2008091 | RB adjustment | 152.44
Total | 14011 | 7 | 23091 | 2009-01-01 00:00:00 | JE:m/a journal |  | -2591.15
Tech | 22010 | 1 | 23089 | 2008-07-01 00:00:00 | JE:INVOICING -OR |  | -192.72
Spreadsheet: 766089d1643745881-selecting-value-from-the-drop-down-list-automatically-based-on-the-other-cell-value-dropdownlists
Sheet: Drop-down lists

Country |  | Canton
Switzerland |  | Zürich (ZH)
USA |  | Bern / Berne (BE)
 |  | Luzern (LU)
 |  | Uri (UR)
 |  | [NAME] (SZ)
 |  | Unterwalden (Obwalden (OW) / Nidwalden (NW))
 |  | Glarus (GL)
 |  | Zug (ZG)
 |  | Freiburg / Fribourg (FR)
 |  | Solothurn (SO)
 |  | Basel (Basel Stadt (BS)/ Basel Land (BL))
 |  | [NAME] (SH)
 |  | Appenzell (Appenzell Ausserrhoden (AR) / [NAME] (AI))
 |  | [NAME] (SG)
 |  | Graubünden (GR)
 |  | Aargau (AG)
 |  | Thurgau (TG)
 |  | [NAME] (TI)
 |  | [NAME] ([NAME])
 |  | Valais / Wallis (VS)
 |  | Neuchâtel (NE)
 |  | Genève (GE)
 |  | [NAME] (JU)
 |  | n/a
Spreadsheet: 174a123a-b730-4784-8753-600da4111155
Sheet: Maida F. Townsend

[NAME]
Fair Share Fee: Those Who Don't Pay Their Fair Share
Agree
Explain your fair share position, if you choose.
No response
Teachers' Retirement: Support in the State Budget
Agree
Explain your teachers' retirement position, if you choose.
No response
Health Care: Continuing System Reform
Agree
Explain your health care reform position, if you choose
No response
Teaching Career: Retaining New Teachers
Agree
Explain your teaching career position, if you choose
No response
Teaching Profession: Simplifying Professional Relicensing
Agree
Explain your relicensing position, if you choose
No response
Name | email address | Address | Office sought | Are you an incumbent? |  | County
[NAME] | [EMAIL] | 232 Patchen Road South Burlington | Chittenden 7-4 House Seat | No |  | Chittenden
Spreadsheet: 157423d1337720531-automatically-sort-the-data-and-ranking-based-on-the-sorted-data-schedule-calculator
Sheet: AHT Summary

 | Employee ID | Name | No Of Calls | AHT |  |  | Ranking | Employee ID | Name | No Of Calls | AHT
 | A942 | Mawsumi |  |  |  |  | 1
 | A378 | [NAME] |  |  |  |  | 2
 | A2559 | Sandeep |  |  |  |  | 3
 | A1128 | Rajeev |  |  |  |  | 4
 | A2733 | Vijender |  |  |  |  | 5
 | A978 | Nasrin |  |  |  |  | 6
 | A3784 | [NAME] |  |  |  |  | 7
 | Month | Mawsumi |  |  | [NAME] |  |  | Sandeep |  |  | Rajeev |  |  | [NAME] |  |  | Vijender |  |  | Nasrin
 |  | Talk Time | No of Calls | AHT | Talk Time | No of Calls | AHT | Talk Time | No of Calls | AHT | Talk Time | No of Calls | AHT | Talk Time | No of Calls | AHT | Talk Time | No of Calls | AHT | Talk Time | No of Calls | AHT
 | 2012-01-01 00:00:00 | 1 day, 15:08:18 | 526 | 0:04:27.867000 | 1 day, 0:55:57 | 326 | 0:04:35.328000 | 1 day, 1:59:30 | 379 | 0:04:06.887000 | 21:39:41 | 355 | 0:03:39.665000 | 1 day, 1:34:12 | 371 | 0:04:08.119000 | 1 day, 12:31:36 | 458 | 0:04:47.109000 | 1 day, 8:48:12 | 559 | 0:03:31.256000
 | 2012-02-01 00:00:00 | 1 day, 3:38:22 | 411 | 0:04:02.097000 | 17:32:10 | 171 | 00:06:09.181000 | 1 day, 5:42:21 | 463 | 00:03:50.974000 | 1 day, 8:05:56 | 528 | 00:03:38.856000 | 1 day, 10:44:53 | 479 | 00:04:21.154000 | 22:28:24 | 349 | 00:03:51.817000 | 23:31:09 | 428 | 00:03:17.825000
 | 2012-03-01 00:00:00 | 1 day, 3:24:53 | 448 | 0:03:40.297000 | 12:43:54 | 124 | 0:06:09.629000 | 20:16:12 | 355 | 0:03:25.555000 | 1 day, 6:01:19 | 498 | 0:03:37.026000 | 1 day, 4:38:09 | 392 | 0:04:22.982000 | 22:50:34 | 319 | 0:04:17.787000 | 1 day, 1:14:17 | 461 | 0:03:17.087000
 | 2012-04-01 00:00:00 | 1 day, 5:31:42 | 525 | 0:03:22.480000 | 16:32:45 | 176 | 0:05:38.438000 | 1 day, 6:25:15 | 582 | 0:03:08.170000 | 21:55:22 | 477 | 0:02:45.455000 | 1 day, 10:26:32 | 582 | 0:03:33.045000 | 22:55:35 | 434 | 0:03:10.173000 | 1 day, 7:43:55 | 643 | 0:02:57.659000
 | 2012-05-01 00:00:00
 | 2012-06-01 00:00:00
 | 2012-07-01 00:00:00
 | 2012-08-01 00:00:00
 | 2012-09-01 00:00:00
 | 2012-10-01 00:00:00
 | 2012-11-01 00:00:00
 | 2012-12-01 00:00:00
 | Annual Average