tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 181260d1347977727-converting-unusual-time-format-valueofcomplextimeformat
Sheet: Sheet2

 | D | H | M | S | Total
4d 15h 10m
4d 16h 28m
12m
5m
1h 40m
1h 40m
58s
58s
22h 38m
59s
4d 23h 32m
5m
6d 11h 53m
5m
22d 9h 51m
22d 9h 51m
22d 9h 51m
22d 9h 51m
22d 9h 51m
22d 9h 51m
22d 9h 51m
6m
6m
36d 7h 51m
36d 7h 51m
117d 12h 15m
 | You can Hide these Columns
Spreadsheet: 680515d1591069463-finding-max-for-each-day-from-date-time-data-set-book1
Sheet: Sheet1

 |  |  |  | [NAME]
2020-04-08 00:05:00 | 7 |  |  | Date | Flow
 | 6
 | 8
 | 5
 | 6.5
 | 2
2020-04-09 00:05:00 | 6
 | 8.5
 | 1
 | 5
 | 6
 | 8
2020-04-10 00:05:00 | 6
 | 6
 | 7
 | 5
 | 9
Spreadsheet: 46c653b3-a5de-4ccb-aae9-3e2e3f32e915
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Factor | Null df | Alternative df | Null deviance | Alternative deviance | Test df | Test deviance | Test P-value
Parental type | 3 | 4 | -12026.8 | -12097.4 | 1 | 70.6 | <0.0001
Site | 3 | 4 | -12037.6 | -12097.4 | 1 | 59.8 | <0.0001
Parental type x site | 4 | 5 | -12097.4 | -12512.6 | 1 | 415.3 | <0.0001
Analysis of the effect of parental type (LMC vs. SWB) and field site on the composite of two components of fitness modeled by the
following directional graph: 1-> survival to flowering -> number of flowers produced.
Spreadsheet: 0c1f4102-6b35-44f4-852b-428f6e0a9765
Sheet: CSR At risk K

BASE SALARIES
FRINGE BENEFITS | 2012 | 2013
[NAME]
WORKER'S COMP
UNEMP INS
MEDICARE
MEDICAL INS
OTHER
Total
M200
SALARIES
FRINGE BENEFITS
[NAME]
WORKER'S COMP
UNEMP INS
MEDICARE
MEDICAL INS
OTHER
Total
M300
SALARIES
FRINGE BENEFITS
[NAME]
 |  |  | 0 | 0
WORKER'S COMP
UNEMP INS
MEDICARE
MEDICAL INS
OTHER
Total
E670
SALARIES
FRINGE BENEFITS
[NAME]
WORKER'S COMP
UNEMP INS
MEDICARE
MEDICAL INS |  |  |  | 0
OTHER
Total
E671
SALARIES
FRINGE BENEFITS
[NAME]
WORKER'S COMP
UNEMP INS
MEDICARE
MEDICAL INS |  |  | 0
OTHER
Total
E601 PERS
SALARIES
FRINGE BENEFITS
[NAME]
WORKER'S COMP
UNEMP INS
MEDICARE
MEDICAL INS | 0 | 0 | 0 | 0
OTHER
Total
MEDICAL INS
Total should be
Costs are included in CSR worksheets and under the CSR total in DSA Summ.  This is the amount that should be in Cat 18
Spreadsheet: 745564d1630000758-need-assistance-with-a-lookup-function-bool12
Sheet: Sheet1

 |  |  | 2022-05-01 00:00:00 | plan progress |  |  | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00
 |  |  | a |  |  | a | 23 | 25 | 34 | 37 | 50 | 55
 |  |  | b |  |  | b | 45 | 48 | 50 | 52 | 53 | 60
 |  |  | c |  |  | c | 56 | 60 | 65 | 67 | 70 | 100
 |  |  | d |  |  | d | 35 | 37 | 40 | 43 | 45 | 50
 |  |  | e |  |  | e | 12 | 15 | 27 | 40 | 45 | 68
Spreadsheet: 89420d1289228458-help-with-counting-columns-sample-worksheet
Sheet: Sheet1

SIGN TYPE | SIGN TEXT
E | EVACUATION PLAN
B.1 | WOMEN
B.1 | MEN
B | STORAGE
B | JANITOR
B | STORAGE
 | NO SIGN
 | NO SIGN
 | NO SIGN
 | NO SIGN
