tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: darrell_schoolcraft__7322__imball0202
Sheet: EOG

 | 500249 |  | 500260 |  | 500646 |  | 500598
 | Pronghorn |  | Pitchfork Ranch |  | Tristi Draw |  | EOG/TW Eddy
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 8109 | 7700 | 7524 | 8000 |  | 3500 | 5621 | 3500
2 | 7487 | 7700 | 8454 | 8000 |  |  | 5644 | 7000
3 | 7329 | 7700 | 8774 | 8000 |  |  | 5629 | 7000
4 | 7232 | 7700 | 8619 | 8000 |  |  | 6650 | 7000
5 | 7130 | 7700 | 8498 | 8000 | 1 |  | 6285 | 7000
6 | 8341 | 7700 | 8747 | 8000 |  |  | 5673 | 7000
7 | 9046 | 7700 | 5199 | 8000 |  |  | 1107
8 | 8490 | 7700 | 4470 | 8000
9 | 7931 | 7700 | 8850 | 8000
10 | 7777 | 7700 | 8458 | 8000
11 | 7673 | 7700 | 8800 | 8000 |  |  | 265
12 | 7457 | 7700 | 9083 | 8000 |  |  | 913
13 | 7123 | 7700 | 8979 | 8000
14 | 12291 | 7700 | 9160 | 8000 |  |  | 1482
15 | 11610 | 8000 | 9275 | 8700 |  |  | 23
16 | 13054 | 11000 | 9247 | 8700
17 | 10833 | 11000 | 9133 | 8700 |  |  | 101
18 | 12772 | 11000 | 9577 | 8700 |  |  | 499
19
20
21
22
23
24
25
26
27
28
29
30
31
2002-01-31 00:00:00 |  |  |  |  |  |  |  |  | 18846.61
2002-02-18 00:00:00
CBS Volume
 |  |  | -118658
Spreadsheet: 690781d1597296097-date-match-demo
Sheet: Data

Sl no | Date | Price
1 | 2020-08-01 00:00:00 | 150
2 | 2020-07-02 00:00:00 | 300
3 | 2020-08-03 00:00:00 | 450
4 | 2020-08-04 00:00:00 | 720
5 | 2020-08-05 00:00:00 | 810
6 | 2020-08-06 00:00:00 | 680
7 | 2020-08-07 00:00:00 | 725
8 | 2020-08-08 00:00:00 | 325
9 | 2020-08-09 00:00:00 | 985
Spreadsheet: 761647d1641134068-index-match-not-always-returning-data-time-clock-data
Sheet: Clock Sort

Date | Employee | In | Lunch out | Lunch in | out | FSM | M Gap | LSM | E Gap
11/29/2021 | Hickman, Reginald
11/30/2021 | Hickman, Reginald
12/1/2021 | Hickman, Reginald
12/2/2021 | Hickman, Reginald
12/3/2021 | Hickman, Reginald
12/4/2021 | Hickman, Reginald
12/5/2021 | Hickman, Reginald
12/6/2021 | Hickman, Reginald
12/7/2021 | Hickman, Reginald
12/8/2021 | Hickman, Reginald
12/9/2021 | Hickman, Reginald
12/10/2021 | Hickman, Reginald
12/11/2021 | Hickman, Reginald
12/12/2021 | Hickman, Reginald
12/13/2021 | Hickman, Reginald
12/14/2021 | Hickman, Reginald
12/15/2021 | Hickman, Reginald
12/16/2021 | Hickman, Reginald
12/17/2021 | Hickman, Reginald
12/18/2021 | Hickman, Reginald
12/19/2021 | Hickman, Reginald
12/20/2021 | Hickman, Reginald
12/21/2021 | Hickman, Reginald
12/22/2021 | Hickman, Reginald
12/23/2021 | Hickman, Reginald
12/24/2021 | Hickman, Reginald
12/25/2021 | Hickman, Reginald
12/26/2021 | Hickman, Reginald
12/27/2021 | Hickman, Reginald
12/28/2021 | Hickman, Reginald
12/29/2021 | Hickman, Reginald
12/30/2021 | Hickman, Reginald
12/31/2021 | Hickman, Reginald
1/1/2022 | Hickman, Reginald
1/2/2022 | Hickman, Reginald
Spreadsheet: 04dd54c1-e57a-49b5-9c15-eba867b4cdf7
Sheet: Sheet1

