tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 798799d1664736996-formula-not-working-as-expected-display-x-when-duplicate-but-not-the-first-one-sample-34-
Sheet: Sheet1

Machine | [NAME] | Filter | Chosen | Disipline | Control | Current Score | Residual Score | Risk Reduction | Budget | $/Risk Reduction | Selected Low Risk | 18
 | Transmission hazards - finger/hand amp and crush in the chain and sprockets |  |  | M | Fixed barriers along control panel side and end. Ensure barriers are capble of impact from coil/crane impact without deformation or structural damage. Fixed barriers to extend out to the light curtain position. | 10 | 7
 |  |  |  | FS | Light curtain along loading side. 14[NAME] resolution. <40mm to ground. >1200mm high. Reach over position >550mm from hazard (edge of coil loader for simplicity). Approach speed position >500mm (based on 0.25[NAME] stopping time). Light curtain to stop coil loading carriage and the unwinder movement across to coil loader only. Other unwinder movement can continue. Reset buttons fitted to both ends of the light curtain. | 10 | 7
 | Finger draw in and crush in the carriage (rollers in guides, end strokes) |  |  | M | Fixed barriers along control panel side and end. Ensure barriers are capble of impact from coil/crane impact without deformation or structural damage. Fixed barriers to extend out to the light curtain position. | 10 | 7
 |  |  |  | FS | Light curtain along loading side. 14[NAME] resolution. <40mm to ground. >1200mm high. Reach over position >550mm from hazard (edge of coil loader for simplicity). Approach speed position >500mm (based on 0.25[NAME] stopping time). Light curtain to stop coil loading carriage and the unwinder movement across to coil loader only. Other unwinder movement can continue. Reset buttons fitted to both ends of the light curtain. | 10 | 7
 | Finger/hand crush between the carriage lifting plate and coil when the coil is being loaded onto unwinder or the coil and the machine frame when loading |  |  | M | Fixed barriers along control panel side and end. Ensure barriers are capble of impact from coil/crane impact without deformation or structural damage. Fixed barriers to extend out to the light curtain position. | 17 | 7
 |  |  |  | FS | Light curtain along loading side. 14[NAME] resolution. <40mm to ground. >1200mm high. Reach over position >550mm from hazard (edge of coil loader for simplicity). Approach speed position >500mm (based on 0.25[NAME] stopping time). Light curtain to stop coil loading carriage and the unwinder movement across to coil loader only. Other unwinder movement can continue. Reset buttons fitted to both ends of the light curtain. | 17 | 7
 | Fall >2.7m into pit |  |  | M | Fit edge potection barriers along the open side and along the end compliant with AS 1657. (100mm toeboard, 450mm mid rail, 950mm upper rail). Note this will need to be positioned inside the light curtain with enough clearance for the coils to pass by. | 18 | 14
Spreadsheet: 816539d1675690722-sort-unique-value-over-multiple-sheets-ignoring-zeros-book2
Sheet: TUE

Virgin Part No | Painted Part No | Customer | Product | Variant | Colour | Quantity | [NAME] | Plant
 | 66001547 |  |  |  |  | 20 | 1 | TRACK
 | 66001504 |  |  |  |  | 20 | 1 | TRACK
 | 66001209 |  |  |  |  | 120 | 3 | TRACK
 | 66001213 |  |  |  |  | 40 | 1 | TRACK
 | 15268301 |  |  |  |  | 1000 | 23 | TRACK
 | 74110109 |  |  |  |  | 40 | 10
 | 74110111 |  |  |  |  | 40
 | 74110105 |  |  |  |  | 30 | 10
 | 74110106 |  |  |  |  | 30 | 10
 | 74110107 |  |  |  |  | 30 | 10
 | 74110108 |  |  |  |  | 30 | 10
 | 74110112 |  |  |  |  | 40
 | 74110113 |  |  |  |  | 40
 |  |  |  | Trial Parts
 | GSM LETTERS | GSM | LETTERS | RANGE ROVER | SAMPLES | 40 | 2 | TRACK
