tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 031fb7c5-4261-4bff-99a8-c5a072ae7e24
Sheet: Extra Comp

SOUTHERN METHODIST UNIVERSITY
EXTRA COMPENSATION PAYMENT AUTHORIZATION
Dedman College - Summer Teaching Only
PAY TO:
 | Name |  |  |  |  |  |  |  | Dept.
 | SMU ID |  |  |  |  | Dept. Contact
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Phone
 | Employee Type: |  |  | Biweekly |  |  |  |  | Staff
 |  |  |  | Monthly |  |  |  |  | Faculty
PAY INSTRUCTIONS:
 | Total amount to be paid |  |  |  |  |  |  |  | Date payments to begin
 | Amount per payment |  |  |  |  |  |  |  | Number of payments to be made
ACCOUNT(S) TO BE CHARGED:
 | 1st Account Number to Charge |  |  | 10 |  | 210005 |  |  |  |  |  |  |  | Amount
 |  |  |  | Fund |  | Organization |  |  | Project |  |  | Account
 | 2nd Account Number to Charge |  |  |  |  |  |  |  |  |  |  |  |  | Amount
 |  |  |  | Fund |  | Organization |  |  | Project |  |  | Account
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
AUTHORIZATION:
 | Home Base Department |  |  |  |  |  |  |  |  |  |  | Date
 | Department Charged |  |  |  |  |  |  |  |  |  |  | Date
 | (If Different from Home Base)
 | VP, [NAME], or FO |  |  |  |  |  |  |  |  |  |  | Date
EXTRA COMP INSTRUCTIONS:
 | 1. This form should be used to pay an additional amount to an employee with an established job and a base pay rate.
 | 2. The extra compensation payment will be added to the next regular payroll check of the employee, on or after the 'Date payments to begin' specified above.
 | 3. An extra compensation request that is not received by the published Payroll deadline for the expected pay date is not eligible to be processed on an off-cycle payroll.
 | 4. Extra compensation is not eligible for retirement benefits unless payment is for one of two conditions. Indicate type of pay, if applicable, in the Description area below.
 | 5. Obtain all approvals before submitting this request to the Payroll Department, [NAME]. Allow sufficient time for the approval process to be completed prior to the Payroll deadline.
ADDITIONAL AUTHORIZATIONS:
 | 1. Extra comp payments for faculty members must be approved by the Provost's Office.
 | 2. Extra comp payments for biweekly staff employees must be approved by the Compensation Manager in HR.
 | 3. Extra comp payments charged to a grant must be approved by Grants and Contract Accounting.
DESCRIBE REASON FOR EXTRA COMP PAYMENT: |  |  |  |  |  |  | FOR AMOUNTS CHARGED TO
 |  |  |  |  |  |  | [NAME] AND CONTRACTS
 |  |  |  |  |  |  | I affirm that the distribution(s) to the above listed Grant or Contract reflects the appropriate amount and actual effort for the employee for the period stated and that the amount(s) charged have been previously approved by the Grantor.
Not eligible for retirement unless for faculty member and:
 | Pay for teaching during summer or interterm sessions
 | Pay from externally funded grants or contracts that provide for salary and benefits. |  |  |  |  |  | EMPLOYEE AND/OR PROJECT DIRECTOR
Spreadsheet: 797715d1664094453-formula-needs-slight-tweaking-to-show-correct-results-book1-1-
Sheet: Forward Contract Calculator (S)

 | Account Balance
 | 20000
 | Name Of Instrument | Ticker Symbol | Entry Signal Price (From TradingView) | Stop Price (From TradingView) | % Risk | Risk Amount | DFB Price (From IG Index) | Forward Contract Price (From IG Index) | Forward Contract Entry Order | Forward Contract Stop Distance | Risk Per Point | No. Of CFD Shares
 |  |  | 33759 | 38486 | 0.02 |  | 34323 | 35111
Spreadsheet: 812365d1673095333-split-string-into-separate-columns-without-delimiter-example-split-string-to-columns
Sheet: Sheet2

