tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 2ca8e943-9027-47c1-bb34-616411faf767
Sheet: Sheet1

Software | Vendor | Street | City | St | Zip | Phone | e-mail | Contact | Oct 31
Account | SchoolNet Inc. |  |  |  |  | (212) 645-0615 | [EMAIL]; | [NAME]
Administrator's Plus | Rediker Software | 2 Wilbraham Road | Hampden | MA | 01036 | 8002139860 | [EMAIL]; [EMAIL]; [EMAIL]; [EMAIL]; | [NAME] [NAME][NAME] [NAME]
CIC | Computer Information Concepts Inc. | 2843 31st Avenue | [NAME] | CO | 80631 | 8004377457 | [EMAIL]; [EMAIL]; [EMAIL]; | [NAME][NAME]
eSchoolPlus | Sungard Pentamation Inc. | 3 West Broad Street | Bethlehem | PA | 18018 | 6106913616 | [EMAIL]; | [NAME] Feather
eSIS | Administrative Assistants Limited Solutions (AAL Solutions) | 101 Red Cedar #2 P O Box 7320 | [NAME] | NV | 89452 | (289) 313-1012 Direct                          (800) 668-8486 x1012 | [EMAIL]; | [NAME]
FastDirect | FastDirect Communications | 150 Prospect Avenue | Kirkwood | MO | 63122 | 3148223278 | [EMAIL]; | [NAME]
Synergy Student Information System | Edupoint |  |  |  |  | (800) 914-9815 | [EMAIL];                          [EMAIL];             tswietek@edupoint;   [EMAIL]; | [NAME]            [NAME]
Infinite Campus Inc. | Infinite Campus |  |  |  |  | (651) 631-0000 (763) 795-4174 | [EMAIL]; [EMAIL]; | [NAME]Justin Elston
Web Student (Skyward) | Skyward | 5233 [NAME] | [NAME] | WI | 54481-0166 | 8002367274 | [EMAIL]; [EMAIL]; [EMAIL]; | [NAME]           Brandon Grabski              Kris Lepak
PowerSchool | Pearson School Systems | 80 Iron Point Circle, #200 | Folsom | CA | 95630 | (480) 457-7435 | [EMAIL]; | Dawn Colon
Go.edustar | Harris School Solutions |  |  |  |  | (316) 494-6300 (800) 456-4685 | [EMAIL]; [EMAIL]; [EMAIL]; [EMAIL]; | [NAME][NAME]                  Kayla Nickel                      Mary Andyshak
Schoolmaster | Tyler Technologies Inc. - Schoolmaster Division | 7249 Capitol Blvd South | [NAME] | WA | 98501-5519 | (800) 733-0922   x-151109 For [NAME] or [NAME] For [NAME] | [EMAIL]; [EMAIL]; | [NAME]
Schools Online | CrossPointe | 3016 Dade Avenue | Orlando | FL | 32804 | 4078973623 | [EMAIL]; | [NAME]
Silk SIS | Excelsior Software (Formerly [NAME]) | 3609 S Wadsworth Blvd, #310 | Lakewood | CO | 80235 | (800) 727-2728 | [EMAIL]; [EMAIL]; | [NAME]       [NAME]
STI-K12 | Software Technology Inc. | 4721 Morrison Drive #200 | Mobile | AL | 36609 | 8008440884 | [EMAIL];                     [EMAIL]; [EMAIL]; [EMAIL]; | [NAME]
Spreadsheet: 793182d1661350528-creating-a-results-list-of-multiple-races-finn-resultaten-2022
Sheet: 3 juli

 |  | place | 1e wedstrijd | 2e wedstrijd | 3e wedstrijd | 4e wedstrijd |  |  |  | Place | sailnumber | points | points overall | count
 |  | 1 | 147 | 222 | 147 | 147 |  |  |  | 1 |  | 5 | 17
 |  | 2 | 200 | 147 | 14 | 13 |  |  |  | 2 | 14 | 17 | 16
 |  | 3 | 108 | 14 | 13 | 14 |  |  |  | 3 | 13 | 18 | 15
 |  | 4 | 63 | 250 | 113 | 113 |  |  |  | 4 | 222 | 19 | 14
 |  | 5 | 222 | 13 | 108 | 222 |  |  |  | 5 | 113 | 23 | 13
 |  | 6 | 113 | 20 | 1015 | 108 |  |  |  | 6 | 108 | 25 | 12
 |  | 7 | 1015 | 1015 | 63 | 199 |  |  |  | 7 | 63 | 30 | 11
 |  | 8 | 13 | 199 | 222 | 960 |  |  |  | 8 | 199 | 36 | 10
 |  | 9 | 14 | 113 | 199 | 63 |  |  |  | 9 | 1015 | 37 | 9
 |  | 10 | 20 | 63 | 960 | 131 |  |  |  | 10 | 960 | 41 | 8
 |  | 11 | 960 | 108 | 20 | 145 |  |  |  | 11 | 20 | 44 | 7
 |  | 12 | 199 | 960 | 57 | 57 |  |  |  | 12 | 131 | 51 | 6
 |  | 13 | 131 | 145 | 131 | 150 |  |  |  | 13 | 145 | 52 | 5
 |  | 14 | 145 | 57 | 145 |  |  |  |  | 14 | 57 | 53 | 4
 |  | 15 | 57 | 131 | 150 |  |  |  |  | 15 | 200 | 53 | 3
 |  | 16 | 150 | 150 |  |  |  |  |  | 16 | 250 | 55 | 2
 |  | 17 | 250 | 200 | 200 | 200 |  |  |  | 17 | 150 | 60 | 1
 |  | 17 |  |  | 250 | 1015 |  |  |  |  | 0 | 197
 |  | 17 |  |  |  | 250
 |  | 17 |  |  |  | 20
Spreadsheet: 780402d1652437772-if-formula-using-index-match-with-help-from-helper-sample
Sheet: Sheet1

Old Report
PARTICIPANT_NAME | NUMBER | BOOKING_ID | SERVICE_BOOKING_TYPE | SUPPORT_CATEGORY | SUPPORT_Number | START_DATE | END_DATE | STATUS
Participant 1 | 294566094 | 6565625 | Standard | IT Support | 06_05_001_1_5 | 2021-06-30 00:00:00 | 2022-06-30 00:00:00 | Active
Participant 2 | 676442211 | 6795483 | Standard | IT Support | 06_05_001_1_5 | 2021-05-30 00:00:00 | 2022-04-30 00:00:00 | Inactive
Participant 3 | 741035032 | 3497568 | Standard | IT Support | 06_05_001_1_5 | 2022-03-20 00:00:00 | 2023-03-20 00:00:00 | Active
Participant 4 | 130289078 | 9346824 | Standard | IT Support | 06_05_001_1_5 | 2021-10-11 00:00:00 | 2022-04-17 00:00:00 | Active
Participant 5 | 845963037 | 5973164 | Standard | IT Support | 06_05_001_1_5 | 2022-04-12 00:00:00 | 2022-04-30 00:00:00 | Active
Participant 6 | 246487752 | 5731648 | Standard | IT Support | 06_05_001_1_5 | 2021-04-11 00:00:00 | 2022-06-30 00:00:00 | Active
New Report
PARTICIPANT_NAME | NUMBER | BOOKING_ID | SERVICE_BOOKING_TYPE | SUPPORT_CATEGORY | SUPPORT_Number | START_DATE | END_DATE | STATUS | TRUE / FALSE | Current Formula | Cell Meant To Say
Participant 1 | 294566094 | 6565625 | Standard | IT Support | 06_05_001_1_5 | 2021-06-30 00:00:00 | 2022-06-30 00:00:00 | Active |  |  | No Change in Plan
Participant 2 | 676442211 | 6795483 | Standard | IT Support | 06_05_001_1_6 | 2021-05-30 00:00:00 | 2022-04-30 00:00:00 | Inactive |  |  | New but Not Active
Participant 3 | 741035032 | 3497568 | Standard | IT Support | 06_05_001_1_7 | 2022-03-20 00:00:00 | 2023-03-20 00:00:00 | Active |  |  | No Change in Plan
Participant 4 | 130289078 | 9346824 | Standard | IT Support | 06_05_001_1_8 | 2021-10-11 00:00:00 | 2023-04-17 00:00:00 | Active |  |  | Extended
Participant 5 | 845963037 | 5973164 | Standard | IT Support | 06_05_001_1_9 | 2022-05-01 00:00:00 | 2023-05-01 00:00:00 | Active |  |  | New
Participant 6 | 246487752 | 5731648 | Standard | IT Support | 06_05_001_1_10 | 2021-04-11 00:00:00 | 2022-06-30 00:00:00 | Active |  |  | No Change in Plan
Spreadsheet: 688958d1596036804-restructure-text-format-sample
Sheet: Sheet1

 |  |  | Expected result
