tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 682802d1592335109-formula-to-extract-numerical-value-with-decimal-not-working-data-extract
Sheet: EXTRACT

INNE  DOG  BALANCE  12  Kg
INNE  DOG  ATLANTIC  12  Kg
INNE  DOG  SENIOR  12  Kg
INNE  CHATON  POULET/KITTEN  1.5  Kg |  | 1.5
INNE  CAT  ADULT  POULET/CHICKEN  1.5Kg |  | 1.5
INNE  CAT  ADULT  POISSON/  FISH  1.5  Kg |  | 1.5
INNE  CAT  ADULT  STERILIZED  1.5  Kg |  | 1.5
INNE  CAT  ADULT  STERILIZED  1,5  Kg |  | 1,5
Spreadsheet: 0fa7ef16-bf1c-498b-9658-3f6f5447fbc5
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
 | 6302.0 Average Weekly Earnings, Australia
 | TABLE 14B. Average Weekly Earnings, Private and Public Sectors, Victoria (Dollars) - Original - Persons
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
Earnings; Persons; Full Time; Adult; Ordinary time earnings ;  Victoria ;  Private sector ; |  |  | Original | A2753973J | 1994-11-15 00:00:00 | 2012-11-15 00:00:00 | 73 | $ | RATIO | Quarter | 2
Earnings; Persons; Full Time; Adult; Total earnings ;  Victoria ;  Private sector ; |  |  | Original | A2753976R | 1994-11-15 00:00:00 | 2012-11-15 00:00:00 | 73 | $ | RATIO | Quarter | 2
Earnings; Persons; Total earnings ;  Victoria ;  Private sector ; |  |  | Original | [NAME] | 1994-11-15 00:00:00 | 2012-11-15 00:00:00 | 73 | $ | RATIO | Quarter | 2
Earnings; Persons; Full Time; Adult; Ordinary time earnings ;  Victoria ;  Public sector ; |  |  | Original | A2754198X | 1994-11-15 00:00:00 | 2012-11-15 00:00:00 | 73 | $ | RATIO | Quarter | 2
Earnings; Persons; Full Time; Adult; Total earnings ;  Victoria ;  Public sector ; |  |  | Original | A2754201A | 1994-11-15 00:00:00 | 2012-11-15 00:00:00 | 73 | $ | RATIO | Quarter | 2
Earnings; Persons; Total earnings ;  Victoria ;  Public sector ; |  |  | Original | A2754207R | 1994-11-15 00:00:00 | 2012-11-15 00:00:00 | 73 | $ | RATIO | Quarter | 2
Standard Errors ;  Earnings; Persons; Full Time; Adult; Ordinary time earnings ;  Victoria ;  Private sector ; |  |  | Original | A3524583K | 2009-05-15 00:00:00 | 2012-11-15 00:00:00 | 15 | $ | RATIO | Quarter | 2
Standard Errors ;  Earnings; Persons; Full Time; Adult; Total earnings ;  Victoria ;  Private sector ; |  |  | Original | A3524586T | 2009-05-15 00:00:00 | 2012-11-15 00:00:00 | 15 | $ | RATIO | Quarter | 2
Standard Errors ;  Earnings; Persons; Total earnings ;  Victoria ;  Private sector ; |  |  | Original | A3524589X | 2009-05-15 00:00:00 | 2012-11-15 00:00:00 | 15 | $ | RATIO | Quarter | 2
Standard Errors ;  Earnings; Persons; Full Time; Adult; Ordinary time earnings ;  Victoria ;  Public sector ; |  |  | Original | A3527823R | 2009-05-15 00:00:00 | 2012-11-15 00:00:00 | 15 | $ | RATIO | Quarter | 2
Standard Errors ;  Earnings; Persons; Full Time; Adult; Total earnings ;  Victoria ;  Public sector ; |  |  | Original | A3527826W | 2009-05-15 00:00:00 | 2012-11-15 00:00:00 | 15 | $ | RATIO | Quarter | 2
Standard Errors ;  Earnings; Persons; Total earnings ;  Victoria ;  Public sector ; |  |  | Original | A3527829C | 2009-05-15 00:00:00 | 2012-11-15 00:00:00 | 15 | $ | RATIO | Quarter | 2
© Commonwealth of Australia  2013
Spreadsheet: 857938d1706783976-lookup-help-project-performance-tracker-etaf
Sheet: Project Invoice List

 | Contract #:
 | Contract:
 | Client:
Element | Supplier | PO Number | PO Val (£) | Inv Totals (£) | PO Diff (£) | Invoice 1 | Invoice 2 | Invoice 3 | Invoice 4 | Invoice 5 | Invoice 6 | Invoice 7 | Invoice 8 | Invoice 9 | Invoice 10
Design | No 1 Draughting | 10638 | 1950
Material | SJS Sheeting | 10685 | 30845
Material | Various | N/A |  |  |  | 26485.14
Spreadsheet: 833023d1686737910-transform-discreet-data-set-into-multiple-columns-test-file-1-
Sheet: Sheet1

1 |  | 3 | 6 | 9 | 10 | 13
2 | 2 | 4 | 7 |  | 11 | 14
0 |  | 5 | 8 |  | 12 | 15
3 |  |  |  |  |  | 16
4 |  |  |  |  |  | 17
5 |  |  |  |  |  | 18
0
0
6
7
8
0
9
0
0
0 |  |  |  |  |  | imported data that needs manipulation
10 |  |  |  |  |  | expected output
11
12
0
0
0
0
13
14
15
16
17
18
Spreadsheet: 818997d1677163877-countif-using-multiple-criteria-countif-against-multiple-criteria
Sheet: Sheet1

Order name | Who by | Type |  | Subject | Count of Resources Orders | Product names | Product names | Product names | Product names
Maths KS3 | Mr [NAME] | Resources |  | Primary Extended Curriculum |  | Ext curr |  |  |  | 1 |  | Count conditions | Count in column E against relevant subject in column D when the following conditions are met: column B must say "Resources" and column A must contain one of the products listed against that subject in columns F:I
Maths GCE | [NAME] School - Mrs Thompson | Qualifications |  | Primary Maths |  | Primary Maths |  |  |  | 1
English KS3 |  | Resources |  | Primary English |  | Primary English |  |  |  | 1
History KS3 | London Academy | Resources |  | Secondary Maths |  | Maths KS3 | Maths GCSE | Maths GCE |  | 1
History GCSE | St Lukes | Resources |  | Secondary English |  | English KS3 | English GCSE | English GCE |  | 2
[NAME] |  | Qualifications |  | Secondary Science |  | Science KS3 | Science GCSE | Science GCE |  | 3
Geography GCE |  | Qualifications |  | Secondary MFL |  | MFL KS3 | MFL GCSE | MFL GCE |  | 1
Geography GCE |  | Resources |  | Secondary History |  | History KS3 | History GCSE | History GCE |  | 3
Geography KS3 |  | Resources |  | [NAME] |  | Geography KS3 | Geography GCSE | Geography GCE |  | 2
English GCE | Mr [NAME] | Resources
MFL KS3 |  | Resources
MFL KS3 |  | Qualifications
Science KS3 |  | Resources
Science GCSE |  | Resources
Science KS3 | [NAME] | Qualifications
Science GCSE | [NAME] | Qualifications
Ext curr |  | Resources
Science KS3 | London Free School | Resources
Science GCSE | London Free School | Resources
Science GCSE | Birmingham Academy | Resources
History GCSE | St Lukes | Qualifications
History KS3 | Birmingham Academy | Resources
Primary English |  | Resources
Primary Maths |  | Resources
Spreadsheet: 835325d1688496554-sumifs-with-indirect-references-sumifs-question
Sheet: Sheet1

