tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 804497d1668103701-find-value-from-table-in-string-sample
Sheet: Values

Code | Facility |  |  | Cost Center | Facility |  |  | Cost Center | Facility
A | Test Fac 1 |  |  | 6010A |  |  |  | 6010A | Test Fac 1
B | Test Fac 2 |  |  | 6011A |  |  |  | 6011A | Test Fac 1
1000 | Test Fac 3 |  |  | 6014A |  |  |  | 6014A | Test Fac 1
2000 | Test Fac 4 |  |  | 8311B |  |  |  | 8311B | Test Fac 2
 |  |  |  | 8331B |  |  |  | 8331B | Test Fac 2
 |  |  |  | 8371B |  |  |  | 8371B | Test Fac 2
 |  |  |  | 1000-20319 |  |  |  | 1000-20319 | Test Fac 3
 |  |  |  | 1000-12938 |  |  |  | 1000-12938 | Test Fac 3
 |  |  |  | 1000-10283 |  |  |  | 1000-10283 | Test Fac 3
 |  |  |  | 13091-1000 |  |  |  | 13091-1000 | Test Fac 3
 |  |  |  | 12983-1000 |  |  |  | 12983-1000 | Test Fac 3
 |  |  |  | [PHONE] |  |  |  | [PHONE] | Test Fac 3
 |  |  |  | 1000-10000 |  |  |  | 1000-10000 | Test Fac 3
 |  |  |  | 1000-10291 |  |  |  | 1000-10291 | Test Fac 3
 |  |  |  | 1000-1000 |  |  |  | 1000-1000 | Test Fac 3
 |  |  |  | 1000-2000 |  |  |  | 1000-2000 | Test Fac 3
 |  |  |  | 2000-1000 |  |  |  | 2000-1000 | Test Fac 4
Spreadsheet: 351abcfd-662b-4900-be35-fc43a0b97bc8
Sheet: Sheet1

Supplementary table 2: Conserved and unique repeats found in GIV and SGIV | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
 | GIV |  |  |  | SGIV
Sequence | Indices | Period size | Copy number | Match identity | Indices | Period size | Copy number | Match identity
CONSERVED REPEATS
agt [NAME] | 12668--12719 | 9 | 5.8 | 100 | 23472--23505 | 9 | 3.8 | 100
g gctgtgaagt agga | 20850--20955 | 15 | 7.1 | 100 | 31605--31635 | 15 | 2.1 | 100
tccaggcc ccccaggacc | 90693--90728 | 18 | 2 | 100 | 102058--102093 | 18 | 2 | 100
[NAME] cccaaggggc t | 40024--40074 | 18 | 2.8 | 100 | 50701--50751 | 18 | 2.8 | 100
aggg ctcagggaca gcttgtagac [NAME] | 100027--100499 | 26 | 18.2 | 100 | 111355--111749 | 26 | 15.2 | 95
ccaat cgttcctcaa cctctttggg ggtttgtcta attttaggct tggcgc | 346--448 | 51 | 2 | 98 | 11054--11156 | 51 | 2 | 96
g actgcctctg ggcctcctgg ggctagcggg cctcttgtcc ctcgacctct cgg | 1090--1330 | 54 | 4.5 | 99 | 11798--12126 | 54 | 6.1 | 99
UNIQUE REPEATS
ctgggcc tc | 1314--1349 | 9 | 4 | 96
tcccg gtgg | 30836--30875 | 9 | 4.4 | 100
[NAME] | 48149--48432 | 15 | 18.9 | 100
tt tcatgctaaa tagcg | 127569--127605 | 17 | 2.2 | 95
cac ccaggagccc tcttcgcccc acgc | 48468--48538 | 27 | 2.6 | 100
t [NAME] | 7100--7360 | 36 | 7.3 | 99
[NAME] ctccaccgag [NAME] gcccgaggtc | 88678--88880 | 63 | 3.2 | 100
tcca ccgtagcgcc c |  |  |  |  | 58827--58871 | 15 | 3 | 100
tgctaaatag tgtttca |  |  |  |  | 138581--138629 | 17 | 2.9 | 100
[NAME] tcctcg |  |  |  |  | 7019--7062 | 18 | 2.4 | 96
agaggcttcc tcgaaggccg a |  |  |  |  | 123751--123881 | 21 | 6.2 | 100
cccc acgccaccca ggagccctct tcg |  |  |  |  | 58907--59192 | 27 | 10.6 | 100
ggtgggact cttgcgtctt gtgggagttt ttcgtct |  |  |  |  | 17912--18143 | 36 | 6.4 | 96
[NAME] cgagccagag [NAME] gtcctccacc cctcccccga a |  |  |  |  | 99529--100248 | 63 | 11.4 | 100
Spreadsheet: 275240d1383414156-how-to-use-index-and-match-with-multiple-criteria-driverssample
Sheet: Drivers

