tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 807979d1670220978-return-last-5-rows-from-table1-sample-3-
Sheet: Sheet2

 | Last 5 Trips |  |  |  |  | Solution for Excel 2021 users
 |  | #[NAME]! | #[NAME]! | #[NAME]! |  |  | 454 | 612 | Seattle
 | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! |  | Nick | 912 | 1121 | New York
 | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! |  | Olivia | 313 | 565 | Palm Beach
 | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! |  | Cameron | 810 | 1201 | Chicago
 | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! |  | [NAME] | 717 | 981 | Las Vegas
 | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]!
 | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! |  | Solution for Excel 365 users
 | #[NAME]! | #REF! | #REF! | #[NAME]! |  |  | 454 | 612 | Seattle
 | #[NAME]! | #REF! | #REF! | #[NAME]! |  | Nick | 912 | 1121 | New York
 | #[NAME]! | #REF! | #REF! | #[NAME]! |  | Olivia | 313 | 565 | Palm Beach
 | #[NAME]! | #REF! | #REF! | #[NAME]! |  | Cameron | 810 | 1201 | Chicago
 |  |  |  |  |  | [NAME] | 717 | 981 | Las Vegas
Spreadsheet: 870830d1717270191-common-day-column-for-both-tables-2095-pulse-with-two-bar-graphs-2
Sheet: Pulse

 | Pulse |  |  |  |  | Pulse
 | AM (6- 9) |  |  |  |  | PM (4-7)
 | Day | SYS | DIA | Pulse |  | Day | SYS | DIA | Pulse
 | 1 | 131 | 71 | 61 |  |  | 128 | 66 | 59
 | 2 | 120 | 71 | 68 |  |  | 130 | 65 | 60
 | 3 | 111 | 59 | 59 |  |  | 124 | 66 | 55
 | 4 | 110 | 59 | 52 |  |  | 123 | 61 | 54
 | 5 | 122 | 67 | 61 |  |  | 123 | 66 | 59
 | 6 | 127 | 72 | 61 |  |  | 134 | 68 | 71
 | 7 | 117 | 68 | 59 |  |  | 123 | 61 | 55
 | 8 | 121 | 62 | 60 |  |  | 119 | 63 | 65
 | 9 | 118 | 70 | 62 |  |  | 123 | 64 | 58
 | 10 | 117 | 68 | 59 |  |  | 130 | 65 | 60
 | 11 | 118 | 66 | 61 |  |  | 119 | 61 | 53
 | 12 | 132 | 68 | 61 |  |  | 130 | 65 | 60
 | 13 | 111 | 59 | 59 |  |  | 113 | 58 | 69
 | 14 | 120 | 67 | 55 |  |  | 131 | 67 | 62
 | 15 | 122 | 67 | 61 |  |  | 131 | 65 | 62
 | 16 | 125 | 68 | 53 |  |  | 139 | 72 | 61
 | 17 | 132 | 69 | 54 |  |  | 128 | 62 | 63
 | 18 | 135 | 70 | 51 |  |  | 132 | 60 | 62
 | 19 | 132 | 69 | 54 |  |  | 126 | 66 | 55
 | 20 | 119 | 65 | 57 |  |  | 123 | 61 | 57
 | 21 | 125 | 70 | 56 |  |  | 117 | 57 | 61
 | 22 | 121 | 70 | 55 |  |  | 121 | 60 | 60
 | 23 | 119 | 65 | 57 |  |  | 124 | 62 | 58
 | 24 | 123 | 67 | 59 |  |  | 117 | 57 | 61
 | 25 | 124 | 61 | 63 |  |  | 119 | 67 | 61
 | 26 | 114 | 67 | 61 |  |  | 130 | 65 | 61
 | 27 | 129 | 66 | 56 |  |  | 116 | 64 | 54
 | 28 | 124 | 68 | 57 |  |  | 117 | 60 | 58
 | 29 | 121 | 66 | 55 |  |  | 121 | 67 | 66
 | 30 | 129 | 66 | 56 |  |  | 123 | 66 | 54
Spreadsheet: f3829a47-dfd1-4b48-9f5f-598d763befd5
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
7496 | 13958 | Team I | Australia | AUS
7496 | 10386 | Team I | Czech Republic | CZE
7496 | 11428 | Team I | France | FRA
7496 | 11450 | Team I | Germany | GER
7496 | 11448 | Team I | Great Britain | GBR
7496 | 11437 | Team I | Italy | ITA
7496 | 14037 | Team I | Japan | JPN
7496 | 11452 | Team I | Portugal | POR
7496 | 11435 | Team I | Spain | ESP
7496 | 14168 | Team I | United States | USA
Spreadsheet: 27660d1221087149-change-from-foot-to-meters-conversion
Sheet: Convert

