tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 703501d1605023401-get-values-from-different-sheets-where-different-bits-of-data-values-match-chasing-values
Sheet: items

ParentKey | LineNum | ItemCode | Quantity
DocNum | LineNum | ItemCode | Quantity
Spreadsheet: 713269d1610629458-how-to-split-a-quantity-across-time-periods-example-for-volume-split
Sheet: View 2

Shipping Year | 2020
Sum of Volume | Column Labels
Row Labels | 12020 | 32020 | 42020 | 52020 | 62020 | 72020 | 82020 | Grand Total
A | 530.64 |  | 640 |  | 650 | 500 | 1300 | 3620.64
B | 145.08 | 349 |  |  | 300 | 1000 | 250 | 2044.08
C |  | 849 |  | 478 |  | 350 | 1050 | 2727
D |  |  |  | 461 | 70 | 2131.84 | 300 | 2962.84
E |  |  | 621 |  | 250 | 800 | 380 | 2051
Grand Total | 675.72 | 1198 | 1261 | 939 | 1270 | 4781.84 | 3280 | 13405.56
Spreadsheet: 78565d1278949522-hours-and-minutes-separate-cells-mod1
Sheet: timesheet front 

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CURRENT / AMENDED TIMESHEET    (PLEASE DELETE AS APPROPRIATE) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | √
Status Codes for timesheets |  |  | PRINT NAME |  |  |  |  |  |  |  |  | PAYROLL NUMBER |  |  | Payroll Week No |  |  |  |  |  |  |  |  |  |  | BATCH NUMBER |  |  |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WEEK ENDING DATE
AL | Annual Leave |  | Date |  | On Call (Please State Tick or %) |  | Rostered Hours |  | Status Code         (See left) |  | Time Booked ON |  | Meal |  | Time Booked OFF |  | Total Hours |  | Total Overtime Hrs Claimed |  | Claimed HGD Grade Code |  | Average Earnings (please tick) |  | RTA (Please tick no of days) | PDA, (Please tick no of days) | Taxable RTA Allow ££ pp |  | Meal Allowance                  ££ pp |  | Roster change (Please [NAME]) |  | Remarks/ Comments
AW | Absent without Leave |  |  |  |  |  |  |  |  |  | hh | [NAME] | hh | [NAME] | hh | [NAME] | hh | [NAME] | hh | [NAME] |  |  |  |  |  |  |  |  |  |  | D -N | N- D
 |  |  | FRI | 1
BH | un-worked Bank holiday
CL | Comp Leave/ [NAME] |  | SAT | 2
EL | Education Leave
HA | Hospital Appointment |  | SUN | 3
JL | Jury Service
ML | Maternity Leave |  | MON | 4
PL | Paid Leave/ Resting after nights
PP | Paternity Leave |  | TUES | 5
RD | Rest Day
RW | Overtime shift worked/ Rest day worked
 |  |  | WED | 6
S | Sickness
TC | On a training course
 |  |  | THUR | 7
TW | Training whilst at work
WB | Worked on a Bank Holiday
UL | [NAME] |  | Total number of on calls |  |  |  | 0 |  | Total number of [NAME] |  |  |  |  |  | Total Hours Worked (A) |  | 0 | 0 | 0 | 0 | Total hours overtime claiming |  |  | Total £ of Allowances Claimed
 | I DECLARE THAT THE HOURS BOOKED ARE PROPERLY CLAIMED, ACCURATE & COMPLETE |  |  |  |  |  |  |  |  |  | EMPLOYEE SIGNATURE |  |  |  |  |  |  |  | I CERTIFY THAT ALL DETAILS ARE ACCURATE AND [NAME] |  |  |  | LINE MANAGER SIGNATURE |  |  |  |  |  |  |  |  |  |  | SMF/MG/0303
Spreadsheet: 03f54fe3-ac4f-4ab3-867f-1f622601bfdb
Sheet: State Codes 