110011
BCDE
Spreadsheet: 121647d1316215411-calculating-interest-with-late-fees-loansinterest
Sheet: Sheet1

 | A guy buys a car for 30,000 on a 7% annual loan and gets a $35 late charge each time he is late.  Show your work.
Month | Balance | Pmt Amt | Interest | Principal | Late Charge | New Balance |  | Hints - 7% annually means .07/12 interest every month.
1 | 30000 | 300 |  |  | 0 |  |  | << This is the easy way to do it but not what the instructor wants
2 |  | 300 |  |  | 35
3 |  | 300 |  |  | 0 |  |  |  | <<<This is what s/he is looking for.  Read PMT function.
4 |  | 300 |  |  | 0 |  |  |  | I made the Nper (number of periods/payments = 5 years = 60 months)
5 |  | 300 |  |  | 35
6 |  | 300 |  |  | 0 |  |  |  | It looks like my guess of $300/month was about half of what was needed
7 |  | 300 |  |  | 0
8 |  | 300 |  |  | 0
9 |  | 300 |  |  | 0
10 |  | 300 |  |  | 0
11 |  | 300 |  |  | 35
12 |  | 300 |  |  | 0
13 |  | 300 |  |  | 0
14 |  | 300 |  |  | 0
15 |  | 300 |  |  | 0
16 |  | 300 |  |  | 0
17 |  | 300 |  |  | 0
18 |  | 300 |  |  | 0
19 |  | 300 |  |  | 0
20 |  | 300 |  |  | 0
21 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
 |  | 300 |  |  | 0
Spreadsheet: 820746d1678278319-find-exact-match-in-string-array-s666-pq-find-exact-match-in-string-array-v2
Sheet: Sheet1

To find |  | Code | Name |  | To find | Code | Name
7523M |  | 17 | * 046300 VIS INOX A2 4,8 X 38 (200P) |  | INOX | 17 | * 046300 VIS INOX A2 4,8 X 38 (200P)
7523L |  | 21 | * SEUIL DINAC 3M REF 207500 |  | 26034 | 10 | 3M 26034 PPS SERIES 2.0 ADAPTER,TYPE S-4
5535 |  | 19 | **obsolete**4X48,5ML KUNSTSTOFF-REPARATURMATERIAL 05901NEW DOPPELKARTUSCHEN-SET |  | 52025 | 11 | 3M CUBITRON II HOOKIT STREIFEN 737U 80X400MM 52025 P 400
2890S |  | 23 | 2135 FILTRE P3 CATON DE 6 PAIRES
289A |  | 10 | 3M 26034 PPS SERIES 2.0 ADAPTER,TYPE S-4
65170 |  | 20 | 3M 734 SCHUURPAPIER 25ST P240 01979
1639 |  | 5 | 3M ACETAT AUSTAUSCHSCHEIBEN 289A
972 |  | 30 | 3M BOLZEN DRUCKSCHLAUCH HOCHLEISTUNGSPISTOLE 26834
34240 |  | 33 | 3M CUBITRON II FEILENBAND 36+ 13 MM X 520 MM 33443
26034 |  | 34 | 3M CUBITRON II FEILENBAND 60+ 13 MM X 520 MM 33445
52025 |  | 11 | 3M CUBITRON II HOOKIT STREIFEN 737U 80X400MM 52025 P 400
8878 |  | 6 | 3M CUBITRON II [NAME], 76mm x 1mm x 8mm, PN65170
26811 |  | 32 | 3M CUBITRON II TRENNSCHEIBE 75 X 1,6 X 9,53 MM 33455
26814 |  | 28 | 3M DRUCKSCHLAUCH FÜR HOCHLEISTUNGSPISTOLE 26833
26818 |  | 31 | 3M ERSATZVISIER 5F-11
64698 |  | 3 | 3M FINISH-KONTROLSPRAY 55535
INOX |  | 18 | 3M HIGH PERFORMANCE CLOTH BLUE 02010HLBU
2010 |  | 13 | 3M HOCHLEISTUNGSDUESENKOPF HVLP 1,1 MM GELB 26811
5901NEW |  | 14 | 3M HOCHLEISTUNGSDUESENKOPF HVLP 1,4 MM ORANGE 26814
79 |  | 15 | 3M HOCHLEISTUNGSDUESENKOPF HVLP 1,8 MM TRANSPARENT 26818
750 |  | 27 | 3M HOCHLEISTUNGSLACKIERPISTOLE 26832
RET |  | 26 | 3M HOCHLEISTUNGSLACKIERPISTOLEN SYSTEM FLIESSBECHER 26778
 |  | 25 | 3M HOCHLEISTUNGSLACKIERPISTOLEN-SYSTEM INDUSTRIE 26878
 |  | 29 | 3M KUGELHAHN FÜR HOCHLEISTUNGSPISTOLE 26839
 |  | 9 | 3M Plastlagningslim 50 ml, 6 st/fp, 34240A
 |  | 7 | 3M PPS COLOR CORRECTIVE BULB 16399
 |  | 4 | 3M PREMIUM FULL VISION GLASSES 2890SA
 |  | 24 | 3M QUICK CONNECT PERFECT-IT III POLIERSCHAUM 150 MM LILA 33034
 |  | 16 | 3M SCOTCH BRITE VLIESBAND A CRS 13X457MM 64698
 |  | 2 | 3M STARTPAKET L A2/P3 (ers 06783) 7523LF
 |  | 1 | 3M STARTPAKET M 7523MF ERSÄTTER 06782
 |  | 12 | 3M STEINSCHLAGSCHUTZ WEIS.8878
 |  | 8 | FESTO FILTERSACK FUER CT 44 452972 3M 202616
 |  | 22 | LUNETTES SECURET FIT 400 GRISE VERSION SOLAIRE
