tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 888307d1738794322-count-lookup-if-date-in-in-range-term-test
Sheet: Term list

 |  | Termination Date |  |  |  |  | Department
 |  | 2025-01-09 00:00:00 |  |  |  |  | TN-PR-SUP
 |  | 2025-01-03 00:00:00 |  |  |  |  | FINANC
 |  | 2024-12-30 00:00:00 |  |  |  |  | TN-PR-REC
 |  | 2024-12-20 00:00:00 |  |  |  |  | TN-PR-SUP
 |  | 2024-12-09 00:00:00 |  |  |  |  | SL-ADM
 |  | 2024-11-18 00:00:00 |  |  |  |  | SL-SUP
 |  | 2024-11-18 00:00:00 |  |  |  |  | TN-PR-ASS
 |  | 2024-11-07 00:00:00 |  |  |  |  | TN-PR-ASS
 |  | 2024-11-01 00:00:00 |  |  |  |  | PURINT
 |  | 2024-11-01 00:00:00 |  |  |  |  | PG-ECO
 |  | 2024-10-29 00:00:00 |  |  |  |  | PR-SHP
 |  | 2024-10-17 00:00:00 |  |  |  |  | PURCHS
 |  | 2024-10-17 00:00:00 |  |  |  |  | TN-PR-REC
 |  | 2024-10-15 00:00:00 |  |  |  |  | TN-PR-IDS
 |  | 2024-10-07 00:00:00 |  |  |  |  | TN-PR-SHP
 |  | 2024-10-03 00:00:00 |  |  |  |  | PG-MKT
 |  | 2022-10-01 00:00:00 |  |  |  |  | PG-MKT
 |  | 2024-09-16 00:00:00 |  |  |  |  | TN-PR-ASS
 |  | 2023-09-06 00:00:00 |  |  |  |  | TN-PR-VAS
 |  | 2023-09-03 00:00:00 |  |  |  |  | TN-PR-PSH
 |  | 2023-08-23 00:00:00 |  |  |  |  | TN-PR-REP
 |  | 2024-08-23 00:00:00 |  |  |  |  | TN-PR-PSH
 |  | 2024-08-21 00:00:00 |  |  |  |  | PR-ADM
 |  | 2024-08-21 00:00:00 |  |  |  |  | TN-PR-ASS
 |  | 2024-08-07 00:00:00 |  |  |  |  | TN-PR-SUP
 |  | 2024-08-06 00:00:00 |  |  |  |  | SL-IND
 |  | 2024-07-26 00:00:00 |  |  |  |  | SL-ADM
 |  | 2024-07-23 00:00:00 |  |  |  |  | SL-ADM
 |  | 2024-06-25 00:00:00 |  |  |  |  | TN-PR-SUP
 |  | 2024-06-21 00:00:00 |  |  |  |  | TN-PR-REP
 |  | 2024-05-31 00:00:00 |  |  |  |  | SL-ADM
 |  | 2024-05-29 00:00:00 |  |  |  |  | TN-PR-PSH
 |  | 2024-05-28 00:00:00 |  |  |  |  | TN-PR-ASS
 |  | 2024-05-21 00:00:00 |  |  |  |  | TN-PR-REP
 |  | 2024-05-20 00:00:00 |  |  |  |  | TN-PR-SHP
 |  | 2024-05-16 00:00:00 |  |  |  |  | TN-PR-ASS
 |  | 2024-05-08 00:00:00 |  |  |  |  | TN-PR-RMA
 |  | 2024-05-03 00:00:00 |  |  |  |  | TN-SL-ADM
 |  | 2024-05-03 00:00:00 |  |  |  |  | TN-PR-SUP
 |  | 2024-05-01 00:00:00 |  |  |  |  | TN-PR-ADM
 |  | 2024-04-30 00:00:00 |  |  |  |  | TN-PR-RMA
 |  | 2024-04-26 00:00:00 |  |  |  |  | TN-PR-QAS
 |  | 2024-04-26 00:00:00 |  |  |  |  | TN-PR-VAS
 |  | 2024-04-25 00:00:00 |  |  |  |  | TN-PR-ASS
 |  | 2024-04-24 00:00:00 |  |  |  |  | TN-PR-ASS
 |  | 2024-04-20 00:00:00 |  |  |  |  | TN-PR-REP
 |  | 2024-04-18 00:00:00 |  |  |  |  | TN-PR-REC
 |  | 2024-04-17 00:00:00 |  |  |  |  | TN-PR-SHP
