tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 730994d1620102932-subtract-aggregate-of-row-between-columns-of-values-in-different-rows-expiration-example
Sheet: Sheet3

Analysis | Supplier | Item # | Item Description | Loacation | 2021-05-03 00:00:00 | 2021-05-04 00:00:00 | 2021-05-05 00:00:00 | 2021-05-06 00:00:00 | 2021-05-07 00:00:00 | 2021-05-08 00:00:00 | 2021-05-09 00:00:00 | 2021-05-10 00:00:00 | 2021-05-11 00:00:00 | 2021-05-12 00:00:00 | 2021-05-13 00:00:00 | 2021-05-14 00:00:00 | 2021-05-15 00:00:00 | 2021-05-16 00:00:00 | 2021-05-17 00:00:00 | 2021-05-18 00:00:00 | 2021-05-19 00:00:00 | 2021-05-20 00:00:00 | 2021-05-21 00:00:00 | 2021-05-22 00:00:00 | 2021-05-23 00:00:00
DOC | Supplier 1 | 1 | Widget 1 | Location #1 | 10.18181818181818 | 9.181818181818182 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20.38181818181818 | 19.38181818181818 | 18.38181818181818 | 17.38181818181818 | 16.38181818181818 | 15.38181818181818 | 14.38181818181817 | 7.999999999999993 | 6.999999999999993 | 5.999999999999993 | 4.999999999999993 | 3.999999999999993
Inventory | Supplier 1 | 1 | Widget 1 | Location #1 | 50 | 45.08928571428572 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 100.0892857142857 | 95.17857142857142 | 90.26785714285712 | 85.35714285714283 | 80.44642857142854 | 75.53571428571425 | 70.62499999999996 | 39.28571428571425 | 34.37499999999996 | 29.46428571428568 | 24.5535714285714 | 19.64285714285711
Forecast | Supplier 1 | 1 | Widget 1 | Location #1 | 4.910714285714286 | 4.910714285714286 | 4.910714285714286 | 4.910714285714286 | 4.910714285714286 | 4.910714285714286 | 4.910714285714286 | 4.910714285714286 | 4.910714285714286 | 4.910714285714286 | 4.910714285714286 | 4.910714285714286 | 4.910714285714286 | 4.910714285714286 | 4.910714285714286 | 4.910714285714286 | 4.910714285714286 | 4.910714285714286 | 4.910714285714286 | 4.910714285714286 | 4.910714285714286
Open POs | Supplier 1 | 1 | Widget 1 | Location #1 | 120 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 105 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Shrink | Supplier 1 | 1 | Widget 1 | Location #1 | 0 | 50 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Expected Shrink | Supplier 1 | 1 | Widget 1 | Location #1 | 0 | 40.17857142857143 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Open PO Expected Shrink Date | Supplier 1 | 1 | Widget 1 | Location #1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 120 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 105 | 0 | 0 | 0 | 0 | 0
Open PO Shrink Impact | Supplier 1 | 1 | Widget 1 | Location #1
BIS Date | Supplier 1 | 1 | Widget 1 | Location #1 |  |  |  |  |  |  |  |  |  | 2021-05-12 00:00:00
Spreadsheet: 160672d1339163988-copy-lines-to-another-tab-forumexample
Sheet: Manualy done

