Hi Eric
The brute force way (requiring the least mathematical analysis) is to
calculate the left hand side as functions of two reasonable first guess x
and y inputs and then calculate the total error (say as a sum squares of the
differences) of these compared to the right hand sides.
Once you have that you can run the solver add-in to minimise (or set to
zero) the error cell's value by altering (subject to optional constraints)
your input x and y values.
Regards
Steve Dalton
<fsshl@centurytel.net> wrote in message
news:1107681393.070670.213660@c13g2000cwb.googlegroups.com...
> Dear ms excel user/programmers:
>
> I hope this question is not repeated before. But anyway
>
> highly appreciate anyone can tell me how (or hint) to use ms excell
> and/or visual c/c++, basic, or octave(emulate matlab) to solve:
> (12-x)^2 + y^2 =15^2,
> (16+y)^2+x^2=25^2
>
> (by programming or using its built in function)?
>
> that ^2 mean square.
>
> looking to any excel user, mathmatician, and/or programmer's help,
> eric, fsshl@yahoo.com
>

Major help needed!!!! #2
Thanks for the post GE, I was able to find another computer with exce
97 still loaded. I opened the existing spreadheet and went through th
tools options and unchecked th 1904 date option. Went back to m
updated computer and the dates came across just fine.
Also thanks Don, your comment will be noted. I was in a rushed an
panic'd state :
--
KyDean
-----------------------------------------------------------------------
KyDeano's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1556
View this thread: http://www.excelforum.com/showthread.php?threadid=27128
...

error 0x800ccc13 #2I have Outlook 2000 installed on WinXP home. After installing modem
software (for fax purposes) I now receive error 0x800ccc13 when
performing 'send receive' in Outlook. Outlook Express now also fails
with 0x800ccc0f error. I've disabled all spywatch and filtering
software and tested Winsock using Netdiag and Winsock passes but there
is a fail for NetBT transports test failed (I'm assuming because I
removed all services other than TCP/IP.) I've reinstalled Outlook
Express using the procedure from #318378
http://support.microsoft.com/default.aspx?scid=kb;en-us;318378&amp...

MS Publisher #2Does anyone know how to open an MS Publisher 2000 document
with MS Publisher 97?
You cannot open a Publisher 2000 document in Publisher 97.
You need the same or later version of Publisher to open Publisher documents.
--
Why is it that people don't realize that they will probably have a problem
opening a newer file with an older program? Rarely does that ever happen.
"Riobard" <morgan.riobard@sivh.ie> wrote in message
news:12b801c38ceb$868aea80$a401280a@phx.gbl...
> Does anyone know how to open an MS Publisher 2000 document
> with MS Publisher 97?
Because t...

Import MySQL data to Excel
I would like to have a local Excel worksheet go out to a MySQL database
on a webserver and get data. I've seen how you can do web queries, but
these don't work with any site that requires authentication. I've also
seen the ODBC engine, but this only seems to work on local databases.
Does anyone know how I can link a worksheet to a MySQL database?
--
mbeyer
------------------------------------------------------------------------
mbeyer's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29230
View this thread: http://www.excelforum.com/showthread.php?th...

Help ! #2 Hi,
I have developed an application in VC++ where spelling of a word will be
checked in Excel (English is default).
I have used Automation for this. I want to use the same application for
German and French languages.
Could someone help me on how to select the language programmatically so
that selected language's dictionary will be
activated and spelling of a word will be checked in that selected language's
dictionary?
TIA,
Gary
...

Error adding users #2Hello all:
I am working with a new installation of MSCRM, and when I try to add a user
I get the "AN error ahs occurred, please contact your system administrator"
message. So I enabled tracing, and I have pasted the error details from the
trace file below...
Does anyone have any ideas?
John.
>MSCRM Application Error Report:
--------------------------------------------------------------------------------------------------------
Error: Index was out of range. Must be non-negative and less than the size
of the collection.
>Parameter name: index
Error Message: Index was ou...

RMS 2.0 ManualI have a general question. I remember over year ago when we were buying RMS
license we were receivig license+box with manual, user guide and Instalation
CD. From some time whenever we order new license there is A2 cartboard
"envelope" comming which have another A3 soft envelope in it and eventually
this one ontains 10cm x 10cm RMS license sheet.
Can someoe tell me is it just us or everybody have it this way.
Before after we did training for customer he had Manual/User Guide to look
back into if he forgot about something, I know that this manual is exact
printout of ...