RaceID | Year | Race | Pos | Driver | Time
1 | 2012 | 7 | 1 | Driver 1 | Race time
1 | 2012 | 7 | 2 | Driver 2 | Race time
1 | 2012 | 7 | 3 | Driver 3 | Race time
1 | 2012 | 7 | 4
2 | 2012 | 8 | 1
2 | 2012 | 8 | 2
2 | 2012 | 8 | 3
2 | 2012 | 8
3 | 2013 | 1
3 | 2013 | 1
Spreadsheet: 832723d1686565378-transforming-data-from-vertical-to-horizontal-using-excel-function-excel1-copy
Sheet: Sheet1

Option A |  |  |  |  |  | Option B (what I want)
Source | Target | Sign |  | Categories |  | StorageA | StorageA | StorageA | StorageA | StorageB | StorageB | StorageB | StorageB | StorageC | StorageC | StorageC | StorageC | StorageC
StorageA | Evaporation | - |  | Sign |  | + | + | - | - | + | + | - | - | + | + | + | -
StorageA | SOTP | - |  | How to generate this result using formular |  | Rain | FlowinA | Evaporation | SOTP | Rain | FlowinB | Evaporation | SQPE | Rain | SWRD | FlowinC | Evaporation | UGTW
Rain | StorageA | +
FlowinA | StorageA | +
Rain | StorageB | + |  |  |  | Note
FlowinB | StorageB | + |  |  |  | + | To represent what into StorageA, StorageB and StorageC
StorageB | Evaporation | - |  |  |  | - | To represent what exisiting StorageA, StorageB and StorageC
StorageB | SQPE | -
SWRD | StorageC | +
Rain | StorageC | +
FowinC | StorageC | +
StorageC | Evaporation | -
StorageC | UGTW | -
Spreadsheet: 083f6199-0e1e-4a65-9d9a-c571c5579e9a
Sheet: Sheet1

MISSOURI GAMING COMMISSION | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
DETAIL GAMING STATS - PUBLIC REPORT
MONTH ENDED:      OCTOBER 2012
 |  |  | BOAT:    ARGOSY RIVERSIDE
TABLE GAMES:
 |  |  |  | TABLE | TABLE | ACTUAL
 |  |  | UNITS | DROP | AGR | HOLD %
Blackjack |  |  | 12 | 632593 | 105039.5 | 0.1660459410711152
Double [NAME] |  |  | 2 | 735573 | 58389 | 0.07937893315823175
Blackjack Press
Face Up Blackjack
Multiple Action Blackjack
Spanish 21 |  |  | 1 | 153459 | 39186.5 | 0.255354850481236
Super Seven Blackjack
Flop Poker
Caribbean Stud
Craps |  |  | 2 | 769717 | 207794 | 0.2699615572996309
Craps No More
No Craps, Craps |  |  | 1 | 318347 | 113817.5 | 0.3575265355099938
Double Down Stud
Let It Ride |  |  | 1 | 102964 | 39597 | 0.3845713064760499
Mini Bacarrat
Pai Gow Poker |  |  | 2 | 221276 | 85071.5 | 0.3844587754659339
[NAME] |  |  | 2 | 390693 | 102226.5 | 0.2616542912209843
Poker w/o bad beat
Bad Beat Poker - house funded
Bad Beat Poker - player funded
Three Card Poker/Stud |  |  | 1 | 111053 | 13354.48 | 0.1202532124301009
[NAME] |  |  | 1 | 184888 | 47637.09 | 0.2576537687681191
BJ 21 +3 |  |  | 5 | 1449272 | 251878.5 | 0.1737965682080382
Let it Ride 3 Card Bonus
Perfect Pair
Ultimate Texas Hold'em |  |  | 1 | 255595 | 71662.48 | 0.2803751247090123
Table Tournaments
Other
Rounding
TOTAL TABLE GAMES: |  |  | 31 | 5325430 | 1135654.05 | 0.2132511459168555
ELECTRONIC GAMING DEVICES:
 |  |  |  | SLOT | SLOT | ACTUAL
 |  |  | UNITS | HANDLE | AGR | PAYOUT % (1)
