tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 211928d1359992347-pull-data-based-on-day-of-week-from-another-workbook-for-previous-three-weeks-salesreport2013
Sheet: 0102

 | Date: | 2013-01-02 00:00:00
 | Day:
 | Time | Trans. | Total Sales | Avg. Sales
 | 09:00:00 | 0 | 0
 | 10:00:00 | 8 | 35.76
 | 11:00:00 | 54 | 265.31
 | 12:00:00 | 109 | 579.11
 | 13:00:00 | 67 | 356.68
 | 14:00:00 | 43 | 200.87
 | 15:00:00 | 40 | 197.7
 | 16:00:00 | 41 | 263.13
 | 17:00:00 | 60 | 472.37
 | 18:00:00 | 59 | 429.11
 | 19:00:00 | 43 | 293.17
 | 20:00:00 | 39 | 219.37
 | 21:00:00 | 33 | 218.43
 | 22:00:00 | 30 | 186.86
 | 23:00:00 | 14 | 97.29
 | 1900-01-01 00:00:00 | 13 | 31.14
 | 1900-01-01 01:00:00 | 0 | 0
 | 1900-01-01 02:00:00 | 0 | 0
 | 1900-01-01 03:00:00 | 0 | 0
 | 04:00:00 | 0 | 0
 | Total
Spreadsheet: 5e0776ed-2b03-4671-9577-c8ccf426d55d
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2014-04-01 09:31:45.650000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.875 | 102.875 | 102.75 | 102.625 | 102.25 |  | and are added to price quote
4.75 | 102.704 | 102.579 | 102.454 | 102.079
4.625 | 101.944 | 101.819 | 101.694 | 101.319 |  | Note: | Refer To Price [NAME]
4.5 | 101.005 | 100.88 | 100.755 | 100.38 |  |  | For all Price Adjs
4.375 | 100.086 | 99.961 | 99.836 | 99.211
4.25 | 99.508 | 99.383 | 99.258 | 98.633
4.125 | 98.677 | 98.552 | 98.427 | 97.802
4 | 97.659 | 97.534 | 97.409 | 96.784
3.875 | 96.61 | 96.485 | 96.36 | 95.735
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4 | 102.853 | 102.728 | 102.603 | 102.228
3.875 | 102.162 | 102.037 | 101.912 | 101.537
3.75 | 101.8 | 101.675 | 101.55 | 101.175
3.625 | 101.36 | 101.235 | 101.11 | 100.735
3.5 | 100.81 | 100.685 | 100.56 | 99.935
3.375 | 100.015 | 99.89 | 99.765 | 99.14
3.25 | 99.237 | 99.112 | 98.987 | 98.362 |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2014-04-15 09:31:45.650000
30 DAY | 2014-04-30 09:31:45.650000
45 DAY | 2014-05-15 09:31:45.650000
60 DAY | 2014-05-30 09:31:45.650000
90 DAY | 2014-06-29 09:31:45.650000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 63840d1264703290-looking-up-multiple-values-index-match-sample
Sheet: MultipleRows

