快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. Hide Unused Rows and Columns. See explanation.
                            3. Include Comments and Notes. See explanation.
                            4. Keep unprotected backup of Spreadsheet-based DSS. See explanation.
                            5. Pick Fonts Carefully. See explanation.
                            6. Plan it! See explanation.
                            7. Protect Spreadsheet-based DSS. See explanation.
                            8. Track Changes. See explanation.
                            9. Use Borders to Help Organize Worksheet Screens. See explanation.
                            10. Use Conditional Formatting. See explanation.
                            11. Use Data Forms. See explanation.
                            12. Use Informative Headers and Footers for Decision Support Reports. See explanation.
                            13. Use Input Boxes Sparingly. See explanation.
                            14. Use Message Boxes Sparingly. See explanation.
                            15. Use Parentheses in Complex Formulas. See explanation.

                            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