tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 78296d1278679091-the-sum-of-cells-based-on-lookup-yka_help
Sheet: Sheet1

Part # | Qty | Price
1 | 100 | 2
1 | 200 | 3
1 | 300 | 4
1 | 400 | 5
1 | 500 | 6
1 | 600 | 7
2 | 700 | 8
2 | 800 | 9
2 | 900 | 10
2 | 1000 | 11
2 | 1100 | 12
2 | 1200 | 13
2 | 1300 | 14
3 | 1400 | 15
3 | 1500 | 16
3 | 1600 | 17
3 | 1700 | 18
3 | 1800 | 19
3 | 1900 | 20
3 | 2000 | 21
4 | 2100 | 22
4 | 2200 | 23
4 | 2300 | 24
4 | 2400 | 25
4 | 2500 | 26
4 | 2600 | 27
4 | 2700 | 28
Spreadsheet: 6155d66a-293e-4338-8fce-08ef30288fc6
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Current | Unnamed: 3 | 1 - 30 | Unnamed: 5 | 31 - 60 | Unnamed: 7 | 61 - 90 | Unnamed: 9 | > 90 | Unnamed: 11 | TOTAL
 | ABC Digital | 0 |  | 1599 |  | 0 |  | 0 |  | 0 |  | 1599
 | CollabNet, Inc. | 12500 |  | 12500 |  | 0 |  | 0 |  | 0 |  | 25000
 | Inflectra Corporation | 0 |  | 0 |  | 1750 |  | 0 |  | 0 |  | 1750
 | LeanKit | 0 |  | 0 |  | 7500 |  | 0 |  | 0 |  | 7500
 | Opscode | 0 |  | 0 |  | 4500 |  | 0 |  | 0 |  | 4500
 | Perforce | 0 |  | 5000 |  | 0 |  | 0 |  | 0 |  | 5000
 | Red Gate Software | 0 |  | 0 |  | 4500 |  | 0 |  | 0 |  | 4500
 | Scripps Networks | 0 |  | 1599 |  | 0 |  | 0 |  | 0 |  | 1599
 | Scrum.org | 0 |  | 0 |  | 0 |  | 5000 |  | 5000 |  | 10000
 | [NAME]} | 10000 |  | 0 |  | 0 |  | 0 |  | 0 |  | 10000
 | Smits Management Consultancy LLC | 0 |  | 1250 |  | 0 |  | 0 |  | 0 |  | 1250
 | Vanguard | 6696 |  | 0 |  | 0 |  | 0 |  | 0 |  | 6696
TOTAL |  | 29196 |  | 21948 |  | 18250 |  | 5000 |  | 5000 |  | 79394
Spreadsheet: 377077d1423782572-find-value-that-doesnt-match-and-bring-back-column-heading-updated-file-ndm
Sheet: Year 2

PersID | PosCode | Org1 | Org2 | Org3 | Non-Matching Value from Year 1 | Location of non-matching value from Year 1 | Header
1001 | 21 | 8 | A1 | SS1 |  |  |  | Drag these formula in columns F, G, H down as far as needed
1002 | 21 | 9 | A2 | AQ1
1003 | 22 | 11 | B3 | D34
1004 | 23 | 12 | B2 | DW4
1005 | 23 | 22 | C1 | SS2
1006 |  | 8 | A1 | SS1
1007 |  | 9 | A2 | AQ1
1008 |  | 11 | B3 | D34
1009 |  | 12 | B2 | DW4
1010 |  | 22 | C1 | SS2
1011 |  | 8 | A1 | SS1
1012 |  | 9 | A2 | AQ1
1013 |  | 11 | B3 | D34
1014 |  | 12 | B2 | DW4
1015 |  | 22 | C1 | [NAME]
Spreadsheet: 182555d1348524632-capturing-matched-data-from-one-tab-to-another-test-file-to-show-challenge
Sheet: Teacher info

