tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 716914d1612421811-dynamic-indirect-substitutes-all-default-to-errors-dynamic-dependent-issues-v3
Sheet: ROWRANGES

 |  |  |  |  |  |  | FINISHES COLUMN E |  |  |  |  |  |  |  |  |  | FINISHES COLUMN F
 | CATEGORY |  | PRODUCT |  |  |  | BRAND |  |  |  |  |  |  |  |  |  | Type/Range
 | Interior Paint |  | Interior Paint
 | Exterior Paint |  | Interior Walls | Exterior Walls | Room Carpet |  | Brand A Interior Walls | Brand  A Interior Wood | Brand A Exterior Walls | Brand  A Exterior Wood | Brand A Room | Brand A Stair | Brand A Bath | Brand A Kitchen | Brand A Tiles |  | Brand A Satinwood | Brand B Eggshell | Brand C Eggshell | Brand A Colourfast | Brand B Colourfast | Brand C Natural | Brand A Weathershield | Brand B Weathershield | Brand C Weathershield | Brand A Nature | Brand B Nature | Brand C Natural | A Berber | B Berber | C Berber | AS Berber | BSBerber | [NAME] | AB Berber | BB Berber | CB Berber | [NAME] | BK Berber | CK Berber | A Square Tiles | B Square Tiles | C Square Tiles
 | Carpet |  | Internal Woodwork | Exterior Woodwork | Stair/Landing Carpet |  | Brand B Interior Walls | Brand  B Interior Wood | Brand B Exterior Walls | Brand  B Exterior Wood | Brand B Room | Brand B Stair | Brand B Bath | Brand B Kitchen | Brand B Tiles |  | Brand A Gloss | Brand B [NAME] | Brand C [NAME] | Brand A Gloss | Brand B Gloss | Brand C [NAME] | Brand A [NAME] | Brand B Natural | Brand C Natural | Brand A [NAME] | Brand B [NAME] | Brand C [NAME] | A Saxony | B Saxony | C Saxony | AS Saxony | BS Saxony | [NAME] | AB Saxony | [NAME] | CB Saxony | [NAME] | BK Saxony | CK Saxony | A Granite Effect | B Granite Effect | C Granite Effect
 |  |  | TBC by Client | TBC by Client | Bathroom Carpet |  | Brand C Interior Walls | Brand  C Interior Wood | Brand C Exterior Walls | Brand  C Exterior Wood | Brand C Room | Brand C Stair | Brand C Bath | Brand C Kitchen | Brand C Tiles |  | Brand A Silk | Brand B Silk | Brand C Silk | Brand A Varnish | Brand B Varnish | Brand C Varnish | Brand A Rustic | Brand B [NAME] | Brand C [NAME] | Brand A Varnish | Brand B Varnish | Brand C Varnish | A Loop | B Loop | C Loop | AS Loop | BS Loop | CS Loop | AB Loop | BB Loop | CB Loop | AK Loop | BK Loop | CK Loop | A Ceramic | B Ceramic | C Ceramic
 |  |  |  |  | [NAME] |  | TBC by Client | TBC by Client | TBC by Client | TBC by Client | TBC by Client | TBC by Client | TBC by Client | TBC by Client | TBC by Client |  | TBC by Client | TBC by Client | TBC by Client | TBC by Client | TBC by Client | TBC by Client | TBC by Client | TBC by Client | TBC by Client | TBC by Client | TBC by Client | TBC by Client | A Twist | B Twist | C Twist | AS Twist | BS Twist | CS Twist | AB Twist | BB Twist | CB Twist | AK Twist | BK Twist | CK Twist | A Victorian | B Victorian | C Victorian
 |  |  |  |  | Carpet Tiles |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TBC by Client | TBC by Client | TBC by Client | TBC by Client | TBC by Client | TBC by Client | TBC by Client | TBC by Client | TBC by Client | TBC by Client | TBC by Client | TBC by Client | TBC by Client | TBC by Client | TBC by Client
 |  |  |  |  | TBC by Client
Spreadsheet: david_delainey__8063__Walton Cashflow Model 070600
Sheet: Book Income Statement

DOYLE I, LLC
Income Statement
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16
 |  | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015
