tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 888763d1739344142-sum-lookups-across-multiple-tabs-using-dynamic-formulas-demand-planning
Sheet: Demand

 | Master Demand Plan |  |  |  | Current Month
 |  | Month | Month +1 | Month +2 | Month +3 | Month +4 | Month +5 | Month +6 | Month +7 | Month +8 | Month +9 | Month +10 | Month +11 | Month +12 | Month +13 | Month +14 | Month +15 | Month +16 | Month +17 | Month +18
 | Component 1
 | Component 2
 | Component 3
 | Component 4
 | Component 5
Spreadsheet: 233844d1367939144-making-calendar-oskar
Sheet: Jan

Date
2013-01-01 00:00:00
2013-01-02 00:00:00
2013-01-03 00:00:00
2013-01-04 00:00:00
2013-01-05 00:00:00
2013-01-06 00:00:00
2013-01-07 00:00:00
2013-01-08 00:00:00
2013-01-09 00:00:00
2013-01-10 00:00:00
2013-01-11 00:00:00
2013-01-12 00:00:00
2013-01-13 00:00:00
2013-01-14 00:00:00
2013-01-15 00:00:00
2013-01-16 00:00:00
2013-01-17 00:00:00
2013-01-18 00:00:00
2013-01-19 00:00:00
2013-01-20 00:00:00
2013-01-21 00:00:00
2013-01-22 00:00:00
2013-01-23 00:00:00
2013-01-24 00:00:00
2013-01-25 00:00:00
2013-01-26 00:00:00
2013-01-27 00:00:00
2013-01-28 00:00:00
2013-01-29 00:00:00
2013-01-30 00:00:00
2013-01-31 00:00:00
Spreadsheet: 681583d1591645881-using-if-and-or-formula-for-numbers-in-2-columns-to-match-numbers-in-3-different-columns-and-or
Sheet: Sheet1

COL A | COL B | COL C | COL D | COL E | COL F |  | SHOULD BE
 |  |  |  |  |  |  |  | (BLANK)
 |  |  |  |  |  |  |  | (BLANK)
2 |  | 2 |  |  |  |  | Y
 |  |  |  | 4 |  |  | N
 | 3 |  | 3 |  |  |  | Y
 |  |  |  |  |  |  |  | (BLANK)
 |  |  |  |  |  |  |  | (BLANK)
 | 1 |  |  |  |  |  | N
6 |  |  |  |  |  |  | N
 |  |  |  | 5 |  |  | N
 |  |  | 8 |  |  |  | N
 |  | 4 |  |  |  |  | N
 |  |  |  |  |  |  |  | (BLANK)
 |  |  |  |  |  |  |  | (BLANK)
 | 9 |  | 9 |  |  |  | Y
 |  |  |  |  |  |  |  | (BLANK)
 | 1 |  |  |  |  |  | N
2 |  | 2 |  |  |  |  | Y
 |  |  |  |  |  |  |  | (BLANK)
 |  |  |  | 4 |  |  | N
7 |  |  |  |  |  |  | N
Spreadsheet: 696189d1600695794-collating-multiple-tab-info-into-one-rj-projections_chrispq
Sheet: Supplier 2

