tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 114632d1310390416-how-to-colour-the-cell-with-word-if-book1
Sheet: Sheet1

 |  |  |  |  |  | Date |  | 08:00:00 | 09:00:00 | 10:00:00 | 11:00:00 | 12:00:00 | 13:00:00 | 14:00:00 | 15:00:00
Booking Detail |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Time Table
Date | Name | Room | start | End |  |  |  |  |  |  |  |  |  |  |  | Date |  | 08:00:00 | 09:00:00 | 10:00:00 | 11:00:00 | 12:00:00 | 13:00:00 | 14:00:00 | 15:00:00
2011-07-03 00:00:00 | [NAME] | Room 2 | 08:00:00 | 10:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2011-07-03 00:00:00 | ROOM1 | [NAME]
2011-07-03 00:00:00 | [NAME] | Room 1 | 08:00:00 | 12:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2011-07-03 00:00:00 | ROOM2 | MARY |  |  |  |  | AMY
2011-07-03 00:00:00 | [NAME] | Room 3 | 14:00:00 | 15:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2011-07-03 00:00:00 | ROOM3 |  |  |  |  | STEPHEN |  | [NAME]
2011-07-03 00:00:00 | Stephen | Room 3 | 12:00:00 | 13:00:00
2011-07-04 00:00:00 | [NAME] | Room 3 | 09:00:00 | 12:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2011-07-04 00:00:00 | ROOM1
2011-07-03 00:00:00 | [NAME] | Room 2 | 13:00:00 | 15:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2011-07-04 00:00:00 | ROOM2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-07-04 00:00:00 | ROOM3 |  | MARY
2011-07-05 00:00:00
2011-07-06 00:00:00 | [NAME] | Room 3 | 08:00:00 | 09:00:00
2011-07-06 00:00:00 | [NAME] | Room 3 | 09:00:00 | 10:00:00
2011-07-06 00:00:00 | Stranger | Room 3 | 11:00:00 | 12:00:00
2011-07-06 00:00:00 | No name | Room 3 | 13:00:00 | 14:00:00
Spreadsheet: 827316d1682605889-dynamic-table-reference-based-on-todays-date-to-create-a-small-summary-table-dynamic-table-reference-by-date
Sheet: Sheet1

 | Number of Flowers sold by date (past and future orders)
Flowers |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | …
Roses | 2 | 2 | 4 | 2 | 1 | 2 | 1 | 3 | 3 | 5 | 4 | 1 | 2 | 5 | 2 | 1 | 4 | 2 | 4 | …
[NAME] | 14 | 11 | 12 | 13 | 14 | 15 | 14 | 12 | 11 | 11 | 14 | 12 | 4 | 17 | 15 | 12 | 13 | 12 | 11 | …
Orchid | 1 | 2 | 1 | 2 | 1 | 2 | 3 | 1 | 2 | 3 | 2 | 3 | 4 | 1 | 2 | 1 | 2 | 1 | 1 | …
Tulip | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 3 | 1 | 1 | 1 | 1 | 1 | …
[NAME] | 6 | 7 | 5 | 8 | 5 | 4 | 5 | 8 | 9 | 6 | 2 | 4 | 5 | 4 | 7 | 1 | 5 | 7 | 1 | …
Simple 4 day look ahead for flower orders
Flowers
 | How would I create a lookup  to include only the data associated with the dates in the small summary table that dynamically reference a larger data table that goes on indefinately?
Spreadsheet: 822633d1679462323-repeat-values-x-times-down-a-column-s666-pq-repeat-values
Sheet: Sheet1