5 cents |  |  | 83 | 10342259.6 | 645599.04 | 0.937576596897645
10 cents
25 cents |  |  | 219 | 15436508.9 | 1048168.5 | 0.9320980859862685
50 cents |  |  | 6 | 343688 | 24429.5 | 0.9289195433067201
$1.00 |  |  | 173 | 14775985.59 | 922846.31 | 0.9375441790749608
$2.00 |  |  | 18 | 3444509 | 218308 | 0.9366214459012882
$5.00 |  |  | 13 | 2573540 | 73960 | 0.9712613753817698
$10.00
$25.00
1 cent tokenized |  |  | 1133 | 71748128.92 | 8128990.47 | 0.8867010109899323
2 cent tokenized
Slot Tournaments
Wide Area Progressive
Other
Rounding
TOTAL SLOTS: |  |  | 1645 | 118664620.01 | 11062301.82 | 0.9067767476180536
TOTAL AGR FOR MONTH: |  |  |  |  | 12197955.87
(1) The above payout percentages for slots represent the actual payout for a one month period only.
The 80% minimum payout per Section 313.805(12) RSMO is not limited to any one month period
and is calculated based on standard probability and statistical theory.
NOTE:  THE FIGURES IN THIS REPORT ARE SUBJECT TO ADJUSTMENT
Spreadsheet: 584643d1533304800-how-to-count-records-taking-into-account-and-or-possibilities-how-to-count-a-list-of-records-taking-into-account-and-or-possibilities
Sheet: Sheet1

 |  | 2018-09-30 00:00:00
 | Arrived | Left |  | Count?
[NAME] | 2018-09-01 00:00:00 |  |  | Yes - as no leaving date
[NAME] | 2017-12-01 00:00:00 | 2018-08-01 00:00:00 |  | No - as left before date in C2
[NAME] |  |  |  | Yes - assume arrived before C2 and still here
[NAME] | 2018-10-01 00:00:00 |  |  | Yes - assume arrived before and blank = still here
[NAME] |  | Not Known |  | Yes - assume arrive before and for not known assume still here
[NAME] | 2018-10-01 00:00:00 |  |  | No - arrived after
 |  |  | Expected Result = 4
 |  | ATTEMPTED FORMULA |  | countifs($C$5:$C$10,">"&$C$2)+countifs($C$5:$C$10,"Not Known")+countifs($C$5:$C$10,""),countifs($B$5:$B$10,"<"&$C$2),$B$5:$B$10,"")
 |  |  | Try this
Spreadsheet: 718620d1613238248-formula-for-automatic-breakdown-sample-data
Sheet: Sheet3

 |  |  |  |  | what formula for this breakdown
 |  | [NAME] | 10
 |  | abc15 | 5
 |  | mmm20 | 20
Spreadsheet: 860277d1708436406-flow-data-through-tabs-based-on-what-is-entered-in-a-cell-pricing-example-ef
Sheet: 2024 Pricing

[NAME] | UPDATED | PRODUCT CODE | 2024 COST PRICE (EXC VAT) | MINIMUM  PROFIT | mark up | 2024 NEW PRICE (ex VAT) | 2024 NEW PRICE (INC VAT)
BUDGET WANEY (BROWN & ORANGE)
2ft |  | [NAME] |  |  |  |  | 10
3ft |  | MDW3 |  |  |  |  | 15
4ft |  | MDW4 |  |  |  |  | 20
5ft |  | MDW5 |  |  |  |  | 25
6ft |  | [NAME] |  |  |  |  | 30
Spreadsheet: 816229d1675435647-vacation-time-vacation-time-calculator
Sheet: Nora Twyman

