tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 220842d1363279180-dcount-cannot-find-the-correct-field-tracreviewreport
Sheet: Employee Summary

 | Number of Employee by Sex and Health Plan |  |  |  |  | Criteria
 |  | Female | Male | Total |  | PPOI Females |  |  | PPOI Males
 | PPOI |  |  |  |  | Sex | Health Plan |  | Sex | Health Plan
 | PPOF |  |  |  |  | F | PPOI |  | M | PPOI
 | HMOI
 | HMOF |  |  |  |  | PPOF Females |  |  | PPOF Males
 | None |  |  |  |  | Sex | Health Plan |  | Sex | Health Plan
 | Total |  |  |  |  | F | PPOF |  | M | PPOF
 | Total Salaries by Years Service and Sex |  |  |  |  | HMOI Females |  |  | HMOI Males
 | Years Service | Female | Male |  |  | Sex | Health Plan |  | Sex | Health Plan
 | 0-4 |  |  |  |  | F | HMOI |  | M | HMOI
 | 5-9
 | 10-14 |  |  |  |  | HMOF Females |  |  | HMOI Males
 |  |  |  |  |  | Sex | Health Plan |  | Sex | Health Plan
 |  |  |  |  |  | F | HMOF |  | M | HMOF
 |  |  |  |  |  | None Females |  |  | None Males
 |  |  |  |  |  | Sex | Health Plan |  | Sex | Health Plan
 |  |  |  |  |  | F | None |  | M | None
Spreadsheet: andy_zipper__555__11_19_01LO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | CL Z1 | EXP |  |  | 61.2 | 72.3 | 0.9 | 2001-11-13 14:31:00
 | CL F2 | 17.5 | 245 | 255 | 67.3 | 70 | 0.76 | 2001-11-19 12:03:00
 | CL G2 | 17.5 | 340 | 360 | 61.6 | 65.2 | 0.7 | 2001-11-19 12:03:00
 | CL H2 | 18 | 400 | 415 | 57.8 | 59.9 | 0.67 | 2001-11-19 12:03:00
 | CL J2 | 18 | 430 | 450 | 54 | 56.5 | 0.63 | 2001-11-19 12:03:00
 | CL K2 | 18.5 | 480 | 500 | 52 | 54.2 | 0.62 | 2001-11-19 12:03:00
 | CL M2 | 18.5 | 500 | 520 | 49.7 | 51.7 | 0.59 | 2001-11-19 12:03:00
 | CL N2 | 19 | 515 | 540 | 46.1 | 48.4 | 0.56 | 2001-11-19 12:03:00
 | CL Q2 | 19 | 530 | 560 | 44.6 | 47.1 | 0.55 | 2001-11-19 12:03:00
 | CL U2 | 19 | 535 | 565 | 42.6 | 45 | 0.52 | 2001-11-19 12:03:00
 | [NAME] | 19 | 540 | 570 | 40.8 | 43.1 | 0.5 | 2001-11-19 12:03:00
 | CL X2 | 19 | 540 | 570 | 39.1 | 41.3 | 0.48 | 2001-11-19 12:03:00
 | [NAME] | 19.5 | 550 | 560 | 37.4 | 38.1 | 0.46 | 2001-11-19 12:03:00
 | CL M3 |  |  |  | 30.6 | 32.6 | 0.4 | 2001-11-19 10:15:00
 | CL Z3 |  |  |  | 27.1 | 29.1 | 0.35 | 2001-11-19 10:15:00
Spreadsheet: 06b21780-7f4d-45ab-b85a-7b8df3e373ff
Sheet: Sheet1

