tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 675726d1588441835-use-data-in-multiple-cells-to-return-result-example
Sheet: Sheet1

Key details |  |  |  |  |  |  |  |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday
Child's Name | D.O.B | Age | Parent's Name | Address | Contact Number | Allergies | Disabilities | Password | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM
1 | 2018-05-27 00:00:00 |  | 1 | 33bhdhd |  |  |  |  | Yes
2 | 2016-08-17 00:00:00 |  | 2 | 33bhdhd |  |  |  |  | No
3 | 2014-09-05 00:00:00 |  | 3 | 33bhdhd |  |  |  |  | Yes
4 | 2017-06-01 00:00:00 |  | 4 | 33bhdhd |  |  |  |  | No
Spreadsheet: 62837d1263841448-formula-to-change-font-color-logans-whiteboard
Sheet: Sheet1

Date | GA's | P GA's | Total Ops | [NAME] | EIPO | FPO | [NAME] | Acc Rev | Wired Sub | Wire Post | CFT % | [NAME]
2010-01-17 00:00:00 | 6 | 17 | 55 | 107 | 47 | 20.98 | 923 | 2256 | 2 | 0 |  | 1.891
Date | GA's | P GA's | Total Ops | [NAME] | EIPO | FPO | [NAME] | Acc Rev | Wired Sub | Wire Post | CFT % | [NAME]
Spreadsheet: 763938d1642478353-average-function-which-disregards-columns-year-months-average-2
Sheet: Sheet1

Years/Months | Years/Months | Average |  |  | Data | Years/Months | Data | Years/Months | Average
6/4 | 7/4 |  |  |  | 23.2 | 6/4 | 45.3 | 7/4
6/5 | 6/10 |  |  |  | 45.3 | 6/5 | 58 | 6/10
5/12 | 6/10 |  |  |  | 23 | 5/12 |  | 6/10
6/2 |  |  |  |  |  | 6/2 | 3.2
6/4 | 6/11 |  |  |  | 45 | 6/4 | 45.3 | 6/11
6/4 | 7/2 |  |  |  | 96 | 6/4 | 23 | 7/2
Spreadsheet: d223cdcf-5d98-4959-b18b-1bf2ba903369
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
INGERSOLL-RAND COMPANY
Consolidated Income Statement
Third Quarter and Nine Months
(In millions except percentages and per share figures)
UNAUDITED
 |  |  | Three Months |  |  |  | Nine Months
 |  |  | Ended September 30, |  |  |  | Ended September 30,
 |  |  | 2001 |  | 2000 |  | 2001 |  | 2000
Revenues |  |  | 2383.1 |  | 2511.9 |  | 7146.4 |  | 7160.9
Cost of goods sold |  |  | 1868.196 |  | 1889 |  | 5595.257212 |  | 5331.4
Selling & administrative expenses |  |  | 364.7040000000001 |  | 341.5 |  | 1053.142788 |  | 943.6
Restructuring charges |  |  | 25.6 |  | 38.2 |  | 57.2 |  | 38.2
Operating income |  |  | 124.6 |  | 243.2 |  | 440.8 |  | 847.7
Interest expense |  |  | -75.2 |  | -84.5 |  | -216.2 |  | -203.2
Other income/(expense) |  |  | -17.3 |  | 47.10000000000005 |  | -14.7000000000001 |  | 36.2
Equity in earnings of partially-
 | owned affiliates |  | 1.7 |  | 2.7 |  | 4.6 |  | 4.7
Minority interests |  |  | -2.5 |  | -10 |  | -16.6 |  | -30.1
Other income/(expense), net |  |  | -18.1 |  | 47.6 |  | -26.7000000000001 |  | 18.8
Results from assets held
for sale (net of tax) |  |  | 0 |  | 0 |  | 0 |  | 0
Earnings before taxes |  |  | 31.30000000000037 |  | 206.3 |  | 197.9 |  | 663.3
Provision for taxes |  |  | -2.6 |  | 75.6 |  | 51.8 |  | 223.2
 | Earnings from continuing operations |  | 33.90000000000037 |  | 130.7 |  | 146.1 |  | 440.1
Discontinued operations (net of tax) |  |  | 0 |  | 121.2 |  | 0 |  | 123.2
 | Net earnings |  | 33.90000000000037 |  | 251.9 |  | 146.1 |  | 563.3