From | USD | GBP | CAD | EUR | AUD
To
USD | 1 | 1.755 | 0.932 | 1.402 | 0.804
GBP | 0.57 | 1 | 0.531 | 0.799 | 0.458
CAD | 1.073 | 1.884 | 1 | 1.505 | 0.863
EUR | 0.713 | 1.252 | 0.664 | 1 | 0.573
AUD | 1.244 | 2.184 | 1.159 | 1.745 | 1
Spreadsheet: 219958d1363022797-looking-up-a-value-based-on-two-pieces-of-information-test9
Sheet: Patterns

Pattern | 1 | 2 | 3
2013-03-01 00:00:00 | IN | IN | OFF
2013-03-02 00:00:00 | IN | IN | IN
2013-03-03 00:00:00 | IN | IN | IN
2013-03-04 00:00:00 | IN | IN | IN
2013-03-05 00:00:00 | OFF | OFF | OFF
2013-03-06 00:00:00 | OFF | OFF | OFF
2013-03-07 00:00:00 | IN | OFF | IN
2013-03-08 00:00:00 | IN | IN | IN
2013-03-09 00:00:00 | IN | IN | IN
2013-03-10 00:00:00 | IN | IN | IN
2013-03-11 00:00:00 | IN | IN | IN
2013-03-12 00:00:00 | OFF | OFF | OFF
2013-03-13 00:00:00 | OFF | OFF | OFF
2013-03-14 00:00:00 | IN | OFF | OFF
2013-03-15 00:00:00 | IN | IN | IN
2013-03-16 00:00:00 | IN | IN | IN
2013-03-17 00:00:00 | IN | IN | IN
2013-03-18 00:00:00 | IN | IN | IN
2013-03-19 00:00:00 | OFF | OFF | IN
2013-03-20 00:00:00 | OFF | OFF | IN
2013-03-21 00:00:00 | OFF | OFF | OFF
2013-03-22 00:00:00 | IN | IN | OFF
2013-03-23 00:00:00 | IN | IN | IN
2013-03-24 00:00:00 | IN | IN | IN
2013-03-25 00:00:00 | IN | IN | IN
2013-03-26 00:00:00 | OFF | IN | IN
2013-03-27 00:00:00 | OFF | IN | IN
2013-03-28 00:00:00 | OFF | IN | IN
2013-03-29 00:00:00 | OFF | OFF | OFF
2013-03-30 00:00:00 | IN | OFF | OFF
2013-03-31 00:00:00 | IN | OFF | OFF
Spreadsheet: 584374d1533142834-combining-formulas-if-function-example
Sheet: Sheet1

Account | Total Finance View | Utilization Ratio | Last 6 Month Sales | Days Since Payment | Letter Grade | Review?
1 | 603199.72 | 6.031997199999999 | 777616.5 | 1 | A
2 | 39457 | 0.78914 | 144538 | 2 | B
3 | 27103 | 0.4517166666666667 | 147870 | 1 | C
4 | 166018.6 | 2.0752325 | 267213.4 | 13 | D
5 | 16701 | 1.6701 | 25768 | 61 | F
Spreadsheet: jonathan_mckay__16926__Area Managers
Sheet: Mount Pleasant

Enron Direct Deal Sheet |  |  |  |  |  |  |  |  |  |  |  |  | 1 | January
 |  |  |  |  |  |  |  |  |  |  |  |  | 2 | February
Counterparty Name: | Mount Pleasant Sportsplex |  |  |  | Deal Date: | 2001-05-23 00:00:00 |  |  |  |  |  |  | 3 | March
Originator: | Greg Frers |  |  |  | Deal ID #: |  |  |  |  |  |  |  | 4 | April
 |  |  |  |  |  |  |  |  |  |  |  |  | 5 | May
Deal Start Date: | 2001-08-01 00:00:00 |  |  |  | Unit of Measure: | GJ |  |  |  |  |  |  | 6 | June
Deal End Date: | 2002-07-31 00:00:00 |  |  |  | Volume (Monthly/Daily): | Monthly |  |  |  |  |  |  | 7 | July
Term Duration (months): |  |  |  |  |  |  |  |  |  |  |  |  | 8 | August
 |  |  |  |  | Price: |  |  |  |  |  |  |  | 9 | September