B | AUDITORIUM
B | AUDITORIUM
B | AUDITORIUM
B | AUDITORIUM
B | STORAGE
B | COMM ROOM
B | PROJECTION ROOM
B | GREEN ROOM
B | GREEN ROOM
B | STORAGE
B | CATERING
B | JANITOR
B | TO EQUIPMENT ROOM
B | TO EQUIPMENT ROOM
 | NO SIGN
 | NO SIGN
B | DIMMING ROOM
 | NO SIGN
 | NO SIGN
 | NO SIGN
 | NO SIGN
 | NO SIGN
 | NO SIGN
1.3 | 1 CENTRAL
B | ELEVATOR CONTROL ROOM
 | NO SIGN
 | NO SIGN
B | CC OFFICE
B | MAIN ACCESS CONTROL CENTER
I | LOGO
B | SECURITY OPERATIONS CENTER
O | OCCUPANT NAME
O | OCCUPANT NAME
B | PHYSICAL SECURITY MONITORING and ACCESS CENTER
B | EQUIPMENT ROOM
B | GUARDMOUNT ROOM
B | SECURITY OPERATIONS CENTER STORAGE
B | SERVICE ELEVATOR LEVEL 1
B | SERVICE DESK
B | STAGING AREA
B | FACILITIES MANAGEMENT
 | NO SIGN
O | CONVENIENCE STORE
O | OFFICE
B | STORAGE
O | COFFEE SHOP
B | STORAGE
B | SCANNING ROOM
B | ER
 | NO SIGN
 | NO SIGN
B | FIRE CONTROL CENTER
C | MEETING ROOM
B | SMALL BUSINESS
O | OCCUPANT NAME
O | OCCUPANT NAME
 | NO SIGN
C | MEETING ROOM
O | OCCUPANT NAME
B | STORAGE
B | HUMAN RESOURCES
C | BREAK-OUT
C | TRAINING ROOM
B | STORAGE
B | STORAGE
C | TRAINING ROOM
C | BREAK-OUT
B.1 | WOMEN
B.1 | MEN
B | STORAGE
B.1 | WOMEN
B | JANITOR
B.1 | MEN
B | FIRE ALARM CLOSET
B | MECHANICAL ROOM
B | ELECTRICAL ROOM
B | COMM ROOM
B | COMM ROOM
B | ELECTRICAL ROOM
B | MECHANICAL ROOM
B | FIRE ALARM CLOSET
B.1 | MEN
B | JANITOR
B.1 | WOMEN
1.3 | 1 EAST
O | OPEN OFFICE
O | OPEN OFFICE
O | OCCUPANT NAME
O | OCCUPANT NAME
O | OCCUPANT NAME
O | OCCUPANT NAME
 | NO SIGN
 | NO SIGN
 | NO SIGN
C | CONFERENCE
B | EQUIPMENT ROOM
C | CONFERENCE
B | BUSINESS CENTER
C | MEETING ROOM
O | OPEN OFFICE
O | OCCUPANT NAME
O | OCCUPANT NAME
O | OCCUPANT NAME
O | OCCUPANT NAME
O | EAST COFFEE SHOP
B | STORAGE
B | MECHANICAL ROOM
B | STORAGE
 | NO SIGN
 | NO SIGN
 | NO SIGN
 | NO SIGN
 | NO SIGN
B | EAST ACCESS CONTROL CENTER
I | LOGO
C | MEETING ROOM
O | OPEN OFFICE
O | OCCUPANT NAME
O | OCCUPANT NAME
O | OCCUPANT NAME
 | NO SIGN
C | CONFERENCE
O | OCCUPANT NAME
O | OCCUPANT NAME
O | OPEN OFFICE E-315
B | BUSINESS CENTER
O | OCCUPANT NAME
O | OCCUPANT NAME
 | NO SIGN
 | NO SIGN
 | NO SIGN
 | NO SIGN
 | NO SIGN
B | STORAGE
B | ELEVATOR CONTROL CLOSET
B | UPS
Spreadsheet: 181760d1348145501-transposing-quarterly-row-data-into-one-column-in-order-to-graph-it-v2-unemplmt
Sheet: BLS Data Series

