tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 216b5582-e0fa-4d61-a484-83297a184095
Sheet: SF-424A (8)

Applicant Name: |  |  |  | Award Number:
Budget Information - Non Construction Programs
OMB Approval No. 0348-0044
Section A - Budget Summary
 | Grant Program Function or Activity | Catalog of Federal Domestic Assistance Number | Estimated Unobligated Funds |  | New or Revised Budget
 |  |  | Federal | Non-Federal | Federal | Non-Federal | Total
 | (a) | (b) | (c ) | (d) | (e) | (f) | (g)
1. | Previous Projects | 10.17
2.
3.
4.
5. | Totals
Section B - Budget Categories
6. | Object Class Categories |  | Grant Program, Function or Activity |  |  |  | Total (5)
 |  |  | Previous Projects | (23) | (24) | (25)
 | [NAME]
 | [NAME]
 | c.  Travel
 | d.  Equipment
 | e.  Supplies
 | f.  Contractual
 | g.  Construction
 | h.  Other
 | i.  Total Direct Charges (sum of 6a-6h)
 | j.  Indirect Charges
 | k.  Totals (sum of 6i-6j)
7. | Program Income
 |  |  |  |  |  |  | SF-424A (Rev. 4-92)
Previous Edition Usable |  |  |  |  |  | Prescribed by OMB Circular A-102
Authorized for Local Reproduction
Section C - Non-Federal Resources
 | (a) Grant Program |  |  | (b) Applicant | (c ) State | (d) Other Sources | (e) Totals
8.
9.
10.
11.
12. | Total (sum of lines 8 - 11)
Section D - Forecasted Cash Needs
 |  |  | Total for 1st Year | 1st Quarter | 2nd Quarter | 3rd Quarter | 4th quarter
13. | Federal
14. | Non-Federal
15. | Total (sum of lines 13 and 14)
Section E - Budget Estimates of Federal Funds Needed for Balance of the Project
(a) Grant Program |  |  |  | Future Funding Periods (Years)
 |  |  |  | (b) First | (c ) Second | (d) Third | (e) Fourth
16.
17.
18.
19.
20. | Total (sum of lines 16-19)
Section F - Other Budget Information
21. Direct Charges |  |  |  | 22. Indirect Charges
23.  [NAME]
 |  |  |  |  |  |  | SF-424A (Rev. 4-92)
Previous Edition Usable |  |  |  |  |  |  | Prescribed by OMB Circular A-102
 |  | Authorized for Local Reproduction
Spreadsheet: phillip_m_love__30054__PowerRiskCalc Jan01 Sithe 1-30-01
Sheet: Model

 |  | Valuation date | 2001-01-30 00:00:00
 | Avg. Start Date | Avg. End Date | Curve ($/MWhr) | Vol % | Years until averaging begins | Years until averaging ends | # of settle prices | Strike price ($/MWhr) | Interest rate | Set days | Avg. Price to Date | Time to [NAME] | Call/Put (1/0) | Option Premium ($/MWhr) | Total MWhrs | Total value
 |  | 2001-01-31 00:00:00 |  | 1.609728351931112 |  |  |  | 58 | 0.067 | 30 |  |  | Call
 |  |  |  | A | B
 | Delivery date | MW | MWhrs | Market price | AXB |  | Value summary
 | 2001-01-01 00:00:00 | 200 |  |  |  |  | Valuation as of
 | 2001-01-02 00:00:00 | 200 |  |  |  |  | Valuation as of
 | 2001-01-03 00:00:00 | 200 |  |  |  |  | Change in value
 | 2001-01-04 00:00:00 | 200
 | 2001-01-05 00:00:00 | 200 |  |  |  |  | Curve shift
 | 2001-01-06 00:00:00 | 200 |  |  |  |  | Theta
 | 2001-01-07 00:00:00 | 200 |  |  |  |  | Vol
 | 2001-01-08 00:00:00 | 200 |  |  |  |  | Set days
 | 2001-01-09 00:00:00 | 200 |  |  |  |  | 2nd order
 | 2001-01-10 00:00:00 | 200 |  |  |  |  | Total change
 | 2001-01-11 00:00:00 | 200
 | 2001-01-12 00:00:00 | 200
 | 2001-01-13 00:00:00 | 200
 | 2001-01-14 00:00:00 | 200
 | 2001-01-15 00:00:00 | 200
 | 2001-01-16 00:00:00 | 200
 | 2001-01-17 00:00:00 | 200
 | 2001-01-18 00:00:00 | 200
 | 2001-01-19 00:00:00 | 200
 | 2001-01-20 00:00:00 | 200
 | 2001-01-21 00:00:00 | 200
 | 2001-01-22 00:00:00 | 200
 | 2001-01-23 00:00:00 | 200
 | 2001-01-24 00:00:00 | 200
 | 2001-01-25 00:00:00 | 200
 | 2001-01-26 00:00:00 | 200
 | 2001-01-27 00:00:00 | 200
 | 2001-01-28 00:00:00 | 200
 | 2001-01-29 00:00:00 | 200
 | 2001-01-30 00:00:00 | 200
 | 2001-01-31 00:00:00 | 200
