tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 2a1eb375-0ee4-43a9-8e4a-28bbb93b2c5e
Sheet: 1.3b General Student Pop

Institution
Indicator 1: Overall Institution Profile
Table 1.3b: General Student Population Demographics / AY 2011-12
Time period: Fall 2011 (October 15, 2011)
Please enter the institution's general student population background, and characteristics, including first-time entering students.
Age range of students
Number of students who are: |  |  | 15-17 | 18-21 | 22-24 | 25-34 | 35-49 | 50-64 | 65 & over
American Indian |  | M | 0 | 115 | 83 | 185 | 119 | 27 | 2
 |  | F | 7 | 206 | 157 | 341 | 233 | 100 | 11
Non-Indian |  | M | 1 | 2 | 4 | 10 | 10 | 5 | 2
 |  | F | 0 | 6 | 7 | 20 | 22 | 12 | 1
Speakers of American Indian Languages |  |  |  | None | Limited | Conversational | Fluent
American Indian |  | M |  | 444 | 87 | m | m
 |  | F |  | 913 | 142 | m | m
Non-Indian |  | M |  | 34 | m | m | m
 |  | F |  | 66 | 2 | m | m
Number of students who are |  |  |  |  |  | American Indian |  | Non-Indian
 |  |  |  |  |  | M | F | M | F
Single - No Children |  |  |  |  |  | 255 | 335 | 15 | 20
Single with dependent children |  |  |  |  |  | 209 | 556 | 7 | 18
Married - No Children |  |  |  |  |  | 8 | 16 | 3 | 5
Married with dependent children |  |  |  |  |  | 59 | 148 | 9 | 25
Responsible for elderly family members in home |  |  |  |  |  | m | m | m | m
Number of students who are |  |  |  |  |  | American Indian |  | Non-Indian
 |  |  |  |  |  | M | F | M | F
First Generation Students |  |  |  |  |  | m | m | m | m
Not First Generation Students |  |  |  |  |  | m | m | m | m
Primary residence is |  |  |  |  |  | American Indian |  | Non-Indian
 |  |  |  |  |  | M | F | M | F
On / near reservation (within 60 miles) |  |  |  |  |  | m | m | m | m
In-State |  |  |  |  |  | 527 | 1037 | 30 | 58
Out-of-State |  |  |  |  |  | 4 | 18 | 4 | 10
[NAME] |  |  |  |  |  | American Indian |  | Non-Indian
 |  |  |  |  |  | M | F | M | F
Average family income ($) in student's household |  |  |  |  |  | 11743 | 13019 | 14903 | 21099
Number of students employed less than 20 hrs/week (excluding work / study) |  |  |  |  |  | m | m | m | m
Number of students employed 20 or more hrs/week (excluding work / study) |  |  |  |  |  | m | m | m | m
Number of students eligible for financial aid |  |  |  |  |  | 381 | 741 | 16 | 33
Number of students in need, but not eligible for financial aid |  |  |  |  |  | 47 | 99 | 0 | 3
Number of students who |  |  |  |  |  | American Indian |  | Non-Indian
 |  |  |  |  |  | M | F | M | F
Are Veterans |  |  |  |  |  | 13 | 11 | 2 | 0
Notes:
Re. Speakers of American Indian Languages: the numbers represent yes/no answers.  Numbers on student's household income reflect only students who completed a FAFSA.
Spreadsheet: 101562d1299674963-vlookup-problem-copy-of-practice-payroll
Sheet: Time sheet

RETURN TO: |  |  | TEACHER
DUVAL COUNTY SCHOOL BOARD |  |  | PRINCIPAL | [NAME]
Business Services |  |  | CONSELOR
Payroll Department |  |  | CLERK
1701 Prudential Drive |  |  | OTHER
Jacksonville, FL 32207
 |  |  |  | Charge to:
Print Name |  |  | PA (Fund Ctr/R/C) No.
 |  |  | Function/Object
