tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 766868d1644125468-indirekt-wechseln-dynamisch-indirekt-wechseln-dynamisch
Sheet: Daten

MR | GA | Name
OST | Müller | [NAME]
[NAME] | Müller | Flavian
OST | Herzog | Remo
OST | Herzog | [NAME] |  | Dieser [NAME] (Spalte A-C) wechseln in der [NAME] und im [NAME]
OST | Herzog | Frieda
West | Meyer | [NAME]
West | Meyer | [NAME]
West | Meyer | [NAME]
West | Meyer | [NAME]
West | Paulsen | Hermann
West | Paulsen | Ulla
West | Paulsen | Ursula
West | Paulsen | Heinz
West | Paulsen | Thomi
Spreadsheet: 140886d1328923648-large-database-yfeb-food-total-values
Sheet: 2-1-12

 | Breakfast | Quantity | Measure | Food Item | Cost | Daily Points
 |  | 0.75 | cup | milk
 | Daily Total | 1 | cup | cheerios
 | Lunch | Quantity | Measure | Food Item | Cost | Daily Points
 |  | 1 | slice | english muffin
 |  | 3 | sticks | carrot
 | Dinner | Quantity | Measure | Food Items | Cost | Daily Points
 |  | 3 | sticks | chicken legs |  | 12
Spreadsheet: 128506d1321016288-numerical-sorting-800428-numerical-sorting-brelu
Sheet: Data JB

 |  |  |  |  |  |  | MEMBERS SCORE CARDS |  |  |  |  |  |  |  |  |  |  |  | SumCode | Rank
13 | 9 | 8 | 6 | 9 | 9 | 10 | 11 | 11 | 9 | 10 | 8 | 10 | 9 | 12 | 9 | 9 |  |  | 162.01 | 17
14 | 9 | 12 | 9 | 13 | 11 | 10 | 12 | 13 | 12 | 13 | 14 | 13 | 11 | 9 | 11 | 9 |  |  | 195.02 | 6
10 | 9 | 9 | 7 | 8 | 14 | 11 | 8 | 10 | 8 | 13 | 10 | 12 | 8 | 11 | 8 | 15 |  |  | 171.03 | 15
13 | 8 | 7 | 7 | 10 | 11 | 9 | 7 | 9 | 11 | 11 | 15 | 10 | 10 | 12 | 15 | 8 |  |  | 173.04 | 13
10 | 7 | 9 | 6 | 11 | 8 | 12 | 10 | 10 | 9 | 12 | 13 | 11 | 9 | 7 | 10 | 8 |  |  | 162.05 | 16
13 | 10 | 12 | 9 | 11 | 14 | 12 | 12 | 15 | 9 | 14 | 11 | 13 | 9 | 12 | 11 | 9 |  |  | 196.06 | 5
13 | 10 | 13 | 9 | 15 | 15 | 13 | 13 | 12 | 12 | 15 | 14 | 15 | 12 | 15 | 9 | 10 |  |  | 215.07 | 1
13 | 10 | 11 | 7 | 11 | 13 | 11 | 7 | 10 | 13 | 15 | 12 | 15 | 10 | 9 | 9 | 8 |  |  | 184.08 | 9
14 | 11 | 11 | 8 | 12 | 10 | 13 | 13 | 13 | 13 | 14 | 15 | 14 | 14 | 15 | 10 | 8 |  |  | 208.09 | 2
12 | 8 | 9 | 9 | 11 | 9 | 11 | 11 | 9 | 10 | 12 | 14 | 9 | 9 | 15 | 11 | 12 |  |  | 181.1 | 10
12 | 10 | 10 | 8 | 11 | 9 | 9 | 8 | 10 | 15 | 13 | 14 | 12 | 11 | 10 | 10 | 8 |  |  | 180.11 | 11
10 | 7 | 9 | 4 | 8 | 10 | 9 | 7 | 8 | 9 | 9 | 15 | 8 | 8 | 13 | 12 | 8 |  |  | 154.12 | 18
12 | 10 | 12 | 10 | 11 | 12 | 11 | 8 | 10 | 11 | 11 | 14 | 12 | 10 | 14 | 11 | 11 |  |  | 190.13 | 7
12 | 8 | 12 | 7 | 11 | 8 | 13 | 6 | 10 | 11 | 12 | 15 | 13 | 9 | 14 | 11 | 12 |  |  | 184.14 | 8
12 | 10 | 15 | 11 | 13 | 12 | 12 | 10 | 10 | 10 | 10 | 12 | 13 | 14 | 15 | 12 | 15 |  |  | 206.15 | 3
10 | 9 | 12 | 9 | 11 | 11 | 10 | 10 | 11 | 9 | 12 | 11 | 9 | 12 | 10 | 8 | 11 |  |  | 175.16 | 12
12 | 9 | 10 | 8 | 11 | 15 | 12 | 9 | 10 | 10 | 11 | 11 | 9 | 8 | 8 | 8 | 11 |  |  | 172.17 | 14
14 | 12 | 11 | 15 | 11 | 11 | 12 | 11 | 11 | 10 | 10 | 12 | 12 | 10 | 15 | 11 | 10 |  |  | 198.18 | 4
Spreadsheet: 192913c9-099a-4daa-99c2-8f3b77d3112f
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2011-03-14 09:24:23.140000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
5.25 | 101.75 | 101.75 | 101.625 | 101.125 |  | and are added to price quote
5.125 | 101.589 | 101.589 | 101.464 | 100.964
5 | 101.163 | 101.163 | 101.038 | 100.538 |  | Note: | Refer To Price [NAME]
4.875 | 100.659 | 100.659 | 100.534 | 100.034 |  |  | For all Price Adjs
4.75 | 99.7 | 99.7 | 99.575
4.625 | 98.49799999999999 | 98.49799999999999 | 98.37299999999999
 |  |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  |  | Please note availability of
 |  |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  |  | Will apply.
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4.375 | 101.75 | 101.75 | 101.625 | 101.125
4.25 | 101.201 | 101.201 | 101.076 | 100.576
4.125 | 100.001 | 100.001 | 99.87599999999999 | 99.37599999999999
4 | 99.67099999999999 | 99.67099999999999 | 99.54599999999999 | 99.04599999999999
3.875 | 99.232 | 99.232 | 99.107
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2011-03-14 09:24:23.140000
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2011-03-28 09:24:23.140000
30 DAY | 2011-04-12 09:24:23.140000
45 DAY | 2011-04-27 09:24:23.140000
60 DAY | 2011-05-12 09:24:23.140000
90 DAY | 2011-06-11 09:24:23.140000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: dutch_quigley__9188__NGDelta12-3
Sheet: Sheet1