School name | Teacher Surname | Teacher First Name | [NAME] | Course code1 | Course code2 | Course code3
School1 | Surname1 | FirstName 1 |  | C1 | AWT1 | JM2
School1 | Surname2 | FirstName 2 |  | AC1 | AWT1 | C1
School2 | Surname3 | FirstName 3 |  | JM2 | AC2
School3 | Surname4 | FirstName 4 |  | AC1 | JM2 | C1
School3 | Surname5 | FirstName 5 |  | JM2 | C1 | AC2
Spreadsheet: 752701d1634906693-formula-to-sort-by-road-name-first-then-by-house-number-test-worksheet-to-sort-formula
Sheet: Sheet1

 | 150/152 & 154/158 [NAME] | 1 Bell Road | 2 Bell Road | Cottage | 13 Oak Road | 18 Oak Road | 14 Random Street | 2 Random Street | 22 Random Street
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Income
Commercial Rental Income | 13041.75 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Interest Receivable | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Other Revenue | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Residential Rental Income | 0 | 292 | 2130 | 3490 | 409.5 | 370 | 388 | 5195 | 328
Total Income | 13041.75 | 292 | 2130 | 3490 | 409.5 | 370 | 388 | 5195 | 328
Spreadsheet: 823113d1679715637-summarizing-a-workbook-lego-replacement-parts
Sheet: Set # 7660

Checked | Qty | Part# | Colour | Description
 | 2 | 4211804 | Light Grey | PLATE 1X2 W/FORK/VERTICAL/END
 | 15 | 4211063 | [NAME] | PLATE 1X2
 | 2 | 4211388 | Light Grey | BRICK 1X2
 | 1 | 4210762 | [NAME] | BRICK 1X2 M. 2 HOLES Ø 4,87
 | 2 | 4211183 | Reddish Brown | ROUND BRICK 1X1
 | 1 | 4288513 | [NAME] | BRICK 1X2 WITH STICK
 | 2 | 4505141 | [NAME] | Wedge, Plate 3 x 3 Cut Corner
 | 2 | 4211064 | [NAME] | ROOF TILE 2X3/25° INV.
 | 2 | 4505142 | [NAME] | Plate, Round Corner 4 x 4
 | 6 | 4211190 | Reddish Brown | Plate 1 x 4
 | 3 | 4507045 | [NAME] | Tile 2 x 2 with Groove
 | 2 | 4245599 | Reddish Brown | Tile, Round 2 x 2
 | 2 | 4265484 | Black | BRICK 1X2 W/STUB VERTICAL END
 | 6 | 4140588 | Black | PLATE 1X2 [NAME]
 | 3 | 4278274 | [NAME] | SLIDE SHOE ROUND 2X2
 | 2 | 4223247 | Black | SPACE SKELETON ARM
 | 2 | 4293756 | [NAME] | Wedge 4 x 4 Triple Curved No Studs
 | 1 | 4211397 | Light Grey | Plate 2 x 2
 | 2 | 4544720 | Trans Red | Cone 1 x 1 without Top Groove
 | 4 | 4290055 | Reddish Brown | ROOF TILE 2X16X1, 11°
 | 4 | 4507047 | [NAME] | FLAT TILE 1X6
Spreadsheet: tracy_geaccone__40591__CF_GPG_CONS
Sheet: JULYYTD 

Enron Gas Pipeline Group
Statement of Consolidated Cash Flows
For the 7 months ended July 31, 2000
 | CONSOLIDATED |  |  |  |  |  |  | HPLO | HPL | LRC | LIQUIDS | GATHER | LIQUIDS | SERVICE | GPG CASH |  |  | TOTAL
