tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 884587d1733823466-trying-to-combine-the-if-function-with-index-function-and-failing-project-dashboard-etaf
Sheet: Level 2

 | Project Name » | THERMAL OIL FOR THE COAL ELIMINATION-5 X12GCAL TOH |  |  | Overall  Progress » | pie chart |  |  | Duration »
 | Project Manager » | Mr. [NAME] |  |  |  |  |  |  | Project Start » | 2024-09-11 00:00:00
 | [NAME] » | As part of their strategy to decarbonize the facility, achieve sustainable growth and satisfy the needs of customers in target export markets, Style Textile is replacing 3 Nos. of their existing Coal Based Thermal Oil Heaters (TOH) with 5 Nos. Multi-Fuel Biomass Fired TOH of 60GCal/hr, each with capacity of  12GCal/hr. |  |  |  |  |  |  | Project End » | 2026-03-30 00:00:00
 |  |  |  |  |  |  |  |  | Man Days » | 404
Task Manager
 | Task Title | AssignedTo | Start | End | Actual  Progress | Status |  | Planned Progress
 |  |  |  |  |  |  |  |  |  | x
 | S-1st set of Civil weight data, Flooring, equipment foundations design/Drawing Submission |  | 2024-10-04 00:00:00 | 2024-10-21 00:00:00 | 1
Spreadsheet: louise_kitchen__22552__Hot List Update 07-11-01
Sheet: Offshore -50

Deal Description Sheet - 7/9/01
Production Offshore
Project Name | Lead Originator | Counterparty | Description | Potential Valuation | Last Customer Contact | Probability | Expected Closing (Month/Year) | Weekly Updates / Comments
[NAME] | [NAME] | [NAME] | Volumetric Production payment on McMoRan Offshore Reserves. | 500000 | 2001-06-26 00:00:00 | 0.1 | 2001-08-01 00:00:00 | Working with [NAME] and KimYates of Enron Energy Capital Resources (ECR) on a VPP proposal.  ECR recently provided [NAME] Treasurer, [NAME], a pitchbook outlining a high level proposal.  ECR is in the process of setting up a meeting with [NAME] to discuss further.
Shallow-Water | [NAME] | VanKirk & Riles | Shallow-water used platform and gathering line sale & lease/financing business with small to mid-sized E&P independents. | 500000 | 2001-06-26 00:00:00 | 0.1 | 2001-09-01 00:00:00 | Working on HI 52 and WC 43 proposal for Gryphon Exploration.  [NAME] is upbeat on the HI 52 reserves.  [NAME] and [NAME] are deal originators.  [NAME] is structuring and pricing the deal.  Non-binding proposal to go out in the next week.
Spreadsheet: phillip_m_love__30653__9903_OA
Sheet: TX-HPL-FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  HPL
 |  |  | NGP&L |  | CPR Adjustments |  | 3rd Day CPR |  | [NAME] |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron | 16975874 | 27418103.07
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | -2984498 | -5320357.08
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 120000
 | Total Sales: |  | 13991376 | 22217745.99
 | Purchases:
6 |  | 3rd Party / Inter Enron | -12001040 | -20492160.99870001
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | 2984498 | 5320355.44
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 0 | 0.5399999999999636
 | Total Purchases: |  | -9016542 | -15171805.01870001
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales | 2385827 | 4842147.12
12 |  | Purchases | -3569711 | -5891806.050000004
 | Total Intra CTS Sales / Purchases |  | -1183884 | -1049658.93
 | Imbalances:
13 |  | In Kind | 0 | 0
14 |  | Cash Out | -3790950 | -6671178.306412736
15 |  | Cash In | 0 | 0
16 |  | Synthetic Storage | 0 | 0
 | Total Imbalances: |  | -3790950 | -6671178.306412736
 | Storage:
17 |  | Injection (Sales to Stg) | 0 | -0.25
18 |  | W/D (Purchase from Stg) | 0 | 0
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | 0 | 0
 | Total Storage: |  | 0 | -0.25