Select/Change an ID here >> |  |  | 1236 | 4 |  |  | Example Data - this could be hidden, or even on another sheet
Key | Invoice # | Amount | Date |  |  |  | Key | Cust ID# | Invoice # | Amount | Date
1 | ABA06 | 600 | 2008-03-08 00:00:00 |  |  |  | 0 | 1231 | ABA01 | 100 | 2008-03-03 00:00:00
2 | ABA14 | 1400 | 2008-03-16 00:00:00 |  |  |  | 0 | 1232 | ABA02 | 200 | 2008-03-04 00:00:00
3 | ABA22 | 2200 | 2008-03-24 00:00:00 |  |  |  | 0 | 1233 | ABA03 | 300 | 2008-03-05 00:00:00
4 | ABA30 | 3000 | 2008-04-01 00:00:00 |  |  |  | 0 | 1234 | ABA04 | 400 | 2008-03-06 00:00:00
5 |  |  |  |  |  |  | 0 | 1235 | ABA05 | 500 | 2008-03-07 00:00:00
6 |  |  |  |  |  |  | 1 | 1236 | ABA06 | 600 | 2008-03-08 00:00:00
7 |  |  |  |  |  |  | 1 | 1237 | ABA07 | 700 | 2008-03-09 00:00:00
8 |  |  |  |  |  |  | 1 | 1238 | ABA08 | 800 | 2008-03-10 00:00:00
9 |  |  |  |  |  |  | 1 | 1231 | ABA09 | 900 | 2008-03-11 00:00:00
10 |  |  |  |  |  |  | 1 | 1232 | ABA10 | 1000 | 2008-03-12 00:00:00
11 |  |  |  |  |  |  | 1 | 1233 | ABA11 | 1100 | 2008-03-13 00:00:00
12 |  |  |  |  |  |  | 1 | 1234 | ABA12 | 1200 | 2008-03-14 00:00:00
13 |  |  |  |  |  |  | 1 | 1235 | [NAME] | 1300 | 2008-03-15 00:00:00
14 |  |  |  |  |  |  | 2 | 1236 | ABA14 | 1400 | 2008-03-16 00:00:00
15 |  |  |  |  |  |  | 2 | 1237 | ABA15 | 1500 | 2008-03-17 00:00:00
16 |  |  |  |  |  |  | 2 | 1238 | ABA16 | 1600 | 2008-03-18 00:00:00
17 |  |  |  |  |  |  | 2 | 1231 | ABA17 | 1700 | 2008-03-19 00:00:00
18 |  |  |  |  |  |  | 2 | 1232 | ABA18 | 1800 | 2008-03-20 00:00:00
19 |  |  |  |  |  |  | 2 | 1233 | ABA19 | 1900 | 2008-03-21 00:00:00
20 |  |  |  |  |  |  | 2 | 1234 | ABA20 | 2000 | 2008-03-22 00:00:00
21 |  |  |  |  |  |  | 2 | 1235 | ABA21 | 2100 | 2008-03-23 00:00:00
22 |  |  |  |  |  |  | 3 | 1236 | ABA22 | 2200 | 2008-03-24 00:00:00
23 |  |  |  |  |  |  | 3 | 1237 | ABA23 | 2300 | 2008-03-25 00:00:00
24 |  |  |  |  |  |  | 3 | 1238 | ABA24 | 2400 | 2008-03-26 00:00:00
25 |  |  |  |  |  |  | 3 | 1231 | ABA25 | 2500 | 2008-03-27 00:00:00
26 |  |  |  |  |  |  | 3 | 1232 | ABA26 | 2600 | 2008-03-28 00:00:00
27 |  |  |  |  |  |  | 3 | 1233 | ABA27 | 2700 | 2008-03-29 00:00:00
28 |  |  |  |  |  |  | 3 | 1234 | ABA28 | 2800 | 2008-03-30 00:00:00
29 |  |  |  |  |  |  | 3 | 1235 | ABA29 | 2900 | 2008-03-31 00:00:00
30 |  |  |  |  |  |  | 4 | 1236 | ABA30 | 3000 | 2008-04-01 00:00:00
 |  |  |  |  |  |  | 4 | 1237 | ABA31 | 3100 | 2008-04-02 00:00:00
 |  |  |  |  |  |  | 4 | 1238 | ABA32 | 3200 | 2008-04-03 00:00:00
Spreadsheet: darrell_schoolcraft__7266__saledoc02_22TW
Sheet: Sheet1

Transwestern Pipeline Company
GAS [NAME]
 | GAS SALE INFORMATION |  |  |  |  | PURCHASE PARTY
Account Manager |  |  | [NAME] |  |  | Company: |  | Astra Power
Deal Date: |  |  | 2002-02-21 00:00:00 |  |  | Contact Name: |  | [NAME]
Gas Sale Date (s) |  |  | 2/21/2002 |  |  | FAX Number:
Total Quantity |  |  | 10133 | MMBtu |  | Address: |  | Phone: [PHONE]
Gas Sale Price |  |  | 2.24
GAS SALE TERMS
 |  | Contract Quantity (MMBtu)
