tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 772448d1647278148-recent-date-recent-location-date-location
Sheet: Sheet1

Input
Entiry | Date | Location
1 | 2022-01-01 00:00:00 | Location1
1 | 2022-01-02 00:00:00 | Location2
2 | 2022-02-05 00:00:00 | Location1 |  |  |  | Max of Date
2 | 2022-02-05 00:00:00 | Location2 |  |  |  | Entiry | Date | Location | Total
2 | 2022-02-06 00:00:00 | Location1 |  |  |  | 1 | 02-Jan | Location2 | 44563
3 | 2022-02-02 00:00:00 | Location1 |  |  |  | 2 | 06-Feb | Location1 | 44598
3 | 2022-02-03 00:00:00 | Location2 |  |  |  | 3 | 06-Feb | Location5 | 44598
3 | 2022-02-04 00:00:00 | Location3
3 | 2022-02-05 00:00:00 | Location4
3 | 2022-02-06 00:00:00 | Location5
Desired Output
Entity | Last Date | Last Location
1 | 2022-01-02 00:00:00 | Location2
2 | 2022-02-06 00:00:00 | Location1
3 | 2022-02-06 00:00:00 | Location5
Spreadsheet: 6881a325-9835-4564-838b-06b79653c6bb
Sheet: Sheet1

Definitions | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Percentages are the percentages of the population of each given country or group of countries.
Individuals are classified as being in the "Embryonic", "New Business" or "Established Business" phases of entrepreneurship.
The categories are separated as follows:
Embryonic | The individual is taking the necessary steps to start up a business.
New Business | The individual is running a business less than 3 years old.
Established Business | The individual is running a business 3 years old or older.
Total Entrepreneurial Activity is the sum of these three categories.
Sources
Data are from a series of surveys conducted by The Gallup Organization.  Data and definitions are given in
the Flash Eurobarometer Reports, available at: http://ec.europa.eu/public_opinion/archives/flash_arch_en.htm |  |  | http://ec.europa.eu/public_opinion/archives/flash_arch_en.htm
Year | Report #'s
2009 | 283
2007 | 192
2004 | 160
Spreadsheet: 755735d1637067755-formatting-data-of-an-auto-populating-calendar-workbook-metal-production-calendar
Sheet: Calendar

 |  |  | Metal Production
 | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
1 |  |  |  |  |  |  |  |  | Month | 11 |  | <== Enter MONTH - 1 to 12
2 |  |  |  |  |  |  |  |  | Year | 2021 |  | <== Enter YEAR - 2018 to 2030
3
4
5
6
7
8
9
10
 |  |  |  |  |  |  |  |  |  | KEY:
1 |  |  |  |  |  |  |  |  |  | Alonzo
2 |  |  |  |  |  |  |  |  |  | Chepe C
3 |  |  |  |  |  |  |  |  |  | [NAME]
4 |  |  |  |  |  |  |  |  |  | [NAME]
5 |  |  |  |  |  |  |  |  |  | [NAME]
6 |  |  |  |  |  |  |  |  |  | Merlin
7 |  |  |  |  |  |  |  |  |  | [NAME]
8 |  |  |  |  |  |  |  |  |  | Walter
9 |  |  |  |  |  |  |  |  |  | Sub
10
1
2
3
4
5
6
7
8
9
10
1
2
3
4
5
6
7
8
9
10
1
2
3
4
5
6
7
8
9
10
1
2
3
4
5
6
7
8
9
10
Spreadsheet: 463203d1464352920-overtime-calculations-for-specific-start-times-overtime-for-specific-start-time
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  | Rate
 | Day | Start | Finish | Total Hours | [NAME] | Net Hours | 1.5 | 2 | 1 | 1.5 | 2 | Total | 10 |  |  | OT1 | 00:00:00 | 06:00:00
 | 2016-05-17 00:00:00 | 3:00:00 | 19:00:00 |  | 00:30:00 |  |  |  |  |  |  |  |  |  |  | OT2 | 06:00:00 | 07:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Reg | 07:00:00 | 23:59:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Normal | 07:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Over Normal | 03:00:00
Spreadsheet: louise_kitchen__24097__NEWCO HEADCOUNT NAMES1
Sheet: Portland Fundies & Structuring

