Posts

Showing posts with the label spreadsheet

Commmand line pluses.

Image
Open source and the command line is a match made in heaven. The command line allows porting of age old rock solid code to nix. Most command line programs survive in the fact they can do one thing well and be used to pipe data from one form to another all without the fancy gui environment. Text based programs port very well. Of gui front ends can always be added later. For example an old spreadsheet program originally written many years ago for cpm using mbasic still lives with the ability for free basic to recompile (with changes) the code.The following flatfile database originally developed in the DOS environment  is being expanded to have the abilities for a relational database.   Lastly there is a text editor developed in the TRS-80 days that can still be easily used in the command line environment when compiled with freebasic. Programs like dosbox can make the conversion easier.     A bit rusty with it but: Native linux version: ...

Command line spreadsheet.

Image
No matter what system you use or even if you do everything by hand, you will need a typewriter (editor), Filing cabinet (database), and an financial worksheet (spreadsheet). Everyone knows about vim, nano, and  for using as editor or word processor. If you have ever wanted to set up a filing cabinet or database, you probably have heard of Mysql (or one of the variants), Postgresql, or even Nosql. What many people have not heard of is a spreadsheet for the command line.One interesting spreadsheet is called simply enough called sc. Some people may lead you to believe it will only support just numbers that is not true. You can even get a help file with: $ scqref > sc_commands ... ...  A:   This overview  B:   Toggle Options  C:   Set Options  D:   Cursor movement commands  E:   Cell entry and editing commands  F:   Line Editing  G:   File comm...

Remember Visicalc?

Image
What if Software Arts had patented Visicalc, Visiword, and etc?  Would office365 and Libreoffice never have existed?   Picture is actual VC.com running in the dosbox emulator. Per www.archive.org VisiCalc was the first spreadsheet computer program, originally released for the Apple II. It is often considered the application that turned the microcomputer from a hobby for computer enthusiasts into a serious business tool. VisiCalc sold over 700,000 copies in six years. Conceived by Dan Bricklin, refined by Bob Frankston, developed by their company Software Arts, and distributed by Personal Software in 1979 (later named VisiCorp) for the Apple II computer, it propelled the Apple from being a hobbyist's toy to a useful tool for business, two years before the introduction of the IBM PC. VisiCalc was, in part, inspired by earlier "row and column" spreadsheet programs in widespread use on systems of several national timesharing com...

Business office evoluton.

Image
Good old fashioned office. Standalone packages Database: Word processor:   Spreadsheet:   Integrated packages: Office packages: Integrated ERP/CMS: Beyond.....

Business office evoluton.

Image
Good old fashioned office. Standalone packages Database: Word processor:   Spreadsheet:   Integrated packages: Office packages: Integrated ERP/CMS: Beyond.....

Disappearing spreadsheet.

Image
  The code is at: http://thiscouldbebetter.wordpress.com/2013/04/16/a-simple-spreadsheet-in-javascript/

Simple spreadsheet

Image
Ever wanted to use a spreadsheet just for a quick calculation either on your computer or especially on a touch pad.  If nothing else it can be used as a learning to in building your own spreadsheets. Years ago I found this source code for a minimal spreadsheet from a CPM (forerunner of DOS operating systems) magazine. Typed it in and have been using it since. Of course many improvements have been made since the original code was typed in.  As I port the code to new platforms, there are always enhancements to be made. Everything now is web based so why not a basic spreadsheet. It is made up of three files that need to reside in the same directory. Major improvements can and should be made. Hope you enjoy this page as much as I did from the code I used years ago.  To be honest there are many good javascript spreadsheets (aka http://www.simple-groupware.de/cms/Spreadsheet/Home ), this article is just for example in case you wanted to dabble one of your own. --------...

What is the date?

Image
The above graphic is nice but what is the date for a particular day. How about the day 214? Supposedly close to the hottest day of the year, then what actual day is that?  Usage: ./main dayofyear year $ ./main 214 2014 Result: day 214 of year 2014 is '08/02/2014'. To confirm it: So it looks like August 2, is near the hottest day of the year. $ gcc main.c -o main main.c [code]  #define _XOPEN_SOURCE /* glibc2 needs this for strptime */ #include <stdio.h> #include <stdlib.h> #include <time.h>   #include <errno.h> int to_date(   char * date,   const size_t size,   const char * fmt,   const short unsigned int day_of_year,   const short unsigned int year) {   char buffer[16] = "";   sprintf(buffer, "%hu %hu", day_of_year, year);   {     struct tm t = {0};     char * presult = strptime(buffer, "%j %Y", &t);   ...

Basically.

Image
BASIC (standing for B eginner's A ll Purpose S ymbolic I nstruction C ode) was written (invented) in 1963, at Dartmouth College, by mathematicians John George Kemeny and Tom Kurtzas as a teaching tool for undergraduates. BASIC has been one of the most commonly used computer programming languages, a simple computer language considered an easy step for students to learn before more powerful languages such as FORTRAN . (formula translation) You can read more about the evolution of BASIC at https://en.wikipedia.org/wiki/BASIC . My first computer language was Fortran running on IBM type big iron. Came home from college and saw that my younger brother had purchased a home computer. It was a TRS-80 and came with built in BASIC. I asked my brother how to use it and he stated read the manual. So the next couple of days I devoured the information from the text. BASIC was very much like Fortran, so the transition to learn it was fairly easily. Ended up with the limited memory of...

Spreadsheets are more than for accounting.

Image
Statistics are so interesting. I was curious about the NFL draft. Thinking how could I look at the results of the draft. Voila a spreadsheet of course. A spreadsheet is sometimes known as a flat file and looks much like an accountant's worksheet. That is it has no relation to any other file in its most rudimentary form. For our purposes that would be just fine.The original list was in the order of when someone was drafted. So I gathered the data from the draft with everything in corresponding columns. That makes sense. Then I thought what can I do. Arranging or sorting a list is one of the pluses of the spreadsheet. Let's see you have the team name, draftee and his position, plus some other vital data. Posed myself a question that maybe opposing teams might ask. The teams obviously drafted where they thought they might need help. Lets do a sort and see who needs what. Instructions to do a sort for your spreadsheet may vary. Noticed that there was only one punter draf...

Screen resolution update

Image
This is probably a better look at the change in resolution. I did a text scrape of a spreadsheet I wrote. Before:  After:   A bit bigger(or smaller as the case may be).....