tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 2a2c0d9d-a3cd-4a29-a655-c0ee3fc1a9cf
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 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
 |  |  |  |  |  |  |  |  | 2004 | 2005 | 2006 | 2007 | 2008 | 2009
 |  |  |  |  |  |  |  | African-American | 0.3396 | 0.3043 | 0.3376 | 0.2582 | 0.2772 | 0.2845
 |  |  |  |  |  |  |  | Asian-American | 0.046 | 0.0626 | 0.0696 | 0.0685 | 0.0552 | 0.0613
 |  |  |  |  |  |  |  | Blank or Declined to State | 0.1651 | 0.1909 | 0.1926 | 0.284 | 0.2173 | 0.1537
 |  |  |  |  |  |  |  | Caucasian/White | 0.3231 | 0.3033 | 0.2633 | 0.2512 | 0.2799 | 0.323
 |  |  |  |  |  |  |  | Latino/a/Hispanic | 0.0991 | 0.1018 | 0.0998 | 0.0943 | 0.1188 | 0.1217
 |  |  |  |  |  |  |  | Native American/Pacific Islander | 0.0083 | 0.0085 | 0.0139 | 0.0109 | 0.0184 | 0.0156
 |  |  |  |  |  |  |  | Other | 0.0189 | 0.0286 | 0.0232 | 0.0328 | 0.0331 | 0.0403
Spreadsheet: 0801d9c5-6cfd-40f4-a039-899624a8e556
Sheet: AlwinMui_Data

 |  |  |  |  |  | Total Carbon (mg) |  |  |  |  |  |  |  | [NAME] (mg) |  |  |  |  |  |  |  | PIC
PIC Cell Quotas |  | Strain | Concentrations | mls filtered | # Cells | Sample 1 | Sample 2 | Sample 3 | Average | per cell | Total C (pg/cell) | [NAME] | Standard Error (%) | Sample 1 | Sample 2 | Sample 3 | Average | per cell | Org C (pg/cell) | [NAME] | Standard Error (%) | PIC (mg) | PIC/cell (mg/cell) | PIC/cell (pg/cell) | PIC/cell (% error) | PIC/cell (ng/cell) sd
 | 2013-11-04 00:00:00 | 374 | 526000 | 5 |  | 0.03889582 | 0.04174638 | 0.03940262 |  |  |  |  |  | 0.03881373 | 0.04307961 | 0.04446823
Performed by Alwin Mui/Frank Natale | 2013-11-04 00:00:00 | 624 | 400000 | 5 |  | 0.06851538 | 0.06012932 | 0.06264658 |  |  |  |  |  | 0.03958323 | 0.03514444 | 0.03195399
Fall 2013 |  |  | From Flow
PIC by differnece method | Under 24hr light Conditions
 | 2013-10-16 00:00:00 | 374 | 492000 | 5 |  | 0.02863195 | 0.03179439 | 0.02869838 |  |  |  |  |  | 0.03198126 | 0.03325538 | 0.03347907
Corresponds to EhV infections run | 2013-10-16 00:00:00 | 624 | 650000 | 5 |  | 0.05748027 | 0.06098461 | 0.05690406 |  |  |  |  |  | 0.03582262 | 0.0343039 | 0.02995955
with EhV1 and EhV86 on these |  |  | There are two cell counts for 624 on 10/16 (for trying to reach the optimal cell concentration for infection) but I used the one that was within the concentration range for infection (5E5 to 1E6)
hosts |  |  | 624 1:3 | 650000
 |  |  | 624 1:4 | 163000
Spreadsheet: 0e5c2b16-405f-4ff6-b1e5-89498bffcd8e
Sheet: 2014-2015

2015-2016 Class Schedule |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | You may select up to three classroom attributes.  Select only course requirements, as the number of available classrooms will be reduced with each attribute selected.
Communication Studies
Fall 2015
Subject | Course and Title | Subtitle/Alternate Title | Days | Times | Sec | Part of Term | Credits | Hamline Plan | Instructor(s) | Instructor ID | FT or Adj | [NAME] | Registration Approval Required? | [NAME] | Seats to be Saved | Saved Seats Type | Campus: [NAME], [NAME], Online, Blended |  |  |  | Cross list? SUBJ CRSE SEC | XLST total enrl | Areas of Study | Comments
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Classroom Attribute A | Classroom Attribute B | Classroom Attribute C
Spreadsheet: 159632d1338791224-excel-2010-not-displaying-correct-formula-result-cic-members-test
Sheet: Membership Dashboard

