tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 693151d1598805923-excel-formula-function-help-needed-mock-up
Sheet: Final Report

Member SSN | Old Network | Old Account | Old Group | Old ID | Old Code | New Network | New Account | New Group | New ID | New Code | First Name | Last Name | Gender | DOB | OLD From Date | Old Thru Date | New From Date | New Thru Date
(Duplicates from column A need to be eliminated, I know we can use the data tools to eliminate)
Spreadsheet: 751096d1633871440-formula-to-calculate-amount-based-on-drop-list-budget-d-etaf
Sheet: April

 | March Transactions
 | Date: | Ref No.: | Payee | Description | Category | AMOUNT
 | 10/10/2021 | 1 | hhh200 | hhh200 | Insurance | 1200
 | 10/10/2021 | 10 | hhh201 | hhh201 | Salary | 2500
 | 10/10/2021 | 200 | [NAME] | [NAME] | Salary | 1500
 | 10/10/2021 | 300 | hhh203 | hhh203 | Salary | 3500
 | 10/10/2021 | 4 |  |  | Stationery | 98
 | 10/10/2022 | 1 |  |  | Advertisement | 250
 | 10/10/2023 |  | Rent |  | Rent | 5800
 | Totals
Spreadsheet: 4547bdc9-d899-42f0-b282-9085d641ac92
Sheet: 19. Historic by Agency

 | FY 2013 Federal Real Property Charts
 | Historic Designation Total Assets†*
 | Agency | Evaluated, Not Historic | National Historic Landmark (NHL) | National Register Eligible (NRE) | National Register Listed (NRL) | Non-contributing element of NHL/NRL district | Not Evaluated
 | Agriculture | 3516 | 1 | 2199 | 586 | 70 | 33208
 | Air Force** | 45018 | 283 | 5383 | 239 | 1242 | 75412
 | Army** | 15259 | 517 | 14320 | 664 | 102 | 151992
 | Commerce | 578 | 2 | 5 | 13 | 15 | 153
 | Corps of Engineers** | 146 | 6 | 1 | 37 | 9 | 140416
 | Defense/WHS** | 606 | 1 |  |  |  | 18
 | Energy | 7916 | 6 | 1263 | 10 | 239 | 9112
 | Environmental Protection Agency | 269 |  | 10 |  |  | 9
 | General Services Administration | 215 | 80 | 154 | 232 | 45 | 1088
 | Health and Human Services | 1754 | 11 | 196 | 12 | 9 | 997
 | Homeland Security | 1577 | 4 | 31 | 414 | 107 | 43728
 | Interior | 14800 | 2128 | 8642 | 6819 | 1588 | 109488
 | Justice | 201 |  | 492 | 10 | 82 | 3630
 | Labor | 41 |  | 21 | 11 |  | 3747
 | National Aeronautics And Space Administration | 1944 | 48 | 344 | 72 | 181 | 2241
 | National Science Foundation | 391 |  |  | 2 |  | 306
 | Navy** | 8182 | 792 | 6304 | 387 | 596 | 94131
 | Office of Personnel Management
 | State | 5380 |  |  | 1 |  | 27
 | State (USAID) | 109
 | Transportation | 53803 | 2 | 17 |  | 91 | 28
 | Treasury | 8 | 2 | 1 |  |  | 5
 | Veterans Affairs | 3377 | 210 | 794 | 1740 | 2107 | 1347
 | Total
 | † All real property data from the CFO Act agencies required to submit data to the FRPP
 | * Historic Designation is  reported on all owned buildings, structures, and land assets, except those assets that have been evaluated and for which disclosure of historic status is restricted based upon EO 13007 and Section 304 of the National Historic Preservation Act.   Generally, properties eligible for listing in the National Register are at least 50 years old. Properties less than 50 years of age must be exceptionally important to be considered eligible for listing.
 | **Department of Defense
Spreadsheet: 753058d1635220967-calculating-actual-and-budget-from-data-drop-test-mma-bvj-
Sheet: MMA FP

FP
Period | 1
 |  | September - August
 |  | Actual | Budget
Code
510100
510130
510200
510201
510251
520153
510150
Spreadsheet: c0f731a1-adbb-4cb1-a5ca-781c4887d8a4
Sheet: Sheet1