Spreadsheet: 792696d1661085752-number-rows-in-ascending-order-excelforum1
Sheet: Sheet1

1 | 69 | 10
2 | 23 | 2
3 | 39 | 5
4 | 51 | 8
5 | 47 | 7
6 | 2 | 1
7 | 44 | 6
8 | 36 | 4
9 | 52 | 9
10 | 35 | 3
Spreadsheet: 100149d1298574812-calculate-average-over-variable-range-variable-average-exmpl
Sheet: Sheet1

Time | Value | Range from | Range To |  | Average with index |  | Average normal
1 | 0 | 2 | 11
2 | 50
4 | 100
4 | 150
5 | 200
6 | 250
7 | 300
8 | 400
9 | 450
10 | 500
Spreadsheet: chris_dorland__1638__11-01 1600
Sheet: NPCC

NPCC
 |  | Full Plant Capacity | Current Plant Output
 |  |  |  |  | Fuel | [NAME] | Unit | On/Off | On/Off | On/Off | On/Off | Comments
OPERATOR | Plant |  |  | Unit # | Type | Heat Rate | Capacity | @ 0630 | @ 0900 | @ 1200 | @1600
PGET | Brayton Point |  |  | 1 | Coal | 9799 | 240 |  |  |  |  | weather
PGET | Brayton Point |  |  | 2 | Coal | 9484 | 240
PGET | Brayton Point |  |  | 3 | Coal | 8984 | 640
PGET | Brayton Point |  |  | 4 | FO6 | 10655 | 475
Wisvest | Bridgeport Harbor |  |  | 1 | FO6 | 10171 | 80 | Off | Off | Off | Off
Wisvest | Bridgeport Harbor |  |  | 2 | FO6 | 9912 | 180 | On | On | Off | Off
Wisvest | Bridgeport Harbor |  | 0 | 3 | Coal | 9640 | 400 | Off | Off | Off | Off
Duke | Bridgeport Energy |  |  | 1 | Gas | 12392 | 170 | On | On | On | On
Duke | Bridgeport Energy |  | 340 | 2 | Gas | 12392 | 170 | On | On | On | On
Southern | Canal |  |  | 1 | FO6 | 8991 | 580 | Off | Off | Off | Off
Southern | Canal |  | 580 | 2 | FO6 | 9662 | 580 | On | On | On | On
PGET | [NAME] |  |  | 9 | Gas | 7782 | 165 | On | On | On |  | weather
PGET | [NAME] |  |  | 10 | Gas | 10540 | 165 | On | On | On
PGET | [NAME] |  |  | 11 | Gas | 10540 | 165 | Off | Off | On
NU | Merrimack |  |  | 1 | Coal | 9721 | 115 | On | On | On | On
NU | Merrimack |  | 460 | 2 | Coal | 9628 | 345 | On | On | On | On
NRG | Middletown |  |  | 1 | FO6 | 10505 | 65 | Off | Off | Off | Off
NRG | Middletown |  |  | 2 | FO6 | 9698 | 115 | On | On | On | On
NRG | Middletown |  |  | 3 | FO6 | 8995 | 235 | On | On | On | On
NRG | Middletown |  | 750 | 4 | FO6 | 10831 | 400 | On | On | On | On
Sithe | Mystic |  |  | 4 | FO6 | 9872 | 155 | On | On | On | On
Sithe | Mystic |  |  | 5 | FO6 | 10777 | 155 | On | On | On | On
Sithe | Mystic |  |  | 6 | FO6 | 9861 | 155 | Off | Off | Off | Off
Sithe | Mystic |  | 925 | 7 | FO6 | 9597 | 615 | On | On | On | On
Sithe | New Boston |  |  | 1 | Gas | 9737 | 360 | On | On | On | On
Sithe | New Boston |  | 360 | 2 | Gas | 9831 | 360 | Off | Off | Off | Off
Wisvest | New Haven Harbor | 465 | 465 | 1 | FO6 | 9373 | 465 | On | On | On | On
NU | Newington | 415 | 0 | 1 | FO6 | 10699 | 415 |  | Off | Off | Off
NRG | Norwalk Harbor |  |  | 1 | FO6 | 9625 | 165 | Off | Off | Off | Off
NRG | Norwalk Harbor |  | 0 | 2 | FO6 | 9572 | 165 | Off | Off | Off | Off
PGET | Salem Harbor |  |  | 1 | Coal | 10405 | 80 | On | On | On | On
PGET | Salem Harbor |  |  | 2 | Coal | 10600 | 80 | On | On | On | On
PGET | Salem Harbor |  |  | 3 | Coal | 10312 | 165 | On | On | On | On
PGET | Salem Harbor |  | 325 | 4 | FO6 | 10595 | 475 | Off | Off | Off | Off
NU | [NAME] |  |  | CW1 | FO2 |  | 105 | Off | Off | Off | Off
NU | [NAME] |  |  | CT1 | FO2 | 11425 | 85 | Off | Off | Off | Off
NU | [NAME] |  |  | CT2 | FO2 | 11425 | 85 | Off | Off | Off | Off
NU | [NAME] |  |  | CT3 | FO2 |  | 85 | Off | Off | Off | Off
NU | [NAME] |  | 85 | 1 | FO2 |  | 85 | On | On | On | On
FPL | Wyman |  |  | 3 | FO6 | 10702 | 115 | On | On | On | On
FPL | Wyman |  | 745 | 4 | FO6 | 10745 | 630 | On | On | On | On
Spreadsheet: 217467d1362074711-help-needed-need-sum-value-based-upon-3-criteria-excel_1-modified-by-tigeravatar-
Sheet: Sheet1

