tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 796794d1663540298-average-formula-using-table-references-instead-of-ranges-with-unconventional-data-table-test-hd
Sheet: Section 1

Name | Ref | Year | Sept | March | [NAME] | March3 |  | Year | Sept | March | Average | Sept | March | Average
Name 1 | C | 2016-2017 | -0/6 | 0/0 |  |  | AVERAGE | 2016-2017
Name 2 | C | 2016-2017 | -0/1 | -0/2 |  |  | AVERAGE | 2017-2018
Name 3 | C | 2016-2017 | 2/4 | 0/11 |  |  | AVERAGE | 2018-2019
Name 4 | C | 2016-2017 | 0/9 | 1/7 |  |  | AVERAGE | 2019-2020
Name 5 | C | 2016-2017 | 1/4 | 2/3 |  |  | AVERAGE | 2020-2021
Name 6 | C | 2016-2017 | 0/2 | -0/4 |  |  | AVERAGE | 2021-2022
Name 7 | C | 2017-2018 | 1/3 | 2/4
Name 8 | C | 2017-2018 | 0/1 | 0/8 |  |  |  |  |  |  |  |  | Notation in Years and full Months (Y/M)
Name 9 | C | 2017-2018 |  | 0/6
Name 10 | C | 2017-2018 | -0/5 | 0/7
Name 11 | C | 2017-2018 | -0/7 | 0/7
Name 12 | C | 2017-2018 | 1/6 | 2/5
Name 13 | H | 2018-2019 | 0/11 | 1/7
Name 14 | H | 2018-2019 | 2/11 | 1/9
Name 15 | H | 2018-2019 | 0/10 | 2/4
Name 16 | H | 2018-2019 | 1/9 | 2/0
Name 17 | H | 2018-2019 | 0/11
Name 18 | H | 2018-2019 | 1/10 | 2/6
Name 19 | D | 2019-2020 | -0/6 | 0/8
Name 20 | D | 2019-2020 | 0/10 | 1/9
Name 21 | D | 2019-2020 | 0/10 | 1/5
Name 22 | D | 2019-2020 | 1/4 | 1/0
Name 23 | D | 2019-2020 | 0/10 | 1/8
Name 24 | D | 2019-2020 | -0/4 | 0/0
Name 25 | D | 2019-2020 | 1/3 | 2/1
Name 26 | G | 2019-2020 | 0/11 | 1/11
Name 27 | G | 2020-2021 | -0/1 | 1/4
Name 28 | G | 2020-2021 | 2/7
Name 29 | G | 2020-2021 | -0/1 | 1/1
Name 30 | G | 2020-2021 |  | 2/0
Name 31 | G | 2020-2021 | -0/4 | -0/9
Name 32 | G | 2020-2021 | 0/10 | 0/10
Name 33 | M | 2021-2022 | 0/4 | 0/11
Name 34 | M | 2021-2022 | 1/5 | 2/4
Name 35 | M | 2021-2022 | -0/2 | 0/5
Name 36 | M | 2021-2022 |  | 1/1
Name 37 | M | 2021-2022 | 1/3 | 1/6
Name 38 | M | 2021-2022 | 0/9 | 1/4
Name 39 | M | 2021-2022 | 1/6 | 2/2
Name 40 | M | 2021-2022 | 0/0 | 1/6
 |  | Average
