tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 855468d1705020258-drop-down-reference-to-different-sheet-cells-weekly-recap
Sheet: Sheet2

 | Date Range | Sales | Traffic | SRC | Manager [NAME] | [NAME] | SOS DT | SOS FC | Overall Satisfaction | Mystery Shop | Waste | Labor
Week 1 | 12/27/2023-1/2/2024 | 91607 | 8776 | 0.014 | 6.17 | 8.23 | 01:47:00 | 01:50:00 | 0.818 | 1 | 1.18
Week 2 | 1/3/2024-1/9/2024 | 115320 | 10933 | 0.142 | 14.59 | 21.93 | 01:42:00 | 01:57:00 | 0.813 | 1 | 1.39
Week 3 | 1/10/2024-1/16/2024 | 21222
Week 4 | 1/17/2024-1/23/2024
Week 5 | 1/24/2024-1/30/2024
Week 6 | 1/31/2024-2/6/2024
Week 7 | 2/7/2024-2/13/2024
Week 8 | 2/14/2024-2/20/2024
Week 9 | 2/21/2024-2/27/2024
Week 10 | 2/28/2024-3/5/2024
Week 11 | 3/6/2024-3/12/2024
Week 12 | 3/13/2024-3/19/2024
Week 13 | 3/20/2024-3/26/2024
Week 14
Week 15
Week 16
Week 17
Week 18
Week 19
Week 20
Week 21
Week 22
Week 23
Week 24
Week 25
Week 26
Week 27
Week 28
Week 29
Week 30
Week 31
Week 32
Week 33
Week 34
Week 35
Week 36
Week 37
Week 38
Week 39
Week 40
Week 41
Week 42
Week 43
Week 44
Week 45
Week 46
Week 47
Week 48
Week 49
Week 50
Week 51
Week 52
Spreadsheet: 357076d1415294315-average-of-averages-with-if-averages
Sheet: Sheet1

AVR RPE | From | To | AVR RPE | From | To | AVR RPE | From | To | AVR RPE | From | To | AVR RPE | From | To | AVR RPE | From | To | AVR RPE | From | To | AVR RPE | From | To | AVR RPE | From | To
 | 0.1 | 1.4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
Date | Time | Average HR | Date | Time | Average HR | Date | Time | Average HR | Date | Time | Average HR | Date | Time | Average HR | Date | Time | Average HR | Date | Time | Average HR | Date | Time | Average HR | Date | Time | Average HR
Spreadsheet: 744406d1629222653-stop-an-instance-of-a-formula-repeating-plot-schedule-to-correct-semis-as-one-unit
Sheet: Plot Output

 | No of Plots | Plot Number | Plot Type
 |  |  |  |  | output needed in the Plot Number Column | output needed in the Plot Type  Column
 |  |  |  |  | 7 - 9 | The Coppersmith M4(2) - The Cobbler M4(2) - The mason
 |  |  |  |  | 10 - 13 | The Joiner - The Joiner - The Lymner - The Lymner
 |  |  |  |  | 14 - 18 | The Cobbler - The Cutler - The Blacksmith - The Blacksmith - The Thespian
Spreadsheet: 163874d1340519755-date-wise-itemwise-inventory-daywise-inward
Sheet: Daily Inward

Daily Inward
Sr No. | Date | Month | Item Name | [NAME] | Qty
1 | 19 | June | Powder | Minearal bros | 19240
 | 19 | June | Powder | Abc supplier | 4130
 | 13 | June | Powder | Minearal bros | 20200
 | 23 | June | Chemical | supplier A | 18312
 | 22 | June | Firewood | Abc supplier | 13720
 | 23 | June | Firewood | Abc supplier | 10660
 | 23 | June | Firewood | Abc supplier | 5370
