tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 8a80dcb7-fb81-4bfc-9b30-2cfd564ed7b3
Sheet: Capital

CAPITAL PROJECT |  |  |  |  |  |  | 120554
Ordinance Fiscal Note |  |  |  |  |  |  | Ordinance Number
Ordinance Title (in Brief)
 | Contract No. 8551 - Small Main Replacement for Plate C-85, NE 48th Street to NE Russell Road,
 | N Jackson Avenue to N Topping Avenue
 |  |  |  | X | Design Professional Services
Is this ordinance for the following: |  |  |  |  | New Construction
 |  |  |  |  | Replacement
 |  |  |  |  | Repair
Was this project programmed in the Five-Year Capital Improvement Plan? |  |  |  |  |  |  |  | No |  | X | Yes
 | If yes, please identify year in which this project was funded. |  |  |  |  |  |  | 2012
 | If no, please detail the reasons why this project was not included and need for present funding request.
Does this project leverage non-city funds for design/construction? |  |  |  |  |  |  | X | No |  |  | Yes
 | If yes, please identify source and amount.
 | Source of Funds:
 | Year Funded:
 | Amount of Non-City Funds: |  |  | $
 | If no, please identify source and amount of city funds.
 | Acct #: |  |  |  | 8072-808081-B-611040
 | Name of Fund: |  |  |  | Water & Sewer CD1
 | Year Funded: |  |  |  | AL
 | Amount of City Funds: |  |  | $ | 431000
If ordinance is for new construction or replacement of asset please provide the following information:
 | Total estimated costs (design through construction): |  |  | $ | N/A
 | Estimated lifespan of project in years |  |  | $ | N/A
 | Estimated annual operating and maintenance costs |  |  | $ | N/A
 | (Please detail type of maintenance or operating costs needed, additional staffing, capital maintenance costs, utilities, etc.)
Are these O&M costs reflected in the current budget? |  |  |  |  |  |  | X | No |  |  | Yes
 | If yes, please please provide source of funds.
 | If no, please identify year in which additional operating and maintenance costs will be needed. |  |  |  |  |  |  |  |  |  | N/A
Reference Numbers: (Previously approved legislation): |  |  |  |  | N/A |  |  | N/A |  |  | N/A
Reviewed by:
 |  |  |  |  |  | OMB Approval Date
Spreadsheet: 64934d1265738460-isolating-data-example-three
Sheet: Drivers

Driver | # | 2
ATHWAL,GURDIP | 1
ATHWAL,HARJINDER | 100
ATHWAL,PARAMJIT | 200
GILL,BEANT | 300
GILL,JAGDEV | 400
KAUL,SAT PAL | 500
MAKAS,STANISLAV | 600
MINHAS,MALVINDER | 700
PANNU,SUKHJINDER | 800
PANNU,TEJINDER | 900
RAI,YUVRAJ | 1000
SAHI,AMARPAL | 1100
SAHOTA,MANJITSINGH | 1200
SAHOTA,SUKHDEV | 1300
SALICKSINGH,[NAME] | 1400
SANDHU,MOHAN | 1500
SINGH,JASPAL | 1600
SINGH,SARBJIT | 1700
[NAME],[NAME] | 1800
VIRK,NAVJIT | 1900
Spreadsheet: cf6c605b-b59c-46e2-b43b-de69bce5eab0
Sheet: Sheet1

