tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 599353d1542984576-distribute-values-between-two-different-dates-copy-of-loan-calculation-work-sheet-version01-
Sheet: Master Loan Summary

Master Loan & Recovery  Summary |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sum
 | Branch Information-► |  |  |  |  | Customer Information-► |  |  |  |  |  |  | Loan Information -►
Serial No | Loan Code | Branch Name | Branch Code | Officer's Name | Officer Code | Customer Name | NIC No. | Customer Status | Main City | Contact No | Distance to Center(Km) | Nearest Town | Date of Loan | Loan Amount (Rs.) | [NAME] | Payment Method | Period (Days) | % Effective Interest | Total Interest | Total with Interest | No of Instmnts | Loan Instalment | Sum of Instalmnt Paid | Sum of Amount Paid | Bank Deposits | Remaining Instalmnt | Recovered Loan Amt. | Loan Balance | Recovered Interest Amt. | Interest Balance | Total Balance | Excess/Sshort | Recovery Efficiency | Customer Status2
Total
Spreadsheet: 556066f4-3c2c-4d56-a3e6-3e69473a0a1f
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: |  |  | 2013-12-31 09:19:41.010000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
5 | 102.625 | 102.5 | 102.375 | 102 |  | and are added to price quote
4.875 | 102.098 | 101.973 | 101.848 | 101.473
4.75 | 101.572 | 101.447 | 101.322 | 100.947 |  | Note: | Refer To Price [NAME]
4.625 | 100.783 | 100.658 | 100.533 | 100.158 |  |  | For all Price Adjs
4.5 | 99.792 | 99.667 | 99.542 | 98.917
4.375 | 98.754 | 98.629 | 98.504 | 97.879
4.25 | 98.159 | 98.034 | 97.909 | 97.284
4.125 | 97.289 | 97.164 | 97.039 | 96.414
4 | 96.213 | 96.088 | 95.963 | 95.338 |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4 | 102.388 | 102.263 | 102.138 | 101.763
3.875 | 101.651 | 101.526 | 101.401 | 101.026
3.75 | 100.906 | 100.781 | 100.656 | 100.281
3.625 | 100.513 | 100.388 | 100.263 | 99.888
3.5 | 99.936 | 99.811 | 99.686 | 99.061
3.375 | 99.17 | 99.045 | 98.92 | 98.295
3.25 | 98.366 | 98.241 | 98.116 | 97.491 |  | 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-01-14 09:19:41.010000
30 DAY | 2014-01-29 09:19:41.010000
45 DAY | 2014-02-13 09:19:41.010000
60 DAY | 2014-02-28 09:19:41.010000
90 DAY | 2014-03-30 09:19:41.010000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: darrell_schoolcraft__7827__imbalsumm0110
Sheet: summary

TRANSWESTERN  PIPELINE -   SUMMARY OF OBA BALANCES |  |  |  |  |  | index
 |  |  |  |  |  | SJ
Positive=due [NAME] |  | Negative = due operator |  |  |  | AVG
 |  |  |  |  |  | NTXPH
 |  | Equilavent
