tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 307884d1396086303-length-optimizer-length-optimizer
Sheet: Sheet1

 |  |  |  |  | example |  |  |  |  | if I do manual calculation the result would be
 |  |  |  |  | Stock length |  |  |  |  |  | Stock length |  |  | waste length |  |  | balance length
Sr.no | type | length | Qty | Standard length | length | Qty | I want to separated out used Qty and waste qty |  |  |  | length | Qty |  | length | Qty
1 | cut 1 | 1200 | 2 | I want to optimize from this length 3660, 3050, 4575 | 3660 | 100 |  |  |  |  | 3660 | 2 |  | 60 | 2 |  | 3660 | 98
2 | cut 1 | 2400 | 2 |  | 3050 | 100 |  |  |  |  | 3050 | 1 |  | 50 | 1 |  | 3050 | 99
3 | cut 1 | 1000 | 3 |  | 4575 | 100 |  |  |  |  |  |  |  |  |  |  | 4575 | 100
Spreadsheet: 683026d1592444618-combining-3-array-formulas-to-one-sample
Sheet: NO

 | Name | Phone | Date order Received | [NAME] | Disc £ ea | Balance | Paid | Product | Notes/ Special Reqs | Status | Collection Date | Time
 | [NAME] | 123456 |  | 2 |  |  | paid | 5f |  |  | 2020-06-10 00:00:00 | 10:00:00
 | [NAME] | 67890 |  | 4 |  |  |  | 5f |  |  | 2020-06-12 00:00:00 | 13:00:00
 | patric | 876543 |  | 6 |  |  | paid | 6f |  |  | 2020-06-08 00:00:00 | 13:00:00
 | [NAME] | 9812345 |  | 5 |  |  |  | 6f |  |  | 2020-06-12 00:00:00 | 11:00:00
Spreadsheet: darrell_schoolcraft__7775__imbalsumm0106
Sheet: EPFS

 | El Paso/TW Eddy Rec
 | 78093
Day | Measured | Scheduled
1 | 24912 | 30000
2 | 36015 | 30000
3 | 42137 | 30000
4 | 32489 | 40000
5 | 39177 | 38000
6 | 39137 | 38000
7 | 29194 | 38000
8 | 34268 | 38000
9 | 33780 | 37999
10 | 33193 | 37999
11 | 2357 | 23999
12
13
14
15
16
17
18
19
20
21
22
23 | 31271 | 30000
24 | 36296 | 30000
25
26
27
28
29
30
31
2001-05-31 00:00:00 |  |  | -112130.12
2001-06-24 00:00:00
Spreadsheet: 139252d1328156988-sort-and-count-unique-numbers-unique-count-and-sort
Sheet: Sheet1

List | Unique | Sorted | Count
5
11
5
5
12
11
6
7
5
5
7
9
11
9
12
5
11
7
7
10
Spreadsheet: 200789d1355766640-solving-engineering-problem-using-solver-solver-solution
Sheet: Sheet1

 |  | Height | Horizontal distance |  | Length of Cable |  |  | Minimize | g6
 | Pole A | 55 | 55.00000061274035 |  |  |  |  | By changing | d3:d4
 | Pole C | 35 | 35.00000038725964 |  |  |  |  | Constraints | d6=1
 | Distance: | 90
 |  |  | A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C
Spreadsheet: 722576d1615318585-highlight-a-cell-in-a-row-based-on-the-current-sum-of-that-series-bonus-based-on-hours-worked
Sheet: Payroll

