tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: kim_ward__20823__DWP Gas Assets
Sheet: Gas Fired Generation Facilities

LADWP's Natural Gas Fired Generation Facilities
Facility | Unit | Fuel | Capacity | Year of
Name | Number |  | MW | Initial
 |  |  |  | Operation
[NAME] | GT6 | Natural Gas | 19 | 1972
 | GT7 | Natural Gas | 19 | 1972
 | GT8 | Natural Gas | 19 | 1972
 | GT9 | Natural Gas | 19 | 1972
 | 4 | Natural Gas (Out of Service) | 86 | 1948
 | 5 | Natural Gas (Out of Service) | 86 | 1949
Haynes [NAME] | 1 | Natural Gas | 222 | 1962
 | 2 | Natural Gas | 222 | 1963
 | 3 | Natural Gas | 222 | 1964
 | 4 | Natural Gas | 222 | 1964
 | 5 | Natural Gas | 341 | 1966
 | 6 | Natural Gas | 341 | 1967
Scattergood Gen Stn | 1 | Natural Gas | 179 | 1958
 | 2 | Natural Gas | 179 | 1959
 | 3 | Natural Gas | 358 | 1974
[NAME] | 1 | Natural Gas-Deactivated | 95 | 1954
 | 2 | Natural Gas-Deactivated | 99 | 1954
 | 3 | Natural Gas | 163 | 1955
 | 4 | Natural Gas | 160 | 1956
TOTAL:
Spreadsheet: 296bcdbf-6a73-43dc-a90a-7449040ebc45
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2014-06-16 09:19:44.330000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.75 | 102.875 | 102.75 | 102.625 | 102.25 |  | and are added to price quote
4.625 | 102.717 | 102.592 | 102.467 | 102.092
4.5 | 102.58 | 102.455 | 102.33 | 101.955 |  | Note: | Refer To Price [NAME]
4.375 | 101.757 | 101.632 | 101.507 | 101.132 |  |  | For all Price Adjs
4.25 | 101.165 | 101.04 | 100.915 | 100.29
4.125 | 100.328 | 100.203 | 100.078 | 99.453
4 | 99.327 | 99.202 | 99.077 | 98.452
3.875 | 98.282 | 98.157 | 98.032 | 97.407
3.75 | 97.407 | 97.282 | 97.157 | 96.532
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.75 | 102.404 | 102.279 | 102.154 | 101.779
3.625 | 102.015 | 101.89 | 101.765 | 101.39
3.5 | 101.466 | 101.341 | 101.216 | 100.841
3.375 | 100.749 | 100.624 | 100.499 | 100.124
3.25 | 100.066 | 99.941 | 99.816 | 99.191
3.125 | 99.632 | 99.507 | 99.382 | 98.757
3 | 98.882 | 98.757 | 98.632 | 98.007 |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2014-06-30 09:19:44.330000
30 DAY | 2014-07-15 09:19:44.330000
45 DAY | 2014-07-30 09:19:44.330000
60 DAY | 2014-08-14 09:19:44.330000
90 DAY | 2014-09-13 09:19:44.330000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: richard_shapiro__32210__2000 contributions
Sheet: Breakouts

Contribution Breakout
A total of 545 contributions have been disbursed to date, totaling $1,367,925.
11 contrib. were not used because they were outside the scope of  this analysis.
The # of contribs & the percentages were calculated w/o using those 11 contribs. which
are listed at the bottom of the chart.
 | Contribution Destination | # of Contribs | $$ amt | % of Total Contrib | % of Total $$
 | Republicans | 337 | 684625
 | Democrats | 208 | 683300
 | State | 525 | 491426
 | Federal | 20 | 876500
 | SOM/SEBI | 0 | 0 | 0 | 0
 | Leadership | 0 | 0 | 0 | 0
 | Key Comm. | 0 | 0 | 0 | 0
 | Supports Legis | 0 | 0 | 0 | 0
 | Key Dist | 0 | 0 | 0 | 0
 | Not counted | 11 | 69000
