tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 149059d1333666161-finding-second-to-minimum-number-in-array-tissue-culture-sal-1
Sheet: Sheet1

 |  | Competitor Price |  |  |  |  |  |  |  |  | Denville
PRODUCT | DENVILLE'S CAT. NUMBER: | Corning |  |  | BD |  |  | ? |  |  |  |  |  | Savings/ Month | Savings/ Year
CELL CULTURE DISHES |  | Price | Dishes/cs | $/tube | Price | Dishes/cs | $/tube | Price | Dishes/cs | $/tube | Price | Dishes/cs | $/tube
35[NAME] cell culture dish, thickness 12mm; Qty./bag: 20; Qty./case: 500 | T1103 | 90.79 | 500 |  | 106 | 500 |  |  |  |  | 74.99 | 500
60[NAME] cell culture dish, thickness 15mm; Qty./bag: 20; Qty./case: 500 | T1106 | 84.06 | 500 |  | 89 | 500 |  |  |  |  | 74.99 | 500
100[NAME] cell culture dish, thickness 20mm; Qty./bag: 20; Qty./case: 300 | T1110 | 159.25 | 500 |  | 79.6 | 200 |  |  |  |  | 69.99 | 300
150[NAME] cell culture dish, thickness 25mm; Qty./bag: 5; Qty./case: 100 | T1115 | 89.66 | 60 |  | 95.2 | 100 |  |  |  |  | 69.99 | 100
CELL CULTURE PLATES |  | Price | Plates/cs | $/plate | Price | Plates/cs | $/plate | Price | Plates/cs | $/plate | Price | Plates/cs | $/plate
6 well cell culture plate; Qty./bag: 1; Qty./case: 50 | T1006 | 100.8 | 100 |  | 47.5 | 50 |  |  |  |  | 46.99 | 50
12 well cell culture plate; Qty./bag: 1; Qty./case: 50 | T1012 | 131.9 | 100 |  | 57 | 50 |  |  |  |  | 53.99 | 50
24 well cell culture plate; Qty./bag: 1; Qty./case: 50 | T1024 | 173.51 | 100 |  | 55 | 50 |  |  |  |  | 49.99 | 50
96 well cell culture plate; Qty./bag: 1; Qty./case: 100 | T1096 | 101.34 | 100 |  | 59.5 | 50 |  |  |  |  | 89.99 | 100
CELL CULTURE FLASKS |  | Price | Flasks/cs | $/plate | Price | Flasks/cs | $/plate | Price | Flasks/cs | $/plate | Price | Flasks/cs | $/plate
50ml cell culture flask, Vented cap; Growth area: 25cm2; Qty./bag: 10; Qty./case: 200 | T1205 | 121.54 | 200 |  | 79.6 | 200 |  |  |  |  | 89.99 | 200
[NAME] cell culture flask, Vented cap; Growth area: 75cm2; Qty./bag: 5; Qty./case: 100 | T1225 | 102.58 | 100 |  | 86.4 | 100 |  |  |  |  | 89.99 | 100
750ml cell culture flask, Vented cap; Growth area: 175cm2; Qty./bag: 5; Qty./case: 40 | T1275 | 87.43 | 50 |  | 68 | 40 |  |  |  |  | 79.99 | 40
50ml cell culture flask, Plug seal cap; Growth area: 25cm2; Qty./bag: 10; Qty./case: 200 | T1206 | 206.5 | 500 |  | 76.8 | 200 |  |  |  |  | 81.99 | 200
[NAME] cell culture flask, Plug seal cap; Growth area: 75cm2; Qty./bag: 5; Qty./case: 100 | T1226 | 82.12 | 100 |  | 83.6 | 100 |  |  |  |  | 81.99 | 100
750ml cell culture flask, Plug seal cap; Growth area: 175cm2; Qty./bag: 5; Qty./case: 40 | T1276 | 80.07 | 50 |  | 62.64 | 40 |  |  |  |  | 69.99 | 40
Spreadsheet: 179581d1347304157-match-positive-and-negative-values-with-the-same-assignment-reference-example3
Sheet: Blad1

Assignment | Amount
1 | -5000
1 | 5000
1 | 50
4 | 2375
4 | 2300
5 | -8000
5 | -75
5 | 75
9 | 1000
10 | 4000
Spreadsheet: 679553d1590492676-number-items-in-a-list-that-are-not-chosen-example-list
Sheet: Names

