tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 178670d1346866616-if-column-b-says-1234-xyz-then-column-o-will-return-this-for-example-nsh
Sheet: NSH.xls

 |  | ALPHA INSUL & WTRPRFG - NSH |  |  |  |  |  | Follow Up
 |  | ** Aged Trial Balance By Job ** |  |  |  |  |  | Balance
 |  | Thru Month Ending: 07/31/2012 |  |  |  |  |  | On Account
 |  | Aged through: 07/31/2012 |  |  |  |  |  | Reverse
 |  | All Accounts
Customer | Job Description | All Customers
Customer Number | Date | Total Due | 0-30 Days | 31-60 Days | 61-90 Days | Over 90 | Retention | Pay Date | Pay Amount | Job Complete | Project Completion | 1st 5% Billed | 2nd 5% Billed | Notes
68506 FELL/SPARK, JV, (GC) (555) 555-5555
1000 MUSIC CITY CENTER |  |  |  |  |  |  |  |  |  |  |  |  |  | Moved to NSH #1000
49 | 2012-06-30 00:00:00 | 10458.93 | 0 | 10458.93 | 0 | 0 | 0
RETN | 2012-01-20 00:00:00 | 12588.07 | 0 | 0 | 0 | 0 | 12588.07
13925 | 2012-01-24 00:00:00 | 5248.25 | 0 | 0 | 0 | 5248.25 | 0
14150 | 2012-03-21 00:00:00 | 5781.25 | 0 | 0 | 0 | 5781.25 | 0
14151 | 2012-04-19 00:00:00 | 6822.9 | 0 | 0 | 0 | 6822.9 | 0
14153 | 2012-05-30 00:00:00 | 8927.73 | 0 | 0 | 8927.73 | 0 | 0
14154 | 2012-07-30 00:00:00 | 1801.35 | 1801.35 | 0 | 0 | 0 | 0
14156 | 2012-06-18 00:00:00 | 14468.75 | 0 | 14468.75 | 0 | 0 | 0
14159 | 2012-07-16 00:00:00 | 8125 | 8125 | 0 | 0 | 0 | 0
14161 | 2012-07-23 00:00:00 | 2780.06 | 2780.06 | 0 | 0 | 0 | 0
 | Job Totals: | 77002.29 | 12706.41 | 24927.68 | 8927.73 | 17852.4 | 12588.07
 | Customer Totals: | 77002.29 | 12706.41 | 24927.68 | 8927.73 | 17852.4 | 12588.07
28508 CHAPEL STONE, [NAME]  (555) 555-5555
1020 BUILDING 3 |  |  |  |  |  |  |  |  |  |  |  |  |  | Moved to BHAM #1000
14157 | 2012-07-16 00:00:00 | 4775 | 4775 | 0 | 0 | 0 | 0
 | Job Totals: | 4775 | 4775 | 0 | 0 | 0 | 0
 | Customer Totals: | 4775 | 4775 | 0 | 0 | 0 | 0
68515 DUNLAN COMPANY, (GC) (555) 555-5555
1014 PROJECT RANGO |  |  |  |  |  |  |  |  |  |  |  |  |  | Moved to NSH #1001
36 | 2012-05-30 00:00:00 | 182118.8 | 0 | 0 | 182118.8 | 0 | 0
55 | 2012-06-30 00:00:00 | 46056 | 0 | 46056 | 0 | 0 | 0
68 | 2012-07-31 00:00:00 | 12175.2 | 12175.2 | 0 | 0 | 0 | 0
RETN | 2012-05-30 00:00:00 | 12650 | 0 | 0 | 0 | 0 | 12650
14163 | 2012-07-30 00:00:00 | 29316 | 29316 | 0 | 0 | 0 | 0
 | Job Totals: | 282316 | 41491.2 | 46056 | 182118.8 | 0 | 12650
 | Customer Totals: | 282316 | 41491.2 | 46056 | 182118.8 | 0 | 12650
