tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: c0b58ea3-9917-42d0-9741-27d32f000a0e
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2011-02-09 14:27:20.890000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
5.375 | 101.567 | 101.567 | 101.442 | 100.942 |  | and are added to price quote
5.25 | 100.672 | 100.672 | 100.547 | 100.047
5.125 | 99.70899999999999 | 99.70899999999999 | 99.58399999999999 | 99.08399999999999 |  | Note: | Refer To Price [NAME]
5 | 98.92 | 98.92 | 98.795 | 98.295 |  |  | For all Price Adjs
4.875 | 98.776 | 98.776 | 98.651
4.75 | 97.78099999999999 | 97.78099999999999 | 97.65599999999999
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4.75 | 101.711 | 101.711 | 101.586 | 101.086
4.625 | 100.448 | 100.448 | 100.323 | 99.823
4.5 | 100.237 | 100.237 | 100.112 | 99.612
4.375 | 99.93 | 99.93 | 99.805 | 99.305
4.25 | 99.425 | 99.425 | 99.3
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2011-02-09 14:27:20.890000
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2011-02-23 14:27:20.890000
30 DAY | 2011-03-10 14:27:20.890000
45 DAY | 2011-03-25 14:27:20.890000
60 DAY | 2011-04-09 14:27:20.890000
90 DAY | 2011-05-09 14:27:20.890000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 81735d1281907662-formulas-previously-working-now-resulting-in-0-trimmean-average-formulas-used-excel-help-forum-rev1
Sheet: Tuesday Prep

Tuesday |  |  | Need | Have | Make | Initial
Dough | Pans (44 = 1 Batch)
 | Mids (68 = 1 Batch)
 | Thins (72 = 1 Batch)
 | Personals
Mids | Meatlovers
 | Hawaiian
 | Supreme
 | Pepperoni
Pans | Meatlovers
 | Hawaiian
 | Supreme
 | Pepperoni
Thins | Pepperoni
TO BE COMPLETED AFTER DOUGH AND PRE-MAKES WITH MAKE-BENCH FULL
Cheese | Containers (Coolroom) |  | 3
 | X.Large Bains ([NAME]) |  | 4
Pineapple | [NAME] ([NAME]) |  | 4
Capsicum | Buckets (Coolroom) |  | 1.5
Onion | Buckets (Coolroom) |  | 1.5
Mushrooms | Cartons (Coolroom) |  | 2
Olives | Small Bains ([NAME] fridge) |  | 1
Sauces | [NAME] ([NAME] fridge) |  | 2
 | Tomato Sauce Buckets (Cool Room) |  | 3
 | [NAME] ([NAME] fridge) |  | 2
Wings | Packets (Makebench fridge) |  | 6
Ribs | Packets (Makebench fridge) |  | 9
Steak | Small Bains ([NAME] fridge) |  | 2
Pork | Small Bains ([NAME] fridge) |  | 1
Meat Mix | Buckets (Cool Room) |  | 2
Spreadsheet: 01e7c198-21bd-46da-b5f1-2ad3bea08048
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | ASSET FORM | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
SCHOOL OF PSYCHOLOGY
ASSET ADDITION
Asset Number: |  | 5248/                                    /000
Description of Asset:
Serial No: |  |  |  |  |  |  | Model:
Building Name: |  |  |  |  |  |  | Room No:
Employee Responsible for Asset:
Asset to be taken off campus:  YES/NO  (Please circle)   If Yes, Off Campus Form Completed?:
Asset Number Sticker Affixed By: |  |  |  |  |  |  | Date Affixed:
Date Asset Engraved:
ASSET RETIREMENT
Retired Asset Number: |  |  | 5248/                        /000 |  |  |  | Retirement Date:
Description of Asset:
Reason for Retirement (see below):
Descriptions:
Damaged: [NAME] has been damaged beyond repair and is no  longer in use
Donated to External Body: Item has been donated to a body/individual external to the University
Scrapped: Item no longer provides an economic benefit to UQ or is technically obsolete
Sold to External Body: Item has been sold to a body/individual external to the University
Stolen: [NAME] has been stolen or knowingly lost eg. Left on a bus
Trade In: Item has been traded in to a body/individual external to the University
Other: [NAME] has been disposed for a reason not listed.
Finance Office to [NAME]:
PO Number:
Asset Addition: |  | Unifi Receipt No __________________ |  |  |  | Entered into Asset Register by?  ___________
Asset Retirement: |  | Asset Disposal Form Completed by:
 |  | Sent to [EMAIL]  on:
 |  | Account to which proceeds were deposited:
 |  | Amount of Cash proceeds: |  |  |  |  | Account:
Spreadsheet: 82958d1282938178-caculating-the-difference-in-a-pivot-table-caculate-pivot-example
Sheet: Sheet1

Year | FY | Type | SubType |  |  | Pivot 1
2011 | 10 | Pet | Dog
2010 | 15 | Non Pet | [NAME] |  |  |  |  |  | Year
2011 | 8 | Pet | Dog |  |  | Type | SubType | Data | 2010 | 2011
2010 | 7 | Non Pet | [NAME] |  |  | Pet | Cat | Sum of FY | 118
2011 | 6 | Non Pet | Ferret |  |  |  |  | Diff |  | -118
2010 | 19 | Pet | Cat |  |  |  | Dog | Sum of FY | 55 | 125
2011 | 21 | Pet | Dog |  |  |  |  | Diff |  | 70
2010 | 33 | Non Pet | Ferret |  |  | Non Pet | [NAME] | Sum of FY | 22
2011 | 72 | Pet | dog |  |  |  |  | Diff |  | -22
2010 | 55 | Pet | Dog |  |  |  | Ferret | Sum of FY | 33 | 6
2011 | 76 | Non Pet | Snake |  |  |  |  | Diff |  | -27
2010 | 99 | Pet | Cat |  |  |  | Snake | Sum of FY | 13 | 76
2011 | 14 | Pet | Dog |  |  |  |  | Diff |  | 63
2010 | 13 | Non Pet | Snake
How I want |  |  |  |  |  |  |  |  |  |  |  | Pivot 2
 |  | Data | Year |  |  |  |  |  |  |  |  |  |  | Data | Year
 |  | Sum of FY |  |  |  |  |  |  |  |  |  |  |  | Sum of FY |  | Diff
Type | SubType | 2010 | 2011 | Diff |  |  |  |  |  |  |  | Type | SubType | 2010 | 2011 | 2010 | 2011
Pet | Cat | 118 |  | -118 |  |  |  |  |  |  |  | Pet | Cat | 118 |  |  | -118
 | Dog | 55 | 125 | 70 |  |  |  |  |  |  |  |  | Dog | 55 | 125 |  | 70
Non Pet | [NAME] | 22 |  | -22 |  |  |  |  |  |  |  | Non Pet | [NAME] | 22 |  |  | -22
 | Ferret | 33 | 6 | -27 |  |  |  |  |  |  |  |  | Ferret | 33 | 6 |  | -27
 | Snake | 13 | 76 | 63 |  |  |  |  |  |  |  |  | Snake | 13 | 76 |  | 63
Spreadsheet: 776940d1650011524-un-text-numbers-in-filtered-data-test-filter
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-02-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-02-28 00:00:00
 | 2022-02-10 00:00:00 | 21252973 | 34EAY791 | 44574.56940972222 | 44576.49326388889 | 13 | 15.34 | 0 | -15.34 | 0 | yes