Supplier 2 |  |  |  |  |  |  | Payment Dates
Forecast Month | [NAME] (Product) | [NAME] (Number) | Container Number | Time to arrive (M) | Order Date | Container Cost (£) | Jan-20 | Feb-20 | Mar-20 | Apr-20 | May-20 | Jun-20 | [NAME] | Aug-20 | Sep-20 | Oct-20 | Nov-20 | Dec-20 | Jan-21 | Feb-21 | Mar-21 | Apr-21 | May-21 | [NAME] | [NAME] | Aug-21 | Sep-21 | Oct-21 | Nov-21 | Dec-21
2021-01-01 00:00:00 | Product B | 2000 | 1 | -3 | 2020-10-01 00:00:00 | 10000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2500 | 0 | 7500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2021-03-01 00:00:00 | Product B | 2000 | 1 | -3 | 2020-12-01 00:00:00 | 20000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5000 | 0 | 15000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2021-04-01 00:00:00 | Product B | 2000 | 1 | -3 | 2021-01-01 00:00:00 | 50000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12500 | 0 | 37500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2021-04-01 00:00:00 | Product B | 2000 | 1 | -3 | 2021-01-01 00:00:00 | 40000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10000 | 0 | 30000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 145730d1331725037-excel-2007-alternative-for-using-sumif-with-a-3d-reference-example-3d-sumif
Sheet: Loc_a

 |  |  | Area location: | Area3 |  |  |  |  |  |  |  | Loc_A
 |  |  |  |  |  | 2011 | 2012 | 2013 | 2014 | 2015
 |  |  |  |  | Sales | 100 | 250 | 300 | 100 | 50
 |  |  |  |  | Revenue | 50 | 125 | 150 | 50 | 25
Spreadsheet: 734816d1622520914-accumulative-sales-with-multiple-criteria-accumulative-sales
Sheet: Sheet1

Distributor Code | Product | Month No | Date | Sales | Accumulative sales
Distributor A | Product A | May | 2021-05-01 | 51.84 | 51.84
Distributor A | Product B | May | 2021-05-02 | 300.15 | 300.15
Distributor A | Product B | May | 2021-05-03 | 1918.08
Distributor A | Product A | May | 2021-05-04 | 933.1200000000001
Distributor A | Product A | May | 2021-05-05 | 881.28
Distributor A | Product A | May | 2021-05-06 | 1278.72
Distributor A | Product A | May | 2021-05-07 | 103.68
Distributor A | Product A | May | 2021-05-08 | 1002.24
Distributor A | Product C | May | 2021-05-09 | 84.16
Distributor A | Product C | May | 2021-05-10 | 6324.48
Distributor A | Product C | May | 2021-05-11 | 4147.2
Distributor A | Product C | May | 2021-05-12 | 1658.88
Distributor A | Product C | May | 2021-05-13 | 69.12
Distributor A | Product C | May | 2021-05-17 | 29.58
Distributor B | Product A | May | 2021-05-18 | 2488.32
Distributor B | Product A | May | 2021-05-19 | 380.16
Distributor B | Product A | May | 2021-05-20 | 760.32
Distributor B | Product A | May | 2021-05-21 | 846.72
Distributor B | Product B | May | 2021-05-22 | 1002.24
Distributor B | Product B | May | 2021-05-24 | 311.04
Distributor B | Product C | May | 2021-05-25 | 1399.68
Distributor B | Product C | May | 2021-05-26 | 3939.84
Distributor B | Product C | May | 2021-05-27 | 501.12
Distributor C | Product A | May | 2021-05-28 | 67.1
Distributor C | Product A | May | 2021-05-29 | 311.04
Distributor C | Product A | May | 2021-05-30 | 22.09
Distributor C | Product B | May | 2021-05-31 | 4769.28
Spreadsheet: 24238d1214400848-problem-need-to-eliminate-redundant-steps-d-backup
Sheet: Front

Business | Product | 2008-06-07 00:00:00 | 2008-06-10 00:00:00 | 2008-06-11 00:00:00
Town 1 | 2ULS | 0.99 | 55.44 | 0.99
P1 | 1ULS | 1.98 | 0 | 1.98
 | Lead Free | 3.96 | 0 | 3.96
 | [NAME] | 4.95 | 0 | 4.95
 | Silver | 5.94 | 0 | 5.94
 | 89 Gasahol | 7.92 | 0 | 7.92
Town 2 | 2ULS | #N/A | #N/A | #N/A
P1 | 1ULS | #N/A | #N/A | #N/A
 | Lead Free | #N/A | #N/A | #N/A
 | [NAME] | #N/A | #N/A | #N/A
 | 89 Gasahol | #N/A | #N/A | #N/A
Spreadsheet: 488091d1478490639-automated-model-help-data-flow-reporting-metrics1
Sheet: Sheet4