*** I copied all the data from loan data into this tab, sorted by "user date" then deleted the ones (manually) that were greater then "today()+60".
*** I would like this list to be generated automatically and dynamically as dates and data change.
 |  | Account | USER DATE
 |  | 1047 | 2009-07-03 00:00:00
 |  | 1045 | 2010-12-04 00:00:00
 |  | 1053 | 2011-01-11 00:00:00
 |  | 1028 | 2011-02-08 00:00:00
 |  | 1035 | 2011-04-06 00:00:00
 |  | 1010 | 2011-04-13 00:00:00
 |  | 1018 | 2011-04-27 00:00:00
 |  | 1006 | 2011-05-25 00:00:00
 |  | 1023 | 2011-06-12 00:00:00
 |  | 1004 | 2011-06-25 00:00:00
 |  | 1008 | 2011-09-14 00:00:00
 |  | 1024 | 2011-09-14 00:00:00
 |  | 1021 | 2011-09-28 00:00:00
 |  | 1014 | 2011-10-01 00:00:00
 |  | 1051 | 2011-10-15 00:00:00
 |  | 1036 | 2011-10-23 00:00:00
 |  | 1007 | 2011-10-29 00:00:00
 |  | 1001 | 2011-10-30 00:00:00
 |  | 1032 | 2011-12-15 00:00:00
 |  | 1052 | 2011-12-28 00:00:00
 |  | 1027 | 2012-01-04 00:00:00
 |  | 1031 | 2012-01-25 00:00:00
 |  | 1039 | 2012-01-25 00:00:00
 |  | 1038 | 2012-02-15 00:00:00
 |  | 1046 | 2012-05-10 00:00:00
 |  | 1003 | 2012-05-12 00:00:00
 |  | 1022 | 2012-06-07 00:00:00
 |  | 1025 | 2012-06-07 00:00:00
 |  | 1041 | 2012-06-07 00:00:00
 |  | 1011 | 2012-07-02 00:00:00
 |  | 1005 | 2012-07-07 00:00:00
 |  | 1026 | 2012-07-07 00:00:00
 |  | 1055 | 2012-07-14 00:00:00
 |  | 1037 | 2012-08-05 00:00:00
Spreadsheet: 74117d1274717988-excel-2007-need-a-formula-to-search-specific-worksheet-sample
Sheet: 8

SKU # | [NAME] | AMOUNT | CODE DATE | AMOUNT | CODE DATE | AMOUNT | CODE DATE | AMOUNT | CODE DATE | AMOUNT | CODE DATE | AMOUNT | CODE DATE |  | Total
12456 | Chicken | 1 | 2010-05-15 00:00:00 | 6 | 2010-05-16 00:00:00 | 11 | 2010-05-17 00:00:00
Spreadsheet: 01494541-9e36-47b7-a039-566011538187
Sheet: ODCs

Advertising and Integrated Marketing Solutions (AIMS )                                             7FCB-H2-07-0541-B                                                                                                 Page 2 of 4
Schedule 541 - Proposal Price List Preparation Spreadsheet (ODCs)
[NAME]:
Other Direct Costs (ODCs)
Products, Services and Labor acquired from a third party.  Other Direct Costs are established at Not-To-Exceed Amounts
SIN(s) PROPOSED | SUPPORT PRODUCT/ LABOR (ODCs) | COMMERCIAL PRICE EXCLUDING MARKUP | UNIT OF ISSUE (e.g. Hour, Task, Sq ft) | MOST FAVORED CUSTOMER (MFC) | COMMERCIAL MARKUP (%) | COMMERCIAL PRICE INCLUDING MARKUP | MARKUP OFFERED TO GSA (%)* | CEILING PRICE/RATE OFFERED TO GSA (excluding IFF) | CEILING PRICE/RATE OFFERED TO GSA (including IFF) | SUPPORTING INVOICE NUMBER
541-1000 | Photographer | 100 | Hourly | All Commercial Customers | 0.1 |  | 0.05 |  |  | 123456
Note: The table above is an example, for further instructions, see tab: |  |  |  | Enclosure B
* Note: ODCs are normally priced at actual cost (plus IFF), however, if your firm has a standard commercial markup and have documentation to demonstrate this markup relationship, the Government may allow a negotiated discounted markup rate. See Enclosure B for additional information.
Spreadsheet: 786425d1657189390-looking-for-formula-to-identify-several-duplicate-item-codes-and-change-price-to-highest-excel-sample-forum-xlookup-aligw
Sheet: Sheet1

ITEM | [NAME] | BUY | MARKUP | SELL | ITEM | [NAME] | BUY | MARKUP | SELL | ITEM | [NAME] | BUY | MARKUP | SELL
 | KOM HM 600-3 |  |  |  | KOM HM 100-2 |  |  |  |  | KOM P300-2
