tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 475627d1471380704-how-to-add-value-from-new-inserted-row-and-also-add-the-new-row-count-to-an-average-goonbah
Sheet: VF Org & Mgmt. Model

Task Name | Members | Plan Start Date | Plan End Date | Actual Start Date | Actual End Date | % Complete | Planned Days | Actual Days | [NAME] | Dependencies | Comments
Summary | msf
Define Organization Model & Scope of Responsibilities | msf
VF Board of Managers (BOM) | msf | 2016-08-09 00:00:00 | 2016-08-10 00:00:00 | 2016-08-10 00:00:00 | 2016-08-13 00:00:00
VF Board of Advisors  (BOA)+ BOM (Governing) | msf | 2016-08-17 00:00:00 | 2016-08-18 00:00:00 | 2016-08-17 00:00:00 | 2016-08-19 00:00:00 | 1 |  |  |  | 3
Operational Roles & Names (Core Management Team) SS | msf | 2016-08-18 00:00:00 | 2016-08-19 00:00:00 | 2016-08-18 00:00:00 | 2016-08-19 00:00:00 | 1 |  |  |  | 4
Integration Roles & Names (Core Team)  ([NAME], [NAME], [NAME], IT, [NAME]) | msf | 2016-08-19 00:00:00 | 2016-08-20 00:00:00 | 2016-08-18 00:00:00 | 2016-08-19 00:00:00 | 1
Determine Management/Employee Communications and Meeting Schedules | msf
BOA Quarterly | msf | 2016-08-16 00:00:00 | 2016-08-17 00:00:00 | 2016-08-16 00:00:00 | 2016-08-17 00:00:00 | 1
BOM Weekly Call | msf | 2016-08-16 00:00:00 | 2016-08-17 00:00:00 | 2016-08-16 00:00:00 | 2016-08-17 00:00:00 | 1
Core Management Weekly | msf | 2016-08-16 00:00:00 | 2016-08-17 00:00:00 | 2016-08-16 00:00:00 | 2016-08-17 00:00:00 | 1
Develop strawman [NAME] for Practice Acquisitions & Integration | msf
Review & approve Integration Plan and process | msf | 2016-08-16 00:00:00 | 2016-08-17 00:00:00 | 2016-08-16 00:00:00 | 2016-08-19 00:00:00 | 1
Approve Communications/Announcements and roles | msf | 2016-08-17 00:00:00 | 2016-08-18 00:00:00 | 2016-08-17 00:00:00 | 2016-08-19 00:00:00 | 1 |  |  |  | 12
Determine additional staffing | msf | 2016-08-22 00:00:00 | 2016-08-25 00:00:00 | 2016-08-22 00:00:00 | 2016-09-02 00:00:00 | 1 |  |  |  | 12
Spreadsheet: 03bf4322-db5f-49bf-bd0b-40a2a55a31e6
Sheet: Sheet1

Trade plan check and permits | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
ELECTRICAL PERMITS
Residential (SFD) |  |  |  |  | Permit Fee - 2010 | Count
 | Appliance( fixed), up to 5 hp |  |  |  | 17
 | Main Services and sub panels - up to 400 amps |  | 68 |  | 34
 | [NAME], [NAME], Thermostat, smoke detectors, and Lighting outlet |  |  |  | 4
 | greater than 10 |  |  |  | 2.5
 | Temporary Power Pole |  |  |  | 45
 | Branch Circuits (Temporary or Future) |  |  |  | 60
