tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 452416d1458731449-auto-populate-tab-based-on-drop-down-from-different-tab-projec-tracker
Sheet: HPT

HPT Project Tracker
 | # | Priority | Project Description | Impact | Approximate Cost | Champion | Status | Completion Goal | Comments
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 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
Spreadsheet: 820093d1677859199-excel-conditional-formatting-whole-row-manpower-schedule
Sheet: Sheet1

P&S Manpower Schedule |  | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday
Job List | Name | 2023-03-06 00:00:00
111 - Office | [NAME] | 408 | 408 | 408 | 408 | 408 |  |  | 400 | 400 | 400 | 400 | 400 |  |  | 400 | 400 | 400 | 400 | 400 |  |  | 400 | 400 | 400 | 400 | 400 |  |  | 400 | 400 | 400 | 400 | 400
292 - CRREL Hanover NH | Long Nguyen
298 - B106 Groton CT | [NAME] | 410 | 410 | 410
400 - Ductbank Cutler ME | [NAME] | 111 | 404 | 111 | 404
404 - B1435 Hanscom AFB | [NAME] | 298 | 298 | 298 | 298 | 298
406 - B119 Newport, RI
407 - B264 Pease ANG
408 - GSA VT
409 - Raymark Stratford, CT
410 - Bldg F Elev MITLL
Spreadsheet: 23a1d0a0-b90b-4c08-aba3-deb9657deeff
Sheet: Sheet1

Representative in Congress (North Dakota) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Downloaded at 5/24/2013 11:45:44 AM
Precincts Reporting: 607/607 - Total Ballots Cast: 316016
2004 General Election - OFFICIAL RESULTS
Precinct | [NAME] | [NAME] | TOTALS
Precinct 1201 | 552 | 785 | 1337
Precinct 1202 | 492 | 819 | 1311
Precinct 1203 | 474 | 733 | 1207
Precinct 1205 | 435 | 824 | 1259
Precinct 1206 | 406 | 605 | 1011
Precinct 2901 | 61 | 75 | 136
Precinct 2902 | 64 | 119 | 183
Precinct 2903 | 69 | 145 | 214
Precinct 2904 | 50 | 84 | 134
Precinct 2905 | 76 | 147 | 223
Precinct 2906 | 132 | 137 | 269
Precinct 2907 | 88 | 120 | 208
Precinct 2908 | 171 | 249 | 420
Precinct 2909 | 125 | 195 | 320
Precinct 2910 | 176 | 252 | 428
Precinct 2911 | 97 | 85 | 182
Precinct 2912 | 114 | 140 | 254
Precinct 2941 | 399 | 606 | 1005
TOTAL | 3981 | 6120 | 10101
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 672081d1586718251-ranking-without-duplicates-without-skipping-numbers-sample_new_1stmarch
Sheet: Runners

Date | Meeting | Time | H/Cap | Class | Age | Code | Dist | Run | Type1 | Type2 | [NAME] | No | Horse | Form | Grade | Distance | Going | Speed | Rating | RTD | Won | Odds | Returns | Draw | Trainer | [NAME] | Distance |  | Going | Top5 | Speed | Top5 | CD | Prize | BHA | WT | DSLR | Age | Cr | Cl | Lm | To | Draw% | RS | [NAME] | Rank | LTO | Rank | Days | Ave | MA | Rank | Diff | Cse | Dist | Abiliy | Form | F/C | HForm | Prize | BHA | [NAME] 3 | Trainer 4/5 | [NAME] | Jocks 4/5 | T14 | J14
Spreadsheet: 464967d1465391231-error-while-checking-the-check-boxes-474-checkboxes-and-graph
Sheet: Sheet11

 |  | Social Media Overview
 | Social Media | Sessions | Page views | Avg,session duration | pages/session
 | Facebook | 222 | 595 | 00:02:32 | 2.68
 | Blogger | 2 | 3 | 00:00:22 | 1.5
 | stumbleupon | 1 | 1 | 00:00:00 | 1
 | Disqus | 1 | 1 | 00:00:00 | 1
 | Facebook apps | 2 | 5 | 00:00:12 | 2.5
 | TOTAL | 228 | 605
Spreadsheet: b7b78646-599d-4fe4-808e-6cf1935fb373
Sheet: Sheet1