Spreadsheet: 196312d1353953724-counting-number-of-quotes-given-to-a-company-over-a-quarterly-period-jusmightbeokay_excel
Sheet: Sheet1

Deal ID | Option | A/B | Prospect name | Quarter |  | Quarter | Number of Companies | A Quotes | B Quotes | Total Quotes
Y12-001 | Option 1 | A | Company 1 | Q1-2012 |  | Q1-2012
Y12-002 | Option 1 | A | Company 2 | Q1-2012 |  | Q2-2012
Y12-002 | Option 1 | A | Company 2 | Q1-2012 |  | Q3-2012
Y12-003 | Option 1 | A | Company 3 | Q1-2012 |  | Q4-2012
Y12-003 | Option 2 | A | Company 3 | Q1-2012
Y12-003 | Option 3 | A | Company 3 | Q1-2012
Y12-003 | Option 4 | A | Company 3 | Q1-2012
Y12-004 | Option 1 | B | Company 4 | Q2-2012
Y12-004 | Option 2 | B | Company 4 | Q2-2012
Y12-004 | Option 3 | B | Company 4 | Q2-2012
Y12-005 | Option 1 | A | Company 5 | Q2-2012
Y12-006 | Option 1 | B | Company 6 | Q2-2012
Y12-006 | Option 2 | B | Company 6 | Q2-2012
Y12-006 | Option 3 | B | Company 6 | Q2-2012
Y12-006 | Option 4 | B | Company 6 | Q2-2012
Y12-007 | Option 1 | A | Company 7 | Q3-2012
Y12-008 | Option 1 | B | Company 8 | Q3-2012
Y12-008 | Option 2 | B | Company 8 | Q3-2012
Y12-009 | Option 1 | A | Company 9 | Q4-2012
Y12-009 | Option 2 | A | Company 9 | Q4-2012
Y12-010 | Option 1 | B | Company 10 | Q4-2012
Spreadsheet: darrell_schoolcraft__7532__Eott Summary UAF Reports 2002
Sheet: Marine Operations

Marine Operations - 7502
 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sept | Oct | Nov | Dec | Total