8 | 23 | June | Powder | Minearal bros | 9000
Spreadsheet: 688916d1596020962-dependent-lists-based-on-multiple-not-unique-table-columns-dependentlists-3-
Sheet: Sheet1

 |  |  |  |  |  |  | Expected Result
 |  | Division | App | Function
 |  | Game | Baden | 8
 |  | Game | deRamblr | 7 |  |  | Division | App | Function
 |  | Game | Five Labs | 5 |  |  | Xbox | Baden | 7
 |  | Game | Hackrr | 6 |  |  | New | Hackrr
 |  | Game | Kryptis | 1
 |  | Game | Kryptis | 1
 |  | Game | Kryptis | 2 |  |  |  |  | 7
 |  | Game | Kryptis | 3
 |  | Game | Pes | 9
 |  | New | Blend | 1
 |  | New | Blend | 1
 |  | Xbox | Baden | 4
 |  | Xbox | Baden | 4
 |  | Xbox | Baden | 5
 |  | Division
 |  | App
 |  | Function
 | 1
 |  |  | Arcade | 8
Spreadsheet: 266469d1379620825-use-selections-from-two-data-validation-lists-to-lookup-and-return-a-combined-result-state-county-fips-codes
Sheet: NEW JERSEY-29

 | COUNTY | CODE
 | Atlantic | 1
 | Bergen
 | Burlington
 | Camden
 | Cape
 | Cumberland
 | Essex
 | Gloucester
 | Hudson
 | [NAME]
 | Mercer
 | Middlesex
 | Monmouth
 | Morris
 | Ocean
 | Passaic
 | Salem
 | Somerset
 | Sussex
 | Union
 | [NAME]
Spreadsheet: louise_kitchen__22633__SepQTD Orig w notes Faith
Sheet: Midwest

Midwest Origination
For the Quarter Ended September 30
By Team
Originator |  | Commodity |  | Team |  | Total |  | %Total
Valderama |  | Power |  | Midwest Orig
Sewell |  | Power |  | Midwest Orig |  | 65500
Wheeler |  | Power |  | Midwest Orig |  | 8800
Baughman |  | Power |  | Midwest Orig |  | 2640
Total
Spreadsheet: thomas_martin__39870__ubs Jan 28
Sheet: By Job Type

 |  | Overall Total
 |  | Origination & Structuring
 |  | Trading & Support
 |  | Name | Rating | Role |  | Name | Rating | Role | Notes |  | Name | Rating | Role | Notes |  | Name | Rating | Role | Notes
 | 1 | [NAME] |  | MD Origination | 1 | [NAME] |  | MD Trading |  | 1 | [NAME] |  | Projects & Fundamentals |  | 1 | [NAME] |  | Scheduling & Projects
 | 1 | [NAME] |  | Coordinator | 1 | TJ Black |  | Coordinator |  | 1 | [NAME] |  | Projects |  | 1 | [NAME] |  | Scheduling | Midwest
 |  |  |  |  | 1 | Claudia Guerra |  | Assistant |  |  |  |  |  |  | 1 | [NAME] |  | Scheduling | Midwest
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | [NAME] |  | Scheduling | North East
 |  |  |  |  | 1 | [NAME] |  | VP | Mid/SE | 1 | [NAME] |  | Physical | Mid/SE | 1 | [NAME] |  | Scheduling | South East
 | 1 | [NAME] |  | ER Origination | 1 | [NAME] |  | Cash | Mid/SE | 1 | [NAME] |  | Physical | Mid/SE | 1 | Smith Day |  | Scheduling | [NAME]
 | 1 | [NAME] |  | ER Origination | 1 | [NAME] |  | Cash | Mid/SE | 1 | [NAME] |  | Physical | Mid/SE
 | 1 | Edith Cross |  | ER Origination | 1 | [NAME] |  | Term | Mid/SE | 1 | [NAME] |  | Physical | Mid/SE | 1 | [NAME] |  | Fundamentals | Coordinator
 | 1 | [NAME] |  | MW Origination | 1 | [NAME] |  | Cash | Mid/SE | 1 | [NAME] |  | Physical | Mid/SE | 1 | [NAME] |  | Fundamentals | Model & Trans
 | 1 | [NAME] |  | MW Origination |  |  |  |  |  | 1 | [NAME] Seely |  | Physical | Mid/SE | 1 | [NAME] |  | Fundamentals | Forecasting
 | 1 | [NAME] |  | NE Origination | 1 | [NAME] |  | VP | North East |  |  |  |  |  | 1 | [NAME] |  | Fundamentals | Core - NE
 | 1 | [NAME] |  | NE Origination | 1 | [NAME] |  | Term | North East | 1 | [NAME] |  | Physical | North East | 1 | Gulay [NAME] |  | Fundamentals | Assists Rika
 | 1 | [NAME] |  | NE Origination | 1 | [NAME] |  | Cash | North East | 1 | [NAME] |  | Physical | North East | 1 | [NAME] |  | Fundamentals | Ercot Front Line
 | 1 | [NAME] |  | SE Origination |  |  |  |  |  | 1 | [NAME] |  | Physical | North East | 1 | Gustavo Giron |  | Fundamentals | MW/SE Front Line
 | 1 | [NAME] |  | SE Origination |  |  |  |  |  | 1 | [NAME] |  | Physical | North East
 | 1 | [NAME] |  | SE Origination | 1 | [NAME] |  | VP | [NAME]
 |  |  |  |  | 1 | [NAME] |  | Term | [NAME] |  |  |  |  |  | 1 | [NAME] |  | Fundamentals IT | MOS, PI & EMS
 | 1 | [NAME] |  | ER Gas | 1 | [NAME] |  | Cash | [NAME] | 1 | [NAME] |  | Physical | [NAME] | 1 | [NAME] |  | Fundamentals IT | Databases
 | 1 | [NAME] |  | ER Gas |  |  |  |  |  | 1 | [NAME] |  | Physical | [NAME] | 1 | [NAME] |  | Fundamentals IT | Web site
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | [NAME] |  | Fundamentals IT | Misc items
 |  |  |  |  | 1 | [NAME] |  | VP | Options
 | 1 | [NAME] |  | Structuring | 1 | [NAME] |  | OPT | Options |  |  |  |  |  | 1 | [NAME] |  | Weather
 | 1 | [NAME] |  | Structuring | 1 | [NAME] |  | OPT | Options |  |  |  |  |  | 1 | [NAME] |  | Weather
