tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 165295d1341149254-link-row-data-to-column-rows-from-cols
Sheet: Sheet1

25
27
45
46
2
9
17
34
888
4989
25 |  |  | 25 |  |  | 27 |  |  | 45 |  |  | 46 |  |  | 2 |  |  | 9 |  |  | 17 |  |  | 34 |  |  | 888 |  |  | 4989
Spreadsheet: 471685d1469131700-creating-test-scenarios-from-requirements-final-testing-scenarios
Sheet: Master

Segment 1 | Responsibility Centre | Approval Limit | Currency | Project | Funds | Delgation
Entity 10 | RC 1 | Approver $250 | CDN | PMO Project Only | Fund Advisor | Delegated
Entity 20 | RC 2 | Approver $5000 | USD | Non PMO |  | Not Delegated
Entity 30 | RC 3 | Approver $10,000 |  | PMO
 | RC 4 | Approver $50,000
 | RC 5 | Approver $100,000
 |  | Approver $250,000
 |  | Approver $500,000
 |  | Approver $1,000,000
Spreadsheet: 792688d1661079965-need-to-flatten-many-column-ranges-into-one-row-easily-2022-08-21-oeldere-codyg-excel_forum_flatten_problem_sample
Sheet: Sheet1

Sample Data Set
name | [NAME] | name3
[NAME] | [NAME] | [NAME]
Pancakes | Eggs | Cereal
Sandwich | Hamburger | Sandwich
Porkchops | Pasta | Chicken
How I Do NOT Want Flatten To Work |  |  |  |  | How I DO Need Flatten to Work (Across 500+ columns with ranges like A2:A5, B2:[NAME], and on and on):
[NAME] |  |  |  |  | [NAME]
[NAME] |  |  |  |  | Pancakes
[NAME] |  |  |  |  | Sandwich
Pancakes |  |  |  |  | Porkchops
Eggs |  |  |  |  | [NAME]
Cereal |  |  |  |  | Eggs
Sandwich |  |  |  |  | Hamburger
Hamburger |  |  |  |  | Pasta
Sandwich |  |  |  |  | [NAME]
Porkchops |  |  |  |  | Cereal
Pasta |  |  |  |  | Sandwich
Chicken |  |  |  |  | Chicken
Spreadsheet: c9538a55-037b-4528-b98f-b5ca90b15292
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
259508 | 65445 | Marleide | [NAME] B1 | BRA | 3 | 00:23:18 | 00:02:06 | 00:40:49 | 00:01:15 | 00:33:57 | 1 | 01:41:27
Spreadsheet: 882476d1730873639-costing-query-forum-support-1
Sheet: Project Cost

[NAME]
Project Name | Item Name | Unit Cost | Tool Price Per Use | Sq Centimeters Used | Cost per Sq cm | Total Unit Amount | Total Project Cost
Christmas Cards | Cardstock pack - Primary Colours |  |  | 0.1
 | Cardstock pack - Browns/tans |  |  | 0.3
 | Cardstock pack - Greens |  |  | 4.3
 | Cricut
 | 36pcs Vibrant Multicolour Fine Point Dual Tip Pens |  |  | 0
 | Scoring Wheel Housing
 | Green/Cardstock Mat
 | [NAME] |  |  | 0.5
Birthday Card | Cardstock pack - Browns/tans
 | Frenchville - Cardstock pack - Black
 | Frenchville - Cardstock pack - white
 | [NAME]
 | 36pcs Vibrant Multicolour Fine Point Dual Tip Pens
 | Cricut
 | Green/Cardstock Mat
 | [NAME] |  |  | 0.2
Spreadsheet: 887960d1738268531-how-to-extend-sumifs-to-new-data-how-to-append-items-into-a-list-excel-forum-sumifs-help-questions
Sheet: Sheet1

Order Number | Name | Amount | Order Items | Total NUMBER  Orders from person | Total REVENUE from person | All Order Items Ever List
1 | AA | 110 | A, B |  |  | A,B,D,E,F,G,H
2 | BB | 130 | C,A
3 | AA | 120 | D,E
4 | CC | 80 | F
5 | BB | 80 | F
6 | CC | 140 | G, H
7 | AA | 80 | F
8 | AA | 140 | G,H
9 | BB | 80 | F
10 | DD | 50 | I
Spreadsheet: 786552d1657265499-how-do-i-sort-the-data-randomly-by-date-sort-with-respect-to-date
Sheet: Sheet1

