Posts Tagged excel user defined function call web service

Web Service That Collects End User HW Config And WEI

The focus of this project is the technology, i.e. get it to work. Only the simplest graphic design needed to show functionality is required.

I want a web site running on the www.one.com web hotel that automatically (as far as possible) collects end users HW config and WEI (Windows Experience Index).

A user who has registered and provided his HW data is qualified to search/browse HW data for all other reported systems.

The collected data should be browsable for qualified users by make/model of computer and CPU, as well as WEI. All collected information on a specific system shall be displayed when it is selected from the browsing tree/catalog or search results.

It is important that the php code and mySQL data base are well documented for further development.

A user should be able to report data from more than one computer.

Information to be collected and stored:

– computer manufacturer
– computer model
– computer manufacturers partnumber or equivalent
– CPU manufacturer
– CPU model
– CPU clock speed
– FSB speed
– Installed RAM
– max RAM
– Graphics adapter manufacturer
– Graphics adapter model
– Graphics adapter manufacturers partnumber or equivalent
– Graphics adapter video memory
– Graphics adapter supports Direct3D 9, DirectX 9, and WDDM 9 y/n (for each)?
– Hard disk size
– Hard disk bandwidth (if possible)
– Hard disk type (IDE/ATA…)
– laptop/stationary…
– monitor size
– Windows Experience Index and subindecies (manually entered if necessary)

The website should be written in css/html/php, and use a MySQL database. I guess an activeX control or java-something will be needed too for the info collection.

As much as possible of the data collection should be done without user interaction, but if a discrepancy is found when comparing manufacturer partnumber to an already registered system the user should be asked if the scanned/reported data really is accurate. Any user-entered data should be "spell checked" against the data base in order to maintain data integrity.

The purpose of the site is to build a data base of WEI for computers systems of different kinds.

Any text that the user sees must be stored separately so it can be translated in to other languages.

Tags: , , , , , , , , , , , , , , , ,

Excel RATE() Function Defined In Ruby

I need someone to look over a function I have defined in Ruby. Im wanting to clone Excels built-in RATE() function and cant seem to get the code right. This job will be considered complete when the function is working flawlessly.

Tags: , , , , , , , , , , , , , ,

French Social Bookmarking French Speaking Person

I am looking for an experienced and reliable person for social bookmarking of internal pages of my French language website.

I have a website on French with French keywords and I need the main links (~36) to be submitted to top 50 dofollow social bookmarking sites. 50*36 = 1800 bookmarks

Each url should be submitted to 50 most popular dofollow social bookmarking sites.

Below are some basic requirements:

– It is better to add my links to the existing bookmarking accounts. Old accounts are preferable.

– For each url i will give 5-6 Titles/descriptions/keyword tags. You should rotate them and use every title/decription/set of tags not more than 2 times.

– Each url should be submitted to top 50 dofollow social bookmarking sites.

– You should bookmark only one link in one account on social bookmarking site. It would be better, if you have enough (36) accounts on each social bookmarking site. If yo dont have enough accounts, you should create them.
New accounts user name, password, email used to create the account and the email password should be on the excel spreadsheet

– You need to provide me with a Exel spreadsheet (report) with the links to the bookmarks so i can verify the URLs.

– Spread the work during 10 to 15 days.

For each of 36 urls you will be provided 5 titles (anchors), 5-6 descriptions, 5-6 sets of tags. The main thing it is FRENCH site and social bookmarking sites are also should be FRENCH. Do not bid if you are not French speaking person and never had used French social bookmarking sites. Please send me a list of social bookmarking sites you would like to use.

Tags: , , , , , , , , , , , , , , , ,

SQL Server Function & Excel VBA User Defined Function

This small piece of work consists of 2 components:

1. A very small SQL Server 2005 Function must be written for my ANALYST table. The function should count the number of records in the table and return the counted number. No where clause exists.

2. In Excel VBA, a User Defined Function must be created which will call the SQL Server Function. Please note that it should be a Function and not a SUB. You may use Subs etc in the background, but it must be accessable via the User Defined Functions list in Excel.

So, the user (in Excel) will type into a field:

=CountedAnalysts()

Once the user clicks ok, the excel function must then call the SQL Server Function. The function will count the number of records in the ANALYSTS table and return it to Excel

Tags: , , , , , , , , , , , , , , , ,