Spreadsheet: 751722d1634281777-calculate-and-count-occurrences-across-multiple-non-adjacent-columns-and-multiply-earnings
Sheet: Volunteers

 |  | Earnings WK1 | Earnings WK2 | Earnings WK3 | Earnings WK4 | Earnings WK5 | Earnings WK6 | [NAME] | Earnings WK8 | Earnings WK9
Volunteer 1
Volunteer 2
Volunteer 3
Volunteer 4
Volunteer 5
Volunteer 6
Volunteer 7
Volunteer 8
Volunteer 9
Volunteer 10
Volunteer 11
Volunteer 12
Volunteer 13
Volunteer 14
Volunteer 15
Volunteer 16
Volunteer 17
Volunteer 18
Volunteer 19
Volunteer 20
Spreadsheet: 14f55282-8767-47ef-8c09-3f70f6da9c7b
Sheet: Sheet1

OTB Summary Worksheet | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
XXXXX Casino |  |  |  |  |  | Use the items below to copy into appropiate cells
Date | Shift | Station/ Location | Net Cash Turn-In | Signatures of: |  | Yes þ  No r
 |  |  |  | [NAME] | Verifier | Yes r  No þ
 | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r
 | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r
 | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r
 | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r
 | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r
 | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r
 | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r
 | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r
 | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r
 | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r
 | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r
 | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r
 | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r
 | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r
 | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r
 | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r
 | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r
 | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r
 | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r
 | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r
 | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r
 | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r
 | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r
 | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r
 | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r
 | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r
 | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r
 | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r
 | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r
 | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r
 | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r
 | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r
 | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r
 | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r
 | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r
 | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r
Spreadsheet: 35502d1233107395-excel-2007-how-to-calculate-formula-to-exclude-empty-cells-qc-sheet-master
Sheet: Thursday

 | Technician |  |  |  |  | Jobs Routed | [NAME] | Jobs Not Completed | Total QC Completed | Pass | Fail
 | 1 |  |  |  |  | 5 | 5 |  | 0 | 0
 | 2 |  |  |  |  | 5 | 5 |  | 0 | 0
 | 3 |  |  |  |  | 5 | 5 |  | 2 | 1
 | 4 |  |  |  |  | 5 | 1 |  | 2 | 1
 | 5 |  |  |  |  | 5 | 4 |  | 3 | 2
 | 6 |  |  |  |  | 5 | 4 |  | 1 | 0
 | 7 |  |  |  |  | 5 | 4 |  | 1 | 1
 | 8 |  |  |  |  | 5 | 5 |  | 0 | 0
 | 9 |  |  |  |  | 5 | 5 |  | 3 | 2
 | 10 |  |  |  |  | 4 | 4 |  | 0 | 0
 | 11 |  |  |  |  | 4 | 4 |  | 0 | 0
 | 12 |  |  |  |  | 4 | 2 |  | 0 | 0
 | 13 |  |  |  |  | 4 | 3 |  | 1 | 1
 | 14 |  |  |  |  | 7 | 6 |  | 2 | 1
 | 15 |  |  |  |  | 7 | 6 |  | 2 | 2
 | 16 |  |  |  |  | 7 | 4 |  | 2 | 2
 | 17
 | 18
 | 19
 | 20
 | 21
 | 22
 | 23
 | 24
 | 25
 | Totals