Spreadsheet: 164798d1340893570-complicated-cell-referencing-calculation-code-help-needed-fulldailymold-copy
Sheet: Disa 1

DATE: |  |  |  | DAILY MODLING PRODUCTION |  |  |  |  | PAGE: | 1 | OF | 2
EMP.NO: |  |  | NAME: |  |  |  | SHIFT: |  | WORK CTR: |  | MACH.NO: | 4000
START TIME | END TIME | OPER. NO. | PATTERN NO. | MOLDS MADE | MOLDS DESTROYED | MOLDS CLOSED | PART NO. | M.O. | PART RATE | IMP | PCS. MADE | DOWNTIME  (MINS) | CORED (Y/N)
20:00:00 | 22:10:00 | 20 | P111111 | 404 |  | 5 | 11111 | M1111111 | 260 | 2 | 798 |  | Y
20:00:00 | 20:10:00 | 9385
20:10:00 | 20:30:00 | 9230
20:30:00 | 20:40:00 | 9250
 |  | 9170 |  |  |  |  |  |  |  | P111111
 |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  | MOLDS CLOSED
DATE: |  |  |  | DAILY MODLING PRODUCTION |  |  |  |  | PAGE: | 2 | OF | 2
EMP.NO: |  |  | NAME: |  |  |  | SHIFT: |  | WORK CTR: |  | MACH.NO: | 4000
START TIME | END TIME | OPER. NO. | PATTERN NO. | MOLDS MADE | MOLDS DESTROYED | MOLDS CLOSED | PART NO. | M.O. | PART RATE | IMP | PCS. MADE | DOWNTIME  (MINS) | CORED (Y/N)
20:00:00 | 21:10:00 | 20 | P22222 | 100 |  | 1 | 22222 | M22222 | 200 | 2 | 198 |  | N
21:10:00 | 21:30:00 | 9010
21:30:00 | 22:00:00 | 9200
 |  | 9170
23:00:00 | 23:20:00 | 20 | P44444 | 200 |  | 2 | 33333 | M333333 | 10 | 2 | 396 |  | Y
23:20:00 | 23:40:00 | 9361
 |  | 9170
DATE: |  |  |  | DAILY MODLING PRODUCTION |  |  |  |  | PAGE: | 3 | OF | 3
EMP.NO: |  |  | NAME: |  |  |  | SHIFT: |  | WORK CTR: |  | MACH.NO: | 4000
START TIME | END TIME | OPER. NO. | PATTERN NO. | MOLDS MADE | MOLDS DESTROYED | MOLDS CLOSED | PART NO. | M.O. | PART RATE | IMP | PCS. MADE | DOWNTIME  (MINS) | CORED (Y/N)
Spreadsheet: 787222d1657698252-arrange-the-rows-values-into-columns-service-utilization-1-
Sheet: Sheet1

