tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: da9e4cdd-85d4-4bd1-b449-6585e0439c06
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
42796357 | 2014-08-19 23:01:49 | ALLIES | 1 | 6 | 2 | 225841 | sacas | 7664 | pacific | 1944-07-25 | 1944-07-25 | Japanese Counterattack | Contre-attaque japonaise
42796615 | 2014-08-19 23:21:51 | AXIS | 0 | 5 | 6 | 225841 | sacas | 7664 | pacific | 1944-07-25 | 1944-07-25 | Japanese Counterattack | Contre-attaque japonaise
42797682 | 2014-08-20 00:46:53 | ALLIES | 1 | 6 | 2 | 67493 | [NAME] | 12509 | western | 1944-06-06 |  | [Normandy] Vaumicel Manor | Château de Vaumicel
42797903 | 2014-08-20 01:01:18 | AXIS | 1 | 6 | 1 | 67493 | [NAME] | 12509 | western | 1944-06-06 |  | [Normandy] Vaumicel Manor | Château de Vaumicel
42811023 | 2014-08-21 00:32:26 | ALLIES | 1 | 6 | 3 | 642023 | [NAME] | 12498 | western | 1944-07-11 |  | [Normandy] Bretel Wood | [NAME]
42811342 | 2014-08-21 01:09:14 | AXIS | 1 | 6 | 5 | 642023 | [NAME] | 12498 | western | 1944-07-11 |  | [Normandy] Bretel Wood | [NAME]
42811743 | 2014-08-21 01:25:34 | ALLIES | 1 | 6 | 0 | 1623373 | [NAME] | 7595 | eastern | 1939-12-16 | 1939-12-16 | Suomussalmi | Suomussalmi
42811835 | 2014-08-21 01:35:10 | AXIS | 1 | 6 | 4 | 1623373 | [NAME] | 7595 | eastern | 1939-12-16 | 1939-12-16 | Suomussalmi | Suomussalmi
42826377 | 2014-08-22 03:39:13 | ALLIES | 1 | 7 | 3 | 1174565 | Capt [NAME] | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
42826578 | 2014-08-22 03:55:47 | ALLIES | 1 | 6 | 5 | 1613177 | Digs99 | 6152 | western | 1944-12-20 | 1944-12-22 | [NAME] | St. Vith
42826707 | 2014-08-22 04:11:07 | AXIS | 1 | 6 | 2 | 1613177 | Digs99 | 6152 | western | 1944-12-20 | 1944-12-22 | [NAME] | St. Vith
42884727 | 2014-08-26 04:21:22 | AXIS | 0 | 5 | 6 | 1472328 | [NAME] | 12497 | pacific | 1942-09-12 | 1942-09-14 | Bloody Ridge | [NAME]
42884919 | 2014-08-26 04:45:29 | ALLIES | 1 | 6 | 3 | 1472328 | [NAME] | 12497 | pacific | 1942-09-12 | 1942-09-14 | Bloody Ridge | [NAME]
42896003 | 2014-08-26 23:31:22 | ALLIES | 1 | 5 | 0 | 1348201 | ironkastel | 6153 | western | 1944-08-24 | 1944-08-24 | Liberation of Paris | Libération de Paris
42896190 | 2014-08-26 23:52:12 | AXIS | 1 | 5 | 3 | 1348201 | ironkastel | 6153 | western | 1944-08-24 | 1944-08-24 | Liberation of Paris | Libération de Paris
42937413 | 2014-08-30 00:49:08 | AXIS | 1 | 6 | 5 | 377160 | docsteve | 7364 | mediterranean | 1941-11-25 | 1941-11-25 | Dug in at [NAME] | Retranchés à [NAME]
42937682 | 2014-08-30 01:12:02 | ALLIES | 0 | 4 | 6 | 377160 | docsteve | 7364 | mediterranean | 1941-11-25 | 1941-11-25 | Dug in at [NAME] | Retranchés à [NAME]
Spreadsheet: 682488d1592143894-automating-a-task-automating-task-1-
Sheet: Pivot

 |  |  |  |  |  |  |  |  | NOTE: You can insert calculation fields into the [NAME] table. Click anywhere inside the [NAME] table,