Spreadsheet: gerald_nemec__11404__SASEP30-2000
Sheet: PRESSURE 

2000-09-30 00:00:00
 |  | JAN - AUG
WELL | LINE | 8 MONTH | COMMENTS
 | PRESSURE | AVG LP
SA #1
SA #2
SA #5
SA #6
SA#40
ENTRADA TOTAL
SA #4 | 120 | 105
SA #17 | 120 | 105
SA #18 | 119 | 106
SA #21 | 122 | 103
SA #24 | 119 | 103
SA #26 | 120 | 109
SA #27 | 120 | 104
SA #28 | 120 | 113
SA #30 | 120 | 115
SA #3 | 62 | 73
SA #35 | 110 | 103
SA #36 | 119 | 109
SA #37 | 119 | 111
SA #12 | 119 | 97
SA #16 | 125 | 106
SA #20 | 120 | 102
ROUTE #1 AVERAGE
SA #8 | 72 | 85
SA #9 | 64 | 84
SA #11 | 76 | 85
SA #13 | 61 | 92
SA #19 | 48 | 66
SA #22 | 119 | 113
SA #25 | 67 | 83
SA #29 | 62 | 80
SA #31 | 80 | 83
SA #32 | 148 | 109
SA #38 | 76 | 93
FED 174-1 | 54 | 74
BITTERCREEK#1 | 54 | 76
FEDERAL GILBERT | 54 | 78
ARCO 36-7 | 176 | 121
ARCO 36-8 | 176 | 125
ARCO 2-1 | 174 | 121
ARCO 2-2 | 193 | 127
BLACKHORSE 31-1 | 156 | 113
ARCO 27-1 | 67 | 89
ROUTE #2 AVERAGE
Spreadsheet: 199518d1355243849-matching-multiple-criteria-both-exactly-and-approximately-example-coded-vs-charges
Sheet: Sheet1

DOS | NAME | ProfCPT1 | MOD | Dx1 | Dx2 | Dx3
2012-11-08 00:00:00 | [NAME], [NAME] | 99284 |  | 9 | 787.91 | 729.1
2012-11-08 00:00:00 | Doe, [NAME] | 99284 |  | 535.5 | 789.09 | 787.91
2012-11-08 00:00:00 | [NAME], [NAME] | 99285 | 25 | 995.3
2012-11-08 00:00:00 | Jones, [NAME] | 99285 |  | 780.4 | 787.01 | 780.64
Spreadsheet: louise_kitchen__22837__Hot List Update 4-30-01
Sheet: Wellhead

Deal Description Sheet - 4/30/01
Wellhead
Project Name | Counterparty | Description | Potential Valuation | Last Customer Contact | Probability | Expected Closing (Month/Year) | Weekly Updates / Comments
CL&F I | Continental Land & Fur | Accounting. | *$10,000 | 2001-04-03 00:00:00 | 0.9 | 2001-05-01 00:00:00 | Initial deal to close in May.  2 wells.  ATS & ENA commodity.
Aspect Resources | Aspect Resources | Well Connect Offsystem - Cross Media #1, TNCT #1, Galveston County, TX, [NAME] and 098-9816, FGT Meter 092-0490 and 092-0489. | *$50,000 | 2001-04-24 00:00:00 | 0.5 | 2001-06-01 00:00:00 | Meeting set up for May 11, 2001.
Apache | Apache | Outsourcing- scheduling, balancing, settlement, deal confirmations and measurement. | *$750,000 | 2001-04-09 00:00:00 | 0.25 | 2001-06-01 00:00:00 | Will be meeting with [NAME] and [NAME] first week in May.
CL&F II | Continental Land & Fur | Accounting and scheduling, outsourcing. | 50000 | 2001-04-03 00:00:00 | 0.7 | 2001-08-01 00:00:00 | 300 wells depending on the success of CL&F II.
Crosstimbers | Crosstimbers | Outsourcing- scheduling, balancing, settlement, deal confirmations and measurement. | *$125,000 | 2001-04-11 00:00:00 | 0.25 | 2001-09-01 00:00:00 | Meeting set up for second part of May with [NAME].
 |  |  |  |  |  |  | * Accrual
