tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: af2e2ae3-54e3-418f-bfcd-3c38ed5f2af4
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
STAP | Test | STAP | Identification Staphylococcus | Identification Staphylococcus |  |  |  |  |  |  | This test is for Billing Purposes Only.  This is not an orderable test. |  |  |  |  |  |  | 1 | 87077 |  |  |  |  | Rochester
STAP | [NAME] | VARIES | Varies |  |  |  | See instructions
Spreadsheet: 214716d1361080435-need-help-with-populating-worksheet-with-rows-from-other-sheet-based-on-criteria-2013-pinto-schedule
Sheet: Tigers

Field | Date | Day | Start Time | Away | AC | HC | Home |  | Code | Team | Away Games | Home Games | Total Games
 |  |  |  |  |  |  |  |  | 1 | A's
 |  |  |  |  |  |  |  |  | 2 | Cubs
 |  |  |  |  |  |  |  |  | 3 | Dodgers
 |  |  |  |  |  |  |  |  | 4 | Phillies
 |  |  |  |  |  |  |  |  | 5 | Pirates
 |  |  |  |  |  |  |  |  | 7 | Yankees
Spreadsheet: 177472d1346319852-sum-frequentcy-formula-not-working-dailyfigures
Sheet: Summary

Date |  |  | [NAME] | Gina | Sandra | Scott | [NAME]
2012-08-29 00:00:00
Selling Channel | Value | Orders | Actual
TTS - Export Intl Schools |  |  | 2
TTS - UK Trade Direct Delivery |  |  | 3
TTS - Export Consolidators |  |  | 2
TTS - UK Consolidators |  |  | 0
TTS - Export Trade |  |  | 1
TTS - UK Trade |  |  | 3
TTS - Trade Pisces |  |  | 0
TTS Trade and Export |  |  | 0
Total
Export Total
UK Total
Spreadsheet: 122014d1316551995-indirect-erep_1gb-tigrovi_bkp
Sheet: Imbar

