دسترسی نامحدود
برای کاربرانی که ثبت نام کرده اند
دانلود کتاب Business Modeling with Spreadsheets Problems, Principles, and Practice
دانلود کتاب مدل سازی کسب و کار با صفحات گسترده مسائل، اصول و تمرین
مشخصات کتاب
Business Modeling with Spreadsheets Problems, Principles, and Practice
ویرایش: 2 ed. نویسندگان: Thin-Yin Leong, Michelle L.F. Cheong سری: ISBN (شابک) : 9780071078887, 125900998X ناشر: McGraw Hill سال نشر: 2013 تعداد صفحات: 474 زبان: English فرمت فایل : PDF (درصورت درخواست کاربر به PDF، EPUB یا AZW3 تبدیل می شود) حجم فایل: 39 مگابایت
قیمت کتاب (تومان) : 83,000
در صورت تبدیل فایل کتاب Business Modeling with Spreadsheets Problems, Principles, and Practice به فرمت های PDF، EPUB، AZW3، MOBI و یا DJVU می توانید به پشتیبان اطلاع دهید تا فایل مورد نظر را تبدیل نمایند.
توجه داشته باشید کتاب مدل سازی کسب و کار با صفحات گسترده مسائل، اصول و تمرین نسخه زبان اصلی می باشد و کتاب ترجمه شده به فارسی نمی باشد. وبسایت اینترنشنال لایبرری ارائه دهنده کتاب های زبان اصلی می باشد و هیچ گونه کتاب ترجمه شده یا نوشته شده به فارسی را ارائه نمی دهد.
توضیحاتی در مورد کتاب مدل سازی کسب و کار با صفحات گسترده مسائل، اصول و تمرین
پتانسیل واقعی نرمافزارهای صفحهگسترده در کاربرد آنها در کشف
مسئله و تجزیه و تحلیل موقعیت نهفته است، که به تحلیلگران تجاری و
مالی امکان میدهد تا به سرعت روی مشکلات بدون ساختار کار کنند.
مدلسازی کسبوکار با صفحات گسترده مجموعهای غنی از زمینهها و
یادداشتهای تجاری را ارائه میدهد که صفحات گسترده یادگیری را
جالبتر و کسب مهارتها را مؤثرتر و ماندگارتر میکند.
این کتاب برگرفته از تجربه گسترده نویسندگان در آموزش مدلسازی
صفحهگسترده در دورههای کارشناسی و کارشناسی ارشد در SMU است،
این کتاب کاملاً به هنر مدلسازی صفحهگسترده اکتشافی اختصاص
دارد. برخلاف سایر کتابها، این کتاب به گونهای طراحی شده است که
مدلمحور باشد، یعنی از صفحهگسترده عمدتاً به عنوان یک ابزار
محاسباتی استفاده میکند. مشکلات واقعی که خوانندگان به طور
روزانه با آنها مواجه می شوند، با هدف کمک به آنها در استخراج
اصول قابل اجرا و پیوند دادن اصول به تمرین ارائه شده است.
دانشآموختگان، دانشجویان فارغالتحصیل و متخصصانی که کارشان شامل
مدیریت توسعه تجارت، امور مالی، حسابداری و عملیات است، این کتاب
را یک راهنمای یادگیری با طراوت و منبع مرجع مفید خواهند یافت.
این کتاب اکنون 101 تمرین و ابزار صفحهگسترده را ارائه میکند و
شامل یک فصل جدید با 101 چالش تجاری اضافی است که خوانندگان
میتوانند به عنوان پروژههای مدلسازی انجام دهند. این پوشش
اکنون شامل اکسل 2007، اکسل 2003 و همچنین OpenOffice.org Calc در
بخشهای اختصاصی میشود و یادگیری مدلسازی کسبوکار را با
استفاده از ویژگیهای صفحهگسترده اولیه و پیشرفته برای هر شخصی،
اعم از مبتدی، مبتدی یا کاربر متخصص، آسانتر میکند. همچنین
برنامه نویسی در Visual Basic for Application و OpenOffice.org
Basic. کتابهای صفحه گسترده تکمیل شده در هر سه نسخه صفحه گسترده
نیز ارائه شده است.
توضیحاتی درمورد کتاب به خارجی
The true potential of spreadsheet software lies in their
application in problem discovery and situation analysis, which
enables business and financial analysts to work rapidly on
unstructured problems. Business Modeling with Spreadsheets
offers a rich set of business contexts and notes that make
learning spreadsheets interesting and acquiring of skills more
effective and enduring.
Arises from the authors extensive experience in teaching
spreadsheet modeling in undergraduate s and master s courses in
SMU, this book is wholly dedicated to the art of exploratory
spreadsheet modeling. Unlike other books, it is designed to be
modeling-centric, i.e. using the spreadsheet mainly as a
computing tool. Real problems that readers encounter on a
day-to-day basis are presented, with the aim of helping them
derive applicable principles and link principles to practice.
Undergraduates, graduate students and professionals whose work
involves managing business development, finance, accounting and
operations will find this book a refreshing learning guide and
handy reference resource. The book now offers 101 spreadsheet
exercises and tools, and includes a new chapter featuring an
additional 101 business challenges that the readers can do as
modeling projects. The coverage now spans Excel 2007, Excel
2003, as well as OpenOffice.org Calc in dedicated sections,
making it easier for any person, whether a novice, beginner, or
expert user, to learn business modeling using basic and
advanced spreadsheet features, as well as programming in Visual
Basic for Application and OpenOffice.org Basic. Completed
spreadsheet workbooks in all three spreadsheet versions are
also provided.
فهرست مطالب
Title Page Copyright Dedication Contents Preface Acknowledgments About the Authors CHAPTER 1 SPREADSHEET MODELING Ex 1: ACHILLES AND THE TORTOISE Ex 2: COMMUNITY WATER TANK Ex 3: PALIBALO FERRY Ex 4: ALEX PROCESSING Ex 5: DATA CENTER ASSETS Ex 6: FINANCIAL STATEMENT Ex 7: GROUP TRIP EXPENSES Ex 8: 100 METERS IN 9 SECONDS Ex 9: GINI INDEX Tip 1: Enter data only once Tip 2: Hard-coding Tip 3: Data, model, view Tip 4: Computer as an analysis tool Tip 5: Smart guessing CHAPTER 2 PROBLEM SOLVING AND SPREADSHEET ENGINEERING Ex 10: F1 NIGHT CITY RACE Ex 11: INKJET PRINTER Ex 12: FINANCIAL PROJECTION Ex 13: WEB STORE Ex 14: CASINO HOTEL Ex 15: VILLAGE COFFEE Ex 16: INVEST IN EDUCATION Ex 17: STOPPED WATCH Tip 6: Systemic view Tip 7: Systematic modeling Tip 8: Black-box diagram Tip 9: Influence diagram Tip 10: Vitals at the top Tip 11: Color coding Tip 12: Macro security CHAPTER 3 DATA LOOKUP AND LINKUP Ex 18: ECHO OFFICE SUPPLIES Ex 19: TRANSPORT COST Ex 20: CCH KINDERGARTEN Ex 21: CHOP SENG PROVISIONS Ex 22: OCEAN SHIPPING Ex 23: WEIGHT MANAGEMENT Ex 24: TOPIX WEIGHTS Tool 1: List management Tool 2: My investment portfolio Tool 3: Forms and links Tool 4: Data import Tip 13: Table headers Tip 14: Switch off gridlines Tip 15: Worksheet protection Tip 16: Linking cells across workbooks Tip 17: Orderly workbook Tip 18: Proper file names Tip 19: Version control Tip 20: Concurrent editing CHAPTER 4 RELATIONSHIPS Ex 25: TIME VALUE Ex 26: BUY, LEASE, OR RENT Ex 27: FLEXIBLE LOAN Ex 28: HOME LOAN IN CRISIS Ex 29: LEASE AND BUYBACK Ex 30: CHARITY DONATION Ex 31: SOTHIN AND SONS Ex 32: BLACK–SCHOLES Ex 33: BINOMIAL OPTION Ex 34: FOREIGN INVESTMENT Ex 35: GAME SCORING Ex 36: SAILING Tip 21: Working in the vacuum Tip 22: Entered before? Tip 23: Point and drag Tip 24: Right the first time Tip 25: Break it up Tip 26: Model documentation CHAPTER 5 MAKING ASSUMPTIONS Ex 37: WXYZ CONSTRUCTION Ex 38: FLY-BY-DAY AIR Ex 39: VILLAGE WATER Ex 40: EXTREME EXPLORERS Ex 41: WALK PLANS Ex 42: CRAZY AUCTION Ex 43: MARKET CLEARING PRICE Ex 44: BUY, SHARE, AND RENT Ex 45: MAKE A DEAL Ex 46: FAST SODUKU Ex 47: GOOGLE ADWORDS Tip 27: Keep it simple Tip 28: Verify and validate Tip 29: Test cases Tip 30: Back-testing CHAPTER 6 RISKS AND UNCERTAINTIES Ex 48: MONTE HALL Ex 49: CHANGE DISPENSING Ex 50: FREQUENCY DISTRIBUTION Ex 51: DATA SIMULATION Ex 52: JOHN LIM’S RETIREMENT Ex 53: PORTFOLIO SIMULATION Ex 54: FORECAST EYEBALL Ex 55: YANKEE FRUITS Ex 56: WONDERCOOKIES Tool 5: Statistical lies Tool 6: Statistics review Tool 7: Probability functions Tool 8: Resampling Tool 9: Lucky draw Tool 10: Card game Tool 11: Pick a number Tool 12: Bingo Tip 31: Modeling versus models Tip 32: Types of models Tip 33: Keeping it alive Tip 34: RAND in formulas CHAPTER 7 PROCESSES AND TIME Ex 57: TIMER-CLICKER Ex 58: XDB BANK Ex 59: CALL CENTER Ex 60: TANDEM QUEUES Ex 61: EMERGENCY SERVICES Ex 62: TIME AND TIDE Tool 13: week schedule Tool 14: Year planner – days and weeks Tool 15: Week planner Tool 16: Investment journal Tool 17: Countdown Tip 35: Invisible macro buttons Tip 36: Snap to fit Tip 37: Less clutter Tip 38: Six months later CHAPTER 8 ANALYZING THE DATA Ex 63: HOTEL APEX Ex 64: LIFE EXPECTANCY Ex 65: DUREX GLOBAL SEX SURVEY Ex 66: MY HAIR PLACE Ex 67: ABC SERVICES Ex 68: OFFSHORE DEVELOPMENT Ex 69: GRAND GROCERY Ex 70: PORTFOLIO ANALYSIS Ex 71: PORTFOLIO PLANNING Tool 18: Special statistics Tool 19: Data fit Tool 20: Goodness of fit Tip 39: Modeling analysis and data Tip 40: Real client Tip 41: Work with the client Tip 42: Spontaneity and planning Tip 43: Enterprise resource CHAPTER 9 MODELING PROJECTS Project 1: B. TANKEE Project 2: VOLUNTEERS MANAGEMENT Project 3: FAMILY SERVICES CENTER Project 4: NEW CAR PURCHASE Project 5: THE BETTER BOOKSTORE Project 6: CAKE LEGACY Project 7: ANIMAL EXCHANGE Project 8: SUZIE ICE RINK Project 9: METRO GET-AWAY Project 10: FREELANCE DANCERS Project 11: LOVE-IN-THE-AIR Project 12: FAMILY CLINIC Project 13: LL LEGAL Project 14: CAT-TV Community and Individual Project 15: AUTO CHALLENGE Project 16: FREE BUS STOPS Project 17: ALUMNI GIVING Project 18: VWO FINANCIAL RESERVES Project 19: Z-LINK Project 20: COMMUNITY MAPPING Project 21: STUDENT SOCIETY Project 22: WATERWAYS WATCH Project 23: ATTAINING THE 5Cs Project 24: CPF LIFE Project 25: BUY OR RENT PROPERTY Project 26: CALORIES AND NUTRITION Business and Services Project 27: CAFE STOP Project 28: KJC RESTAURANTS Project 29: SOUND EQUIPMENT Project 30: VIDEO RENTAL Project 31: KARAOKE Project 32: BLACKJACK Project 33: NEWSPAPER READERSHIP Project 34: KINDERGARTEN Project 35: UNIVERSITY LIBRARY Project 36: INTERNATIONAL CONFERENCE New Venture Project 37: FRANCHISE Project 38: MULTI-LEVEL MARKETING Project 39: BRIDAL SALON Project 40: DIFFERENT CUTS Project 41: LINGERIE XY Project 42: VEGGIE MANIA Project 43: FRIED TOFU Project 44: GRAB-FOOD EXPRESS Project 45: SINGAPORE FLYER Project 46: GRASS SKIING Project 47: BIKE TOUR Finance and Administration Project 48: NBA PLAYER SALARY Project 49: SALARY INCREMENT BUDGETTING Project 50: RATIO ANALYSIS Project 51: INTERNAL CREDIT RATING Project 52: LOAN DELINQENCIES Project 53: UNSECURED LOAN Project 54: INTERNET VALUATION Project 55: FIRM VALUATION Project 56: PROPERTY VALUATION Project 57: HEALTH INSURANCE PREMIUM Project 58: RELATIVE-VALUE EQUITY TRADING Project 59: FIXED INCOME ARBITRAGE Transportation and Distribution Project 60: SHUTTLE BUS SERVICE Project 61: COMMUTER PLUS Project 62: RENT-A-CAR Project 63: CHARTERED BUS Project 64: SS SUPERMART Project 65: SUBWAY SCHEDULE Project 66: SUBWAY FARE Project 67: CRUISE ITINERARY DESIGN Project 68: CRUISE TERMINAL DESIGN Project 69: AIR FLEET EXPANSION Project 70: SERVICE FACILITY LOCATION Project 71: TRAFFIC GROWTH Manufacturing and Operations Project 72: TECHNOLOGY CHOICE Project 73: FLEXIBLE CAPACITY Project 74: CAR DEMAND Project 75: INSPECTION SAMPLING Project 76: ECONOMIC ORDER QUANTITY Project 77: NEWSVENDOR PROBLEM Project 78: INVENTORY ABC Project 79: MULTIPLE-PERIOD INVENTORY SYSTEMS Project 80: PRODUCTION SEQUENCE Project 81: BUCKET BRIGADE Project 82: BEER GAME SOLITAIRE Project 83: XOS TIRES Information Technology and Communication Project 84: SOFTWARE DEVELOPMENT PLANNING Project 85: SOFTWARE PROJECTS PORTFOLIO Project 86: SOFTWARE DEVELOPMENT VENDOR MANAGEMENT Project 87: IT OUTSOURCING Project 88: ON-LINE TRADING Project 89: TRADE PROCESSING Project 90: INCIDENTS MANAGEMENT Project 91: BANDWIDTH PLANNING Project 92: WIRELESS NETWORK DESIGN Global and Environmental Project 93: GLOBAL OIL PRODUCTION Project 94: RENEWAL ENERGY Project 95: SAVE THE FORESTS Project 96: AGROFORESTRY Project 97: FISHING STOCK Project 98: POTABLE WATER Project 99: SUSTAINABLE PLANET Project 100: PANDEMIC CONTROL Project 101: MALARIA Tool 21: New exercise Tool 22: New project Tool 23: Modeling tools Tool 24: Learn Tool 25: Useful macros Tool 26: Spin wheel Tool 27: Limited trial Tool 28: Text data import and export Tool 29: Rename files Tool 30: TableSolve Tip 44: Excellent spreadsheet projects Tip 45: Not system development Tip 46: Not a one-off effort Tip 47: Confidentiality constraint Tip 48: Data security concerns Tip 49: Short names Tip 50: Project files Tip 51: Learning from others APPENDIX A - 1 EXCEL 2007 FEATURES AND FUNCTIONS Note 1: SPREADSHEET WINDOW Note 2: COMPUTATION Note 3: CELL REFERENCING Note 4: FORMATTING Note 5: DATA VALIDATION AND LOOKUP Note 6: RANDOM NUMBERS AND RESAMPLING Note 7: AUTOMATIC TABULATION Note 8: CHART Note 9: DATE, TIME, AND TEXT Note 10: LOGICAL FORMULA AND FUNCTION Note 11: DATA MANAGEMENT Note 12: TARGET AND OPTIMIZATION Note 13: DATA ANALYSIS Note 14: EXCEL 2007 VS EXCEL 2003 Note 15: MIGRATING TO OPENOFFICE.ORG CALC APPENDIX A - 2 EXCEL 2003 FEATURES AND FUNCTIONS Note 1: SPREADSHEET WINDOW Note 2: COMPUTATION Note 3: CELL REFERENCING Note 4: FORMATTING Note 5: DATA VALIDATION AND LOOKUP Note 6: RANDOM NUMBERS AND RESAMPLING Note 7: AUTOMATIC TABULATION Note 8: CHART Note 9: DATE, TIME, AND TEXT Note 10: LOGICAL FORMULA AND FUNCTION Note 11: DATA MANAGEMENT Note 12: TARGET AND OPTIMIZATION Note 13: DATA ANALYSIS Note 14: EXCEL 2003 VS EXCEL 2007 Note 15: MIGRATING TO OPENOFFICE.ORG CALC APPENDIX A - 3 CALC FEATURES AND FUNCTIONS Note 1: SPREADSHEET WINDOW Note 2: COMPUTATION Note 3: CELL REFERENCING Note 4: FORMATTING Note 5: DATA VALIDATION AND LOOKUP Note 6: RANDOM NUMBERS AND RESAMPLING Note 7: AUTOMATIC TABULATION Note 8: CHART Note 9: DATE, TIME, AND TEXT Note 10: LOGICAL FORMULA AND FUNCTION Note 11: DATA MANAGEMENT Note 12: TARGET AND OPTIMIZATION Note 13: DATA ANALYSIS Note 14: EXCEL 2003 VS EXCEL 2007 Note 15: MIGRATING TO OPENOFFICE.ORG CALC APPENDIX B - 1 VISUAL BASIC FOR APPLICATION Note 16: MACRO RECORDING Note 17: VISUAL BASIC GRAMMAR Note 18: MORE PROGRAMMING Note 19: SOLVER AND ADD-INS Note 20: AUTOMATIC PROCEDURES AND EVENTS Note 21: RUN-TIME ERROR HANDLING Note 22: SPREADSHEET PROGRAMMING APPROACH APPENDIX B - 2 OPENOFFICE.ORG BASIC Note 16: MACRO RECORDING Note 17: OOo BASIC GRAMMAR Note 18: MORE PROGRAMMING Note 19: EXTENSION AND ADD-INS Note 20: AUTOMATIC PROCEDURES AND EVENTS Note 21: RUN-TIME ERROR HANDLING Note 22: SPREADSHEET PROGRAMMING APPROACH Index
نظرات کاربران
کتاب های تصادفی
دانلود کتاب Skin Shows 4
دانلود کتاب Mule ESB cookbook : over 40 recipes to effectively build your enterprise solutions from the ground up using Mule ESB