Commercial/ Multi-Family |  |  |  |  | Permit Fee - 2010 | Count
 | Non-Residential Appliances, up to 5 hp | 0 | 34 | 0 | 34 |  | 34
 | Electrical Sign | 30 | 177 | 109 | 68 |  | 68
 | Power Apparatus (Ratings in HP, KW, [NAME], or KVAR) Transformers, motors
 | Up to 100 KVA | 30 | 154 | 109 | 45 |  | 45
 | Greater than 100 KVA | 30 | 245 | 109 | 136 |  | 136
 | Temporary Power Pole | 0 | 45 | 0 | 45 |  | 45
 | Services, Switchboards, Control Centers, Standing Section & Panels
 | up to 600 volts or 400 amps |  |  |  | 68
 | Over 401amps | 30 | 429 | 327 | 102 |  | 102
 | greater than 600 volts | 90 | 463 | 327 | 136 |  | 136
 | Receptacle, [NAME], Lighting fixture, Thermostat and [NAME], and Smoke Detectors per fixture (1 - 10)  Commericial | 0.5 | 9 | 2 | 7 |  | 7
 | Greater than 10 | 0.5 | 2 | 0 | 2.5 |  | 2.5
 | Pole or [NAME], per fixture | 0 | 23 | 0 | 23 |  | 23
 | Swimming Pool - Electrical | 0 | 136 | 0 | 136 |  | 136
 | [NAME] | 0 | 45 | 0 | 45 |  | 45
 | Electrical Duct Bank (per lin ft) |  |  |  | 60
 | Branch Circuits (Temporary or Future) |  |  |  | 60
 | Miscellaneous Conduits and Conductors (per 100 linear feet) | 0 | 34 | 0 | 34 |  | 34
Applies To All Permit Types |  |  |  |  | Permit Fee - 2010 | Plan check - Per Schedule B-1
 | Permit Issuance |  | 34 |  | 34
 | Miscellaneous electrical |  | [NAME] |  | 68
 | Reinspections |  | [NAME] |  | 175
 | After Hours Inspection (4 hour minimum) |  | OT Hourly Rate |  | 515
 | Overtime Hourly Rate is 120% of the Regular Hourly Rate |  |  |  | 210
Update Jan 25, 2010
 |  |  |  |  |  |  | 11
 |  |  |  |  |  |  | 34
 |  |  |  |  |  |  | 102
 |  |  |  |  |  |  | 45
 |  |  |  |  |  |  | 68
 |  |  |  |  |  |  | 204
 |  |  |  |  |  |  | 14
 |  |  |  |  |  |  | 34
 |  |  |  |  |  |  | 68
 |  |  |  |  |  |  | 34
 |  |  |  |  |  |  | 34
 |  |  |  |  |  |  | 102
 |  |  |  |  |  |  | 34
 |  |  |  |  |  |  | 34
 |  |  |  |  |  |  | 68
 |  |  |  |  |  |  | 28.5
 |  |  |  |  |  |  | 22.5
 |  |  |  |  |  |  | 45
 |  |  |  |  |  |  | 45
 |  |  |  |  |  |  | 8
 |  |  |  |  |  |  | 34
 |  |  |  |  |  |  | 11
 |  |  |  |  |  |  | 45
 |  |  |  |  |  |  | 68
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 68
 |  |  |  |  |  |  | 102
 |  |  |  |  |  |  | 136
 |  |  |  |  |  |  | 170
 |  |  |  |  |  |  | 68
 |  |  |  |  |  |  | 12
 |  |  |  |  |  |  | 68
Spreadsheet: 267458d1380082850-capturing-and-saving-updated-data-from-fields-driven-by-selections-from-drop-down-menu-20130924-1230-mockup-mr-excel
Sheet: Data-from database

EmployeeID | Name | Overall message | Strengths | Skills that have improved | Development objectives | Skill 1 | Skill 2 | Skill 3
1 | Venkman, [NAME] | a | b | c | d | High | Medium | Low
2 | Spengler, Egon | e | f | g | h | Med | Low | High
3 | Zeddmore, Winston | i | j | k | l | Low | Low | Med
4 | Stanz, [NAME] | m | n | o | p | High | Medium | Low
5 | [NAME], [NAME] | q | r | s | t | Med | Low | High
6 | Bourne, [NAME] | u | v | w | x | Low | Low | Med
7 | Golightly, Holly | y | z | aa | bb | High | Medium | Low
8 | Peck, [NAME] | cc | dd | ee | ff | Med | Low | High
9 | Jones, Indiana | gg | hh | ii | jj | Low | Low | Med
Spreadsheet: 848828d1699459195-automated-graph-on-sales-per-day-versus-the-average-of-that-day-from-the-previous-months-excel-forum
Sheet: Sheet1

 | Months of the year
Working days of the month | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | AVERAGE |  | I need to create a graph in wich I can see the differnce between yesterday's sales (let's say November 4) versus the averege of the same day for the earlier months (column "AVERAGE"),
1
2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | and every day I put in the sales for yesterday, the graph will update
3
4
5
6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | something like this, but with the averege line too (from column N)
7
8
9
10
11
12
13
14
15
16
17
18
19
20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | working days
21
22
23
Spreadsheet: 680372d1590995406-consolidate-information-and-return-a-value-with-max-results-in-the-row-return-value-in-a-row-1-1-
Sheet: Sheet1

 | name1 |  | 2019-01-01 00:00:00 | name1
 | [NAME] |  | 2019-01-02 00:00:00 | [NAME] |  | Should be empty because most recent result is empty in C16
 | name3 | 1 | 2019-01-03 00:00:00 | name3
 | name4 | 1 | 2019-01-04 00:00:00 | name4 |  | Should be 1 bacause  C9 is empty.
 | name5 | 1 | 2019-01-05 00:00:00 | name5
 | [NAME] | 1 | 2019-01-06 00:00:00
 | name3 |  | 2019-01-07 00:00:00
 | name4 |  | 2019-01-08 00:00:00
 | name5 |  | 2019-01-09 00:00:00
 | name1 | 1 | 2019-01-10 00:00:00
 | [NAME] | 1 | 2019-01-11 00:00:00
 | name3 |  | 2019-01-12 00:00:00
 | name4 | 1 | 2019-01-13 00:00:00
 | name5 |  | 2019-01-14 00:00:00
 | [NAME] |  | 2019-01-15 00:00:00
Spreadsheet: 16ec8ec9-d217-4afd-8332-8333ad806a10
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 | [NAME]:  (as you would like it to appear on recognition materials)
 | Contact Person:
 | [NAME]:
 | [NAME]:
 |  | Required Green Leader Steps
 |  | Step | Description |  |  |  | Completed? ("Y" for Yes)
 |  | 1 | Register with the Green Homes Challenge
 |  | 1 | Take the Green Homes Challenge Pre-Survey
 |  | 2 | Earn at least 70 points by Implementing Green Actions See "Green Actions" tab
 |  |  |  |  |  | Points Earned
 |  |  | Waste Management |  |  | 0
 |  |  | Transportation & Travel |  |  | 0
 |  |  | Food |  |  | 0
 |  |  | Indoors & Cleaning |  |  | 0
 |  |  | Indoor Water Conservation |  |  | 0
 |  |  | Outdoor Water Conservation |  |  | 0
 |  |  | Outdoors & Yard |  |  | 0
 |  |  | Home Office |  |  | 0
 |  |  | Community Involvement, Education, & Leadership |  |  | 0
 |  |  |  |  | Total Points: | 0
 |  | 3 | Submit your Green Leader Certification Form (this form)
Spreadsheet: 804391d1668037293-formula-for-printing-all-sheets-xcvbtr10
Sheet: 11

 |  | [NAME])  YA MSHIRIKA T.A.G HERMON REVIVAL CHURCH |  |  |  |  |  |  |  |  | MWAKA
 |  | JINA KAMILI | WEEKS | JAN | FEB | [NAME] | APRIL | MAY | [NAME] | JULY | AUGU | SEPT | OKT | NOV | DEC | JUMLA
 |  | ht7 | 1
 |  |  | 2
 |  |  | 3
 |  |  | 4
 |  |  | 5
 |  |  | JUMLA
Spreadsheet: 48810d1248112407-excel-formula-or-macro-test
Sheet: Annexe 1

 | January | February | March | April | May | June | July | August | September | October | November | December | Total