Qty sold/Qty available #2
Any way of doing this on a top performer report? I would
like to see the qty sold and qty available per item, not
individual sales.
THANKS!
CT
>-----Original Message-----
>CT,
>
>Detailed Sales Report and add the On Hand column. (right
click on the
>report, Show/Hide Columns)
>
>--
>Jeff
>
>Get Secure! - www.microsoft.com/security
>
>=====================================================
>
>When responding to posts, please "Reply to Group" via
>your newsreader so that others may learn and benefit
>from your issue.
>
>=======...

Button for goal seek?! #2
Hello I have the following data:
5
6
12
15
20
Total of all those added
I will have to set a goal seek button so that i can put the total i
want and then change the cell i want i tried using a macro but i
couldnt do it... I just want to do it using a click of a button instead
of going to menu>goal seek>etc etc
Thanks a lot
From John
--
Neo1
------------------------------------------------------------------------
Neo1's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30329
View this thread: http://www.excelforum.com/showthread.php?threadid=515571
Any ...

FTP #2Greetings.
I have an MFC application working just fine using ftp with
CInternetSession and CFtpConnection, and I'm using windows ftp server.
this app needs to check file's size and dates where CFtpFileFind seems
to works perfectly.
I have some doubts:
1. this app seems to work fine with filezila ftp server... is there
somethig I have to know working with other ftp servers specially servers
runing on linux? I have seen that list files is not standard...
2. MFC can handle FTPS?? if not, does any one knows a good library? I'm
starting to see libcurl.
Any suggestions are welc...

Need help building a model in ExcelI'm modeling a two-step industrial process for work
Step #1 occurs anytime (date or day of week), step #1 requires 21 days
to completion
Step #2 follows step #1, but occurs ONLY on Mondays, so, for
example,for a particular instance, if (start date of step #1 + 21
days) is a Wed, step #2 doesn't commence until the following Monday.
I'm counting pieces (widgets) that will pass from step#1 to step#2,
and this model helps to provide estimates for the resources needed to
complete step #2
I've having intellectual problems trying to slove this
So input is count of widgets ente...

2 cells 2 colors
Hi All,
Here's my glitch:
I've got 2 dropdown/combo boxes in a user form. Both offer variou
color options. The 1st one colors an active cell the correct color tha
is chosen. The 2nd dropdown colors the cell directly to the right or th
active cell in the same manner. My code is pretty crude & not ver
efficient, but it works correctly. The problem is when color 2 is no
chosen. Currently, if a color isn't chosen, I can put an "X" in th
cell, or color it a certain color, but what I want is to color i
whatever the color of the active cell is.
Any ideas?
Thanks
--
S...

Forms.dic #2Hi,
I might have missed out something.
After installing MGP v8.0 SP5 on the workstation, I then I clicked on
Modifier, the system created a file called forms.dic.
After this, I can't open certain forms like Sales Transaction Windows, Sales
Order Fulfillment, Inventory Transaction, etc.
Other forms like Item Class ID, Journal Entry are fine.
Anything I miss out here?
TIA,
Sugih
Were these forms modified? Is security pointing to the modified forms? The
new forms.dic will be empty and not contain these forms. Most firms either
copy a complete forms.dic from a working workstation ...

Outlook 2007WinXP Pro SP3
Outlook 2007 - Pop3
Can outlook 2007 have mail stores (PST) greater than 2 GB? I have a friend
who keeps all for his business and is pushing the limit. I was told that
Outlook 2007 raised the limit.
Any clarification is appreciated.
--
*****************
John Lenz
JohnLenz@comcast.net
20Gb + if using the new, default, pst file type of Unicode which is the
default in Outlook 2003 and later
If however you upgraded outlook from a pre 2003 version, then it maybe that
you are still using the old outlook format data file which has the size
limitation.
Within Outlook, select ...

Office 97 to 2003: Excel: enter data w/fixed 2 decimal. 2000. be. #2When I enter number "2000." I get 20.00 - yes, set decimals at 2 but earlier
excel would accept change if you entered decimal with number. this is
slowing down a budget prep and I'd sure like some help - online and tutorials
say "enter decimal" but this is not working. what am I doing wrong?
...

matrix item in rms 2.0When creating a matrix item in 2.0, and selecting the option to show the
dimensions of the size and color with the description, I get a error message
that "itemlookup code or item description exeeds the allowed length. do you
wish to continue truncating the lookup code or description." However with
the old version I was able to do this. Is the description field more
restricted in size?
Also it whould be easier to be able to enter the matrix reorder #,minimum
order & case quantity when you create a matrx item, for now i have to do it
with the wizard.
Does anybody know ...

