tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 132010d1323438849-nested-if-or-and-matched-indexed-statements-final-yez-sample
Sheet: All hotels

Rooming allocation for Amsterdam, Rhine Valley, Munich, Venice, Tuscany, Switzerland, Paris
Type | # of Rms
Singles |  |  |  |  |  | Arrive Amsterdam |  |  | [NAME]
Twins |  |  |  |  |  | Arrive Rhine Valley |  |  | [NAME]
Triples |  |  |  |  |  | Arrive Munich |  |  | [NAME]
Quads |  |  |  |  |  | Arrive Venice |  |  | Depart Venice
5 bed |  |  |  |  |  | Arrive Florence |  |  | [NAME]
6 bed |  |  |  |  |  | Arrive Switzerland |  |  | [NAME] Switzerland
Total Pax |  |  |  |  |  | Arrive Paris |  |  | [NAME]
fs | ms | Single | Twin |  | Triple |  | Quad |  | 5 |  | 6
[NAME] | [NAME] | Single | Twin |  | Triple |  | Quad |  | 5 bed |  | 6 bed
Spreadsheet: c65abf78-4d20-4f66-9cca-9c34d91b96dd
Sheet: Scoring

Scoring
A high quality assessment is Scored using Clear Guidelines and Criteria
What elements of a scoring guide are present?  Check all that apply. |  | Answer key, scoring template, computerized /machine scored |  | Generalized Rubric (e.g., for persuasive writing, for all science labs) |  | Task-Specific Rubric (only used for the particular task)
 |  | Checklist (e.g., with score points for each part) |  | Teacher Observation Sheet/ Observation Checklist
2a. Does the rubric/scoring criteria align to Colorado Academic Standards in this assessment.  Provide an explanation of your response: |  | Yes |  | Somewhat |  | No
2b. Are the score categories clearly defined and coherent across performance levels?  Provide an explanation of your response below: |  | Yes |  | Somewhat |  | No
2c. To what degree does the rubric/scoring criteria address all of the demands within the task or item? Provide an explanation of your response below: |  | High |  | Moderate |  | Low or None
2d. Based on your review of the rubric/scoring criteria, do you think the scoring rubric would most likely lead different raters to arrive at the same score for a given response?  Provide an explanation of your response below: |  | Yes |  | Somewhat |  | No
2e. Is there student work (e.g., anchor papers, video, portfolio) which illustrates student mastery? If so, describe. If not, what student work would be needed below: |  | Yes |  | Somewhat |  | No
Overall Strengths and Suggestions Regarding Scoring
Spreadsheet: 705755d1606296960-finding-high-low-avg-with-an-if-formulae-sales-2020
Sheet: Sheet2

Code | Vessel |  |  |  | Boxes | Total (£)
[NAME] |  |  |  |  |  | Total (Kg)
Merchant | Species | Presentation | Grade | Units |  |  | Total (£) | [NAME] | Total (Kg) |  |  | Species | Presentation | Boxes | Total (Kg)
 |  |  |  | Boxes | Weight | Cost
Spreadsheet: 762fc51b-79a6-43b8-b360-825ebe0723cc
Sheet: Enki eBooks

Enki Library eBooks 2014
 | Collection Size |  | Patrons |  | Circulations
 | Total Titles | Total Copies | Total | New | Total
January | 16540 | 18226 | 40 |  | 79
February | 16540 | 18226 | 45 | 5 | 64
March | 17005 | 18761 | 58 | 13 | 125
April | 18211 | 19967 | 65 |  | 110
May | 18269 | 20029 | 77 |  | 93
June | 18615 | 20392 | 89 |  | 99
July | 22132 | 24020 | 108 |  | 104
August | 22132 | 24020 | 122 |  | 81
September | 22132 | 24020 | 127 | 5 | 48
October | 22132 | 24020 | 135 |  | 137
November
December
Year to date
Notes
Fully public on January 24, 2014.
Top books are not being recorded for Enki.
 | Currently the only report like this is for all time (not monthly) and all libraries (not broken out for each location).
 | Will start recording this information if it is more specific to KS.