Personnel #/Social Security |  |  | [NAME]
321810000 |  |  | PAY PERIOD | 2011-03-07 00:00:00
HOME Base PA (Fund Center/RC) No. |  |  |  | START | END
TO BE FILLED OUT BY PART-TIME HOURLY EMPLOYEES IN INK.
COMPLETE IN DUPLICATE, RETAIN ON COPY , AND KITTO MARKS("") ARE NOT ACCEPTABLE
For days not worked , list "date and no hours" Do not include lunch time in the total number of hours worked.
Deliver original to the Payroll Department at 1701 Prudential Drive.
DATE | TIME IN | LUNCH TIME OUT | LUNCH TIME IN | TIME OUT | TOTAL NO. HOURS PAID
 | 07:00:00
 | 07:00:00
 | 07:00:00
 | 07:00:00
 | 07:00:00
 |  | TOTAL HOURS WORKED FIRST WEEK
 | 07:00:00
 | 07:00:00
 | 07:00:00
 | 07:00:00
 | 07:00:00
 |  | TOTAL HOURS WORKED SECOND WEEK
 |  |  | TOTAL HOURS PAID
EMPLOYEE’S SIGNATURE |  |  | SCHOOL NAME OR CENTER NO.
PRINCIPAL’S SIGNATURE |  |  | SUPERVISOR OR COORDINATOR’S SIGNATURE
DIRECTOR’S SIGNATURE
Spreadsheet: 2be316c3-8d75-49e7-8f98-a7d52a2ddc9f
Sheet: Supplemental Availability

Forward Capacity Market Availability Settlement Detail Report |  |  |  |  |  |  |  |  |  |  |  | Forward Capacity Market Availability Settlement Detail Report
SD_FCMAVAIL_<customer id>_<settlement_date>_<version>.CSV |  |  |  |  |  |  |  |  |  |  |  | SD_FCMAVAIL_<customer id>_<settlement_date>_<version>.CSV
<[NAME] |  |  |  |  |  |  |  |  |  |  |  | <[NAME]
Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:[NAME]:ss> GMT |  |  |  |  |  |  |  |  |  |  |  | Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:[NAME]:ss> GMT
Resource Information |  |  |  |  |  |  |  |  |  | Supplemental Availability Contract |  | Supplementing Resource |  | Supplemented Resource
Shortage Event ID | Trading Date | Trading Interval | Resource ID | Resource Name | Resource Type | Capacity Zone ID | Capacity Zone Name | Reserve Zone ID | Reserve Zone Name | Contract ID | Internal Reference ID | Supplementing Resource ID | Final Supplementing MW | Supplemented Resource ID | Final Supplemented MW
Number | Date | Hour End | Number | String | String | Number | String | Number | String | Number | String | Number | MW | Number | MW
Spreadsheet: 43443d1242117582-identifying-frequency-of-names-sample3
Sheet: Results

Sum of Count
Australian | Total |  | Sum of Count
b | 11 |  | Australian | Financial Review | Total
c | 9 |  | a | g | 2
a | 7 |  | a Total |  | 2
f | 5 |  | b | a | 1
d | 5 |  |  | g | 1
Grand Total | 37 |  |  | j | 4
 |  |  |  | k | 1
 |  |  |  | l | 2
Sum of Count |  |  |  | m | 1
Financial Review | Total |  | b Total |  | 10
g | 8 |  | c | a | 1
j | 8 |  |  | g | 1
l | 4 |  |  | j | 1
k | 4 |  |  | k | 1
m | 3 |  |  | l | 1
a | 3 |  | c Total |  | 5
Grand Total | 30 |  | d | a | 1
 |  |  |  | g | 1
 |  |  |  | k | 1
 |  |  |  | l | 1
 |  |  | d Total |  | 4
 |  |  | f | g | 1
 |  |  |  | j | 2
 |  |  |  | m | 1
 |  |  | f Total |  | 4
 |  |  |  | a Count | 3
 |  |  |  | g Count | 6
 |  |  |  | j Count | 7
 |  |  |  | k Count | 3
 |  |  |  | l Count | 4
 |  |  |  | m Count | 2
 |  |  | Grand Total |  | 25
Spreadsheet: 39215d1237401178-changing-cells-from-alpha-to-numeric-and-now-my-if-function-wont-work-stuck
Sheet: Sheet1

 |  |  |  | GKP PRODUCTION 2009 DOWNTIME REPORT |  |  |  |  |  | 7-10032
 |  |  |  |  |  | Remaining Available Entries:
 |  |  |  |  |  |  |  | Of: 9523