Ambient on/off
eRepublik – Online Strategy Game
Sep20 Day 1,400 of the New World
Home
My Land
Wars
Market
Marketplace
Job market
Monetary market
Companies for sale
Community
World Map
News
My Party
Elections
Military Unit
Country administration
Invite friends
Badges
Get Gold & Extras
[NAME]
[NAME]
27
60
Eat food
Gold2.24 Gold
BAM411 BAM
HRK1625 HRK
Missions
X
You don't have enough Gold to complete the task Get Gold
Completed!
2011-10-03 00:00:00
2011-10-03 00:00:00
2011-10-03 00:00:00
Reward
Ok
Congratulations, your rank is now
Rank Bonus on attack +5%
Energy bar
Ok
Strength
Experience points
Health
Rank points
Gold
Energy bar
[NAME]
Free Lands
Scope
Bazooka
Weapons
Weapons
Weapons
Food units
Food units
Food units
Grain Farms
0 0
Logout
Experience level: 27
Experience points: 10027
Next level at: 15000
• Working, training and fighting decreases health
[NAME], health boxes, food, hospitals restore health.
This action restores as much health as possible by eating Food from your Storage.
You can recover up to: 450 / 450 Health
100 more recoverable Health in: 00:59:59
Food limit reached
You have reached your food consumption limit.
You can recover 100 health every hour.
100 more recoverable Health in: [NAME]
Buy health kit Close
Imbar
offlineImbar
Add as a friend Send message Donate
Experience level 27
13,842 / 15,000
Location: CroatiaCroatia, Central Croatia Citizenship: CroatiaCroatia
eRepublik birthday
Aug 04, 2010
National rank: 1031
Party Member
[NAME] eHrvatskeSavez Komunista eHrvatske Far-left Wing
No Military Unit
No media activity
Friends(12)
BeDva
Z N Gorki
[NAME]
NoviTigar91
wayoflife
Sokrato
[NAME]
[NAME]
[NAME] subcomadante
view all
Land of Imbar: 16 buildings
Visit
Achievements
hard worker
2
Hard Worker
Worked 30 days in a row
congressman
Congress Member
Win the Congress elections
president
Country President
Win the Presidential elections
media mogul
Media Mogul
Reach 1000 subscribers to your newspaper
battle hero
Battle Hero
Reach the highest war influence in a battle
campaign hero
Campaign hero
Reach the highest war influence in a campaign
resistance hero
Resistance Hero
Start a resistance war and liberate that region
super soldier
8
Super Soldier
Advance 250 strength points
society builder
Society Builder
Invite 10 people to eRepublik and help them reach level 10
mercenary
1
Mercenary
Defeat 25 enemies for 50 different countries
Coming soon
Coming soon
Military Skills
Strength
2,118.05
Super soldier:2,118 / 2,250
Rank
Colonel **Colonel **
Rank points:
521,388 / 540,000
Forum   |   [NAME]   |   Blog   |   Press   |   Contact   |   [NAME]   |   Terms of Service   |   Privacy  |   Affiliates  |   [NAME]
Follow us: FacebookFacebook TwitterTwitter
Copyright © 2007-2011 eRepublik
Spreadsheet: 68c97b97-f1eb-40d4-b01a-d090831082c2
Sheet: SUMMER 2012

 | SUMMER SCHOOL 2012 CALENDAR
 | INSTRUCTIONAL PAYROLL SCHEDULE
 | Column1 | Column2 | Column3 | Column4 | COUNTY PROCESSING DAY
 | PAY PERIOD | REPORTS DUE | ISSUE DATE |  | OF CHECKS
 |  |  |  |  | (NO CHANGES OR ADDS AFTER THIS DATE)
 | 6/11/12 TO 6/30/12 | *JUNE 25 TH | JULY 5TH | SUMMER SESSION | JUNE 28TH
 | [NAME] | *JULY 23 RD | AUGUST 3RD | SUMMER SESSION | JULY 30TH
 | 8/01/12 TO 8/31/12 | *AUG 23 RD | SEPTEMBER 5TH | COUNSELORS, HRLY, ETC. | AUG 29TH
 | * DEPARTMENTS MUST PROJECT  ALL SUMMER PAID HOURS ON THEIR TIME REPORTS DUE BEFORE THE END OF EACH MONTH
 | BECAUSE OF THE SHORTAGE OF PAYROLL PROCESSING TIME AVAILABLE
Spreadsheet: 793355d1661426635-how-to-update-a-list-tab-based-on-an-evolving-data-tab-test
Sheet: Anon_Data_BEFORE

CENTRE | F_AREA | COL1 | COL2 | [NAME] | COL4 | [NAME] | CRS_TITLE | COL6 | COL7 | [NAME] | COL9 | AO | CODE | Level | COL10 | COL11 | COL12 | Year | COL13 | COL14 | COL15
Centre 01 | Area 01 | XYZ | XYZ | XYZ | XYZ | XYZ | Course 01 | XYZ | XYZ | XYZ | XYZ | AO1 | 001 | 1 | XYZ | XYZ | XYZ | 22/23 | XYZ | XYZ | XYZ
Centre 02 | Area 02 | XYZ | XYZ | XYZ | XYZ | XYZ | Course 02 | XYZ | XYZ | XYZ | XYZ | AO2 | 002 | 1 | XYZ | XYZ | XYZ | 22/23 | XYZ | XYZ | XYZ
Centre 04 | Area 03 | XYZ | XYZ | XYZ | XYZ | XYZ | Course 03 | XYZ | XYZ | XYZ | XYZ | AO3 | 002 | 2 | XYZ | XYZ | XYZ | 22/23 | XYZ | XYZ | XYZ
Centre 01 | Area 04 | XYZ | XYZ | XYZ | XYZ | XYZ | Course 04 | XYZ | XYZ | XYZ | XYZ | AO4 | 002 | X | XYZ | XYZ | XYZ | 22/23 | XYZ | XYZ | XYZ
Centre 02 | Area 05 | XYZ | XYZ | XYZ | XYZ | XYZ | Course 05 | XYZ | XYZ | XYZ | XYZ | AO5 | 005 | E | XYZ | XYZ | XYZ | 22/23 | XYZ | XYZ | XYZ
Centre 03 | Area 06 | XYZ | XYZ | XYZ | XYZ | XYZ | Course 06 | XYZ | XYZ | XYZ | XYZ | AO6 | 006 | E | XYZ | XYZ | XYZ | 22/23 | XYZ | XYZ | XYZ
Centre 05 | Area 07 | XYZ | XYZ | XYZ | XYZ | XYZ | Course 07 | XYZ | XYZ | XYZ | XYZ | NONE | 007 | E | XYZ | XYZ | XYZ | 22/23 | XYZ | XYZ | XYZ
Centre 06 | Area 08 | XYZ | XYZ | XYZ | XYZ | XYZ | Course 08 | XYZ | XYZ | XYZ | XYZ | AO7 | 007 | 1 | XYZ | XYZ | XYZ | 22/23 | XYZ | XYZ | XYZ
 | [NAME]