Portland Fundamentals & Structuring |  |  | ok
[NAME] | Kourtney | Fundies | Analyst | 1 | 15000
[NAME] | [NAME] | Fundies | Analyst |  | 5000
Elafandi | Mo | Structuring | Associate | 1 | 20000
Heizenrader | [NAME] | Fundies | Director | 1
Swain | [NAME] | Fundies | Manager |  | 75000
[NAME] | Todd | Structuring |  |  | 30000
[NAME] | Julie | Fundies | Spec | 1 | 10000
[NAME] | [NAME] | Fundies | Sr. Spec |  | 10000
Van Houten | Maria | Fundies | Sr. Spec | 2 | 13000
Seaton | [NAME] | Fundies |  |  |  |  | contractor
 |  |  | TOTAL | 8 | Fundies |  | 7
 |  |  |  |  | Structuring |  | 2
Spreadsheet: 725685d1616791240-help-on-adjusting-excel-formula-to-calculate-more-date-sales-ledger-2021bb-jt
Sheet: TXs

 | Date | Txs | Student Number | Student Name | Receipt Number | Invoice Number | Amount | Notes
 | 2020-01-01 00:00:00 | Opening Balance | ST 001 | [NAME] |  | C001 | 400
 | 2020-01-10 00:00:00 | Student Invoice | ST 001 | [NAME] |  | 0001 | 2000
 | 2020-01-11 00:00:00 | Student Invoice | ST 002 | [NAME] |  | 2 | 2000
 | 2020-01-12 00:00:00 | Cash Received | ST 001 | [NAME] | R010 | C001 | 300
 | 2020-01-12 00:00:00 | Student Invoice | ST 003 | [NAME] |  | 3 | 2000
 | 2020-01-13 00:00:00 | Cash Received | ST 002 | [NAME] | R011 | 2 | 2000
 | 2020-01-13 00:00:00 | Student Invoice | ST 004 | O'Neil James |  | 4 | 2000
 | 2020-01-14 00:00:00 | Cash Received | ST 001 | [NAME] | R012 | 0001 | 1000
 | 2020-01-19 00:00:00 | Cash Received | ST 003 | [NAME] | R013 | 3 | 1500
 | 2020-01-20 00:00:00 | Cash Received | ST 004 | O'Neil James | R014 | 4 | 2000
 | 2020-05-12 00:00:00 | Student Invoice | ST 001 | [NAME] |  | 0001 | 2300
 | 2020-05-13 00:00:00 | Student Invoice | ST 002 | [NAME] |  | 6 | 2300
 | 2020-05-14 00:00:00 | Student Invoice | ST 003 | [NAME] |  | 7 | 2300
 | 2020-05-15 00:00:00 | Student Invoice | ST 004 | O'Neil James |  | 8 | 2300
 | 2020-09-09 00:00:00 | Student Invoice | ST 001 | [NAME] |  | 0005 | 2500
 | 2020-09-10 00:00:00 | Student Invoice | ST 002 | [NAME] |  | 10 | 2500
 | 2020-09-11 00:00:00 | Student Invoice | ST 003 | [NAME] |  | 11 | 2500
 | 2020-09-12 00:00:00 | Student Invoice | ST 004 | O'Neil James |  | 12 | 2500
Spreadsheet: 172993d1344404412-sum-total-including-cells-with-a-value-of-greater-or-less-than-a-number-example-excel-help
Sheet: Sheet1

Total number of Fruits | Apples | % | Oranges | % | Bananas | % | [NAME] | % | Strawberries | % | Mangoes | % | Kiwis | %
 | 1215 |  | 780 |  | 95 |  | <10 |  | 90 |  | 38 |  | 27
 | 1022 |  | 659 |  | 79 |  | 12 |  | 58 |  | 27 |  | 25
 | 568 |  | 285 |  | 12 |  | <10 |  | 23 |  | <10 |  | 11
 | 633 |  | 264 |  | 48 |  | <10 |  | 36 |  | 11 |  | 19
 | 282 |  | 136 |  | 34 |  | 19 |  | 30 |  | 19 |  | <10
 | 16 |  | <10 |  | <10 |  | <10 |  | <10 |  | <10 |  | <10
 | 186 |  | 106 |  | 52 |  | 20 |  | 15 |  | 16 |  | <10
 | 403 |  | 186 |  | <10 |  | <10 |  | 38 |  | <10 |  | 11
 | 82 |  | 26 |  | <10 |  | <10 |  | <10 |  | <10 |  | <10
 | 601 |  | 315 |  | 79 |  | 13 |  | 42 |  | 17 |  | 12
 | 201 |  | 166 |  | 23 |  | <10 |  | 14 |  | 12 |  | <10
 | 389 |  | 316 |  | 58 |  | <10 |  | 32 |  | <10 |  | <10
 | 256 |  | 225 |  | 50 |  | 14 |  | 18 |  | 16 |  | 11
 | 439 |  | 507 |  | 78 |  | <10 |  | 43 |  | <10 |  | <10
 | 298 |  | 212 |  | 42 |  | 14 |  | 18 |  | 15 |  | <10
 | 132 |  | 89 |  | <10 |  | <10 |  | 10 |  | <10 |  | 19