Membership Report
Report Date:
Current Members
 | Regular Members:
 |  | New Members in 2012
 |  | Pending Members
 |  | Renewed Members
 |  | Reinstated Members
 | Student Members:
 |  | New Members in 2012
 |  | Pending Members
 |  | Renewed Members
 |  | Reinstated Members
 | Special Members:
 | Current Members:
Expired Members:
 | Regular:
 | Student:
Inactive Members:
 | Regular:
 | Student:
Sub-Total:
Group Members: |  |  |  | 1089
Total Audience:
Spreadsheet: 706717d1606849108-totalling-consolidating-data-sumproduct-with-mult-and-add-glewis14-
Sheet: Product Level

 |  |  |  |  |  |  |  |  |  | E4US references | 6
 |  |  |  |  |  |  |  |  |  | Week references | 46 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  | Stock (pcs) |  |  | SAFETY STOCK |  |  |  |  | 8 | 9
Material ID | New code | Material Description | Factory | Supplier | In transit | MIN | MAX | Comments | E4us | combined stock
68138572 | 68190271 | Big pack current | 60562 | 135988 | 69260 | 5 | 13 |  | Demand |  | 39181 | 26121 | 65302 | 0 | 26121 | 26121 | 0 | 32816 | 0 | 26121 | 0 | 26121 | 0 | 26121 | 15510 | 21113 | 21271 | 21233 | 24479 | 37907 | 42113 | 21466 | 21466 | 21415 | 21284
 |  |  |  |  |  |  |  |  | Production |  | 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
 |  |  |  |  |  |  |  |  | Closing stock
 |  |  |  |  |  |  |  |  | Fwd Cover
68138552 |  | Small pack new | 191841 | 874929 | 67573 | 0 | 0 |  | Demand |  | 0 | 199504 | 0 | 26602 | 332506 | 13301 | 0 | 0 | 26602 | 26602 | 13301 | 13301 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | Production |  | 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
 |  |  |  |  |  |  |  |  | Closing stock
 |  |  |  |  |  |  |  |  | Fwd Cover
68190271 |  | Big pack new | 35099 | 50993 | 0 | 0 | 0 |  | Demand |  | 0 | 0 | 13126 | 26252 | 0 | 0 | 0 | 0 | 0 | 26252 | 0 | 0 | 0 | 0 | 0 | 1662 | 18132 | 5201 | 9308 | 4761 | 4443 | 5683 | 8454 | 5016 | 2785
 |  |  |  |  |  |  |  |  | Production |  | 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
 |  |  |  |  |  |  |  |  | Closing stock
 |  |  |  |  |  |  |  |  | Fwd Cover
68138555 | 68138552 | Small pack current | 69953 | 0 | 0 | 0 | 0 |  | Demand |  | 0 | 16241 | 0 | 0 | 0 | 8121 | 0 | 0 | 0 | 8121 | 0 | 8121 | 0 | 0 | 5135 | 5882 | 7496 | 4774 | 5247 | 4993 | 6615 | 6121 | 5909 | 6713 | 5707
 |  |  |  |  |  |  |  |  | Production |  | 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
 |  |  |  |  |  |  |  |  | Closing stock
 |  |  |  |  |  |  |  |  | Fwd Cover
Spreadsheet: 58faeca6-aab9-4e28-8d40-a4c5d0ff82e7
Sheet: Sheet1