Input data |  | Multiplier |  | output data
1 |  | 5 |  | 1 |  | after change value in multiplier table right click on the green table and select [NAME]
a |  |  |  | 1
test |  |  |  | 1
jkl |  |  |  | 1
wjklwl |  |  |  | 1
33 |  |  |  | a
502 |  |  |  | a
sdjkl |  |  |  | a
elkjl |  |  |  | a
[NAME] |  |  |  | a
 |  |  |  | test
 |  |  |  | test
 |  |  |  | test
 |  |  |  | test
 |  |  |  | test
 |  |  |  | jkl
 |  |  |  | jkl
 |  |  |  | jkl
 |  |  |  | jkl
 |  |  |  | jkl
 |  |  |  | wjklwl
 |  |  |  | wjklwl
 |  |  |  | wjklwl
 |  |  |  | wjklwl
 |  |  |  | wjklwl
 |  |  |  | 33
 |  |  |  | 33
 |  |  |  | 33
 |  |  |  | 33
 |  |  |  | 33
 |  |  |  | 502
 |  |  |  | 502
 |  |  |  | 502
 |  |  |  | 502
 |  |  |  | 502
 |  |  |  | sdjkl
 |  |  |  | sdjkl
 |  |  |  | sdjkl
 |  |  |  | sdjkl
 |  |  |  | sdjkl
 |  |  |  | elkjl
 |  |  |  | elkjl
 |  |  |  | elkjl
 |  |  |  | elkjl
 |  |  |  | elkjl
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
Spreadsheet: 862246d1709993751-determine-first-of-the-day-in-a-sequence-and-how-many-are-needed-to-become-good-example
Sheet: Sheet1

date | condition | # needed | first of day
2024-02-01 00:00:00 | bad
2024-02-01 00:00:00 | good | 1 | 1
2024-02-02 00:00:00 | bad
2024-02-02 00:00:00 | good | 1 | 1
2024-02-03 00:00:00 | good | 0 | 1
2024-02-04 00:00:00 | good | 1 | 1
2024-02-04 00:00:00 | bad
2024-02-04 00:00:00 | good | 1 | 1
2024-02-04 00:00:00 | good
2024-02-05 00:00:00 | bad | 1
2024-02-06 00:00:00 | bad | 1
2024-02-06 00:00:00 | bad | 2
2024-02-06 00:00:00 | good | 3 | 1
2024-02-07 00:00:00 | good | 1 | 1
2024-02-08 00:00:00 | bad | 1
2024-02-08 00:00:00 | good | 2 | 1
2024-02-09 00:00:00 | good | 1 | 1
2024-02-10 00:00:00 | good | 1 | 1
2024-02-11 00:00:00 | good | 1 | 1
2024-02-11 00:00:00 | good
2024-02-12 00:00:00 | good | 1 | 1
2024-02-13 00:00:00 | good | 1 | 1
2024-02-13 00:00:00 | good
2024-02-13 00:00:00 | bad
2024-02-13 00:00:00 | good
2024-02-14 00:00:00 | good | 1 | 1
2024-02-15 00:00:00 | good | 1 | 1
2024-02-16 00:00:00 | bad | 1
2024-02-16 00:00:00 | bad | 2
2024-02-16 00:00:00 | good | 3 | 1
2024-02-16 00:00:00 | bad
2024-02-17 00:00:00 | good | 1 | 1
Spreadsheet: 153226d1335808828-making-a-schedule-with-auto-time-format-and-adding-total-hours-se-schedule
Sheet: jan 30

 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
 | 2012-01-30 00:00:00 | 2012-01-31 00:00:00 | 2012-02-01 00:00:00 | 2012-02-02 00:00:00 | 2012-02-03 00:00:00 | 2012-02-04 00:00:00
[NAME] | off | 9:30-5:30 | 8:00-5:00 | 8:00-5:00 | 8:30-5:30 | 9:15-5:15
 |  | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 | 38
[NAME] | 8:30-5:30 | 8:30-5:30 | 9:30-5:30 | 8:30-5:30 | 9:30-5:30 | off
 | 2:00-3:00 | 2:00-3:00 | 2:00-3:00 | 2:00-3:00 | 2:00-3:00 |  | 38
