tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 72988d1273670273-countif-index-match-test2
Sheet: Receipt

 |  |  |  |  |  |  | RECEIPT / INVOICE
Art & Escape Ltd
23-25 Barnet Road
EN6 2QX
Company No. 6972835
www.artandescape.com
#N/A |  |  |  |  |  | ARTIST REFERENCE | A0009
#N/A |  |  |  |  |  | DATE | 2010-05-12 14:15:32
#N/A
#N/A |  |  |  |  |  | DATE RECEIVED | 2009-11-24 00:00:00
#N/A |  |  |  |  |  | RECEIVED VIA
5
OUR  REF | ARTIST  REF | [NAME] | DATE  RETURNED | DATE  SOLD | DATE  PAID | SALE AMOUNT | ARTIST  COMMISSION @ 55%
AR0064 | 0 | [NAME] landscape | 1900-01-01 00:00:00 | 2009-12-14 00:00:00 | 2010-03-05 00:00:00 | 140 | 77
AR0065 | 0 | A Man Named [NAME] landscape | 1900-01-01 00:00:00 | 2009-12-14 00:00:00 | 2010-03-05 00:00:00 | 140 | 77
AR0066 | 0 | Man Who Laughs A1 portrait | 2010-03-10 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 | 0
AR0067 | 0 | The Caterpillar A2 landscape | 2010-03-10 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 | 0
AR0068 | 0 | Alice in Wonderland Illustrated book | 2010-03-10 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 | 0
 |  |  |  | TOTAL |  |  | 154
Please direct enquiries to:
[NAME]
+44 (0) 7791 075 458
email: [EMAIL]
Received with thanks
Art & Escape Ltd agree to represent works for at least the length of exhibition.
All payments will be made within 30 days after exhibition.
Spreadsheet: 38411d1236598118-excel-2007-issue-with-using-formulas-to-pull-data-from-one-sheet-to-another-lwnnsalariesprojections
Sheet: Padres

San Diego Padres | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 |  | San Diego Padres | 2009 | 2010 | 2011 | 2012 | 2013 | 2014
Actual |  |  |  |  |  |  |  | Operations
Budget | 90 | 90 | 90 | 90 | 90 | 90
Difference |  |  |  |  |  |  |  | Fan Base Factors
 |  |  |  |  |  |  |  | Record Reward