(In Thousands) | GPG & EOTT |  | GPG | NNG | TW | EC | NP | 543 | 584 | 583 | DOMESTIC |  | GROUP | COS | SERVICES | OTHER |  | EOTT
Operating Cash Inflows (Outflows)
Net income before financing costs
Financing costs
NI after financing costs (excluding cons subs equity earn)
Depreciation, depletion and amortization
Deferred income taxes
Gains on sales of assets and investments
Dividends on pref securities of subsidiary cos.
Equity earnings
Equity/partnership distributions |  |  |  | 1634 |  |  | 1632
Other, net |  |  |  |  |  | 0 |  | 1 | 50 | -2 | -7964 |  |  | 4948 | 0 | -211
Funds Flow
Changes in components of working capital
Receivables |  |  |  | 27018 | 441 |  | -119 | 13 | -2066 | 276 | 26 |  |  | -49 | -1973 | 108
A/R, A/P - Intercompany |  |  |  |  |  |  | -2133 | -16 | 3190 | -808 | -22902 |  |  |  | 83597 | 350
Inventories |  |  |  | 72 | 130 |  |  |  |  |  | 173
Prepayments |  |  |  | 0 | 6
Payables |  |  |  | 4531 | -2666 |  | 360 |  | -894 | 10 | -110 |  |  | -38 | 5631 | -118
Exchange Rec/Payable |  |  |  | 5618 | -535 |  | 0
Accrued taxes |  |  |  | -354 | 297 |  | 0 |  | 2 | -1 | -1572 | 0 |  | -538
Accrued interest |  |  |  | 2875 | 39
Other working capital |  |  |  | -7436 | 336 |  | -1060 |  | -122 | 2 | 3 |  |  | 1199 |  | -4
Total changes in components of working capital
Net Cash Provided by Operating Activities
Investing Cash Inflows (Outflows)
Proceeds from sale of assets and investments |  |  |  | 5479 | 0
Capital Expenditures |  |  |  | -22225 | -15273
Underground Storage,Salvage & Removal Costs
EOTT Revolver and API's |  |  |  | 0 | 0
Other investing activities - intercompany |  |  |  | 0 | 0
Other investing activities, net |  |  |  | -14 | 0
Net Cash Provided by Investing Activities
Cash Flows From Financing Activities
Net increase (decrease) in short-term borrowings |  |  |  |  | 0
Issuance of long-term debt |  |  |  |  | 150000
Repayment of long-term debt |  |  |  |  | -123000
Other financing activities - I/C
Other financing activities, net
Net Cash Provided by Financing Activities
INC (DEC) IN CASH & CASH EQUIV, I/C CASH FROM CORP
INC (DEC) IN CASH & CASH EQUIV |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 84 | 5
INC (DEC) INTERCOMPANY CASH FROM CORPORATE
Change in other obligations |  |  |  | -45 | -27000 | 0 | 0 | 145 | -995 | 849 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
Change in total obligations
Spreadsheet: 871648d1718073049-time-saving-template-help-template-help
Sheet: Sheet1

Topic | Time topic takes per week/hours | employees in department | Department | time saving per year to remove topic per department | time saving per year to remove topic per FTE based on 38 hour week
Topic 1 | 4 | 7 | Blue | ? | ?
Topic 2 | 5 | 8 | Blue | ? | ?
Topic 3 | 6 | 4 | Green | ? | ?
Topic 4 | 7 | 10 | Green | ? | ?
Spreadsheet: phillip_m_love__30150__9907_OA
Sheet: RECLASS

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - RECLASSES
COMPANY:  ALL
REGION: ALL
 |  |  | Total |  | Central |  | Northeast |  | Southeast-LRC |  | Southeast-EGM |  | West |  | Texas-HPLR |  | Texas-EGM |  | Texas-HPLC |  | Storage |  | Ontario |  | BUG
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron |  |  |  |  |  |  | 1453427 |  |  |  |  | -452583 |  |  |  | 0 |  | 0
2 |  | Liquidations |  |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  | 0 |  | -1416080
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron |  |  |  | 613000 |  |  | -1453427 |  |  |  |  | -98594
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage |  |  |  |  |  | 67860
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 564737
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity |  |  |  |  |  |  |  |  |  |  |  | 18808
25 |  | Demand |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -26233
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 155000
34 |  | Originations |  |  |  |  |  |  |  |  |  |  |  | -130700 |  |  |  |  |  |  |  |  |  |  |  | 130700
35 |  | Broker Fees
36 |  | Asset Group Demand Charges |  |  |  |  |  | 15000 |  |  |  |  |  |  |  |  |  |  |  | -15000 |  | 0
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
Spreadsheet: 698821d1602189011-conditional-formating-with-a-formula-and-icon-set-xlf20201008-example-cf_arrow_icons-for_analyst1234-as
Sheet: Sheet1

Store | Location | CY | PY | [NAME] | Comp % | 1 | 1 PY | Arrows
4 | OAKVILLE | 230865.74 | 191276.6 |  | 0.2069732523476475 | 5002 | 10349.98
11 | Sherway | 230865.74 | 191276.6 |  | 0.2069732523476475 | 1231223 | 10349.98
25 | University | 230865.74 | 191276.6 |  | 0.2069732523476475 | 12312 | 10349.98
27 | Kirkland | 230865.74 |  |  | 0.2069732523476475 | 32 | 10349.98
36 | Bayers | 230865.74 | 250000 |  | 0.2069732523476475 | 312 | 10349.98
49 | Marche | 69054.91 | 56249.02 |  | 0.2276642330835275 | 14606.67 | 5511.48
Spreadsheet: 771389d1646652009-how-will-index-match-work-with-name-range-over-12-sheets-or-with-a-vba-test
Sheet: Style Detail

 |  | [NAME] type 1 | [NAME] type 2 | [NAME] type 3
Inv # | Style No. | Unit Price
1 | WTB181693
2 | WTB371652
3 | WTC181281
4 | WTC181275
5 | WTC181304
6 | [NAME]
7 | WTB371647
8 | WTC181313
9 | WTC181260
10 | WTC181297
11 | WTE181121
12 | WTB181678
Spreadsheet: 833670d1687187629-auto-fill-using-xlookup-19jun-aligw
Sheet: Training

Type of Training | Date of Training | Employee Name | Employee Number | Topic | Trainer | Completed
Scheduled Monthly Tailgate | 2023-06-19 00:00:00 | [NAME] |  |  |  | Absent - Vacation
HEO Rubber Tire | 2023-06-20 00:00:00 | [NAME]
Spreadsheet: 813964d1674075121-employee-rotation-taking-into-account-expected-absences-libro2
Sheet: Week 7

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Ubicaciones
 |  |  |  |  |  |  |  |  |  |  |  |  |  | BCN | PRAT
 |  |  |  |  |  | Lun, 13/02 | Mar, 14/02 | Mie, 15/02 | Jue, 16/02 | Vie, 17/02
 | Empleado | Ausencias
 | AA A | EE E |  |  |  |  | DD D |  | AA A
 | BB B |  |  |  |  |  | BB B |  | CC C
 | CC C
 | DD D
 | EE E
Spreadsheet: errol_mclaughlin_jr__10717__Zipper LTD Reconciliation 10-01
Sheet: ACCRUAL

Enron Capital & Trade Resources
Financial Ops - Portfolio Accounting
Income Statement Reconciliation - 2001 LTD
 | Book(s): |  | Power Cross Commodity | NG-X-OPT-PWR  ([NAME])
 | Month: |  | 2000-11-01 00:00:00 | 2001-10-01 00:00:00
Responsibility Codes:  Financial Ops/Power East (TVA), Power Settlements (PS), [NAME] (GAS), To Be Determined (TBD)
Types of Variances:  Prior Year Adjustments (P), Current Year Adjustments - Timing (T), Exposure (E), Other (O)
(Inc)/Exp
 | Resp. |  |  |  | Outstanding
Month | Code | Type | Description | Description | 2000 ADJ* | 2001-07-31 00:00:00 | 2001-08-31 00:00:00 | 2001-09-30 00:00:00 | 2001-10-31 00:00:00 | 2001-11-30 00:00:00 | 2001-12-31 00:00:00 |  | Total
2001-08-01 00:00:00 | FO |  |  | MTM not booked
2001-08-01 00:00:00 | RM |  |  | Unknown liquidation variance; no support from Risk |  |  | -40960
2001-09-01 00:00:00 | RM |  |  | Squeeze between Beginning balances and Ending Balances did not tie to month to date income.   There was a problem in the file.   Sent e-mail and voice mail to Errol to correct.  DPR to take adjustment as expense was never recognized. |  |  |  | 795090
2001-09-01 00:00:00 | RM |  |  | Variance between Zipper and East Power  - no support from Risk |  |  |  | -330959
2001-09-01 00:00:00 | RM |  |  | Liquidations beginning balance for Sept changed from ending balance in Aug file. |  |  |  | 647
 |  |  |  | SUBTOTAL
 |  |  |  | Subtotal 2001 Outstanding Adjustments
 |  |  |  |  | Power Cross Commodity Accrual
 |  |  |  |  | Difference
*  FOR RESPONSIBILITY CODE:         RM = (DR)/CR
FOR RESPONSIBILITY CODE:       FS or FO = DR/(CR)
**  IF THE AMOUNT IN THIS COLUMN IS:
(BRACKETED) = DPR IS LESS THAN THE G/L
W/O BRACKETS = DPR IS GREATER THAN THE G/L
Spreadsheet: 539627d1506308251-return-month-value-return-month-value
Sheet: Sheet1

Example: | Data base up until Aug-17 | 2017-08-01 00:00:00 |  | Data base up until Sep-17 | 2017-09-01 00:00:00 |  | Data base up until Oct-17 | 2017-10-01 00:00:00
 | Month | Result Month # |  | Month | Result Month # |  | Month | Result Month #
 | What I want to accomplish is:
 | I want my months to have a number, being "1" the month I have most recent information, in this case Aug-17
 | However, once I have Sep information, I want the number of the month to restate itself into "1" and so on, so I don't have to do it manually.
 | Thanks
 | D2S
Spreadsheet: 487636d1478179103-power-pivot-and-data-model-theory-powerpivot-test
Sheet: Sheet2

 | Empl./Appl.Name | Pers.No. | Date | Hours | Time type descript. | Cost Ctr | Org. Unit | Org. Unit2 | Pers. subarea | Job key | EE subgroup | EE subgrp | Subarea | TmType | Work schedule rule (short) | End Date | Position
 | BRUCE |  | 2016-05-15 00:00:00 | 8 | Vacation | 102564 | 86428264 | S1 FINL | Gr1 [NAME] | clown | CP Regular Full-time | 7A | 0210 | 9310 | Y010101 | 9999-12-31 00:00:00 | 81966669
 | PAULA |  | 2016-05-16 00:00:00 | 7.97 | Regular Hours | 102564 | 86428264 | S1 FINL | Gr1 [NAME] | chef | CP Regular Full-time | 7A | 0210 | 9310 | Y010101 | 9999-12-31 00:00:00 | 83097483
 | NELSON |  | 2016-05-17 00:00:00 | 8 | Regular Hours | 102564 | 86810277 | S3 COMM | Gr1 [NAME] | cop | CP Regular Full-time | 7A | 0210 | 9310 | 0003101 | 9999-12-31 00:00:00 | 80450197
 | PAT |  | 2016-05-18 00:00:00 | 8 | Regular Hours | 102564 | 86817286 | S1 FINL | Gr1 [NAME] | teacher | CP Regular Full-time | 7A | 0210 | 9310 | Y010101 | 9999-12-31 00:00:00 | 81964143
 | CLAUDE |  | 2016-05-19 00:00:00 | 8 | Regular Hours | 102564 | 86329401 | S1 DOCK | Gr1 [NAME] | lawyer | CP Regular Full-time | 7A | 0210 | 9310 | 0003087 | 9999-12-31 00:00:00 | 81965468
 | DANIEL |  | 2016-05-20 00:00:00 | 8 | Sick | 102564 | 86817286 | S1 FINL | Gr1 [NAME] | clown | CP Regular Full-time | 7A | 0210 | 9310 | Y010101 | 9999-12-31 00:00:00 | 81964135
 | MARK |  | 2016-05-21 00:00:00 | 8 | Vacation | 102564 | 86344737 | S3 COMM | Gr1 [NAME] | clown | CP Regular Full-time | 7A | 0210 | 9244 | 0003101 | 9999-12-31 00:00:00 | 80460710
 | WILLIAM |  | 2016-05-22 00:00:00 | 8 | Regular Hours | 102564 | 86344737 | S3 COMM | Gr1 [NAME] | waiter | CP Regular Full-time | 7A | 0210 | 9310 | 0003101 | 9999-12-31 00:00:00 | 83102972
 | GEOFF |  | 2016-05-23 00:00:00 | 7.92 | Regular Hours | 102564 | 86329401 | S1 DOCK | Gr1 [NAME] | unemployed | CP Regular Full-time | 7A | 0210 | 9310 | 0003087 | 9999-12-31 00:00:00 | 83152755
 |  |  | Sum of Hours | Column Labels
 |  |  | Row Labels | chef | clown | cop | lawyer | teacher | unemployed | waiter | Grand Total
 |  |  | BRUCE |  | 8 |  |  |  |  |  | 8
 |  |  | CLAUDE |  |  |  | 8 |  |  |  | 8
 |  |  | DANIEL |  | 8 |  |  |  |  |  | 8
 |  |  | GEOFF |  |  |  |  |  | 7.92 |  | 7.92
 |  |  | MARK |  | 8 |  |  |  |  |  | 8
 |  |  | NELSON |  |  | 8 |  |  |  |  | 8
 |  |  | PAT |  |  |  |  | 8 |  |  | 8
 |  |  | PAULA | 7.97 |  |  |  |  |  |  | 7.97
 |  |  | WILLIAM |  |  |  |  |  |  | 8 | 8
 |  |  | Grand Total | 7.97 | 24 | 8 | 8 | 8 | 7.92 | 8 | 71.89
Spreadsheet: 173b3307-149a-4bde-81b9-2da2489ed350
Sheet: Denials 2006

MULTNOMAH COUNTY LOAN DENIAL RATES BY INCOME-RACE GROUPINGS : 2006
Home Purchase & Occupation
I.  Total Applications
Race/Ethnicity | 0-30% MFI | 31-50% MFI | 51-80% MFI | 81-95% MFI | >95% MFI | Total
American Indian | 1 | 10 | 53 | 32 | 84 | 191
Asian | 6 | 49 | 361 | 245 | 952 | 1720
Blacks | 2 | 39 | 147 | 89 | 268 | 575
Native Hawaiian or Pacific Islander | 2 | 7 | 46 | 18 | 81 | 164
White | 98 | 511 | 2913 | 1921 | 8017 | 14270
Hispanic | 8 | 64 | 389 | 303 | 592 | 1439
Overall Total | 133 | 688 | 3822 | 2467 | 10215 | 18461
II.  Total Denials
 | 0-30% MFI | 31-50% MFI | 51-80% MFI | 81-95% MFI | >95% MFI | Total
American Indian | 1 | 2 | 15 | 7 | 10 | 37
Asian | 3 | 7 | 54 | 31 | 156 | 280
Blacks | 1 | 8 | 27 | 21 | 56 | 117
Native Hawaiian or Pacific Islander | 1 | 4 | 15 | 4 | 12 | 37
White | 9 | 96 | 401 | 246 | 845 | 1704
Hispanic | 3 | 22 | 104 | 65 | 120 | 328
Overall Total | 24 | 139 | 575 | 341 | 1218 | 2468
III. Denial Rates (II/I) * 100
 | 0-30% MFI | 31-50% MFI | 51-80% MFI | 81-95% MFI | >95% MFI | Total
American Indian
Asian
Blacks
Native Hawaiian or Pacific Islander
White
Hispanic
Overall Total
Source: HMDA (LAR)
Note: Data reported here is for Multnomah County. These are loans for the purpose of purchasing a home. The loans are for homes that are meant for a primary occupancy of the owner. These are all represented for conventional loans. For ethnic and racial breakout, these are loans originated by households where either the applicant or co-applicant are representative of that group.
Spreadsheet: hunter_shively__12716__Enron Quotes 12-21-01 Morning
Sheet: Sheet1

 |  |  |  |  |  |  | CENTRAL BASIS QUOTES
 |  |  | Jan-Mar | Apr-Oct2 | Nov-Mar3 | Apr-Oct3 | Nov03 | [NAME] | Nov05 | Nov06 | Nov07 | Nov08
 | [NAME] | ML7
 | [NAME] | Consumers
 | [NAME] | Dawn
 | [NAME] | Parkway
 | [NAME] | [NAME]
 | NGI | Chicago | .0825 @ .0875 | .0175 @ .025 | .1225 @ .1275 | .035 @ .04 | .07 @ .075 | .07 @ .075 | .07 @ .075 | .07 @ .075 | .07 @ .075 | .07 @ .075
 | GDM | Mich | .0825 @ .0875 | .08 @ .085 | .135 @ .1425 | .1225 @ .13 | .125 @ .1375 | .125 @ .1375 | .12 @ .135 | .115 @ .13 | .115 @ .14 | .1175  @ .145
 | IF | Panhandle | -.1125 @- .1075 | [NAME] | [NAME] | -.125 @ -.1175 | -.13 @ -.12 | -.13 @ -.12
 | IF | Midcontinent | -.1425 @ -.13 | -.1575 @ -.15 | -.15 @ -.14 | -.145  @ -.1325 | -.15 @ -.14 | -.15 @ -.14 | -.15 @ -.14 | -.15 @ -.14 | -.15 @ -.14 | -.15 @ -.14
 | IF | ANR SW | -.1125 @- .1075 | [NAME] | [NAME]
 | IF | [NAME] | -.005  @ .005 | -.0975 @ -.09 | -.000 @ .005 | -.09 @ -.08
 | IF | Vent | .005  @ .015 | -.0975 @ -.09 | .005  @ .015
 | IF | ANR LA | -.085 @ -.0775 | -.0825 @ -.075 | -.08 @ -.075 | -.085 @ -.075
 | IF | NGPL/LA | -.085 @ -.0775 | -.0675 @ -.06 | [NAME]
 | IF | TRKL/LA | -.09 @ -.0825 | -.09 @ -.0825 | -.095 @ -.085 | -.09 @ -.08 | -.095 @ -.085 | -.095 @ -.085
Spreadsheet: 176110d1345733914-simplified-way-of-displaying-data-for-training-and-information-house-clearance-log
Sheet: Raw Data

Customer Name | Customer Address | Date Enquiry Taken | Heard of us how? | Call Centre Member | Viewing Booked? Y/N | Viewing Date & Time | Viewer | Price Quoted | Clearance Booked? Y/N | Clearance Date | Clearance Time | [NAME]? Y/N | Amount Received |  |  |  |  |  |  |  |  |  |  |  | Viewing Booked | Viewers | Clearance Booked | Callcentre | Clearance Completed
Mr. [NAME] | 23 Acacia Avenue, Pontypandy, CF45 4GG | 2011-05-15 00:00:00 |  | Anne | yes | 2011-05-20 00:00:00 | Siôn | 300 | Yes | 2011-05-25 00:00:00 | 10am | Yes | 300 |  |  |  |  |  |  |  |  |  |  |  | Yes | Siôn | Yes | Anne | Yes
Mr. [NAME] | 24 Acacia Avenue, Pontypandy, CF45 4GG |  |  | Anne | yes | 2011-05-21 00:00:00 | Siôn | 200 | Yes | 2012-07-10 00:00:00 | 10am | Yes | 200 |  |  |  |  |  |  |  |  |  |  |  | No | Shaun | No | [NAME] | No
Ms. [NAME] | 25 Acacia Avenue, Pontypandy, CF45 4GG |  |  | [NAME] | yes | 2011-05-22 00:00:00 | Siôn | 250 | Yes | 2012-07-10 00:00:00 | 2pm | Yes | 250 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | Leanne
 | 26 Acacia Avenue, Pontypandy, CF45 4GG |  |  | [NAME] | yes | 2011-05-23 00:00:00 | Siôn | 200 | Yes | 2012-07-12 00:00:00 | 10am | Yes | 200 |  | Total Prices Quoted |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | 27 Acacia Avenue, Pontypandy, CF45 4GG |  |  | Leanne | yes | 2011-05-24 00:00:00 | Siôn | 300 | Yes | 2012-07-17 00:00:00 | 10am | Yes | 300 |  | Total Amounts Received |  |  |  |  |  |  |  |  |  |  |  |  | Sue
 | 28 Acacia Avenue, Pontypandy, CF45 4GG |  |  | Sue | yes | 2011-05-25 00:00:00 | Siôn | 250 | Yes | 2012-07-26 00:00:00 | 10am | No | 0
Spreadsheet: 682660d1592238838-nested-if-statement-not-multiplying-formula-by-the-designated-cell-error-issue
Sheet: Sheet1 (3)

Commission Tier | [NAME] | [NAME] | Commission [NAME] | Commission Min | Commission Max
Tier 1 | 0 | 9999.99 | 0.15 | 0
[NAME] | 10000 | 29999.99 | 0.16
Tier 3 | 30000 | 49999.99 | 0.17
[NAME] | 50000 | 70000 | 0.18
Rate Calculator | Value
Revenue Generated | 60000 | <--- This cell can be edited to produce the comission calculation below
Comission Due |  | <--- This is the cell where the issue with the IF Statements is happening
Spreadsheet: 741880d1627395110-resetting-a-value-in-a-field-and-hiding-fields-via-check-mark-travel-forms-request-or-voucher-test
Sheet: TRAVEL REQUEST

 |  | TRAVEL REQUEST WORKSHEET |  |  |  |  |  |  |  |  | TRAVEL ORDER NUMBER
 |  | TRAVELER NAME |  | SUMMER, CHRISTY
 |  | EMPLOYEE ID
 |  | SPECIAL REQUESTS
 |  | CONFIRMATORY |  |  |  |  |  |  |  |  |  |  |  |  | False
 |  | VARIATION AUTHORIZED |  |  |  |  |  |  |  |  |  |  |  |  | False
 |  | TRAVEL ADVANCE |  |  |  |  |  |  |  |  |  |  |  |  | False
 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | True
 |  | DEPART FROM |  |  |  |  |  | DEPART DATE
 |  | ARRIVING AT |  |  |  |  |  | RETURN DATE
 |  | Select Drop Down for ILPP Locations
 |  | PURPOSE OF TRAVEL |  |  |  |  |  |  |  |  |  |  |  |  | CHECK IF A SECONDARY MAIN MODE OF TRANSPORT WILL BE USED
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SELECT THE SECONDARY MODE OF TRANSPORT (if used)
 |  | TRANSPORTATION MODE
 |  | SELECT THE MAIN MODE OF TRANSPORT
 |  | POV |  |  |  |  | SELECT ONE
 |  | TYPE / TDY CATEGORY
 |  | SELECT ONE
 |  | REIMBURSEMENT TYPE
 |  | Actual Expense for Lodging
 |  | COSTS
 |  |  |  | ESTIMATED FLIGHT
 |  |  |  | ESTIMATED RENTAL CAR |  |  |  | $ per mile |  |  | Total POV Mileage
 |  |  |  | ESTIMATED POV MILEAGE |  |  |  | 0.56
 |  |  |  | ESTIMATED POV VICINITY MILEAGE |  |  |  | 0.32
 |  |  |  | OTHER:
 |  |  |  | CEFMS TOTAL ESTIMATE
 |  | FUNDING
 |  |  |  | DIRECT - PROJECT FUNDS
 |  |  |  | OVERHEAD - TRAINING
 |  |  |  | OTHER
 |  | REMARKS
 |  |  | LOG IN TRAVEL & TRAINING :
 |  |  | ORDERING WORK ITEM:
 |  |  | FUNDING WORK ITEM:
 |  |  | WORK CATEGORY :
 |  |  | TOTAL COST