Operator | Dollars | Volume | Date | Imbal Type | MS rep | Comments
[NAME] |  |  |  | Dollar Valued | [NAME]
SoCal |  |  |  | Volumetric | [NAME]
EPFS / PG&E TX |  |  |  | Dollar Valued | [NAME]
CIG |  |  |  | Dollar Valued | [NAME] | if changed to volumetric the volume would be 61,000 mmbtus
Conoco |  |  |  | Dollar Valued | [NAME] | [NAME] and Maljamar
Amoco Abo |  |  |  | Dollar Valued | [NAME]
NNG |  |  |  | Dollar Valued | [NAME]
[NAME] |  |  |  | Volumetric | [NAME]
Mewborne |  |  |  | Dollar Valued | [NAME]
Mojave Pipeline |  |  |  | Volumetric | [NAME]
Red Cedar |  |  |  | Volumetric | [NAME]
PNM |  |  |  | Dollar Valued | [NAME]
NGPL |  |  |  | Volumetric | [NAME]
PG&E Topock |  |  |  | Volumetric | [NAME]
Lonestar |  |  |  | Volumetric | [NAME]
Northwest |  |  |  | Volumetric | [NAME]
Duke/GPM |  |  |  | Dollar Valued | [NAME] | Crawford, Pecos Diamond, [NAME], Linam Ranch, Artesia
Agave |  |  |  | Dollar Valued | [NAME]
Oasis |  |  |  | Volumetric | [NAME]
Amoco |  |  |  | Volumetric | [NAME]
EOG |  |  |  | Dollar Valued | [NAME]
TransColorado |  |  |  | Dollar Valued | [NAME]
Calpine |  |  |  | Dollar Valued | [NAME]
Panhandle Eastern |  |  |  | Volumetric | [NAME] | Hansford
Citizens-Griffith |  |  |  | Dollar Valued | [NAME]
Burlington |  |  |  | Dollar Valued | [NAME] | balance is cashed out monthly
Continental |  |  |  | Dollar Valued | [NAME]
[NAME] |  |  |  | Dollar Valued | [NAME] | cashed out monthly
Receivable imbalances
Operator | Dollars | Volume | Date | Imbal Type | MS rep | Comments
Citizens Communications |  |  |  | Dollar Valued | [NAME]
North Star Steel |  |  |  | Dollar Valued | [NAME]
El Paso Field Services |  |  |  | Dollar Valued | [NAME]
El Paso |  |  |  | Volumetric | [NAME] | Blanco and Window Rock
Payable imbalances
Net imbals
Note -  This report does not represent the total population of imbalances on Transwestern.
Spreadsheet: 888621d1739198011-tenor-need-to-increase-base-on-balance-installment-tenure-test_v2
Sheet: Loan_ID

Loan ID | Name | Loan Date | Interest  % | Loan Amount | Tenor |  | Helper
L001 | Nutan Vishal Bhagare | 2024-12-19 00:00:00 | 2 | 20000 | 4
L002 | Suvarna N Gaikwad | 2025-02-21 00:00:00 | 2 | 40000 | 6
L003 | Rajjaka A Waghmode | 2025-03-26 00:00:00 | 2 | 30000 | 2
L004 | Surkekha A Kirgat | 2025-04-27 00:00:00 | 2 | 50000 | 8
L005 | Kamble | 2024-12-31 00:00:00 | 2 | 10000 | 5
L006 | [NAME] | 2025-01-21 00:00:00 | 2 | 15000 | 8
L007 | [NAME] | 2025-01-26 00:00:00 | 2 | 25400 | 6
L008 | Sunita R Madne | 2025-01-27 00:00:00 | 2 | 36582 | 4
L009 | [NAME] | 2024-12-01 00:00:00 | 2 | 18000 | 7
L010 | [NAME] | 2025-01-21 00:00:00 | 2 | 365480 | 3
Spreadsheet: 92282d1291901335-lookup-for-specific-values-in-multiple-cells-export
Sheet: Customer Spec

