Saturday, January 10, 2009

Excel 2007 Charts or Advanced Rails Recipes

Excel 2007 Charts

Author: John Walkenbach

Excel, the top number-crunching tool, now offers a vastly improved charting function to help you give those numbers dimension and relativity. John Walkenbach, a.k.a. Mr. Spreadsheet, clearly explains all these charting features and shows you how to choose the right chart for your needs. You’ll learn to modify data within the chart, deal with missing data, format your chart, use trend lines, construct “impossible” charts, create charts from pivot tables, dress them up with graphics, and more.



See also: How to Be Invisible or Beginning GIMP

Advanced Rails Recipes: 84 New Ways to Build Stunning Rails Apps

Author: Mike Clark

From the author of the indispensable "Rails Recipes," and with the help of a new master Rails chef in the kitchen, here are 72 new ways to kick your Ruby on Rails apps up a notch. "More Rails Recipes" is a collection of practical recipes for dressing up your web application with little fuss. You'll learn how the pros have solved the tough problems using the most cutting-edge Rails techniques so you can deliver your stunning web app quicker and easier.
Developers by the thousands are coming to Rails-the benefits are clear, both to individuals and their organizations.
But how can a developer be expected to write idiomatic, effective Rails code when the technology is so new? The answer is to work alongside masters, people who've been there from the start (and who have the scars to prove it). And, what better way to learn from their experience than to look at their code and read their explanations of why it's written that way? And even better imagine if that code can be lifted and placed right into your own application.
This is better than just cut-and-paste: the recipe format means you'll understand the code, and be able to modify it to suit your needs. And the list of recipes is so broad that you're bound to find tips and techniques where you'll say "Oh! That's how they do that," or, "I didn't know you could do that in Rails."
With "More Rails Recipes," a following up to the popular original "Rails Recipes," you can cook up a storm.



Table of Contents:

Introduction 1

Pt. I REST and Routes Recipes 7

1 Create a RESTful Resource 9

2 Add Your Own RESTful Actions 15

3 Nest Resources to Scope Access 19

4 Toggle Attributes with Ajax 25

5 Authenticate REST Clients 29

6 Respond to Custom Formats 35

7 Catch All 404s 39

Pt. II Database Recipes 43

8 Add Foreign Key Constraints 45

9 Write Custom Validations 49

10 Take Advantage of Master/Slave Databases 53

11 Siphon Off SQL Queries 57

12 Use Fixtures for Canned Datasets 61

Pt. III User-Interface Recipes 65

13 Handle Multiple Models in One Form 67

14 Replace In-View Raw JavaScript 75

15 Validate Required Form Fields Inline 77

16 Create Multistep Wizards 81

17 Customize Error Messages 91

18 Upload Images with Thumbnails 93

19 Decouple JavaScript with Low Pro 103

20 Format Dates and Times 111

21 Support an iPhone Interface 115

Pt. IV Search Recipes 121

22 Improve SEO with Dynamic Metatags 123

23 Build a Site Map 127

24 Find Stuff (Quick and Dirty) 133

25 Search Text with Ferret 137

26 Ultra-Search with Sphinx 143

27 Solr-Power Your Search 151

Pt. V Design Recipes 163

28 Freshen Up Your Models with Scope 165

29 Create Meaningful Relationships Through Proxies 171

30 Keep Forms DRY and Flexible 175

31 Prevent Train Wrecks 181

32 Simplify Controllers with a Presenter 185

Pt. VI Integration Recipes 191

33 Process Credit Card Payments 193

34 Play Nice with Facebook 205

35 Mark Locations on a Google Map 207

36 Tunnel Back to Your Application 215

Pt. VII Console Snacks 219

37 Write Console Methods 221

38 Log to the Console 223

39 Play in the Sandbox 225

40 Access Helpers 227

41 Shortcut the Console 229

Pt. VIIIAsynchronous-Processing Recipes 231

42 Send Lightweight Messages 233

43 Off-Load Long-Running Tasks to BackgrounDRb 237

44 Process Asynchronous, State-Based Workflows 245

Pt. IX E-mail Recipes 251

45 Validate E-mail Addresses 253

46 Receive E-mail Reliably via POP or IMAP 257

47 Send E-mail via Gmail 263

48 Keep E-mail Addresses Up-to-Date 265

Pt. X Testing Recipes 271

49 Maintain Fixtures Without Frustration 273

50 Describe Behavior from the Outside In with RSpec 277

51 Test First with Shoulda 285

52 Write Domain-Specific RSpec Matchers 291

53 Write Custom Testing Tasks 295

54 Test JavaScript with Selenium 297

55 Mock Models with FlexMock 303

56 Track Test Coverage with rcov 307

57 Automatically Validate HTML 311

58 Mock with a Safety Net 315

59 Drive a Feature Top-Down with Integration Tests 317

Pt. XI Performance and Scalability Recipes 321

60 Cache Data Easily 323

61 Look Up Constant Data Efficiently 327

62 Profile in the Browser 333

63 Cache Up with the Big Guys 337

64 Dynamically Update Cached Pages 345

65 Use DTrace for Profiling 349

Pt. XII Security Recipes 357

66 Constrain Access to Sensitive Data 359

67 Encrypt Sensitive Data 361

68 Flip On SSL 367

Pt. XIII Deployment and Capistrano Recipes 371

69 Upload Custom Maintenance Pages 373

70 Generate Custom Error (404 and 500) Pages 377

71 Write Config Files on the Fly 381

72 Create New Environments 383

73 Run Multistage Deployments 387

74 Safeguard the Launch Codes 391

75 Automate Periodic Tasks 393

76 Preserve Files Between Deployments 399

77 Segregate Page Cache Storage with Nginx 401

78 Load Balance Around Your Mongrels' Health 405

79 Respond to Remote Capistrano Prompts 411

80 Monitor (and Repair) Processes with Monit 413

Pt. XIV Big-Picture Recipes 417

81 Manage Plug-in Versions 419

82 Fail Early 423

83 Give Users Their Own Subdomain 425

84 Customize and Analyze Log Files 431

Bibliography 437

Index 439

No comments:

Post a Comment