Spreadsheet: 878342d1725422012-how-to-find-multiple-data-from-a-list-then-combine-it-in-another-cell-robin-excel-question-2-
Sheet: MATERIAL CODE LIST

Product | Description | Code | XM
1234 | ABC | 1 | S
1234 | ABC | 2 | M
1234 | ABC | 3 | P
1234 | ABC | 4 | K
1461 | GJK | 1 | S
1456 | BCD | 1 | S
1456 | BCD | 2 | M
1735 | DEFG | 1 | S
1735 | DEFG | 2 | M
1735 | DEFG | 3 | P
1735 | DEFG | 4 | K
1735 | DEFG | 5 | R
1735 | DEFG | 6 | T
1873 | NMOP | 1 | S
2012 | FFGH | 1 | S
2012 | FFGH | 2 | M
2012 | FFGH | 3 | P
2012 | FFGH | 4 | K
2012 | FFGH | 5 | R
2012 | FFGH | 6 | T
2378 | [NAME] | 1 | S
2378 | [NAME] | 2 | M
2378 | [NAME] | 3 | P
2378 | [NAME] | 4 | K
2645 | LMNO | 1 | S
2645 | LMNO | 2 | M
2752 | TSTL | 1 | S
2752 | TSTL | 2 | M
2752 | TSTL | 3 | P
2865 | ERTY | 1 | S
2865 | ERTY | 2 | M
Spreadsheet: 760519d1640265517-average-formula-using-unconventional-format-test-45-ans-2
Sheet: Sheet1

Year | Reading Age Difference
2016 | 1/1 |  | Month is rounded to nearest integer |  |  | 13
2017 | 6/8 |  | ARRAY formula is used |  |  | 80
2018
2019 | -0/4 |  |  |  |  | 4
2020 | 2/8 |  |  |  |  | 32
2021 | 4/10 |  |  |  |  | 58
Average |  | Blank cell treated as 0/0
 |  | Blank cell omitted for calculation.
Spreadsheet: 774536d1648537772-highlight-column-a-if-column-e-has-data-condition-format
Sheet: Sheet1

A | B | C | D | E | F | G | H
TANADAR | DRT | AAA | N |  | s | 11970 | AAADNRT
GRADATE | DRT | AAE | G |  | d | 2848 | AADEGRT
LATERAD | DRT | AAE | L |  |  | 1668 | AADELRT
ADAPTER | DRT | AAE | P |  | s | 4817 | AADEPRT
READAPT | DRT | AAE | P | p | s | 4818 | AADEPRT
ADRATES | DRT | AAE | S |  |  | 1670 | AADERST
Spreadsheet: 162844d1340102150-sumifs-that-includes-additional-criteria-sample-db
Sheet: I&E

 |  |  | Period |  |  | 8
 |  |  | Total Funding
 |  |  |  |  |  |  |  | Actual
Range 1
[NAME] | Range To |  | Income
500 | 4500 |  |  | Income 1 |  |  |  | 5712364.129999999
4605 | 4645 |  |  | Income 2 |  |  |  | 477.7499999999999
5500 | 6200 |  |  | Income 3 |  |  |  | 1158054.28
10100 | 10750 |  |  | Income 4 |  |  |  | 110958.35
 |  |  |  | Income 5 |  |  |  | 0
 |  |  |  | Income 6 |  |  |  | 0
28600 | 28900 |  |  | Income 7 |  |  |  | 28709.06
29500 | 29550 |  |  | Income 8 |  |  |  | 62903.65
 |  |  |  | Income 9 |  |  |  | 0
 |  |  | Total Income |  |  |  |  | 7073467.219999999