20 | Linepack: |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
22 | UA4: |  | 0 | 0
23 | Fuel: |  | 668 | 25000
 | Transport Expense:
24 |  | Commodity | 0 | 0
25 |  | Demand | 0 | 0
 | Total Transport Expense: |  | 0 | 0
 | Transport Revenue:
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | 0
 | Total Transport Revenue: |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense | 0 | 0
29 |  | Transport Revenue | 0 | 0
 | Total Intra CTS Transport |  | 0 | 0
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance | 0 | 0
31 |  | Prior Month Book Balance | 0 | 0
 |  | Total MTM Income | 0 | 0
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | 0
34 |  | Originations | 0 | 0
35 |  | Broker Fees | 0 | 0
36 |  | Asset Group Demand Charges | 0 | 0
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 0
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | 0
 |  | TOTAL
Spreadsheet: 888307d1738794322-count-lookup-if-date-in-in-range-term-test
Sheet: Summary

Department | Year | Count
TN-PR-SUP | 2024
FINANC | 2025
TN-PR-REC | 2022
SL-ADM
SL-SUP
TN-PR-ASS
PURINT
PG-ECO
PR-SHP
PURCHS
TN-PR-IDS
TN-PR-SHP
PG-MKT
TN-PR-VAS
TN-PR-PSH
TN-PR-REP
PR-ADM
SL-IND
TN-PR-RMA
TN-SL-ADM
TN-PR-ADM
TN-PR-QAS
Spreadsheet: 840634d1692880029-matrix-lookup-probably-as-simple-as-my-previous-question-test-example2-1-
Sheet: Konfigs

 | Probalility level | Kolumn1 | Kolumn2 | Kolumn3
 |  | 0 | 0.099 | Very low
 |  | 0.1 | 0.99 | Low
 |  | 1 | 9.99 | Moderate
 |  | 10 | 99 | High
 |  | 100 |  | Very high
 | Anpassat, se motivering
 | Konsekvensnivå | Kolumn1 | Kolumn2 | Kolumn3
 |  | 0 | 99 | Neglible
 |  | 100 | 999 | Moderate
 |  | 1000 | 4999 | Serious
 |  | 5000 |  | Very Serious
 | Anpassat, se motivering
 | Kolumn1 | Very low | Low | Moderate | High | Very high
 | Very serious | 4 | 5 | 6 | 7 | 8
 | Serious | 3 | 4 | 5 | 6 | 7
 | Moderate | 2 | 3 | 4 | 5 | 6
 | Negliable | 1 | 2 | 3 | 4 | 5
Spreadsheet: 495030d1482954181-vacation-calendar-spreadsheet-time-off-calendar-excel-form
Sheet: 2017

Year Begin |  |  |  |  |  |  | 2017-01-01 00:00:00 |  |  | Year End |  |  |  |  | 2017-12-31 00:00:00
Start Date |  |  |  |  |  | 2016-07-05 00:00:00 |  |  |  | Today's Date
Balance 2016 Vacation Days |  |  |  |  |  |  | 6 |  |  | Balance 2016 Sick Days |  |  |  |  |  | 6
Total Vacation Days |  |  |  |  |  |  |  |  |  | Total Sick Days |  |  |  |  |  |  |  | Total STOP Time |  |  |  |  | 8
Vacation Days Taken: |  |  |  |  |  |  |  |  |  | Paid Sick Hours Taken |  |  |  |  |  |  |  | STOP Time Taken
Remaining Vacation Days |  |  |  |  |  |  |  |  |  | Remaining Sick Days |  |  |  |  |  |  |  | Remaining Stop Time
2016 | January |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  | September |  | October |  | November |  | December
 | V/S/ST | .5 / 1 | V/S/ST | .5 / 1 | V/S/ST | .5 / 1 | V/S/ST | .5 / 1 | V/S/ST | .5 / 1 | V/S/ST | .5 / 1 | V/S/ST | .5 / 1 | V/S/ST | .5 / 1 | V/S/ST | .5 / 1 | V/S/ST | .5 / 1 | V/S/ST | .5 / 1 | V/S/ST | .5 / 1
