tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 216723d1361867841-returning-a-value-from-a-cell-in-onecolumn-having-checked-for-conditions-in-another-column-for-olives-2
Sheet: Sheet1

45 |  | 32.3 | 101 | 1
 |  | 42.6 | 115 | 2 |  |  | OPTION 2  FORMULA
 |  | 54.3 | 156 | 3
 |  | 64.1 | 124 | 4
 |  | 22.3 | 111 |  |  | QUE STION 1 | I used the formula in H3 to find the highest value in Column D from those whose corresponding value in Column C
 |  |  |  |  |  |  | were lower than the value in A1
 |  |  |  |  |  |  | I copied the formula to H4 and I got the 2nd highest value. Is this by design?
 |  |  |  |  |  |  | Yes
 |  |  |  |  |  | QUE STION 2 | How can I change the conditions in H3 to compare A1 and the values in Column C
 |  |  |  | I would like to add these reference numbers above. |  |  | and choose the values  in Column C that are LESSER THAN A1 and then go to the corresponding values in Column D
 |  |  |  | and put them in Column B (as below!) |  |  | and return the highest value in D?
 |  |  |  | BUT! They ruin the formula in H3 :( !
 |  |  |  |  |  |  | I'd like to use the formula currently in H3 AND have the one I'm describing above.
 |  |  |  |  |  | QUE STION 3 | Is there a way to ALSO return the value in Column D? Which I would like to move to Column B…
 |  | for display purposes I put these numbers here.
 |  |  |  |  |  | DESIRED OUTPUT (EVERYTHING BELOW) |  |  |  |  |  |  | This formula yields
 | REFERENCE |  |  |  |  |  |  |  |  |  |  |  | values in Column D
 | NO. |  |  |  | OPTION 2  FORMULA |  |  |  | OPTION 3  FORMULA |  |  |  | corresponding to
45 | 1 | 32.3 | 101 |  |  |  |  |  |  |  |  |  | values in Column C
 | 2 | 42.6 | 115 |  |  |  |  |  |  |  |  |  | that are LESSER THAN A21
 | 3 | 54.3 | 156
 | 4 | 64.1 | 124
 | 5 | 22.3 | 111 |  |  |  |  | HIGHEST VALUES first |  |  |  | HIGHEST VALUES first
 |  |  |  |  |  |  | This formula yields
 |  |  |  |  |  |  | values in Column D
 |  |  |  |  |  |  | corresponding to
 |  |  |  |  |  |  | values in Column C
 |  |  |  |  |  |  | that are GREATER THAN A21
Spreadsheet: 156087d1337177875-excel-2007-need-to-create-batting-order-depending-on-stats-and-cant-have-a-player-twice-in-line-up-softball-stats-monday-night
Sheet: Game 5

 | Game # | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | Total
 | Date | 2012-06-18 19:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JBC |  |  |  |  |  |  |  | 0 | 0 | 0
 | Location | Jamestown |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jenison Bible #2 |  |  |  |  |  |  |  | 0 | 0 | 0
 | Opponent | Jenison Bible #2
 | Result | Loss
# | Name | G | AB | H | 1B | 2B | 3B | HR | BB | ROE | SAC | R | RBI | BA | OBP | SLG | OPS
1 | Scott |  |  | 0 |  |  |  |  |  |  |  |  |  | n/a | n/a | n/a | n/a
2 | [NAME] |  |  | 0 |  |  |  |  |  |  |  |  |  | n/a | n/a | n/a | n/a
3 | Jared |  |  | 0 |  |  |  |  |  |  |  |  |  | n/a | n/a | n/a | n/a
4 | [NAME] |  |  | 0 |  |  |  |  |  |  |  |  |  | n/a | n/a | n/a | n/a
5 | [NAME] |  |  | 0 |  |  |  |  |  |  |  |  |  | n/a | n/a | n/a | n/a
6 | Joel |  |  | 0 |  |  |  |  |  |  |  |  |  | n/a | n/a | n/a | n/a
7 | [NAME] |  |  | 0 |  |  |  |  |  |  |  |  |  | n/a | n/a | n/a | n/a
8 | [NAME] |  |  | 0 |  |  |  |  |  |  |  |  |  | n/a | n/a | n/a | n/a
9 | [NAME] |  |  | 0 |  |  |  |  |  |  |  |  |  | n/a | n/a | n/a | n/a
10 | Kris |  |  | 0 |  |  |  |  |  |  |  |  |  | n/a | n/a | n/a | n/a
11 | [NAME] |  |  | 0 |  |  |  |  |  |  |  |  |  | n/a | n/a | n/a | n/a
 |  |  |  | 0 |  |  |  |  |  |  |  |  |  | n/a | n/a | n/a | n/a
 |  |  |  | 0 |  |  |  |  |  |  |  |  |  | n/a | n/a | n/a | n/a
 |  |  |  | 0 |  |  |  |  |  |  |  |  |  | n/a | n/a | n/a | n/a
 | TOTAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | n/a | n/a | n/a | n/a
 | MAX
Spreadsheet: 863296d1710844989-date-and-data-help-training-class-schedule
Sheet: Schedule

 | Year | 2024 | Date |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 60 | 61 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70 | 71 | 72 | 73 | 74 | 75 | 76 | 77 | 78 | 79 | 80 | 81 | 82 | 83 | 84 | 85 | 86 | 87 | 88 | 89 | 90 | 91 | 92 | 93 | 94 | 95 | 96 | 97 | 98 | Column21 | Column22 | Column23 | Column24 | Column25 | Column26
 | Month | 3 | Weekday |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18 | 19 | 20 | 21 | 22 | 23
 | Name - EMP. ID |  | Month
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EMP. ID | Name | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Spreadsheet: 828065d1683207039-sort-function-or-any-ignoring-header-in-existing-let-function-dummy2
Sheet: Sheet1

Sheet | Sheet2 |  |  |  |  |  |  |  | ******************* Expected Result************************************
Group | Jasmine
 |  |  |  |  |  |  |  |  |  |  |  | 2nd sort |  |  | 1st sort
 |  |  |  |  |  |  |  | Require > | Header1 | Header4 | Header5 | Header6 | Header7 | Header8 | Header9 | Header11
 |  |  |  |  |  |  |  |  | Jasmine | 0 | 0 | 0 | 0 | 9631 | 0 | 0
 |  |  |  |  |  |  |  |  | Jasmine | 2098.77 | 0 | Avenger | 0 | ABC | Apps | 0
 |  |  |  |  |  |  |  |  | Jasmine | 0 | 0 | Desktop | 0 | 64638 | District | 47
 |  |  |  |  |  |  |  |  | Jasmine | 2084.2.6 | 0 | Poly | 0 | 895634 | Electro | 98
 |  |  |  |  |  |  |  |  | Jasmine | 0 | 0 | Tesla | 0 | 126364 | [NAME] | 97
 |  |  |  |  |  |  |  |  | Jasmine | 2097.6.4 | 0 | Popy | 0 | 126364 | Text1 | 2
Spreadsheet: 100240d1298645350-how-to-get-the-value-of-x-column-when-2-other-columns-values-are-met-luisexample
Sheet: Sheet1

Test A | Test B | Time |  |  | TestA | TestB | Time
0 | 2 | 1 |  |  | 11 | 2 | ????
0 | 2 | 2
0 | 2 | 3
1 | 2 | 4
1 | 2 | 5
11 | 0 | 6
1 | 0 | 7
11 | 2 | 8
1 | 2 | 9
1 | 2 | 10
Spreadsheet: 199400d1355207007-copying-a-vertical-list-to-a-horizontal-not-transposing-test1
Sheet: FormattedLanguage

MATERIAL__MAT_ID | Audio Polish English Mix | Audio Polish | Audio Russian | Audio Czech | Audio Hungarian
516284 | Audio Polish English Mix | Audio Polish
516666 |  |  | Audio Russian
516667 |  |  | Audio Russian
516668 | Audio Polish English Mix | Audio Polish
516669 | Audio Polish English Mix | Audio Polish
517286 |  |  |  | Audio Czech | Audio Hungarian
517306 | Audio Polish English Mix | Audio Polish
517307 | Audio Polish English Mix | Audio Polish
517311 | Audio Polish English Mix | Audio Polish
517482 |  |  |  |  | Audio Hungarian
519145 |  |  | Audio Russian
519167 |  |  | Audio Russian
519237 | Audio Polish English Mix | Audio Polish
519239 | Audio Polish English Mix | Audio Polish
519241 | Audio Polish English Mix | Audio Polish
519242 | Audio Polish English Mix | Audio Polish
519244 | Audio Polish English Mix | Audio Polish
519273 |  |  |  | Audio Czech | Audio Hungarian
519276 |  |  |  | Audio Czech | Audio Hungarian
519277 |  |  |  | Audio Czech | Audio Hungarian
519278 |  |  |  | Audio Czech | Audio Hungarian
519279 |  |  |  | Audio Czech | Audio Hungarian
519366 |  |  | Audio Russian
519392 |  |  | Audio Russian
519448 |  |  | Audio Russian
519450 |  |  | Audio Russian
519943 |  |  | Audio Russian
520339 |  |  | Audio Russian
520430 |  |  | Audio Russian
521260 | Audio Polish English Mix
Spreadsheet: 103493d1301255050-displaying-data-from-the-main-page-copy-of-cc-template
Sheet: Sheet1

Needs | Activities and Services | Number of families engaged (e-start) |  |  |  | ECM | Evidence Location
 |  | Qtr 1 | Qtr 2 | Qtr 3 | Qtr 4
 | Antenatal Session |  |  |  |  | Be Healthy | Physically Healthy
 | [NAME] |  |  |  |  | Stay Safe | [NAME]
 | Berries drop in and play |  |  |  |  | Enjoy and [NAME] | Safe from bullying and discrimination
 | Breastfeeding Support Group |  |  |  |  | Be Healthy | Mentally & Emotionally Healthy
 | Breastfeeding Support Group Training |  |  |  |  | Enjoy and [NAME] | Achieve personal and social development and enjoy recreation
 | Butterfly and [NAME] |  |  |  |  | Pick an ECM from the drop down | Pick an evidence location from the drop down
 | Christmas Craft Workshop |  |  |  |  | Pick an ECM from the drop down | Pick an evidence location from the drop down
 | Christmas Party |  |  |  |  | Pick an ECM from the drop down | Pick an evidence location from the drop down
 | Crackington Haven Playgroup |  |  |  |  | Pick an ECM from the drop down | Pick an evidence location from the drop down
 | Drop in and Play |  |  |  |  | Pick an ECM from the drop down | Pick an evidence location from the drop down
 | Why Weight Creche |  |  |  |  | Pick an ECM from the drop down | Pick an evidence location from the drop down
Spreadsheet: 827956d1683144215-count-sort-occurrences-with-multiple-variables-sample
Sheet: Calcs

Given three worksheets containing data - Data1, [NAME], Data3
And the following data validated categories:
Worksheet | Name | Color | Day | Time | State
Data2 | [NAME] | * | Tue | * | GA
Desired output:
 | Name | Color | Day | Time | State
 | [NAME]   3 | Blue   1 | Tue   3 | Normal   2 | GA    3
 |  | Red   1 |  | Late   1
 |  | Yellow 1
Note:  The desired output will illustrate two things.
1) If a category variable is selected (green), the output will show the frequency
that selected variables occurred on the same row
2) If a category variable is "*" (blue), the output will show the SORTED frequency
of the respective category variable associated with selected category
variables occurring on the same row
See Data2 for color display of matched occurences.
I imagine the formula will use INDIRECT, FILTER, SORT and LET functions but I can't resolve it
with multiple variables.
Spreadsheet: phillip_allen__28815__rentroll_915
Sheet: weekly

 |  |  |  |  |  |  | Stagecoach Apartments
 |  |  |  |  |  |  | Rent Worksheet
 |  |  |  |  |  |  | Week ended September 15, 2000
Unit | Name | Bal. Fwd. | Rent Due | Late Fees | Util. Over | Total | Date Pd. | Amt. Paid | Fwd. Bal. | Notes
1 | [NAME] |  | 120
2 | [NAME] |  | 220
3 | [NAME] |  | 130
4 | [NAME] |  | 330
5 | [NAME] | 130 | 130
6 | HelenMerriwether | 56 | 260
7 | LUCY |  | Mgr
8 | [NAME] |  | 120
9 | [NAME] |  | 110
10 | [NAME] |  | 110
11 | [NAME] |  | 200
12 | [NAME] |  | 120
13 | [NAME] |  | 140
14 | [NAME] | 170 | 95
15 | TomasCisneros |  | 190
16 | [NAME] errin |  | 130
17 | [NAME] |  | 130
18 | [NAME] |  | 110
19 | Vacant
20 | Alonzo Perez
21 | [NAME] |  | 115
22 | [NAME] |  | 100
23 | Moses [NAME] | 40 | 130
24 | Wade |  | Maint
25 | [NAME] |  | 100
26 | [NAME] ramirez |  | 115
27 | Gillbert Coronado | 5 | 130
28 | [NAME] | 115 | 115
29 | [NAME] |  | 115
30 | Mai Tram |  | 400
31 | [NAME] |  | 105
32 | [NAME] |  | 100
33 | [NAME] |  | 105
34 | Ruthie McClure |  | 120
35 | Laxson/Navarro |  | 110
36 | Alarcon |  | 125
37 | [NAME] |  | 125
38 | Rodriguez |  | 520
39 | Price [NAME] |  | 130
40 | Gomez Victor |  | 150
41 | [NAME] |  | 550
42 | [NAME] |  | 120
43 | Palermo Chuck |  | 120
44 | NhanNguyn |  | 650
Total
Spreadsheet: 867515d1714384461-using-array-formula-and-relative-referencing-most-efficiently-sample-data
Sheet: Sheet1

 |  | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 |  | 6
 |  | 7
 |  | 8
 |  | 9
Spreadsheet: 968543cf-0daa-4cc4-80d1-6e41edaf6ea3
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
GRAS2 | Test | GRAS2 | Grass Panel # 2 | Grass Panel # 2 | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL Additional Information: See Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
GRAS2 | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
GRAS2 | Result | GRAS2 | Grass Panel # 2 | Grass Panel # 2 | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 30188-7 | (Cynodon dactylon+Lolium perenne+Phleum pratense+Poa pratensis+Sorghum halepense+Paspalum notatum) Ab.IgE:ACnc:Pt:Ser:Qn:Multidisk
Spreadsheet: jonathan_mckay__17203__Tariffs New Update
Sheet: SummerSum

[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ROLL EACH MONTH
(Using Summer to Date average fuel ratio)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FP | BASIS
FX |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AECO CAD
Aeco to Border | 0 | $C/GJ |  |  |  |  |  | Mids Date: |  |  |  |  |  |  |  |  |  | AECO USD
Aeco to Border |  | $US/MMBTU |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NX1
 |  |  |  |  |  | PRICE TERM: | 2001-06-01 00:00:00 | - | 2001-10-01 00:00:00 |  |  |  |  |  |  |  |  | EMPRESS USD
Gas Prices | $C/GJ | $US/MMBTU |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CHICAGO
AECO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DAWN
Empress/Border |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MALIN
Station 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | STATION 2
Stanfield
Sumas
Emerson
 |  |  |  |  | $US/MM | $US/MMBTU |  |  | $C/GJ |  |  | FIRM TRANSPORTATION
Transportation Point | Firm Variable | IT Variable | % Fuel |  | Fuel | Firm Variable Total | IT Total |  | Firm Variable Total | IT Total |  | RECP | DELIV | SPREAD | VALUE
ABC to [NAME]
ABC to Stanfield*
ABC to Stanfield (NWPL)*
ABC to Malin*
Empress to Ventura
Empress to Chicago
Empress to Saskatchewan
Empress to GLGT
Empress to Dawn
Empress to [NAME]
Empress to Iroquois
Empress to Chippawa
Empress to Phillipsburg
Empress to St Clair
Empress to Parkway
Empress to St. Clair (GLGT) w/o GLGT
Emerson to St. Clair (GLGT) w/o GLGT
Emerson to Fortune Lake (GLGT) w/o GLGT
Emerson to Carlton (GLGT) w/o GLGT
Alberta to Chicago via Alliance
BC to Chicago via Alliance
Stanfield to Malin*
Station 2 to AECO
Station 2 to Huntingdon
Station 2 to NWPL*
Huntingdon to NWPL*
AECO to Station 2 **
All numbers in $US/MMBtu
*Includes GRI
**AECO to Station 2 IT priced off of Empress
Station 2 to NWPL IT has T-South firm and NWPL IT
TCPL IT costs assume floor bid of 80% of firm
Spreadsheet: 677814d1589539979-countifs-help-manhole-table-1-
Sheet: Surface Manhole Schedule

 |  |  |  |  | 1 | 1.25 | 1.5 | 1.75 | 2 | 2.25 | 2.5 | 2.75 | 3 | 3.25 | 3.5 | 3.75 | 4 | 4.25 | 4.5 | 4.75 | 5 | 5.25 | 5.5 | 5.75 | 6 | 6.25 | 6.5 | 6.75 | 7 | 7.25 | 7.5 | 7.75 | 8 | 8.25
 |  | 900
 |  | 1050
 |  | 1200
 |  | 1350
 |  | 1500
 |  | 1800
 |  | 2100
 |  | 2400
 |  | 2700
 |  | 3000
Spreadsheet: 819917d1677766220-split-column-nowy-microsoft-excel-worksheet-2-
Sheet: Arkusz1

1 | 2 | 3 | 4 | 5
looks like this | Looks like this |  | Merged
41-203 | SŁONECZNA 14 SOSNOWIEC | →→ | SŁONECZNA 14 41-203 SOSNOWIEC Polska
40-315 | AL. ROŹDZIEŃSKIEGO 210 KATOWICE | →→ | AL. ROŹDZIEŃSKIEGO 210 40-315 KATOWICE Polska
40-315 | GEN. [NAME] PSZCZYNA | →→ | GEN. [NAME] 40-315 PSZCZYNA Polska
43-500 | 1 MAJA 7 GOLESZÓW | →→ | 1 MAJA 7 43-500 GOLESZÓW Polska
40-212 | ROLNA 14 KATOWICE | →→ | ROLNA 14 40-212 KATOWICE Polska
Spreadsheet: benjamin_rogers__1039__Consolidated 6 Peaker-051800
Sheet: IS

[NAME]
('000 $)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Revenue
Demand Payment
Energy Payment
Block Payment
Amortization of Contract
Market Price & Price Extension Period:
Demand Payment
Variable Revenue
Energy Margin
Interest Income
Total Revenue
Expense
Fixed O&M
Variable O&M
Major Maintenance & Ongoing Capex
O&M Management Fee
Owner's Expense
Property Taxes
Franchise Tax
Total Expense
EBITDA
Depreciation & Amortization
EBIT
Interest Expense
EBT
Book State Tax Benefit / (Expense)
Shareholder Fed. Tax Benefit / (Expense)
Net Income
Spreadsheet: 0745f374-567b-4770-ad1d-ba024eb85d9f
Sheet: Erosion Control Estimate

EROSION CONTROL COST ESTIMATE
TITLE SHEET
 |  |  |  |  | FILE NO:
PROJECT NAME:
OWNER'S NAME:
ADDRESS:
PHONE #: |  |  | (            )
FAX #: |  |  | (            )
E-MAIL ADDRESS:
ENGINEERING FIRM:
ADDRESS:
CONTACT PERSON:
PHONE #: |  |  | (            )
FAX #: |  |  | (            )
E-MAIL ADDRESS:
FOR SEAL
 |  |  | ENGINEER'S SIGNATURE |  |  |  | DATE
 |  |  | PRINT NAME |  | RCE |  | EXP.
Erosion Control Plan Number:
No. of Sheets:
Total Cost Estimate: |  |  | 0
APPROVED BY |  |  |  | DATE
COST ESTIMATE
EROSION CONTROL
[NAME] | QUANTITY | UNIT | UNIT COST | COST
GRAVEL BAG |  | EA | 1.1
JUTE BAG |  | SF | 0.4
STRAW MAT |  | SF | 0.28
STRAW BALES |  | EA | 5
SILT FENCE |  | LF | 1.6
FIBER ROLLS |  | LF | 2.25
FIBER MATT |  | SF | 0.4
HYDRO-SEED |  | SF | 0.2
HYDRAULIC MULCH |  | SF | 0.3
STABILIZED CONSTRUCTION ENTRANCE |  | SF | 5.25
CONCRETE WASHOUT |  | EA | 500
INLET PROTECTION (SEDIMENT) |  | EA | 150
 |  |  | SUBTOTAL:
 |  |  | Contingencies - 15%:
 |  |  | TOTAL COST ESTIMATE EROSION CONTROL:
Spreadsheet: 777122d1650184097-count-no-of-cases-based-on-a-given-date-range-excelforum_countnocase-2
Sheet: Defect

 | S/No | Car | Defect | WO/JR No. | Since | Status | Clear | >3 | No of Case | >7
 | 1 | 28 |  | NA | 2021-12-01 00:00:00 | Pending Investigation | 2021-12-10 00:00:00
 | 2 | 16 |  | NA | 2021-12-08 00:00:00 | Pending Investigation
 |  | 5 |  |  | 06-12-21
Spreadsheet: 842131d1694186648-if-and-only-works-on-the-same-row-123
Sheet: Returns

 |  |  |  |  |  |  |  |  |  |  |  | Manual
order number | date of return | Local / International | Shipping zone | Return reason | Returned product SKU | Refund / Exchange | Product weight | Products total weight | Product price | What was the exchange? | Shipping cost | Shipping cost customer to us | Tracking number | Total refund price
10334193 |  | International | 1 | Quality issues / Faulted | 100023 | Refund
Spreadsheet: louise_kitchen__23094__NETCO_All  Gas List_120601
Sheet: Gas Trading

[NAME] | Central Trading | 1
[NAME] | Central Trading | 2
[NAME] | Central Trading | 3
[NAME] | Central Trading | 4
[NAME] | Central Trading | 5
[NAME] | Central Trading | 6
[NAME] | Central Trading | 7
[NAME] | Central Trading | 8
[NAME] | East Trading | 9
[NAME] | East Trading | 10
[NAME] | East Trading | 11
[NAME] | East Trading | 12
[NAME] | East Trading | 13
Brad Mckay | East Trading | 14
[NAME] | East Trading | 15
[NAME] | East Trading | 16
[NAME] | Financial Trading | 17
[NAME] | Financial Trading | 18
[NAME] | Financial Trading | 19
[NAME] | Financial Trading | 20
[NAME] May | Financial Trading | 21
[NAME] | Financial Trading | 22
[NAME] | Financial Trading | 23
[NAME] | NGL | 24
[NAME] | NGL | 25
Wade Hicks | NGL | 26
[NAME] | Texas Trading | 27
[NAME] | Texas Trading | 28
[NAME] | Texas Trading | 29
[NAME] | Texas Trading | 30
[NAME] | Trading | 31
[NAME] | West Trading | 32
[NAME] | West Trading | 33
[NAME] | West Trading | 34
[NAME] | West Trading | 35
[NAME] | West Trading | 36
[NAME] | West Trading | 37
[NAME] | West Trading | 38
[NAME] | West Trading | 39
[NAME] | West Trading | 40
Tori Kuykendall | West Trading | 41
[NAME] | West Trading | 42
[NAME] | West Trading | 43
Spreadsheet: 176997d1346161249-how-to-get-my-spreadsheet-to-change-accordingly-spreadsheet-model-2
Sheet:  Report

 | Name |  |  | [NAME]
 | Age |  |  | 15
 | Height |  |  | 165
 | New Weight |  |  | 43.86326075686881
 | New BMI |  |  | 16.11139054430443
Here is the activity plan for the next ten weeks!
Day One
Activity | Time (hours) | Cals per hour | Cals burnt off
Fast Walking | 0.5 | 150 | 75
Squash | 1 | 140 | 140
Day Two
Activity | Time (hours) | Cals per hour | Cals burnt off
Five a side Football | 1 | 150 | 150
Kayaking | 0.5 | 190 | 95
Day Three
Activity | Time (hours) | Cals per hour | Cals burnt off
Kickboxing | 0.5 | 190 | 95
Mountain Climbing | 0.25 | 190 | 47.5
Day Four
Activity | Time (hours) | Cals per hour | Cals burnt off
Rugby Men | 1.75 | 140 | 245
Ice Hockey | 0.25 | 200 | 50
Day Five
Activity | Time (hours) | Cals per hour | Cals burnt off
Windsurfing | 1 | 150 | 150
Water Skiing | 1 | 200 | 200
Day Six
Activity | Time (hours) | Cals per hour | Cals burnt off
Weight Training | 1.5 | 200 | 300
Street Dance | 0.5 | 140 | 70
Day Seven
Activity | Time (hours) | Cals per hour | Cals burnt off
Rock Climbing | 1.75 | 140 | 245
Five a side Football | 2 | 150 | 300
Here is the food plan for the next ten weeks!
 | Day One | Day Two | Day Three | Day Four | Day Five | Day Six | Day Seven
Breakfast | None | None | None | None | None | None | None
 | None | None | None | None | None | None | None
 | None | None | None | None | None | None | None
 | None | None | None | None | None | None | None
 | None | None | None | None | None | None | None
Lunch | None | None | None | None | None | None | None
 | None | None | None | None | None | None | None
 | None | None | None | None | None | None | None
 | None | None | None | None | None | None | None
 | None | None | None | None | None | None | None
Meats | None | None | None | None | None | None | None
 | None | None | None | None | None | None | None
 | None | None | None | None | None | None | None
 | None | None | None | None | None | None | None
 | None | None | None | None | None | None | None
Fruit and Veg | None | None | None | None | None | None | None
 | None | None | None | None | None | None | None
 | None | None | None | None | None | None | None
 | None | None | None | None | None | None | None
 | None | None | None | None | None | None | None
 | None | None | None | None | None | None | None
Drinks | None | None | None | None | None | None | None
 | None | None | None | None | None | None | None
 | None | None | None | None | None | None | None