Labor Force Statistics from the Current Population Survey
Original Data Value
Series Id: | LNS14000000Q
Seasonally Adjusted
Series title: | (Seas) Unemployment Rate
Labor force status: | Unemployment rate
Type of data: | Percent or rate
Age: | 16 years and over
Years: | 1981 to 2012
Year | Qtr1 | Qtr2 | Qtr3 | Qtr4 | Annual
1981 | 7.4 | 7.4 | 7.4 | 8.2 | 7.600000000000001
1982 | 8.8 | 9.4 | 9.9 | 10.7 | 9.7
1983 | 10.4 | 10.1 | 9.4 | 8.5 | 9.6
1984 | 7.9 | 7.5 | 7.4 | 7.3 | 7.525
1985 | 7.3 | 7.3 | 7.2 | 7 | 7.2
1986 | 7 | 7.2 | 7 | 6.8 | 7
1987 | 6.6 | 6.3 | 6 | 5.9 | 6.199999999999999
1988 | 5.7 | 5.5 | 5.5 | 5.3 | 5.5
1989 | 5.2 | 5.2 | 5.3 | 5.4 | 5.275
1990 | 5.3 | 5.3 | 5.7 | 6.1 | 5.6
1991 | 6.6 | 6.8 | 6.9 | 7.1 | 6.85
1992 | 7.4 | 7.6 | 7.6 | 7.4 | 7.5
1993 | 7.2 | 7.1 | 6.8 | 6.6 | 6.925000000000001
1994 | 6.6 | 6.2 | 6 | 5.6 | 6.1
1995 | 5.5 | 5.7 | 5.7 | 5.6 | 5.625
1996 | 5.5 | 5.5 | 5.3 | 5.3 | 5.4
1997 | 5.2 | 5 | 4.9 | 4.7 | 4.95
1998 | 4.6 | 4.4 | 4.5 | 4.4 | 4.475
1999 | 4.3 | 4.3 | 4.2 | 4.1 | 4.225
2000 | 4 | 3.9 | 4 | 3.9 | 3.95
2001 | 4.2 | 4.4 | 4.8 | 5.5 | 4.725000000000001
2002 | 5.7 | 5.8 | 5.7 | 5.8 | 5.75
2003 | 5.9 | 6.2 | 6.1 | 5.8 | 6.000000000000001
2004 | 5.7 | 5.6 | 5.4 | 5.4 | 5.525
2005 | 5.3 | 5.1 | 5 | 5 | 5.1
2006 | 4.7 | 4.7 | 4.6 | 4.5 | 4.625
2007 | 4.5 | 4.5 | 4.7 | 4.8 | 4.625
2008 | 5 | 5.3 | 6 | 6.9 | 5.800000000000001
2009 | 8.3 | 9.3 | 9.6 | 9.9 | 9.275
2010 | 9.8 | 9.6 | 9.5 | 9.6 | 9.625
2011 | 9 | 9.1 | 9.1 | 8.7 | 8.975000000000001
2012 | 8.2 | 8.2 |  |  | 8.2
1992 Recession | 0.7999999999999998
2008 Recession | 0.6000000000000005
1980 Recession | 1.7
Spreadsheet: 6e17b87c-00f6-4445-b73d-9dba32fed706
Sheet: MULTIFAMILY  

 |  |  | CITY OF RIO RANCHO, NEW MEXICO
 |  |  | JUNE 2014 MULTI-FAMILY
APPLICATION TYPE | ADDRESS |  |  |  | LEGAL DESCRIPTION |  |  | PERMIT |  | STATUS | YMMDD | SQUARE FOOTAGE | VALUATION | # OF UNITS
 | Street Number | Street Name | Suffix | Quandrant | Unit | Block | Lot | Permit Year | Permit number
 |  |  | NONE | FOR | [NAME] | 2014
Spreadsheet: 193335d1352805630-array-between-2-sheets-dec
Sheet: Sheet1

 |  | group1 |  |  |  |  |  |  | [NAME] | [NAME] | [NAME] | jingle | schmit | 0 | 0
 |  | group1 |  |  |  |  |  |  | [NAME] | [NAME] | [NAME] | jingle | schmit | 0 | 0
 |  | group2 |  |  |  |  |  |  | [NAME] | [NAME] | [NAME] | 0 | 0 | 0 | 0
 |  | group2 |  |  |  |  |  |  | [NAME] | [NAME] | [NAME] | 0 | 0 | 0 | 0
 |  | group2 |  |  |  |  |  |  | [NAME] | [NAME] | [NAME] | 0 | 0 | 0 | 0
 |  | [NAME] |  |  |  |  |  |  | tom | [NAME] | [NAME] | 0 | 0 | 0 | 0
 |  | group4 |  |  |  |  |  |  | [NAME] | [NAME] | davidson | [NAME] | [NAME] | [NAME] | schmit
 |  | group4 |  |  |  |  |  |  | [NAME] | [NAME] | davidson | [NAME] | [NAME] | [NAME] | schmit
 |  | group5 |  |  |  |  |  |  | [NAME] | [NAME] | 0 | 0 | 0 | 0 | 0
