tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 386130d1427625632-help-with-show-values-as-of-row-total-with-show-values-as-of-row-total-pivot
Sheet: Sheet1

Category | 1 | 2 | 3 | 4 | 5 | 6 | 7 | total 1-7
q | 29 | 21 | 126 | 65 | 114 | 100 | 935 | 1390 |  |  | Row Labels | Percentage (1) | Percentage (2) | Percentage (3) | Percentage (4) | Percentage (5) | Percentage (6) | Percentage (7)
w | 8 | 2 | 51 | 14 | 32 | 16 | 41 | 164 |  |  | a | 0 | 0 | 0 | 0 | 0 | 0 | 0
e | 7 | 14 | 48 | 56 | 108 | 87 | 831 | 1151 |  |  | e | 0.006081668114682885 | 0.01216333622936577 | 0.04170286707211121 | 0.04865334491746308 | 0.09383145091225022 | 0.07558644656820157 | 0.7219808861859253
r | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | i | 0.02539298669891173 | 0.01499395405078597 | 0.1027811366384522 | 0.05392986698911729 | 0.1061668681983071 | 0.09528415961305925 | 0.6014510278113664
t | 102 | 37 | 111 | 80 | 159 | 104 | 1012 | 1605 |  |  | o | 0.007194244604316547 | 0.007194244604316547 | 0.07913669064748201 | 0.09352517985611511 | 0.07194244604316546 | 0.1294964028776978 | 0.6115107913669064
y | 73 | 56 | 127 | 234 | 335 | 206 | 2499 | 3530 |  |  | p | 0 | 0 | 0 | 0 | 0 | 0 | 0
u | 11 | 10 | 53 | 26 | 73 | 28 | 55 | 256 |  |  | q | 0.02086330935251799 | 0.01510791366906475 | 0.09064748201438849 | 0.04676258992805755 | 0.08201438848920864 | 0.07194244604316546 | 0.6726618705035972
i | 105 | 62 | 425 | 223 | 439 | 394 | 2487 | 4135 |  |  | r | 0 | 0 | 0 | 0 | 0 | 0 | 0
o | 1 | 1 | 11 | 13 | 10 | 18 | 85 | 139 |  |  | s | 0 | 0 | 0 | 0 | 0 | 0 | 0
p | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | t | 0.06355140186915888 | 0.02305295950155763 | 0.0691588785046729 | 0.04984423676012461 | 0.09906542056074766 | 0.064797507788162 | 0.6305295950155764
a | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | u | 0.04296875 | 0.0390625 | 0.20703125 | 0.1015625 | 0.28515625 | 0.109375 | 0.21484375
s | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | w | 0.04878048780487805 | 0.01219512195121951 | 0.3109756097560976 | 0.08536585365853659 | 0.1951219512195122 | 0.0975609756097561 | 0.25
 |  |  |  |  |  |  |  |  |  |  | y | 0.02067988668555241 | 0.01586402266288952 | 0.03597733711048159 | 0.06628895184135977 | 0.09490084985835694 | 0.05835694050991502 | 0.7079320113314448
 |  |  |  |  |  |  |  |  |  |  | Grand Total | 0.02716248989490703 | 0.016410670978173 | 0.07696038803556993 | 0.05747776879547292 | 0.1026677445432498 | 0.07704122877930476 | 0.6422797089733225
Spreadsheet: 273041d1382592996-finding-values-in-a-range-and-then-sorting-horiztonally-while-removing-blanks-sorting-1-ans
Sheet: Sheet1

Range | 6132 |  | 6182 |  | 6267 | 2128
 |  | 6178 |  |  |  | 6086 |  | 6270 |  |  | 6138 |  |  | 6308
 | 1020 |  |  | 6188 |  |  | 6271 | 6298 | 6304
Sorted Result | 1020 | 2128 | 6086 | 6132 | 6138 | 6178 | 6182 | 6188 | 6267 | 6270 | 6271 | 6298 | 6304 | 6308
 | Your numbers are in text format