Average of Total days from date vendor submitted to start date | Column Labels
Row Labels | Humcap | Lucas Inc. | RH | ServTech | TEK
2015 12 |  |  |  |  | 60
2016 02 | 25 | 7.666666666666667 | 16.16666666666667 | 28 | 17
2016 03 | 13.25 | 21 | 12 |  | 15.75
2016 04 | 18 | 10.8 |  |  | 15.4
2016 05 | 20 | 18.5 |  |  | 9.222222222222221
2016 06 | 13.4 | 15.8 |  |  | 14.28571428571429
2016 07 | 19 | 16.22222222222222 |  |  | 14
2016 08 | 13.1 | 15.625 |  |  | 12
2016 09 | 13.88888888888889 | 17 |  |  | 20.3
2016 10 | 13.4 | 17.375 |  |  | 14.54545454545454
2016 11 | 21 | 15.77777777777778 |  |  | 19.33333333333333
2016 12 | 13.3 | 20.45454545454545 |  |  | 14.2
2017 01 | 71.9090909090909 | 69.4 |  |  | 56.1
2017 02 | 71.55555555555556 | 57.88888888888889 |  |  | 83.9
2017 03 | 56.5 | 77.36363636363636 |  |  | 71.8
2017 04 | 60.4 | 56.4 |  |  | 53.8
2017 05 | 63.54545454545455 | 67.6 |  |  | 67.6
2017 06 | 69.1 | 61.1 |  |  | 68.3
2017 07 | 65.5 | 75.4 |  |  | 63
2017 08 | 64.4 | 63.18181818181818 |  |  | 67.2
2017 09 | 70.5 | 63.7 |  |  | 66.3
2017 10 | 74.63636363636364 | 62.3 |  |  | 64.3
2017 11 | 56.5 | 66.9 |  |  | 65
2017 12 | 69.8 | 59.7 |  |  | 62.36363636363637
2018 01 | 80.33333333333333 | 50.25 |  |  | 64.33333333333333
Grand Total | 47.13366336633663 | 46.38613861386138 | 15.57142857142857 | 28 | 45.85990338164251
Spreadsheet: 02e4b555-05a6-40f8-a00e-8401a50136eb
Sheet: 12b

Product | EUR** | GBP | [NAME] | USD | TOTAL
Basis*
FRA
IRS- [NAME]
OIS
VNS
Zero Coupon
TOTAL | N/A*** | N/A | N/A | N/A | N/A
Estimated swap dollar volumes, week ending February 8, by product type and supermajor currency (value of all trades in millions of USD), cleared swaps only, all participant types and tenors. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for currency 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: 162326d1339795586-counting-data-ignoring-certain-cells-question_unique-count-red-fuji-oeldere-
Sheet: Sheet1

15 | 15 |  | <= subtotal for visual cells.
Part Number | quantity in box A |  |  |  | quanity in box A (unique part numbers) NOT COUNTING THE ZERO QUANTITY | quanity in box A (unique part numbers) DOES COUNT THE ZERO QUANTITY
part # 01 | 2 |  |  |  | 13 | 15
part # 02 | 2 |  |  |  | This formula will ignore any rows that have a blank cell or a zero quantity. It will also ignore one of the duplicated Part Numbers. What should be left are non-duplicated parts with 1,2...  For a quantity. The final count should be 13 which is really a cell count rather than actual part quantity count. | This formula will ignore any rows that have a blank cell and ignore one of the duplicated Part Numbers. What should be left are non-duplicated part numbers with 0,1,2 ... For a quantity.  That count should be 15 which is really a cell count rather than actual part quantity count.
part # 03 | 0
part # 3 |  |  |  | Waarden
part # 05 | 1 |  | Rijlabels | Aantal van quantity in box A | Som van quantity in box A2
part # 05 | 3 |  | part # 01 | 1 | 2
part # 7 |  |  | part # 02 | 1 | 2
part # 08 | 1 |  | part # 03 | 1 | 0
part # 08 | 0 |  | part # 05 | 2 | 4
part # 10 | 2 |  | part # 08 | 2 | 1
part # 11 | 0 |  | part # 10 | 1 | 2
part # 12 | 1 |  | part # 11 | 1 | 0
part # 12 |  |  | part # 12 | 1 | 1
part # 14 |  |  | part # 14
part # 15 | 1 |  | part # 15 | 1 | 1
part # 16 |  |  | part # 16
part # 17 | 1 |  | part # 17 | 1 | 1
part # 18 |  |  | part # 18
part # 19 | 1 |  | part # 19 | 1 | 1
part # 20 |  |  | part # 20
part # 21 | 1 |  | part # 21 | 1 | 1
part # 22 | 3 |  | part # 22 | 1 | 3
part # 23 | 3 |  | part # 23 | 1 | 3
part # 24 | 1 |  | part # 24 | 2 | 1
part # 24 | 0 |  | part # 3
 |  |  | part # 7
 |  |  | Eindtotaal | 18 | 23