Cost of Goods
Personnel |  |  |  |  |  |  |  | Income
Bleich, Jeremy | ML | ML | ML | ML | ML | ML |  | From Astros | -5.5
[NAME], Dusty | ML | ML | ML | ML | ML | ML |  | From Athletics | -1
Cooper, David | ML | ML | ML | ML | ML | ML |  | From Blue Jays | -5
Raben, Dennis | ML | ML | ML | ML | ML | ML |  | From Brewers | -5.7 | -5.8
[NAME] | ML | ML | ML | ML | ML | ML |  | From Cardinals | -8.6 | -3.5
Adams, Ryan | ML | ML | ML | ML | ML | ML |  | From Cubs | -1 | -0.5
[NAME], [NAME] | ML | ML | ML | ML | ML | ML |  | From Dodgers | -10.5
Armstrong, Cole | ML | ML | ML | ML | ML | ML |  | From Mariners | -0.9
Coghlan, [NAME] | ML | ML | ML | ML | ML | ML |  | From [NAME] | -0.9
Dominguez, [NAME] | ML | ML | ML | ML | ML | ML |  | From Nationals |  | -0.5
[NAME], [NAME] | ML | ML | ML | ML | ML | ML |  | From Phillies | -3.1
Hessman, [NAME] | ML | ML | ML | ML | ML | ML |  | From Reds | -0.6
Hicks, [NAME] | ML | ML | ML | ML | ML | ML |  | From Twins | -5.5
Hodges, [NAME] | ML | ML | ML | ML | ML | ML
Hooker, [NAME] | ML | ML | ML | ML | ML | ML |  | Expenses
Hughes, [NAME] | ML | ML | ML | ML | ML | ML |  | [NAME], [NAME] | 1.6 | 1.5
Maloney, [NAME] | ML | ML | ML | ML | ML | ML |  | [NAME], [NAME] | 4.1 | 4.1
[NAME], [NAME] | ML | ML | ML | ML | ML | ML |  | To Angels |  | 0.3
Nunez, [NAME] | ML | ML | ML | ML | ML | ML |  | To Athletics | 0.5
Omogrosso, [NAME] | ML | ML | ML | ML | ML | ML |  | To Blue Jays | 4 | 1.5
[NAME], [NAME] | ML | ML | ML | ML | ML | ML |  | To Cardinals | 3.1 | 1.1 | 0.6
[NAME], [NAME] | ML | ML | ML | ML | ML | ML |  | To Cubs | 4.5
[NAME], [NAME] | ML | ML | ML | ML | ML | ML |  | To Mariners |  | 0.7
Rodriguez, Aneury | ML | ML | ML | ML | ML | ML |  | To Rays | 4
Simmons, [NAME] | ML | ML | ML | ML | ML | ML |  | To Twins | 1.2 | 0.1
Cabrera, [NAME] | 33.5
Peavy, Jake | 25
[NAME], Troy | 10.7
[NAME], [NAME] | 10 | 10 | 10
Molina, Bengie | 6.6
Nady, Xavier | 4.7 | 4.7
Cano, Robinson | 3.6 | A3
Ethier, [NAME] | 3 | A2 | A3
[NAME], [NAME] | 3 | A2 | A3
[NAME], [NAME] | 2.9 | A2 | A3
[NAME], [NAME] | 2.5 | 2.5 | 2.5
Harris, Willie | 1.7
Hoffpauir, Micah | 1.2 | 1.2 | 1.2 | 1.2
[NAME], [NAME] | 0.9 | 0.9 | 0.9 | 0.9
[NAME], [NAME] | 0.7 | A1 | A2 | A3
Danks, [NAME] | 0.7 | A1 | A2 | A3
[NAME], [NAME] | 0.7 | A1 | A2 | A3
Perkins, [NAME] | 0.7 | A1 | A2 | A3
Camp, [NAME] | 0.5 | A
[NAME], [NAME] | 0.5 | A
Reyes, Dennys | 0.5 | A
Aviles, [NAME] | 0.3 | 0.7 | A1 | A2 | A3
Blevins, [NAME] | 0.3 | 0.7 | A1 | A2 | A3
[NAME], [NAME] | 0.3 | 0.7 | A1 | A2 | A3
Valentin, Javier | 0.1
Spreadsheet: 462568d1464102228-extract-present-data-from-master-sheet-extract-data-from-master-sheet
Sheet: Master

Provider | data
A | a
B | b
C | c
A | aa
B | bb
C | cc
A | aaa
B | bbb
C | [NAME]
A | aaaa
B | bbbb
C | cccc
Spreadsheet: 168325d1342402273-a-complicated-look-up-table-with-multiple-conditions-copy-of-complex-look-up-alternative
Sheet: Result

 |  |  |  | Jan | Feb | Mar | April | May | June
[NAME]
TM72006 | [NAME](Z9002) | Z9002 | In Brand Text column from LookUP Data tab
TM72001 | [NAME]  (ZCT) | [NAME] | In Brand Text column from LookUP Data tab
TM72004 | TMF ACRYLIC 1-P (ZMB00) | [NAME] | In Product Size column from LookUP Data tab
TM72001 | TMF ACRYLIC 3-P (ZMA00) | ZMA00 | In Product Size column from LookUP Data tab
TM72006 | Phaco Tips | Reusable Tips | In Brand Text column from LookUP Data tab, 2 combined look up vales
TM72006 | Phaco Tips | Disposable Tips | In Brand Text column from LookUP Data tab
TM72001 | PHACO ACC- FX [NAME] | Sovereign Accessories | In Brand Text column from LookUP Data tab
TM72001 | Phaco Equipment / Signature $ | WhiteStar Signature | Not there in the Look UP Data
TM72001 | Fitzory | Kalmore
Look UP Values |  | Look Up Values
from Terr Surg column of LookUP [NAME] |  | some of these values are found in "Brand Text" column and Some in "Product Size Column"
Spreadsheet: 781450d1653332938-looking-for-a-tutorial-to-create-a-fat-loss-calculator-in-excel-tf04036851_win322
Sheet: EXERCISE

 | EXERCISE |  |  |  | Diet | Goals
 | DATE | DURATION (MIN) | CALORIES BURNED | NOTES
 |  | 30 | 120 | Treadmill workout
 |  | 60 | 180 | Low impact aerobics
 |  | 60 | 350 | Extreme workout
 |  | 30 | 150 | Treadmill workout
 |  | 25 | 125 | Run
 |  | 20 | 285 | Treadmill workout
 |  | 40 | 205 | Run
 |  | 30 | 335 | Run
 |  | 40 | 175 | Run
 |  | 45 | 325 | Treadmill workout
 |  | 40 | 270 | Run
 |  | 20 | 295 | Treadmill workout
 |  | 45 | 350 | Run
 |  | 35 | 320 | Run
 |  | 40 | 290 | Run
 |  | 25 | 265 | Treadmill workout
 |  | 20 | 195 | Run
