tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 101588d1299689728-convert-horizontal-to-vertical-normalizinglist1
Sheet: Sheet5

DC | Type | Date | Amount |  | Sum of Amount |  |  |  | <-- FINAL PIVOT TABLE
68225 | GrossSales | 2011-01-08 00:00:00 | 450781 |  | DC | Type | Date | Total
68225 | GrossSales | 2011-02-08 00:00:00 | 505799 |  | 42244 | GrossSales | 2011-01-08 00:00:00 | 1082832
68225 | GrossSales | 2011-03-08 00:00:00 | 525418 |  |  |  | 2011-02-08 00:00:00 | 2045248
68225 | GrossSales | 2011-04-08 00:00:00 | 854186 |  |  |  | 2011-03-08 00:00:00 | 1966902
42244 | GrossSales | 2011-01-08 00:00:00 | 1082832 |  |  |  | 2011-04-08 00:00:00 | 1479986
42244 | GrossSales | 2011-02-08 00:00:00 | 2045248 |  |  | Iincentives | 2011-01-08 00:00:00 | 1001224
42244 | GrossSales | 2011-03-08 00:00:00 | 1966902 |  |  |  | 2011-02-08 00:00:00 | 1051184
42244 | GrossSales | 2011-04-08 00:00:00 | 1479986 |  |  |  | 2011-03-08 00:00:00 | 1247438
45239 | GrossSales | 2011-01-08 00:00:00 | 973195 |  |  |  | 2011-04-08 00:00:00 | 1244621
45239 | GrossSales | 2011-02-08 00:00:00 | 1626944 |  | 42244 Total |  |  | 11119435
45239 | GrossSales | 2011-03-08 00:00:00 | 1210509 |  | 45239 | GrossSales | 2011-01-08 00:00:00 | 973195
45239 | GrossSales | 2011-04-08 00:00:00 | 986249 |  |  |  | 2011-02-08 00:00:00 | 1626944
68225 | Iincentives | 2011-01-08 00:00:00 | 575963 |  |  |  | 2011-03-08 00:00:00 | 1210509
68225 | Iincentives | 2011-02-08 00:00:00 | 1301511 |  |  |  | 2011-04-08 00:00:00 | 986249
68225 | Iincentives | 2011-03-08 00:00:00 | 1473719 |  |  | Iincentives | 2011-01-08 00:00:00 | 844135
68225 | Iincentives | 2011-04-08 00:00:00 | 1492196 |  |  |  | 2011-02-08 00:00:00 | 1229691
42244 | Iincentives | 2011-01-08 00:00:00 | 1001224 |  |  |  | 2011-03-08 00:00:00 | 1038124
42244 | Iincentives | 2011-02-08 00:00:00 | 1051184 |  |  |  | 2011-04-08 00:00:00 | 899851
42244 | Iincentives | 2011-03-08 00:00:00 | 1247438 |  | 45239 Total |  |  | 8808698
42244 | Iincentives | 2011-04-08 00:00:00 | 1244621 |  | 68225 | GrossSales | 2011-01-08 00:00:00 | 450781
45239 | Iincentives | 2011-01-08 00:00:00 | 844135 |  |  |  | 2011-02-08 00:00:00 | 505799
45239 | Iincentives | 2011-02-08 00:00:00 | 1229691 |  |  |  | 2011-03-08 00:00:00 | 525418
45239 | Iincentives | 2011-03-08 00:00:00 | 1038124 |  |  |  | 2011-04-08 00:00:00 | 854186
45239 | Iincentives | 2011-04-08 00:00:00 | 899851 |  |  | Iincentives | 2011-01-08 00:00:00 | 575963
 |  |  |  |  |  |  | 2011-02-08 00:00:00 | 1301511
 |  |  |  |  |  |  | 2011-03-08 00:00:00 | 1473719
 |  |  |  |  |  |  | 2011-04-08 00:00:00 | 1492196
 |  |  |  |  | 68225 Total |  |  | 7179573
 |  |  |  |  | Grand Total |  |  | 27107706
Spreadsheet: 217325d1362044950-calendar-task-list-task-tracker
Sheet: How to use

0.7
Notes:-
 | This tracker is everything about showing which tasks are ongoing which ones are completed and which ones are Delayed.
