tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: louise_kitchen__24093__NEWCO HEADCOUNT NAMES
Sheet: Regulatory

Regulatory |  |  | ok
Comnes | [NAME] | West Power | Director
Yeung | [NAME] | ERCOT | Director
[NAME] | [NAME] |  | Director | 3
Calcagno | Suzanne |  | Manager | 1
[NAME] | [NAME] | West | Sr. Director
Nicolay | Christi |  | Sr. Director
[NAME] | [NAME] |  | Sr. Director
Novosel | [NAME] |  | Sr. Director | 4
Montovano | [NAME] | East Gas | Vice Pres | 1
 |  |  | TOTAL | 9
Spreadsheet: 676029d1588614412-search-a-number-in-a-sentence-sample-20-05-04
Sheet: Sample

 | Hello Experts, I need help please, I need a formula to search a number in a sentence. Example: In row 1, I will search a number that is greater than 50 (50 can be change anytime by the user from -100 to 300), so the answer is 150, 100, 75 & 201. The formula will be applicable from row 1 to row 5. In row 4, the answer is 135, 160 & 165. Thank you, [NAME] | Lag ([NAME]): | -10
A | B | VBA | TextJoin
Row 1 | PE4620: PH 150, CE2110: AC -4, [NAME]: DC 5, ME2220: KL 100, ECE4310: CA 75, CM5620: UK 201, PM1100: AB 2 | 0;0;150;0;0;-4;0;0;5;0;0;100;0;0;75;0;0;201;0;0;2 | 0;0;0;0;0;0;0;0
Row 2 | CE2110: AC 50, CM5620: UK 250, ECE4310: CA 85, [NAME]: DC 6, ME2220: KL -3, PE4620: PH 75 | 0;0;50;0;0;250;0;0;85;0;0;6;0;0;-3;0;0;75 | 0;0;0;0;0;0;0;0
Row 3 | PM1100: AB 1, PE4620: PH -5, ME2220: KL 140, EE3110: DC 95, ECE4310: CA 200, CE2110: AC 3 | 0;0;1;0;0;-5;0;0;140;0;0;95;0;0;200;0;0;3 | 0;0;0;0;0;0;0;0
Row 4 | EE3110: DC 135, ME2220: KL -9, CM5620: UK 165 | 0;0;135;0;0;-9;0;0;165 | 0;0;0;0;0;0;0;0
Row 5 | PM1100: AB -19, CE2110: AC 90, ECE4310: CA 210, PE4620: PH 30 | 0;0;0;0;90;0;0;210;0;0;30 | 0;0;0;0;0;0;0;0
Spreadsheet: 859725d1708001566-two-upper-and-two-lower-numbers-average-cartel-2019-2-rules-dj
Sheet: Foglio1

 |  |  | 45
 |  |  | 60 |  |  |  |  | 6
 |  |  | 15 |  |  |  |  | 12
 |  |  | 92 |  |  |  |  | 15
 |  |  | 121 |  |  |  |  | 18
 |  |  | 12 |  |  |  |  | 19
 |  |  | 28 |  |  |  |  | 22
 |  |  | 87 |  |  |  |  | 28
 |  |  | 6 |  |  |  |  | 34
 |  |  | 56 |  |  |  |  | 41 |  |  | 41
 |  |  | 78 |  |  |  |  | 45
 |  |  | 19 |  |  |  |  | 56
 |  |  | 2 |  |  |  |  | 60 |  |  | 60
 |  |  | 41 |  |  |  |  | 66
 |  |  | 66 |  |  |  |  | 78
 |  |  | 94 |  |  |  |  | 87
 |  |  | 34 |  |  |  |  | 92
 |  |  | 22 |  |  |  |  | 94
 |  |  | 18 |  |  |  |  | 121
 |  |  |  |  | Average = 47.15
Spreadsheet: 219bb193-7118-459e-9ca4-a494a82a3510
Sheet: Cycle

Mangle until it hits, shred to 5 CP, rip
Number of mangles to hit
Combo points from mangle
Number of shreds to reach 4 CP
Number of shreds to reach 5 CP
Number of rips to hit
Time between rip and mangle
Time between mangle and endshred |  | not an accurate average bc it's capped below
 | Count | Energy | Damage | DPE | % damage
Mangle
Shred
[NAME]
[NAME] |  | 0
Cycle
Cycle time
Mangle uptime (rip)
Mangle uptime (shred)
Cycle DPS
Spreadsheet: 1ef50df9-fd95-4868-9812-e00d22eb4d07
Sheet: 13a

Product1 | Cleared2 | Uncleared | TOTAL
Index Tranche | - | 1047295 | 1047295
Asia | - | 20 | 20
Europe | - | 478614 | 478614
North America | - | 568661 | 568661
Other | - | - | -
Index | 2191268 | 5418277 | 7609545
Asia | - | 129410 | 129410
Europe | 917371 | 2564866 | 3482237
North America | 1255104 | 2450236 | 3705340
Other | 18793 | 273765 | 292558
Other | - | 627457 | 627457
Exotic | - | 55409 | 55409
Swaptions | - | 571728 | 571728
Total Return Swap | - | 320 | 320
TOTAL | 2191268 | 7093029 | 9284297
Spreadsheet: 755217d1636725139-nearest-coordinates-3d-distance-surveyor-forum-1
Sheet: Sheet1

DESIGN |  |  |  |  | SURVEY
Id | X | Y | Z |  | ID | X | Y | Z
V4 | 1997.082 | 6023.74 | 19.646 |  | PT001.1 | 1976.647116 | 6005.177557 | 19.652581
V7 | 1994.621 | 6023.299 | 19.64 |  | PT001.2 | 1977.0646 | 6006.7925 | 16.9092
V9 | 1993.015 | 6022.864 | 19.648 |  | PT001.3 | 1977.0646 | 6006.7925 | 19.6542
V15 | 1988.403 | 6020.92 | 19.638 |  | PT001.4 | 1977.4528 | 6007.9881 | 16.9091
V17 | 1986.792 | 6019.954 | 19.636 |  | PT001.5 | 1977.4528 | 6007.9881 | 19.6541
V21 | 1984.151 | 6017.914 | 18.779 |  | PT001.6 | 1977.980703 | 6009.342911 | 19.654937
V22 | 1984.143 | 6017.912 | 19.637 |  | PT001.7 | 1978.687 | 6010.858811 | 19.655
V27 | 1980.8906 | 6014.3947 | 19.6454 |  | PT001.8 | 1979.93911 | 6013.027871 | 19.655
V29 | 1979.9293 | 6013.0326 | 19.6391 |  | PT001.9 | 1980.897 | 6014.394811 | 19.655
V32 | 1978.685 | 6010.863 | 24.046 |  | PT001.10 | 1984.1534 | 6017.9178 | 19.6533
V34 | 1977.977 | 6009.343 | 24.046 |  | PT001.11 | 1984.1539 | 6017.9181 | 18.7983
V36 | 1977.452 | 6007.993 | 24.067 |  | PT001.12 | 1986.794792 | 6019.944708 | 19.652556
V36 | 1977.4381 | 6007.9841 | 19.6625 |  | PT001.13 | 1988.399492 | 6020.918273 | 19.654615
V37 | 1977.064 | 6006.796 | 24.034 |  | PT001.14 | 1993.006818 | 6022.874324 | 19.655404
V38 | 1977.065 | 6006.793 | 19.633 |  | PT001.15 | 1994.61929 | 6023.307041 | 19.655
V39 | 1976.642 | 6005.181 | 24.028 |  | PT001.16 | 1997.085 | 6023.741811 | 19.655
Spreadsheet: 780996d1652925060-using-filter-to-show-visible-cells-sample-workbook
Sheet: LOG

REFERENCE | SURNAME | SALES PERSON | DATE RECEIVED
123 | SMITH | [NAME] | 2022-02-01 00:00:00
124 | DIXON | PAUL | 2022-02-02 00:00:00
125 | EBERT | MARK | 2022-02-03 00:00:00
126 | LOBB | PAUL | 2022-02-04 00:00:00
127 | GREY | [NAME] | 2022-02-05 00:00:00
128 | HAYES | [NAME] | 2022-05-19 00:00:00
129 | [NAME] | PAUL | 2022-05-19 00:00:00
130 | GEORGE | MARK | 2022-05-18 00:00:00
Spreadsheet: michael_maggi__26465__NYMEXWEEKLY
Sheet: hu

Week Ending: | 2001-10-19 00:00:00
 | Futures Settlement Prices
 | UNLEADED GASOLINE |  |  |  |  | Contract Symbol:  [NAME]
 | Contract | Monday | Tuesday | Wednesday | Thursday | Friday | Open
 | Month | 2001-10-15 00:00:00 | 2001-10-16 00:00:00 | 2001-10-17 00:00:00 | 2001-10-18 00:00:00 | 2001-10-19 00:00:00 | Interest
 | 2001-11-01 00:00:00 | 0.5971 | 0.5902 | 0.5802 | 0.5673 | 0.5952 | 25731
 | 2001-12-01 00:00:00 | 0.6047 | 0.5964 | 0.5863 | 0.5737 | 0.5985 | 25287
 | 2002-01-01 00:00:00 | 0.6132 | 0.6049 | 0.5953 | 0.5837 | 0.607 | 10762
 | 2002-02-01 00:00:00 | 0.6227 | 0.6144 | 0.6053 | 0.5947 | 0.6165 | 5813
 | 2002-03-01 00:00:00 | 0.6327 | 0.6249 | 0.6158 | 0.6057 | 0.627 | 9286
 | 2002-04-01 00:00:00 | 0.6952 | 0.6869 | 0.6773 | 0.6672 | 0.6865 | 10233
 | 2002-05-01 00:00:00 | 0.7002 | 0.6919 | 0.6828 | 0.6736 | 0.6915 | 8595
 | 2002-06-01 00:00:00 | 0.6977 | 0.6894 | 0.6808 | 0.6726 | 0.6895 | 6511
 | Total Weekly Volume
 |  |  | 127618 |  | Total Open Interest |  | 110153
 |  |  |  | Weekly volume and open interest reflects all traded months.
 | Historical Volatility-Spot Month Futures
 |  |  |  | Unleaded Gas
 | 5 Day Hist. Vol. |  |  | 0.5295
 | 20 Day Hist. Vol. |  |  | 0.4415
 | Implied Volatility-Options |  |  | Unleaded Gas
 | At the Money Call & Put |  |  | 0.4692
Spreadsheet: 211928d1359992347-pull-data-based-on-day-of-week-from-another-workbook-for-previous-three-weeks-salesreport2013
Sheet: 0112

 | Date: | 2013-01-12 00:00:00
 | Day
 | Time | Trans. | Total Sales | Avg. Sales
 | 09:00:00 | 0 | 0
 | 10:00:00 | 8 | 34.96
 | 11:00:00 | 41 | 256.93
 | 12:00:00 | 68 | 486.36
 | 13:00:00 | 78 | 508.42
 | 14:00:00 | 57 | 388.18
 | 15:00:00 | 36 | 234.37
 | 16:00:00 | 46 | 303
 | 17:00:00 | 32 | 247.02
 | 18:00:00 | 41 | 351.88
 | 19:00:00 | 20 | 166.32
 | 20:00:00 | 21 | 98.67
 | 21:00:00 | 15 | 125.01
 | 22:00:00 | 38 | 237.54
 | 23:00:00 | 28 | 169.42
 | 1900-01-01 00:00:00 | 23 | 176.42
 | 1900-01-01 01:00:00 | 13 | 96.7
 | 1900-01-01 02:00:00 | 9 | 69.45
 | 1900-01-01 03:00:00 | 0 | 0
 | 04:00:00 | 0 | 0
 | Total
Spreadsheet: 217060d1361978511-use-multiple-sheets-to-display-and-edit-data-sample-data
Sheet: Sheet1

33261 |  | [NAME] | 2013-01-21 00:00:00 | PRS | PRS/57744 04 | MAC ID labels & Serial Number labels don't match | George | B |  | 2013-01-22 00:00:00 | 2013-01-22 00:00:00 | 2013-01-22 00:00:00 | 2013-01-22 00:00:00 | 2013-02-25 00:00:00 | 35
33262 |  | [NAME] saqqa | 2013-01-24 00:00:00 | ALP | ALP/B1109 00 | [NAME] | Yeary/George | B |  | 2013-01-28 00:00:00 | 2013-02-25 00:00:00 | 2013-02-25 00:00:00 | 2013-02-25 00:00:00 | 2013-02-25 00:00:00 | 32
33263 |  | [NAME] | 2013-01-24 00:00:00 | ALP | ALP/B1109 00 | Solder bridging | [NAME] | B |  | 2013-01-24 00:00:00 |  |  |  |  | 34
33264 |  | [NAME] | 2013-01-28 00:00:00 | NSW | NSW/750-614-020 D | [NAME] placed on the wrong side | Yeary | B |  | 2013-01-28 00:00:00 | 2013-01-28 00:00:00 | 2013-01-28 00:00:00 | 2013-01-28 00:00:00 | 2013-01-28 00:00:00 | 0
33265 |  | K Hearndon | 2013-01-29 00:00:00 | PRS | PRS/65483 06 | [NAME] | [NAME] | B |  | 2013-02-04 00:00:00 |  |  |  |  | 29
33266 |  | [NAME] saqqa | 2013-02-07 00:00:00 | DBI | DBI/10029326 D | Q7 & Q9 | George | A |  |  |  |  |  |  | 20
33267 |  | [NAME] | 2013-02-13 00:00:00 | STP | STP/GG79-TRI 010 | [NAME] and ANT2 continuity test | Yeary |  |  | 2013-02-18 00:00:00 | 2013-02-22 00:00:00 | 2013-02-22 00:00:00 | 2013-02-22 00:00:00 | 2013-02-25 00:00:00 | 12
33268 |  | [NAME] saqqa | 2013-02-13 00:00:00 | BRT | BRT/RP-CB-A 0.04 | SW1 & SW2 placed backward | Yeary | A |  | 2013-02-18 00:00:00 | 2013-02-18 00:00:00 | 2013-02-18 00:00:00 | 2013-02-18 00:00:00 | 2013-02-18 00:00:00 | 5
33269 |  | [NAME] | 2013-02-13 00:00:00 | DBI | [NAME] | wrong resistor installed on 15 boards | Thibodeau | A |  | 2013-02-18 00:00:00 | 2013-02-18 00:00:00 | 2013-02-18 00:00:00 | 2013-02-18 00:00:00 | 2013-02-18 00:00:00 | 5
33270 |  | [NAME] | 2013-02-25 00:00:00 | NSW | NSW/750-614-020 D | U7 either wrong part or bad date code |  |  |  |  |  |  |  |  | 2
33271 |  | [NAME] | 2013-02-26 00:00:00 | SDC | SDC/MSD30AG 4 | Serial# label not scanning |  |  |  |  |  |  |  |  | 1
-
-
Spreadsheet: 045141a7-f30e-4ecf-856e-c4128624cbb3
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | IMPERIAL COMMUNITY COLLEGE DISTRICT | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 |  |  |  | TRAVEL REQUEST & EXPENSE STATEMENT
Name:
Attendance At:
Destination:
Date/Time Departing: |  |  |  | Date/Time Returning:
Part 1: EXPENSES |  |  |  |  |  | EXPENSES
Transportation |  |  |  |  |  | Estimated | Actual
Public Carrier
 | Airline, etc
Rental Vehicle |  | days |  | Rental car rate |  | 0
 |  |  |  |  |  |  | estimated rates if rented locally:  $40 Compact, $50 Midsize, $60 Full-size, $100 [NAME]
 | ** rental cars rates will be higher if rented outside Imperial County **
Rental pick-up: |  |  | Return:
 | Date | Time |  | Date | Time
IVC vans |  | miles @ | 0.68 | 8 passenger [NAME] |  | 0
 |  | miles @ | 0.68 | 11 passenger [NAME] |  | 0
 |  | miles @ | 0.68 | 15 passenger [NAME] |  | 0
Private Vehicle | Round trip mileage |  | IRS mileage rate
 |  | miles @ | eff. 1/1/14 | 0.56 |  | 0
Lodging |  |  |  |  |  |  |  |  | `
Registration
Other
Meals                Dates:
Breakfast $7
Lunch $10 |  |  |  |  |  | Meals
Dinner $18 |  |  |  |  |  | Estimated | Meals
Total Estimated | 0 | 0 | 0 | 0 | 0 | 0 | Actual
Total Actual | 0 | 0 | 0 | 0 | 0
 |  |  | Total estimated expense |  |  | 0
Part 2: APPROVALS FOR TRAVEL
Department Head |  | Date |  | President/VP/Dean |  |  | Date
Part 3:REIMBURSEMENT OF ACTUAL EXPENSES |  |  |  |  |  |  | Reimbursement Amount
Claimant |  | Claimant |  |  |  |  | (receipts required except for meals)
Department approval if estimate exceeded
 |  | Fund | Org | Acct | Prog | Estimated | Actual
 |  |  |  |  | Total | 0 | 0
Spreadsheet: 465565d1465757221-pivot-table-help-book45-amended-v2
Sheet: Helper col pivot

Region | (All)
Customer | Apple House
Red KPI | All KPI
Project Mgr | Red
[NAME] | 3
[NAME] T | 15
[NAME] A | 28
Laurne L | 14
[NAME] O | 17
[NAME] | 8
Ricky R | 17
Sundeep T | 6
Grand Total | 108
Spreadsheet: 150754d1334675428-find-and-list-corresponding-values-in-a-column-in-descending-order-descending-order
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB
 |  |  |  |  |  |  |  |  |  |  |  | 0.02021212727636582 | 0.07064238543125875 | 0.05263157894736842 | 0.08044826896137683 | 0.1420852511506904 | 0.06283770262157294 | 0.05143085851510906 | 0.1364818891334801 | 0.1060636381829097 | 0.0278166900140084 | 0.01681008605163098 | 0.05663398038823294 | 0.07164298579147488 | 0.03702221332799679 | 0.004802881729037423 | 0.002201320792475486 | 0.008805283169901942 | 0.01821092655593356 | 0.01600960576345807 | 0.009405643386031618 | 0.0006003602161296778 | 0 | 0.00100060036021613 | 0.001801080648389033 | 0.001600960576345807 | 0.001600960576345807 | 0.00100060036021613 | 0
 |  |  |  |  |  |  |  |  |  |  |  | .
 |  |  |  |  |  |  |  |  |  |  |  | .
 |  |  |  |  |  |  |  |  |  |  |  | .
 |  |  |  |  |  |  |  |  |  |  |  | .
 |  |  |  |  |  |  |  |  |  |  |  | .
 |  |  |  |  |  |  |  |  |  |  |  | .
Spreadsheet: 62181d1263171436-excel-2007-common-data-filtering-dummy-workbook
Sheet: Sheet1

Agent A
 | Company A | AA112
 | Company B | AA115
 | Company C | AA119
 | Company D | AA253
 | Company D | AA253
 | Company E | BB118
 | Company E | [NAME]
 | Company F | DD126
 | Company F | DD127
 | [NAME] | BB145
 | Compnay H | CC846
 | Company I | BB257
 | Company J | EE123
 | Company K | DD167
 | Company K | DD167
Spreadsheet: 144029d1330690753-excel-2007-military-time-and-count-if-question-response-time-summary
Sheet: By Truck

 | Total | WRT | % | Total | WRT | % | Total | WRT | % | Total | WRT | % | Total | WRT | %
 | PA-1 |  |  | PA-2 |  |  | PA-3 |  |  | PA-4 |  |  | PA-5
A | 3 | 3 | 100 | 3 | 3 | 100 | 1 | 0 | 0 | 1 | 1 | 100 | 1 | 1 | 100
B | 0 | 0 | #N/A | 1 | 1 | 100 | 1 | 1 | 100 | 1 | 1 | 100 | 0 | 0 | #N/A
C | 2 | 1 | 50 | 1 | 1 | 100 | 5 | 2 | 40 | 1 | 1 | 100 | 1 | 1 | 100
D | 4 | 4 | 100 | 1 | 1 | 100 | 0 | 0 | #N/A | 0 | 0 | #N/A | 0 | 1 | #N/A
E | 0 | 0 | #N/A | 0 | 0 | #N/A | 0 | 0 | #N/A | 0 | 0 | #N/A | 0 | 0 | #N/A
O | 0 | 0 | #N/A | 2 | 2 | 100 | 1 | 1 | 100 | 0 | 0 | #N/A | 0 | 0 | #N/A
Spreadsheet: 880492d1728295828-formula-to-make-breakdown-of-amount-per-category-09-sept-2024-copy
Sheet: Sheet1

 |  | A |  |  | B
Posting Date | Transa. Date | Description | 0 | 0 | AMOUNT | 0 | Bank Charges | Status
 |  | BOOK  YR8LVB4HV2 | 0 | 0 | 652 | 0 | 0
 |  | SETTLEMENT 063CC17949624 | 0 | 0 | 30000 | 0 | 0
 |  | WORK 730911645REF | 0 | 0 | 828.86 | 0 | 0
 |  | WORK 730950956REF | 0 | 0 | 2024.06 | 0 | 0
 |  | BOOK  TJ2HB9UQB2 | 0 | 0 | 497.99 | 0 | 0
 |  | BOOK  SC39CACRB2 | 0 | 0 | 1390.26 | 0 | 0
 |  | ZOOM US [PHONE] | 0 | 0 | 70.9 | 0 | 0
 |  | PAAT 45635 | 0 | 0 | 5000 | 0 | 0
 |  | WORK 732674900REF | 0 | 0 | 2024.06 | 0 | 0
 |  | WORK 732901931REF | 0 | 0 | 404.71 | 0 | 0
 |  | WORK 733456928REF | 0 | 0 | 2024.11 | 0 | 0
 |  | MASA E0700TREHT | 0 | 0 | 834.3 | 0 | 0
 |  | MASA E0700TRR8K | 0 | 0 | 2329.84 | 0 | 0
 |  | BOOK  SH7HAAYQB2 | 0 | 0 | 486.25 | 0 | 0
 |  | BOOK 3DR4394RB2 | 0 | 0 | 779.9 | 0 | 0
 |  | WORK 735240332REF | 0 | 0 | 2833.53 | 0 | 0
 |  | BOOK [PHONE] | 0 | 0 | 23.06 | 0 | 0
 |  | BOOK  BU8M894RB2 | 0 | 0 | 394.47 | 0 | 0
 |  | BOOK  S9ED994RB2 | 0 | 0 | 478.32 | 0 | 0
 |  | BOOK 72RGE94RB2 | 0 | 0 | 656.32 | 0 | 0
 |  | BOOK  N7EJ5ACQB2 | 0 | 0 | 900 | 0 | 0
 |  | BOOK  W984PFQQB2 | 0 | 0 | 500.43 | 0 | 0
 |  | BOOK  JADGM94RB2 | 0 | 0 | 900 | 0 | 0
 |  | WORK 736969210REF | 0 | 0 | 242.82 | 0 | 0
 |  | BOOK  MW5ZBAGQB2 | 0 | 0 | 900 | 0 | 0
 |  | BOOK  L8RMXFQQB2 | 0 | 0 | 900 | 0 | 0
 |  | WORK 737654109REF | 0 | 0 | 2225.52 | 0 | 0
 |  | MOOD US [PHONE] | 0 | 0 | 49.58 | 0 | 0
 |  | BOOK  L3SUSACQB2 | 0 | 0 | 835.65 | 0 | 0
 |  | WORK 737865840REF | 0 | 0 | 272.07 | 0 | 0
 |  | BOOK  J6FJCGQQB2 | 0 | 0 | 690.1 | 0 | 0
 |  | WORK 739362482REF | 0 | 0 | 1839.77 | 0 | 0
 |  |  |  | Total =
 |  |  |  |  |  |  | Breakdowns | Make formula to make The break down Here
 |  |  |  |  |  |  | BOOK | formula here
 |  |  |  |  |  |  | WORK | formula here
 |  |  |  |  |  |  | MASA | formula here
 |  |  |  |  |  |  | MOOD | formula here
 |  |  |  |  |  |  | PAAT | formula here
 |  |  |  |  |  |  | SETTLEMENT | formula here
 |  |  |  |  |  |  | G. Total =
 |  |  |  |  |  |  | Diff
Spreadsheet: frank_ermis__11198__1114
Sheet: Export

[NAME] | [NAME] | Deal No. | Originator | Broker | Type | Deal Date | Status | Brk | Stmt | CP | Trd | Retro | Quantity | Comm | Delivery Ref | Index | Beg Date | End Date | N | Premium | Price | Broker Fee
Enron North America Corp. | BP Corporation North America Inc. | YJ5038.1 | Kuykendall | Prebon Energ | Swap | 2001-11-14 00:00:00 | New deal | No | No | No | No | N | 5000 [NAME]/day | NG | IF-ELPO/SJ | NX1 | 2002-04-01 00:00:00 | 2002-10-31 00:00:00 | F |  | US -0.3650 | 267.5
Aquila Risk Management Corporation | Enron North America Corp. | YJ3212.1 | May [NAME] | GFI Group  I | OPT/Put | 2001-11-14 00:00:00 | New deal | No | Yes | No | No | N | 10000 MMBtu/day | NG | IF-NWPL_ROCKY_M | NX1 | 2001-12-01 00:00:00 | 2002-03-31 00:00:00 | F | 0.12 | US -0.6000 | 605
Aquila Risk Management Corporation | Enron North America Corp. | YJ4056.1 | May [NAME] | GFI Group  I | OPT/Put | 2001-11-14 00:00:00 | New deal | No | No | No | No | N | 10000 MMBtu/day | NG | IF-NWPL_ROCKY_M | NX1 | 2001-12-01 00:00:00 | 2002-03-31 00:00:00 | F | 0.09 | US -0.6000 | 605
Aquila Risk Management Corporation | Enron North America Corp. | YJ4132.1 | May [NAME] | GFI Group  I | OPT/Put | 2001-11-14 00:00:00 | New deal | No | No | No | No | N | 20000 MMBtu/day | NG | IF-NWPL_ROCKY_M | NX1 | 2001-12-01 00:00:00 | 2002-03-31 00:00:00 | F | 0.08 | US -0.6000 | 1210
Spreadsheet: 836005d1689038521-excel-formula-for-merge-duplicate-data-and-sum-the-value-qmedical-supplies-sherina-
Sheet: Stock Out

Date | Stand No. | Item Name | Item Code No. | Quantity
 |  | Crepe Bandage 5cm | 131230010 | 15
 |  | Crepe Bandage 5cm | 131230010 | 20
 |  | Crepe Bandage 5cm | 131230010 | 36
 |  | Crepe Bandage 7.5cm | 131230012 | 45
 |  | [NAME] | 131230013 | 11
 |  | [NAME] 15cm | 131230014 | 10
 |  | Crepe Bandage 5cm | 131230010 | 12
 |  | Crepe Bandage 5cm | 131230010 | 14
 |  | Crepe Bandage 5cm | 131230010 | 11
 |  | Crepe Bandage 7.5cm | 131230012 | 10
 |  | [NAME] | 131230013 | 15
 |  | [NAME] 15cm | 131230014 | 12
Spreadsheet: 746026d1630439350-choosing-text-based-on-numbers-sample
Sheet: Sheet1

Current Status: | Requires Improvement |  |  | 0 | No
 | Action Plan Area
 | Finance | H&S | MCA | Governance | Care Outcomes | Medication | Engagement | Staffing | Other | Total | Total remaining
High Risk | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Number Completed | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Inadequate
Number Validated | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
% Completed
% Validated
Return to Good | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Number Completed | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Requires Improvement
Number Validated | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
% Completed
% Validated
Good to Outstanding | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Number Completed | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Good
Number Validated | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
% Completed
% Validated
Overdue | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 844251d1695993338-help-to-calculate-trend-book2-11-
Sheet: Sheet1

 |  | Type | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 2023-01-01 00:00:00 |  |  |  |  | Rate of chagne |  | ABS( R ) | slope (per day) | multiply by 30,5
 |  | Bananas | 233 | 206 | 191 | 182 | 170 | 156 | 151 | 134 | 129 | 113 | 107 | 0 | 0
 |  | Bananas | 310 | 249 | 205 | 192 | 176 | 162 | 158 | 138 | 136 | 118 | 112 | 0 | 0
 |  | Bananas | 188 | 156 | 130 | 119 | 110 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Bananas | 157 | 128 | 110 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Bananas | 278 | 280 | 275 | 272 | 268 | 260 | 255 | 242 | 230 | 221 | 206 | 199 | 192
 |  | Bananas | 2000 | 1987 | 1975 | 1966 | 1950 | 1928 | 1893 | 1845 | 1765 | 1685 | 1597 | 1493 | 1391
 |  | Bananas | 564 | 558 | 555 | 551 | 547 | 541 | 536 | 531 | 509 | 484 | 458 | 430 | 396
 |  | Bananas | 624 | 619 | 618 | 615 | 610 | 602 | 594 | 582 | 557 | 539 | 511 | 475 | 448
 |  | Bananas | 1522 | 1523 | 1521 | 1496 | 1457 | 1424 | 1397 | 1347 | 1298 | 1240 | 1198 | 1149 | 1103
 |  | Bananas | 237 | 236 | 235 | 235 | 233 | 232 | 230 | 224 | 218 | 211 | 203 | 191 | 174
 |  | Bananas | 358 | 354 | 347 | 344 | 334 | 331 | 327 | 316 | 309 | 296 | 289 | 283 | 272
 |  | Bananas | 291 | 288 | 285 | 282 | 280 | 278 | 275 | 273 | 268 | 266 | 258 | 248 | 243
 |  | Bananas | 196 | 201 | 199 | 198 | 194 | 191 | 191 | 189 | 186 | 185 | 183 | 181 | 179
 |  | Bananas | 855 | 853 | 852 | 850 | 845 | 839 | 835 | 830 | 822 | 815 | 810 | 802 | 787
 |  | Bananas | 936 | 988 | 1019 | 1032 | 1025 | 1015 | 1006 | 992 | 982 | 971 | 966 | 961 | 955
 |  | Bananas | 933 | 985 | 1036 | 1041 | 1034 | 1026 | 1021 | 1016 | 1002 | 990 | 981 | 974 | 964
 |  | Bananas | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 105 | 143
 |  | Bananas | 207 | 264 | 315 | 367 | 421 | 479 | 514 | 595 | 614 | 635 | 648 | 656 | 662
 |  | Bananas | 136 | 179 | 228 | 268 | 311 | 377 | 410 | 447 | 480 | 491 | 488 | 484 | 484
 |  | Bananas | 0 | 0 | 0 | 0 | 176 | 233 | 297 | 386 | 459 | 511 | 573 | 637 | 711
 |  | Bananas | 0 | 0 | 0 | 0 | 157 | 253 | 326 | 443 | 526 | 584 | 640 | 685 | 768
 |  | Bananas | 0 | 0 | 0 | 109 | 223 | 280 | 320 | 428 | 488 | 585 | 663 | 733 | 799
Spreadsheet: 753377d1635405851-grouping-by-column-and-outputting-specific-value-in-formula-animalexample
Sheet: Sheet1

Col1 | Col2 | Col3 | ExpectedResult |  | Animal
Topo1 | Animal | Dog | Dog
Topo1 | Car | VW | Dog
Topo1 | Computer | Asus | Dog
Topo1 | Color | Green | Dog
Topo2 | Animal | [NAME] | [NAME]
Topo2 | Color | Black | [NAME]
Spreadsheet: 875941d1722561052-ranking-based-on-two-columns-wwar-2-
Sheet: Size vs Items (2)

cubic | # of items | cubic * 1000 vs # of items / 1000 | cubic * 10 vs # of items / 10 | cubic * 80% vs # of items * 20%
59.672758111 | 37 |  |  |  |  | The weightage you give will severely affect the ranking when # of items is significantly higher than cubic.
59.672758111 | 15 | 2 | 2 | 3
47.4050031 | 55 | 3 | 3 | 4
36.671006944 | 21 | 4 | 4 | 7
24.155722125 | 20 | 5 | 5 | 8
24.155722125 | 7 | 6 | 6 | 9
21.477591556 | 87 | 7 | 8 | 5
21.477591556 | 82 | 8 | 9 | 6
21.099016204 | 226 | 9 | 7 | 1
Spreadsheet: 725131d1616550018-calendar-date-update-by-year-24-03-2021-calendar-by-year-update
Sheet: 2022

 | Payroll Calendar 2022
2021-06-03 00:00:00
 | Sun | Mon | Tue | Wed | Thu | Fri | Sat |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat
 | Sun | Mon | Tue | Wed | Thu | Fri | Sat |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat
 | Sun | Mon | Tue | Wed | Thu | Fri | Sat |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat
 | Sun | Mon | Tue | Wed | Thu | Fri | Sat |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat
Spreadsheet: 160014d1338928196-calculation-the-proportional-distribution-option-ratio-calculations
Sheet: Sheet1

 |  | Total Investment
 |  | 5000
Call Allocation |  |  |  | Put Allocation
 | Call |  | Put
Price | 59 |  | 60
Delta | 0.0759 |  | 0.0544
 |  | Ratio
# Calls |  |  |  | # Puts
 | Call Delta |  | Put Delta |  |  | Delta Diff
Spreadsheet: 844645d1696399454-formula-for-text-string-listing-number-of-each-type-of-room-in-a-property-property-room-schedule
Sheet: Sheet1

Property address | Window reference | Room reference | Room type |  | Property address |  | Text string
1 Acacia Avenue | W1 | R1 |  |  | Value | [NAME] | Example text (formula required)
1 Acacia Avenue | [NAME] |  | Living room |  |  |  | 1 living room, 1 kitchen, 2 bedrooms
1 Acacia Avenue | W3 | R2 | Kitchen |  | 3 Acacia Avenue |  | 1 living room, 1 utility room, 2 bedrooms, 1 bathroom
1 Acacia Avenue | W4 | R3 | Bedroom
1 Acacia Avenue | W5 | R4
1 Acacia Avenue | W6 |  | Bedroom
3 Acacia Avenue | W1 | R1
3 Acacia Avenue | [NAME] |  | Living room
3 Acacia Avenue | W3 | R2 | Utility room
3 Acacia Avenue | W4 | R3 | Bedroom
3 Acacia Avenue | W5 | R4 | Bathroom
3 Acacia Avenue | W6 | R5 | Bedroom
Notes:
Columns C has some blank cells
Columns D contains formulae that returns some blanks.