tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 67467d1268085550-list-dates-when-multiple-criteria-is-met-satreport
Sheet: SAT

Test Score ID Reference >> |  |  |  |  |  |  | 16 | 16 | 383 | 383 | 17 | 17 | 18 | 18 |  | 16 | 16 | 383 | 383 | 17 | 17 | 18 | 18 |  | 16 | 16 | 383 | 383 | 17 | 17 | 18 | 18 |  | 16 | 16 | 383 | 383 | 17 | 17 | 18 | 18
 | Highest Scores |  |  |  |  | Attempt #1 | Critical Reading |  | Essay |  | Math |  | Writing |  | Attempt #2 | Critical Reading |  | Essay |  | Math |  | Writing |  | Attempt #3 | Critical Reading |  | Essay |  | Math |  | Writing |  | Attempt #4 | Critical Reading |  | Essay |  | Math |  | Writing
Wave-Maker | Overall | Critical Reading | Essay | Math | Writing | Date Taken | Number Score6 | National Percentile2 | Number Score7 | National Percentile8 | Number Score9 | National Percentile10 | [NAME] | National Percentile12 | Date Taken2 | Number Score63 | National Percentile24 | Number Score75 | National Percentile86 | Number Score97 | National Percentile108 | Number Score119 | National Percentile1210 | Date Taken | Number Score63 | National Percentile24 | Number Score75 | National Percentile86 | Number Score97 | National Percentile108 | Number Score119 | National Percentile1210 | Date Taken | Number Score63 | National Percentile24 | Number Score75 | National Percentile86 | Number Score97 | National Percentile108 | Number Score119 | National Percentile1210
Griffin, Stewie
Griffin, Stewie |  |  |  |  |  | 2007-10-04 00:00:00 | 300 |  | 1 |  | 300 |  | 600 |  | 2007-10-05 00:00:00 | 390 |  | 0 |  | 520 |  |  |  | 2009-05-02 00:00:00 | 470 |  | 0 |  | 490 |  | 470 |  | 2009-06-06 00:00:00 | 380 |  | 0 |  | 350 |  | 370
Spreadsheet: a338b62c-458b-4295-bb63-398d7578a23d
Sheet: Exp as a % of Rev

 |  |  |  |  |  |  |  |  |  |  | Pro Forma Operating Expenses as a % of Revenue
 | 2007 |  |  |  |  |  | 2008 |  |  |  |  |  | Growth
 | 1Q | 2Q | 3Q | 4Q | FY |  | 1Q | 2Q | 3Q | 4Q | FY |  | 1Q | 2Q | 3Q | 4Q | FY