Result in number format
Result in TEXT format
Spreadsheet: 42140d1240697815-copying-text-to-next-rows-test
Sheet: Sheet1

Data Sample |  |  |  |  | Desire Result
Store | [NAME] | Qty 2 |  |  |  | [NAME] | Qty 2
Los angeles |  |  |  |  | Los angeles | 1234565 | 2
cla's | 1234565 | 2 |  |  | Los angeles | 1234565 | 3
cases | 1234565 | 3 |  |  | Los angeles | 1234565 | 5
 |  |  |  |  | Los angeles | 1234565 | 4
holsters | 1234565 | 5 |  |  | Los angeles | 1234565 | 2
memory | 1234565 | 4 |  |  | Los angeles | rows with no sku or qty should be deleted
travel charger | 1234565 | 2 |  |  | Los angeles | rows with no sku or qty should be deleted
 |  |  |  |  | Los angeles | rows with no sku or qty should be deleted
San diego |  |  |  |  | San diego | 1234565 | 1
 |  |  |  |  | San diego | 1234565 | 10
cla's | 1234565 | 1 |  |  | San diego | 1234565 | 14
cases | 1234565 | 10 |  |  | San diego | 1234565 | 5
 |  |  |  |  | San diego | 1234565 | 7
holsters | 1234565 | 14 |  |  | San diego | rows with no sku or qty should be deleted
memory | 1234565 | 5 |  |  | San diego | rows with no sku or qty should be deleted
travel charger | 1234565 | 7 |  |  | San diego | rows with no sku or qty should be deleted
Spreadsheet: 673817d1587554043-match-positive-and-negative-amount-to-get-zero-balance-excel-matchning-zero-balance
Sheet: Pivot

 |  |  |  |  | Document type
1 | PO Name | Document Date | Document Number | Posting Key | SH | XN | ZT |  | resault
 | ALAMANDA - COUNTER | 2019-11-06 00:00:00 | [PHONE] | 50 |  |  | -1924.25 |  | no match
 | ALAMANDA - COUNTER | 2019-11-06 00:00:00 | [PHONE] | 40 |  | 1902.45 |  |  | no match
 | ALAMANDA - COUNTER | 2019-11-10 00:00:00 | [PHONE] | 50 |  |  | -4949.08 |  | no match
 | ALAMANDA - COUNTER | 2019-11-10 00:00:00 | [PHONE] | 40 |  | 4949 |  |  | no match
 | ALAMANDA - COUNTER | 2020-02-10 00:00:00 | [PHONE] | 40 |  | 3520.15 |  |  | match
 | ALAMANDA - COUNTER | 2020-02-11 00:00:00 | [PHONE] | 50 |  |  | -5037.95 |  | match
 | ALAMANDA - COUNTER | 2020-02-11 00:00:00 | [PHONE] | 40 |  | 1517.8 |  |  | match
 | AMPANG-COUNTER | 2020-03-19 00:00:00 | [PHONE] | 40 |  | 259.3 |  |  | match
 | AMPANG-COUNTER | 2020-04-15 00:00:00 | [PHONE] | 50 |  |  | -1045.6 |  | match
 | AMPANG-COUNTER | 2020-04-15 00:00:00 | [PHONE] | 40 |  | 786.3 |  |  | match
 | AMPANG-COUNTER | 2020-04-17 00:00:00 | [PHONE] | 40 |  | 326.7 |  |  | match
 | AMPANG-COUNTER | 2020-04-18 00:00:00 | [PHONE] | 50 |  |  | -376.1 |  | match
 | AMPANG-COUNTER | 2020-04-18 00:00:00 | [PHONE] | 40 |  | 49.4 |  |  | match
 | AMPANG-COUNTER | 2020-04-20 00:00:00 | [PHONE] | 40 |  | 63.45 |  |  | no match
 | B.BARU AYER ITAM-COUNTER | 2018-10-31 00:00:00 | [PHONE] | 40 |  | 1151.95 |  |  | no match
 | B.BARU AYER ITAM-COUNTER | 2020-04-20 00:00:00 | [PHONE] | 40 |  | 261.05 |  |  | no match
 | BAGAN SERAI-COUNTER | 2020-04-20 00:00:00 | [PHONE] | 40 |  | 1060.7 |  |  | no match
 | BALAKONG-COUNTER | 2020-01-24 00:00:00 | [PHONE] | 40 |  | 292.5 |  |  | match
 | BALAKONG-COUNTER | 2020-01-28 00:00:00 | [PHONE] | 50 |  |  | -2044.55 |  | match
 | BALAKONG-COUNTER | 2020-01-28 00:00:00 | [PHONE] | 40 |  | 1752.05 |  |  | match
 | BALAKONG-COUNTER | 2020-04-20 00:00:00 | [PHONE] | 40 |  | 1469.6 |  |  | no match
 | BALIK PULAU-COUNTER | 2020-04-20 00:00:00 | [PHONE] | 40 |  | 727.85 |  |  | no match
 | [NAME] | 2020-02-05 00:00:00 | [PHONE] | 50 |  |  | -1033.4 |  | no match
 | [NAME] | 2020-02-05 00:00:00 | [PHONE] | 40 |  | 1033.6 |  |  | no match
 | [NAME] | 2020-03-09 00:00:00 | [PHONE] | 50 |  |  | -1296.3 |  | match
 | [NAME] | 2020-03-09 00:00:00 | [PHONE] | 40 |  | 1201.4 |  |  | match
 | [NAME] | 2020-03-16 00:00:00 | [PHONE] | 40 |  |  | 1743.45 |  | match
 | [NAME] | 2020-03-17 00:00:00 | [PHONE] | 50 | -1648.55 |  |  |  | match
 | [NAME] | 2020-04-20 00:00:00 | [PHONE] | 40 |  | 946.6 |  |  | no match