Sick Time Calculated
Employee Name |  |  |  |  | Date of Hire | 2023 Used Sick Time | Previous Year Carry Over
[NAME] |  |  |  |  |  |  | 0.45
Payroll Week | Sunday-Saturday | Vacation | Holiday | Hours Worked | Weekly Total | [NAME] | Total Accrued Sick | Sick Used | Sick Available
Week Ending | 2023-01-07 00:00:00 | 9 | 8 | 17.17
Week Ending | 2023-01-14 00:00:00 |  | 8 | 26.21
Week Ending | 2023-01-21 00:00:00 |  |  | 35
Week Ending | 2023-01-28 00:00:00 | 7 |  | 25.1
Week Ending | 2023-02-04 00:00:00 |  |  | 33.37
Week Ending | 2023-02-11 00:00:00
Week Ending | 2023-02-18 00:00:00
Week Ending | 2023-02-25 00:00:00
Week Ending | 2023-03-04 00:00:00
Week Ending | 2023-03-11 00:00:00
Week Ending | 2023-03-18 00:00:00
Week Ending | 2023-03-25 00:00:00
Week Ending | 2023-04-01 00:00:00
Week Ending | 2023-04-08 00:00:00
Week Ending | 2023-04-15 00:00:00
Week Ending | 2023-04-22 00:00:00
Week Ending | 2023-04-29 00:00:00
Week Ending | 2023-05-06 00:00:00
Week Ending | 2023-05-13 00:00:00
Week Ending | 2023-05-20 00:00:00
Week Ending | 2023-05-27 00:00:00
Week Ending | 2023-06-03 00:00:00
Week Ending | 2023-06-10 00:00:00
Week Ending | 2023-06-17 00:00:00
Week Ending | 2023-06-24 00:00:00
Week Ending | 2023-07-01 00:00:00
Week Ending | 2023-07-08 00:00:00
Week Ending | 2023-07-15 00:00:00
Week Ending | 2023-07-22 00:00:00
Week Ending | 2023-07-29 00:00:00
Week Ending | 2023-08-05 00:00:00
Week Ending | 2023-08-12 00:00:00
Week Ending | 2023-08-19 00:00:00
Week Ending | 2023-08-26 00:00:00
Week Ending | 2023-09-02 00:00:00
Week Ending | 2023-09-09 00:00:00
Week Ending | 2023-09-16 00:00:00
Week Ending | 2023-09-23 00:00:00
Week Ending | 2023-09-30 00:00:00
Week Ending | 2023-10-07 00:00:00
Week Ending | 2023-10-14 00:00:00
Week Ending | 2023-10-21 00:00:00
Week Ending | 2023-10-28 00:00:00
Week Ending | 2023-11-04 00:00:00
Week Ending | 2023-11-11 00:00:00
Week Ending | 2023-11-18 00:00:00
Week Ending | 2023-11-25 00:00:00
Week Ending | 2023-12-02 00:00:00
Week Ending | 2023-12-09 00:00:00
Week Ending | 2023-12-16 00:00:00
Week Ending | 2023-12-23 00:00:00
Week Ending | 2023-12-30 00:00:00
Spreadsheet: 857854d1706722683-sum-hours-based-on-date-range-and-id-and-then-summarize-on-a-separate-tab-eot-sample-v2
Sheet: COSTA

Name | ID |  |  |  |  | CHARGE MONTH: |  |  |  | PAYROLL WORKSHEET
COSTA |  |  |  |  |  | 2023-11-01 00:00:00 |  |  |  | Schedule: | Weekly |  |  | Mo. [NAME]: |  |  |  | Hrly [NAME].: |  |  |  | Position: | Officer
 |  |  |  |  |  |  |  |  |  | Shift: | Swing |  |  | Stipends/UA |  |  |  | Bi-Wk Equiv.: |  |  |  | Union: | R08