Spreadsheet: 71173d1271873891-chart-plots-blanks-and-n-a-as-zero-example
Sheet: Trending

 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
Station 1
Station 2
Station 3
Station 4
Station 5
Spreadsheet: 1e00b4a3-6b81-4804-826d-cd6c0df74226
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
A2F | Test | A2F | [NAME] and F, Blood | [NAME] and F | Cation Exchange/High-Performance Liquid Chromatography (HPLC) |  |  |  | 3 | mL | Container/Tube: Preferred: Lavender top (EDTA) Acceptable: ACD, heparin [NAME]: 3 mL Collection Instructions:  1. Submit fresh specimen. 2. Do not transfer blood to other containers. Additional Information: Patient's age is required. Forms:  1. Thalassemia/Hemoglobinopathy Patient Information Sheet (Supply T358) in Special Instructions 2. If not ordering electronically, please submit a Hematopathology/Molecular Oncology Request Form (Supply T241) with the specimen. | 1 mL | Hemolysis	Mild OK; Gross OK Thawing	NA Lipemia	NA Icterus	NA Other	NA | [NAME]: 0.0-2.1% 1-2 months: 0.0-2.6% 3-5 months: 1.3-3.1% > or =6 months: 2.0-3.3%  HEMOGLOBIN F 1-30 days: 22.8-92.0% 1-2 months: 7.6-89.8% 3-5 months: 1.6-42.2% 6-8 months: 0.0-16.7% 9-12 months: 0.0-10.5% 13-17 months: 0.0-7.9% 18-23 months: 0.0-6.3% > or =24 months: 0.0-0.9% | Monday through Saturday; 7 a.m. and 1 p.m. | Same day/1 day | 2 days | 1 | 83021 |  |  |  |  | Rochester
A2F | [NAME] | WBEDTA | [NAME] EDTA |  |  |  | Refrigerated | 7 days
A2F | Result | 2381 | [NAME] | [NAME] | Numeric |  |  |  |  | % |  |  |  |  |  |  |  |  |  | 4551-8 | [NAME]/Hemoglobin.total:MFr:Pt:[NAME]:Qn:
A2F | Result | 2382 | [NAME] | [NAME] | Numeric |  |  |  |  | % |  |  |  |  |  |  |  |  |  | 4576-5 | [NAME]MFr:Pt:[NAME]:Qn:
Spreadsheet: e173c37b-f529-4f99-8523-cb9016d3b2c6
Sheet: Filled out

FINANCIAL STATEMENT
 | 2005-03-31 00:00:00 | 2005-06-30 00:00:00 | 2005-09-30 00:00:00 | 2005-12-31 00:00:00 | 2006-03-31 00:00:00
