tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 37075d1235036666-data_lookup-data_lookup
Sheet: Data

Business Priority | Campaign Name | Campaign Owner | FY09 Budget ($K) | YTD Budget | YTD Actuals | Jul 08 Act | Aug 08  act | Sep 08  act | Oct 08  act | Nov 08  act | Dec 08  act | Jan 09  act
Citizenship | Corporate - Local Campaign | meenuh | 248364.6943 | 140710.7916157224 | 66810.1992 | 0 | 447.6835 | 34211.3374 | 19443.0243 | 7761.0908 | 4493.2588 | 453.8044000000009
Citizenship | Corporate - PR | meenuh | 331661.1529 | 243649.0126244935 | 257673.2921 | 34729.1147 | 39313.4665 | 32160.2487 | 64170.7815 | 25679.8283 | 17634.7772 | 43985.07520000001
Citizenship | Government Elite Communication (GECo) | meenuh | 473431.7207 | 260387.446235 | 255968.5564 | 137.0902 | 8755.2443 | 18670.7024 | 68410.8711 | 61814.9975 | 22262.8002 | 75916.85070000001
Citizenship | Software Ecosystem Market Development | SRIVARK | 133976.4764 | 96646.22742074417 | 20054.5303 | 0 | 0 | 0 | 0 | 6225.2628 | 9981.1235 | 3848.144
Citizenship | TwC/CTZ Privacy, Internet Safety & Security Campaign | mmadaan | 311640.5832 | 247184.2638540499 | 155551.517 | 2164.581 | 0 | 18462.4569 | 37149.1021 | 87537.34419999999 | 21039.3425 | -10801.3097
Compete | Compete - Local Campaign | alkak | 29028.8555 | 0 | 22871.5394 | 0 | 0 | 21239.6864 | 3363.278200000001 | -6156.9111 | 4425.4859 | 0
Compete | Drive Platform Preference (Windows Server 2008 vs. [NAME]) | rohitrai | 400733.2005 | 315967.4984326685 | 264668.2132 | 0 | 0 | 29236.3473 | 37185.9944 | 120202.0815 | 85992.9807 | -7949.190700000003
Compete | IBM Platform/Notes Compete Local Summits | vikrambh | 25624.3356 | 25609.95645629639 | 12997.6838 | 0 | 0 | 0 | 10822.9052 | 15071.1958 | -12896.4172 | 0
Compete | Interoperability | vikrambh | 45676.3315 | 24772.93393784224 | 6695.843099999999 | 0 | 122.9724 | 0 | 373.246 | 6490.6645 | -3514.9188 | 3223.879
Compete | Oracle Compete | plavaniy | 106476.6873 | 87044.84481471541 | 67916.70060000001 | 0 | 0 | 0 | 31903.7884 | 25836.4821 | 3103.0951 | 7073.335
Spreadsheet: 675423d1588275814-if-formula-to-gather-data-from-different-sheets-in-a-worksheet-demo
Sheet: 0 students

0 |  |  |  |  |  |  |  | lsantiago
 |  |  |  |  |  |  |  | Dfster
 |  |  |  |  |  |  |  | Apersaud
Spreadsheet: 7a32aeed-977e-4b8b-aa5a-00bfac767dce
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
PTHRP | Test | PTHRP | Parathyroid Hormone-Related Peptide (PTHrP), Plasma | PTH-Related Peptide | Immunochemiluminometric Assay (ICMA) | EDTA (lavender-top) tube: EDTA |  |  | 0.7 | mL | Collection Container/Tube: Ice-cooled, lavender top (EDTA) Submission Container/Tube: Plastic vial [NAME]: 0.7 mL Collection Instructions: 1. Fasting 2. Spin specimen down in a refrigerated centrifuge or in chilled centrifuge cups. Forms: If not ordering electronically, submit a General Request Form (Supply T239) with the specimen. | 0.25 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm OK <1 hr; Cold OK <6 hrs - refreeze Lipemia	Mild OK; [NAME] OK Icterus	Mild OK; [NAME] OK Other	NA | <2.0 pmol/L | Monday through Thursday; 1:30 p.m. | 2 days | 5 days | 1 | 82397 |  |  |  |  | Rochester
PTHRP | [NAME] | PLEDTA | [NAME] |  |  |  | Frozen | 90 days
PTHRP | Result | 81774 | PTH-Related Peptide | PTH-Related Peptide | Numeric |  |  |  |  | pmol/L |  |  |  |  |  |  |  |  |  | 15087-0 | Parathyrin related protein:SCnc:Pt:Ser/Plas:Qn:
Spreadsheet: eric_saibi__9712__10702
Sheet: Craig 01