Spreadsheet: 839310d1691819435-excel-formula-to-calculate-stock-transaction-sample-67-2-
Sheet: Sheet1

Date | Type | Stock | Transacted Units | Transacted Price (per unit) | Comm | Cls Fee | Tdg Fee | Buying Fee | SGX SI Fee | GST Fee | Fees | Stock [NAME] | Previous Units | Cumulative Units | Transacted Value | Previous Cost | Cost of Transaction | Avg Stock Price | Cumulative Cost | Gains/Losses from Sale | [NAME]  %
2023-05-03 00:00:00 | Buy | ABC | 300 | 32.44 | 27.25 | 3.16 | 0.73 | 0 | 0.35 | 2.52 |  | 1
2023-05-22 00:00:00 | Div | ABC | 300 | 0.42 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
2023-11-08 00:00:00 | Div | ABC | 300 | 0.48 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
2023-08-12 00:00:00 | Buy | ABC | 400 | 32.44 | 27.25 | 3.16 | 0.73 | 0 | 0.35 | 2.52 | 34.01000000000001 | 1
2023-08-15 00:00:00 | Buy | ABC | 500 | 32.44 | 27.25 | 3.16 | 0.73 | 0 | 0.35 | 2.52 | 34.01000000000001 | 1
 |  |  |  |  |  |  |  |  |  |  | Expected Result |  | 700 | 1200 | 16254.01 | 22776.02 |  |  | 39030.03
Spreadsheet: 73442d1274113277-multi-sheet-formula-auto-populate-updated-week-4
Sheet: WEEK 5

 |  | THE HIT PARADE
 |  | Monday |  |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Sunday
 | Player | Hits | Points |  | Hits | Points | Hits | Points | Hits | Points | Hits | Points | Hits | Points | Hits | Points |  |  |  | TOTAL HITS
Cubie |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Dwayne |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Kent |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Nate |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Scott |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
[NAME] | 0 | 0
Not Hitter | 0 | 0
Total Points | (meaningless)
Cubie |  | 4
Dwayne |  | 2
[NAME] |  | 5
[NAME] |  | 2
[NAME] |  | 5
Kent |  | 3
Nate |  | 3
[NAME] |  | 6
Scott |  | 6
Spreadsheet: 36046d1233791270-pay-scales-lots-of-ifs-overtime-workbook
Sheet: Week 1

