tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 270330d1381438235-formula-help-with-multiple-tabs-sampe-workbook-for-forum-1-
Sheet: Dept 2

 |  | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7
 | Revenue | 3917428.998911999 | 4196274.664681757 | 4505619.92025635 | 4809660.251795057 | 4996622.551626949 | 5096555.002659488 | 5212728.530391343
 | Expenses | 2546328.849292799 | 2727578.532043142 | 2928652.948166628 | 3126279.163666787 | 3247804.658557517 | 3312760.751728667 | 3388273.544754373
 | Net Income
Spreadsheet: 3055c95a-27f8-49dc-80a0-ce4ccde0b027
Sheet: Sheet1

Table 3--Soybean oil:  U.S. supply and disappearance | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 |  | Supply
Year begin. | Beginning | Production | Imports | Total |  | Domestic |  | Exports | Total | Ending
Oct. 1 | stocks |  |  |  |  | Total | Methyl ester |  |  | stocks
 |  |  |  | Million pounds
2009/10 | 2860.5 | 19615.31352 | 102.579 | 22578.39252 |  | 15813.94552 | 1676.402 | 3358.667 | 19172.61252 | 3405.78
2010/111 | 3405.78 | 18887.58252 | 159.001 | 22452.36352 |  | 16794.32052 | 2550 | 3232.696 | 20027.01652 | 2425.347
2011/122 | 2425.347 | 18780 | 185 | 21390.347 |  | 17900.347 | 4000 | 1200 | 19100.347 | 2290
1 Estimated.  2 Forecast.
Source: USDA, World Agricultural Outlook Board, World Agricultural Supply and Demand Estimates.
Last update: | 2012-04-12 13:57:01.810000
Spreadsheet: 837459d1690196494-can-you-do-a-sum-and-vlookup-or-index-match-across-multiple-rows-columns-example-46-2-
Sheet: P1

 | Act |  |  |  |  |  |  | Actual
Resources | 2023-01-07 00:00:00
Smith, Richie | 0.5 |  | 5 | 1.5
Tachett, [NAME] |  |  | 0.5 | 0.5
Wamby, Bradley |  |  | 3 | 12
Weekly Adjustments (+/-)
AEW
Spreadsheet: 216985d1361954992-trying-to-return-scores-based-on-three-different-data-points-using-ranges-scrubdata
Sheet: Score Grids

1 | 2 | 3 | 4 | 5 | 6 | 7
2 | >=3 | >=5000 | >=3000 | >=1500 | >=700 | <=699
3 | >=1 | 5
4 | >=.95 |  |  |  |  | 1
5 | >=.90 |  |  |  |  | 1
6 | >=.85 |  |  |  |  | 0
7 | <.85
8
9 | >=2 | >=5000 | >=3000 | >=1500 | >=700 | <=699
10 | >=1 | 4
11 | >=.95 |  |  |  |  | 1
12 | >=.90
13 | >=.85 |  |  |  |  | 0
14 | <.85
15
16 | >=2 | >=5000 | >=3000 | >=1500 | >=700 | <=699
17 | >=1 | 3
18 | >=.95 |  |  |  |  | 1
19 | >=.90
20 | >=.85 |  |  |  |  | 0
21 | <.85
Spreadsheet: mary_fischer__25641__111
Sheet: E1.XLS 

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 0111
COMPANY NAME  Pierce Mechanical
ANALYSIS OF A/R - OTHER
FOR THE 6 MONTHS ENDED 6-30-2001
PREPARED BY: Sonya City
EXTENSION:  3 9690 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-1
 |  | 12-31-2000 Balance
 |  | BEGINNING |  | OTHER |  | 03-31-2001 |  | OTHER |  | 06-30-2001 |  | OTHER |  | 09-30-2001 |  | OTHER |  | 12-31-2001
[NAME] |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE
 |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.)