1 | Enter start date of tracker in "K1"
2 | Enter Task description in column "B".
 | As soon as you enter task description that task will be highlighted as "Delayed"
 | Something like the above image.
 | Don’t Worry
3 | Enter Start Date in column "G".
4 | Enter Duration of task in Column "H"
 | And the task status will be seen as ONGOING.
5 | Now you will also delay a task(That is why you want to use this tracker).
6 | The tracker is designed so as to if you do not complete the task with in 70% duration of what you have set in "Duration"  it will show as Delayed.
7 | You can set this delay intimation by changing A1 of How to use sheet
8 | Once you complete the task put your task completion comments in column J and the task will be highlighted Gray and status of the task will be seen as Completed.
Spreadsheet: d864b602-5b45-488f-9c6a-a4df9fb446a6
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
F100B | Test | F100B | S-100B Protein, Serum | S-100B Protein, Serum | Quantitative Enzyme-Linked Immunosorbent Assay |  |  |  |  |  | Draw blood in a plain, red-top tube(s). (Serum gel tube is acceptable.) Allow specimen to clot at room temperature. Spin down and send 2 mL of serum refrigerated in a plastic vial. | 0.5 mL | Hemolysis:	NA Thawing:	Warm reject, Cold OK Lipemia:	NA Icterus:	NA Other:	NA | 0 - 96 ng/L  This assay is performed using the CanAg S100 Enzyme Immunoassay. Results obtained with different assay methods or kits cannot be used interchangeably.  Test Performed by: ARUP Laboratories                              500 [NAME]St. Lake City, UT 84108 | Tuesday | 1 - 8 days | 3 - 18 days | 1 | 86316 |  |  |  |  | ARUP Laboratories
F100B | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
F100B | Result | Z2708 | S-100B Protein, S | S-100B Protein, S | Alphanumeric
Spreadsheet: 153226d1335808828-making-a-schedule-with-auto-time-format-and-adding-total-hours-se-schedule
Sheet: August 1

 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
 | 2011-08-01 00:00:00 | 2011-08-02 00:00:00 | 2011-08-03 00:00:00 | 2011-08-04 00:00:00 | 2011-08-05 00:00:00 | 2011-08-06 00:00:00
[NAME] |  | 9:30-5:30 | 8:00-5:00 | 8:00-5:00 | 8:30-5:30 | 9:15-5:15
 | off | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00
[NAME] | 8:30-5:30 | 8:30-5:30 | 9:30-5:30 | 8:30-5:30 | 9:30-5:30 | off
 | 2:00-3:00 | 2:00-3:00 | 2:00-3:00 | 2:00-3:00 | 2:00-3:00
Ray | 8:00-5:00 | 8:00-5:00 | 8:00-4:00 | 7:00-4:00 | 8:00-4:00
 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 | off
Mark | 8:30-5:30 | 9:00-4:00 | 8:30-5:30 | 8:30-5:30 | off | 9:00-5:00
 | 1:00-2:00 | 1:00-2:00 | 1:00-2:00 | 1:00-2:00 | off | 1:00-2:00
[NAME] | 8:00-4:00 | off | 8:30-5:30 | 7:00-4:00-HOMER | 8:00-5:00 | 9:15-5:15-ctr
ctr 12-2 | 11:00-12:00 | off | 11:00-12:00 | 1ub | 11:00-12:00 | 11:00-12:00
Kat |  |  | 8:00-5:00 |  |  | 9:15-5:15
 |  |  | 12:00-1:00 |  |  | 12:00-1:00
 |  |  | 12:00-1:00
 |  |  |  |  |  | total hours
Spreadsheet: 778834d1651367247-help-needed-for-sum-up-time-totals-workingpaytemplate
Sheet: Help Needed Sheet

Sunday |  | Platform |  | Pays
Daily HOS | Overall Hours | Platform | Non Platform | Overtime | Call-Up
Run # | Start Time | End Time | Extend | Duration | Task | Platform | Non Platform
 | 0700 | 1000 |  |  | Platform |  | 01:00:00
 | 1030 | 1200 |  |  | Platform
 | 1230 | 1700 |  |  | Platform
Call Up ? | No | 9:30 Booking | No | Additional HOS Minutes | 0
 |  |  | Totals
 |  |  | Non Platform
