tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 883726d1732378621-excel-lookup-help-required-eoy-2024-new-eba
Sheet: KPI Details

DEPARTMENT | POSITION | REPORTING TO | CATEGORY | [NAME] | [NAME]
Claims & Network Management | Senior Motor Claims Operations Manager | Deputy Chief Executive Officer | DELIVER FINANCIAL RESULTS | Maintain an ideal loss ratio for the motor claims department in line with company standards | Increase the Gross written premium with 4% by providing effective service to the clients
 |  |  |  |  | Maintain margin level of Reserves & Outstanding's with 3%
 |  |  |  |  | Secure average claims recovery with 5% increment
 |  |  |  |  | Maintain healthy combined loss ratio
 |  |  |  |  | Maintain and reduce the average cost per claim
 |  |  | ADVANCED OPERATIONS | Improve the internal operations in the motor claims department | Average handling time for claims
 |  |  |  |  | Improve the efficiency of the cooperation and communication between the department team members to reduce the cycle time, speed of production and resolving any obstacles through a planned monthly meeting with the team and with other related stakeholders
 |  |  |  |  | Improve internal tracking of claims numbers & Cost so that risk are minimized and opportunities are maximized (Timely and Accurate Reporting)
 |  |  | SERVICE TO CUSTOMERS | IMPROVE CUSTOMER EXPERIENCE AND SATISFACTION | Average time to handle Direct customer complaints
 |  |  |  |  | Average time to handle customer complaints received from IRU
 |  |  | LEARNING AND GROWTH | IMPROVE THE LEARNING AND GROWTH ENVIRONMENT WITHIN THE DEPARTMENT | Understand, communicate and implement the department KPIs, policies and procedures
 |  |  |  |  | Implement personal and behavioral training to the department's employees
 |  |  |  |  | Implement technical training to the department's employees in relation to the insurance, underwriting, and Claims
Spreadsheet: 127293d1320271127-help-using-match-and-index-i-think-sample-worksheet
Sheet: Sheet1

NAME | 11-12 Salary | BASIC ED | K-4 |  | SPEC ED | IDEA | PreK | VOC | MidVoc | TITLE I | Even St | Title IIA | MIGRANT | LAP | EACAP | Title III | BILINGUAL | HiCap | D wide | Total
 |  | 0100 |  | 0155 | 2100 | 2400 | 2415 | 3100 | 3400 | 5100 | 5105 | 5200 | 5300 | 5500 | 5843 | 6400 | 6500 | 7400 | 9700
Adams, [NAME] | 52581 |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | 1
Atkins, Vice | 62955 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  | 1
Aman, [NAME] | 62955 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Ala, Cat | 62955 |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Andersen, Brick | 56597 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Anderten, Deb | 46652 |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  | 1
[NAME], [NAME] | 62955 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Arlington, [NAME] | 56597 |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  | 1
Arlington, Travis | 47332 |  |  |  | 0.5 | 0.5 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Ava, Joey | 56597 |  |  |  |  | 0.9 | 0.1 |  |  |  |  |  |  |  |  |  |  |  |  | 1
Barllot, [NAME] | 48768 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Baxtor, Sean | 47602 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Beedman, Heather | 43594 |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Beetle, [NAME] | 58370 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Spreadsheet: 104849d1302285217-adding-prefix-to-numbers-dph150_after
Sheet: Lookups

