tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 723551d1615776995-how-filter-out-rows-where-the-end-date-does-not-immediately-preceed-current-record-example-9-
Sheet: Sheet1

Employee_id | LEAVE_START_DATE | LEAVE_END_DATE | Number of Days off | Total Num of Days |  | 1st case | 2nd case
12345 | 2010-03-23 00:00:00 | 2010-05-17 00:00:00 | 55
12345 | 2010-05-18 00:00:00 | 2012-12-20 00:00:00 | 947
12345 | 2012-12-21 00:00:00 | 2013-08-31 00:00:00 | 253
12345 | 2013-09-01 00:00:00 | 2021-03-05 00:00:00 | 2742 | 55 + 947 + 253 +2742
23456 | 2017-09-01 00:00:00 | 2018-08-31 00:00:00 | 364
23456 | 2018-09-01 00:00:00 | 2019-08-31 00:00:00 | 364
23456 | 2019-09-01 00:00:00 | 2020-08-31 00:00:00 | 365
23456 | 2020-09-01 00:00:00 | 2021-03-05 00:00:00 | 185 | 364 + 364 + 365 + 185
34567 | 2010-06-23 00:00:00 | 2010-08-31 00:00:00 | 69
34567 | 2010-09-01 00:00:00 | 2010-11-14 00:00:00 | 74
34567 | 2010-11-15 00:00:00 | 2011-01-13 00:00:00 | 59
34567 | 2011-01-14 00:00:00 | 2012-08-31 00:00:00 | 595
34567 | 2012-09-01 00:00:00 | 2021-03-05 00:00:00 | 3107 | 69 + 74 + 59 + 595 +3107
45678 | 1999-09-01 00:00:00 | 2000-08-31 00:00:00 | 365
45678 | 2000-09-01 00:00:00 | 2001-08-31 00:00:00 | 364
45678 | 2021-01-04 00:00:00 | 2021-03-05 00:00:00 | 60 | 60
56789 | 2019-02-19 00:00:00 | 2019-08-31 00:00:00 | 193
56789 | 2020-10-10 00:00:00 | 2021-03-05 00:00:00 | 146 | 146
Spreadsheet: 01b7c169-afb2-4cca-a0f7-81b56c28742a
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | [NAME] | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | [NAME] | Unnamed: 7 | Unnamed: 8
Vendor Number: |  |  |  |  |  | Number:
 |  |  |  |  |  | Date:
To:
Address
Ship to:
 | [NAME]
 | 34 Main Street
 | North Vernon, Indiana  47265
Ship via:
Charge to: |  |  |  | Appropriation Number:
Quantity | Unit | Description |  |  |  | Unit Price |  | Amount
Total Amount of Order: |  |  |  |  |  |  |  | 0
Ordered by: |  |  |  |  | Approved by:
 |  |  |  |  |  |  | Principal
Spreadsheet: 263531d1378506459-trying-to-create-a-spreadsheet-with-3-variables-dummy-worksheet-letter-names
Sheet: Sheet1

Date | Name | Letters Learned | 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
2013-09-02 00:00:00 | [NAME] |  | 1 | 0 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-09-02 00:00:00
2013-09-02 00:00:00 | [NAME] |  | 1 | 0 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | a | b | c
2013-09-02 00:00:00 | [NAME] |  | 1 | 1 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 1 | 0 | 1
2013-09-02 00:00:00 | [NAME] |  | 0 | 0 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 1 | 0 | 1
2013-09-09 00:00:00 | [NAME] |  | 1 | 0 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 1 | 1 | 0
2013-09-09 00:00:00 | [NAME] |  | 1 | 0 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 0 | 0 | 1
2013-09-09 00:00:00 | [NAME] |  | 1 | 1 | 0 | 1 | 1
2013-09-09 00:00:00 | [NAME] |  | 0 | 0 | 1 | 0 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-09-09 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 1 | 0 | 1 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 1 | 1 | 0 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 0 | 0 | 1 | 0 | 1
Spreadsheet: 714011d1611060342-formula-to-correctly-identify-the-answer-from-2-criteria-excel-q-incorrect-category
Sheet: Table

 | Mixed data |  | Northern Hemisphere
 | Hemisphere | Town | NH Town | NH Country | NH Hemisphere | Notes |  |  | Question | Excel is finding the first instance of the NH Town and correlating it with the country. How do I make sure the answer is true for "Town" and "Hemisphere" in the formula?
 | Southern | [NAME]
 | Northern | [NAME] |  |  |  | INCORRECT
 | Northern | Memphis
 | Southern | Windsor
 | Northern | Windsor |  |  |  | INCORRECT
 | Southern | [NAME]
 | Northern | [NAME] |  |  |  | INCORRECT
 | Northern | Memphis
 | Southern | Windsor
 | Northern | Windsor |  |  |  | INCORRECT