Ray | 8:00-5:00 | 8:00-5:00 | 8:00-4:00 | 7:00-4:00 | 8:00-4:00 | off
 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 |  | 38
Mark | 8:00-5:00 | 9:00-4:00 | 8:30-5:30 | 8:30-5:30 | off | 9:00-5:00
 | 1:00-2:00 | 1:00-2:00 | 1:00-2:00 | 1:00-2:00 |  | 1:00-2:00 | 38
[NAME] | 8:30-5:30 | off | 8:30-5:30 | 7:00-4:00-HOMER | 9:00-5:00 | 9:15-5:15-ctr
ctr 12-2 | 11:00-12:00 | off | 11:00-12:00 | 1ub | 11:00-12:00 | 11:00-12:00 | 38
Kat |  |  | 8:00-5:00 |  |  | 9:15-5:15
 |  |  | 12:00-1:00 |  |  | 12:00-1:00
 |  |  | 12:00-1:00
 |  |  |  |  |  | total hours
Spreadsheet: 727906d1618207809-updating-an-existing-formula-to-add-new-logic-samptt1
Sheet: Sheet2

Available | CA | COM | D | REV | FOR | IP | HOLD1 | HOLD2 | HOLD1A | HOLD1B | HOLD3 | HOLD4 | HOLD1C | PA | TERM | SET | TYP | OVER | EXEC | D2B | CURRENT CALCUAATION | Expected Calculation
0 |  |  |  | 1.208333333333333 |  | 55.45833333333334 |  |  |  |  |  |  |  | 0.25 |  | Modified | Normal | Override | 0.2 | 28 |  |  | IN THIS EXAMPLE, G2 GT U2
3 |  |  |  | 0 |  | 16.25 |  |  |  | 205.7916666666667 |  |  |  |  |  | Modified | Normal | Override | 0.2 | 8 |  |  | IN THIS EXAMPLE, G3 GT U3
0 |  |  |  | 2.916666666666667 |  | 0.08333333333333333 |  |  | 11.20833333333333 |  |  |  |  |  |  | Modified | Set Delivery Date | Override | 0.2 |  |  |  | EXEPCTED OUTCOME
0.7916666666666666 |  |  |  | 0.04166666666666666 |  | 11 |  |  | 33 |  |  |  |  | 3.458333333333333 |  | New | Normal | Override | 0.2 | 24 |  |  | IN THIS EXAMPLE, G5 [NAME]
0.08333333333333333 |  |  |  | 25 |  | 75.75 |  |  | 3 | 5.916666666666667 |  |  |  |  |  | Modified | Set Delivery Date | 0 | 68.75 |  |  |  | EXEPCTED OUTCOME
0.2083333333333333 |  |  |  | 1.708333333333333 |  | 8.875 |  |  |  |  |  |  |  |  |  | Modified | Normal | 0 | 8.9 |  |  |  | EXEPCTED OUTCOME
Spreadsheet: 05fd17b9-1ca8-41b7-a7ab-4f6d7e529147
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
6518 | 50136 | Rita | [NAME] | GER | 145 | 00:18:48 | 00:01:31 | 01:21:15 | 00:00:56 | 00:45:25 | 1 | 02:27:59
6518 | 13015 | Sabine | Greipel | AUT | 144 | 00:18:54 | 00:01:33 | 01:28:34 | 00:01:07 | 00:47:43 | 2 | 02:37:55
Spreadsheet: 114041d1309909301-help-needed-with-function-percent-function
Sheet: Sheet1

 |  |  | Amount with |  | Check
 | Amount | Discount | Discount |  | Figure
 | 231
 | 13546
 | 5464
 | 132
 | 1000
 | 400
 | 4564
 | 123121
 | 564
 | 13215
 | 10000
Spreadsheet: 271291d1381896641-sum-with-blank-cell-that-has-if-formula-wip-calculator
Sheet: November