Name | Appointment 1 | Appointment 2 | Appointment 3 | Appointment 4 | Appointment 5 | Appointment 6 | Appointment 7 | Appointment 8 | Appointment 9 | Appointment 10 | Appointment 11 | Appointment 12
Spreadsheet: 21d114b0-094d-4035-b81a-f531aa05acbb
Sheet: Sheet1

CDBG Missing Data | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25
MEDFORD OR
Data as of 06/01/2009
Act ID | Status | [NAME] | Matrix CD | Prop Accomp MA04 | Actual [NAME] | Total [NAME] CDBG08 | Create FT Jobs CDBG11 | Create FT Jobs LM CDBG11 | Create PT Hours CDBG11 | Create PT Hours LM CDBG11 | Retain FT Jobs CDBG11 | Retain FT Jobs LM CDBG11 | Retain PT Hours CDBG11 | Retain PT Hours LM CDBG11 | Assist Type CDBG11 | [NAME] CDBG13 | [NAME] CDBG13 | Num Very Low Incm CDBG13 | Units Start CDBG14 | Units [NAME] CDBG14 | Units Occ LM Start CDBG14 | Units Exp CDBG14 | Units [NAME] CDBG14 | Units Occ LM Exp CDBG14 | LMA % CDBG07
280 | 3 | LMC | 03C | 0
281 | 4 | LMC | 03C | 0
282 | 3 | LMH | 14B | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
283 | 3 | LMC | 05D |  | 197 | 0 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
Spreadsheet: 110705d1307335006-excel-2007-keeping-a-running-total-running-total
Sheet: Sheet1

DATE | CREDIT | WHO | PRODUCT | AMOUNT |  |  |  |  |  |  |  |  |  |  | DATE
2011-01-01 00:00:00 | Y | FRED | P1 | 100 |  |  |  |  |  |  |  |  |  |  | 2011-01-01 00:00:00
2011-01-01 00:00:00 |  |  | P3 | 90 |  |  |  |  |  |  |  |  |  |  | 2011-01-02 00:00:00
2011-01-02 00:00:00 | Y | FRED | P2 | 250 |  |  |  |  |  |  |  |  |  |  | 2011-01-03 00:00:00
2011-01-02 00:00:00 |  |  | P1 | 100 |  |  |  |  |  |  |  |  |  |  | 2011-01-04 00:00:00
2011-01-05 00:00:00 |  |  | P4 | 225 |  |  |  |  |  |  |  |  |  |  | 2011-01-05 00:00:00
2011-01-05 00:00:00 |  | FRED | RECEIVED | -130 |  |  |  |  |  |  |  |  |  |  | 2011-01-06 00:00:00
2011-01-05 00:00:00 | Y | [NAME] | P3 | 50 |  |  |  |  |  |  |  |  |  |  | 2011-01-07 00:00:00
2011-01-05 00:00:00 | Y | MARY | P1 | 100 |  |  |  |  |  |  |  |  |  |  | 2011-01-08 00:00:00
2011-01-06 00:00:00 |  | MARY | RECEIVED | -100 |  |  |  |  |  |  |  |  |  |  | 2011-01-09 00:00:00
2011-01-07 00:00:00 |  | FRED | RECEIVED | 250 |  |  |  |  |  |  |  |  |  |  | 2011-01-10 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-01-11 00:00:00
RESULTS (1) |  |  | RESULTS (3)
 |  |  | When PRODUCT=RECEIVED, amount is netted off
 |  |  | where CREDIT=[NAME] sorted on BALANCE descending
DATE | 2011-01-01 00:00:00 |  | DATE | 2011-01-05 00:00:00
WHO | BALANCE |  | WHO | BALANCE
FRED | 100 |  | FRED | 220
 |  |  | MARY | 100
 |  |  | [NAME] | 50
RESULTS (2) |  |  | RESULTS (4)
 |  |  | If [NAME], don't display
