tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 817472d1676260673-how-to-highlight-more-than-one-column-after-non-sequential-number-date-sample-
Sheet: Sheet1

MONTHLY REPORT - Accural Basis
2023-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
Spreadsheet: 544699d1509005968-formula-required-to-extrapolate-values-test-excel-forum-1-
Sheet: City 2

 | 2017-10-01 00:00:00 | 2017-10-02 00:00:00 | 2017-10-03 00:00:00 | 2017-10-04 00:00:00 | 2017-10-05 00:00:00 | 2017-10-06 00:00:00 | 2017-10-07 00:00:00 | 2017-10-08 00:00:00 | 2017-10-09 00:00:00 | 2017-10-10 00:00:00
Company A | 650 | 1300 | 1950 | 2600 | 3250 | 3900 | 4550 | 5200 | 5850 | 6500
Company B | 56410 | 57060 | 57710 | 58360 | 59010 | 59660 | 132 | 5056 | 5650 | 560
Company C | 2565 | 3215 | 3865 | 4515 | 5165 | 5815 | 6465 | 7115 | 7765 | 8415
Company D | 44566 | 45216 | 45866 | 46516 | 47166 | 47816 | 48466 | 49116 | 49766 | 50416
Spreadsheet: 194228d1353082059-blue-arrow-on-my-screen-testing_result_for_forum
Sheet: Testing_Result

 | If From B3:V3 value is not TRUE then give count
 |  |  |  |  | 28
 | 28 | 29 | 29 | 27 | 28 | 28 | 27 | 57 | 38 | 28 | 50 | 28 | 28 | 28 | 28 | 2 | 28 | 28 | 28 | 28 | 28
 | 28 | 29 | 29 | 27 | 28 | 28 | 27 | 57 | 38 | 28 | 50 | 28 | 28 | 28 | 28 | 2 | 28 | 28 | 28 | 28 | 28
Spreadsheet: tracy_geaccone__40232__enron corp infomation request
Sheet: Europe IS

 |  | September
Gross Margin by Business Unit |  | Year-to-Date
Metals
Credit
Gas Trading
Continental Power Power Trading
Bilaterial Power Trading
Corp  Finance Origination
Asset Management
Continental Europe
Australia
Scandinavia
SE Europe
Switzerland/Austria
Germany
Spain/Portugal
Benelux/Italy
Japan
Teesside
ETOL
Other
Total Gross Margin
Operating Expenses |  | 0
Depreciation and Amortization |  | 0
Taxes Other Than Income |  | 0
Other Income (Loss) |  | 0
Income / (Loss) Before Interest & Taxes
(3)
Spreadsheet: 256669d1376080319-sum-time-shows-01-95-instead-of-02-35-sdgr-logsheet-template
Sheet: Invoices

