tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 473835d1470419908-mileage-reimbursement-form-formulas-not-working-mileage-reimbursement
Sheet: Ref-Mileage

Mileage Chart | Amityville | Bay Shore 180 | Bay Shore 375 | Hauppauge (LIVM / MCM) | Brentwood | Hauppauge | Huntington | Port Jefferson | Sayville | West Islip | Deer Park | Garden City | Hempstead | Holbrook | Riverhead | Smithtown | Southampton | Southold | [NAME] (NSEYE) | Little Neck | Other (Please explain thoroughly in the next column)
Amityville |  | 11.8 | 11.4 | 17 | 13.9 | 16.6 | 17.1 | 33 | 19.4 | 8.9 | 9 | 16 | 15 | 25 | 45 | 23 | 59 | 62 | 14 | 23
Bay Shore 180 | 11.8 |  | 0.4 | 6.7 | 4.6 | 6.5 | 18 | 23.7 | 9.6 | 3.6 | 6 | 25 | 24 | 13 | 36 | 16 | 49 | 57 | 18 | 33
Bay Shore 375 | 11.4 | 0.4 |  | 6.2 | 4.3 | 6.2 | 18.5 | 23.3 | 9.6 | 4 | 9 | 26 | 26 | 13 | 35 | 12 | 49 | 57 | 19 | 34
Hauppauge (LIVM / Middle Country Management) | 17 | 6.7 | 6.2 |  | 3.1 | 1.8 | 11 | 20.2 | 12.8 | 9.9 | 7 | 25 | 26 | 10 | 32 | 9 | 50 | 52 | 11 | 27
Brentwood | 13.9 | 4.6 | 4.3 | 3.1 |  | 2.5 | 13.1 | 18.8 | 11.3 | 7.6 | 5 | 25 | 26 | 11 | 33 | 8 | 51 | 52 | 13 | 28
Hauppauge | 16.6 | 6.5 | 6.2 | 1.8 | 2.5 |  | 12.4 | 14.2 | 13.4 | 11 | 7 | 24 | 25 | 9 | 32 | 6 | 49 | 51 | 12 | 27
[NAME] (LIEYE) | 17.1 | 18 | 18.5 | 11 | 13.1 | 12.4 |  | 25.2 | 23.8 | 18.7 | 10 | 18 | 19 | 21 | 43 | 17 | 61 | 63 | 1 | 20
Port Jefferson | 33 | 23.7 | 23.3 | 20.2 | 18.8 | 14.2 | 25.2 |  | 16 | 27.5 | 27 | 39 | 40 | 11 | 19 | 10 | 45 | 37 | 25 | 46
Sayville | 19.4 | 9.6 | 9.6 | 12.8 | 11.3 | 13.4 | 23.8 | 16 |  | 15 | 17 | 38 | 34 | 6 | 28 | 13 | 42 | 49 | 26 | 41
West Islip | 8.9 | 3.6 | 4 | 9.9 | 7.6 | 11 | 18.7 | 27.5 | 15 |  | 6 | 33 | 32 | 18 | 40 | 17 | 53 | 62 | 19 | 34
Deer Park | 9 | 6 | 9 | 7 | 5 | 7 | 10 | 27 | 17 | 6 |  | 21 | 20 | 16 | 39 | 14 | 56 | 58 | 10 | 24
Garden City | 16 | 25 | 26 | 25 | 25 | 24 | 18 | 39 | 38 | 33 | 21 |  | 0.8 | 33 | 55 | 30 | 72 | 74 | 19 | 8
Hempstead | 15 | 24 | 26 | 26 | 26 | 25 | 19 | 40 | 34 | 32 | 20 | 0.8 |  | 33 | 56 | 31 | 72 | 75 | 20 | 7
Holbrook | 25 | 13 | 13 | 10 | 11 | 9 | 21 | 11 | 6 | 18 | 16 | 33 | 33 |  | 23 | 9.1 | 40 | 42 | 20 | 37
Riverhead | 45 | 36 | 35 | 32 | 33 | 32 | 43 | 19 | 28 | 40 | 39 | 55 | 56 | 23 |  | 32 | 21 | 20 | 45 | 58
Smithtown | 23 | 16 | 12 | 9 | 8 | 6 | 17 | 10 | 13 | 17 | 14 | 30 | 31 | 9.1 | 32 |  | 47 | 49 | 15 | 33
Southampton | 59 | 49 | 49 | 50 | 51 | 49 | 61 | 45 | 42 | 53 | 56 | 72 | 72 | 40 | 21 | 47 |  | 34 | 60 | 75
Southold | 62 | 57 | 57 | 52 | 52 | 51 | 63 | 37 | 49 | 62 | 58 | 74 | 75 | 42 | 20 | 49 | 34 |  | 61 | 80
[NAME] (NSEYE) | 14 | 18 | 19 | 11 | 13 | 12 | 1 | 25 | 26 | 19 | 10 | 19 | 20 | 20 | 45 | 15 | 60 | 61 |  | 21
Little Neck | 23 | 33 | 34 | 27 | 28 | 27 | 20 | 46 | 41 | 34 | 24 | 8 | 7 | 37 | 58 | 33 | 70 | 80 | 21
[NAME] | 80 | 65 | 78 | 98 | 214 | 487
Spreadsheet: 61031d1261601178-calculating-time-time-analysis-help
Sheet: Sheet1

 | PAYROLL | MONDAY |  | TUESDAY |  | WEDNESDAY |  | THURSDAY |  | FRIDAY |  | MONDAY |  | TUESDAY |  | WEDNESDAY |  | THURSDAY |  | FRIDAY |  | MINUTES | MINUTES | # DAYS | # DAYS
 |  | IN | OUT | IN | OUT | IN | OUT | IN | OUT | IN | OUT | IN | OUT | IN | OUT | IN | OUT | IN | OUT | IN | OUT | LATE | OUT EARLY | LATE | OUT EARLY