Spreadsheet: 165123d1341033336-lookup-function-create-flags-example
Sheet: Sheet2

 |  |  | Choosen Week + subsequent 4 weeks should be flagged 1
 |  |  | Example 1 |  |  |  |  |  | Example 2
 |  |  | Choose Week # | 2 |  |  |  |  | Choose Week # | 4
 |  |  | Table |  |  |  |  |  | Table
 |  |  | Week # | Flag |  |  |  |  | Week # | Flag
 |  |  | 1 | 0 |  |  |  |  | 1 | 0
 |  |  | 2 | 1 |  |  |  |  | 2 | 0
 |  |  | 3 | 1 |  |  |  |  | 3 | 0
 |  |  | 4 | 1 |  |  |  |  | 4 | 1
 |  |  | 5 | 1 |  |  |  |  | 5 | 1
 |  |  | 6 | 1 |  |  |  |  | 6 | 1
 |  |  | 7 | 0 |  |  |  |  | 7 | 1
 |  |  | 8 | 0 |  |  |  |  | 8 | 1
 |  |  | 9 | 0 |  |  |  |  | 9 | 0
 |  |  | 10 | 0 |  |  |  |  | 10 | 0
Spreadsheet: 685197d1593799737-what-is-purpose-of-the-0-in-this-formula-practice-vlookup
Sheet: Sheet1

Code | Original Formula | Without Text function | Alternate approach
710000
710001
710002
710003
710004
710005
710006
710007
710008
710009
710010
710011
710012
710013
710014
710015
710016
710017
710018
Spreadsheet: 853182d1703092858-newish-to-excel-need-a-little-help-truck-updates-send-
Sheet: UP-DOWN

LOGO |  |  |  |  |  |  |  | Fuel Truck Updates
1 |  | 2 |  | 2A |  | 2B |  | 2C |  | 2E |  | 3 |  | 4
UP |  | UP |  | UP |  | UP |  | UP |  | DOWN |  | UP |  | UP
4A |  | 5A |  | 6 |  | 6A |  | 7 |  | 7A |  | 8 |  | 9
UP |  | UP |  | DOWN |  | DOWN |  | UP |  | UP |  | UP |  | UP
10 |  | 12
DOWN |  | DOWN |  |  | UP
 |  |  |  |  | DOWN
Tank 1 |  | Tank 2 |  | Tank 3 |  | Tank 4 |  | Tank 5 |  | Tank 6 |  | Tank 7
UP |  | UP |  | UP |  | UP |  | DOWN |  | UP |  | UP
Spreadsheet: 536e629f-bce6-42e3-9d8c-04de62c9e7f7
Sheet: February

FEDERAL COLLEGE WORK-STUDY PROGRAM
MASTER SHEET FOR STUDENT WORK HOURS
NAME |  |  |  |  |  |  |  | ASU ID #
PAY PERIOD BEGINNING |  |  | 2013-02-01 00:00:00 |  |  |  |  | PAY PERIOD ENDING |  |  | 2013-02-28 00:00:00
HOURLY RATE |  |  | 7.25 |  | TOTAL Hours |  |  |  |  | DEPARTMENT
TIME
WORKED | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16
IN
OUT
IN
OUT
IN
OUT
TOTAL
TIME
WORKED | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 |  |  | 31
IN
OUT
IN
OUT
IN
OUT
TOTAL
Student's Signature
Supervisor's Name (Print) |  |  |  |  |  |  |  |  |  | [NAME]'s Signature
Department Head's  Name (Print) |  |  |  |  |  |  |  |  |  | Department Head's Signature
Note:  This Master [NAME] should reflect the time and hours the student actually worked.  The total hours per day should reflect in the total column.
Students are not authorized to work no more than 20 hours per week.  No EXCEPTIONS!!!
Spreadsheet: 80783d1280979932-programming-a-cell-to-automatically-expand-when-required-expanded
Sheet: Formula