LEAVE USAGE
TYPE | V | S | SF | CTO | HC | IH | PH |  |  |  |  |  | Hours Worked
DATE |  |  |  |  |  |  |  |  |  | Period # | Start | End | Regular | Holiday | Overtime | CTO | Total | Swing | S Due | Grave | G Due | Total Comp | OT Rate
 |  |  |  |  |  |  |  |  |  | 1 | 2023-10-22 00:00:00 | 2023-11-04 00:00:00 | 80
 |  |  |  |  |  |  |  |  |  | 2 | 2023-11-05 00:00:00 | 2023-11-18 00:00:00 | 80
 |  |  |  |  |  |  |  |  |  | 3 | 2023-11-19 00:00:00 | 2023-12-02 00:00:00 | 80
 |  | NO TIME TAKEN |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  |  |  |  |  | Total All OT Worked:
TOTAL |  |  |  |  |  |  |  |  |  |  |  |  | OT Reported by Dept:
 |  |  |  |  |  |  |  |  |  |  |  |  | Less Holiday RDO:
OVERTIME AUTHORIZED
REASON | DATE | FROM | TO | HOURS | EARN ID | PAY CODE | SWING | GRAVE |  |  |  |  |  | Difference:
FOOTBALL VS BOISE | 2023-11-04 00:00:00 | 1500 | 2330 | 8.5 | OTPR | 871-425P |  | 1.5
BOARD OF TRUSTEE MEETINGS | 2023-11-06 00:00:00 | 900 | 1330 | 4.5 | OTPR | 213-425P
BOARD OF TRUSTEE MEETINGS | 2023-11-07 00:00:00 | 700 | 2000 | 13 | CTO | 213-425P | 20
BOARD OF TRUSTEE MEETINGS | 2023-11-08 00:00:00 | 700 | 1700 | 10 | HOL(W) | 213-425P
VETERANS DAY - REG SHIFT | 2023-11-10 00:00:00 |  |  | 12 | HG6 | 213-425HP
FOOTBALL VS NEW MEXICO | 2023-11-18 00:00:00 | 1600 | 2345 | 7.8 | OTPR | 871-425P |  | 1.75
THANKSGIVING DAY - REG SHIFT | 2023-11-23 00:00:00 |  |  | 12 | HG6 | 213-425HP
Total
 |  |  |  | Regular Shift Differential Hours: |  |  |  | 180
 |  |  |  | Total Shift Differential Hours to Pay:
Spreadsheet: 32998d1229193708-trying-to-calculate-minutes-using-sumproduct-formula-scratch
Sheet: Sheet1

Date | Shift | Tag # | Stacker | Station | Product | Start Time | Finish Time | Total Time | Pcs | Pcs/Min | Samples | Usable | % Usable | Total Pcs
2008-12-12 00:00:00 | A | R35363 | Mazie | 1 | BFS | 06:30:00 | 07:20:00 | 0.03472222222222221 | 600 | 12.00000000000001 | 12 | 6 | 0.5 | 1101
2008-12-12 00:00:00 | A | R53623 | Mazie | 1 | BFS | 07:20:00 | 08:00:00 | 0.02777777777777779 | 501 | 12.525
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Stacker | Pcs | % of Product | Total Minutes | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Mazie | 1101 | 1 | 0.0625 | 12.23333333333333
Spreadsheet: 53248d1253156511-help-grouping-times-together-grouping
Sheet: Sheet1

