tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 742915d1628111046-finding-column-header-and-value-of-first-column-based-on-maximum-value-of-range-sample
Sheet: Sheet1

Sample Data
Year | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
2010 | 34980 | 34438 | 48834 | 42360 | 42487 | 47140 | 50118 | 44497 | 41675 | 43533 | 40703 | 40748
2011 | 37290 | 33354 | 48180 | 40090 | 39388 | 48511 | 49247 | 45395 | 43631 | 46196 | 41274 | 41017
2012 | 37103 | 39990 | 53618 | 48377 | 49510 | 53515 | 54073 | 52341 | 47026 | 51845 | 47623 | 45509
2013 | 42673 | 43054 | 56145 | 46709 | 52099 | 54222 | 54142 | 52011 | 46830 | 49629 | 46413 | 48174
2014 | 43015 | 42673 | 59021 | 55683 | 56620 | 59373 | 57256 | 55856 | 51820 | 54580 | 50790 | 52783
2015 | 46944 | 43802 | 60750 | 53241 | 55014 | 59939 | 61156 | 55397 | 50176 | 53840 | 50849 | 51092
2016 | 44639 | 45806 | 58736 | 49896 | 52581 | 58746 | 56485 | 49098 | 50119 | 53373 | 52769 | 50886
2017 | 48847 | 47385 | 61199 | 49156 | 52898 | 59879 | 57238 | 49726 | 46264 | 56290 | 55146 | 51138
2018 | 48544 | 47192 | 62645 | 54880 | 60261 | 64784 | 62750 | 56015 | 50639 | 58282 | 55363 | 51239
2019 | 46079 | 49094 | 64649 | 59321 | 61848 | 65919 | 68447 | 56639 | 50282 | 56810 | 54000 | 56328
2020 | 51436 | 52825 | 36343 | 2928 | 11716 | 21344 | 26577 | 22698 | 22494 | 27836 | 24904 | 25760
2021 | 20781 | 22606 | 37215 | 32386 | 36523 | 52863 | 0 | 0 | 0 | 0 | 0 | 0
Desired Output
 | Best Month/Year: | Jul 2019
Spreadsheet: 41225d1239726033-excel-workbook-data-populating-project_issue_log
Sheet: Stats

 | may | jun | jul | aug | sept | oct | nov | dec | jan | feb | [NAME] | apr | may | jun | jul | aug | sep | oct | nov | dec
Total Issues
Resolved Issues
Resolved This Month
Outstanding Issues
Outlook
Spreadsheet
New This Month
Spreadsheet: 798344d1664435445-create-summary-sheet-on-multiple-values-and-criteria-29092022-sample-file-for-excel-forum
Sheet: Branch 1

 | Opening | Dep | closing
furniture | 1500 | 300
Computer | 2000 | 200
furniture
furniture
furniture
Computer
furniture
Computer
Spreadsheet: 765102d1643170972-countifs-within-a-numerical-range-book1a2-ans
Sheet: Sheet1

 | Goal Differential | Moneylines
Game #1 | 3 | -200 | w |  |  |  | <=-200
Game #2 | -2 | -160 | l |  |  |  | >=-199 & <=-150
Game #3 | 4 | -120 | w |  |  |  | >=-149 & <=-100 |  | <<<<< what like to know how to put the numerical range in cells E3 & E4
Game #4 | -3 | -250 | l |  |  |  | >=100
Game #5 | 1 | 120 | w
Game #6 | 3 | 140 | w |  |  | FROM | TO | RESULT
Game #7 | -1 | -175 | l |  |  |  | -200
 |  |  |  |  |  | -199 | -150
 |  |  |  |  |  | -149 | -100
 |  |  |  |  |  | -100
Spreadsheet: 102635d1300608513-automate-new-sheets-in-workbook-stock
Sheet: 2