Spreadsheet: mark_haedicke__24590__2002 Plan Budget Pack - Legal Group 021001(HCODE)
Sheet: PL Expense Analysis

 |  | 2001 |  |  |  | 2002 |  | 2002vs2001
 |  |  |  |  |  |  |  |  |  | COMMENTS
 |  |  |  | Total Gross Margin
 |  |  |  | Salaries & Wages |  |  |  |  |  | [NAME] due to reduction in Headcount (47 - 36)
 |  |  |  | Travel & Entertainment
 |  |  |  | Flights/Europe/US/Asia |  | -89820 |  |  |  | Flight detail per month: 2 Economy, 1 Business transcontinental, 5 European
 |  |  |  | Employee Meals & Ent |  |  |  |  |  | Includes Travel related expenses
 |  |  |  | Hotels |  | -40140 |  |  |  | Hotel stays in accordance with flights
 |  |  |  | Car Hire |  |  |  |  |  | Amounts for car hire (Germany)/ fuel etc & Rail Travel
 |  |  |  | Office Expenses |  |  |  |  |  | Computer expenses / Couriers / Stationary
 |  |  |  | Consultancy
 |  |  |  | Outside Services |  | -10008 |  |  |  | Translation and Management Training
 |  |  |  | Recruitment Fees |  | -49992 |  |  |  | Relates to maintaining headcount
 |  |  |  | Professional Costs |  | -9060 |  |  |  | Benefits / Benefits reselection / Tax advisory fees
 |  |  |  | Audit & Legal (tax, reg) |  |  |  |  |  | Breakdown included on separate slide
 |  |  |  | Occupancy Costs (rent & utilities)
 |  |  |  | General & Admin |  |  |  |  |  | Annual SFA Fees not budgeted in 2001
 |  |  |  | SFA Annual Fees |  | -224000
 |  |  |  | Annual Reurn Fees & Subs |  |  |  |  |  | Company annual return fees & publication subcriptions
 |  |  |  | Training |  | -51840 |  |  |  | Legal training / training courses
 |  |  |  | Mobile Phones/Land Lines |  |  |  |  |  | Fixed line telecoms / Desktops now budgeted as a direct cost
 |  |  |  | Taxes Other Than Income
 |  |  |  | TOTAL G&A
 |  |  |  | Depreciation & Amortisation
 |  |  |  | Other Expenses
 |  |  |  | TOTAL DIRECT COST
 |  |  |  | Allocations
 |  |  |  | INCOME BEFORE INTEREST & TAX
Spreadsheet: 837137d1689873880-indirect-a1-a5-and-a1-to-spill-a1-from-other-sheets-doesnt-work-how-could-i-do-it-example-2
Sheet: DBClients

N° | Name | Address | City | mail / contact | Phone
1 | MARC | XXXX | XXXX | XXXX | XXXX
2 | ALFRED | XXXX | XXXX | XXXX | XXXX
3 | PIERRE | XXXX | XXXX | XXXX | XXXX
4 | PEDRO | XXXX | XXXX | XXXX | XXXX
5 | [NAME] | XXXX | XXXX | XXXX | XXXX
6 | ADRIEN | XXXX | XXXX | XXXX | XXXX
7 | NATHALIE | XXXX | XXXX | XXXX | XXXX
8 | SHEILA | XXXX | XXXX | XXXX | XXXX
9 | HENRY | XXXX | XXXX | XXXX | XXXX
10 | [NAME] | XXXX | XXXX | XXXX | XXXX
Spreadsheet: 763227d1642065469-formula-calculation-with-multiple-conditions-sample
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | >1 | >1001 | >10001 | >50001 | >100001
 |  |  |  |  |  |  |  |  |  | <1000 | <10000 | <50000 | <100000 | <500000
 | Sr. No | Name of  Representative | Name of Donar | Date | Amount |  |  | Name of  Representative | Name of Donar | 1 to 1000 | 1001 to 10000 | 10001 to 50000 | 50001 to 100000 | 100001 to 500000
 | 1 | xyz | a | 2022-01-12 00:00:00 | 500 |  |  | xyz | a | 1000 | 0 | 0
 |  | xyz | b | 2022-01-12 00:00:00 | 1000 |  |  | xyz | b | 0 | 2000 | 0
 |  | xyz | c | 2022-01-12 00:00:00 | 2000 |  |  | xyz | c | 0 | 4000 | 0
 |  | xyz | d | 2022-01-12 00:00:00 | 10000 |  |  | xyz | d | 0 | 0 | 20000
 |  | xyz | a | 2022-01-12 00:00:00 | 500
 |  | xyz | b | 2022-01-12 00:00:00 | 1000
 |  | xyz | c | 2022-01-12 00:00:00 | 2000
 |  | xyz | d | 2022-01-12 00:00:00 | 10000
Spreadsheet: 20f3b075-21ce-4ddb-bf90-bbea394f64ab
Sheet: Sheet1

Table 3--U.S. fiber supply | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 | Nov. |  | Dec. |  | Jan. |  | Jan.
Item | 2013 |  | 2013 |  | 2014 |  | 2013
 | 1,000 480-lb. [NAME]
Cotton:
Stocks, beginning | 4169 | 2750 | 8810 |  | 10960 |  | 14039
Ginnings | 5405 |  | 3200 |  | 1012 |  | 1254
Imports since August 1 | 1.5 |  | 1.5 |  | 2.1 |  | 2.8
 | Million pounds
Manmade:
Production | 510.4 |  | 496.7 |  | 520.2 |  | 508.7
Noncellulosic | 510.4 |  | 496.7 |  | 520.2 |  | 508.7
Cellulosic
Total since January 1 | 5879.9 |  | 6376.6 |  | 520.2 |  | 508.7
 | Oct. |  | Nov. |  | Dec. |  | Dec.
 | 2013 |  | 2013 |  | 2013 |  | 2012
 | Million pounds
Raw fiber imports: | 156.4 |  | 144.9 |  |  |  | 126.8
Noncellulosic | 142.5 |  | 133.4 |  |  |  | 114.6
Cellulosic | 13.9 |  | 11.5 |  |  |  | 12.2
Total since January 1 | 1558 |  | 1702.9 |  |  |  | 1819.8
 | 1,000 pounds
Wool and mohair:
Raw wool imports, clean | 919.6 |  | 458.2 |  | 430.8 |  | 416.4
48s-and-finer | 442.1 |  | 271.4 |  | 172.1 |  | 137
Not-finer-than-46s | 477.4 |  | 186.8 |  | 258.8 |  | 279.4
Total since January 1 | 6717.5 |  | 7175.8 |  | 7606.6 |  | 9114.5
Wool top imports | 107.2 |  | 170.7 |  | 72.1 |  | 446.7
Total since January 1 | 4308 |  | 4478.7 |  | 4550.9 |  | 4544.8
Mohair imports, clean | 0 |  | 0 | 0 | 0 |  | 0
Total since January 1 | 0 |  | 0 | 0 | 0 |  | 7.2
NA = Not available.
Sources: USDA, National Agricultural Statistics Service;
U.S. Dept. of Commerce, U.S. Census Bureau; and [NAME].
Last update: 3/12/14.
Spreadsheet: 685968d1594298893-finding-data-across-multiple-sheets-excelforum__help_file
Sheet: Calc

 | CS_Jan
 | CZ_Jan
 | JA_Jan
 | ML_Jan
 | AH_Jan
 | JE_Jan | 1 | white | green | orange |  | desired result |  | 1 |  | green | blue |  | Solution here |  |  | 1.1 | 1.2 | 1.3
 |  | 2 | blue | yellow | white |  |  |  | 2 | yellow | [NAME] | red |  |  |  |  | green | orange | white
 |  | 3 | [NAME] | purple | red |  |  |  | 3 | orange | yellow | white |  |  |  |  | blue | yellow | white
 |  | 4 | orange | yellow | blue |  |  |  | 4 | purple | white | white |  |  |  |  | [NAME] | purple | red
 |  | 5 | red | white | green |  |  |  | 5 | red | blue | green |  |  |  |  | orange | yellow | blue
 |  | 6 |  |  |  |  |  |  | 6 |  |  |  |  |  |  |  | red | white | green
 |  | 7 |  |  |  |  |  |  | 7
 |  | 8 |  |  |  |  |  |  | 8
 |  | 9 |  |  |  |  |  |  | 9
 |  | 10 |  |  |  |  |  |  | 10
 |  | 11 |  |  |  |  |  |  | 11
 |  | 12 |  |  |  |  |  |  | 12
 |  | 13 |  |  |  |  |  |  | 13
 |  | 14 |  |  |  |  |  |  | 14
 |  | 15 |  |  |  |  |  |  | 15
 |  | 16 |  |  |  |  |  |  | 16
 |  | 17 |  |  |  |  |  |  | 17
 |  | 18 |  |  |  |  |  |  | 18
 |  | 19 |  |  |  |  |  |  | 19
 |  | 20 |  |  |  |  |  |  | 20
 |  | 21 |  |  |  |  |  |  | 21
 |  | 22 |  |  |  |  |  |  | 22
 |  | 23 |  |  |  |  |  |  | 23
 |  | 24 |  |  |  |  |  |  | 24
 |  | 25 |  |  |  |  |  |  | 25
 |  | 26 |  |  |  |  |  |  | 26
 |  | 27 |  |  |  |  |  |  | 27
 |  | 28 |  |  |  |  |  |  | 28
 |  | 29 |  |  |  |  |  |  | 29
 |  | 30 |  |  |  |  |  |  | 30
 |  | 31 |  |  |  |  |  |  | 31
Spreadsheet: 471414d1469003339-add-new-row-in-another-excel-sheet-asset-register
Sheet: 07 Computer

07 Computer
Asset |  |  |  | Quantity | Date | Price per Unit | Total Price in Purchased Date | Depreciation Percentage | Depreciation Expense | Total Price
Asset | Brand | Gen. | Code
Computer | Aero Cool |  | 59070650 | 1 | 2015-07-12 00:00:00 | 25740 |  | 20
Display | Samsung | S20D300NH/XT | 59070651 | 1 | 2015-07-12 00:00:00 | 3290 |  | 20
[NAME] and [NAME] | Logitech | MK200 | 59070652 | 1 | 2015-07-12 00:00:00 | 620 |  | 20
 |  |  | 59070653
Spreadsheet: michael_maggi__26462__NYMEXWEEKLY
Sheet: ho

Week Ending: | 2001-10-12 00:00:00
 | Futures Settlement Prices
 | HEATING OIL |  |  |  |  | Contract Symbol:  HO
 | Contract | Monday | Tuesday | Wednesday | Thursday | Friday | Open
 | Month | 2001-10-08 00:00:00 | 2001-10-09 00:00:00 | 2001-10-10 00:00:00 | 2001-10-11 00:00:00 | 2001-10-12 00:00:00 | Interest
 | 2001-11-01 00:00:00 | 0.6447 | 0.6468 | 0.6463 | 0.6676 | 0.6384 | 33288
 | 2001-12-01 00:00:00 | 0.656 | 0.6567 | 0.6557 | 0.6763 | 0.6476 | 38204
 | 2002-01-01 00:00:00 | 0.6625 | 0.6627 | 0.6617 | 0.6813 | 0.6536 | 23793
 | 2002-02-01 00:00:00 | 0.6595 | 0.6597 | 0.6592 | 0.6778 | 0.6516 | 14206
 | 2002-03-01 00:00:00 | 0.648 | 0.6482 | 0.6482 | 0.6648 | 0.6396 | 15215
 | 2002-04-01 00:00:00 | 0.636 | 0.6362 | 0.6362 | 0.6513 | 0.6271 | 7426
 | 2002-05-01 00:00:00 | 0.6235 | 0.6242 | 0.6242 | 0.6383 | 0.6146 | 4033
 | 2002-06-01 00:00:00 | 0.62 | 0.6207 | 0.6207 | 0.6343 | 0.6111 | 6892
 | 2002-07-01 00:00:00 | 0.6225 | 0.6232 | 0.6237 | 0.6368 | 0.6141 | 2060
 | 2002-08-01 00:00:00 | 0.6275 | 0.6282 | 0.6292 | 0.6418 | 0.6196 | 2202
 | 2002-09-01 00:00:00 | 0.634 | 0.6347 | 0.6362 | 0.6488 | 0.6266 | 1837
 | 2002-10-01 00:00:00 | 0.6405 | 0.6417 | 0.6432 | 0.6558 | 0.6336 | 1268
 | Total Weekly Volume |  | 167183 |  | Total Open Interest |  | 154416
 |  |  |  | *Weekly volume and open interest reflects all traded months.
 | Historial Volatility-Spot Month Futures
 |  |  |  | Heating Oil
 | 5 Day Hist. Vol. |  |  | 0.5131
 | 20 Day Hist. Vol. |  |  | 0.7084
 | Implied Volatility-Options |  |  | Heating Oil
 | At the Money Call & Put |  |  | 0.4578
Spreadsheet: 008f278d-8865-40a5-995e-5a9ab616130b
Sheet: Travel Ex rev 04.01.2013

STATE OF CALIFORNIA - CSUM STD 262 (REV. 04/01/13)
TRAVEL EXPENSE CLAIM |  |  |  |  |  |  |  |  |  | Page |  | of |  | Pages
CLAIMANTS NAME |  |  |  |  |  | EMPLOYEE ID # (Do Not Enter SSN) |  |  |  | CAMPUS & ADDRESS
 |  |  |  |  |  |  |  |  |  | CALIFORNIA MARITIME ACADEMY