Undergraduate Majors | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
Adult Education (Includes Aboriginal Adult Education)
Study Year | Major | 1999-00 | 2000-01 | 2002-03 | 2003-04 | 2004-05 | 2005-06 | 2006-07 | 2007-08 | 2008-09
 | Single | 18 | 38 | 115 | 117 | 142 | 129 | 110 | 126 | 94
 | Combined | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Year I | Sub-Total: | 18 | 38 | 115 | 117 | 142 | 129 | 110 | 126 | 94
 | Gen/Integ Studies | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Total: | 18 | 38 | 115 | 117 | 142 | 129 | 110 | 126 | 94
 | Single | 20 | 50 | 105 | 127 | 114 | 112 | 122 | 109 | 97
 | Combined | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Year II | Sub-Total: | 20 | 50 | 105 | 127 | 114 | 112 | 122 | 109 | 97
 | Gen/Integ Studies | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Total: | 20 | 50 | 105 | 127 | 114 | 112 | 122 | 109 | 97
 | Single | 85 | 102 | 257 | 302 | 301 | 243 | 254 | 226 | 260
 | Combined | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Year III | Sub-Total: | 85 | 102 | 257 | 302 | 301 | 243 | 254 | 226 | 260
 | Gen/Integ Studies | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Total: | 85 | 102 | 257 | 302 | 301 | 243 | 254 | 226 | 260
 | Single | 0 | 2 | 6 | 5 | 1 | 1 | 0 | 1 | 0
 | Combined | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Year IV | Sub-Total: | 0 | 2 | 6 | 5 | 1 | 1 | 0 | 1 | 0
 | Gen/Integ Studies | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
 | Total: | 0 | 2 | 6 | 5 | 1 | 1 | 0 | 1 | 1
 | Single | 123 | 192 | 483 | 551 | 558 | 485 | 486 | 462 | 451
 | Combined | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TOTAL: | Sub-Total: | 123 | 192 | 483 | 551 | 558 | 485 | 486 | 462 | 451
 | Gen/Integ Studies | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
 | Total: | 123 | 192 | 483 | 551 | 558 | 485 | 486 | 462 | 452
Male |  | 43 | 65 | 130 | 163 | 179 | 143 | 134 | 128 | 116
Female |  | 80 | 127 | 353 | 388 | 379 | 342 | 352 | 334 | 336
Full-Time |  | 11 | 12 | 19 | 27 | 32 | 30 | 26 | 19 | 12
Part-Time |  | 112 | 180 | 464 | 524 | 526 | 455 | 460 | 443 | 440
Codes: | ADAB, ADAC, ADEC, ADED, ADGN, ADSB, ENPC.
Spreadsheet: 760170d1640028141-vlookup-for-a-formula-result-test-bracket-1-
Sheet: Bracket

 | Round 10 | Round 9 | Round 7 | Round 6 | Round 4 | Round 2 | Round 1 | Round 3 | Round 5 | Round 8 | Round 11
 |  |  |  |  |  |  | Game 1
 |  |  |  |  |  | Game 9 |  | Game 13
 |  |  |  |  | Game 17 |  | Game 2
 |  |  |  |  |  |  |  |  | Game 21
 |  |  |  |  | Loser of 16
 |  |  |  | Game 23 |  |  | Game 3
 |  |  |  |  |  | Game 10 |  | Game 14
 |  |  | Game 25 |  | Game 18 |  | Game 4
 |  |  |  |  |  |  |  |  |  | Game 27
 |  |  |  |  | Loser of 15
 |  |  |  |  |  |  | Game 5
 |  |  | Loser of 22 |  |  | Game 11 |  | Game 15
 |  | Game 29 |  |  | Game 19 |  | Game 6
 |  |  |  |  |  |  |  |  | Game 22 |  |  | Tournament Winner
 |  |  |  |  | Loser of 14
 |  |  |  | Game 24 |  |  | Game 7
 | Game 57 |  |  |  |  | Game 12 |  | Game 16
