tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 705840d1606326767-formula-to-search-across-three-values-to-populate-a-result-test-data
Sheet: Table 1

ACCTID | ACCTNAME | BILLINGCYCLE | TERMINALS | TOTALCHARGES
100000914 | Client A | 2020-Nov | 1128131 | 625119.76
100000954 | [NAME] | 2020-Nov | 4347 | 28336.1
100000957 | Client C | 2020-Nov | 0 | 0
100000973 | Client Z | 2020-Nov | 22676 | 52242.15
Spreadsheet: 487878d1478287615-formula-formula
Sheet: Sheet1

 |  |  |  |  | (1)-,+(should be positive taking  )
2247 | 2247 |  |  |  | (2)+,-(should be negative taking )
 | -25.08 | don’t consider this |  |  | (3)+,+(positive is second is larger and negative if 1 is larger)
 |  |  |  |  | (4)-,-(negative is second is larger and positive if 1 is larger)
1479 | 1479 |  |  |  | (5)0,-(negative)
 |  |  |  |  | (6)0,+(positive)
 | -34.18 | This is okay |  |  | (7)-,0(positive)
2610 | 2610 |  |  |  | (8)+,0(negative)
 | 76.47 | This is okay
4251 | 4251
 | 62.87 | This is okay
10903 | 10903
 | 156.48 | this should come ~256% |  |  | The blank space in between is needed as other values come there ehich has not to be included in this formula
 |  |  |  |  | that same formula should work giving correct results on A5,A9,A12,A15,A18 AND d5, d9, d12, d15, d18
-2250 | -2250
 | -100 | this should come ~-120, as 10903>0 is -100 and  then 0 to -2250, is -21, so ~-121%
875 | 875
 | 38.89 | this should come 138%
-1000 | -1000
 | -214.29 | this is okay
-4250 | -4250
 | -325 | this should come -325
52250 | 52250
 | 1229.41 | this should come 1229.41
Spreadsheet: sally_beck__33976__Weekly Operating Report 3-28
Sheet: EIM New Deals

New Deals for | JANUARY |  |  |  |  |  |  |  | FEBRUARY |  |  |  |  |  |  |  |  |  | [NAME]
 | Week Ending 4 |  | Week Ending 11 |  | Week Ending 18 |  | Week Ending 25 |  | Week Ending 1 |  | Week Ending 8 |  | Week Ending 16 |  | Week Ending 22 |  | Week Ending 28 |  | Week Ending 7 |  | Week Ending 14 |  | Week Ending 21 |  | Week Ending 28
 | EOL | Non-EOL | EOL | Non-EOL | EOL | Non-EOL | EOL | Non-EOL | EOL | Non-EOL | EOL | Non-EOL | EOL | Non-EOL | EOL | Non-EOL | EOL | Non-EOL | EOL | Non-EOL | EOL | Non-EOL | EOL | Non-EOL | EOL | Non-EOL
Financial
ENA
Gas (Calgary)
Gas (Houston)
Power (Houston)
Power (Calgary)
EIM
Lumber | 0 | 23 | 0 | 7 | 0 | 10 | 0 | 19 | 0 | 19 | 0 | 24 | 0 | 8 | 0 | 9 | 0 | 14 | 0 | 22 | 0 | 28 | 0 | 27 | 0 | 13
Newsprint | 0 | 2 | 2 | 0 | 0 | 2 | 0 | 2 | 0 | 0 | 0 | 10 | 0 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 5 | 0
Pulp (recycled paper) | 0 | 1 | 0 | 4 | 0 | 12 | 0 | 10 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 11 | 0 | 17 | 0 | 7 | 0 | 3 | 2 | 1
Steel | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
EGM
IR/FX
Weather
Liquids
Emissions
Physical
ENA
Gas (Houston)
Gas (Calgary)
Power (Houston)
Power (Calgary)
EIM
Lumber | 1 | 62 | 12 | 107 | 10 | 83 | 2 | 103 | 5 | 62 | 7 | 38 | 4 | 26 | 2 | 30 | 5 | 50 | 7 | 55 | 7 | 45 | 5 | 62 | 9 | 101
Newsprint | 0 | 3 | 0 | 15 | 1 | 6 | 0 | 22 | 0 | 4 | 0 | 2 | 0 | 18 | 0 | 17 | 0 | 18 | 0 | 20 | 2 | 43 | 1 | 24 | 5 | 9
Pulp (recycled paper) | 4 | 1 | 3 | 10 | 0 | 12 | 0 | 9 | 2 | 23 | 4 | 13 | 3 | 12 | 3 | 18 | 5 | 41 | 4 | 11 | 9 | 10 | 2 | 35 | 0 | 29
Steel | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 2 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 7
EGM
Liquids
Coal
Spreadsheet: daren_farmer__5729__HPLN0220
Sheet: Sheet1