[NAME]: Enter Data In Gray Cells Only. If No Production Time Lost Leave the Start & Finish Time Blank |  |  |  |  |  |  |  |  |  | Total Time Lost Per Code Per Incident |  |  |  |  |  |  |  |  |  |  | Data For Pivot Charts
Week | Date M/D/Y | Line | Shift | Tech | Start Time (24hr) | End Time (24hr) | Code | Operational | Comments | Duration  (MIN) | Electrical (1) | Mechanical (2) | Delays/Stripping (3) | Delays/Milling (4) | Delays/Mixing (5) | Meeting/Training (6) | Cust/Development (7) | Delay/Weigh-up (8) | Power Outage (9) | Packaging (10) | Date_ | Month_ | Shift_ | Line_ | Technician_ | Shift_ | Week_ | Unscheduled Downtime_ | Scheduled Downtime_ | Operational Downtime_ | Mechanical Downtime_ | Call fixing time (MIN)_ | Week/Type_ | Week/Shift/Type_ | Shift/Type_
12 | 2009-03-16 06:45:00 | 3 | 1 |  | 2009-03-16 06:45:00 | 2009-03-16 06:55:00 | 6 | Y | RS  Meeting
12 | 2009-03-16 06:55:00 | 3 | 3 |  | 2009-03-16 06:55:00 | 2009-03-16 07:05:00 | 6 | Y | [NAME]
12 | 2009-03-16 07:10:00 | 3 | 1 |  | 2009-03-16 07:10:00 | 2009-03-16 07:20:00 | 2 | Y | Oil Line
12 | 2009-03-16 11:57:00 | 3 | 1 |  | 2009-03-16 11:57:00 | 2009-03-16 12:07:00 | 2 | Y | Flush Rings
12 | 2009-03-17 07:00:00 | 3 | 1 |  | 2009-03-17 07:00:00 | 2009-03-17 07:15:00 | 2 | Y | [NAME]
Spreadsheet: 2a47350f-e0fb-4888-a0bd-da2b81c206d6
Sheet: FORM

 |  | Division of School Finance |  | DISTRICT REVENUES AND EXPENDITURES                                 BUDGET FOR FY 2013 AND FY 2014 |  |  |  | ED-00110-37
 |  | 1500 Highway 36 West
 |  | Roseville, MN 55113-4266
GENERAL INFORMATION: Minnesota Statutes, section 123B.10 requires that every school board shall publish the subject data of this report.
District Name: |  |  |  |  |  |  | District Number:
FUND |  | FY 2013 BEGINNING FUND BALANCES | FY 2013 ACTUAL REVENUES AND TRANSFERS IN | FY 2013 ACTUAL EXPENDITURES AND TRANSFERS OUT | JUNE 30, 2013 ACTUAL FUND BALANCES | FY 2014 BUDGET REVENUES AND TRANSFERS IN | FY 2014 BUDGET EXPENDITURES AND TRANSFERS OUT | JUNE 30, 2014 PROJECTED FUND BALANCES
General Fund/Restricted |  | 0 | 0 | 0 |  | 0 | 0
General Fund/Other |  | 0 | 0 | 0 |  | 0 | 0
Food Service Fund |  | 0 | 0 | 0 |  | 0 | 0
Community Service Fund |  | 0 | 0 | 0 |  | 0 | 0
Building Construction Fund |  | 0 | 0 | 0 |  | 0 | 0
Debt Service Fund |  | 0 | 0 | 0 |  | 0 | 0
Trust Fund |  | 0 | 0 | 0 |  | 0 | 0
Internal Service Fund |  | 0 |  |  | 0 |  |  | 0
* OPEB Revocable Trust Fund |  | 0 | 0 | 0 |  | 0 | 0
OPEB Irrevocable Trust Fund |  | 0 | 0 | 0 |  | 0 | 0
OPEB Debt Service Fund |  | 0 | 0 | 0 |  | 0 | 0
TOTAL - ALL FUNDS
LONG-TERM DEBT |  |  |  | CURRENT STATUTORY OPERATING DEBT PER MINNESOTA STATUTES, SECTION 123B.81
Outstanding July 1, 2012 |  | 0 |  | AMOUNT OF GENERAL FUND DEFICIT, IF ANY, IN EXCESS OF 2.5% OF EXPENDITURES 06/30/2013 |  |  | 0
Plus: New Issues |  | 0
Less: Redemeed Issues |  | 0 |  | COST PER STUDENT - AVERAGE DAILY MEMBERSHIP (ADM) 06/30/2013
Outstanding June 30, 2013
SHORT-TERM DEBT |  |  |  | TOTAL OPERATING EXPENDITURES |  |  | 0
Certificates of Indebtedness |  | 0 |  | FY 2013 TOTAL ADM SERVED + TUITIONED OUT ADM + ADJUSTED EXTENDED ADM |  |  | 0
Other Short-Term Indebtedness |  | 0 |  | FY 2013 OPERATING COST PER ADM
The complete budget may be inspected upon request to the superintendent.
Comments:
* Other Post-Employment Benefits (OPEB)
Spreadsheet: 477463d1472304322-program-for-stitching-unit-sample-excel
Sheet: order form