Product Operating Expense as a % of Product Revenue
Video Programming (% of Video Rev)
Voice (% of Voice Rev)
High-Speed Internet (% of HSI Rev)
Operating Expense as a % of  Cable and Programming Revenue
Video Programming (% of Cable Rev)
Technical Labor (% of Cable Rev)
Voice (% of Cable Rev)
High-Speed Internet (% of Cable Rev)
Other (% of Cable Rev)
Total Cable Operating Expense  (% of Cable Rev)
Customer Service (% of Cable Rev)
Marketing (% of Cable Rev)
Administrative and Other  (% of Cable Rev)
Total Cable SG&A  (% of Cable Rev)
Total Cable  (% of Cable Rev)
Programming (% of Programming Rev)
Corporate and Other (% of Total Rev)
Total Consolidated Operating Expense (% of Total Rev)
Operating Cash Flow (OCF)
Cable | 2876 | 3124 | 3050 | 3196 |  |  | 3142 | 3362 | 3251 | 3415 | 13170
Programming | 64.53768376666667 | 75 | 97 | 49 |  |  | 113.30410793 | 89 | 105.16293284 | 55.03238907200003
Corporate & Other | -96 | -93 | -143 | -91 |  |  | -81 | -100 | -119
Total Consolidated OCF
Cable
Programming
Total Consolidated OCF Margin
* Business Services Revenue (included in Total Cable) | 87 | 95 | 102 | 110 |  |  | 120 | 131 | 145 | 162
Total Operating Expense as a % of Total Revenue
Total Cable (% of Total Rev)
Programming (% of Total Rev)
Corporate and Other (% of Total Rev)
Total Consolidated Operating Expense (% of Total Rev)
Note: Pro Forma adjustments for 2007 include the cable system acquired from Patriot Media, the SportsNet Bay Area/Sports Channel New England acquisitions and the cable systems acquired
as a result of the dissolution of our cable partnership with Insight Communications.
(1) Results have been adjusted to reflect the impact of the Insight, [NAME], New England SN and Bay Area SN Acquisitions
Revenue:
Cable | 7212 | 7557 | 7593 | 7758 |  |  | 7916 | 8100 | 8131 | 8296
Programming | 302 | 334 | 330 | 348 |  |  | 363 | 366 | 347 | 350
Corporate & Other | 88 | 48 | 51 | 89 |  |  | 110 | 87 | 71 | 119
Total Consolidated Revenue
Spreadsheet: 134396d1325265553-creating-a-graph-with-scroll-and-checkboxes-pnl_qty
Sheet: data

 |  |  |  |  | True | True | 3
 | date | total pnl | total qty
 | 2011-01-03 00:00:00
 | 2011-01-04 00:00:00
 | 2011-01-05 00:00:00
 | 2011-01-06 00:00:00 |  |  |  | date
 | 2011-01-07 00:00:00 |  |  |  | total pnl
 | 2011-01-10 00:00:00 |  |  |  | total qty
 | 2011-01-11 00:00:00
 | 2011-01-12 00:00:00
 | 2011-01-13 00:00:00
 | 2011-01-14 00:00:00
 | 2011-01-17 00:00:00
 | 2011-01-18 00:00:00
 | 2011-01-19 00:00:00
 | 2011-01-20 00:00:00
 | 2011-01-21 00:00:00
 | 2011-01-24 00:00:00
 | 2011-01-25 00:00:00
 | 2011-01-26 00:00:00
 | 2011-01-27 00:00:00
 | 2011-01-28 00:00:00
 | 2011-01-31 00:00:00
 | 2011-02-01 00:00:00
 | 2011-02-02 00:00:00
 | 2011-02-03 00:00:00
 | 2011-02-04 00:00:00
 | 2011-02-07 00:00:00
 | 2011-02-08 00:00:00
 | 2011-02-09 00:00:00
 | 2011-02-10 00:00:00
 | 2011-02-11 00:00:00
 | 2011-02-14 00:00:00
 | 2011-02-15 00:00:00
 | 2011-02-16 00:00:00
 | 2011-02-17 00:00:00
 | 2011-02-18 00:00:00
 | 2011-02-21 00:00:00
 | 2011-02-22 00:00:00
 | 2011-02-23 00:00:00
 | 2011-02-24 00:00:00
 | 2011-02-25 00:00:00
 | 2011-02-28 00:00:00
 | 2011-03-01 00:00:00
 | 2011-03-02 00:00:00
 | 2011-03-03 00:00:00
 | 2011-03-04 00:00:00
 | 2011-03-07 00:00:00
 | 2011-03-08 00:00:00
 | 2011-03-09 00:00:00
 | 2011-03-10 00:00:00
 | 2011-03-11 00:00:00
 | 2011-03-14 00:00:00
 | 2011-03-15 00:00:00
 | 2011-03-16 00:00:00
 | 2011-03-17 00:00:00
 | 2011-03-18 00:00:00
 | 2011-03-21 00:00:00
 | 2011-03-22 00:00:00
 | 2011-03-23 00:00:00
 | 2011-03-24 00:00:00
 | 2011-03-25 00:00:00
 | 2011-03-28 00:00:00
 | 2011-03-29 00:00:00
 | 2011-03-30 00:00:00
 | 2011-03-31 00:00:00
Spreadsheet: 107726d1304876947-round-function-help-intexcel
Sheet: Salespeople