Hey everyone, I need you help. I'm trying to make a formula that will take into account different periods of time and group them together to show how much time was spent in each group based on classification. In my list I will show you what my input is and what i'd like my end result to be. Thanks!
Type of work | Start time | End time | How many people working?
Labor | 04:00:00 | 06:00:00 | 2
Tech | 07:00:00 | 08:00:00 | 3
Maintainence | 07:00:00 | 08:00:00 | 4
Labor | 06:00:00 | 07:00:00 | 5
Tech | 09:00:00 | 10:00:00 | 6
Maintainence | 10:00:00 | 12:00:00 | 7
Ok now we got the list, I want to generate a report, I don't care how it looks I can fix that later. The rules are pretty simple. We take the classification and time spent on project and multiply it by the amount of people working. I know how to do that. What I don't know how to do however is group them together. For example I know how to make it do this..... Here is an example.
Type | Start Time | End Time | Billable Hours.
Labor | 04:00:00 | 06:00:00 | 4
Tech | 07:00:00 | 08:00:00 | 3
Maintanence | 07:00:00 | 08:00:00 | 4
Labor | 06:00:00 | 07:00:00 | 5
Tech | 09:00:00 | 10:00:00 | 6
Maintanence | 10:00:00 | 12:00:00 | 14
If you study the above you will notice that there were two calls of each type made in the day. However A labor call was made from 0400-0600 but also again at 0600-0700. This is basically an extension of the original call therefore I need to group it together. It would be billable hours of labor call 1 + billable hours of labor call 2 and start / end time would reflect overlap. like this.
Type | Start Time | End Time | Billable Hours.
Labor | 04:00:00 | 07:00:00 | 9
Tech | 07:00:00 | 08:00:00 | 3
Maintanence | 07:00:00 | 08:00:00 | 4
Tech | 09:00:00 | 10:00:00 | 6
Maintanence | 10:00:00 | 12:00:00 | 14
Basically put, an extension qualifies if the end time of one call overlaps the start time another call in the same category and if there is multiple calls. If there is a break between times it is counted again on a new log. In this next example, I'm gonna have two overlapping tech calls, one seperate tech call and a maintanence call just for a filler. As well as what I'd like my end result to be.
Type of work | Start time | End time | How many people working?
Tech | 04:00:00 | 06:00:00 | 1
Tech | 05:00:00 | 07:00:00 | 1
Maintainence | 07:00:00 | 08:00:00 | 1
Tech | 07:15:00 | 08:15:00 | 1
End Result…..
Type of work | Start time | End time | Billable Hours.
Tech | 04:00:00 | 07:00:00 | 4
Maintainence | 07:00:00 | 08:00:00 | 1
Tech | 07:15:00 | 08:15:00 | 1
Spreadsheet: 812564d1673254372-extract-data-example-layout-v2
Sheet: Weekly Data

Product Name | Product Data 2 | Product Data 3 | Product Data 4 | Product Data 5 | Product Data 6 | Product Data 7 | Product Data 8 | Product Data 9 | Product Data 10 | Product Data 11 | Product Data 12 | Product Data 13 | Product Data 14 | Product Data 15 | Product Data 16
Phone | electronic | 45 | 125 | 789 | 1.06 | 145 | 856 | 125 | 785 | 352 | 415 | 698 | 52115 | 1452 | online
Camera | photography | 321 | 3213 | 656 | 65 | 312 | 666 | 632 | 626 | 6574 | 556 | 632 | 65 | 65 | in store
Computer | electronic | 545 |  | 961 | 631 | 6 | 6 | 45 | 61296 | 9563 |  | 6563 | 652 | 6 | online
Phone | electronic | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14
Spreadsheet: 68532d1269043520-formula-disappears-generic-version
Sheet: Rpt Data

 | Company Name
 | test
 |  |  |  |  | 85000
 |  |  |  |  | 15000
 |  |  |  |  | 100000
 |  |  |  |  | 0.25
 |  |  |  |  | 0.039
 |  |  |  |  | 0.14
 |  |  |  |  | 0.6
 |  |  |  |  | 175131.3485113835
 |  |  |  |  | 291885.5808523059
 | EXPENSE CATEGORY |  |  |  | AMOUNT |  | PERCENT
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 | TOTAL |  |  |  | 0 |  | 1
 | MARKETING CATEGORY |  |  |  | AMOUNT
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 | TOTAL |  |  |  | 0
 | Total Expenses |  |  |  | 0
 | REVENUE CATEGORY |  |  |  | AMOUNT
 | 0 |  |  |  | 0 |  | 0
 |  |  |  |  | 0 |  | 0
 |  |  |  |  | 0 |  | 0
 |  |  |  |  | 0 |  | 0
 |  |  |  |  | 0 |  | 0
 | TOTAL |  |  |  | 0 |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 15000
 |  |  |  |  | -15000
Spreadsheet: bb70464d-afdd-4696-a467-474cd7ae5088
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
5630 | 41262 | [NAME] | Hertl (1948) | SVK | 158 | 00:12:40 | 00:01:20 | 01:15:04 | 00:01:13 | 00:20:14 | 1 | 01:50:34
Spreadsheet: 701613d1603847779-sorting-and-display-groups-of-data-entries-weather-and-roads-test-3-
Sheet: CountingData

Sample of INPUT Data to Generate the Weather and Roads Report - Safety School Zone |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] testing result
Time | Counter ID | Type | Direction From | Direction To | Count | Weather | Road | DateTime |  |  |  | UMI
 | new_admin | Adult | SE | NE | 5 | Wet Snow | Bare | 2020-08-22 00:00:00
 | new_admin | School | SE | NE | 5 | Wet Snow | Bare
 | new_admin | Pre-School | SE | NE | 5 | Wet Snow | Bare
 | new_admin | Adult | NE | SE | 5 | Rain | Wet
 | new_admin | School | NE | SE | 5 | Rain | Wet
 | new_admin | Pre-School | NE | SE | 5 | Rain | Wet
 | new_admin | Pre-School | SE | SW | 5 | Overcast | Bare
 | new_admin | School | SE | SW | 5 | Overcast | Bare
 | new_admin | Adult | SE | SW | 5 | Overcast | Bare
END | END | END | END | END | END | END | END | END | END | END | END | END
Final Weather and [NAME]
Time Start | Time End | Weather | Road
Spreadsheet: kim_ward__20788__customer D&B
Sheet: Sheet1

 |  |  | Western Retai Annual Customer Demand
 |  |  | Volume in Mmbtu
 |  |  | Expected Consumption |  |  | Dunn &
 |  |  | In 2001 |  |  | Bradstreet
SOCAL |  |  |  |  |  | Number
[NAME] |  |  | 119971 |  |  | 00-848-9569
Agricel |  |  | 84332
Aptco |  |  | 68774
Associated Assp |  |  | 44000 |  |  | 00-831-8057
[NAME] |  |  | 226274 |  |  | 00-828-7450
Granite Buelton |  |  | 110000 |  |  | 00-691-4642
Granite Bakersfield |  |  | 44304 |  |  | 00-691-4642
[NAME] |  |  | 137912 |  |  | 00-848-0584
Golden State |  |  | 95226 |  |  | 00-910-8671
ITW CIP Stampings |  |  | 142987 |  |  | 05-079-7679
JG Boswell |  |  | 294888 |  |  | 00-823-7505
Leprino Foods |  |  | 469987 |  |  | 00-707-6664
Luxfer |  |  | 68296 |  |  | 06-448-3704
[NAME] heat Treat |  |  | 67434 |  |  | 05-733-2017
Morgan Services |  |  | 24502 |  |  | 05-662-6922
Mission Hosp |  |  | 37094 |  |  | 06-760-7572
Real Fresh |  |  | 108173 |  |  | 00-913-3950
[NAME] |  |  | 364122 |  |  | 06-772-7313
St. Jude |  |  | 39477 |  |  | 06-760-7572
St. Joseph |  |  | 129600 |  |  | 06-760-7572
Valley |  |  | 30988 |  |  | 07-294-0307
St. Mary |  |  | 38212 |  |  | 06-760-7572
PGE
[NAME] |  |  | 260820 |  |  | 05-965-1117
Canan- Esc |  |  | 55590 |  |  | 05-965-1117
Canan-Gonz |  |  | 26222 |  |  | 05-965-1117
Canan-Madera |  |  | 398420 |  |  | 05-965-1117
Canan- [NAME] |  |  | 22485 |  |  | 05-965-1117
[NAME] |  |  | 565339 |  |  | 05-563-5593
Granite Coal |  |  | 140153 |  |  | 00-691-4642
Granite French |  |  | 85622 |  |  | 00-691-4642
Granite Watson |  |  | 90000 |  |  | 00-691-4642
Granite Sacra |  |  | 129089 |  |  | 00-691-4642
Granite Tracy |  |  | 136747 |  |  | 00-691-4642
Granite Rio Lind |  |  | 27333 |  |  | 00-691-4642
Leprino |  |  | 288339 |  |  | 00-707-6664
Mitsubishi |  |  | 487000 |  |  | 19-607-2334
Queen |  |  | 46760 |  |  | 06-760-7572
Santa Rosa |  |  | 55735 |  |  | 06-760-7572
St. Joe |  |  | 22542 |  |  | 06-760-7572
F & A Cheese |  |  | 350000 |  |  | 07-929-0722
Columbus [NAME] |  |  | 70000 |  |  | 17-775-1658
SDG&E
Superior Ready Mix |  |  | 90000
Leprino New Mexico |  |  | 751000 |  |  | 00-707-6664
Arizona
Hexcel |  |  | 182400 |  |  | 00-911-8563
AZ Pistachio |  |  | 74000
Total Physical Demand
Spreadsheet: 181fd2d5-b923-45f2-ba3d-dbbd79badfa3
Sheet: 2009-10