***Balance Sheet is the "holder" of the WIP number.  It should always match report total.
Period 11 | November | Work In Progress Report
 |  | A | B | C | D | E | F | G | H | J
 |  | Job ID | Contract price | Esimated Job Cost Expenses | Estimated GP% | Total Actual Job Cost to date | % of completion of each job in accounting | Earned Revenue | TOTAL Invoiced to Client to date | Over(-) or [NAME]) Status
 |  | Report Total
 |  | Once you have given your final invoice for a project, take the project off this report. |  |  |  |  |  | Report Status
 |  |  |  |  |  |  |  | Prior Period to adjust
Entries for BN Numbers
Period 11 | November |  |  | Enter the amount showing on line #3 of the appropriate 'Profit Center' in the 'Profit Center" tab.
 |  |  |  | Enter this amount on line #3 of the 'Balance Sheet' in the 'Financial Data" tab.
 |  |  |  | Enter this amount on line #13 of the 'Balance Sheet' in the 'Financial Data" tab.
Journal Entries for Accounting Software
Period 11 | November |  | Journal Entry      Dated November 30
 |  |  | G/L Account |  | Debit | Credit
 |  |  | WIP Income Acct
 |  |  | WIP Asset Acct
 |  |  | !!!REVERSE JOURNAL ENTRY!!!      Dated December 1
 |  |  | G/L Account |  | Debit | Credit
 |  |  | WIP Income Acct
 |  |  | WIP Asset Acct
 |  |  | Journal Entry      Dated November 30
 |  |  | G/L Account |  | Debit | Credit
 |  |  |  | WIP Income Acct
 |  |  |  | WIP Liability Acct
 |  |  | !!!REVERSE JOURNAL ENTRY!!!      Dated December 1
 |  |  | G/L Account |  | Debit | Credit
 |  |  |  | WIP Income Acct
 |  |  |  | WIP Liability Acct
Spreadsheet: 76623d1277164117-sorting-a-football-soccer-league-table-correct-football-season-2010-11
Sheet: PLAYERS

1 | PLAYER 1
2 | PLAYER 2
3 | PLAYER 3
4 | PLAYER 4
5 | PLAYER 5
6 | PLAYER 6
7 | PLAYER 7
8 | PLAYER 8
9 | PLAYER 9
10 | PLAYER 10
Spreadsheet: darrell_schoolcraft__7316__imball0202
Sheet: SoCal

 | 10487 |  | 56697
Day | Measured | Scheduled | Measured | Scheduled
1 | -612464 | -611587
2 | -602028 | -603119
3 | -605205 | -615801
4 | -600868 | -601843
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
2002-01-31 00:00:00 |  |  |  |  | 94012
2002-02-04 00:00:00
CBS Dollars
 |  |  | 310268
Spreadsheet: 811439d1672509511-cell-function-operation-inputted-from-another-cell-in-excel-excel_problem_funtionselection-v2
Sheet: Sheet1

Column | B | C | D |  |  | Min row | 6
Operation | AVERAGE | MIN | MAX | MIN |  | [NAME] row | 17
 |  |  |  | TYPE EITHER "AVERAGE", "MAX", OR "MIN" IN CELL E2
 | Measurement X
 | Temp(C) | Temp Low(C) | Temp High(C)
Jan | -2.873 | -18.7 | 5.5
Feb | -1.879 | -15 | 4.2
Mar | -0.006 | -11.2 | 12
Apr | 3.443 | -8.5 | 14.7
May | 9.389 | -1.6 | 22
Jun | 17.08 | 6.3 | 31.8
Jul | 17.844 | 9.4 | 30
Aug | 18.943 | 7 | 29.8
Sep | 9.609 | 2.3 | 17.9
Oct | 7.941 | -2.4 | 14.8
Nov | 2.661 | -5.1 | 13.3
Dec | -0.7 | -16.5 | 4.7
YEAR
Average
Min
[NAME]
Spreadsheet: 55702d1255884929-counting-occurences-of-values-relating-to-date-range-book1
Sheet: Raw Data

