tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 94788d1294554775-countif-with-multiple-criteria-example
Sheet: DAYS

DAY OF WEEK | 2011-01-30 00:00:00 | 2011-01-31 00:00:00 | 2011-02-01 00:00:00 | 2011-02-02 00:00:00 | 2011-02-03 00:00:00 | 2011-02-04 00:00:00 | 2011-02-05 00:00:00 | 2011-02-06 00:00:00 | 2011-02-07 00:00:00 | 2011-02-08 00:00:00 | 2011-02-09 00:00:00 | 2011-02-10 00:00:00 | 2011-02-11 00:00:00 | 2011-02-12 00:00:00 | 2011-02-13 00:00:00 | 2011-02-14 00:00:00 | 2011-02-15 00:00:00 | 2011-02-16 00:00:00 | 2011-02-17 00:00:00 | 2011-02-18 00:00:00 | 2011-02-19 00:00:00 | 2011-02-20 00:00:00 | 2011-02-21 00:00:00 | 2011-02-22 00:00:00 | 2011-02-23 00:00:00 | 2011-02-24 00:00:00 | 2011-02-25 00:00:00 | 2011-02-26 00:00:00
DATES | 2011-01-30 00:00:00 | 2011-01-31 00:00:00 | 2011-02-01 00:00:00 | 2011-02-02 00:00:00 | 2011-02-03 00:00:00 | 2011-02-04 00:00:00 | 2011-02-05 00:00:00 | 2011-02-06 00:00:00 | 2011-02-07 00:00:00 | 2011-02-08 00:00:00 | 2011-02-09 00:00:00 | 2011-02-10 00:00:00 | 2011-02-11 00:00:00 | 2011-02-12 00:00:00 | 2011-02-13 00:00:00 | 2011-02-14 00:00:00 | 2011-02-15 00:00:00 | 2011-02-16 00:00:00 | 2011-02-17 00:00:00 | 2011-02-18 00:00:00 | 2011-02-19 00:00:00 | 2011-02-20 00:00:00 | 2011-02-21 00:00:00 | 2011-02-22 00:00:00 | 2011-02-23 00:00:00 | 2011-02-24 00:00:00 | 2011-02-25 00:00:00 | 2011-02-26 00:00:00
[NAME] | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _
[NAME] | 7 | _ | _ | 7 | 3 | 3 | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _
[NAME] | 7 | 3 | _ | 11 | _ | 3 | 3 | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _
Sandy | 7 | _ | 3 | 7 | _ | 3 | 7 | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _
Jessica | _ | 7 | 11 | _ | 7 | 7 | 3 | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _
[NAME] | 3 | _ | 7 | 3 | _ | _ | 7 | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _
[NAME] | _ | 3 | 3 | 3 | 3 | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _
[NAME] | _ | _ | 7 | 11 | 7 | 3 | 11 | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _
Stacy | 11 | 11 | _ | 7 | 3 | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _
[NAME] | _ | 7 | _ | _ | 3 | 7 | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _
[NAME] | _ | 3 | 7 | _ | 7 | 7 | 11 | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _
[NAME] | _ | 7 | _ | 3 | 11 | _ | 7 | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _
Total Staff
Total RN
Total Full time
Spreadsheet: 33452d1229824764-multiple-user-passwords-for-a-workbook-veryhidden
Sheet: Sheet1

DOG CAT LIZARD |  | Dog Cat Lizard
 |  |  | 0
 |  |  | 1
 |  |  | 2
 |  |  | 3
 |  |  | 4
 | a |  | 5
 |  |  | 6
 | d | s
 |  | 3 | 3
 |  | 2 | 4
 |  | 1 | 5
 |  |  | 6
 |  |  | 6
 |  |  | 2 |  |  | 13
 |  |  | 47
Spreadsheet: 873469d1719956891-converting-formula-to-spill-value-error-spill-formula-error
Sheet: Sheet1

Start Date | Starting Bal. | Row Amount
 | 2000 | 20