Natural Gas
 |  | Delta
Month | Futures | Options | Combined
2001-01-02 00:00:00 | 117 | -35
2001-02-02 00:00:00 | -218 | 111
2001-03-02 00:00:00 | -11 | -6
2001-04-02 00:00:00 | 78 | 108
2001-05-02 00:00:00 | 403 | 27
2001-06-02 00:00:00 | -360 | 191
2001-07-02 00:00:00 | 289 | 0
2001-08-02 00:00:00 | -4340 | 3
2001-09-02 00:00:00 | -1930 | -2
2001-10-02 00:00:00 | 693 | -13
2001-11-02 00:00:00 | 150 | -8
2001-12-02 00:00:00 | 50 | -50
2001-01-03 00:00:00 | 182 | 0
2001-02-03 00:00:00 | 445 | 0
2001-03-03 00:00:00 | 88 | 16
2001-04-03 00:00:00 | -185 | 0
2001-05-03 00:00:00 | 363 | 0
2001-06-03 00:00:00 | -91 | 0
2001-07-03 00:00:00 | 265 | 0
2001-08-03 00:00:00 | 286 | 0
2001-09-03 00:00:00 | 331 | 0
2001-10-03 00:00:00 | 352 | 0
2001-11-03 00:00:00 | 388 | 0
2001-12-03 00:00:00 | 416 | 0
2001-01-04 00:00:00 | 0 | 0
2001-02-04 00:00:00 | 460 | 0
2001-03-04 00:00:00 | -29 | 0
2001-04-04 00:00:00 | 0 | 0
2001-05-04 00:00:00 | -9 | 0
2001-06-04 00:00:00 | 0 | 0
2001-07-04 00:00:00 | 0 | 0
2001-08-04 00:00:00 | 541 | 0
2001-09-04 00:00:00 | 74 | -84
2001-10-04 00:00:00 | 945 | 0
2001-11-04 00:00:00 | 40 | 0
2001-12-06 00:00:00 | 0 | 0
2001-12-07 00:00:00 | 0 | 0
Spreadsheet: 218164d1362378741-total-items-using-tick-boxes-book1
Sheet: Sheet2

