tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 714567d1611286233-custom-time-formatting-paybonusforefproperresults
Sheet: Sheet1

Working time | Needed Result | [NAME]
7:00:00 | 8:00:00
7:15:00 | 8:00:00
7:30:00 | 8:00:00
7:45:00 | 8:00:00
8:00:00 | 8:00:00
8:15:00 | 8:23:00
8:30:00 | 8:45:00
8:45:00 | 9:08:00
9:00:00 | 9:30:00
9:15:00 | 9:53:00
9:30:00 | 10:15:00
9:45:00 | 10:38:00
10:00:00 | 11:00:00
10:15:00 | 11:23:00
10:30:00 | 11:45:00
10:45:00 | 12:08:00
11:00:00 | 12:30:00
11:15:00 | 12:53:00
11:30:00 | 13:15:00
11:45:00 | 13:38:00
12:00:00 | 14:00:00
12:15:00 | 14:23:00
12:30:00 | 14:45:00
Spreadsheet: 13c5bb84-384c-4246-9837-98cdd7a605af
Sheet: JVS Section 3315.18

daria.shams:setaside_calculation_fy12.xlsx
Set-aside Calculation for FY 2012 Based on Provisions of Section 3315.18 of Sub. [NAME]
for Joint Vocational School Districts
(SORTED BY JVS)
 |  |  | STUDENT
 |  |  | POPULATION
 |  |  | USED IN | SET-ASIDE
 |  |  | CALCULATION | CALCULATION
IRN | JVS NAME | JVS COUNTY | OF SET-ASIDE | SECTION 3315.18
50773 | APOLLO JT VOC SD | [NAME] | 797.97
62042 | ASHLAND COUNTY-WEST HOLMES JT | Ashland | 303.02
50815 | ASHTABULA COUNTY JVS JT VOC SD | Ashtabula | 736.18
51169 | AUBURN JT VOC SD | Lake | 344.42
50856 | BELMONT-HARRISON JT VOC SD | Belmont | 472.69
51656 | [NAME] | Tuscarawas | 869.03
50880 | BUTLER TECH JT VOC SD | Butler | 3117.75
51201 | C-TEC JT VOC SD | Licking | 700.27
50906 | [NAME] COUNTY JT VOC SD | [NAME] | 328.36
65227 | COSHOCTON COUNTY JT VOC SD | Coshocton | 220.72
50922 | CUYAHOGA VALLEY JT VOC SD | Cuyahoga | 469.73
50989 | DELAWARE AREA CAREER CENTER JT | Delaware | 536.66
51003 | EASTLAND-FAIRFIELD CAREER/TECH | Franklin | 1259.15
51029 | EHOVE JT VOC SD | Erie | 741.11
50963 | FOUR COUNTY JT VOC SD | [NAME] | 986.41
62067 | GALLIA-JACKSON-VINTON JT VOC S | Gallia | 531.1
51060 | GREAT OAKS INST OF TECHNOLOGY | [NAME] | 3474.19
51045 | GREENE COUNTY JT VOC SD JT VOC | Greene | 718.81
51128 | JEFFERSON COUNTY JT VOC SD | [NAME] | 375.43
51144 | KNOX COUNTY JT VOC SD | Knox | 581.53
51185 | [NAME] | [NAME] | 651.66
51227 | LORAIN COUNTY JVS JT VOC SD | Lorain | 1180.7
51243 | MAHONING CO CAREER & TECH CTR | Mahoning | 635.17
51391 | MAPLEWOOD CAREER CENTER JT VOC | Portage | 689.78
62109 | MEDINA COUNTY JVSD JT VOC SD | Medina | 1049.41
51284 | MIAMI VALLEY CAREER TECH JT VO | Montgomery | 2008.78
51300 | MID-EAST CAREER & TECH CENTERS | Muskingum | 1070.3
51334 | OHIO HI-POINT JT VOC SD | Logan | 801.18
51359 | PENTA JT VOC SD | Wood | 1949.97
51433 | PICKAWAY-ROSS JVSD JT VOC SD | [NAME] | 1044.34
51375 | PIKE COUNTY AREA JT VOC SD | Pike | 439.92
51417 | PIONEER CAREER & TECHNOLOGY JT | Richland | 1270.42
50948 | POLARIS JT VOC SD | Cuyahoga | 630.47
63495 | PORTAGE LAKES JT VOC SD | Summit | 386.77
51490 | SCIOTO COUNTY CTC JT VOC SD | Scioto | 456.84
50799 | [NAME] | [NAME] | 367.26
51532 | SPRINGFIELD-CLARK COUNTY JT VO | [NAME] | 727.14
62026 | STARK COUNTY AREA JT VOC SD | [NAME] | 700.95
63511 | TOLLES JT VOC SD | [NAME] | 591.14
51607 | TRI-COUNTY CAREER CENTER JT VO | Athens | 486.45
65268 | TRI-RIVERS JT VOC SD | Marion | 643.71
51631 | TRUMBULL CAREER & TECH CTR JT | Trumbull | 978.99
62802 | U S GRANT JT VOC SD | Clermont | 301.01
62125 | UPPER VALLEY JT VOC SD | Miami | 1054.45
51458 | VANGUARD-SENTINEL JT VOC SD | Sandusky | 1083.22
51672 | VANTAGE JT VOC SD | Van Wert | 552.28
51474 | WARREN COUNTY JT VOC SD | [NAME] | 921
51698 | WASHINGTON COUNTY JT VOC SD | Washington | 463.69
51714 | WAYNE COUNTY JVSD JT VOC SD | Wayne | 781.8
Spreadsheet: 751096d1633871440-formula-to-calculate-amount-based-on-drop-list-budget-d-etaf
Sheet: Summary

 | Budget Summary
 | Category Title | March | April | May | June | July | August | September | October | November | December | January | Febuary | TOTAL
 | Advertising and promotion
 | Bank Charges |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Insurance |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Office Rent |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Cleaning material
 | Fuel and oil
 | Stationery
 | Salary
 | [NAME]
 | Material
 | Phase or Category Title