Spreadsheet: 875909d1722525113-solved-how-can-i-get-this-formula-to-work-with-each-individual-row-exceltest-elitebeat-
Sheet: Sheet1

Style | Type | Height | [NAME] | OUTPUT |  |  |  |  |  |  |  |  |  |  |  |  |  | Style | Compi | Compi Verti | K1 | P1 | K2 | K3 | 300_ | 450_
Compi Verti | K3 | 450 | 600 |  |  |  |  |  |  |  |  | Style | Type | Height | [NAME] | Output |  | Compi | K1 | K3 | 300 | 450 | 450 | 450 | 400 | 400
Compi | K2 | 450 | 400 |  |  |  |  |  |  |  |  | Compi | K1 | 300 | 400 | 204 |  | Compi Verti | P1 |  | 450 |  |  |  | 500 | 500
Compi | K1 | 300 | 1500 |  |  |  |  |  |  |  |  | Compi | K1 | 300 | 500 | 255 |  |  | K2 |  |  |  |  |  | 1000 | 600
Compi | P1 | 450 | 400 |  |  |  |  |  |  |  |  | Compi | K1 | 300 | 1000 | 509 |  |  |  |  |  |  |  |  | 1500 | 700
 |  |  |  |  |  |  |  |  |  |  |  | Compi | K1 | 300 | 1500 | 764 |  |  |  |  |  |  |  |  | 2000 | 800
 |  |  |  |  |  |  |  |  |  |  |  | Compi | K1 | 300 | 2000 | 1018 |  |  |  |  |  |  |  |  | 2500 | 900
 |  |  |  |  |  |  |  |  |  |  |  | Compi | K1 | 300 | 2500 | 1273 |  |  |  |  |  |  |  |  | 300 | 1000
 |  |  |  |  |  |  |  |  |  |  |  | Compi | K1 | 300 | 3000 | 1527 |  |  |  |  |  |  |  |  |  | 1100
 |  |  |  |  |  |  |  |  |  |  |  | Compi | K1 | 450 | 400 | 302 |  |  |  |  |  |  |  |  |  | 1200
 |  |  |  |  |  |  |  |  |  |  |  | Compi | P+ | 450 | 500 | 378 |  |  |  |  |  |  |  |  |  | 1400
 |  |  |  |  |  |  |  |  |  |  |  | Compi | P+ | 450 | 600 | 454 |  |  |  |  |  |  |  |  |  | 1600
 |  |  |  |  |  |  |  |  |  |  |  | Compi | P+ | 450 | 700 | 529 |  |  |  |  |  |  |  |  |  | 1800
 |  |  |  |  |  |  |  |  |  |  |  | Compi | P+ | 450 | 800 | 605 |  |  |  |  |  |  |  |  |  | 2000
 |  |  |  |  |  |  |  |  |  |  |  | Compi | P+ | 450 | 900 | 680 |  |  |  |  |  |  |  |  |  | 2200
 |  |  |  |  |  |  |  |  |  |  |  | Compi | P+ | 450 | 1000 | 756 |  |  |  |  |  |  |  |  |  | 2400
 |  |  |  |  |  |  |  |  |  |  |  | Compi | P+ | 450 | 1100 | 832 |  |  |  |  |  |  |  |  |  | 2600
 |  |  |  |  |  |  |  |  |  |  |  | Compi | K2 | 450 | 1200 | 907 |  |  |  |  |  |  |  |  |  | 2800
 |  |  |  |  |  |  |  |  |  |  |  | Compi | K2 | 450 | 1400 | 1058 |  |  |  |  |  |  |  |  |  | 3000
 |  |  |  |  |  |  |  |  |  |  |  | Compi | K2 | 450 | 1600 | 1210