Winner of [NAME] |  |  |  |  |  |  |  |  |  |  | Winner of Losers bracket
 |  |  | Game 26 |  | Game 20 |  | Game 8
 |  |  |  |  | Loser of 15
 |  |  | Loser of 21
 | Loser of 27
Spreadsheet: 66293d1266977528-round-numbers-round
Sheet: Sheet1

Amount |  | % |  | round |  | Amount | % |  | round
29.78 |  | 76 | 22.6328 | 22.63 |  | 25.34 | 76 | 19.2584 | 19.26
 |  | 4 | 1.1912 | 1.19 |  |  | 4 | 1.0136 | 1.01
 |  | 13 | 3.8714 | 3.87 |  |  | 13 | 3.2942 | 3.29
 |  | 1 | 0.2978 | 0.3 |  |  | 1 | 0.2534 | 0.25
 |  | 1 | 0.2978 | 0.3 |  |  | 1 | 0.2534 | 0.25
 |  | 5 | 1.489 | 1.49 |  |  | 5 | 1.267 | 1.27
 |  | 100 |  | 29.78 |  |  | 100 |  | 25.33
The amount of 29.78 can be broken down into individual sub correctly whereas 25.33 cannot be broken down correctly.
Spreadsheet: 856842d1706018618-set-minimum-height-of-specific-rows-machine-status-report
Sheet: Machine Status

 |  | Now - |  |  |  |  |  |  |  |  |  |  |  |  |  |  | To refresh the "Now" time, press the F9 key
 |  | Machine | Washer 1 | Washer 2 | Washer 3 | Washer 4 | Washer 5 | Washer 6 | Washer 7 | Washer 8 | Washer 9 |  |  | Working | In Service | [NAME]
 |  | Status | OOS | Working | Working | Working | Working | Working | Working | Working | Working |  |  | OOS | Weekly | Waquas
 |  | [NAME] | Weekly | In Service | In Service | In Service | In Service | Quarterly | In Service | In Service | In Service |  |  |  | Monthly | [NAME]
 |  | Comments | [NAME] hr hr ewfheu oewhb uewg hb ewhg weuihw we f ewoifh |  |  |  |  |  |  |  |  |  |  |  | Quarterly | [NAME] | This row will automatically resize once you have finished typing your comments
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Annual | Caroline
 |  | Machine | Autoclave 1 | Autoclave 2 | Autoclave 3 | Autoclave 4 | Autoclave 5 | [NAME] | [NAME] | Ultrasonic LHS | Ultrasonic RHS |  |  |  | Awaiting Parts | [NAME]
 |  | Status | Working | Working | Working | OOS | Working | OOS | Working | Working | Working |  |  |  | Repair | [NAME]
 |  | [NAME] | In Service | Weekly | In Service | In Service | In Service | Annual | In Service | In Service | In Service |  |  |  | Extra Process | [NAME]
 |  | Comments |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | This row will automatically resize once you have finished typing your comments
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  | Date | Time |  |  |  |  |  |  |  |  |  |  | Rajesh
 |  | Form Last Updated At: |  | 2024-01-18 00:00:00 | 05:34:00 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  | By: |  | Waquas |  |  |  |  |  |  |  |  |  |  |  | Bev
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A.N.Other
Spreadsheet: 728640d1618555323-multiple-criteria-lookup-test-multiple-lookup
Sheet: Result

 |  |  |  |  |  | Apple | Mango | [NAME] | Apple | Mango | [NAME]
 |  |  |  |  |  | Shrawan |  |  | Bhadra
Purchase
Spreadsheet: 92251d1291873599-automatically-adjusting-a-formula-for-new-data-dashboard12810
Sheet: Pivot Table of Backlog

