tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 791720d1660563939-pay-as-you-earn-calculation-paye-calculator
Sheet: Sheet1

Tax start period | 2021-07-01 00:00:00 | 2021-07-01 00:00:00
Tax end period | 2022-06-30 00:00:00 | 2022-06-30 00:00:00
Gross earnings | 123000 | 345000
Pension fund (Tax Deductible | 1755 | 1755
Taxable pay
Age | 50 | 65
Annual Tax rebate (not more than 60 years of ages | 8200 | 8200
Annual Tax rebate (more than 60 years of ages | 10900 | 10900
After Rebater
Tax due
The rates of Income Tax applicable are as follows:
RATES OF NORMAL TAX FOR INDIVIDUALS
Exceeds | Does not exceed
Taxable Income |  |  | Rate | Differential
0 | 100000 | 0 | 0.2 | 0.2
100000 | 150000 | 20000 | 0.25 | 0.05
150000 | 200000 | 32500 | 0.3 | 0.05
200000 |  | 47500 | 0.33 | 0.03
Spreadsheet: 748620d1632242856-selective-summing-with-two-tests-rough-sumifs
Sheet: Summary

 | Project Name | Contract Value (GBP) | Recorded Saving (GBP)
 |  |  | Type A | Type B | Type C
 | Project 1 | 1000
 | Project 2 | 2000
 | Project 3 | 3000
 | Project 4 | 4000
 | Grand Total
Spreadsheet: 1474a546-1e41-494a-abb4-8eb36a6d89c0
Sheet: 2013

TYPE OF PERMIT | JAN | FEB | MAR | APR | MAY | JUN* | JUL | AUG | SEP | OCT | NOV | DEC | YR TOTAL
-------------- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --------
SINGLE FAMILY DET. | 31 | 17 | 38 | 54 | 25 | 44 | 45 | 36 | 32 | 17
$ [NAME] | 11533341 | 5898975 | 14832800 | 19956375 | 11933850 | 17299025 | 17818500 | 12614475 | 11990025 | 6382275
SINGLE FAMILY ATTACH | 6 | 17 | 12 | 0 | 5 | 8 | 8 | 0 | 5 | 1
$ [NAME] | 1140300 | 3289650 | 2133150 | 0 | 891600 | 1421850 | 1411050 | 0 | 871725 | 176925
MULTI FAMILY UNITS | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
$ [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
RESID. ALT/REPAIRS | 185 | 194 | 206 | 279 | 253 | 250 | 259 | 243 | 210 | 226
$ [NAME] | 569030 | 549253 | 657655 | 1187336 | 997492 | 1078850 | 1080065 | 980829 | 744148 | 795508
RESIDENTIAL ADD. | 7 | 0 | 0 | 1 | 0 | 0 | 1 | 1 | 1 | 3
$ [NAME] | 166233 | 0 | 0 | 97500 | 0 | 0 | 25000 | 16000 | 11000 | 84399
COMM. ALT/REPAIRS | 63 | 32 | 34 | 29 | 34 | 42 | 38 | 42 | 39 | 35
$ [NAME] | 1024664 | 337959 | 428338 | 684353 | 1339679 | 2223613 | 943050 | 1208307 | 950389 | 741470
COMMERCIAL, NEW | 2 | 1 | 1 | 1 | 0 | 1 | 4 | 1 | 3 | 0
$ [NAME] | 2450000 | 250000 | 3200000 | 600000 | 0 | 700000 | 3940000 | 1250000 | 3825000 | 0
COMMERCIAL ADD/FO | 13 | 12 | 22 | 12 | 20 | 25 | 11 | 16 | 19 | 18
$ [NAME] | 810000 | 1038250 | 233795 | 326560 | 2258254 | 331865 | 66625 | 344900 | 195650 | 132380
INDUSTRIAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
$ [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
PUBLIC BUILDINGS | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
$ [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
PUBLIC BLDG. ADD. | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
$ [NAME] | 0 | 5000000 | 5000000 | 0 | 0 | 0 | 0 | 0 | 0 | 0
PUBLIC BLDG. ALT. | 1 | 4 | 7 | 3 | 6 | 10 | 3 | 0 | 0 | 2
$ [NAME] | 95000 | 780000 | 5047306 | 331655 | 40978 | 2814132 | 69659 | 0 | 0 | 4500
TEMPORARY OFFICE | 6 | 2 | 9 | 6 | 12 | 7 | 2 | 5 | 6 | 7
$ [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ACCESSORY BLDG. | 3 | 5 | 3 | 5 | 6 | 5 | 2 | 4 | 4 | 6
$ [NAME] | 5489 | 10888 | 7534 | 8328 | 17612 | 10868 | 1750 | 8775 | 5247 | 15162
POOLS | 9 | 15 | 18 | 23 | 18 | 16 | 18 | 19 | 17 | 8
$ [NAME] | 335000 | 597365 | 777716 | 938500 | 694630 | 634000 | 608840 | 696559 | 748700 | 318580
SPAS | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0
$ [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5000 | 0
FENCES | 117 | 57 | 112 | 126 | 56 | 88 | 81 | 84 | 80 | 149
$ [NAME] | 255015 | 127372 | 435693 | 470899 | 271600 | 404562 | 282882 | 289053 | 193219 | 393349
SPRINKLER | 21 | 38 | 57 | 39 | 24 | 54 | 45 | 45 | 29 | 46
$ [NAME] | 44525 | 80750 | 140400 | 112550 | 132904 | 131095 | 223814 | 157800 | 56200 | 98300
SIGNS | 32 | 24 | 32 | 37 | 27 | 26 | 17 | 40 | 31 | 22
$ [NAME] | 137433 | 37660 | 52679 | 56383 | 28406 | 35390 | 20895 | 583068 | 36765 | 49090
MOVING | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
$ [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DEMOLITION | 0 | 1 | 0 | 0 | 3 | 2 | 4 | 1 | 3 | 0
$ [NAME] | 0 | 25000 | 0 | 0 | 10500 | 66000 | 9430 | 10600 | 26780 | 0
TOTAL PERMITS
TOTAL DOLLAR VALUE
Spreadsheet: 44350d1242936070-regression-question-3-updated-2-
Sheet: Sensitivity Report 1

Microsoft Excel 12.0 Sensitivity Report
Worksheet: [Question 3 updated.xlsx]Sheet4
Report Created: 5/22/2009 2:31:13 AM
Adjustable Cells
 |  |  | Final | Reduced
 | Cell | Name | Value | Gradient
 | $C$58 | bhpw1 | 0.2450569267210508 | 0
 | $D$58 | nabw2 | 0.1509886146557898 | 0
 | $E$58 | sgbw3 | 0.1509886146557898 | 0
 | $F$58 | [NAME] | 0.1509886146557898 | 0
 | $G$58 | awcw5 | 0.1509886146557898 | 0
 | $H$58 | wplw5 | 0.1509886146557898 | 0
Constraints
 |  |  | Final | Lagrange
 | Cell | Name | Value | Multiplier
 | $C$60 | Contraint BHP | 0.9999999999999999 | 1.000871361611644e-05
Spreadsheet: drew_fossum__8874__01_19_00StanH_mtg_final
Sheet: NNG  99 3c3 to Actuals

 |  | Enron Transportation & Storage
 |  | Northern Natural Gas Company
 |  | 1999 Actuals  toThird Current Estimate
 |  | Revenue/Margin Summary
 | Variance From 99 Actuals vs  3CE |  |  | $Millions
 |  | 1999 3CE Revenues |  | 447.3
 | NNG
 | Midwest |  |  | 0.2 |  | Ups: Noram,Nicor+1.2,  [NAME]: Commodity-1.1, other .1
 | South Onshore |  |  | 1.9 |  | [NAME] (ENA) and  Commodity price increase (rate case) +1.9
 | South Offshore |  |  | -0.5 |  | Production decline, demand price variance
 | Storage |  |  | 0.5 |  | IDD
 | Other |  |  | 0.1 |  | DDVC
 | TOTAL NNG
 | G.L. to Accounting Month Difference |  |  | 0.2 |  | Flash to actual, PPA's
 | SUBTOTAL NNG
 |  | 1999 Actual Revenues
 |  | Less: Carlton |  | 1.5
 |  | 1999 Margin
Spreadsheet: 215521d1361396971-extracting-and-transferring-rows-and-transosing-info-into-a-new-sheet-template-_animal-numbers
Sheet: Input

Date approved | Protocol # | Researcher | Animal species | # of animals approved | Protocol expiry date
2012-01-01 00:00:00 | F12-001 | Dr ABC | beef | 100 | 2013-01-01 00:00:00
2013-01-01 00:00:00 | F12-002 | Dr DEF | dairy | 150 | 2014-01-01 00:00:00
2013-02-02 00:00:00 | F13-001 | Dr ABC | pigs | 20 | 2014-02-02 00:00:00
2013-02-03 00:00:00 | F12-004 | Dr JKL | layers | 30 | 2014-02-03 00:00:00
2013-02-04 00:00:00 | F13-010 | Dr MNO | broiler chicks | 12 | 2014-02-04 00:00:00
2013-02-05 00:00:00 | F14-012 | Dr JKL | pigs | 10 | 2013-02-05 00:00:00
2013-02-06 00:00:00 | F12-008 | Dr STU | broilers | 6 | 2013-02-06 00:00:00
Spreadsheet: 91580d1291285436-auto-fill-the-schedule-based-on-data-schedule-data
Sheet: Schedule 

 |  |  |  |  |  | Park A | Park B | Park C | Park D | Park E | [NAME]
 | Match No | Date | Day | Time | Group
 | 1 | 2010-12-04 00:00:00 | 2010-12-04 00:00:00 | 1st Half | A | [NAME]
 | 2 | 2010-12-04 00:00:00 | 2010-12-04 00:00:00 | 2nd Half | A | B1 Vs B2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 20
 | 21
 | 22
 | 23
 | 24
 | 25
 | 26
 | 27
 | 28
 | 29
 | 30
 | 31
 | 32
 | 33
 | 34
 | 35
 | 36
 | 37
 | 38
 | 39
 | 40
 | 41
 | 42
 | 43
 | 44
 | 45
 | 46
 | 47
 | 48
 | 49
 | 50
 | 51
 | 52
 | 53
 | 54
 | 55
 | 56 | 2011-02-13 00:00:00 | 2011-02-13 00:00:00 | Ist Half | B |  |  |  |  |  | B7 Vs B8
Spreadsheet: 63c61d4e-2bd5-4ffc-b863-0861aa6ef03d
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SNOWSHOE | T1 | SKATE | T2 | SKI | POSITION | TOTAL TIME
4558 | 10231 | Jan | Holiga (1947) | SVK | 152 | 00:17:13 | 00:01:38 | 00:20:17 | 00:01:13 | 00:19:10 | 1 | 00:59:37
4558 | 25800 | [NAME] | [NAME] | GER | 0 | 00:18:21 | 00:01:38 | 00:21:12 | 00:01:25 | [NAME] | 2 | 01:04:24
Spreadsheet: 275098d1383326253-mutliple-tables-on-1-sheet-testcopyofqr
Sheet: SUMMARY PAGE OVERALL

 |  |  |  | Home Services |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Quality Review
 |  |  |  | Superior Water and Air - 999999 |  |  |  | Class HVAC |  |  | REGION(S): |  |  |  |  |  |  | PACIFIC NORTH |  | 76, 533, 226
 |  |  |  |  |  |  | HTD |  | YTD |  | 2012 (Prev Yr)
 |  |  |  | Sub Class Desc |  |  | SALES  HTD | SALES VLY % | SALES  YTD | SALES VLY % | 2012 | 2012 VLY % | YTD HD VLY % | YTD Region VLY % | HD Natl Rank | Region Rank | PO COUNT | Average PO | Cycle-time (days) | Installer Overall VOC |  | VOC Survey Count
 |  |  |  | HVAC |  |  | 4634815.810000001 | 0.6418589299591712 | 4634815.810000001 | 0.6418589299591712 | 0.3401954909617002 | 1793 | 0.15 | 0.12 | 114 | 2 | 1 | 2584.950256553263 | 30.02747252747253 | 9.05 |  | 182
295640 | 29 | 56 | 40 | WATER TREATMENT |  |  | 1221786.13 | 0.1692007557989142 | 1221786.13 | 0.1692007557989142 | -0.0278624295726783 | 613 | 0.12 | 0.15 | 98 | 1 | 1 | 1993.125823817292 | 30.92356687898089 | 9.493150684931507 |  | 74
295610 | 29 | 56 | 10 | WATER HEATER |  |  | 771717.36 | 0.1068723546363575 | 771717.36 | 0.1068723546363575 | 0.99967812049738 | 471 | 0.09 | 0.1 | 112 | 5 | 1 | 1638.465732484076 | 29.37062937062937 | 9.395348837209303 |  | 43
295622 | 29 | 56 | 22 | TANKLESS WATER HEATER |  |  | 390226.17 | 0.05404101526059685 | 390226.17 | 0.05404101526059685 | 0.5555547440603484 | 154 | 0.05 | 0.075 | 2 | 9 | 1 | 2533.936168831169 | 35.28571428571428 | 9.470588235294118 |  | 17
295664 | 29 | 56 | 64 | CUSTOM ELECTRICAL |  |  | 186536.68 | 0.02583279222544473 | 186536.68 | 0.02583279222544473 | 0.07859800013595183 | 153 | -0.16 | -0.08 | 166 | 12 | 1 | 1219.193986928105 | 35.55696202531646 | 9.066666666666666 |  | 15
29569 | 29 | 56 | 9 | F&I FIXTURES |  |  | 8011.38 | 0.001109467129891469 | 8011.38 | 0.001109467129891469 | 0.6957328200634598 | 6 | 0.12 | -0.09 | 54 | 15 | 1 | 1335.23 | 27 | 0 |  | 0
295662 | 29 | 56 | 62
295620 | 29 | 56 | 20
 |  |  |  | TOTAL (ALL SUBCLASSES): |  |  | 7220925.96 |  |  |  | 0.3543908501729051 | 3196 |  |  |  |  |  |  | 27.69014453639717 | 9.216463414634147 |  | 331
 |  |  |  | * Totals may include sales from programs that are no longer active or showing. *Only the top 10 SALES (PO COUNT) subclasses are shown on this page
 |  |  |  | * All data, except overall sales (SALES (RETAIL) above reflects Installation, not measure, purchase orders only.  PO Count reflects non rework purchase orders only
Spreadsheet: chris_germany__2334__CGULF_newalb_confirms_Mar_2001
Sheet: wacog

NEW ALBANY  - March  2001
 | GAS [NAME] |  |  |  |  |  |  | GAS COSTS $ |  |  |  |  | TOTAL PURCHASES
DATE |  |  |  | Fuel | OVER/ |  |  |  | East Desk Purchases |  | TTL DAILY
 | RECEIPTS | DELIVERIES | [NAME] | 0.0282 | UNDER | BALANCE |  | [NAME] | @ +.065 | NEGOTIATED | PURCH
 |  |  |  |  | SUPPLY
 |  |  |  |  |  | 12582 |  |  |  |  |  |  | BURN * GDA | TAX RATE - 1.5%
2001-03-01 00:00:00 | 0 |  | 1 |  |  |  |  | 5.09 |  | 0
2001-03-02 00:00:00 | 0 |  | 1 |  |  |  |  | 5.115 |  | 0
2001-03-03 00:00:00 | 0 |  | 2 |  |  |  |  | 5.1 |  | 0
2001-03-04 00:00:00 | 0 |  | 1 |  |  |  |  | 5.1 |  | 0
2001-03-05 00:00:00 | 0 |  | 7850 |  |  |  |  | 5.1 |  | 0
2001-03-06 00:00:00 | 10000 |  | 3550 |  |  |  |  | 5.32 |  | 0
2001-03-07 00:00:00 | 0 |  | 36 |  |  |  |  | 5.27 |  | 0
2001-03-08 00:00:00 | 0 |  | 30 |  |  |  |  | 5.22 |  | 0
2001-03-09 00:00:00 | 0 |  | 2 |  |  |  |  | 5.245 |  | 0
2001-03-10 00:00:00 | 0 |  | 2 |  |  |  |  | 5.135 |  | 0
2001-03-11 00:00:00 | 0 |  | 3 |  |  |  |  | 5.135 | 0 | 0
3/12/2001 | 0 |  | 2 |  |  |  |  | 5.135 | 0 | 0
a) 3/13/2001 | 0 |  | 3406 |  |  |  |  | 4.98 | 2520 | 0
2001-03-14 00:00:00 | 0 |  | 2 |  |  |  |  | 0 | 0 | 0
2001-03-15 00:00:00 | 0 |  | 4 |  |  |  |  | 0 |  | 0
2001-03-16 00:00:00 | 0 |  | 3 |  |  |  |  | 0 | 0 | 0
2001-03-17 00:00:00 | 0 |  | 3 |  |  |  |  | 0 |  | 0
2001-03-18 00:00:00 | 0 |  | 4 |  |  |  |  | 0 |  | 0
2001-03-19 00:00:00 | 0 |  | 1 |  |  |  |  | 0 |  | 0
2001-03-20 00:00:00 | 0 |  | 1 |  |  |  |  | 0 |  | 0
2001-03-21 00:00:00 | 0 |  | 1 |  |  |  |  | 0 |  | 0
2001-03-22 00:00:00 | 0 |  | 1 |  |  |  |  | 0 |  | 0
2001-03-23 00:00:00 | 0 |  | 2 |  |  |  |  | 0 |  | 0
2001-03-24 00:00:00 | 0 |  | 1 |  |  |  |  | 0 |  | 0
2001-03-25 00:00:00 | 0 |  | 1 |  |  |  |  | 0 | 0
2001-03-26 00:00:00 | 0 |  | 2 |  |  |  |  | 0 |  | 0
2001-03-27 00:00:00 | 0 |  | 1 |  |  |  |  | 0 |  | 0
2001-03-28 00:00:00 | 0 |  | 1 |  |  |  |  | 0 | 0 | 0
2001-03-29 00:00:00 | 0 |  | 1 |  |  |  |  | 0 | 0 | 0
2001-03-30 00:00:00 | 0 |  | 1 |  |  |  |  | 0 |  | 0
2001-03-31 00:00:00 | 0 |  | 1 |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0
TOTALS |  |  |  |  |  |  |  | 5%   =
BOLD DATE = PIPELINE ACTUALS
Spreadsheet: 160326d1339053025-can-i-use-my-spreadsheet-graph-as-a-screen-saver-departmental-screen-shot-data
Sheet: BELATRON

BELATRON Dept.
 | Week 17 |  | Dept. [NAME] |  | Plant Average 2012
On Time Delivery |  | % |  | % |  |  | % | >100Green >90 Amber < 90 Red
Efficiency | 0 | % | 0.8824 | % | 0.7549 |  | % | 75  Green 70-75Amber       < 70 Red
Throughput Days |  | % |  | % |  |  | % | > 5 Green  5-7 Amber < 7 Red
Overheads | 0 |  |  | % | 0.2473 |  | %
Extra Time | 0 | % | 0 | % | 0.27 |  | %
Spreadsheet: 151243d1334839503-find-text-string-then-sum-formula-new-take-off-sheet-test
Sheet: dropdown order

System List
Ballast Controllers
Relay Controllers
Ecolinx LCM
Multi-Purpose Controllers
Leading & Trailing Edge Dimming Controllers
DR2PE
DPNE
DPWE
DLPE
Touch Screens
Time Clocks
Sensors
System Integration
Network Acessories
Software
Remote Controls
Leads & Plugs
Fixture Couplers
Occuswitch
Light Master [NAME]
LMM Scene Setting
LMM Panels & Additional Products
General Purpose
ColourChaser DMX Controls
LMM Leads & Plugs
Trios
Options - Leading & Trailing Edge Dimmers
Options - Relay Controllers
Options - HFBallast Controllers
Options - Mulitpurpose Controllers
Spreadsheet: 702669d1604474462-sum-x-and-y-axis-values-question-2-
Sheet: Sheet1

 | Data I have now |  |  |  |  |  |  |  |  |  |  |  | Data I need to get (in two columns)
 |  | 0 | 0.01 | 0.02 | 0.03 | 0.04 | 0.05 | 0.06 | 0.07 | 0.08 | 0.09
 | 0 | 50 | 49.6 | 49.2 | 48.8 | 48.4 | 48.01 | 47.61 | 47.20999999999999 | 46.81 | 46,91
 | 0.1 | 46.02 | 45.62 | 45.22000000000001 | 44.83000000000001 | 44.43 | 44.04 | 43.64 | 43.25 | 42.86 | 41,02
 | 0.2 | 42.06999999999999 | 41.67999999999999 | 41.29000000000001 | 40.90000000000001 | 40.52 | 40.13 | 39.73999999999999 | 39.35999999999999 | 38.97000000000001 | 38,54
Spreadsheet: 92065d1291739934-too-many-ifs-help-to-simplify-solution
Sheet: Sheet1

Section | RAG1Q | RAG2Q | RAG3Q | RAG4Q | Live | Pending | Q1 | <Choose
House | RED | Blue |  |  | Yes | Other
House | Amber |  |  |  | Yes | Other
House |  |  |  |  | No
Room | Red |  |  |  | Yes | Other |  | Q1
Room | Red |  |  |  | Yes | Other |  | Q2
Room | Green |  |  |  | Yes | Other |  | Q3
Room |  |  |  |  | No |  |  | Q4
Roof | Red | Amber |  |  | Yes | Other
 |  |  |  |  |  | 13
 |  |  |  |  |  | 9
Spreadsheet: 150792d1334681308-difficult-making-list-of-unique-values-from-info-in-two-tables-copy-of-excelhelp-custid-to-workorder-list
Sheet: Result

Customer ID | Count--> |  | Customer ID | WorkOrderID |  | Customer ID | WorkorderID |  | Customer ID |  | Customer ID | WorkOrderID
23132 |  |  | 23100 | 36184 |  | 23132 | 36181 |  | 23132 |  | 23100 | 36184
23124 |  |  | 23132 | 36181 |  | 23132 | 35973 |  | 23124 |  | 23132 | 36181
23100 |  |  | 23100 | 36054 |  | 23132 | 36349 |  | 23100 |  | 23100 | 36054
 |  |  | 23132 | 35973 |  | 23132 | 36356 |  |  |  | 23132 | 35973
 |  |  | 23132 | 36349 |  | 23132 | 36455 |  |  |  | 23132 | 36349
 |  |  | 23132 | 36356 |  | 23124 | 36162 |  |  |  | 23132 | 36356
 |  |  | 23100 | 36454 |  | 23124 | 36395 |  |  |  | 23100 | 36454
 |  |  | 7284 | 35689 |  | 23124 | 36266 |  |  |  | 23124 | 36162
 |  |  | 23124 | 36162 |  | 23100 | 36184 |  |  |  | 23132 | 36455
 |  |  | 7773 | 36320 |  | 23100 | 36054 |  |  |  | 23124 | 36395
 |  |  | 23132 | 36455 |  | 23100 | 36454 |  |  |  | 23124 | 36266
 |  |  | 8155 | 36471 |  | 23100 | 36381 |  |  |  | 23100 | 36381
 |  |  | 23124 | 36395
 |  |  | 8344 | 36427
 |  |  | 23124 | 36266
 |  |  | 9686 | 36203
 |  |  | 23100 | 36381
 |  |  | 11298 | 36469
 |  |  | 11485 | 36452
 |  |  | 11485 | 36451
 |  |  | 11689 | 36363
Spreadsheet: 0a75845c-c06e-403c-a51b-73251dbeff8d
Sheet: Sheet1

UTAH STATE OFFICE OF EDUCATION | Unnamed: 1 | Unnamed: 2
SCHOOL FINANCE & STATISTICS
[NAME] OF LOCAL EFFORT
FY 13 PREFINAL UPDATE
USBE RULE R277-911-4
PreFinal Update |  | Current as of April 10, 2013
 | FY12 | FY13 MINIMUM
 | Audited | QUALIFYING
DISTRICT | ADD-ON ADM | EXPENDITURE*
 | GRADE 9-12 | @
 |  | 2607
 | (1) | (2)
01 ALPINE | 2667.292 | 6953630.244
02 BEAVER | 78.796 | 205421.172
03 BOX ELDER | 629.911 | 1642177.977
04 CACHE | 708.723 | 1847640.861
05 CARBON | 169.841 | 442775.487
06 DAGGETT | 13.756 | 35861.892
07 DAVIS | 2704.271 | 7050034.497
08 DUCHESNE | 132.872 | 346397.3040000001
09 EMERY | 101.702 | 265137.114
10 GARFIELD | 74.075 | 193113.525
11 GRAND | 102.841 | 268106.487
12 GRANITE | 2755.245 | 7182923.715
13 IRON | 291.503 | 759948.321
14 JORDAN | 2289.385 | 5968426.695
15 [NAME] | 96.454 | 251455.578
16 KANE | 78.561 | 204808.527
17 MILLARD | 179.699 | 468475.293
18 MORGAN | 106.166 | 276774.762
19 NEBO | 1467.63 | 3826111.41
20 N SANPETE | 255.308 | 665587.956
21 N SUMMIT | 55.385 | 144388.695
22 PARK CITY | 168.471 | 439203.897
23 PIUTE | 23.867 | 62221.269
24 RICH | 21.462 | 55951.434
25 SAN JUAN | 165.174 | 430608.618
26 SEVIER | 228.315 | 595217.205
27 S SANPETE | 116.833 | 304583.631
28 S SUMMIT | 95.918 | 250058.226
29 TINTIC | 7.279 | 18976.353
30 TOOELE | 799.039 | 2083094.673
31 UINTAH | 233.741 | 609362.787
32 WASATCH | 295.675 | 770824.725
33 WASHINGTON | 1261.158 | 3287838.906
34 WAYNE | 40.878 | 106568.946
35 WEBER | 1743.054 | 4544141.778
36 SALT LAKE | 1022.959 | 2666854.113
37 OGDEN | 563.657 | 1469453.799
38 PROVO | 704.177 | 1835789.439
39 LOGAN | 177.326 | 462288.882
40 MURRAY | 349.539 | 911248.173
42 CANYONS | 1271.961 | 3316002.327
CHARTER SCHOOLS:
83  AMES | 22.998 | 59955.786
[NAME] | 54.167 | 141213.369
A5  ITINERIS | 10.006 | 26085.642
A9 SUCCESS ACADEMY | 2.951 | 7693.257000000001
1B  UCAS | 24.961 | 65073.327
8B  AMERICAN LEADERSHIP ACADEMY | 7.846 | 20454.522
2C  INTECH | 29.01 | 75629.07
TOTAL | 24401.83800000001 | 63615591.66600001
*The amount in column 2 must be expended in order to earn State [NAME] funds.  All State CTE Funds are
RESTRICTED funds.  For calculation purposes, the  amount in column 2 shall not include State Add-On, State
Set-Aside, and Federal funds.
Spreadsheet: 2436a299-76f6-4ced-a335-c351156c3f1d
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: |  |  | 2013-07-31 09:25:26.120000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.75 | 101.782 | 101.657 | 101.532 | 101.157 |  | and are added to price quote
4.625 | 101.129 | 101.004 | 100.879 | 100.504
4.5 | 100.303 | 100.178 | 100.053 | 99.678 |  | Note: | Refer To Price [NAME]
4.375 | 99.434 | 99.309 | 99.184 | 98.809 |  |  | For all Price Adjs
4.25 | 98.751 | 98.626 | 98.501 | 97.876
4.125 | 98.016 | 97.891 | 97.766 | 97.141
4 | 97.107 | 96.982 | 96.857 | 96.232
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4 | 102.125 | 102 | 101.875 | 101.5
3.875 | 101.637 | 101.512 | 101.387 | 101.012
3.75 | 101.051 | 100.926 | 100.801 | 100.426
3.625 | 100.713 | 100.588 | 100.463 | 100.088
3.5 | 100.224 | 100.099 | 99.974 | 99.349
3.375 | 99.48 | 99.355 | 99.23 | 98.605
3.25 | 98.758 | 98.633 | 98.508 | 97.883 |  | Minimum loan amount:
3.125 | 97.893 | 97.768 | 97.643 | 97.018 |  | 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:
 |  |  |  |  |  | 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 | 2013-08-14 09:25:26.120000
30 DAY | 2013-08-29 09:25:26.120000
45 DAY | 2013-09-13 09:25:26.120000
60 DAY | 2013-09-28 09:25:26.120000
90 DAY | 2013-10-28 09:25:26.120000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 31883d1227880538-drop-down-lists-including-formulas-ben-sample
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | Toro S/D 8% | 8
 |  |  |  |  |  |  |  |  | Sis S/D 12% | 12
April | May | June | July | Aug | Sept | Oct | Nov | Total | Ry S/D 6% | 6
Toro S/D 8% | Sis S/D 12% |  |  | Sis S/D 12% |  | V-cuts S/D 5% |  |  | [NAME] | 8
8 | 12 |  |  | 12 |  | 5 |  | 37 | Gr S/D 11% | 11
 |  |  |  |  |  |  |  |  | Th-a-wy S/D 15% | 15
 |  |  |  |  |  |  |  |  | T Pro S/D 7% | 7
 |  |  |  |  |  |  |  |  | V-cuts S/D 5% | 5
 |  |  |  |  |  |  |  |  | [NAME] 6% | 6
Information- I have included a drop list under each month that includes all the equipment. I would like to choose the equipment that was used and have the (%) sum in the total (with auto sum). The best way I can explain it is to have a hidden formula that includes the percentage for the equipment that was chosen and have that (%) auto sum in the total column. I still want the text to appear in the cell for presentation purposes. I know that I can do it using another row with only the number but I would like to keep it clean and have it show in one row. Also is there a way to highlight a cell in order to activate a formula. Such as if I had "Sisis S/D 12%" in the desired month I was going to do the work... can I highlight or activate the formula so it then auto sums in the total column?
Spreadsheet: darrell_schoolcraft__7622__imball0201
Sheet: transcol

 | TransColorado
 | 500632
Day | Measured | Scheduled
1 | 106165 | 117417
2 | 117972 | 117437
3 | 124002 | 124207
4 | 100788 | 100788
5 | 104942 | 104207
6 | 104211 | 104207
7 | 84424 | 83518
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-12-31 00:00:00 |  |  | 12821
2002-01-07 00:00:00
CBS Volume
 |  |  | -49782
Spreadsheet: andy_zipper__621__Broker & Exchange Detail 11-20-01 EM
Sheet: EXCHANGE DEAL SUMMARY

EnronOnline Exchange Detail for 11/20/2001
Completed Transactions:
TODAY
Date | 2001-11-20 00:00:00
Count
Exchange Party | Counterparty Name | Commodity | Total
Grand Total
No Activity
LTD
Date | (All)
Count
Exchange Party | Counterparty Name | Commodity | Total
True Quote LLC | PG&E Energy Trading - Power, L.P. | US East Power | 91
 |  | US West Power | 25
 | Tucson Electric Power Company | US West Power | 2
 | Cinergy Marketing & Trading, LLC | Natural Gas | 2
 | Conectiv Energy Supply, Inc. | US East Power | 11
 |  | Natural Gas | 1
 | Tractebel Energy Marketing, Inc. | US East Power | 1
 |  | Natural Gas | 15
 | CMS Marketing, Services and Trading Company | US East Power | 1
 |  | Natural Gas | 3
 | Calpine Energy Services, L.P. | US East Power | 4
 |  | US West Power | 2
 |  | Natural Gas | 9
 | CLECO Marketing and Trading, LLC | Natural Gas | 1
 | PG&E Energy Trading-Gas Corporation | Natural Gas | 131
 | Axia Energy, LP | Natural Gas | 3
 | Entergy-Koch Trading, LP | Natural Gas | 10
 | Conoco Inc. | Natural Gas | 13
 | Richardson Energy Marketing, Ltd. | Natural Gas | 1
True Quote LLC Total |  |  | 326
Grand Total |  |  | 326