AAA | 2022-02-10 00:00:00 | 21252973 | 34EAY849 | 44576.49327546296 | 44606.57421296297 | 84.5 | 99.71 | 0 | -99.71 | 0 | yes
AAA | 2022-02-22 00:00:00 | 21286472 | 34EAY847 | 44586.67990740741 | 44616.699375 | 1038.75 | 1225.73 | 1396.5 | 170.77 | 0 | 0
CCC | 2022-02-02 00:00:00 | 21386309 | 34DZE265 | 44587.45758101852 | 44594.43201388889 | 5.75 | 6.79 | 0 | -6.79 | 0 | 0
CCC | 2022-02-03 00:00:00 | 21412720 | 34EAY850 | 44593.69423611111 | 44595.4981712963 | 14.5 | 17.11 | 35 | 17.89 | 0 | 0
DDD | 2022-02-18 00:00:00 | 21456238 | 34DYN110 | 44604.32568287037 | 44611.32907407408 | 29.5 | 34.81 | 11.8 | -23.01 | 0 | 0
EEE | 2022-02-01 00:00:00 | 21308722 | 34DZD645 | 44567.59796296297 | 44594.63152777778 | 211.25 | 249.28 | 266 | 16.72 | 0 | 0
EEE | 2022-02-01 00:00:00 | 21311591 | 34EVF059 | 44584.78908564815 | 44593.55697916666 | 184 | 217.12 | 177 | -40.12 | 0 | 0
EEE | 2022-02-28 00:00:00 | 21354809 | 34DYZ460 | 44611.42070601852 | 44620.4650462963 | 131.75 | 155.47 | 203.5 | 48.03 | 0 | 0
FFF | 2022-02-28 00:00:00 | 21413462 | 34DYN598 | 44617.78795138889 | 44620.83331018518 | 23 | 27.14 | 18 | -9.14 | 0 | 0
FFF | 2022-02-28 00:00:00 | 21438720 | 34EVE922 | 44599.70461805556 | 44601.76361111111 | 39.5 | 46.61 | 30.33 | -16.28 | 0 | yes
FFF | 2022-02-28 00:00:00 | 21438720 | 34DYN417 | 44601.76362268518 | 44613.57222222222 | 247 | 291.46 | 189.67 | -101.79 | 0 | yes
FFF | 2022-02-28 00:00:00 | 21515174 | 34DZD334 | 44616.58288194444 | 44620.38958333333 | 218 | 257.24 | 203.25 | -53.99000000000001 | 0 | 0
Spreadsheet: 482328d1475010455-ranking-based-on-conditions-mock-report
Sheet: Ranking

 | [NAME] |  |  |  |  | Example 1
 | Select Contract |  |  |  |  | Select Contract
 | Select Division |  |  |  |  | Select Division | Division 2
 | Select BU |  |  |  |  | Select BU
 |  | [NAME] (Row 2) | GL (Column C) | [NAME] (columns G/J/M/P/S) |  |  | [NAME] (Row 2) | GL (Column C) | [NAME] (columns G/J/M/P/S)
 | Rank Variance 1 |  |  |  |  | Rank Variance 1 | Contract 3 | External Revenue | 2927
 | Rank Variance 2 |  |  |  |  | Rank Variance 2 | Contract 2 | External Revenue | 986
 | Rank Variance 3 |  |  |  |  | Rank Variance 3 | Contract 3 | Facility Costs | 797
 | Rank Variance 4 |  |  |  |  | Rank Variance 4 | Contract 2 | Asset Amortisation | 416
 | Rank Variance 5 |  |  |  |  | Rank Variance 5 | Contract 3 | Communications | 365
Spreadsheet: 686753d1594802461-conditional-addition-payroll-test
Sheet: Monthly

Monthly  Tax Calculator
Tax Table | 1 | 2 | 3 | 4 | 5 | 6
Compensation Range | 0 to 20,832 | 20,834 to 33,332 | 33,334 to 66,664 | 66,666 to 166,664 | 166,666 to 666,664 | 666,666 to 1,000,000
Withholding Tax | 0.00 + 0% over | 0.00 +20% over | 1,250.00 + 25% over | 5,416.67 + 30% over | 20,416.67 + 32% over | 100,416.67 + 35% over
Monthly Salary | 22500
SSS
Philhealth |  |  |  |  |  |  |  |  |  |  |  | BIR TAX TABLE
Pag Ibig Premium | 100 |  |  |  |  |  |  |  |  |  |  | [NAME] (ANNUAL) | INCOME TAX RATE
Bonus |  |  |  |  |  |  |  |  |  |  |  | 250000 and below | 0
13th Month Pay |  |  |  |  |  |  |  |  |  |  |  | 250000.01 to 400000 | 20% of the excess over 250000
Other Adjustment |  |  |  |  |  |  |  |  |  |  |  | 400000.01 to 800000 | 30000 + 25% of the excess over 400000
[NAME] |  |  |  |  |  |  |  |  |  |  |  | 800000.01 to 2000000 | 130000 + 30% of the excess over 800000
OT Meal allowance |  |  |  |  |  |  |  |  |  |  |  | 2000000.01 to 8000000 | 490000 + 32% of the excess over 2000000
Abcenses/tardiness |  |  |  |  |  |  |  |  |  |  |  | 8000000.01 and above | 2410000 + 35% of the excess over 8000000
Taxable Income
Withholding Tax
 |  |  |  |  |  |  |  |  |  |  |  | Taxable Income | 35000
 |  |  |  |  |  |  |  |  |  |  |  | Income Tax
 |  |  |  |  |  |  |  |  |  |  |  | Taxable Income | 35000
 |  |  |  |  |  |  |  |  |  |  |  | Income Tax
 |  |  |  |  |  |  |  |  |  |  |  | FROM | TO
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 20832 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 20834 | 33332 | 0 | 0.2
 |  |  |  |  |  |  |  |  |  |  |  | 33334 | 66664 | 30000 | 0.25
 |  |  |  |  |  |  |  |  |  |  |  | 66666 | 166664 | 130000 | 0.3
 |  |  |  |  |  |  |  |  |  |  |  | 166666 | 666664 | 490000 | 0.32
 |  |  |  |  |  |  |  |  |  |  |  | 666666 | 99999999 | 2410000 | 0.35
 |  |  |  |  |  |  |  |  |  |  |  |  | 2410000
Spreadsheet: 1abeb744-2d3e-4c4a-921f-d6c04d8f5fec
Sheet: Setting codes

SFY 2015 STATE CODE SHEET
SFY 2015 STATE EDRS-UFARS codes crosswalk
EDRS Setting Codes
Setting Codes Required for Personnel Type Codes 01 and 07 on EDRS
Ages 6 to 21 and Birth thru 2
Setting code | [NAME]
A | Regular Class
B | Resource Room
C | Separate Class
D | Public Separate Day School
F | Public Residential
G | Private Residental
H | Home Based/Homebound/Hospital (use with FSC c Birth-2)
I | Lead teacher Provides No Direct Service
line left blank intentionally
Ages 3 Through 5
Setting code | [NAME]
Y | Early Childhood 3-5
end of worksheet
Spreadsheet: 89568732-7eb1-43ff-983c-7953a060527f
Sheet: Inputs

 | Iowa and Nebraska Dairy Budgets
 |  |  | October 2010
 |  |  | Milk Components & Prices
 |  |  | BF% | 3.66
 |  |  | Protein% | 3.15
 |  |  | Other solids% | 5.73
 |  |  | scc | 234
 |  |  | BF price | 2.4436
 |  |  | Protein price | 2.4739
 |  |  | Other solids price | 0.1736
 |  |  | PPD | 0.41
 |  |  | SCC adjustment | 0.00088
 |  |  | MILC | 0
 |  |  | Feed prices
 |  |  | Corn | 4.96
 |  |  | Soybean meal | 347
 |  |  | Cottonseed | 228
 |  |  | Animal fat | 0.34
 |  |  | Hay | 132.5
 |  |  | Cull Cow Price | 57.5
 | Notes on budget assumptions and prices
 | (a)  [NAME] cow income represents sales of dairy stock, a capital asset.  This income is included to calculate production in terms of milk equivalents. Price fron most recent Iowa weekly slaughter report http://www.ams.usda.gov/mnreports/nw_ls785.txt
 | (b)  A detailed explanation of the feed rations utilized is available upon request from the authors.
 | (c)  Facilities budgeted here represent those needed for a 250 cow herd housed in a freestall and milked in a parlor.
 | (d)  Milk equivalents are calculated by computing the adjusted gross receipts (gross receipts - death loss) then dividing by the total price per cwt. of milk.
 | (e)  The break even milk price is the gross Grade A price per cwt. required in the receipts section, so the budget will cover total costs and labor.
 | (f)   Corn price obtained from Monthly Grain report Omaha/Council Bluffs http://www.ams.usda.gov/mnreports/wh_gr110.txt. Fat & Soybean Meal prices are obtained from the most recent Minneapolis Weekly Feedstuffs report, http://www.ams.usda.gov/mnreports/ms_gr852.txt
 | Cottonseed price from most recent Feedstuffs magazine. Hay price obrained from NE/IA Weekly hay report, http://www.ams.usda.gov/mnreports/sc_gr310.txt, Premium quality alfalfa large squares.
 | (g)  Other costs revised August 2009
 | Prepared by: [NAME], Extension Farm Management Specialist, [NAME], Extension Dairy Specialist,
 | and [NAME], Extension Dairy Specialist, Iowa State University.
 | Revised by: [NAME], Extension Educator, UN-L, June 2010
Spreadsheet: 507e0b7d-7ba4-488c-909d-9be97f7ee31d
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
6748 | 50164 | Carmenza | Morales | COL | 19 | 00:24:00 | 00:01:23 | [NAME] | 00:00:48 | 01:38:19 | 1 | 05:01:05
6748 | 5389 | Fiorella | D'Croz | COL | 17 | 00:20:14 | 00:01:01 | 02:57:07 | 00:01:02 | 01:42:35 | 2 | 05:01:59
6748 | 21009 | Karina | Fernandez | CRC | 18 | 00:22:49 | 00:01:23 | 03:05:48 | 00:01:04 | 01:38:17 | 3 | 05:09:23
6748 | 50042 | Lotty | [NAME] | PAN | 20 | [NAME] | 00:01:33 | [NAME] | 00:00:49 | 01:48:13 | 4 | 05:18:23
6748 | 44272 | Cristina | Mata | PAN | 21 | [NAME] | 00:01:25 | 02:55:00 | 00:01:18 | 01:59:01 | 5 | 05:26:17
6748 | 51498 | [NAME] | Real | PAN | 22 | 00:27:05 | 00:01:14 | [NAME] | [NAME] | 02:07:06 | 6 | 05:37:46
Spreadsheet: 150077d1334269810-problem-with-ref-errors-ef77_excel-help-forum-example-1
Sheet: Design Narrative

 | Pole Name | Gantry Name
 | Gantry Name
 | Lens Focal Length
 | Arm
 | Camera Position
 | Camera Direction
 | Camera Target
 | Comments
 | Illuminator
 | Illuminator Position
 | [NAME]
 | LPR Capture Direction
 | LPR Target
 | Comments
 | General Comments
 | Pole Name
 | Lens Focal Length
 | Arm
 | Camera Position
 | Camera Direction
 | Camera Target
 | Comments
 | Illuminator
 | Illuminator Position
 | [NAME]
 | LPR Capture Direction
 | LPR Target
 | Comments
 | General Comments
 | Pole Name
 | Lens Focal Length
 | Arm
 | Camera Position
 | Camera Direction
 | Camera Target
 | Comments
 | Illuminator
 | Illuminator Position
 | [NAME]
 | LPR Capture Direction
 | LPR Target
 | Comments
 | General Comments
 | Pole Name
 | Lens Focal Length
 | Arm
 | Camera Position
 | Camera Direction
 | Camera Target
 | Comments
 | Illuminator
 | Illuminator Position
 | [NAME]
 | LPR Capture Direction
 | LPR Target
 | Comments
 | General Comments
 | Pole Name
 | Lens Focal Length
 | Arm
 | Camera Position
 | Camera Direction
 | Camera Target
 | Comments
 | Illuminator
 | Illuminator Position
 | [NAME]
 | LPR Capture Direction
 | LPR Target
 | Comments
 | General Comments
 | Pole Name
 | Lens Focal Length
 | Arm
 | Camera Position
 | Camera Direction
 | Camera Target
 | Comments
 | Illuminator
 | Illuminator Position
 | [NAME]
 | LPR Capture Direction
 | LPR Target
 | Comments
 | General Comments
 | Pole Name
 | Lens Focal Length
 | Arm
 | Camera Position
 | Camera Direction
 | Camera Target
 | Comments
 | Illuminator
 | Illuminator Position
 | [NAME]
 | LPR Capture Direction
 | LPR Target
 | Comments
 | General Comments
Spreadsheet: 812574d1673260736-count-with-two-conditions-book1
Sheet: COUNT

Districts | No | Resolved | In Progress | Unresolved
Delta Fly |  | Count result | count result | count result |  | Count project status for this district
Middle Fly |  | Count result | count result | count result
North Fly |  |  | count result | count result
South Fly |  | Count result | count result | count result
District | Project Status | Count
South Fly | In Progress | 1
North Fly | In Progress | 3
Middle Fly | In Progress | 3
Middle Fly | Resolved | 2
South Fly | Resolved | 2
Delta Fly | Resolved | 1
Delta Fly | In Progress | 3
South Fly | Unresolved | 2
North Fly | Unresolved | 1
Spreadsheet: 177601d1346355656-how-to-populate-workbook-pages-from-microsoft-query-copy-of-total-misses-for-period-6
Sheet: 7-036,069

 |  |  |  |  |  |  |  | 7-036   7-069
 |  |  |  |  |  |  |  | TOTAL MISSES FOR THIS PAY PERIOD
CHPUB | CHACT# | CHDIST | CHRTE | CHTIME | CHTTYP | CHTRCD | UNNBR | PREDIR | STREET | SUFFIX | PSTDIR | SUNTYP | SUNNBR | POZIP5 | CHSTAT | CHSMM | CHSDD | CHSYY
Spreadsheet: 101003d1299178510-array-formula-help-suming-multiple-datasets-example-sumofdatasets
Sheet: Sheet1

 |  |  |  |  | I need an equation which returns the sum of datasets for each field of data, each field of data is spaciailly seperated by 4 rows.
 |  |  |  |  |  | I believe an array formulae will achieve this.
Data 1 | Data 2 | Data 3 | Sum data
 |  |  |  |  | Please note datasets can range from 2 up to 100 in size, but are always spacially seperated by 4 rows
Data 1 | Data 2 | Data 3 | Sum data
Data 1 | Data 2 | Data 3 | Sum data
Spreadsheet: 782268d1653936215-how-to-change-answer-based-on-a-set-of-numbers-and-rounding-formulaforef
Sheet: Sheet1

Inputs |  |  | h1
k | 50 |  | 1 |  | Step 1. | hmax | = | [k/(v*/60)]– | (round down to next acceptable h)
v* | 260 |  | 2 |  | Step 2. | n | = | [cmin/hmax]+
cmin | 51 |  | 5 |  | Step 3. | h | = | [cmin/n]+ | (round up to next acceptable h)
 |  |  | 10 |  | Step 4. | c | = | nh = n/q
 |  |  | 15 |  |  | q | = | 60/h
 |  |  | 20 |  |  | lp | = | v*/q £ k
 |  |  | 25
 |  |  | 30
 |  |  | 35
 |  |  | 40
 |  |  | 45
 |  |  | 50
 |  |  | 55
 |  |  | 60
Spreadsheet: 169152d1342713061-matching-prop-refs-to-addresses-chris-f_071912_grm
Sheet: Costs

Prop Ref | Number | Road | Cost
1335002500 | 25 | ALDER DRIVE | 1213.159728565839
1335002700 | 27 | ALDER DRIVE | 1213.159728565839
1335002900 | 29 | ALDER DRIVE | 1213.159728565839
0 | 31 | ALDER DRIVE | 1213.159728565839
1335002600 | 26 | ALDER DRIVE | 1146.118174658626
1335002800 | 28 | ALDER DRIVE | 1146.118174658626
0 | 30 | ALDER DRIVE | 1146.118174658626
1335003200 | 32 | ALDER DRIVE | 1146.118174658626
1335004200 | 42 | ALDER DRIVE | 1073.782658813208
1335004400 | 44 | ALDER DRIVE | 1073.782658813208
1335004600 | 46 | ALDER DRIVE | 1073.782658813208
1335004800 | 48 | ALDER DRIVE | 1073.782658813208
0 | 45 | ALDER DRIVE | 721.5194812495997
1335004700 | 47 | ALDER DRIVE | 721.5194812495997
1335004900 | 49 | ALDER DRIVE | 721.5194812495997
1335005100 | 51 | ALDER DRIVE | 721.5194812495997
1335005000 | 50 | ALDER DRIVE | 1019.305659772332
1335005200 | 52 | ALDER DRIVE | 1019.305659772332
1335005400 | 54 | ALDER DRIVE | 1019.305659772332
0 | 56 | ALDER DRIVE | 1019.305659772332
0 | 62 | ALDER DRIVE | 1010.907436561385
1335006400 | 64 | ALDER DRIVE | 1010.907436561385
1335006600 | 66 | ALDER DRIVE | 1010.907436561385
1335006800 | 68 | ALDER DRIVE | 1010.907436561385
1335007100 | 71 | ALDER DRIVE | 912.7478760415579
1335007300 | 73 | ALDER DRIVE | 912.7478760415579
1335007500 | 75 | ALDER DRIVE | 912.7478760415579
1335007700 | 77 | ALDER DRIVE | 912.7478760415579
1335008400 | 84 | ALDER DRIVE | 1034.574560520416
1335008600 | 86 | ALDER DRIVE | 1034.574560520416
1335008800 | 88 | ALDER DRIVE | 1034.574560520416
1335009000 | 90 | ALDER DRIVE | 1034.574560520416
Spreadsheet: jeff_dasovich__14223__E206-Mkting-Ford SpreadMS95
Sheet: Sheet2