(PROVIDE DETAIL OF INDIVDUAL ITEMS
IN EXCESS OF $200,000.)
Accts Receivables - Unconsolidated Assoc Companies:
Total (Hyperion line 0053)
Asset/Expense Accts:  DR/(CR)
Accts Receivables - Other:
[NAME] Activity |  | 80
Total (Hyperion line 0060)
Asset/Expense Accts:  DR/(CR)
Asset/Expense Accts:  DR/(CR)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-1
Spreadsheet: 87221d1287068342-table-array-or-matrices-lookuptableusingindirect
Sheet: Sheet1

300
 | Looking for Intersection of
 | Row = | 600 |  |  | Change the Yellow Cells to do a lookup in Table
 | Col = | 550
 |  |  |  |  | < Use the Row and Column to build the Address
 |  |  |  |  | < Use the Address to pull out the value
 |  |  |  |  | <<<Here is the single formula to get the above.
Spreadsheet: kay_mann__19227__Cost Alocation of Mitigation Plan Rev 2
Sheet: Sheet1

Attachment __
Fault Current Management Plan
Capital Cost Allocation
(Preliminary)
NYISO |  |  |  |  |  |  |  |  |  |  | Allocated |  | Cash Flows
Queue |  |  |  |  |  | Service |  |  | Allocation(2) |  | Cost Of
Number |  | Developer |  | Project |  | Year(1) | MW |  | Factor |  | Plan(3) |  | 2001 | 2002 | 2003 | 2004
 |  |  |  |  |  |  |  |  | (%) |  | ($Million) |  | ($Million) | ($Million) | ($Million) | ($Million)
 |  |  |  |  |  |  |  |  |  |  |  |  | 14 | 33 | 26 | 12
5 |  | Sithe Energies |  | Torne Valley |  | 2004 | 860
6 |  | Sunset Energy |  | Sunset Energy |  | 2003 | 520
7 |  | ANP |  | Ramapo Energy |  | 2004 | 1100
9/10 |  | Millennium |  | Millennium |  | 2004 | 480
11/12/13/14 |  | East Coast Power |  | East Coast Power |  | 2003(4) | 410
16 |  | ABB |  | Oak Point |  | 2004 | 1075
17 |  | KeySpan |  | Ravenswood |  | 2003 | 270
18 |  | NYPA |  | Poletti Expansion |  | 2004 | 500
19 |  | NYC Energy |  | SEFCO |  | 2002 | 79.9
24 |  | Orion |  | Astoria Repowering |  | 2004 | 499
25 |  | Con Edison |  | East River Repowering |  | 2003 | 288
29 |  | Mirant |  | [NAME]. 3 |  | 2004 | 750
31 |  | SCS |  | Astoria Energy |  | 2004 | 1000
 |  |  |  |  |  | Total | 7831.9
(1)  The developers' projects are assumed to be in service by the summer of the specified year.
(2)  The interim allocation is based on the project size (MW) divided by the sum of all the project sizes.
(3)   Based on an assumed total estimated cost of $85 million.
(4)  Year in which the first new generating unit is added.
2001-04-12 00:00:00
Spreadsheet: 300597d1393517688-client-code-for-differentiated-client-price-client-type-ndm
Sheet: Blad1

Retailer price | Installer price | Wholesaler price | [NAME] price | Rounded total
 |  |  |  |  |  |  |  | 1 | Retailer price
180000 | 126000 | 108000 | 93600 | ? |  |  |  | 2 | Installer price
 |  |  |  |  |  |  |  | 3 | Wholesaler price
Client type | 1 |  |  |  |  |  |  | 4 | [NAME] price
Spreadsheet: 695464d1600227531-index-with-match-test
Sheet: Sheet1

Name | 1 | 2 | 3 | 4 | 5 |  | Test1 | Test2 | Test3 | Test4 | Test5 | Test6 | [NAME] | Test8 | Test9
[NAME] |  |  |  |  |  |  | 85 | 72 | 25 | 42 | 0 | 92 | 13 | 55 | 56
bill |  |  |  |  |  |  | 44 | 56 | 78 | 36 | 52 | 97 | 64 | 84 | 80
[NAME] |  |  |  |  |  |  |  | 0 | 46 | 72 | 85 | 63 | 67 | 88 | 99
[NAME] | I need john's first 5 test scores from sheet 2 - excluding zeroes.
[NAME]
justin
Spreadsheet: 112576d1308674811-how-to-update-a-chart-automatically-if-news-lines-will-be-added-euro-weight
Sheet: Euro weight

