tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 684397d1593346763-ranking-with-zeros-and-count-error-ranking-zeros-and-rank-count-error
Sheet: Sheet1

Values | Rank |  |  | Required Result
1512
0 |  |  |  | 0
0 |  |  |  | 0
1365
1258
894
265 |  |  | TWO 12'S | No 11
0 |  |  |  | 0
83
254
855
798
1450
1257
741
0 |  |  |  | 0
0 |  |  |  | 0
265 |  |  | TWO 12'S
1157
Spreadsheet: 221606d1363623256-countif-mode-functions-not-working-the-way-i-perceive-to-why
Sheet: Sheet1

NNW | --- | ---
NE | --- | ---
ENE | --- | ---
NNE | --- | ---
NNE | --- | ---
N | --- | ---
ESE | --- | W
NNE | --- | W
N | --- | W
WSW | --- | W
WNW | --- | W
W | --- | W
W | --- | W
WNW | --- | W
W | --- | W
SW | --- | W
WNW | W | W
W | W | W
SW | W | W
W | E | W
W | NE | W
W | S | W
W | S | W
Spreadsheet: 86801d1286778461-loop-in-specific-range-and-count-nth-cell-not-including-blank-cells-example
Sheet: Sheet1

1 | 2 | 3 | 4 |  | 6 | 7 | 8 |  | 10 | 11 | 12 | 13 | 14 | 15 | 16 |  | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 |  | 30 | 31 | 32 | 33 | 34 | 35 |  | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ***
I wish to count on every 7th cells from left to right, blank cell are not included from counting. When the counting reaches number
45 at range("AS1"), its loop back to number 1 at range ("A1") to continue counting until the 7th number. All selected number
will be cut and paste at Range("A4") to Range("G4").
Eg: It can start on any number, if its start on number 3 and there are 2 blank cells in between the range, then the selection
of 7th cell is number 12 as number 3 and blank cells are not included from counting.
Spreadsheet: 552923d1513848179-extension-of-formula-21-dec-2017
Sheet: Sheet1

-0.1815255773265033
-0.1812095838068258
-0.1817675280100335
-0.1648874201731296
-0.1575969654144961
-0.1559439446249273
-0.20203079435535
-0.1886429167611037
-0.1575279533520303
-0.1515865537733742
-0.0978930384604376
-0.1261050678616666
-0.07525544055833638
-0.06227551274924422
-0.1117280195279828
-0.0683647328070608
-0.02526145801705037
0.021545335260536
0.08675507640632502
0.0210264333967775
0.06533077626467564
0.04533851544682986
0.09603235700311903
0.1050349517109787
0.1141413765745174
0.1884437878732357
0.2483064075232735
0.2462803080125054
0.2050552644562683
0.2494699623221075
0.2177562554000075
0.04921104949772302
0.1018231622332709
0.1915336612464584
0.2453982098799879
0.3363483533880949
0.3797215788418313
0.328096780606582
0.3594670604523718
0.3785130717351427
0.3390833475628748
0.416890990857561
0.3645990171538319
0.3368550893088815
0.2882239614050559
0.3669745406789297
0.4114770434773196
0.482169343225447
0.4173390081030374
0.4350179818046641
0.5733720555644249
0.5208961698334942
0.5002471300738045
0.533017277220885
0.5196302558943933
0.6310367639855671
0.562650900308762
0.5707158950968791
0.4404709161520278
0.4603081773995555
0.5234556957781494
0.4057067585432708
0.3076317446361155
0.4069400104806848
0.4189258250049129
0.3888530916538135
0.3801989250872144
0.2845035806085982
0.1889409005835664
0.2090446802686975
0.2905627833747009
0.2922132313276264
0.2554994916304576
0.2207582267513042
0.2567542582001369
0.1751446401721051
0.1521756804733583
0.06093186144477592
-0.03436537172253622
-0.04425441151157308
-0.1585569236295203
-0.09840696642972864
-0.05982973892753383
-0.128688216073363
-0.1655740081433796
-0.1936970013980761
-0.1941244003818397
-0.1315991986830629
-0.1003522624781868
-0.1012461604094373
-0.08988328710344513
-0.08699972173176992
-0.1124572924151351
-0.07641450725096902
-0.08509093500948439
-0.05089758663264705
-0.04514054010955885
-0.04174731397288216
-0.06740038813600648
-0.0922187079752368
Spreadsheet: 807224d1669810067-transfer-of-data-from-a-master-sheet-to-other-sheets-major-last
Sheet: Cash in Bank