Berwick Terminal - 61148
Beginning Inventory | 110.29 |  |  |  |  |  |  |  | 110.29
Receipts | 0
Deliveries | 0
Ending Inventory | 110.29
Gain (Loss)-Bbls
Gain (Loss)- % |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
PMA's | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Adjusted G(L)-Bbls
Adjusted G(L)- % |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
Darrow Storage - 60226
Beginning Inventory | 3213.93
Receipts | 6753.1
Deliveries | 0
Ending Inventory | 9831.85
Gain (Loss)-Bbls
Gain (Loss)- %
PMA's | -19.89 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Adjusted G(L)-Bbls
Adjusted G(L)- %
[NAME]
Beginning Inventory | 26493.43 |  |  | 20358.06
Receipts | 92788.8
Deliveries | 101298.57
Ending Inventory | 18277.95
Gain (Loss)-Bbls
Gain (Loss)- %
PMA's | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Adjusted G(L)-Bbls
Adjusted G(L)- %
Eloi Bay Station - 39716
Beginning Inventory | 9852.74 |  | 5245.43
Receipts | 67037.21
Deliveries | 68348.05
Ending Inventory | 8775.86
Gain (Loss)-Bbls
Gain (Loss)- %
PMA's | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Adjusted G(L)-Bbls
Adjusted G(L)- %
[NAME]
Beginning Inventory | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
Receipts | 12499.07
Deliveries | 12480.88
Ending Inventory | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Gain (Loss)-Bbls
Gain (Loss)- %
PMA's | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Adjusted G(L)-Bbls
Adjusted G(L)- %
[NAME]
Beginning Inventory | 43705.71
Receipts | 157678.63
Deliveries | 161868.39
Ending Inventory | 39680.13
Gain (Loss)-Bbls
Gain (Loss)- %
PMA's | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Adjusted G(L)-Bbls
Adjusted G(L)- %
Unocal - Forked Island - 1013661
Beginning Inventory | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
Receipts | 40487.2
Deliveries | 40535.52
Ending Inventory | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Gain (Loss)-Bbls
Gain (Loss)- % | 0 | 0 | 0 | 0 | 0
PMA's | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Adjusted G(L)-Bbls
Adjusted G(L)- %
Total Marine Operations
Beginning Inventory |  | 0
Receipts
Deliveries
Ending Inventory
Gain (Loss)-Bbls
Gain (Loss)- %
PMA's | 0
Adjusted G(L)-Bbls
Adjusted G(L)- %
Spreadsheet: 788651d1658602176-highlight-data-with-vlookup-samplequestionforum
Sheet: Sheet1-Data

unique ID | Name | Sales2016 | Slaes2017 | Sales2018
751061 | CODO INOX CED-40 SOLDABLE 10" X 90
751790 | CODO INOX CED-40 8" X 90
770186 | TEE INOX C-40 SOLDABLE 6"
751050 | CODO INOX  CED-40 SOLDABLE 2" X 90
751079 | FLANGE INOX S/CUELLO 8" X 150 PSI
751054 | CODO INOX CED-40 SOLDABLE 4" X 90
751056 | CODO INOX CED-40 SOLDABLE 6" X 90
Spreadsheet: 737650d1624530325-formula-error-from-live-data-skip-tracker
Sheet: Sheet2

6T Skip Number | [NAME] | Inspection Date | Inspection Category | Days on Hire
BCAB5001 | 6 Tonne | 2021-05-31 00:00:00 | Outbound
BCAB5002 | 6 Tonne | 2021-06-01 00:00:00 | Outbound
BCAB5003 | 6 Tonne | 2021-06-02 00:00:00 | Outbound
BCAB5001 | 6 Tonne | 2021-06-15 00:00:00 | Inbound
BCAB5002 | 6 Tonne | 2021-06-17 00:00:00 | Inbound
BCAB5003 | 6 Tonne | 2021-06-19 00:00:00 | Inbound
BCAB5001 | 6 Tonne | 2021-06-20 00:00:00 | Outbound
BCAB5002 | 6 Tonne | 2021-06-19 00:00:00 | Outbound
BCAB5003 | 6 Tonne | 2021-06-19 00:00:00 | Outbound
BCAB5001 | 6 Tonne | 2021-06-23 00:00:00 | Inbound
BCAB5002 | 6 Tonne | 2021-06-23 00:00:00 | Inbound
BCAB5003 | 6 Tonne | 2021-06-23 00:00:00 | Inbound
Spreadsheet: 195826d1353675833-in-vlook-if-value-comes-to-n-a-i-want-there-0-new-clustwise-nov-12
Sheet: comparison

Cluster | Biz as on |  | Total Target Nov  2012 | Biz as on |  | Gap | [NAME]/day
 | 21/10/2012 | % achieved |  | 21/11/2012 | % achieved