Row Labels | Count of CALLID
Equipment Loan | 36
GroupWise | 5
HeatService | 1
HW Install | 2
HW Issues | 1
InfoDesk | 1
Internet_Other | 2
LanAdmin Access | 1
[NAME] | 4
M1 Support | 3
Network Issues | 6
Network Task | 24
PC Setup | 30
Primavera | 1
Printing | 1
Project | 17
Security Issues | 2
Security Notice | 13
Security RSA Tokens | 1
SW Install | 2
SW Issues | 22
Technology Enhancement | 2
Telephone | 24
Telephone Down | 3
VTC | 1
Wireless Device | 20
Grand Total | 225
Spreadsheet: 24831224-627d-466d-8f42-16ced77f8298
Sheet: Free (U15-U18 Boys) - Dec 1

SATURDAY, Dec 1st, SCHEDULE
Home Club: | Loudoun |  | Locations: | Loudoun Soccer Park Field #1
[NAME]: | Freestate |  | Field Directions:
Loudoun Soccer wears Red shirts, Black shorts, Red socks |  |  | http://www.loudounsoccer.com/Default.aspx?tabid=193688
 | Loudoun Soccer Park Field #1
U15/16 (40 mins x2) + U17/U18 (45 mins x2)
 | Time | Teams
 | 9am | U15B
 | 11am | U16B
 | 1pm | U17B
 | 3pm | U18B
Spreadsheet: 800c49ed-edec-4546-9bb8-e3d563c71e92
Sheet: Sheet1

Unnamed: 0 | SVG Coater and [NAME] Use Only | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 | Week of May. 17 - May. 23, 2009
 |  | 1um | 1.6um | 7um | 1um | 1.6um | 3um | 1um | 1.6um | 3um
SVG                         Coater | Date (Coat) | 2009-05-18 00:00:00 | 2009-05-18 00:00:00 | 2009-05-18 00:00:00 | 2009-05-18 00:00:00 | 2009-05-18 00:00:00 | 2009-05-18 00:00:00
 | Track | 1 | 1 | 1 | 2 | 2 | 2
 | Prime Program | Yes Oven | Yes Oven | Yes Oven | Yes Oven | Yes Oven | Yes Oven
 | Coat Program | 7 | 8 | 4 | 7 | 8 | 4
 | Oven Program | 1 | 2 | 3 | 1 | 2 | 3
 | Problems
Thickness Measurements                                (NanoSpec) | Date (Measurement) | 2009-05-18 00:00:00 | 2009-05-18 00:00:00 | 2009-05-18 00:00:00 | 2009-05-18 00:00:00 | 2009-05-18 00:00:00 | 2009-05-18 00:00:00 | - | - | -
 | Top (A) | 10297 | 17196 | 72603 | 10294 | 17152 | 30184 | - | - | -
 | Center (A) | 10270 | 17173 | 72456 | 10264 | 17121 | 30123 | - | - | -
 | Flat (A) | 10279 | 17167 | 72356 | 10279 | 17121 | 30122 | - | - | -
 | Left  (A) | 10296 | 17145 | 72442 | 10293 | 17125 | 30145 | - | - | -
 | Right (A) | 10314 | 17168 | 72450 | 10313 | 17148 | 30144 | - | - | -
 | Average (A) | 10291 | 17170 | 72461 | 10289 | 17133 | 30144 | - | - | -
 | [NAME]  (A) | 17 | 18 | 89 | 18 | 15 | 25 | - | - | -
 | Comments
Exposure | Date (Exposure) | 2009-05-19 00:00:00 | 2009-05-19 00:00:00 | 2009-05-19 00:00:00 | 2009-05-19 00:00:00 | 2009-05-19 00:00:00 | 2009-05-19 00:00:00
 | Tool | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | EValign | EValign | EValign
 | Contact Type | Vac. | Vac. | Vac. | Vac. | Vac. | Vac.
 | Exposure Time | 1.1s | 1.3s | 3.0s x2 | 1.0s | 1.3s | 2.8s
 | Problems
