Closed

PowerShell to calculate photocopier total usage cost per user by job type.

PowerShell to calculate photocopier total usage cost per user by job type.

Photocopier JobTypes: Print, Copy, Scan.

A/ First split the ‘User Name’ filed in the source CVS file as below:

1. Split the ’User Name’ column after the ## creating a new column ‘Softlog’

Eg Username username,SoftlogCode

Tori Sambrooks##8677 -> Tori Sambrook,8677

B/ Calculate totals per user by job type.

Please examine the data in attached Excel (both sheets)

Example.

1. The photocopier exports a CSV (attached) – see XLS file

2. The PowerShell is to calculate totals and produce a Report/CSV as below – see XLS ‘outputcsv’ sheet

PowerShell to calculate photocopier total usage cost per 'softloguser' by job type and produce a Report/CSV shown in attached XLS (see the ‘outputcsv’ sheet).

Please examine the exported photocopier data to understand how job types are identified also note the cost per job is calculated in column G, this needs to be totalled per softlogcode.

Skills: Microsoft, Powershell, Programming

See more: jquery calculate table total, excel advanced user job, cost flash job, freelance jobs from home, powershell scripting jobs, sell powershell scripts, powershell scripting freelance jobs, find freelance jobs, work as a freelancer, freelance jobs list, powershell freelance, excel user job, javascript calculate display total cost order, how to calculate total fixed cost, how to calculate total variable cost

About the Employer:
( 4 reviews ) Clayfield, Australia

Project ID: #23945395

9 freelancers are bidding on average $27 for this job

sohailhost

Hi, I can help you with this excel work for print calculation per user. I am systems administrator with over 12 years of experience managing server infrastructures and data-center operations across multiple platforms More

$25 AUD in 7 days
(10 Reviews)
4.2
STBadri

Dear Employer, Greeting! I am Microsoft certified professional and have completed '' 70-533 Implementing Microsoft Azure Infrastructure Solutions' certification. I have 6 years of experience and specialize in windo More

$30 AUD in 2 days
(2 Reviews)
2.8
masoodbari

Hi interested in this project Relevant Skills and Experience Excel Sql data analysis

$25 AUD in 1 day
(0 Reviews)
0.0
Expostech

Hi, I have heaps of experience in programming and will be able to create the script for you. I'd like to discuss some of the details with you so that the script meets your requirements. I look forward to working wi More

$20 AUD in 2 days
(0 Reviews)
0.0
Ldelcampo23

Hi, I am a System Administrator with 20 years of experience. I create few powershell in my daily tasks and I can help you with your project. Regards

$30 AUD in 7 days
(0 Reviews)
0.0
ratlangaytho

Hi, I’m an Devops Engineer with strong powershell scripting skill. Writing automation script is also one of my daily tasks . I guarantee can deliver this to you with no problem. Contact me and we can get it done. Thank More

$30 AUD in 2 days
(0 Reviews)
0.0
Bhopalmacro

I am very good at powershell and also in xls vba. I had gone through the requirements. As your final out put will be in xls, so I feel it would be better if we can do it in xls vba. I M ok with both of powershell and v More

$30 AUD in 3 days
(0 Reviews)
0.0
efedriko1234

Honest and reliable company delivering at a Low Cost complex and simple projects. Wide range of technologies and skills. Do not hesitate to contact us for any further inquiries.

$30 AUD in 7 days
(0 Reviews)
0.0
cmathon

Hi, I created the code based on the info you provided: <><> $SourceCSVFile = Import-Csv -LiteralPath $SourceCSVFilePath -Encoding UTF8 [[login to view URL]]$SoftLogCodeList = @() ForEach($SourceCSVFileRow in $ More

$20 AUD in 7 days
(0 Reviews)
0.0