State/Country/Territory Code | Abbreviation
Afghanistan | AG
Alaska | AK
Alabama | AL
Arkansas | AR
Arizona | AZ
Australia | AU
California | CA
Canada | CN
Colorado | CO
Connecticut | CT
District of Columbia | DC
Delaware | DE
England | EG
Florida | FL
Georgia | GA
Government Vehicle | US
Hawaii | HI
Iowa | IA
Idaho | ID
Illinois | IL
Indiana | IN
Kansas | KS
Kentucky | KY
Lousiana | LA
Massachusetts | MA
Maryland | MD
Maine | ME
Michigan | MI
Minnesota | MN
Missouri | MO
Mississippi | MS
Montana | MT
Mexico | MX
Nebraska | NB
North Carolina | NC
North Dakota | ND
New Hampshire | NH
New Jersey | NJ
New Mexico | NM
Northwest Territory | NT
Nunavut Territory | NU
Nevada | NV
New York | NY
Ohio | OH
Oklahoma | OK
Oregon | OR
Other Country | OC
Palau | PW
Pennsylvania | PA
Puerto Rico | PR
Quebec | QC
Rhode Island | RI
South Carolina | SC
South Dakota | SD
Tennessee | TN
Texas | TX
United Kingdom | UK
Utah | UT
Virginia | VA
Vermont | VT
Washington | WA
Wisconsin | WI
West Virginia | WV
Wyoming | WY
Yukon Territory | YT
Spreadsheet: 883970d1732789950-requesting-for-help-involving-dates-and-date-ranges-excel-help-copy
Sheet: Sheet1

Date | [NAME] | Employee Name | Processed Items | Department? |  |  |  |  |  |  |  | Employee Name | Department | Department As Of
2024-01-14 00:00:00 | Panda | Shanice Michaels | 53 |  |  |  |  |  |  |  |  | Shanice Michaels | Sales | 2024-01-01 00:00:00
2024-01-14 00:00:00 | Panda | [NAME] | 45 |  |  |  |  |  |  |  |  | [NAME] | Sales | 2024-01-01 00:00:00
2024-01-14 00:00:00 | Unicorn | Athena Soler | 24 |  |  |  |  |  |  |  |  | Athena Soler | Marketing | 2024-01-01 00:00:00
2024-01-14 00:00:00 | [NAME] | [NAME] | 76 |  |  |  |  |  |  |  |  | [NAME] | Technology | 2024-01-01 00:00:00
2024-01-30 00:00:00 | Stonefish | Shanice Michaels | 43 |  |  |  |  |  |  |  |  | [NAME] | Human Resources | 2024-01-01 00:00:00
2024-01-30 00:00:00 | Unicorn | [NAME] | 53 |  |  |  |  |  |  |  |  | [NAME] | Human Resources | 2024-01-01 00:00:00
2024-01-30 00:00:00 | Ladybug | Athena Soler | 9 |  |  |  |  |  |  |  |  | [NAME] | Operations | 2024-01-01 00:00:00
2024-02-11 00:00:00 | Stonefish | Athena Soler | 63 |  |  |  |  |  |  |  |  | [NAME] | Operations | 2024-01-26 00:00:00
2024-02-11 00:00:00 | Panda | Shanice Michaels | 96 |  |  |  |  |  |  |  |  | Athena Soler | Human Resources | 2024-01-10 00:00:00
2024-02-11 00:00:00 | Ladybug | [NAME] | 21 |  |  |  |  |  |  |  |  | Shanice Michaels | Human Resources | 2024-02-09 00:00:00
2024-03-14 00:00:00 | [NAME] | Athena Soler | 19 |  |  |  |  |  |  |  |  | [NAME] | Sales | 2024-03-12 00:00:00
2024-03-15 00:00:00 | Octopus | [NAME] | 83 |  |  |  |  |  |  |  |  | [NAME] | Technology | 2024-03-17 00:00:00
2024-03-15 00:00:00 | Stonefish | [NAME] | 32 |  |  |  |  |  |  |  |  | [NAME] | Technology | 2024-04-02 00:00:00
2024-03-18 00:00:00 | [NAME] | [NAME] | 7 |  |  |  |  |  |  |  |  | [NAME] | Sales | 2024-04-03 00:00:00
2024-04-02 00:00:00 | Raven | [NAME] | 31 |  |  |  |  |  |  |  |  | [NAME] | Marketing | 2024-05-16 00:00:00
2024-04-02 00:00:00 | Panda | [NAME] | 31 |  |  |  |  |  |  |  |  | [NAME] | Sales | 2024-05-17 00:00:00
2024-04-04 00:00:00 | Raven | [NAME] | 23
2024-04-07 00:00:00 | Ladybug | [NAME] | 28
2024-05-13 00:00:00 | Unicorn | [NAME] | 64
2024-05-13 00:00:00 | Stonefish | [NAME] | 8
2024-05-17 00:00:00 | Unicorn | Shanice Michaels | 10
2024-05-17 00:00:00 | Raven | [NAME] | 75
Spreadsheet: 122593d1317013946-remove-duplicate-lines-but-not-delete-rows-793815-remove-duplicate-lines-test1
Sheet: Sheet1