Week 1 - 01/02/2009
Name | Direct 1 | Direct 2 | Direct 3 | Direct 4 | Direct 5 | Direct 6 | Direct 7 | Direct 8 | Direct 9 | Direct 10
Contracted Hours | 35 | 35 | 35 | 35 | 35 | 15 | 15 | 15 | 15 | 15
[NAME] at 1x | 10 | 15 | 20 | 25 | 10 | 10 | 10 | 10 | 10 | 10
[NAME] at 1.5x | 15 | 22.5 | 30 | 37.5 | 15 | 15 | 15 | 15 | 15 | 15
Hourly  Wage at 2x | 20 | 30 | 40 | 50 | 20 | 20 | 20 | 20 | 20 | 20
Sunday Premium Wage | 20 | 30 | 40 | 50 | 20 | 20 | 20 | 15 | 15 | 15
Additional Hours | 10 | 8 | 5 |  | 2 | 20 | 20 | 21 | 20 | 20
Sunday Hours |  | 2 | 1 | 1 |  |  |  |  | 1
Sunday Addtional Hours |  |  |  |  |  |  |  |  |  | 1
Weekly Overtime Spend | 450 | 735 | 860 | 950 | 370 | 350 | 350 | 360 | 375 | 375
Total Overtime Spend This Week | 5175
% Of Budget
Budget Remaining
Spreadsheet: 718090d1612979934-extract-from-tables-from-multiple-tabs-one-workbook-excel-help
Sheet: ABC I 2019

 |  |  |  |  |  |  |  | Title 2019
 | Date Range |  | 2019-01-01 00:00:00 | to | 2019-12-31 00:00:00
Account | Description |  | Period 1 - 2019 | Period 2 - 2019 | Period 3 - 2019 | Period 4 - 2019 | Period 5 - 2019 | Period 6 - 2019 | Period 7 - 2019 | Period 8 - 2019 | Period 9 - 2019 | Period 10 - 2019 | Period 11 - 2019 | Period 12 - 2019 | Total
01-999-12345 | First Row |  | -59360.66959002035 | -60669.381295158 | -59991.91995313048 | -60275.77883270602 | -63225.90810517436 | -66538.14924564176 | -68846.42899869419 | -71065.57370712045 | -60190.6091815496 | -59476.97860821536 | -60583.21909690577 | -60356.71337650798 | -750581.3299908243
01-999-11223 | Second Row |  | -7433.230785566619 | -7597.109599657625 | -7512.276889070465 | -7547.822117535544 | -7947.229695491042 | -8363.564421856092 | -8653.705440763146 | -8932.642560907943 | -7565.70543647374 | -7476.005086506792 | -7615.054845150835 | -7586.584032452511 | -94230.93091143234
01-999-99883 | [NAME] |  | -1738.445474160763 | -1776.772601474034 | -1756.932366987113 | -1765.245500715332 | -1869.796796082705 | -1967.750594737475 | -2036.013973090862 | -2101.641336781028 | -1780.033084138765 | -1758.928695137545 | -1791.643842826835 | -1784.945328199102 | -22128.14959433156
01-999-77443 | Middle Row |  | -1133.057237296593 | -1158.037502500513 | -1145.106339798434 | -1150.524546164624 | -1183.172214042996 | -1245.155533872773 | -1288.351314651542 | -1329.879074973826 | -1126.371426907232 | -1113.016966832793 | -1133.718496435034 | -1129.479802476686 | -14135.87045595305
01-888-12345 | First Row |  | -50899.50573512211 | -52021.67601051392 | -51440.77879857191 | -51684.17694028273 | -53150.78436638101 | -55935.21593727419 | -60274.11969288801 | -62216.9509437879 | -52696.06622974412 | -52071.29229129528 | -53039.79091343455 | -52841.48821130546 | -648271.8460706011
01-888-11223 | Second Row |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
01-888-99883 | [NAME] |  | -1718.735962400319 | -1756.628558416663 | -1737.013261289448 | -1745.232145408221 | -1794.755434280142 | -1888.778010857633 | -2012.930797953353 | -2077.814115703809 | -1759.852075572622 | -1738.986956200158 | -1771.331198044134 | -1764.708627387492 | -21766.76714351399
01-888-77443 | Middle Row |  | -961.3587437913684 | -982.5536098453676 | -971.581978473334 | -976.1791337575905 | -1003.879518121363 | -1056.470159199432 | -1212.259916775817 | -1251.335003438646 | -1059.846733350469 | -1047.281001880864 | -1066.759877143651 | -1062.771524955277 | -12652.27720073318
Spreadsheet: 453676d1459410051-is-there-any-way-to-automatically-color-code-cells-based-on-formula-outcome-conditional-formatting
Sheet: Sheet1

Date | Day
2016-03-01 00:00:00 |  | [NAME] used for conditional formatting =OR(B1="Saturday",B1="Sunday")
2016-03-02 00:00:00
2016-03-03 00:00:00
2016-03-04 00:00:00
2016-03-05 00:00:00
2016-03-06 00:00:00
2016-03-07 00:00:00
2016-03-08 00:00:00
2016-03-09 00:00:00
2016-03-10 00:00:00
2016-03-11 00:00:00
2016-03-12 00:00:00
2016-03-13 00:00:00
2016-03-14 00:00:00
2016-03-15 00:00:00
2016-03-16 00:00:00
2016-03-17 00:00:00
2016-03-18 00:00:00
2016-03-19 00:00:00
2016-03-20 00:00:00
Spreadsheet: 94894d1294664712-index-and-lookup-returning-data-for-only-1st-or-last-occurance-of-matched-key-value-find-all-occurences
Sheet: Sheet2

Key | Value | Helper |  | Input | B | 6
A | 4 |  |  |  |  | 16
B | 6 | 3 |  |  |  | 26
C | 8 |  |  |  |  | 36
D | 10
E | 12
A | 14
B | 16 | 8
C | 18
D | 20
E | 22
A | 24
B | 26 | 13
C | 28
D | 30
E | 32
A | 34
B | 36 | 18
C | 38
D | 40
E | 42
Spreadsheet: 178768d1346914275-automatic-entry-in-calender-when-updating-reference-sheet-calender-entry
Sheet: Sheet1

Date | Project
2012-08-01 00:00:00 | A
2012-08-01 00:00:00 | B
2012-08-01 00:00:00 | C
2012-08-09 00:00:00 | D
2012-08-09 00:00:00 | E
2012-08-10 00:00:00 | F
2012-08-14 00:00:00 | G
2012-08-14 00:00:00 | H
2012-08-14 00:00:00 | I
2012-08-20 00:00:00 | J
2012-08-21 00:00:00 | K
2012-08-21 00:00:00 | L
2012-08-31 00:00:00 | M
2012-08-31 00:00:00 | N
2012-08-31 00:00:00 | O
Spreadsheet: mary_fischer__25638__31U
Sheet: E11.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 031U
COMPANY NAME   Limbach Mgmt Company
ANALYSIS OF OTHER CURRENT LIABILITIES
FOR THE 6 MONTHS ENDED 6-30-2001
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-11
 |  | 12-31-2000 Balance
 |  | BEGINNING |  | OTHER |  | 03-31-2001 |  | OTHER |  | 06-30-2001 |  | OTHER |  | 09-30-2001 |  | OTHER |  | 12-31-2001
[NAME] |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE
 |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.)
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Worker's comp (reclassed to Hyperion 620) |  | -8994599 |  | 8994599 |  |  |  | 0
State of Nevada |  | 1621 |  | 0 |  |  |  | 0
Dep Prem-Ins-Ohio |  | 0 |  | 1000 |  |  |  | 0
Dep Prem-Ins-West VA |  | 0 |  | 4172 |  |  |  | 0
Total Other Current Liabilities
(must tie to Hyperion account 655) | * |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *
Income Accts:  DR/(CR)
Reverse signs from Hyperion
Spreadsheet: jeffrey_a_shankman__14000__Exhibit 14 (Scenario 6)
Sheet: Rate Increase Model

 | CPUC Rate Proceeding |  |  |  |  |  |  |  | Exhibit 14:  Scenario 6
 | SDG&E A. 01-01-044 |  |  |  |  |  |  |  | Revised with DWR Revenue Requirement
 |  |  |  |  |  |  |  |  | Update August 7, 2001
 | Billing Determinants
 | Original Filing Determinants (July-01 to June-02)
 | Sales (GWh) |  | URG | DWR |  | Total
 | Capped AB 265 Customers | 0.7 | 6987.209349386416 | 4772.273078870193 |  | 11759.48242825661
 | Capped ABX1 43 Customers | 0.3 | 0 | 5039.778183538547 |  | 5039.778183538547
 | Total Bundled Sales |  | 6987.209349386416 | 9812.05126240874 |  | 16799.26061179516
 | Update Determinants (October-01 to December-02)
 | Sales (GWh) |  | URG | DWR |  | Total
 | Capped AB 265 Customers | 0.7
 | Capped ABX1 43 Customers | 0.3 | 0
 | Total Bundled Sales
 | Commodity Revenue Requirement |  | ($000s)
 | DWR Rev. Requirement |  | 2068441 |  | <============ | DWR Revenue Requirements Update Letter August 7, 2001
 | SDG&E - URG |  | 670175.3136200698 |  | <============ | Retained Generation Costs Jul-01 to Dec-02
 | SDG&E Ancillary Charges |  | 213045.1524139957 |  | <============ | SDG&E Ancillary Charges Jul 01 to Dec 02
 | SDG&E Other ISO Charges |  | 73149.20836804548 |  | <============ | SDG&E ISO Charges Jul 01 to Dec 02
 | SDG&E Grid Mgmnt Charges (GMC) |  | 30621.4823457456 |  | <============ | SDG&E Grid Mgmnt Charges (GMC) Jul 01 to Dec 02
 | Total URG Revenue Requirement
 | Total Commodity Revenue Requirement
 | Bundled Revenues
 | Revenues at Current Commodity Rate
 | DWR Commodity Revenues @6.5 c/kWh
 | URG Commodity Revenues @ 6.5 c/kWh |  |  | 6.5
 | DWR Revenues Subject to Rate Increase
 | SDG&E Revenues Subject to Rate Increase
 | Total Rate Increase
 | Customer Revenue Allocation
 |  |  | System |  |  | ABX1 43 Customers |  | AB 265 Customers
 | DWR Revenue Requirement
 | Billed Revenues
 | DWR Revenues Subject to Rate Increase
 | DWR Revenue Requirement Reduction |  | -94000 |  |  |  |  | NA
 | Retroactive Rate Increase Adjustment  Mar-27 to Sept- 30 |  |  |  |  |  |  | NA
 | [NAME] (GWh) Oct-01 to Dec-02
 | DWR Rate Increase (C/kWh)
 | CTC Rate (C/kWh) |  |  |  |  | -0.66 |  | 0
 | Net DWR Rate Increase (C/kWh)
Spreadsheet: 49999d1249411754-solved-data-manipulation-reformatreport
Sheet: Sheet3