Client | Type | Week | Sum of Receipts | Sum of Inventory | Sum of Inventory+ | Sum of Receipts 2 | Sum of Inventory2 |  | Then on the Ribbon, select 'Analyse, then Field, Items & Sets….
A | EU | 2020-05-29 00:00:00 | 4 | 5 | 4 | 45 | 4
 | US | 2020-05-29 00:00:00 | 8 | 1 | 35 | 456 | 67 |  | Alternatively, use Helper columns with the raw data (easier and more flexible on calculations.
A Total |  |  | 12 | 6 | 39 | 501 | 71
B | EU | 2020-05-29 00:00:00 | 7 | 1 | 4356 | 456 | 457
 | USA | 2020-05-29 00:00:00 | 9 | 62 | 692 | 51 | 9152
B Total |  |  | 16 | 63 | 5048 | 507 | 9609
C | EU | 2020-05-29 00:00:00 | 3 | 4 | 35 | 456 | 457
 | US | 2020-05-29 00:00:00 | 12 | 4 | 635 | 456 | 456
 | USA | 2020-05-29 00:00:00 | 4 | 6 | 6 | 6 | 454
C Total |  |  | 19 | 14 | 676 | 918 | 1367
D | EU | 2020-05-29 00:00:00 | 6 | 6 | 536 | 645 | 45
 | US | 2020-05-29 00:00:00 | 7 | 7 | 56 | 45 | 456
D Total |  |  | 13 | 13 | 592 | 690 | 501
E | EU | 2020-05-29 00:00:00 | 6 | 6 | 45 | 456 | 456
 | not assigned | 2020-05-29 00:00:00 | 5 | 3 | 6 | 645 | 645
 | US | 2020-05-29 00:00:00 | 4 | 5 | 645 | 6 | 456
 | USA | 2020-05-29 00:00:00 | 3 | 4 | 645 | 645 | 4
E Total |  |  | 18 | 18 | 1341 | 1752 | 1561
F | EU | 2020-05-29 00:00:00 | 7 | 3 | 456 | 45 | 6
 | US | 2020-05-29 00:00:00 | 98 | 5 | 45 | 456 | 456
 | USA | 2020-05-29 00:00:00 | 9 | 6 | 645 | 456 | 45645
F Total |  |  | 114 | 14 | 1146 | 957 | 46107
G | ASIA | 2020-05-29 00:00:00 | 6 | 76 | 456 | 645 | 6
 | EU | 2020-05-29 00:00:00 | 7 | 2 | 6 | 6 | 645
 | not assigned | 2020-05-29 00:00:00 | 5 | 5 | 45 | 45 | 456
G Total |  |  | 18 | 83 | 507 | 696 | 1107
H | EU | 2020-05-29 00:00:00 | 6 | 3 | 645 | 456 | 456
H Total |  |  | 6 | 3 | 645 | 456 | 456
I | US | 2020-05-29 00:00:00 | 7 | 7 | 651 | 912 | 690
 | USA | 2020-05-29 00:00:00 | 2 | 5 | 456 | 6 | 54
I Total |  |  | 9 | 12 | 1107 | 918 | 744
J | EU | 2020-05-29 00:00:00 | 65 | 7 | 45 | 645 | 6
J Total |  |  | 65 | 7 | 45 | 645 | 6
K | EU | 2020-05-29 00:00:00 | 5 | 8 | 645 | 645 | 456
 | US | 2020-05-29 00:00:00 | 34 | 6 | 6 | 45 | 456
 | USA | 2020-05-29 00:00:00 | 3 | 4 | 456 | 456 | 456
K Total |  |  | 42 | 18 | 1107 | 1146 | 1368
Grand Total |  |  | 332 | 251 | 12253 | 9186 | 62897
Spreadsheet: 730878d1620016809-looking-for-to-resolve-the-match-formula-in-attached-file-sks-aligw
Sheet: Matrix

Offense | First Instance | Second Instance | Third Instance | Fourth Instance
Driving Under the Influence of Drugs or Alchohol | [NAME]
Driver or Passenger not using the seat belt while the vehicle is in motion. | Final Warning | [NAME]
Over Speeding Recorded by IVMS | Final Warning | [NAME]
Using Mobile Phone while driving (both handheld and handsfree) | Final Warning | [NAME]
Tampering Safety Device | Final Warning | [NAME]
Failure to Obtain a valid Permit to Work whenever required for the task at hand. | First Warning Letter | Final Warning | [NAME]
Failure to Conduct gas tests whenever required. | First Warning Letter | Final Warning | [NAME]
Failure to Verify isolation before work begins and use the specified life_x0002_protecting equipment. | First Warning Letter | Final Warning | [NAME]
Failure to Obtain authorization or a valid Permit to Work before entering a confined space | First Warning Letter | Final Warning | [NAME]
Failure to Obtain authorization or a valid Permit to Work before overriding or disabling safety-critical equipment. | First Warning Letter | Final Warning | [NAME]
Failure to Use specified  fall-prevention equipment when working at height | First Warning Letter | Final Warning | [NAME]
Failure to follow the rule - Do not walk under a suspended load. | First Warning Letter | Final Warning | [NAME]
Failure to Follow the No Smoking rules | First Warning Letter | Final Warning | [NAME]
Not Complying with Jounrey Management Plan Rules | First Warning Letter | Final Warning | [NAME]
Unauthorized driving for private use | First Warning Letter | Final Warning | [NAME]
Driving with expired ROP License & DD driving Permit | Counselling | First Warning Letter | Final Warning | [NAME]
Leaving Ignition key and/or IVMS [NAME] with [NAME] unattended or use of smart key of others | Counselling | First Warning Letter | Final Warning | [NAME]
Any other road safety non-compliance not mentioned in the above offences | Counselling | First Warning Letter | Final Warning | [NAME]
Spreadsheet: 863192d1710775208-vlookup-if-with-conditions-in-two-columns-solar-salaried-employee-list-test
Sheet: ENTRY TAB

Emp No | Employee Full Name | First Name | Last Name | PHONE NUMBER | Hire Date
1001
1036
1037
1068
 |  |  |  | Lookup on A2
 |  |  |  | in WD DROP
 |  |  |  | for work phone#
 |  |  |  | if none, then add
 |  |  |  | personal phone #
Spreadsheet: 802797d1667046503-check-if-there-is-duplicated-records-in-date-range-duplicated-in-date-range-_-etaf
Sheet: Sheet1

 | # | Code | Date | Error | Column1 |  | Check if there duplicated Code in exact and before and after 2 days from the date
 | 1 | 22 | 2022-10-25 00:00:00 | Yes
 | 2 | 33 | 2022-09-10 00:00:00 | Yes
 | 3 | 33 | 2022-09-11 00:00:00 | Yes
 | 4 | 11 | 2022-01-01 00:00:00 | No
 | 5 | 22 | 2022-10-27 00:00:00 | Yes
 | 6 | 77 | 2022-01-01 00:00:00 | No
 | 7 | 99 | 2022-01-01 00:00:00 | No
 | 8 | 66 | 2022-01-01 00:00:00 | No
 | 9 | 22 | 2022-10-20 00:00:00 | No
 | 10 | 88 | 2022-01-01 00:00:00 | No
Spreadsheet: 719875d1613863941-auto-populate-date-ranges-to-linear-calendar-90-day-mx-outlook-automated-test-1
Sheet: Weekly Task Schedule

 | To Task List
 | 90 DAY
 | TASK SCHEDULE |  |  |  |  | Schedule Start Date: |  | 2021-03-01 00:00:00
 | 100
 | 101
 | 110
 | 120
 | 146
 | 151
 | 200
 | 201
 | 202
 | 203
 | HOT ROD
 | PASSENGER
Spreadsheet: 769513d1645568544-unique-count-average-percentage-and-weekly-breakdown-member-check-ins-average-check-ins-testing
Sheet: Total Members per Age Group

Starting Age | Ending Age | Total Members
13 | 19
20 | 29 |  |  | THIS NEEDS TO BE A UNIQUE COUNT OF MEMBERS BETWEEN THE AGE GROUPS
30 | 39
40 | 49 |  |  | THERE ARE TWO UNIQUE MEMBERS FOR 13-19
50 | 59
60 | 69 |  |  | THERE IS ONE UNIQUE MEMBER FOR 20-29
70 | 79
80 | 89
90 | 99999
Spreadsheet: 8bbac669-f4e2-429a-848e-f65fbe94041e
Sheet: Key

 | School Performance Framework Ratings
 | Rating | Percent of Points Earned
Elementary/Middle Schools | Accredited | at or above 59%
 | Accredited with Improvement | at or above 47% but below 59%
 | Accredited with Priority Improvement | at or above 37% but below 47%
 | Accredited with Turnaround | below 37%
High Schools | Accredited | at or above 60%
 | Accredited with Improvement | at or above 47% but below 60%
 | Accredited with Priority Improvement | at or above 33% but below 47%
 | Accredited with Turnaround | below 33%
Please note that districts can lower school ratings per their accreditation contracts. Districts can also request a higher rating for schools through the request to reconsideration process. If the percent of points earned does not match the rating, please read the "Notes" column for the details.
Spreadsheet: michelle_lokay__26792__imball0203
Sheet: PNM

PNM imbalance
 | Measured | Scheduled | Imbalance
9236 |  | -29232
9238 |  | -6000
56422 |  | -576174
58710 |  | -408
60921 |  | -326680
78026
500084 |  | -6000
500085
500097 | -11368 | -12000
INDEX
2002-02-28 00:00:00 |  |  | 829704.21
2002-03-06 00:00:00
CBS Volume
 |  |  | 337548
Spreadsheet: 847596d1698448372-how-to-convert-a-set-of-utc-dates-times-into-gmt-bst-time-zones-2
Sheet: UTC Conversion

Date/Time UTC | Date/Time London | Required Result for Date/Time London | Correct formula
2023-03-25 01:00:00 |  | 25/03/2023 01:00:00
2023-03-26 01:00:00 |  | 26/03/2023 02:00:00
2023-03-27 01:00:00 |  | 27/03/2023 02:00:00
2023-10-28 01:00:00 |  | 28/10/2023 02:00:00
2023-10-29 01:00:00 |  | 29/10/2023 [NAME]
2023-10-30 01:00:00 |  | 29/10/2023 [NAME]
2023-03-26 00:59:59
2023-03-26 01:00:00
2023-03-26 01:00:01
2023-10-29 00:59:59
2023-10-29 01:00:00
2023-10-29 01:00:01
Spreadsheet: 221661d1363634152-sales-report-summarizing-the-totals-pivottable-example1
Sheet: Pivottable2

Row Labels | Sum of Total Sales
639739 | 199.96
Mens Backpacks & Bags | 16.99
Misc | 3.99
Skateboard Decks | 50
[NAME] | 4
Skateboard Wheels | 25
(blank) | 99.98
639740 | 27.98
Misc | 3.99
[NAME] | 10
(blank) | 13.99
639741 | 127.98
[NAME] | 60
Misc | 3.99
(blank) | 63.99
639742 | 57.98
[NAME] and Pants | 10
[NAME] | 15
Misc | 3.99
(blank) | 28.99
Overall | 18346.17
(blank) | 18346.17
Grand Total | 18760.07
Spreadsheet: 128506d1321016288-numerical-sorting-800428-numerical-sorting-brelu
Sheet: Original

 |  |  |  |  |  |  | MEMBERS SCORE CARDS |  |  |  |  |  |  |  |  |  |  |  |  | ENTRY | TOTAL | ENTRY | SORTED |  | TMS |  | DO Applied | DO Example
13 | 9 | 8 | 6 | 9 | 9 | 10 | 11 | 11 | 9 | 10 | 8 | 10 | 9 | 12 | 9 | 9 |  |  |  | 1 | 162 | 7 | 215 |  | 7 |  | 7 | 7
14 | 9 | 12 | 9 | 13 | 11 | 10 | 12 | 13 | 12 | 13 | 14 | 13 | 11 | 9 | 11 | 9 |  |  |  | 2 | 195 | 9 | 208 |  | 9 |  | 9 | Committed with
10 | 9 | 9 | 7 | 8 | 14 | 11 | 8 | 10 | 8 | 13 | 10 | 12 | 8 | 11 | 8 | 15 |  |  |  | 3 | 171 | 15 | 206 |  | 15 |  | 15 | Ctrl-Shift-Enter
13 | 8 | 7 | 7 | 10 | 11 | 9 | 7 | 9 | 11 | 11 | 15 | 10 | 10 | 12 | 15 | 8 |  |  |  | 4 | 173 | 18 | 198 |  | 18 |  | 18
10 | 7 | 9 | 6 | 11 | 8 | 12 | 10 | 10 | 9 | 12 | 13 | 11 | 9 | 7 | 10 | 8 |  |  |  | 5 | 162 | 6 | 196 |  | 6 |  | 6
13 | 10 | 12 | 9 | 11 | 14 | 12 | 12 | 15 | 9 | 14 | 11 | 13 | 9 | 12 | 11 | 9 |  |  |  | 6 | 196 | 2 | 195 |  | 2 |  | 2
13 | 10 | 13 | 9 | 15 | 15 | 13 | 13 | 12 | 12 | 15 | 14 | 15 | 12 | 15 | 9 | 10 |  |  |  | 7 | 215 | 13 | 190 |  | 13 |  | 13
13 | 10 | 11 | 7 | 11 | 13 | 11 | 7 | 10 | 13 | 15 | 12 | 15 | 10 | 9 | 9 | 8 |  |  |  | 8 | 184 | 8 | 184 |  | 8 |  | 8
14 | 11 | 11 | 8 | 12 | 10 | 13 | 13 | 13 | 13 | 14 | 15 | 14 | 14 | 15 | 10 | 8 |  |  |  | 9 | 208 | 14 | 184 |  | 8 |  | 14
12 | 8 | 9 | 9 | 11 | 9 | 11 | 11 | 9 | 10 | 12 | 14 | 9 | 9 | 15 | 11 | 12 |  |  |  | 10 | 181 | 10 | 181 |  | 10 |  | 10
12 | 10 | 10 | 8 | 11 | 9 | 9 | 8 | 10 | 15 | 13 | 14 | 12 | 11 | 10 | 10 | 8 |  |  |  | 11 | 180 | 11 | 180 |  | 11 |  | 11
10 | 7 | 9 | 4 | 8 | 10 | 9 | 7 | 8 | 9 | 9 | 15 | 8 | 8 | 13 | 12 | 8 |  |  |  | 12 | 154 | 16 | 175 |  | 16 |  | 16
12 | 10 | 12 | 10 | 11 | 12 | 11 | 8 | 10 | 11 | 11 | 14 | 12 | 10 | 14 | 11 | 11 |  |  |  | 13 | 190 | 4 | 173 |  | 4 |  | 4
12 | 8 | 12 | 7 | 11 | 8 | 13 | 6 | 10 | 11 | 12 | 15 | 13 | 9 | 14 | 11 | 12 |  |  |  | 14 | 184 | 17 | 172 |  | 17 |  | 17
12 | 10 | 15 | 11 | 13 | 12 | 12 | 10 | 10 | 10 | 10 | 12 | 13 | 14 | 15 | 12 | 15 |  |  |  | 15 | 206 | 3 | 171 |  | 3 |  | 3
10 | 9 | 12 | 9 | 11 | 11 | 10 | 10 | 11 | 9 | 12 | 11 | 9 | 12 | 10 | 8 | 11 |  |  |  | 16 | 175 | 1 | 162 |  | 1 |  | 1
12 | 9 | 10 | 8 | 11 | 15 | 12 | 9 | 10 | 10 | 11 | 11 | 9 | 8 | 8 | 8 | 11 |  |  |  | 17 | 172 | 5 | 162 |  | 1 |  | 5
14 | 12 | 11 | 15 | 11 | 11 | 12 | 11 | 11 | 10 | 10 | 12 | 12 | 10 | 15 | 11 | 10 |  |  |  | 18 | 198 | 12 | 154 |  | 12 |  | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | First | 215
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Second | 208
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Third | 206
Spreadsheet: 711719d1609862045-daily-sales-spreadsheet-test-month-target
Sheet: Sheet1

JANUARY 2021
Day | DATE | Daily Target | Daily Sales | Month To Date |  | The basic info is:
MON | 4TH |  | 2491 |  |  | The month target is £62'500 and we only work weekdays, so this month is 20days.
TUES | 5TH |  | 2274 |  |  | This makes the daily target £3125.
WED | 6TH |  |  |  |  | On day 1 we did £2491 which then makes the target £60'009, and the daily target £3158.
THUR | 7TH |  |  |  |  | Day 2 we have done £2274; monthly £57'735, daily target now £3207.
FRI | 8TH
MON | 11TH
TUES | 12TH
WED | 13TH
THUR | 14TH
FRI | 15TH
MON | 18TH
TUES | 19TH
WED | 20TH
THUR | 21ST
FRI | 22ND
MON | 25TH
TUES | 26TH
WED | 27TH
THUR | 28TH
FRI | 29TH
TOTAL |  | 62500
Spreadsheet: 160bc5f0-f2f2-48b9-ba7f-9f7af200318e
Sheet: Formulas

[NAME] (Revised 5-1-13)
Assumption:  CMS will receive legislative approval to increase cap on Middle Colleges to 400.
Giles Science Bldg. Renovation – Additional 21,000 GSF; 60% = 12,600 ASF
12,600 divided by 90 Assignable Square Feet (County Goal) = 140 CPCC FTE
140 FTEs X 3 = 420 CPCC Students Total
50% = 210 PT CMS Students
50% = 105 FT CMS Students
Cato Campus - Additional 100,000 GSF = 60,000 ASF
60,000 divided by 90 ASF = 667 CPCC FTE
667 FTEs X 3 = 2000 CPCC Students Total
If we expanded the Middle College, then CMS’ portion would 400 FTE
If we expanded the Career and College Promise Programs then CMS’ portion would be 100 FTE
(50% of 200 PT CMS Students = 100 FT CMS Students)
For a total of 500 FT CMS Students
New Classroom Bldg. at Charlottetown for ATC Center = Additional 100,000 GSF = 60,000 ASF
60,000 divided by 90 ASF = 667 CPCC FTE
667 FTEs X 3 = 2000 CPCC Students
To reach the CMS goal of 1600 CCP students, would need to add 836 PT CMS students
50% = 412 FT CMS Students
[NAME] 120,000 GSF = 72,000 ASF
72,000 divided by 90 ASF = 800 CPCC FTE
800 FTEs X 3 = 2400 CPCC Students Total
If we added a Middle College, then CMS’ portion would be 400 FTE
If we expanded the Career and College Promise Programs then CMS’ portion would be 100 FTE
(50% of 200 PT CMS Students = 100 FT CMS Students)
For a total of 500 FT CMS Students
Merancas Campus - Additional 100,000 GSF = 60,000 ASF
60,000 divided by 90 ASF = 667 CPCC FTE
667 FTEs X 3 = 2000 CPCC Students Total
If we added a Middle College or new Academies, then CMS’ portion would be 400 FTE
If we expanded the Career and College Promise Programs then CMS’ portion would be 100 FTE
(50% of 200 PT CMS Students = 100 FT CMS Students)
For a total of 500 FT CMS Students
ATC Building Renovation – Additional 75,000 GSF = 45,000 ASF
45,000 divided by 90 ASF = 500 CPCC FTE
500 FTEs X 3 = 1500 CPCC Students Total
50% = 250 FTEs for CMS
New Basic Skills Literacy Center = Additional 200,000 GSF = 120,000 ASF
120,000 divided by 90 ASF = 1333 CPCC FTE
1333 FTEs X 3 = 4000 Total CPCC Students
Hendrick Automotive Expansion at Levine Campus = 34,426 current GSF + 13,000 additional GSF = 47,426;
60% = 28,456 ASF
28,456 divided by 90 ASF = 316 CPCC FTE
316 FTEs X 3 = 948 CPCC Students Total
If we added an Apprenticeship Program then CMS’ portion would be 50 FTE
[NAME] 150,000 GSF = 90,000 ASF
90,000 divided by 90 ASF = 1000 CPCC FTE
1000 FTEs X 3 = 3000 CPCC Students Total
If we added a Middle College, then CMS’ portion would be 400 FTE
If we expanded the Career and College Promise Programs then CMS’ portion would be 100 FTE
(50% of 200 PT CMS Students = 100 FT CMS Students)
For a total of 500 FT CMS Students
[NAME] = Additional 150,000 GSF; 60% = 90,000 ASF
90,000 divided by 90 ASF = 1000 CPCC FTE
1000 FTEs X 3 = 3000 Total Students
Spreadsheet: 95815d1295365433-average-of-the-count-sum-pivot-tables-sample
Sheet: Pivot Table

Safety Critical | P
Fault Catgeory | (All)
Count of Vehicle |  | Years | Date
 |  | 2010 |  |  |  |  |  |  |  |  |  |  |  | 2011 | Grand Total
Class | Ravers Code | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan
66 | BB | 8 | 5 | 5 | 5 | 3 | 1 | 11 | 2 | 3 | 12 | 15 | 16 |  | 86
 | AW | 6 | 3 | 4 | 1 | 5 | 2 | 8 | 6 | 4 | 3 | 6 | 10 |  | 58
 | AS | 1 |  | 1 | 1 | 5 | 1 | 5 | 7 | 5 | 10 | 2 | 1 |  | 39
 | EL | 1 |  | 2 | 5 | 4 | 4 | 1 | 3 | 1 |  | 3 | 5 | 1 | 30
 | BH | 1 | 2 | 1 | 1 | 3 | 1 | 3 |  | 2 | 5 | 1 | 1 |  | 21
66 Total |  | 17 | 10 | 13 | 13 | 20 | 9 | 28 | 18 | 15 | 30 | 27 | 33 | 1 | 234
Grand Total |  | 17 | 10 | 13 | 13 | 20 | 9 | 28 | 18 | 15 | 30 | 27 | 33 | 1 | 234
Spreadsheet: 876153d1722846756-need-formula-for-tier-incentive-calculation-calculation-doing-formula-etaf
Sheet: DR. Sultana Alsdairi.

Contract Terms (*)
 |  | 1- Revenue Target on Dental Procedure | Incentive
 |  | [NAME] to 25,000 | 0.05
 |  | [NAME] to 35,000 | 0.075
 |  | [NAME] to 45,000 | 0.1
 |  | Over (45000) | 0.15
Doctor Calculation
 |  | Doctor Revenue Dental Procedure | 24352.02
 |  | Clinic Fees 5%
 |  | Dental Lab | 0
 |  | Net Revenue
 |  | Amount to be Paid
 |  | Total Amount to be Paid
Prepared By …................. |  |  |  | CFO: | .......................
Spreadsheet: 150115d1334298368-please-help-with-random-cells-raffle-roster4
Sheet: Sheet1

 |  |  | rostered on | who is on
1 |  | Person1 | 2012-04-01 00:00:00 | Person45 | Person24
2 |  | Person2 | 2012-04-07 00:00:00 | Person43 | Person1
3 |  | Person3 |  | Person69 | Person53
4 |  | Person4 |  | Person12 | Person60
5 |  | Person5 |  | Person18 | Person35
6 |  | Person6 |  | Person26 | Person65
7 |  | Person7 |  | Person64 | Person40 | how do I do a raffle roster with 80 names with 2  names as on this sheet
8 |  | Person8 |  | Person52 | Person14
9 |  | Person9 |  | Person19 | [NAME]
10 |  | Person10 |  | Person10 | Person9
11 |  | Person11 |  | Person47 | Person17
12 |  | Person12 |  | Person50 | Person8
13 |  | [NAME] |  | Person33 | Person11
14 |  | Person14 |  | Person41 | Person29
15 |  | Person15 |  | Person23 | Person16
16 |  | Person16 |  | Person22 | Person42
17 |  | Person17 |  | Person34 | Person28
18 |  | Person18 |  | Person49 | Person55
19 |  | Person19 |  | Person32 | Person57
20 |  | [NAME] |  | Person27 | Person21
21 |  | Person21 |  | Person6 | Person15
22 |  | Person22 |  | Person7 | Person71
23 |  | Person23 |  | Person39 | Person58
24 |  | Person24 |  | Person54 | Person59
25 |  | Person25 |  | Person61 | Person67
26 |  | Person26 |  | Person44 | Person56
27 |  | Person27 |  | Person63 | Person37
28 |  | Person28 |  | Person51 | Person4
29 |  | Person29 |  | Person62 | Person66
30 |  | Person30 |  | Person46 | Person3
31 |  | Person31 |  | Person38 | [NAME]
32 |  | Person32 |  | Person30 | Person48
33 |  | Person33 |  | Person2 | Person36
34 |  | Person34 |  | Person5 | Person31
35 |  | Person35 |  | Person70 | Person25
36 |  | Person36 |  | Person68
37 |  | Person37
38 |  | Person38
39 |  | Person39
40 |  | Person40
41 |  | Person41
42 |  | Person42
43 |  | Person43
44 |  | Person44
45 |  | Person45
46 |  | Person46
47 |  | Person47
48 |  | Person48
49 |  | Person49
50 |  | Person50
51 |  | Person51
52 |  | Person52
53 |  | Person53
54 |  | Person54
55 |  | Person55
56 |  | Person56
57 |  | Person57
58 |  | Person58
59 |  | Person59
60 |  | Person60
61 |  | Person61
62 |  | Person62
63 |  | Person63
64 |  | Person64
65 |  | Person65
66 |  | Person66
67 |  | Person67
68 |  | Person68
69 |  | Person69
70 |  | Person70
71 |  | Person71
72
73
74
75
76
77
78
79
80
Spreadsheet: 589c6e62-5169-49a8-8bb5-dae14bf5a22b
Sheet: Sheet1

Rochester Season Schedule | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Date | Game Number | Visiting Team | Visiting Score | Home Team | Home Score | Game Time/Status | Venue
2013-04-27 | 1 | Rochester | 3 | Toronto | 6 | Final | Ricoh Coliseum Toronto, ON
2013-04-28 | 2 | Rochester | 0 | Toronto | 2 | Final | Ricoh Coliseum Toronto, ON
2013-05-01 | 3 | Toronto | 3 | Rochester | 2 | Final OT | Blue Cross [NAME], NY
Spreadsheet: 111275d1307672545-data-validation-with-v-look-up-data-validation-help
Sheet: SUmmary

Names | Small Cost | Big Cost | Amount |  |  | AAA
[NAME] |  | AAA | 1000 |  |  | AA
[NAME] |  |  | 3000 |  |  | DDD
[NAME] |  |  | 15430.81 |  |  | DDD
[NAME] |  |  | 4000 |  |  | FFF
[NAME] |  |  | 29129.29 |  |  | W
 |  |  | 3000 |  |  | FFFF
 |  |  | 21403.82 |  |  | GGGG
 |  |  | 3000 |  |  | GGGG
 |  |  | 20538.01 |  |  | GGGG
 |  |  | 3500 |  |  | A
 |  |  | 32061.82 |  |  | GGGG