CLOCK TIME | 2009-08-01 00:00:00 | 07:58:00 | 17:15:00 | 08:03:00 | 17:00:00 | 07:58:00 | 16:59:00 | 07:17:00 | 16:57:00 | 07:51:00 | 16:58:00 | 07:57:00 | 16:28:00 | 07:56:00 | 16:58:00 | 07:51:00 | 16:58:00 | 07:51:00 | 17:00:00 | 08:00:00 | 16:56:00 |  |  | 1 | 6
TIMESHEET |  | 08:00:00 | 17:15:00 | 08:00:00 | 17:00:00 | 08:00:00 | 17:00:00 | 08:00:00 | 17:00:00 | 08:00:00 | 17:00:00 | 08:00:00 | 16:28:00 | 08:00:00 | 17:00:00 | 08:00:00 | 17:00:00 | 08:00:00 | 17:00:00 | 08:00:00 | 17:00:00
CLOCK TIME | 2009-08-15 00:00:00 | 07:57:00 | 16:59:00 | 07:59:00 | 16:58:00 | 07:56:00 | 11:50:00 |  |  | 07:56:00 | 16:56:00 | 07:58:00 | 16:59:00 | 07:57:00 | 17:01:00 | 07:56:00 | 17:01:00 | 08:00:00 | 16:59:00 | 07:52:00 | 16:58:00 |  |  |  | 6
TIMESHEET |  | 08:00:00 | 17:00:00 | 08:00:00 | 17:00:00 | 08:00:00 | 11:55:00 |  |  | 08:00:00 | 17:00:00 | 08:00:00 | 17:00:00 | 08:00:00 | 17:00:00 | 08:00:00 | 17:00:00 | 08:00:00 | 17:00:00 | 08:00:00 | 17:00:00
CLOCK TIME | 2009-08-29 00:00:00 | 07:55:00 | 16:59:00 | 07:52:00 | 16:59:00 | 07:51:00 | 16:57:00 | 07:54:00 | 17:00:00 | 07:52:00 | 16:57:00 |  |  | 07:51:00 | 17:00:00 | 07:51:00 | 16:58:00 | 07:55:00 | 16:57:00 | 07:51:00 |  |  |  |  | 6
TIMESHEET |  | 08:00:00 | 17:00:00 | 08:00:00 | 17:00:00 | 08:00:00 | 17:00:00 | 08:00:00 | 17:00:00 | 08:00:00 | 17:00:00 |  |  | 08:00:00 | 17:00:00 | 08:00:00 | 17:00:00 | 08:00:00 | 17:00:00 | 08:00:00 | 17:00:00
Minutes early | 2009-08-01 00:00:00
Minutes late | 2009-08-01 00:00:00
Spreadsheet: 273726d1382885597-help-need-a-monthly-formula-hermes5187
Sheet: Quality - Monthly

Quality - Monthly
 | Section 2
 | Ordered | Completed