2013-04-01 00:00:00 | 267
 | 176
 | 207
 | 269
 | 318
 | 334
 | 339
 | 907
 | 1061
 | 1905
 | 1352
 | 1117
Winter |  | << Winter months will be the SUM of DEC, JAN & FEB
Load Factor
NOTE: Column A1:A12 - dates will change depending up on the contract start month
=IF(OR(MONTH(A1)={11,12,1,2,3}),"WIN",IF(OR(MONTH(A12)={4,5,6,7,8,9,10}),"SUM",""))
Spreadsheet: 453783d1459442152-complicated-formula-help-lookup-row-and-then-add-certain-cells-until-count-is-met-sample-1-
Sheet: Master

 | Initial Handicap Factor |  |  | Event 1 | Event 2 | Event 3 | Event 4 | Event 5 | Event 6
Competitor 1 | 0.98
Competitor 2 | 1.02
Competitor 3 | 0.96
Competitor 4 | 0.85
Competitor 5 | 1.12
Competitor 6 | 1.05
Spreadsheet: 813554d1673857640-vlookup-multiple-criteria-and-sheets-vlookup-sample
Sheet: Sheet2

 |  |  |  |  |  |  | Name |  |  | date |  | ID |  |  | Amount
0 | 0 | 0 | 0 | 0 | 0 | 0 | ABC | 0 | 0 | 2023-01-10 00:00:00 | 0 | 121212 | 0 | 0 | 4213 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | ABC | 0 | 0 | 2023-01-10 00:00:00 | 0 | 636363 | 0 | 0 | 764 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | ABC | 0 | 0 | 2023-01-10 00:00:00 | 0 | 242424 | 0 | 0 | 657 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | ABC | 0 | 0 | 2023-01-10 00:00:00 | 0 | 323232 | 0 | 0 | 6567 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | BOB | 0 | 0 | 2023-01-10 00:00:00 | 0 | 121212 | 0 | 0 | 675 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | BOB | 0 | 0 | 2023-01-10 00:00:00 | 0 | 636363 | 0 | 0 | 787 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | BOB | 0 | 0 | 2023-01-10 00:00:00 | 0 | 242424 | 0 | 0 | 5645 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | [NAME] | 0 | 0 | 2023-01-10 00:00:00 | 0 | 121212 | 0 | 0 | 2342 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | [NAME] | 0 | 0 | 2023-01-10 00:00:00 | 0 | 636363 | 0 | 0 | 756 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | [NAME] | 0 | 0 | 2023-01-10 00:00:00 | 0 | 242424 | 0 | 0 | 232 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | Scott | 0 | 0 | 2023-01-10 00:00:00 | 0 | 121212 | 0 | 0 | 654 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | Scott | 0 | 0 | 2023-01-10 00:00:00 | 0 | 636363 | 0 | 0 | 787 | 0
Spreadsheet: 101799d1299845373-using-data-from-different-worksheets-feb-team-target
Sheet: TOTAL