Spreadsheet: 097f49f2-7d77-4969-84b5-2d90b664570a
Sheet: Sheet1

Table 2 -- Sugarbeet crop conditions in various States, 2012/13. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
State | Date | Very poor | Poor | Fair | Good | Excellent
 |  |  | ------- Percent -----------
Colorado | 2012-07-10 00:00:00 | 4 | 7 | 34 | 44 | 11
 | 2012-07-03 00:00:00 | 1 | 8 | 36 | 40 | 15
 | 2012-06-26 00:00:00 | 0 | 9 | 33 | 48 | 10
 | 2012-06-19 00:00:00 | 0 | 8 | 25 | 57 | 10
 | 2012-06-12 00:00:00 | 0 | 6 | 17 | 61 | 16
 | 2012-06-05 00:00:00 | 0 | 6 | 24 | 56 | 14
Minnesota | 2012-07-10 00:00:00 | 1 | 2 | 19 | 66 | 12
 | 2012-07-03 00:00:00 | 1 | 2 | 19 | 64 | 14
 | 2012-06-26 00:00:00 | 0 | 2 | 21 | 66 | 11
 | 2012-06-19 00:00:00 | 1 | 2 | 21 | 67 | 9
 | 2012-06-12 00:00:00 | 1 | 2 | 20 | 68 | 9
 | 2012-06-05 00:00:00 | 1 | 4 | 25 | 63 | 7
North Dakota | 2012-07-10 00:00:00 | 3 | 4 | 27 | 55 | 11
 | 2012-07-03 00:00:00 | 0 | 1 | 16 | 67 | 16
 | 2012-06-26 00:00:00 | 0 | 1 | 11 | 65 | 23
 | 2012-06-19 00:00:00 | 0 | 1 | 15 | 64 | 20
 | 2012-06-12 00:00:00 | 0 | 2 | 20 | 67 | 11
 | 2012-06-05 00:00:00