SUMIFS Question |  |  |  | Choose Column | Color
 |  |  |  | Choose Element | Yellow |  |  |  |  |  |  |  |  |  |  |  |  |  |  | For second Drop Down List
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =UNIQUE(FILTER(INDIRECT("Table2["&'!F1&"]"),)
 |  | Facility | $ | Color | Length | Material |  |  |  | Facility | [NAME]
 |  | 1 | 339 | Blue | 41 | 335 |  |  |  |  | =SUMIFS(Table2[$],Table2[F1],F1,IFNA(INDIRECT("Table2["&F1&"]")=F2,False),)
 |  | 2 | 146 | Yellow | 77 | 154 |  |  |  | 2
 |  | 3 | 200 | Green | 487 | 424 |  |  |  | 3
 |  | 2 | 442 | Yellow | 232 | 255
 |  | 2 | 82 | Blue | 172 | 256
 |  | 3 | 395 | Green | 252 | 461
 |  | 1 | 350 | Yellow | 421 | 477
 |  | 3 | 206 | Blue | 463 | 318
 |  | 2 | 87 | Green | 317 | 204
Spreadsheet: 92029d1291709733-excel-2007-find-duplicates-with-different-formatting-finddups
Sheet: LIST CHANGES DAILY

LIST CHANGES DAILY | A | B | C | D | E
ABBATT JOSHUA TOM | ** | SC | 2011-08-01 00:00:00 | 2017-06-16 00:00:00 | 2012-04-15 00:00:00
[NAME] | ** | ** | 2011-08-01 00:00:00 | 2018-09-13 00:00:00 | 2011-08-11 00:00:00
SADAMS MACK SHAWN | SC | SC | 2011-08-01 00:00:00 | 2016-12-03 00:00:00 | 2012-04-14 00:00:00
ABRHAMS MACKENZIE SAM | ** | SC | 2011-08-01 00:00:00 | 2017-02-25 00:00:00 | 2012-04-20 00:00:00
ALEXANDER MAGGIE N | ** | SC | **2011/08/01 | 2016-05-28 00:00:00 | 2012-05-04 00:00:00
ALEX [NAME] | ** | SC | 2011-08-01 00:00:00 | 2017-07-13 00:00:00 | 2012-06-06 00:00:00
ALFORD NATHANIEL [NAME] | SC | SC | 2011-08-01 00:00:00 | 2017-07-29 00:00:00 | 2012-02-02 00:00:00
ALLEN EAVIAN DIMITRI | ** | ** | 2011-08-01 00:00:00 | 2020-04-04 00:00:00 | 2012-10-03 00:00:00
ALLEN GENEVIEVE MIREILLE | ** | SC | 2011-08-01 00:00:00 | 2017-03-16 00:00:00 | 2012-04-14 00:00:00
[NAME] | SC | SC | 2011-08-01 00:00:00 | 2017-04-14 00:00:00 | 2012-04-12 00:00:00
SNAPPLEBY KEN J | SC | SC | 2011-08-01 00:00:00 | 2013-05-05 00:00:00 | *2010/09/05
CAMBROISE MANUEL J | ** | SC | 2011-08-01 00:00:00 | 2014-06-01 00:00:00 | 2011-08-05 00:00:00
SANDERSON JACK SCOTT | SC | SC | 2011-08-01 00:00:00 | 2016-06-13 00:00:00 | 2012-05-11 00:00:00
ASHANTY SHASE HAILE | SC | SC | 2011-08-01 00:00:00 | 2017-06-05 00:00:00 | 2012-05-11 00:00:00
SANDERSON MITCHELL LATRAK | SC | SC | 2011-08-01 00:00:00 | 2017-01-08 00:00:00 | 2012-04-12 00:00:00
ANDREWS TROY WOODROW | SC | SC | 2011-08-01 00:00:00 | 2018-08-12 00:00:00 | 2011-08-05 00:00:00
APPLEBY [NAME] | SC | SC | 2011-08-01 00:00:00 | 2014-02-21 00:00:00 | 2012-04-18 00:00:00
ARNAD DENNY A | SC | SC | **2010/08/01 | 2016-05-06 00:00:00 | 2012-04-19 00:00:00
[NAME] SAYERS | SC | SC | 2011-08-01 00:00:00 | 2018-05-18 00:00:00 | 2012-05-11 00:00:00
ALEXANDER MAGGIE N | SC | SC | 2011-08-01 00:00:00 | 2020-05-31 00:00:00 | 2011-08-07 00:00:00
[NAME] | SC | SC | 2011-08-01 00:00:00 | 2016-08-27 00:00:00 | 2012-05-11 00:00:00
RAUMBACH SAUL FITZ | SC | SC | **2011/08/01 | 2018-07-21 00:00:00 | 2011-04-29 00:00:00
SASKEW SCOTT DAN | SC | SC | 2011-08-01 00:00:00 | 2014-08-30 00:00:00 | *2010/09/23
FABIN MATT T | ** | SC | 2011-08-01 00:00:00 | 2019-01-21 00:00:00 | 2012-04-14 00:00:00
TACCAIRE NICK ADAM | SC | SC | 2011-08-01 00:00:00 | 2016-06-13 00:00:00 | 2012-05-11 00:00:00
SHAER PHIL RYAN | SC | SC | 2011-08-01 00:00:00 | 2017-06-05 00:00:00 | 2012-05-11 00:00:00
SANKS [NAME] | SC | SC | 2011-08-01 00:00:00 | 2017-01-08 00:00:00 | 2012-04-12 00:00:00
TANKS BRITT NICKY | SC | SC | 2011-08-01 00:00:00 | 2018-08-12 00:00:00 | 2011-08-05 00:00:00
BAPTISTE MARK H | SC | SC | 2011-08-01 00:00:00 | 2014-02-21 00:00:00 | 2012-04-18 00:00:00
Spreadsheet: 88723d1288595013-find-certain-number-then-copy-it-and-4-other-cells-to-other-worksheet-example
Sheet: Sheet1

1 | a | b | c | d | 6 | e | f | g | h | 50 | i | j | k | l | 60 | m | n | o | p
2 | aa | bb | cc | dd | 7 | ee | ff | gg | hh | 51 | ii | jj | kk | ll | 61 | [NAME] | nn | oo | pp
3 | aaa | bbb | [NAME] | ddd | 8 | eee | [NAME] | ggg | hhh | 52 | iii | jjj | kkk | lll | 62 | mmm | nnn | ooo | ppp
4 | aaaa | bbbb | cccc | dddd | 9 | eeee | ffff | gggg | hhhh | 53 | iiii | jjjj | kkkk | llll | 63 | mmmm | nnnn | oooo | pppp
5 | aaaaa | bbbbb | ccccc | ddddd | 10 | eeeee | [NAME] | ggggg | hhhhh | 54 | iiiii | jjjjj | [NAME] | lllll | 64 | [NAME] | nnnnn | [NAME] | ppppp
Spreadsheet: 699099d1602399124-expand-or-reduce-a-table-based-on-the-month-test
Sheet: Sheet1

Jul |  |  |  |  |  | Mar
 |  |  |  |  | Numbers
 |  |  |  |  | Start No. | 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
 |  |  |  |  | 31
Spreadsheet: 63972d1264809785-vlookup-and-sum-call-logs-template-work1
Sheet: Summary

Weekly Summary
Public Que
8am-12pm
 | Calls Answered | Calls Placed | Total Calls - All | Time on Calls Inbound | Time on Calls Outbound | Time on Calls - All | Avg. Call Inbound | Avg. Call Outbound | Avg. Call - All
12pm-5pm
 | Calls Answered | Calls Placed | Total Calls - All | Time on Calls Inbound | Time on Calls Outbound | Time on Calls - All | Avg. Call Inbound | Avg. Call Outbound | Avg. Call - All
Inbound Que
8am-12pm
 | Calls Answered | Calls Placed | Total Calls - All | Time on Calls Inbound | Time on Calls Outbound | Time on Calls - All | Avg. Call Inbound | Avg. Call Outbound | Avg. Call - All
12pm-5pm
 | Calls Answered | Calls Placed | Total Calls - All | Time on Calls Inbound | Time on Calls Outbound | Time on Calls - All | Avg. Call Inbound | Avg. Call Outbound | Avg. Call - All
Agent | Calls Answered | Calls Placed | Total Calls - All | Time on Calls Inbound | Time on Calls Outbound | Time on Calls - All | Avg. Call Inbound | Avg. Call Outbound | Avg. Call - All
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Chase Schuchard
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Kasi Prachyl
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Makenzie Dover
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Spreadsheet: 03dbe0c4-a774-485a-b7a8-661fb6dc16e9
Sheet: 2012 math grade 8

[NAME] |  | Total Number | [NAME]
[NAME] |  |  | Inconclusive | Exploring | Emerging | Developing | Novice | No Score
2010 | All Students | 566 | 12 | 25 | 26 | 21 | 8 | 7
2011 |  | 540 | 14 | 21 | 27 | 23 | 9 | 6
2012 | All Students | 583 | 11 | 24 | 21 | 26 | 11 | 6
 | Black or African American | 45 | 9 | 22 | 22 | 29 | 9 | 9
 | Hispanic or Latino | 186 | 14 | 22 | 26 | 25 | 8 | 4
 | White | 322 | 11 | 24 | 19 | 27 | 11 | 7
 | Minority | 261 | 12 | 23 | 24 | 25 | 10 | 5
 | English Learners | 77 | 6 | 21 | 25 | 31 | 10 | 6
 | Free/Reduced Lunch | 310 | 11 | 20 | 23 | 30 | 11 | 5
 | Female | 223 | 9 | 25 | 25 | 24 | 11 | 6
 | Male | 360 | 13 | 23 | 19 | 28 | 11 | 7
Spreadsheet: c7202c85-4643-42d3-9211-01b3d0dc3954
Sheet: Tilling_performance_score_det

Participant | Performance Points | Timing 1 setsin | Points 1 | Timing 2 powers_of_2 | Points 2 | Timing 3 monster1 | Points 3 | Timing 4 10Kx10K | Points 4 | Timing 5 30Kx26K | Points 5 | Timing 6 40Kx4K | Points 6 | Timing 7 40Kx8K | Points 7 | [NAME]
akki | 73.80952380952381 | 0.014 | 4.761904761904762 | 0.009 | 4.761904761904762 | 0.005 | 7.142857142857143 | 0.267 | 14.28571428571429 | 2.89 | 14.28571428571429 | 0.923 | 14.28571428571429 | 1.614 | 14.28571428571429 | 49
denghui0815 | 61.9047619047619 | 0.003 | 14.28571428571429 | 0.002 | 14.28571428571429 | 0.001 | 14.28571428571429 | 0.565 | 4.761904761904762 | 10.239 | 4.761904761904762 | 2.336 | 4.761904761904762 | 3.662 | 4.761904761904762 | 46
protocolocon | 44.04761904761905 | 0.0169 | 3.571428571428572 | 0.0045 | 7.142857142857143 | 0.00633 | 4.761904761904762 | 0.5287 | 7.142857142857143 | 6.07 | 7.142857142857143 | 2.213 | 7.142857142857143 | 3.59 | 7.142857142857143 | 41
[NAME] | 20.85034013605442 | 0.0452 | 2.380952380952381 | 0.0626 | 2.040816326530612 | 0.0146 | 3.571428571428572 | 1.655 | 2.857142857142857 | 17.715 | 3.571428571428572 | 5.859 | 3.571428571428572 | 10.465 | 2.857142857142857 | 49
[NAME] | 15.13605442176871 | 0.13 | 1.785714285714286 | 0.061 | 2.380952380952381 | 0.114 | 1.785714285714286 | 25.271 | 2.040816326530612 | 714.838 | 2.380952380952381 | 78.112 | 2.380952380952381 | 192.567 | 2.380952380952381 | 49
Minh-Nhut Hong | 8.333333333333334 | 1000 | 0 | 0.009 | 4.761904761904762 | 1000 | 0 | 1000 | 0 | 1000 | 0 | 1000 | 0 | 6.735 | 3.571428571428572 | 49
Valentina Kustikova | 4.444444444444445 | 1000 | 0 | 0.11 | 1.587301587301587 | 0.016 | 2.857142857142857 | 1000 | 0 | 1000 | 0 | 1000 | 0 | 1000 | 0 | 45
oshapovalov | 2.857142857142857 | 1000 | 0 | 0.048 | 2.857142857142857 | 1000 | 0 | 1000 | 0 | 1000 | 0 | 1000 | 0 | 1000 | 0 | 45
Vasiliy | 11.90476190476191 | 1000 | 0 | 0.18 | 1.428571428571429 | 0.03 | 2.380952380952381 | 2.294 | 2.380952380952381 | 26.388 | 2.857142857142857 | 9.048 | 2.857142857142857 | 1000 | 0 | 35
[NAME] | 3.956043956043956 | 0.023 | 2.857142857142857 | 0.822 | 1.098901098901099 | 1000 | 0 | 1000 | 0 | 1000 | 0 | 1000 | 0 | 1000 | 0 | 44
[NAME] | 14.54081632653061 | 0.008 | 7.142857142857143 | 0.067 | 1.785714285714286 | 0.101 | 2.040816326530612 | 0.749 | 3.571428571428572 | 1000 | 0 | 1000 | 0 | 1000 | 0 | 10
nuriyasov | 1.19047619047619 | 1000 | 0 | 0.638 | 1.19047619047619 | 1000 | 0 | 1000 | 0 | 1000 | 0 | 1000 | 0 | 1000 | 0 | 35
[NAME] | 1.587301587301587 | 18.751 | 1.587301587301587 | 1000 | 0 | 1000 | 0 | 1000 | 0 | 1000 | 0 | 1000 | 0 | 1000 | 0 | 21
Val | 0 | 1000 | 0 | 1000 | 0 | 1000 | 0 | 1000 | 0 | 1000 | 0 | 1000 | 0 | 1000 | 0 | 21
iberenger | 3.469387755102041 | 0.05 | 2.040816326530612 | 0.18 | 1.428571428571429 | 1000 | 0 | 1000 | 0 | 1000 | 0 | 1000 | 0 | 1000 | 0 | 3
Spreadsheet: 63653d1264544341-how-to-make-a-booking-planning-report-testbookings2010
Sheet: BookingList

Aprt | [NAME] | [NAME] | Nights
C1A | 2010-04-29 00:00:00 | 2010-05-10 00:00:00 | 11
C1A | 2010-05-15 00:00:00 | 2010-05-18 00:00:00 | 3
C1C | 2010-05-22 00:00:00 | 2010-05-25 00:00:00 | 3
C1D | 2010-05-01 00:00:00 | 2010-05-15 00:00:00 | 14
C1E | 2010-05-13 00:00:00 | 2010-05-15 00:00:00 | 2
C1E | 2010-05-05 00:00:00 | 2010-05-12 00:00:00 | 7
C1A | 2010-05-21 00:00:00 | 2010-05-28 00:00:00 | 7
C1G | 2010-05-01 00:00:00 | 2010-05-15 00:00:00 | 14
C1E | 2010-05-18 00:00:00 | 2010-05-23 00:00:00 | 5
C1C | 2010-05-13 00:00:00 | 2010-05-19 00:00:00 | 6
Spreadsheet: 124686d1318542487-arrays-book1
Sheet: Sheet1

3568
3569
3854
4420
5018
5453
5422
5071
4563
4041
3700
3537
3477
3502
3865
4435
5006
5438
5405
5067
4568
4060
3779
3637
3584
3589
3878
4436
5037
5466
5439
5080
4525
3993
3666
3570
3530
3545
3875
4440
5020
5454
5430
5069
4536
4006
3692
3584
3545
3538
3854
4422
5013
5442
5414
5057
4548
4021
3716
3588
3540
3556
3861
4408
5015
5436
5405
5071
4584
4070
3744
3603
3541
3540
3830
4387
4998
5435
5414
5058
4557
4041
3753
3612
3558
3554
3860
4411
5009
5444
5426
5085
4588
4092
3789
3617
3550
3549
3833
4394
5010
5446
5433
5088
4565
4025
3728
3598
3533
3536
3833
4411
5017
5451
5426
5072
4588
4079
3747
3616
3544
3550
3848
4409
5020
Spreadsheet: 849751d1700148511-sumifs-with-several-criteria-when-i-add-dates-criteria-the-sum-goes-to-0-realsample1
Sheet: Data for Dadj

Row Labels | Count of round
Main | 30078 | Adj
BR | 1 | 9
F | 637 | 10
QF | 2484 | 8
R128 | 3520 | 4
R16 | 4944 | 7
R32 | 9513 | 6
[NAME] | 4629 | 5
RR | 3076 | 1
SF | 1274 | 9
(blank)
Qualies | 9573
Q1 | 5687 | 1
Q2 | 2926 | 2
Q3 | 960 | 3
Grand Total | 39651
Spreadsheet: 865744d1712748583-finance-tracker-help-suggestions-to-track-welcomed-magaletta-personal-finance-tracker-test
Sheet: Data Validation

Type List | Category List
Credit | Income
Debit | Reimbursement
 | Present
 | Misc
 | Food
 | Shopping (Grocery)
 | Shopping (Recreational)
 | Shopping ([NAME])
 | Transport
 | Business
 | Partner
 | Entertainment
 | Entertainment (Subscriptions)
 | Savings
 | Travel
 | Medical
 | Living Expenses (Misc)
 | Living Expenses (Board)
 | [NAME] (Gifts)
 | Misc (Reimbursement)
 | Misc (Other)
Spreadsheet: 673237d1587276122-how-to-display-the-latest-20-dates-from-a-data-sheet-golf-handicap-index-calculation-txt007_20200419
Sheet: Lastest20scores

Player
A |  |  |  |  |  | B |  |  |  |  |  | C |  |  |  |  |  | D
 | Average of differential |  |  |  |  |  | Average of differential |  |  |  |  |  | Average of differential |  |  |  |  |  | Average of differential
 | Handicap Index |  |  |  |  |  | Handicap Index |  |  |  |  |  | Handicap Index |  |  |  |  |  | Handicap Index
Date | Course | Score | Rating | Slope | Differential | Date | Course | Score | Rating | Slope | Differential | Date | Course | Score | Rating | Slope | Differential | Date | Course | Score | Rating | Slope | Differential
How to get the latest 20 games based on the date?
Spreadsheet: 826663d1682145463-hardcode-text-to-spilled-array-spilled-range
Sheet: autospill

 | id | date | type | qty | unit | unit price |  |  | total price
 | Al-100 | 2023-04-17 00:00:00 | quote | 0.03 | [NAME] | 1165
 | Al-100 | 2023-04-17 00:00:00 | quote | 1 | [NAME] | 922 |  |  |  |  | 922
 | [NAME] | 2023-04-17 00:00:00 | quote | 0.03 | [NAME] | 1100 |  |  |  |  | 33
 | [NAME] | 2023-04-17 00:00:00 | quote | 0.5 | [NAME] | 1100 |  |  |  |  | 550
 | [NAME] | 2023-04-17 00:00:00 | quote | 1 | [NAME] | 865 |  |  |  |  | 865
 | Al-102 | 2023-04-17 00:00:00 | quote | 0.03 | [NAME] | 1000 |  |  |  |  | 30
 | Al-102 | 2023-04-17 00:00:00 | quote | 1 | [NAME] | 830 |  |  |  |  | 830
 | Al-103 | 2023-04-17 00:00:00 | quote | 0.03 | [NAME] | 940 |  |  |  |  | 28.2
 | Al-103 | 2023-04-17 00:00:00 | quote | 1 | [NAME] | 780 |  |  |  |  | 780
 | Al-104 | 2023-04-17 00:00:00 | quote | 1 | [NAME] | 46 |  |  |  |  | 46
 | Al-105 | 2023-04-17 00:00:00 | quote | 25 | [NAME] | 33 |  |  |  |  | 825
 | [NAME] | 2023-04-17 00:00:00 | quote | 25 | [NAME] | 29 |  |  |  |  | 725
 |  |  |  |  |  | 0
Spreadsheet: 802220d1666707449-calculate-numbers-backwards-from-total-sum-value-positions
Sheet: Sheet2

Position | Quantity | Price | Total Sum |  |  | Final Price |  |  |  | > Price | >P:  Total Sum
Position 25 | 3825 | 0.083 |  |  |  | ?
Position 26 | 4162 | 0.083 |  |  |  | ?
Position 24 | 4367 | 0.083 |  |  |  | ?
Position 23 | 4413 | 0.083 |  |  |  | ?
Position 21 | 3807 | 0.133 |  |  |  | ?
Position 20 | 3969 | 0.133 |  |  |  | ?
Position 19 | 4095 | 0.133 |  |  |  | ?
Position 22 | 4636 | 0.133 |  |  |  | ?
Position 27 | 3528 | 0.163 |  |  |  | ?
Position 28 | 4438 | 0.163 |  |  |  | ?
Position 41 | 3504 | 0.229 |  |  |  | ?
Position 40 | 3738 | 0.229 |  |  |  | ?
Position 31 | 3943 | 0.351 |  |  |  | ?
Position 29 | 4169 | 0.351 |  |  |  | ?
Position 30 | 4842 | 0.351 |  |  |  | ?
Position 32 | 4925 | 0.351 |  |  |  | ?
Position 34 | 3941 | 0.429 |  |  |  | ?
Position 33 | 4816 | 0.429 |  |  |  | ?
Position 37 | 4256 | 0.534 |  |  |  | ?
Position 35 | 4485 | 0.534 |  |  |  | ?
Position 36 | 4718 | 0.534 |  |  |  | ?
Position 39 | 4393 | 0.656 |  |  |  | ?
Position 38 | 4527 | 0.656 |  |  |  | ?
Position 9 | 5 | 3.02 |  |  |  | ?
Position 7 | 6 | 3.02 |  |  |  | ?
Position 5 | 10 | 3.02 |  |  |  | ?
Position 15 | 10 | 3.02 |  |  |  | ?
Position 1 | 13 | 3.02 |  |  |  | ?
Position 3 | 14 | 3.02 |  |  |  | ?
Position 11 | 16 | 3.02 |  |  |  | ?
Position 13 | 20 | 3.02 |  |  |  | ?
Position 8 | 5 | 3.039 |  |  |  | ?
Position 12 | 8 | 3.039 |  |  |  | ?
Position 6 | 18 | 3.039 |  |  |  | ?
Position 10 | 19 | 3.039 |  |  |  | ?
Position 14 | 20 | 3.039 |  |  |  | ?
Position 2 | 22 | 3.039 |  |  |  | ?
Position 4 | 23 | 3.039 |  |  |  | ?
Position 16 | 25 | 3.039 |  |  |  | ?
Position 17 | 37 | 3.63 |  |  |  | ?
Position 18 | 37 | 3.63 |  |  |  | ? |  |  |  |  |  |  | Difference
 |  |  |  |  |  | 30642.19
 |  |  | Initial Grand total sum |  |  | Final Grand total sum
Spreadsheet: 107010d1304162144-how-to-find-top-25-values-from-more-than-1000-rows-with-their-corresponding-names-excel-test-top-5
Sheet: Sheet3

 | Name | Amount
2 | Alpha | 100 |  |  |  | Foxtrot | 120
3 | Bravo | 90 |  |  |  | Alpha | 100
13 | [NAME] | 20 |  |  |  | Bravo | 90
4 | Delta | 80 |  |  |  | Delta | 80
6 | Echo | 70 |  |  |  | [NAME] | 80
1 | Foxtrot | 120 |  |  |  | Echo | 70
 | Golf |  |  |  |  | Sierra | 61
5 | [NAME] | 80 |  |  |  | India | 50
8 | India | 50 |  |  |  | Romeo | 47
11 | [NAME] | 40 |  |  |  | Tango | 45
12 | Kilo | 30 |  |  |  | [NAME] | 40
14 | Lima | 20 |  |  |  | Kilo | 30
15 | [NAME] | 10 |  |  |  | [NAME] | 20
 | Novembe |  |  |  |  | Lima | 20
 | [NAME] |  |  |  |  | [NAME] | 10
 | Papa |  |  |  |  | #N/A | #N/A
 | Quebec |  |  |  |  | #N/A | #N/A
9 | Romeo | 47 |  |  |  | #N/A | #N/A
7 | Sierra | 61 |  |  |  | #N/A | #N/A
10 | Tango | 45 |  |  |  | #N/A | #N/A