tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 690013d1596804754-help-with-forecasting-formula-for-a-retailer-i-am-stumped-please-help-example-for-phasing-help
Sheet: Sales phasing forecast

 |  |  |  |  |  |  | FORECAST SPLIT %
 | Key Forecast | Cateogry | Type | Group | Gender | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 1 | 2 | 3 | 4 | 5 | Overall Result | Comments
 |  | Footwear | ENDUR | SHOES | U | 0.06275187104202648 | 0.05152561888313183 | 0.05152561888313183 | 0.04979850316637881 | 0.05526770293609672 | 0.05555555555555555 | 0.06476683937823834 | 0.03367875647668394 | 0.04461715601611975 | 0.0434657455382844 | 0.06332757628094415 | 0.0659182498560737 | 0.03195164075993091 | 0.02590673575129534 | 0.02389176741508348 | 0.02302820955670697 | 0.02849740932642487 | 0.02849740932642487 | 0.02878526194588371 | 0.03195164075993091 | 0.01986183074265976 | 0.02475532527345999 | 0.0233160621761658 | 0.02302820955670697 | 0.02130109383995394 | 0.02302820955670697 | 1
 |  | Socks | Running Socks | SOCKS | U | 0.01373064563248612 | 0.0035056967572305 | 0.002337131171487 | 0.000292141396435875 | 0.00175284837861525 | 0.002337131171487 | 0.00175284837861525 | 0.0035056967572305 | 0.009056383289512124 | 0.007595676307332749 | 0.02191060473269062 | 0.02337131171487 | 0.032719836400818 | 0.02979842243645925 | 0.03125912941863862 | 0.04177621969033012 | 0.09144025708442886 | 0.06251825883727724 | 0.09962021618463336 | 0.1016652059596845 | 0.1156879929886065 | 0.09494595384165937 | 0.08618171194858311 | 0.04528191644756062 | 0.03885480572597137 | 0.03710195734735612 | 1
Spreadsheet: 751986d1634494348-needing-help-with-matching-ir-rollup-12oct21
Sheet: Parts Request

NIIN | Nomenclature | U of I | Batch | QTY | Unit Price | Total Price | Location | Date | QTY
000000079 | Washer Flat | EA | B | 1 | 0.35 |  | W2N9 | 2021-03-05 00:00:00 | 1
000880552 | Nut Self Locking Hexagon | EA | B | 10 | 1.01 |  | W1K2 | 2021-01-15 00:00:00 | 4
015062715 | WHEEL AND TIRE ASSEMBLY | AY | B | 2 | 3095 |  | BT3 | 2021-08-27 00:00:00 | 2
002932336 | AX,SINGLE BIT | EA | B | 26 | 30.42 |  | AB2 | 2021-02-05 00:00:00 | 20
002933336 | SHOVEL, HAND | EA | B | 20 | 15.76 |  | AB3 | 2021-07-02 00:00:00 | 14
005417839 | SOCKET,SOCKET WRENCH | EA | B | 12 | 44.36 |  | L2D | 2021-02-05 00:00:00 | 4
Spreadsheet: darrell_schoolcraft__7825__imbalsumm0109
Sheet: summary

TRANSWESTERN  PIPELINE -   SUMMARY OF OBA BALANCES |  |  |  |  |  | index
 |  |  |  |  |  | SJ
Positive=due [NAME] |  | Negative = due operator |  |  |  | AVG
 |  |  |  |  |  | NTXPH
Operator | Dollars | Volume | Date | Imbal Type | MS rep | Comments
SoCal |  |  |  | Volumetric | [NAME]
EPFS / PG&E TX |  |  |  | Dollar Valued | [NAME]
[NAME] |  |  |  | Dollar Valued | [NAME]
NNG |  |  |  | Dollar Valued | [NAME]
[NAME] |  |  |  | Volumetric | [NAME]
Amoco Abo |  |  |  | Dollar Valued | [NAME]
Conoco |  |  |  | Dollar Valued | [NAME] | [NAME] and Maljamar
CIG |  |  |  | Dollar Valued | [NAME] | if changed to volumetric the volume would be 61,000 mmbtus
Mewborne |  |  |  | Dollar Valued | [NAME]
Mojave Pipeline |  |  |  | Volumetric | [NAME]
Red Cedar |  |  |  | Volumetric | [NAME]
NGPL |  |  |  | Volumetric | [NAME]
PNM |  |  |  | Dollar Valued | [NAME]
Lonestar |  |  |  | Volumetric | [NAME]
PG&E Topock |  |  |  | Volumetric | [NAME]
Agave |  |  |  | Dollar Valued | [NAME]
Amoco |  |  |  | Volumetric | [NAME]
Oasis |  |  |  | Volumetric | [NAME]
Calpine |  |  |  | Dollar Valued | [NAME]
Northwest |  |  |  | Volumetric | [NAME]
EOG |  |  |  | Dollar Valued | [NAME]
TransColorado |  |  |  | Dollar Valued | [NAME]
[NAME] |  |  |  | Dollar Valued | [NAME] | cashed out monthly
Continental |  |  |  | Dollar Valued | [NAME]
Burlington |  |  |  | Dollar Valued | [NAME] | balance is cashed out monthly
Receivable imbalances
Operator | Dollars | Volume | Date | Imbal Type | MS rep | Comments
Citizens Communications |  |  |  | Dollar Valued | [NAME]
North Star Steel |  |  |  | Dollar Valued | [NAME]
Duke/GPM |  |  |  | Dollar Valued | [NAME] | Crawford, Pecos Diamond, [NAME], Linam Ranch, Artesia
Citizens-Griffith |  |  |  | Dollar Valued | [NAME]
El Paso Field Services |  |  |  | Dollar Valued | [NAME]
El Paso |  |  |  | Volumetric | [NAME] | Blanco and Window Rock
Panhandle Eastern |  |  |  | Volumetric | [NAME] | Hansford
Payable imbalances
Net imbals
Note -  This report does not represent the total population of imbalances on Transwestern.
Spreadsheet: 60854edd-3ad1-425a-b018-97c2c5aa8b5d
Sheet: Segments

Johnson & Johnson and Subsidiaries
Supplementary Sales Data
([NAME]; Dollars in Millions) | FIRST QUARTER
 |  |  |  |  | Percent Change
 | 2011 |  | 2010 |  | Total |  | Operations |  | Currency
Sales to customers by
segment of business
Consumer
U.S. | 1345 |  | 1560 |  | -13.8 | % | -13.8 |  | 0
International | 2337 |  | 2206 |  | 5.9 |  | 2.600000000000001 |  | 3.3
 | 3682 |  | 3766 |  | -2.2 |  | -4.1 |  | 1.9
Pharmaceutical
U.S. | 3391 |  | 3206 |  | 5.8 |  | 5.8 |  | 0
International | 2668 |  | 2432 |  | 9.7 |  | 7.299999999999999 |  | 2.4
 | 6059 |  | 5638 |  | 7.5 |  | 6.4 |  | 1.1
Med Devices & Diagnostics
U.S. | 2872 |  | 2886 |  | -0.5 |  | -0.5 |  | 0
International | 3560 |  | 3341 |  | 6.6 |  | 3 |  | 3.6
 | 6432 |  | 6227 |  | 3.3 |  | 1.3 |  | 2
U.S. | 7608 |  | 7652 |  | -0.6 |  | -0.6 |  | 0
International | 8565 |  | 7979 |  | 7.3 |  | 4.1 |  | 3.2
Worldwide | 16173 |  | 15631 |  | 3.5 | % | 1.8 |  | 1.7
Spreadsheet: 721275d1614619694-combine-5-lists-into-one-list-combine-5lists-into-one-big-list
Sheet: Report

No | Employee Name | Job
2 | B | Job AA |  | Required:
3 | C | Job AA |  | Sheet Data contains 5 Lists in different columns
4 | D | Job AA |  | I want to combine them in one big list (in one column) in sheet Report
5 | E | Job AA
6 | F | Job AA
7 | G | Job AA
8 | H | Job AA
9 | I | Job BB
10 | J | Job BB
11 | K | Job BB
12 | L | Job AA
13 | M | Job AA
14 | N | Job AA
15 | O | Job AA
16 | P | Job AA
17 | Q | Job AA
18 | R | Job AA
19 | S | Job AA
20 | T | Job BB
21 | U | Job BB
22 | V | Job AA
23 | W | Job AA
24 | X | Job AA
25 | Y | Job AA
26 | Z | Job AA
27 | AA | Job AA
28 | BB | Job AA
29 | CC | Job AA
30 | DD | Job BB
31 | EE | Job BB
32 | FF | Job BB
33 | GG | Job AA
34 | HH | Job AA
35 | II | Job AA
36 | JJ | Job AA
37 | KK | Job AA
38 | LL | Job AA
39 | MM | Job AA
40 | NN | Job AA
41 | OO | Job BB
42 | PP | Job BB
43 | OO | Job AA
44 | PP | Job AA
45 | QQ | Job AA
46 | RR | Job AA
47 | SS | Job AA
48 | TT | Job AA
49 | UU | Job AA
50 | VV | Job AA
51 | WW | Job BB
52 | XX | Job BB
53 | YY | Job BB
54 | ZZ | Job BB
55 | AAA | Job cc
56 | BBB | Job cc
57 | CCC | Job cc
58 | DDD | Job cc
59 | EEE | Job cc
60 | FFF | Job cc
61 | GGG | Job cc
62 | HHH | Job DD
63 | III | Job DD
64 | JJJ | Job DD
65 | KKK | Job DD
66 | LLL | Job DD
67 | MMM | Job DD
68 | NNN | Job DD
69 | OOO | Job DD
70 | PPP | Job DD
71 | QQQ | Job DD
72 | RRR | Job DD
Spreadsheet: 805344d1668629993-trying-to-create-dynamic-date-time-formula-need-help-wth-dynamic-date-time-formula
Sheet: Sheet1

 | 1st workday of the month: | 2022-11-01 00:00:00 |  |  | Order | Part # | Qty | Start (date&time) | Setup + Run Time (hrs) | End/Completion (date&time)
 | Machine #: | H123 |  |  | 1 | BACB123 | 33000 |  |  | 2022-11-02 10:30:00
 | Rate (pcs/hr): | 2000 |  |  | 2 | BACB1234 | 10000 |  |  | 2022-11-02 19:30:00
 | Setup (hrs): | 4 |  |  | 3 | BACB12345 | 3000 |  |  | 2022-11-03 09:00:00
 | 2 Shifts
 | DayStart
 | DayEnd
Spreadsheet: 065a5b47-f6bf-4f62-bd16-bde3c98aaa63
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 |  | Central | IBC | NEPA | Highmark | Totals
 | ADAMS | 43 |  |  |  | 43
 | ALLEGHENY |  |  |  | 2622 | 2622
 | ARMSTRONG |  |  |  | 244 | 244
 | BEAVER |  |  |  | 381 | 381
 | BEDFORD |  |  |  | 153 | 153
 | BERKS | 155 |  |  |  | 155
 | BLAIR |  |  |  | 392 | 392
 | BRADFORD |  |  | 30 |  | 30
 | BUCKS |  | 469 |  |  | 469
 | BUTLER |  |  |  | 360 | 360
 | CAMBRIA |  |  |  | 790 | 790
 | CAMERON |  |  |  | 26 | 26
 | CARBON |  |  | 101 |  | 101
 | CENTRE | 50 |  |  | 70 | 120
 | CHESTER |  | 212 |  |  | 212
 | CLARION |  |  |  | 114 | 114
 | CLEARFIELD |  |  |  | 417 | 417
 | CLINTON |  |  | 34 |  | 34
 | COLUMBIA | 55 |  |  |  | 55
 | CRAWFORD |  |  |  | 303 | 303
 | CUMBERLAND | 99 |  |  |  | 99
 | DAUPHIN | 116 |  |  |  | 116
 | DELAWARE |  | 535 |  |  | 535
 | ELK |  |  |  | 172 | 172
 | ERIE | 1 |  |  | 1366 | 1367
 | FAYETTE |  |  |  | 489 | 489
 | FOREST |  |  |  | 5 | 5
 | FRANKLIN | 47 |  |  |  | 47
 | FULTON | 13 |  |  |  | 13
 | GREENE |  |  |  | 139 | 139
 | HUNTINGDON |  |  |  | 122 | 122
 | INDIANA |  |  |  | 301 | 301
 | JEFFERSON |  |  |  | 172 | 172
 | JUNIATA | 16 |  |  |  | 16
 | [NAME] |  |  | 195 |  | 195
 | LANCASTER | 117 |  |  |  | 117
 | [NAME] |  |  |  | 278 | 278
 | LEBANON | 50 |  |  |  | 50
 | LEHIGH | 133 |  |  |  | 133
 | LUZERNE |  |  | 306 |  | 306
 | LYCOMING |  |  | 52 |  | 52
 | MCKEAN |  |  |  | 109 | 109
 | MERCER |  |  |  | 358 | 358
 | MIFFLIN | 63 |  |  |  | 63
 | MONROE |  |  | 112 |  | 112
 | MONTGOMERY |  | 555 |  |  | 555
 | MONTOUR | 5 |  |  |  | 5
 | NORTHAMPTON | 83 |  |  |  | 83
 | NORTHUMBERLAND | 62 |  |  |  | 62
 | PERRY | 28 |  |  |  | 28
 | PHILADELPHIA |  | 2360 |  |  | 2360
 | PIKE |  |  | 35 |  | 35
 | POTTER |  |  |  | 74 | 74
 | SCHUYLKILL | 63 |  |  |  | 63
 | SNYDER | 13 |  |  |  | 13
 | [NAME] |  |  |  | 413 | 413
 | SULLIVAN |  |  | 6 |  | 6
 | SUSQUEHANNA |  |  | 49 |  | 49
 | TIOGA |  |  | 51 |  | 51
 | UNION | 9 |  |  |  | 9
 | VENANGO |  |  |  | 187 | 187
 | WARREN |  |  |  | 155 | 155
 | WASHINGTON |  |  |  | 518 | 518
 | WAYNE |  |  | 49 |  | 49
 | WESTMORELAND |  |  |  | 1144 | 1144
 | WYOMING |  |  | 23 |  | 23
 | YORK | 140 |  |  |  | 140
 | Totals | 1361 | 4131 | 1043 | 11874 | 18409
Spreadsheet: 720918d1614364132-resetting-a-rows-function-based-on-a-counta-function-rows-example1
Sheet: FRI

 |  |  | HOW IT SHOULD LOOK |  | WHAT HAPPENS CURRENTLY
FRIDAY 2/26/21 |  |  | CREW1 |  |  |  |  |  |  |  |  | CREW | ORDER | CUSTOMER | STORE1 | PHONE1 | PHONE2 | NOTES | ADDRESS | JOB TYPE | JOB | AMOUNT
09:30:00 | - |  |  |  |  |  |  |  |  |  |  | CREW1 | 3 | CUSTOMER2 | STORE1 | CUSTOMER2 PHONE1 | [NAME] | CUSTOMER2 NOTES | CUSTOMER2 ADDRESS | SIDE JOB
 |  |  |  |  |  |  |  |  |  |  |  | CREW1 | 4 | CUSTOMER3 | STORE1 | CUSTOMER3 PHONE1 | [NAME] | CUSTOMER3 NOTES | CUSTOMER3 ADDRESS | INSTALL
 |  |  |  |  |  |  |  |  |  |  |  | CREW1 | 2 | CUSTOMER1 | STORE1 | CUSTOMER1 PHONE1 | [NAME] | CUSTOMER1 NOTES | CUSTOMER1 ADDRESS | DETAIL
 |  |  |  |  |  |  |  |  |  |  |  |  | 1 | PICKUP AT STORE1 |  | PICKUP FOR: |  |  | STORE1 ADDRESS | PICKUP
 | -
 | -
 |  |  |  |  |  |  |  |  | MY FORMULA
 |  |  |  |  |  |  |  |  | =@INDEX(INDIRECT("fri"&@INDEX(JobTypeLists,
 |  |  |  |  |  |  |  |  | ROWS($C3:C$3)+1,
 | - |  |  |  |  |  |  |  | MATCH(INDEX(JobTypes,,MATCH(@INDEX(FriType,INDEX(MATCH(1,(FriCrew=FriRandy)*(FriOrder=COUNTA($C$3:C3)),0),0)),JobTypes,0)),JobTypes,0))),INDEX(MATCH(1,(FriCrew=FriRandy)*(FriOrder=COUNTA($C$3:[NAME]))
Spreadsheet: 829655d1684352780-creating-an-automatic-list-of-unique-values-in-a-range-creating-an-automatic-list-of-unique-values-in-a-range
Sheet: Sheet1

 | DATA |  |  |  |  |  | EXPECTED RESULTS |  |  |  |  |  |  |  |  | Dynamic First letter to rows, dynamic columns based of Row letter
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E | N
 |  |  |  |  |  |  |  | M |  | E |  | N
 |  |  |  |  |  |  |  | M-01 |  | E-01 |  | N-01 |  |  |  | M-02 | E-02 | N-02
 |  |  |  |  |  |  |  | M-02 |  | E-02 |  | N-02 |  |  |  | M-03 | E-03 | N-03
 | M-01-141 | M-02-143 |  | M-03-145 | M-04-147 |  |  | M-03 |  | E-03 |  | N-03 |  |  |  | M-04 | E-04 | N-04
 | M-01-152 | M-02-154 |  | M-03-156 | M-04-158 |  |  | M-04 |  | E-04 |  | N-04 |  |  |  |  | E-05 | N-05
 | M-01-185 | M-02-187 |  | M-03-189 | M-04-191 |  |  |  |  | E-05 |  | N-05
 | M-01-196 | M-02-198 |  | M-03-200 | M-04-202
 | M-01-229 | M-02-231 |  | M-03-233 | M-04-235
 | M-01-240 | M-02-242 |  | M-03-244 | M-04-246
 | E-01-275 | E-02-277 | E-03-279 | E-04-281 | E-05-283
 | E-01-286 | E-02-288 | E-03-290 | E-04-292 | E-05-294
 | E-01-325 | E-02-327 | E-03-329 | E-04-331 | E-05-333
 | E-01-336 | E-02-338 | E-03-340 | E-04-342 | E-05-344
 | E-01-375 | E-02-377 | E-03-379 | E-04-381 | E-05-383
 | E-01-386 | E-02-388 | E-03-390 | E-04-392 | E-05-394
 | E-01-425 | E-02-427 | E-03-429 | E-04-431 | E-05-433
 | N-01-436 | N-02-438 | N-03-440 | N-04-442 | N-05-444
 | N-01-469 | N-02-471 | N-03-473 | N-04-475 | N-05-477
 | N-01-470 | N-02-DTABA | N-03-472 | N-04-474 | N-05-ABA TR7
 | N-01-DTSLM |  | N-03-DTSLM | N-04-DTSLM
Spreadsheet: 886806d1736929416-marks-sheet-need-subject-name-in-which-fail-in-the-last-coloumn-supervisorptcl-result-sample-sheet-for-help-forum-spill-365-aligw
Sheet: EXAMPLE

5th A
S. No. | Student's Name | Roll No | Isl | Urdu | Maths | S.St | Sc | Eng | [NAME] | % age | FAIL / PASS | Grade | Position | If Fail  Subject Name
 |  |  | [NAME] | [NAME] | Akram | Nasim | Akram | Akram
1 | [NAME] | 5501 | 44 | 24 | 15 | 20 | 11 | 16
2 | [NAME] | 5502 | 76 | 72 | 60 | 43 | 52 | 60
3 | [NAME] | 5503 | 69 | 57 | 54 | 46 | 43 | 59
4 | [NAME] | 5504 | 47 | 41 | 33 | 33 | 33 | 35
5 | abc | 5505 | A | A | 14 | A | A | 19 |  |  |  |  |  | Maths, Eng
6 | def | 5506 | 65 | 54 | 46 | 50 | 73 | 51
7 | ghi | 5507 | 82 | 66 | 59 | 55 | 60 | 63
8 | jkl | 5508 | 84 | 76 | 55 | 41 | 56 | 60
9 | mno | 5509 | 57 | 33 | 64 | 38 | 22 | 33 |  |  |  |  |  | Sc
10 | [NAME] | 5510 | 74 | 69 | 61 | 64 | 50 | 51
11 | [NAME] | 5511 | 81 | 70 | 39 | 50 | 50 | 60
12 | [NAME] | 5512 | 91 | 83 | 70 | 46 | 78 | 53
13 | wajid | 5513 | 85 | 63 | 68 | 52 | 65 | 56
14 | akram | 5514 | 43 | 22 | 60 | 33 | 41 | 35 |  |  |  |  |  | Urdu
15 | [NAME] | 5515 | 54 | 33 | 25 | 33 | 42 | 34 |  |  |  |  |  | Maths
16 | Naushad | 5516 | 63 | 33 | 33 | 51 | 55 | 46
17 | Rafique | 5517 | 50 | 33 | 21 | 36 | 13 | 27 |  |  |  |  |  | Maths, Sc, Eng
18 | [NAME] | 5518 | 69 | 56 | 40 | 33 | 33 | 25 |  |  |  |  |  | Eng
Total Strength |  |  | 34 | 34 | 34 | 34 | 34 | 34
[NAME]
Pass
Fail
%age
Subject | Tot Marks |  | Grade | %age
Islamiyat | 100 |  | A-1 | 80-100
Urdu | 100 |  | A | 70-80
Maths | 100 |  | B | 60-70
S.St | 100 |  | D | 60
Science | 100
English | 100
TOTAL
Spreadsheet: 99686028-a4a1-4b8c-b23a-ff6329c92907
Sheet: Impairment

Permittee Legal Name: |  |  |  |  |  | ODEQ File No./Facility ID:
Facility Common Name: |  |  |  |  |  | Reporting Period: |  | July 1, |  | to | June 30,
Facility Location: |  |  |  |  |  | Laboratory Name:
County: |  |  |  |  |  | Laboratory ORELAP #: |  |  |  | SIC Code(s):
Impairment Sampling: 2 times per year, every year
Please refer to the permit assignment letter to determine if impairment sampling is required.
Name or Number of Sampling Point(s) (group data per sampling point) |  | Sample Date | Iron
 |  |  | mg/L
Permit Reference Concentration |  |  | 1
Name or Number of Sampling Point(s) (group data per sampling point) |  | Sample Date
 |  |  | mg/L | mg/L | mg/L | mg/L | mg/L | mg/L | mg/L | mg/L | mg/L
Permit Reference Concentration
Name or Number of Sampling Point(s) (group data per sampling point) |  | Sample Date
 |  |  | mg/L | mg/L | mg/L | mg/L | mg/L | mg/L | mg/L | mg/L | mg/L | mg/L | mg/L
Permit Reference Concentration
Page 4
Spreadsheet: 699423d1602601059-vlookup-with-condition-book-1-fixed-zak1914-
Sheet: Sheet2

Employee | ID | Year 1 Rate | Year 1 Rate Change | Reason for change | Year 2 Rate | Year 2 Rate Change | Reason for change
Mr [NAME] | 123456 | 73.72 | 85.46 | promotion from 11.2019 | 75.89474
Mr [NAME] | 789666 | 35.43 |  |  | 35.43 | 38.62684000000001 | Promoted from period 04.2020
Mr [NAME] | 654321 | 57.14 |  |  | 58.82563 | 75.89474 | promotion exercise taken place in period 10.2020
Mr [NAME] | 789645 | 57.14 |  |  | 58.82563 | 75.89474 | change band from period 06.2020
Mr [NAME] | 998877 | 44.43 |  |  | 45.74068500000001
Spreadsheet: 86251d1286280076-vba-comparison-of-two-worksheets-cars
Sheet: Customer DB

Car Type | Car Model | Imported to country | Imported Date
Volkswagen | [NAME] | Irland | 2001-01-01 00:00:00
Volkswagen | C5 | China | 2002-02-02 00:00:00
Volkswagen | [NAME] | Japan | 2003-03-03 00:00:00
Citroen | C5 | France | 2006-04-01 00:00:00
Citroen | C5 | UK | 2005-05-05 00:00:00
Spreadsheet: 774795d1648656935-formula-to-calculate-elapsed-time-between-two-dates-times-taylorbrent-covid-pay-audit
Sheet: Sheet2

 | Enter First Date |  |  |  |  |  |  | 00:00:00 |  | 07:00:00 |  | 19:00:00 |  | 23:59:00 |  |  | Day Shift Total | Night Shift Total
 | 2022-03-13 00:00:00
First Day of Data
Last Day of Data
Spreadsheet: 585638d1533880625-help-with-solver-inputs-wall-design-2
Sheet: 1. General Variables

General Variables
Geometry |  |  | Parameters |  |  | Material Rates
Group Number | 7 |  | [NAME] | 1.2 | m | [NAME] (incl. GST) |  | $/m3
H |  | m
0.4H |  | m |  |  |  | Concrete Rate (incl. GST) | 475 | $/m3
Post Length |  | m
Acoustic Barrier Height |  | m |  |  |  | Steel Post Rate (incl. GST) | 4180 | $[NAME]
Acoustic Barrier Length | 1200 | m |  |  |  | Steel Post Misc Items Rate  (incl. GST) | 0.05 | % Steel Post Cost
[NAME] | 0.3 | m |  |  |  | Girt and Components Supply Rate | 0.5 | % Girt and Components Cost
[NAME] | 0.3 | m
[NAME] | 0.3 | m3
[NAME]
Spreadsheet: 484809d1476457548-calculate-intakes-by-month-casse_massagno
Sheet: Daten

 | January | February | March | April | May | June | July | August | September | October | November | Dicember
2013 | 5000 | 4300 | 6000 | 7000 | 9700 | 9600 | 6800 | 5900 | 4300 | 5000 | 3800 | 5300
2014 | 6200 | 4800 | 6200 | 7100 | 8500 | 8500 | 9100 | 7600 | 6300 | 4700 | 4700 | 6100
2015 | 5100 | 4200 | 5100 | 7000 | 7800 | 7800 | 5800 | 6400 | 6700 | 4100 | 3700 | 3600
2016 | 3700 | 3800 | 4800 | 4300 | 5100
Spreadsheet: 124800d1318612197-formula-to-treat-cell-as-empty-despite-formula-in-that-cell-excel-forum
Sheet: Sheet1

Date | Times | Hrs / shift | Hrs Total | Hrs correct | [NAME]
2011-10-01 00:00:00 | 6.45-12.15 | 5.5 |  |  |  |  | 5.5
2011-10-07 00:00:00 | 8-12.15 | 4.25 |  |  |  |  | 4.25
 |  |  | 9.75 | x | 9.75 |  | 5
2011-10-09 00:00:00 | 6.45-11.45 | 5
2011-10-14 00:00:00 | 8-12.15 | 4.25
 |  |  | 9.25
2011-10-15 00:00:00 | 6.45-12.15 | 5.5
2011-10-21 00:00:00 | 8-12.15 | 4.25
 |  |  | 9.75
2011-10-23 00:00:00 | 6.45-11.45 | 5
 |  |  | #N/A
2011-11-04 00:00:00 | 8-12.15 | 4.25
 |  |  | #N/A
2011-11-06 00:00:00 | 6.45-11.15 |  | #N/A
2011-11-11 00:00:00 | 8-12.15 | 4.25
 |  |  | #N/A
2011-11-12 00:00:00 | 6.45-12.15 | 5.5
2011-11-18 00:00:00 | 8-12.15 | 4.25
 |  |  | 9.75
2011-11-25 00:00:00 | 8-12.15 | 4.25
 |  |  | #N/A
2011-11-26 00:00:00 | 6.45-12.15 | 5.5
2011-12-02 00:00:00 | 8-12.15 | 4.25
 |  |  | 9.75
2011-12-03 00:00:00 | 6.45-12.15 | 5.5
2011-12-09 00:00:00 | 8-12.15 | 4.25
 |  |  | 9.75
2011-12-10 00:00:00 | 6.45-12.15 | 5.5
2011-12-16 00:00:00 | 8-12.15 | 4.25
 |  |  | 9.75
2011-12-17 00:00:00 | 6.45-12.15 | 5.5
2011-12-23 00:00:00 | 8-12.15 | 4.25
 |  |  | 9.75
Spreadsheet: 29046d1223706124-two-dimensional-help-jg-master
Sheet: Payout

FEES | # | POT | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
15
6 | 1 | 9 | 9
12 | 2 | 18 | 18
18 | 3 | 27 | 27
24 | 4 | 36 | 21.6 | 14.4
30 | 5 | 45 | 27 | 18
36 | 6 | 54 | 32.4 | 21.6
42 | 7 | 63 | 31.5 | 18.9 | 12.6
48 | 8 | 72 | 36 | 21.6 | 14.4
54 | 9 | 81 | 40.5 | 24.3 | 16.2
60 | 10 | 90 | 36 | 27 | 18 | 9
66 | 11 | 99 | 39.6 | 29.7 | 19.8 | 9.9
72 | 12 | 108 | 43.2 | 32.4 | 21.6 | 10.8
78 | 13 | 117 | 39.78 | 31.59 | 23.4 | 15.21 | 7.02
84 | 14 | 126 | 42.84 | 34.02 | 25.2 | 16.38 | 7.56
90 | 15 | 135 | 45.90000000000001 | 36.45 | 27 | 17.55 | 8.1
96 | 16 | 144 | 41.76 | 34.56 | 27.36 | 20.16 | 12.96 | 7.2
102 | 17 | 153 | 44.37 | 36.72 | 29.07 | 21.42 | 13.77 | 7.65
108 | 18 | 162 | 46.98 | 38.88 | 30.78 | 22.68 | 14.58 | 8.1
114 | 19 | 171 | 49.59 | 41.04 | 32.49 | 23.94 | 15.39 | 8.55
120 | 20 | 180 | 52.2 | 43.2 | 34.2 | 25.2 | 16.2 | 9
126 | 21 | 189 | 54.81 | 45.36 | 35.91 | 26.46 | 17.01 | 9.450000000000001
132 | 22 | 198 | 57.41999999999999 | 47.52 | 37.62 | 27.72 | 17.82 | 9.9
138 | 23 | 207 | 60.02999999999999 | 49.68 | 39.33 | 28.98 | 18.63 | 10.35
144 | 24 | 216 | 62.63999999999999 | 51.84 | 41.04 | 30.24 | 19.44 | 10.8
150 | 25 | 225 | 65.25 | 54 | 42.75 | 31.5 | 20.25 | 11.25
156 | 26 | 234 | 67.86 | 56.16 | 44.46 | 32.76000000000001 | 21.06 | 11.7
162 | 27 | 243 | 70.47 | 58.32 | 46.17 | 34.02 | 21.87 | 12.15
168 | 28 | 252 | 73.08 | 60.48 | 47.88 | 35.28 | 22.68 | 12.6
174 | 29 | 261 | 75.69 | 62.64 | 49.59 | 36.54000000000001 | 23.49 | 13.05
180 | 30 | 270 | 78.3 | 64.8 | 51.3 | 37.8 | 24.3 | 13.5
186 | 31 | 279 | 80.91 | 66.96 | 53.01 | 39.06 | 25.11 | 13.95
192 | 32 | 288 | 83.52 | 69.12 | 54.72 | 40.32000000000001 | 25.92 | 14.4
198 | 33 | 297 | 86.13 | 71.28 | 56.43 | 41.58000000000001 | 26.73 | 14.85
204 | 34 | 306 | 88.74 | 73.44 | 58.14 | 42.84 | 27.54 | 15.3
210 | 35 | 315 | 72.45 | 63 | 53.55 | 44.1 | 34.65 | 25.2 | 15.75 | 6.3
216 | 36 | 324 | 74.52000000000001 | 64.8 | 55.08000000000001 | 45.36000000000001 | 35.64 | 25.92 | 16.2 | 6.48
222 | 37 | 333 | 76.59 | 66.60000000000001 | 56.61000000000001 | 46.62 | 36.63 | 26.64 | 16.65 | 6.66
228 | 38 | 342 | 78.66 | 68.4 | 58.14000000000001 | 47.88 | 37.62 | 27.36 | 17.1 | 6.84
234 | 39 | 351 | 80.73 | 70.2 | 59.67 | 49.14000000000001 | 38.61 | 28.08 | 17.55 | 7.02
240 | 40 | 360 | 82.8 | 72 | 61.2 | 50.40000000000001 | 39.6 | 28.8 | 18 | 7.2
246 | 41 | 369 | 84.87 | 73.8 | 62.73 | 51.66 | 40.59 | 29.52 | 18.45 | 7.38
252 | 42 | 378 | 86.94 | 75.60000000000001 | 64.26 | 52.92 | 41.58 | 30.24 | 18.9 | 7.56
258 | 43 | 387 | 89.01 | 77.4 | 65.79 | 54.18000000000001 | 42.57 | 30.96 | 19.35 | 7.74
264 | 44 | 396 | 91.08 | 79.2 | 67.32000000000001 | 55.44 | 43.56 | 31.68 | 19.8 | 7.92
270 | 45 | 405 | 93.15 | 81 | 68.85000000000001 | 56.7 | 44.55 | 32.4 | 20.25 | 8.1
Spreadsheet: 583955d1532816235-please-need-correction-on-sum-mid-formula-to-find-low-high-on-universe-of-10-digits-low-high-on-universe-of-10-digit-sample
Sheet: Sheet1

 | If Low numbers are 1,2,3,4,5 and low number are 6,7,8,9,0, Then why I'm getting some wrong output?
 |  |  |  |  |  |  |  |  |  | Some ouputs are wrong
 | Correct Output |  |  |  |  |  |  |  |  | Low/High | Using bellow formulas on row K15:K25
 | 5/0 | 4-4-3-3-0 | Correct |  |  |  |  |  |  |  | =SUM(--(--MID(E15,{1,1,3,9,9},1)<=5))&"/"&SUM(--(--MID(E15,{1,1,3,9,9},1)>=6))
 | 3/2 | 6-2-0-2-8 | wrong --> |  |  |  |  |  |  |  | =SUM(--(--MID(E16,{1,1,3,9,9},1)<=5))&"/"&SUM(--(--MID(E16,{1,1,3,9,9},1)>=6))
 | 3/2 | 5-5-1-7-0 | wrong --> |  |  |  |  |  |  |  | =SUM(--(--MID(E17,{1,1,3,9,9},1)<=5))&"/"&SUM(--(--MID(E17,{1,1,3,9,9},1)>=6))
 | 3/2 | 1-9-1-4-6 | wrong --> |  |  |  |  |  |  |  | =SUM(--(--MID(E18,{1,1,3,9,9},1)<=5))&"/"&SUM(--(--MID(E18,{1,1,3,9,9},1)>=6))
 | 3/2 | 9-3-2-3-0 | Correct |  |  |  |  |  |  |  | =SUM(--(--MID(E19,{1,1,3,9,9},1)<=5))&"/"&SUM(--(--MID(E19,{1,1,3,9,9},1)>=6))
 | 2/3 | 2-9-5-0-6 | Correct |  |  |  |  |  |  |  | =SUM(--(--MID(E20,{1,1,3,9,9},1)<=5))&"/"&SUM(--(--MID(E20,{1,1,3,9,9},1)>=6))
 | 4/1 | 3-3-2-8-5 | wrong--> |  |  |  |  |  |  |  | =SUM(--(--MID(E21,{1,1,3,9,9},1)<=5))&"/"&SUM(--(--MID(E21,{1,1,3,9,9},1)>=6))
 | 1/4 | 9-7-8-6-2 | wrong--> |  |  |  |  |  |  |  | =SUM(--(--MID(E22,{1,1,3,9,9},1)<=5))&"/"&SUM(--(--MID(E22,{1,1,3,9,9},1)>=6))
 | 4/1 | 7-1-1-3-3 | wrong--> |  |  |  |  |  |  |  | =SUM(--(--MID(E23,{1,1,3,9,9},1)<=5))&"/"&SUM(--(--MID(E23,{1,1,3,9,9},1)>=6))
 | 4/1 | 1-4-8-2-3 | wrong--> |  |  |  |  |  |  |  | =SUM(--(--MID(E24,{1,1,3,9,9},1)<=5))&"/"&SUM(--(--MID(E24,{1,1,3,9,9},1)>=6))
 | 2/3 | 7-9-4-8-5 | correct |  |  |  |  |  |  |  | =SUM(--(--MID(E25,{1,1,3,9,9},1)<=5))&"/"&SUM(--(--MID(E25,{1,1,3,9,9},1)>=6))