Total Weight | €/Kilo
14100 | 2.907801418439716
20830 | 2.974075852136342
14600 | 2.808219178082192
12800 | 2.83203125
12800 | 2.83203125
7220 | 4.413434903047092
7220 | 4.413434903047092
7220 | 4.413434903047092
14600 | 2.808219178082192
14600 | 2.808219178082192
7220 | 4.413434903047092
12800 | 2.83203125
14600 | 2.808219178082192
14600 | 3.424657534246575
12800 | 2.83203125
12800 | 3.5078125
12800 | 2.83203125
20000 | 2.78
25000 | 2.6
16800 | 3
 | please click the button "Chart", you will see a graphe
 | 1 how to includ the line 20 and 21 in the chart??
 | 2 how to extract the equation in the chart  to stock somewhere like a button, for example???
 | Thank you very much for your help!!
Spreadsheet: 846024d1697316417-help-with-a-conditional-format-on-cells-with-formula-conditional-format-etaf
Sheet: POS

[PHONE] | 0 | CABLE I11,PRO,MAX,[NAME],XR,8-5SE | 22 | 9.99
[PHONE] | 0 | MICRU USB CABLE | 22 | 9.99
[PHONE] | 0 | S5 AND NOTEIII TRAVEL CHARGER | 22 | 9.99
[PHONE] | 0 | TYPE C USB CABLE | 22 | 9.99
[PHONE] | 0 | Travel Charger | 22 | 9.99
Spreadsheet: 107159d1304376264-help-with-excel-2010-grading-sheet
Sheet: Grades

High Plains School
Grade Calculation
 | Component Percentage
 |  |  |  | Total | Grade
Student |  |  |  |  | Overall
Spreadsheet: 64555d1265378392-counting-with-variable-requirements-sumbymonthandyear-1-
Sheet: Sheet1

Company | Date Raised | Days to Close
Company A | 2009-10-07 00:00:00 | 5
Company A | 2009-10-22 00:00:00 | 25
Company A | 2009-12-21 00:00:00 | 6
Company A | 2010-01-21 00:00:00 | 8
Company A | 2010-02-01 00:00:00 | 9
Company B | 2009-09-29 00:00:00 | 15
Company B | 2009-11-18 00:00:00 | 14
Company B | 2010-01-26 00:00:00 | 3
Company B | 2010-01-28 00:00:00 | 4
Company B | 2010-02-01 00:00:00 | 4
Company C | 2009-09-21 00:00:00 | 10
Company C | 2009-11-19 00:00:00 | 7
Company C | 2010-01-25 00:00:00 | 8
Company C | 2010-01-26 00:00:00 | 5
Company C | 2010-02-01 00:00:00 | 2
2009
Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
Company A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 30 | 0 | 6
Company B | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 0 | 14 | 0
Company C | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 0 | 7 | 0
2010
Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
Company A | 8 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Company B | 7 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Company C | 13 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 75564d1276110742-make-a-letter-have-a-value-to-add-it-together-system-win-percentage
Sheet: System 1

 | Series Start Date | Team | [A] | [B] | [C] | Record