68511 BOX HEPP (GC), (555) 555-5555
1017 MED CLINIC - PH2 |  |  |  |  |  |  |  |  |  |  |  |  |  | Moved to BHAM #1001
54 | 2012-06-30 00:00:00 | 1900 | 0 | 1900 | 0 | 0 | 0
62 | 2012-07-30 00:00:00 | 17569.3 | 17569.3 | 0 | 0 | 0 | 0
RETN | 2012-04-30 00:00:00 | 1289.8 | 0 | 0 | 0 | 0 | 1289.8
 | Job Totals: | 20759.1 | 17569.3 | 1900 | 0 | 0 | 1289.8
 | Customer Totals: | 20759.1 | 17569.3 | 1900 | 0 | 0 | 1289.8
Spreadsheet: 781310d1653207655-help-with-determining-the-right-formula-to-use-sample-worksheet
Sheet: Data Validation 

Happy Hour |  |  |  |  |  | Method of Payment
Yes |  |  |  |  |  | [NAME]
No |  |  |  |  |  | Cash
 |  |  |  |  |  | [NAME]
Drink
Beer (Can)
Draft Beer |  |  |  |  |  | Guest/Room
Coca Cola |  |  |  |  |  | Room 2
Coke Light |  |  |  |  |  | Room 3
Coke Zero |  |  |  |  |  | Room 4
Sprite |  |  |  |  |  | Room 5
7Up |  |  |  |  |  | Room 6
[NAME] |  |  |  |  |  | Room 7
Tonic Water |  |  |  |  |  | Room 8
[NAME] |  |  |  |  |  | Room 9
Orange Juice |  |  |  |  |  | Room 10
Pineapple Juice |  |  |  |  |  | Room 11
Apple Juice |  |  |  |  |  | Outside Guest 1
[NAME] |  |  |  |  |  | Outside Guest 2
House Whisky with mixer |  |  |  |  |  | Outside Guest 3
House Vodka & mixer |  |  |  |  |  | Outside Guest 4
House Gin & mixer |  |  |  |  |  | Outside Guest 5
House Rum & mixer |  |  |  |  |  | Table 1
[NAME] with mixer |  |  |  |  |  | Table 2
[NAME] shot |  |  |  |  |  | Table 3
PASTIS with Coke |  |  |  |  |  | Table 4
[NAME] with mixer
Gordons & mixer
Bombay & Mixer
Stoli & Mixer
[NAME]
Mocktail JRP
Mocktail Mojito
[NAME]
Blue hawaiian mocktail
Virgin sunrise
[NAME]
Jamesons with mixer
Hendricks with mixer
[NAME]
[NAME]
Sangria glass
White Wine
[NAME]
Red Wine
Grey Goose & Mixer
Glenfiddich with mixer
[NAME]
Mojito
Old Fashioned
Dark n Stormy
Antiqua rum punch
Jamican rum punch
Blue Lagoon
[NAME]
[NAME]
Vodka sour
Vodka sunrise
Long Island Ice Tea
[NAME]
Blue Hawaiian
Sangria jug
Spreadsheet: 27940d1221674593-commission-schedule-book1
Sheet: Sample

 |  |  | Total Fee Credit
 |  |  | Q1 | Q2 | Q3 | Q4 | Total
 |  | New Business | 54023.06 | 52137.32 | 28145.45 | 0 | 134305.83
 |  |  | 0 | 0 | 0 | 0 | 0
 |  | Quarterly Totals | 54023.06 | 52137.32 | 28145.45 | 0 | 134305.83
Cumulative Total Fees YTD: |  |  | 54023.06 | 106160.38 | 134305.83 | 134305.83 | 134305.83
 |  |  | [NAME] |  | Award %
 |  |  |  | 0 | 0
 |  |  | 0 | 49999 | 0.05
 |  |  | 50000 | 99999 | 0.1
 |  |  | 100000 | 149999 | 0.15
 |  |  | 150000 | 199999 | 0.2
 |  |  | 200000 | 249999 | 0.25
 |  |  | 250000 | 299999 | 0.3
 |  |  | 300000 | 300000 | 0.35
 |  |  | Q1 | Q2 | Q3 | Q4 |  | YTD Incentive Total