State | 2006 | 2007 | 2009 | Av Emp | Total Sales | Sales/Emp
CT | 2 | 2 | 2 | 2 | 511112 | 8.388537839823659
MA | 8 | 6 | 5 | 6.333333333333333 | 2633207 | 0.8494128768857016
ME | 4 | 3 | 4 | 3.666666666666667 | 1607155 | 0.8928750198750376
NH | 6 | 5 | 5 | 5.333333333333333 | 1962694 | 0.8844389055684586
NJ | 3 | 3 | 3 | 3 | 2269629 | 1.098492721570484
NY | 9 | 8 | 6 | 7.666666666666667 | 4762647 | 1.042754332757305
PA | 4 | 5 | 4 | 4.333333333333333 | 4565845 | 1.004578725631205
RI | 2 | 3 | 2 | 2.333333333333333 | 1981928 | 0.9260943762220745
VT | 5 | 6 | 5 | 5.333333333333333 | 1694719 | 0.9111446666275729
Spreadsheet: 706151d1606496121-supplier-based-on-price-and-quantity-count
Sheet: Sheet2

Supplier | Sup1 | Sup2 | Sup3 | Sup4 | Sup5
Price | 172.5 | 50 | 172.5 | 50 | 172.5
Quantity | 90 | 50 | 40 | 70 | 20
lowest price
lowest price
Spreadsheet: 691976d1597990026-how-to-auto-extract-data-by-person-name-and-auto-generate-save-in-individual-file-2020-09-19-oeldere2-feidifeidi-691653d1597817853-how-to-auto-extract-data-by-person-name-and-
Sheet: Pivot table

Som [NAME] | Kolomlabels
Rijlabels | [NAME] | [NAME] | [NAME] | [NAME] | Eindtotaal
123 | 110 |  |  |  | 110
ABC | 100 |  |  | 600 | 700
ABS |  |  | 120 |  | 120
JKC |  |  | 200 |  | 200
KKP |  | 700 |  |  | 700
Eindtotaal | 210 | 700 | 320 | 600 | 1830
Spreadsheet: 109934d1306750542-monitor-worksheet-and-record-data-to-external-sheet-777712-macro-test-file
Sheet: Register

5001 | Trolley Wheels Fitting | Section 1
5002 | [NAME] | Section 1
5003 | Drill Holes In Chassis | Section 1
5004 | Chassis Earthing Points | Section 1
5005 | Auxiliary Motor & Pump Prep | Section 1
5006 | Auxiliary Motor & Pump Fitting | Section 1
5007 | Pressure Filter | Section 1
5008 | Compressor & Motor Assembly Mounting Brackets | Section 1
5009 | Battery Mounting Pads | Section 1
5010 | Hopper Dump Valve Bulkhead Adaptor | Section 1
5011 | Sequence Valve Prep | Section 1
5012 | Sequence Valve Fitting | Section 1
5013 | Hopper Dump Valve Prep | Section 1
5014 | Hopper Dump Valve Fitting | Section 1
5015 | [NAME] | Section 1
5016 | Water Pump Assembly | Section 1
5017 | Water Pump Fitting | Section 1
5018 | Water Manifold Assembly | Section 1
5019 | Water Manifold Fitting | Section 1
5020 | Water Strainer Assembly | Section 1
5021 | Water Strainer Fitting | Section 1
5022 | Hopper Cylinders Fitting | Section 1
5023 | Side Panel Pivots Prep | Section 1
5024 | Side Panel Pivots Fitting | Section 1
5025 | Side Panel Latch Mounting Brackets | Section 1
5026 | Chassis Gas [NAME] Joints | Section 1
5027 | [NAME] | Section 1
5028 | Chassis Conical Stops | Section 1
5029 | Battery Locating Pins | Section 1
5030 | [NAME] | Section 1
5031 | Front Axle Fitting | Section 1
5032 | Rear Axle Fitting | Section 1
5033 | Handbrake Cables Fitting | Section 1
5034 | Battery Pack Plungers | Section 1
5035 | Hydraulic Tank Assembly | Section 1
5036 | Hydraulic Tank Fitting | Section 1
5037 | Chassis Brake Pipes | Section 1
5038 | Water Hoses | Section 1
5039 | Screenwash Hose & Chassis Camera Cable | Section 1
Spreadsheet: 117df557-de35-4beb-a9bb-ee3cafe57b6e
Sheet: Tabla 24