1 | 2010-04-20 00:00:00 | Boston | W | X | X | 1-0
2 | 2010-04-23 00:00:00 | Boston | W | X | X | 2-0
3 | 2010-04-26 00:00:00 | Kansas City | W | X | X | 3-0
4 | 2010-04-26 00:00:00 | Milwaukee | W | X | X | 4-0
5 | 2010-04-26 00:00:00 | St Louis | W | X | X | 5-0
6 | 2010-04-30 00:00:00 | NYY | W | X | X | 6-0
7 | 2010-05-03 00:00:00 | Boston | W | X | X | 7-0
8 | 2010-05-06 00:00:00 | Minnesota | L | L | W | 8-0
9 | 2010-05-07 00:00:00 | Cincy | L | W | X | 9-0
10 | 2010-05-17 00:00:00 | Atlanta | L | W | X | 10-0
11 | 2010-05-28 00:00:00 | San Francisco | W | X | X | 11-0
12 | 2010-05-28 00:00:00 | Florida | L | L | W | 12-0
13 | 2010-06-01 00:00:00 | LA Dodgers | W | X | X | 13-0
14 | 2010-06-01 00:00:00 | Chicago White Sox | L | L | W | 14-0
15 | 2010-06-08 00:00:00 | Philly | W | X | X | 15-0
16
17
18
 |  |  | W
 |  | Win %
Spreadsheet: 65407d1266105269-formula-to-distinguish-month-year-from-prior-month-years-excel-spreadsheet-with-formulas
Sheet: Summary

 |  |  |  |  |  | 2010-01-10 00:00:00
 |  |  |  |  |  | Current Month Payment | Actual to Date $ [NAME] | Remaining  Sub-Total $ | Remaining Total$
A | [NAME]
 |  |  | 24000000 | 0 | 24000000 | 0 | 0 | 24000000
 |  |  | 0 | 0 | 0 | 0 |  | 0
 |  |  | 1000000 | -1000000 | 0 | 0 |  | 0
 |  |  | 937500 | 0 | 937500 | 0 | 0 | 937500
 |  |  | 2000000 | 0 | 2000000 | 0 |  | 2000000
 |  |  | 375000 | -375000 | 0
 | Total Tab 1 |  | 28312500 |  | 26937500 |  | 0 |  | 26937500
 |  |  |  |  | 1375000
B | [NAME]
 |  |  | 135000 |  | 135000 | 0 | 0 | 135000
 |  |  | 175500 |  | 175500 | 0 | 0 | 175500
 |  |  | 364500 |  | 364500 | 0 | 0 | 364500
 | Total Tab 2 |  |  |  | 675000 |  | 0 |  | 675000
C | [NAME]
 |  |  | 553700 |  | 553700 | 0 | 553700 | 0
 |  |  | 474600 |  | 474600 | 0 | 71190 | 403410
 |  |  | 110000 |  | 110000 | 0 | 110000 | 0
 |  |  | 221480 |  | 221480 | 0 | 221480 | 0
 |  |  | 276850 |  | 276850 | 0 | 276850 | 0
 |  |  | 55370 |  | 55370 | 0 | 55369.5 | 0.5
 |  |  | 47000 |  | 47000 | 0 | 28200 | 18800
 |  |  | 28500 |  | 28500 | 0 | 22800 | 5700
 |  |  | 0 | 20500.04 | 20500.04 | 553700 | 20500.04 | 0
 | Total Tab 3 |  |  |  | 1788000.04 |  | 1360089.54 | 427910.5 | 427910.5
D | [NAME]
 |  | 0.107 | 2831250 |  | 2831250 | 0 | 0 | 2831250
 |  | 0.0487 | 1415625 |  | 1415625 | 0 | 0 | 1415625
 | Total Tab 4 |  |  |  | 4246875 |  | 0 |  | 4246875
E | [NAME]
 |  | 0.0005 | 14156 |  | 14156 | 0 | 390 | 13766
 |  | 0.0161 | 283125 |  | 283125 | 3700 | 42360 | 240765
 |  |  | 200000 |  | 200000 | 0 | 0 | 200000
 | Total Tab 5 |  |  |  | 497281 |  | 42750 |  | 454531
F | Tab 6
 |  |  | 3274246 |  | 3274246 |  |  | 3274246
 |  |  | 0 |  | 0 |  |  | 0
 |  |  | 0 | -20500.04 | -20500.04 |  |  | -20500.04
 | Total Tab 6 |  | 3274246 |  | 3253745.96 |  |  |  | 3253745.96
G | [NAME]
 |  |  | 38000 |  | 38000 | 0 | 38000 | 0
 |  |  | 99616 |  | 99616 | 0 | 99616.16 | -0.1600000000034925
 | Total Tab 7 |  |  |  | 137616 |  | 137616.16 |  | -0.1600000000034925
H | Totals |  | 70497764 |  | 37536018 |  | 1540455.7 |  | 35995562.3 | 37536018
 |  |  |  |  | 37500000 |  |  |  | 35995562.3
 |  |  |  |  | -36018 |  |  |  | 0
 |  |  | 2400000
 |  |  | 31200000
 |  |  | 3900000
 |  |  | 37500000
Spreadsheet: 870794d1717234787-sumifs-substitute-2d_spill-aligw
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Women
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | USING Z1: |  | MANUAL EDIT:
Country X | Bolly
Country X | Pumpkin |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 984 |  | 984 |  | 984
Country X | Chicken |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9582 |  | 9582 |  | 9582
Country X | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 654 |  | 654 |  | 654
Country X | Apple |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50263 |  | 50263 |  | 50263
Country X | Mango |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3.136 |  | 3.136 |  | 3.136
Country X | Tumbaktu |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0
Country X | Rhodoendron |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 |  | 25 |  | 25
Country X | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3310 |  | 3310 |  | 3310
Country X | Pure |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3575 |  | 3575 |  | 3575
Country X
Country X Total | Total XXXXX |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 68652.136 |  | 68652.136
Country Y | Bolly |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 120 |  | 120 |  | 120
Country Y | Pumpkin |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1940 |  | 1940 |  | 1940
Country Y | Chicken |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11541 |  | 11541 |  | 11541
Country Y | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 57 |  | 57 |  | 57
Country Y | Apple |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3100 |  | 3100 |  | 3100
Country Y | Mango |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 82 |  | 82 |  | 82
Country Y | Tumbaktu |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0
Country Y | Rhodoendron |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 38021 |  | 38021 |  | 38021
Country Y | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2083 |  | 2083 |  | 2083
Country Y | Pure |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1321 |  | 1321 |  | 1321
Country Y
Country Y Total | Total XXXXX |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 58265 |  | 58265
Spreadsheet: 173b3307-149a-4bde-81b9-2da2489ed350
Sheet: Denials 2008

MULTNOMAH COUNTY LOAN DENIAL RATES BY INCOME-RACE GROUPINGS : 2008
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 | 6 | 18 | 12 | 28 | 66
Asian | 12 | 63 | 221 | 95 | 409 | 809
Blacks | 3 | 17 | 45 | 34 | 84 | 184
Native Hawaiian or Pacific Islander | 0 | 2 | 16 | 11 | 48 | 77
White | 64 | 349 | 1614 | 771 | 4145 | 7021
Hispanic | 3 | 33 | 130 | 66 | 190 | 426
Overall Total | 81 | 475 | 2044 | 948 | 5055 | 8725
II.  Total Denials
 | 0-30% MFI | 31-50% MFI | 51-80% MFI | 81-95% MFI | >95% MFI | Total
American Indian | 0 | 5 | 6 | 1 | 5 | 17
Asian | 9 | 16 | 51 | 18 | 61 | 160
Blacks | 2 | 7 | 10 | 9 | 13 | 41
Native Hawaiian or Pacific Islander | 0 | 0 | 5 | 1 | 13 | 19
White | 20 | 83 | 285 | 114 | 515 | 1039
Hispanic | 3 | 11 | 46 | 13 | 40 | 113
Overall Total | 30 | 125 | 385 | 152 | 648 | 1370
III. Denial Rates (II/I) * 100
 | 0-30% MFI | 31-50% MFI | 51-80% MFI | 81-95% MFI | >95% MFI | Total