Campus | Last Name | First Name | [NAME] | Phone Number | Fax Number | Street | Street2 | City | State | Zip
Appalachian State University | Ellis | Marjorie | [EMAIL] | [PHONE] | [PHONE] | Academy Drive |  | Boone | NC | 28608
East Carolina University | Thompson | [NAME] | [EMAIL] | [PHONE] |  | East Fifth Street |  | Greenville | NC | 27858
Elizabeth City State University | Whitehurst-McLean | Makitta | [EMAIL] | [PHONE] | [PHONE] | 1704 Weeksville Road |  | Elizabeth City | NC | 27909
Fayetteville State University | Cameron | Helene | [EMAIL] | [PHONE] |  | 1200 Murchison Road |  | Fayetteville | NC | 28301
NC Agricultural and Technical State University | Edwards | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 1601 East Market Street |  | Greensboro | NC | 27411
North Carolina Central University | Hembrick | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 1801 Fayetteville Street |  | [NAME] | NC | 27707
NC State University | Bell | [NAME] | [EMAIL] | [PHONE] |  | Patterson Hall 111 | Box 7642 | Raleigh | NC | 27695-7642
UNC Asheville | Mowitz | Marlane | [EMAIL] | [PHONE] | [PHONE] | 1 University Heights |  | Asheville | NC | 28804
UNC-Chapel Hill | Angle | Ray | [EMAIL] | [PHONE] |  | 211 Carr Building | CB #5000 | Chapel Hill | NC | 27599-5000
UNC Charlotte |  |  |  |  |  | 9201 University City Boulevard |  | Charlotte | NC | 28223
UNC Greensboro | [NAME] | [NAME] | [EMAIL] | [PHONE] | [PHONE] | [NAME] 26170 |  | Greensboro | NC | 27402-6170
UNC Pembroke | Pruett | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 1 University Drive |  | Pembroke | NC | 28372
[NAME] | Rakes | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 601 South College Road |  | [NAME] | NC | 28403
UNC School of the Arts |  |  |  |  |  | 1533 South Main St. |  | Winston-Salem | NC | 27127
Western Carolina University |  |  |  |  |  |  |  | Cullowhee | NC | 28723
Winston-Salem State University | Sloan | [NAME] | [EMAIL] | [PHONE] |  | 601 [NAME], Jr. Drive |  | Winston-Salem | NC | 27110
North Carolina School of Science and Mathematics |  |  |  |  |  | 1219 Broad Street |  | [NAME] | NC | 27705
Spreadsheet: 102933d1300815283-summing-indirect-based-on-column-and-row-headers-roi-metrics
Sheet: Broadway