GROUP | NAME | SURNAME | ID | ANALYSIS | RESULT | UNITS
34 | George | Clooney | 3456346 | LDL | 356 | mg
34 | George | Clooney | 3456346 | HDL | 324 | ml
34 | George | Clooney | 3456346 | VLDL | 635 | [NAME]
34 | [NAME] | Cruise | 4573456 | LDL | 463 | dl
34 | [NAME] | Cruise | 4573456 | HDL | 746 | cm
34 | [NAME] | Cruise | 4573456 | VLDL | 435 | dc
35 | Al | Pacino | 5646464 | LDL | 467 | hg
35 | Al | Pacino | 5646464 | HDL | 352 | df
35 | Al | Pacino | 5646464 | VLDL | 643 | rf
Spreadsheet: 704631d1605657316-how-to-add-recommendations-based-on-formula-result-sheet
Sheet: Sheet1

 | CGPA until previous semester | 2.46
 | Total credit hours required | 115
 | Number of earned credit hours Until | 98
 | [NAME] hours(Taking this semester)SO this is my last sem.so my remain credit hours will be 0 after sem if I pass all courses
 | [NAME] | 1
 |  |  | Code | Mark | Credit hours | Score | Percentage | Grades | Credits | Points |  | PASS/FAIL
 |  | Course 1 | ABC | 80 | 3 | 80
 |  | Course 2 | DEF | 90 | 2 | 85
 |  | Course 3 | GHI | 85 | 3 | 85
 |  | Course 4 | JKL | 88 | 3 | 81
 |  | Course 5 | MNO | 78 | 3 | 76
 |  | Course 6 | PQR | 95 | 3 | 95
 | Semester GPA
 | Cummalative GPA
 | Graduate/May Not Graduate