Date: | 2022-01-07 00:00:00
Sl. | Name | Room assigned
1 | Name-1 | 318
2 | [NAME] | 317
3 | Name-3 | Lab-1
4 | Name-4 | Lab-2
5 | Name-5 | 201
 |  | Source of Room
 |  | 318
 |  | 317
 |  | Lab-1
 |  | Lab-2
 |  | 201
Spreadsheet: 835879d1688948456-is-it-possible-to-link-groups-of-data-to-one-cell-monthly-cash-flow-test
Sheet: Sheet1

 | January | February | March | April | May | June | July | August | September | October | November | December
Cash In | 20 | 57 | 41 | 68 | 15 | 130 | 175 | 41 | 90 | 10 | 1000 | 6700
Cash Out | 15 | 75 | 23 | 159 | 650 | 25 | 39 | 67 | 89 | 90 | 290 | 4200
Net Cash after month end
Spreadsheet: 182775d1348599822-pivot-table-grouping-columns-together-and-obtaining-a-subtotal-groupingpivottables
Sheet: Sheet1

Name | Year | Division | Jan-Hours | Jan-Overtime | Feb-Hours | Feb-Overtime
A | 2006 | 1 | 38 | 0.4 | 32.8 | 7.600000000000001
B | 2006 | 1 | 34 | 9.1 | 39.6 | 6.600000000000001
C | 2006 | 1 | 39.2 | 1.4 | 36.4 | 9.3
D | 2006 | 1 | 35.6 | 4.7 | 38.8 | 3.4
E | 2006 | 1 | 36.4 | 4.100000000000001 | 36.8 | 1.7
F | 2006 | 1 | 36.8 | 2.3 | 38 | 7.5
G | 2006 | 1 | 38.8 | 2.2 | 38.8 | 6.4
H | 2006 | 1 | 36.4 | 3.5 | 34.8 | 3.5
I | 2006 | 1 | 36.8 | 8 | 33.6 | 7.5
J | 2006 | 1 | 37.2 | 2.2 | 39.6 | 8.9
K | 2006 | 2 | 39.2 | 1.4 | 36.4 | 8.700000000000001
L | 2006 | 2 | 39.2 | 8.200000000000001 | 39.6 | 4
M | 2006 | 2 | 33.6 | 4.5 | 38.8 | 6.800000000000001
N | 2006 | 2 | 40 | 8.5 | 32 | 5.9
O | 2006 | 2 | 35.2 | 6.4 | 36.8 | 0.1
P | 2006 | 2 | 37.2 | 1.4 | 38.8 | 9.700000000000001
Q | 2006 | 2 | 34 | 6.100000000000001 | 40 | 8.5
R | 2006 | 2 | 34.8 | 4.2 | 39.6 | 8.3
S | 2006 | 2 | 37.2 | 3.4 | 32.8 | 7.2
Spreadsheet: 735346d1622879137-cell-value-multiplication-by-criteria-prob
Sheet: Sheet1