1
2 | HOLIDAY
3
4 |  |  |  |  |  |  |  |  |  |  |  |  | HOLIDAY
5
6
7
8
9
10
11
12
13 | ST | 1.5 | V | 1
14 |  |  | V | 1
15 |  |  | V | 1
16 |  |  | V | 1
17 |  |  | V | 1
18
19
20
21
22
23
24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HOLIDAY |  | HOLIDAY
25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HOLIDAY |  | HOLIDAY
26
27
28
29
30
31 | ST | 1
TOTALS
Vacation
Sick
STOP (hrs)
Spreadsheet: 678436d1589891052-return-to-column-heading-if-value-found-sample
Sheet: Sheet1

1860s | 1860 | 1805s | Kimberly | Not Fit |  |  | Result
 |  | 1 |  |  |  |  | 1805s
 |  | 1 |  |  |  |  | 1805s
1
1
 |  | 1
1
 | 1
1
1
1
1
 | 1
 | 1
1
 | 1
1
1
 | 1
 |  | 1
1
 |  |  | 1
1
1
 | 1
 |  |  | 1
1
1
 |  | 1
1
 | 1
1
 |  | 1
1
 |  | 1
 |  |  |  | 1
1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  |  | 1
1
 |  |  | 1
 |  | 1
 | 1
 |  | 1
 | 1
1
 | 1
 |  | 1
 |  | 1
 |  | 1
1
 |  | 1
1
 |  | 1
 |  | 1
 | 1
1
 |  | 1
1
 |  | 1
1
1
1
 |  |  |  | 1
1
1
 | 1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
 | 1
1
1
1
1
1
 |  | 1
1
 |  | 1
1
 | 1
 | 1
1
 | 1
1
 |  | 1
1
1
1
1
1
 |  | 1
 |  |  |  | 1
 | 1
Spreadsheet: 212766d1360228806-how-to-add-values-in-a-dates-book2
Sheet: Sheet5

 |  | Products | Dates | Values
 |  | Product A | 2013-01-01 00:00:00 | 10
 |  | Product B | 2013-01-10 00:00:00 | 20
 |  | Product A | 2013-01-15 00:00:00 | 30
 |  | Product D | 2013-01-20 00:00:00 | 15
 |  | Product A | 2013-01-25 00:00:00 | 20
 |  |  |  |  |  |  |  |  | Result
 |  |  |  |  |  |  | Product | Date | Values
 |  |  |  |  |  |  | Product A | 2013-01-18 00:00:00
Spreadsheet: louise_kitchen__22726__0201MarginRequirements
Sheet: Template

FUTURES MARGIN REQUIREMENTS
2002-01-29 00:00:00
2002-01-28 00:00:00
 | US $$$ |  |  |  |  |  |  |  |  |  |  |  | CANADIAN $$$ |  | US $$$
Broker | TE | Credit Facility Covering TE | TE Less CreditCoverage | Net Option Value | Initial Margin | Line of Credit Covering Initial Margin (except EDF [NAME] see calc below) | Initial Margin Less Line of Credit Covering Initial Margin |  | Daily Facility Movement Inc/(Dec) Line |  | Wire Day Cash In/(Out) |  | TE | Initial Margin | OTE
ABN-Amro Inc |  |  |  | 0
ADM INVESTOR |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | 0
BANK ONE |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | 0
CARR FUTURES (NG) |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | 0
CARR FUTURES INC. |  |  |  | 0
CREDIT SUISSE FIRST BOSTON |  |  |  | 0
EDF MAN
FIMAT |  |  |  | 0
HSBC - US$ |  |  |  | 0
HSBC - Canadian | 0 |  |  | 0 |  |  |  |  |  |  |  |  |  |  | 0
JP Morgan |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | 0
[NAME] |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | 0
PARIBAS |  |  |  | 0
PRUDENTIAL SI |  |  |  | 0
REFCO, INC |  |  |  | 0
R J O'BRIEN |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | 0
SAUL STONE & COMPANY |  |  |  | 0
SMITH BARNEY, INC |  |  |  | 0
SMITH BARNEY, INC  (Financial) | 0 |  |  | 0
TOTAL EXCLUDING MID-DAY CALLS
MID-DAY CALLS: (based solely on Market Movement)
EDF Mann | 0
TOTAL INCLUDING MID-DAY CALLS
 |  | Used Line