Last Name: | Initial: | Employee Number: |  |  |  |  | SCHEDULE | TRAINING DAY
g | f | 3 |  |  |  |  | AD | MANDATORY TRAINING
 |  |  |  |  |  |  | AL | MEETING
 |  |  |  |  |  |  | AP | S/T - DAY FOR DAY
 |  |  |  |  |  |  | AT | S/T - SHIFT FOR SHIFT
 |  |  |  |  |  |  | AY | TIME FOR TIME
 |  |  |  |  |  |  | BP | UNCERTIFIED SICK - 210
 |  |  |  |  |  |  | CB | CERTIFIED SICK - 220
 |  |  |  |  |  |  | CM | VACATION - 110
 |  |  |  |  |  |  | CO | VACATION PAID OUT - 115
 |  |  |  |  |  |  | CR | [NAME]
 |  |  |  |  |  |  | DA | LIEU TAKEN - 851
 |  |  |  |  |  |  | DC | LIEU PAID OUT - 855
 |  |  |  |  |  |  | DS | COMP EARNED - 899
 |  |  |  |  |  |  | EM | COMP TAKEN - 810
 |  |  |  |  |  |  | EW | COMP PAID OUT - 815
 |  |  |  |  |  |  | FG | FRR FOR SELF - 400
 |  |  |  |  |  |  | HF | FRR FOR FAMILY - 410
 |  |  |  |  |  |  | IM | O/T DAY SHIFT ON FIRST RDO
 |  |  |  |  |  |  | [NAME] | O/T EVES SHIFT ON FIRST RDO
 |  |  |  |  |  |  | JJ | O/T MIDS SHIFT ON FIRST RDO
 |  |  |  |  |  |  | JL | O/T DAY SHIFT ON SECOND RDO
 |  |  |  |  |  |  | JM | O/T EVES SHIFT ON SECOND RDO
 |  |  |  |  |  |  | JV | O/T MIDS SHIFT ON SECOND RDO
 |  |  |  |  |  |  | KB | O/T DAY SHIFT ON THIRD RDO
 |  |  |  |  |  |  | KG | O/T EVES SHIFT ON THIRD RDO
 |  |  |  |  |  |  | LC | O/T MIDS SHIFT ON THIRD RDO
 |  |  |  |  |  |  | MC | O/T DOUBLE ON FIRST RDO
 |  |  |  |  |  |  | ME | O/T DOUBLE ON SECOND RDO
 |  |  |  |  |  |  | MI | O/T DOUBLE ON THIRD RDO
 |  |  |  |  |  |  | NT | BANK O/T DAY SHIFT - COMP 899
 |  |  |  |  |  |  | RA | BANK O/T EVES SHIFT - COMP 899
 |  |  |  |  |  |  | RK | BANK O/T MIDS SHIFT - COMP 899
 |  |  |  |  |  |  | SC | BANK O/T DOUBLE - COMP 899
 |  |  |  |  |  |  | SM | STAT HOLIDAY PAY OUT
 |  |  |  |  |  |  | SR | DAY FOR DAY - NO STAT ENTITLEMENT
 |  |  |  |  |  |  | TG | BANK STAT HOLIDAY 8.25 - LIEU 800 (4 hrs @ 1.5x & 0.12 @ 2.0x & 4.13 [NAME] 2.0) = 8.25 hrs
 |  |  |  |  |  |  | TL | BANK STAT HOLIDAY 9.75 - LIEU 800 (4 hrs @ 1.5x & 0.87 @ 2.0x & 4.88 [NAME] 2.0) = 9.75 hrs
 |  |  |  |  |  |  | TO | BANK STAT HOLIDAY - LIEU 800 (4 hrs @ 1.5x & 1.62 @ 2.0x & 4.13 [NAME] 2.0) = 8.25 from 9.75 hrs
 |  |  |  |  |  |  | TR | BEREAVEMENT - 510
 |  |  |  |  |  |  | TS | MARRIAGE LEAVE - 450
Spreadsheet: 115521d1311101601-help-to-create-matrix-table-book21-players
Sheet: Sheet4

