tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 118642d1313821119-shorten-formula-to-avoid-maxing-of-cpu-master-budget
Sheet: Preliminaries

CODE | ITEM | Supplier | QTY | COST |  | ACTUAL COST | INC B/M | GST Amt | TOTAL INC GST | CODE TOTAL
5-1060 | COUNCIL
 | Plan Lodgement (Council Quote) |  | 0 | 4000 | item
 | Sign Board |  | 0 | 150 | item
5-1030 | ESTIMATING/ADMINISTRATION
 | Plan Copies |  | 3 | 10 | set
 | Administrator/Bookkeeping |  | 0 | 150 | wk
 | Copyshop |  | 5 | 50 | wk
 |  |  | 0 | 45 | hr
5-1050 | INSURANCE
 | Contract Work & Public Liability |  | 0 | 1800 | item
 | QBSA Insurance |  | 1 | 3889.25 | item
 | Contract Costs QMBA |  | 1 | 15 | each
 | Subcontractor Contracts |  | 15 | 2 | each
 | Qleave |  | 475000 |  | item
5-1040 | CONSULTANTS
 | Surveyor |  | 1 | 750 | item
 | Engineer |  | 0 | 1500 | quote
 |  |  |  |  | item
 | Inspection Fees |  | 8 | 150 | visit
 |  |  | 0 | 200 | item
5-1110 | TEMPORARY FENCING (Del & Install) |  | 0 | 10 | Lm
5-1080 | CONTINGENCY ALLOWANCE |  | 0 |  | Item
5-1070 | TRAVEL ALLOWANCE |  | 0 | 12 | day
 | Preliminary Totals
NOTES
1
2
Spreadsheet: daren_farmer__5207__BMSPT041
Sheet: BMSPT066

BAMMEL STORAGE ACTIVITY
VOLUME SPLIT BY Counterparties
2001-04-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | SWING CONTRACT VOLUMES |  |  |  |  | ECT LONG/(SHORT) |  |  |  | LONG/(SHORT)
 |  | HPL INDEX |  |  | HPL FIXED PRICE |  |  |  |  | TOTAL | HL&P | CP&L | TUFCO | TOTAL |  | ECT FIRST OF THE MONTH | TUFCO/ HL&P/ CP&L SWING VOLUME | ECT LONG OR (SHORT) |  | ECT TOTAL | HPLC Excluding 3rd Party | Net LONG/ (SHORT)
 |  | MTD Adjustment | CURRENT DAY | Total | MTD Adjustment | CURRENT DAY | Total | 3rd Party | HPLC Total |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  | Reinject Fees
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Injected Volume | Value
Beginning Balance
1 | Scheduled |  |  |  |  |  |  |  |  |  | 0 | 0
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Estimated
 | Estimated
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Index: | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fuel: | 0.01
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fuel Rate:
Ending Balance |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Prod.[NAME]:
Variances:
Total Projected
March 31 thru April 6
April 7 thru April 13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Previous Position: |  | 452505
April 14 thru April 20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]:
April 21 thru April 27
Spreadsheet: 143597d1330472427-protect-hidden-column-hidden-column
Sheet: Sheet1