Owner Name |  | Tri-State Generation
Station Name |  | Craig Power Station
Unit Name |  | [NAME] 01
NERC Region |  | WSCC
State |  | CO
Fuel Type |  | Coal
Capacity |  | 446MW
Start Date |  | 2002-01-05 00:00:00
End Date |  | 2002-01-13 00:00:00
Comments |  | [NAME]
SIC |  | 4911
Plant ID |  | 1015365
Unit ID |  | 1007177
Outage ID |  | 19384
Spreadsheet: 887162d1737376319-index-match-get-the-columns-headings-index-match
Sheet: Sheet2

ITEM | 2025-01-01 00:00:00 | 2024-12-01 00:00:00 | 2024-11-01 00:00:00 | 2024-10-01 00:00:00 | 2024-09-01 00:00:00 | 2024-08-01 00:00:00 | 2024-07-01 00:00:00 | 2024-06-01 00:00:00 | 2024-05-01 00:00:00 | 2024-04-01 00:00:00 | 2024-03-01 00:00:00 | 2024-02-01 00:00:00 | 2024-01-01 00:00:00 |  |  |  | ITEM | Last Sold Month
Item1 | 120 | 134 | 202 | 199 | 209 | 221 | 209 | 168 | 177 | 180 | 181 | 140 | 150 |  |  |  | Item1 | 2025-01-01 00:00:00 | <<=== I did manually
Item2 | 0 | 138 | 227 | 205 | 184 | 192 | 216 | 163 | 150 | 167 | 163 | 170 | 168 |  |  |  | Item2 | 2024-12-01 00:00:00
Item3 | 100 | 81 | 122 | 149 | 208 | 98 | 181 | 147 | 161 | 176 | 166 | 153 | 144 |  |  |  | Item3 | 2025-01-01 00:00:00
Item4 | 0 | 0 | 0 | 141 | 148 | 132 | 127 | 150 | 188 | 210 | 133 | 14 | 134 |  |  |  | Item4 | 2024-10-01 00:00:00
Item5 | 103 | 93 | 128 | 123 | 66 | 79 | 77 | 73 | 100 | 118 | 123 | 127 | 110 |  |  |  | Item5 | 2025-01-01 00:00:00
Item6 | 81 | 89 | 97 | 123 | 103 | 91 | 128 | 120 | 121 | 86 | 87 | 78 | 89 |  |  |  | Item6 | 2025-01-01 00:00:00
Item7 | 0 | 0 | 0 | 0 | 0 | 0 | 167 | 105 | 113 | 143 | 58 | 23 | 68 |  |  |  | Item7 | 2024-07-01 00:00:00
Item8 | 52 | 70 | 109 | 107 | 112 | 108 | 113 | 94 | 89 | 96 | 118 | 93 | 79 |  |  |  | Item8 | and so on
Item9 | 0 | 0 | 86 | 189 | 152 | 121 | 137 | 128 | 110 | 156 | 85 | 36 | 0 |  |  |  | Item9 | and so on
Item10 | 52 | 71 | 141 | 121 | 112 | 94 | 81 | 81 | 74 | 72 | 30 | 5 | 76 |  |  |  | Item10 | and so on
Item11 | 45 | 74 | 77 | 110 | 76 | 78 | 79 | 68 | 60 | 60 | 71 | 80 | 61 |  |  |  | Item11 | and so on
Item12 | 48 | 63 | 95 | 91 | 94 | 82 | 81 | 72 | 80 | 63 | 65 | 56 | 48 |  |  |  | Item12 | and so on
Item13 | 0 | 12 | 84 | 127 | 91 | 88 | 85 | 94 | 76 | 62 | 45 | 26 | 108 |  |  |  | Item13 | and so on
Item14 | 54 | 70 | 111 | 29 | 83 | 82 | 80 | 79 | 64 | 68 | 40 | 10 | 55 |  |  |  | Item14 | and so on
Item15 | 0 | 0 | 4 | 98 | 94 | 82 | 95 | 86 | 72 | 88 | 56 | 16 | 101 |  |  |  | Item15 | and so on
Spreadsheet: 121b7907-2695-4cbc-861b-c6770cf46caf
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
 | Time Series Workbook
 | 8731.0 Building Approvals, Australia
 | TABLE 79. Value of Building Approved, Chain Volume Measures, Original - New South Wales
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Value of Approval ($M) ;  Chain Volume Measures ;  New South Wales ;  Total houses ;  New ; |  |  | Original | A590477A | 1985-09-01 00:00:00 | 2012-03-01 00:00:00 | 107 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  New South Wales ;  Total other residential building ;  New ; |  |  | Original | A590478C | 1985-09-01 00:00:00 | 2012-03-01 00:00:00 | 107 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  New South Wales ;  Total residential building ;  New ; |  |  | Original | A590479F | 1985-09-01 00:00:00 | 2012-03-01 00:00:00 | 107 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  New South Wales ;  Total residential building ;  Total alterations/additions (incl. refurb and conversion) ; |  |  | Original | A590480R | 1985-09-01 00:00:00 | 2012-03-01 00:00:00 | 107 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  New South Wales ;  Total residential building ;  Total (Type of Work) ; |  |  | Original | A590481T | 1985-09-01 00:00:00 | 2012-03-01 00:00:00 | 107 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  New South Wales ;  Total non-residential building ;  Total (Type of Work) ; |  |  | Original | A590482V | 1985-09-01 00:00:00 | 2012-03-01 00:00:00 | 107 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  New South Wales ;  Total building ;  Total (Type of Work) ; |  |  | Original | A590483W | 1985-09-01 00:00:00 | 2012-03-01 00:00:00 | 107 | $ Millions | FLOW | Quarter | 3
© Commonwealth of Australia  2012
Spreadsheet: 155963d1337114230-count-multiple-column-data-by-date-criteria-and-display-the-value-sampledatanew
Sheet: Sheet1