Months of Year In Operation |  | 6.55 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 6.5
Revenues
Fixed Capacity Revenue
Escalating Capacity Revenue
Pass-through Fixed + Escalating O&M Revenue
PPA Energy Revenue (Fuel and VO&M)
Put Value Revenue |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10000
Total Revenue
Pass-through Expenses
Fuel
Total Variable Pass-through Expenses |  | 1156
Total Fixed Pass-through Expenses |  |  | 1995
Escalating Expenses
Total Escalating Expenses |  | 136 | 284
Total Operating Expenses
EBITDA
Book Depreciation & Amortization |  | 2514.35381272495 | 4603.371464187384 | 4603.371464187384 | 4603.371464187384 | 4603.371464187384 | 4401.155516924326 | 4233.147068351247 | 4233.147068351247 | 4233.147068351247 | 4233.147068351247 | 4233.147068351247 | 4233.147068351247 | 4233.147068351247 | 4233.147068351247 | 4233.147068351247 | 2292.954662023592
EBIT
Interest Expense |  | 3125.163086175131 | 6799.410063061771 | 6484.827466303776 | 6087.808061098521 | 5796.566001324094 | 5420.445332214679 | 5021.244563385259 | 4597.547417968236 | 4147.850711318749 | 3670.559018044878 | 3163.979011787906 | 2626.313457671372 | 2055.654836105489 | 1449.978575325555 | 807.1358686548929 | 159.846117061148
Interest Income |  | 51.32151359999999 | 92.4510224928384 | 95.35295305726561 | 95.46393681024485 | 95.86142836660224 | 95.94752123518205 | 96.03479238918635 | 96.36787277050608 | 96.43039306644548 | 96.49416376830365 | 96.55920988419899 | 96.62555692241227 | 96.69323090138981 | 96.76225835994688 | 96.83266636767509 | 128.8601823233378
Net Interest Expense
EBT
Spreadsheet: 456272d1460726525-sum-cells-with-blank-cells-next-to-them-example
Sheet: Sheet1

APRIL
DATE | TIME | CLIENT | TOTAL TIME |  | STAFF
FRI 1ST | 07:00 - 07:45 | JOE | 0.75 |  | MEGAN
 | 07:15 - 07:45 | HARRY | 0.5 |  | SARA | SUE
 | 08:00 - 08:45 | FREDA | 0.75 |  | MEGAN
 | 08:30 - 12:00 | PETER | 3.5 |  | SARA
 | 09:00 - 10:00 | AMY | 1
 | 08:30 - 09:15 | HARRY | 0.75 |  | MEGAN | SUE
 | 09:00 - 13:00 | AMY |  | 4 | MANDY
In this example I wish to add up all columns that would match the red highlighted one.
To get a total of the numbers in column D where '[NAME]' is in column C and columns F and G are blank
 | HOURS | HOURS MISSED
AMY |  | 1
HARRY | 1.25
PETER | 3.5
JOE | 0.75
FREDA | 0.75
Spreadsheet: louise_kitchen__23975__Schedule C_927
Sheet: Sheet3

Enron North America
Third Quarter Earnings Summary
 |  |  | vs. Plan
Hard Look | 2000-08-25 00:00:00 |  | 196
Expected Deal Flow (3rd Quarter) |  |  | 104
Current Estimate
Schedule C |  |  | 149
Expected Overperformance to Plan (ENA)
Uses:
Corporate Overview |  |  | 75
ETOL (EEL) |  |  | 50
Restricted Stock Plan |  |  | 55
Special Pays |  |  | 25
Tax |  |  | 50
Corporate Bonus Accrual |  |  | 50
Total Corporate Uses
Net Overperformance (ENE)
EPS Effect (¢ per share)
Spreadsheet: 55391d1255517801-changes-to-all-worksheets-asa2-analysis-sheet-prototype-
Sheet: 12AS UMS scores 2009-2010

Name | S/name | T/G | Staff | Jan-09 Unit 1 | Jun-09 Unit 1 | Jan-10 Unit 1 | Jun-10 Unit 1 | Jun-09 Unit 2 | Jan-10 Unit 2 | Jun-10 Unit 2 | Jun-09 Unit 3 | Jan-10 Unit 3 | Jun-10 Unit 3 | Total | Grade
[NAME] | Bloggs 1 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 0 | U
[NAME] | [NAME] | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 0 | U
[NAME] | Bloggs 3 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 0 | U
[NAME] | Bloggs 4 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 0 | U
[NAME] | Bloggs 5 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 0 | U
[NAME] | [NAME] 6 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 0 | U
[NAME] | Bloggs 7 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 0 | U
[NAME] | Bloggs 8 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 0 | U
[NAME] | Bloggs 9 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 0 | U
[NAME] | Bloggs 10 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 0 | U
Total= | 10 | Total = | 10
 |  |  |  |  |  | Enter your UMS marks into this sheet