Unnamed: 0 | ADVANCED MICRO DEVICES, INC. | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | CONSOLIDATED STATEMENTS OF OPERATIONS
 | (Millions except per share amounts and percentages)
 |  |  | Quarter Ended
 |  |  | Mar. 27, | Dec. 26, | Mar. 28,
 |  |  | 2010 | 2009 | 2009
 | Net revenue |  | 1574 | 1646 | 1177
 | Cost of sales |  | 833 | 911 | 666
 | Gross margin |  | 741 | 735 | 511
 | Gross margin % |  | 0.4707750952986023 | 0.4465370595382746 | 0.4341546304163126
 | Research and development |  | 323 | 432 | 444
 | Marketing, general and administrative |  | 219 | 239 | 287
 | Legal settlement |  | 0 | -1242 | 0
 | Amortization of acquired intangible assets |  | 17 | 18 | 18
 | Restructuring charges |  | 0 | 0 | 60
 | Operating income (loss) |  | 182 | 1288 | -298
 | Interest income |  | 3 | 3 | 3
 | Interest expense |  | -49 | -119 | -97
 | Other income (expense), net |  | 304 | 19 | 94
 | Income (loss) before equity in net income (loss) of investee and income taxes |  | 440 | 1191 | -298
 | Provision (benefit) for income taxes |  | 0 | 11 | 116
 | Equity in net income (loss) of investee |  | -183 | 0 | 0
 | Income (loss) from continuing operations |  | 257 | 1180 | -414
 | Income (loss) from discontinued operations, net of tax |  | 0 | -3 | 0
 | Net income (loss) |  | 257 | 1177 | -414
 | Net (income) loss attributable to noncontrolling interest |  | 0 | 23 | 6
 | Class B preferred accretion |  | 0 | -22 | -8
 | Net income (loss) attributable to AMD common stockholders |  | 257 | 1178 | -416
 | Net income (loss) attributable to AMD common stockholders per common share
 | Basic
 |  | Continuing operations | 0.3635077793493635 | 1.675177304964539 | -0.6645367412140575
 |  | Discontinued operations | 0 | -1e-08 | 0
 | Basic net income (loss) attributable to AMD common stockholders per common share |  | 0.3635077793493635 | 1.675177294964539 | -0.6645367412140575
 | Diluted
 |  | Continuing operations | 0.350132625994695 | 1.519595448798989 | -0.6645367412140575
 |  | Discontinued operations | 0 | -1e-08 | 0
 | Diluted net income (loss) attributable to AMD common stockholders per common share |  | 0.350132625994695 | 1.519595438798989 | -0.6645367412140575
 | Shares used in per share calculation
 | Basic |  | 707 | 705 | 626
 | Diluted |  | 754 | 791 | 626
Spreadsheet: 431578d1448137636-index-match-duplicate-values-with-no-helper-cells-match-index-duplicate-value
Sheet: Sheet1

Apples | Bananas | Oranges | Peaches | Grapes | Pears | Plums | Grapefruit
15 | 11 | 15 | 12 | 12 | 15 | 10 | 16
Large 1 | Large 2 | Large 3 | Large 4
Grapefruit | Apples | Oranges | Pears
Spreadsheet: eaec7f58-94ba-4c16-bee5-202ec8ea56cf
Sheet: Sheet1

analytica 2012 - List of exhibitors | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Search by product and service index (1 Entry):
 | 3 Test and measurement and quality control 3.4 Time and time-based parameters 3.4.2 Time counters
No. | Company | Country | City | [NAME] | Hall/Booth
1 | A. Hanhart GmbH & Co. [NAME] | Germany | [NAME] | 78148 | B1.122
Spreadsheet: 828074d1683209847-formula-to-search-uppercase-words-only-in-text-string-uppercase-search
Sheet: Sheet1

 |  |  |  | Column1 | Results wanted for these examples
 |  |  |  | ENF…THIS IS A TEST TODAY. (I want formula to only recognize uppercase words not lowercase.) | True
 |  |  |  | I was doing something this date and I was happy about it. | False
 |  |  |  | ENF…I WITNESSED SOMEONE THIS DATE DO SOMETHING INAPPROPRIATE. | True
 |  |  |  | Today I am expected to do something important | False
 |  |  |  | BWN…THIS IS ANOTHER TEST. (I saw the movie [NAME] today) | False
Spreadsheet: 781207d1653060001-need-help-with-pulling-data-from-one-sheet-to-another-using-index-requiredtraining2022-test
Sheet: Records

[NAME] | FullName | Supervisor | Division | MaxOfClassDate | ClassName | Frequency | ClassType
003 | Employee, Mister | Supervisor, [NAME] | Manager, [NAME] | 2019-12-09 00:00:00 | Class1 | Annual | Annual
003 | Employee, Mister | Supervisor, [NAME] | Manager, [NAME] | 2019-05-08 00:00:00 | Class2 | Annual | Annual
003 | Employee, Mister | Supervisor, [NAME] | Manager, [NAME] | 2020-12-03 00:00:00 | Class3 | Annual | Annual
003 | Employee, Mister | Supervisor, [NAME] | Manager, [NAME] | 2018-05-24 00:00:00 | Class4 | Annual | Annual
Spreadsheet: 108442d1305532587-date-and-percentage-with-if-function-date-and-percentage
Sheet: Sheet1

Focus | Actual | Status
2011-06-27 00:00:00 | 0.4
2011-05-20 00:00:00 |  |  |  | - If Focus is blank then it would show nothing in the Status
 |  |  |  | - If Actual is 100% or any date then it would show DONE the Status
 |  |  |  | - If Focus is smaller than today date then it would show OVERDUE in the Status
2011-06-27 00:00:00 |  |  |  | - If Focus minus today date is smaller than 8 then it would show TO FINISH IN 7 DAYS in the Status
2011-06-20 00:00:00
2011-05-26 00:00:00
2011-05-20 00:00:00 |  |  |  | There is a condition missing, if Focus - Today is larger than 7. I added " don't know". Change it to what you need
2011-05-25 00:00:00 | 0.7
2011-05-15 00:00:00 | 1
2011-05-21 00:00:00
2011-06-20 00:00:00
2011-05-17 00:00:00 | 2011-05-14 00:00:00
2011-06-27 00:00:00
2011-06-05 00:00:00
2011-05-04 00:00:00 | 2011-05-09 00:00:00
2011-04-30 00:00:00 | 1
2011-05-07 00:00:00 | 2011-05-07 00:00:00
Spreadsheet: 713683d1610879954-subtraction-of-vlookup-in-two-sheets-but-across-a-number-of-columns-test-excel-forum_vlookup_test-when-ee-not-in-one-tab
Sheet: DEC 20

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 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
EE ID | Gender | Other 1 | Other 2 | Other 3 | Other 4 | Other 5 | Other 6 | Other 7 | Other 8 | Other 9 | Other 10 | Other 11 | Other 12 | Other 13 | Other 14 | Other 15 | Other 16 | Other 17 | Other 18 | Other 19 | Other 20 | Other 21 | Other 22 | Other 23 | Other 24 | Other 25 | Other 26 | Other 27 | Other 28 | Other 29 | Other 30 | Other 31 | Other 32 | Other 33 | Other 34 | Other 35 | Other 36 | Other 37 | Other 38 | Other 39 | Other 40 | Other 41
100 | test | test | test | test | test | test | test | test | test | test | test | test | test | test | test | test | test | 950000 | 5 |  |  |  |  |  |  |  |  |  |  |  | 59
150 | test | test | test | test | test | test | test | test | test | test | test | test | test | test | test | test | test | 10 |  |  |  |  |  |  |  | 4
175 | test | test | test | test | test | test | test | test | test | test | test | test | test | test | test | test | test | 85000
Spreadsheet: eb76c2e2-fb3b-4720-9d72-c03a95ca4507
Sheet: 15a

Product |  | Transactions
Single - Name* | Corporate | 27252
 | Loans | <100
 | Municipal | <100
 | Recovery | <100
 | Sovereign | 2122
Index Tranche | Asia | <100
 | Europe | 223
 | North America | 892
Index | Asia | 141
 | Europe | 4879
 | North America | 3660