Revenu | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 78
Expense
Salary | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 78
Publicity | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 90
Total expense | 3 | 5 | 7 | 9 | 11 | 13 | 15 | 17 | 19 | 21 | 23 | 25 | 168
Special project
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
Brochure |  |  |  |  |  |  |  |  |  |  |  |  | 0
Flyers
Spreadsheet: 854806d1704563686-lookup-and-find-the-in-between-days-and-return-number-of-days-20240105-h2
Sheet: Sheet1

 |  | ID Number | Date From | Date To | Num Of Days | Days I Get | Actual Days Should Be
 |  | 26827 | 2020-06-01 00:00:00 |  |  |  | 302 | Cell D2 is without [NAME]
 |  | 26827
 |  | 26827
 |  | 26827
 |  | 26827
 |  | 26827
 |  | 26827
 |  | 30617 | 2021-10-03 00:00:00 |  |  |  | 195 | Cell D9 is without [NAME]
 |  | 30617
 |  | 30617
 |  | 30617
 |  | 30706 | 2021-09-27 00:00:00 |  |  |  | 253 | Cell D13 is without [NAME]
 |  | 30706
 |  | 30706
Spreadsheet: 267208d1380012832-vlookup-function-0a215_a
Sheet: Pannell, Troy

Pannell, Troy
Umpire | Player | Team | Position | Votes | Team Margin | K | H | D | CP | UP | DE% | CLG | M | CM | M50 | HO | CLR | CC | ST | R50 | FF | FA | T | 0.01 | Bo | [NAME] | G | B | GA | G% | TG% | DT
Spreadsheet: 679152d1590226311-return-ids-of-account-managers-data-source
Sheet: Account Managers

Account_Manager_ID | Account_Manager
1 | [NAME]
2 | [NAME]
3 | [NAME]
4 | [NAME]
5 | [NAME]
6 | [NAME]
7 | [NAME]
8 | [NAME]
9 | [NAME]
10 | [NAME]
11 | [NAME]
12 | Shane Gardner
13 | Young Madden
14 | [NAME]
15 | [NAME]
16 | [NAME]
17 | [NAME]
18 | [NAME]
19 | [NAME]
20 | Ines Reed
21 | [NAME]
22 | [NAME]
23 | Otha Crosby
24 | [NAME]
25 | Bradley Vincent
26 | [NAME]
27 | [NAME]
28 | [NAME]
29 | [NAME]
30 | Wm Cortez
31 | [NAME]
32 | [NAME]
33 | [NAME]
34 | Isabelle Oneal
35 | [NAME]
36 | Agustin Newton
37 | [NAME]
38 | [NAME]
39 | [NAME]
40 | [NAME]
41 | [NAME]
42 | [NAME]
43 | [NAME]
44 | Asa Nguyen
45 | [NAME]
46 | Minnie Parsons
47 | [NAME]
48 | [NAME]
49 | [NAME]
50 | [NAME]
51 | [NAME]
52 | Willy Simmons
53 | [NAME]
54 | [NAME]
55 | [NAME]
56 | Beatriz [NAME]
57 | [NAME]
58 | [NAME]
59 | [NAME]
60 | [NAME]
61 | [NAME]
62 | [NAME]
63 | [NAME]
64 | [NAME]
65 | Isidro Hubbard
66 | [NAME]
67 | [NAME]
68 | Mikel Glover
69 | [NAME]
70 | [NAME]
71 | [NAME]
72 | Rolland Mays
73 | [NAME]
74 | [NAME]
75 | [NAME]
76 | Norris Norris
77 | [NAME]
78 | [NAME]
79 | [NAME]
80 | [NAME]
81 | [NAME]
82 | [NAME]
83 | [NAME]
84 | [NAME]
85 | [NAME]
86 | [NAME]
87 | [NAME]
88 | [NAME]
89 | [NAME]
90 | [NAME]
91 | [NAME]
92 | [NAME]
93 | [NAME]
94 | Erasmo Morales
95 | [NAME]
96 | Autumn Calderon
97 | [NAME]
98 | [NAME]
99 | Gina Rivera
100 | [NAME]
101 | [NAME]
102 | [NAME]
103 | Eula West
104 | [NAME]
105 | [NAME]
106 | [NAME]
107 | [NAME]
108 | [NAME]
109 | [NAME]
110 | [NAME]
111 | [NAME]
112 | [NAME]
113 | Christie Oneal
114 | [NAME]
115 | Penelope Moody
116 | [NAME]
117 | [NAME]
118 | [NAME]
119 | Marci Holmes
120 | [NAME]
121 | [NAME]
122 | [NAME]
123 | [NAME]
124 | [NAME]
125 | [NAME]
126 | Raleigh Orozco
127 | [NAME]
128 | [NAME]
129 | Coy Clay
130 | [NAME]
131 | [NAME]
132 | [NAME]
133 | [NAME]
134 | [NAME]
135 | [NAME]
136 | [NAME]
137 | [NAME]
138 | Caleb Petty
139 | Krystal Peck
140 | [NAME]
141 | [NAME]
142 | [NAME]
143 | [NAME]
144 | Therese Drake
145 | Mathew Costa
146 | Blanche Bradford
147 | [NAME]
148 | [NAME]
Spreadsheet: 693495d1598991412-combining-vlookup-and-hlookup-sample-data
Sheet: Zip Codes

Airport Zip Code | Airport Code | * Zip codes -> (45 mile radius)
76708 | ACT | 75102 | 75109 | 75151 | 76041 | 76043 | 76055 | 76093 | 76501 | 76502
 | ACT | Local | Local | Local | Local | Local | Local | Local | Local | Local
95519 | ACV | 95501 | 95502 | 95503 | 95514 | 95518 | 95519 | 95521 | 95524 | 95525
Local | ACV | Local | Local | Local | Local | Local | Local | Local | Local | Local
8234 | ACY | 8001 | 8002 | 8003 | 8004 | 8005 | 8006 | 8007 | 8008 | 8009
 | ACY | Local | Local | Local | Local | Local | Local | Local | Local | Local
99546 | ADK | 99546
 | ADK | Local
99615 | ADQ | 99615 | 99619 | 99624 | 99643 | 99644 | 99697
 | ADQ | Local | Local | Local | Local | Local | Local
Spreadsheet: 887724d1738054705-merging-data-from-multiple-workbooks-sorting-alphabetically-creating-new-workbooks-new-class-workbook-with-formulas-for-new-year
Sheet: Summary

Rm | Surname | First Name | Phoneme | Grapheme | Nonsense Words | Phase Passed | Date
Spreadsheet: 850334d1700689228-defining-sumif-range-based-on-the-sum-of-two-cells-upprakning-tester
Sheet: Blad1

 | year | adjustment | cost
 | 2014 | 10 | 100000 |  | [NAME]:
 | 2023 | 2 | 200000 |  | without adjustment | with adjustment
 | 2020 | 3 | 340000 |  |  | =SUMMA.OM(B2:B7+C2:C7;"<"&2023;D2:D7)
 | 2023 | 0 | 150000
 | 2023 | 44 | 72000
 | 2004 | 6 | 58000
Spreadsheet: 120492d1315330637-sum-every-second-cell-based-on-multiple-cells-stockexample
Sheet: Sheet1

Expense | Cat | Quantity | Invent | Price | Project1 | Quant1 | Project2 | Quant2 | Project3 | Quant3 | Project4 | Quant4 | Project5 | Quant5 | Project6 | Quant6 | Project7 | Quant7 | Project8 | Quant8 | Project9 | Quant9 | Project10 | Quant10
120 | [NAME] | 12 |  |  | Proj 0 | 4 | Proj 1 | 2
100 | Metal | 24 |  |  | Proj 0 | 3 | Proj 1 | 6
 |  |  |  |  |  |  | =rept(text,number times)
 |  |  |  |  |  |  |  |  | Expected
 |  |  |  |  | NEED: | Proj 0 | Wood
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | Metal
 |  |  |  |  |  |  | Plastic
 |  |  |  |  |  | Proj 1 | Wood
 |  |  |  |  |  |  | [NAME]
 | Cat |  | Project |  |  |  | Metal
 | Wood |  | Proj 0 |  |  |  | Plastic
 | [NAME] |  | Proj 1 |  |  | and so on…
 | Metal |  | Proj 2
 | Plastic |  | Proj 3
 |  |  | Proj 4
 |  |  | Proj 5
 |  |  | Proj 6
 |  |  | Proj 7
 |  |  | Proj 8
 |  |  | Proj 9
 |  |  | Proj 10
Spreadsheet: 817179d1676041157-help-with-filtering-test-fields-test-excel
Sheet: Sheet1

Date | NT | Specialty | Agent transferred to | Case Number | Case Number | Case Number | Case Number | Case Number | Case Number | Comments | Region | Start | End
2023-02-12 00:00:00 |  |  |  | Off Shift | Off Shift | Off Shift | Extra | Extra | Extra
2023-02-12 00:00:00 |  |  |  | Off Shift | Off Shift | Off Shift | Extra | Extra | Extra
2023-02-12 00:00:00 |  |  |  | Off Shift | Off Shift | Off Shift | Extra | Extra | Extra
2023-02-12 00:00:00 |  |  |  | Off Shift | Off Shift | Off Shift | Extra | Extra | Extra
2023-02-12 00:00:00 |  |  |  | Low Offers | Exempted | UP Off | Extra | Extra | Extra
2023-02-12 00:00:00 |  |  |  | Off Shift | Off Shift | Off Shift | Extra | Extra | Extra
2023-02-12 00:00:00 |  |  |  | Off Shift | Off Shift | Off Shift | Extra | Extra | Extra
2023-02-12 00:00:00 |  |  | [NAME] | Tech | Going on vacation | Off | Extra | Extra | Extra
2023-02-12 00:00:00 |  |  | [NAME] | 2211111111111111 | 33333333 |  | Extra | Extra | Extra
2023-02-12 00:00:00 |  |  | [NAME] | Off Shift | Off Shift | Off Shift | Extra | Extra | Extra
2023-02-12 00:00:00 |  |  | Manja | Off Shift | Off Shift | Off Shift | Extra | Extra | Extra
2023-02-12 00:00:00 |  |  | [NAME] | Off Shift | Off Shift | Off Shift | Extra | Extra | Extra
2023-02-12 00:00:00 |  |  | Laurence | 2211111111111112 |  |  | Extra | Extra | Extra
2023-02-12 00:00:00 |  |  |  | Off Shift | Off Shift | Off Shift | Extra | Extra | Extra
2023-02-12 00:00:00 |  |  |  | Off Shift | Off Shift | Off Shift | Extra | Extra | Extra
Spreadsheet: 57103d1257273626-lookup-with-repeating-values-new-example
Sheet: Dump 1129

 |  |  |  | Actual | Actual | Actual | Actual | Actual | Actual | Forecast
 |  |  |  | Period 1 | Period 2 | Period 3 | Period 4 | Period 5 | Period 6 | Period 7
 |  | KEY | Lead column | 2009/10 | 2009/10 | 2009/10 | 2009/10 | 2009/10 | 2009/10 | 2009/10
212018 | Sales in Cnt to Proc | 212018  Sales in Cnt to Proc*        Total Sales | 212018  Sales in Cnt to Proc | -21769.09 | -15399.89 | -24259.48 | -25338.92 | -22608.4 | -28994.92 | -34546.36
212708 | Energy [NAME] | 212708  Energy Surcharge Int*        Total Sales | 212708  Energy Surcharge Int | -2490.44 | -2591.39 | -2416.96 | -3387.02 | -2582.13 | -3423.68 | -6109.56
213011 | External Sales | 213011  External Sales*        Total Sales | 213011  External Sales | -491554.78 | -469001.02 | -598475.63 | -407829.73 | -396456.11 | -577454.96 | -505449.59
213519 | Energy Surcharge Ext | 213519  Energy Surcharge Ext*        Total Sales | 213519  Energy Surcharge Ext | -57427.7 | -59052.3 | -70703.29 | -50934.27 | -61102.67 | -74126.03 | -87510.91
*        Total Sales*        Total Sales | Total Sales | *        Total Sales*        Total Sales | *        Total Sales | -573242.01 | -546044.6 | -695855.36 | -487489.94 | -482749.31 | -683999.59 | -633616.42
Spreadsheet: 02c5f0e3-48a3-48d0-9027-7f1ee76b3c94
Sheet: LCSC

 | Lewis-Clark State College
 | Summary of Sources and Uses of Funds
 |  |  |  | A | B | C |  | D |  | E | F |  | G |  | H
 |  |  |  | Operating Budgets
 |  |  |  | Board Approved Budgets |  |  |  | CEO Approved |  | Estimated Budgets |  |  | Total |  | %
 |  |  |  | General | Professional- Technical | Special |  | Auxiliary |  | Instit | Grants & |  | Operating |  | of
 |  |  |  | Education | Education | Programs |  | Enter.   1) |  | Accounts | Contracts |  | Budgets |  | Total
 | SOURCES OF FUNDS:
 |  | State Appropriations