GENERAL | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15
Ordinance Fact Sheet |  |  |  |  |  |  | Ordinance Number
 | Brief Title |  | Approval Deadline |  | Reason
 | [NAME] EmergencyRelief
 | Funding FY2011 - Part A
Details |  |  |  |  | Positions/Recommendations
 | Reason for Legislation |  |  |  | Sponsor |  |  |  | Health Department
 |  |  |  |  | Programs,
 |  |  |  |  | Departments, |  |  |  | Health Department
 |  |  |  |  | or Groups
 |  |  |  |  | Affected
 |  |  |  |  | Applicants / |  | Applicant
 |  |  |  |  | Proponents
 |  |  |  |  |  |  |  |  | _________ Department
 |  |  |  |  |  |  | City Department
 |  |  |  |  |  |  |  |  | _________ Department
 |  |  |  |  |  |  |  |  | _________ Department
 |  |  |  |  |  |  | Other
 |  |  |  |  | Opponents |  | Groups or Individuals
 |  |  |  |  |  |  |  |  | None Known
 |  |  |  |  |  |  | Basis of opposition
 |  |  |  |  | Staff
 |  |  |  |  | Recommendation |  | X |  | For
 |  |  |  |  |  |  |  |  | Against
 |  |  |  |  |  |  | Reason Against
 |  |  |  |  | Board or
 |  |  |  |  | Commission |  | By
 |  |  |  |  | Recommendation
 |  |  |  |  |  |  |  |  | For |  |  |  | Against |  | No action taken
 |  |  |  |  |  |  |  |  | For, with revisions or conditions
 |  |  |  |  |  |  |  |  | (see details column for conditions)
 |  |  |  |  | Council
 |  |  |  |  | Committee |  |  |  | Do pass
 |  |  |  |  | Actions
 |  |  |  |  |  |  |  |  | Do pass (as amended)
 |  |  |  |  |  |  |  |  | Committee Sub.
 |  |  |  |  |  |  |  |  | Without Recommendation
 |  |  |  |  |  |  |  |  | Hold
 |  |  |  |  |  |  |  |  | Do not pass
 |  |  |  |  |  |  |  |  |  |  |  | (Continued on reverse side)
Details |  |  |  |  | Policy/Program Impact
 |  |  |  |  | Policy or Program
 |  |  |  |  | Change |  | X |  | No |  |  |  | Yes
 |  |  |  |  | Operational
 |  |  |  |  | Impact
 |  |  |  |  | Assessment
 |  |  |  |  | Finances
 |  |  |  |  | Cost & Revenue
 |  |  |  |  | Projections --
 |  |  |  |  | Including Indirect
 |  |  |  |  | Costs
 |  |  |  |  | Financial Impact
 |  |  |  |  | Fund Source (s) |  | 19__ Budget, Page ___
 |  |  |  |  | and Appropriation |  | Unbudgeted, Appropriation
 |  |  |  |  | Account Codes |  | ________________ Fund
 |  |  |  |  |  |  | 00-000-00-0000-A0000
 |  |  |  |  | (Use this space for further discussion, if necessary)
Applicable Dates:
Fact Sheet Prepared by:
 | Name [NAME] |  | Date: 7/18/11
 | Title: Program Manager
Reviewed by:
 | Name |  | Date
 | Title
Reference Numbers
Spreadsheet: 865773d1712762850-return-a-column-header-based-on-latest-instance-of-data-in-a-row-sample-5-
Sheet: Sheet1