G F T | B I J | A U D | O S L | Q H K | P R M | N E C | G F T |  | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U
K I U | T M H | S C B | J R L | A Q E | F P N | D O G | K I U | A
H I R | L B D | T O P | U G Q | K A C | S J N | E F M | H I R | B
A N M | E L P | S T D | G C R | U J H | I F Q | B K O | A N M | C
I P A | L U T | C O M | H B F | Q R S | J D E | N K G | I P A | D
E H G | I D C | O N R | M S U | T A J | K F L | Q B P | E H G | E
M L I | Q C T | F U O | D N H | R A B | P J G | K E S | M L I | F
C L H | E U R | N T I | D P K | F A S | O Q J | M G B | C L H | G
C P U | B T E | H O A | G S I | J M K | R D F | L Q N | C P U | H
R K T | D M Q | C J F | L G A | P H S | I E O | U N B | R K T | I
 |  |  |  |  |  |  | B I J | J
 |  |  |  |  |  |  | T M H | K
 |  |  |  |  |  |  | L B D | L
 |  |  |  |  |  |  | E L P | M
 |  |  |  |  |  |  | L U T | N
 |  |  |  |  |  |  | I D C | O
 |  |  |  |  |  |  | Q C T | P
 |  |  |  |  |  |  | E U R | Q
 |  |  |  |  |  |  | B T E | R
 |  |  |  |  |  |  | D M Q | S
 |  |  |  |  |  |  | A U D | T
 |  |  |  |  |  |  | S C B | U
 |  |  |  |  |  |  | T O P
 |  |  |  |  |  |  | S T D
 |  |  |  |  |  |  | C O M
 |  |  |  |  |  |  | O N R
 |  |  |  |  |  |  | F U O
 |  |  |  |  |  |  | N T I
 |  |  |  |  |  |  | H O A
 |  |  |  |  |  |  | C J F
 |  |  |  |  |  |  | O S L
 |  |  |  |  |  |  | J R L
 |  |  |  |  |  |  | U G Q
 |  |  |  |  |  |  | G C R
 |  |  |  |  |  |  | H B F
 |  |  |  |  |  |  | M S U
 |  |  |  |  |  |  | D N H
 |  |  |  |  |  |  | D P K
 |  |  |  |  |  |  | G S I
 |  |  |  |  |  |  | L G A
 |  |  |  |  |  |  | Q H K
 |  |  |  |  |  |  | A Q E
 |  |  |  |  |  |  | K A C
 |  |  |  |  |  |  | U J H
 |  |  |  |  |  |  | Q R S
 |  |  |  |  |  |  | T A J
 |  |  |  |  |  |  | R A B
 |  |  |  |  |  |  | F A S
 |  |  |  |  |  |  | J M K
 |  |  |  |  |  |  | P H S
 |  |  |  |  |  |  | P R M
 |  |  |  |  |  |  | F P N
 |  |  |  |  |  |  | S J N
 |  |  |  |  |  |  | I F Q
 |  |  |  |  |  |  | J D E
 |  |  |  |  |  |  | K F L
 |  |  |  |  |  |  | P J G
 |  |  |  |  |  |  | O Q J
 |  |  |  |  |  |  | R D F
 |  |  |  |  |  |  | I E O
 |  |  |  |  |  |  | N E C
 |  |  |  |  |  |  | D O G
 |  |  |  |  |  |  | E F M
 |  |  |  |  |  |  | B K O
 |  |  |  |  |  |  | N K G
 |  |  |  |  |  |  | Q B P
 |  |  |  |  |  |  | K E S
 |  |  |  |  |  |  | M G B
 |  |  |  |  |  |  | L Q N
 |  |  |  |  |  |  | U N B
Spreadsheet: 785995d1656917798-sum-of-cells-in-adjacent-columns-fantasy
Sheet: Sheet1

OGUNBOWALE | 31.5
YOUNG | 30.3
SMITH | 24.9
HAMBY | 25.9
FOWLES | 30.6
MAGBEGOR | 27.5
JONES | 31.9
HOWARD | 29.4
[NAME] | 28.3
CLOUD | 26
JEFFERSON | 25.1
OGWUMIKE | 32.6 | X
THOMAS | 29.8
POWERS | 24.1
PLUM | 35
SMITH | 35 | X
DeSHIELDS | 24.3 | X
SAMUELSON | 19 | X
Spreadsheet: 70745d1271432787-display-data-in-a-calendar-seedtrial
Sheet: Sheet1