AF5 | OUTER AIR FILTER |  | 0.1 |  | AF7 | OUTER AIR |  | 0.1 |  | AF7 | OUTER AIR |  | 0.1
AF6 | AF6 |  | 0.1 |  | AF5 | INNER AIR |  | 0.1 |  | AF6 | AF6 |  | 0.1
 |  |  |  |  | AF6 | AF6 |  | 0.1 |  | AF5 | INNER AIR FILTER |  | 0.1 | 27.65
 |  |  |  |  | LOOKUP LIST (can be located anywhere, even on another worksheet)
 |  |  |  |  | AF5 | 20
 |  |  |  |  | AF6 | 30
 |  |  |  |  | AF7 | 40
Spreadsheet: john_zufferli__16709__HedgeSummary
Sheet: Sheet1

 | CONFIDENTIAL:  PPA - POWER AND GAS POSITIONS:
 |  |  |  |  |  |  |  |  | Current to | Hedgeable | Current |  | AECO
 |  |  |  |  | Power Price | Aeco Gas Price | Heat Rate | Jan 11/2001 | Beg. Year | Volume | Gas Hedges |  | Hedge
 |  | Power (MWh) | Discount Days | Power (MW) | ($/MWh) | ($[NAME]) | (GJ/MWh) | Heat Rates | HR Delta | (cont/day) | (cont/day) | % Hedged | (cont/day)
2002-01-01 00:00:00 | Cal 2002 |  |  |  |  |  |  | 14.25
2003-01-01 00:00:00 | Cal 2003 |  |  |  |  |  |  | 12.03
2004-01-01 00:00:00 | Cal 2004 |  |  |  |  |  |  | 8.9
2005-01-01 00:00:00 | Cal 2005 |  |  |  |  |  |  | 9.06
2006-01-01 00:00:00 | Cal 2006 |  |  |  |  |  |  | 7.5
2007-01-01 00:00:00 | Cal 2007 |  |  |  |  |  |  | 7.02
2008-01-01 00:00:00 | Cal 2008 |  |  |  |  |  |  | 7.09
2009-01-01 00:00:00 | Cal 2009 |  |  |  |  |  |  | 7.1
2010-01-01 00:00:00 | Cal 2010 |  |  |  |  |  |  | 7.14
2011-01-01 00:00:00 | Cal 2011 |  |  |  |  |  |  | 7.11
2012-01-01 00:00:00 | Cal 2012 |  |  |  |  |  |  | 7.08
2013-01-01 00:00:00 | Cal 2013 |  |  |  |  |  |  | 7.04
2014-01-01 00:00:00 | Cal 2014 |  |  |  |  |  |  | 7.03
2015-01-01 00:00:00 | Cal 2015 |  |  |  |  |  |  | 7
2016-01-01 00:00:00 | Cal 2016 |  |  |  |  |  |  | 7
2017-01-01 00:00:00 | Cal 2017 |  |  |  |  |  |  | 7
2018-01-01 00:00:00 | Cal 2018 |  |  |  |  |  |  | 7
2019-01-01 00:00:00 | Cal 2019 |  |  |  |  |  |  | 7
2020-01-01 00:00:00 | Cal 2020 |  |  |  |  |  |  | 7
 | Total
 | Note: Power position is 710MW * Availability factor (of 81-87%) - 9% transmission losses - hedges
Spreadsheet: 826311d1681922212-countif-formula-for-names-appearing-in-all-or-some-months-book2
Sheet: Sheet1

 | Digitar o Nome da Pessoa | Any 1 month | Any 2 months | All 3 months | Total
 | [NAME]
 | Name | Jan | Feb | March
 | [NAME] | 15200 | 6950 | 0
 | [NAME] | 37693 | 74303 | 80712
 | [NAME] | 366615 | 0 | 0
 | [NAME] | 4838 | 0 | 6048
 | [NAME] | 22805 | 0 | 0
 | [NAME] | 10207 | 0 | 0
 | [NAME] | 33377 | 0 | 0
 | [NAME] | 0 | 5 | 8
 | [NAME]