Spreadsheet: 0e07ee2f-b589-4da7-9847-f5e59864728a
Sheet: Sheet1

Engineering and Electronics Technology* | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Associate of Applied Science Degree
Name |  |  | Student ID Number |  |  |  | Date Entered:
Address |  |  | Phone: |  |  |  | Proposed Graduation Date:
 |  |  | [NAME]:
 |  |  | Student Signature: |  |  |  |  | Date:
 |  |  | Advisor Signature: |  |  |  |  | Date:
 |  |  | Authorizing Signature: |  |  |  |  | Date:
Remedial Courses As Needed |  |  |  | Grade | Semester Taken
010 RDG + 12 DRE - Intro. to [NAME]
020 RDG + 101 GE - Improved College Reading
030 RDG + 101 GE (if not already completed)
090 ENC - Foundations of College Writing I
091 ENC - Foundations of College Writing II
055 MT - Pre-Algebra
065 MT - Elemtary Algebra
120 MT - Intermediate Algebra
General Education Courses (Core Curiculum) |  |  |  |  | Credit  Hours | Grade | Semester Taken | Note
ENG101 - Writing I |  |  |  |  | 3
Communications Course |  |  |  |  | 3
Mathematics Course (MT 150 or MAT 126) |  |  |  |  | 3
Heritage/Humanities Course |  |  |  |  | 3
Social Science Course |  |  |  |  | 3
Physics Course (PHY 171 or higher level) |  |  |  |  | 3-4
Total Gen. [NAME]. Semester Hours |  |  |  |  | 18-19
Technical Core Courses |  |  |  |  | Credit  Hours | Grade | Semester Taken | Note
ELT 110 | Circuits I |  |  |  | 5
ELT 114 | Circuits II |  |  |  | 5
ELT 210 | Devices I |  |  |  | 4
ELT 120 | Digital I |  |  |  | 3
CAD 100 | Introduction to Computer Aided Design OR |  |  |  | 3
 | Equivalent course with consent of APC |  |  |  | 3
 | Computer Literacy Course |  |  |  | 3
ELT289 | ELT Capstone Course |  |  |  | 1
Total Technical Core Hours |  |  |  |  | 24
Electronic Specialization Courses |  |  |  |  | Credit Hours | Grade | Semester Taken | Note
ELT 214 | Devices II |  |  |  | 4 |  |  | Technical Electives:
ELT 220 | Digital II |  |  |  | 3 |  |  | See advisor
Technical Electives - see program coordinator |  |  |  |  | 13
Total Specialization Hours |  |  |  |  | 20
*This curriculum is to be followed by students entering this program beginning Fall 2011 or after.
Spreadsheet: 689036d1596095669-alternative-way-to-make-this-lighter-faster-opb-format-sample-2
Sheet: Sheet1

Electrical Works
Selling Cost | 12677023.59417717
Direct Cost | 9628521.580000002
Level
BF2 | 4.5
BF1 | 4.5
GF | 6
2F | 4.8
3F | 4.8
4F | 3.7
5F | 3.7
6F | 3.7
7F | 4.225
RF | 2.775
Plumbing Works
Selling Cost | 5878913.036011875
Direct Cost
Level
BF2 | 4.5
BF1 | 4.5
GF | 6
2F | 4.8
3F | 4.8
4F | 3.7
5F | 3.7
6F | 3.7
7F | 4.225
RF | 2.775
Fire Protection Works
Selling Cost | 5500175.228141251
Direct Cost
Level
BF2 | 4.5
BF1 | 4.5
GF | 6
2F | 4.8
3F | 4.8
4F | 3.7
5F | 3.7
6F | 3.7
7F | 4.225
RF | 2.775
Spreadsheet: ce930d2f-936f-41f3-a941-5a63210fd1b7
Sheet: Sheet1