Change ID | Scheduled Start Date | Team Names
CRQ000000025334 | 2012-01-03 17:00:00 | Team - A
[NAME] | 2012-01-03 17:00:00 | Team - B
CRQ000000025457 | 2012-01-03 17:00:00 | Team - A
CRQ000000025448 | 2012-01-16 00:00:00 | Team - A
[NAME] | 2012-01-16 00:00:00 | Team - C
[NAME] | 2012-01-16 00:00:00 | Team - A
CRQ000000025538 | 2012-01-16 00:00:00 | Team - C
CRQ000000025547 | 2012-01-16 00:00:00 | Team - B
Results
Team Names | Number of Changes 3-Jan-12 | Number of Changes 16-Jan-12
Team - A | 2 | 2
Team - B | 1 | 1
Team - C | 0 | 2
Spreadsheet: 682177d1591954111-find-a-high-low-avg-price-sales-2020
Sheet: Sheet4

Vessel |  | BF800
[NAME] |  |  |  |  | Price per Kilo Summary |  |  |  |  |  | Price per Kilo Summary (All Vessels)
Species | Presentation | Boxes | Total (Kg) |  | Species | Grade | Lowest (Kg) Price | Highest (Kg) Price | [NAME] |  | Species | Grade | Lowest (Kg) Price | Highest (Kg) Price | [NAME]
 |  |  |  |  |  |  |  |  |  |  | COD | 1 | 3.25 | 3.64 | 3.51
 |  |  |  |  |  |  |  |  |  |  | COD | 2 | 3.25 | 3.64 | 3.52
 |  |  |  |  |  |  |  |  |  |  | COD | 3 | 2.9 | 3.33 | 3.13
 |  |  |  |  |  |  |  |  |  |  | COD | 4 | 2.5 | 2.88 | 2.69
 |  |  |  |  |  |  |  |  |  |  | COD | 5 | 2.85 | 2.85 | 2.85
 |  |  |  |  |  |  |  |  |  |  | ANF | 1 | 2.54 | 2.54 | 2.54
 |  |  |  |  |  |  |  |  |  |  | ANF | 2 | 2.92 | 3.08 | 3
 |  |  |  |  |  |  |  |  |  |  | ANF | 3 | 3.42 | 3.5 | 3.46
 |  |  |  |  |  |  |  |  |  |  | ANF | 4 | 3.35 | 3.38 | 3.36
 |  |  |  |  |  |  |  |  |  |  | ANF | 5 | 2.5 | 3 | 2.75
 |  |  |  |  |  |  |  |  |  |  | ANF | 6 | 1.48 | 1.48 | 1.48