Hidden | Hidden | Hidden | Platform
 |  |  | Plat Reg Pay
 |  |  | Plat OT
 |  |  | Stand-By
 |  |  | OT / Scrounge
 |  |  | DAY
Spreadsheet: 833443d1686964676-conditional-formatting-with-uneven-rows-and-missing-cells-conditional-formatting
Sheet: Sheet1

 |  | MADDEN 03-19 | 85+ more than half (definite) |  |  | 85+ less than half (put in) |  |  | 80-84 more than half |  |  | 80-84 50/50 |  |  | 80-84 less than half
 |  | MADDEN 20-24 | 80+ more than half (definite) |  |  | 80+ less than half (put in) |  |  | 75-80 more than half |  |  | 75-80 50/50 |  |  | 75-80 less than half
 |  |  | OVERALL'S
YEAR | POS | NAME | OVR | OVR | OVR | OVR | OVR | OVR | OVR | OVR | OVR | OVR | OVR | OVR | OVR | OVR | OVR | OVR | OVR | OVR | OVR | OVR | OVR | OVR
06 | HB | [NAME] | 72 | 80 | 83 | 87 | 90 | 84 | 80 | 81
03 | FB | Darian Barnes |  |  |  | 75 | 73 | 84 | 78
06 | HB | [NAME] |  |  |  | 87 | 85 | 88 | 82
09 | WR | [NAME] | 78 | 63 | 76 | 80 | 82 | 81 | 77
10 | WR | Hakeem Nicks | 76 | 81 | 89 | 94 | 89 | 84 | 78 | 73
04 | SS | [NAME] | 66 | 84 | 87 |  | 74 | 72 | 66 | 80 | 79 | 77 | 73
05 | CB | [NAME] | 82 | 85 | 93 | 94 | 93 | 79 | 85 | 86 | 86 | 81 | 82 | 77 | 82 | 79
07 | FS | [NAME] | 79 | 80 | 77
08 | CB | [NAME] | 80 | 78 | 75 | 71 | 78 | 83 | 85
09 | FS | [NAME] | 75 | 64 | 77 | 80 | 82 | 84 | 81
07 | CB | Brent Grimes |  |  | 68 | 47 | 75 | 86 | 90 | 89 | 91 | 87 | 85 | 88 | 86
10 | SS | [NAME] | 75 | 75 | 82 | 81 | 87 | 83 | 80
11 | FS | [NAME] |  | 60 | 62 | 75 | 78 | 79 | 77 | 75 | 72 | 71
04 | TE | Visanthe Shiancoe | 63 | 69 | 69 | 70 | 75 | 79 | 78 | 86 | 84
08 | TE | [NAME] | 70 | 80 | 83 | 81 | 77 | 77
08 | TE | [NAME] | 69 | 72 | 72 | 70 | 71 | 46 | 50 | 57 | 62 | 55 | 55 | 52 | 51
Spreadsheet: 707555d1607347575-filtering-data-by-date-against-existing-data-problem
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | December
 |  |  | Staff 1 |  | Staff 2 |  | Staff 3 |  |  |  | Report 1 |  | Bucket 1 |  | Bucket 2 |  | Bucket 3 |  | 2020-12-01 00:00:00
 | Dates |  | Pass | Fail | Pass | Fail | Pass | Fail |  | Name | QC | Errors | QC | Errors | QC | Errors | QC | Errors | QC | Errors
 | Tuesday | 2020-12-01 00:00:00 | 12 | 2 | 15 | 3 | 22 | 1 |  | Staff 1 | 13 |  | 0 | 0 | 25 | 0 | 8 | 2
 | Wednesday | 2020-12-02 00:00:00 |  |  |  |  |  |  |  | Staff 2 | 15 |  | 0 | 0 | 12 | 1 | 7 | 0
 | Thursday | 2020-12-03 00:00:00 |  |  |  |  |  |  |  | Staff 3 | 30 |  | 0 | 0 | 9 | 0 | 15 | 0
 | Friday | 2020-12-04 00:00:00
 | Tuesday | 2020-12-08 00:00:00
 | Wednesday | 2020-12-09 00:00:00
 | Thursday | 2020-12-10 00:00:00
 | Friday | 2020-12-11 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | I need the yellow cells to pull the data
 | Monday | 2020-12-14 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | for each individual for the dates selected in cell T2
 | Tuesday | 2020-12-15 00:00:00
 | Wednesday | 2020-12-16 00:00:00
 | Thursday | 2020-12-17 00:00:00
 | Friday | 2020-12-18 00:00:00
 | Monday | 2020-12-21 00:00:00
 | Tuesday | 2020-12-22 00:00:00
 | Wednesday | 2020-12-23 00:00:00
 | Thursday | 2020-12-24 00:00:00
 | Friday | 2020-12-25 00:00:00
 | Monday | 2020-12-28 00:00:00
 | Tuesday | 2020-12-29 00:00:00
 | Wednesday | 2020-12-30 00:00:00
 | Thursday | 2020-12-31 00:00:00
Spreadsheet: 132573d1323821321-pdf-text-to-excel-spreadsheet-travelleisure
Sheet: Page_20

 |  |  |  | Media Outlet Results
Outlet Name | Outlet City | Outlet State | Outlet Type  Outlet Website |  |  | Outlet E-mail |  | Outlet Phone Number Outlet Circulation Keyword Outlet Source  AudienceRelevance
Personnel Guide | Toronto | ON | [NAME] |  | http://www.p | pg@baxter. |  | (416) 968-7252 | 0 | 74 | S
to Canada's |  |  | zine, |  | ersonnelgui | net
Travel Industry |  |  | trade/ |  | de.ca/
 |  |  | indust
 |  |  | ry
Public Relations | [NAME] | BC | News |  | [NAME] | colin@btbtr |  | (604) 543-7375 | 0 | 40 | S
Plus Program |  |  | /Rele |  | tbtravel.com | avel.com
 |  |  | ase
 |  |  | Distri
 |  |  | butio
 |  |  | n
 |  |  | Servi
 |  |  | ce
Qubein, Ramsey | High Point | NC | Freel |  |  | ramseyq@h |  | (336) 906-3789 | 0 | 54 | S
 |  |  | ance |  |  | otmail.com
 |  |  | Journ
 |  |  | alist
Road & Travel | [NAME] | MI | Onlin |  | http://www.r | courtney@r |  | (248) 546-4646 | 0 | 50 | S
 |  |  | e, |  | oadandtrave | oadandtrave
 |  |  | consu |  | l.com/ | l.com
 |  |  | [NAME]
[NAME], [NAME] | New York | NY | Freel |  | http://www.j | jdsiskin@g |  | (212) 786-1870 | 0 | 41 | S
 |  |  | ance |  | dsiskinorigin | mail.com
 |  |  | Journ |  | als.com/
 |  |  | alist
SmarterTravel.co | Charlestown | MA | Onlin |  | http://www.s | editor@sma |  | (617) 886-5555 | 0 | 69 | S
m |  |  | e, |  | martertravel | rtertravel.co
 |  |  | consu |  | .com | m
 |  |  | [NAME]
[NAME], [NAME] | Cincinnati | OH | Freel |  |  | jxs4travel@ |  | (513) 241-1093 | 0 | 67 | S
 |  |  | ance |  |  | aol.com
 |  |  | Journ
 |  |  | alist
Page: 20 |  |  |  |  |  |  |  |  |  |  | 12/13/2011
Spreadsheet: 725614d1616767614-excel-average-formula-with-array-test-25-ans
Sheet: Лист1

 | Current Stock | Current Unit price | Average unit Price
 | 3,10 | 2.43,2.57
 | 2,2 | 60,80
 | 2,10 | 5.35,6.15
 | 6,1 | 17.53,17.705
 | 6,1 | 17.53,17.705
 | 10,1 | 5.46,5.951
 | 3,6 | 27.35,28.17
 | 5,1 | 12.84,14.016
 | 10,1 | 4.31,5.043
 | 1,6 | 45.47,50.29
 | 1,10,1 | 73.5,74.24,74.731
 | 1,1 | 56.47,57.035
 | 47,2,5,462 | 0.11,0.05,0.11,0.05
 | 0,2 | 0.45,0.41
 | 1,1 | 7.6,7.6
 | 4,7 | 0.37,0.43
 | 3,20 | 2.24,2.24
 | 2,20 | 1.77,1.66
 | 1,2 | 1.015,1.07
 | 1,4 | 4.36,4.47
 | 0,0 | 4.97,4.84
 | 1,1 | 6.55,6.616
 | 1,1 | 20.54,16.83
 | 12,24 | 0.452,0.43
Spreadsheet: 542725d1508057108-drop-down-lists-book-gk-final
Sheet: Sheet1

Agent Name |  | Agent | Tasks |  |  |  |  | Agent |  | Tasks
 |  | [NAME] | Audit |  |  |  |  | Kaira
 |  | Kaira | Processes
 |  | Kai | Variations
 |  | [NAME] | over view
 |  | [NAME] | end of day
 |  | Kai | communications
 |  | [NAME] | Grouping
Spreadsheet: 216984d1361954753-formula-for-a-continuously-changing-array-test-file
Sheet: Sheet1

Data From a Scanner Populates here in each row
123480
123481
123482
123483
123483
123484
123485
123503
123487
123488
123488
123489
123490
123490
123491
123492
123498 | I need to verify the contents of A18 cell with all the cells above whether its unique or not
123499
123499
123502
123503
Spreadsheet: 0fda912a-6dbb-487d-8837-aca41cd5ef49
Sheet: 9b

Product1 | EUR3 | GBP | [NAME] | USD | AUD | CAD | OTHER | TOTAL
Fixed-Float | 292887 | 83017 | 45292 | 1421649 | 11108 | 40684 | 60362 | 1954999
OTHER* | 212060 | 12927 | 18557 | 563396 | 77721 | 20697 | 56263 | 961621
TOTAL | 504947 | 95944 | 63849 | 1985045 | 88829 | 61381 | 116625 | 2916620
*OTHER variable includes the following products: Swaption, Cap/Floor, Debt Option, Exotic, Fixed-Fixed, Inflation, Basis, OIS, and FRA.
Spreadsheet: 878294d1725367149-adding-relative-references-for-conditional-formatting-rule-therapy-hours-tracker-template
Sheet: Sheet1

 |  |  | Autumn Term | [NAME] | [NAME]
 |  |  | week 1-12 | week 13-24 | week 25-36
Student Name | [NAME] | Starting Week | Hours (input) | Hours (input) | Hours (input)
A | X | 1 | 12 | 24 | 36
B | Y | 13 | 0 | 12 | 24
C | Z | 25 | 0 | 0 | 12
Spreadsheet: 129932d1321978653-how-do-i-get-a-cell-to-sum-based-on-two-criteria-copy-of-drainage-material-pipe
Sheet: Drain order

 |  | Pipework
 |  | [NAME] | Length | m less junct, soc, spig rocker | No of Pipes | Type
 |  | 0.15 | 1.25 |  |  |  | Plastic |  |  | but also only sum it if it is plastic
 |  | 0.15 | 1.25 |  |  |  | Clay |  |  | but also only sum it if it is clay
 |  | 0.225 | 1.25 |  |  |  | Plastic |  |  | but also only sum it if it is plastic
 |  | 0.225 | 1.25 |  |  |  | Clay |  |  | but also only sum it if it is clay
 |  | 0.3 | 1.25 |  |  |  | Plastic |  |  | but also only sum it if it is plastic
 |  | 0.3 | 1.25 |  |  |  | Clay |  |  | but also only sum it if it is clay
 |  | 0.3 | 1.25 |  |  |  | Concrete |  |  | but also only sum it if it is concrete
 |  | 0.375 | 2.5
 |  | 0.45 | 2.5
 |  | 0.525 | 2.5
 |  | 0.6 | 2.5
 |  | 0.675 | 2.5
 |  | 0.75 | 2.5
 |  | 0.825 | 2.5
 |  | 0.9 | 2.5
 |  | 1.05 | 2.5
 |  | 1.2 | 2.5
 |  | 1.5 | 2.5
 |  | 1.6 | 2.5
 |  | 1.8 | 2.5
Spreadsheet: 122325d1316731768-pivot-table-new-audit-tool
Sheet: pivot

Date of Audit | (All)
 |  | Data
Resource | Resource Name | Count of 1. Both actual and desired pain documented using pain scale slider on initial visit | Count of 2. Both actual and desired pain documented using pain scale slider at ALL visits during the audit time frame under review | Count of 3. There were gaps in 24-hr follow up of unmanaged pain symptoms documented in clinical monitoring scales | Count of 4. Pain scale used  is documented in clinical monitoring scales comments
Admission Nurse | cathy | 1 | 1 | 1 | 1
 | [NAME] | 1 | 1 | 1 | 1
 | [NAME] | 1 | 1 | 1 | 1
Admission Nurse Total |  | 3 | 3 | 3 | 3
RN Case Manager | barb | 1 | 1 | 1 | 1
 | brat | 1 | 1 | 1 | 1
RN Case Manager Total |  | 2 | 2 | 2 | 2
(blank) | (blank)
(blank) Total
Grand Total |  | 5 | 5 | 5 | 5
Spreadsheet: 702406d1604332834-subtract-1-from-last-5-records-manualexamplev3
Sheet: Manual -what i would like

HOW IT IS CURRENTLY |  |  |  |  |  | WHAT I WOULD LIKE
A | B | A-B | SUM last 5 |  |  | A | B | SUM last 5 | SUM last 6
3 | 3 |  |  |  |  | 3 | 3 | 0
3 | 3 |  |  |  |  | 3 | 3 | -1
3 | 3 |  |  |  |  | 3 | 3 | -1
3 | 3 |  |  |  |  | 3 | 3 | -1
3 | 3 |  |  |  |  | 3 | 3 | -2
3 | 4 |  |  |  |  | 4 | 5 | -2
3 | 3 |  |  |  |  | 8 | 8 | -1
3 | 3 |  |  |  |  | 6 | 6 | -1
3 | 4 |  |  |  |  | 2 | 1 | -1
3 | 3 |  |  |  |  | 3 | 3 | 0
3 | 3 |  |  |  |  | 4 | 4 | 0
Spreadsheet: 8cd3f1e7-a935-4358-b343-588ee90d9000
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
MYGLS | Test | MYGLS | Myoglobin, Serum | Myoglobin, S | Latex Particle-Enhanced Immunoturbidometric Assay | Serum Gel Tube: SGT |  |  |  |  | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 1 mL | 0.5 mL | Hemolysis	NA Thawing	Cold OK; Warm reject Lipemia	Mild OK; Gross reject Icterus	NA Other	NA | < or =90 mcg/L | Monday through Sunday, continuous | 1 day | 2 days | 1 | 83874 |  |  |  |  | Rochester
MYGLS | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
MYGLS | Result | MYGLS | Myoglobin, S | Myoglobin, S | Numeric |  |  |  |  | mcg/L |  |  |  |  |  |  |  |  |  | 2639-3 | Myoglobin:MCnc:Pt:Ser/Plas:Qn:
Spreadsheet: 258793d1376854846-adult-baseball-league-schedule-2013fall-schedule-1-
Sheet: SEADOGS

Game # | week # | Visitors | Home | Field
4 | 1 | BAYSOX | SEADOGS | GHS
11 | 2 | SEADOGS | BAYSOX | [NAME]
7 | 2 | SEADOGS | REDWINGS | LBU
15 | 3 | TIGERS | SEADOGS | GHS
21 | 4 | MUDCATS | SEADOGS | GHS
26 | 5 | KEYS | SEADOGS | GHS
29 | 5 | REDWINGS | SEADOGS | [NAME]
30 | 6 | BYE | SEADOGS
34 | 6 | SEADOGS | TIGERS | [NAME]
39 | 7 | SENATORS | SEADOGS | GHS
Spreadsheet: 57248d1257363348-looking-up-and-returning-more-than-one-record-lookup-multiple-rows
Sheet: Sheet1

Styles | Description | Colour | Other info
JRY001 | [NAME] | Blue | This is a great looking top
JRY001 | [NAME] | Red | The red colour is more suited for girls. Looks like pink
JRY001 | [NAME] | Yellow | Ugly!
JRY002 | [NAME] | Black | too bland
JRY002 | [NAME] | Pink | Just like bubble gum
JRY002 | [NAME] | White | too bland
JRY002 | [NAME] | Blue | It's a nice darker blue
JRY003 | [NAME] | Yellow | who called a taxi on bike
JRY003 | Aviation Jersey | White | a classic
JRY003 | Aviation Jersey | Blue | Sky blue, a collectable
JRY003 | Aviation Jersey | Black | Should sell well with teams
Spreadsheet: 033d305d-cff9-418e-ab1e-33c6d7c1f9be
Sheet: 4. Exceptions