Aurangabad | 0.6361033 | 0.01734196564885496 | 36.68 | 0.6571033000000001 | 0.01791448473282443 | 36.0228967 | 4.002544077777777
Nasik | 1.7752359 | 0.03944968666666666 | 45 | 1.7752359 | 0.03944968666666666 | 43.2247641 | 4.802751566666667
[NAME] | 0.9132100000000001 | 0.02422307692307692 | 37.7 | 0.9132100000000001 | 0.02422307692307692 | 36.78679 | 4.087421111111111
Goa | 0.8073537 | 0.04718607247223846 | 17.11 | 0.8073537 | 0.04718607247223846 | 16.3026463 | 1.811405144444444
[NAME] | 3.3881245 | 0.03007389046689153 | 112.66 | 3.3881245 | 0.03007389046689153 | 109.2718755 | 12.1413195
Total | 7.5200274 | 0.03018273088500903 | 249.15 | 7.5410274 | 0.03026701745936183 | 241.6089726 | 26.84544140000001
Spreadsheet: darrell_schoolcraft__7792__imbalsumm0107
Sheet: by type

TRANSWESTERN  PIPELINE -   SUMMARY OF OBA BALANCES |  |  |  |  |  | index
 |  |  |  |  |  | SJ
Positive=due [NAME] |  | Negative = due operator |  |  |  | AVG
 |  |  |  |  |  | NTXPH
Operator | Dollars | Volume | Date | Imbal Type | MS rep | Comments
NNG |  |  |  | Dollar Valued | [NAME] | working on 10,000/d to sell
Red Cedar |  |  |  | Dollar Valued | [NAME]
Conoco |  |  |  | Dollar Valued | [NAME] | [NAME] and Maljamar
[NAME] |  |  |  | Dollar Valued | [NAME]
Amoco Abo |  |  |  | Dollar Valued | [NAME] | possible cashout
PNM |  |  |  | Dollar Valued | [NAME] | 6,000/d being received in payback
Duke/GPM |  |  |  | Dollar Valued | [NAME] | Crawford, Pecos Diamond, [NAME], Linam Ranch, Artesia
Mewborne |  |  |  | Dollar Valued | [NAME]
CIG |  |  |  | Dollar Valued | [NAME]
PG&E TX/EPFS |  |  |  | Dollar Valued | [NAME]
EOG |  |  |  | Dollar Valued | [NAME]
[NAME] |  |  |  | Dollar Valued | [NAME] | 6/30/01 balance of $887,643.73 invoiced
Agave |  |  |  | Dollar Valued | [NAME]
TransColorado |  |  |  | Dollar Valued | [NAME]
Calpine |  |  |  | Dollar Valued | [NAME]
Continental |  |  |  | Dollar Valued | [NAME]
Burlington |  |  |  | Dollar Valued | [NAME] | balance is cashed out monthly
El Paso Field Services |  |  |  | Dollar Valued | [NAME]
Citizens-Griffith |  |  |  | Dollar Valued | [NAME] | after 19th we will pay back
North Star Steel |  |  |  | Dollar Valued | [NAME]
Citizens Communications |  |  |  | Dollar Valued | [NAME]
$ valued totals
Operator | Dollars | Volume | Date | Imbal Type | MS rep | Comments
[NAME] |  |  |  | Volumetric | [NAME] | [NAME], Valverde, [NAME], and Milagro
SoCal |  |  |  | Volumetric | [NAME]
NGPL |  |  |  | Volumetric | [NAME] | 5,000/DAY scheduled for makeup
Mojave Pipeline |  |  |  | Volumetric | [NAME]
Panhandle Eastern |  |  |  | Volumetric | [NAME] | Hansford
El Paso |  |  |  | Volumetric | [NAME] | Blanco and Window Rock
Lonestar |  |  |  | Volumetric | [NAME] | 3,000/d scheduled makeup from 7/12 - 7/18
Amoco |  |  |  | Volumetric | [NAME]
Oasis |  |  |  | Volumetric | [NAME]
PG&E Topock |  |  |  | Volumetric | [NAME]
Northwest |  |  |  | Volumetric | [NAME]
volumetric totals
Net $ valued/volumetric
Note -  This report does not represent the total population of imbalances on Transwestern.
Spreadsheet: 700085d1602939735-instantaneous-value-at-each-hour-from-start-and-end-time-power
Sheet: Sheet1

 | Sl.NO | Name  of  Appliance | Power (W) | Time of  Start | Time of  End | Quantity
 | 1 | Lamp | 20 | 2020-10-16 05:00:00 | 2020-10-16 20:00:00 | 30
 | 2 | PC | 80 | 2020-10-16 05:00:00 | 2020-10-16 20:00:00 | 12
 | 3 | Moniter | 155 | 2020-10-16 05:00:00 | 2020-10-16 20:00:00 | 4
 | 4 | Security Camera | 40 | 2020-10-16 01:00:00 | 2020-10-16 12:59:00 | 10