HPLN0220.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  LIZ BELLAMY / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC)
SUBJECT:  TXU FUELS NOMINATION - February 20, 2001
 |  |  |  |  |  | **Tuesday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2001-02-20 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
 |  | Firm Summary
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 172909fb-bf08-42ea-9c8a-c275f0289967
Sheet: Acad Level - Fall Grad

Return to Contents
Academic Level - Fall Graduate
 |  |  |  | UH | UH COMMUNITY COLLEGES
 |  | UH | UH | WEST
 | TOTAL | MĀNOA | HILO | O‘AHU | SUBTOTAL | Hawaii | Honolulu | Kapi‘olani | Kaua‘i | Leeward | Maui | [NAME]
1955 | 736 | 736 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1956 | 695 | 695 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1957 | 835 | 835 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1958 | 946 | 946 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1959 | 1216 | 1216 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1960 | 1314 | 1314 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1961 | 1567 | 1567 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1962 | 1771 | 1771 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1963 | 2025 | 2025 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1964 | 2260 | 2260 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1965 | 2762 | 2762 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1966 | 3352 | 3352 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1967 | 3588 | 3588 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1968 | 3843 | 3843 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1969 | 4293 | 4293 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1970 | 4696 | 4696 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1971 | 5124 | 5124 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1972 | 4956 | 4956 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1973 | 5017 | 5017 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1974 | 5010 | 5010 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1975 | 5209 | 5209 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1976 | 5630 | 5617 |  | 13 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1977 | 5571 | 5554 |  | 17 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1978 | 5765 | 5758 |  | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1979 | 5716 | 5630 | 83 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1980 | 5749 | 5599 | 148 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1981 | 5904 | 5704 | 190 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1982 | 5968 | 5761 | 189 | 18 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1983 | 5772 | 5590 | 174 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1984 | 5518 | 5353 | 156 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1985 | 5641 | 5471 | 161 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1986 | 5761 | 5564 | 193 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1987 | 5691 | 5457 | 228 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1988 | 5839 | 5543 | 290 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1989 | 6040 | 5741 | 289 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1990 | 6336 | 6038 | 284 | 14 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1991 | 6636 | 6315 | 309 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1992 | 6825 | 6544 | 273 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1993 | 6929 | 6637 | 289 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1994 | 6993 | 6735 | 248 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1995 | 6580 | 6389 | 179 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Note: Data may not match [NAME] reports due to changes in enrollment counting methodology.
Spreadsheet: 771975d1646937052-nested-if-and-vlookup-statement-if-blank-vlookup
Sheet: Sheet1

 | Candidate Id | Job Reference No | Candidate First Name | Candidate Last Name | [NAME] | Job Region | Job Service Location | [NAME] | Rejection Reason | Rejection After App Date |  | Job Region | Rejection Reason
 | 12345 | 6147 | First Name | Surname | Person | North | A Place | 653681 |  | 07/03/2022 |  | North |  |  |  | Code | Reason
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 653681 | CV/App Form Not Suitable
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 653592 | Failed Telephone Interview
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 670722 | Part of Warm List
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 689240 | [NAME] Issue
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 653588 | DBS/PVG Failed
Spreadsheet: 89ea18b3-233b-46ca-a411-4103140586ab
Sheet: Sheet1