Spreadsheet: michelle_lokay__26582__EOLCredit
Sheet: Sheet1

Transwestern / EOL
Agave/Yates
Aquila/Utilicorp
Arizona Public Service
Barrett Resources
BP Energy
Burlington
Calpine
CIG
Citizens
Conoco
Coral
Duke/GPM
Dynegy
EES
El Paso Field Services
El Paso Merchant
El Paso Natural Gas
Elmridge Resources
ENA
Engage
EOG
[NAME]
[NAME]
Marathon
North Star Steel
NWPL
Oneok
Oxy
[NAME]
Pan Canadian
PG&E
PG&E Trading
Phillips
PNM
Pogo
PPL Global
Questar
Red Cedar
Reliant
SCEM
SDG&E
Sempra Energy
[NAME]
SMUD
SoCal Gas
Southwest Gas
SPS/ePrime
Tenaska
Texaco
TransColorado
TXU
USGT
Western Gas Resources
[NAME]
Spreadsheet: 374bbd9c-77e0-433b-b0ae-2a8f9a7c44e1
Sheet: 8d

 | Swap Dealers/MSPs5 |  | Others
Product1 | Cleared2 | Uncleared | Cleared | Uncleared
Fixed-Float | 2632 | 1206 | 5470 | 772
OTHER* | 41 | 820 | 11 | 238
TOTAL | 2673 | 2026 | 5481 | 1010
*OTHER variable includes the following products: Basis, Cap/Floor, Debt Option, Exotic, Fixed-Fixed, FRA,  Inflation, OIS, and Swaption.
Spreadsheet: 151772d1335113887-advanced-if-array-i-think-book1
Sheet: Echelon

Control
42
Back
109 |  |  | 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 | 26
 |  | 1 | 0
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 |  | 6
 |  | 7
 |  | 8
 |  | 9
 |  | 10
 |  | 11
 |  | 12
 |  | 13
 |  | 14
 |  | 15
 |  | 16
 |  | 17
 |  | 18
 |  | 19
 |  | 20
Spreadsheet: 107527d1304676448-excel-formula-to-change-another-cell-example
Sheet: Sheet1