Basic earnings per share
 | -Continuing operations |  | 0.2 |  | 0.81 |  | 0.89 |  | 2.73
 | -Discontinued operations |  | 0 |  | 0.7500000000000009 |  | 0 |  | 0.7600000000000007
 |  |  | 0.2 |  | 1.56 |  | 0.89 |  | 3.49
Diluted earnings per share
 | -Continuing operations |  | 0.2 |  | 0.8 |  | 0.89 |  | 2.7
 | -Discontinued operations |  | 0 |  | 0.75 |  | 0 |  | 0.76
 |  |  | 0.2 |  | 1.55 |  | 0.89 |  | 3.46
Average number of common
 | shares outstanding:
 | Basic |  | 168.285 |  | 160.9 |  | 164.255622 |  | 161.433822
 | Diluted |  | 169.248 |  | 162.1 |  | 165.5 |  | 162.756178
Spreadsheet: 881117d1729032332-fairly-easy-problem-rank-items-by-score-using-a-recursive-function-sample
Sheet: Dropdowns

Score Order
Spreadsheet: 275936d1383689705-forecast-bonus-calculator-require-a-formula-to-calculate-the-bonus-due-forecast-bonus-calculator
Sheet: Bonus Calc

 |  | 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 | 2013-01-01 00:00:00 | 2013-02-01 00:00:00 | 2013-03-01 00:00:00 | 2013-04-01 00:00:00 | 2013-05-01 00:00:00 | 2013-06-01 00:00:00 | 2013-07-01 00:00:00 | 2013-08-01 00:00:00 | 2013-09-01 00:00:00 | 2013-10-01 00:00:00 | 2013-11-01 00:00:00 | 2013-12-01 00:00:00 | 2014-01-01 00:00:00 | 2014-02-01 00:00:00 | 2014-03-01 00:00:00 | 2014-04-01 00:00:00 | 2014-05-01 00:00:00 | 2014-06-01 00:00:00 | 2014-07-01 00:00:00 | 2014-08-01 00:00:00 | 2014-09-01 00:00:00 | 2014-10-01 00:00:00 | 2014-11-01 00:00:00 | 2014-12-01 00:00:00 | 2015-01-01 00:00:00 | 2015-02-01 00:00:00 | 2015-03-01 00:00:00 | 2015-04-01 00:00:00 | 2015-05-01 00:00:00 | 2015-06-01 00:00:00 | 2015-07-01 00:00:00 | 2015-08-01 00:00:00 | 2015-09-01 00:00:00 | 2015-10-01 00:00:00 | 2015-11-01 00:00:00 | 2015-12-01 00:00:00 | 2016-01-01 00:00:00 | 2016-02-01 00:00:00
 | Sales (k) | 454859 | 148957 | 2353724 | 191220 | 2287930 | 1829090 | 668204 | 555000 | 755000 | 926002 | 357000 | 1136000 | 448000 | 675000 | 812557 | 249454 | 737741 | 1756883 | 1295694 | 599131 | 174016 | 2320866 | 214158 | 707921 | 689186 | 1515642 | 817880 | 1534024 | 2221692 | 1116665 | 735831 | 2376133 | 691398 | 466317 | 838136 | 962338 | 1678538 | 853977 | 401694 | 1453274 | 810841 | 1527949 | 527444 | 1919066 | 2351186 | 2238120 | 2068982
 | 12 Mth Rolling Sum (k)
 | Monthly Bonus Due
 | Greater Than:
 | 5000000
 | 10000000
 | 15000000
 | The table below shows the bonus percentage due after the 12 month rolling sales sum reaches a certain level.
 | Bonus % Due
 | 5000000 | 0.01
 | 10000000 | 0.02
 | 15000000 | 0.03
 | The first bonus due will be in August 2012 when the 12 month rolling sum first goes above 5,000k. The bonus due will be 4,370 (4k), calculated as (5,437k - 5,000k) x 1%.
 | The second bonus due will be in September 2012 when the bonus payable will be the difference between the current rolling figure (7,266k) and the previous rolling high point (5,437k) multiplied by the applicable rate (1%).
 | (7,266k - 5,437k) x 1% = 18,290 (18k)
 | Incremental bonuses will then be due each month until April 13 when the rolling position falls below a level at which bonuses have already been paid (11,656k < 11,663k). They will be due again in May 13 as 12,182k > 11,663k
 | Bonuses aren't paid when the current rolling sum is below a previous high. There is effectively a rolling 'bonus ceiling' in operation.
 | Bonuses can be due at split percentages, i.e. x amount due at 1% and x amount due at 2% when the rolling sum goes above 10,000k.
 | Ideally I'd like a formula in row 6 to show how to calculate the total due and some formulas in row 9 to 11 to show how to calculate it split out between the different bonus percentage rates.
 | Massive thanks in advance! Snook