Spreadsheet: 157664d1337826231-simple-indicator-simple-example
Sheet: Sheet1

 | as | as |  | ERROR |  | as | as
 | df | df |  |  |  | df | df
 | ds | ds |  |  |  | ds | ds
 | sadf | sadf |  |  |  | sadf | sadf
 | sdf | sdf |  |  |  | sdf | sdf
 | 0 | dsf |  |  |  | as | dsf
 | dsf | dsf |  |  |  | dsf | dsf
 | dfsa | dfsa |  |  |  | dfsa | dfsa
 | dsf | dsf |  |  |  | dsf | dsf
 | dsf | dsf |  |  |  | dsf | dsf
 | dfsa | dfsa |  |  |  | dfsa | dfsa
 | 0 | 0 |  |  |  | 0 | 0
 | 0 | 0 |  |  |  | 0 | 0
 | 0 | 0 |  |  |  | 0 | 0
 | 0 | 0 |  |  |  | 0 | 0
Spreadsheet: 765055d1643137038-table-search-for-codes-glass-size-search-1-
Sheet: Glass Sizes

Prefix | Code | [NAME] | [NAME] |  | Prefix | Code | [NAME] | [NAME]
BDL | 3(66/98) |  |  |  | BDR | 33(78/60)
BDL | 33(78/60) |  |  |  | BDR | 34(94/60)
BDL | 34(94/60) |  |  |  | BDR | 35(114/60)
BDL | 35(114/60) |  |  |  | BDR | 81(78/75)
BDL | 81(78/75) |  |  |  | BDR | 82(78/95)
BDL | 82(78/95) |  |  |  | BDR | 85(94/75)
BDL | 85(94/75) |  |  |  | BDR | 86(94/95)
BDL | 86(94/95) |  |  |  | BDR | 86(94/95)
BDL | 89(114/75) |  |  |  | BDR | 89(114/75)
BDL | 90(114/95) |  |  |  | BDR | 93(134/75)
BDL | 93(134/75) |  |  |  | BDR | 94(134/95)
BDL | 94(134/95)
Spreadsheet: 43113fbd-ac04-478f-be12-cdeb6a2ed10b
Sheet: 7d

 | Swap Dealers/MSPs5 |  | Others
Product1 | Cleared2 | Uncleared | Cleared | Uncleared
Fixed-Float | 218836130 | 96955759 | 19794727 | 45312776
FRA | 94686140 | 9347676 | 7976520 | 3808723
OIS | 49817549 | 10912395 | 5711534 | 3932516
OTHER* | 10332864 | 68298024 | 1033951 | 19785029
TOTAL | 373672683 | 185513854 | 34516732 | 72839044
*OTHER variable includes the following products: Basis, Swaption, Cap/Floor, Debt Option, Exotic, Fixed-Fixed, and Inflation.
Spreadsheet: gerald_nemec__11501__122900 HPL
Sheet: Itinerary Ops

Itinerary for Houston Region Operations
Week of January 1 - 5, 2001
 | Monday | Tuesday | Wednesday | Thursday | Friday | Pager #
CHERRY, STEVE | Hoilday |  |  |  |  | (281) 490-1484
HARWELL, DANA | Hoilday | BH | BH | BH | BH | (281) 490-6874
KANTENBERGER, [NAME] | Hoilday | BH | [NAME] | [NAME] | [NAME] | (281) 665-3920
NEWMAN, [NAME] | Hoilday |  |  |  |  | (281) 264-9455
ROBINSON, DIANA | Hoilday | BH | BH | BH | BH | (281) 262-3167
SHERIDAN, BILL | Hoilday |  |  |  |  | (512) 902-1211
THOMPSON, CHARLIE | Hoilday | EB/BH | BH | BH | BH | (713) 608-1022
[NAME], ANNA | Hoilday | Corpus Office | Corpus Office | Corpus Office | Corpus Office | Office
BORDELON, ANJI | Hoilday | Corpus Office | Corpus Office | Corpus Office | Corpus Office | Office
JURECEK, [NAME] | Hoilday | Corpus Office | Corpus Office | Corpus Office | Corpus Office | (512) 844-2111
HOWELL, [NAME] | Hoilday |  |  |  |  | (800) 443-7243 PIN 006509
Spreadsheet: 0b75d1bb-9535-466d-a21a-ac1fd0d3b99d
Sheet: Sheet1