SVG                            Developer | Date (Develop) | 2009-05-20 00:00:00 | 2009-05-20 00:00:00 | 2009-05-20 00:00:00 | 2009-05-20 00:00:00 | 2009-05-20 00:00:00 | 2009-05-20 00:00:00
 | Track | 1 | 1 | 1 | 2 | 2 | 2
 | Pre-bake Program | 1 | 2 | none | 1 | 2 | none
 | Develop Program | 3 | 4 | 6 | 3 | 4 | 7
 | Post-base Program | 1 | 2 | none | 1 | 2 | none
 | Problems
Resolution                         Measurements | Date (Measurement) | 2009-05-20 00:00:00 | 2009-05-20 00:00:00 | 2009-05-20 00:00:00 | 2009-05-20 00:00:00 | 2009-05-20 00:00:00 | 2009-05-20 00:00:00
 | Top (H/V) (um) | 1.5/1.5 | 1.5/1.5 | 2.5/2.5 | 1.5/1.5 | 2/2 | 2.5/2.5
 | Center (H/V) (um) | 1/1.5 | 1.5/1.5 | 2.5/2.5 | 1/1.5 | 1.5/2 | 2.5/2.5
 | Flat (H/V) (um) | 1.5/1.5 | 1.5/1.5 | 2.5/2.5 | 1/2 | 1.5/1.5 | 2.5/2.5
 | Left (H/V) (um) | 1/1.5 | 1/1.5 | 2.5/2.5 | 1.5/1.5 | 2/2 | 2.5/2.5
 | Right (H/V) (um) | 1/1.5 | 1.5/1.5 | 3/2.5 | 2/1.5 | 1/1.5 | 3/2.5
 | Comments |  |  |  |  |  | slightly overexposed
Spreadsheet: 688869d1595988776-help-sorting-apartments-go-advanced
Sheet: Sheet1

 | Apt # | BDRMS
 | 2A | 2
 | 2B | 1
 | 2C | 3
 | 2D | 2
 | 2E | 2
 | 2F | 2
 | 2G | 2
 | 2H | 1
 | 2I | 3
 | 2J | 2
 | 2K | 2
 | 2L | 2
 | 3A | 2
 | 3B | 1
 | 3C | 3
 | 3D | 2
 | 3E | 2
 | 3F | 2
 | 3G | 2
 | 3H | 1
 | 3I | 3
 | 3J | 2
 | 3K | 2
 | 3L | 2
Spreadsheet: 119707d1314677513-mid-extracting-each-number-their-respective-category-midsolved
Sheet: Sheet1

There are 12 series of numbers, separated by comma, in one cell.  The goal is to distribute values tagged as 1 in their respective categories. (See Columns D to N).
 |  |  | 1 | 3 | 5 | 7
 |  |  | Category