Spreadsheet: 840629d1692874321-if-and-or-statement-with-multiple-condition-if-multiple-cond
Sheet: Sheet1

Onhand Value | SVC PARTS | Total Res | Aging
110.7 | YES |  | A.0-3M
200 | NO |  | C.6-9M | [NAME] supposed to be 0
400 | YES |  | E.1-3Y
500 | YES |  | A.0-3M
100 | YES |  | E.1-3Y
600 | NO |  | F.>3Y | C7 supposed to be 0
400 | YES |  | E.1-3Y
200 | YES |  | B.3-6M
100 | YES |  | F.>3Y
Spreadsheet: 769467d1645548995-populate-an-excel-calendar-with-information-from-sheet-in-same-workbook-opi-job-track-worksheet
Sheet: Calendar

 |  | 2022-02-01 00:00:00
 |  | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 |  | 2022-03-01 00:00:00
 |  | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
 |  | 2022-04-01 00:00:00
 |  | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
Spreadsheet: 227841d1365847587-how-to-do-4-bit-x-4-bit-binary-multilpication-by-converting-muliplier-to-boolean-in-excel-hardarexshiftadd_copy
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Multiplier |  |  | Multiplicand
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Decimal | Binary |  |  |  | Decimal | Binary |  | Decimal | Binary
 |  |  |  |  |  |  |  |  |  |  |  |  | Multiplicand | 11
 |  |  |  |  |  |  |  |  |  |  |  |  | Multiplier | 10
 |  |  |  |  |  |  |  |  |  |  |  |  | Product
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mand
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bit | Bit | Bit | Bit
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 2 | 1 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | Multiplier |  |  |  |  |  |  |  |  |  |  | Multiplicand |  |  |  |  |  |  | Carry |  |  |  |  |  | Sum
 |  |  |  |  | Bit | Bit | Bit | Bit |  |  |  |  |  |  |  | Bit | Bit | Bit | Bit |  |  |  |  |  |  |  |  | 0
 |  |  |  |  | 3 | 2 | 1 | 0 | Bit considered |  | Multiplier | Bit Position | Multiplier |  |  | 3 | 2 | 1 | 0 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | Bit Value | index | Bit Value |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  | 0 |  |  |  |  |  |  |  |  |  | SUM | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  | 0
 |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  | 0 |  |  |  |  |  |  |  | 1 |  |  | 0
 |  |  |  | 0 |  |  |  |  |  |  |  | 2 |  |  | 0
 |  |  |  | 0 |  |  |  |  |  |  |  | 3 |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 6 | 5 | 4 | 3 | 2 | 1 | 0
 |  |  |  |  |  |  |  |  | Analogous layout for Boolean logic as opposed to bit values above
 |  |  |  |  |  |  | You can replace the binary number functions used above, with Boolean logic (AND<OR, NOR etc) below to get correct answers.
 |  |  |  |  |  |  |  | And recreate any additional sum and carry spreadsheet blocks off to the right as above for binary.
 |  |  |  |  |  |  | Multiplier |  |  |  |  |  |  |  |  |  |  | Multiplicand
 |  |  |  |  | Bit | Bit | Bit | Bit |  |  |  |  |  |  |  | Bit | Bit | Bit | Bit
 |  |  |  |  | 3 | 2 | 1 | 0 |  |  | Multiplier | Bit Position | Multiplier |  |  | 3 | 2 | 1 | 0
 |  |  |  |  |  |  |  |  |  |  | Bit Value | index | Bit Value
 |  |  |  | False |  |  |  |  | Multiplier Bit |  |  |  |  |  | False |  |  |  |  |  |  |  |  |  |  | Carry |  |  |  |  |  | Sum
 |  |  |  | False |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | False | False | False | False |  |  |  |  |  | 0
 |  |  |  | False |  |  |  |  |  |  |  | 1 |  |  | False |  |  |  |  |  | False | False | False |  |  |  |  |  | 0
 |  |  |  | False |  |  |  |  |  |  |  | 2 |  |  | False | False |  |  |  |  |  | False | False |  |  |  |  |  | 0
 |  |  |  | False |  |  |  |  |  |  |  | 3 |  |  | False | False | False |  |  |  |  |  | False |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | SUM
