tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 164504d1340800393-index-match-formula-looking-in-2-columns-and-1-row-calendar-2012-13-sample
Sheet: Temp (11)

 |  |  |  |  |  |  |  | Total: |  | 2012-06-25 00:00:00
< |  |  |  |  |  | > |  |  |  | Week 01
M | [NAME] | W | Th | F | Sa | Su |  |  | Customer | Ref, P/O | Load | From | Mileage | To | Goods | Del | Comments | Cost | Extra | Hours | [x] | Pay | Time |  | Rate | x
2012-05-28 00:00:00 |  |  |  |  |  |  | 01:00:00
 |  |  |  |  |  |  | 02:00:00
 |  |  |  |  |  |  | 03:00:00
 |  |  |  |  |  |  | 04:00:00
 |  |  |  |  |  |  | 05:00:00
Holidays |  |  |  |  |  |  | 06:00:00
 |  |  |  |  |  |  | 07:00:00
Sick |  |  |  |  |  |  | Stock am
 |  |  |  |  |  |  | 08:00:00 |  |  |  |  | V I need to look into adding this column into it as well, but might be able to manage without |  | V This then needs to be looked up in Customer!F:F
 |  |  |  |  |  |  |  |  | [NAME] | <this is the first thing I need to be looked up in the Customer worksheet, column D |  | [NAME] |  | Stoke-on-trent |  |  |  | I need this cell to contain the equation and equal the correct price |  |  |  |  |  |  | Combo |  | Finally, I need this to be found in Customer!1:1
Unavailable |  |  |  |  |  |  | 09:00:00
Available |  |  |  |  |  |  | 10:00:00
Appointments |  |  |  |  |  |  | 11:00:00
 |  |  |  |  |  |  | 12:00:00
Notes; |  |  |  |  |  |  | Stock pm
 |  |  |  |  |  |  | 13:00:00
 |  |  |  |  |  |  | 14:00:00
Deliveries In; |  |  |  |  |  |  | 15:00:00
 |  |  |  |  |  |  | 16:00:00
Stock In/Out
Packaging Out
 |  |  |  |  |  |  | 17:00:00
 |  |  |  |  |  |  | 18:00:00
 |  |  |  |  |  |  | 19:00:00
 |  |  |  |  |  |  | 20:00:00
 |  |  |  |  |  |  | 21:00:00
 |  |  |  |  |  |  | 22:00:00
 |  |  |  |  |  |  | 23:00:00
Cost needs to look in row for 'From' then 'To', then look in column for 'Rate'
Spreadsheet: 733758d1621781120-autofill-sorting-vba-map-reformat-for-pt
Sheet: Sorting

Name | Q1 | Q2 | Q3 | Q4 |  | 1. Autofill (mark and drag down) starting from frow 2 until row 20 (without overwriting row 21) (autofill withou formatting)
 |  |  |  |  |  | 2. Delete all cell values starting from "Total"
 |  |  |  |  |  | 3. Sort only the light blue marked sub-table. In general it shoul select and sort only the sub-table where the first yellow row appears
Total
Spreadsheet: 6e307b3f-c05e-4d33-8d1f-f1d61816b05e
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
35961878 | 2013-05-16 03:06:00 | ALLIES | 1 | 7 | 4 | 154281 | Mr [NAME] | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
35962004 | 2013-05-16 03:22:15 | AXIS | 1 | 7 | 4 | 154281 | Mr [NAME] | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
35995623 | 2013-05-18 14:11:54 | AXIS | 1 | 7 | 2 | 761625 | Gateam | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
35995784 | 2013-05-18 14:33:38 | ALLIES | 0 | 3 | 7 | 761625 | Gateam | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
36002088 | 2013-05-18 22:53:11 | AXIS | 1 | 7 | 3 | 488411 | Hortense60 | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
36003674 | 2013-05-19 00:43:48 | AXIS | 1 | 7 | 2 | 298050 | MrBlonde | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
36003837 | 2013-05-19 01:03:59 | ALLIES | 1 | 7 | 5 | 298050 | MrBlonde | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
36010495 | 2013-05-19 13:56:20 | AXIS | 1 | 7 | 6 | 1135412 | Spirit of Dunkerque | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
36010762 | 2013-05-19 14:28:36 | AXIS | 0 | 6 | 7 | 3120 | gonzalan | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
36011077 | 2013-05-19 14:51:31 | ALLIES | 0 | 4 | 7 | 3120 | gonzalan | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
36020481 | 2013-05-20 01:53:05 | AXIS | 1 | 7 | 1 | 1048463 | LPhelps | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
36066759 | 2013-05-23 03:00:36 | AXIS | 0 | 4 | 7 | 803895 | [NAME] | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
36094583 | 2013-05-25 00:45:25 | AXIS | 1 | 7 | 5 | 188507 | WiredNun | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
36094777 | 2013-05-25 01:03:11 | ALLIES | 0 | 6 | 7 | 188507 | WiredNun | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
Spreadsheet: 874612d1721175880-excel-formula-to-find-multiple-variables-example1
Sheet: Sheet1

Enrolment ID | Company Name | Vehicle Registration | Enrolment Country |  | How many vehicles are registered in both USA and CAN?
1114104 | ABC Inc | B1 | USA
1114127 | ABC Inc | B1 | CAN |  | ABC Inc | 2
1114128 | ABC Inc | AAA 456 | USA |  | [NAME] | 3
1114129 | ABC Inc | B1 | MEX
1114144 | ABC Inc | AAA 456 | CAN
1114171 | ABC Inc | B1 | USA
5643413 | [NAME] | GA6 | USA
5445644 | [NAME] | [NAME] | CAN
5247875 | [NAME] | GA7 | CAN
5050106 | [NAME] | GA6 | CAN
5050107 | [NAME] | GA6 | USA
Spreadsheet: 714423d1611224646-formula-to-check-date-range-timeline_ex-ans
Sheet: Sheet1

 | Component | Phases |  |  |  |  |  |  | 2020 |  |  |  |  |  |  |  |  |  |  |  | 2021
 |  | A |  | B |  | C |  |  | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00
 | X | 2020-05-25 00:00:00 | 2020-06-29 00:00:00 | 2020-06-30 00:00:00 | 2020-08-04 00:00:00 | 2020-08-05 00:00:00 | 2020-09-09 00:00:00
 | Y | 2020-03-04 00:00:00 | 2020-04-08 00:00:00 | 2020-04-09 00:00:00 | 2020-04-28 00:00:00 | 2020-04-29 00:00:00 | 2020-05-18 00:00:00
 | Z | 2020-09-24 00:00:00 | 2020-10-05 00:00:00 | 2020-10-06 00:00:00 | 2020-11-30 00:00:00 | 2020-12-01 00:00:00 | 2021-01-25 00:00:00
 | S | 2020-01-24 00:00:00 | 2020-03-08 00:00:00 | 2020-03-09 00:00:00 | 2020-04-22 00:00:00 | 2020-04-23 00:00:00 | 2020-07-31 00:00:00
 | T | 2020-07-08 00:00:00 | 2020-08-06 00:00:00 | 2020-08-07 00:00:00 | 2020-09-05 00:00:00 | 2020-09-06 00:00:00 | 2020-12-14 00:00:00
Spreadsheet: 78863d1279152298-average-last-14-numbers-from-changing-amount-of-cells-last14
Sheet: Sheet1

 |  | Numbers
 |  | 63
 |  | 32
 |  | 40
 |  | 19
 |  | 67
 |  | 42
 |  | 12
 |  | 24
 |  | 5
 |  | 81
 |  | 67
 |  | 70
 |  | 71
 |  | 17
 |  | 27
 |  | 71
 |  | 62
 |  | 12
 |  | 100
 |  | 66
 |  | 16
 |  | 72
 |  | 45
 |  | 8
 |  | 25
 |  | 59
 |  | 79
 |  | 29
 |  | 69
 |  | 49
 |  | 20
 |  | 7
 |  | 29
 |  | 1
 |  | 79
 |  | 26
 |  | 77
 |  | 64
 |  | 77
 |  | 1
 |  | 42
 |  | 4
 |  | 71
 |  | 53
 |  | 30
 |  | 30
 |  | 89
 |  | 81
 |  | 31
 |  | 12
 |  | 67
 |  | 76
 |  | 35
 |  | 67
 |  | 63
 |  | 65
 |  | 27
 |  | 11
 |  | 51
 |  | 28
 |  | 20
 |  | 14
 |  | 15
 |  | 71
 |  | 97
 |  | 76
 |  | 72
 |  | 86
 |  | 48
 |  | 3
 |  | 29
 | Average last 14 | 44.35714285714285
Spreadsheet: 55175d1255344035-filter-by-only-first-4-numbers-malchemist
Sheet: 31946

Date of Order | Date of Order | Item No. | Description | Quantity | [NAME] value £ | Order Number | Contract
20080225 | 2008-02-25 | 202416 | Laser range meter PD 4 | 1 | 110 | 118949 | 31946
20080919 | 2008-09-19 | 228195 | Battery pack B 36 2.4 NiCd | 2 | 318.6 | 118949 | 31946
20081128 | 2008-11-28 | 272444 | Battery charger C 4/36-ACS Li TPS 230V | 1 | 101.58 | 131384 | 31946
20090121 | 2009-01-21 | 272444 | Battery charger C 4/36-ACS Li TPS 230V | 1 | 76.6299999999999 | 132438 | 31946
20080425 | 2008-04-25 | 272627 | Cordl. ham. dr. driver SFH 181-A 3.0 | 1 | 270.44 | 118949 | 31946
20090121 | 2009-01-21 | 272828 | Cordl. impact screwdriver SID 144-A | 1 | 93.28 | 132438 | 31946
20090121 | 2009-01-21 | 273114 | Battery pack B 144 2.6 Li-Ion | 1 | 52.1499999999999 | 132438 | 31946
20090121 | 2009-01-21 | 273114 | Battery pack B 144 2.6 Li-Ion | 1 | 52.1499999999999 | 132438 | 31946
20080918 | 2008-09-18 | 370101 | Battery pack SFB 185 | 2 | 179.72 | 118949 | 31946
20090427 | 2009-04-27 | 378450 | Battery charger C 7/36-ACS 230V | 1 | 98.59 | 134794 | 31946
Spreadsheet: 277655d1384380340-automaticly-fill-in-wokring-shifts-pbeumer
Sheet: Blad1

 | Mon | Tue | Wed | Thu | Fri |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Aantal Wk2 | Aantal Wk3 | Aantal Wk4 |  | 10/13
Zakelijk | 06:00-15:00 Z | 06:00-15:00 Z | 06:00-15:00 Z | 06:00-15:00 Z | 06:00-15:00 Z |  | Mon |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 47/62
 | 1 | 1 | 1 | 1 | 1 |  | Tue
 | 06:00-15:00 Z | 06:00-15:00 Z | 06:00-15:00 Z | 06:00-15:00 Z | 06:00-15:00 Z |  | Wed
 | 3 | 2 | 2 | 2 | 2 |  | Thu
 | 06:00-15:00 Z | 06:00-15:00 Z | 06:00-15:00 Z | 06:00-15:00 Z | 06:00-15:00 Z |  | Fri
 | 4 | 3 | 3 | 3 | 3
 | 06:00-15:00 Z | 06:00-15:00 Z | 06:00-15:00 Z | 06:00-15:00 Z | 06:00-15:00 Z
 | 5 | 5 | 4 | 4 | 4
 | 06:00-15:00 Z | 06:00-15:00 Z | 06:00-15:00 Z | 06:00-15:00 Z | 06:00-15:00 Z
 | 6 | 6 | 5 | 5 | 5
 | 06:00-15:00 Z | 06:00-15:00 Z | 06:00-15:00 Z | 06:00-15:00 Z | 06:00-15:00 Z
 | 7 | 7 | 7 | 7 | 7
 | 12:00-21:00 Z | 12:00-21:00 Z | 12:00-21:00 Z | 12:00-21:00 Z | 12:00-21:00 Z
 | 8 | 8 | 6 | 8 | 8
 | 16:00-24:00 Z | 16:00-24:00 Z | 16:00-24:00 Z | 16:00-24:00 Z | 16:00-24:00 Z
 | 9 | 9 | 9 | 9 | 9
 | 16:00-24:00 Z | 16:00-24:00 Z | 16:00-24:00 Z | 16:00-24:00 Z | 16:00-24:00 Z
 | 10 | 10 | 10 | 11 | 11
 | 16:00-24:00 Z | 16:00-24:00 Z | 16:00-24:00 Z | 16:00-24:00 Z | 16:00-24:00 Z
 | 11 | 11 | 11 | 12 | 12
 | 16:00-24:00 Z | 16:00-24:00 Z | 16:00-24:00 Z | 16:00-24:00 Z | 16:00-24:00 Z
 | 13 | 12 | 12 | 13 | 13
 | 06:00-15:00 Z | 06:00-15:00 Z | 06:00-15:00 Z | 06:00-15:00 Z | 06:00-15:00 Z | 12:00-21:00 Z | 06:00-15:00 Z | 12:00-21:00 Z | 16:00-24:00 Z | 16:00-24:00 Z | 16:00-24:00 Z | 16:00-24:00 Z | 16:00-24:00 Z
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13
Spreadsheet: 112597d1308677975-summing-rows-based-on-account-number-excel-help
Sheet: Sheet1

BEFORE
Account Information | Department | Account Code | Account Number | Debit | Credit
EE TAXES | 12345 | 60 | 62350000.43281 |  | 60
EE TAXES | 12344 | CPOR | 62350000.43281 |  | 90
EE TAXES | 12346 | REGE | 62350000.28531 | 550
EE TAXES | 12348 | REGE | 62350000.28531 |  | 450
EE TAXES | 12345 | REGE | 62350000.28531 | 525
EE TAXES | 12345 | REGE | 62350000.28531 |  | 650
EE TAXES | 12344 | REGE | 62350000.28531 | 275
EE TAXES | 12346 | REGE | 62350000.28531 |  | 250
EE TAXES | 12348 | OJ | 62350000.28535 | 35
EE TAXES | 12345 | ML | 62350000.28535 |  | 25
EE TAXES | 12345 | CT | 62350000.28535 | 45
EE TAXES | 12344 | MO | 62350000.28535 |  | 50
EE TAXES | 12346 | CN | 62350000.28535 | 34
EE TAXES | 12348 | TW | 62350000.28535 |  | 39
AFTER
Account Number | Debit | Credit
62350000.43281 |  | 60
62350000.43281 |  | 90
62350000.28531 | 1350
62350000.28531 |  | 1350
62350000.28535 | 114
62350000.28535 |  | 114
Spreadsheet: 095f2da2-25c3-46d1-82b4-9bccbcfe99a4
Sheet: Sheet1

Wake Forest University Baptist Medical Center | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Community Training Center
Affiliation Renewal Form
Name
Title |  |  |  | Level of Licensure: (Ex RN, EMT-P, etc)
SS#
Home Mailing Address:
 |  | Street
 |  | City |  |  | State | County |  | [NAME]
 |  | Phone |  |  | Pager/Other
 |  | E-mail
Work Mailing Address:
 |  | Employer name
 |  | Street
 |  | City |  |  | State | County |  | [NAME]
 |  | Phone |  |  | Fax
 |  | E-mail
Please check all that apply regarding your current Instructor Status - Include a copy of all cards that apply
BCLS/PBLS |  |  | ACLS |  |  | PALS
Regional Faculty: _____________ |  |  | Regional Faculty: ____________ |  |  | Regional Faculty: ____________
 | (expires) |  |  | (expires) |  |  | (expires)
Instructor/Trainer: _____________ |  |  | Instructor: __________________ |  |  | Instructor: __________________
 | (expires) |  |  | (expires) |  |  | (expires)
Instructor: ___________________
 | (expires)
Spreadsheet: 17472e09-8832-4dad-a720-6c7ef92c1d1e
Sheet: # Monographs purchased

[NAME] vs. [NAME]
Monographic Volumes Purchased
 | FY 2007 | FY 2008 | FY 2009 | FY 2010 | FY 2011 | % Change
Peer Average
Peer Median
University of Rhode Island | 6417 | 6111 | 7124 | 7634 | 7832
[NAME] University | 17729 | 18987 | 14303 | 13283 | 14663
Montana State University - Bozeman | 8392 | 5776 | 136576 | U/A | 4295
North Dakota State University - Main Campus | U/A | U/A | 2513 | U/A | U/A | U/A
University of Maine | 11419 | 10958 | 11671 | 10447 | 8463
University of New Hampshire - Main Campus | 12899 | 10224 | 9805 | 9029 | 12571
University of Vermont and State Ag. Coll. | U/A | U/A | 2666748 | 323586 | 22161 | U/A
University of Wyoming | 17792 | 25893 | 35120 | 24008 | U/A | U/A
Source: ACRLMetrics
Revised: May 30, 2012, ajr
Spreadsheet: 767086d1644284453-move-data-up-if-blank-or-move-to-next-row-and-retrieve-requested-data-filter-and-table-eba
Sheet: Bez (2)

Name | Gender | [NAME]
 |  |  |  |  | Bez Bloodline
Spreadsheet: 46242d1245152249-find-the-cheepest-provider-in-a-table-book6
Sheet: Cheepest Provider

 | Prov.1 | Prov.3 | Prov.3 |  | Country
Italy | 1 | 12 | 9 |  | England
France | 18 | 45 | 4
Belgium | 4 | 8 | 5 |  | country row | column of | Provider
England | 12 | 6 | 13 |  | Row | MIN | INDEX
Romania | 8 | 36 | 3 |  | 5 | 2 | Prov.3
 |  |  |  |  |  | B5:D5
 |  |  |  |  |  | {12,6,13}
 | Prov.1 | Prov.3 | Prov.3 |  | Country
Italy | 1 | 12 | 9 |  | England
France | 18 | 45 | 4
Belgium | 4 | 8 | 5 |  | Provider
England | 12 | 6 | 13 |  | INDEX
Romania | 8 | 36 | 3 |  |  | ????
 | DATA
Spreadsheet: 842738d1694727800-sumproduct-with-returned-arrays-from-most-recent-date-and-different-timepoints-in-the-past-trailing-performance
Sheet: Sheet1

Date
Account | US TFSA | <<<Switch between accounts
Account | Company | Account | Qty
US TFSA | AMD | US TFSA | 10 |  | AMD
US TFSA | NVDA | US TFSA | 63 |  | NVDA
US TFSA | QCOM | US TFSA | 15 |  | QCOM
US TFSA | AAPL | US TFSA | 45 |  | AAPL
US TFSA | MSFT | US TFSA | 60 |  | MSFT
US TFSA | MA | US TFSA | 10 |  | MA
US TFSA | V | US TFSA | 10 |  | V
US TFSA | MCO | US TFSA | 13 |  | MCO
US TFSA | BAC | US TFSA | 8 |  | BAC
US TFSA | JPM | US TFSA | 14 |  | JPM
US TFSA | WKHS | US TFSA | 5 |  | WKHS
US TFSA | SPY | US TFSA | 375 |  | SPY
US TFSA | VOO | US TFSA | 375 |  | VOO
US Cash | AMD | US Cash | 62 |  | AMD
US RSP | UMC | US RSP | 20 |  | UMC
Trailing Performance | Beginning Value | Ending Value | % Gain/Loss | Months back
Trailing 3 Months |  |  |  | 4
Trailing 6 Months |  |  |  | 7
Trailing 12 Months |  |  |  | 13
Trailing 3 Years |  |  |  | 37
Trailing 5 Years |  |  |  | 81
Spreadsheet: 791105d1660153745-days-in-market-days-in-market-2
Sheet: Change to data structure

 | Comment | Ticket Number | [NAME] | [NAME] | Departure Date | [NAME] | EU Arrival date | EU Departure date | Days within 180 window | Dates in EU
1 | Outbound to France | 123345679 | LHR | CDG | 2022-08-10 00:00:00 | 2022-08-10 00:00:00 | 2022-08-10 00:00:00 | 2022-08-10 00:00:00
1 | Inbound from France | 123345679 | CDG | LHR | 2022-08-10 00:00:00 | 2022-08-10 00:00:00 | 2022-08-10 00:00:00 | 2022-08-10 00:00:00
2 | Outbound to France | 98765431 | LHR | CDG | 2022-12-20 00:00:00 | 2022-12-20 00:00:00 | 2022-12-20 00:00:00 | 2023-02-01 00:00:00
2 | Inbound from France | 98765431 | CDG | LHR | 2023-01-02 00:00:00 | 2023-01-02 00:00:00 | 2022-12-20 00:00:00 | 2023-02-01 00:00:00
3 | Outbound to France | 1233456179 | LHR | CDG | 2023-02-01 00:00:00 | 2023-02-01 00:00:00 | 2023-02-01 00:00:00 | 2023-02-01 00:00:00
3 | Inbound from France | 1233456179 | CDG | LHR | 2023-02-01 00:00:00 | 2023-02-01 00:00:00 | 2023-02-01 00:00:00 | 2023-02-01 00:00:00
4 | Outbound to France | 1254879865 | LHR | CDG | 2023-02-04 00:00:00 | 2023-02-04 00:00:00 | 2023-02-04 00:00:00 | 2023-02-06 00:00:00
4 | Inbound from France | 1254879865 | CDG | LHR | 2023-02-06 00:00:00 | 2023-02-06 00:00:00 | 2023-02-04 00:00:00 | 2023-02-06 00:00:00
5 | Outbound to Spain | 15948267398 | LHR | MAD | 2023-02-06 00:00:00 | 2023-02-06 00:00:00 | 2023-02-04 00:00:00 | 2023-02-14 00:00:00
5 | Outbound from Spain | 15948267398 | MAD | WAW | 2023-02-08 00:00:00 | 2023-02-08 00:00:00 | 2023-02-04 00:00:00 | 2023-02-14 00:00:00
5 | Outbound from Poland | 15948267398 | WAW | CDG | 2023-02-10 00:00:00 | 2023-02-10 00:00:00 | 2023-02-04 00:00:00 | 2023-02-14 00:00:00
5 | Outbound from France | 15948267398 | Paris gare du Nord | [NAME] | 2023-02-13 00:00:00 | 2023-02-14 00:00:00 | 2023-02-04 00:00:00 | 2023-02-14 00:00:00
6 | Outbound to France | 15948267398 | LHR | CDG | 2023-03-01 00:00:00 | 2023-03-01 00:00:00 | 2023-03-01 00:00:00 | 2023-03-11 00:00:00
6 | Outbound from France | 15948267398 | Paris gare du Nord | [NAME] | 2023-03-03 00:00:00 | 2023-03-03 00:00:00 | 2023-03-01 00:00:00 | 2023-03-11 00:00:00
6A | Outbound from Netherlands | A6598745 | AMS | GVA | 2023-03-09 00:00:00 | 2023-03-09 00:00:00 | 2023-03-01 00:00:00 | 2023-03-11 00:00:00
6A | Outbound from Switzerland |  | GVA | AMS | 2023-03-11 00:00:00 | 2023-03-11 00:00:00
6 | Outbound from Netherlands | 15948267398 | [NAME] | Brussels Central | 2023-03-12 00:00:00 | 2023-03-12 00:00:00 | 2023-03-12 00:00:00 | 2023-03-14 00:00:00
6 | Outbound from France | 15948267398 | Brussels Central | [NAME] | 2023-03-13 00:00:00 | 2022-03-14 00:00:00 | 2023-03-12 00:00:00 | 2023-03-14 00:00:00
Spreadsheet: 05f4773a-a1b5-47eb-a9e7-9596fc4daab1
Sheet: Fig 9 data

year | abslcpreallogdev10 | fbalt0errorcomb | abslcpreallogdev10
1977 |  | -7.234262 | 0.3492236
1978 |  | -1.89263 | 0.4147236
1979 |  | -4.710392 | 0.4094496
1980 |  | -6.563248 | 0.1001986
1981 |  | -2.474469 | 0.0813662
1982 |  | -1.422639 | 0.3709442
1983 |  | 0.0787787 | 0.5655609
1984 |  | -0.5751269 | 0.4864074
1985 |  | -0.770126 | 0.577227
1986 |  | -2.051005 | 0.4551056
1987 |  | -2.28352 | 0.4591908
1988 |  | -2.713611 | 0.1699178
1989 |  | -5.343116 | 0.2014834
1990 |  | 0.6963379 | 0.2393608
1991 |  | -0.2420529 | 0.1428492
1992 |  | -0.7422547 | 0.007502
1993 |  | -1.110361 | 0.0337493
1994 |  | -0.1944679 | 0.2449258
1995 |  | -1.130906 | 0.0687847
1996 |  | -0.4418205 | 0.1302171
1997 |  | 0.4317812 | 0.1796439
1998 |  | -0.1053034 | 0.2227801
1999 |  | 0.6513158 | 0.5487713
2000 |  | -0.0693719 | 0.5509581
2001 |  | 0.6623793 | 0.3548304
2002 |  | 1.327657 | 0.4533184
2003 |  | 0.0737995 | 0.4211939
2004 |  | -1.802472 | 0.2529696
2005 |  | -3.027666 | 0.2255794
2006 |  | -4.617418 | 0.4454062
2007 |  | -8.341913 | 1.021922
2008 |  | 0.2286541 | 0.9064305
2009 |  | 8.096022 | 0.7090269
Spreadsheet: 835118d1688316528-calculating-day-allowance-for-sick-leave-testsick-1
Sheet: Jun-23-SI

NO | RTW | Absence From | Absence To | Duration | Pattern | Wait | CUM | Daily Rate | OSP | OFFSET DAYS | SSP | Expected result | 109.4
3 | Sickness | 2023-05-22 00:00:00 | 2023-05-25 00:00:00 | 4 | 5 | 0 | 6 | 92 |  |  |  | 0
8 | Sickness | 2023-05-16 00:00:00 | 2023-05-22 00:00:00 | 5 | 5 | 0 | 2 | 96.87 |  |  |  | 0
9 | Sickness | 2023-06-12 00:00:00 | 2023-06-16 00:00:00 | 5 | 5 | 0 | 2.4375 | 113.77 |  |  |  | 0
13 | Sickness | 2023-05-23 00:00:00 | 2023-05-26 00:00:00 | 4 | 5 | 0 | 6 | 113.78 |  |  |  | 0
22 | Sickness | 2023-06-11 00:00:00 | 2023-06-18 00:00:00 | 5 | 5 | 0 | 5 | 106.59 |  |  |  | 0
23 | Sickness | 2023-05-28 00:00:00 | 2023-06-20 00:00:00 | 14 | 4 | 0 | 5 | 128.63 |  |  |  | 246.15
27 | Sickness | 2023-06-13 00:00:00 | 2023-06-26 00:00:00 | 10 | 5 | 0 | 5 | 90.29 |  |  |  | 109.4
60 | Sickness | 2023-05-22 00:00:00 | 2023-05-26 00:00:00 | 5 | 5 | 0 | 7 | 101.94 |  |  |  | 43.76000000000001
36 | Sickness | 2023-06-12 00:00:00 | 2023-06-22 00:00:00 | 9 | 5 | 0 | 4 | 104.5 |  |  |  | 65.64000000000001
29 | Sickness | 2023-06-05 00:00:00 | 2023-06-09 00:00:00 | 5 | 5 | 0 | 2 | 101.94 |  |  |  | 0
117 | Sickness | 2023-06-01 00:00:00 | 2023-06-14 00:00:00 | 10 | 5 | 0 | 0.5 | 151.85 |  |  |  | 10.94
32 | Sickness | 2023-05-17 00:00:00 | 2023-06-01 00:00:00 | 8 | 4 | 0 | 6 | 145.22 |  |  |  | 109.4
37 | Sickness | 2023-06-02 00:00:00 | 2023-06-09 00:00:00 | 4 | 4 | 0 | 5 | 145.22 |  |  |  | 0
38 | Sickness | 2023-06-12 00:00:00 | 2023-06-15 00:00:00 | 4 | 5 | 0 | 0 | 84 |  |  |  | 0
47 | Sickness | 2023-05-24 00:00:00 | 2023-06-14 00:00:00 | 10 | 5 | 3 | 7 | 151.85 |  |  |  | 153.16
49 | Sickness | 2023-05-24 00:00:00 | 2023-06-05 00:00:00 | 8 | 5 | 0 | 1 | 108.52 |  |  |  | 0
50 | Sickness | 2023-05-21 00:00:00 | 2023-05-28 00:00:00 | 4 | 4 | 0 | 0 | 151.85 |  |  |  | 0
61 | Sickness | 2023-05-30 07:30:00 | 2023-06-02 00:00:00 | 3.75 | 5 | 0 | 0 | 89.2 |  |  |  | 0
65 | Sickness | 2023-05-22 09:00:00 | 2023-05-26 00:00:00 | 4.8125 | 5 | 0 | 0.375 | 84 |  |  |  | 0
66 | Sickness | 2023-06-06 00:00:00 | 2023-06-15 00:00:00 | 8 | 5 | 0 | 0 | 84 |  |  |  | 0
74 | Sickness | 2023-05-22 00:00:00 | 2023-06-04 00:00:00 | 5.4545 | 4 | 0 | 1.5454 | 166.05 |  |  |  | 0
75 | Sickness | 2023-05-31 00:00:00 | 2023-06-04 00:00:00 | 3.9075 | 5 | 0 | 0 | 151.85 |  |  |  | 0
76 | Sickness | 2023-06-05 00:00:00 | 2023-06-09 00:00:00 | 4 | 4 | 0 | 3 | 131.7 |  |  |  | 0
78 |  | 2023-05-16 00:00:00 | 2023-05-24 00:00:00 | 4 | 4 | 0 | 15 | 145.22 |  |  |  | 27.35
93 | Sickness | 2023-05-26 00:00:00 | 2023-06-11 00:00:00 | 10 | 5 | 0 | 0 | 90.29 |  |  |  | 0
107 | Sickness | 2023-06-14 00:00:00 | 2023-06-21 00:00:00 | 4 | 4 | 0 | 1 | 145.22 |  |  |  | 0
110 | Sickness | 2023-06-02 00:00:00 | 2023-06-09 00:00:00 | 4 | 4 | 0 | 1 | 124.78 |  |  |  | 0
113 | Sickness | 2023-06-08 00:00:00 | 2023-06-14 00:00:00 | 4 | 4 | 0 | 3 | 151.85 |  |  |  | 0
114 | Sickness | 2023-05-27 00:00:00 | 2023-06-04 00:00:00 | 4 | 4 | 0 | 0 | 151.85 |  |  |  | 0
 |  |  |  |  | #REF! | 6 | 767.3215999999996 | 15017.04000000002
Spreadsheet: 138077d1327507746-need-help-on-how-to-lookup-values-that-duplicate-book3
Sheet: Sheet1

 |  |  | HERE IS THE DATA
 |  |  |  | [NAME] | [NAME] | Zack | [NAME] | [NAME] | [NAME]
 |  |  | Score1 | 43.63 | 46.12 | 22 | 36.54 | 44.39 | 51.49
 |  |  | Score2 | 27 | 45.92 | 22 | 45.92 | 39.53 | 41.43
 |  |  | Score3 | 30.79 | 54.86 | 22 | 50.22 | 49.78 | 43.6
 |  |  | Score4 | 50.24 | 55.26 | 22 | 48.03 | 53.15 | 37.51
 |  |  |  |  |  |  |  |  |  |  |  | How do I get [NAME]'s name reported? Also, If I insert columns (e.g. I insert a column after Column G) and add more user data, will this still work properly?
Spreadsheet: 115687d1311223623-how-to-use-sumproduct-with-filtered-list-sumproduct
Sheet: Sheet1

 | NAME | TYPE
 | ANDI | Yes
 | DDD | No
 | ABC | No
 | ANDI | Yes
 | DDD | Yes
 | ABC | Yes
 | ANDI | No
 | DDD | Yes
 | ABC | No
 | ANDI | Yes
 | DDD | No
Spreadsheet: 174a123a-b730-4784-8753-600da4111155
Sheet: Michel Consejo

[NAME]
Fair Share Fee: Those Who Don't Pay Their Fair Share
Disagree
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
I'd like to explain my position
Explain your relicensing position, if you choose
Would like to know more about the existing one
Name | email address | Address | Office sought | Are you an incumbent? |  | County
[NAME] | [EMAIL] | P.O. Box 422 [NAME], VT  05485 | State representative | Yes |  | Franklin
Spreadsheet: 697999d1601661730-using-median-with-multiple-conditions-test-sheet
Sheet: Summary Page

12m Total Return (%) 30/09/19 - 30/09/20 | Median
 | Port
Low/Med Income
Low/Med Balanced
Low/Med Growth
Med Income
Med Balanced
Med Growth
Med/High Income
Med/High Balanced
Med/High Growth
High