What's new
  • Welcome to PHCorner forums. Take a moment to sign up and gain unlimited access and extra privileges that guests are not entitled to, such as: All that and more! Registration is quick, simple and absolutely free. Join our community today!

Certificate of performance/commercial logs

powerup

Leecher
Joined
Feb 8, 2016
Messages
5
Reaction
2
Nasa Radio station po ako nagtatrabaho
Bali every month kailangan kong gawin yung certificate of performance

-ang laman po ng certificate of performance ay yung araw and mga oras na naiplay yung commercial ng isang product
Binabase po yun sa play logs na automatic generated araw-araw

Bali para magawa ko yung certificate of performance, kailangan ko pang isa-isahin yung txtfile ng logs, nad icheck kung anung oras naiplay, icopy and paste, masyadong mahang process and time comsuming

Ask ko lang po kung may code or apps na pwedeng magamit para mapadali ang trabaho ko
Salamat po sa sasagot


Update: sample ng logs and certificate of performance

Pasensya na po, wala pong internet pc, cellphone data lang kaya picture na lang
 

Attachments

Last edited:

purplehazee

Established
Hello sir!

Ask ko lang if ano format nung text file? or initial body nya? kahit wag mo na po i-send yung mismong laman nung commercial logs basta yung parang sample format nya lang :) gusto ko lang sana try gawin :D

thank you!
 
Comment

powerup

Leecher
Hello sir!

Ask ko lang if ano format nung text file? or initial body nya? kahit wag mo na po i-send yung mismong laman nung commercial logs basta yung parang sample format nya lang :) gusto ko lang sana try gawin :D

thank you!
Thank you po sa pagpansin ng poat ko sir

Updated na po yung post, may picture po ng logs and COP
Salamat po ulit
 
1 Comment
P
purplehazee
Uy hello sir, thanks sa update, try ko sya gawin ngayong week, busy din kasi ako sa work, pero update ko po kayo sa progress, thank you!
 

celeritas0725

Established
Gamit ka ng Excel. From excel, click mo yung You do not have permission to view the full content of this post. Log in or register now. na feature. Follow mo lang yung link. Once napaghiwahiwalay mo na yung date, time at commercial, lagyan mo ng header then gawa ka ng pivot table. Hindi same ng output sa nasa excel file pero yung data na kailangan mo ay available sa pivot.
 
Comment

powerup

Leecher
Gamit ka ng Excel. From excel, click mo yung You do not have permission to view the full content of this post. Log in or register now. na feature. Follow mo lang yung link. Once napaghiwahiwalay mo na yung date, time at commercial, lagyan mo ng header then gawa ka ng pivot table. Hindi same ng output sa nasa excel file pero yung data na kailangan mo ay available sa pivot.
thank you po sa pagsagot sir
sa ganitong method sir halos same lang din
need pa din magcopy paste paisa isa,
30 to 31 beses kong gagawin tong method na to

ganito po sana gusto kong mangyari sir

app siya na ganito ang gagawin

open folder
open 1st txtfile
find this text ("commercial") inside the file
log aired time to another txtfile
close file
loop
 
Comment

celeritas0725

Established
thank you po sa pagsagot sir
sa ganitong method sir halos same lang din
need pa din magcopy paste paisa isa,
30 to 31 beses kong gagawin tong method na to

ganito po sana gusto kong mangyari sir

app siya na ganito ang gagawin

open folder
open 1st txtfile
find this text ("commercial") inside the file
log aired time to another txtfile
close file
loop
Ah ok, noted. Kala ko yung pagplot sa excel file per time slot yung issue. Di ako marunong sa programming, wait natin yung iba. 😊
 
Comment

dee-u

Elite
Baka mas maganda kung magbigay ka ng pabuya sa makakagawa kasi napakalaking ginhawa sayo kung magiging automatic na ito. :)
 
Comment

powerup

Leecher
Baka mas maganda kung magbigay ka ng pabuya sa makakagawa kasi napakalaking ginhawa sayo kung magiging automatic na ito. :)
cge po sir, lakarin ko po sa management
sana maapprove nila
minimum lang po sahod ko dito sa province sir kaya medyo kapos po ako
 
Comment

m1k3y

Grasshopper
if pwede, i attach mo ung actual files (folder na may sample text files) and then yung sample output file na gusto mo.
 
Comment

purplehazee

Established
thank you po sa pagsagot sir
sa ganitong method sir halos same lang din
need pa din magcopy paste paisa isa,
30 to 31 beses kong gagawin tong method na to

ganito po sana gusto kong mangyari sir

app siya na ganito ang gagawin

open folder
open 1st txtfile
find this text ("commercial") inside the file
log aired time to another txtfile
close file
loop
hello sir, bali ganto ba yung magiging output nya?
1. Nag find ako ng Commercial Names under dun sa Logs nyo which is eto:
1618300769042.png

2. Then kinuha ko lang yung Commercial Name nya using Search Function, and included na din yung Date and Time sa result
1618300791648.png


3. Pwede din i log yung Date and Time from text file. :)


Reason for Update: Output pics hehe
 

Attachments

Last edited:
Comment

Online statistics

Members online
976
Guests online
1,240
Total visitors
2,216

Forum statistics

Threads
1,091,191
Messages
18,317,863
Members
1,525,443
Comments
1,194,813
Attachments
1,425,836
Profile posts
97,958
Top