SDGR | Invoices
Invoice # | Date | First Name | Last Name | [NAME] | Sold By | Tech | Time In | Time Out | Paid By | Code | Amount |  |  |  |  |  |  | Per Job | Total Time
G-101 | 2013-02-02 00:00:00 | Test | Tester | [EMAIL] | 35 | 65 | 1235 | 1435 | check | wp | 180
G-102 | 2013-02-05 00:00:00 | Flim | [NAME] | [EMAIL] | 35 | 65 | 730 | 945 | ccard | rc | 240
G-103 | 2013-03-11 00:00:00 | Zimm | [NAME] | [EMAIL] | 35 | 65 | 700 | 1030 | ccard | wp | 380
G-104 | 2013-04-01 00:00:00 | Zapple | Zipple | [EMAIL] | 35 | 65 | 1415 | 1448 | invoiced | rc | 175
G-105 | 2013-05-13 00:00:00 | [NAME] | [NAME] | [EMAIL] | 35 | 65 | 630 | 822 | ccard | wp | 495
[NAME] | 2013-06-13 00:00:00 | Whirly | Bucket | [EMAIL] | 35 | 65 | 648 | 822 | ccard | rf | 280
Spreadsheet: 889530d1740389291-write-off-ytd-data-automataed-write-off
Sheet: Summary by Reason YTD

 | Summary by Reason by Purchase Group YTD 2025
 | Category | Purchase Group | Old Warehouse |  |  | New Warehouse |  |  |  | Street 3 Warehouse |  | S920-Trade Return Goods | S930-General Merchandise | S940-Pharmacy | Grand Total | % by Purchase Group by [NAME]
 |  |  | S911-Pet Food | S912-Dabur | S902-Frozen | S905-Foodstuff | S907-Frozen | S909-Fruits & Vegetable | S917-Confectionery | S901-Foodstuff | S916-Non Food
 | Expired | Commerce |  | 41.8 |  | 85.44
 |  | Retail |  |  |  |  |  |  |  | 41.37 | 102.26
 | [NAME] | Commerce
 |  | Retail
 | Infested | Commerce
 |  | Retail
 | Quality Complaint | Commerce
 |  | Retail
 | Rejected by H.Athrty | Commerce
 |  | Retail
 | Return from Commerce | Commerce | 3701.639999999999 | 5939.170000000003 |  | 22232.65000000003 | 3909.589999999999 |  |  | 139.88 |  |  | 1128.02
 |  | Retail |  |  | 42.82 |  |  |  |  | 1002.12
 | Spoiled | Commerce | 79.36000000000001 | 938.4199999999998 |  | 212.4299999999999
 |  | Retail |  |  |  | 1052.96 |  | 600.79
 | Transit Damage | Commerce |  |  | 800.78 |  |  |  |  | 1665.49
 |  | Retail
 | Unhygienic Condition | Commerce
 |  | Retail
 | WH Damaged | Commerce | 239.27 | 1955.11 |  | 2669.28 | 121.08 |  |  |  |  |  | 141.24
 |  | Retail | 118.72 |  |  | 243 |  |  |  | 808.4 | 118.84
 | Double Date | Commerce
 |  | Retail
 | Total
 | % by Storage Location
Spreadsheet: 774730d1648637686-extract-data-from-qr-code-and-deduct-from-inventory-list-extract-qr-code-1-
Sheet: Blad1

data from QR code :
{"id":"OiF9mMKP","product_order_id":"67b92426-c9cf-4c51-9737-2e574bb4342d","product_sku":"F52"}
[NAME] | Antal
F70 | Deluxe [NAME] (4kg) 🇵🇹 | 12
F55 | [NAME] (5kg) 🇪🇸 | 11
F12 | Eko Mandarin (3kg) 🇪🇸 | 10
F52 | Eko [NAME] (2kg) 🇪🇸 | 8
F41 | Deluxe Apelsin (6kg) 🇵🇹 | 7
D49 | [NAME] (1kg) 🇩🇰 | 7
V21 | Eko Sötpotatis (3kg) 🇪🇸 | 6
F04 | [NAME] och Apelsin (3,5kg) 🇪🇸 | 6
V89 | Eko [NAME] (3kg) 🇪🇸 | 6
[NAME] | Eko körsbärstomater på kvist (2kg) 🇪🇸 | 5
V45 | Eko Potatis (4kg) 🇩🇰 | 5
V27 | [NAME] och Blomkål (3,5kg) 🇪🇸 | 5
F80 | [NAME] (3,5kg) 🇪🇸 | 5
V10 | Ekologiska miniplommontomater (2 kg) 🇪🇸 | 5
F45 | Eko [NAME] (2kg) 🇪🇸 | 4
F15 | [NAME] (3kg) 🇪🇸 | 4
D09 | [NAME] (1kg) 🇵🇹 | 3
F71 | Eko [NAME] (6kg) 🇪🇸 | 3
F28 | Eko [NAME] (2,8kg) 🇪🇸 | 3
D21 | Eko Hasselnötter (900g) 🇵🇹 | 2
F05 | Eko Citron (3kg) 🇪🇸 | 2
D08 | Eko [NAME] (900g) 🇵🇹 | 2
F140 | [NAME] (4kg) 🇪🇸 | 2
F01 | [NAME] och Grapefrukt (3,5kg) 🇪🇸 | 2
F08 | Eko [NAME] och Citron (3,5kg) 🇪🇸 | 2
F63 | Eko [NAME] (4kg) 🇪🇸 | 2
V11 | Ekologisk blandning av körsbärstomater (2 kg) 🇪🇸 | 2
V68 | Eko [NAME] (4kg) 🇩🇰 | 1
D06 | Eko rostade hasselnötter (900g) 🇪🇸 | 1
F10 | [NAME] (3kg) 🇪🇸 | 1
D13 | Eko Valnötter (700g) 🇵🇹 | 1
V60 | [NAME] (1kg) 🇩🇪 | 1
Spreadsheet: 795732d1662897885-how-to-filter-a-word-with-capital-letters-kod-filter-1-
Sheet: Sheet1

 |  | We want to filter 3 Letter codes like BLS, ASD. HHS, …
 | Column 1 | Column 2
 | [NAME] azx 34 TRDG
 | TBKZ Yyy xczt cv ASD
 | Yxzt BV Xxcs HHS cx GKOP
 | BLS TU Zytcxzx BTKE 365
 | Zt CHW zx GHMN 24 KM
 | PT GBUE 724 KLM cv2 HY
 | 362 Vxct PST 2684 LKMT SX
 | TSX xcz AW 25 STLC
 | 32 zxty KLM BN HGTR
 | …
 | …
 | …