Spreadsheet: 85218d1285255288-using-dsum-with-date-range-finance-tracker
Sheet: Sheet2

Personal Budget
2010
Income: | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total
Wages | 1000 | 1000 | 1000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3000
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Income | 1000 | 1000 | 1000 |  |  |  |  |  |  |  |  |  | 3000
Expenditure: | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total | Average
Car | 400 | 400 | 400 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1200 | 100
Phone | 200 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 200 | 16.66666666666667
Shopping | 300 | 300 | 300 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 900 | 75
Gas | 0 | 150 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 150 | 12.5
Electricity | 0 | 0 | 150 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 150 | 12.5
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Expenditure | 900 | 850 | 850 |  |  |  |  |  |  |  |  |  | 2600
Surplus / Deficit | 100 | 150 | 150 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | Balance: | 400
Spreadsheet: 867675d1714484034-vlookup-test
Sheet: P&L

Test
Profit & Loss Account
2024-05-31 00:00:00
 |  |  |  |  |  |  | YTD |  | YTD
 |  | Actual |  | Budget |  |  | Actual |  | Budget
Turnover
Management & Supervision
Forest Planning & FSC Certification
Restock Planting
New Planting
Establishment, Maintenance & Protection
Cost+ Tender Contracts
Commission on Sales
Tree Safety & Consultancy
Mileage
Roads & New Fencing
Additional Sales Required
 |  | 0 |  |  |  |  | 0 |  | 0
Cost of Sales
Purchases
Restocking
New Planting
Establishment, Maintenance & Protection
Cost+ Tender Contracts
Roads & New Fencing
Additional COS
 |  | 0 |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0.3755219280242284
Spreadsheet: 829912d1684523328-substitute-an-expression-column-b-that-matches-the-expression-in-column-a-substitute
Sheet: substitute

Take care of | I had to take care of my daughter because she was ill.
Take charge (of) | I will take charge of the project and ensure it is completed on time.
Take drugs | It is not safe to take drugs because they can be harmful to your health.
Take exercise | I take exercise every morning to stay healthy and fit.
Take medicine | You should take medicine to relieve your headache.
Take notes | It's important to take notes during class so you can review them later.
ache | My body is going to ache tomorrow.
repair | My car was repaired yesterday.
Spreadsheet: 146097d1331898890-moving-data-truck-test
Sheet: Sheet1

First Name | Last Name | Company | Website | Fax | Phone | street 1 | street 2 | city | state | zip | E-mail
[NAME] | [NAME] | 24/7 Specialized Transportation, Inc. |  | (760) 948-1223 | (760) 948-7272 | PO Box 403621 |  |  |  |  | [EMAIL]
 |  |  |  |  |  | Hesperia, CA 92340-3621
Verg | Beaty | A & B Truck Repair, Inc. |  | (209) 575-3541 | (209) 527-6971 | 959 South 9th Street |  |  |  |  | [EMAIL]
 |  |  |  |  |  | Modesto, CA 95351-5499
[NAME] | Tausz | A & R Transport |  | (815)941-5643 | (714) 521-7161 | 6250 Caballero Blvd. |  |  |  |  | [EMAIL]
 |  |  |  |  |  | [NAME], CA 90620-1124
[NAME] | Tallman | A & W Hay Service |  | (209) 667-1624 | (209) 667-2708 | [NAME] |  |  |  |  | [EMAIL]
 |  |  |  |  |  | Turlock, CA 95381-2367
[NAME] | [NAME] | A B F Freight System, Inc. |  | (479) 785-8783 | (479) 785-8700 | P.O. Box 10048 |  |  |  |  | [EMAIL]
 |  | www.abf.com |  |  |  | [NAME], AR 72917-0048