Data1 | Data2 | Data3 | Data4 | Data5 | Data6 | Data7 | <<<<<Column F is hidden, to veiw it enter the password "12345"
Data1 | Data2 | Data3 | Data4 | Data5 | Data6 | Data7 | As you can see other people can do what ever they want with the other cells
Data1 | Data2 | Data3 | Data4 | Data5 | Data6 | Data7 | But you have to lock the whole sheet. This does not mean you can't have them change other aspects of
Data1 | Data2 | Data3 | Data4 | Data5 | Data6 | Data7 | the sheet.
Data1 | Data2 | Data3 | Data4 | Data5 | Data6 | Data7
Data1 | Data2 | Data3 | Data4 | Data5 | Data6 | Data7
Data1 | Data2 | Data3 | Data4 | Data5 | Data6 | Data7
Data1 | Data2 | Data3 | Data4 | Data5 | Data6 | Data7
Data1 | Data2 | Data3 | Data4 | Data5 | Data6 | Data7
Data1 | Data2 | Data3 | Data4 | Data5 | Data6 | Data7
Data1 | Data2 | Data3 | Data4 | Data5 | Data6 | Data7
Data1 | Data2 | Data3 | Data4 | Data5 | Data6 | Data7
Data1 | Data2 | Data3 | Data4 | Data5 | Data6 | Data7
Data1 | Data2 | Data3 | Data4 | Data5 | Data6 | Data7
Data1 | Data2 | Data3 | Data4 | Data5 | Data6 | Data7
Data1 | Data2 | Data3 | Data4 | Data5 | Data6 | Data7
Data1 | Data2 | Data3 | Data4 | Data5 | Data6 | Data7
Data1 | Data2 | Data3 | Data4 | Data5 | Data6 | Data7
Data1 | Data2 | Data3 | Data4 | Data5 | Data6 | Data7
Data1 | Data2 | Data3 | Data4 | Data5 | Data6 | Data7
Data1 | Data2 | Data3 | Data4 | Data5 | Data6 | Data7
Data1 | Data2 | Data3 | Data4 | Data5 | Data6 | Data7
Data1 | Data2 | Data3 | Data4 | Data5 | Data6 | Data7
Data1 | Data2 | Data3 | Data4 | Data5 | Data6 | Data7
Data1 | Data2 | Data3 | Data4 | Data5 | Data6 | Data7
Data1 | Data2 | Data3 | Data4 | Data5 | Data6 | Data7
Data1 | Data2 | Data3 | Data4 | Data5 | Data6 | Data7
Data1 | Data2 | Data3 | Data4 | Data5 | Data6 | Data7
Data1 | Data2 | Data3 | Data4 | Data5 | Data6 | Data7
Data1 | Data2 | Data3 | Data4 | Data5 | Data6 | Data7
Data1 | Data2 | Data3 | Data4 | Data5 | Data6 | Data7
Data1 | Data2 | Data3 | Data4 | Data5 | Data6 | Data7
Data1 | Data2 | Data3 | Data4 | Data5 | Data6 | Data7
Data1 | Data2 | Data3 | Data4 | Data5 | Data6 | Data7
Data1 | Data2 | Data3 | Data4 | Data5 | Data6 | Data7
Data1 | Data2 | Data3 | Data4 | Data5 | Data6 | Data7
Data1 | Data2 | Data3 | Data4 | Data5 | Data6 | Data7
Data1 | Data2 | Data3 | Data4 | Data5 | Data6 | Data7
Data1 | Data2 | Data3 | Data4 | Data5 | Data6 | Data7
Data1 | Data2 | Data3 | Data4 | Data5 | Data6 | Data7
Data1 | Data2 | Data3 | Data4 | Data5 | Data6 | Data7
Data1 | Data2 | Data3 | Data4 | Data5 | Data6 | Data7
Data1 | Data2 | Data3 | Data4 | Data5 | Data6 | Data7
Data1 | Data2 | Data3 | Data4 | Data5 | Data6 | Data7
Data1 | Data2 | Data3 | Data4 | Data5 | Data6 | Data7
Spreadsheet: vkaminski__40900__CASH_GasMat_0400MyCopy
Sheet: Ref1

[NAME]
 |  |  |  |  |  |  | Person(s)
 |  |  |  |  |  | Date Of | Responsible