ExtCustSpec | Ingredient | LowerLimit | UpperLimit
GG-15 UHC (WDB-BMW-001) | ALUMINIUM | 0.1 | 3
GG-15 UHC (WDB-BMW-001) | [NAME] | 0.1 | 3
GG-15 UHC (WDB-BMW-001) | COPPER | 0.1 | 3
GG-15 UHC (WDB-BMW-001) | LEAD | 0.1 | 3
GG-15 UHC (WDB-BMW-001) | MOLYBDENUM | 0.1 | 3
GG-15 UHC (WDB-BMW-001) | NICKEL | 0.1 | 3
GG-15 UHC (WDB-BMW-001) | PHOSPHORUS | 0.1 | 3
GG-15 UHC (WDB-BMW-001) | SULPHUR | 0.1 | 3
GG-15 UHC (WDB-BMW-001) | TITANIUM | 0.1 | 3
GG-15 UHC (WDB-BMW-001) | V + SN + TI | 0.1 | 0
GG-15 UHC (WDB-BMW-001) | MANGANESE | 0.5 | 3
GG-15 UHC (WDB-BMW-001) | SILICON | 1.8 | 3
GG-15 UHC (WDB-BMW-001) | CARBON | 2.8 | 3
GG-15 UHC (WDB-BMW-001) | HBW SPREAD | 150 | 200
GG-15 UHC (WDB-BMW-001) | TENSILE | 150 | 0
GG-15 UHC (WDB-BMW-001) | Wedge Pen Test | 150 | 0
GG-15 UHC (WDB-BMW-001) | HBW | 160 | 200
[NAME] Mo Cr (WDB-PO-003) | NICKEL | 0 | 0.1
[NAME] Mo Cr (WDB-PO-003) | PHOSPHORUS | 0 | 0.1
[NAME] Mo Cr (WDB-PO-003) | SULPHUR | 0 | 0.08
[NAME] Mo Cr (WDB-PO-003) | MOLYBDENUM | 0.1 | 0.4
[NAME] Mo Cr (WDB-PO-003) | [NAME] | 0.15 | 0.3
[NAME] Mo Cr (WDB-PO-003) | COPPER | 0.25 | 0.5
[NAME] Mo Cr (WDB-PO-003) | MANGANESE | 0.65 | 0.8
[NAME] Mo Cr (WDB-PO-003) | SILICON | 1.8 | 2.2
[NAME] Mo Cr (WDB-PO-003) | CARBON | 3.5 | 3.9
[NAME] Mo Cr (WDB-PO-003) | HBW SPREAD | 150 | 200
[NAME] Mo Cr (WDB-PO-003) | TENSILE | 150 | 200
[NAME] Mo Cr (WDB-PO-003) | Wedge Pen Test | 150 | 200
[NAME] Mo Cr (WDB-PO-003) | HBW | 160 | 200
[NAME] (ATE N 553 71.01) | PHOSPHORUS | 0 | 0.12
[NAME] (ATE N 553 71.01) | SULPHUR | 0 | 0.1
[NAME] (ATE N 553 71.01) | MANGANESE | 0.5 | 0.8
[NAME] (ATE N 553 71.01) | SILICON | 1.8 | 2.8
[NAME] (ATE N 553 71.01) | CARBON | 3.7 | 0
[NAME] (ATE N 553 71.01) | HBW SPREAD | 150 | 200
[NAME] (ATE N 553 71.01) | TENSILE | 150 | 200
[NAME] (ATE N 553 71.01) | Wedge Pen Test | 150 | 200
[NAME] (ATE N 553 71.01) | HBW | 160 | 200
Spreadsheet: 63001d1263982171-sumproduct-sumif-within-2-times-fleet-example
Sheet: Sheet1

Registration | start time | Reached Location | [NAME]
LS57UHG | 06:09:27 | Huddersfield | 29.82
KB52YTH | 21:13:28 | [NAME] | 58.43
PK58TYR | 05:26:31 | Reading | 98.57
LG57UHG | 04:09:30 | Twyford | 23.4
KB52YTH | 06:09:31 | [NAME] | 98.45
KB52YTH | 12:09:32 | [NAME] | 201.75
PK58TYR | [NAME] | [NAME] | 76.12
PK58TYR | 22:23:40 | Reading | 13.21
LG57UHG | 19:09:35 | Derby | 82.42
Spreadsheet: 129596d1321727333-applying-name-range-excel-2007-lowestpricesexcludingshanghai1
Sheet: Final Cost

Wild Match on Part Code |  |  | All Matching Parts - Priced Low - High
Part Code
AAA1
BBB1
CCC1
CCC
 |  |  | Trying to get the data below to show the same as results above but by applying  'named ranges' from Raw Data and not the existing column references.
 |  |  | All Matching Parts - Priced Low - High (with data specified by named dynamic range)
