tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 797250d1663775099-allocating-based-on-dates-with-if-and-function-book1-83-dates-aligw
Sheet: Sheet1

Start Date | End Date | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 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 | 2024-01-01 00:00:00
2022-06-01 00:00:00 | 2023-05-31 00:00:00
2022-06-01 00:00:00 | 2023-05-31 00:00:00
2022-06-12 00:00:00 | 2023-05-31 00:00:00
2022-06-20 00:00:00 | 2023-06-19 00:00:00
2022-06-21 00:00:00 | 2023-06-20 00:00:00
2022-06-24 00:00:00 | 2023-06-23 00:00:00
2022-07-04 00:00:00 | 2023-07-03 00:00:00
2022-07-06 00:00:00 | 2023-07-05 00:00:00
2022-07-06 00:00:00 | 2023-07-05 00:00:00
2022-07-08 00:00:00 | 2023-01-07 00:00:00
2022-07-09 00:00:00 | 2023-01-08 00:00:00
2022-07-09 00:00:00 | 2023-07-08 00:00:00
2022-07-11 00:00:00 | 2023-07-10 00:00:00
2022-07-11 00:00:00 | 2023-07-10 00:00:00
2022-07-13 00:00:00 | 2022-10-13 00:00:00
2022-07-22 00:00:00 | 2023-01-21 00:00:00
2022-07-25 00:00:00 | 2022-10-24 00:00:00
2022-07-26 00:00:00 | 2023-07-25 00:00:00
2022-07-28 00:00:00 | 2023-07-27 00:00:00
2022-07-29 00:00:00 | 2023-07-28 00:00:00
2022-08-01 00:00:00 | 2023-07-31 00:00:00
2022-08-05 00:00:00 | 2022-11-03 00:00:00
2022-08-08 00:00:00 | 2023-08-07 00:00:00
2022-08-10 00:00:00 | 2023-08-09 00:00:00
2022-08-15 00:00:00 | 2022-11-15 00:00:00
2022-08-19 00:00:00 | 2023-02-18 00:00:00
2022-08-19 00:00:00 | 2023-08-18 00:00:00
2022-08-23 00:00:00 | 2023-08-22 00:00:00
2022-08-23 00:00:00 | 2022-08-22 00:00:00
2022-08-31 00:00:00 | 2023-08-30 00:00:00
2022-09-01 00:00:00 | 2022-12-01 00:00:00
2022-09-01 00:00:00 | 2022-12-01 00:00:00
2022-09-01 00:00:00 | 2022-12-01 00:00:00
2022-09-01 00:00:00 | 2023-08-31 00:00:00
2022-09-02 00:00:00 | 2023-09-01 00:00:00
2022-09-12 00:00:00 | 2023-09-11 00:00:00
2022-09-12 00:00:00 | 2023-09-11 00:00:00
2022-09-14 00:00:00 | 2023-03-13 00:00:00
2022-09-18 00:00:00 | 2022-12-18 00:00:00
2022-10-02 00:00:00 | 2023-10-01 00:00:00
2022-10-02 00:00:00 | 2023-10-01 00:00:00
2022-10-06 00:00:00 | 2022-10-05 00:00:00
2022-10-08 00:00:00 | 2022-04-07 00:00:00
Spreadsheet: 845775d1697123386-subtract-formula-based-on-row-colour-subtract-formula-based-on-row-colour
Sheet: Sheet1

EXMP - 1 | STRIKE | PRICE |  | PRICE |  | TOTAL
 | 17500 | 8264 |  | 83845
 | 17550 | 10959 |  | 72979
 | 17600 | 98133 |  | 138793 |  |  |  |  | DEAR SIR / MAM
 | 17650 | 103658 |  | 78675 |  |  |  |  | In this 2 Example I want Auto Subtract the amount in G Column based on the Row Color
 | 17700 | 106643 |  | 28250 |  |  |  |  | The Colored Row Automatically move up and down in regular interval
 | 17750 | 80848 |  | 4296 |  |  |  |  | so I want Conditional formula / Function in G Column based on Row Color
EXMP - 2 | STRIKE | PRICE |  | PRICE
 | 17500 | 8264 |  | 83845
 | 17550 | 10959 |  | 72979
 | 17600 | 98133 |  | 138793
 | 17650 | 103658 |  | 78675
 | 17700 | 106643 |  | 28250
 | 17750 | 80848 |  | 4296
Spreadsheet: 762624d1641667665-conditional-formatting-data-bar-different-color-depending-on-value-notes
Sheet: Notes

Coefficient | Branches
3 | MATHE | 45 | 11 | 41.5
 | vun: | 60 | 15 | 60
3 | ALLEM | 38 | 36
 | vun: | 60 | 60
3 | ANGLA | 10 | 26
 | vun: | 10 | 30
4 | ECOAI | 38
 | vun: | 60
3 | ECOPO | 42
 | vun: | 60
3 | FRANC | 28 | 18
 | vun: | 60 | 30
2 | HISTO | 15
 | vun: | 45
1 | CIVIC
 | vun:
2 | PHILO
 | vun:
Spreadsheet: 198609d1354826670-can-vlookup-do-this-solver_solution
Sheet: Solver_setup

 | Target | 1958
 | 270.72 | 1
 | 346.86 | 1
 | 287.64 | 0
 | 219.96 | 0
 | 135.36 | 1
 | 16.92 | 0
 | 169.2 | 1
 | 84.6 | 1
 | 33.84 | 0
 | 37.14 | 0
 | 74.28 | 0
 | 111.42 | 0
 | 222.84 | 0
 | 55.71 | 1
 | 74.28 | 0
 | 241.41 | 1
 | 37.14 | 1
 | 74.28 | 0
 | 18.57 | 0
 | 18.57 | 0
 | 18.57 | 0
 | 18.57 | 0
 | 37.14 | 1
 | 18.57 | 0
 | 55.71 | 0
 | 246.8 | 0
 | 579.68 | 1
 | 144.92 | 0
 | 289.84 | 0
 | 81.5 | 0
 | 162.99 | 0
 | sum | 1957.82
 | Object f | 0.1799999999998363
Spreadsheet: c8b274fa-04ff-4649-aef9-5b7b2edf10c5
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | SWIM | T2 | RUN.1 | POSITION | TOTAL TIME
5279 | 28302 | Ellie | Salthouse | AUS | 0 | 00:08:26 | 00:00:00 | 00:15:56 | 00:00:00 | 00:10:15 | 1 | 00:34:36
5279 | 18588 | Jasmine | [NAME] | SWE | 0 | 00:08:35 | 00:00:00 | 00:15:45 | 00:00:00 | [NAME] | 2 | 00:35:04
5279 | 21841 | Simone | Ackermann | NZL | 0 | 00:08:42 | 00:00:00 | 00:15:36 | 00:00:00 | 00:10:53 | 3 | 00:35:14
5279 | 31559 | Brooke | [NAME] | AUS | 0 | 00:08:51 | 00:00:00 | 00:15:01 | 00:00:00 | 00:11:27 | 4 | 00:35:19
5279 | 31558 | Maddison | [NAME] | AUS | 0 | 00:09:06 | 00:00:00 | 00:14:38 | 00:00:00 | 00:11:35 | 5 | 00:35:19
5279 | 15743 | Erin | Gangelhoff | AUS | 0 | [NAME] | 00:00:00 | 00:15:30 | 00:00:00 | [NAME] | 6 | 00:35:38
5279 | 17670 | Sara | Vilic | ITU | 0 | 00:09:18 | 00:00:00 | 00:15:01 | 00:00:00 | 00:12:11 | 7 | 00:36:30
Spreadsheet: 99490d1298106142-dynamically-select-non-zero-rows-labels-and-corresponding-values-matrix
Sheet: Sheet1

Data available |  |  |  | This matrix shall be developed with the help of col.B & col.C
Pipe | From | To |  | Source 1 |  |  |  |  |  |  |  |  |  |  | Instructions:
1 | 1 | 2 |  |  | Adjacent matrix (A) |  |  |  |  |  |  |  |  | 1 | I have created the matrix manually
2 | 2 | 3 |  |  | 1 | 2 | 3 | 4 | 5 | 6 |  |  |  | 2 | Matrix shall be developed with "from & to" column
3 | 3 | 4 |  | 1 | 0 | 1 | 0 | 0 | 0 | 1 |  |  |  | 3 | Assume source at Node 1
4 | 4 | 5 |  | 2 | 0 | 0 | 1 | 0 | 1 | 0 |  |  |  | 4 | Flows are bidirectional (shown in the graph) except
5 | 5 | 6 |  | 3 | 0 | 1 | 0 | 1 | 0 | 0 |  |  |  |  | the source node (i.e. flow wouldn't go towards the source node)
6 | 6 | 1 |  | 4 | 0 | 0 | 1 | 0 | 1 | 0 |  |  |  | 5 | Give point 1 in the matrix for connecting code otherwise 0 (see the matrix)
7 | 2 | 5 |  | 5 | 0 | 1 | 0 | 1 | 0 | 1 |  |  |  | 6 | 6 nodes in the horizontal & 6 nodes in the vertical arrangement
 |  |  |  | 6 | 0 | 0 | 0 | 0 | 1 | 0 |  |  |  | 7 | Further the program should work for the source at node 2
 |  |  |  | Source 2
 |  |  |  |  | Adjacent matrix (A)
 |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6
 |  |  |  | 1 | 0 | 0 | 0 | 0 | 0 | 1
 |  |  |  | 2 | 1 | 0 | 1 | 0 | 1 | 0
 |  |  |  | 3 | 0 | 0 | 0 | 1 | 0 | 0
 |  |  |  | 4 | 0 | 0 | 1 | 0 | 1 | 0
 |  |  |  | 5 | 0 | 0 | 0 | 1 | 0 | 1
 |  |  |  | 6 | 1 | 0 | 0 | 0 | 1 | 0
Spreadsheet: 213323d1360440377-probability-of-more-than-once-in-a-column-sport
Sheet: Sheet1

Player ID | Game
2938 | tennis
3493 | running
2938 | soccer
400 | soccer
231 | tennis
532 | tennis
145 | running
425 | tennis
231 | rugby
302 | soccer
Spreadsheet: 1fb45253-fa57-4b0b-a60d-45ac857120f4
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 8731.0 Building Approvals, Australia
 | TABLE 37. Value of Building Approved - Australian Capital Territory
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Value of Approval ;  Australian Capital Territory ;  Total residential building ;  New ; |  |  | Original | A420494A | 1970-07-01 00:00:00 | 2012-05-01 00:00:00 | 503 | $'000 | FLOW | Month | 1
Value of Approval ;  Australian Capital Territory ;  Total residential building ;  Total alterations/additions (incl. refurb and conversion) ; |  |  | Original | A420503T | 1973-07-01 00:00:00 | 2012-05-01 00:00:00 | 467 | $'000 | FLOW | Month | 1
Value of Approval ;  Australian Capital Territory ;  Total residential building ;  Total (Type of work) ; |  |  | Original | A420515A | 1973-07-01 00:00:00 | 2012-05-01 00:00:00 | 467 | $'000 | FLOW | Month | 1
Value of Approval ;  Australian Capital Territory ;  Total non-residential building ;  Total (Type of work) ; |  |  | Original | A421178T | 1970-07-01 00:00:00 | 2012-05-01 00:00:00 | 503 | $'000 | FLOW | Month | 1
Value of Approval ;  Australian Capital Territory ;  Total building ;  Total (Type of work) ; |  |  | Original | A422865L | 1973-07-01 00:00:00 | 2012-05-01 00:00:00 | 467 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: 8cb1e853-e1f7-4a31-bf3c-6da3f34f55c8
Sheet: 3-Budget Detail

CDE CHARTER SCHOOL GRANT PROGRAM
1 | 2 | 3 | 4 | 4b | 4c | 4d | 4e | 4f | 4g | 5 | 6 | 7
Budget Object | Project Number/Budget Year | Quantity | Original Cost | 1st Revision | 2nd Revision | 3rd Revision | 4th Revision | 5th Revision | 6th Revision | Description/Budget Narrative | Expected Date of Completion | Notes
Spreadsheet: 120151d1315014626-pivot-tables-help-pivothelp
Sheet: PivotTable

Count of Mark | Column Labels
Row Labels | DO1 | DO10 | DO11 | DO12 | DO13 | DO14 | DO15 | DO16 | DO17 | DO18 | DO19 | DO2 | DO20 | [NAME] | DO22 | DO3 | DO4 | DO5 | DO6 | DO7 | DO8 | DO9
DI1
CL |  |  |  |  |  |  |  |  |  |  |  | 1
I |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 |  | 1
SD | 1
x |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
DI2
I |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 1 |  |  | 1
DI3
I |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1
[NAME]
I |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  | 1 | 1 | 1 |  |  |  |  | 1 | 1
q |  |  |  |  |  |  |  |  |  |  | 1
x |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Count of Mark | Column Labels
 | DI1 |  |  |  | DI2 | DI3 | [NAME] |  |  | Grand Total
Row Labels | CL | I | SD | x | I | I | I | q | x
DO1 |  |  | 1 |  |  |  |  |  |  | 1
DO10 |  | 1 |  |  | 1 | 1 | 1 |  |  | 4
DO11 |  |  |  |  |  |  | 1 |  |  | 1
DO12 |  |  |  |  |  |  | 1 |  |  | 1
DO13 |  |  |  |  |  |  | 1 |  |  | 1
DO14 |  |  |  |  |  |  | 1 |  |  | 1
DO15 |  |  |  |  |  |  | 1 |  |  | 1
DO16 |  |  |  |  |  |  | 1 |  |  | 1
DO17 |  |  |  |  |  |  | 1 |  |  | 1
DO18 |  |  |  |  |  |  | 1 |  |  | 1
DO19 |  |  |  |  |  |  |  | 1 |  | 1
DO2 | 1 |  |  |  |  |  |  |  |  | 1
DO20 |  |  |  |  |  |  | 1 |  |  | 1
[NAME] |  |  |  |  |  |  | 1 |  |  | 1
DO22 |  |  |  |  |  |  | 1 |  |  | 1
DO3 |  | 1 |  |  |  |  |  |  |  | 1
DO4 |  | 1 |  |  | 1 |  |  |  |  | 2
DO5 |  | 1 |  |  |  |  |  |  |  | 1
DO6 |  | 1 |  |  | 1 | 1 |  |  |  | 3
DO7 |  | 1 |  |  |  | 1 | 1 |  |  | 3
DO8 |  |  |  | 1 |  | 1 | 1 |  |  | 3
DO9 |  | 1 |  |  | 1 | 1 |  |  | 1 | 4
Grand Total | 1 | 7 | 1 | 1 | 4 | 5 | 14 | 1 | 1 | 35
Spreadsheet: 24703d1215452886-trouble-with-ifs-and-thens-forumexample
Sheet: Sheet1

Scientific Name | [NAME] | ID | Type | Growth | Nativity | Site | Year | Season | Hits | Average Cover % | Frequency% | Relative Veg. Cover | Average Cover - All | Relative Veg. Cover-All | % Foliar Cover
Helianthus pumilus | DWARF SUNFLOWER | HEPU | F | P | N | C1 | 1998 | Spring | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 174a123a-b730-4784-8753-600da4111155
Sheet: Linda Waite-Simpson

[NAME]
Fair Share Fee: Those Who Don't Pay Their Fair Share
Agree
Explain your fair share position, if you choose.
This law must apply to all bargaining units; not just teachers.
Teachers' Retirement: Support in the State Budget
Agree
Explain your teachers' retirement position, if you choose.
A promise is a promise!
Health Care: Continuing System Reform
Agree
Explain your health care reform position, if you choose
It is my understanding that the teachers will be exempt from the new exchange (qualified self-insured plan).  I don't have the specific
information on the single payer plan - and we don't know if we'll even get a waiver to do much before 2017.
Teaching Career: Retaining New Teachers
Agree
Explain your teaching career position, if you choose
Mentoring, decent starting salaries and high quality professional development are very important and I support all three.
Teaching Profession: Simplifying Professional Relicensing
Agree
Explain your relicensing position, if you choose
We should minimize bureaucracy as much as possible - here and in other areas.
Name | email address | Address | Office sought | Are you an incumbent? |  | County
[NAME] | [EMAIL] | 76 Beech Street | House of Representatives | Yes |  | Chittenden
Spreadsheet: 8c3b89b2-0916-4efc-851b-ba47d4f713eb
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
APPLICATION FOR GRADUATION
I hereby make application for the degree of |  |  |  |  | Will you participate in the commencement exercise?
 |  |  |  |  |  | Yes/No
Bachelor of Science
Bachelor of Arts |  |  |  |  | If no, please provide a mailing address for your diploma
Masters |  |  |  |  | and a contact number.
To be conferred (check only one, please)
 | Spring Semester (May Commencement) |  |  |  |  | Mailing Address:
 | Fall Semester (December Commencement)
 |  |  |  |  |  | Home Telephone#
 |  |  |  |  |  | Current Mailing Address:
Major
Your name as you wish it to appear on degree:
(Please print legibly) |  |  |  |  |  | Local Telephone#
 |  |  |  |  |  | Please return application to:
Student's Signature
 |  |  |  |  |  | University of Arkansas at Pine Bluff
 |  |  |  |  |  | Office of Admissions & Academic Records
ID Number |  |  | Date |  |  | 1200 N. University Drive--Mail Slot 4983
 |  |  |  |  |  | Pine Bluff, Arkansas 71601
Height |  | Weight
This information is needed in order to obtain the |  |  |  |  |  | In order to assist us in preparing you for
proper size gown for you.  (Misleading information |  |  |  |  |  | graduation, please make sure that your
will result in your possibly not having a gown that fits |  |  |  |  |  | advisor is aware that you are applying for
appropriately.) |  |  |  |  |  | graduation.
NOTE: | IT IS IMPERATIVE THAT ALL SENIORS AND GRADUATE STUDENTS SUBMIT AN
 | APPLICATION FOR GRADUATION
Spreadsheet: 676546d1588863056-who-supplies-what-example
Sheet: Sheet3

Apples | Bananas | Strawberries | Blackberries | Pineapples
[NAME]'s Fruit | [NAME]'s Fruit | [NAME]'s Fruit | [NAME]'s Fruit | [NAME]'s produce
[NAME]'s produce | [NAME]'s produce | [NAME]'s produce | [NAME]'s produce | [NAME]'s food
[NAME]'s food | [NAME]'s goodies | [NAME]'s food | [NAME]'s food | [NAME]'s goodies
[NAME]'s goodies |  | Eva's berries | Eva's berries
Spreadsheet: cooper_richey__4321__marks
Sheet: Sheet1

 |  |  |  |  |  |  | Jan 29  2002
 |  | *2001 actual published PP
 |  |  | flat | on | off |  | 2002 | BID | OFFER | MID
 |  | JAN* | 131.23 | 145.5 | 113.1 |  | BOM | 30 | 30.5
 |  | FEB* | 116.75 | 134.4 | 93.16 |  | FEB | 27 | 27.5
 |  | MAR* | 97.23 | 114.6 | 73.12 |  | MAR | 27 | 28
 |  | APR* | 114.82 | 138.4 | 85.25 |  | APR | 26 | 27
 |  | MAY* | 88.34 | 107.4 | 61.85 |  | MAY | 25.5 | 27.5
 |  | JUN* | 63.59 | 79.85 | 41.34 |  | JUN | 25.5 | 27.5
 |  | JUL* | 53.47 | 64.64 | 40.48 |  | JUL | 31.5 | 32.5
 |  | AUG* | 52.37 | 63.54 | 36.91 |  | AUG | 31.5 | 32.5
 |  | SEP* | 29.84 | 35.9 | 23.11 |  | SEP | 31.5 | 32.5
 |  | OCT* | 43.92 | 54.2 | 29.73 |  | OCT | 34.5 | 35.5
 |  | NOV* | 33.31 | 42.28 | 22.09 |  | NOV | 34.5 | 35.5
 |  | DEC | 33.3 |  |  |  | DEC | 34.5 | 35.5
 |  |  |  |  |  |  | Feb Dec
Spreadsheet: 494215d1482253398-2017-revenue-forecast-trend-formula-2017-forecast-trend_linear
Sheet: 2016 Summary

CATEGORIES |  | January | February | March | April | May | June | July | August | September | October | November | December | Full Year
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
REVENUE
Hosting Services |  | 11244 | 10589.5 | 12644 | 12704 | 14444 | 11944 | 18064 | 16109 | 13609 | 14217 | 13929 | 13609
License Subscription |  | 56831 | 29461 | 35284 | 37961 | 66853 | 43617 | 70637 | 86921 | 88725 | 80619.5 | 81208 | 52802
TOTAL
Spreadsheet: 777943d1650704357-conditional-formatting-when-all-rows-of-a-type-meet-a-condition-example-ans
Sheet: Sheet1

INVOICE | STATUS
1214 | [NAME]
1214 | ORDERED
1664 | [NAME]
1664 | [NAME]
1664 | [NAME]
1664 | [NAME]
1664 | [NAME]
1684 | ORDERED
1684 | [NAME]
1684 | [NAME]
1684 | [NAME]
Spreadsheet: 199763d1355321876-matching-numbers-meals-per-day
Sheet: Sheet1

 |  | [NAME] per day
 |  | Mon | [NAME] | Weds | Thurs | Fri | Total | Answer Needed
 | Fred | 1 | 1 | 1 |  |  |  | On different days
 | [NAME] |  |  | 3 |  |  |  | All on one day
 | [NAME] |  | 2 |  |  |  |  | All on one day
 | [NAME] |  | 2 | 1 | 2 |  |  | On different days
Spreadsheet: cd818d12-95c2-4ce1-bf16-6e860bc32fe8
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
[NAME] giving worksheet and budget
SPECIAL OCCASION BUDGET | Estimate | Actual | Difference |  | GIFT IDEAS
GIFTS | 1170 | 730 | 440 |  | NAME | GIFTS
CARDS/WRAPPING | 0 | 0 | 0
HOSTED CELEBRATION | 0 | 0 | 0
ATTENDED CELEBRATIONS | 300 | 295 | 5
TRAVEL | 0 | 0 | 0
DONATIONS | 0 | 0 | 0
Other |  |  | 0
Total SPECIAL OCCASION BUDGET | 1470 | 1025 | 445
GIFTS | Estimate | Actual | Difference
Significant other | 300 | 350 | -50
Mom | 100 | 80 | 20
Dad | 100 | 0 | 100
Brother | 100 | 0 | 100
Sister | 100 | 0 | 100
In-law | 50 | 0 | 50
Niece | 40 | 0 | 40
[NAME] | 40 | 0 | 40
[NAME] | 100 | 300 | -200
Grandpa | 100 | 0 | 100
Gift exchanges | 20 | 0 | 20
Neighbor gifts | 40 | 0 | 40
Teacher gifts | 40 | 0 | 40
Hostess gifts | 40 | 0 | 40
Other | 0 | 0 | 0
Total GIFTS | 1170 | 730 | 440
CARDS/WRAPPING | Estimate | Actual | Difference
Photography |  |  | 0
Cards |  |  | 0
Wrapping supplies |  |  | 0
Packaging/Shipping |  |  | 0
Postage |  |  | 0
Other |  |  | 0
Total CARDS/WRAPPING | 0 | 0 | 0
HOSTED CELEBRATION | Estimate | Actual | Difference
Decorations |  |  | 0
Meal |  |  | 0
Drinks |  |  | 0
Snacks |  |  | 0
Appetizers |  |  | 0
Invitations |  |  | 0
Caterers |  |  | 0
Other (Loot bags, take homes, outfit) |  |  | 0
Total HOSTED CELEBRATION | 0 | 0 | 0
ATTENDED CELEBRATIONS | Estimate | Actual | Difference
Tickets | 100 | 90 | 10
Hostess gifts | 40 | 45 | -5
Babysitter - Work party | 80 | 80 | 0
Babysitter - Neighbor's party | 80 | 80 | 0
Other (clothing, meal contributions) |  |  | 0
Total ATTENDED CELEBRATIONS | 300 | 295 | 5
TRAVEL | Estimate | Actual | Difference
Flight |  |  | 0
Accomodation |  |  | 0
Food |  |  | 0
Activities |  |  | 0
Other (clothing, travel supplies) |  |  | 0
Total TRAVEL | 0 | 0 | 0
DONATIONS | Estimate | Actual | Difference
United way |  |  | 0
Food bank |  |  | 0
Total DONATIONS | 0 | 0 | 0
Spreadsheet: 10a03aab-44bf-4875-a4dd-0352735b8f5b
Sheet: Sheet1

TOTAL HEARINGS | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Fiscal Year 13: 150
COMMITMENT HEARINGS
 | Central | Northeast | Southern | Western | Boulder | Total %
Grants | 26 | 18 | 14 | 3 | 1 | 0.89
Denials | 2 | 1 | 0 | 0 | 0 | 0.04
[NAME] | 1 | 1 | 0 | 0 | 0 | 0.03
[NAME] w/prej | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 0 | 0 | 0
Continued | 1 | 1 | 1 | 0 | 0 | 0.04
Split | 0 | 0 | 0 | 0 | 0 | 0
Subtotal % | 0.43 | 0.3 | 0.21 | 0.04 | 0.02 | 70 Hearings
POST COMMITMENT HEARINGS
 | Central | Northeast | Southern | Western | Boulder | Total %
Grant | 2 | 1 | 2 | 4 | 0 | 0.21
Grant with Prejudice | 6 | 9 | 6 | 4 | 0 | 0.57
[NAME] | 1 | 0 | 0 | 0 | 0 | 0.02
[NAME] w/Prejudice | 2 | 1 | 1 | 1 | 0 | 0.11
Recommendation | 2 | 1 | 1 | 0 | 0 | 0.09
Continue | 0 | 0 | 0 | 0 | 0 | 0
Subtotal % | 0.28 | 0.28 | 0.23 | 0.21 | 0 | 44 Hearings
VIOLATION HEARINGS
 | Central | Northeast | Southern | Western | Boulder | Total %
Revoke from post commitment parole | 2 | 4 | 1 | 6 | 0 | 0.54
Revoke from commitment parole | 6 | 1 | 1 | 0 | 0 | 0.33
Modify during Post Commitment Parole | 0 | 0 | 0 | 1 | 0 | 0.04
Review of Suspension - return to parole | 1 | 0 | 0 | 0 | 0 | 0.04
Review of Parole | 1 | 0 | 0 | 0 | 0 | 0.04
Subtotal % | 0.42 | 0.21 | 0.08 | 0.29 | 0 | 24 Hearings
FULL BOARD ACTIONS
 | Central | Northeast | Southern | Western | Boulder | Total %
Aggravated Offender Post Commitment Grant with Prejudice | 1 | 0 | 0 | 0 | 0 | ~8%
Aggravated Offender Post Commitment Grant | 1 | 0 | 0 | 0 | 0 | ~8%
Violent Offender Commitment Grant | 1 | 0 | 0 | 1 | 0 | ~16%
Violent Offender Post Commitment Grant with Prejudice | 0 | 0 | 1 | 0 | 0 | ~8%
Violent Offender Post Commitment Grant | 2 | 0 | 0 | 0 | 0 | ~16%
Discharge to DOC Grant | 1 | 1 | 0 | 0 | 0 | ~16%
Discharge Other Grant | 0 | 1 | 0 | 1 | 0 | ~16%
Appeal Affirm | 0 | 1 | 0 | 0 | 0 | ~8%
Subtotal % | 0.5 | 0.25 | ~8% | ~16% | 0 | 12 Hearings
Spreadsheet: 329687d1404384376-help-to-prepare-dynamic-table-in-excel-dummy
Sheet: Sheet2

 | Current week | 23
 | current week | 22
 | Product | week 23 Quantity | week 23 Quantity
 | a | 0
 | b | 0
 | c
 | d
 | e
 | f
 | g |  | 0
 | i |  | 0
P.S | If I change current and previous week it will automatically get updated.
Spreadsheet: 133098d1324172821-top-cumulative-cumulative
Sheet: Cumulative %

Result C | 8 |  |  |  |  |  | Result A - Occurred 5 times
Result D | 7 |  |  |  |  |  | Result B - Occurred 3 times
Result E | 6 |  |  |  |  |  | [NAME] 8 times
[NAME] | 6 |  |  |  |  |  | Result D - Occurred 7 times
Result A | 5 |  |  |  |  |  | Result E - Occurred 6 times
Result G | 5 |  |  |  |  |  | [NAME] 6 times
Result B | 3 |  |  |  |  |  | [NAME] 5 times
 |  |  |  |  |  |  | I need to calculate the top 70% (approximate) of the results based on how frequently they occurred.
 |  |  |  |  |  |  | So in this example...
 |  |  |  |  |  |  | [NAME] 8 times
 |  |  |  |  |  |  | Result D - Occurred 7 times
 |  |  |  |  |  |  | Result E - Occurred 6 times
 |  |  |  |  |  |  | [NAME] 6 times
 |  |  |  |  |  |  | Total: 27 (That is 67.5% ~ 70%)
 |  |  |  |  |  |  | I dont want to include Result A or Result G then it would come to 92.5%
Spreadsheet: 91060d1290734541-can-you-sumifs-until-delays
Sheet: Sheet1

Date | Shift | Delay Type | Duration |  | Date | Total Shift Delay 1 | Total Shift Delay 2 | Total Shift Delay 3 | Total Shift Delay 4 | Total Shift Delay 5
2009-07-14 00:00:00 | Night | Delay1 | 120 |  | 2009-07-14 00:00:00
 |  | Thanks in advance | 30 |  | 2009-07-15 00:00:00
 |  |  | 50 |  | 2009-07-16 00:00:00
 |  | Delay2 | 10
 |  |  | 60
 |  |  | 185
 |  | Delay3 | 10
 |  |  | 30
 |  |  | 40
 |  |  | 25
 |  |  | 60
 | Day | Delay5 | 480
 | Evening | Delay2 | 65
 |  |  | 20
 |  |  | 30
 |  |  | 40
 |  |  | 345
2009-07-15 00:00:00 | Night | Delay1 | 10
 |  |  | 15
 |  |  | 20
 |  | Delay4 | 90
 |  | Delay2 | 10
 |  |  | 270
 |  | Delay3 | 10
 |  |  | 40
 |  |  | 20
 |  |  | 10
 |  |  | 30
 | Day | Delay2 | 15
 |  |  | 150
 |  |  | 15
 |  |  | 40
 |  |  | 220
 |  | Delay5 | 40
 | Evening | Delay2 | 30
 |  |  | 20
 |  |  | 40
 |  |  | 290
 |  | Delay3 | 30
 |  |  | 15
 |  |  | 5
 |  |  | 10
 |  |  | 30
 |  |  | 35
2009-07-16 00:00:00 | Night | Delay4 | 15
 |  |  | 20
 |  |  | 10
 |  | Delay2 | 15
 |  |  | 20
 |  |  | 20
 |  |  | 320
 |  | Delay3 | 40
 |  |  | 20
 |  |  | 30
 |  |  | 30
 |  | Delay5 | 20
 | Day | Delay2 | 15
 |  |  | 25
 |  |  | 360
 |  | Delay3 | 5
 |  |  | 20
 |  |  | 35
 |  | Delay5 | 40
 | Evening | Delay2 | 10
 |  |  | 40
 |  |  | 235
 |  | Delay3 | 15
 |  |  | 180
Spreadsheet: eric_saibi__9713__010702R
Sheet: P H Robinson 04

Owner Name |  | Reliant -Houston Lighting & Power
Station Name |  | P H Robinson  Power Station
Unit Name |  | Robinson 04
NERC Region |  | ERCOT
State |  | TX
Fuel Type |  | Natural Gas
Capacity |  | 765 MW
Start Date |  | 2002-09-06 00:00:00
End Date |  | 2002-12-04 00:00:00
Prv. Start Date |  | 2002-01-04 00:00:00
Prv. End Date |  | 2002-04-03 00:00:00
Comments |  | Refurbishment
SIC |  | 4911
Plant ID |  | 1001683
Unit ID |  | 1004031
Outage ID |  | 6407