tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 124762d1318598805-list-dependant-on-cell-value-thats-being-vlookupped-from-another-sheet-ccernat_sample-1-
Sheet: ROUTINGS

ITEM | Description | SETUP TIME | RUN TIME ( PCES/FG*TIME PER PIECE
BA313098 G | DEBIT | 0.07433000000000001 | 0.125
BA313098 G | INDOIRE | 0.03334 | 0.05558
BA313098 G | LASER | 0.18325 | 0.09915000000000002
BA313098 G | SUDURA | 0.5 | 0.24534
Spreadsheet: 08688de9-7591-437f-b361-5cf25a09ce50
Sheet: Sources

SOURCES OF FUNDING
Project Name: |  |  |  | Date: | 2012-01-01 00:00:00
If mixed use project, see comment | RESIDENTIAL |  |  |  |  | COMMERCIAL
Funding Source | HOME Match (check) | Committed | Conditional | Tentative | Anticipated or Firm Commitment Date | Commercial | Anticipated or Firm Commitment Date
OHCS GRANTS & EQUITY
LIHTC Equity
Trust Fund
Preservation
LI Weatherization Program
HELP
OTHER ____________________
Total OHCS Grants & Equity
OHCS LOANS
Tax Exempt Bonds
Trust Fund
Preservation
ORR
HELP
OTHER ____________________
Total OHCS Loans
PHB SOURCES
Tax Increment Financing
HOME
[NAME]
Tax Exemptions
OTHER ____________________
Total PHB
OTHER LOANS
Permanent Loan (bank name)
Total OTHER Loans
OTHER GRANTS
Total OTHER Grants
APPLICANT  CONTRIBUTIONS
Cash
Deferred Development Fee
Total Applicant Contribution
OTHER:
Cashflow During Rehab
Total Other Funds
SUBTOTALS
TOTAL FUND SOURCES
Surplus or Gap |  |  | (Note: Total Fund Sources must match "Total Project Cost" from Uses of Funding page.)
Other OHCS non-equity sources:
Oregon Affordable Housing Tax Credit (OAHTC) |  |  |  |  | (loan amount)
GHAP construction bridge loan |  |  |  |  | (loan amount)
GHAP capitol needs assessment short term loan |  |  |  |  | (loan amount)
GHAP operating subsidy
Predevelopment Loan |  |  |  |  | (loan amount)
Spreadsheet: sally_beck__33931__GlobalMgmtSum-Q101-0201
Sheet: Expenses

PLAN2000
TOT_OPS_EXPENSES | ENRON GLOBAL MARKETS |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DEALS IDENTIFIED
2000-12-01 00:00:00 | 1st QUARTER 2001 EXPENSES
M.QTD
ENA |  |  | Direct Expenses
 | Business Team |  | Forecast | Plan | [NAME] |  | [NAME]
 | Crude & Products |  |  | 6767.77
COAL | Coal |  |  | 4013.093
SO2 | Emissions
WEATHER | Weather |  |  | 1808.523
INSURANCE | Global Risk Markets |  |  | 1802.648
ECT_INV_IRFX | Financial Trading |  |  | 3467.386
 | Freight |  |  | 461.707
 | LNG |  |  | 1430.25
 | Middle East |  |  | 809.5
 | Puerto Rico
 | Finance and Structuring |  |  | 712.17
 | Office of the Chairman |  |  | 533.369 |  |  | Wharton School Donation
 | Subtotal Commercial
 | Group |  |  | 27654
 | Other Interest Related Charges |  | 0 | 0
 | Total
 |  |  | Operating Expenses
 | Business Team |  | Forecast | Plan | [NAME] |  | [NAME]
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
Spreadsheet: 69478d1270023075-list-all-duplicate-triplicate-etc-values-from-set-of-cells-723711_neil4speed
Sheet: Sheet1

 |  |  |  |  | 3 | 1 |  | 8
 |  |  |  |  | Two or More | Three or More |  | Co-ord | Unique Locations | Count
Calgary |  | Edmonton |  | Toronto | Calgary | Edmonton |  | 1.1 | Calgary | 2
Edmonton |  | Calgary |  | Edmonton | Edmonton |  |  | 1.3 | Edmonton | 3
Vancouver |  | Quebec City |  | Quebec City | Quebec City |  |  | 1.5 | Toronto | 1
Winnipeg |  | Montreal |  | Saskatoon |  |  |  | 3.1 | Vancouver | 1
 |  |  |  |  |  |  |  | 3.3 | Quebec City | 2
 |  |  |  |  |  |  |  | 4.1 | Winnipeg | 1
 |  |  |  |  |  |  |  | 4.3 | Montreal | 1
 |  |  |  |  |  |  |  | 4.5 | Saskatoon | 1
Spreadsheet: 164140d1340656182-need-formula-that-will-return-a-sum-of-values-in-a-table-that-match-two-criteria-book3
Sheet: Summary

 |  | PROJECT CODE
 |  | 100 | 200 | 300 | 400 | 500 | 600 | Total
COST CENTER | AA0000 |  |  |  |  |  |  | 0
 | AB0000 |  |  |  |  |  |  | 0
 | AA1000 |  |  |  |  |  |  | 0
 | AB1010 |  |  |  |  |  |  | 0
 | AA1020 |  |  |  |  |  |  | 0
 | AB1020 |  |  |  |  |  |  | 0
Spreadsheet: abf20632-02d3-4968-9b16-bac85ba27ae7
Sheet: Sheet1

Income Statement - Fiscal Year, Consolidated (IFRS) | 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
Millions | 4Q08 | 1Q09 | 2Q09 | 3Q09 | 4Q09 | 1Q10 | 2Q10 | 3Q10 | 4Q10 | 1Q11 | 2Q11 | 3Q11 | 4Q11 | 1Q12 | 2Q12 | 3Q12 | 4Q12 | 1Q13
Gross Sales Revenues | 3576.201 | 833.652 | 1867.918 | 2922.808 | 4242.057 | 0 | 2298.009 | 3579.222 | 5136.712 | 0 | 2539.463 | 3920.896 | 5591.374 | 0 | 2884.117 | 4470.651 | 6345.669 | 0
Deductions from Gross Revenue | -1113.237 | -261.577 | -563.366 | -877.563 | -1294.565 | 0 | -711.795 | -1076.198 | -1556.806 | 0 | -756.266 | -1169.931 | -1666.3 | 0 | -836.643 | -1291.652 | -1868.045 | 0
Gross Result | 2462.964 | 572.075 | 1304.552 | 2045.245 | 2947.492 | 0 | 1586.214 | 2503.024 | 3579.906 | 0 | 1783.197 | 2750.965 | 3925.074 | 0 | 2047.474 | 3178.999 | 4477.624 | 0
Cost of Goods Sold and/or Services Rendered | -1692.829 | -400.558 | -925.102 | -1430.849 | -2031.464 | 0 | -1059.913 | -1669.467 | -2412 | 0 | -1242.718 | -1905.344 | -2610.004 | 0 | -1451.845 | -2233.759 | -3108.074 | 0
Selling Expenses | -1259.333 | -296.22 | -661.332 | -679.328 | -1496.125 | 0 | -762.598 | -1203.562 | -1704.322 | 0 | -909.293 | -1409.63 | -1952.74 | 0 | -1038.852 | -1574.114 | -2212.205 | 0
General and Administrative Expenses | -461.85 | -111.077 | -251.544 | -726.117 | -520.715 | 0 | -284.161 | -451.797 | -690.21 | 0 | -350.217 | -516.724 | -720.341 | 0 | -411.358 | -648.512 | -884.226 | 0
Other Operating Revenue | 28.354 | 0 | 0.581 | 5.419 | 0 | 0 | 0 | 0 | 0 | 0 | 16.792 | 21.01 | 63.077 | 0 | 0 | 0 | 0 | 0
Other Operating Expenses | 0 | -0.116 | 0 | 0 | -14.624 | 0 | -13.154 | -14.108 | -17.468 | 0 | 0 | 0 | 0 | 0 | -1.635 | -11.133 | -11.643 | 0
Equity Income | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Income before Taxes/Participations | 517.857 | 138.747 | 306.971 | 497.056 | 683.924 | 0 | 333.052 | 524.749 | 744.05 | 0 | 338.611 | 540.194 | 830.901 | 0 | 366.564 | 603.887 | 861.222 | 0
Spreadsheet: 98119d1297172629-group-by-date-and-count-groupby
Sheet: data

Report | First submission | Second Submission | Third Submission | Fourth Submission
Report1 | 2011-01-01 00:00:00 | 2011-01-08 00:00:00
Report2 | 2011-01-01 00:00:00 | 2011-01-02 00:00:00 | 2011-02-07 00:00:00
Report3 | 2011-01-02 00:00:00
Report4 | 2011-01-05 00:00:00
Report5 | 2011-01-08 00:00:00
Report6 | 2011-01-08 00:00:00
Report7 | 2011-02-07 00:00:00
Report8 | 2011-02-07 00:00:00
Spreadsheet: 44802d1243541639-lookup-worksheets-and-do-sumifs-criteria-lookupsumifa-1
Sheet: 66105

braches rent account
NL Code | Month | J R | Date | Ref 1 | Ref 2 | Amount
266105 | 1 | 196 | 2009-05-29 00:00:00 | CB |  | 500
566105 | 1 | 197 | 2009-05-29 00:00:00 | CB |  | 700
466105 | 1 | 198 | 2009-05-29 00:00:00 | CB |  | 500
 |  |  |  |  |  | 1700
Spreadsheet: 763345d1642111382-help-nesting-sumif-and-left-or-sumproduct-left-and-and-example
Sheet: Example

Column A | Column B | Column C | Column D
DATE | Amount |  | Description
2022-01-03 00:00:00 | -35.78 | * | PURCHASE Amazon Online DSW
2022-01-09 00:00:00 | -89.7 | * | PURCHASE Safeway #3120 Scottsdale, AZ
2022-01-10 00:00:00 | 200 | * | PURCHASE Refund credit card ending in 2233
2022-01-10 00:00:00 | -75 | * | [NAME] Buffalo Wild Wings Restaurant
2022-01-11 00:00:00 | -10 | * | PURCHASE Shell Oil #6140 Reno, NV
=SUMIFS( B2:B7, B2:B7, "<0", (LEFT(D2:D7,8)),="PURCHASE")
Spreadsheet: 739380d1625667218-find-cell-value-but-cell-name-or-vlookup-with-cell-name-price-matrix-example
Sheet: Sheet1

THICKNESS | AA/CC | AA/EE
 |  |  |  |  | _4000123456 | 18.93
 |  |  |  |  | _4000123457
[NAME] | M2 | M2 |  |  | _4000123458
15 | 18.93 |  |  |  | _4000123459
17 | 20.07 |  |  |  | _4000123460
20 | 21.2 |  |  |  | _400023451
25 | 23.52 |  |  |  | _400023456
30 | 26.13 |  |  |  | _400023461
35 | 28.99 |  |  |  | _4000123480
38 | 30.29
40 | 31.6
45 | 34.13
50 | 36.68
55 | 39.43
60 | 42.39
Hello! Again I need help of guru and I hope there is a simple solution that I never thought about...
I have a Matrix of prices, see sample file attached. Each Price has cell name of underscore and article number (eg. _4000123456)
I need to extract the prices into listed format like in column F, but what formula can I use to link them to matrix (B:C) and get result in G?
Spreadsheet: eric_saibi__9812__9-23-01
Sheet: Deals

Deal_id | Flow Date | CP | Volume | Price | Start Hr | End Hr | Trans
 |  | Mirant Call | -50 |  | 8 | 24
758660.15 | 2001-09-23 00:00:00 | Enron Call | -100 |  | 7 | 22
784271.1 | 2001-09-23 00:00:00 | Enron Call | 100 |  | 7 | 22
784837.1 | 2001-09-23 00:00:00 | FPL | 50 | 18.75 | 8 | 24
784865.1 | 2001-09-23 00:00:00 | [NAME] | -50 | 18.75 | 8 | 24
Spreadsheet: 82856d1282847537-max-min-function-for-alpha-vendor-summary
Sheet: Sheet1

Roster |  | Desired Output |  |  | Excel Forum Formula
[NAME] |  | Braylon Edwards
[NAME] |  | [NAME]
 |  | [NAME]
 |  | Derrel Revi$
 |  | [NAME]
Derrel Revi$ |  | [NAME]
[NAME] |  | [NAME]
[NAME] |  | [NAME]
Braylon Edwards
[NAME]
[NAME]
Braylon Edwards
[NAME]
[NAME]
[NAME]
Derrel Revi$
[NAME]
[NAME]
Braylon Edwards
[NAME]
[NAME]
Braylon Edwards
[NAME]
[NAME]
[NAME]
[NAME]
Braylon Edwards
[NAME]
[NAME]
[NAME]
Braylon Edwards
[NAME]
[NAME]
[NAME]
Derrel Revi$
[NAME]
[NAME]
[NAME]
Braylon Edwards
[NAME]
[NAME]
[NAME]
Braylon Edwards
Spreadsheet: 137347d1327071106-mode-array-vsum
Sheet: Sheet2

 | Spend | Spend | Spend | Orders | Orders | Orders
Budget line | MER200 | MER350 | HEY554 | MER200 | MER350 | HEY554 | Average order Value | Max PO Value | Min PO Value | Mode |  |  | SUMIF…………..
1005 | 286499 | 0 | 0 | 999 | 0 | 0 | 286.7857857857858 | 242525 | 19246 |  |  |  | 1005 | 286499
1006 | 103302 | 0 | 0 | 16362 | 0 | 0 | 6.313531353135313 | 34434 | 34434 |  |  |  | 1006 | 103302
1010 | 0 | 17001 | 0 | 0 | 1968 | 0 | 8.638719512195122 | 5667 | 5667 |  |  |  | 1010 | 17001
1018 | 0 | 0 | 2330634 | 0 | 0 | 2301 | 1012.878748370274 | 776878 | 776878 |  |  |  | 1018 | 2330634
1022 | 261 | 0 | 0 | 231 | 0 | 0 | 1.12987012987013 | 87 | 87 |  |  |  | 1022 | 261
1028 | 0 | 27 | 0 | 0 | 18 | 0 | 1.5 | 9 | 9 |  |  |  | 1028 | 27
1034 | 0 | 0 | 2694 | 0 | 0 | 228 | 11.81578947368421 | 898 | 898 |  |  |  | 1034 | 2694
1042 | 269391 | 0 | 0 | 2028 | 0 | 0 | 132.8357988165681 | 89797 | 89797 |  |  |  | 1042 | 269391
Spreadsheet: 137265d1327019627-selecting-from-filter-list-to-generate-a-total-supply-list
Sheet: Sheet1

The Amazing Supply List of Amazingness
Item | Brand | Supplier | Category | For | Quantity | Price without VAT | Price with VAT | Subtotal |  | Grand Total: | 323.4
PP Wardrobe Large | Muji | Muji | Storage | Nikki | 12 |  | 25.95 | 311.4
Scissors | Fiskars | Morplan | Organisation | Chrissie | 1 | 10 |  | 12 |  | Total for:
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
Spreadsheet: 121271d1315961835-timesheet-sampletimesheet
Sheet: Sheet1

Name: | Employee Name |  |  |  |  | Employee: | 1789 |  | Helper Tables
Week Ending: | 2011-09-04 00:00:00 |  |  |  |  |  |  |  |  |  |  | Basic Splits |  |  |  |  |  |  |  |  | [NAME]
Premium Shifts |  | HELPER | CEDO | LEVEL 1 | Basic Hours | OT |  |  | PS | Holiday |  | HELPER | OT | DT | CEDO | OT | DT | LEVEL 1 | OT | DT | HELPER | CEDO | LEVEL 1 | Totals | Expenses
Mon | 2011-08-29 00:00:00 | 0 | 9.250000000000002 | 0 | 8 | 1.250000000000002 | 290.1521875000001 |  | Mon |  |  | 0 | 0 | 0 | 8 | 1.250000000000002 | 0 | 0 | 0 | 0 | 0 | 252.3062500000001 | 0 | 252.3062500000001 | 0
Tue | 2011-08-30 00:00:00 | 0 | 0 | 7.5 | 7.5 |  | 260.6475 |  | Tue |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 7.5 | 0 | 0 | 0 | 0 | 226.65 | 226.65 | 0
Wed | 2011-08-31 00:00:00 | 0 | 7 | 2.499999999999999 | 8 | 1.5 | 292.5599999999999 |  | Wed |  |  | 0 | 0 | 0 | 7 | 0 | 0 | 2.499999999999999 | 0 | 0 | 0 | 178.85 | 75.54999999999997 | 254.4 | 0
Thu | 2011-09-01 00:00:00 | 0 | 2.75 | 7.25 | 8 | 2 | 289.3575 |  |  |  |  | 0 | 0 | 0 | 2.75 | 0 | 0 | 7.25 | 0 | 0 | 0 | 70.2625 | 219.095 | 289.3575 | 0
Fri | 2011-09-02 00:00:00 | 0 | 6.5 | 5.5 | 8 | 4 | 684.5699999999999 |  |  | 1 |  | 0 | 0 | 0 | 6.5 | 0 | 0 | 5.5 | 0 | 0 | 0 | 166.075 | 166.21 | 332.285 | 20
Sat | 2011-09-03 00:00:00 | 0 | 0 | 0 | 0 |  | 0 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Sun | 2011-09-04 00:00:00 | 0 | 0 | 0 | 0 |  | 0 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Totals | 25.5 | 0 | 22.75 | 39.5 | 8.750000000000002 | 1817.2871875
Date | Start | Finish | Hours | Workorder | Customer | Location | Rate
2011-08-29 00:00:00 | 20:30:00 | 05:45:00 | 9.250000000000002 | 11-07-78 | Customer1 | 100 Yonge St | CEDO
2011-08-30 00:00:00 | 21:45:00 | 05:15:00 | 7.5 | 11-07-78 | Customer1 | 100 Yonge St | Level 1
2011-08-31 00:00:00 | 21:00:00 | 23:30:00 | 2.499999999999999 | 11-07-13 | Customer2 | 101 Yonge St | Level 1
2011-08-31 00:00:00 | 23:30:00 | 06:30:00 | 7 | 11-08-78 | Customer1 | 100 Yonge St | CEDO
2011-09-01 00:00:00 | 21:00:00 | 1900-01-01 00:00:00 | 3 | 11-01-01 | Customer3 | 102 Yonge St | Level 1
2011-09-01 00:00:00 | 1900-01-01 00:00:00 | 04:15:00 | 4.25 | 11-02-04 | Customer4 | 104 Yonge St | Level 1
2011-09-01 00:00:00 | 04:15:00 | 07:00:00 | 2.75 | 11-01-09 | Customer6 | 106 Yonge St | CEDO
2011-09-02 00:00:00 | 21:00:00 | 02:30:00 | 5.5 | 01-02-98 | Customer4 | 103 Yonge St | Level 1
2011-09-02 00:00:00 | 02:30:00 | 09:00:00 | 6.5 | 11-06-13 | Customer5 | 105 Yonge St | CEDO
2011-09-03 00:00:00
2011-09-04 00:00:00
Spreadsheet: 1975f4b6-5f44-401c-ac98-74fa0969f025
Sheet: Sheet1

Permit No.: | Unnamed: 1 | WQ0029434 | Unnamed: 3 | Facility Name: | Unnamed: 5 | Alligator Bay WWTF | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | County: | Onslow | Unnamed: 13 | Month: | Unnamed: 15 | Unnamed: 16 | Year: | Unnamed: 18
PPI: |  | 001 | Flow Measuring Point: |  |  |  |  |  |  | Parameter Monitoring Point:
Parameter Code |  |  | 50050 | 00310 | 00680 | 00940 | 50060 | 31616 | 00610 | 00620 | 00600 | 00400 | 00665 | 00545 | 70295 | 00530 | 00076
Day | ORC Arrival Time | ORC Time On Site | Flow | BOD5 | Total Organic Carbon | Chloride | Total Residual Chlorine | Fecal Coliform | Ammonia | Nitrate | Total Nitrogen | pH | Total Phosphorus | Settleable Solids | Total Dissolved Solids | Total Suspended Solids | Turbidity
 | 24-hr | hrs | GPD | mg/L | mg/L | mg/L | mg/L | #/100 mL | mg/L | mg/L | mg/L | su | mg/L | mL/L | mg/L | mg/L | NTU
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Average:
Daily Maximum:
Daily Minimum:
Sampling Type: |  |  | Recorder | Composite | Grab | Grab | Grab | Grab | Composite | Grab | Composite | Grab | Composite | Grab | Grab | Composite | Recorder
Monthly Limit: |  |  | 117090 | 10 |  |  |  | 14 | 4 |  | 10 |  | 5 |  |  | 5
Daily Limit: |  |  |  | 15 |  |  |  | 25 | 6 |  |  | 6-9 |  |  |  | 10 | 10
Sample Frequency: |  |  | [NAME] | See Permit | 3 x Year | 3 x Year | 5 x Week | See Permit | See Permit | 3 x Year | See Permit | 3 x Year | See Permit | 5 x Week | 3 x Year | See Permit | [NAME]
 |  | Average
 |  | Geomean
 |  | MAX/MIN
Spreadsheet: lisa_gang__22324__ENA_PGE_JUNE_20_2002
Sheet: JD-MAL OR CPTJK TRANS

From: | EPMI
To: | PGE System Transactions
Date: | 2002-06-20 00:00:00
Total Transmission
HE
ENDING | PGE TRANNY | PGE TRANNY | PGE TRANNY | PGE TRANNY | PGE TRANNY | TOTAL
Pacific Prevailing
Time | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | [NAME] USED
(PPT) |  |  |  |  |  | Total In To PGE Trans
0100 | 0 | 0 | 0 | 0 | 0
0200 | 0 | 0 | 0 | 0 | 0
0300 | 0 | 0 | 0 | 0 | 0
0400 | 0 | 0 | 0 | 0 | 0
0500 | 0 | 0 | 0 | 0 | 0
0600 | 0 | 0 | 0 | 0 | 0
0700 | 50 | 50 | 25 | 25 | 25
0800 | 50 | 50 | 25 | 25 | 25
0900 | 50 | 50 | 25 | 25 | 25
1000 | 50 | 50 | 25 | 25 | 25
1100 | 50 | 50 | 25 | 25 | 25
1200 | 50 | 50 | 25 | 25 | 25
1300 | 50 | 50 | 25 | 25 | 25
1400 | 50 | 50 | 25 | 25 | 25
1500 | 50 | 50 | 25 | 25 | 25
1600 | 50 | 50 | 25 | 25 | 25
1700 | 50 | 50 | 25 | 25 | 25
1800 | 50 | 50 | 25 | 25 | 25
1900 | 50 | 50 | 25 | 25 | 25
2000 | 50 | 50 | 25 | 25 | 25
2100 | 50 | 50 | 25 | 25 | 25
2200 | 50 | 50 | 25 | 25 | 25
2300 | 0 | 0 | 0 | 0 | 0
2400 | 0 | 0 | 0 | 0 | 0
 | BPA(G)24966 | BPA(G)24966 | BPA(G)24661 | BPA(G)24718 | BPA(G)SLICE12041
 | BPA(T)SYS/JD | BPA(T)SYS/JD | BPA(T)SYS/JD | BPA(T)SYS/JD | EWEB
 | AEP | AEP | AEP | AEP | BCPD
 | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | BPA(T)SYS/JD
 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5 | EWEB
 | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | AEP
 | AEP | AEP | AEP | AEP | EPMI(PSE)
 | MID | SNCL | MIRANT | SDGE | PGE(T)JD/MAL5
 | MID(T)CPJK/TRACEY/WESLEY | ISO(T)CPJK/NP15 | ISO(T)MALIN/NP15 | ISO(T)MALIN/SP15 | EPMI(PSE)
 | MID(L)WESLEY | SNCL(L)NP15 | MIRANT(L)NP15 | SDGE(L)SP15 | AEP
 |  |  |  |  | MIRANT
 |  |  |  |  | ISO(T)MALIN/NP15
 |  |  |  |  | MIRANT(L)NP15
Spreadsheet: 123906d1317922645-formatting-overdue-date-conditionalcolumns
Sheet: Sheet1

 |  |  | Due | Delivery
Spreadsheet: 478192d1472669440-vlookup-of-adjacent-cells-vlookup-adjacent-help
Sheet: Sheet1

sink | "w" | "h" |  |  |  | vlookup for column A | display corresponding "w" | display corresponding "h"
111 | 22 | 44
222 | 23 | 45
333 | 24 | 46
444 | 25 | 47
555 | 26 | 48
666 | 27 | 49
Spreadsheet: 167100d1341901330-filtering-one-specific-name-in-excel-2010-copy-of-morning-attendance-2-
Sheet: 03 May 2012

Daily Morning Staff |  |  |  |  | Thursday
 | 07:30-14:30 |  | 2012-05-03 00:00:00
Name | Staff No. | Title | Time In | Out | Locations | Remarks
Naima Mohamed | 2166 | Client Relation Supervisor | 07:30:00 | 14:30:00 | TOPS
Sheikha [NAME] | 2120 | Reservation Officer | 07:30:00 | 14:30:00 | TOPS
Syed Sultan | 2888 | Supervisor | 07:30:00 | 14:30:00 | EFS
[NAME] | 4143 | Aircraft Team Leader | 07:30:00 | 14:30:00 | EFS
Jalil Nushadi | 1889 | Driver | 05:30:00 | 14:30:00 | EFS | coordination  for vehicle with empty service
[NAME] | 624 | Driver | 07:30:00 | 14:30:00 | EFS
Soud Sharar | 2097 | [NAME] Officer | 07:30:00 | 14:30:00 | [NAME]
[NAME] | 1897 | Manager | 07:30:00 | 14:30:00 | EFS
[NAME] | 4440 | Attendant | 07:30:00 | 14:30:00 | EFS
[NAME] | 1861 | Duty Officer | 07:30:00 | 14:30:00 | EFS
Spreadsheet: 142458d1329846348-create-a-dynamic-drop-down-list-based-on-specific-criteria-employee-list-example
Sheet: Sheet2

employee | status | filtered | no blanks | staus data validation
Armstrong, Niel | inactive |  |  | active
[NAME], [NAME] | active | [NAME], [NAME] | [NAME], [NAME] | inactive |  | employee
[NAME] | active | [NAME] | [NAME]
[NAME], [NAME] | inactive
Lincoln, [NAME] | active | Lincoln, [NAME] | Lincoln, [NAME]
Gates, [NAME] | active | Gates, [NAME] | Gates, [NAME]
Santana, [NAME] | active | Santana, [NAME] | Santana, [NAME]
Spreadsheet: 800487d1665682787-formula-for-multiple-discounts-to-meet-targets-margin-calculator
Sheet: Sheet1

 | Margin Finder
 | BWX Calculated Multiplier |  | Calculated        Margin %
Start | 0.7188 |  | 0.313375 |  |  |  |  | Yellow = Numbers that would be input manually that change with every project.
Target | 0.6371 |  | 0.226665
Floor | 0.6178 |  | 0.202806 |  |  |  |  | Blue= Number that would be manually input to calculate the [NAME] cell next to it.
Margin |  |  |  |  |  |  |  | Green = Number that would be calculated based on the data from the yellow and blue.
Multipler
Based on the numbers in yellow, you could put a number in the blue and it would populate the correct number in green.
So if cells B3,B4,B5 = D3,D4,D5 then [NAME] would calculate D3 and D9 would calculate B9.
If I were to put 25% in D9, I would like the required multiper needed to populate in B9.
Spreadsheet: 874553d1721139693-sequence-values-within-an-array-sample
Sheet: Sheet1

 | INPUT VALUES |  |  | RANGE OF POINTS TO TRANSFORM
 |  |  |  | START POINT | END POINT
PT # | Y Coordinates | X Coordinates |  | (or single pt) | (or empty) | Empty? |  | Range1 | Range2 | Range3 | Range4 | Range5
1 | 581735.12 | 1766282.86 |  | 1 | 6
2 | 581765.246 | 1768562.0903 |  | 11 |  |  |  | 2 |  | 102
4 | 581769.7225 | 1768902.7909 |  | 101 | 114 |  |  | 3 |  | 103
5 | 579130.8787 | 1768926.5763 |  |  |  |  |  | 4 |  | 104
6 | 579119.3138 | 1768358.6941 |  |  |  |  |  | 5 |  | 105
7 | 579078.1099 | 1766335.4236 |  |  |  |  |  | 6 |  | 106
8 | 576384.616 | 1764771.9017 |  |  |  |  |  |  |  | 107
11 | 576413.1213 | 1766388.145 |  |  |  |  |  |  |  | 108
14 | 576418.153 | 1767380.3851 |  |  |  |  |  |  |  | 109
15 | 576423.9439 | 1768514.1474 |  |  |  |  |  |  |  | 110
16 | 576426.3695 | 1768990.6213 |  |  |  |  |  |  |  | 111
101 | 575195.0631 | 1768719.7843 |  |  |  |  |  |  |  | 112
114 | 573895.7258 | 1768205.0101 |  |  |  |  |  |  |  | 113
112 | 573875.907 | 1767397.2831 |  |  |  |  |  |  |  | 114
113 | 573811.1526 | 1764758.1774
 |  |  |  |  |  |  |  | SHOULD BE DISPLAYED LIKE BELOW:
 |  |  |  |  |  |  |  | 1 | 11 | 101
 |  |  |  |  |  |  |  | 2 |  | 114
 |  |  |  |  |  |  |  | 4 |  | 112
 |  |  |  |  |  |  |  | 5 |  | 113
 |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  | OR
 |  |  |  |  |  |  |  |  |  | 101
 |  |  |  |  |  |  |  |  |  | 112
 |  |  |  |  |  |  |  |  |  | 113
 |  |  |  |  |  |  |  |  |  | 114
 |  |  |  |  |  |  |  |  |  | (ORDER DOESN'T MATTER)
Spreadsheet: 266458d1379617782-formula-for-each-month-and-number-count-for-exceptions-setup-exception-tracking-by-ae-example
Sheet: Dirk

Date | Company | Broker | Processor | [NAME]. Last | Loan # (Last 5) | Exception reason | Exceptions | Submissions | Exception %
2013-03-31 00:00:00 |  |  |  |  |  |  | 0 | 40
2013-04-30 00:00:00 |  |  |  |  |  |  | 0 | 59
2013-05-31 00:00:00 |  |  |  |  |  |  | 0 | 37
2013-06-03 00:00:00 | Bez Financial Network | [NAME] | [NAME] | Sayed | 39341 | paystubs >30 & assets missing pages
2013-06-05 00:00:00 | CIG Corp | [NAME] | [NAME] | [NAME] | 39406 | missing prelim
2013-06-17 00:00:00 | Bez Financial Network | [NAME] | [NAME] | Liimatta | 39472 | missing prelim
2013-06-19 00:00:00 | Bez Financial Network | [NAME] | [NAME] | [NAME] | 39661 | did not separate multiple borrowers
2013-06-26 00:00:00 | Bez Financial Network | [NAME] | [NAME] | Ng | 39737 | prelim >45 | 5 | 24
2013-07-02 00:00:00 | R&R Mortgage | [NAME] | [NAME] | Dugger | 40002 | asset missing pgs
2013-07-08 00:00:00 | CIG Corp | [NAME] | [NAME] | [NAME] | 40104 | paystub >30 | 2 | 30
2013-08-31 00:00:00 |  |  |  |  |  |  | 0 | 19
2013-09-18 00:00:00 | W.J. Bradley Mortgage Capital, LLC | [NAME] | Joanne Armes | Basso | 41298 | credit >45