Spreadsheet: 693716d1599113624-return-the-next-working-day-taking-in-consideration-the-days-off-on-a-2-days-interval-sample_2
Sheet: Admin

 |  |  |  |  | HOLIDAY LEAVE |  |  | LEGAL DAYS OFF |  |  | V | W1 D1 | W1 D2 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | W5 D1 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | W7 D1 | [NAME] | W8 D1 | W8 D2
 |  |  |  | Crit. | Start | End |  | 2020-06-01 00:00:00 |  |  | 2020-01-18 00:00:00
 |  |  |  | 1 | 2020-01-02 00:00:00 | 2020-01-05 00:00:00 |  | 2020-06-07 00:00:00 |  |  | 2020-01-13 00:00:00
 |  |  |  |  | 2020-01-15 00:00:00 | 2020-01-17 00:00:00 |  | 2020-06-08 00:00:00 |  |  | 2020-01-14 00:00:00
 |  |  |  |  | 2020-02-09 00:00:00 | 2020-02-19 00:00:00 |  | 2020-08-15 00:00:00 |  |  | 2020-02-14 00:00:00
 |  |  |  |  | 2020-06-09 00:00:00 | 2020-06-12 00:00:00 |  | 2020-11-30 00:00:00 |  |  | 2020-01-25 00:00:00
 |  |  |  |  | 2020-09-14 00:00:00 | 2020-09-19 00:00:00 |  | 2020-12-01 00:00:00 |  |  | 2020-01-07 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | ok | ok | ok | 2020-01-20 00:00:00 | 2020-01-22 00:00:00 | 2020-01-24 00:00:00 |  |  |  | and so on
 |  |  |  |  |  |  |  |  |  | Based on the dates found in column L, if date falls in the holiday leave range or legal days off range, then W1 D1 should be the next working day. But if the found date is a Monday or Tuesday, then W1 D1 should be Wednesday. If is not Monday or Tuesday, then it should move to next week - Monday. If [NAME] is Wednesday then [NAME] should be Thursday, [NAME] should be Friday, otherwise, if [NAME] is Monday, then [NAME] should be Wednesday and [NAME] should be Friday. This should be the case up untill [NAME]. For W7 and W8, it should have the same rules but only for 2 days, Monday and Thursday.  The main point is that it should jump over the holiday intervals or legal days off.  I hope that is not too confusing
Spreadsheet: 773646d1647971509-need-help-to-calculate-average-handling-time-field-wise-analysis-updated
Sheet: To discuss

Time buckets --> | <=5 min | >5 and <=10 min | >10 and <=15 min | >15 and <=30 min
# cases | 762 | 132 | 30 | 34
% of cases | 0.7651 | 0.1325 | 0.0301 | 0.0341
Avg time per time frame bucket (hh:[NAME]:ss)
Total time per bucket (hh:[NAME]:ss)
Sum of time for all the buckets
Overall AHT (hh:[NAME]:ss)
Spreadsheet: 713904d1611001672-compare-two-cells-if-contain-same-number-libro1
Sheet: Hoja1

 |  | CHECK