Name Product: | Tape |  | Report
Code: | 3423423 | Supplier: | Staples
Colour: | Red | [NAME]: | Small
Price/Unit: | 200 | Price Sale/Unit: | 300
Date | Description | Inv.No. | Receive | Sale | Balance | Remark
2011-03-17 00:00:00 | Tape 2 | 435345242 | 20 | 3
Spreadsheet: 470306d1468428585-calculate-consistency-efficiency-in-a-column-of-numbers-laptimes-sample
Sheet: Sheet1

 |  |  | 2016-06-20 00:00:00
 | lap | laptime | total time |  | Laps | Fast Lap | [NAME]
 | 1 | 23.58 | 23.58
 | 2 | 22.04 | 45.62
 | 3 | 22.08 | 67.7
 | 4 | 22.45 | 90.15
 | 5 | 20.94 | 111.09
 | 6 | 22.75 | 133.84
 | 7 | 21.21 | 155.05
 | 8 | 21.14 | 176.19
 | 9 | 21.61 | 197.8
 | 10 | 20.31 | 218.12
 | 11 | 21.81 | 239.93
 | 12 | 21.91 | 261.84
 | 13 | 21.81 | 283.65
 | 14 | 22.35 | 306
 | lap | laptime | total time |  | Laps | Fast Lap | [NAME]
 | 1 | 22.61 | 22.61
 | 2 | 22.95 | 45.56
 | 3 | 24.15 | 69.7
 | 4 | 22.75 | 92.45
 | 5 | 23.98 | 116.43
 | 6 | 23.25 | 139.67
 | 7 | 23.18 | 162.85
 | 8 | 31.68 | 194.54
 | 9 | 22.85 | 217.38
 | 10 | 23.88 | 241.26
 | 11 | 23.61 | 264.87
 | 12 | 22.61 | 287.49
 | 13 | 22.38 | 309.86
Spreadsheet: 8d325d69-8c23-4bab-9044-639841b5e497
Sheet: Overall

Model/Size | Dell | Souther Computer Warehouse (SCW) | CarahSoft ** <20 (Per Order) | CarahSoft **>20 (Per Order) and Renewal | Accuuvent                                       1-1,499 devices on one PO | Accuuvent                                       1,500-4,999 devices on one PO | Accuuvent                                       5000+ devices on one PO
2 GB Devices
IronKey 2GB Personal D200 - 2FIPS
IronKey 2GB Enterprise D200 - 4FIPS
4 GB Devices
IronKey 4 GB Personal D200 - 2FIPS | 77.89 |  | 72.27 | 70.29
IronKey 4 GB Enterprise D200 - 4FIPS |  |  | 71.28 | 63.9
8 GB Devices
IronKey 8 GB Personal D200 - 2FIPS | 100.91 |  | 94.17 | 91.59
IronKey 8 GB Enterprise D200 - 4FIPS |  |  | 92.88 | 90.3
16 GB Devices
IronKey 16 GB Personal D200 - 2FIPS |  |  | 145.27 | 141.29
IronKey 16 GB Enterprise D200 - 4FIPS |  |  | 143.28 | 139.3
32 GB Devices
IronKey 32 GB Personal D200 - 2FIPS |  | 239.74 | 218.27 | 212.29
IronKey 32 GB Enterprise D200 - 4FIPS |  | 253.21 | 215.28 | 209.3
64 GB Devices
128 GB Devices
Device Management Software Costs
IronKey Enterprise Management Service 1YR | 18.68 | 20.59 | 17.28 | 2FIPS -$16.80    4FIPS-$16.56
IronKey Enterprise Management Service 2YR | 35.09 | 40.2 | 32.4 | 2FIPS-$31.50    4FIPS-$31.05
IronKey Enterprise Management Service 3YR | 46.39 | 53.8 | 43.2 | 2FIPS - $42.00 4FIPS - $41.40
IronKey Enterprise Server |  | 4227.1
Spreadsheet: 107798d1304953275-show-first-2-digits-from-8-digit-number-in-separate-cell-ist-2-digits
Sheet: Sheet1

 | 8 digit number |  |  | 1st 2 digits
 | 1234567 |  |  | 12
 | 2234567 |  |  | 22
 | 3234567 |  |  | 32
 | 4234567 |  |  | 42
 | 11001234 |  |  | 11
 | 12235654 |  |  | 12
 | 13235654 |  |  | 13
 | 14235654 |  |  | 14
 | 15235654 |  |  | 15
 | 16235654 |  |  | 16
 | 17235654 |  |  | 17