Spreadsheet: 05f80a87-1d8f-4476-bc2c-2abf5e8ef7f6
Sheet: Marktplace - Leb FE

 |  |  | 2014 Delivery Calendar  -  Markethouse Place F.E. - Lebanon
 | January |  |  |  |  |  |  |  | February |  |  |  |  |  |  |  | March
 | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S
 |  |  |  | 1 | 2 | 3 | 4 |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | 1
 | 5 | 6 | 7 | 8 | 9 | 10 | 11 |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 |  | 2 | 3 | 4 | 5 | 6 | 7 | 8
 | 12 | 13 | 14 | 15 | 16 | 17 | 18 |  | 9 | 10 | 11 | 12 | 13 | 14 | 15 |  | 9 | 10 | 11 | 12 | 13 | 14 | 15
 | 19 | 20 | 21 | 22 | 23 | 24 | 25 |  | 16 | 17 | 18 | 19 | 20 | 21 | 22 |  | 16 | 17 | 18 | 19 | 20 | 21 | 22
 | 26 | 27 | 28 | 29 | 30 | 31 |  |  | 23 | 24 | 25 | 26 | 27 | 28 |  |  | 23 | 24 | 25 | 26 | 27 | 28 | 29
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30 | 31
 | April |  |  |  |  |  |  |  | May |  |  |  |  |  |  |  | June
 | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S
 |  |  | 1 | 2 | 3 | 4 | 5 |  |  |  |  |  | 1 | 2 | 3 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7
 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |  | 4 | 5 | 6 | 7 | 8 | 9 | 10 |  | 8 | 9 | 10 | 11 | 12 | 13 | 14
 | 13 | 14 | 15 | 16 | 17 | 18 | 19 |  | 11 | 12 | 13 | 14 | 15 | 16 | 17 |  | 15 | 16 | 17 | 18 | 19 | 20 | 21
 | 20 | 21 | 22 | 23 | 24 | 25 | 26 |  | 18 | 19 | 20 | 21 | 22 | 23 | 24 |  | 22 | 23 | 24 | 25 | 26 | 27 | 28
 | 27 | 28 | 29 | 30 |  |  |  |  | 25 | 26 | 27 | 28 | 29 | 30 | 31 |  | 29 | 30
 | July |  |  |  |  |  |  |  | August |  |  |  |  |  |  |  | September
 | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S
 |  |  | 1 | 2 | 3 | 4 | 5 |  |  |  |  |  |  | 1 | 2 |  |  | 1 | 2 | 3 | 4 | 5 | 6
 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |  | 3 | 4 | 5 | 6 | 7 | 8 | 9 |  | 7 | 8 | 9 | 10 | 11 | 12 | 13
 | 13 | 14 | 15 | 16 | 17 | 18 | 19 |  | 10 | 11 | 12 | 13 | 14 | 15 | 16 |  | 14 | 15 | 16 | 17 | 18 | 19 | 20
 | 20 | 21 | 22 | 23 | 24 | 25 | 26 |  | 17 | 18 | 19 | 20 | 21 | 22 | 23 |  | 21 | 22 | 23 | 24 | 25 | 26 | 27
 | 27 | 28 | 29 | 30 | 31 |  |  |  | 24 | 25 | 26 | 27 | 28 | 29 | 30 |  | 28 | 29 | 30
 |  |  |  |  |  |  |  |  | 31
 | October |  |  |  |  |  |  |  | November |  |  |  |  |  |  |  | December
 | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S
 |  |  |  | 1 | 2 | 3 | 4 |  |  |  |  |  |  |  | 1 |  |  | 1 | 2 | 3 | 4 | 5 | 6
 | 5 | 6 | 7 | 8 | 9 | 10 | 11 |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 |  | 7 | 8 | 9 | 10 | 11 | 12 | 13
 | 12 | 13 | 14 | 15 | 16 | 17 | 18 |  | 9 | 10 | 11 | 12 | 13 | 14 | 15 |  | 14 | 15 | 16 | 17 | 18 | 19 | 20
 | 19 | 20 | 21 | 22 | 23 | 24 | 25 |  | 16 | 17 | 18 | 19 | 20 | 21 | 22 |  | 21 | 22 | 23 | 24 | 25 | 26 | 27
 | 26 | 27 | 28 | 29 | 30 | 31 |  |  | 23 | 24 | 25 | 26 | 27 | 28 | 29 |  | 28 | 29 | 30 | 31
 |  |  |  |  |  |  |  |  | 30
 |  | 2nd Fridays with Lebanon County.  [NAME] is subject to change.  Call CPFB with questions [PHONE]. Thank you.
 |  | Holidays, Food Bank is Closed |  |  |  |  |  |  |  | Delivery dates to your area
Spreadsheet: 687569d1595278609-countifs-with-and-and-or-criteria-2020-07-20-oeldere-forestview-687508d1595256713-countifs-with-and-and-or-criteria-yes-and-si
Sheet: Sheet1