Agent | Ski Tar | Lakes T | Ski Ach | Lakes Ac | Agt [NAME] | Tot Pax | Tot Book | Extra Tar | [NAME] | % Dir Ski | % Dir Lake | Calls | Conv | Enq | Conv
Chrissy | 78 | 12 | 196 | 8 |  |  |  |  |  | 2.51 | 0.67
Clare | 68 | 11 | 97 | 14 |  |  |  |  |  | 1.43 | 1.27
[NAME] | 68 | 11 | 82 | 2 |  |  |  |  |  | 1.21 | 0.18
Grace | 56 | 8 | 92 | 6 |  |  |  |  |  | 1.64 | 0.75
[NAME] | 78 | 11 | 143 | 12 |  |  |  |  |  | 1.83 | 1.09
Kallie | 43 | 8 | 27 | 2 |  |  |  |  |  | 0.63 | 0.25
Meegan | 78 | 12 | 148 | 11 |  |  |  |  |  | 1.9 | 0.92
[NAME] | 35 | 6 | 30 | 0 |  |  |  |  |  | 0.86 | 0
[NAME] | 60 | 8 | 72 | 15 |  |  |  |  |  | 1.2 | 1.88
[NAME] | 564 | 87 | 887 | 70
[NAME] | 78 | 12 | 86 | 8 |  |  |  |  |  | 1.1 | 0.67
Olivia | 78 | 12 | 78 | 5 |  |  |  |  |  | 1 | 0.42
Charlotte | 36 | 7 | 56 | 4 |  |  |  |  |  | 1.56 | 0.57
TTL ROE | 192 | 31 | 220 | 17
[NAME] | 66 | 14 | 58 | 22 |  |  |  |  |  | 0.88 | 1.57
[NAME] | 66 | 14 | 124 | 13 |  |  |  |  |  | 1.89 | 0.93
Ian | 66 | 14 | 64 | 21 |  |  |  |  |  | 0.97 | 1.5
[NAME] | 45 | 10 | 33 | 21 |  |  |  |  |  | 0.73 | 2.1
[NAME] | 48 | 10 | 36 | 19 |  |  |  |  |  | 0.75 | 1.9
[NAME] | 38 | 7 | 40 | 15 |  |  |  |  |  | 1.05 | 2.14
Sagar | 66 | 14 | 58 | 15 |  |  |  |  |  | 0.88 | 1.07
[NAME] | 66 | 14 | 78 | 16 |  |  |  |  |  | 1.18 | 1.14
TTL ITALY | 461 | 97 | 491 | 142
Alana | 35 | 8 | 35 | 15 |  |  |  |  |  | 1 | 1.88
Amanda | 36 | 7 | 15 | 6 |  |  |  |  |  | 0.42 | 0.86
[NAME] | 34 | 7 | 39 | 2 |  |  |  |  |  | 1.15 | 0.29
[NAME] | 43 | 8 | 57 | 13 |  |  |  |  |  | 1.33 | 1.63
[NAME] | 42 | 7 | 21 | 18 |  |  |  |  |  | 0.5 | 2.57
Rainer | 27 | 6 | 25 | 2 |  |  |  |  |  | 0.93 | 0.33
[NAME] | 49 | 9 | 75 | 8 |  |  |  |  |  | 1.53 | 0.89
[NAME] | 35 | 6 | 37 | 4 |  |  |  |  |  | 1.06 | 0.67
Suzanne | 45 | 8 | 35 | 4 |  |  |  |  |  | 0.77 | 0.5
TTL AUS | 346 | 66 | 339 | 72
Spreadsheet: 837140d1689876186-indirect-a1-a5-and-a1-to-spill-a1-from-other-sheets-doesnt-work-how-could-i-do-it-example-2
Sheet: ANALYSIS

