Excel smoothing formula

E

eddster

New Member
Joined
Oct 11, 2017
Messages
25


Hi, I wonder if anybody could assist me in a smoothingformula I am struggling with,


In this scenario I wish to take the replacementvalue/period of an item based on several inputs and in some instances smooththe resulting smooth the output over either 3,5,7 periods equally eachside of the period that the item would be due

example below

The top table is a working version i.e. I have the necessary formulas togive the required output in columns H - AK however in this version no form ofsmoothing is being applied


In the 2nd table I have added in a smoothingvalue and hardcoded the result as I would expect to see them IF I had the formula ?





The formula I am currently using for cell J6 in the toptable is


=(IF($C6="",0,IF(AND($D6="N/A",$C6=J$2),$G6,IFERROR(IF($C6>J$2,0,((MOD(J$2-$C6,$D6)=0)*$G6)),0))))= £4000


I need the formulas that will give the desire £1333.33output in J6 on the bottom table and spread the costs either side accordingly


[TABLE="width: 1941"]
<tbody>[TR]
[TD="width: 64, bgcolor: transparent"]A1
[/TD]
[TD="width: 86, bgcolor: transparent"]B
[/TD]
[TD="width: 113, bgcolor: transparent"]C
[/TD]
[TD="width: 73, bgcolor: transparent"]D
[/TD]
[TD="width: 68, bgcolor: transparent"]E
[/TD]
[TD="width: 64, bgcolor: transparent"]F
[/TD]
[TD="width: 117, bgcolor: transparent"]G
[/TD]
[TD="width: 81, bgcolor: transparent"]H
[/TD]
[TD="width: 64, bgcolor: transparent"]I
[/TD]
[TD="width: 64, bgcolor: transparent"]J
[/TD]
[TD="width: 64, bgcolor: transparent"]K
[/TD]
[TD="width: 64, bgcolor: transparent"]L
[/TD]
[TD="width: 64, bgcolor: transparent"]M
[/TD]
[TD="width: 64, bgcolor: transparent"]N
[/TD]
[TD="width: 64, bgcolor: transparent"]O
[/TD]
[TD="width: 64, bgcolor: transparent"]P
[/TD]
[TD="width: 64, bgcolor: transparent"]Q
[/TD]
[TD="width: 64, bgcolor: transparent"]R
[/TD]
[TD="width: 64, bgcolor: transparent"]S
[/TD]
[TD="width: 64, bgcolor: transparent"]T
[/TD]
[TD="width: 64, bgcolor: transparent"]U
[/TD]
[TD="width: 64, bgcolor: transparent"]V
[/TD]
[TD="width: 64, bgcolor: transparent"]W
[/TD]
[TD="width: 64, bgcolor: transparent"]X
[/TD]
[TD="width: 64, bgcolor: transparent"]Y
[/TD]
[TD="width: 64, bgcolor: transparent"]Z
[/TD]
[TD="width: 64, bgcolor: transparent"]AA
[/TD]
[TD="width: 64, bgcolor: transparent"]AB
[/TD]
[TD="width: 64, bgcolor: transparent"]AC
[/TD]
[TD="width: 64, bgcolor: transparent"]AD
[/TD]
[TD="width: 64, bgcolor: transparent"]AE
[/TD]
[TD="width: 64, bgcolor: transparent"]AF
[/TD]
[TD="width: 64, bgcolor: transparent"]AG
[/TD]
[TD="width: 64, bgcolor: transparent"]AH
[/TD]
[TD="width: 64, bgcolor: transparent"]AI
[/TD]
[TD="width: 64, bgcolor: transparent"]AJ
[/TD]
[TD="width: 64, bgcolor: transparent"]AK
[/TD]
[TD="width: 64, bgcolor: transparent"]AL
[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent, align: right"]2
[/TD]
[TD="width: 86, bgcolor: #548235"]Items
[/TD]
[TD="width: 113, bgcolor: #548235"]1st replacement period
[/TD]
[TD="width: 73, bgcolor: #548235"]frequency
[/TD]
[TD="width: 68, bgcolor: #548235"]quantity
[/TD]
[TD="width: 64, bgcolor: #548235"]cost
[/TD]
[TD="width: 117, bgcolor: #548235"]Total cost per replacement cycle
[/TD]
[TD="width: 81, bgcolor: #548235"]smoothing
[/TD]
[TD="width: 64, bgcolor: #4472C4, align: right"]1
[/TD]
[TD="width: 64, bgcolor: #4472C4, align: right"]2
[/TD]
[TD="width: 64, bgcolor: #4472C4, align: right"]3
[/TD]
[TD="width: 64, bgcolor: #4472C4, align: right"]4
[/TD]
[TD="width: 64, bgcolor: #4472C4, align: right"]5
[/TD]
[TD="width: 64, bgcolor: #4472C4, align: right"]6
[/TD]
[TD="width: 64, bgcolor: #4472C4, align: right"]7
[/TD]
[TD="width: 64, bgcolor: #4472C4, align: right"]8
[/TD]
[TD="width: 64, bgcolor: #4472C4, align: right"]9
[/TD]
[TD="width: 64, bgcolor: #4472C4, align: right"]10
[/TD]
[TD="width: 64, bgcolor: #4472C4, align: right"]11
[/TD]
[TD="width: 64, bgcolor: #4472C4, align: right"]12
[/TD]
[TD="width: 64, bgcolor: #4472C4, align: right"]13
[/TD]
[TD="width: 64, bgcolor: #4472C4, align: right"]14
[/TD]
[TD="width: 64, bgcolor: #4472C4, align: right"]15
[/TD]
[TD="width: 64, bgcolor: #4472C4, align: right"]16
[/TD]
[TD="width: 64, bgcolor: #4472C4, align: right"]17
[/TD]
[TD="width: 64, bgcolor: #4472C4, align: right"]18
[/TD]
[TD="width: 64, bgcolor: #4472C4, align: right"]19
[/TD]
[TD="width: 64, bgcolor: #4472C4, align: right"]20
[/TD]
[TD="width: 64, bgcolor: #4472C4, align: right"]21
[/TD]
[TD="width: 64, bgcolor: #4472C4, align: right"]22
[/TD]
[TD="width: 64, bgcolor: #4472C4, align: right"]23
[/TD]
[TD="width: 64, bgcolor: #4472C4, align: right"]24
[/TD]
[TD="width: 64, bgcolor: #4472C4, align: right"]25
[/TD]
[TD="width: 64, bgcolor: #4472C4, align: right"]26
[/TD]
[TD="width: 64, bgcolor: #4472C4, align: right"]27
[/TD]
[TD="width: 64, bgcolor: #4472C4, align: right"]28
[/TD]
[TD="width: 64, bgcolor: #4472C4, align: right"]29
[/TD]
[TD="width: 64, bgcolor: #4472C4, align: right"]30
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]3
[/TD]
[TD="bgcolor: transparent"]pencils
[/TD]
[TD="bgcolor: transparent"]1
[/TD]
[TD="bgcolor: transparent"]1
[/TD]
[TD="bgcolor: transparent"]1000
[/TD]
[TD="bgcolor: transparent"]0.1
[/TD]
[TD="bgcolor: transparent"]100
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"]100.00
[/TD]
[TD="bgcolor: transparent, align: right"]100.00
[/TD]
[TD="bgcolor: transparent, align: right"]100.00
[/TD]
[TD="bgcolor: transparent, align: right"]100.00
[/TD]
[TD="bgcolor: transparent, align: right"]100.00
[/TD]
[TD="bgcolor: transparent, align: right"]100.00
[/TD]
[TD="bgcolor: transparent, align: right"]100.00
[/TD]
[TD="bgcolor: transparent, align: right"]100.00
[/TD]
[TD="bgcolor: transparent, align: right"]100.00
[/TD]
[TD="bgcolor: transparent, align: right"]100.00
[/TD]
[TD="bgcolor: transparent, align: right"]100.00
[/TD]
[TD="bgcolor: transparent, align: right"]100.00
[/TD]
[TD="bgcolor: transparent, align: right"]100.00
[/TD]
[TD="bgcolor: transparent, align: right"]100.00
[/TD]
[TD="bgcolor: transparent, align: right"]100.00
[/TD]
[TD="bgcolor: transparent, align: right"]100.00
[/TD]
[TD="bgcolor: transparent, align: right"]100.00
[/TD]
[TD="bgcolor: transparent, align: right"]100.00
[/TD]
[TD="bgcolor: transparent, align: right"]100.00
[/TD]
[TD="bgcolor: transparent, align: right"]100.00
[/TD]
[TD="bgcolor: transparent, align: right"]100.00
[/TD]
[TD="bgcolor: transparent, align: right"]100.00
[/TD]
[TD="bgcolor: transparent, align: right"]100.00
[/TD]
[TD="bgcolor: transparent, align: right"]100.00
[/TD]
[TD="bgcolor: transparent, align: right"]100.00
[/TD]
[TD="bgcolor: transparent, align: right"]100.00
[/TD]
[TD="bgcolor: transparent, align: right"]100.00
[/TD]
[TD="bgcolor: transparent, align: right"]100.00
[/TD]
[TD="bgcolor: transparent, align: right"]100.00
[/TD]
[TD="bgcolor: transparent, align: right"]100.00
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]4
[/TD]
[TD="bgcolor: transparent"]erasers
[/TD]
[TD="bgcolor: transparent"]4
[/TD]
[TD="bgcolor: transparent"]N/A
[/TD]
[TD="bgcolor: transparent"]400
[/TD]
[TD="bgcolor: transparent"]1
[/TD]
[TD="bgcolor: transparent"]400
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]400.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]5
[/TD]
[TD="bgcolor: transparent"]books
[/TD]
[TD="bgcolor: transparent"]2
[/TD]
[TD="bgcolor: transparent"]4
[/TD]
[TD="bgcolor: transparent"]50
[/TD]
[TD="bgcolor: transparent"]10
[/TD]
[TD="bgcolor: transparent"]500
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]500.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]500.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]500.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]500.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]500.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]500.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]500.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]500.00
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]6
[/TD]
[TD="bgcolor: transparent"]cupboard
[/TD]
[TD="bgcolor: transparent"]2
[/TD]
[TD="bgcolor: transparent"]10
[/TD]
[TD="bgcolor: transparent"]10
[/TD]
[TD="bgcolor: transparent"]400
[/TD]
[TD="bgcolor: transparent"]4000
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]4000.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]4000.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]4000.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]7
[/TD]
[TD="bgcolor: transparent"]table
[/TD]
[TD="bgcolor: transparent"]3
[/TD]
[TD="bgcolor: transparent"]15
[/TD]
[TD="bgcolor: transparent"]10
[/TD]
[TD="bgcolor: transparent"]150
[/TD]
[TD="bgcolor: transparent"]1500
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]1500.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]1500.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11
[/TD]
[TD="width: 86, bgcolor: #548235"]Items
[/TD]
[TD="width: 113, bgcolor: #548235"]1st replacement period
[/TD]
[TD="width: 73, bgcolor: #548235"]frequency
[/TD]
[TD="width: 68, bgcolor: #548235"]quantity
[/TD]
[TD="width: 64, bgcolor: #548235"]cost
[/TD]
[TD="width: 117, bgcolor: #548235"]Total cost per replacement cycle
[/TD]
[TD="width: 81, bgcolor: #548235"]smoothing
[/TD]
[TD="width: 64, bgcolor: #4472C4, align: right"]1
[/TD]
[TD="width: 64, bgcolor: #4472C4, align: right"]2
[/TD]
[TD="width: 64, bgcolor: #4472C4, align: right"]3
[/TD]
[TD="width: 64, bgcolor: #4472C4, align: right"]4
[/TD]
[TD="width: 64, bgcolor: #4472C4, align: right"]5
[/TD]
[TD="width: 64, bgcolor: #4472C4, align: right"]6
[/TD]
[TD="width: 64, bgcolor: #4472C4, align: right"]7
[/TD]
[TD="width: 64, bgcolor: #4472C4, align: right"]8
[/TD]
[TD="width: 64, bgcolor: #4472C4, align: right"]9
[/TD]
[TD="width: 64, bgcolor: #4472C4, align: right"]10
[/TD]
[TD="width: 64, bgcolor: #4472C4, align: right"]11
[/TD]
[TD="width: 64, bgcolor: #4472C4, align: right"]12
[/TD]
[TD="width: 64, bgcolor: #4472C4, align: right"]13
[/TD]
[TD="width: 64, bgcolor: #4472C4, align: right"]14
[/TD]
[TD="width: 64, bgcolor: #4472C4, align: right"]15
[/TD]
[TD="width: 64, bgcolor: #4472C4, align: right"]16
[/TD]
[TD="width: 64, bgcolor: #4472C4, align: right"]17
[/TD]
[TD="width: 64, bgcolor: #4472C4, align: right"]18
[/TD]
[TD="width: 64, bgcolor: #4472C4, align: right"]19
[/TD]
[TD="width: 64, bgcolor: #4472C4, align: right"]20
[/TD]
[TD="width: 64, bgcolor: #4472C4, align: right"]21
[/TD]
[TD="width: 64, bgcolor: #4472C4, align: right"]22
[/TD]
[TD="width: 64, bgcolor: #4472C4, align: right"]23
[/TD]
[TD="width: 64, bgcolor: #4472C4, align: right"]24
[/TD]
[TD="width: 64, bgcolor: #4472C4, align: right"]25
[/TD]
[TD="width: 64, bgcolor: #4472C4, align: right"]26
[/TD]
[TD="width: 64, bgcolor: #4472C4, align: right"]27
[/TD]
[TD="width: 64, bgcolor: #4472C4, align: right"]28
[/TD]
[TD="width: 64, bgcolor: #4472C4, align: right"]29
[/TD]
[TD="width: 64, bgcolor: #4472C4, align: right"]30
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]12
[/TD]
[TD="bgcolor: transparent"]pencils
[/TD]
[TD="bgcolor: transparent"]1
[/TD]
[TD="bgcolor: transparent"]1
[/TD]
[TD="bgcolor: transparent"]1000
[/TD]
[TD="bgcolor: transparent"]0.1
[/TD]
[TD="bgcolor: transparent"]100
[/TD]
[TD="bgcolor: transparent"]1
[/TD]
[TD="bgcolor: transparent, align: right"]100.00
[/TD]
[TD="bgcolor: transparent, align: right"]100.00
[/TD]
[TD="bgcolor: transparent, align: right"]100.00
[/TD]
[TD="bgcolor: transparent, align: right"]100.00
[/TD]
[TD="bgcolor: transparent, align: right"]100.00
[/TD]
[TD="bgcolor: transparent, align: right"]100.00
[/TD]
[TD="bgcolor: transparent, align: right"]100.00
[/TD]
[TD="bgcolor: transparent, align: right"]100.00
[/TD]
[TD="bgcolor: transparent, align: right"]100.00
[/TD]
[TD="bgcolor: transparent, align: right"]100.00
[/TD]
[TD="bgcolor: transparent, align: right"]100.00
[/TD]
[TD="bgcolor: transparent, align: right"]100.00
[/TD]
[TD="bgcolor: transparent, align: right"]100.00
[/TD]
[TD="bgcolor: transparent, align: right"]100.00
[/TD]
[TD="bgcolor: transparent, align: right"]100.00
[/TD]
[TD="bgcolor: transparent, align: right"]100.00
[/TD]
[TD="bgcolor: transparent, align: right"]100.00
[/TD]
[TD="bgcolor: transparent, align: right"]100.00
[/TD]
[TD="bgcolor: transparent, align: right"]100.00
[/TD]
[TD="bgcolor: transparent, align: right"]100.00
[/TD]
[TD="bgcolor: transparent, align: right"]100.00
[/TD]
[TD="bgcolor: transparent, align: right"]100.00
[/TD]
[TD="bgcolor: transparent, align: right"]100.00
[/TD]
[TD="bgcolor: transparent, align: right"]100.00
[/TD]
[TD="bgcolor: transparent, align: right"]100.00
[/TD]
[TD="bgcolor: transparent, align: right"]100.00
[/TD]
[TD="bgcolor: transparent, align: right"]100.00
[/TD]
[TD="bgcolor: transparent, align: right"]100.00
[/TD]
[TD="bgcolor: transparent, align: right"]100.00
[/TD]
[TD="bgcolor: transparent, align: right"]100.00
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]13
[/TD]
[TD="bgcolor: transparent"]erasers

[/TD]
[TD="bgcolor: transparent"]4
[/TD]
[TD="bgcolor: transparent"]N/A
[/TD]
[TD="bgcolor: transparent"]400
[/TD]
[TD="bgcolor: transparent"]1
[/TD]
[TD="bgcolor: transparent"]400
[/TD]
[TD="bgcolor: transparent"]3
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]133.33
[/TD]
[TD="bgcolor: transparent, align: right"]133.33
[/TD]
[TD="bgcolor: transparent, align: right"]133.33
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]14
[/TD]
[TD="bgcolor: transparent"]books
[/TD]
[TD="bgcolor: transparent"]2
[/TD]
[TD="bgcolor: transparent"]4
[/TD]
[TD="bgcolor: transparent"]50
[/TD]
[TD="bgcolor: transparent"]10
[/TD]
[TD="bgcolor: transparent"]500
[/TD]
[TD="bgcolor: transparent"]3
[/TD]
[TD="bgcolor: transparent, align: right"]166.67
[/TD]
[TD="bgcolor: transparent, align: right"]166.67
[/TD]
[TD="bgcolor: transparent, align: right"]166.67
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]166.67
[/TD]
[TD="bgcolor: transparent, align: right"]166.67
[/TD]
[TD="bgcolor: transparent, align: right"]166.67
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]166.67
[/TD]
[TD="bgcolor: transparent, align: right"]166.67
[/TD]
[TD="bgcolor: transparent, align: right"]166.67
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]166.67
[/TD]
[TD="bgcolor: transparent, align: right"]166.67
[/TD]
[TD="bgcolor: transparent, align: right"]166.67
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]166.67
[/TD]
[TD="bgcolor: transparent, align: right"]166.67
[/TD]
[TD="bgcolor: transparent, align: right"]166.67
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]166.67
[/TD]
[TD="bgcolor: transparent, align: right"]166.67
[/TD]
[TD="bgcolor: transparent, align: right"]166.67
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]166.67
[/TD]
[TD="bgcolor: transparent, align: right"]166.67
[/TD]
[TD="bgcolor: transparent, align: right"]166.67
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]166.67
[/TD]
[TD="bgcolor: transparent, align: right"]166.67
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]15
[/TD]
[TD="bgcolor: transparent"]cupboard
[/TD]
[TD="bgcolor: transparent"]2
[/TD]
[TD="bgcolor: transparent"]10
[/TD]
[TD="bgcolor: transparent"]10
[/TD]
[TD="bgcolor: transparent"]400
[/TD]
[TD="bgcolor: transparent"]4000
[/TD]
[TD="bgcolor: transparent"]3
[/TD]
[TD="bgcolor: transparent, align: right"]1333.33
[/TD]
[TD="bgcolor: transparent, align: right"]1333.33
[/TD]
[TD="bgcolor: transparent, align: right"]1333.33
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]1333.33
[/TD]
[TD="bgcolor: transparent, align: right"]1333.33
[/TD]
[TD="bgcolor: transparent, align: right"]1333.33
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]1333.33
[/TD]
[TD="bgcolor: transparent, align: right"]1333.33
[/TD]
[TD="bgcolor: transparent, align: right"]1333.33
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]16
[/TD]
[TD="bgcolor: transparent"]table
[/TD]
[TD="bgcolor: transparent"]3
[/TD]
[TD="bgcolor: transparent"]15
[/TD]
[TD="bgcolor: transparent"]10
[/TD]
[TD="bgcolor: transparent"]150
[/TD]
[TD="bgcolor: transparent"]1500
[/TD]
[TD="bgcolor: transparent"]7
[/TD]
[TD="bgcolor: transparent, align: right"]214.29
[/TD]
[TD="bgcolor: transparent, align: right"]214.29
[/TD]
[TD="bgcolor: transparent, align: right"]214.29
[/TD]
[TD="bgcolor: transparent, align: right"]214.29
[/TD]
[TD="bgcolor: transparent, align: right"]214.29
[/TD]
[TD="bgcolor: transparent, align: right"]214.29
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]214.29
[/TD]
[TD="bgcolor: transparent, align: right"]214.29
[/TD]
[TD="bgcolor: transparent, align: right"]214.29
[/TD]
[TD="bgcolor: transparent, align: right"]214.29
[/TD]
[TD="bgcolor: transparent, align: right"]214.29
[/TD]
[TD="bgcolor: transparent, align: right"]214.29
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]214.29
[/TD]
[TD="bgcolor: transparent, align: right"]214.29
[/TD]
[/TR]
</tbody>[/TABLE]



 

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
Sort by date Sort by votes
Try:

r><
td style="text-align: right;background-color: #FAFAFA ;;">166.6667
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKAL
AM

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
<td sty
le="text-align: right;;"></td>[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]2[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #548235"]Items[/TD]
[TD="bgcolor: #548235"]1st replacement period[/TD]
[TD="bgcolor: #548235"]frequency[/TD]
[TD="bgcolor: #548235"]quantity[/TD]
[TD="bgcolor: #548235"]cost[/TD]
[TD="bgcolor: #548235"]Tot
al cost per replacement cycle[/TD]
[TD="bgcolor: #548235"]smoothing[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=4472C4]#4472C4[/URL] , align: right"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=4472C4]#4472C4[/URL] , align: right"]2[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=4472C4]#4472C4[/URL] , align: right"]3[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=4472C4]#4472C4[/URL] , align: right"]4[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=4472C4]#4472C4[/URL] , align: right"]5[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=4472C4]#4472C4[/URL] , align: right"]6[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=4472C4]#4472C4[/URL] , align: right"]7[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=4472C4]#4472C4[/URL] , align: right"]8[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=4472C4]#4472C4[/URL] , align: right"]9[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=4472C4]#4472C4[/URL] , align: right"]10[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=4472C4]#4472C4[/URL] , align: right"]11[/TD]
[TD="align: right"]12[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=4472C4]#4472C4[/URL] , align: right"]13[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=4472C4]#4472C4[/URL] , align: right"]14[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=4472C4]#4472C4[/URL] , align: right"]15[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=4472C4]#4472C4[/URL] , align: right"]16[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=4472C4]#4472C4[/URL] , align: right"]17[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=4472C4]#4472C4[/URL] , align: right"]18[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=4472C4]#4472C4[/URL] , align: right"]19[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=4472C4]#4472C4[/URL] , align: right"]20[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=4472C4]#4472C4[/URL] , align: right"]21[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=4472C4]#4472C4[/URL] , align: right"]22[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=4472C4]#4472C4[/URL] , align: right"]23[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=4472C4]#4472C4[/URL] , align: right"]24[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=4472C4]#4472C4[/URL] , align: right"]25[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=4472C4]#4472C4[/URL] , align: right"]26[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=4472C4]#4472C4[/URL] , align: right"]27[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=4472C4]#4472C4[/URL] , align: right"]28[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=4472C4]#4472C4[/URL] , align: right"]29[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=4472C4]#4472C4[/URL] , align: right"]30[/TD]
[TD="align: right"][/TD]

[TD="align: center"]3[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] "]pencils[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]1000[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0.1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]100[/TD]
[TD="align: right"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]100[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]100[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]100[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]100[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]100[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]100[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]100[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]100[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]100[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]100[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]100[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]100[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]100[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]100[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]100[/TD]
<td sty
le="text-align: right;background-color: #FAFAFA ;;">100</td>[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]100[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]100[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]100[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]100[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]100[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]100[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]100[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]100[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]100[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]100[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]100[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]100[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]100[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]100[/TD]
[TD="align: right"][/TD]

[TD="align: center"]4[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] "]erasers[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]4[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]1000[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]400[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]400[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]3[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]133.333333[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]133.3333[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]133.3333[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL]
, align: right"]0[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]
[TD="align: right"][/TD]

[TD="align: center"]5[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] "]books[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]2[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]4[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]50[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]10[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]500[/TD]
[TD="align: right"]3[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]166.666667[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]166.6667[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]166.666667[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]166.6667[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]166.6667[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]166.6667[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]166.6667[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]166.6667[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]166.6667[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]166.6667[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]166.6667[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] "]166.6667[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]166.6667[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]166.6667[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]166.6667[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]166.6667[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]166.6667[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]166.6667[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]166.6667[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]166.6667[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]166.6667[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]166.6667[/TD]
[TD="align: right"][/TD]

[TD="align: center"]6[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] "]cupboard[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]2[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]10[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]10[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]400[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]4000[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]3[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]1333.33333[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]1333.333[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]1333.33333[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]
<td st
yle="text-align: right;background-color: #FAFAFA ;;">0</td>[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]1333.333[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]1333.333[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]1333.333[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]
[TD="bgcolor: #
FAFAFA, align: right"]1333.333[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]1333.333[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]1333.333[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]
[TD="align: right"][/TD]

[TD="align: center"]7[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] "]table[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]3[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]15[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]10[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]150[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]1500[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]7[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]214.285714[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]214.2857[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]214.285714[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]214.2857[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]214.2857[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]214.2857[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] "]0[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]214.2857[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]214.2857[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]214.2857[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]214.2857[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]214.2857[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]214.2857[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]214.2857[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]0[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]214.2857[/TD]
[TD="align: right"][/TD]

</tbody>
Sheet1​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulashead>[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]I3[/TH]
[TD="align: left"]=IF(OR(MOD(I$2-$C3,$D3)<=$H3/2,MOD(I$2-$C3,$D3)>=$D3-$H3/2),$G3/$H3,0)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]



Note that I replace the N/A in D4 with 1000 (or any really large number). Sorry about the formatting.
 
Upvote 0
You must log in or register to reply here.

Similar threads

M
  • Solved
Put two ranges into one range from two sheets
2
Replies
14
Views
147
Mussa
M
M
  • Solved
Add item in first digits with create space after it based on sheet name
Replies
8
Views
111
kvsrinivasamurthy
K
A
  • Solved
Track movement stock in listbox on userform by copy amounts from previous row to next row
Replies
8
Views
93
abdo meghari
A
A
  • Solved
How sort duplicates data under each other of them for each duplicates dates
Replies
5
Views
117
Peter_SSs
Peter_SSs
A
  • Solved
Autonumbering in cell based on last row in column
Replies
2
Views
71
abdo meghari
A

Forum statistics

Threads
1,223,904
Messages
6,175,295
Members
452,631
Latest member
a_potato

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top