Assumption Category | Assumption Description | Current Assumption |  |  | Assumption Reference | Reference | For Assumption | Comments
 |  |  |  |  | Project Information Memorandum | 1999-08-01 00:00:00 | DKB | Chapter 6 Section 1.2
 |  |  |  |  | Project Information Memorandum | 1999-08-01 00:00:00 | DKB | Chapter 6 Section 1.0
 |  |  |  |  | SCC EPC Contract | 1997-08-22 00:00:00 | [NAME] | Table C-2
 |  |  |  |  | [NAME] | 1999-05-11 00:00:00 | [NAME] | To Follow Up With Final Schedule
 |  |  |  |  | [NAME] | 1999-05-11 00:00:00 | [NAME] | To Follow Up With Final Schedule
 |  |  |  |  | Calculation
 |  |  |  |  | [NAME] | 1999-05-11 00:00:00 | [NAME] | To Follow Up With Final Schedule
 |  |  |  |  | [NAME] | 1999-08-31 00:00:00 | [NAME] | To Follow Up With Final Schedule
 |  |  |  |  | PPA |  |  | Verify This Assumption
 |  |  | Years |  | TGS-GasBol Contract | 1999-03-05 00:00:00 | [NAME] | Opening Paragraph
 |  |  |  |  | Project Information Memorandum
 |  |  |  |  | [NAME] | 1999-03-17 00:00:00 | [NAME]
 |  |  |  |  | Calculation
 |  |  |  |  | Calculation |  |  | Six Months From Start Of Phase III
 |  |  |  |  | TGS-GasMat Contract | 1999-03-05 00:00:00 | [NAME] | Section 3.1
 |  |  |  |  | TGS-GasMat Contract | 1999-03-05 00:00:00 | [NAME] | Section 3.1
 | Escalation On Fixed Capacity Payment |  |  |  | TGS-GasMat Contract | 1999-03-05 00:00:00 | [NAME] | Section 3.1
 |  |  |  |  | TGS-GasMat Contract | 1999-03-05 00:00:00 | [NAME] | Section 4.1
 |  |  |  |  | TGS-GasMat Contract | 1999-03-05 00:00:00 | [NAME] | Section 4.1
 | Base Year
 | Escalation Factor |  |  |  |  |  |  | Escalate @ CPI
 |  |  |  |  | K. Pierce - Memo | 1998-03-27 00:00:00 | K. Pierce | Includes GasBol / Transredes O&M Agrmnt
 |  |  |  |  | K. Pierce - Memo | 1998-03-27 00:00:00 | K. Pierce | Includes GasBol / Transredes O&M Agrmnt
 |  |  |  |  | K. Pierce - Memo | 1998-03-27 00:00:00 | K. Pierce | Includes GasBol / Transredes O&M Agrmnt
 |  |  |  |  | K. Pierce - Memo | 1998-03-27 00:00:00 | K. Pierce | Includes GasBol / Transredes O&M Agrmnt
 |  |  |  |  | K. Pierce - Memo | 1998-03-27 00:00:00 | K. Pierce | Includes GasBol / Transredes O&M Agrmnt
 |  |  |  |  | K. Pierce - Memo | 1998-03-27 00:00:00 | K. Pierce | Includes GasBol / Transredes O&M Agrmnt
 |  |  |  |  | K. Pierce - Memo | 1998-03-27 00:00:00 | K. Pierce | Includes GasBol / Transredes O&M Agrmnt
 |  |  |  |  | K. Pierce - Memo | 1998-03-27 00:00:00 | K. Pierce | Includes GasBol / Transredes O&M Agrmnt
 |  |  |  |  | [NAME] | 1998-12-28 00:00:00 | [NAME] | Premium $308K, Taxes $63K
 |  |  |  |  | J. Bestard - Verbal | 1998-09-25 00:00:00 | J. Bestard
 |  |  |  |  | TGS-GasMat Contract | 1999-03-05 00:00:00 | [NAME] | Section 8.1
 | Conversion Of MCM To Kcal |  | Kcal / MCM |  | Conversion Tables
 | Conversion Of Kcal To MMBTU |  | MMBTU / Kcal |  | Conversion Tables
 | Conversion Of MCM To MMBTU |  | MCM / MMBTU |  | Calculation
Spreadsheet: 328175d1403804696-closest-number-above-and-below-mpgpc-handicap-final-3
Sheet: 2014 (Before)