CLIENT 1 |  |  |  |  |  |  |  | CLIENT 2 |  |  |  |  |  |  |  | CLIENT 3 |  |  |  |  |  |  |  | CLIENT 4
 |  | TOTAL S | TOTAL M | TOTAL L | TOTAL XL |  |  |  |  | TOTAL S | TOTAL M | TOTAL L | TOTAL XL |  |  |  |  | TOTAL S | TOTAL M | TOTAL L | TOTAL XL
 |  | 280 | 245 | 84 | 112 |  |  |  |  | 357 | 308 | 112 | 56 |  |  |  |  | 294 | 329 | 238 | 315
DATE |  | s | m | l | xl |  |  | DATE |  | s | m | l | xl |  |  | DATE |  | s | m | l | xl
20-8-2016 |  | 10 | 5 | 3 | 4 |  |  | 20-8-2016 |  | 21 | 14 | 4 | 2 |  |  | 20-8-2016 |  | 12 | 17 | 22 | 39
21-8-2016 |  | 20 | 15 | 6 | 8 |  |  | 21-8-2016 |  | 31 | 24 | 8 | 4 |  |  | 21-8-2016 |  | 22 | 27 | 26 | 41
22-8-2016 |  | 30 | 25 | 9 | 12 |  |  | 22-8-2016 |  | 41 | 34 | 12 | 6 |  |  | 22-8-2016 |  | 32 | 37 | 30 | 43
23-8-2016 |  | 40 | 35 | 12 | 16 |  |  | 23-8-2016 |  | 51 | 44 | 16 | 8 |  |  | 23-8-2016 |  | 42 | 47 | 34 | 45
24-8-2016 |  | 50 | 45 | 15 | 20 |  |  | 24-8-2016 |  | 61 | 54 | 20 | 10 |  |  | 24-8-2016 |  | 52 | 57 | 38 | 47
26-08-2016 |  | 60 | 55 | 18 | 24 |  |  | 26-08-2016 |  | 71 | 64 | 24 | 12 |  |  | 26-08-2016 |  | 62 | 67 | 42 | 49
26-08-2016 |  | 70 | 65 | 21 | 28 |  |  | 26-08-2016 |  | 81 | 74 | 28 | 14 |  |  | 26-08-2016 |  | 72 | 77 | 46 | 51
27-08-2016 |  |  |  |  |  |  |  | 27-08-2016 |  |  |  |  |  |  |  | 27-08-2016
Spreadsheet: ec0a2035-e8ae-47bf-83a9-815bb6bfe0a0
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Merch | 80688770754 | Meredith Andrews | Lemon You'Re Not Alone Ladies Large | 2008-03-21 | T-Shirt | Na | 15 | N | To Be Retired
Merch | 80688770716 | Meredith Andrews | Lemon  You'Re Not Alone Ladies Medium | 2008-03-21 | T-Shirt | Na | 15 | N | To Be Retired
Merch | 80688770617 | Meredith Andrews | Navy [NAME] Ladies Medium | 2008-03-21 | T-Shirt | Na | 15 | N | To Be Retired
Merch | 80688770600 | Meredith Andrews | Navy [NAME] Ladies Small | 2008-03-21 | T-Shirt | Na | 15 | N | To Be Retired
Spreadsheet: 800924d1665998178-formala-for-pulling-values-from-another-sheet-where-multiple-vlookup-search-results-exist-booking-sample-4
Sheet: Bookings

 |  |  |  | not to be pulled in to job sheets |  |  | not to be pulled in to job sheets
 | Date | Name | Address | City | Booking | Time | Price | Booking order 1 | Booking order 2 | Booking order 3
 | 2022-10-01 00:00:00 | George | 1 street, parkway | Sydney | 45 | 2:00pm - 3:00pm | 10 | Table | eee | yyy
 | 2022-10-01 00:00:00 | [NAME] | 5 big road, city | London | 56 | 10:00am - 4:00pm | 40 | Drum | Knife
 | 2022-10-01 00:00:00 | Adam | 6 rideway close, sydney | Amsterdam | 44 | 4:00pm - 4:00am | 500 | Chair | Table | Stand
 | 2022-10-08 00:00:00 | Wilfred | 33 Hay Street, Melbourne | Melbourne | 34 | 3:00am - 9:00pm | 555 | Wire | Chair | Mic
 | 2022-10-08 00:00:00 | [NAME] | 2 Queens close, Reading | Reading | 56 | 12:00pm - 4:00pm | 24 | Remote | Fork | Spoon
Spreadsheet: 688778d1595952607-using-data-validation-to-link-data-to-different-locations-excel-help-2-bebo-
Sheet: Pro-Forma Balance sheet Final

 | Opening 2012 | Adjustments  + | Adjustments - | ProForma  2012
Cash and Cash Equivalents | 250 |  | -250
Accounts Receivables | 450
Inventories | 600
Prepaids and Other Current Assets | 175
Total Current Assets
Property, Plant and Equipment, Net | 2500
Goodwill | 1000
Intangible Assets | 875
Other Assets | 150
Deferred Financing Fees |  | 90
Total Assets
Accounts Payable | 215
Accrued Liabilities | 275
Other Current Liabilities | 100
Total Current Liabilities
Revolving Credit Facility |  |  |  |  |  | Revolving Credit Facility Size | 250
Term Loan A |  |  |  |  |  | Revolving Credit Facility Draw
Term Loan B |  | 2150 |  |  |  | Term Loan A
Term Loan C |  |  |  |  |  | Term Loan B | 2150
2nd [NAME] |  |  |  |  |  | Term Loan C
Existing Bank Debt | 1000 |  | -1000 |  |  | 2nd [NAME]
Senior Notes |  |  |  |  |  | Senior Notes | 1500
Senior Suboridinate Notes |  |  |  |  |  | Senior Suboridinate Notes
Senior Suboridinate Notes |  |  |  |  |  | Senior Bridge Facility
Senior Bridge Facility |  |  |  |  |  | Senior Subordinate Bridge Facility
Senior Subordinate Bridge Facility |  |  |  |  |  | Equity Contribution | 2100
Existing Bond Debt | 500 |  | -500 |  |  | Rollover Equity
Mezzanine Debt |  |  |  |  |  | Cash and Cash Equivalents | 250
Existing Mezzanine Debt
Deferred Income Taxes | 300
Other-Long Term Liabilities | 110 |  |  |  |  | Equity Purchase Price | 4350
Total Liabilities |  |  |  |  |  | Existing Bank Debt | 1000
 |  |  |  |  |  | Existing Bond Debt | 500
[NAME] | 0 |  |  |  |  | Existing Mezzanine Debt | 0
Shareholders Equity | 3500 |  |  |  |  | Tender / Call Premiums | 20
Existing Shareholders Equity |  |  |  |  |  | Deferred Financing Fees | 90
Total Shareholders Equity |  |  |  |  |  | Other Fees and Expenses | 40
Total Liabilities and Equity
Spreadsheet: michael_maggi__26470__NYMEXWEEKLYSTATS
Sheet: SC

Week Ending: | 2001-02-01 00:00:00
 | Futures Settlement Prices
 | BRENT CRUDE OIL |  |  |  |  | Contract Symbol:  SC
 | Contract | Monday | Tuesday | Wednesday | Thursday | Friday | Open
 | Month | 2001-01-28 00:00:00 | 2001-01-29 00:00:00 | 2001-01-30 00:00:00 | 2001-01-31 00:00:00 | 2001-02-01 00:00:00 | Interest
 | 2002-03-01 00:00:00 | 19.6 | 19.22 | 18.77 | 19.18 | 19.98 | 55
 | 2002-04-01 00:00:00 | 19.77 | 19.4 | 18.98 | 19.36 | 20.18 | 10
 | 2002-05-01 00:00:00 | 19.88 | 19.49 | 19.09 | 19.49 | 20.24 | 20
 | 2002-06-01 00:00:00 | 19.79 | 19.6 | 19.15 | 19.43 | 20.12 | 275
 | 2002-07-01 00:00:00 | 19.79 | 19.6 | 19.18 | 19.44 | 20.11 | 98
 | Total Weekly Volume
 |  |  |  |  | Total Open Interest |  | 458
 |  |  |  | *Weekly volume and open interest reflects all traded months.
 | Historical Volatility-Spot Month Futures
 |  |  |  | Brent Crude Oil
 | 5 Day Hist. Vol. |  |  | N\A
 | 20 Day Hist. Vol. |  |  | N\A
 | Implied Volatility-Options
 |  |  |  | Brent Crude Oil
 | At the Money Call & Put
 |  |  |  | N\A
 | MON | TUE | WED | THUR | FRI | Total
Volume | 50 | 50 | 0 | 0 | 50
Spreadsheet: 190217d1351566997-reference-cell-date-in-worksheet-based-on-a-group-of-dates-in-another-worksheet-sample
Sheet: Calculations

 |  | Name:   [NAME] |  |  |  |  |  | EDM SRVS | Month: | October
 |  | DAY | MILEAGE | MILEAGE | PARKING | TOTALS |  | Description
 |  |  | <=100 kms | >100 kms
 |  | 2012-10-25 00:00:00 | 20
 |  | 2012-10-26 00:00:00 | 45
 |  |  |  |  |  |  |  | See Attach Sheet
 | TOTAL KM's |  | 65 | 0
 | MILEAGE RATE |  | 0.42 | 0.21
 | TOTAL |  | 27.3 | 0 | 0 | 27.3 | A
 | GST | @ 5/105 | 1.3 | 0 | 0 | 1.3 | C | ---------------]---> | 1.3
 | TOT-NET OF GST |  | 26 | 0 | 0 | 26 | D
 | NOTE:  *For expenses incurred less than 40km from your branch. |  |  |  |  | 27.3 |  | TOTAL FOR MONTH (A. ABOVE)
 | NOTE: **For expenses incurred more than 40km from your branch. |  |  |  |  |  |  | LESS: ADVANCED FUNDS
 |  |  |  |  |  | 27.3 |  | BALANCE DUE      __ MICROSERVE
 | EMPLOYEES SIGNATURE: |  |  | _______[NAME]_______ |  |  |  | DATE: | October, 29 2012
 | APPROVAL 1:   _________________________________________ |  |  |  |  |  |  | DATE:   ____________________________
 | APPROVAL 2:   _________________________________________ |  |  |  |  |  |  | DATE:_____________________________
Spreadsheet: 21118d1208269299-listing-cells-that-meet-a-criteria-trsetparameters
Sheet: TR1

Date | Neutralization Number (Acid) | D877 | SPGR | Visual | Sediment | Moisture | Furans | Hydrogen | Methane | [NAME] | [NAME] | Ethylene | [NAME] | Total Combustibles
2005-02-22 00:00:00 | 0.03 | 34 | 0.96 | CLR | NONE | 7 | ND | 289 | 51 | 1812 | 14 | 6 | ND | 2172
2008-03-06 00:00:00 | 0.02 | 46 | 0.97 | CLR | NONE | 12 | 1 | 132 | 51 | 1868 | 17 | 5 | ND | 2073
Spreadsheet: 09ea1531-9a0f-45e6-8cf3-02523165425a
Sheet: Sheet1