Bills
 |  | Months | [NAME] | Days | Weeks | Each p/w
Gas |  | 2 | 140 | 41
Water |  |  | 23.65 | 40
Electricity |  | 3 | 195.34 | 31
Internet+Phone |  | 1 | 90 | 29
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
Number of people | $ p/w each | Total: |  |  |  | Total bills p/w each
1 | 20 | 298
Spreadsheet: f20ca1d7-a6f2-4a38-86ed-eb6441e6b7e8
Sheet: Sheet1

analytica 2012 - List of exhibitors | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Search by product and service index (6 Entries):
 | 5 Laboratory apparatus 5.4 Laboratory technology and equipment 5.4.4 Cleaning equipment [NAME]-washing machines
No. | Company | Country | City | [NAME] | Hall/Booth
1 | Belimed Deutschland GmbH | Germany | Mühldorf | 84453 | B1.316
2 | GETINGE LANCER | France | Tournefeuille | 31170 | B1.427
3 | [NAME] | Germany | Wörth | 85457 | B1.222
4 | Labconco Corporation | USA | Kansas City | MO 64034 | B2.125
5 | Miele & Cie. KG [NAME] | Germany | Gütersloh | 33332 | B1.201/302
6 | Riebesam GmbH & Co. [NAME] | Germany | [NAME] | 39307 | B1.457
Spreadsheet: 760294d1640123494-display-names-of-individuals-trained-small-sample
Sheet: Run.Taxi

Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
Spreadsheet: 1921e805-0521-49d1-8529-9e8ebe82a645
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
40407137 | 2014-03-08 02:47:20 | ALLIES | 1 | 6 | 3 | 270299 | 3FingerJimbo | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
Spreadsheet: 845581d1697034415-problem-incrementing-or-decrementing-a-cells-value-based-on-a-filters-value-golfscoresmultiplayermanualentryaligw111023
Sheet: MthlySummary

Mthly Summary
Team | Team1 | Team2 | Team3 | Team4 | Team5 | Team6 | Team7 | Total
2023-11-13 00:00:00 | 6 | 1 | 3 | 5 | 2 | 7 | 4 | 28 | 10
2023-12-04 00:00:00 | 5 | 1 | 2 | 6 | 4 | 7 | 3 | 28 | 9
2024-01-08 00:00:00 | 1 | 6 | 4 | 2 | 5 | 7 | 3 | 28 | 8
2024-02-05 00:00:00 | 1 | 7 | 3 | 5 | 6 | 2 | 3 | 27 | 9
2024-03-04 00:00:00 | 7 | 1 | 4 | 5 | 2 | 6 | 3 | 28 | 10
2024-04-08 00:00:00 | 3 | 6 | 2 | 4 | 5 | 7 | 1 | 28 | 9
2024-05-06 00:00:00 | 3 | 6 | 5 | 4 | 7 | 1 | 2 | 28 | 10
2024-06-03 00:00:00 | 5 | 7 | 2 | 3 | 6 | 4 | 1 | 28 | 10
Spreadsheet: 824543d1680649934-how-to-add-formula-to-show-bank-holiday-bank-holidays-bvj-
Sheet: holidays in england & scotland

England and Wales 2023
Date | Day of the week | Bank holiday
2023-04-07 00:00:00 | Friday | Good Friday
2023-04-10 00:00:00 | Monday | Easter Monday
2023-05-01 00:00:00 | Monday | Early May bank holiday
2023-05-08 00:00:00 | Monday | Bank holiday for the coronation of King [NAME]
2023-05-29 00:00:00 | Monday | Spring bank holiday
2023-08-28 00:00:00 | Monday | Summer bank holiday
2023-12-25 00:00:00 | Monday | Christmas Day
2023-12-26 00:00:00 | Tuesday | Boxing Day
Scotland
Date | Day of the week | Bank holiday
Scotland | Monday | New Year's Day (substitute day)
2023-01-03 00:00:00 | Tuesday | 2 January (substitute day)
2023-04-07 00:00:00 | Friday | Good Friday
2023-05-01 00:00:00 | Monday | Early May bank holiday
2023-05-08 00:00:00 | Monday | Coronation bank holiday
2023-05-29 00:00:00 | Monday | Spring bank holiday
2023-08-07 00:00:00 | Monday | Summer bank holiday
2023-11-30 00:00:00 | Thursday | [NAME]
2023-12-25 00:00:00 | Monday | Christmas Day
2023-12-26 00:00:00 | Tuesday | Boxing Day
Spreadsheet: 752592d1634841379-circular-reference-issue-copy-of-excel-employee-vacation-sheet-2021-prototype
Sheet: Jan

Formation /Training
Congés / Leaves | V
Congés fériés / GC holidays
Fin de semaine / Weekend
T:  Tentative A; Approved
Compressed Day Off
Assignment / Left
Half Day
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Enter year:
January | Dates of Leave |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021
01 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Vacation
Employee Name | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 |  | Replaced by:
January Total
Spreadsheet: 866893d1713805183-help-extracting-specific-text-from-inconsistent-text-strings-data-set-new
Sheet: Sheet1

 |  |  |  |  |  |  | VBA CODE RESULT
Invoice | Code Item | Description | QTY |  | Invoice | Code Item | Description | Cont No
33593 | SI1 | KOE240000059 STUFFING IN : MRTU2090087.FCIU6090526.MRTU2138344 LIFT ON EMPTY : MRTU2126493.MRTU2058450M | 3 |  | 33593 | SI1 | KOE240000059 STUFFING IN : MRTU2090087.FCIU6090526.MRTU2138344 LIFT ON EMPTY : MRTU2126493.MRTU2058450M | MRTU2090087
33593 | LE1 | KOE240000059 STUFFING IN : MRTU2090087.FCIU6090526.MRTU2138344 LIFT ON EMPTY : MRTU2126493.MRTU2058450M | 2 |  | 33593 | SI1 | KOE240000059 STUFFING IN : MRTU2090087.FCIU6090526.MRTU2138344 LIFT ON EMPTY : MRTU2126493.MRTU2058450M | FCIU6090526
 |  |  |  |  | 33593 | SI1 | KOE240000059 STUFFING IN : MRTU2090087.FCIU6090526.MRTU2138344 LIFT ON EMPTY : MRTU2126493.MRTU2058450M | MRTU2138344
 |  |  |  |  | 33593 | LE1 | KOE240000059 STUFFING IN : MRTU2090087.FCIU6090526.MRTU2138344 LIFT ON EMPTY : MRTU2126493.MRTU2058450M | MRTU2090087
 |  |  |  |  | 33593 | LE1 | KOE240000059 STUFFING IN : MRTU2090087.FCIU6090526.MRTU2138344 LIFT ON EMPTY : MRTU2126493.MRTU2058450M | FCIU6090526
 |  |  |  |  | 33593 | LE1 | KOE240000059 STUFFING IN : MRTU2090087.FCIU6090526.MRTU2138344 LIFT ON EMPTY : MRTU2126493.MRTU2058450M | MRTU2138344
 |  |  |  |  |  |  | RESULT I WANT
 |  |  |  |  | Invoice | Code Item | Description | Cont No
 | Note : This are Activity Code and Activity Name (The list is more then this) |  |  |  | 33593 | SI1 | KOE240000059 STUFFING IN : MRTU2090087.FCIU6090526.MRTU2138344 LIFT ON EMPTY : MRTU2126493.MRTU2058450M | MRTU2090087
 | PR1 | Plugging reefer |  |  | 33593 | SI1 | KOE240000059 STUFFING IN : MRTU2090087.FCIU6090526.MRTU2138344 LIFT ON EMPTY : MRTU2126493.MRTU2058450M | FCIU6090526
 | SI1 | STUFFING IN |  |  | 33593 | SI1 | KOE240000059 STUFFING IN : MRTU2090087.FCIU6090526.MRTU2138344 LIFT ON EMPTY : MRTU2126493.MRTU2058450M | MRTU2138344
 | LE1 | LIFT ON EMPTY |  |  | 33593 | LE1 | KOE240000059 STUFFING IN : MRTU2090087.FCIU6090526.MRTU2138344 LIFT ON EMPTY : MRTU2126493.MRTU2058450M | MRTU2126493
 | RC1 | REPAIR CONTAINER |  |  | 33593 | LE1 | KOE240000059 STUFFING IN : MRTU2090087.FCIU6090526.MRTU2138344 LIFT ON EMPTY : MRTU2126493.MRTU2058450M | MRTU2058450
 | TI1 | TAMBAH ISI
 | AK1 | ALIH KAPAL |  |  |  | Note : When the description Showing more than One Activity, The container name will be break down or extract by it Activity
 | TRF1 | THC & RELOKASI FULL
Spreadsheet: 881804d1729992033-2025-player-of-the-year-formula-2025-poy-test
Sheet: Payout Calculations

Payout Calculations
Players | 1st | 2nd | 3rd | 4th | 5th | 6th | 7th | 8th | 9th | 10th | 11th | 12th | Total
1
2 | 20
3 | 30
4 | 40
5 | 40 | 10
6 | 40 | 20
7 | 40 | 20 | 10
8 | 45 | 25 | 10
9 | 45 | 30 | 15
10 | 45 | 30 | 20 | 5
11 | 45 | 35 | 20 | 10
12 | 50 | 40 | 20 | 10
13 | 50 | 40 | 25 | 15
14 | 50 | 40 | 30 | 20
15 | 50 | 40 | 30 | 20 | 10
16 | 55 | 45 | 30 | 20 | 10
17 | 55 | 45 | 35 | 25 | 10
18 | 55 | 45 | 35 | 25 | 15 | 5
19 | 55 | 45 | 35 | 25 | 20 | 10
20 | 60 | 50 | 35 | 25 | 20 | 10
21 | 60 | 50 | 40 | 25 | 20 | 10 | 5
22 | 60 | 50 | 40 | 30 | 20 | 15 | 5
23 | 60 | 50 | 40 | 30 | 25 | 15 | 10
24 | 65 | 50 | 40 | 30 | 25 | 20 | 10
25 | 65 | 55 | 45 | 30 | 25 | 20 | 10
26 | 65 | 55 | 45 | 35 | 25 | 20 | 10 | 5
27 | 65 | 55 | 45 | 35 | 25 | 20 | 15 | 10
28 | 70 | 55 | 45 | 35 | 30 | 20 | 15 | 10
29 | 70 | 60 | 50 | 35 | 30 | 20 | 15 | 10
30 | 70 | 60 | 50 | 40 | 30 | 20 | 15 | 10 | 5
31 | 70 | 60 | 50 | 40 | 30 | 25 | 20 | 10 | 5
32 | 75 | 60 | 50 | 40 | 30 | 25 | 20 | 15 | 5
33 | 75 | 65 | 55 | 40 | 30 | 25 | 20 | 15 | 5
34 | 75 | 65 | 55 | 45 | 30 | 25 | 20 | 15 | 10
35 | 75 | 65 | 55 | 45 | 35 | 30 | 20 | 15 | 10
36 | 80 | 65 | 55 | 45 | 35 | 30 | 25 | 15 | 10
37 | 80 | 70 | 60 | 45 | 35 | 30 | 25 | 15 | 10
38 | 80 | 70 | 60 | 50 | 35 | 30 | 25 | 20 | 10
39 | 80 | 70 | 60 | 50 | 40 | 30 | 25 | 20 | 10 | 5
40 | 85 | 70 | 60 | 50 | 40 | 35 | 25 | 20 | 10 | 5
41 | 85 | 75 | 65 | 50 | 40 | 35 | 25 | 20 | 10 | 5
42 | 85 | 75 | 65 | 55 | 40 | 35 | 30 | 20 | 10 | 5
43 | 85 | 75 | 65 | 55 | 45 | 35 | 30 | 25 | 10 | 5
44 | 90 | 75 | 65 | 55 | 45 | 35 | 30 | 25 | 15 | 5
45 | 90 | 80 | 65 | 55 | 45 | 35 | 30 | 25 | 15 | 10
46 | 95 | 80 | 70 | 55 | 45 | 35 | 30 | 25 | 15 | 10
47 | 95 | 80 | 70 | 60 | 50 | 35 | 30 | 25 | 15 | 10
48 | 95 | 80 | 70 | 60 | 50 | 40 | 35 | 25 | 15 | 10
49 | 95 | 80 | 70 | 60 | 50 | 40 | 35 | 30 | 20 | 10
50 | 95 | 80 | 70 | 60 | 50 | 40 | 35 | 30 | 20 | 15 | 5
51 | 100 | 85 | 70 | 60 | 50 | 40 | 35 | 30 | 20 | 15 | 5
52 | 100 | 85 | 75 | 65 | 50 | 40 | 35 | 30 | 20 | 15 | 5
53 | 100 | 85 | 75 | 65 | 55 | 45 | 35 | 30 | 20 | 15 | 5
54 | 100 | 85 | 75 | 65 | 55 | 45 | 40 | 35 | 20 | 15 | 5
55 | 100 | 85 | 75 | 65 | 55 | 45 | 40 | 35 | 25 | 20 | 5
56 | 100 | 85 | 75 | 65 | 55 | 45 | 40 | 35 | 25 | 20 | 10 | 5
57 | 105 | 90 | 75 | 65 | 55 | 45 | 40 | 35 | 25 | 20 | 10 | 5
58 | 105 | 90 | 80 | 70 | 55 | 45 | 40 | 35 | 25 | 20 | 10 | 5
59 | 105 | 90 | 80 | 70 | 60 | 50 | 40 | 35 | 25 | 20 | 10 | 5
60 | 105 | 90 | 80 | 70 | 60 | 50 | 45 | 40 | 25 | 20 | 10 | 5
Spreadsheet: 787309d1657722553-sum-using-frequency-but-based-off-another-column-sample
Sheet: Sheet1

EmployeeID | Department | DateChanged | AMOUNT
369 | Call Center | 2021-03-08 00:00:00 | 1000 |  | Total Employees:
369 | Call Center | 2021-07-23 00:00:00 | 1200 |  | Employees w/ Raises:
1999 | Operations | 2021-06-01 00:00:00 | 1200
1999 | Operations | 2022-02-04 00:00:00 | 1300 |  | Administration
1999 | Operations | 2022-03-19 00:00:00 | 1400 |  | Employees:
1687 | Operations | 2020-03-19 00:00:00 | 1500 |  | Employees w/ Raises:
1687 | Operations | 2021-06-14 00:00:00 | 1900
1687 | Operations | 2021-11-26 00:00:00 | 2000 |  | Call Center
2163 | Operations | 2021-11-13 00:00:00 | 1600 |  | Employees:
854 | IT | 2021-12-10 00:00:00 | 2000 |  | Employees w/ Raises:
1786 | Marketing | 2021-02-23 00:00:00 | 1400
1786 | Marketing | 2021-10-05 00:00:00 | 1600 |  | HR
1786 | Marketing | 2022-04-28 00:00:00 | 1800 |  | Employees:
860 | Operations | 2021-12-27 00:00:00 | 1200 |  | Employees w/ Raises:
933 | Call Center | 2022-04-04 00:00:00 | 1000
612 | IT | 2021-06-24 00:00:00 | 1500 |  | IT
612 | IT | 2022-02-03 00:00:00 | 1750 |  | Employees:
243 | Administration | 2020-03-19 00:00:00 | 1000 |  | Employees w/ Raises:
243 | Administration | 2020-06-30 00:00:00 | 1100
243 | Administration | 2021-05-03 00:00:00 | 1200 |  | Marketing
243 | Administration | 2021-07-21 00:00:00 | 1300 |  | Employees:
327 | IT | 2020-11-17 00:00:00 | 1550 |  | Employees w/ Raises:
327 | IT | 2021-09-17 00:00:00 | 1700
327 | IT | 2021-12-22 00:00:00 | 1800 |  | Operations
327 | IT | 2022-05-27 00:00:00 | 2000 |  | Employees:
805 | Call Center | 2021-10-01 00:00:00 | 1000 |  | Employees w/ Raises:
805 | Call Center | 2022-02-18 00:00:00 | 1100
2011 | Marketing | 2021-07-02 00:00:00 | 1200
2011 | Marketing | 2021-09-02 00:00:00 | 1300
2159 | Operations | 2021-10-22 00:00:00 | 1400
2437 | Call Center | 2022-06-12 00:00:00 | 1500
1044 | IT | 2022-05-03 00:00:00 | 1900
1275 | Operations | 2022-06-12 00:00:00 | 1400
921 | HR | 2022-03-06 00:00:00 | 1200
838 | HR | 2021-11-13 00:00:00 | 1100
838 | HR | 2022-02-18 00:00:00 | 1300
838 | HR | 2022-05-27 00:00:00 | 1400
832 | Administration | 2021-11-13 00:00:00 | 1200
832 | Administration | 2022-02-18 00:00:00 | 1300
Spreadsheet: 684766d1593528568-power-query-join-two-tables-using-not-equal-criteria-example-document
Sheet: OutputData

assetId | startLocationId | endLocationId | Table2.assetId | Table2.homeLocationId
1 | DepotA |  | 1 | DepotA |  |  |  |  | What I actually want to see is this as the output
1 | DepotA | DepotA | 1 | DepotA
1 | DepotA | DepotC | 1 | DepotA |  |  |  |  | assetId | startLocationId | endLocationId | Table2.assetId | Table2.homeLocationId
2 | DepotB | DepotB | 2 | DepotB |  |  |  |  | 1 | DepotA |  | 1 | DepotA
2 | DepotB |  | 2 | DepotB |  |  |  |  | 1 | DepotA | DepotC | 1 | DepotA
2 | DepotB | DepotB | 2 | DepotB |  |  |  |  | 2 | DepotB |  | 2 | DepotB
3 | DepotA | DepotB | 3 | DepotA |  |  |  |  | 3 | DepotA | DepotB | 3 | DepotA
3 | DepotA | DepotD | 3 | DepotA |  |  |  |  | 3 | DepotA | DepotD | 3 | DepotA
3 | DepotA | DepotA | 3 | DepotA
Spreadsheet: 267331d1380045782-merge-multiple-rows-while-maintaining-the-column-data-pivot
Sheet: Sheet1

Name | L Name | DOB | Score1 | Score2 | Run
Jon | Doe | 1990-01-01 00:00:00 | 99 | 98 | 1
Jon | Doe | 1990-01-01 00:00:00 | 79 | 70 | 2
Doe | Jon |  | 11 | 10 | 1
Doe | Jon |  | 90 | 80 | 2
A | B |  | 80 | 70 | 1
A | B |  | 79 | 20 | 2
B | A |  | 90 | 80 | 1
B | A |  | 80 | 70 | 2
C | A |  | 99 | 98 | 1
C | A |  | 10 | 11 | 2
Spreadsheet: 150583d1334608456-combining-several-worksheets-into-one-invoices
Sheet: Satex ARU

 |  |  |  |  |  | XXXXX Latin America
 |  |  |  |  |  | 355 Alhambra Circle
 |  |  |  |  |  | Suite 1400
April 6, 2012 |  |  |  |  |  | Coral Gables, FL  33134
Ref. No.: | 060412- | D
Freight Forwarder: |  |  |  |  | Ship To:
ALL TRANSPORT INC. |  |  |  |  | SATEX AGENCIES
8369 NW 66 STREET |  |  |  |  | SEROE BLANCO Z/N
MIAMI, FL  33166 |  |  |  |  | ORANJESTAD
 |  |  |  |  | ARUBA
ATTN: SATEX - ARUBA |  |  |  |  | NETHERLANDS ANTILLES
TELE: (305) 591-2762
 |  |  |  |  | ATTN: PEDRO TEXTEIRA
 |  |  |  |  | TELE: 297-837132
Boxes | SKU | Description |  |  |  | Value | TOTAL US$
25 | 97440 | Mini Folding Wire Weekender |  |  |  | 43.33333333333334
10 | 97576 | On - The - Go Stackable Baskets |  |  |  | 28.66666666666667
25 | 97598 | belVita breakfast rack |  |  |  | 50
 | TOTAL |  |  |  |  | TOTAL
 | [NAME]
Spreadsheet: 34752d1232069076-cross-validation-rule-cross-20validation1-1-
Sheet: Sheet1

 |  |  |  |  | Center AA | Departments of AA | Center BB | Departments of BB | Center CC | Departments of CC | Accounts
Account Flex-Fields |  |  |  |  | AA | 444 | BB | 111 | CC | 777 | 721001
Center | Department | Account | MESSAGE |  | AA | 555 | BB | 222 | CC | 888 | 721002
AA | 444 | 249001 | VALID ACCOUNT CODE |  | AA | 666 | BB | 333 | CC | 999 | 721003
AA | 111 | 249001 | IN-VALID ACCOUNT CODE |  |  |  |  |  |  |  | 249001
BB | 222 | 249001 | VALID ACCOUNT CODE |  |  |  |  |  |  |  | 650001
BB | 999 | 249001 | IN-VALID ACCOUNT CODE |  |  |  |  |  |  |  | 221001
CC | 777 | 249001 | VALID ACCOUNT CODE |  |  |  |  |  |  |  | 239005
CC | 555 | 249001 | IN-VALID ACCOUNT CODE |  |  |  |  |  |  |  | 521111
 |  |  |  |  |  |  |  |  |  |  | 940001
 |  |  |  |  |  |  |  |  |  |  | 142001
 |  |  |  |  |  |  |  |  |  |  | 725001
 |  |  |  |  |  |  |  |  |  |  | 725099
 |  |  |  |  |  |  |  |  |  |  | 640002
 |  |  |  |  |  |  |  |  |  |  | 729002
 |  |  |  |  |  |  |  |  |  |  | 729003
 |  |  |  |  |  |  |  |  |  |  | 663001
 |  |  |  |  |  |  |  |  |  |  | 249008
 |  |  |  |  |  |  |  |  |  |  | 235006
 |  |  |  |  |  |  |  |  |  |  | 640001
 |  |  |  |  |  |  |  |  |  |  | 729004
Spreadsheet: 547340d1510503270-filling-across-a-range-of-sheets-test
Sheet: Sea Jenny

BOAT NAME
OWNER NAME
MOORING TYPE
ADDRESS
HOME TEL
MOBILE TEL
[NAME]
BOAT TYPE
LENGTH
HULL COLOUR
UPPER DECK
TENDER?
DURATION
FEE
NEXT INVOICE DUE DATE | 2017-09-04 00:00:00
INVOICE DUE DATE | INVOICE REMINDER DATE | INVOICE SENT DATE | DATE PAID | NOTES
2017-09-04 00:00:00 |  |  |  | Not Paid 2016
Spreadsheet: 118072d1313422349-using-vlookup-on-filtered-data-dummy
Sheet: Sheet1

code | status
00002795 | yes
00003262 | yes
00003266 | yes
00003267 | yes
00003268 | yes
00003269 | yes
00003270 | no
00003271 | no
00003272 | del
00003273 | yes
00035477 | yes
00035478 | yes
00035479 | yes
00035480 | del
00035481 | del
00035482 | del
00035483 | del
00035484 | del
00035486 | no
00035487 | err
00035488 | err
00035489 | no
00035490 | no
Spreadsheet: 760925d1640540793-formula-to-calculate-average-daily-balance-finding-avg-daily-balance-update-2
Sheet: Sheet2

Date | Type | Amount
2006-11-29 00:00:00 | Equity Debt/Credit | 2500
2006-12-29 00:00:00 | Equity Debt/Credit | 1000
2007-01-01 00:00:00 | Equity Debt/Credit | 10
2007-01-03 00:00:00 | Purchase | -3
2007-01-04 00:00:00 | Equity Debt/Credit | -5
2007-01-07 00:00:00 | Equity Debt/Credit | 100
2007-01-10 00:00:00 | Equity Debt/Credit | 10
2007-01-13 00:00:00 | Equity Debt/Credit | -5
2007-01-16 00:00:00 | Equity Debt/Credit | 10
2007-01-19 00:00:00 | Equity Debt/Credit | 100
2007-01-21 00:00:00 | Sale | 7
2007-01-22 00:00:00 | Equity Debt/Credit | 10
2007-01-25 00:00:00 | Equity Debt/Credit | 100
2007-01-28 00:00:00 | Equity Debt/Credit | -5
2007-01-31 00:00:00 | Equity Debt/Credit | 100
2007-02-03 00:00:00 | Equity Debt/Credit | 10