tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 493640d1481814079-help-creating-auto-sum-quantity-sales
Sheet: Sheet1

Product name | What we got delivered | What we have in our Store 1 | What we have in our Store 2 | What we have in our Store 3 | [NAME] box to chose from what store how mutch quantity are sold | What we have left in Store 1 | What we have left in Store 2 | What we have left in Store 3 | What we have left from all Stores | All sold quantity
 | Delivevred | Store1 | [NAME] | Store3 | Store1 | Store1 [NAME] | [NAME] | Store3 Left | Store All | All Sold
Product 1 | 12 | 4 | 4 | 4
Product 2 | 13 | 4 | 2 | 7
Product 3 | 44 | 14 | 10 | 20
Product 4 | 31 | 10 | 10 | 11
Product 5 | 6 | 2 | 2 | 2
Product 6 | 4 | 1 | 2 | 1
Product 7 | 3 | 1 | 1 | 1
Product 8 | 46 | 20 | 16 | 10
Spreadsheet: 100367d1298737901-final-date-formula-from-inicial-and-duration-final-date-formula
Sheet: Sheet1

 | BORROWER | INICIAL DATE | LOAN AMOUNT | MONTH DURATION | FINAL DATE
 | PETER | 2010-02-18 00:00:00 | 1000 | 12 | 2011-02-17 00:00:00
 | [NAME] | 2010-01-25 00:00:00 | 1500 | 10 | 2010-11-23 00:00:00
 | PHILIP | 2010-02-17 00:00:00 | 2500 | 3 | 2010-05-16 00:00:00
 | DON | 2010-02-25 00:00:00 | 500 | 24 | 2012-02-24 00:00:00
 |  |  |  |  | I would need a formula in cells F6:F9
Spreadsheet: 880687d1728527266-highlighting-the-row-highlight
Sheet: Highlight

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Header> | Code | Name | Weight | Category | Assigned | Zero Rated
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 609702822 | M.D. Chem Pvt. Limited. | Mass | Entertainment | 1660160 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 300037575 | [NAME] | Mass | Entertainment | 2057061.62 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 609702822 | [NAME] | Mass | Entertainment | 168001 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 600890218 | My life Guide | Mass | Entertainment | 177585.31 | 0
Spreadsheet: 801194d1666110495-formula-to-sift-all-rows-containing-a-certain-number-into-a-table-on-another-sheet-sample
Sheet: Sheet1

Room | Element | As Existing | Work Required | By Whom | Sequence | Complete
Living Room | Floor | Bare floorboards, non-insulated, poor condition with gaps but complete | Floorboards raised and numbered to enable plumbing/electrical and insulation | [NAME] | 1 | N
 |  |  | Any joist repairs undertaken | [NAME] | 2 | N
 |  |  | Temporary chipboard sheets laid to enable further works | [NAME] | 2 | N
 |  |  | Plumbing and electrics | Contractor | 3 | N
 |  |  | Under floor insulation - Sheep Wool with membrane plus sound insulating sheep wool tape across joists | [NAME] | 4 | N
 |  |  | Floorboards replaced as original - all protruding nails hammered below surface | [NAME] | 5 | N
 |  |  | Initial rough course of HSS belt sanding - diagonal course | [NAME] | 6 | N
 |  |  | Gaps filled with reclaimed pine slivers. Slivers to be glued, set, and chiselled level | [NAME] | 7 | N
 |  |  | Medium course of HSS belt sanding, plus skirting sander for edges | [NAME] | 8 | N
 |  |  | Fine course of HSS belt sanding plus skirting sander for edges | [NAME] | 9 | N
 |  |  | Floor finish applied - oil-based (treatex, liberon, or osmo polyx) | [NAME] | 10 | N
Spreadsheet: 1d2f4adb-a7e8-478e-8f23-43bb9757f8b9
Sheet: Sheet1

GW-Body Code | GW-Body Name | Size | Recharge | Outflow | Major Abstraction | Balance | outflow                     % | % difference between outflow and recharge rates
 |  | km2 | [NAME] | [NAME] |  | [NAME] |  | %