2012 ERIE COUNTY BOARD OF ELECTIONS OFFICES TO BE ELECTED      July 30, 2012 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
elections.erie.gov
OFFICE |  | TERM |  | IN PLACE OF
Electors for President |  | 4 year |  | [NAME] (D)
Electors for Vice-President |  | 4 year |  | [NAME] (D)
United States Senator |  | 6 year |  | [NAME] (D)
REDISTRICTED - 2012
Representative in Congress - 26th District |  | 2 year
Representative in Congress - 27th District |  | 2 year
State Senator - 59th District |  | 2 year
State Senator - 60th District |  | 2 year
State Senator - 61st District |  | 2 year
State Senator - 63rd District |  | 2 year
Member of Assembly - 140th District |  | 2 year
Member of Assembly - 141st District |  | 2 year
Member of Assembly - 142nd District |  | 2 year
Member of Assembly - 143rd District |  | 2 year
Member of Assembly - 144th District |  | 2 year
Member of Assembly - 145th District |  | 2 year
Member of Assembly - 146th District |  | 2 year
Member of Assembly - 147th District |  | 2 year
Member of Assembly - 149th District |  | 2 year
County
Family Court Judge |  | 10 year |  | [NAME] (R)
District Attorney |  | 4 year |  | [NAME] (D)
County Comptroller |  | To Fill Vacancy |  | [NAME] (D)
City of Buffalo
City Court Judge |  | 10 year |  | [NAME] (D)
Council Member - South District |  | To Fill Vacancy |  | [NAME] (D)
City of Lackawanna
Councilman - 2nd Ward |  | To Fill Vacancy |  | [NAME] (D)
Councilman - 3rd Ward |  | To Fill Vacancy |  | Vacant | certificate of nominations
 |  |  |  |  | to be filed in September
Town of Boston
[NAME] |  | To Fill Vacancy |  | [NAME] (D)
Town of Clarence
Town Justice |  | 4 year |  | [NAME] (R)
Town of Colden
Town Justice |  | 4 year |  | [NAME] (C)
Town Superintendent of Highways-TFV |  | To Fill Vacancy |  | [NAME]
Town of Collins
Town Justice |  | 4 year |  | [NAME] (D)
Town of Concord
[NAME] |  | To Fill Vacancy |  | [NAME] (R)
Town of Grand Island
Councilman |  | To Fill Vacancy |  | [NAME]  (C)
Town of Wales
Town Justice |  | 4 year |  | [NAME] (R)
Assessor |  | To Fill Vacancy |  | [NAME] (R)
Party Positions (Primary Election ONLY)
Member of State Committee | Democratic, Conservative, Working Families, Independence and Green
Delegate and Alternate Delegate to the 8th District Judicial Convention |  |  |  | All Parties
Member of County Committee | Democratic, Republican, Conservative, Independence and Green
Spreadsheet: 545305d1509393896-summarizing-a-list-of-vendors-test-expense-tracking-sheet
Sheet: Expense Tracking Sheet

Test Project Expense Tracking Sheet
Expense Date | Vendor | Amount | Payment Method | Location | Description | Expense Code | Verified? | Receipt
2017-10-24 00:00:00 | Vendor A | 5000 | AK Amex | A05 | Screws | 510040 | yes
2017-08-27 00:00:00 | Vendor B | 38.97 | Check | Entrance | Rope | 510050 | yes
2017-10-24 00:00:00 | Vendor A | 15000 | Invoice | A25 | Bricks | 510020 | yes
2017-10-24 00:00:00 | Vendor A | 18000 | Check | A31 | Screws | 510051 | yes
2017-10-24 00:00:00 | Vendor C | 7000 | AK Amex | D25 | Food | 510051 | yes
2017-10-03 00:00:00 | Vendor C | 38.94 | [NAME] | P04 | Uber | 510051 | yes
2017-10-03 00:00:00 | Vendor D | 87.93 | [NAME] | Sitewide | Lumber | 510410 | yes
2017-10-24 00:00:00 | Vendor E | 1689 | Check | A01 | Lumber | 502304 | yes
2017-10-24 00:00:00 | Vendor C | 536 | Invoice | A07 | Bolts | 678256 | yes
2017-10-24 00:00:00 | Vendor D | 445 | Petty Cash | A26 | Paint | 510020 | no
2017-10-24 00:00:00 | Vendor D | 1863 | Petty Cash | B26 | Tools | 510051 | yes
2017-10-24 00:00:00 | Vendor A | 467 | DH Visa | C32 | Screws | 513654 | yes
2017-10-18 00:00:00 | Vendor B | 50 | Check | Resturaunt | Lumber | 510410 | yes
2017-10-03 00:00:00 | Vendor E | 5 | Petty Cash | A04 | Hardware | 510051 | yes
Spreadsheet: 593364d1539104432-powerpivot-lookup-table-to-create-link-between-tables-simplified-data-set
Sheet: Data

 | Unique | Not |  | Not | Not |  | Unique | Not
 | ScheduleTag | Control Room |  | ScheduleTag | TNumber |  | TNumber | Complexity
 | SPEC1 | Unit 1 |  | SPEC1 | ST001 |  | ST001 | 3
 | SPEC2 | Unit 2 |  | SPEC2 | ST001A |  | ST001A | 1
 | [NAME] | Unit 1 |  | [NAME] | ST002A |  | ST002A | 1
 | [NAME] | Unit 3 |  | [NAME] | ST003 |  | ST003 | 2
 |  |  |  | SPEC1 | ST022A |  | ST022A | 2
 |  |  |  | SPEC2 | ST043 |  | ST043 | 3
 |  |  |  | [NAME] | ST000B |  | ST000B | 1
 |  |  |  | [NAME] | ST060 |  | ST060 | 1
 |  |  |  | SPEC2 | ST009 |  | ST009 | 1
 |  |  |  | SPEC2 | ST002A
 |  |  |  | [NAME] | ST022A
 |  |  |  | [NAME] | ST043
 |  |  |  | TINT2 | ST000B
 |  |  |  | TINT2 | ST060
 |  |  |  | SPEC1 | ST001A
 |  |  |  | [NAME] | ST003
 |  |  |  | [NAME] | ST022A
 |  |  |  | SPEC1 | ST043
 |  |  |  | SPEC2 | ST000B
 |  |  |  | [NAME] | ST060
 |  |  |  | [NAME] | ST009
 |  |  |  | SPEC2 | ST001
 |  |  |  | SPEC1 | ST002A
 |  |  |  | SPEC2 | ST022A
 |  |  |  | [NAME] | ST043
 |  |  |  | [NAME] | ST000B
 |  |  |  | TINT2 | ST000B