Spreadsheet: benjamin_rogers__936__PJM Model
Sheet: Hourly Load

[NAME]
Total
8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9
9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11
11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12
12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13
13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14
14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15
15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16
16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17
17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18
18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19
19 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20
20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21
21 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22
22 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23
23 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24
Average
Peak
West
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
Average
Peak
East
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
Average
Peak
Spreadsheet: 536750d1504665125-take-column-from-one-worksheet-and-match-its-info-with-cells-in-another-sheet-hfa_all_contacts_08-04-2017-copy
Sheet: DESIRED RESULT

Account ID | Contact ID | First Name | Last Name | Job Title | Business Phone | Business Phone Extension | [NAME] | Mailing Street | Mailing City | Mailing State | Mailing PostalCode | Mailing Country | Record Updated | Verification Status | Communication Preference | Primary Contact | Company Name
1213498 | 1213499 | Cathy | Womeldorf | Owner | X |  | X | X | Brainerd | MN | X |  | True | Validated |  | True | 371 Furniture
1188820 | 1188860 | [NAME] | Ahn | Owner | X |  | X | X | Los Angeles | CA | X |  | True | Validated | Phone | True | Ahn's Piano
1213897 | 1213898 | [NAME] | [NAME] | Owner |  |  | X | X | Santa Rosa | CA | X |  | False | Validated |  | True | Alexander Home Collection
1256 | 10172 | [NAME] | Hall | Owner | X |  | X | X | Paso Robles | CA | X |  | False | Not Validated - Not Available |  | True | American Oak Wholesalers & Auction Co
37925N | 52053N | Toni | Troccoli | Owner | X |  | X | X | Lancaster | PA | X |  | False | Validated |  | True | American Sleep Center
1265 | 10176 | Masood | Rostai | Owner | X |  | X | X | [NAME] | CA | X |  | False | Validated |  | True | American Wholesale Furniture
32588N | 50255N | [NAME] | [NAME] | Owner | X |  | X | X | Urbandale | IA | X |  | True | Validated | [NAME] | True | [NAME]
1213956 | 1213957 | Brooke | Smith | Owner | X |  | X | X | Tomball | TX | X |  | False | Validated |  | True | Arvel
1057N | 14072N | [NAME] | Fineman | CEO/Managing Member |  |  | X | X | Jacksonville | FL | X |  | False | Validated |  | True | Ashley Furniture HomeStore
Spreadsheet: 844858d1696507849-running-total-that-outputs-0-if-the-sum-is-negative-and-applying-max-caps-aggregate-excess
Sheet: Sheet1

 |  |  | Stop Loss | Agg |  |  | [NAME]
 |  | CLAIMED AMOUNT | 250000 | 1500000
 |  | 350000
 |  | 75000
 |  | 110000
 |  | 435000
 |  | 0
 |  | 500000
 |  | 0
 |  | 0
 |  | 300000
 |  | 600000
 |  | 300000
 |  | 95000
Spreadsheet: 727170d1617739310-removing-duplicates-from-dropdown-list-book002
Sheet: FormTable

 | DISPLAY_JUMPER_B
 | Con: |  |  | STX Con: |  | DISPLAY_JUMPER_B
 | Lock: |  |  | STX Lock:
 | [NAME] | Wire # | Circuit | Terminal | STX Term # | Crimp Tool | Pos. | Strip | Route to | [NAME] | Color | STX #
 | 1 |  |  | --- |  |  |  |  | --- | --- | --- | ---
 | 2 |  |  | --- |  |  |  |  | --- | --- | --- | ---
 | 3 |  |  | --- |  |  |  |  | --- | --- | --- | ---
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 20
 | 21
 | L
 | R |  |  | --- |  |  |  |  | --- | --- | --- | ---
 | Con: |  |  | STX Con: |  | Attach fully plugged mating connector into DISPLAY_JUMPER_B.
 | Lock: |  |  | STX Lock:
 | Plugs: |  |  | STX Plugs:
Spreadsheet: 197038d1354197765-conditional-formating-sums-in-brackets-greater-than10
Sheet: Highlight cells <10

 |  |  | [NAME] [8]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | BTTQ [6]
 |  |  | BTTQ
 |  |  | BTTQ
 |  |  | BTTQ
 |  |  | BTTQ
 |  |  | BTTI [6]
 |  |  | BTTI
 |  |  | BTTI
 |  |  | BTTI
 |  |  | BTTI
 | BPLI [8] | BTSI-9 [17] | BTTQ [10]
 | BPLI | BTSI-9 | BTTQ
 | BPLI | BTSI-9 | BTTQ
 | BPLI | BTSI-9 | BTTQ
 | BPLI | BTSI-9 | BTTQ
 | BPLQ [19] | BTSI-9 [8] |  | BTTI [8]
 | BPLQ | BTSI-9 |  | BTTI
 | BPLQ | BTSI-9 |  | BTTI
 | BPLQ | BTSI-9 |  | BTTI
 | BPLQ | BTSI-9 |  | BTTI
Spreadsheet: 105973d1303229574-third-data-validation-drop-down-list-prototype-2
Sheet: Sheet2

...
Chapter_Master
Captain
[NAME]
Chaplain
Master_of_the_Forge
Chapter Master |  | Captain [NAME] |  | [NAME] |  | Chaplain Armour |  | Master_of_the_Forge
Column1 |  | Column1 |  | Column1 |  | Column1 |  | Column1
Power armour |  | Power armour |  | Power armour |  | Power armour |  | [NAME] armour
[NAME] armour |  | [NAME] armour |  | Terminator armour |  | Terminator armour
Terminator armour |  | Terminator armour
Captain Weapons
Bolt pistol
Boltgun
Storm bolter
Combi-flamer
Combi-melta
Combi-plasma
Storm shield
Power blade
Lightning claw
Plasma pistol
Power fist
Relic blade
Thunder hammer
Spreadsheet: chris_germany__1881__2001tran05
Sheet: Other

4.76 |  | St 65 | 4.55 |  | St 65 | 4.55 |  | St 85 |  |  |  | 4.76 | 4.76
 |  | Transco | (3-4) FT |  | Transco | (3-5) |  | Transco | (4-4) it
 |  | comm | 0.017 |  | comm | 0.0278 |  | comm | 0.1672
 |  | s/c |  |  | s/c |  |  | s/c
 |  | 0.0233 |  |  | 0.0381 |  |  | 0.0189 |  |  | 0.02776
 |  |  |  |  |  | 0.09
 |  |  |  |  |  | 0.1
Spreadsheet: 551189d1512755293-sumif-for-a-specific-item-code-sumif-excel-question-help
Sheet: Sheet1

Posted Dt. | Memo / Description | TO Number | Customer Name | Item | Department | Department | Customer | Business Segment | Project | Internal Client ID | Customer Location | Sub Location | Country | Debit (USD) | Credit (USD)
4424-9999 - Revenue-Null (Balance Forward As of 11/01/2017)
2017-11-27 00:00:00 | Invoice - Iowa, University of: 300dpi, RADJW2 - TO605 | TO605 | Iowa, University of | PPRI0008 | 0 | 0 | 14 | 0 |  | 14 | 0 | 22 | 0 |  | 7568
2017-11-27 00:00:00 | Invoice - Iowa, University of: TO605 | TO605 | Iowa, University of | PCAB0010 | 0 | 0 | 14 | 0 |  | 14 | 0 | 22 | 0 |  | 52
2017-11-27 00:00:00 | Invoice - Whole Food Markets, Inc.: TO606 | TO606 | Whole Food Markets, Inc. | PPRI0009 | 0 | 0 | 244 | 0 |  | 244 | 0 | 22 | 0 |  | 1688
2017-11-27 00:00:00 | Invoice - Arizona, University of: TO607 | TO607 | Arizona, University of | PACC0194 | 0 | 0 | 44 | 0 |  | 44 | 0 | 22 | 0 |  | 620
2017-11-27 00:00:00 | Invoice - Alabama, University of: TO608 | TO608 | Alabama, University of | PACC0157 | 0 | 0 | 78 | 0 |  | 78 | 0 | 22 | 0 |  | 1700
2017-11-27 00:00:00 | Invoice - Alabama, University of: TO608 | TO608 | Alabama, University of | DISC | 0 | 0 | 78 | 0 |  | 78 | 0 | 22 | 0 | 1700
Spreadsheet: 722417d1615242447-search-last-value-in-several-worksheets-test
Sheet: John Peter