SALE DATES |  |  |  | Daily
Start | End | Monthly |  | Min |  | [NAME] |  | Other
2/21/2002 | 2002-02-21 00:00:00 | 10133 |  | 10133 |  | 10133
RELATED SCHEDULING AND TRANSPORTATION REQUIREMENTS
Tranwestern Receipt/Delivery Point |  |  |  |  |  |  | DOWNSTREAM |  | TW UPSTREAM
Name |  |  | POI # |  | Daily Volume |  | Contract # |  | Contract Number
WT Pool |  |  | 58646 |  | 10133 |  |  |  | 22948
 |  |  | BILLING BY THIRD PARTY |  |  |  |  | Please direct all invoices to:
 |  |  | Month [NAME] Rec'd |  | Expected [NAME] |  |  | Debbie Mosely
 |  |  |  |  | To be determined |  |  | Transwestern Pipeline Company
 |  |  |  |  |  |  |  | P.O. Box 1188
 |  |  |  |  |  |  |  | Houston, TX  77251-1188
Comments:
Buyer: Please acknlowledge confirmation of the above deal by signing below and faxing this confirmation to:
[NAME] [PHONE]   Phone [PHONE]
Gas Buyer Signature |  |  |  |  |  |  | Date:
TW Acct Manager Signature |  |  |  |  |  |  | Date:
Spreadsheet: 856649d1705854706-concatenate-with-indirect-function-21012024-sample-file-for-xlforum
Sheet: Xls12

BrCd | PrdCd | AcctId
4 | 515 | 426
3 | 809 | 14029
15 | 751 | 412
6 | 601 | 1628
9 | 601 | 14036
24 | 755 | 17
8 | 601 | 18
23 | 753 | 1
2 | 805 | 3
4 | 414 | 4
2 | 601 | 1
6 | 712 | 53
2 | 601 | 14048
4 | 809 | 14029
18 | 751 | 412
27 | 601 | 1628
26 | 601 | 14036
11 | 755 | 17
45 | 601 | 18
Spreadsheet: 827335d1682613345-if-then-else-formula-statement-isblank-excel-formula-sample
Sheet: Sheet1

 |  |  |  |  |  |  | Policy Spend Limit: |  |  | 13 | 15 | 25
Employee Name | Employee State | Employee Program | Card ID Number | Transaction Number | Transaction Date | Submitted CC Statement with receipts | Does receipt contain an itemized list of purchase? | Is purchase authorized by CC Policy? | Meal Purchase | Breakfast: $13.00 | Lunch: $15.00 | Dinner: $25.00 | Was meal purchase within limits set in Policy? | Tip | Calculated Tip Limit per Policy (20%) | Was tip within limits set forth in Policy?
 |  |  |  |  |  |  |  |  |  |  |  | 26
 |  |  |  |  |  |  |  |  |  |  | 10
Spreadsheet: 99104d1297859928-vlookup-result-not-clickable-hyperlink-concept-structuur-hyperlink-documentatie
Sheet: Sheet2

Nummer | KA2S | MCP | Omkasting | LCP/DCS | samengevoegd | Hyperlink
 | 1 | 0 | 1 | 1 | 1011 | C:\test
 | 1 | 0 | 1 | 0 | 1010 | \\\C:\test
 | 1 | 0 | 0 | 0 | 1000 | Hyperlink4
 |  |  |  |  |  | #N/A
 |  |  |  |  |  | #N/A
 |  |  |  |  |  | #N/A
 |  |  |  |  |  | #N/A
 |  |  |  |  |  | #N/A
Spreadsheet: 8b68866f-bff7-4c08-90b7-59247d5e56b2
Sheet: Sheet1

RECALL | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | normal; MPG | normal; MPG (variant positions) | cell culture; MPG | cell culture; MPG (variant positions) | cell culture; MPV
all positions | 0.988 | 0.9846 | 0.846 | 0.80671 | 0.94812
no hidden SNPs | 0.988 | 0.98441 | 0.842 | 0.80598 | 0.94677
no hidden SNPs; cnv OK | 0.993 | 0.99029 | 0.912 | 0.87976 | 0.96275
PRECISION
 | normal; MPG | normal; MPG (variant positions) | cell culture; MPG | cell culture; MPG (variant positions) | cell culture; MPV
all positions | 0.99895 | 0.98108 | 0.99898 | 0.97649 | 0.9785
no hidden SNPs | 0.99914 | 0.98066 | 0.99917 | 0.97603 | 0.9781
no hidden SNPs; cnv OK | 0.99937 | 0.99893 | 0.99939 | 0.9988 | 0.99788
Spreadsheet: 779331d1651702281-if-then-formula-help-22-01a-forney-hs-paving-audit
Sheet: CONTRACT AWARD