CASH
Bank Account #1
Bank Account #2
Checking Account
Credit Union Savings
CD
Other
[NAME]
401(k) Plan
IRA #1
IRA #2
HOUSE
Purchase Price
minus [NAME]
Net House Value
CONSUMER DEBTS
Car Loan
Credit Card #1
Credit Card #2
Spreadsheet: 942067ff-ac5e-4a47-8cf3-625371b186b8
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FRTIX | Test | FRTIX | Free Thyroxine Index (FTI), Serum | Free Thyroxine Index (FTI), S | Chemiluminometric Immunoassay | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL | 0.4 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm reject Cold OK Lipemia	NA Icterus	NA Other	NA | T-UPTAKE Males: 27-37% Females: 20-37%  FREE THYROXINE INDEX Males <1.5 suggest hypothyroidism 1.5-3.0 suggest euthyroidism >3.0 suggest hyperthyroidism Females <1.3 suggest hypothyroidism 1.3-3.0 suggest euthyroidism >3.0 suggest hyperthyroidism   THYROXINE, TOTAL Males 0-11 months: not established 1-9 years: 6.0-12.5 mcg/dL 10-23 years: 5.0-11.0 mcg/dL > or =24 years: 5.0-12.5 mcg/dL Females 0-11 months: not established 1-9 years: 6.0-12.5 mcg/dL 10-17 years: 5.0-11.0 mcg/dL > or =18 years: 5.0-12.5 mcg/dL | Monday through Friday, Sunday; 6 a.m.-3 p.m. | Same day/1 day | 2 days |  | Profile |  |  |  |  | Rochester
FRTIX | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
FRTIX | Result | T4S | Thyroxine, Total, S | Thyroxine, Total, S | Numeric |  |  |  |  | mcg/dL |  |  |  |  |  |  |  |  |  | 3026-2 | Thyroxine:MCnc:Pt:Ser/Plas:Qn:
FRTIX | Result | TUP | T3 (Triiodothyronine), Uptake, S | T3 (Triiodothyronine), Uptake, S | Numeric |  |  |  |  | % |  |  |  |  |  |  |  |  |  | 3050-2 | Triiodothyronine resin uptake (T3RU):NFr:Pt:Ser/Plas:Qn:
FRTIX | Result | FRTI | Free Thyroxine Index | Free Thyroxine Index | Numeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32215-6 | Thyroxine free index:ACnc:Pt:Ser/Plas:Qn:
FRTIX | Billing Component | FRTIX |  | T3 Uptake |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 84479
FRTIX | Billing Component | FRTIX |  | Thyroxine Total |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 84436
Spreadsheet: 866363d1713293606-issues-getting-sum-formula-to-work-kansas-scheduler-v4-5-etaf
Sheet: ALL JOBS

 |  |  | DO NOT EDIT THIS SHEET- IT IS A REFERENCE SHEET!  DATA IS PULLED HERE FROM DIGITAL AND FABRIC TABS.
Press | SchedTime | Due Date | Job# | Line# | Master [NAME] | QTY | H | W | Material | Sides | PrintMode | Kitting | #OfKits | Notes | DateRecieved | SqFt | LinearFT
Spreadsheet: harry_arora__12143__dealbench deals 012401
Sheet: Sheet1

DEALBENCH DEALS - Inception to
2001-01-24 00:00:00
[NAME] | 7 | 1000000000 | A&D
Enron India Dataroom | 1 | 800000000 | A&D
Enron China DataRoom | 1 | 50000000 | A&D
Lighting Fixtures - EPS | 1 | 2000000 | Auctions
Carpet - EPS | 1 | 2100000 | Auctions
Ceiling Tiles - EPS | 1 | 822000 | Auctions
Exit Signs -EES | 1 | 890000 | Auctions
[NAME] | 1 | 11000000 | Auctions
EBS - Switches | 1 | 300000000 | Auctions
EBS - Switches (2) | 1 | 22500000 | Auctions
Enron Syndication | 1 | 3000000000 | Banking
Enron Multi-Tier Facility | 1 | 485000000 | Banking
AUR Mining Resources / Chilean Mine | 1 | 170000000 | Banking
Enron Funding Corp 2nd Amendment | 1 | 355000000 | Banking
Zepherus | 1 | 481725000 | Banking
VPP Deal | 1 | 250000000 | Banking
Project Inauguration | 1 | 460750000 | Banking
Vitro ([NAME]) - debt | 1 | 90000000 | Banking
Hawaii - 125 | 1 | 300000000 | Banking
Enron Europe/RBS Financial | 1 | 200000000 | Banking
Quafco 4 Expansion | 1 | 500000000 | Banking
[NAME] amendment | 1 | 513000000 | Banking
Arcos | 1 | 580000000 | Banking
Project Electra | 1 | 400000000 | Banking
Orbis SA - SocGen | 1 | 50000000 | Banking
Seneca | 15 | 100000000 | Leasing
BankOne | 1 | 7000000 | Leasing
BankOne | 1 | 20000000 | Leasing
Fifth Third | 1 | 15000000 | Leasing
Fifth Third | 1 | 4000000 | Leasing
Spreadsheet: 192672d1352486359-coding-macros-for-a-class-shapes-area-etc-macrohelp
Sheet: Problem3

Make a code that calculates the area of the squares and rectangles dimensioned below.
The code also needs to determine whether or not an object in rectangular or square.
The box on the right shows what your final result should look like.
SHAPE 1 |  |  |  |  | (answers)
Length | 2 |  |  |  | Length | 2
[NAME] | 4.5 |  |  |  | [NAME] | 4.5
Area |  |  |  |  | Area | 9
Shape |  |  |  |  | Shape | Rectangle
SHAPE 2 |  |  |  |  | SHAPE 2
Length | 2.5 |  |  |  | Length | 2.5
[NAME] | 2.5 |  |  |  | [NAME] | 2.5
Area |  |  |  |  | Area | 6.25
Shape |  |  |  |  | Shape | Square
Spreadsheet: louise_kitchen__24139__ubsfinal
Sheet: Sheet1

 | Commercial:
 | Texas Gas Trading |  |  |  | 4
 | East Gas Trading |  |  |  | 6
 | Central Gas Trading |  |  |  | 5
 | West Gas Trading |  |  |  | 9
 | Nymex Desk Trading |  |  |  | 5
 | Derivatives Marketing |  |  |  | 7
 | Gas Outsourcing |  |  |  | 4
 | Texas Gas Origination |  |  |  | 2
 | East Gas Origination |  |  |  | 2
 | Central Gas Origination |  |  |  | 2
 | West Gas Origination |  |  |  | 5
 | Ercot Power Trading |  |  |  | 3
 | Northeast Power Trading |  |  |  | 6
 | Midwest Power Trading |  |  |  | 3
 | Southeast  Power Trading |  |  |  | 4
 | East Options Trading |  |  |  | 3
 | East Power Services |  |  |  | 1
 | Ercot Power Origination |  |  |  | 3
 | Northeast Power Origination |  |  |  | 4
 | Midwest Power Origination |  |  |  | 3
 | Southeast Power Origination |  |  |  | 3
 | Southwest Power Trading |  |  |  | 2
 | California Power Trading |  |  |  | 3
 | Northwest Power Trading |  |  |  | 3
 | West Power Services |  |  |  | 1
 | Southwest Power Origination |  |  |  | 2
 | California Power Origination |  |  |  | 3
 | Northwest Power Origination |  |  |  | 3
 | Western Canada Gas and Power Trading |  |  |  | 8
 | Western Canada Gas and Power Origination |  |  |  | 8
 | Eastern Canada Gas and Power Trading |  |  |  | 2
 | Eastern Canada Gas and Power Trading |  |  |  | 2
 | Leadership |  |  |  | 2 | 2
 | Admins for Houston Commercial |  |  |  | 11
 | Admins for Portland Commercial |  |  |  | 4
 | Regulatory Affairs |  |  |  | 8
 | Fundamentals |  |  |  | 32
 | Structuring |  |  |  | 3
 | Weather |  |  |  | 5
 | Credit |  |  |  | 12
 | Market Risk |  |  |  | 3
 | Research |  |  |  | 2
 | HR |  |  |  | 9
 | Legal |  |  |  | 18
 | Operations:
 | Gas Risk Management
 | Gas Volume Management
 | Gas Logistics
 | Gas Settlements
 | Power Risk Management
 | Power Volume Management
 | Power Logistics
 | Power Settlements
 | Documentation
 | Power Real Time |  |  |  | 20
 | Management
 | Admins for Operations |  |  |  |  | 120
 | IT
 | IT Development |  |  |  | 121
 | IT Infrastructure |  |  |  | 59
 | EOL Support |  |  |  | 30
 | Admins for IT
 | Accounting
 | Accounting, Transaction Support |  |  |  | 39
 | Cash Operations |  |  |  | 6
 | Tax |  |  |  | 2
 | Canada Support |  |  |  |  | 25