Employee | Current progress to 200 | Total Hours Worked In 2021 | 1/15/2021 Payroll | 1/31/2021 Payroll | 2/15/2021 [NAME] | 2/28/2021 Payroll | 3/15/2021 Payroll | 3/31/2021 Payroll | 4/15/2021 Payroll | 4/30/2021 Payroll | 5/15/2021 Payroll | 5/31/2021 Payroll | 6/15/2021 Payroll | 6/30/2021 Payroll | 7/15/2021 Payroll | 7/31/2021 Payroll | 8/15/2021 Payroll | [NAME] | 9/15/2021 Payroll | 9/30/2021 Payroll | 10/15/2021 Payroll | 10/31/2021 Payroll | 11/15/2021 Payroll | 11/30/2021 Payroll | 12/15/2021 Payroll | 12/31/2021 Payroll
[NAME] |  |  | 42.67 | 47.88 | 65.25 | 59.43
[NAME] |  |  | 62.55 | 64.52 | 74.08 | 81.84
[NAME] |  |  | 32.37 | 14.87 | 55.24 | 22.7
[NAME] |  |  | 62.35 | 27.02 | 63.03 | 20.03
[NAME] |  |  | 46.22 | 60.8 | 56.13 | 44.13
[NAME] |  |  | 57.87 | 56.85 | 50.27 | 41.3
[NAME] |  |  | 89.58 | 74.62 | 83.77 | 59.17
[NAME] |  |  | 83.33 | 91.8 | 76.88 | 72.23
[NAME] |  |  | 89.04 | 72.72 | 87.26 | 72.63
[NAME] |  |  | 27.92 | 42.92 | 26.3 | 31.2
Spreadsheet: 813016d1673505855-sumproduct-with-multiple-criteria-sumproduct-1-also-try
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Buy
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bought
 |  |  | Transaction Type |  |  |  | Quantity
 |  |  |  | Item |  |  |  |  | IN Stock/ backorder | Amount per style | Amount per style
 |  |  | EFT | zero |  |  |  |  | 100
 |  |  | Buy | Box |  |  | 20 |  | -23
 |  |  | Buy | cart |  |  | 14201 |  | -56
 |  |  | Buy | pencil |  |  | 7344 |  | 67
 |  |  | Buy | pen |  |  | 3446 |  | 767
 |  |  | Buy | paper |  |  | 6316 |  | 45
 |  |  | Buy | pin |  |  | 26892 |  | 45
 |  |  | Buy | plate |  |  | 42000 |  | 32
 |  |  | Bought | cup |  |  | 0.91 |  | 33
 |  |  | Bought | spoon |  |  | 0.031 |  | 45
 |  |  | Bought | fork |  |  | 0.186 |  | 40
 |  |  | Bought | meat |  |  | 0.134 |  | -33
 |  |  | Bought | veg |  |  | 0.085 |  | 12
 |  |  | Bought | Noodle |  |  | 0.632 |  | 564
 |  |  | Buy | salt |  |  | 15667 |  | 557
 |  |  | Sell | zero |  |  | -7344 |  | -57
 |  |  | Bought | Box |  |  | 0.745 |  | 76
 |  |  | Sold | cart |  |  | -0.186 |  | 78
 |  |  | BALANCE | pencil |  |  |  |  | -56
 |  |  | Interest | pen |  |  | 0.19 |  | 65
 |  |  | Interest | paper |  |  | 44 |  | 68
 |  |  | Dividend | pin |  |  | 0.521 |  | 55
 |  |  | Dividend | plate |  |  | 62 |  | 556
 |  |  | Sell | cup |  |  | -3500 |  | 56
 |  |  | EFT | spoon |  |  |  |  | 454
 |  |  | Dividend | fork |  |  | 0.55 |  | -34
 |  |  | Dividend | meat |  |  | 40 |  | 223
 |  |  | Sell | veg |  |  | -3500 |  | 22
 |  |  | Deposit | Noodle |  |  |  |  | 56
 |  |  | BALANCE | salt
 |  |  | Interest | zero |  |  | 0.77
 |  |  | Interest | Box |  |  | 49
 |  |  | Dividend | cart |  |  | 0.806
 |  |  | Dividend | pencil |  |  | 53
 |  |  | Buy | pen |  |  | 576
 |  |  | Dividend | paper |  |  | 0.595
 |  |  | Dividend | pin |  |  | 452
 |  |  | Dividend | plate |  |  | 0.953
 |  |  | Dividend | cup |  |  | 92
 |  |  | Dividend | spoon |  |  | 0.131
 |  |  | Dividend | fork |  |  | 29
 |  |  | EFT | meat
 |  |  | Bought | veg |  |  | 0.472
 |  |  | Redeemed | Noodle |  |  | -3500
 |  |  | Deposit | salt
 |  |  | Interest | zero |  |  | 0.08
 |  |  | Interest | Box |  |  | 49
 |  |  | Redeemed | cart |  |  | -3500
 |  |  | Deposit | pencil
 |  |  | Interest | pen |  |  | 0.85
 |  |  | Interest | paper |  |  | 42
 |  |  | Dividend | pin |  |  | 0.673
 |  |  | Dividend | plate |  |  | 87
 |  |  | Sell | cup |  |  | -2435
 |  |  | Redeemed | spoon |  |  | -3500
 |  |  | Redeemed | fork |  |  | -0.543
 |  |  | EFT | meat
 |  |  | Deposit | veg
 |  |  | Interest | Noodle |  |  | 0.44
 |  |  | Interest | salt |  |  | 34
 |  |  | Dividend | zero |  |  | 0.525
 |  |  | Dividend | Box |  |  | 46
 |  |  | Sell | cart |  |  | -221
 |  |  | Sell | pencil |  |  | -1930
 |  |  | Sell | pen |  |  | -1531
 |  |  | Sell | paper |  |  | -3717
 |  |  | Redeemed | pin |  |  | -0.331
 |  |  | Redeemed | plate |  |  | -0.465
 |  |  | Redeemed | cup |  |  | -0.004
 |  |  | Redeemed | spoon |  |  | -0.533
 |  |  | EFT | fork
 |  |  | EFT | meat
 |  |  | BALANCE | veg
 |  |  | Interest | Noodle |  |  | 0.18
 |  |  | Redeemed | salt |  |  | -3500
Spreadsheet: susan_pereira__39558__Kochmeters
Sheet: Sheet1

[NAME] |  | Koch Zones & Areas
17154 |  | Zone 11 A4
12756 |  | Zone 1 A8
108035 |  | Zone 4 A2
10506 |  | Zone 2 A5
11465 |  | Zone 2 A5
2886 |  | Zone 4 A2
389 |  | [NAME]
11463 |  | [NAME]
17130 |  | [NAME]
478 |  | [NAME]
12685 |  | [NAME]
3491 |  | Zone 2 A5
20938 |  | Zone 2 A6
10119 |  | Zone 2 A9
11469 |  | Zone 2 A9
11948 |  | Zone 1 A9
10743 |  | Zone 1 A8
11782 |  | Zone 1 A8
12756 |  | Zone 1 A8
2883 |  | Zone 3 A1
9134 |  | Zone 1 A8
17149 |  | [NAME]
17155 |  | [NAME]
11462 |  | Zone 4 A2
17159 |  | [NAME]
9122 |  | [NAME]
9205 |  | Zone 4 A2
9922 |  | Zone 4 A2
9921 |  | [NAME]
464 |  | [NAME]
11463 |  | [NAME]
12685 |  | [NAME]
322 |  | [NAME]
177 |  | Zone 2 A5
10506 |  | Zone 2 A5
11467 |  | Zone 2 A7
9755 |  | Zone 2 A7
11468 |  | Zone 1 A8
11963 |  | Zone 1 A9
11469 |  | Zone 1 A9
Spreadsheet: 115874d1311345578-excel-claim-sorting-claims-sorting
Sheet: Summery

 |  |  | Paid No of Claims | Paid Total Amount | Outstanding No of Claims | Outstanding Total Amount
 | 2006-02-02 00:00:00 | 2007-02-01 00:00:00 | 3 | 5000 | 2 | 1000
 | 2007-02-02 00:00:00 | 2008-02-01 00:00:00
 | 2008-02-02 00:00:00 | 2009-02-01 00:00:00
 | 2009-02-02 00:00:00 | 2010-02-01 00:00:00
 | 2010-02-02 00:00:00 | 2011-02-01 00:00:00
 | 2011-02-02 00:00:00 | 2012-02-01 00:00:00
Spreadsheet: 92773d1292330919-formatting-bug-in-2010-strange-errorb
Sheet: Sheet1

 |  | Count | 11
 |  |  | 1 |  | 70000
 |  |  | 2 |  | 30000
 |  |  | 3 |  | 28000
 |  |  | 4 |  | 12000
 |  |  | 5 |  | 40000
 |  | Breakdown |  | Heading 1 | Heading 2 | Heading 3
 |  | A
 |  | B
 |  | C
 |  | D
 |  | E
 |  | F
 |  | G
 |  | H
 |  | Total
Spreadsheet: 186884d1350282259-format-cells-so-that-the-content-will-be-two-opts-only-and-cf-form-qfs-comp-send
Sheet: Sheet1

No | Issue |  | Area |  | Action Plan | PIC | Verifikasi Closing oleh PIC | Catatan |  | C/O
1 |  |  |  |  |  |  |  |  |  | Close
2 |  |  |  |  |  |  |  |  |  | Open
3
4
5
6
 |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  | Open Issue
 |  |  |  |  |  |  |  | Closed Issue