Colorado Department of Education
Maintenance of Effort Workbook
as required under IDEA (34 CFR §300.203)
Exception Totals Worksheet
Instructions:  No Input is necessary on this sheet.  Calculations are made automatically from data input on the Staff_Departures, HighCost_Students and Termination_of_Exps tabs of this workbook.  See Cell E45 to see Pass/Fail results after entering exceptions.
Reporting Year
Administrative Unit Code
Administrative Unit Name
Maintenance of Effort Shortfall from MOE_Input_Sheet |  |  | -0.35
Exceptions to Maintenance of Effort (see Federal IDEA Regulations 34 CFR §300.204):
Justify only to the amount of fiscal effort not maintained as noted on the Maintenance of Fiscal Effort Worksheet.  If the total justifications equal/exceed this amount then fiscal effort has been maintained for the reporting year.
Exception: |  | Amount(s)
34 CFR §300.204(a)
Voluntary Departure, by retirement or otherwise, or departure for just cause. ('[NAME]' worksheet) | 1.
34 CFR §300.204(c)
High Cost special education student moves, reaches maximum age, or no longer needs services. ('High Cost' worksheet) | 2.
34 CFR §300.204(d)
Termination of costly expenditures for Long-Term Purchases ('Termination_of_Exps' worksheet) | 3.
Allowable Federal Exceptions to Maintenance of Effort
Maintenance of Effort Surplus/(Shortfall)
Spreadsheet: 185137d1349518028-delete-empty-cells-in-selected-range-every-nth-row-data1
Sheet: Sheet8

 | Date
 | 2012-08-05 00:00:00 | 2012-08-06 00:00:00 | 2012-08-07 00:00:00
Item1
Page Views
Quantity Sold
Price Paid
Purchase Price
Revenue
Conversion Rate
CIR
Item2
Page Views
Quantity Sold
Price Paid
Purchase Price
Revenue
Conversion Rate
CIR
Item3
Page Views
Quantity Sold
Price Paid
Purchase Price
Revenue
Conversion Rate
CIR
Item4
Page Views
Quantity Sold
Price Paid
Purchase Price
Revenue
Conversion Rate
CIR
Item5
Spreadsheet: 135278d1325890422-how-can-i-change-the-criteria-in-an-array-to-replace-sumproduct-excel-forum
Sheet: YEARLY SUMMARIES

 | PILOT RECORD
 |  |  | YEAR: | SEP | SINGLE ENGINE PISTON |  | MEP | MULTI ENGINE PISTON |  | SETP | SINGLE ENGINE T/PROP |  | METP | MULTI ENGINE T/PROP
 |  |  | 2003
 | 1 |  |  |  |  |  |  |  |  |  | 0:00:00 | 0 |  | 0:00:00 | 0
 | 2 | 2003 |  |  | 0:00:00 | 0 |  | 0:00:00 | 0 |  | 0:00:00 | 0 |  | 0:00:00 | 0
 | 3 | 2003 |  |  | 0:00:00 | 0 |  | 0:00:00 | 0 |  | 0:00:00 | 0 |  | 0:00:00 | 0
 | 4 | 2003 |  |  | 0:00:00 | 0 |  | 0:00:00 | 0 |  | 0:00:00 | 0 |  | 0:00:00 | 0
 | 5 | 2003 |  |  | 0:00:00 | 0 |  | 0:00:00 | 0 |  | 0:00:00 | 0 |  | 0:00:00 | 0
 | 6 | 2003 |  |  | 0:00:00 | 0 |  | 0:00:00 | 0 |  | 0:00:00 | 0 |  | 0:00:00 | 0
 |  | 2003 | TOTALS 1st SIX MONTHS |  | 0:00:00 | 0 |  | 0:00:00 | 0 |  | 0:00:00 | 0 |  | 0:00:00 | 0
 | 7 | 2003 |  |  | 0:00:00 | 0 |  | 0:00:00 | 0 |  | 0:00:00 | 0 |  | 0:00:00 | 0
 | 8 | 2003 |  |  | 0:00:00 | 0 |  | 0:00:00 | 0 |  | 0:00:00 | 0 |  | 0:00:00 | 0
 | 9 | 2003 |  |  | 0:00:00 | 0 |  | 0:00:00 | 0 |  | 0:00:00 | 0 |  | 0:00:00 | 0
 | 10 | 2003 |  |  | 0:00:00 | 0 |  | 0:00:00 | 0 |  | 0:00:00 | 0 |  | 0:00:00 | 0
 | 11 | 2003 |  |  | 0:00:00 | 0 |  | 0:00:00 | 0 |  | 0:00:00 | 0 |  | 0:00:00 | 0
 | 12 | 2003 |  |  | 0:00:00 | 0 |  | 0:00:00 | 0 |  | 0:00:00 | 0 |  | 0:00:00 | 0
 |  |  | YEARLY TOTALS |  | 0:00:00 | 0 |  | 0:00:00 | 0 |  | 0:00:00 | 0 |  | 0:00:00 | 0
 |  |  | TOTALS PREV. YEAR |  | 0:00:00 | 0 |  | 0:00:00 | 0 |  | 0:00:00 | 0 |  | 0:00:00 | 0
 |  |  | TOTALS TO DATE |  | 0:00:00 | 0 |  | 0:00:00 | 0 |  | 0:00:00 | 0 |  | 0:00:00 | 0