Count of SUB_NAME | Column Labels
Row Labels | early | on time | 1-2 weeks delayed | 2-3 weeks delayed | 3-4 weeks delayed | 4+ weeks delayed | (blank) | Grand Total | Final Bucket
1484989K |  | 18 |  | 18 |  | 18 |  | 54
2191443C |  | 18 |  | 18 |  | 18 |  | 54 | 4+ weeks delayed
2422780R |  | 18 |  | 18 |  | 18 |  | 54 | 4+ weeks delayed
1644681K |  | 63 | 63 | 63 |  |  |  | 189 | 2-3 weeks delayed
2332393C |  | 68 | 68 | 68 |  |  |  | 204 | 2-3 weeks delayed
2560639R |  | 68 | 68 | 68 |  |  |  | 204 | 2-3 weeks delayed
31121319 |  | 20 |  | 20 | 20 | 40 |  | 100 | 4+ weeks delayed
31040052 |  | 24 |  | 24 |  | 24 |  | 72 | 4+ weeks delayed
31175601 |  | 36 | 18 | 18 |  |  |  | 72 | 2-3 weeks delayed
31638550 | 13 | 26 | 13 |  |  |  |  | 52 | 1-2 weeks delayed
31780118 | 40 | 80 | 40 |  |  |  |  | 160 | 1-2 weeks delayed
1533348K |  | 20 | 20 |  | 40 |  |  | 80 | 3-4 weeks delayed
2462257R |  | 20 | 20 |  | 40 |  |  | 80 | 3-4 weeks delayed
2462265R |  | 24 | 24 |  | 48 |  |  | 96 | 3-4 weeks delayed
1577295K |  | 30 | 30 |  | 60 |  |  | 120 | 3-4 weeks delayed
2393635C | 24 | 24 | 24 | 24 | 24 |  |  | 120 | 3-4 weeks delayed
31180969 |  | 21 | 21 |  | 42 |  |  | 84 | 3-4 weeks delayed
31087762 |  | 24 | 24 |  | 48 |  |  | 96 | 3-4 weeks delayed
31180984 |  | 16 | 32 |  | 16 |  |  | 64 | 3-4 weeks delayed
1533355K |  | 24 | 24 |  | 48 |  |  | 96 | 3-4 weeks delayed
2228674C |  | 24 | 24 |  | 48 |  |  | 96 | 3-4 weeks delayed
2269017C |  | 30 | 30 |  | 60 |  |  | 120 | 3-4 weeks delayed
2393585C |  | 10 | 10 | 10 |  |  |  | 30 | 2-3 weeks delayed
2228666C |  | 20 | 20 |  | 40 |  |  | 80 | 3-4 weeks delayed
1705953K |  | 10 | 10 | 10 |  |  |  | 30 | 2-3 weeks delayed
1706001K |  | 19 | 19 | 19 |  |  |  | 57 | 2-3 weeks delayed
31840223 | 9 | 9 | 9 |  |  |  |  | 27 | 1-2 weeks delayed
31840222 | 62 | 31 | 31 |  |  |  |  | 124 | 1-2 weeks delayed
2621092R |  | 10 | 10 | 10 |  |  |  | 30 | 2-3 weeks delayed
31345870 |  | 30 | 30 |  | 60 |  |  | 120 | 3-4 weeks delayed
2500734R |  | 29 | 29 |  | 58 |  |  | 116 | 3-4 weeks delayed
30807942 |  | 6 | 6 | 6 |  |  |  | 18 | 2-3 weeks delayed
2621142R |  | 7 |  | 7 | 7 |  |  | 21 | 3-4 weeks delayed
31286902 | 2 | 2 | 2 |  |  |  |  | 6 | 1-2 weeks delayed
31509103 | 12 | 12 | 12 |  |  |  |  | 36 | 1-2 weeks delayed
Spreadsheet: geir_solberg__11295__1-20act
Sheet: EPEData

 | 37296.95694444444
 | NEWMAN 1 ,UNAV,  0  , 75  , 39  , 83  ,  0  ,1
 | NEWMAN 2 ,ECON, 35  , 70  , 34  , 83  , 35  ,1
 | NEWMAN 3 ,ECON, 64  ,100  , 35  ,103  , 36  ,1
 | NEWMN/GT1,MANL, 20  , 60  , 18  , 60  ,  0  ,1
 | NEWMN/GT2,MANL, 20  , 60  , 18  , 60  ,  0  ,1
 | NM/GT1+ST,UNAV,  0  ,100  , 61  ,107  ,  0  ,1
 | NM/GT2+ST,UNAV,  0  ,100  , 66  ,107  ,  0  ,1
 | NEWMAN 4 ,UNAV,  0  ,215  , 86  ,214  ,  0  ,1
 | NEWMAN   ,, 139 ,  290,  105, 306 ,  71 ,
 | COPPER   ,[NAME], -0  , 69  , 15  , 69  ,  0  ,1
 | RIOGRAN 6,AVAL,  0  , 47  , 29  , 48  ,  0  ,1
 | RIOGRAN 7,AVAL,  0  , 38  , 32  , 49  ,  0  ,1
 | RIOGRAN 8,UNAV,  0  ,120  , 36  ,151  ,  0  ,1
 | RIOGRANDE,,   0 ,    0,    0,   0 ,   0 ,
 | PALOVERDE,MANL,607  ,600  ,600  ,600  ,  0  ,1
 | FOURCRNRS,MANL, 52  , 52  , 52  ,104  ,  0  ,1
 | LAMBDA, 24.93,  620,  620,  153,    1,    0, 9548,21
 | APS     ,FIRM    ,FC,  ,  25,  25
 | APS     ,FIRM    ,PV,  ,  50,  50
 | IID     ,FIRM    ,PV,  ,  75,  75
 | LDWP    ,FIRM    ,PV,  ,  25,  25
 | PGT     ,LOSS    ,LC,  ,  -2,  -1
 | PNM     ,ECON    ,FC,  ,  20,   0
 | PNM     ,FIRM    ,FC,  ,  30,  30
 | SRP     ,LOSS    ,PV,  ,   4,   4
 | TNP     ,LOSS    ,AM,  ,  -2,  -2
 | CISO    ,FIRM    ,PV,  ,  78,   0
 | TNP     ,LOSS    ,AM,  ,  -2,  -2
 | WAPA    ,PASS    ,WM,HO,  -1,  -1
 | 37300.62986111111
 | NEWMAN 1 ,UNAV, -0  , 75  , 39  , 83  ,  0  ,1
 | NEWMAN 2 ,MANL, 39  , 75  , 34  , 83  ,  0  ,1
 | NEWMAN 3 ,ECON, 38  ,100  , 35  ,103  , 40  ,1
 | NEWMN/GT1,UNAV,  0  , 60  , 18  , 60  ,  0  ,1
 | NEWMN/GT2,UNAV,  0  , 60  , 18  , 60  ,  0  ,1
 | NM/GT1+ST,UNAV,  0  ,100  , 61  ,107  ,  0  ,1
 | NM/GT2+ST,UNAV,  0  ,100  , 66  ,107  ,  0  ,1
 | NEWMAN 4 ,ECON,174  ,215  , 86  ,214  , 41  ,1
 | NEWMAN   ,, 251 ,  390,  155, 400 ,  81 ,
 | COPPER   ,[NAME], -0  , 69  , 15  , 69  ,  0  ,1
 | RIOGRAN 6,AVAL,  0  , 47  , 29  , 48  ,  0  ,1
 | RIOGRAN 7,AVAL,  0  , 38  , 32  , 49  ,  0  ,1
 | RIOGRAN 8,UNAV,  0  ,121  , 36  ,151  ,  0  ,1
 | RIOGRANDE,,   0 ,    0,    0,   0 ,   0 ,
 | PALOVERDE,MANL,603  ,600  ,600  ,600  ,  0  ,1
 | FOURCRNRS,MANL, 51  , 51  , 51  ,104  ,  0  ,1
 | LAMBDA, 23.51,  798,  796,   80,   -3,    0,11060,21
 | APS     ,STRT    ,FC,  ,   1,   1
 | IID     ,EXCS    ,FC,  ,  50,  50
 | IID     ,FIRM    ,PV,  , 100, 100
 | LDWP    ,ECON    ,PV,  ,  80,  80
 | PGT     ,LOSS    ,PV,  ,  -1,  -1
 | PNM     ,CNTG    ,LC,  ,  11,  11
 | PNM     ,LOSS    ,LC,  ,   2,   2
 | SPS     ,FIRM    ,WM,  ,-103,-103
 | SRP     ,FIRM    ,ED,  ,  25,  25
 | SRP     ,LOSS    ,PV,  ,   1,   1
 | TNP     ,FIRM    ,PV,  ,  25,  25
 | TNP     ,LOSS    ,PV,  ,  -5,  -5
 | WAPA    ,PASS    ,WM,HO,  -1,  -1
Spreadsheet: 465468d1465672848-conditional-formatting-help-conditional-formatting-with-text-2-
Sheet: Sheet1

Value | Color | Value2 | Color | Value3 | Color
0 |  | 0 |  | 0
 |  | 0
0 |  | 0 |  | 0
1 |  | 1 |  | 1
1 |  |  |  | 1
1 |  | 1 |  | 1
2 |  | 2 |  | 2
2 |  | 2 |  | 2
Spreadsheet: phillip_m_love__30156__SitheFRED
Sheet: all variances

Sithe financial liquidation variances
TAGG | [NAME] | GL Amount | [NAME] | ABS |  | Desk Adjustment | GL Adjustment/Reclass | Comments
NS9352.1 | -74622.70980000001 | 0
NS6767.1 | 11624.845 | 0
NS2550.1 | 27899.876 | 0
NX8240.2 | -684605.9472 | 684605.96
Spreadsheet: 802456d1666870291-let-reference-inside-curly-brackets-not-accepted-unique-index-sort-sortfilterdemo-1-
Sheet: Sheet1

Column1 | Column2 | Column3 | Wave | Column5 | Phase | Column7 | Task | Column9 | Column10 | Column11 | Column12 | Column13 | Column14 | Column15 |  |  |  | 1 | A |  |  | 1 | A
 |  |  | 1 |  | 1 |  | A |  |  |  |  |  |  |  |  |  | 1 | 1 | B |  | 1 | 1 | B
 |  |  | 1 |  | 1 |  | B |  |  |  |  |  |  |  |  |  | 1 | 1 | F |  | 1 | 1 | F
 |  |  | 1 |  | 2 |  | C |  |  |  |  |  |  |  |  |  | 1 | 1 | G |  | 1 | 1 | G
 |  |  | 1 |  | 3 |  | D |  |  |  |  |  |  |  |  |  | 1 | 2 | C |  | 1 | 2 | C
 |  |  | 1 |  | 1 |  | F |  |  |  |  |  |  |  |  |  | 1 | 2 | J |  | 1 | 2 | J
 |  |  | 1 |  | 1 |  | G |  |  |  |  |  |  |  |  |  | 1 | 2 | K |  | 1 | 2 | K
 |  |  | 4 |  | 2 |  | H |  |  |  |  |  |  |  |  |  | 1 | 2 | L |  | 1 | 2 | L
 |  |  | 5 |  | 2 |  | I |  |  |  |  |  |  |  |  |  | 1 | 3 | D |  | 1 | 3 | D
 |  |  | 1 |  | 2 |  | J |  |  |  |  |  |  |  |  |  | 1 | 3 | M |  | 1 | 3 | M
 |  |  | 1 |  | 2 |  | K |  |  |  |  |  |  |  |  |  | 1 | 3 | P |  | 1 | 3 | P
 |  |  | 1 |  | 2 |  | L |  |  |  |  |  |  |  |  |  | 2 | 1 | T |  | 2 | 1 | T
 |  |  | 1 |  | 3 |  | M |  |  |  |  |  |  |  |  |  | 2 | 3 | O |  | 2 | 3 | O
 |  |  | 3 |  | 3 |  | N |  |  |  |  |  |  |  |  |  | 2 | 3 | Q |  | 2 | 3 | Q
 |  |  | 2 |  | 3 |  | O |  |  |  |  |  |  |  |  |  | 2 | 3 | R |  | 2 | 3 | R
 |  |  | 1 |  | 3 |  | P |  |  |  |  |  |  |  |  |  | 2 | 3 | S |  | 2 | 3 | S
 |  |  | 2 |  | 3 |  | Q |  |  |  |  |  |  |  |  |  | 3 | 1 | U |  | 3 | 1 | U
 |  |  | 2 |  | 3 |  | R |  |  |  |  |  |  |  |  |  | 3 | 1 | V |  | 3 | 1 | V
 |  |  | 2 |  | 3 |  | S |  |  |  |  |  |  |  |  |  | 3 | 3 | N |  | 3 | 3 | N
 |  |  | 2 |  | 1 |  | T |  |  |  |  |  |  |  |  |  | 4 | 1 | X |  | 4 | 1 | X
 |  |  | 3 |  | 1 |  | U |  |  |  |  |  |  |  |  |  | 4 | 2 | H |  | 4 | 2 | H
 |  |  | 3 |  | 1 |  | V |  |  |  |  |  |  |  |  |  | 5 | 2 | I |  | 5 | 2 | I
 |  |  | 4 |  | 1 |  | X
Spreadsheet: 733359d1621524880-formula-to-auto-fill-data-from-another-sheet-excel-example
Sheet: Master Sheet 1

Employee EmployeeId | LastName | FirstName | Employee Address State | Employee GenderId | Employee EthnicityId
78 | Beck | [NAME] | IL | Male | White (not Hispanic or Latino)
870 | Becker | [NAME] | IL | Male | White (not Hispanic or Latino)
15 | [NAME] | [NAME] | IL | Male | White (not Hispanic or Latino)
888 | [NAME] | [NAME] | IL | Female | White (not Hispanic or Latino)
665 | Cordova | [NAME] | IL | Male | Hispanic or Latino
666 | Crosby | [NAME] | IL | Male | Black or African American (not Hispanic or Latino)
930 | [NAME] | [NAME] | IL | Male | White (not Hispanic or Latino)
 | [NAME] | [NAME] | IL | Male | White (not Hispanic or Latino)
701 | Duffy | [NAME] | IL | Male | White (not Hispanic or Latino)
838 | Elfering | [NAME] | IL | Male | White (not Hispanic or Latino)
920 | [NAME] | Justin | IL | Male | White (not Hispanic or Latino)
869 | Harwell | [NAME] | IL | Male | White (not Hispanic or Latino)
597 | Hedges | Shawn | IL | Male | White (not Hispanic or Latino)
19 | Isa | Mugni | IL | Male | White (not Hispanic or Latino)
311 | Kenney | [NAME] | IL | Male | White (not Hispanic or Latino)
429 | [NAME] | [NAME] | IL | Male | White (not Hispanic or Latino)
92 | [NAME] | [NAME] | IL | Male | White (not Hispanic or Latino)
917 | Lang | Adam | IL | Male | White (not Hispanic or Latino)
760 | Leonard | Leo | IL | Male | White (not Hispanic or Latino)
811 | Lombardi | [NAME] | IL | Male | White (not Hispanic or Latino)
914 | [NAME] | Adam | IL | Male | White (not Hispanic or Latino)
98 | [NAME] | [NAME] | IL | Male | Black or African American (not Hispanic or Latino)
398 | Parker | [NAME] | IL | Male | White (not Hispanic or Latino)
762 | Pellng | [NAME] | IL | Male | White (not Hispanic or Latino)
905 | Platt | Chante | IL | Female | Black or African American (not Hispanic or Latino)
864 | Posey | Adam | WI | Male | White (not Hispanic or Latino)
515 | [NAME] | [NAME] | IL | Male | Hispanic or Latino
431 | Siek | [NAME] | IL | Male | White (not Hispanic or Latino)
788 | Spatz | [NAME] | IL | Male | White (not Hispanic or Latino)
669 | Spells | [NAME] | IL | Male | Black or African American (not Hispanic or Latino)
886 | Tekampe | [NAME] | IL | Male | White (not Hispanic or Latino)
792 | [NAME] | Riley | IL | Male | White (not Hispanic or Latino)
938 | [NAME] | [NAME] | IL | Male | White (not Hispanic or Latino)
379 | Turner | [NAME] | IL | Male | White (not Hispanic or Latino)
58 | Useini | Vullnet | IL | Male | White (not Hispanic or Latino)
931 | [NAME] | [NAME] | IN | Male | White (not Hispanic or Latino)
909 | [NAME] | Marcus | IL | Male | White (not Hispanic or Latino)
Spreadsheet: 216198d1361639492-help-with-vlookup-formula-book1
Sheet: Sheet2

ram
vivek
vikas
suraj
prashant
sunil
suhas
mayur
here I have take an example of bikes
in Sheet1, column A I have mention the names of person, and in column B I have mentioned the names of bike
In Sheet2, I have applied vlook formula in column B, but it just returns 1 result
example ram is have pulsar, unicorn, karizma
but it just shows pulsar
I want a formula which should insert rows and to get all the ans
[NAME] 2more rows should automatically get added to show unicorn and karizma
Spreadsheet: 778514d1651133808-how-to-find-cell-address-of-numeric-value-in-range-w-multiple-rows-and-columns-book1-5-ans
Sheet: Sheet1

 | Jan | Feb | Mar | Apr
1 | 1.6 | 1.8 | 2.6 | 0.8
2 | 0.5 | 1.1 | 2.8 | 2.6
3 | 0.2 | 2.6 | 2.1 | 0
4 | 1.8 | 3.3 | 2.7 | 1.7
5 | 1.3 | 0.3 | 3.3 | 1.1
6 | 2.5 | 2.8 | 4 | 2.7
7 | 1.7 | 1.6 | 1.2 | 1.8
8 | 2.8 | 2.8 | 2.2 | 1.6
 | MAX |  |  | =IF(COUNTIF($B$2:$E$9,$C$11)=1,"The maximum daily discharge occurred on "&INDEX($B$1:$E$1,SUMPRODUCT(($B$2:$E$9=$C$11)*COLUMN($B$1:$E$1))-COLUMN($A$1))&" "&INDEX($A$2:$A$9,SUMPRODUCT(($B$2:$E$9=$C$11)*ROW($A$2:$A$9))-ROW($A$1))&"th.","The maximum daily discharge occurred on multiple days.")
 | MIN |  |  | =IF(COUNTIF($B$2:$E$9,$C$12)=1,"The minimum daily discharge occurred on "&INDEX($B$1:$E$1,SUMPRODUCT(($B$2:$E$9=$C$12)*COLUMN($B$1:$E$1))-COLUMN($A$1))&" "&INDEX($A$2:$A$9,SUMPRODUCT(($B$2:$E$9=$C$12)*ROW($A$2:$A$9))-ROW($A$1))&"th.","The minimum daily discharge occurred on multiple days.")
Spreadsheet: 287296d1388750432-sorting-dates-as-i-know-them-book41
Sheet: Sheet1

 |  | 01-05-1976 Balliol library asking for their books back
 |  | 01-05-1976 Notes for Finals examination
 |  | 02-08-1974 Oxfordshire County Council University grant result
 |  | 04-05-1976 [NAME] account
 |  | 07-02-1977 6/2 stamp
 |  | 07-02-1977 University External Studies Teaching Course
 |  | 08-06-1976 Notes for a “Thanks to the Balliol Tutors at the end of our studies
 |  | 08-06-1976 [NAME] asks me to give “Thanks” few words at Schools Dinner
 |  | 11-06-1976 Balliol P-P-E- Tutors [NAME] dinner
 |  | 13-05-1976 Discuss Graduate work?
 |  | 15-06-1976 Lukes, [NAME] and Newton-Smith defend their views on “The nature of explanation and the Concept of a Person
 |  | 16-10-1974 Barclays Bank account
 |  | 17-06-1976 [NAME] lost books
 |  | 18-7-1977 University External Studies Teaching Course
 |  | 1974 Balliol JCR
 |  | 1976 Examination answers paper
 |  | 1976 Finals papers questions
 |  | 1976 [NAME] for [NAME] term
 |  | 1976 Oxford Cyrenians asking for contributions of fifty pence
 |  | 1976 Oxford Union Society calendar
 |  | 1976 Oxford Union Treasurer note
 |  | 1976 University Labour Club internecine strife with dodgy accounts
 |  | 20-05-1976 Party invitation
 |  | 23-06-1976 Revision note from [NAME]
 |  | 23-12-1974 Oxfordshire County Council University grant receipts
 |  | 25-04-1976 Revision time table
 |  | 28-11-1974 Oxford Strumpet
 |  | 29-4-1976 [NAME] note on revision
Spreadsheet: 225597ec-1b19-4d59-b0f2-95894cda072f
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
----------------------------------Rheem Manufacturing Co. - Water Heater Division------------------------------
TEAM FEASIBILITY COMMITMENT
PRODUCTION PART APPROVAL
ATTENTION: RHEEM MANUFACTURING COMPANY
Date: |  |  |  |  |  |  |  |  |  |  |  |  |  | Yes
 |  |  |  |  |  |  |  |  |  |  |  |  |  | No
Part Number |  |  |  |  | Revision Level |  |  |  | Part Name
Our Product quality planning team has considered the following questions, not intended to be all-inclusive in performing a feasibility evaluation.  The drawings and/or specifications provided have been used as a basis for analyzing the ability to meet all specified requirements.  All "no" answers are supported with attached comments identifying our concerns and/or proposed changes to enable us to meet the specified requirements.
Y, N, N/A |  | CONSIDERATIONS
 |  | Is product adequately defined (application requirements, etc) to enable feasibility evaluation?
 |  | Can Engineering Performance Specifications be met as written?
 |  | Can product be manufactured to tolerances specified on drawings?
 |  | Can product be manufactured with [NAME]'s that meets requirements?
 |  | Is there adequate capacity to produce product?
 |  | Can the product be manufactured without incurring any unusual costs? (i.e. capital equipment, tooling, alternative manufacturing methods)
 |  | Is statistical process control required on product?
 |  | Are Cpk's greater than 1.33?
 |  | Conclusion
 |  | Feasible |  | Product can be produced as specified with no revisions.
 |  | Feasible |  | Changes recommends.  (see attached)
 |  | Not Feasible |  | Design review required to produce product within the specified requirements.