2009-10-18 00:00:00 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 10 | 11
 | x | x | x | x | x | x | x | x | 555 | x |  | every day the data in this sheet will be deleted and a new data pasted over it
 | x | x | x | x | x | x | x | x | 666 | x
 | x | x | x | x | x | x | x | x | 777 | x
 | x | x | x | x | x | x | x | x | 555 | x
 | x | x | x | x | x | x | x | x | 666 | x
 | x | x | x | x | x | x | x | x | 777 | x
 | x | x | x | x | x | x | x | x | 555 | x
 | x | x | x | x | x | x | x | x | 666 | x
 | x | x | x | x | x | x | x | x | 777 | x
 | x | x | x | x | x | x | x | x | 555 | x
 | x | x | x | x | x | x | x | x | 555 | x
 | x | x | x | x | x | x | x | x | 555 | x
 | x | x | x | x | x | x | x | x | 555 | x
 | x | x | x | x | x | x | x | x | 555 | x
 | x | x | x | x | x | x | x | x | 555 | x
 | x | x | x | x | x | x | x | x | 666 | x
 | x | x | x | x | x | x | x | x | x | x
 | x | x | x | x | x | x | x | x | 666 | x
 | x | x | x | x | x | x | x | x | 666 | x
 | x | x | x | x | x | x | x | x | 777 | x
 | x | x | x | x | x | x | x | x | 777 | x
 | x | x | x | x | x | x | x | x | 777 | x
 | x | x | x | x | x | x | x | x | 777 | x
 | x | x | x | x | x | x | x | x | 777 | x
Spreadsheet: 469113d1467766811-vacation-accrual-please-help-leave-register
Sheet: Employees

Employee | Start Date | Anniversary Date | Years Service | Months this year | Current Monthly Accrural Rate | [NAME] This Year | [NAME] this Year | Total Career Leave Accrued Prior to Anniversary Date | Total Career Leave Taken Prior to Anniversary Date | [NAME] | Balance |  |  |  | Days per year | 5 | 10 | 15
A | 2005-05-05 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | Days per Month
B | 2014-03-08 00:00:00
Spreadsheet: darrell_schoolcraft__7622__imball0201
Sheet: Amoco

 | Florida Plant
Day | Measured | Scheduled | Imbal
1 | 152595 | 150415
2 | 151711 | 150642
3 | 130476 | 128588
4 | 157869 | 157685
5 | 153621 | 153806
6 | 157371 | 156381
7 | 161938 | 164999
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-12-31 00:00:00 |  |  | -30210
2002-01-07 00:00:00
CBS Dollars
 |  |  | 272582 |  |  |  | 12
 |  |  |  |  |  |  | 500
 |  |  |  |  |  |  | 5895
Spreadsheet: 216339d1361726389-zero-values-returned-in-formulas-staff-timesheet-current
Sheet: Pay Week 1

 | W / E :