Spreadsheet: 676011d1588605899-how-to-get-data-based-on-date-criteria-excel-solution-miranti-
Sheet: Sticker

Period : | 2020-03-20 00:00:00 |  | 2020-04-20 00:00:00
Type | Start | Finish
abc | 2020-04-12 00:00:00 | 2020-04-21 00:00:00
lalal | 2020-04-12 00:00:00 | 2020-04-15 00:00:00
ZZZ | 2020-04-12 00:00:00 | 2020-04-15 00:00:00
[NAME] | 2020-04-13 00:00:00 | 2020-04-15 00:00:00
sss | 2020-04-14 00:00:00 | 2020-04-15 00:00:00
Update production
Date | Type |  | Date | Type
2020-04-12 00:00:00 | abc |  |  |  |  | abc
2020-04-12 00:00:00 | lalal
2020-04-12 00:00:00 | ZZZ
2020-04-13 00:00:00 | abc
2020-04-13 00:00:00 | lalal
2020-04-13 00:00:00 | ZZZ
2020-04-13 00:00:00 | [NAME]
2020-04-14 00:00:00 | lalal
2020-04-14 00:00:00 | ZZZ
2020-04-14 00:00:00 | [NAME]
2020-04-14 00:00:00 | sss
Spreadsheet: 696872d1601020700-sumproduct-with-indirect-mainsheet
Sheet: 8.HH

Particulars | 2019-04-01 00:00:00 | 2019-05-01 00:00:00 | 2019-06-01 00:00:00 | 2019-07-01 00:00:00 | 2019-08-01 00:00:00 | 2019-09-01 00:00:00 | 2019-10-01 00:00:00 | 2019-11-01 00:00:00 | 2019-12-01 00:00:00 | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | FY-20 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | FY-21
Production Qty | 180
Production Cost
Material Cost
Fuel Cost
Power Cost | 35
Spreadsheet: 9631d25c-24bf-4482-be1e-93f0bf2ab404
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
6362 | 52838 | [NAME] | Fawcett | GBR | 401 | 00:35:51 | 00:01:30 | 00:59:32 | 00:01:58 | 00:18:38 | 1 | 01:57:28
6362 | 43803 | [NAME] | Landon | GBR | 402 | 00:37:17 | 00:01:29 | 00:59:36 | 00:01:37 | [NAME] | 2 | 02:00:15
Spreadsheet: 329376d1404293446-using-the-sumproduct-book1
Sheet: Sheet1