Member | Shoot 1 | Shoot 2 | Shoot 3 | Shoot 4 | Shoot 5 |  | Handicap |  | Current Score |  | Adjusted Score |  | Name | Actual score |  | Name | Adjusted score
[NAME] | 70 | 0 | 0 | 0 | 0 |  | 20 |  | 0
[NAME] | 52 | 53 | 0 | 0 | 0 |  | 32 |  | 0
[NAME] | 66 | 0 | 0 | 0 | 0 |  | 23 |  | 0
[NAME] | 43 | 33 | 0 | 0 | 0 |  | 40 |  | 0
[NAME] | 62 | 60 | 66 | 68 | 0 |  | 24 |  | 0
[NAME] | 76 | 0 | 0 | 0 | 0 |  | 16 |  | 0
[NAME] | 40 | 0 | 0 | 0 | 0 |  | 40 |  | 0
[NAME] | 66 | 68 | 64 | 0 | 0 |  | 23 |  | 0
[NAME] | 52 | 47 | 0 | 0 | 0 |  | 34 |  | 0
[NAME] | 75 | 72 | 71 | 0 | 0 |  | 19 |  | 0
[NAME] | 75 | 79 | 0 | 0 | 0 |  | 16 |  | 0
[NAME] | 57 | 0 | 0 | 0 | 0 |  | 29 |  | 0
[NAME] | 60 | 0 | 0 | 0 | 0 |  | 27 |  | 0
[NAME] | 64 | 67 | 74 | 55 | 0 |  | 24 |  | 0
[NAME] | 52 | 49 | 56 | 0 | 0 |  | 32 |  | 0
[NAME] | 58 | 0 | 0 | 0 | 0 |  | 28 |  | 0
[NAME] | 40 | 0 | 0 | 0 | 0 |  | 40 |  | 0
[NAME] | 52 | 51 | 0 | 0 | 0 |  | 33 |  | 0
[NAME] | 40 | 36 | 0 | 0 | 0 |  | 40 |  | 0
[NAME] | 40 | 38 | 31 | 23 | 0 |  | 40 |  | 0
[NAME] | 42 | 39 | 0 | 0 | 0 |  | 40 |  | 0
[NAME] | 57 | 56 | 59 | 54 | 0 |  | 29 |  | 0
[NAME] | 58 | 52 | 0 | 0 | 0 |  | 30 |  | 0
Shane Parsons | 49 | 42 | 0 | 0 | 0 |  | 37 |  | 0
Clive Perrin | 69 | 61 | 74 | 59 | 0 |  | 23 |  | 0
[NAME] | 69 | 68 | 0 | 0 | 0 |  | 21 |  | 0
[NAME] | 73 | 71 | 0 | 0 | 0 |  | 19 |  | 0
[NAME] | 43 | 0 | 0 | 0 | 0 |  | 38 |  | 0
[NAME] | 57 | 48 | 66 | 45 | 0 |  | 31 |  | 0
[NAME] | 64 | 63 | 52 | 47 | 0 |  | 29 |  | 0
[NAME] | 70 | 74 | 75 | 66 | 0 |  | 20 |  | 0
[NAME] | 51 | 46 | 45 | 0 | 0 |  | 36 |  | 0
[NAME] | 51 | 0 | 0 | 0 | 0 |  | 33 |  | 0
[NAME] | 72 | 68 | 71 | 46 | 0 |  | 24 |  | 0
[NAME] | 55 | 53 | 0 | 0 | 0 |  | 31 |  | 0
[NAME] | 40 | 0 | 0 | 0 | 0 |  | 40 |  | 0
[NAME] | 40 | 0 | 0 | 0 | 0 |  | 40 |  | 0
[NAME] | 50 | 69 | 53 | 68 | 54 |  | 28 |  | 0
[NAME] | 48 | 0 | 0 | 0 | 0 |  | 35 |  | 0
[NAME] | 49 | 43 | 0 | 0 | 0 |  | 36 |  | 0
Adrian Whitehurst | 70 | 62 | 75 | 73 | 0 |  | 20 |  | 0
[NAME] | 54 | 58 | 0 | 0 | 0 |  | 30 |  | 0
[NAME] | 48 | 43 | 43 | 41 | 0 |  | 38 |  | 0
 |  |  |  |  |  |  |  | Average | #N/A
 |  |  |  |  |  |  |  | Closest < | #N/A
 |  |  |  |  |  |  |  | Closest > | #N/A
Spreadsheet: 274409d1383108751-data-from-sheet2-will-populate-if-certain-cell-in-sheet1-have-numerical-value-book1
Sheet: Task

Emp# | Name | Task1 | [NAME] | Task3 | Task4 | Task5 | Task6 | Task7 | Task8 | Task9
11111 | employee1 | x | x |  | x
22222 | employee2 |  | x
33333 | employee3 |  |  | x |  |  |  |  |  | x
44444 | employee4 |  |  |  | x
55555 | employee5 |  |  |  |  | x
66666 | employee6 |  |  |  |  |  | x
77777 | employee7 |  |  |  |  |  |  | x
88888 | employee8 |  |  |  |  |  |  |  | x
99999 | employee9 |  |  |  |  |  |  |  |  | x
Spreadsheet: 170552d1343313924-need-formula-macro-to-assign-training-classes-to-variable-sized-groups-excel-forum-example-solved
Sheet: Sheet1

Staff | Center | Training Class To Attend
Wanser | DC | 1
Esther | DC
[NAME] | DC
Miesha | DC
Gloria | DC
[NAME] | DC
[NAME] | VA
[NAME] | VA
[NAME] | VA
Frewoini | VA
Collin | VA
Suzanne | VA
Christine | VA
Pierrein | VA
Tiffany | VA
Yakob | MD
[NAME] | MD
[NAME] | MD
Natalia | MD
[NAME] | CA
[NAME] | CA
[NAME] | CA
Sonya | CA
[NAME] | CA
[NAME] | CA
Wayne | CA
Robyn | NC
Kimetra | NC
Galina | NC
[NAME] | NC
Eboni | NC
[NAME] | NC
[NAME] | NC
[NAME] | MA
[NAME] | MA
[NAME] | MA
Chadderick | MA
Fatin | MA
[NAME] | MA
[NAME] | MA
Karida | NY
Beverley | NY
Mozone | NY
Megan | NY
[NAME] | NY
Jaime | NY
Derrick | IL
Massomeh | IL
[NAME] | IL
Tomia | IL
Dawn | IL
[NAME] | IL
[NAME] | IL
Tamia | IL
Melody | IL
[NAME] | IL
Gulalai | IL
[NAME] | IL
Garry | IL
Diedria | IL
Curtis | FL
[NAME] | FL
[NAME] | FL
Rebecca | FL
Sabian | FL
[NAME] | FL
Ayebea | FL
[NAME] | FL
[NAME] | FL
[NAME] | FL
Spreadsheet: 148423d1333396619-creating-a-report-to-show-vehicle-tax-due-tax-disc-log-trial
Sheet: DX55 BYT

 |  |  |  |  | DX55 BYT