Spreadsheet: 01a31d1e-d5f9-4040-8860-d52e1a953237
Sheet: Summary

NRCS Programmatic and TA Economic Impacts in the State of South Dakota, FY2010
Program | Federal Cost | Direct Impacts | Total Output | Total Value Added | Direct Jobs | Total Jobs | Jobs per $1 Million of Federal Cost | Federal Cost Output Multiplier
EQIP | 12102144 | 12102144 | 23185604 | 9908593 | 81.2 | 172.3
WHIP | 505024 | 505024 | 888458 | 489515 | 7 | 10.7
CSP 2008 | 12719169 | 12719169 | 22395990 | 8870969 | 94.5 | 178.6
CSP 2002 | 3883204 | 3883204 | 6273870 | 2809972 | 35.3 | 58.8
WRP | 6787936 | 4580939 | 6959476 | 3119754 | 35.8 | 59.8
GRP | 978625 | 636310 | 945742 | 407186 | 4.7 | 7.8
NRCS TA | 26584792.76 | 26584792.76 | 41090355 | 28821873 | 254.8 | 426.4
Totals
 | In FY2010:
 | NRCS had $63.6 million in direct expenditures into the South Dakota economy.
 | These expenditures resulted in $101.7 million in total output (sales of goods and services) and $54.4 million in local wages and profits.
 | This includes the direct impact on business activity and the indirect impact (businesses and households purchasing goods and services within the state).
 | Create or support 914 jobs in South Dakota (not including NRCS employees).
 | For every $1.00 expenditure, an additional $0.60 of economic activity was created (multiplier effect).
 | Source:  IMPLAN
Spreadsheet: 290754d1389969002-formula-to-count-consecutive-blank-cells-in-a-range-depending-on-todays-date-sample-workbook
Sheet: Class Roster

Student ID | Student Name | Class Name | Class Start Date | [NAME] | FORMULA SHOULD READ | Student Email | 2013-11-04 00:00:00 | 2013-11-11 00:00:00 | 2013-11-18 00:00:00 | 2013-11-25 00:00:00 | 2013-12-02 00:00:00 | 2013-12-09 00:00:00 | 2013-12-16 00:00:00 | 2013-12-23 00:00:00 | 2013-12-30 00:00:00 | 2014-01-06 00:00:00 | 2014-01-13 00:00:00 | 2014-01-20 00:00:00 | 2014-01-27 00:00:00 | 2014-02-03 00:00:00 | 2014-02-10 00:00:00 | 2014-02-17 00:00:00 | 2014-02-24 00:00:00 | 2014-03-03 00:00:00 | 2014-03-10 00:00:00 | 2014-03-17 00:00:00 | 2014-03-24 00:00:00 | 2014-03-31 00:00:00 | 2014-04-07 00:00:00 | 2014-04-14 00:00:00 | 2014-04-21 00:00:00 | 2014-04-28 00:00:00 | 2014-05-05 00:00:00 | 2014-05-12 00:00:00 | 2014-05-19 00:00:00 | 2014-05-26 00:00:00 | 2014-06-02 00:00:00 | 2014-06-09 00:00:00 | 2014-06-16 00:00:00 | 2014-06-23 00:00:00 | 2014-06-30 00:00:00 | 2014-07-07 00:00:00 | 2014-07-14 00:00:00 | 2014-07-21 00:00:00 | 2014-07-28 00:00:00 | 2014-08-04 00:00:00 | 2014-08-11 00:00:00 | 2014-08-18 00:00:00 | 2014-08-25 00:00:00 | 2014-09-01 00:00:00 | 2014-09-08 00:00:00 | 2014-09-15 00:00:00 | 2014-09-22 00:00:00 | 2014-09-29 00:00:00 | 2014-10-06 00:00:00 | 2014-10-13 00:00:00 | 2014-10-20 00:00:00 | 2014-10-27 00:00:00 | 2014-11-03 00:00:00 | 2014-11-10 00:00:00 | 2014-11-17 00:00:00 | 2014-11-24 00:00:00 | 2014-12-01 00:00:00 | 2014-12-08 00:00:00 | 2014-12-15 00:00:00 | 2014-12-22 00:00:00 | 2014-12-29 00:00:00
[NAME] | STUDENT 1 | SAMPLE CLASS | 2014-01-14 12:30:00 | Registered | 3 | [EMAIL] | x |  |  |  | x | x | x | x | x | x | x
[NAME] | STUDENT 2 | SAMPLE CLASS | 2014-01-14 12:30:00 | Registered | 1 | [EMAIL] | x | x |  | x |  | x |  | x | x | x | x
[NAME] | STUDENT 3 | SAMPLE CLASS | 2014-01-14 12:30:00 | Registered | 2 | [EMAIL] | x |  |  | x | x | x |  |  | x | x | x
Class #:
Spreadsheet: 57001d1257183109-pivot-count-query-example-a-and-b-
Sheet: Sheet1