Spreadsheet: 88608d1288386428-pivot-report-running-total-cumcountpvt
Sheet: Pivot

 | Data |  |  |  | Percentage Running Total
Category | Count of Quantity | Count of Quantity2
Fair | 20 | 0.3174603174603174 |  |  | 0.3174603174603174
[NAME] category | 20 | 0.3174603174603174 |  |  | 0.6349206349206349
Serious | 23 | 0.3650793650793651 |  |  | 1
(blank) |  | 0 |  |  | 1
Grand Total | 63 | 1
I think this is what You Want.  Look under Show values by - More Options
 | Data
Category | Count of Quantity | Count of Quantity2 | Count of Quantity3
Fair | 20 | 20 | 0.3174603174603174
[NAME] category | 20 | 40 | 0.6349206349206349
Serious | 23 | 63 | 1
Grand Total | 63
Spreadsheet: 792518d1660931062-spill-error-budget-aug-18-1230-2022-
Sheet: vendor amazon store cc

WB - ASC
type:  non-health creditor account
ShortTermDebt Account (STDA)
for Amazon Store credit card
due date:
Date | SOM Balance | Principal credit | debit | Interest | Fees | EOM Balance
2019-07-25 00:00:00 | 89.2 |  |  |  | 39.5
2019-08-01 00:00:00 | 0
 |  | 89.2
Spreadsheet: 96166d1295576845-display-value-from-one-sheet-to-another-example
Sheet: Sheet1

PO# |  |  | 1111
PO Amount |  |  | 0
Type |  |  | 0
Total Spend Submitted |  |  | 0
Total Spend Paid |  |  | 0
Amount Left |  |  | 0
Project Name |  |  | 10.7 Data Store
PO# |  |  | 2222
PO Amount |  |  | 0
Type |  |  | 0
Total Spend Submitted |  |  | 0
Total Spend Paid |  |  | 0
Amount Left |  |  | 0
Project Name |  |  | Global EDW at CGT with [NAME]
PO# |  |  | 0
PO Amount |  |  | 0
Type |  |  | 0
Total Spend Submitted |  |  | 0
Total Spend Paid |  |  | 0
Amount Left |  |  | 0
Project Name |  |  | TEST
Spreadsheet: eric_saibi__9876__102201R
Sheet: Indian Point 02

Owner Name |  | Entergy Nuclear Generation Company
Station Name |  | Indian Point II Nuclear Power Station
Unit Name |  | Indian Point 02
NERC Region |  | NPCC
State |  | NY
Fuel Type |  | Nuclear
Capacity |  | 1,310 MW
Start Date |  | 2001-10-26 00:00:00
End Date |  | 2001-11-05 00:00:00
Prv. Start Date |  | 2001-10-27 00:00:00
Prv. End Date |  | 2001-11-06 00:00:00
Comments |  | Turbine Work
SIC |  | 4911
Plant ID |  | 1008426
Unit ID |  | 1004365
Outage ID |  | 7477
Spreadsheet: 755337d1636797081-how-to-look-up-with-multiple-criteria-october-2021-stitching-bill
Sheet: PAYMENT

IN HOUSE
 | TOTAL PCS |  |  |  | PAYMENT