Location: | London |  |  | This is not a problem, Its just to illustrate.
Path
 |  |  | Client
 | This Table is where I want to look at the end.
 | I want to see the total amount paid by each client in the BDD
 | I also want to see the total amount that would have been paid if ONE client did all the purchase
 | To do that I have in total:
 | 2 data base that I put at the end of the year and that stay forever in this excel file.
 | 6 pricing sheets that changes every year, Sometimes I add 1 or delete one.
 | A settings tab that connect the Pricing sheets with the Mapping
 | The analysis tab connect the DB with the Mapping
 | So now my mapping connects pricing sheets and DB
 | And my problem is in the MAPPING TAB
 | Also All the data I used are random.
Spreadsheet: 63106d1264067318-vlookup-function-example
Sheet: Sheet1

A | 15
B | 30
C | 45
D | 60
 |  | January | February | March
1 | [NAME] | A |  | A
2 | Mark | C |  | D
3 | [NAME]
4 | [NAME] | A | B | C
 |  | January | February | March
1 | [NAME] | 15 | 0 | 15
2 | Mark | 45 | 0 | 60
3 | [NAME] | 0 | 0 | 0
4 | [NAME] | 15 | 30 | 45
Spreadsheet: 729745d1619301165-help-with-countif-formula-for-calendar-countif-any-date-in-table-present-schedule-workbook-stat-holiday-help
Sheet: Sheet1

Region | Month | Item | Sales |  | Region | North
North | Jan | Apples | 100 |  | Month | Feb
North | Jan | Bananas | 120 |  | Item | Apples
North | Feb | Apples | 115 |  | Sales
North | Feb | Bananas | 130
North | Mar | Apples | 135
North | Mar | Bananas | 125 |  | Match
South | Jan | Apples | 110
South | Jan | Bananas | 140
South | Feb | Apples | 115
South | Feb | Bananas | 120
South | Mar | Apples | 155
South | Mar | Bananas | 105
Spreadsheet: 758575d1638955944-rand-names-on-exact-date-book1
Sheet: Sheet1

Number: | Date:
3 | 2021-12-01 00:00:00 |  |  |  | Enter number of names in A2
 |  |  |  |  | Enter Date in B2
Name: | Date: |  | Custom.Name: |  | On the Data Tab, click on Refresh All
[NAME] | 2021-12-01 00:00:00 |  | [NAME]
Anne | 2021-12-01 00:00:00 |  | Anne
[NAME] | 2021-12-01 00:00:00 |  | [NAME]
Mark | 2021-12-01 00:00:00
[NAME] | 2021-12-02 00:00:00
[NAME] | 2021-12-02 00:00:00
[NAME] | 2021-12-02 00:00:00
[NAME] | 2021-12-03 00:00:00
[NAME] | 2021-12-03 00:00:00
[NAME] | 2021-12-03 00:00:00
Spreadsheet: 111710d1308044252-excel-2007-how-to-count-based-on-months-and-parts-product-calculation
Sheet: Master Info

Product no. | Product description | Comprised of part no.:
044313 | D190/140x1710 | 040952-32P | 040952-53P | 041320-30P
044286 | D240/180X2160 | 044286-40P | 044286-41P
044409 | D260/190x2630 | 043737-32P | 043737-53P | 043737-30P
044410 | [NAME] | 040953-30P | 040954-53P
043128 | D190/140X1940 | 040952-32P | 040952-53P | 041312-30P
044032 | D220/180x2780 | 044029-40P | 044032-45P
041636 | [NAME] | 040876-32P | 041636-53P | 041320-30P
044031 | D200/140x210 | 044032-25P
044029 | D150/125x2500 | 044029-40P | 044029-45P
044527 | D230/160x2290 | 044286-40P | 044527-41P
044559 | D215/150x2080 | 044559-40P | 040954-53P
042173 | D200/140x2080 | 042173-32P | 041106-53P | 041106-30P
Spreadsheet: 3e3644c7-0a87-446e-987c-61ec3741526e
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 | Risk Integrator
 | Input your patient's information (red numbers) |  |  |  |  | Results
 |  |  |  |  |  |  | CAC score category
 | Age - | 60 |  |  | Pre-test 10-year CHD Risk estimate:
 | Male (1) or [NAME] (0) - | 0 |  |  |  | 0.1457436672945595 | (N/A)
 | Systolic Blood Pressure - | 150
 | Diastolic Blood Pressure - | 90
 | [NAME] | 155 |  |  | Proportion of scores falling into each category:
 | HDL cholesterol - | 40 |  |  |  | 0.4720243729231722 | 0
 | Tobacco use? (1 or 0) - | 0 |  |  |  | 0.3641482949437063 | 1-100
 | Diabetes mellitus? (1 or 0) - | 0 |  |  |  | 0.1157031419225597 | 101-400
 |  |  |  |  |  | 0.0481241902105617 | >400
 | Assumption (1 or 2) - | 1
 | CAC score-specific relative risks for CHD events |  |  |  | Post-test 10-year CHD Risk estimate:
 | 1=conservative (blinded outcome adjudication studies only) |  |  |  |  | 0.09104183016353562 | 0
 | 2=optimistic (base case scenario from meta-analysis) |  |  |  |  | 0.1502574667538349 | 1-100
 |  |  |  |  |  | 0.2510974786798067 | 101-400
 |  |  |  |  |  | 0.3410365765077886 | >400
 | if CAC score is: | 1-year risk is: |  | 10-year risk is: | (rounded)
 | 0 | 0.009500205549515481 |  | 0.09104183016353562 | 0.09104183016353562
 | 1-100 | 0.01615034943417632 |  | 0.1502574667538349 | 0.1502574667538349
 | 101-400 | 0.02850061664854645 |  | 0.2510974786798067 | 0.2510974786798067
 | >400 | 0.04085088386291657 |  | 0.3410365765077886 | 0.3410365765077886
Spreadsheet: 63680d1264568885-excel-2007-count-repeat-names-count_names
Sheet: 214th Master List

NO SHOW MASTER LIST |  |  | Total for PT
DATE | [NAME]'S NAME | TIME |  |  | Should Read
2010-01-04 00:00:00 | DOE, [NAME] | 1110 |  |  | <---  1
2010-01-04 00:00:00 | DOE, [NAME] | 1100 |  |  | <---  2
2010-01-04 00:00:00 | CARR, JANICE | 1310 |  |  | <---  2
2009-01-05 00:00:00 | DOUGLAS, [NAME] | 1010 |  |  | <---  1
2009-01-05 00:00:00 | CHRISTOPHER, SUE | 0820 |  |  | <---  1
2010-01-12 00:00:00 | [NAME], BONNIE | 1400 |  |  | <---  1
2010-01-12 00:00:00 | BIBBEE, JERRY | 1310 |  |  | <---  3
2010-01-12 00:00:00 | GREENFIELD, [NAME] | 0830 |  |  | <---  1
2010-01-12 00:00:00 | THOMPSON, CATHERINE | 0840 |  |  | <---  3
2010-01-12 00:00:00 | COWGER, MATHEW | 1000 |  |  | <---  1
2010-01-12 00:00:00 | SHANNON, GEORGE | 1130 |  |  | <---  1
2010-01-12 00:00:00 | CISTRUNK, REPEAT | 1300 |  |  | <---  3
2010-01-13 00:00:00 | [NAME], RENEE | 1130 |  |  | <---  2
2010-01-14 00:00:00 | BLADE, RYAN | 1440 |  |  | <---  1
2010-01-14 00:00:00 | LINDSTROM, DANIEL | 0810 |  |  | <---  1
2010-01-14 00:00:00 | ERB, RONALD | 1120 |  |  | <---  1
2010-01-14 00:00:00 | HANSON, [NAME] | 0920 |  |  | <---  1
2010-01-14 00:00:00 | CURRY, JOE | 0930 |  |  | <---  1
2010-01-14 00:00:00 | THOMPSON, CATHERINE | 1100 |  |  | <---  3
2010-01-14 00:00:00 | HAAN, [NAME] | 1420 |  |  | <---  1
2010-01-19 00:00:00 | BOURQUE, MICHELLE | 0920 |  |  | <---  1
2010-01-21 00:00:00 | SHAFER, JOHN | 0930 |  |  | <---  1
2010-01-21 00:00:00 | THOMPSON, CATHERINE | 1030 |  |  | <---  3
2010-01-21 00:00:00 | CARR, JANICE | 0820 |  |  | <---  2
2010-01-21 00:00:00 | BIBBEE, JERRY | 0920 |  |  | <---  3
2010-01-21 00:00:00 | CISTRUNK, REPEAT | 1640 |  |  | <---  3
2010-01-22 00:00:00 | TRUAX, DERRICK | 0820 |  |  | <---  1
2010-01-25 00:00:00 | MCKITTRICK, CHRISTOPHER | 1540 |  |  | <---  1
2010-01-25 00:00:00 | CISTRUNK, REPEAT | 1010 |  |  | <---  3
2010-01-26 00:00:00 | SHANNON, BILLY | 0932 |  |  | <---  1
2010-01-26 00:00:00 | GREENFIELD, DANIEL | 0936 |  |  | <---  1
2010-01-26 00:00:00 | DOE, [NAME] | 0938 |  |  | <---  2
2010-01-26 00:00:00 | [NAME], RENEE | 1000 |  |  | <---  2
2010-01-26 00:00:00 | BIBBEE, JERRY | 1123 |  |  | <---  3
Spreadsheet: 776235d1649620727-sum-category-by-month-book2
Sheet: Summary

