Excel Project(repost)

Cancelado Postado Jan 3, 2010 Pago na entrega
Cancelado Pago na entrega

This is an Excel project with the following requirements.

1-the values in certain first range of cells is to be rounded up or down to the nearest predefined fraction.

2-the new values is then compared to the values in second range of cells.

3-When the matched values are found then the cells in the second set should be formatted exactly like the matched cells in the first range of cells.

## Deliverables

This is an Excel project with the following requirements.

1-The values in a predefined range of cells (which we call the? Range A) is to be rounded up or down to the nearest predefined fraction (e.g .01 or .05 or .25 ).

2-The new rounded values is then compared to the values in another range of cells (which we call the? Range B? ).

3-When the matched values are found in Range B then the cells in the? Range B? should be formatted exactly like the matched cells in? Range A? (i.e. font size, font color , background color ,etc...).

Note: the ranges that are used may be from different worksheets but are all in the same workbook.

* * *This broadcast message was sent to all bidders on Tuesday Dec 22, 2009 2:01:37 PM:

Attention all biders: Please take note that since the code will be used many times on many ranges in a workbook , there must be a user friendly way for me to define 3 pieces of information. 1- The fraction by which the values in range A to be rounded up/down.(e.g. 0.10 or 0.25 or etc...) 2- Range A needs to be defined. 3- Range B needs to be defined. Please adjust your bids if you need to.

* * *This broadcast message was sent to all bidders on Tuesday Dec 22, 2009 4:11:12 PM:

Thank you all for your bids . It seems a little more clarification is needed. Below is an example of how the code should work. Suppose Range A contains 5 cells with values 100.23 , 153.435 ,413.02 , 254.78 , 367.89 This range is rounded to the nearest .25 decimal which gives the following values : 100.25 , 153.50 , 413.00 , 254.75 , 368.00 Range B has 1360 cells starting from 80.00 to 420.00 (with 0.25 increments apart like 80.00,80.25,80.50,..to...,[url removed, login to view],420.00) Now what the code does is to find the value of the cells in Range A that match the cells in Range B and will format the same cells in Range B as they are in Range A.(same font size , color , background, etc...) Note: There are going to be many sets of Range A and Range B in the same worksheet and workbook and each set should operate separate from each other.

* * *This broadcast message was sent to all bidders on Tuesday Dec 22, 2009 4:15:31 PM:

By the way please try to provide the most efficient and user friendly and least time consuming method as this will have the greatest impact of your bid being accepted (with a reasonable bid price of course).

* * *This broadcast message was sent to all bidders on Tuesday Jan 5, 2010 6:17:47 AM:

It seems there are a lot of unresolved issues for many bidders so in order to answer all your questions I have attached a new zip file which contains four files to provide full explanation . Please start with the file named “Project description?? and after studying all the files please adjust your bids and time required to do the task accordingly.

Engenharia Microsoft MySQL PHP Gestão de projetos Arquitetura de software Teste de Software Visual Basic Visual Basic para Apps Área de trabalho do Windows

ID do Projeto: #3059774

Sobre o projeto

29 propostas Projeto remoto Ativo em Mar 12, 2010

29 freelancers estão ofertando em média $84 nesse trabalho

shikhamehta

See private message.

$157.25 USD in 14 dias
(232 Comentários)
7.0
pShankar2

See private message.

$85 USD in 14 dias
(408 Comentários)
7.1
schandraram

See private message.

$85 USD in 14 dias
(169 Comentários)
6.9
LogixSmith

See private message.

$17 USD in 14 dias
(55 Comentários)
6.0
Lotusdeveloper

See private message.

$106.25 USD in 14 dias
(82 Comentários)
5.2
mdsoftsl

See private message.

$153 USD in 14 dias
(12 Comentários)
5.0
expbingo

See private message.

$21.25 USD in 14 dias
(27 Comentários)
5.0
excelsolution

See private message.

$59.5 USD in 14 dias
(66 Comentários)
4.8
tatasthuinfotech

See private message.

$25.5 USD in 14 dias
(13 Comentários)
3.3
kanhashriinc

See private message.

$29.75 USD in 14 dias
(9 Comentários)
2.9
tookool4uvw

See private message.

$45 USD in 14 dias
(5 Comentários)
2.4
satheez1984

See private message.

$6.8 USD in 14 dias
(2 Comentários)
2.3
nguyenhoangtran

See private message.

$17 USD in 14 dias
(3 Comentários)
2.2
lalchetian

See private message.

$42.5 USD in 14 dias
(2 Comentários)
2.0
silverlinesoftvw

See private message.

$11.05 USD in 14 dias
(7 Comentários)
1.8
PeopleWorld

See private message.

$25.5 USD in 14 dias
(2 Comentários)
0.8
isoli

See private message.

$17 USD in 14 dias
(1 Comentário)
0.5
quadcorevw

See private message.

$34 USD in 14 dias
(1 Comentário)
0.0
ghiewa

See private message.

$63.75 USD in 14 dias
(0 Comentários)
0.0
kcdevelopers

See private message.

$212.5 USD in 14 dias
(0 Comentários)
0.0