TYPE | SIZE | STITCHING | PURPOSE | PCS | PRICE | AMOUNT
 |  |  |  |  |  |  |  |  | NEW NAKSHI | BEDCOVER | NEW NAKSHI
 |  |  |  |  |  | 420 |  |  | NEW NAKSHI | PILLOW | SINGLE
 |  |  |  |  |  | 1470 |  |  | NEW NAKSHI | CUSHION | SINGLE
 |  |  |  |  |  |  |  |  | NEW NAKSHI | BOOSTER | BOOSTER
 |  |  |  |  |  |  |  |  | NAKSHI | BEDCOVER | NAKSHI
 |  |  |  |  |  |  |  |  | NAKSHI | PILLOW | PILLOW
 |  |  |  |  |  |  |  |  | NAKSHI | CUSHION | CUSHION
 |  |  |  |  |  |  |  |  | NAKSHI | BOOSTER | BOOSTER
Spreadsheet: 74983d1275508054-match-multiple-criteria-in-rows-and-columns-example2
Sheet: Sheet1

[NAME] # | Cost / bolt | Use Now? | Case cost | Bolts / case | Better price available? | May Purchase (qty of cases) | May bolts purchased | Better priced item case qty needed to maintain old item's May units purchased
600468651 | 2 | YES | 200 | 100 |  | 33
600468651 | 1 | NO | 500 | 500 |  | 0
167592369 | 3 | YES | 300 | 100 |  | 21
418577140 | 3 | YES | 1500 | 500 |  | 8
167981463 | 2 | YES | 200 | 100 |  | 8
664584893 | 1 | NO | 500 | 500 |  | 0
664584893 | 2 | YES | 200 | 100 |  | 0
664584893 | 2 | NO | 180 | 90 |  | 0
537358705 | 2 | YES | 200 | 100 |  | 45
296342672 | 1 | YES | 500 | 500 |  | 26
685181835 | 2 | YES | 200 | 100 |  | 20
416907891 | 1 | YES | 90 | 90 |  | 9
442194893 | 3 | YES | 180 | 60 |  | 14
125094487 | 4 | YES | 400 | 100 |  | 32
678390783 | 3 | YES | 750 | 250 |  | 21
644223880 | 1 | NO | 250 | 250 |  | 16
644223880 | 4 | YES | 400 | 100 |  | 0
644223880 | 1 | NO | 120 | 120 |  | 0
806148279 | 3 | YES | 1500 | 500 |  | 35
119297191 | 2 | YES | 200 | 100 |  | 26
786163235 | 3 | YES | 300 | 100 |  | 15
563293518 | 2 | YES | 1000 | 500 |  | 5
525817355 | 1 | YES | 120 | 120 |  | 48
749920488 | 4 | YES | 360 | 90 |  | 40
311342030 | 4 | YES | 480 | 120 |  | 22
311342030 | 3 | NO | 750 | 250 |  | 0
311342030 | 3 | NO | 1500 | 500 |  | 0
522468128 | 2 | YES | 1000 | 500 |  | 47
288718138 | 3 | YES | 300 | 100 |  | 61
723117862 | 2 | YES | 200 | 100 |  | 41
500800142 | 1 | NO | 500 | 500 |  | 25
500800142 | 2 | YES | 200 | 100 |  | 0
500800142 | 1 | NO | 250 | 250 |  | 0
862243827 | 3 | YES | 300 | 100 |  | 39
988409945 | 3 | YES | 270 | 90 |  | 42
910626344 | 4 | YES | 240 | 60 |  | 11
316266721 | 4 | YES | 400 | 100 |  | 60
456934891 | 2 | YES | 200 | 100 |  | 30
Spreadsheet: 757914d1638522468-counting-cell-after-a-reference-point-and-restart-when-the-reference-point-is-meet-count-after-a-landmark-is-meet3
Sheet: Sheet1

 | results |  | ALiGW's Formula
 |  |  |  |  |  | Counting cell after a reference point and restart when the refference point is meet.
 |  |  |  |  |  | RF = refference point
RF | 3 |  |  |  |  | B = cells to count
 | 2
7 | 5
B | 1
B
D
B
F
RF
G
B
23
B
N
25
RF
B
R
B
10
B
B
M
B
RF
B
15
Spreadsheet: mary_fischer__25622__87P
Sheet: E12.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 087P
COMPANY NAME  EFS Water Treatment Services
ANALYSIS OF LONG-TERM DEBT
FOR THE 6 MONTHS ENDED 6-30-2001
PREPARED BY:[NAME] |  |  |  |  |  |  |  |  |  |  |  | ** Credit Positive Liability  (Debit Negative Liability) **
EXTENSION:[PHONE] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-12
 |  |  |  |  |  |  |  | ORIGINAL |  | BEGINNING BALANCE |  |  |  |  |  |  |  |  |  | OTHER (NON-CASH) |  |  |  | ENDING BALANCE
