快3|福彩网网址

      

                

                    

                          

                            


                            Spreadsheet-based DSS Resources
                            

                            Both Model-Driven and Data-Driven DSS can be built using spreadsheets. Solver add-ins are popular for building Model-Driven DSS based on optimization models. Small-scale, Data-Driven DSS can be built using Pivot table capabilities.
                            

                            

                            Resources
                            

Articles

                            
Instructional Materials

                            
General Sites

                            
Product Sites

                            


                            		


                            
Development Tips

                              

                            1. Add Hyperlinks to Integrate Your DSS with the 
Web.  See explanation.
                              2. 

                            2. Hide Unused Rows and Columns.  See explanation.
                              3. 

                            3. Include Comments and Notes.  See explanation.
                              4. 

                            4. Keep unprotected backup of Spreadsheet-based DSS. See explanation.
                              5. 


                            5. Pick Fonts Carefully.  See explanation.
                              6. 

                            6. Plan it!  See explanation.
                              7. 

                            7. Protect Spreadsheet-based DSS. See explanation.
                              8. 


                            8. Track Changes.  See explanation.
                              9. 

                            9. Use Borders to Help Organize Worksheet Screens.  See explanation. 
                              10. 

                            10. Use Conditional Formatting.  See explanation.
                              11. 

                            11. Use Data Forms.  See explanation.
                              12. 

                            12. Use Informative Headers and Footers for Decision Support Reports.  See explanation.
                              13. 

                            13. Use Input Boxes Sparingly.  See explanation. 
                              14. 

                            14. Use Message Boxes Sparingly.  See explanation. 
                              15. 

                            15. Use Parentheses in Complex Formulas.  See explanation. 
                              16. 

                            

                            

                            The tips and detailed explanations were written by Dr. Dan Power. 
                            


                            


                            

                            Ask Dan! 
                             


                            What is a Spreadsheet-based DSS? Dan's reply


                            What is active enterprise financial planning? Dan's reply


                            What is Planners Lab? Dan's reply


                            What is/was IFPS? Dan's reply


                            Who are the major vendors of Excel add-in programs for building model-driven DSS? Dan's reply



                            If you identify additional major spreadsheet links, please send an email message to power@www.auks2008.cn.
                            


                            


                                

                                          

                                              

                                                    

                                                      



                                                      

                                                      

                                                      Foreign exchange
                                                      		

                                                      constellation
                                                      		

                                                      news
                                                      		

                                                      

                                                      

                                                      Celebrity
                                                      		

                                                      reading
                                                      		

                                                      aviation
                                                      		

                                                      

                                                      

                                                      mailbox
                                                      		

                                                      Premier League
                                                      		

                                                      aviation