Prefix | Component |  | Prefix | Component |  | Prefix | Component |  | Concatenated
020 | RES |  | 020 | RES |  | 020 | RES |  | 020 RES |  | 1 | 020
020 | RES |  | 022 | CAP |  | 022 | CAP |  | 022 CAP |  | 1 | 022
020 | RES |  | 023 | INDUCTOR |  | 023 | INDUCTOR |  | 023 INDUCTOR |  | 3 | 023
020 | RES |  | 023 | IND |  | 024 | IC |  | 023 IND |  | 3 | 023
020 | RES |  | 024 | IC |  | 029 | OSCLTR |  | 024 IC |  | 4 | 024
020 | RES |  | 024 | TRANSISTOR |  | 026 | CONN |  | 024 TRANSISTOR |  | 4 | 024
020 | RES |  | 024 | DIODE |  | 033 | TESTPOINT |  | 024 DIODE |  | 4 | 024
020 | RES |  | 024 | ALT |  |  |  |  | 024 ALT |  | 4 | 024
020 | RES |  | 029 | OSCLTR |  |  |  |  | 029 OSCLTR |  | 2 | 029
020 | RES |  | 023 | XFMR |  |  |  |  | 029 ALT |  | 2 | 029
020 | RES |  | 026 | CONN |  |  |  |  | 023 XFMR |  | 3 | 023
020 | RES |  | 033 | TESTPOINT |  |  |  |  | 026 CONN |  | 2 | 026
020 | RES |  |  |  |  |  |  |  | 026 ALT |  | 2 | 026
020 | RES |  |  |  |  |  |  |  | 033 TESTPOINT |  | 1 | 033
020 | RES
020 | RES
022 | CAP
022 | CAP
022 | CAP
022 | CAP
022 | CAP
022 | CAP
022 | CAP
022 | CAP
022 | CAP
022 | CAP
022 | CAP
022 | CAP
023 | INDUCTOR
023 | INDUCTOR
023 | IND
024 | IC
024 | TRANSISTOR
024 | IC
024 | DIODE
024 | DIODE
024 | IC
024 | DIODE
024 | ALT
024 | ALT
024 | DIODE
024 | DIODE
024 | IC
024 | IC
029 | OSCLTR
029 | ALT
020 | RES
023 | XFMR
024 | IC
026 | CONN
026 | CONN
026 | CONN
026 | CONN
026 | ALT
026 | ALT
033 | TESTPOINT
033 | TESTPOINT
033 | TESTPOINT
033 | TESTPOINT
033 | TESTPOINT
033 | TESTPOINT
Spreadsheet: kate_symes__18826__Cob
Sheet: DJ COB Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-03-09 00:00:00 |  | 228.93 | 5600 | 165 | 600
 | 2001-03-08 00:00:00 |  | 276.67 | 6000 | 200 | 200 | 346.11 | 3730 | 314.25 | 2395
 | 2001-03-07 00:00:00 |  | 340.26 | 7600 | 263.33 | 600 | 350.64 | 3925 | 325.92 | 1567
 | 2001-03-06 00:00:00 |  | 338.57 | 2800 | 269.58 | 960 | 357.4 | 2896 | 344.21 | 1295
 | 2001-03-05 00:00:00 |  | 327 | 2000 | 306.25 | 800 | 344.21 | 4538 | 365.1 | 1235
 | 2001-03-04 00:00:00 |  |  |  |  |  |  |  | 330 | 1125 |  | 306.25 | 2400
 | 2001-03-03 00:00:00 |  | 298.33 | 4800 | 223.97 | 584 | 350 | 75 | 350 | 600
 | 2001-03-02 00:00:00 |  | 298.33 | 4800 | 223.97 | 584 | 365 | 200 | 350 | 285
 | 2001-03-01 00:00:00 |  | 292.12 | 6800 | 280 | 200 | 429.4 | 1762 | 326.61 | 930
 | 2001-02-28 00:00:00 |  | 200.76 | 5152 | 183.49 | 1328 | 338.36 | 10459 | 285.21 | 1523
 | 2001-02-27 00:00:00 |  | 202.25 | 2912 | 135 | 200 | 275.53 | 4475 | 267.2 | 795
 | 2001-02-26 00:00:00 |  | 248.21 | 5600 | 195 | 240 | 258.41 | 5480 | 226.05 | 950
 | 2001-02-25 00:00:00 |  |  |  |  |  |  |  | 181.6 | 2500 |  | 200 | 360
 | 2001-02-24 00:00:00 |  | 196.43 | 2800 | 140 | 200 | 214.05 | 4252 | 232.89 | 760
 | 2001-02-23 00:00:00 |  | 196.43 | 2800 | 140 | 200 | 296.91 | 1345 | 300 | 400
 | 2001-02-22 00:00:00 |  | 261 | 4000 | 200 | 200 | 233.22 | 2500 | 222.69 | 1730
 | 2001-02-21 00:00:00 |  | 283.75 | 4800 | 240 | 200 | 425 | 1050 | 372 | 750
 | 2001-02-20 00:00:00 |  | 326.82 | 4400 | 300 | 600 | 324.71 | 8650 | 350.06 | 1975
 | 2001-02-19 00:00:00 |  | 326.15 | 5200 | 300 | 600 | 382.2 | 4390 | 356.1 | 1540
 | 2001-02-18 00:00:00 |  |  |  |  |  |  |  | 399.12 | 4290 |  | 320 | 600
 | 2001-02-17 00:00:00 |  | 346.07 | 3360 | 320 | 200 | 397.33 | 8623 | 394.97 | 2510
 | 2001-02-16 00:00:00 |  | 448.85 | 5200 | 425 | 200 | 444.06 | 5450 | 419.61 | 1985
 | 2001-02-15 00:00:00 |  | 448.85 | 5200 | 425 | 200 | 436.92 | 5630 | 480.72 | 1815
 | 2001-02-14 00:00:00 |  | 323 | 2000 | 300 | 0 | 601.45 | 2755 | 404.44 | 1970
 | 2001-02-13 00:00:00 |  | 307.5 | 2400 | 315 | 0 | 400.85 | 9115 | 379.49 | 2005
 | 2001-02-12 00:00:00 |  | 287.5 | 2400 | 277.5 | 0 | 380.82 | 9260 | 330.18 | 1690
 | 2001-02-11 00:00:00 |  |  |  |  |  |  |  | 398.34 | 5105 |  | 250 | 0
 | 2001-02-10 00:00:00 |  | 255.63 | 3200 | 217.5 | 400 | 385.49 | 9007 | 373.04 | 3310
 | 2001-02-09 00:00:00 |  | 255.63 | 3200 | 217.5 | 400 | 385.64 | 9525 | 391.75 | 2705
 | 2001-02-08 00:00:00 |  | 360.63 | 3200 | 300 | 48 | 407.79 | 7436 | 402.59 | 2830
 | 2001-02-07 00:00:00 |  | 301.25 | 4800 | 231.43 | 1400 | 415.92 | 7768 | 431.28 | 1750
 | Explanatory Notes
 | R = REVISED |  |  | S = SURVEYED DATA |  |  |  | N/Q - NO QUOTE
 | Index: Weighted average price of megawatthours sold at COB. The Index is quoted in $/Mwh.
 | For questions or comments please call Antoine Eustache (609)520-7058 or [NAME] (609) 520-7067.