Count of Name | A or B
Name | A | B | Grand Total
Chock | 1 |  | 1
Clem | 1 |  | 1
[NAME] | 1 |  | 1
Giff | 2 |  | 2
Glock | 1 |  | 1
[NAME] | 1 |  | 1
[NAME] | 1 |  | 1
[NAME] | 2 |  | 2
[NAME] |  | 3 | 3
[NAME] |  | 2 | 2
Grand Total | 10 | 5 | 15
0
Spreadsheet: 674557d1587913129-unique-value-count-based-of-multiple-criteria-sample-1-sumfrequency
Sheet: BONOUS

CUSTOMER CODE --->> |  | 0026628X
 |  |  | TOTAL COUNT | SUM | UNIQUE COUNT |  |  |  | unique count(unique DOB in NB sheet) in Col.F6 if C2 satisfies below mentioned contidions:-
20190401 | 20200331 |  |  |  |  |  |  |  | IF(NB!A:A,"NB"and NB!M:M,C2 and NB!F:F>=A6 and NB!F:F<=&B6, nb!L:L (UNIQUE DOB)
20180401 | 20190331
20170401 | 20180331 |  |  |  |  |  |  |  | EXPECTED ANSWER IN WRITTEN IN COL F6 AND F14
20160401 | 20170331
20150401 | 20160331
20140401 | 20150331 |  |  |  |  |  |  | 1 | Total record for 0026628X in sheet NB >=F6(i.e. >=20190401) and <=B6(i.e. 20200331)
20130401 | 20140331 |  |  |  |  |  |  | 2 | are 7 out of which one record(seria; number 7) has "ND" flag so it does not satisfy condition NB!A:A="NB"
20120401 | 20130331 |  |  |  |  |  |  |  | Out of 6 records which satifies  condition 1 & 2 four records(in red color) are duplicates)
20110401 | 20120331 |  |  |  |  |  |  |  | so the answer in col. F6 should be 5
20100401 | 20110331
20090401 | 20100331 |  |  |  |  |  |  |  | Simalarly answer in F14 should be 6
20080401 | 20090331
20070401 | 20080331
20060401 | 20070331
Spreadsheet: 739369d1625664963-monthly-rental-revenue-calculation-with-rcd-and-red-date-and-different-escalation-rates-monthly-rent-calculation-template
Sheet: Sheet1

 |  |  | 2020-01-01 00:00:00
 |  |  |  | Annual Rent psf
Unit | Area | RCD | RED | 2020 | 2021 | 2022 | 2023 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00
1 | 100 | 2021-04-11 00:00:00 |  | 0 | 100 | 0 | 0
 | Required Output
Spreadsheet: 587390d1535000765-scoring-between-tables-looking-at-data-set-scoring-table-tennis
Sheet: Sheet1

