Results 1 to 15 of 34
Thread: Circular reference issue

20100114, 17:55 #1
 Join Date
 Oct 2001
 Location
 San Bernardino, California, USA
 Posts
 734
 Thanks
 0
 Thanked 0 Times in 0 Posts
Attached is a simple spreadsheet to determine pricing for an event consisting of X tables, it shows the price, the food & labor expenses, the overall profit and the profit per table. I can declare a desired profit per table and have the spreadsheet calculate the appropriate price adjustment to achieve that desired profit per table. However, I seem to be unable to create a formula where that adjustment is automatically applied to the overall price.
Can anyone help with this?

20100114, 17:55 #2
 Join Date
 Oct 2001
 Location
 San Bernardino, California, USA
 Posts
 734
 Thanks
 0
 Thanked 0 Times in 0 Posts
Attached is a simple spreadsheet to determine pricing for an event consisting of X tables, it shows the price, the food & labor expenses, the overall profit and the profit per table. I can declare a desired profit per table and have the spreadsheet calculate the appropriate price adjustment to achieve that desired profit per table. However, I seem to be unable to create a formula where that adjustment is automatically applied to the overall price.
Can anyone help with this?

20100114, 17:55 #3
 Join Date
 Oct 2001
 Location
 San Bernardino, California, USA
 Posts
 734
 Thanks
 0
 Thanked 0 Times in 0 Posts
Attached is a simple spreadsheet to determine pricing for an event consisting of X tables, it shows the price, the food & labor expenses, the overall profit and the profit per table. I can declare a desired profit per table and have the spreadsheet calculate the appropriate price adjustment to achieve that desired profit per table. However, I seem to be unable to create a formula where that adjustment is automatically applied to the overall price.
Can anyone help with this?

20100114, 17:55 #4
 Join Date
 Oct 2001
 Location
 San Bernardino, California, USA
 Posts
 734
 Thanks
 0
 Thanked 0 Times in 0 Posts
Attached is a simple spreadsheet to determine pricing for an event consisting of X tables, it shows the price, the food & labor expenses, the overall profit and the profit per table. I can declare a desired profit per table and have the spreadsheet calculate the appropriate price adjustment to achieve that desired profit per table. However, I seem to be unable to create a formula where that adjustment is automatically applied to the overall price.
Can anyone help with this?

20100114, 17:55 #5
 Join Date
 Oct 2001
 Location
 San Bernardino, California, USA
 Posts
 734
 Thanks
 0
 Thanked 0 Times in 0 Posts
Attached is a simple spreadsheet to determine pricing for an event consisting of X tables, it shows the price, the food & labor expenses, the overall profit and the profit per table. I can declare a desired profit per table and have the spreadsheet calculate the appropriate price adjustment to achieve that desired profit per table. However, I seem to be unable to create a formula where that adjustment is automatically applied to the overall price.
Can anyone help with this?

20100114, 17:55 #6
 Join Date
 Oct 2001
 Location
 San Bernardino, California, USA
 Posts
 734
 Thanks
 0
 Thanked 0 Times in 0 Posts
Attached is a simple spreadsheet to determine pricing for an event consisting of X tables, it shows the price, the food & labor expenses, the overall profit and the profit per table. I can declare a desired profit per table and have the spreadsheet calculate the appropriate price adjustment to achieve that desired profit per table. However, I seem to be unable to create a formula where that adjustment is automatically applied to the overall price.
Can anyone help with this?

20100114, 17:55 #7
 Join Date
 Oct 2001
 Location
 San Bernardino, California, USA
 Posts
 734
 Thanks
 0
 Thanked 0 Times in 0 Posts
Attached is a simple spreadsheet to determine pricing for an event consisting of X tables, it shows the price, the food & labor expenses, the overall profit and the profit per table. I can declare a desired profit per table and have the spreadsheet calculate the appropriate price adjustment to achieve that desired profit per table. However, I seem to be unable to create a formula where that adjustment is automatically applied to the overall price.
Can anyone help with this?

20100114, 17:55 #8
 Join Date
 Oct 2001
 Location
 San Bernardino, California, USA
 Posts
 734
 Thanks
 0
 Thanked 0 Times in 0 Posts
Attached is a simple spreadsheet to determine pricing for an event consisting of X tables, it shows the price, the food & labor expenses, the overall profit and the profit per table. I can declare a desired profit per table and have the spreadsheet calculate the appropriate price adjustment to achieve that desired profit per table. However, I seem to be unable to create a formula where that adjustment is automatically applied to the overall price.
Can anyone help with this?

20100114, 18:16 #9
 Join Date
 Jul 2002
 Location
 Pittsburgh, Pennsylvania, USA
 Posts
 11,225
 Thanks
 14
 Thanked 342 Times in 335 Posts
If you are looking for a calculation in [s]B2[/s]B4 so that B9=B8 try in [s]B2[/s]B4:
=B9*B2+B5+B6
Steve

20100114, 18:16 #10
 Join Date
 Jul 2002
 Location
 Pittsburgh, Pennsylvania, USA
 Posts
 11,225
 Thanks
 14
 Thanked 342 Times in 335 Posts
If you are looking for a calculation in [s]B2[/s]B4 so that B9=B8 try in [s]B2[/s]B4:
=B9*B2+B5+B6
Steve

20100114, 18:16 #11
 Join Date
 Jul 2002
 Location
 Pittsburgh, Pennsylvania, USA
 Posts
 11,225
 Thanks
 14
 Thanked 342 Times in 335 Posts
If you are looking for a calculation in [s]B2[/s]B4 so that B9=B8 try in [s]B2[/s]B4:
=B9*B2+B5+B6
Steve

20100114, 18:16 #12
 Join Date
 Jul 2002
 Location
 Pittsburgh, Pennsylvania, USA
 Posts
 11,225
 Thanks
 14
 Thanked 342 Times in 335 Posts
If you are looking for a calculation in [s]B2[/s]B4 so that B9=B8 try in [s]B2[/s]B4:
=B9*B2+B5+B6
Steve

20100114, 18:16 #13
 Join Date
 Jul 2002
 Location
 Pittsburgh, Pennsylvania, USA
 Posts
 11,225
 Thanks
 14
 Thanked 342 Times in 335 Posts
If you are looking for a calculation in [s]B2[/s]B4 so that B9=B8 try in [s]B2[/s]B4:
=B9*B2+B5+B6
Steve

20100114, 18:16 #14
 Join Date
 Jul 2002
 Location
 Pittsburgh, Pennsylvania, USA
 Posts
 11,225
 Thanks
 14
 Thanked 342 Times in 335 Posts
If you are looking for a calculation in [s]B2[/s]B4 so that B9=B8 try in [s]B2[/s]B4:
=B9*B2+B5+B6
Steve

20100114, 18:16 #15
 Join Date
 Jul 2002
 Location
 Pittsburgh, Pennsylvania, USA
 Posts
 11,225
 Thanks
 14
 Thanked 342 Times in 335 Posts
If you are looking for a calculation in [s]B2[/s]B4 so that B9=B8 try in [s]B2[/s]B4:
=B9*B2+B5+B6
Steve