Fuel Rate %: | 0.01561 |  |  |  | Buy/Sell: | Buy |  |  |  |  |  |  | 10 | October
 |  |  |  |  |  |  |  |  |  |  |  |  | 11 | November
 |  |  |  |  |  |  |  |  |  |  |  |  | 12 | December
 | Month | Rate 11 Volume | Rate 13 Volume | Combined Volume | Fuel | Total
 | January | 215
 | February | 191
 | March | 146
 | April | 120
 | May | 37
 | June | 57
 | July | 32
 | August | 49
 | September | 49
 | October | 118
 | November | 182
 | December | 248
 | TOTAL:
Spreadsheet: 86957d1286899712-how-to-changing-conditional-formatting-once-applied-book2
Sheet: Automation

 |  |  |  | WW35 |  | WW36 |  | WW37
 |  |  |  | 2010-08-27 00:00:00 | 2010-08-27 00:00:00
 |  |  |  | Forecast | Actual | Forecast | Actual | Forecast | Actual
Group | Name
Select Group | [NAME] | Project | Total Allocation
 |  | Spec |  | 0.15 | 0.15
 |  | Design |  |  |  | 0.2 | 0.25 | 0.25 | 0.25
 |  | Dev |  |  |  | 0.3 | 0.3 | 0.25 | 0.25
 |  | Test |  |  |  |  |  | 0.3 | 0.3
Automation | [NAME] | Project | Total Allocation
 |  | Spec |  | 0.15 | 0.15
 |  | Design |  |  |  | 0.2 | 0.25 | 0.25 | 0.25
 |  | Dev |  |  |  | 0.3 | 0.3 | 0.25 | 0.25
 |  | Test |  |  |  |  |  | 0.3 | 0.3
Automation | [NAME] | Project | Total Allocation
 |  | Spec |  | 0.15 | 0.15
 |  | Design |  |  |  | 0.2 | 0.25 | 0.25 | 0.25
 |  | Dev |  |  |  | 0.3 | 0.3 | 0.25 | 0.25
 |  | Test |  |  |  |  |  | 0.3 | 0.3
Automation | [NAME] | Project | Total Allocation
 |  | Spec |  | 0.15 | 0.15
 |  | Design |  |  |  | 0.2 | 0.25 | 0.25 | 0.25
 |  | Dev |  |  |  | 0.3 | 0.3 | 0.25 | 0.25
 |  | Test |  |  |  |  |  | 0.3 | 0.3
Automation | [NAME] | Project | Total Allocation
 |  | Spec |  | 0.15 | 0.15
 |  | Design |  |  |  | 0.2 | 0.25 | 0.25 | 0.25
 |  | Dev |  |  |  | 0.3 | 0.3 | 0.25 | 0.25
 |  | Test |  |  |  |  |  | 0.3 | 0.3
Spreadsheet: michelle_lokay__26647__RedRockSumm
Sheet: Oneok at 1700

RED ROCK EXPANSION PROJECT
 | REQUESTED | REQUESTED
 | RECEIPT | DELIVERY |  |  | Allocation
COMPANY | POINT | POINT | MMBtu/d | Term/Yrs | Share | Volume
PPL | EOT | Griffith | 8000 | 30
 | EOT | Socal Needles | 12000 | 30
Western | EOT | Socal Needles | 10000 | 15
[NAME] | EOT | Socal Needles | 6000 | 15
 | EOT | PG&E Topock | 2000 | 15
US Gypsum | PH Pool | Socal Needles | 4500 | 12.25
 | Central Pool | Socal Needles
 | WT Pool | Socal Needles
BP Energy | Central Pool | Socal Needles | 15000 | 5
Oneok | EOT | Socal Needles | 1700 | 1.8
Calpine | EOT | PG&E Topock | 40000 | 15
 |  |  |  |  |  |  | West Texas Pool Total Volume
 |  | Exclude BP | 15000
 |  | Total Req'd
Spreadsheet: 765829d1643631066-1-how-to-create-a-list-based-on-user-input-2-previous-values-based-on-the-last-occurance-questions-ans-v1-ans1
Sheet: Q1