TOTAL |  | 39169
Estimated swap transaction volumes, week ending February 15, by product type (in number of transactions), all tenors and currencies. This table will be expanded to reflect participant type and cleared status as more complete data becomes available.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown.
*See Data Dictionary for product descriptions.
**N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 6f13eb65-9f1d-45bc-9c52-5c7bf557258c
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SNOWSHOE | T1 | SKATE | T2 | SKI | POSITION | TOTAL TIME
2795 | 6008 | Carina | Wasle | AUT | 51 | [NAME] | 00:00:00 | 00:42:21 | 00:00:00 | 00:26:12 | 1 | [NAME]
2795 | 5998 | Sigrid | Mutscheller | GER | 52 | [NAME] | 00:00:00 | 00:44:12 | 00:00:00 | 00:24:52 | 2 | 01:34:08
2795 | 15241 | Anke | Kullmann | GER | 59 | 00:25:11 | 00:00:00 | 00:44:04 | 00:00:00 | 00:26:06 | 3 | 01:35:23
2795 | 6001 | Sarka | [NAME] | CZE | 53 | 00:26:10 | 00:00:00 | 00:49:11 | 00:00:00 | 00:27:24 | 4 | 01:42:46
2795 | 6956 | Adelaide | Cappellini | ITA | 58 | 00:28:57 | 00:00:00 | 00:52:02 | 00:00:00 | [NAME] | 5 | [NAME]
2795 | 15598 | Germaine | Roullet | ITA | 57 | 00:29:10 | 00:00:00 | [NAME] | 00:00:00 | 00:28:00 | 6 | 01:58:42
2795 | 15679 | Sabine | Houdek | GER | 54 | 00:32:06 | 00:00:00 | [NAME] | 00:00:00 | 00:38:49 | 7 | 02:17:23
Spreadsheet: 829527d1684294619-creating-a-formula-to-return-the-average-of-the-top-5-scores-for-a-certain-player-in-table-season-long-ppr-rankings-session-1-2023
Sheet: Seaon Long PPR

Top 5 | TRUE
Player Name | Average of PPR Score |  |  | Row Labels | Count of Game Name
[NAME] | 6.781999999999999 |  |  | [NAME] | 7
[NAME] | 5.933999999999999 |  |  | 7.32 | 1
[NAME] | 5.57 | Not 5 matches |  | 7.22 | 1
[NAME] | 6.3 |  |  | 6.65 | 1
[NAME] | 5.954000000000001 |  |  | 6.6 | 1
[NAME] | 5.225 | Not 5 matches |  | 6.12 | 1
[NAME] | 5.116 |  |  | 5.75 | 1
[NAME] | 6.184 |  |  | 5.54 | 1
[NAME] D | 6.622 |  |  | [NAME] | 6
[NAME] | 6.021999999999999 |  |  | 6.63 | 1
Kyle N | 4.378 |  |  | 6 | 1
Wags | 6.194000000000001 |  |  | 5.77 | 1
Grand Total | 5.872586206896551 |  |  | 5.65 | 1
 |  |  |  | 5.62 | 1
 |  |  |  | 5.52 | 1
 |  |  |  | [NAME] | 4
 |  |  |  | 5.89 | 1
 |  |  |  | 5.6 | 1
 |  |  |  | 5.52 | 1
 |  |  |  | 5.27 | 1
 |  |  |  | [NAME] | 8
 |  |  |  | 7.35 | 1
 |  |  |  | 6.59 | 1
 |  |  |  | 6.02 | 1
 |  |  |  | 5.83 | 1
 |  |  |  | 5.71 | 1
 |  |  |  | 5.53 | 1
 |  |  |  | 5.48 | 1
 |  |  |  | 4.95 | 1
 |  |  |  | [NAME] | 8
 |  |  |  | 6.35 | 1
 |  |  |  | 6.27 | 1
 |  |  |  | 5.83 | 1
 |  |  |  | 5.67 | 1
 |  |  |  | 5.65 | 1
 |  |  |  | 5.62 | 1
 |  |  |  | 5.58 | 1
 |  |  |  | 4.52 | 1
 |  |  |  | [NAME] | 4
 |  |  |  | 6 | 1
 |  |  |  | 5.5 | 1
 |  |  |  | 4.76 | 1
 |  |  |  | 4.64 | 1
 |  |  |  | [NAME] | 9
 |  |  |  | 6.14 | 1
 |  |  |  | 5.11 | 1
 |  |  |  | 4.94 | 1
 |  |  |  | 4.74 | 1
 |  |  |  | 4.65 | 1
 |  |  |  | 4.5 | 1
 |  |  |  | 4.32 | 1
 |  |  |  | 4.09 | 1
 |  |  |  | 3.93 | 1
 |  |  |  | [NAME] | 8
 |  |  |  | 6.7 | 1
 |  |  |  | 6.29 | 1
 |  |  |  | 6.15 | 1
 |  |  |  | 6 | 1
 |  |  |  | 5.78 | 1
 |  |  |  | 5.47 | 1
 |  |  |  | 5.46 | 1
 |  |  |  | 4.82 | 1
 |  |  |  | [NAME] D | 7
 |  |  |  | 7.11 | 1
 |  |  |  | 6.82 | 1
 |  |  |  | 6.76 | 1
 |  |  |  | 6.52 | 1
 |  |  |  | 5.9 | 1
 |  |  |  | 5.6 | 1
 |  |  |  | 5.4 | 1
 |  |  |  | [NAME] | 9
 |  |  |  | 6.68 | 1
 |  |  |  | 6.2 | 1
 |  |  |  | 6 | 1
 |  |  |  | 5.67 | 1
 |  |  |  | 5.56 | 1
 |  |  |  | 5.45 | 1
 |  |  |  | 5.35 | 1
 |  |  |  | 5.33 | 1
 |  |  |  | 5.27 | 1
 |  |  |  | Kyle N | 6
 |  |  |  | 5.92 | 1
 |  |  |  | 4.62 | 1
 |  |  |  | 4.15 | 1
 |  |  |  | 3.94 | 1
 |  |  |  | 3.26 | 1
 |  |  |  | 1.23 | 1
 |  |  |  | Wags | 5
 |  |  |  | 6.73 | 1
 |  |  |  | 6.55 | 1
 |  |  |  | 6.12 | 1
 |  |  |  | 5.96 | 1
 |  |  |  | 5.61 | 1
 |  |  |  | Grand Total | 81
Spreadsheet: 883339d1731960290-variable-end-of-data-series-value-in-chart-akp
Sheet: 0 Plan

 |  |  |  |  |  | Select Ending Week for plotting -> |  |  |  | Wk 13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Plot Limits
 | Plot Accumulators |  |  | Wk 1 | Wk 2 | Wk 3 | Wk 4 | Wk 5 | Wk 6 | Wk 7 | Wk 8 | Wk 9 | Wk 10 | Wk 11 | Wk 12 | Wk 13 | Wk 14 | Wk 15 | Wk 16 | Wk 17 | Wk 18 | Wk 19 | Wk 20 | Wk 21 | Wk 22 | Wk 23 | Wk 24 | Wk 25 | Wk 26 | Wk 27 | Wk 28 | Wk 29 | Wk 30 | Wk 31
 |  |  | Inc Plan | 2 | 4 | 6 | 8 | 10 | 12 | 14 | 16 | 18 | 20 | 22 | 24 | 26 | 28 | 30 | 32 | 34 | 36 | 38 | 40 | 42 | 44 | 46 | 48 | 50 | 52 | 54 | 56 | 58 | 60 | 62
 |  |  | How To
 |  |  | https://support.microsoft.com/en-us/office/offset-function-c8de19ae-dd79-4b9b-a14e-b4d906d11b66
 | Balance Sheet |  | Hours | Cost
 | Labor Rate |  | 1
 | Plan
 | Spend
 | Balance
 | Materials Spend Log
 | Discipline |  | PO # |  | Date |  | Cost |  | Item Description
 | Total Materials Spend
 | Total Materials Budget
 | Total Materials Balance
Spreadsheet: 215246d1361312960-how-transfer-cell-value-to-related-sheet-name-copy-to-other-sheet-tab1
Sheet: Master

Name | first name | Surname |  | Seq | 1
Name1 | A | AA
[NAME] | C | KK
[NAME] | G | PP
Name3 | K | UU
Name1 | M | TT
Nmae3 | O | HH
Name4 | P | VV
Name1 | T | DD
[NAME] | H | CC
Name4 | W | MM
Spreadsheet: james_steffes__12850__CA rate exposure final 8-28 rev
Sheet: Assumptions

ASSUMPTIONS/DATA |  |  |  |  |  |  |  | SCENARIO ANALYSIS (scenario numbers can be changed)
 |  |  |  |  |  |  |  | KEY | Scenario A- | Impacts all DA customers
ANNUAL SALES |  |  |  |  |  |  |  |  | Scenario B- | Impact is prorated
PG&E | 80000000 |  |  |  |  |  |  |  | Scenario C- | Costs do not apply
Edison | 82000000 |  |  |  |  |  | Legacy Customers
SDG&E | 16000000 |  |  |  |  |  | PG&E
Total |  |  |  |  |  |  | Scenario |  | Amortization (years) | 5 | 7 | 10 | 12 | 15
 |  |  |  |  |  |  | A | Utility Undercollection
BONDS |  |  |  |  |  |  | B | Bonds
Amount Raised | Rate | Interest |  |  |  |  | C | Contracts
 |  |  |  |  |  |  | Sub Total
8500 | 0.0577 |  |  |  |  |  |  | Regulatory Costs
4000 | 0.0777 |  |  |  |  |  | Total
ASSUMED DISCOUNT RATES |  |  |  |  |  |  | SCE
Bonds
Contracts | 0.09 |  |  |  |  |  | Scenario |  | Amortization (years) | 5 | 7 | 10 | 12 | 15
Undercollection | 0.0641 |  |  |  |  |  | C | Utility Undercollection
 |  |  |  |  |  |  | B | Bonds
 |  |  |  |  |  |  | A | Contracts
DWR'S COST ALLOCATION - 2001&2002 (USD billions) |  |  |  |  |  |  | Sub Total
 | Share | Bonds | Above market contract costs |  |  |  |  | Regulatory Costs
PG&E |  |  |  |  |  |  | Total
Edison
SDG&E
Total |  |  |  |  |  |  | SDGE
OTHER COSTS |  |  |  |  |  |  | Scenario |  | Amortization (years) | 5 | 7 | 10 | 12 | 15
 | Undercollection | Regulatory Costs |  |  |  |  | B | Utility Undercollection
PG&E | 6.7 |  |  |  |  |  | C | Bonds
Edison | 3.5 |  |  |  |  |  | C | Contracts
SDG&E | 0.932 |  |  |  |  |  | Sub Total
Total |  |  |  |  |  |  |  | Regulatory Costs
 |  |  |  |  |  |  | Total
Regulatory Costs Breakdown
Employee Transition | Power Purchase Obligations | Nuclear Incremental | CTC Exempts | FTA Related | Total
$ | $ | $ | $ | $ | $
 |  |  |  |  |  |  | New Customers
 |  |  |  |  |  |  | PG&E
 |  |  |  |  |  |  | Scenario |  | Amortization (years) | 5 | 7 | 10 | 12 | 15
 |  |  |  |  |  |  | C | Utility Undercollection
 |  |  |  |  |  |  | B | Bonds
 |  |  |  |  |  |  | A | Contracts
 |  |  |  |  |  |  | Sub Total
 |  |  |  |  |  |  |  | Regulatory Costs
 |  |  |  |  |  |  | Total
 |  |  |  |  |  |  | SCE
 |  |  |  |  |  |  | Scenario |  | Amortization (years) | 5 | 7 | 10 | 12 | 15
 |  |  |  |  |  |  | A | Utility Undercollection
 |  |  |  |  |  |  | B | Bonds
 |  |  |  |  |  |  | C | Contracts
 |  |  |  |  |  |  | Sub Total
 |  |  |  |  |  |  |  | Regulatory Costs
 |  |  |  |  |  |  | Total
 |  |  |  |  |  |  | SDGE
 |  |  |  |  |  |  | Scenario |  | Amortization (years) | 5 | 7 | 10 | 12 | 15
 |  |  |  |  |  |  | B | Utility Undercollection
 |  |  |  |  |  |  | C | Bonds
 |  |  |  |  |  |  | A | Contracts
 |  |  |  |  |  |  | Sub Total
 |  |  |  |  |  |  |  | Regulatory Costs
 |  |  |  |  |  |  | Total
Spreadsheet: 880697d1728549159-how-to-convert-cell-values-with-formula-book2
Sheet: Sheet1

 |  |  |  | 1
 | BUDGET | REQUIREMENT