Spreadsheet: 126e1ff5-54ed-4186-a213-f5a9349645c0
Sheet: T54

الجدول 54: وفيات الإناث المسجلة، 2000-2010
Table 54: Registered female deaths, 2000-2010
Country | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | البلد
Bahrain | 832 | 771 | 796 | 872 | 919 | 895 | 938 | 847 | … | … | … | البحرين
Egypt | 183324 | 181600 | 197224 | 202282 | 198809 | 203895 | 202105 | 204196 | 205817 | 215465 | 218682 | مصر
Iraq | 125646 | 35522 | 38168 | 38137 | 39905 | 43187 | 85456 | 51321 | 57326 | … | … | العراق
Jordan | 5411 | 6670 | 7131 | 6911 | 6932 | 7326 | 8644 | 10363 | 8302 | 8856 | 12863 | الأردن
Kuwait | 1537 | 1603 | 1587 | 1602 | 1705 | 1647 | 1819 | 1938 | 2104 | 2460 | … | الكويت
Lebanon | 8241 | 7709 | 7681 | 7720 | 7905 | 7983 | 8231 | 9404 | 9420 | 10029 | 10563 | لبنان
Oman | 1008 | 1023 | 1033 | 1114 | 1092 | 1186 | 2191 | 2230 | 2667 | 2471 | … | عمان
Palestine | 4026 | 4009 | 4168 | 4349 | 4140 | 4230 | 4189 | 4327 | … | … | … | فلسطين
Qatar | 394 | 379 | 365 | 415 | 417 | 437 | 476 | 457 | 487 | 493 | 500 | قطر
Saudi Arabia | 36107 | 36523 | 36945 | 37371 | 37803 | 38232 | 38667 | 39128 | 39609 | 40120 | … | المملكة العربية السعودية
Sudan | ... | ... | ... | ... | ... | ... | ... | ... | … | … | … | السودان
Syrian Arab Republic | 21804 | 22554 | 23434 | 23647 | 26151 | 26921 | 25522 | 28064 | 30694 | 32312 | … | الجمهورية العربية السورية
United Arab Emirates | 1480 | 1644 | 1607 | … | … | 1806 | 1796 | 1946 | 1975 | 1940 | … | الإمارات العربية المتحدة
Yemen | 4643 | 4605 | 4745 | 5023 | 5372 | 4039 | 4131 | 4817 | 4866 | 6288 | … | اليمن
Spreadsheet: 689556d1596513443-duplicate-tasks-in-a-project-tracker-formula-and-data-consistency-help-project-tracker-example
Sheet: Sheet1

Sequence | Platform | Task | Duplicate group | Status | Desired result of status | [NAME] linkage | Comments
1 | A | Task 1 | Duplicate 1 | Completed | Completed | status hardcoded from status in Column E
2 | A | Task 2 | Duplicate 2 | In progress | In progress | status hardcoded from status in Column E
3 | A | Task 3 | Duplicate 3 | Error | Error | status hardcoded from status in Column E
4 | A | Task 4 | Duplicate 4 | Not Required | Not Required | status hardcoded from status in Column E
5 | B | Task 1 | Duplicate 1 |  |  | =E4 | Picks up Task 1 / Duplicate 1 data from platform A and finds correct status (completed)
6 | B | Task 2 | Duplicate 2 |  |  | =E5 | Picks up Task 2 / Duplicate 2 data from platform A and finds correct status (In progress)
7 | B | Task 5 | Duplicate 5 | Deffered | Deferred | status hardcoded from status in Column E
8 | C | Task 1 | Duplicate 1 |  |  | =E4 | Picks up Task 1 / Duplicate 1 data from platform A and finds correct status (completed)
9 | C | Task 2 | Duplicate 2 |  |  | =E5 | Picks up Task 2 / Duplicate 2 data from platform A and finds correct status (In progress)
10 | C | Task 3 | Duplicate 3 |  |  | =E6 | Picks up Task 3 / Duplicate 3 data from platform A and finds correct status (error)
11 | C | Task 5 | Duplicate 5 |  |  | =E10 | Picks up Task 5 / Duplicate 5 data from platform B and finds correct status (deferred)
12 | D | Task 1 | Duplicate 1 | Completed |  | =E4 | Picks up Task 1 / Duplicate 1 data from platform A and finds correct status (completed)
13 | D | Task 4 | Duplicate 4 | Not Required |  | =E7 | Picks up Task 4 / Duplicate 4 data from platform A and finds correct status (Not required)
14 | D | Task 6 |  | To do | To do | status hardcoded from status in Column E | Stand alone task
15 | D | Task 7 |  | To do | To do | status hardcoded from status in Column E | Stand alone task
Spreadsheet: 853121d1703064044-flip-rows-excel-2010-flip-rows
Sheet: List2

 | Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 |  | Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8
 | 8 | 7 | 6 | 5 | 4 | 3 | 2 | 1 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
 | 26 | 24 | 22 | 20 | 18 | 16 | 14 | 12 |  | 12 | 14 | 16 | 18 | 20 | 22 | 24 | 26
 | 85 | 82 | 79 | 76 | 73 | 70 | 67 | 64 |  | 64 | 67 | 70 | 73 | 76 | 79 | 82 | 85
Spreadsheet: benjamin_rogers__1176__Bernsteins's LM6000 Model
Sheet: OPERATIONAL CHARACTERISTICS

 | OPERATIONAL CHARACTERISTICS
 | CAPACITY AND HEAT RATE |  |  | ISO | 95* | ISO | 95*
 |  |  |  | with chilling | with chilling | no chilling | no chilling
 |  | GROSS UNIT CAPACITY MW |  | 48.3 | 48.3 | 45.5 | 34.5
 |  | UNIT AUXILIARY POWER (MW) | 0.015
 |  | MAIN POWER TRANSFORMER (MW) | 0.005
 |  | GAS COMPRESSION (MW) |  |  |  |  |  |  |  |  | this should be changed to incorporate real comprssion loads
 |  | CHILLER LOAD |  | -0.2 | -1.75 | 0 | 0
 |  | NET PLANT CAPACITY
 |  | NOTE: These are New and Clean data
 |  | HEAT RATE - PLANT NET OF GSU AND AUXILIARY (HHV)
 |  |  | this also includes 3% GE/S&S margin
 | RAMP UP/DOWN TIME
 |  | RAMP UP TIME |  | 10 | Minutes |  |  |  | this matches S&S claim - reality is more like 16 minutes for typical push button to full load
 |  | RAMP DOWN TIME |  | 5 | Minutes
 |  | TIME BEFORE RESTART |  | 30 | Minutes
 | RELIABILITY
 |  | AVAILABILITY |  | 0.95 | Annually
 |  | ENGINE LEASE PROGRAM - WITHIN 72 HOURS |  | 800 | $000 / Year
 |  | MAJOR MAINTENANCE SCHEDULE |  | COST | TIME
 |  | 5,000 HOURS |  | 250000 | 3 WEEKS
 |  | 10,000 HOURS |  | 500000 | 5 WEEKS
 |  | 15,000 HOURS |  | 250000 | 3 WEEKS
 |  | 20,000 HOURS |  | 500000 | 5 WEEKS
 |  | 25,000 HOURS |  | 1200000 | 10 WEEKS
 | CURRENT GE MARKET PRICE AND AVAILABILITY
 |  | BASE TURBINE |  | 14000000
 |  | SPRINT PACKAGE |  | 500000
 |  | FIN FAN COOLER |  | 65000
 |  | TOTAL TURBINE COST
 |  | DELIVERY |  | Q3 2001