Table Q
Full Time Affiliate Student numbers
Department | Undergraduate |  |  | Graduate |  |  | Total
 | Home | Overseas | Total | Home | Overseas | Total
Anthropology | 1 | 11 |  | 2 | 0
Institute of Archaeology | 6 | 4 |  | 4 | 2
Bartlett School of Architecture | 0 | 0 |  | 0 | 1
Bartlett School of Planning | 6 | 4 |  | 3 | 1
Biochemical Engineering | 3 | 2 |  | 0 | 0
Division of Biosciences | 0 | 22 |  | 1 | 0
Centre for European Studies | 0 | 0 |  | 2 | 0
Centre for Intercultural Studies | 0 | 0 |  | 3 | 0
Chemical Engineering | 8 | 4 |  | 0 | 0
Chemistry | 3 | 3 |  | 0 | 0
Institute of Child Health | 0 | 6 |  | 1 | 0
Civil, Environmental and Geomatic Eng. | 3 | 4 |  | 2 | 2
Computer Science | 8 | 7 |  | 0 | 1
[NAME] and Literature | 6 | 0 |  | 0 | 0
Earth Sciences | 3 | 0 |  | 0 | 0
Eastman Dental Institute | 0 | 0 |  | 6 | 9
Economics | 0 | 44 |  | 5 | 0
Electronic and Electrical Engineering | 2 | 2 |  | 0 | 0
English Language and Literature | 1 | 44 |  | 0 | 0
European Social and Political Studies | 9 | 5 |  | 0 | 0
Slade School of Fine Art | 2 | 6 |  | 0 | 0
French | 27 | 8 |  | 0 | 0
Geography | 7 | 11 |  | 0 | 1
German | 20 | 0 |  | 0 | 0
Greek and Latin | 9 | 6 |  | 0 | 0
Hebrew and Jewish Studies | 0 | 1 |  | 1 | 0
History | 11 | 21 |  | 3 | 0
History of Art | 4 | 11 |  | 0 | 0
Italian | 27 | 0 |  | 0 | 0
Language Centre (Affiliates) | 9 | 204 |  | 0 | 0
Laws | 48 | 7 |  | 4 | 22
Management Science and Innovation | 1 | 1 |  | 0 | 0
Mathematics | 1 | 12 |  | 0 | 0
Mechanical Engineering | 0 | 3 |  | 0 | 0
UCL Medical School | 1 | 0 |  | 0 | 0
Medical Physics | 1 | 0 |  | 0 | 0
Philosophy | 0 | 8 |  | 1 | 0
Physics and Astronomy | 1 | 7 |  | 2 | 0
Political Science | 0 | 37 |  | 0 | 0
Division of Population Health | 0 | 0 |  | 1 | 0
Division of Psychology and Language Sciences | 7 | 37 |  | 1 | 0
Scandinavian Studies | 10 | 0 |  | 0 | 0
School of Slavonic and E. European Stds | 25 | 4 |  | 2 | 0
Science and Technology Studies | 0 | 5 |  | 0 | 1
Spanish and Latin American Studies | 15 | 1 |  | 0 | 0
Statistical Science | 5 | 1 |  | 0 | 0
Total
Faculty | Undergraduate |  |  | Graduate |  |  | Total
 | Home | Overseas | Total | Home | Overseas | Total
Arts and Humanities | 135 | 283 |  | 7 | 0
Biomedical Sciences | 1 | 6 |  | 8 | 9
Built Environment | 6 | 4 |  | 3 | 2
Engineering Sciences | 26 | 23 |  | 2 | 3
Laws | 48 | 7 |  | 4 | 22
Life Sciences | 7 | 59 |  | 2 | 0
Mathematical and Physical Sciences | 13 | 28 |  | 2 | 1
Social and Historical Sciences | 54 | 143 |  | 16 | 3
Total
As figures relate to the official HEFCE census date, 1 December, affiliate students who start in January are not included.