Find Jobs
Hire Freelancers

Add-in for Excel 2010 to enter repeat values in a cell

$30-250 USD

Abgesagt
Veröffentlicht vor fast 12 Jahren

$30-250 USD

Bezahlt bei Lieferung
Develop a general-purpose add-in for Excel 2010 and Windows 7 that repeatedly enters different values in a defined cell. The cell values, called independent variables, have dependents but not precedents. User enters information in a dialog box similar to an attached prototype, along with a cell reference whose values are to be changed repeatedly over a range. The cell value is used in a set of equations that calculate certain desired results, usually on a separate worksheet. The dialog box uses input by the user to define the format of the results and to create a scatter-plot chart that shows a relationship between the entered value and one or more of the result values. The title of this add-in is to be MultiCalc.xlam. Users can open MultiCalc while working with Excel, and the dialog box remains in view while switching between different worksheets of a workbook. Do not rush to bid on this project. Read the attachments carefully. I want to see in your bid reply that you have read the requirements carefully. Your bid should include a brief statement of how you plan to do the project. A worker will not be chosen until 5 days after the project is posted. The first step is to analyze the problem and devise a solution. Next, translate the requirements into the language of the computer (and test it). Submit progress reports every 4 days, along with prototypes weekly. Excel is capable of making calculations where the results of a formula are used as inputs for a second formula, etc. However, this only works for a single calculation. If several calculations are wanted, the user must do them one by one, and copy the result to another location on the worksheet. If the user only wants one calculation, he would not use MultiCalc. This project asks for an Excel add-in that repeatedly enters a certain range of values into an input cell. These values, called independent variables, are used as inputs to one or more formulas. For example, if the user asked for a range of values between 8 and 20, and in addition, asked for 7 calculations, MultiCalc would enter 8, 10, 12, 14, 16, 18, and 20 into the designated cell address, and Excel would produce 7 different results. Intermediate results would need to be stored until all 7 calculations were complete or written to the worksheet according to the user’s specified location. The results are to be displayed on a specified worksheet in one of two ways. (1) A scatterplot chart showing the relationship between the entered value and one or more of the results; or (2) Complete sets of results (no chart) displayed on a new worksheet tiled vertically. In the case of the first option, the dialog box must allow the user to specify which result cells are to appear on the scatterplot. An attached workbook shows an example of the use of MultiCalc. To work on this project, you don’t need to know anything about combustion or how the formulae are written on the InputData or Results worksheet. MultiCalc will be applied to many different types of Excel worksheets, involving different engineering problems. Please examine the workbook example to see how MultiCalc is supposed to work. The prototype dialog box needs to be re-done according to good Excel VBA style Please read the project first and write the word "Understood". Also write your steps and suggestions to complete the project with a short description of what you understood.
Projekt-ID: 1698865

Über das Projekt

9 Vorschläge
Remote Projekt
Aktiv vor 12 Jahren

Möchten Sie etwas Geld verdienen?

Vorteile einer Ausschreibung auf Freelancer

Legen Sie Ihr Budget und Ihren Zeitrahmen fest
Für Ihre Arbeit bezahlt werden
Skizzieren Sie Ihren Vorschlag
Sie können sich kostenlos anmelden und auf Aufträge bieten
9 Freelancer bieten im Durchschnitt $240 USD für diesen Auftrag
Avatar des Nutzers
Understood. We have realized an add-in, it is working until and included, the table with results. We send in PM a Word document with description and screen captures.
$250 USD in 7 Tagen
4,9 (19 Bewertungen)
5,6
5,6
Avatar des Nutzers
Hello, I am an Excel VBA developer, please see my PM for bid details. Thanks, David
$250 USD in 5 Tagen
4,9 (3 Bewertungen)
4,4
4,4
Avatar des Nutzers
Hi, Understood. I would love to provide you with a WORKING SAMPLE for review. Please refer PM.
$200 USD in 5 Tagen
4,8 (10 Bewertungen)
4,0
4,0
Avatar des Nutzers
Hello, please see the PM for details.
$500 USD in 7 Tagen
5,0 (2 Bewertungen)
2,1
2,1
Avatar des Nutzers
Understood, please check your PM.
$200 USD in 2 Tagen
5,0 (4 Bewertungen)
1,9
1,9
Avatar des Nutzers
Hi! Please check PMB.
$500 USD in 30 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
I would like to apply for this position. I'm confident to do this job.
$30 USD in 2 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
let me do this one
$30 USD in 2 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
Hi, Hope you are doing well. I am writing in reply to your project posting. I have worked extensively on MS excel / VBA platform creating user friendly dashboards, simulators, models involving the use of excel formula, functions, objects such as drop down boxes, dialog boxes, graphs etc. I have a fairly strong knowledge of MS Excel (top 10% in the MS Excel 2007 Odesk test), I truly understand your question, have done multiple such type of projects and am sure my qualifications will meet your expectations. I can do the job on a priority basis for you. I hold a B. Tech. degree from IIT Delhi, one of the most prestigious engineering institutions of India and globally, and worked with multi-national firms in excel modeling area for various clients. My focus on understanding client's needs and delivering 100% quality results has always been appreciated by the clients. Although a relatively new Freelancer, with my passion, energy, attention to details and past experience I assure you I will leave no stone un-turned to make your project a success and build a strong long term professional relationship. Looking forward to hear back from you, Regards Kshitij
$200 USD in 5 Tagen
0,0 (0 Bewertungen)
0,0
0,0

Über den Kunden

Flagge von EGYPT
Cairo, Egypt
4,8
91
Zahlungsmethode verifiziert
Mitglied seit Aug. 15, 2008

Kundenüberprüfung

Danke! Wir haben Ihnen per E-Mail einen Link geschickt, über den Sie Ihr kostenloses Guthaben anfordern können.
Beim Senden Ihrer E-Mail ist ein Fehler aufgetreten. Bitte versuchen Sie es erneut.
Registrierte Benutzer Veröffentlichte Jobs
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Vorschau wird geladen
Erlaubnis zur Geolokalisierung erteilt.
Ihre Anmeldesitzung ist abgelaufen und Sie wurden abgemeldet. Bitte melden Sie sich erneut an.