Spreadsheet: 157694d1337849145-formula-to-calculate-commission-based-on-sales-percent-salary-report_solution
Sheet: Sheet1

Employee | Sales performance | Commission Earned |  |  |  | Sales % | Commission
[NAME] | 0.74 | 250 |  |  | 0.7 | 70-80% | 250
[NAME] | 0.8 | 250 |  |  | 0.8001 | 80-90% | 500
[NAME] | 1.13 | 1250 |  |  | 0.9001 | 90-100% | 750
 |  |  |  |  | 1.0001 | 100-110% | 1000
 |  |  |  |  | 1.1001 | 110-120% | 1250
Spreadsheet: 781564d1653417181-multiple-value-need-to-be-referenced-2022-05-24-oeldere-sterlingsilver67-lookup-question
Sheet: Explaination

 |  |  |  |  | Batch | 10001A |  | 10003A
Type:
L-01
L-02 |  |  |  |  |  | 10002A
L-03
L-04
L-05
LT1
LT2
 |  |  |  |  |  |  |  |  |  | Need Type(s) brought in by Batch No and not bring in additional
 |  |  |  |  |  |  |  |  |  | Some Batch number will have the same "Type" - Do not need to bring in value unless it matches Batch #
Spreadsheet: 65889d1266517167-match-formula-excel-help-2-18-10
Sheet: Sheet1

[NAME]
AA
BB
CC
[NAME]
AA
BB
CC
[NAME]
AA
BB
CC
Tiffany
AA
BB
CC
Will
AA
BB
CC
[NAME]
AA
BB
CC
Spreadsheet: 56695d1256825741-moving-information-within-a-workbook-and-inserting-in-sheets-data-move
Sheet: Sheet1

Conway | FXF | FXNL | Old D | R+L | Lowest Carrier 200 | Conway | FXF | FXNL | Old D | R+L | Lowest Carrier   250 | Conway | FXF | FXNL | Old D | R+L | Lowest Carrier   300
200 | 200 | 200 | 200 | 200 |  | 250 | 250 | 250 | 250 | 250 |  | 300 | 300 | 300 | 300 | 300
109 | 79.11599999999999 | 79.11599999999999 |  | 80 |  | 118.19 | 86.75599999999997 | 86.13599999999997 |  | 80 |  | 133.83 | 104.106 | 103.362 |  | 86.97
109 | 70 | 70 |  | 80 |  | 118.19 | 78.16 | 77.596 |  | 80 |  | 133.83 | 93.79199999999997 | 93.11399999999998 |  | 86.97
109 | 84.63599999999997 | 84.63599999999997 |  | 80 |  | 118.19 | 95.356 | 94.67 |  | 80 |  | 133.83 | 114.426 | 113.604 |  | 86.97
109 | 70 | 70 |  | 80 |  | 118.19 | 78.16 | 77.596 |  | 80 |  | 133.83 | 93.79199999999997 | 93.11399999999998 |  | 86.97
109 | 84.63599999999997 | 84.63599999999997 |  | 80 |  | 118.19 | 95.356 | 94.67 |  | 80 |  | 133.83 | 114.426 | 113.604 |  | 86.97
109 | 79.11599999999999 | 79.11599999999999 |  | 80 |  | 118.19 | 86.75599999999997 | 86.13599999999997 |  | 80 |  | 133.83 | 104.106 | 103.362 |  | 86.97
109 | 79.11599999999999 | 79.11599999999999 |  | 80 |  | 118.19 | 86.75599999999997 | 86.13599999999997 |  | 80 |  | 133.83 | 104.106 | 103.362 |  | 86.97
109 | 79.11599999999999 | 79.11599999999999 |  | 80 |  | 118.19 | 86.75599999999997 | 86.13599999999997 |  | 80 |  | 133.83 | 104.106 | 103.362 |  | 86.97
109 | 84.63599999999997 | 84.63599999999997 |  | 80 |  | 118.19 | 95.356 | 94.67 |  | 80 |  | 133.83 | 114.426 | 113.604 |  | 86.97
109 | 79.11599999999999 | 79.11599999999999 |  | 80 |  | 118.19 | 86.75599999999997 | 86.13599999999997 |  | 80 |  | 133.83 | 104.106 | 103.362 |  | 86.97
109 | 70 | 70 |  | 80 |  | 118.19 | 78.16 | 77.596 |  | 80 |  | 133.83 | 93.79199999999997 | 93.11399999999998 |  | 86.97
109 | 70 | 70 |  | 80 |  | 118.19 | 78.16 | 77.596 |  | 80 |  | 133.83 | 93.79199999999997 | 93.11399999999998 |  | 86.97
109 | 79.11599999999999 | 79.11599999999999 |  | 80 |  | 118.19 | 86.75599999999997 | 86.13599999999997 |  | 80 |  | 133.83 | 104.106 | 103.362 |  | 86.97
 | ok this is what I need to do I need to take F3:F15 information and move it to sheet2 and insert it into A1:15
 | the same goes for column l but that needs to go into sheet 2 in column b
Spreadsheet: fc7569e7-3237-4c7b-bf81-56a9aad2624f
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
SPNEU | Test | SPNEU | Streptococcus pneumoniae Antigen, [NAME] | Streptococcus pneumoniae Ag, U | Immunochromatographic Membrane Assay | Plastic, urine bottle: [NAME] |  |  | 10 | mL | Container/Tube: Plastic, 10-mL urine tube (Supply T068) [NAME]: 2 mL Collection Instructions: Collect a random urine specimen. Forms: If not ordering electronically, submit a General Request Form (Supply T239) with the specimen. | 0.5 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | Negative | Monday through Friday; 12 p.m. | Same day/1 day | 1 day | 1 | 87899 |  |  |  |  | Rochester
SPNEU | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 7 days
SPNEU | Result | 83150 | Streptococcus pneumoniae Ag, U | Streptococcus pneumoniae Ag, U | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24027-5 | Streptococcus pneumoniae Ag:ACnc:Pt:[NAME]:[NAME]:
Spreadsheet: 551456d1512962077-cell-colour-formatting-with-multiple-arguments-copy-of-colour
Sheet: Sheet2

 |  | Milestone | Task | True
 |  | Patch Cable | Buy cables | True
 |  |  | Install cables | True
 |  |  | Label cables | True
 |  | Install Equipment | Buy devices | False
 |  |  | Asset register | True
 |  |  | Install devices | True
 |  | Delivery | Trial run with client | True
 |  |  | Training | True
 |  |  | [NAME] | True
Spreadsheet: 171455d1343738470-vba-vlookup-compare-three-columns-book3
Sheet: Sheet2

100000313 | NORDIC CHARGE | Service Charge IS Management | P12 2012
100000313 | NORDIC CHARGE | Nordic Service Charges NO31 | P11 2012
100000627 | NORDIC CHARGE | Service Charge IS Management | P11 2012
100000627 | NORDIC CHARGE | Nordic Service Charges NO31 | P12 2012
100001227 | NORDIC CHARGE | Service Charge IS Management | P12 2012
100001227 | NORDIC CHARGE | Nordic Service Charges NO31 | P09 2012
100001988 | NORDIC CHARGE | Service Charge IS Management | P08 2012
100001988 | NORDIC CHARGE | Nordic Service Charges NO31 | P05 2012
100002607 | NORDIC CHARGE | Service Charge IS Management | P04 2012
100002607 | NORDIC CHARGE | Nordic Service Charges NO31 | P03 2012
Spreadsheet: 124621d1318513641-help-with-sumif-sumproduct-formulas-sample-bc
Sheet: Feb

Acct | Consolidated | Location 1 | Location 2 | Location 3
supplies |  | 1 | 7 | 14
insurance |  | 8 | 4 | 5
office |  | 5 | 1 | 32
Spreadsheet: 143929d1330628661-index-code-including-count-examplebirdiestotals-1-
Sheet: Sheet1

PAR | 4 | 4 | 4 | 3 | 5 | 3 | 4 | 5 | 4 |  | 5 | 3 | 4 | 4 | 4 | 5 | 3 | 4 | 4
Jones, B | 3 | 4 | 5 | 7 | 5 | 3 | 3 | 5 | 5 |  | 4 | 4 | 5 | 7 | 5 | 4 | 3 | 5 | 5
Smith, A | 3 | 3 | 5 | 5 | 6 | 3 | 5 | 6 | 4 |  | 6 | 2 | 5 | 5 | 6 | 5 | 5 | 6 | 4
Moore, L | 4 | 4 | 6 | 4 | 4 | 3 | 6 | 7 | 6 |  | 4 | 4 | 6 | 4 | 4 | 4 | 6 | 7 | 6
Stone, G | 5 | 4 | 3 | 3 | 5 | 3 | 3 | 6 | 5 |  | 5 | 4 | 3 | 5 | 5 | 4 | 7 | 8 | 5
Evans, R | 6 | 4 | 4 | 3 | 6 | 2 | 4 | 4 | 4 |  | 6 | 4 | 4 | 5 | 6 | 5 | 4 | 4 | 4
Brown, M | 3 | 4 | 4 | 3 | 4 | 3 | 5 | 5 | 5 |  | 5 | 4 | 4 | 5 | 4 | 5 | 5 | 5 | 5
Kirk, W | 5 | 5 | 5 | 4 | 6 | 4 | 6 | 4 | 6 |  | 5 | 5 | 5 | 4 | 6 | 5 | 6 | 6 | 6
Malone, R | 4 | 5 | 6 | 5 | 5 | 2 | 7 | 5 | 4 |  | 5 | 5 | 6 | 5 | 5 | 5 | 7 | 5 | 4
[NAME], T | 5 | 6 | 6 | 5 | 5 | 4 | 8 | 6 | 3 |  | 5 | 6 | 6 | 5 | 5 | 5 | 8 | 6 | 5
Crane, R | 6 | 4 | 3 | 3 | 5 | 5 | 4 | 7 | 4 |  | 6 | 4 | 4 | 5 | 5 | 5 | 4 | 7 | 4
Palmer, M | 7 | 5 | 6 | 3 | 5 | 4 | 4 | 5 | 3 |  | 7 | 5 | 6 | 5 | 5 | 5 | 4 | 5 | 5
[NAME], R | 3 | 6 | 4 | 3 | 4 | 3 | 4 | 6 | 6 |  | 5 | 6 | 4 | 5 | 4 | 5 | 4 | 6 | 6
Spreadsheet: 707960d1607551338-help-for-vlookup-offset-and-match-to-search-for-a-reference-and-return-the-needed-value-hockey-stats-ex
Sheet: Goal Breakdown

