tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 145687d1331710707-autofill-across-worksheets-sample-workbook
Sheet: Cost Estimate

 |  | COST ESTIMATES FORM
 |  |  |  | Year 3 |  |  |  | Year 4 |  |  |  | Year 5
 |  |  | Qtr. 1 | Qtr. 2 | Qtr. 3 | Qtr. 4 | Qtr. 1 | Qtr. 2 | Qtr. 3 | Qtr. 4 | Qtr. 1 | Qtr. 2 | Qtr. 3 | Qtr. 4
1 | Production | Labor | 13890 | 11945 | 12654 | 16605 | 20438 | 20438 | 2038 | 18270 | 16762 | 16268 | 18123 | 14937
2 |  | Raw Material | 13673 | 12953 | 13678 | 12990 | 16800 | 4900 | 18400 | 19050 | 16442 | 16866 | 19073 | 15492
3 |  | Maintenance | 2083 | 1792 | 1898 | 2491 | 3066 | 3066 | 3066 | 2740 | 2514 | 2440 | 2719 | 2240
4 |  | Training | 20 | 30 | 50 | 100 | 250 | 500 | 500 | 500 | 500 | 500 | 200 | 200
5 |  | Production Level Change | 60 | 0 | 401 | 1201 | 602 | 0 | 0 | 0 | 0 | 80 | 0 | 200
6 |  | Equipment Replacement | 1367 | 1295 | 1368 | 1299 | 1680 | 490 | 1840 | 1905 | 1644 | 1687 | 1907 | 1549
7 |  | Production Administration | 1099 | 1000 | 1050 | 1333 | 1687 | 1890 | 2125 | 2241 | 2402 | 2576 | 2855 | 2472
8 |  | Total Production Cost
9 | Marketing | Advertising | 950 | 1130 | 1170 | 1170 | 1190 | 1300 | 1280 | 1225 | 1290 | 1330 | 1485 | 1760
10 |  | Sales Salaries | 270 | 293 | 298 | 356 | 386 | 462 | 462 | 404 | 383 | 373 | 346 | 351
11 |  | Sales Commissions | 203 | 430 | 492 | 1062 | 1567 | 1847 | 2964 | 3277 | 3328 | 6190 | 8981 | 10499
12 |  | Transportation | 1131 | 996 | 1037 | 1475 | 2037 | 2358 | 2729 | 2912 | 3178 | 3456 | 3899 | 3290
13 |  | [NAME] | 2826 | 2924 | 2805 | 2993 | 3004 | 3105 | 3532 | 3583 | 3449 | 4031 | 4665 | 4978
14 |  | Sales Force Change | 42 | 82 | 66 | 42 | 66 | 82 | 0 | 29 | 0 | 0 | 0 | 0
15 |  | Marketing Administration | 30 | 40 | 50 | 100 | 250 | 500 | 500 | 750 | 200 | 200 | 200 | 200
16 |  | Total Marketing Cost
17 | Other | Research and Development | 115 | 135 | 500 | 700 | 1000 | 1300 | 1300 | 1300 | 1200 | 1000 | 470 | 450
18 |  | Fin. Prod. [NAME] | 172 | 150 | 12 | 0 | 2 | 319 | 0 | 298 | 752 | 1755 | 2454 | 2622
19 |  | Fin. Prod. [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
20 |  | Fin. Prod. [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
21 |  | Raw Mat. Carrying Cost | 237 | 186 | 151 | 129 | 160 | 40 | 160 | 200 | 234 | 240 | 256 | 138
22 |  | Bond Interest | 750 | 1000 | 950 | 900 | 850 | 800 | 750 | 750 | 975 | 1138 | 1203 | 1203
23 |  | Bond Call Premium | 0 | 120 | 120 | 120 | 120 | 120 | 0 | 0 | 0 | 0 | 0 | 300
24 |  | Loan Interest | 0 | 163 | 0 | 0 | 0 | 0 | 0 | 98 | 32 | 0 | 0 | 0
 |  | Other Administration | 4528 | 4624 | 4359 | 5160 | 5202 | 5065 | 6555 | 6949 | 6823 | 8653 | 10992 | 11999
 |  | Total Other Cost
 |  |  | Year 3 | Year 4 | Year 5
 |  | Total Production Cost
 |  | Total Marketing Cost
 |  | Total Other Cost
 |  | Year 3Total Cost |  |  |  |  |  |  | Year 4 Total Cost
 |  | Year 5 Total Cost
Spreadsheet: 47737d1246910100-update-values-based-on-multiple-requirements-example-data
Sheet: Sheet2

Labes/Ranges Names
_350_BBS
_350_Grenade_Launchers
_350_EXO_Suits
_750_Speed_Round_Tokens
_7500_Punk_Cards
_750_Recruits
_750_Grenade_Launchers
_1500_Recruits
_2000_Ghetto_Lotto_Tickets
_150_Arch_Angel_Liquid_Metal_Prototypes
_150_RPG
_2000_Flash_Bombs
_10500_MHead_Pipe_Bombs
_Increase_Hustla_Limit_for_All_Blocks
_Increase_Bookie_Limit_for_All_Blocks
_Increase_Pimp_Limit_for_All_Blocks
_Increase_Balla_Limit_for_All_Blocks
_1_Billion_in_Cash
_4500_Recruits
_Level_Up_Ballas_To_the_Next_Level
_Level_Up_Pimp_To_the_Next_Level
_Level_Up_Bookie_To_the_Next_Level
_Level_Up_Hustla_To_the_Next_Level
_Level_Up_Sentinel_To_the_Next_Level
_Level_Up_Killa_To_the_Next_Level
_Level_Up_SUK_To_the_Next_Level
_Increase_Workers_All_Blocks_x2
Spreadsheet: 0e30daf1-5d56-45c4-aa73-8c45f5a05b6e
Sheet: Cumulative

 |  |  |  | Totals ($)
Section A, Senior/Key Person
Section B, Other Personnel
Total Number Other Personnel
Total Salary, Wages and Fringe Benefits (A+B)
Section C, Equipment
Section D, Travel
1.  Domestic
2.  Foreign
Section E, Participant/Trainee Support Costs
1.  Tuition/Fees/Health Insurance
2.  Stipends
3.  Travel
4.  Subsistence
5.  Other
6.  Number of Participants/Trainees
Section F, Other Direct Costs
1.  Materials and Supplies
2.  Publication Costs
3.  Consultant Services
4.  ADP/Computer Services
5.  Subawards/Consortium/Contractual Costs
6.  Equipment or Facility Rental/User Fees
7.  Alterations and Renovations
8.  Other 1
9.  Other 2
10. Other 3
Section G, Direct Costs (A thru F)
Section H, Indirect Costs
Section I, Total and Indirect Costs (G + H)
Section J, Fee
Spreadsheet: 137744d1327341903-formula-not-working-format-of-cell-book1-1-2
Sheet: Sheet1

Start Date | 2012-01-23 00:00:00
Finish Date
TRADE/DATE
Roofing & Rainwater
Structural
Windows
1st Fix Plumbing
1st Fix Electrics
1st Fix Joinery
Plastering
2nd Fix Joinery
Tiling
2nd Fix Plumbing
Surface Prep
Decorating
2nd Fix Electrics
Flooring
Landscaping
Spreadsheet: 677933d1589596094-pick-cost-based-on-value-purchase-order-sept-2019-example
Sheet: Personnel Only

C2-P48 |  | Make | Model | LCD | Price |  |  |  | OEM | GENERIC | PREMIUM | NCC |  |  | 1
 |  | IPHONE | 5/5 C | OEM | 12 |  |  |  | 5/5 C | 5/5 C | 6 | 6 |  |  | 2
 |  | IPHONE | 5 S | OEM | 13 |  |  |  | 5 S | SE | 6 Plus | 6 Plus |  |  | 3
 |  | IPHONE | 6 | OEM | 18 |  |  |  | 6 | 6 | 6 S | 6 S |  |  | 4
 |  | IPHONE | 6 S | OEM | 22 |  |  |  | 6 S | 6 Plus | 6 S Plus | 6 S Plus |  |  | 5
 |  | IPHONE | 6 Plus | OEM | 25 |  |  |  | 6 Plus | 6 S | 7 Prem/Tianma | 7 |  |  | 6
 |  | IPHONE | 6 S Plus | OEM | 31 |  |  |  | 6 S Plus | 6 S Plus | 7 Plus | 7 Plus |  |  | 7
 |  | IPHONE | 7 | OEM | 29 |  |  |  | 7 | 7 | 8 Prem/Tianma | 8 |  |  | 8
 |  | IPHONE | 7 Plus | OEM | 45 |  |  |  | 7 Plus | 7 With Plate | 8 Plus | 8 Plus |  |  | 9
 |  | IPHONE | 8 | OEM | 42 |  |  |  | 8 | 7 Plus |  |  |  |  | 10
 |  | IPHONE | 8 Plus | OEM | 53 |  |  |  | 8 Plus | 8
 |  | IPHONE | X | OEM | 160 |  |  |  | X | 8 Plus
 |  | IPHONE | X Off Phone | OEM | 165 |  |  |  | X Off Phone | X Hard OLED New
 |  | IPHONE | XR | OEM | 95 |  |  |  | XR | X Soft OLED
 |  | IPHONE | XS | OEM | 170 |  |  |  | XS | XR Copy
 |  | IPHONE | [NAME] | OEM | 235 |  |  |  | [NAME] | XS OLED
 |  | IPHONE | 5/5 C | GENERIC | 9
 |  | IPHONE | SE | GENERIC | 9
 |  | IPHONE | 6 | GENERIC | 10 |  |  |  | IPHONE
 |  | IPHONE | 6 Plus | GENERIC | 15 |  |  |  | OEM
 |  | IPHONE | 6 S | GENERIC | 15 |  |  |  | GENERIC
 |  | IPHONE | 6 S Plus | GENERIC | 18 |  |  |  | PREMIUM
 |  | IPHONE | 7 | GENERIC | 16 |  |  |  | NCC
 |  | IPHONE | 7 With Plate | GENERIC | 17
 |  | IPHONE | 7 Plus | GENERIC | 18
 |  | IPHONE | 8 | GENERIC | 18 |  |  |  | BLACK
 |  | IPHONE | 8 Plus | GENERIC | 20 |  |  |  | WHITE
 |  | IPHONE | X Hard OLED New | GENERIC | 80
 |  | IPHONE | X Soft OLED | GENERIC | 120
 |  | IPHONE | XR Copy | GENERIC | 70
 |  | IPHONE | XS OLED | GENERIC | 130
 |  | IPHONE | 6 | Premium | 13
 |  | IPHONE | 6 Plus | Premium | 18
 |  | IPHONE | 6 S | Premium | 17
 |  | IPHONE | 6 S Plus | Premium | 18.5
 |  | IPHONE | 7 Prem/Tianma | Premium | 18.5
 |  | IPHONE | 7 Plus | Premium | 22.5
 |  | IPHONE | 8 Prem/Tianma | Premium | 22.5
 |  | IPHONE | 8 Plus | Premium | 25
 |  | IPHONE | 6 | NCC | 14.5
 |  | IPHONE | 6 Plus | NCC | 18
 |  | IPHONE | 6 S | NCC | 18
 |  | IPHONE | 6 S Plus | NCC | 22
 |  | IPHONE | 7 | NCC | 19
 |  | IPHONE | 7 Plus | NCC | 23
 |  | IPHONE | 8 | NCC | 23
 |  | IPHONE | 8 Plus | NCC | 25
Spreadsheet: 56197d1256293438-unique-codes-sample-code-data
Sheet: Sheet1

ID | Day | AA | AB | AC | AD | AE | AF | AG | AI | AM
10002 | 1 |  |  |  |  |  | 2 |  |  | 1
 | 2 |  |  |  | 1 |  | 2
 | 3 |  |  |  | 1 |  | 2 |  |  | 1
 | 4 |  |  |  |  |  | 2 |  |  | 2
10002 Total |  |  |  |  | 2 |  | 8 |  |  | 4
10005 | 1 |  |  |  |  |  | 2 |  | 1 | 1
 | 2 |  |  |  |  |  | 1 | 1
 | 3 |  |  |  |  |  | 1 | 1
 | 4 |  |  |  |  |  |  | 1 | 1 | 1
10005 Total |  |  |  |  |  |  | 4 | 3 | 2 | 2
10009 | 1 |  |  |  |  |  | 1 | 1 | 1
 | 2 |  |  |  |  |  | 1 |  | 1 | 1
 | 3 |  |  |  | 1 |  | 2 |  | 1
 | 4 |  |  |  |  |  | 2 |  | 1 | 2
10009 Total |  |  |  |  | 1 |  | 6 | 1 | 4 | 3
Spreadsheet: 765211d1643211949-formula-for-dynamic-schedule-data-sample-schedule
Sheet: Current Shifts

 | 2022-01-05 00:00:00 | <-- "=TODAY()"
 | Shift 1 | Shift 2 | Shift 3 | Shift 4 | Shift A | Shift B | Shift C | Shift D
1
2
3
 | 2022-01-08 00:00:00 | <-- "=TODAY()"
 | Shift 1 | Shift 2 | Shift 3 | Shift 4 | Shift A | Shift B | Shift C | Shift D
1
2
3
Spreadsheet: 375606d1423241206-extrapolate-data-example
Sheet: Sheet1

[NAME] | 3
Greg | 2
Betty | 5
[NAME] | 7
Spreadsheet: 644381d1570531918-help-with-a-string-of-if-statements-cashflow-template-working-version
Sheet: Base Case Cashflow

 |  |  |  |  |  |  |  |  |  | Year 1 |  |  |  | Year 2 |  |  |  | Year 3 |  |  |  | Year 4 |  |  |  | Year 5
 |  |  |  |  |  |  |  |  |  | 2019-09-30 00:00:00 | 2019-12-31 00:00:00 | 2020-03-31 00:00:00 | 2020-06-30 00:00:00 | 2020-09-30 00:00:00 | 2020-12-31 00:00:00 | 2021-03-31 00:00:00 | 2021-06-30 00:00:00 | 2021-09-30 00:00:00 | 2021-12-31 00:00:00 | 2022-03-31 00:00:00 | 2022-06-30 00:00:00 | 2022-09-30 00:00:00 | 2022-12-31 00:00:00 | 2023-03-31 00:00:00 | 2023-06-30 00:00:00 | 2023-09-30 00:00:00 | 2023-12-31 00:00:00 | 2024-03-31 00:00:00 | 2024-06-30 00:00:00
Property Address | Tenant | Lease Start | Lease Break Exercised? | Lease Break Date | Lease Expiry | Rent | Rent Post Void | Post Void Lease Expiry | VOID (# [NAME]) | Q3 2019 | Q4 2019 | Q1 2020 | Q2 2020 | Q3 2020 | Q4 2020 | Q1 2021 | Q2 2021 | Q3 2021 | Q4 2021 | Q1 2022 | Q2 2022 | Q3 2022 | [NAME] | Q1 2023 | Q2 2023 | Q3 2023 | Q4 2023 | Q1 2024 | Q2 2024
 |  | 2018-12-01 00:00:00 |  | 2022-02-01 00:00:00 | 2028-05-01 00:00:00 | 120000 |  | 2028-05-01 00:00:00
 |  | 2018-10-01 00:00:00 |  | 00:00:00 | 2022-06-01 00:00:00 | 250000 |  | 2022-06-01 00:00:00
 |  | 2018-12-01 00:00:00 |  | 2020-03-31 00:00:00 | 2030-06-20 00:00:00 | 200000 |  | 2030-06-20 00:00:00
 |  | 2016-06-05 00:00:00 |  | 00/01/1900 | 2021-09-28 00:00:00 | 80000 |  | 2021-09-28 00:00:00
 |  | 00:00:00
Initial Loan Requirement |  |  |  |  | Opening Bal
Property Value |  |  |  |  | [NAME]
Annuity Loan Profile on |  |  |  |  | [NAME]
Term |  |  |  |  | Closing LTV
Gross Rent
Interest p.a.
Service Charges & Costs - lessee
Profit before tax
Tax Payable (estimated) @
Total Interest, Expenses & Tax
Cashflow available pre Principal Repayments p.a.
Net Cashflow Available per above
Add back interest
Cashflow available for Debt Servicing
Cashflow after Debt Servicing
Gross Interest Cover
DSCR Pre Tax
DSCR Post Tax
Surplus Cashflow Available p.a. - pre tax
Surplus Cashflow Available p.a. - post tax
Tax Calculation
Rent
Expenses
Interest
Interest Dissalowed |  |  |  | 0
Capital Allowance |  |  |  | 0
Taxable Surplus
Tax Payable @
Rent Reserve
Opening reserve |  |  |  |  |  |  |  |  |  | 0
Surplus Cashflow Available p.a. - post tax
Cumulative reserve
Spreadsheet: 3290afb1-de45-4a40-acde-653c54b60347
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2011-04-25 09:20:21.250000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
5.125 | 101.953 | 101.703 | 101.578 | 101.203 |  | and are added to price quote
5 | 101.529 | 101.279 | 101.154 | 100.779
4.875 | 100.984 | 100.734 | 100.609 | 100.234 |  | Note: | Refer To Price [NAME]
4.75 | 99.999 | 99.749 | 99.624 | 99.249 |  |  | For all Price Adjs
4.625 | 98.843 | 98.593 | 98.468
4.5 | 98.333 | 98.083 | 97.958
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4.5 | 102 | 101.75 | 101.625 | 101.25
4.375 | 101.944 | 101.694 | 101.569 | 101.194
4.25 | 101.414 | 101.164 | 101.039 | 100.664
4.125 | 100.369 | 100.119 | 99.994 | 99.619
4 | 100.008 | 99.758 | 99.633
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2011-05-09 09:20:21.250000
30 DAY | 2011-05-24 09:20:21.250000
45 DAY | 2011-06-08 09:20:21.250000
60 DAY | 2011-06-23 09:20:21.250000
90 DAY | 2011-07-23 09:20:21.250000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 131119d1322749120-activity-planning-prioritized-auto-scheduling-gantt-chart
Sheet: Sample Timephasing

Activity. No. | Description | Priority | Remaining Hours | Planned Hours |  | 2011-11-28 00:00:00 | 2011-11-29 00:00:00 | 2011-11-30 00:00:00 | 2011-12-01 00:00:00 | 2011-12-02 00:00:00 | 2011-12-05 00:00:00 | 2011-12-06 00:00:00 | 2011-12-07 00:00:00 | 2011-12-08 00:00:00 | 2011-12-09 00:00:00 | 2011-12-12 00:00:00 | 2011-12-13 00:00:00 | 2011-12-14 00:00:00 | 2011-12-15 00:00:00 | 2011-12-16 00:00:00 | 2011-12-19 00:00:00 | 2011-12-20 00:00:00 | 2011-12-21 00:00:00 | 2011-12-22 00:00:00 | 2011-12-23 00:00:00 | 2011-12-26 00:00:00 | 2011-12-27 00:00:00 | 2011-12-28 00:00:00 | 2011-12-29 00:00:00 | 2011-12-30 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
1 | Activity 1 | 2 | 40
2 | Activity 2 | 3 | 40
3 | Activity 3 | 1 | 40
 | Subtotal
Spreadsheet: 39289d1237467752-calendar-and-buttons-3m-valley
Sheet: Veg Glycerine (2)

Veg. Glycerine 99.7 BIO-K
576 Lbs./Drum
[NAME]
Lot # | CB242261208
Batch # | 121108
PO | USMMMF9H45
Rel. | N/A | 2009-03-11 00:00:00
Veg. Glycerine 99.7 BIO-K
576 Lbs./Drum
[NAME]
Lot # | CB242261208
Batch # | 121108
PO | USMMMF9H45
Rel. | N/A | 2009-03-11 00:00:00
Spreadsheet: 124112d1318130965-how-do-i-show-list-of-students-names-who-failed-on-a-separate-sheet-final-grades
Sheet: Sheet2

Name of Student | Concept 1 | Concept 2 | Concept 3 | Compre Exam | Lecture Final | = | Status
Spreadsheet: sally_beck__35036__Prudency
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | CONFIDENTIAL
 |  |  |  |  |  |  |  |  |  |  |  | PRUDENCY DETAIL
 |  |  |  |  |  |  |  |  |  |  |  | As of  June 30, 1999
Book |  |  |  |  |  |  |  |  |  |  |  | Amount
Power West |  |  |  |  |  |  |  |  |  |  |  | -533487
Power East |  |  |  |  |  |  |  |  |  |  |  | -8298592
Power GENCO |  |  |  |  |  |  |  |  |  |  |  | -11900000
Interest Rate
Foreign Currency
Canadian Gas |  |  |  |  |  |  |  |  |  |  |  | -7915642
Canadian Gas |  |  |  |  |  |  |  |  |  |  |  | 0
Canada Index |  |  |  |  |  |  |  |  |  |  |  | -88283
West Gas |  |  |  |  |  |  |  |  |  |  |  | -159524
Texas
New York Gas
Southeast Gas |  |  |  |  |  |  |  |  |  |  |  | -265000
EFP Basis |  |  |  |  |  |  |  |  |  |  |  | -164433
Dublin Gas |  |  |  |  |  |  |  |  |  |  |  | -278321
Crude Oil |  |  |  |  |  |  |  |  |  |  |  | -514000
Oil Spec II |  |  |  |  |  |  |  |  |  |  |  | -561000
Residuals |  |  |  |  |  |  |  |  |  |  |  | -558382
Natural Gas Liquids |  |  |  |  |  |  |  |  |  |  |  | -844000
Refined Products
BTX
London Crude |  |  |  |  |  |  |  |  |  |  |  | 0
London Refined
London NGL
London Residuals |  |  |  |  |  |  |  |  |  |  |  | 0
Weather |  |  |  |  |  |  |  |  |  |  |  | -3050000
Paper |  |  |  |  |  |  |  |  |  |  |  | -336308
Plastics
SO2 |  |  |  |  |  |  |  |  |  |  |  | -85805
Coal |  |  |  |  |  |  |  |  |  |  |  | 0
NOX
European Trading - Non-Affiliate Gas |  |  |  |  |  |  |  |  |  |  |  | -13782032
European Trading - Enron Direct |  |  |  |  |  |  |  |  |  |  |  | 0
European Trading - UK Power |  |  |  |  |  |  |  |  |  |  |  | -31230467
European Trading - Continental Power |  |  |  |  |  |  |  |  |  |  |  | -6803139
European Trading - Nordic Power |  |  |  |  |  |  |  |  |  |  |  | -540301
European Trading - Eastern 2 |  |  |  |  |  |  |  |  |  |  |  | 0
European Trading - Inflation |  |  |  |  |  |  |  |  |  |  |  | -12069310
Singapore |  |  |  |  |  |  |  |  |  |  |  | -291000
 |  |  |  |  |  |  |  |  |  | TOTAL PRUDENCY
Spreadsheet: 184502d1349282287-problem-with-running-macro-to-enter-date-stamp-when-corresponding-check-box-is-checked-autocheckbox1
Sheet: The AnythingCheckbox

 |  |  |  |  |  | Wingding | [NAME] | Symbol | Wingdings 2 |  | WINGDINGS 2
Set Font to Wingdings (or symbol or [NAME]) as per table below |  |  |  |  |  | s | a | s | R | R | R
Customize cell number format to ü;ü;ü;ü (Ö for symbol,  a for marlett, etc) |  |  |  |  |  | v | b | s | dd | P | P
Any ENTRY gives a checkmark |  |  |  |  |  | D | fdsfs | s | abc | Q | Q
 |  |  |  |  |  | A | z | a | 3 | S | S
Symbol | Font | Shortcut |  |  |  |  | fdgfd | d |  | T | T
ü | Wingding | Alt 0252 (ü) |  |  |  |  |  |  |  | U | U
Ö | Symbol | Alt 0214 (Ö) |  |  |  |  |  |  |  | V | V
a | [NAME] | a
R | WingDings 2 | R
P | WingDings 2 | P
Q | WingDings 2 | Q
S | WingDings 2 | S
T | WingDings 2 | T
U | WingDings 2 | U
V | WingDings 2 | V
The problem with this type of checkbox is it can't be referenced for what you would think would be in the cell as, no matter what you put in the cell, it's formatted to show the value you want (i.e. [NAME] a)
Example: A23 is formatted as [NAME], and with custom number format a;a;a;a.  I enter a "z" into A23 and it shows up as an a which [NAME] displays as a check mark.  It's still a z so if I have an If Statement for that cell,
it has to be general.  See formulas in C23 and C24
z | Box is unchecked |  | <-- This doesn't work because Excel knows there's a z in that cell.
 | [NAME] is checked |  | <-- This works because is more general
Spreadsheet: 95898d1295425661-how-to-make-a-formula-to-take-value-in-database-to-store-as-history-history
Sheet: Sheet1

No | Name | Status | Month
1 | [NAME] | New | January | January
2 | Bani |  | January |  | How to show those value with status New to Sheet2 (view sheet 2 for example value that I want)
3 | Cech |  | January
4 | Danold | New | January |  | And now the month is January, when it is february, all the status of New are deleted (manually) because they are not New anymore
5 | Eagle |  | January |  | But, in sheet2 still wanna show those New with month in January as a history (so we have record showing this person is new in January)
6 | Foxes |  | January |  | Currently the entry has 10 value. When it is February, there are new entry entered below it (manually), so the entry will always increase
7 | Gray | New | January |  | Then if there are entry with status "New" in february, sheet2 will grab it to show who are new in february without delete those january record
8 | Hayward |  | January |  | So sheet2 entry will always increase based on New in each month.
9 | Irwans | New | January
10 | Jenova |  | January |  | Question is how to make those process automatically by using [NAME]?
11 | A | New | February
12 | B |  | February
13 | c |  | February
14 | d | New | February
15 | e |  | February
16 | f |  | February
17 | g | New | February
18 | h |  | February
19 | i | New | February
20 | j |  | February
21 | k | New | March
22 | l |  | March
23 | m | New | March
24 | n |  | March
25 | o | New | March
26 | p |  | March
27 | q |  | March
28 | r | New | March
29 | s |  | March
30 | t | New | March
31 | u |  | April
32 | v | New | April
33 | w |  | April
34 | x | New | April
35 | y |  | April
36 | s | New | April
Spreadsheet: 728877d1618757664-find-the-value-of-a-cell-above-the-last-cell-lookup-last-entry-value
Sheet: Sales

 |  |  |  |  |  |  |  | Q4 | Date
Date | SalesTeam | Q1 | Q2 | Q3 | Q4
2021-04-01 00:00:00 | A | 100 | 200 | 200 | 400
2021-04-02 00:00:00 | B | 50 | 60 | 60 | 70
2021-04-03 00:00:00 | A | 100 | 100 | 200 | 450
2021-04-04 00:00:00 | B | 250 | 350 | 150 | 100
2021-04-05 00:00:00 | A | 58 | 90 | 100 | 100
2021-04-06 00:00:00 | B | 100 | 200 | 250 | 300
2021-04-07 00:00:00 | A | 20 | 50 | 100 | 200
2021-04-08 00:00:00 | B | 20 | 30 | 100 | 15
2021-04-14 00:00:00 | C | 10 | 10 | 10 | 11
2021-04-15 00:00:00 | d | 11 | 12 | 13 | 14
2021-04-16 00:00:00 | E | 9 | 8 | 7 | 4
Spreadsheet: 125198d1318932571-maxif-formula-example-18-
Sheet: Sheet2

[NAME] of MAX
date | Total
sij | 329
vlj | 323
ožu | 322
tra | 316
svi | 295
lip | 338.4
srp | 348.3
kol | 342.6
ruj | 337.9
lis | 322
[NAME] | 312
pro | 334
Grand Total | 348.3
Spreadsheet: 877412d1724255307-staff-count-per-hour-adding-overnight-to-next-days-count-staff-count-per-hour-adding-overnight-to-next-days-count
Sheet: Overnight Hrs added to Next Day

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Staff count per hour adding overnight to next days count
Employee Name | 2024-08-18 00:00:00 |  | 2024-08-19 00:00:00 |  | 2024-08-20 00:00:00 |  | 2024-08-21 00:00:00 |  | 2024-08-22 00:00:00 |  | 2024-08-23 00:00:00 |  | 2024-08-24 00:00:00 |  | https://www.excelforum.com/newreply.php?do=postreply&t=1427595
Name | 06:00:00 | 16:00:00
Name | 10:00:00 | 20:00:00
Name | 16:00:00 | 02:00:00
Name | 20:00:00 | 06:00:00
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
00:00:00
01:00:00
02:00:00
03:00:00
04:00:00
05:00:00
06:00:00
07:00:00
08:00:00
09:00:00
10:00:00
11:00:00
12:00:00
13:00:00
14:00:00
15:00:00
16:00:00
17:00:00
18:00:00
19:00:00
20:00:00
21:00:00
22:00:00
23:00:00
Spreadsheet: 189025d1351069542-conditional-formula-help-exceleg
Sheet: Sheet1

 |  |  | ratio |  | acceleration | cell value
 |  |  |  |  |  | case 1
 |  |  | 25 |  | 25 |  | case 1: cell = "long" if acceleration cell is positive and when ratio cell value moves above -75
 |  |  | 0 |  | -20 |  | after it has been lower than that number ie less than -75 as shown in example
 |  |  | 20 |  | -30
 |  |  | 50 |  | 25 | long
 |  |  | 25 |  | 25 | long | case 2: cell = "long" if acceleration is positive and when cell ration moves above - 75
 |  |  | 0 |  | 25 | long | after it has been lower than that number ie less than -75 and ratio value column d is less than zero
 |  |  | -25 |  | 25 | long
 |  |  | -50 |  | 25 | long
 |  |  | -75 |  | 25 | long
 |  |  | -100 |  | 50
 |  |  | -150 |  | 50
 |  |  | -200 |  | -100
 |  |  | -100 |  | -50
 |  |  | -50 |  | -50
 |  |  | 0 |  | -100
 |  |  | 100 |  | 25
 |  |  | 75 |  | 25
 |  |  | 50 |  | 25
 |  |  | 25