Bevölkerung des Freistaates Sachsen nach ausgewählten Altersgruppen | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Elbe-Röder-Dreieck - Variante 2
Alter von ... bis                     unter ... Jahren | 2011 | 2015 | 2020 | 2025
1 000
unter 20 | 3479 | 3600 | 3419 | 3005
20 - 25 | 1250 | 608 | 657 | 727
25 - 35 | 2825 | 2547 | 1784 | 1311
35 - 55 | 8237 | 7152 | 6018 | 5253
55 - 67 | 4598 | 5284 | 5353 | 4910
67 und mehr | 6223 | 5993 | 6332 | 6659
Insgesamt | 26612 | 25184 | 23563 | 21865
%
unter 20 | 13.07304975199158 | 14.29479034307497 | 14.51003692229343 | 13.74342556597302
20 - 25 | 4.697129114685104 | 2.41423125794155 | 2.788269744939099 | 3.324948547907615
25 - 35 | 10.61551179918834 | 10.11356416772554 | 7.571192123244069 | 5.995883832609192
35 - 55 | 30.95220201412896 | 28.3989834815756 | 25.54004159062938 | 24.02469700434484
55 - 67 | 17.27791973545769 | 20.98157560355781 | 22.71782031150533 | 22.45597987651498
67 und mehr | 23.38418758454833 | 23.79685514612452 | 26.8726393073887 | 30.45506517265035
Insgesamt | 100 | 100 | 100 | 100
Gebietsstand: | 1. Januar 2012
Quelle: | 2011 Bevölkerungsfortschreibung auf Basis der [NAME] vom 03. Oktober 1990
 | 2012 - 2025 Bevölkerungsprognose
Bevölkerung jeweils am 31. Dezember
Prognoseergebnisse werden bei der Veröffentlichung immer auf volle [NAME] gerundet. [NAME] basieren [NAME] ungerundeten Werten. Beim [NAME] der [NAME] werden Ihnen die ungerundeten [NAME] zur Verfügung gestellt, damit [NAME] eigenen Berechnungen genauer durchführen können. Die Darstellung der Ergebnisse sollte dann aber wieder gerundet erfolgen.
Spreadsheet: drew_fossum__8882__MarchForecast
Sheet: NNG-O&M