[NAME]
Tabla 24. Resumen de presupuesto para programa integrado de EID por área geográfica
Resumen de costos para implementación del plan de acción integrado contra las EID en ___________________________________________
Costos por objetivo especifico |  | Año 1 |  | [NAME] |  | Año 3 |  | [NAME] |  | Año 5 |  | Total para [NAME] años
 |  | Costo | [NAME] financiamiento | Costo | [NAME] financiamiento | Costo | [NAME] financiamiento | Costo | [NAME] financiamiento | Costo | [NAME] financiamiento | Costo | [NAME] financiamiento
Objetivo específico 1
Objetivo específico 2
Objetivo específico 3
Objetivo específico 4
Objetivo específico 5
Objetivo específico 6
TOTAL
Resumen de las necesidades de medicamentos y brechas (expresadas en número de tabletas) [NAME] en ________________
Medicamento |  | Año 1 |  | [NAME] |  | Año 3 |  | [NAME] |  | Año 5 |  | Total para [NAME] años
 |  | Necesidad | Brecha | Necesidad | Brecha | Necesidad | Brecha | Necesidad | Brecha | Necesidad | Brecha | Necesidad | Brecha
Geohelmintiasis | Albendazol
 | Mebendazol
Filariasis linfática | Albendazol
 | DEC
Tracoma | Azitromicina
 | Tetraciclina
Spreadsheet: 779645d1651933335-calculating-range-and-remainder-calculatingfolderandposition
Sheet: Sheet1

Folder | Folder size | Cumulative | Cumulatiive | [NAME], as first step |  |  | Number entered | Result wanted Folder,Position | Explanation
1 | 4 | 4 | 1 |  |  |  | 1 | 1,1 | Calculate by testing Number against the ranges
2 | 14 |  | 5 |  |  |  | 5 | 2,1 | Calculate by testing Number against the ranges
3 | 328 |  | 19 |  |  |  | 8 | 2,4 | Calculate by testing Number against the ranges
4 |  |  | 347 |  |  |  | 20 | 3,2 | Calculate by testing Number against the ranges
5 |  |  | 347 |  |  |  | 100 | 3,82 | Calculate by testing Number against the ranges
6 |  |  | 347 |  |  |  | 300 | 3282 | Calculate by testing Number against the ranges
7 |  |  | 347 |  |  |  | 350 | 1,1 | Outside all ranges so default tol '1,1'
8 |  |  | 347
9 |  |  | 347
10 |  |  | 347
Enter number in C13 |  | 2
Note: Only using 3 of the 10 intended folders for this example
Spreadsheet: a584408f-a434-4dd9-a74e-62b3a96baabd
Sheet: Sheet1

Pollination Report for (Year) ___________  by (Name)____________________________________________________ | 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
at Location[s] ______________________________________________________________________________________
___________________________________________________________________________________________________
Tree | Tree Number | Bag | Poll. | Male (Pollen) | Dried or | Pollinated |  |  |  | Unpoll.  Checks |  |  |  | Harvest
Name | or Code | Date | Date | Parent | fresh? | [NAME] | ([NAME]) | Burs | Nuts | [NAME] | ([NAME]) | Burs | Nuts | Date | Comments
Locations/Notes::::
LEGEND | Tree Name |  | Received from Mother Tree Coordinator |  |  |  |  |  | Please be sure to read the instructions on the next tab in this worksheet.
 | Tree No/Code |  | Received from Mother Tree Coordinator
 | Bag Date |  | Date of Bagging
 | Poll. Date |  | Date of Pollination
 | Male (Pollen) Parent |  | Code of Pollen Parent - should be on vial, or received from Mother Tree Coordinator
 | Dried or fresh? |  | Is the pollen dried (in vial) or a fresh catkin?
Pollinated | [NAME] () |  | Number of pollinated bags placed  (How many recovered during harvest)
 | Burs |  | After harvest, how many burs were recovered
 | Nuts |  | After harvest, how many nuts were recovered
Unpollinated  Checks | [NAME] () |  | [NAME] placed  (How many recovered during harvest)
 | Burs |  | After harvest, how many burs were recovered
 | Nuts |  | After harvest, how many nuts were recovered
 | Harvest Date |  | Date of Harvest
 | Comments |  | Anything extra??
Spreadsheet: 684024d1593101824-count-distinct-values-with-multiple-criteria-forumulatest
Sheet: Sheet1

name | date
[NAME] | 2020-05-02 00:00:00 |  | Month Range |  | jane | [NAME] | tiffany
tiffany | 2020-05-02 00:00:00 |  | 2020-05-01 00:00:00 | 2020-05-31 00:00:00 | 3 | 3 | 2
[NAME] | 2020-05-02 00:00:00 |  | 2020-06-01 00:00:00 | 2020-06-30 00:00:00 | 2 | 4 | 1
tiffany | 2020-05-02 00:00:00
jane | 2020-05-03 00:00:00
[NAME] | 2020-05-03 00:00:00
[NAME] | 2020-05-04 00:00:00
jane | 2020-05-04 00:00:00
[NAME] | 2020-05-04 00:00:00
tiffany | 2020-05-04 00:00:00
[NAME] | 2020-05-04 00:00:00
jane | 2020-05-09 00:00:00
[NAME] | 2020-06-05 00:00:00
jane | 2020-06-05 00:00:00
[NAME] | 2020-06-05 00:00:00
jane | 2020-06-05 00:00:00
tiffany | 2020-06-06 00:00:00
[NAME] | 2020-06-07 00:00:00
[NAME] | 2020-06-08 00:00:00
[NAME] | 2020-06-08 00:00:00
jane | 2020-06-08 00:00:00
[NAME] | 2020-06-09 00:00:00
Spreadsheet: 134857d1325681071-need-help-with-excel-2010-exclearn
Sheet: Sheet1

 |  | R | Date | Home | Score | Away | 1 | X | 2 | res |  | best line
 |  | 5 | 2009-08-29 00:00:00 | Barnsley | 1   -   3 | Reading | 31.2 | 33.3 | 35.5 | 0 - 1 |  |  | M4 to check H4, [NAME], [NAME] and return the highest value i.e. in this line J4 is the highest thus a return of 2
 |  | 5 | 2009-08-29 00:00:00 | Blackpool | 3   -   0 | Coventry City | 39.7 | 31.7 | 28.6 | 0 - 1 |  |  | M5 to check H5, I5, J5 39.7 is the highest value thus a return of 1
 |  | 5 | 2009-08-29 00:00:00 | Bristol City | 2   -   1 | Middlesbrough | 34 | 32 | 34 | 2 - 2 |  |  | M6 to check H6, I6, J6 columns 1 and 2 have both the highest value thus a return of 12 is needed.
 |  | 5 | 2009-08-29 00:00:00 | Doncaster | 2   -   0 | Cardiff City | 27.1 | 28.5 | 44.5 | 0 - 2
 |  | 5 | 2009-08-29 00:00:00 | Ipswich Town | 1   -   1 | Preston | 26.6 | 27.9 | 45.5 | 0 - 2
 |  | 5 | 2009-08-29 00:00:00 | Nottm Forest | 3   -   2 | Derby County | 29.5 | 31.3 | 39.3 | 0 - 1
 |  | 5 | 2009-08-29 00:00:00 | Plymouth Argyle | 1   -   3 | Sheffield Wed | 30 | 31.8 | 38.2 | 0 - 1
 |  | 5 | 2009-08-29 00:00:00 | Scunthorpe Utd | 0   -   1 | [NAME] | 31.4 | 39.6 | 29 | 0 - 0
 |  | 5 | 2009-08-29 00:00:00 | Sheffield Utd | 2   -   2 | West Bromwich | 31.4 | 33.6 | 35 | 1 - 2
 |  | 5 | 2009-08-29 00:00:00 | Swansea city | 1   -   1 | Watford | 31.2 | 33.3 | 35.5 | 0 - 2
 |  | 5 | 2009-08-31 00:00:00 | Newcastle Utd | 1   -   0 | Leicester City | 36 | 37.9 | 22.9 | 0 - 0
 |  | 5 | 2009-08-31 00:00:00 | Peterborough | 1   -   1 | Crystal Palace | 30.2 | 32.1 | 37.7 | 1 - 2
 | my needs are:
 |  |  | hi, I need to check colums H, I and J and return 1 if H is the higest, return X if I is the highest, return 2 if J is the highest or if two values are the same return 1X or 12 or X2.
Spreadsheet: b393b41f-ae6b-405b-a806-a513dd4534f3
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
3381 | 18704 | [NAME] | Myllymaki | CAN | 0 |  |  |  |  |  | 1 | 1:52:30
3381 | 18703 | Kurt | Blattma | SUI | 0 |  |  |  |  |  | 2 | 1:52:39
3381 | 10171 | [NAME] | Bright | NZL | 0 |  |  |  |  |  | 3 | 1:52:55
3381 | 5328 | Stephane | Poulat | FRA | 0 |  |  |  |  |  | 4
3381 | 15201 | [NAME] | Harper | AUS | 0 |  |  |  |  |  | 5
3381 | 5691 | Ralf | [NAME] | GER | 0 |  |  |  |  |  | 6
3381 | 28496 | [NAME] | Heldoorn | NED | 0 |  |  |  |  |  | 7
3381 | 14920 | [NAME] | Macmartin | CAN | 0 |  |  |  |  |  | 8
3381 | 5607 | [NAME] | Bignet | FRA | 0 |  |  |  |  |  | 9
3381 | 15288 | Mathew | Belfield | GBR | 0 |  |  |  |  |  | 10
Spreadsheet: stacey_white__38846__westcorrelations
Sheet: Sheet1

 | West Desk |  |  |  |  | Houston VAR Group
A. | SP15 | TO | NOB S/N |  |  | SP15 | TO | NOB S/N
 | R11 |  | B22 |  |  | R11 |  | B22
 | correlation: | 0.9 |  |  |  | correlation: | 0.92
B. | PV | TO | WEST WING (FOUR CORNERS) |  |  | PV | TO | WEST WING (FOUR CORNERS)
 | R7 |  | B6 |  |  | R7 |  | B6
 | correlation: | 0.9 |  |  |  | correlation: | 1
 | WILL MOVE TO 100%
C. | [NAME] | TO | COB |  |  | [NAME] | TO | COB
 | B27 |  | R8 |  |  | B27 |  | R8
 | correlation: | 0.95 |  |  |  | correlation: | 1
D. | PV | TO | MEAD |  |  | PV | TO | MEAD
 | R7 |  | B4 |  |  | R7 |  | B4
 | correlation: | 0.9 |  |  |  | correlation: | 1
 | WILL MOVE TO 100%
E. | MID C DELIVERED(BIG EDDY) | TO | NOB N/S |  |  | MID C DELIVERED(BIG EDDY) | TO | NOB N/S
 | B8 |  | B22 |  |  | B8 |  | B22
 | correlation: | 0.95 |  |  |  | correlation: | 1
Spreadsheet: 3b39c74e-fd69-471a-b775-bf2365d7d2a4
Sheet: IOD Expenses

Expense Comparison
Total
 |  |  |  |  |  | Period One |  |  |  |  | Period Two |  |  |  |  | Period Three
Category | Total | PRD | POU | % of EGI |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 10
 |  | UW | UW | UW |  |  |  | Cost per Month | Period Cost |  |  |  | Cost per Month | Period Cost |  |  |  | Cost per Month | Period Cost
 |  |  |  |  |  | 1 | of total exp |  |  |  | 1 | of total exp |  |  |  | 1 | of total exp
 |  |  |  |  |  | 0.05 | of EGI |  |  |  | 0.052 | of EGI |  |  |  | 0.052 | of EGI
 |  |  |  |  |  | 1 | of total exp |  |  |  | 1 | of total exp |  |  |  | 1 | of total exp
 |  |  |  |  | min of 33% fixed |  | prd |  |  |  |  | prd |  |  |  |  | prd
 |  |  |  |  |  | 0.1 | of total exp |  |  |  | 0.2 | of total exp |  |  |  | 0.5 | of total exp
 |  |  |  |  | min of 33% fixed |  | prd |  |  |  |  | prd |  |  |  |  | prd
 |  |  |  |  | min of 33% fixed |  | prd |  |  |  |  | prd |  |  |  |  | prd
 |  |  |  |  |  |  | poupy |  |  |  |  | pou |  |  |  |  | pou
 |  |  |  |  |  | 0 | of total exp |  |  |  | 0 | of total exp |  |  |  | 1 | of total exp
 |  |  |  |  |  | 0 | of total exp |  |  |  | 0 | of total exp |  |  |  | 1 | of total exp
 |  |  |  |  |  | 0 | of total exp |  |  |  | 0 | of total exp |  |  |  | 1 | of total exp
TOTAL
Key Data (per resident day)
Effective Gross Income
Net Operating Income
Expense Ratio
Occupancy |  |  |  |  |  |  |  |  | 0.2196969696969697 |  |  |  |  | 0.3106060606060606 |  |  |  |  | 0.672077922077922
Total Beds
Private
Medicare
Medicaid
Other
Occupied Units
Resident Days
Spreadsheet: 156131d1337185612-creating-a-staff-rota-new-rota
Sheet: rota

Sunday
05:00:00 | 06:00:00 | 07:00:00 | 08:00:00 | 09:00:00 | 10:00:00 | 11:00:00 | 12:00:00 | 13:00:00 | 14:00:00 | 15:00:00 | 16:00:00 | 17:00:00 | 18:00:00 | 19:00:00 | 20:00:00 | 21:00:00 | 22:00:00 | 23:00:00
Monday
6-7 | 7-8 | 8-9 | 9-10 | 10-11 | 11-12 | 12-1 | 1-2 | 2-3 | 3-4 | 4-5 | 5-6 | 6-7 | 7-8 | 8-9 | 9-10
Tuesday
6-7 | 7-8 | 8-9 | 9-10 | 10-11 | 11-12 | 12-1 | 1-2 | 2-3 | 3-4 | 4-5 | 5-6 | 6-7 | 7-8 | 8-9 | 9-10
Wednesday
6-7 | 7-8 | 8-9 | 9-10 | 10-11 | 11-12 | 12-1 | 1-2 | 2-3 | 3-4 | 4-5 | 5-6 | 6-7 | 7-8 | 8-9 | 9-10
Thursday
6-7 | 7-8 | 8-9 | 9-10 | 10-11 | 11-12 | 12-1 | 1-2 | 2-3 | 3-4 | 4-5 | 5-6 | 6-7 | 7-8 | 8-9 | 9-10
Friday
6-7 | 7-8 | 8-9 | 9-10 | 10-11 | 11-12 | 12-1 | 1-2 | 2-3 | 3-4 | 4-5 | 5-6 | 6-7 | 7-8 | 8-9 | 9-10
Saturday
6-7 | 7-8 | 8-9 | 9-10 | 10-11 | 11-12 | 12-1 | 1-2 | 2-3 | 3-4 | 4-5 | 5-6 | 6-7 | 7-8 | 8-9 | 9-10
Spreadsheet: 716360d1612186761-dynamic-indirect-substitutes-all-default-to-errors-dynamic-indirect-dependents-eba
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | CATEGORY | Coluna1 | Product | Coluna2 | Brand | Coluna3 | Type / Range | Coluna4 | Colour / Code
 |  |  |  |  |  |  |  |  |  |  | Interior Paint |  | Interior Paint |  | Interior Walls |  | Brand A Interior Walls |  | Brand A Satinwood
 |  |  |  |  |  |  |  |  |  |  | Exterior Paint |  | Interior Walls |  | Brand A Interior Walls |  | Brand A Satinwood |  | Colour 1 - Code Whatever
 |  |  |  |  |  |  |  |  |  |  | Carpet |  | Internal Woodwork |  | Brand B Interior Walls |  | Brand A Gloss |  | [NAME] Whatever
 |  |  |  |  |  |  |  |  |  |  |  |  | TBC by Client |  | Brand C Interior Walls |  | Brand A Silk |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TBC by Client |  | TBC by Client |  | TBC by Client
 |  | All Dependents evaluate to Errors
 | Category | Product | Brand | Type / Range | Colour / Code
 | Interior Paint | Interior Walls | Brand A Interior Walls |  | Brand A Satinwood
 |  | S/be three choices from Col N assume select Interior Walls
 |  |  | S/be four choices from Col P - Assume choose Brand A
 |  |  |  | S/be four choices from Col R - Assume choose Satinwood
 |  |  |  |  | S/be four choices from Col T - Assume choose Colour 1
Spreadsheet: 98522d1297376991-excel-2007-multiple-variable-length-lists-to-1-list-scratch
Sheet: Sheet1

LISTS GENERATED BY INPUT - LENGTH (NUMBER OF ROWS VARIES BASED ON INPUT) |  |  |  |  |  |  |  |  |  |  |  |  | COMBINED LIST I'D LIKE TO BE AUTOMATICALLY CREATED (NO BLANKS)
LIST 1 |  |  | LIST 2 |  |  | LIST 3 |  |  | LIST 4 |  |  |  | Row Breaks | Column
X | Y | Z | X | Y | Z | X | Y | Z | X | Y | Z |  | 1
L1 R1 | L1 R1 | zz | [NAME] | [NAME] | [NAME] | L3 R1 | L3 R1 | L3 R1 | [NAME] | [NAME] | [NAME]
[NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
L1 R3 | L1 R3 | L1 R3 | L2 R3 | L2 R3 | L2 R3 | L3 R3 | L3 R3 | L3 R3 | [NAME] | [NAME] | [NAME]
L1 R4 | L1 R4 | L1 R4 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 |  |  | [NAME] | [NAME] | [NAME] | L3 R5 | L3 R5 | L3 R5 | [NAME] | [NAME] | [NAME]
 |  |  | [NAME] | [NAME] | [NAME] | L3 R6 | L3 R6 | L3 R6 | [NAME] | [NAME] | [NAME] |  | X | Y | Z
 |  |  | L2 R7 | L2 R7 | L2 R7 | L3 R7 | L3 R7 | L3 R7 | [NAME] | [NAME] | [NAME]
 |  |  | [NAME] | [NAME] | [NAME] |  |  |  | [NAME] | [NAME] | [NAME]
 |  |  | L2 R9 | L2 R9 | L2 R9 |  |  |  | [NAME] | [NAME] | [NAME]
 |  |  | L2 R10 | L2 R10 | L2 R10
 |  |  | L2 R11 | L2 R11 | L2 R11
 |  |  | L2 R12 | L2 R12 | L2 R12
 |  |  | L2 R13 | L2 R13 | L2 R13
Spreadsheet: 132713d1323888666-if-statement-and-vlookup-help-bandsaw-blade-summary-analysis-report-2012-blank-modified-by-tigeravatar-
Sheet: BANDSAW BLADE SUM ANALYSIS  

Title: |  | Bandsaw Blade Summary Analysis Report |  |  |  | Document ID: | D4.439 |  |  | Page: | 1 of 1
Author: |  |  |  |  |  | Approved By: |  |  |  | Approval Date: | 2004-11-01 00:00:00
Rev # : |  | Original |  |  |  | Rev. [NAME]: | November 1, 2004 |  |  | Effective Date: | 2004-11-01 00:00:00
BANDSAW BLADE SUMMARY ANALYSIS REPORT
DATE | SERIAL # |  | BLADE TYPE | MACH # | I.D.      (A - H) | BLADE SIZE |  |  | TOTAL # OF CUTS | TOTAL SQUARE INCHES | SQUARE INCHES PER CUT (Average)
 |  |  |  |  | I.D.         (I - M)