1 |  | General Account
 |  | General Acct - One time funds
 |  | Endowment Funds |  | 1267000
 |  | Student Fees |  | 8533800
 |  | Student Fees/Other - One time
 |  | ARRA Stimulus Funds
 |  | Total Appropriations
 |  | Other Student Fees |  |  |  |  |  |  |  | 3650000
 |  | Federal Approp
 |  | Federal Grants & Contracts |  |  |  |  |  |  |  |  | 2000000
 |  | State Grants & Contracts |  |  |  |  |  |  |  |  | 2400000
 |  | Private Gifts, Grts & Contr |  |  |  |  |  |  |  |  | 400000
 |  | Sales & Serv of Educ Act |  |  |  |  |  |  |  | 2300000
 |  | Sales & Serv of Aux Ent
 |  | Indirect Costs |  |  |  |  |  |  |  | 150000
 |  | Other |  |  |  |  |  |  |  | 1600000
 |  | Total Revenue
 | USES OF FUNDS:
 |  | Instruction |  | 12210795 | 3351524 |  |  |  |  | 2293300 | 2252600
 |  | Research |  | 149561 |  |  |  |  |  | 0 | 186900
 |  | Public Service |  | 102062 |  |  |  |  |  | 465700 | 1548800
 |  | Academic Support |  | 1906700 | 624007 |  |  |  |  | 6200
 |  | Libraries |  | 1025219 |  |  |  |  |  | 557100 | 811700
 |  | Student Services |  | 1857361 | 176936 |  |  |  |  | 342000 | 0
 |  | Institutional Support |  | 3903855 |  |  |  |  |  | 1729200
 |  | Physical Plant |  | 2833955 |  |  |  |  |  | 351600
 |  | Scholarships & Fellowships |  |  |  |  |  |  |  | 93300
 |  | Auxiliary Enterprises      (1) |  | 912892 |  |  |  | 3812863 |  | 1661600
 |  | Mandatory Transfers
 |  | One-time Replacement Capital |  | 951200 | 69167
 |  | Total Uses
 | Incr/(Decr) to Balance
 | Employee FTE |  |  | 308.23 | 56.01 |  |  |  |  |  | 47.45
 |  | (1) General Education program supports intercollegiate athletics which is an auxiliary enterprise and reported in the General Education
 |  | column not the auxiliary enterprise column.
Spreadsheet: phillip_m_love__30713__200009_OA
Sheet: TX-CON-FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  ECTR (EGM) / HPLR / HPLC
 |  |  | NGP&L |  | CPR Adjustments |  | 3rd Day CPR |  | [NAME] |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL INTRA-MTH
FT-Texas
 |  | Current Month MTM
 |  | Financial Liquidations
 |  | Originations
 |  | TOTAL FIRM TRADING
 |  | TOTAL NGPL
Spreadsheet: 822810d1679547559-random-time-between-starting-and-ending-time-generate-overtime
Sheet: Sheet1

 |  |  | Starting time | addition | Ending time
 |  |  | 09:30:00 | 10:00:00
 |  |  | 09:30:00
 |  |  | 09:30:00
 |  |  | 09:30:00
 |  |  | 09:30:00
 |  |  | 09:30:00
 |  |  | 09:30:00
 |  |  | 09:30:00
 |  |  | 09:30:00
 |  |  | 09:30:00
 |  |  | 09:30:00
 |  |  | 09:30:00