Names | Y/N | Site |  |  | Y/N | Site | Ops
[NAME] | Yes | x |  |  | Yes | x
[NAME] | Yes | y |  |  | Yes | y
[NAME] | No | z |  |  | Yes | z
[NAME] | No | x
[NAME] | Yes | x
Julie | Yes | z |  |  | Aantal van Names | Kolomlabels
[NAME] | Yes | z |  |  | Rijlabels | x | y | z | Eindtotaal
[NAME] | No | y |  |  | No | 1 | 3 | 1 | 5
[NAME] | No | y |  |  | [NAME] |  |  | 1 | 1
[NAME] | No | y |  |  | [NAME] |  | 1 |  | 1
 |  |  |  |  | [NAME] | 1 |  |  | 1
 |  |  |  |  | [NAME] |  | 1 |  | 1
 |  |  |  |  | [NAME] |  | 1 |  | 1
 |  |  |  |  | Yes | 2 | 1 | 2 | 5
 |  |  |  |  | [NAME] | 1 |  |  | 1
 |  |  |  |  | [NAME] | 1 |  |  | 1
 |  |  |  |  | [NAME] |  |  | 1 | 1
 |  |  |  |  | Julie |  |  | 1 | 1
 |  |  |  |  | [NAME] |  | 1 |  | 1
 |  |  |  |  | Eindtotaal | 3 | 4 | 3 | 10
Spreadsheet: 5ac240ce-ac1b-4fe6-990b-a0a4dfe976d6
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2012-08-29 09:16:50.650000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4 | 102.125 | 102 | 101.875 | 101.5 |  | and are added to price quote
3.875 | 101.625 | 101.5 | 101.375 | 101
3.75 | 101.49 | 101.365 | 101.24 | 100.865 |  | Note: | Refer To Price [NAME]
3.625 | 101.078 | 100.953 | 100.828 | 100.453 |  |  | For all Price Adjs
3.5 | 100.441 | 100.316 | 100.191 | 99.566
3.375 | 99.566 | 99.441 | 99.316 | 98.691
3.25 | 98.608 | 98.483 | 98.358 | 97.733
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | TIB Annual Mortgage Conference
 |  |  |  |  |  | October 3rd thru 5th
 |  |  |  |  |  | Register Now!!!
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.375 | 101.903 | 101.778 | 101.653 | 101.278
3.25 | 101.514 | 101.389 | 101.264 | 100.889
3.125 | 101.174 | 101.049 | 100.924 | 100.549
3 | 100.846 | 100.721 | 100.596 | 100.221
2.875 | 100.215 | 100.09 | 99.965 | 99.34
2.75 | 99.515 | 99.39 | 99.265 | 98.64
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2012-09-12 09:16:50.650000
30 DAY | 2012-09-27 09:16:50.650000
45 DAY | 2012-10-12 09:16:50.650000
60 DAY | 2012-10-27 09:16:50.650000
90 DAY | 2012-11-26 09:16:50.650000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 805727d1668865703-find-proportional-value-based-on-measured-value-book-hd
Sheet: Sheet1

4500000 | 60
4400000 | 55
4300000
4000000
3900000
3700000
3500000
3300000
3100000
2900000
Spreadsheet: 08c04032-0b6c-47b3-b038-6fa840d65f8a
Sheet: 4-Annual Financial Report