Spreadsheet: 678359d1589839007-if-formula-looking-at-another-tab-to-determine-results-eh_-project-planne
Sheet: Actions

ID | TASKS | RESPONSIBILITY | COMMENTS/DESCRIPTION | START DATE | DEADLINE | PRIORITY |  | STATUS |  | Next meeting & actions | 1 WEEK FROM START DATE | 2 WEEKS FROM START DATE | 3 WEEKS FROM START DATE | 4 WEEKS FROM START DATE | 5 WEEKS FROM START DATE | 6 WEEKS FROM START DATE | 7 WEEKS FROM START DATE | 8 WEEKS FROM START DATE | 9 WEEKS FROM START DATE | 10 WEEKS FROM START DATE
 |  |  |  |  |  |  |  |  |  | 18th June
1 |  | Ray |  | 2020-05-18 00:00:00 |  | Medium |  | Not Started |  | Not required
2 |  | Ray |  | 2020-05-18 00:00:00 |  | Medium |  | Not Started |  | Not required
3 | [NAME] to speak to [NAME] about displaying a CX badge (see Action No.3) | Client |  | 2020-05-18 00:00:00 |  | Medium |  | Not Started |  | Not required
4
5
6
7
8
9
ID | TASKS | RESPONSIBILITY | COMMENTS/DESCRIPTION | START DATE | DEADLINE | PRIORITY |  | STATUS |  | Next meeting & actions | 1 WEEK FROM START DATE | 2 WEEKS FROM START DATE | 3 WEEKS FROM START DATE | 4 WEEKS FROM START DATE | 5 WEEKS FROM START DATE | 6 WEEKS FROM START DATE | 7 WEEKS FROM START DATE | 8 WEEKS FROM START DATE | 9 WEEKS FROM START DATE | 10 WEEKS FROM START DATE
1
2
Spreadsheet: 126180d1319557473-find-and-replace-indirect-example
Sheet: 2013

Field 1 | Field 2 | Field 3 | Field 4
Data 21 | 0.23 | 635 | 74234
Data 22 | 0.87 | 594 | 88591
Data 23 | 0.78 | 82 | 17206
Data 24 | 0.79 | 970 | 32779
Data 25 | 0.82 | 731 | 7898
Data 26 | 0.05 | 592 | 94077
Data 27 | 0.33 | 574 | 10568
Data 28 | 0.91 | 995 | 65856
Data 29 | 0.77 | 555 | 70463
Data 30 | 0.26 | 17 | 45528
Spreadsheet: 862933d1710501699-if-a-value-exists-in-a-string-return-a-value-in-another-cell-top-winner-dj
Sheet: Sheet1

 | Top 3 | Top 4 | Top 4 |  | Winner
 | 4,8,2 |  |  |  | 4
 |  | 4,8,2,1 |  | L | 4 |  |  | if winner (Column F)  exists in Top 3 (Col B) I want W in Column E otherwise L in column E
 |  |  | 4,8,2,1,7 | L | 4
 | 1,2,5 |  |  | W | 1
 |  | 1,2,5,8 |  | L | 1
 |  |  | 1,2,5,8,9 | L | 1
 | 1,5,14 |  |  | L | 4
 |  | 1,5,9,14 |  | L | 4
 |  |  | 1,5,9,14,4,2 | L | 4
 | 2,1,7 |  |  | L | 5
 |  | 2,1,7,3 |  | L | 5
 |  |  | 2,1,5,3,7,6 | L | 5
 | 5,9,10 |  |  | W | 5
 |  | 5,9,10,2 |  | L | 5
 |  |  | 5,9,10,2,4 | L | 5
Spreadsheet: 35589d1233181057-returning-multiple-results-for-one-lookup-value-multivalue-return
Sheet: Data