Spreadsheet: 98530d1297384218-formula-for-chronologically-aligning-days-of-the-week-xa-test-total-cat-inv-combine-total-names-for-excel-study-
Sheet: Totals

 |  |  | TOTAL PER CATEGORY |  |  |  |  |  |  |  |  |  | TOTAL |  |  |  |  | MON |  |  |  |  |  |  |  |  | TUE |  |  |  |  |  |  |  |  | WED |  |  |  |  |  |  |  |  | THU |  |  |  |  |  |  |  |  | FRI |  |  |  |  |  |  |  |  | SAT |  |  |  |  |  |  |  |  | SUN
 | job number / EC
 | Name |  | reg hr | ot hr | n/c hr | [NAME] | mob hr | [NAME] | mob mile | per diem | trnch ft |  | reg hr | ot hr | total hr | mile |  | reg hr | ot hr | n/c hr | [NAME] | mob hr | [NAME] | mob mile | per diem | trnch ft | reg hr | ot hr | n/c hr | [NAME] | mob hr | [NAME] | mob mile | per diem | trnch ft | reg hr | ot hr | n/c hr | [NAME] | mob hr | [NAME] | mob mile | per diem | trnch ft | reg hr | ot hr | n/c hr | [NAME] | mob hr | [NAME] | mob mile | per diem | trnch ft | reg hr | ot hr | n/c hr | [NAME] | mob hr | [NAME] | mob mile | per diem | trnch ft | reg hr | ot hr | n/c hr | [NAME] | mob hr | [NAME] | mob mile | per diem | trnch ft | reg hr | ot hr | n/c hr | [NAME] | mob hr | [NAME] | mob mile | per diem | trnch ft
1
 | Total
Spreadsheet: 16769c99-e10e-4ac2-a396-9b587a04c605
Sheet: Sheet1

Table 8--U.S. cotton textile imports, by origin | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
 | Jan. | Feb. | Mar. |  | Mar.
Region/country | 2013 | 2013 | 2013 |  | 2012
 | 1,000 pounds 1/