Name | Profit | HELPER | Most profitable List | Total Profit |  |  |  | UNIQUE NAMES | Total Profit | Profit Rank | USER INPUT: | 8 | PLEASE ENTER A VALUE TO KNOW THE MOST PROFITABLE NAMES
ABC | 700 |  |  |  |  |  |  |  |  | 3
RST | 400 |  |  |  |  |  |  |  |  | 2
XYZ | 300 |  |  |  |  |  |  |  |  | 1
ABC | -50 |  |  |  |  |  |  |  |  | 6
MNO | 200 |  |  |  |  |  |  |  |  | 8
RST | 600 |  |  |  |  |  |  |  |  | 5 | [NAME] needed for J1 such that:
QWE | 150 |  |  |  |  |  |  |  |  | 11 | if user input is, let's say, 5, then list of top 5 profitable names should appear in Col C along with their respective total profit in Col D
RST | -150 |  |  |  |  |  |  |  |  | 4 | but if user input is, let's say 7, then top 7 names along with their total profits to appear in Col C & D
LKJ | 300 |  |  |  |  |  |  |  |  | 9 | The list shd appear such that most profitable name shd be on the top (decending profit)
DFG | -350 |  |  |  |  |  |  |  |  | 7
UYT | 400 |  |  |  |  |  |  |  |  | 10
HGY | 100
ZXC | 200
BVC | 50
XYZ | 800
ABC | 200
Spreadsheet: 726776d1617448830-sumifs-function-doesnt-calculate-values-as-expected-accounting-module
Sheet: YTD Budget & Summary

 | MONTHLY EXPENSES SUMMARY |  |  |  | 2018-12-18 00:00:00
 | ACTUAL vs. BUDGET YTD |  |  |  | YEAR
 | G/L Code | Account Title | Actual | Budget | Remaining Rs. | Remaining %
 | WGL001 | Building Rent |  | 100000
 | WGL002 | Electricity |  | 100000
 | WGL003 | Fuel |  | 100000
 | WGL004 | Internet Charges |  | 100000
 | WGL005 | Mobile Charges |  | 50000
 | WGL006 | Statationery |  | 25000
 | WGL007 | Computers |  | 75000
 | WGL008 | Furniture |  | 65000
 | WGL009 | Travelling Costs |  | 125000
 | WGL010 | Marketing |  | 100000
 | WGL011 | Charitables |  | 250000
 | WGL012 | Sponsorships |  | 50000
 | WGL013 | Entertainment |  | 50000
 | WGL014 | Insurance |  | 50000
 | WGL015 | Water Bill |  | 50000
 | WGL016
 | WGL017
 | WGL018
 | Total
Spreadsheet: 685352d1593941246-if-formula-which-can-resolve-and-look-for-text-in-2-columns-example-formula-1
Sheet: Sheet1

COMPARE | COMPARE |  | AUDIT TEST
19 | 6
sub_result | visual_authenticity_result
clear | clear |  | Is THERE a formula which can look into column A and B and search for the word "Clear", and if Clear, then "pass", if not, then "fail"
clear | clear
clear | clear
caution | clear
clear | clear
clear | clear
clear | clear
clear | clear
clear | clear
clear | clear
clear | clear
clear | clear
clear | clear
clear | clear
clear | clear
clear | clear
clear | clear
clear | clear
clear | clear
clear | clear
clear | clear
clear | clear
clear | clear
clear | clear
clear | clear
clear | clear
clear | clear
clear | clear
clear | clear
clear | clear
clear | clear
clear | clear
clear | clear
Spreadsheet: daren_farmer__6597__egmnom-Feb
Sheet: RHODIA

 | Nomination Change
 | ATTN: Transportation Specialist
HOUSTON PIPE LINE COMPANY
HPL Contract # |  | 012-27106-02-011
Shipper: | Entex Gas Marketing | Effective Dates:
Nominator: | Troy Benoit | Start:
Telephone: | (713)207-3376 | 2000-02-01 00:00:00
Fax: | (713)207-0054 | Stop:
 |  | 2000-02-29 00:00:00
RECEIPTS |  |  | FEB | FEB | FEB | FEB | FEB | FEB | FEB | FEB | FEB | FEB | FEB | FEB | FEB | FEB | FEB | FEB | FEB | FEB | FEB | FEB | FEB | FEB | FEB | FEB | FEB
METER # | [NAME] | SUPPLIER | 1
4132 | EXXON KATY | [NAME] (MIDCON 92155) | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500
ZZZZ | IMBALANCE |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | RECEIPT TOTAL
DELIVERIES
METER # | [NAME] | MARKET
8078 | RHODIA-FREEPORT | RHODIA-FREEPORT | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500
ZZZZ | IMBALANCE |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | DELIVERY TOTAL
 |  | BALANCE