Style of Radiator | Type of Radiator | Height | [NAME] |  |  |  |  |  |  |  |  | Compi | K2 | 450 | 1800 | 1361
Compi | K1 | 300 | 400 |  |  |  |  |  |  |  |  | Compi | K2 | 450 | 2000 | 1512
Compi Verti | K2 | 450 | 500 |  |  |  |  |  |  |  |  | Compi | K2 | 450 | 2200 | 1663
 | K3 |  | 600 |  |  |  |  |  |  |  |  | Compi Verti | K3 | 450 | 2400 | 1814
 | P+ |  | 700 |  |  |  |  |  |  |  |  | Compi Verti | K3 | 450 | 2600 | 1966
 |  |  | 800 |  |  |  |  |  |  |  |  | Compi Verti | K3 | 450 | 2800 | 2117
 |  |  | 900 |  |  |  |  |  |  |  |  | Compi Verti | K3 | 450 | 3000 | 2268
 |  |  | 1000
 |  |  | 1100
 |  |  | 1200
 |  |  | 1300
 |  |  | 1400
 |  |  | 1500
 |  |  | 1600
 |  |  | 1700
 |  |  | 1800
 |  |  | 1900
 |  |  | 2000
 |  |  | 2100
 |  |  | 2200
 |  |  | 2300
 |  |  | 2400
 |  |  | 2500
 |  |  | 2600
 |  |  | 2700
 |  |  | 2800
 |  |  | 2900
 |  |  | 3000
Spreadsheet: 99863d1298406991-index-match-match-returns-ref-or-0-2011-square-and-bracket-templet
Sheet: PD

 |  | First Set | Second Set | Name | Paid
 |  | 1 | 1 | [NAME]
 |  | 2 | 1 | #N/A
 |  | 3 | 1 | Yolanda M
 |  | 4 | 1 | #N/A
 |  | 5 | 1 | [NAME]
 |  | 6 | 1 | #N/A
 |  | 7 | 1 | #N/A
 |  | 8 | 1 | Sean P
 |  | 9 | 1 | [NAME]
 |  | 0 | 1 | #N/A
 |  | 1 | 2 | [NAME] and [NAME]
 |  | 2 | 2 | #N/A
 |  | 3 | 2 | Rich & George
 |  | 4 | 2 | #N/A
 |  | 5 | 2 | Carrie & Jen
 |  | 6 | 2 | #N/A
 |  | 7 | 2 | #N/A
 |  | 8 | 2 | Hershey S
 |  | 9 | 2 | [NAME]
 |  | 0 | 2 | #N/A
 |  | 1 | 3 | 0
 |  | 2 | 3 | #N/A
 |  | 3 | 3 | 0
 |  | 4 | 3 | #N/A
 |  | 5 | 3 | 0
 |  | 6 | 3 | #N/A
 |  | 7 | 3 | #N/A
 |  | 8 | 3 | 0
 |  | 9 | 3 | 0
 |  | 0 | 3 | #N/A
 |  | 1 | 4 | 0
 |  | 2 | 4 | #N/A
 |  | 3 | 4 | 0
 |  | 4 | 4 | #N/A
 |  | 5 | 4 | 0
 |  | 6 | 4 | #N/A
 |  | 7 | 4 | #N/A
 |  | 8 | 4 | 0
 |  | 9 | 4 | 0
 |  | 0 | 4 | #N/A
 |  | 1 | 5 | 0
 |  | 2 | 5 | #N/A
 |  | 3 | 5 | 0
 |  | 4 | 5 | #N/A
 |  | 5 | 5 | 0
 |  | 6 | 5 | #N/A
 |  | 7 | 5 | #N/A
 |  | 8 | 5 | 0
 |  | 9 | 5 | 0
 |  | 0 | 5 | #N/A
 |  | 1 | 6 | [NAME]
 |  | 2 | 6 | #N/A
 |  | 3 | 6 | [NAME] T
 |  | 4 | 6 | #N/A
 |  | 5 | 6 | [NAME]
 |  | 6 | 6 | #N/A
 |  | 7 | 6 | #N/A
 |  | 8 | 6 | [NAME]
 |  | 9 | 6 | Connie G
 |  | 0 | 6 | #N/A
 |  | 1 | 7 | Brad & Cathy
 |  | 2 | 7 | #N/A
 |  | 3 | 7 | [NAME]
 |  | 4 | 7 | #N/A
 |  | 5 | 7 | [NAME]
 |  | 6 | 7 | #N/A
 |  | 7 | 7 | #N/A
 |  | 8 | 7 | Julie & Joe
 |  | 9 | 7 | Kathy & Frank
 |  | 0 | 7 | #N/A
 |  | 1 | 8 | a
 |  | 2 | 8 | #N/A
 |  | 3 | 8 | 0
 |  | 4 | 8 | #N/A
 |  | 5 | 8 | 0
 |  | 6 | 8 | #N/A
 |  | 7 | 8 | #N/A
 |  | 8 | 8 | 0
 |  | 9 | 8 | a
 |  | 0 | 8 | #N/A
 |  | 1 | 9 | a
 |  | 2 | 9 | #N/A
 |  | 3 | 9 | 0
 |  | 4 | 9 | #N/A
 |  | 5 | 9 | 0
 |  | 6 | 9 | #N/A
 |  | 7 | 9 | #N/A
 |  | 8 | 9 | 0
 |  | 9 | 9 | 0
 |  | 0 | 9 | #N/A
 |  | 1 | 0 | Sandy & Denise
 |  | 2 | 0 | #N/A
 |  | 3 | 0 | [NAME]
 |  | 4 | 0 | #N/A
 |  | 5 | 0 | [NAME]
 |  | 6 | 0 | #N/A
 |  | 7 | 0 | #N/A
 |  | 8 | 0 | [NAME]
 |  | 9 | 0 | Amy & Mike
 |  | 0 | 0 | #N/A
