Recent content by cctanaka

Thanks JulieInMaine. Carlos Cesar tanaka Curso de Excel / Access MPR Informatica

Yes I vê done this. It seems correct. I assigned $1 for each resource cost, is that right. Carlos Cesar tanaka Curso de Excel / Access MPR Informatica

Hello, I need to compare the amount of finished work ( % finished work) against the the ideal work (work without delays) finished in a status date. How could I obtain the last one? Thanks in advance. Carlos Cesar tanaka Curso de Excel / Access MPR Informatica

The solution presented by SkipVought has worked, besides it is simpler. Thanks. Carlos César tanaka Curso de Excel / Access MPR Informática

Hi, I am trying to create a Dynamic Chart using named ranges. 1. I created two named ranges as follow: CatX - workbook scope, with the formula: =OFFSET(INDIRECT("'Week Data'!$B$" & Metas!$C$4+2);0;0;Metas!$C$5-Metas!$C$4;1) CatY - workbook scope, with the formula...

Hi, How can I create a report of kind cross reference with: Resources, tasks and note in the lines Time in the columns Duration in the Data area (intersection between lines and columns) Thanks in advance. Carlos César tanaka Curso de Excel / Access MPR Informática

Hi Gruuuu, I have understood you did not used POST options in VBA before, but I think you really can help me. Here is a code that uses this method, that I adapted from site http://www.business-spreadsheets.com/forum.asp?t=103 You have to create an account and change in the constants below...

Thanks again, One more doubt, I have seen the code place you have posted above. Shouldn´t we also send two more parameters which appear some lines below in the code of Resumo_semanal_index.asp? These parameters are: rdResumo selCombustivel Carlos César tanaka Curso de Excel / Access MPR...

Hi Gruuuu, I have researched this subject and discovered that is possible to make a Excel Web Query to a site that has a form using POST method. It has to use a IQY file, separating URL from parameters. My problem is I am not being able to discover what are the parameters (names). Could you...

Thanks Gruuuu, I am trying to extract data from that table using HTML elements. I would like to know if it is possible to make a web query (using Excel / Data) to navigate through links of web page and options of forms, and then extract a table, like that I described in the previous post. I am...

Hello, I cannot import data from teh following site: http://www.anp.gov.br/preco then link "SEMANAL - RESUMO I" Select option button ESTADOS, combo box GASOLINA Submmit - Processar The resultant table, starting with word "ESTADO" in light blue, has spanned cells (in the header), I think Web...

Thanks for the answer. I use Project 2007 (12.0.6423.1000) SP2 MSO (12.0.6425.1000), Brazilian. The default working period is 9:00 to 18:00. THe hints you have made did not solve the problem. Have you followed the steps before to verify if that problem really exist? I think it could be a...

Hi, I am having a problem working with nondefault calendar. I am using MS Project 2007 (office with SP2 - Language Portuguese) Situation: 1. Start a new project. a. create a task with duration of 1 day in a friday b. create a second task with duration of 1 day and make a constraint Finish...

Hello, I have a SBS 2008 Standard Server with Backup Exec 12.5. I would like to have some cheap redundancy, so I thought about having another server in the net (a Windows Server 2008 Std) configured as a secondary server, plus the data on the first server. For the data I want to use backup Exec...

Yes that works. It follows my idea, the difference is that I create variables to make changes flexible. If one do not need parameters just cut them off. Carlos César tanaka Curso de Excel / Access MPR Informática