A | B | C | D | E
2021-01-01 00:00:00 | 1
2021-01-02 00:00:00 |  | 2
2021-01-03 00:00:00 |  | 3
2021-01-04 00:00:00 |  |  | 1
Spreadsheet: 769773d1645683779-sumif-horizontal-and-vertical-criteria-sumproduct-vertical-and-horizontal-criteria
Sheet: Sheet1

AREA | JANUARY | JANUARY | JANUARY | FEBRUARY | FEBRUARY | FEBRUARY | FEBRUARY | FEBRUARY
AREA 1 | 1 |  | 1 |  | 1
AREA 1 |  | 1 | 1 |  |  | 1
AREA 1 |  | 1 | 1 |  |  |  |  | 1
AREA 2 | 2 | 2 | 2
AREA 2 |  |  | 2
AREA 2 |  |  | 2 | 2 | 2 | 2
AREA 2 |  |  |  |  | 2 | 2 | 2 | 2
>>RESULT | JANUARY | FEBRUARY
AREA 1 | 6 | 2
AREA 2 | 10 | 14
Spreadsheet: 735460d1622994080-average-multiple-rows-in-multiple-columns-based-off-multiple-criteria-points-test-sheet-avg-rop-calculator
Sheet: Avg ROP

Manual Fill In Operator and [NAME] |  | Phases | SUR: Surface |  |  |  | INT: Intermediate |  |  |  | INT2: Intermediate 2 |  |  |  | INT2: Intermediate 2 / CRV: CURVE |  |  |  | CRV/LAT: CURVE/LATERAL |  |  |  | LAT: Lateral |  |  |  | Overall Performance
 |  |  | ROTATE ROP | SLIDE ROP | AVG ROP |  | ROTATE ROP | SLIDE ROP | AVG ROP |  | ROTATE ROP | SLIDE ROP | AVG ROP |  | ROTATE ROP | SLIDE ROP | AVG ROP |  | ROTATE ROP | SLIDE ROP | AVG ROP |  | ROTATE ROP | SLIDE ROP | AVG ROP |  | ROTATE ROP | SLIDE ROP | AVG ROP
Operator | [NAME]
A | 1
B | 2
C | 3
D | 4
E | 5
F | 6
G | 7
Spreadsheet: 791021d1660122283-look-up-tool-calc-xx
Sheet: Consultant Calculator

Commision is paid at the following rates
£0-14,999 | 0.1
£15,000-£20,000 | 0.15
£20,000+ | 0.2
 |  |  |  |  |  |  | Billings |  | Commision |  | Basic |  | OTE Calculator
Basic | Title | Days Per Week | Runners | Days Average | Margin Average | Per Week | Per 4 Week Average | Per Year | Month | Year | Month |  | Month | Year
25000 | Trainee | 5 |  | 25 | 50 |  |  |  | 675 | 6581.25 | 2083.33
28000 | Junior | 5 |  | 50 | 50 |  |  |  | 1425 | 13893.75 | 2333.33
32500 | Consultant | 5 |  | 100 | 50 |  |  |  | 2925.05 | 28519.24 | 2708.33
35000 | Consultant 2 | 5 |  | 150 | 50 |  |  |  | 4925.05 | 48019.24 | 2916.67
40000 | Consultant 3 | 5 |  | 200 | 50 |  |  |  | 6925.05 | 67519.24 | 3333.33
45000 | Consultant 3 | 5 |  | 250 | 50 |  |  |  | 8925.05 | 87019.24 | 3750
50000 | Principal | 5 |  | 300 | 50 |  |  |  | 10925.05 | 106519.24 | 4166.67
65000 | Partner | 5 |  | 500 | 50 |  |  |  | 18925.05 | 184519.24 | 5416.67
 |  |  | Average Days |  |  |  | (4 weeks)