[NAME] | Malta (Main) Mean Sea Level Aquifer | 216.6 | 34.27 | 36.05 | Potable, Agriculture | -2.37 | 105.1940472716662 | -5.194047271666165
MT002 | Rabat-Dingli Perched | 22.6 | 4.64 | 4.62 | Agriculture | 0.02 | 99.5689655172414 | 0.431034482758605
MT003 | [NAME] | 13.7 | 2.86 | 3.46 | Potable | -0.59 | 120.979020979021 | -20.97902097902097
 |  |  |  |  | Agriculture
MT005 | [NAME] | 2.8 | 0.7 | 0.69 | Agriculture | 0.01 | 98.57142857142857 | 1.428571428571431
MT006 | Mizieb Mean Sea Level | 5.2 | 1.11 | 0.96 | Potable | 0.15 | 86.48648648648648 | 13.51351351351352
 |  |  |  |  | Agriculture
MT008 | Mellieha Perched | 4.5 | 0.75 | 0.53 | Agriculture | 0.22 | 70.66666666666667 | 29.33333333333333
MT009 | Mellieha Coastal | 2.9 | 0.69 | 0.38 | Agriculture | 0.31 | 55.07246376811595 | 44.92753623188405
[NAME] | Marfa Coastal | 5.5 | 0.89 | 0.62 | Agriculture | 0.27 | 69.66292134831461 | 30.33707865168539
MT011 | [NAME] | 3.4 | 0.5 |  | Agriculture
MT012 | Comino Mean Sea Level | 2.7 | 0.52 | 0.3 | Agriculture | 0.22 | 57.69230769230769 | 42.30769230769231
MT013 | Gozo Mean Sea Level | 65.8 | 8.66 | 9.78 | Potable | -1.119999999999999 | 112.933025404157 | -12.93302540415704
 |  |  |  |  | Agriculture
MT014 | Ghajnsielem Perched | 2.7 | 0.85 | 0.34 | Agriculture | 0.39 | 40 | 60
MT015 | Nadur Perched | 5 | 1.33 | 0.58 | Agriculture | 0.57 | 43.60902255639097 | 56.39097744360903
[NAME] | [NAME] | 3 | 0.86 | 0.33 | Agriculture | 0.38 | 38.37209302325581 | 61.62790697674419
MT017 | [NAME] | 0.4 | 0.16 | 0.03 | Domestic | 0.07 | 18.75 | 81.25
MT018 | [NAME] Perched | 1.5 | 0.58 | 0.14 | Domestic | 0.25 | 24.13793103448276 | 75.86206896551724
Source: Malta Resources Authority 2005 data
working: outflow/recharge*100
Spreadsheet: acc39e1d-2806-4f65-bb20-c84d1af89679
Sheet: 2

 | Jul 5 |  | Jul 12 |  | Jul 19 |  | Jul 26
 | Long | Short | Long | Short | Long | Short | Long | Short
Total Interest Rate* | 400176292 | 400176292 | 407544951 | 407544951 | 409603188 | 409603188 | 415233742 | 415233742
SD/MSPs | N/A*** | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Cross-Currency | 16205406 | 16205406 | 16388810 | 16388810 | 16351629 | 16351629 | 16491326 | 16491326
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Credit | 20169699 | 20169699 | 20278667 | 20278667 | 20219318 | 20219318 | 20363235 | 20363235
Dealers** | 16836509 | 16829226 | 16999287 | 16975129 | 16964192 | 16936896 | 17079885 | 17053096
Buyside | 3333190 | 3340473 | 3279380 | 3303538 | 3255126 | 3282422 | 3283350 | 3310139
Total Equity | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Other Commodity | 3091000 | 3091000 | 3091000 | 3091000 | 3091000 | 3091000 | 3091000 | 3091000
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Weekly snapshot, estimated gross notional amount outstanding by asset class and participant type (millions of USD), all products, origins, currencies, tenors, and participant types, cleared and uncleared. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
*See Data Dictionary for asset class descriptions.
**See Explanatory Notes for participant type descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL]
Spreadsheet: 98214d1297213923-setting-expiry-date-with-conditional-formatting-sample
Sheet: Sheet1

 |  |  | FIRST
 | CERT III | TRADE | AID
 | Nil | Nil | (1YR)