plot | activity | date |  |  |  |  | plot\date | 2010-01-01 00:00:00 | 2010-01-02 00:00:00 | 2010-01-03 00:00:00 | 2010-01-04 00:00:00 | 2010-01-05 00:00:00 | 2010-01-06 00:00:00 | 2010-01-07 00:00:00 | 2010-01-08 00:00:00 | 2010-01-09 00:00:00 | 2010-01-10 00:00:00
1 | sow | 2010-01-01 00:00:00 |  |  |  |  | 1
1 | treat | 2010-01-03 00:00:00 |  |  |  |  | 2
1 | harvest | 2010-01-09 00:00:00 |  |  |  |  | 3
2 | sow | 2010-01-01 00:00:00 |  |  |  |  | 4
2 | treat | 2010-01-04 00:00:00
2 | harvest | 2010-01-10 00:00:00
3 | sow | 2010-01-01 00:00:00
3 | A | 2010-01-04 00:00:00
3 | B | 2010-01-04 00:00:00
3 | Harvest | 2010-01-08 00:00:00
Spreadsheet: 159421d1338631133-excel-cell-search-using-a-cell-book4-spursrule68-
Sheet: Sheet1

lam
gkp
[NAME]
talv |  |  |  | rnk | #N/A
rnk | rnk | 1
[NAME]
emg
egu
fxpo |  |  |  | rnk | #N/A
rto
shi
rrl |  |  | OELDERE | mk | go to cell | F12 contains A16
rrr
[NAME]
mk
 |  |  |  | [NAME]
 |  |  |  | [NAME]
Spreadsheet: 104753d1302213085-finding-pv-spreadsheet-3-day92
Sheet: Sheet1

size of issuie | 100000000 | NPV
old bond coupon rate | 0.15
orig old flotation cost | 4000000
orig maturity of old issue | 20
years remaining on old bond | 15
tax rate | 0.4
Proposed replacement bond issue:
new bond coupon rate | 0.125
new issue flotation cost | 6000000
maturity of new issue | 15
call premium percentage | 0.1
Coupon rate ST Govt Securities | 0.09
Cost of refunding at t=0 | Amount before tax | amount after tax | present value
call premium on old issue
flotation cost on new issue
tax savings on old float exp
extra interest cost old issue
interest earned ST investment
net investment outlay
After tax flotation cost effects:
flotation cost on new issue
tax benefit lost on old float
net flotation cost effects
Interest savings due to refunding:
 | pre tax | after tax
annual payment (old bond)
annual payment (new bond)
net annual savings and PV of int savings:
NPV of the refunding decisions: |  |  | ~~~~~~~~~~
Spreadsheet: 270148d1381401101-how-do-you-list-unique-names-when-the-criteria-is-identical-listed-names
Sheet: Appointments Book

Month Selection |  | October
Time | Name | Date
13 | Mr E | 2013-10-24 00:00:00 |  |  |  |  | Months
13 | Mr F | 2013-10-24 00:00:00 |  |  |  |  | January
13 | Mr G | 2013-10-24 00:00:00 |  |  |  |  | February
13 | Mr H | 2013-10-24 00:00:00 |  |  |  |  | March
 |  |  |  |  |  |  | April
 | As the month is selected by the user the names for that month are listed in date and order the spaces above |  |  |  |  |  | May
 |  |  |  |  |  |  | June
 |  |  |  |  |  |  | July
 |  |  |  |  |  |  | August
 |  |  |  |  |  |  | September
 |  |  |  |  |  |  | October
 |  |  |  |  |  |  | November
 |  |  |  |  |  |  | December
Spreadsheet: 69371d1269913756-proportionate-weightings-prorata-weights
Sheet: Sheet1

 | Weightings
Metrics | 50/50 | Proportionate
Call Quality Internal & External | 16 | 16 | 56
Attendance | 10 | 10
[NAME] | 18 | 18
Process Compliance | 12 | 12
PTP Realisation | 6 | 3.5 | 18.66666666666666 | 39.23809523809523
Cash collection | 14 | 8.166666666666666
OB THT | 12 | 7
IB CHT | 12 | 20.57142857142857 | 20.57142857142857
Total | 100 | 95.23809523809524
 | Hours | % in each | Divisor
Outbound | 3.5 | 0.3684210526315789 | 0.5833333333333334
Inbound | 6 | 0.631578947368421 | 1.714285714285714
If Outbound hours are 0, then cells C7 through C9 must equal 0 and C10 must equal 44
If Inbound hours are 0, then cell C10 must equal 0 and cells C7 through C9 must equal 44
Where inbound/outbound hours are equal, cells C7 through C10 must match their respective values in column B
Spreadsheet: 076a55ad-6d9e-4db6-81c1-5a10a2ac3cf5
Sheet: Sheet1

