Here you should find links to spreadsheet examples (only my own).
I am not sure if I will link directly to other peoples work (there are a lot of very useful sites that show very good information and spreadsheet examples).
Wherever I was able to link some special solution to another site where I found myself such solution, I did it into the workbook itself.
Again, I need to underline that even if one example is ‘attached’ to a particular level of knowledge, this is not an absolute scale !
I would recommend to check all solutions. Sometimes-, beginners need to know what they should achieve as ‘experts’ and also experts might take sometimes advantage in simple solutions.
Please note that ALL examples are still a work in progress and I will try to put in them (that takes time…)- especially for the beginner/intermediate levels some ‘easter eggs’ showing different level of experience.
NO example will carry code (macros and/or VBA) , unless explicitly declared !
Beginners zone:
1) First example is developed in a series of 3 workbooks on the same theme :
Calculating penalties for late payments. This is meant to be a teaser on Spreadsheet capabilities or you can even consider it a small tutorial (not exhaustive !) showing how to think a solution from simple to complex.
You can download from:
|
English |
French |
Romanian |
Example 1 |
[download id=”7″ format=”fara hit”] |
|
|
Example 2 |
[download id=”8″ format=”fara hit”] |
|
|
Example 3 |
[download id=”9″ format=”fara hit”] |
|
|
Just for fun, check the example showing same workbook in the advanced area…
Intermediate users:
1)A solution for a small company making sandwiches 🙂 .
Well, this is its title, but it suits well any business which has a recipe for its ingredients, the ingredients have a limited validity and it has some sales forecast. More things explained in the files, presented in various formats, available for download :
|
English |
French |
Romanian |
Excel 2000/2003 format |
[download id=”1″ format=”fara hit”] |
|
[download id=”4″ format=”fara hit”] |
Excel 2007 format |
[download id=”2″ format=”fara hit”] |
|
[download id=”5″ format=”fara hit”] |
OpenOffice Calc format |
[download id=”3″] |
|
[download id=”17″] |
Google Docs compatible format |
[download id=”6″ format=”fara hit”] |
|
|
Advanced-users:
1) A solution showing how to dispose a tourist group in a Bus (various buses schemes can be chosen) matching (as much as possible) their expressed preferences (family, groups, window, etc.).
Work in progress… Just a first draft, please,excuse the lack of explanations.
I am working on it! Just for the curious, file is here, for download:
In Excel 2003 format [download id=”10″ format=”fara hit”],
or in Excel 2007 format [download id=”11″ format=”fara hit”].
It is named ‘Bus discontentment factor’ .
Please note : Bus1 Sheet can be replicated, renamed and then modified, preserving all functionality.
2) Calculating penalties for late payments. [download id=”12″ format=”fara hit”]. This is the ‘advanced-form’ for the series presented in the Beginners-section.
3) How to palletize carton boxes ?
[download id=”13″ format=”fara hit”].
This example tries to solve that and also to illustrate 2 different solutions to translate (without VBA) within the same workbook. Also, a solution to handle pictures embedded in the file.
Everybody :
1) A small zip file, showing that you could use Excel to build solutions that would barely look as spreadsheeting (the workbook CONTAINS VBA code !)
The zip file has 1 Excel (2003 style) file + a folder with some pictures.
The excel file and a folder named Pics have to be placed in the same folder !
You can (please !) use your own pics.
Zip file is below, for download.
|
English |
French |
Romanian |
Pics example (zip files) |
[download id=”14″ format=”fara hit”] |
[download id=”15″ format=”fara hit”] |
[download id=”16″ format=”fara hit”] |
If you just want to see what it does , check is as a flash movie loop (sorry for the look, my movie making skills are not my best).
Please, keep close ! More to come ….! Shortly ?!