STYLE | COO | Quantity | COLOR | CUTTING RATIO | 1ST COST
2871 | USA | 352 | SILVERSTAR | XS-XL | 9.25
2879 | USA | 350 | WHITE | XS-XL | 8.9
2896 | USA | 502 | BLACK | XS-XL | 9.95
2856 | USA | 600 | BLACK | XS-XL | 5.7
2864 | USA | 300 | PINK | XS-XL | 6
2864 | USA | 200 | GOLD | XS-XL | 6
2828 | USA | 450 | YELLOW | XS-XL | 6.3
2784 | USA | 300 | RED PEPPER | XS-XL | 5.5
2784 | USA | 200 | AEGEAN SEA | XS-XL | 5.5
2750 | USA | 250 | RED PEPPER | XS-XL | 5.71
2750 | USA | 250 | CAVE | XS-XL | 5.6
Spreadsheet: 166445d1341587184-minimum-distance-between-two-lat-long-points-book2
Sheet: Airports

ABE | 40.65236111111111 | -75.44041666666666
ABI | 32.41130555555556 | -99.68188888888889
ABQ | 35.04019444444445 | -106.6091944444444
ABR | 45.44905555555556 | -98.42183333333332
ACT | 31.61219444444444 | -97.23030555555555
ACV | 40.97783333333334 | -124.1084722222222
AGS | 33.36994444444444 | -81.9645
ALB | 42.74911111111111 | -73.80197222222222
AMA | 35.21936111111111 | -101.7059166666667
ASE | 39.22316666666666 | -106.8688611111111
ATL | 33.63669952777778 | -84.42786394444444
ATW | 44.25808333333333 | -88.51908333333334
AUS | 30.19452777777778 | -97.66988888888888
AVL | 35.43619444444445 | -82.54180555555556
AVP | 41.33847222222222 | -75.72338888888889
AZO | 42.23438888888889 | -85.55155555555555
BDL | 41.93914511111112 | -72.68337127777778
BFF | 41.87402777777778 | -103.5956388888889
BFI | 47.53 | -122.3019722222222
BFL | 35.43386111111111 | -119.0576666666667
BGM | 42.20855555555556 | -75.97972222222222
BGR | 44.80744444444444 | -68.82813888888889
BHM | 33.56388888888889 | -86.75230555555555
BIL | 45.80766666666667 | -108.5428888888889
BIS | 46.77272222222222 | -100.74575
BJI | 47.51072222222222 | -94.93472222222222
BLI | 48.79269444444445 | -122.5375277777778
BMI | 40.47711111111111 | -88.91591666666666
BNA | 36.12447222222222 | -86.67819444444444
BOI | 43.56436111111111 | -116.2228611111111
BOS | 42.36297222222223 | -71.00641666666667
BTM | 45.95480555555555 | -112.4974722222222
BTR | 30.53290577777778 | -91.14987686111111
BTV | 44.47186111111112 | -73.15327777777777
BUF | 42.94041666666666 | -78.73058333333333
BUR | 34.20066666666666 | -118.3586666666667
BWI | 39.17536111111111 | -76.66833333333334
BZN | 45.77757166666667 | -111.1520215555555
Spreadsheet: 692926d1598636811-index-and-match-function-printing-and-photocopying-reports
Sheet: English