Credit Lines: | Line | OTE | Initial Margin | Total Line Used | Total Line Unused
Smith Barney | 50000000 | 0
1 Includes amounts withheld from payments due Enron.  Fimat's customer agreement states that excess margin including OTE due to Enron must first be used to pay down advances on the facility.
Spreadsheet: 216202d1361640367-help-with-vlookup-formula-ef366_bikes
Sheet: Sheet2

ram
vivek
vikas
suraj
prashant
sunil
suhas
mayur
here I have take an example of bikes
in Sheet1, column A I have mention the names of person, and in column B I have mentioned the names of bike
In Sheet2, I have applied vlook formula in column B, but it just returns 1 result
example ram is have pulsar, unicorn, karizma
but it just shows pulsar
I want a formula which should insert rows and to get all the ans
[NAME] 2more rows should automatically get added to show unicorn and karizma
Spreadsheet: 877412d1724255307-staff-count-per-hour-adding-overnight-to-next-days-count-staff-count-per-hour-adding-overnight-to-next-days-count
Sheet: Overnight Hours

Employee Name | 2024-08-18 00:00:00
Name | 06:00:00 | 16:00:00
Name | 10:00:00 | 20:00:00
Name | 16:00:00 | 02:00:00
Name | 20:00:00 | 06:00:00
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
 | Total Hours | Same Day | Overnight |  | [NAME]
00:00:00
01:00:00
02:00:00
03:00:00
04:00:00
05:00:00
06:00:00
07:00:00
08:00:00
09:00:00
10:00:00
11:00:00
12:00:00
13:00:00
14:00:00
15:00:00
16:00:00
17:00:00
18:00:00
19:00:00
20:00:00
21:00:00
22:00:00
23:00:00
Spreadsheet: 139916d1328544629-sort-with-combobox-sample-excel-inventory-using-indirect-data-validation
Sheet: YokeShaft

PartID | Description | Cost | Series
SP 1-28-111 | [NAME] | 1.11 | 1010
SP 2-28-222 | [NAME] | 2.22 | 1020
SP 3-28-333 | [NAME] | 3.33 | 1030
SP 4-28-444 | [NAME] | 4.44 | 1040
Spreadsheet: 547814d1510757104-filter-contains-more-than-2-contains-values-copy-of-example-jamiek47-
Sheet: Sheet1

Filter title column below by below terms | Filter URL column below by below terms
espn | [NAME]
sport | mirror
yahoo | goal
Title | URL | Title Search | URL Search
All results | Football | The Guardian | https://www.theguardian.com/football/results
Football Live Scores | Football Results | WhoScored - WhoScored.com | https://www.whoscored.com/LiveScores
Football Scores - ESPN | http://www.espn.co.uk/football/scoreboard
Football Scores and Fixtures - ESPN | http://www.espn.co.uk/football/fixtures
Today's Results - Football - Sporting Life | [NAME]
Premier League Football Scores, Results & Season Archives | https://www.premierleague.com/results
Football results - The Telegraph | http://www.telegraph.co.uk/football/all-results/
Live Football Scores, Fixtures & Results | Goal.com | http://www.goal.com/en-gb/live-scores
Live American football scores - NFL livescore, NFL results | http://www.flashscore.com/american-football/
Football Results | Scores | News - Yahoo Sport UK | [NAME]
Football Results & Latest Football Betting Odds | Soccer Base | http://www.soccerbase.com/results/home.sd
[NAME] dead aged 87 - Voice of BBC classified football results ... | https://www.thesun.co.uk/news/4905640/tim-gudgin-dead-87-bbc-football-results/
Football Results 2017/18 | BT Sport | http://sport.bt.com/football/results-01374810415303
Man who was voice of Saturday tea time and delivered classified ... | http://www.mirror.co.uk/sport/football/news/man-who-voice-saturday-tea-11515119
SofaScore.com: Football LiveScore | http://www.sofascore.com/
Spreadsheet: 876611d1723331785-calculation-two-numbers-with-text-n-one-cell-project
Sheet: Hier einf.bearb.Etiketten!!!!

 |  |  | Casio Collection MTP-1302PD-2A2VEF | turquoise / silver |  |  |  |  | PRODUCT DETAILS | Marke: CASIO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Marke: CASIO | PRODUCT DETAILS |  |  |  |  | turquoise / silver | Casio Collection MTP-1302PD-2A2VEF |  |  |  |  |  | Discount Euro | 0.2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 55,00 € 15.000 Miles |  |  | 55,00 € 15.000 Miles |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Discount Miles | 0.3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 39 | 11000