POSITION |  |  |  |  |  | DEPARTMENT |  |  |  | 200 MARITIME ACADEMY DRIVE
 |  |  |  |  |  |  |  |  |  | VALLEJO |  |  | CA | 94590
RESIDENCE ADDRESS |  |  |  |  |  | DELIVERY OPTIONS (SELECT ONE)
 |  |  |  |  |  | MAIL CHECK |  |  |  | Phone #
 |  |  |  |  |  | ACH           ( bank info must be on file with AP )
(1) MONTH / YEAR |  | (3)  LOCATION                                         WHERE EXPENSES WERE INCURRED | (4)             LODGING | (5) MEALS (Max $55 per day) |  |  | (6) INCIDENTALS | (7) TRANSPORTATION |  |  |  |  | (8)           BUSINESS EXPENSE | (9)                                          TOTAL EXPENSES FOR DAY
 |  |  |  | BRKFAST  Actual Exp | LUNCH  Actual Exp | DINNER  Actual Exp |  | (A)                COST OF TRANS. | (B)                  TYPE USED | (C)  TOLLS PARKING | (D) PRIVATE CAR USE
(2) DATE | TIME |  |  |  |  |  | $7 / day after 24 hours of travel |  |  |  | [NAME] | AMOUNT
(10) SUBTOTAL
LESS: Amount paid by university including amount paid by procard
CLAIM TOTAL (AMOUNT DUE EMPLOYEE) |  |  |  |  |  |  |  |  |  |  | $
(11) PURPOSE OF TRIP, REMARKS, AND DETAILS (ATTACH ORIGINAL RECEIPTS/VOUCHERS-NO COPIES WHEN REQUIRED) |  |  |  |  |  |  |  |  |  |  | (12) NORMAL WORK HOURS
 |  |  |  |  |  |  |  |  |  |  | (13) PRIVATE VEHICLE LICENSE
 |  |  |  |  |  |  |  |  |  |  | (14) MILEAGE RATE CLAIMED
 |  |  |  |  |  |  |  |  |  |  | 0.565 | (If different see instructions)
Amount |  | Account | Fund | [NAME] | Class |  |  | Notes:
 |  | Total Claim (Amount Due Employee)
I HEREBY CERTIFY that the above is a true statement of the ACTUAL travel expenses incurred by me in accordance with ICSUAM Policy and Procedures, 3601.01 AND the CLAIM TOTAL amount above (Col 9)  has not been reimbursed from any other source or previously submitted for reimbursement
CLAIMANT'S SIGNATURE |  |  |  | DATE |  | DEPARTMENT CHAIR (IF APPLICABLE) |  |  |  |  |  |  |  | DATE
(16) SIGNATURE OF AUTHORIZED APPROVING OFFICIAL;  Approval indicates the Travel Claims Approving Checklist has been used to reivew and approve reimbursement of this Travel Expense Claim
SIGNATURE                                                                                                                         TITLE                                                                                                                             DATE
DETAILED receipts are required for reimbursement of any expense greater than $25
Review the CSU Travel Policy for rates allowed for foreign travel including Alaksa & Hawaii
CSU Policy prohibits the purchase of alcholic beverages with CSU operating trust funds.
Reminder:  Attach Travel Authorization form completed and approved by authorized approving official
Spreadsheet: 86936d1286892281-count-with-two-variables-test
Sheet: FILE

 | Name | Acc/Inc | PPS No | Licence No | Date Reported | Logged by | Vehicle No | Trailer No | Details | Acc File No | Reported to insurer | Cost of Accident / Incident
1 | MURPHY P | Accident | #N/A | #N/A | 2010-06-12 00:00:00 | P Mc | 08C1234 | TR57 | Paddy damaged car door reversing into Youghal waste facility | 126 | NO | 152
2 | O'GORMAN | Incident | #N/A | #N/A | 2010-10-03 00:00:00 | [NAME] | 05C904 | TR65 | DROVE OFF WITHOUT DIESEL FILL
3 | MURPHY C | Complaint | #N/A | #N/A | 2010-06-06 00:00:00 | [NAME] | 08C509 | TR219 | CIARAN BLEW HORN AT CAR ON ROUNDABOUT MALLOW
4 | MURPHY O | Accident | #N/A | #N/A |  | [NAME] |  |  | OLAN HIT REAR OF CAR IN ICE | 127 | YES
5 | BRADLEY |  | #N/A | #N/A |  | Paddy
6 | CONNORS |  | #N/A | #N/A |  | [NAME]
7 | MC CARTHY PL |  | #N/A | #N/A |  | PatMc
8 | KLOBUSYNSKI |  | #N/A | #N/A |  | PatMc
9 | O'GORMAN | Accident | #N/A | #N/A | 2010-09-17 00:00:00 | Paddy | 97C1052 |  | NIGEL HIT SIDE OF PARKED VEHICLE | 128 | YES | 4750
10 | MURPHY P | Accident | #N/A | #N/A |  | [NAME] | 01C24185 |  | PADDY KNOCKED PILLAR IN CASTLEMORE
11 | MURPHY P | Accident | #N/A | #N/A |  | [NAME] | 05C4548 |  | REVERSED INTO PARKED CAR | 129 | NO | 333
12 | O'GORMAN | Incident | #N/A | #N/A | 2010-03-10 00:00:00 | [NAME] | 05C4548 |  | NIGEL BROKE REAR AXLE
13 | KLOBUSYNSKI | Incident | #N/A | #N/A | 2010-03-23 00:00:00 | [NAME] | 08C493 |  | CLASH OF MIRRORS ON ENNISKEANE ROAD |  | NO | 70
14 | O'GORMAN | Complaint | #N/A | #N/A | 2010-10-07 00:00:00 | Paddy | 97C1052 |  | NIGEL REPORTED FOR DANGEROUS DRIVING LIMERICK TUNNEL |  | NO
15 | CHLEBOWSKI |  | #N/A | #N/A
16 | COONEY | Accident | #N/A | #N/A |  | [NAME] | 06CW2084 | TR219
17 | RYAN SEAMUS | Incident | #N/A | #N/A |  | [NAME] | 06C11094 | TR65
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
Spreadsheet: 109983d1306787952-probability-question-talent-competition-yes-votes
Sheet: Sheet1

 |  | Yes | No
 | Act 1 | 0.1 | 0.9
 | Act 2 | 0.6 | 0.4
 | Act 3 | 0.3 | 0.7
 | Act 4 | 0.01 | 0.99
 | Act 5 | 0.05 | 0.95
 | Act 6 | 0.1 | 0.9
 | Act 7 | 0.4 | 0.6
 | Yes Votes
 | 0 | 0.12798324
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7 | 3.6e-07
Spreadsheet: 455628d1460443540-plot-the-third-entry-if-0-plot-the-third-entry-if-0
Sheet: third

1 | 2010-01-01 00:00:00 | 9.383333333333333 |  |  |  |  |  | Plot the third entry if 0
2 |  | 9.4
3 |  | 9.563333333333333 | -1 |  |  |  |  | Hello Friends
4 |  | 9.536666666666667
5 |  | 9.65 |  |  |  |  |  | Please find the attached file (Plot the third entry if 0.xlsx)
6 |  | 9.7333333333333
7 |  |  |  |  |  |  |  | If in Column D `0' is present then the third value from 0 should be plotted from Column C to Column F in the corresponding row of 0.
8 |  | 9.7333333333333
9 |  | 9.633333333333333
10 |  | 9.520000000000001
11 |  | 9.543333333333333 | 0 |  | 9.57 |  |  | thanks in advance
12 |  | 9.486666666666668
13
14
15 |  | 9.5666666666667
16 |  | 9.6333333333333
17 |  | 9.629999999999999
18 |  | 9.57 | 1
19 |  | 9.666666666666666
20 |  | 9.653333333333334
21
22 |  | 9.763333333333332
23 |  | 9.756666666666666
24 |  | 9.866666666666667
25
26 |  | 1.2 | 0 |  | 1.1
27 |  | 1
28
29 |  | 1.1
30 |  | 1.1933333333333
31 |  | 1.23
32 |  | 1.2266666666667
33 |  | 1.2 | -1
34 |  | 1.2
35
36 |  | 1.1566666666667
37 |  | 1.466666666667
38 |  | 1.15
39 |  | 1.1566666666667
40 |  | 1.2666666666667
41 |  | 1.3233333333333 | 0 |  | 1.29
42
43
44 |  | 1.533333333333
45 |  | 1.2866666666667
46 |  | 1.31
47 |  | 1.333333333333 | 1
48 |  | 1.38
49
50 |  | 1.433333333333
51 |  | 1.4133333333333
52 |  | 1.466666666667
53 |  | 1.3766666666667
54 |  | 1.566666666667
55 |  | 1.48 | 0 |  | 1.66
56
57 |  | 1.4733333333333
58 |  | 1.66
59 |  | 1.53
60 |  | 1.64
61 |  | 1.7666666666667
62 |  | 1.76 | -1
63
64 |  | 1.7833333333333
65 |  | 1.7333333333333
66 |  | 1.6466666666667
67 |  | 1.4733333333333
68 |  | 1.3333333333333
69 |  | 1.39
70 |  |  | 0 |  | 1.42
71 |  | 1.56
72 |  | 1.4866666666667
73 |  | 1.4233333333333
74 |  | 1.37
75 |  | 1.29
76 |  | 1.31
77 |  |  | 1
78 |  | 1.6466666666667
79 |  | 1.6933333333333
80 |  | 1.9233333333333
81 |  | 1.9933333333333
82 |  | 1.9866666666667
83 |  | 1.9733333333333
84
85 |  | 11.12333333333333 | 0 |  | 11.27
86 |  | 11.13666666666667
87 |  | 11.27
88 |  | 11.22666666666667
89 |  | 11.14
90 |  | 11.14333333333333
91
92 |  | 11.33 | -1
93 |  | 11.39666666666667
94 |  | 11.55666666666667
95 |  | 11.54
96 |  | 11.69333333333333
97 |  | 11.75666666666667
98
99 |  | 11.76333333333333
100 |  | 11.92333333333333 | 0
Spreadsheet: 124129d1318168904-conditional-formatting-teacher-mark-book-example
Sheet: Sheet1

 |  |  |  | English
 |  |  |  | Spelling Age Standardised Score (one point roughly equals one month)
 |  | DOB | Cr Age | R | Y1 | Y2 | Y3 | Y4 | Y5 | Y6 | Average
[NAME] | Surname | 2004-02-16 00:00:00 |  |  | 114 | 83 | 109 | 107 | 105 | 99
Lauren | Surname | 2003-08-31 00:00:00 |  |  | 114 | 98 | 107 | 113 | 84 | 91
Imogen | Surname | 2003-06-28 00:00:00 |  |  | 103 | 88 | 95 | 94 | 105 | 102
Charlotte | Surname | 2003-10-09 00:00:00 |  |  | 86 | 100 | 92 | 102 | 80 | 97
Ella | Surname | 2004-02-17 00:00:00 |  |  | 99 | 89 | 104 | 101 | 94 | 80
Kobby | Surname | 2004-01-19 00:00:00 |  |  | 102 | 82 | 101 | 90 | 83 | 106
[NAME] | Surname | 2003-07-28 00:00:00 |  |  | 99 | 96 | 104 | 92 | 86 | 93
Maxim | Surname | 2003-01-30 00:00:00 |  |  | 114 | 91 | 86 | 79 | 108 | 101
Marika | Surname | 2003-03-23 00:00:00 |  |  | 94 | 96 |  | 114 | 112 | 88
[NAME] | Surname | 2003-08-18 00:00:00 |  |  | 90 | 111 | 108 | 116 | 96 | 109
[NAME] | Surname | 2003-12-16 00:00:00 |  |  | 104 | 99 | 99 | 92 | 116 | 107
Rebecca | Surname | 2004-01-01 00:00:00 |  |  | 90 | 91 | 109 | 107 | 117 | 89
Tabitha | Surname | 2003-08-09 00:00:00 |  |  | 109 | 84 | 113 | 105 | 84 | 103
Victoria | Surname | 2003-03-08 00:00:00 |  |  | 103 | 120 |  | 101 | 83 | 119
Isabelle | Surname | 2003-04-12 00:00:00 |  |  | 85 | 87 | 106 | 115 | 89 | 94
Matilda | Surname | 2003-02-25 00:00:00 |  |  | 93 | 91 | 92 | 89 | 98 | 96
Emma | Surname | 2003-07-05 00:00:00 |  |  | 118 | 91 |  | 110 | 104 | 82
[NAME] | Surname | 2003-11-16 00:00:00 |  |  | 101 | 83 |  | 103 | 106 | 108
Imogen | Surname | 2003-09-19 00:00:00 |  |  | 115 | 84 |  | 100 | 107 | 87
Emma | Surname | 2003-06-25 00:00:00 |  |  | 105 | 87 | 105 | 114 | 82 | 94
Francesca | Surname | 2003-02-23 00:00:00 |  |  | 115 | 114 | 111 |  | 106 | 86
Lily | Surname | 2003-03-14 00:00:00 |  |  | 96 | 109 | 113 | 110 | 96 | 80
Maxwell | Surname | 2003-04-22 00:00:00 |  |  | 101 | 113 | 104 | 103 | 88 | 98
Year Average
 |  | Problem 1 | Each pupil gets a score every year.
 |  |  | I want to highlight their score green if it is 10 greater than, or red if it is 10 less than, their own average.
 |  |  | I can do that on each line at a time but it takes forever.
 |  |  | How do I do it for the first pupil then copy the formatting for every other one?
 |  |  | (In the cells above I've copied the formatting for '10 less' than average, but it all references the first pupil's average (in L4)
 |  |  | How can I ensure that blank cells remain unformatted until they have data entered (I don’t want them to turn red just because they have no data yet)?
 |  |  | See Conditional Formatting rules for This Worksheet
 |  | Preblem 2 | How do I create a 'Chronological Age' for each pupil based on date of birth so that it stays constantly up to date?
 |  |  | See formula in column D
 |  | Preblem 3 | I'd like a visual representation of each child's data (line chart) but I want each chart to use the same range on the vertical axis (i.e. from 60 - 140), not give a 'best fit' based on the individual's range of scores. Can this be done?
 |  |  | See Charts tab
Spreadsheet: daren_farmer__5868__EnronAvails0600revised
Sheet: Sid Richardson Plant

TO: | [NAME] |  | Effective Date |  |  | PHONE: | (713) 853-9272
 | ENRON NORTH AMERICA |  | 2000-06-01 00:00:00 |  |  | FAX: | (713) 646-2391
 |  |  |  |  |  | E-MAIL: | [EMAIL]
FROM: | JAN SVAJIAN |  |  |  |  | PHONE: | (405) 552-8163
 | DEVON ENERGY CORPORATION |  |  |  |  | FAX: | (405) 552-4664
 |  |  |  |  |  | E-MAIL: | [EMAIL]
 |  |  | VOLUME |  | DBQ |  | DBQ |  | EXCESS
 | CDP NAME & METER NUMBER |  | AVAILABLE |  | % |  | AVAILABLE |  | AMOUNT
 | [NAME] (90289) |  | 933.25 |  | 0.75
 | [NAME] Sat #3 (K-332) |  | 104 |  | 0.75
 | Baird WE 1312 (K-351) |  | 91 |  | 0.75
 | KCC 359 Battery ([NAME]) |  | 87.75 |  | 0.75
 | SKEU 108 Battery |  | 7032.130559999999 |  | 0.75
 | State Walton #5 (90337) |  | 365.625 |  | 0.75
 | Baird #1257 (90339) |  | 406.25 |  | 0.75
 | Baird #1875 (90329) |  | 195 |  | 0.75
 | Baird #1954 (90327) |  | 357.5 |  | 0.75
 | Baird #1955 (90328) |  | 403 |  | 0.75
 | H.E. Lovett #2 (90348) |  | 282.75 |  | 0.75
 | State Walton #1 (90336) |  | 362.5947 |  | 0.75
 | Baird #1382 (90338) |  | 380.25 |  | 0.75
 | [NAME] (90341) |  | 520 |  | 0.75
 | [NAME] (90340) |  | 745.46875 |  | 0.75
 | [NAME] (90342) |  | 150.6037975 |  | 0.75
 | Baird #1381 (90353 |  | 325 |  | 0.75
 | SKEU Bass Operated Holt Unit |  | 1025 |  | 0.75
 | KEYSTONE PLANT TAILGATE MMBTU/D