English Printing and Photocopying
ENGLISH   22040
Staff | Number of Colour Pages | Number of Grayscale Pages
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Total
Spreadsheet: kate_symes__18518__SP 15 pages
Sheet: DJ SP15

 |  |  | Firm | Volume | Firm | Volume | Sun & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | 24 HOUR | [NAME]
 | 2001-01-26 00:00:00 |  | 211.11 | 21392 | 172.47 | 4456
 | 2001-01-25 00:00:00 |  | 208.12 | 14880 | 179.01 | 6280
 | 2001-01-24 00:00:00 |  | 222.73 | 18880 | 169.8 | 6240
 | 2001-01-23 00:00:00 |  | 251.47 | 12800 | 171.59 | 5800
 | 2001-01-22 00:00:00 |  | 267.54 | 15440 | 185.36 | 2800
 | 2001-01-21 00:00:00 |  |  |  |  |  | 185 | 2400
 | 2001-01-20 00:00:00 |  | 435.91 | 4400 | 260.09 | 3584
 | 2001-01-19 00:00:00 |  | 435.91 | 4400 | 260.09 | 3584
 | 2001-01-18 00:00:00 |  | 326.07 | 5600 | 216.1 | 3080
 | 2001-01-17 00:00:00 |  | 232.5 | 8000 | 179.95 | 3680
 | 2001-01-16 00:00:00 |  | 181.85 | 13600 | 133.91 | 1880
 | 2001-01-15 00:00:00 |  | 181.85 | 13600 | 133.91 | 1880
 | 2001-01-14 00:00:00 |  |  |  |  |  | 128.51 | 4440
 | 2001-01-13 00:00:00 |  | 169.31 | 26800 | 128.51 | 1480
 | 2001-01-12 00:00:00 |  | 170.09 | 18800 | 123.67 | 2400
 | 2001-01-11 00:00:00 |  | 170.09 | 18800 | 123.67 | 2400
 | 2001-01-10 00:00:00 |  | 164.78 | 14800 | 129.9 | 2000
 | 2001-01-09 00:00:00 |  | 155.6 | 14000 | 129.75 | 3200
 | 2001-01-08 00:00:00 |  | 135.72 | 11600 | 102.7 | 2000
 | 2001-01-07 00:00:00 |  |  |  |  |  | 102.7 | 6000
 | 2001-01-06 00:00:00 |  | 139.35 | 10400 | 101.82 | 4400
 | 2001-01-05 00:00:00 |  | 139.35 | 10400 | 101.82 | 4400
 | 2001-01-04 00:00:00 |  | 146.31 | 6400 | 108.22 | 3600
 | 2001-01-03 00:00:00 |  | 146.92 | 4800 | 115.58 | 2400
 | 2001-01-02 00:00:00 |  | 143.57 | 2800 | 120 | 2600
 | 2001-01-01 00:00:00 |  |  |  |  |  | 120 | 7800
 | 2000-12-31 00:00:00 |  |  |  |  |  | 112 | 6000
 | 2000-12-30 00:00:00 |  | 135.5 | 4000 | 112 | 2000
 | 2000-12-29 00:00:00 |  | 176.02 | 3520 | 90.91 | 2200
 | 2000-12-28 00:00:00 |  | 174.87 | 3120 | 90.91 | 2200
 | 2000-12-27 00:00:00 |  | 239.8 | 2000 | 146.18 | 2200
Spreadsheet: 873303d1719801207-two-formulas-test-copy
Sheet: Tab 2

#
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
Spreadsheet: 207465d1358460571-custom-list-validation-dynamicpicklist
Sheet: Sheet1

Picks | Values | Key |  |  |  | Picklist>>
Pick1
Pick2 |  |  |  |  |  | Maxpick
[NAME] |  |  |  |  |  | 30
Pick4
Pick5
Pick6 |  |  |  |  |  |  |  |  | Press F9 and check how the list in H changes, and thus J3 drop list changes
Pick7 |  |  |  |  |  |  |  |  | The named range [NAME] only displays the number of listed values in column H
Pick8
Pick9
Spreadsheet: 879432d1726935149-whats-wrong-with-the-formula-exf
Sheet: Sheet1

 |  |  |  |  |  | Sr# | D. Month | Start | End |  | Current Date
 |  |  |  |  |  | 1 | چیت | 2024-03-14 00:00:00 | 2024-04-13 00:00:00
 |  |  |  |  |  | 2 | ویساکھی | 2024-04-14 00:00:00 | 2024-05-14 00:00:00
 |  |  |  |  |  | 3 | جیٹھ | 2024-05-15 00:00:00 | 2024-06-14 00:00:00
 |  |  |  |  |  | 4 | ہاڑ | 2024-06-15 00:00:00 | 2024-07-15 00:00:00
 |  |  |  |  |  | 5 | ساون | 2024-07-16 00:00:00 | 2024-08-15 00:00:00
 |  |  |  |  |  | 6 | بھادوں | 2024-08-16 00:00:00 | 2024-09-14 00:00:00
 |  |  |  |  |  | 7 | اسو | 2024-09-15 00:00:00 | 2024-10-14 00:00:00 | Should be the right answer #7 اسو in L6
 |  |  |  |  |  | 8 | کاتک | 2024-10-15 00:00:00 | 2024-11-13 00:00:00
 |  |  |  |  |  | 9 | مگھڑ | 2024-11-14 00:00:00 | 2024-12-13 00:00:00
 |  |  |  |  |  | 10 | پوہ | 2024-12-14 00:00:00 | 2024-01-12 00:00:00 | Showing this answer which is wrong in L6
 |  |  |  |  |  | 11 | مگہ | 2024-01-13 00:00:00 | 2024-02-11 00:00:00
 |  |  |  |  |  | 12 | پھاگن | 2024-02-12 00:00:00 | 2024-03-13 00:00:00
Spreadsheet: 233811d1367935607-building-a-parts-list-sample-list-solution
Sheet: Sheet1

 | Qty | Description | Unit Price | Net Price | % GM | Cost
1 | 1 | Part 6 | 227 | 227 | 0.5581581497797357 | 100.2981
2 | 1 | Part 164 | 3853 | 3853 | 0.556592365418918 | 1708.449616040909
3 | 1 | Part 190 | 535 | 535 | 0.5567409398725573 | 237.1435971681818
4 | 3 | Part 248 | 328 | 984 | 0.558203094941796 | 144.9093848590909
5 | 1 | Part 251 | 596 | 596 | 0.5584545112949969 | 263.1611112681819
6 | 1 | Part 266 | 2475 | 2475 | 0.556588468194674 | 1097.443541218182
7 | 1 | Part 268 | 338 | 338 | 0.5624551862157073 | 147.8901470590909
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
Spreadsheet: 08206b25-f6c6-47bf-8275-028259d6aa10
Sheet: Sheet1

Murder | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
 | 1993
Age Group | Total | Male | Female
12 and under | 0.1024580841035831 | 0.1477386262843947 | 0.05497424386146962
13-14 | 6.26457298252242 | 11.12964618252905 | 1.155249638800587
15 | 20.53125672251551 | 37.45438850751619 | 2.697565628744603
16 | 35.90333663281149 | 67.13609620801985 | 2.784754478261569
17 | 50.43331236521194 | 92.65099585975877 | 5.487970310176935
18 | 59.16862475506624 | 110.1028582105074 | 5.616658726721798
19 | 53.5051222278089 | 98.60864819623552 | 6.470824611464298
20 | 46.81098320927909 | 87.14333793748956 | 4.710937738108379
21 | 40.03273587134366 | 73.98507764931217 | 4.597065651090112
22 | 35.37688852029296 | 64.54817313117854 | 5.195637876957855
23 | 30.94534019736453 | 56.74655069807721 | 4.351535908937326
24 | 26.09557012096793 | 46.61878015202092 | 5.030107945938478
25-29 | 18.50468357989898 | 32.62255954411395 | 4.28231725959591
30-34 | 11.14392310347419 | 19.08996453422008 | 3.241595494319493
35-39 | 8.23986394760706 | 13.74225254001625 | 2.798109606583347
40-44 | 5.6849279004859 | 9.9060502261738 | 1.564166927262205
45-49 | 4.279176163404061 | 7.406666186312648 | 1.264348953498797
50-54 | 3.545301979546378 | 6.278352289809044 | 0.9593321197573232
55-59 | 2.38399178335598 | 4.170363249960094 | 0.7380927653119882
60-64 | 1.508280576608447 | 2.786581519198238 | 0.3775169241636656
65 and over | 0.7029519543878223 | 1.534284976516918 | 0.1361703928181045
Spreadsheet: 60593d1261094864-excel-2007-some-form-of-vlookup-type-function-book3
Sheet: Sheet1