PO # | CSP # | SCOPE | CONTRACTOR | BASE | ALLOWANCE | ALT#1 - Replace Existing Light Poles & Fixtures | ADJUSTMENTS | TOTAL PROJECT | COMMENTS | TOTAL SHEET | ALTERNATES | DIFFERENCE
 | 26-A | Electrical | Intex Electrical Contractors, Inc. | 33546 |  | 28985 |  |  |  | 33564 | 28985
 | 31-A | Excavation | The Holbrook Company, Inc. | 83845 |  |  |  |  |  | 83845
 | 32-A | Concrete Paving | JDS Contractors LLC | 295300 | 50000 |  |  |  |  | 345300
 |  | Pole Bases for Alt. 1 | Estimate - BA to [NAME], if required |  |  | 3000 |  |  |  |  | 3000
 | 32-B | Landscape and Irrigation | Texas Yard Pro, INC. | 46640 | 5000 |  |  |  |  | 51640
 | 33-A | Site Utilities | J&K Moore Enterprises LLC | 35000 |  |  |  |  |  | 95000
 |  | Survey and Layout | Estimate | 2500 |  |  |  |  |  | 2500
 |  | Temporary Construction Fence | Estimate | 7500 |  |  |  |  |  | 7500
 |  | Temporary Toilets | Estimate | 5000 |  |  |  |  |  | 5000
 |  | Subsurface Investigation - Utility Locate | Estimate | 10000 |  |  |  |  |  | 10000
 |  | Clean Up Equipment | Estimate | 5000 |  |  |  |  |  | 5000
 |  | Grading Equipment | Estimate | 5000 |  |  |  |  |  | 5000
 |  | General Cleanup | Estimate | 10000 |  |  |  |  |  | 10000
 |  | SWPPP Book/Silt Fence & Repairs | Estimate | 15000 |  |  |  |  |  | 15000
 |  | Mailing/Shipping Provisions/Printing | Estimate | 500 |  |  |  |  |  | 500
 |  | Close-Out Documentation Scanning Fee | Estimate | 5000 |  |  |  |  |  | 5000
 |  | Builders Risk | Estimate | 2500 |  |  |  |  |  | 2500
 |  | Contruction Contingency | Estimate | 50000 |  |  |  |  |  | 50000
 |  | [NAME] and General Requirements | Gallagher | 63368 |  | 3217 |  |  |  | 63368 | 3217 |  | Rounding off by $1
CONSTRUCTION COSTS TOTAL
FEES AND OWNER'S DIRECT EXPENSES
 |  | Civil Engr Fees | Estimate | 39536 |  | 2640 |  |  |  | 39536 | 2640
 |  | Geotechnical Reports | Estimate | 10000 |  |  |  |  |  | 10000
 |  | Material Testing and Inspection | Estimate | 20000 |  |  |  |  |  | 20000
 |  | Printing | Estimate | 500 |  |  |  |  |  | 500
 |  | Construction Waste Removal Services | Estimate | 10000 |  |  |  |  |  | 10000
 |  | Building Permit/Plan Review/Inspections | Estimate | 7500 |  |  |  |  |  | 7500
 |  | TAS Reviews and Inspections | Estimate | 2000 |  |  |  |  |  | 2000
FEES AND OWNER'S DIRECT EXPENSES TOTAL
FURNITURE ,FIXTURES, & EQUIPMENT (FF&E)
 |  | Furniture, Fixtures, and Equipment |  | 0 |  |  |  |  |  | 0
FURNITURE ,FIXTURES, & EQUIPMENT (FF&E) TOTAL
[NAME]
 |  | Owner Contingency | Estimate | 25000 |  |  |  |  |  | 25000
[NAME] CONTINGENCIES TOTAL
TOTAL COST
 |  |  |  |  |  |  |  | 943094
 |  |  | Contractor | Total Sheet | Contracts | Difference | Comments
 |  |  | Intex Electrical Contractors, Inc. | 62549 | 62531 |  | Base number trasposed on Total Sheet, Added back in to construction contingency
 |  |  | J&K Moore Enterprises LLC | 95000 | 35000 |  | Total sheet had $95,000; Actual Contract $35,000 - Added $60,000 in to construction contingency
 |  |  | CM Fee | 66584 | 66585 |  | Rounding issue