Spreadsheet: 03b6c791-33c2-446a-a9d0-ce1e74da02eb
Sheet: July 2013

Spend over £25,000 - Publication template
Department family | Entity | Date | Expense type | Expense area | Supplier | Transaction number | Amount
DCMS | SMG | 2013-07-04 00:00:00 | Insurance | NMeM Brand | S-Tech Insurance Services Ltd | 178269 | 28000
DCMS | SMG | 2013-07-04 00:00:00 | Insurance | NMeM Brand | S-Tech Insurance Services Ltd | 178271 | 257167.54
DCMS | SMG | 2013-07-04 00:00:00 | Rates (CILOR) | Science Museum Estates | Royal Borough of Kensington & Chelsea | 178276 | 48707
DCMS | SMG | 2013-07-04 00:00:00 | Security | NMeM Brand | [NAME] | 178314 | 166425
DCMS | SMG | 2013-06-25 00:00:00 | Build Construction | National MPG | Elmwood (Glasgow) Ltd | 178344 | 152408.95
DCMS | SMG | 2013-07-18 00:00:00 | Electricity | Science Museum Estates | Natural History Museum | 178411 | 51080.81
DCMS | SMG | 2013-07-04 00:00:00 | Security | NMeM Brand | [NAME] | 178486 | 36538
DCMS | SMG | 2013-07-04 00:00:00 | Security | NMeM Brand | [NAME] | 178487 | 38235
DCMS | SMG | 2013-07-18 00:00:00 | Build Construction | NMeM Brand | TTS Interiors Limited | 178567 | 26745.19
DCMS | SMG | 2013-07-04 00:00:00 | Security | NMeM Brand | [NAME] | 178643 | 166425
DCMS | SMG | 2013-07-02 00:00:00 | Build Construction | RETAIL LAUNCHPAD | [NAME] | 178644 | 29407
DCMS | SMG | 2013-07-04 00:00:00 | Insurance | NMeM Brand | S-Tech Insurance Services Ltd | 178817 | 28100.6
DCMS | SMG | 2013-07-18 00:00:00 | Maintenance | Science Museum Estates | Cofely Limited | 178850 | 29409.47
DCMS | SMG | 2013-07-18 00:00:00 | Build Construction | National MPG | Elmwood (Glasgow) Ltd | 179099 | 340200.19
DCMS | SMG | 2013-07-18 00:00:00 | Maintenance | NMeM Brand | Honeywell Controls Ltd | 179178 | 89942
DCMS | SMG | 2013-07-18 00:00:00 | Maintenance | NMeM Brand | Honeywell Controls Ltd | 179229 | 82858
DCMS | SMG | 2013-07-18 00:00:00 | Build Construction | ScM Major projects | Parkeray Ltd | 179230 | 216669.06
DCMS | SMG | 2013-07-18 00:00:00 | Rent | Science Museum Estates | The British Museum | 179455 | 45622.21
DCMS | SCMGE | 2013-07-02 00:00:00 | [NAME] | Visitor Related | IMAX Corporation | 125257 | 42760.94
DCMS | SCMGE | 2013-07-25 00:00:00 | Maintenance | Visitor Related | IMAX Corporation | 126059 | 34464.23
Spreadsheet: 811553d1672643757-sum-formula-change-range-with-value-input-sum-functin
Sheet: Sheet1