Unnamed: 0 | Inserire le risposte in questa colonna
Dati anagrafici  (Dati obbligatori per tutti)
Nome
Cognome
Data di nascita
Indirizzo e-mail
Cellulare
Iscrizione (Dati obbligatori per tutti)
Desidero iscrivermi [NAME] (clicca sulla cella e scegli sì/no dal menu a tendina)
Desidero iscrivermi [NAME] (clicca sulla cella e scegli sì/no dal menu a tendina)
Desidero iscrivermi a entrambi (clicca sulla cella e scegli sì/no dal menu a tendina)
Solo per tesserati FIT, inserire:
Numero tessera FIT
[NAME]
Classifica FIT
Solo per amatori
Livello di gioco (clicca sulla cella, apri [NAME] a tendina e [NAME] [NAME])
[NAME] regolamento sono reperibili sul sito dell'Ordine all'indirizzo | http://www.odcec.mi.it/allegati/attivita/tennis09.pdf
Spreadsheet: 752572d1634835631-complex-deferred-revenue-schedule-help-deferred-revenue-schedule-mandalynnef-
Sheet: Model

 |  | Q1 20 | Q2 20 | Q3 20 | Q4 20 | Q1 21 | Q2 21 | Q3 21 | Q4 21 |  | 2020 | 2021 | Y/Y % Growth |  | Q2 | Q3 | Q4
CURRENT TRACK
 | Subscription Bookings
 | Overages
 | 5% AutoRenew Lift for 2021
 | Total Bookings
 | Recurring Subscription Revenues |  |  |  |  |  |  |  |  |  |  |  |  |  | Samsung | Top Golf | Reeds
 | Non-recurring revenues |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Foundation Health
 | Total Revenues
 | Ending MRR
 | Ending ARR
 | ARR Growth
 | Total Revenue Growth
 | Bookings Growth Q/Q
 | Bookings Growth Q/Q Prior Year
REVENUES AND BOOKINGS SUMMARY
 | Recurring Subscription Revenues
 | Non-recurring revenues
 | Total Revenues
 | Ending MRR
 | Ending ARR
 | Bookings
 | 2021 New Bookings |  |  |  |  |  |  |  | 435476
 | ARR Growth
 | Total Revenue Growth
 | Bookings Growth Q/Q
 | Bookings Growth Q/Q Prior Year
 | Non-recurring % of Sales | 0.019
 |  |  |  |  | net new | 30000 | 70000 | 100000 | 47000
 |  |  |  |  | net new | 58000 | 46000 | 62000 | 56000
 |  |  |  |  |  | 100000 | 40000 | 25000 | 132000
Spreadsheet: 685837d1594220187-highlight-when-a-patient-needs-to-be-transferred-to-another-hospital-pq-simplified-workbook-aligw
Sheet: Sheet1

 | Primary Treatment | Months |  |  |  | Primary Treatment | Treatment Start Date
 | Monitor | 1 |  |  |  | Surgery | 2020-03-03 00:00:00
 | BSC | 1 |  |  |  | Radiotherapy | 2020-07-05 00:00:00
 | Transfer Care | 1 |  |  |  | Radiotherapy | 2020-02-24 00:00:00
 | Surgery | 2 |  |  |  | Surgery | 2020-05-05 00:00:00
 | Palliative Radiotherapy | 4 |  |  |  | Monitor
 | Palliative Chemotherapy | 4 |  |  |  | BSC
 | Radiotherapy | 6 |  |  |  | Surgery
 | Chemo/Radiotherapy | 6 |  |  |  | Chemo/Radiotherapy
 | Chemotherapy | 6 |  |  |  | Radiotherapy
 |  |  |  |  |  | Transfer Care
 |  |  |  |  |  | Surgery
 |  |  |  |  |  | Chemo/Radiotherapy
Spreadsheet: 834042d1687412306-problem-to-find-the-changing-numbers-for-both-genders-by-setting-a-target-for-2025-diversity-calculator
Sheet: Sheet1

Problem- To find the changing numbers for both genders in the next 3 years (till 2025) at each level (E3, E4, and L5) setting a target for 2025 end as 35% for females across all levels (keeping the size of the target group same and not considering growth)
 | Gender | Male | Female | Total |  | % Male | %Female
Year
2023
E3 |  | 6 | 2
E4 |  | 30 | 6
L5 |  | 72 | 21
Total
2024
E3
E4
L5
Total
2025
E3 |  |  |  |  |  |  | 0.35
E4 |  |  |  |  |  |  | 0.35
L5 |  |  |  |  |  |  | 0.35
Total
Spreadsheet: 141002d1329018533-sum-values-from-one-collumn-according-to-values-from-another-one-excel-problem-2
Sheet: Fixirano

 | 3
Day | Daily Profit | Stake | Sum of all lost stakes | Picks | Play | Odds | Win/Loss
1 | 3 |  |  | Team1-Team2 | Team2 -4 | 1.91 | 1
 |  |  |  | Team3-Team4 | Team3 -2 | 1.91 | 0
 |  |  |  | (date) | ODD:
 | 3 |  |  | team a - team b | xx | 1.91 | 0
 |  |  |  | team c - team d | yy | 1.91 | 1
 |  |  |  | (date) | ODD:
 | 3 |  |  | team 5 - team 6 | aa | 1.91 | 1
 |  |  |  | team 7 - team 8 | bb | 1.91 | 1
 |  |  |  | (date) | ODD:
 | 3 |  |  | team 5 - team 6 | aa | 1.91 | 1
 |  |  |  | team 7 - team 8 | bb | 1.91 | 1
 |  |  |  | (date) | ODD:
Spreadsheet: 469966d1468267703-make-line-chart-where-y-axis-value-affected-by-multiple-variables-fun
Sheet: Sheet1

Y | X | C | D
 | 1 | 1 | 1
 | 2 | 1 | 1
 | 3 | 1 | 1
 | 4 | 2 | 1
 | 5 | 2 | 1
 | 6 | 2 | 1
 | 7 | 3 | 1
 | 8 | 3 | 1
 | 9 | 3 | 1
 | 1 | 4 | 2
 | 2 | 4 | 2
 | 3 | 4 | 2
 | 4 | 5 | 2
 | 5 | 5 | 2
 | 6 | 5 | 2
 | 7 | 6 | 2
 | 8 | 6 | 2
 | 9 | 6 | 2
 | 1 | 7 | 3
 | 2 | 7 | 3
 | 3 | 7 | 3
 | 4 | 8 | 3
 | 5 | 8 | 3
 | 6 | 8 | 3
 | 7 | 9 | 3
 | 8 | 9 | 3
 | 9 | 9 | 3
 | 1 | 1 | 4
 | 2 | 1 | 4
 | 3 | 1 | 4
 | 4 | 2 | 4
 | 5 | 2 | 4
 | 6 | 2 | 4
 | 7 | 3 | 4
 | 8 | 3 | 4
 | 9 | 3 | 4
 | 1 | 4 | 5
 | 2 | 4 | 5
 | 3 | 4 | 5
 | 4 | 5 | 5
 | 5 | 5 | 5
 | 6 | 5 | 5
 | 7 | 6 | 5
 | 8 | 6 | 5
 | 9 | 6 | 5
 | 1 | 7 | 6
 | 2 | 7 | 6
 | 3 | 7 | 6
 | 4 | 8 | 6
 | 5 | 8 | 6
 | 6 | 8 | 6
 | 7 | 9 | 6
 | 8 | 9 | 6
 | 9 | 9 | 6
 | 1 | 1 | 7
 | 2 | 1 | 7
 | 3 | 1 | 7
 | 4 | 2 | 7
 | 5 | 2 | 7
 | 6 | 2 | 7
 | 7 | 3 | 7
 | 8 | 3 | 7
 | 9 | 3 | 7
 | 1 | 4 | 8
 | 2 | 4 | 8
 | 3 | 4 | 8
 | 4 | 5 | 8
 | 5 | 5 | 8
 | 6 | 5 | 8
 | 7 | 6 | 8
 | 8 | 6 | 8
 | 9 | 6 | 8
 | 1 | 7 | 9
 | 2 | 7 | 9
 | 3 | 7 | 9
 | 4 | 8 | 9
 | 5 | 8 | 9
 | 6 | 8 | 9
 | 7 | 9 | 9
 | 8 | 9 | 9
 | 9 | 9 | 9