Spreadsheet: 789905d1659434659-index-match-from-dropdown-test_data-1-
Sheet: bill_calculation

 |  |  |  |  | `
 |  | distribution
 |  | Vegetables/Fruits |  |  |  | Order
 |  | Items | Rate | Per | Weight | shrikant | Poushali | Pravina | Sharad | Wajpe | Dinesh | Vijay | Ban | Satish |  |  |  | Total Order | Total [NAME]
 |  | [NAME] | 60 | Kg | 1000 | 250 |  | 250 | 250 | 250 | 250 | 250 |  |  |  |  |  |  | 90
 |  | Curlyflower | 56 | Kg | 1000 | 500 | 500 | 500 | 250 |  | 750 | 750 | 250 | 250
 |  | Brinjal | 44 | Kg | 1000 | 500 | 250 | 500 | 500 |  | 750 | 750
 |  | Beans | 15 | Bunch | 1 | 1 |  | 1 | 2 | 1
 |  | Greens | 15 | Bunch | 1 | 1 |  | 1 | 3
 |  | Veg.Leavs | 15 | Bunch | 1 | 1 |  | 2 | 1 |  | 2
 |  | Red beans | 20 | Bunch | 1 | 1 | 1 | 1 | 1
 |  | [NAME] | 20 | Bunch | 1 | 1 | 1 | 1 | 2 |  | 2
 |  | [NAME] | 10 | Bunch | 1 | 5 |  | 5 | 10 |  | 10
 |  | Mint | 20 | Bunch | 1 | 1 | 1 | 1 | 1 |  | 2 |  | 2 | 2
 |  | [NAME] | 60 | Dozen | 12 | 6 | 12 | 12 | 12 |  | 12
 |  | Sapling | 30 | Piece | 1 | 1 |  | 1 | 1 | 1 | 2 |  |  |  |  |  |  |  |  |  |  |  | `
 |  | Total
Spreadsheet: 791730d1660568139-pay-as-you-earn-calculation-paye-calculator-3-
Sheet: Sheet1