Registration number : | DX55 BYT |  | Date Taxed | Duration | Tax Expiry  Date | Cost (£)
Manufacturer : | DAF |  | 2005-08-31 00:00:00 | 12 Months | 2006-09-01 00:00:00 | £1200 + £38
Specification : | 6 x 2 A (3 Axle) |  | 2006-08-31 00:00:00 | 12 Months | 2007-09-01 00:00:00 | 1200
Type : | FTG XF 95.480 |  | 2007-08-31 00:00:00 | 12 Months | 2008-09-01 00:00:00 | 1200
1st Registered : | 01.09.05 |  | 2008-08-31 00:00:00 | 12 Months | 2009-09-01 00:00:00 | 1200
Engine : | XE 355C1 12.60 litre |  | 2009-08-28 00:00:00 | 12 Months | 2010-09-01 00:00:00 | 1200
[NAME] : | 44,000kg |  | 2010-08-31 00:00:00 | 12 Months | 2011-09-01 00:00:00 | 1200
 |  |  | 2011-08-26 00:00:00 | 12 Months | 2012-09-01 00:00:00 | £1,200 + £2.50 Online fee
 |  |  | 2011-11-29 00:00:00 | 12 Months | 2012-09-01 00:00:00 | 700 | RP HGV
 |  |  | Exhange Tax disc from HGV to RP Euro 3 to Euro 4 by Eminox
Back To Index
Spreadsheet: 4052f3c6-c29d-4832-b508-336a19985d00
Sheet: Natural Gas

 |  | [NAME] | 20000 | Ft2 |  |  |  |  |  |  | Existing |  | Proposed
 |  |  |  |  |  |  |  |  |  |  | Heat Loss Line |  | Heat Loss Line |  | 0.5 | Est. Savings
 |  | Average kW = | [kWh/Month] / ([Days] x 24 Hr/Day) |  |  |  |  |  |  |  | [NAME]. | Avg. kW | [NAME]. | Avg. kW
 |  |  |  |  |  |  |  |  |  |  | 27 | 7 | 27
 |  | Average Watts/Ft2 = | 1000 W/kW x [[NAME]. kW] / [Sq. Footage] |  |  |  |  |  |  |  | 63 | 1.7
[NAME] |  |  |  |  |  |  |  |  |  |  | Intercept
Natural Gas Bill Information |  |  | Calculated Values |  |  |  |  |  |  |  | Slope
From Date | To Date | Therms /Month | Days | Average Temp | Average kW | Avg. Watts /Ft2 | Month | Year | kWh /Month |  | [NAME] (kW) | Proposed Ductless HP Heat Line (kW) | Predicted Monthly Savings (kWh)
2011-07-19 00:00:00 | 2011-08-18 00:00:00 | 0 |  |  |  |  |  |  | 1750
 | 2011-09-16 00:00:00 | 0 |  |  |  |  |  |  | 2225
 | 2011-10-17 00:00:00 | 22 |  |  |  |  |  |  | 2025
 | 2011-11-15 00:00:00 | 112 |  |  |  |  |  |  | 2125
 | 2011-12-16 00:00:00 | 210 |  |  |  |  |  |  | 2325
 | 2012-01-19 00:00:00 | 257 |  |  |  |  |  |  | 2675
 | 2012-02-15 00:00:00 | 161 |  |  |  |  |  |  | 4725
 | 2012-03-16 00:00:00 | 134 |  |  |  |  |  |  | 5400
 | 2012-04-16 00:00:00 | 71 |  |  |  |  |  |  | 4250
 | 2012-05-18 00:00:00 | 7 |  |  |  |  |  |  | 4425
 | 2012-06-19 00:00:00 | 0 |  |  |  |  |  |  | 3475
 | 2012-07-19 00:00:00 | 0 |  |  |  |  |  |  | 2475
 | 2012-07-19 00:00:00 |  |  |  |  |  |  |  | 1750
 | 2011-02-05 00:00:00 |  |  |  |  |  |  |  | 2175
 | 2011-02-23 00:00:00 |  |  |  |  |  |  |  | 1825
 | 2011-03-30 00:00:00 |  |  |  |  |  |  |  | 2200
 | 2011-04-27 00:00:00 |  |  |  |  |  |  |  | 2050
 | 2011-05-25 00:00:00 |  |  |  |  |  |  |  | 2100
 | 2011-06-23 00:00:00 |  |  |  |  |  |  |  | 2650
 | 2011-07-22 00:00:00 |  |  |  |  |  |  |  | 4125
 | 2011-08-25 00:00:00 |  |  |  |  |  |  |  | 3825
 | 2011-09-29 00:00:00 | 0 |  |  |  |  |  |  | 3825
 | 40780
 | 40815 |  |  |  |  |  | 0.2
 |  |  |  | Avg. Temperature |  | $/Day for Heat | Savings
2011-07-19 00:00:00 | 2011-08-18 00:00:00 | 0 | 30 | 72.37096774193549 | 10.6
2011-08-19 00:00:00 | 2011-09-16 00:00:00 | 0 | 28 | 73.84482758620689 | 10.6
2011-09-17 00:00:00 | 2011-10-17 00:00:00 | 22 | 30 | 58.09677419354838 | 32.1
2011-10-18 00:00:00 | 2011-11-15 00:00:00 | 112 | 28 | 42.48275862068966 | 117.02
2011-11-16 00:00:00 | 2011-12-16 00:00:00 | 210 | 30 | 31.2741935483871 | 196.64
2011-12-17 00:00:00 | 2012-01-19 00:00:00 | 257 | 33 | 28.88235294117647 | 228.75
2012-01-20 00:00:00 | 2012-02-15 00:00:00 | 161 | 26 | 31.74074074074074 | 147.27
2012-02-16 00:00:00 | 2012-03-16 00:00:00 | 134 | 29 | 38.18333333333333 | 124.35
2012-03-17 00:00:00 | 2012-04-16 00:00:00 | 71 | 30 | 45.75806451612903 | 70.87
2012-04-17 00:00:00 | 2012-05-18 00:00:00 | 7 | 31 | 56.796875 | 16.54
2012-05-19 00:00:00 | 2012-06-19 00:00:00 | 0 | 31 | 61.453125 | 10.6
2012-06-20 00:00:00 | 2012-07-19 00:00:00 | 0 | 29 | 73.1 | 10.6
Spreadsheet: 127875d1320667273-rolling-12-week-calculations-sample-workbook-for-12-week-rolling-calculation
Sheet: Sheet1

 |  | 2011-10-07 00:00:00 | 2011-10-14 00:00:00 | 2011-10-21 00:00:00 | 2011-10-28 00:00:00 | 2011-11-04 00:00:00 | 2011-11-11 00:00:00 | 2011-11-18 00:00:00 | 2011-11-25 00:00:00 | 2011-12-02 00:00:00 | 2011-12-09 00:00:00 | 2011-12-16 00:00:00 | 2011-12-23 00:00:00 | 2011-12-30 00:00:00 | 2012-01-06 00:00:00
 |  | 10 | 30 | 52.35 | 36.74 | 102.56 | 89.88 | 10 | 21.25 | 34.65 | 98.99 | 87.75 | 66.39 | 127.89 | 365.42
 |  | 15.72 | 152.75 | 65.78 | 127.35 | 185.25 | 269 | 74.36 | 0 | 52.65 | 199.78 | 59.98 | 69.99 | 172.56 | 99.86
Spreadsheet: ccb94579-7401-478f-a2e6-ca62092e5fd1
Sheet: Sheet1

# | [NAME] | [NAME] | min. | sec. | 2b s. | 2b ú. | 3b s. | 3b ú. | TH s. | TH ú. | DU | DO | DC | Bl | As | M+ | M- | F+ | F- | Val | b.
4 | Mařík | Lukáš | 17 | 2 | 1 | 0 | 6 | 1 | 2 | 0 | 1 | 0 | 1 | 0 | 2 | 2 | 4 | 1 | 3 | -6 | 3
5 | Žampach | Adam | 14 | 39 | 4 | 2 | 1 | 0 | 4 | 2 | 0 | 2 | 2 | 0 | 1 | 0 | 2 | 3 | 2 | 3 | 6
7 | Pištěcký | Antonín | 11 | 20 | 2 | 0 | 1 | 0 | 2 | 2 | 2 | 2 | 4 | 0 | 0 | 0 | 1 | 1 | 0 | 3 | 2
10 | Houška | Pavel | 24 | 17 | 7 | 5 | 1 | 1 | 0 | 0 | 3 | 8 | 11 | 0 | 1 | 1 | 2 | 2 | 2 | 22 | 13
11 | Jiříček | Jan | 8 | 15 | 3 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 4 | 2 | 0 | 1 | 1 | 1 | 1 | 3 | 0
12 | [NAME] | [NAME] | 23 | 45 | 5 | 2 | 3 | 1 | 2 | 1 | 1 | 4 | 5 | 0 | 1 | 2 | 1 | 3 | 1 | 11 | 8
15 | Houška | Jakub | 9 | 50 | 2 | 1 | 0 | 0 | 4 | 3 | 2 | 1 | 3 | 0 | 0 | 0 | 1 | 3 | 2 | 6 | 5
22 | [NAME] | [NAME] | 22 | 57 | 4 | 2 | 2 | 0 | 4 | 3 | 1 | 6 | 7 | 0 | 8 | 2 | 0 | 4 | 2 | 21 | 7
24 | Smeták | Jan | 6 | 38 | 0 | 0 | 0 | 0 | 2 | 0 | 3 | 1 | 4 | 0 | 0 | 0 | 0 | 1 | 0 | 3 | 0
33 | Stria | Luboš | 19 | 29 | 5 | 3 | 2 | 2 | 3 | 2 | 0 | 1 | 1 | 0 | 3 | 0 | 2 | 2 | 1 | 14 | 14
41 | Pomikálek | Tomáš | 20 | 1 | 5 | 3 | 0 | 0 | 6 | 4 | 1 | 4 | 5 | 1 | 1 | 1 | 1 | 5 | 4 | 14 | 10
53 | Alič | Admir | 21 | 42 | 5 | 3 | 3 | 1 | 3 | 2 | 0 | 1 | 1 | 0 | 1 | 1 | 2 | 3 | 2 | 8 | 11
 |  |  | 40 | 0 | 43 | 21 | 19 | 6 | 32 | 19 | 16 | 32 | 48 | 3 | 18 | 10 | 17 | 29 | 20 | 102 | 79
 |  |  |  |  | 49% |  | 32% |  | 59%
Spreadsheet: 599397d1543028521-max-and-minimum-value-for-the-given-2-columns-max-and-minimum-value-for-the-given-2-columns
Sheet: Sheet1

 |  |  |  |  |  | Inputs |  | [NAME] | Min
 | AAA | BBB | 5 |  |  | AAA | BBB | 5 | 25
 | AAA | BBB | 10 |  |  | CCC | DDD | 10 | 30
 | CCC | DDD | 20
 | CCC | DDD | 20
 | AAA | BBB | 10
 | AAA | BBB | 25 |  |  | Maximum and Minium value for the given 2 columns
 | AAA | BBB | 10
 | CCC | DDD | 10 |  |  | Hello Friends
 | CCC | DDD | 20
 | CCC | DDD | 30 |  |  | Please help me to extract the maximum and minimum values from Columns B:D based on the input from cells G3:H4 and need to plot the reslt by fomrula in light yellow cells I3:J4.
 | CCC | DDD | 20
 | CCC | DDD | 20 |  |  | Thanks in advance
Spreadsheet: 61474d1262345493-excel-2007-check-for-text-from-a-list-then-return-a-specific-value-if-matched-book2
Sheet: Meetings

1 | DATE | TIME | MEETING | RACE # | HORSE # | HORSE | STATE | MEETING TYPE | WEEKDAY / [NAME] | ALL / SPECIAL
172 | 19/12/2009 | 11:40 | Dubbo | 1 | 5 | So Light | NSW | Counrty | Weekend
173 | 19/12/2009 | 12:15 | Bungendore | 2 | 7 | Money Dragon | NSW | [NAME] | Weekend
184 | 19/12/2009 | 3:30: | Rosehill | 7 | 2 | Bukefalt | NSW | Metro | Weekend
246 | 22/12/2009 | 1:00: | Gosford | 1 | 9 | Under The Eiffel | NSW | Provincial | Weekday
247 | 22/12/2009 | 1:30: | Doomben | 2 | 15 | Wasted Force | QLD | Metro | Weekday
337 | 28/12/2009 | 1:00: | Eagle Farm | 1 | 1 | Club Ha Ha | QLD | Metro | Weekday
347 | 28/12/2009 | 4:35: | Bendigo | 7 | 7 | Odyssey | VIC | Counrty | Weekday
Spreadsheet: 774279d1648360151-how-to-filter-a-cell-dependant-on-3-other-cells-drawercosting
Sheet: Lists