Spreadsheet: 0db8de16-1cb6-41ca-88ae-3d17a56dea6c
Sheet: Sheet1

a | 10000 | ft
b | 12000 | ft
S | 0.1
T | 4000 | ft^2/day
4T/S
 |  |  |  | Pumping | 2-ps | 3-1s | 6-4s | 7-5s | 9-8s |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pumping | 2-ps | 3-1s | 6-4s | 7-5s | 9-8s
a mult |  |  |  | 1 | 1 | 3 | 3 | 5 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 3 | 3 | 5 | 5
b mult |  |  |  | 0 | 2 | 2 | 4 | 4 | 6 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 2 | 2 | 4 | 4 | 6 | 6
 |  |  |  | 1 | -1 | 1 | -1 | 1 | -1 | 1
t (days) | River_a | River_b | Sum | 1 |  |  |  |  |  | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  | 7
50
a
b
 |  |  |  | Pumping | 2-ps | 3-1s | 6-4s | 7-5s | 9-8s |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pumping | 2-ps | 3-1s | 6-4s | 7-5s | 9-8s
a mult |  |  |  | 1 | 1 | 3 | 3 | 5 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 3 | 3 | 5 | 5
b mult |  |  |  | 0 | 2 | 2 | 4 | 4 | 6 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 2 | 2 | 4 | 4 | 6 | 6
 |  |  |  | 1 | -1 | 1 | -1 | 1 | -1 | 1
t | River_a |  |  | 1 |  |  |  |  |  | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  | 7
Spreadsheet: 484670d1476379436-case-when-testfile-1-
Sheet: MasterSheet1

BRO. OBED |  | FILIPINO | ENGLISH | MATHEMATICS | SCIENCE | A/P | TLE | MAPEH | CLE |  |  |  | GEN AVERAGE | HR/ESP | CONDUCT | EXTRA CUR | EXTRA CUR LG | HONORS
1 | TEST | 85 | 89 | 90 | 92 | 93 | 97 | 88 | 87 |  | 88 |  |  | 86 | 89 | 90
2 | TEST1 | 75 | 75 | 83 | 74 | 79 | 99 | 79 | 86 |  | 83 |  |  | 76 | 79 | 74
3 | TEST12 | 85 | 88 | 85 | 85 | 85 | 88 | 88 | 86 |  | 88 |  |  | 87 | 88 | 89
4 | TEST123 | 89 | 87 | 77 | 88 | 78 | 77 | 85 | 86 |  | 90 |  |  | 80 | 87 | 88
5 | TEST1234 | 75 | 79 | 80 | 87 | 88 | 72 | 85 | 86 |  | 90 |  |  | 90 | 87 | 78
6 | TEST12345 | 85 | 86 | 87 | 88 | 89 | 90 | 91 | 92 |  | 94 |  |  | 96 | 97 | 98
7 | TEST123456 | 90 | 97 | 95 | 91 | 92 | 95 | 96 | 97 |  | 90 |  |  | 97 | 97 | 98
Spreadsheet: 207069d1358355335-excel-filtering-book1
Sheet: Sheet1

Type | Period | Name | Campaign Details |  |  | Offer Details & Logistics |  |  |  |  |  |  |  | Project  Brief | Creative |  |  | Data(Targeting [NAME]) |  | Comments | Overall Status
 |  |  | Elements | Start | End  (Or Quantity, if Direct Mail) | Promtional Offer | Type | Start | End | SKU List | IDs |  | [NAME] | Status | English Status -1st Proof | French Status -2nd Proof | Artwork Drop Dead Due - FINAL | Status | Drop Dead Date
 |  |  |  |  |  |  |  |  |  |  | Event | Offer | 1.2.3. | 1.2.3. | 1.2.3. | 1.2.3. | DM (5 wks); In-Store (check); Web (3 wks) | 1.2.3. | DM (5 wks)