1 | 1 | 1 | 1 | 1 |  | B2 | =SUM(A2:G2)
1 | 1 | 1 | 1 | 1 |  | [NAME] | =SUM(A3:G3)
1 | 1 | 1 | 1 | 1 |  | D4 | =SUM(A3:G4)
1 | 1 | 1 | 1 | 1 |  | E5 | =SUM(A3:G5)
 |  |  |  |  | X
1 | 1 | 1 | 1 | 1 | =SUM(A8:X) | if i change X, all the formulas should change there range to A, B, C, D or E...
1 | 1 | 1 | 1 | 1 | =SUM(A9:X)
1 | 1 | 1 | 1 | 1 | =SUM(A10:X)
1 | 1 | 1 | 1 | 1 | =SUM(A11:X)
Spreadsheet: 05fe99ce-2e3e-4653-8480-92c54b45c2f3
Sheet: 8. Buildings

 | FY 2012 Federal Real Property Charts
 | Buildings†
 | Agency | Owned Building Assets** | Owned Gross Square Feet** | Owned Annual Operating Costs** | Leased Building Assets | Leased Gross Square Feet | Leased Annual Costs*
 | Agriculture | 21461 | 41866079 | 355123274.3500001 | 3381 | 16189683 | 268593318.68
 | Air Force*** | 50067 | 533753345 | 2598791507.89 | 4806 | 60532504 | 367232889.748
 | Army*** | 87220 | 778988434.661 | 2593773999.273 | 15947 | 126037831.07 | 605976148.041
 | Commerce | 534 | 7778153 | 65524870 | 196 | 1245707 | 29071942.63
 | Corps of Engineers*** | 930 | 11110545.04 | 37277029 | 126 | 793137 | 11712360
 | Defense/WHS*** | 105 | 8269208.04 | 38938878.382 | 0 | 0 | 0
 | Energy | 10559 | 115987780 | 1789506154 | 53 | 951946 | 18715284
 | Environmental Protection Agency | 168 | 4154185 | 43442470.54000001 | 3 | 201983 | 15446026.91
 | General Services Administration | 1574 | 225324610.47 | 1147790603.809999 | 7134 | 197507674.75 | 5166233662
 | Health and Human Services | 2744 | 31984266.678 | 398318909.053 | 91 | 2612347.9 | 83729224.369
 | Homeland Security | 9904 | 42684522.15 | 354362881.04 | 557 | 7074779.35 | 114912049.19
 | Interior | 43194 | 103366559.6 | 460523876.318 | 360 | 3806349 | 63763304.778
 | Justice | 3883 | 70676317 | 530888633.1 | 49 | 1095152 | 16366658
 | Labor | 2104 | 22020973 | 100837139.25 | 297 | 3320437 | 25577041.721
 | National Aeronautics And Space Administration | 2476 | 46052705 | 396503877 | 11 | 939886 | 6990994
 | National Science Foundation | 388 | 2970741.14 | 28973634.35 | 12 | 189896 | 2679393.2
 | Navy*** | 49009 | 492213223.8100001 | 3308721971.976 | 4396 | 55563458.51 | 580047639.055
 | Office of Personnel Management | 0 | 0 | 0 | 4 | 81437 | 1087000
 | State | 4066 | 42689456 | 412232106.6300001 | 13440 | 39130678 | 896715348.04
 | State (USAID) | 100 | 1058844 | 7490968.049999997 | 1550 | 4646063 | 83988697.53
 | Transportation | 9782 | 19161242.25 | 254713930.64 | 1092 | 6751893 | 116929220.137
 | Treasury | 11 | 4088647 | 71659430.00000001 | 107 | 2697443 | 72651500.54
 | Veterans Affairs | 5887 | 149357331 | 781061448.17 | 1540 | 14799632 | 256765488.61
 | Total |  |  | 15776457592.822
 | † All real property data from the CFO Act agencies required to submit data to the FRPP
 | *Includes operations and maintenance costs and rent
 | **includes federal government owned, foreign government owned, museum trust, state government owned
 | *** Department of Defense