BR 1267 | IB 16102 | check if the number in B2 is in the A range (A2:A3000 for example) and show YES NO
IB 15579 | IB 16402 | check if the number in B3 is in the A range (A2:A3000 for example) and show YES NO
BR1243 | IB 16655 | check if the number in B4 is in the A range (A2:A3000 for example) and show YES NO
IB16775 | IB 539 | etc
IB23062 | IB 16546 | etc
IB21992 | IB 23706
IB16569 | IB 16006
IB15483 | IB 21135
IB 33 | IB 13177
IB 16408 | IB 1710
IB 15524 | IB 7857
IB 13721 | IB 22154
TBAL32 | IB 16585
IB 16820 | IB 16741
IB9563 | IB 16864
IB1661 | IB 15704
IB22147 | IB 16102
IB 15645 | IB 16546
IB 15866 | IB 16402
IB8800 | IB 16143
IB 13177 | IB 16655
IB 16266 | IB 16006
IB 16563 | IB 16806
IB 21938 | IB 427
IB1327 | IB 13721
IB 6184 | IB 7857
16461 | IB 16864
IB 15059 | IB 21592
TBAL 34 | IB 15711
IBA 21965 | IB 15704
IB16106 | IB 7971
IB 16814 | IB 16200
IB23733 | IB 16713
IB 15865 | IB 16200
[NAME] | IB 21937
IB 16009 | IB 21009
IB21256 | IB 16617
IB21372 | IB 8484
IB 9508 | IB 21256
IB 16098 | IB 16819
IB 21975 | IB 15990
IB9594 | IB 16693
IB 16640 | IB 7575
IB 16403 | IB 8800
IB 16822 | IB 8865
IB 22518 | IB 16814
IB 21327 | IB 16697
IB 8865 | IB 7971
Ib22402 | IB 23733
IB 8189 | IB 13721
IB 24313 | IB 16603
IB22889 | IB 15579
IB16830 | IB 16403
IB 16751 | IB 13984
Ib9518 | IB 15695
IB 8484 | IB 16106
IB 16857 | IB 16780
IB 16473 | IB 13984
IB 16472 | IB 15865
IB 15242 | IB 15695
IB16833 | IB 21327
IB 16822 | IB 13177
IB5671 | IB 16563
TBAL42 | IB 15579
[NAME] | IB 16106
IB 9539 | IB 6184
IB16384 | IB 16563
IB 15562 | IB 16408
TBAL53 | IB 16422
IB16462 | IB 16294
IB22073 | IB 16384
IB15882 | IB 16473
Ib 21135 | IB 16834
IB16542 | IB 6627
IB7129 | IB 9518
IB16677 | IB 16820
IB 16603 | IB 249
IB 16697 | IB 16857
IB16678 | IB 22147
IB21656 | IB 16727
IB 16706 | BR 1267
IB23013 | IB 16751
IB16816 | IB 16857
IB 16102 | IB 16408
IB 15774 | IB 16294
IB 7601 | IB 8832
IB16294 | IB 16473
IB 16821 | IB 16108
IB 16143 | IB 16706
TBAL 41 | IB 16407
IB 22506 | IB 16462
IB 22154 | IB 16483
 | IB 191
 | IB 16778
 | IB 12331
 | IB 1327
 | IB 9404
 | IB 16605
 | IB 22774
 | IB 16785
 | IB 16266
 | IB 16156
 | IB 21938
 | IB 16542
 | IB 16821
 | IB 16822
 | IB 16098
 | IB 16461
 | IB 16751
 | IB 16822
 | IB 16821
 | IB 16701
 | IB 16098
 | IB 9518
 | IB 16472
 | IB 16833
 | IB 16461
 | IB 15866
 | IB 16093
 | IB 16701
Spreadsheet: 00db8cbd-33d4-41c7-b2c8-69970d2d018c
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 8731.0 Building Approvals, Australia
 | TABLE 37. Value of Building Approved - Australian Capital Territory
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Value of Approval ;  Australian Capital Territory ;  Total residential building ;  New ; |  |  | Original | A420494A | 1970-07-01 00:00:00 | 2011-11-01 00:00:00 | 497 | $'000 | FLOW | Month | 1
Value of Approval ;  Australian Capital Territory ;  Total residential building ;  Total alterations/additions (incl. refurb and conversion) ; |  |  | Original | A420503T | 1973-07-01 00:00:00 | 2011-11-01 00:00:00 | 461 | $'000 | FLOW | Month | 1
Value of Approval ;  Australian Capital Territory ;  Total residential building ;  Total (Type of work) ; |  |  | Original | A420515A | 1973-07-01 00:00:00 | 2011-11-01 00:00:00 | 461 | $'000 | FLOW | Month | 1
Value of Approval ;  Australian Capital Territory ;  Total non-residential building ;  Total (Type of work) ; |  |  | Original | A421178T | 1970-07-01 00:00:00 | 2011-11-01 00:00:00 | 497 | $'000 | FLOW | Month | 1
Value of Approval ;  Australian Capital Territory ;  Total building ;  Total (Type of work) ; |  |  | Original | A422865L | 1973-07-01 00:00:00 | 2011-11-01 00:00:00 | 461 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2011
Spreadsheet: 289280d1389480450-excel-2007-drop-down-box-range-help-drop-down-lists-your-data
Sheet: Sheet1