Table Tennis Scoring
Date |  | Player 1 | Player 2 | Score Player 1 | Score Player 2 | [NAME] 1 | [NAME] 2 |  | Individual: | Win % |  | Player | Vs Player | Win % |  | Player | Vs Player | Average score
2018-08-16 00:00:00 | Game 1 | [NAME] | [NAME] | 11 | 7 | Win | Lose |  | [NAME] |  |  | [NAME] | [NAME] |  |  | [NAME] | [NAME]
 | Game 2 | [NAME] | [NAME] | 5 | 11 | Lose | Win |  | [NAME] |  |  | [NAME] | [NAME] |  |  | [NAME] | [NAME]
 | Game 3 | [NAME] | [NAME] | 9 | 11 | Lose | Win |  | Kurt H |  |  | [NAME] | Kurt H |  |  | [NAME] | Kurt H
 | Game 4 | [NAME] | [NAME] | 11 | 9 | Win | Lose |  |  |  |  | Kurt H | [NAME] |  |  | Kurt H | [NAME]
 | Game 5 | [NAME] | [NAME] | 9 | 11 | Lose | Win |  |  |  |  | [NAME] | Kurt H |  |  | [NAME] | Kurt H
 | Game 6 | [NAME] | [NAME] | 8 | 11 | Lose | Win |  |  |  |  | Kurt H | [NAME] |  |  | Kurt H | [NAME]
 | Game 7 | [NAME] | [NAME] | 11 | 13 | Lose | Win
 | Game 8 | [NAME] | Kurt H | 11 | 6 | Win | Lose
 | Game 9 | [NAME] | Kurt H | 11 | 4 | Win | Lose
 | Game 10 | [NAME] | Kurt H | 9 | 11 | Lose | Win
 | Game 11 | [NAME] | Kurt H | 11 | 3 | Win | Lose
 | Game 12 | [NAME] | Kurt H | 11 | 8 | Win | Lose
Spreadsheet: 545668d1509616921-formula-to-copy-named-range-to-another-ranges-and-formulas
Sheet: Sheet1

 |  | These are the master named ranges |  |  |  |  |  |  |  |  | This is the cell to input the named range we want to use |  |  | This is the table where the selected named range should appear depending on what name is put into cell [NAME]
 |  | This range is named First |  |  |  |  |  |  |  |  |  |  |  | This range is named Data
 |  | 5989 | 10327 | 9658 | 7144 | 9658 | 7144 | 12218 |  |  | Second
 |  | 5989 | 10327 | 9658 | 7144 | 9658 | 7144 | 12218
 |  | 5989 | 10327 | 9658 | 7144 | 9658 | 7144 | 12218
 |  | 5989 | 10327 | 9658 | 7144 | 9658 | 7144 | 12218
 |  | 5930 | 10465 | 9604 | 7142 | 9604 | 7142 | 12663
 |  | 5930 | 10465 | 9604 | 7142 | 9604 | 7142 | 12663
 |  | 5930 | 10465 | 9604 | 7142 | 9604 | 7142 | 12663
 |  | This range is named Second
 |  | 12218 | 12218 | 9658 | 10327 | 9658 | 14536 | 14536
 |  | 12218 | 12218 | 9658 | 10327 | 9658 | 14536 | 14536
 |  | 12663 | 12663 | 9604 | 10465 | 9604 | 15429 | 15429
 |  | 12663 | 12663 | 9604 | 10465 | 9604 | 15429 | 15429
 |  | 12663 | 12663 | 9604 | 10465 | 9604 | 15429 | 15429
 |  | 12663 | 12663 | 9604 | 10465 | 9604 | 15429 | 15429
 |  | 12663 | 12663 | 9604 | 10465 | 9604 | 15429 | 15429
 |  | This range is named Third
 |  | 7142 | 12663 | 12663 | 9604 | 10465 | 9604 | 15429
 |  | 7142 | 12663 | 12663 | 9604 | 10465 | 9604 | 15429
 |  | 7142 | 12663 | 12663 | 9604 | 10465 | 9604 | 15429
 |  | 7142 | 12663 | 12663 | 9604 | 10465 | 9604 | 15429
 |  | 7891 | 15016 | 15016 | 10094 | 11070 | 10094 | 17402
 |  | 7891 | 15016 | 15016 | 10094 | 11070 | 10094 | 17402
 |  | 7891 | 15016 | 15016 | 10094 | 11070 | 10094 | 17402
 |  | This range is named Fourth
 |  | 9604 | 15429 | 15429 | 15429 | 21880 | 21880 | 21880
 |  | 9604 | 15429 | 15429 | 15429 | 21880 | 21880 | 21880
 |  | 9604 | 15429 | 15429 | 15429 | 21880 | 21880 | 21880
 |  | 9604 | 15429 | 15429 | 15429 | 21880 | 21880 | 21880
 |  | 10094 | 17402 | 17402 | 17402 | 23219 | 23219 | 23219
 |  | 10094 | 17402 | 17402 | 17402 | 23219 | 23219 | 23219
 |  | 10094 | 17402 | 17402 | 17402 | 23219 | 23219 | 23219