Ann: Excel Writer v.05

Hello! There is a new release of Excel Writer. What's new: * Some new built-in Excel numeric formats * Usage of Excel_Out instead of Ada.Text_IO (and conversely) made a bit easier * Should compile on any Ada 95+ compiler (a non-compliant detail was fixed) Download: http://excel-writer.sf.net Enjoy! _________________________________________________________ Gautier's Ada programming -- http://sf.net/users/gdemont/ NB: For a direct answer, e-mail address on the Web site!

ANN: Resolver One 1.8 released

We are proud to announce the release of Resolver One, version 1.8. Resolver One is a Windows-based spreadsheet that helps you build more reliable, more maintainable models, by providing you with a well- integrated programming platform based on the Python language. For version 1.8, we've made serious performance improvements, and added support for the new syntax in Python 2.6. You can read more about Resolver One here: <http://www.resolversystems.com/products/resolver-one/> We have a 31-day free trial version, so if you would like to take a look, you can download it from

Custom Dialog Boxes

I generally use standard Yes/No dialog boxes in my worksheets. I have a need to have a check box at the bottom so users can choose not to see the dialog box again. I inserted an Excel 5.0 dialog box with a YES & NO buttons and a check box at the bottom. Does anyone know how I capture the button the user presses so I can code the macro to continue or stop? (It is siliar to the task I am trying to accomplish in the code below if that helps with the explanation.) Thanks for any help -Michael Msg = "Compare Cash Value to Balance" & Chr(10) + acct1 Style = vbYesNo Title = " Cash Verific

What does =B11*$C$4 mean?

I get the cell value equals cell B11 times��then what's the $ mean, $C$4? I think it means use the value in cell C4, but what do the $ mean?

GeoDLL - Geodetic Functions as DLL for your own geodetic programs

Hello, GeoDLL is available in a new version and can be downloaded from my website now. For those of you who do not know GeoDLL yet, I have made a short description here. GeoDLL supports the development of geodetic software on various platforms by providing geodetic functions. GeoDLL contains precise functions of the themes 2D and 3D coordinate transformation, geodetic datum shift and reference system convertion, meridian strip changing, user defined coordinate and reference systems, distance calculation, Digital Elevation Model, NTv2 handling, Direct / Inverse Solutions and map fun

ANN: Resolver One 1.6.5 released

We are proud to announce the release of Resolver One, version 1.6.5. Resolver One is a Windows-based spreadsheet that helps you build more more reliable, more maintainable models, by providing you with a well- integrated programming platform based on the Python language. For versions 1.6 and 1.6.5, we've made it easier for people to share their spreadsheets. A new free "player" version means you can pass your work on to other people, and they can use it without having to buy anything, while a new Resolverlib makes calling your spreadsheets from IronPython .NET programs as easy as

Hierarchical spreadsheet?

Hi all, does anyone know about any work done on alternative (especially open source) spreadsheets? I use Excel all day and consequently have some opinions on the possible design of a spreadsheet that modifies the Visicalc-style flat grid paradigm. Two main ideas are that the spreadsheet should concentrate on explanation and "self-documentation" rather than calculation, and that a hierarchical format would work better for many applications. If anyone actually wants to hear more about my ideas, I wrote up a short essay at: http://www.emerose.org/explicans/explicans.html I'm awar

SumIf formula with multiple criteria

Given range named "type" and "qty", i am trying to write a formula that will sum the "qty" of multiple "type"s together. I've tried =sum(if((type="apples")+(type="oranges"),qty,0) and =sumif(type,(or("apples"),("oranges")),qty) neither work....can someone help me

ANN: Resolver One 1.5 released

We are proud to announce the release of Resolver One, version 1.5. Resolver One is a Windows-based spreadsheet that helps you build more more reliable, more maintainable models, by providing you with a well- integrated programming platform based on the Python language. For version 1.5, we've added a console; this new command-line window gives you a way to interact with your spreadsheet using Python statements. Here's a screencast showing why this is worth doing: <http://www.resolversystems.com/screencasts/console/> We have a 31-day free trial version, so if you would like to

hello! Want to buy software Retail or OEM, Microsoft, Adobe, Macromedia, Corel Symantec

WE BUY SOFTWARE EMAIL: theebayshark@aol.com <mailto:theebayshark@aol.com> WITH ANY SOFTWARE OFFERS. Sellussoftware.com WTB: WINDOWS XP PRO, WIN2K PRO, HOME, 98SE, 98, 95, NT 4.0, OFFICE, SERVER INCLUDES MICROSOFT, DELL, COMPAQ, IBM, HP OR ANY OTHER OEM PACKAGES Email: theebayshark@aol.com <mailto:theebayshark@aol.com> with what you have. WE ARE BUYING WINDOWS XP PRO, WIN2K PRO, HOME, 98SE, 98, 95, NT 4.0, OFFICE, SERVER INCLUDES MICROSOFT, DELL, COMPAQ, IBM, HP OR ANY OTHER OEM PACKAGES Email: theebayshark@aol.com <mailto:theebayshark@aol.com> with what you have. WE BUY MIC

hello! WTB SELL ME YOUR software OEM or Retail LARGE and SMALL QTY

WTB: MICROSOFT OEM SOFTWARE WTB: MS WIN 95, 98, 98SE, 2K, XP, OFFICE 2000, XP, 97, 95 PRO-Vista ultimate, basic, premium Small business.. Looks at the list below. Wanted to buy.. Microsoft OEM and RETAIL Software in small and large quantities. Buying in areas of 1-2000 or more! The more the better! Here is a partial list below. Email us with what you have! Office 2000 SBE Office 2000 PRO Office XP SBE Office XP PRO Office 2003 Office 2007 Pro, Ultimate Office 97 PRO Office 97 SBE WIN 95, 98, 98 SE, 2000 PRO and XP Windows 2000 Server Windows 2000 Server +5, 10 or

Need spreadsheet...maybe not Hexcel

Need spreadsheet not unlike Quattro-Pro. * Must be able to graph 2 variables (eg:volume, temperature VS time) and show each with its own grids in its own colors with scales in same colors (eg: one on left, other on right). * Absolutely !MUST! be able to do all of the following: 1) copy a graph to a (given, programmed) position ..and i mean COPY - NO changes of font or anything else! 2) via program/macro, to change title(s) obtained from given cell(s) ..and i mean change text ONLY - NO changes of font or anything else! 3) via program/macro, export graph in BMP or GIF format an

how can I retrieve value of next occurence?

I'm using Excel 2007 and s/s is 325501 rows deep. It consists of series of ranges between 4 and 30 rows deep. I want to locate the next appearance of the name in column C and copy a number on same row in column L to column Q on the row of former appearance. The desired objective is to place in column Q the next appearing number in column L of the name in column C. When the next appearance presents no number I need to find the next appearance which does have a number. Doing this manully is not feasible, given the large size of the s/s . If anyone can help me to this end I wo

ANN: Resolver One 1.3 released

We are proud to announce the release of Resolver One, version 1.3. Resolver One is an Excel-compatible spreadsheet designed for reliability. It's programmable in Python, integrates easily with .NET, and comes with a built-in Web server. It runs on Windows, and there's a free version for non-commercial use. For version 1.3, we've made two big changes: * Our Web server, which (as you would expect) allows you to expose your spreadsheets to other people as web applications, is now included - in the free version of the software too! (It was previously a commercial-only product.) * W

How do I macro 20,000+ series of data?

The full s/s stretches to nearly 350,000 rows and consists of over 20,000 series of data, between 6 and 30 rows deep, in columns A:J. In column I of each series, on rows 3, 4 and 5 there are three numbers. The second number is to be subtracted from the first with the answer being divided by the third. If possible, the answers should appear in the rows directly beneath these three numbers. Because there are so many series of data it isn't feasible to manually input the formula and I'm searching for a macro(s) which can do it automatically. Can anyone please suggest code to help

Is there a macro to transfer a row of data from top to bottom row of range ??

I use excel 2007. I have a s/s encompassing over 350,000 rows. Data consists of a series of ranges from columns A:N and rows varying in number between 3 and 30. There are two blank lines between each range of data. Each range is (with exception) numerically ordered down column H (e.g, 1, 2, 3, etc). Problem: there are around 1100 occasions when a range contains a row of data which is to be disqualified from consideration. On these occasions the data always appears in the top row of the range and is identifiable in column H by the nine codes 111, 222, 333, 444, 555, 666, 77

123 feature not supported in Excel & NeoOffice?

All, I've been a long time user of Smartsuite on OS/2 and Windows but as there has been little development for quite a while and I've now got a Mac, my spreadsheets are being transferred via Excel format to NeoOffice's Calc (an Open Office clone). One of my spreadsheets consists of many sheets each recording daily rainfall for a year. The final sheet has a summary of the monthly statistics. In 123 I use formulae to count how many years have complete records for the month. The formula is something like: +12-Countif(sheet1.b36:sheet12.b36,"y") where cell B36 on each sheet

How Can I in office 2003

hi all, i am trying to do the following with a m/s spread/s.. i need to be able to change a month date (e.g. Sept 2008) and have a row of day names ( monday 1st etc) change according to the month and length of month.. its for a staff rota i am trying to build... any help would be really app.... thanks in advance... btw.. i have no vb experience..

API

How i can find name of share folders by API programing?whitch .dll file?

ANN: Resolver One 1.1 released

We're delighted to announce version 1.1 of Resolver One, a Windows spreadsheet/IDE mashup that can be programmed in IronPython. As you enter formulae on the grid, it writes the equivalent computer program for you, using the IronPython language. As you add your own IronPython code, the grid is updated. This allows you to build applications that are much more complex but better-structured than a traditional spreadsheet, much more quickly than you could if you were using a regular programming language. You can then export the code and re-use it elsewhere in your own programs. The

Corrupted XLS file Options

Hello all, I have created a Excel 2003 spreadsheet that basically links 18 other spreadsheets together as a summary file. It has grown to about 4MB. When saving, it saves OK. However, ...... the file prompts 'Cannot open file'. Is there a utility out there to fix this?

FREE E- BOOK

Before you get into internet marketing you need to get the TRUTH! Get your free copy of... It's only easy if you know the TRUTH. It's a must read ! http://www.GRNPortalToWealth.com

Calculation for a summary sheet

I made an excel sheet to calculate the number of the vacation taken by the employees excluding the weekend and the official holidays. B22=From (date) > > C22= To Date > > D22= Total Taken > > C44:C53 =Official Holidays > > =NETWORKDAYS(B22,C22,C44:C53) what i do really need is to find formula that allows me to know the number of days taken in each month of the year as a summary sheet A5=NAME C5=JANUARY D5=FEBRUARY etc......

ANN: version 1.0.1 of Resolver One, a Windows spreadsheet/IDE

Hi! We're delighted to announce version 1.0.1 of Resolver One, a Windows spreadsheet/IDE mashup that can be programmed in IronPython. As you enter formulae on the grid, it writes the equivalent computer program for you, using the IronPython language. As you add your own IronPython code, the grid is updated. This allows you to build applications that are much more complex but better-structured than a traditional spreadsheet, much more quickly than you could if you were using a regular programming language. You can then export the code and re-use it elsewhere in your own program

Charting multi-dimensional data

Hi all, I have data that looks like this: 1/1/2008 Red 3.325 5.668 5.461 5.598 5.608 5.598 5.688 1/1/2008 Yellow 12.658 14.09 13.413 13.129 14.09 13.65 13.303 1/1/2008 Blue 7.07 6.963 6.84 6.92 6.86 7.01 6.94 1/8/2008 Red 3.935 3.785 3.685 3.665 3.765 3.635 3.715 1/8/2008 Yellow 8.502 8.802 8.793 8.632 8.456 8.573 8.593 1/8/2008 Blue 4.777 4.626 5.278 4.557 4.757 4.706 4.597 1/15/2008 Red 3.445 3.295 5.518 5.448 5.548 5.588 3.415 1/15/2008 Yellow 13.129 12.999 13.052 8.212 8.252 8.242 8.272 1/15/2008 Blue 4.317 6.89 7.084 7.331 4.497 4.206 7.13 And (using Excel) I want to turn i