PERSON 1 | NO | YES | 2012-01-17 00:00:00
PERSON 2 | NO | NO | 2012-01-17 00:00:00
PERSON 3 | NO | NO | 2012-01-17 00:00:00
PERSON 4 | NO | YES | 2012-01-24 00:00:00
PERSON 5 | NO | NO | 2011-03-11 00:00:00
PERSON 6 | YES | YES | 2011-03-10 00:00:00
Spreadsheet: 125084d1318871896-adding-a-column-without-damage-to-sheet-copy-of-box-inventory1
Sheet: LRS Non Haz

 |  | LRS [NAME]
Box # | Start Date | 50 Day | 70 Day | Box Location | Box Weight Empty | Material Weight | Delivered to Staging | Issues
4 | 2011-09-29 00:00:00 |  |  | Dedust | 9620 |  |  | utilitizing
 | Baghouse
 | Transfer Tower
 | Dedust
 | Fans
Spreadsheet: 145064d1331292093-date-problems-server-back-up
Sheet: Dates

Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday |  | 1st Monday | 2nd Monday | 3rd Monday | 4th Monday
 |  |  |  |  |  | 2012-01-01 00:00:00
 |  |  |  |  |  |  |  | 1st Of The Month
Spreadsheet: 77216d1277736828-does-this-require-vlookup-service-dispatch-w-tabs
Sheet: INTERNALS

Status | A Customer | S.A. | RO | Model | Promised | A-Tech | Hours | Dispatched At | Completed At | Job Description |  |  |  |  | Reason for Hold
ASSIGNED | INTERNAL | 11912 | 65678 | 10 XL1200X | ASAP | TF | 27.85 | 4/14/20104:36 PM |  | INST ACCYS
ASSIGNED | INTERNAL / KAEHLER / SCHNEIDER | 11856 | 66067 | 10 FLHTCU | 6/15 @ 12 | RAS | 0.5 | 6/14/20102:28 PM |  | INSTALL ACCYS
ASSIGNED | INTERNAL | AK | 66450 | 07 FLHX | 2010-05-24 00:00:00 | AC | 1.5 | 5/27/201010:13 AM |  | PERFORM UVD/ 15 POINT INSPECTION
ASSIGNED | INTERNAL | 11914 | 66541 | 10 FXDWG | 2010-05-27 00:00:00 | RAS | 4 | 5/27/20108:52 AM |  | IK SERVICE
ASSIGNED | INTERNAL MAJOR UNIT | 11965 | 66555 | 10 FXD | 2010-05-27 00:00:00 | MK | 0.75 | 6/3/201010:41 AM |  | DEALER TRADE
ASSIGNED | INTERNAL | 11928 | 66576 | 98 FLSTC | 2010-05-28 00:00:00 | DAN | 1.4 | 6/16/20101:32 PM |  | INSTALL ACCESSORIES
ASSIGNED | INTERNAL MAJOR UNIT | 11924A | 66623 | 03 FLSTF | 2010-06-01 00:00:00 | RS | 1.5 | 6/2/20103:53 PM |  | PERFORM UVD/15-PT INSPECTION, PERFORM RECALL 0119
ASSIGNED | INTERNAL MAJOR UNIT | 11975 | 66788 | 85 FLHS | 2010-06-08 00:00:00 | RS | 1.5 | 6/9/20104:23 PM |  | UVD/15-PT INSPECTION
ASSIGNED | INTERNAL | 11984 | 66875 | 02 FLSTCI | 2010-06-11 00:00:00 | MH | 1.5 | 6/15/201010:26 AM |  | UVD/15-PT INSPECTION
ASSIGNED | INTERNAL | 11998 | 67096 | 09 FLHX |  | MH | 1.5 | 6/25/20108:12 AM |  | PERFORM UVD/15-PT INSPECTION
ASSIGNED | INTERNAL / LEUBKE |  | 67119 | 05 XL883L | 2010-06-25 00:00:00 | MH | 1.5 | 6/25/20101:27 PM |  | PERFORM UVD/15-PT INSPECTION
HOLD - NO BIKE | INTERNAL / LENZEN | 11869 | 65844 | 10 FLHTK | 2010-05-14 00:00:00 | JZ | 15.05 | 5/10/201010:17 AM |  | INST ACCYS/ DYNO TIME
HOLD - PARTS - FUEL GAUGE | INTERNAL | Z401A | 66943 | 01 FLHTCU | 2010-06-16 00:00:00 |  | 1.5 |  |  | UVD/15-PT INSPECTION
HOLD - WAITING TO TALK TO AMY | INTERNAL | 11972 | 66693 | 04 FLSTFI | 2010-06-03 00:00:00 | RS | 1.5 | 6/8/201012:03 PM |  | PERFORM UVD/15-PT INSPECTION
NEEDS DYNO | INTERNAL | 11924 | 66479 | 10 FLHX | 2010-06-10 00:00:00 | AC | 6.95 | 6/9/201010:44 AM
 | SALES | 11771A | 66635 |  | 2010-06-11 00:00:00 |  | 1.5 |  |  | PERFORM UVD/15-PT INSPECTION
ASSIGNED | INTERNAL / ROBERT | Z384 | 66750 | 04 VRSC | WAITER | BS | 0.6 | 6/26/20109:48 AM |  | INSTALL ACCESSORIES
ASSIGNED | INTERNAL | 11970 | 66763 | 10 FLHTK | 2010-07-09 00:00:00 | BS | 16.75 | 6/28/20109:15 AM |  | INSTALL ACCESSORIES
ASSIGNED | INTERNAL | 11930 | 65959 | 10 FLHX | 2010-06-28 00:00:00 | RA | 2.7 | 6/28/20109:34 AM |  | INSTALL ACCESSORIES
Spreadsheet: 789495d1659118827-find-the-sum-of-large-4-numbers-from-5-different-cell-values-large-function
Sheet: Sheet1

Name | English |  |  | Math |  |  | Science |  |  | History |  |  | Geography
 | Theory | Practical | Total | Theory | Practical | Total | Theory | Practical | Total | Theory | Practical | Total | Theory | Practical | Total
[NAME] | 61 | 15 |  | 51 | 12 |  | 71 | 11 |  | 82 | 20 |  | 56 | 15
 |  |  |  | Total of Best 4 Subjects =
The result comes wrong. Since the best 4 numbers are 102, 82, 76 & 71 and their total is 331. But as the range is used the result comes different. What formula can get me the total of best four numbers considering only the Total column for each subject.
Spreadsheet: 147427d1332790659-financial-modeling-debt-calculation-problem-workbook1
Sheet: Sheet1

 | 1 | 2 | 3 | 4 | 5 | Total
Revenue
Costs
Base Financing Need
Interest
Required Debt
Interest Rate | 0.04
Years of Construction | 5
Spreadsheet: 718828d1613378946-extract-a-range-based-on-a-value-sample-16-ans
Sheet: Sheet2

EG740F
Power (kW) | Engine LS | Power take-off (rpm) | (Nm) |  | 70
70 | 900
70
70
70
Power (kW) | Engine HS | Power take-off (rpm) | (Nm)
70 | 700
70
Power (kW) | Engine LS | Power take-off (rpm) | (Nm)
100 | 1200
100
100
Power (kW) | Engine HS | Power take-off (rpm) | (Nm)
100 | 1300
 |  |  |  |  |  |  | TRUE Answer | Power (kW) | Engine LS | Power take-off (rpm) | (Nm)
 |  |  |  |  |  |  |  | 70 | 900 | 1485 | 450.1683501683502
 |  |  |  |  |  |  |  | 70 | 1000 | 1650 | 405.1515151515151
 |  |  |  |  |  |  |  | 70 | 1100 | 1815 | 368.3195592286501
 |  |  |  |  |  |  |  | 70 | 1200 | 1980 | 337.6262626262626
 |  |  |  |  |  |  |  | Power (kW) | Engine HS | Power take-off (rpm) | (Nm)
 |  |  |  |  |  |  |  | 70 | 700 | 1428 | 468.1372549019608
 |  |  |  |  |  |  |  | 70 | 800 | 1632 | 409.6200980392157