American Indian |  | 0
Asian
Blacks
Native Hawaiian or Pacific Islander | 0
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: 704317d1605498080-data-rearrangement-in-row-book3-2-
Sheet: Sheet1

 |  |  | Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10 | Column11
 |  |  | 1 | 4 | 7 | 10 | 13 | 16 | 19 | 22 | 25 | 28 | 31
 |  |  | 2 | 5 | 8 | 11 | 14 | 17 | 20 | 23 | 26 | 29 | 32
 |  |  | 3 | 6 | 9 | 12 | 15 | 18 | 21 | 24 | 27 | 30 | 33
 |  |  |  |  |  |  |  | 6 |  |  |  | ? | ? | ?
Spreadsheet: 92191d1291833560-excel-2007-pull-data-from-multiple-sheet-example
Sheet: 2

Qualification Tensile Inspection
Supplier | ABC
 | ([NAME]) | (in)
[NAME]: | 4
Length: | 150
 |  |  |  | Date Tested: | 2010-11-05 00:00:00
 | Tested at Location: | ABC |  | Tested by:
Cavity | Tensile Strength (N) | [NAME] (lbf) | Insertion Force (N) | Moisture | Comments
1 | 285 |  |  | 1.9
2 | 276
3 | 298
4 | 234
5 | 226
6 | 255
7 | 256
8 | 258
9 | 276
10 | 286
11 | 282
12 | 276
13 | 288
14 | 256
15 | 270
16 | 285
17 | 281
18
19 | 259
20 | 275
21 | 270
22 | 288
23 | 259
24 | 256
25 | 292
26 | 239
27 | 216
28 | 285
29 | 199
30 | 286
31 | 287
32 | 256
33 | 263
34 | 248
35 | 244
36 | 272
37 | 269
38 | 285
39 | 196
40 | 246
41 | 229
42 | 290
43 | 283
44 | 222
45 | 276
46 | 269
47 | 269
48 | 267
49 | 268
50 | 238
51 | 285
52 | 264
53 | 265
54 | 297
Average |  |  | Average
Min |  |  | Min
[NAME] |  |  | [NAME]
[NAME] |  |  | [NAME]
Spreadsheet: 128639d1321139886-unhide-column-s-and-p-expanded-pivot
Sheet: Monthly

TC | (PIVOT - BC) + PIVOT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date | VAH | VaL | VA Range | mean CPR | std CPR | mean +1 | mean     -1/2
Pivot | (H+L+C)/3 | Date | H | L | C | Range | Close | Open #F=2 | PIVOT | BC | TC | Prange | R1 | R2 | R3 | R4 | S1 | S2 | S3 | [NAME]
BC | (H+L)/2 | 2011-10-31 00:00:00 | 1289.25 | 1068 | 1249.25 |  |  | 1118.75
 |  | 2011-11-30 00:00:00 | 1275.25 | 1208.5 | 1261.5 |  |  | 1247.5
R4 | R3 + (R2-R1)
R3 | R1+(H-L)
R2 | PIVOT + (H-L)
R1 | 2 X PIVOT - LOW
S1 | 2 X PIVOT - HIGH
S2 | PIVOT - (HIGH - LOW)
S3 | S1 - (HIGH - LOW)
[NAME] | S3 - (S1 - S2)
Spreadsheet: john_griffith__16029__2_5_02GO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | [NAME] | 58 | 500 | 600 | 46.2 | 55.5 | 1.85 | 2002-02-05 11:55:00
 | [NAME] | 65 | 840 | 930 | 44.9 | 49.7 | 1.93 | 2002-02-05 11:55:00
 | [NAME] | 66 | 1025 | 1125 | 42.2 | 46.4 | 1.84 | 2002-02-05 11:55:00
 | [NAME] | 66 | 1175 | 1275 | 40.8 | 44.3 | 1.77 | 2002-02-05 11:55:00
 | HU N2 | 64 | 1275 | 1375 | 41 | 44.3 | 1.72 | 2002-02-05 11:55:00
 | [NAME] | 64 | 1300 | 1400 | 38 | 40.9 | 1.59 | 2002-02-05 11:55:00
 | HU U2 | 62 | 1325 | 1425 | 36.9 | 39.7 | 1.49 | 2002-02-05 11:55:00
 | [NAME] | 60 | 1300 | 1450 | 35.1 | 39.2 | 1.4 | 2002-02-05 11:55:00
 | [NAME] | 59 | 1300 | 1450 | 33.5 | 37.4 | 1.31 | 2002-02-05 11:55:00
 | [NAME] | 59 | 1300 | 1450 | 32 | 35.7 | 1.26 | 2002-02-05 11:55:00
 | HU F3 | 59 | 1300 | 1450 | 30.6 | 34.2 | 1.2 | 2002-02-05 11:55:00
 | [NAME] |  |  |  |  |  | 1.26 | 2001-08-20 15:44:00
 | HU H3
 | [NAME]
 | [NAME] |  |  |  |  |  | 0.56 | 2001-07-19 17:15:00
 | HU M3