Spreadsheet: kate_symes__18316__04-09
Sheet: Sheet2

DATE | FERC FILE | SERVICE CUST | HR BEG | HR END | TOTAL HRS | DEL PT | SUPPLY | MW PER HR | TOTAL MW | SCHEDULE ID | SELL PRICE
2001-04-09 00:00:00 |  |  | 1 | 1 | 1 | SP15 | EES | 17 | 17 |  | 80 | SOLD
2001-04-09 00:00:00 |  |  | 3 | 3 | 1 | SP15 | EES | 20 | 20 |  | 80 | SOLD
2001-04-09 00:00:00 |  |  | 4 | 4 | 1 | SP15 | EES | 1 | 1 |  | 80 | SOLD
2001-04-09 00:00:00 |  |  | 5 | 5 | 1 | SP15 | EES | 18 | 18 |  | 90 | SOLD
2001-04-09 00:00:00 |  |  | 6 | 6 | 1 | SP15 | EES | 10 | 10 |  | 80 | SOLD
2001-04-09 00:00:00 |  |  | 7 | 7 | 1 | SP15 | EES | 21 | 21 |  | 90 | SOLD
Spreadsheet: 160476d1339090903-excel-2007-index-with-duplicates-department-updates-and-announcements
Sheet: All

Announcement Number | Employee Announcements
All1
All2
All3
All4
All5
All6
Announcement Number | Manager [NAME]
All1manager
All2manager
All3manager
All4manager
All5manager
All6manager
Spreadsheet: 148820d1333564792-creating-a-table-of-distributors-example-5-
Sheet: Sheet1

Name | Product Type |  |  | Choose product type | EMC
[NAME] | EMC
[NAME] | VMW |  |  | Name ->
[NAME] | MSFT
[NAME] | RVBD
[NAME] | EMC
abc | FFIV
pat | EMC
def | FTNT
Spreadsheet: 327679d1403641241-unable-to-determine-logical-statemment-for-conditional-formatting-maxarray-1-
Sheet: Sheet1

 |  |  |  | Agent | Operation | [NAME]
 |  |  |  | File_Server | Replication Job
 |  |  |  | FileServer | Transfer Job
 |  |  |  | File_Server | Transfer Job
 |  |  |  | WX64STD-DEMO-1- | Export Job
 |  |  |  | ICEEX | Mountability Check Job
 |  |  |  | ICEEX | Transfer Job
 |  |  |  | WX64STD-DEMO-1- | Transfer Job
 |  |  |  | Ubuntu Test | Export Job
 |  |  |  | Ubuntu Test | Transfer Job
 |  |  |  | Exchange_Server | Mountability Check Job
 |  |  |  | Exchange_Server | Transfer Job
 |  |  |  | WX64STD-DEMO-2- | Transfer Job
 |  |  |  | win-ulh3dog5plb | Export Job
 |  |  |  | WIN-DAPNK3R40LM | Replication Job
 |  |  |  | win-ulh3dog5plb | Transfer Job
 |  |  |  | WIN-DAPNK3R40LM | Transfer Job
 |  |  |  | ICESQL | Transfer Job
 |  |  |  | ICESQL | Check Agent Recovery Points Job
 |  |  |  |  | [NAME]