Rank | Name | Order # |  | Rank | Name | Order # |  | Rank | Name | Order # |  | Rank | Name | Order # |  | Rank | Name | Order #
1 | Adam | 1 |  | 6 | [NAME] |  |  | 11 | [NAME] |  |  | 16 | [NAME] |  |  | 21 | Umberto
2 | [NAME] | 2 |  | 7 | George |  |  | 12 | [NAME] |  |  | 17 | Quinn |  |  | 22 | Victor
3 | [NAME] | 3 |  | 8 | [NAME] |  |  | 13 | Mark |  |  | 18 | Rodger |  |  | 23 | Walter
4 | [NAME] | 4 |  | 9 | [NAME] |  |  | 14 | Nathan |  |  | 19 | [NAME] |  |  | 24 | Xander
5 | [NAME] | 5 |  | 10 | [NAME] |  |  | 15 | Ozzie |  |  | 20 | [NAME]
Spreadsheet: 201357d1355955047-how-to-reference-cell-with-date-in-formula-llj-bills-example-sheet-1-
Sheet: Netflix

NETFLIX
Due Date | Amount | Date Paid | Amount Paid | Balance
2009-12-28 00:00:00 | 15.21 | 2009-12-28 00:00:00 | 15.21
2010-01-25 00:00:00 | 15.21 | 2010-01-25 00:00:00 | 15.21
2010-02-25 00:00:00 | 15.21 | 2010-02-25 00:00:00 | 15.21
2010-03-25 00:00:00 | 15.21 | 2010-03-25 00:00:00 | 15.21
2010-04-25 00:00:00 | 15.21 | 2010-04-26 00:00:00 | 15.21
2010-05-25 00:00:00 | 15.21 | 2010-05-25 00:00:00 | 15.21
2010-06-25 00:00:00 | 15.21 | 2010-06-24 00:00:00 | 15.21
2010-07-24 00:00:00 | 15.21 | 2010-07-26 00:00:00 | 15.21
2010-08-24 00:00:00 | 15.21 | 2010-08-24 00:00:00 | 15.21
2010-09-24 00:00:00 | 15.21 | 2010-09-27 00:00:00 | 15.21
2010-10-24 00:00:00 | 15.21 | 2010-10-25 00:00:00 | 15.21
 | 15.21 | 2010-11-24 00:00:00 | 15.21
 | 7.99 | 2010-12-24 00:00:00 | 7.99
 | 7.99 | 2011-01-25 00:00:00 | 7.99
 | 7.99 | 2011-02-25 00:00:00 | 7.99
 | 7.99 | 2011-03-24 00:00:00 | 7.99
 | 7.99 | 2011-04-24 00:00:00 | 7.99
 | 7.99 | 2011-05-27 00:00:00 | 7.99
 | 7.99 | 2011-06-24 00:00:00 | 7.99
 | 7.99
Spreadsheet: 773fb9fe-6cb4-4c1d-9948-44241082236c
Sheet: Sheet1

Excel Training Student Roster
Instructor | Student | Level | Score
[NAME] | [NAME], [NAME] | 1 | 90
Dawes | [NAME], [NAME] | 1 | 87
[NAME] | Ames, [NAME] | 1 | 68
Smith | Ames, [NAME] | 2 | 94
[NAME] | [NAME], [NAME] | 2 | 94
Smith | Sorrell, [NAME] | 1 | 100
Smith | [NAME], [NAME] | 1 | 98
Dawes | Jones, [NAME] | 1 | 85
Smith | [NAME], Will | 2 | 76
Smith | Ames, [NAME] | 3 | 89
Dawes | [NAME], [NAME] | 2 | 92
Smith | [NAME], [NAME] | 2 | 95
Dawes | Jones, [NAME] | 2 | 79
[NAME] | Ames, [NAME] | 1 | 88
[NAME] | Ames, [NAME] | 2 | 86
Dawes | Brown, [NAME] | 1 | 99
[NAME] | Yee, Donese | 3 | 100
Smith | [NAME], [NAME] | 2 | 95
Spreadsheet: 272354d1382365948-transfer-multiple-row-entries-to-single-row-sample
Sheet: Sheet1

Date | Rising | Morning | Afternoon | Evening | Date | Rising | Morning | Afternoon | Evening
2013-08-20 00:00:00 |  |  | 151 |  | 2013-08-20 00:00:00
2013-08-20 00:00:00 |  |  |  | 171 | 2013-08-21 00:00:00
2013-08-21 00:00:00 | 133 |  |  |  | 2013-08-22 00:00:00
2013-08-21 00:00:00 |  |  | 180 |  | 2013-08-23 00:00:00
2013-08-22 00:00:00 | 156 |  |  |  | 2013-08-24 00:00:00
2013-08-23 00:00:00 | 144 |  |  |  | 2013-08-25 00:00:00
2013-08-23 00:00:00 |  |  | 92 |  | 2013-08-26 00:00:00
2013-08-23 00:00:00 |  |  |  | 215 | 2013-08-27 00:00:00
2013-08-23 00:00:00 |  |  |  | 207 | 2013-08-28 00:00:00
2013-08-24 00:00:00 | 156 |  |  |  | 2013-08-29 00:00:00
2013-08-24 00:00:00 |  |  |  | 188 | 2013-08-30 00:00:00
2013-08-25 00:00:00 | 141 |  |  |  | 2013-08-31 00:00:00
2013-08-25 00:00:00 |  |  |  | 185 | 2013-09-01 00:00:00
2013-08-25 00:00:00 |  |  |  | 187 | 2013-09-02 00:00:00
2013-08-26 00:00:00 | 166 |  |  |  | 2013-09-03 00:00:00
2013-08-26 00:00:00 |  |  | 82 |  | 2013-09-04 00:00:00
2013-08-26 00:00:00 |  |  | 120 |  | 2013-09-05 00:00:00
2013-08-26 00:00:00 |  |  |  | 187 | 2013-09-06 00:00:00
Spreadsheet: 0152e851-70b9-4427-b60a-8620d3ca2bc3
Sheet: Maintenance Costs Summary

 | HR&A Advisors, Inc.
 | Inner Loop East Reconstruction Project
 | Maintenance and Repair Costs Summary
 | Year | Project Year | Project Maintenance Cost ($ 2013)
 | 2014 | 0 | 0
 | 2015 | 1 | 0
 | 2016 | 2 | 0
 | 2017 | 3 | 0
 | 2018 | 4
 | 2019 | 5 | 0
 | 2020 | 6 | 0
 | 2021 | 7
 | 2022 | 8 | 0
 | 2023 | 9 | 0
 | 2024 | 10
 | 2025 | 11 | 0
 | 2026 | 12 | 0
 | 2027 | 13
 | 2028 | 14 | 0
 | 2029 | 15 | 0
 | 2030 | 16
 | 2031 | 17 | 0
 | 2032 | 18 | 0
 | 2033 | 19
 | 2034 | 20 | 0
 | 2035 | 21 | 0
 | 2036 | 22
 | 2037 | 23 | 0
 | 2038 | 24 | 0
 | 2039 | 25
 | 2040 | 26 | 0
 | 2041 | 27 | 0
 | 2042 | 28
 | 2043 | 29 | 0
 | 2044 | 30 | 0
 | 2045 | 31
 | Total
 | Net Present Value 3% Discount Rate
 | Net Present Value 7% Discount Rate
Spreadsheet: 107424d1304599166-need-formula-for-a-macro-function-example
Sheet: 22

877
Name | Amount
Name 1 | 157
Name 3 | 175
Name 2 | 200
Name 2 | 195
Name 3 | 138
Name 2 | 117
Name 3 | 114
Name 2 | 192
Name 3 | 102
Name 2 | 178
Name 1 | 134
Name 2 | 158
Name 2 | 184
Name 2 | 113
Name 3 | 178
Name 1 | 102
Name 3 | 147
Name 3 | 183
Name 3 | 164
Name 1 | 184
Name 3 | 198
Name 3 | 106
Name 1 | 125
Name 1 | 175
Name 3 | 139
Spreadsheet: 833976d1687372010-formula-to-average-shipment-weight-by-piece-dims_list_by_weight
Sheet: ppususr.dimslistif(jfkug>Sheet1

 | Finals for |  | Total Pcs |  | Total Wgt. |  | Average Wgt per piece in Kg
 | shipment "x"
AWBNO | # of pieces | WGHT | L | W | H
[PHONE] | 1 | 20 | 12 | 12 | 20
[PHONE] | 2 | 30 | 15 | 20 | 18
[PHONE] | 1 | 10 | 12 | 10 | 10
[PHONE] | 4 | 200 | 48 | 40 | 25
[PHONE] | 3 | 500 | 20 | 20 | 20 |  |  | Should be 500/5pcs=100
[PHONE] | 1 | 0 | 20 | 10 | 15 |  |  | Which I would like to populate in H8&H9&H10
[PHONE] | 1 | 0 | 25 | 18 | 10
 | 1 | 350 | 48 | 40 | 40
 | 4 | 1000 | 20 | 20 | 20
 | 7 | 700 | 30 | 30 | 30
 | This List gets pulled from another program and varies with the number of shipments
 | and sometimes lists all the weight on
 | Is there a formula to automate when it sees 0 in the weight column to combine these all and then
 | divide by total number of pcs to get the correct average weight per piece?
LHR |  |  | 17.515
Spreadsheet: 778521d1651138005-formula-to-split-totals-depending-on-the-number-of-days-in-a-month-equal-split-per-month-aligw
Sheet: Sheet1

Date | Sales Target
2022-01-01 00:00:00 |  |  |  |  | January | 160
2022-01-02 00:00:00
2022-01-03 00:00:00
2022-01-04 00:00:00
2022-01-05 00:00:00
2022-01-06 00:00:00
2022-01-07 00:00:00
2022-01-08 00:00:00
2022-01-09 00:00:00
2022-01-10 00:00:00
2022-01-11 00:00:00
2022-01-12 00:00:00
2022-01-13 00:00:00
2022-01-14 00:00:00
2022-01-15 00:00:00
2022-01-16 00:00:00
2022-01-17 00:00:00
2022-01-18 00:00:00
2022-01-19 00:00:00
2022-01-20 00:00:00
Spreadsheet: 0180e0a0-80dd-48cc-8af5-e202472807ed
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: |  |  | 2011-12-20 09:33:54.140000
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.5 | 101.875 | 101.75 | 101.625 | 101.25 |  | and are added to price quote
4.375 | 101.735 | 101.61 | 101.485 | 101.11
4.25 | 101.32 | 101.195 | 101.07 | 100.695 |  | Note: | Refer To Price [NAME]
4.125 | 100.968 | 100.843 | 100.718 | 100.343 |  |  | For all Price Adjs
4 | 100.527 | 100.402 | 100.277 | 99.652
3.875 | 99.967 | 99.842 | 99.717 | 99.092
3.75 | 99.118 | 98.993 | 98.868 | 98.243
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.875 | 101.875 | 101.75 | 101.625 | 101.25
3.75 | 101.449 | 101.324 | 101.199 | 100.824
3.625 | 101.164 | 101.039 | 100.914 | 100.539
3.5 | 100.85 | 100.725 | 100.6 | 100.225
3.375 | 100.445 | 100.32 | 100.195 | 99.57
3.25 | 99.893 | 99.768 | 99.643 | 99.018
 |  |  |  |  |  | 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-01-03 09:33:54.140000
30 DAY | 2012-01-18 09:33:54.140000
45 DAY | 2012-02-02 09:33:54.140000
60 DAY | 2012-02-17 09:33:54.140000
90 DAY | 2012-03-18 09:33:54.140000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 97859d1296969345-autofill-from-a-matrix-when-2-constants-are-know-indexmatch
Sheet: Matrix

 | Likelihood
Consequence | Almost certain | Likely | Possible | Unlikely | Rare
Catastrophic | EXTREME | EXTREME | EXTREME | VERY HIGH | HIGH
Major | EXTREME | EXTREME | VERY HIGH | HIGH | MEDIUM
Moderate | VERY HIGH | HIGH | HIGH | MEDIUM | LOW
Minor | MEDIUM | MEDIUM | MEDIUM | LOW | LOW
Insignificant | MEDIUM | LOW | LOW | LOW | LOW
 | HIGH
Spreadsheet: 4f55808c-1487-44d0-899a-4950c6b43447
Sheet: Sheet1

Permit No.: | Unnamed: 1 | Unnamed: 2 | WQ0005150 | Unnamed: 4 | Unnamed: 5 | Facility Name: | Unnamed: 7 | North End Elementary | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | County: | Person | Unnamed: 16 | Month: | Unnamed: 18 | Unnamed: 19 | Year: | Unnamed: 21
Did irrigation occur    at this facility? |  |  |  |  |  | Field Name: |  | 1 |  | Field Name: |  | 2 |  | Field Name: |  |  |  | Field Name:
 |  |  |  |  |  | Area (acres): |  | 1.1 |  | Area (acres): |  | 1.76 |  | Area (acres): |  |  |  | Area (acres):
 |  |  |  |  |  | Cover Crop: |  | Green Ash |  | Cover Crop: |  | Green Ash |  | Cover Crop: |  |  |  | Cover Crop:
 |  |  |  |  |  | [NAME] (in): |  | 0.15 |  | [NAME] (in): |  | 0.3 |  | [NAME] (in): |  |  |  | [NAME] (in):
 |  |  |  |  |  | Annual Rate (in): |  | 26 |  | Annual Rate (in): |  | 18.2 |  | Annual Rate (in): |  |  |  | Annual Rate (in):
Day | Weather |  |  | Freeboard |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Storage | 5-Day Upset (if applicable) | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading
 |  | ºF | in | ft | ft | gal | min | in | in | gal | min | in | in | gal | min | in | in | gal | min | in | in
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Monthly Loading:
12 Month Floating Total (in):
Spreadsheet: 264247d1378828527-extracting-and-sorting-data-from-source-worksheet-excel-2003-top-5-autosort-revised
Sheet: Condition Codes

Facility Component Condition Codes
Code | Classification | Condition Code Description | Points
1 | CRITICAL | Failed; System Failure; Installed property, equipment or facility component can't be used for intended purpose; Mandatory compliance; Critical mission, quality of work life, environment, security, safety, health, or fire impact. | 10
2 | ESSENTIAL | Poor Condition; Failure Imminent; Installed property, equipment/component or facility in advanced stage of deterioration and requires frequent repairs; High potential for significant or serious adverse consequences to mission, quality of work life, security, environmental, moderate safety, health or fire impact. | 8
3 | IMPORTANT | Fair Condition; Failure impending; System functional, deterioration evident; will progress further if not fixed; Deficiency should be corrected to prevent undesirable mission, quality of work life, environmental, safety, health or fire impact. | 5
4 | ROUTINE | End of Life Cycle; Failure Probable; Little deterioration at present, but work still considered essential; Actions will reduce potential mission, quality of work life, environmental, safety, health or fire deficiencies or problems. | 2
5 | DEFERABLE | Good Condition; Cyclical; Failure Predictable; Correction of minor problems; Nice, but not essential; potential for mission, quality of work life, environmental, safety, health or fire improvements. | 1
Spreadsheet: 799646d1665170620-mark-special-date-and-time-period-in-excel-worksheet-2022-10-07-excel-forum
Sheet: Tabelle1

Today | Description | Assignee |  |  |  | Due to… | KW 40 |  |  |  | KW 41 |  |  |  |  |  |  | KW 42 |  |  |  |  |  |  | KW 43 |  |  |  |  |  |  | KW 44
 |  |  |  |  |  |  | October |  |  |  | October |  |  |  |  |  |  | October |  |  |  |  |  |  | October
 |  |  |  |  | Task received on… |  | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon
 |  |  |  |  |  |  | 2022-10-06 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Deadline "German Company"
 |  |  |  |  |  |  | Meeting |  |  |  | Meeting
sample task 2… | … |  |  |  | … | …
sample task 1… | … |  |  |  | … | …
 |  |  |  |  | … | …
 |  |  |  |  | 2022-10-06 00:00:00 | 2022-10-10 00:00:00
 |  |  |  |  | 2022-10-06 00:00:00 | 2022-10-10 00:00:00
 |  |  |  |  | 2022-10-06 00:00:00 | 2022-10-10 00:00:00
Spreadsheet: 71604d1272372511-average-if-problem-excel-2003-example-for-forum
Sheet: Overview

<80% Attendence | Total | Average Attendence | Total Negatives | Average Negative Per Student | Total Positive | Positive Average Per Student | Total Lates | Lates Average Per Student | Exclusions | Total Holiday Sessions | Average Hol Ses Per Student
All students
Boys
Girls
Ethnicity ex. WBRI
WBRI
FSM
In Care
Joiners
G&T
Vulnerable
SEN
No Target Group (excluding [NAME] and ETH)
Spreadsheet: 474660d1470846413-creating-relationships-between-tables-excel-2003-example1
Sheet: Sheet1

Morning [NAME]
Date | Total # Pieces | Mis-Picks (# pcs) | Missing (# pcs) | [NAME] (#[NAME]) | Damaged (#pcs) | [NAME] (#[NAME]) | Total Discrepancies (# pcs) | % Accuracy
2016-08-01 00:00:00 | 514 | 0 | 1 | 0 | 0 | 1 | 2 | 0.9961089494163424
2016-08-02 00:00:00 | 930 | 0 | 1 | 0 | 0 | 0 | 1 | 0.9989247311827957
2016-08-03 00:00:00 | 402 | 0 | 0 | 3 | 1 | 0 | 4 | 0.9900497512437811
2016-08-04 00:00:00 | 1129 | 0 | 0 | 0 | 2 | 0 | 2 | 0.9982285208148804
2016-08-05 00:00:00 | 587 | 0 | 0 | 0 | 1 | 0 | 1 | 0.9982964224872232
2016-08-06 00:00:00 | 540 | 1 | 0 | 0 | 2 | 0 | 3 | 0.9944444444444445
2016-08-07 00:00:00 | 653 | 0 | 0 | 0 | 2 | 1 | 3 | 0.9954058192955589
2016-08-08 00:00:00 | 863 | 1 | 0 | 0 | 2 | 0 | 3 | 0.996523754345307
2016-08-09 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2016-08-10 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2016-08-11 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2016-08-12 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2016-08-13 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2016-08-14 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2016-08-15 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2016-08-16 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2016-08-17 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2016-08-18 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2016-08-19 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2016-08-20 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2016-08-21 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2016-08-22 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2016-08-23 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2016-08-24 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2016-08-25 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2016-08-26 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2016-08-27 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2016-08-28 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2016-08-29 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2016-08-30 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2016-08-31 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0
August Total | 5618 | 2 | 2 | 3 | 10 | 2 | 19 | 0.9959977991537916
Spreadsheet: 763433d1642172240-extract-numbers-in-a-cell-in-the-middle-excels-forum-sample
Sheet: Sheet1

Raw Data |  |  |  | [NAME]
 | ACW% |  |  | AWC%
 | 0-13-15 |  |  | 0.13
 | 0-27-11 |  |  | 0.27
 | 0-0-0 |  |  | 0.27
 | 0-0-0 |  |  | 0
 | 0-29-7 |  |  | 0.29
 | 0-0-0 |  |  | 0
 | 0-0-0 |  |  | 0
 | 0-0-0 |  |  | 0
Spreadsheet: benjamin_rogers__1224__test model from Erin
Sheet: CSHFLO-ENA

Cash Flow
Project Revenues:
Project Operating Expenses:
Fuel Charges
O&M Expenses
Working Capital Changes
Return of Maintenance Reserve
Operating Cash Flow
Debt Service:
Interest Payments
Principal Payments
LC Charge on DSRF
Interest Income
Total Debt Service
Federal Income Taxes
NET A-T CASH FLOW
Debt Service Coverage Ratios
Debt Life
Long Term Debt
Interest
Principal
Long Term Debt Service
TOTAL DEBT SERVICE
DSC Ratios:
Long Term DSCR
Average
Minimum
Average Life
Total Debt Coverage Ratio
 |  | 0.5 | 1.5 | 2.5 | 3.5 | 4.5 | 5.5 | 6.5 | 7.5 | 8.5 | 9.5 | 10.5 | 11.5 | 12.5 | 13.5 | 14.5 | 15.5 | 16.5 | 17.5 | 18.5 | 19.5
Spreadsheet: 44353f5d-87dc-4be8-99f7-ba54a11758df
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 35. LEASE FINANCE COMMITMENTS, By Purpose: State (WA), Original (Number, $000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
1 . . . [NAME] ; |  |  | Original | A2413911L | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | A2413912R | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413913T | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413914V | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | A2413915W | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles  ; |  |  | Original | A2413916X | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
1.3.1a . . . . . . - new trucks ; |  |  | Original | A2413917A | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
. . . . . . . . . . . . [new trucks (no.)] ; |  |  | Original | A2413918C | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | Number | FLOW | Month | 1
1.3.3 a. . . . . . - used trucks ; |  |  | Original | A2413919F | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
. . . . . . . . . . . . [used trucks (no.)] ; |  |  | Original | A2413920R | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | Number | FLOW | Month | 1
1.3.5 . . . . . . . - trailers, buses, coaches, other MVs ; |  |  | Original | A2413921T | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
2 . . . Other Transport Equipment ; |  |  | Original | A2413922V | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
3 . . . Agricultural, Construction & Manufacturing Equipment ; |  |  | Original | A2413923W | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
4 . . . Office Equipment ; |  |  | Original | A2413924X | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
5 . . . Other ; |  |  | Original | A2413925A | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
TOTAL LEASE FINANCE ; |  |  | Original | A2413926C | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2011