Spreadsheet: 190907d1351847269-inventory-run-out-calculator-need-help-with-final-step-run-out-calculation_v1
Sheet: Sheet1

Supplier Number | [NAME] |  | Part Number | Part Description
1000 | ABC Company |  | 1234567890 | TMNT Legos
Supplier |  |  |  | Customer Demand
Input | 250 |  |  | Start Date and Time | 2012-10-31 08:00:00
Supplier OEE% | 0.8 |  |  | Running Hours | 24
Throughput | 190
Run-Out Time | 2012-11-10 01:42:00
Date | [NAME] (-) | Use per hour | [NAME] (+) | Difference | On-Hand
2012-10-30 08:00:00 |  |  |  |  | 1000
2012-10-31 08:00:00 | 368 | 15.33333333333333 | 190 | -178 | 822
2012-11-01 08:00:00 | 383 | 15.95833333333333 | 190 | -193 | 629
2012-11-02 08:00:00 | 374 | 15.58333333333333 | 190 | -184 | 445
2012-11-03 08:00:00 | 145 | 6.041666666666667 | 190 | 45 | 490
2012-11-04 08:00:00 | 0 | 0 | 190 | 190 | 680
2012-11-05 08:00:00 | 323 | 13.45833333333333 | 190 | -133 | 547
2012-11-06 08:00:00 | 360 | 15 | 190 | -170 | 377
2012-11-07 08:00:00 | 345 | 14.375 | 190 | -155 | 222
2012-11-08 08:00:00 | 335 | 13.95833333333333 | 190 | -145 | 77
2012-11-09 08:00:00 | 362 | 15.08333333333333 | 190 | -172 | -95 | 2012-11-09 08:00:00 | 17.70165745856353
2012-11-10 08:00:00 | 153 | 6.375 | 190 | 37 | -58 | 2012-11-10 08:00:00
2012-11-11 08:00:00 | 0 | 0 | 190 | 190 | 132
2012-11-12 08:00:00 | 260 | 10.83333333333333 | 190 | -70 | 62
2012-11-13 08:00:00 | 335 | 13.95833333333333 | 190 | -145 | -83 | 2012-11-13 08:00:00
2012-11-14 08:00:00 | 269 | 11.20833333333333 | 190 | -79 | -162 | 2012-11-14 08:00:00
2012-11-15 08:00:00 | 308 | 12.83333333333333 | 190 | -118 | -280 | 2012-11-15 08:00:00
2012-11-16 08:00:00 | 343 | 14.29166666666667 | 190 | -153 | -433 | 2012-11-16 08:00:00
2012-11-17 08:00:00 | 146 | 6.083333333333333 | 190 | 44 | -389 | 2012-11-17 08:00:00
2012-11-18 08:00:00 | 0 | 0 | 190 | 190 | -199 | 2012-11-18 08:00:00
2012-11-19 08:00:00 | 245 | 10.20833333333333 | 190 | -55 | -254 | 2012-11-19 08:00:00
2012-11-20 08:00:00 | 320 | 13.33333333333333 | 190 | -130 | -384 | 2012-11-20 08:00:00
2012-11-21 08:00:00 | 380 | 15.83333333333333 | 190 | -190 | -574 | 2012-11-21 08:00:00
2012-11-22 08:00:00 | 155 | 6.458333333333333 | 190 | 35 | -539 | 2012-11-22 08:00:00
2012-11-23 08:00:00 | 0 | 0 | 190 | 190 | -349 | 2012-11-23 08:00:00
2012-11-24 08:00:00 | 0 | 0 | 190 | 190 | -159 | 2012-11-24 08:00:00
2012-11-25 08:00:00 | 0 | 0 | 190 | 190 | 31
2012-11-26 08:00:00 | 283 | 11.79166666666667 | 190 | -93 | -62 | 2012-11-26 08:00:00
2012-11-27 08:00:00 | 372 | 15.5 | 190 | -182 | -244 | 2012-11-27 08:00:00
2012-11-28 08:00:00 | 385 | 16.04166666666667 | 190 | -195 | -439 | 2012-11-28 08:00:00
2012-11-29 08:00:00 | 390 | 16.25 | 190 | -200 | -639 | 2012-11-29 08:00:00
2012-11-30 08:00:00 | 387 | 16.125 | 190 | -197 | -836 | 2012-11-30 08:00:00
2012-12-01 08:00:00 | 409 | 17.04166666666667 | 190 | -219 | -1055 | 2012-12-01 08:00:00
Spreadsheet: 884635d1733861995-trying-to-put-a-i-in-a-cell-relative-to-a-number-in-cell-f6-handicap-2
Sheet: Sheet1