Spreadsheet: mary_fischer__25637__31T
Sheet: E20.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 031T
ANALYSIS OF OTHER INCOME AND DEDUCTIONS
EXTENSION: |  |  |  |  |  |  |  |  |  | E-20
[NAME] |  | 1ST QTR |  | 2ND QTR |  | 3RD QTR |  | 4TH QTR |  | YEAR TO DATE
OTHER INCOME - OTHER
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Total Other Income - Other
(MUST TIE TO HYPERION ACCOUNT 1690)
Income Accts:  DR/(CR)
Reverse signs from Hyperion
[NAME] |  | 1ST QTR |  | 2ND QTR |  | 3RD QTR |  | 4TH QTR |  | YEAR TO DATE
OTHER DEDUCTIONS - OTHER
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Total Other Deductions - Other
(MUST TIE TO HYPERION ACCOUNT 1775)
Asset/Expense Accts:  DR/(CR)
Same signs as Hyperion
 |  |  |  |  |  |  |  |  |  | E-20
Spreadsheet: 84903d1284998468-unsorted-lists-obtaining-the-value-only-once-even-if-repeated-pivot-example
Sheet: Sheet1

Test | Name
[NAME] | [NAME] |  |  |  |  |  |  |  |  | Steps
[NAME] | [NAME] |  |  |  | Test | [NAME]
[NAME] | [NAME] |  |  |  |  |  |  |  |  | Click inside cell A2
[NAME] | [NAME] |  |  |  | Count of Name
[NAME] | [NAME] |  |  |  | Name | Total |  |  |  | From Excel's menu bar, click on Data
 |  |  |  |  | [NAME] | 1
 |  |  |  |  | [NAME] | 2 |  |  |  | From the menu that drops down, click on PivotTable and PivotChart Report
 |  |  |  |  | [NAME] | 2
 |  |  |  |  | Grand Total | 5 |  |  |  | The Pivot Table wizard starts up
 |  |  |  |  |  |  |  |  |  | Just Click "Finish"
 |  |  |  |  |  |  |  |  |  | On the new Sheet that will appear, drag "Name" from the table on the right hand side of the screen to the "Row" section on the left
 |  |  |  |  |  |  |  |  |  | Now drag "Name" again from the Right to the "Data" Section
 |  |  |  |  |  |  |  |  |  | it should now show you the same as the pivot table in F3:G10 on this sheet.
Spreadsheet: 684368d1593334533-huge-data-to-be-converted-from-a-single-column-to-related-rows-test-2-
Sheet: Sheet1

[User]
uid=U000569
last_name=LastName1
first_name=FIRST
email_address=[EMAIL]
[User]
uid=u000679
last_name=[NAME]
first_name=Second
email_address=[EMAIL]
[User]
uid=U000832
last_name=LastName3
first_name=third
email_address=[EMAIL]
uid=U000569 | last_name=LastName1 | first_name=FIRST | email_address=[EMAIL]
uid=u000679 | last_name=[NAME] | first_name=Second | email_address=[EMAIL]
uid=U000832 | last_name=LastName3 | first_name=third | email_address=[EMAIL]
Spreadsheet: 804391d1668037293-formula-for-printing-all-sheets-xcvbtr10
Sheet: 6

 |  | [NAME])  YA MSHIRIKA T.A.G HERMON REVIVAL CHURCH |  |  |  |  |  |  |  |  | MWAKA
 |  | JINA KAMILI | WEEKS | JAN | FEB | [NAME] | APRIL | MAY | [NAME] | JULY | AUGU | SEPT | OKT | NOV | DEC | JUMLA
 |  | E | 1
 |  |  | 2
 |  |  | 3
 |  |  | 4
 |  |  | 5
 |  |  | JUMLA