Basic |  |  | Runners | Days | Margin | GP Week | GP Month | GP Year
 |  | 5 |  | 10 | 50
 |  |  |  | *Input | *Input
Commision
OTE | Per Month
Rate | Range | Rate Diff | Amount
0.1 | 0 | 0.1
0.15 | 1500
0.2 | 19999
See …
http://www.mcgimpsey.com/excel/variablerate.html
Spreadsheet: 870693d1717160009-adjustment-of-formulas-from-google-sheets-to-excel-file-tourneys1-west123-
Sheet: Sheet1

Time Normal | Tournament | Buy In | Entry | [NAME] | action-sold | Total Prize | Duration | Rank | Result
Spreadsheet: 771449d1646675736-removing-duplicates-in-results-and-chart-testexcel-manchesterman-
Sheet: Sheet1

 |  | Year | Country | 2023 | 2024 | 2025 | 2026 | 2027
 |  | Result before | Ethiopia | 0.009110962920174472 | 0.01019438716300168 | 0.008836215416318655 | 0.009239227028008353 | 0.0122634567910201
 |  | Result after | Ethiopia | 0.06910405576541942 | 0.05753051689167876 | 0.079302199033127 | 0.06220088444467513 | 0.06246649513254182
 |  | Result before | Czech | 0.09845256445714043 | 0.02554988258318547 | 0.02059573392568265 | 0.04296240030383593 | 0.09649237789216746 |  |  | Column1
 |  | Result after | Czech | 0.09845256445714043 | 0.1632439718565707 | 0.1433711938360619 | 0.04296240030383593 | 0.09649237789216746
 |  | Result before | Palestine | 0.007532370517928287 | 0.007532370517928287 | 0.007532370517928287 | 0.007532370517928287 | 0.007532370517928287
 |  | Result after | Palestine | 0.007532370517928287 | 0.007532370517928287 | 0.007532370517928287 | 0.007532370517928287 | 0.007532370517928287
 |  | Result before | Ethiopia | 0.009110962920174472 | 0.01019438716300168 | 0.008836215416318655 | 0.009239227028008353 | 0.0122634567910201
 |  | Result after | Ethiopia | 0.06910405576541942 | 0.05753051689167876 | 0.079302199033127 | 0.06220088444467513 | 0.06246649513254182
 |  | Result before | Ethiopia | 0.009110962920174472 | 0.01019438716300168 | 0.008836215416318655 | 0.009239227028008353 | 0.0122634567910201
 |  | Result after | Ethiopia | 0.06910405576541942 | 0.05753051689167876 | 0.079302199033127 | 0.06220088444467513 | 0.06246649513254182