13-005 Request for Proposal for Custodial Services | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Company Name | Bid Proposal | Porter/Hour | Cleaning/Hour | Bond/Check
ISS Facility Services | 468629.71 | 14.28 | 22.75 | B
Regent Services | 334911.48 | 11.7 |  | B
UBM Enterprises | 342156 | 11 | 12.5 | B
Members Building Maintenance | 376704 | 9.84 | 11 | C
[NAME] | 285036 | 13 | 15 | C
HB Management Group | 391260.2 | 12.28 | 15.8
American Facility Servvices | 367800 | 12.5 | 12.5 | B
Able Building Maintenance | 545498.51 | 12.97 | 22.2 | B
Varsity Facility Services | 421414.3 | 13.26 | 15.35 | B
[NAME] of Dallas | 364860 | 12.75 | 12.75 | C
Professional Polish | 523620 | 15.5 | 15.5 | C
D&A Building Services | 351116.88 | $10.00/10.35 | 13.75 | C
Pruitt Building Services | 311100 | $10.50/12.00 | 14 | C
Oriental Building Services | 514305.54 | 11.45 | 16.25 | B
[NAME] | 440524.8 | 10.5 | 14.89 | C
Entrust One | 330889.88 | 12.53 | 13.5 | C
CTJ Maintenance Inc. | 325320 | 9 | 13.68 | C
Spreadsheet: 886378d1736418857-sum-based-on-variable-end-text-sum-based-on-variable-end-text
Sheet: Sheet1

 | P1 | P2 | P3 | P4 | P5 | P6 | P7 | P8 | P9 | P10 | P11 | P12 |  | Financial Year | Quarter | Period | Start Date | End Date
Value | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 |  |  | FY25 | Q1 | P1 | 2024-02-26 00:00:00 | 2024-03-31 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | FY25 | Q1 | P2 | 2024-04-01 00:00:00 | 2024-04-28 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | FY25 | Q1 | P3 | 2024-04-29 00:00:00 | 2024-05-26 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | FY25 | Q2 | P4 | 2024-05-27 00:00:00 | 2024-06-30 00:00:00
 | Required Total |  |  |  |  |  |  |  |  |  |  |  |  | FY25 | Q2 | P5 | 2024-07-01 00:00:00 | 2024-07-28 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | FY25 | Q2 | P6 | 2024-07-29 00:00:00 | 2024-08-25 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | FY25 | Q3 | P7 | 2024-08-26 00:00:00 | 2024-09-29 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | FY25 | Q3 | P8 | 2024-09-30 00:00:00 | 2024-10-27 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | FY25 | Q3 | P9 | 2024-10-28 00:00:00 | 2024-11-24 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | FY25 | Q4 | P10 | 2024-11-25 00:00:00 | 2024-12-29 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | FY25 | Q4 | P11 | 2024-12-30 00:00:00 | 2025-01-26 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | FY25 | Q4 | P12 | 2025-01-27 00:00:00 | 2025-02-23 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | FY26 | Q1 | P1 | 2025-02-24 00:00:00 | 2025-03-30 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | FY26 | Q1 | P2 | 2025-03-31 00:00:00 | 2025-04-27 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | FY26 | Q1 | P3 | 2025-04-28 00:00:00 | 2025-05-25 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | FY26 | Q2 | P4 | 2025-05-26 00:00:00 | 2025-06-29 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | FY26 | Q2 | P5 | 2025-06-30 00:00:00 | 2025-07-27 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | FY26 | Q2 | P6 | 2025-07-28 00:00:00 | 2025-08-24 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | FY26 | Q3 | P7 | 2025-08-25 00:00:00 | 2025-09-28 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | FY26 | Q3 | P8 | 2025-09-29 00:00:00 | 2025-10-26 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | FY26 | Q3 | P9 | 2025-10-27 00:00:00 | 2025-11-23 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | FY26 | Q4 | P10 | 2025-11-24 00:00:00 | 2025-12-28 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | FY26 | Q4 | P11 | 2025-12-29 00:00:00 | 2026-01-25 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | FY26 | Q4 | P12 | 2026-01-26 00:00:00 | 2026-02-22 00:00:00