North America | 104814.416 | 132256.313 | 143308.444 |  | 146200.657
Canada | 2959.098 | 2724.511 | 2852.062 |  | 3013.699
Costa Rica | 199.368 | 788.641 | 687.865 |  | 933.337
Dominican Republic | 3981.692 | 6358.245 | 6838.911 |  | 5656.268
El Salvador | 13232.068 | 18308.671 | 20297.836 |  | 24492.759
Guatemala | 6580.228 | 7761.34 | 8251.197 |  | 8462.537
Haiti | 8448.22 | 12292.378 | 13662.017 |  | 10777.346
Honduras | 17598.227 | 28209.277 | 31598.707 |  | 30571.623
Mexico | 38789.236 | 42105.729 | 40749.508 |  | 46393.078
Nicaragua | 13025.862 | 13652.658 | 18363.675 |  | 15883.632
South America | 5059.74 | 3865.94 | 5341.988 |  | 4268.91
Brazil | 93.478 | 131.639 | 163.117 |  | 253.243
Colombia | 1794.295 | 1663.199 | 2465.582 |  | 1300.023
Peru | 3129.484 | 2020.194 | 2675.035 |  | 2626.16
Europe | 10660.673 | 10037.095 | 11153.073 |  | 10347.688
Germany | 863.799 | 958.4 | 1009.684 |  | 887.703
Italy | 1686.528 | 1448.906 | 1651.119 |  | 1827.87
Portugal | 1194.01 | 1107.773 | 1106.525 |  | 902.136
Turkey | 4847.443 | 4480.481 | 4728.641 |  | 3974.438
Asia | 547968.57 | 521706.88 | 429782.725 |  | 421609.709
Bahrain | 1166.533 | 1331.887 | 1536.084 |  | 2258.377
Bangladesh | 52851.101 | 51746.584 | 51585.066 |  | 47769.866
Cambodia | 18211.497 | 17091.386 | 17790.319 |  | 17767.221
China | 234106.926 | 229485.161 | 128014.848 |  | 134308.764
Hong Kong | 877.38 | 811.289 | 761.378 |  | 441.449
India | 60273.695 | 58861.543 | 66365.713 |  | 63429.223
Indonesia | 32741.73 | 29632.134 | 29048.129 |  | 27795.877
Israel | 888.908 | 792.455 | 774.485 |  | 1010.812
Japan | 992.684 | 914.717 | 1166.333 |  | 1080.361
Jordan | 4267.479 | 4332.655 | 4065.946 |  | 3655.329
Malaysia | 3207.3 | 2963.467 | 2651.68 |  | 1976.96
Pakistan | 64598.634 | 52624.61 | 61731.93 |  | 58093.126
Philippines | 4982.837 | 4892.683 | 5084.08 |  | 4550.212
South Korea | 5997.976 | 5039.854 | 4852.106 |  | 5388.654
Sri Lanka | 7697.095 | 6420.051 | 7296.354 |  | 7107.409
Taiwan | 2664.392 | 2471.331 | 1655.188 |  | 2733.773
Thailand | 6680.908 | 6658.897 | 5856.408 |  | 6009.728
Vietnam | 44721.133 | 44717.441 | 38617.097 |  | 35179.391
Oceania | 26.855 | 10.305 | 29.158 |  | 69.931
Africa | 16080.987 | 11443.885 | 14575.522 |  | 14155.153
Egypt | 8995.577 | 6835.211 | 8556.056 |  | 7746.188
Kenya | 1693.832 | 1250.237 | 1985.906 |  | 2188.02
[NAME] | 3032.771 | 1522.063 | 2245.999 |  | 2301.346
[NAME] | 892.035 | 726.662 | 703.699 |  | 729.665
World 2/ | 684611.241 | 679320.418 | 604190.911 |  | 596652.049
 |  |  |  |  |  |  |  | 95
1/ Raw-fiber equivalent.  2/ Totals may not add due to rounding.
Sources: USDA, Economic Research Service; and
U.S. Dept. of Commerce, U.S. Census Bureau.
Last update:  05/14/13.
Spreadsheet: 853813d1703779539-multiple-column-search-criteria-3-pigs
Sheet: Sheet1

 |  |  | Little Pig 1's House |  |  |  |  | Little Pig 2s's House |  |  |  | Little Pig 3s's House
 |  |  | Living Room | Hall | Bathroom | Kitchen |  | Living Room | Bathroom | Kitchen |  | Living Room
 |  |  | Chair | Light | Wc | Cooker |  | Chair | Wc | Cooker |  | Couch
 |  |  | Couch | Lamp | Bath | Sink |  | Lamp | Bath | Sink |  | Lamp
 |  |  | Lamp | Stand | Shower |  |  | Table |  |  |  | Table
 |  |  | Table
Spreadsheet: 03c9e2f4-d582-4110-a2f2-e7ee7aad35ff
Sheet: Sheet1

Additional File 1: Targets of upregulated microRNA: Predicted mRNA targets of upregulated miRNAs in ccRCC.
microRNA | Gene target | P-value | [NAME]
miR-185 | PTPN13 | 0.000612 | Protein tyrosine phosphatase, non-receptor type 13 (APO-1/CD95 (Fas)-associated phosphatase)
miR-185 | PTEN | 0.0006932 | phosphatase and tensin homolog (mutated in multiple advanced cancers 1)
miR-21 | SLC12A1 | 0.0012473 | solute carrier family 12 (sodium/potassium/chloride transporters), member 1
miR-185 | NTN4 | 0.0024651 | netrin 4
miR-21 | TCF21 | 0.003395 | transcription factor 21
miR-185 | KCNJ16 | 0.0038685 | potassium inwardly-rectifying channel, subfamily J, member 16
miR-224 | ERBB4 | 0.0045935 | v-erb-a erythroblastic leukemia viral oncogene homolog 4 (avian)
miR-142-3p | LRRC2 | 0.004906 | leucine rich repeat containing 2
miR-185 | [NAME] | 0.0049827 | doublecortin domain containing 2
miR-34a | SFRP1 | 0.0050746 | secreted frizzled-related protein 1
miR-34a | CAMTA1 | 0.0056181 | [NAME] transcription activator 1
Spreadsheet: 747814d1631714449-adding-specific-data-from-one-worksheet-to-another-interchange-spreadsheet
Sheet: Sheet1