[NAME] STAFF HOURS |  |  |  |  |  |  |  |  |  |  |  |  |  | Over/Under Time |  | AGENCY HOURS
NAME | MON | TUES | WEDS | THURS | FRI | SAT | TOTAL |  |  |  |  |  |  |  |  | NAME | MON | TUES | WEDS | THURS | FRI | SAT |  |  |  |  |  |  | TOTAL
Dawson 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dawson 1
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dawson 2
ANDRZEJ KOSTRZEWA
SLAWOMIR SRUTEK |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dawson 3
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Piotr Cuczma
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Dawson 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Piotr Forys
ARKADIUSZ MIELNIK
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
NIKOLAJS LOSAKS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
FRYDERYK AGATOWSKI
Dawson 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fridge
LUKASZ KAZMAREK |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dhitriyus Lucanovas
MARIUSZ CEMPA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pergals
ROBBIE HOPLEY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
LUKASZ SKOCZYLAS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Lab
Wrapper |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
ROMAN JARMOLA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Agency Hours
[NAME]
[NAME]
KRZYSZTOF KOBIERSKI
KRYSTOF WIRASZKA
[NAME]
LESZEK JASINSKI
DARREN READ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KEY
PATRYCJUSZ DOROBISZ
Fridge |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SICK | S
ARTURAS MICHINICIUS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HOLIDAY | H
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | UNPAYED LEAVE | U/P
Pergal Machine |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DAY OFF | D/O
MAREK FORYS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TIME OWED | T/O
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SUSPENSION | SUS
Pasteriser |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NOT APPLICABLE | N/A
TOMASZ KRYGIER
PATRYK PACHNIK
CIP Operative
[NAME] DIXON
Lab
PHILIP MITCHELL
Production Support Team
BRETT BOYCE
[NAME]
BOGUSLAW SWIST
MAREK KUROVSKI
Management
KARL FELLBRICH
STUART BEATTIE
[NAME]
 |  |  |  |  |  | Total Overtime
 |  |  |  |  |  |  |  |  | CALL OUTS £120.00
Spreadsheet: 36b4807f-b2cc-4aa6-81ed-15b4bd915fb7
Sheet: 2009-10

Table F
Student Numbers by [NAME] and Method of Study
2009-10
 | Full Time |  |  | Part Time |  |  | Total
 | Male | Female | Total | Male | Female | Total | Male | Female | Total
Undergraduate | 6066 | 6691 |  | 175 | 100
%
Graduate | 3036 | 3701 |  | 1405 | 1454
%
Total
Spreadsheet: 803080d1667239406-count-of-cell-with-same-text-with-a-group-in-column-invoice-allocation-demo
Sheet: Weekly Work Schedule

Active Jobs
22002
22004
22009
22019
22031
22055
22062
22068
22070
22073
22074
22075
22078
22080
22083
22084
22087
22088
22089
22090
22091
22092
22093
22094
22095
22097
22098
22099
22100
22102
22105
22109
22111
22113
22114
22115
22108
11111
22001
22030
22066
22096
22116
22117
22118
22119
22120
22122
Spreadsheet: 465000d1465402047-12-month-and-quarterly-updated-mean-excel-help-12-month-and-quarterly-rolling-data-ndm
Sheet: Sheet2

Years | Quarters | Month/Year | DLQOR 1Q16 #1 | DLQOR 1Q16 #2 | Quarterly Average | Quarterly Total | Rolling Yearly Average
2015 | Qtr2 | Apr | 0.22 | 0.81 |  | 1.03
 |  | May | 1.22 | 0.61 |  | 1.83
 |  | Jun | 0.38 | 1.49 | 0.7883333333333332 | 1.87
 | Qtr2 Total |  | 1.82 | 2.91 | 0.7883333333333332 | 4.73
 | Qtr3 | Jul | 1.4 | 0.26 |  | 1.66
 |  | Aug | 0.45 | 0.64 |  | 1.09
 |  | Sep | 1.49 | 0.45 | 0.7816666666666667 | 1.94
 | Qtr3 Total |  | 3.34 | 1.35 | 0.7816666666666667 | 4.69
 | Qtr4 | Oct | 0.94 | 1.01 |  | 1.95
 |  | Nov | 0.4 | 0.52 |  | 0.92
 |  | Dec | 0.79 | 0.95 | 0.7683333333333334 | 1.74
 | Qtr4 Total |  | 2.13 | 2.48 | 0.7683333333333334 | 4.609999999999999
2015 Total |  |  | 7.29 | 6.739999999999999 | 0.7794444444444445 | 14.03
2016 | Qtr1 | Jan | 0.57 | 0.44 |  | 1.01
 |  | Feb | 0.56 | 0.92 |  | 1.48
 |  | Mar | 0.64 | 0.81 | 0.6566666666666667 | 1.45
 | Qtr1 Total |  | 1.77 | 2.17 | 0.6566666666666667 | 3.94
 | Qtr2 | Apr | 0.68 | 1.23 |  | 1.91
 |  | May | 0.46 | 1.05 |  | 1.51 | 0.7830769230769229
 |  | Jun |  |  | 0.855 | 0 | 0.7720833333333333
 | Qtr2 Total |  | 1.14 | 2.28 | 0.855 | 3.42 | 1.555160256410256