Spreadsheet: 681061d1591336574-counting-number-of-times-an-age-appears-when-calculated-from-dob-formula-used-book1-6-
Sheet: Sheet1

2020-04-21 00:00:00 | 2006-03-08 00:00:00
2020-04-21 00:00:00 | 2008-09-21 00:00:00
2020-04-29 00:00:00 | 2009-05-05 00:00:00
2020-04-29 00:00:00 | 2008-02-05 00:00:00
2020-04-29 00:00:00 | 2009-03-23 00:00:00
2020-04-30 00:00:00 | 2010-05-02 00:00:00 |  | 2000-01-01 00:00:00 | Start date
 |  |  | 2025-01-01 00:00:00 | end date
 |  |  |  |  | bmv's
 |  | 10yo |  | This should read as 1 occasion counted.
 |  | 11yo |  | should be 3
 |  | 12yo |  | should be 1
 |  |  |  | etc
Spreadsheet: 837197d1689930556-shape-select-issue-shape-select-issue
Sheet: Chart ONE

0.02
-0.01
0.03
0.02
-0.02
0.05
-0.01
-0.01
0.02
0.03
Spreadsheet: 173334d1344518393-sumproduct-formula-only-counting-dates-in-column-copy-of-sumproduct-sample
Sheet: DateCount

2011-01-01 00:00:00 | 2021-01-31 00:00:00 | January | 2001
2001-02-01 00:00:00 | 2001-02-28 00:00:00 | February | 2001
2001-03-01 00:00:00 | 2001-03-31 00:00:00 | March | 2001
2001-04-01 00:00:00 | 2001-04-30 00:00:00 | April | 2001
2001-05-01 00:00:00 | 2001-05-31 00:00:00 | May | 2001
2001-06-01 00:00:00 | 2001-06-30 00:00:00 | June | 2001
2001-07-01 00:00:00 | 2001-07-31 00:00:00 | July | 2001
2001-08-01 00:00:00 | 2001-08-31 00:00:00 | August | 2001
2001-09-01 00:00:00 | 2001-09-30 00:00:00 | September | 2001
2001-10-01 00:00:00 | 2001-10-31 00:00:00 | October | 2001
2001-11-01 00:00:00 | 2001-11-30 00:00:00 | November | 2001
2001-12-01 00:00:00 | 2001-12-31 00:00:00 | December | 2001
Spreadsheet: 873559d1720060267-how-to-create-automated-lookups-without-having-to-do-multiple-vlookups-template-example
Sheet: Reps Promo Report

DATE:
SALES REP | % |  | [NAME] | PROMOTION |  | PROMOTION |  | PROMOTION |  | PROMOTION
 |  |  | STOCKISTS | NA1 |  | NA2 |  | NA3 |  | NA4
 |  |  |  |  | UNITS SOLD |  | UNITS SOLD |  | UNITS SOLD |  | UNITS SOLD
Qty on PO | % by Warehouse | % by State
NSW
Rep1 |  |  |  |  | ? |  | ? |  | ? |  | ?
[NAME] |  |  |  |  | ? |  | ? |  | ? |  | ?
Rep3 |  |  |  |  | ? |  | ? |  | ? |  | ?
Rep4 |  |  |  |  | ? |  | ? |  | ? |  | ?
Rep5 |  |  |  |  | ? |  | ? |  | ? |  | ?
Rep6 |  |  |  |  | ? |  | ? |  | ? |  | ?
 |  |  |  |  | ? |  | ? |  | ? |  | ?
Rep8 |  |  |  |  | ? |  | ? |  | ? |  | ?
Rep9 |  |  |  |  | ? |  | ? |  | ? |  | ?
Rep10 |  |  |  |  | ? |  | ? |  | ? |  | ?
Rep11 |  |  |  |  | ? |  | ? |  | ? |  | ?
Rep12 |  |  |  |  | ? |  | ? |  | ? |  | ?
 |  |  |  |  | ? |  | ? |  | ? |  | ?
[NAME] |  |  |  |  | ? |  | ? |  | ? |  | ?
Rep15 |  |  |  |  | ? |  | ? |  | ? |  | ?
Rep16 |  |  |  |  | ? |  | ? |  | ? |  | ?
Rep17 |  |  |  |  | ? |  | ? |  | ? |  | ?
Rep18 |  |  |  |  | ? |  | ? |  | ? |  | ?
 |  |  |  |  | ? |  | ? |  | ? |  | ?
Rep20 |  |  |  |  | ? |  | ? |  | ? |  | ?
[NAME] |  |  |  |  | ? |  | ? |  | ? |  | ?
 |  |  |  |  | ? |  | ? |  | ? |  | ?
Rep23 |  |  |  |  | ? |  | ? |  | ? |  | ?
Rep24 |  |  |  |  | ? |  | ? |  | ? |  | ?
TOTAL AVAILABLE TO SELL
TOTAL SOLD
PERCENTAGE SOLD PER SKU
Spreadsheet: 859450d1707835633-recursive-lambda-samplefile
Sheet: Sheet1

 | MGRNAME | MGRID | EENAME | EEID | HLVL |  |  | Direct | Indirect
 | [NAME] | 123 | [NAME] | 134 | 1 |  | [NAME] | 4 | 24
 | [NAME] | 123 | [NAME] | 145 | 1 |  | [NAME] | 3 | 5
 | [NAME] | 123 | [NAME] | 198 | 1 |  | [NAME] | 3 | 13
 | [NAME] | 123 | [NAME] | 156 | 1 |  | [NAME] | 5 | 8
 | [NAME] | 134 | [NAME] | 456 | 2 |  | [NAME] | 5 | 0
 | [NAME] | 134 | [NAME] | 845 | 2 |  | Missy Rower | 8 | 0
 | [NAME] | 134 | [NAME] | 334 | 2
 | [NAME] | 145 | [NAME] | 688 | 2
 | [NAME] | 145 | [NAME] | 543 | 2
 | [NAME] | 145 | [NAME] | 789 | 2
 | [NAME] | 543 | [NAME] | 877 | 3
 | [NAME] | 543 | [NAME] | 455 | 3
 | [NAME] | 543 | [NAME] | 322 | 3
 | [NAME] | 543 | Missy Rower | 111 | 3
 | [NAME] | 543 | [NAME] | 226 | 3
 | [NAME] | 456 | Carm Gower | 833 | 3
 | [NAME] | 456 | [NAME] | 412 | 3
 | [NAME] | 456 | [NAME] | 288 | 3
 | [NAME] | 456 | [NAME] | 999 | 3
 | [NAME] | 456 | [NAME] | 733 | 3
 | Missy Rower | 111 | [NAME] | 311 | 4
 | Missy Rower | 111 | [NAME] | 855 | 4
 | Missy Rower | 111 | [NAME] | 357 | 4
 | Missy Rower | 111 | [NAME] | 880 | 4
 | Missy Rower | 111 | [NAME] | 343 | 4
 | Missy Rower | 111 | [NAME] | 661 | 4
 | Missy Rower | 111 | [NAME] | 222 | 4
 | Missy Rower | 111 | [NAME] | 187 | 4
Spreadsheet: jeff_dasovich__14103__California PJM and NE Tables revised2
Sheet: A15

TABLE A15 FREQUENCY OF PRICE SPIKES IN CALIFORNIA ISO SPINNING RESERVE MARKET NP15
PRICE EQUALS OR EXCEEDS | FY 00/99 | FY 99/98
 | # of hours
 | % of available hours
100 | 164 | 182
 | 0.01867 | 0.02078
250 | 88 | 73
 | 0.01002 | 0.00833
500 | 41 | 0
 | 0.00467 | 0
750 | 7 | 0
 | 0.0008 | 0
1000 | 0 | 0
 | 0 | 0
Source: CAISO website (www.caiso.com)
FY 00/99: 8/1/1999-7/31/2000
FY 99/98: 8/1/1998-7/31/1999
Spreadsheet: 857929d1706782493-conditional-formatting-issue-audit-and-costs-template-working-version-ans
Sheet: Sheet1

 | Month | 2024-02-01 00:00:00 |  |  |  |  |  |  |  | Date
Name | [NAME]
Reg | AB12 CDE | Audit Date |  | By |  |  | Damages |  |  | Repair Costs |  | Total Costs
Entry | Damage | When Reported | Reported by | Damage Cost Estimate | Driver Liable | Approved by | Repair Cost | Repair Option Taken Self / Garage | Self Repair Completion Target Date | Self Repairs Satisfactory Yes / No | Self Repair Inspection by | Garage Repair Booked in Date | Garage Repair Completed Date | hidden column costs evaluate | Recovery From Wage Start | Monthly Recovery | Fully Paid
1 |  |  |  |  |  |  |  |  | 2024-02-10 00:00:00
2 |  |  |  |  |  |  |  |  |  |  |  | 2024-01-20 00:00:00
3
4
5
6
7 |  |  |  |  |  |  |  |  | 2024-03-05 00:00:00
8 |  |  |  |  |  |  |  |  | 2024-01-20 00:00:00
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Spreadsheet: 726013d1617018810-copy-value-based-on-date-range-inventory-
Sheet: Stock

 |  |  |  |  |  |  |  |  |  | Total value
Item | Supplier | Appendix | Invoice | Starting balance | Total price | Price pr. unit | Items in stock | Stockvalue
Item 1 | Supplier 1 | Appendix 1 | Invoice 1 | 1 | 3115.04
Item 2 | Supplier 2 | Appendix 2 | Invoice 2 | 1 | 810
Item 3 | Supplier 3 | Appendix 3 | Invoice 3 | 3 | 1876.29
Item 4 | Supplier 4 | Appendix 4 | Invoice 4 | 2 | 1493.21
Item 5 | Supplier 5 | Appendix 5 | Invoice 5 | 16 | 17007.07
Item 6 | Supplier 6 | Appendix 6 | Invoice 6 | 4 | 212.75
Item 7 | Supplier 7 | Appendix 7 | Invoice 7 | 23 | 16020.31
Item 8 | Supplier 8 | Appendix 8 | Invoice 8 | 20 | 13874.01
Item 9 | Supplier 9 | Appendix 9 | Invoice 9 | 1 | 5442.14
Item 10 | Supplier 10 | Appendix 10 | Invoice 10 | 7 | 790.3
Item 11 | Supplier 11 | Appendix 11 | Invoice 11 | 13 | 26369.79 |  | 0
Item 12 | Supplier 12 | Appendix 12 | Invoice 12 | 1 | 1772
Item 13 | Supplier 13 | Appendix 13 | Invoice 13 | 2 | 26634.01
Item 14 | Supplier 14 | Appendix 14 | Invoice 14 | 1 | 2471.75
Item 15 | Supplier 15 | Appendix 15 | Invoice 15 | 3 | 2714.25
Item 16 | Supplier 16 | Appendix 16 | Invoice 16 | 4 | 3479.86
Item 17 | Supplier 17 | Appendix 17 | Invoice 17 | 5 | 343.66
Item 18 | Supplier 18 | Appendix 18 | Invoice 18 | 5 | 385.56
Item 19 | Supplier 19 | Appendix 19 | Invoice 19 | 13 | 436615.85
Item 20 | Supplier 20 | Appendix 20 | Invoice 20 | 8 | 5602.4
Item 21 | Supplier 21 | Appendix 21 | Invoice 21 | 1 | 869.96
Item 22 | Supplier 22 | Appendix 22 | Invoice 22 | 16 | 641
Item 23 | Supplier 23 | Appendix 23 | Invoice 23 | 1 | 9604
Item 24 | Supplier 24 | Appendix 24 | Invoice 24 | 15 | 4185
Item 25 | Supplier 25 | Appendix 25 | Invoice 25 | 50 | 600
Item 26 | Supplier 26 | Appendix 26 | Invoice 26 | 1 | 22102
Item 27 | Supplier 27 | Appendix 27 | Invoice 27 | 150 | 1800
Item 28 | Supplier 28 | Appendix 28 | Invoice 28 | 5 | 1767
Item 29 | Supplier 29 | Appendix 29 | Invoice 29 | 2 | 2542
Item 30 | Supplier 30 | Appendix 30 | Invoice 30 | 2 | 208
Spreadsheet: 726604d1617311967-index-indirect-match-function-issue-indirect-invoice-total
Sheet: Completed Result

Invoice Period | Name | Invoice No | USD | CCY | Invoice Total CCY | Invoice Total USD
2021-01-01 00:00:00 | Example | 46547-[PHONE] | USD | N/A |  | 1324.5
2021-01-01 00:00:00 | Example | 166465789-[PHONE] | EUR | EUR | 654749
2021-01-01 00:00:00 | Example | 98787-299467989 | USD | N/A |  | 78543
2021-01-01 00:00:00 | Example | [PHONE]-[PHONE] | USD | N/A |  | 95467.65
2021-01-01 00:00:00 | Example | 48-000046549 | USD | N/A |  | 65497.14
Spreadsheet: 1dab41f3-4ee3-4cea-a4e5-665b5b791aab
Sheet: Rate Summary

Service Center Rate Summary Sheet
 | Service 1 | Service 2
Prior Year Fund Balance (if applicable)
Less Equipment Reserve
Revised Prior Year Fund Balance
ANNUAL COSTS
Salaries and [NAME]
Travel
Operating Costs
Equipment < $5,000
Capital equipment depreciation
TOTAL ANNUAL COSTS
% of Total Costs
Revised Prior Year Balance (Add Deficit, Subtract Surplus)
Estimated 2 months working capital
TOTAL REVISED COSTS
# of Annual Units
Unit Base
CALCULATED RATE PER SERVICE PER UNIT
SUBSIDY
Subsidized Rate
UNIT RATE THAT WILL BE CHARGED TO CUSTOMERS | 0 | 0
Current year rates
Spreadsheet: 843823d1695660524-blood-pressure-chart-help-please-
Sheet: לחץ דם

 |  | תאריך | 2023-06-17 00:00:00 | 2023-06-18 00:00:00 | 2023-06-19 00:00:00 | 2023-06-20 00:00:00 | 2023-06-21 00:00:00 | 2023-06-22 00:00:00 | 2023-06-23 00:00:00 |  | [NAME] | [NAME] | Week
 |  | בוקר |  |  |  |  |  |  |  |  | 80 | 120 | 17/6/2023 - 23/6/2023 | Example:
 |  | SYS | 110 | 128 | 155 | 155 | 155 | 120 | 110
 |  | DIA | 90 | 85 | 74 | 74 | 74 | 80 | 88
 |  | צהריים
 |  | SYS | 125 | 115 | 128 | 128 | 128 | 125 | 138
 |  | DIA | 81 | 70 | 78 | 78 | 78 | 81 | 74
 |  | ערב
 |  | SYS | 135 | 138 | 140 | 140 | 140 | 135 | 80
 |  | DIA | 88 | 80 | 72 | 72 | 72 | 88 | 84
Spreadsheet: tracy_geaccone__40337__Cont Uncontr Stretch
Sheet: Sheet1

 |  | Northern Natural Gas Company
 |  | Commercial Group
 |  | 2002 Plan Definitions
 |  | Contracted | Uncontracted | Idenfified Stretch | Unidentified Stretch
 |  | Firm Commodity
 |  | Long Term Firm-reservation-executed | Long Term Firm-reservation-unexecuted
 |  | Committed Capital Projects-reservation |  | Discretionary Capital Pool
 |  | Short Term Firm-reservation-executed
 |  |  |  | High risk deals or occurrences where a counter party or specific transaction is defined.    Dollars are  probability adjusted | Stretch numbers that are
 |  |  |  |  | only conceptual.
 |  |  | Daily Firms unexecuted
 |  |  | Interruptible commodity (historical, normal)
 |  |  | [NAME]
Spreadsheet: 685968d1594298893-finding-data-across-multiple-sheets-excelforum__help_file
Sheet: AH_Jan

 |  | 1
 |  | 2 | white
 |  | 3 | purple
 |  | 4
 |  | 5 | white
 |  | 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
Spreadsheet: phillip_allen__28944__pivot_0430
Sheet: Cu.Mon.Util

 |  | [NAME] |  | Electric & Water | Natural Gas |  | Overage