Spreadsheet: 695005d1599948076-how-to-use-wildcards-in-search-replace-for-existing-formulas-findreplacewildcard
Sheet: Sheet2

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Factor | Price
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.26803
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.27739
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.2096
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.24228
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.37819
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.21875
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -0.07748
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.17334
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.16244
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.86717
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.42746
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.38803
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.3809
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.3224
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.21973 | 481
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.27749 | 792
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.56164 | 318
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.31059 | 500
Spreadsheet: 842116d1694179211-dynamic-array-formula-needed-for-irregular-data-book1-8-
Sheet: Sheet1

 | Source: | Dynamic Array formula needed for irregular data
 |  |  |  |  | Dyn.Arr. | Expected values
 | [NAME] | Dataset | Product | Channel | Division | Type | A-Code | X-Code |  |  |  |  |  |  | Dataset | unique id | Division | Type | A-Code | Colour | X-Code
 | 1 | [NAME] |  |  |  | A | A01 | X01 |  |  |  |  |  |  | 1 | [NAME] | North | A | A01 | Grey | X01
 |  |  | Product X | EU | North | A | A01 | X01 |  |  |  |  |  |  | 2 | XEFGH | South | B | A02 | Black | X02
 |  |  | Product X | UK | North | A | A01 | X01 |  |  |  |  |  |  | 3 | XIJKL | West | C | A03 | White | X03
 |  |  | Product X | AU | North | A | A01 | X01 |  |  |  |  |  |  | 4 | XMNOP | North | D | A04 | Green | [NAME]
 |  |  | Product X | US | North | A | A01 | X01 |  |  |  |  |  |  | 5 | XQRST | East | E | A05 | Blue | X05
 | 2 | XEFGH |  |  | South | B | A02 | X02 |  |  |  |  |  |  | 6 | XUVWX | West | F | A06 | Red | X06
 |  |  | Product Y | EU | South | B | A02 | X02
 |  |  | Product Y | UK | South | B | A02 | X02
 |  |  | Product Y | AU | South | B | A02 | X02
 |  |  | Product Y | US | South | B | A02 | X02
 | 3 | XIJKL |  |  | West | C | A03 | X03
 |  |  | Product Z | EU | West | C | A03 | X03
 |  |  | Product Z | UK | West | C | A03 | X03
 |  |  | Product Z | AU | West | C | A03 | X03
 |  |  | Product Z | US | West | C | A03 | X03
Spreadsheet: 266591d1379673255-conditional-formatting-due-dates-for-production-ppic-board-ans
Sheet: Sheet1

Today :
 |  |  |  | Production Planning and Control Board
Product |  | Component |  | Material |  | Assembly |  | Metal
 |  |  |  | Preparation |  | Department |  | Treatment |  | Finishing
Description | Qty | Description | Pcs | Schd | Actual | Schd | Actual | Schd. | Actual | Schd. | Actual | Schd. | Actual
Accent Chair | 10 | Back Legs | 20 | 2013-09-18 00:00:00 | 2013-09-18 00:00:00 | 2013-10-01 00:00:00 | 2013-10-05 00:00:00 | 2013-10-10 00:00:00 | 2013-10-11 00:00:00 | 2013-10-12 00:00:00 | 2013-10-12 00:00:00
 |  |  |  | 2013-09-19 00:00:00
Spreadsheet: 649057d1573451883-how-to-find-nearest-value-in-excel-nearest-point
Sheet: Sheet1