Spreadsheet: 132939d1324047128-formula-for-rolling-back-three-months-anothersampleattendance
Sheet: Employee points and FMLA totals

Employee Name |  | Total Points: (Last Rolling three months as of today's date) | Total FMLA Time Missed (Last rolling 12 months as of today's date) | Today's Date: | 2011-12-16 00:00:00
 | Dept. Number |  |  | Three month rolling period: (points) | 2011-09-16 00:00:00
 |  |  |  | Twelve month rolling period: (FMLA) | 2010-12-16 00:00:00
[NAME] | 1
[NAME] | 2
[NAME] | 3
TEST
TEST
TEST
TEST
TEST
TEST
Spreadsheet: 154786d1336565569-run-an-if-statement-of-a-dependent-drop-down-list-application-master_john_v2
Sheet: Demo

Ticket/Case # | Application Name | Date | Sev | Incident Duration | Description of Issue/Impact | Immediate Fix | Root Cause | Long Term Corrective Action | Related Change Request or Incident
IN12345678
IN12345679
IN12345680
IN12345681
IN12345682
IN12345683
IN12345684
IN12345685
IN12345686
IN12345687
IN12345688
IN12345689
IN12345690
IN12345691
IN12345692
IN12345693
IN12345694
IN12345695
IN12345696
IN12345697
IN12345698
IN12345699
IN12345700
IN12345701
Spreadsheet: 884797d1734067939-minifs-and-hidden-data-cliffoxiesample
Sheet: Sheet1

SAMPLE WORKSHEET |  |  |  |  | Next Expiration
End Date | End Time | Status
2024-12-12 00:00:00 | 1400 | ACTIVE
2024-12-15 00:00:00 | 1500 | ACTIVE |  |  |  | ^^^ it is pulling from Row 8, which is hidden
2024-12-26 00:00:00 | 2200 | ACTIVE |  |  |  | I would like to show Row 11, value 1200
2024-12-13 00:00:00 | 200 | ACTIVE
2024-12-14 00:00:00 | 400 | DONE
2024-12-12 00:00:00 | 600 | DONE
2024-12-13 00:00:00 | 1400 | ACTIVE
2024-12-24 00:00:00 | 1800 | ACTIVE
2024-12-12 00:00:00 | 1200 | READY TO BE DONE |  |  | D2 = | "=aggregate(5,5,a3:a26)"
 |  |  |  |  | E2 = | "=minifs(B3:B26,A3:A26,D2)"
 |  |  |  |  | Status List
 |  |  |  |  | ACTIVE
 |  |  |  |  | DONE
 |  |  |  |  | READY TO BE DONE
 |  |  |  |  | READY TO GO ACTIVE
Spreadsheet: 473554d1470262255-how-to-generate-possible-outcomes-after-ndm
Sheet: Sheet1

A | 1 | h |  | 36
B | 2 | i |  | 6
C | 3 | j
D | 4 | k
E | 5 | l
F | 6 | m
Spreadsheet: 217967d1362271331-need-help-with-creating-a-sheet-to-calculate-sales-price-margins-sheet
Sheet: Sheet1

Cost Price | eBay Fee | Paypal fee | Postage | Packaging | VAT | Profit | Profit Margin | Price to Sell at
1 |  |  | 0.58 | 0.13 |  |  | 10
2 |  |  | 0.58 | 0.13 |  |  | 11
3 |  |  | 0.58 | 0.13 |  |  | 12
4 |  |  | 0.58 | 0.13 |  |  | 13
5 |  |  | 0.58 | 0.13 |  |  | 14
6 |  |  | 0.58 | 0.13 |  |  | 15
Cost | PP Fee | Ebay | Postage | Packaging | VAT | Price to sell | Profit
100 |  |  | 0.58 | 0.13 |  | 53687091.2
100 |  |  |  |  |  | 110
 |  |  |  |  |  |  |  | Cost of Item | 100
 |  |  |  |  |  |  |  | Shipping Costs
Cost of Item |  |  |  |  |  |  |  | Sales Price | 126.3158042105263
 |  |  |  |  |  |  |  | Profit Margin
Spreadsheet: 183508d1348846520-i-am-getting-this-error-copy-of-q4-mlt-mto-cloud-program-dining-narendra
Sheet: sheet