THIS WORKSHEET MUST BE RETURNED WITH PAYMENT AND UPDATE APPLICATION | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | COMPANY NAME:
 | Client ID |  |  |  |  | Issue Date
 | Worksheet to determine annual certification fee
Depending on the products produced or services provided, fees could be based on more than one level of this schedule.
If you are certified as a partner with another company and that company pays your fees,  you ARE NOT required to return this worksheet.  Retail Stores certifying departments and Restaurants do NOT need to complete this worksheet (see section D of the OTCO Fee Schedule for applicable fees).
Sales from - to (Month/Year):
Total Organic Sales:
Retail Products *
 |  | Enter Sales amount
 |  | from last fiscal year |  |  |  | Rate |  |  | FEE
$0 to $500,000 enter here ~~~> |  |  |  |  | X | .5% (.005) | = | 0 |  |  | A
$500,001 to $2 Million |  |  |  |  | X | .25% (.0025) | = | 0 |  |  | B
$2,000,001 to $50 Million |  |  |  |  | X | .05% (.0005) | = | 0 |  |  | C
$50,000,001 to $100 Million |  |  |  |  | X | .025% (.00025) | = | 0 |  |  | D
$100,000,001 and over |  |  |  |  | X | .0025% (.000025) | = | 0 |  |  | E
 | Sub Total Sales | 0 |  |  |  | Sub Total Fees |  | 0 |  |  | F
Bulk, Co-packing products *
 |  | Enter Sales amount
 |  | from last fiscal year |  |  |  | Rate |  |  | FEE
$0 to $2 Million enter here~~> |  |  |  |  | X | .1% (.001) | = | 0 |  |  | G
$2,000,001 to $50 Million |  |  |  |  | X | .05% (.0005) |  | 0 |  |  | H
$50,000,001 to $100 Million |  |  |  |  | X | .025% (.00025) | = | 0 |  |  | I
$100,000,001 and over |  |  |  |  | X | .0025% (.000025) | = | 0 |  |  | J
 | Sub Total Sales | 0 |  |  |  | Sub Total Fees |  | 0 |  |  | K
 | Total Sales | 0
 |  |  |  |  | TOTAL ANNUAL FEE (Minimum Fee $1000; Maximum $40,000) |  |  | F + K = | 1000 |  | L
* See page 8 of the fee schedule for definition.
 |  |  |  | Inspection Deposit |  |  |  | + | 200 |  | M
See Example for assistance in completing this form |  |  |  | CAN assessment  (add $295.00) |  |  |  | + |  |  | N
 |  |  |  | EU assessment (add $295.00) |  |  |  | + |  |  | O
 |  | TOTAL DUE |  |  |  |  |  | L + M + N + O = | 1200 |  | P
 | Make checks payable to:  Oregon Tilth, Inc.
 | 260 SW Madison Ave. [NAME] 106 - Corvallis, OR 97333 - Phone (503)378-0690 - Fax (541) 753-4924
Completed by, Signature: _______________________________________
Completed by, Print name: _______________________________________
Date: ____________________________
Spreadsheet: 838085d1690703479-change-sheet-refernce-incrementally-in-adjacent-cells-2023-league-standings-sample-hd
Sheet: T16