Spreadsheet: 882523d1730910899-input-1-to-maybe-7-sku-numbers-to-return-groups-of-rows-find-groups-with-components
Sheet: Sheet1

Case SKU | Material description | Component | Material description | Ratio
9800001245 | ASTMNTS CRL SHPR X48 | [PHONE] | ASTMNTS CRL 8.56OZX12 | 48
123456789 | ASTMNTS 240CT | 9800006353 | Red | 80
 |  | 9800006357 | Blue | 80
 |  | 9800006356 | Yellow | 40
 |  | 9800008635 | Green | 40
9800033873 | ASTMNTS X276 | 9800015503 | Purple | 276
9800056677 | ASTMNTS X216 | 9800030528 | teal | 216
9800028774 | ASTMNTS X288 | 9800015535 | orange | 288
9800078993 | ASTMNTS X36 | 9800019446 | beige | 36
9800063993 | ASTMNTS  X144 | 9800023584 | white | 144
987654321 | ASTMNTS 960ct | 9800006353 | Red | 320
 |  | 9800006357 | Blue | 320
 |  | 9800006356 | Yellow | 160
 |  | 9800008635 | Green | 160
986271658 | ASTMNTS X33 | 9862540320 | crunch | 15
 |  | 9862775537 | space | 18
9862710566 | ASTMNTS X36 | 9864121325 | nature | 18
 |  | 9862710138 | butter | 18
9862781065 | ASTMNTS RX33 | 9867770325 | grass | 18
 |  | 9801126984 | fiber | 32
9800028932 | ASTMNTS X156 | 9804423144 | flake | 72
 |  | 9804427010 | giant | 84
654321987 | ASTMNTS CRL 120CT | 9800006353 | Red | 40
 |  | 9800006357 | Blue | 40
 |  | 9800006356 | Yellow | 20
 |  | 9800008635 | Green | 20
9800024446 | ASTMNTS X36 | 9805523856 | snack | 18
 |  | 9800445403 | snacks | 18
Spreadsheet: richard_sanders__31745__Tick Analysis @ 14-Nov-00
Sheet: Brazos' i Adjustment

[NAME]
Brazos' Interest Rate Adjustment
(Dollars in Thousands)
THIS INFORMATION IS CONFIDENTIAL PER SECTION 5 OF THE FACILITATION AGREEMENT
 |  |  | 1997 | 1998 | 1999 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019