Spreadsheet: 587319d1534955819-flagging-values-after-certain-text-samplesheets
Sheet: Original

Q1 | Q2 | Q3 | Q4 | Q5 | Q6 | Q7 | Q8 | Q9 | Q10 | Q11 | Q12 | Q13 | Q14 | Q15 | Q16 | Q17 | Q18
2 | 3 | 4 | 3 | 3 | 3 | 5 | 1 | 3 | 2 | 2 | 3 | 5 | 5 | - | - | - | -
2 | 3 | 4 | 3 | 3 | 4 | 3 | 5 | 3 | 2 | 3 | - | 2 | 1 | 5 | -999 | -999 | -
2 | 5 | 1 | 2 | 2 | 5 | 1 | 1 | 2 | 2 | 3 | 4 | 4 | 5 | 5 | 4 | 5 | 5
2 | 2 | 1 | 2 | 2 | - | - | - | - | - | - | - | - | - | - | - | - | -
5 | 1 | 4 | 1 | 5 | 3 | 1 | 4 | 2 | 1 | 2 | 5 | 2 | 3 | - | - | - | -
- | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | 5
2 | 3 | 4 | 3 | 3 | 2 | 5 | 1 | 4 | 1 | - | - | - | - | - | - | - | -
5 | 4 | 4 | 2 | 2 | - | - | - | - | - | - | - | - | - | - | - | - | -
-999 | 2 | 2 | 5 | 2 | 2 | 1 | 1 | 1 | 3 | 3 | 4 | 1 | 3 | - | - | - | -
4 | 1 | 1 | 5 | 2 | 4 | 3 | 3 | 2 | 2 | 1 | 1 | 4 | 5 | 3 | 4 | 4 | -
4 | 1 | 5 | 5 | 5 | 5 | 5 | 5 | 2 | 4 | 3 | 3 | 3 | 2 | 2 | 4 | 5 | -
4 | 4 | 5 | 1 | 3 | 2 | 5 | 5 | - | - | 3 | 3 | 3 | 4 | - | - | - | -
4 | 1 | 1 | 5 | - | - | - | - | - | - | - | - | - | - | - | - | - | -
4 | 4 | 3 | 5 | 2 | 4 | 4 | 3 | 4 | 1 | 1 | - | - | - | - | - | - | -
2 | 2 | 5 | 4 | 1 | 4 | 5 | 5 | - | - | - | - | - | - | - | - | - | -
1 | 1 | 5 | 1 | 3 | - | - | - | - | - | - | - | - | - | - | - | - | -
4 | 5 | 5 | 5 | - | - | - | - | - | - | - | - | - | - | - | 4 | 1 | 1
- | 5 | 1 | 3 | - | - | - | - | - | - | - | - | - | - | - | - | - | -
Spreadsheet: 150425d1334524075-excel-2007-coding-stock-market-data-ganesh2cbe
Sheet: Sheet1