PAYEE AND [NAME] |  | HYPERION |  | DUE |  | INTEREST |  | AMOUNT |  | CURRENT |  | LONG-TERM |  |  |  | ADDITIONS |  | RETIREMENTS |  | AMOUNT |  | [NAME] |  | CURRENT |  | LONG-TERM
 |  | ACCOUNT |  | DATE |  | RATE |  | AUTHORIZED |  | PORTION |  | PORTION |  | TOTAL |  | DR (CR) |  | DR (CR) |  | DR (CR) |  |  |  | PORTION |  | PORTION |  | TOTAL
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Current:
Current Maturities of Long-Term Debt * |  | 0450 |  |  |  | 0
Notes Payable - Other |  | TOT_NP_OTHER
Total Short-Term
Long-Term:
Long-Term Debt (Hyperion Accts. 0705, 0770)
Notes (list by name of payee or issue):
Total (Hyperion Accts 0705 & 0770)
Current Maturities of L/T Debt (Contra) * |  | 0775
Unamortized Premium on L/T Debt |  | 0765
Total Long-Term Debt
Total Debt  DR/(CR)
!!DO NOT INCLUDE INTERCOMPANY DEBT!!
*  HYPERION ACCOUNTS 0450 & 0775 MUST BE THE SAME AMOUNT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-12
 |  |  |  | Income Accts:  (DR)/CR Reverse signs from Hyperion
 |  |  |  |  |  |  | Income Accts: (DR)/CR  Reverse signs from Hyperion
Spreadsheet: 583618d1532535301-fill-in-blank-cells-based-on-other-present-information-gibsojl1-excel-question
Sheet: Finished Product

Control Number | [NAME] | Supplier ID
503056 | [NAME]'s [NAME]
503056 | [NAME]'s [NAME]
503058 | [NAME] Law Office
503058 | [NAME] Law Office
503058 | [NAME] Law Office
503059 | Kelly's Auto Repair
503059 | Kelly's Auto Repair
Spreadsheet: 793459d1661496860-array-formula-that-works-on-latest-excel-verion-but-not-on-2007-basket-matrix
Sheet: Sheet1

Oorder number | item |  |  | Apple | Orange | [NAME]
123 | Apple |  | Apple
123 | Orange |  | Orange
#234 | Apple |  | [NAME]
#234 | Orange
#234 | [NAME]
#5788 | [NAME]
#5788 | Orange
#5788 | Apple
Spreadsheet: 207136d1358368385-1-cell-looking-a-range-then-returning-data-from-adjacent-cell-and-combining-if-then-schedule-demo
Sheet: Template-Demo (2)

DATES |  |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday
 |  |  | Trainer | Time | Trainer | Time | Trainer | Time | Trainer | Time | Trainer | Time | Trainer | Time
Trainees | Tinker |  |  |  |  |  |  |  |  |  |  |  | OFF
 | Tailor |  | [NAME] |  |  |  |  |  |  |  |  |  | OFF
 |  |  | 815/115
 | Soldier |  |  |  |  |  |  |  |  |  |  |  | OFF
 | Spy |  |  |  |  |  |  |  |  |  |  |  | OFF
 | Thing 1 |  |  |  |  |  |  |  | OFF |  |  |  | Princess P
 |  |  |  |  |  |  |  |  |  |  |  |  | 830/12
 | Thing 2 |  |  |  |  |  |  |  |  |  |  |  | OFF
 | Red Fish |  |  |  |  |  |  |  | OFF |  |  |  | [NAME] R
 |  |  |  |  |  |  |  |  |  |  |  |  | 830/12
 | Blue Fish |  |  |  |  |  |  |  |  |  |  |  | OFF
 | Old Fish |  |  |  |  |  |  |  | OFF |  |  |  | [NAME] R
 |  |  |  |  |  |  |  |  |  |  |  |  | 830/12
 | New Fish |  | [NAME] |  |  |  |  |  |  |  |  |  | OFF
 |  |  | 815/115