Helper |  | Date | Description | Debit | Credit
 |  |  |  |  |  | Cash in Bank
Spreadsheet: kam_keiser__18027__ERPNewFunctions
Sheet: Sheet1

Executive Reports Publisher
New Add-In Functions
 | Change the values in blue & view the results.
User_Id: | [NAME]
Report_Cd: | 1
[NAME]: | 1
Publish_Dt: | 2002-01-29 00:00:00
 | New Functions | Results
 | [NAME],Publish_Dt)
 | =erReportCategoryCd(Report_Cd)
 | =erReportCategoryName(Report_Cd)
 | =erReportIsActive(Report_Cd)
 | =erReportName(Report_Cd)
 | =erUserCanAudit(User_Id)
 | =erUserCanAudit(User_Id)
 | =erUserCanPublish(User_Id, Report_Cd, [NAME])
 | =erUserCanView(User_Id, Report_Cd, [NAME])
 | =erUserEmail(User_Id)
 | =erUserIsActive(User_Id)
 | =erUserIsAdmin(User_Id)
 | =erUserIsNotified(User_Id, Report_Cd, [NAME])
 | =erUserIsSigner(User_Id, Report_Cd, [NAME])
 | =erUserName(User_Id)
 | New Macros for Auditing
 | erListUserIds | Create list beginning at cellpointer
 | erListReportNames | Create list beginning at cellpointer
 | erListReportCodes | Create list beginning at cellpointer
 | erListCategoryNames | Create list beginning at cellpointer
Spreadsheet: 699892d1602813653-need-help-with-adding-two-more-columns-assessment-tracker2
Sheet: 1

Teacher: |  |  |  | Student:
Course Name:
Course Code:
 |  |  |  |  |  |  |  |  |  |  | Categories Evaluated |  |  |  |  | unn
Assessment Name | Date Submitted | P/O/C | Overall Expectations | Mark | Out Of | % Grade | Level | Weight |  | Assessment Name | K | T | C | A
Summatives | Date Submitted | P/O/C | Overall Expectations | Mark | Out Of | % Grade | Level | Weight |  | Summatives | K | T | C | A
 |  |  |  |  |  |  |  |  |  | Total:
Total Products |  |  |  | 0.7 |  | Raw Mean Grade:
Total Observations |  |  |  |  |  | Weighted Mean Grade:
Total Conversations
 |  |  |  | 0.3 |  | Raw Mean Grade: |  |  |  | Overall Expectation Tracker
Level 0 |  |  |  |  |  | Weighted Mean Grade: |  |  |  | A1/1.1 |  |  | D1/4.1
Level 1 |  |  |  |  |  |  |  |  |  | A2/1.2 |  |  | D2/4.2
Level 2 |  |  |  |  |  | Final Grade: |  |  |  | A3/1.3 |  |  | D3/4.3
Level 3 |  |  |  |  |  |  |  |  |  | A4/1.4 |  |  | [NAME]
Level 4 |  |  |  |  | Grade on Report Card: |  |  |  |  | A5/1.5 |  |  | D5/4.5
 |  |  |  |  |  |  |  |  |  | A6/1.6 |  |  | D6/4.6
 |  |  |  |  |  |  |  |  |  | B1/2.1 |  |  | E1/5.1
 |  |  |  |  |  |  |  |  |  | [NAME] |  |  | E2/5.2
 |  |  |  |  |  |  |  |  |  | B3/2.3 |  |  | E3/5.3
 |  |  |  |  |  |  |  |  |  | [NAME] |  |  | E4/5.4
 |  |  |  |  |  |  |  |  |  | B5/2.5 |  |  | E5/5.5
 |  |  |  |  |  |  |  |  |  | B6/2.6 |  |  | E6/5.6
 |  |  |  |  |  |  |  |  |  | C1/3.1 |  |  | F1/6.1
 |  |  |  |  |  |  |  |  |  | C2/3.2 |  |  | F2/6.2
 |  |  |  |  |  |  |  |  |  | C3/3.3 |  |  | F3/6.3
 |  |  |  |  |  |  |  |  |  | C4/3.4 |  |  | F4/6.4
 |  |  |  |  |  |  |  |  |  | C5/3.5 |  |  | F5/6.5
 |  |  |  |  |  |  |  |  |  | C6/3.6 |  |  | F6/6.6