NORTHERN NATURAL GAS COMPANY
2000 O & M EXPENSE (000'S) - NET - 1ST QUARTER
 |  | 1999 Actuals |  | Prior Forecast |  | Forecast |  | Plan |  | Var. from Plan |  | Description
Direct Costs
Executive
Finance & Accounting |  |  |  |  |  |  |  |  |  |  |  | Savings distribution
Systems |  |  |  |  |  |  |  |  |  |  |  | Savings distribution
Transportation Marketing |  |  |  |  |  |  |  |  |  |  |  | Savings distribution; $100 Keyex prepmt
Business Services |  |  |  |  |  |  |  |  |  |  |  | Savings distribution
Market Services
Regulatory Affairs & Administration |  |  |  |  |  |  |  |  |  |  |  | Savings distribution
TW Commercial Group |  |  |  |  |  |  |  |  |  |  |  | Savings distribution
Operations |  |  |  |  |  |  |  |  |  |  |  | DOT fees reversal $1,072M, Timing
General & Administrative
Stretch
Total Direct Costs
GPG Allocations
Legal  (Co.  508) |  |  |  |  |  |  |  |  |  |  |  | OH reclass
Finance & Accounting  (Co. 422) |  |  |  |  |  |  |  |  |  |  |  | OH reclass
Operations Technical Services  (Co. 423)
Human Resources  (Co. 507) |  |  |  |  |  |  |  |  |  |  |  | Payroll taxes allocation, OH reclass
Executive |  |  |  |  |  |  |  |  |  |  |  | Aviation True-up $(35), OH reclass $310, Ad Val.Tax reclass $72;  rev. OH $144
Other
Total GPG Allocations
Corporate Allocations
MMF
ECM |  |  |  |  |  |  |  |  |  |  |  | savings, offset in corp. overview
Insurance
Direct - EMI Co 001
Direct - Corp Co 011 |  |  |  |  |  |  |  |  |  |  |  | Ad Valorem Tax reclass $(72);
Aviation
EIS |  |  |  |  |  |  |  |  |  |  |  | $(270) reversal,  $(200) offset in corp. overview
EPSC - Co 901 |  |  |  |  |  |  |  |  |  |  |  | Reclass to cap $(43)
EDS Delta |  |  |  |  |  |  |  |  |  |  |  | Capitaliztion deferred to 1st  Qtr
Other
Total Corporate Allocations
Total O&M Expense
Spreadsheet: 728058d1618283530-arrange-top-5-items-from-a-list-in-decreasing-order-book2-12-ans
Sheet: Risk Register

 |  | Estimated cost of residual risk
Reference | Cause, trigger or issue | Minimum $ | Most Likely $ | Maximum $
3 | 1. Delay to REF determination which is required prior to AHIP application to [NAME] 2. Excessive review timeframes from [NAME] | 60000 | 120000 | 300000 |  |  | Top 5 risk items | Most Likely Values
4 | Residential noise treatments required not previously identified by pre-construciton noise modelling | 50000 | 100000 | 150000 |  | 1
5 | 1. Poor exisiting pavement may trigger addional costs for insitu stabilisation. | 100000 | 145000 | 480000
10 | Clearing of EECs and habitat for threatened species. Triggered by vegetation clearing. | 100000 | 200000 | 600000
16 | Encountering legacy contamination during construction including:  1. Coal tar (in pavement) 2. Asbestos  3. Other | 24000 | 48000 | 96000
26 | 1. Potential seasonal restrictions to road closures, lane configurations (e.g. school holidays, [NAME]) 2. Not willing to provide comment on likely ROL conditions until actual ROL submitted by contractor- uncertainty remains | 100000 | 200000 | 400000
27 | 1. Competition with large pipeline of work currently in NSW | 250000 | 625000 | 1250000
28 | 1. Lack of appropriately skilled contractors available  2. Competition with large pipeline of work | 78000 | 156000 | 312000
35 | 1. Limited ancillary site locations are available.  2. Sites identified wihtin REF have various contraints (overhead power lines etc) 3. Preferred site not yet secured, pending agreement from Ausgrid | 40000 | 60000 | 100000
37 | 1. Existing tree roots preventing installation of temporary sheet piling. | 5000 | 72500 | 195000
46 | 1. PSC specifications ambiguous 2. Work by others impacts on deliverables 3. Additional / unanticipated investogation required | 50000 | 100000 | 150000
47 | Aboriginal find during construction | 10000 | 20000 | 250000
52 | Unforeseen / unknown utilities at time of preparing concept design | 40000 | 100000 | 500000
54 | Bushfire in the surrounding areas (National Parks, [NAME]) | 60000 | 100000 | 200000
71 | Unanticipated construction conctract claims above and beyond the allowances made within this RA. | 125000 | 312500 | 625000
73 | Excavation for pavement foundations and/or retaining wall foundations encourter unanticipated (poor) ground conditions | 3600 | 14300 | 31500
Spreadsheet: 306108c5-0470-47d7-b372-6f261aa6619d
Sheet: Sheet1

MD ID (country + ######) | Setting | Patient ID | Date ##/##/## | Patient Age (years) | Sex (M or F) | Local epidemy (Y or N) | Acute onset (<36 hours)(Y or N) | T° value | SYMPTOMS 0=absent/1=mild/2=moderate/3=severe | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | A/H1N1 (Y or N or ?) | Symptom 1 used for [NAME]. Remedy choice | Symptom 2 used for [NAME]. Remedy choice | Symptom 3 used for [NAME]. Remedy choice | Symptom 4 used for [NAME]. Remedy choice | Symptom 5 used for [NAME]. Remedy choice | Symptom 6 used for [NAME]. Remedy choice | [NAME] (name, dilution, dosage) | Other treatment 1 and dosage | Other treatment 2 and dosage | Other treatment 3 and dosage | Overall Health Status Using scale: 0 (very bad) to 10 (best possible) | Concomitants
ex: BE15MVW | (Private or Public or Hospital) |  |  |  |  |  |  |  | Fatigue | Malaise | Sweat/Chills | Myalgia | Headache | Cough | Rhinorrhoea | Sore throat | Nose obstruction | Tears or Red eyes | Nausea | Diarrhoea | other 1 (description + value) | other 2 (description + value) | other 3 (description + value) |  |  |  |  |  |  |  |  |  |  |  |  | Previous Diseases or treatment
Spreadsheet: 473393d1470180622-auto-populate-calendar-from-list-of-events-in-2-tables-ef945_calendar_two_tables
Sheet: Data_Entry

 | English |  | Chinese
Title | Date | Day | Date | Day | RANK
Event 1 | 2016-01-04 00:00:00 |  | 2016-01-06 00:00:00 |  |  |  | Formulae in columns C, E and F already copied down to row 100 - copy further as required
Event 2 | 2016-01-05 00:00:00 |  | 2016-01-07 00:00:00
Event 3 | 2016-01-04 00:00:00 |  |  |  |  |  | Some test data - replace with your own
Event 4 | 2016-01-01 00:00:00 |  | 2016-01-01 00:00:00 |  |  |  | Some test data - replace with your own
Spreadsheet: 486735d1477646470-american-date-to-english-date-format-test-sheet-dates
Sheet: VERSION CONTROL - DO DELETE

Version | Date | Author | Department | Description of change
[NAME] V0.1 | 2015-03-07 00:00:00 | [NAME] | Enterprise & Data Solutions Service Delivery | Template Added for Department
V1.0 | 2015-03-07 00:00:00 | [NAME] | Enterprise & Data Solutions Service Delivery | Document Created
[NAME] | 2015-05-11 00:00:00 | [NAME] | Enterprise & Data Solutions Service Delivery | Change to CSP level 2 contact ([NAME])
V1.2 | 2015-07-06 00:00:00 | [NAME] | Enterprise & Data Solutions Service Delivery | Split of EFM And EAD Modifies for correct headers
V1.3 | 2015-09-29 00:00:00 | [NAME] | Enterprise & Data Solutions Service Delivery | Change to CSP Level 3 Contact ([NAME])
V1.4 | 2015-11-17 00:00:00 | [NAME] | Enterprise & Data Solutions Service Delivery | Change to CSP Level 2 and Level 3 Email Addresses Updated
V1.5 | 2016-03-09 00:00:00 | [NAME] | Enterprise & Data Solutions Service Delivery | Delivery Co-ordinator and B-end installation post code
V1.6 | 2016-03-09 00:00:00 | [NAME] | Enterprise & Data Solutions Service Delivery | New Branding added.
Name |  | Department | Version | Approval
[NAME] |  | Enterprise & Data Solutions Delivery | V1.0 to V1.1 | Self Approved (Delegated Authority)
[NAME] |  | Enterprise & Data Solutions Delivery | V1.2 - V1.4 | Self Approved (Delegated Authority)
[NAME] |  | Enterprise & Data Solutions Delivery | V1.4 - V1.5 | Self Approved (Delegated Authority)
[NAME] |  | Enterprise & Data Solutions Delivery | V1.5 - V1.6 | Self Approved (Delegated Authority)
Spreadsheet: 850004d1700396057-compare-2-columns-ef
Sheet: Sheet1

Column A | Column B |  | Unique in A | Unique in B | Common
Q | A
W | S
E | D
A | F
T | Q
Y | H
U | J
I | K
K
Spreadsheet: 5203fff8-ddb5-48cc-9aae-d80c3bfbd1db
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 | logo
 |  |  |  | Service business costing and pricing
 | Calculate your projected monthly charge out hours. Ensure that you take into consideration that as a small business owner some of your time will be spent doing other things bsides just selling time. Be realistic when you calculate how many hours you can charge out every month.
 |  |  |  | Insert your projected monthly business expenses in this table
 | Monthly Fixed Expenses
 | Accounting fees | ………… | 50 |  | Total fixed expenses ÷ Number of charge out hours
 | Advertising | ………… | 200
 | Bank charges | ………… | 45
 | Owner's drawings | ………… | 10000 |  | Number of projected charge out hours ………. | 120
 | Hydro | ………… | 100
 | Internet | ………… | 85 |  | Minimum Hourly Rate ………………………….. | 95.5
 | Employee benefits | ………… | 0 |  | Market Price ……………………………………. | 60
 | Petty cash | ………… | 100 |  | Note: If you increase your charge out rate your break even number of hours will come down.
 | Insurance | ………… | 175
 | Rent | ………… | 400 |  | My Price per Hour ……………………………… | 100
 | Stationery | ………… | 30
 | Telephone and cell phone | ………… | 230 |  | Monthly Survival Break Even
 | Salaries | ………… | 0
 | Depreciation | ………… | 45 |  | Charge out rate …………………………………. | 100
 | Interest on loan | ………… | 0
 | Other expenses | ………… | 0 |  | Number of hours to need to sell each month to survive: | 114.6
 | Other expenses | ………… | 0
 |  | Total fixed expenses: | 11460
Spreadsheet: 815971d1675287727-formula-to-lookup-payment-with-payment-amount-and-date-sample5
Sheet: Sheet1

Month | Payment
Jan | 263.35 |  |  |  | Payment | 263.35
Feb | 263.35 |  |  |  |  |  |  |  | Would like to see these results
Mar | 263.35 |  |  |  | Jan | Insert formula here… |  |  | 263.35
Apr | 263.35 |  |  |  | Feb | Insert formula here… |  |  | 263.35
May | 263.35 |  |  |  | Mar |  |  |  | 263.35
Jun | 263.35 |  |  |  | Apr |  |  |  | 263.35
Jul | 263.35 |  |  |  | May |  |  |  | 263.35
Aug | 263.35 |  |  |  | Jun |  |  |  | 263.35
Sep | 263.35 |  |  |  | Jul |  |  |  | 263.35
Oct | 263.35 |  |  |  | Aug |  |  |  | 263.35
Nov | 263.35 |  |  |  | Sep |  |  |  | 263.35
Dec | 263.35 |  |  |  | Oct |  |  |  | 263.35
 |  |  |  |  | Nov |  |  |  | 263.35
 |  |  |  |  | Dec |  |  |  | 263.35
Spreadsheet: 820676d1678236092-formula-to-lookup-asset-value-based-on-month-sample21
Sheet: Sheet1

 | Current Month
 | Asset 1 |  |  |  | Asset 1 | Asset 2 | Asset 3 | Asset 4 | Asset 5
 | Asset 2 |  |  | Jan | 21000 | 52000 | 24000 | 31000 | 33000
 | Asset 3 |  |  | Feb | 25000 | 65000 | 30000 | 34000 | 35000
 | Asset 4 | [NAME] |  | Mar | 40000 | 72000 | 29000 | 35000 | 38000
 | Asset 5 | [NAME] |  | Apr
 |  |  |  | May
 |  |  |  | Jun
 |  |  |  | Jul
 |  |  |  | Aug
 |  |  |  | Sep
 |  |  |  | Oct
 |  |  |  | Nov
 |  |  |  | Dec
Spreadsheet: lisa_gang__22460__Hanson Scheduling Model_5_30
Sheet: Scheduling

 |  |  |  |  | HANSON PERMANENTE CEMENT
 |  |  |  |  |  | Power Usage Forecast
 | CALIFORNIA SCHEDULING COORDINATION AND
 | ENERGY PURCHASES AND SALES AGREEMENT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monday: Tuesday Scheduling
 | Day of Scheduling |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tuesday: Wednesday Scheduling
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wednesday: Thursday Scheduling
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Thursday: Friday & Saturday Scheduling
 | 2002-05-30 00:00:00 | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | Total |  |  |  |  |  |  |  |  | Friday: Sunday and Monday LLH Scheduling
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 |  |  |  |  |  |  |  |  |  | Friday: Monday HLH
 |  | 13.5 | 13.872 | 13.992 | 13.98 | 13.992 | 13.428 | 14.784 | 15.06 | 15.06 | 15.144 | 15.276 | 15.168 | 15.108 | 15.048 | 14.832 | 14.364 | 14.148 | 14.388 | 14.604 | 14.94 | 15.096 | 14.46 | 14.688 | 14.784 |  |  |  |  |  |  |  |  |  | Holiday
 |  | 14.19523590669259 | 14.19523590669259 | 14.19523590669259 | 14.19523590669259 | 14.19523590669259 | 14.19523590669259 | 14.19523590669259 | 14.19523590669259 | 14.19523590669259 | 14.19523590669259 | 14.19523590669259 | 14.19523590669259 | 5.98 | 5.98 | 5.98 | 5.1 | 5.1 | 5.1 | 13.31523590669259 | 13.31523590669259 | 14.19523590669259 | 14.19523590669259 | 14.19523590669259 | 14.19523590669259
 | Day Ahead Incremental Quantity (Hanson needs to purchase)
 | Day Ahead Decremental Quantity (Hanson needs to sell)
 | Contact Persons
 | EPMI | Telephone |  |  | E-Mail
 | [NAME] | 503/464-3829 |  |  | [EMAIL]
 | [NAME] | 503/464-5053 |  |  | [EMAIL]
 | [NAME] | 503/464-3822 |  |  | [EMAIL]
 | [NAME] | 503/464-3824 |  |  | [EMAIL]
 | [NAME] | [PHONE] |  |  | [EMAIL]
 | Hanson | Telephone |  |  | E-Mail
 | [NAME] Manager | [PHONE] |  |  | [EMAIL]
 | [NAME] Engineer | [PHONE] |  |  | [EMAIL]
 | [NAME]  - VP Operations | [PHONE] |  |  | [EMAIL]
 | [NAME] | [PHONE] |  |  | [EMAIL]
Spreadsheet: diana_scholtes__8594__Modesto_lossrtn_settlement
Sheet: Sheet1

 | DJ-COB | Index * 4.5 % [NAME] | Settlement for STCA | Settlement for STNW
2001-11-07 00:00:00 | 30.15 | 1.36
2001-11-08 00:00:00 | 28.87 | 1.3
2001-11-09 00:00:00 | 28.89 | 1.3 |  |  |  |  |  |  |  | Sales | 1625704
2001-11-10 00:00:00 | 28.7 | 1.29 | 0 |  | Didn't use. |  |  |  |  | Purchases | 1710648
 |  |  |  |  |  |  |  |  |  | Transmission | 32000
2001-11-12 00:00:00 | 30.96 | 1.39 |  |  |  |  |  |  |  | [NAME]
2001-11-13 00:00:00 | 31.02 | 1.4
2001-11-14 00:00:00 | 24.51 | 1.1 |  |  |  |  |  |  |  | Net
2001-11-15 00:00:00 | 22.92 | 1.03
2001-11-16 00:00:00 | 19.98 | 0.9
2001-11-17 00:00:00 | 19.98 | 0.9
2001-11-19 00:00:00 | 19.67 | 0.89
2001-11-20 00:00:00 | 16.46 | 0.74
2001-11-21 00:00:00 | 16.46 | 0.74
2001-11-23 00:00:00 | 20.34 | 0.92
2001-11-24 00:00:00 | 20.34 | 0.92
2001-11-26 00:00:00 | 22.11
2001-11-27 00:00:00 | 22.87
2001-11-28 00:00:00 | 29.29
2001-11-29 00:00:00 | 31.46
2001-11-30 00:00:00 | 31.46
 |  |  |  |  | *Minus Nov 7 due to Annuity already in system. (859377.1 ; 859389.1)
Spreadsheet: 860735d1708719411-filtered-formulas-investements-sample
Sheet: Sheet2

 |  |  |  |  |  |  |  |  |  |  |  |  | Gain
Date | Year | Open | TFSA | RRSP | Subtotal | GIC | Secure | Growth | Subtotal2 | other bank RRSP3 | Total | Investements | Notes
2022-01-01 00:00:00 |  | 475 | 475 | 475 |  | 475 | 475 | 475 |  | 475
2022-01-07 00:00:00 |  | 450 | 450 | 450 |  | 450 | 450 | 450 |  | 450
2022-01-10 00:00:00 |  | 490 | 490 | 490 |  | 490 | 490 | 490 |  | 490
2023-04-23 00:00:00 |  | 500 | 500 | 500 |  | 500 | 500 | 500 |  | 500
2023-05-01 00:00:00 |  | 510 | 510 | 510 |  | 510 | 510 | 510 |  | 510
2023-05-01 00:00:00 |  | 520 | 520 | 520 |  | 520 | 520 | 520 |  | 520 |  | 150
2023-07-01 00:00:00 |  | 525 | 525 | 525 |  | 525 | 525 | 525 |  | 525 |  | 75
2024-08-14 00:00:00 |  | 485 | 485 | 485 |  | 485 | 485 | 485 |  | 485
2024-08-14 00:00:00 |  | 600 | 600 | 600 |  | 600 | 600 | 600 |  | 600 |  | 100
2024-08-30 00:00:00 |  | 550 | 550 | 550 |  | 550 | 550 | 550 |  | 550
Spreadsheet: 756819d1637805408-calculate-3-year-standard-deviation-using-monthly-and-quarterly-returns-on-the-s-and-p-500-standdev-on-s-and-p-500-3yr-
Sheet: Sheet1

 |  | Monthly Returns for the S&P 500 |  |  |  | Quarterly Returns for the S&P 500
 | 3 Year Standard Deviation |  |  |  |  | 3 Year Standard Deviation
 |  |  | [NAME] |  |  |  |  | Quarterly Returns
 |  | 2021-09-21 00:00:00 | -0.0465 |  |  | Q3 2021 |  | 0.0058
 |  | 2021-08-21 00:00:00 | 0.0304 |  |  | Q2 2021 |  | 0.0855
 |  | 2021-07-21 00:00:00 | 0.0238 |  |  | Q1 2021 |  | 0.0617
 |  | 2021-06-21 00:00:00 | 0.0233 |  |  | Q4 2020 |  | 0.1215
 |  | 2021-05-21 00:00:00 | 0.007 |  |  | Q1 2020 |  | 0.0893
 |  | 2021-04-21 00:00:00 | 0.0534 |  |  | Q2 2020 |  | 0.2054
 |  | 2021-03-21 00:00:00 | 0.0438 |  |  | Q3 2020 |  | -0.196
 |  | 2021-02-21 00:00:00 | 0.0276 |  |  | Q4 2019 |  | 0.0907
 |  | 2021-01-21 00:00:00 | -0.0101 |  |  | Q3 2019 |  | 0.017
 |  | 2020-12-21 00:00:00 | 0.0384 |  |  | Q2 2019 |  | 0.043
 |  | 2021-11-20 00:00:00 | 0.1095 |  |  | Q1 2019 |  | 0.1365
 |  | 2021-10-21 00:00:00 | -0.0266 |  |  | Q4 2018 |  | -0.1352
 |  | 2021-09-20 00:00:00 | -0.038
 |  | 2021-08-20 00:00:00 | 0.0719
 |  | 2021-07-20 00:00:00 | 0.0564
 |  | 2021-06-20 00:00:00 | 0.0199
 |  | 2021-05-20 00:00:00 | 0.0476
 |  | 2021-04-20 00:00:00 | 0.1282
 |  | 2021-03-20 00:00:00 | -0.1235
 |  | 2021-02-20 00:00:00 | -0.0823
 |  | 2021-01-20 00:00:00 | -0.0004
 |  | 2019-12-20 00:00:00 | 0.0302
 |  | 2021-11-19 00:00:00 | 0.0363
 |  | 2021-10-19 00:00:00 | 0.0217
 |  | 2021-09-19 00:00:00 | 0.0187
 |  | 2021-08-19 00:00:00 | -0.0158
 |  | 2021-07-19 00:00:00 | 0.0144
 |  | 2021-06-19 00:00:00 | 0.0705
 |  | 2021-05-19 00:00:00 | -0.0635
 |  | 2021-04-19 00:00:00 | 0.0405
 |  | 2021-03-19 00:00:00 | 0.0194
 |  | 2021-02-19 00:00:00 | 0.0321
 |  | 2021-01-19 00:00:00 | 0.0801
 |  | 2021-12-18 00:00:00 | -0.0903
 |  | 2021-11-18 00:00:00 | 0.0204
 |  | 2021-10-18 00:00:00 | -0.0684
Spreadsheet: 166201d1341499522-some-sort-of-lookup-and-return-value-test-
Sheet: Totals

 | Number of Each Sport | How Many Are Completed | Outstanding
Hockey |  | 1
Softball |  | 2
Other
Soccer
Skiing
Walking
Spreadsheet: 116125d1311613952-excel-2007-sum-if-across-range-possibly-using-index-match-sumproduct-or-hlookup-sample
Sheet: Source data

 | 2011-09-30 00:00:00 | 2011-10-31 00:00:00 | 2011-11-30 00:00:00
Line 1 |  | 10000 | 15000
Line 2 |  |  | 80000
Line 3 | 20000
Line 4 |  | 10000
Line 5
Line 6
Week | 2011-09-09 00:00:00 | 2011-09-16 00:00:00 | 2011-09-23 00:00:00 | 2011-09-30 00:00:00 | 2011-10-07 00:00:00 | 2011-10-14 00:00:00 | 2011-10-21 00:00:00 | 2011-10-28 00:00:00 | 2011-11-04 00:00:00 | 2011-11-11 00:00:00 | 2011-11-18 00:00:00 | 2011-11-25 00:00:00 | 2011-12-02 00:00:00 | 2011-12-09 00:00:00 | 2011-12-16 00:00:00 | 2011-12-23 00:00:00 | 2011-12-30 00:00:00
Month | 2011-09-30 00:00:00 | 2011-09-30 00:00:00 | 2011-09-30 00:00:00 | 2011-09-30 00:00:00 | 2011-10-31 00:00:00 | 2011-10-31 00:00:00 | 2011-10-31 00:00:00 | 2011-10-31 00:00:00 | 2011-11-30 00:00:00 | 2011-11-30 00:00:00 | 2011-11-30 00:00:00 | 2011-11-30 00:00:00 | 2011-11-30 00:00:00 | 2011-12-31 00:00:00 | 2011-12-31 00:00:00 | 2011-12-31 00:00:00 | 2011-12-31 00:00:00
End of Month? |  |  |  | Yes |  |  |  | Yes |  |  |  |  | Yes |  |  |  | Yes
End of Month - date
Sum of lines 1 -6
Spreadsheet: darrell_schoolcraft__7808__imbalsumm0108
Sheet: EPFS

 | El Paso/TW Eddy Rec
 | 78093
Day | Measured | Scheduled
1 | 32539 | 31400
2 | 32516 | 31400
3 | 39547 | 36521
4 | 37821 | 33628
5 | 35429 | 38484
6 | 39523 | 38484
7 | 40822 | 38500
8 | 41242 | 38499
9 | 39629 | 37100
10 | 39802 | 37879
11 | 39852 | 38499
12 | 18864 | 24382
13 | 34489 | 35457
14 | 40193 | 39600
15 | 40662 | 38879
16 | 38470 | 39600
17 | 40314 | 39600
18 | 40863 | 39600
19 | 39065 | 39600
20 | 40407 | 39600
21 | 42092 | 36760
22 | 41126 | 35000
23
24
25
26
27
28
29
30
31
2001-07-31 00:00:00 |  |  | -38120.6
2001-08-22 00:00:00
CBS Volume
 |  |  | -2104