#1 Interchange PN | #2 Compressed Part Number | #2 Catalog Part Number | Invoice Price - Effective 07/15/2021
42013 | LX1005 | LX 1005
42015 | LX677 | LX 677
42023 | LX3214 | LX 3214
42052 | LX781 | LX 781
42054 | LX2549 | LX 2549
42086 | LX3088 | LX 3088
42098 | LX2552 | LX 2552
42106 | LX264 | LX 264
42133 | [NAME] | LX 259
42156 | LX2942 | LX 2942
42159 | LX1140 | LX 1140
42164 | LX1955 | LX 1955
42165 | LX190 | LX 190
42168 | LX500 | LX 500
42168 | LX501 | LX 501
42170 | LX218 | LX 218
42170 | LX54 | LX 54
42174 | [NAME] | LX 114
42177 | LX686 | LX 686
Spreadsheet: 875787d1722404775-show-dots-in-ip-adresses-show-points-in-ip-addresses
Sheet: vergelijking IP-adressen

IP-adressen X | =SUBSTITUTE(A2,CHAR(160),"")
185177124193
92.64.43.131
Spreadsheet: 306e0d59-60fd-4d51-ad9d-cb82c1befde1
Sheet: Reading Gr. 4

2012 Minnesota Comprehensive Assessments-Series II (MCA-II)
[NAME]
Raw Score | Scale Score | Level | Percentile Rank
0 | 401 | D | 1
1 | 401 | D | 1
2 | 401 | D | 1
3 | 401 | D | 1
4 | 401 | D | 1
5 | 401 | D | 1
6 | 401 | D | 1
7 | 401 | D | 1
8 | 406 | D | 1
9 | 412 | D | 1
10 | 417 | D | 1
11 | 420 | D | 1
12 | 423 | D | 2
13 | 425 | D | 2
14 | 427 | D | 3
15 | 429 | D | 4
16 | 431 | D | 5
17 | 433 | D | 6
18 | 434 | D | 6
19 | 436 | D | 8
20 | 437 | D | 9
21 | 439 | D | 10
22 | 440 | P | 11
23 | 441 | P | 12
24 | 443 | P | 14
25 | 444 | P | 15
26 | 445 | P | 17
27 | 446 | P | 19
28 | 448 | P | 21
29 | 449 | P | 23
30 | 450 | M | 26
31 | 452 | M | 29
32 | 453 | M | 32
33 | 455 | M | 36
34 | 456 | M | 40
35 | 458 | M | 44
36 | 459 | M | 48
37 | 461 | M | 53
38 | 464 | E | 59
39 | 465 | E | 64
40 | 467 | E | 70
41 | 470 | E | 77
42 | 473 | E | 82
43 | 477 | E | 88
44 | 482 | E | 93
45 | 491 | E | 97
46 | 499 | E | 99
Spreadsheet: 549576d1511800749-why-is-there-a-variance-here-for-total-year-variance
Sheet: Sheet1

 | JAN 2017 | FEB 2017 | MAR 2017 | APR 2017 | MAY 2017 | JUN 2017 | JUL 2017 | AUG 2017 | SEP 2017 | OCT 2017 | NOV 2017 | DEC 2017 | TOTAL 2017
Employee A | 742666.1233410082 | 813949.0005859714 | 953371.2315528995 | 799387.5319462308 | 822508.4119924988 | 955488.5257095351 | 785237.7277418305 | 746465.5188081894 | 982699.0170330144 | 807691.8904049682 | 733537.5393582032 | 1007731.421170712 | 10150733.93964505
Employee B | 306911.0468597781 | 318286.7646447081 | 397916.7891392176 | 318286.7646447081 | 314331.5713007081 | 389998.1223481076 | 311951.8312118194 | 311951.8312118194 | 389998.1223481076 | 311951.8312118194 | 318286.7646447081 | 420668.2247090803 | 4110539.664274597
% Employee A
Total Benefits | 242877.8828025221 | 236799.8103224953 | 288707.8149107003 | 246898.6837987141 | 230567.4859968615 | 282583.1754817075 | 227069.7419900518 | 205134.7433238657 | 273871.938356843 | 218551.2100150433 | 211511.4025813499 | 296022.3640098977 | 2960596.253590052
Employee A Allocated Benefits
Spreadsheet: benjamin_rogers__1204__Retail Shorts version Debt-Equity 60-40 version2-Jin
Sheet: Options

Spread Option Model
70% Correlation
Revenue
Capacity Prices ($/kW-mo.) Old Version |  | 4.31 | 4.22 | 4.13 | 4.13 | 4.12 | 4.12 | 4.15 | 4.16 | 4.25 | 4.28
Capacity Prices ($/kW-mo.) New Version |  | 3.88 | 3.77 | 3.72 | 3.73 | 3.74 | 3.79 | 3.83 | 3.86 | 3.96 | 3.98
 | Adj.
Energy Prices (Drop in from Structuring) OLD | 0
Energy Prices (Drop in from Structuring) NEW |  | 15206.799 | 15739.444 | 16041.814 | 16456.276 | 16683.26 | 16872.563 | 17029.12 | 17170.03 | 17245.233 | 17360.898
Expenses:
Fuel |  | 14580.003 | 14997.487 | 15203.159 | 15546.749 | 15741.839 | 15910.637 | 16076.874 | 16234.955 | 16321.38 | 16456.793
VOM |  | 964.937 | 998.733 | 996.896 | 999.426 | 992.701 | 982.097 | 972.29 | 960.905 | 946.085 | 937.004
60% Correlation
Revenue
Capacity Prices ($/kW-mo.) |  | 4.08 | 3.98 | 3.95 | 3.99 | 4.02 | 4.06 | 4.12 | 4.16 | 4.28 | 4.3
Energy Prices (Drop in from Structuring) |  | 16212.969 | 16706.766 | 17054.9 | 17542.91 | 17820.479 | 17994.331 | 18236.171 | 18473.848 | 18632.525 | 18794.406
50% Correlation
Revenue
Capacity Prices ($/kW-mo.) |  | 4.26 | 4.18 | 4.17 | 4.23 | 4.28 | 4.31 | 4.39 | 4.45 | 4.58 | 4.61
Energy Prices (Drop in from Structuring) |  | 17052.152 | 17515.978 | 17901.733 | 18445.41 | 18763.184 | 18931.931 | 19238.37 | 19549.836 | 19771.198 | 19970.676
[NAME]% Change
MWh | Adj. | 444454.18 | 780058.98 | 853098.52 | 895576.95 | 890978.86 | 884420.04 | 829190.78 | 839458.88 | 829528.9 | 563847.9
Annual Cost (000)
[NAME] Change
MWh
Annual Cost (000) |  | 16603.743 | 26982.556 | 29547.085 | 31028.184 | 30945.183 | 30859.377 | 28915.243 | 29483.268 | 29582.159 | 21651.078
[NAME]
MWh
Annual Cost (000) |  | 13584.88 | 22076.636 | 24174.888 | 25386.696 | 25318.786 | 25248.581 | 23657.926 | 24122.674 | 24203.584 | 17714.518
Spreadsheet: 59348d1259845504-vlookup-multiple-rows-with-the-same-lookup-value-book2_dec3
Sheet: Sheet1