Brands | Models | Type | Depth | [NAME] | Height | KG |  | Blum | Type |  | AntKG | Ant_H | Antaro |  | [NAME] | Leg_H | Legrabox |  | [NAME] | Met_H | Metabox
 |  |  |  | 300 |  |  |  | Antaro | Inner |  | 30 | C | 270 |  | 40 | C | 270 |  | 25 | C | 270
DTC | Dragon | [NAME] | 300 | 400 | F | 30 |  | Legrabox | [NAME] |  | 65 | M | 300 |  | 70 | F | 300 |  | 30 | F | 300
[NAME] | Impaz |  | 350 | 500 | H | 40 |  | Metabox |  |  |  | MB | 350 |  |  | K | 350 |  | 40 | H | 350
 | Legrabox |  | 400 | 600 | HB | 65 |  |  |  |  |  | MC | 400 |  |  | M | 400 |  | 65 | HB | 400
 | Metabox |  | 450 | 700 | K | 70 |  |  |  |  |  | MD | 450 |  |  | N | 450 |  | 70 | K | 450
 | Smooth |  | 500 | 800 | KB |  |  |  |  |  |  | MDD | 500 |  |  |  | 500 |  |  | KB | 500
 |  |  | 550 | 900 | KD |  |  |  |  |  |  | N | 550 |  |  |  | 550 |  |  | KD | 550
 |  |  | 600 | 1000 | M |  |  |  |  |  |  |  | 600 |  |  |  | 600 |  |  | M | 600
 |  |  | 650 | 1100 | MB |  |  |  |  |  |  |  | 650 |  |  |  | 650 |  |  | MB | 650
 |  |  |  | 1200 | MC |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MC
 |  |  |  |  | MD |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MD
 |  |  |  |  | MDD |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MDD
 |  |  |  |  | N |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N
 |  |  |  |  |  |  |  | DTC |  |  | SmoKG | Smo_H | Smooth |  | DraKG | Dra_H | Dragon
 |  |  |  |  |  |  |  | Dragon |  |  | 40 | C | 270 |  | 40 | C | 270
 |  |  |  |  |  |  |  | Smooth |  |  |  | F | 300 |  |  | F | 300
 |  |  |  |  |  |  |  |  |  |  |  | K | 350 |  |  | K | 350
 |  |  |  |  |  |  |  |  |  |  |  | KD | 400 |  |  | M | 400
 |  |  |  |  |  |  |  |  |  |  |  | M | 450 |  |  | N | 450
 |  |  |  |  |  |  |  |  |  |  |  | MB | 500 |  |  |  | 500
 |  |  |  |  |  |  |  |  |  |  |  | MD | 550 |  |  |  | 550
 |  |  |  |  |  |  |  |  |  |  |  | MDD | 600 |  |  |  | 600
 |  |  |  |  |  |  |  |  |  |  |  | N
 |  |  |  |  |  |  |  | [NAME] |  |  | HarKG | [NAME] | [NAME]
 |  |  |  |  |  |  |  | Impaz |  |  | 30 | H | 270
 |  |  |  |  |  |  |  |  |  |  |  | HB | 300
 |  |  |  |  |  |  |  |  |  |  |  | K | 350
 |  |  |  |  |  |  |  |  |  |  |  | KB | 400
 |  |  |  |  |  |  |  |  |  |  |  | KD | 450
 |  |  |  |  |  |  |  |  |  |  |  | M | 500
 |  |  |  |  |  |  |  |  |  |  |  | MB | 550
 |  |  |  |  |  |  |  |  |  |  |  | MD | 600
 |  |  |  |  |  |  |  |  |  |  |  |  | 650
Spreadsheet: 739691d1625857223-formula-for-progressive-tax-rate-tax-calc-forum-1-
Sheet: tariff

Progressive tax tariff
below or = | 0 | 0
above | 10000 | 0.01
above | 20000 | 0.02
above | 30000 | 0.03
above | 40000 | 0.04
Calc. Example:
income | 10000 | 20000 | 30000 | 40000 | 50000
tax
tax computation manually. this is what the formula should be able to calculate