Data1 | Data2 | Data3 | Data4 | N/A | N/A | N/A | N/A | N/A | N/A | N/A | Result 1
AA | AA | AA | AA |  |  |  |  |  |  |  | One
BB | BB | BB | BB |  |  |  |  |  |  |  | One
CC | CC | CC | CC |  |  |  |  |  |  |  | Two
DD | DD | DD | DD |  |  |  |  |  |  |  | Two
EE | EE | EE | EE |  |  |  |  |  |  |  | One
AA | AA | AA | AA |  |  |  |  |  |  |  | One
BB | BB | BB | BB |  |  |  |  |  |  |  | One
CC | CC | CC | CC |  |  |  |  |  |  |  | Three
DD | DD | DD | DD |  |  |  |  |  |  |  | One
EE | EE | EE | EE |  |  |  |  |  |  |  | One
AA | AA | AA | AA |  |  |  |  |  |  |  | One
BB | BB | BB | BB |  |  |  |  |  |  |  | One
CC | CC | CC | CC |  |  |  |  |  |  |  | Two
DD | DD | DD | DD |  |  |  |  |  |  |  | Two
EE | EE | EE | EE |  |  |  |  |  |  |  | One
AA | AA | AA | AA |  |  |  |  |  |  |  | One
BB | BB | BB | BB |  |  |  |  |  |  |  | One
CC | CC | CC | CC |  |  |  |  |  |  |  | Three
DD | DD | DD | DD |  |  |  |  |  |  |  | One
EE | EE | EE | EE |  |  |  |  |  |  |  | One
AA | AA | AA | AA |  |  |  |  |  |  |  | One
BB | BB | BB | BB |  |  |  |  |  |  |  | One
CC | CC | CC | CC |  |  |  |  |  |  |  | Two
DD | DD | DD | DD |  |  |  |  |  |  |  | Two
Spreadsheet: 0202ec9a-e9a1-47e7-9813-e22cbcb247cd
Sheet: Sheet1

Following is the Records Retention and [NAME] for Institutional Advancement.  Please note:  "P" means "Permanent," or archival | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Institutional Advancement
Record Series | In Office | Archives | Total | Notes
Alumni Relations and Operations
40 file drawers of alumni information on index cards | Enter into database and retain electronically | P | Enter into database and retain electronically | Retain 10-15 cards for possible exhibit (no Soc. Sec. numbers)
VIP Biographical files | Retain in office while active | P | P
Events files
Binders of invitations | 3 | P | P
Grant Proposals
Successful proposals | Completion of Project +3 | P | P
Unsuccessful proposals | 3 |  | 3
Advisory Board binders (including minutes) | 5 | P | P
Alumni Relations Board binders (including minutes) | 5 | P | P
Publications (newsletters, magazines, etc.) produced by Ins't. Adv. | 5 | P | 2 copies of each to Archives
Foundation files | Active
Spreadsheet: 724884d1616430502-index-match-function-lookup-cell-is-formula-want-it-to-look-for-result-of-formula-example-for-hours-log
Sheet: 1

Ratio Coverage for
 | Residential |  |  |  |  |  |  |  |  |  | On Behalf Of Hours
 | Sched. | Actual | Deviation |  | Medical | Sick | Orientation | Review | Transport | Total OBO
R1
R2
R3
R4
R5
R6
R7
R8
R9
R10
R11
R12
R13
R14
R15
R16
R17
R18
R19
R20
R21
R22
R23
R25
R26
R27
R28
R29
R30
R31
R32
R33
Spreadsheet: 46935d1245853352-finding-changing-data-from-a-pivot-table-sample2
Sheet: Sheet1

Sum of Column1 |  | Posting Date
G_L Account No_ | Name | 2009-06-22 00:00:00 | 2009-06-24 00:00:00 | Grand Total
4405 | GROCERY SALES | 31276.24999999999 | 28758.65 | 60034.89999999999
4415 | MEAT SALES | 549.0500000000001 | 1691.72 | 2240.77
4420 | PRODUCE SALES |  | 208.63 | 208.63
4425 | DELI SALES | 73.72 | 172.85 | 246.57
4430 | BAKERY SALES |  | 24.01 | 24.01
4440 | DAIRY SALES | 5819.049999999999 | 6926.51 | 12745.56
4445 | [NAME] | 2547.109999999999 | 5174.070000000001 | 7721.18
4460 | CIGARETTE SALES |  | 53.18000000000001 | 53.18000000000001
4465 | CANDY SALES | 32.06 | 168.82 | 200.88
4495 | FEES INCOME | 440.8200000000001 | 183.71 | 624.5300000000001
4450 | HEALTH & BEAUTY CARE SALES | 150.34 |  | 150.34
Grand Total |  | 40888.39999999998 | 43362.15 | 84250.54999999999
Spreadsheet: 2d3f95ec-d28e-404e-ad9a-2e2fe0230e31
Sheet: Sheet1

Permit No.: | Unnamed: 1 | WQ0024694 | Unnamed: 3 | Facility Name: | Unnamed: 5 | Bright's Creek Golf Club | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | County: | Polk | Unnamed: 13 | Month: | Unnamed: 15 | Unnamed: 16 | Year: | Unnamed: 18
PPI: |  | 001 | Flow Measuring Point: |  |  |  |  |  |  | Parameter Monitoring Point:
Parameter Code |  |  | 50050 | 00310 | 00680 | 00940 | 50060 | 31616 | 00610 | 00620 | 00400 | 00545 | 70295 | 00530 | 00076
Day | ORC Arrival Time | ORC Time On Site | Flow | BOD5 | Total Organic Carbon | Chloride | Total Residual Chlorine | Fecal Coliform | Ammonia | Nitrate | pH | Settleable Solids | Total Dissolved Solids | Total Suspended Solids | Turbidity
 | 24-hr | hrs | GPD | mg/L | mg/L | mg/L | mg/L | #/100 mL | mg/L | mg/L | su | mL/L | mg/L | mg/L | NTU
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
26
27
28
29
30
31
Average:
Daily Maximum:
Daily Minimum:
Sampling Type: |  |  | Recorder | Composite | Grab | Grab | Grab | Grab | Composite | Grab | Grab | Grab | Grab | Composite | Recorder
Monthly Limit: |  |  | 120000 | 10 |  |  |  | 14 | 4 |  |  |  |  | 5
Daily Limit: |  |  |  | 15 |  |  |  | 25 | 6 |  | 6-9 |  |  | 10 | 10
Sample Frequency: |  |  | Continous | See Permit | 3 x Year | 3 x Year | 5 x Week | See Permit | See Permit | 3 x Year | 3 x Year | 5 x Week | 3 x Year | See Permit | [NAME]
 |  | Average
 |  | Geomean
 |  | MAX/MIN
Spreadsheet: 582222d1531787595-counting-number-of-days-in-overlapping-date-ranges-counting-number-of-days-in-overlapping-date-ranges
Sheet: Arkusz1

Start date | End date | numer of days | excl overlapiing
2018-02-01 00:00:00 | 2018-02-05 00:00:00 |  | 4
2018-02-03 00:00:00 | 2018-02-15 00:00:00 |  | 10
2018-03-02 00:00:00 | 2018-03-05 00:00:00 |  | 3
2018-03-12 00:00:00 | 2018-03-16 00:00:00 |  | 4
Spreadsheet: 712832d1610440442-how-to-add-formula-for-dynamic-drop-down-list-to-data-validation-share-excel-sheet-with-questions
Sheet: Reference sheet

Category | Type
Animal | Pig
Animal | Dog |  | 1
Animal | Cat |  | 2
Animal | Elephant |  | 4
Bird | Flamingo |  | 6
Bird | Eagle
Bird | Emu
Bird | [NAME]
Country | Australia
Fish | Goldfish
Fish | Tuna
Fish | Catfish
Person | Emma
Plant | Rose
Plant | Tree
Plant | Shrub
Reptile | Snake
Reptile | Lizard
Reptile | Gecko
Reptile | turtle
Spreadsheet: 16bcab55-4bd6-4ca5-9655-547da6b0af36
Sheet: Sheet1

Effort Certification Report
4/1/2013-9/30/2013
[NAME]: |  | LName, Fname
Employee ID: |  | 555555
Title: |  | Professor
Department: |  | Department
[NAME]: |  | [EMAIL]
Accounts |  |  |  |  | Payroll | Cost Share | Committed Effort |  | Certified Effort |  |  | Initial
Sponsored
 | 31-xxxxxx | Sponsored Project 1 |  |  | 0 | 0
 | 44-xxxxxx | Sponsored Project 2 |  |  | 0 | 0
 | Sponsored Total