Wyoming | 2012-07-10 00:00:00 | 0 | 1 | 43 | 50 | 6
 | 2012-07-03 00:00:00 | 0 | 1 | 43 | 50 | 6
 | 2012-06-26 00:00:00 | 0 | 1 | 43 | 50 | 6
 | 2012-06-19 00:00:00 | 0 | 0 | 45 | 49 | 6
 | 2012-06-12 00:00:00 | 0 | 0 | 42 | 56 | 2
 | 2012-06-05 00:00:00 | 0 | 0 | 40 | 58 | 2
Source: USDA, NASS, Weekly Weather and Crop Bulletin State Stories.
Spreadsheet: 55190d1255362018-creating-several-data-input-cells-after-you-input-the-number-of-cells-neede-creatingcells
Sheet: Sheet1

# of Owners | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16
1 | 1
3 | 0.3 | 0.35 | 0.35
6
8
7
Spreadsheet: 743828d1628760112-speedometer-issue-gauge-for-excel-forum-ans
Sheet: Credit Gauge

 | Name | Stats Total |  | Tier | Stats Minimum |  |  | Pointer |  | Level Labels | Level Values |  | NOTE
 | Credit Score | 1100 |  | Poor | 180 |  | Start |  |  | 500 | 100 |  | Formula in I3 changed
 |  |  |  | Average | 180 |  | [NAME] | 6 |  |  | 100 |  | For K column 50 should not be added add from L column.
 |  |  |  | Good | 180 |  | End |  |  |  | 100 |  | Custom data label for the needle is linked to C3
 |  |  |  | Excellent | 180 |  |  |  |  |  | 100
 |  |  |  | Super Excellent | 180 |  |  |  |  |  | 100
 |  |  |  | Total |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  |  |  |  | Custom data label for the needle is linked to C3
Spreadsheet: 798325d1664425534-unpivot-columns-without-power-query-unpivot-columns-without-power-query
Sheet: Sheet1

Province | City #1 | City #2 | City #3 | City #4 | City #5 |  |  |  | Desired Result in Dynamic Array WITHOUT Power Query
Ontario | Toronto | Ottawa | Kingston
British Columbia | Vancouver | Victoria | [NAME] | [NAME] |  |  |  |  | Province | City |  | Province | City
Alberta | Edmonton | Calgary |  |  |  |  |  |  | Ontario | Toronto
Quebec | Montreal |  |  |  |  |  |  |  | Ontario | Ottawa
 |  |  |  |  |  |  |  |  | Ontario | Kingston
 |  |  |  |  |  |  |  |  | British Columbia | Vancouver
 |  |  |  |  |  |  |  |  | British Columbia | Victoria
 |  |  |  |  |  |  |  |  | British Columbia | [NAME]
 |  |  |  |  |  |  |  |  | British Columbia | [NAME]
 |  |  |  |  |  |  |  |  | Alberta | Edmonton
 |  |  |  |  |  |  |  |  | Alberta | Calgary
 |  |  |  |  |  |  |  |  | Quebec | Montreal
Spreadsheet: scott_neal__37935__STOR9820
Sheet: STOR951

ENRON CAPITAL & TRADE RESOURCES |  |  |  |  |  |  |  |  |  |  |  |  |  | Confidential - For Internal Use Only
STORAGE UPDATE |  |  |  |  |  |  |  |  |  |  |  |  |  |  | File: STOR9820
Below is a summary of the estimated storage working gas levels
for the week ending: |  |  | 2001-02-23 00:00:00
 |  | Gas In Stg | Gas in | Quantity | Percent | Percent |  |  |  |  | Last Year | Three | Five | Quantity | Quantity | Quantity
 |  | Prev Week | Storage | Change | Change | of Full |  |  |  |  | Same | Year | Year | Change From | Change From | Change From
U.S. Region |  | (Bcf) | (Bcf) | from last week | from last week | Capacity |  |  |  |  | Week | Average | Average | last year | 3 year avg. | 5 year avg.
Production Area |  | 257 | 242
(TX, LA, OK, KS, MS)
Market Area - East |  | 537 | 456
Market Area - West |  | 166 | 161
TOTAL U.S.
MONTH TO DATE
Enron Gas Services |  |  | 36.2 | 0 | 0 | 0.924 |  |  |  |  | ECTR is refilling [NAME] as third parties
(as of 1/20/95) |  |  |  |  |  |  |  |  |  |  |  |  |  | are withdrawing, this keeping our
 |  |  |  |  |  |  |  |  |  |  |  |  |  | total position flat for the week.
