tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 32149d1228245807-payment-staus-sheet-new-payment-status-report2
Sheet: Payment Status

Karhu |  |  |  |  | Payment Status Report
Woodworking Inc.
Customer Name: | [NAME]
Job Number: | 1234 |  | Quotes |  | Total |  |  | Total
Date | Document | # | Product | Installation | No Tax | GST | PST | With Taxes
 | Quote | 123 | 100 |  | 100 | 5 | 8 | 113
 |  |  |  |  | 0 | 0 | 0 | 0
2008-12-12 00:00:00 | Quote | 234 | 200 |  | 200 | 10 | 16 | 226
 |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0
 |  | Sub-Totals | 300 | 0 | 300 | 15 | 24 | 339
 |  |  | Change Orders
 | Description |  | Quotes |  | Total |  |  | Total
Date | of Change |  | Product | Installation | No Tax | GST | PST | With Taxes
2008-12-24 00:00:00 | Add stuff |  | 110 | 10 | 120 | 6 | 8.8 | 134.8
 | Remove other stuff |  | -15 | -5 | -20 | -1 | -1.2 | -22.2
 |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0
 |  | Change Order Sub-Totals | 95 | 5 | 100 | 5 | 7.600000000000001 | 112.6 |  | 1st Draw
 |  |  | Invoices |  |  |  |  |  |  | 2nd Draw
 |  |  | Quotes |  | Total |  |  | Total |  | 3rd Draw
Date | Payments | % | Product | Installation | No Tax | GST | PST | With Taxes |  | 4th Draw
2008-12-24 00:00:00 | 1st Draw | 0.3 | 90 |  | 90 | 4.5 | 7.2 | 101.7 |  | 5th Draw
 | 2nd Draw | 0.6 | 180 |  | 180 | 9 | 14.4 | 203.4 |  | 6th Draw
 |  |  |  |  | 0 | 0 | 0 | 0 |  | 7th Draw
 |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0
 | Final Draw | 0.1 | 30 | 0 | 30 | 1.5 | 2.4 | 33.9
 |  | Total Change Orders | 95 | 5 | 100 | 5 | 7.600000000000001 | 112.6
Final Payment Including Change Orders |  |  | 125 | 5 | 130 | 6.5 | 10 | 146.5
 |  |  | Totals
 |  | Total Quotes | 300 |  | 300 | 15 | 24 | 339
 |  | Total Changes | 95 | 5 | 100 | 5 | 7.600000000000001 | 112.6
 |  | Job Grand Total | 395 | 5 | 400 | 20 | 31.6 | 451.6
 |  |  | Date Received |  |  | Invoice # |  | 101.7
 |  |  | Date Received |  |  | Invoice # |  | 203.4
 |  |  | Date Received |  |  | Invoice # |  | 140
 |  |  | Date Received |  |  | Invoice #
 |  |  | Date Received |  |  | Invoice #
 |  |  | Date Received |  |  | Invoice #
 |  |  | Date Received |  |  | Invoice #
 |  |  |  |  |  |  | Total Amount Received To Date | 445.1
 |  |  |  |  |  |  | Amount Invoiced With Balance | -298.6 |  |  | <-- unknown formulas
 |  |  |  |  |  |  | Amount Still to be Invoiced (plus any new Change Orders) |  |  |  | <-- unknown formulas
Spreadsheet: 53876d1253800725-vlookup-or-index-match-book2
Sheet: needed

PART | QTY | Type
100 | 1 | Needed
101 | 3 | Needed
102 | 4 | Needed
103 | 55 | Needed
104 | 8 | Needed
100 | 1 | On Hand
101 | 3 | On Hand
102 | 3 | On Hand |  |  |  | Sum of QTY | Type
103 | 0 | On Hand |  |  |  | PART | Needed | On Hand | on Po | Grand Total
104 | 2 | On Hand |  |  |  | 100 | 1 | 1 | 0 | 2
100 | 0 | on Po |  |  |  | 101 | 3 | 3 | 0 | 6
101 | 0 | on Po |  |  |  | 102 | 4 | 3 | 1 | 8
102 | 1 | on Po |  |  |  | 103 | 55 | 0 | 55 | 110
103 | 55 | on Po |  |  |  | 104 | 8 | 2 | 6 | 16
104 | 6 | on Po |  |  |  | Grand Total | 71 | 9 | 62 | 142
Spreadsheet: john_zufferli__16761__positionsummary
Sheet: Summary Chart 

Position Sensitivies for Gas (in US$)
 | Pos'n (contracts) | [NAME] (US$) | +2 30d-Stdev | -2 30d-Stdev | +1 30d-Stdev | -1 30d-Stdev
Sumas
Malin
Socal
AECO
Consumers
Parkway
[NAME]
Waddington
Dawn
Monchy
TM3
[NAME]
Michcon
Chicago
Ventura
TZ6
PG&E
Station 2
Nymex
Scenario 1: Nymex Moves +2 Stdev = +2 [NAME] for Eastern/Central Markets, +1 Stdev for AECO
 | Pos'n (contracts) | [NAME] (US$) | P&L (US$)
Sumas |  |  | 0
Malin |  |  | 0
Socal |  |  | 0
AECO
Consumers
Parkway
[NAME]
Waddington
Dawn
Monchy
TM3
[NAME]
Michcon
Chicago
Ventura
TZ6
PG&E |  |  | 0
Station 2
Nymex
Sum
Scenario 2: Nymex Moves -2 Stdev = [NAME] for Eastern/Central Markets, +1 Stdev for Aeco/West
 | Pos'n (contracts) | [NAME] (US$) | P&L (US$)
Sumas
Malin
Socal
AECO
Consumers
Parkway
[NAME]
Waddington
Dawn
Monchy
TM3
[NAME]
Michcon
Chicago
Ventura
TZ6
PG&E
Station 2
Nymex
Sum
Position Sensitivies for Power (in CDN$)
Alberta Power | Position (PVMWh) | [NAME] (C$) | +2 30d-Stdev | -2 30d-Stdev | +1 30d-Stdev | -1 30d-Stdev
5*16
7*8
Sat
Sun
Sum
Spreadsheet: 148286d1333328446-drop-down-boxes-with-if-statement-and-vlookup-pricebook2
Sheet: Analysis

Code | Description | A | GM% | D | GM% | B | GM % | E | GM%
32360 | Product 1234 | 210.74 | 0.395957103539907 | 202.3104 | 0.3707886495207365 | 198.0956 | 0.3574011739786245 | 204.4178 | 0.3772753644741309
32379 | Product 1235 | 210.74 | 0.395957103539907 | 202.3104 | 0.3707886495207365 | 198.0956 | 0.3574011739786245 | 204.4178 | 0.3772753644741309
32395 | Product 1236 | 210.74 | 0.395957103539907 | 202.3104 | 0.3707886495207365 | 198.0956 | 0.3574011739786245 | 204.4178 | 0.3772753644741309
51322 | Product 1237 | 235.82 | 0.4601984564498346 | 226.3872 | 0.4377067254685777 | 221.6708 | 0.4257430387764197 | 228.7454 | 0.4435035633503449
Spreadsheet: benjamin_rogers__1036__Consolidated 6 Peaker- 051100-NewPrices
Sheet: Gleason

INCOME STATEMENT - GLEASON
('000 $)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Revenue
Fixed Price Period:
Demand Payment
Energy Payment
Block Payment
Market Price & Price Extension Period:
Demand Payment | 0 | 0 | 0
Variable Revenue | 0 | 0 | 0
Energy Margin | 0 | 0 | 0
Interest Income
Total Revenue
Expense
Fixed O&M
Variable O&M
Major Maintenance & Ongoing Capex
O&M Management Fee
Owner's Expense
Property Taxes Liability | 174.46 | 348.92 | 436.15 | 436.15 | 436.15 | 523.38 | 523.38 | 523.38 | 523.38 | 523.38 | 523.38 | 523.38 | 872.3 | 872.3 | 1308.45 | 743.9310449999999 | 758.8096658999999 | 773.985859218 | 789.4655764023599 | 805.2548879304072
Admin Fees
Marketing Fee | 0 | 0 | 0
Debt Service Reserve [NAME]
Franchise Tax
Total Expense
EBITDA
Depreciation & Amortization
EBIT
Interest Expense
EBT
Book State Tax Benefit / (Expense)
Shareholder Fed. Tax Benefit / (Expense)
Gleason Net Income
CASH FLOW [NAME]
Investor Interest
('000 $) | 2001 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Check
EBITDA
Plus Property Tax Liability
Less Property Tax Expense | -92.2251014
Debt Service
Pre Tax Cash Flow
State Cash Taxes Benefit (Expense)
Federal Cash Taxes Benefit (Expense)
After Tax Cash Flow
0
PV of EBITDA @
STATE TAX & FRANCHISE TAX - GLEASON
 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22
('000 $) | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020
FRANCHISE TAX
Book Value of Assets
Paid-In-Capital
[NAME]
Outstanding Debt
Total Capitalization
Greater of Book Value and Capitalzation
State Fracnhise Tax Rate
State Franchise Tax Liability | 503.0878305308907 | 487.528413091791 | 471.9689956526913 | 456.4095782135916 | 440.8501607744919 | 432.9293657576987 | 434.7437137793585 | 435.6906208126838 | 436.9173136908661 | 437.9709529301937 | 429.1266536364917 | 418.6693638022581 | 405.8537807180642 | 392.6363671291185 | 375.7134267645051 | 365.5823943758299 | 349.3656278602357 | 325.8874202275131 | 299.491564765197 | 269.8775240900777
STATE TAXES
Pretax Book Income
Plus Book Depreciation & Amortization
Less Tax Depreciation
State Taxable Income
State Income Tax Rate
Current State Income Tax Expense (Benefit)
Beginning NOL's | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
New NOL's
Expired NOL's | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NOL Utilization
Ending NOL's
Total State Taxes Utilizing NOLs
Spreadsheet: 806997d1669710156-googlesheets-schedule-checker-2023-1st-semester-schedule-bundang
Sheet: RACHEL

 | MONDAY |  | TUESDAY |  | WEDNESDAY |  | THURSDAY |  | FRIDAY |  | BOOKS/PREPS
 | _ |  | _ |  | _ |  | _ |  | _ |  | 1st Grade |  |  |  | 4th Grade
 | ADMIN |  | ADMIN |  | ADMIN |  | ADMIN |  | ADMIN
 |  |  |  |  |  |  |  |  |  |  | 2nd Grade
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5th Grade
 |  |  |  |  |  |  |  |  |  |  | 3rd Grade
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6th Grade
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
 |  |  |  |  |  |  |  |  |  |  | WRITING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
 |  |  | . |  |  |  | .
Spreadsheet: 172974d1344397470-identify-gaps-in-dates-within-a-range-excel-book-10
Sheet: Sheet1

Name | Start | End | Comments
Belden | 2010-01-12 00:00:00 | 2011-01-11 00:00:00
[NAME] | 2010-05-12 00:00:00 | 2011-05-11 00:00:00
[NAME] | 2011-07-07 00:00:00 | 2012-07-06 00:00:00 | Gap in coverage
[NAME] | 2012-07-05 00:00:00 | 2013-07-04 00:00:00
Belden | 2011-01-12 00:00:00 | 2012-01-11 00:00:00
Belden | 2012-01-19 00:00:00 | 2013-01-18 00:00:00 | Gap in coverage
[NAME] | 2009-05-12 00:00:00 | 2010-05-11 00:00:00
Spreadsheet: stacey_white__39149__ena-cal roll 1231
Sheet: Check

 |  | Afternoon Check |  |  |  |  | Morning Check
 |  | Prudency | Liquidations | Book Balance | Difference |  |  | Prudency | Book Balance
 | COB |  |  |  |  |  | COB
 | PV |  |  |  |  |  | PV
 | MID COLUMBIA |  |  |  |  |  | MID COLUMBIA
 | PX NORTH |  |  |  |  |  | PX NORTH
 | PX SOUTH |  |  |  |  |  | PX SOUTH
 | CEC GREEN |  |  |  |  |  | CEC GREEN
 | NON CEC GREEN |  |  |  |  |  | NON CEC GREEN
 | ZP26 |  |  |  |  |  | ZP26
 | Rockies |  |  |  |  |  | Rockies
 | NEPOOL |  |  |  |  |  | NEPOOL
 | NY EAST |  |  |  |  |  | NY EAST
 | PJM |  |  |  |  |  | PJM
 | Extra Sheet
 | SERC |  |  |  |  |  | SERC
 | SERC-Florida |  |  |  |  |  | SERC-Florida
 | SOUTHERN MAPP |  |  |  |  |  | SOUTHERN MAPP
 | SPP |  |  |  |  |  | SPP
 |  | Needs to be zero
Spreadsheet: 215918d1361541158-formular-to-help-sort-data-sorting-text-in-to-values-across-columns-example
Sheet: Sheet1

In a job seen as a path to a career | Never | Seldom | Sometimes | Often | Very often | Always | Total |  |  | never | 1
person 1 |  |  | Sometimes |  |  |  |  |  |  | seldom | 2
person 2 |  |  |  | often |  |  |  |  |  | sometimes | 3
person 3 |  | Seldom |  |  |  |  |  |  |  | often | 4
person 4 | never |  |  |  |  |  |  |  |  | very often | 5
person 5 |  |  |  |  | very often |  |  |  |  | always | 6
person 6 |  | Seldom
person 7 |  |  | Sometimes
Spreadsheet: 833726d1687216469-subtraction-logic-sample
Sheet: Sheet1

DATE | TOOL | PART COUNT | QUANTITY
2023-06-19 00:00:00 | T3434 | 7892 | X
2023-06-19 00:00:00 | T1021 | 8756 | X
2023-06-19 00:00:00 | T0303 | 9233 | X
2023-06-19 00:00:00 | T3434 | 9255 | 1363
2023-06-19 00:00:00 | T0303 | 9258 | 25
2023-06-19 00:00:00 | T1022 | 9670 | X
2023-06-19 00:00:00 | T3434 | 9675 | 420
Spreadsheet: 648479d1573060719-fruit-company-ordering-schedule-fruit
Sheet: Sheet1

AM | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT
ORANGE | X | X |  |  |  | X |  | X | X |  |  |  | X
APPLE |  | X |  | X |  | X |  |  | X |  | X |  | X
GRAPE | X |  |  |  |  | X | X | X |  |  |  |  | X | X
KIWI |  |  | X |  | X | X |  |  |  | X |  | X | X
PM | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT
PEAR | X | X | X |  |  |  |  | X | X | X
PLUM |  | X |  | X |  | X |  |  | X |  | X |  | X
COCONUT |  | X | X |  |  |  |  |  | X | X
MANGO |  | X |  |  |  |  |  |  | X
Spreadsheet: 149065d1333670575-need-to-pull-multiple-reference-points-into-one-spread-sheet-project-20sample-1-
Sheet: MASTER

APRIL | COST | LABOR | UNITS | TIME |  |  | ABC | APRIL
PQR |  |  |  |  |  |  | DEF | MAY
DEF |  |  |  |  |  |  | GHI | [NAME]
 |  |  |  |  |  |  | JKL
 |  |  |  |  |  |  | MNO
 |  |  |  |  |  |  | PQR
Sure, i incorporated [NAME]'s col() function into my revised formula.  My formula is based on having the data for each month as a named range, if you cant do that (if you dont know how, ask me), you will have to manually enter the ranges into the formula, and revisde its structure to what my 1st replky said (plus Jenns contribution) |  |  |  |  |  |  | STU
 |  |  |  |  |  |  | VWX
 |  |  |  |  |  |  | YZA
 |  |  |  |  |  |  | BCD
 |  |  |  |  |  |  | EFG
 |  |  |  |  |  |  | HIJ
 |  |  |  |  |  |  | KLM
Spreadsheet: 84795d1284837342-excel-2007-rebar-quantifier-formula-rebar-quantifier
Sheet: Sheet1

[NAME]
column mark | bar diameter(mm) | no. of sets | cut bar(m) | commercial length(m) | no of pcs (comm'l length) | Total kg
c1 | 16 | 4 | 3.5 | 7.5
c2 | 12 | 4 | 6 | 12
c3 | 20 | 8 | 3 | 6
c4 | 12 | 6 | 4.3 | 9
 |  |  |  |  | Total kg
table1: available comm'l lengths
6m |  |  |  | My Questions:
9m |  |  |  | 1. What formula will I use to fill-up cell E2 to E5 so that it would give me the commercial length
7.5m |  |  |  | with the smallest waste as possible using only available commercial lengths
10.5m |  |  |  | example: it should look for the comm'l length with the least remainder when comm'l length is divided by cut bar
12m |  |  |  | cut bar | commercial length | remarks
 |  |  |  | 2.5 | 9 | too much waste
table2 :Unit weight of steel: |  |  |  | 2.5 | 10.5 | too much waste
diameter ([NAME]) |  | [NAME]. per meter |  | 2.5 | 7.5 | ok
10
12 |  |  |  | 2. What formula will I use to sum only the no. of pieces and  weight of bars with 12mm diameter only?
14 |  |  |  | What is the total kg of row 3 and 5? I think you will use here the combination of match and vlookups.
16 |  |  |  | example: using the table above
20 |  |  |  | Summary
25 |  |  |  | diameter | no of pcs | [NAME]
32 |  |  |  | 12mm | 21
 |  |  |  | Pardon my english and thank you very much! It will be of great help!
Spreadsheet: 803856d1667750301-calculate-final-price-using-tiered-pricing-more-elegantly-tier
Sheet: Sheet1

0.65 | per unit cost
4 | multiplier applied to first 100 units
cell D5 | starting price
 | added to every increase of 100 units after 500 units
Qty Min | [NAME] | Increase | Unit price |  | Qty | Total |  | Qty | Total usng IFS | Total
0 | 100 | 0 |  |  | 100 |  |  | 400
101 | 200 | 0.5 |  |  | 200 |  |  | 450
201 | 300 | 0.25 |  |  | 300 |  |  | 499
301 | 400 | 0.18 |  |  | 400 |  |  | 600
401 | 500 | 0.13 |  |  | 500 |  |  | 620
501 | and over |  |  |  | 600 |  |  | 660
 |  |  |  |  | 700 |  |  | 699
 |  |  |  |  | 800 |  |  | 700
 |  |  |  |  | 900 |  |  | 900
 |  |  |  |  | 1000
Spreadsheet: 750892d1633710509-alter-formula-to-get-sum-without-any-value-being-less-than-zero-formula2
Sheet: Sheet2

Store | Current lease expiration | BreakPoint | % Sales | PR Calc - Greater of Rent or % Rent | Multi-Tiered | Rent Type | 202301 | 202302 | 202303 | 202304 | 202305 | 202306 | 202307 | 202308 | 202309 | 202310 | 202311 | 202312 | Total FY23 Sales |  |  |  |  |  |  |  |  |  |  |  |  | Total % Rent
2003 | 2023-01-31 00:00:00 | 1021507 | 0.1 | No | No | Base + BP% | 84415.51999999999 | 87288.88 | 67558.32 | 67000 | 84000 | 57000 | 61560 | 88000 | 70000 | 95000 | 115000 | 62000
2004 | 2023-01-31 00:00:00 | 500000 | 0.1 | No | No | Base + BP% | 69995.59 | 92112.94 | 74945.52000000002 | 74000 | 92000 | 66240 | 68000 | 96000 | 82000 | 100000 | 120000 | 68000
2005 | 2022-01-31 00:00:00 | 0 | 0.1 | No | No | % Rent only | 93090.52999999998 | 100543.12 | 88631.28 | 88000 | 97000 | 69840 | 74000 | 100000 | 85000 | 105000 | 120000 | 77000
2922 | 2022-01-31 00:00:00 | 814382 | 0.12 | Yes | No | Add'l % Rent | 90666.04000000001 | 110512.5 | 90163.475 | 90343.80195 | 112929.7524375 | 54000 | 58000 | 93000 | 94000 | 118000 | 120000 | 90000
Spreadsheet: 716299d1612165675-return-column-header-based-on-1st-2nd-3rd-match-and-possible-offset-return-headers-based-on-values-ans1
Sheet: Sheet1

 | Help on retieving column headers based on cell values in range
 | list for lookup |  |  |  |  |  |  |  |  |  |  |  | Output |  |  |  |  | Output
 |  |  |  |  |  |  |  |  |  |  |  |  | lookup value | EXPECTED FORMULA BELOW |  |  |  | lookup value | EXPECTED FORMULA BELOW
 |  |  | Name | Header 1 |  | Name | [NAME] |  | Name | [NAME] |  |  | a |  |  |  |  | a | Header 1 | [NAME]
 | a |  | a | 1 |  | b | 2 |  | a | 3 |  |  | b |  |  |  |  | b | [NAME]
 | b |  | c | 2 |  | d | 3 |  | c | 7 |  |  | d |  |  |  |  | d | [NAME]
 | c |  |  |  |  | c | 5 |  |  |  |  |  | c |  |  |  |  | c | Header 1 | [NAME] | [NAME]
 | d
 | e
 | f
 | g
 | h
 | i
 | j
 | k
Spreadsheet: 872735d1719140932-tracking-financial-achievement-logic-and-formula-are-needed-stretch-goal_suppliers_w_comments
Sheet: Excel Forum

Finally agreed contract with supplier, Price (MIKA) | initially forecasted price (AEK) - only [NAME] | initially forecasted price with a financial task (AEK) | Overall Change | Financial Task | Financial Task NOT achieved | Financial Task achieved | Financial Task OVERachieved
MIKA | AEK | AEK w/SG
1100 | 1000 |  |  | 100 |  |  |  | Product Category 1
1000 | 1000 |  |  | 100 |  |  |  | Product Category 2
950 | 1000 |  |  | 100 |  |  |  | Product Category 3
900 | 1000 |  |  | 100 |  |  |  | Product Category 4
850 | 1000 |  |  | 100 |  |  |  | Product Category 5
600 | 1000 |  |  | 100 |  |  |  | Product Category 6
500 | 800 |  |  | 50 |  |  |  | Product Category 7
550 | 600 |  |  | 70
1300 | 1000 |  |  | 0
numbers manually entered | numbers manually entered | calculated | calculated | numbers manually entered | For results in the column "F" (task not achieved):  - if  "E" = 0, -> result in ZERO (row 12) - if "D" is a negative number, then result in ZERO (example - row 9,10);   - if "D" is ZERO, "[NAME], result in ZERO (row7)   Otherwise, compare column "E" to column "D"):  - if "D" is a positive number and larger than "E" -> result in "E" (FT). in this example it is 100 (row 4) -  which means , the result in this column may equal [NAME]. column "E" itself).  - if "D" is a positive number and is smaller than "E" -> result in "A minus C"  (see row 6, row 11). - if "D" is a positive number and equals "E", result in ZERO (row 5).   please mind that there is no order (1->2->3 etc.) in fullfilling these criteria, so assumingly I cannot use IFS-function. | For column "G" (task ACHIEVED):   - if  "E" = 0, -> result in ZERO (row 12);   - if "B - A" = "E", -> result in "E" (row 7);  - if [NAME] and D>=E, result in ZERO (see row 4 and 5);  - if D>0 and D<E, result in "E-D" (see row 6 and row 11);   - if D is a negative number and "-D"<"B-A" (row 8, 9), then result in "E".  If no: XXXXX  pls note as a check: sum of G and H should equal to a difference "B" - "A". "G" cannot be higher than "E". Any overachievement should flow into "H".  pls note: sum of "F" und "G" cannot be higher than "E". (row 11)  please mind that there is no order (1->2->3 etc.) in fullfilling these criteria, so assumingly I cannot use IFS-function. | For column "H" (task  OVER-achieved) : - if  "E" = 0, -> result in ZERO.   - if  "D" >= 0, -> result in ZERO.  if  D < 0 and minus D<"B-A" then calculate "B-A" minus "G"
Spreadsheet: 36596d1234463976-multiple-selections-from-list-into-one-box-vlookup-dropdown-list-box
Sheet: Names

Name | Address | City | State | Zip | Amount Owed
[NAME] | 123 Anywhere St | Your Town 1 | IN | 45454 | 123.56
[NAME] | 234 A Street Ave | Your Town 2 | OH | 45455 | 231.56
[NAME] | 345 Sleeping [NAME] | Your Town 3 | KY | 45456 | 346.58
[NAME] | 456 Sneezy Ln | Your Town 4 | CA | 45457 | 532.48
[NAME] | 567 [NAME] | Your Town 5 | MI | 45458 | 456.17
 | In this sheet I selected A2 through A12.  Clicked on the [NAME] tab.
 | I went to A12 to leave room to add more names
 | In the Define Names Group select Define Name and name the range. I called it test, but use a name that works for you.
Spreadsheet: 91796d1291458253-date-alarming-while-same-vehicle-come-twice-or-thrice-date_near
Sheet: Sheet2

AUTONO | VEHICLE SERIAL NO | SE NAME | SE NAME (+WITH) | COMPL_SRNO | FSR NO | HRS | TYPE OF SERVICE | NATURE OF COMPLAINT | ACTION TAKEN | VEHICLE :DATE OF RECEIPT | REMARK
11 | MAV-1234 | ABC | -------- | A1 | 1234 | 67 | INSPECT | C1 | [NAME] | 2010-11-25 00:00:00 | 1 st time vehicle come for repair
22 | MAT-2345 | ABC | -------- | A2 | 2345 | 234 | SERVICING | S1 | DONE | 2010-11-26 00:00:00
33 | MHT-2122 | BCD | -------- | A3 | 3456 | 23 | SERVICING | S1 | DONE | 2010-11-29 00:00:00
44 | MAV-1234 | BCD | -------- | A4 | 4567 | 190 | MAJOR REPAIR | M1 | DONE | 2010-12-15 00:00:00 | 2 nd time same vehicle number come for repair after 20 days
55 | MVN-2090 | ABC | -------- | A5 | 5678 | 88 | MAJOR REPAIR | M1 | DONE | 2010-12-18 00:00:00
66 | MAV-1234 | BCD | -------- | A6 | 6789 | 299 | RE WORK | R2 | REPAIRED | 2010-12-25 00:00:00 | 3 rd time again same vehicle number come for repair after 10 days. Before that same vehicle number repaired on 15-dec-10. Here I required some alert formla (in red color) / message using with data validation, while enter date in column "B7" which is come within 15 days.
actually my data format as per above. Previously for example I m given example in column a & b
Spreadsheet: 679912d1590682486-dynamically-alter-table-header-and-dropdown-list-test-report
Sheet: Wages

 | Wages 2020 - 2021
W/E | Period | Name 1 | Name 2 | Name 3 | Name 4 | Name 5 | Name 6 | Name 7 | Name 8 | Name 9 | Name 10 | Total | CIS
2020-04-04 00:00:00 | Mar20 | 100 | 200 | 300
 | Apr20 | 101 | 201 | 301
 | Apr20 | 102 | 202 | 302
 | Apr20 | 103 | 203 | 303
 | Apr20 | 104 | 204 | 304
 | May20 | 105 | 205 | 305
 | May20 | 107 | 206 | 306
 | May20 | 106 | 207 | 307
 | May20
 | Jun20
 | Jun20
 | Jun20
 | Jun20
 | Jun20
 | Jul20
 | Jul20
 | Jul20
 | Jul20
 | Aug20
 | Aug20
 | Aug20
 | Aug20
 | Aug20
 | Sep20
 | Sep20
 | Sep20
 | Sep20
 | Oct20
 | Oct20
 | Oct20
 | Oct20
 | Nov20
 | Nov20
 | Nov20
 | Nov20
 | ,Nov20
 | Dec20
 | Dec20
 | Dec20
 | Dec20
 | Jan21
 | Jan21
 | Jan21
 | Jan21
 | Feb21
 | Feb21
 | Feb21
 | Feb21
 | Mar21
 | Mar21
 | Mar21
 | Mar21
 | Mar21
Spreadsheet: 187494d1350474412-referencing-the-first-15-names-in-a-list-a-list-that-is-manually-altered-bycopy-paste-etc-excel-help-forum2
Sheet: Risk Categories Table

 |  | Risk Categories Profile
 | Almost certain
 | Probable
 | Possible
 | Unlikely
 | Rare
 |  | Insignificant | Minor | Moderate | Major | Catastrophic
 | Rank | Risk name | Likelihood | Impact | Category | Subcategory
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
Spreadsheet: 883352d1731974191-sort-out-a-sequence-with-refering-to-certain-year-sort-with-different-years-eba
Sheet: PRESENTATION

2023
CEASAR | 30
ALFA | 20
BETA | 10
2024
BETA | 30
ALFA | 20
CEASAR | 5