Date | Start | Total | Total (Spill Formula Version) |  | Open Dates | Close Dates | Amount
2024-06-16 00:00:00 |  |  |  |  | 2024-06-17 00:00:00 | 2024-06-17 00:00:00 | 4
 |  |  |  |  | 2024-06-17 00:00:00 | 2024-06-17 00:00:00 | 5.67
 |  |  |  |  | 2024-06-18 00:00:00 | 2024-06-18 00:00:00 | 9.01
 |  |  |  |  | 2024-06-18 00:00:00 | 2024-06-18 00:00:00 | -3.45
 |  |  |  |  | 2024-06-21 00:00:00 | 2024-06-21 00:00:00 | 5.9
 |  |  |  |  | 2024-07-01 00:00:00 | 2024-07-01 00:00:00 | 69
 |  |  |  |  | 2024-07-01 00:00:00 | 2024-07-02 00:00:00 | 1
 |  |  |  |  | 2024-07-03 00:00:00 | 2024-07-05 00:00:00 | 56
 |  |  |  |  | 2024-06-17 00:00:00 | 2024-07-01 00:00:00 | -34
 |  |  |  |  | 2024-07-05 00:00:00 | 2024-07-05 00:00:00 | -450
 |  |  |  |  | 2024-07-17 00:00:00 | 2024-07-17 00:00:00 | 45
 |  |  |  |  | 2024-07-17 00:00:00 | 2024-07-17 00:00:00 | -22
 |  |  |  |  | 2024-07-18 00:00:00 | 2024-07-18 00:00:00 | 4
 |  |  |  |  | 2024-07-19 00:00:00 | 2024-07-29 00:00:00 | 6
 |  |  |  |  | 2024-07-20 00:00:00 | 2024-07-20 00:00:00 | -1
Spreadsheet: 149915d1334187147-excel-2003-how-do-i-copy-contents-of-cells-identified-by-sumproduct-ef74a_sample-2-
Sheet: Sheet3

Select Criteria | Description | Filter
Actors | List all Actors | INDEX(Head_5,ROW()-1)="Actor"
Actresses | List all Actresses | INDEX(Head_5,ROW()-1)="Actress"
Male | List all Male | INDEX(Head_6,ROW()-1)="M"
Female | List all Female | INDEX(Head_6,ROW()-1)="F"
Shop 1 | List those from Shop 1 | INDEX(Head_4,ROW()-1)="Shop 1"
Shop 2 | List those from Shop 2 | INDEX(Head_4,ROW()-1)="Shop 2"
Shop 3 | List those from Shop 3 | INDEX(Head_4,ROW()-1)="Shop 3"
Shop 4 | List those from Shop 4 | INDEX(Head_4,ROW()-1)="Shop 4"
Shop 5 | List those from Shop 5 | INDEX(Head_4,ROW()-1)="Shop 5"
Shop 6 | List those from Shop 6 | INDEX(Head_4,ROW()-1)="Shop 6"
Shop 7 | List those from Shop 7 | INDEX(Head_4,ROW()-1)="Shop 7"
Shop 8 | List those from Shop 8 | INDEX(Head_4,ROW()-1)="Shop 8"
Shop 9 | List those from Shop 9 | INDEX(Head_4,ROW()-1)="Shop 9"
Shop 10 | List those from Shop 10 | INDEX(Head_4,ROW()-1)="Shop 10"
Shop 11 | List those from Shop 11 | INDEX(Head_4,ROW()-1)="Shop 11"
Shop 12 | List those from Shop 12 | INDEX(Head_4,ROW()-1)="Shop 12"
Shop 13 | List those from Shop 13 | INDEX(Head_4,ROW()-1)="Shop 13"
Shop 14 | List those from Shop 14 | INDEX(Head_4,ROW()-1)="Shop 14"
Shop 15 | List those from Shop 15 | INDEX(Head_4,ROW()-1)="Shop 15"
Shop 16 | List those from Shop 16 | INDEX(Head_4,ROW()-1)="Shop 16"
Shop 17 | List those from Shop 17 | INDEX(Head_4,ROW()-1)="Shop 17"
Shop 18 | List those from Shop 18 | INDEX(Head_4,ROW()-1)="Shop 18"
Shop 19 | List those from Shop 19 | INDEX(Head_4,ROW()-1)="Shop 19"
Shop 20 | List those from Shop 20 | INDEX(Head_4,ROW()-1)="Shop 20"
Pay Numbers <3500000 | List Pay Numbers less than 3500000 | INDEX(Head_2,ROW()-1)<3500000
Pay Numbers >=3500000 | List Pay Numbers above 3500000 | INDEX(Head_2,ROW()-1)>=3500000
Actors beginning B | List Actors with names beginning with B | AND(INDEX(Head_5,ROW()-1)="Actor",LEFT(INDEX(Name,ROW()-1),1)="B")
Spreadsheet: 02b6bd8b-97cd-4a16-942a-15ec494cdac4
Sheet: Pop 20-24

 | 1960 | 1961 | 1962 | 1963 | 1964 | 1965 | 1966 | 1967 | 1968 | 1969 | 1970 | 1971 | 1972 | 1973 | 1974 | 1975 | 1976 | 1977 | 1978 | 1979 | 1980 | 1981 | 1982 | 1983 | 1984 | 1985 | 1986 | 1987 | 1988 | 1989 | 1990 | 1991 | 1992 | 1993 | 1994 | 1995 | 1996 | 1997 | 1998 | 1999 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010