AGA FULL CAPACITY |  |  | 3294 |  |  |  |  |  |  |  |  |  |  | 3294 | 3294 | 3294
Maximum Gas In Stg Level (Bcf) |  |  | 3127 |  |  |  |  |  |  |  |  |  |  | 3127 | 2832 | 2915
Minimum Gas In Stg Level (Bcf) |  |  | 831 |  |  |  |  |  |  |  |  |  |  | 1006 | 794 | 871
Spreadsheet: 690775d1597292194-vlookup-does-not-help-me-mani-copy
Sheet: Sheet1

Table 1
PR | PO | value
10074943 | [PHONE] | ?
10074943 | [PHONE] | ?
10102331 | [PHONE] | ?
10102331 | [PHONE] | ?
10102331 | [PHONE] | ?
Table 2
PO | value
[PHONE] | 0.068
[PHONE] | 0.024
[PHONE] | 5
[PHONE] | 0
[PHONE] | 0
Spreadsheet: 862965d1710517678-calendar-formulas-and-conditional-formatting-annual-calendar
Sheet: March

 |  |  |  |  |  |  |  |  | MAR
 | NOTES
Spreadsheet: 810089d1671540801-application-lookup-and-count-formulas-lookup-and-count-problem
Sheet: CALCULATION

 |  | Return all the values of 4 items with respect to a particular date
 |  | D | S | A | F
 | 2022-12-01 00:00:00 |  |  |  |  |  | The formula I use for uniform interval of rows of every dates.
 | 2022-12-02 00:00:00
 | 2022-12-03 00:00:00 |  |  |  |  |  | But, the row number is variable in Data sheet
 | 2022-12-04 00:00:00
 | 2022-12-05 00:00:00 |  |  |  |  |  | How can I go through the reference cells |  |  |  | of all respective dates to count 4 items (D,S,A, and F)?
 | 2022-12-06 00:00:00
 | 2022-12-07 00:00:00
 | 2022-12-08 00:00:00
 | 2022-12-09 00:00:00
 | 2022-12-10 00:00:00
 | 2022-12-11 00:00:00
 | 2022-12-12 00:00:00
 | 2022-12-13 00:00:00
 | 2022-12-14 00:00:00
 | 2022-12-15 00:00:00
 | 2022-12-16 00:00:00
 | 2022-12-17 00:00:00
 | 2022-12-18 00:00:00
 | 2022-12-19 00:00:00
 | 2022-12-20 00:00:00
 | 2022-12-21 00:00:00
 | 2022-12-22 00:00:00
 | 2022-12-23 00:00:00
 | 2022-12-24 00:00:00
 | 2022-12-25 00:00:00
 | 2022-12-26 00:00:00
 | 2022-12-27 00:00:00
 | 2022-12-28 00:00:00
 | 2022-12-29 00:00:00
 | 2022-12-30 00:00:00
 | 2022-12-31 00:00:00
Spreadsheet: hunter_shively__12726__EOL Customers
Sheet: Top 50 Customers