Total expenses for the year
 | Van | Truck | [NAME] | Pam
101
102
201
202
Van, [NAME], and [NAME]
 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
101
102
201
202
Pam Expenses
 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
Cash
Check
Credit Card
Spreadsheet: 56573d1256744892-filter-records-based-on-selection-24847373
Sheet: Employee Data

Emp. # | Name | Title | Department | Hiring Date
11111 | [NAME] | Agent | A Team | 2009-10-02 00:00:00
22222 | [NAME] | Agent | A Team | 2009-10-03 00:00:00
33333 | [NAME] 3 | Agent | B Team | 2009-10-04 00:00:00
44444 | [NAME] | Agent | B Team | 2009-10-05 00:00:00
55555 | [NAME] | Agent | C Team | 2009-10-06 00:00:00
66666 | [NAME] 6 | Agent | C Team | 2009-10-07 00:00:00
Spreadsheet: 883520d1732130986-excel-lookup-formula-excel-lookup-formula-if-multiple-ingredients-
Sheet: Sheet5 (2)

 |  |  |  |  |  |  |  |  |  |  |  | =TOCOL(IFS(ISNUMBER(SEARCH(H4:K4,F5:F16)),H4:[NAME])
 |  |  |  |  | Name | Type of Food | Cheese | Fish | Ham | Bread
 |  |  |  |  | Cheesecake
 |  |  |  |  | Fishsauce | Fish
 |  |  |  |  | Hamhock | Ham
 |  |  |  |  | Breadsand | Bread
 |  |  |  |  | Cheesesteak | Cheese
 |  |  |  |  | Breadsauce | Bread
 |  |  |  |  | Breadcake | Bread
 |  |  |  |  | Fishtreacle | Fish
 |  |  |  |  | Cheesestick | Cheese
 |  |  |  |  | Hamcake | Ham
 |  |  |  |  | Hamsteak | Ham
 |  |  |  |  | BreadCheese | Cheese, Bread
Spreadsheet: 5678d9c3-1558-47a4-a709-ed515084649c
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2
Please click on required table number:
Child Measurement Data |  | Definition
4.2.1 | Percentage of Children at School-Entry Age who are Overweight by Locality, LA and PCT: 2006/07 | Click here for data definition
4.2.2 | Percentage of Children at School-Entry Age who are Overweight by Locality, LA and PCT - Gender Split: 2006/07
4.2.3 | Percentage of Children at School-Entry Age who are Overweight by Locality, LA and PCT - 3 Year Trend: 2004/05 to 2006/07
4.2.4 | Percentage of Children at School-Entry Age who are Overweight by Locality, LA and PCT - 6 Year Trend: 2001/02 to 2006/07 (Single Years)
4.2.5 | Percentage of Children at School-Entry Age who are Overweight by Locality, LA and PCT - 6 Year Trend: 2001/02 to 2006/07 (3-Years Pooled)
4.2.6 | Percentage of Children at School-Entry Age who are Overweight by Locality, LA and PCT - 3 Years Pooled: 2004/05 to 2006/07
4.2.7 | Percentage of Children at School-Entry Age who are Overweight by Locality, LA and PCT - 5 Years Pooled: 2002/03 to 2006/07
4.2.8 | Percentage of Children at School-Entry Age who are Overweight by Ward - 3 and 5 Years Pooled: 04/05 to 06/07 & 02/03 to 06/07
4.2.9 | Percentage of Children in Year 6 (10 and 11 Year Olds) who are Overweight by Locality, LA and PCT: 2006/07
4.2.10 | Percentage of Children in Year 6 (10 and 11 Year Olds) who are Overweight by Locality, LA and PCT - Gender Split: 2006/07
4.2.11 | Percentage of Children in Year 6 (10 and 11 Year Olds) who are Overweight by Locality, LA and PCT - 2 Year Trend: 2005/06 to 2006/07
4.2.12 | Percentage of Children who are Overweight - Year R & Year 6 Comparison: 2006/07
4.2.13 | Percentage of Children who are Overweight by Level of Deprivation - Worst Vs Best Quintile of Wards (IMD 2007): 2006/07 | Click here for data definition
4.2.14 | Percentage of Children in Year 6 who are Overweight by Educational Attainment at KS2 - Worst Vs Best Quintile of Schools: 2006/07 | Click here for data definition
Spreadsheet: 329915d1404455986-multiply-rows-with-a-value-before-adding-sample
Sheet: Sheet1

 |  | 1 | 0 | 0 | 1 | 1 | 1 | 0 | 1 | 1 | 1
TOTAL 1 |  | 3 | 4 | 5 | 6 | 7 | 8 | 6 | 4 | 33 | 7
TOTAL 2 |  | 20 | 9 | 89 | 67 | 4 | 7 | 5 | 6 | 45 | 4
TOTAL 3 |  | 6 | 6 | 6 | 6 | 5 | 4 | 6 | 6 | 6 | 5
Spreadsheet: 116677d1311979418-calculating-the-minutes-for-a-period-during-a-time-frame-date
Sheet: Dates

 |  |  |  |  |  |  |  | # of minutes between…
 |  |  |  |  |  |  |  | Midnight-1am | 1am-2am | 2am-3am | 3am-4am | 4am-5am | 5am-6am | 6am-7am | 7am-8am | 8am-9am | 9am-10am | 10am-11am | 11am-12noon | 12noon-1pm | 1pm-2pm | 2pm-3pm | 3pm-4pm | 4pm-5pm | 5pm-6pm | 6pm-7pm | 7pm-8pm | 8pm-9pm | 9pm-10pm | 10pm-11pm | 11pm-12mid
Start Day/Time | End Day/time | Days | [NAME] | Start Hour | End Hour | Start Minute | End Minute | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | Hours-Check
2011-01-01 22:39:00 | 2011-01-02 00:33:00
2011-01-01 23:09:00 | 2011-01-02 00:10:00
2011-01-01 23:28:00 | 2011-01-02 00:46:00
2011-03-26 23:48:00 | 2011-03-27 01:41:00
2011-07-11 22:55:01 | 2011-07-13 06:30:00
2011-05-28 20:21:25 | 2011-05-30 03:58:00
2011-05-28 23:45:28 | 2011-05-30 12:30:00
2011-06-16 23:26:09 | 2011-06-23 02:22:00
2011-05-04 03:53:00 | 2011-05-19 13:20:00