1-4 |  |  |  | 228.11
5-8 |  |  |  | 900
9-12 |  |  |  | 352.45
13 |  | 100 |  | 151.68
14 |  | 60 |  | 104.53
15 |  | 60 |  | 51.44
16 |  | 60 |  | 26.25
17 |  | 60 |  | 140.11
18 |  | 60 |  | 95.21
19 |  | 80 |  | 19.49
20 |  | 120 |  | 113.79
21 |  | 80 |  | 148.61
22 |  | 80 |  | 56.94
23 |  | 80 |  | 47.44
24 |  | 100 |  | 223.97
25 |  | 80 |  | 100.78 |  |  |  | new tenant
26 |  | 100 |  | 90.15
27 |  | 100 |  | 171.12
28 |  | 100 |  | 80.77
29 |  | 100 |  | 125.23
30 |  | 80 |  | 121.35
31 |  | 80 |  | 145.05
32 |  | 80 |  | 118.42 |  |  |  | Moved to #13. No charge.
33 |  | 80 |  | 175.5
34 |  | 100 |  | 144.74
35 |  | 100 |  | 205.08
36 |  | 100 |  | 96.41
37 |  | 100 |  | 159.81
38 |  | 100 |  | 381.42 |  |  |  | new tenant
39 |  | 80 |  | 97.09 |  |  |  | new tenant
40 |  | 100 |  | 127.55 |  |  |  | new tenant
41 |  | 100 |  | 43.76 | 114.45
42 |  | 100 |  | 40.25 | 123.12
43 |  | 100 |  | 36.38 | 122.34
44** |  | 150 |  | 43.44 | 150.01 |  |  | don't worry about water bill
HSMTR |  |  |  | 29.82 | 44.32
Water 7th |  |  |  | 192.5
Water |  |  |  | 185.79
Water 30-39 |  |  |  | 213.5
Water 41-43 |  |  |  | 71.75
Water 44 |  |  |  | 86.04
**cap on total of electric and gas
* Electric & Water 12/8-1/9, Gas 12/14-1/18
Spreadsheet: errol_mclaughlin_jr__10009__Candeals
Sheet: Sheet1

M A N U A L   I N P U T S |  |  |  |  |  |  |  |  | I N T E R M E D I A T E   C A L C U L A T I O N S |  |  |  |  |  |  |  |  | E X O T I C A   O U T P U T S |  |  | C A L C U L A T I O N S
Counterparty | Internal / External | Deal Num | Pub Code | Phy / Fin | Call / Put | Period | Monthly Option Qty | Strike Price | Nymex Price | Basis Price | Index Price | Interest Rate | Nymex Vol | Index Vol | Skew Adj Index Vol | Correlation | [NAME] | Unit Premium | Unit Delta | Unit Basis Delta Offset | MTM Value | Delta | Nymex [NAME]
ECC | I | V56856.1 | IF-NTHWST/CANBR | F | P | 2002-01-01 00:00:00 | -1550000 | 0.5 | 2.634 | 0.45 | 3.084 | 0.0223009258468765 | 0.97 | 0.989 | 0.989 | 0.88 | 2001-12-28 00:00:00 | 0.1795566883304425 | -0.5260439655387299 | 0.573052059375265 | -278312.8669121859 | 815368.1465850313 | -72862.54544662948
ECC | I | V56856.1 | IF-NTHWST/CANBR | F | P | 2002-02-01 00:00:00 | -1400000 | 0.5 | 2.746 | 0.2 | 2.946 | 0.0217808492956433 | 0.945 | 0.964 | 0.964 | 0.88 | 2002-01-30 00:00:00 | 0.4060742968231216 | -0.6658337410634878 | 0.7273257482869648 | -568504.0155523702 | 932167.237488883 | -86088.81011286784
ECC | I | V56856.1 | IF-NTHWST/CANBR | F | P | 2002-03-01 00:00:00 | -1550000 | 0.5 | 2.763 | -0.05 | 2.713 | 0.0211456580710117 | 0.825 | 0.842 | 0.842 | 0.88 | 2002-02-27 00:00:00 | 0.6006875404241356 | -0.7971467626052292 | 0.8454070150124124 | -931065.6876574103 | 1235577.482038105 | -74803.39123113401
Spreadsheet: 2f73fd6a-9996-45f1-8b54-3cfc9e55a17b
Sheet: Sheet1

Council Member - NON (North Dakota) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Downloaded at 6/19/2013 1:29:52 AM
Precincts Reporting: 505/505 - Total Ballots Cast: 102066
2010 Primary Election - OFFICIAL RESULTS
Precinct | [NAME] | [NAME] | Andrea (Geffre) Amundson | [NAME]  Sitzler | write-in | TOTALS
Precinct 03 | 236 | 281 | 132 | 242 | 3 | 894
TOTAL | 236 | 281 | 132 | 242 | 3 | 894
Results provided by the Office of North Dakota Secretary of State