Instructors | [NAME] |  | Tailor & New Fish |  | Tinker & Soldier |  | Thing 2 |  | New Fish |  | Thing 1 & New Fish |  | OFF
 |  |  | 815/115
 | [NAME] |  | Blue Fish & Old Fish |  | Tailor & Thing 1 |  | Thing 1 & Tailor |  | Blue Fish |  | Tinker & Old Fish |  | OFF
 |  |  | 815/145
 | [NAME] |  | Spy |  | Thing 2 & Red Fish |  | Soldier |  | Soldier |  | Thing 2 |  | OFF
 |  |  | 815/145
 | [NAME] T |  | Thing 1 & Thing 2 |  | Blue Fish |  | Spy & New Fish |  | Thing 2 |  | Blue Fish |  | OFF
 |  |  | 9/215
 | [NAME] R |  | Tinker |  | Spy & Old Fish |  | Tinker |  | OFF |  | Tailor & Spy |  | Red Fish, & Old Fish
 |  |  | 10/3 |  |  |  |  |  |  |  |  |  | 830/12
Mentors | Mario P |  | Soldier |  |  |  | Blue Fish
 | Luigi P |  |  |  | New Fish |  | Old Fish |  | Spy |  | Soldier
 | Princess T |  | Red Fish |  |  |  | Red Fish
 | Princess P |  |  |  |  |  |  |  | Tailor |  |  |  | Thing 1
 |  |  |  |  |  |  |  |  |  |  |  |  | 830/12
 | Yoshi M |  |  |  |  |  |  |  | Tinker |  | Red Fish
Spreadsheet: 97011d1296228848-excel-2007-turn-back-2-last-flight-dates-forum-help
Sheet: Daily Aircraft Registrations

 |  | FLIGHTS OF DAY
 |  | AIRCRAFT #1 | AIRCRAFT #2 | AIRCRAFT #3 | AIRCRAFT #4 | AIRCRAFT #5 | AIRCRAFT #6 | AIRCRAFT #7 | AIRCRAFT #8 | AIRCRAFT #9 | AIRCRAFT #10 | AIRCRAFT #11 | AIRCRAFT #12
Saturday | 2010-01-01 00:00:00 | AIR 21
Sunday | 2010-01-02 00:00:00
Monday | 2010-01-03 00:00:00 | AIR 1 |  |  |  |  |  | AIRR3
Tuesday | 2010-01-04 00:00:00 |  |  |  |  |  |  | AIR4
Wednesday | 2010-01-05 00:00:00
Thursday | 2010-01-06 00:00:00 |  | AAIR 1
Friday | 2010-01-07 00:00:00 |  | AIR2
Saturday | 2010-01-08 00:00:00 |  | AIRR3
Sunday | 2010-01-09 00:00:00 |  | AIR4
Monday | 2010-01-10 00:00:00 |  | FLYHI1
Tuesday | 2010-01-11 00:00:00
Wednesday | 2010-01-12 00:00:00
Thursday | 2010-01-13 00:00:00 |  |  |  |  | AAIR 1
Friday | 2010-01-14 00:00:00 |  |  | AIRR3 |  | AIR2
Saturday | 2010-01-15 00:00:00 |  |  | AIR4
Sunday | 2010-01-16 00:00:00
Monday | 2010-01-17 00:00:00 | AIRR3
Tuesday | 2010-01-18 00:00:00 | AIR4
Wednesday | 2010-01-19 00:00:00 |  |  |  | AAIR 1
Thursday | 2010-01-20 00:00:00 |  |  |  | AIR2
Friday | 2010-01-21 00:00:00
Saturday | 2010-01-22 00:00:00
Sunday | 2010-01-23 00:00:00
Monday | 2010-01-24 00:00:00
Tuesday | 2010-01-25 00:00:00
Wednesday | 2010-01-26 00:00:00
Thursday | 2010-01-27 00:00:00
Friday | 2010-01-28 00:00:00
Saturday | 2010-01-29 00:00:00
Sunday | 2010-01-30 00:00:00
Monday | 2010-01-31 00:00:00
Spreadsheet: 97977d1297093407-multiple-rows-same-address-address-sample
Sheet: Original Data