Non-Sponsored
 | 11-xxxxxx-50010 | Academic Dept - Payroll |  |  | 0 | 0
 | 11-xxxxxx-50060 | [NAME] |  |  | 0 | 0 | 0
 | Non-Sponsored Total |  |  |  |  | 0 | 0
 | Grand Total |  |  |  |  | 0
I certify that the information contained above is a true and accurate representation of my professional effort during the period listed.
I certify that any salary direct-charged, transferred, cost-shared, or otherwise committed towards any externally funded project was
for the benefit of that project, and consistent with proposal and award requirements.  I further certify that I have first-hand knowledge
of all effort certified herein.
Print Name:
Comments: |  |  |  | Signature: |  |  |  |  | Date:
Spreadsheet: 151237d1334838226-vlookup-based-on-table-forum
Sheet: Sheet1

Table |  |  |  |  |  |  | Vlookup Table
S.No | Salesmen | East | West | North | South |  | S.No | Salesmen | East | West | North | South
1 | B | 0 | 16 | 4 | 0 |  | 5 | A
2 | A | 25 | 0 | 0 | 4 |  | 4 | B
3 | C | 0 | 0 | 0 | 0 |  | 3 | C
4 | D | 0 | 0 | 0 | 0 |  | 2 | D
5 | E | 0 | 9 | 0 | 15 |  | 1 | E
Spreadsheet: 647744d1572610906-closest-match-with-multiple-criteria-3-criteria-boxes-breakdown-closest-match-sample
Sheet: Sheet1

ID | length | width |  |  |  | [NAME] | length | width
1 | 600 | 400 |  |  |  | Cont1 | 450 | 305
2 | 400 | 300 |  |  |  | Cont2 | 800 | 500
3 | 200 | 150 |  |  |  | Cont3 | 600 | 402
 |  |  |  |  |  | Cont4 | 250 | 200
 |  | WORKING
ID | length | width | depth |  |  | [NAME] | length | width | depth
1 | 600 | 400 | 119 |  |  | Cont1 | 450 | 305 | 430
2 | 400 | 300 | 220 |  |  | Cont2 | 800 | 500 | 135
3 | 200 | 150 | 420 |  |  | Cont3 | 600 | 402 | 250
 |  |  |  |  |  | Cont4 | 250 | 200 | 175
 |  | DON'T KNOW HOW TO GET WORKING
Spreadsheet: 793666d1661620863-generate-a-list-of-a-filtered-dataset-generatelists
Sheet: GenerateLists

Name | Put/Call | Strike | Amount
A29 | P | 700 | 4
AEX | P | 725 | -10
A29 | P | 713 | -1
A29 | P | 718 | 3
A29 | C | 722 | -3
A29 | C | 718 | 8
A29 | C | 720 | 3
A29 | C | 716 | -5
A29 | P | 712 | 1
A29 | P | 717 | -3
A29 | P | 716 | -5
AEX | P | 710 | -4
AEX | C | 700 | -2
AEX | P | 700 | 3
AEX | C | 715 | 4
AEX | C | 710 | -4
AEX | P | 705 | 4
AEX | P | 700 | 4
AEX | C | 730 | 5
AEX | P | 720 | 1
AEX | C | 755 | 2
Unique names (extrcted by UNIQUE; there could be more)
AEX
Sorted array on Strike with Amount > 0 for P of each unique name (how can I loop through all and create the following?)
 | #REF! | #REF! | #REF!
#REF! | #REF! | #REF! | #REF!
#REF! | #REF! | #REF! | #REF!
 | #REF! | #REF! | #REF!
#REF! | #REF! | #REF! | #REF!
#REF! | #REF! | #REF! | #REF!
Sorted array on Strike with Amount < 0 for P of each unique name
 | #REF! | #REF! | #REF!
#REF! | #REF! | #REF! | #REF!
#REF! | #REF! | #REF! | #REF! |  | Remark: October
#REF! | #REF! | #REF! | #REF! |  | Remark: November
 | #REF! | #REF! | #REF!