Spreadsheet: 84162d1284149481-conditional-formatting-stock-market-test
Sheet: Sheet1

 | [NAME] | PPS | Activision | PPS | Sony | PPS | [NAME] | PPS | Company 5 | PPS | Company 6 | PPS | Company 7 | PPS | Company 8 | PPS | Company 9 | PPS | Company 10 | PPS
2010-09-10 00:00:00 |  |  |  |  |  |  | 1000 | 25.66 |  |  |  |  |  |  |  |  |  |  |  |  | BUY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SELL
2010-09-11 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BUY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SELL
2010-09-12 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BUY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SELL
2010-09-13 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BUY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SELL
2010-09-14 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BUY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SELL
2010-09-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BUY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SELL
2010-09-16 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BUY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SELL
2010-09-17 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BUY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SELL
2010-09-18 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BUY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SELL
2010-09-19 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BUY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SELL
2010-09-20 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BUY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SELL
Spreadsheet: 738f9a8a-4371-44f7-a386-fa77c56f7040
Sheet: Sheet1

Kingsland Community Church | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Budget vs Actual Year-to-Date Summary
July 2009 - February 2010
 | Total
 | Actual | Budget | $ Over Budget | % of Budget
Income
40000 General Purpose Income (not restricted use) | 118711.57 | 122560 | -3848.429999999993 | 0.9685996246736293
Total Income | 118711.57 | 122560 | -3848.429999999993 | 0.9685996246736293
Expenses
50000 General Purpose Expenses (for operations) | 121538.6 | 121625 | -86.39999999999418 | 0.9992896197327853
59000 Reimbursible Costs & (Reimb) [NOT BUDG] | 27.43 |  | 27.43
Total Expenses | 121566.03 | 121625 | -58.97000000000116 | 0.9995151490236382
Net Income | -2854.459999999992 | 935 | -3789.459999999992 | -3.052898395721916
Friday, Mar 12, 2010 01:26:27 PM GMT-6 - Accrual Basis
Spreadsheet: 070f5cc3-3ebf-4850-b52e-70cfbb1d9a7f
Sheet: 4.3

Table 4.3: Gross enrolment ratio in primary/basic education by nationality, country, sex and year (per cent)
Country | year | Nationals |  |  | Non-nationals |  |  | Total
 |  | Male | Female | Total | Male | Female | Total | Male | Female | Total
Iraq
 | 2010 | ... | ... | ... | ... | ... | ... | 113 | 101.3 | 107.4
 | 2011(1) | ... | ... | ... | ... | ... | ... | 116.5 | 105.4 | 111.1
Oman
 | 2005 | 100.1 | 99.5 | 99.8 | ... | ... | ... | ... | ... | ...
 | 2010 | 102.8 | 102.2 | 102.3 | ... | ... | ... | ... | ... | ...
Palestine
 | 2000 | ... | ... | ... | ... | ... | ... | 95.8 | 98 | 96.8
 | 2005 | ... | ... | ... | ... | ... | ... | 93.1 | 95.2 | 94.1
 | 2010 | ... | ... | ... | ... | ... | ... | 91.8 | 96.1 | 93.9
 | 2011 | ... | ... | ... | ... | ... | ... | 93.4 | 95.5 | 94.4
Qatar
 | 2000 | ... | ... | ... | ... | ... | ... | 85.1 | 103.4 | 93.1
 | 2005 | ... | ... | ... | ... | ... | ... | 93.2 | 99.4 | 96.1
 | 2010 | ... | ... | ... | ... | ... | ... | 102.1 | 104 | 103
 | 2011 | ... | ... | ... | ... | ... | ... | 99.4 | 99.1 | 99.3
Saudi Arabia
 | 2010 | ... | ... | ... | ... | ... | ... | 106.32 | 105.74 | 106.04
 | 2011 | ... | ... | ... | ... | ... | ... | 106.27 | 105.75 | 106.01
 | 2012 | ... | ... | ... | ... | ... | ... | 105.93 | 106.37 | 106.14
Yemen
 | 2000 | … | … | … | … | … | … | … | … | …
 | 2005 | 85.8 | 62.8 | 74.7 | … | … | … | 85.8 | 62.8 | 74.7
 | 2010 | 96.1 | 75.5 | 74.7 | … | … | … | 96.1 | 75.5 | 86.1
 | 2011 | 96.6 | 77.2 | 87.3 | … | … | … | 96.6 | 77.2 | 87.3
(1) Includes government and private.
Spreadsheet: 107600d1304712040-lookup-within-a-if-statement-copy-of-lookup-help-2
Sheet: Routing

[NAME] | PartNumber | Wc_Id | Machine Group | Part Number | Seq Nbr
1 | N123 |  | Cold Saw - Long Bar | N123 | 1
2 | N123 |  | Lathe6 | N123 | 2
3 | N123 |  | CNC GRIND4 | N123 | 3
4 | N123 |  | Inspection | N123 | 4
5 | N123 |  | Outsource (Plate) | N123 | 5
6 | N123 |  | Inspection | N123 | 6
7 | N123 |  | CNC GRIND4 | N123 | 7
8 | N123 |  | CNC GRIND5 | N123 | 8
9 | N123 |  | Inspection | N123 | 9
10 | W456 |  | Cold Saw - Long Bar | W456 | 1
11 | W456 |  | Lathe6 | W456 | 2
12 | W456 |  | CNC GRIND4 | W456 | 3
13 | W456 |  | Inspection | W456 | 4
14 | W456 |  | Outsource (Plate) | W456 | 5
15 | W456 |  | Inspection | W456 | 6
16 | W456 |  | CNC GRIND4 | W456 | 7
17 | W456 |  | CNC GRIND5 | W456 | 8
18 | W456 |  | Inspection | W456 | 9
19 | TEST1 |  | Lathe1 | TEST1 | 1
20 | TEST1 |  | [NAME] | TEST1 | 2
21 | TEST1 |  | Lathe3 | TEST1 | 3
22 | TEST1 |  | Lathe4 | TEST1 | 4
Spreadsheet: 544956d1509116917-conditionally-summing-across-a-varying-number-of-worksheets-copy-of-example-book-allisonns-
Sheet: Summary

 | Totals From Below
Year = | Check |  |  |  |  |  | <--------- | Takes the units on each tab on the date closest to the end of the calander year input on the summary sheet and sums them.
2016 | Difference
Tab# | Stock Name | Units Sold | Proceeds | Basis | Gain/Loss | Ending Units | [NAME]
1 | Stock 1 | 0 | 0 | 0 |  |  |  | Not the actual column references used but is exactly how the formulas are written on the summary sheet
2 | Stock 2 | -6512 | 22562 | 18962 |  |  |  | So the top level summary for this needs to sum all the maximum values after determining if it is the ending units column value or a number from the transaction
3 | Stock 3 | -5689 | 20496 | 20685 |  |  |  | column for each tab.
a4:i50 | a4 | g4:g50 | a4:a50
Spreadsheet: 110341d1307032855-excel-2007-macro-to-or-s-to-exsisting-cells-on-dif-pages-example-for-belayasila-v2
Sheet: Add

Item | Qty +
Item 1 | 0
Item 2 | 0
Item 3 | 0
Item 4 | 8
Item 5 | 0
Item 6 | 0
Item 7 | 4
Item 8 | 0
Item 9 | 0
Item 10 | 0
Spreadsheet: darrell_schoolcraft__7638__imball0201
Sheet: SoCal

 | 10487 |  | 56697
Day | Measured | Scheduled | Measured | Scheduled
1 | -492632 | -494656
2 | -501900 | -485325
3 | -540213 | -539549
4 | -472917 | -473220
5 | -501953 | -499242
6 | -549512 | -560014
7 | -525598 | -521371
8 | -534270 | -531085
9 | -607985 | -606773
10 | -588011 | -634161
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-12-31 00:00:00 |  |  |  |  | 104420
2002-01-10 00:00:00
CBS Dollars
 |  |  | 331917
Spreadsheet: jim_schwieger__14330__Schwieger
Sheet: Schwieger Summary 2

Account # | Category | 1995 | 1996 | 1997 | 1998 | 1999 | 2000
HS-66400-ES | Beginning Balance | 0 |  | 197350.79 | 234548.92 | 247578.93 | 383977.24
HM-00803-ES | Deposits, Transfers In, Rollovers | 178460.65 | 0 | 0 | 31084.55 | 85105.43 | 0
 | Withdrawals, Transfers Out | -11328.02 | -2856.77 | -4654.13 | -1956.44 | 0 | 0
 | Ending Balance | 170138.78 | 197350.79 | 234548.92 | 247578.93 | 383977.24 | 546364.8
 | Total Investment | 178460.65
 | Earnings
 | Return
Account # | Category | 1995 | 1996 | 1997 | 1998 | 1999 | 2000
HS-71708-ES | Beginning Balance | N/A | N/A | N/A | 0 | 40889.46 | 47915.31
HM-01185-ES | Deposits, Transfers In, Rollovers |  |  |  | 40000 | 0 | 0
 | Withdrawals, Transfers Out |  |  |  | 0 | 0 | 0
 | Ending Balance | N/A | N/A | N/A | 40889.46 | 47915.31 | 47441.47
 | Total Investment
 | Earnings
 | Return | N/A | N/A | N/A
Account # | Category | 1995 | 1996 | 1997 | 1998 | 1999 | 2000
HS-69167-ES | Beginning Balance | N/A | N/A | 0 | 6203.37 | 74955.03 | 98951.8
HM-00963-ES | Deposits, Transfers In, Rollovers |  |  | 7000 | 68350 | 21000 | 21500
 | Withdrawals, Transfers Out |  |  | -1400 | 0 | 0 | 0
 | Ending Balance | N/A | N/A | 6203.37 | 74955.03 | 98951.8 | 121080.46
 | Total Investment
 | Earnings
 | Return | N/A | N/A
Account # | Category | 1995 | 1996 | 1997 | 1998 | 1999 | 2000
HS-65130-ES | Beginning Balance | 0 | 3630.04 | 8737.74 | 6719.46 | 7207.35 | 76983.51
HM-00737-ES | Deposits, Transfers In, Rollovers | 55666.34 | 151734.74 | 98892.35 | 359071.95 | 133956.86 | 404057.21
 | Withdrawals, Transfers Out | -52165.75 | -147553.51 | -101388.33 | -348999.56 | -138472.03 | -384028.39
 | Ending Balance | 3630.04 | 8737.74 | 6719.46 | 7207.35 | 76983.51 | 119603.4
 | Total Investment
 | Earnings
 | Return
 | Index (Historical) | 1995 | 1996 | 1997 | 1998 | 1999 | 2000 ytd
 | S & P 500 | 0.3754 | 0.2323 | 0.3339 | 0.2874 | 0.2103 | -0.018
 | DJIA 30 | 0.3701 | 0.2891 | 0.2491 | 0.1816 | 0.2725 | -0.0332
 | NASDAQ Comp | 0.3993 | 0.227 | 0.2165 | 0.3962 | 0.8559 | -0.172
 | * Please note year 2000 figures are based on ytd ending Aug 31.