City | State | Province | Zip | Country
 | NM |  |  | USA
 | NJ |  |  | USA
 | CA |  |  | USA
 | IL |  |  | USA
 |  |  |  | ARE
 |  |  |  | ARE
 | NY |  |  | USA
 | NY |  |  | USA
 |  |  |  | POL
 | CO |  |  | USA
 | GA |  |  | USA
 | IL |  |  | USA
 | NY |  |  | USA
 | NY |  |  | USA
 | NY |  |  | USA
 | GA |  |  | USA
 | NJ |  |  | USA
 | NH |  |  | USA
 |  |  |  | CRI
 | NY |  |  | USA
 | NY |  |  | USA
 | MA |  |  | USA
 | FL |  |  | USA
 | CA |  |  | USA
 | WY |  |  | USA
 | CO |  |  | USA
 | MO |  |  | USA
 | FL |  |  | USA
 | AL |  |  | USA
 | GA |  |  | USA
 | TX |  |  | USA
 | NJ |  |  | USA
 | SC |  |  | USA
 | FL |  |  | USA
 | GA |  |  | USA
 | LA |  |  | USA
 | WI |  |  | USA
 | WI |  |  | USA
 |  |  |  | COL
 | MA |  |  | USA
 | MA |  |  | USA
 | CA |  |  | USA
 | CA |  |  | USA
 | PA |  |  | USA
 | TX |  |  | USA
 | DC |  |  | USA
 | MI |  |  | USA
 | LA |  |  | USA
 | CA |  |  | USA
 |  |  |  | CAN
 | MI |  |  | USA
 | CA |  |  | USA
 | AL |  |  | USA
 | IN |  |  | USA
 | TN |  |  | USA
 | TX |  |  | USA
 | PA |  |  | USA
 | WA |  |  | USA
 | NY |  |  | USA
 | KS |  |  | USA
 | CA |  |  | USA
 | OH |  |  | USA
 | MA |  |  | USA
 | RI |  |  | USA
 | KS |  |  | USA
 | ID |  |  | USA
 | MA |  |  | USA
 |  |  |  | CAN
 | MD |  |  | USA
 | TN |  |  | USA
 | WA |  |  | USA
 | HI |  |  | USA
 | NJ |  |  | USA
 | PR |  |  | USA
 | IL |  |  | USA
 | FL |  |  | USA
 | GA |  |  | USA
 | TX |  |  | USA
 |  |  |  | PER
 | OK |  |  | USA
 | CA |  |  | USA
 | CA |  |  | USA
 | PA |  |  | USA
 | KS |  |  | USA
 | OH |  |  | USA
 | CA |  |  | USA
 | TN |  |  | USA
 | NH |  |  | USA
 | GA |  |  | USA
 | TX |  |  | USA
 | MA |  |  | USA
 | OH |  |  | USA
 | MI |  |  | USA
 | CA |  |  | USA
 | TX |  |  | USA
 | GA |  |  | USA
 | TN |  |  | USA
 | NY |  |  | USA
 | NY |  |  | USA
 | OK |  |  | USA
 | LA |  |  | USA
 | FL |  |  | USA
 | CA |  |  | USA
 |  | NS |  | CAN
 | NE |  |  | USA
 | TX |  |  | USA
 | CA |  |  | USA
 |  |  |  | JOR
 |  |  |  | BMU
 | NY |  |  | USA
 | CA |  |  | USA
 | MT |  |  | USA
 | NY |  |  | USA
 | NY |  |  | USA
 | NY |  |  | USA
 | MA |  |  | USA
 |  |  |  | NZL
 | MD |  |  | USA
 | CA |  |  | USA
 | PA |  |  | USA
 | GA |  |  | USA
Spreadsheet: 36175d1233942361-vlookup-index-on-2-criteria-lookup-2-criteria-formula
Sheet: Sheet1

office 1 |  | location 1 |  | 111 |  |  |  | office 1 | officeone
office 1 |  | location 2 |  | 222 |  |  |  | office 2 | officetwo
office 1 |  | location 3 |  | 333 |  |  |  | office 3 | officethree
office 2 |  | location 1 |  | 444
office 2 |  | location 2 |  | 555
office 2 |  | location 3 |  | 666
office 3 |  | location 1 |  | 777
office 3 |  | location 2 |  | 888
office 3 |  | location 3 |  | 999
 |  | office 3 | location 2 | 888
