tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 787128d1657639014-i-am-looking-for-a-formulae-to-use-that-can-return-maximum-score-in-each-race-bobiez
Sheet: Sheet6

race | SCORE 2 | [NAME]/race
Sligo | 6.4136815417525
Sligo | 8.87297061493923
Sligo | 10.02739150940454
Sligo | 4.958479790790738
Sligo | 6.282373888067842
Sligo | 4.959069064039466
Sligo | 11.33608825820421
Sligo | 8.7435062775724
Sligo | 7.267160827094935
Sligo | 5.789187145331516
Sligo | 11.10483432293065
Sligo
Sligo | 7.452438563275734
Sligo | 6.87572809759081
Sligo | 5.721026788160458
Perth | 12.98542871798773
Perth | 6.066813291337838
Perth | 8.9057606484591
Perth
Perth | 7.35581030582108
Perth | 7.411091090566611
Fairyhouse
Fairyhouse
Fairyhouse | 7.316058554523817
Fairyhouse | 6.81700095736526
Fairyhouse | 8.859185784404017
Fairyhouse
Fairyhouse
[NAME] | 7.073077981003618
[NAME] | 12.047722808647
[NAME] | 7.24079491107891
[NAME] | 6.374906806842228
[NAME] | 7.742908159003413
[NAME] | 6.795122181622202
[NAME] | 8.126176930279252
[NAME] | 8.052872908199362
[NAME] | 8.465679148581255
[NAME] | 2.708841147580827
[NAME] | 4.61220667794808
Sligo | 6.483189530668253
Sligo | 6.148205398454829
Sligo | 3.41012389211263
Sligo | 4.426500700773573
Sligo | 5.565118147974466
Sligo | 5.792176442178782
Sligo | 5.711581253754126
Sligo | 5.431316951409455
Sligo | 6.583992344530496
Sligo | 5.934622253546034
Sligo | 6.985090410676471
Sligo | 7.854599228219614
Sligo | 4.061234789020074
Sligo | 5.924991269190303
Sligo | 8.336450379858972
Spreadsheet: 269019d1380915235-project-task-tracking-payroll-formula-help-etco-calculated-timecard-testformulas
Sheet: Summary

ETCO Calculated Timesheet for pay date range:
Project:
 |  | Payout | Hours
Mobilization
Site Utilities
Underground - Secondary Service
Underground - BC/Feeders
Exterior Bldg Rough-In Wiring
Interior Bldg Rough-In Wiring
Branch Circuit Wiring/Terminations
Branch Circuit Trim/Devices
Feeders
[NAME]
Service Panels and Equipment
Light Fixtures and Installation
Light Fixtures Terminations/Controls
O.F.E. Equipment Install/Term/Test
Device Installation/Lighting Controls
[NAME] Track
Testing
Project Finalization; As-Builts
Holiday
Administration
Other
TOTAL Payout this Period:
TOTAL Hours this Period:
Spreadsheet: 836853d1689684781-help-in-pivot-table-filtering-pivot_filter
Sheet: Sheet1

Type | Doc. | Set 1 | Set 2
EF | ZNB | 9101 | 1001
EF | ZNB | 9101 | 1001
EF | ZNB | 9101 | 1001
EF | ZNB | 1000 | 1010
EF | ZNB | 1000 | 1010
EF | ZNB | 1001 | 1010
EF | ZNB | 1001 | 1010
EF | ZNB | 1001 | 1010
EF | ZNB | 1002 | 1010
EF | NB | 9201 | 2001
EF | NB | 9201 | 2001
EF | NB | 9201 | 2001
EF | NB | 9201 | 2001
EF | NB | 9201 | 2001
EF | NB | 9201 | 2001
EV | UB | 1000 | 1010
EV | UB | 1001 | 1010
EV | UB | 1001 | 1010
Spreadsheet: 857122d1706184244-how-to-look-up-a-result-if-two-criteria-are-met-example1a
Sheet: System data

Date | Receipt number | Order number | Item | Qty receipted | Batch number
2023-01-02 00:00:00 | 11875 | 102658 | CHAIR-IE-VINYL-S | 35 | 1035
2023-01-02 00:00:00 | 11875 | 102658 | CHAIR-IE-VINYL-M | 65 | 1035
2023-01-02 00:00:00 | 11875 | 102658 | CHAIR-IE-VINYL-L | 6 | 1035
2023-02-15 00:00:00 | 12635 | 105398 | CHAIR-UK-G-S | 106 | 1293
2023-03-25 00:00:00 | 13985 | 125694 | CHAIR-UK-B-L | 106 | 1299
2023-04-15 00:00:00 | 14758 | 135984 | CHAIR-US-B-M | 106 | 1350
2023-05-30 00:00:00 | 15369 | 158635 | CHAIR-IE-VINYL-S | 40 | 1398
2023-05-30 00:00:00 | 15369 | 158635 | CHAIR-IE-VINYL-M | 50 | 1398
2023-05-30 00:00:00 | 15369 | 158635 | CHAIR-IE-VINYL-L | 16 | 1398
2023-06-08 00:00:00 | 16402 | 178945 | CHAIR-US-B-M | 50 | 1436
2023-06-08 00:00:00 | 16402 | 178945 | CHAIR-US-B-L | 56 | 1436
2023-07-17 00:00:00 | 17323 | 198675 | CHAIR-UK-G-S | 106 | 1698
Spreadsheet: 291899d1390428760-need-help-sorting-multiple-columns-teams
Sheet: Sheet1

Team | Wins | Losses | Points
Spreadsheet: diana_scholtes__8583__July 2001 tranny
Sheet: Sheet1

 | Data
Act Date | Sum of Gross MW | Average of Price | Sum of Total Amt
2001-07-03 00:00:00 | -225 | 0 | -639
2001-07-05 00:00:00 | -225 | 0 | -639
2001-07-06 00:00:00 | -320 | 0 | -908.8
2001-07-07 00:00:00 | -320 | 0 | -908.8
2001-07-09 00:00:00 | -310 | 0 | -880.4
2001-07-26 00:00:00 | -320 | 0 | -864
2001-07-31 00:00:00 | -320 | 0 | -908.8
Grand Total | -2040 | 0 | -5748.8
Schedule 1    Scheduling, System Control, and Dispatch Services -  $0.047 per MWh
2040 MW x 0.047 = $95.88
Schedule 2    Reactive Supply and Voltage Control - $0.066 per MWh
2040 MW x 0.066 = $134.64
Schedule 9    Loss Compensation Service - $3.00 per MWh
2040 MW x $3.00 = $6120.00
New Mexico Gross Receipts Tax - 5.75% of gross charges for the month
($5748 energy charge + $6350.52 ancillary charge total) x 5.75% = $ 695.66
Total Annuity #  735993.1
Spreadsheet: 146127d1331911532-calculating-number-of-days-in-leap-year-nav-calculator
Sheet: Sheet1

Policy Number | Effective Date | Dollar Amount | Calculated Value | Principal | Interest Rate | Interest Earned | Year | Combined | Days | Int Rate
INITIAL | 2011-01-01 00:00:00 | 18092.84 | 18092.84 | 18092.84
 | 2012-01-01 00:00:00 | 10000 | 29178.41 | 18092.84 | 6 | 11085.57 | 365 | 0 | 365 | 0.06
 | 2013-01-01 00:00:00 | 15000 | 45934.05 | 18092.84 | 6 | 27841.21 | 366 | 0 | 366 | 0.06
Spreadsheet: 715190d1611595788-average-for-current-month-new-report-2
Sheet: AFC Beaumont

 | 2019 | ES | OM | NV | OF | TM | PTC | % increase | Average
2020-01-01 00:00:00 | 2059 | 52 | 445 | 53 | 1897 | 0
2020-02-01 00:00:00 | 1950 | 79 | 374 | 42 | 1900 | 0
2020-03-01 00:00:00 | 2239 | 63 | 269 | 57 | 1529 | 0
2020-04-01 00:00:00 | 1980 | 27 | 184 | 34 | 806 | 7
2020-05-01 00:00:00 | 2385 | 18 | 243 | 136 | 1184 | 4
2020-06-01 00:00:00 | 1781 | 30 | 341 | 66 | 2566 | 220
2020-07-01 00:00:00 | 1759 | 40 | 267 | 66 | 2568 | 147
2020-08-01 00:00:00 | 2479 | 37 | 345 | 80 | 1823 | 0
2020-09-01 00:00:00 | 2090 | 27 | 431 | 165 | 1783 | 558
2020-10-01 00:00:00 | 2548 | 23 | 441 | 321 | 1888 | 679
2020-11-01 00:00:00 | 2303
2020-12-01 00:00:00 | 2437
 | 26010
Spreadsheet: 76356d1276862600-count-words-referenced-to-a-number-testformula
Sheet: Travel Summary

DCSF No. | School | Bus | Car | Taxi | Walk | Total
Primary
2001 | [NAME] First | 0 | 0 | 1 | 1
2011 | Colehill First | 1 | 0 | 0 | 0
2017 | [NAME] | 1 | 0 | 0 | 0
2020 | Ferndown First | 2 | 1 | 0 | 0
2022 | Hazelbury Bryan Primary | 0 | 0 | 0 | 0
2024 | Lytchett Matravers Primary | 0 | 0 | 0 | 0
Spreadsheet: 53461d1253338036-time-computations-flight-log
Sheet: Sheet1

Leg | DATE | B/P/C | PF | FROM | TO | T.O. |  | LDG |  | TOTAL | NIGHT | D/N | P/N | HOLD | OUT | IN | TOTAL | T.O. | LDG
1 | 2009-08-22 00:00:00 | C | SV |  |  | 22:30:00 | z |  | z | 03:30:00 |  |  |  |  | 30000 | 25600
2 | 2009-08-23 00:00:00 |  |  |  |  | 10:00:00 | z |  | z | 06:23:00 |  |  |  |  |  | 21000
3 |  |  |  |  |  | 11:00:00 | z |  | z | 04:40:00 |  |  |  |  |  | 15760
4 |  |  |  |  |  | 12:10:00 | z |  | z | 06:45:00 |  |  |  |  |  | 12300
5 | 2009-09-15 18:38:33.840000 |  |  |  |  | 13:00:00 | z |  | z | 00:45:00 |  |  |  |  | 15000 | 11350
6 | 2009-09-15 18:38:56.650000 |  |  |  |  | 12:00:00 | z |  | z | 00:35:00 |  |  |  |  |  | 8700
7 | 2009-09-16 00:50:52.090000 |  |  |  |  | 13:00:00 | z |  | z | 03:28:00 |  |  |  |  |  | 6000
8 | 2009-09-16 00:54:09.010000 |  |  |  |  | 22:30:00 | z |  | z | 04:45:00 |  |  |  |  |  | 4000
DST | 07:00:00
Spreadsheet: 719411d1613658261-index-and-match-function-with-several-columns-roster-vs-schedule-example
Sheet: Classes

Day | Monday | Monday | Monday | Monday | Tuesday | Tuesday | Tuesday | Tuesday | Wednesday | Wednesday | Wednesday | Wednesday | Wednesday | Thursday | Thursday | Thursday | Thursday | Friday | Friday
System | System 1 | System A | System 2 | System 3 | System 4 | System B | System 5 | System 6 | System 7 | System 8 | System C | System D | System 9 | System E | System F | System 10 | System G | System H | System 11
 | OVERFLOW
 | Monday | Tuesday | Wednesday | Thursday | Friday
 |  |  |  |  |  |  | In the formulas to the left, I want to omit any students that have a site listed with the word "existing" from the Names tab site column. The two listed as of now would be student 1 and student 5.
Spreadsheet: 65262d1265953059-sum-hlookup-testsummonths
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | January
 |  |  |  |  | Total |  |  |  |  |  |  |  |  |  |  | February
Select Months |  | July | October |  | 10 |  |  |  |  |  |  |  |  |  |  | March
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | April
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | May
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | June
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | July
 | July | August | September | October | November | December | January | February | March | April | May | June |  |  |  | August
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |  |  |  | September
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | October
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | November
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | December
Spreadsheet: 834060d1687424024-formula-to-summary-price-qty-on-selected-rows-sample-case2
Sheet: Sheet1

 |  |  |  | SUBTOTAL QTY
 |  |  |  | SUBTOTAL AMNT
 |  |  |  | EXPECTED SUBTOTAL AMNT
 |  | CATEGORY | Price/Unit | MODEL | JUL | AUG | SEP
 |  | 32" | 2 | [NAME] | 100 | 75 | 50
 |  | 32" | 2.1 | [NAME] | 50 | 50 | 25
 |  | 32" | 1.9 | AQT32K701A | 100 | 140 | 200
 |  | 32" | 2 | [NAME] | 50 | 50 | 0
 |  | 43" | 2.8 | [NAME] | 80 | 80 | 150
 |  | 43" | 2.7 | LE43AQT8500MF | 0 | 0 | 0
 |  | 43" | 2.8 | LE43AQT6700FG | 100 | 100 | 0
 |  | 43" | 2.7 | AQT43K701AF | 40 | 40 | 180
 |  | 43" | 2.7 | LE43AQT6700UG | 50 | 50 | 0
 |  | 43" | 2.7 | AQT43P750UX | 40 | 40 | 120
 |  | 50" | 3.5 | LE50AQT7000QUPRO | 50 | 50 | 50
Spreadsheet: 456119d1460651032-how-to-use-vslookup-for-3-products-book2-1-
Sheet: Sheet1

ice cream | [NAME] | Bammer |  |  |  |  | ice cream | [NAME] | [NAME] | bammer
w0942 |  |  |  |  |  |  | w0942 | 84 | 80 | 70
w1242 |  |  |  |  |  |  | w1242 | 92 | 86 | 80
w1542 |  |  |  |  |  |  | w1542 | 102 | 94 | 90
w1842 |  |  |  |  |  |  | w1842 | 108 | 102 | 98
w2142 |  |  |  |  |  |  | w2142 | 116 | 110 | 80
w2442 |  |  |  |  |  |  | w2442 | 142 | 134 | 120
w2742 |  |  |  |  |  |  | w2742 | 150 | 142 | 130
w3042 |  |  |  |  |  |  | w3042 | 160 | 150 | 140
w3342 |  |  |  |  |  |  | w3342 | 168 | 156 | 140
w3642 |  |  |  |  |  |  | w3642 | 176 | 164 | 150
w3024 |  |  |  |  |  |  | w3024 | 110 | 104 | 99
w3324 |  |  |  |  |  |  | w3324 | 116 | 110 | 98
w3624 |  |  |  |  |  |  | w3624 | 120 | 112 | 110
wdc2442 |  |  |  |  |  |  | wdc2442 | 168 | 152 | 140
wea1242 |  |  |  |  |  |  | wea1242 | 88 | 82 | 80
Spreadsheet: 00f3a408-1e09-4161-a974-22a6c61c6782
Sheet: +50 WS 

BWF World Senior Championships 2013
WS 50
Badminton Tournament Planner - bwf.tournamentsoftware.com
 | Member ID | St. | Cnty | Flag | Round 1 | Round 2 | Quarterfinals | Semifinals | Final | Winner
1 | 3710 |  | NED |  | [NAME] [1]
2 | 83847 |  | RUS |  | Liudmila Postnova
3 | 74919 |  | RSA |  | [NAME]
4 | 74894 |  | FRA |  | [NAME]
5 | 65853 |  | IND |  | [NAME] [5/8]
6 | 50617 |  | TUR |  | [NAME]
7 | 2325 |  | IRL |  | [NAME]
8 | 83789 |  | JPN |  | [NAME]
9 | 79613 |  | ENG |  | [NAME] [3/4]
10 | 73841 |  | CAN |  | [NAME]
11 | 78420 |  | JPN |  | [NAME]
12 | 87186 |  | GER |  | [NAME]
13 | 93920 |  | TPE |  | [NAME] [5/8]
14 | 73311 |  | AUT |  | Waltraud Kronsteiner
15 | 8312 |  | FRA |  | [NAME]
16 | 97565 |  | IND |  | [NAME]
17 | 88291 |  | POL |  | [NAME]
18 | 80204 |  | JPN |  | Kiyomi Kawata
19 | 1557 |  | IRL |  | [NAME]
20 | 70243 |  | THA |  | [NAME] [5/8]
21 | 67624 |  | FRA |  | [NAME]
22 | 5114 |  | RSA |  | [NAME]
23 | 93117 |  | IND |  | [NAME]
24 | 90731 |  | ENG |  | [NAME] [3/4]
25 | 82357 |  | NED |  | [NAME]
26 | 84825 |  | JPN |  | [NAME]
27 | 72972 |  | FRA |  | [NAME]
28 | 95744 |  | RUS |  | Irina Shalmanova [5/8]
29 | 65495 |  | ENG |  | [NAME]
30 | 80449 |  | IND |  | [NAME]
31 | 65351 |  | SUI |  | [NAME]
32 | 8576 |  | DEN |  | [NAME] [2]
Spreadsheet: 218882d1362598260-calculate-standard-deviation-for-column-based-on-column-heading-book10
Sheet: Sheet2

 | aa | bb | cc
2013-03-06 00:00:00 | 32 | 39 | 84
2013-02-27 00:00:00 | 88 | 36 | 81
2013-02-20 00:00:00 | 90 | 57 | 38
2013-02-13 00:00:00 | 52 | 86 | 62
2013-02-06 00:00:00 | 34 | 89 | 46
2013-01-30 00:00:00 | 72 | 63 | 79
2013-01-23 00:00:00 | 87 | 69 | 61
2013-01-16 00:00:00 | 52 | 51 | 70
2013-01-09 00:00:00 | 39 | 53 | 24
2013-01-02 00:00:00 | 89 | 92 | 54
2012-12-26 00:00:00 | 34 | 65 | 25
2012-12-19 00:00:00 | 63 | 29 | 100
Spreadsheet: 124134d1318174537-hlookup-h-lookup-problem
Sheet: Sheet1

 |  |  |  |  |  |  | Depart Code | [NAME] | IN value | In No | SR Value | Sr  No
Sum of Amount | Column Labels |  |  |  |  |  | 1 | A-1
Row Labels | 1 | 2 | 3 | 4 | Grand Total |  | 2 | A-2
IN | 716198.93 | 29150 | 102005 | 95621 | 942974.93 |  | 3 | A-3
SR | -122491.06 |  |  | -11754 | -134245.06 |  | 4 | A-4
Grand Total | 593707.8700000001 | 29150 | 102005 | 83867 | 808729.8700000001 |  | 5 | A-5
 |  |  |  |  |  |  | 6 | A-6
 |  |  |  |  |  |  | 8 | A-7
 |  |  |  |  |  |  | 9 | A-8
 |  |  |  |  |  |  | 10 | [NAME]
 |  |  |  |  |  |  | 11 | A-10
 |  |  |  |  |  |  | 12 | A-11
 |  |  |  |  |  |  |  | Need the respective formulas in J,K,L and M columns above please
 |  |  |  |  |  |  |  | As you can see if some day IN is missing the SR comes to A4
 |  |  |  |  |  |  |  | and it totally gives false results in above coulumns.
Count of Amount | Column Labels
Row Labels | 1 | 2 | 3 | 4 | Grand Total
IN | 114 | 6 | 10 | 22 | 152
SR | 23 |  |  | 6 | 29
Grand Total | 137 | 6 | 10 | 28 | 181
Spreadsheet: 5d503af9-aad8-43be-b9a4-ea35da8cad4d
Sheet: Sheet1

OPERATING/PROGRAMMATIC | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Legislative Fiscal Note |  |  |  |  |  |  | Ordinance Number
Ordinance Title (in Brief)
 | Authorizing acceptance and approval of a Health Care Foundation of Greater Kansas City grant
 | through a one year contract for $75,000.
Does this Legislation Estimate New or Additional Revenues to the City? |  |  |  |  |  |  |  | No |  | X | Yes
 | If yes, please identify in  which Fund these revenues will be deposited (e.g. General, Sales Tax)
 | and provide the following revenue information:
 | Revenue Detail |  |  |  | FY 2007-08 |  |  | FY 2008-09
 | General Fund |  |  |  | 0 |  |  | 0
 | Special Revenue |  |  |  | 50000 |  |  | 25000
 | Enterprise
 |  |  | Total: | $ | 50000 |  | $ | 25000
 | (Please detail type of revenue (fees, grants, tax) and change that will occur as a result of this legislation.  Provide multi-year
 | estimates if known, or if grant revenue please identify source of funds (federal or state) and duration of grant support)
Does this Legislation increase appropriations in the current budget? |  |  |  |  |  |  |  | No |  | X | Yes
 | If Yes, please complete the following budget information:
 | Expense Detail |  |  |  | FY 2007-08 |  |  | FY 2008-09
 | General Fund |  |  |  | 0 |  |  | 0
 | Special Revenue |  |  |  | 50000 |  |  | 25000
 | Enterprise/Other
 |  |  | Total: | $ | 50000 |  | $ | 25000
 | Please detail the extent to which these increased appropriations will be of a permanent nature (e.g. number of
 | additional staff, facilities, long-term contracts)
Does this Legislation expand the scope of current city services? |  |  |  |  |  |  |  | No |  | X | Yes
 | (Please detail estimate number of people to be served, who is delivering services currently to that population, service
 | performance expectations, and if grant supported, provisions for support if grant support ends.
 | This grant will provide intake, case management, counseling, and post release services for the women
 | incarcerated at the Municipal Correctional Institution
Is this legislation the result of a federal or state legislative mandate? |  |  |  |  |  |  | X | No |  |  | Yes
 | (If yes, please detail the purpose and source for that mandate).
Reviewed by:
 | 0ffice of Management and Budget |  |  | OMB Approval Date
Spreadsheet: 884534d1733760665-search-an-array-but-return-only-certain-cells-lee-test-2
Sheet: Data

 |  |  |  |  |  |  |  |  |  |  |  | DO | DB | IQ | RQ | FQ
[NAME] | Company 2 | 100 | Y | 6.11 | 3.12 | 3.12 | £120K | [NAME] | 14 1 |  | x |  |  |  | x |  | London Central North | MTK
OPP1347769 | ZH Ltd | 100 | Y | 27.11 | 4.12 | 4.12 | circa £56 | [NAME] | 7 1,1,1 | 16.1 | x |  |  |  |  | x | [NAME] | MFR
OPP1353878 | Apple FC | 50 | Y | 25.11 | 5.12 | 5.12 | 63K circa | [NAME] | 8 | 16 | x |  |  |  | x |  | Teeside | CR
[NAME] | Reed House | 30 | Y | 24.11 | 5.12 | 5.12 |  | clsroom block | 1 | 2 | x |  |  |  | x |  | Reading | CR
OPP1354564 | Zephyr HQ | 10 | Y | 28.11 | 3.12 | 2.12 | £57k | DX322 | 4 | 7..6 | x |  |  |  | x |  | LE - Thameside | JW
[NAME] | [NAME] and Caps | 100 | Y | 6.11 | 3.12 | 3.12 | £120K | [NAME] | 14 1 |  | x |  |  |  | x |  | London Central North | [NAME]
OPP1347769 | LRD Ltd | 100 | Y | 27.11 | 4.12 | 4.12 | circa £56 | [NAME] | 7 1,1,1 | 16.1 | x |  |  |  |  | x | [NAME] | MFR
OPP1353878 | Company 1 | 50 | Y | 25.11 | 5.12 | 5.12 | 63K circa | [NAME] | 8 | 16 | x |  |  |  | x |  | Teeside | MFR
[NAME] | Dogs and Cats | 30 | Y | 24.11 | 5.12 | 5.12 |  | clsroom block | 1 | 2 | x |  |  |  | x |  | Reading | CR
OPP1354564 | ABC Signs | 10 | Y | 28.11 | 3.12 | 2.12 | £57k | DX322 | 4 | 7..6 | x |  |  |  | x |  | LE - Thameside | JW
[NAME] | Thimbles R Us | 100 | Y | 6.11 | 3.12 | 3.12 | £120K | [NAME] | 14 1 |  | x |  |  |  | x |  | London Central North | MTK
OPP1347769 | Mighty Energy Services | 100 | Y | 27.11 | 4.12 | 4.12 | circa £56 | [NAME] | 7 1,1,1 | 16.1 | x |  |  |  |  | x | [NAME] | MFR
OPP1353878 | Hill Hall Hotel | 50 | Y | 25.11 | 5.12 | 5.12 | 63K circa | [NAME] | 8 | 16 | x | x |  |  |  |  | Teeside | [NAME]
[NAME] | Snooker UK Ltd | 30 | Y | 24.11 | 5.12 | 5.12 |  | clsroom block | 1 | 2 | x | x |  |  |  |  | Reading | CR
OPP1354564 | Wuindswept Ltd | 10 | Y | 28.11 | 3.12 | 2.12 | £57k | DX322 | 4 | 7..6 | x |  |  |  | x |  | LE - Thameside | JW
[NAME] | Flix and Furnish | 100 | Y | 6.11 | 3.12 | 3.12 | £120K | [NAME] | 14 1 |  | x |  |  |  | x |  | London Central North | [NAME]
OPP1347769 | Highlotte School | 100 | Y | 27.11 | 4.12 | 4.12 | circa £56 | [NAME] | 7 1,1,1 | 16.1 | x |  |  |  |  | x | [NAME] | MFR
OPP1353878 | Weavers School | 50 | Y | 25.11 | 5.12 | 5.12 | 63K circa | [NAME] | 8 | 16 | x |  |  |  | x |  | Teeside | MFR
[NAME] | Bunce UK | 30 | Y | 24.11 | 5.12 | 5.12 |  | clsroom block | 1 | 2 | x |  |  |  | x |  | Reading | CR
OPP1354564 | Goalposts 4 All | 10 | Y | 28.11 | 3.12 | 2.12 | £57k | DX322 | 4 | 7..6 | x |  |  |  | x |  | LE - Thameside | JW
Spreadsheet: 792321d1660838371-makearray-inside-let-function-result-in-value-error-makearray-inside-let-function-result-in-value-error
Sheet: Sheet2

Name | ID#1 | ID#2 | ID#3 | ID#4 |  |  | List of PO | ID#1 | ID#2 | ID#3 | ID#4 |  | Result
PO Group #1 | [NAME] | A103 | A104 |  |  |  |  |  | A103 | A104
PO Group #2 | A102 | D902 |  |  |  |  | PO Group #2 | A102 | D902 |  |  |  | Doe |  |  | #[NAME]!
PO Group #3 | B101 | B102 | D903 |  |  |  | D901 |  |  |  |  |  | [NAME] |  |  | #[NAME]!
 |  |  |  |  |  |  | PO Group #3 | B101 | B102 | D903 |  |  | [NAME] || Doe |  |  | #[NAME]!
Table2 |  |  |  |  |  |  | C104 |  |  |  |  |  | #N/A |  |  | #[NAME]!
Table1
PO Number | Customer Name
[NAME] | [NAME]
A102 | Doe
B101 | [NAME]
B102 | Doe
C101 | FirstName
C102 | LastName
A103 | [NAME]
B103 | Bixie
C103 | Cat
D901 | [NAME]
D902 | Doe
D903 | [NAME]
 |  |  |  |  |  |  | PO Group #1
 |  |  |  |  |  |  | PO Group #2
 |  |  |  |  |  |  | D901
 |  |  |  |  |  |  | PO Group #3
 |  |  |  |  |  |  | C104
Spreadsheet: 32736d1228914820-how-to-rank-by-group-help_rank-2-
Sheet: Sheet1

 |  | Kind | Mark | Index ?
 |  |  |  |  | Result I Desire
 |  | C | 6.111111111111111 | ? | 5
 |  | D | 4.222222222222222 | ? | 9
 |  | C | 5.111111111111111 | ? | 7
 |  | A | 8.444444444444445 | ? | 2
 |  | B | 6.6 | ? | 3
 |  | B | 6.6 | ? | 3
 |  | C | 5.555555555555555 | ? | 6
 |  | A | 9.222222222222221 | ? | 1
 |  | D | 3.666666666666667 | ? | 10
 |  | D | 5.222222222222222 | ? | 8
 |  |  | How to rank by group : A first, next B, then C and final D
 |  |  | Note : Do not sort the database
Spreadsheet: 733584d1621631249-not-sure-how-to-tackle-this-sample-2-
Sheet: Sheet2

EMPLID | lookup1 | NAME | lookup2 | ACTION | EFFDT
10001 |  | DUCK,[NAME] |  | H | 2016-08-15 00:00:00
10001 |  | DUCK,[NAME] |  | T | 2016-09-06 00:00:00
10001 |  | DUCK,[NAME] |  | H | 2016-09-17 00:00:00
10001 |  | DUCK,[NAME] |  | T | 2016-10-02 00:00:00
10002 |  | [NAME],MICKEY |  | H | 2019-06-04 00:00:00
10002 |  | [NAME],MICKEY |  | T | 2019-08-11 00:00:00
10002 |  | [NAME],MICKEY |  | H | 2019-08-12 00:00:00
10002 |  | [NAME],MICKEY |  | T | 2019-09-23 00:00:00
10003 |  | [NAME],MINNIE |  | H | 2020-02-27 00:00:00
10003 |  | [NAME],MINNIE |  | T | 2021-03-19 00:00:00
Spreadsheet: 118540d1313753154-suming-an-ongoing-waiting-list-excel-example-ongoing-waiting-list
Sheet: Feb

Feb
Orthopaedics |  |  |  |  |  |  |  |  |  |  |  | User Satisfaction
Name | Hosp no. | Psy no. | IP/OP code | Referral received date | Opt in date | Appt date | Outcome of Assessment | IP waiting time (weeks) | OP waiting time (weeks) | Discharge date | Action | Sent | Received
FRED |  |  | IP | 2011-05-29 00:00:00 |  | 2011-09-02 00:00:00 |  | 13.71428571428571
BOB |  |  | OP | 2011-06-25 00:00:00 | 2011-07-13 00:00:00 |  |  |  | 5.285714285714286
ARTHUR |  |  | OP | 2011-08-01 00:00:00 | 2011-08-03 00:00:00 | 2011-08-27 00:00:00 |  |  | 3.428571428571428
SID |  |  | IP | 2011-05-08 00:00:00 |  |  |  | 14.71428571428571
Ongoing waiting list
Spreadsheet: 263360d1378456716-how-to-adjust-salary-advances-of-different-months-against-last-unpaid-month-salary-original
Sheet: TERMS

ID | MONTHS | EURO | US$ | GBP |  | CURRENCY
1 | J A N U A R Y | 210 | 160 | 265 |  | USD $
 | F E B R U A R Y | 211 | 161 | 270 |  | GBP £
 | M A R C H | 209 | 162 | 268 |  | EURO €
 | A P R I L | 212 | 163 | 260 |  | NGN ₦
 | M A Y | 210 | 162 | 262
 | J U N E | 209 | 161.5 | 268
 | J U L Y | 211 | 160.5 | 261
 | A U G U S T | 212 | 160.5 | 260
 | S E P T E M B E R | 212 | 159.5 | 268
 | O CT O B E R | 210 | 159.6 | 260
 | N O V E M B E R | 210.5 | 160 | 260
 | D E C E M B E R | 210.5 | 158.9 | 261
 | Select Month
Spreadsheet: 25d4b55f-78b1-4025-ad90-9a0703a4bc3f
Sheet: BuyOrRent

Buy or Rent a Drill
I. Known Information:
Planning period (years): |  | 10
Discount rate: |  | 0.1
Acres of cropland: |  | 600
Purchase cost of a new drill ($): |  | 24000
Residue value of the drill ($): |  | 4000
Annual repair cost ($): |  | 300
Annual taxes and insurance ($): |  | 50
[NAME] rental cost ($/acre): |  | 7.5
II. Analysis:
 |  | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
Additional Revenue ($):
Reduced Costs ($):
 | [NAME] rental cost ($/acre):
Total positive effects ($):
Additional Costs ($):
 | Purchase cost of a new drill ($):
 | Residue value of the drill ($):
 | Annual repair cost ($):
 | Annual taxes and insurance ($):
Reduced revenue ($):
Total negative effects ($):
Net effect ($):
Net Present Value (NPV, $):
Internal Rate of Return (IRR):