#REF! | #REF! | #REF! | #REF!
Hoe can I do this?
list to generate for each unique name
A29 | P | 718 |  | 717
A29 | P | 718 |  | 717
A29 | P | 718 |  | 717
A29 | P | 712 |  | 715
A29 | P | 700 |  | 715
A29 | P | 700 |  | 715
A29 | P | 700 |  | 715
A29 | P | 700 |  | 715
A29 | P |  |  | 713
AEX | P | 720 |  | 725
AEX | P | 705 |  | 725
AEX | P | 705 |  | 725
AEX | P | 705 |  | 725
AEX | P | 705 |  | 725
AEX | P | 700 |  | 725
AEX | P | 700 |  | 725
AEX | P | 700 |  | 725
AEX | P | 700 |  | 725
AEX | P | 700 |  | 725
AEX | P | 700 |  | 710
AEX | P |  |  | 710
AEX | P |  |  | 710
Spreadsheet: 680319d1590945001-vlookup-and-substitute-excelforum-example
Sheet: Sheet1

 | Comparison File |  |  | Main Table |  |  |  | Table A
 |  |  |  | [NAME] | 350 |  |  | [NAME] | 7500
 |  |  |  | [NAME] | 1350 |  |  | [NAME] | 900
 |  |  |  | B.J Novak | 850 |  |  | [NAME] | 1350
 |  |  |  | Carol-Anne Smith | 7000 |  |  | [NAME] | 350
Spreadsheet: 872213d1718630476-copying-a-group-of-cells-and-pasting-it-1000-times-book1
Sheet: Sheet1

 |  |  |  | 964 | 643 | 881 | 529 |  |  |  | 643 | 881 | 529
 |  |  |  | 566 | 255 | 585 | 275 |  |  |  | 255 | 585 | 275
 |  |  |  | 370 | 962 | 666 | 452 |  |  |  | 962 | 666 | 452
 |  |  |  | 681 | 647 | 474 | 589 |  |  |  | 647 | 474 | 589
 |  |  |  | 255 | 151 | 556 | 262 |  |  |  | 151 | 556 | 262
 |  |  |  | 566 | 795 | 334 | 376 |  |  |  | 795 | 334 | 376
 |  |  |  | 711 | 452 | 580 | 749 |  |  |  | 452 | 580 | 749
 |  |  |  | 361 | 373 | 662 | 875 |  |  |  | 373 | 662 | 875
 |  |  |  | 130 | 681 | 859 | 420 |  |  |  | 681 | 859 | 420
 |  |  |  | 589 | 214 | 219 | 653 |  |  |  | 214 | 219 | 653
 |  |  |  | 573 | 729 | 850 | 308 |  |  |  | 729 | 850 | 308
 |  |  |  | 760 | 263 | 722 | 441 |  |  |  | 263 | 722 | 441
 |  |  |  |  |  |  |  |  |  |  | 643 | 881 | 529
 |  |  |  |  |  |  |  |  |  |  | 255 | 585 | 275
 |  |  |  |  |  |  |  |  |  |  | 962 | 666 | 452
 |  |  |  |  |  |  |  |  |  |  | 647 | 474 | 589
 |  |  |  |  |  |  |  |  |  |  | 151 | 556 | 262
 |  |  |  |  |  |  |  |  |  |  | 795 | 334 | 376
 |  |  |  |  |  |  |  |  |  |  | 452 | 580 | 749
 |  |  |  |  |  |  |  |  |  |  | 373 | 662 | 875
 |  |  |  |  |  |  |  |  |  |  | 681 | 859 | 420
 |  |  |  |  |  |  |  |  |  |  | 214 | 219 | 653
Spreadsheet: 104290d1301932343-excel-2007-transfer-only-data-with-a-value-book1
Sheet: Result

Materials List
Item Description |  | Qty. |  | Unit |  | Total
 |  |  |  | Price |  | Price/Row
interior framing | 2x4x8 | 15 | pcs. | 2.99 | /pc.
exterior framing | 2x6x10 | 200 | pcs. | 10.99 | /pc.
framing | 2x12x10 | 1 | pcs. | 14.99 | /pc.