終了済み

Excel 2007 to [login to view URL] Configuration Generator

Excel spreadsheet expert with [url removed, login to view] experience.

The application is to be created in Excel 2007, and then uploaded to work in [url removed, login to view], ensuring that it works there. A portion of the Excel spreadsheet has been completed, and can therefore act as a specification. However, [url removed, login to view] does not support all Excel functionality. For instance, Microsoft VB is not supported. And, it does not support Conditional Formatting, so some of the already-completed spreadsheet logic must be accomplished in another way. This is why specific [url removed, login to view] experience is a must.

Therefore this is not an Excel 2007 developer gig. Nor is this right for most power Excel users.

Very good facility in English, and previous experience working in corporate environments gathering requirements for business applications (but not necessarily Excel-related) is a must. This because: once you understand what is required, as long as you have the skills noted above -- particularly knowledge of the limitations of [url removed, login to view] -- it will not take long to create what is needed.

I have several different documents that explain the task at hand from several different points of view. I have not included some because they would reveal our identity, violating [url removed, login to view] rules. This makes experience with translating business needs into applications more important than it would be otherwise.

This application automates the configuration of a "rust belt" product. This configuration work has been performed, manually to create customer quotations for some time. Currently, prospects enter information into a Web-based form on our website. There are, at most, 15 different variables entered. Many are yes/no or forced choice from a list.

This application will be used solely by resellers. It is, therefore, not expected that this will need to be "pretty" in any sense -- it just can't be confusing, and must lead the distributor sales rep to the right answer.

The reason why Excel is preferred over a forms-based Web application is that three of the data elements that drive the configuration choices are numbers. The numbers must then be tested (less than, greater than, etc.) as numbers -- not text. Based on the answer to those tests, different components are proposed.

Last Fall, the current functionality of forms-building Web-based tools DID support this same application that will now be posted at [url removed, login to view], just barely; the business requirements outgrew the application platform. In Oct. 2009, a slightly simpler version of this project was successfully created in Formstack (the erstwhile Formspring). This will give you an idea of the relative simplicity of this application.

The quotes we are currently producing never contain more than 10 line items, frequently only 5 or 6.

スキル: その他, シェアポイント, ウェブ記事のスクラップ, ウェブサイトのデザイン

さらに表示: excel configuration generator, excel 2007 create configuration generator, configuration generator excel, work with freelancer com, work translating, works need excel, works at freelancer, working with freelancer com, working at freelancer com, working as a freelancer web developer, work in freelancer com, work in act, work freelancer com, work as a freelancer web developer, why would i need data scraping, why freelancer com, what skills does a freelancer need, what makes a good freelancer, what is this freelancer com, what is sales support

採用者について:
( 2件のレビュー ) Belmont, United States

プロジェクトID: #743196

6人のフリーランサーが、このジョブに平均$328で入札しています

vbexcel

Over ten years experience in developing Excel/VBA solutions.

$400 USD 10日以内
(6件のレビュー)
4.3
Keira880

We are an experienced team specilized in this. We can do that according to your requirement.

$400 USD 15日以内
(0件のレビュー)
0.0
bnc002

Hi Will be done within time and budget ........... If you have any query please ask without any hesitation ....... Best Regards

$320 USD 10日以内
(0件のレビュー)
0.0
kshitish

I will do this for you,give me the opportunity to do this [login to view URL] PM

$300 USD 7日以内
(0件のレビュー)
0.0
mayuf

[login to view URL] is new to me, but I bid here because I found it very interesting, excel is my specialty and I do analytical work using excel for a large organization since 2004

$300 USD 10日以内
(0件のレビュー)
0.0
sankalplondon2

Please let me know when I have to start the work for u , I have my project website , I could even show that to u , My skype ID is sankalpsaxena7

$250 USD 12日以内
(0件のレビュー)
0.0