2250 | - | - | - | - | - | - | I25 | x | - | 470.37
2250 | - | - | - | - | - | - | I75 | x | - | 3020.05
2600 | - | - | - | - | - | - | I25 |  | - | 45.7
2600 | - | - | - | - | - | - | I25 |  | - | 999.2
2450 | - | - | - | - | - | - | I25 |  | - | -32
2300 | - | - | - | - | - | - | I75 | x | - | 721.01
2250 | - | - | - | - | - | - | I25 | x | - | 3200
 |  | In this case, only row 1, 2 and 7 fit the criterias
 |  | My formula should then do the following calculation
 |  | K1*0,25+K2*0,171+K7*0,25
Spreadsheet: 809298d1671013308-sorting-formular-sorting
Sheet: PRIMARY

 | CLASESS | SUBJECTS | STREAMS | TEACHER'S NAME | NUMBER OF PERIODS PER WEEK IN EACH STREAM OR CLASS
 | 3 | MATHS | A | A.B | 7 | I NEED ROTATION TO BE IN THIS WAY MONDAY IN CLASS 3 STREAM A MATHS IN B SCIENCE IN C ENG
 |  | SCIENCE | B | B.C | 5 | IN D SOCIAL INE CIVIC. FIRST PERIOD.THEN SECOND PERIOD IN CLASS 3 STREAM A KISWAHILI IN B MATHS
 |  | ENG | C | C.D | 7 | IN C SCIENCE IN D ENG IN E SOCIAL. THEN THIRD PERIOD IN A  CIVIC IN B KISWAHILI IN C MATHS IN D SCIENCE IN E ENG AND THE REST UP TO THE LAST PERIOD
 |  | SOCIAL | D | D.E | 5 | AND IN EACH DAY THERE ARE 8 PERIODS EXCEPT THURSDAY AND FRIDAY THERE ARE 6 PERIODS
 |  | CIVIC | E | F.G | 5
 |  | KISWAHILI |  | H.I | 7
 | 4 | MATHS | A | A.B | 7
 |  | SCIENCE | B | B.C | 5
 |  | ENG | C | C.D | 7
 |  | SOCIAL | D | D.E | 5
 |  | CIVIC | E | F.G | 5
 |  | KISWAHILI |  | H.I | 7
 | 5 | MATHS | A | A.B | 7
 |  | SCIENCE | B | B.C | 5
 |  | ENG | C | C.D | 7
 |  | SOCIAL | D | D.E | 5
 |  | CIVIC | E | F.G | 5
 |  | KISWAHILI |  | H.I | 7
 |  | V.S |  |  | 4
 | 6 | MATHS | A | A.B | 7
 |  | SCIENCE | B | B.C | 5
 |  | ENG | C | C.D | 7
 |  | SOCIAL | D | D.E | 5
 |  | CIVIC | E | F.G | 5
 |  | KISWAHILI |  | H.I | 7
 |  | V.S |  |  | 4
 | 7 | MATHS | A | A.B | 7
 |  | SCIENCE | B | B.C | 5
 |  | ENG | C | C.D | 7
 |  | SOCIAL | D | D.E | 5
 |  | CIVIC | E | F.G | 5
 |  | KISWAHILI |  | H.I | 7
 |  | V.S |  |  | 4
 |  |  | I NEED ALL SPACES IN MAIN TIME TABLE TO BE FILLED AUTOMATIC ACCORDING TO NUMBERS OF PERIOD PER WEEK IN EACH CLASS AND EACH STREAM
 |  |  | ALSO TEACHER'S NAME TO BE IN A COLUMN OF TEACHER NAME
 |  |  | VS SHOULD APPERA FROM NUMBER 5 TO 7 ONLY