Quarterly Incentive to be Paid: |  |  | 5402.306 | 5213.732 | 1407.2725 | 0
Cumulative Incentive: |  |  | 5402.306 | 10616.038 | 12023.3105 | 12023.3105
Spreadsheet: 798278d1664392310-max-value-formula-calculating-pay-range-maxvalueformula-etaf
Sheet: Calculator

 |  |  |  |  |  |  |  | [NAME] in this column
Employee ID | Provider | Specialty | APP Licensure Date | Hire Date | Specialty | Years of Experience | Current Rate | Calculated Rate
11111 | Name |  | 2001-01-01 00:00:00 | 00:00:00 | Medical Based Includes Inpatient Work | 2.5 | 57.2 |  | Answer should be $57.20 because the lookup table came bck with $51.51
2222 | [NAME] |  | 2001-01-02 00:00:00 | 00:00:00 | Surgical Salary Based Includes Inpatient Work | 21.5 | 52.63 |  | Answer should be $68.41 because the maximum pay range of this specialty is $68.41.
 |  |  |  |  | Surgical Salary Based Includes Inpatient Work
Looking for a formula that looks up the specialty and the years of experiences and then compares the value that it gates from the lookup table and compares to current rate and gives me the [NAME] value, or the higher of the 2
Spreadsheet: 26647a9f-a009-41a3-a0d8-d9c8e0d414cf
Sheet: Calculations

 | Current Asset & Liability Analysis
 |  | Current Ratio |  | 1st row
 |  | [NAME] |  | 2nd row
 |  | Cash Ratio |  | 3rd row
 |  | Working Capital |  | 4th row
 | Hide Input Cells
 | I1 |  |  | I1
 | I2 |  |  | I2
 | I3 |  |  | I3
 | I4 |  |  | I4
 | I5 |  |  | I5
 | I6 |  |  | I6
 | I7 |  |  | I7
 | I1 |  |  | I1
 | I2 |  |  | I2
 | I3 |  |  | I3
 | I4
 | I5
 | I6
 | I1
 | I2
 | I3
 | I4
Spreadsheet: 736681d1623798416-find-records-based-on-their-rating-rating
Sheet: Sheet1

Record number | Rating
111 | 4
112 | 6
113 | 9
114 | 8
115 | 7
116 | 5
117 | 9
118 | 10
119 | 8
120 | 6
Record with rating of <=7
Spreadsheet: 6f9ed038-4ce6-4062-b604-60e79f477edc
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
42309988 | 2014-07-15 11:42:48 | ALLIES | 1 | 7 | 4 | 1198315 | Tibor_Mars1 | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
42310061 | 2014-07-15 11:57:09 | AXIS | 0 | 4 | 7 | 1198315 | Tibor_Mars1 | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
42324250 | 2014-07-16 12:46:00 | ALLIES | 0 | 5 | 10 | 1605408 | player1605408 | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
42324422 | 2014-07-16 13:08:02 | AXIS | 0 | 4 | 10 | 1605408 | player1605408 | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
42391356 | 2014-07-21 11:45:16 | ALLIES | 0 | 4 | 7 | 1575000 | [NAME] | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
42391493 | 2014-07-21 12:02:27 | AXIS | 1 | 7 | 3 | 1575000 | [NAME] | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
42396380 | 2014-07-21 20:18:26 | ALLIES | 1 | 7 | 4 | 1351059 | misterfunny | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
42396659 | 2014-07-21 20:28:34 | AXIS | 1 | 7 | 2 | 1351059 | misterfunny | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
42405541 | 2014-07-22 11:22:43 | ALLIES | 1 | 7 | 4 | 1542223 | guy.warmoes | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
42405633 | 2014-07-22 11:42:54 | AXIS | 1 | 7 | 5 | 1542223 | guy.warmoes | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
42420253 | 2014-07-23 13:41:56 | ALLIES | 1 | 7 | 5 | 1388575 | Shocking Blue | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
42420424 | 2014-07-23 13:51:09 | AXIS | 1 | 7 | 3 | 1388575 | Shocking Blue | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
42434141 | 2014-07-24 14:32:05 | AXIS | 0 | 2 | 6 | 707319 | GR50 | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
42434336 | 2014-07-24 14:56:34 | ALLIES | 0 | 4 | 6 | 707319 | GR50 | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
42446021 | 2014-07-25 11:26:06 | ALLIES | 0 | 5 | 7 | 780030 | keithdone | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
42451582 | 2014-07-25 21:25:32 | ALLIES | 1 | 7 | 3 | 225841 | sacas | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
42451734 | 2014-07-25 21:39:54 | AXIS | 1 | 7 | 4 | 225841 | sacas | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
42477020 | 2014-07-27 18:22:55 | ALLIES | 0 | 6 | 7 | 492220 | Ronpo | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
42477201 | 2014-07-27 18:35:59 | AXIS | 0 | 4 | 7 | 492220 | Ronpo | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
Spreadsheet: eric_saibi__9846__100801
Sheet: James H Miller 01

Owner Name | Alabama Power Company
Station Name | [NAME]
Unit Name | [NAME] 01
NERC Region | SERC
State | AL
Fuel Type | Coal
Capacity | 706 MW
Start Date | 2001-10-04 00:00:00
End Date | 2001-12-12 00:00:00
Prv. Start Date | 2001-12-29 00:00:00
Prv. End Date | 2001-02-01 00:00:00
Comments | SCR Work
SIC | 4911
Plant ID | 1006764
Unit ID | 1006904
Outage ID | 17611
Spreadsheet: 845442d1696958217-mark-date-red-helkama-bica-2023
Sheet: Sheet1

NN MultiTool |  | Kund: | Helkama Bica
[NAME] , 10600 Ekenäs
[PHONE]
FO-Nummer 2174260
Servicepunkt / Ägare | Brand | Type | Cons.Year | Expiration | Gran/Serv | 1 or 2 Years | Remarks | Next Check | Price
 | Presto | P12 | 2016-01-01 00:00:00 |  | G | 2024
 |  |  | 2023-10-01 00:00:00 |  |  | 2024
 |  |  | 2021-10-05 00:00:00 |  |  | 2025
 |  |  |  |  |  | 2024
 |  |  |  |  |  | 2024
 |  |  |  |  |  | 2024
 |  |  |  |  |  | 2024
 |  |  |  |  |  | 2024
 |  |  |  |  |  | 2024
 |  |  |  |  |  | 2024
 |  |  |  |  |  | 2024
 |  |  |  |  |  | 2024
Granskare: |  |  |  |  |  |  |  | Totalt Euro
Underskrift:
Datum:
NN MultiTool |  | Kund:
[NAME] , 10600 Ekenäs
[PHONE]
FO-Nummer 2174260
Servicepunkt / Ägare | Märke | [NAME] | Tillverkningsår | Går Ut | Granskning | Service | Anmärkningar | [NAME] | [NAME]
 |  |  | 2013-07-01 00:00:00 |  |  |  |  | 2019
 |  |  | 2023-10-01 00:00:00
Granskare: |  |  |  |  |  |  |  | Totalt Euro
Underskrift:
Datum:
Spreadsheet: joe_parks__14526__Capacity_rates
Sheet: VNG Open Bid

VNG TETCO Capacity |  |  |  |  |  |  |  |  |  |  |  |  |  | VNG CNG Capacity
November 1997
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | Commodity | Demand
 |  |  |  |  | NYMEX + | CNG | NYMEX + |  |  |  |  | Nov-Oct |  | 1997-11-01 00:00:00 | 0.14 | 0.032
 | NYMEX | Basis | Commodity | Fuel | Variable | Basis | Basis | Demand | Volume | Cost |  | Demand |  | 1997-12-01 00:00:00 | 0.19 | 0.032
M1 | 2.259 | 0.02 |  | 0.0306 |  | 0.45 |  |  | 2061 |  |  |  |  | 1998-01-01 00:00:00 | 0.19 | 0.032
ELA | 2.259 | -0.025 |  | 0.0469 |  | 0.45 |  |  | 2818 |  |  |  |  | 1998-02-01 00:00:00 | 0.16 | 0.032
WLA | 2.259 | -0.03 |  | 0.0499 |  | 0.45 |  |  | 1548 |  |  |  |  | 1998-03-01 00:00:00 | 0.11 | 0.032
ETX | 2.259 | -0.16 |  | 0.047 |  | 0.45 |  |  | 987 |  |  |  |  | 1998-04-01 00:00:00 | 0.08 | 0.032
STX | 2.259 | -0.16 |  | 0.0567 |  | 0.45 |  |  | 2825 |  |  |  |  | 1998-05-01 00:00:00 | 0.05 | 0.032
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1998-06-01 00:00:00 | 0.05 | 0.032
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1998-07-01 00:00:00 | 0.05 | 0.032
December 1997 - March 1998 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1998-08-01 00:00:00 | 0.05 | 0.032
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1998-09-01 00:00:00 | 0.05 | 0.032
 |  |  |  |  | NYMEX + | CNG | NYMEX + |  |  |  |  |  |  | 1998-10-01 00:00:00 | 0.05 | 0.032
 | NYMEX | Basis | Commodity | Fuel | Variable | Basis | Basis | Demand | Volume | Cost
M1 |  | 0.02 |  | 0.0397 |  | 0.45 |  |  | 2061 |  |  |  |  | Average
ELA |  | -0.025 |  | 0.0592 |  | 0.45 |  |  | 2818
WLA |  | -0.03 |  | 0.0635 |  | 0.45 |  |  | 1548
ETX |  | -0.16 |  | 0.0592 |  | 0.45 |  |  | 987
STX |  | -0.16 |  | 0.0734 |  | 0.45 |  |  | 2825 |  |  |  |  | Combined TETCO & CNG
 |  |  |  |  |  |  |  |  |  |  |  |  |  | CNG only
April 1998 - October 1998
 |  |  |  |  | NYMEX + | CNG | NYMEX +
 | NYMEX | Basis | Commodity | Fuel | Variable | Basis | Basis | Demand | Volume | Cost
M1 |  | 0 |  | 0.0306 |  |  |  |  | 2061
ELA |  | -0.045 |  | 0.0469 |  |  |  |  | 2818
WLA |  | -0.055 |  | 0.0499 |  |  |  |  | 1548
ETX |  | -0.1 |  | 0.047 |  |  |  |  | 987
STX |  | -0.1 |  | 0.0567 |  |  |  |  | 2825
 |  |  |  |  |  |  |  |  |  |  | 0.01
Spreadsheet: 138635d1327773463-sum-data-with-criterias-conditional-sum
Sheet: Sheet1

 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 5 | 5 | 5 | 5 | 5 | 5 | 5
 |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue
Bay | Criteria | 2012-01-01 00:00:00 | 2012-01-02 00:00:00 | 2012-01-03 00:00:00 | 2012-01-04 00:00:00 | 2012-01-05 00:00:00 | 2012-01-06 00:00:00 | 2012-01-07 00:00:00 | 2012-01-08 00:00:00 | 2012-01-09 00:00:00 | 2012-01-10 00:00:00 | 2012-01-11 00:00:00 | 2012-01-12 00:00:00 | 2012-01-13 00:00:00 | 2012-01-14 00:00:00 | 2012-01-15 00:00:00 | 2012-01-16 00:00:00 | 2012-01-17 00:00:00 | 2012-01-18 00:00:00 | 2012-01-19 00:00:00 | 2012-01-20 00:00:00 | 2012-01-21 00:00:00 | 2012-01-22 00:00:00 | 2012-01-23 00:00:00 | 2012-01-24 00:00:00 | 2012-01-25 00:00:00 | 2012-01-26 00:00:00 | 2012-01-27 00:00:00 | 2012-01-28 00:00:00 | 2012-01-29 00:00:00 | 2012-01-30 00:00:00 | 2012-01-31 00:00:00
Bay 1 | Planned | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
Bay 1 | Achieved | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
Bay 2 | Planned | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32
Bay 2 | Achieved | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32
Bay 3 | Planned | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33
Bay 3 | Achieved | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33
 |  |  | 1 | 1 | 2 | 2 | 3 | 3
 |  |  | Up To 1st Tue |  | From 1st Wed to 2 nd Tue |  | From 2nd Wed to 3rd Tue
 |  |  | 2012-01-01 00:00:00 | 2012-01-03 00:00:00 | 2012-01-04 00:00:00 | 2012-01-10 00:00:00 | 2012-01-11 00:00:00 | 2012-01-17 00:00:00
 |  |  | Planned | Achieved | Planned | Achieved | Planned | Achieved
 |  | Bay 1 | 6 | 6 | 49 | 49 | 98 | 98
 |  | Bay 2 | 9 | 9 | 56 | 56 | 105 | 105
 |  | Bay 3 | 12 | 12 | 63 | 63 | 112 | 112
Spreadsheet: 808618d1670535662-need-to-exclude-weekends-from-total-countif-formula-2022-annual-leave-tracker-sample
Sheet: Setting

Leave Type | Leave Code |  |  | Month List |  |  | Holidays
Vacation | V |  |  | 2022-01-01 00:00:00
Leave without Pay | LWP |  |  | 2022-02-01 00:00:00
[NAME] | SL |  |  | 2022-03-01 00:00:00
Half Day Leave | HD |  |  | 2022-04-01 00:00:00
Maternity Leave | ML |  |  | 2022-05-01 00:00:00
Work From Home | WH |  |  | 2022-06-01 00:00:00
Unexplained Absense | UA |  |  | 2022-07-01 00:00:00
 |  |  |  | 2022-08-01 00:00:00
 |  |  |  | 2022-09-01 00:00:00
 |  |  |  | 2022-10-01 00:00:00
 |  |  |  | 2022-11-01 00:00:00
 |  |  |  | 2022-12-01 00:00:00
Spreadsheet: 89597d1289385251-picking-a-value-out-of-a-range-book1
Sheet: in

DAILY-IN | 2010-10-28 00:00:00 | 2010-10-29 00:00:00 | 2010-10-30 00:00:00 | 2010-10-31 00:00:00 | 2010-11-01 00:00:00 | 2010-11-02 00:00:00
SERVICE DESK
[NAME]
[NAME]
[NAME]
[NAME]
Townsend  Neethling
FIRST LINE (Days)
[NAME]
[NAME]
Romesh Sharma
[NAME]
[NAME]
Esosa Igbinosun
FIRST LINE (Shifts)
[NAME]
Spreadsheet: 164028d1340623487-excel-2007-what-formula-and-how-should-i-use-it-vlookup-or-indext-or-diet-plan-3
Sheet: food database

food name | grams | Measurements | Calories | Protein | Fat | Crabs | Fibre
Quaker,  Oats | 27 | 1 cup | 103 | 3.2 | 2.4 | 15.7 | 2.6
[NAME], Crunchy Oats | 12.5 | 3 biscuits | 172 | 3 | 5.9 | 25.5 | 1.8
Abbott's Bread: Harvest Seeds & Grains | 42 | 1 slice | 118 | 4.6 | 2.2 | 18.8 | 1.8
Vita-Weat, 9 Grain | 25 | 2 slice | 94 | 3.1 | 2.4 | 15.6 | 3
Spreadsheet: 873655d1720167281-catch-break-inside-working-time-breaks
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TODAY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sat
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WED | 08:15:15 | 11:35:35
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | THU | 08:30:31 | 11:30:45 | 14:30:45
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FRI | 09:00:15 | 12:00:15 | 15:00:15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SAT | 08:30:45 | 11:30:45 | 14:30:45
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | breaks |  |  |  |  | v1 |  | V2 |  |  | CS Finish time | CS Breaks
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | START TIME | FINISH TIME
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 01:20:39.834000 |  | 06:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 04:05:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 02:14:24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 01:01:12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 02:52:48
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | START TIME | FINISH TIME
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 01:04:43.146000 |  | 06:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:50:56.604000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 03:55:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 02:38:24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 02:24:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | START TIME | FINISH TIME
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 05:33:00 |  | 06:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 02:02:00 |  | 12:13:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 04:06:00 |  | 14:15:00
Spreadsheet: 56779d1256864405-linking-worksheets-705314-linking-worksheets
Sheet: Ranges

Status | L&G | MC |  | BHI | Month
Active | 0 | 0 | 0 | 0 | Jan
Complete | 1 | One | 250 | BC | Feb
Decline | 2 | Two | 500 | B | Mar
Gone Off | 3 | Three | 1000 | C | Apr
 | 4 | Four | 1500 |  | May
 | 5 |  |  |  | Jun
 | 6 |  |  |  | Jul
 | 7 |  |  |  | Aug
 | 8 |  |  |  | Sep
 | 9 |  |  |  | Oct
 |  |  |  |  | Nov
 |  |  |  |  | Dec
Spreadsheet: 93176d1292782277-array-formulae-macro-counting-datasets-ad9051_countdataset-1-
Sheet: Sheet1

 |  |  |  |  |  |  |  | Ok the formulae/macro needs to be able to return the size of the dataset where rank =1
 | Data | Rank | Count of Data Sets
 | 47.5 |  |  |  |  |  |  | The datasets I receive/produce can range between 2 - 30 in size and a single spreadsheet may contain 200 or more datasets
 | 47.66666666666666 |  |  |  | <- | should be
 | 45.75
 | 42.625
 | 45.75
 | 45.5
 | 38.625
 | Data
 | 42.25
 | 40.5
 | 42.375 |  |  |  | <- | should be
 | 40.25
 | Data
 | 47.75
 | 48.125 |  |  |  | <- | should be
 | 48
 | 42.5
 | 32.66666666666666
 | 43.66666666666666
 | 44.875
 | 34.5
 | 35.5
 | 0
 | 41
 | 38.66666666666666
 | MS
 | 45
 | 43.25
 | 41.75
 | 34.25
 | 31.5
 | 40
 | 27
 | 36
 | 0
 | MS
 | 51.5
 | 51.25
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 50
 | 0
Spreadsheet: 52490d1252275715-help-needed-in-creating-a-drop-down-list-involved-set-of-data-in-tables-alisalm
Sheet: Hauling

 |  | Distance (ft) | Select Equip. | Select Weight | Select Total Resistence | Travel Speed (mph) | Travel Time (min)
 |  |  | D25D | 40-60 | 15
 |  |  |  | D25D | Travel Speed (mph)
 |  |  | Weight (lb*1000) |  | Total Resistence (%)
 |  |  |  |  | 5 | 10 | 15 | 20 | 25 | 30
 |  |  | 40-60 |  | 22 | 18 | 12 | 10 | 7 | 7
 |  |  | 60-80 |  | 18 | 12 | 12 | 7 | 7 | 4
 |  |  | 80-100 |  | 18 | 12 | 7 | 7 | 4 | 4
 |  |  |  | D400E | Travel Speed (mph)
 |  |  | Weight (lb*1000) |  | Total Resistence (%)
 |  |  |  |  | 5 | 10 | 15 | 20 | 25 | 30
 |  |  | 70-80 |  | 31 | 23 | 17 | 12 | 10 | 10
 |  |  | 80-100 |  | 31 | 22 | 17 | 12 | 10 | 7
 |  |  | 100-120 |  | 31 | 22 | 12 | 10 | 8 | 7
 |  |  | 120-160 |  | 31 | 18 | 10 | 8 | 7 | 7
 |  |  |  | 773D | Travel Speed (mph)
 |  |  | Weight (lb*1000) |  | Total Resistence (%)
 |  |  |  |  | 5 | 10 | 15 | 20 | 25 | 30
 |  |  | 88-100 |  | 41 | 30 | 17 | 12 | 12 | 8
 |  |  | 100-150 |  | 41 | 23 | 15 | 8 | 8 | 7
 |  |  | 150-200 |  | 30 | 12 | 10 | 7 | 7 | 7
 |  |  |  | 775D | Travel Speed (mph)
 |  |  | Weight (lb*1000) |  | Total Resistence (%)
 |  |  |  |  | 5 | 10 | 15 | 20 | 25 | 30
 |  |  | 100-120 |  | 41 | 31 | 17 | 14 | 14 | 8
 |  |  | 120-160 |  | 41 | 23 | 17 | 12 | 12 | 7
 |  |  | 160-200 |  | 31 | 15 | 12 | 8 | 8 | 7
 |  |  | 200-240 |  | 30 | 12 | 8 | 7 | 7 | 7
 |  |  |  | 777D | Travel Speed (mph)
 |  |  | Weight (lb*1000) |  | Total Resistence (%)
 |  |  |  |  | 5 | 10 | 15 | 20 | 25 | 30
 |  |  | 140-150 |  | 38 | 28 | 18 | 18 | 12 | 12
 |  |  | 150-200 |  | 38 | 23 | 17 | 12 | 9 | 7
 |  |  | 200-250 |  | 28 | 20 | 12 | 8 | 7 | 7
 |  |  | 250-300 |  | 28 | 15 | 12 | 7 | 7 | 7
 |  |  | 300-350 |  | 28 | 12 | 10 | 7 | 7
Spreadsheet: 876852d1723565769-pivot-table-second-column-sum-and-values-not-matching-work-progress-dated-12-aug-2024-bvj-
Sheet: Install

Installed  On | MarkNo. | Qty (Nos) | [NAME]. | GROSS WEIGHT | Assembly Name
2024-06-23 00:00:00 | QLGF-C2001 | 1
2024-06-23 00:00:00 | QLGF-C2002 | 1
2024-06-24 00:00:00 | QLGF-C2002 | 1
2024-06-23 00:00:00 | QLGF-C2003 | 1
2024-06-24 00:00:00 | QLGF-BM2003 | 1
2024-06-24 00:00:00 | QLGF-BM2004 | 1 |  | 205.7
2024-06-24 00:00:00 | QLGF-HB2005 | 1
2024-06-24 00:00:00 | QLGF-HB2009 | 1
2024-06-25 00:00:00 | QL-1-BM2002 | 1 |  | 673.6
2024-06-25 00:00:00 | QL-1-BM2003 | 1
2024-06-25 00:00:00 | QL-1-BM2004 | 1
Spreadsheet: 136277d1326502327-duplicate-names-book1_tjonas
Sheet: Sheet1 (2)

 |  |  | Remove Initial Letter |  | Remove Duplicates | [NAME]
AERNI, GISELLE | 47 |  | AERNI, GISELLE |  | AERNI, GISELLE | 95
AERNI, GISELLE A | 48 |  | AERNI, GISELLE |  | AFROOZ, PAUL | 1101
AFROOZ, PAUL | 953 |  | AFROOZ, PAUL |  | AGARWAL, DEVESH | 49
AFROOZ, PAUL N | 148 |  | AFROOZ, PAUL |  | AGARWAL, SUNIL | 639
AGARWAL, DEVESH | 49 |  | AGARWAL, DEVESH
AGARWAL, SUNIL | 523 |  | AGARWAL, SUNIL
AGARWAL, SUNIL K | 116 |  | AGARWAL, SUNIL