TOP 50 CUSTOMER LIST
Customer Responsibility Breakdown:
East:         Frank Vickers
West:        [NAME]
Price:        [NAME]
Texas:      [NAME]
Central:     Laura Luce
Derivative:  [NAME]
*Note:  The numbers in each column denote the phase that each region has rated a counterparty.  An "x" denotes no ranking by the group but that they
have been chosen to talk with this particular counterparty.
COUNTERPARTY NAME | East | West | Price | Texas | Central | Derivatives
Aquila Risk Management Corporation
AEP Energy Services, Inc.
Sempra Energy Trading Corp.
Dynegy Marketing and Trade
Duke Energy Trading and Marketing, L.L.C.
Entergy-Koch Trading, LP |  |  |  |  |  | x
Calpine Energy Services, L.P.
El Paso Merchant Energy, L.P.
Mirant Americas Energy Marketing, L.P.
Reliant Energy Services, Inc.
Conectiv Energy Supply, Inc.
Coral Energy Holding L.P. |  |  |  |  |  | x
Constellation Power Source, Inc.
BP Corporation North America Inc.
Hess Energy Trading Company LLC
J. Aron & Company |  |  |  |  |  | x
Cinergy Marketing & Trading, LLC |  |  |  |  |  | x
Williams Energy Marketing & Trading Company |  |  |  |  |  | x
PG&E Energy Trading-Gas Corporation
Tractebel Energy Marketing, Inc.
Virginia Power Energy Marketing, Inc.
Engage Energy Canada L.P.
Texaco Natural Gas Inc. |  |  |  |  | x
Cargill Energy, a division of Cargill, Incorporated |  |  |  |  |  | x
CMS Marketing, Services and Trading Company
OGE Energy Resources, Inc.
TXU Energy Trading Company
ONEOK Energy Marketing and Trading Company, L.P.
Morgan Stanley Capital Group Inc. |  |  |  |  |  | x
Mieco Inc.
IDACORP Energy L.P.
e prime, inc.
PanCanadian Energy Services Inc.
PSEG Energy Resources & Trade LLC
TransCanada Energy Financial Products Limited
Cook Inlet Energy Supply L.L.C.
Tenaska Marketing Ventures
Nexen Marketing |  | x
EnergyUSA-TPC Corp. |  |  |  |  | x
MidAmerican Energy Company
Allegheny Energy Supply Company, LLC | x
Enserco Energy, Inc.
Texla Energy Management Inc.
Avista Energy, Inc.
Utilicorp United Inc.
Bank of America, National Association |  |  |  |  |  | x
BNP Paribas |  |  |  |  |  | x
Duke Energy Marketing Limited Partnership | x
Dynegy Canada Inc. |  |  |  | x
Aquila Capital & Trade, Ltd. | x
Aquila Energy Marketing Corporation | x
Spreadsheet: 827731d1683008421-mid-function-help-split-longitude-and-latitude-aligw
Sheet: Sheet1

18°42'0"S, 138°31'58"E
22°58'0"S, 145°14'31"E
23°33'55"S, 145°18'25"E
25°38'30"S, 140°46'58"E
17°44'54"S, 139°32'2"E
17°56'25"S, 138°49'19"E
24°15'29"S, 144°25'30"E
21°35'24"S, 138°21'28"E
22°21'48"S, 143°5'9"E
Spreadsheet: 266859d1379788340-help-with-sumif-forumula-lakewestassessment
Sheet: Section 4

 | Instructor:  Yamahiro
Student Number | Major | Classification | Q1 | Q2 | Q3 | Q4 | Q5 | Q6 | Q7 | Q8 | Q9 | Q10
61 | MNGT | Freshman | a | d | d | b | a | c | c | c | e | a
62 | ACCT | Senior | a | b | d | c | a | b | c | c | d | c
63 | MNGT | Sophomore | a | c | d | b | e | b | c | c | a | b
64 | MRKT | Junior | b | d | d | b | a | b | c | c | d | d
65 | MIS | Freshman | a | b | d | b | a | c | c | c | e | a
66 | ECON | Freshman | a | a | d | d | a | c | c | c | e | a
67 | ECON | Sophomore | b | d | d | b | c | d | c | a | e | a
68 | ECON | Freshman | b | b | d | b | c | a | c | c | e | a
69 | ECON | Junior | b | a | e | b | a | c | c | c | e | a
70 | ECON | Sophomore | c | b | c | d | a | d | c | c | e | a
71 | ECON | Sophomore | d | b | d | b | a | a | c | b | e | a
72 | ECON | Senior | e | d | e | b | a | c | c | b | e | a
73 | ACCT | Sophomore | c | a | c | b | a | d | c | d | e | a
74 | FIN | Sophomore | b | c | d | b | a | d | c | a | e | a
75 | ACCT | Sophomore | c | c | d | b | a | a | c | b | e | a
76 | MRKT | Freshman | d | c | d | d | a | a | c | d | e | a
77 | MIS | Junior | a | c | d | b | a | b | c | a | e | a
78 | MNGT | Sophomore | d | c | d | b | a | b | c | a | e | a
79 | ACCT | Junior | a | c | d | b | a | b | c | b | e | a
80 | ACCT | Sophomore | a | d | e | b | a | b | c | b | e | a
Spreadsheet: 2221c500-1a35-40aa-b8bc-d710e0f6acb9
Sheet: 3

 | Nov 23 | Nov 30 | Dec 7 | Dec 14 | Dec 21
Total Interest Rates* | 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 | 2534908 | 2544943 | 2535376 | 2559859 | 2319826
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Equities | 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 Commodities | 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].
Spreadsheet: 768873d1645183485-excel-formula-to-translate-foreign-currency-foreign-exchange
Sheet: Roreign Exchange Rates

 | FOREIGN EXCHANGE RATE
 | Month | USD
 | 2021-01-01 00:00:00 | 82.6756
 | 2021-02-01 00:00:00 | 83.8867
 | 2021-03-01 00:00:00 | 84.4001
 | 2021-04-01 00:00:00 | 84.5032
 | 2021-05-01 00:00:00 | 84.7259
 | 2021-06-01 00:00:00 | 85.6402
 | 2021-07-01 00:00:00 | 85.6402
 | 2021-08-01 00:00:00 | 86.0551
 | 2021-09-01 00:00:00 | 87.6653
 | 2021-10-01 00:00:00 | 97.1361
 | 2021-11-01 00:00:00 | 105.6896
 | 2021-12-01 00:00:00 | 108.666
Spreadsheet: joe_parks__14594__Hubbard Nomination Model 2002 with Noms
Sheet: Nomination Sheet

HUBBARD NOMINATIONS
February 2002
Annual Charge Gas
 | 28 | Number of days in month
 | 0.85 | Expected Load Factor
 | 54663 | Monthly fuel gas payable
True-Up Volume
December
 | 1567700 | KwH per Midland Power Cooperative Invoice
 |  | Conversion to HP
 |  | Actual Month Fuel Gas
 | 60710 | Expected Load Factor Volume
 |  | True-up volume
Total Monthly Gas
 |  | [NAME]
 |  | Daily MMBtu
Spreadsheet: 871792d1718205125-if-statement-where-a-specific-word-is-needed-and-a-amount-is-entered-into-another-cell-market-tracker-template-pjfoster-
Sheet: Proposals 24

New Client
2024 Proposals Date | Status Win/Loss | Client | New / Exist | Project | Total Submitted | Total Won Fee | Arch | MEP | Structural | Civil | Permitting | Const. [NAME] | Suveys | Signage | [NAME] SOW | Sub Consultants | Reimbursable | Construction | Notes
2024 Proposals
2024-01-23 00:00:00 | LOST | Client ABC | Status | Project Description |  |  | 22340 | 6000 | 6800 |  | 5000 | 5000
2024-04-15 00:00:00 | Status | Client DEF | Existing | Project Description |  |  | 26700 | 15650 |  |  |  |  |  |  | 15980
2024-05-12 00:00:00 | WIN | Client GHI | Status | Project Description |  |  | 2494 | 14000 | 5000 |  | 2500 | 36800
2024-05-22 00:00:00 | Client Reviewing | Client JKL | Status | Project Description |  |  |  | 26700 | 19000 |  | 4000 | 1000
2024-06-01 00:00:00 | LOST | Client MNO | Status | Project Description |  |  | 750 |  |  |  | 200
2024-06-10 00:00:00 | WIN | Client PQR | Status | Project Description |  |  |  |  |  | 85000 | 15000 | 7500 | 24000 |  | 2500
Spreadsheet: 183948d1349100436-need-help-with-conditional-formatting-problem-please-help-tf-performance-2-latest-q3
Sheet: TF Sales Performance Quarterly