Case | Raw Data |  | Peach | Blue | Green | Red | Yellow | Maroon | Black | Gray | White | Orange | Pink
A103 | 0,1,0,0,1,0,0,0,0,0,0,1 |  | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
A104 | 1,1,1,0,0,1,0,1,1,0,1,0 |  | 1 | 1 | 1 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 1
A105 | 0,0,1,0,0,0,0,0,0,0,0,1 |  | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
A106 | 0,1,1,0,1,0,1,0,0,0,1,1 |  | 0 | 1 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 1
A107 | 0,0,0,1,0,0,0,0,0,0,0,1 |  | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
A108 | 0,0,0,0,0,0,0,0,0,1,0,0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0
A109 | 0,1,0,1,0,0,0,0,0,1,0,0 |  | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0
A110 | 1,1,1,0,0,0,0,0,0,1,1,1 |  | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1
A111 | 0,1,0,0,1,0,0,0,0,0,0,0 |  | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
A112 | 1,1,1,0,0,0,0,0,0,0,0,0 |  | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
A113 | 0,0,1,1,0,0,1,0,0,0,0,0 |  | 0 | 0 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0
A114 | 0,0,0,0,0,1,0,1,0,0,0,0 |  | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0
A115 | 0,1,0,0,1,0,0,0,0,0,0,0 |  | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
A116 | 1,1,0,1,0,1,1,0,0,0,0,1 |  | 1 | 1 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0
A117 | 0,1,0,0,0,1,0,1,0,0,0,0 |  | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0
A118 | 0,0,1,0,0,0,0,0,0,0,0,0 |  | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
A119 | 0,0,0,0,1,1,0,0,1,0,0,0 |  | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 1 | 0 | 0
A120 | 1,1,1,1,1,0,0,0,0,0,0,1 |  | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0
A121 | 0,1,1,0,1,0,1,0,0,0,1,0 |  | 0 | 1 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 1
A122 | 0,0,1,0,1,0,0,0,0,0,1,0 |  | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1
A123 | 0,0,1,1,0,0,1,0,0,0,0,0 |  | 0 | 0 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0
A124 | 0,0,0,0,0,0,0,0,0,0,0,0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
A125 | 1,0,1,0,0,0,0,0,0,0,0,0 |  | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
A126 | 0,1,0,0,0,0,0,0,0,0,0,0 |  | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
A127 | 0,0,0,0,0,0,0,0,0,0,0,1 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
A128 | 0,0,0,0,1,1,0,0,0,0,0,1 |  | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0
A129 | 0,0,0,0,0,0,0,0,1,0,0,0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0
A130 | 0,0,0,0,0,0,0,0,1,0,0,0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0
A131 | 0,1,1,1,0,0,1,0,0,0,1,0 |  | 0 | 1 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 1
A132 | 0,0,0,0,0,0,0,0,0,0,0,1 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 494851d1482816093-pull-id-and-school-name-from-sheet2-from-multi-columns-book1
Sheet: Sheet1

Name | ID | School
Garret | 39379 | AGRIGAON
Cameron | 46050 | ARITAR
Parker | 96422 | BADONG
Thaddeus | 22221 | BENGTHANGSING
Archie | 22443 | BHUSUK
Wilbert | 78945 | BIRASPATI
Spreadsheet: 876978d1723680016-calculating-sum-based-on-value-of-another-column-and-date-sample-sheet-for-calc
Sheet: Table1

Month Name | Year | Total
May | 2017 | 43345
June | 2017 | 19387
July | 2017 | 6215
August | 2017 | 15506
January | 2018 | 6750
February | 2018 | 22908
March | 2018 | 14535
April | 2018 | 16349
June | 2018 | 9261
July | 2018 | 18126
August | 2018 | 42800
September | 2018 | 86732.05
October | 2018 | 130549
November | 2018 | 16631
December | 2018 | 6594
March | 2019 | 35482
April | 2019 | 68324
May | 2019 | 6100
June | 2019 | 68842
August | 2019 | 36190
September | 2019 | 34339
October | 2019 | 20548
December | 2019 | 6590
January | 2020 | 7800
March | 2020 | 46094
April | 2020
May | 2020 | 11725
August | 2020 | 51395
September | 2020 | 21025
October | 2020 | 5925
December | 2020 | 64250
January | 2021 | 24447
February | 2021 | 12065
March | 2021 | 39195
April | 2021 | 40350
May | 2021 | 6600
June | 2021 | 6100
July | 2021 | 43456
August | 2021 | 13500
September | 2021 | 80033
November | 2021 | 60761
December | 2021 | 155020
January | 2022 | 7800
February | 2022 | 20375
March | 2022 | 82530
April | 2022 | 31375
May | 2022 | 21000
June | 2022 | 365166
July | 2022 | 6300
August | 2022 | 6600
September | 2022 | 6600
October | 2022 | 46735
November | 2022 | 58300
December | 2022 | 71578
January | 2023 | 72200
February | 2023 | 240350
March | 2023 | 303500
May | 2023 | 74730
June | 2023 | 98566
July | 2023 | 91860
August | 2023 | 60655
September | 2023 | 41735
October | 2023 | 19808
November | 2023 | 35862
January | 2024 | 199451
February | 2024 | 82717
March | 2024 | 14580
Spreadsheet: 730035d1619512048-find-record-on-2-criteria-with-nearest-lowest-date-27042021-sample-file-for-excel-forum
Sheet: Sheet1