Spreadsheet: 36086d1233851204-how-to-deduct-holidays-and-take-multiple-projects-into-account-in-a-report-monthly-report-with-holidays
Sheet: vacation

Employee | Date
Mr White | 2008-11-28 00:00:00
Mr White | 2008-12-01 00:00:00
Mr White | 2008-12-02 00:00:00
Mr White | 2008-12-23 00:00:00
Mr White | 2008-12-24 00:00:00
Mr White | 2008-12-29 00:00:00
Mr White | 2008-12-30 00:00:00
Mr White | 2008-12-31 00:00:00
Mr White | 2009-01-02 00:00:00
Mr White | 2009-01-12 00:00:00
Mr White | 2009-01-13 00:00:00
Mr White | 2009-01-14 00:00:00
Mr White | 2009-01-15 00:00:00
Mr White | 2009-01-16 00:00:00
Mr Orange | 2008-12-01 00:00:00
Mr Orange | 2008-12-22 00:00:00
Mr Orange | 2008-12-23 00:00:00
Mr Orange | 2008-12-24 00:00:00
Mr Orange | 2008-12-29 00:00:00
Mr Orange | 2008-12-30 00:00:00
Mr Orange | 2008-12-31 00:00:00
Mr Orange | 2009-01-02 00:00:00
Mr Blonde | 2008-12-01 00:00:00
Mr Blonde | 2008-12-12 00:00:00
Mr Blonde | 2008-12-23 00:00:00
Mr Blonde | 2008-12-24 00:00:00
Mr Blonde | 2008-12-29 00:00:00
Mr Blonde | 2008-12-30 00:00:00
Mr Blonde | 2008-12-31 00:00:00
Mr Blonde | 2009-01-02 00:00:00
Mr Pink | 2008-11-20 00:00:00
Mr Pink | 2008-11-21 00:00:00
Mr Pink | 2008-12-01 00:00:00
Mr Pink | 2008-12-22 00:00:00
Mr Pink | 2008-12-23 00:00:00
Mr Pink | 2008-12-24 00:00:00
Mr Pink | 2008-12-29 00:00:00
Mr Pink | 2008-12-30 00:00:00
Mr Pink | 2008-12-31 00:00:00
Mr Pink | 2009-01-02 00:00:00
Mr Blue | 2008-11-06 00:00:00
Mr Blue | 2008-11-07 00:00:00
Mr Blue | 2008-11-13 00:00:00
Mr Blue | 2008-11-14 00:00:00
Mr Blue | 2008-12-01 00:00:00
Mr Blue | 2008-12-19 00:00:00
Mr Blue | 2008-12-22 00:00:00
Mr Blue | 2008-12-23 00:00:00
Mr Blue | 2008-12-24 00:00:00
Mr Blue | 2008-12-29 00:00:00
Mr Blue | 2008-12-30 00:00:00
Mr Blue | 2008-12-31 00:00:00
Mr Blue | 2009-01-02 00:00:00
Mr [NAME] | 2008-11-01 00:00:00
Mr [NAME] | 2008-11-03 00:00:00
Mr [NAME] | 2008-11-04 00:00:00
Mr [NAME] | 2008-11-05 00:00:00
Mr [NAME] | 2008-11-06 00:00:00
Mr [NAME] | 2008-11-07 00:00:00
Mr [NAME] | 2008-12-22 00:00:00
Mr [NAME] | 2008-12-23 00:00:00
Mr [NAME] | 2008-12-24 00:00:00
Mr [NAME] | 2008-12-29 00:00:00
Mr [NAME] | 2008-12-30 00:00:00
Mr [NAME] | 2008-12-31 00:00:00
Mr [NAME] | 2009-01-02 00:00:00
Mr [NAME] | 2009-01-05 00:00:00
Mr [NAME] | 2009-01-06 00:00:00
Mr [NAME] | 2009-01-07 00:00:00
Mr [NAME] | 2009-01-08 00:00:00
Mr [NAME] | 2009-01-09 00:00:00
Spreadsheet: mary_hain__25858__EnronMarch2001
Sheet: MAR7

Loss Calculation for | 2001-03-06 00:00:00
Please indicate either
 | Financial |  | =
 |  | OR
 | Energy Return |  | = |  | MW
 |  | If [NAME] is Selected, then:
 |  |  |  |  | Should have been returned concurrent with parent tag
If energy is returned |  |  |  |  | Should be returned next week, same day, same profile (see date to the left)
Collection is due on
Please fax back to
(970) 461-7213
CRSP LOSSES
LOSSES FOR THESE TRANSACTIONS SHOULD BE RETURNED CONCURRENTLY W/ SEPARATE TAG |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24
20010307 | 2164 | 18080 | CR | ENRON OASIS 20635 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 20 | 10 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  | 0.055 | 0.055 | 0.055 | 0.055 | 0.055 | 0.055 | 0.055 | 0.055 | 0.055 | 0.055 | 0.055 | 0.055 | 0.055 | 0.055 | 0.055 | 0.055 | 0.055 | 0.055 | 0.055 | 0.055 | 0.055 | 0.055 | 0.055 | 0.055
 |  |  |  |  |  | PRICES |  | 192.69 |  |  |  |  |  |  | 215.32
LAP LOSSES
 |  |  |  |  |  |  |  | 0.0475 | 0.0475 | 0.0475 | 0.0475 | 0.0475 | 0.0475 | 0.0475 | 0.0475 | 0.0475 | 0.0475 | 0.0475 | 0.0475 | 0.0475 | 0.0475 | 0.0475 | 0.0475 | 0.0475 | 0.0475 | 0.0475 | 0.0475 | 0.0475 | 0.0475 | 0.0475 | 0.0475
 |  |  |  |  |  | PRICES
REAL-TIME CRSP LOSSES
LOSSES FOR THESE TRANSACTIONS SHOULD BE RETURNED PRESCHEDULED NEXT WEEK, SAME DAY, SAME PROFILE |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24
 |  |  |  |  |  |  |  | 0.055 | 0.055 | 0.055 | 0.055 | 0.055 | 0.055 | 0.055 | 0.055 | 0.055 | 0.055 | 0.055 | 0.055 | 0.055 | 0.055 | 0.055 | 0.055 | 0.055 | 0.055 | 0.055 | 0.055 | 0.055 | 0.055 | 0.055 | 0.055
 |  |  |  |  |  | PRICES
REAL-TIME LAP LOSSES
LOSSES FOR THESE TRANSACTIONS SHOULD BE RETURNED PRESCHEDULED NEXT WEEK, SAME DAY, SAME PROFILE
 |  |  |  |  |  |  |  | 0.0475 | 0.0475 | 0.0475 | 0.0475 | 0.0475 | 0.0475 | 0.0475 | 0.0475 | 0.0475 | 0.0475 | 0.0475 | 0.0475 | 0.0475 | 0.0475 | 0.0475 | 0.0475 | 0.0475 | 0.0475 | 0.0475 | 0.0475 | 0.0475 | 0.0475 | 0.0475 | 0.0475
 |  |  |  |  |  | PRICES
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ADMINISTRATIVE CHARGE
Spreadsheet: 108791d1305760721-search-a-value-from-two-columns-find-the-corresponding-value-in-third-column-code-excel
Sheet: Sheet1 (2)

101 | 99 | 65 |  |  |  | 35
102 | 35 | 1000
103 | 48 | 86
104 | 25 | 45
105 | 96 | 32
101 | 1000 | 1000 |  |  |  | 1000
102 | 1000 | 1000
103 | 1000 | 1000
104 | 1000 | 1000
105 | 1000 | 1000
101 | 1000 | 1000 |  |  |  | 1000
102 | 850 | 223
103 | 132 | 145
104 | 1212 | 1212
105 | 1555 | 1000
Spreadsheet: 156197d1337209175-can-anyone-help-with-a-stock-count-balance-sheet-book111
Sheet: Sheet3

[NAME] | Value | total rec | Total Usage
ab12345 | 1000 |  | 999
ab12346 | 3000 |  | 3999
ab12456 | 1000 |  | 4000
ac12221 | 1 |  | 4000
 | Delivery | Total | Usage | Balance
a1 | 1000 |  | 0
a2 | 1000 |  | 999
a3 | 1000 |  | 1000
Spreadsheet: 872144d1718512728-drop-down-menu-that-filters-dates-project-change-log-aligw
Sheet: Main

Project Change Log
Date | Project Name | Task Name | Description of Change | Outcome of Change | Changed By | Notes | Month
2024-01-05 00:00:00 | Infographic | Eagle | Some cool things | Cool things show up | [NAME]
2024-01-09 00:00:00 | Calendar | Turtle |  |  | [NAME]
2024-02-13 00:00:00 | Database | Capybara |  |  | [NAME]
2024-02-29 00:00:00 | [NAME] | Sea Otter |  |  | [NAME]
2024-03-07 00:00:00 | Infographic | Red Panda |  |  | [NAME]
2024-03-08 00:00:00 | Calendar | [NAME] |  |  | [NAME]
2024-03-15 00:00:00 | Database | Puffin |  |  | [NAME]
2024-04-01 00:00:00 | [NAME] | Kangaroo |  |  | [NAME]
2024-05-06 00:00:00 | Database | [NAME] |  |  | [NAME]
2024-05-07 00:00:00 | Infographic | Capybara |  |  | [NAME]
2024-06-15 00:00:00 | Calendar | [NAME] |  |  | [NAME]
Spreadsheet: a85352f6-fc24-49ff-bfe8-7fd7b95b9eb3
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2
 |  | U.S. Census Bureau
 |  | Source: New Residential Construction
 |  | Housing Units Under Construction: United States
 |  | Seasonally Adjusted Single-family Units [Thousands of Units]
 |  | Period: 2008 to 2012
 |  | Data Extracted on: November 22, 2014 (5:38 am)
Period | Value
Jan-2008 | 592
Feb-2008 | 578
Mar-2008 | 563
Apr-2008 | 552
May-2008 | 532
Jun-2008 | 511
Jul-2008 | 489
Aug-2008 | 479
Sep-2008 | 456
Oct-2008 | 437
Nov-2008 | 417
Dec-2008 | 397
Jan-2009 | 383
Feb-2009 | 366
Mar-2009 | 344
Apr-2009 | 327
May-2009 | 316
Jun-2009 | 314
Jul-2009 | 316
Aug-2009 | 311
Sep-2009 | 314
Oct-2009 | 308
Nov-2009 | 301
Dec-2009 | 300
[NAME] | 299
[NAME] | 302
Mar-2010 | 306
Apr-2010 | 307
[NAME] | 301
[NAME] | 282
[NAME] | 277
Aug-2010 | 273
Sep-2010 | 270
Oct-2010 | 266
Nov-2010 | 266
Dec-2010 | 262
Jan-2011 | 260
Feb-2011 | 253
Mar-2011 | 253
Apr-2011 | 249
May-2011 | 246
Jun-2011 | 246
Jul-2011 | 242
Aug-2011 | 238
Sep-2011 | 237
Oct-2011 | 235
Nov-2011 | 236
Dec-2011 | 236
Jan-2012 | 241
Feb-2012 | 245
Mar-2012 | 246
Apr-2012 | 246
May-2012 | 253
Jun-2012 | 257
Jul-2012 | 262
Aug-2012 | 265
Sep-2012 | 271
Oct-2012 | 275
Nov-2012 | 279
Dec-2012 | 284
Spreadsheet: 485290d1476807169-trying-to-make-a-payroll-form-that-divides-reg-time-and-ot-after-8-and-after-44-hours-payroll-form
Sheet: Sheet1

 |  |  |  |  |  |  | PAY ROLL FORM
 | Date | Day 1 |  |  | Day 2 |  |  | Day 3 |  |  | Day 4 |  |  | Day 5 |  |  | Day 6 |  |  | Day 7 |  |  | Week Totals
Employee |  | Total | Reg | OT | Total | Reg | OT | Total | Reg | OT | Total | Reg | OT | Total | Reg | OT | Total | Reg | OT | Total | Reg | OT | Total | Reg | OT |  |  | OT after in one day |  |  | 8
 |  | 12 |  |  | 12 |  |  | 12 |  |  | 12 |  |  | 12 |  |  | 12 |  |  | 12 |  |  |  |  |  |  |  | OT after in one week |  |  | 44
 | Date | Day 8 |  |  | Day 9 |  |  | Day 10 |  |  | Day 11 |  |  | Day 12 |  |  | Day 13 |  |  | Day 14 |  |  | Week Totals |  |  |  | 2 Week Totals
Employee |  | Total | Reg | OT | Total | Reg | OT | Total | Reg | OT | Total | Reg | OT | Total | Reg | OT | Total | Reg | OT | Total | Reg | OT | Total | Reg | OT |  | Total | Reg | OT
 |  | 8 |  |  | 8 |  |  | 8 |  |  | 8 |  |  | 8 |  |  | 8 |  |  | 8
Spreadsheet: 33650d1230136918-dynamic-named-range-samplespreadsheet2
Sheet: Product Details

Product Code | Product Description | List Price
BC110 | Product 1 | 50
BC113 | Product 2 | 65
[NAME] | Product 3 | 120
CA085 | Product 4 | 100
DJ220 | Product 5 | 85
DJ230 | Product 6 | 70
Spreadsheet: 54726d1254781988-selecting-matching-names-and-variables-from-2-lists-indexmatch-2fields-simple
Sheet: Data

First Name | Last Name | OtherData | [NAME]
First1 | Last1 | Other1 | Email1
First2 | Last2 | Other2 | Email2
First3 | [NAME] | Other3 | Email3
First4 | Last4 | Other4 | Email4
First5 | Last5 | Other5 | Email5
First6 | Last6 | Other6 | Email6
First7 | Last7 | Other7 | Email7
First8 | Last8 | Other8 | Email8
First9 | [NAME] | Other9 | Email9
First10 | Last10 | Other10 | Email10
First11 | [NAME] | Other11 | Email11
Spreadsheet: 838208d1690819503-horse-racing-bookie-account-balances-horse-racing-bets-test
Sheet: Bets

Bookmaker | Stake | Odds Multiplier | Column1 | Odds | Bet Type | Result | Win | [NAME] | Profit/Loss | Total P&L | Total Payout | [NAME]
Skybet | 10 | 10 | / | 1 | Win | Win | Yes |  |  |  |  | Needs to either subtract the stake from the balance on tab 'Bookmakers' if the result in G is "Lost" or if the result is "Place" or "Win" add Win Payout (Column I) to the balance of the bookmaker in stipulated in Column A
Tote | 5 | 10 | / | 1 | Each Way | Place |  |  |  |  |  | Do the same as above for all bookmakers
Ladbrokes | 5 | 10 | / | 1 | Win | Lost
Spreadsheet: sally_beck__33919__GlobalMgmtSum-Q101-0125
Sheet: GrossMargin

PLAN2000
[NAME] | ENRON GLOBAL MARKETS
2000-12-01 00:00:00 | 1st QUARTER 2001 DETAIL OF GROSS MARGIN
M.QTD
ENA
 |  |  |  |  |  |  |  | Actual | Deals | Forecast | Total | Margin
 | Business Team |  | DPR(1) | MPR | Accruals | Other | FTA | Margin | Identified | Margin | Margin | Plan | [NAME]
 | Crude & Products |  | -11805 | 0 | 0 | 0 | 0 |  |  | 0 |  | 40000
COAL | Coal |  |  |  | 0 |  | 0 |  |  | 0 |  | 13750
SO2 | Emissions |  | -2813 | 0 | 0 | 0 | 0 |  |  | 0
WEATHER | Weather |  | 1615 | 0 | 0 | 0 | 0 |  |  | 0 |  | 8509.251
INSURANCE | Global Risk Markets |  | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  | 4875
ECT_INV_IRFX | Equity Trading |  | -271 | 0 | 0 | 0 | 0 |  |  | 0 |  | 0
ECT_INV_IRFX | Convertible Trading |  | 1457 | 0 | 0 | 0 | 0 |  |  | 0 |  | 0
 | FX / Int Rate Trading |  | 1866 | 0 | 0 | 0 | 0 |  |  | 0 |  | 0
 | Soft Commodities Trading |  | -4 | 0 | 0 | 0 | 0 |  |  | 0 |  | 0
 | Grain Trading |  | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  | 0
 | Meat Trading |  | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  | 0
 | Financial Trading |  |  |  |  |  |  |  |  |  |  | 20000
 | Transportation |  | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  | 500
 | LNG |  | 274 | 0 | 0 | 0 | 0 |  |  | 0 |  | 3000
 | Middle East |  | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  | 1413
 | Puerto Rico |  | 0 | 0 | 0 | -859 | 0 |  |  | 0
 | Finance and Structuring |  | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  | 0
 | Office of the Chairman |  | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  | 0
 | Subtotal Gross Margin
 | Other Interest Related Charges |  | 0 | 0 | 0 |  | 0 |  |  | 0
 | EGM Gross Margin
 | (1) Excludes Cap. Charge & Operating Costs
Spreadsheet: 480467d1473934449-pay-slip-calculation-error-pay-slip-calculation-error
Sheet: Sheet1

 |  | Start Time | Regular Hours | Regular Pay (hourly) | Overtime Pay (hourly)
 |  | 07:00:00 | 8 | 15
 |  | In Time | [NAME] | [NAME] In | Out Time | [NAME] | Regular Hrs | PTO Hours | [NAME] | Public Holidays | Make-Up Hrs | Un-Paid Hrs | Total Hrs | OT Hours | Total Pay
 |  | 07:00:00 | 11:00:00 | 11:30:00 | 13:00:00 |  |  | 0 | 0 | 0 | 0 | 0
 |  | 07:00:00 | 11:00:00 | 11:30:00 | 15:30:00 |  |  | 0 | 0 | 0 | 0 | 0
 |  | 07:00:00 | 11:00:00 | 11:30:00 | 16:00:00 |  |  | 0 | 0 | 0 | 0 | 0
Spreadsheet: 889908d1740939764-formula-works-except-for-one-cell-blood-pressure-2025-a
Sheet: 30 day

30 Day Tracker
date | day | time | Sys | [NAME] | Pul | Sugar
 |  |  |  |  |  |  |  |  | 29 | .
 |  |  |  |  |  |  |  |  | 28
 |  |  |  |  |  |  |  |  | 27
 |  |  |  |  |  |  |  |  | 26
 |  |  |  |  |  |  |  |  | 25
 |  |  |  |  |  |  |  |  | 24
 |  |  |  |  |  |  |  |  | 23
 |  |  |  |  |  |  |  |  | 22
 |  |  |  |  |  |  |  |  | 21
 |  |  |  |  |  |  |  |  | 20
 |  |  |  |  |  |  |  |  | 19
 |  |  |  |  |  |  |  |  | 18
 |  |  |  |  |  |  |  |  | 17
 |  |  |  |  |  |  |  |  | 16
 |  |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  |  | 14
 |  |  |  |  |  |  |  |  | 13
 |  |  |  |  |  |  |  |  | 12
 |  |  |  |  |  |  |  |  | 11
 |  |  |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  | 0
Median
 |  | Time | Sys | [NAME] | Pul | Sugar
High
Low
Spreadsheet: 888838d1739440185-instead-of-dropdown-selecting-single-need-all-lists-output-tenure-test_v3
Sheet: Entry

Date | ID | Member [NAME] | Monthly Contribution | Category |  |  |  | Year 2022
2025-01-01 00:00:00 | M001 | Nutan Vishal Bhagare | 500 |  |  | Year 2020 |  | Contribution
2025-01-01 00:00:00 | M002 | Suvarna N Gaikwad | 500 |  |  | Year 2021 |  | Intest
2025-01-01 00:00:00 | M003 | Rajjaka A Waghmode | 500 |  |  | Year 2022 |  | Late Fee
2025-01-01 00:00:00 | M004 | Surkekha A Kirgat | 500 |  |  | Year 2023 |  | Late Intest
2025-01-01 00:00:00 | M005 | Kamble | 500 |  |  | Year 2024 |  | [NAME]
2025-01-01 00:00:00 | M006 | [NAME] | 500 |  |  | Year 2025 |  | Expencess
2025-01-21 00:00:00 | M007 | [NAME] | 500 |  |  | Year 2026 |  | Total
2025-01-01 00:00:00 | M008 | Sunita R Madne | 500 |  |  | Year 2027 |  | Prev Cash in Hand
2025-01-01 00:00:00 | M009 | [NAME] | 500 |  |  | Year 2028 |  | Bank Balance
2025-02-20 00:00:00 | L001 | Nutan Vishal Bhagare | 5253 |  |  | Year 2029 |  | Loan Amount
2025-05-22 00:00:00 | L001 | Nutan Vishal Bhagare | 5253 |  |  | Year 2030 |  | Cash in Hand
2025-05-22 00:00:00 | L001 | Nutan Vishal Bhagare | 5253
2025-04-26 00:00:00 | L001 | Nutan Vishal Bhagare | 5253
2025-04-27 00:00:00 | L001 | Nutan Vishal Bhagare
2025-02-28 00:00:00 | L003 | Rajjaka A Waghmode | 1500
2025-01-01 00:00:00 | L009 | [NAME]
Spreadsheet: 729753d1619311175-why-isnt-this-working-metric
Sheet: 2021 IND

Name | WEEK STARTING
 |  |  |  |  |  |  |  |  |  |  |  |  |  | AVERAGE | Daily average
GFulton
[NAME]
JBURKHAR
[NAME]
JPushnac
JWhetsel
KCrosby
MHelman
RMarinch
TKeck
HKimble
BWilson
JKachmar
CMaddas
CThomas
Dstevey
MBYERS
Spreadsheet: 219295d1362701668-nested-formula-required-for-two-cell-inputs-and-a-single-cell-output-vlookup-with-datavalidation
Sheet: Vlookup with datavalidation

 |  |  |  |  |  |  |  |  | http://www.excelforum.com/excel-formulas-and-functions/905294-help-required-for-required-formula-task.html
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C12 In_______C13 In______C15 Out
 |  |  |  |  |  |  |  | [NAME] | 1 | 2 |  |  |  |  |  | ___1____________2________Kentec XT
 |  |  |  |  |  |  |  |  | 1 | 4 |  |  |  |  |  | ___1____________4___Kentec XT+ 1 Area 4 Zone
 |  |  |  |  |  |  |  |  | 1 | 6 |  |  |  |  |  | ___1____________6___Kentec XT+ 1 Area 8 Zone
 |  |  |  |  |  |  |  |  | 2 | 2 |  |  |  |  |  | ___2____________2___Kentec XT+ 2 Area 2 Zone
 |  |  |  |  |  |  |  |  | 2 | 4 |  |  |  |  |  | ___2____________4___Kentec XT+ 2 Area 4 Zone
 |  | 3 |  |  |  |  |  |  | 2 | 6 |  |  |  |  |  | ___2____________6___Kentec XT+ 2 Area 8 Zone
 |  | 6 |  |  |  |  |  |  | 3 | 2 |  |  |  |  |  | ___3____________2___Kentec XT+ 3 Area 2 Zone
 |  |  |  |  |  |  |  |  | 3 | 4 |  |  |  |  |  | ___3____________4___Kentec XT+ 3 Area 4 Zone
 |  |  |  |  |  |  |  |  | 3 | 6 |  |  |  |  |  | ___3____________6___Kentec XT+ 3 Area 8 Zone
 |  |  |  |  |  |  |  |  | 4 | 2 |  |  |  |  |  | ___4____________2___Kentec XT+ 4 Area 2 Zone
 |  |  |  |  |  |  |  |  | 4 | 4 |  |  |  |  |  | ___4____________4___Kentec XT+ 4 Area 4 Zone
 |  |  |  |  |  |  |  |  | 4 | 6 |  |  |  |  |  | ___4____________6___Kentec XT+ 4 Area 8 Zone
 |  |  | Lookup table
 |  |  | 1 | 2 |  | [NAME]
 |  |  | 1 | 4 |  | Kentec XT+ 1 Area 4 Zone
 |  |  | 1 | 6 |  | Kentec XT+ 1 Area 8 Zone
 |  |  | 2 | 2 |  | Kentec XT+ 2 Area 2 Zone
 |  |  | 2 | 4 |  | Kentec XT+ 2 Area 4 Zone
 |  |  | 2 | 6 |  | Kentec XT+ 2 Area 8 Zone
 |  |  | 3 | 2 |  | Kentec XT+ 3 Area 2 Zone
 |  |  | 3 | 4 |  | Kentec XT+ 3 Area 4 Zone
 |  |  | 3 | 6 |  | Kentec XT+ 3 Area 8 Zone
 |  |  | 4 | 2 |  | Kentec XT+ 4 Area 2 Zone
 |  |  | 4 | 4 |  | Kentec XT+ 4 Area 4 Zone
 |  |  | 4 | 6 |  | Kentec XT+ 4 Area 8 Zone
 |  |  | Datavalidation lists
 |  |  | 1 | 2
 |  |  | 2 | 4
 |  |  | 3 | 6
 |  |  | 4