Hole | From | To | in this column I need the "Seam" of the lookup data to match the from\to in this portion of the sheet…
BH1 | 45.79 | 47.71 | FOR EXAMPLE:  This interval is covered by the seam B |  |  |  |  |  | Hole | Seam | From | To
BH1 | 45.79 | 45.9 | FOR EXAMPLE:  This interval is covered by the seam B |  |  |  |  |  | BH1 | A | 43.7 | 43.85
BH1 | 47.25 | 47.4 | FOR EXAMPLE:  This interval is covered by the seam B |  |  |  |  |  | BH1 | B | 45.79 | 47.71
BH1 | 47.4 | 47.63 | FOR EXAMPLE:  This interval is covered by the seam B |  |  |  |  |  | BH1 | C | 54.01 | 54.36
BH1 | 47.63 | 47.66 | FOR EXAMPLE:  This interval is covered by the seam B |  |  |  |  |  | BH1 | D | 54.36 | 55.44
BH1 | 47.66 | 47.68 | FOR EXAMPLE:  This interval is covered by the seam B |  |  |  |  |  | BH1 | E | 55.44 | 56.16
BH1 | 47.68 | 47.71 | FOR EXAMPLE:  This interval is covered by the seam B |  |  |  |  |  | BH1 | F | 6.75 | 8
BH1 | 47.71 | 47.81 |  |  |  |  |  |  | BH1 | G | 65.15 | 65.64
BH1 | 54.36 | 54.47 |  |  |  |  |  |  | BH1 | H | 71.12 | 71.789
BH1 | 54.47 | 54.99 |  |  |  |  |  |  | BH1 | I | 71.789 | 72.176
BH1 | 54.99 | 55.3 |  |  |  |  |  |  | BH1 | J | 72.176 | 74.19
BH1 | 55.3 | 55.39
BH1 | 45.9 | 45.92 |  |  |  |  |  |  | this is my lookup data
BH1 | 54.47 | 56.16
BH1 | 55.39 | 55.46
BH1 | 55.46 | 56.16
BH1 | 71.12 | 71.4
BH1 | 71.4 | 71.62
BH1 | 71.62 | 71.74
BH1 | 71.74 | 71.75
BH1 | 71.75 | 71.94
BH1 | 71.94 | 71.97
BH1 | 71.97 | 72.13
BH1 | 72.13 | 72.2
BH1 | 45.92 | 46.35
BH1 | 71.12 | 74.19
BH1 | 72.2 | 72.91
BH1 | 72.91 | 72.95
BH1 | 72.95 | 73.26
BH1 | 73.26 | 73.31
BH1 | 73.31 | 73.79
BH1 | 73.79 | 73.81
BH1 | 73.81 | 74.17
BH1 | 74.17 | 74.19
BH1 | 74.19 | 74.29
BH1 | 46.35 | 46.42
BH1 | 46.42 | 46.68
BH1 | 46.68 | 46.69
BH1 | 46.69 | 46.83
BH1 | 46.83 | 47.07
BH1 | 47.07 | 47.25
Spreadsheet: 179806d1347379940-information-auto-fill-ingredients-list
Sheet: Sheet1

Ingredients | Gross Price | Gross Weight | Unit
Plain Flour | 1.7 | 1000 | g
S/F Flour | 1.7 | 1000 | g
Stork | 2.1 | 1000 | g
Butter | 1.6 | 250 | g
Caster Sugar | 1.65 | 1000 | g
Eggs | 1.89 | 18 | Single
Spreadsheet: dana_davis__4474__CANADA - 46L - A
Sheet: E31.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 46L
COMPANY NAME:  SUNDANCE ECT CANADA ACCOUNTING ENTITY
RECONCILIATION OF STOCKHOLDERS' EQUITY AND INVESTMENT IN SUBS
FOR THE 6 MONTHS ENDED 6-30-2000
PREPARED BY:  Laynie East
EXTENSION:  3-3131 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-31
 |  |  |  | 12-31-99 Balance |  |  |  | EQUITY IN |  | DIVIDENDS DECLARED |  |  |  | OTHER ACTIVITY
 |  |  |  | DR  (CR) |  | RECLASS '99 NI |  | EARNINGS |  |  |  |  |  |  |  |  |  | DR  (CR)
 |  | Hyp line |  | BEG BALANCE |  | TO BEG RE |  | /LOSSES |  | COMMON |  | PREFERRED |  | DR (CR) |  | (Describe) |  | END BALANCE
Shareholders Equity by Parent |  | Reverse signs from Hyperion
Common Stock |  | 0901
Paid in Capital |  | 0910
Contribution Received from Parent |  | 0915
RE - Beg Bal |  | 0920 |  |  |  | -2002512
RE - Net Income |  | 0930 |  | -2002512 |  | 2002512 |  | -1144755
RE - Net Income (Fair Value Adjustment) |  | 0931
Dividends Decl - Preferred Stock |  | 0935
Dividends Decl - Common Stock |  | 0941
Invest in Subs Plug Account |  | 0942
Total Shareholders' Equity |  | TOT_SHARE_EQU
Net Income |  | NET_INCOME
PARENT'S CO # |  | 46H
Investment in Consol Sub (on Parent Books) |  |  |  | Same signs as Hyperion
Investment in CS |  | 0215
Investment in PIC (contrib by parent) |  | 0216
Investment in Equity earnings of sub |  | 0217 |  | 1829136 |  |  |  | 0
Total Investment in Consol Sub
Equity in Consol Sub |  | 1505 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -2002512
Difference between SE (on sub) and Invest (on parent)
Reasons for Differences
Net Income, rolled to Parent annually |  |  |  |  |  |  |  | -1144755
A schedule will need to be prepared for each subsidiary.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-31