Schools by [NAME], October 1, 2001 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 | Elem. | Middle | Junior | Senior | Jr./Sr. | 4-Year
 | Schools | Schools | High | High | High | High
 | Grades | Grades | Grades | Grades | Grades | Grades | Special | Alternate | Total
District | K-6 | 5-9 | 7-9 | 10-12 | 7-12 | 9-12 | Schools | High | Schools
Alpine | 38 | 0 | 8 | 7 | 0 | 0 | 3 | 1 | 57
Beaver | 3 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 5
[NAME] | 17 | 2 | 2 | 2 | 0 | 0 | 1 | 2 | 26
Cache | 12 | 4 | 2 | 2 | 0 | 0 | 2 | 1 | 23
Carbon | 5 | 1 | 2 | 1 | 1 | 0 | 2 | 1 | 13
Daggett | 2 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 3
[NAME] | 51 | 0 | 13 | 7 | 0 | 0 | 11 | 2 | 84
Duchesne | 7 | 0 | 1 | 0 | 3 | 1 | 3 | 1 | 16
Emery | 6 | 0 | 2 | 1 | 1 | 0 | 0 | 0 | 10
[NAME] | 5 | 0 | 1 | 0 | 2 | 1 | 0 | 0 | 9
Grand | 2 | 0 | 1 | 0 | 0 | 1 | 0 | 1 | 5
Granite | 63 | 0 | 15 | 9 | 0 |  | 10 | 1 | 98
Iron | 8 | 0 | 1 | 0 | 1 | 2 | 2 | 0 | 14
Jordan | 53 | 0 | 15 | 8 | 0 | 0 | 3 | 1 | 80
[NAME] | 2 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 4
[NAME] | 4 | 0 | 1 | 0 | 3 | 1 | 0 | 0 | 9
Logan | 6 | 1 | 0 | 0 | 0 | 1 | 0 | 1 | 9
Millard | 4 | 2 | 0 | 0 | 0 | 3 | 0 | 0 | 9
Morgan | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 3
[NAME] | 7 | 0 | 2 | 1 | 0 | 0 |  | 1 | 11
Nebo | 20 | 4 | 3 | 3 | 0 | 0 | 1 | 1 | 32
No Sanpete | 5 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 7
No Summit | 1 | 1 | 0 | 0 | 0 | 1 | 0 |  | 3
Ogden | 16 | 4 | 0 | 0 | 0 | 2 | 6 | 1 | 29
Park City | 4 | 2 | 0 | 0 | 0 | 1 | 0 | 0 | 7
Piute | 2 | 0 | 0 | 0 | 1 | 0 |  | 0 | 3
Provo | 13 | 0 | 3 | 0 | 0 | 2 | 6 | 1 | 25
Rich | 2 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 4
[NAME] | 29 | 0 | 5 | 0 | 0 | 3 | 3 | 1 | 41
San Juan | 7 | 1 | 0 | 0 | 3 | 2 | 0 | 0 | 13
Sevier | 5 | 3 | 0 | 0 | 0 | 3 | 2 | 1 | 14
So [NAME] | 3 | 2 | 0 | 0 | 0 | 2 | 0 | 0 | 7
So Summit | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 3
Tintic | 3 | 0 |  | 0 | 2 | 0 | 0 | 0 | 5
Tooele | 10 | 1 | 1 | 0 | 2 | 2 | 1 | 1 | 18
Uintah | 7 | 2 | 1 | 1 | 0 | 0 | 1 | 1 | 13
Wasatch | 3 | 1 | 1 | 1 | 0 |  | 0 | 1 | 7
Washington | 18 | 2 | 3 | 3 | 1 | 1 | 1 | 1 | 30
Wayne | 2 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 4
Weber | 26 | 0 | 8 | 4 | 0 | 0 | 2 | 0 | 40
Subtotal | 473 | 38 | 92 | 50 | 23 | 35 | 60 | 22 | 793
Charter Schs. | 2 | 0 | 1 | 2 | 1 | 2 | 1 | 0 | 9
TOTAL | 475 | 38 | 93 | 52 | 24 | 37 | 61 | 22 | 802
 |  |  |  | 113
Spreadsheet: 061c0ea6-9daa-4296-8978-53f6c5253611
Sheet: Comparable Prices