Spreadsheet: 768129d1644847973-formula-to-pick-up-last-6-months-data-test-2
Sheet: Summary

 |  |  | Month |  |  |  | YTD (6 Months)
 |  |  | Actual | Budget / Forecast | [NAME] |  | Actual | Budget | [NAME]
 |  | Revenue
 |  | Operating Profit (Pre provisions and transformation) | 2 | 3 | 3
 |  | %
 |  | Provisions and one-off
 |  | Tranformation cost | 2 | 3 | 3 |  | 3 | 3
 |  | Operating Profit
 |  | %
 |  | Investment | 0 |  |  |  | 0 | 0
 |  | Pension Admin and Charges
 |  | PBT
 |  | %
Spreadsheet: 186420d1350036886-search-beers
Sheet: G

Brewery |  | Beer
Gale’s |  | 5X
 |  | Best Bitter
 |  | [NAME]
Garton |  | Liquid Labotomy
[NAME] |  | Golden Haze
[NAME] |  | The Bishop’s Tipple
[NAME] |  | Whitney Bitter
 |  | [NAME]
Goacher’s |  | Real Mild Ale
 |  | Old 1066 Ale
 |  | Crown Imperial Stout
 |  | Maidstone Real Mild
 |  | Maidstone Old
[NAME] |  | [NAME]
Goff’s |  | Sleepless Night
[NAME] |  | [NAME]
[NAME] |  | [NAME]
 |  | Pommies Revenge
 |  | No Eye Deer
 |  | Chinook Blonde
Gott |  | Tournament
Grainstore |  | Rutland Panther
[NAME] |  | Baltic Trader Imperial Stout | 1/3 Only 10.5% !
[NAME] |  | XX [NAME]
 |  | [NAME]
Spreadsheet: 693504d1598994877-excel-formula-function-help-needed-mock-up
Sheet: extracted from Database

SSN | Network | Account | Group | ID | Code | First Name | Last Name | Gender | DOB | From Date | End Date
123456780 | ABC123 | OPEN | 1041JK | 12345678911 | 04 | [NAME] | Smith | M | 1977-11-11 00:00:00 | 2017-04-01 00:00:00 | 2018-02-28 00:00:00
098112356 | ABC123 | OPEN | 5214JK | 11121314156 | 04 | [NAME] | Doe | F | 1968-11-12 00:00:00 | 2014-03-01 00:00:00 | 2039-12-31 00:00:00
345678910 | ABC123 | OPEN | 3696JK | 12367891234 | 04 | [NAME] | Ray | M | 1984-08-07 00:00:00 | 2018-06-08 00:00:00 | 2039-12-31 00:00:00
075971908 | ABC123 | OPEN | 6435JK | 85278693127 | 04 | Riley | Trace | F | 1952-11-07 00:00:00 | 2015-10-01 00:00:00 | 2039-12-31 00:00:00
075971908 | ABC123 | RETIREE | 6436LM | 96321564783 | 06 | Riley | Trace | F | 1952-11-07 00:00:00 | 2020-09-01 00:00:00 | 2039-12-31 00:00:00
095393796 | ABC123 | OPEN | 7895JK | 32178965431 | 04 | [NAME] | Chi | F | 1982-06-08 00:00:00 | 2020-04-01 00:00:00 | 2039-12-31 00:00:00
093865135 | ABC123 | OPEN | 8525JK | 96385214743 | 04 | Trance | Pung | M | 1950-02-08 00:00:00 | 2019-02-01 00:00:00 | 2019-04-30 00:00:00
093865135 | ABC123 | OPEN | 8526JK | 52085496321 | 04 | Trance | Pung | M | 1950-02-08 00:00:00 | 2019-02-01 00:00:00 | 2019-07-31 00:00:00
093865135 | ABC123 | RETIREE | 8528LM | 96548963212 | 06 | Trance | Pung | M | 1950-02-08 00:00:00 | 2020-09-01 00:00:00 | 2039-12-31 00:00:00
093865135 | ABC123 | OPEN | 8527JK | 74101234637 | 04 | Trance | Pung | M | 1950-02-08 00:00:00 | 2020-09-01 00:00:00 | 2039-12-31 00:00:00
101213756 | ABC123 | OPEN | [NAME] | 70236514563 | 04 | [NAME] | [NAME] | M | 1977-05-10 00:00:00 | 2019-05-01 00:00:00 | 2039-12-31 00:00:00
202134867 | ABC123 | OPEN | 2316JK | 51456321789 | 04 | [NAME] | Adkins | M | 1978-04-03 00:00:00 | 2010-11-01 00:00:00 | 2020-05-31 00:00:00
202134867 | ABC123 | COBRA | 2317MN | 23102350456 | 05 | [NAME] | Adkins | M | 1978-04-03 00:00:00 | 2020-07-01 00:00:00 | 2039-12-31 00:00:00
013579908 | ABC123 | OPEN | 7415JK | 28516541385 | 04 | [NAME] | [NAME] | M | 1996-07-04 00:00:00 | 2020-09-01 00:00:00 | 2039-12-31 00:00:00
Spreadsheet: bb6a61aa-46f5-4179-a70d-d41b3d430ed7
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
5564 | 12428 | [NAME] | [NAME] | GBR | 432 | 00:43:43 | 00:00:58 | 01:14:14 | 00:24:14 | 00:43:41 | 1 | 02:23:09
Spreadsheet: 179210d1347062676-lcalculating-hours-overtime-and-doubletime-for-payroll-del-company-driver-overtime-calculator
Sheet: Sheet1

