tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 796566d1663352054-i-try-to-generate-a-list-based-on-a-criteria-but-studentsforumsumproduct-and-index
Sheet: Sheet1

 | Monday | Monday | Tuesday | Tuesday | Tuesday | Tuesday | Thursday | Thursday | Friday | Friday
Name | Hours per day | Subjects | Hours per day | Subjects | Hours per day | Subjects | Hours per day | Subjects | Hours per day | Subjects
George | 2 | Sociology | 2 | Sociology | 3 | Physics | 3 | Math | 5 | Business
Anna | 3 | Chemistry | 1 | Chemistry | 4 | Sociology | 5 | Sociology | 4 | Business
[NAME] | 1 | Sociology | 3 | Physics | 5 | Physics | 4 | Physics | 3 | Computer science
[NAME] | 2 | Computer science | 3 | Sociology | 6 | Physics | 2 | Chemistry | 4 | Math
Sophia | 3 | Chemistry | 2 | Sociology | 2 | Computer science | 5 | Physics | 5 | Physics
Amelia | 1 | Physics | 1 | Physics | 3 | Sociology | 4 | Physics | 4 | Sociology
[NAME] | 2 | Business | 2 | Sociology | 1 | Sociology | 3 | Chemistry | 3 | Physics
[NAME] | 1 | Chemistry | 2 | Sociology | 2 | Math | 4 | Law | 4 | Computer science
 |  |  | Name | List of Subjects he/she attended | Hours per each subject |  | Monday | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY
 |  |  | Amelia | Sociology
 |  |  |  | Physics
 | Math |  |  | Math
 | Sociology |  |  | Business
 | Chemistry
 | Physics
 | Computer science
 | Business
 | Law
Spreadsheet: 90170d1289931183-cannot-get-formulas-to-populate-a-protected-worksheet-when-inserting-rows-bcs-scope-list-template
Sheet: Building10

Building10
 | Reference No. | Year | Priority | BCS Reference | Items | Existing Conditions | Recommendations | New Const. | Additions | Alteration | Major Systems | Major Repair | Energy | Bond | Capital | Estimated Cost with Incidental
 |  | SITE ISSUES
 |  | ARCHITECTURAL ISSUES
 |  | MECHANICAL ISSUES
 |  | PLUMBING ISSUES
 |  | ELECTRICAL ISSUES
Spreadsheet: 217478d1362077694-how-to-use-tallies-in-spreadsheet-to-create-account-119-tasman-trading
Sheet: Sheet2

dec12-jan13 | M1 | M2 | M3 | trsf | po | fx | txt | em | time | ? | ph# | msg
29 | 1 |  |  |  |  |  |  |  | 1213 | t | 7-3788835 | [NAME] part for the juicer on the front, x2, white, 835 state hgway 1, rd4, taupo - visa 4999 1400 0020 0419 xp 05/13 m [NAME] (pls call re new model)
31 | 1 |  |  |  |  |  |  |  | 1312 | t |  | [NAME] OK with the credit card?
jan
2 | 2
3 | 1
 | 1 |  |  |  |  |  |  |  |  |  | 221251634 | [NAME] didn't arrive
4 |  | 1 |  |  |  |  |  |  | 1029 | t |  | [NAME] x juicer stainer - 383 Lockington Rd., Katikati rd2 3178 ph 07 5520997 Mcard 5402 2310 2214 1919 xp 04/16 Eva-[NAME] (517)
 |  | 1 |  |  |  |  |  |  | 1153 | t | 6-8750182 | [NAME] 18 Beach Rd., Hamoana, Hawkes Bay 4102 - plastic part (clear part) split and leaking.
 |  | 1 |  |  |  |  |  |  | 1215 | t | 4161816 | Aria - older model [NAME] wanted
 |  | 1 |  |  |  |  |  |  | 1403 | t | 212410010 | [NAME] coffee - 27 [NAME], ohakune 4625 - part on top of centrifuge with black plastic filter
 |  | 1 |  |  |  |  |  | 1 | 1455 | t | [EMAIL] | [NAME] to order another 3 juicers urgently for Totara Trust - 9-4365127
