»»» TCPhoneBill V1.3 ««« copyright © 1998-2000 by Mario 'padrino' Cattaneo 1. Introduction ------------ *NOTE* There are no German docs available, guess this readme should be enough... (If you need them though, try sending me an email!) As a student I am living in a flat-sharing community AND the telephone is mine, so I better had to think of an (quite) easy way to handle those monthly upcoming phone bills ;-) Well, I decided to use TurboCalc, included features like "Kabelanschluß", "Zählimpulse" etc... Finally I made tables for 2 to 5 flat members... So, after a while, and hours complaining about the German T*kom... guess I finally did it! 2. Disclaimer ---------- This software is provided AS IS. Neither do I claim it bugfree (or complete) nor do I give any warranty at all. Any damage that might happen to your system by using this package is not my fault. Use this software at your own risk! 3. Requirements ------------ I made these tables using TurboCalc 4.x, so they should work from V4 upwards. Probably they will work with older versions, too (not tested!). If you have any information on this topic _please_ let me know! 4. Usage & Notes ------------- Usage should be very easy, just load the desired table into TurboCalc, change all the data you need (like names, "Telefonanschluss (normal/sozial)"...), save the new template. Then if you need it again, just fill in the units (or fee for the other providers than the T*Kom) of each person... Notes: - "Einheiten (*0.1033 / * 0.0929 / * 0.0516)" can slightly differ from your phone bill because the Telekom rounds at every "Tarifzone" (even seperate for "normal" and "10plus"...) and they split them as often as they like... :( - The "Differenz" will be spread over the flat members by the percentage each amount of units is of the total. So if e.g. someone has no units at all, he or she won't have to pay a part of the "Differenz" (as he/she was probably not there and could not be guilty of doing anything wrong :-)... If you don't like this way, just tell me... If you think one could cheat this way, well 1. one could also cheat if it was devided into equal parts 2. you should better look out for a new flat-sharing community ;-) - The totals of each member are rounded in a way, so that their sum is never smaller than the grand total of the phone bill itself! This might differ upto "number-of-flat-members minus 1 PF" from the actual phone bill... - The tables ignore stuff like "ActivePlus" etc. I don't use it and I don't want to add extra rows for all their special cases like "normal", "10plus", special countries... - If you have e.g. units to foreign countries (or a mobile phone) you can always multiply their amounts. Their unit-values are just multiples of 12PF, too. 5. FEEDBACK -------- This software is CONTACTWARE! If you like it you should drop me a mail or even better send me a postcard of your hometown! Creating these tables was quite some work and they realy should (and probably will) make your life (at least concerning the phone bill ;-) a lot easier. So, feedback would not be too much to be expected, or are you just too lazy?! :( You might also have a look at other products of mine, which can be found on my homepage (http://www.cattaneo.de/projekte.e.html) or aminet®. Currently there are (besides this package): - TinyMWBCollection - SmileFonts - MagicMenu2MUI - pad-Diavolo (prerelease) - Aliazer - WormsCGXBootPic - IB_WebImages - BarIcons - ... And If you like those (or at least some) too, please contact me, write me a postcard, just FEEDBACK, feedback... You can reach me at: Mario Cattaneo Paul-Marien-Straße 6 D-66111 Saarbrücken GERMANY E-mail: cattaneo@coli.uni-sb.de IRC-nick: padrino (most time #AmigaGER...) Homepage: http://www.cattaneo.de/ 6. Future ------ If you have any ideas, or (even worse!) find bugs, please let me know! 7. History ------- V1.0: (02/11/1998) - initial release V1.1: (08/13/1998) - Changed tax to 16% - Added "10 plus" - Added "Privatanbieter" - Changed some terms to fit phonebill V1.2: (04/14/1999) - Added 6PF-Units - Changed regular unit value back to 12.0PF (from 12.1PF) V1.2a: (04/26/1999) - Fixed a bug in the calculation of the "Differenz" (just did too much cut 'n' paste ;-) V1.3: (02/15/2000) - Changed some terms again - Reduced unit values by 0.001PF each - Fixed another bug in the calculation of "Differenz" (4 members were always the default case) - Optimized some calculationstrings (they are easier to read now :-) - Protected cells that should not be changed by hand