Spreadsheet: 788543d1658517145-formular-to-get-sum-in-another-sheet-analysis
Sheet: SHEET2

MPANGILIO WA UFAULU WA WANAFUNZI KIMASOMO
SHULE |  |  |  |  |  |  |  |  | DARASA |  |  |  | III
NA | SOMO | WALIOFANYA |  | WALIOFAULU |  | ALAMA WALIZOPATA
 |  |  |  |  |  | A |  | B |  | C |  | D |  | E
 |  | WV | WS | WV | WS | WV | WS | WV | WS | WV | WS | WV | WS | WV | WS
1 | HISABATI
2 | KISWAHILI
3 | KIINGEREZA
4 | SAYANSI & TEKNOLOJIA
5 | [NAME]
6 | URAIA NA MAADILI
Spreadsheet: 218898d1362602405-return-specific-text-if-a-different-text-is-contained-anywhere-in-a-range-of-cells-test
Sheet: Sheet1

Line | Qty | Description | Weight | Rate | Charges
1 | 4 | Widget 1234 | 10 | 17.50
2 | 6 | Widget 2345 FSC 1234 | 100 | 23.50
3 | 10 | Widget 2345 ABC | 100 | 18.50
4 | 2 | Widget 3456 | 25 | 17.50
5 | 1 | Widget 4567 ABC | 75 | 18.50
6 | 6 | Widget 5678 ABC | 100 | 18.50
 | Type:
Spreadsheet: 649061d1573457921-run-time-error-in-macro-time-series-upper-aquifer-qw-spreadsheet
Sheet: Well 3

Well | Date | pH | EC | Ca | [NAME] | Na | Alk as CaCO3 | HCO3  as  CaCO3 | CO3  as  CaCO3 | SO4 | Cl | TDS | SAR | SARadj | B | NO3-N | Cu | Fe | Mn | Zn | L.I. | Comments | Sum cat | [NAME] | % dif
 | Sampled | unit | dS/m | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | mg/L |  |  | mg/L | mg/L | mg/L | mg/L | mg/L | mg/L | Calc
3 | 2007-02-16 00:00:00 | 7.4 | 1.99 | 9.3 | 3.1 | 7.5 | 5.2 |  |  |  | 11 |  | 4.259713756852986 | 4.2 | 0.2 | 13 |  |  |  |  | 0.1
Spreadsheet: 787866d1658101134-two-criteria-index-match-not-working-index-match2
Sheet: Loading