Piping | 58421.503
Electrical | 87324.894
Instrumentation | 57765.123
TOTAL
Other Materials | 4862.864
Spares | 3315.94
TOTAL
Presently I have the values in Column B
Which I want to change as per Column C
I want to add the named range in front of the cell values, so that I can change the name range cell as per my requirement
Spreadsheet: 747299d1631362621-listing-differences-between-2-columns-comparelist-help
Sheet: Sheet1

 | DUTY | NAME | MON | TUE | WED | THUR | FRI | SAT |  |  | Master List |  | MON | TUE | WED | THUR | FRI | SAT
 | L1 | R J [NAME] | L5 | L24 | L24 | L24 | DAY OFF | L24
 | L2 | M S J GRIFFITH | A/L | A/L | A/L | A/L | A/L | DAY OFF
 | L3 |  | L3 |  |  |  |  | OFF
 | [NAME] | E M OWEN | A/L | [NAME] | DAY OFF | [NAME] | [NAME] | A/L
 | L5 | H PREUSS | L7 | L20 | [NAME] | DAY OFF | DAY OFF | DAY OFF
 | L6 | H GRIFFITH | Day Off | DAY OFF | DAY OFF | L20 | L20 | L20
 | L7 | A W GRIFFITH | Day Off | [NAME] | L12 | L22 | L24 | L12
 | L8 | [NAME] | L8 | L6 | L20 | L6 | L6 | Day Off
Spreadsheet: 854523d1704368802-dynamically-autopopulate-a-table-auto-populate
Sheet: DATASHEET

Period
2011/ | 01
2011/ | 02
2011/ | 03
2011/ | 04
2011/ | 05
2011/ | 06
2011/ | 07
2011/ | 08
2011/ | 09
2011/ | 10
2011/ | 11
2011/ | 12
2012/ | 01
2012/ | 02
2012/ | 03
2012/ | 04
2012/ | 05
2012/ | 06
2012/ | 07
2012/ | 08
2012/ | 09
2012/ | 10
2012/ | 11
2012/ | 12
2013/ | 01
2013/ | 02
2013/ | 03
2013/ | 04
2013/ | 05
2013/ | 06
2013/ | 07
2013/ | 09
2013/ | 10
2013/ | 12
2014/ | 01
2014/ | 02
2014/ | 03
2014/ | 04
2015/ | 07
2015/ | 08
2015/ | 09
2015/ | 10
2015/ | 11
2015/ | 12
2016/ | 01
2016/ | 02
2016/ | 03
2016/ | 04
2016/ | 05
2016/ | 06
2016/ | 07
2016/ | 08
2016/ | 09
2016/ | 10
2016/ | 11
2016/ | 12
2017/ | 01
2017/ | 02
2017/ | 03
2017/ | 04
2017/ | 05
2017/ | 06
2017/ | 07
2017/ | 08
2017/ | 09
2017/ | 10
2017/ | 11
2017/ | 12
2018/ | 01
2018/ | 02
2018/ | 03
2018/ | 04
2018/ | 05
2018/ | 06
2018/ | 07
2018/ | 08
2018/ | 09
2018/ | 10
2018/ | 11
2018/ | 12
2019/ | 01
2019/ | 02
2019/ | 03
2019/ | 04
2019/ | 05
2019/ | 06
2019/ | 07
2019/ | 08
2019/ | 09
2019/ | 10
2019/ | 11
2019/ | 12
2020/ | 01
2020/ | 02
2020/ | 03
2020/ | 04
2020/ | 05
2020/ | 06
2020/ | 07
2020/ | 08
2020/ | 09
2020/ | 10
2020/ | 11
2020/ | 12
2021/ | 01
2021/ | 02
2021/ | 03
2021/ | 04
2021/ | 05
2021/ | 06
2021/ | 07
2021/ | 08
2021/ | 09
2021/ | 10
2021/ | 11
2021/ | 12
2022/ | 01
2022/ | 02
2022/ | 03
2022/ | 04
2022/ | 05
2022/ | 06
2022/ | 07
2022/ | 08
2022/ | 09
2022/ | 10
2022/ | 11
2022/ | 12
2023/ | 01
2023/ | 02
2023/ | 03
Total: