tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 886695d1736794166-date-of-6th-last-occurrence-mals
Sheet: Sheet1

Date | Malfunctions
2025-01-01 00:00:00 | 2
2025-01-02 00:00:00 | 1 |  | Date of 6th Last Malfunction
2025-01-03 00:00:00 | 1 |  | Desired Result | 2025-01-05 00:00:00
2025-01-04 00:00:00
2025-01-05 00:00:00 | 3
2025-01-06 00:00:00
2025-01-07 00:00:00
2025-01-08 00:00:00 | 2
2025-01-09 00:00:00
2025-01-10 00:00:00 | 2
2025-01-11 00:00:00
2025-01-12 00:00:00 | 1
2025-01-13 00:00:00
2025-01-14 00:00:00
Spreadsheet: 715439d1611703112-sum-only-those-numbers-with-adjacent-number-0-formula-trouble
Sheet: Sheet1

4.96 | 0 | Excluded from sum
20.09 | 0 | Excluded from sum
18 | 0.93 | Included in sum
1.24 | 0 | Excluded from sum
3.89 | 0 | Excluded from sum
13.59 | 0 | Excluded from sum
20.54 | 0 | Excluded from sum
7.66 | 0 | Excluded from sum
5.17 | 0 | Excluded from sum
4.24 | 1 | Included in sum
6.04 | 0 | Excluded from sum
7.57 | 0 | Excluded from sum
11.24 | 0 | Excluded from sum
7.12 | 0 | Excluded from sum
6.43 | 0 | Excluded from sum
5.4 | 0 | Excluded from sum
4.24 | 1 | Included in sum
8.75 | 0 | Excluded from sum
7 | 0.72 | Excluded from sum
 | Total I need to get
Spreadsheet: 135061d1325793246-generate-warning-if-values-not-met-daily-timesheet-v2
Sheet: staff

NAME | No | GRADE | PAY AVERAGE | TEAM LEADERS |  | MACHINES | SMV
ABBOT A | 1 | A | 10 |  |  | 1 | 0.3977
BARRY B | 2 | A | 10 |  |  | 2 | 0.367
CAZIZ C | 3 | A | 10 |  |  | 3 | 0.61
DELTA D | 4 | A | 10 |  |  | 4 | 0.367
ECHO E | 5 | A | 10
FINN F | 6 | A | 10
GRACE G | 7 | A | 10
HOOPER H | 8 | A | 10 |  |  |  | SHIFT | SHIFT | SHIFT
INNIS I | 9 | A | 10 |  |  | GRADES | 6-2 | 2-10 | 10-6
JEEP J | 10 | A | 10
KELLY K | 11 | A | 10 |  |  | A | 0.1713 | 0.1713 | 0.1799
LIMA L | 12 | A | 10 |  |  | B | 0.1596 | 0.1596 | 0.1676
MOOR M | 13 | A | 10 |  |  | C | 0.1369 | 0.1369 | 0.1437
NORIE N | 14 | A | 10
OTTER O | 15 | A | 10
PETTLE P | 16 | A | 10
QUEEN Q | 17 | A | 10 |  |  | BASIC TIME RATE | 6.58 | 6.58 | 6.91
[NAME] R | 18 | A | 10
STONE S | 19 | A | 10
TAMMY T | 20 | A | 10
Spreadsheet: 270591d1381534026-circular-reference-help-sola-salon-ml-model
Sheet: Unit Assumptions

 |  |  |  |  | Assumptions
 | [NAME] |  |  |  |  |  | Studio Count and Revenue
 |  | [NAME] (Sqft.) | 5500 |  |  |  | % of Studio mix | Studios | [NAME] Feet/Studio | Sqr. Feet | Rent | Weekley Revenue
 |  | Common Area Usage | 0.4 |  |  |  | 0.7
 |  | [NAME] | 100 |  |  |  | 0.15 |  | 150
 |  | Number of Studios |  |  |  |  | 0.15 |  | 200
 |  | Build Out Cost per Studio
 |  | Total Build Out Cost |  | Cost per sq. foot | 132
 |  | TI Allowance PSF | 25 |  |  |  |  |  |  | Gross Potential Rent
 |  | Depreciation Years | 20
 |  | Monthly Dep
 | Revenue |  |  |  |  |  | Capital
 |  | Weekly Rent of Standard Suite | 225 | Ave. Monthly Rent per Studio |  |  |  |  | Sources |  |  | Capital Required
 |  | Annual Rent increase | 0.03 |  |  |  | Equity/Cash | 0.4 | Equity/Cash |  |  | Build Out
 |  | Lease Up per Month | 3 |  |  |  | Debt | 0.6 | Debt |  |  | TI Allowance
 |  | [NAME] |  |  |  |  |  |  | Total |  |  | Franchise Fee
 |  |  |  |  |  |  |  |  |  |  |  | Working Capital
 | Operating Expenses |  |  |  |  |  |  |  | Interest Rate | 0.065 |  | Total
 |  | Annual Lease Cost PSF | 25 |  |  |  |  |  | Term (months) | 120
 |  | Utilities | 25000 |  |  |  |  |  | Monthly Payment
 |  | Repairs and Maintenance | 10000
 |  | Cleaning/Maintenance | 8000
 |  | Insurance | 4000
 |  | Personal Property Tax | 5000
 |  | Accounting | 3000
 |  | Royalty Payment for Franchisees | 0.06
 |  | Royalty Payment for Corporate Stores | 0
 |  | Other | 5000
 |  | On going advertising | 5000
 |  | Annual Inflation | 0.03
Spreadsheet: 797992d1664266778-percentage-calculation-from-negative-numbers-book2
Sheet: Sheet1

 |  |  | QUESTION 1: |  | WANTED OUTCOME
 |  |  | Percantage | 0.1
 |  |  | TOTAL of certain cells | -14241
 |  |  | Output |  | <- output should be "0" , if the output is negative.
 |  |  | QUESTION 2: |  | WANTED OUTCOME
 |  |  | Number 1 in a cell: | -65232 | if the number is negative
 |  |  | Percantage | 0.1
 |  |  | Outcome: |  | is the formula correct, on this row???
Spreadsheet: 852363d1702424017-help-with-dependant-validation-sample
Sheet: Sheet1

 | This table allows someone to select a dropdown in "Firm" column. The list would be limited to "Acoustical Consultants" in cell C1 for example. Them the "Contact" drop down would be limited to people within that firm. |  |  |  |  |  |  |  |  |  |  | This table would include all firms and all contacts.
 | Role | Firm | Contact |  |  |  |  |  |  |  |  | Role | Firm | Contact
 | Acoustical Consultant | SLR Consulting | [NAME] |  |  |  |  |  |  |  |  | Acoustical Consultant | SLR Consulting | [NAME]
 | Archeology Consultant |  |  |  |  |  |  |  |  |  |  | Acoustical Consultant | Veneklasen & Associates | Jan
 | Architect of Record |  |  |  |  |  |  |  |  |  |  | Acoustical Consultant | [NAME] | [NAME]
 | BMCS Consultant |  |  |  |  |  |  |  |  |  |  | Archeology Consultant | SCB | [NAME]
 | Civil Engineer |  |  |  |  |  |  |  |  |  |  | Architect of record | Amador Arquitectos | [NAME]
 | Code Consultant |  |  |  |  |  |  |  |  |  |  | Architect of record | Ankrom Moisan | [NAME]
 | Comissioning Consultant |  |  |  |  |  |  |  |  |  |  | Architect of record | Antunovich Associates | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | Architect of record | Antunovich Associates | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | Architect of record | AO Architects (Architect's Orange) | Armando
 |  |  |  |  |  |  |  |  |  |  |  | BMCS Consultant | HMA | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | Civil Engineer | Adams Engineering | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | Civil Engineer | [NAME] | Lance
 |  |  |  |  |  |  |  |  |  |  |  | Civil Engineer | Pennoni Associates, Inc. | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | Code Consultant | [NAME] | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | Code Consultant | WJE | Harold
 |  |  |  |  |  |  |  |  |  |  |  | Comissioning Consultant | AHA | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | Comissioning Consultant | Butters | Mitch
Spreadsheet: 164591d1340815019-trying-to-select-a-name-out-of-a-cell-given-by-certain-critera-within-an-adjacent-cell-racertest
Sheet: Sheet1

Racers and Best Time
Events
 | Column1 | Race 1 | Race 2 | Race 3 | Race 4 | Value | Race One |  | Race Two |  | Helper Column
 | Racer 1 | 42.59 | 41.8 | 40.92 | 42.39 |  |  |  |  |  | Racer 1
 | [NAME] | 42.59 | 58.53 | 56.68 | 54.68 |  | 2 |  | 2 |  | [NAME]
 | Racer 3 | 42.59 | 33.9 | 56.68 | 25.36 |  | 1 |  | 1 |  | Racer 3
 | [NAME] | 42.59 | 51.49 | 44.62 | 78.27 |  | 3 |  | 3 |  | [NAME]
 | Racer 5 | 42.59 | 51.05 | 54.32 | 47.72 |  | Race Three |  | Race 4 |  | Racer 5
 | Racer 6 | 42.59 | 34.08 | 46.44 | 78.27 |  |  |  |  |  | Racer 6
 | Racer 7 | 33.75 | 58.53 | 56.68 | 78.27 |  | 2 |  | 2 |  | Racer 7
 | Racer 8 | 24.6 | 25.75 | 33.08 | 22.63 |  | 1 |  | 1 |  | Racer 8
 | Racer 9 | 42.59 | 25.72 | 29.28 | 62.3 |  | 3 |  | 3 |  | Racer 9
 |  |  |  |  |  | =VLOOKUP(SMALL(Table1[Race 1],1),$C$3:$L$12,10,0)
 |  |  |  |  |  | So in every cell add a vlookup before your small formula
Spreadsheet: 688656d1595892877-fixing-time-format-sample
Sheet: Sheet1

epoc (ms) | timestamp (-0700) | elapsed (s) | temperature (C) |  | Extracted time
1595888370469 | 2020-07-27T15.19.30.469 | 0 | 32.5 |  |  |  | Column F needs to be in the format hh:[NAME]:ss.0
1595888430469 | 2020-07-27T15.20.30.469 | 60 | 32.75
1595888490469 | 2020-07-27T15.21.30.469 | 120 | 32.75
1595888550469 | 2020-07-27T15.22.30.469 | 180 | 32.75
1595888610469 | 2020-07-27T15.23.30.469 | 240 | 33
1595888670469 | 2020-07-27T15.24.30.469 | 300 | 33
1595888730469 | 2020-07-27T15.25.30.469 | 360 | 32.625
1595888790469 | 2020-07-27T15.26.30.469 | 420 | 31.25
1595888850469 | 2020-07-27T15.27.30.469 | 480 | 30.125
1595888910469 | 2020-07-27T15.28.30.469 | 540 | 29.5
Spreadsheet: 168734d1342552700-copy-across-multiple-rows-and-columns-the-data-to-one-column-removing-dupilicates-blank-15640
Sheet: Jan27-Feb2p

Pavilion
 | 2013-01-27 00:00:00 |  |  | Thru | 2013-02-02 00:00:00
 | SUN | MON | TUE | WED | THURS | FRI | SAT
 | 2013-01-27 00:00:00 | 2013-01-28 00:00:00 | 2013-01-29 00:00:00 | 2013-01-30 00:00:00 | 2013-01-31 00:00:00 | 2013-02-01 00:00:00 | 2013-02-02 00:00:00 |  |  |  | Blocks | Team | Hours
7:15AM | Silver Sticks |  |  |  |  |  |  | 7:15AM |  |  | 0 | 05 [NAME] | 0
 | Silver Sticks |  |  |  |  |  |  |  |  |  | 0 | 04 Flags | 0
8:15AM | Silver Sticks |  |  |  |  |  |  | 8:15AM |  |  | 0 | 03 [NAME] | 0
 | Silver Sticks |  |  |  |  |  |  |  |  |  | 0 | 02 Flags | 0
9:15AM | Silver Sticks |  |  |  |  |  |  | 9:15AM |  |  | 0 | 01 Flags | 0
 | Silver Sticks |  |  |  |  |  |  |  |  |  | 0 | 00 Flags | 0
10:15AM | Silver Sticks |  |  |  |  |  |  | 10:15AM |  |  | 0 | 99 Flags | 0
 | Silver Sticks |  |  |  |  |  |  |  |  |  | 0 | 98 Flags | 0
11:15AM | Silver Sticks |  |  |  |  |  |  | 11:15AM |  |  | 0 | Midget A | 0
 | Silver Sticks |  |  |  |  |  |  |  |  |  | 0 | Midget AA | 0
12:15PM | Silver Sticks |  |  |  |  |  |  | 12:15PM
 | Silver Sticks
1:15PM | Silver Sticks |  |  |  |  |  |  | 1:15PM
 | Silver Sticks
2:15PM |  |  |  |  |  |  |  | 2:15PM
3:15PM |  |  |  |  |  |  |  | 3:15PM
4:15PM |  |  |  |  |  |  |  | 4:15PM
5:15PM |  |  |  |  |  |  |  | 5:15PM
[NAME] |  |  |  |  |  |  |  | [NAME]
7:15PM |  |  |  |  |  |  |  | 7:15PM
8:15PM |  |  |  |  |  |  |  | 8:15PM
9:15PM |  |  |  |  |  |  |  | 9:15PM
10:15PM |  |  |  |  |  |  |  | 10:15PM
11:15PM |  |  |  |  |  |  |  | 11:15PM
 | Cancellations or Corrections
 | Date | Time | Customer | Operations Personal | Comments
Spreadsheet: 285809d1387861242-need-all-sheet-to-be-change-if-i-change-the-master-sample10
Sheet: Condiments

Item Number | Item Description | Packing | Brand | Category | Total
ORGSTRAW13 | CROFTER  PREMIUM SPREAD STRAWBERRY ORGANIC | 2X6X283GM | CROFTERS | CONDIMENTS | 938.58
ORGAPRI967 | CROFTER PREMIUM SPREAD APRICOT ORGANIC | 2X6X283GM | CROFTERS | CONDIMENTS | 656.5
ORGRASP920 | CROFTER PREMIUM SPREAD RASPBERRY ORGANIC | 2X6X283GM | CROFTERS | CONDIMENTS | 655.5
ORGCHERY43 | CROFTER PREMIUM  SPREAD MORELLO CHERRY ORGANIC | 2X6X283GM | CROFTERS | CONDIMENTS | 350.5
ORGBLUE950 | CROFTERS PREMIUM BLUEBERRY ORGANIC | 2X6X283GM | CROFTERS | CONDIMENTS | 269
ORGMANGO75 | CROFTERS PREMIUM MANGO ORGANIC | 2X6X283GM | CROFTERS | CONDIMENTS | 269
ORGBLAC936 | CROFTERS PREMIUM BLACKBERRY ORGANIC | 2X6X283GM | CROFTERS | CONDIMENTS | 178
 |  |  |  | Total | 3317.08
Spreadsheet: e467324f-32a1-4d6d-a7db-58cade929257
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
ALC | Test | ALC | Ethanol, Blood | Ethanol, B | Headspace Gas Chromatography-Flame Ionization Detector (HSGC-FID) | Gray-Top Tube (Potassium Oxalate/Sodium Fluoride): GryPOSF |  |  | 2 | mL | Container/Tube:  Preferred: Grey top (potassium oxalate/sodium fluoride) Acceptable: Any anticoagulant [NAME]: 2 mL Collection Instructions: Specimen must be sent in original tube.  Additional Information: For situations where chain-of-custody is required, a Chain-of-Custody Kit (Supply T282) is available. For chain-of-custody information, see COCH/9426 Chain-of-Custody Processing. | 0.5 mL or amount to fill 1 tube | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	Mild OK; [NAME] OK Other	NA | Not detected (Positive results are quantified.) Limit of detection: 10 mg/dL (0.01 g/dL) Legal limit of intoxication is 80 mg/dL (0.08 g/dL). Toxic concentration is dependent upon individual usage history. Potentially lethal concentration: > or =400 mg/dL (0.4 g/dL) | Monday through Sunday; Varies | Same day/1 day | 1 day | 1 | 82055 |  |  |  |  | Rochester
ALC | [NAME] | WBNAFL | [NAME] NaFl-KOx |  |  |  | Refrigerated | 72 hours
ALC | Result | 30908 | Ethanol, B | Ethanol, B | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 5640-8 | Ethanol:MCnc:Pt:[NAME]:Qn:
Spreadsheet: 733747d1621778472-pull-data-based-on-cell-criteria-ef-sample-workbook_may-20
Sheet: Master

Covered in Jun'20
Category | Activity Name
Spreadsheet: 860856d1708877785-change-column-displayed-based-on-drop-down-example-book
Sheet: Lines

Room: | 1
Line | Camera | Slot
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
Spreadsheet: 174a123a-b730-4784-8753-600da4111155
Sheet: Claudette Sortino

[NAME]
Fair Share Fee: Those Who Don't Pay Their Fair Share
Agree
Explain your fair share position, if you choose.
The NEA position appears to be a fair position to all involved.
Teachers' Retirement: Support in the State Budget
Agree
Explain your teachers' retirement position, if you choose.
Given that teacher salaries at entry level tend to be lower than that of most other professionsals, benefits at least make
up for some of the disparity.  It has concerned me for a long time that teaching is the noblest of professions but not adequately
rewarded.
Health Care: Continuing System Reform
Agree
Explain your health care reform position, if you choose
I am unsure on this issue.  Until everything rolls out with the Affordable care Act and Vermont's Green Mountain Care, I don't have
enough information as to what position to take, but the NEA proposal sounds reasonable.
Teaching Career: Retaining New Teachers
Agree
Explain your teaching career position, if you choose
Retaining the best and the brightest is the number one priority to  create a top quality system of public education.  On the other
side of this is a need that teachers who do not meet the high standards required to be best they can be should not be able to
continue on teaching forever.
Teaching Profession: Simplifying Professional Relicensing
Agree
Explain your relicensing position, if you choose
Again I don't have sufficient knowledge to answer this question directly.  Like other highly skilled professions, teachers should have
to maintain and improve their skills in order to remain at the cutting edge.  [NAME] should be as uncomplicated as possible but
of sufficient depth to provide necessary information.
Name | email address | Address | Office sought | Are you an incumbent? |  | County
[NAME] | [EMAIL] | 350 [NAME]South Ryegate VY 05069 | State Representative, Caledonia District-1 | No |  | Caledonia
Spreadsheet: 791120d1660160413-copy-values-from-one-excel-sheet-to-another-by-matching-multiple-columns-fillcellsbasedonmultiplecriteria_excelex
Sheet: Sheet1

Table to Add to based on Station (col. A) / Bottle (col. C) |  |  |  |  | Table with chla values to add  (col. H -> col. D)
station | press | bottle | chla | WHAT SHOULD BE HERE/CHLA | station | bottle | chla
SLIP1 | 74.899 | 1 |  |  | SLIP1 | 3 | 0.27
SLIP1 | 74.867 | 2 |  |  | SLIP1 | 6 | 0.27
SLIP1 | 74.934 | 3 |  | 0.27 | SLIP1 | 9 | 1.29
SLIP1 | 74.869 | 4 |  |  | SLIP1 | 12 | 0.37
SLIP1 | 74.898 | 5 |  |  | SLIP1 | 15 | 0.32
SLIP1 | 51.088 | 6 |  | 0.27 | SLIP1 | 18 | 0.21
SLIP1 | 51.087 | 7 |  |  | SLIP2 | 1 | 0.24
SLIP1 | 51.089 | 8 |  |  | SLIP2 | 7 | 0.33
SLIP1 | 36.177 | 9 |  | 1.29 | SLIP2 | 10 | 0.25
SLIP1 | 36.193 | 10 |  |  | SLIP2 | 13 | 1.92
SLIP1 | 36.112 | 11 |  |  | SLIP2 | 16 | 0.48
SLIP1 | 24.897 | 12 |  | 0.37 | SLIP2 | 19 | 0.66
SLIP1 | 24.843 | 13
SLIP1 | 24.756 | 14
SLIP1 | 14.734 | 15 |  | 0.32
SLIP1 | 14.654 | 16
SLIP1 | 14.688 | 17
SLIP1 | 5.338 | 18 |  | 0.21
SLIP1 | 5.325 | 19
SLIP1 | 5.322 | 20
SLIP2 | 76.221 | 1
SLIP2 | 76.172 | 2
SLIP2 | 76.153 | 3
SLIP2 | 51.023 | 7
SLIP2 | 51.02 | 8
SLIP2 | 51.03 | 9
SLIP2 | 35.394 | 10
SLIP2 | 35.406 | 11
SLIP2 | 35.418 | 12
SLIP2 | 25.198 | 13
SLIP2 | 25.225 | 14
SLIP2 | 25.26 | 15
SLIP2 | 15.421 | 16
SLIP2 | 15.342 | 17
SLIP2 | 15.326 | 18
SLIP2 | 5.157 | 19
SLIP2 | 5.166 | 20
SLIP2 | 5.179 | 21
Spreadsheet: mary_fischer__25634__31Q
Sheet: E15.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY #  031Q
COMPANY NAME    Limbach Constructors
ANALYSIS OF MINORITY INTERESTS
FOR THE 3 MONTHS ENDED 3-31-2001
 |  |  |  |  |  |  |  |  |  |  |  | E-15
 |  |  |  | 12-31-2000 Balance
 |  |  |  | BEGINNING |  | AMOUNT |  |  |  |  |  | 12-31-2001
[NAME] OR ENTITY |  | ENRON'S |  | BALANCE |  | PER INCOME |  | OTHER |  |  |  | BALANCE
 |  | OWNERSHIP % |  | DR. (CR.) |  | STATEMENT |  | AMOUNT |  | (DESCRIBE) |  | DR. (CR.)
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Total Minority Interest | * |  |  |  |  |  |  |  |  |  |  |  | *
* MUST TIE TO HYPERION ACCOUNT 0855  DR/(CR)
Spreadsheet: andy_zipper__127__Broker & Exchange Detail 6-8-01
Sheet: EXCHANGE DEAL SUMMARY

EnronOnline Exchange Detail for 6/8/2001
Completed Transactions:
TODAY
NO ACTIVITY
Date | 2001-06-05 00:00:00
Count
Exchange Party | Counterparty Name | Commodity | Total
True Quote LLC | PG&E Energy Trading - Power, L.P. | US East Power | 3
LTD
Date | (All)
Count
Exchange Party | Counterparty Name | Commodity | Total
True Quote LLC | PG&E Energy Trading - Power, L.P. | US East Power | 7
 |  | US West Power | 10
 | Tucson Electric Power Company | US West Power | 1
 | Cinergy Marketing & Trading, LLC | Natural Gas | 2
 | Conectiv Energy Supply, Inc. | US East Power | 6
 | Tractebel Energy Marketing, Inc. | US East Power | 1
 |  | Natural Gas | 6
 | CMS Marketing, Services and Trading Company | US East Power | 1
True Quote LLC Total |  |  | 34
Grand Total |  |  | 34
Spreadsheet: 04de7c86-1f43-402e-970f-3b08b18ab5b0
Sheet: Report

2159
FY 2011 Pension Adjustment |  |  |  | Notes
1 | Actual TRA salaries, basic + coordinated, FY 1997 |  |  |  |  |  |  | 4
 | Actual TRA salaries, basic + coordinated, FY 2004 |  |  |  |  |  |  | 5
 | Actual TRA salaries, basic + coordinated, FY 2005 |  |  |  |  |  |  | 6
 | Actual TRA salaries, basic + coordinated, FY 2006 |  |  |  |  |  |  | 7
 | Actual TRA salaries, basic + coordinated, FY 2007 |  |  |  |  |  |  | 8
 | Actual TRA salaries, basic + coordinated, FY 2008 |  |  |  |  |  |  | 9
 | Actual TRA salaries, basic + coordinated, FY 2009 |  |  |  |  |  |  | 10
 | Actual TRA salaries, basic + coordinated, FY 2010 |  |  |  |  |  |  | 11
 | PERA salaries, FY 1997 |  |  |  |  |  |  | 15
 | Old law PERA adjustment |  |  |  |  |  |  | 16
Spreadsheet: 780289d1652373811-if-calculated-value-is-not-equal-to-a-date-return-book1
Sheet: Sheet1

 | 2022-04-01 00:00:00 | 2022-05-13 00:00:00
 | 2022-04-01 00:00:00 | 2022-04-29 00:00:00
 | 2022-04-22 00:00:00 | 2022-04-29 00:00:00
 | 2022-04-29 00:00:00 | 2022-05-13 00:00:00
 | 2022-04-18 00:00:00 | 2022-05-23 00:00:00
 | 2022-04-18 00:00:00 | 2022-04-25 00:00:00
 | 2022-04-25 00:00:00 | 2022-05-20 00:00:00
 | 2022-05-20 00:00:00 | 2022-05-30 00:00:00
 | 2022-05-30 00:00:00 | 2022-06-03 00:00:00
Spreadsheet: 07466b93-9fee-4cc1-a2c0-5189b737a5f5
Sheet: Purchase of Equipment

[NAME]
Item # | Item | Year | Purchase Price
 | 2500 Set | 1 | 38.5
 |  | 2 | 38.89
 |  | 3 | 39.27
 |  | 4 | 39.67
 |  | 5 | 40.06
 | 14 ft [NAME] | 1 | 1.32
 |  | 2 | 1.38
 |  | 3 | 1.39
 |  | 4 | 1.4
 |  | 5 | 1.41
 | 25 ft Line Cord | 1 | 2.75
 |  | 2 | 2.78
 |  | 3 | 2.82
 |  | 4 | 2.85
 |  | 5 | 2.88
 | 48 Port Cat 6 Panel | 1 | 275
 |  | 2 | 277.75
 |  | 3 | 280.53
 |  | 4 | 283.33
 |  | 5 | 286.18
 | Cat 6 [NAME] | 1 | 1.85
 | 3 ft | 2 | 1.87
 |  | 3 | 1.89
 |  | 4 | 1.91
 |  | 5 | 1.94
Spreadsheet: 141648d1329387411-vba-to-copy-data-from-multiple-workbooks-to-master-workbook-sales-person-3
Sheet: Sales Log

 | No. | Client | Activity | Activity
 | 1
 | 1.01
 | 1.02
 | 1.03 |  |  |  |  | Named Range
 | 1.04 |  |  |  |  | Range1
 | 1.05
 | 1.06
 | 1.07
 | 1.08
 | 1.09
 | 2
 | 2.01
 | 2.02
 | 2.03
 | 2.04 |  |  |  |  | Named Range
 | 2.05 |  |  |  |  | Range2
 | 2.06
 | 2.07
 | 2.08
 | 2.09
 | 3 | Client 21 | Activity 1 | [NAME] 3
 | 3.01 | Client 22 | Activity 2 | [NAME] 3
 | 3.02 | Client 23 | Activity 3 | [NAME] 3
 | 3.03 | Client 24 | Activity 4 | [NAME] 3
 | 3.04 | Client 25 | Activity 5 | [NAME] 3 |  | Named Range
 | 3.05 | Client 26 | Activity 1 | [NAME] 3 |  | Range3
 | 3.06 | Client 27 | Activity 2 | [NAME] 3
 | 3.07 | Client 28 | Activity 3 | [NAME] 3
 | 3.08 | Client 29 | Activity 4 | [NAME] 3
 | 3.09 | Client 30 | Activity 5 | [NAME] 3
Spreadsheet: d640de8c-10b6-4760-a790-b8a578c2c1a0
Sheet: Sheet1

Aperture | 150 | CO |  |  | Barlow | 1.5 | 2.2
Type | Focal Length | Telescope Focal Ratio/Length |  | Mag Steps | Mag | Barlow | Barlow | AFOV | TFOV | [NAME] | Power / Per Inch
Plossl | 32 | 0 | 0 |  | 0 |  |  | 50 | 0 | 0
Plossl | 25 |  |  |  |  |  |  | 52
HD [NAME] | 18 |  |  |  |  |  |  | 41
 | 12 |  |  |  |  |  |  | 45
 | 10 |  |  |  |  |  |  | 51
TMB II | 8 |  |  |  |  |  |  | 58
[NAME] | 7 |  |  | 0 | 0 |  |  | 0 | 0 | 0
 | 6
 |  | FR= | FL/D
 |  | TFOV= | AFOV/Mag
 |  | Mag = | AFOV/TFOV
 |  | Mag = | FL/EpFL
 |  | FL = | Mag*EpFL
Aperture |  | CO |  |  | 1.5x Barlow
Type | Focal Length | Telescope Focal Ratio/Length |  | Mag Steps | Mag | AFOV | TFOV | [NAME] | Power / Per Inch
Plossl | 32 | 0 | 0 |  | 0 | 50 | 0 | 0
Plossl | 25 |  |  |  |  | 52 | 0.34
HD [NAME] | 18 |  |  |  |  | 40.44 | 0.21
 | 12 |  |  |  |  | 45 | 0.15
 | 10 |  |  |  |  |  | 0.14
TMB II | 8 |  |  |  |  | 58 | 0.14
[NAME] | 7 |  |  |  | 0 | 0 | 0 | 0
 | 6 |  |  |  |  |  | 0.11
Aperture |  | CO |  |  | 2.2x Barlow
Type | Focal Length | Telescope Focal Ratio/Length |  | Mag Steps | Mag | AFOV | TFOV | [NAME] | Power / Per Inch
Plossl | 32 | 0 | 0 |  | 0 | 50 | 0 | 0
Plossl | 25 |  |  |  |  | 52 | 0.25
HD [NAME] | 18 |  |  |  |  | 40.44 | 0.14
 | 12 |  |  |  |  | 45 | 0.1
 | 10 |  |  |  |  |  | 0.09
TMB II | 8 |  |  |  |  | 58 | 0.09
[NAME] | 7 |  |  | 0 | 0 | 0 | 0 | 0
 | 6 |  |  |  |  |  | 0.07
Spreadsheet: andy_zipper__221__Global_Prod 5-30-01 EM
Sheet: New on 5-29-01 - 24 Hr

New Global Products made available on
that were not available on
Global Product Short Desc.
Credit Dflt Swap Nokia OYJ               3 Years         bpa/USDm
Credit Dflt Swap Telfon Ericsson         5 Years         bpa/USDm
[NAME] ARA                 Apr-Jun02       EUR/mt
[NAME] ARA                 Jan-Mar02       EUR/mt
[NAME] ARA                 Jul-Sep01       EUR/mt
[NAME] ARA                 Jul-Sep02       EUR/mt
[NAME] ARA                 Oct-Dec01       EUR/mt
[NAME] ARA                 Oct-Dec02       EUR/mt
For Curr Exch    Forward                 01Jun01         JPY/USD
For Curr Exch    Forward                 01Jun01         USD/EUR
For Curr Exch    Forward                 01Jun01         USD/GBP
For Curr LME     LME (Spot)              01Jun01         JPY/USD
For Curr LME     LME (Spot)              01Jun01         USD/EUR
For Curr LME     LME (Spot)              01Jun01         USD/GBP
Foreign Currency Reuters BOFC            30May01         CAD/USD
[NAME]Sep01           WS/mt
US Prop FOB Phy  MB TET                  Jun01           c/Gl-b
US ResidOil Swap Platts No 6 GC 3%       Jul-Sep01       USD/bl/m
US ResidOil Swap Platts No 6 GC 3%       Oct-Dec01       USD/bl/m
US Wthr CDD Swap SAC 100/20K             May-Sep01       USD/CDD
Spreadsheet: 864254d1711485420-calculating-bonus-value-based-on-percentage-of-goal-met-bonus
Sheet: Bonus Calc

Sales Goal | 3000000
Bonus Target | 5000
Q1 Revenue | 10000000 | <-- Accounting inputs number here
 |  |  |  |  |  | % of Goal | Bonus Payout %
Actual Q1 Bonus |  |  |  |  |  | 0.15 | 0.15
 |  |  |  |  |  | 0.25 | 0.25
 |  |  |  |  |  | 0.5 | 0.5
 |  |  |  |  |  | 0.9 | 0.75
 |  |  |  |  |  | 1 | 1
 |  |  |  |  |  | 1.05 | 1.05
 |  |  |  |  |  | 1.1 | 1.1