Write some Software

1.2 New Functionality

New functionality is being provided in the MS Project 2013 client, in the form of a macro. This macro is designed to:

Read an input file containing

• Actual Costs to date

• Total Committals

For each project.

The macro will read through the file and apply the two values to the specific project task on the schedule. The key is the Project ID from Finance 1.

1.3 File Format

The file will be a comma separated file with the following fields:

File Header:

Interface Identifier: “Finance 1 Project Actuals ”

Date of data: yyyy-mm-dd

Detail Record

Project ID: numeric

Actuals: numeric, 2 decimal places

Commitments: numeric, 2 decimal places

Total Actuals to date: numeric, 2 decimal places

File Trailer:


Where there are no Actual or Commitment values, insert 0.

Example File:

Finance 1 Project Actuals 2014-07-02



Business Logic

1. File Extract

Field Name Data Type Use/Source

File Header

Interface Identifier: “Finance 1 Project Actuals ” First check for the macro – will not proceed if this is incorrect.

Date of Data Date: yyyy-mm-dd Date of extract data (end of business day). For overnight processing, ensure that the date is the day the data was updated on the Finance 1 system (ie not necessarily current date). The data should be aggregated to the midnight on that day (23:59:59)

Detail Record

Project ID Numeric Finance 1 Project Identifier although there is no mathematical function involved, so can tolerate text if the F1 identifier will deliver non-numeric data.

Actuals Value Numeric, 2 Decimal Places The Actual Cost incurred between the 1st of the current month to the end of the “Date of Data” date.

Commitments Numeric, 2 Decimal Places The commitments value at the end of the “Date of Data” date.

Total Actuals to date Numeric, 2 Decimal Places The Actual Cost incurred from the start of the Financial Year to the end of the “Date of Data” date.

Internal Cost of Labour Numeric, 2 Decimal Places

File Trailer


Beceriler: PHP, Yazılım Mimarisi

Daha fazlasını gör: trailer text, data processing costs, write name software, write macro, check input function php, mathematical finance, use extract function, macro project schedule, internal record system, macro values, function financial system, business finance write, financial data input, trailer logic record, trailer record logic, read write project file, macro software, extract business name, end day software, finance software, Mathematical Software, php current date yyyy, start software financial business, schedule task php, php task schedule

İşveren Hakkında:
( 0 değerlendirme ) Australia

Proje NO: #6508532

Bu iş için 1 freelancer ortalamada $277 teklif veriyor


A proposal has not yet been provided

in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(6 Değerlendirme)

A proposal has not yet been provided

in %bids___i_period_sub_35% gün içinde277%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(3 Değerlendirme)

Hi, We are a 1000 + employee firm. Charging 6$ an hour. Can start any technology immediately. Direct access to developers via skype, G talk and hotline – 24/7 availability for all 1000+ resource. We can bet you Daha Fazla

in %bids___i_period_sub_35% gün içinde144%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)