Spreadsheet: 874535d1721130324-sort-list-of-dates-times-wont-work-sorting-times-and-dates-v3_2
Sheet: Blad2

tijdstip |  | tijdstip2
20-02-2023 11:56:34.193
20-02-2023 11:58:59.478
20-02-2023 14:11:59.990
20-02-2023 14:11:59.990
20-02-2023 14:12:00.714
20-02-2023 14:12:00.675
20-02-2023 14:12:00.671
20-02-2023 14:12:00.671
20-02-2023 14:12:00.668
20-02-2023 14:12:00.661
20-02-2023 14:12:00.087
20-02-2023 14:12:11.964
20-02-2023 14:12:11.964
20-02-2023 14:12:19.384
20-02-2023 14:12:19.355
20-02-2023 14:12:19.355
20-02-2023 14:12:19.355
20-02-2023 14:12:20.546
20-02-2023 14:12:20.544
20-02-2023 14:12:20.502
20-02-2023 14:12:20.500
20-02-2023 14:12:20.466
20-02-2023 14:12:20.466
20-02-2023 14:12:20.466
20-02-2023 14:12:20.412
20-02-2023 14:12:20.396
20-02-2023 14:12:22.908
20-02-2023 14:12:22.905
20-02-2023 14:12:22.870
20-02-2023 14:12:22.870
20-02-2023 14:12:22.870
20-02-2023 14:12:23.014
20-02-2023 14:12:23.012
20-02-2023 14:12:25.940
20-02-2023 14:12:25.938
20-02-2023 14:12:25.938
20-02-2023 14:12:25.913
20-02-2023 14:12:25.913
20-02-2023 14:12:25.910
20-02-2023 14:12:25.877
20-02-2023 14:12:25.877
20-02-2023 14:12:25.877
20-02-2023 14:13:00.211
19-09-2023 09:56:38.202
19-09-2023 09:56:38.065
19-09-2023 09:56:38.065
19-09-2023 09:56:39.187
19-09-2023 09:56:39.183
19-09-2023 09:56:39.182
19-09-2023 09:56:39.160
19-09-2023 09:56:39.160
19-09-2023 09:56:39.100
19-09-2023 09:56:39.097
19-09-2023 09:56:39.097
19-09-2023 09:57:17.122
19-09-2023 09:57:17.100
19-09-2023 09:57:17.100
19-09-2023 09:57:17.100
19-09-2023 09:57:18.153
19-09-2023 09:57:18.140
22-09-2023 09:50:26.241
22-09-2023 09:50:26.116
22-09-2023 09:50:26.116
22-09-2023 09:50:27.105
22-09-2023 09:50:27.100
22-09-2023 09:50:27.099
22-09-2023 09:50:27.084
22-09-2023 09:50:27.082
22-09-2023 09:50:27.019
22-09-2023 09:50:27.017
22-09-2023 09:50:27.017
22-09-2023 10:39:17.101
22-09-2023 10:47:03.157
25-09-2023 17:31:03.177
25-09-2023 17:31:34.926
25-09-2023 17:55:08.623
26-09-2023 11:01:24.184
26-09-2023 11:02:00.758
26-09-2023 11:06:44.532
27-09-2023 15:34:42.888
27-09-2023 15:34:56.638
27-09-2023 15:38:24.786
27-09-2023 15:38:42.447
27-09-2023 15:39:44.949
27-09-2023 15:40:43.185
27-09-2023 15:42:45.059
27-09-2023 15:43:00.143
27-09-2023 15:43:00.127
27-09-2023 15:43:18.289
27-09-2023 15:43:29.197
27-06-2024 09:35:35.355
12-31-2018 10:19:00.000
12-31-2018 10:19:00.000
12-31-2018 10:19:00.000
12-31-2018 10:19:00.000
12-31-2018 10:19:00.000
12-31-2018 10:19:00.000
12-30-2021 09:52:31.747
12-30-2021 09:52:31.747
Spreadsheet: 740641d1626434251-using-multiple-if-functions-with-vlookup-2023-cohort
Sheet: Cohort

Teacher |  |  | Date |  |  |  | Date |  |  |  | Date |  |  |  | Date |  |  |  | Date |  |  |  | Date |  |  |  | Date |  |  |  | Date
 |  |  | Type (L/S/R/W) | L |  |  | Type (L/S/R/W) |  |  |  | Type (L/S/R/W) |  |  |  | Type (L/S/R/W) |  |  |  | Type (L/S/R/W) |  |  |  | Type (L/S/R/W) |  |  |  | Type (L/S/R/W) |  |  |  | Type (L/S/R/W)
 |  |  | Title |  |  |  | Title |  |  |  | Title |  |  |  | Title |  |  |  | Title |  |  |  | Title |  |  |  | Title |  |  |  | Title
Name |  | TIER | Out of | 20 | % | Grade | Out of |  | % | Grade | Out of |  | % | Grade | Out of |  | % | Grade | Out of |  | % | Grade | Out of |  | % | Grade | Out of |  | % | Grade | Out of |  | % | Grade
student name | W | F |  | 9
student name | W
student name | X
student name | W
student name | X
student name | W
student name | X
student name | W
student name | W
student name | X
student name | X
student name | W
student name | W
student name | X
student name | W
student name | W
student name | X
student name | X
student name | X
student name | W
student name | W
student name | X
student name | X
student name | X
student name | X
student name | X
student name | W
student name | X
student name | X
student name | W
student name | X
Spreadsheet: 1e6cce0b-2348-4966-bb3f-8a6a81c01091
Sheet: Mountains

Mountain | Location | Height (m) | Default Value | Percent | Percen- tile | Bar only | Two column bar chart
Aconcagua | Argentina | 6959.8032
Annapurna I | Nepal | 8078.4192
Ararat | Turkey | 5121.8592
Citlaltepetl | Mexico | 5699.76
[NAME] | New Zealand | 3763.9752
Everest | Nepal-China | 8847.7344
Grand Teton | Wyoming, U.S. | 4195.8768
Huascaran | Peru | 6768.084
Jaja | New Guinea | 5029.2
[NAME] | Morocco | 4163.8728
K2 | Kashmir | 8610.6
Kanchenjunga | India-Nepal | 8597.7984
Kilimanjaro | Tanzania | 5894.832
Kinabalu | Malaysia | 4101.084
Logan | Yukon, Canada | 6050.28
McKinley | Alaska, U.S. | 6193.536
Mont Blanc | France-Italy | 4807.0008
[NAME] | Italy-Switzerland | 4633.8744
[NAME] | Argentina-Chile | 6879.9456
[NAME] | Ethiopia | 4260.1584
[NAME] | Bolivia | 6519.9768
Vinson Massif | Antarctica | 5140.1472
Spreadsheet: diana_scholtes__8581__Transmission Ancillary
Sheet: Sheet1

[NAME] TRENDS
Please note that Volume Management will add these charges on the back end.  This information is just FYI to help you calculate the "true" cost of transmission
and does not necessarily reflect the exact charge that will be made.
These calculations are subject to change at any time |  |  |  |  |  | **NOTE: this is an estimated range
 |  |  |  |  |  | based on PAST bilings
 | Scheduling fees | Reactive Supply and Voltage | System Control and Dispatch fees | Line Losses | Notes: | Estimated Range
APS
LLH | 0.32 | No charge until Commission has  allowed developed rate to be implemented |  | 2.5% of each MW reserved (paid back physically) |  | 0.32
HLH | 0.58 |  |  |  |  | 0.58
IDAHO |  |  |  | *thru Sept '01*
LLH |  |  |  | 3.6% x  (Palo Verde index price + $2) | June '01 to Sept '01, IPC will be fully loaded coming from the west, so they will be wheeling to Palo Verde. | $ 1.62 - 12.00
HLH |  |  |  | 3.6% x  (Palo Verde index price + $2) | The + $2  is the average cost to IPC to wheel from their system to PV | $ 1.62 - 12.01
NPC
LLH | 0.10337 | 0.12019 |  | 3.543835 x (MW's reserved x 0.0132) |  | $ 0.28 - 2.65
HLH | 0.10337 | 0.12019 |  | 3.543835 x (MW's reserved x 0.0132) |  | $ 0.28 - 2.66
PAC
LLH |  |  |  | Range between $3 - $12 / MWh | Based on the average of the DJ index prices at Mic_C, 4 Corners, Palo Verde, and COB for | $ 3.00 - 16.00
HLH |  |  |  | Range between $3 - $12 / MWh | each hour of each day x # MW's reserved x .45 | $ 3.00 - 16.01
PUGET SOUND
LLH |  | 0.009 | 8.89 per transaction (reservation) includes scheduling fees | none known at this time |  | $ 0.50 - 8.89
HLH |  | 0.015 | 8.89 per transaction (reservation) includes scheduling fees |  |  | $ 0.50 - 8.89
SALT RIVER PROJECT
LLH |  |  | 2.3% of Dow Jones PV firm energy index |  |  | $ 2.86 - 8.36
HLH |  |  | 2.3% of Dow Jones PV firm energy index |  |  | $ 2.86 - 8.37
SIERRA PACIFIC
LLH | 0.1649 x # MW's reserved |  | 9.1692 x (0.45 x # MW's reserved) x 0.0234 | 0.0234 x (# MW's wheeled) x Avg energy cost for the month as determined by transmission provider |  | $ 1.21 - 6.46
HLH | 0.1649 x # MW's reserved |  | 9.1692 x (0.45 x # MW's reserved) x 0.0235 | 0.0234 x (# MW's wheeled) x Avg energy cost for the month as determined by transmission provider |  | $ 1.21 - 6.47
TUCSON
LLH | $ 0.06 - 0.12 | $ 0.22 - 0.46 |  |  |  | $ 0.28 - 0.58
HLH | $ 0.06 - 0.12 | $ 0.22 - 0.46 |  |  |  | $ 0.28 - 0.59
WAPA CRSP
LLH |  |  |  | 5.5% of  total $ amount of wheeled transmission | Losses for all pre-scheduled transactions shall be submitted using ONE E-tag for losses for all aggregated losses for the pre-scheduled day | $ 0.25 - 9.16
HLH |  |  |  | 5.5% of  total $ amount of wheeled transmission | WAPA will calculate losses for all Real-time transactions and submit an aggregated loss schedule one week in arrears | $ 0.25 - 9.16
Spreadsheet: 165564d1341267802-statements-produced-from-a-list-of-invoices-example-setmoa-
Sheet: Sheet1

INFORMATION |  |  |  |  | DESIRED RESULT
Customer | Invoice Date | Invoice Number | Invoice Amount |  | Customer: | A
A | 2002-08-01 00:00:00 | 10 | 10.5
B | 2010-09-05 00:00:00 | 102 | 20.4 |  | Invoice Date | Invoice Number | Invoice Amount
C | 2011-12-06 00:00:00 | 124 | 104.12 |  | 2002-08-01 00:00:00 | 10 | 10.5
D | 2009-08-07 00:00:00 | 125 | 50.78 |  | 2010-08-22 00:00:00 | 154 | 15
E | 2001-04-06 00:00:00 | 128 | 20.8 |  | 2012-04-14 00:00:00 | 134 | 3
F | 2011-03-31 00:00:00 | 134 | 10 |  | 2011-11-15 00:00:00 | 144 | 200
A | 2010-08-22 00:00:00 | 154 | 15
E | 2008-01-01 00:00:00 | 178 | 10
B | 2011-06-14 00:00:00 | 165 | 20
B | 2011-05-06 00:00:00 | 143 | 100
C | 2010-12-29 00:00:00 | 198 | 220
C | 2009-07-31 00:00:00 | 164 | 500
A | 2012-04-14 00:00:00 | 134 | 3
D | 2008-02-27 00:00:00 | 157 | 60
E | 2010-09-16 00:00:00 | 111 | 90 |  | Rijlabels | Som van Invoice Amount
E | 2011-05-03 00:00:00 | 168 | 45 |  | A | 228.5
F | 2011-07-02 00:00:00 | 197 | 45.2 |  | 2002-08-01 00:00:00 | 10.5
F | 2010-10-11 00:00:00 | 135 | 60 |  | 2010-08-22 00:00:00 | 15
A | 2011-11-15 00:00:00 | 144 | 200 |  | 2011-11-15 00:00:00 | 200
 |  |  |  |  | 2012-04-14 00:00:00 | 3
 |  |  |  |  | B | 140.4
 |  |  |  |  | 2010-09-05 00:00:00 | 20.4
 |  |  |  |  | 2011-05-06 00:00:00 | 100
 |  |  |  |  | 2011-06-14 00:00:00 | 20
 |  |  |  |  | C | 824.12
 |  |  |  |  | 2009-07-31 00:00:00 | 500
 |  |  |  |  | 2010-12-29 00:00:00 | 220
 |  |  |  |  | 2011-12-06 00:00:00 | 104.12
 |  |  |  |  | D | 110.78
 |  |  |  |  | 2008-02-27 00:00:00 | 60
 |  |  |  |  | 2009-08-07 00:00:00 | 50.78
 |  |  |  |  | E | 165.8
 |  |  |  |  | 2001-04-06 00:00:00 | 20.8
 |  |  |  |  | 2008-01-01 00:00:00 | 10
 |  |  |  |  | 2010-09-16 00:00:00 | 90
 |  |  |  |  | 2011-05-03 00:00:00 | 45
 |  |  |  |  | F | 115.2
 |  |  |  |  | 2010-10-11 00:00:00 | 60
 |  |  |  |  | 2011-03-31 00:00:00 | 10
 |  |  |  |  | 2011-07-02 00:00:00 | 45.2
 |  |  |  |  | Eindtotaal | 1584.8
Spreadsheet: larry_campbell__21450__TSC Calculator 2000 12
Sheet: Calculator

 |  |  |  | Volume | 50
Generator | NYISO_LBMP_REFERENCE
Bus_Name | PJM_LOAD_KEYSTONE
Data | TO_Name | TO_TSC_Rate_$/Mwhr | Total | Rate | Volume
Sum of TSC_Cost_$/Mwhr | CONSOLIDATED EDISON | 6.97 | 2.8556
 | NEW YORK STATE ELECTRIC AND GAS | 6.2604 | 0
 | NIAGARA MOHAWK | 1.891 | 0.3757
 | NYPA | 1.78 | 0.3403
Sum of Resultant_Dfax | CONSOLIDATED EDISON | 6.97 | -0.4923
 | NEW YORK STATE ELECTRIC AND GAS | 6.2604 | -0.232
 | NIAGARA MOHAWK | 1.891 | -0.0844
 | NYPA | 1.78 | -0.1913
Total Sum of TSC_Cost_$/Mwhr |  |  | 3.5716
Total Sum of Resultant_Dfax |  |  | -1
Spreadsheet: 218112d1362352342-top-10-report-based-on-totals-of-sales-from-a-list-rank-top-ten-sales-report1
Sheet: Report

 | Top 10 Sales
 | Select Year | 2012
Rank | Customer name | Sales | Qty
1 | xxxxx | 100000 | 100
2 | yyyyy | 75000 | 90
3 | zzzzz | 50000 | 80
4 | [NAME] | 40000 | 70
5 | aaaaa | 30000 | 60
6 | ssssss | 25000 | 50
7 | ddddd | 20000 | 40
8 | [NAME] | 17500 | 30
9 | ggggg | 15000 | 20
10 | hhhhh | 12000 | 10
Spreadsheet: c3e06163-b364-4bb2-a3cf-676b14761f91
Sheet: Sheet1

2008-09-09 00:00:00 | DEMOCRATIC | Unnamed: 2 | Unnamed: 3
 | EXECUTIVE COUNCIL - DISTRICT 1
 | Cauble, d | Burton, r | [NAME]
Albany | 36
[NAME] | 29 | 2
Alton | 91 | 1
Ashland | 45
Atkinson & Gilmanton Academy Grant | --- | ---
[NAME] | 87 | 1
Bath | 4 | 7
Bean's Grant | --- | ---
Bean's Purchase | --- | ---
Belmont | 81 | 3
[NAME] | 7 | 2
[NAME] | 78 | 7
[NAME] | 81 | 7
[NAME] 3 | 114 | 4
[NAME] 4 | 62 | 4
Bethlehem | 77 | 7
Bridgewater | 33 |  | 1
Bristol | 59 | 1
Cambridge | --- | ---
Campton | 76 | 6
Canaan | 65 | 1
Carroll | 24 | 2
Center Harbor | 12
[NAME]'s Purchase | --- | ---
Charlestown | 114 | 1
Chatham | 9
Claremont Ward 1 | 53 | 2
Claremont Ward 2 | 114
Claremont Ward 3 | 70 | 1
[NAME] | 4 | 4
Colebrook | 55 | 9
Columbia | 11 | 4
Conway | 211 | 5 | 1
Cornish | 90 | 4
Crawford's Purchase | --- | ---
Croydon | 16
Cutt's Grant | --- | ---
[NAME] | 9 | 3
Dix's Grant | --- | ---
Dixville | 5 | 1
Dorchester | 7
Dummer | 2 | 1
Easton | 12 | 6 | 1
Eaton | 21
[NAME] | 69 | 4 | 1
Ellsworth | 5
Enfield | 68 | 2
Errol | 10 | 3
Erving's Location | --- | ---
Franconia | 68 | 10 | 1
Freedom | 71
Gilford | 153 | 8
[NAME] | 84 | 6
[NAME] | 40 |  | 1
Grantham | 127 | 3
Green's Grant | --- | ---
Hadley's Purchase | --- | ---
[NAME] | 16
Hale's Location | 3
Hanover | 343
Hart's Location | 7
Haverhill | 35 | 19
Hebron | 29
Holderness | 87 | 7
[NAME] | 61 | 1
[NAME] | 23 | 6
Kilkenny | --- | ---
[NAME] | 58 |  | 2
[NAME] | 74 | 3
[NAME] 3 | 59 | 9
[NAME] | 44
[NAME] | 43
[NAME] 6 | 54
Lancaster | 72 | 18 | 1
Landaff | 12 | 5
Lebanon Ward 1 | 126 | 1
Lebanon Ward 2 | 119 | 3 | 1
Lebanon Ward 3 | 147
Lincoln | 38 | 1
Lisbon | 12 | 1
Littleton | 97 | 7 | 1
Livermore | --- | ---
Low & Burbank's Grant | --- | ---
[NAME] | 12 | 4
Lyme | 84 | 1
[NAME] | 85 | 1
Martin's Location | --- | ---
Meredith | 134 | 1 | 2
Milan | 28 | 4
[NAME] | 4
Monroe | 8 | 2
Moultonborough | 91 | 3
New Hampton | 52 | 2
Newport | 79 | 3 | 2
Northumberland | 83 | 12
[NAME] | --- | ---
Orange | 14 | 1
Orford | 43 | 2
Ossipee | 116 | 1
Piermont | 12 | 4
[NAME]'s Grant | --- | ---
Pittsburg | 20 | 0
Plainfield | 173 | 1
Plymouth | 127 | 1
Randolph | 26 | 1
Rumney | 55 | 1
Sanbornton | 123 | 4
Sandwich | 113
Sargent's Purchase | --- | ---
Second College Grant | --- | ---
Shelburne | 7 | 1
Springfield | 37 | 1
[NAME] | 12 | 7
Stewartstown | 16
[NAME] | 17 | 1
Success | --- | ---
[NAME] | 24 | 3
Sunapee | 117 | 2
Tamworth | 133 | 1
Thompson & Meserve's Purchase | --- | ---
[NAME] | 48 | 2
[NAME] | 116 | 8 | 2
Tuftonboro | 89
Wakefield | 125 | 1
[NAME] | 20 | 10 | 1
Waterville Valley | 26
Wentworth | 14
Wentworth's Location | 3
[NAME] | 38 | 10
Wolfeboro | 254 | 5
Woodstock | 24 | 2
Totals | 6720 | 316 | 18
Spreadsheet: 791918d1660659383-optomize-raw-material-pallet-beta_modded-hydr-
Sheet: Excel Solver_result

 |  | T | W | L | Demand?
 |  | 16 | 75 | 845 | 16
 |  | 16 | 75 | 945 | 36
 |  | 16 | 75 | 1000 | 36
 |  | 16 | 75 | 1140 | 12
 |  | 16 | 75 | 1200 | 35
 |  | 16 | 75 | 2400 | 4
 |  | Stock L | 4800
 |  |  |  |  |  |  |  |  |  |  | waste | Bars | Tot waste
 |  |  |  |  | 2400 | 1200 | 1140 | 1000 | 945 | 845 | pr bar | used | from bars
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  | Total
 |  |  |  | Demand | 4 | 35 | 12 | 36 | 36 | 16
 |  |  | Excess production
 |  |  | Total excess = Tot waste + Excess production
Spreadsheet: 41057d1239523856-lookup-formula-not-returning-correct-answer-boston
Sheet: Overview

East | W | L | PCT | vs E | vs C | vs W | INT | HOME | ROAD | Total
Boston | 2 | 3 | 0.4 | 1-2 | 0-0 | 1-1 | 0-0 | 1-2 | 1-1 | 2-3
 |  |  |  |  | Home | Road | Total | PCT
 |  |  | Boston vs. | Florida | 15 | No | No | No
 |  |  |  |  | 1 |  |  | CELL I6 is trying to divide 0/0
 |  |  |  |  | Cell F4 USING "Vlookup" with your data sheet works
 |  |  |  |  | However column A must be in order
Spreadsheet: 192930d1352634236-automatically-insert-a-blank-row-forum-sample
Sheet: Sheet1

Customer | Reference Number | Total
Print City, LLC | KS101707 | 10182
Print City, LLC | KS101705 | 12282
Print City, LLC | KS101708 | 12374
Print City, LLC | KS101711 | 13129
Print City, LLC | KS101704 | 14094
Print City, LLC | KS101709 | 19741
Print City, LLC | KS101703 | 19811
Print City, LLC | KS101712 | 25568
Print City, LLC | KS101710 | 66021
Print City, LLC | KS101706 | 66621
Print City, LLC | KS101805 | 2051
Print City, LLC | KS101804 | 2854
Print City, LLC | DB101009 | 3355
Print City, LLC | KS101803 | 11402
 |  |  | <<<  Can these blank row be inserted automatically
ABC, Inc. | ED100413 | 231 | based on the data changing in column A?
ABC, Inc. | AH101005 | 1137.5
ABC, Inc. | AH101006 | 2429.49
Microsoft | KS101519 | 556
Microsoft | KS101510 | 1614
Microsoft | KS101511 | 2071
Widgets, Co. | KS101502 | 1285
Widgets, Co. | KS101501 | 6976
Academy of Design | AH101522 | 362.6
Academy of Design | AH101603 | 433.37
Academy of Design | AH101605 | 549.51
Academy of Design | AH101604 | 711.95
Academy of Design | AH101521 | 1746.02
Electronic Network | KS103016 | 8633
Society of Higher Learning | AH101004 | 1238.954
Society of Higher Learning | AH101003 | 3005.16
Spreadsheet: 866173d1713147187-in-spec-out-of-spec-formula-blank-grade-form
Sheet: Customer trending

 | Customer | Burns
 | Good | Satisfactory | Unacceptable | Good (%) | Satisfactory (%) | Unacceptable (%)
2021
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec