tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 889214d1739950196-formula-for-dates-to-know-which-date-on-current-year-before-2-months-of-recontract-date-book1x
Sheet: Sheet1

 |  |  |  | [NAME] | [NAME]
 | ID | Employee Name | Location | Hiring Date | Date this Current year - 60 Days(2months) before the recontracting to send email to the manager to renew the contract of not
 | 82393 | [NAME] | Cott Company | 2012-06-16 | 2025-04-16 00:00:00 | formula in the yellow highlighted
 | 82394 | [NAME] | Mitt Company | 2016-06-23 | 2025-04-23 00:00:00
 | 82395 | Reg Runio | Dess Company | 2019-07-25 | 2025-05-25 00:00:00
 |  |  |  | 2012-06-16
 |  |  |  | 2015-02-01
 |  |  |  | 2013-04-01
 |  |  |  | 2020-05-05
 |  |  |  | 2020-09-23
 |  |  |  | 2021-03-01
 |  |  |  | 2016-06-23
 |  |  |  | 2016-02-21
 |  |  |  | 2019-07-25
 |  |  |  | 2021-12-19
 |  |  |  | 2022-03-14
 |  |  |  | 2022-01-01
 |  |  |  | 2024-12-15
 |  |  |  | 2017-09-25
 |  |  |  | 2020-10-25
 |  |  |  | 2019-02-26
 |  |  |  | 2015-08-01
 |  |  |  | 2017-07-16
 |  |  |  | 2018-02-11
 |  |  |  | 2018-04-01
 |  |  |  | 2018-04-01
 |  |  |  | 2012-08-25
 |  |  |  | 2017-03-09
 |  |  |  | 2017-02-15
 |  |  |  | 2015-02-08
 |  |  |  | 2015-10-27
 |  |  |  | 2015-10-27
 |  |  |  | 2016-02-07
 |  |  |  | 2016-05-18
 |  |  |  | 2013-06-16
 |  |  |  | 2014-06-29
 |  |  |  | 2017-09-17
 |  |  |  | 2016-11-16
 |  |  |  | 2019-11-16
 |  |  |  | 2019-02-26
 |  |  |  | 2019-06-08
 |  |  |  | 2018-05-12
 |  |  |  | 2018-08-01
 |  |  |  | 2018-10-16
 |  |  |  | 2019-12-16
 |  |  |  | 2016-05-03
 |  |  |  | 2016-04-10
 |  |  |  | 2017-10-25
 |  |  |  | 2017-10-12
 |  |  |  | 2020-09-02
 |  |  |  | 2021-02-14
 |  |  |  | 2021-05-01
 |  |  |  | 2021-04-28
 |  |  |  | 2021-04-28
 |  |  |  | 2021-04-28
 |  |  |  | 2021-06-07
 |  |  |  | 2020-09-21
 |  |  |  | 2021-03-28
 |  |  |  | 2021-06-20
 |  |  |  | 2021-07-25
 |  |  |  | 2021-07-25
 |  |  |  | 2021-04-25
 |  |  |  | 2021-10-03
 |  |  |  | 2021-10-03
 |  |  |  | 2021-04-03
 |  |  |  | 2021-12-23
 |  |  |  | 2022-01-04
 |  |  |  | 2024-03-05
 |  |  |  | 2022-04-03
 |  |  |  | 2022-05-09
 |  |  |  | 2022-05-12
 |  |  |  | 2022-08-01
 |  |  |  | 2022-08-01
 |  |  |  | 2022-08-07
 |  |  |  | 2022-09-04
 |  |  |  | 2022-08-22
 |  |  |  | 2022-08-22
 |  |  |  | 2022-08-22
 |  |  |  | 2022-09-01
 |  |  |  | 2022-10-10
 |  |  |  | 2023-06-06
 |  |  |  | 2022-12-07
 |  |  |  | 2023-01-10
 |  |  |  | 2022-12-07
 |  |  |  | 2023-01-11
 |  |  |  | 2023-03-07
 |  |  |  | 2023-03-09
 |  |  |  | 2023-05-07
 |  |  |  | 2023-05-06
 |  |  |  | 2023-05-14
 |  |  |  | 2024-01-15
 |  |  |  | 2024-01-21
 |  |  |  | 2024-01-21
 |  |  |  | 2024-02-01
 |  |  |  | 2024-06-01
 |  |  |  | 2024-06-02
 |  |  |  | 2024-06-02
 |  |  |  | 2024-06-27
 |  |  |  | 2024-07-07
 |  |  |  | 2024-06-02
 |  |  |  | 2024-07-30
 |  |  |  | 2024-08-04
 |  |  |  | 2024-09-01
 |  |  |  | 2024-11-03
 |  |  |  | 2024-10-21
 |  |  |  | 2024-11-06
 |  |  |  | 2024-11-19
 |  |  |  | 2024-11-27
 |  |  |  | 2024-11-25
 |  |  |  | 2024-12-04
 |  |  |  | 2024-09-01
 |  |  |  | 2024-12-29
 |  |  |  | 2025-01-11
 |  |  |  | 2022-11-27
 |  |  |  | 2024-12-04
 |  |  |  | 2023-03-01
 |  |  |  | 2023-02-15
 |  |  |  | 2023-09-23
Spreadsheet: 330197d1404602693-complex-sumif-jwillis07-example-2
Sheet: Sheet2

 | A |  |  | B |  |  | C
 | x | y | z | x | y | z | x | y | z
1
2
3
4
Spreadsheet: 110714d1307344605-creat-top-10-list-book1
Sheet: Sheet2

name
xyz
xyz |  |  |  | 4.00012 | zuv
abc |  |  |  | 4.00011 | abc
abc |  |  |  | 3.00015 | jjj
zuv |  |  |  | 3.00008 | xyz
zuv |  |  |  | 1.00007 | zbor
 | 7e-05 |  |  | 0.00016 | 0
 | 7e-05 |  |  | 0.00016 | 0
 | 7e-05 |  |  | 0.00016 | 0
zbor | 1.00007 |  |  | 7e-05 | 0
xyz | 3.00008 |  |  | 7e-05 | 0
zuv |  |  |  | 7e-05 | 0
abc
abc | 4.00011
zuv | 4.00012
jjj
jjj
jjj | 3.00015
 | 0.00016
 | 0.00016
 | 0.00016
Spreadsheet: 685663d1594133577-vlookup-or-if-trial
Sheet: Sheet1

 | Jan-20
FS-1 | 1-7 | 8-15 | 16-23 | 24-31
Lead | Smith | Smith
Slot 2 | Doe | [NAME]
Slot 3 | [NAME]
FS-2
Lead | [NAME] | Doe | Smith
Slot 2
Slot 3
FS-3
Lead |  | [NAME] |  | Smith
Slot 2 |  |  | Doe
Slot 3
FS-4
Lead |  |  | [NAME] | [NAME]
 | Jan-20
 | 1-7 | 8-15 | 16-23 | 24-31
Smith | FS-1 | FS-1 | FS-2
Doe
[NAME]
[NAME]
Spreadsheet: 841364d1693552207-match-date-on-two-different-pages-and-paste-data-in-columns-copy-of-copy-of-ef-file-
Sheet: 3-1 night

 | CR1 | Priority | Headcount
1 | Alinity RV | 9 | 0.25
2 | Alinity RV | 8 | 0.25
3 | Alinity RV | 10 | 0.25
4 | Alinity RV | 11 | 0.25
5 | Alinity RV | 12 | 0.25
12 | [NAME] | 24 |  | QI to support, if QI cannot support - then shutdown
13 | [NAME] | 20 | 0.25
9 | Architect RV | 16 | 0.25
15 | Sample Cup / Lid tray | 2 | 0.5
16 | Architect RV | 19 | 0.25
17 | Alinity RV | 7 | 0.25
50 | Baxter SIV Assy |  |  | keep down
31 | Architect RV | 3 | 0.25
8 | Alinity RV | 4 | 0.25
10 | Architect RV | 5 | 0.25
11 | [NAME] | 23 |  | shut down
18 | Architect RV | 17 | 0.25
19 | Architect RV | 18 | 0.25
20 | Base sleeve | 22 | 2.5 | if need to - run 2-3 hours with .5 operator to build up carts and then packout, the other operators can help with labels
21 | Architect RV | 13 | 0.25
22 | Architect RV | 14 | 0.25
23 | Architect RV | 15 | 0.25
30 | Architect RV | 6 | 0.25
7 | Architect SC | 1 | 0.25
Total
 | CR2 | Priority
71 | PP4 | 5 | 0.25
72 | 8ul | 4 | 0.25
73 | PP1 | 6 | 0.25
74 | 6 UL | 3 | 0.25
76 | PP3 ES
77 | Base Cassette | 2 | 0.75
78 | Side Cassette B | 1 | 0.25
79 | [NAME] | 7 | 0.25
87 | Top Frame A | 8 | 0.25
52 | Architect RV | 10 | 0.25
53 | Architect RV | 9 | 0.25
54 | Siemens KS860 | 17 |  | shut down
59 | Architect RV | 11 | 0.25
61 | [NAME] trays | 14 | 0.5 |  |  |  |  |  | mo |  | 13
66 | [NAME] | 15 | 0.5 |  |  |  |  |  | tues | 20 | 17
83 | Ceph OM#1 |  |  |  |  |  |  |  |  |  | 18
84 | Ceph MB#1 | 22 |  | shut down after PQ run
86 | [NAME] | 21
62 | NP227 | 18
63 | NP Birdcage
64 | Siemens 1ML
67 | [NAME] | 16 | 0.25
69
88 | Side Pump | 12
89 | Top Frame B | 13 | 0.25
95 | Beckman Unicel E
96 | Beckman Unicel F
106
107 | Snap Ring | 21 |  | shut down
108
109 | [NAME]
Total
 | [NAME] |  | 1.25 | [NAME]/material handler to help with labels?
 | [NAME] |  | 0 | leads to do relief trainer
 | # of operators tonight |  | 13 | two people on overtime, lead to be relief trainer
Spreadsheet: de4edb05-891b-499d-a9eb-22023ecb5d3a
Sheet: Sheet1

Lowe's Companies, Inc. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19
Consolidated Statements of Current and Retained Earnings (Unaudited)
In Millions, Except Per Share Data
 |  | Three Months Ended |  |  |  |  | Nine Months Ended
 |  | 2008-10-31 00:00:00 |  | 2007-11-02 00:00:00 |  |  | 2008-10-31 00:00:00 |  | 2007-11-02 00:00:00
Current Earnings |  | Amount | Percent | Amount | Percent |  | Amount | Percent | Amount | Percent
Net sales |  | 11728000000 | 100 | 11565000000 | 100 |  | 38246000000 | 100 | 37904000000 | 100 |  |  |  |  |  |  | 38246359916.15 |  | 37903663786.32999
Cost of sales |  | 7743000000 | 66.02 | 7601000000 | 65.73 |  | 25113000000 | 65.66 | 24798000000 | 65.42
Gross margin |  | 3985000000 | 33.98 | 3964000000 | 34.27 |  | 13133000000 | 34.34 | 13106000000 | 34.58
Expenses:
Selling, general and administrative |  | 2726000000 | 23.23 | 2503000000 | 21.63 |  | 8464000000 | 22.13 | 8026000000 | 21.17
Store opening costs |  | 31000000 | 0.27 | 41000000 | 0.36 |  | 70000000 | 0.18 | 79000000 | 0.21
Depreciation |  | 385000000 | 3.29 | 340000000 | 2.94 |  | 1142000000 | 2.99 | 995000000 | 2.63
Interest - net |  | 65000000 | 0.56 | 50000000 | 0.43 |  | 210000000 | 0.55 | 148000000 | 0.39 |  |  |  |  |  |  | 210145426.91 |  | 147572670.64
Total expenses |  | 3207000000 | 27.35 | 2934000000 | 25.36 |  | 9886000000 | 25.85 | 9248000000 | 24.4
Pre-tax earnings |  | 778000000 | 6.63 | 1030000000 | 8.91 |  | 3247000000 | 8.49 | 3858000000 | 10.18
Income tax provision |  | 290000000 | 2.47 | 387000000 | 3.35 |  | 1214000000 | 3.17 | 1457000000 | 3.85
Net earnings |  | 488000000 | 4.16 | 643000000 | 5.56 |  | 2033000000 | 5.32 | 2401000000 | 6.33
Weighted average shares outstanding - basic |  | 1459000000 |  | 1470000000 |  |  | 1456000000 |  | 1490000000
Basic earnings per share |  | 0.33 |  | 0.44 |  |  | 1.4 |  | 1.61
Weighted average shares outstanding - diluted |  | 1464000000 |  | 1497000000 |  |  | 1473000000 |  | 1519000000
Diluted earnings per share |  | 0.33 |  | 0.43 |  |  | 1.38 |  | 1.58
Cash dividends per share |  | 0.085 |  | 0.08 |  |  | 0.25 |  | 0.21
[NAME]
Balance at beginning of period |  | 16648000000 |  | 15210000000 |  |  | 15345000000 |  | 14860000000
Cumulative effect [NAME] |  | 0 |  | 0 |  |  | 0 |  | -8000000
Net earnings |  | 488000000 |  | 643000000 |  |  | 2033000000 |  | 2401000000
Cash dividends |  | -124000000 |  | -118000000 |  |  | -366000000 |  | -312000000
Share repurchases |  | 0 |  | -454000000 |  |  | 0 |  | -1660000000
Balance at end of period |  | 17012000000 |  | 15281000000 |  |  | 17012000000 |  | 15281000000
1 The Company adopted FIN 48, "Accounting for Uncertainty in Income Taxes", effective February 3, 2007.
Spreadsheet: 693150d1598805374-how-do-i-add-data-to-a-sheet-without-messing-up-the-formatting-for-the-whole-workbook-problems
Sheet: Data

 | Date | Name | Hours
 | 2020-08-01 00:00:00 | Adams, Bob | 10
 | 2020-08-01 00:00:00 | [NAME], [NAME] | 10
 | 2020-08-01 00:00:00 | Edwards, [NAME] | 10
 | 2020-08-01 00:00:00 | Smith, [NAME] | 10
 | 2020-08-02 00:00:00 | Adams, Bob | 8
 | 2020-08-02 00:00:00 | [NAME], [NAME] | 8
 | 2020-08-02 00:00:00 | [NAME], Charles | 8
 | 2020-08-02 00:00:00 | [NAME], [NAME] | 8
 | 2020-08-02 00:00:00 | Edwards, [NAME] | 8
 | 2020-08-02 00:00:00 | [NAME], Anne | 8
 | 2020-08-02 00:00:00 | Gonzales, George | 8
 | 2020-08-02 00:00:00 | Smith, [NAME] | 8
 | 2020-08-15 00:00:00 | Credence, [NAME] | 8
 | 2020-08-15 00:00:00 | [NAME], [NAME] | 8
 | 2020-08-15 00:00:00 | Edwards, [NAME] | 8
 | 2020-08-15 00:00:00 | Hernandez, [NAME] | 8
 | 2020-08-16 00:00:00 | [NAME], Charles | 8
 | 2020-08-16 00:00:00 | Credence, [NAME] | 8
 | 2020-08-16 00:00:00 | [NAME], Anne | 8
 | 2020-08-16 00:00:00 | Gonzales, George | 8
 | 2020-08-16 00:00:00 | Hernandez, [NAME] | 8
 | 2020-08-22 00:00:00 | [NAME], Charles | 8
 | 2020-08-22 00:00:00 | Edwards, [NAME] | 8
 | 2020-08-22 00:00:00 | Smith, [NAME] | 8
 | 2020-08-22 00:00:00 | [NAME], [NAME] | 8
 | 2020-08-22 00:00:00 | [NAME], [NAME] | 8
 | 2020-08-22 00:00:00 | Edwards, [NAME] | 8
 | 2020-08-22 00:00:00 | [NAME], Anne | 8
 | 2020-08-29 00:00:00 | Adams, Bob | 8
 | 2020-08-29 00:00:00 | [NAME], [NAME] | 8
 | 2020-08-29 00:00:00 | Gonzales, George | 8
 | 2020-08-29 00:00:00 | Hernandez, [NAME] | 8
 | 2020-08-30 00:00:00 | Adams, Bob | 12
 | 2020-08-30 00:00:00 | Edwards, [NAME] | 12
 | 2020-08-30 00:00:00 | Hernandez, [NAME] | 12
 | 2020-08-30 00:00:00 | Smith, [NAME] | 12
 | 2020-09-01 00:00:00 | [NAME], [NAME] | 8
 | 2020-09-01 00:00:00 | Gonzales, George | 8
 | 2020-09-01 00:00:00 | Smith, [NAME] | 8
 | 2020-09-02 00:00:00 | Adams, Bob | 10
 | 2020-09-02 00:00:00 | Edwards, [NAME] | 10
 | 2020-09-02 00:00:00 | Gonzales, George | 10
 | 2020-09-02 00:00:00 | Smith, [NAME] | 10
 | 2020-09-15 00:00:00 | Edwards, [NAME] | 8
 | 2020-09-15 00:00:00 | Smith, [NAME] | 8
 | 2020-09-16 00:00:00 | Credence, [NAME] | 4
 | 2020-09-22 00:00:00 | [NAME], [NAME] | 8
 | 2020-09-22 00:00:00 | Gonzales, George | 8
 | 2020-09-22 00:00:00 | Edwards, [NAME] | 8
 | 2020-09-22 00:00:00 | Smith, [NAME] | 8
 | 2020-09-29 00:00:00 | Smith, [NAME] | 8
 | 2020-09-30 00:00:00 | Adams, Bob | 12
 | 2020-09-30 00:00:00 | Smith, [NAME] | 12
Spreadsheet: 106318d1303489471-excel-2007-calculating-from-one-sheet-to-another-excel-help
Sheet: Wise Totals

Wise Global Training  Monthly Sales Record -
 |  | Course fee | Exam reg fee
NEBOSH NGC eLearning
NGC eLearning Totals |  | 0 | 0
NEBOSH NGC Classroom
NGC Classroom Totals |  | 0 | 0
IOSH Managing Safely eLearning
IOSH Managing Safely eLearningTotals |  | 0 | 0
IOSH Classroom
IOSH Managing Safely Classroom Totals: |  | 0 | 0
CIEH Classsroom
CIEH Classroom Totals: |  | 0 | 0
Non-Accredited Classroom
Non-Accredited Totals: |  | 0 | 0
 |  | Course fee | Exam reg fee
Month Total: £
Spreadsheet: 288964d1389361118-time-study-continuous-running-clock-mixed-with-stops-timestudy
Sheet: Sheet1

 | Trial |  |  |  |  |  |  |  |  |  |  | IGNORE>> | 20
Step | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 |  |  |  | 12
a | 1 | 14 | 2 | 2 | 73 |  |  |  |  |  |  |  | 45
b | 2 | 18 | 5 | 21 | 78 |  |  |  |  |  |  |  | 1.25
c | 3 | 22 | 8 | 28 | 81 |  |  |  |  |  |  |  | 1.15
d | 5 | 27 | 9 | 35 | 85 |  |  |  |  |  |  |  | 1.48
e | 8 | 35 | 12 | 45 | 88
f
g
h
 |  | Trial Time |  |  |  |  |  |  |  |  |  | Average Trial Time |  | Total Step Time
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
Step Time
a
b
c
d
e
f
g
h
Spreadsheet: benjamin_rogers__1264__NewCo-7-15-00
Sheet: Maine Hydro

INCOME STATEMENT - Maine Hydro
('000 $) |  |  | 1999 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | Net Total
Revenue
PPA Period:
Demand Payment
Energy Payment
Block Payment
Market Period:
Demand Payment
Variable Revenue
Energy Margin
Interest Income
Total Revenue
Expense
Fuel  (Includes Fixed Transportation)
Fixed O&M
Variable O&M
Major Maintenance & Ongoing Capex (Cash)
Insurance
SG&A
Utility Start Up Power (included in O&M)
Property, Other Taxes
Debt Service L/C Fee
Marketing Fee
Administrative Fee
O&M Fees
Total Expense
EBITDA
Depreciation & Amortization
EBIT
Interest Expense
EBT
Book State Tax Benefit / (Expense) |  | 0.089
Shareholder Fed. Tax Benefit / (Expense) |  | 0.35
Net Income
CASH FLOW - Maine Hydro
FPLE Interest |  | 1
('000 $) |  |  | 1999
EBITDA
Capital Expenditures |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Debt Service
Pre Tax Cash Flow
Cash Taxes Benefit (Expense)
After Tax Cash Flow
Net Income to FPLE
Distributable Cash to FPLE
Valuation
Pre Tax Cash Flow
Tax Benefit / (Expense)
Residual Value |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
After Tax Cash Flow |  |  |  | -452550.070512004
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Residual Value
NPV |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020 EBITDA
Equity Discount Rate |  | 0.1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Adjustment Factor |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Adjusted EBITDA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EBITDA Multiple |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Residual Value
Depreciable Basis
Debt (12/31/00) |  |  | 0
Equity
Percent Depreciable |  |  | 0.8
Depreciable Basis
GAAP Depreciation
Life | 30 | SL
Additional Depreciation @ FPLE
Tax Depreciation
Basis
Depreciation Rate: 20 Year 150% MACRS HY |  |  |  |  | 0.0375 | 0.07219 | 0.06677 | 0.06177 | 0.05713 | 0.05285 | 0.04888 | 0.04522 | 0.04462 | 0.04461 | 0.04462 | 0.04461 | 0.04462 | 0.04461 | 0.04462 | 0.04461 | 0.04462 | 0.04461 | 0.04462 | 0.04461
Tax Depreciation
Additional Depreciation @ FPLE
Taxable Income
Tax Depreciation
Interest Expense
Taxable Income
State Income Tax
Federal Income Tax
FPLE Net Income
Interest Income - Loan Receivable |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Fee Income
Total Other Income
State Taxes
Federal Taxes
Net Income from Interest and Fee to FPLE
Total FPLE Net Income
FPLE Other Cash Flows  (Loan Receivable valued at principal)
Aftertax cash from Fee Income
Other |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NPV
Equity Discount Rate |  | 0.1
Valuation of FPLE's Project Interest
FPLE's Share of Project
Note Receivable |  |  | 0
PV of Fee Income
Value of FPLE's Interest
 |  | [NAME]
 |  | Beginning Balance
 |  | [NAME]
 |  | Ending Balance
 |  | Interest Expense
 |  | Aftertax Interest Expense
 |  | Debt Service
 |  | Resultant Coverage Ratio
Spreadsheet: 848756d1699391771-how-to-combine-multiple-formulas-example-file
Sheet: Sheet1

State | Name | Result
TX | 401K BATCH #06
FLO | 401K BATCH #09
MS | TAX BATCH #44
NJ | TAX BATCH #99
NY | OR-SUIER
SC |  | Need formula here to get result 401K
Spreadsheet: 757499d1638293125-dynamic-drop-down-list-box-dilemma-demo
Sheet: List

1941 |  | Unique & sorted
1962
1941
1918
1874
1872
1931
1941
1962
1955
1941
1962
1941
1918
1874
1872
1931
1941
1962
1955
Spreadsheet: 490951d1480189283-creating-a-pivot-table-participants-by-month-when-i-only-have-the-start-and-end-dates-help_needed_example
Sheet: Sheet1

ID | Course start date | Course end date | Course outcome
1 | 2012-08-28 00:00:00 | 2012-10-02 00:00:00 | refused
2 | 2012-09-04 00:00:00 | 2012-10-02 00:00:00 | finished
3 | 2012-09-30 00:00:00 | 2012-10-02 00:00:00 | finished
4 | 2012-10-02 00:00:00 | 2012-10-02 00:00:00 | refused
5 | 2012-10-02 00:00:00 | 2012-10-02 00:00:00 | finished
6 | 2012-10-02 00:00:00 | 2012-10-02 00:00:00 | finsihed
7 | 2012-10-02 00:00:00 | 2012-10-02 00:00:00 | started but didn't finish
8 | 2012-08-21 00:00:00 | 2012-10-03 00:00:00 | finsihed
9 | 2012-08-26 00:00:00 | 2012-10-03 00:00:00 | finsihed
10 | 2012-09-04 00:00:00 | 2012-10-03 00:00:00 | started but didn't finish
11 | 2012-09-04 00:00:00 | 2012-10-03 00:00:00 | finished
12 | 2012-09-09 00:00:00 | 2012-10-03 00:00:00 | finished
13 | 2012-09-09 00:00:00 | 2012-10-03 00:00:00 | started but didn't finish
14 | 2013-01-13 00:00:00 | 2013-01-16 00:00:00 | refused
15 | 2013-01-13 00:00:00 | 2013-01-16 00:00:00 | refused
16 | 2013-01-13 00:00:00 | 2013-01-16 00:00:00 | finished
17 | 2012-06-27 00:00:00 | 2013-01-17 00:00:00 | started but didn't finish
18 | 2012-07-15 00:00:00 | 2013-01-17 00:00:00 | finished
19 | 2012-09-30 00:00:00 | 2013-01-17 00:00:00 | started but didn't finish
Spreadsheet: 714317d1611169395-formula-link-between-2-sheets-in-attesa
Sheet: in_attesa

POS. | ARTICOLO | DESCRIZIONE | U.M. | Q.TA'  DISP. | Q.TA'  MIN | Q.TA'  DA ORD | COSTO UNIT. € | FORNITORE | ORDINATO MAIL | ORDINATO MANUALE | DATA  ORDINE
M-98 | 9900015811 | AAAABBB3 | NR | 0 | 9 | 9 | 7 | AAA130 | NO
N-18 | 609400234 | AAAABBB12 | NR | 1 | 9 | 99 | 5 | AAA74 | NO
Q-01 | 9900014460 | AAAABBB13 | NR | 1 | 8 | 8 | 8 | AAA5 | NO
X-25 | 9900014673 | AAAABBB19 | NR | 2 | 5 | 8 | 2 | AAA121 | NO
Spreadsheet: 818772d1677046670-trouble-with-significant-figures-significant-figure-challenges
Sheet: Sheet1 (2)

Here is an example of raw data of various magnitude |  |  |  |  |  |  | 3 | Significant figure |  | times | text to add
 |  | No. of digits before decimal point | Roundding required | Rounded | Decimal point? | [NAME] without decimal point | [NAME] point to add | No. of Zero to add | To add | Final Formula | Combined Formula | Summarised with LET
Entry 1 | 1.2
Entry 2 | 5.023654
Entry 3 | 5
Entry 4 | 10258.60105
Entry 5 | 205.32154674
Entry 6 | 1025860105
Entry 7 | 21.0052
Entry 8 | 23.2101
Entry 9 | 500.0025
Entry 10 | 2140.261
I want to round to 3 significant figures (note: originally I had a problem with excel automatically dropping trailing zeros)
 | Rounded result | Notes on Challenge
Entry 1
Entry 2
Entry 3 |  | This should  say 5.00 but excel has dropped the trailing zeros
Entry 4
Entry 5
Entry 6
Entry 7 |  | This should  say 21.0 but excel has dropped the trailing zeros
Entry 8
Entry 9
Entry 10
To get around this, I have added some conditional formattiong (shown on the right) to asess the magnatiude of the cell and specify the decimal points
 | Rounded result
Entry 1
Entry 2 |  |  |  |  |  |  |  |  |  |  |  | Note on conditional formatting: this is only required for cells <100 because above that, the formula will perform the rounding without dropping the trailing zeros
Entry 3
Entry 4
Entry 5
Entry 6
Entry 7
Entry 8
Entry 9
Entry 10
After this, I want the ability to manually remove some points and add a note (in this case it will say "a" with a footnote somewhere else explaining this.
I also want to generate statisical data for the original results, and the results without footnotes.
 | Rounded result | Manually remove
Entry 1
Entry 2
Entry 3 |  | yes
Entry 4
Entry 5
Entry 6 |  | yes
Entry 7
Entry 8
Entry 9
Entry 10
 | Rounded result (with footnote) | I have also tried keeping the Significant Figure formula to obtain the Rounded result (with footnote) | Notes on Challenge
Entry 1
Entry 2
Entry 3 |  |  | I want this to say "5.00 a" but if my result is less than 100, and has a 0 as the third significant figure. I am not able to get it to work
Entry 4
Entry 5
Entry 6 |  |  | This entry (magnitude above 100) has worked properly.
Entry 7 |  |  | In this case (without a footnote) excel has not dropped the trailing zero. This is what I want.
Entry 8
Entry 9
Entry 10
 | [NAME] applied to all results | [NAME] applied to results without footnotes | Notes
Average |  |  | These are working fine but it is something to keep in mind if the formula to solve the above problem changes in a way such that they don't work
St. Dev.
Spreadsheet: 879381d1726853133-dept-and-date-to-auto-calculate-based-on-todays-date-book1-6-
Sheet: Sheet2

 |  | Shift
 | Dept | 1 | 2 | 3
 | Grocery
 | Deli
 | Meat
 | Freezer
 | Produce
Spreadsheet: 21589d1209296209-combining-cells-to-a-separate-spreadsheet-meetings
Sheet: Sheet1

MEETING
European and International Orthopaedic Societies
EFORT Congress
BVOT
CAO
EATES
EFAS
EFORT Instructional Course
EORS
EPOS
ESSKA Congress
ESSSE /SECEC
ETS
[NAME]
IFFAS
ISAKOS
ISFR
SICOT
SIOT
SOFCOT
British Orthopaedic Society meetings
[NAME]
BASS
BESS
BHS
BOA
BOFSS
BOOS
BORS
BOSTA
BSCOS
BSS
BSSH
BTS
CAOSUK
SBPR
SBPR
American Orthopaedic Associations
AAOS
OTA
ORS
AOSSM
AANA
ACSM
Knee Society
AOASSN
POSNA
AAHKS
MSTS
ASIA
ASSH
ASES
AOFAS
LLRS ASAMI -NA
Indian Orthhopaedic Associations
IOACON
Australian Orthopaedic Associations
AOA
New Zealand Orthopaedic Associations
NZOA
Canadian Orthopaedic Associations
COA
South African Orthopaedic Associations
SAOA
Spreadsheet: 808726d1670602111-excel-if-statement-multiple-conditions-range-satya
Sheet: Sheet1

0 | 0.0075 | 0.0075 |  | 19000000
5000000 | 0.015
10000000 | 0.0175
15000000 | 0.02
19000000 | 0.0225
http://www.mcgimpsey.com/excel/variablerate.html
Spreadsheet: 119943d1314879400-inserting-rows-across-sheets-komet12_testing
Sheet: changesmade

Randal | 2011-08-31 00:00:00 | $J$23 | 33 | 33
Randal | 2011-08-31 00:00:00 | $3:$3
Randal | 2011-08-31 00:00:00 | $2:$2 | Abate | Abate
Randal | 2011-08-31 00:00:00 | $7:$7
Randal | 2011-08-31 00:00:00 | $6:$6 | Adams | Adams
Spreadsheet: 1ef50df9-fd95-4868-9812-e00d22eb4d07
Sheet: 11d

 | Swap Dealers/MSPs5 |  | Others
Product1 | Cleared2 | Uncleared | Cleared | Uncleared
Cross-Currency Basis | - | 567 | - | 221
Cross-Currency Fixed-Fixed | - | 90 | - | 80
Cross-Currency Fixed-Float | - | 203 | - | 117
TOTAL | - | 860 | - | 418
Spreadsheet: 885751d1735586982-how-to-remove-specific-text-only-from-the-first-few-characters-sample-bbfdsue
Sheet: Sheet1

NCMOEMIK
XXVINCUS
XXVINCUS
VINCUS
NCROOFRU
RRANCH
INCCON
NCMANCAP
NCREICHA
NCSILNOR
KBRANC
NCROOFRU
OHMENCO
NCGONJER
NCGONJER
XXPKENCO
NCSILNOR