Chase Manhattan
Yearly Principal Repayment % |  |  |  |  |  | 0.0225 | 0.0275 | 0.0275 | 0.0325 | 0.0375 | 0.0425 | 0.0475 | 0.1071 | 0.1253 | 0.1167 | 0.1339 | 0.1555 | 0.08650000000000001 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Quarter 1 Principal Repayment |  |  | 0
Quarter 2 Principal Repayment |  |  | 0
Quarter 3 Principal Repayment |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Quarter 4 Principal Repayment |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Quarter 1 Debt Balance
Quarter 2 Debt Balance
Quarter 3 Debt Balance
Quarter 4 Debt Balance
COBANK
Yearly Principal Repayment % |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.164284 | 0.18 | 0.197144 | 0.218572 | 0.24 | 0 | 0 | 0
Quarter 1 Principal Repayment |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Quarter 2 Principal Repayment |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Quarter 3 Principal Repayment
Quarter 4 Principal Repayment
Quarter 1 Debt Balance
Quarter 2 Debt Balance
Quarter 3 Debt Balance
Quarter 4 Debt Balance
Total (CHASE & COBANK)
Quarter 1 Debt Balance | Days: | 90
Quarter 2 Debt Balance |  | 91
Quarter 3 Debt Balance |  | 92
Quarter 4 Debt Balance |  | 92
Average Annual Unpaid Principal
Interest Rate Adjustment
Per This Worksheet |  | $/kW-mo.
Per Schedule 11.02 of PPA |  | $/kW-mo. | 1.2 | 1.19 | 1.18 | 1.17 | 1.15 | 1.13 | 1.11 | 1.09 | 1.06 | 1.03 | 0.98 | 0.9 | 0.82 | 0.74 | 0.64 | 0.53 | 0.4 | 0.3 | 0.19 | 0.08 | 0 | 0 | 0
Difference
Variables Used in Calculation
Amortization A (Construction Loan) |  | 80300
Amortization B (Construction Loan) |  | 70000
Treasury Bond Rate at "Financial Close" |  | 0.07802
Index Rate |  | 0.061
Factor 1 - Annual Billing Units, MW =
Factor 2 - Coverage Ratio |  | 1
Spreadsheet: 723974d1615978872-creating-a-new-list-based-on-criteria-in-existing-column-and-map-new-columns-to-it-excel-dummy-data
Sheet: Input needed

 | Starting point (data is organized as below, in a living document with multiple users)
 |  |  | Timeframe | May | May | April | April | May | April | May | April | April | April
 | Property | Property type |  | Buyer 1 | Buyer 2 | Buyer 3 | Buyer 4 | Buyer 5 | Buyer 6 | Buyer 7 | Buyer 8 | Buyer 9 | Buyer 10
 | Property 1 | Mansion |  | x |  | x |  | x |  |  |  | x
 | Property 2 | Mansion
 | Property 3 | Apartment |  |  |  |  |  |  | x |  | x |  | x
 | Property 4 | Penthouse |  |  | x
 | Property 5 | Country house |  |  | x |  |  | x
 | Property 6 | Mansion |  |  |  |  |  |  |  | x |  | x
 | Property 7 | Apartment |  |  | x |  | x |  |  | x
 | Property 8 | Apartment
 | Property 9 | Apartment |  |  |  |  |  |  |  | x
 | Property 10 | Country house |  |  |  | x |  |  |  |  | x
 | Output should look like this (in new sheet):
 |  | Property | Buyers April | Buyers May | Interested buyers ->
 | Apartment | Property 3 | 2 | 2 | Buyer 1 | Buyer 3 | Buyer 5 | Buyer 9
 | Apartment | Property 7 | 1 | 2 | Buyer 2 | Buyer 4 | Buyer 7
 | Apartment | Property 8 | 0 | 0
 | Apartment | Property 9 | 0 | 1 | Buyer 7
Spreadsheet: 96356d1295766735-listing-of-selective-data-copying
Sheet: Sheet1

 |  |  | Source list
 |  |  | Name | Amt | Del. | INV. | Open | Diff.
blank rows contain details
that add up to the total
on this line |  |  | abc | 68136.2 | 2010-01-07 00:00:00 | 656 | 7.275957614183426e-11 | 614
these details are not relevant
for making the target list
 |  |  | abc | 77515.19 | 2010-01-30 00:00:00 | 660 | 0 | 698.31
 |  |  | def | 9800 | 2010-01-30 00:00:00 |  | 0
 |  |  | mno | 16452.78 | 2010-07-05 00:00:00 | 655 | 7.457856554538012e-11 | 170.66
 |  |  | ghi | 151911.6 | 2010-03-13 00:00:00 | 668 | 151911.6
 |  |  | abc | 122986.64 | 2010-03-10 00:00:00 | 667 | -3.492459654808044e-10 | 1107.98
 |  |  | mno | 43946.97 | 2010-04-07 00:00:00 | 676 | -1.164153218269348e-10 | 443.91
 |  |  | ghi | 107195.04 | 2010-06-07 00:00:00 | 686 | 4.365574568510056e-11
 |  |  | mno | 15016.32 | 2010-06-02 00:00:00 | 685 | 0 | 151.68
 |  |  | abc | 57672.22 | 2010-07-22 00:00:00 | 694 | -1.891748979687691e-10 | 662.42
 |  |  |  |  |  |  |  |  | i can do the
Target list |  |  |  |  |  |  |  |  | =SUMIF(D4:D37, "abc", I4:I37)'
 |  |  |  |  |  |  |  |  | but need to list the items that
