tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 83e7153a-031e-4ccb-aadf-dc751253ca38
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 |  |  |  |  |  |  |  |  | [NAME] | 住宅の所有の関係(2区分)，居住室数(10区分)別住宅数―全国
 |  |  |  |  |  |  |  |  | Table 1. | Dwellings by Tenure of Dwelling (2 Groups) and Dwelling Rooms (10 Groups) - Japan
 |  |  |  |  |  |  | 住宅の所有の関係(2区分) |  |  | 総　数 | 居住室数　　　　　　　　　　　　　　　　Dwelling rooms |  |  |  |  |  |  |  |  |  | １住宅当たり 居住室数
 |  |  |  |  |  |  |  |  |  |  | １室 | ２ | ３ | ４ | ５ | ６ | ７ | ８ | ９ | 10室以上
 |  |  |  |  |  |  | Tenure of dwelling (2 Groups)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dwelling rooms  per dwelling
 |  |  |  |  |  |  |  |  |  | Total |  |  |  |  |  |  |  |  |  | and over
 |  |  |  |  |  |  |  |  |  | 1)
 |  |  |  |  |  |  | 全         　　　       国 | Japan
5 | 0 |  |  |  | 1 |  | 住　　　宅　　　総　　　数 | Dwellings | 2) | 49598300 | 4124600 | 3671200 | 7197700 | 9731800 | 8230300 | 6168000 | 3729300 | 2368000 | 1169500 | 1695500 | 4.67
5 | 0 |  |  |  | 2 |  | 持　　　　 ち　　　　 家 | 3-A |  | 30316100 | 83900 | 421200 | 1788400 | 5735000 | 7577000 | 5915400 | 3637700 | 2326200 | 1153800 | 1677500 | 5.8
5 | 0 |  |  |  | 3 |  | 借　　　　　　　　　　家 | 3-B |  | 17770000 | 4040800 | 3250000 | 5409300 | 3996800 | 653300 | 252500 | 91600 | 41800 | 15700 | 18000 | 2.75
 |  |  |  |  |  |  | 1)  居住室数 ｢不詳｣ を含む。 |  |  | 1)  Including ｄwelling ｒooms "Not reported".
 |  |  |  |  |  |  | 2)  住宅の所有の関係 ｢不詳｣ を含む。 |  |  | 2)  Including tenure of dwelling "Not reported".
Spreadsheet: 596004d1540906254-if-and-using-vlookup-from-another-tab-using-table-but-if-over-roundup-to-next-cell-med-gas-branch-pipe-sizing-test-autosaved-
Sheet: Medical Air 

MEDICAL AIR LINE SIZING (25 LPM PER OUTLET) |  |  |  |  |  |  |  |  | MEDICAL AIR PRESSURE DROP
START | END | RUN (FEET) | FLOW (LPM) | PIPE SIZE | LOSS PER 100' | LOSS | RUNNING SUB TOTAL
 |  |  |  |  |  |  |  |  | FLOW |  | NOMINAL PIPE SIZE
A | B | 25 | 75 | 1/2" |  |  |  |  | LPM | SCFM | 1/2" | 3/4" | 1" | 1-1/4" | 1-1/2" | 2" | 2-1/2" | 3" | 4"
B | C | 16 | 150 | 1/2" |  |  |  |  |  | 425
C | D | 17 | 225 | 1/2"
D | E | 19 | 300 | 1/2"
E | F | 16 | 375 | 3/4" |  |  |  |  | System Totals
F | G | 16 | 450 | 3/4" |  |  |  |  | [NAME] | LPM Per Section |  | Pressure [NAME] (PSIG/100 FT) |  |  |  | Equivalent (LF) |  | Pressure Drop
G | H | 16 | 525 | 3/4" |  |  |  |  | 4"
H | I | 16 | 600 | 3/4" |  |  |  |  | 3" | 11500 |  |  |  |  |  | 35
I | J | 16 | 675 | 3/4" |  |  |  |  | 2 1/2"
J | K | 10 | 750 | 3/4" |  |  |  |  | 2" | 6675 |  |  |  |  |  | 46
K | L | 138 | 1500 | 1 1/4" |  |  |  |  | 1 1/2" | 2400 |  |  |  |  |  | 24
L | M | 15 | 2400 | 1 1/2" |  |  |  |  | 1 1/4" | 1500 |  |  |  |  |  | 173
M | N | 15 | 4275 | 2" |  |  |  |  | 1"
N | O | 15 | 6675 | 2" |  |  |  |  | 3/4" | 751 |  |  |  |  |  | 113
O | P | 15 | 9075 | 3" |  |  |  |  | 1/2" | 300 |  |  |  |  |  | 97
P | Q | 25 | 12980 | 3" |  |  |  |  | Total Maximum System Loss Per 100' = |  |  |  |  |  | System Total Pressure Drop
 |  |  |  |  |  |  |  |  | Place your flow rate for the overall zone of pipe you are sizing up top, then place the flow rate for the section you are sizing and the length of that section in the middle. |  |  |  |  |  | LENGTH OF LONGEST RUN |  |  |  | LF
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ADD FOR FITTING  LOSS |  |  |  | LF
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL EQUIVALENT LENGTH |  |  |  | LF
Spreadsheet: 467566d1466767506-index-march-a-specific-part-of-table-example
Sheet: Sheet1

 |  | Rank | Cost |  |  |  | Inventory
 | Sword TIER 1 | 1 | 5 |  |  |  | Rank
 |  | 2 | 10 |  |  | Sword rank 1 | 1
 | Sword TIER 2 | 1 | 25 |  |  | Bow tier 2 | 2
 |  | 2 | 50 |  |  |  | TOAL COST
 | Bow TIER 1 | 1 | 50
 |  | 2 | 75
 | Bow TIER 2 | 1 | 50
 |  | 2 | 75
Spreadsheet: 871566d1718017200-comparing-two-lists-in-differing-order-sample-list
Sheet: Sheet1

 | Data ref #1 | Data ref list #2 | Required Result
 | 20.1 | 20.1 | Match
 | 22 | 12 | Error | Error
 | 40 | 8 | Error | Error
 | 40.1 | 9 | Match | Match
 | 9 | 40 | Match | Match
Spreadsheet: joe_parks__14878__TXULSP Avail Cap Elec Gen
Sheet: available capacity

 |  |  | Today's Date:
 | Lone Star Pipeline
Estimated Available Capacity on the TXU Lone Star Pipeline system
Gas Day runs from 9:00 a.m. to 9:00 a.m.
All volumes are expressed in [NAME]/d
The data below is TXU Lone Star Pipeline's best estimate of available capacity based on current operational data.  The available capacity listed
at the various [NAME])  is subject to the nomination process and the operational conditions existing at the time a nomination is confirmed.
The volumes listed below do not represent individual point capacity availability.   All transportation service will be performed subject to the terms
and conditions of your Transportation Agreement.
Please contact TXU Lone Star Pipeline's Transportation Administration Department before scheduling any imbalance makeup.  When
nominating imbalance makeup, please indicate what portion of your nomination is intended as imbalance makeup.  For more information, please
contact your TXU Lone Star Pipeline Transportation Administrator.
Please visit our web site at www.txulsp.com for nomination information and for a list of Major Interconnect Points on our system.
 | Receipt Area Capacity
 | Gas Day | Gas Day
 | 2002-03-07 00:00:00
From the Waha Area | 150000
East of Waha to | 100000
to the Maryneal Compressor
East of Maryneal Compressor | 50000
[NAME] | 100000
(Waller and Ft. Bend Counties)
Line V (30") | 50000
(Ennis to [NAME])
Lines L8A | 0
(Limestone and Freestone Cty)
Line P | 15000
([NAME] Area - for local consumption only)
[NAME] and O (East Texas) | 25,000*
 | * Carthage Plant OK for 25,000
Spreadsheet: 145908d1331811053-summing-multiple-sheets-indirect-formula-sum-multiple-sheets
Sheet: 2

 |  |  |  |  | Total M2 by Product |  |  |  |  |  |  |  |  |  |  |  | Total Sales by Product
 |  | Product 1 | Extra 1 |  | 4 | 9 | 3 | 10 | 10 | 9 | 9 | 2 | 3 | 9 | 68 |  | 30 | 71 | 96 | 16 | 68 | 85 | 51 | 59 | 21 | 30 | 527
 |  | Product 2 | Extra 2 |  | 6 | 7 | 6 | 6 | 4 | 2 | 5 | 8 | 4 | 2 | 50 |  | 56 | 30 | 70 | 38 | 87 | 89 | 70 | 80 | 51 | 11 | 582
 |  | Product 3 | Extra 3 |  | 10 | 4 | 7 | 5 | 5 | 4 | 2 | 9 | 2 | 9 | 57 |  | 57 | 86 | 81 | 94 | 52 | 68 | 51 | 26 | 20 | 90 | 625
 |  | Product 4 | Extra 4 |  | 3 | 2 | 10 | 2 | 8 | 7 | 5 | 2 | 8 | 1 | 48 |  | 77 | 14 | 13 | 65 | 44 | 42 | 94 | 35 | 96 | 41 | 521
 |  | Product 5 | Extra 5 |  | 4 | 1 | 7 | 6 | 6 | 8 | 3 | 7 | 1 | 3 | 46 |  | 16 | 49 | 39 | 30 | 59 | 16 | 13 | 22 | 31 | 52 | 327
 |  | Product 6 | Extra 6 |  | 8 | 5 | 9 | 7 | 7 | 6 | 9 | 9 | 6 | 6 | 72 |  | 57 | 16 | 46 | 74 | 23 | 34 | 24 | 51 | 26 | 28 | 379
 |  | Product 7 | Extra 7 |  | 6 | 2 | 5 | 9 | 2 | 9 | 5 | 7 | 10 | 8 | 63 |  | 62 | 94 | 59 | 53 | 71 | 63 | 78 | 63 | 19 | 65 | 627
 |  | Product 8 | Extra 8 |  | 10 | 9 | 4 | 3 | 1 | 1 | 10 | 5 | 6 | 9 | 58 |  | 80 | 14 | 11 | 36 | 95 | 40 | 82 | 39 | 56 | 28 | 481
 |  | Product 9 | Extra 9 |  | 1 | 10 | 2 | 7 | 5 | 3 | 9 | 1 | 2 | 2 | 42 |  | 34 | 38 | 69 | 38 | 17 | 75 | 23 | 46 | 38 | 28 | 406
 |  | Product 10 | Extra 10 |  | 4 | 4 | 3 | 2 | 8 | 9 | 10 | 9 | 5 | 2 | 56 |  | 18 | 69 | 42 | 13 | 93 | 37 | 76 | 55 | 27 | 79 | 509
 |  | Product 11 | Extra 11 |  | 3 | 10 | 4 | 6 | 7 | 6 | 4 | 8 | 4 | 8 | 60 |  | 67 | 79 | 24 | 75 | 12 | 38 | 41 | 12 | 73 | 23 | 444
 |  | Product 12 | Extra 12 |  | 10 | 1 | 5 | 4 | 2 | 5 | 2 | 1 | 4 | 3 | 37 |  | 11 | 64 | 96 | 68 | 41 | 52 | 62 | 52 | 62 | 10 | 518
 |  | Product 13 | Extra 13 |  | 1 | 3 | 10 | 8 | 8 | 7 | 10 | 7 | 7 | 2 | 63 |  | 16 | 10 | 61 | 80 | 86 | 66 | 19 | 33 | 20 | 90 | 481
 |  | Product 14 | Extra 14 |  | 1 | 1 | 6 | 9 | 4 | 3 | 5 | 5 | 2 | 4 | 40 |  | 26 | 84 | 91 | 90 | 38 | 62 | 75 | 70 | 59 | 64 | 659
 |  | Product 15 | Extra 15 |  | 10 | 10 | 3 | 1 | 10 | 10 | 6 | 7 | 8 | 7 | 72 |  | 34 | 48 | 80 | 19 | 91 | 67 | 92 | 29 | 52 | 79 | 591
 |  | Product 16 | Extra 16 |  | 9 | 1 | 10 | 4 | 2 | 1 | 3 | 6 | 7 | 2 | 45 |  | 75 | 18 | 50 | 99 | 19 | 52 | 62 | 32 | 46 | 86 | 539
 |  |  |  |  | 90 | 79 | 94 | 89 | 89 | 90 | 97 | 93 | 79 | 77 | 877 |  | 716 | 784 | 928 | 888 | 896 | 886 | 913 | 704 | 697 | 804 | 8216
Spreadsheet: 786029d1656940738-excel-function-use-to-extract-between-range-data-without-array-formula-04072022-sample-file-for-excel-forum
Sheet: Sheet1

Bth | Bthno | From no. | To No. |  |  | RESULT
GK | 1 | 1 | 1000 |  |  | Nos. | Bth | [NAME] | [NAME] Used
 | 2 |  |  |  |  | 15712 | JG | 3
 | 3 |  |  |  |  | 1 | GK | 1
 | 4 |  |  |  |  | 8901 | GK | 9
 | 5 |  |  |  |  | 7484 | GK | 8
 | 6 |  |  |  |  | 23948 | BH | 2
 | 7 |  |  |  |  | 21910 | BR | 1
 | 8 |  |  |  |  | 13213 | JG | 1
 | 9 |  |  |  |  | 13212 | GK | 13
 | 10
 | 11
 | 12
 | 13 |  | 13212
JG | 1 | 13213 | 14212
 | 2
 | 3
 | 4
 | 5
 | 6 |  | 19525
BY | 1 | 19526 | 20582
BR | 1 | 20583 | 21910
BH | 1 | 21911 | 22910
 | 2
 | 3
 | 4
 | 5 |  | 27472
GT | 1 | 27473 | 28472
 | 2 |  | 29487
TH | 1 | 29488 | 30487
 | 2 |  | 31445
VS | 1 | 31446 | 32445
 | 2
 | 3
 | 4
 | 5 |  | 36599
PNV | 1 | 36600 | 37305
PN | 1 | 37306 | 37617
PCN | 1 | 37618 | 38617
 | 2 |  | 39960
WA | 1 | 39961 | 41498
MD | 1 | 41499 | 42498
 | 2
 | 3 |  | 44425
ST | 1 | 44426 | 45337
SH | 1 | 45338 | 45592
KD | 1 | 45593 | 46676
Spreadsheet: 159516d1338726309-need-text-to-appear-when-conditions-met-my-excel-headache
Sheet: Sheet1

Post name | Employee# | User Name | Duty On | Duty Off | Duty Time | Duty On (rounded) | Duty Off (rounded) | Duty Time (rounded) | comments
1300~10020~EA-G11 |  |  | 6/1/2012 11:01:41 AM | 6/1/2012 2:18:07 PM | 3:16 | 6/1/2012 11:00:00 AM | 6/1/2012 2:15:00 PM | 3:15 |  | Cells B-F are not important for final report. Cell A-J need to alternate color based on Post listed in cell [NAME] for G is: =$h2<$g3. I need that to result in cell J comment "change"
1300~10020~EA-G11 |  |  | 6/1/2012 2:32:11 PM | 6/1/2012 2:32:56 PM | 0:01 | 6/1/2012 2:30:00 PM | 6/1/2012 2:30:00 PM | 0:00 | Change
1300~10020~EA-G11 |  |  | 6/1/2012 2:35:38 PM | 6/1/2012 7:08:40 PM | 4:33 | 6/1/2012 2:30:00 PM | 6/1/2012 7:15:00 PM | 4:45
1300~10020~EA-G13 |  |  | 6/1/2012 6:07:46 AM | 6/1/2012 7:28:40 AM | 1:21 | 6/1/2012 6:15:00 AM | 6/1/2012 7:30:00 AM | 1:15
Spreadsheet: 791417d1660328551-vlookup-across-multiple-sheets-and-add-results-sample-finance
Sheet: Feb

Monthly Financial Report
Deposits | Source |  | Expense | Vendor |  | Allocated Funds | Reason |  | Previous Month Bal | Current Bal | Allocated Bal | Available Bal |  | Deposits
5000 | Income |  | 250 | Fuel |  |  |  |  |  |  |  |  |  | Payments
 |  |  | 300 | Cell |  |  |  |  |  |  |  |  |  | Previous Allocated
 |  |  | 200 | Cable |  |  |  |  |  |  |  |  |  | Newly Allocated
Spreadsheet: 32339d1228441007-how-to-choose-the-highest-5-numbers-from-4-different-worksheets-4accendo
Sheet: DC #2

 | Name | Height (CM) | Intelligence | Strength | Speed | Agility | Fighting Skills
 | Superman | 191 | 7 | 50 | 19 | 21 | 87
 | Hawkman | 186 | 4 | 30 | 8 | 17 | 77
 | Hawkgirl | 167 | 3 | 27 | 7 | 17 | 71
 | Steel | 201 | 6 | 38 | 7 | 12 | 80
 | [NAME] | 203 | 6 | 38 | 6 | 14 | 85
 | Lex Luthor | 188 | 10 | 20 | 4 | 12 | 63
 | Cheetah | 175 | 4 | 22 | 17 | 17 | 85
 | Superboy | 170 | 3 | 40 | 9 | 14 | 78
 | Martian Manhunter | 201 | 6 | 46 | 18 | 21 | 85
 | Beast Boy | 172 | 3 | 27 | 4 | 23 | 66
 | Super Girl | 170 | 3 | 41 | 10 | 15 | 80
 | Gog | 191 | 5 | 36 | 10 | 16 | 84
 | Doomsday | 213 | 2 | 50 | 14 | 10 | 85
 | Ares | 208 | 7 | 42 | 9 | 19 | 83
 | Nightwing | 177 | 7 | 26 | 6 | 17 | 80
 | [NAME] | 185 | 7 | 41 | 18 | 19 | 78
 | Black Adam | 183 | 7 | 48 | 17 | 18 | 80
 | Red Tornado | 186 | 5 | 35 | 12 | 22 | 66
 | Hippolyta | 175 | 6 | 24 | 6 | 14 | 70
 | Poison Ivy | 167 | 5 | 13 | 4 | 12 | 65
 | Plastic Man | 186 | 4 | 21 | 4 | 22 | 65
 | Cyborg | 196 | 6 | 36 | 4 | 13 | 65
 | [NAME] | 175 | 5 | 35 | 9 | 16 | 74
 | [NAME] | 166 | 3 | 32 | 12 | 19 | 73
 | General Zod | 191 | 5 | 38 | 4 | 13 | 71
 | Artemis | 183 | 5 | 27 | 5 | 15 | 75
 | Catwoman | 170 | 4 | 17 | 6 | 17 | 72
 | Mr [NAME] | 183 | 6 | 26 | 5 | 10 | 70
 | The Riddler | 186 | 5 | 18 | 4 | 13 | 64
 | Two-Face | 183 | 4 | 20 | 4 | 12 | 61
Spreadsheet: 843540d1695320652-conditional-formatting-based-on-data-in-table-conditional-formula-test
Sheet: Sheet1

 | Day | Monday | Tuesday | Wednesday | Thursday | Friday |  |  |  | Week Of | Monday |  | Monday |  | Tuesday |  | Wednesday |  | Wednesday |  | Thursday
 | Date | 2023-09-25 00:00:00 | 2023-09-26 00:00:00 | 2023-09-27 00:00:00 | 2023-09-28 00:00:00 | 2023-09-29 00:00:00 |  |  |  | 2023-09-25 00:00:00 | 2023-09-25 00:00:00 |  | 2023-09-25 00:00:00 |  | 2023-09-26 00:00:00 |  | 2023-09-27 00:00:00 |  | 2023-09-27 00:00:00 |  | 2023-09-28 00:00:00
 | Colleagues | Test 1 | Test 2 | Test 1 | Test 1 | Test 1 |  |  |  | Time | 8:00AM - 12:00PM |  | 12:30PM - 4:30PM |  | 8:00AM - 4:30PM |  | 8:00AM - 12:00PM |  | 1:00PM - 2:30PM |  | 12:30PM - 4:30PM
 |  | Test 2 | Test 3 | Test 3 | Test 2 | Test 3 |  |  |  | System | Class 1 | [NAME] | Class 2 | [NAME] | Class 3 | [NAME] | Class 4 | [NAME] | Class 5 | [NAME] | Class 6 | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Test 1 | 123345 | Test 1 | 123345 | Test 1 | 123345 | Test 3 | 456456 | Test 2 | 435643567 | Test 1 | 123345
 |  |  |  |  |  |  |  |  |  |  | Test 2 | 435643567 | Test 2 | 435643567 | Test 2 | 435643567 |  |  |  |  | Test 3 | 435643567
 | Looking for Conditional Formatting to Look Like This for Colleague Names
 |  |  |  |  |  |  |  |  | Legond
 | Day | Monday | Tuesday | Wednesday | Thursday | Friday |  |  | No Class
 | Date | 2023-09-25 00:00:00 | 2023-09-26 00:00:00 | 2023-09-27 00:00:00 | 2023-09-28 00:00:00 | 2023-09-29 00:00:00 |  |  | 1 Partial Day Class
 | Colleagues | Test 1 | Test 3 | Test 1 | Test 1 | Test 1 |  |  | 2 Classes for the Day
 |  | Test 2 |  | Test 2 | Test 2 | Test 2
 |  | Test 3 |  | Test 3 | Test 3 | Test 3
 |  | If a Colleague has a class from 8AM to 4:30PM they will not appear on list.
Spreadsheet: 160832d1339233876-dynamic-charts-help-setting-up-with-named-ranges-836659
Sheet: Sheet1

 |  |  | 2010 | 2010 | 2010 | 2010 | 2010 | 2010 | 2010 | 2010 | 2010 | 2010 | 2010 | 2010
 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 |  | Column1 | 1 2010 | 2 2010 | 3 2010 | 4 2010 | 5 2010 | 6 2010 | 7 2010 | 8 2010 | 9 2010 | 10 2010 | 11 2010 | 12 2010
 |  | 1000 Series | 7763.5 | 8469.77 | 14815.32 | 11033.26 | 5095.31 | 15453.28 | 10837.89 | 13496.6 | 12830.25 | 10793.5 | 14062.41 | 3788.38
 |  | 2000 Series | 10092.09 | 5325.63 | 22213.71 | 21963.15 | 17151.68 | 9628.29 | 5899.38 | 14082.57 | 14850.55 | 9588.31 | 13304.52 | 3775.56
 |  | 3000 Series | 55873.29 | 62078.31 | 64356.14 | 63029.48 | 80443.55 | 83927.28 | 53788.17 | 78987.78 | 78974.75 | 71375.56 | 74311.65 | 48475.32
 |  | 4000 Series | 7913.15 | 15395.78 | 16422.78 | 9894.11 | 9978.63 | 6662.32 | 5602.92 | 17048.49 | 7927.92 | 5155.61 | 21520.2 | 3586.9
 |  | 5000 Series | 521.16 | 1108.98 | 746.38 | 1367.3 | 1764.27 | 350.64 | 841.5 | 1257.86 | 424.92 | 210.35 | 1380.11 | 191.29
 |  | 6000 Series | 4091.32 | 3364.03 | 4649.13 | 9092.19 | 3881.53 | 8939.77 | 2668.1 | 5458.63 | 8772.13 | 6326.73 | 6112.38 | 1361.8
 |  | 7000 Series | 14251.74 | 15246.56 | 18486.33 | 19455.33 | 14478 | 26037.78 | 19175.95 | 26168.59 | 29650.31 | 17966.23 | 23866.37 | 15728.87
 |  | 9000 Series | 3105.29 | 10053.25 | 6280.81 | 4243.49 | 16914.07 | 4463.59 | 3970.94 | 3268 | 11368.6 | 4175.57 | 16848.46 | 2684.15
 |  | A Series | 1198.03 | 923.14 | 2479.93 | 1869.04 | 3068.3 | 1404.73 | 2249.31 | 2343.26 | 749.7 | 1196.33 | 1258.6 | 1542.07
 |  | E Series | 1001.4 | 1371.32 | 1504.88 | 825.31 | 1492.36 | 1317.29 | 1701.54 | 584.25 | 521.25 | 1423.17 | 2117.41 | 144.64
 |  | G Series |  | 228.33 | 95.16 | 39.18 | 56.76 | 35.02 | 840.5 | 1010.06 | 395.33
 |  | J Series | 36.14 | 28.24 | 281.32 | 131.84 | 1453.73 | 119.9 |  | 85.23 | 39.02 | 144 | 45.72
 |  | W Series | 132.9 | 272.67 | 1227.66 | 329.2 | 633.82 | 245.72 | 91.76 | 334.3 | 393.56 | 915.27 | 614.87 | 118.3
 |  | N Series | 1090.55 | 2402.93 | 2600.24 | 2844.19 | 2537.91 | 2869.28 | 2588.98 | 4274.55 | 4329.64 | 5080.98 | 5025.16 | 325.28
 |  | S Series | 5458.65 | 3048.2 | 1882.55 | 3061.44 | 2758.47 | 3833.47 | 1706.46 | 12187.53 | 4916.46 | 1415.39 | 2662.92 | 484.94
 |  | U Series |  |  | 17.2 |  |  |  |  |  |  | 34.4
 |  | Miscellaneous Income | 3523.17 | 2853.21 | 6695.1 | 7851.87 | 4162.62 | 5827.62 | 3407.48 | 2316.94 | 4447.69 | 6658.86 | 6573.95 | 2276.32
Spreadsheet: 170187d1343199422-sum-over-overlapping-arrays-sumoverlappingarrays5
Sheet: LoadOnProductionCenters

16 | 22 | 62 | 118 | 198 | 88 | 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 | ProdCenter1
24 | 24 | 78 | 148 | 154 | 176 | 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 | ProdCenter2
22 | 22 | 82 | 112 | 44 | 22 | 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 | ProdCenter3
28 | 36 | 100 | 136 | 88 | 44 | 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 | ProdCenter4
Period1 | Period2 | Period3 | Period4 | Period5 | Period6 | Period7 | Period8 | Period9 | Period10 | Period11 | Period12 | Period13 | Period14 | Period15 | Period16 | Period17 | Period18 | Period19 | Period20 | Period21 | Period22 | Period23 | Period24 | Period25 | Period26 | Period27 | Period28 | Period29 | Period30 | Period31 | Period32 | Period33 | Period34 | Period35 | Period36 | Period37 | Period38 | Period39 | Period40 | Period41 | Period42 | Period43 | Period44 | Period45 | Period46 | Period47 | Period48 | Period49 | Period50 | Period51 | Period52 | Period53 | Period54
The "Product" sheets contain the production load on every production center at every period (there are 30 of them)
The "PlanningTable" sheet contains the planned order releases
The "LoadOnProductionCenters" sheet contains the solution: the load on every production center caused by all the planned products. Every "Product" sheet has to be added to the "LoadOnProductionCenters" table at the location and with the factor given by the "PlanningTable".
The yellow parts of the "LoadOnProductionCenters" table give wrong (too small) numbers, because they depend on periods smaller than 1 or bigger than 52 of the "PlanningTable"
Spreadsheet: 718618d1613237872-formula-for-automatic-breakdown-sample-data
Sheet: Sheet3

 |  |  |  |  | what formula for this breakdown
 |  | [NAME] | 10 |  | [NAME]
 |  | abc15 | 5 |  | [NAME]
 |  | mmm20 | 20 |  | [NAME]
 |  |  |  |  | [NAME]
 |  |  |  |  | [NAME]
 |  |  |  |  | [NAME]
 |  |  |  |  | [NAME]
 |  |  |  |  | [NAME]
 |  |  |  |  | [NAME]
 |  |  |  |  | [NAME]
 |  |  |  |  | abc15
 |  |  |  |  | abc15
 |  |  |  |  | abc15
 |  |  |  |  | abc15
 |  |  |  |  | abc15
 |  |  |  |  | mmm20
 |  |  |  |  | mmm20
 |  |  |  |  | mmm20
 |  |  |  |  | mmm20
 |  |  |  |  | mmm20
 |  |  |  |  | mmm20
 |  |  |  |  | mmm20
 |  |  |  |  | mmm20
 |  |  |  |  | mmm20
 |  |  |  |  | mmm20
 |  |  |  |  | mmm20
 |  |  |  |  | mmm20
 |  |  |  |  | mmm20
 |  |  |  |  | mmm20
 |  |  |  |  | mmm20
 |  |  |  |  | mmm20
 |  |  |  |  | mmm20
 |  |  |  |  | mmm20
 |  |  |  |  | mmm20
 |  |  |  |  | mmm20
Spreadsheet: 49429d1248789441-finding-anagrams-in-a-word-list-book1
Sheet: Sheet1

CHAIR | NIGHT | #N/A
EXCEPT | [NAME] | #N/A
WORLD | EXPECT | 2 | EXCEPT
STREET | THOUGHT | #N/A
OUTSIDE | TEDIOUS | 5 | OUTSIDE
PEOPLE | OFFICE | #N/A
WINDOW | SETTER | 4 | STREET
LETTER | [NAME] | #N/A
BOOK | BEFORE | #N/A
 | OFFER | #N/A
Spreadsheet: 479003d1473176090-streetnumbers-even-and-odd-welldone
Sheet: Tabelle1

Code | von | bis | Code3 | Code2 | Kennziffer | Column1 |  |  |  |  | STCODE | [NAME]. | Code | Code2 | Richtig | Richtig
81379 KIS | 61 | 75 | 43 | 270 |  |  |  |  |  |  | 81379 KIS | 1 |  |  | 44 | 550
81379 KIS | 1 | 59 | 44 | 550 |  |  |  |  |  |  | 81379 KIS | 74 |  |  | 43 | 270
81379 KIS | 2 | 60 | 44 | 550 |  |  |  |  |  |  | 81379 KIS | 155 |  |  | 43 | 285
81379 KIS | 61 | 75 | 43 | 270 |  |  |  |  |  |  | 81379 KIS | 148 |  |  | 43 | 285
81379 KIS | 62 | 82 | 43 | 480 |  |  |  |  |  |  | 81379 KIS | 160 |  |  | 43 | 290
81379 KIS | 77 | 101 | 43 | 270 |  |  |  |  |  |  | 81379 KIS | 4 |  |  | 44 | 550
81379 KIS | 84 | 124 | 43 | 270 |  |  |  |  |  |  | 81476 LIM | 10 |  |  | 42 |  |  |  | [NAME] (ein Streetrange 1 bis [NAME] normaler sverweis
81379 KIS | 103 | 123 | 43 | 280 |  |  |  |  |  |  | 82041 NOR | 88 |  |  | 83 | 160 |  |  | [NAME] (ein Streetrange 1 bis [NAME] normaler sverweis
81379 KIS | 125 | 144 | 43 | 280 |  |  |  |  |  |  | 83561 MUC | 24 |  |  | 82 | 360
81379 KIS | 145 | 157 | 43 | 285 |  |  |  |  |  |  | 83561 MUC | 13 |  |  | 80 | 100
81379 KIS | 146 | 150 | 43 | 285 |  |  |  |  |  |  | 83561 MUC | 14 |  |  | 81 | 370
81379 KIS | 152 | 8888 | 43 | 290 |  |  |  |  |  |  | 83561 MUC | 19 |  |  | 81 | 110
81379 KIS | 159 | 9999 | 43 | 290 |  |  |  |  |  |  | 83561 MUC | 26 |  |  | 82 | 360
81476 LIM | 1 | 9999 | 42 | 970 |  |  |  |  |  |  | 83561 MUC | 88 |  |  | 79 | 350
82041 NOR | 1 | 9999 | 83 | 160 |  |  |  |  |  |  | 83561 MUC | 99 |  |  | 83 | 150
83561 MUC | 1 | 15 | 80 | 100
83561 MUC | 2 | 20 | 81 | 370
83561 MUC | 17 | 21 | 81 | 110
83561 MUC | 22 | 28 | 82 | 360
83561 MUC | 23 | 9999 | 83 | 150
83561 MUC | 30 | 8888 | 79 | 350
Ich benötige eine [NAME] STCODE in der Matrix findet in A:F und gleichzeitig in der gefundenen Zeile prüft ob die [NAME].  in J:J in Streetrange B:C passt und dann als [NAME] die richtige [NAME].
Spreadsheet: 884662d1733905442-sum-data-with-condition-kimudao-sumif-2-pt-365-aligw
Sheet: period

month | period
ad | Active L12M
2024 - 01 | Active L12M
2024 - 02 | Active L12M
2024 - 03 | Active L12M
2024 - 04 | Active L12M
2024 - 05 | Active L12M
2024 - 06 | Active L12M
2024 - 07 | Active L12M
2024 - 08 | Active L12M
2024 - 09 | Active L12M
2024 - 10 | Active L12M
2024 - 11 | Active L12M
Spreadsheet: 878748d1726033925-referencing-multiple-sheet-inorder-to-create-pt-pl2
Sheet: Result

Sheet Name > | [NAME]
Subject > | Science
 | Step 1 |  |  |  | Step 2 |  | Step 3
 |  |  |  |  | Adding unique |  | filtering >1000 based on Name
 |  |  | >>>>> | Name | Marks | >>>>> | Name | ID | Marks
 |  |  |  | Shweta |  |  | Shweta | 74
 |  |  |  | Check | 192
Spreadsheet: 05850fdc-d49e-45df-b5f3-cb0b5a839f57
Sheet: BEvalidations

VALIDATION | STAFF FILE | STUDENT FILE
STAFF FILE
Reject file if local course number doesn't exist in their index for reporting year | yes
Reject file if file folder number is invalid in MDE | yes
Reject file if no calendar information exists for reporting year | yes
Reject file if there is no teacher of record for each course section | yes
If fixed period indicator is false do not save any data in start and end period fields if they are populated
Reject file if file folder number does not exist. | yes | yes
Reject student file if there are scheduled and independent student student records and no calendar data for reporting year |  | yes
Cannot submit course section record if the calendar record does not match.
You can add, edit or delete course section records up to the point of adding student course sections.
Cannot delete any course index with a course section related to it.
Reject staff file if there is no calendar data for reporting year | yes
Allow multiple teachers for one section | YES | YES
Student file will reject if student does not have a mark for section that has indicated a mark will be given
DEVELOPER QUESTIONS
site cannot be 000 -- min value is 001
how is unique record defined? | ffn
 | local course
 | local section
 | local dist
 | local type
 | local site