Date | 2020-11-28 00:00:00
Player | Game 1 | Game 2 | Game 3 | Game 4 | Game 5 | Game 6 | Game 7 | Game 8 | Game 9 | Game 10 | Game 11 | Game 12 | Game 13 | Game 14 | Game 15 | Game 16 | Game 17 | Game 18 | Game 19 | Game 20 | Game 21 | Game 22 | Game 23
[NAME]
Will Fraumeni
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Will Meyers
[NAME]
[NAME]
Chubbz
[NAME]
[NAME]
[NAME]
[NAME]
Elric
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
PJ
[NAME]
[NAME]
[NAME]
[NAME]
BJ
Urim
[NAME]
[NAME]
[NAME]'s Brother
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Flops
Pads
Other Guy
[NAME]
[NAME]
Soup
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Spreadsheet: 45697d1244530814-nesting-vlookup-in-if-vice-versa-and-pivot-table-modelcategoryytd
Sheet: gGuide

 | Get a YTD report for category 1 or 2
 | Include new data
 | Update the YTD report and automatically include new model numbers
 | Change YTD category
 | Type the category number into F3 on rYTD
 | Add new data to sData
 | Paste new data into the rows directly below the last row of sModelData
 | Update the sModelData range name to include the new data
 | Refresh the PivotTable on dMonCat
 | Update the YTD report and automatically include new model numbers
 | 1. Delete the Data Table results on rYTD. To do this, proceed as follows:
 | 1.1 Select from D8 on rYTD (you see that it contains a DSUM formula) down to the
 | bottom row in the DEC column on rYTD (do not include columns beyond DEC - they
 | are not part of the Data Table).
 | 2. Press Delete
 | 3. On the external data toolbar click [NAME] (the icon with a mini spreadsheet and an
 | exclamation mark). You see that if the data includes additional models, the list is updated and
 | the YTD formulae extend to the required number of rows.
 | 4. Recreate the Data Table as follows:
 | 4.1 Select from C7 (you see that it contains a DSUM formula) down to the last DEC row.
 | 4.2 Choose Data | Table
 | 4.3 For Row Input Cell: choose [NAME] (Month), for column input cell choose D3 (Model)
 | 4.4 Choose OK….you should get a result like the following:
Spreadsheet: 670112d1585752935-updating-a-formula-for-text-split-textfunctions
Sheet: Sheet2

 | 1st String | 2nd String | [NAME]
Find position of first space
Find position of second space
Find position of third space
Find position of fourth space
Find position of fifth space
Find position of sixth space
Find position of seventh space
Find position of eigth space
Find position of nineth space
Find position of tenth space
Find position of eleventh space
 | LEFT(A17,B2) | MID(A17,B2+1,B3-(B2+1)) | MID(A17,B3+1,B4-(B3+1)) | MID(A17,B4+1,B7-(B4+1)) | MID(A17,B7+1,B8-(B7+1)) | MID(A17,B7+1,B8-(B7+1)) | RIGHT(TRIM(A17),5)
[NAME] 18794 [NAME] Northville Michigan 48168
[NAME] 620 Slayton Street Grand Haven Michigan 12345
[NAME] 5353 North Silver Pines Drive Bellaire Michigan 56789
Spreadsheet: 774474d1648494110-need-alternative-formula-to-fetch-price-value-based-on-effective-date-sample-file-fetch-price-based-on-effective-date-1-
Sheet: Result

Model | Data Date | Current Formula | Need a alternative formula | Need a alternative formula | Need a alternative formula
A | 2022-03-01 00:00:00
B | 2022-03-02 00:00:00
C | 2022-03-04 00:00:00
D | 2022-03-10 00:00:00
A | 2022-03-20 00:00:00 |  |  |  |  | As model 'A' and 'B' prices dropped on the 20th, prices after the 20th will be at a new price based on the effective date from the price list.
B | 2022-03-22 00:00:00
A | 2022-03-25 00:00:00
B | 2022-03-25 00:00:00
Spreadsheet: 737433d1624415511-calculate-cell-value-based-on-time-and-day-sample
Sheet: Sheet1