Brand Spotlight | P2 | Store 1 | In-Store POP(Flag) | 2013-01-26 00:00:00 | 2013-02-22 00:00:00 | Sample | Contest | 2013-01-26 00:00:00 | 2013-02-22 00:00:00 |  |  |  |  |  |  |  |  | N/A | 2012-01-09 00:00:00
 | P2 |  | Targeted E-mail | Jan 31st
 | P2 |  | Product Page | 2013-01-26 00:00:00 | 2013-02-22 00:00:00
 | P2 |  | All Optimum Offers | 2013-01-26 00:00:00 | 2013-02-22 00:00:00
One-to-One | P2 | Store 2 | Sampling(300 Stores) | 2013-02-23 00:00:00 | 2013-03-08 00:00:00 | Sample | In-Store Sampling Event | 2012-02-23 00:00:00 | 2012-03-08 00:00:00
Direct Mail | P2 |  | Direct Mail 35K | 2013-02-11 00:00:00
Brand Spotlight | P2 | Store 3 | In-Store Pop (Flag & Wobbler) | 2013-02-02 00:00:00 | 2013-03-01 00:00:00 | Sample | In-Store Event | 2012-02-02 00:00:00 | 2012-03-01 00:00:00 |  |  |  |  |  |  |  |  | N/A | N/A
 | P2 |  | Targeted E-mail | 2013-02-02 00:00:00
 | P2 |  | Enhanced Product Page | 2013-02-02 00:00:00 | 2013-03-01 00:00:00
Spreadsheet: 83958d1283973508-excel-2007-transferring-cell-properties-across-sheets-with-live-updates-milk-book
Sheet: Customers&Orders

Address | Type |  | Monday | Wednesday | Friday
1 [NAME] | 1L ss |  | 1 | 3 | 2
3 Pusti Ave | 2L pas |  | 1 | 0 | 1
 | 1p OJ |  | 1 | 0 | 2
5 Twat Close | 1L ss org |  |  | 2 | 3
Spreadsheet: 71241d1271935359-date-picker-and-display-temp
Sheet: Sheet1

1st visit | 2nd visit | 3rd visit | 4th visit | 5th visit | 6th visit | 7th visit | 8th visit | 9th visit | 10th visit | 11th visit | 12th visit | 2010-04-22 00:00:00
2009-06-15 00:00:00 | 2009-07-15 00:00:00 | 2009-08-15 00:00:00 | 2009-09-15 00:00:00 | 2009-10-15 00:00:00 | 2009-11-15 00:00:00 | 2009-12-15 00:00:00 | 2010-01-15 00:00:00 | 2010-02-15 00:00:00 | 2010-03-15 00:00:00 | 2010-04-15 00:00:00 | 2010-05-15 00:00:00
2009-01-04 00:00:00 | 2009-02-04 00:00:00 | 2009-03-04 00:00:00 | 2009-04-04 00:00:00 | 2009-05-04 00:00:00 | 2009-06-04 00:00:00 | 2009-07-04 00:00:00 | 2009-08-04 00:00:00 | 2009-09-04 00:00:00 | 2009-10-04 00:00:00 | 2009-11-04 00:00:00 | 2009-12-04 00:00:00
2009-04-15 00:00:00 | 2009-05-15 00:00:00 | 2009-06-15 00:00:00 | 2009-07-15 00:00:00 | 2009-08-15 00:00:00 | 2009-09-15 00:00:00 | 2009-10-15 00:00:00 | 2009-11-15 00:00:00 | 2009-12-15 00:00:00 | 2010-01-15 00:00:00 | 2010-02-15 00:00:00 | 2010-03-15 00:00:00
2009-07-18 00:00:00 |  | 2009-09-18 00:00:00 |  | 2009-11-18 00:00:00 |  | 2010-01-18 00:00:00 |  | 2010-03-18 00:00:00 |  | 2010-05-18 00:00:00
2009-06-15 00:00:00 |  | 2009-08-15 00:00:00 |  | 2009-10-15 00:00:00 |  | 2009-12-15 00:00:00 |  | 2010-02-15 00:00:00 |  | 2010-04-15 00:00:00
[NAME] required : m2 .. M6 : (Column A2 to L6) visit date as per due date calculte with start date. I want formula in m2 which date between current month. Display today system date in column : m1
1st visit | 2nd visit | 3rd visit | 4th visit | 5th visit | 6th visit | 7th visit | 8th visit | 9th visit | 10th visit | 11th visit | 12th visit | 2010-04-22 00:00:00
2009-06-15 00:00:00 | 2009-07-15 00:00:00 | 2009-08-15 00:00:00 | 2009-09-15 00:00:00 | 2009-10-15 00:00:00 | 2009-11-15 00:00:00 | 2009-12-15 00:00:00 | 2010-01-15 00:00:00 | 2010-02-15 00:00:00 | 2010-03-15 00:00:00 | 2010-04-15 00:00:00 | 2010-05-15 00:00:00 | 2010-04-15 00:00:00
2009-01-04 00:00:00 | 2009-02-04 00:00:00 | 2009-03-04 00:00:00 | 2009-04-04 00:00:00 | 2009-05-04 00:00:00 | 2009-06-04 00:00:00 | 2009-07-04 00:00:00 | 2009-08-04 00:00:00 | 2009-09-04 00:00:00 | 2009-10-04 00:00:00 | 2009-11-04 00:00:00 | 2009-12-04 00:00:00
2009-04-15 00:00:00 | 2009-05-15 00:00:00 | 2009-06-15 00:00:00 | 2009-07-15 00:00:00 | 2009-08-15 00:00:00 | 2009-09-15 00:00:00 | 2009-10-15 00:00:00 | 2009-11-15 00:00:00 | 2009-12-15 00:00:00 | 2010-01-15 00:00:00 | 2010-02-15 00:00:00 | 2010-03-15 00:00:00
2009-07-18 00:00:00 |  | 2009-09-18 00:00:00 |  | 2009-11-18 00:00:00 |  | 2010-01-18 00:00:00 |  | 2010-03-18 00:00:00 |  | 2010-05-18 00:00:00
2009-06-15 00:00:00 |  | 2009-08-15 00:00:00 |  | 2009-10-15 00:00:00 |  | 2009-12-15 00:00:00 |  | 2010-02-15 00:00:00 |  | 2010-04-15 00:00:00
Spreadsheet: 765167d1643201591-lookup-first-and-last-instance-of-text-in-range-and-return-column-heading-data-lookup-copy
Sheet: Sheet1

 | 2022-01-29 00:00:00
