tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 729491d1619117639-excel-keeps-calculating-no-idea-why-production-planning-excel-issue
Sheet: ARTICLES

Article number | Full material Description | Length | [NAME] | Thickness | Density | Material description | Dimensions
146128 | 1 | 600 | 500 | 14 |  | 1
146176 | 2 | 601 | 501 | 15 |  | 2
146422 | 3 | 602 | 502 | 16 |  | 3
147021 | 4 | 603 | 503 | 17 |  | 4
147247 | 5 | 604 | 504 | 18 |  | 5
147484 | 6 | 605 | 505 | 19 |  | 6
149776 | 7 | 606 | 506 | 20 |  | 7
150198 | 8 | 607 | 507 | 21 |  | 8
150199 | 9 | 608 | 508 | 22 |  | 9
150200 | 10 | 609 | 509 | 23 |  | 10
150201 | 11 | 610 | 510 | 24 |  | 11
150202 | 12 | 611 | 511 | 25 |  | 12
150203 | 13 | 612 | 512 | 26 |  | 13
150214 | 14 | 613 | 513 | 27 |  | 14
150215 | 15 | 614 | 514 | 28 |  | 15
150447 | 16 | 615 | 515 | 29 |  | 16
151005 | 17 | 616 | 516 | 30 |  | 17
151006 | 18 | 617 | 517 | 31 |  | 18
151396 | 19 | 618 | 518 | 32 |  | 19
151397 | 20 | 619 | 519 | 33 |  | 20
151401 | 21 | 620 | 520 | 34 |  | 21
151402 | 22 | 621 | 521 | 35 |  | 22
151503 | 23 | 622 | 522 | 36 |  | 23
152071 | 24 | 623 | 523 | 37 |  | 24
152319 | 25 | 624 | 524 | 38 |  | 25
153631 | 26 | 625 | 525 | 39 |  | 26
154034 | 27 | 626 | 526 | 40 |  | 27
154595 | 28 | 627 | 527 | 41 |  | 28
155001 | 29 | 628 | 528 | 42 |  | 29
155421 | 30 | 629 | 529 | 43 |  | 30
155493 | 31 | 630 | 530 | 44 |  | 31
156067 | 32 | 631 | 531 | 45 |  | 32
156194 | 33 | 632 | 532 | 46 |  | 33
168076 | 34 | 633 | 533 | 47 |  | 34
168340 | 35 | 634 | 534 | 48 |  | 35
Spreadsheet: 873290d1719779232-do-not-count-in-range-average-if-cell-has-no-value-is-empty-blank-example_countif_notblank
Sheet: Sheet1

2024-06-25 00:00:00 |  | -5
2024-06-25 00:01:00 |  | 40.5
2024-06-25 00:02:00 |  | 34.4
2024-06-25 00:03:00 |  | 40.9 |  |  |  |  |  | G1 is not correct.
2024-06-25 00:04:00 |  | 28.7 |  |  |  |  |  | I1 is correct.
2024-06-25 00:05:00 |  | 19.6 |  |  |  |  |  | Value of 0.0 should be counted into the average.  Values of empty should not.
2024-06-25 00:06:00 |  | 39 |  |  |  |  |  | Thus, there are 55 valid readings, so sum and divide by 55 to get average.
2024-06-25 00:07:00 |  | 38.7 |  |  |  |  |  | However, G1 counts 60 readings so sum is divided by 60, which is incorrect.
2024-06-25 00:08:00 |  | 31.8
2024-06-25 00:09:00 |  | 42.4 |  |  |  |  |  | Column D simulates the data with a formula in it.
2024-06-25 00:10:00 |  | 43.9
2024-06-25 00:11:00 |  | 42.3
2024-06-25 00:12:00 |  | 33.7
2024-06-25 00:13:00 |  | 42.3
2024-06-25 00:14:00 |  | 25.7
2024-06-25 00:15:00 |  | 0
2024-06-25 00:16:00 |  | -5
2024-06-25 00:17:00 |  | -5
2024-06-25 00:18:00 |  | -5
2024-06-25 00:19:00 |  | -5
2024-06-25 00:20:00 |  | 38
2024-06-25 00:21:00 |  | 32.3
2024-06-25 00:22:00 |  | 15.4
2024-06-25 00:23:00 |  | 28.6
2024-06-25 00:24:00 |  | 35.7
2024-06-25 00:25:00 |  | 30.5
2024-06-25 00:26:00 |  | 19.6
2024-06-25 00:27:00 |  | 39.3
2024-06-25 00:28:00 |  | 42.7
2024-06-25 00:29:00 |  | 34.5
2024-06-25 00:30:00 |  | 33.9
2024-06-25 00:31:00 |  | 31.3
2024-06-25 00:32:00 |  | 34
2024-06-25 00:33:00 |  | 45.3
2024-06-25 00:34:00 |  | 37.1
2024-06-25 00:35:00 |  | 28.9
2024-06-25 00:36:00 |  | 29.1
2024-06-25 00:37:00 |  | 47.4
2024-06-25 00:38:00 |  | 39.7
2024-06-25 00:39:00 |  | 24.6
2024-06-25 00:40:00 |  | 44
2024-06-25 00:41:00 |  | 31.2
2024-06-25 00:42:00 |  | 39.3
2024-06-25 00:43:00 |  | 33.7
2024-06-25 00:44:00 |  | 28.5
2024-06-25 00:45:00 |  | 42
2024-06-25 00:46:00 |  | 36.6
2024-06-25 00:47:00 |  | 38.9
2024-06-25 00:48:00 |  | 25.4
2024-06-25 00:49:00 |  | 28.5
2024-06-25 00:50:00 |  | 40.6
2024-06-25 00:51:00 |  | 27.1
2024-06-25 00:52:00 |  | 27.3
2024-06-25 00:53:00 |  | 31.3
2024-06-25 00:54:00 |  | 31
2024-06-25 00:55:00 |  | 43.9
2024-06-25 00:56:00 |  | 22.5
2024-06-25 00:57:00 |  | 37.2
2024-06-25 00:58:00 |  | 29.8
2024-06-25 00:59:00 |  | 23.4
Spreadsheet: 671930d1586623560-fix-template-based-on-raw-data-sheet-current-and-previous-day-templates
Sheet: Rawdata

Date | Item | Sample | data
2020-04-09 00:00:00 | Name6 | Sample6 | 10
2020-04-09 00:00:00 | Name7 | Sample7 | 11
2020-04-09 00:00:00 | Name8 | Sample8 | 12
2020-04-09 00:00:00 | Name9 | Sample9 | 13
2020-04-09 00:00:00 | Name10 | Sample10 | 14
2020-04-09 00:00:00 | Name11 | Sample11 | 15
2020-04-10 00:00:00 | Name1 | Sample1 | 50
2020-04-10 00:00:00 | [NAME] | Sample2 | 51
2020-04-10 00:00:00 | Name6 | Sample6 | 55
2020-04-10 00:00:00 | Name7 | Sample7 | 56
2020-04-10 00:00:00 | Name8 | Sample8 | 57
2020-04-10 00:00:00 | Name9 | Sample9 | 58
2020-04-10 00:00:00 | Name10 | Sample10 | 59
2020-04-10 00:00:00 | Name11 | Sample11 | 60
2020-04-09 00:00:00 | Name1 | Sample1 | 5
2020-04-09 00:00:00 | [NAME] | Sample2 | 6
2020-04-09 00:00:00 | Name3 | Sample3 | 7
2020-04-09 00:00:00 | Name4 | Sample4 | 8
2020-04-09 00:00:00 | Name5 | Sample5 | 9
2020-04-10 00:00:00 | Name3 | Sample3 | 52
2020-04-10 00:00:00 | Name4 | Sample4 | 53
2020-04-10 00:00:00 | Name5 | Sample5 | 54
Spreadsheet: 741836d1627385794-excel-room-booking-sheet-using-sumproduct-and-conditional-formatting-sv-booking-sheet-27-july-2021-ans4
Sheet: Availability Calendar (2021)

 |  |  |  | =IF($C8<>"",IF(SUMPRODUCT(('Room Reservation'!$K$9:$K$1181=E$7)*('Room Reservation'!$B$9:$B$1181=$C8))>0,10,1-SUMPRODUCT(('Room Reservation'!$K$9:$K$1181<=E$7)*('Room Reservation'!$L$9:$L$1181>=E$7+1)*('Room Reservation'!$B$9:$B$1181=$C8))),"") |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Villa #1
 |  |  |  | VILLA AVAILABILITY TABLE FOR PERIOD: |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 0.1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Villa #2
 |  |  |  | -1 | Available |  | 0 | Not Available |  |  | >=1 | Double Reservation |  |  |  | First day of CheckIn |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Villa #3
 |  | Enter Date here |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Villa #4
 |  | 2021-07-01 00:00:00 |  | 0
No | Room Type | Room Number |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Unbooked Days
1 | Standard | 1
2 | Standard | 2
3 | Standard | 3
4 | Standard | 4
5 | Standard | 5
No | Room Type | Room Number
1 | Standard | 1
2 | Standard | 2
3 | Standard | 3
4 | Standard | 4
5 | Standard | 5
No | Room Type | Room Number
1 | Standard | 1
2 | Standard | 2
3 | Standard | 3
4 | Standard | 4
5 | Standard | 5
No | Room Type | Room Number
1 | Standard | 1
2 | Standard | 2
3 | Standard | 3
4 | Standard | 4
5 | Standard | 5
No | Room Type | Room Number
1 | Standard | 1
2 | Standard | 2
3 | Standard | 3
4 | Standard | 4
5 | Standard | 5
No | Room Type | Room Number
1 | Standard | 1
2 | Standard | 2
3 | Standard | 3
4 | Standard | 4
5 | Standard | 5
Spreadsheet: 158778d1338391156-how-to-show-the-corresponding-options-in-a-drop-down-list-for-each-question-selection-options
Sheet: Sheet1

SelectQuestion | SelectResponse |  |  |  |  |  |  |  | Questions | Options
Q1 | 1 |  |  |  |  |  |  |  | Q1 | 1
 |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  | Q2 | 1
 |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  | Q3 | 1
 |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  | 4
Spreadsheet: 723531d1615754030-date-conversion-sample-bsb-
Sheet: Sheet1

Name | First | Last | RecNo | DOB | DOD
NA, [NAME] | [NAME] | NA | 441
NA, Eldad | Eldad | NA | 178 | 23 Mar 1711 | 4 Jun 1773
NA, Judith | [NAME] | NA | 314 | 1702 | 4 Apr 1763
NA, [NAME] | [NAME] | NA | 292
[NAME], [NAME] | [NAME] | [NAME] | 29 | 3 Aug 1899 | 1970-11-02 00:00:00
[NAME], [NAME] A | [NAME]  A | [NAME] | 3 | 1926-08-10 00:00:00 | 2018-01-05 00:00:00
Allen, [NAME] T | Alvin  T | [NAME] | 43 | Nov 1837 | 1927
[NAME], [NAME] | [NAME] | [NAME] | 28 | Jan 1898 | 1971-08-05 00:00:00
[NAME], [NAME] | [NAME] | [NAME] | 37 | 15 Jul 1879 | 1972-03-15 00:00:00
[NAME], [NAME] | [NAME] | [NAME] | 413 | 1920-07-21 00:00:00 | 1972-03-15 00:00:00
[NAME], Eleanor | Eleanor | [NAME] | 44 | 1837
[NAME], Elmer | Elmer | [NAME] | 31 | 1901 | 1981-02-26 00:00:00
[NAME], [NAME] | Fred  K | [NAME] | 40 | Sep 1870 | 1920
[NAME], [NAME] | [NAME] | [NAME] | 30 | 1902-03-10 00:00:00 | 1967-08-18 00:00:00
[NAME], Hattie | Hattie | [NAME] | 36 | 8 Aug 1884 | 24 Nov 1890
[NAME], [NAME] | [NAME] | [NAME] | 34 | abt 1877
[NAME], [NAME] | [NAME] | [NAME] | 45 | 14 Jul 1840 | 1925-09-16 00:00:00
[NAME], [NAME] | [NAME] | [NAME] | 41 | 1805 | 18 May 1883
[NAME], [NAME] | [NAME] | [NAME] | 35 | 13 May 1887 | 1950-03-23 00:00:00
Allen, [NAME] | [NAME] | [NAME] | 38 | 1872 | 1938-04-09 00:00:00
Spreadsheet: 733021d1621356431-help-with-an-area-formula-plate-project
Sheet: Joseph

 |  |  |  |  | Input Sheet A |  |  | Input Sheet B
 |  |  |  |  | [NAME] | Length | Surface Area | [NAME] | Length | Surface Area
 |  | Output Sheet |  |  | 1250 | 1700 |  | 1500 | 2200
 |  |  |  | Surface | Number | % | % | Number | % | %
 | Machines | [NAME] | Length | Area | of Cuts | Waste | Utilisation | of Cuts | Waste | Utilisation
 | Bobst 76 | 556 | 798
 | Bobst 102 | 715 | 1052
 | Bobst 104 | 736 | 1074
 | Bobst 106s | 760.5 | 1090
 | Bobst 106c | 730 | 1090
 | Bobst SPO 1600 | 1090 | 1629
 | Bobst 142 | 1028 | 1449
 | Bobst 145 | 1064 | 1484
Spreadsheet: 153550d1335960364-queuing-if-a-cell-in-column-a-is-15-only-the-first-the-next-values-should-be-0-need-help
Sheet: Ark1

Does it use counter 1? (1 = Yes) | Amount of queue in queue 1 |  | Does it use counter 2 (1 = Yes) | Amount of queue in queue 1
1 | 0 |  | 0 | 0
1 | 1 |  | 0 | 0
1 | 0 |  | 0 | 0
1 | 1 |  | 0 | 0
1 | 2 |  | 0 | 0
1 | 3 |  | 0 | 0
1 | 4 |  | 0 | 0
1 | 5 |  | 0 | 0
1 | 5 |  | 0 | 0
1 | 5 |  | 0 | 0
1 | 6 |  | 0 | 0
1 | 7 |  | 0 | 0
1 | 8 |  | 0 | 0
1 | 9 |  | 0 | 0
1 | 10 |  | 0 | 0
1 | 9 |  | 0 | 0
1 | 10 |  | 0 | 0
1 | 10 |  | 0 | 0
1 | 11 |  | 0 | 0
1 | 11 |  | 0 | 0
1 | 11 |  | 0 | 0
1 | 12 |  | 0 | 0
1 | 12 |  | 0 | 0
1 | 13 |  | 0 | 0 |  | When column B hits 15 for the first time:
1 | 14 |  | 0 | 0
1 | 15 |  | 0 | 0 |  | The cells marked with purple should all be 0 until queue 2 has reached the same level of people in queue
0 | 15 |  | 1 | 0 |  | Furthermore queue 1 should not be limited to 15 customers as now, when having opened counter 2.
0 | 15 |  | 1 | 1
0 | 15 |  | 1 | 1
0 | 14 |  | 1 | 2
1 | 15 |  | 0 | 1
0 | 15 |  | 1 | 0
0 | 15 |  | 1 | 1
0 | 15 |  | 1 | 1
0 | 14 |  | 1 | 2
1 | 14 |  | 0 | 3
1 | 15 |  | 0 | 0
0 | 15 |  | 1 | 0
0 | 15 |  | 1 | 2
0 | 15 |  | 1 | 2
0 | 13 |  | 1 | 3
1 | 13 |  | 0 | 3
 | … |  |  | …
 | … |  |  | …
 | 8 |  |  | 8 |  | What it should end like..
 | 9 |  |  | 8
 | 9 |  |  | 9
 | 10 |  |  | 9
 | 9 |  |  | 10
 | 10 |  |  | 10
 | 11 |  |  | …
 | … |  |  | …
 | … |  |  | …
 | 20 |  |  | 19
 | 20 |  |  | 20
 | 21 |  |  | 20
 | 21 |  |  | 21
 | 22 |  |  | 20
 | … |  |  | …
Spreadsheet: 118532d1313749369-football-prediction-point-system-football-prediction
Sheet: Sheet1

 |  |  |  |  |  | Points Scored (formula goes here)
 | Predictions
 |  | GOALS |  | GOALS |  |  | Correct pointing | How it works
 | [NAME] | 1 | v | 1 | Wolves | 30 | -3 | Not precited winner, goal diffirence 1 so I socre -3 | HOW PTS ARE SCORED
 | Fulham | 2 | v | 1 | [NAME] | 0 | -9 | Not predicted the draw, 3 goals pridicted wrong so I score -9 | HOME WIN PREDICTED
 | Liverpool | 2 | v | 1 | Sunderland | 30 | -3 | Not predicted the draw, I put wxtra goal for liverpool so I get -3 | SPOT ON = 40 pts
 | Man City | 2 | v | 0 | Swansea | 30 | 14 | I predicted the winner but not spot on so I get 20 points for CLOSE score and I minuse 3 per goal diffirence from the points earnerd. 20-6=14 points | CLOSE = 20 [NAME] (-3 PER GOAL OUT)
 | Newcastle | 1 | v | 2 | Arsenal | 0 | -9 | Not predicted the draw, 3 goals pridicted wrong so I score -9 | WRONG = 0 [NAME] (-3 PER GOAL OUT)
 | QPR | 1 | v | 2 | [NAME] | 30 | 21 | I predicted the AWAY winner but not spot on so I get 30 points for Away CLOSE score and I minuse 3 per goal diffirence from the points earnerd. Wrong goals for QPR is 1 and for [NAME] so 3 wron goals = -9. Points should be 30-9 =21
 | Stoke | 1 | v | 2 | Chelsea | 0 | -9 | Not predicted the draw, 3 goals pridicted wrong so I score -9 | DRAW PREDICTED
 | Tottenham | 1 | v | 1 | Everton | 50 | 50 | Game not played but as if I precicted Spot on draw, it equals 50 points | SPOT ON = 50 pts
 | West Brom | 1 | v | 3 | Man Utd | 30 | 27 | Away winer predicted so 30 pints but I was wrong [NAME]. So 30-3 =27 | CLOSE = 30 [NAME] (-3 PER GOAL OUT)
 | [NAME] | 2 | v | 0 | [NAME] | 30 | -6 | Not predicted the draw, 2 goals pridicted wrong so I score -6 | WRONG = 0 [NAME] (-3 PER GOAL OUT)
 |  |  |  |  |  |  |  |  | AWAY WIN PREDICTED
 | [NAME] |  |  |  |  |  |  |  | SPOT ON = 50 pts
 |  | GOALS |  | GOALS |  |  |  |  | CLOSE = 30 [NAME] (-3 PER GOAL OUT)
 | [NAME] | 1 | v | 2 | Wolves |  |  |  | WRONG = 0 [NAME] (-3 PER GOAL OUT)
 | Fulham | 0 | v | 0 | [NAME]
 | Liverpool | 1 | v | 1 | Sunderland
 | Man City | 4 | v | 0 | Swansea
 | Newcastle | 0 | v | 0 | Arsenal
 | QPR | 0 | v | 4 | [NAME]
 | Stoke | 0 | v | 0 | Chelsea
 | Tottenham | 1 | v | 1 | Everton
 | West Brom | 1 | v | 2 | Man Utd
 | [NAME] | 1 | v | 1 | [NAME]
Spreadsheet: 774931d1648730203-look-up-and-retrieve-excel-sample
Sheet: Mar 2022

ID # | Team A Maintenance Hours | Team B Maintenance Hours | Total [NAME]
GG984 | 23.2 | 45
GG447 | 45.5 | 77
OP456 | 78.8 | 105.2
HT444 | 4.4 | 78.4
[NAME] | 3 | 14
WE123 | 0 | 12
WR144 | 0 | 54
Spreadsheet: 594659d1539883603-conditional-formatting-weekend-dates-cf-for-weekend-dates
Sheet: Sheet1

Date | Due date | Day 35 | Day 59 | Day 60 | Day 75 | Day 90
Spreadsheet: 823448d1679966871-excel-calendar-perpetual-events-monthly-calendar-sample
Sheet: APRIL

APRIL 2023
SUNDAY |  | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY
 | 26 | 27 | 28 | 29 | 30 | 31 | 1
 | 2 | 3 | 4 | 5 | 6 | 7 | 8
 |  | [NAME] born 4/3/1853 - 2/21/1938 @ 85 |  |  |  | Good Friday
 | 9 | 10 | 11 | 12 | 13 | 14 | 15
 | [NAME] dies 4/9/1937 @ 83 ([NAME]'s aunt)
 | 16 | 17 | 18 | 19 | 20 | 21 | 22
 | 23 | 24 | 25 | 26 | 27 | 28 | 29
 | 30 | 1 | 2 | 3 | 4 | 5 | 6
Notes: |  |  |  |  |  |  | © www.calendarlabs.com
[NAME] "Little Mother" (1853-1938) and her family traveled in the highest of Chicago society.  Her husband was a personal friend of President [NAME].  [NAME]  came home from school one day and was told she would be a teacher from then on.  She was a brilliant teacher, learning by reading from a book as she washed the dishes.  [NAME] easily controlled a class of unruly boys that had driven several teachers out.
Spreadsheet: 687654d1595335020-solver-problem-risk-optimizer-excel-forum-sample
Sheet: Position

 |  | 1yr | 2yr | 3yr | 4yr | 5yr | 6yr | 7yr | 10yr | Total |  | [NAME] | 500
 | Position | 300 | 150 | 175 | -500 | 1250 | 275 | -50 | -400 |  |  | Min
 | Overlay | 400 | -100 | 75 | -10 | -700 |  | 100 | 50
 |  |  |  |  |  |  |  |  |  |  |  | Risk
 | Total
 | Scenarios |  |  |  |  |  |  |  |  |  |  |  |  |  | Position |  |  |  |  |  |  |  |  | Total
1 | Solver | -500 | -316 | -225 | 485 | -500 | -162 | -117 | 348
 | Manual 1 | -400 |  |  | 500 | -500
 | Manual 2 |  | -500 |  |  | -300
 | Manual 3 |  |  | -500 | -500 |  |  |  | 100
 | Manual 4
 | Manual 5
Spreadsheet: 268852d1380858583-formula-to-calculate-cost-based-on-increasing-scale-calculate-cost
Sheet: Sheet1

Units |  | Cost
From | To
0 | 500 | 40
501 | 1000 | 45
1001 | 1500 | 50
1501 | 2000 | 55
2001 | 2500 | 60
2501 | 3000 | 65
3001 | 3500 | 70
3501 | 4000 | 75
 |  | Units | Cost
Search Criteria : |  | 331
 |  | 200
 |  | 989
 |  | =IFERROR(VLOOKUP(LOOKUP(C14;SMALL($A$3:$A$10;ROW(INDIRECT("1:"&ROWS($A$3:$A$10)))));$A$3:$C$10;3;0);"")*C14
 |  | Enjoy……….
 |  | Azumi
Spreadsheet: 153330d1335875553-calculation-of-text-and-numbers-claims
Sheet: TOTALS

Policy | CLAIMS |  |  |  | TOTAL CLAIMS |  | DEDUCTIBLE/ | Claims Recorded At Nil
Year | Paid |  | Oustanding |  |  |  | EXCESS
 | No. | Amount | No. | Amount | No. | Amount | APPLICABLE
 |  | Not Insured
TOTALS
 | 1 | If the value is all "0" then its wants to show"Nil" value
 | 2 | If there is "Not Insured" then in total also wants to show "Not Insured" in Paid Amount column and rest all cells will be blank
Spreadsheet: 293217d1390923337-custom-sorting-will-not-work-on-table-with-index-formulas-1-excel-forum-jan28
Sheet: EXAMPLE SHEET

 |  |  | DAY of MO | TOTAL CHARGE | STATE OF DELV | CONDITION | COLOR |  |  |  |  |  |  |  |  | DAY of MO | TOTAL CHARGE | STATE OF DELV | CONDITION | COLOR
 |  |  |  |  |  |  |  | MODEL | ZIP CODE |  | PAYMENT |  |  |  |  |  |  |  |  |  | MODEL | ZIP CODE |  | PAYMENT
RO | ACCOUNT | CUSTOMER |  |  |  |  |  |  |  | FEE |  |  | RO | ACCOUNT | CUSTOMER |  |  |  |  |  |  |  | FEE
Spreadsheet: kam_keiser__17949__Book List
Sheet: Sheet1

Netco East Power
Book Organization
[NAME] |  | Old Power Book Name |  | Power Book Name |  | Region |  | Old Gas Book Name | Gas Book Name
[NAME] |  | EPMI-LT-NW |  | NETCO-LT-NW |  | All |  | PWR-NG-WEST | PWR-GAS-NW
[NAME] |  | EPMI-LT-SW |  | NETCO-LT-SW |  | All |  | PWR-NG-LTSW | PWR-GAS-SW
[NAME] |  | EPMI-LT-CALI |  | NETCO-LT-CALI |  | All |  | PWR-NG-LTCA | PWR-GAS-CALI
[NAME] |  | EPMI-ST-NW |  | NETCO-ST-NW |  | All
[NAME] |  | EPMI-ST-NW |  | NETCO-ST-NW |  | All
[NAME] |  | EPMI-ST-SW |  | NETCO-ST-SW |  | All
[NAME] |  | EPMI-ST-SW |  | NETCO-ST-SW |  | All
[NAME] |  | EPMI-ST-CA |  | NETCO-ST-CALI |  | All
[NAME] |  | EPMI-LT-WESTMGM |  | NETCO-LT-WMGM |  | All |  | PWR-NG-LT-WST | PWR-GAS-WMGMT
[NAME] |  | EPMI-ST-WHOURLY |  | NETCO-W-WMGM |  | All
 |  |  |  |  |  |  |  |  | PWR-GAS-ERCOT
Spreadsheet: 739386d1625668762-server-down-time-and-up-time-issue-need-help-new-daily-status-tracker-working
Sheet: 2021

Daily Status Tracking  (2021) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Weekend | Holiday
Date | Downtime (Start) | Downtime (End) | Downtime (Total/Hr:Min) | Up Time % | Down Time % | Downtime (Start) | Downtime (End) | Downtime (Total/Hr:Min) | UP Time % | Down Time % | Downtime (Start) | Downtime (End) | Downtime (Total/Hr:Min) | Up Time % | Down Time % | Reason for Outage | Verified By:
2021-07-01 00:00:00 | 01:00:00 | 13:00:00
Spreadsheet: 682765d1592321218-data-validation-with-an-extra-entry-for-all-in-the-list-gl3-1-
Sheet: Invoice Detail

Invoice No | Inv Date | Customer | Factory | Product | Qty | Price | Adj Type | Adj Value | Total | Comm. % | Comm. | Year | Perf
1 |  |  |  | X1 | 10 | 10 | None |  |  | 9
1 |  |  |  | X14 | 10 | 20 | None |  |  | 9
1 |  |  |  | X15 | 25 | 15 | None |  |  | 9
2 |  |  |  | X1 | 50 | 10 | None |  |  | 9
3 |  |  |  | X4 | 60 | 5 | None |  |  | 9
3 |  |  |  | X7 | 50 | 25 | None |  |  | 9
4 |  |  |  | Y12 | 60 | 35 | None |  |  | 9
4 |  |  |  | [NAME] | 50 | 25 | None |  |  | 9
5 |  |  |  | X7 | 50 | 25 | None |  |  | 9
5 |  |  |  | X8 | 80 | 40 | None |  |  | 9
5 |  |  |  | X15 | 10 | 15 | None |  |  | 9
6 |  |  |  | [NAME] | 20 | 2 | None |  |  | 9
7 |  |  |  | Z6 | 30 | 8 | None |  |  | 9
8 |  |  |  | X8 | 30 | 14 | None |  |  | 9
9 |  |  |  | Y6 | 40 | 15 | None |  |  | 9
Spreadsheet: 839046d1691606745-multiple-match-criteria-then-sum-of-two-columns-multiplied-formula-excel
Sheet: Sheet1

Customer | Time Period | Qty | Price |  |  | Answer I want
[NAME] | Summer | 100 | 50
[NAME] | Winter | 60 | 40
[NAME] | Summer | 200 | 10 |  |  | Larger Data:Want to pull based on match of [NAME] and Summer into one cell
[NAME] | Winter | 150 | 30
Spreadsheet: vkaminski__40932__Raptor 3b
Sheet: B_D TRS

B_D TRS Analysis
Screen
Strike
 | Screen | Strike |  | Clint's Check
FMV of Warrants |  |  |  | FMV
Debt & Equity O/S |  |  |  | Capital
Equity Lost
 |  |  |  | Screen
ENE Pays Hawaii |  |  |  | Strike
Hawaii Pays ENE
In(Out) to ENE |  |  | Hedged Gain
Strike Value
ENE Pays Porc.
Porc. Pays ENE
Net P&L To ENE
Check
Spreadsheet: 240094d1370199674-highlighting-cells-by-date-depending-on-where-i-put-an-x-defects-status-sheet-2013-copy
Sheet: DEFECTS STATUS SHEET

 | 1 |  | Defects Raised | Defects Completed | Defects Outstanding
DEFECTS - STATUS SHEET
CONVEYOR | Description | Reported | Date | Owner | DATE | Priority
No | Problem Statement | By | Raised |  | Completed | 1 | 2 | 3 | 4
1 | JOB 1 |  | 2013-05-01 00:00:00 |  |  | X
2 | [NAME] |  | 2013-05-15 00:00:00 |  |  |  | X
3 | JOB 3 |  | 2013-05-26 00:00:00 |  |  |  |  | X
4 | JOB 4 |  | 2013-06-01 00:00:00 |  |  |  |  |  | X
5 | JOB 5 |  | 2013-06-02 00:00:00 |  |  | X
Spreadsheet: 717584d1612753536-conditional-formatting-multiple-ranges-tabs-conditional-formatting-multiple-rules-referencing-separate-sheet-fayecattini-
Sheet: Monthly View

 | Resource Working Days Overview |  |  |  |  |  |  |  |  |  |  |  |  |  | Month |  |  |  | 2 |  |  |  | Year |  |  | 2021
 | Resource Groups
 | MTCSS 1
 | MTCSS 2
 | CONTRACT 1
 | CONTRACT 2
 | CONTRACT 3
 | CONTRACT 4
 | SPRAY 1
 | SPRAY 2
Spreadsheet: cbdfbba5-6bf3-4936-98c9-df38d12b55b3
Sheet: Certification Page

Did the application rates exceed the limits in Attachment B of your permit?
If not a basin, were the sites kept free of vegetation and raked?
If not a basin, were there any instances of effluent ponding in or runoff from the sites?
If a basin, were there any instances of breakout from the berms?
Was the onsite automatically activated standby power source tested and operational?
If the facility is non-compliant, please explain in the space below the reason(s) the facility was not in compliance.  Provide in your explanation the date(s) of the non-compliance and describe the corrective action(s) taken. Attach additional sheets if necessary.
Operator in Responsible Charge (ORC) Certification |  |  |  |  |  |  |  |  |  |  |  | Permittee Certification
ORC: |  |  |  |  |  |  |  |  |  |  |  | Permittee:
Certification No.: |  |  |  |  |  |  |  |  |  |  |  | Signing Official:
Grade: |  |  |  |  | Phone Number: |  |  |  |  |  |  | Signing Official's Title:
Has the ORC changed since the previous NDAR-2? |  |  |  |  |  |  |  |  |  |  |  | Phone Number: |  |  |  |  | Permit Exp.:
Signature |  |  |  |  |  |  |  |  |  | Date |  | Signature |  |  |  |  |  |  |  | Date
By this signature, I certify that this report is accurrate and complete to the best of my knowledge. |  |  |  |  |  |  |  |  |  |  |  | I certify, under penalty of law, that this document and all attachments were prepared under my direction or supervision in accordance with a system designed to assure that all qualified personnel properly gathered and evaluated the information submitted. Based on my inquiry of the person or persons who manage the system, or those persons directly responsible for gathering the information, the information submitted is, to the best of my knowledge and belief, true, accurate, and complete. I am aware that there are significant penalties for submitting false information, including the possibility of fines and imprisonment for knowing violations.
Mail Original and Two Copies to:
Division of Water Resources
Information Processing Unit
1617 Mail Service Center
Raleigh, North Carolina 27699-1617