tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 150349d1334445950-using-solver-to-maximize-a-value-product-financial-assump-2012
Sheet: Assumptions

 | MONROVIA NURSERY: RESIDENTIAL PRODUCT OPTIMIZATION
 | Program Elements
 |  | Total Site Area |  |  |  |  | sqft |  | 20 | acres
 |  | Retail GFA |  |  |  | 12000 | sqft |  |  | acres
 |  | Park Site Area |  |  |  |  | sqft |  | 0.5 | acres
 |  | Roads Site Area |  |  | 0.1 |  | sqft |  |  | acres
 |  | Site Area: Residential |  |  |  |  | sqft |  |  | acres
 | Residential Program Recommendations
 |  | PRODUCT TYPE | MARKET SEGMENT | DENSITY | WEEKLY ABSORPTION | MIN PROJECT SIZE | MAX PROJECT SIZE | BASE PRICE | AVERAGE HOME SIZE | VALUE RATIO
 |  |  |  | (# of DU/ acres) | (# of DU/ week) | (# of DU) | (# of DU) | ($[NAME]) | (sqft) | ($/sqft)
 | A | Alley-load SFD (40 x 75 lot a total of 3000 sqft) | Young Married, Growing Family & Adult Family | 8 | 1 | 60 | 80 |  | 2200 | 320
 | B | Attached Courtyard | [NAME], Adult Singles Single Parents | 12 | 1.5 | 75 | 125 |  | 1500 | 300
 | C | Tuck-under Townhomes | Young Married & Adult Singles | 20 | 1 | 75 | 125 |  | 1000 | 275
 | D | Podium Multi-family | [NAME] | 50 | 1.5 | 100 | 150 |  | 1900 | 250
 | Other Cost & Value Assumptions
 |  | Land Development Time Frame |  |  |  | 1 | year
 |  | Land Development Costs (onsites and offsites) |  |  |  | 4 | /sqft | Site Area
 |  | Costs of Roads |  |  |  | 6 | /sqft | Road Area
 |  | Less cost of Park Area |  |  |  | 7 | /sqft | Park Area
 |  | Retail Land value (End of Year 1) |  |  |  | 65 | /sqft | Retail Site Area
 |  | Discount Rate |  |  |  | 0.25
 |  | PRODUCT TYPE | DIRECT CONST.  COST | INDIRECT CONST.  COST | FINANCE COSTS | MARKETING COSTS | OVERHEAD COSTS | CONTINGENCY | WARRANTY | LOT IMPROVEMENT
 |  |  | (DC =$/ sqft) | (%of DC) | (%of DC) | (%of DC) | (%of DC) | (%of DC) | (per DU) | (per DU)
 | A | Alley-load SFD | 55 | 0.06 | 0.06 | 0.055 | 0.03 | 0.005 | 2500 | 31250
 | B | Attached Courtyard | 65 | 0.05 | 0.06 | 0.055 | 0.03 | 0.005 | 2250 | 30000
 | C | Tuck-under Townhomes | 85 | 0.05 | 0.06 | 0.055 | 0.03 | 0.005 | 2000 | 18750
 | D | Podium Multi-family | 150 | 0.04 | 0.06 | 0.045 | 0.025 | 0.005 | 4000 | 12500
 | Notes
 | 1 | Steps for optimizing residential product mix
 | a | Figure out costs of developing each residential product type
 | b | Calculate the net profit for each product type
 | c | Check for net profit per acre and time to absorption
 | d | Use annual absorption figure to build a monthly schedule of absorption
 | e | Calculate the cash flows associated with these absorption figure
 | f | Calculate NPV
 | g | Use Solver to Maximize NPV for optimal product mix (set boundary conditions i.e. Maximum product size, residential site area etc.)
 | 2 | Use this value along with retail land value and substract land development costs and discount the residual land value at the end of year 1 to year 0.
Spreadsheet: 44e0349e-7940-470d-ab81-2165784e1e64
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
UIOD | Test | UIOD | Iodine, 24 Hour, [NAME] | Iodine, 24 Hr, U | Inductively Coupled Plasma-Mass Spectrometry (ICP-MS) | [NAME], 24-hour graduated: 24Urine |  |  | 10 | mL | Container/Tube: Plastic, 10-mL urine tube (Supply T068) or clean, plastic aliquot container with no metal cap or glued insert  [NAME]: 10 mL Collection Instructions: 1. Collect urine for 24 hours. 2. No preservative. 3. See Metals Analysis-Collection and Transport in Special Instructions for complete instructions. 4. Refrigerate specimen within 4 hours of completion of 24-hour collection. Additional Information: 1. 24-Hour volume is required. 2. See [NAME] in Special Instructions for multiple collections. 3. If this test is used in conjunction with the (131)I uptake test, then specimen collection should begin immediately after the dose of (131)I is given (ie, the patient should void and discard urine just prior to the (131)I, and all subsequent urine should be collected for the next 24 hours). The last void should be included in the collection.   Urine Preservative Collection Options  Ambient	Yes Refrigerated	Preferred Frozen	Yes 6N HCl	No 50% Acetic Acid	Yes Na2CO3	No Toluene	No 6N HNO3	No Boric Acid	No Thymol	No Forms: If not ordering electronically, submit a General Request Form (Supply T239) with the specimen. | 0.3 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | 0-15 years: not established > or =16 years: 93-1,125 mcg/specimen | Monday, Tuesday, Wednesday, Friday; 5 p.m. | 1 day | 3 days | 1 | 83789 |  |  |  |  | Rochester
UIOD | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 146 days
UIOD | Order Question | TIME5 | Collection Duration |  | Plain Text
UIOD | Order Question | VL23 | [NAME] |  | Plain Text
UIOD | Result | 9549 | Iodine, 24 Hr, U | Iodine, 24 Hr, U | Numeric |  |  |  |  | mcg/spec |  |  |  |  |  |  |  |  |  | 2492-7
UIOD | Result | TIME5 | Collection Duration | Collection Duration | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13362-9
UIOD | Result | VL23 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3167-4
UIOD | Result | 3346 | Iodine Concentration | Iodine Concentration | Numeric |  |  |  |  | mcg/L |  |  |  |  |  |  |  |  |  | 26842-5
Spreadsheet: 671824d1586551586-index-indirect-match-sample
Sheet: Sheet3

Pair | Column 1 | Column 2 | PTP Edit Rationale | CCMI
 | 80047 | 84132 | HCPCS/CPT procedure code definition | 1
 | 80047 | 82374 | HCPCS/CPT procedure code definition | 1
 | 80047 | 82330 | HCPCS/CPT procedure code definition | 1
 | 80047 | 82947 | HCPCS/CPT procedure code definition | 1
 | 80047 | 80051 | HCPCS/CPT procedure code definition | 1
 | 80047 | 82565 | HCPCS/CPT procedure code definition | 1
 | 80047 | 82435 | HCPCS/CPT procedure code definition | 1
Spreadsheet: 41313d1239801231-working-with-lookups-lookup-macro-1
Sheet: Result day 2

Macro produces this from vlookup
Day 2
Date | Ref | Mem No. | Name | Amount to  Release |  | Amount Received
2009-04-15 00:00:00 | TW000927 |  |  |  |  | 96.8
2009-04-15 00:00:00 | N0000031 |  |  |  |  | 82.48
2009-04-15 00:00:00 | JS000014 |  |  |  |  | 71.74
Spreadsheet: 163203d1340220730-matching-values-in-a-table-with-larger-list-of-numbers-and-names-example
Sheet: Sheet1

[NAME] | [NAME]
3002168369 | 2400
3002209337 | 1100
3002209337 | 1200
3002209337 | 1300
3002209337 | 1400
3002209337 | 1600
3002209337 | 1700
3002209337 | 800
3002209337 | 900
3000408917 | 2900
3002552154 | 1000
3002552154 | 2300
3002552154 | 300
3002552154 | 3800
3002757619 | 1100
3002757619 | 1600
3002941321 | 30
3002941321 | 90
3003049769 | 2900
3003049769 | 3000
3003049769 | 3100
Spreadsheet: b9c108fc-1c13-497f-bb95-edbf04fef37d
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
HBF | Test | HBF | [NAME], Blood | [NAME], B | Ion-Exchange/High-Performance Liquid Chromatography (HPLC) | EDTA (lavender-top) tube: EDTA |  |  | 1 | mL | Container/Tube: Preferred: Lavender top (EDTA) Acceptable: ACD (solution B), sodium heparin [NAME]: 3 mL Collection Instructions: Do not transfer blood to other containers. Forms: If not ordering electronically, please submit a Hematopathology/Molecular Oncology Request Form (Supply T241) with the specimen. | 1 mL | Hemolysis	Mild OK; Gross OK Thawing	NA Lipemia	NA Icterus	NA Other	NA | 1-30 days: 22.8-92.0% 1-2 months: 7.6-89.8% 3-5 months: 1.6-42.2% 6-8 months: 0.0-16.7% 9-12 months: 0.0-10.5% 13-17 months: 0.0-7.9% 18-23 months: 0.0-6.3% > or =24 months: 0.0-0.9% | Monday through Saturday | 1 day | 3 days | 1 | 83021 |  |  |  |  | Rochester
HBF | [NAME] | BLOOD | Whole blood |  |  |  | Refrigerated | 10 days
HBF | Result | 8269 | [NAME], B | [NAME], B | Numeric |  |  |  |  | % |  |  |  |  |  |  |  |  |  | 42246-9
HBF | Result | 6812 | Comment | Comment | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 48767-8
Spreadsheet: 36125d1233878542-only-count-a-cell-filled-in-with-color-example
Sheet: Sheet1

FRIDAY
[NAME] | 43205
NUTTAL | 78429
MONDAY
COX | 88468
SMITH | 29995
TUESDAY
PAYNE | 28815
WEDNESDAY
SEATH | 13950
GEDDES | 145564
THURSDAY
BILLIMOORE | 117000
HOBAN | 87000
VINNICOMBE | 109150
FRIDAY
HAMBLIN | 78097
ENGLEFIELD | 80760
Shaded Total
Unshaded Total
Spreadsheet: 7b394a13-6894-474b-b7a0-2fa10ced7a28
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 |  | U.S. Census Bureau
 |  | Source: New Residential Construction
 |  | Housing Units Completed: United States
 |  | Not Seasonally Adjusted Total Units [Thousands of Units]
 |  | Period: 2008 to 2012
 |  | Data Extracted on: September 1, 2014 (5:37 pm)
Year | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
2008 | 93.5 | 87 | 89.8 | 79.6 | 96.5 | 99.7 | 91.5 | 94.5 | 104.2 | 94.1 | 91.5 | 97.8
2009 | 54.7 | 56.5 | 62.1 | 65.5 | 68.1 | 70.3 | 66.4 | 73.9 | 64.4 | 67.4 | 72.6 | 72.4
2010 | 46.3 | 45.4 | 48.6 | 57.7 | 58.7 | 77.7 | 48.2 | 54.6 | 56.7 | 54.8 | 48.3 | 54.7
2011 | 35 | 42 | 43.8 | 42.2 | 45.4 | 50.5 | 53.6 | 57.3 | 54.7 | 52.1 | 50.1 | 58.3
2012 | 36.4 | 39 | 44.4 | 52.3 | 50 | 55.1 | 58.2 | 64.8 | 58.7 | 67.7 | 57.8 | 64.8
Spreadsheet: 289512d1389613438-first-in-first-out-fifo
Sheet: Sheet 2

Item |  |  | TV | "A to B" should be returned with "B to A", but I need the 4-jan to be the first one being returned, then 12-feb, 12-mar, so the next date of "A to B".
From | To | Date | Qty
A | B | 2014-01-04 00:00:00 | 5 | D3 is 5.To empty the cell, it takes 3 from D4 [6-feb], 1 from D5 [7-feb], and 1 from D8 [18-jan] (So,  there's still 2 remain on D8 and 6 still remain on D9) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =3+1+1
B | A | 2014-02-06 00:00:00 | 3
B | A | 2014-02-07 00:00:00 | 1
A | B | 2014-02-12 00:00:00 | 6 | D6 is 6. To empty the cell, it takes 2 from D8 [18-jan] (because 1 has been used for D3), and 4 from D9 [13-mar]( So, there's still 2 remain on D9) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =2+4
A | B | 2014-03-12 00:00:00 | 7 | [NAME] is 7. To empty the cell, it takes 2 from D9 [13-mar] (because 4 has been used for D6). D7 remain 5. |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =2
B | A | 2014-01-18 00:00:00 | 3
B | A | 2014-03-13 00:00:00 | 6
 |  | price: | 2
Spreadsheet: 598901d1542784510-help-with-formulas-to-perform-indexation-to-rental-income-on-annual-semi-annual-etc-dummy-file-20112018-1-ans1
Sheet: Income Calc

 | Helper column
 |  | Tenant 1 | 1
 |  | [NAME] | 1
 |  | Tenant 3 | 1
 |  |  | I want to add formulas here with the below outcome. The idea is to add a formula which takes into account number of years in tab "Rent Roll". I.e if [NAME] is 1 year then tenant 1 here have indexation every year - see correct end result below under tenant 1. Same for tenant 2 and so on, if tenant 2 has "2 year in D4 on tab "rent roll" the indexation will take place every second year. Indexation is supposed to happen in 1st quarter when the rent is subject to indexation
 | NOTE: Column D is changed
 |  | What I like to achieve by adding a dynamic formula
 |  |  | Tenant 1 | 1 | 1 | 1
 |  |  | [NAME] | 1 | 1 | 1 | 1 | 1.0302 | 1.0302 | 1.0302 | 1.0302 | 1.0302 | 1.0302 | 1.0302 | 1.0302 | 1.08232812 | 1.08232812 | 1.08232812 | 1.08232812 | 1.08232812 | 1.08232812 | 1.08232812 | 1.08232812
 |  |  | Tenant 3 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1.061106 | 1.061106 | 1.061106 | 1.061106 | 1.061106 | 1.061106 | 1.061106 | 1.061106 | 1.061106 | 1.061106 | 1.061106 | 1.061106
 |  | Revised
 |  |  | 2017-12-31 00:00:00 | 2018-03-31 00:00:00 | 2018-06-30 00:00:00 | 2018-09-30 00:00:00 | 2018-12-31 00:00:00 | 2019-03-31 00:00:00 | 2019-06-30 00:00:00 | 2019-09-30 00:00:00 | 2019-12-31 00:00:00 | 2020-03-31 00:00:00 | 2020-06-30 00:00:00 | 2020-09-30 00:00:00 | 2020-12-31 00:00:00 | 2021-03-31 00:00:00 | 2021-06-30 00:00:00 | 2021-09-30 00:00:00 | 2021-12-31 00:00:00 | 2022-03-31 00:00:00 | 2022-06-30 00:00:00 | 2022-09-30 00:00:00 | 2022-12-31 00:00:00
 |  |  | Tenant 1 |  | 1.01 | 1.01 | 1.01 | 1.0302 | 1.0302 | 1.0302 | 1.0302 | 1.061106 | 1.061106 | 1.061106 | 1.061106 | 1.08232812 | 1.08232812 | 1.08232812 | 1.08232812 | 1.136444526 | 1.136444526 | 1.136444526 | 1.136444526
 |  |  | [NAME] | 1 | 1 | 1 | 1 | 1.01505 | 1.01505 | 1.01505 | 1.01505 | 1.01505 | 1.01505 | 1.01505 | 1.01505 | 1.0405785075 | 1.0405785075 | 1.0405785075 | 1.0405785075 | 1.0405785075 | 1.0405785075 | 1.0405785075 | 1.0405785075
 |  |  | Tenant 3 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1.04562128125 | 1.04562128125 | 1.04562128125 | 1.04562128125 | 1.04562128125 | 1.04562128125 | 1.04562128125 | 1.04562128125 | 1.04562128125 | 1.04562128125 | 1.04562128125 | 1.04562128125
Spreadsheet: 03d5e858-3b4a-4531-b503-7fa64f2d87bb
Sheet: 2004

School of Nursing 2004
 |  | BSN |  | MEPN |  | Masters |  | Doctoral |  | School Totals |  | Total Grad
Total Number |  | 194 |  | 20 |  | 237 |  | 85
Ethnic Diversity
Citizens/Permanent Residents
American Indian or Native Am. |  | 4 |  | 0 |  | 5 |  | 0
Asian or Asian American |  | 35 |  | 2 |  | 14 |  | 3
African American |  | 14 |  | 0 |  | 2 |  | 2
Hispanic or Latino |  | 9 |  | 2 |  | 4 |  | 3
Hawaiian or Pacific Islander |  | 2 |  | 0 |  | 1 |  | 0
White |  | 113 |  | 13 |  | 184 |  | 46
Not Indicated |  | 16 |  | 3 |  | 17 |  | 1
International Students |  | 1 |  | 0 |  | 10 |  | 30
Minority
Underrepresented Minority
**Based on Autumn quarter 10th census data / Seattle campus only
***Underrepresented students do not include Asian or Asians Americans
Spreadsheet: 879238d1726680863-create-a-separate-workbook-that-holds-a-live-copy-of-one-sheet-shooting-team-record-dummy
Sheet: Student_Raw

Name | Prefered Name | Surname | Year | House | [NAME] | Experience | Dominant Hand | Comment | Date Added | Number of Practices Completed | Average Score | [NAME] | Shooting Team
 | [NAME] | Smith | Yr 8 | [NAME] | [EMAIL] | Complete Novice (never held a rifle) | Left | I have used a shotgun | 2024-09-17 14:18:39 |  |  |  | Jnr
 | [NAME] | Doe | Yr 8 | [NAME] | [EMAIL] | Complete Novice (never held a rifle) | Right | I use an air rifle on the farm | 2024-09-17 14:20:03 |  |  |  | Snr
 | One | Any | Yr 8 | [NAME] | [EMAIL] | Complete Novice (never held a rifle) | Right |  | 2024-09-17 00:00:00
Spreadsheet: john_griffith__15565__ALL Gas Marketing
Sheet: vpp

 | HALL HOUSTON VPP
 |  | PRICING POINT | TRANSPORT/FUEL | FLOW
 | SP 18 | TRCO ZN3 | $0.0794 & .45% | To Pioneer's SP 13 [?], then to TRCO [meter #0067].  Per KCS, says directly into TRCO, no costs to TRCO.
 | SP 14/15 | TENN LA [ZN 1] |  | To [NAME] d'arc's STim 34, then to TENN [meter #019012 - 500 leg].
 | Verm 320 | NGPL LA | $0.1414 & .7% | Into Stingray @ #[NAME], then to NGPL.
 | Verm 325 | NGPL LA | $0.1414 & .7% | To KCS' [NAME], then into Stingray @ #[NAME], then to NGPL.
 | WCam 149 | ANR LA |  | To WCam 167, then ANR [meter #186211].  Per KCS, no cost to get to WCam 167.
 | ECam 160 | TETCO WLA |  | Ties in directly to TETCO @ #71474.
 | HI A327 | ANR LA | $0.1294 & 1% | Ties into ANR lateral [$0.005 fee], then to HIOS [$0.1244, 1%], then to either ANR [SE] or UTOS.  [NAME], but currently not processing, thus, must flow to UTOS.
 | Note that KCS did this deal @ a Henry Hub NYMEX price, and that [NAME] did the basis swap.  [NAME] keeps KCS whole on all transport charges AND the basis diff from [NAME] to the pricing point each month.
Spreadsheet: 742032d1627482908-how-to-grab-a-number-adjacent-to-a-call-containing-searched-text-help
Sheet: Data Input

Company Balance Sheet
 |  |  | Balance | Current
Assets
103-00          Petty Cash |  |  | 77 | 8979
105-00          Security Deposits |  |  | 6546 | 654
106-00          Checking Account |  |  | 5416 | 54
107-00          Checking Account |  |  | 746 | 845
108-00          Cash investments |  |  | 65 | 183
Subtotal
111-00          Accts Receivable |  |  | 521665 | 654869
112-00          Other Receivables |  |  | 54165 | 53185
113-00          Allowance for Doubtful Accounts |  |  | 6523165 | 498
Subtotal
120-00          Costs in excess of billings |  |  | 451 | 654
121-00          Unbilled Services |  |  | 645 | 541
Subtotal
151-00          Furniture and Fixtures
151-01          Capital lease asset
152-00          Accumulated Deprec
152-01          Accum depreciation Capital Lease
153-00          Leasehold Improvements
154-00          Accumulated Amortiz
Subtotal
172-00          Prepaid Expenses
Subtotal
Total Assets
Liabilities
210-00          Accts Payable-Trade
211-00          Accrued Expenses
213-00          FBP-Medical Reimbursement
214-00          FBP-Child Care Reimbursement
215-00          Medical claims payable
217-00          Dental ins withholding
218-00          HSA Employer Liability
219-00          NYS Paid Family Leave Ded
Subtotal
220-00          Billings in excess of costs
Subtotal
231-00          Salaries Payable
233-00          Accrued vacation
235-00          Accrued Loss on Contracts
Subtotal
240-00          Supplemental Life W/H
241-00          Federal Income Taxes Payable
242-00          State Income Taxes Payable
243-00          401(K) Employer Contributions
244-00          401(K) Profit Sharing Contribution
Subtotal
251-00          Line/Letter of Credit
252-00          BSB Construction Note
Subtotal
260-00          Capital lease obligation
264-00          Note Payable - APT
269-00          Note Payable -JLH
Subtotal
271-00          Note Payable - RTB
272-00          Note Payable - RFW
Subtotal
290-00          Deferred Income Taxes
Subtotal
Total Liabilities
Net Worth
301-00          Common Stock
302-00          Treasury Stock
Subtotal
310-00          Add'l Paid In Capital
311-00          Prev Yrs Retained Earngs
312-00          Current Yrs Profit(Loss)
Subtotal
Total Net Worth
Total Liabilities and Net Worth
Spreadsheet: 727213d1617777730-start-list-on-first-friday-of-the-month-yearly-calendar
Sheet: 2021

2021-01-01 00:00:00
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Trump
Spreadsheet: 731056d1620143280-formulas-and-drop-down-lists-workload_dashboard
Sheet: Resource Naming

Production |  |  |  | Development
Azure Region | West Europe |  |  | Azure Region | South Africa North
Company | Company1 |  |  | Company | Company2
Application | QlikView |  |  | Application | QlikView
Subscription | Production |  |  | Subscription | Development
Resource Type | virtualMachines |  |  | Resource Type | virtualNetworks
Resource Group Number | First |  |  | Resource Group Number | Second
Resource Type Number | First |  |  | Resource Type Number | Second
Resource Name Base |  |  |  | Resource Name Base
Resource Group Name |  |  |  | Resource Group Name
Resource Type Name |  |  |  | Resource Type Name
Spreadsheet: 90789d1290528843-excel-2007-rank-and-award-points-on-2-columns-one-ascending-and-one-descending-example
Sheet: Sheet1

Team | Cows | Time |  |  |  |  |  |  | Team | Cows | Time | Rank | Points |  |  |  | Place | Points
1 | 8 | 00:01:30 | 0.0001302083333333333 | 9 | 11 |  |  |  | 19 | 11 | 02:00:00 |  |  |  |  |  | 1st | 20
2 | 8 | 00:01:24 | 0.0001215277777777778 | 7 | 13 |  |  |  | 18 | 9 | 01:50:00 |  |  |  |  |  | 2nd | 19
3 | 5 | 00:01:00 | 0.0001388888888888889 | 10 | 10 |  |  |  | 1 | 8 | 00:10:00 |  |  |  |  |  | 3rd | 18
4 | 6 | 00:02:00 | 0.0002314814814814815 | 15 | 5 |  |  |  | 8 | 8 | 01:24:00 |  |  |  |  |  | 4th | 17
5 | 3 | 00:00:20 | 7.716049382716049e-05 | 3 | 17 |  |  |  | 9 | 8 | 02:00:00 |  |  |  |  |  | 5th | 16
6 | 4 | 00:00:38 | 0.0001099537037037037 | 5 | 15 |  |  |  | 7 | 7 | 00:50:00 |  |  |  |  |  | 6th | 15
7 | 7 | 00:01:50 | 0.0001818783068783069 | 14 | 6 |  |  |  | 4 | 6 | 00:20:00 |  |  |  |  |  | 7th | 14
8 | 2 | 00:00:24 | 0.0001388888888888889 | 10 | 10 |  |  |  | 17 | 6 | 01:50:00 |  |  |  |  |  | 8th | 13
9 | 8 | 00:02:00 | 0.0001736111111111111 | 13 | 7 |  |  |  | 12 | 6 | 02:00:00 |  |  |  |  |  | 9th | 12
10 | 2 | 00:01:00 | 0.0003472222222222222 | 18 | 2 |  |  |  | 3 | 5 | 01:00:00 |  |  |  |  |  | 10th | 11
11 | 4 | 00:01:34 | 0.0002719907407407407 | 17 | 3 |  |  |  | 6 | 4 | 01:38:00 |  |  |  |  |  | 11th | 10
12 | 6 | 00:02:00 | 0.0002314814814814815 | 15 | 5 |  |  |  | 11 | 4 | 02:00:00 |  |  |  |  |  | 12th | 9
13 | 3 | 00:00:10 | 3.858024691358025e-05 | 1 | 19 |  |  |  | 13 | 3 | 00:10:00 |  |  |  |  |  | 13th | 8
14 | 2 | 00:01:23 | 0.000480324074074074 | 20 | 0 |  |  |  | 5 | 3 | 00:20:00 |  |  |  |  |  | 14th | 7
15 | 1 | 00:00:30 | 0.0003472222222222222 | 18 | 2 |  |  |  | 20 | 2 | 00:10:00 |  |  |  |  |  | 15th | 6
16 | 1 | 00:00:10 | 0.0001157407407407407 | 6 | 14 |  |  |  | 2 | 2 | 00:45:00 |  |  |  |  |  | 16th | 5
17 | 6 | 00:00:55 | 0.0001060956790123457 | 4 | 16 |  |  |  | 14 | 2 | 01:23:00 |  |  |  |  |  | 17th | 4
18 | 9 | 00:02:00 | 0.000154320987654321 | 12 | 8 |  |  |  | 10 | 2 | 02:00:00 |  |  |  |  |  | 18th | 3
19 | 11 | 00:02:00 | 0.0001262626262626263 | 8 | 12 |  |  |  | 15 | 1 | 01:30:00 |  |  |  |  |  | 19th | 2
20 | 2 | 00:00:10 | 5.787037037037037e-05 | 2 | 18 |  |  |  | 16 | 1 | 02:00:00 |  |  |  |  |  | 20th | 1
Spreadsheet: 884329d1733417026-blended-rate-tiered-commission-book1-3-
Sheet: Sheet2

 |  |  |  |  | From | To | Realtor
 |  |  |  |  | 0 | 2000000 | 0.5 |  | This is the sales tier/split
 |  |  |  |  | 2000000.01 | 3000000 | 0.6 |  | As YTD sales grow, the % is split changes
 |  |  |  |  | 3000000.01 | 5000000 | 0.7
 |  |  |  |  | 5000000.01 | 10000000 | 0.8
 |  |  |  |  | 10000000 | 100000000 | 0.9
 |  |  |  |  | Client Name | Location | [NAME] OR Buyer | Quarter | Sales Price | YTD Sales | Commission | GCI | Fixed | 0.06 | 0.1 | Comission Check |  | FORMULA?
 |  |  |  |  | Sale 1 |  |  |  | 1200000 |  | 0.025 |  | 250
 | I would like to show full sale price of These two at 1.1MM rather than split |  |  |  | Sale 2 |  |  |  | 800000 |  | 0.0275 |  | 250 |  |  |  |  |  | $800K (of Commission Check) is split at 50%, while the remaining $300K is split at 60%
 |  |  |  |  | Sale 2 |  |  |  | 300000 |  | 0.0275 |  | 250
 |  |  |  |  | Sale 3 |  |  |  | 1100000 |  | 0.0275 |  | 250
 |  |  |  |  | Sale 4 |  |  |  | 1800000 |  | 0.03 |  | 250 |  |  |  |  |  |  | Blended Rate
 |  |  |  |  | Sale 5 |  |  |  | 2900000 |  | 0.025 |  | 250
 |  |  |  |  | Sale 6 |  |  |  | 5000000 |  | 0.03 |  | 250
 |  |  |  |  | Sale 7 |  |  |  | 1000000 |  | 0.025 |  | 250
 |  |  |  |  | Sale 8 |  |  |  | 1800000 |  | 0.025 |  | 250
 |  |  |  |  | Sale 9 |  |  |  | 1250000 |  | 0.025 |  | 250
 |  |  |  |  | Sale 10 |  |  |  | 500000 |  | 0.025 |  | 250
Spreadsheet: tracy_geaccone__40416__Expense Analysis
Sheet: Sheet1

 | OCTOBER
 | PLAN | ACTUALS |  | NOV | NOV |  | DEC | DEC |  | PLAN | ACTUALS
 | YTD | YTD |  | PLAN | CE |  | PLAN | CE |  | YTD | YTD
Regulatory |  |  |  | -0.704 | -0.704 |  | -0.732 | -0.732
O&M Expenses |  |  |  | -0.156 | -0.163 |  | -0.358 | -0.164
Aviation | -0.3 | 0 |  | 0 | 0 |  | -0.1 | -0.1
Other/Revenue Mangement |  | 0.048 |  | 0 | 0 |  | -0.1 | -0.06
This analysis does not include UAF