NEW DATA |  |  |  | NEAREST POINT |  |  |  | DISTANCE BETWEEN TWO POINTS |  |  | OLD DATA
GULLY_NO | FM_EASTING | FM_NORTHING |  | GULLY_NO | FM_EASTING | FM_NORTHING |  |  |  |  | GULLY_NO | Easting (X) | Northing (Y)
55/SA/33/G1 | 220738.544 | 387238.219 |  |  |  |  |  |  |  |  | 55/BD/1 | 222529.349 | 387863.667
55/WB/SA1A/G2 | 227316.391 | 391205.881 |  |  |  |  |  |  |  |  | 55/BD/2 | 222460.898 | 387652.85
ASF/5/1/1/G1A | 221820.297 | 387640.736 |  |  |  |  |  |  |  |  | 55/BD/3 | 221852.452 | 387640.789
ASF/5/1/1/G2 | 221852.384 | 387640.742 |  |  |  |  |  |  |  |  | 55/BD/4 | 221820.068 | 387628.96
ASF/5/1/1/G5 | 221844.918 | 387628.963 |  |  |  |  |  |  |  |  | 55/BD/5 | 221844.784 | 387628.926
ASF/5/1/1/G6 | 221821.016 | 387628.803 |  |  |  |  |  |  |  |  | 55/[NAME] | 222522.967 | 387868.383
ASF/5/1/1/G6A | 221820.414 | 387628.816 |  |  |  |  |  |  |  |  | 55/BD/7 | 222511.128 | 387856.551
ASF/5/1/G3 | 221965.634 | 387629.571 |  |  |  |  | COMPARE WITH EASTING |  |  |  | 55/BD/8 | 222454.09 | 387842.85
ASF/5/1/G3 | 221965.634 | 387629.571 |  |  |  |  | COMPARE WITH NORTHING |  |  |  | 55/BD/9 | 222416.716 | 387839.652
ASF/5/1/G4 | 221915.21 | 387629.225 |  |  |  |  |  |  |  |  | 55/BD/10 | 221965.511 | 387679.604
ASF/5/10/G1 | 222445.005 | 387677.73 |  |  |  |  |  |  |  |  | 55/BD/10A | 221965.83 | 387629.612
ASF/5/10/G2 | 222460.823 | 387652.888 |  |  |  |  |  |  |  |  | 55/BD/12 | 221915.022 | 387629.329
ASF/5/13/1/G1 | 222459.856 | 387851.735 |  |  |  |  |  |  |  |  | 55/BD/13 | 222459.825 | 387851.675
ASF/5/13/1/G2 | 222454.046 | 387842.838 |  |  |  |  |  |  |  |  | 55/BD/14 | 221820.132 | 387640.596
ASF/5/13/1/G3 | 222436.785 | 387838.095 |  |  |  |  |  |  |  |  | 55/BD/15 | 221820.938 | 387628.995
ASF/5/13/1/G4 | 222416.509 | 387839.669 |  |  |  |  |  |  |  |  | 55/BD/16 | 222445.054 | 387677.866
[NAME] | 222523.037 | 387868.282 |  |  |  |  |  |  |  |  | 55/BD/17 | 222436.88 | 387838.154
ASF/5/13/2/G2 | 222529.394 | 387863.609 |  |  |  |  |  |  |  |  | 55/BD/18 | 220738.59 | 387237.87
ASF/5/13/2/G3 | 222511.09 | 387856.545 |  |  |  |  |  |  |  |  | 55/BD/19 | 227316.454 | 391205.907
ASF/5/13/2/G4 | 222503.597 | 387863.268
 |  |  |  | * | If only one coordinate is near mean, that’s not a nearest point,
Spreadsheet: 91a59ecf-9c8e-4567-9a9f-edda0062d85e
Sheet: Sheet1

