AutoEuro_Code

Cerrado Publicado May 14, 2002 Pagado a la entrega
Cerrado Pagado a la entrega

Introduction. In breif - import a .txt file, chop it up, and place into an Excel(97) template (includes charts and calculations) We have a sales force out in the field (in the UK) who look after our Domestic customers who export out of the UK. But some of these Sales Reps look after some domestic accounts as well. The International customers have been given the prefix of “Eur01 to Eur12 including Eur????? the Eur??? Is an extra code for the management accounts. The “Eur?? codes are known as “Territory Codes?? hence “Terri Code?? in the Template. The Terri code is made up from a set geographical (Counties) area, identified by the UK PostCode system. The Domestic accounts are grouped by the individual post code system and are know as “Rep Code?? in the template. This information is always in the “Header?? marker. What I do with this method of reporting is to collate all relevant information belonging to the customer and their Trading habits ??" it’s a mild form of customer profiling. So it would be the “TurnOver?? “Parcels?? “Weight?? “Deliveries?? and from these values I can identify the general “Trading Health?? of the customer. To take it a bit further I then extract the various countries that they have been trading with and break down the type of “Service?? they have been using. I put in a “Good Performance indicator?? which is a trading level known as the “Threshold?? of say £2000 and produce a report to say that; For all the customers in “Eur01?? separate all the customers that have a monthly Turn over of above £2000 and put them into “Acustomers?? sheet. For the rest of the customers for “Eur01?? put them into “BCustomers?? sheet and for all the customers that have not traded this reporting month put them into “Down Traders?? sheet. There are three other sheets in each “Eur01?? report, which I will get to later. The “txt?? file. The “txt?? file is picked up from /u1/export/home/ducod/cprogs/terri If you use this path to start off with, but make it changeable (maybe by inserting a vbmsg box requesting the path prior to the running of the program) it would make it sort of portable so to speak. There is not enough space to describe the project, so if you want I will send an email with a full description.

## Deliverables

Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. Complete copyrights to all work purchased. For the txt file of September (of which I will send to you) the Reporting month is reporting the wrong month ??" should be September and not July ??" perhaps the sheets are not being cleared properly. · With account number 55203787 in the Summary sheet there is no data but in the Acustomers sheet there is one month worth of data ??" June 01 26061.1 ??" BUT it looks like the whole paste action is out of sync. It is also not picking up all 13 months on each account number. · Why is the “Copy & Paste?? process starting from the middle of “Acustomers?? ??" e.g. Acc # 55970850 But the “Acustomers?? report starts with acc# 55022065 · The data (actual turnover figures) that is placed on the Summary sheet is not that of the text file it has copied. Hidden Sheets · There is a leakage of data in the final process of producing the requested Euro code. · Also there are processing errors (see below) Acustomer Sheet. · There are a number of changes here. If you look at the Excel document that came with this report ??" named “[url removed, login to view]? ??" you will see what I mean. · The “Post code?? is in the “Account number?? space. The “Date Account Opened?? has got the “Rep Code?? ID in that space. In the “Location?? space is the “Tariff Code??. AEOR| Tariff code Acc num Post code Date Acc opened Rep Code ATRADHE| BRIDGEWATER DIST.& MANAGEMENT |30|55970850|E15 2DY |05/21/1997|SMA010 ATRADPR| 09-2000| 6875.82| 678.00| 7437.00| 289.00| 10-2000| 7673.89| 943.00| 8875.00| 313.00| 11-2000| 2616.00| 155.00| 1874.00| 43.00| · Where the “Total?? line is at the bottom of the “ATRADDE?? ??" Could you format this line to a two (2) digit decimal point and make it “Bold?? please. · In “User form1?? where you have the drop down list for which chart you require the program is picking up the “Post Code?? and “Customer Name??. The Customer Name is GOOD, but it should be picking up the “Account number?? and not the “Post Code?? ??" So if the above is changed then it should be picking up the “Account Number??. When the user creates a chart the chart is also picking up the “Total?? which it should not do, as that then throws out the true reading for the “Trend line??. · When the chart is created it is using the “Account number?? space as the “Sheet name?? but the “Post code?? is used but I think that when the proper spaces are used for the “Header Information?? then a number of cosmetic things will be solved. · [url removed, login to view] is a big gap between Acc # 55203787 and Acc # 55970850. If you look at the Text file the Account number that comes after 55203787 is 55219349 and NOT 55970850 But in the actual report between 55203787 and 55219349 there is this big gap and then the data for Acc # 55970850. What is going on here? Bcustomer Sheet. · First off there seems to be some slippage here where the first line to be pasted is being pasted into the wrong row BMONTHS| 09-2000|10-2000|11-2000|12-2000|01-2001|02-2001|03-2001|04-2001|05-2001|06-2001|07-2001|08-2001|09-2001| BDATA| 50001655|SECURICOR FUELSERV LTD | 17.10| 77.40| 51.30| 44.10| 49.50| 45.00| 71.10| 0.00| 0.00| 37.80| 47.70| 14.40| 33.30| 55001688|ZOFFANY LTD | 18.00| 0.00| 0.00| 0.00| 0.00| 0.00| 0.00| 14.00| 26.00| 22.00| 21.00| [url removed, login to view]| 0.00| NOT Being Imported (Yellow) Being Imported but not placed correctly.(Grey) · The grey area above matches the grey area on the Excel document. So the area in yellow has somehow been lost in the Copy and paste process. Could you correct this please? · Also the “Date?? format for the last month (red Bold) has not been picked up to format it to

## Platform

Windows 95 with Microsoft Office 97 2SE As this will be a portable function

## Deadline information

I need the code I have debugged and a stable program running. I need to know what Time frame this can be provided in and an estimate of cost - BEFORE I take anything on Please be reasonable. Cheers Neville

Ingeniería Microsoft MySQL PHP Arquitectura de software Verificación de software Visual Basic Windows Desktop

Nº del proyecto: #2851285

Sobre el proyecto

18 propuestas Proyecto remoto Activo Jun 4, 2002

18 freelancers están ofertando un promedio de $318 por este trabajo

cdware

See private message.

$382.5 USD en 14 días
(35 comentarios)
5.1
alex4vw

See private message.

$170 USD en 14 días
(19 comentarios)
4.5
jsmorgan24

See private message.

$340 USD en 14 días
(30 comentarios)
4.2
vw408662vw

See private message.

$127.5 USD en 14 días
(5 comentarios)
3.5
lightworkvw

See private message.

$255 USD en 14 días
(4 comentarios)
3.4
JTerrell72

See private message.

$425 USD en 14 días
(6 comentarios)
2.9
wordracr

See private message.

$403.75 USD en 14 días
(6 comentarios)
2.5
harshalvaidyavw

See private message.

$382.5 USD en 14 días
(2 comentarios)
1.3
ericeugene

See private message.

$425 USD en 14 días
(3 comentarios)
0.0
equicom

See private message.

$255 USD en 14 días
(0 comentarios)
0.0
whemmons

See private message.

$340 USD en 14 días
(0 comentarios)
0.0
phenden

See private message.

$297.5 USD en 14 días
(0 comentarios)
0.0
daidalos

See private message.

$408 USD en 14 días
(1 comentario)
0.0
citsystemsltd

See private message.

$408 USD en 14 días
(0 comentarios)
0.0
scottcarden

See private message.

$225.25 USD en 14 días
(0 comentarios)
0.0
kdcarden

See private message.

$212.5 USD en 14 días
(0 comentarios)
0.0
bykasifvw

See private message.

$340 USD en 14 días
(0 comentarios)
0.0
brettvandyke

See private message.

$318.75 USD en 14 días
(0 comentarios)
0.0