Name | Amt | INV. | Diff. |  |  |  |  |  | make up that total
abc | 68136.2 | 656 | 614
abc | 77515.19 | 660 | 698.31
abc | 122986.64 | 667 | 1107.98
abc | 57672.22 | 694 | 662.42
selective data is copied to the target list if there is a number in
the Diff. column of the source list, AND the customer is abc.
A simple formula is desirable. If listing only selected parts makes
it too complicated, the whole range can be copied and the unneeded
portions manually deleted.
Spreadsheet: 66171d1266874903-excel-2007-manipulation-of-cell-references-example
Sheet: Day by Day

 |  | SMITH | HOWARD | JONES | [NAME] | HARRISON
January | 1st | P | P | P | P | P
 | 2nd | P | P | P | P | P
 | 3rd
 | 4th
 | 5th | S | H | P | P | P
 | 6th | P | H | P | P | P
 | 7th | P | H | P | P | P
 | 8th | P | H | P | P | P
 | 9th | P | H | P | P | P
 | 10th
 | 11th
 | 12th | P | P | P | P | P
 | 13th | P | P | P | P | P
 | 14th | P | P | P | P | P
 | 15th | S | P | H | P | P
 | 16th | P | P | P | P | P
 | 17th
 | 18th
 | 19th | P | P | P | P | P
 | Present
 | Holiday
 | Sick
Spreadsheet: 35abdba6-b5fb-4015-bce4-0fb3220fbc44
Sheet: Sheet1

Date | Sport | Opponent | Time | Results
08/30/2014 | Football | vs. Alabama (Chick-fil-A Kickoff Game) | 03:30 PM | L, 23-33
09/06/2014 | Football | Towson | 07:30 PM | W, 54-0
09/13/2014 | Football | at Maryland | 12:00 PM | W, 40-37
09/20/2014 | Football | Oklahoma* | 07:30 PM | 7:30 pm
10/04/2014 | Football | Kansas* | 12:00 AM | TBA
10/11/2014 | Football | at Texas Tech* | 12:00 AM | TBA
10/18/2014 | Football | Baylor* | 12:00 AM | TBA
10/25/2014 | Football | at Oklahoma State* | 12:00 AM | TBA
11/01/2014 | Football | TCU* | 12:00 AM | TBA
11/08/2014 | Football | at Texas* | 12:00 AM | TBA
11/20/2014 | Football | Kansas State* | 07:00 PM | 7 p.m.
11/29/2014 | Football | at Iowa State* | 12:00 AM | TBA
Spreadsheet: 791994d1660685043-countifs-multiple-criteria-and-date-has-to-be-15th-of-the-month-example
Sheet: Sheet1

Status | Type | Signed Date |  |  | JULY | AUGUST
WIP | Cash | 2022-07-01 00:00:00
WIP | Cash | 2022-07-02 00:00:00
Completed | Cash | 2022-07-03 00:00:00
Completed | Cash | 2022-07-04 00:00:00
Completed | Cash | 2022-07-05 00:00:00
Completed | Cash | 2022-07-06 00:00:00
Completed | Cash | 2022-07-07 00:00:00
Completed | Cash | 2022-07-08 00:00:00
Completed | Cash | 2022-07-09 00:00:00
Completed | Cash | 2022-07-10 00:00:00
Completed | Cash | 2022-07-11 00:00:00
Completed | Cash | 2022-07-12 00:00:00
Completed | Amortised | 2022-07-13 00:00:00
Completed | Amortised | 2022-07-14 00:00:00
Completed | Amortised | 2022-07-15 00:00:00
Completed | Amortised | 2022-07-16 00:00:00
WIP | Amortised | 2022-07-17 00:00:00
WIP | Amortised | 2022-07-18 00:00:00
WIP | Cash | 2022-07-19 00:00:00
WIP | Cash | 2022-07-20 00:00:00
Completed | Amortised | 2022-07-21 00:00:00
Completed | Amortised | 2022-07-22 00:00:00
Completed | Amortised | 2022-07-23 00:00:00
Completed | Amortised | 2022-07-24 00:00:00
WIP | Amortised | 2022-07-25 00:00:00
WIP | Amortised | 2022-07-26 00:00:00
WIP | Amortised | 2022-07-27 00:00:00
WIP | Amortised | 2022-07-28 00:00:00
WIP | Amortised | 2022-07-29 00:00:00
WIP | Amortised | 2022-07-30 00:00:00
WIP | Amortised | 2022-07-31 00:00:00
WIP | Amortised | 2022-08-01 00:00:00
WIP | Amortised | 2022-08-02 00:00:00
WIP | CASH | 2022-08-03 00:00:00
WIP | Cash | 2022-08-04 00:00:00
WIP | Cash | 2022-08-05 00:00:00
Spreadsheet: chris_germany__1996__6-24-02 Gas Cash
Sheet: Log

5 Day Rolling Cash Forecast:  Payment Log as of Jun-24-02
Payment Date | Amount | Deal Name | Counterparty | Commercial Contact | Transaction Description
2002-06-28 00:00:00 | -1892.15 | [NAME] | Natural Gas Pipeline Company | [NAME] | Phys | Cash requested 6/20/02. Note that the payment date has been changed.
2002-06-25 00:00:00 | 1280619.23 | City of Tallahassee | City of Tallahassee | C hris Germany | Phys | Payment for May swing and baseload gas.
2002-06-28 00:00:00 | -2371234.02 | Citrus | Citrus | [NAME]/[NAME] | Phys | Payment related to gas purchases.  Payment day changed, and will keep being pushed back until further notice.
Spreadsheet: 7b2ac468-4c80-45fe-b89a-6d5983ee5901
Sheet: Sheet1

[NAME] | Unnamed: 1
Quelle: http://ergebnisse.vimentis.ch/
Frage:
Ich bin bereit, länger zu arbeiten, damit meine [NAME] ist.
 | Stadt/Land
Antwort
Ja
Neutral / Weiss nicht
[NAME]
Angaben zu den [NAME]
Erhebungsjahr | 2011
Stichprobengrösse | 30565
Erhebungszeitraum | 05.11.2011 bis: 30.12.2011
[NAME] | [NAME]
Methodik / Repräsentativität
Um soziodemographische Verzerrungen [NAME], wurden sämtliche [NAME] nach [NAME], Alter, Bildung und Region gemäss der wahren [NAME] älter als 15 Jahre gewichtet. Es bleibt eine psychographische Verzerrung wegen
der [NAME] über das Internet, welche nicht korrigiert [NAME]. Diese Verzerrung wird anhand einzelner [NAME] für jede [NAME] abgeschätzt. Demnach sind [NAME] auf dieser Seite angegebenen [NAME] mit einer
Präzision von &plusmn;2% [NAME].
[NAME] und [NAME] auf dieser Seite dürfen unter Angabe der Quelle weiterverwendet werden.
Spreadsheet: 08bfa04e-5096-4f92-b9b0-b9c598b8561b
Sheet: Sheet1

Actavis, Inc. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
8-K
01/08/2013
WATSON PHARMACEUTICALS, INC.
Nevada |  | 001-13305 |  | 95-3872914
(State or other Jurisdiction |  | (Commission |  | (IRS Employer
of Incorporation) |  | File Number) |  | Identification Number)
Morris Corporate Center III |  |  |  | 7054
400 Interpace Parkway
Parsippany, New Jersey
(Address of principal executive offices) |  |  |  | (Zip Code)
____________________________
Created by Morningstar Document Research.
http://documentresearch.morningstar.com/
Spreadsheet: 878721d1725979019-referencing-multiple-sheet-inorder-to-create-pt-pl-1-
Sheet: Pivot Table

Sheet Name > | Lux
Subject > | Math
 |  |  |  |  |  |  | Another way:
 |  |  |  |  |  |  | First convert the data into tables, naming the tables "Lux" and "[NAME]" respectively
 | Joshep |  |  |  |  |  | Then apply these formulas:
 | Aline |  |  |  |  |  | Name: =UNIQUE(INDIRECT(B1&"[Name]"))
 | [NAME] |  |  |  |  |  | Marks: =SUMIFS(INDIRECT(B1&"[Marks]"),INDIRECT(B1&"[Name]"),E5#,INDIRECT(B1&"[Subject]"),B2)