2011-03-01 00:00:00
-20024.2628190597
172752.830348642
15578.8303486421
18028.8303486421
42944.8303486421
10043.8303486421
12886.8303486421
639410.830348642
32517.8303486421
4717.83034864215
41016.8303486421
23617.8303486421
24098.8303486421
21665.8303486421
34222.8303486421
74232.8303486421
25267.8303486421
4389.83034864215
55928.8303486421
19149.8303486421
9462.83034864215
44251.8303486421
21440.8303486421
13524.8303486421
117664.830348642
31273.8303486421
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
-54085.1696513578
NULL
NULL
NULL
NULL
NULL
NULL
-549.169651357845
NULL
NULL
NULL
-8821.2628190597
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
Spreadsheet: 787449d1657804073-formula-to-write-day-and-month-from-a-timestamp-timestamps-to-day-and-month
Sheet: Sheet1

 |  |  | Expected Results
 |  | 2022-06-16 00:00:00.620Z | 2022-06-16 00:00:00
 |  | 2022-06-16 00:00:01.903Z | 2022-06-16 00:00:00
 |  | 2022-06-16 00:00:02.264Z | 2022-06-16 00:00:00
 |  | 2022-06-16 00:00:03.316Z | 2022-06-16 00:00:00
 |  | 2022-06-16 00:00:03.735Z | 2022-06-16 00:00:00
 |  | 2022-06-16 00:00:04.401Z | 2022-06-16 00:00:00
 |  | 2022-06-16 00:00:04.629Z | 2022-06-16 00:00:00
 |  | 2022-06-16 00:00:04.658Z | 2022-06-16 00:00:00
 |  | 2022-06-16 00:00:05.024Z | 2022-06-16 00:00:00
 |  | 2022-06-16 00:00:05.718Z | 2022-06-16 00:00:00
 |  | 2022-06-19 22:05:00.415Z | 2022-06-19 00:00:00
 |  | 2022-06-19 22:05:00.522Z | 2022-06-19 00:00:00
 |  | 2022-06-19 22:05:00.656Z | 2022-06-19 00:00:00
 |  | 2022-06-19 22:05:01.043Z | 2022-06-19 00:00:00
 |  | 2022-06-19 22:05:02.063Z | 2022-06-19 00:00:00
 |  | 2022-06-19 22:05:02.136Z | 2022-06-19 00:00:00
 |  | 2022-06-19 22:05:03.246Z | 2022-06-19 00:00:00
 |  | 2022-06-19 22:05:04.516Z | 2022-06-19 00:00:00
 |  | 2022-06-19 22:05:05.594Z | 2022-06-19 00:00:00
 |  | 2022-06-19 22:05:06.164Z | 2022-06-19 00:00:00
 |  | 2022-06-19 22:05:06.325Z | 2022-06-19 00:00:00
 |  | 2022-06-19 22:05:06.592Z | 2022-06-19 00:00:00
 |  | 2022-06-19 22:05:08.353Z | 2022-06-19 00:00:00
 |  | 2022-05-01 22:05:01.466Z | 2022-05-01 00:00:00
 |  | 2022-05-01 22:05:02.630Z | 2022-05-01 00:00:00
 |  | 2022-05-01 22:05:04.053Z | 2022-05-01 00:00:00
 |  | 2022-05-01 22:05:04.538Z | 2022-05-01 00:00:00
 |  | 2022-05-01 22:05:07.030Z | 2022-05-01 00:00:00
 |  | 2022-05-01 22:05:08.133Z | 2022-05-01 00:00:00
 |  | 2022-05-01 22:05:09.206Z | 2022-05-01 00:00:00
 |  | 2022-05-01 22:05:09.559Z | 2022-05-01 00:00:00
 |  | 2022-05-01 22:05:10.093Z | 2022-05-01 00:00:00
 |  | 2022-05-01 22:05:11.324Z | 2022-05-01 00:00:00
 |  | 2022-05-01 22:05:12.496Z | 2022-05-01 00:00:00
 |  | 2022-05-01 22:05:15.529Z | 2022-05-01 00:00:00
 |  | 2022-05-01 22:05:15.859Z | 2022-05-01 00:00:00
 |  | 2022-05-01 22:05:17.032Z | 2022-05-01 00:00:00
 |  | 2022-05-01 22:05:17.413Z | 2022-05-01 00:00:00
 |  | 2022-05-01 22:05:18.734Z | 2022-05-01 00:00:00
 |  | 2022-05-01 22:05:19.142Z | 2022-05-01 00:00:00
 |  | 2022-05-01 22:05:20.142Z | 2022-05-01 00:00:00
 |  | 2022-05-01 22:05:21.371Z | 2022-05-01 00:00:00
 |  | 2022-05-01 22:05:23.101Z | 2022-05-01 00:00:00
 |  | 2022-05-17 12:27:02.604Z | 2022-05-17 00:00:00
 |  | 2022-05-17 12:27:03.741Z | 2022-05-17 00:00:00
 |  | 2022-05-17 12:27:05.162Z | 2022-05-17 00:00:00
 |  | 2022-05-17 12:27:06.170Z | 2022-05-17 00:00:00
 |  | 2022-05-17 12:27:06.253Z | 2022-05-17 00:00:00
 |  | 2022-05-17 12:27:07.014Z | 2022-05-17 00:00:00
 |  | 2022-05-17 12:27:07.988Z | 2022-05-17 00:00:00
 |  | 2022-05-17 12:27:08.042Z | 2022-05-17 00:00:00
 |  | 2022-05-17 12:27:09.027Z | 2022-05-17 00:00:00
 |  | 2022-05-17 12:27:10.076Z | 2022-05-17 00:00:00
 |  | 2022-05-17 12:27:11.415Z | 2022-05-17 00:00:00
Spreadsheet: 269047d1380922891-dropdownl-list-hyperlink-generator
Sheet: Results

 | Players [NAME] |  |  | Best Score
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Ladonnia Hollingsworth
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
Spreadsheet: 876062d1722708048-formular-with-if-and-x-find-map1
Sheet: Blad1

pages | total packs |  | pages | total packs
42,5 gram WE |  |  | 52 gram WE |  |  |  |  | 42.5
4 | 200 | 50 | 4 | 200 | 50
6 | 200 | 50 | 6 | 200 | 50
8 | 200 | 50 | 8 | 200 | 50 |  |  | 40
10 | 200 | 50 | 10 | 200 | 50 |  |  | 40
12 | 100 | 25 | 12 | 100 | 25
14 | 100 | 25 | 14 | 100 | 25 |  |  | 40
16 | 100 | 25 | 16 | 100 | 25
18 | 100 | 25 | 18 | 100 | 25
20 | 100 | 25 | 20 | 100 | 25
22 | 80 | 40 | 22 | 80 | 40
24 | 80 | 40 | 24 | 80 | 40
26 | 80 | 40 | 26 | 80 | 40
28 | 60 | 30 | 28 | 60 | 30
30 | 60 | 30 | 30 | 60 | 30
32 | 60 | 30 | 32 | 60 | 30
34 | 60 | 30 | 34 | 60 | 30
36 | 60 | 30 | 36 | 60 | 30
38 | 60 | 30 | 38 | 60 | 30
40 | 60 | 30 | 40 | 40 | 20
Spreadsheet: 60821d1261408777-data-validation-problem-in-excel-datavalidation
Sheet: Sheet1

SL. NO | Description | UNIT BASIC  PRICE | EXCISE DUTY (Amount) | Sales Tax applicable for Supply in Areas of |  |  |  | PACKING & FORWARDING CHARGES (RS.) | FREIGHT (RS.) | TRANSIT INSURANCE (RS.) | OTHER CHARGES (RS.) | TOTAL LANDED VALUE
 |  |  |  | Madhya Pradesh |  | Chhattisgarh |  |  |  |  |  | FOR SUPPLIES IN AREAS OF
 |  |  |  | CST | VAT | CST | VAT |  |  |  |  | MP | C.G.
 |  | (Rs. Each) | (Rs Each.) | (Rs Each.) | (Rs Each.) | (Rs Each.) | (Rs Each.) | (Rs Each.) | (Rs Each.) | (Rs Each.) | (Rs Each.) | (Rs Each.) | (Rs Each.)
1 | [NAME]
2 | [NAME]
3 | [NAME]
Spreadsheet: 153463d1335920627-manufacturing-inventory-control-inventory-tracking-rev-05d
Sheet: Inventory

2012-05-01 17:52:31 |  |  | Order | Current |  | Starting |  | Daily
 | Quantity | Re-order | Quantity | Quantity |  | Quantity |  | Usage | Days of Stock |  | Line |  |  | Total | Total
Material Description | Used | Threshold | Received | On Hand | Last Quantity Used | On Hand | [NAME] | Rate | Remaining | Ordering Website | Number |  | Starting Date | Used | Received
Polyimid |  | 5 |  |  |  |  |  |  |  | SIGMA-ALDRICH | 1
 |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  | 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
Spreadsheet: 154523d1336472309-index-match-help-demon8991_example-2_08may12_01
Sheet: Rail Operations

[NAME] Event Detail
 |  |  |  | 8 | RAIL OPERATIONS (1902878)
24 | 17
Reported Date | Claim ID | Division (FLEET DATA LEVEL_06_NODE_DS) | Name | Location | Event Description | Accident Date
IN THIS CELL IF COLUMN H ON 'FLEET DATA ACC DETAIL' READS 'RAIL OPERATIONS (1902878)' THEN PULL INFOMRATION FROM COLUMN X ON 'FLEET DATA ACC DETAIL' | IN THIS CELL IF COLUMN H ON 'FLEET DATA ACC DETAIL' READS 'RAIL OPERATIONS (1902878)' THEN PULL INFOMRATION FROM COLUMN Q ON 'FLEET DATA ACC DETAIL' | IN THIS CELL IF COLUMN H ON 'FLEET DATA ACC DETAIL' READS 'RAIL OPERATIONS (1902878)' THEN PULL INFOMRATION FROM COLUMN J ON 'FLEET DATA ACC DETAIL' |  | IN THIS CELL IF COLUMN H ON 'FLEET DATA ACC DETAIL' READS 'RAIL OPERATIONS (1902878)' THEN PULL INFOMRATION FROM COLUMN AB ON 'FLEET DATA ACC DETAIL' | IN THIS CELL IF COLUMN H ON 'FLEET DATA ACC DETAIL' READS 'RAIL OPERATIONS (1902878)' THEN PULL INFOMRATION FROM COLUMN V ON 'FLEET DATA ACC DETAIL' | IN THIS CELL IF COLUMN H ON 'FLEET DATA ACC DETAIL' READS 'RAIL OPERATIONS (1902878)' THEN PULL INFOMRATION FROM COLUMN W ON 'FLEET DATA ACC DETAIL'
2011-06-14 00:00:00 | DRAG DOWN | DRAG DOWN | DRAG DOWN | DRAG DOWN | DRAG DOWN | DRAG DOWN
2011-03-23 00:00:00
2011-09-19 00:00:00
2011-04-18 00:00:00
2011-11-10 00:00:00
2011-10-25 00:00:00
2011-02-18 00:00:00
2011-02-04 00:00:00
Spreadsheet: 2f2b7b14-dfd8-41d6-9b6a-38d8b00efb7e
Sheet: DV-IDENTITY-0

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | eycrYk20JPc= | eycrYk20JPg= | eycrYk20JPk=
Spreadsheet: 862604d1710278487-solver-doesnt-find-global-max-solver_issue_example
Sheet: Test