Name | Q1 Due Date | Q1 End Date | Q1 % Comp | Q2 Due Date | Q2 End Date | Q2 % Comp |  | Question | Due Date | End Date | Percent Complete
Ric | 2009-10-08 00:00:00 | 2009-11-08 00:00:00 | 0.1 | 20/08/2009 | 21/08/2009 | 0.2 |  | Ric
[NAME] | 2009-05-09 00:00:00 | 2009-06-09 00:00:00 | 1 | 15/09/2009 | 16/09/2009 | 0.9 |  | 1 | 2009-10-08 00:00:00 | 2009-11-08 00:00:00 | 0.1
[NAME] | 2008-12-08 00:00:00 | 2009-01-08 00:00:00 | 0.9 | [NAME] | 21/08/2010 | 0.6 |  | 2 | 20/08/2009 | 21/08/2009 | 0.2
[NAME] | 2008-07-09 00:00:00 | 2008-08-09 00:00:00 | 0.8 | 15/09/2010 | 16/09/2010 | 0.3 |  | [NAME]
[NAME] | 2008-02-08 00:00:00 | 2008-03-10 00:00:00 | 0.7 | 20/08/2011 | 21/08/2011 | 1 |  | 1 | 2009-05-09 00:00:00 | 2009-06-09 00:00:00 | 1
Doug | 2007-09-09 00:00:00 | 2007-10-10 00:00:00 | 0.6 | 15/09/2011 | 16/09/2011 | 0.7 |  | 2 | 15/09/2009 | 16/09/2009 | 0.9
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | 1 | 2008-12-08 00:00:00 | 2009-01-08 00:00:00 | 0.9
 |  |  |  | Each color represents a separate formula. |  |  |  | 2 | [NAME] | 21/08/2010 | 0.6
 |  |  |  | Enter the first yellow and copy down. |  |  |  | [NAME]
 |  |  |  | Enter the first blue and copy down 1 row and |  |  |  | 1 | 2008-07-09 00:00:00 | 2008-08-09 00:00:00 | 0.8
 |  |  |  | over two columns. |  |  |  | 2 | 15/09/2010 | 16/09/2010 | 0.3
 |  |  |  | Then enter the tan formula and copy across. |  |  |  | [NAME]
 |  |  |  | Then highlight all the blue and tan cells (3 |  |  |  | 1 | 2008-02-08 00:00:00 | 2008-03-10 00:00:00 | 0.7
 |  |  |  | rows worth) and copy that down as a group. |  |  |  | 2 | 20/08/2011 | 21/08/2011 | 1
 |  |  |  |  |  |  |  | Doug
 |  |  |  |  |  |  |  | 1 | 2007-09-09 00:00:00 | 2007-10-10 00:00:00 | 0.6
 |  |  |  |  |  |  |  | 2 | 15/09/2011 | 16/09/2011 | 0.7
Spreadsheet: 125084d1318871896-adding-a-column-without-damage-to-sheet-copy-of-box-inventory1
Sheet: Summary

 |  | Summary
Box # | Product | Start Date | # Days in Storage | Material Weight | Delivered to Staging | Issues
1 | Empty
2 | Crane Dust
3 | [NAME]
4 | LRS [NAME]
5 | Mixed Alloy
6 | Mixed Alloy
7 | Mixed Alloy
8 | KO61
9 | Haz
10 | Haz
11 | Haz
12 | KO61
13 | KO61
14 | KO61
15 | Crane Dust
16 | Crane Dust
17 | KO61
18 | Crane Dust
19 | Mixed Alloy
Spreadsheet: 90816d1290539250-if-and-data-validation-part-2-ms-test-11-18-2010
Sheet: Lists

 |  |  | UOM | KGS | Piece | Percent
16 | 40.64 | 40 | KGS | 0.25 | 1 | 0.01
17 | 43.18 | 43 | Piece | 0.275 | 2 | 0.0125
18 | 45.72 | 45 | Percent | 0.3 | 3 | 0.015
20 | 50.8 | 50 | Dollar | 0.325 | 4 | 0.0175
21 | 53.34 | 53 | Fixed | 0.35 | 5 | 0.02
22 | 55.88 | 55 |  | 0.375 | 6 | 0.0225
24 | 60.96 | 60
26 | 66.04 | 66
27 | 68.58 | 68.58
28 | 71.12 | 71
30 | 76.2 | 75
40 | 101.6 | 100
60 | 152.4 | 152
84 | 213.36 | 213
27.5 | 69.85 | 70
32 | 81.28 | 80
34 | 86.36 | 86
35 | 88.9 | 89
35.5 | 90.17 | 90
48 | 121.92 | 122
36 | 91.44 | 90
57 | 144.78 | 145
72 | 182.88 | 183
45 | 114.3 | 114
46 | 116.84 | 115
96 | 243.84 | 244
120 | 304.8 | 300
Spreadsheet: 714203d1611141096-hlookup-with-nested-match-function-hlookupfile
Sheet: Summary

 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
McDonalds
GM
Apple
IBM
Microsoft
Honda
Toyota
Chevron
Shell
Belkin