Spreadsheet: 05c7a794-754c-45f3-a988-63bbf635c13b
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 | Farm Sales: | 2000000 | sq/ft | -or- | 45.91368227731864
 | Sales Price: | 0 | sq/ft | = | 0
 | Cost: | 0.12 | sq/ft | = | 240000
 | Net Profit: | -0.12 | sq/ft | = | -240000
 | Lower Sales Price: | 0 | sq/ft | = | 0
 | Cost: | 0.12 | sq/ft | = | 240000
 | Net Profit: | -0.12 | sq/ft | = | -240000
 |  |  |  |  | 0
 |  |  |  |  | 0 | sq/ft | -or- | 0
 | Raise Sales Price: | 0 | sq/ft | = | 0
 | Cost: | 0.12 | sq/ft | = | 240000
 | Net Profit: | -0.12 | sq/ft | = | -240000
 |  |  |  |  | 0
 |  |  |  |  | 0 | sq/ft | -or- | 0
Spreadsheet: 867474d1714336546-profit-margin-calculation-and-bridge-illustration-book10-solution
Sheet: Sheet1

 | Excel Forum
 | Profit Margin - Calculation and 'Bridge' Illustration
 | keegan90
 |  |  | Budget |  |  |  |  |  |  |  | Actual
 | Product |  | Volume | Sales | Cost | Margin | Margin % | Average Sell Price | Mix % |  | Volume | Sales | Cost | Margin | Margin % | Average Sell Price | Mix % |  | Mix | Volume | Sell Price | Cost | Margin
 | Product 1 |  | 10 | 100 | 80 |  |  |  |  |  | 20 | 180 | 150
 | Product 2 |  | 20 | 300 | 150 |  |  |  |  |  | 25 | 250 | 150
 | Product 3 |  | 30 | 240 | 200 |  |  |  |  |  | 25 | 200 | 200
 | Product 4 |  | 40 | 240 | 180 |  |  |  |  |  | 40 | 250 | 200
 | Product 5 |  | 50 | 300 | 210 |  |  |  |  |  | 55 | 300 | 200
 | Total
Spreadsheet: 725074d1616517642-calculating-monthly-sales-totals-formula-book1
Sheet: Sales

Date | Sales
2021-01-04 00:00:00 | 0
2021-01-04 00:00:00 | 1
2021-01-06 00:00:00 | 2
2021-01-06 00:00:00 | 3
2021-01-08 00:00:00 | 2
2021-01-09 00:00:00 | 3
2021-01-09 00:00:00 | 4
2021-01-09 00:00:00 | 0
2021-01-09 00:00:00 | 5
2021-01-09 00:00:00 | 2
2021-01-12 00:00:00 | 2
2021-01-12 00:00:00 | 4
2021-01-13 00:00:00 | 4
2021-01-13 00:00:00 | 5
2021-01-14 00:00:00 | 5
2021-01-14 00:00:00 | 5
2021-01-14 00:00:00 | 4
2021-01-15 00:00:00 | 1
2021-01-15 00:00:00 | 3
2021-01-15 00:00:00 | 1
2021-01-16 00:00:00 | 1
2021-01-17 00:00:00 | 3
2021-01-18 00:00:00 | 2
2021-01-19 00:00:00 | 0
2021-01-20 00:00:00 | 3
2021-01-21 00:00:00 | 3
2021-01-22 00:00:00 | 0
2021-01-23 00:00:00 | 4
2021-01-24 00:00:00 | 3
2021-01-25 00:00:00 | 8
2021-01-26 00:00:00 | 3
2021-01-27 00:00:00 | 8
2021-01-28 00:00:00 | 0
2021-01-29 00:00:00 | 4
2021-01-30 00:00:00 | 3
2021-01-31 00:00:00 | 4
2021-02-01 00:00:00 | 4
2021-02-02 00:00:00 | 4
2021-02-03 00:00:00 | 0
2021-02-04 00:00:00 | 5
2021-02-05 00:00:00 | 5
2021-02-06 00:00:00 | 1
2021-02-07 00:00:00 | 5
2021-02-08 00:00:00 | 8
2021-02-09 00:00:00 | 5
2021-02-10 00:00:00 | 5
2021-02-11 00:00:00 | 0
2021-02-12 00:00:00 | 3
2021-02-13 00:00:00 | 0
2021-02-14 00:00:00 | 3
2021-02-15 00:00:00 | 3
2021-02-16 00:00:00 | 3
2021-02-17 00:00:00 | 3
2021-02-18 00:00:00 | 3
2021-02-19 00:00:00 | 3
2021-02-20 00:00:00 | 3
2021-02-21 00:00:00 | 3
2021-02-22 00:00:00 | 3
2021-02-23 00:00:00 | 6
2021-02-24 00:00:00 | 2
2021-02-25 00:00:00 | 1
2021-02-26 00:00:00 | 4
2021-02-27 00:00:00 | 1
2021-02-28 00:00:00 | 1
2021-03-01 00:00:00 | 1
2021-03-02 00:00:00 | 1
2021-03-03 00:00:00 | 4
2021-03-04 00:00:00 | 1
2021-03-05 00:00:00 | 1
2021-03-06 00:00:00 | 6
2021-03-07 00:00:00 | 1
2021-03-08 00:00:00 | 2
2021-03-09 00:00:00 | 1
2021-03-10 00:00:00 | 1
2021-03-11 00:00:00 | 1
2021-03-12 00:00:00 | 5
2021-03-13 00:00:00 | 1
2021-03-14 00:00:00 | 6
2021-03-15 00:00:00 | 6
2021-03-16 00:00:00 | 6
2021-03-17 00:00:00 | 5
2021-03-18 00:00:00 | 3
2021-03-19 00:00:00 | 2
2021-03-20 00:00:00 | 3
2021-03-21 00:00:00 | 4
2021-03-22 00:00:00 | 5
2021-03-23 00:00:00 | 1
2021-03-24 00:00:00 | 4
2021-03-25 00:00:00 | 3
2021-03-26 00:00:00 | 4
Spreadsheet: 109724d1306501121-excel-2007-specific-date-compared-to-date-range-fed-calc-v3
Sheet: Year 5

 | Case Number |  |  |  |  | Date Prepared
 | Non Custodial Parent |  |  |  |  |  | Reconciliation Date
 | CP/Caretaker
 | YEAR 5:
 |  | Amount Due |  |  |  |  |  | Charging
 |  |  |  |  |  |  |  | Order
Month |  | ORDER 1 | ORDER 2 | ORDER 3 | ORDER 4 | ORDER 5 |  | Amount
49 | January
50 | February
51 | March
52 | April
53 | May
54 | June
55 | July
56 | August
57 | September
58 | October
59 | November
60 | December
 | Support Due
 | Support Paid
 | [NAME]
 | Accrued Arrearage
 | Last Year Carryover
 | Lump/TANF
 | This Year
 | Total
 | Interest Rate
 | Arrears Interest
 | Fees Due
 | Fees Paid
 | Fees Owed
Spreadsheet: 69366d1269904556-if-functions-conditional-formatting-test
Sheet: Sheet1

 | League Position
 | TEAM A | TEAM B | TEAM C | TEAM D | TEAM E | TEAM F | TEAM G | TEAM H | TEAM I | TEAM J |  | Top Team Wins
2010-01-01 00:00:00 | 6 | 4 | 2 | 9 | 10 | 4 | 3 | 6 | 8 | 1
2010-01-02 00:00:00 | 9 | 7 | 1 | 4 | 4 | 6 | 2 | 7 | 10 | 3
2010-01-03 00:00:00 | 8 | 7 | 2 | 1 | 4 | 6 | 3 | 9 | 10 | 5
2010-01-04 00:00:00 | 9 | 8 | 2 | 1 | 3 | 7 | 4 | 5 | 10 | 6
 | Points
 | TEAM A | TEAM B | TEAM C | TEAM D | TEAM E | TEAM F | TEAM G | TEAM H | TEAM I | TEAM J
2010-01-01 00:00:00 | 1 | 1 | 3 | 0 | 0 | 1 | 3 | 1 | 0 | 3
2010-01-02 00:00:00 | 1 | 1 | 6 | 3 | 3 | 2 | 6 | 1 | 0 | 4
2010-01-03 00:00:00 | 2 | 2 | 7 | 6 | 6 | 2 | 6 | 1 | 1 | 4
2010-01-04 00:00:00 | 2 | 2 | 7 | 9 | 6 | 2 | 6 | 4 | 1 | 4
Spreadsheet: 1e06dc08-476e-47bc-a6d1-312c2a510b41
Sheet: инструкции RU

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Английский
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
1
2
3
1
2
3
4
5
6
 |  | 1
 |  |  |  |  |  | Ч | % |  |  |  |  | Ч | % | Ч | % | Ч | %
 |  |  |  |  |  | З |  |  |  |  |  | З |  | З |  | З
 |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | 0
Please select…
Please select…
Please select…
Please select…
Please select…
Spreadsheet: 683197d1592553329-true-or-false-not-working-with-if-error-in-zero-values-sample
Sheet: Sheet1

 |  |  |  | NAME | AMOUNT
 |  |  |  | Ambrosia | 8415
 |  |  |  | Apple | 4319
 |  |  |  | [NAME] | 1812 |  |  |  |  |  |  |  | NAME | AMOUNT
 |  |  |  | Anemone | 1866 |  |  |  | Row Labels | Sum of AMOUNT |  |  | Apple | 21225
 |  |  |  | [NAME] | 5662 |  |  |  | Ambrosia | 13796 |  |  | [NAME] | 11655
 |  |  |  | Ambrosia | 3886 |  |  |  | Anemone | 13350 |  |  | Calliope | 0
 |  |  |  | Anemone | 5862 |  |  |  | [NAME] | 14905 |  |  | Calyx | 0
 |  |  |  | Anemone | 4833 |  |  |  | Apple | 21225 |  |  | Camellia | 0
 |  |  |  | Ambrosia | 1495 |  |  |  | [NAME] | 11655 |  |  | Candy | 0
 |  |  |  | Anemone | 789 |  |  |  | Grand Total | 74931 |  |  | Cannon | 0
 |  |  |  | [NAME] | 6608 |  |  |  |  |  |  |  | Ambrosia | 13796
 |  |  |  | [NAME] | 6485 |  |  |  |  |  |  |  | Anemone | 13350
 |  |  |  | Apple | 8055 |  |  |  |  |  |  |  | [NAME] | 14905
 |  |  |  | [NAME] | 1994 |  |  |  |  |  |  |  | Canon | 0
 |  |  |  | Apple | 8851 |  |  |  |  |  |  |  | Cantor | 0
 |  |  |  | [NAME] | 3999 |  |  |  |  |  |  |  | [NAME] | 0
 |  |  |  | TOTAL |  |  |  |  |  |  |  |  | Cascade | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | Case | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | Cash | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | Cedar | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | Chance | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | Charisma | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | Charity | 0
Spreadsheet: 26675d1219048126-v-look-up-help-book4-1-
Sheet: Sheet1

Level | 14173675 | SYM BE SBSP 12.5 WIN ML CD BBP B12MO | Quantity |  | BOX PKG SYM BE 12.5 SMB (MED) [AP] | 14497562
1 | 11862320 | CTN ND [APAC] 392x353x272 BROWN | 0.1 |  | CARD ASY Backup Exec Not for Resale (OEMID 211 NO MAINT) | 14497563
1 | 91-50-90257 | LBL 102X210MM SHIPPER | 0.1 |  | CARD ASY Backup Exec Not for Resale (OEMID 214 NO MAINT) | 14497564
1 | SW | SHRINK WRAP | 1 |  | CARD ASY BE 12.5 for Windows Servers (OEMID 062 MAINT) | 14497565
1 | 91-50-90256 | LBL 60X25MM BOX P/N | 1 |  | CARD ASY BE 12.5 for Windows Servers (OEMID 063 MAINT) | 14497566
1 |  | BOX PKG SYM BE 12.5 SMB (MED) [AP] | 1 |  | CARD ASY BE 12.5 for Windows Servers (OEMID 211 NO MAINT) | 14497567
1 | 14368176 | STKR CONTENT SYM BE 12.5 [IN] | 1 |  | CARD ASY BE 12.5 for Windows Servers (OEMID 214 NO MAINT) | 14497568
1 | XXXXX | FLYER TECH SUPPORT SYM BE 12.0 WIN [AP] | 1 |  | CARD ASY BEWS 12.5 for Small Business Server (OEMID 062 MAINT) | 14497569
Spreadsheet: 791408d1660324581-formula-not-pulling-through-data-for-text-with-a-space-eh-template-1-
Sheet: Tues 29th June