Math Sections | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Monday |  |  |  |  |  | Tuesday
08:00:00 | Math 0300.001 MWF | Math 0301.001 MTW |  |  | Math 0303.006 MWF |  | Math Multi.010 TR | Math 0301.016 TR | Math 0302.008 TR |  | Math 0302.011 TR
08:30:00
09:00:00
09:30:00 | Math 0300.002 MWF | Math 0301.007 MW |  | Math 0302.001 MWF | Math 0303.001 MWF | Math 0303.011 MWF | Math 0301.012 TR | Math 0301.003 TR | Math 0302.002 TR |  | Math 0303.002 TR
10:00:00
10:30:00
11:00:00 | Math 0301.013 MWF | Math 0301.004 MTW | Math 0301.015 MW | Math 0302.003 MTW | Math 0303.003 MTW | [NAME] | Math Multi.009 TR |  | Math 0302.006 TWR
11:30:00
12:00:00
12:30:00 | Math 0301.017 MW | Math 0301.006 MW |  | Math 0302.007 MWF | Math 0303.004 MWF |  | Math 0300.004 TR | Math 0301.013 TR |  | Math 0303.013 TR
01:00:00
01:30:00
02:00:00 |  | Math 0301.018 MW |  |  | Math 0303.014 MW |  | Math 0301.011 TR | Math 0301.005 TR | Math 0302.004 TR | Math 0303.005 TWR
02:30:00
03:00:00
03:30:00 |  |  |  |  |  |  |  | Math 0301.019 TR
04:00:00 |  |  |  | Math 0302.005 MW
04:30:00
05:00:00 |  | Math 0301.200 MW |  |  | Math 0303.200 MW |  | Math 0300.201 TR | Math 0301.201 TR
05:30:00 | Math 0300.200 MW |  | Math 0301.205 MW | Math 0302.200 MW |  | Math 0303.203 MW |  |  | Math 0302.201 TR | Math 0303.201 TR | Math 0303.204 TR
06:00:00
06:30:00
07:00:00 | Math 0300.202 MW | Math 0301.202 MW |  | Math 0302.202 MW | Math 0303.202 MW |  |  | Math 0301.204 TR | Math 0302.203 TR | Math 0303.203 TR
07:30:00
08:00:00
08:30:00
09:00:00
09:30:00
Spreadsheet: 717866d1612884507-index-and-match-function-with-several-columns-roster-vs-schedule-example
Sheet: Schedule

Day | Monday | Monday | Monday | Tuesday | Tuesday | Wednesday
System | System 1 | System 2 | System 3 | System 4 | System 5 | System 6
Extract Names from Roster tab List which are not in listed above based on day for multiple columns
Monday | Tuesday | Wednesday
 |  |  |  | Everything to the left will be formulas which can auto update based on data entered above. It should also alow for columns to be added or deleted above without having to change the formulas to the left. For example if a new system is added in between column B and C there would then be 6 systems showing from colums B to G. The formulas to the left should also account for the new system automatically based on the day for that system.
 |  |  |  |  |  | Name | System
 |  |  |  |  |  | Test 1 | System 1
 |  |  |  |  |  | Test 2 | System 2
 |  |  |  |  |  | Test 3 | System 3
 |  |  |  |  |  | Test 4 | System 4
 |  |  |  |  |  | Test 5 | System 5
 |  |  |  |  |  | Test 6 | System 6
 |  |  |  |  |  | Test 7 | System 7
 |  |  |  |  |  | Test 8 | System 8
 |  |  |  |  |  | Test 9 | System 9
 |  |  |  |  |  | Test 10 | System 10
Spreadsheet: 48459d1247669541-last-transaction-value-test
Sheet: Sheet3

Item Code
 | Last Transaction Value
30100 | 1.04 | I wanted June Value(1.04) here instead of 0.92
30101
30103 |  | This is april value
30300
30301
30305
30405
30406
30408
30418
30419
30450
30451
30483
30484
30485
30486
30488
30489
30516
30517
30518
30700
30701
30702
30703
30720
30909
30911
30915
30926
30927
30929
30931
30935
30940
30950
33010
34019
34020
34023
34030
34040
34056
39010
39025
39030
90100
90200
90280
90300
90301
90310
90315
90316
90600
Spreadsheet: 0f6bc7ef-c2ca-4f08-84ab-fbbb88c3d41a
Sheet: Sheet2