Column 1 | Start Date | Day | Person 1 | (Person 2) | Start Time | Finish Time | Total duration | End Date | End Day | Column 2 | Column 3 | Column 4 | Column 5 | Column 6 | CP | NON CP | CP - Intened | NON CP Intened
 | 2021-04-27 00:00:00 | Tuesday | Person 1 | Person 4 | 10:30:00 | 16:00:00 | 5.5 | 2021-04-27 00:00:00 | Tuesday | 1 | 1 | Yes |  | DP |  |  | 4.5 | 1
 | 2021-04-27 00:00:00 | Tuesday | Person 2 | Person 5 | 10:30:00 | 14:00:00 | 3.500000000000001 | 2021-04-27 00:00:00 | Tuesday | 1 | 1 | Yes |  | DP |  |  | 3.5 | 0
 | 2021-04-29 00:00:00 | Thursday | Person 3 | Person 5 | 13:00:00 | 14:00:00 | 1.000000000000002 | 2021-04-29 00:00:00 | Thursday | 1 | 1 | Yes |  | DP |  |  | 1 | 0
 | 2021-05-04 00:00:00 | Tuesday | Person 3 | Person 5 | 09:30:00 | 14:00:00 | 4.500000000000002 | 2021-05-04 00:00:00 | Tuesday | 1 | 1 | Yes |  | DP |  |  | 4.5 | 0
 | 2021-05-11 00:00:00 | Tuesday | Person 3 | Person 5 | 11:00:00 | 16:30:00 | 5.5 | 2021-05-11 00:00:00 | Tuesday | 1 | 1 | Yes |  | DP |  |  | 4 | 1.5
Spreadsheet: 802903d1667136169-dynamic-string-rankings
Sheet: Sheet2

rank | athlete |  | rank | athlete |  | rank | athlete
1 | A |  | 1 | B |  | 1 | E
2 | B |  | 2 | A |  | 2 | B
3 | C | → | 3 | C | → | 3 | A
4 | D |  | 4 | D |  | 4 | C
5 | E |  | 5 | E |  | 5 | D
6 | F |  | 6 | F |  | 6 | F
Spreadsheet: sally_beck__33873__EGM_MgmtSum-Q4-1214
Sheet: GrossMargin

PLAN2000
[NAME] | ENRON GLOBAL MARKETS
2000-12-01 00:00:00 | 4TH QUARTER 2000 DETAIL OF GROSS MARGIN
M.QTD
ENA
 |  |  |  |  |  |  |  | Actual | Deals | Forecast | Total | Margin
 | Business Team |  | DPR(1) | MPR | Accruals | Other | FTA | Margin | Identified | Margin | Margin | Plan | [NAME]
 | Liquids |  | -7526 | 0 | 0 |  | 0 |  |  | 0 |  | 30000
COAL | Coal |  | 8391 |  | 79.724 | 0 | 0 |  |  | 0
SO2 | Emissions |  | 6807 | 0 | 0 | 0 | 0 |  |  | 0
WEATHER | Weather |  | 3105 | 0 | 0 | 0 | 0 |  |  | 0
INSURANCE | Global Risk Markets |  | 0 | 0 | 0 | 0 | 0 |  |  | 0
ECT_INV_IRFX | Equity Trading |  | 50 | 0 | 0 | 0 | 0 |  |  | 0 |  | 0
ECT_INV_IRFX | Convertible Trading |  | -498 | 0 | 0 | 0 | 0 |  |  | 0 |  | 0
 | FX / Int Rate Trading |  | 2176 | 0 | 0 | 0 | 0 |  |  | 0 |  | 0
 | Soft Commodities Trading |  | -87 | 0 | 0 | 0 | 0 |  |  | 0 |  | 0
 | Grain Trading |  | 38 | 0 | 0 | 0 | 0 |  |  | 0 |  | 0
 | Meat Trading |  | -54 | 0 | 0 | 0 | 0 |  |  | 0 |  | 0
 | Financial Trading
 | Transportation |  | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  | 0
 | Office of the Chairman |  | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  | 0
 | Overview |  | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  | 10100
 | Subtotal Commercial
 | LNG |  | 0 | 0 |  | 0 | 0 |  |  | 0
 | Middle East |  | 0 | 0 | 132 | 0 | 0 |  |  | 0 |  | 4617
 | Puerto Rico |  | 0 | 0 | -3089 | 0 | 0 |  |  | 0 |  | 530
 | Subtotal LNG / ME / PR
 | Subtotal Gross Margin
 | Other Interest Related Charges |  | 0 | 0 | 0 | -520 | 0 |  |  | 0
 | EGM Gross Margin
 | (1) Excludes Cap. Charge & Operating Costs