Population 20-24 year olds | 669800 | 695100 | 716200 | 735300 | 773800 | 817800 | 859159 | 929824 | 991828 | 1035159 | 1075643 | 1140607 | 1128504 | 1138271 | 1156689 | 1164852 | 1173358 | 1189213 | 1210115 | 1240002 | 1269148 | 1301866 | 1333401 | 1348438 | 1351931 | 1349451 | 1336709 | 1327203 | 1325819 | 1335896 | 1358360 | 1396764 | 1430396 | 1442801 | 1439785 | 1429521 | 1396866 | 1358251 | 1324276 | 1301080 | 1291138 | 1302412 | 1330110 | 1366686 | 1399667 | 1435898 | 1471858 | 1494136 | 1530590 | 1613332 | 1648245
Australian Bureau of Statistics
3105.0.65.001 - Australian Historical Population Statistics, 2008
http://www.abs.gov.au/ausstats/abs@.nsf/mf/3105.0.65.001
Spreadsheet: 149214d1333746470-i-need-help-salesdata
Sheet: Sales By Country

Country | (Multiple Items)
Order Date | (All)
Products | Sum Of Sales | Sum of Quantity
Beverages | 5944.65 | 4907
Condiments | 2067.35 | 2697
Confections | 3952.930000000001 | 4340
Dairy Products | 4509.000000000001 | 4794
Grains/Cereals | 2152.549999999999 | 2432
Meat/Poultry | 3634.69 | 2331
Produce | 2141.199999999999 | 1456
Seafood | 2914.790000000001 | 4007
Grand Total | 27317.16 | 26964
Spreadsheet: 118981d1314119860-formula-to-convert-text-to-a-date-in-a-date-format-dataconversion
Sheet: Sheet2

Jan | 1 |  | Feb 21 2011
Feb | 2 |  | Mar 12 2011
Mar | 3 |  | Apr 30 2011
Apr | 4 |  | May 21 2011
May | 5 |  | Jun 13 2011
Jun | 6 |  | Jul 15 2011
Jul | 7 |  | Aug 18 2011
Aug | 8 |  | Sep 14 2011
Sep | 9
Oct | 10
Nov | 11
Dec | 12
Spreadsheet: 191300d1352053606-time-and-a-half-calulated-on-real-time-not-after-x-many-hours-worked-timesheettest2
Sheet: Timesheet

 |  | Strt | End | Total Due | Notes
[NAME] | Band A | 2012-03-14 06:30:00 | 2012-03-14 07:30:00 |  | 7hrs @ £13
[NAME] | Band A | 2012-03-15 06:00:00 | 2012-03-15 07:00:00 |  | 6.5hrs @ £13
[NAME] | Band A | 2012-03-15 12:00:00 | 2012-03-16 03:30:00 |  | 5.5hrs @ £13 plus 4hrs @ @19.50
[NAME] | Band B | 2012-03-16 06:00:00 | 2012-03-16 11:30:00 |  | 1.5 hrs @ 22.50 plus 4hrs @ £15
[NAME] | Band C | 2012-03-16 06:00:00 | 2012-03-16 11:30:00 |  | 1.5hrs @ 13.35 plus 4hrs @ 8.90
 | 7.30am - 11.30pm | 11.30pm - 7.30am
Band A | 13
Band B | 15
Band C | 8.9
Spreadsheet: 547918d1510809123-index-and-match-need-particular-given-text-to-arrive-from-a-range-index-match
Sheet: Status

 |  |  |  |  |  |  |  |  |  | SS |  | SSR |  | Trg |  | Trg |  | Docn |  | Docn |  | Imp/IA |  | Imp/IA |  | MA |  | MA |  | MA |  | MA |  |  |  |  |  | Phase-wise Billing |  |  |  |  |  |  |  |  | Mandays as in Proposal
S. No. | Client | City | State | Level | Phase Compltd/WIP | Consultant | Marketing | Proj Start | Proj End | I (On) | Date | I (Off) | Date | II (On) | Date | II (Off) | Date | III (On) | Date | III (Off) | Date | IV (On) | Date | IV (Off) | Date | V (On) | Date | V (Off) | Date | VI (On) | Date | VI (Off) | Date | Accredited | Remarks | % compltn |  | Adv | I | II | III | IV | V | VI | Total |  | I On | I Off | II On | II Off | III On | III Off | IV On | IV Off | V On | V Off | VI On | VI Off | Onsite Total | Offsite Total
1 | Hospital | Rajamundry | AP | EL |  |  |  |  |  | FIN | 2017-10-29 00:00:00 | FIN | 2017-10-29 00:00:00 | FIN | 2017-10-29 00:00:00 | NA | 2017-10-29 00:00:00 |  |  | FIN
Spreadsheet: 1afd8c7f-bc56-40e9-8af3-ac90a15701d3
Sheet: Sheet1

 | Credit  Headcount At Census
 | MSJC SJC Total by Gender
 | AY07-08 |  |  | AY08-09 |  |  | [NAME] |  |  | AY10-11 |  |  | AY11-12 |  |  | AY12-13 |  |  | AY13-14
Gender | SU07 | FA07 | SP08 | SU08 | FA08 | SP09 | SU09 | FA09 | SP10 | SU10 | FA10 | SP11 | SU11 | FA11 | SP12 | SU12 | FA12 | SP13 | SU13 | [NAME] | SP14
Male |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 332 | 2178 | 2177 | 132 | 2286 | 2304
Female |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 307 | 2626 | 2653 | 33 | 2744 | 2789
Undeclared |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 50 | 47 | 0 | 41 | 40
Term Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5133
Academic Year |  |  |  |  |  |  |  |  |  |  |  |  | 7485 |  |  | 7031 |  |  | 7213
% of Total | Credit Headcount % of Total
 | MSJC SJC Total by Gender
 | AY07-08 |  |  | AY08-09 |  |  | [NAME] |  |  | AY10-11 |  |  | AY11-12 |  |  | AY12-13 |  |  | AY13-14
Gender | SU07 | FA07 | SP08 | SU08 | FA08 | SP09 | SU09 | FA09 | SP10 | SU10 | FA10 | SP11 | SU11 | FA11 | SP12 | SU12 | FA12 | SP13 | SU13 | [NAME] | SP14
Male |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.514 | 0.4492 | 0.4459 | 0.7929 | 0.4493 | 0.4489
Female |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.4768 | 0.5406 | 0.5442 | 0.2071 | 0.5426 | 0.5433
Undeclared |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.93 | 0.0102 | 0.0098 | 0 | 0.0081 | 0.0078
Success Rate | Success Rate
 | MSJC SJC Total by Gender
 | AY07-08 |  |  | AY08-09 |  |  | [NAME] |  |  | AY10-11 |  |  | AY11-12 |  |  | AY12-13 |  |  | AY13-14
Gender | SU07 | FA07 | SP08 | SU08 | FA08 | SP09 | SU09 | FA09 | SP10 | SU10 | FA10 | SP11 | SU11 | FA11 | SP12 | SU12 | FA12 | SP13 | SU13 | [NAME] | SP14
Male | 0.8502923976608188 | 0.6163282571912013 | 0.6180645161290322 | 0.8399621212121212 | 0.6140129682997119 | 0.6316227924025325 | 0.852975495915986 | 0.6128321832330055 | 0.6278860569715142 | 0.8717948717948718 | 0.7016087182148417 | 0.6625877271909304 | 0.9785407725321889 | 0.6981754658385093 | 0.6686145146088596 | 0.87 | 0.69 | 0.65 | 0.96 | 0.64 | 0.63
Female | 0.7832957110609481 | 0.6407664453832227 | 0.6369685167153522 | 0.7988410596026491 | 0.6440228762728414 | 0.6451319381255687 | 0.7939698492462312 | 0.667741165234002 | 0.6522268191774154 | 0.817047817047817 | 0.7240022484541877 | 0.6808062575210589 | 1.03448275862069 | 0.7115953307392996 | 0.6790271730971326 | 0.83 | 0.71 | 0.68 | 1 | 0.67 | 0.64
Undeclared | 0.9473684210526315 | 0.6017699115044248 | 0.6027397260273972 | 0.8571428571428571 | 0.6304347826086957 | 0.7 | 0.8333333333333334 | 0.7178217821782178 | 0.6732673267326733 | 0.5714285714285714 | 0.7975460122699386 | 0.6666666666666666 | 1 | 0.7614678899082569 | 0.85 | 0.83 | 0.75 | 0.68 |  | 0.64 | 0.65
Term Average |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.85 | 0.7 |  | 0.97 | 0.66 | 0.64
Success rate = # of “A, B, C, CR & P” grades divided by (the # of all grades) “A, B, C, CR, P, D, F, NC, NP, I and W”
Note: district totals exclude dual enrollment data
Spreadsheet: 777244d1650277565-formula-to-find-repeating-number-patterns-within-single-cells-double-sets-of-three-aligw
Sheet: Sheet1

Service Type | Prefix | Number Length | From | To | Status | Quantity |  |  | AliGW
Special | 1500 | 10 | 1500007007 | 1500007007 | Okay | 1
Special | 1500 | 10 | 1500007009 | 1500007012 | Okay | 4
Special | 1500 | 10 | 1500007013 | 1500007013 | Okay | 1
Special | 1500 | 10 | 1500007014 | 1500007021 | Okay | 8
Special | 1500 | 10 | 1500007023 | 1500007032 | Okay | 10
Special | 1500 | 10 | 1500393392 | 1500393394 | Okay | 3
Special | 1500 | 10 | 1500007089 | 1500007099 | Okay | 11
Special | 1500 | 10 | 1500007116 | 1500007116 | Okay | 1
Special | 1500 | 10 | 1500007119 | 1500007119 | Okay | 1
Special | 1500 | 10 | 1500437124 | 1500437124 | Okay | 1
Special | 1500 | 10 | 1500007127 | 1500007128 | Okay | 2
Special | 1500 | 10 | 1500007132 | 1500007133 | Okay | 2
Special | 1500 | 10 | 1500007135 | 1500007135 | Okay | 1
Special | 1500 | 10 | 1500007137 | 1500007139 | Okay | 3
Special | 1500 | 10 | 1500007142 | 1500007143 | Okay | 2
Special | 1500 | 10 | 1500007145 | 1500007145 | Okay | 1
Special | 1500 | 10 | 1500007146 | 1500007146 | Okay | 1
Special | 1500 | 10 | 1500007149 | 1500007149 | Okay | 1
Spreadsheet: mark_taylor__25000__FLag Football  Roster
Sheet: Roster

 | ENRON 111
 | [NAME] |  | (713)781-1061 x40
 |  |  | TEL NO. |  | [NAME]
7 | RAFAEL AVILA |  | (W)[PHONE] |  | [EMAIL]
 |  |  | ©[PHONE]
17 | DARREN BINNS |  | (W)345-3747 |  | [EMAIL]
 |  |  | ©(713)553-7859
 |  |  | (H)[PHONE]
23 | HUY DINH | Out Season | (W)[PHONE] |  | [EMAIL]
 |  |  | (C)[PHONE]
33 | [NAME] |  | (W)[PHONE] |  | [EMAIL]
 |  |  | (H)[PHONE]
 |  |  | (C)[PHONE]
3 | LONG HA |  | (281)222-6000 |  | [EMAIL]
 | KEVIN MURRAY |  | (W)[PHONE] |  | [EMAIL]
 |  |  | (H)[PHONE]
 |  |  | ©[PHONE]
25 | [NAME] |  | ©[PHONE] |  | [NAME]
 |  |  | (w)[PHONE]
1 | MIEN PHAM |  | ©[PHONE] |  | [EMAIL]
 |  |  | (P)[PHONE]
 |  |  | (W)[PHONE]
 |  |  | (F)[PHONE]
22 | RAHMAN POUNDS |  | (W)[PHONE] |  | [NAME]
 |  |  | ©[PHONE]
 |  |  | (H)[PHONE]
34 | RICHARD ORELLANA |  | (W)[PHONE]
 |  |  | ©[PHONE] |  | [EMAIL]
 |  |  | (H)[PHONE]
4 | EDDIE SERA |  | (W)[PHONE] |  | [EMAIL]
 |  |  | ©[PHONE]
6 | SCOTT TACKETT |  | (W)[PHONE] |  | [EMAIL]
 |  |  | ©[PHONE]
 | MICAH HATTEN |  | (W)[PHONE] |  | MICAH,HATTEN@ENRON
 |  |  | (H)[PHONE]
 |  |  | ©[PHONE]
21 | BAO VINH |  | ©[PHONE] |  | [EMAIL]
 |  |  |  |  | [EMAIL]
16 | [NAME] |  | ©[PHONE] |  | [EMAIL]
2 | MIKE NGUYEN |  | (713)853-7201 |  | [NAME]
 |  |  | (281)804-3468
 | [NAME] |  | (W)[PHONE] |  | [EMAIL]
5 | PAUL HAUN | Not avaliable |  |  | [NAME]
 |  | Util 4th game
15 | AARON GREEN | Only if  Short | (W)[PHONE] |  | [EMAIL]
 |  |  | (H)[PHONE]
 |  |  | ©[PHONE]
7 | WILLIAM WESTBROOK | Out Season | (W)[PHONE] |  | [EMAIL]
 |  |  | (H)[PHONE]
12 | [NAME] | Only if  Short |  |  | [EMAIL]
8 | Extra
9 | Extra
10 | Extra
11 | Extra
12 | Extra
13 | Extra
Spreadsheet: 740630d1626431066-using-multiple-if-functions-with-vlookup-aqa-gcse-mock-mfl-results
Sheet: French Summer 2018

AQA GCSE French Boundaries Summer 2018
 |  | LF |  |  | LH |  |  | RF |  | RH |  | SF |  | SH |  | WF |  |  | WH
 |  | Grade | RM | SM | Grade | RM | SM | Grade | SM | Grade | SM | Grade | SM | Grade | SM | Grade | RM | SM | Grade | SM
 |  | U | 0 |  | U | 0 |  | U | 0 | U | 0 | U | 0 | U | 0 | U | 0 |  | U | 0
 |  | 1 | 5 |  | 3 | 10 |  | 1 | 9 | 3 | 19 | 1 | 7 | 3 | 22 | 1 | 6 |  | 3 | 20
 |  | 2 | 9 |  | 4 | 13 |  | 2 | 20 | 4 | 23 | 2 | 16 | 4 | 27 | 2 | 15 |  | 4 | 26
 |  | 3 | 13 |  | 5 | 16 |  | 3 | 31 | 5 | 27 | 3 | 25 | 5 | 32 | 3 | 24 |  | 5 | 32
 |  | 4 | 18 |  | 6 | 19 |  | 4 | 42 | 6 | 31 | 4 | 34 | 6 | 38 | 4 | 33 |  | 6 | 38
 |  | 5 | 22 |  | 7 | 23 |  | 5 | 45 | 7 | 36 | 5 | 38 | 7 | 44 | 5 | 36 |  | 7 | 44
 |  | [NAME] |  |  | 8 | 30 |  | [NAME] |  | 8 | 42 | [NAME] |  | 8 | 48 | [NAME] |  |  | 8 | 48
 |  | [NAME]. | 40 | 60 | 9 | 38 |  | [NAME]. | 60 | 9 | 49 | [NAME]. | 60 | 9 | 53 | [NAME]. | 50 | 60 | 9 | 53
 |  |  |  |  | [NAME] |  |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  |  | [NAME]
 |  |  |  |  | [NAME]. | 50 | 60 |  |  | [NAME]. | 60 |  |  | [NAME]. | 60 |  |  |  | [NAME]. | 60
 |  | F Tier |  | H Tier
 |  | Grade | MSM | Grade | MSM
 |  | U |  | U
 |  | 1 | 31 | 3 | 72
 |  | 2 | 68 | 4 | 92
 |  | 3 | 105 | 5 | 112
 |  | 4 | 143 | 6 | 132
 |  | 5 | 159 | 7 | 152
 |  | 5 | 240 | 8 | 176
 |  |  |  | 9
 |  |  |  | 9 | 240
Spreadsheet: 719700d1613758414-logic-updates-to-existing-formulas-duplicates-exclusion-lookups-samplep1
Sheet: SHIP

ID |  |  | type | rec count |  | [NAME] |  | [NAME] |  |  | Counts |  |  |  |  | Counts:
1154375 |  |  | Test |  | 4 | No Posting |  |  |  | Test File |  |  |  |  |  |  |  |  |  |  |  | Update 2 -> Can this formula be updated to '-' when not able to calculate (no values to aggregate)
1154375 |  |  | A |  | 4 | No Posting |  | Rp |  |  |  |  |  |  |  |  |  |  |  |  |  | Update 2 -> Can this formula be updated to '-' when not able to calculate (no values to aggregate)
1155626 |  |  | INT |  | 5 | Post 100% |  | Rp
1155626 |  |  | Final | 96849 | 5 | Post 100% |  | C D w/ I |  |  |  |  |  |  |  |  |  |  |  |  |  | Expecting 683,392 final quantity (96,849 + 586,543); formula is currently taking average of these values
1155626 |  |  | A | 50 | 5 | Post 100% |  | A |  |  |  |  |  |  |  |  |  |  |  |  |  | Expecting 683,392 final quantity (96,849 + 586,543); formula is currently taking average of these values
1155626 |  |  | Final | 586543 | 5 | Post 100% |  | C D w/ I |  |  |  |  |  |  |  |  |  |  |  |  |  | Expecting 683,392 final quantity (96,849 + 586,543); formula is currently taking average of these values
1155626 |  |  | Final | 586543 | 5 | Post 100% |  | C D w/o I |  |  |  |  |  |  |  |  |  |  |  |  |  | Expecting 683,392 final quantity (96,849 + 586,543); formula is currently taking average of these values
1162502 |  |  | Final | 81185 | 2 | No Posting |  | C D w/ I |  |  |  |  |  |  |  |  |  |  |  |  |  | Expecting 102,782 final quantity (81,185 + 21,597); formula is currently taking average of these values
1162502 |  |  | Final | 21597 | 2 | Net Down |  | C D w/ I |  |  |  |  |  |  |  |  |  |  |  |  |  | Expecting 102,782 final quantity (81,185 + 21,597); formula is currently taking average of these values
1162502 |  |  | A | 0 | 2 | Net Down |  | A |  |  |  |  |  |  |  |  |  |  |  |  |  | Expecting 102,782 final quantity (81,185 + 21,597); formula is currently taking average of these values
Spreadsheet: mark_guzman__24560__Palo
Sheet: DJ Palo Verde Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2000-10-31 00:00:00 |  | 70.81 | 36432 | 37.45 | 4528
 | 2000-10-30 00:00:00 |  | 77.42 | 13760 | 48.34 | 1208 | 69.06 | 1987 | 31.97 | 485
 | 2000-10-29 00:00:00 |  |  |  |  |  | 44.75 | 495 | 36.07 | 675 |  | 47.07 | 5424
 | 2000-10-28 00:00:00 |  | 72.54 | 26720 | 43.93 | 2704 | 44.87 | 1170 | 36.77 | 1315
 | 2000-10-27 00:00:00 |  | 72.84 | 27376 | 44.16 | 2744 | 67.85 | 315 | 32.71 | 1430
 | 2000-10-26 00:00:00 |  | 78.92 | 29296 | 32.76 | 4488 | 58.45 | 654 | 26.96 | 1528
 | 2000-10-25 00:00:00 |  | 78.92 | 29296 | 32.76 | 4488 | 61.88 | 848 | 23.53 | 1018
 | 2000-10-24 00:00:00 |  | 78.86 | 28096 | 32.76 | 4488 | 76.66 | 802 | 36.09 | 1050
 | 2000-10-23 00:00:00 |  | 85.82 | 30256 | 50.72 | 3528 | 68.26 | 2306 | 35.23 | 1882
 | 2000-10-22 00:00:00 |  | 86 | 2400 | 45 | 0 | 50.02 | 737 | 36.76 | 1412 |  | 49.5 | 5400
 | 2000-10-21 00:00:00 |  | 79.92 | 25552 | 42.9 | 4856 | 55.97 | 1793 | 44.74 | 1780
 | 2000-10-20 00:00:00 |  | 80.01 | 25152 | 42.9 | 4856 | 80.63 | 2209 | 44.59 | 817
 | 2000-10-19 00:00:00 |  | 92.46 | 24912 | 45.52 | 4056 | 85.21 | 1695 | 37.8 | 1240
 | 2000-10-18 00:00:00 |  | 94.58 | 31152 | 51.36 | 3976 | 87.02 | 1053 | 37.22 | 270
 | 2000-10-17 00:00:00 |  | 91.86 | 18800 | 57.25 | 1600 | 81.48 | 1660 | 39.97 | 990
 | 2000-10-16 00:00:00 |  | 80.19 | 23552 | 60.23 | 3936 | 70.36 | 1068 | 43.46 | 1050
 | 2000-10-15 00:00:00 |  | 75 | 0 | 55 | 200 | 43.2 | 1040 | 48.52 | 575 |  | 60.05 | 12600
 | 2000-10-14 00:00:00 |  | 67.28 | 18160 | 46.85 | 3072 | 59.2 | 2163 | 48.51 | 1113
 | 2000-10-13 00:00:00 |  | 67.28 | 18160 | 46.85 | 3072 | 85.41 | 1185 | 53.58 | 405
 | 2000-10-12 00:00:00 |  | 81.37 | 34160 | 43.86 | 4200 | 64.09 | 1205 | 39.19 | 883
 | 2000-10-11 00:00:00 |  | 90.92 | 30000 | 52.4 | 3720 | 59.88 | 1180 | 46.72 | 250
 | 2000-10-10 00:00:00 |  | 91.26 | 22400 | 53.83 | 4376 | 78.03 | 1740 | 48.65 | 850
 | 2000-10-09 00:00:00 |  | 108.45 | 24800 | 72.66 | 4016 | 83.4 | 1962 | 41.75 | 621
 | 2000-10-08 00:00:00 |  | 90 | 0 | 60 | 40 | 57.21 | 1851 | 44.92 | 1268 |  | 72.79 | 11928
 | 2000-10-07 00:00:00 |  | 100.53 | 28000 | 51.59 | 4200 | 51.56 | 574 | 49.97 | 547
 | 2000-10-06 00:00:00 |  | 100.53 | 28800 | 51.59 | 4200 | 80.18 | 702 | 52.1 | 492
 | 2000-10-05 00:00:00 |  | 125.05 | 31616 | 66.07 | 3000 | 73.79 | 1372 | 46.23 | 862
 | 2000-10-04 00:00:00 |  | 126.6 | 42016 | 54.28 | 2480 | 89.08 | 860 | 71.9 | 999
 | 2000-10-03 00:00:00 |  | 153.75 | 35616 | 53.25 | 2720 | 114.62 | 885 | 58.21 | 946
 | 2000-10-02 00:00:00 |  | 132.5 | 35712 | 82.72 | 3200 | 96.76 | 1170 | 44.65 | 246
 | 2000-10-01 00:00:00 |  | 120 | 400 | 62.39 | 352 | 66.68 | 1902 | 42.9 | 760 |  | 82.69 | 10800
Spreadsheet: 546937d1510254969-pto-tracker-pto-forum
Sheet: Sheet2

Indianapolis
Employee | Cary Over |  | January |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  | [NAME] |  | October |  | November |  | December |  | Hire Date | Days Received
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-05-03 00:00:00 | 10 | 3
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-01-25 00:00:00 | 10 | 3
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2014-06-23 00:00:00 | 10 | 3
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-12-05 00:00:00 | 10 | 3
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016-08-03 00:00:00 | 10 | 3
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-05-28 00:00:00 | 10 | 3
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-03-09 00:00:00 | 10 | 3
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-02-05 00:00:00 | 10 | 3
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 3
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 3
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 3