NO1 |  |  | 01
NO5 |  |  | 05
NO12 |  |  | 12
A9 |  |  | I09
A10 |  |  | I10
H9 |  |  | H09
H12 |  |  | H12
 |  | Remove NO
 |  | Number at least have 2 digit. For example if the number is 1 then will become 01 and A9 wil become A09
Spreadsheet: 155458d1336850641-need-formula-to-check-subtotals-in-long-column-company-subtotal-example
Sheet: 2010 G3 L1_5 (2)

REC_NUM | WKSHT_CD | LINE_NUM | CLMN_NUM | VAL | ORG_NUM | FY_END_DT
266168 | G300000 | 00100 | 0100 | 76431770 | 660690 | 2010-07-09 00:00:00
266168 | G300000 | 00200 | 0100 | 33369070 | 660690 | 2010-07-09 00:00:00
266168 | G300000 | 00300 | 0100 | 43062700 | 660690 | 2010-07-09 00:00:00
266168 | G300000 | 00400 | 0100 | 64639316 | 660690 | 2010-07-09 00:00:00
266168 | G300000 | 00500 | 0100 | -21576616 | 660690 | 2010-07-09 00:00:00
266615 | G300000 | 00100 | 0100 | 525279526 | 341222 | 2010-12-31 00:00:00
266615 | G300000 | 00200 | 0100 | 341914956 | 341222 | 2010-12-31 00:00:00
266615 | G300000 | 00300 | 0100 | 183364570 | 341222 | 2010-12-31 00:00:00
266615 | G300000 | 00400 | 0100 | 177094116 | 341222 | 2010-12-31 00:00:00
266615 | G300000 | 00500 | 0100 | 6270454 | 341222 | 2010-12-31 00:00:00
266616 | G300000 | 00100 | 0100 | 465909413 | 390122 | 2010-12-31 00:00:00
266616 | G300000 | 00200 | 0100 | 320758896 | 390122 | 2010-12-31 00:00:00
266616 | G300000 | 00300 | 0100 | 145150517 | 390122 | 2010-12-31 00:00:00
266616 | G300000 | 00400 | 0100 | 143354682 | 390122 | 2010-12-31 00:00:00
266616 | G300000 | 00500 | 0100 | 1795835 | 390122 | 2010-12-31 00:00:00
266618 | G300000 | 00100 | 0100 | 78080371 | 316001 | 2010-12-31 00:00:00
266618 | G300000 | 00200 | 0100 | 36771913 | 316001 | 2010-12-31 00:00:00
266618 | G300000 | 00300 | 0100 | 41308458 | 316001 | 2010-12-31 00:00:00
266618 | G300000 | 00400 | 0100 | 37408752 | 316001 | 2010-12-31 00:00:00
266618 | G300000 | 00500 | 0100 | 3899706 | 316001 | 2010-12-31 00:00:00
266656 | G300000 | 00100 | 0100 | 583411202 | 431789 | 2010-12-31 00:00:00
266656 | G300000 | 00200 | 0100 | 373349593 | 431789 | 2010-12-31 00:00:00
266656 | G300000 | 00300 | 0100 | 210061609 | 431789 | 2010-12-31 00:00:00
266656 | G300000 | 00400 | 0100 | 217896155 | 431789 | 2010-12-31 00:00:00
266656 | G300000 | 00500 | 0100 | -7834546 | 431789 | 2010-12-31 00:00:00
266657 | G300000 | 00100 | 0100 | 75632042 | 121453 | 2010-12-31 00:00:00
266657 | G300000 | 00200 | 0100 | 36445918 | 121453 | 2010-12-31 00:00:00
266657 | G300000 | 00300 | 0100 | 39186124 | 121453 | 2010-12-31 00:00:00
266657 | G300000 | 00400 | 0100 | 42039180 | 121453 | 2010-12-31 00:00:00
266657 | G300000 | 00500 | 0100 | -2853056 | 121453 | 2010-12-31 00:00:00
266767 | G300000 | 00100 | 0100 | 68761014 | 732145 | 2010-12-31 00:00:00
266767 | G300000 | 00200 | 0100 | 27574336 | 732145 | 2010-12-31 00:00:00
266767 | G300000 | 00300 | 0100 | 41186678 | 732145 | 2010-12-31 00:00:00
266767 | G300000 | 00400 | 0100 | 44252174 | 732145 | 2010-12-31 00:00:00
266767 | G300000 | 00500 | 0100 | -3065496 | 732145 | 2010-12-31 00:00:00
Spreadsheet: daren_farmer__6363__CES INFO
Sheet: DEFS

Purchase
 | From Republic Royalty
 | At Felmont #1 (Mtr 58798 - Felmont #1)
 | For 91% of HSC FOM
Sale
 | To Duke Energy Field Services
 | For 92% of HSC FOM
Term
 | Evergreen
Other
 | [NAME] handles nominations
 | We make 1% of HSC IFERC
 | We then turn around and pay Jackie $[NAME] agent fee
 | No noms on our part
 | 140 MMBtu/day
 | We will be terminating this evergreen deal
 | Reciept and Delivery of Gas from Felmont #1 attributable to
 | Republic Royalty's interest at wellhead.Duke Energy
 | purchases the gas at the wellhead and delivers it to its
 | own market.  CES is kept whole on [NAME] delivered at
 | wellhead.
Deal Numbers
 | P - 143558
 | S - 143559
Spreadsheet: 733507d1621603426-formula-to-insert-multiple-dates-eh_bau-project-planner_v2
Sheet: Project planner snapshot

ID | Tasks | Co-ordinator | Deadline | Days remaining | Priority |  | Status |  |  | ID |  |  |  |  | Task owners
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Other (specify in notes)
 | Ongoing Actions | Co-ordinator | LATEST UPDATE |  |  |  | Status |  |  |  |  |  |  |  | Task meter (ongoing tasks excluded)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | On hold
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Not started
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In progress
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total outstanding Tasks
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Completed
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Priority tracker
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | High Priority
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Medium Priority
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Low Priority
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | On hold
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Not Started
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In progress
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Completed
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Tasks
Spreadsheet: 105500d1302818547-hlookup-example-2-
Sheet: Sheet2

Name Here
 | 2011-04-14 00:00:00
Course - 6C62890
 | 2011-04-14 00:00:00
Course - TR009046
 | 2011-04-14 00:00:00
Course - 75402RC
 | 2011-04-19 00:00:00
Course - 6C62890
Spreadsheet: 856181d1705522375-excel-formula-for-a-range-that-will-produce-words-jf_words
Sheet: Sheet1

=IF(C4<-9,â€Cracked Pepperâ€,IF(C4<-6,â€Chocolatâ€,IF(C4<-3,"Black Current",IF(C4<-1,"Acai",IF(C4<1,"Aubergine",IF(C4<3,"Jalapeno",IF(C4<5,"Overcast",IF(C4<8,"Okra",IF(C4<10,"Grapes",IF(C4<15,"Rye",IF(C4<20,"Petals",IF(C4<25,"Grapefruit",IF(C4<28,"Sunny",IF(C4<30,"Tang",IF(C4<40,"Sour [NAME]"))))
 |  |  | -2
-9 | Cracked Pepper
-6 | Chocolate
-3 | Blackcurrant
-1 | Acal
1 | [NAME]
3 | Jalapeno
5 | Overcast
8 | Okra
10 | Grapes
15 | Rye
20 | Petails
25 | Grapefruit
28 | Sunny
30 | [NAME]
40 | Sour [NAME]
Spreadsheet: 38371d1236537715-how-many-items-per-month-and-average-accounts
Sheet: Sheet2

1 | Apples
2 | Beans
3 | Beetroot
4 | [NAME]
5 | Carrots
6 | [NAME]
7 | Coffee
8 | Corn
9 | Electricity
10 | [NAME]
11 | [NAME]
12 | House Rent
13 | [NAME]
14 | Milk
15 | Onions Lrg
16 | Onions Sm
17 | Potatoes
18 | Red Cabbage
19 | Dhal
20 | Salt
21 | Sugar
22 | Tea
23 | Water
24 | Donation
25 | Parotte
26 | Chicken
27 | Biscuits
28 | Photo
29 | Coconut
30 | Fish
31 | Lemon
32 | Cake
33 | Coriander
34 | Hospital Fees
35 | [NAME]
36 | Tomato
37 | Curd
38 | Egg
39 | [NAME]
40 | Snack Items
41 | Mango
42 | Cumin
43 | [NAME]
44 | Mixer
45 | [NAME]
46 | Gooseberry
47 | Orange
48 | Grapes
49 | [NAME]
50 | Papaya
51 | Ginger
52 | Hair Cutting
53 | Capsicum
54 | Car Rent
55 | Newspaper
56 | Peas
57 | Nuts
58 | [NAME]
59 | Coconut Oil
60 | Soap - Clothes
61 | Soap - Body
62 | Lotion
63 | [NAME]
64 | [NAME]
65 | Wheat
66 | Vinegar
67 | Ghee
68 | Cashew Nuts
69 | Cardoman
70 | Black Gram
71 | [NAME]
72 | Biriyani Items
73 | Telephone
74 | Tuition Fee
75 | Mobile Charge
76 | Vegetables
77 | Breakfast
78 | [NAME]
79 | [NAME]
80 | School Fees
81 | Travel Expenses
82 | Santharaj
83 | Bed Sheets
84 | Pillow Cover
85 | Pillow
86 | [NAME]
87 | Stitching
88 | Material for Uniform
89 | Exercise Books
90 | [NAME]
91
92
93
94
95
96
97
98
99
100 | Illegible
Spreadsheet: 83910d1283949380-selecting-two-colums-of-info-on-one-sheet-from-another-sheet1
Sheet: results

Date | Reason
2010-09-01 00:00:00 | A
2010-09-01 00:00:00 | A
2010-09-01 00:00:00 | A
2010-09-01 00:00:00 | A
2010-09-01 00:00:00 | A
2010-09-01 00:00:00 | A
2010-09-01 00:00:00 | A
2010-09-01 00:00:00 | A
2010-09-01 00:00:00 | A
2010-09-01 00:00:00 | A
2010-09-01 00:00:00 | A
2010-09-01 00:00:00 | A
2010-09-01 00:00:00 | A
2010-09-01 00:00:00 | A
2010-09-01 00:00:00 | A
2010-09-01 00:00:00 | A
2010-09-01 00:00:00 | B
2010-09-01 00:00:00 | B
2010-09-01 00:00:00 | B
2010-09-01 00:00:00 | B
2010-09-02 00:00:00 | C
2010-09-02 00:00:00 | C
2010-09-02 00:00:00 | C
2010-09-02 00:00:00 | C
2010-09-02 00:00:00 | C
2010-09-02 00:00:00 | C
2010-09-02 00:00:00 | C
2010-09-02 00:00:00 | C
2010-09-02 00:00:00 | C
2010-09-02 00:00:00 | C
2010-09-02 00:00:00 | A
2010-09-02 00:00:00 | A
2010-09-02 00:00:00 | A
2010-09-02 00:00:00 | B
2010-09-02 00:00:00 | B
2010-09-02 00:00:00 | B
2010-09-03 00:00:00 | A
2010-09-03 00:00:00 | A
2010-09-03 00:00:00 | B
2010-09-03 00:00:00 | A
2010-09-03 00:00:00 | A
2010-09-03 00:00:00 | A
2010-09-04 00:00:00 | D
2010-09-07 00:00:00 | C
2010-09-07 00:00:00 | C
2010-09-07 00:00:00 | C
Spreadsheet: 856321d1705596035-trying-to-add-a-custom-filter-set-to-a-sheet-test
Sheet: Sheet1

 |  | 20 AVE | MEAN/MED AVE | 20 WR | 15 AVE | 10 AVE
 | 2011-02-11 00:00:00 | 0.007847162706645903 | 0.004856385378900189 | 0.65 | 0.01001168815091302 | 0.002945579177806571
 | 2012-02-10 00:00:00 | 0.004612695006587677 | 0.005003096346232707 | 0.65 | 0.006121198031135881 | 0.0001428902191500639
 | 2015-03-06 00:00:00 | 0.000389287945237127 | 0.0006363984320768622 | 0.55 | 0.0004368943959200155 | 0.005936018955869848
 | 2015-03-06 00:00:00 | 0.000389287945237127 | 0.0006363984320768622 | 0.55 | 0.0004368943959200155 | 0.005936018955869848
 | 2010-02-12 00:00:00 | 0.003565711728978009 | 0.003002121348460371 | 0.65 | 0.00446161195842794 | -0.0006080370026923853
 | 2010-02-12 00:00:00 | 0.003721254803804335 | 0.003262368821361517 | 0.65 | 0.00459233359673769 | 0.0007626772342328148
 | 2008-02-14 00:00:00 | 0.003002247552802494 | 0.00259745674059337 | 0.65 | 0.003884510649695176 | 0.003426012988559098
 | 2011-02-11 00:00:00 | 0.007683607380535383 | 0.004703718511213742 | 0.6 | 0.009869441111059717 | 0.001557358040689063
 | 2008-02-14 00:00:00 | 0.002851416327474081 | 0.00331742941664158 | 0.6 | 0.003760178636088871 | 0.002068798797052612
 | 2012-02-10 00:00:00 | 0.006099127265464198 | 0.003526949980250064 | 0.6 | 0.008025203527014892 | 0.004002518190221911
 | 2012-02-10 00:00:00 | 0.0008778186689994072 | 0.0009327719076664821 | 0.7 | 0.0008538576344415214 | -0.001128991002512991
 | 2015-03-06 00:00:00 | 0.0004960840003790949 | 0.0006471172460068184 | 0.55 | 0.0002128274555032254 | 0.007398441935256531
 | 2020-02-19 00:00:00 | -0.001982548507098748 | -0.001733900139550555 | 0.45 | -0.001849876071058266 | 0.002286316845422351
 | 2011-02-11 00:00:00 | 0.007367332756697776 | 0.004780837635549573 | 0.6 | 0.009260914344096228 | 0.002270445297403528
Spreadsheet: 725144d1616563962-how-can-i-limit-the-max-int-value-of-2nd-drop-down-box-based-on-int-value-of-first-drop_down_solved
Sheet: Sheet1

1 |  | First Drop-Down |  | Second Drop-Down
2 |  | 90 |  | 10
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
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Spreadsheet: louise_kitchen__24136__North America Plan 01-08 adj
Sheet: EOL Support

 | EOL Support
 | 2002 Plan
 |  | 2001-09-01 00:00:00 |  | 2001 |  | 2002 |  |  |  |  | Per HC | New HC | Adj Comp | 2002
 |  | YTD Actual |  | Forecast |  | Forecast |  |  |  |  |  |  |  | Plan
ENACOMP | Compensation
 | Special Pays | 0 |  |  |  |  |  |  |  | Compensation | 0
 | Analyst & Associate | 0 |  |  |  | 0
ENABENTX | Benefits & Payroll Taxes
ENAEMPEX | Employee Expense |  |  |  |  |  |  |  |  | Other
ENAT&EEX | Travel & Entertainment Expense
ENAOUTSV | Outside Services | 0 |  |  |  | 30600 |  |  |  | Total
ENASUPP | Supplies Expense
ENAMKTEX | Marketing |  |  |  |  | 408000
ENACONTR | Charitable Contributions |  |  |  |  | 0 |  |  |  | [NAME] | 36000 | 0
ENARENT | Rent |  |  |  |  |  |  |  |  | Admins | 48000 | 2
ENATECH | Technology |  |  |  |  |  |  |  |  | Staff | 49200 | 7
ENATRANS | Transportation |  |  |  |  | 0 |  |  |  | Analysts | 57600 | 3
ENAOTHEX | Other Expenses |  |  |  |  |  |  |  |  | Specialist | 62400 | 8
ENATAXES | Taxes Other than Income |  |  |  |  | 0 |  |  |  | Sr Specialist | 74400 | 7
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  |  |  | Managers | 96000 | 8
 |  |  |  |  |  |  |  |  |  | Directors | 120000 | 3
 | Headcount |  |  | 114 |  |  |  |  |  | Sr Director | 156000 | 0
 |  |  |  |  |  |  |  |  |  | Vice President | 204000 | 1
 | A&A Headcount |  |  | 4 |  |  |  |  |  | [NAME] | 240000 | 0
 | Total Headcount |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  | Benefits & Taxes |  |  | 0.2
ENAOUTLG | Outside Legal
ENAOUTTX | Outside Tax
ENAINSUR | Insurance
ENASYSDV | System Development
ENACORIT | Controllable Infrastructure
ENACORRN | Corporate Rent
ENAOTHAL | Other Allocated Direct  Expenses |  |  |  |  |  |  |  | Other Expense Calculation
ENADEPR | Depreciation & Amortization
 |  |  |  |  |  |  |  |  | Based on information from ENW accounting.
Spreadsheet: 99581d1298199117-forecast-offset-formula-needed-forecast2
Sheet: Forecast

By Hand Formulation |  |  |  |  | Forecast Formulation
# | TIME | PRICE |  |  | # | Time | Close | Forecast
1 | 20:00:00 | 1.3683 |  |  | 1 | 20:00:00 | 1.3683
2 |  | 1.3665 |  |  | 2 | 00:00:00 | 1.3645
3 |  | 1.3659 |  |  | 3 | 04:00:00 | 1.3646
4 |  | 1.3644 |  |  | 4 | 08:00:00 | 1.3628
5 | 00:00:00 | 1.3645 |  |  | 5 | 12:00:00 | 1.3614
6 |  | 1.3664 |  |  | 6 | 16:00:00 | 1.363
7 |  | 1.3658 |  |  | 7 | 20:00:00 | 1.362
8 |  | 1.3672
9 | 04:00:00 | 1.3646
10 |  | 1.3613
11 |  | 1.3632
12 |  | 1.3626
13 | 08:00:00 | 1.3628
14 |  | 1.3628
15 |  | 1.3631
16 |  | 1.3625 | Forecast
17 | 12:00:00 | 1.3614 | 1.36122 | This is the Forecast for the past five instances for the four hour periods. (20:00/0:00/4:00/8:00/12:00)
18 | 13:00:00 | 1.3623 | 1.3616 | This is the Forecast for the past four instances for last four hour periods and one from the next period. (0:00/4:00/8:00/12:00/13:00)
19 | 14:00:00 | 1.3614 | 1.36106 | This is the Forecast for the past four instances for last four hour periods and one from the next period. (0:00/4:00/8:00/12:00/14:00)
20 | 15:00:00 | 1.3609 | 1.36076 | This is the Forecast for the past four instances for last four hour periods and one from the next period. (0:00/4:00/8:00/12:00/15:00)
21 | 16:00:00 | 1.363 | 1.36202 | This is the Forecast for the past five instances for the four hour periods. (0:00/4:00/8:00/12:00/16:00)
22 | 17:00:00 | 1.3619 | 1.3617 | This is the Forecast for the past four instances for last four hour periods and one from the next period. (4:00/8:00/12:00/16:00/17:00)
23 | 18:00:00 | 1.3615 | 1.36146 | This is the Forecast for the past four instances for last four hour periods and one from the next period. 4:00/8:00/12:00/16:00/18:00)
24 | 19:00:00 | 1.3603 | 1.36074 | This is the Forecast for the past four instances for last four hour periods and one from the next period. (4:00/8:00/12:00/16:00/19:00)
25 | 20:00:00 | 1.362 | 1.36176 | This is the Forecast for the past five instances for last four hour periods. (4:00/8:00/12:00/16:00/20:00)
Spreadsheet: james_steffes__12850__CA rate exposure final 8-28 rev
Sheet: New

NEW CUSTOMERS (DA for first time as of 10/1/01)
PG&E | Utility Undercollection |  |  |  |  | Bonds |  |  |  |  | Above Market Contract Cost |  |  |  |  | Weighted Avg. Total
 | Scenario | A | B | C |  | Scenario | A | B | C |  | Scenario | A | B | C
 | % Collected |  |  |  | Weighted | % Collected |  |  |  | Weighted | % Collected |  |  |  | Weighted
 | Probability |  |  |  | Average | Probability |  |  |  | Average | Probability |  |  |  | Average
 | Factor | 1 | 1 | 0 |  |  | 1 | 1 | 0 |  |  | 1 | 1 | 0
Amortization (years)
5
7
10
12
15
Edison | Utility Undercollection |  |  |  |  | Bonds |  |  |  |  | Above Market Contract Cost
 | Scenario | A | B | C |  | Scenario | A | B | C |  | Scenario | A | B | C
 | % Collected |  |  |  | Weighted | % Collected |  |  |  | Weighted | % Collected |  |  |  | Weighted
 | Probability |  |  |  | Avg | Probability |  |  |  | Avg | Probability |  |  |  | Avg
 | Factor | 1 | 1 | 0 |  | Factor | 1 | 1 | 0 |  | Factor | 1 | 1 | 0
Amortization (years)
5
7
10
12
15
SDG&E | Utility Undercollection |  |  |  |  | Bonds |  |  |  |  | Above Market Contract Cost
 | Scenario | A | B | C |  | Scenario | A | B | C |  | Scenario | A | B | C
 | % Collected |  |  |  | Weighted | % Collected |  |  |  | Weighted | % Collected |  |  |  | Weighted
 | Probability |  |  |  | Avg | Probability |  |  |  | Avg | Probability |  |  |  | Avg
 | Factor | 1 | 1 | 0 |  | Factor | 1 | 1 | 0 |  | Factor | 1 | 1 | 0
Amortization (years)
5
7
10
12
15
Spreadsheet: 126426d1319689199-referencing-a-non-integer-or-generating-a-consecutive-integer-example
Sheet: Sheet2

1 |  | Column A is the goal of the formula generation.
2 | [NAME] should begin here.
3
4
5
6
7
7.8
9 |  | Decision Path:
10 |  | Previous Cell | Action | Cell References | Action
11 |  | 1) non-integer | round up | 1) a non-integer present is within a value of 1 to Previous Cell | reference that non-integer
12 |  | 2) integer | Check Cell References | 2) [NAME] or not within 1 value close to Previous Cell | add 1
12.35
13
14
15
16
17
18
19
20
21
22
23
24
Spreadsheet: 104080d1301701439-automatic-date-distribution-and-cost-loading-formulas-for-construction-schedules-construction-schedule
Sheet: Sheet1

Activity | Start | End | Amount
A | 2010-01-01 00:00:00 | 2010-07-01 00:00:00 | 140
B | 2010-02-01 00:00:00 | 2010-08-01 00:00:00 | 280
C | 2010-06-01 00:00:00 | 2010-11-01 00:00:00 | 300
Spreadsheet: 42011d1240550117-figured-out-my-boston-problem-boston
Sheet: Overview

East | W | L | PCT | vs E | vs C | vs W | INT | HOME | ROAD | Total
Boston
 |  |  |  |  | Home | Road | Total | PCT
 |  |  | Boston vs. | Philadelphia Phillies
Spreadsheet: 238248d1369427115-prevent-resetting-of-condititional-formatting-rules-resetting-cf
Sheet: Sheet1

xs | df | dfs
2013-05-24 00:00:00 | a
2013-05-23 00:00:00
2013-05-22 00:00:00 | a
2013-05-21 00:00:00 | b | a
2013-05-20 00:00:00 | c | c
2013-05-19 00:00:00 |  | b
2013-05-18 00:00:00 |  | a
2013-05-17 00:00:00
2013-05-16 00:00:00 | a
2013-05-15 00:00:00
2013-05-14 00:00:00
2013-05-13 00:00:00 |  | a
2013-05-12 00:00:00
2013-05-11 00:00:00
2013-05-10 00:00:00 | a | a
2013-05-09 00:00:00
2013-05-08 00:00:00
2013-05-07 00:00:00 | b
2013-05-06 00:00:00
2013-05-05 00:00:00 | b
2013-05-04 00:00:00 |  | bb
2013-05-03 00:00:00 |  | b
2013-05-02 00:00:00
2013-05-01 00:00:00 | a
 | a | a