⚽Updated scores⚽ |  |  |  |  | ⚽Updated scores⚽
England 🏴󠁧󠁢󠁥󠁮󠁧󠁿 🆚 Germany 🇩🇪 |  |  |  |  | Sweden [NAME] 🆚 Ukraine 🇺🇦
⚽5pm kick-off⚽ |  |  |  |  | ⚽8pm kick-off⚽
〰〰〰〰〰〰〰〰〰 |  |  |  |  | 〰〰〰〰〰〰〰〰〰
⚽ Amin A: 3-1 |  |  |  |  | ⚽ Amin A: 1-2
🏴󠁧󠁢󠁥󠁮󠁧󠁿 Arif J: 2-1 |  |  |  |  | 🏴󠁧󠁢󠁥󠁮󠁧󠁿 Arif J: 3-1
⚽ Din: 1-1. Wildcard applied. Amended original prediction of 3-2. No wildcards remaining |  |  |  |  | ⚽ Din: 3-1
🏴󠁧󠁢󠁥󠁮󠁧󠁿 Hanif E: 1-1 |  |  |  |  | 🏴󠁧󠁢󠁥󠁮󠁧󠁿 Hanif E: 2-0
[NAME]: 2-1 |  |  |  |  | [NAME]: 1-2
🏴󠁧󠁢󠁥󠁮󠁧󠁿 Mehboob: 2-1 |  |  |  |  | 🏴󠁧󠁢󠁥󠁮󠁧󠁿 Mehboob: 1-1
⚽ Mohamed: 2-1 |  |  |  |  | ⚽ Mohamed: 3-2
🏴󠁧󠁢󠁥󠁮󠁧󠁿 Muizz: 1-1 |  |  |  |  | 🏴󠁧󠁢󠁥󠁮󠁧󠁿 Muizz: N-S
⚽ [NAME]: 2-1 |  |  |  |  | ⚽ [NAME]: 1-1
🏴󠁧󠁢󠁥󠁮󠁧󠁿 Rahim V: 1-3 |  |  |  |  | 🏴󠁧󠁢󠁥󠁮󠁧󠁿 Rahim V: 1-1
⚽ Rayyan: 1-2 |  |  |  |  | ⚽ Rayyan: 0-0
🏴󠁧󠁢󠁥󠁮󠁧󠁿 Sahir: 1-0 |  |  |  |  | 🏴󠁧󠁢󠁥󠁮󠁧󠁿 Sahir: 1-1
⚽ Salim: 2-1 |  |  |  |  | ⚽ Salim: 1-1
🏴󠁧󠁢󠁥󠁮󠁧󠁿 Salman: 0-1 |  |  |  |  | 🏴󠁧󠁢󠁥󠁮󠁧󠁿 Salman: 2-1
[NAME]: 3-1 |  |  |  |  | [NAME]: 2-1
🏴󠁧󠁢󠁥󠁮󠁧󠁿 Shafiq: 2-1 |  |  |  |  | 🏴󠁧󠁢󠁥󠁮󠁧󠁿 Shafiq: 2-1
[NAME]: 0-1 |  |  |  |  | [NAME]: 1-0
[NAME]: 1-1 |  |  |  |  | [NAME]: 2-1
Spreadsheet: 700104d1602956052-sum-unique-values-based-on-criteria-for-different-dates-example-sjerpeli-
Sheet: Blad1

Customer number | Date purchased | Amount | Unique  Date/Customer | What I want to see
100 | 2020-10-01 00:00:00 | 2
100 | 2020-10-01 00:00:00 | 2
100 | 2020-10-02 00:00:00 | 2
100 | 2020-10-02 00:00:00 | 2
200 | 2020-09-01 00:00:00 | 3
200 | 2020-09-01 00:00:00 | 3