ID | Preferred_Name | Additional Name | Address | City | State | [NAME]
1445 | [NAME] |  | 85 Stanley St | Cambridge | MA | 15151
1446 | [NAME] |  | 85 Stanley St | Cambridge | MA | 15151
1876 | [NAME] | [NAME] | 85 Stanley St | Cambridge | MA | 15151
4615 | [NAME] | Pam Potts | 69 West St | Charleston | MA | 14118
4145 | [NAME] |  | 6 Pleasant St | Concord | MA | 15111
5333 | [NAME] |  | 67 [NAME] | Concord | MA | 14434
5334 | Sandra Cans | [NAME] | 67 [NAME] | Concord | MA | 14434
6267 | [NAME] | [NAME] | 40 Old Stow Rd | Hudson | MA | 15411
5726 | [NAME] |  | 72 [NAME] | Lincoln | MA | 16378
6334 | George & Martha Wilson |  | 98 Flemming Rd | Lincoln | MA | 16111
6335 | [NAME] |  | 98 Flemming Rd | Lincoln | MA | 16111
6365 | [NAME] |  | 98 Flemming Rd | Lincoln | MA | 16111
6280 | [NAME] |  | 770 [NAME] #123 | Marlborough | MA | 15411
627 | [NAME] |  | 27 Connecticut Ave | Newton | MA | 15482
4817 | [NAME] |  | 27 Connecticut Ave | Newton | MA | 15482
1794 | [NAME] | [NAME] | 3 Later Rd | Southborough | MA | 15346
1932 | Anders Larson | [NAME] | 241 Concord Ave | West Bridgewater | MA | 16139
5448 | [NAME] |  | 241 Concord Ave | West Bridgewater | MA | 16139
5727 | [NAME] |  | 241 Concord Ave | West Bridgewater | MA | 16139
298 | [NAME] |  | 241 Concord Ave | West Bridgewater | MA | 16139
Spreadsheet: 167827d1342111573-1st-time-user-of-excel-solver-function-can-some-one-double-check-my-work-for-accuracy-efficient-frontier-calc-7-11-12
Sheet: Callan Projection E.F. 

 | Efficient Frontier Calc Based on Callan Projections:
 | [NAME] | Equities |  | Callan Volatility Projection | Equities | [NAME] | Fixed Income |  | Callan Volatility Projection | Fixed Income
 | Broad Domestic Equity | 0.055 |  | Broad Domestic Equity | 0.181 | Domestic Fixed Income | 0.0125 |  | Domestic Fixed Income | 0.045
 | [NAME]
 | Fixed Income Return Proj. |  |  |  |  | Covariance Matrix
 | Equity Return Proj. |  |  |  |  |  | Domestic Fixed Income |  | Equities
 |  |  |  |  |  | Domestic Fixed Income | 1 |  | 0.01
 | Fixed Income Volatility Proj. |  |  |  |  | Equities | 0.01 |  | 1
 | Equity Volatility Proj. |  |  |  |  | Variances
 | Fixed Income Allocation | 0.7059058823529413
 | Equities Allocation | 0.2940941176470588
 | Total Weight
 | Portfolio Average Return
 | [NAME]
 |  | Hypothetical Portfolio Return
 |  |  |  |  | Asset Allocation
 |  | Targeted Return |  | Standard Deviation | Fixed Income | Equities
 |  | 0.0125 |  | 0.045 | 1
 |  | 0.015 |  | 0.0406 | 0.9412
 |  |  |  | 0.0377 | 0.8824
 |  |  |  | 0.0364 | 0.8235
 |  |  |  | 0.0366 | 0.7647
 |  |  |  | 0.0384 | 0.7059
 |  |  |  | 0.0417 | 0.6471
 |  |  |  | 0.0466 | 0.5882
 |  |  |  | 0.053 | 0.5294
 |  |  |  | 0.061 | 0.4706
 |  |  |  | 0.0706 | 0.4117
 |  |  |  | 0.0817 | 0.3529
 |  |  |  | 0.0944 | 0.2941
 |  |  |  | 0.1086 | 0.2353
 |  |  |  | 0.1244 | 0.1765
 |  |  |  | 0.1417 | 0.1176
 |  |  |  | 0.1606 | 0.0588
 |  |  |  | 0.181 | 0
Spreadsheet: 705022d1605860841-vlookup-wont-work-on-multiple-rows-so-i-need-an-alternative-fhlp
Sheet: Table 2

 | no. | no. | no. | no. | no. | no.