Expelled and at Risk Student Services Grant AFR
ANNUAL FINANCIAL REPORT
District/BOCES:
School:
Facility:
 |  |  |  |  |  |  | Funding request in Year 3 must be reduced by 25% from the highest award received in year one or two |  | Funding request in Year 4 must be reduced by 50% from the highest award received in year one or two
 |  |  | Year 1 |  | Year 2 |  | Year 3 |  | Year 4
 |  |  | Budget | Actual Expenditures | Budget | Actual Expenditures | Budget | Actual Expenditures | Budget | Actual Expenditures
 |  | Amount Requested |  |  |  | 0 |  | 0 |  | 0
 |  | INSTRUCTIONAL SERVICES
 | 1 | Salaries (0100) |  | 0 |  | 0 |  | 0 |  | 0
 | 2 | Employee Benefits (0200) |  | 0 |  | 0 |  | 0 |  | 0
 | 3 | Purchased Professional & Technical Services (0300) |  | 0 |  | 0 |  | 0 |  | 0
 | 4 | Other Purchased Services (0500) |  | 0 |  | 0 |  | 0 |  | 0
 | 5 | Supplies (0600) |  | 0 |  | 0 |  | 0 |  | 0
 | 6 | Non-Capital Equipment (0735) |  | 0 |  | 0 |  | 0 |  | 0
 |  | SUPPORT SERVICES | Budget | Actual Expenditures | Budget | Actual Expenditures | Budget | Actual Expenditures | Budget | Actual Expenditures
 | 7 | Salaries (0100) |  |  |  | 0 |  | 0 |  | 0
 | 8 | Employee Benefits (0200) |  | 0 |  | 0 |  | 0 |  | 0
 | 9 | Purchased Professional & Technical Services (0300) |  | 0 |  | 0 |  | 0 |  | 0
 | 10 | Other Purchased Services (0500) |  | 0 |  | 0 |  | 0 |  | 0
 | 11 | Supplies (0600) |  | 0 |  | 0 |  | 0 |  | 0
 | 12 | Non-Capital Equipment (0735) |  |  |  | 0 |  | 0 |  | 0
 |  | ADMINISTRATIVE SUPPORT-LIMITED TO 15% | Budget | Actual Expenditures | Budget | Actual Expenditures | Budget | Actual Expenditures | Budget | Actual Expenditures
 | 13 | Salaries (0100) |  | 0 |  | 0 |  | 0 |  | 0
 | 14 | Employee Benefits (0200) |  | 0 |  | 0 |  | 0 |  | 0
 | 15 | Purchased Professional & Technical Services (0300) |  | 0 |  | 0 |  | 0 |  | 0
 | 16 | Other Purchased Services (0500) |  | 0 |  | 0 |  | 0 |  | 0
 | 17 | Supplies (0600) |  | 0 |  | 0 |  | 0 |  | 0
 | 18 | Non-Capital Equipment (0735) |  | 0 |  | 0 |  | 0 |  | 0
 | 19 | Total Budget
 | 20 | Unobligated funds as of June 30th-MUST BE RETURNED TO CDE*
 | 21 | Number of pupils served by program-Must match student count reported to CDE in the EARSS online End of Year Report.
 | 22 | Amount expended per pupil served:
 | * | Upon completion of the AFR, unobligated funds must be returned to CDE to:  Colorado Department of Education, 201 East Colfax Avenue, Room 208, Denver, CO  80203  ATTENTION:  Marti Rodriguez
Spreadsheet: 137775d1327353347-excel-2007-vlookup-to-return-a-cell-outside-of-table-array-vlookup
Sheet: Sheet1

 |  |  |  |  |  | ---------Table Array----------- |  |  |  |  | Call center
 |  |  | Vlookup formula | ID |  | ID | Name | Pay |  |  | ID
 |  |  |  | 1 |  | 1 | [NAME] | 30 |  |  | 3
 |  |  |  | 2 |  | 4 | [NAME] | 35 |  |  | 95
 |  |  |  | 3 |  | 2 | [NAME] | 40 |  |  | 5
 |  |  |  | 4 |  | 3 | [NAME] | 45 |  |  | 7878
 |  |  |  | 5 |  | 5 | [NAME] | 50 |  |  | 67
Spreadsheet: 286024d1388011722-date-and-time-conversion-sample
Sheet: Sheet1

Date and time
2012-12-10 21:50:01
2012-12-10 22:00:01
2012-12-10 22:10:01
2012-12-10 22:20:01
2012-12-10 22:30:01
2012-12-10 22:40:01
2012-12-10 22:50:01
2012-12-10 23:00:01
2012-12-10 23:10:01
2012-12-10 23:20:01
2012-12-10 23:30:01
2012-12-10 23:40:01
2012-12-10 23:50:01
10/13/12 12:00:01 AM
10/13/12 12:10:01 AM
10/13/12 12:20:01 AM
10/13/12 12:30:01 AM
10/13/12 12:40:01 AM
10/13/12 12:50:01 AM
10/13/12 1:00:01 AM
10/13/12 1:10:01 AM
10/13/12 1:20:01 AM
10/13/12 1:30:01 AM
10/13/12 1:40:01 AM
10/13/12 1:50:01 AM
Spreadsheet: 869595d1716208411-index-and-match-multiple-rows-only-returning-top-row-gw_test2
Sheet: Sheet3

 | Dataset |  |  |  | Index and Match retrieve
 | Unique ID | Town | In the area? |  | Unique ID | In the area?
 | A2G00043 | Bury | No |  | A2G00043
 | A2G00044 | Matlock | No |  | A2G00044
 | A2G00044 | Matlock | Yes |  | A2G00045
 | A2G00045 | [NAME] | No |  | A2G00052
 | A2G00052 | Rochdale | Yes |  | A2G00053
 | A2G00053 | Oldham | Yes |  | A2G00054
 | A2G00054 | Stockport | Yes |  | A2G00065
 | A2G00065 | [NAME] | No |  | A2G00067
 | A2G00067 | [NAME] | No |  | A2G00078
 | A2G00078 | Partington | No
 | A2G00078 | Partington | Yes