Comments/Explanation:
DECLARATION
I affirm that the samples represented by this warrant are representative of our parts and have been made to the applicable customer drawings and specifications and in the case of production samples, are made from specified materials on regular production tooling with no operations other than the regular production process.  I have noted any deviations from this declaration below:
EXPLANATION/COMMENTS
Name |  |  |  |  | Title |  |  |  |  | Phone
Date
Spreadsheet: 60981d1261565381-vlookup-problem-maybe-formatting-vlookup-error
Sheet: Sheet 2

 |  | Identifier | Vlookup
Mr M R Adams |  | Mr M R Adams | Mr M R Adams
Mr E Adeniyi |  | Mr E Adeniyi | Mr E Adeniyi
Mr P D Andrew |  | Mr P D Andrew | #N/A
Mrs M F Appleby |  | Mrs M F Appleby | #N/A
Miss M J Arden |  | Miss M J Arden | Miss M J Arden
Miss H Armstrong |  | Miss H Armstrong | Miss H Armstrong
Mr M H Avery |  | Mr M H Avery | Mr M H Avery
Mrs L J Barley |  | Mrs L J Barley | #N/A
Mrs A L Barnett |  | Mrs A L Barnett | #N/A
Mr [NAME] |  | Mr [NAME] | #N/A
Mr G Bell |  | Mr G Bell | #N/A
Mr D Belton |  | Mr D Belton | #N/A
Mr T F Bennington |  | Mr T F Bennington | #N/A
Mr H W T Berry |  | Mr H W T Berry | #N/A
Mr A W Bird |  | Mr A W Bird | #N/A
Mr J W Bowser |  | Mr J W Bowser | #N/A
Mrs D K Buffham |  | Mrs D K Buffham | #N/A
Mrs C D Burton |  | Mrs C D Burton | #N/A
Mrs S L Burton |  | Mrs S L Burton | #N/A
Miss P Calderbank |  | Miss P Calderbank | #N/A
Mr A D Chamberlain |  | Mr A D Chamberlain | #N/A
Mr D N Cliverd |  | Mr D N Cliverd | #N/A
Mr G S Colebrook |  | Mr G S Colebrook | #N/A
DD Cook
Mrs H D Cook |  | Mrs H D Cook | #N/A
Mr I C Cook |  | Mr I C Cook | #N/A
Mrs J I Cook |  | Mrs J I Cook | #N/A
Mr J M Cookson |  | Mr J M Cookson | #N/A
Mrs J M Cotgrave |  | Mrs J M Cotgrave | #N/A
Mr R A Craw |  | Mr R A Craw | #N/A
Mr G D Crawford |  | Mr G D Crawford | #N/A
Mrs J Crawford |  | Mrs J Crawford | #N/A
Ms J L Crouch |  | Ms J L Crouch | #N/A
Mr J R Davies |  | Mr J R Davies | #N/A
Mrs R A Dawson |  | Mrs R A Dawson | #N/A
Mr J P Dennis |  | Mr J P Dennis | #N/A
Miss L J Dent |  | Miss L J Dent | Miss L J Dent
Spreadsheet: 109762d1306524477-excel-2007-specific-date-compared-to-date-range-terrip
Sheet: Payments

 | Case Number |  |  |  |  |  |  |  |  |  | Date Prepared
 | Non Custodial Parent |  |  |  |  |  |  |  |  |  | Reconciliation Date
 | CP/Caretaker
 |  |  |  | PAYMENT SUMMARY
 |  | Order 1 |  | Order 2 |  | Order 3 |  | Order 4 |  | Order 5
State |  |  |  |  |  |  |  |  |  |  |  | Annual
Effective Date |  |  |  |  |  |  |  |  |  |  |  | Sum of
End Date |  |  |  |  |  |  |  |  |  |  |  | Payments
Year
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
 | Total