Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kckar
 
Posts: n/a
Default production frontier


i am making a production frontier

it is basically set up but i have the following requirements


Create 2 columns of numbers. The 1st containing integers from 0 to 20
and
labeled “Apples”. The second should contain the following formula:

= SQRT(20^2 – {Whatever # of Apples are in the adjacent cell}^2)

Call that 2nd column “Oranges”. Create a line-connected scatter plot
of the two and call the plot “Production Frontier”.

Pick one cell in the sheet and label it ‘Location’. Label the cell to
the right of it ‘Direction’. Use the following to define the value
inside Location :
= Location + Direction
Use an IF statement within the Direction cell that makes Direction
equal to 1 if Location is less than or equal to 19, and -1 if Location
is greater than or equal to 1. {Make sure to do this in the ‘iteration
mode’}



Basically there are three cases you'll need to take action for:
1) When location is no longer <=19, you need to turn around (make
direction=-1)
2) When location is no longer =1, you need to start moving up again
(make direction=1)
3) The rest of the time you need to "maintain" the direction

what do i put in the direction cell?


--
kckar
------------------------------------------------------------------------
kckar's Profile: http://www.excelforum.com/member.php...o&userid=25322
View this thread: http://www.excelforum.com/showthread...hreadid=512918

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
I AM LOOKING FOR A SIMPLE PRODUCTION SCHEDULE FOR MANUFACTURING wayne Excel Discussion (Misc queries) 1 December 18th 05 11:56 PM
forecast production jrM... Excel Worksheet Functions 2 October 6th 05 05:57 PM
Production CLock Thorrrr Excel Worksheet Functions 0 May 2nd 05 06:00 PM
percentage of production against quotation Nigel Excel Discussion (Misc queries) 3 April 22nd 05 02:34 PM
How do you graph a PPF (Production Possibilities Frontier) chart . tominindy Charts and Charting in Excel 0 January 29th 05 08:51 PM


All times are GMT +1. The time now is 07:33 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"