No | Part Number | Description | QTY | Mass | Bounding Box  Length | Bounding Box  Width | Sheet Metal  Thickness | Total QtY
1 | [NAME] |  | 3 | 1.12
1.1 |  | Lakštas | 1 | 0.08 | 82.6 | 82.6 | 2 | 3
1.2 |  | Lakštas | 3 | 0.21 | 128.7 | 128.7 | 2 | 9
1.3 |  | Lakštas | 1 | 0.42 | 412.6 | 42 | 3 | 3
2 | TOT_Part |  | 5 | 0.07
2.1 |  | Lakštas | 1 | 0.07 | 92.1 | 30 | 3 | 5
Spreadsheet: 119950d1314884799-excel-mac-2011-merging-data-p-and-l-excel-forum
Sheet: Sheet5

 |  |  |  |  |  |  | 5:27 PM
 |  |  |  |  |  |  | 2011-08-30 00:00:00
 |  |  |  |  |  |  | Accrual Basis
 |  |  |  |  | Jun 11 |  | May 11
 | Ordinary Income/Expense
 |  | Income
 |  |  | Patient Fees |  | 194987.25 |  | 162335.16
 |  |  | Medicare/Medicaid/Workers Comp |  | 240972.87 |  | 216349.88
 |  |  | Tricare |  | 991.02 |  | 652.95
 |  |  | Forest [NAME] |  | 58738.52 |  | 59113.03
 |  |  | Subsidy |  | 12000 |  | 0
 |  |  | Refunds |  | -519.02 |  | -652.47
 |  |  | NSF Checks |  | -26.55 |  | 0
 |  | Total Income |  |  | 507144.09 |  | 437798.55
 |  | Expense
 |  |  | Bank Service Charges |  | 147.09 |  | 163.82
 |  |  | Billing Fees |  | 21290.85 |  | 18388.81
 |  |  | Business Meals & Entertainment |  | 28.07 |  | 0
 |  |  | Collection Fees |  | 371.02 |  | 0
 |  |  | Delivery & Freight |  | 161.5 |  | 160
 |  |  | Fees Expense |  | 0 |  | 150
 |  |  | Insurance - Health |  | 13267.42 |  | 11199.93
 |  |  | Insurance - Malpractice |  | 10256 |  | 10256
 |  |  | Insurance - Overhead |  | 47.65 |  | 47.65
 |  |  | Legal Expense |  | 0 |  | 1950.92
 |  |  | Manager's Salary |  | 12250 |  | 10500
 |  |  | Office Supplies |  | 88.03 |  | 175.93
 |  |  | Online Services |  | 12.95 |  | 12.95
 |  |  | Outside Services |  | 438 |  | 0
 |  |  | Payroll Expenses
 |  |  |  | Managing Director [NAME] | 7000 |  | 3500
 |  |  |  | Nurse Prac Salary | 8333.34 |  | 0
 |  |  |  | Admin Salary Expense | 7845 |  | 7505.28
 |  |  |  | Health Ins Stipend - Staff | 110.5 |  | 110.5
 |  |  |  | Health Insurance - Staff | 1696.92 |  | 376.76
 |  |  |  | Less Reimbursement | -1815.25 |  | -1801.3
 |  |  |  | Mileage Reimbursement | 59.52 |  | 29.76
 |  |  |  | Payroll Tax Expense | 1973.5 |  | 905.65
 |  |  |  | [NAME] | 1591.1 |  | 1523.16
 |  |  |  | Payroll Expenses - Other | 43.19 |  | 19.73
 |  |  | Total Payroll Expenses |  | 26837.82 |  | 12169.54
 |  |  | Postage and Delivery |  | 299.28 |  | 484.34
 |  |  | Professional Fees |  | 3346.25 |  | 2897.5
 |  |  | Recruiting Expense |  | 350 |  | 0
 |  |  | Rent |  | 1000 |  | 1000
 |  |  | Signing Bonus-Dr's |  | 0 |  | 11000
 |  |  | [NAME] |  | 2545 |  | 2545
 |  |  | Telephone & Pagers |  | 908.22 |  | 972.04
 |  |  | Voice Mail System |  | 917.8 |  | 963.4
 |  |  | Void Checks |  | 0 |  | 0
 |  |  | Allocable Expenses |  | 0 |  | 0
 |  | Total Expense |  |  | 94562.95 |  | 85037.83
 | Net Ordinary Income |  |  |  | 412581.14 |  | 352760.72
 | Other Income/Expense
 |  | Other Expense
 |  |  | Contract Labor-Doctors' |  | 197259.36 |  | 191673.23
 |  |  | Guaranteed Payments-Members
 |  |  |  | Base Pay | 157135.33 |  | 140699.09
 |  |  |  | 10% Allocation | 18338.78 |  | 2590.29
 |  |  |  | Partner Allocation | 39847.67 |  | 17798.11
 |  |  | Total Guaranteed Payments-Members |  | 215321.78 |  | 161087.49
 |  | Total Other Expense |  |  | 412581.14 |  | 352760.72
 | Net Other Income |  |  |  | -412581.14 |  | -352760.72
Net Income |  |  |  |  | 0 |  | 0
Spreadsheet: 540275d1506606447-dropdown2-combobox2-list-will-update-based-on-combobox1-dropdown1-value-sample-workbook
Sheet: Sheet2

 | Name | Class
 | Huey Sircy | Class 1 a
 | [NAME] | Class 2 b
 | [NAME] | Class 3 c
 | [NAME] | Class 1 a
 | [NAME] | Class 2 b
 | [NAME] | Class 3 c
 | Corrie Cupples | Class 1 a
 | [NAME] | Class 2 b
 | [NAME] | Class 3 c
 | [NAME] | Class 1 a
 | [NAME] | Class 2 b
 | [NAME] | Class 3 c
 | Carroll Paulsen | Class 1 a
 | [NAME] | Class 2 b
 | [NAME] | Class 3 c
 | [NAME] | Class 1 a
 | [NAME] | Class 2 b
 | [NAME] | Class 3 c
 | [NAME] | Class 1 a
 | Teresita Blackwater | Class 2 b
 | [NAME] | Class 3 c
 | [NAME] | Class 1 a
 | [NAME] | Class 2 b
 | [NAME] | Class 3 c
Spreadsheet: 825797d1681539203-two-columns-merged-into-vertical-cells-two-columns-merged-into-vertical-cells-v2
Sheet: Sheet1

Apple | Cat 1 |  | Apple
Pear |  |  | Pear
Grapes |  |  | Grapes
 |  |  | Cat 1
Pears | Cat 1 |  | Pears
Apples |  |  | Apples
Grapes |  |  | Grapes
 |  |  | Cat 1
Mango |  |  | Mango
Avocado |  |  | Avocado
Carrots | Cat 1 |  | Carrots
Brocolli |  |  | Brocolli
Lettuce |  |  | Lettuce
Cabbage |  |  | Cabbage
 |  |  | Cat 1
Peanuts |  |  | Peanuts
Walnuts |  |  | Walnuts
Spreadsheet: 295593d1391732449-need-to-find-a-value-in-a-column-example-excel-forum-jan28
Sheet: Sheet1

 |  | MODEL | ZIP CODE |  | PAYMENT
ACCOUNT | CUSTOMER |  |  | FEE
XXX123 | 1A | 3 | 12345 | Y | 23
WWW123 | 2B | 5 | 12345 | Y | 44
EEE123 | 3C | 4 | 12345 | Y | 567
TRE432 | 4D | 6 | 12345 | YN | 44
TRY234 | 5E | 5 | 12345 | NH | 32
TYU346 | 6F | 5 | 54321 | T | 777
RRU776 | 7G | 6 | 54321 |  | 4
OIO898 | 8H | 6 | 54321 | F | 333
YHT567 | 9I | 6 | 54321 | F | 66
YYT665 | 10J | 4 | 44444 | F | 89
UJU787 | 11K | 5 | 44444 | DF | 45
RER454 | 12L | 4 | 44444 |  | 66
HGH724 | 13M | 3 | 44444 | W | 154
JUH755 | 14N | 9 | 987654 |  | 223
WER299 | 15O | 8 | 987654 | H | 4
FER587 | 16P | 7 | 987654 |  | 77
Spreadsheet: 604017d1546258703-need-help-with-separating-data-on-a-pivot-report-book1
Sheet: Pivot

Sum of Cost | Column Labels
Row Labels | 2019-04-01 00:00:00 | 2019-05-01 00:00:00 | Grand Total
Beef
Calves | 10 | 11 | 21
Grand Total | 10 | 11 | 21
Assumption should list here
E.g. For Apr 2019 for Beef, assumptions should read:
ID | Assumptions
1 | Unable to sell stock
2 | Unable to transport stock
3 | New buyer for stock
For May 2019 for Beef, assumptions should read:
ID | Assumptions
1 | Unable to sell stock
2 | Unable to transport stock
3 | New buyer for stock
4 | Compensation Scheme
Spreadsheet: 721351d1614673667-how-to-import-particular-columns-from-different-workbook-destination
Sheet: Source

Source.Name | Column1 | Column2
Source 1.xlsx | 2020-01-20/AF/TES-[PHONE] ZYP0-Critical Instructions | Q
Source 1.xlsx | 2020-02-02/AF20/TES-[PHONE] ZYP0-Normal Query | W
Source 1.xlsx | 2021-01-20/BST2090/TES-[PHONE] ZYP0-Fiber Quotas | E
Source 1.xlsx | 2021-01-20/BST2090/AQX-CHK8385343 ZYPX-Olive Box | R
Source 1.xlsx | 2021-01-20/BST2090/BAS-CHK8395240 ZYPY-Levers | T
Source 2.xlsx | 2020-01-20/AF/TES-[PHONE] ZYP0-Critical Instructions | Y
Source 2.xlsx | 2020-02-02/AF20/TES-[PHONE] ZYP0-Normal Query | U
Source 2.xlsx | 2021-01-20/BST2090/TES-[PHONE] ZYP0-Fiber Quotas | I
Source 2.xlsx | 2021-01-20/BST2090/AQX-CHK8385343 ZYPX-Olive Box | O
Source 2.xlsx | 2021-01-20/BST2090/BAS-CHK8395240 ZYPY-Levers | P
Source 3.xlsx | 2020-01-20/AF/TES-[PHONE] ZYP0-Critical Instructions | A
Source 3.xlsx | 2020-02-02/AF20/TES-[PHONE] ZYP0-Normal Query | S
Source 3.xlsx | 2021-01-20/BST2090/TES-[PHONE] ZYP0-Fiber Quotas | D
Source 3.xlsx | 2021-01-20/BST2090/AQX-CHK8385343 ZYPX-Olive Box | F
Source 3.xlsx | 2021-01-20/BST2090/BAS-CHK8395240 ZYPY-Levers | G
Spreadsheet: 290512d1389893525-separating-one-column-of-data-into-3-based-on-its-value-book1
Sheet: Sheet1

 |  | 5 | 7 | 8
5001
5002
7008
7009
7010
8999
8445
8900
8763
Spreadsheet: 680069d1590763683-return-fiscal-week-duration-excel-forum5
Sheet: Sheet1

 | Fiscal Week 22 |  |  | Fiscal Week 23 |  |  | Fiscal Week 24 |  |  | Fiscal Week 25 |  |  | Fiscal Week 26 |  |  | Fiscal Week 27
Duration | LM | Sub | TM | LM | Sub | TM | LM | Sub | TM | LM | Sub | TM | LM | Sub | TM | LM | Sub | TM
22-25 | 1 | 2 | 1 | 1 | 2 | 1 | 1 | 2 | 1 | 1 | 2 | 1
Spreadsheet: 876065d1722712975-sorting-between-brackets-rafael1024-detect-characters-in-name-tms-aligw
Sheet: (Formula Test)

Area | Zone | Name |  | Compliments of AliGW from: [NAME]
 |  | [ Area 1] - BB OT - Nurse - Wing - [DA.2] |  |  | [ Area 1] - BB OT - Nurse - Wing - [DA.2]
 |  | [ Area 1] - C OT - Nurse 1 - [DA.1] |  |  | [ Area 1] - C OT - Nurse 1 - [DA.1]
 |  | [ Area 1] - C OT - Nurse - [DA.1] |  |  | [ Area 1] - C OT - Nurse - [DA.1]
 |  | [ Area 1] - CB OT - Nurse - Core - [DA.15] |  |  | [ Area 1] - CB OT - Nurse - Core - [DA.15]
 | Area 2 | [ Area 2] - B Partial - Nurse - [FA.11] |  | Area 2 | [ Area 2] - B Partial - Nurse - [FA.11]
 |  | [ Area 2] - C Partial  Nurse - Core - [FA.2] |  |  | [ Area 2] - C Partial  Nurse - Core - [FA.2]
 | Area 4 | [ Area 4] - A PM - Nurse - [QA.21] |  | Area 4 | [ Area 4] - A PM - Nurse - [QA.21]
 | Area 5 | [ Area 5] - CZ OT - Nurse 2 - [DA.2] |  | Area 5 | [ Area 5] - CZ OT - Nurse 2 - [DA.2]
 |  | [ Area 5] - CZ OT - Nurse 1 - [DA.2] |  |  | [ Area 5] - CZ OT - Nurse 1 - [DA.2]
 |  | [ Area 5] - CZ OT - Nurse 3 - [DA.2] |  |  | [ Area 5] - CZ OT - Nurse 3 - [DA.2]
 |  | [ Area 5] - Z OT - Nurse - [DA.1] |  |  | [ Area 5] - Z OT - Nurse - [DA.1]
 |  | [ Area 5] - A Full - Nurse - [RA.1] |  |  | [ Area 5] - A Full - Nurse - [RA.1]
 |  | [ Area 5] - B DTM - Nurse - [ZA.1] |  |  | [ Area 5] - B DTM - Nurse - [ZA.1]
 |  | [ Area 5] - DTM - Nurse - [ZA.1] |  |  | [ Area 5] - DTM - Nurse - [ZA.1]
 | Area 55 | [ Area 55] - A DTM - Nurse - [ZA.1] |  | Area 55 | [ Area 55] - A DTM - Nurse - [ZA.1]
Spreadsheet: 880699d1728551085-populate-names-of-people-running-the-same-course-on-any-given-date-samplequery
Sheet: Monthly Summary

 | Trainer Monthly Summary |  |  |  |  |  |  |  |  |  | 2024-09-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2024-10-01 00:00:00
 | Name | [NAME] |  | Month | 2024-10-01 00:00:00
 |  |  | Notes
Spreadsheet: 3189fb06-f7fd-4206-b00b-4cdaec749e40
Sheet: Sheet1

To determine the amount for private vehicle mileage reimbursement, please fill in the yellow highlighted fields.  Personal reimbursement will be at the Hertz Full Size rate or the Employee Car/Minivan rate, whichever is less.  If no FHSU Motor Pool vehicle or Hertz vehicle is available, $0.56 per mile will be the reimbursement rate.  The traveler is not required to use Hertz as the rental company. | 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 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17
[NAME]'s Name:
PR #:
PO #:
Check Applicable:
 | Pretrip Estimate
 | Complete prior to submitting a PR. Form to be retained by department.
 | Actual Expense
 | Complete after traveler returns. Form to be sent to Accounts Payable along with travel receipts.
Number of Days Vehicle is Required:
Total Miles Driven:
KDOT mileage chart: |  |  |  |  |  | http://kdotapp2.ksdot.org/mileagebetweencities/
Return Travel Date: |  |  |  |  |  |  |  |  | Travel Date must be 07/01/14 or later
Reimbursement Calculation
Employee Car/Minivan when [NAME] is available ($0.22 plus estimated fuel per mile) |  |  |  |  | Employee Car/Minivan when [NAME] and [NAME] NOT available ($0.56 per mile) |  |  |  | Hertz Full Size  rate including the Cost of Fuel |  |  |  |  |  | Department may reduce the rate or limit the amount to be reimbursed.
 |  |  |  |  | 0
Vehicle Data
Current Cost of Fuel per Gallon |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | per gallon
Estimated Miles per Gallon for Rental Full Size |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 | miles/gallon
Employee Car/Minivan Rate when Motor [NAME] is available |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | per mile
Employee Car/Minivan Rate when [NAME] and Hertz Vehicle NOT available |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.56 | per mile
Hertz Full Size Rate (Unlimited Miles) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33.5 | per day
Gas price updated as of |  |  |  |  |  | 2014-12-17 00:00:00
Hertz Contract 37354  Awarded 11-01-12
Comments:
Spreadsheet: benjamin_rogers__1205__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.) -10% Version |  | 3.06 | 2.95 | 2.9 | 2.92 | 2.93 | 2.98 | 3.02 | 3.04 | 3.12 | 3.14
Capacity Prices ($/kW-mo.) Base Version |  | 3.88 | 3.77 | 3.72 | 3.73 | 3.74 | 3.79 | 3.83 | 3.86 | 3.96 | 3.98
Capacity Prices ($/kW-mo.) +10% Version |  | 4.83 | 4.72 | 4.64 | 4.65 | 4.66 | 4.71 | 4.75 | 4.78 | 4.89 | 4.92
Capacity Prices ($/kW-mo.) New Version | 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: 162926d1340120121-trying-to-create-a-batch-by-batch-and-weekly-schedule-adherence-sheet-scheduleadherence
Sheet: HS1

 | Description | SKU | Scheduled Quantity (cases) | Scheduled start time | Scheduled end time | Schedule run time (hrs) | Quantity made | Actual Start time | Actual end time | Start time difference (hrs) | Absolute start time difference | End time difference | Actual runtime | Runtime difference | Absolute runtime difference | Quantity difference | % of schedule made | Time difference hrs | Absolute schedule difference | Quantity made/hour | Scheduled time run | Q made in scheduled slot | Schedule adherence
 | on time. | AB1 | 500 | 2012-01-02 07:00:00 |  |  | 500
 | Started early, finished early | AB2 |  |  |  |  | 500
 | Late start, late finish | AB3 | 500 |  |  |  | 500
 | On time start. Late finish | AB4 |  |  |  |  | 500
 | Early start. Late finish. | AB5 | 500 |  |  |  | 500
 | Late start. Early (or on time) finish | AB6 |  |  |  |  | 500
 | Early start. On time finish | AB7 | 500 |  |  |  | 500
 | On time start. Early finish | AB8 | 500 |  |  |  | 500
 |  | WEEKLY
 |  | Scheduled | Actual
 | Time (hours)
 | Quantity made (cases)
 | Quantity made (cases)/hour
 | Schedule adherence
Spreadsheet: 293840d1391104504-translating-city-codes-to-names-example-attached-example3
Sheet: VB_lookup

City Number | City Name
1 | Azle
2 | Bedford
3 | Benbrook
4 | Blue Mound
5 | Colleyville
6 | Crowley
7 | [NAME]
8 | Edgecliff Village
9 | Everman
10 | [NAME]
11 | Grapevine
13 | [NAME]
14 | [NAME]
15 | Lakeside
16 | Lake Worth
17 | Mansfield
18 | North Richland Hills
19 | Pantego
20 | Richland Hills
21 | Saginaw
22 | Southlake
23 | Westover Hills
24 | Arlington
25 | Euless
26 | Fort Worth
27 | Haltom City
28 | Hurst
29 | River Oaks
30 | White Settlement
31 | Watauga
32 | Westworth Village
33 | [NAME]
34 | Haslet
36 | Pelican Bay
37 | Westlake
38 | Grand Prairie
39 | Sansom Park
41 | Reno
42 | Flower Mound
43 | Roanoke
44 | [NAME]
Spreadsheet: 584914d1533524294-how-to-merge-rows-but-create-seperate-rows-for-data-copy-of-mock-up-example-yurbuddychris-
Sheet: Current

Name | Amount | Year | Address | Category
[NAME] | 200 | 2015 | 1 Main St | A
[NAME] | 250 | 2016 | 1 Main St | A
[NAME] | 300 | 2017 | 1 Main St | A
[NAME] | 350 | 2018 | 1 Main St | A
[NAME] | 10 | 2015 | 2 South 1st St | B
[NAME] | 20 | 2016 | 2 South 1st St | B
[NAME] | 30 | 2017 | 2 South 1st St | B
[NAME] | 40 | 2018 | 2 South 1st St | B
[NAME] | 100 | 2015 | 3 Maple Ave | A
[NAME] | 100 | 2016 | 3 Maple Ave | A
[NAME] | 100 | 2017 | 3 Maple Ave | A
[NAME] | 100 | 2018 | 3 Maple Ave | A
Spreadsheet: 234521d1368118671-using-sumproduct-with-conditions-example-mf
Sheet: Sheet1

 | 2000 |  |  |  |  |  | 2001
 | NAME | Position | A.Return | G.Return | Weight |  | NAME | Position | A.Return | G.Return | Weight
 | a | 1 |  |  |  |  | f | 2
 | b | 3 |  |  |  |  | g | 1
 | c | 2 |  |  |  |  | i | 3
 | d | 1 |  |  |  |  | l | 3
 | e | 3 |  |  |  |  | p | 3
 | f | 3 |  |  |  |  | s | 2
 | g | 3 |  |  |  |  | t | 1
 | h | 1 |  |  |  |  | u | 2
 | i | 1 |  |  |  |  | v | 1
 | j | 2 |  |  |  |  | w | 1
 | k | 3 |  |  |  |  | x | 2
 | l | 2 |  |  |  |  | y | 1
 |  |  |  |  |  |  | z | 3
 |  | Portfolio | 2000 |  | 2001
 |  |  | A.Return | G.Return | A.Return | G.Return
 |  | 1
 |  | 2
 |  | 3