Tax start period | 2021-07-01 00:00:00 | 2021-07-01 00:00:00
Tax end period | 2022-06-30 00:00:00 | 2022-06-30 00:00:00
Gross earnings | 123000 | 345000
Pension fund (Tax Deductible | 1755 | 1755
Taxable pay
Annual Tax rebate (not more than 60 years of ages | 8200 | 8200
Annual Tax rebate (more than 60 years of ages | 10900 | 10900
The rates of Income Tax applicable are as follows:
RATES OF NORMAL TAX FOR INDIVIDUALS
Exceeds | Does not exceed
Taxable Income |  |  |  | Rates |  |  |  |  |  |  |  | 121245 | 343245
 |  |  |  |  |  |  |  |  | Band Start | Rate
0 | 100000 | 0 | 0.2 | E0           +  20% of the excess of E0 00 |  |  |  |  | 0 | 0
100000 | 150000 | 20000 | 0.25 | E20 000 + 25% of the excess of E100 000 |  |  |  |  | 50000
150000 | 200000 | 32500 | 0.3 | E32 500 + 30% of the excess of E150 000 |  |  |  |  | 100000
200000 |  | 47500 | 0.33 | E47 500 + 33% of the excess of E200 000 |  |  |  |  | 150000
 |  |  |  |  |  |  |  |  | 200000
Manual Calculation
 | taxable pay | 121245 | 121245
Between 10000 and 15000 |  | 20000 | 20000
 | 0.25
 |  | 8200 | 10900
Tax Payable
Spreadsheet: 164317d1340726160-excel-2007-repeating-subtration-troubleshooting-spreadsheet
Sheet: Sheet1

4931
BILL# | BILL DATE | PRINCIPAL | INTEREST | ADMIN | TOTAL |  |  |  |  | Monthly Payment
[NAME] | 2011-11-04 00:00:00 | 235 | 1.37 | 11.22 | 247.59 | 197.59 | Money Due | 7 | July | 50
K200YH7 | 2011-11-04 00:00:00 | 1100 | 6.34 | 0 | 1106.34 | 908.7499999999999 | Money Due | 8 | August | Start Month
K205J9I | 2012-05-08 00:00:00 | 8 | 0 | 0 | 8 | -900.7499999999999 | balance | 9 | September | 7
 |  |  |  |  | 0 | -900.7499999999999 | balance | 9 | September
 |  |  |  |  | 0 | -900.7499999999999 | balance | 9 | September
 |  |  |  |  | 0 | -900.7499999999999 | balance | 9 | September
 |  |  |  |  | 0 | -900.7499999999999 | balance | 9 | September
 |  |  |  |  | 0 | -900.7499999999999 | balance | 9 | September
 |  |  |  |  | 0 | -900.7499999999999 | balance | 9 | September
 |  |  |  |  | 0 | -900.7499999999999 | balance | 9 | September
 |  |  |  |  | 0 | -900.7499999999999 | balance | 9 | September
 |  |  |  |  | 0 | -900.7499999999999 | balance | 9 | September
 |  |  |  |  |  | 197.59 | 7 | July
 |  | 1 | January |  |  | -908.7499999999999 | 7 | July
 |  | 2 | February |  |  | 50 | 8 | August
 |  | 3 | March |  |  | 50 | 9 | September
 |  | 4 | April |  |  | 50 | 10 | October
 |  | 5 | May |  |  | 50 | 11 | November
 |  | 6 | June |  |  | 50 | 12 | December
 |  | 7 | July |  |  | 50 | 13 | January
 |  | 8 | August |  |  | 50 | 14 | February
 |  | 9 | September |  |  | 50 | 15 | March
 |  | 10 | October |  |  | 50 | 16 | April
 |  | 11 | November |  |  | 50 | 17 | May
 |  | 12 | December |  |  | 50 | 18 | June
 |  |  |  |  |  | 50 | 19 | July
Spreadsheet: 862834d1710421628-need-help-totaling-based-on-selections-mix-id-calculator-tier_addres
Sheet: Commercial Selection Tab

Commercial Mix ID Calculator
Tier | Mix ID | Add On |  |  |  |  |  |  |  |  |  | Distance | Total
T1
 |  | Air | HRWR | 3/8 Agg | [NAME] | 1%Retard | 2%Retard | 3%Retard | Fiber | SRA | SS
 | COM301510 | False | False | False |  |  | False | False | False | False | False | 1-10
Spreadsheet: 219365d1362737169-match-multiple-criteria-then-select-the-smallest-value-the-lookup-value-multimatchlookupsampledata
Sheet: Sheet2

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
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
270.1639344262295
559.047619047619
1740.689655172414
2440
4519.512195121952
12894.44444444445
21573.91304347826
35785.71428571428
60500
120791.6666666667
215000
375611.1111111111
616562.5
866071.4285714285
1067000
10000000
Spreadsheet: 145699d1331717768-how-to-look-up-with-duplicate-values-duplicate
Sheet: Sheet2

 |  |  |  |  | tpHCM
 |  |  |  |  | HaNoi
 |  |  |  |  | HaiPhong
Province | Category | Price
tp HCM | sugar | 10000
tp HCM | milk | 6000
tp HCM | rice | 20000
HaNoi | cake | 15000
HaNoi | flower | 16000
HaNoi | rice | 32000
HaiPhong | bike | 8000
HaiPhong | candy | 7000
HaiPhong | rice | 25000
Spreadsheet: 386550d1427831324-looking-up-enitre-rows-even-to-the-left-of-the-targeted-cell-dpb_example-ndm
Sheet: Granite Imports (Marble)

Name | 3cm | Vendor
Azul Lunas | 19 | Granite Imports
Bardiglio | 14.5 | Granite Imports
Bianco Statuary | 29.5 | Granite Imports
Black and Gold | 28.5 | Granite Imports
[NAME] | 16.9 | Granite Imports
Calacatta | 49 | Granite Imports
Calacatta Crestola | 68.9 | Granite Imports
[NAME] | 49 | Granite Imports
Carrara Gioia | 16.5 | Granite Imports
Carrara Gold | 19.5 | Granite Imports
[NAME] | 13.9 | Granite Imports
[NAME] | 15.5 | Granite Imports
[NAME] | 15.5 | Granite Imports
Opera Fantastico | 48 | Granite Imports
Paonazzo |  | Granite Imports
Rainforest Brown | 15.5 | Granite Imports
Rainforest [NAME] (Riverwashed) | 18.5 | Granite Imports
Rainforest Green | 15.5 | Granite Imports
[NAME] | 14.95 | Granite Imports
[NAME] (Leathered) | 19.9 | Granite Imports
Statuary Supreme | 49 | Granite Imports
[NAME] | 38 | Granite Imports
White Carrara | 14.95 | Granite Imports
Venatino | 14.95 | Granite Imports
White Carrara (Honed) | 16.45 | Granite Imports
White Sky | 18.5 | Granite Imports
Spreadsheet: 114876d1310567056-pasting-a-formula-row-every-third-line-using-sort
Sheet: Sheet1

 | sort 1 | feb | march | april | may | unsort |  |  |  |  | feb | march | april | may
item a | deliveries | 10 | 10 | 120 | 10 | 1 |  |  | item a | deliveries | 10 | 10 | 120 | 10
item b | deliveries | 20 | 10 | 120 | 10 | 4 |  |  | stock | usage | 5 | 10 | 100 | 20
item c | deliveries | 10 | 10 | 120 | 10 | 7 |  |  | 10 | running total | 15 | 15 | 35 | 25
10 | running total | 20 | 20 | 20 | 20 | 3 |  |  | item b | deliveries | 20 | 10 | 120 | 10
10 | running total | 0 | -10 | 90 | 80 | 6 |  |  | stock | usage | 5 | 10 | 100 | 20
10 | running total | 30 | 60 | -10 | -70 | 9 |  |  | 10 | running total | 25 | 25 | 45 | 35
stock | usage | 5 | 10 | 100 | 20 | 2 |  |  | item c | deliveries | 10 | 10 | 120 | 10
stock | usage | 5 | 10 | 100 | 20 | 5 |  |  | stock | usage | 5 | 10 | 100 | 20
stock | usage | 5 | 10 | 100 | 20 | 8 |  |  | 10 | running total | 15 | 15 | 35 | 25
 | this table is sorted by sort 1 |  |  |  |  |  |  |  | This shows it with formula which enables me to make
 | formulas entered in c6:f6 |  |  |  |  |  |  |  | changes in the delivery row, and see the effect on running total
 | then dragged to c8:d8
 | now select a2 to g11
 | and sort by column g unsort
Spreadsheet: scott_neal__37892__STOR9805
Sheet: STOR951

ENRON CAPITAL & TRADE RESOURCES |  |  |  |  |  |  |  |  |  |  |  |  |  | Confidential - For Internal Use Only
STORAGE UPDATE |  |  |  |  |  |  |  |  |  |  |  |  |  |  | File: STOR9805
Below is a summary of the estimated storage working gas levels
for the week ending: |  |  | 2000-11-10 00:00:00
 |  | Gas In Stg | Gas in | Quantity | Percent | Percent |  |  |  |  | Last Year | Three | Five | Quantity | Quantity | Quantity
 |  | Prev Week | Storage | Change | Change | of Full |  |  |  |  | Same | Year | Year | Change From | Change From | Change From
U.S. Region |  | (Bcf) | (Bcf) | from last week | from last week | Capacity |  |  |  |  | Week | Average | Average | last year | 3 year avg. | 5 year avg.
Production Area |  | 687 | 688
(TX, LA, OK, KS, MS)
Market Area - East |  | 1678 | 1682
Market Area - West |  | 383 | 372
TOTAL U.S.
MONTH TO DATE
Enron Gas Services |  |  | 36.2 | 0 | 0 | 0.924 |  |  |  |  | ECTR is refilling [NAME] as third parties
(as of 1/20/95) |  |  |  |  |  |  |  |  |  |  |  |  |  | are withdrawing, this keeping our
 |  |  |  |  |  |  |  |  |  |  |  |  |  | total position flat for the week.
AGA FULL CAPACITY |  |  | 3294 |  |  |  |  |  |  |  |  |  |  | 3294 | 3294 | 3294
Maximum Gas In Stg Level (Bcf) |  |  | 3127 |  |  |  |  |  |  |  |  |  |  | 3127 | 2832 | 2915
Minimum Gas In Stg Level (Bcf) |  |  | 1335 |  |  |  |  |  |  |  |  |  |  | 1006 | 794 | 871
Spreadsheet: 600311d1543597693-help-with-a-formula-which-will-provide-a-value-after-two-text-cells-are-selected-sample-table
Sheet: Sheet1

 | UK | Spain | Mexico | India
Apple | 5 | 10 | 5 | 5
[NAME] | 10 | 5 | 5 | 5
[NAME] | 10 | 5 | 5 | 10
Melon | 10 | 10 | 5 | 5
[NAME] | 10 | 5 | 10 | 10
Spreadsheet: 115756d1311267080-sumif-and-lookups-based-on-months-book1
Sheet: Sheet1

DATE | COMPANIES | NATIONAL
2011-01-04 00:00:00 | NIIT | INDIA
2011-01-04 00:00:00 | NIIT | SRILANKA
2011-01-04 00:00:00 | NIIT | NEPAL
2011-01-05 00:00:00 | SATYAM | INDIA
2011-01-05 00:00:00 | SATYAM | NEPAL
2011-01-05 00:00:00 | SATYAM | BANGLADESH
2011-01-05 00:00:00 | NIIT | INDIA
2011-01-05 00:00:00 | NIIT | SRILANKA
2011-01-05 00:00:00 | NIIT | NEPAL
2011-01-06 00:00:00 | SATYAM | INDIA
2011-01-06 00:00:00 | SATYAM | NEPAL
2011-01-06 00:00:00 | SATYAM | BANGLADESH
2011-01-06 00:00:00 | NIIT | INDIA
2011-01-06 00:00:00 | NIIT | SRILANKA
2011-01-06 00:00:00 | NIIT | NEPAL
2011-01-06 00:00:00 | SATYAM | INDIA
2011-01-07 00:00:00 | SATYAM | NEPAL
2011-01-07 00:00:00 | SATYAM | BANGLADESH
2011-01-07 00:00:00 | NIIT | INDIA
2011-01-07 00:00:00 | NIIT | SRILANKA
2011-01-07 00:00:00 | NIIT | NEPAL
2011-01-07 00:00:00 | SATYAM | INDIA
2011-01-08 00:00:00 | SANKAR | INDIA
2011-01-08 00:00:00 | NIIT | NEPAL
2011-01-08 00:00:00 | NIIT | BANGLADESH
2011-01-08 00:00:00 | SATYAM | INDIA
2011-01-08 00:00:00 | SATYAM | SRILANKA
2011-01-08 00:00:00 | SANKAR | NEPAL
Spreadsheet: 843692d1695483858-create-unique-combinations-of-individuals-for-triads-book2
Sheet: Sheet1

Start | Select  1 | Remainder | Select  2 | Remainder | Select  3 | Remainder | Select  4 | Remainder | Select  5 | Remainder | Select  6 | Remainder | Select  7 | Remainder | Select  8 | Remainder | Select  9 | Remainder |  | Amanda
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Anna
Anna |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hope
Hope |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Keaton
Keaton |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rachelle
Rachelle |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tiffany
Tiffany
Result