tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 861881d1709724263-power-query-merge-query-using-reference-query-sample-w-pq
Sheet: Sheet1

 | Emplyee [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | Father [NAME] |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | Child - 1 |  |  |  | Child - 2 |  |  |  | Child - 3 |  |  |  | Child - 4 |  |  |  | Child - 5 |  |  |  | Child - 6
Date | CNIC No. | Email address | Employee Code |  |  |  | Name of Employee | Department | Date of Joning  DD-MM-YYYY | Date of Birth | Gender | Employee Age | Address | [NAME] | Name | CNIC | Date Of Birth2 | Age | Name3 | CNIC4 | Date Of Birth5 | [NAME] | Name7 | CNIC8 | Date Of Birth9 | Age10 | Name11 | Date Of Birth12 | Gender13 | Age14 | Name15 | Date Of Birth16 | Gender17 | Age18 | Name19 | Date Of Birth20 | Gender21 | Age22 | Name23 | Date Of Birth24 | Gender25 | Age26 | Name27 | Date Of Birth28 | Gender29 | Age30 | Name31 | Date Of Birth32 | Gender33 | Age34 | Present Salary | Contact Number
 | 123 | AAA | 100 |  |  |  | ABC | Marketing | 2017-10-10 00:00:00 | 1990-01-13 00:00:00 | FEMALE | 33 | Flat#123 | Married | ADDDD | 111 |  | 61 | GHI | 222 |  | 60 | JB | 203 | 1990-01-13 00:00:00 | 30 | HGAA |  | Male | 5 | PHAI |  |  | 2
 | 111 | BBB | 103 |  |  |  | CCD | Prod | 2022-06-01 00:00:00 | 1986-04-09 00:00:00 | MALE | 36 | Flat#124 | Married | ABGGG | 11111 |  | 65 |  |  |  |  | BH | 1011 | 1990-01-13 00:00:00 | 30 | VGG |  | Male | 4 | ABGH |  |  | 2 | HVVV |  |  | 1
 | 201 | CCC | 101 |  |  |  | GHT | Export | 2017-02-01 00:00:00 | 1986-06-08 00:00:00 | MALE | 36 | Flat#182 | Married |  |  |  | 70 | HGN | 333 |  | 65 | NU | 3000 | 1990-01-13 00:00:00 | 30 | TH |  | Male | 3
The Above data is too large of employees and the main headers are merged. I need the details as per below template.
Employee Code | Name | Age | Desig/Relation | CNIC No. | Date Of Birth
100 | ABC | 33 | Marketing | 123 | 1990-01-13 00:00:00
 | ADDDD | 61 | Father | 111
 | GHI | 60 | Mother | 222
 | JB | 30 | Spouse | 203 | 1990-01-13 00:00:00
 | HGAA | 5 | Child-1
103 | CCD | 36 | Prod | 111 | 1986-04-09 00:00:00
 | ABGGG | 65 | Father | 11111
 | BH | 30 | Spouse | 1011 | 1990-01-13 00:00:00
 | VGG | 4 | Child-1
 | ABGH | 2 | Child-2
 | HVVV | 1 | Child-3
101 | GHT | 36 | Export |  | 1986-06-08 00:00:00
 | HGN | 65 | Mother | 333
 | NU | 30 | Spouse | 3000 | 1990-01-13 00:00:00
 | TH | 3 | Child-1
Employee Code | Name | Age | Desig/Relation | CNIC No. | Date Of Birth
100 | ABC | 33 | Marketing | 123 | 1990-01-13 00:00:00
 | ADDDD | 61 | Father | 111
 | GHI | 60 | Mother | 222
 | JB | 30 | Spouse | 203 | 1990-01-13 00:00:00
 | HGAA | 5 | Child - 1
 | PHAI | 2 | Child - 2
103 | CCD | 36 | Prod | 111 | 1986-04-09 00:00:00
 | ABGGG | 65 | Father | 11111
 | BH | 30 | Spouse | 1011 | 1990-01-13 00:00:00
 | VGG | 4 | Child - 1
 | ABGH | 2 | Child - 2
 | HVVV | 1 | Child - 3
101 | GHT | 36 | Export | 201 | 1986-06-08 00:00:00
 | HGN | 65 | Mother | 333
 | NU | 30 | Spouse | 3000 | 1990-01-13 00:00:00
 | TH | 3 | Child - 1
Spreadsheet: 774004d1648154062-fill-empty-rows-fill-in-empty-rows
Sheet: Sheet1

CODE |  | OUTPUT
X_L_DON-137274-XVA-000166 |  | X_L_DON-137274-XVA-000166
X_L_DON-137274-XVA-000167 |  | X_L_DON-137274-XVA-000167
 |  | X_L_DON-137274-XVA-000168
X_L_DON-137274-XVA-000169 |  | X_L_DON-137274-XVA-000169
 |  | X_L_DON-137274-XVA-000170
X_L_DON-137274-XVA-000171 |  | X_L_DON-137274-XVA-000171
M_A_KY-164383-YA-002184 |  | M_A_KY-164383-YA-002184
 |  | M_A_KY-164383-YA-002185
 |  | M_A_KY-164383-YA-002186
 |  | M_A_KY-164383-YA-002187
 |  | M_A_KY-164383-YA-002188
 |  | M_A_KY-164383-YA-002189
 |  | M_A_KY-164383-YA-002190
 |  | M_A_KY-164383-YA-002191
 |  | M_A_KY-164383-YA-002192
 |  | M_A_KY-164383-YA-002193
 |  | M_A_KY-164383-YA-002194
M_A_KY-164383-YA-002195 |  | M_A_KY-164383-YA-002195
Spreadsheet: 58217d1258498628-changing-the-color-along-a-row-to-show-increasing-and-decreasing-values-cf
Sheet: Sheet1

 | oct | nov | dec | jan | feb | [NAME] | apr | may | jun
a | 18 | 6 | 54 | 50 | 60 | 108 | 126 | 144 | 162
b | 648 | 659 | 486 | 405 | 402 | 413 | 162 | 4050 | 243
c | 1134 | 978 | 972 | 891 | 905 | 729 | 730 | 741 | 486
Spreadsheet: 453152d1459187331-text-movement-based-on-values-advanced-filter-for-questions
Sheet: Sheet1

Questions | Value
 | <5
Questions | Value |  |  |  |  |  |  | Questions | Value
Question 1 | 2 |  |  |  |  |  |  | Question 1 | 2
Question 2 | 8 |  |  |  |  |  |  | Question 5 | 1
Question 3 | 5 |  |  |  |  |  |  | Question 7 | 3
Question 4 | 6 |  |  |  |  |  |  | Question 8 | 2
Question 5 | 1 |  |  |  |  |  |  | Question 10 | 3
Question 6 | 9 |  |  |  |  |  |  | Question 11 | 4
Question 7 | 3 |  |  |  |  |  |  | Question 15 | 3
Question 8 | 2 |  |  |  |  |  |  | Question 17 | 1
Question 9 | 7 |  |  |  |  |  |  | Question 18 | 4
Question 10 | 3 |  |  |  |  |  |  | Question 20 | 1
Question 11 | 4 |  |  |  |  |  |  | Question 21 | 3
Question 12 | 6 |  |  |  |  |  |  | Question 22 | 2
Question 13 | 9 |  |  |  |  |  |  | Question 25 | 2
Question 14 | 5 |  |  |  |  |  |  | Question 27 | 1
Question 15 | 3 |  |  |  |  |  |  | Question 30 | 1
Question 16 | 6
Question 17 | 1
Question 18 | 4
Question 19 | 10
Question 20 | 1
Question 21 | 3
Question 22 | 2
Question 23 | 6
Question 24 | 10
Question 25 | 2
Question 26 | 6
Question 27 | 1
Question 28 | 5
Question 29 | 5
Question 30 | 1
Question 31 | 8
Question 32 | 7
Spreadsheet: 145534d1331641776-adjust-the-plan-date-if-busy-adjust-date
Sheet: Sheet1

 | Task | Plan date | Adjust date |  |  |  |  | Busy date
 | 1 | 2012-03-15 00:00:00 | 2012-03-15 00:00:00 | Does not change |  |  |  | 2012-03-02 00:00:00
 | 2 | 2012-03-17 00:00:00 | 2012-03-19 00:00:00 | Change to next date that not busy |  |  |  | 2012-03-03 00:00:00
 | 3 | 2012-03-18 00:00:00 | 2012-03-19 00:00:00 | Change to next date that not busy |  |  |  | 2012-03-05 00:00:00
 | 4 | 2012-03-19 00:00:00 | 2012-03-19 00:00:00 | Change to next date that not busy |  |  |  | 2012-03-12 00:00:00
 | 5 | 2012-03-23 00:00:00 | 2012-03-24 00:00:00 | Change to next date that not busy |  |  |  | 2012-03-16 00:00:00
 | 6 | 2012-03-24 00:00:00 | 2012-03-24 00:00:00 | Does not change |  |  |  | 2012-03-17 00:00:00
 |  |  |  |  |  |  |  | 2012-03-18 00:00:00
 |  |  |  |  |  |  |  | 2012-03-23 00:00:00
 |  | Plan date to do task | Plan date should be adjusted to next day if busy; does not change if not busy
Spreadsheet: 49651d1248986907-excel-2007-referencing-multiple-worksheets-sampleworkbook
Sheet: DAILY CONVERSION TOTALS

DATE | 2009-08-01 00:00:00 |  |  |  |  | 2009-08-02 00:00:00 |  |  |  |  | 2009-08-03 00:00:00 |  |  |  |  | 2009-08-04 00:00:00 |  |  |  |  | 2009-08-05 00:00:00 |  |  |  |  | 2009-08-06 00:00:00 |  |  |  |  | 2009-08-07 00:00:00 |  |  |  |  | 2009-08-08 00:00:00 |  |  |  |  | 2009-08-09 00:00:00 |  |  |  |  | 2009-08-10 00:00:00 |  |  |  |  | 2009-08-11 00:00:00 |  |  |  |  | 2009-08-12 00:00:00 |  |  |  |  | 2009-08-13 00:00:00 |  |  |  |  | 2009-08-14 00:00:00 |  |  |  |  | 2009-08-15 00:00:00 |  |  |  |  | 2009-08-16 00:00:00 |  |  |  |  | 2009-08-17 00:00:00 |  |  |  |  | 2009-08-18 00:00:00 |  |  |  |  | 2009-08-19 00:00:00 |  |  |  |  | 2009-08-20 00:00:00 |  |  |  |  | 2009-08-21 00:00:00 |  |  |  |  | 2009-08-22 00:00:00 |  |  |  |  | 2009-08-23 00:00:00 |  |  |  |  | 2009-08-24 00:00:00 |  |  |  |  | 2009-08-25 00:00:00 |  |  |  |  | 2009-08-26 00:00:00 |  |  |  |  | 2009-08-27 00:00:00 |  |  |  |  | 2009-08-28 00:00:00 |  |  |  |  | 2009-08-29 00:00:00 |  |  |  |  | 2009-08-30 00:00:00 |  |  |  |  | 2009-08-31 00:00:00
NAME | TOTAL OPPTS | APPT | NO SET | PS ATTEMPT | GROSS CLOSE | TOTAL OPPTS | APPT | NO SET | PS ATTEMPT | GROSS CLOSE | TOTAL OPPTS | APPT | NO SET | PS ATTEMPT | GROSS CLOSE | TOTAL OPPTS | APPT | NO SET | PS ATTEMPT | GROSS CLOSE | TOTAL OPPTS | APPT | NO SET | PS ATTEMPT | GROSS CLOSE | TOTAL OPPTS | APPT | NO SET | PS ATTEMPT | GROSS CLOSE | TOTAL OPPTS | APPT | NO SET | PS ATTEMPT | GROSS CLOSE | TOTAL OPPTS | APPT | NO SET | PS ATTEMPT | GROSS CLOSE | TOTAL OPPTS | APPT | NO SET | PS ATTEMPT | GROSS CLOSE | TOTAL OPPTS | APPT | NO SET | PS ATTEMPT | GROSS CLOSE | TOTAL OPPTS | APPT | NO SET | PS ATTEMPT | GROSS CLOSE | TOTAL OPPTS | APPT | NO SET | PS ATTEMPT | GROSS CLOSE | TOTAL OPPTS | APPT | NO SET | PS ATTEMPT | GROSS CLOSE | TOTAL OPPTS | APPT | NO SET | PS ATTEMPT | GROSS CLOSE | TOTAL OPPTS | APPT | NO SET | PS ATTEMPT | GROSS CLOSE | TOTAL OPPTS | APPT | NO SET | PS ATTEMPT | GROSS CLOSE | TOTAL OPPTS | APPT | NO SET | PS ATTEMPT | GROSS CLOSE | TOTAL OPPTS | APPT | NO SET | PS ATTEMPT | GROSS CLOSE | TOTAL OPPTS | APPT | NO SET | PS ATTEMPT | GROSS CLOSE | TOTAL OPPTS | APPT | NO SET | PS ATTEMPT | GROSS CLOSE | TOTAL OPPTS | APPT | NO SET | PS ATTEMPT | GROSS CLOSE | TOTAL OPPTS | APPT | NO SET | PS ATTEMPT | GROSS CLOSE | TOTAL OPPTS | APPT | NO SET | PS ATTEMPT | GROSS CLOSE | TOTAL OPPTS | APPT | NO SET | PS ATTEMPT | GROSS CLOSE | TOTAL OPPTS | APPT | NO SET | PS ATTEMPT | GROSS CLOSE | TOTAL OPPTS | APPT | NO SET | PS ATTEMPT | GROSS CLOSE | TOTAL OPPTS | APPT | NO SET | PS ATTEMPT | GROSS CLOSE | TOTAL OPPTS | APPT | NO SET | PS ATTEMPT | GROSS CLOSE | TOTAL OPPTS | APPT | NO SET | PS ATTEMPT | GROSS CLOSE | TOTAL OPPTS | APPT | NO SET | PS ATTEMPT | GROSS CLOSE | TOTAL OPPTS | APPT | NO SET | PS ATTEMPT | GROSS CLOSE
Sample
TOTAL:
Spreadsheet: 35265d1232822512-input-automatic-calculation-excel-problem-statement
Sheet: Sheet1

Step-1 | All blue entries  are filled in manually by the User.
 | "Spec" can be alpha-numerical, with characters
 | "x" would be number, with upto two decimal places
 | "y" is the number to be calculated.
Spec | x | y
A1A-1 | 80
A1A-1 | 90
B3A | 70
A2A-N | 190
B1N-0 | 350
A3A-P1 | 120
B5k - 0 | 200
B3A | 195
A2A-N | 80
 |  |  |  |  |  | Table 1
 |  |  |  |  |  | Table 1 is prepared by the user himself. No automation required here. The table may have as many as 100 different "Spec" or rows. But Table 1 is preferably located in another sheet in same workbook, if possible.
 |  |  |  |  |  | Spec | Equation
 |  |  |  |  |  | A1A-1 | y = 1E-07x3 - 1E-04x2 - 0.013x + 20.07
 |  |  |  |  |  | A2A-N | y = 1E-07x3 - 0.0001x2 - 0.0041x + 19.906
 |  |  |  |  |  | A3A-P1 | y = 1E-07x3 - 1E-04x2 - 0.086x + 20.1
 |  |  |  |  |  | B3A | y = -9E-08x3 + 3E-05x2 - 0.0312x + 19.997
 |  |  |  |  |  | B1N-0 | y = -1E-07x3 + 6E-05x2 - 0.0344x + 20.015
 |  |  |  |  |  | B5k - 0 | y = -3E-05x2 + 0.804x - 0.187
Spreadsheet: 70941d1271700972-sorting-columns-by-rows-restructuredtable
Sheet: Sheet1

ORIGINAL TABLE
07:00:00 | 07:30:00 | 08:00:00 | 08:30:00 | 09:00:00 | 09:30:00
WER908 | QWE098 | HG456 | TYJR234 | UIL789 | WEG345
SDG089 | [NAME] | TYJR234 | ERG8907 | WER234 | DF34T5
SDFG0789 | SDFG345 | QWER15 | TY546 | DHB345 | HEHJ234
ASD089 | WER908 | NY345 | WER908 | ASDF0789 | VBN6
ERG8907 | HBTR34 | SDZV456 | ASDF07089 | ERH234 | ASDF0789
DFN234 | SDG089 | VBN6 | QWE123 | AWR234 | FRMJ7689
AEG9876 | QWE123 | [NAME] | HG456 | ERH345 | WE345
ASTF0789 | [NAME] | WER908 | UIL789 | ERG8907 | DB34
RTN09 | DFBH76 | QWE123 | VBN6 | VBN6 | ERH345
CVB897 | WERT345 | UIL789 | WER234 |  | WER234
ZSXC76 | HG456 | SDG089
QWE098
FN723
BT879
SORTED TABLE
UNIQUE IDS | 07:00:00 | 07:30:00 | 08:00:00 | 08:30:00 | 09:00:00 | 09:30:00
WER908 | WER908 | WER908 | WER908
SDG089 | SDG089 | SDG089
SDFG0789
ASD089
ERG8907 |  |  | ERG8907 | ERG8907
DFN234
AEG9876
ASTF0789
RTN09
CVB897
ZSXC76
QWE098 | QWE098
FN723
BT879
[NAME] | [NAME]
SDFG345 | SDFG345
HBTR34 | HBTR34
QWE123 | QWE123 | QWE123 | QWE123
[NAME] | [NAME] | [NAME]
DFBH76 | DFBH76
WERT345 | WERT345
HG456 | HG456 | HG456 | HG456
TYJR234 |  | TYJR234 | TYJR234
QWER15 |  | QWER15
NY345 |  | NY345
SDZV456 |  | SDZV456
VBN6 |  | VBN6 | VBN6 | VBN6 | VBN6
UIL789 |  | UIL789 | UIL789 | UIL789
TY546 |  |  | TY546
ASDF07089 |  |  | ASDF07089
WER234 |  |  | WER234 | WER234 | WER234
DHB345 |  |  |  | DHB345
ASDF0789 |  |  |  | ASDF0789 | ASDF0789
ERH234 |  |  |  | ERH234
AWR234 |  |  |  | AWR234
ERH345 |  |  |  | ERH345 | ERH345
WEG345 |  |  |  |  | WEG345
DF34T5 |  |  |  |  | DF34T5
HEHJ234 |  |  |  |  | HEHJ234
FRMJ7689 |  |  |  |  | FRMJ7689
WE345 |  |  |  |  | WE345
DB34 |  |  |  |  | DB34
Spreadsheet: 738646d1625160439-rolling-3-month-sum-with-offset-rolling-3-month-with-offset1
Sheet: Sheet1

 | 2021-05-01 00:00:00 |  | 2021-07-01 00:00:00
Budget | 2524 | 2263 | 1899 | 2220 | 2163 | 2910 | 2557 | 3388 | 2800 | 2965 | 3187 | 3332 | 3481 | 3165
Actual | 1941 | 2306 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Delta |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rolling 3-Month Delta
Spreadsheet: 713534d1610769011-nested-if-or-and-statement-not-working-on-all-rows-copy-20200818-obsolete-tooling
Sheet: 20201014 Curtis (Oper Supplies)

Material | Short Text | Profit Center | Valuation Class | MRP Controller | MRP | Valuation Type (Batch) | Valuation Type (Batch) | Location | Del. flag: stge type | DF at plant level | Plant-sp.matl status | Total Stock (Qty in Inventory) | Total Value (Value Unrestricted) | Number of Years | Days since consumption | Moving price | Price Unit | OBSOLETE? (Yes / No) | Comments
78-5004-0589-9-00 | CURTAIN,LIGHT [NAME] | 619029705 | 7060 | 5 |  | C1 |  | FM21-3B1 |  |  |  | 3 | 7468.95 |  | 3840 | 248965 | 100 | Yes
78-5004-0589-9-00 | CURTAIN,LIGHT [NAME] | 619029705 | 7060 | 5 |  | C2 |  | FM21-3B1 |  |  |  | 1 | 2489.65 |  | 3840 | 248965 | 100 | Yes
Spreadsheet: 868997d1715692406-help-modelling-a-fee-with-a-cap-and-collar-with-a-deferred-element-simple-performance-fee-restructure-me-
Sheet: Sheet1

Fee Projections
 |  | Q3-24 | Q4-24 | Q1-25 | Q2-25 | 12m Total
Base fees |  | 0.4758462247 | 0.4758462247 | 0.4758462247 | 0.4758462247
Success fees |  | 0.4864020000000001 | 1.80943 | 0 | 0
Gross fees
Increase to floor |  | 0 | 0 | 0 | 0
[NAME] fees in excess of cap
Unwind deferred fees |  | 0
Net fees
Deferred fee balance
 |  |  |  |  |  |  | 1.5
Spreadsheet: 198362d1354745330-variable-materials-and-prices-formula-variable-prices-bb-
Sheet: PRODUCT

MATERIAL | QTY | THICK | Length mm | [NAME] | Price/m² | TOTAL |  |  |  | WOOD | 3 | 6 | 9 | 12 | 16 | 18
WOOD | 1 | 6 | 1000 | 1000 | 4 | 4 |  |  |  |  | 2 | 4 | 6 | 8 | 10 | 12
 |  |  |  |  |  |  |  |  |  | PLASTIC | 2 | 3 | 5 | 6 | 9
 |  |  |  |  |  |  |  |  |  |  | 5 | 10 | 15 | 20 | 25
 |  |  |  |  |  |  |  |  |  | METAL | 2 | 3 | 4 | 5 | 6
 |  |  |  |  |  |  |  |  |  |  | 10 | 20 | 30 | 40 | 50
Spreadsheet: 767733d1644597239-distribute-a-number-from-a-cell-across-others-based-on-the-percentage-of-another-cell-distribute-based-on-individual-percentage-of-available-updated-
Sheet: Team Assignments

FRUIT | TOTAL AVAILABLE | TOTAL TO PICK | TEAM 1 | TEAM 2 | TEAM 3 | TEAM 4 | TOTAL ASSIGNED
ORANGES |  | 50
APPLES |  | 11
 |  | TOTAL AVAILABLE BY TEAM
 |  | RANK
 |  |  | Calculate how many to "pick" based on their individual percentage of B.
 |  |  | The sum of D:G must be exactly the value in C.  Must be whole numbers.
Spreadsheet: 822073d1679074289-sumifs-index-match-with-a-date-range-or-other-options-example-1-
Sheet: Sheet1

 | 2022-08-31 00:00:00 | 2022-09-30 00:00:00 | 2022-10-31 00:00:00 | 2022-11-30 00:00:00 | 2022-12-31 00:00:00 | 2023-01-31 00:00:00 | 2023-02-28 00:00:00 |  | Single Month |  |  | Month | 2022-09-30 00:00:00
BANK | 2234.67 | -1871.35 | 6912.09 | -3597.33 | 3892.78 | -3394.9 | -3394.9 |  |  |  |  | Category | REVENUE
BANK | 0 | 0 | 0 | 0 | 0 | 0 | 0
REVENUE | 104549.7 | 311209.13 | 359263.6 | 545005.13 | 338058.6 | 583226.75 | 583226.75
REVENUE | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | Range |  |  | Start Month | 2022-11-30 00:00:00
REVENUE | 5152 | 6440 | 1487 | 10304 | 2775 | 7728 | 7728 |  |  |  |  | End Month | 2023-02-28 00:00:00
REVENUE | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | Category | REVENUE
REVENUE | 0 | 0 | 0 | 0 | 0 | 0 | 0
OTHERINCOME | 0 | 0 | 0 | 0 | 0 | 0 | 0
DIRECTCOSTS | 0 | 0 | 0 | 0 | 0 | 0 | 0
DIRECTCOSTS | 0 | 0 | 0 | 0 | 0 | 0 | 0
DIRECTCOSTS | 46555.68 | 147210.63 | 165719.34 | 246608.94 | 153959.15 | 258470.67 | 258470.67
DIRECTCOSTS | 4400 | 4220 | 4400 | 4400 | 3520 | 5280 | 5280
DIRECTCOSTS | 0 | 1475 | 9225 | 8450 | 8450 | 8450 | 8450
DIRECTCOSTS | 0 | 107.91 | 703.88 | 538.5 | 538.5 | 538.5 | 538.5
DIRECTCOSTS | 0 | 0 | 0 | 0 | 33.15 | 93.6 | 93.6
OVERHEADS | 0 | 0 | 850 | 300 | 0 | 87.18 | 87.18
OVERHEADS | 1234.5 | 36.5 | 36.5 | 35.79 | 35.5 | 49.5 | 49.5
OVERHEADS | 134.21 | 135.38 | 136.29 | 140.06 | 143.44 | 147.47 | 147.47
OVERHEADS | 90.67 | 96.49 | 132 | 668.4 | 649.8 | 633.05 | 633.05
DIRECTCOSTS | 0 | 0 | 0 | 0 | 0 | 0 | 0
OVERHEADS | 135 | 270 | 135 | 0 | 393.75 | 506.25 | 506.25
DEPRECIATN | 1741.8 | 1799.28 | 1905.15 | 2164.94 | 2220.62 | 2401.26 | 2401.26
REVENUE | 0 | 0 | 0 | 0 | 0 | 0 | 0
OVERHEADS | 0 | 0 | 0 | 0 | 0 | 0 | 0
OVERHEADS | 0 | 0 | 0 | 0 | 0 | 0 | 0
REVENUE | 1970.4 | 957.19 | 1079.78 | 2261.59 | 784.77 | 570.51 | 570.51
OVERHEADS | 0 | 0 | 0 | 0 | 0 | 0 | 0
OVERHEADS | 166.01 | 170.72 | 221.32 | 457.28 | 188.99 | 542.71 | 542.71
OVERHEADS | 0 | 0 | 0 | 0 | 0 | 0 | 0
OVERHEADS | 355.72 | 355.72 | 355.72 | 358.18 | 1090.35 | 886.69 | 886.69
EXPENSE | 513.7 | 0 | 0 | 0 | 0 | 0 | 0
OVERHEADS | 52 | 228.44 | 10.16 | 480.33 | 120.94 | -271.95 | -271.95
OVERHEADS | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 185096d1349476750-goal-log-setup-personal-goal-tracking
Sheet: Sheet1

Goal | Total success % | Last 28 day success % | Current consecutive success streak | 2012-10-04 00:00:00 | 2012-10-05 00:00:00 | 2012-10-06 00:00:00 | 2012-10-07 00:00:00 | 2012-10-08 00:00:00 | 2012-10-09 00:00:00 | 2012-10-10 00:00:00
Go running |  |  |  | y | y | y | n | o | y | y
Don't smoke |  |  |  | y | y | y | y | y | y | y
Practice guitar |  |  |  | y | n | n | y | n | y | n
 |  |  | Done current streaks Please look in sheet2 how it work.
 |  |  | Good luck cheer
Spreadsheet: 217801d1362193838-pull-out-information-from-main-sheet-to-summary-sheet-phase-1-2-3-2-27-13
Sheet: Summary

 | 2013-02-13 00:00:00 | 2013-02-13 00:00:00 | 2013-02-14 00:00:00 | 2013-02-14 00:00:00 | 2013-02-15 00:00:00 | 2013-02-15 00:00:00 | 2013-02-16 00:00:00 | 2013-02-16 00:00:00 | 2013-02-17 00:00:00 | 2013-02-17 00:00:00 | 2013-02-18 00:00:00 | 2013-02-18 00:00:00 | 2013-02-19 00:00:00 | 2013-02-19 00:00:00 | 2013-02-20 00:00:00 | 2013-02-20 00:00:00 | 2013-02-21 00:00:00 | 2013-02-21 00:00:00 | 2013-02-22 00:00:00 | 2013-02-22 00:00:00 | 2013-02-23 00:00:00 | 2013-02-23 00:00:00 | 2013-02-24 00:00:00 | 2013-02-24 00:00:00 | 2013-02-25 00:00:00 | 2013-02-25 00:00:00 | 2013-02-26 00:00:00 | 2013-02-26 00:00:00 | 2013-02-27 00:00:00 | 2013-02-27 00:00:00 | 2013-02-28 00:00:00 | 2013-02-28 00:00:00 | 2013-03-01 00:00:00 | 2013-03-01 00:00:00 | 2013-03-02 00:00:00 | 2013-03-02 00:00:00
 | Weld no. | Weld [NAME] | Weld no. | Weld [NAME] | Weld no. | Weld [NAME] | Weld no. | Weld [NAME] | Weld no. | Weld [NAME] | Weld no. | Weld [NAME] | Weld no. | Weld [NAME] | Weld no. | Weld [NAME] | Weld no. | Weld [NAME] | Weld no. | Weld [NAME] | Weld no. | Weld [NAME] | Weld no. | Weld [NAME] | Weld no. | Weld [NAME] | Weld no. | Weld [NAME] | Weld no. | Weld [NAME] | Weld no. | Weld [NAME] | Weld no. | Weld [NAME] | Weld no. | Weld [NAME]
 | GB4-599 | 4
 | GB4-600 | 4
 | GB4-601 | 4
 | GB4-602 | 4
 | GB4-603 | 4
 | GB4-604 | 4
Total Welds | 6
Total Inches per day |  | 75.36
No. of welders |  | 5
Total Inches per welder/day |  | 15.072
Spreadsheet: 151752d1335106544-excel-indexing-coursework
Sheet: ev_HiddenInfo

Goal (Cell, Statistic, Parameter), E1: RO Formula to Optimize |  |  |  |  | [NAME] |  |  | Compatibility with Old Versions (4 trips pre-v5 versions) | 3 |  | RISKOpt Tag | True |  | Out. Stats
[NAME] (Type, Target Value) | 1 | 0 |  |  | Start (enabled, macro) | False |  | Formula Conversion Cell (not used in v5) |  |  | #Iterations ([NAME]) |  |  | Mean |  |  | Creation Version | 5.7.1 |  | Constraint Solver, number of Latin Hypercube stratifications, for reproducing results with Actual Convergence
Trial Count Stopping (enabled, trial count) | True | 20000 |  |  | Before Recalc (enabled, macro) | False |  | Number Formatting Cell (introduced in v5) |  |  | [NAME]. Stopping Mode, Tolerance |  |  | Std. [NAME]. |  |  | Required Version | 4.0.0 |  | Constraint Solver, total of adjustable cell values, to only pass number of stratifications if model hasn't changed
[NAME] (enabled, trial count) | False | 5 | 2 |  | After [NAME] (enabled, macro) | False |  |  |  |  | Same Seed Each Simulation |  |  | Min |  |  | Recommended Version | 4.0.0
[NAME] (enabled, trial count, [NAME] change, change is percent) | False | 100 | 0.01 | True | After Storage (enabled, macro) | False |  |  |  |  | Sampling Type |  |  | [NAME] |  |  | Last Modified by Version | 5.7.1
[NAME] (enabled, formula) | False |  |  |  | Finish (enabled, macro) | False |  |  |  |  | Macro Before Simulation (enabled, macro)
Population Size | 50 |  |  |  |  |  |  |  |  |  | Macro After Simulation (enabled, macro)
UNUSED | UNUSED |  |  |  | Seed (Is Auto, Value) | True | 1
Ev4/RO1: Update Display (replaced by Show Excel Recalcs in v5) | 3 |  |  |  | Minimize Excel on Startup | False
Stop on Errors (before v5: Pause on Errors) | False
[NAME] (if cell has anything other than False consider True, since Evolver 4 didn't have this setting) | True
Ev4/RO1: Graph Progress | False |  |  |  | Show Excel Recalcs (replaces "Update Display" used before v5) | 2
# [NAME] | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | # Constraints | 0
Method + #Operators | Mutation Rate | [NAME] | Description | # Time Blocks/All Groups Must Be Present | Constraint Range | #Ranges | Adj. Range | Min Val or Range | [NAME] Or Range | Flags |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HARD CONSTRAINT DEV |  |  |  |  |  | Type (Hard/Soft) | Entry Mode | [NAME] | Description | Left Val Or Range | Left Operator | Constrained Cells | Right Operator | Right Val Or Range | Penalty Function | RO Eval Time (Iter/Sim) | RO Statistic to Constrain | RO Statistic Parameter
SCHEDULE_x0001_4 | 0.01 | 0.9 |  | 5 |  | 1
DEFAULT PARENT SELECTION
[NAME]
DEFAULT CROSSOVER
DEFAULT BACKTRACK
Spreadsheet: 888711d1739286973-lookup-a-value-within-a-table-vernong72-table
Sheet: Sheet1

-10°C | 8
 |  | -35°C | -30°C | -25°C | -20°C | -15°C | -10°C | -5°C | 0°C | 5°C | 10°C
 | 5 | 0.3096599544072948 | 0.3143047112462006 | 0.3189494680851064 | 0.3204692249240121 | 0.3266337386018238 | 0.3312784954407295 | 0.3621010638297872 | 0.3852393617021276 | 0.4114171732522797 | 0.4222264437689969
 | 6 | 0.3974829027355623 | 0.4082921732522796 | 0.4129369300911854 | 0.4191014437689969 | 0.43 | 0.4360752279635258 | 0.4745820668693009 | 0.5038848784194528 | 0.5408719604863221 | 0.5624050151975684
 | 7 | 0.483786094224924 | 0.4945953647416413 | 0.4992401215805471 | 0.5054046352583587 | 0.52 | 0.5377469604863222 | 0.5870630699088145 | 0.6225303951367781 | 0.6748860182370822 | 0.7118731003039513
 | 8 | 0.56 | 0.5700892857142856 | 0.5762537993920972 | 0.5824183130699088 | 0.61 | 0.6425436930091185 | 0.6948993161094225 | 0.7473404255319149 | 0.8120250759878419 | 0.8675056990881458
 | 9 | 0.63 | 0.65 | 0.6517477203647417 | 0.6610372340425532 | 0.6887348024316109 | 0.7457351823708206 | 0.8073803191489362 | 0.8736702127659575 | 0.9538088905775075 | 1.024658054711246
 | 10 | 0.7 | 0.7195573708206686 | 0.7318863981762918 | 0.7380509118541033 | 0.77 | 0.84 | 0.91 | 1 | 1.093987462006079 | 1.186455167173252
 | 11 |  |  |  |  |  |  |  | 1.130974544072948 | 1.238810790273556 | 1.345127279635258
 | 12 |  |  |  |  |  |  |  | 1.263468844984802 | 1.386759118541034 | 1.50844414893617