Spreadsheet: 38517d1236687293-choose-ytd-and-month-figures-test
Sheet: Original Items

 | Original |  | F.M.V.
ORIGINAL ITEMS (ex VAT) | Cost |  | 0.5
ProLamp Ultra Violet Lamp Kit | 220
Autodiagnos MT Pro Kit | 7500
Vas 5052 | 4850
VAG 1551 | 2125
VAG 1763 Comp tester | 786
Bosch PMS100 Scope | 1850
Bosch 561 + trolley | 6913
VAS 6085 tool | 585
FSA 560 | 11500
[NAME] | 40000
VAS 5234 Brake Bleeder | 1790
Bosch Inj Machine K-Jet | 325
VAG 1451 ignition tester | 115
[NAME] | 520
AD100 Japanese tool | 2125
Klann Spring Compressor | 515
ASNU Ultrasonic inj machine | 4500
Hunter 411 4 wheel alignment machine | 11500
Seally fuel extraction machine | 495
Seally brake cleaning machine | 575
Seally extraction machine oil | 415
[NAME] tool | 650
[NAME] tester unit | 1050
Autodiagnose Abs test equipment | 1800
Depreciation (4 year straight line)
 |  | Jul 08 | Aug 08 | Sep 08 | Oct 08 | Nov 08 | Dec 08 | Jan 09 | Feb 09 | Mar 09 | Apr 09 | May 09 | Jun 09 |  | Jul 09 | Aug 09 | Sep 09 | Oct 09 | Nov 09 | Dec 09 | Jan 10 | Feb 10 | Mar 10 | Apr 10 | May 10 | Jun 10 |  | Jul 10 | Aug 10 | Sep 10 | Oct 10 | Nov 10 | Dec10 | Jan 11 | Feb 11 | Mar 11 | Apr 11 | May 11 | Jun 11
Opening  Fixed assets
Depreciation
Net Book Value
Spreadsheet: 453800d1459450015-need-function-to-average-hours-used-over-specific-dates-fs9-service-user-schedule-combined
Sheet: Sheet2

1 |  | 2016-04-01 00:00:00 | 2016-05-01 00:00:00
2 |  | 2016-05-02 00:00:00 | 2016-05-29 00:00:00
3 |  | 2016-05-30 00:00:00 | 2016-06-26 00:00:00
4 |  | 2016-06-27 00:00:00 | 2016-07-24 00:00:00
5 |  | 2016-07-25 00:00:00 | 2016-08-21 00:00:00
6 |  | 2016-08-22 00:00:00 | 2016-09-18 00:00:00
7 |  | 2016-09-19 00:00:00 | 2016-10-16 00:00:00
8 |  | 2016-10-17 00:00:00 | 2016-11-13 00:00:00
9 |  | 2016-11-14 00:00:00 | 2016-12-11 00:00:00
10 |  | 2016-12-12 00:00:00 | 2017-01-08 00:00:00
11 |  | 2017-01-09 00:00:00 | 2017-02-05 00:00:00
12 |  | 2017-02-06 00:00:00 | 2017-03-05 00:00:00
13 |  | 2017-03-06 00:00:00 | 2017-03-31 00:00:00