AAA | 10 | 10 | 5 | 10 | 10 |  |  | This line highlighted to demonstrate where the source of the data is on table 1
BBB | 10 | 5 | 5 | 5
CCC
DDD
EEE | 40 | 20
FFF
There should never be more than 6 items in these rows so I don’t need more columns
Spreadsheet: 267853d1380242049-referencing-data-from-main-database-to-seperate-dataheets-formula-issue-employee1
Sheet: Datasheet

 |  |  |  |  |  |  |  |  |  | Employee details
Employee no:
First name:
Last name:
Date of birth
Internal / External:
Medical details
Other details
[NAME] |  |  |  |  |  |  |  |  |  | Employee photo
Start date:
Section:
Job title:
License no:
Current targets
 |  |  |  |  |  |  |  |  |  | Employee details
Employee no:
First name:
Last name:
Date of birth
Internal / External:
Medical details
Other details
[NAME] |  |  |  |  |  |  |  |  |  | Employee photo
Product Type
Condition
Asbestos result:
Risk Rating
Current targets
 |  |  |  |  |  |  |  |  |  | Employee details
Employee no:
First name:
Last name:
Date of birth
Internal / External:
Medical details
Other details
[NAME] |  |  |  |  |  |  |  |  |  | Employee photo
Product Type
Condition
Asbestos result:
Risk Rating
Current targets
 |  |  |  |  |  |  |  |  |  | Employee details
Employee no:
First name:
Last name:
Date of birth
Internal / External:
Medical details
Other details
[NAME] |  |  |  |  |  |  |  |  |  | Employee photo
Product Type
Condition
Asbestos result:
Risk Rating
Current targets
 |  |  |  |  |  |  |  |  |  | Employee details
Employee no:
First name:
Last name:
Date of birth
Internal / External:
Medical details
Other details
[NAME] |  |  |  |  |  |  |  |  |  | Employee photo
Product Type
Condition
Asbestos result:
Risk Rating
Current targets
 |  |  |  |  |  |  |  |  |  | Employee details
Employee no:
First name:
Last name:
Date of birth
Internal / External:
Medical details
Other details
[NAME] |  |  |  |  |  |  |  |  |  | Employee photo
Product Type
Condition
Asbestos result:
Risk Rating
Current targets
 |  |  |  |  |  |  |  |  |  | Employee details
Employee no:
First name:
Last name:
Date of birth
Internal / External:
Medical details
Other details
[NAME] |  |  |  |  |  |  |  |  |  | Employee photo
Product Type
Condition
Asbestos result:
Risk Rating
Current targets
 |  |  |  |  |  |  |  |  |  | Employee details
Employee no:
First name:
Last name:
Date of birth
Internal / External:
Medical details
Other details
[NAME] |  |  |  |  |  |  |  |  |  | Employee photo
Product Type
Condition
Asbestos result:
Risk Rating
Current targets
 |  |  |  |  |  |  |  |  |  | Employee details
Employee no:
First name:
Last name:
Date of birth
Internal / External:
Medical details
Other details
[NAME] |  |  |  |  |  |  |  |  |  | Employee photo
Product Type
Condition
Asbestos result:
Risk Rating
Current targets
 |  |  |  |  |  |  |  |  |  | Employee details
Employee no:
First name:
Last name:
Date of birth
Internal / External:
Medical details
Other details
[NAME] |  |  |  |  |  |  |  |  |  | Employee photo
Product Type
Condition
Asbestos result:
Risk Rating
Current targets
Spreadsheet: 269945d1381331130-i-am-trying-to-compare-text-in-2-columns-and-see-if-there-is-a-match-sample-sheet-2
Sheet: Sheet1

PART # | [NAME]
1 | CHAMBER VALVE KIT
2 | Valve Chamber Assy
3 | Valve Chamber Assy
4 | KIT REPAIR 830997M91
5 | [NAME] B1002 MKI
6 | [NAME]
7 | KIT REPAIR 1810678M91
8 | PLUG 181999M1
9 | PLUG 888700M1
10 | PLUG 1868741M1
11 | KIT REPAIR HYD PUMP
12 | KIT REPAIR HYD PUMP
13 | KIT REPAIR HYD PUMP
14 | Hyd Pump Repair Kit
15 | KIT REPAIR HYD PUMP
16 | Hyd Pump Repair Kit
17 | [NAME] 180933M1
18 | VALVE 1680061M91
19 | PLUNGER 1860114M91
20 | Spring 461-891