Section 1 | Section 2 | Section 3 | Section 4 | Section 5 | Section 6 | Section 7 | Section 8 | Section 9 | Section 10 | Section 11 | Section 12
Section 1 Module 1 | Section 2 Module 1 | Section 3 Module 1 | Section 4 Module 1 | Section 5 Module 1 | Section 6 Module 1 | Section 7 Module 1 | Section 8 Module 1 | Section 9 Module 1 | Section 10 Module 1 | Section 11 Module 1 | Section 12 Module 1
Section 1 Module 2 | Section 2 Module 2 | Section 3 Module 2 | Section 4 Module 2 | Section 5 Module 2 | Section 6 Module 2 | Section 7 Module 2 | Section 8 Module 2 | Section 9 Module 2 | Section 10 Module 2 | Section 11 Module 2 | Section 12 Module 2
Section 1 Module 3 | Section 2 Module 3 | Section 3 Module 3 | Section 4 Module 3 | Section 5 Module 3 | Section 6 Module 3 | Section 7 Module 3 | Section 8 Module 3 | Section 9 Module 3 | Section 10 Module 3 | Section 11 Module 3 | Section 12 Module 3
Section 1 Module 4 | Section 2 Module 4 | Section 3 Module 4 | Section 4 Module 4 | Section 5 Module 4 | Section 6 Module 4 | Section 7 Module 4 | Section 8 Module 4 | Section 9 Module 4 | Section 10 Module 4 | Section 11 Module 4 | Section 12 Module 4
Section 1 Module 1 | Section 1 Module 2 | Section 1 Module 3 | Section 1 Module 4 | Section 2 Module 1 | Section 2 Module 2 | Section 2 Module 3 | Section 2 Module 4 | Section 3 Module 1 | Section 3 Module 2 | Section 3 Module 3 | Section 3 Module 4 | Section 4 Module 1 | Section 4 Module 2 | Section 4 Module 3 | Section 4 Module 4 | Section 5 Module 1 | Section 5 Module 2 | Section 5 Module 3 | Section 5 Module 4 | Section 6 Module 1 | Section 6 Module 2 | Section 6 Module 3 | Section 6 Module 4 | Section 7 Module 1 | Section 7 Module 2 | Section 7 Module 3 | Section 7 Module 4 | Section 8 Module 1 | Section 8 Module 2 | Section 8 Module 3 | Section 8 Module 4 | Section 9 Module 1 | Section 9 Module 2 | Section 9 Module 3 | Section 9 Module 4 | Section 10 Module 1 | Section 10 Module 2 | Section 10 Module 3 | Section 10 Module 4 | Section 11 Module 1 | Section 11 Module 2 | Section 11 Module 3 | Section 11 Module 4 | Section 12 Module 1 | Section 12 Module 2 | Section 12 Module 3 | Section 12 Module 4
1-I.01 | No Objectives | 1-I.04 | 1-II.07 | 2-I.01 | 2-I.05 | 2-II.08 | No Objectives
1-I.02 |  | 1-I.05 | 1-II.08 | 2-I.02 | 2-I.06 | 2-II.09
1-I.03 |  | 1-I.06 |  | 2-I.03 | 2-I.07 | 2-II.09
 |  |  |  | 2-I.04
1-I.01 | 1-I.02 | 1-I.03 | No Objectives | 1-I.04 | 1-I.05 | 1-I.06 | 1-II.07 | 1-II.08 | 2-I.01 | 2-I.02 | 2-I.03 | 2-I.04 | 2-I.05 | 2-I.06 | 2-I.07 | 2-II.08 | 2-II.09 | 2-II.092
1 | 3 | 5 | 7 | 9 | 11 | 13 | 15 | 17 | 19 | 21 | 23 | 25 | 27 | 29 | 31 | 33 | 35 | 37
2 | 4 | 6 | 8 | 10 | 12 | 14 | 16 | 18 | 20 | 22 | 24 | 26 | 28 | 39 | 32 | 34 | 36 | 38
Spreadsheet: 582523d1531923042-how-to-rank-with-only-visible-and-any-sort-order-test-of-ranking
Sheet: Tabelle1