Spreadsheet: bfda5c7b-1ae4-408b-a00b-dd55b715e1fe
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
4379 | 7986 | [NAME] | Perkins | USA | 124 | 00:23:27 | 00:00:00 | 01:19:11 | 00:00:00 | 00:55:45 | 1 | 02:38:24
4379 | 25156 | [NAME] | Bik | USA | 131 | 00:25:23 | 00:00:00 | 01:22:55 | 00:00:00 | 00:59:02 | 2 | 02:47:21
4379 | 22141 | [NAME] | Geny | ARG | 114 | 00:22:27 | 00:00:00 | 01:25:56 | 00:00:00 | 01:08:10 | 3 | [NAME]
4379 | 25155 | [NAME] | Leske | USA | 3347 | 00:28:02 | 00:00:00 | [NAME] | 00:00:00 | 01:01:21 | 4 | 02:58:41
4379 | 7966 | [NAME] | Peiffer | FRA | 120 | 00:23:23 | 00:00:00 | 01:29:15 | 00:00:00 | 01:08:09 | 5 | 03:00:46
4379 | 7987 | Grant | [NAME] | CAN | 144 | 00:25:06 | 00:00:00 | 01:45:52 | 00:00:00 | 01:03:42 | 6 | 03:14:41
4379 | 7971 | Ruben | Grande | MEX | 130 | 00:27:54 | 00:00:00 | 01:35:24 | 00:00:00 | 01:28:40 | 7 | 03:31:59
Spreadsheet: vkaminski__40853__ModelingProject
Sheet: GBM+jump

 | GBM + [NAME]
 | Input Parameters
 | S0 | 100 |  | f | 100
 | r | 0.05 |  | k | 0
 | s | 0.3 |  | g | 0.02
 | Dt |  | (hourly)
 | dS = (r-d)Sdt + sSdz+kSdq
 | St = St-1 * exp[(m - 0.5s2 - fk)Dt + (se1(Dt)0.5)+(k + ge2)(ui>fDt)]
 | Time | e1 | e2 | u | Condition | Return | St
 | 0
Spreadsheet: mark_whitt__25242__Huber - Existing & Proposed Deals 111201
Sheet: Exposure

 |  | IF NGPL MidContinent index | IF PEPL index | IF NGPL MidContinent Index minus $0.01 | IF CIG Rocky Mtns. index minus $0.03 (Proposed) | Gas Daily PG&E Topock index minus $0.02 (Proposed) | Gas [NAME] San Juan index minus $0.10 (Proposed) | Gas Daily NWPL Wyoming Pool index minus $0.10 (Proposed)
Spreadsheet: 805932d1669020635-apply-formula-based-on-the-equality-of-adjacent-cells-excelforum21-ans
Sheet: Sheet1

Barcode 1 | [NAME] apply downwards
A
A
A
A
B
B
B
B
B
B
B
C
Spreadsheet: 542824d1508134161-merge-city-names-from-4-columns-into-one-column-with-between-each-city-book2
Sheet: Sheet1

City | City | City | City | Merge
Washington |  | Mombay
 | London
 | New York | Sydney | Tokyo
Dubai
 |  |  | Dublin
Baghdad
Spreadsheet: 62049d1262949880-counting-consecutive-dates-as-a-single-occasion-sick
Sheet: Sheet1

Name | Sickness Reason | Sickness Date | Total Days Absent
[NAME] | Minor Illnesses (e.g. colds, flu, stomach upsets, migraines) | 2009-06-19 00:00:00 | 0.5
[NAME] | Minor Illnesses (e.g. colds, flu, stomach upsets, migraines) | 2009-06-22 00:00:00 | 1
[NAME] | Minor Illnesses (e.g. colds, flu, stomach upsets, migraines) | 2009-06-23 00:00:00 | 1
[NAME] | Minor Illnesses (e.g. colds, flu, stomach upsets, migraines) | 2009-07-31 00:00:00 | 1
[NAME] | Minor Illnesses (e.g. colds, flu, stomach upsets, migraines) | 2009-10-02 00:00:00 | 1 |  |  | 187.5
[NAME] | Minor Illnesses (e.g. colds, flu, stomach upsets, migraines) | 2009-10-15 00:00:00 | 1
[NAME] | Minor Illnesses (e.g. colds, flu, stomach upsets, migraines) | 2009-10-16 00:00:00 | 1
[NAME] | Minor Illnesses (e.g. colds, flu, stomach upsets, migraines) | 2009-12-14 00:00:00 | 1
Spreadsheet: 767308d1644403894-need-help-to-get-the-count-based-on-criteria-sample-1
Sheet: Sheet4