2013-01-01 00:00:00 | 0 | 0
2013-02-01 00:00:00 | 0 | 0
2013-03-01 00:00:00 | 0 | 0
2013-04-01 00:00:00 | 6 | 10
2013-05-01 00:00:00 | 17 | 38
2013-06-01 00:00:00 | 47 | 42
2013-07-01 00:00:00 | 9 | 11
2013-08-01 00:00:00 | 25 | 19
2013-09-01 00:00:00 | 0 | 0
2013-10-01 00:00:00 | 0 | 0
2013-11-01 00:00:00 | 0 | 0
2013-12-01 00:00:00 | 0 | 0
Spreadsheet: 182873d1348645294-formula-that-can-merge-multiple-rows-with-the-same-id-into-one-row-0a1_fot_sample-55-
Sheet: Φύλλο1

 |  |  |  | Uniques ids
1234 | A
1234 | B
1234 | C
1234 | D
5678 | g
6785 | B
 |  |  | Normal Formula
 |  |  |  |  |  |  | Array formulae.
 |  |  | I want the Column A that has the same value to combine Column B into one row to look like this:
 |  |  | Column A Column B Column C Column D Column E
 |  |  | 1234 A B C D
 |  |  | 5678 A
 |  |  | 6785 B
Spreadsheet: 275437d1383514000-sum-cells-based-on-current-month-report-template
Sheet: workings

 | DRAFT reporting template |  | Yesterdays date
 |  | Yesterday |  | Last Week |  | Total of month so far
 | Retail |  |  |  |  | ?
 | Direct |  |  |  |  | ?
 | Corporate |  |  |  |  | ?
 | Total
Spreadsheet: 821180d1678484992-copying-only-certain-items-to-separate-sheet-based-on-if-formula-ams-pq-parameter
Sheet: Sheet1

Time | Party Room | Party Name | Items | Time2 | Quantity |  | Items
10:00:00 | 1 | Billys bday | Laser Tag | 13:00:00 | 10 |  | Laser Tag
 |  |  | Go Karts | 13:15:00 | 10
11:30:00 | 1 | [NAME] | Go Karts | 14:00:00 | 12
12:00:00 | 1 | George | Go Karts | 15:00:00 | 10
 |  |  | Laser Tag | 15:00:00 | 10
Spreadsheet: 37788d1235799415-displaying-after-search-nonarraymultiplelookup
Sheet: Sheet1

 | Select | Year | Col1 | Col2 | Col3
Company | ABC | 2005 | 3 | 2 | 0 |  | This is done without array formulas (which slow down larger spreadsheets)
 |  | 2006 | 4 | 7 | 5 |  | by adding "key" helper column on your data sheet2.
 |  | 2007 | 1 | 4 | 2
 |  | 2005 | 4 | 5 | 6 |  | As you select from the businesses in B2, the key will change and renumber
 |  | 2006 | 3 | 4 | 6 |  | to flag the appropriate data rows on that sheet.
 |  | 2007 | 12 | 4 | 2
 |  |  |  |  |  |  | Then the formulas in the tan section will see if their row # is within the number
 |  |  |  |  |  |  | of valid answers from the key, if so, they will appear. When the row # exceeds
 |  |  |  |  |  |  | the maximum of the current "key", the rows stop showing results and stay blank.
Spreadsheet: 674206d1587717620-using-if-to-return-1-or-0-for-a-range-of-cells-formula_test
Sheet: Sheet1

2.2.1 | 2.2.2 | 2.2.3 | Sense of Community - Strongly Agree | Sense of Community - Tend to Agree | Sense of Community - Neither Agree nor Disagree | Sense of Community - Tend to Agree | Sense of Community - Strongly Agree | Sense of Community - Don't Know | Can Influence Decisions - Strongly Agree | Can Influence Decisions - Tend to Agree | Can Influence Decisions - Neither Agree nor Disagree | Can Influence Decisions - Tend to Agree | Can Influence Decisions - Strongly Agree | Can Influence Decisions - Don't Know | People Get on Well - Strongly Agree | People Get on Well - Tend to Agree | People Get on Well - Neither Agree nor Disagree | People Get on Well - Tend to Agree | People Get on Well - Strongly Agree | People Get on Well - Don't Know
c | d | b
c | c | c
f | f | f
e | e | b
a | a | a
c | f | a
a | c | b
a | c | c
b | c | b
a | d | c
c | c | a
a | d | a
b | d | b
b | f | a
a | e | a
c | e | c
f | c | b
c | e | c
c | e | c
a | d | a
a | d | a
b | f | b
a | c | d
b | a | b
a | c | a
a | b | b
b | c | c
Spreadsheet: 98cfe7ca-6072-4d30-96ea-3db68ece61d8
Sheet: Sheet1