5 | 1 |  |  |  |  |  |  |  | 1010 | t | 4-4766359 or [PHONE] | [NAME] espin Cr, Karori, Wellington 6012 - wheat grass spray query
 | 1
 | 1
7 | 1 |  |  |  |  |  |  |  | 1038
 | 1 |  |  |  |  |  |  |  | 1350 |  |  | [NAME] lock rings ordered
 | 1 |  |  |  |  |  |  |  | 1434 |  | 274777556 | [NAME] - wheat grass cream needed urgently for injury
 | 1 |  |  |  |  |  |  |  | 1748 | t | 4-2987205 | kay - common sense organics kapiti - 1 x white oscar - coastalnds shopping cnetre paraparaumu.
8 | 1 |  |  |  |  |  |  |  | 0845 | t | 8339853 | bev - oscar problems
Totals | 14 | 5 | 0 | 0 |  |  |  | 1
Spreadsheet: 826475d1682028951-pull-data-from-one-sheet-to-another-from-last-data-entered-in-a-column-and-the-12-24-above-ak-sample3-2-
Sheet: COVER-12

 | ANIMAL KINGDOM |  |  |  |  |  | unlock 1111 |  |  |  |  |  |  | combo | Cover
Well No. | 12H | 13H | 14H | 15H | Total |  |  |  |  |  |  |  |  | combo
Start Date: |  |  |  |  |  |  |  |  |  |  |  |  |  | combo
Online/Hrs |  |  |  |  |  |  |  |  |  |  |  |  |  | combo
Choke |  |  |  |  |  |  |  |  |  |  |  |  |  | lt f
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | lt p
Casing PSI |  |  |  |  |  |  | Copy and paste table into email body |  |  |  |  |  |  | fork
Surface Csg |  |  |  |  |  |  |  |  |  |  |  |  |  | lift
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | trash
Water / Day |  |  |  |  |  | Clear | enter water totals in this row.  the row above where 0 is will calculate bbl per hour |  |  |  |  |  |  | ft
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | ft
Oil / Day |  |  |  |  |  |  | enter oil totals in this row.  the row above where 0 is will calculate bbl per hour |  |  |  |  |  |  | plug C
[NAME] to sales |  |  |  |  |  |  |  |  |  |  |  |  |  | plug C
Gas / Day |  |  |  |  |  |  | enter gas totals in this row.  the row above where 0 is will calculate bbl per hour |  |  |  |  |  |  | plug C
Inj / Day | off | off | off |  |  |  |  |  |  |  |  |  |  | st
 |  |  |  |  |  |  |  |  |  |  |  |  |  | st
Yesterday Lact |  |  |  |  |  |  |  |  |  |  |  |  |  | st
Notes: | Hello how are you? Oh Im doing ok. XXXX OPEN WELL XX/128  S/I XXXX psi. Going to the store, |  |  |  |  |  | gfhghcghghgvhvgvgvhgvhvghvgvgh
 | PM
 | 12H | 13H | 14H | 15H
GAS
WATER
OIL
 | AM |  |  |  |  |  | lact total
 | 12H | 13H | 14H | 15H |  |  | 0430 | 24 b4 |  |  |  |  | IF(g28-h28<0,0,g28-h28)
GAS |  |  |  |  |  | 750 |  | 118029
WATER |  |  |  |  |  | 760
OIL |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  | 0
Spreadsheet: 09279f50-ca70-4529-a1b2-2d9bb8cc538b
Sheet: ARwT Benefits

 | Arcata Rail with Trail Connectivity Project - Estimated Use
 | Estimate of Annual Use *1 | 294405
 | By [NAME] of Travel:
 | Walk/Jog | 156035
 | Bicycle | 117762
 | Rollerblade/Other | 20608
 | By [NAME]:
 | Male | 164867
 | Female | 129538
 | Means of Travel to Trail:
 | Drive | 164867
 | Bicycle | 58881
 | Walk/Jog | 32767
 | Other | 11776
 | Trip Purpose: *2
 | Health | 223748
 | Recreation | 123650
 | Commuting | 11776
 | Economic Benefits: | 2060836
 | Health Benefits: | 37683855
 | Transportation Benefits (saved VT/yr): | 16192
 | *1 Based on counts on over 30 trails nationwide; calibrated for local environment, trail length, surrounding land use, population, density, climate, number of visitors, aesthetics, and other factors. Includes all trips on the trail, many of which may be for short distances.
 | *2 Adds to more than 100%, since users cited more than one trip purpose.
Spreadsheet: 80076d1280307304-pivot-table-with-calculated-field-p-table-example
Sheet: Sheet1

 | Month 1 Forecast
 |  | July | August | Sept | Oct | Nov
 | Sales | 1550 | 1560 | 990 | 1320 | 1550
 | Payroll | 700 | 700 | 700 | 700 | 700
 | Travel | 55 | 50 | 102 | 40 | 52
 | Cost of Sales | 332 | 412 | 256 | 317 | 352
 | Sundries | 1 | -5 | 4 | 3 | 19
 | Month 2 Forecast
 |  | July | August | Sept | Oct | Nov
 | Sales | 1700 | 1560 | 990 | 1350 | 1560
 | Payroll | 710 | 700 | 690 | 700 | 700
 | Travel | 55 | 45 | 102 | 40 | 50
 | Cost of Sales | 350 | 410 | 260 | 300 | 370
 | Sundries | 1 | 2 | 4 | 11 | 19
 | What I want is this:
 | Month 2 Less Month 1
 |  | July | August | Sept | Oct | Nov
 | Sales | all calculated month 2 less month 1
 | Payroll
 | Travel
 | Cost of Sales
 | Sundries
 | Note
 | 1. This is a simplified example. I have around 1000 rows of accounts to compare each month.
 | 2. Account numbers tend to be the same from one month to the next but sometimes new ones are added.
Spreadsheet: joe_parks__14589__NGPL Storage CurrentDeals
Sheet: Sheet1 

NGPL Storage Information
NSS Contract # 114846 |  |  |  |  | Total Storage Balance by Location as of Jan 1st
Balance as of 1/1/02
Location | [NAME] | Balance |  |  | Location | [NAME] | Balance
Texok | 25658 | 472 |  |  | Texok | 25658
SouthTX | 25084 | 515360 |  |  | SouthTX | 25084
Louisiana | 25085 | 462538 |  |  | Louisiana | 25085
MSV = 999,975
MDQ = 13,333
 |  |  |  |  | January Activity
Withdrawal Quantity (WQ) |  |  |  |  | Date | K# | Withdrawal Amt
Balance > 499,988  then WQ = 13,333 |  |  |  |  | 1/1-1/4 | 114786 | 13000
Balance < 499,988  then WQ < 9,333 |  |  |  |  | 1/5 | 114786 | 10209
 |  |  |  |  | 1/6 | 114786 | 9393
 |  |  |  |  | 1/7 | 114786 | 5386
 |  |  |  |  | 1/8 | 114786 | 13000
NSS Contract # 114786 |  |  |  |  | 1/9 | 114786 | 11149
Balance as of 1/1/02 |  |  |  |  | 1/10-1/31 | 114786 | 13000
Location | [NAME] | Balance
Texok | 25658 | 0
SouthTX | 25084 | 243306
Louisiana | 25085 | 874305 |  |  | Service Deals
 |  |  |  |  | Contract # | Sitara #
 |  |  |  |  | 114846 | 1190492
MSV = 1,371,225 |  |  |  |  | 114786 | 134583, 1190490
MDQ = 18,283
 |  |  |  |  | Withdrawal Deals
Withdrawal Quantity (WQ) |  |  |  |  | Location | Sitara #
Balance > 685,613  then WQ = 18,283 |  |  |  |  | Louisiana | 244724
Balance < 685,613  then WQ < 12,798 |  |  |  |  | South TX | 244728
Spreadsheet: andy_zipper__154__ICE - Mar28 Power & Gas VOL
Sheet: ICE-EPM

Enron Power Marketing
Activity on ICE
UOM | Deals | Volume
MWhs
 |  |  |  |  |  |  | START | END
Enron Power Marketing, Inc.
Commodity Type:  All
Instruments:  All
Trade Dates:  Mar-28-01 thru Mar-28-01
Trade Date | Deal ID | Leg ID | B/S | Product | Hub | Strip | START | END | Option | Strike | Style | Counterparty | Price | Price Units | Qty Per Period | Periods | Total Quantity | Qty Units | Trader
Mar-28-01 | 197268607 |  | Bought | Firm-LD Peak | Ent | Next Day | Mar-29-01 | Mar-29-01 |  |  |  | Mirant Americas Energy Marketing, LP | 46.25 | USD / MWh | 50 | Hourly | 800 | MWhs | Carson , M
Mar-28-01 | 100978739 |  | Bought | Firm-LD Peak | Ent | 2001-04-01 00:00:00 | Apr-01-01 | Apr-30-01 |  |  |  | BP Energy Company | 47.5 | USD / MWh | 50 | Hourly | 16800 | MWhs | Carson , M
Mar-28-01 | 151186588 |  | Sold | Firm-LD Peak | Ent | 2001-04-01 00:00:00 | Apr-01-01 | Apr-30-01 |  |  |  | American Electric Power Service Corp. | 46.75 | USD / MWh | 50 | Hourly | 16800 | MWhs | Carson , M
Mar-28-01 | 146285938 |  | Sold | Firm-LD Peak | Cin | Next Day | Mar-29-01 | Mar-29-01 |  |  |  | El Paso Merchant Energy L.P. | 38.75 | USD / MWh | 50 | Hourly | 800 | MWhs | Dorland , C
Mar-28-01 | 685574751 |  | Bought | Firm-LD Peak | Cin | 2001-05-01 00:00:00 | May-01-01 | May-31-01 |  |  |  | Aquila Energy Marketing Corp | 49 | USD / MWh | 100 | Hourly | 35200 | MWhs | Dorland , C
Mar-28-01 | 14786290144 |  | Sold | Firm-LD Peak | Cin | 2001-04-01 00:00:00 | Apr-01-01 | Apr-30-01 |  |  |  | American Electric Power Service Corp. | 40.75 | USD / MWh | 50 | Hourly | 16800 | MWhs | Dorland , C
Spreadsheet: 823720d1680108801-how-to-find-coordinates-using-slope-and-height-sample-workbook
Sheet: slope sample

24 | 23 | 21 | 21 | 23
26 | 26 | 24 | 22 | 22
27 | 26 | 24 | 23 | 23
24 | 24 | 21 | 21 | 22
23 | 25 | 22 | 21 | 20
24 | 27 | 27 | 26 | 23
20 | 24 | 25 | 27 | 27
21 | 20 | 20 | 21 | 24
25 | 23 | 20 | 19 | 20
24 | 25 | 24 | 23 | 21
Spreadsheet: 143135d1330217590-help-with-lookup-etc-should-be-easy-question-excel-question
Sheet: Sheet1

Unique | Category | Value
Stock
Code
TLS | BCD | 50000
WPL | BCG | 25000
ANZ | BCD | 15000
CHN | SPC | 90000
NUP | SPC | 20000
OST | BCG | 15000
WBC | BCD | 6000
PRR | SPC | 5000
ORE | SPC | 8000
CWP | SCG | 25000
TSM | SCD | 30000
Category Totals |  |  | How do I tell it to calculate the category totals?
BCD
BCG
SCD
SCG
SPC
Spreadsheet: 215719d1361462991-get-maximum-value-per-row-of-an-embedded-2d-array-to-create-an-embedded-1d-column-vector-excel-problem-locate-string-in-array
Sheet: Problem

Match all Items where a given name occurs, and all the times it occurs |  |  |  |  |  |  |  |  |  | This is what the formulae give |  |  |  |  |  | This is desired result
 |  | Item | Name 1 | Name 2 | Name 3 | Name 4 | Name 5 | Name= | *avi* | Item | Item Row | Name 1 | Name 2 | Name 3 |  | Item | Item Row | Name 1 | Name 2 | Name 3
 |  | First | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] |  |  |  |  |  |  |  |  | Second | 5 | [NAME] | [NAME] | [NAME]
 |  | Second | [NAME] | [NAME] | George | [NAME] | [NAME] |  |  |  |  |  |  |  |  | Third | 6 | [NAME] | - | -
 |  | Third | [NAME] | Sheena | [NAME] | George | Susan2 |  |  |  |  |  |  |  |  | Fourth | 7 | David1 | - | -
 |  | Fourth | Anne | [NAME] | David1 | [NAME] | [NAME] |  |  |  |  |  |  |  |  | - | - | - | - | -
 | I need to use SMALL on a 1-col vector [NAME] derived from the 4x5 matrix array by obtaining the MAX value per row
 | HOW?
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bracket Counts
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ( | )
 | ISNUMBER(SEARCH($J$20,$D$21:$H$24)) |  |  |  |  |  | IF(ISNUMBER(SEARCH($J$20,$D$21:$H$24)),ROW($21:$24),0) |  |  |  |  |  | SMALL(IF(ISNUMBER(SEARCH($J$20,$D$21:$H$24)),ROW($21:$24)),ROW(*:*))
 |  | False | False | False | False |  |  | False | False | False | False |  |  | 5
 | False | True | False | True | True |  | False | 5 | False | 5 | 5 |  |  | 6
 | True | False | False | False | False |  | 6 | False | False | False | False |  |  | 7
 | False | False | True | False | False |  | False | False | 7 | False | False |  |  | -
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -
Spreadsheet: kate_symes__18429__MidC
Sheet: DJ Mid-C Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-01-05 00:00:00 |  | 146.05 | 22800 | 135.85 | 3616
 | 2001-01-04 00:00:00 |  | 152.95 | 20280 | 139.1 | 5544 | 143.03 | 190 | 127.53 | 415
 | 2001-01-03 00:00:00 |  | 175.7 | 14400 | 163.68 | 3800 | 156.14 | 485 | 127.71 | 648
 | 2001-01-02 00:00:00 |  | 185.67 | 14400 | 176.33 | 3000 | 142.46 | 2097 | 126.6 | 1453
 | 2001-01-01 00:00:00 |  | 187.5 | 0 | 175 | 0 | 111.05 | 95 | 110 | 300 |  | 176.33 | 9000
 | 2000-12-31 00:00:00 |  | 167.5 | 0 | 157.5 | 0 | 150.12 | 2630 | 110 | 450 |  | 164.5 | 19440
 | 2000-12-30 00:00:00 |  | 171.7 | 19408 | 160.7 | 5608 | 146.38 | 705 | 145.32 | 1175
 | 2000-12-29 00:00:00 |  | 217.65 | 10992 | 169.05 | 3208 | 214.02 | 1107 | 166.68 | 674
 | 2000-12-28 00:00:00 |  | 217.65 | 10992 | 169.05 | 3208 | 190.98 | 1381 | 158.36 | 802
 | 2000-12-27 00:00:00 |  | 394.68 | 12400 | 267.17 | 3320 | 165.54 | 2855 | 159.35 | 1123
 | 2000-12-26 00:00:00 |  | 451.15 | 10624 | 428.32 | 2712 | 182.26 | 2772 | 177.14 | 934
 | 2000-12-25 00:00:00 |  | 410 | 32 | 315 | 200 | 201.38 | 12441 | 207.74 | 775 |  | 377.09 | 5160
 | 2000-12-24 00:00:00 |  |  |  | 315 | 200 | 225.8 | 1588 | 225.35 | 855 |  | 377.09 | 5160
 | 2000-12-23 00:00:00 |  | 462.41 | 8224 | 382.64 | 1912 | 325.41 | 4915 | 244.19 | 2400
 | 2000-12-22 00:00:00 |  | 463 | 8624 | 382.94 | 1712 | 349.16 | 4653 | 309.33 | 2630
 | 2000-12-21 00:00:00 |  | 463 | 8624 | 384.75 | 2112 | 425 | 150 | 350 | 50
 | 2000-12-20 00:00:00 |  | 463.54 | 9424 | 386.4 | 1912 | 411.71 | 1117 | 365.63 | 240
 | 2000-12-19 00:00:00 |  | 471.25 | 7824 | 408.97 | 312 | 547.65 | 3749 | 506.72 | 1005
 | 2000-12-18 00:00:00 |  | 372.89 | 7600 | 321.88 | 1600 | 378.62 | 360 | 328.33 | 150
 | 2000-12-17 00:00:00 |  |  |  |  |  | 368.41 | 1404 | 355.96 | 663 |  | 321.88 | 4800
 | 2000-12-16 00:00:00 |  | 317.57 | 11504 | 272.19 | 1112 | 374.92 | 642 | 339.88 | 168
 | 2000-12-15 00:00:00 |  | 317.59 | 11424 | 272.19 | 1112 | 364.78 | 598 | 477.91 | 763
 | 2000-12-14 00:00:00 |  | 459.34 | 7024 | 342.87 | 1712 | 380.91 | 1574 | 283 | 1890
 | 2000-12-13 00:00:00 |  | 700.87 | 7824 | 485.4 | 1712 | 391.35 | 1561 | 349.97 | 318
 | 2000-12-12 00:00:00 |  | 956.16 | 9024 | 636.87 | 2712 | 526.56 | 322 | 355.87 | 412
 | 2000-12-11 00:00:00 |  | 3322.42 | 5744 | 2166.67 | 600 | 1285.47 | 695 | 451.85 | 621
 | 2000-12-10 00:00:00 |  |  |  |  |  | 595.02 | 1607 | 516.15 | 975 |  | 2125 | 2400
 | 2000-12-09 00:00:00 |  | 781.79 | 10896 | 449.75 | 808 | 423.26 | 1913 | 496.71 | 380
 | 2000-12-08 00:00:00 |  | 781.79 | 10896 | 449.75 | 808 | 604.06 | 1877 | 475.29 | 433
 | 2000-12-07 00:00:00 |  | 628.75 | 8000 | 490 | 1000 | 664.04 | 2134 | 377.22 | 552
 | 2000-12-06 00:00:00 |  | 360.3 | 13200 | 283.68 | 3800 | 417.71 | 480 | 254.49 | 195
 |  |  |  |  |  | ..
Spreadsheet: 0e9be5b7-5c72-4134-9445-ed6e04be666f
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 8731.0 Building Approvals, Australia
 | TABLE 80. Value of Building Approved, Chain Volume Measures, Original - Tasmania
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Value of Approval ($M) ;  Chain Volume Measures ;  Tasmania ;  Total houses ;  New ; |  |  | Original | A590527L | 1985-09-01 00:00:00 | 2009-06-01 00:00:00 | 96 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Tasmania ;  Total other residential building ;  New ; |  |  | Original | A590528R | 1985-09-01 00:00:00 | 2009-06-01 00:00:00 | 96 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Tasmania ;  Total residential building ;  New ; |  |  | Original | A590529T | 1985-09-01 00:00:00 | 2009-06-01 00:00:00 | 96 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Tasmania ;  Total residential building ;  Total alterations/additions (incl. refurb and conversion) ; |  |  | Original | A590530A | 1985-09-01 00:00:00 | 2009-06-01 00:00:00 | 96 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Tasmania ;  Total residential building ;  Total (Type of Work) ; |  |  | Original | A590531C | 1985-09-01 00:00:00 | 2009-06-01 00:00:00 | 96 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Tasmania ;  Total non-residential building ;  Total (Type of Work) ; |  |  | Original | A590532F | 1985-09-01 00:00:00 | 2009-06-01 00:00:00 | 96 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Tasmania ;  Total building ;  Total (Type of Work) ; |  |  | Original | A590533J | 1985-09-01 00:00:00 | 2009-06-01 00:00:00 | 96 | $ Millions | FLOW | Quarter | 3
© Commonwealth of Australia  2009
Spreadsheet: 215839d1361507069-if-at-least-one-number-fails-the-rest-of-the-field-must-be-failed-book1-27-
Sheet: Sheet1

 | SO number | SO/LI number | Revision
 | 789 | 10 | 1
 | 789 | 20 | 0
 | 789 | 30 | 0
 | 564 | 10 | 0
 | 564 | 20 | 0
 | 564 | 30 | 0
 | 564 | 40 | 0
 | 321 | 10 | 1
 | 321 | 20 | 0
 | 321 | 30 | 0
Expected outcome |  |  |  |  |  | [NAME]
no of passed items (unique so numbers) |  |  | 1 |  |  |  | <---array formula
no of failed items(unique so numbers) |  |  | 2 |  |  |  | <---array formula
Total no of unique items |  |  | 3 |  |  |  | <---regular formula
Spreadsheet: 888320d1738823649-alter-formula-learning-the-ropes-weekly-scores-2-365-aligw
Sheet: Sheet1

 |  |  |  |  | WEEKLY SCORES |  |  |  |  |  |  |  |  |  |  | WEEKLY SCORES
Player Number | Name | Beginning Handicap | Current [NAME] |  | Week1 | Week2 | Week3 | Week4 | Week5 | Week6 | Week7 | Week8 | Week9 | Week10 | Week11 | [NAME] | Week13 | Week14 | Week15 | Week16 | Week17 | Week18 | Week19 | Week20 | Week21 | Week22 | Week23 | Week24 |  | Current [NAME] |  |  |  | Average Weekly  Score |  | HDCP Stroke Change |  | Full Year Handicap |  | Full Year Handicap change
1 |  |  |  |  | 38 | 45 | 42 | 45
2
3
4
5
6
7
8
9
10
11 |  |  |  |  | 39 | 45 | 43 | 44
12
13
14
15
16
17
18
19
20
21
22
23
Spreadsheet: 836573d1689500991-use-aggregate-function-with-multiple-criteria-book2
Sheet: Sheet1

Lv | Whatever | Helper |  | Roundup Value Of Each Lv
1 | 4.1 |  |  | 5
2 | 3.7 |  |  | 4
3
4 | 2.4 |  |  | 3
5 | 6
5 | 10
5 | 8.1
5 | 4.1
5 | 0.1
6 | 0.1
6
5 | 0.1
5 | 0.1
5 | 0.1
5 | 0.1
5 | 0.1
6 | 0.1
5 | 0.1 |  |  | 29 | combined value of lv 5
8 | 0.1
9 | 0.1
6 | 0.1
5 |  |  | Firstly need to sum the values of each lv which should be rounded-up to 0 dp on each lv
5 |  |  | [NAME] work but need to account for hidden rows & error values
Sum Of Spec'd Floors
01:03 |  |  | Secondly need to sum values of a specified range, with the same rounded-up conditions (Lv) as each floor above. Specfified range needs to be dynamic (not fixed).
01:03 |  |  | [NAME] works but want to use aggregate to avoid error & hidden values.
Spreadsheet: 680746d1591179259-vlookup-doesnt-wotk-but-should-1
Sheet: data

Code | PIB | Name | street | place
1 | 104364648 | DISTRIBUTER 018 | Riste Vujoševića bb | 18360 Svrljig
2 | 101329487 | PLAVI CVET STR  ZAJECAR | Ivana Milutinovica BB | 19000 [NAME]
3 | 100567572 | TPP CENTROISTOK AD BOR | ZELENI BULEVAR 23 | 19210 [NAME]
5 | 100415527 | TRGOVINA LAZIC TR  PROKUPLJE | KOSOVSKA 72 | 18400 Prokuplje
6 | 102291732 | MILOSCIC D.O.O. NIS | BULEVAR 12 FEBRUAR BB | 18000 Nis 18000
7 | 100354091 | MARMIL DOO PIROT | 22.DIVIZIJE 1 | 18300 Pirot
8 | 100549248 | MLADENOVIC DOO VRANJE | TRG SLOBODE 16 | 17500 Vranje
9 | 100492213 | METRO TR DOLJEVAC | DOLJEVAC | 18410 Doljevac
10 | 100107733 | MAK PROMET DOO LESKOVAC | 28.MART 4A | 16000 Leskovac
11 | 100821122 | KIVI STR BELA PALANKA | SRPSKIH VLADARA 73 | 18310 Bela Palanka
12 | 100356587 | MARAKANA STR PIROT | POLJSKA RZANA | 18300 Pirot
14 | 100354278 | PARGA STR  PIROT | SELO GNJILAN | 18300 Pirot
15 | 100541733 | MAX-PROM DOO LESKOVAC | [NAME] 7 | 16000 Leskovac
Spreadsheet: 766232d1643814162-formula-to-count-max-number-of-simultaneous-events-example
Sheet: Sheet1

2022-01-01 00:00:00 | 2022-01-10 00:00:00
2022-01-01 00:00:00 | 2022-01-02 00:00:00 |  | Date | Number of open events
2022-01-02 00:00:00 | 2022-01-04 00:00:00
2022-01-06 00:00:00 | 2022-01-10 00:00:00 |  | 2022-01-01 00:00:00 |  |  | =COUNTIFS(A:A,"<="&D4,B:B,">="&D4)
2022-01-07 00:00:00 | 2022-01-09 00:00:00 |  | 2022-01-02 00:00:00
 |  |  | 2022-01-03 00:00:00
 |  |  | 2022-01-04 00:00:00
 |  |  | 2022-01-05 00:00:00
 |  |  | 2022-01-06 00:00:00
 |  |  | 2022-01-07 00:00:00
 |  |  | 2022-01-08 00:00:00
 |  |  | 2022-01-09 00:00:00
 |  |  | 2022-01-10 00:00:00
 |  |  | [NAME] |  |  | =MAX(E4:[NAME])
Spreadsheet: 820470d1678117821-if-statement-with-3-criteria-help
Sheet: Sheet1

 |  | date difference | DOC Monthly | DOC Weekly | FC Start of Month | FC Weekly | Name | DoC | FC Date | Customer ID
 |  |  | 2022-09-01 00:00:00 | 2022-09-19 00:00:00 | 2022-09-01 00:00:00 | 2022-09-26 00:00:00 | ACTON | 2022-09-23 00:00:00 |  | 168e0311-09ff-4a90-af52-edd9a01fa00d
 |  |  | 2022-09-01 00:00:00 | 2022-09-19 00:00:00 | 2022-10-01 00:00:00 | 2022-10-03 00:00:00 | ACTON | 2022-09-22 00:00:00 | 2022-10-07 00:00:00 | 29ee19d4-3554-4158-be8c-b8e6fe0fd430
 |  |  | 2022-09-01 00:00:00 | 2022-09-19 00:00:00 | 2022-10-01 00:00:00 | 2022-10-03 00:00:00 | ACTON | 2022-09-25 00:00:00 | 2022-10-07 00:00:00 | d41eef85-38ef-46fb-ba61-bc642778d405
 | Want to show BLANK |  | 2022-09-01 00:00:00 | 2022-09-26 00:00:00 | 2022-10-01 00:00:00 | 2022-10-10 00:00:00 | ACTON | 2022-09-28 00:00:00 | 2022-10-08 00:00:00
 |  |  | 2022-09-01 00:00:00 | 2022-09-26 00:00:00 | 2022-10-01 00:00:00 | 2022-10-10 00:00:00 | ACTON | 2022-09-28 00:00:00 | 2022-10-12 00:00:00 | da38e7b4-b884-482b-b538-4cd9286069a4