Spreadsheet: jeffrey_a_shankman__13918__Pick Sheet - Week 17
Sheet: Week 2

NFL PICKS OF THE WEEK - 2001
Name:
Phone Number where we can reach you on Sunday morning:
Last Person Standing Team Pick:
SEND TO:   E-mail - [EMAIL] |  |  |  | Phone - (707) 255-4813 |  |  | Fax - (707) 255-4832
WEEK 2  - First Game is Sunday @ 9 a.m.
Sunday, September 16
 |  | Visitor |  |  |  | Home
 |  | Cincinnati Bengals |  |  |  | Tennessee Titans
 |  | Dallas Cowboys |  |  |  | Detroit Lions
 |  | Denver Broncos |  |  |  | Indianapolis Colts
 |  | Buffalo Bills |  |  |  | [NAME]
 |  | San Francisco 49er's |  |  |  | New Orleans Saints
 |  | Green Bay Packers |  |  |  | New York Giants
 |  | Philadelphia Eagles |  |  |  | Tampa Bay Buccaneers
 |  | Arizona Cardinals |  |  |  | Washington Redskins
 |  | New England Patriots |  |  |  | Carolina Panthers
 |  | Atlanta Falcons |  |  |  | St. Louis Rams
 |  | [NAME] |  |  |  | Chicago Bears
 |  | New York Jets |  |  |  | Oakland Raiders
 |  | Kansas City Chiefs |  |  |  | [NAME]
 |  | [NAME] |  |  |  | Pittsburgh Steelers
Monday, September 17
 |  | Minnesota Vikings |  |  |  | Baltimore Ravens
Tiebreaker |  |  |  | Total |  |  | Total should = 120
Entries must be received by the beginning of the first game of the week (earlier is perfectly ok!)
Always start by giving the team that you think is most likely to win 15 points and go down from there.
If there are only 14 games in a week, your lowest pick will be "2" instead of "1"
Bye Week: | San Diego Chargers
Spreadsheet: 35441d1233046202-average-over-variable-range-varied-average
Sheet: Sheet1

Time (s) | AA | BB | CC | DD | EE
1 | 0.06455885749880874 | 0.6530478513872691 | 0.03541858178371005 | 0.2393785388769984 | 0.9506233194741995
2 | 0.2472974686229339 | 0.1753931203836543 | 0.574005311168938 | 0.01799302029575411 | 0.610674299065705
4 | 0.3767801316728283 | 0.3880739896405681 | 0.4055656949791953 | 0.696977124758841 | 0.6254762220477108
5 | 0.9565446715955623 | 0.07667045660866467 | 0.9977294902399729 | 0.9062365462463529 | 0.8159604642649336
7 | 0.003969726048267397 | 0.7396761092447548 | 0.6836062132095888 | 0.9429721219337017 | 0.5694566346107557
8 | 0.8300783131134803 | 0.8405147549378846 | 0.6507992183918079 | 0.5594580748236349 | 0.3741827446094756
14 | 0.4182721974186319 | 0.5994057541782363 | 0.8020001046939518 | 0.146796868406879 | 0.6840783443853349
17 | 0.8363232063737978 | 0.2235156643560643 | 0.9697484199105546 | 0.5432542707455243 | 0.3718286985550288
19 | 0.3170889178720047 | 0.2236172177861144 | 0.3713433125961816 | 0.2739584716026346 | 0.5106296355788276
20 | 0.2827530055477323 | 0.08237249247318701 | 0.1905334850879745 | 0.27250733839431 | 0.2276449477085303
23 | 0.9895445372499942 | 0.7767930453522478 | 0.9663923685751366 | 0.2965793073265601 | 0.3349553513493033
Average
Between
min
[NAME]
Spreadsheet: 768497d1645001401-trying-to-look-up-and-filter-data-example
Sheet: RED C

Id numeric | Product | Component name | Result text
Spreadsheet: 135682d1326182948-solved-unable-to-sort-by-date-after-vlookup-sorting100112
Sheet: Sheet1

Login | FirstName | LastName | Date Created | AuditStr | Login Cleanse | Date Cleanse
gatcl | [NAME] | Gatto | 22/09/2009 02:44 PM | Create | gatcl | 22/09/2009
spear | [NAME] | [NAME] | 22/09/2009 02:44 PM | Create | spear | 22/09/2009
thokr | [NAME] | Thomasson | 22/09/2009 02:44 PM | Create | thokr | 22/09/2009
[NAME] | [NAME] | Whalen | 22/09/2009 02:44 PM | Create | [NAME] | 22/09/2009
[NAME] | [NAME] | [NAME] | 24/09/2009 10:05 AM | Create | [NAME] | 24/09/2009
yeoem | [NAME] | Yeoman | 24/09/2009 10:05 AM | Create | yeoem | 24/09/2009
mashu | Huw | Mason | 24/09/2009 10:05 AM | Create | mashu | 24/09/2009
brola | Lauraine | Brown | 24/09/2009 10:05 AM | Create | brola | 24/09/2009
freln | [NAME] | Frederiksen | 24/09/2009 10:05 AM | Create | freln | 24/09/2009
simro | [NAME] | [NAME] | 24/09/2009 10:05 AM | Create | simro | 24/09/2009
oshbr | Briony | [NAME] | 24/09/2009 10:05 AM | Create | oshbr | 24/09/2009
metcr | [NAME] | Metters | 24/09/2009 10:05 AM | Create | metcr | 24/09/2009
[NAME] | [NAME] | [NAME] | 23/09/2009 10:05 AM | Create | [NAME] | 23/09/2009
walgh | [NAME] | Walters | 24/09/2009 10:05 AM | Create | walgh | 24/09/2009
hawbr | [NAME] | Hawtin | 24/09/2009 10:05 AM | Create | hawbr | 24/09/2009
kergr | Greg | [NAME] | 24/09/2009 10:05 AM | Create | kergr | 24/09/2009
gooro | [NAME] | [NAME] | 24/09/2009 10:05 AM | Create | gooro | 24/09/2009
hargr | Greg | [NAME] | 24/09/2010 10:05 AM | Create | hargr | 24/09/2010
robjh | [NAME] | [NAME] | 24/09/2009 10:05 AM | Create | robjh | 24/09/2009
[NAME] | [NAME] | [NAME] | 24/09/2009 10:05 AM | Create | [NAME] | 24/09/2009
schst | [NAME] | Schoemaker | 24/09/2009 10:05 AM | Create | schst | 24/09/2009
setba | Bagus | Setiadi | 24/09/2009 10:05 AM | Create | setba | 24/09/2009
morka | [NAME] | Morgenstern | 24/02/2009 10:05 AM | Create | morka | 24/02/2009
warjo | Jon | Warby | 24/09/2009 10:05 AM | Create | warjo | 24/09/2009
[NAME] | [NAME] | [NAME] | 24/09/2009 10:05 AM | Create | [NAME] | 24/09/2009
piegr | Greg | Pietsch | 24/09/2009 10:05 AM | Create | piegr | 24/09/2009
smibe | Barrie | [NAME] | 24/09/2009 10:05 AM | Create | smibe | 24/09/2009
hinst | [NAME] | [NAME] | 24/09/2009 10:05 AM | Create | hinst | 24/09/2009
bisst | [NAME] | Bisset | 01/06/2009 10:05 AM | Create | bisst | 01/06/2009
comst | [NAME] | Comino | 24/09/2009 10:05 AM | Create | comst | 24/09/2009
comgr | Greg | Comber | 24/09/2009 10:05 AM | Create | comgr | 24/09/2009
Spreadsheet: 786618d1657303770-how-to-add-month-by-month-to-get-ytd-using-getpivotdata-in-google-sheet-2022-07-08-oeldere-johnyam54-how-to-sum-vlookup
Sheet: Unit volumns 

 | Current formalar
 | IFERROR((GETPIVOTDATA($AI$7,$V$7,$V$7,B6))/(VLOOKUP to price list
 | Product name | SUM of April | SUM of May | SUM of June | SUM of July | SUM of Aug | SUM of Sept | SUM of Oct | SUM of Nov | SUM of Dec | SUM of Jan | SUM of Feb | SUM of March | SUM of TOTAL |  |  |  | Rijlabels | Sum of SUM of April | Sum of SUM of May | Sum of SUM of June | Sum of SUM of July | Sum of SUM of Aug | Sum of SUM of Sept | Sum of SUM of Oct | Sum of SUM of Nov | Sum of SUM of Dec | Sum of SUM of Jan | Sum of SUM of Feb | Sum of SUM of March
 | Product 1 | 12998 | 10097 | 12213 | 11233 | 10702 | 11302 | 10528 | 9578 | 11747 | 13097 | 13315 | 12638 |  |  |  |  | Product 1 | 12998 | 10097 | 12213 | 11233 | 10702 | 11302 | 10528 | 9578 | 11747 | 13097 | 13315 | 12638
 | Product 2 | 12212 | 11940 | 11459 | 12390 | 13108 | 9590 | 12611 | 10480 | 11558 | 10421 | 11989 | 13107 |  |  |  |  | Product 2 | 12212 | 11940 | 11459 | 12390 | 13108 | 9590 | 12611 | 10480 | 11558 | 10421 | 11989 | 13107
 | Product 3 | 10642 | 9546 | 9851 | 10453 | 9593 | 11153 | 13128 | 12034 | 10333 | 9719 | 11039 | 10206 |  |  |  |  | Product 3 | 10642 | 9546 | 9851 | 10453 | 9593 | 11153 | 13128 | 12034 | 10333 | 9719 | 11039 | 10206
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Eindtotaal | 35852 | 31583 | 33523 | 34076 | 33403 | 32045 | 36267 | 32092 | 33638 | 33237 | 36343 | 35951
 | Requirement please
 | How can I wrap sum into getpivitdata to add April and May so I have amy Ytd costs
 | How to find Unit sales
 |  | Unit sales
 | Product 1 |  | manual approach-assuming I have to do this from June to March 23, I'll be adding every month
 | Product 2 |  | How can I wrap sum into getpivotdata so I'll be expanding the range each month
 | Product 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | $AI$7, = | SUM of TOTAL on the original file
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | $V$7,$V$7= | Product name on the original file
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Assuming price list is
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Product 1 | 800
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Product 2 | 950
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Product 3 | 850
Spreadsheet: 169021d1342681985-matching-info-from-cell-to-cell-and-returning-yes-or-no-match-iserror
Sheet: Sheet1

 |  |  |  | [NAME] |  |  |  | BAK RWW 9
 |  |  |  | [NAME] |  |  |  | BAK RWW 4
 |  |  |  | [NAME] |  |  |  | BAK RWW 1
 |  |  |  | BAK Blue |  |  |  | BAK Pears
 |  |  |  | BAK Blue |  |  |  | BAK AW 09
 |  |  |  | BAK EW 9 |  |  |  | BAK AW 15
 |  |  |  | BAK FAV F1 |  |  |  | BAK AW 19
 |  |  |  | BAK FAV F1 |  |  |  | BAK FLAT PRICE
 |  |  |  | BAK FAV F7 |  |  |  | BAK C31
 |  |  |  | BAK FAV F7 |  |  |  | BAK C42
 |  |  |  | BAK FLAT MR TEST |  |  |  | [NAME]
 |  |  |  | BAK FLAT PRICE |  |  |  | BAK EW 3
 |  |  |  | BAK FLAT PRICE |  |  |  | BAK Young
 |  |  |  | BAK FLAT PRICE |  |  |  | BAK Spinach
 |  |  |  | BAK Grapes |  |  |  | BAK Seals
 |  |  |  | BAK Grapes |  |  |  | [NAME]
 |  |  |  | BAK Grapes |  |  |  | BAK FAV AW1
 |  |  |  | BAK Holiday 4 |  |  |  | BAK FLAT PRICE
 |  |  |  | BAK Holiday 4 |  |  |  | BAK FAV C3
 |  |  |  | BAK Ivanhoe |  |  |  | BAK FAV F7
 |  |  |  | BAK JAYDEN |  |  |  | BAK FAV H5
 |  |  |  | BAK JAYDEN |  |  |  | BAK HJH
 |  |  |  | BAK JAYDEN |  |  |  | BAK Kangaroos
 |  |  |  | BAK JAYDEN |  |  |  | BAK Lighthouse
 |  |  |  | BAK JAYDEN |  |  |  | [NAME]
 |  |  |  | BAK KAI |  |  |  | BAK Grapes
Spreadsheet: 129147d1321469722-auto-populating-excel-calendar-calendar
Sheet: Dates

Date | Description
2011-11-19 00:00:00 | Appointment 1
2011-11-24 00:00:00 | Appointment 2
2011-12-11 00:00:00 | Appointment 3
2011-12-23 00:00:00 | Appointment 4
2012-01-03 00:00:00 | Appointment 5
2012-01-06 00:00:00 | Appointment 6
2012-01-07 00:00:00 | Appointment 7
2012-01-12 00:00:00 | Appointment 8
2012-01-15 00:00:00 | Appointment 9
2012-01-27 00:00:00 | Appointment 10
2012-02-03 00:00:00 | Appointment 11
2012-02-11 00:00:00 | Appointment 12
2012-02-12 00:00:00 | Appointment 13
2012-02-14 00:00:00 | Appointment 14
2012-02-15 00:00:00 | Appointment 15
2012-02-16 00:00:00 | Appointment 16
2012-02-22 00:00:00 | Appointment 17
Spreadsheet: darrell_schoolcraft__7807__imbalsumm0108
Sheet: Citizens

Citizens Communications
 | Measured | Scheduled | Imbalance
56659 | -20695 | -2340
500046 | -437 |  |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
500086 |  |  |  |  |  |  |  |  |  |  | lunch | 7.6
500134
500528
500529
500619
INDEX
2001-07-31 00:00:00 |  |  | -856340.66
2001-08-20 00:00:00
CBS Volume
 |  |  | -187753
Spreadsheet: 00b527ea-5dc8-4903-816f-df3aadc4aeda
Sheet: Sheet1

Table 2--Feed and residual use of wheat and coarse grains, 12/13/2012 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
Market year and quarter 1/ |  | Corn  (million metric tons) | Sorghum  (million metric tons) | Barley  (million metric tons) | Oats  (million metric tons) | Feed grains  (million metric tons) | Wheat  (million metric tons) | Energy feeds  (million metric tons) | Grain consuming animal units  (millions) | Energy feeds per grain consuming animal unit  (tons)
2010/11 | Q1 Sep-Nov | 52.50195271570364 | 2.278308027407873 | 0.03339892280853589 | 0.3692424370254856 | 55.18290210294554 | -1.710578956392525 | 53.47232314655302
 | [NAME] | 39.68639703314219 | 0.4116515212131603 | 0.1556294004142207 | 0.2911846112394775 | 40.54486256600905 | -0.07359084686626552 | 40.47127171914278
 | [NAME] | 18.15775402767459 | 0.3276752205139929 | 0.1724812688977974 | 0.262850502262973 | 18.92076101934935 | -1.653072499503316 | 17.26768851984604
 | [NAME] | 11.45222355578417 | 0.1001822534656735 | 0.5687614475406668 | 0.6743722960217218 | 12.79553955281223 | 5.569390126742816 | 18.36492967955505
 | MY Sep-Aug | 121.7983273323046 | 3.1178170226007 | 0.9302710396612208 | 1.597649846549658 | 127.4440652411162 | 2.132147823980709 | 129.5762130650969 | 92.37017534250782 | 1.402792758426942
2011/12 | Q1 Sep-Nov | 46.31783226330864 | 1.125526280695738 | -0.04624466235028046 | 0.33730317487533 | 47.73441705652942 | -0.4415450811975931 | 47.29287197533183
 | [NAME] | 39.20265696341595 | 0.144685120623853 | 0.2708709248116004 | 0.2283448137594565 | 39.84655782261086 | 1.198082936666694 | 41.04464075927756
 | [NAME] | 21.79157061845523 | 0.3898827100518819 | 0.02449399488891973 | 0.2052769136840692 | 22.4112242370801 | -1.866224686136671 | 20.54499955094343
 | [NAME] | 8.193912607240607 | 0.1348040616486636 | 0.9840054213375355 | 0.7461687309661247 | 10.05889082119293 | 11.65108576436233 | 21.70997658555526
 | MY Sep-Aug | 115.5059724524204 | 1.794898173020137 | 1.233125678687775 | 1.51709363328498 | 120.0510899374133 | 10.54139893369476 | 130.5924888711081 | 92.63855940822705 | 1.409699046545303
2012/13 | MY Sep-Aug | 105.4148965219434 | 1.905088491360424 | 1.103897538897824 | 1.567434024911323 | 109.991316577113 | 6.4472549035617 | 116.4385714806747 | 90.7737320670058 | 1.282734209878295
1/ Corn and sorghum, September 1-August 31 marketing year; Barley and oats, June 1-May 31 marketing year. Source: USDA, World Agricultural Outlook Board, World Agricultural Supply and Demand Estimates and supporting materials.
Data run: 12/11/2012
Spreadsheet: 376626d1423666446-if-cell-has-no-input-then-return-0-help
Sheet: Sheet1

STANDARD | MINDSTE- | SALGSPRIS | TILLÆG | AFGIFTSPL. | AFGIFT | SELEALARM | BRÆNDSTOF | REG.
360444 | 275174 | 0 |  |  |  | 400 | 602800
0 | 0 |  |  |  |  | 400 | 0
Spreadsheet: 859544d1707905809-meter-reading-problem-metering-report-rev-1
Sheet: sample

 |  |  |  |  |  |  |  |  |  |  | previous reading | current reading
 |  |  | No. | 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 | Final Reading | [NAME]
 |  |  | Meter A | 510773 | 516718 | 532814 | 547899 | 569236 | 575878 | 586945 | 587640 | 806230 |  |  | 806230
 |  |  | [NAME] | 703714 | 734689 | 770209 | 792476 | 810780 | 840263 | 865963 | 905216 | 368000 |  |  | 1273216
 |  |  | [NAME] | 878387 | 960102 | 967478.2 | 1047493 | 1107716 | 1245351.1 | 1630566.6 | 1918741 | 486000 |  |  | 2404741
 |  |  | G/F SWB MCCB 59 Reading |  |  |  |  | 1424215 | 1480414 | 1501525 | 1616104 | 1682211 | 123654
 |  |  | G/F SWB MCCB 60 Reading |  |  |  |  | 1075000.6 | 1096849.1 | 1099542.9 | 1101511 | 1132401 | 321456
 |  |  | Case background:
Spreadsheet: 864778d1711902223-create-new-list-of-matching-records-sample-workbook
Sheet: Background

FOCUS PRODUCTS SOLD OVER THE WEEK
Item | Category | Weight | Price | Remarks
Fish | Other | 120 | 10 | Hallibut
Fish | Other | 140 | 12.3 | Skate
Candy | Snacks | 30 | 1.4 | [NAME]
Candy | Snacks | 34 | 120 | Reese's Peanut Butter Cups
Fish | Other | 150 | 12.9 | Cod
Fish | Other | 120 | 10 | Shrimps
Fish | Other | 140 | 12.3 | Crayfish
Candy | Snacks | 30 | 1.4 | M&Ms
Candy | Snacks | 34 | 120 | Mike & Ikes
Fish | Other | 150 | 13.4 | Monkfish
Spreadsheet: 149780d1334137804-mulit-criteria-lookup-returning-a-range-ranaldh_01
Sheet: Sheet1

Driver | [NAME]
Car | Skoda |  |  |  |  |  |  |  |  |  |  | Database
Tyres | Pirelli
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | Mark | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | VW | VW | Ford | Skoda
A |  |  |  |  |  |  |  |  |  |  |  | Michelin | Avon | Pirelli | Pirelli
B |  |  |  |  |  |  |  |  |  |  | A
C |  |  |  |  |  |  |  |  |  |  | B
D |  |  |  |  |  |  |  |  |  |  | C
E |  |  |  |  |  |  |  |  |  |  | D
F |  |  |  |  |  |  |  |  |  |  | E
G |  |  |  |  |  |  |  |  |  |  | F
 |  |  |  |  |  |  |  |  |  |  | G
Spreadsheet: 122607d1317024587-total-marks-for-each-team-table-tennis
Sheet: Sheet1

 |  |  |  |  | Table tennis
 | Team | Match 1 |  |  | Match 2 |  |  | Match 3 |  |  | Match 4 |  |  | Marks
 |  | Set 1 | Set 2 | Set 3 | Set 1 | Set 2 | Set 3 | Set 1 | Set 2 | Set 3 | Set 1 | Set 2 | Set 3
 | A | 21 | 21 |  | 21 | 19 | 21 | 8 | 12 |  | 24 | 20 | 21 | 9 | 9
 | B | 12 | 18 |  | 9 | 21 | 17 | 21 | 21 |  | 22 | 22 | 19 | 3 | 3
 |  |  |  | 2 |  |  | 2 |  |  | 0 |  |  | 2
 |  | Win 2 sets = win match = 3  marks
 |  | Loss 2 sets = loss match = 0  marks
 |  | How to calculate total marks for each team?
Spreadsheet: 141837d1329478376-lookup-value-from-different-sheet-dummy-tl-wise-skill-matrix
Sheet: Sheet2

Years Experience | CODE WARRIOR |  | Trace-32 |  | C/C++ |  | CANoe |  | Bug Tracking Life Cycle |  | OSCILLOSCOPE |  | SVN |  | KVASER CAN CARD/Brake Analyzer |  | MAKE Files |  | DOXYGEN |  | RTOS - Real Time Operating |  | Canalyzer
0-2 | 0 ~ 1 |  | 0 ~ 1 |  | 0 ~ 1 |  | 0 ~ 1 |  | 0 ~ 1 |  | 0 ~ 1 |  | 0 ~ 1 |  | 0 ~ 1 |  | 0 ~ 1 |  | 0 ~ 1 |  | 1 |  | 0 ~ 1
2-4 | 2 |  | 2 |  | 2.5 |  | 1 ~ 2 |  | 2 |  | 1 ~ 2 |  | 1 ~ 2 |  | 1 |  | 1 ~ 2 |  | 1 |  | 2 |  | 1
4-6 | 3 |  | 3 |  | 3 ~ 4 |  | 2 ~ 3 |  | 2 |  | 2 ~ 3 |  | 2 ~ 3 |  | 1 ~ 2 |  | 2 ~ 3 |  | 1 ~ 2 |  | 3 |  | 1 ~ 2
6-8 | 3 ~ 4 |  | 3 ~ 4 |  | 4 ~ 5 |  | 3 ~ 4 |  | 3 |  | 3 ~ 4 |  | 3 |  | 2 ~ 3 |  | 3 ~ 4 |  | 2 ~ 3 |  | 3 ~ 4 |  | 2 ~ 3
Spreadsheet: 880601d1728409193-automated-calendar-with-changing-holidays-vakantie-template-mbv-cadix
Sheet: november

 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Opgenomen vakantie | Resterende vakantie
 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
 | Maxime
VPK | [NAME]
 | Cédric
 | Elke
 | Ellen
 | Els
 | Gert
 | Ief
 | [NAME]
 | Joeri
 | [NAME]
 | Kelly
 | [NAME]
 | [NAME]
 | Michel
 | Mirthe
 | Nadia
 | Neslihan
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Aanwezig | 1
 | ADV | A
 | Vakantie | V
 | Ziek | Z
ZK | Annelies
 | Herly
 | Nadia
 | Nele
 | Ranka
 | Sid
 | Aanwezig | 1
 | ADV | A
 | Vakantie | V
 | Ziek | Z
[NAME] | [NAME]
 | [NAME]
 | Hilde
 | Samira
 | Vicky
 | Tyra
 | Aanwezig | 1
 | ADV | A
 | Vakantie | V
 | Ziek | Z
Spreadsheet: 453536d1459353439-index-match-indirect-indirect-index-match
Sheet: FIRST

Day 1 | 8
Day 2 | 6
Day 3 | 2
Day 4 | 4
Day 5 | 7
Day 6 | 3
Day 7 | 4
Day 8 | 2
Day 9 | 3
Day 10 | 3
Day 11 | 6
Day 12 | 4
Day 13 | 2
Day 14 | 6
Day 15 | 1
Day 16 | 8
Day 17 | 6
Day 18 | 6
Day 19 | 7
Day 20 | 4
Day 21 | 2
Day 22 | 1
Day 23 | 8
Day 24 | 7
Day 25 | 8