STATE OF NEW HAMPSHIRE | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
ELECTIONS DIVISION
STATE GENERAL ELECTION - November 4, 2008
HILLSBOROUGH COUNTY/BALLOTS CAST
November 4,2008 | Regular | Absentee | Total
Amherst | 6393 | 1076 | 7469
Antrim | 1395 | 151 | 1546
[NAME]* | 10279 | 2485 | 12764
Bennington | 743 | 49 | 792
Brookline | 2657 | 234 | 2891
Deering | 987 | 67 | 1054
Francestown | 937 | 134 | 1071
Goffstown | 8361 | 760 | 9121
[NAME] | 869 | 59 | 928
Greenville | 907 | 71 | 978
Hancock | 1096 | 134 | 1230
Hillsborough | 2685 | 232 | 2917
Hollis | 4549 | 559 | 5108
Hudson | 11615 | 802 | 12417
Litchfield | 4295 | 319 | 4614
Lyndeborough | 953 | 87 | 1040
[NAME] | 4794 | 711 | 5505
[NAME] | 4355 | 475 | 4830
[NAME] 3 | 2744 | 360 | 3104
[NAME] | 3161 | 278 | 3439
[NAME] | 2733 | 160 | 2893
[NAME] 6 | 4465 | 450 | 4915
[NAME] | 3575 | 225 | 3800
[NAME] 8 | 4564 | 411 | 4975
[NAME] 9 | 3814 | 323 | 4137
[NAME] 10 | 3838 | 320 | 4158
[NAME] 11 | 2824 | 149 | 2973
[NAME] 12 | 3885 | 533 | 4418
Mason | 800 | 70 | 870
Merrimack | 14292 | 911 | 15203
Milford | 7276 | 574 | 7850
[NAME] | 1383 | 122 | 1505
[NAME] | 5037 | 508 | 5545
[NAME] | 4344 | 374 | 4718
[NAME] | 4058 | 415 | 4473
[NAME] | 2904 | 209 | 3113
[NAME] | 4882 | 490 | 5372
[NAME] | 3863 | 302 | 4165
[NAME] | 3664 | 303 | 3967
[NAME] | 4151 | 455 | 4606
[NAME] 9 | 4760 | 601 | 5361
New Boston | 2870 | 266 | 3136
New Ipswich** | 2374 | 204 | 2578
[NAME] | 6585 | 451 | 7036
Peterborough | 3414 | 547 | 3961
[NAME] | 218 | 40 | 258
Temple | 803 | 79 | 882
Weare | 4385 | 354 | 4739
[NAME] | 2088 | 225 | 2313
Windsor | 117 | 9 | 126
Totals | 187741 | 19123 | 206864
*correction submitted by clerk on 11/19/08
**correction submitted by clerk - corrected 1/15/09
Spreadsheet: 178717b0-f9b2-4f63-b60b-8c02ad2f8fc7
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Taseis | 859219001397 | [NAME] | Live In Chicago | 2010-10-26 | DVD | Comedy | 11.99 | Y | Available
Image Entertainment | 14381771527 | [NAME] | [NAME] | 2013-12-03 | DVD | Comedy | 14.98 | Y | Available
[NAME] Csr | 80688612290 | [NAME] | Four-Eyed Blonde Clean Comedy | 2004-11-09 | DVD | Comedy | 7.99 | Y | Available
[NAME] Csr | 80688636593 | [NAME] | Last Word Clean Comedy, The | 2004-12-07 | DVD | Comedy | 7.99 | Y | Available
[NAME] Csr | 80688636296 | [NAME] | Girls Night Out Clean Comedy | 2004-11-09 | DVD | Comedy | 7.99 | Y | Available
Warner Bros Rec | 75993868623 | [NAME] | Whats That [NAME] | 2006-08-08 | DVD | Comedy | 14.95 | Y | Available
Taseis | 805569430493 | Sister Cantaloupe | Laffin Out Loud With The Lord | 2004-08-10 | DVD | Comedy | 14.95 | Y | Available
Taseis | 805569411195 | Sister Cantaloupe | Go Cantaloupe Go | 2004-08-10 | DVD | Comedy | 14.95 | Y | Available
Spreadsheet: 3a67e385-2eec-4f5f-9571-8a1f8f120743
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
43482292 | 2014-10-07 21:32:27 | AXIS | 0 | 5 | 6 | 1600642 | ZZZED | 12497 | pacific | 1942-09-12 | 1942-09-14 | Bloody Ridge | [NAME]
Spreadsheet: 215921d1361541678-sum-of-sum-tableau-entrep-ts
Sheet: A1

[NAME]
Nom: | [NAME]
Numéro de téléphone: | [PHONE]
[NAME]:
Paiement dû le: | 2013-03-01 00:00:00
[NAME]: | 9
Réservé:
Prix: | 140
Payé: | OUI
Mois réservés
Novembre 2011
Décembre 2011
Janvier 2012
Février 2012
Mars 2012
Avril 2012
Mai 2012
[NAME] 2012
Juillet 2012
Août 2012
Septembre 2012
Octobre 2012
Novembre 2012
Décembre 2012
Spreadsheet: 85168d1285223209-divide-by-zero-errors-kitchen-replacement-programme-2010-11_revised_web_upload2
Sheet: Cyclical Completions

 |  | Properties Instructed |  | Projected Spend
 |  | Proposed Property Completions |  | Initial Costs |  | Final Costs |  |  |  | Actual Property Completions |  | Actual Costs
 |  | Aug |  |  |  |  |  |  |  | Aug
 |  | Sept |  |  |  |  |  |  |  | Sept
 |  | Oct |  |  |  |  |  |  |  | Oct
 |  | Nov |  |  |  |  |  |  |  | Nov
 |  | Dec |  |  |  |  |  |  |  | Dec
 |  | Jan |  |  |  |  |  |  |  | Jan
 |  | Feb |  |  |  |  |  |  |  | Feb
 |  | Mar |  |  |  |  |  |  |  | Mar
 |  | Apr |  |  |  |  |  |  |  | Apr
 |  | May |  |  |  |  |  |  |  | May
 |  | Jun |  |  |  |  |  |  |  | Jun
 |  | All Properties |  | Projected Spend |  |  |  |  |  | Average Figures
 |  | Proposed Property Completions |  | Initial Costs |  | Final Costs
 |  |  |  |  |  |  |  |  |  | Initial Works Order Value
 |  | Aug
 |  | Sept |  |  |  |  |  |  |  | Variations
 |  | Oct
 |  | Nov |  |  |  |  |  |  |  | Final Works Order Value
 |  | Dec
 |  | Jan
 |  | Feb
 |  | Mar
 |  | Apr
 |  | May
 |  | Jun
 |  | Over All Totals
 |  | Initial Works Order Value
 |  | Variations
 |  | Final Works Order Value
 |  | Projected Over Spend Based on Initial W/O Costs
 |  | Projected Total Av.
 |  | Over Spend
 |  | Projected Over Spend Based on Final W/O costs
 |  | Projected Total Av.
 |  | Over Spend
Spreadsheet: 818464d1676858982-display-the-result-from-my-summary-table-to-dynamic-calendar-dynamic-calendar-excel-forum-2-
Sheet: Summary Sheet

 | 2023-03-01 00:00:00
Spreadsheet: 879318d1726802250-subtotalifs-9-summing-only-the-visible-cells-with-a-condition-hide-rows-from-subtotal
Sheet: Exp by Month

STRAT_TYPE | OPERATING
EXECUTIVE_GROUP | CHIEF OPERATING OFFICER
BUDGET_REF | 2024
MONETARY_AMOUNT |  |  |  | DATA_TYPE |  |  | Is total?
UNIT_DESCR | DEPTID | DEPTID_DESCR | BUD_ACCOUNT | BUDGET | EXPENSE | PROJECTION
CENTER FOR LEARNING & ORGANIZ | 00CLOSCP | CLOE - STATE OFFICE CP | L1001 | 8154276.8917 | 7918028.314499969 | 7963416.731699999
 |  |  | [NAME] | 67765.383 | 42111.78800000007 | 42111.533
 |  |  | L1002 | 250057.8366 | 380921.7281999995 | 381134.4966
 |  | CLOE - STATE OFFICE CP Total |  | 9304513.4 | 9170703.978799965 | 9220715.14
 | 00FCLCLO | FCL CLOE - STATE OFFICE | L1001 | 54581.2644 | 52396.3284 | 52396.4844
 |  |  | L1002 | 1881.5748 | 4037.8464 | 4037.8548
 |  | FCL CLOE - STATE OFFICE Total |  | 56327.7 | 56145.01620000001 | 56145.18
RECORDS MANAGEMENT | 00RMDOSS | RECORDS MANAGEMENT | L1001 | 5822408.792 | 5289474.208000054 | 5289474.392000001
 |  |  | [NAME] | 134252.0236 | 114123.3113999999 | 114123.4836
 |  |  | L1002 | 166128.3715 | 217928.9930000041 | 217929.0215
 |  | RECORDS MANAGEMENT Total |  | 6550279.439999999 | 6003157.355800061 | 6003157.76
TALENT ACQUISITION GROUP | 00TAGRCP | TALENT ACQUISITION GROUP | L1001 | 2885638.5516 | 2685528.308400002 | 2739190.4316
 |  |  | [NAME] | 11506.433 | 6367.426499999998 | 6367.333
 |  |  | L1002 | 80171.7542 | 159657.9938000002 | 162577.8142
 |  | TALENT ACQUISITION GROUP Total |  | 3329520.42 | 3186784.700600002 | 3250026.5
Spreadsheet: 282237cb-bf91-47ec-a6e8-e112fe808019
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
42667650 | 2014-08-10 18:51:02 | ALLIES | 1 | 6 | 1 | 412088 | [NAME] | 12504 | mediterranean | 1943-11-05 | 1943-11-13 | [NAME] | [NAME]
42667785 | 2014-08-10 19:15:10 | AXIS | 1 | 6 | 5 | 412088 | [NAME] | 12504 | mediterranean | 1943-11-05 | 1943-11-13 | [NAME] | [NAME]
42747743 | 2014-08-16 15:19:17 | ALLIES | 1 | 6 | 2 | 400481 | Invictus - Team du Sud | 6154 | mediterranean | 1944-08-20 | 1944-08-26 | Toulon | Toulon
42747956 | 2014-08-16 15:38:13 | AXIS | 0 | 1 | 6 | 400481 | Invictus - Team du Sud | 6154 | mediterranean | 1944-08-20 | 1944-08-26 | Toulon | Toulon
Spreadsheet: 268867d1380870249-help-with-logical-value-test-squash110-sample-workbook
Sheet: Sheet1

Screening Date | Employee ID | FirstName | LastName | Gender | DOB | TotalCholesterol | HDL | Triglycerides | TCOverHDL | LDL | Fasting GLU | NON FASTING GLU | SystolicBP | DiastolicBP | BMI | BodyFatPercentage | HeightFt | HeightIn | Weight | RestingHeartRate | Waist | A1CPercentage | Nicotine | Screening Location | Risk Factor
2011-01-10 00:00:00 |  | [NAME] | Doe | F | 1960-05-27 00:00:00 | 181 | 31 | 306 | 5.8 | 89 | 154 |  | 164 | 105 | 30 | 36.3 | 5 | 6 | 186 |  | 40 |  | Y | Pasco
2011-01-10 00:00:00 |  | Jon | Smith | M | 1972-08-14 00:00:00 | 293 | 33 | 439 | 9 |  | 104 |  | 146 | 81 | 25 | 22 | 5 | 10 | 180 | 88 | 34 |  | Yes | Pasco
Spreadsheet: martin_cuilla__25348__Bowl2000
Sheet: Games

NAME:________________________________________ |  |  |  | ENTRIES DUE BY TUESDAY, DEC 19
BOWL POOL 2000
$20 entry fee.                           All Picks are against the spread
Circle each of your picks against the spread.  Then pick your 5 bonus games.
You will receive 5 extra points for your bonus games that you get right against the spread
[NAME] will be TOTAL score of the "so-called" national championship Orange Bowl on January 3rd
Date | Bowl Game | Favorite |  | Spd | Underdog
2000-12-20 00:00:00 | Mobile Bowl |  | TCU | 6.5 | Southern Miss
2000-12-21 00:00:00 | Las Vegas Bowl |  | Arkansas | - | UNLV
2000-12-24 00:00:00 | Oahu Bowl |  | Georgia | 10.5 | Virginia
2000-12-25 00:00:00 | Aloha Bowl |  | Arizona St. | 3.5 | Boston College
2000-12-27 00:00:00 | Motor City Bowl |  | Cincinnati | 4.5 | [NAME]
2000-12-27 00:00:00 | GalleryFurniture.com |  | Texas Tech | 1.5 | East Carolina
2000-12-28 00:00:00 | [NAME] |  | Boise St. | 6.5 | UTEP
2000-12-28 00:00:00 | Music City Bowl |  | Mississippi | 4.5 | West Virginia
2000-12-28 00:00:00 | [NAME] PC Bowl |  | Minnesota | 3.5 | NC State
2000-12-28 00:00:00 | Insight.com Bowl |  | Iowa St. | - | Pittsburgh
2000-12-29 00:00:00 | Liberty Bowl |  | Colorado St. | 1.5 | Louisville
2000-12-29 00:00:00 | Sun Bowl |  | Wisconsin | 4.5 | UCLA
2000-12-29 00:00:00 | Peach Bowl |  | Georgia Tech | 7.5 | LSU
2000-12-29 00:00:00 | Holiday Bowl |  | Texas | 6.5 | Oregon
2000-12-30 00:00:00 | Alamo Bowl |  | Nebraska | 13.5 | Northwestern
2000-12-31 00:00:00 | Silicon Valley Bowl |  | Air Force | - | Fresno St.
2000-12-31 00:00:00 | Independence Bowl |  | Mississippi St. | - | Texas A&M
2000-01-01 00:00:00 | Cotton Bowl |  | Kansas St. | 3.5 | Tennessee
2000-01-01 00:00:00 | Outback Bowl |  | Ohio St. | 5.5 | South Carolina
2000-01-01 00:00:00 | Gator Bowl |  | [NAME] | 6.5 | Clemson
2000-01-01 00:00:00 | Citrus Bowl |  | Michigan | 7.5 | Auburn
2000-01-01 00:00:00 | Rose Bowl |  | Washington | - | Purdue
2000-01-01 00:00:00 | Fiesta Bowl |  | Oregon St. | 2.5 | Notre Dame
2000-01-02 00:00:00 | Sugar Bowl |  | Miami, Fl | 4.5 | Florida
2000-01-03 00:00:00 | Orange Bowl |  | Florida St. | 11 | Oklahoma
Orange Bowl Final Score |  |  | Florida St.-----------> |  | Oklahoma-------------->
Spreadsheet: 691763d1597858247-extrapolating-existing-data-plus-increase-decrease-on-forecasted-assumptions-dummy
Sheet: Assumptions

Business Growth Assumption
 | MoM Growth
August | 0.01
September | 0.02
October | 0.03
November | -0.01
December | -0.02
Seasonal dips/increases
August | -0.01
September | 0.005
October | 0
November | 0
December | -0.005
Operational Assumptions
Deletions
SKONTO
Re-Alignments
Spreadsheet: 860619d1708643366-how-to-sort-data-which-includes-alpha-as-well-as-numerals-new-sort
Sheet: Planilha1

W-123
S-3 |  | M-98
[NAME] |  | M-121
[NAME] |  | M-131
P-66 |  | M-139
M-98 |  | M-168
P-230 |  | M-171
M-171 |  | M-182
P-152 |  | [NAME]
W-257 |  | M-221
[NAME] |  | [NAME]
M-182 |  | M-300
W-115 |  | N-11
M-221 |  | N-15
N-18 |  | N-18
M-168 |  | P-66
M-121 |  | P-152
W-62 |  | [NAME]
M-300 |  | P-230
M-131 |  | S-3
M-59 |  | [NAME]
[NAME] |  | W-62
N-11 |  | W-115
N-15 |  | W-123
M-139 |  | W-200
W-200 |  | W-257
Spreadsheet: 214972d1361213135-find-add-and-return-values-from-multiple-worksheets-total-hour-on-subject
Sheet: Totals

Name | Course A | Time spent | Course B | Time spent | Course C | Time spent
Adam | Maths | 4 | English | 6 | Science | 6
Eve | English | 7 | French | 4 | Maths | 5
[NAME] | Maths | 6 | Science | 3 | Geography | 6
0 |  | 0 |  | 0 |  | 0
0 |  | 0 |  | 0 |  | 0
0 |  | 0 |  | 0 |  | 0
0 |  | 0 |  | 0 |  | 0
0 |  | 0 |  | 0 |  | 0
0 |  | 0 |  | 0 |  | 0
0 |  | 0 |  | 0 |  | 0
0 |  | 0 |  | 0 |  | 0
0 |  | 0 |  | 0 |  | 0
0 |  | 0 |  | 0 |  | 0
0 |  | 0 |  | 0 |  | 0
0 |  | 0 |  | 0 |  | 0
0 |  | 0 |  | 0 |  | 0
0 |  | 0 |  | 0 |  | 0
0 |  | 0 |  | 0 |  | 0
0 |  | 0 |  | 0 |  | 0
0 |  | 0 |  | 0 |  | 0
0 |  | 0 |  | 0 |  | 0
0 |  | 0 |  | 0 |  | 0
Spreadsheet: 67926d1268420569-vlookup-doesnt-work-after-cell-values-are-changed-bom_template
Sheet: Sheet2

Part # | Vendor | Cost
1 | [NAME] | 12
 | IBM | 15
 | Dell | 8
 | D | 7
2 | A | 100
 | B | 105
 | C | 98
 | D | 99
3 | A | 25
 | B | 23
 | C | 26
 | D | 28
4 | A | 55
 | B | 57
 | C | 59
 | D | 63
5 | A | 22
 | B | 20
 | C | 21
 | D | 25
Spreadsheet: 217036d1361973053-percentage-change-between-a-range-of-numbers-please-help-projecting-profits-test_etaf
Sheet: Monthly 3

 | January | February | March | April | May | June | July | August | September | October | November | December
Year 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | Total (%)
Year 2 |  |  |  |  |  |  |  |  |  |  |  |  |  | Total (%)
Year 3 |  |  |  |  |  |  |  |  |  |  |  |  |  | Total (%)
Year 1 |  |  |  |  |  |  |  |  |  | Profit (£) | Gain (%)
 |  |  |  |  |  |  |  | Account Balance
 |  |  |  |  |  |  |  | Peak Drawdown
 |  |  |  |  |  |  |  | Losing Streak
 |  |  |  |  |  |  |  | Winning Streak
Spreadsheet: 168848d1342607448-how-to-ignore-blank-matches-with-an-index-and-choose-the-next-match-if-multiple-matches-index-query-example
Sheet: Review Date

 |  | Review Date
 |  | Client ID | Client | Worker | Date
 |  | 10 | Ian |  | 2012-01-01 00:00:00
 |  | 20 | Billy | [NAME] | 2012-01-05 00:00:00
 |  | 30 | [NAME] | [NAME] | 2012-01-10 00:00:00
 |  | 40 | Mark | [NAME] | 2012-02-15 00:00:00
 |  | 10 | Ian | [NAME] | 2012-02-16 00:00:00
 |  | 10 | Ian | [NAME] | 2012-02-16 00:00:00
 |  | 10 | Ian | Sue | 2012-02-16 00:00:00
Spreadsheet: 789218d1659003697-removing-duplicates-and-counting-test-sheet-1-ans
Sheet: Summary

Summary
 | Sales person |  | Sales person | Invoice count |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
10001 | Adam |  |  | 2
10001 | Adam |  | [NAME] | 3
10002 | [NAME] |  | [NAME] | 3
10003 | [NAME] |  | [NAME] | 1
10004 | [NAME] |  | [NAME] | 1
10004 | [NAME]
10005 | [NAME] |  | Indipendent of column A and B
10006 | Adam
10007 | [NAME]
10007 | [NAME]
10007 | [NAME]
10008 | [NAME]
10009 | [NAME]
10010 | [NAME]
Spreadsheet: 737199d1624278020-multi-match-between-two-spreadsheets-multi-match
Sheet: trans

company | batch | Document | Document_Date | Description | Reference | Document_Value_Base | Document_Value_Currency | Year_Period | Text | GL_Cost_Code | GL_Expense_Code | Currency | Company | Result
8005 | CB032301 | CPSB01/00008970 | 2021-05-18 00:00:00 | Mr Monday | REFUND | 84 | -84 | 2021/03 | Company= 304 | 04-075 | 0643- | GBP | 304 | Yes
8005 | CB032301 | CPSB01/00008971 | 2021-05-18 00:00:00 | Mr Tuesday | REFUND | 193 | -193 | 2021/03 | Company=1225 | 04-075 | 0209- | GBP | 1225 | Yes
8005 | CB032301 | CPSB01/00008972 | 2021-05-18 00:00:00 | Miss Wednesday | REFUND | 20 | -20 | 2021/03 | Company= 520 | 04-075 | 0643- | GBP | 520 | No