Spreadsheet: 848292d1699031339-formula-help-find-a-match-from-one-column-to-another-sample-workbook
Sheet: Sheet1

Company Name | Company Name
IBM | Apple
AT&T | Costco
Coca Cola | Pepsi
Microsoft | McDonalds
Apple | [NAME]
Caterpillar | IBM
Goldman Sachs | Boeing
JP Morgan | Tesla
Costco | State Farm
Spreadsheet: 118434d1313684503-how-to-create-a-golf-schedule-scheduler-updated
Sheet: Sheet1

1 | [NAME] | [NAME] | [NAME] |  | [NAME] | 4
2 | [NAME] | [NAME] | Fred |  | [NAME] | 4
3 | George | [NAME] | Ian |  | [NAME] | 4
4 | [NAME] | [NAME] | [NAME] |  | [NAME] | 4
5 | [NAME] | Norm | [NAME] |  | [NAME] | 4
6 | [NAME] | Quentin | [NAME] |  | Fred | 4
7 | [NAME] | [NAME] | George |  | George | 4
8 | [NAME] | [NAME] | [NAME] |  | [NAME] | 4
9 | Fred | Ian | [NAME] |  | Ian | 4
10 | [NAME] | [NAME] | [NAME] |  | [NAME] | 4
11 | [NAME] | Norm | Quentin |  | [NAME] | 4
12 | [NAME] | [NAME] | [NAME] |  | [NAME] | 3
13 | [NAME] | [NAME] | Ian | [NAME] | [NAME] | 4
14 | [NAME] | Fred | George | [NAME] | Norm | 4
15 | [NAME] | [NAME] | [NAME] | Quentin | [NAME] | 3
16 | Norm | [NAME] |  |  | [NAME] | 3
17 | [NAME] | [NAME] | Fred | [NAME] | Quentin | 3
18 | [NAME] | [NAME] | George | [NAME]
19 | [NAME] | [NAME] | Ian | [NAME]
20 | [NAME] | Norm
Spreadsheet: 871118d1717559405-subtotals-filter-script-test-sheet-10-aligw
Sheet: Copy of TS-Contact Log

Contact Log: Owner Name |  | Contact Log: Contact Log Name | Date | Contact: Last Name | Contact: First Name | Contact Type | Contact: Active
AV |  | CL-3488 | 2024-01-16 00:00:00 | [NAME] | [NAME] | Closing Note | True
AV |  | CL-3499 | 2024-01-17 00:00:00 | [NAME] | [NAME] | File Note | True
AV |  | CL-3865 | 2024-02-15 00:00:00 | [NAME] | [NAME] | Voice Mail | True
AV |  | CL-3920 | 2024-02-27 00:00:00 | [NAME] | [NAME] | Voice Mail | True
LB |  | CL-3931 | 2024-02-28 00:00:00 | [NAME] | [NAME] | File Note | True
AV |  | CL-3983 | 2024-03-05 00:00:00 | [NAME] | [NAME] | File Note | True
AV |  | CL-4025 | 2024-03-18 00:00:00 | [NAME] | [NAME] | Closing Note | True
LB |  | CL-4071 | 2024-03-27 00:00:00 | [NAME] | [NAME] | Closing Note | True
LV |  | CL-3601 | 2024-01-16 00:00:00 | [NAME] | [NAME] | Referral Confirmation | True
LB |  | CL-3509 | 2024-01-17 00:00:00 | [NAME] | [NAME] | File Note | True
LV |  | CL-4226 | 2024-04-15 00:00:00 | [NAME] | George | Referral Confirmation | True
LB |  | CL-4249 | 2024-04-17 00:00:00 | [NAME] | George | File Note | True
SS |  | CL-3562 | 2024-01-23 00:00:00 | [NAME] | Ringo | Phone | True
SS |  | CL-4016 | 2024-03-15 00:00:00 | [NAME] | Ringo | Closing Note | True
LB |  | [NAME] | 2024-03-27 00:00:00 | [NAME] | Ringo | Closing Note | True
 |  | CL-4071 | 2024-03-27 00:00:00 | [NAME] | [NAME] | Closing Note | True