Spreadsheet: 269829d1381301915-excel-conditional-functions-engineering-model-model
Sheet: Specifications

 | Model for Midas Gold Pty Ltd Mine Lift Project - Specifications
 | Total Passengers | 300 |  |  | Cost of Steel Mesh ($/m²) | 200
 | Single Passenger Mass (kg) | 100 |  |  | Cost of W50 Winch ($) | 12250
 | Time Limit (mins) | 15 |  |  | Cost of W80 Winch ($) | 17150
 | Time for Entry/Exit (mins) |  |  |  | Cost of W100 Winch ($) | 24000
 | Passenger [NAME] (m) | 2.2 |  |  | Cost of W150 Winch ($) | 33600
 | Cage Wall Thickness (m) | 0.02 |  |  | Cost of W200 Winch ($) | 47000
 | Steel Mesh (20%) | 0.2 |  |  | Cost of Steel Rope ($/m) | 6
 | Density of Steel (kg/m³) | 7830
 | Area Required for 1 Passenger (m²) | 0.25
 | Height of Shaft (m) | 60
 | Ground to Winch (m) | 10
 | Winch Radius (m) | 0.25
 | Maximum Budget ($) | 40000
 | Top Speed | 5
 | Winch Efficency (%) | 70
 | Steel Rope Breaking Stress (Mpa) | 700
 | Steel Rope Safety Factor | 8
 | Diameter of Steel Rope | 16
 | Gravity | 9.81
Spreadsheet: 797489d1663921460-sum-of-range-defined-by-value-of-another-cell-question-1
Sheet: Sheet1

 |  | workdays / step | 4 | 7 | 2 | 8 | 23 | 6 | 15 | 5 | 3 | 1
number | steps to go | amount | step 1 | step 2 | step 3 | step 4 | step 5 | step 6 | step 7 | step 8 | step 9 | step 10 |  | time left | expected month
1 | 2 | 2 |  |  |  |  |  |  |  |  |  |  |  | 4
2 | 4 | 3 |  |  |  |  |  |  |  |  |  |  |  | 24
3 | 4 | 5 |  |  |  |  |  |  |  |  |  |  |  | 24
4 | 6 | 3 |  |  |  |  |  |  |  |  |  |  |  | 53
5 | 10 | 6 |  |  |  |  |  |  |  |  |  |  |  | 74
6 | - | 6 |  |  |  |  |  |  |  |  |  |  |  | -
 |  |  | sep | oct | nov | dec | jan | feb | [NAME] | apr | may
 | amount per month |  | 2 | 8 | 0 | 3 | 6 | NA() | NA() | NA() | NA()
