Cancellato

C#-based DLL, Excel 2007, 2010+ Toolbar/Add-in, Console Application and [Optional] Web Service for remote interaction with DLL

To provide the "skeleton" codebase for each deliverable so that algorithms may be added without requiring knowledge of creating the projects/solutions "from the ground up".

Highlights of the Deliverables:

? Excel 2010 Ribbon Changes - Custom Toolbar Group with complete VB or C# source code, executable (if needed?), and any/all required configuration files. Toolbar to contain Buttons and/or check boxes, etc., for selecting worksheet cell set(s), initiating processing [to be accomplished in DLL], saving preferences

? "Console" Process - used (in the absence of Excel) to provide the inputs & data for initiating processing within the DLL. Command-line launched with parameters to automatically carry-out desired operations.

? C# DLL - DLL to be called by Custom Toolbar (above) with complete C# source code and any/all build dependencies, and any/all configuration files.

? FUTURE: "Web Service" with Encrypted and non-encrypted connection options [if needed?]

## Deliverables

Deliverables:

? Excel 2010 Ribbon Changes - Custom Toolbar Group with complete VB or C# source code, executable (if needed?), and any/all required configuration files. Toolbar to house Buttons and/or drop-down menu items, for selecting worksheet cell set(s), initiating processing [to be accomplished in DLL], saving preferences

? "Console" Process - used (in the absence of Excel) to provide the inputs & data for initiating processing within the DLL. Command-line launched with parameters to automatically carry-out desired operations.

? C# DLL - DLL to be called by Custom Toolbar (above) with complete C# source code and any/all build dependencies, and any/all configuration files.

? FUTURE: "Web Service" with Encrypted and non-encrypted connection options [if needed?]

General Expectations:

? All code must be legible, well-formatted, and written in a logical manner

? Common naming conventions of code sections shall be used to improve understanding & readability

? Code projects/solutions shall use the base name of "PriResponse"

o Example: "PriResponse_setResults()"

? Method/interface/procedure names must not be cryptic or confusing

? Naming of code sections and button/dialog names should be obvious and easy to identify

? All code must be written to MINIMIZE overhead/processing consumed in sending/receiving data to the DLL and processing WITHIN the DLL

? Complete code shall be delivered along with all installation procedures, requirements, and dependencies (potentially an "Installer" feature will be needed for distribution of software)

Functionality:

? Excel Ribbon:

o Provide buttons for setting preferences and/or initiating processes within DLL

? Code should provide a minimum of components (so that quantities can be increased as needed)

? Minimum of (6) six buttons:

? "Preferences", Button to pop up user settings dialog

o Dialog to have four "check boxes" for enabling various DLL processing features

o Dialog to have a "slider" control & "linked" text box to set a value called "Reduction Factor" from 1 to 100 (integer numbers only)

o Provide "Apply" or "Cancel" buttons to apply preference changes or to cancel and close dialog

o User preferences should be saved to a file, or registry, or other location [please recommend] for later use of excel toolbar

? "Set Input", Button to set location(s) of INPUT cell set(s)*

? "Set Output", Button to set location(s) of 2nd set of INPUT_2 cell set(s)*

? "Set Result", Button to set location(s) of OUTPUT cell set(s)*

? "Calculate", Button to initiate PROCESSING (provided that INPUT/INPUT_2/RESULT location(s) are already set)

o Code should pass all cell sections (perhaps in form of Excel Ranges, etc.) to DLL via DLL method for processing and receipt of results back

? "Create Report", Button to initiate a report creation process that will pop-up windows to select:

o Set of cell set(s) * that contain the calculated data

o Set of cell set(s) * that contain any desired column labels

o Set of cell set(s) * that contain any desired row labels

*cell set(s) may be continuous and/or discontinuous sets of cells from single or multiple worksheets (within same workbook)

o Provide drop-down menu for setting preferences and/or initiating processes within DLL

o Provide check boxes to specify processing conditions

