Tuesday, May 31, 2005
Erik's Linkblog
Erik's Linkblog: "Useful Java Application Components 0.9.25 "provides a powerful expression interpreter, an iText-based document processing engine, a charting library supporting JSP custom tags, and much more
Thought River Commons 2005.05.30
Features classes for working with XML, networking, metadata, graphs, Java code generation, and for creating self-healing software, among other things.
How Safe is WiFi?
It is the users who let them down, by not securing their networks, opening them to hackers and malcontents. Many times its sheer laziness.
Sunday, May 29, 2005
Creating Pivot Tables on the iSeries
by Bruce Guetzkow
If you've ever used spreadsheet software, there's a good chance that you've created a pivot table. Pivot tables allow you to convert rows of data into columns of data, which may be more meaningful to the end user. Creating pivot tables on the iSeries can be a complicated process. The commands demonstrated here will greatly simplify that task.
If you've ever used spreadsheet software, there's a good chance that you've created a pivot table. Pivot tables allow you to convert rows of data into columns of data, which may be more meaningful to the end user. Creating pivot tables on the iSeries can be a complicated process. The commands demonstrated here will greatly simplify that task.
Guide to Using XMLHttpRequest (with Baby Steps)
The XMLHttpRequest object is a handy dandy JavaScript object that offers a convenient way for webpages to get information from servers without refreshing themselves.
Although the XMLHttpRequest object might sound complex and different from any other JavaScript object you have ever used, it really isn't.
Although the XMLHttpRequest object might sound complex and different from any other JavaScript object you have ever used, it really isn't.
Just Fucking Google It
Someone thinks you are an idiot because you were too stupid to check Google before asking a question
Idea Share
This page regularly offers ideas for books or stories or works in other media, from those who can’t act upon them. In all cases they are offered in the hopes that these worthy projects will find their way to someone with the time and wherewithal to pursue them. Send yours to ideas@believermag.com.
Going Independent - Part 3 - Breaking Away
"The hardest part about eating sushi for the first time is actually convincing yourself to do it. You know that lots of other people are doing it and find the experience to be tremendously rewarding, but you’re afraid that if you try it yourself, you’re going to wind up in the bathroom slung over the porcelain throne wondering what the hell you were thinking in the first place. Many developers have the same fears about cutting their corporate ties and becoming an independent contractor"
Jonathan Goodyear
Jonathan Goodyear
Publicly available web services
Emerging web services standards such as SOAP, WSDL and UDDI will enable system-to-system integration that is easier than ever before. This site lists publicly available web services.
Do and don't battery table
Each battery has unique needs that must be met to obtain reliable service and long life. The Do and Don't battery table summarizes these needs and advises proper handling of each battery type.
Saturday, May 28, 2005
11 Ways to Improve Landing Pages
You’re about to launch a big online marketing campaign complete with media buys, search engine placement, banner ads and blog buzz. You’ve tested your creative and your clickthrough rate is strong. You know once you go live, tons of targeted traffic will be hitting your site.
Time to sit back and relax, right? Not quite yet.
Time to sit back and relax, right? Not quite yet.
Using Excel for Graphing
Most business intelligence products I've worked with do really simplistic graphing, decorated with a lot of useless chart junk. I often find myself pulling numbers and feeding them into Excel for better manipulation and graphing. Your typical BI tool can't automatically handle some incredibly useful charts which I learned years ago in Total Quality Management training and find myself reusing every year.
One of these is Shewhart control charts. Also Pac-Man, but that comes later.
One of these is Shewhart control charts. Also Pac-Man, but that comes later.
Flash Strikes Back: Creating Powerful Web Applications
Flash is a powerful tool that offers developers huge capabilities. Until recently, developers mostly utilized Flash's strengths to create complex animations or fast-loading movies. However, the most recent versions of Flash offer developers power that's far beyond the tool's original scope.
An object-oriented Javascript library
Prototype is a Javascript library that aims to ease development of dynamic web applications
Complete script for Life of Brian - Scene 9
REG:
All right, but apart from the sanitation, the medicine, education, wine, public order, irrigation, roads, a fresh water system, and public health, what have the Romans ever done for us?
All right, but apart from the sanitation, the medicine, education, wine, public order, irrigation, roads, a fresh water system, and public health, what have the Romans ever done for us?
There is more to data access than SQL
The number and variety of computing devices in the environment are increasing rapidly. Real computers are no longer tethered to desktops or locked in server rooms. PDAs, highly mobile tablet and laptop devices, palmtop computers, and mobile telephony handsets now offer powerful platforms for the delivery of new applications and services. These devices are, however, only the tip of the iceberg. Hidden from sight are the many computing and network elements required to support the infrastructure that makes ubiquitous computing possible
Friday, May 27, 2005
iFabricate is a documentation and collaboration system that helps you record and share your projects
iFabricate is a documentation and collaboration system that helps you record and share your projects with a mixture of images, text, ingredient lists, CAD files, and more. Documenting is fast and easy because you only have to list the high-level steps. iFabricate helps you link your projects to descriptions of tools, standard materials, and detailed sub-processes created by yourself and the ifabricate community. Incorporate helpful comments from expert-users to make sure your project always uses the best practice. Consumer electronics hacks, engineering prototyping, recipes, fine wood-working, and hobby projects are all equally ideal ifabricate projects.
Share your project exclusively with co-workers, open it to the world, or sell the plans or kit of parts. iFabricate lets you choose how and when your project goes public and gives you the forum to properly make and market it.
Share your project exclusively with co-workers, open it to the world, or sell the plans or kit of parts. iFabricate lets you choose how and when your project goes public and gives you the forum to properly make and market it.
11 steps to a better brain
It doesn't matter how brainy you are or how much education you've had - you can still improve and expand your mind. Boosting your mental faculties doesn't have to mean studying hard or becoming a reclusive book worm. There are lots of tricks, techniques and habits, as well as changes to your lifestyle, diet and behaviour that can help you flex your grey matter and get the best out of your brain cells. And here are 11 of them.
How to Stop Feeling Bad About Using Tables for Layout and Start Enjoying Your Markup
You must be really living out in the sticks if you haven't heard by now that using HTML tables for layout is bad. Markup is for content, CSS is for presentation, we learned.
You must be living in the land of magic mushrooms if you haven't realized by now that making CSS do exactly what you want is easier said than done.
See, in the ideal, happy-go-lucky world, everything is just right. The content, custom-tailored by suave professional markup writers, fits perfectly into the widths and proportions of your template. The browsers support standards at exactly the same level and in exactly the same way.
Too bad we don't live in Mayberry. With the loony Czar "The Exasperating" CSS 1.50304 ruling the presentational realm, it is surprisingly hard to build templates that are not brittle. Even The Man himself is battling with the idiosyncrasies of the dominant Web browser. And he's the sole content contributor to the site! What if the entries were written and posted by someone who neither knows nor cares about the quality of markup, which last time I checked, is the absolute majority of your typical content contributors?
Dimitri Glazkov
You must be living in the land of magic mushrooms if you haven't realized by now that making CSS do exactly what you want is easier said than done.
See, in the ideal, happy-go-lucky world, everything is just right. The content, custom-tailored by suave professional markup writers, fits perfectly into the widths and proportions of your template. The browsers support standards at exactly the same level and in exactly the same way.
Too bad we don't live in Mayberry. With the loony Czar "The Exasperating" CSS 1.50304 ruling the presentational realm, it is surprisingly hard to build templates that are not brittle. Even The Man himself is battling with the idiosyncrasies of the dominant Web browser. And he's the sole content contributor to the site! What if the entries were written and posted by someone who neither knows nor cares about the quality of markup, which last time I checked, is the absolute majority of your typical content contributors?
Dimitri Glazkov
Nodezilla is a secured, distributed, and fault tolerant routing system
Nodezilla is a secured, distributed, and fault tolerant routing system (or grid network) that supports distributed services such as file sharing, chat, efficient video multicast streaming, and secured file storage. It provides cache features where any server may create a local replica of any data object. These local replicas provide faster access and robustness to network partitions, and reduce network congestion by localizing access traffic. To ensure data protection, redundancy and cryptographic techniques are used.
IntelliJ IDEA, the future and my radical "throw out" thesis
Logemann:
"Radical thoughts on how to make this thing (IDEA) snappy again"
"Radical thoughts on how to make this thing (IDEA) snappy again"
Bank of America Launches SiteKey
Bank of America this morning announced the launch of a new protection service called SiteKey that helps confirm a customer's identification online.
27 May 2005 - Apache Portals Jetspeed 2.0 M3 (Milestone Release Third) Now Available
Jetspeed is an Enterprise Information Portal framework aiming to provide:
an efficient multi-device user customizable portal interface
a full implementation of the Java Portlet API used for developing customizable components that can be integrated into any compatible portal
The release is available for download from the Apache Download Mirrors:
http://www.apache.org/dyn/closer.cgi/portals/jetspeed-2/
Two binary releases are provided.
Jetspeed-2 + Tomcat 5.0.30 distribution.
Jetspeed-2 + Tomcat 5.5.9 distribution.
an efficient multi-device user customizable portal interface
a full implementation of the Java Portlet API used for developing customizable components that can be integrated into any compatible portal
The release is available for download from the Apache Download Mirrors:
http://www.apache.org/dyn/closer.cgi/portals/jetspeed-2/
Two binary releases are provided.
Jetspeed-2 + Tomcat 5.0.30 distribution.
Jetspeed-2 + Tomcat 5.5.9 distribution.
Java certification success
This hands-on tutorial helps SCEA certification aspirants clear the first part of the SCEA certification exam, a knowledge-based, multiple-choice exam. The tutorial introduces the main concepts and then builds upon them to provide readers with a solid foundation of the exam goals. Each section of the tutorial reinforces the readers' understanding through examples and practice questions.
Embedding simple, easy-to-write scripts into your Java apps with Groovy
Ever thought about embedding Groovy's simple, easy-to-write scripts in your more complex Java™ programs? In this installment of Practically Groovy, Andrew Glover shows you the many ways to incorporate Groovy into your Java code and explains where and when it's appropriate to do so.
EJOSA Revolutions Version 2.3 is available!
The Enterprise Java Open Source Architecture (EJOSA) Template was built
to help Java developers, develop J2EE projects with a low learning
curve. With little to no experience in J2EE, and a modest experience in
Java, developers were able to use the EJOSA template to create robust
and production-ready J2EE projects.
to help Java developers, develop J2EE projects with a low learning
curve. With little to no experience in J2EE, and a modest experience in
Java, developers were able to use the EJOSA template to create robust
and production-ready J2EE projects.
Feds shut down network that leaked 'Star Wars'
The raid, code-named Operation D-Elite, shut down one of the first peer-to-peer networks to post an illegal copy of "Star Wars: Episode III -- Revenge of the Sith" before the movie officially opened in theaters May 19.
Geronimo! Part 2: Get hands-on with operation, deployment, configuration, and management
Geronimo, the Apache Software Foundation's J2EE 1.4 server project, is integrating a large suite of existing open source services to achieve J2EE 1.4 compliance. Part 1 of this two-part series explored the reason for Geronimo, its design goals and architecture, and some core concepts and terminology. In this final part, Sing Li cuts to the chase and gets hands-on with Geronimo. Using the latest Geronimo distribution, you'll test and deploy a Web application, an enterprise application, Enterprise Java™Beans (EJBs), and more
Things I can’t Live Without: Firefox Crash Recovery
Matt Croydon
"I quite literally haven’t quit firefox properly in weeks. Crash Recovery allows me to save my browser state in a way that I’ve never been able to before. On Linux I’ll just issue a shutdown command, which will kill Firefox in the process. When I boot up and start Firefox again, I’m exactly where I was when I shut down"
"I quite literally haven’t quit firefox properly in weeks. Crash Recovery allows me to save my browser state in a way that I’ve never been able to before. On Linux I’ll just issue a shutdown command, which will kill Firefox in the process. When I boot up and start Firefox again, I’m exactly where I was when I shut down"
Bluetooth Eyes Audio, Home Automation
Enhancements to the Bluetooth core specification will help the technology expand into personal audio, home automation and global navigation systems
Database Hackers Reveal Tactics
Three young hackers under investigation for unlawfully accessing personal information on thousands of people in a LexisNexis database have characterized their act as a cyberjoyride that got out of hand.
The hackers, ages 16, 19 and 20, spoke with Wired News by phone Monday and said that in January and February they accessed LexisNexis data -- which included the Social Security number, birth date, home address and driver's license number of numerous celebrities and hacker friends -- to claim bragging rights, rather than to steal identities or sell the information to identity thieves, as some published reports have stated.
The hackers, ages 16, 19 and 20, spoke with Wired News by phone Monday and said that in January and February they accessed LexisNexis data -- which included the Social Security number, birth date, home address and driver's license number of numerous celebrities and hacker friends -- to claim bragging rights, rather than to steal identities or sell the information to identity thieves, as some published reports have stated.
The Java BluePrints book Designing Web Services with the J2EE 1.4 Platform: JAX-RPC, SOAP, and XML Technologies has just been made available for free
The book provides the guidelines, patterns, and real-world examples architects and developers need for designing and integrating enterprise-level Web services using the Java 2 Platform, Enterprise Edition (J2EE) 1.4
AltioLive Studio enables users to quickly build interactive rich client front ends to complex Web based applications
Included are a Visual GUI builder, a backend integration tool, and other development tools, which allow developers to build the interface for their applications quickly, remotely, and without touching an XML or Java editor, so that they can get on with developing the business logic on the backend.
edtFTPj/PRO is a Java library that performs secure file transfers
It supports FTPS (FTP over SSL), both explicit and implicit modes, and SFTP (FTP via SSH) All major FTP operations are supported, including both active and passive modes. It provides a progress monitor interface, allowing applications to receive progress updates for their file transfers. The library is built on the open source edtFTPj and shares its API
Tuesday, May 24, 2005
Why Crunch Mode (Long Hours) Doesn't Work
There's a bottom-line reason most industries gave up crunch mode over 75 years ago: It's the single most expensive way there is to get the work done
PS3 - Sony unveils the PlayStation 3
Sony have unveiled the first pictures and details of its planned PlayStation 3, showing off a machine with enormous horsepower, stunning graphics and a slew of multimedia elements.
Due in about a year [Spring 2006], the PlayStation 3 boasts an engine 35 times more powerful than the PlayStation 2, according to Sony. It will support up to seven wireless controllers and has outputs for two high-definition televisions (HDTVs)
Big Faceless PDF Library for creating PDF documents
The Big Faceless PDF Library is a Java class library for creating PDF documents. The Extended Edition offers the ability to create and edit AcroForms, PDF's answer to the HTML form. Like HTML forms, PDF forms can contain text boxes, radio buttons, and can call JavaScript functions. The Extended Edition also includes a PDF reader for importing and editing, along with FDF support and verification for Digital Signatures. Both variations offer full Unicode support, encryption, embedded TrueType and Type1 fonts, barcodes, hyperlinks, spot and calibrated color. Advanced text layout engine enables complex HTML styles. It is small, fast, easy to use, and 100% pure Java
FreeGuide TV Guide
FreeGuide TV Guide is a TV guide program which grabs listings for many countries from the Internet and allows you to view them and construct a personalised guide to print out. It uses the XMLTV tools to grab listings, and requires Java 1.4 or above
Publishers Protest Google Library Project
The Association of American University Presses said in a letter to Google that the online search engine's library project 'appears to involve systematic infringement of copyright on a massive scale
UNIX Basics : Examples with awk: A short introduction
This article gives some insight in to the tricks that you can do with AWK. It is not a tutorial but it provides real live examples to use
Monday, May 23, 2005
YourKit Java Profiler
YourKit Java Profiler is a CPU and memory profiler that makes it easy to solve wide range of CPU- and memory-related performance problems. It features automatic leak detection, powerful tools for the analysis of memory distribution, an object heap browser, comprehensive memory tests as part of your JUnit testing process, extremely low profiling overhead, transparent deobfuscation support, and integration with Eclipse, JBuilder, IntelliJ IDEA, NetBeans, and JDeveloper IDEs."
freshmeat.net: Project details for SupportDesk
SupportDesk is an Internet text chat system designed for Web sites that wish to provide their users with online support. A Java applet client allows users to log in to the chat system anonymously from a Web site and request help from the Web site operators.
HouseSpider website indexing and search
HouseSpider is a Java applet that adds indexing and search capability to Web sites. It can search by two methods: by spidering through the site, or by searching a cached index file. Spider-searching is slow, but very easy to set up and requires no maintenance. Cache-searching requires only a little more attention to set up and is sometimes even faster than CGI programs. HouseSpider also supports compression of the index file and boolean searches. Translations for several languages are provided, and it can handle Web sites in any language or encoding
Podcast support in next version of iTunes
At the Wall Street Journal's D Conference, Steve Jobs tonight showed ipodder-like features in the next release of iTunes, supposedly available within about 60 days. I was glad to see this, since the 'architecture of participation' has been the only one of the big Web 2.0 themes that Apple had seemed to be missing
Sunday, May 22, 2005
Saturday, May 21, 2005
BBC NEWS | UK | Wales | South West Wales | Town's secret Star Wars history
A relatively long time ago, in a west Wales town not too far away... arguably the most famous spaceship in the universe was created.
Friday, May 20, 2005
System State Changes: Who Will Be Affected?
IBM has said that, within the next year or two, i5/OS will be redesigned to prevent anyone from installing system state programs without IBM's permission. Ostensibly, the change is intended to increase the operating system's security. But some in the industry have their doubts
Paris Hilton Hack Started With Old-Fashioned Con
When hotel heiress Paris Hilton found out in February that her high-tech wireless phone had been taken over by hackers, many assumed that only a technical mastermind could have pulled off such a feat. But as it turns out, a hacker involved in the privacy breach said, the Hilton saga began on a decidedly low-tech note -- with a simple phone call.
Thursday, May 19, 2005
WebGalileo Faces 2.0 - Java Server Faces components
WebGalileo Faces is a set of highly customizable reusable user interface components that simplify the development of Java based web applications. With full support for the Sun Java Server Faces specification WebGalileo Faces finally provides developers with the tools needed to easily capture and respond to UI events in the browser
Free Spreadsheets
cVue
http://www.winsite.com/bin/Info?21000000038832
cVue is a spreadsheet that has been designed to better organise your work: arrange your sheets in our workbook, segregated by dividers (see screenshot). Much better than tabs!
Featurewise, you can enter values, text, dates etc. and format them as you might with any other spreadsheet. We support many formulas, a few unique formats and tools, and an import from Microsoft Excel. Currently, we are working on providing cross sheet linking and will eventually add charting and drawing tools.
We currently have no plans to charge for this software once the beta period ends. However, please be aware that this might change.
This download includes an uninstaller. It will not install any spyware or send to us any personal information.
Custom Spreadsheet Software
http://www.spreadsheet123.com
Custom Spreadsheet software and accounting systems development. Web site is full of free spreadsheets ready to download.
The Excel MVP Page
http://www.oaltd.co.uk/MVP/Default.htm
Welcome to the Excel MVP page. This page is intended to become a file library where the Microsoft Excel MVPs can place example files and utilities.
This page contains third party Excel add-ons .. for the more advanced users.
Blackcat : Spreadsheets and Graphs Software
http://www.blackcatsoftware.com/catalog/products/numbox2.html
NumberBox 2 is a spreadsheet package that has been specifically designed for use within the classroom.
Dynamic graphs | Export to HTML and Excel files | Attach notes to your spreadsheet using the built-in word processor | Easy access to resources | Save clippings for later use | Insert a sound file in a cell | E-mail spreadsheets to other users |
DataSweet : Data Handling Suite inc. Spreadsheet
http://www.kudlian.net/products/index.html
DataSweet has been developed specifically to meet the needs of data handling for the National Curriculum at Key Stages 1, 2 & 3. DataSweet is a powerful, yet clear and easy to use application which means that pupils are able to concentrate on the data handling activities without worrying about the complexity of the software.
The suite comprises of a graph drawing application, databases and a spreadsheet.
Microsoft Excel : Online Tutorial
http://www.wcu.edu/ccenter_inf/CatOnline/MSEX/index.html
Microsoft Excel Spreadsheet : Online Tutorial
Practise spreadsheet skills : an online quiz
http://www.school-resources.co.uk/FramesForKS3SpreadsheetQuiz.htm
Practise spreadsheet skills : an online quiz
As-Easy-AS Spreadsheet for Win95/98/Me/NT/2K/XP
http://www.triusinc.com/asawin.htm
As-Easy-AS Spreadsheet for Win95/98/Me/NT/2K/XP .. Shareware
Powerful 32-bit spreadsheet program with over 130 math, financial, scientific, statistical, string, date and time functions. Superb graphics. New macro programming language implementation. Min/Max Linear Programming. Goalseeking. Linear and Non-linear Multi-variate Regression. Internal and External User-definable Functions. Text Search & Replace. File Linking. Integration & Recursion. Beta and Gamma functions. Gaussian & Poisson distributions.
Free 30 day evaluation can be downloaded ... then US$49
Data analysis in Excel - helpsheets
http://tinyurl.com/22cev
Data analysis in Excel - helpsheets
Brief descriptions of how to use the data analysis tools in Excel
Filtering data in Excel | Subtotals in Excel | List of useful Excel functions | Summarising data in Excel | Data validation in Excel | Conditional formatting in Excel | Data entry in Excel |
Free Spreadsheet Software
http://www.pricelessware.org/2004/PL2004BUSINESS-HOME.htm#Spreadsheet
Free Spreadsheet Software ... an alternative to buying Excel.
Free Microsoft Excel Files, Templates and Utilities
http://www.winsite.com/edu/excel/
Free Microsoft Excel Files, Templates and Utilities
Including ..
Provides Search/Replacement function for textboxes or shapes | Free Financial Modeling lessons | Template for Excel. Punch card caulculator | Matrix and Linear Algebra for EXCEL | Random Task Assignments for 100 Volunteers | Rotating Shift Schedules for 25 People | If you want to learn microsoft excel follow these CBT lessons |
Max's Sandbox - K-2 interface for Word, Excel and PowerPoint
http://www.maxssandbox.com/
Max's Sandbox - K-2 interface for Word, Excel and PowerPoint
All the time kids are having fun with Max? Sandbox they are learning important life skills such as word processing, how to use spreadsheets and how to create professional-looking presentations.
Lewisham (UK) : KS4 GCSE ICT Writing Frames - Spreadsheets
http://www.lgfl.net/lgfl/leas/lewisham/communities/ICT/resources/Secondary/KS4_5/KS4.db_psc
Lewisham (UK) : KS4 GCSE ICT Writing Frames - Spreadsheets
Using Spreadsheets as a Problem-Solving Tool
http://www.crews.org/curriculum/teacher/GaETC/spreadsheets.htm
Using Spreadsheets as a Problem-Solving Tool
Spreadsheets are a very powerful tool that allows students to understand complicated word problems. They allow students to "spread" out data for manipulation, analysis, and reflection. Below are many examples that you can use to teach students how to use a spreadsheet as a tool to think at a higher level in order to solve real life word problems.
GCSE - Spreadsheets
http://www.ictgcse.org.uk/frm_projs.htm
GCSE - Spreadsheets | Fantasy League Project | Cinema/School Play Seating Project | A small business spreadsheet |
Community Students Spreadsheets
http://www.cleo.net.uk/community/spreadsheet?invite=1
This community is for teachers to use with their students/pupils. It has two distinct 'audiences'.
The first is for the teacher introducing students/pupils to spreadsheet applications or developing pupils understanding of how a spreadsheet can be used.
The examples remove the need to know how to prepare a spreadsheet or start with an over-facing screen of blank cells both for teacher and student.
There are various themes available but I am very willing to develop a theme from your own idea.
Just e-mail the idea with a few details of what you hope the spreadsheet will do.
The second audience is the teacher as a classroom administrator. Several spreadsheets are designed to make those tedious tasks a little easier.
5 Tips for Working with Multiple Worksheets in Excel
http://office.microsoft.com/assistance/2002/articles/pwExcelMultiWkShts.aspx
5 Tips for Working with Multiple Worksheets in Excel
Many projects involving Excel require you to work with a number of worksheets in a workbook. And often, the changes you make in one worksheet affect the data in another. Check out these five tips for working with data in multiple worksheets.
A blog about Maths and Numeracy
http://bodmas.blog-city.com/briefcase.cfm
A blog about Maths and Numeracy teaching pointing to resources and ideas for activities. Click on the month name in the calendar to see what I have been up to this month. Use the search box to find information on keywords like 'fractions' or 'spreadsheets'. - Keith Burnett.
One downloadable item is - e.g MS Excel spreadsheet to demonstrate the straight line and quadratic graphs
Are small bananas better value? - Spreadsheet
http://www.kented.org.uk/ngfl/ssheet/bananas.doc
Are small bananas better value? ... a great example of using spreadsheets.
Mr Excel
http://www.mrexcel.com/
Mr Excel
When you need help with Excel - whether it's solving an immediate emergency or simplifying a task - MrExcel.com is there. MrExcel.com is an entire community of Excel power users who are dedicated to helping you unleash the power of Excel.
Led by Mr. Excel himself, the community is always available to help you save time, create accurate, useful reports and make you the hero of your company meetings. And unlike a software support hotline or an independent "Excel genius", MrExcel.com can usually give you free, quick solutions through our Message Board. The MrExcel.com community is constantly checking for new questions and posting solutions. They're passionate about making Excel work for you.
Excel Spreadsheets and Add-Ins (free)
http://members.aol.com/johnp71/javasta2.html#Excel
Free plug-ins for the Excel spreadsheet
Spreadsheets Teaching Theme
http://teachers.teach-nology.com/themes/comp/spreadsheets/
Spreadsheets Teaching Theme
Some excellent spreadsheet teaching & learning resources ... and links to resources.
Tutorials (Beginner)| Graphing Activities | Hands-on Activities | Web Quests |
Evaluation of Sheetwise
http://www.ncte.ie/SoftwareCentral/Evaluations/Sheetwise/
"Sheetwise is a simple spreadsheet program for children. It introduces them to the concept of a spreadsheet, formulae and data handling without the clutter of more advanced programs."
Spreadsheets - Alternative Software (free)
http://www.shambles.net/pages/school/MSoffice/
Just as Microsoft Excel is a part of the "MS Office" package .... there are a number of free open source software packages such as OpenOffice, Star Office, ThinkFree Office ... that also contain Spreadsheet applications.
Students Spreadsheets at CLEO (UK)
http://www.cleo.net.uk/communities/
"Student Spreadsheets" - These are free Excel spreadsheets that can be used by students and pupils to enhence their work across various areas of the curriculum
If you are a first time visitor then you will need to register - free
Creating Pictographs in Excel - Lesson Plan
http://www.pics4learning.com/lessonplan_details.php?id=m05
Creating Pictographs in Excel
Objective - Students will complete a survey in Excel and create a spreadsheet using their data.
They will then use the Chart Wizard feature to create a pictograph using data and pictures they took in class or found on Pics4Learning.
Vocabulary Enrichment Using Excel
http://www.pics4learning.com/lessonplan_details.php?id=204
Vocabulary Enrichment Using Excel
Objective - Students learn and/or review vocabulary words by labeling a picture in Excel.
This activity would be a great addition to a foreign language class, or any class that requires students to learn or review specific vocabulary words or places.
Excel spreadsheets for the daily Mathematics lesson
http://www.kented.org.uk/ngfl/numeracy/spreadsheets.htm
Excel spreadsheets for the daily Mathematics lesson: simple, highly visual and ready to use. Cards, games and grids
Using Chart tool in Excel to Graph spelling results
http://www.virtualteacher.com.au/graphing.doc
Using Chart tool in Excel to Graph spelling results
Excel Template for Calculation Years and months
http://www.virtualteacher.com.au/yrsmths.xls
Excel Template for Calculation Years and months given a child's birthdate.
Includes formulas.
DO NOT CLICK TO OPEN THIS LINK, download this link by right clicking on the mouse and select, download link to disk.(for mac just hold the mouse down and dialogue box will come up).
After downloading open file in Microsoft Excel.
Spreadsheets... IT Advice for Novices
http://www.ictadvice.org.uk/new2computers/opt/menu_spread/page/tutorials
Spreadsheets... IT Advice for Novices
Excel 97 samples (PDF 109 KB) Covers performing calculations | How to set up Excel (PDF 168 KB) | Using spreadsheets (PDF 254 KB) |
Excel Formulas Learning Video Online
http://easylink.playstream.com/cbtnuggets/mous/formulas.wvx
Excel Formulas - Learning Video Online .. try it now!
GREAT online free tutorial
Spreadsheet | spreadsheets | tutorial | excel | video | online | Free Video Lessons from CBT Nuggets |
Other Spreadsheet Information
http://www.j-walk.com/ss/other/index.htm
Although Excel makes up the bulk of spreadsheet use, there are some other useful spreadsheet products available. This pages lists some products and spreadsheet-related tools that you may be interested in .. some are free.
spreadsheet | spreadsheets | software | free | download | downloads |
The Spreadsheet Page
http://www.j-walk.com/ss/
The Spreadsheet Page ... lots of serious and informative stuff ... but also a small area entitled : "Spreadsheet Jokes"
Office 11 Watch | Who Knew Excel Could Do That? | PUP v5 | Excel Developer Tips | Excel User Tips | JWalk Chart Tools | Excel Newsgroups | Top-10 pages at this site | Excel Charts |
Spreadsheets in Education
http://sunsite.univie.ac.at/Spreadsite/
Spreadsheets, Mathematics, Science, and Statistics Education
This page tries to collect some information about spreadsheets with an emphasis on mathematics and statistics education.
Spreadsheets in Education
Spreadsheet modelling from Devon (UK)
http://www.devon.gov.uk/dcs/ict/models/index.html
Spreadsheet modelling
Modelling - an introduction | Dictionary definitions | What is modelling? | Computer modelling | examples | spreadsheet | spreadsheets |
TRC Teacher Resource Exchange
http://tre.ngfl.gov.uk/
The Teacher Resource Exchange is a database of resources and activities designed to help teachers develop and share ideas for good practice. The new-look, redeveloped TRE provides a variety of navigational features designed to deliver resources specific to your needs.
Go to the site and type 'spreadsheet' into the search box to get some great examples from teachers.... in fact over 100 examples .. e.g.
Introducing spreadsheets | Using a spreadsheet to convert Sterling to Euro | Spreadsheets Lesson Plan | Variance Analysis Lesson Plan and Spreadsheet | Using Spreadsheet in Mathematics | Using spreadsheets to record heart rate and other physical data | Using spreadsheets to record heights | Spreadsheets in Business Studies | Spreadsheet Design in Key Skills - a Lesson Plan | Food Costings Spreadsheet | Menu (business) engineering spreadsheet | Teaching spreadsheets using Excel | Importing a spreadsheet and graph from Ecel to a Word document | Compound Interest / Repayment Spreadsheet | Analysis of diet using spreadsheet | Radioactive decay, spreadsheet | Advanced Spreadsheet Work | planning a party | Hundred Square | Floating and Sinking | Is Soil just Soil? | ICT and Maths - Data Handling | Acceleration due to gravity, Spreadsheeet |
Mathsnet - Spreadsheets
http://www.mathsnet.net/ssheets.html
Mathsnet - Spreadsheets
Using spreadsheets in education, not just for data handling but for pure mathematical investigation too.
Find out what a spreadsheet is, view a dictionary of basic spreadsheet terms and try out some ideas. Have a look also at these animations of common spreadsheet operations.
Embedded spreadsheets For you to view and use the embedded spreadsheets on these pages, you will need to install a free plug-in from Formula One/NET. Go to the download page for details.
spreadsheets | spreadsheet | math | maths |
Math lets : Spreadsheet and Graphing Tool
http://illuminations.nctm.org/mathlets/grapher/index.html
Mathlets are math applets you can use to explore math and create interactive lessons.
This interactive math applet combines the features of a spreadsheet and a graphing calculator. It can be used as a general tool or customized for specific purposes. For example, see how this tool can be used to investigate rational functions in the whelk i-Math Investigation, or exponential functions in the the decay of light i-Math or the trout population i-Math.
Grades 6-8 and 9-12
spreadsheet | spreadsheets |
Math lets - spreadsheet in your browser
http://illuminations.nctm.org/mathlets/spreadsheet/index.html
Mathlets are math applets you can use to explore math and create interactive lessons.
This simplified, yet powerful, spreadsheet has many of the same features as a complete spreadsheet. It is provided online so that you can remain in a web-browsing environment while using it, or in case you do not have a complete spreadsheet. It is a modified version of the Spreadsheet and Graphing Tool.
Grades 6-8 and 9-12
spreadsheet | spreadsheets |
Microsoft Excel Viewers and Converters (free)
http://office.microsoft.com/downloads/2000/xlviewer.aspx
The Microsoft Excel 97/2000 Viewer is recommended for use with a stand-alone computer that does not have Microsoft Excel installed. This product allows the user to open and view Excel 97 and Excel 2000 spreadsheet files. The viewer is not suitable for use on a server.
The Microsoft Excel 97 Viewer allows users to view and print Excel 97 and Excel 2000 spreadsheet files, in addition to other Excel for Windows? (versions 2.0 and greater) and Excel for the Macintosh? (versions 2.2a and greater) spreadsheet files. This small, freely distributable viewer gives users the flexibility to view page layout, copy and control cell sizes, and access the zoom and AutoFilter features. This viewer also supports OLE DocObject as well as the ability to view any Excel file.
Microsoft | Excel | Viewer |
Spreadsheets - more than just number crunching
http://top.ngfl.gov.uk/content.php3?content=content/b953743223.html
One of the main benefits of my laptop has been that I can now achieve administrative asks more quickly than before. For instance, I now compose letters, governors' reports and newsletters to parents. Very important to the work of the school, however, has been our use of spreadsheets.
The spreadsheets - or 'Tracking achievement sheets' as we call them - have developed from handwritten records I had been keeping for years.
Good Practice : Working with Excel
http://www.clickteaching.com/good_practice/spotlight_working_with_excel.shtml
Microsoft Excel can look like a complicated hing-functioning program for office users. Yet its features are easy to use, and can be worked to develop rich, interactive content for children to use. By learning some of the basic formualas you can bring all of the National Curriculum subjects alive.
The best way to find out how to use Excel to create interactive worksheets is to view some examples.
When you have downloaded the files, click around the worksheet to see how it is created.
Introduction to spreadsheets
http://www.educate.org.uk/teacher_zone/classroom/ict/unit5d.htm
In this unit children learn to enter numbers, labels and simple formulae into a spreadsheet and to use the data to calculate totals. Children will be introduced to spreadsheet software and will explore how changes in price and quantity can affect total cost. Children will apply what they have learnt in this unit when exploring mathematical and scientific models.
Children will be able to explore the effects of changing data in a spreadsheet.
A guideline sheet to help children produce a spreadsheet to calculate cost of buying several different items for a party.
Using Excel Templates (primary)
http://www.forsyth.k12.ga.us/sbeck/
How to Create a Template in Excel | Samples of Elementary Templates | Categorizing and graphing Skittles, surveying and graphing Eye Color and Pets | Did Somebody say Pizza? | Other Great Ideas for Using Excel with Primary Students |
Spreadsheet Tools
http://www.2learn.ca/teachertools/Spreadsheet/ssintro.htm
Spreadsheets can make you think! Working with spreadsheets can require practice of problem-solving skills.... There is a literacy in being able to input, process and reconstruct information through spreadsheet applications if projections made and conclusions drawn from the data are to be reasonable.
Boxplots in Excel
http://www.mis.coventry.ac.uk/~nhunt/boxplot.htm
A boxplot, or box and whisker diagram, provides a simple graphical summary of a set of data. It shows a measure of central location (the median), two measures of dispersion (the range and inter-quartile range), the skewness (from the orientation of the median relative to the quartiles) and potential outliers (marked individually).
DISCUS
http://www.mis.coventry.ac.uk/research/discus/discus_home.html
DISCUS is a set of interactive spreadsheets, written in Microsoft Excel, which are designed for teaching statistics at sixth form and first year undergraduate level.
The materials are designed to be used off the shelf by students working on their own, and little preparation by teaching staff is required.
It consists of a set of eight Microsoft Excel workbooks, each on a particular topic, and a set of associated photo-copyable workcards which provide a series of thought provoking challenges to help students gain insight and understanding.
Descriptive Statistics | Probability | Binomial Distributions | The Poisson Distribution | Continuous Distributions | Sampling | Regression | Hypothesis Testing |
Dinosaur data files
http://www.nhm.ac.uk/education/online/dinosaur_data_files.html
These dinosaur data files have been designed so that they can be printed out and photocopied for educational use in the classroom, at home or in the Museum itself. We have also created some suggestions for activities you may like to try, and a spreadsheet file in Excel format containing much of the data in these data files for further classroom work.
Spreadsheet resources
http://atschool.eduweb.co.uk/allsouls/ssheets/ssheet.html
Click on the icons below to download a set of Excel 5 spreadsheets that enables you to generate simple worksheets. Useful for homework or differentiation.
Simple 1,2 & 3 digit addition and subtraction plus simple multiplication
Simple function machines and addition squares
Putting numbers in order
http://www.winsite.com/bin/Info?21000000038832
cVue is a spreadsheet that has been designed to better organise your work: arrange your sheets in our workbook, segregated by dividers (see screenshot). Much better than tabs!
Featurewise, you can enter values, text, dates etc. and format them as you might with any other spreadsheet. We support many formulas, a few unique formats and tools, and an import from Microsoft Excel. Currently, we are working on providing cross sheet linking and will eventually add charting and drawing tools.
We currently have no plans to charge for this software once the beta period ends. However, please be aware that this might change.
This download includes an uninstaller. It will not install any spyware or send to us any personal information.
Custom Spreadsheet Software
http://www.spreadsheet123.com
Custom Spreadsheet software and accounting systems development. Web site is full of free spreadsheets ready to download.
The Excel MVP Page
http://www.oaltd.co.uk/MVP/Default.htm
Welcome to the Excel MVP page. This page is intended to become a file library where the Microsoft Excel MVPs can place example files and utilities.
This page contains third party Excel add-ons .. for the more advanced users.
Blackcat : Spreadsheets and Graphs Software
http://www.blackcatsoftware.com/catalog/products/numbox2.html
NumberBox 2 is a spreadsheet package that has been specifically designed for use within the classroom.
Dynamic graphs | Export to HTML and Excel files | Attach notes to your spreadsheet using the built-in word processor | Easy access to resources | Save clippings for later use | Insert a sound file in a cell | E-mail spreadsheets to other users |
DataSweet : Data Handling Suite inc. Spreadsheet
http://www.kudlian.net/products/index.html
DataSweet has been developed specifically to meet the needs of data handling for the National Curriculum at Key Stages 1, 2 & 3. DataSweet is a powerful, yet clear and easy to use application which means that pupils are able to concentrate on the data handling activities without worrying about the complexity of the software.
The suite comprises of a graph drawing application, databases and a spreadsheet.
Microsoft Excel : Online Tutorial
http://www.wcu.edu/ccenter_inf/CatOnline/MSEX/index.html
Microsoft Excel Spreadsheet : Online Tutorial
Practise spreadsheet skills : an online quiz
http://www.school-resources.co.uk/FramesForKS3SpreadsheetQuiz.htm
Practise spreadsheet skills : an online quiz
As-Easy-AS Spreadsheet for Win95/98/Me/NT/2K/XP
http://www.triusinc.com/asawin.htm
As-Easy-AS Spreadsheet for Win95/98/Me/NT/2K/XP .. Shareware
Powerful 32-bit spreadsheet program with over 130 math, financial, scientific, statistical, string, date and time functions. Superb graphics. New macro programming language implementation. Min/Max Linear Programming. Goalseeking. Linear and Non-linear Multi-variate Regression. Internal and External User-definable Functions. Text Search & Replace. File Linking. Integration & Recursion. Beta and Gamma functions. Gaussian & Poisson distributions.
Free 30 day evaluation can be downloaded ... then US$49
Data analysis in Excel - helpsheets
http://tinyurl.com/22cev
Data analysis in Excel - helpsheets
Brief descriptions of how to use the data analysis tools in Excel
Filtering data in Excel | Subtotals in Excel | List of useful Excel functions | Summarising data in Excel | Data validation in Excel | Conditional formatting in Excel | Data entry in Excel |
Free Spreadsheet Software
http://www.pricelessware.org/2004/PL2004BUSINESS-HOME.htm#Spreadsheet
Free Spreadsheet Software ... an alternative to buying Excel.
Free Microsoft Excel Files, Templates and Utilities
http://www.winsite.com/edu/excel/
Free Microsoft Excel Files, Templates and Utilities
Including ..
Provides Search/Replacement function for textboxes or shapes | Free Financial Modeling lessons | Template for Excel. Punch card caulculator | Matrix and Linear Algebra for EXCEL | Random Task Assignments for 100 Volunteers | Rotating Shift Schedules for 25 People | If you want to learn microsoft excel follow these CBT lessons |
Max's Sandbox - K-2 interface for Word, Excel and PowerPoint
http://www.maxssandbox.com/
Max's Sandbox - K-2 interface for Word, Excel and PowerPoint
All the time kids are having fun with Max? Sandbox they are learning important life skills such as word processing, how to use spreadsheets and how to create professional-looking presentations.
Lewisham (UK) : KS4 GCSE ICT Writing Frames - Spreadsheets
http://www.lgfl.net/lgfl/leas/lewisham/communities/ICT/resources/Secondary/KS4_5/KS4.db_psc
Lewisham (UK) : KS4 GCSE ICT Writing Frames - Spreadsheets
Using Spreadsheets as a Problem-Solving Tool
http://www.crews.org/curriculum/teacher/GaETC/spreadsheets.htm
Using Spreadsheets as a Problem-Solving Tool
Spreadsheets are a very powerful tool that allows students to understand complicated word problems. They allow students to "spread" out data for manipulation, analysis, and reflection. Below are many examples that you can use to teach students how to use a spreadsheet as a tool to think at a higher level in order to solve real life word problems.
GCSE - Spreadsheets
http://www.ictgcse.org.uk/frm_projs.htm
GCSE - Spreadsheets | Fantasy League Project | Cinema/School Play Seating Project | A small business spreadsheet |
Community Students Spreadsheets
http://www.cleo.net.uk/community/spreadsheet?invite=1
This community is for teachers to use with their students/pupils. It has two distinct 'audiences'.
The first is for the teacher introducing students/pupils to spreadsheet applications or developing pupils understanding of how a spreadsheet can be used.
The examples remove the need to know how to prepare a spreadsheet or start with an over-facing screen of blank cells both for teacher and student.
There are various themes available but I am very willing to develop a theme from your own idea.
Just e-mail the idea with a few details of what you hope the spreadsheet will do.
The second audience is the teacher as a classroom administrator. Several spreadsheets are designed to make those tedious tasks a little easier.
5 Tips for Working with Multiple Worksheets in Excel
http://office.microsoft.com/assistance/2002/articles/pwExcelMultiWkShts.aspx
5 Tips for Working with Multiple Worksheets in Excel
Many projects involving Excel require you to work with a number of worksheets in a workbook. And often, the changes you make in one worksheet affect the data in another. Check out these five tips for working with data in multiple worksheets.
A blog about Maths and Numeracy
http://bodmas.blog-city.com/briefcase.cfm
A blog about Maths and Numeracy teaching pointing to resources and ideas for activities. Click on the month name in the calendar to see what I have been up to this month. Use the search box to find information on keywords like 'fractions' or 'spreadsheets'. - Keith Burnett.
One downloadable item is - e.g MS Excel spreadsheet to demonstrate the straight line and quadratic graphs
Are small bananas better value? - Spreadsheet
http://www.kented.org.uk/ngfl/ssheet/bananas.doc
Are small bananas better value? ... a great example of using spreadsheets.
Mr Excel
http://www.mrexcel.com/
Mr Excel
When you need help with Excel - whether it's solving an immediate emergency or simplifying a task - MrExcel.com is there. MrExcel.com is an entire community of Excel power users who are dedicated to helping you unleash the power of Excel.
Led by Mr. Excel himself, the community is always available to help you save time, create accurate, useful reports and make you the hero of your company meetings. And unlike a software support hotline or an independent "Excel genius", MrExcel.com can usually give you free, quick solutions through our Message Board. The MrExcel.com community is constantly checking for new questions and posting solutions. They're passionate about making Excel work for you.
Excel Spreadsheets and Add-Ins (free)
http://members.aol.com/johnp71/javasta2.html#Excel
Free plug-ins for the Excel spreadsheet
Spreadsheets Teaching Theme
http://teachers.teach-nology.com/themes/comp/spreadsheets/
Spreadsheets Teaching Theme
Some excellent spreadsheet teaching & learning resources ... and links to resources.
Tutorials (Beginner)| Graphing Activities | Hands-on Activities | Web Quests |
Evaluation of Sheetwise
http://www.ncte.ie/SoftwareCentral/Evaluations/Sheetwise/
"Sheetwise is a simple spreadsheet program for children. It introduces them to the concept of a spreadsheet, formulae and data handling without the clutter of more advanced programs."
Spreadsheets - Alternative Software (free)
http://www.shambles.net/pages/school/MSoffice/
Just as Microsoft Excel is a part of the "MS Office" package .... there are a number of free open source software packages such as OpenOffice, Star Office, ThinkFree Office ... that also contain Spreadsheet applications.
Students Spreadsheets at CLEO (UK)
http://www.cleo.net.uk/communities/
"Student Spreadsheets" - These are free Excel spreadsheets that can be used by students and pupils to enhence their work across various areas of the curriculum
If you are a first time visitor then you will need to register - free
Creating Pictographs in Excel - Lesson Plan
http://www.pics4learning.com/lessonplan_details.php?id=m05
Creating Pictographs in Excel
Objective - Students will complete a survey in Excel and create a spreadsheet using their data.
They will then use the Chart Wizard feature to create a pictograph using data and pictures they took in class or found on Pics4Learning.
Vocabulary Enrichment Using Excel
http://www.pics4learning.com/lessonplan_details.php?id=204
Vocabulary Enrichment Using Excel
Objective - Students learn and/or review vocabulary words by labeling a picture in Excel.
This activity would be a great addition to a foreign language class, or any class that requires students to learn or review specific vocabulary words or places.
Excel spreadsheets for the daily Mathematics lesson
http://www.kented.org.uk/ngfl/numeracy/spreadsheets.htm
Excel spreadsheets for the daily Mathematics lesson: simple, highly visual and ready to use. Cards, games and grids
Using Chart tool in Excel to Graph spelling results
http://www.virtualteacher.com.au/graphing.doc
Using Chart tool in Excel to Graph spelling results
Excel Template for Calculation Years and months
http://www.virtualteacher.com.au/yrsmths.xls
Excel Template for Calculation Years and months given a child's birthdate.
Includes formulas.
DO NOT CLICK TO OPEN THIS LINK, download this link by right clicking on the mouse and select, download link to disk.(for mac just hold the mouse down and dialogue box will come up).
After downloading open file in Microsoft Excel.
Spreadsheets... IT Advice for Novices
http://www.ictadvice.org.uk/new2computers/opt/menu_spread/page/tutorials
Spreadsheets... IT Advice for Novices
Excel 97 samples (PDF 109 KB) Covers performing calculations | How to set up Excel (PDF 168 KB) | Using spreadsheets (PDF 254 KB) |
Excel Formulas Learning Video Online
http://easylink.playstream.com/cbtnuggets/mous/formulas.wvx
Excel Formulas - Learning Video Online .. try it now!
GREAT online free tutorial
Spreadsheet | spreadsheets | tutorial | excel | video | online | Free Video Lessons from CBT Nuggets |
Other Spreadsheet Information
http://www.j-walk.com/ss/other/index.htm
Although Excel makes up the bulk of spreadsheet use, there are some other useful spreadsheet products available. This pages lists some products and spreadsheet-related tools that you may be interested in .. some are free.
spreadsheet | spreadsheets | software | free | download | downloads |
The Spreadsheet Page
http://www.j-walk.com/ss/
The Spreadsheet Page ... lots of serious and informative stuff ... but also a small area entitled : "Spreadsheet Jokes"
Office 11 Watch | Who Knew Excel Could Do That? | PUP v5 | Excel Developer Tips | Excel User Tips | JWalk Chart Tools | Excel Newsgroups | Top-10 pages at this site | Excel Charts |
Spreadsheets in Education
http://sunsite.univie.ac.at/Spreadsite/
Spreadsheets, Mathematics, Science, and Statistics Education
This page tries to collect some information about spreadsheets with an emphasis on mathematics and statistics education.
Spreadsheets in Education
Spreadsheet modelling from Devon (UK)
http://www.devon.gov.uk/dcs/ict/models/index.html
Spreadsheet modelling
Modelling - an introduction | Dictionary definitions | What is modelling? | Computer modelling | examples | spreadsheet | spreadsheets |
TRC Teacher Resource Exchange
http://tre.ngfl.gov.uk/
The Teacher Resource Exchange is a database of resources and activities designed to help teachers develop and share ideas for good practice. The new-look, redeveloped TRE provides a variety of navigational features designed to deliver resources specific to your needs.
Go to the site and type 'spreadsheet' into the search box to get some great examples from teachers.... in fact over 100 examples .. e.g.
Introducing spreadsheets | Using a spreadsheet to convert Sterling to Euro | Spreadsheets Lesson Plan | Variance Analysis Lesson Plan and Spreadsheet | Using Spreadsheet in Mathematics | Using spreadsheets to record heart rate and other physical data | Using spreadsheets to record heights | Spreadsheets in Business Studies | Spreadsheet Design in Key Skills - a Lesson Plan | Food Costings Spreadsheet | Menu (business) engineering spreadsheet | Teaching spreadsheets using Excel | Importing a spreadsheet and graph from Ecel to a Word document | Compound Interest / Repayment Spreadsheet | Analysis of diet using spreadsheet | Radioactive decay, spreadsheet | Advanced Spreadsheet Work | planning a party | Hundred Square | Floating and Sinking | Is Soil just Soil? | ICT and Maths - Data Handling | Acceleration due to gravity, Spreadsheeet |
Mathsnet - Spreadsheets
http://www.mathsnet.net/ssheets.html
Mathsnet - Spreadsheets
Using spreadsheets in education, not just for data handling but for pure mathematical investigation too.
Find out what a spreadsheet is, view a dictionary of basic spreadsheet terms and try out some ideas. Have a look also at these animations of common spreadsheet operations.
Embedded spreadsheets For you to view and use the embedded spreadsheets on these pages, you will need to install a free plug-in from Formula One/NET. Go to the download page for details.
spreadsheets | spreadsheet | math | maths |
Math lets : Spreadsheet and Graphing Tool
http://illuminations.nctm.org/mathlets/grapher/index.html
Mathlets are math applets you can use to explore math and create interactive lessons.
This interactive math applet combines the features of a spreadsheet and a graphing calculator. It can be used as a general tool or customized for specific purposes. For example, see how this tool can be used to investigate rational functions in the whelk i-Math Investigation, or exponential functions in the the decay of light i-Math or the trout population i-Math.
Grades 6-8 and 9-12
spreadsheet | spreadsheets |
Math lets - spreadsheet in your browser
http://illuminations.nctm.org/mathlets/spreadsheet/index.html
Mathlets are math applets you can use to explore math and create interactive lessons.
This simplified, yet powerful, spreadsheet has many of the same features as a complete spreadsheet. It is provided online so that you can remain in a web-browsing environment while using it, or in case you do not have a complete spreadsheet. It is a modified version of the Spreadsheet and Graphing Tool.
Grades 6-8 and 9-12
spreadsheet | spreadsheets |
Microsoft Excel Viewers and Converters (free)
http://office.microsoft.com/downloads/2000/xlviewer.aspx
The Microsoft Excel 97/2000 Viewer is recommended for use with a stand-alone computer that does not have Microsoft Excel installed. This product allows the user to open and view Excel 97 and Excel 2000 spreadsheet files. The viewer is not suitable for use on a server.
The Microsoft Excel 97 Viewer allows users to view and print Excel 97 and Excel 2000 spreadsheet files, in addition to other Excel for Windows? (versions 2.0 and greater) and Excel for the Macintosh? (versions 2.2a and greater) spreadsheet files. This small, freely distributable viewer gives users the flexibility to view page layout, copy and control cell sizes, and access the zoom and AutoFilter features. This viewer also supports OLE DocObject as well as the ability to view any Excel file.
Microsoft | Excel | Viewer |
Spreadsheets - more than just number crunching
http://top.ngfl.gov.uk/content.php3?content=content/b953743223.html
One of the main benefits of my laptop has been that I can now achieve administrative asks more quickly than before. For instance, I now compose letters, governors' reports and newsletters to parents. Very important to the work of the school, however, has been our use of spreadsheets.
The spreadsheets - or 'Tracking achievement sheets' as we call them - have developed from handwritten records I had been keeping for years.
Good Practice : Working with Excel
http://www.clickteaching.com/good_practice/spotlight_working_with_excel.shtml
Microsoft Excel can look like a complicated hing-functioning program for office users. Yet its features are easy to use, and can be worked to develop rich, interactive content for children to use. By learning some of the basic formualas you can bring all of the National Curriculum subjects alive.
The best way to find out how to use Excel to create interactive worksheets is to view some examples.
When you have downloaded the files, click around the worksheet to see how it is created.
Introduction to spreadsheets
http://www.educate.org.uk/teacher_zone/classroom/ict/unit5d.htm
In this unit children learn to enter numbers, labels and simple formulae into a spreadsheet and to use the data to calculate totals. Children will be introduced to spreadsheet software and will explore how changes in price and quantity can affect total cost. Children will apply what they have learnt in this unit when exploring mathematical and scientific models.
Children will be able to explore the effects of changing data in a spreadsheet.
A guideline sheet to help children produce a spreadsheet to calculate cost of buying several different items for a party.
Using Excel Templates (primary)
http://www.forsyth.k12.ga.us/sbeck/
How to Create a Template in Excel | Samples of Elementary Templates | Categorizing and graphing Skittles, surveying and graphing Eye Color and Pets | Did Somebody say Pizza? | Other Great Ideas for Using Excel with Primary Students |
Spreadsheet Tools
http://www.2learn.ca/teachertools/Spreadsheet/ssintro.htm
Spreadsheets can make you think! Working with spreadsheets can require practice of problem-solving skills.... There is a literacy in being able to input, process and reconstruct information through spreadsheet applications if projections made and conclusions drawn from the data are to be reasonable.
Boxplots in Excel
http://www.mis.coventry.ac.uk/~nhunt/boxplot.htm
A boxplot, or box and whisker diagram, provides a simple graphical summary of a set of data. It shows a measure of central location (the median), two measures of dispersion (the range and inter-quartile range), the skewness (from the orientation of the median relative to the quartiles) and potential outliers (marked individually).
DISCUS
http://www.mis.coventry.ac.uk/research/discus/discus_home.html
DISCUS is a set of interactive spreadsheets, written in Microsoft Excel, which are designed for teaching statistics at sixth form and first year undergraduate level.
The materials are designed to be used off the shelf by students working on their own, and little preparation by teaching staff is required.
It consists of a set of eight Microsoft Excel workbooks, each on a particular topic, and a set of associated photo-copyable workcards which provide a series of thought provoking challenges to help students gain insight and understanding.
Descriptive Statistics | Probability | Binomial Distributions | The Poisson Distribution | Continuous Distributions | Sampling | Regression | Hypothesis Testing |
Dinosaur data files
http://www.nhm.ac.uk/education/online/dinosaur_data_files.html
These dinosaur data files have been designed so that they can be printed out and photocopied for educational use in the classroom, at home or in the Museum itself. We have also created some suggestions for activities you may like to try, and a spreadsheet file in Excel format containing much of the data in these data files for further classroom work.
Spreadsheet resources
http://atschool.eduweb.co.uk/allsouls/ssheets/ssheet.html
Click on the icons below to download a set of Excel 5 spreadsheets that enables you to generate simple worksheets. Useful for homework or differentiation.
Simple 1,2 & 3 digit addition and subtraction plus simple multiplication
Simple function machines and addition squares
Putting numbers in order
Design Patterns for AJAX Usability
AJAX holds a lot of promise for web usability, and the underlying technology has already delivered some stunning applications. But its no magic bullet. Careful design is always required, and it must be based specifically on the technology at hand. As AJAX emerges, were going to learn more about what sort of design works, and well need ways of documenting this information and talking about it. Fortunately, the evolution of this particular technology will take place at a time when design patterns are well-entrenched in the industry, and design patterns are an excellent means of knowledge representation. Thus, it makes sense to begin cataloguing AJAX design patterns. These are some thoughts based on current examples and demo systems
Software Theory and Practice for the Real World by Michael Mahemoff
Software Theory and Practice for the Real World by Michael Mahemoff
Getting Things Done With Delete
One of the easiest ways to eliminate a problem or to make something better is to take something away
50 Fun Things To Do With Your iPod
In the four years since its introduction, the iPod has proven to be a versatile little device. Despite a relatively closed architecture, hackers have found their way in. Content creators and software makers put information at your fingertips when you're on the go. Would-be designers have added to the fashionable stylings of the now-ubiquitous white ear buds. Hardware makers and enthusiasts have augmented the iPod with new add-on gadgets. Here are a few dozen things you can do with your iPod besides listen to music
EssentialPIM - Absolutely free, powerful PIM
EssentialPIM - free and innovative Personal Information Manager
Tips for improving your handwriting
Youve decided you want to improve your handwriting and youre probably hoping a fountain pen will do the trick -- maybe a friend told you it would. Maybe youre just adventurous and you want to try your hand at calligraphy (or you might, once your handwriting improves). Good for you!
A fountain pen may make your writing look a bit better, but if your writing looks as if frenzied chickens got loose on the page, chances are this wont be enough. Most likely, youll need to retrain your arm and hand
A fountain pen may make your writing look a bit better, but if your writing looks as if frenzied chickens got loose on the page, chances are this wont be enough. Most likely, youll need to retrain your arm and hand
Power users need a fix
You hear a lot about the mobile population always looking for WiFi hotspots while on the road so they can do their internet work and email. What you don't hear much about is how the same workers are also looking for power
The Beeb Shall Inherit the Earth
America's entertainment industry is committing slow, spectacular suicide, while one of Europe's biggest broadcasters -- the BBC -- is rushing headlong to the future, embracing innovation rather than fighting it.
Unlike Hollywood, the BBC is eager and willing to work with a burgeoning group of content providers whose interests are aligned with its own: its audience
Unlike Hollywood, the BBC is eager and willing to work with a burgeoning group of content providers whose interests are aligned with its own: its audience
IBM eServer iSeries - iSeries NetServer: Command Line Setup
iSeries NetServer (formerly AS/400 NetServer) is IBM eServer iSeries support for Windows Network Neighborhood.
This fast-path document is designed to get your iSeries NetServer configured and running quickly in your network. Use iSeries NetServer to share integrated file system directories as well as output queues to your networked Windows or Linux computers for file and print access
This fast-path document is designed to get your iSeries NetServer configured and running quickly in your network. Use iSeries NetServer to share integrated file system directories as well as output queues to your networked Windows or Linux computers for file and print access
Free Excel SpreadSheets
Capital Budgeting Analysis (xls) - Basic program for doing capital budgeting analysis with inclusion of opportunity costs, working capital requirements, etc.
Rating Calculation (xls) - Estimates a rating and cost of debt based on the coverage of debt by an organization.
LBO Valuation (xls) - Analyzes the value of equity in a leverage buyout (LBO).
Synergy (xls) - Estimates the value of synergy in a merger and acquisition.
Valuation Models (xls) - Rough calculation for choosing the correct valuation model.
Risk Premium (xls) - Calculates the implied risk premium in a market. (uses macro's).
FCFE Valuation 1 (xls) - Free Cash Flow to Equity (FCFE) Valuation Model for organizations with stable growth rates.
FCFE Valuation 2 (xls) - Free Cash Flow to Equity (FCFE) Valuation Model for organizations with two periods of growth, high growth initially and then stable growth.
FCFE Valuation 3 (xls) - Free Cash Flow to Equity (FCFE) Valuation Model for organizations with three stages of growth, high growth initially, decline in growth, and then stable growth.
FCFF Valuation 1 (xls) - Free Cash Flow to Firm (FCFF) Valuation Model for organizations with stable growth rates.
FCFF Valuation 2 (xls) - Free Cash Flow to Firm (FCFF) Valuation Model for organizations with two periods of growth, high growth initially and then stable growth.
Time Value (xls) - Introduction to time value concepts, such as present value, internal rate of return, etc.
Lease or Buy a Car (xls) - Basic spreadsheet for deciding to buy or lease a car.
NPV & IRR (xls) - Explains Internal Rate of Return, compares projects, etc.
Real Rates (xls) - Demonstrates inflation and real rates of return.
Template (xls) - Template spreadsheet for project evaluation & capital budgeting.
Free Cash Flow (xls) - Cash flow worksheets - subsidized and unsubsidized.
Capital Structure (xls) - Spreadsheet for calculating optimal capital structures using different percents of debt.
WACC (xls) - Calculation of Weighted Average Cost of Capital using beta's for equity.
Statements (xls) - Generate a set of financial statements using two input sheets - operational data and financial data.
Bond Valuation (zip) - Calculates the value or price of a 25 year bond with semi-annual interest payments.
Buyout (zip) - Analyzes the effects of combining two companies.
Cash Flow Valuation (zip) - Walks through a valuation of cash flows under three models- capital cash flows, equity cash flows, and free cash flows.
Financial Projections (zip) - Spreadsheet model for generating projected financials along with valuation based on WACC.
Leverage (zip) - Shows the effects on Net Income from using debt (leverage).
Ratio Calculator (zip) - Calculates a standard set of ratios based on input of financial data.
Stock Value (zip) - Calculates expected return on stock and value based on no growth, growth, and variable growth.
CFROI (xls) - Simplified Cash Flow Return on Investment Model.
Financial Charting (zip) - Add on tool for Excel 97, consists of 6 files.
Risk Analysis (exe) - Analysis and simulation add on for excel, self extracting exe file.
Black Scholes Option Pricing (zip) - Excel add on for the pricing of options.
Cash Flow Matrix - Basic cash flow model.
Business Financial Analysis Template for start-up businesses from Small Business Technology Center
Forex (zip) - Foreign market exchange simulation for Excel
Hamlin (zip) - Financial function add-on's for Excel
Tanly (zip) - Suite of technical analysis models for Excel
Financial History Pivot Table - Microsoft Financials
Income Statement What If Analysis
Breakeven Analysis (zip) - Pricing and breakeven analysis for optimal pricing - Biz Pep.
SLG Ratio Master (exe) - Excel workbook for creating 25 key performance ratios.
DCF - Menu driven Excel program (must enable macros) for Discounted Cash Flow Analysis from the book Analysis for Financial Management by Robert C. Higgins
History - Menu driven Excel program (must enable macros) for Historical Financial Statements from the book Analysis for Financial Management by Robert C. Higgins
Proforma - Menu driven Excel program (must enable macros) for Pro-forma Financial Statements from the book Analysis for Financial Management by Robert C. Higgins
Business Valuation Model (zip) - Set of tabbed worksheets for generating forecast / valuation outputs. Includes instruction sheet. Bizpep
LBO Model - Excel model for leveraged buy-outs
Comparable Companies - Excel valuation model comparing companies
Combination Model - Excel valuation model for combining companies
Balanced Scorecard - Set of templates for building a balanced scorecard.
Cash Model - Template for calculating projected financials from CFO Connection
Techniques of Financial Analysis - Workbook of 11 templates (breakeven, valuation, forecasting, etc.) from ModernSoft
Ratio Reminder (zip) - Simple worksheet of comparative financials and corresponding ratios from Agilicor
Risk Analysis IT - Template for assessing risk of Information Technology - Audit Net
Risk Analysis DW - Template for assessing risk of Data Warehousing - Audit Net
Excel Workbook 1-2 - Set of worksheets for evaluating financial performance and forecasting - Supplemental Material for Short Course 1 and 2 on this website.
Rule Maker Essentials - Excel Template for scoring a company by entering financial data - The Motley Fool
Rule Maker Ranker - Excel Template for scoring a company by entering comparable data - The Motley Fool
IPO Timeline - Excel program for Initial Public Offerings (must enable macros)
Assessment Templates - Set of templates for assessing an organization based on the Malcolm Baldrige Quality Model.
Cash Gap in Days - Spreadsheet for calculating number of days required for short-term financing.
Cash Flow Template - Simple spreadsheet for calculating Free Cash Flow.
Six Solver Workbook (zip) - Set of various spreadsheets for solving different business problems (inventory ordering, labor scheduling, working capital, etc.).
Free Cash Flow Valuation - Basic Spreadsheet Valuation Model
Finance Examples - Seven examples in Business Finance - Solver
Capital Budgeting Workbook - Several examples of capital budgeting analysis, including the use of Solver to select optimal projects.
Present Value Tables (rtf) - Set of present value tables written in rich text format, compatible with most word processors. Includes examples of how to use present value tables.
Investment Valuation Model (zip) - Valuation model of companies (must enable macros) - Excel Business Tools
Cash Flow Sensitivity (xlt) - Sensitivity analysis spreadsheet - Small Business Store
What If Analysis - Set of templates for sensitivity analysis using financial inputs.
Risk Return Optimization - Optimal project selection - Metin Kilic (must enable macro's)
Rating Calculation (xls) - Estimates a rating and cost of debt based on the coverage of debt by an organization.
LBO Valuation (xls) - Analyzes the value of equity in a leverage buyout (LBO).
Synergy (xls) - Estimates the value of synergy in a merger and acquisition.
Valuation Models (xls) - Rough calculation for choosing the correct valuation model.
Risk Premium (xls) - Calculates the implied risk premium in a market. (uses macro's).
FCFE Valuation 1 (xls) - Free Cash Flow to Equity (FCFE) Valuation Model for organizations with stable growth rates.
FCFE Valuation 2 (xls) - Free Cash Flow to Equity (FCFE) Valuation Model for organizations with two periods of growth, high growth initially and then stable growth.
FCFE Valuation 3 (xls) - Free Cash Flow to Equity (FCFE) Valuation Model for organizations with three stages of growth, high growth initially, decline in growth, and then stable growth.
FCFF Valuation 1 (xls) - Free Cash Flow to Firm (FCFF) Valuation Model for organizations with stable growth rates.
FCFF Valuation 2 (xls) - Free Cash Flow to Firm (FCFF) Valuation Model for organizations with two periods of growth, high growth initially and then stable growth.
Time Value (xls) - Introduction to time value concepts, such as present value, internal rate of return, etc.
Lease or Buy a Car (xls) - Basic spreadsheet for deciding to buy or lease a car.
NPV & IRR (xls) - Explains Internal Rate of Return, compares projects, etc.
Real Rates (xls) - Demonstrates inflation and real rates of return.
Template (xls) - Template spreadsheet for project evaluation & capital budgeting.
Free Cash Flow (xls) - Cash flow worksheets - subsidized and unsubsidized.
Capital Structure (xls) - Spreadsheet for calculating optimal capital structures using different percents of debt.
WACC (xls) - Calculation of Weighted Average Cost of Capital using beta's for equity.
Statements (xls) - Generate a set of financial statements using two input sheets - operational data and financial data.
Bond Valuation (zip) - Calculates the value or price of a 25 year bond with semi-annual interest payments.
Buyout (zip) - Analyzes the effects of combining two companies.
Cash Flow Valuation (zip) - Walks through a valuation of cash flows under three models- capital cash flows, equity cash flows, and free cash flows.
Financial Projections (zip) - Spreadsheet model for generating projected financials along with valuation based on WACC.
Leverage (zip) - Shows the effects on Net Income from using debt (leverage).
Ratio Calculator (zip) - Calculates a standard set of ratios based on input of financial data.
Stock Value (zip) - Calculates expected return on stock and value based on no growth, growth, and variable growth.
CFROI (xls) - Simplified Cash Flow Return on Investment Model.
Financial Charting (zip) - Add on tool for Excel 97, consists of 6 files.
Risk Analysis (exe) - Analysis and simulation add on for excel, self extracting exe file.
Black Scholes Option Pricing (zip) - Excel add on for the pricing of options.
Cash Flow Matrix - Basic cash flow model.
Business Financial Analysis Template for start-up businesses from Small Business Technology Center
Forex (zip) - Foreign market exchange simulation for Excel
Hamlin (zip) - Financial function add-on's for Excel
Tanly (zip) - Suite of technical analysis models for Excel
Financial History Pivot Table - Microsoft Financials
Income Statement What If Analysis
Breakeven Analysis (zip) - Pricing and breakeven analysis for optimal pricing - Biz Pep.
SLG Ratio Master (exe) - Excel workbook for creating 25 key performance ratios.
DCF - Menu driven Excel program (must enable macros) for Discounted Cash Flow Analysis from the book Analysis for Financial Management by Robert C. Higgins
History - Menu driven Excel program (must enable macros) for Historical Financial Statements from the book Analysis for Financial Management by Robert C. Higgins
Proforma - Menu driven Excel program (must enable macros) for Pro-forma Financial Statements from the book Analysis for Financial Management by Robert C. Higgins
Business Valuation Model (zip) - Set of tabbed worksheets for generating forecast / valuation outputs. Includes instruction sheet. Bizpep
LBO Model - Excel model for leveraged buy-outs
Comparable Companies - Excel valuation model comparing companies
Combination Model - Excel valuation model for combining companies
Balanced Scorecard - Set of templates for building a balanced scorecard.
Cash Model - Template for calculating projected financials from CFO Connection
Techniques of Financial Analysis - Workbook of 11 templates (breakeven, valuation, forecasting, etc.) from ModernSoft
Ratio Reminder (zip) - Simple worksheet of comparative financials and corresponding ratios from Agilicor
Risk Analysis IT - Template for assessing risk of Information Technology - Audit Net
Risk Analysis DW - Template for assessing risk of Data Warehousing - Audit Net
Excel Workbook 1-2 - Set of worksheets for evaluating financial performance and forecasting - Supplemental Material for Short Course 1 and 2 on this website.
Rule Maker Essentials - Excel Template for scoring a company by entering financial data - The Motley Fool
Rule Maker Ranker - Excel Template for scoring a company by entering comparable data - The Motley Fool
IPO Timeline - Excel program for Initial Public Offerings (must enable macros)
Assessment Templates - Set of templates for assessing an organization based on the Malcolm Baldrige Quality Model.
Cash Gap in Days - Spreadsheet for calculating number of days required for short-term financing.
Cash Flow Template - Simple spreadsheet for calculating Free Cash Flow.
Six Solver Workbook (zip) - Set of various spreadsheets for solving different business problems (inventory ordering, labor scheduling, working capital, etc.).
Free Cash Flow Valuation - Basic Spreadsheet Valuation Model
Finance Examples - Seven examples in Business Finance - Solver
Capital Budgeting Workbook - Several examples of capital budgeting analysis, including the use of Solver to select optimal projects.
Present Value Tables (rtf) - Set of present value tables written in rich text format, compatible with most word processors. Includes examples of how to use present value tables.
Investment Valuation Model (zip) - Valuation model of companies (must enable macros) - Excel Business Tools
Cash Flow Sensitivity (xlt) - Sensitivity analysis spreadsheet - Small Business Store
What If Analysis - Set of templates for sensitivity analysis using financial inputs.
Risk Return Optimization - Optimal project selection - Metin Kilic (must enable macro's)
Wednesday, May 18, 2005
Geronimo! Part 1: The J2EE 1.4 engine that could
As a J2EE server, Geronimo can deploy and run your Web and enterprise applications. You can use Java ServerPages (JSPs), servlets, filters, and Enterprise JavaBeans (EJBs) to compose your application. The application has access to external RDBMS through Java Data Access API (JDBC) connector, to directory services through the Java Naming and Directory Interface (JNDI), to transactional message queues through the Java Message Service (JMS), to e-mail through JavaMail, and so on.
Telecom Recipes - Minimizing Your Telephone Bills
Chances are you can shave at least $20 to $30 off your monthly bill if you're using a combination of fixed-line, cellular and broadband service. That might not sound like much but thats several hundred dollars per year, money that can be spent on you, instead of the phone company
Implementing an Enterprise Service Bus in Java
Using the open source Mule project, you can build a highly customized Enterprise Service Bus (ESB) that meets your specific needs. This article discusses the mechanisms used by an ESB to facilitate cross-protocol messaging, message transformation, message security, service invocation, and other necessary requirements of a service-oriented messaging infrastructure
Use Yahoo! Messenger to call and talk over the Internet just like you're on the phone
Use Yahoo! Messenger to call and talk over the Internet just like you're on the phone. All you need is a headset, or a microphone and speakers. It's that easy - just click the Call button. If no one's there, leave a voicemail!
Tuesday, May 17, 2005
Free Excel Downloads showing Functions and VBA (Visual Basic for Applications).
These examples show Excels features
such as VBA, Worksheet_Change Event, Advanced Filter, Dfunctions, Choose, Vlookup, Validation, Index, Match and more! you will need WinZip to open the Workbooks on this page. If you do not have WinZip download it here
AdvancedFilter.zip
This is a zipped Excel Workbook that has six working examples using Excels Advanced Filter. It has three that use no formulas and three that do use formulas.
--------------------------------------------------------------------------------
DFunctionsWithValidation.zip
This is a zipped Excel Workbook that shows how you can use Data Validation and the Dfunctions to extract data from a Table.
--------------------------------------------------------------------------------
FormulaExamples.zip
This is a zipped Excel Workbook that shows how you can use various formulas to extract information from a Table using LookUp formulas.
--------------------------------------------------------------------------------
FormsControls.zip
Think you need to know VBA to make things happen automatically, think again. Here are some clever uses of Option Buttons and Conditional Formatting.
--------------------------------------------------------------------------------
DynamicSelections.zip
Way to spice up your spreadsheet using a 3D effect on selected cell and the Office Assistant to guide you.
--------------------------------------------------------------------------------
SheetsToPrint.zip
Use of a UserForm and ListBox to display a list of non empty sheets for printing.
--------------------------------------------------------------------------------
AutoUpdateValidationList.zip
This is a zipped Excel Workbook that shows how you can use VBA housed in the Worksheet_Change Event to automatically add data to a cells Data Validation list.
--------------------------------------------------------------------------------
SumEveryNth.zip
This is a zipped Excel Workbook that shows how you can Sum every second, third fourth or Nth cell, the right way
--------------------------------------------------------------------------------
ChangingExternal.zip
This Workbook shows how you can use the Worksheet_Calculate Event and a Validation list to have formulas automatically reference different Workbooks. The code has been set so it works in both Excel 97 and 2000. The reason it uses the Worksheet_Calculate Event and not the Worksheet_Change is because a Validation list will not fire the Worksheet_Change Event in Excel 97.
This download contains four Workbooks. They should be all saved to the same folder on your hard drive. Then open "ChangingExternalFormulas".
--------------------------------------------------------------------------------
PrintCol.zip
This workbook example shows how you can move a long column of data (10,000 rows in the example) at each page break and place them across columns ready for printing. The code is also here.
--------------------------------------------------------------------------------
DynaRange.zip
This workbook demonstrates the use of dynamic ranges taken to a new level. It will create a dynamic range within another dynamic range, range or named range. For example you can actually have a dynamic range of all people whos name starts with the letter "H" within a list of names. If you are not familiar with dynamic ranges, click here
--------------------------------------------------------------------------------
MatchingLists.zip
Here is how you can use Data Validation in 2 cells and have the List of one depend on the item chosen from the other, no code required! There is also a more advanced versions which makes use of VBA code.
--------------------------------------------------------------------------------
Lookup.zip
This workbook shows how you can combine VLOOKUP, COUNTIF, Data Validation and Dynamic named ranges to create a very user friendly lookup table.
--------------------------------------------------------------------------------
ListMatch.zip
Uses two 'Type 2' InputBoxes that allow you to select two seperate ranges. The Values from the first range are then match and transfered to the second range.
--------------------------------------------------------------------------------
ListBoxTransfer.zip
Demonstrates how you can use a multi columned ListBox and transfer the user selection(s) to another table.
--------------------------------------------------------------------------------
EnableMacros.zip
A user friendly way to ensure macros are enabled within your VBA Workbook. This method uses some simple VBA to hide all sheets if macros are disabled.
--------------------------------------------------------------------------------
PasswordBook.zip
How to add a UserForm that prompts for a user name and password when the workbook opens.
--------------------------------------------------------------------------------
LisboxSort.zip
A very quick and easy way to add a list to a UserForm ListBox that has all duplicates removed and is then sorted.
--------------------------------------------------------------------------------
AddingCustomMenus.zip
This workbook demonstrates how to create a Custom menu (with sub-menus) on Excel's Worksheet Menu Bar. The custom menu is deleted when the Workbook is Deactivated and re-created when it's Activated.
--------------------------------------------------------------------------------
AutoSelectList.zip
The "Pick from list" option you get when you right click in a cell or use Alt+Down arrow is a very handy way to add to a list. Unfortunately it will only include text, this Workbook contains a possible work-around using Validation.
--------------------------------------------------------------------------------
ChartByMonth.zip
Very simple method to have a chart range expand and contract and have it instantly reflected in the chart. No VBA needed!
--------------------------------------------------------------------------------
OverDueDates.zip
A simple but very handy use of Conditional Formatting to show all over due dates.
--------------------------------------------------------------------------------
ChangingCombo.zip
A very simple method to have a ComboBox (from Forms toolbar) change it's Input Range according to a users choice from some OptionButtons. No VBA needed!
--------------------------------------------------------------------------------
ChangingCombo2.zip
Another very simple method to have a ComboBox (from Forms toolbar) change it's Input Range according to a users choice from another ComboBox. Again no VBA needed!
--------------------------------------------------------------------------------
SwapSelection.zip
A very simple macro that swaps the content of two cells with each other. Cells can be contiguous or non-contiguous!
--------------------------------------------------------------------------------
Pivot.zip
Simple use of a Pivot Table and a Dynamic named range to show the Top x occuring numbers in a list.
--------------------------------------------------------------------------------
WhichControl.zip
Example of how to use the one Procedure to determine which Control button was clicked and run it's own procedure.
--------------------------------------------------------------------------------
LookUpTaxRate.zip
Very simple method of looking up the appropriate tax rate using VLOOKUP.
--------------------------------------------------------------------------------
DisplayWaitMessage.zip
Here is a simple method anyone can use to let the user know that a Procedure is running. Often a progress bar is used, but this slows things down even more.
--------------------------------------------------------------------------------
FormsControls.zip
Think you need to use VBA for user interaction? If so this will prove you wrong, it's a very simple use of the CheckBox control from the Forms Toolbar combined with Conditional Formatting.
--------------------------------------------------------------------------------
Solvsamp.zip
Here is the Microsoft Workbook example of Excels Solver feature.
--------------------------------------------------------------------------------
Xl8galry.zip
Excels Chart Workbook.
--------------------------------------------------------------------------------
Samples.zip
This Workbook is priceless in more ways than one. It shows Functions, special features, ActiveX controls, VBA code for Databases and API code and more!
--------------------------------------------------------------------------------
FaceID.zip
If you create Custom Command Bars, you will find this download very handy.
such as VBA, Worksheet_Change Event, Advanced Filter, Dfunctions, Choose, Vlookup, Validation, Index, Match and more! you will need WinZip to open the Workbooks on this page. If you do not have WinZip download it here
AdvancedFilter.zip
This is a zipped Excel Workbook that has six working examples using Excels Advanced Filter. It has three that use no formulas and three that do use formulas.
--------------------------------------------------------------------------------
DFunctionsWithValidation.zip
This is a zipped Excel Workbook that shows how you can use Data Validation and the Dfunctions to extract data from a Table.
--------------------------------------------------------------------------------
FormulaExamples.zip
This is a zipped Excel Workbook that shows how you can use various formulas to extract information from a Table using LookUp formulas.
--------------------------------------------------------------------------------
FormsControls.zip
Think you need to know VBA to make things happen automatically, think again. Here are some clever uses of Option Buttons and Conditional Formatting.
--------------------------------------------------------------------------------
DynamicSelections.zip
Way to spice up your spreadsheet using a 3D effect on selected cell and the Office Assistant to guide you.
--------------------------------------------------------------------------------
SheetsToPrint.zip
Use of a UserForm and ListBox to display a list of non empty sheets for printing.
--------------------------------------------------------------------------------
AutoUpdateValidationList.zip
This is a zipped Excel Workbook that shows how you can use VBA housed in the Worksheet_Change Event to automatically add data to a cells Data Validation list.
--------------------------------------------------------------------------------
SumEveryNth.zip
This is a zipped Excel Workbook that shows how you can Sum every second, third fourth or Nth cell, the right way
--------------------------------------------------------------------------------
ChangingExternal.zip
This Workbook shows how you can use the Worksheet_Calculate Event and a Validation list to have formulas automatically reference different Workbooks. The code has been set so it works in both Excel 97 and 2000. The reason it uses the Worksheet_Calculate Event and not the Worksheet_Change is because a Validation list will not fire the Worksheet_Change Event in Excel 97.
This download contains four Workbooks. They should be all saved to the same folder on your hard drive. Then open "ChangingExternalFormulas".
--------------------------------------------------------------------------------
PrintCol.zip
This workbook example shows how you can move a long column of data (10,000 rows in the example) at each page break and place them across columns ready for printing. The code is also here.
--------------------------------------------------------------------------------
DynaRange.zip
This workbook demonstrates the use of dynamic ranges taken to a new level. It will create a dynamic range within another dynamic range, range or named range. For example you can actually have a dynamic range of all people whos name starts with the letter "H" within a list of names. If you are not familiar with dynamic ranges, click here
--------------------------------------------------------------------------------
MatchingLists.zip
Here is how you can use Data Validation in 2 cells and have the List of one depend on the item chosen from the other, no code required! There is also a more advanced versions which makes use of VBA code.
--------------------------------------------------------------------------------
Lookup.zip
This workbook shows how you can combine VLOOKUP, COUNTIF, Data Validation and Dynamic named ranges to create a very user friendly lookup table.
--------------------------------------------------------------------------------
ListMatch.zip
Uses two 'Type 2' InputBoxes that allow you to select two seperate ranges. The Values from the first range are then match and transfered to the second range.
--------------------------------------------------------------------------------
ListBoxTransfer.zip
Demonstrates how you can use a multi columned ListBox and transfer the user selection(s) to another table.
--------------------------------------------------------------------------------
EnableMacros.zip
A user friendly way to ensure macros are enabled within your VBA Workbook. This method uses some simple VBA to hide all sheets if macros are disabled.
--------------------------------------------------------------------------------
PasswordBook.zip
How to add a UserForm that prompts for a user name and password when the workbook opens.
--------------------------------------------------------------------------------
LisboxSort.zip
A very quick and easy way to add a list to a UserForm ListBox that has all duplicates removed and is then sorted.
--------------------------------------------------------------------------------
AddingCustomMenus.zip
This workbook demonstrates how to create a Custom menu (with sub-menus) on Excel's Worksheet Menu Bar. The custom menu is deleted when the Workbook is Deactivated and re-created when it's Activated.
--------------------------------------------------------------------------------
AutoSelectList.zip
The "Pick from list" option you get when you right click in a cell or use Alt+Down arrow is a very handy way to add to a list. Unfortunately it will only include text, this Workbook contains a possible work-around using Validation.
--------------------------------------------------------------------------------
ChartByMonth.zip
Very simple method to have a chart range expand and contract and have it instantly reflected in the chart. No VBA needed!
--------------------------------------------------------------------------------
OverDueDates.zip
A simple but very handy use of Conditional Formatting to show all over due dates.
--------------------------------------------------------------------------------
ChangingCombo.zip
A very simple method to have a ComboBox (from Forms toolbar) change it's Input Range according to a users choice from some OptionButtons. No VBA needed!
--------------------------------------------------------------------------------
ChangingCombo2.zip
Another very simple method to have a ComboBox (from Forms toolbar) change it's Input Range according to a users choice from another ComboBox. Again no VBA needed!
--------------------------------------------------------------------------------
SwapSelection.zip
A very simple macro that swaps the content of two cells with each other. Cells can be contiguous or non-contiguous!
--------------------------------------------------------------------------------
Pivot.zip
Simple use of a Pivot Table and a Dynamic named range to show the Top x occuring numbers in a list.
--------------------------------------------------------------------------------
WhichControl.zip
Example of how to use the one Procedure to determine which Control button was clicked and run it's own procedure.
--------------------------------------------------------------------------------
LookUpTaxRate.zip
Very simple method of looking up the appropriate tax rate using VLOOKUP.
--------------------------------------------------------------------------------
DisplayWaitMessage.zip
Here is a simple method anyone can use to let the user know that a Procedure is running. Often a progress bar is used, but this slows things down even more.
--------------------------------------------------------------------------------
FormsControls.zip
Think you need to use VBA for user interaction? If so this will prove you wrong, it's a very simple use of the CheckBox control from the Forms Toolbar combined with Conditional Formatting.
--------------------------------------------------------------------------------
Solvsamp.zip
Here is the Microsoft Workbook example of Excels Solver feature.
--------------------------------------------------------------------------------
Xl8galry.zip
Excels Chart Workbook.
--------------------------------------------------------------------------------
Samples.zip
This Workbook is priceless in more ways than one. It shows Functions, special features, ActiveX controls, VBA code for Databases and API code and more!
--------------------------------------------------------------------------------
FaceID.zip
If you create Custom Command Bars, you will find this download very handy.
Free, Handy, and Educational Excel Templates
These are postings of working Excel templates that solve business problems or demonstrate business principles.
Depending on your browser, these templates may open 'live' and functional in your browser window.
You can also copy these templates onto your own computer. In Internet Explorer, right-click your mouse button over the link name, choose 'save target as,' and follow the prompts.
Please write us if you have a request for a template on a different subject!
Forecasting Template -- Takes monthly historic data, to calculate a new-year monthly forecast with consideration for seasonality, secular trending, and the current business cycle
Price Analysis Template -- Uses test prices and corresponding test quantities sold, to estimate the highest-volume price, the highest gross-revenue price, and the highest contribution-margin price
Universal Trend Charter Template -- Takes any time-sequenced stream of readings or measurements to create a real-time chart showing data points, average line, and statistical boundaries, thus distinguishing real trends from mere noise
NPV Solution Template -- Accepts any set of investment costs, expected returns, and discount rate percentages to calculate the Net Present Value of doing any given project
Break-Even Visualizer Template -- Uses prices, costs, discount percentages, and crash-cost estimates to create a bent-line break-even chart illustrating what happens to profit when discounts and expediting occur at over-capacity volumes
Depending on your browser, these templates may open 'live' and functional in your browser window.
You can also copy these templates onto your own computer. In Internet Explorer, right-click your mouse button over the link name, choose 'save target as,' and follow the prompts.
Please write us if you have a request for a template on a different subject!
Forecasting Template -- Takes monthly historic data, to calculate a new-year monthly forecast with consideration for seasonality, secular trending, and the current business cycle
Price Analysis Template -- Uses test prices and corresponding test quantities sold, to estimate the highest-volume price, the highest gross-revenue price, and the highest contribution-margin price
Universal Trend Charter Template -- Takes any time-sequenced stream of readings or measurements to create a real-time chart showing data points, average line, and statistical boundaries, thus distinguishing real trends from mere noise
NPV Solution Template -- Accepts any set of investment costs, expected returns, and discount rate percentages to calculate the Net Present Value of doing any given project
Break-Even Visualizer Template -- Uses prices, costs, discount percentages, and crash-cost estimates to create a bent-line break-even chart illustrating what happens to profit when discounts and expediting occur at over-capacity volumes
Excel Viewer 2003 - Open, view, and print Excel workbooks, even if you don't have Excel installed
Open, view, and print Excel workbooks, even if you don't have Excel installed. This download is a replacement for Excel Viewer 97 and all previous Excel Viewer versions
Sun's Gosling: Already Plenty of Java 'Harmony' Under the Sun
The open source community may be looking for 'Harmony' but 'Father of Java' James Gosling says enterprise Java customers would sooner go 'screaming into the hills.' Gosling talks to DevX about why Sun is ambivalent about Apache's Harmony, the future of the tools market, and the expectation for a language that will one day eclipse Java
Monday, May 16, 2005
Fast guide to Web-enabling tools
Fast guide to Web-enabling tools: "What do you do when you want to get your applications on the Web but you're short of Web development skills? A Web-enabling tool just might be the answer. Here's a look at some of the products out there
Tips for i5 eServer Hardware Management Console
The HMC was introduced for Logical Partition support on the pSeries with the introduction of Power 4 Technology. IBM has continued the process of consolidating server hardware and the Power 5 Technology. The eServer i5 can now run i5/OS and AIX natively on the Power 5 server, as well as Linux. The HMC provides a single-control point for managing hardware and Capacity Upgrade on Demand across multiple operating systems, and eliminates the need for a 'Primary Partition' on the iSeries. What will this mean from an implementation and systems Management perspective? Recently Allyn Walsh, IBM Partner World for Developers (PWD) Technical Support, joined Search400.com for a webcast on Introduction to i5 eServer Hardware Management Console (HMC)
iSeries Gets New Features for LPAR, I/O, SQL
IBM announced a number of incremental enhancements for the iSeries, topped by a simplified Logical Partitioning (LPAR) solution for smaller i5 shops that want to avoid the hassle of having to use the Hardware Management Console (HMC). Other enhancements tackle SQL, security, and I/O improvements, including RAID-5 Write Protection and new mirroring packages
Extend the life of your JUnit tests by enabling them to be executed inside a real deployed J2EE app, not just on developer PCs
Learn how a simple EJB JUnit test service can facilitate test execution in real deployment environments, not just on developer PCs
Friday, May 13, 2005
The worst kept secret in the world just got revealed in the U.S. on MTV
I’ve seen some comments on the size of the system. Mostly negative of course. I’ve got to repeat what I’ve said on a couple of shows. This is a very impressive bit of machinery. Microsoft haven’t hyped it nearly enough, mostly because the PS3 is more impressive. However, we’re talking about a system that would normally set you back several thousand dollars. Some high quality workgroup servers don’t even match the compute power in this, and they cost much more than the $300 to $400 it’s expected to retail for.
Thursday, May 12, 2005
UNIX Shell Programming
Ken Steube
San Diego Supercomputer Center
These are the workshop notes I used to use for teaching a course on Bourne shell (sh) scripting. I haven't taught the class for some time now, but the material is all still current since the Bourne shell hasn't changed. Often you'll find that these notes are a bit short of description. This is because they were intended by be a lecture aid.
What do you need to know to follow this course? These notes were originally written as a second class in UNIX. The first class taught how to use the basic UNIX commands (like sed, grep and find) and this class teaches how to combine these tools to accomplish bigger tasks.
In addition to the material in this course you might be interested in the Korn shell (ksh) and the Bourne again shell (bash), both of which are excellent shells that enchance the original Bourne shell. These alternate shells are upwardly-compatible with the original Bourne shell, meaning that a script written for sh can run in ksh or bash. However, there are additional features in bash and ksh that are not available in the Bourne shell.
The focus of this guide is to get you to understand and run some Bourne shell scripts. On several pages there are example scripts for you to run. On most of these pages there is a link you can click on (with the right mouse button) and download the script to your computer and run it
San Diego Supercomputer Center
These are the workshop notes I used to use for teaching a course on Bourne shell (sh) scripting. I haven't taught the class for some time now, but the material is all still current since the Bourne shell hasn't changed. Often you'll find that these notes are a bit short of description. This is because they were intended by be a lecture aid.
What do you need to know to follow this course? These notes were originally written as a second class in UNIX. The first class taught how to use the basic UNIX commands (like sed, grep and find) and this class teaches how to combine these tools to accomplish bigger tasks.
In addition to the material in this course you might be interested in the Korn shell (ksh) and the Bourne again shell (bash), both of which are excellent shells that enchance the original Bourne shell. These alternate shells are upwardly-compatible with the original Bourne shell, meaning that a script written for sh can run in ksh or bash. However, there are additional features in bash and ksh that are not available in the Bourne shell.
The focus of this guide is to get you to understand and run some Bourne shell scripts. On several pages there are example scripts for you to run. On most of these pages there is a link you can click on (with the right mouse button) and download the script to your computer and run it
ONJava.com: Five Things I Love About Spring
by Bruce A. Tate, coauthor of Spring: A Developer's Notebook
About two years ago, I tried out that Spring project that was prominently mentioned on the Hibernate site. It felt just like that old kayak: it fit me perfectly. For hardcore enterprise development, Spring became so deeply woven into my programming that I made it the topic of my fourth Java book, Spring: A Developer's Notebook. In this article, I'll tell you why
About two years ago, I tried out that Spring project that was prominently mentioned on the Hibernate site. It felt just like that old kayak: it fit me perfectly. For hardcore enterprise development, Spring became so deeply woven into my programming that I made it the topic of my fourth Java book, Spring: A Developer's Notebook. In this article, I'll tell you why
Google Ponders Blogger Enhancements
Google is contemplating various improvements to its popular Blogger Web logging service, including native image uploading and deeper integration with the company's Gmail Web-mail service, according to a Google executive
Wednesday, May 11, 2005
How to Style a Definition List with CSS
Most tutorials on the styling of CSS lists for menus use unordered lists, which, for people starting out with CSS, can be a little difficult to grasp as the use of unordered lists requires extra styling to remove the bullets.
In this tutorial I demonstrate how to style a Definition List, which is equally suitable for menus, but is a little easier to understand
In this tutorial I demonstrate how to style a Definition List, which is equally suitable for menus, but is a little easier to understand
MyMarket - PHP based E-Commerce solution
MyMarket - PHP based E-Commerce solution: "MyMarket is a fully functional online shopping catalog system, built using PHP and MySQL. It was created by Ying Zhang for the purpose of teaching people about the basics of creating an E-Commerce site. "
Is There any AJAX based UI Component JSP Custom Taglib?
cyblogue: Is There any AJAX based UI Component JSP Custom Taglib?: "I am looking for a 'Tree UI Component' for use in my web applications. It must be:
Customizable: Should provide a means to set differnt GIFs and/or CSS styles for the nodes and leafs.
Robust: Must be able to display 1000s of nodes/leafs with ease i.e., not memory intensive and performant.
Dynamic (nice to have): Should be able to refresh the tree or parts of the tree without reloading the whole page (Think - AJAX, DHTML/Java Script).
Has anyone created AJAX basesd UI Component JSP Custom taglib yet? "
Customizable: Should provide a means to set differnt GIFs and/or CSS styles for the nodes and leafs.
Robust: Must be able to display 1000s of nodes/leafs with ease i.e., not memory intensive and performant.
Dynamic (nice to have): Should be able to refresh the tree or parts of the tree without reloading the whole page (Think - AJAX, DHTML/Java Script).
Has anyone created AJAX basesd UI Component JSP Custom taglib yet? "
Tuesday, May 10, 2005
PORTKNOCKING - A system for stealthy authentication across closed ports
Port knocking is a method of establishing a connection to a networked computer that has no open ports . Before a connection is established, ports are opened using a port knock sequence, which is a series of connection attempts to closed ports. A remote host generates and sends an authentic knock sequence in order to manipulate the server's firewall rules to open one or more specific ports. These manipulations are mediated by a port knock daemon, running on the server, which monitors the firewall log file for connection attempts which can be translated into authentic knock sequences. Once the desired ports are opened, the remote host can establish a connection and begin a session. Another knock sequence may used to trigger the closing of the port
Building a better J2EE server, the open source way
Gluecode Software is among the growing number of companies that are successfully commercializing open source software, and it has incorporated several up-and-coming open source middleware components -- including Apache Geronimo and Apache Derby, among others -- into a J2EE application server stack. After the recent announcement of IBM's acquisition of Gluecode, we sat down with one of Geronimo's main contributors and CTO of Gluecode, Jeremy Boynes, to hear his perspectives on Geronimo, Java directions, and the state of open source
How to Geotag
MAKE: Blog: "Here's a great step-by-step on using Firefox, Greasemonkey and Flickr to GeoTag your photos to use with GeoBloggers.com. Once you get the script installed, you browse to your Flickr image, add a new 'geotag' and enter in a zip code. You'll then use Google maps to locate a position and it saves the location data to the photo. Once that's complete you can submit the image to Geobloggers"
DIY Pioneer Aux Input (MP3 to Car)
Great project to add your MP3 player to your car (Cool MAKE Photo too!) 'Over the past couple of years I have upgraded my Pioneer Car CD changer to meet my needs. I went from a 6CD to a 12CD and now I have a portable MP3 player I want to connect. Pioneer offers an auxiliary adapter (CDRB-10) for ~$40 or an iPod adapter (CD-IB100) for ~$130. The auxiliary adapter appears to be a simple input-to-RCA-out, so I decided to make an aux adapter myself for ~$6. A quick tally of the cost of the parts listed is ~$12 bucks but you'll have plenty of wire for your future projects and an extra stereo jack"
Developing a Common Corporate Framework for your Java Applications
Developing a Common Corporate Framework for your Java Applications (timothyfisher.javadevelopersjournal.com): "In today's market, application development teams are often asked to complete applications in time frames shorter than ever before, with fewer resources, and at lower cost. This high pressure, fast-paced environment can open a door to poorly designed and implemented applications that are difficult to support and maintain. When a project has a tight schedule, one of the first practices to be jettisoned is the notion of code reuse. It is a common view that making code reusable, while important strategically, will slow down development on the current project. If this practice becomes standard throughout a company, what you end up with is a family of corporate applications that have no common infrastructure, no common design elements, multiple styles of coding and design, and hundreds of instances of solving the same set of problems repeatedly. "
Michael Dell Sinks $100M Into Red Hat
Billionaire Michael S. Dell, founder and chairman of Dell Inc., has placed a $99.5 million bet on Red Hat.
Dell invested his own money in the Raleigh Linux software developer, taking the largest single chunk of $600 million in debentures offered by the company in January 2004
Dell invested his own money in the Raleigh Linux software developer, taking the largest single chunk of $600 million in debentures offered by the company in January 2004
Ten Easy Ways to Screw Up Your Computer Game Company
You've been thinking about it for years. You can't help it. You know you have what it takes. And above all, you know that the jobs which are out there, inside or outside of the gaming business, are never going to provide you with the challenges and the opportunities that you crave and deserve. So you prepare for the big day, and you wait. It isn't easy, but you save a little money, gather a team whom you believe will be able to carry a schedule, and you go into business for yourselves.
Every year, hundreds (maybe thousands) of groups of people just like you make the same decision. Some of them make it big. Most fizzle within months and are never heard from again. To you, that would be a fate worse than death. So how do you avoid it?
There are no golden paths to game development stardom, but there are many, many tempting roads leading right into the abyss. Here are just a few of them. Trespass at your own peril."
Every year, hundreds (maybe thousands) of groups of people just like you make the same decision. Some of them make it big. Most fizzle within months and are never heard from again. To you, that would be a fate worse than death. So how do you avoid it?
There are no golden paths to game development stardom, but there are many, many tempting roads leading right into the abyss. Here are just a few of them. Trespass at your own peril."
hello joseph / how i implemented tags: a de-normalized approach
hello joseph / how i implemented tags: a de-normalized approach: "There's been a lot of talk recently about how to implement tags on your own web site, and I wanted to share how I did it. By no means am I an expert code writer and my way may not be the best (it's de-normalized), and I'm sure there will be people who laugh in my general direction. That's fine -- at the very least, I hope that it will give you some ideas of how to do this on your own. I've been using this system for about three months on two web sites and it's working great (here, and brotherjoe.com). It is made with PHP and MySQL, and uses REGEX for tag matching. My system does popular tags, related tags, tag addition, and the ability to seperate tags with commas so you can have multi-word tags. Let's get started..."
Kevin Kelly -- Cool Tools
Kevin Kelly -- Cool Tools: "Cool tools really work. A cool tool can be any book, gadget, software, video, map, hardware, material, or website that is tried and true. I am chiefly interested in stuff that is extraordinary, better than similar products, little-known, and reliably useful for an individual or small group. I depend on friends and readers to suggest things they actually use. There are plenty of places to read about stuff that should be cool, or that looks new and cool, and that might be useful. These recommendations here, on the other hand, are based on people who have used this item and many similar and have come to see its superiority. Items can be old items, or cheap things that you still dote on after years of use. Great new gear, if well tested by you, are also wonderful. I post things I like and I ignore the rest. Suggestions for tools much better than what is recommended here are always wanted. Tell me what you love. "
Greasemonkey will blow up business models (as well as your mind)
Greasemonkey is a Firefox extension which lets users add “user scripts” (DHTML, technically) to any web page. These scripts can change any aspect of a web page’s behaviour, interaction, or design. This little baby is going to blow up business models
Critical Thinking Mini-Lessons
A Practical Guide to Critical Thinking by Greg R. Haskins. A concise (14 page) introduction to critical thinking, intended as a handy tool to help anyone develop sound reasoning and arguments, or to evaluate the validity of any claim, based on The Skeptic's Dictionary and Becoming a Critical Thinker
Mouseover DOM Inspector v2.0
The Mouseover DOM Inspector, or MODI for short, is a favelet (also known as a bookmarklet) that allows you to view and manipulate the DOM of a web page simply by mousing around the document.
Browsers currently supported are Firefox, Mozilla, Opera 7.5+ and MSIE6+ on all of their respective Operating Systems. As of this writing, Safari does not support the sourcing of dynamically created script objects so the application does not work in that browser
Browsers currently supported are Firefox, Mozilla, Opera 7.5+ and MSIE6+ on all of their respective Operating Systems. As of this writing, Safari does not support the sourcing of dynamically created script objects so the application does not work in that browser
Monday, May 09, 2005
Hiding Email Addresses on Your Web Page - MC Press Online
Outfox those dirty little "sniffer" programs
iSeries Linux ODBC driver and PHP HowTo
This HowTo document will explain how to get an ODBC connection to your iSeries as400 via PHP/Linux. We are going to be working with the latest Apache 2, and the latest version of PHP, which is 5.0.4 at the time this document is being written
Nexus Portal
Nexus Portal is an iSeries-based portal that allows administrators to make documents, reports, iSeries applications, and external information sources such as Google and Yahoo! available to users. Multiple portals can be run on a single iSeries server and a single copy of the Nexus Portal software
Your iseries performance problems could be caused by seize/wait conflicts.
Have you ever had performance problems on your iSeries in which the CPU is barely being utilized but users are complaining that their jobs are running more slowly
than usual? You could be running into seize/wait conflicts. Seizes and locks can sometimes be a cause of significant wait times on your system. This document explains the difference between a seize and a lock and identifies how to determine whether seize/wait conflicts are occurring on your system
than usual? You could be running into seize/wait conflicts. Seizes and locks can sometimes be a cause of significant wait times on your system. This document explains the difference between a seize and a lock and identifies how to determine whether seize/wait conflicts are occurring on your system
Blogger Help : How do I post via email?
Blogger Help : How do I post via email?: "How do I post via email?"
TiddlyWiki - a reusable non-linear personal web notebook
Welcome to the ThirdVersion of TiddlyWiki, an experimental MicroContent WikiWikiWeb built by JeremyRuston. It's written in HTML, CSS and JavaScript to run on any modern browser without needing any ServerSide logic. It allows anyone to create personal SelfContained hypertext documents that can be posted to any web server, sent by email or kept on a USB thumb drive to make a WikiOnAStick
Testing/debugging code on the fly in eclipse
Sometimes its useful to be able to run a piece of code to see if it does what you want without having a test case for it.
Eclipse makes this easy to do with its Scrapbook Page feature. To create a Scrapbook Page, New (Ctrl-N) -> Java -> Java Run/Debug -> Scrapbook page. This brings up an editor into which you can add snippets of java code which you can then execute by selecting them, RC->Inspect/Display/Execute
But did you know you could also debug the code you are executing from a scrapbook? Since the scrapbook actually runs the code in a jvm running in a debugger, all you have to do is set breakpoints at the locations you care about. This makes it extremely easy for one to figure out if a utility method is doing what it should (but you should really write a test case ;), or inspect the execution of some javadoc deficient thirdparty code to figure out what it actually does before you make your code depend on it
Eclipse makes this easy to do with its Scrapbook Page feature. To create a Scrapbook Page, New (Ctrl-N) -> Java -> Java Run/Debug -> Scrapbook page. This brings up an editor into which you can add snippets of java code which you can then execute by selecting them, RC->Inspect/Display/Execute
But did you know you could also debug the code you are executing from a scrapbook? Since the scrapbook actually runs the code in a jvm running in a debugger, all you have to do is set breakpoints at the locations you care about. This makes it extremely easy for one to figure out if a utility method is doing what it should (but you should really write a test case ;), or inspect the execution of some javadoc deficient thirdparty code to figure out what it actually does before you make your code depend on it
Quick and Easy Custom Templates with XDoclet
I stumbled upon templates. Templates are a way to extend the functionality of XDoclet to better match your code-generation needs. For instance, if you have a particular type of class that doesn't quite fit in with anything the XDoclet offers out of the box (in my case, these were custom controller classes), then it's fairly easy to add your own template files using XML markup only! Ideally, I just wanted to define a class with a minimal set of properties and generate not only my controller code, but additional XML that would be required by Spring. After some tweaking, I was pleased with the results
Yahoo! Video Search Goes Primetime
Great video search isn't just about content from large publishers, it's also about the long tail content from smaller publishers and individuals as well. To that end, we're indexing the Internet Archive's Moving Image Archive. One of the great things about the Moving Image Archive is that it encompasses a wide range of content -- everything from the Prelinger Archives (a collection of over 48,000 'ephemeral films' from 1927 through 1987), to user-created Open Source Movies hosted by the Internet Archive, and other collections of video. (One of my favorites is the animated legos from Brick Films. Don't miss seeing their version of Grand Theft Auto done entirely in Lego).
Those of you who are budding independent filmmakers, or think you've created the next Numa Numa Dance, we're keeping you in the fold too. Besides making enhancements to our web crawl which indexes video files published online, you can also submit a Media RSS feed directly to us of the video on your website.
If you want someone to host your video content for you as well, you can have your video hosted by sites such as OurMedia, the Internet Archive's Open Source Movies, or any other hosting service that publishes video files directly to the web or with Media RSS. We applaud these hosting efforts -- it's our goal that once you publish your video content on any hosting service, we'll index the content in Video Search and help our audience find your content. Supporting an open model for video hosting gives you the most choices, so you can find the publishing solution that works best for you
Those of you who are budding independent filmmakers, or think you've created the next Numa Numa Dance, we're keeping you in the fold too. Besides making enhancements to our web crawl which indexes video files published online, you can also submit a Media RSS feed directly to us of the video on your website.
If you want someone to host your video content for you as well, you can have your video hosted by sites such as OurMedia, the Internet Archive's Open Source Movies, or any other hosting service that publishes video files directly to the web or with Media RSS. We applaud these hosting efforts -- it's our goal that once you publish your video content on any hosting service, we'll index the content in Video Search and help our audience find your content. Supporting an open model for video hosting gives you the most choices, so you can find the publishing solution that works best for you
Why I do not like Apple, 2nd Edition
Mad Andys Bad Thoughts:
The publisher Wiley is going to publish a biography about Steve Jobs and it seems Apple aka Steve Jobs does not like it and pulled all the Wiley books from the Apple stores. Steve Jobs proofs, once again, that were there is a lot of light there are also many shadows. Having a 3 year old boy that looks more like child's play to me rather than grown up behavior. Most of the visionaries I know do have bad bedside manners and so Steve Jobs just fits the rule but I still do not like it and therefore I will not spend any further money on Apple products in the near future. Finally Steve helped to resolve my own battle between my dislike of Apple and the coolness factor of their products
The publisher Wiley is going to publish a biography about Steve Jobs and it seems Apple aka Steve Jobs does not like it and pulled all the Wiley books from the Apple stores. Steve Jobs proofs, once again, that were there is a lot of light there are also many shadows. Having a 3 year old boy that looks more like child's play to me rather than grown up behavior. Most of the visionaries I know do have bad bedside manners and so Steve Jobs just fits the rule but I still do not like it and therefore I will not spend any further money on Apple products in the near future. Finally Steve helped to resolve my own battle between my dislike of Apple and the coolness factor of their products
Google Web Accelerator
Google Web Accelerator is...
Designed for Broadband - Web pages load even more quickly on DSL and cable connections
Easy to use - Simply install and enjoy faster web browsing in seconds"
Designed for Broadband - Web pages load even more quickly on DSL and cable connections
Easy to use - Simply install and enjoy faster web browsing in seconds"
$925M Gain On Sale Of Google Shares
WASHINGTON (Dow Jones)--Time Warner Inc. (TWX) disclosed Wednesday that it expects to record a gain of about $925 million in the second quarter as a result of its sale of Google Inc.'s (GOOG) common stock.
The New York media conglomerate said in its quarterly report filed with the Securities and Exchange Commission that it sold its 5.1 million Google shares on Tuesday at an average of $185 a share, receiving total cash of roughly $940 million
The New York media conglomerate said in its quarterly report filed with the Securities and Exchange Commission that it sold its 5.1 million Google shares on Tuesday at an average of $185 a share, receiving total cash of roughly $940 million
Your Phone Is Calling Your Car
HOP in your car, turn the key and your phone book stares up at you from the liquid crystal display screen in your dashboard. Scroll through a list of missed calls or recently dialed numbers. Find the name you're looking for, press a button and the call rings through the car's sound system, all while your phone remains untouched in your jacket pocket
Innovation Happens Elsewhere
The title alludes to a famous comment made by Bill Joy, to the effect that no-one can hire all the smart people so some of the innovation inevitably happens elsewhere. In the massively connected age in which we find ourselves, the only smart way to develop software is to collaborate with those people - relying only on the ones you can hire is the wrong move. To me, open source software development is the obvious approach in the massively connected age.
Software Terrorist - The Terror of Code in the Wrong Hands
The 20-to-1 productivity rule says that 5 percent of programmers are 20 times more productive than the remaining 95 percent, but what about the 5 percent at the other end of the bell curve? Consider the software terrorist: the guy who stays up all night, unwittingly but systematically destroying the entire teams last months work while improving the code. He doesnt tell anybody what hes done, and he never tests. Hes created a ticking time bomb that wont be discovered for six months"
CSS Design Showcase
Cssbeauty.com is a project focused on providing its audience with a database of well designed css based websites from around the world.
It's purpose is to showcase designers' work and to act as a small portal to the css design community.
If you are 'in need of inspiration', you have come to the right place
It's purpose is to showcase designers' work and to act as a small portal to the css design community.
If you are 'in need of inspiration', you have come to the right place
Eclipse WTP 1.0 M4 - New and Noteworthy
This milestone release of WTP is a major milsetone in respects to new function provided and final API definition for the Web Tools Platform's 1.0 release
How to pick a password
InfoWorlds Jon Udell publishes a tutorial movie on how to choose different, secure passwords for each web site you sign into based on a single master password"
Wow! Bill Gates Doesn't Get It! Again! (And that's a good thing!)
He kept trying to get Bill to explain his vision and clarify Microsoft Mobile strategy in a competitive market and to me, it just came across as Bill just not getting it. At all. I mean, hey, Bill's the richest guy on the planet, not me... so you can be the judge who really gets it. But in this case, I think he's being as short sighted as the original version of The Road Ahead which if you remember, forgot to mention the Internet... in 1995.
What was Duck Typing again?
Duck Typing is a powerful feature included primarily in newer languages. It provides the following capability: An object having all the methods described in an interface can be made to implement that interface dynamically at runtime, even if the objects class does not include the interface in its implements clause.
This is actually a somewhat restricted definition of Duck Typing compared to other languages. But it is the one I have chosen because it is the one I believe fits best with Javas design philosophy of having API contracts explicitly specified in interfaces up-front.
The good news is that although this feature is not built into the Java language, it turns out to be quite easy to implement.
This is actually a somewhat restricted definition of Duck Typing compared to other languages. But it is the one I have chosen because it is the one I believe fits best with Javas design philosophy of having API contracts explicitly specified in interfaces up-front.
The good news is that although this feature is not built into the Java language, it turns out to be quite easy to implement.
Tim's Webmail is a Web-based POP3 email viewer powered by Java Servlets and JSP
It uses SMTP to send email via the JavaMail API. It's fully compatible with sendmail and QMail. It has a simple user interface, and all basic email functions are available, including attachments. Support for multi-part messages and mailbox filtering is also implemented. The user interface is customizable using the presentation layer JSP pages and the CSS file provided
DWR explained in one GIF
I thought it ought to be possible to explain DWR in a single graphic, so I had a go. I think the result gives a simple overview of what is going on, without getting bogged down in how marshalling is done. What do you think?
Bill Gates talks about the next Xbox
The Engadget Interview: Bill Gates, Part 1: Bill Gates talks about the launch of the next Xbox console, whether or not Microsoft is going to come out with a competitor for the PlayStation Portable, and the future of Windows Mobile
What is WebSphere?
What is WebSphere?: 'What is WebSphere?' tackles all of those tough, technical, WebSphere related questions in a funny, informative and easy to understand manner
Sunday, May 01, 2005
The boss button is back
Here's a great application that fits in perfectly with the theme of this page. It's called Ghostzilla; http://www.ghostzilla.com/ . The idea is that you want to surf the web, but have it look like you are doing normal work to people walking by your computer. Ghostzilla is a browser that hides itself in your normal work applications, like Excel, or Word, or Visual Studio... anything. With a swish of the mouse, Ghostzilla pops up and you can surf the web. If you see someone coming, simply move the mouse away, and it disappears, leaving no trace. Plus, you can easily configure it to use the shunnel as described here, for total privacy! "
Subscribe to:
Posts (Atom)
Subscribe To as400 blog
Posts
All Comments