Fees Slabs | Charges | Date
500000 | 2500 | 2018-09-24 00:00:00 |  |  | Question 1 :
1000000 | 3000 | 2018-09-24 00:00:00
2500000 | 5000 | 2018-09-24 00:00:00 |  |  | Current Date | 2021-03-30 00:00:00 | << [NAME] |  | Nearest lowest date of the current date is 05/07/2020
5000000 | 7500 | 2018-09-24 00:00:00 |  |  | Fees | 3500000 | << [NAME]
100000000 | 9000 | 2018-09-24 00:00:00 |  |  | Charges | 5400 | <<<<< RESULT |  | Charges on fees slabs above 10.00 lakh but minimum 25.00 lakh
0 | 0 | 2020-07-05 00:00:00
500000 | 3100 | 2020-07-05 00:00:00 |  |  | I want Charges amount by seeking nearest lowest date record & fees amount must be between the range
1000000 | 3500 | 2020-07-05 00:00:00
2500000 | 5400 | 2020-07-05 00:00:00
5000000 | 7900 | 2020-07-05 00:00:00
100000000 | 11000 | 2020-07-05 00:00:00
0 | 0 | 2021-04-04 00:00:00
500000 | 3500 | 2021-04-04 00:00:00
1000000 | 4000 | 2021-04-04 00:00:00
2500000 | 6000 | 2021-04-04 00:00:00
5000000 | 8000 | 2021-04-04 00:00:00
100000000 | 15000 | 2021-04-04 00:00:00
Service Charges Amt. | Service Chg % | Sanction limit | Date |  | Question 2 :
0 | 0.01 | 0 | 2018-09-24 00:00:00
0 | 0.01 | 2500000 | 2018-09-24 00:00:00 |  | Current Date | 2021-03-30 00:00:00 | << [NAME] |  | Nearest lowest date of the current date is 05/07/2020
25000 | 0.005 | 5000000 | 2018-09-24 00:00:00 |  | Fees | 11127000 | << [NAME]
37500 | 0.0025 | 10000000 | 2018-09-24 00:00:00 |  | Service Charges Amt |  | <<<<< RESULT |  | Service Charges on slabs above 1.00 crore
50000 | 0.002 | 1000000000 | 2018-09-24 00:00:00 |  |  |  | + |  | <<< how i can add this amount in summation
0 | 0.01 | 0 | 2020-07-05 00:00:00 |  | For 25.00 lakh
0 | 0.01 | 2500000 | 2020-07-05 00:00:00 |  | Upto 50.00 lakh |  | =(C25-C24)*B25+G25
25000 | 0.005 | 5000000 | 2020-07-05 00:00:00 |  | upto 1.00 Crore |  | =(C26-C25)*B26+G26
37500 | 0.0025 | 10000000 | 2020-07-05 00:00:00 |  | above 1.00 Crore |  | =(C27-C26)*B27+G27
50000 | 0.002 | 1000000000 | 2020-07-05 00:00:00
0 | 0.03 | 0 | 2021-04-04 00:00:00 |  | I want Service Charges amount by seeking nearest lowest date record & sanction limit amount must be between the date range * Servic charges %
0 | 0.03 | 2500000 | 2021-04-04 00:00:00
25000 | 0.02 | 5000000 | 2021-04-04 00:00:00
37500 | 0.01 | 10000000 | 2021-04-04 00:00:00
50000 | 0.005 | 1000000000 | 2021-04-04 00:00:00
Spreadsheet: mark_guzman__24565__EPE_JAN_2001
Sheet: JANUARY (1)

To: El Paso Marketing   -  fax # [PHONE] |  | 01/01/01
El Paso Generation   -  fax # [PHONE]
HR ENDING | HR ENDING | Palo Verde | Palo Verde | Palo Verde | Palo Verde | 4 CORNERS | EDDY
Pacific | Mountain | SALE | SALE | SALE | SALE | SALE | BUY
Standard | Standard | TO ENRON | TO ENRON | TO ENRON | TO ENRON | TO ENRON | From ENRON
Time | Time | 85 | 82.5 | 82.5 | 90
 |  | CARRY OVER FROM 12/31 | CARRY OVER FROM 12/31 | CARRY OVER FROM 12/31 | FOR THE DAY | FOR THE DAY | FOR THE DAY
 |  | 12/30/00-12/30/00 | 12/30/00-12/30/00 | 12/30/00-12/30/00 | 01/0/01-01/01/01 | 01/0/01-01/01/01 | 01/01/00-01/01/00
 |  | TAG# 13668 | TAG# 13668 | PAC TAG | WESCO TAG | PSCO TAG # 22447 | PSCO TAG #22425 | TOTAL
PST | MST | Deal #485864 | Deal #486213 | Deal #486213 | Deal# 486942 | DIRECT BILL!!!!! | DIRECT BILL!!!!!
2400 | 0100 | 50 | 15 | 10 | 0 | 103 | -103
0100 | 0200 | 0 | 0 | 0 | 25 | 103 | -103
0200 | 0300 | 0 | 0 | 0 | 25 | 103 | -103
0300 | 0400 | 0 | 0 | 0 | 25 | 103 | -103
0400 | 0500 | 0 | 0 | 0 | 25 | 103 | -103
0500 | 0600 | 0 | 0 | 0 | 25 | 103 | -103
0600 | 0700 | 0 | 0 | 0 | 25 | 103 | -103
0700 | 0800 | 0 | 0 | 0 | 25 | 103 | -103
0800 | 0900 | 0 | 0 | 0 | 25 | 103 | -103
0900 | 1000 | 0 | 0 | 0 | 25 | 103 | -103
1000 | 1100 | 0 | 0 | 0 | 25 | 103 | -103
1100 | 1200 | 0 | 0 | 0 | 25 | 103 | -103
1200 | 1300 | 0 | 0 | 0 | 25 | 103 | -103
1300 | 1400 | 0 | 0 | 0 | 25 | 103 | -103
1400 | 1500 | 0 | 0 | 0 | 25 | 103 | -103
1500 | 1600 | 0 | 0 | 0 | 25 | 103 | -103
1600 | 1700 | 0 | 0 | 0 | 25 | 103 | -103
1700 | 1800 | 0 | 0 | 0 | 25 | 103 | -103
1800 | 1900 | 0 | 0 | 0 | 25 | 103 | -103
1900 | 2000 | 0 | 0 | 0 | 25 | 103 | -103
2000 | 2100 | 0 | 0 | 0 | 25 | 103 | -103
2100 | 2200 | 0 | 0 | 0 | 25 | 103 | -103
2200 | 2300 | 0 | 0 | 0 | 25 | 103 | -103
2300 | 2400 | 0 | 0 | 0 | 25 | 103 | -103
2400 | 0100 | 0 | 0 | 0 | 25 | 103 | -103
 | MST Total
 | PDT Total
 |  | EPE@PV | EPE@PV | EPE@PV | EPE@PV | EPE@4C345 | SPS (G) @ EDDY TIE
 |  | EPMI | EPMI | EPMI | EPMI | EPMI | EPMI
 |  | CALPX@DEVERS | CALPX@DEVERS | PAC | WESCO | PSCO | EPE (L) @ EDDY TIE
 |  | EPMI_PX_2027 | EPMI_PX_2027 | CISO(T)PV/MALIN | SRP | SRP(T)4C345/4C230#6086
 |  |  |  | PAC(T)MALIN/SYS | SRP(T)PV/KYRENE#GF | PSCO(T)4C230/SR#GF
 |  |  |  | PAC@SYS | SRP@KYRENE | PSCO(T)SR/CG/WSYS#GF
 |  |  |  |  |  | PSCO@SYS
 | SRP CHECK
 | EPE CHECK
Spreadsheet: 792832d1661183101-want-to-make-simple-dynamic-dashboard-example-1-
Sheet: invalid email

Sl no. | [NAME] | Valid