? Check box - with name "Bias 1"

? Check box - with name "Bias 2"

? Console app:

o Provide command-line flags/settings, etc. to initiate processing within the DLL

o All functionality, processing flags, etc shall be supported as if calls were coming from Excel Toolbar

? [OPTIONAL FUTURE COMPONENT] Web Service:

o Provide SSL and non-SSL encryption.

o Provide interface(s) for

? Setting and storing user preferences

? "Streaming" information from client to web-service for processing and results return

? Able to specify file name and location.

? DLL:

o Provides 100% (or as much as possible) of processing for supporting Ribbon-initiated and/or console-requested functions

o Ability to be called by "console" process or Excel-based Toolbar

o Has distinct purposes:

? [CONFIG] Provides an interface/method(s) to set processing conditions (i.e. - user preferences)

? [INPUT/OUTPUT]

? Provides a main "processing" interface/method(s) for ingesting the information/data sent from the Console-specified CSV file or other format(s), or via Excel-Toolbar declared worksheet/cell Range(s).

o CSV-based data:

? FROM: CSV-format file

? FROM: Fixed-Field text file

o Excel-based data:

? FROM: "live" excel application (currently running)

? Call from ribbon to pass [url removed, login to view](s) to DLL

? FROM: Excel file (all Excel file types: .xlsx & .xls extensions

? Ability to provide INPUT in one format and OUTPUT into another [i.e. IN: CSV, OUT: .xls]

? Input parameters include processing settings from the user preferences and/or check boxes, etc. on the Excel Toolbar as well as to specify how & where results are to be placed.

? Processing method(s) must create a copy of the data that is a List of continuous values

? Places "output" results set(s) back to calling process via one or more desired formats [i.e. - CSV file, Excel Range(s), etc.]

? Output format that is provided back to Excel via Excel Range(s) shall support alteration of *individual* cell formatting styles [i.e. - change fill color, text color, etc.] for each cell within the INPUT or RESULT cell set(s)

o DLL shall be able to accept input from and/or provide output to Excel as continuous/discontinuous cell set(s).

o DLL shall convert all input Excel Range(s) into a *continuous* List of the cell values along with a reference to the original cell location (row, column, sheet, workbook?) in order to "reconstruct" results sets to occupy a similar set of discontinuous cells in the INPUT or OUTPUT destination(s).

o DLL shall be written, constructed, and/or designed in such a way to provide MAXIMUM protection against exposing any of the logic/algorithms contained within the DLL. As such, method name(s) shall be generic and non-descriptive (although).

Competenze: .NET, ASP, Programmazione C#, Microsoft, Architettura Software, Visual Basic, Windows Desktop

Vedere di più: excel 2007 add, excel 2010, web algorithms, web 2.0 creation service, visual basic 6 web service code, vb creation, vb algorithms, use of algorithms, understanding algorithms, types of algorithms, the n and o, text algorithms, set o application, remote excel, order form format in excel, maximum data solutions, logical software solutions, logical operations, line algorithms, integer factor

Sul datore di lavoro:
( 0 valutazioni ) United States

ID Progetto: #2715685

6 freelance hanno fatto un'offerta media di $13/ora per questo lavoro

mastirlaa

See private message.

$25.48 USD / ora
(87 Recensioni)
6.3
richardst

See private message.

$10.01 USD / ora
(17 Recensioni)
5.0
yurok1975

See private message.

$10.01 USD / ora
(25 Recensioni)
4.2
Valy18

See private message.

$9.1 USD / ora
(7 Recensioni)
3.1
MSDev2012

See private message.

$5.46 USD / ora
(8 Recensioni)
2.6
shebabnewtok

See private message.

$13.65 USD / ora
(1 Recensione)
0.0
sigmasolvei

See private message.

$9 USD / ora
(0 Recensioni)
0.0
sst2010

See private message.

$25.48 USD / ora
(3 Recensioni)
0.8