tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 94035d1293820348-getting-the-monthly-sums-back-to-the-monthly-wss-sums-back-to-the-monthly-wss
Sheet: MARCH

 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PRESENCES | ABSENCES COUNTED AS PRESENCE |  |  |  |  |  | TOTAL
 | Name | Entry date | Leaving date | 2010-03-01 00:00:00 | 2010-03-02 00:00:00 | 2010-03-03 00:00:00 | 2010-03-04 00:00:00 | 2010-03-05 00:00:00 | 2010-03-06 00:00:00 | 2010-03-07 00:00:00 | 2010-03-08 00:00:00 | 2010-03-09 00:00:00 | 2010-03-10 00:00:00 | 2010-03-11 00:00:00 | 2010-03-12 00:00:00 | 2010-03-13 00:00:00 | 2010-03-14 00:00:00 | 2010-03-15 00:00:00 | 2010-03-16 00:00:00 | 2010-03-17 00:00:00 | 2010-03-18 00:00:00 | 2010-03-19 00:00:00 | 2010-03-20 00:00:00 | 2010-03-21 00:00:00 | 2010-03-22 00:00:00 | 2010-03-23 00:00:00 | 2010-03-24 00:00:00 | 2010-03-25 00:00:00 | 2010-03-26 00:00:00 | 2010-03-27 00:00:00 | 2010-03-28 00:00:00 | 2010-03-29 00:00:00 | 2010-03-30 00:00:00 | 2010-03-31 00:00:00 |  | W | V | C | H | F | R
1 | P1 | 2009-10-31 00:00:00 |  | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | W | W | W
2 | P2 | 2009-06-16 00:00:00 | 2010-10-12 00:00:00 |  |  | V | V | V | V | V | V |  |  | U | U | U | U | U | U | U | U | U | U | U | U | U | U | U | U | U | U | U | U | U
3 | P3 | 2008-11-24 00:00:00 |  |  |  |  |  |  | W | W |  |  |  |  |  | W |  |  |  |  |  |  | W | W |  |  | W | W | W | W
4 | P4 | 2009-06-05 00:00:00 |  |  |  |  |  |  |  | W |  |  |  |  |  | W |  |  |  |  |  |  | W | W |  |  |  |  |  | W
5 | P5 | 2007-05-12 00:00:00 | 2010-11-04 00:00:00 |  |  |  |  |  |  | W |  |  |  |  |  | W | W |  |  |  |  |  | W | W |  |  | C | C | C | C | C | C | C | C
6 | P6 | 2006-01-18 00:00:00 | 2010-03-03 00:00:00
7 | P7 | 2009-03-23 00:00:00 | 2010-03-03 00:00:00
8 | P8 | 2009-05-19 00:00:00 | 2010-04-20 00:00:00 |  |  |  |  |  | W | W |  |  |  |  |  |  |  |  |  |  |  |  |  | W |  |  |  |  | W | W | W | W | W
9 | P9 | 2010-03-03 00:00:00
10 | P10 | 2010-03-03 00:00:00 |  |  |  |  |  |  | W | W |  |  |  |  |  | W |  |  |  |  |  |  | W | W
11 | P11 | 2010-04-22 00:00:00
12 | P12 | 2010-10-22 00:00:00
13 | P13 | 2010-11-23 00:00:00
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
 | F: [NAME], V: Vacances, C: Clinique, U: Fugue, R: Réintégration |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0
Spreadsheet: 216492d1361789823-equation-help-for-military-database-height-and-weight
Sheet: Male Weight Chart

[NAME]
Height in | Age | Age | Age | Age
Inches | 17 - 20 | 21 - 27 | 28 - 39 | 40 +
58
59
60 | 132 | 136 | 139 | 141
61 | 136 | 140 | 144 | 146
62 | 141 | 144 | 148 | 150
63 | 145 | 149 | 153 | 155
64 | 150 | 154 | 158 | 160
65 | 155 | 159 | 163 | 165
66 | 160 | 163 | 168 | 170
67 | 165 | 169 | 174 | 178
68 | 170 | 174 | 179 | 181
69 | 175 | 179 | 184 | 186
70 | 180 | 185 | 189 | 192
71 | 185 | 189 | 194 | 197
72 | 190 | 195 | 200 | 203
73 | 195 | 200 | 205 | 208
74 | 201 | 206 | 211 | 214
75 | 206 | 212 | 217 | 220
76 | 212 | 217 | 223 | 226
77 | 218 | 223 | 229 | 232
78 | 223 | 229 | 235 | 238
79 | 229 | 235 | 241 | 244
80 | 234 | 240 | 247 | 250
Spreadsheet: 197619d1354491321-return-all-matching-rows-of-a-table-based-on-dropdown-cell-book1
Sheet: Sheet1

Inventory ID | Product | Cost Price | Sale Price | Quantity Available | Date Ordered
20122 | A | 200 | 400 | 10 | 2012-01-19 00:00:00
20129 | B | 150 | 300 | 10 | 2012-01-20 00:00:00
20001 | A | 130 | 370 | 25 | 2011-09-14 00:00:00
20111 | A | 100 | 350 | 5 | 2011-09-01 00:00:00
22991 | C | 5 | 50 | 100 | 2012-11-25 00:00:00
22992 | C | 7 | 70 | 50 | 2012-11-29 00:00:00
29321 | B | 140 | 300 | 10 | 2011-09-29 00:00:00
Spreadsheet: 874114d1720680475-if-formula-not-making-data-blank-when-it-is-acrossley1-test-data-14-aligw
Sheet: Sheet1

 |  | 2024-07-01 00:00:00 | 2024-07-02 00:00:00 | 2024-07-03 00:00:00 | 2024-07-04 00:00:00 | 2024-07-05 00:00:00 | 2024-07-06 00:00:00 | 2024-07-07 00:00:00
 | orange | 1 | 2 |  | 1 | 2 |  | 4
 | pear |  | 5 | 5 |  | 3 | 4 | 4
 | banana | 4 | 5
 | apple |  | 1 | 7 | 6 | 5 | 4 | 4
Spreadsheet: 107457d1304619358-team-rank-without-skipping-numbers-mock-rank-by-team
Sheet: Sheet1

Team Scores
Name | Team # | Score | Team Score | Team Rank
Player A | 1 | 55 |  | 3
Player B | 2 | 48 |  | 1
Player C | 1 | 18 |  | 3
Player D |  | 25
Player E | 2 | 44 |  | 1
Player F | 1 | 38 |  | 3
Player G |  | 60
Player H | 2 | 49 |  | 1
Player I |  | 41
Player J | 3 | 29 |  | 2
Player K | 3 | 33 |  | 2
Player L |  | 34
Player M | 3 | 50 |  | 2
 |  |  |  | ^desired output result typed in
 |  |  |  | ^Need equations to automatically calculate team scores
 |  |  |  | ^Ties are ranked as same number
 |  |  |  | ^No rank numbers are skipped
Spreadsheet: 472613d1469663567-sumproduct-or-sum-if-date-range-copy-of-rma_data-3-
Sheet: Summary

Product Code | Brand | Jan-Mar | Apr-Jun |  |  |  |  |  |  |  | 2016-01-01 00:00:00 | 2016-03-31 00:00:00 | 2016-04-01 00:00:00 | 31/06/2016
[NAME]
BB012
BNCSPP
BNCSPS
BNCSS
BNCTP
Spreadsheet: 793182d1661350528-creating-a-results-list-of-multiple-races-finn-resultaten-2022
Sheet: 8 mei

 |  | Place | 1e wedstrijd | 2e wedstrijd | 3e wedstrijd | 4e wedstrijd |  |  | Place | sailnumber | points | points overall | count
 |  | 1 | 151 | 13 | 151 | 151 |  |  | 1 |  | 6 | 14
 |  | 2 | 220 | 1015 | 131 | 63 |  |  | 2 | 220 | 15 | 13
 |  | 3 | 63 | 151 | 220 | 1015 |  |  | 3 | 1015 | 22 | 12
 |  | 4 | 113 | 220 | 931 | 13 |  |  | 4 | 13 | 24 | 11
 |  | 5 | 199 | 113 | 250 | 931 |  |  | 5 | 931 | 24 | 10
 |  | 6 | 131 | 199 | 1015 | 220 |  |  | 6 | 63 | 25 | 9
 |  | 7 | 931 | 250 | 13 | 199 |  |  | 7 | 131 | 29 | 8
 |  | 8 | 49 | 931 | 63 | 145 |  |  | 8 | 199 | 29 | 7
 |  | 9 | 145 | 131 | 49 | 250 |  |  | 9 | 113 | 33 | 6
 |  | 10 | 56 | 145 | 113 | 56 |  |  | 10 | 250 | 34 | 5
 |  | 11 | 1015 | 49 | 199 | 197 |  |  | 11 | 145 | 39 | 4
 |  | 12 | 13 | 63 | 145 | 131 |  |  | 12 | 49 | 41 | 3
 |  | 13 | 250 | 56 | 56 | 49 |  |  | 13 | 56 | 46 | 2
 |  | 14 | 197 | 197 | 197 | 113 |  |  | 14 | 197 | 53 | 1
 |  | 15 |  |  |  |  |  |  |  | 0 | 340
 |  | 16
 |  | 17
 |  | 18
 |  | 19
Spreadsheet: d938348e-a32f-45a6-90ab-dd8c88bbb814
Sheet: Sheet1

Date | Sport | Opponent | Time | Results
09/26/2014 | Women's Tennis | Pink Invitational (Mountaineer Tennis Courts) | 09:00 AM | Results
09/27/2014 | Women's Tennis | Pink Invitational (Mountaineer Tennis Courts) | 09:00 AM | Results
09/28/2014 | Women's Tennis | Pink Invitational (Mountaineer Tennis Courts) | 09:00 AM | Results
10/03/2014 | Women's Tennis | at Akron Invite | 09:00 AM | Results
10/04/2014 | Women's Tennis | at Akron Invite | 09:00 AM | Results
10/05/2014 | Women's Tennis | at Akron Invite | 09:00 AM | Results
10/10/2014 | Women's Tennis | at Georgia State Invite | 10:00 AM | Results
10/11/2014 | Women's Tennis | at Georgia State Invite | 03:00 PM | Results
10/12/2014 | Women's Tennis | at Georgia State Invite | 10:00 AM | Results
10/24/2014 | Women's Tennis | Big Easy Tennis Classic (New Orleans, La.) | 08:00 AM
10/25/2014 | Women's Tennis | Big Easy Tennis Classic (New Orleans, La.) | 08:00 AM
10/31/2014 | Women's Tennis | [NAME] (Ridgeview [NAME]) | 09:00 AM
11/01/2014 | Women's Tennis | [NAME] (Ridgeview [NAME]) | 09:00 AM
11/02/2014 | Women's Tennis | [NAME] (Ridgeview [NAME]) | 09:00 AM
Spreadsheet: 701180d1603587621-using-powerquery-to-import-data-from-a-website-to-an-excel-spreadsheet-unfinishedpq-problem
Sheet: Sheet1

Path |  |  | Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10 | Column11 | Column12
AAON |  |  | Index | - | P/E | 46.97 | EPS (ttm) | 1.32 | Insider Own | 0.195 | Shs Outstand | 52.10M | Perf Week | -1.93%
 |  |  | Market [NAME] | 3.20B | Forward P/E | 50.70 | EPS next Y | 1.22 | Insider Trans | -0.0192 | [NAME] | 40.85M | Perf Month | 7.88%
 |  |  | Income | 69.50M | PEG | 3.91 | EPS next Q | 0.34 | Inst Own | 0.723 | Short Float | 9.71% | Perf Quarter | 6.80%
 |  |  | Sales | 499.20M | P/S | 6.41 | EPS this Y | 27.00% | Inst Trans | 0.0006 | Short Ratio | 21.09 | Perf Half Y | 28.74%
 |  |  | Book/sh | 6.19 | P/B | 9.99 | EPS next Y | -11.66% | ROA | 0.179 | Target Price | 35.00 | Perf Year | 29.99%
 |  |  | Cash/sh | - | P/C | - | EPS next 5Y | 12.00% | ROE | 0.232 | 52W Range | 40.48 - 65.69 | Perf YTD | 25.20%
 |  |  | Dividend | 0.38 | P/FCF | 51.12 | EPS past 5Y | 5.10% | ROI | 0.181 | 52W High | -5.83% | Beta | 0.63
 |  |  | Dividend % | 0.61% | [NAME] | 1.80 | Sales past 5Y | 5.70% | Gross Margin | 0.29 | 52W Low | 52.81% | ATR | 1.50
 |  |  | Employees | 2290 | Current Ratio | 2.90 | Sales Q/Q | 5.20% | Oper. Margin | 0.172 | RSI (14) | 54.45 | Volatility | 2.01% 2.32%
 |  |  | Optionable | Yes | Debt/Eq | 0.02 | EPS Q/Q | 32.90% | Profit Margin | 0.139 | Rel Volume | 0.47 | Prev Close | 61.23
 |  |  | Shortable | Yes | LT Debt/Eq | 0.02 | Earnings | Aug 06 AMC | Payout | 0.262 | [NAME] | 188.09K | Price | 61.86
 |  |  | Recom | 3.50 | SMA20 | 0.09% | SMA50 | 4.42% | SMA200 | 0.1407 | Volume | 87,809 | Change | 1.03%
Spreadsheet: 222524d1363875892-names-of-failure-students-to-be-automatically-shown-in-the-list-of-failures-marks-and-list-of-failures_2
Sheet: List of Failures

List of Failures
SN | Student's Name | Student No. | Mark | Grade
 |  |  |  |  |  |  | Student 14 | 13157 | 55 | F
 |  |  |  |  |  |  | Student 15 | 13158 | 0 | F
 |  |  |  |  |  |  | Student 16 | 13159 | 45 | F
 |  |  |  |  |  |  | Student 20 | 13163 | 53 | F
 |  |  |  |  |  |  | Student 22 | 13165 | 0 | F
 |  |  |  |  |  |  | Student 24 | 13167 | 50 | F
 |  |  |  |  |  |  | Student 26 | 13169 | 58 | F
 |  |  |  |  |  |  | Student 33 | 13176 | 58 | F
 |  |  |  |  |  |  | Student 34 | 13177 | 55 | F
 |  |  |  |  |  |  | Student 36 | 13179 | 53 | F
 |  |  |  |  |  |  | Student 40 | 13183 | 33 | F
Spreadsheet: 105781d1303068946-dependent-list-problem-dependent-list
Sheet: Sheet3

Drop 1 | Drop 2
Yellow & Orange Fruit | choice 3 | "=INDIRECT(VLOOKUP(A2,NameLookup,2,0))"
FruitList
Red Fruit | RedFruit
Yellow & Orange Fruit | YOFruit
Green Fruit | GreenFruit
RedFruit | YOFruit | GreenFruit
choice 1 | choice 3 | choice 4
choice 2 | choice 4 | choice 5
Spreadsheet: 698583d1602066990-formula-for-unique-numbers-example-7-
Sheet: Sheet1

name | marks
A | 12
A | 13
A | 0
A | 0
B | 20
B | 0
B | 0
B | 5
C | 0
C | 0
C | 0
C | 15
Count |  | Result
 | Conditions | It sould not count zero's and count only unique name from column A.. If A is repeating it should count only one time
Spreadsheet: caa981e6-6892-4aa7-ac0d-594af4e90a7d
Sheet: FACULTY INFORMATION FORM

Please use capital letters & no punctuation | EXAMPLE | class 1 info | class 2 info | class 3 info | class 4 info | class 5 info | class 6 info
Last Name | LOGAN
First Name | SARAH
MI | M
Printed Course Prefix (e.g. [NAME]) and Number | PSY3303
Printed Date/Time (e.g. MW 08:00 AM, TR 12:30 PM or MWF 18:00 PM) | TR 18:00 PM
Bubbled in Meeting Days (MTWRFSN) NO [NAME] or Spaces | TR
In the Classroom = Face  OR  Online Course = Online | Face
Eight Week Course = Y (yes) or N (no).    If YES… 1 for first eight weeks or 2 for second eight weeks | Y-2
For On-line courses ONLY - Print course title. In addition, please provide a class roster with [NAME] "username@angelo .edu" with your FIF.  Dropped students can be withdrawn later. | Learning  and Cognition
Objectives:  (Scale - M = Minor or No Importance,  I = Important,                              E = Essential) | M, I, E | M, I, E | M, I, E | M, I, E | M, I, E | M, I, E | M, I, E
1.  Gaining factual knowledge (terminology, classifications, methods,       trends) | E
2.  Learning fundamental principles, generalizations, or theories | E
3.  Learning to apply course material (to improve thinking, problem       solving,  and decisions) | E
4.  Developing specific skills, competencies, and points of view needed       by professionals in the field most closely related to this course | I
5.  Acquiring skills in working with others as a member of a team | I
6.  Developing creative capacities (writing, inventing, designing,       performing in art, music, drama, etc.) | M
7.  Gaining a broader understanding and appreciation of       intellectual/cultural activity (music, science, literature, etc.) | M
8.  Developing skill in expressing oneself orally or in writing | M
9.  Learning how to find and use resources for answering questions or       solving problems | M
10.  Developing a clearer understanding of, and commitment to, personal         values | M
11.  Learning to analyze and critically evaluate ideas, arguments,         and points of view | M
12.  Acquiring an interest in learning more by asking questions and         seeking answers | M
[NAME] (e.g. CS) | PSY | CS | CS | CS | CS | CS | CS
Discipline codes:  CS = 1100                                                (4 digits) | 4200 | 1100 | 1100 | 1100 | 1100 | 1100 | 1100
[NAME] (e.g. 800, 1230, or 1800) | 800
Bubbled Course Number                                                 (4 digits) | 3303
Enrollment | 23
Local Code for CS1301, 1341, 1351, 1361, & 1371 = 0200   Honors = 0201                                                              (4 digits)
Long (L) or Short (S) Forms | L
Number of Additional Questions to be answered on the Survey  ([NAME]. number of Additional questions that can be asked for Long form = 19 & Short form = 10) | 12
Is this class [NAME]?   Y or N | N
Spreadsheet: 270297d1381432547-can-offset-function-be-used-on-condition-offset-from-below
Sheet: Sheet2

 | Least 10 Performers
# | Login ID | Name | Final Score
1 | 7199 | Lydia Osei-Amoako | 94.44444444444444
2 | 7192 | [NAME] | 94.42028985507247
3 | 7200 | [NAME] | 94.42028985507247
4 | 7209 | [NAME] | 93.86473429951691
5 | 7255 | [NAME] | 92.86666666666667
6 | 7062 | Yvonne welbeck | 89.69806763285024
7 | 7214 | [NAME] | 88.75
8 | 7225 | [NAME] [NAME] | 79.72222222222223
9 | 7109 | [NAME] | 53.30917874396135
10 | 7238 | Patience Atanga | 15
Spreadsheet: 90061d1289822386-2nd-best-selling-product-using-sumproduct-753254_theproblem
Sheet: Sheet1

Product | Sales
Dogs | 12
Cats | 15 |  |  |  | Product | Top Sale
Mice | 20 |  |  |  | Dogs
Elephants | 21 |  |  |  | Cats
[NAME] | 22 |  |  |  | Mice
Cats | 5 |  |  |  | Elephants
[NAME] | 8 |  |  |  | [NAME]
Mice | 10
Dogs | 30 |  |  |  | 2nd Best Sale Overall
Elephants | 24
Dogs | 19
Spreadsheet: eric_saibi__9951__110601R
Sheet: Broadway 03

Owner Name |  | Pasadena Water and Power Department
Station Name |  | Broadway Glenarm Power Station
Unit Name |  | Broadway 03
NERC Region |  | WSCC
State |  | CA
Fuel Type |  | Natural Gas / Fuel Oil
Capacity |  | 75 MW
Start Date |  | 2001-11-02 00:00:00
End Date |  | 2002-03-01 00:00:00
Prv. Start Date |  | 2001-11-05 00:00:00
Prv. End Date |  | 2002-03-04 00:00:00
Comments |  | Steam Turbine Overhaul
SIC |  | 4911
Plant ID |  | 1014529
Unit ID |  | 1005372
Outage ID |  | 12388
Spreadsheet: 719546d1613723746-how-to-combine-two-index-and-match-functions-properly-double_lookup
Sheet: Feuil1

 |  |  |  |  |  |  | 2021-01-28 00:00:00 | 2021-01-29 00:00:00 | 2021-01-30 00:00:00 | 2021-01-31 00:00:00 | 2021-02-01 00:00:00 | 2021-02-02 00:00:00 | 2021-02-03 00:00:00 | 2021-02-04 00:00:00 | 2021-02-05 00:00:00 | 2021-02-06 00:00:00
2021-01-28 00:00:00 |  | A | 9.8 |  |  | A
 |  | B | 9.3 |  |  | B
 |  | C | 9.8 |  |  | C
 |  | D | 11.6 |  |  | D
 |  | E | 40.5 |  |  | E
 |  | F | 8.5 |  |  | F
 |  | G | 7.4 |  |  | G
 |  | H | 42.8 |  |  | H
 |  | I | 10.4 |  |  | I
 |  | J | 25.6 |  |  | J
 |  | K | 6 |  |  | K
 |  | L | 7.4 |  |  | L
 |  | M | 8.1 |  |  | M
 |  | N | 5.9 |  |  | N
 |  | O | 8.8 |  |  | O
 |  | P | 12.7 |  |  | P
 |  | Q | - |  |  | Q
 |  | R | - |  |  | R
 |  | S | - |  |  | S
 |  | T | - |  |  | T
 |  | U | - |  |  | U
 |  | V | - |  |  | V
 |  | W | - |  |  | W
 |  | X | - |  |  | X
 |  | Y | - |  |  | Y
 |  | Z | - |  |  | Z
 |  | AB | - |  |  | AB
2021-01-29 00:00:00 |  | A | 2.3
 |  | B | 2.8
 |  | C | 3.1
 |  | D | 6.8
 |  | E | 38.6
 |  | F | 1.9
 |  | G | -
 |  | H | 36
 |  | I | 4
 |  | J | 25.2
 |  | K | -
 |  | L | -
 |  | M | -
 |  | N | -
 |  | O | -
 |  | P | 3.5
 |  | Q | -
 |  | R | 7.3
 |  | S | 8.4
 |  | T | 2.3
 |  | U | 0.6
 |  | V | 1
 |  | W | 1.6
 |  | X | 15.5
 |  | Y | 3.5
 |  | Z | 4.8
 |  | AB | -
2021-01-30 00:00:00 |  | A | 3.7
 |  | B | 3.3
 |  | C | 5340531519.1
 |  | D | 4.6
 |  | E | 60.4
 |  | F | 1.7
 |  | G | -
 |  | H | 32.2
 |  | I | 3.6
 |  | J | 20
 |  | K | -
 |  | L | -
 |  | M | -
 |  | N | -
 |  | O | -
 |  | P | 5.4
 |  | Q | -
 |  | R | -
 |  | S | -
 |  | T | -
 |  | U | -
 |  | V | -
 |  | W | -
 |  | X | -
 |  | Y | -
 |  | Z | -
 |  | AB | -
Spreadsheet: 1b09c658-948a-4184-a432-a3c62bd9d0a4
Sheet: 7d

 | Swap Dealers/MSPs5 |  | Others
Product1 | Cleared2 | Uncleared | Cleared | Uncleared
Fixed-Float | 220312883 | 94292182 | 25517025 | 46537757
FRA | 88656915 | 13471827 | 5257845 | 2636019
OIS | 53588257 | 14726400 | 8212617 | 5977177
OTHER* | 12023969 | 67776428 | 884121 | 21537609
TOTAL | 374582024 | 190266837 | 39871608 | 76688562
*OTHER variable includes the following products: Basis, Swaption, Cap/Floor, Debt Option, Exotic, Fixed-Fixed, and Inflation.
Spreadsheet: jeffrey_a_shankman__13783__CA rate exposure 8-26 JT
Sheet: Legacy

LEGACY CUSTOMERS (DA as of 9/17 - switched back and forth)
PG&E | Utility Undercollection |  |  |  | Bonds |  |  |  | Above Market Contract Cost
 | Scenario | 1 | 2 | 3 |  | 1 | 2 | 3 |  | 1 | 2 | 3
 | % Collected | 0.8 | 0.8 | 0.8 | % Collected | 1 | 0.5 | 0 | % Collected | 1 | 0.5 | 0
 | Probability | 0.95 | 0.95 | 0.95 | Probability | 0.3 | 0.3 | 0.3 | Probability | 0.3 | 0.3 | 0.3
Amortization (years)
5
7
10
12
15
Edison | Utility Undercollection |  |  |  | Bonds |  |  |  | Above Market Contract Cost
 | Scenario | 1 | 2 | 3 |  | 1 | 2 | 3 |  | 1 | 2 | 3
 | % Collected | 0.8 | 0.8 | 0.8 | % Collected | 1 | 0.5 | 0 | % Collected | 1 | 0.5 | 0
 | Probability | 0.95 | 0.95 | 0.95 | Probability | 0.3 | 0.3 | 0.3 | Probability | 0.3 | 0.3 | 0.3
Amortization (years)
5
7
10
12
15
SDG&E | Utility Undercollection |  |  |  | Bonds |  |  |  | Above Market Contract Cost
 | Scenario | 1 | 2 | 3 |  | 1 | 2 | 3 |  | 1 | 2 | 3
 | % Collected | 0.8 | 0.8 | 0.8 | % Collected | 1 | 0.5 | 0 | % Collected | 1 | 0.5 | 0
 | Probability | 0.95 | 0.95 | 0.95 | Probability | 0.3 | 0.3 | 0.3 | Probability | 0.3 | 0.3 | 0.3
Amortization (years)
5
7
10
12
15
Spreadsheet: 145930d1331818926-best-way-to-display-data-via-a-macro-in-excel-2010-register
Sheet: Register Matrix

Register No: | 67462
Week Day | 3
 | Date & Start Time | 2012-02-01 14:00:00 | 2012-02-08 14:00:00 | 2012-02-15 14:00:00 | 2012-02-22 14:00:00 | 2012-02-29 14:00:00
 |  | 27 | 28 | 29 | 30 | 40 | 41 | 42 | 43 | 44 | 45 | 46 |  | Present | Absent | % todate
Student No | StuName
10004817/3 | THOMSON, CLAIRE | A | P | A | P | P |  |  |  |  |  |  |  |  |  | 60
055703/4 | [NAME], ELEANOR SHELAGH | P | P | P | P | P
045131/7 | GRAHAM, DAWN LOUISE | P | A | P | A | A
11007337/1 | BAXTER, [NAME] | A | A | A | A | A
082718/2 | HOLMES, NAOMI | A | A | A | A | A
10002135/2 | DICKINS, CLAIRE LOUISE | P | P | P | P | P
11000261/1 | ALLAN, VICKY LOUISE | P | P | P | P | P
10013592/3 | DANIELS, ELEANOR | P | P | P | P | P
10001380/1 | MATHESON, CAROLE ANN | A | P | A | P | P
09002690/2 | LEONCE, DEBORAH LOUISE | P | A | P | A | A
014639/7 | HOPE, [NAME] | P | A | P | A | A
10003309/2 | LAZDANE-VITOLA, [NAME] | P | P | P | P | P
10003814/2 | DUGUID, LAUREN MARIE | P | A | P | A | A
10004771/2 | COULL, CLAIRE | A | P | A | P | P
10004229/2 | PUSCAS, SILVIU PAUL | P | P | P | P | P
10004230/2 | PUSCAS, IOANA MARIA | P | A | P | A | A
09007050/2 | JIA, LING | A | P | A | P | P
065261/4 | MACDONALD, CAROL ANN | P | A | P | A | A
10000450/1 | BOAG, GILLIAN WENDY | P | P | P | P | P
10004329/3 | GEDDES, DIANE HELEN | P | P | P | P | P
Spreadsheet: 213201d1360371773-making-sections-of-a-large-worksheet-appear-dynamically-in-other-worksheets-dynamicsnapshot
Sheet: Sheet1

A | 1
B | 2
C | 3
D | 4
E | 5
F | 6
G | 7
H | 8
I | 9
J | 10
K | 11
L | 12
M | 13
N | 14
O | 15
P | 16
Q | 17
R | 18
S | 19
 |  | << add data to column A and B, then check contents of the snapshot on Sheet2
Spreadsheet: louise_kitchen__24119__North America Plan 12-27
Sheet: Fin Ops

 | Financial Operations
 | 2002 Plan
 |  |  |  |  |  |  |  |  | Reporting, GL, Trading & Transaction Support |  |  |  |  | Cash Operations
 |  | 2001-09-01 00:00:00 |  | 2001 | 2002 |  | % of |  |  | Per HC | New HC | Adj Comp |  |  | Per HC | New HC | Adj Comp |  |  |  | 2002
 |  | YTD Actual |  | Forecast | Plan |  | Total Exp |  |  |  |  |  |  |  |  |  |  |  |  |  | Plan
ENACOMP | Compensation
 | Special Pays | 0 |  |  | 0 |  |  |  | Compensation | 0 |  |  |  | Compensation | 0
 | Analyst & Assoicate | 0
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  | 1.2
ENAEMPEX | Employee Expense |  |  |  |  |  |  |  | Other |  |  |  |  | Other
ENAT&EEX | Travel & Entertainment Expense
ENAOUTSV | Outside Services | 0 |  |  | 700000 |  |  |  | Total |  |  |  |  | Total
ENASUPP | Supplies Expense
ENAMKTEX | Marketing
ENACONTR | Charitable Contributions |  |  |  |  |  |  |  | [NAME] |  | 0 |  |  | [NAME] |  | 1
ENARENT | Rent |  |  |  |  |  |  |  | Admins |  | 4 |  |  | Admins |  | 1
ENATECH | Technology |  |  |  |  |  |  |  | Staff | 49200 | 2 |  |  | Staff | 49200 | 1
ENATRANS | Transportation |  |  |  |  |  |  |  | Analysts | 57600 | 2 |  |  | Analysts | 57600 | 0
ENAOTHEX | Other Expenses |  |  |  |  |  |  |  | Specialist | 62400 | 7 |  |  | Specialist | 62400 | 0
ENATAXES | Taxes Other than Income |  |  |  |  |  |  |  | Sr Specialist | 74400 | 11 |  |  | Sr Specialist | 74400 | 0
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  |  | Managers | 90000 | 9 |  |  | Managers | 90000 | 2
 |  |  |  |  |  |  |  |  | Directors | 120000 | 4 |  |  | Directors | 120000 | 1
 | Headcount |  |  | 99 |  |  |  |  | Sr Director | 174000 | 1 |  |  | Sr Director | 174000 | 1
 |  |  |  |  |  |  |  |  | Vice President | 216000 | 4 |  |  | Vice President | 216000
 | A&A Headcount |  |  | 4 | 2 |  |  |  | [NAME] | 312000 | 1 |  |  | [NAME] | 312000
 | Total Headcount |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  | Benefits & Taxes |  |  | 0.2 |  | Benefits & Taxes |  |  | 0.2
ENAOUTLG | Outside Legal
ENAOUTTX | Outside Tax
ENAINSUR | Insurance
ENASYSDV | System Development |  |  |  |  |  |  |  | Other Expense Calculation
ENACORIT | Controllable Infrastructure |  |  |  |  |  |  |  | Reporting, GL, Trading & Transaction Support
ENACORRN | Corporate Rent |  |  |  |  |  |  |  | Total Misc Exp |  | Old HC | Exp/Old HC | New HC | Exp/New HC
ENAOTHAL | Other Allocated Direct  Expenses |  |  |  |  |  |  |  |  |  |  |  | 46 |  | This was adjusted up 600,000
ENADEPR | Depreciation & Amortization |  |  |  |  |  |  |  |  |  |  |  |  |  | for Audit fees during the year.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | It was also adjusted 704,684
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | to get to a total of 7,000,000
 |  |  |  |  |  |  |  |  | Cash Operations |  |  |  |  |  | for the BA&R group.
 |  |  |  |  |  |  |  |  | Total Misc Exp |  | Old HC | Exp/Old HC | New HC | Exp/New HC
 |  |  |  |  |  |  |  |  |  |  | 103 |  | 7 |  | This was adjusted up 360,000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | for consulting fees during the year.
Spreadsheet: 692367d1598294672-rank-top-sales-person-from-order-list-sample-sales
Sheet: Sheet1

Order No | [NAME] | Units Sold |  |  | Rankings | [NAME] | Total Units Sold
1 | [NAME] | 5 |  |  | 1 | [NAME] | 51
2 | [NAME] | 30 |  |  | 2 | [NAME] | 46
3 | Sara | 2 |  |  | 3 | Sara | 37
4 | [NAME] | 6
5 | [NAME] | 8
6 | [NAME] | 23
7 | Sara | 34
8 | Sara | 1
9 | [NAME] | 16
10 | [NAME] | 9
11 | [NAME] | 5
12 | Janice | 16