One Control for 2 codesMy Combo Box cbGSTOptions selects either tax or no tax but after making my
selection I need to update with another control form the calculation to work
Control 2 is under the line====
Can I incorporate these two code to just the Afterupdate of my Combo Box
----------------------------------------------------------------------
Option Compare Database
Option Explicit
Dim recInvoice_ItMdt As ADODB.Recordset
Dim recInvoice As ADODB.Recordset, dblGSTContentsValue As Double,
lngIntermediateID As Long
Dim dblGSTOptionsValue As Double
Dim bModify As Boolean
Dim ynCheque As Boolean, ln...

Exchange 2007 Beta 2 questionHi
I have the mailbox, CA, hub and UM on one server. I am trying to create a
new email life cycle policy, but the option to do this cannot be found. I
right click on the mailbox icon in EMC under "organization" but the option is
not listed. The only listed options are. Also the tab in ESM for this is not
there
New address list
New managed custom folder
new managed fodler mailbox policy
new offline address list
On Wed, 23 Aug 2006 13:58:02 -0700, skip
<skip@discussions.microsoft.com> wrote:
>Hi
>
>I have the mailbox, CA, hub and UM on one server. I am trying to...

2 X 2 Splitter Windows #2What is wrong with the following code? I am trying to create a 2 X 2
splitter window. It should look like this.
CMyTreeView | CMyListView
__________________|___________________
|
CPictureView | CDetailView
It compiles correctly but when I run it I get an error in the WinSplit
routine of MFC.
if(!m_wndSplitterWnd1.CreateStatic(this,1,2))
return FALSE;
if(!m_wndSplitterWnd1.CreateView(0,0, RUNTIME_CLASS(CMyTreeView),
CSize(0,0), pContext))
return FALSE;
if(!m_wndSplitterWnd2.CreateStatic(&m_wn...

AutoCorrect #2Can 'AutoCorrect' listings be transported from an old computer to a new one? I have hundreds of 'auto-corrections' that would take me all day to redo. Copying the dictionary does not seem to do it.
Robert, it is stored as a .ACL file ,do a search for *.acl and copy it to
the new computer
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **
"robert gerald" <...

CRM 1.2 subnet changeI am moving my CRM servers to a different site for DR, and I need to know if
I need to do anything to the server besides updating the DNS records with the
new IPs.
Anyone have any experience with this?
Thanks
...

duplicate #2I have spreadsheet that contains about 200,000 records. Many of them are
duplicated. How can I sort them out so that I can only have one of each?
Metalteck wrote:
|| I have spreadsheet that contains about 200,000 records. Many of them
|| are duplicated. How can I sort them out so that I can only have one
|| of each?
have a look here:
http://www.cpearson.com/excel/duplicat.htm#HighlightingDuplicates
--
Gordon Burgess-Parker
Interim Systems and Management Accounting
www.gbpcomputing.co.uk
ASAP Utilities has a feature that does this nicely..........
Free at www.asap-utilities.com
Vaya...

i haev not used excel much this weeks, but it has just started to play up.it seems to be having a problem.
I start excel as normal from the start menu and then Microsoft Excel, then
I click a box to start typing, if after clicking a box, and I move the mouse
in any direction it starts to select boxes. like the mouse button is
already held down, but it is not, I have tried another mouse and also tried
the keyboard short cuts and had the mouse unplugged too, when I have
restarted the pc to make sure it was not anything to do with the mouse.
has anyone else had this and fixed it,? if so how did you fix it,
thanks in advance for any help that you are able to give ...

TransferSpreadsheet Excel 2007 into Access 2003How can I TransferSpreadsheet Excel 2007 into Access 2003?
This does not work:
DoCmd.TransferSpreadsheet , acSpreadsheetTypeExcel9, "tblSomeData", "C:
\DataFolder\SomeData.xlsx", True, "Sheet1$"
If I save as an xls it will work:
DoCmd.TransferSpreadsheet , acSpreadsheetTypeExcel9, "tblSomeData", "C:
\DataFolder\SomeData.xls", True, "Sheet1$"
Do I need to do that? Is there another way?
Since Access 2003 came out long before Excel 2007 was designed, it seems
logical that it doesn't know anything about the Excel...