Spreadsheet: 885308d1734797323-excel-function-that-can-take-an-array-value-for-rates-for-npv-with-multiple-rates-xnpv3
Sheet: JT

Method 1 |  |  |  |  |  |  |  |  |  |  | Method 2
Calculate XNPV of individual cash flows at their respective rates, then sum up
 |  |  |  | 2025-09-14 00:00:00 | 2026-01-07 00:00:00 | 2027-02-28 00:00:00 | 2027-05-28 00:00:00 | 2028-12-18 00:00:00 | 2029-05-09 00:00:00 |  |  |  |  |  | 2025-09-14 00:00:00 | 2026-01-07 00:00:00 | 2027-02-28 00:00:00 | 2027-05-28 00:00:00 | 2028-12-18 00:00:00
Rate | Dates | Values |  | 3670998.19 | 567283.99 | 4226362.05 | 7389020.34 | 10455837.28 | 14375800.65 |  | Rate | Dates | Values |  | 0.07 | 0.06 | 0.09 | 0.15 | 0.17
START> | 2024-12-31 00:00:00 | 1256023.32 |  |  |  |  |  |  |  |  | START> | 2024-12-31 00:00:00 | 1256023.32
0.12 | 2025-09-14 00:00:00 | 3670998.19 |  |  |  |  |  |  |  |  | 0.12 | 2025-09-14 00:00:00 | 3670998.19 | [NAME]
0.07 | 2026-01-07 00:00:00 | 567283.99 |  |  |  |  |  |  |  |  | 0.07 | 2026-01-07 00:00:00 | 567283.99
0.06 | 2027-02-28 00:00:00 | 4226362.05 |  |  |  |  |  |  |  |  | 0.06 | 2027-02-28 00:00:00 | 4226362.05
0.09 | 2027-05-28 00:00:00 | 7389020.34 |  |  |  |  |  |  |  |  | 0.09 | 2027-05-28 00:00:00 | 7389020.34
0.15 | 2028-12-18 00:00:00 | 10455837.28 |  |  |  |  |  |  |  |  | 0.15 | 2028-12-18 00:00:00 | 10455837.28
0.17 | 2029-05-09 00:00:00 | 14375800.65 |  |  |  |  |  |  |  |  | 0.17 | 2029-05-09 00:00:00 | 14375800.65
Total Cash flow |  |  | <- undiscounted |  |  |  |  |  |  |  | Total Cash flow |  |  | <- undiscounted
 |  | Rate |  | 0.12 | 0.07 | 0.06 | 0.09 | 0.15 | 0.17 |  |  |  | XNPV
 |  |  |  |  |  |  |  |  |  |  |  |  | Adjustment
 |  | XNPV |  |  |  |  |  |  |  |  |  |  | Adj. XNPV
 |  | Total XNPV |  |  |  |  |  |  |  |  |  |  | Total XNPV
Spreadsheet: 761323d1640812973-two-questions-find-similar-names-and-setting-values-mysentinel-extract-example
Sheet: Sheet1