DATE | 2011-01-03 00:00:00 |  | DATE | 2011-01-07 00:00:00
WHO | BALANCE |  | WHO | BALANCE
FRED | 350 |  | [NAME] | 50
 |  |  | FRED | -30
Spreadsheet: 751424d1634109229-setting-number-currency-format-by-formula-for-example-text-formula-and-calculation-error-settingnumberformat
Sheet: Sheet1

 | Background: Currency/number format set by selected currency (B8:B12) and number format set accordinly (C8:C12)
 | Values in several sheets and the values should be shown based on selected currency & format
 | How to set format the way numbers can be calculated? Calculatnig cells with TEXT formula causes error
 | Conditional format is one solution, but all cells should be formatted by using format painter, but that applies cell color etc, not just the conditional format by formula to set the number format
 | Currency | CURRENCY FORMATS |  | Select currency |  | A | B | A+B
 | EUR | € # ##0,00 |  | EUR
 | USD | $ # ##0,00 |  | SEK
 | SEK | # ##0,00 |  | GBP
 | DKK | "DKK" # ##0,00
 | GBP | £# ##0,00
Spreadsheet: 99010d1297798616-lookup-in-several-tables-copy-of-test-for-hlookup
Sheet: Sheet1

 | Keyword 1 |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | Keyword 5 |  |  |  | Keyword 6 |  |  |  | [NAME]
 |  | Revenue | Number of Orders |  |  | Revenue | Number of Orders |  |  | Revenue | Number of Orders |  |  | Revenue | Number of Orders |  |  | Revenue | Number of Orders |  |  | Revenue | Number of Orders |  |  | Revenue | Number of Orders
 | Jul | 363 | 16 |  | Jul | 409 | 9 |  | Jul | 216 | 13 |  | Jul | 399 | 18 |  | Jul | 272 | 16 |  | Jul | 446 | 8 |  | Jul | 475 | 15
 | Aug | 265 | 10 |  | Aug | 214 | 12 |  | Aug | 462 | 17 |  | Aug | 253 | 5 |  | Aug | 406 | 16 |  | Aug | 381 | 11 |  | Aug | 311 | 5
 | Sep | 443 | 3 |  | Sep | 221 | 19 |  | Sep | 231 | 17 |  | Sep | 305 | 4 |  | Sep | 345 | 18 |  | Sep | 280 | 19 |  | Sep | 315 | 6
 | Oct | 355 | 5 |  | Oct | 316 | 18 |  | Oct | 215 | 19 |  | Oct | 487 | 4 |  | Oct | 226 | 16 |  | Oct | 426 | 2 |  | Oct | 242 | 9
 | Nov | 357 | 20 |  | Nov | 267 | 15 |  | Nov | 397 | 18 |  | Nov | 392 | 10 |  | Nov | 398 | 8 |  | Nov | 394 | 3 |  | Nov | 354 | 18
 | Dec | 457 | 7 |  | Dec | 475 | 5 |  | Dec | 466 | 10 |  | Dec | 317 | 10 |  | Dec | 294 | 14 |  | Dec | 489 | 15 |  | Dec | 230 | 12
 | Jan | 226 | 18 |  | Jan | 250 | 10 |  | Jan | 258 | 2 |  | Jan | 488 | 12 |  | Jan | 473 | 15 |  | Jan | 275 | 4 |  | Jan | 239 | 14
 |  | Revenue | Aug
 | Keyword1
 | Keyword2
 | Keyword3
 | Keyword4
 | Keyword5
 | Keyword6
 | Keyword7
Spreadsheet: 673118d1587185755-need-help-with-this-formula-to-sum-orders-online-eq-bvj-
Sheet: Sheet1

 |  | Date | customer | invoice | named range: stock
 |  | 2020-01-13 00:00:00 | A | 1001 | 1 - Bar | 2 - Key
 |  | 2020-02-14 00:00:00 | C | 1002 | 2 - Bar | 11 - Key
 |  | 2020-03-17 00:00:00 | A | 1003 | 1 - Tin | 2 - Tin | 3 - Bar | 4 - Tin
 |  | 2020-04-18 00:00:00 | Z | 1004 | 22 - Bar
 |  | 2020-05-20 00:00:00 | W | 1005 | 2 - Key | 3 - Tin
 |  |  |  |  |  |  | - Bar
 |  |  |  |  |  |  | - Key
 |  |  |  |  |  |  | - Tin
