D
Daniel CHEN
Assignment will be due soon but you do not have an easy way to finish it?
Tired of spending hours on time-consuming, labor intensive work?
Try UDQ Consulting Services -
Consulting Cost Starting from $25.00 - Your Small Investment Could Save Your
Hours Even Days of Labor-Intensive Repetitive Work!
Most of the time, you can receive solution to your problem within 24-72
hours.
www.geocities.com/UDQServices (e-mail address removed)
UDQ Consulting Services Believes that Every Problem Should Have an Easy &
Simple Solution
Your "Impossible" Task Could Be Someone Else's "Piece of Cake"
You first consulting work could be free if it is not too difficult - limited
time only!
Project Based Consulting Could be Either On-Site or Remote
No matter what problem you have, even you think it is impossible or has
nothing to do with Excel, try UDQ Consulting Services! You will get an
affordable and satisfactory solution.
= - = - = - = - = - = - = - = - = - = - = - = - = - = - = - = - = - = -
UDQ Services has years of experience with MS Excel and VBA (Visual Basic for
Application) and has developed various kinds of utility programs, add-ins,
templates, spreadsheet applications, and database applications.
For MS Excel: File Password Protection, Sheets/Range Password Protection,
Conditional Formatting and Custom Formatting, Data Validation, List, Forms
and Controls, Array Functions, Database Functions, Value Lookup Functions,
Range Names, Customize Menu and Toolbar, Solver, Goal Seek, Scenario
Analysis, Statistic Analysis, Group and Outline, Subtotal, Filter and
Advanced Filter, Sort, Database Query and Web Query, Pivot Table and Pivot
Chart, XML, and Macros.
For Excel VBA: User-Defined Functions, Macros, Work with
Ranges/Charts/Sheets/Workbooks/Files/Directories, Forms and Controls for GUI
(Graphic User Interface), Customize Menu/Toolbars, API, External Database
Access via SQL, Extraction of Data from Internet, Extraction of Data from
External ASCII Files, Interact with Other Offices Applications (like Word,
Outlook), Class Module, etc.
VB6/Access/Others: UDQ Services also has experience with MS Access(Table,
Form, Query, Reports, Stored Procedure, Macro, VBA, Database Application),
VB6(ADO, DAO, Objects, API, ActiveX), Java, PHP, MySQL, Apache, HTML,C/C++,
SPSS, Matlab, etc.
= - = - = - = - = - = - = - = - = - = - = - = - = - = - = - = - = - = -
List of Recent Projects:
P001: Mortgage Transaction Spreadsheet Database
Developed a spreadsheet database application, which includes a user-friendly
loan transaction entry interface, password protected administrative page to
allow add/remove loan officer and loan manager, monthly and annual report
for loan officers / managers, monthly state report, etc.
P002: Customer List Converted from Excel Table to Word
Developed an interface to convert a list of customers from an Excel table
into a new Word document, one customer per page, including user-specified
headers.
P003: Amortization Calculator
Developed an amortization calculator: based on user specified loan amount,
interest rate, and term, calculate the monthly payment, total payment, total
interest payment, payment schedule table, interest rate sensitivity charts,
etc.
P004: Account Data Extraction from Internet
Developed a utility program to extract housing pricing/tax payment
information from a government website based on a list of house address.
P005: Sales Invoice Database
Developed a spreadsheet database for sales invoicing. If user input an
existing customer, then the shipping/billing address, VAT number, Account
Number, etc. for that customer will be automatically filled into the
invoice, otherwise, the new customer entry will be automatically added to
the existing customer list database, automatically fill product information,
calculate the invoice, create monthly and annual report for sales.
P006: Data Extraction from Hundreds of ASCII Files
Developed a spreadsheet application with user-friendly interface for
importing data from hundreds for external ASCII files based on
user-specified keywords.
P007: Mass Email based on Criteria
Developed a mass email program using Spreadsheet. Based on criteria (replied
or not), send email (reminder) to each individual in the list with different
body contents, different subject, and different salutation lines - about
1000 emails in the list.
www.geocities.com/UDQServices (e-mail address removed)
Tired of spending hours on time-consuming, labor intensive work?
Try UDQ Consulting Services -
Consulting Cost Starting from $25.00 - Your Small Investment Could Save Your
Hours Even Days of Labor-Intensive Repetitive Work!
Most of the time, you can receive solution to your problem within 24-72
hours.
www.geocities.com/UDQServices (e-mail address removed)
UDQ Consulting Services Believes that Every Problem Should Have an Easy &
Simple Solution
Your "Impossible" Task Could Be Someone Else's "Piece of Cake"
You first consulting work could be free if it is not too difficult - limited
time only!
Project Based Consulting Could be Either On-Site or Remote
No matter what problem you have, even you think it is impossible or has
nothing to do with Excel, try UDQ Consulting Services! You will get an
affordable and satisfactory solution.
= - = - = - = - = - = - = - = - = - = - = - = - = - = - = - = - = - = -
UDQ Services has years of experience with MS Excel and VBA (Visual Basic for
Application) and has developed various kinds of utility programs, add-ins,
templates, spreadsheet applications, and database applications.
For MS Excel: File Password Protection, Sheets/Range Password Protection,
Conditional Formatting and Custom Formatting, Data Validation, List, Forms
and Controls, Array Functions, Database Functions, Value Lookup Functions,
Range Names, Customize Menu and Toolbar, Solver, Goal Seek, Scenario
Analysis, Statistic Analysis, Group and Outline, Subtotal, Filter and
Advanced Filter, Sort, Database Query and Web Query, Pivot Table and Pivot
Chart, XML, and Macros.
For Excel VBA: User-Defined Functions, Macros, Work with
Ranges/Charts/Sheets/Workbooks/Files/Directories, Forms and Controls for GUI
(Graphic User Interface), Customize Menu/Toolbars, API, External Database
Access via SQL, Extraction of Data from Internet, Extraction of Data from
External ASCII Files, Interact with Other Offices Applications (like Word,
Outlook), Class Module, etc.
VB6/Access/Others: UDQ Services also has experience with MS Access(Table,
Form, Query, Reports, Stored Procedure, Macro, VBA, Database Application),
VB6(ADO, DAO, Objects, API, ActiveX), Java, PHP, MySQL, Apache, HTML,C/C++,
SPSS, Matlab, etc.
= - = - = - = - = - = - = - = - = - = - = - = - = - = - = - = - = - = -
List of Recent Projects:
P001: Mortgage Transaction Spreadsheet Database
Developed a spreadsheet database application, which includes a user-friendly
loan transaction entry interface, password protected administrative page to
allow add/remove loan officer and loan manager, monthly and annual report
for loan officers / managers, monthly state report, etc.
P002: Customer List Converted from Excel Table to Word
Developed an interface to convert a list of customers from an Excel table
into a new Word document, one customer per page, including user-specified
headers.
P003: Amortization Calculator
Developed an amortization calculator: based on user specified loan amount,
interest rate, and term, calculate the monthly payment, total payment, total
interest payment, payment schedule table, interest rate sensitivity charts,
etc.
P004: Account Data Extraction from Internet
Developed a utility program to extract housing pricing/tax payment
information from a government website based on a list of house address.
P005: Sales Invoice Database
Developed a spreadsheet database for sales invoicing. If user input an
existing customer, then the shipping/billing address, VAT number, Account
Number, etc. for that customer will be automatically filled into the
invoice, otherwise, the new customer entry will be automatically added to
the existing customer list database, automatically fill product information,
calculate the invoice, create monthly and annual report for sales.
P006: Data Extraction from Hundreds of ASCII Files
Developed a spreadsheet application with user-friendly interface for
importing data from hundreds for external ASCII files based on
user-specified keywords.
P007: Mass Email based on Criteria
Developed a mass email program using Spreadsheet. Based on criteria (replied
or not), send email (reminder) to each individual in the list with different
body contents, different subject, and different salutation lines - about
1000 emails in the list.
www.geocities.com/UDQServices (e-mail address removed)