2016 Total |  |  | 2.91 | 4.45 | 0.7558333333333334 | 7.36 | 1.555160256410256
Grand Total |  |  | 10.2 | 11.19 | 0.77 | 21.39 | 1.555160256410256
Spreadsheet: 222673d1363903872-how-to-use-colour-indication-manishpal
Sheet: Sheet1

23 | as | in
25 | ad | out
26 | ae | out
27 | af | in
Spreadsheet: 827356d1682623506-extract-and-filter-sample-sheet
Sheet: Raw Data

Call Date | Agent Calling | Super Saver | French PT Pilot | [NAME]
2023-04-03 00:00:00 | Kurt | No | No | Wi-Fi Password Issue
2023-04-03 00:00:00 | [NAME] | No | No | Balance / Charge Inquiry
2023-04-03 00:00:00 | [NAME] | No | No | Service Credit
2023-04-03 00:00:00 | Amanda | No | No | Service Reliability
2023-04-03 00:00:00 | [NAME] | No | No | Balance / Charge Inquiry
2023-04-03 00:00:00 | Jessica | No | No | Package Pricing
2023-04-03 00:00:00 | Amanda | No | No | Balance / Charge Inquiry
2023-04-03 00:00:00 | [NAME] | No | No | Speed
2023-04-03 00:00:00 | [NAME] | No | No | Signal Issue
2023-04-03 00:00:00 | Jessica | No | No | Service Reliability
2023-04-03 00:00:00 | [NAME] | No | No | Signal Issue
2023-04-03 00:00:00 | Amanda | No | No | Service Credit
2023-04-03 00:00:00 | Amanda | No | No | Seasonal Location
2023-04-03 00:00:00 | [NAME] | No | No | Username / Password Related
2023-04-03 00:00:00 | Jessica | No | No | Service Credit
2023-04-03 00:00:00 | [NAME] | No | No | Limited State
2023-04-03 00:00:00 | Amanda | No | No | Service Reliability
2023-04-03 00:00:00 | Amanda | No | No | Account in Arrears
2023-04-03 00:00:00 | Amanda | No | No | Equipment Recovery
2023-04-03 00:00:00 | Jessica | No | No | Usage Threshold Notification
2023-04-03 00:00:00 | Amanda | No | No | Status Inquiry
2023-04-03 00:00:00 | [NAME] | No | No | Hardware Credit
2023-04-03 00:00:00 | Kurt | No | No | Feature Issue
2023-04-03 00:00:00 | [NAME] | No | No | Equipment
2023-04-03 00:00:00 | Jessica | No | No | Contact Information
2023-04-03 00:00:00 | Amanda | No | No | New Physical Location
2023-04-03 00:00:00 | [NAME] | No | No | Seasonal Location
2023-04-03 00:00:00 | Kurt | No | No | Network Outage / Degradation
2023-04-03 00:00:00 | [NAME] | No | No | Equipment not Registered
2023-04-03 00:00:00 | [NAME] | No | No | Service Credit
2023-04-03 00:00:00 | [NAME] | No | No | Work Order Credit
2023-04-03 00:00:00 | [NAME] | No | No | Wi-Fi Password Issue
2023-04-04 00:00:00 | [NAME] | No | No | Service Reliability
2023-04-04 00:00:00 | Kurt | No | No | 3rd Party Router Issue
2023-04-04 00:00:00 | [NAME] | No | No | Package Pricing
2023-04-04 00:00:00 | [NAME] | No | No | Package Pricing
2023-04-04 00:00:00 | Kurt | No | No | Customer Expectations
2023-04-04 00:00:00 | [NAME] | No | No | Package Pricing
2023-04-04 00:00:00 | Kurt | No | No | New Offer Available
2023-04-04 00:00:00 | Amanda | No | No | Contact Information
2023-04-04 00:00:00 | Amanda | No | No | Transfer Status Inquiry
2023-04-04 00:00:00 | [NAME] | No | No | Username / Password Related
2023-04-04 00:00:00 | [NAME] | No | No | Usage Threshold Notification
2023-04-04 00:00:00 | Jessica | No | No | Refund Request
2023-04-04 00:00:00 | [NAME] | No | No | Service Credit
2023-04-04 00:00:00 | Jessica | No | No | Equipment Recovery
2023-04-04 00:00:00 | Jessica | No | No | Add / Update PAD Information
2023-04-04 00:00:00 | Amanda | No | No | Balance / Charge Inquiry
Spreadsheet: 855477d1705029345-drop-down-reference-to-different-sheet-cells-jmorales22-weekly-recap
Sheet: Sheet1

 | Week 1 | Period | Quarter | YTD
Sales |  |  | 207139 | 207139
Traffic |  |  | 19769 | 19769
SRC |  |  | 0.082 | 0.082
Manager [NAME] |  |  | 20.76 | 20.76
[NAME] |  |  | 30.16 | 30.16
Speed of Service
Drive Thru |  |  |  | 01:44:00
Front Counter |  |  |  | 01:54:00
OSATS
Overall Satisfaction |  |  | 0.815 | 0.815
Mystery Shop |  |  | 1 | 1
Waste |  |  |  | 1.3
Labor
Spreadsheet: 2149bd30-35da-4fe0-8b10-7309cacdd6f4
Sheet: Polypay

Marker1 | Marker2 | D' | r^2
OAR1_185953850 | OAR1_186779231 | 0.65 | 0.4
OAR13_26084492 | OAR13_56607666 | 0.058 | 0.002
OAR15_78598295 | s31340 | 1 | 0.695
OAR17_5388531 | s19031 | 1 | 0.065
OAR18_5646940 | OAR18_5701234 | 1 | 0.986
OAR18_5646940 | OAR18_9395406 | 0.046 | 0.001
OAR18_5701234 | OAR18_9395406 | 0.061 | 0.001
OAR20_19572554 | s65956 | 0.215 | 0.008
DU231007_156 | OAR3_108176200 | 0.331 | 0.006
DU231007_156 | OAR3_144283427 | 0.216 | 0.036
DU231007_156 | OAR3_144414855 | 0.216 | 0.036
DU231007_156 | s23946 | 0.331 | 0.059
OAR3_108176200 | OAR3_144283427 | 0.176 | 0.003
OAR3_108176200 | OAR3_144414855 | 0.176 | 0.003
OAR3_108176200 | s23946 | 0.914 | 0.089
OAR3_144283427 | OAR3_144414855 | 1 | 1
s23946 | OAR3_144283427 | 0.09 | 0.003
s23946 | OAR3_144414855 | 0.09 | 0.003
OAR5_93280925 | OAR5_94009731 | 0.055 | 0.001
s27054 | OAR5_93280925 | 0.274 | 0.015
s27054 | OAR5_94009731 | 0.092 | 0.008
OAR8_73555614 | OAR8_88021348 | 0.07 | 0.003
s27979 | OAR8_73555614 | 0.093 | 0.007
s27979 | OAR8_88021348 | 0.335 | 0.025
OAR9_10735564 | OAR9_10749779 | 1 | 0.846
OAR9_10735564 | OAR9_35880400 | 0.053 | 0.001
OAR9_10735564 | s48118 | 0.78 | 0.582
OAR9_10749779 | OAR9_35880400 | 0.024 | 0
OAR9_10749779 | s48118 | 0.765 | 0.517
s48118 | OAR9_35880400 | 0.017 | 0