Spreadsheet: kate_symes__18603__Palo
Sheet: DJ Palo Verde Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-02-08 00:00:00 |  | 182.53 | 10624 | 115.29 | 7280
 | 2001-02-07 00:00:00 |  | 165.65 | 16640 | 113.79 | 6040 | 170.48 | 1096 | 90.98 | 1046
 | 2001-02-06 00:00:00 |  | 156.9 | 18000 | 117.37 | 6400 | 125.6 | 1999 | 88.75 | 1161
 | 2001-02-05 00:00:00 |  | 151.48 | 12400 | 128.84 | 4400 | 113.86 | 1196 | 83.59 | 982
 | 2001-02-04 00:00:00 |  | 145 | 0 | 120 | 0 | 99.69 | 4662 | 101.68 | 220 |  | 128.84 | 13200
 | 2001-02-03 00:00:00 |  | 168.58 | 13568 | 128.08 | 4200 | 117.03 | 3689 | 99.69 | 1202
 | 2001-02-02 00:00:00 |  | 178.98 | 11968 | 128.08 | 4200 | 152.67 | 7590 | 120.57 | 710
 | 2001-02-01 00:00:00 |  | 239.7 | 15792 | 151.12 | 4208 | 156.7 | 4400 | 127.04 | 2339
 | 2001-01-31 00:00:00 |  | 258.52 | 12800 | 158.13 | 5192 | 175.35 | 3038 | 132 | 1931
 | 2001-01-30 00:00:00 |  | 244.66 | 12560 | 140.9 | 5400 | 178.19 | 3125 | 120.98 | 1446
 | 2001-01-29 00:00:00 |  | 252.84 | 13440 | 177.78 | 5400 | 183 | 4553 | 122.38 | 2433
 | 2001-01-28 00:00:00 |  | 207.5 | 800 | 185 | 200 | 150.26 | 3312 | 132.26 | 2111 |  | 177.78 | 16200
 | 2001-01-27 00:00:00 |  | 225.83 | 13200 | 141.8 | 2840 | 152.11 | 781 | 114.82 | 728
 | 2001-01-26 00:00:00 |  | 225.83 | 13200 | 141.75 | 2800 | 223.17 | 1850 | 161.11 | 180
 | 2001-01-25 00:00:00 |  | 231.78 | 13440 | 144.28 | 3040 | 153.9 | 2315 | 108.66 | 1079
 | 2001-01-24 00:00:00 |  | 222.84 | 13360 | 131.11 | 2880 | 136.45 | 2624 | 93.82 | 933
 | 2001-01-23 00:00:00 |  | 254.26 | 9200 | 143.99 | 4256 | 148.73 | 2079 | 105.08 | 1209
 | 2001-01-22 00:00:00 |  | 324.8 | 9200 | 164 | 2000 | 172.56 | 2925 | 139.79 | 2097
 | 2001-01-21 00:00:00 |  | 177.5 | 2400 | 124.55 | 2200 | 152.69 | 3900 | 141.53 | 2132 |  | 168.33 | 1800
 | 2001-01-20 00:00:00 |  | 452.36 | 4400 | 226.5 | 2000 | 232.31 | 2573 | 148.33 | 1359
 | 2001-01-19 00:00:00 |  | 452.36 | 4400 | 226.5 | 2000 | 273.28 | 6682 | 128.74 | 2093
 | 2001-01-18 00:00:00 |  | 379.51 | 8960 | 214.86 | 2800 | 279.1 | 6115 | 157.96 | 2108
 | 2001-01-17 00:00:00 |  | 220.81 | 12080 | 122 | 3800 | 232.88 | 4018 | 186.65 | 824
 | 2001-01-16 00:00:00 |  | 173.04 | 18112 | 105.14 | 4120 | 231.33 | 632 | 127.03 | 579
 | 2001-01-15 00:00:00 |  | 173.04 | 18112 | 104.82 | 3960 | 169.46 | 718 | 107.24 | 593
 | 2001-01-14 00:00:00 |  | 152.5 | 0 | 103 | 0 | 130.52 | 713 | 116.11 | 446 |  | 107.23 | 13560
 | 2001-01-13 00:00:00 |  | 152.77 | 14160 | 107.23 | 4520 | 138.98 | 1547 | 120.82 | 1165
 | 2001-01-12 00:00:00 |  | 159.03 | 18032 | 90.92 | 3800 | 160.71 | 727 | 98 | 450
 | 2001-01-11 00:00:00 |  | 160.31 | 19472 | 90.92 | 3800 | 153.64 | 1669 | 94.86 | 1106
 | 2001-01-10 00:00:00 |  | 143.16 | 18208 | 84.37 | 3352 | 129.46 | 2981 | 93.14 | 1118
 | 2001-01-09 00:00:00 |  | 132.19 | 14400 | 75.61 | 4552 | 145.14 | 850 | 87.82 | 1753
Spreadsheet: 49666d1248996992-calculate-integer-values-based-on-certain-conditions-example
Sheet: OptimisedPlt

 |  |  |  |  |  |  |  |  |  |  | 100 | 99 | S
SplitFullCaseInd | Prefix | VP | Om | TuWgt | TuHt | TuWdth | TuDpth | OmWgt | VPTi | VPHi | Dimension Test | VPHi Test | Prefix Test | Current OM's P/P | Current Pallet Ht. | Current Pallet Wt. | Ideal Pallet Ht. | OPTIMISED Pallet Ht. | [NAME] Optimised VPHi | [NAME] Optimised Plt Hgt | OPTIMISED VPHi
[NAME] | N | 36 | 12 | 0.7 | 110 | 115 | 105 | 0.25 | 27 | 8 | 0 | 0 | 1 | 648 | 9999 | 226.2 | 1800 | 9999 | 8 |  | 8 |  | Height |  |  | Weight
Full Case | S | 12 | 12 | 0.4 | 117 | 120 | 80 | 0.4 | 64 | 3 | 0 | 0 | 0 | 192 | 601 | 151.8 | 1800 | 1771 | 13 | 1771 | 13 |  | 0 | 0 - 200 |  | 0 | 0 - 125
Full Case | S | 12 | 12 | 0.59 | 337 | 119 | 149 | 0.59 | 32 | 3 | 0 | 0 | 0 | 96 | 1261 | 131.64 | 1800 | 1598 | 4 | 1598 | 4 |  | 200 | 200 - 400 |  | 125 | 125 - 250
Full Case | S | 24 | 24 | 0.65 | 140 | 90 | 190 | 0.65 | 42 | 8 | 0 | 0 | 0 | 336 | 1370 | 293.4 | 1800 | 1790 | 11 | 1790 | 11 |  | 400 | 400 - 600 |  | 250 | 250 - 375
Full Case | S | 24 | 24 | 0.7 | 140 | 90 | 185 | 0.7 | 42 | 8 | 0 | 0 | 0 | 336 | 1370 | 310.2 | 1800 | 1790 | 11 | 1790 | 11 |  | 600 | 600 - 800 |  | 375 | 375 - 500
Full Case | S | 12 | 12 | 0.75 | 150 | 150 | 285 | 0.75 | 32 | 6 | 0 | 0 | 0 | 192 | 1150 | 219 | 1800 | 1750 | 10 | 1750 | 10 |  | 800 | 800 - 1000 |  | 500 | 500 - 625
Full Case | S | 12 | 12 | 0.8 | 151 | 283 | 150 | 0.8 | 32 | 6 | 0 | 0 | 0 | 192 | 1156 | 228.6 | 1800 | 1760 | 10 | 1760 | 10 |  | 1000 | 1000 - 1200 |  | 625 | 625 - 750
Full Case | S | 12 | 12 | 0.86 | 142 | 116 | 335 | 0.86 | 32 | 3 | 0 | 0 | 0 | 96 | 676 | 157.56 | 1800 | 1670 | 10 | 1670 | 10 |  | 1200 | 1200 - 1400 |  | 750 | 750 - 875
Full Case | S | 6 | 6 | 0.88 | 165 | 370 | 95 | 0.88 | 36 | 8 | 0 | 0 | 0 | 288 | 1570 | 328.44 | 1800 | 1735 | 9 | 1735 | 9 |  | 1400 | 1400 - 1600 |  | 875 | 875 - 1000
Full Case | S | 6 | 6 | 0.88 | 165 | 370 | 95 | 0.88 | 36 | 8 | 0 | 0 | 0 | 288 | 1570 | 328.44 | 1800 | 1735 | 9 | 1735 | 9 |  | 1600 | 1600 - 1800 |  | 1000 | 1000 - 1125
Full Case | S | 6 | 6 | 0.88 | 165 | 370 | 95 | 0.88 | 36 | 8 | 0 | 0 | 0 | 288 | 1570 | 328.44 | 1800 | 1735 | 9 | 1735 | 9 |  | 1800 | 1800 - 2000 |  | 1125 | 1125 - 1250
Full Case | S | 6 | 6 | 0.9 | 220 | 225 | 200 | 0.9 | 25 | 5 | 0 | 0 | 0 | 125 | 1350 | 187.5 | 1800 | 1790 | 7 | 1790 | 7 |  | 2000 | 2000 - 2200 |  | 1250 | 1250 - 1375
Full Case | S | 6 | 6 | 0.9 | 220 | 225 | 200 | 0.9 | 25 | 5 | 0 | 0 | 0 | 125 | 1350 | 187.5 | 1800 | 1790 | 7 | 1790 | 7 |  | 2200 | 2200 - 2400 |  | 1375 | > 1375
Full Case | S | 6 | 6 | 0.9 | 220 | 225 | 200 | 0.9 | 25 | 5 | 0 | 0 | 0 | 125 | 1350 | 187.5 | 1800 | 1790 | 7 | 1790 | 7 |  | 2400 | > 2400
Full Case | S | 6 | 6 | 5 | 145 | 244 | 370 | 2.91 | 13 | 10 | 0 | 0 | 0 | 130 | 1700 | 725 | 1500 | 1410 | 9 | 1555 | 9.03448275862069
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1555 | 1560
Spreadsheet: 145241d1331408755-npv-of-a-project-and-trial-simulation-projectnpvandtrial
Sheet: Sheet1

MACRS Table:
1 | 2 | 3 | 4 | 5
0.19 | 0.36 | 0.17 | 0.14 | 0.14
Discount rate: | 0.12
Tax rate: | 0.36 |  | 350000
Equipment cost: | 350000
End-of-life value: | -50000
Inflation: | 0.032
Sales growth: | 0.1
NWC % of sales: | 0.04
Year 1 figures:
Units | 80000
Price | 10
VC/Unit | 7.5
FC | 110000
 | 1 | 2 | 3 | 4
Unit Sales | 80000
Price/Unit | 10
Revenue
Var. Cost | 7.5
Fixed Costs | 110000
EBITDA
Depreciation
EBIT
Taxes
Net Income
OCF
NWC
Change in NWC | 32000
FCF
CFFA
NPV
Price In Year 1 for NPV to Break Even
Spreadsheet: 854461d1704323978-find-string-col-b-paste-in-col-a-until-it-changes-then-paste-new-string-test-tagging
Sheet: Result

5707.01.00 | Identifier | 5707.01.00
5707.01.00 | Description | ID 1
5707.01.00 | Term | 30
5707.01.00 | Cust # | 2320
5707.01.00
5707.01.00
5707.01.00
5707.01.00
5707.01.00 | Desc
5707.01.00
5707.01.00 | Revenue
5707.01.00
5707.01.00 | Cost
5707.01.00
5707.01.00 | Profit
5707.01.00
5707.01.00 | Margin
5707.01.00
5707.01.00
5707.01.00
5707.01.00
5707.02.00 | Identifier | 5707.02.00
5707.02.00 | Description | ID 1
5707.02.00 | Term | 30
5707.02.00 | Cust # | 2320
5707.02.00
5707.02.00
5707.02.00
5707.02.00
5707.02.00 | Desc
5707.02.00
5707.02.00 | Revenue
5707.02.00
5707.02.00 | Cost
5707.02.00
5707.02.00 | Profit
5707.02.00
5707.02.00 | Margin
5707.02.00
5707.02.00
5707.03.00 | Identifier | 5707.03.00
5707.03.00 | Description | ID 1
5707.03.00 | Term | 30
5707.03.00 | Cust # | 2320
5707.03.00
5707.03.00
5707.03.00
5707.03.00
5707.03.00 | Desc
5707.03.00
5707.03.00 | Revenue
5707.03.00
5707.03.00 | Cost
5707.03.00
5707.03.00 | Profit
5707.03.00
5707.03.00 | Margin