FRATERNITY
Comparable Prices | Semester rate | # of Meals/Week | # of weaks in a Semester | Toal Meals
[NAME] | 480 | 9 | 15 | 135
[NAME] | 700 | 9 | 15 | 135
COMMUTER
Type of Meal Plan | Number of Meals | Dining Dollars | Guest Meals | Cost per Semester
 |  |  |  | (includes tax)
Commuter 50 Plan | 50 meals/semester | 300 | 5 Free Guest Meals/semester | 734.16
Commuter 75 Plan | 75 meals/semester | 150 | 5 Free Guest Meals/semester | 734.16
Commuter Dining Dollar Plan | 0 meals/semester | 714.5 | 5 Free Guest Meals/semester | 714.5
RESIDENTIAL
Type of Meal Plan | Number of Meals | Dining Dollars | Guest Meals | Cost per Semester
Unlimited Access Plan | Unlimited meals/week | 100 | 5 Free Guest Meals/semester | 1477
Unlimited Access Plus Plan | Unlimited meals/week | 300 | 5 Free Guest Meals/semester | 1677
Any 10 Plan | 10 meals/week | 300 | 5 Free Guest Meals/semester | 1477
Any 8 Plan | 8 meals/week | 450 | 5 Free Guest Meals/semester | 1477
VOL Block Plan | 165 meals/semester | 500 | 5 Free Guest Meals/semester | 1699
[NAME] 15 Plan | 15 meals/week at Gibbs Dining Hall only | 0 | - | 1196
Spreadsheet: 839884d1692278865-simple-way-to-calculate-ltm-results-for-quarterly-data-that-isnt-contiguous-test
Sheet: Sheet1

 | 1Q21A | 1Q22A | 1Q23A | 2Q21A | 2Q22A | 2Q23A | 3Q21A | 3Q22A | 3Q23E | 4Q21A | 4Q22A | 4Q23E |  | 2Q23 | 2023E |  | 1Q19A | 2Q19A | 3Q19A | 4Q19A |  | 1Q20A | 2Q20A | 3Q20A | 4Q20A
Value | 170 | 175 | 180 | 210 | 200 | 190 | 310 | 205 | 230 | 250 | 230 | 260 |  |  |  |  | 100 | 120 | 125 | 160 |  | 120 | 130 | 150 | 210
 | Desired Result | [NAME] | FORMULATEXT
1Q22
2Q22
3Q22
4Q22
1Q23
2Q23
3Q23
4Q23
Spreadsheet: 689946d1596765253-grid-to-list-formula-grid-to-list-formula
Sheet: EXAMPLE

 | [NAME] |  |  |  |  |  | FORMULA OUTPUT |  |  |  |  |  | Original | FORMULA OUTPUT
SKU | 2020-08-10 00:00:00 | 2020-09-10 00:00:00 | 2020-10-10 00:00:00 | 2020-11-10 00:00:00 | 2020-12-10 00:00:00 |  | SKU | QTY | DATE |  |  |  | intent→ | SKU | QTY | DATE
AB | 1 |  |  | 4 | 5 |  |  |  |  |  |  |  |  | AB | 1 | 2020-08-10 00:00:00
ABC | 6 | 7 |  | 9 |  |  |  |  |  |  |  |  |  | AB | 4 | 2020-11-10 00:00:00
ABCD | 2 |  | 4 |  | 6 |  |  |  |  |  |  |  |  | AB | 5 | 2020-12-10 00:00:00
ABCDE |  |  |  |  |  |  |  |  |  |  |  |  |  | ABC | 6 | 2020-08-10 00:00:00
ABCDEF |  | 4 | 5 |  | 7 |  |  |  |  |  |  |  |  | ABC | 7 | 2020-09-10 00:00:00
ABCDEFG | 2 |  | 1 |  | 1 |  |  |  |  |  |  |  |  | ABC | 9 | 2020-11-10 00:00:00
ABCEDFGH |  | 1 |  | 3 |  |  |  |  |  |  |  |  |  | ABCD | 2 | 2020-08-10 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | ABCD | 4 | 2020-10-10 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | ABCD | 6 | 2020-06-10 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | ABCDEF | 4 | 2020-09-10 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | ABCDEF | 5 | 2020-10-10 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | ABCDEF | 7 | 2020-12-20 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | ABCDEFG | 2 | 2020-08-10 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | ABCDEFG | 1 | 2020-10-10 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | ABCDEFG | 1 | 2020-12-10 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | ABCDEFGH | 1 | 2020-09-10 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | ABCDEFGH | 3 | 2020-11-10 00:00:00