LB |  | CL-3509 | 2024-01-17 00:00:00 | [NAME] | [NAME] | File Note | True
LB |  | CL-4249 | 2024-04-17 00:00:00 | [NAME] | George | File Note | True
LB |  | [NAME] | 2024-03-27 00:00:00 | [NAME] | Ringo | Closing Note | True
Spreadsheet: 63164d1264102476-to-find-out-same-nearest-spelling-temp_avk
Sheet: Sheet1

NAME1 | FORUMA | NAME1 | MORE IF FORMULA REQUIRED
BAIG CONSTRUCTION CO | 1 | BAIG CONSTRUCTION CO | 0 | Hellow friends, I want in d2 to d19 formula for duplicate nearest name. Both all there is same name any formula to trace which is the nearest name in c2 to c19. I want result is true in d column. Or any other solution.
BAIG CONSTRUCTION CO | 1 | BAIG CONSTRUCTION COMPANY | 0
BENZOCHEM INDUSTRIES PVT.LTD | 1 | BENZOCHEM INDUSTRIES PVT LTD | 0
BENZOCHEM INDUSTRIES PVT.LTD | 1 | BENZOCHEM INDUSTRIES PVT.LTD | 0
CHANDAK CONSTRUCTION CO | 1 | CHANDAK CONSTRUCTION CO. | 0
CHANDAK CONSTRUCTION CO | 1 | CHANDAK CONSTRUCTION CO | 0
D.G.ADVANI HOSPITAL | 1 | D.G.ADWANI HOSPITAL | 0
D.G.ADVANI HOSPITAL | 1 | D.G.ADVANI HOSPITAL | 0
DHABE YASHWANT | 1 | YASHWANT DHABE | 0
DHABE YASHWANT | 1 | DHABE YASHWANT | 0
DURGA CONSTRUCTION COMPANY | 1 | DURGA CONSTRUCTION CO | 0
DURGA CONSTRUCTION COMPANY | 1 | DURGA CONSTRUCTION COMPANY | 0
EASYPACK SOFTWARE INC | 1 | EASYPACK SOFTWARE INC | 0
EASYPACK SOFTWARE INC | 1 | EASYPACK SOFTWARE INC. | 0
GIRISH GINNING & PRESSING MILL | 1 | GIRISH GINNING & PRESSING MILL LTD | 0
GIRISH GINNING & PRESSING MILL | 1 | GIRISH GINNING & PRESSING MILL | 0
SAMADHAN MARKETING | 1 | SAMADAN MARKETING | 0
SAMADHAN MARKETING | 1 | SAMADHAN MARKETING | 0
Spreadsheet: 708052d1607600961-what-formulas-should-i-use-to-bring-all-the-alternatives-listed-sample-2-
Sheet:  P S I 

 | Item: | [NAME] | AY25 | J990 | LALA1020
 | Alternatives: | Alternatives: | Alternatives: | Alternatives:
Spreadsheet: 826224d1681871220-formula-needed-to-calculate-lower-and-upper-limits-in-n-number-performance-levels-onditi-performance-levels
Sheet: Sheet1

 | Total Marks | Performance Level |  |  | [NAME] | Levels |  |  | Lower | Upper | Expected |  | Interval
[NAME] | 63 |  |  |  | 100 | 4 |  | Exceeding Expectation |  |  | 0 | 25
[NAME] | 26 |  |  |  |  |  |  | Meeting Expectation |  |  | 26 | 50
George | 84 |  |  |  |  |  |  | Approaching Expectation |  |  | 51 | 75
Ringo | 12 |  |  |  |  |  |  | Below Expectation |  |  | 76 | 100
Spreadsheet: 75372d1275946306-matching-multiple-values-against-multiple-values-worldcup_sort
Sheet: Sheet3

 |  |  |  | original row
 |  |  |  | hlookup
 |  |  |  | [NAME]
Spreadsheet: 714168d1611128413-code-to-combine-stock-item-details-new-items-list-retail-macro
Sheet: Sheet1

Column1 | Column2 | Column3 | Column4 | Column5
1 | AXE POLARIS DEODORANT | 10812000055 | ARGENTINA | 150 ML X 12
 | APOLLO
2 | AXE POLARIS DEODORANT | 10812000056 | ARGENTINA | 150 ML X 12
 | BLACK
3 | AXE POLARIS DEODORANT | 10812000015 | ARGENTINA | 150 ML X 12
 | BLACK NIGHT
4 | AXE POLARIS DEODORANT | 10812000057 | ARGENTINA | 150 ML X 12
 | COLLISION
5 | AXE POLARIS DEODORANT | 10012000041 | ARGENTINA | 150 ML X 12
 | DARK TEMPTATION
6 | AXE POLARIS DEODORANT | 10812000016 | ARGENTINA | 150 ML X 12
 | EXCITE
7 | AXE POLARIS DEODORANT | 10820000005 | ARGENTINA | 150 ML X 12
 | GOLD
8 | AXE POLARIS DEODORANT | 10812000058 | ARGENTINA | 150 ML X 12
 | MARINE
9 | AXE POLARIS DEODORANT | 10812000059 | ARGENTINA | 150 ML X 12
 | MUSK
10 | AXE POLARIS DEODORANT | 10812000022 | SOUTH | 150 ML X 72
 | DARK TEMPTATION |  | AFRICA
11 | AXE POLARIS DEODORANT | 10812000024 | SOUTH | 150 ML X 72
 | MUSK |  | AFRICA
12 | AXE POLARIS DEODORANT | 10812000026 | SOUTH | 150 ML X 72
 | WILD SPICE |  | AFRICA
13 | DOVE DEODORANT | 15212000082 | ARGENTINA | 150 ML X 12
 | ANTI BACTERIA ( M )
14 | DOVE DEODORANT | 15220000011 | ARGENTINA | 150 ML X 12
 | CLEAN COMFORT ( CUIDADO TOTAL ) M
15 | DOVE DEODORANT | 15220000012 | ARGENTINA | 150 ML X 12
 | EXTRA FRESH ( M )
Spreadsheet: 729100d1618913020-match-codes-from-file-1636-match-codes-from-file-master-code-list
Sheet: Test Sheet

 | Product No | Column B Product No located on Master Code List Row No | Next Row No on Master Code List | Product No on next Row No of Master Code List | Column E Product No located on Test Sheet Row No | Sweep Required? | comments
 | 050001 332210901
 | 522287 SPM |  |  |  |  |  | Shows as WASH in Master file, so cannot SWEEP
 | 580824 SPM
 | 508053 SPM
 | 534199 65SPM |  |  |  |  |  | Correct, Col B can SWEEP into Col E
 | 554274 [NAME] |  |  |  |  |  | Shows as WASH in Master file, so cannot SWEEP
 | 589674 CB
 | 589905 1CB
 | 513796 CB
 | 513140 1CB
 | 554628 1CB
 | 589682 CB
 | 871023 SPM
 | 523748 1CB
 | 581230 2CB
 | 513111 CB
 | 513310 CB
 | 589461 6CB
 | 589631 CBEU
 | 548168 CB
 | 548169 2CB
 | 585270 SPM
 | 050001 33229086
 | 585309 1SPM
 | 585289 2SPM
 | 534199 SPM
 | 543075 1CBGB
 | 575905 CB
 | 554097 CB
 | 554201 CB
 | 589817 6CB
 | 589105 SPM
 | 589659 CB
 | 588884 2CB
 | 513153 CB
 | 589858 3CB
 | 555385 CB
 | 579201 SPM
 | 579116 CBEU
 | 575765 SPM
 | 566060 SPM
 | 589206 CB
 | 554490 9CB
 | 513281 CB |  |  |  |  |  | Correct, Col B can SWEEP into Col E
 | 578496 1CBEU
 | 589092 CBEU
Spreadsheet: 526154d1499166049-automatically-sorting-dynamic-data-priorities
Sheet: Sheet1

Project | Priority Level | Priority Queue | Status |  |  | Project | Priority Level | Priority Queue | Status
Project 1 | ON HOLD | 2 | IN PROCESS |  |  | Project 8 | HIGH | 4 | IN PROCESS
Project 2 | LOW | 3 | [NAME] |  |  | Project 9 | HIGH | 5 | IN PROCESS
Project 3 | LOW | 10 | ON HOLD |  |  | Project 11 | LOW |  | IN PROCESS
Project 4 | MEDIUM | 10 | REQUIREMENT GATHERING |  |  | Project 10 | MEDIUM |  | IN PROCESS
Project 5 | LOW |  | [NAME] |  |  | Project 1 | ON HOLD | 2 | IN PROCESS
Project 6 | LOW |  | [NAME] |  |  | Project 7 | ON HOLD | 1 | IN PROCESS
Project 7 | ON HOLD | 1 | IN PROCESS |  |  | Project 12 | HIGH | 6 | REQUIREMENT GATHERING
Project 8 | HIGH | 4 | IN PROCESS |  |  | Project 4 | MEDIUM | 10 | REQUIREMENT GATHERING
Project 9 | HIGH | 5 | IN PROCESS |  |  | Project 3 | LOW | 10 | ON HOLD
Project 10 | MEDIUM |  | IN PROCESS |  |  | Project 13 | HIGH | 7 | [NAME]
Project 11 | LOW |  | IN PROCESS |  |  | Project 15 | HIGH | 9 | [NAME]
Project 12 | HIGH | 6 | REQUIREMENT GATHERING |  |  | Project 2 | LOW | 3 | [NAME]
Project 13 | HIGH | 7 | [NAME] |  |  | Project 5 | LOW |  | [NAME]
Project 14 | MEDIUM |  | [NAME] |  |  | Project 6 | LOW |  | [NAME]
Project 15 | HIGH | 9 | [NAME] |  |  | Project 14 | MEDIUM |  | [NAME]
Spreadsheet: 9c753d7a-aa69-4b58-9ade-ddff9bef0f36
Sheet: Keyword-Pivot

Keywords
ACCESS CONTROL
AIR COMPRESSOR
AIR CONDITIONING UNIT
AIR DRYER
AIR HANDLING UNIT
AUTOCLAVE
BACKFLOW PREVENTER
BATTERY
BLEACHERS
BLINDS
BOILER
BURNER
CASCADE SYSTEM
CHILLED BEAM
CHILLER
COIL
CONTROLS
CONVEYANCE
[NAME]
DAMPER
DEFIBRILLATOR
DEHUMIDIFIER
DOCK EQUIPMENT
DOOR
DUST COLLECTOR WOOD, WELDING
ELECTRICAL SYSTEM
ELECTRICAL, CARBON MONOXIDE SYSTEM
EMERGENCY GENERATOR
EMERGENCY PHONE
EMERGENCY WASH STATION
ENERGY RECOVERY UNIT
ENVIRONMENTAL CHAMBER
FACILITY RECORD
FAN
FILTRATION
FIRE ALARM
FIRE EXTINGUISHER
FIRE HYDRANT PRIVATE
FIRE SUPPRESSION SYSTEM
FIREESCAPE
FIREPLACE
FUME HOOD
FURNACE
GAS SYSTEM, MEDICAL, LAB, ETC.
[NAME]
HEAT EXCHANGER
HEATER
HEPA UNIT
HOT WATER HEATER
HUMIDIFIER
[NAME]
ICEMAKER
LIGHTING
LIGHTNING PROTECTION
LOUVERS
METER
MONITORING SYSTEM
MOTORS
PH NEUTRALIZATION SYSTEM
PRESSURE VESSEL
PUMP
RAINWATER RECLAMATION SYSTEM
REFRIGERATION
REVERSE OSMOSIS DISTILLED WATER
SCREEN
SOLAR SYSTEM
SOOT BLOWER
STEAM GENERATOR
STEAM TRAP
STRAINERS AND SEPARATORS
TANK
TERMINAL UNITS
TRANSFORMER
VALVE
VARIABLE FREQUENCY DRIVE
WASHER
WATER SAMPLE COOLER
WATER SOFTNER
WATER SOURCE HEAT PUMP
WATER TREATMENT
CHIMNEY
CLOCKS, BELLS AND TIMERS
DRAIN
FIELD
HEAT RECOVERY UNIT
HEAT RECOVERY WHEEL
IRRIGATION
KEY CONTROL BOX
MANHOLE
MASONRY SYSTEMS
ROOF
TREE
VEHICLE
Spreadsheet: 456079d1460637762-vlookup-with-multiple-input-and-multiple-output-lorenzo-exemple
Sheet: Sheet1

Input
[NAME]
Region | Category | Capex (total project value)
[NAME] | SBS | 600000 |  | <--- It will take all the autorisation levels below 600 and the first above and list in ascending order
Output
Name | Comment | Finace BP | Proc BP
[NAME] | Earth | F BP 3 | IP BP 2
[NAME] | Water | F BP 2 | IP BP 2
Lorenzo | Fire | F BP 1 | IP BP 1
REGION | Category | AUTHORISTATION (UP TO) | NAME | SCOPE | comment | F BP | IP BP | FUNCTION
[NAME] | SBS | 1000000 | Lorenzo | Text A 1 | Fire | F BP 1 | IP BP 1 | Text B 1
[NAME] | SBS | 500000 | [NAME] | Text A 2 | Water | F BP 2 | IP BP 2 | Text B 2
[NAME] | SBS | 100000 | [NAME] | Text A 3 | Earth | F BP 3 | IP BP 2 | Text B 3
EAME | CPG | 500000 | Lorenzo | Text A 4 | Sky | F BP 3 | IP BP 3 | Text B 4
EAME | CPG | 200000 | Giulio | Text A 5 | Wind | F BP 4 | IP BP 4 | Text B 5
Spreadsheet: 30ca09e0-2a82-4c85-b2f7-39877b310851
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | OWS-8 Cost Sharing Funds Request Form | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 |  | Company Name Here
Labor Funding Request |  |  |  |  |  | Running Total
Function or Task | WBS Task | Assigned Personnel | [NAME] | Projected Labor Hours | Task Funding Request
Write GetView spec | WBS 4.2.1 Item 3 | Sr. Software Eng. | 50 | 100 | 5000
Modify brand x client to support with GetView | WBS 4.2.1 Item 4 | Assoc. Software Eng. | 30 | 150 | 4500
 |  | Expand form as needed
 |  | Group costs by thread, if responding to multiple threads
Total Labor |  |  |  |  | 9500 | 9500
Grand Total Cost Share Funds Request |  |  |  |  | 9500
Spreadsheet: 835812d1688842467-using-countifs-and-unique-unique-values
Sheet: Sheet1

Existing /New | Person | Sale Date | [NAME] |  | [NAME] | Existing/New | Sale Date From | Sale Date To | Customer Numbers | Total Transactions
New | [NAME] | 2022-10-07 00:00:00 | Good1 |  | [NAME] | Existing | 2022-10-01 00:00:00 | 2023-12-31 00:00:00
New | [NAME] | 2022-10-22 00:00:00 | jerv1
Existing | Mandy | 2022-10-15 00:00:00 | simp1
Existing | [NAME] | 2022-11-03 00:00:00 | Good1
New | Mandy | 2022-10-21 00:00:00 | mora1
Existing | [NAME] | 2022-10-20 00:00:00 | Good1
New | Mandy | 2022-11-11 00:00:00 | Link2
Existing | [NAME] | 2022-10-30 00:00:00 | Good1
New | [NAME] | 2022-11-12 00:00:00 | Loca4
New | [NAME] | 2022-11-11 00:00:00 | Hell3
New | Mandy | 2022-11-04 00:00:00 | Dale2
Existing | Mandy | 2022-11-10 00:00:00 | mora1
Existing | [NAME] | 2022-12-09 00:00:00 | simp1
Existing | Mandy | 2022-12-21 00:00:00 | Link2
Existing | [NAME] | 2022-12-26 00:00:00 | mora1
Spreadsheet: 113293d1309253018-currency-rate-between-from-to-date-sample
Sheet: RATE

DAILY TRANS |  |  |  |  |  |  |  | MASTER [NAME] RATE
Date | Currency | Rate | Amount | Base Amount |  |  |  | DATE FROM | DATE TO | CURRENCY | RATE
2011-01-03 00:00:00 | USD |  | 1000 |  |  |  |  | 2011-01-03 00:00:00 | 2011-01-09 00:00:00 | AUD | 9142.51
2011-01-04 00:00:00 | USD |  | 1000 |  |  |  |  | 2011-01-03 00:00:00 | 2011-01-09 00:00:00 | EUR | 11955.79
2011-01-05 00:00:00 | EUR |  | 1000 |  |  |  |  | 2011-01-03 00:00:00 | 2011-01-09 00:00:00 | USD | 8991
2011-01-06 00:00:00 | USD |  | 1000 |  |  |  |  | 2011-01-10 00:00:00 | 2011-01-16 00:00:00 | AUD | 8950.705
2011-01-07 00:00:00 | AUD |  | 1000 |  |  |  |  | 2011-01-10 00:00:00 | 2011-01-16 00:00:00 | EUR | 11717.015
2011-01-08 00:00:00 | USD |  | 1000 |  |  |  |  | 2011-01-10 00:00:00 | 2011-01-16 00:00:00 | USD | 9002
2011-01-09 00:00:00 | EUR |  | 1000 |  |  |  |  | 2011-01-17 00:00:00 | 2011-01-23 00:00:00 | AUD | 9027.305
2011-01-10 00:00:00 | EUR |  | 1000 |  |  |  |  | 2011-01-17 00:00:00 | 2011-01-23 00:00:00 | EUR | 12082.775
2011-01-11 00:00:00 | USD |  | 1000 |  |  |  |  | 2011-01-17 00:00:00 | 2011-01-23 00:00:00 | USD | 9064
2011-01-12 00:00:00 | AUD |  | 1000 |  |  |  |  | 2011-01-24 00:00:00 | 2011-01-30 00:00:00 | AUD | 8939.34
2011-01-13 00:00:00 | USD |  | 1000 |  |  |  |  | 2011-01-24 00:00:00 | 2011-01-30 00:00:00 | EUR | 12233.105
2011-01-14 00:00:00 | USD |  | 1000 |  |  |  |  | 2011-01-24 00:00:00 | 2011-01-30 00:00:00 | USD | 9075
2011-01-15 00:00:00 | EUR |  | 1000 |  |  |  |  | 2011-01-31 00:00:00 | 2011-02-06 00:00:00 | AUD | 8936.895
2011-01-17 00:00:00 | AUD |  | 1000 |  |  |  |  | 2011-01-31 00:00:00 | 2011-02-06 00:00:00 | EUR | 12381.105
2011-01-24 00:00:00 | USD |  | 1000 |  |  |  |  | 2011-01-31 00:00:00 | 2011-02-06 00:00:00 | USD | 9034
2011-01-24 00:00:00 | EUR |  | 1000 |  |  |  |  | 2011-02-07 00:00:00 | 2011-02-13 00:00:00 | AUD | 9197.52
2011-01-31 00:00:00 | USD |  | 1000 |  |  |  |  | 2011-02-07 00:00:00 | 2011-02-13 00:00:00 | EUR | 12316.93
 |  |  |  |  |  |  |  | 2011-02-07 00:00:00 | 2011-02-13 00:00:00 | USD | 9030
 |  |  |  |  |  |  |  | 2011-02-14 00:00:00 | 2011-02-20 00:00:00 | AUD | 8936.81
 |  |  |  |  |  |  |  | 2011-02-14 00:00:00 | 2011-02-20 00:00:00 | EUR | 12137.685
 |  |  |  |  |  |  |  | 2011-02-14 00:00:00 | 2011-02-20 00:00:00 | USD | 8931
 |  |  |  |  |  |  |  | 2011-02-21 00:00:00 | 2011-02-27 00:00:00 | AUD | 8958.115
 |  |  |  |  |  |  |  | 2011-02-21 00:00:00 | 2011-02-27 00:00:00 | EUR | 12043.34
 |  |  |  |  |  |  |  | 2011-02-21 00:00:00 | 2011-02-27 00:00:00 | USD | 8858
 |  |  |  |  |  |  |  | 2011-02-28 00:00:00 | 2011-03-06 00:00:00 | AUD | 8957.66
 |  |  |  |  |  |  |  | 2011-02-28 00:00:00 | 2011-03-06 00:00:00 | EUR | 12236.895
 |  |  |  |  |  |  |  | 2011-02-28 00:00:00 | 2011-03-06 00:00:00 | USD | 8858
Spreadsheet: 02e4b555-05a6-40f8-a00e-8401a50136eb
Sheet: 3

 | Jan 11 | Jan 18 | Jan 25 | Feb 1 | Feb 8
Total Interest Rate* | N/A*** | N/A | N/A | N/A | N/A
Cleared** | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Cross-Currency | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Credit | 2360139 | 2354931 | 2371959 | 2375235 | 2363068
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Equity | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Other Commodity | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
TOTAL | N/A | N/A | N/A | N/A | N/A
Weekly snapshot, net notional amount outstanding by asset class and cleared status (millions of USD), all products, tenors, and participant types.
*See Data Dictionary for asset class descriptions.
**See Explanatory Notes for cleared and uncleared descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].