92865 | 80591 |  | 2022-06-07 00:00:00 | 42 | Art | AJ | 24 | 03:00:00 | 06:25:00 | 03:25:00
92866 | 80591 |  | 2022-06-07 00:00:00 | 42 | Art | AJ | 26 | 06:25:00 | 07:50:00 | 01:25:00
92868 | 80591 |  | 2022-06-07 00:00:00 | 42 | Art | AJ | 26 | 08:30:00 | 10:50:00 | 02:20:00
92869 | 80591 |  | 2022-06-07 00:00:00 | 42 | Art | AJ | 28 | 10:50:00 | 13:00:00 | 02:10:00
92882 | 80600 |  | 2022-06-07 00:00:00 | 530 | [NAME] | [NAME] | 26 | 10:00:00 | 13:00:00 | 03:00:00
92885 | 80602 |  | 2022-06-07 00:00:00 | 413 | Jacobrieon | JW | 26 | 12:11:00 | 13:04:00 | 00:53:00
92895 | 80606 |  | 2022-06-07 00:00:00 | 6 | [NAME] | JB | 28 | 13:30:00 | 15:21:00 | 01:51:00
92896 | 80606 |  | 2022-06-07 00:00:00 | 6 | [NAME] | JB | 28 | 15:21:00 | 17:44:00 | 02:23:00
92903 | 80611 |  | 2022-06-07 00:00:00 | 494 | [NAME] | JM | 28 | 13:30:00 | 18:00:00 | 04:30:00
92904 | 80611 |  | 2022-06-07 00:00:00 | 494 | [NAME] | JM | 26 | 18:00:00 | 23:30:00 | 05:30:00
92908 | 80614 |  | 2022-06-07 00:00:00 | 74 | [NAME] | DR | 28 | 13:30:00 | 15:16:00 | 01:46:00
Spreadsheet: 764403d1642713392-formula-to-adjust-a-rate-based-on-lookup-of-dept-payroll-sample
Sheet: Tab 1

NO. | EMPLOYEE | dept code | Job type
100 | Smith, [NAME] | C61C | GW
101 | Smith, [NAME] | C61C | GW
102 | Smith, [NAME] | C65D | LIFT
103 | Smith, [NAME] | C61Q | GW
104 | Smith, [NAME] | C67GJ | Jan
105 | Smith, [NAME] | C65L | FR LIFT
106 | Smith, [NAME] | C65F | FR RCP
Spreadsheet: 378123d1424270939-how-to-filter-out-the-last-ten-values-and-find-how-many-times-it-exceeds-x-example
Sheet: Ark1

A | 2015-02-12 00:00:00 | 1
A | 2015-02-13 00:00:00 | 2
A | 2015-02-14 00:00:00 | 3
A | 2015-02-15 00:00:00 | 4
A | 2015-02-16 00:00:00 | 4
A | 2015-02-17 00:00:00 | 5
A | 2015-02-18 00:00:00 | 6 |  |  |  |  | Last ten sample dates
B | 2015-02-19 00:00:00 | 7 |  | Number |  | Point | Date | Result
B | 2015-02-20 00:00:00 | 8 |  | 1st |  | A
A | 2015-02-21 00:00:00 | 9 |  | 2nd
A | 2015-02-22 00:00:00 | 10 |  | 3rd
A | 2015-02-23 00:00:00 | 11 |  | 4th
A | 2015-02-24 00:00:00 | 12 |  | 5th
A | 2015-02-25 00:00:00 | 13 |  | 6th
A | 2015-02-26 00:00:00 | 14 |  | 7th
B | 2015-02-27 00:00:00 | 15 |  | 8th
B | 2015-02-28 00:00:00 | 16 |  | 9th
B | 2015-03-01 00:00:00 | 17 |  | 10th
C | 2015-03-02 00:00:00 | 18
C | 2015-03-03 00:00:00 | 19
C | 2015-03-04 00:00:00 | 20
C | 2015-03-05 00:00:00 | 21
Spreadsheet: 776303d1649682539-removing-delete-same-contents-from-columns-test
Sheet: Sheet1

[EMAIL] | [EMAIL] | [EMAIL]
[EMAIL] | [EMAIL] | [EMAIL]
[EMAIL] | [NAME] | [EMAIL]
[EMAIL] | [EMAIL] | [EMAIL]
[EMAIL] | [EMAIL] | [EMAIL]
[EMAIL] | [EMAIL] | [EMAIL]
[EMAIL] |  | [EMAIL]
[NAME] |  | [EMAIL]
[EMAIL] |  | [EMAIL]
[EMAIL] |  | [EMAIL]
[EMAIL] |  | [EMAIL]
[EMAIL] |  | [EMAIL]
[EMAIL] |  | [EMAIL]
[EMAIL] |  | [EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
Spreadsheet: 860869d1708891211-averageiif-for-values-between-a-set-range-50-100-report
Sheet: 50-100 Test.v2

Greater Than | Up To | [NAME] | Avg -Sht / +Lng | [NAME] From Pin | Avg. Shot Gain | Avg Score | [NAME] from Pin
50 | 55 | -1.2
55 | 60
60 | 65
65 | 70
70 | 75
75 | 80
80 | 85
85 | 90
90 | 95
95 | 100
Yards | -Lft / +Rgt | -Sht / +Lng | yrds from Pin
52 | -2 | 5 |  |  | Include
51 | 2 | -5 |  |  | Include
81 | 4 | -2.3
62 | -4 | -6.3
91 | 1 | 3
50 | 0 | 3.6 |  |  | Include
56 | 3 | 1,6
98 | 6 | 5
86 | 5 | -5
56 | -2 | -2.3
56 | 3 | -6.3
95 | -2 | 3
84 | -6 | 3.6
51 | -8 | 1,6 |  |  | Include
52 | 2 | 5 |  |  | Include
83 | 3 | -5
86 | -4 | -2.3
91 | -2 | -6.3
89 | 0 | 3
77 | 0 | 3.6
Spreadsheet: 47649d1246777878-want-to-auto-fill-info-using-an-excel-invoice-copy-of-members-25-discount-price-invoice-test-1
Sheet: Sheet1

Invoice Date: | 2009-07-04 00:00:00
Name: |  | Making the world healthier, One person at a time.
Address:
Phone #:
 |  | GET A FRIEND TO BECOME A MEMBER AND GET AN EXTRA 10% OFF YOUR NEXT ORDER
[NAME]:
SKU | Description | Qty | Tax | Retail Price | Total Price
84749 | Thingies | 1 | 1.1 | 56.19 | 61.809
86734 | doo-dads | 3 | 1.1 | 4.67 | 15.411
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  | Retail Total: | 77.22
Thank you for ordering
 |  |  |  | 25% discount: | 57.915
Please call me if you have any questions
 |  |  |  | Tax: | 0
GET 2 FRIENDS TO BECOME A MEMBER AND GET AN EXTRA 15% OFF YOUR NEXT 2 ORDERS
 |  |  |  | S&H: | 10.8108
 |  |  |  | Your Total Due: | 68.72579999999999
Spreadsheet: 801042d1666042112-sumifs-2-criterias-on-same-column-sumifs-2-criterias-on-same-column-alexxl-
Sheet: Sheet1

 | Day(MM-DD-YYYY) : 09-01-2022 | Total calls
 | 08:00-9:00
 | 09:00-10:00
 | 10:00-11:00
 | 11:00-12:00
 | 12:00-13:00
 | 13:00-14:00
 | 14:00-15:00
 | 15:00-16:00
 | 16:00-17:00
 | Total
 | Day(MM-DD-YYYY) : 09-02-2022 | Total calls
 | 08:00-9:00
 | 09:00-10:00
 | 10:00-11:00
 | 11:00-12:00
 | 12:00-13:00
 | 13:00-14:00
 | 14:00-15:00
 | 15:00-16:00
 | 16:00-17:00
 | Total
Spreadsheet: 855467d1705019858-dynamic-hourly-employee-headcount-including-overnight-staff-dynamic-hourly-employee-headcount-including-overnight-staff-
Sheet: Sheet1

 |  |  |  |  |  |  |  | Day of Week Monday | Monday
 | Day of Week | Role | Name | Start | End |  |  |  | 00:00:00 | 01:00:00 | 02:00:00 | 03:00:00 | 04:00:00 | 05:00:00 | 06:00:00 | 07:00:00 | 08:00:00 | 09:00:00 | 10:00:00 | 11:00:00 | 12:00:00 | 13:00:00 | 14:00:00 | 15:00:00 | 16:00:00 | 17:00:00 | 18:00:00 | 19:00:00 | 20:00:00 | 21:00:00 | 22:00:00 | 23:00:00
 | Monday | RN | Julie | 07:00:00 | 19:00:00 |  |  | Supervisor
 | Monday | RN | Mark | 08:00:00 | 20:00:00 |  |  | Charge
 | Monday | RN |  | 07:30:00 | 20:30:00 |  |  | RN
 | Monday | Tech |  | 08:00:00 | 05:00:00 |  |  | Tech
 | Monday | Tech
 | Monday | Tech
 | Monday | Charge
 | Monday | Supervisor
 | Monday | RN |  | 19:00:00 | 07:00:00
 | Tuesday | RN |  | 19:00:00 | 07:00:00
 | Tuesday | RN
 | Tuesday | RN
 | Tuesday | Tech
 | Tuesday | Tech
 | Tuesday | Tech
 | Tuesday | Charge
 |  | Supervisor
 |  | RN
Spreadsheet: 58208d1258492335-count-dates-between-two-dates-test-if-date-is-between-two-date-then-count
Sheet: Sheet1

Date of Incident | Functional Group
2009-09-11 00:00:00 | CSTP-LD
2009-10-15 00:00:00 | CSTP-EPG
2009-11-02 00:00:00 | CSTP
2009-11-02 00:00:00 | CSTP-LD
2009-10-09 00:00:00 | CSTP
2009-09-16 00:00:00 | CSTP-FX
2009-09-14 00:00:00 | CSTP
2009-10-30 00:00:00 | CSTP-DEV
2009-10-29 00:00:00 | CSTP-EPG
Weeks of Incidents |  | CSTP-LD | CSTP-EPG | CSTP-FX | CSTP
2009-11-16 00:00:00 | 2009-11-22 00:00:00
2009-11-09 00:00:00 | 2009-11-15 00:00:00
2009-11-02 00:00:00 | 2009-11-08 00:00:00
2009-10-26 00:00:00 | 2009-11-01 00:00:00
2009-10-19 00:00:00 | 2009-10-25 00:00:00
2009-10-12 00:00:00 | 2009-10-18 00:00:00
2009-10-05 00:00:00 | 2009-10-11 00:00:00
2009-09-28 00:00:00 | 2009-10-04 00:00:00
2009-09-21 00:00:00 | 2009-09-27 00:00:00
2009-09-14 00:00:00 | 2009-09-20 00:00:00
2009-09-07 00:00:00 | 2009-09-13 00:00:00
2009-08-31 00:00:00 | 2009-09-06 00:00:00
2009-08-24 00:00:00 | 2009-08-30 00:00:00
Spreadsheet: 63572d1264461817-replacing-abbreviations-in-street-addresses-replacestrings
Sheet: Sheet1

N | North |  |  | 563 South 9Th St |  |  | 563 South 9Th St
S | South |  |  | 853 W Main St |  |  | 853 W Main St
E | East |  |  | 98 N Battlebridge Dr |  |  | 98 N Battlebridge Dr
W | West |  |  | 35879 Se 48Th St |  |  | 35879 Se 48Th St
NE | Northeast |  |  | 9863 Morgan Trl |  |  | 9863 Morgan Trl
SW | Southwest |  |  | 6873 [NAME] |  |  | 6873 [NAME]
Rd | Road |  |  | 891 E 169Th Pl |  |  | 891 E 169Th Pl
Ave | Avenue |  |  | 389 Pioneer St |  |  | 389 Pioneer St
Trl | Trail |  |  | 9868 Sw 63Rd St |  |  | 9868 Sw 63Rd St
Pl | Place |  |  | 1986 [NAME] |  |  | 1986 [NAME]
St | Street |  |  | 1987 S 74Th West Ave |  |  | 1987 S 74Th West Ave
[NAME] | Court |  |  | 135 Nesuda Rd |  |  | 135 Nesuda Rd
Ct | Court
Cir | Circle
Dr | Drive