Spreadsheet: 703037d1604682618-conditioning-formatting-formula-if-count-within-range-has-no-x-grey-it-out-test654321
Sheet: Tests

Fabric | Year 1 | Unit Price | # of Units | Total
Silk | No | 20 | 3
[NAME] | Yes | 15 | 2
Velvet | Yes | 30 | 6 |  |  |  |  |  | Yes
Cotton | No | 20 | 3 |  |  |  |  |  | No
Chiffon | Yes | 34 | 2
Wool | Yes | 10 | 8
Spreadsheet: 885247d1734691924-function-to-match-given-set-of-numbers-and-concatinate-test
Sheet: Sheet1

Data is in row  A1 TO G1 |  |  |  |  |  |  | function  to give result for even numbers | function to give result for odd numbers |  |  | Even numbers | Corresponding  Number | Odd numbers | Corresponding  Number
 | 12 |  |  |  |  | 25 | 3 | 5 |  |  | 10 | 1 | 1 | 1 |  | task look for odd numbers from rows A to G, match with numbers in column N2:N16 , if found pick up corresponding number from  column O and put in one cell in I
14 |  |  |  |  |  |  | 5 |  |  |  | 12 | 3 | 3 | 3 |  | task look for even  numbers from rows A to G, match with numbers in column L2:L12 , if found pick up corresponding number from  column L and put in one cell
 |  | 19 |  |  |  |  |  | 1 |  |  | 14 | 5 | 5 | 5
36 |  |  |  | 46 |  |  | 9 | 1 |  |  | 16 | 7 | 7 | 7
7 |  | 28 |  | 25 |  | 32 | 15 | 77 |  |  | 18 | 9 | 9 | 9
 |  |  | 23 |  | 43 |  |  | 57 |  |  | 28 | 1 | 19 | 1
 |  |  |  |  |  |  |  |  |  |  | 30 | 3 | 21 | 3
 |  |  |  |  |  |  | final results are avove |  |  |  | 32 | 5 | 23 | 5
 |  |  |  |  |  |  |  |  |  |  | 34 | 7 | 25 | 7
 |  |  |  |  |  |  |  |  |  |  | 36 | 9 | 27 | 9
 |  |  |  |  |  |  |  |  |  |  | 46 | 1 | 37 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | 39 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  | 41 | 5
 |  |  |  |  |  |  |  |  |  |  |  |  | 43 | 7
 |  |  |  |  |  |  |  |  |  |  |  |  | 45 | 9
Spreadsheet: 9b24b156-1d31-49a2-b517-db298b88a326
Sheet: 2015-2016

2015-2016 Class Schedule |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | You may select up to three classroom attributes.  Select only course requirements, as the number of available classrooms will be reduced with each attribute selected.
Biochemistry
Spring 2016
Subject | Course and Title | Subtitle/Alternate Title | Days | Times | Sec | Part of Term | Credits | Hamline Plan | Instructor(s) | Instructor ID | FT or Adj | [NAME] | Registration Approval Required? | [NAME] | Seats to be Saved | Saved Seats Type | Campus: [NAME], [NAME], Online, Blended |  |  |  | Cross list? SUBJ CRSE SEC | XLST total enrl | Areas of Study | Comments
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Classroom Attribute A | Classroom Attribute B | Classroom Attribute C
Spreadsheet: kevin_ruscitti__20263__PLRates 05-01
Sheet: Meters