Date open high low close |  |  |  | Date | open | high | low | close | Mid Point | Close | Open | Profit | Loss
2008.05.30 4899 4908 4832 4849 |  |  |  | 2008.05.30 | 4899 | 4908 | 4832 | 4849
2008.06.02 4875 4890 4695 4723 |  |  |  | 2008.06.02 | 4875 | 4890 | 4695 | 4723
2008.06.03 4655 4712 4630 4703 |  |  |  | 2008.06.03 | 4655 | 4712 | 4630 | 4703
2008.06.04 4681 4720 4550 4568 |  |  |  | 2008.06.04 | 4681 | 4720 | 4550 | 4568
2008.06.05 4598 4685 4530 4677 |  |  |  | 2008.06.05 | 4598 | 4685 | 4530 | 4677
2008.06.06 4705 4705 4590 4606 |  |  |  | 2008.06.06 | 4705 | 4705 | 4590 | 4606
2008.06.09 4497 4510 4400 4471 |  |  |  | 2008.06.09 | 4497 | 4510 | 4400 | 4471
2008.06.10 4438 4470 4332 4435 |  |  |  | 2008.06.10 | 4438 | 4470 | 4332 | 4435
2008.06.11 4465 4519 4450 4488 |  |  |  | 2008.06.11 | 4465 | 4519 | 4450 | 4488
2008.06.12 4388 4525 4370 4511 |  |  |  | 2008.06.12 | 4388 | 4525 | 4370 | 4511
Spreadsheet: e22349bf-97f6-4cbd-aef6-269d7f73e2e4
Sheet: Sheet1

1er paso: crear dos columnas, uma com los datos de las abscisas y outra com los datos de las ordenadas | Unnamed: 1
x | y
1 | 85
2 | 60
3 | 45
4 | 87
5 | 250
6 | 95
7 | 158
8 | 300
9 | 1000
10 | 900
11 | 850
2do paso seleccionar los datos, y em el ícone de gráficos, [NAME] a dispersión XY. [NAME]
3er paso. Hacer clic em los puntos, y agregar [NAME]. Usar la opción de incluir ecuación em el gráfico
Spreadsheet: 719184d1613550535-calculate-the-frequency-of-answers-per-column-of-all-columns-sample-for-forum
Sheet: Sheet1

COLUMN A | COLUMN B | COLUMN C | COLUMN Z |  |  | ColumnA | Result
2 | A | 23 | a
2 | D | 43 | d |  |  | 1 | 2 | D | 2 | 43 | 1
2 | A | 33 | f |  |  |  |  | S | 1 | 33 | 3
1 | S | 77 | a |  |  |  |  | U | 1 | 77 | 2
2 | D | 77 | f
2 | U | 33 | d
1 | A | 33 | a
Spreadsheet: 116705d1312032214-masterfile-to-subfile-updating-transaction
Sheet: 0001

Contact Person | Com Code | Company | Truck ID | Make | Model | Date | Job Description | Parts | Hours | Call No | Inv Amt | Paid | 2nd Pay | 3rd Pay | Balance |  | Total O/S
Miss [NAME] | 0001 | ABC Pipes | FL1234 | Nissan | PL02A25 | 25.06.11 | overhaul engine |  | 15 | 1405 | 1000 | 200 | 400 |  | 400 |  | 2300
Miss [NAME] | 0001 | ABC Pipes | FL1235 | Nissan | PL02A25 | 24.06.11 | lube service |  | 4 | 1406 | 250 | 250 |  |  | 0
Miss [NAME] | 0001 | ABC Pipes | FL1226 | Toyota | AGE25D | 24.06.11 | lube service |  | 4 | 1407 | 250 | 100 |  |  | 150
Miss [NAME] | 0001 | ABC Pipes | FL1234 | Nissan | PL02A25 | 27.07.11 | brake service |  | 8 | 1408 | 500 | 300 |  |  | 200
Miss [NAME] | 0001 | ABC Pipes | FL1234 | Nissan | PL02A25 | 24.07.11 | headlight repair |  | 2 | 1410 | 150 | 150 |  |  | 0
Spreadsheet: mary_hain__25844__4th qtr 2000 GENCO FERC
Sheet: Caledonia Operations

SCC - L2, L.L.C. (Caledonia)
FERC Filing
Generation Sales:
Organization Name | Transaction Type | Firm/Interruptable | Volume (MW) | Min Price | [NAME] | Point Name
Enron Power Marketing Inc. | S | F | -7200 | 58 | 58 | ENSE-Caledonia-ENSE
Total Generation Sales