Spreadsheet: 141423d1329254382-sorting-based-on-two-columns-sample
Sheet: Copy of date trim for 2000b

START_DATE | END_DATE | TYPES | RECIPIENT | CODE | Pattern | Description
2000-04-27 00:00:00 | 2000-05-13 00:00:00 | PP | VE421 | 1 | ACTIVE | VE421 is part of PP,FF,MM and both dates are in 2000
2000-05-14 00:00:00 | 2000-07-18 00:00:00 | MM | YN599 | 2 | NEED NOT BE CONSIDERED | Because the RECIPIENT is associated with MM and FF.
2000-07-19 00:00:00 | 2000-08-20 00:00:00 | FF | [NAME] | 1 | ACTIVE | [NAME] is part of FF,PP.
2000-08-26 00:00:00 | 2000-10-13 00:00:00 | MM | VE421 | 1 | ACTIVE | VE421 is part of PP,FF,MM and both dates are in 2000
2000-10-14 00:00:00 | 2000-11-16 00:00:00 | FF | YN599 | 2 | NEED NOT BE CONSIDERED | Because the RECIPIENT is associated with MM and FF.
2000-01-01 00:00:00 | 2000-02-03 00:00:00 | PP | WA998 | 1 | ACTIVE | WA998 is part of PP,MM nd both dates are in 2000
2000-12-23 00:00:00 | 2000-04-25 00:00:00 | FF | VE421 | 1 | ACTIVE | VE421 is part of PP,FF,MM and both dates are in 2000
2000-01-27 00:00:00 | 2000-02-24 00:00:00 | MM | WA998 | 1 | ACTIVE | WA998 is part of PP,MM nd both dates are in 2000
2000-04-01 00:00:00 | 2000-05-03 00:00:00 | PP | [NAME] | 2 | ACTIVE | Because   i)YZ681 is part of PP and FF  ii)The Start and End dates are in 2000.
2000-03-16 00:00:00 | 2000-05-18 00:00:00 | PP | WE034 | 2 | ACTIVE | Because both dates are part of year 2000 and WE034 is of Type PP and code is of type '1' or '2'.
2000-05-19 00:00:00 | 2000-08-15 00:00:00 | MM | WX622 | 3 | NEED NOT BE CONSIDERED | Because the RECIPIENT is associated with MM only
2000-04-10 00:00:00 | 2000-05-12 00:00:00 | FF | ZZ072 | 1 | NEED NOT BE CONSIDERED | Because the RECIPIENT is associated with FF only
2001-06-12 00:00:00 | 2001-06-30 00:00:00 | PP | WE034 | 1 | NEED NOT BE CONSIDERED | Because either of the dates end in 2001.
2000-06-12 00:00:00 | 2000-06-30 00:00:00 | PP | WE034 | 3 | NEED NOT BE CONSIDERED | Because the Code is '3'.
PP,MM,FF = VE421(SINCE IT IS COMMON ACROSS ALL THREE) PP,MM=WA998(SINCE IT IS COMMON ACROSS PP,MM) PP,FF=YZ681(SINCE IT IS COMMON ACROSS PP,FF) PP = WE034 (SINCE IT OCCURS FOR PP ALONE).  ALL OTHER RECIPIENTS CAN BE DISCARDED. ALSO SINCE THE RECIPIENT IDs WILL BE UNIQUE,HOW DO I CHECK FOR EVERY SINGLE RECIPIENT IN THIS IF CONDITION? SHOULD I HAVE TO DECLARE IT IN A DIFFERENT WAY?
Spreadsheet: 59128d1259594686-loan-balance-2010
Sheet: Sheet1

Remaing loan |  | 15462 | OR | Loan remaing
Minus |  |  |  | Monthly minus
Plus |  |  |  | Monthly plus
Left |  |  |  | Monthly remaing
Kapitalpension
Spreadsheet: 888950d1739570381-count-for-every-use-with-a-30-second-gap-count-for-every-use-with-a-30-second-gap
Sheet: Sheet1

2025-02-03T10:15:05.149Z |  |  |  |  |  |  | 10:15:05 | Monday |  |  | Tuesday
2025-02-03T10:15:17.141Z |  |  |  |  |  | Monday | 10:15:17 | 00:00:00
2025-02-03T10:15:17.795Z |  |  |  |  |  | Monday | 10:15:19
2025-02-03T10:15:19.953Z |  |  |  |  |  | Monday | 10:15:25
2025-02-03T10:15:25.825Z |  |  |  |  |  | Monday | 10:15:49
2025-02-03T10:15:49.041Z |  |  |  |  |  | Monday | 12:15:20
2025-02-03T10:15:49.133Z |  |  |  |  |  | Monday | 17:11:29
2025-02-03T12:15:20.908Z |  |  |  |  |  | Monday | 17:11:30
2025-02-03T17:11:29.193Z |  |  |  |  |  | Monday | 17:11:57
2025-02-03T17:11:30.601Z |  |  |  |  |  | Monday | 17:12:05
2025-02-03T17:11:57.415Z |  |  |  |  |  | Monday | 17:12:06
2025-02-03T17:12:05.721Z |  |  |  |  |  | Monday | 17:12:09
2025-02-03T17:12:06.228Z |  |  |  |  |  | Monday | 17:12:25
2025-02-03T17:12:09.421Z |  |  |  |  |  | Monday | 17:12:28
2025-02-03T17:12:25.233Z |  |  |  |  |  | Monday | 17:12:31
2025-02-03T17:12:28.844Z |  |  |  |  |  | Monday | 17:12:32
2025-02-03T17:12:31.519Z |  |  |  |  |  | Monday | 17:12:39
2025-02-03T17:12:32.688Z |  |  |  |  |  | Monday | 17:12:46
2025-02-03T17:12:39.253Z |  |  |  |  |  | Monday | 21:46:52
2025-02-03T17:12:46.060Z |  |  |  |  |  | Monday | 21:47:17
2025-02-03T17:12:46.822Z |  |  |  |  |  | Tuesday | 10:49:28
2025-02-03T21:46:52.712Z |  |  |  |  |  | Tuesday | [NAME]
2025-02-03T21:47:17.478Z |  |  |  |  |  | Tuesday | 12:41:25
2025-02-03T21:47:17.500Z |  |  |  |  |  | Tuesday | 12:41:26
2025-02-03T21:47:17.493Z |  |  |  |  |  | Tuesday | 12:41:28
2025-02-03T21:47:17.494Z |  |  |  |  |  | Tuesday | 12:41:34
2025-02-04T10:49:28.888Z |  |  |  |  |  | Tuesday | 12:41:39
2025-02-04T12:40:51.270Z |  |  |  |  |  | Tuesday | 12:41:40
2025-02-04T12:41:25.392Z |  |  |  |  |  | Tuesday | 12:41:41
2025-02-04T12:41:26.022Z |  |  |  |  |  | Tuesday | 12:41:46
2025-02-04T12:41:26.234Z |  |  |  |  |  | Tuesday | 14:48:05
2025-02-04T12:41:28.958Z |  |  |  |  |  | Tuesday | 14:48:07
2025-02-04T12:41:34.906Z |  |  |  |  |  | Tuesday | 14:48:08
2025-02-04T12:41:39.565Z |  |  |  |  |  | Tuesday | 14:48:11
2025-02-04T12:41:40.294Z
2025-02-04T12:41:40.668Z
2025-02-04T12:41:41.135Z
2025-02-04T12:41:46.508Z
2025-02-04T14:48:05.521Z
2025-02-04T14:48:07.463Z
2025-02-04T14:48:07.720Z
2025-02-04T14:48:07.841Z
2025-02-04T14:48:08.112Z
2025-02-04T14:48:11.884Z
2025-02-04T14:48:11.916Z
2025-02-04T14:48:11.928Z
Spreadsheet: 44e91940-9a67-4b31-931f-75e0a9787a96
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Wines offered in GBP per case of 12 bottles, 24 half-bottles or 6 magnums, unless otherwise indicated. 31 October 2014.  Wines lying in bond at London City Bond. E&O.E.  Prices exclude duty and VAT.  For all enquiries, please contact us at [EMAIL]
Region | Producer | Vintage | Wine | Condition | Cs | Bt | GBP Sell | Per | Size | Units | GBP/bt
[NAME] | - | 2001 | Cantegril | - | 14 | 8 | 130 | CS | 75cl | 176 | 10.83
[NAME] | - | 2009 | Carmes de Rieussec  (2nd wine of Rieussec) | - | 2 | - | 150 | CS | 75cl | 24 | 12.5
[NAME] | - | 2010 | Climens | - | 2 | - | 640 | CS | 75cl | 24 | 53.33
[NAME] | - | 2009 | Climens | - | 1 | - | 580 | CS | 37.5cl | 24 | 24.17
[NAME] | - | 2006 | Climens | - | - | 6 | 330 | CS | 75cl | 6 | 27.5
[NAME] | - | 2005 | Climens | - | 4 | - | 550 | CS | 37.5cl | 96 | 22.92
[NAME] | - | 1990 | Climens | - | 1 | 10 | 1100 | CS | 75cl | 22 | 91.67
[NAME] | - | 1989 | Climens | - | 1 | - | 820 | CS | 75cl | 12 | 68.33
[NAME] | - | 1988 | Climens | - | 1 | - | 880 | CS | 75cl | 12 | 73.33
[NAME] | - | 2007 | [NAME] | - | 2 | - | 280 | CS | 75cl | 24 | 23.33
[NAME] | - | 2002 | [NAME] | - | - | 6 | 200 | CS | 75cl | 6 | 16.67
[NAME] | - | 2010 | [NAME] | - | - | 6 | 275 | CS | 75cl | 6 | 22.92
[NAME] | - | 2009 | [NAME] | - | 3 | - | 300 | CS | 37.5cl | 72 | 12.5
[NAME] | - | 2009 | [NAME] | - | 2 | - | 290 | CS | 75cl | 24 | 24.17
[NAME] | - | 2010 | [NAME] | - | 6 | - | 220 | CS | 75cl | 72 | 18.33
[NAME] | - | 2009 | [NAME] | - | 3 | - | 220 | CS | 37.5cl | 72 | 9.17
[NAME] | - | 2007 | Malle | - | 4 | - | 230 | CS | 75cl | 48 | 19.17
[NAME] | - | 2009 | [NAME] | - | 2 | - | 220 | CS | 75cl | 24 | 18.33
[NAME] | - | 2007 | Rieussec | - | 4 | - | 320 | CS | 75cl | 48 | 26.67
[NAME] | - | 2006 | Rieussec | - | 27 | 1 | 310 | CS | 75cl | 325 | 25.83
[NAME] | - | 2007 | Suduiraut | - | 4 | - | 340 | CS | 75cl | 48 | 28.33
[NAME] | - | 2005 | Tour Blanche | - | 4 | - | 320 | CS | 37.5cl | 96 | 13.33
[NAME] | - | 2011 | Yquem | - | - | 6 | 2600 | CS | 75cl | 6 | 216.67
[NAME] | - | 2011 | Yquem | - | - | 12 | 2600 | CS | 37.5cl | 12 | 108.33
[NAME] | - | 2006 | Yquem | - | 4 | - | 1940 | CS | 75cl | 48 | 161.67
[NAME] | - | 2004 | Yquem | - | - | 6 | 1400 | CS | 75cl | 6 | 116.67
[NAME] | - | 2003 | Yquem | - | 1 | - | 1500 | CS | 37.5cl | 24 | 62.5
[NAME] | - | 2001 | Yquem | - | - | 12 | 4600 | CS | 37.5cl | 12 | 191.67
[NAME] | - | 1996 | Yquem | - | 1 | 12 | 1350 | CS | 37.5cl | 36 | 56.25
[NAME] | - | 1995 | Yquem | - | 4 | - | 1480 | CS | 75cl | 48 | 123.33
[NAME] | - | 1988 | Yquem | - | 1 | - | 2970 | CS | 75cl | 12 | 247.5