Spreadsheet: andy_zipper__168__DYNEGY-ICE VOL Apr12
Sheet: ICE-ENA

Enron North America
Activity on ICE
UOM | Deals | Volume
MMBtus
bbl
 |  |  |  |  |  |  | START | END
Enron North America Corp.
Commodity Type:  All
Instruments:  All
Trade Dates:  Apr-12-01 thru Apr-12-01
Trade Date | Deal ID | Leg ID | B/S | Product | Hub | Strip | START | END | Option | Strike | Style | Counterparty | Price | Price Units | Qty Per Period | Periods | Total Quantity | Qty Units | Trader
Apr-12-01 | 588924386 |  | Bought | NG Fin, FP for LD1 | [NAME] | Cal 02 | Jan-01-02 | Dec-31-02 |  |  |  | AEP Energy Services, Inc. | 4.87 | USD / MMBtu | 5000 | Daily | 1825000 | MMBtus | [NAME], J
Apr-12-01 | 150979829 |  | Bought | NG Fin, FP for LD1 | [NAME] | Cal 03 | Jan-01-03 | Dec-31-03 |  |  |  | Duke Energy Trading and Marketing LLC | 4.29 | USD / MMBtu | 2500 | Daily | 912500 | MMBtus | [NAME], J
Apr-12-01 | 100140314 |  | Bought | NG Fin BS, LD1 for IF | CNG-SP | 2001-05-01 00:00:00 | May-01-01 | May-31-01 |  |  |  | Aquila Risk Management Corp. | 0.335 | USD / MMBtu | 5000 | Daily | 155000 | MMBtus | [NAME], G
Apr-12-01 | 707159713 |  | Sold | NG Fin BS, LD1 for IF | Perm | 2001-05-01 00:00:00 | May-01-01 | May-31-01 |  |  |  | AEP Energy Services, Inc. | -0.055 | USD / MMBtu | 10000 | Daily | 310000 | MMBtus | [NAME], G
Apr-12-01 | 848925321 |  | Bought | NG Fin BS, LD1 for IF | [NAME] (NY) | Nov01-Mar02 | Nov-01-01 | Mar-31-02 |  |  |  | AEP Energy Services, Inc. | 1.7 | USD / MMBtu | 5000 | Daily | 755000 | MMBtus | [NAME], G
Apr-12-01 | 119263008 |  | Bought | NG Fin BS, LD1 for IF | [NAME] (NY) | Nov01-Mar02 | Nov-01-01 | Mar-31-02 |  |  |  | AEP Energy Services, Inc. | 1.71 | USD / MMBtu | 5000 | Daily | 755000 | MMBtus | [NAME], G
Apr-12-01 | 775702688 |  | Bought | NG Fin BS, LD1 for IF | Waha | [NAME] | May-01-01 | Oct-31-01 |  |  |  | Axia Energy, LP | 0.0325 | USD / MMBtu | 5000 | Daily | 920000 | MMBtus | [NAME], G
Apr-12-01 | 126764185 |  | Bought | NG Fin BS, LD1 for IF | Waha | [NAME] | May-01-01 | Oct-31-01 |  |  |  | AEP Energy Services, Inc. | 0.035 | USD / MMBtu | 10000 | Daily | 1840000 | MMBtus | [NAME], G
Apr-12-01  Deals
Spreadsheet: 35519d1233135757-excel-2007-how-to-copy-conditional-formating-golf-2009
Sheet: Per-Aage

 | Per-Aage
 | Windsor
 | Hull: | Par: | Beste: | Snitt: |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |  | Par | [NAME] | [NAME] | Eagel | Annet
 | Hull 1 | 4
 | Hull 2 | 4
 | Hull 3 | 5
 | Hull 4 | 3
 | Hull 5 | 5
 | Hull 6 | 4
 | Hull 7 | 4
 | Hull 8 | 3
 | Hull 9 | 4
 | Første 9
 | Hull 10 | 4
 | Hull 11 | 4
 | Hull 12 | 5
 | Hull 13 | 3
 | Hull 14 | 4
 | Hull 15 | 5
 | Hull 16 | 4
 | Hull 17 | 3
 | Hull 18 | 4
 | Siste 9
 | Total
 | Muthaiga
 | Hull: | Par: | Beste: | Snitt: |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |  | Par | [NAME] | [NAME] | Eagel | Annet
 | Hull 1 | 4
 | Hull 2 | 3
 | Hull 3 | 4
 | Hull 4 | 5
 | Hull 5 | 3
 | Hull 6 | 4
 | Hull 7 | 5
 | Hull 8 | 4
 | Hull 9 | 4
 | Første 9
 | Hull 10 | 5
 | Hull 11 | 3
 | Hull 12 | 4
 | Hull 13 | 3
 | Hull 14 | 4
 | Hull 15 | 4
 | Hull 16 | 3
 | Hull 17 | 4
 | Hull 18 | 5
 | Siste 9
 | Total
Spreadsheet: benjamin_rogers__1185__United American Energy 02-09-00
Sheet: Depreciation

DEPRECIATION SCHEDULE
('000 $)
US FEDERAL TAX DEPRECIATION & AMORTIZATION
 | Years
Plant & Equipment - MACRS |  |  | 0.05 | 0.095 | 0.0855 | 0.077 | 0.0693 | 0.0623 | 0.059 | 0.0591 | 0.059 | 0.0591 | 0.059 | 0.0591 | 0.059 | 0.0591 | 0.059 | 0.0295 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Start-Up Costs - SL |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Transaction Costs - SL
Plant & Equipment - MACRS
Start-Up Costs - SL
Transaction Costs - SL
Total Beginning Book Value
Ending Value of Assets
STATE TAX DEPRECIATION & AMORTIZATION
 | Years
Plant & Equipment - MACRS
Start-Up Costs - SL
Transaction Costs - SL
Plant & Equipment - MACRS
Start-Up Costs - SL
Transaction Costs - SL
Total Beginning Book Value
Ending Value of Assets
BOOK DEPRECIATION & AMORTIZATION
 | Years | Residual
Plant & Equipment - MACRS
Start-Up Costs - SL
Transaction Costs - SL
Plant & Equipment - MACRS
Start-Up Costs - SL
Transaction Costs - SL
Total Beginning Book Value
Ending Book Value of Assets
Spreadsheet: 199548d1355248200-finding-row-on-matrix-matching-3-criteria-and-get-a-result-hour-tigeravatar-example-for-moonalert
Sheet: Sheet1

Date/Time | Event | Name |  | Search For…
2012-11-08 07:26:16 | Check-In | [NAME] |  | Name | [NAME]
2012-11-08 13:23:58 | Check-Out | [NAME] |  | Date | 2012-11-08 00:00:00
2012-11-08 13:24:01 | Check-In | [NAME] |  | Event | Check-In
2012-09-27 07:34:13 | Check-In | [NAME] |  | Hour | 14:00:00
2012-09-27 17:35:31 | Check-Out | [NAME]
2012-09-28 07:10:16 | Check-In | [NAME] |  | Result
2012-09-28 17:34:40 | Check-Out | [NAME]
Spreadsheet: 268377d1380609885-dsum-add-up
Sheet: Sheet1

UNIT 2 - SCRAP DETAILS |  |  |  |  |  |  | Poly | Paper | Foil Poly | Bare Foil
 |  |  |  |  |  | Slitter 1
Date | Machine | Scrap Type | Product Name | Quantity |  | [NAME]
2013-09-26 00:00:00 | [NAME] | Poly | [NAME] | 5 |  | Slitter 3
2013-09-26 00:00:00 | Slitter 1 | Poly | [NAME] | 40.2 |  | [NAME]
2013-09-26 00:00:00 | [NAME] 9 | Poly | [NAME] | 13.6 |  | Slitter 5
2013-09-26 00:00:00 | Slitter 5 | Paper | Boomer | 32.8 |  | [NAME] 6
2013-09-26 00:00:00 | EX 1 | Paper |  | 46.2 |  | Slitter 7
2013-09-26 00:00:00 | EX 1 | Paper |  | 21.8 |  | [NAME] 8
2013-09-26 00:00:00 | Doctor 5 | Paper | Boomer | 83 |  | Doctor 1
2013-09-26 00:00:00 | C5 | Foil Poly | BR Foil | 14.4 |  | Doctor 2
2013-09-26 00:00:00 | [NAME] | Poly | [NAME] | 19 |  | Doctor 3
2013-09-26 00:00:00 | [NAME] 6 | Poly | Zinetac | 26.4 |  | Doctor 4
2013-09-26 00:00:00 | Slitter 1 | Poly | [NAME] | 25.6 |  | Doctor 5
2013-09-26 00:00:00 | Slitter 5 | Paper | Boomer | 27.2 |  | EX 1
2013-09-26 00:00:00 | P1 | Paper | Boomer | 133.8 |  | P1
2013-09-26 00:00:00 | Slitter 3 | Bare Foil | Cadbury Silk | 34.6 |  | p2
Spreadsheet: 169822d1343068069-help-in-changing-4-currency-rates-in-real-time-currency1-1-
Sheet: Dirham

a | 1 |  |  | 0 |  |  |  | 69 | 0.059 |  |  | 0 |  |  |  |  | 106.3 | 0.051 |  |  | 1 |  |  |  |  | 160 | 0.044 |  |  |  |  |  |  |  | 250 | 0.039 |  |  | 1 |  |  |  |  | 195 | 0.036 |  |  | 1 |  |  |  |  | 300 | 0.033 |  |  | 1
b | 2 |  |  | 0 |  |  |  | 138 | 0.118 |  |  | 0 |  |  |  |  | 212.5 | 0.103 |  |  | 1 |  |  |  |  | 320 | 0.088 |  |  |  |  |  |  |  | 500 | 0.078 |  |  | 1 |  |  |  |  | 390 | 0.073 |  |  | 1 |  |  |  |  | 600 | 0.066 |  |  | 1
c | 3 |  |  | 0 |  |  |  | 276 | 0.235 |  |  | 0 |  |  |  |  | 425.2 | 0.204 |  |  | 1 |  |  |  |  | 640 | 0.175 |  |  |  |  |  |  |  | 1000 | 0.156 |  |  | 1 |  |  |  |  | 780 | 0.145 |  |  | 1 |  |  |  |  | 1200 | 0.132 |  |  | 1
d | 4 |  |  | 0 |  |  |  | 552 |  |  |  | 0 |  |  |  |  | 850.4 | 0.408 |  |  | 1 |  |  |  |  | 1280 |  |  |  |  |  |  |  |  | 2000 | 0.312 |  |  | 1 |  |  |  |  | 1560 |  |  |  | 1 |  |  |  |  | 2400 | 0.264 |  |  | 1
e | 5 |  |  | 1 |  |  |  | 69 | 0.039 |  |  | 1 |  |  |  |  | 106.3 | 0.031 |  |  | 1 |  |  |  |  | 160 | 0.024 |  |  |  |  |  |  |  | 250 | 0.019 |  |  | 1 |  |  |  |  | 195 | 0.016 |  |  | 1 |  |  |  |  | 300 | 0.013 |  |  | 1
f | 6 |  |  | 0 |  |  |  | 138 | 0.078 |  |  | 1 |  |  |  |  | 212.5 | 0.063 |  |  | 1 |  |  |  |  | 320 | 0.048 |  |  |  |  |  |  |  | 500 | 0.038 |  |  | 1 |  |  |  |  | 390 | 0.032 |  |  | 1 |  |  |  |  | 600 | 0.026 |  |  | 1
g | 7 |  |  | 0 |  |  |  | 276 | 0.156 |  |  | 1 |  |  |  |  | 425.2 | 0.124 |  |  | 1 |  |  |  |  | 640 | 0.096 |  |  |  |  |  |  |  | 1000 | 0.076 |  |  | 1 |  |  |  |  | 780 | 0.064 |  |  | 1 |  |  |  |  | 1200 | 0.052 |  |  | 1
h | 8 |  |  | 0 |  |  |  | 552 | 0.312 |  |  | 1 |  |  |  |  | 850.4 | 0.258 |  |  | 1 |  |  |  |  | 1280 | 0.192 |  |  |  |  |  |  |  | 2000 | 0.152 |  |  | 1 |  |  |  |  | 1560 | 0.128 |  |  | 1 |  |  |  |  | 2400 | 0.104 |  |  | 1
i | 9 |  |  | 1 |  |  |  | 23 | 0.018 |  |  | 1 |  |  |  |  | 35 | 0.018 |  |  | 1
j | 10 |  |  | 1 |  |  |  | 23 | 0.012 |  |  | 1 |  |  |  |  | 35 | 0.012 |  |  | 1
k | 11 |  |  | 0 |  |  |  | 353 | 0.29 |  |  | 1 |  |  |  |  | 548 | 0.245 |  |  | 1
l | 12 |  |  | 0 |  |  |  | 706 | 0.58 |  |  | 1 |  |  |  |  | 1096 | 0.49 |  |  | 1
m | 13 |  |  | 0 |  |  |  | 1412 | 1.16 |  |  | 1 |  |  |  |  | 2192 | 0.98 |  |  | 1
n | 14 |  |  | 0
o | 15 |  |  | 0
p | 16 |  |  | 0
q | 17 |  |  | 0 |  |  |  | 178 | 0.165 |  |  | 1 |  |  |  |  | 273 | 0.153 |  |  | 1
r | 1.14 |  |  | 0 |  |  |  | 712 | 0.66 |  |  | 1 |  |  |  |  | 1092 | 0.612 |  |  | 1
 | 18
s | 19 |  |  | 0
t | 20 |  |  | 0
u | 21 |  |  | 0 |  |  |  | 178 | 0.165 |  |  | 1 |  |  |  |  | 2225 | 0.922 |  |  | 1
v | 22 |  |  | 0 |  |  |  | 712 | 0.66 |  |  | 1 |  |  |  |  | 2710 | 1.114 |  |  | 1
w | 23 |  |  | 0
x | 34 |  |  | 0
y | 35 |  |  | 0 |  |  |  | 2410 | 1.534 |  |  | 1 |  |  |  |  | 3700 | 1.534 |  |  | 1
z | 26 |  |  | 0
Spreadsheet: 839635d1692121365-multi-level-attendance-tracking-based-on-another-document-atw
Sheet: Sheet1

 | Month | Lessons per week | Day 1 | Day 2 | Course | Name | [NAME] 1 | [NAME] 2 | [NAME] 3 | [NAME] 4 | [NAME] 5 | [NAME] 6 | [NAME] 7 | [NAME] 8 | [NAME] 9 | [NAME] 10 | SUM
 | August | 2 | MON | WED | Group 1 | Planned Dates | sequence of dates based on cells A - E
 | August |  |  |  | Group 1 | Real Dates | 8.8. | 10.8. | 13.8. | 15.8. | 20.8. | 24.8.
 | August |  |  |  | Group 1 | Student 1 | A |  | A |  | A
 | August |  |  |  | Group 1 | Student 2 |  | A | A | A |  | A
 | August |  |  |  | Group 1 | Student 3 | A |  |  | A |  | A
 | August | 1 | TUE |  | Group 2 | Planned Dates | sequence of dates based on cells A - E
 | August |  |  |  | Group 2 | Real Dates | 8.8. | 10.8. | 13.8. | 15.8. | 20.8. | 24.8.
 | August |  |  |  | Group 2 | Student 4 | A |  | A |  | A
 | August |  |  |  | Group 2 | Student 5 |  | A | A | A |  | A
 | August |  |  |  | Group 2 | Student 6 | A |  |  | A |  | A
Spreadsheet: 62751d1263748659-sum-of-cells-with-multiple-criteria-example-2
Sheet: Sheet1

TYPE |  |  | LENGTH |  | CWP
POWER |  |  | 35 |  | 25M32
POWER |  |  | 45 |  | 26B12
POWER |  |  | 95 |  | 25D12
POWER |  |  | 78 |  | 27A13
POWER |  |  | 87 |  | 25M32
POWER |  |  | 48 |  | 26B12
INST |  |  | 87 |  | 25D12
INST |  |  | 96 |  | 27A13
INST |  |  | 52 |  | 25M32
INST |  |  | 14 |  | 26B12
INST |  |  | 87 |  | 25D12
INST |  |  | 63 |  | 27A13
INST |  |  | 59 |  | 25H36
INST |  |  | 74 |  | 25H12
Spreadsheet: 821092d1678441984-vba-code-compiles-data-in-new-sheet-except-if-there-is-only-one-line-of-data-road-speed-limit-violations-new-_2023-03-10_0728
Sheet: CC6 CA25753

 |  |  |  | Road Speed Limit Violations
 |  |  |  | Time frame: Manual | Resource type: 90 Resources In 3 groups | Duration: All
 |  |  |  | Created: 10/03/2023 07:28:13 | Account: Hylton Ross Tours (Pty) Ltd
 | CC6 CA25753 Report Totals for 03/03/2023 06:30:00 - 10/03/2023 06:15:00 (UTC+02:00) Harare, Pretoria
 | No. of Events |  |  |  |  |  |  | [NAME] |  |  |  |  | Total Duration
 | 4 |  |  |  |  |  |  | 76km/h |  |  |  |  | 00h00m18s
 | Start Time |  |  |  | Resource |  | Actual Speed |  | RSS Limit | Duration | Location
 | 2023-03-09 08:00:33.540000 |  |  |  | CC6 CA25753 |  | 67 |  | 60 | [NAME] | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-09 08:02:51.760000 |  |  |  | CC6 CA25753 |  | 66 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-09 10:33:37.820000 |  |  |  | CC6 CA25753 |  | 66 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
 | 2023-03-09 10:45:21.420000 |  |  |  | CC6 CA25753 |  | 76 |  | 60 | 00:00:00 | Voortrekker Road (R102), Woodstock, Cape Town, Western Cape
Spreadsheet: 697997d1601658790-return-a-value-in-a-table-bornemann-atex-software-rev-2-1-
Sheet: W07DMBU

 | Yelow Cells require an action or input from the user
 | [NAME]
 | [NAME] | Face ID | Face OD |  | Pressure | Speed | Calculated Sliding Velocity |  | MFD |  | PV | [NAME] | [NAME] | Face Material | Table to use | SFTR | Total Temp | T Rating | Derated Temp | Successful ATEX ? |  |  | 0 | 5 | 10 | 15 | 20 | 25 |  |  | Row
 | [NAME] |  |  |  | Bar (g) | RPM | ms-1 |  |  |  | Bar/m/s | Deg C |  |  |  | From Tables | Deg C |  | Deg C |  |  |  | Table 1 - Aqueous Car Vs SiC |  |  |  |  |  |  |  | Column
 | 50 |  |  |  | 11 | 2000 |  |  |  |  |  | 20 | Aqueous | Carbon Vs SiC | 1 |  |  | T3 |  |  |  |  |  | Pressure
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Column1 | Up to 5 | Up to 10 | Up to15 | Up to 20 | Up to 25 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <=1 | 20 | 20 | 20 | 20 | 20 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <=5 | 20 | 20 | 20 | 22 | 23 | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <=10 | 20 | 22 | 25 | 27 | 30 | 10
 | Value inputted above should |  |  |  |  |  | Value shown above should be looked |  |  |  |  |  |  |  |  | Enter into this cell the result from the correct table |  |  |  |  |  |  | <=15 | 21 | 25 | 29 | 33 | 37 | 15
 | be looked up in the correct |  |  |  |  |  | up in the same colour in the table |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <=20 | 22 | 27 | 33 | 38 | 43 | 20
 | table
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Table 2 - Aqueous Car Vs Steel
 | The above calculations are based on Carbon Vs Silicon Carbide face materials. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pressure
 | All seals need to be set as per AES setting lengths and published data. Any over compression will result in higher SFTR results |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Column1 | Up to 5 | Up to 10 | Up to15 | Up to 20 | Up to 25
 | All components seals are classed as machinery elements and no specific ATEX certification is required or indeed provided. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <=1 | 45 | 45 | 45 | 45
 | The calculation assumes that PV of the sliding materials will not be exceeded. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <=5 | 45 | 45 | 45 | 45
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <=10 | 45 | 45 | 45 | 45
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <=15 | 45 | 45 | 45
 | AESSEAL plc |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <=20 | 45 | 45
 | 2020-09-24 00:00:00