S. No. | MySentinel Application Name Display Name
1 | 1099 Pro
2 | 1099 Pro CS
3 | AppClarity
4 | 2-Way Connect
5 | 360 Risk Op
6 | [NAME]
7 | Project 2016
8 | Actimize
9 | Actimize - CDD
10 | ACTIMIZE - SAM
11 | ACTIMIZE - CTR
12 | ADFS
13 | Active Directory Federation Services (ADFS)
14 | Active Directory Federation Services
15 | ACE
16 | ACH/PEP+
17 | PEP+
18 | ACH
19 | Adjustments
20 | Adobe: Acrobat Professional: 9
21 | Adobe: Acrobat Professional: 8
22 | Adobe: Acrobat Standard: 8
23 | Adobe: Acrobat Standard: 6
24 | Adobe: Dreamweaver: CC 2015
25 | Adobe: Dreamweaver: CC 2016
26 | ADP iPayStatements
27 | ADPLink
28 | AFSNet
29 | BearGrease
30 | Barclay Capital
31 | Beyone Compare
32 | Bloomberg FX
33 | Bloomberg FX
34 | BlueCoat MACH5
35 | BlueCoat Reporter
36 | BNPP - MIT
37 | BNPP - NOMAD
38 | BNPP - Fortis Credit Risk Reporting
39 | Bomgar
40 | Bomgar: Support
41 | RadFox Blog
42 | DMZ Domain
43 | PREP Platform
44 | [NAME]
45 | Cash Vault
46 | CashEdge - Open Now/Fund Now
47 | C-Cure 9000
48 | CDD ROVP
49 | CDD Onboarding Tool
50 | ROVP
51 | CFT
52 | Certified Tracking
53 | Cisco DNA Center
54 | Cisco Data Center Manager
55 | Cisco TACACS
56 | Comply Wire
57 | Comply Wires
58 | Data Choice
59 | Database - Finance Center 8
60 | Database - Finance Data Mart Production
61 | Datawatch: Monarch Pro: 10
62 | Datawatch: Monarch Pro: 8
63 | Wells Fargo
64 | DUO
65 | Dupe Detective
66 | Duplicate - Archsight
67 | Archsight
68 | [NAME]
69 | EditPlus
70 | Editor.Swagger.io
71 | EDS Premier
72 | EDS Scanner Management
73 | e-Funds
74 | e-Funds Online
75 | e-Funds Online
76 | Enterprise FormIO
77 | Enterprise [NAME]
78 | Enterprise Service Bus
79 | Enterprise Service Bus
80 | Evernest
81 | Evernest 10
82 | Greenshot.org
83 | HALO aka ELC (Enterprise Lending Center)
84 | HALO
85 | Enterprise Lending Center (ELC)
86 | Helios: TextPad
87 | jsonformatter.org
88 | Microsoft Word
89 | Microsoft Office
90 | Microsoft Word 2016
91 | PEP+Exchange
92 | PIVOT
93 | PINDROP Case Manager
94 | PINDROP
95 | PMP (Party Master Platform)
96 | POC
97 | Polite Mail
98 | Party Master [NAME] (PMP)
99 | Quest Software: Toad for Oracle: 11.1
100 | Quest Software: Toad for Oracle: 10.6
101 | Quest Software: Toad Data Modeler: 2
102 | Quest Software: Toad Data Modeler: 5
103 | Radware
104 | Rapport
105 | Rapport - Eqfax Web Services
106 | RazorSQL
107 | SAP: Crystal Reports: 10
108 | SAP: Crystal Reports: 11
109 | SAP: Crystal Reports: 2019
110 | TechSmith: [NAME]: 11
111 | TechSmith: [NAME]: 2018
112 | TortoiseSVN
113 | TortoiseSVN: TortoiseSVN: 1.8
114 | [NAME]
115 | Vector Inquiry
116 | Vector Kite
117 | WC3
118 | WC3
119 | WDP (Wire Data Planning)
120 | Webex
121 | Webex Productivity Tools
122 | [NAME]
123 | [NAME]
124 | [NAME]
125 | Xvision
126 | Zoom
127 | Zywave - Broker Briefcase
128 | ZMLSpy
129 | Xeno Online
130 | Xeno Online
131 | [NAME]