tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 870730d1717180602-excel-solver-integer-solver-cant-solve-it-example
Sheet: Q5 

 | From/To |  | Location 2 | Location 3 | Location 4 | Location 5 | Location 6 | Location 7 | Daily Production Capacity
 | Location 1 | 0 | 2452 | 2051 | 470 | 976 | 564 | 1672 | 4.5
 | Location 2 | 2452 | 0 | 906 | 2870 | 1874 | 2918 | 1257 | 3
 | Location 3 | 2051 | 906 | 0 | 2493 | 1203 | 2434 | 414 | 4.5
 | Location 4 | 470 | 2870 | 2493 | 0 | 1294 | 135 | 2094 | 3
 | Location 5 | 976 | 1874 | 1203 | 1294 | 0 | 1235 | 806 | 3
 | Location 6 | 564 | 2918 | 2434 | 135 | 1235 | 0 | 2036 | 6
 | Location 7 | 1672 | 1257 | 414 | 2094 | 806 | 2036 | 0 | 4.5
 | Daily Demand | 1.5 | 3 | 6 | 4.5 | 4.5 | 4.5 | 3
 | From/To |  | Location 2 | Location 3 | Location 4 | Location 5 | Location 6 | Location 7 | Daily Production Capacity (Fixed Given in the Question | Capacity (sum:C16+I16)
 | Location 1 | 1.5 | 0 | 0 | 0 | 1.5 | 0 | 0 | 4.5
 | Location 2 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 3
 | Location 3 | 0 | 0 | 4.5 | 0 | 0 | 0 | 0 | 4.5
 | Location 4 | 0 | 0 | 0 | 3 | 0 | 0 | 0 | 3
 | Location 5 | 0 | 0 | 0 | 0 | 3 | 0 | 0 | 3
 | Location 6 | 0 | 0 | 0 | 1.5 | 0 | 4.5 | 0 | 6
 | Location 7 | 0 | 0 | 1.5 | 0 | 0 | 0 | 3 | 4.5
 | Demand (Fixed given in the question | 1.5 | 3 | 6 | 4.5 | 4.5 | 4.5 | 3
 | Total Demand (sum c16:c22)
 | Cost |  | Objective Function
Spreadsheet: 40896d1239289074-using-if-statement-to-carry-over-grand-totals-based-on-base-number-sample-hours-report
Sheet: Sheet2 (4)

211.3798 | 120.3048 | 70.0099 | 110.7343 | 75.0418 | 28.1292 | 100 | 56 | 77 | 85 | 125 | 75 | 90 | 99 | 160 | 65 | 70.0099 | 110.7343 | 75.0418 | 28.1292 | 100 | 40
95
95 | 95 | 95 | 95 | 95 | 95 | 95 | 95 | 88.59980000000002 | 78.59980000000002 | 95 | 88.59980000000002 | 83.59980000000002 | 87.59980000000002 | 95 | 95 | 95 | 95 | 93.38580000000002 | 26.51500000000002 | -63.48499999999999 | -118.485
116.3798 | 141.6846 | 116.6945 | 132.4288 | 112.4706 | 45.59980000000002 | 50.59980000000002 | 11.59980000000002 | -6.400199999999984 | -16.40019999999998 | 13.59980000000002 | -6.400199999999984 | -11.40019999999998 | -7.400199999999984 | 57.59980000000002 | 27.59980000000002 | 2.609700000000018 | 18.34400000000002 | -1.614199999999983 | -68.48499999999999 | -63.48499999999999 | -118.485
So what I Need this to do is the following.
A3 needs to Show as 95
That’s shows me the Hours I have for the day. The Balance of 211-95 needs then be shifted to next day. So in affect the next Days hours become 236
So once again I then will need B3 to now show as 95 and the balance once again now shifts to [NAME] and so on. Until it gets to a point where I have less then 95 hours showing. This tells me what day
I will have capacity.
Does that help more ?
A2 (95) is a figure I need to be able to adjust sometimes.
Thanks
[NAME]
change A2
A3 will show 95 or whatever maximum hours (77+12=89) available in cell I3
what happens if you start to go negative? J6 should work 85 hours…shouldn’t it?
Spreadsheet: mary_fischer__25633__31P
Sheet: E-6.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 031P
COMPANY NAME    Limbach Holdings, Inc.
ANALYSIS OF PROPERTY, PLANT AND EQUIPMENT
FOR THE 3 MONTHS ENDED 03-31-2001
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-6
 |  | 12-31-2000 Balance |  |  |  |  |  | CHARGED TO I/S
 |  | DR/(CR.) |  |  |  | SALES AND OTHER |  |  |  |  |  |  |  | DETAIL OF |  | ENDING
[NAME] |  | BEGINNING |  | ADDITIONS |  | RETIREMENTS |  | DEPR |  | DEPL |  | OTHER |  | OTHER CHANGES |  | BALANCE
 |  | BALANCE |  | DR/(CR) |  | DR/(CR) |  | 1415 |  | 1416 |  | (List Below-A) |  | (List Below-B) |  | DR/(CR)
Natural Gas Transmission
Electric Generation & Distribution
Construction In Process
O & G Properties
Other
Gross PP & E
Accumulated DD & A
Net PP & E |  |  | * |  | ** |  | ** |  |  |  |  |  |  |  |  |  | *
 |  |  |  |  | ** Pertains to amounts related to normal |  |  |  |  |  |  | (A) |  | (B) | * | [NAME] TO
 |  |  |  |  | operations.  Unusual amounts should be shown |  |  |  |  |  |  |  |  |  |  | HYPERION LINE
 |  |  |  |  | under "Other Changes" with appropriate explanations. |  |  |  |  |  |  |  |  |  |  | NET_TOT_PPE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Asset/Exp  DR/(CR)
 |  |  |  |  |  |  | DETAIL OF OTHER CHANGES     (B)
 |  |  |  |  |  |  |  |  |  |  |  | PP & E |  | ACCUM |  | NET
CHARGED TO OTHER I/S ACCTS     (A) |  |  |  |  |  |  | KEY: |  |  |  |  | DR/(CR) |  | DR/(CR) |  | DR/(CR)
[NAME] |  | HYP ACCT CHGD |  | DR/(CR) |  |  | (PROVIDE DETAIL OF INDIVIDUAL ITEMS
 |  |  |  |  |  |  | IN EXCESS OF $200,000.)
 |  |  |  |  |  |  | (1) Reclassification between property
 |  |  |  |  |  |  | accounts (should net to -0-)
 |  |  |  |  |  |  | (2) Intercompany transfer
 |  |  |  |  |  |  | (list companies):
 |  | TOTAL
 |  |  |  |  |  |  | (3) Acquisition (disposition)
 |  |  |  |  |  |  | of business
 |  |  |  |  |  |  | (4) Foreign currency
 |  |  |  |  |  |  | translation adjustment
 |  |  |  |  |  |  | (5) Lease impairments -
 |  |  |  |  |  |  | Oil & Gas
 |  |  |  |  |  |  | (6) Other (detail):
 |  |  |  |  |  |  |  |  |  | TOTAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-6
Spreadsheet: 864507d1711645542-finding-completion-date-from-a-waterfall-production-schedule-car-production-schedule
Sheet: Schedule

Car Color |  | Schedule | 2024-03-28 00:00:00 | 2024-03-29 00:00:00 | 2024-04-01 00:00:00 | 2024-04-02 00:00:00 | 2024-04-03 00:00:00 | 2024-04-04 00:00:00 | 2024-04-05 00:00:00 | 2024-04-08 00:00:00 | 2024-04-09 00:00:00 | 2024-04-10 00:00:00 | 2024-04-11 00:00:00 | 2024-04-12 00:00:00 | 2024-04-15 00:00:00 | 2024-04-16 00:00:00 | 2024-04-17 00:00:00 | 2024-04-18 00:00:00 | 2024-04-19 00:00:00 | 2024-04-22 00:00:00 | 2024-04-23 00:00:00 | 2024-04-24 00:00:00 | 2024-04-25 00:00:00 | 2024-04-26 00:00:00
Red Car |  | Plan | Start | Continue | Continue | Continue | Complete
 | Serial #1 | Recovery |  | Start | Continue | Continue | Continue | Complete
Blue Car |  | Plan |  | Start | Continue | Continue | Continue | Complete
 | Serial #1 | Recovery
Green Car |  | Plan |  |  | Start | Continue | Continue | Continue | Complete
 | Serial #1 | Recovery |  | Start | Continue | Continue | Continue | Continue | Continue | Complete
[NAME] |  | Plan |  |  |  | Start | Continue | Continue | Continue | Complete
 | Serial #1 | Recovery |  |  |  |  |  | Start | Continue | Continue | Continue | Complete
Red Car |  | Plan |  |  |  |  | Start | Continue | Continue | Continue | Complete
 | Serial #2 | Recovery
Blue Car |  | Plan |  |  |  |  |  | Start | Continue | Continue | Continue | Complete
 | Serial #2 | Recovery
Green Car |  | Plan |  |  |  |  |  |  | Start | Continue | Continue | Continue | Complete
 | Serial #2 | Recovery
[NAME] |  | Plan |  |  |  |  |  |  |  | Start | Continue | Continue | Continue | Complete
 | Serial #2 | Recovery
Red Car |  | Plan |  |  |  |  |  |  |  |  | Start | Continue | Continue | Continue | Complete
 | Serial #3 | Recovery
Blue Car |  | Plan |  |  |  |  |  |  |  |  |  | Start | Continue | Continue | Continue | Complete
 | Serial #3 | Recovery
Green Car |  | Plan |  |  |  |  |  |  |  |  |  |  | Start | Continue | Continue | Continue | Complete
 | Serial #3 | Recovery
[NAME] |  | Plan |  |  |  |  |  |  |  |  |  |  |  | Start | Continue | Continue | Continue | Complete
 | Serial #3 | Recovery
Red Car |  | Plan |  |  |  |  |  |  |  |  |  |  |  |  | Start | Continue | Continue | Continue | Complete
 | Serial #4 | Recovery
Blue Car |  | Plan |  |  |  |  |  |  |  |  |  |  |  |  |  | Start | Continue | Continue | Continue | Complete
 | Serial #4 | Recovery
Green Car |  | Plan |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Start | Continue | Continue | Continue | Complete
 | Serial #4 | Recovery
[NAME] |  | Plan |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Start | Continue | Continue | Continue | Complete
 | Serial #4 | Recovery
etc.
Spreadsheet: 02c0c691-1990-43d8-9bd4-fb56d29c0b5d
Sheet: Sheet1

UTAH STATE OFFICE OF EDUCATION | Unnamed: 1 | Unnamed: 2
SCHOOL FINANCE & STATISTICS
[NAME] OF LOCAL EFFORT
FY08 PRE FINAL
USBE RULE R277-911-4
Pre Final |  | Current as of February 20, 2008
 | FY07 | FY08 MINIMUM
 | Audited | QUALIFYING
DISTRICT | ADD-ON ADM | EXPENDITURE*
 | GRADE 9-12 | @
 |  | 2514
 | (1) | (2)
01 ALPINE | 2428.392 | 6104977.488
02 BEAVER | 87.902 | 220985.628
03 BOX ELDER | 457.711 | 1150685.454
04 CACHE | 574.691 | 1444773.174
05 CARBON | 183.802 | 462078.228
06 DAGGETT | 7.601 | 19108.914
07 DAVIS | 3018.632 | 7588840.848
08 DUCHESNE | 151.219 | 380164.566
09 EMERY | 86.352 | 217088.928
10 GARFIELD | 73.915 | 185822.31
11 GRAND | 57.401 | 144306.114
12 GRANITE | 2803.455 | 7047885.87
13 IRON | 279.096 | 701647.344
14 JORDAN | 3672.946 | 9233786.243999999
15 [NAME] | 75.394 | 189540.516
16 KANE | 71.089 | 178717.746
17 MILLARD | 176.949 | 444849.786
18 MORGAN | 94.114 | 236602.596
19 NEBO | 1171.811 | 2945932.854
20 N SANPETE | 102.039 | 256526.046
21 N SUMMIT | 51.74 | 130074.36
22 PARK CITY | 106.657 | 268135.698
23 PIUTE | 19.783 | 49734.462
24 RICH | 12.304 | 30932.256
25 SAN JUAN | 181.462 | 456195.468
26 SEVIER | 280.171 | 704349.894
27 S SANPETE | 98.425 | 247440.45
28 S SUMMIT | 72.47 | 182189.58
29 TINTIC | 4.802 | 12072.228
30 TOOELE | 632.335 | 1589690.19
31 UINTAH | 269.616 | 677814.624
32 WASATCH | 226.194 | 568651.716
33 WASHINGTON | 1033.966 | 2599390.524
34 WAYNE | 36.509 | 91783.626
35 WEBER | 1759.367 | 4423048.638
36 SALT LAKE | 951.325 | 2391631.05
37 OGDEN | 501.732 | 1261354.248
38 PROVO | 791.58 | 1990032.12
39 LOGAN | 128.929 | 324127.506
40 MURRAY | 354.166 | 890373.324
CHARTER SCHOOLS:
[NAME] | 47.178 | 118605.492
A3  DAVINCI ACADEMY | 3.878 | 9749.292
A5  ITINERIS | 29.693 | 74648.202
A8  EAST HOLLYWOOD | 12.003 | 30175.542
1B  UCAS | 26.244 | 65977.416
2C  INTECH | 13.917 | 34987.338
86  PINNACLE CANYON | 2.378 | 5978.292
90  TUACAHN HS | 10.346 | 26009.844
TOTAL | 23233.681 | 58409474.03399999
*The amount in column 2 must be expended in order to earn State [NAME] funds.  All State CTE Funds are
RESTRICTED funds.  For calculation purposes, the  amount in column 4 shall not include State Add-On, State
Set-Aside, and Federal funds.
Spreadsheet: 61513d1262385213-conditional-if-to-be-used-for-filling-in-text-sample1
Sheet: Customers

J456 | Johns Cabinets | [NAME] | [PHONE] | [PHONE] | 456 Main Street | Largo, FL 33770
J999 | Jims Cabinets | [NAME] | [PHONE] | [PHONE] | 457 Elm Street | Tampa, FL 33771
K789 | [NAME]'s [NAME] | Kenny | [PHONE] | [PHONE] | 777 [NAME] | Leesburg, FL 34748
J456 | Johns Cabinets | [NAME] | [PHONE] | [PHONE] | 456 Main Street | Largo, FL 33770
J999 | Jims Cabinets | [NAME] | [PHONE] | [PHONE] | 457 Elm Street | Tampa, FL 33771
K789 | [NAME]'s [NAME] | Kenny | [PHONE] | [PHONE] | 777 [NAME] | Leesburg, FL 34748
Spreadsheet: 468811d1467589510-index-match-with-multiple-criteria-index_match
Sheet: MAIN FILE

 |  |  | Year
 | Ticker | Items | 2010 | 2011 | 2012 | 2013 | 2014
 | ABBANK | Sales | 500 | 550 | 605 | 665.5
 | ABBANK | Total Assets | 1000 | 1080 | 1166.4 | 1259.712
 | ABBANK | Total Equity | 600 | 642 | 686.94 | 735.0258000000001
 | ALARABANK | Sales | 822 | 904.2 | 994.6200000000001 | 1094.082 | 1180
 | ALARABANK | Total Assets | 2500 | 2725 | 2970.25 | 3237.5725 | 4000
 | ZAHEENSPIN | Sales | 1500 | 1650 | 1815 | 1996.500000000001
Spreadsheet: 35740d1233348699-conditional-average-using-if-possible-for-forum
Sheet: P&L Expenses

Additional Expenses
P&L Expenses |  |  |  |  |  |  |  | Capital Expenses
 |  |  |  | Date | Amount | Running |  |  |  |  |  |  | Amount | Running
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
TOTAL |  |  |  | 0 |  |  |  | TOTAL |  |  |  | 0
Spreadsheet: 06c1fce4-7a71-433a-9ad2-e6e5fd526164
Sheet: MAWA and ETWU

Maximum Applied Water Allowance (MAWA) & Estimated Total Water Use (ETWU) for New and Rehabilitated Landscapes in Hillsborough
Hydrozone |  | Hydrozone Area (HA) (ft2) | Plant Factor3 (PF) | Plant Water Use Type | PF x HA (ft2)
 | Zone 1
 | Zone 2
 | Zone 3
 | Zone 4
 | Zone 5
 | Zone 6
 | Zone 7
 | Zone 8
 | Zone 9
 | Zone 10
 | Zone 11
 | Zone 12
 | Zone 13
 | Zone 14
 | Zone 15
 | Zone 16
 | Zone 17
 | Zone 18
 | Zone 19
 | Zone 20
 | Zone 21
 | Hydrozone Area (HA) (& PF x HA)
 | Special Landscape Area (SLA) |  | 1
 | Total Landscape Area (TLA)
Irrigation Efficiency (IE) |  | 0.71
 |  |  | MAWA1 = |  | gal.
 |  |  |  |  | [NAME].
 |  |  |  |  | HCF
 |  |  |  |  | acre-ft.
 |  |  |  |  | millions of gal.
 |  |  | ETWU2 = |  | gal.
 |  |  |  |  | [NAME].
 |  |  |  |  | HCF
 |  |  |  |  | acre-ft.
 |  |  |  |  | millions of gal.
3Plant Water Use Types | Plant Factor
Low | 0 - 0.3
Medium | 0.4 - 0.6 | 1(ETo) x (0.62) x [(0.7 x HA)+(0.3 x SLA)], where ETo = 44.24
High | 0.7 - 1.0 | 2(ETo) x (0.62) x [(PF x HA/IE) + SLA]
Calculator based on California Dept. of Water Resources "Water Budget Workbook" Beta v. 1.0, Dec. 17, 2009
44.24 | Eto
0.71 | IE Default
0 | Eppt
Spreadsheet: 97217d1296463520-access-grouped-cells-from-formula-copy-of-example
Sheet: Tabelle1

Example to tread 'access grouped cells from formula'
cost familiy |  |  |  |  |  |  | external support | external support | external support | external support | internal support
cost unit | Machine Type A | Machine Type B | Machine Type C | Machine Type D | Instruction | Meeting | Machine Type A | Machine Type B | Machine Type C | Machine Type D | Machine Type A | Machine Type B | Machine Type C | Machine Type D
cost unit code | 300 | 301 | 302 | 303 | 304 | 305 | 400 | 401 | 402 | 403 | 500 | 501 | 502 | 503
cost unit and family
control row
Spreadsheet: 836636d1689557946-create-a-new-column-that-renames-top-6-ranks-sample_top_v1
Sheet: Sheet1

Department | Id | Emp_Name | Flag | Rank | New_Column1 | New_Column2
Food | 101 | [NAME] | Low | 763 | Low | Low
Food | 101 | [NAME] | Low | 726 | Low | Low
Food | 101 | [NAME] | Low | 709 | Low | Low
Food | 101 | [NAME] | Low | 692 | Low | Low
Food | 101 | [NAME] | Low | 642 | Low | Low
Food | 101 | [NAME] | Low | 606 | Low | Low
Food | 101 | [NAME] | High | 554 | Top 6 | High
Food | 101 | [NAME] | Low | 492 | Low | Low
Food | 101 | [NAME] | High | 450 | Top 6 | Low
Food | 101 | [NAME] | Low | 450 | Low | Low
Beauty | 101 | [NAME] | Low | 821 | Low | Low
Beauty | 101 | [NAME] | Low | 791 | Low | Low
Beauty | 101 | [NAME] | Low | 585 | Low | Low
Beauty | 101 | [NAME] | High | 563 | Top 6 | Top 6
Beauty | 101 | [NAME] | Low | 471 | Low | Low
Beauty | 101 | [NAME] | Low | 419 | Low | Low
Hardware | 101 | [NAME] | High | 104 | Top 6 | Top 6
Hardware | 101 | [NAME] | High | 94 | Top 6 | Top 6
Hardware | 101 | [NAME] | High | 72 | Top 6 | Top 6
Hardware | 101 | [NAME] | High | 15 | Top 6 | Top 6
Hardware | 101 | [NAME] | High | 10 | Top 6 | Top 6
Hardware | 101 | [NAME] | High | 6 | Top 6 | Top 6
Hardware | 101 | [NAME] | Low | 3 | Low | Low
Hardware | 101 | [NAME] | Low | 2 | Low | Low
Food | 102 | [NAME] | High | 292 | Top 6 | Top 6
Food | 102 | [NAME] | High | 260 | Top 6 | Top 6
Food | 102 | [NAME] | Low | 255 | Low | Low
Food | 102 | [NAME] | Low | 239 | Low | Low
Food | 102 | [NAME] | High | 221 | Top 6 | Top 6
Food | 102 | [NAME] | High | 100 | Top 6 | Top 6
Food | 102 | [NAME] | High | 91 | Top 6 | Top 6
Spreadsheet: 803168d1667298284-count-unique-occurances-with-2-columns-of-data-system-org-etaf-2
Sheet: Sheet1

sysetm | org |  | System | 1 |  |  | sysetm | 1
4 | ORG1
1 | ORG2 |  |  |  |  |  | Row Labels | Sum of sysetm
2 | ORG3 |  | UNIQUE |  |  |  | ORG11 | 1
3 | ORG4 |  |  | ORG2 |  |  | ORG14 | 1
1 | ORG5 |  | 1 | ORG5 |  |  | ORG17 | 1
2 | ORG6 |  | 1 | ORG8 |  |  | ORG2 | 1
3 | ORG7 |  | 1 | ORG11 |  |  | ORG5 | 1
1 | ORG8 |  | 1 | ORG14 |  |  | ORG8 | 1
2 | ORG9 |  | 1 | ORG17 |  |  | Grand Total | 6
3 | ORG10
1 | ORG11
2 | ORG12
3 | ORG13
1 | ORG14
2 | ORG15
3 | ORG16
1 | ORG17
2 | ORG18
3 | ORG19
4 | ORG20
Spreadsheet: 709739d1608538969-how-to-find-the-maximum-value-of-the-last-6-consecutive-days-without-spaces-example2014
Sheet: Sheet1

[NAME] | 2020-12-01 00:00:00 | 2020-12-02 00:00:00 | 2020-12-03 00:00:00 | 2020-12-04 00:00:00 | 2020-12-05 00:00:00 | 2020-12-06 00:00:00 | 2020-12-07 00:00:00 | 2020-12-08 00:00:00 | 2020-12-09 00:00:00 | 2020-12-10 00:00:00 | 2020-12-11 00:00:00 | 2020-12-12 00:00:00 | 2020-12-13 00:00:00 | 2020-12-14 00:00:00 | 2020-12-15 00:00:00 | 2020-12-16 00:00:00 | 2020-12-17 00:00:00 | 2020-12-18 00:00:00 | 2020-12-19 00:00:00 | 2020-12-20 00:00:00 | 2020-12-21 00:00:00 | 2020-12-22 00:00:00 | 2020-12-23 00:00:00 | 2020-12-24 00:00:00 | 2020-12-25 00:00:00 | 2020-12-26 00:00:00 | 2020-12-27 00:00:00 | 2020-12-28 00:00:00 | 2020-12-29 00:00:00 | 2020-12-30 00:00:00 | 2020-12-31 00:00:00
22241.642 |  | 26275.43 | 100000 | 21553.257 |  | 25152.349 | 27083.554 | 25429.122 | 18790.425 | 19480.144 | 17561.242 | 22241.642 | 21808.236 | 22056.135
34690.466 | 49427.071 | 45857.486 | 41551.494 | 39839.34 |  |  | 46029.191 | 48668.461 | 36961.393 | 34507.729 | 31460.845 | 30667.831 | 31876.037 | 34445.296 | 34690.466
19 | 345 | 12 | 4 |  | 19 | 3 | 5 | 15 | 12 | 18 |  | 2 | 4 | 9
22241.642
34690.466
19
22241.642
34507.729
19
22241.642
34690.466
19
Spreadsheet: 53126d1253048657-vlookup-filtered-rows-comparing-and-matching-filtered-rows
Sheet: Desired Result

[NAME] In This Example
Name of Food |  | Days In Freezer
Beans |  | 3
Tomatoes |  | 1 |  | It should not be listing the 1 in this row
Carrots
Salad |  | 5
Celery
Actual Desired Result
Name of Food |  | Days In Freezer
Beans |  | 3
Tomatoes
Carrots
Salad |  | 5
Celery
Spreadsheet: 782711d1654192013-sumproduct-with-multiple-criteria-sumproduct-with-multiple-criteria
Sheet: Sheet1

2022-06-01 00:00:00 |  |  |  |  |  | Correct Values
JOB | Welding | Painting | Operation 101-108 | Operation 202&203 |  | Welding | Painting | Operation 101-108 | Operation 202&203
H111A1 |  |  |  |  |  | 1.779 | 5.266 | 3.724 | 2.842
H222B1 |  |  |  |  |  | 5.484 |  | 0.839 | 9.338
H333A1 |  |  |  |  |  | 0.1 | 0.573 |  | 2.487
 |  |  |  |  |  | Date | Operation | Job | Operation2 | MT
 |  |  |  |  |  | 2022-06-01 00:00:00 | Welding | H111A1 | 101 | 0.583
 |  |  |  |  |  | 2022-06-01 00:00:00 | Welding | H111A1 | 102 | 0.764
 |  |  |  |  |  | 2022-06-01 00:00:00 | Welding | H111A1 | 201 | 0.432
 |  |  |  |  |  | 2022-06-01 00:00:00 | Fabrication | H111A1 | 202 | 2.842
 |  |  |  |  |  | 2022-06-01 00:00:00 | Welding | H222B1 | 202 | 4.645
 |  |  |  |  |  | 2022-06-01 00:00:00 | Clearing | H222B1 | 202 | 4.693
 |  |  |  |  |  | 2022-06-01 00:00:00 | Welding | H222B1 | 101 | 0.839
 |  |  |  |  |  | 2022-06-01 00:00:00 | Welding | H333A1 | 202 | 0.1
 |  |  |  |  |  | 2022-06-01 00:00:00 | Shearing | H333A1 | 203 | 2.387
 |  |  |  |  |  | 2022-06-01 00:00:00 | Painting | H111A1 | 205 | 2.889
 |  |  |  |  |  | 2022-06-01 00:00:00 | Painting | H111A1 | 104 | 2.377
 |  |  |  |  |  | 2022-06-01 00:00:00 | Punching | H333A1 | 109 | 0.067
 |  |  |  |  |  | 2022-06-01 00:00:00 | Painting | H333A1 | 111 | 0.127
 |  |  |  |  |  | 2022-06-01 00:00:00 | Painting | H333A1 | 120 | 0.446
Spreadsheet: 749071d1632493516-sort-by-column-in-one-sheet-and-maintain-row-formula-references-in-another-sheet-test-metrics
Sheet: Jan

ISP | Hours Worked | Avg. ACD Talk Time | Auto-In Calls | Top Line Calls | Outbound Calls | Total Calls | Avg. Calls/Hour | ISP Emails | Clearslide Email Campaigns | Avg. Emails/Hour | Webinars Conducted | SF Leads Created | Avg. Hourly Work Volume | SF Tasks w/out Clearslide | SF Opp. | Total SF | Avg. SF/Hour | Clearslide Emails Sent | Total Contacts | Avg. Contacts/Hour
a | 144.5 | 02:33:00 | 95 | 46 | 75 |  |  | 100 | 0 |  | 0 | 14 |  | 305 | 50 |  |  | 0
b | 153.5 | 04:24:00 | 91 | 100 | 142 |  |  | 125 | 0 |  | 6 | 4 |  | 387 | 31 |  |  | 0
c | 156 | 05:39:00 | 59 | 135 | 74 |  |  | 150 | 0 |  | 0 | 0 |  | 52 | 29 |  |  | 0
Spreadsheet: 177868d1346483563-want-to-get-highest-sales-qty-and-sales-person-name-within-specified-dates-devawad_855749_31aug12_01
Sheet: Sheet1

Sales person | Date | Product | Qty |  | Helper Column
[NAME] | 2012-08-01 00:00:00 | Pen | 10
[NAME] | 2012-08-02 00:00:00 | Pen | 10
Leo | 2012-08-02 00:00:00 | Pen | 20
Ram | 2012-08-02 00:00:00 | Pen | 15
Leo | 2012-08-03 00:00:00 | Pen | 15
Ravi | 2012-08-04 00:00:00 | Pen | 10
[NAME] | 2012-08-05 00:00:00 | Pen | 15
Ram | 2012-08-06 00:00:00 | Pen | 5
Leo | 2012-08-07 00:00:00 | Pen | 5
[NAME] | 2012-08-08 00:00:00 | Pen | 20
I want formula which will give highest sales qty of pen within specified dates and the name of sales person
 |  | Qty ? | Sale person name ?
2012-08-01 00:00:00 | 2012-08-08 00:00:00
Example - | [NAME] has sold total 55 pen so 55 should come in cell C15 and [NAME] name should come in D15
Spreadsheet: 129445d1321618263-keeping-the-row-the-same-but-changing-the-column-when-dragging-a-formula-down-holidayexample
Sheet: 2012

Resource | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00 | Planned | Alloc | Rem
a | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 |  | -4
b | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 |  | -4
c | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
d | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
e | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
f | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
g | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
h | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
i | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
j | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
k | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
l | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
m | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
Spreadsheet: 171469d1343746821-sum-column-look-up-weekly-sales
Sheet: Sheet1

 |  |  | lw | pw |  |  |  | lw | pw
 |  | 5 | 8 | 10 | 55 | 60
 |  | 9 | 50 | 12 | 33 | 40
 |  | 6 | 6 | 85 | 21 | 12
 |  | 3 | 3 | 10 | 10 | 10