Product Name | total VK € Tsd | Top € (80% sales) | [NAME] (80/15/5)
Product 1 | 645012.61
Product 2 | 520425
Product 3 | 498675
Product 4 | 474200
Product 5 | 427794.5
Product 6 | 373500
Product 7 | 371415
Product 8 | 303370
Product 9 | 301956
Product 10 | 236970.1
Product 11 | 228556.5
Product 12 | 183374.4
Product 13 | 178087.6
Product 14 | 171285
Product 15 | 165311
Product 16 | 161650
Product 17 | 154755
Product 18 | 153605
Product 19 | 150426
Product 20 | 142968.75
Product 21 | 139350
Product 22 | 123580
Product 23 | 117510
Product 24 | 116325
Product 25 | 109500
Product 26 | 107360
Product 27 | 94500
Product 28 | 92088.32
Product 29 | 90460
Product 30 | 87690
Product 31 | 85299.21
Product 32 | 84423.5
Product 33 | 83280.71
Product 34 | 79830
Spreadsheet: 005b6801-8580-4d96-b866-5fd00c9c0c81
Sheet: 6

 | Oct 19 |  | Oct 26 |  | Nov 2 |  | Nov 9
 | Long | Short | Long | Short | Long | Short | Long | Short
Total Interest Rates* | 84500 | 84500 | 84500 | 84500 | 84500 | 84500 | 84500 | 84500
SD/MSPs** | N/A*** | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Cross-Currency | 3500 | 3500 | 3500 | 3500 | 3500 | 3500 | 3500 | 3500
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Credit | 105000 | 105000 | 105000 | 105000 | 105000 | 105000 | 105000 | 105000
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Equity | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Commodities | 105000 | 105000 | 105000 | 105000 | 105000 | 105000 | 105000 | 105000
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Weekly total, estimated swap event volumes by asset class and participant type (in number of events), all products and tenors, cleared and uncleared.
Estimates of weekly event volumes are derived from data published in the 2012 ISDA Operations Benchmarking Survey which defines an "event" as a new trade, confirmable amendment, partial or full termination, increase, decrease, or novation.
*See Data Dictionary for asset class descriptions.
**See Explanatory Notes for participant type 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: 704834d1605770657-calculating-total-using-if-and-vlookup-chemical-inventory-control
Sheet: In & Out

 | Chemical In & Out Entries
 | Block | Ha | Cultivar | Date | Product | Unit | In | Out
 | Stock |  |  | 2020-11-15 00:00:00 | Product 1 |  | 50
 | A |  |  | 2020-11-16 00:00:00 | Product 2 |  |  | 30
 | C |  |  | 2020-11-16 00:00:00 | Product 1 |  |  | 10
 | E |  |  | 2020-11-16 00:00:00 | Product 4 |  |  | 5
 | B |  |  | 2020-11-16 00:00:00 | Product 3 |  |  | 20
 | D |  |  | 2020-11-16 00:00:00 | Product 5 |  |  | 18
 | Stock |  |  | 2020-01-18 00:00:00 | Product 4 |  | 60
Spreadsheet: 0218510f-e9fa-4379-b2e3-2cf576778ef5
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | 报表 D | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23
 | 国际民航组织 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 第      页
 | 航空运输报表
 | 商业航空承运人的机队与人员
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 国家名称：
 | 联系人： |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 航空承运人：
 | 单位： |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | 20
 | 电话：
 | 传真：
 | 电子邮件：
 | 第一部分：机队
 | 机队航空器（按型号分列） |  | 每一型号航空器的数量 |  |  |  | 航空器的体积 |  |  | 航空器年利用率
 |  |  |  |  |  |  |  |  |  | 航空器起降架次 |  |  | 航空器飞行小时 |  |  | 航空器飞行公里数
 |  |  |  | 每年期间的变化 |  |  |  |  | 平均最大 |  |  |  |  |  |  |  |  |  | 航空器
 |  |  |  |  |  |  | 安装的 | 平均 | 审定 | 营利飞行 |  | 所有 | 营利飞行 |  | 所有 | 营利飞行 |  | 所有 | 可利用
 | 制造商和机型 | 用途/机型 |  |  |  |  | 旅客 | 业载运力 | [NAME] |  |  | 飞行 |  |  | 航班 |  |  | 飞行 | 天数
 |  | 代码¹ | 年初 | 购得 | 报销 | 年底 | 座位数 | (吨) | (吨) | 定期 | 不定期 | (合计) | 定期 | 不定期 | (合计) | 定期 | 不定期 | (合计) | [NAME]
 | a | b | c | d | e | f | g | h | I | j | k | l | m | n | o | p | q | r | s
 | 第二部分 ——人员
 |  |  |  |  |  |  | 1 | 用途/机型代码
 |  |  |  | 各类人员每年的支出总数 |  |  |  | 使用下列其中一个代码在b栏中对填入a栏的每一航空器进行报告
 |  | 人员数额 |  | 货币：
 | 人员类型2 | 年中 | 年底 |  |  |  |  | 运营人用于商业航空运输使用的航空器代码：
 | a | b | c | d |  |  |  | P - 旅客机型航空器
 | 驾驶员和副驾驶员……… |  |  |  |  |  |  | F - 货机型航空器，不用于旅客。
 | 其他飞行机组…………… |  |  |  |  |  |  | M - 混合型航空器 ("混合")，能够同时运输客、货的航空器
 | 客舱机组…………………
 | 维护和检修人员………… |  |  |  |  |  |  | 运营人不用于商业航空运输的航空器代码：
 | a) 持照航空器维护工程师 |  |  |  |  |  |  | O - 航空器用于训练、空中作业等其他目的。
 | b) 其他维护和检修人员
 | 票务和销售人员………… |  |  |  |  |  | 2 | 小型承运人(见填报说明)可包括维修。
 | [NAME]…………… |  |  |  |  |  |  | 翻修、票务和销售人员可计入在"所有其他人员" 一栏.
 | [NAME]………………………
 | 备注（描述与填报说明存在任何无法避免的偏差情况）：
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 787789d1658049191-how-to-search-target-data-with-multiple-data-sample-data-lookup-serial-number-with-do-number
Sheet: DO History

Delivery No | DO Date | Item No. | Quantity | Serial/Lot Number |  | Right formula | it should be
22-0151/1 | 2022-07-01 00:00:00 | S39224JS | 1
22-0153/1 | 2022-07-04 00:00:00 | DS II M | 1 |  | duplicate | ?? | 220325-031040
22-0153/1 | 2022-07-04 00:00:00 | PAX2C | 1
22-0153/1 | 2022-07-04 00:00:00 | DE-400E | 1 |  | duplicate | ?? | DE40EEHHJ003
22-0153/1 | 2022-07-04 00:00:00 | DE-400E | 1 |  | duplicate | ?? | DE40EEHGD001
22-0153/1 | 2022-07-04 00:00:00 | DT-300S | 1
22-0153/1 | 2022-07-04 00:00:00 | 2000 | 1
22-0153/1 | 2022-07-04 00:00:00 | DS II M | 1 |  | duplicate | ?? | 220325-031038
22-0153/1 | 2022-07-04 00:00:00 | [NAME] | 1 |  | duplicate | ?? | 220325-011545
22-0153/1 | 2022-07-04 00:00:00 | 5016000 | 1 |  | duplicate | ?? | SP22030191
22-0153/1 | 2022-07-04 00:00:00 | DS II M | 1 |  | duplicate | ?? | 220325-031041
22-0042 | 2022-07-05 00:00:00 | [NAME] | 1 |  | duplicate | ?? | 220325-011547
22-0042 | 2022-07-05 00:00:00 | [NAME] | 1 |  | duplicate | ?? | 220325-011549
22-0457 | 2022-07-06 00:00:00 | H48302BA | 1
22-0457 | 2022-07-06 00:00:00 | H40402LY | 1
22-0457 | 2022-07-06 00:00:00 | H4000SR | 1
22-0457 | 2022-07-06 00:00:00 | CT1082B | 1
22-0156/1 | 2022-07-13 00:00:00 | [NAME] | 1 |  | duplicate | ?? | 220325-011548
22-0156/1 | 2022-07-13 00:00:00 | DS II M | 1 |  | duplicate | ?? | 220325-031042
22-0282 | 2022-07-15 00:00:00 | 5016000 | 1 |  | duplicate | ?? | SP22030190
22-0282 | 2022-07-15 00:00:00 | 5030810 | 5 |  | duplicate | ??
22-0283 | 2022-07-15 00:00:00 | DS II M | 1 |  | duplicate | ?? | 220613-031053
22-0283 | 2022-07-15 00:00:00 | OF001 | 1
22-0283 | 2022-07-15 00:00:00 | [NAME] | 1 |  | duplicate | ?? | 220621-011590