Cerrado

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.

Habilidades: Microsoft, Powershell, Programación

Ver más: 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

Información del empleador:
( 4 comentarios ) Clayfield, Australia

Nº del proyecto: #23945395

9 freelancers están ofertando el promedio de $27 para este trabajo

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 Más

$25 AUD en 7 días
(10 comentarios)
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 Más

$30 AUD en 2 días
(2 comentarios)
2.8
masoodbari

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

$25 AUD en 1 día
(0 comentarios)
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 Más

$20 AUD en 2 días
(0 comentarios)
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 en 7 días
(0 comentarios)
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 Más

$30 AUD en 2 días
(0 comentarios)
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 Más

$30 AUD en 3 días
(0 comentarios)
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 en 7 días
(0 comentarios)
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 $ Más

$20 AUD en 7 días
(0 comentarios)
0.0