tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 754711d1636460182-how-to-type-a-word-and-fill-some-cells-with-numeric-values-associated-myexample-2
Sheet: Plan1

TYPE THE WORD BELOW: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LETTERS | VALUE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A | 1
D | A | Y |  |  |  |  |  |  |  |  |  |  |  |  |  | J | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | K | 2
2021 | 2022 | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | 2031 | 2032 | 2033 | 2034 |  |  | T | 2
D | D | D | D | A | Y | Y | Y | Y | Y | Y | Y | D | D |  |  | C | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | L | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | U | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | V | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | W | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | F | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | G | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Y | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Z | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R | 9
Spreadsheet: 39382d1237542940-finding-sequences-and-highlighting-them-in-different-ways-example-43
Sheet: Sheet1

highlight seq. ascending numbers
1
2
3
7603
7609
7608
7609
7610
7611
1
2
7608
7603
7604
7608
1
1
7
8
9
7
2111
2112
7
3
2
1
Spreadsheet: 08309c3a-e586-405e-bb2d-a80c26a2801e
Sheet: 5Replace Costs-Results 6-10

Table 5.2.44.  Replacement Costs (Years 6 to 10)
 |  |  |  | EPA Discount Rate:
 |  |  |  | Present Value of Replacement Costs in Year:
Component | Unit Cost | Unit | Quantity | 6 | 7 | 8 | 9 | 10
 |  |  | Total Present Value of Replacement Costs (Years 6 to 10):
Spreadsheet: 694486d1599642836-how-to-count-repeating-purchase-from-different-year-testrpt
Sheet: Repeat 2018

No | Name
1
2
3
4
5
6
7
8
9
10
Spreadsheet: 00743850-9960-4c9c-9131-b3eeb795dda4
Sheet: Sheet1

GOTS | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Associate of Applied Science Degree
Name |  |  | Student ID Number |  |  |  | Date Entered:
Address |  |  | Phone: |  |  |  | Proposed Graduation Date:
 |  |  | [NAME]:
 |  |  | Student Signature: |  |  |  | Date:
 |  |  | Advisor Signature: |  |  |  | Date:
 |  |  | Authorizing Signature: |  |  |  | Date:
Remedial Courses As Needed |  |  |  | Recommended          Courses | [NAME] | Please observe electronic notes at red triangles
010 RDG + 12 DRE - Intro. To College Reading
020 RDG + 101 GE - Improved College Reading
030 RDG + 101 GE  (if not already completed)
090 ENC - Foundations of College Writing I
091 ENC - Foundations of College Writing II
055 MT - Pre-Algebra
065 MT - Basic Algebra with Measurements
120 MT - Intermediate Algebra
General Education Courses (Core Curriculum) |  |  |  |  | Credit Hours | Recommended Courses | [NAME] | Semester Recommended
101 ENG Writing I |  |  |  |  | 3
Computer Literacy |  |  |  |  | 3
Social Interaction Course |  |  |  |  | 3
Heritage/Humanities Course |  |  |  |  | 3
MAT 150 College Algebra or min MT105 |  |  |  |  | 3
Science Course |  |  |  |  | 3
Technical Core: |  |  |  |  | Credit Hours | Recommended Courses | [NAME] | Semester Recommended
Total Hours in Program |  |  |  |  | >45
A
B
C
D
E
P
F
I
Spreadsheet: 822858d1679572453-sum-from-drop-down-live-nics-clinics
Sheet: WC 27.03.2023

 | Service | Weekly Allocation | Remaining
 | Accute Illness Clinic | 25 |  | < Weekly Accute Clinic allocation minus Hot Clinic and Cold Clinic
 | First Contact Physio | 2 |  | <- Sum of all week [NAME] |  | Hot Clinic | Cold Clinic
 |  |  |  | - | Sum of all week Hot clinic (service = Hot Clinic-> |  |  | <- sum of all week cold clinic (Service = Cold Clinic)
 | Phlebotomy | 4 |  | <-Sum of all week Phlebotomy
 | Spiro and FeNO | n/a | n/a |  |  | WC 27.03.23
 | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday
 | Service | PT Reference | Service | PT Reference | Service | PT Reference | Service | PT Reference | Service | PT Reference
 | Hot Clinic | 123456
 | Physio | 7890 |  |  | Hot Clinic | 11111 |  |  | Physio | fghj
 |  |  |  |  |  |  | Cold Clinic | 222
 |  |  |  |  | Cold Clinic | 1
 | Phlebotomy | vbn | Phlebotomy | vbn
 |  |  | Phlebotomy | vbn
 |  |  | Phlebotomy | vbn
 |  |  | Phlebotomy | vbn
Spreadsheet: 877047d1723725648-automatic-time-scheduler-student-scheduler
Sheet: Input

 | Length of Lesson (Minutes) | Preference 1 | Preference 2 | Preference 3 | Preference 4 | Preference 5 | Group Together | Separate Days? |  | Preference 1 Start (as [NAME] | Preference 1 End (as [NAME] | Preference 2 Start (as [NAME] | Preference 2 End (as [NAME] | Preference 3 Start (as [NAME] | Preference 3 End (as [NAME] | Preference 4 Start (as [NAME] | Preference 4 End (as [NAME] | Preference 5 Start (as [NAME] | Preference 5 End (as [NAME]
Children
Child 1 | 45 | Monday 3:00
Child 2 | 60 | Tuesday 4:15 | Monday 3:00
Child 3 | 30 | Wednesday 5:00 |  |  |  |  | 1
Child 4 | 45 | Thursday 6:15 |  |  |  |  | 1
Child 5 | 60 | Thursday 7:15 | Wednesday 5:00 | Monday 3:00
Child 6 | 30 | Monday 3:00
Child 7 | 15
Child 8 | 45 | Monday 3:45 |  |  |  |  | 2
Child 9 | 30 |  |  |  |  |  | 2
Child 10 | 60
Spreadsheet: 668810d1585065362-identifying-when-a-value-in-a-column-stops-rising-excel-rising-hollacost69-
Sheet: Sheet1

0.8801 | 0.8864
0.8843 | 0.8933
0.8894 | 0.8922
0.8853 | 0.888
0.8857 | 0.8869
0.8827 | 0.8851
0.8838 | 0.8954
0.8948 | 0.9021
0.8918 | 0.8921
0.8851 | 0.8873
0.8743 | 0.8782
0.873 | 0.8737
0.8724 | 0.877
0.8756 | 0.8814
0.8702 | 0.8731
0.8632 | 0.8684
0.8649 | 0.8723
0.8699 | 0.8743
0.8696 | 0.8718
0.8683 | 0.8759
0.867 | 0.8721
0.8035 | 0.8072
0.7994 | 0.8051
0.8043 | 0.8067
0.7993 | 0.8041
0.8035 | 0.807
0.8068 | 0.8162
0.8093 | 0.8126
0.8091 | 0.8117
0.8032 | 0.8111
0.8099 | 0.819
0.8134 | 0.8197
0.8126 | 0.814
0.8047 | 0.8057
0.7967 | 0.8031
0.7854 | 0.7901
0.7831 | 0.7893
0.7879 | 0.7913
0.7858 | 0.7929
0.7697 | 0.7733
0.7709 | 0.7762
0.7131 | 0.7158
0.7109 | 0.7127
0.7025 | 0.7037
0.6958 | 0.6973
0.6929 | 0.6963
0.6907 | 0.6961
0.6919 | 0.6964
0.6929 | 0.6939
0.6891 | 0.6977
0.6809 | 0.6842
0.682 | 0.6889
0.6811 | 0.6881
0.6858 | 0.6973
0.6971 | 0.699
0.6934 | 0.6953
0.6903 | 0.7
0.6977 | 0.7015
0.6994 | 0.7063
0.7044 | 0.7053
0.7029 | 0.7085
Spreadsheet: 266006d1379462370-drop-down-menu-when-selected-auto-populates-another-cell-with-linked-data-order-form-test
Sheet: Order Form

 |  |  |  |  |  |  |  |  |  | ORDER FORM
 |  |  |  |  | Vendor: |  |  |  |  |  |  |  |  |  |  |  |  | Order Date:
 |  |  |  |  | Season: |  | Summer |  |  |  |  |  |  |  |  |  |  | Ship Date:
 |  |  |  |  | Salesman: |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]:
Contact: |  |  |  |  | Phone: |  |  |  |  |  |  |  |  |  |  | Customer PO #:
Name: |  |  |  |  | Fax: |  |  |  |  | [NAME]: |  |  |  |  |  | PO #:
 |  | Mailing address |  |  |  |  |  |  |  |  |  |  |  |  |  | Shipping address
Business Name: |  |  |  |  |  |  |  |  |  | Business Name:
Address: |  |  | City: |  |  |  |  |  |  | Address: |  |  |  |  |  |  | City:
State: |  |  | Zip Code: |  |  |  |  |  |  | State: |  |  |  |  |  |  | Zip Code:
Special Instructions:
MPN: | Pair: | Case Qty: | 5 | 5.5 | 6 | 6.5 | 7 | 7.5 | 8 | 8.5 | 9 | 9.5 | 10 | 10.5 | 11 | 12 | 13 | 14 | Unit Price: | Total Price:
aabb |  |  |  |  | 1 |  |  |  | 2
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A
[NAME] |  |  |  |  |  | 1 | 1 | 1 | 1
N/A
N/A
N/A
N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total:
Spreadsheet: 91982d1291666572-formula-for-changing-cells-values-without-using-vba-sim_lab
Sheet: Ark1

Stop Week | 2 | Capacity | Week | 999
 |  | 999 | 1
Stop Span | 3 |  | 2
 |  |  | 3
 |  | 999 | 4
 |  | 999 | 5
 |  | 999 | 6
 |  | 999 | 7
 |  | 999
 |  | 999
Spreadsheet: 847525d1698406881-how-to-convert-a-set-of-utc-dates-times-into-gmt-bst-time-zones-2
Sheet: UTC Conversion

Date/Time UTC | Date/Time London | Required Result for Date/Time London
2023-03-25 01:00:00 |  | 25/03/2023 01:00:00
2023-03-26 01:00:00 |  | 26/03/2023 02:00:00
2023-03-27 01:00:00 |  | 27/03/2023 02:00:00
2023-10-28 01:00:00 |  | 28/10/2023 02:00:00
2023-10-29 01:00:00 |  | 29/10/2023 [NAME]
2023-10-30 01:00:00 |  | 29/10/2023 [NAME]
Spreadsheet: e3d3db0b-39d2-44ee-ad65-dfacebca88af
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
Breast primaries | EVL | SYNE1 | PTPRD |  | Sample # | Sex | ER | PR | Her2 | [NAME] | Grade
1-bc004a |  |  |  |  | [NAME] | F | Unk | Unk | Unk | Stage 0 (DCIS) | 0
2-bc005a |  |  |  |  | BC005a | F | Unk | Unk | Unk | Stage 0 (DCIS) | 0
3-bc006a |  |  |  |  | BC006a | F | Unk | Unk | Unk | Stage 0 (DCIS) | 0
4-bc013a |  |  |  |  | BC013a | F | 90 | 60 | Unk | Stage 0 (DCIS) | 0
5-bc017a |  |  |  |  | BC017a | F | 90 | 40 | Unk | Stage 0 (DCIS) | 0
6-bc018a |  |  |  |  | BC018a | F | 0 | 10 | Unk | Stage 0 (DCIS) | 0
7-bc023a |  |  |  |  | BC023a | F | 0 | 0 | Neg | Stage 1 | 1
8-bc024a |  |  |  |  | [NAME] | F | 80 | 80 | Neg | Stage 1 | 1
9-bc025a |  |  |  |  | BC025a | F | 90 | 50 | Neg | Stage 1 | 2
10-bc026a |  |  |  |  | BC026a | F | 80 | 80 | Pos | Stage 1 | 2
11-bc027a |  |  |  |  | BC027a | F | 95 | 10 | Neg | Stage 1 | 2
12-bc028a |  |  |  |  | BC028a | F | 80 | 90 | Neg | Stage 1 | 1
13-bc039a |  |  |  |  | BC039a | F | 80 | 50 | Neg | Stage 2 | 3
14-bc040a |  |  |  |  | BC040a | F | Neg | Neg | Neg | Stage 2 | 1
15-bc041a |  |  |  |  | BC041a | F | Neg | Neg | Neg | Stage 2
16-bc042a |  |  |  |  | BC042a | F | 70 | 20 | Pos | Stage 2 | 3
17-bc043a |  |  |  |  | BC043a | F | 50 | 80 | Neg | Stage 2 | 3
18-bc044a |  |  |  |  | BC044a | F | 60 | 80 | Neg | Stage 2 | 3
19-bc051a |  |  |  |  | BC051a | F | 90 | 50 | Pos | Stage 3 | 3
20-bc052a |  |  |  |  | BC052a | F | 95 | 100 | Neg | Stage 3 | 2
21-bc053a |  |  |  |  | BC053a | F | 80 | 100 | Neg | Stage 3 | 3
22-bc054a |  |  |  |  | BC054a | F | 100 | Neg | Neg | Stage 3 | 3
23-bc055a |  |  |  |  | BC055a | F | 90 | 90 | Neg | Stage 3 | 2
24-bc056a |  |  |  |  | BC056a | F | 90 | 5 | Neg | Stage 3 | 2
25-bc057a |  |  |  |  | BC057a | F | 70 | 50 | Neg | Stage 4 | 2
26-bc058a |  |  |  |  | [NAME] | F | Neg | Neg | Neg | Stage 4 | 3
27-bc059a |  |  |  |  | BC059a | F | 50 | Neg | Pos | Stage 4 | 3
28-bc060a |  |  |  |  | BC060a | F | 95 | 10 | Pos | Stage 4 | 3
29-bc061a |  |  |  |  | [NAME] | F | Neg | Neg | Pos | Stage 4 | 3
30-bc062a |  |  |  |  | [NAME] | F | Neg | Neg | Neg | Stage 4 | 3
Red = methylated
Green = unmethylated
Spreadsheet: kimberly_watson__20552__imbalsumm0108
Sheet: Duke

Duke Energy Field Services
Contract  24268
2001-07-31 00:00:00 |  | 1162786.04
2001-08-11 00:00:00
60874 | 1871
78169
500235
500248
500251
500254
500255 |  |  |  | 4840.73
500262 |  |  |  | 67.24
500267
Duke Energy Trading and Marketing
Contract  24693
2001-07-31 00:00:00 |  | 275313.72
2001-08-11 00:00:00
9164
9167
Duke Energy Trading and Marketing
Contract  24361 |  |  |  | CBS Volume | 24268 | 24693 | 24361
 |  |  |  |  | 223026 | 117857 | 138810
2001-07-31 00:00:00 |  | 732710.21
2001-08-11 00:00:00 |  |  |  |  |  |  | 21665 | 36403
500241 |  |  |  |  |  |  | 22664 | 18932
500391 | 2857 |  |  |  |  |  | 20248 | 43064
500392 | 551 |  |  |  |  |  | 25873 | -17
 |  |  |  |  |  |  | 26758 | -149
 |  |  |  |  |  |  | 26372 | 1467
 |  |  |  |  |  |  | 26700 | 1970
 |  |  |  |  |  |  | 26422 | 3940
 |  |  |  |  |  |  | 26661 | 28550
 |  |  |  |  |  |  | 27291 | -3361
Duke Energy Trading and Marketing |  |  |  |  |  |  | 27137 | -8
21665 | oba | 73449.16 | POI 9109 Mobil Waha Plant |  |  |  | 27123 | -1347
22664 | oba | 23612.35 | POI 59918 Grand Valley Plant
20248 | trans | 141061.91
25873 |  | -259
26758 |  | -596
26372 |  | 2997.09
26700 |  | 4077.9
26422 |  | 8155.8
26661 |  | 146862.35
27291 |  | -17965
27137 |  | -67.28
27123 |  | -6425.19
Spreadsheet: 864671d1711753822-question-on-date-range-based-cell-populating-food-safety-walk
Sheet: Starbucks

 |  |  |  |  | Department: | Starbucks
 |  |  |  |  | Walk Date:
 |  |  |  |  | Auditor:
 |  |  |  |  | Auditor Role:
Market Guard
Question 1: | What is the Market Guard Completion for the Previous Day?
Question 2: | What is the MTD Completion for the Store?
General |  |  |  |  |  |  | Results
1 | Are there any products with missing labels? If so, note quantity. |  |  |  |  |  | F
 | Notes:
2 | Are there any products with incomplete labels? If so, note quantity. |  |  |  |  |  | F
 | Notes:
3 | Are there any expired items? |  |  |  |  |  | F
 | Notes:
4 | Are items stored in the cooler/freezer according to the storage hierarchy? |  |  |  |  |  | F
 | Notes:
5 | Is there any evidence of food/drink usage in the department? |  |  |  |  |  | P
 | Notes:
Cleaning |  |  |  |  |  |  | Results
6 | Do the customer facing displays have aged food debris? |  |  |  |  |  | P
 | Notes:
7 | Are the display door tracks clean? |  |  |  |  |  | P
 | Notes:
8 | Are the hand washing sinks blocked? |  |  |  |  |  | F
 | Notes:
9 | Is there any evidence of the hand washing sinks being used for anything other than hand washing? |  |  |  |  |  | P
 | Notes:
10 | Are the appliance control panels and handles clean? |  |  |  |  |  | P
 | Notes:
11 | Are the cooler/freezer door handles clean? |  |  |  |  |  | P
 | Notes:
12 | Are the hood grates clean? |  |  |  |  |  | F
 | Notes:
13 | Are the walls clean of built up food splatter? |  |  |  |  |  | P
 | Notes:
14 | Are the floors around coolers/equipment clean? |  |  |  |  |  | F
 | Notes:
Supplies/Chemicals |  |  |  |  |  |  | Results
15 | Are there any unauthorized chemicals? |  |  |  |  |  | P
 | Notes:
16 | Are the chemicals mixed correctly?  IE, too dark or light? |  |  |  |  |  | P
 | Notes:
17 | Are the sanitizer strips expired? |  |  |  |  |  | F
 | Notes:
18 | Is the paper towel dispenser stocked and functional at each hand washing sink? |  |  |  |  |  | F
 | Notes:
19 | Are gloves stocked and easily accessible? |  |  |  |  |  | F
 | Notes:
Misc Notes
Spreadsheet: 696970d1601055177-if-vlookup-with-clusters-if-vlookup_updated
Sheet: Sheet1

Alphabet id | Alphabet | Desired Output
445593 | TEST_102559 | Y
445430 | TEST_102559 | Y
278544 | TEST_104994 | Y
278472 | TEST_104994 | Y
258939 | TEST_108069 | Y
258941 | TEST_108069 | Y
444942 | TEST_11417 | Y
444950 | TEST_11417 | Y
513548 | TEST_11679 | X
513548 | TEST_11679 | X
513548 | TEST_11679 | X
513548 | TEST_11679 | X
513548 | TEST_11679 | X
513548 | TEST_11679 | X
513548 | TEST_11679 | X
513548 | TEST_11679 | X
449558 | TEST_11779 | Y
449449 | TEST_11779 | Y
283163 | TEST_118461 | Y
281913 | TEST_118860 | Y
281866 | TEST_118860 | Y
290367 | TEST_123155 | Y
513545 | TEST_125471 | Y
513559 | TEST_125471 | Y
513626 | TEST_125471 | Y
100 | TEST_125472 | Y
101 | TEST_125472 | Y
100 | TEST_125472 | Y
100 | TEST_125472 | Y
Spreadsheet: 51250d1250782138-points-formatting-book1
Sheet: Sheet2

Position | Pts
1 | 400
2 | 340
3 | 310
4 | 290
5 | 270
6 | 250
7 | 230
8 | 210
9 | 190
10 | 170
11 | 150
12 | 130
13 | 110
14 | 90
15 | 80
16 | 70
17 | 60
18 | 50
19 | 40
20 | 30
21 | 20
22 | 10
Spreadsheet: 845851d1697183978-conditional-formating-sample-data
Sheet: Sheet1

 |  | Difference |  |  | Comments
 |  | F/F | Q/Q |  | F/F
Seller1 |  | 450000 | -600000
Seller2 |  | 200000 | 500000
Seller3 |  | -700000 | -500000
Seller4 |  | 200000 | 700000
Seller5 |  | -100000 | 500000
Seller6 |  | 300000 | -200000
Seller7 |  | 440000 | 800000
Seller8 |  | -340000 | -550000
Seller9 |  | 650000 | 450000
Seller10 |  | 980000 | -550000
Spreadsheet: 5238e739-75be-48ee-b640-b27dc7684bf4
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
 | 5302.0 Balance of Payments and International Investment Position, Australia
 | TABLE 83. EXCHANGE RATES - FINANCIAL YEAR
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
United States Dollar ;  Period average ; |  |  | Original | A3604466X | 1960-06-01 00:00:00 | 2013-06-01 00:00:00 | 54 | $ | INDEX | Annual | 6
United Kingdom Pound ;  Period average ; |  |  | Original | A3604465W | 1960-06-01 00:00:00 | 2013-06-01 00:00:00 | 54 | $ | INDEX | Annual | 6
Euro ;  Period average ; |  |  | Original | A3604467A | 1960-06-01 00:00:00 | 2013-06-01 00:00:00 | 54 | $ | INDEX | Annual | 6
[NAME] ;  Period average ; |  |  | Original | A3604463T | 1960-06-01 00:00:00 | 2013-06-01 00:00:00 | 54 | $ | INDEX | Annual | 6
Special Drawing Rights ;  Period average ; |  |  | Original | A3604468C | 1960-06-01 00:00:00 | 2013-06-01 00:00:00 | 54 | $ | INDEX | Annual | 6
United States Dollar ;  End of period ; |  |  | Original | A3605367K | 1960-06-01 00:00:00 | 2013-06-01 00:00:00 | 54 | $ | INDEX | Annual | 6
United Kingdom Pound ;  End of period ; |  |  | Original | A3605364C | 1960-06-01 00:00:00 | 2013-06-01 00:00:00 | 54 | $ | INDEX | Annual | 6
Euro ;  End of period ; |  |  | Original | A3605363A | 1960-06-01 00:00:00 | 2013-06-01 00:00:00 | 54 | $ | INDEX | Annual | 6
[NAME] ;  End of period ; |  |  | Original | A3605365F | 1960-06-01 00:00:00 | 2013-06-01 00:00:00 | 54 | $ | INDEX | Annual | 6
Special Drawing Rights ;  End of period ; |  |  | Original | A3605368L | 1960-06-01 00:00:00 | 2013-06-01 00:00:00 | 54 | $ | INDEX | Annual | 6
Trade Weighted Index ;  Period average ; |  |  | Original | A3604464V | 1960-06-01 00:00:00 | 2013-06-01 00:00:00 | 54 | Index Numbers | INDEX | Annual | 6
Trade Weighted Index ;  End of period ; |  |  | Original | A3605366J | 1960-06-01 00:00:00 | 2013-06-01 00:00:00 | 54 | Index Numbers | INDEX | Annual | 6
© Commonwealth of Australia  2014
Spreadsheet: 793781d1661710871-choose-a-formula-from-a-cell-and-calculate-it-sample-file
Sheet: Taksee

Estado | Coche | Descripción | Fecha | [NAME] | Destino | Pasajero | Km | Importe | Reserva | Id Servicio | Semana | Driver | A [NAME]
Spreadsheet: john_zufferli__16717__HedgeSummary
Sheet: Sheet1

 | CONFIDENTIAL:  PPA - POWER AND GAS POSITIONS:
 |  |  |  |  |  |  |  |  | Current to | Hedgeable | Current |  | AECO
 |  |  |  |  | Power Price | Aeco Gas Price | Heat Rate | Jan 11/2001 | Beg. Year | Volume | Gas Hedges |  | Hedge
 |  | Power (MWh) | Discount Days | Power (MW) | ($/MWh) | ($[NAME]) | (GJ/MWh) | Heat Rates | HR Delta | (cont/day) | (cont/day) | % Hedged | (cont/day)
2002-01-01 00:00:00 | Cal 2002 |  |  |  |  |  |  | 14.25
2003-01-01 00:00:00 | Cal 2003 |  |  |  |  |  |  | 12.03
2004-01-01 00:00:00 | Cal 2004 |  |  |  |  |  |  | 8.9
2005-01-01 00:00:00 | Cal 2005 |  |  |  |  |  |  | 9.06
2006-01-01 00:00:00 | Cal 2006 |  |  |  |  |  |  | 7.5
2007-01-01 00:00:00 | Cal 2007 |  |  |  |  |  |  | 7.02
2008-01-01 00:00:00 | Cal 2008 |  |  |  |  |  |  | 7.09
2009-01-01 00:00:00 | Cal 2009 |  |  |  |  |  |  | 7.1
2010-01-01 00:00:00 | Cal 2010 |  |  |  |  |  |  | 7.14
2011-01-01 00:00:00 | Cal 2011 |  |  |  |  |  |  | 7.11
2012-01-01 00:00:00 | Cal 2012 |  |  |  |  |  |  | 7.08
2013-01-01 00:00:00 | Cal 2013 |  |  |  |  |  |  | 7.04
2014-01-01 00:00:00 | Cal 2014 |  |  |  |  |  |  | 7.03
2015-01-01 00:00:00 | Cal 2015 |  |  |  |  |  |  | 7
2016-01-01 00:00:00 | Cal 2016 |  |  |  |  |  |  | 7
2017-01-01 00:00:00 | Cal 2017 |  |  |  |  |  |  | 7
2018-01-01 00:00:00 | Cal 2018 |  |  |  |  |  |  | 7
2019-01-01 00:00:00 | Cal 2019 |  |  |  |  |  |  | 7
2020-01-01 00:00:00 | Cal 2020 |  |  |  |  |  |  | 7
 | Total
 | Note: Power position is 710MW * Availability factor (of 81-87%) - 9% transmission losses - hedges
Spreadsheet: 63956d1264798697-lookup-and-produce-a-subset-without-arrays-excelobjectivestatement-and-example
Sheet: Sheet1

Objective:  By selecting Group in Output Table, bring over the desired services that are billable in that PG
 | with each in its own row.  No error codes appearing on empty rows.
 | Service & Rate Table |  |  |  |  |  |  |  |  |  |  | Dropdown for Groups
 |  |  |  |  |  |  |  |  |  |  |  | Group1
 |  | Service is billable in: |  |  |  |  |  |  |  |  |  | Group2
 | Name | Group1 | Group2 | Group3 | Group4 | Rate | Unit |  |  |  |  | Group3
 | Service 1 | 1 | 1 |  |  | 10 | 15 |  |  |  |  | Group4
 | Service 2 |  | 1 | 1 |  | 20 | 15
 | Service 3 | 1 |  | 1 | 1 | 30 | 20
 | Output Table |  |  |  |  |  | Example of Output Table with Group = Group3 Red signifies input data from Service & Rate Table
 | Select Group=> | Group1 |  |  |  |  | Select Group=> | Group3
 | Service Name | Rate | Unit | Total |  |  | Service Name | Rate | Unit | Total
 |  |  |  |  |  |  | Service 2 | 20 | 15 | 300
 |  |  |  |  |  |  | Service 3 | 30 | 20 | 600
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  | 0 |  |  |  |  |  | 900
Spreadsheet: 60786d1261369049-cell-change-based-on-two-drop-down-menus-reading-8
Sheet: Set-up

[NAME] Washington
[NAME]
[NAME]
Alisia Amaya
[NAME]
[NAME] |  |  | [NAME] | [EMAIL]
[NAME]
Angelica Arrendondo
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Celeste [NAME]
[NAME]
Cleveland Moorehead
[NAME]
Crystal Barcenas
[NAME]
Dayanna [NAME]
[NAME]
Desiree Molina
Destiny [NAME]
[NAME]
Eduardo Granados
[NAME]
Emily Long
[NAME]
[NAME]
Ezekial Flores
[NAME]
[NAME]
[NAME]
Guadalupe Lopez
[NAME]
[NAME]
Hung Vu
[NAME]
[NAME]
[NAME]
[NAME]
Izak Madrid
[NAME]
[NAME]
[NAME]
Jasenia Gonzales
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Libertad Ruiz
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Mariah Katayama
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Niomi House
[NAME]
Paulina Valdez
Priscilla Peralta
[NAME]
[NAME]
Ratino Sherrod
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Ruby Flores
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Tiffani Jameson
[NAME]
[NAME]
[NAME]
Troy Campbell
[NAME]
[NAME]
[NAME]
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0