Days to Expiration |  | 10
Strike Price = % of Stock Buy | 1
Volatility | 0.6
Risk-Free Rate | 0.05
 |  |  |  |  | Stock dates |  | Stock value | 100 Shares | Stock Profit | Stock %Profit | Days to Expiration | Option strike | Option Value | Option Profit | Option % Profit
# Option Contracts | 10 |  |  | Buy | 2019-10-01 00:00:00 | Buy | 15.01
Cost/contract | 0 |  |  | Sell | 2019-10-08 00:00:00 | Sell | 15.36
Use Solver to Maximize cell P8 (Orange highlight) by changing variable cells C2 & B3 (Yellow highlights)
NOTE: I really wanted to change cell B2 instead of C2, but the integer constraint didn’t work for Cell B2 so I instead change C2 while setting B2=int(C2)
Optimal values are C3=7 (or any value 7-7.99999), B2=7 and B3=91.65% which results in P8=18.34%
However, the solver does not find the optimal values. For example, if I start with C2=10 and B3=100%; I get C2=41.95 and [NAME], B3=86.95% and P8=8.50%
Spreadsheet: 763961d1642505423-order-scheduler-formula-help-required-please-order-schedule-test
Sheet: WK2

Product Code | Description | Order | [NAME] | Date Required (Week Commencing)
Product 1 |  | 468550 | 2028 | 2021-12-13 00:00:00
Product 3 |  | 468542 | 1820 | 2022-01-10 00:00:00
Product 3 |  | 472923 | 1820 | 2022-01-17 00:00:00
Product 4 |  | 469945 | 1820 | 2022-01-17 00:00:00
Product 8 |  | 463348 | 3042 | 2022-01-17 00:00:00
Product 2 |  | 469944 | 1820 | 2022-01-24 00:00:00
Product 6 |  | 467287 | 3042 | 2022-01-24 00:00:00
Product 4 |  | 477064 | 1820 | 2022-01-31 00:00:00
Product 6 |  | 481161 | 3042 | 2022-02-07 00:00:00
Product 9 |  | 477067 | 2704 | 2022-02-07 00:00:00
Product 10 |  | 456820 | 3042 | 2022-02-07 00:00:00
Product 5 |  | 477065 | 2028 | 2022-02-21 00:00:00
Product 9 |  | 477068 | 2704 | 2022-02-28 00:00:00
Product 3 |  | 479841 | 1820 | 2022-03-07 00:00:00
Product 4 |  | 478386 | 1820 | 2022-03-07 00:00:00
Product 6 |  | 481162 | 3042 | 2022-03-07 00:00:00
Product 10 |  | 477069 | 3042 | 2022-03-14 00:00:00
Product 9 |  | 479842 | 2704 | 2022-03-21 00:00:00
Product 4 |  | 478387 | 1820 | 2022-03-28 00:00:00
Product 7 |  | 439127 | 3042 | TBC
Product 7 |  | 442911 | 3042 | TBC
Product 7 |  | 444593 | 3042 | TBC
Spreadsheet: 636604d1565375671-help-calendar-correction-employee-absence-schedule-current-6-5-19
Sheet: December

 | Employee Absence Schedule
 | Absence Type Key | V | Vacation |  |  | P | Pick Up Shift |  |  | S | Sick |  |  | Custom 1 |  |  |  | Custom 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Enter year:
 | December | Dates of Absence/Pick up |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2019
 | Employee Name | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 |  |  |  | Vacation Days Taken/Year | Vacation  Days Taken/Month | Days Picked Up/Month | Sick Days/Month
 | [NAME]
 | Lynda
 | [NAME]
 | Heather
 | [NAME]
 | Emili
 | Amber
 | Meredith
 | Julie
Spreadsheet: 18ce49b9-adda-4a8b-9c82-04a82fdc6b6e
Sheet: Sheet1

DELTA AIR LINES INC /DE/ | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
8-K
07/01/2013
DELTA AIR LINES, INC.
 | For | Against | Abstain | Broker
Nominee |  |  |  | Non-Votes
[NAME] | 613273917 | 643780 | 313839 | 99869216
[NAME] | 613072133 | 834739 | 324664 | 99869216
[NAME] | 602686320 | 11130054 | 415162 | 99869216
[NAME] | 612867833 | 966148 | 397555 | 99869216
[NAME] | 612884307 | 934945 | 412284 | 99869216
[NAME] | 611900715 | 1924330 | 406491 | 99869216
[NAME] | 613134704 | 698302 | 398530 | 99869216
[NAME] | 612495135 | 1342376 | 394025 | 99869216
[NAME] | 612769178 | 1070698 | 391660 | 99869216
[NAME] | 609782806 | 4068480 | 380250 | 99869216
[NAME] | 612916316 | 918777 | 396443 | 99869216
[NAME] | 607496325 | 6336399 | 398812 | 99869216
[NAME] | 613147732 | 673138 | 410666 | 99869216
[NAME] | 613043172 | 788396 | 399968 | 99869216
____________________________
Created by Morningstar Document Research.
http://documentresearch.morningstar.com/
Spreadsheet: 30ff6cea-48cb-4862-aed5-a320d18d8bd4
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SNOWSHOE | T1 | SKATE | T2 | SKI | POSITION | TOTAL TIME
3552 | 15837 | [NAME] | [NAME] | AUT | 16 | 00:16:01 | 00:00:32 | [NAME] | 00:00:49 | 00:20:04 | 1 | 00:56:47
3552 | 15669 | [NAME] | Rassinger | AUT | 18 | 00:16:25 | [NAME] | [NAME] | 00:00:49 | [NAME] | 2 | 00:58:01
Spreadsheet: 721924d1614953968-countif-with-index-match-and-or-function-test-file
Sheet: Berekeningen

 |  |  |  |  |  |  |  |  |  |  | Vroeg | Vroeg | Vroeg | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | DTI | ENg | FTR | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Vroeg |  |  |  |  |  | P1 - Schouw (Aanvoer)
Spreadsheet: 170087d1343155673-need-help-to-create-sales-register-with-automatic-update-my-data-sample1
Sheet: Sheet2

Sales register cusomer wise
 | Sum of sales amount
Sr. No | cstomer name | Total
1 | AAAAAAAAAAA | 1726
2 | BBBBBBBBBBBBBB | 7357
3 | [NAME] | 1640
4 | EEEEEEEEEEEE | 3326
5 | FFFFFFFFFFFFFFFF | 17302
6 | GGGGGGGGGG | 315
7 | HHHHHHHHHHHHHHHHHHH | 93
8 | JJJJJJJJJJJJJJJJJ | 25
9 | KKKKKKKKKKKKKKK | 4015
10 | LLLLLLLLLLLLLLL | 117
11 | MMMMMMMMMMMMMMM | 255
12 | PPPPPPPPPPP | 196
13 | QQQQQQQQQQ | 659
14 | RRRRRRRRRR | 630
15 | SSSSSSSSSS | 656
16 | TTTTTTTTTTTT | 4250
17 | UUUUUUUUUUUUU | 1903
18 | WWWWWWWWWWWW | 9366
19 | [NAME] | 937
 | Grand Total | 54768
Spreadsheet: 2e765301-ce8d-42f1-a50b-afa03ce08b36
Sheet: Page 1

Permit No.: |  |  | WQ0019569 |  |  | Facility Name: |  | [NAME] |  |  |  |  |  | County: | Chatham |  | Month: |  |  | Year:
Did conjunctive utilization occur at this facility? |  |  |  |  |  | Field Name: |  | RES FIELD |  | Field Name: |  |  |  | Field Name: |  |  |  | Field Name:
 |  |  |  |  |  | Area (acres): |  | 86 |  | Area (acres): |  |  |  | Area (acres): |  |  |  | Area (acres):
Day | Weather |  |  | Freeboard |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Storage             (if applicable) | 5-Day Upset              (if applicable) | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading
 |  | ºF | in | ft | ft | gal | min | in | in | gal | min | in | in | gal | min | in | in | gal | min | in | in
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Monthly Loading (gallons):