Name : | Driver
[NAME]: | 20
Overtime Rate:
Double Time
Date | Log in | [NAME] | Lunch Ends | Log Out | Regular Hrs | [NAME] | Double Time | Regular Pay | Overtime Pay | Double Pay | Total Pay
Monday
Tuesday | 2012-09-04 19:00:00 |  |  | 2012-09-05 07:15:00
Wednesday
Thursday
Friday
Saturday
Sunday
 |  |  |  | TOTAL
Spreadsheet: michelle_lokay__26617__imbalsumm0102
Sheet: transcol

 | TransColorado
 | 500632
Day | Measured | Scheduled
1 | 37095 | 37061
2 | 48398 | 47560
3 | 37220 | 37061
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
2001-01-31 00:00:00 |  |  | 275224
2001-02-03 00:00:00
Spreadsheet: 704479d1605594069-automatically-load-values-out-of-1-tab-to-another-tab-weekly-planner-to-be-loaded-with-info-out-of-first-tab
Sheet: forms export

 |  | THIS IS AN EXAMPLE OF AN EXPORT FROM A FORM MADE IN MICROSOFT FORMS
ID | Begintijd | [NAME] | E-mail | Naam | Visit date | Start time | End time | COMPANY NAME | Name | First name | Date of birth | Reason for visit | WHICH MOBILE DEVICES NEEDED FOR WORK REASONS | VOG OR SCREENING ARE VALID | GUIDANCE
1 | 2020-11-14 09:35:27 | 2020-11-14 09:36:51 | anonymous |  | 2020-11-17 00:00:00 | 7.00 | 16.00 | Test Company 1 | test name 1 | First name 1 | 1-1-2000 | Office Visit | Telephone; | NO | YES
2 | 2020-11-14 09:35:27 | 2020-11-14 09:36:51 | anonymous |  | 2020-11-18 00:00:00 | 7.01 | 16.01 | Test Company 2 | test name 2 | First name 2 | 1-1-2001 | Office Visit | tablet | NO | NO
3 | 2020-11-14 09:35:27 | 2020-11-14 09:36:51 | anonymous |  | 2020-11-19 00:00:00 | 7.02 | 16.02 | Test Company 3 | test name 3 | First name 3 | 1-1-2002 | Office Visit | laptop | NO | YES
4 | 2020-11-14 09:35:27 | 2020-11-14 09:36:51 | anonymous |  | 2020-11-20 00:00:00 | 7.03 | 16.03 | Test Company 4 | test name 4 | First name 4 | 1-1-2003 | Office Visit | Telephone; | NO | NO
5 | 2020-11-14 09:35:27 | 2020-11-14 09:36:51 | anonymous |  | 2020-11-21 00:00:00 | 7.04 | 16.04 | Test Company 5 | test name 5 | First name 5 | 1-1-2004 | Office Visit | Telephone; | NO | YES
6 | 2020-11-14 09:35:27 | 2020-11-14 09:36:51 | anonymous |  | 2020-11-22 00:00:00 | 7.05 | 16.05 | Test Company 6 | test name 6 | First name 6 | 1-1-2005 | Office Visit | Telephone; | NO | NO
7 | 2020-11-14 09:35:27 | 2020-11-14 09:36:51 | anonymous |  | 2020-11-23 00:00:00 | 7.06 | 16.06 | Test Company 7 | test name 7 | First name 7 | 1-1-2006 | Office Visit | Telephone; | NO | YES
8 | 2020-11-14 09:35:27 | 2020-11-14 09:36:51 | anonymous |  | 2020-11-24 00:00:00 | 7.07 | 16.07 | Test Company 8 | test name 8 | First name 8 | 1-1-2007 | Office Visit | Telephone; | NO | NO
9 | 2020-11-14 09:35:27 | 2020-11-14 09:36:51 | anonymous |  | 2020-11-25 00:00:00 | 7.08 | 16.08 | Test Company 9 | test name 9 | First name 9 | 1-1-2008 | Office Visit | Telephone; | NO | YES
10 | 2020-11-14 09:35:27 | 2020-11-14 09:36:51 | anonymous |  | 2020-11-26 00:00:00 | 7.09 | 16.09 | Test Company 10 | test name 10 | First name 10 | 1-1-2009 | Office Visit | Telephone; | NO | NO
11 | 2020-11-14 09:35:27 | 2020-11-14 09:36:51 | anonymous |  | 2020-11-27 00:00:00 | 7.10 | 16.10 | Test Company 11 | test name 11 | First name 11 | 1-1-2010 | Office Visit | Telephone; | NO | YES
12 | 2020-11-14 09:35:27 | 2020-11-14 09:36:51 | anonymous |  | 2020-11-28 00:00:00 | 7.11 | 16.11 | Test Company 12 | test name 12 | First name 12 | 1-1-2011 | Office Visit | Telephone; | NO | NO
13 | 2020-11-14 09:35:27 | 2020-11-14 09:36:51 | anonymous |  | 2020-11-29 00:00:00 | 7.12 | 16.12 | Test Company 13 | test name 13 | First name 13 | 1-1-2012 | Office Visit | Telephone; | NO | YES
Spreadsheet: 35971d1233706784-index-match-product-mix-comparison
Sheet: week of 19

ID | Name | Net
1 | Breakfast Special | 4
18 | Toast | 0.9
20 | 12oz Cream of Wheat | 1.5
33 | Open Food | 32.31
37 | small paper plate | 88.58
38 | large paper plate | 173.43
39 | large to go | 753.75
40 | small to go | 148.63
41 | Dry Fruit | 2.02
42 | china plate | 76.54
45 | [NAME] | 8.75
47 | Gyro | 501.5
51 | Large Cupcake | 6
62 | Small Soup Cup | 25.13
69 | Cheese Quesdilla | 4.5
71 | Extra Avocado | 1
72 | Express Snacks | 2
75 | Pacific Rim | 1549.8
76 | Taqueria | 1175.35
79 | Carvery | 791.5
80 | 22oz Soup | 33
81 | Taqueria2 | 505.75
87 | Dressing | 3.15
90 | Vegan Wrap | 116.9
90 | Vegan Special | 199.5
92 | [NAME] | 54.45
92 | vegan 2 | 66.5
96 | Gummy | 0.7
100 | Broiler Special | 881.1
102 | Exhibition | 1117.85
103 | Exhibition Chicken | 476
105 | Panini | 10
106 | Panini w/side salad | 385.25
107 | [NAME] | 387.45
108 | Sushi made to order | 728
110 | Entree | 375.15
111 | Entree Feature | 2789.35
113 | Grab & Go Salad | 460
114 | Side Vegetable | 94
116 | [NAME] | 339.25
121 | Tofurky | 2.8
122 | Liquorish | 1.4
126 | Izze Soda | 2.8
128 | [NAME] | 7
129 | Snapple | 2.8
130 | Rockstar | 5.25
131 | Pizza Special | 346.75
137 | Bawls Energy | 3.5
138 | Pomegranate Juice | 2.1
140 | [NAME] | 2.8
141 | LaBrea Roll | 10.5
149 | Exhibition Veggie | 29.75
151 | Natural Valley Bars | 1.05
152 | NewTree Chocolate | 4.2
153 | [NAME] | 1845
154 | seaweed | 4.2
155 | Jelly Beans | 1.05
156 | Milk 1/2 Pint | 19
167 | Minute [NAME] | 14.25
168 | Minute [NAME]) | 23
171 | small paper plate Deli | 11.68
173 | small to go [NAME] | 15.44
174 | large paper plate Deli | 155.44
176 | large to go [NAME] | 177.92
177 | china plate [NAME] | 3.44
193 | Half Grapefruit | 2.25
194 | Whole Grapefruit | 5
199 | One Taco | 22
200 | Cheese Pizza | 54
201 | [NAME] | 49.5
202 | Pizza with meat | 142.1
203 | Deep Dish Pizza | 77
204 | Bruschetta | 185.25
206 | Shrimp Bruschetta | 5.5
207 | Meat Pizza | 479.75
208 | Seafood Pizza | 4.75
209 | [NAME] to order | 4.75
212 | Cheese Quesadilla | 31.5
213 | Deluxe Quesadilla | 100
214 | [NAME] | 28.5
300 | 12oz Soup | 335.25
301 | 16oz Soup | 317.5
302 | 12oz Chili | 2.4
304 | Roll/Bread | 47.5
305 | Bread Bowl | 3
400 | Avocado | 2
401 | Bacon Cheese Burger | 20
402 | [NAME] | 16
403 | Broadcom Burger | 230.5
405 | [NAME] Sandwich | 199.5
407 | Club Sandwich | 8.6
408 | Extra Bacon | 1.65
409 | Fries | 75
410 | Garden Burger | 30.25
411 | Grilled Cheese | 25.5
412 | Ham & Cheese Sandwich | 36
413 | Hamburger | 26.75
414 | Cheeseburger | 46
415 | [NAME] | 5
419 | Onion Rings | 3.6
420 | [NAME] | 12
422 | [NAME] | 93.5
423 | Turkey Burger | 8
500 | Whole Fruit | 144.5
505 | Pudding | 11.2
507 | Large [NAME] | 14
508 | Small Yogurt Parfait | 18
510 | [NAME] | 40.5
511 | Gourmet Chips | 53.75
512 | Regular Chips | 65.1
513 | Cheesecake | 22.5
520 | Monster Cookies | 43.4
521 | Ms. Mays | 2
526 | Energy Bars | 2.8
802 | Soy Milk | 3.6
Spreadsheet: 732784d1621242728-need-function-to-find-the-sla-between-days-and-hours-excluding-non-business-hours-need-formula
Sheet: Sheet1

ID | Attempted? | vendor | creater | updated | push | activity | status | business | request | Person | Creator | ordered | Account | Approved At | Ordered | Completed At | Order time
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-04-29 22:07:48 | 2021-04-29 22:42:51
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-05-01 14:30:50 | 2021-05-01 15:43:08
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-05-03 23:44:54 | 2021-05-04 00:34:15
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-05-03 23:01:42 | 2021-05-04 01:34:02
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-04-28 01:34:26 | 2021-04-28 03:20:50
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-04-28 01:37:45 | 2021-04-28 03:20:45
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-04-28 01:38:58 | 2021-04-28 03:20:39
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-04-28 01:40:13 | 2021-04-28 03:20:32
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-04-28 01:43:01 | 2021-04-28 03:20:22
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-04-28 01:33:24 | 2021-04-28 03:20:06
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-04-28 02:01:55 | 2021-04-28 05:30:55
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-04-28 01:32:34 | 2021-04-28 03:19:39
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-04-28 02:01:40 | 2021-04-28 05:30:19