Team # | Team Name | Permanent Bowler | Reserves | Lineup | Average | Handicap |  |  |  | Game 1 Scratch | Game 1 Handicap | Game 2 Scratch | Game 2 Handicap | Game 3 Scratch | Game 3 Handicap | Scratch Series | Handicap Series | Indiv Points
16 | Girl Power | Player48 |  |  |  |  |  |  | Week 1
 |  | Player49 |  |  |  |  |  |  | Week 2
 |  | Player50 |  |  |  |  |  |  | Week 3
 |  |  |  |  |  |  |  |  | Week 4
 |  |  |  |  |  |  |  |  | Week 5
 |  |  |  |  |  |  |  |  | Week 6
 |  |  |  |  |  |  |  |  | Week 7
 |  |  |  |  |  |  |  |  | Week 8
 |  |  |  |  |  |  |  |  | Week 9
 | [NAME] |  |  |  |  |  |  |  | Week 10
 |  | Player48 | 84 |  |  |  |  |  | Week 11
 |  | Player49 | 97 |  |  |  |  |  | Week 12
 |  | Player50 | 116 |  |  |  |  |  | Week 13
 |  |  |  |  |  |  |  |  | Week 14
 |  |  |  |  |  |  |  |  | Week 15
 |  |  |  |  |  |  |  |  | Week 16
 |  | Vacant |  |  |  |  |  |  | Week 17
 |  |  |  |  |  |  |  |  | Week 18
 |  |  |  |  |  |  |  |  | Week 19
 | Reserves Lookup |  | Average |  |  |  |  |  | Week 20
 |  |  |  |  |  |  |  |  | Week 21
 |  |  |  |  |  |  |  |  | Week 22
 |  |  |  |  |  |  |  |  | Week 23
 |  |  |  |  |  |  |  |  | Week 24
 |  |  |  |  |  |  |  |  | Week 25
 |  |  |  |  |  |  |  |  | Week 26
 |  |  |  |  |  |  |  |  | Week 27
 |  |  |  |  |  |  |  |  | Week 28
 |  |  |  |  |  |  |  |  | Week 29
 |  |  |  |  |  |  |  |  | Week 30
 |  |  |  |  |  |  |  |  | Week 31
 |  |  |  |  |  |  |  |  | Week 32
 |  |  |  |  |  |  |  |  | Week 33
 |  |  |  |  |  |  |  |  | Week 34
 |  |  |  |  |  |  |  |  | Week 35
 |  |  |  |  |  |  |  |  | Week 36
 | VLOOKUP(B11,C11:C18,1,FALSE) |  |  |  |  |  |  |  | Week 37
 |  |  |  |  |  |  |  |  | Week 38
 |  |  |  |  |  |  |  |  | Week 39
 |  |  |  |  |  |  |  |  | Week 40
 |  |  |  |  |  |  |  |  | Week 41
 |  |  |  |  |  |  |  |  | Week 42
 |  |  |  |  |  |  |  |  | Week 43
 |  |  |  |  |  |  |  |  | Week 44
 |  |  |  |  |  |  |  |  | Week 45
Spreadsheet: 199411d1355211470-how-to-calculate-a-formula-when-an-error-occurs-within-the-related-cells-sample
Sheet: Sheet2

 | CEILINGS
 | Rake out, plaster,paint | 28.2
 | Gap fill and paint | 28.2
 | Remove, dispose, stop, hang and paint lining paper | 66
 | Scrape off, rake out, fill, restipple (excl paint) | 46
 | Remove, dispose, stop, replace gib stop and undercoat | 122.2
 | Rake out, repair lath, plaster cracks and paint | 0
 | WALL COVER
 | Rake out, plaster, paint | 27
 | Remove, rake out, plaster, supply and replace wallpaper | 66
 | Remove, rake out, plaster, paint, supply and replace wallpaper | 85.5
 | Remove, supply, replace lining paper | 40
 | Remove, supply, paint, replace lining paper | 60
 | Rake out, stop | 8.8
 | Paint wall | 24
 | WALL CLADDING
 | Grind out, repoint mortar | 40
 | Relay, re-bed loose bricks | 104
 | Remove, dispose, unstall summer hill stone | 230
 | Remove, dispose, replace bricks | 160
 | FLOOR
 | Grind out, epoxy concrete floor up to 5mm | 120
 | [NAME] and relay | 13
 | Remove, dispose, replace vinyl | 120
 | DOOR
 | Ease door | 80
 | Ease and repaint | 160
Spreadsheet: 188500de-6f0f-40c9-a1e0-2d39510370ad
Sheet: Sheet1

HYPOTHETICAL  ESTATE PLANNING CALCULATIONS | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 |  | Current |  |  | Irrevocable Trust |  |  |  | IDGT
 |  | General |  | General | IRR | Total |  | Other | IDGT | Total
Beginning Values |  | 20000000 |  | 15000000 | 5000000 | 20000000 |  | 15000000 | 5000000 | 20000000
Earnings 7% |  | 36500000 |  | 24600000 | 11000000 | 35600000 |  | 22200000 | 14300000 | 36500000
Less Income Taxes: |  |  |  |  |  | 0
General Investments |  | -9100000 |  | -6200000 |  | -6200000 |  | -5500000 |  | -5500000
Irrevocable Trust |  | 0 |  | 0 | -3800000 | -3800000 |  | 0 |  | 0
IDGT |  | 0 |  | 0 | 0 | 0 |  | -3600000 | 0 | -3600000
Total Taxes |  | -9100000 | 0 | -6200000 | -3800000 | -10000000 |  | -9100000 | 0 | -9100000
Subtotal |  | 47400000 |  | 33400000 | 12200000 | 45600000 |  | 28100000 | 19300000 | 47400000
Living Expenses |  | -13400000 |  | -13400000 | 0 | -13400000 |  | -13400000 | 0 | -13400000
 |  |  |  |  |  | 0 |  |  |  | 0
Ending Values |  | 34000000 |  | 20000000 | 12200000 | 32200000 |  | 14700000 | 19300000 | 34000000
Estimated Estate Taxes
Assets-Ending Values |  | 34000000 |  | 20000000 | 12200000 | 32200000 |  | 14700000 | 19300000 | 34000000
Prior Gifts |  | 0 |  | 5000000 | 0 | 0 |  | 5000000 | 0 | 0
Subtotal |  | 34000000 |  | 25000000 | 12200000 | 37200000 |  | 19700000 | 19300000 | 39000000
 |  |  |  |  |  | 0 |  |  |  | 0
Estate Tax (50%) |  | 17000000 |  | 12500000 | 0 | 12500000 |  | 9850000 | 0 | 9850000
 |  |  |  |  |  | 0 |  |  |  | 0
Net to Beneficiaries |  | 17000000 |  | 7500000 | 12200000 | 19700000 |  | 4850000 | 19300000 | 24150000
Assumptions:
1.  Current situation represents an individual with assets of $20 million, all in investible funds.
2.  Investments earn 7% per year gross.
3.  Income taxes are 25% on general and IDGT investments and 35% on irrevocable trust investments.
4.  Living expenses are $500,000 in year one and increase by the CPI of 3% per year thereafter.
5.  Estate taxes are estimated at 50% of ending value assets plus lifetime "taxable" gifts.
6.  Results reflect estimated ending values in 20 years and net amounts to beneficiaries.
Spreadsheet: 274408d1383108659-finding-values-in-table-a-and-transfering-them-to-table-b-book1-ans1
Sheet: Sheet1

COMPANY | Sales | Margin
COMPANY A | 100 | 0.2
aaa | 200 | 0.21 |  | COMPANY | Sales | Margin
bbb | 300 | 0.22 |  | Company A |  |  |  | Note
cc | 400 | 0.23 |  | Company B |  |  |  | It is assumed that all  company names in Table A are available in Table B.
Installation | 500 | 0.24 |  | Company C |  |  |  | The order of company names should be exactly same in both tables.
xxx | 600 | 0.25 |  |  |  |  |  | Otherwise Sales and Margin data obtained will give wrong result
Freight | 700 | 0.26
COMPANY B | 800 | 0.27
aaa | 900 | 0.28
ff | 1000 | 0.29
dd | 1100 | 0.3
gg | 1200 | 0.31
Freight | 1300 | 0.32
COMPANY C | 1400 | 0.33
tt | 1500 | 0.34
Installation | 1600 | 0.35
uu | 1700 | 0.36
Freight | 1800 | 0.37