ESP (p307)
FACTS
Currently 45% of Ford new car buyers get a svc. Contract.
Of those, 60% get a Ford ESP ie, 27% of all new Ford buyers get Ford ESP (.6 x .45)
80% of svc. Contracts were purchased with the new vehicle, 20% after th 1yr/12K warranty expire.
19986 ESP sales = $265.4 million
Nonluxury = 6590000 | Luxury = 650000
 | N/A
 | N/A
6590000 | 650000
Spreadsheet: andy_zipper__479__11_26_01LO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | CL F2 | 18.5 | 225 | 228 | 68.8 | 69.7 | 0.81 | 2001-11-26 11:55:00
 | CL G2 | 19 | 340 | 350 | 60.4 | 62.2 | 0.73 | 2001-11-26 11:55:00
 | CL H2 | 19 | 400 | 420 | 57 | 59.9 | 0.7 | 2001-11-26 11:55:00
 | CL J2 | 19 | 440 | 460 | 53.9 | 56.4 | 0.66 | 2001-11-26 11:55:00
 | CL K2 | 19.5 | 480 | 505 | 50.4 | 53.1 | 0.63 | 2001-11-26 11:55:00
 | CL M2 | 19.5 | 500 | 520 | 48.1 | 50 | 0.6 | 2001-11-26 11:55:00
 | CL N2 | 19.5 | 515 | 535 | 45.7 | 47.5 | 0.57 | 2001-11-26 11:55:00
 | CL Q2 | 20 | 535 | 555 | 43.3 | 44.9 | 0.55 | 2001-11-26 11:55:00
 | CL U2 | 20 | 540 | 552 | 41.3 | 42.3 | 0.53 | 2001-11-26 11:55:00
 | [NAME] | 20 | 540 | 560 | 39.2 | 40.7 | 0.5 | 2001-11-26 11:55:00
 | CL X2 | 20 | 542 | 562 | 37.6 | 39 | 0.48 | 2001-11-26 11:55:00
 | [NAME] | 20 | 545 | 555 | 36.4 | 37 | 0.46 | 2001-11-26 11:55:00
 | CL M3 | 20.5 | 550 | 595 | 29.9 | 32.4 | 0.4 | 2001-11-26 11:55:00
 | CL Z3 | 20.5 | 550 | 595 | 26.5 | 28.7 | 0.36 | 2001-11-26 11:55:00
 | CL M4 | 21 | 555 | 600 | 23.9 | 25.9 | 0.33 | 2001-11-26 11:55:00
Spreadsheet: 248698d1373299888-search-and-update-or-create-new-entry-datalog
Sheet: William

MRN | Patient # | Facility | surgeon | gender | [NAME] | [NAME] | diagnosis | procedure | insurance | pre-op bmi | preop esr | preop crp | pre-op hgb | preop hct | preop KL score | pre-op fem valgus | pre-op tib var | alignment | pre-op mech alignment | vendor | fem size | tib size | tib thickness | tib type (mono, poly, mod) | [NAME]
Spreadsheet: 740091d1626183766-sheet-named-range-lookup-indirect-function-syntax-multiple-page-lookup
Sheet: input

 |  | 1 | Cells D14 and D15 are Company (D2) and [NAME] (D3) input codes
 |  | 2 | Cells D17 and D18/E18 are the formulas I currently use for the single database sheet - BUT this formula only works for the Customer List sheet
 |  | 3 | Cell D20 is a potential VLOOKUP formula, if I could find a means to search for the column number by the input of D3
 |  | 4 | CellsD24 is the full formula based on the green formulas
 |  | 5 | Cell D25 is the full formula minus the offset part
 |  | 6 | Cell D26 is a shorted version of the full formula using helper cells at D30 and E30
 |  | 7 | Row Section from the full formula
 |  | 8 | D30 and E30 when combined with a colon (  : )  create a reference to a sheet and line number based on the full sheet array of data: alter [NAME] and the row ref changes, which isued by the column part of index as the array
 |  | 9 | D38 Working Index match formula but without a column SECTION so just finds the company, not the person
 |  | 10 | [NAME] - summary of the companies and codes in the data worksheets for ease of checking
 |  | Company Code | [NAME]
 |  | Person Code | SNJOH
 |  |  |  |  |  | Company code |  | Person codes
 |  |  |  |  |  | Cust
 |  |  |  |  |  | Staff
 |  |  |  |  |  | Consult
 |  |  |  |  |  | Subs/Supps