|
DataMuseum.dkPresents historical artifacts from the history of: CP/M |
This is an automatic "excavation" of a thematic subset of
See our Wiki for more about CP/M Excavated with: AutoArchaeologist - Free & Open Source Software. |
top - download
Length: 10752 (0x2a00)
Types: TextFile
Names: »BUDGET2.CMD«
└─⟦6ae1c04a5⟧ Bits:30004364 SW1656 IFPS/Personal Version 2.10 release 1.1
└─ ⟦this⟧ »BUDGET2.CMD«
beg:clear makewindow 2 4 19 73 1 clearwindow writeline writestr - setattr 14 writestr FINANCIAL BUDGET OPTIONS setattr 2 writeline - writeline setattr 4 writeline Financial Budget Options Press letter writeline ======================== ============ writeline Consolidate data C writeline List Consolidated database L writeline View Results V writeline Show Report S writeline Show Graph R writeline What_if Analysis W writeline Goal_seek Analysis G writeline writestr - setattr 13 writestr <Esc> or <F9> returns you to the main template menu setattr 2 writeline - menu1 MainMenu: Consolidate List_data View_spreadsheet Show_report menu2 gRaph What_if Goal_seek Quit Help menusel CLVSRWGQH getmenu pick ifnum &pick& = 0 then goto msg: ifnum &pick& = 1 then goto cons: ifnum &pick& = 2 then goto list: ifnum &pick& = 3 then goto view: ifnum &pick& = 4 then goto rep: ifnum &pick& = 5 then goto grf: ifnum &pick& = 6 then goto what: ifnum &pick& = 7 then goto goal: ifnum &pick& = 8 then goto out: ifnum &pick& = 9 then goto help: msg:clear dropmicro pick CLEAR COMMANDS TEMPLATE goto end: cons:clear message message Consolidating Product A,Product B,Product C,New Product .... RESET CONSOLIDATE PRODA,PRODB,PRODC,NEWPROD CREATE CONSOL SHOW ALL CLOSE message message Consolidation complete, press <Enter> to continue .... pause goback beg: list:clear dropmicro pick list CONSOL.DAT message message Hit <Enter> key to continue .... pause goback beg: view:clear makewindow 6 4 19 73 1 clearwindow setattr 14 writeline VIEWING &1 RESULTS setattr 4 writeline writeline VIEW mode allows you to see the spreadsheet results and the writeline model logic that produces the numbers on the same screen. writeline writeline After analyzing each screen, Press <Enter> to continue ..... writeline writestr pause 8 COMMANDS VIEW2 "&1" goback beg: rep:clear model consol EXECUTE RPCONSOL goback beg: grf:clear dropmicro pick model consol EXECUTE GFCONSOL goback beg: what:clear dropmicro pick makewindow 6 4 19 73 1 clearwindow setattr 14 writeline PLANNING AND BUDGETING WHAT IF ANALYSIS setattr 4 writeline writeline WHAT IF allows you to temporarily change any input assumption. writeline For example, what if the @c2 was higher??? writeline writeline The What if case will be generated for you automatically. writeline Watch for the integrated screen where the case is displayed writeline along with the What If Solution. writeline writeline After viewing each screen, Press <Enter> to continue .... writestr pause 8 COMMANDS WHAT2 "&1" goback beg: goal:clear dropmicro pick makewindow 3 4 19 73 1 clearwindow setattr 14 writeline PLANNING AND BUDGETING GOAL SEEK ANALYSIS setattr 4 writeline writeline GOAL SEEK allows you to define a target objective and ask writeline IFPS/Personal to find a policy to get you there. For example, writeline how much @c6 is required to achieve a target of: writeline writeline @c4=@c5 writeline writeline The Goal Seek analysis will be generated for you automatically. writeline Watch for the integrated screen where the Goal Seek Solution writeline is displayed with the Goal Seek inputs. writeline writeline After viewing each screen, Press <Enter> to continue ..... pause 8 COMMANDS GOAL2 "&1" goback beg: out:clear dropmicro pick makewindow 6 2 17 67 1 clearwindow writeline writeline You can now use IFPS/Personal on your own. writeline writeline To use the IFPS/Personal menus -- press <F9>. writeline To exit IFPS/Personal -- type QUIT. writeline To restart PersonalTemplates --- type COMMANDS TEMPLATE. writestr @A5 exit help:clear dropmicro pick makewindow 3 2 19 67 1 clearwindow writeline writeline * CONSOLIDATE - creates product database. writeline * LIST - lists product database. writeline * VIEW SPREADSHEET - View consolidated spreadsheet. writeline * REPORT - displays sample budget report. writeline * GRAPH - displays color graphs of keys trends. writeline * WHAT IF - temporary changes to input assumptions allowed. writeline * GOAL SEEK - target any bottom line figure and let writeline /Personal tell you how to achieve the result. writeline writeline Select any item for more details or reTurn .... writestr menu1 More: List View Reporting graPhing menu2 What_if Goal_seek Consolidate reTurn menusel LVRPWGCT getmenu pick ifnum &pick& = 0 then goback beg: ifnum &pick& = 1 then goto hlist: ifnum &pick& = 2 then goto hview: ifnum &pick& = 3 then goto hrep: ifnum &pick& = 4 then goto hgrf: ifnum &pick& = 5 then goto hint: ifnum &pick& = 6 then goto hint: ifnum &pick& = 7 then goto hcons: ifnum &pick& = 8 then goback beg: hlist:clear makewindow 1 4 20 73 1 clearwindow writeline Model logic statements for the template you have selected writeline will be displayed. These are the calculation relationships writeline used to generate the spreadsheet. Statements like: writeline writeline Projected Revenues=Unit Sales * Price writeline Unit Sales=Data for 5,TREND(TIME),PREVIOUS * SALES GROWTH writeline Price=500,PREVIOUS * PRICE INCREASES writeline writeline form a model of your problem. Notice here that the IFPS writeline language is both ENGLISH-LIKE and NON-PROCEDURAL, that is writeline statements do not have to be entered in order. Data can writeline be entered into the model, as in the Price statement, or writeline accessed from a database, the Data for 5 statement does writeline this for Unit Sales. Projections can be as defined by writeline you, as in the Sales Growth, or based on statistical writeline relationships over time, illustrated by the TREND function. writeline writestr Press <Enter> to continue .... pause goback help: hview:clear makewindow 1 4 20 73 1 clearwindow writeline View Mode of IFPS/Personal allows you to see the writeline spreadsheet results and the model logic which generated writeline the spreadsheet together on the same screen. The format writeline presented will be: writeline writeline Spreadsheet ........... writeline writeline ========================================================= writeline writeline Model Logic ............ writeline writeline View mode allows you to gain knowledge of BOTH the data and writeline problem relationships and provides enhanced decision support. writeline writestr Press <Enter> to continue .... pause goback help: hrep:clear makewindow 1 4 20 73 1 clearwindow writeline writeline Presentation quality reports can be generated from the writeline solution of your spreadsheets. Without redesigning the writeline spreadsheet, you can generate an unlimited number of reports writeline using qualities of the IFPS/Personal report writer to: writeline writeline * Select which variables and columns should be displayed. writeline * Setting output file format specifications. writeline * Using a variety of report writer utilities to highlight writeline key indicators in the results. writeline writeline Report independence from the spreadsheet allows you to writeline generate more information in a more flexible format. writeline writestr Press <Enter> to continue ..... pause goback help: hgrf:clear makewindow 2 4 19 73 1 clearwindow writeline writeline Presentation quality graphics can be generated from the writeline solution of your spreadsheets. Color graphs of any of the writeline key trends are available in the following formats: writeline writeline * 3-D Bar Charts. * Pie Charts writeline * Stacked Bar Charts * Line Charts writeline * Clusters * Percent Charts writeline writeline Color Graphics help to highlight information which does writeline not appear as prominently in either the spreadsheet or writeline a presentation report. Graphics can be displayed on either writeline a monitor or a variety of hard copy devices. writeline writestr Press <Enter> to continue ..... pause goback help: hint:clear makewindow 1 4 20 73 1 clearwindow writeline writeline Analysis of your spreadsheet can take one of two forms: writeline writeline * Ask WHAT IF one of my input assumptions is different. writeline * Ask What do I have to do to achieve a pre-defined writeline goal --- GOAL SEEK. writeline writeline WHAT IF allows you to make a TEMPORARY change to any number writeline of your input assumptions. You can enter a new value or writeline calculation in the place of the original assumption. writeline writeline GOAL SEEK is a very powerful feature of IFPS/Personal. It writeline allows you to target a bottom figure and ask - What change writeline in my input assumptions is required to achieve that goal? writeline writestr Press <Enter> to continue ..... pause goback help: hcons:clear makewindow 3 4 19 73 1 clearwindow writeline writeline The CONSOLIDATION Feature within IFPS/Personal allows you writeline to combine a series of entities together. For example: writeline writeline ------------- ------------- ------------- writeline * Company A * + * Company B * = * Corporate * writeline ------------- ------------- ------------ writeline writeline In this budgeting example, four product lines are being writeline added together to create a summary view for the corporate writeline model. The results of each line and the P/L effect that writeline each had on the corporate totals can be reported. writeline writestr Press <Enter> to continue ..... pause goback help: «eof»