GREAT LAKES |  |  |  | TRUNKLINE
West Zone | Mileage |  |  | Major Delivery Points
Emerson | 0 |  |  |  |  |  | Zone
Carlton | 283.6 |  |  | [NAME] | ANR |  | Field
 |  |  |  | Centerville | Col Gulf |  | Field
Central Zone |  |  |  | Lebanon | Col Gulf |  | Zone 2
Fortune Lake | 487.7 |  |  | [NAME] | Florida Gas |  | Field
S. St. Marie- Michcon | 702 |  |  | Potamac | Midwestern |  | Zone 2
Sault St. Marie - TCPL | 704.9 |  |  | Lakeside | NGPL |  | Field
[NAME] | 498.4 |  |  | Shadyside | Sonat |  | Field
 |  |  |  | Centerville | [NAME] |  | Field
Eastern Zone |  |  |  | [NAME] | Texas Eastern |  | Zone 1B
[NAME] | 757.1 |  |  | Tuscola | PEPL |  | Zone 2
Farwell | 815.7 |  |  | Dyersburg | Texas Gas |  | Zone 1A
[NAME] | 844.7 |  |  | Epps | Storage |  | Zone 1A
Bell River | 969.9 |  |  | Shaw | [NAME] |  | Zone 1A
St. Clair | 973.2 |  |  | Bourbon | Illinois Power |  | Zone 1B
Muhonville | 960.3 |  |  | Perryville | Noram In& Out |  | Zone 1A
 |  |  |  | Consumers | Trunkline |  | Zone 2
PEPL
sithe points |  |  |  | RELIANT
 |  |  |  | Point |  | Pool | R/D
 | Mileage | R/D |  | ANR- Perryville |  | SE | R
Pony Express (PNYEX) | 181 | R |  | MRT-Glendale |  | South | R
Bourbon ([NAME]) | 538 | D |  | MRT-Perryville |  | SE | D/R
Illinois Power (ILLPW) | 540 | D |  | NGPL-Hot Springs |  | SE | D
Indiana Gas (INGAS) | 667 | D |  | NNG - Red Moon |  | W1AD | D
WNG | 145 | R |  | Tenn-100 [NAME] |  | SE | D/R
Michigan Gas Storage (MGS) | 883 | D |  | TGT - Helena |  | NE | D
Missouri Gas Energy (MGEMO) | 267 | D |  | [NAME] |  | SW | SW
[NAME] (ANRDF) | 791 | D |  | Valero - Spray Berry |  | South | D
[NAME] (CRSRD) | 788 | D |  | WNG - Jane |  | North | D/R
Columbia Gas (COLGA) | 820 | D
Columbia Gas Ohio (COLOH) | 841 | D
NGPL Moultrie (NGPLM) | 520 | D
Central Ill Pub Serv (CIPS) | 470 | D
Texas Gas | 589 | D
Union Electric (UNELE) | 332 | D
Missouri Public Serv (MOPUB) | 287 | D
Lebanon  Lateral-TETCO (02821) | 700 | D
Michcon (MCON) | 888 | D
Union Windsor Canada (UNION) | 885 | D
Dayton Power and Light (DAYPL) | 732 | D
DP&L #2 (02830) | 733 | D
DP&L #3 (02559) | 733 | D
East Ohio (EOHIO) | 841 | D
Spreadsheet: 803499d1667493189-automatically-inputting-data-from-a-seleceted-month-into-a-sheet-test-2
Sheet: REport

 | Brand A | Part Number | Month Qty Required |  | Please select Month | January
 | Brand A | PN282EFI
 | Brand A | PN282EFI
 | Brand A | PN282EFI
 | Brand A | PN282EFI
 | Brand A | PN283WFI
 | Brand A | PN283EFI
 | Brand A | PN283EFI
 | Brand A | PN284EFI
 | Brand A | PN284EFI