[NAME] | C3265 | D101 | D101 (finish off) | Finish C3265 | L0944 | L0944
[NAME] | C3265 | C3265 | C3265 | Annual leave | Annual leave | Annual leave
Trevor | F565 (half day) | F565 | F565 | L1012 | L1012 | L1012 (& half day)
[NAME] | Half day and L1012 | L1012 | L1012 | L1012 | L1012 | L1012
Rebecca | M324A | M324B | M324C | S657 | B1016 | B1016, L1012
Lookup required (normally resides on another worksheet)
Task number | Start date [lookup] | End date [lookup]
D101 | 2022-01-30 00:00:00 | 2022-01-31 00:00:00
F565 | 2022-01-29 00:00:00 | 2022-01-31 00:00:00 |  | Output required from formula
B1016 | 2022-02-02 00:00:00 | 2022-02-03 00:00:00
L1012 | 2022-01-29 00:00:00 | 2022-02-03 00:00:00
Spreadsheet: benjamin_rogers__928__PJM Operational Summaries
Sheet: 02-20-02

2002-02-20 08:00:42
 | Operations Summary for Today's Forecast Peak
A | Internal Scheduled Capacity | 40893
B | Scheduled Tie Flows | 2630
C | Capacity Adjustments | 0
D | Total Scheduled Capability | 43523
E | PJM Load Forecast | 35000
F | Operating Reserve | 8523
G | Unscheduled Capacity | 6461
 | Scheduled Tie Flow Breakdown
H | APS | 1628
I | FE | 672
J | NYPP | 94
K | VP | 236
L | Total | 2630
M | Forecast Eastern Transfer Limit | 5300
N | Forecast Central Transfer Limit | 3800
O | Forecast Western Transfer Limit | 5200
 | Previous Periods Operation Summary
 |  | Day | Evening | Midnight
P | Hour | 800 | 1900 | 300
Q | PJM  [NAME] | 35500 | 35300 | 26500
R | Actual  Load | 35735 | 34527 | 26518
S | West Dispatch Rate ($/MWhr) | 54.74 | 25.45 | 17.48
T | East Dispatch Rate ($/MWhr) | 54.74 | 25.45 | 17.48