Please sign |  |  | TUESDAY POST OFFICE GOLF LEAGUE OFFICIAL SCORE CARD
 |  | TEE-OFF ORDER | 1 | DATE | HANDICAP | 7 | 3 | 8 | 1 | 5 | 6 | 4 | 2 | 9
 |  | TEAM # |  |  | PAR | 4 | 4 | 4 | 3 | 5 | 3 | 4 | 4 | 4
 |  | VS |  | 2025-05-02 00:00:00 | YARDS | 330/285 | 338/269 | 320/320 | 195/161 | 370/361 | 130/118 | 317/279 | 350/292 | 269/269 | 2629/2354
 |  | TEAM # |  |  | HOLE # | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | TOTAL
 |  |  |  | Handicap |  |  |  |  | =if(F6=1,"",if(2,"",if(3"",if(4"",if(5"",if(6"",if(7,I,if(8,I,if(9,I,if(10,I,if(11,I,if(12,I,if(13,II,if(14,II,if(15,II,if(16,II,if(17,II,if(18,II,if(19,II,if(20,II,if(21,II,if(22,II,if(23,II,if(24,II,if(25,III,if(26III,if(27,III,"")))))))))))))))))))))))))
 |  | SCORE MINUS HANDICAP
 |  |  |  | Handicap |  |  |  |  | I
SCORE KEEPER SIGNATURE | OPPONENTS ATTEST SIGNATURE | SCORE MINUS HANDICAP
 |  |  | POINTS WON
 |  | PLAY FAST |  | PACE OF PLAY |  | :13 | :26 | :40 | :53 | 1:10 | 1:20 | 1:34 | 1:48 | 2:06
 |  |  |  | Handicap
 |  | SCORE MINUS HANDICAP
 |  |  |  | Handicap
 |  | SCORE MINUS HANDICAP
 |  |  | POINTS WON
 |  | May move ball only 6 inches, If lost or nonplayable, drop one club length from where lost  or where unplayable lie was. 1 stroke
Spreadsheet: 289347d1389534875-popup-to-show-and-select-from-drop-down-list-to-excel-forum-opoup-menu-1201
Sheet: result

to show pop up and select from list(wsheet prt  a1:a6000)
to show pop up and select from list(wsheet pdt  a1:a6000)
to show pop up and select from list(wsheet pdt  a1:a6000)
to show pop up and select from list(wsheet pdt  a1:a6000)
to show pop up and select from list(wsheet pdt  a1:a6000)
to show pop up and select from list(wsheet pdt  a1:a6000)
to show pop up and select from list(wsheet pdt  a1:a6000)
to show pop up and select from list(wsheet pdt  a1:a6000)
to show pop up and select from list(wsheet pdt  a1:a6000)
to show pop up and select from list(wsheet pdt  a1:a6000)
to show pop up and select from list(wsheet pdt  a1:a6000)
to show pop up and select from list(wsheet pdt  a1:a6000)
to show pop up and select from list(wsheet pdt  a1:a6000)
to show pop up and select from list(wsheet pdt  a1:a6000)
to show pop up and select from list(wsheet pdt  a1:a6000)
to show pop up and select from list(wsheet pdt  a1:a6000)
to show pop up and select from list(wsheet pdt  a1:a6000)
to show pop up and select from list(wsheet pdt  a1:a6000)
to show pop up and select from list(wsheet pdt  a1:a6000)
to show pop up and select from list(wsheet pdt  a1:a6000)
to show pop up and select from list(wsheet pdt  a1:a6000)
to show pop up and select from list(wsheet pdt  a1:a6000)
to show pop up and select from list(wsheet pdt  a1:a6000)
to show pop up and select from list(wsheet pdt  a1:a6000)
to show pop up and select from list(wsheet pdt  a1:a6000)
to show pop up and select from list(wsheet pdt  a1:a6000)
to show pop up and select from list(wsheet pdt  a1:a6000)
to show pop up and select from list(wsheet pdt  a1:a6000)
to show pop up and select from list(wsheet pdt  a1:a6000)
to show pop up and select from list(wsheet pdt  a1:a6000)
to show pop up and select from list(wsheet pdt  a1:a6000)
to show pop up and select from list(wsheet pdt  a1:a6000)
to show pop up and select from list(wsheet pdt  a1:a6000)
to show pop up and select from list(wsheet pdt  a1:a6000)
to show pop up and select from list(wsheet pdt  a1:a6000)
to show pop up and select from list(wsheet pdt  a1:a6000)
to show pop up and select from list(wsheet pdt  a1:a6000)
to show pop up and select from list(wsheet pdt  a1:a6000)
to show pop up and select from list(wsheet pdt  a1:a6000)
to show pop up and select from list(wsheet pdt  a1:a6000)
to show pop up and select from list(wsheet pdt  a1:a6000)
to show pop up and select from list(wsheet pdt  a1:a6000)
to show pop up and select from list(wsheet pdt  a1:a6000)
to show pop up and select from list(wsheet pdt  a1:a6000)
to show pop up and select from list(wsheet pdt  a1:a6000)
to show pop up and select from list(wsheet pdt  a1:a6000)
to show pop up and select from list(wsheet pdt  a1:a6000)
to show pop up and select from list(wsheet pdt  a1:a6000)
to show pop up and select from list(wsheet pdt  a1:a6000)
Spreadsheet: af612a8c-3174-4256-8c6c-e52b29c6c243
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
4968 | 29667 | Ilaria | Zavanone | ITA | 357 | 00:23:04 | 00:01:56 | 01:58:56 | 00:01:06 | 00:48:38 | 1 | 03:13:37
Spreadsheet: 679830d1590651270-sum-vlookup-order-form-aligw
Sheet: ORDER SHEET

 |  | 1 MAY |  | 2 MAY |  | 3 MAY
ORDER |  | [NAME] | JHON | BILLY | JOSH | JHON | BILLY | JOSH
No | ITEMS | Q | Q | Q | Q | Q | Q | Q
1 | CAR | 1 |  |  |  |  | 5
2 | PLANE |  |  |  |  | 1 |  | 1
3 | HELICOPTER |  | 1 | 2 |  | 3
4 | JET |  |  |  | 4
 | TOTAL
Spreadsheet: 713303d1610641156-display-data-from-the-first-column-for-those-who-dont-have-n-a-in-the-second-column-sample
Sheet: Sheet1

User full name | Number of seen books | Completed? | Those who completed - how many books?
Filipe Torrado | 0
Anke Bellens | 4
[NAME] | 4
[NAME] | 0
Quinten Croes | 4
Esteban [NAME] | 0
Akash Shah | 4
[NAME] | 1
[NAME] | 4
[NAME] | 0
[NAME] | 1
Spreadsheet: 648995d1573374808-how-to-find-nearest-value-in-excel-nearest-point
Sheet: Sheet1

NEW DATA |  |  |  | NEAREST POINT |  |  |  |  |  | OLD DATA
GULLY_NO | FM_EASTING | FM_NORTHING |  | GULLY_NO | FM_EASTING | FM_NORTHING |  |  |  | GULLY_NO | Easting (X) | Northing (Y)
55/SA/33/G1 | 220738.544 | 387238.219 |  | 55/BD/18 | 220738.59 | 387237.87 |  |  |  | 55/BD/1 | 222529.349 | 387863.667
55/WB/SA1A/G2 | 227316.391 | 391205.881 |  | 55/BD/19 | 227316.454 | 391205.907 |  |  |  | 55/BD/2 | 222460.898 | 387652.85
ASF/5/1/1/G1A | 221820.297 | 387640.736 |  |  |  |  |  |  |  | 55/BD/3 | 221852.452 | 387640.789
ASF/5/1/1/G2 | 221852.384 | 387640.742 |  |  |  |  |  |  |  | 55/BD/4 | 221820.068 | 387628.96
ASF/5/1/1/G5 | 221844.918 | 387628.963 |  |  |  |  |  |  |  | 55/BD/5 | 221844.784 | 387628.926
ASF/5/1/1/G6 | 221821.016 | 387628.803 |  |  |  |  |  |  |  | 55/[NAME] | 222522.967 | 387868.383
ASF/5/1/1/G6A | 221820.414 | 387628.816 |  |  |  |  |  |  |  | 55/BD/7 | 222511.128 | 387856.551
ASF/5/1/G3 | 221965.634 | 387629.571 |  |  |  |  |  |  |  | 55/BD/8 | 222454.09 | 387842.85
ASF/5/1/G4 | 221915.21 | 387629.225 |  |  |  |  |  |  |  | 55/BD/9 | 222416.716 | 387839.652
ASF/5/10/G1 | 222445.005 | 387677.73 |  |  |  |  |  |  |  | 55/BD/10 | 221965.511 | 387629.604
ASF/5/10/G2 | 222460.823 | 387652.888 |  |  |  |  |  |  |  | 55/BD/11 | 222503.601 | 387863.156
ASF/5/13/1/G1 | 222459.856 | 387851.735 |  |  |  |  |  |  |  | 55/BD/12 | 221915.022 | 387629.329
ASF/5/13/1/G2 | 222454.046 | 387842.838 |  |  |  |  |  |  |  | 55/BD/13 | 222459.825 | 387851.675
ASF/5/13/1/G3 | 222436.785 | 387838.095 |  |  |  |  |  |  |  | 55/BD/14 | 221820.132 | 387640.596
ASF/5/13/1/G4 | 222416.509 | 387839.669 |  |  |  |  |  |  |  | 55/BD/15 | 221820.938 | 387628.995
[NAME] | 222523.037 | 387868.282 |  |  |  |  |  |  |  | 55/BD/16 | 222445.054 | 387677.866
ASF/5/13/2/G2 | 222529.394 | 387863.609 |  |  |  |  |  |  |  | 55/BD/17 | 222436.88 | 387838.154
ASF/5/13/2/G3 | 222511.09 | 387856.545 |  |  |  |  |  |  |  | 55/BD/18 | 220738.59 | 387237.87
ASF/5/13/2/G4 | 222503.597 | 387863.268 |  |  |  |  |  |  |  | 55/BD/19 | 227316.454 | 391205.907