Use this gradebook to calculate grades where each assignment is worth a set number of points. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25 | Unnamed: 26 | Unnamed: 27 | Unnamed: 28 | Unnamed: 29 | Unnamed: 30 | Unnamed: 31 | Unnamed: 32 | Unnamed: 33 | Unnamed: 34 | Unnamed: 35 | Unnamed: 36 | Unnamed: 37 | Unnamed: 38 | Unnamed: 39 | Unnamed: 40 | Unnamed: 41 | Unnamed: 42 | Unnamed: 43 | Unnamed: 44 | Unnamed: 45 | Unnamed: 46 | Unnamed: 47 | Unnamed: 48 | Unnamed: 49 | Unnamed: 50 | Unnamed: 51 | Unnamed: 52 | Unnamed: 53 | Unnamed: 54 | Unnamed: 55 | Unnamed: 56 | Unnamed: 57 | Unnamed: 58 | Unnamed: 59 | Unnamed: 60 | Unnamed: 61 | Unnamed: 62 | Unnamed: 63 | Unnamed: 64 | Unnamed: 65 | Unnamed: 66 | Unnamed: 67 | Unnamed: 68 | Unnamed: 69 | Unnamed: 70 | Unnamed: 71 | Unnamed: 72 | Unnamed: 73 | Unnamed: 74 | Unnamed: 75 | Unnamed: 76 | Unnamed: 77 | Unnamed: 78 | Unnamed: 79
 |  | GRADE & GPA TABLE
 | Average | 0 | 0.6 | 0.63 | 0.67 | 0.7 | 0.73 | 0.77 | 0.8 | 0.83 | 0.87 | 0.9 | 0.93 | 0.97
 | [NAME] | F | D- | D | [NAME] | C- | C | C+ | B- | B | [NAME] | A- | A | A+
 | GPA | 0 | 0.67 | 1 | 1.33 | 1.67 | 2 | 2.33 | 2.67 | 3 | 3.33 | 3.67 | 4 | 4
Your School Name
Teacher Name |  |  |  | Assignment or Test Name
Class/Project |  |  |  | Possible Points
Year/Semester/Quarter
 |  |  |  | Total number of assignments and tests: | 0
 |  |  |  | Total possible points: | 0
STUDENT NAME | STUDENT ID | Average | [NAME] | GPA
CLASS SUMMARY |  | Average | [NAME] | GPA
Average
Highest Score
Lowest Score
Spreadsheet: c0f54386-0d7b-4d51-9340-fc8e2a37d87b
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Name | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 |  |  |  | Learner ID
 |  |  |  | School/College/University
Agriculture, Food and Natural Resources: Animal Systems
Career Pathway Plan of Study for ►Learners ►Parents ►Counselors ►Teachers/Faculty
This Career Pathway Plan of Study (based on the Animal Systems Pathway of the Agriculture, Food and Natural Resources Career Cluster) can serve as a guide, along with other career planning materials, as learners continue on a career path. Courses listed within this plan are only recommended coursework and should be individualized to meet each learner’s educational and career goals. *This Plan of Study, used for learners at an educational institution, should be customized with course titles and appropriate high school graduation requirements as well as college entrance requirements.
EDUCATION | LEVELS | GRADE | [NAME] | Math | Science | Social Studies/ Sciences | Other Required Courses Other Electives Recommended       Electives                         Learner Activities | *Career and Technical Courses                    and/ or Degree Major Courses for               Animal Systems Pathway | SAMPLE                                   Occupations Relating                            to This Pathway
 |  | Interest Inventory Administered and Plan of Study Initiated for all Learners
[NAME] |  | 9 |  |  |  |  |  |  | Occupations Requiring Postsecondary Education ►Animal Caretaker - Poultry                  .    Manager ►Aquaculturalist ►Artificial Insemination Technician ►Dairy Producer ►Equine Manager ►Feed Sales Representative ►Livestock Buyer ►Livestock Inspector ►Livestock Producer ►Veterinary Assistant                                                    .                                                      Occupations Requiring Baccalaureate Degree ►Agricultural Educator ►Animal Nutritionist ►Livestock Geneticist ►Meat Science Researcher ►Physiologist ►Wildlife Biologist ►USDA Inspector ►Veterinarian
 |  | 10
 |  | 11
 |  | College Placement Assessments-Academic/Career Advisement Provided
 |  | 12
 |  | Articulation/Dual Credit Transcripted-Postsecondary courses may be taken/moved to the secondary level for articulation/dual credit purposes.
POSTSECONDARY |  | Year 13
 |  | Year14
 |  | Year 15
 |  | Year 16
 |  |  |  |  |  | Project funded by the U.S. Department of Education (VO51B020001)
Spreadsheet: 75124d1275651287-how-to-refresh-data-for-advanced-filter-and-associated-problems-example_advanced_filter_rev1
Sheet: Q1307

Cost Centre
Cost Centre | Activity Code | Party Id | Name | Service Start | Service End | Frequency | Rate | Provider | A / B
Q1307 | 307 | 5006 | [NAME] | 2010-05-05 00:00:00 | 2010-06-05 00:00:00 | 2 | 40 | Food | A