Canada Sales: Eastern Region
 | Ottawa | Toronto | Montreal | In-Store Sales Total | Online Sales Total | Total Sales
 | 13080 | 12553 | 11816 |  | 30633
 | 13321 | 12744 | 11933 |  | 21284
 | 15182 | 9650 | 12021 |  | 25550
 | 12963 | 10820 | 12267 |  | 28385
Spreadsheet: 742188d1627572584-how-to-add-a-mtd-graph-in-my-dashboard-that-is-made-up-of-daily-data-help-how-to-add-a-mtd-graph-in-my-dashboard-that-is-made-up-of-daily-data
Sheet: Raw Data

Date | Calls Offered | Calls Handled | Answer Call Rate
2021-07-01 00:00:00 | 50 | 48
2021-07-02 00:00:00 | 52 | 50
2021-07-03 00:00:00 | 56 | 54
2021-07-04 00:00:00 | 57 | 56
2021-07-05 00:00:00 | 52 | 49
2021-07-06 00:00:00 | 51 | 49
2021-07-07 00:00:00 | 45 | 44
2021-07-08 00:00:00 | 62 | 59
2021-07-09 00:00:00 | 63 | 59
2021-07-10 00:00:00 | 64 | 58
2021-07-11 00:00:00 | 68 | 65
2021-07-12 00:00:00 | 69 | 67
2021-07-13 00:00:00 | 52 | 50
2021-07-14 00:00:00 | 56 | 52
2021-07-15 00:00:00 | 51 | 50
2021-07-16 00:00:00 | 54 | 52
2021-07-17 00:00:00 | 57 | 55
2021-07-18 00:00:00 | 50 | 48
2021-07-19 00:00:00 | 52 | 50
2021-07-20 00:00:00 | 56 | 54
2021-07-21 00:00:00 | 57 | 56
2021-07-22 00:00:00 | 52 | 49
2021-07-23 00:00:00 | 51 | 49
2021-07-24 00:00:00 | 45 | 49
2021-07-25 00:00:00 | 62 | 59
2021-07-26 00:00:00 | 63 | 59
2021-07-27 00:00:00 | 64 | 58
2021-07-28 00:00:00 | 68 | 65
2021-07-29 00:00:00 | 69 | 67
MTD
Spreadsheet: 722591d1615323125-how-filter-out-rows-where-the-end-date-does-not-immediately-preceed-current-record-example
Sheet: Sheet1

Employee_id | LEAVE_START_DATE | LEAVE_END_DATE | Number of Days off | Total Num of Days
12345 | 2010-03-23 00:00:00 | 2010-05-17 00:00:00 | 55
12345 | 2010-05-18 00:00:00 | 2012-12-20 00:00:00 | 947
12345 | 2012-12-21 00:00:00 | 2013-08-31 00:00:00 | 253
12345 | 2013-09-01 00:00:00 | 2021-03-05 00:00:00 | 2742 | 55 + 947 + 253 +2742
23456 | 2017-09-01 00:00:00 | 2018-08-31 00:00:00 | 364
23456 | 2018-09-01 00:00:00 | 2019-08-31 00:00:00 | 364
23456 | 2019-09-01 00:00:00 | 2020-08-31 00:00:00 | 365
23456 | 2020-09-01 00:00:00 | 2021-03-05 00:00:00 | 185 | 364 + 364 + 365 + 185
34567 | 2010-06-23 00:00:00 | 2010-08-31 00:00:00 | 69
34567 | 2010-09-01 00:00:00 | 2010-11-14 00:00:00 | 74
34567 | 2010-11-15 00:00:00 | 2011-01-13 00:00:00 | 59
34567 | 2011-01-14 00:00:00 | 2012-08-31 00:00:00 | 595
34567 | 2012-09-01 00:00:00 | 2021-03-05 00:00:00 | 3107 | 69 + 74 + 59 + 595 +3107
45678 | 1999-09-01 00:00:00 | 2000-08-31 00:00:00 | 365
45678 | 2000-09-01 00:00:00 | 2001-08-31 00:00:00 | 364
45678 | 2021-01-04 00:00:00 | 2021-03-05 00:00:00 | 60 | 60
56789 | 2019-02-19 00:00:00 | 2019-08-31 00:00:00 | 193
56789 | 2020-10-10 00:00:00 | 2021-03-05 00:00:00 | 146 | 146