[NAME] | 25 | 1 |  |  |  | Lookup: | [NAME] |  | Count: | 3
[NAME] | 40 | 1 |  |  |  |  | [NAME] | 25
[NAME] | 57 | 1 |  |  |  |  | [NAME] | 68
[NAME] | 68 | 2 |  |  |  |  | [NAME] | 902
[NAME] | 902 | 3
[NAME] | 11 | 3
[NAME] | 3 | 3
Spreadsheet: 83424d1283409520-excel-2007-a-question-about-logic-and-looks-water10
Sheet: Data

Date | C25 | C46 | M25 | M45 | Total Sale
2010-09-01 00:00:00 | 33 | 10 | 0 | 3 | 14.1
2010-09-01 00:00:00 | 5 | 0 | 0 | 0 | 1.25
2010-09-01 00:00:00 | 0 | 455 | 16 | 6 | 211.45
2010-09-01 00:00:00 | 0 | 0 | 0 | 5 | 2.25
[NAME]
Spreadsheet: aebc4769-8c0f-4da6-bef9-7435aca09a3e
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
CDAB | Test | CDAB | Candida albicans (Monilia), IgE | [NAME]), IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m. - 8 p.m., Saturday; 8 a.m. - 3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
CDAB | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
CDAB | Result | CDAB | [NAME]), IgE | [NAME]), IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6059-0
Spreadsheet: 783334d1654732521-vlookup-photos-from-another-tab-test-fruit-photo-estimate
Sheet: Estimate

Photo | SKU | Description | Price
 | 1111
Spreadsheet: 767214d1644340352-allocate-amount-into-monthly-columns-formula-fails-for-specific-years-networkdays-issue-allocation1
Sheet: Logic

Logic
Click Consulting
Exercise | Days logic
Overview
 | There are many different ways to compute the number of days.
 | The approach below attempts to strike a balance between formula length and readability.
 | 2013-11-30 00:00:00 | 2013-01-01 00:00:00 | 2014-01-31 00:00:00 | 2014-02-28 00:00:00 | 2014-03-31 00:00:00 | 2014-04-30 00:00:00 | 2014-05-31 00:00:00 | 2014-06-30 00:00:00
 | • | ◊ | • | • | ◊ | • | • | •
 |  | A
 |  | B
 |  | C
 |  | D
 |  | E
 |  | F
[NAME]
 | Start | End | Current | Target | A | B | C=A-B | D | E | [NAME] | C-F | Day1 Adj | Combined
 | 2014-01-01 00:00:00 | 2014-03-31 00:00:00 | 2014-01-31 00:00:00 | 31
 | 2014-01-01 00:00:00 | 2014-03-31 00:00:00 | 2014-02-28 00:00:00 | 28
 | 2014-01-01 00:00:00 | 2014-03-31 00:00:00 | 2014-03-31 00:00:00 | 31
 | 2014-01-01 00:00:00 | 2014-03-31 00:00:00 | 2014-04-30 00:00:00 | 0
 | 2014-01-01 00:00:00 | 2014-03-31 00:00:00 | 2014-05-31 00:00:00 | 0
 | 2014-01-15 00:00:00 | 2014-04-15 00:00:00 | 2014-01-31 00:00:00 | 17
 | 2014-01-15 00:00:00 | 2014-04-15 00:00:00 | 2014-02-28 00:00:00 | 28
 | 2014-01-15 00:00:00 | 2014-04-15 00:00:00 | 2013-12-31 00:00:00 | 0
 | 2014-01-15 00:00:00 | 2014-04-15 00:00:00 | 2014-04-30 00:00:00 | 15
 | 2016-01-01 00:00:00 | 2016-03-31 00:00:00 | 2014-01-31 00:00:00 | 0
 | 2012-01-01 00:00:00 | 2012-03-31 00:00:00 | 2014-01-31 00:00:00 | 0