Year End Performance Report 2011 |  |  |  |  |  | Quarterly Operational Breakdown |  |  |  |  |  |  |  | Yearly Operational Breakdown
 |  |  |  |  |  | Quarterly Support Craft Usage |  |  |  | Fendering Times |  |  |  | TF Support Craft Usage (YTD) |  |  |  |  |  | Fendering Times (YTD)
TF Performance Breakdown
 | Month | Total Ops. | TC (MT) | ACO (MT)
 | October | 48 | 543600
 | November | 50 | 581246
 | December | 24 | 214482
 | Q. Total
 | Year Total | 614 | 6854930.32
 | ** TC = Total Cargo ACO = [NAME]. cargo per operation.
Operations This Quarter |  |  |  |  |  | Quarterly Financial Performance |  |  |  |  |  |  |  | Financial Performance (YTD)
Total operations completed
 |  |  |  |  |  |  | Monthly Revenue - Q4 |  |  |  | Avg. Revenue Per Operation
 |  |  |  |  |  |  | Month | Ammount |  |  | Month | Ammount
 |  |  |  |  |  |  | October | $690,182.87 |  |  | October | 14378.80979166667
 |  |  |  |  |  |  | November | 741923.13 |  |  | November | 14267.7525 |  | TF Revenue - YTD
 |  |  |  |  |  |  | December* | 280054.71 |  |  | December | 11906.085
 |  |  |  |  |  |  | Total (YTD) | 5956176.87224992 |  |  | Total (YTD)
Total Cargo Transferred (KT)
 |  |  |  |  |  | TF Revenue - Q4
Spreadsheet: 774715d1648633224-nested-if-statement-issues-sample1
Sheet: Sheet1

Works But with Issues
PARTICIPANT_NAME | START_DATE |  | PARTICIPANT_NAME | START_DATE
Person 1 | 2021-06-30 00:00:00 |  | Person 1 | 2021-06-30 00:00:00
Person 2 | 2021-06-30 00:00:00 |  | Person 2 | 2021-06-30 00:00:00
Person 3 | 2021-07-01 00:00:00 |  | Person 3 | 2022-07-01 00:00:00
Need To Have It As
PARTICIPANT_NAME | START_DATE |  | PARTICIPANT_NAME | START_DATE
Person 1 | 2021-06-30 00:00:00 |  | Person 2 | 2021-06-30 00:00:00 |  | True
Person 2 | 2021-06-30 00:00:00 |  | Person 3 | 2022-07-01 00:00:00 |  | False
Person 3 | 2021-07-01 00:00:00 |  | Person 1 | 2021-06-30 00:00:00 |  | True
New Formula
PARTICIPANT_NAME | START_DATE |  | PARTICIPANT_NAME | START_DATE
Person 1 | 2021-06-30 00:00:00 |  | Person 2 | 2021-06-30 00:00:00
Person 2 | 2021-06-30 00:00:00 |  | Person 3 | 2022-07-01 00:00:00
Person 3 | 2021-07-01 00:00:00 |  | Person 1 | 2021-06-30 00:00:00
Spreadsheet: 390502d1429656543-lookup-across-multiple-sheets-using-multiple-criteria-lookup-multiple-sheets-sample
Sheet: DataSummary

Agent | Period | Sales | Expenses | Total
[NAME] | Month 1
[NAME] | Month 2
[NAME] | Month 3
[NAME] | Month 1
[NAME] | Month 2
[NAME] | Month 3
[NAME] | Month 1
[NAME] | Month 2
[NAME] | Month 3
Spreadsheet: 757142d1638043947-income-tax-calculation-formula-income-tax-calculation-formula-tms-v2
Sheet: Sheet1

Income Tax Calculator (2021)
Areas | Rates | Fixed Amount | Fixed Amount For | Rate Calculation 1 | Rate Calculation 2 | Total |  |  | Income | 100000
24000 | 15 | 0 | 0
53000 | 20 | 3600 | 24000 |  |  |  |  |  | Income Tax
190000 | 27 | 9400 | 53000
650000 | 35 | 30190 | 130000
more than 650000 | 40 | 212190 | 65000