Status | Count of Status
Didn't join after selection | 1
Duplicate | 2
No Show | 4
Not Interested | 9
Not Suitable | 4
Not Yet Scheduled | 2
Offer Accepted | 1
[NAME] | 2
Rejected (1st) | 14
Rejected (2nd) | 2
Scheduled | 2
Grand Total | 43
Spreadsheet: 05165766-85cd-47cb-b777-4f9fa87172f3
Sheet: 13d

 | Swap Dealers/MSPs4 |  |  | Others
Product1 | HY3 | IG | Other | HY | IG | Other
Index Tranche | 100227 | 906558 | 861118 | 27939 | 83327 | 118532
Europe | - | - | 853443 | - | - | 114273
North America/Asia | 100227 | 906558 | 7675 | 27939 | 83327 | 4259
Other | - | - | - | - | - | -
Index | 918856 | 3873468 | 6067648 | 465324 | 1805052 | 1650185
Asia | - | - | 186172 | - | - | 42129
Europe | - | - | 5228083 | - | - | 1467003
North America | 918856 | 3873468 | 184255 | 465324 | 1805052 | 62682
Other | - | - | 469138 | - | - | 78371
OTHER* | - | - | 579132 | - | - | 284626
TOTAL | 1019083 | 4780026 | 7507898 | 493263 | 1888379 | 2053343
*OTHER variable includes exotic credit products, swaptions, and total return swaps.
Spreadsheet: 763591d1642259297-count-occurrences-and-order-according-to-dates-ocurrency
Sheet: Range

Date | Ocurrency | Result
2021-01-01 00:00:00 | L
2021-01-02 00:00:00 | A
2021-01-03 00:00:00 | A
2021-01-04 00:00:00 | A
2021-01-05 00:00:00 | B
2021-01-06 00:00:00 | A
2021-01-07 00:00:00 | B
2021-01-08 00:00:00 | L
2021-01-09 00:00:00 | L
2021-01-10 00:00:00 | L
2021-01-11 00:00:00 | B
2021-01-12 00:00:00 | L
2021-01-13 00:00:00 | B
2021-01-14 00:00:00 | B
2021-01-15 00:00:00 | B | BA | B > 3. At least 4 B > A. Last Date A before first date B
2021-01-16 00:00:00 | L
2021-01-17 00:00:00 | A
2021-01-18 00:00:00 | A
2021-01-19 00:00:00 | L
2021-01-20 00:00:00 | B
2021-01-21 00:00:00 | B
2021-01-22 00:00:00 | B
2021-01-23 00:00:00 | L
2021-01-24 00:00:00 | L
2021-01-25 00:00:00 | L
2021-01-26 00:00:00 | L
2021-01-27 00:00:00 | A
2021-01-28 00:00:00 | A
2021-01-29 00:00:00 | A
2021-01-30 00:00:00 | A | AL | A > 3. At least 4 A > B. Last Date B before first date A
2021-01-31 00:00:00 | B
2021-02-01 00:00:00 | B
2021-02-02 00:00:00 | L
2021-02-03 00:00:00 | L
2021-02-04 00:00:00 | A
2021-02-05 00:00:00 | A
2021-02-06 00:00:00 | A
2021-02-07 00:00:00 | B
2021-02-08 00:00:00 | B
2021-02-09 00:00:00 | B
2021-02-10 00:00:00 | B
2021-02-11 00:00:00 | L
2021-02-12 00:00:00 | L
2021-02-13 00:00:00 | L
2021-02-14 00:00:00 | A | LT | B > 3. At least 4 B > A. But Last Date A was after last date B
2021-02-15 00:00:00 | A
2021-02-16 00:00:00 | A
2021-02-17 00:00:00 | A
2021-02-18 00:00:00 | L
2021-02-19 00:00:00 | L
2021-02-20 00:00:00 | A
2021-02-21 00:00:00 | A
2021-02-22 00:00:00 | B
2021-02-23 00:00:00 | B
2021-02-24 00:00:00 | B
2021-02-25 00:00:00 | B
2021-02-26 00:00:00 | L
2021-02-27 00:00:00 | L
2021-02-28 00:00:00 | L
2021-03-01 00:00:00 | B | LT | B and A > 3. But A=B