The attached has a few hidden worksheets. I want to see three graphs; 1. Monthly 2. Quarterly 3. Year End. Use of bar graph, show a percentage line within the graph. Please provide instructions, graphs with % line. Items : 1. PM SCheduled/PM Completed ; %of PM; 2. CM Identified/CM Closed;%CM & 3. MAC 4. Helpdesk. I put in dummy data for Month of ExAugust and Quarter Tab. Note: I have created 3 graphs, but could not figure on how to add % line, bascially in the Aug data both
ASIA Work Order ReportAugust Data SiteCategoryWO ReceivedWO completedPercentage Author: Author: Completed percentageRemarks Author: Author: For not 100% compeleted percentage,pls make comments here BJCM Author: Author: • # of Corrective Maintenance Work Orders by site000% PM Author: Author: • # or Preventive Maintenance Work Orders Scheduled Author: Author: Completed percentage141141100% MAC Author: Author: • Move’s Add’s and Changes (# of Completed Moves) Author: Author: For not 100% compeleted percentage,pls make comments here11100% HTR Author: Author: • Hot Line Report: Service Requests by Site11441144100% TJCM77100% PM8888100% MAC33100% HTR9393100% CNBRCM1313100% PM4444100% MAC11100% HTR179179100% SGPCM44100% PM2424100% MAC000% HTR1919100% TWCM1414100% PM99100% MAC000% HTR118118100% INCM133133100% PM1111100% MAC000% HTR211211100% KOCM33100% PM2020100% MAC000% HTR164164100% HKCM000% PM33100% MAC000% HTR3737100% JPCM000%Not tracking in Aug. Will track from Sep. PM000% MAC000% HTR000% Sub-TotalCM174174100% PM340340100% MAC55100% HT19651965100% Total24842484100% Raw Data Work Order Record Since 1 Aug 2012 ItemWork Order #DescriptionTop 10 TypeQtyTypeDateRemarks 1120801Fan Coil Unit Maintenance for Aug, 2012office funiture / equipment1PM1-Aug-12 2120802Water Filter Replacement Aug, 2012office funiture / equipment1PM1-Aug-12 3120803water refillwater 1HTR1-Aug-12 4120804light tube replacementlight 1HTR1-Aug-12 5120805water refillwater 1HTR2-Aug-12 6120806water refillwater 2HTR3-Aug-12 7120807light tube replacementlight 1HTR3-Aug-12 8120808water refillwater 2HTR6-Aug-12 9120809water refillwater 1HTR7-Aug-12 10120810water refillwater 1HTR8-Aug-12 11120811water refillwater 1HTR9-Aug-12 12120812light tube replacementlight 2HTR9-Aug-12 13120813water refillwater 1HTR10-Aug-12 14120814water refillwater 1HTR13-Aug-12 15120815light tube replacementlight 1HTR13-Aug-12 16120816water refillwater 1HTR14-Aug-12 17120817light tube replacementlight 3HTR14-Aug-12 18120818water refillwater 2HTR15-Aug-12 19120819light tube replacementlight 2HTR15-Aug-12 20120820garbage (JCI)miscellaneous1HTR15-Aug-12 21120821water refillwater 1HTR16-Aug-12 22120822light tube replacementlight 2HTR16-Aug-12 23120823water refillwater 1HTR17-Aug-12 24120824water refillwater 3HTR20-Aug-12 25120825light tube replacementlight 3HTR20-Aug-12 26120826Power Off (Reception Area) - Repair electrical1HTR20-Aug-12 27120827water refillwater 1HTR21-Aug-12 31120828water refillwater 1HTR22-Aug-12 33120829water refillwater 2HTR23-Aug-12 34120830light tube replacementlight 1HTR23-Aug-12 36120831water refillwater 1HTR24-Aug-12 37120832light tube replacementlight 2HTR24-Aug-12 38120833water refillwater 1HTR27-Aug-12 39120834light tube replacementlight 1HTR27-Aug-12 40120835water refillwater 1HTR28-Aug-12 41120836light tube replacementlight 1HTR28-Aug-12 42120837Fan Coil Unit Maintenance for Sep, 2012office funiture / equipment1PM28-Aug-12 43120838light tube replacementlight 1HTR29-Aug-12 44120839water refillwater 1HTR30-Aug-12 45120840water refillwater 1HTR31-Aug-12 HTR-• # of Corrective Maintenance Work Orders by site PM-• # or Preventive Maintenance Work Orders Scheduled MAC-• Move’s Add’s and Changes (# of Completed Moves) HTR- Hot Line Report: Service Requests by Site water refillelectrical light tube replacementmiscellaneous water light office funiture / equipment Door / lock July PM (Maximo or Manual SpreadsheetCM (Comes through Help Desk or Identified by TeamMAC (Requests through planning or End User Calls/Emails/ etc CountryLocationScheduledCompleted%IdentifiedClosed%Moved ProcessedHelpdesk ChinaTianjin757093%120120100%2487 ChinaBeijing ChinaChina Branch ChinaTaiwan HongKongHongKong IndiaIndia JapanJapan KoreaKorea SingaporeSingapore TaiwanTaiwan Factory TaiwanTaiwan Office EnglandZUK40-Basingstoke, England - Chineham Park Moto 1 FranceZFR29-Saclay, France GermanyZWG85-Flensburg, Germany GermanyZWG87-Idstein Germany GermanyZWG91-Munich, Germany PolandZPL17-Warsaw, Poland (SetJam) RussiaZRU17-St Petersburg, Russia RussiaZRU18-Moscow, Russia South AfriciaZSA18-Woodlands, South Africa SpainZES14-Madrid, Spain SwedenZSE18-Linkoping, Sweden SwedenZSE24-Norrkoping, Sweden SwedenZSE25-Linkoping, Sweden SwedenZSE29-Linkoping, Sweden Teknikringen 2 TurkeyZTU06-Istanbul, Turkey Aug PM (Maximo or Manual SpreadsheetPM (Maximo or Manual SpreadsheetCM (Comes through Help Desk or Identified by TeamMAC (Requests through planning or End User Calls/Emails/ etc CountryLocationScheduledCompleted%IdentifiedClosed%Moved ProcessedHelpdesk ChinaTianjin8888100%77100%393 ChinaBeijing141141100%000%1114 ChinaChina Branch4444100%1313100%1179 ChinaTaiwan99100%1414100%0118 HongKongHongKong 33100%000%037 IndiaIndia1111100%133133100%0211 JapanJapan 000%000%00 KoreaKorea 2020100%33100%0164 SingaporeSingapore2424100%44100%019 TaiwanTaiwan Factory000%000%00 TaiwanTaiwan Office000%000%00 EnglandZUK40-Basingstoke - Chineham Park Moto 1 FranceZFR29-Saclay GermanyZWG85-Flensburg GermanyZWG87-Idstein GermanyZWG91-Munich PolandZPL17-Warsaw RussiaZRU17-St Petersburg RussiaZRU18-Moscow South AfriciaZSA18-Woodlands SpainZES14-Madrid, Spain SwedenZSE18-Linkoping SwedenZSE24-Norrkoping SwedenZSE25-Linkoping SwedenZSE29-Linkoping-Teknikringen 2 TurkeyZTU06-Istanbul Total340340100%174174100%5935 Sept PM (Maximo or Manual SpreadsheetCM (Comes through Help Desk or Identified by TeamMAC (Requests through planning or End User Calls/Emails/ etc CountryLocationScheduledCompleted%IdentifiedClosed%Moved ProcessedHelpdesk ChinaTianjinERROR:#DIV/0!ERROR:#DIV/0! ChinaBeijingERROR:#DIV/0!ERROR:#DIV/0! ChinaChina BranchERROR:#DIV/0!ERROR:#DIV/0! ChinaTaiwanERROR:#DIV/0!ERROR:#DIV/0! HongKongHongKong ERROR:#DIV/0!ERROR:#DIV/0! IndiaIndiaERROR:#DIV/0!ERROR:#DIV/0! JapanJapan ERROR:#DIV/0!ERROR:#DIV/0! KoreaKorea ERROR:#DIV/0!ERROR:#DIV/0! SingaporeSingaporeERROR:#DIV/0!ERROR:#DIV/0! TaiwanTaiwan FactoryERROR:#DIV/0!ERROR:#DIV/0! TaiwanTaiwan OfficeERROR:#DIV/0!ERROR:#DIV/0! EnglandZUK40-Basingstoke, England - Chineham Park Moto 1ERROR:#DIV/0!ERROR:#DIV/0! FranceZFR29-Saclay, FranceERROR:#DIV/0!ERROR:#DIV/0! GermanyZWG85-Flensburg, GermanyERROR:#DIV/0!ERROR:#DIV/0! GermanyZWG87-Idstein GermanyERROR:#DIV/0!ERROR:#DIV/0! GermanyZWG91-Munich, GermanyERROR:#DIV/0!ERROR:#DIV/0! PolandZPL17-Warsaw, Poland (SetJam) ERROR:#DIV/0!ERROR:#DIV/0! RussiaZRU17-St Petersburg, RussiaERROR:#DIV/0!ERROR:#DIV/0! RussiaZRU18-Moscow, RussiaERROR:#DIV/0!ERROR:#DIV/0! South AfriciaZSA18-Woodlands, South AfricaERROR:#DIV/0!ERROR:#DIV/0! SpainZES14-Madrid, SpainERROR:#DIV/0!ERROR:#DIV/0! SwedenZSE18-Linkoping, SwedenERROR:#DIV/0!ERROR:#DIV/0! SwedenZSE24-Norrkoping, SwedenERROR:#DIV/0!ERROR:#DIV/0! SwedenZSE25-Linkoping, SwedenERROR:#DIV/0!ERROR:#DIV/0! SwedenZSE29-Linkoping, Sweden Teknikringen 2ERROR:#DIV/0!ERROR:#DIV/0! TurkeyZTU06-Istanbul, TurkeyERROR:#DIV/0!ERROR:#DIV/0! EX Aug (2) PM (Maximo or Manual SpreadsheetPM (Maximo or Manual SpreadsheetCM (Comes through Help Desk or Identified by TeamMAC (Requests through planning or End User Calls/Emails/ etcPM (Maximo or Manual SpreadsheetPM (Maximo or Manual Spreadsheet PM (Maximo or Manual SpreadsheetPM (Maximo or Manual SpreadsheetCM (Comes through Help Desk or Identified by TeamCM (Comes through Help Desk or Identified by TeamMAC (Requests through planning or End User Calls/Emails/ etc Site#CountryLocationPM ScheduledPM CompletedPM %CM IdentifiedCM ClosedCM % MAC Moved ProcessedHelpdesk reportsSite#CountryLocationPM ScheduledPM CompletedCM IdentifiedCM ClosedMAC Moved ProcessedHelpdesk reports ChinaTianjin8888100%77100%393ChinaTianjin888877393 ChinaBeijing141141100%000%1114ChinaBeijing141141001114 ChinaChina Branch4444100%1313100%1179SingaporeSingapore242444019 HongKonHongKong 33100%000%037ChinaChina Branch444413131179 IndiaIndia1111100%133133100%0211TwainTaiwan9914140118 JapanJapan 000%000%00IndiaIndia11111331330211 KoreaKorea 2020100%33100%0164KoreaKorea 2020330164 SingaporeSingapore2424100%44100%019HongKonHongKong 3300037 TwainTaiwan Factory000%000%00JapanJapan 000000 TwainTaiwan Office000%000%00ZFR29FranceSaclay535320520568 TwainTaiwan99100%1414100%0118ZES14SpainMadrid2211247 ZES14SpainMadrid5353100%205205100%68ZPL17PolandWarsaw77221105 ZFR29FranceSaclay22100%11100%247ZRU17RussiaSt Petersburg333333057 ZPL17PolandWarsaw77100%22100%1105ZRU18RussiaMoscow151522013 ZRU17RussiaSt Petersburg3333100%33100%057ZSA18South AfriciaWoodlands2020111100 ZRU18RussiaMoscow1515100%22100%013ZSE18SwedenLinkoping11116565423 ZSA18South AfriciaWoodlands2020100%11100%1100ZSE24SwedenNorrkoping1010772215 ZSE18SwedenLinkoping1111100%6565100%423ZSE25SwedenLinkoping11111051051199 ZSE24SwedenNorrkoping1010100%77100%2215ZSE29SwedenLinkoping-Teknikringen 222229999145 ZSE25SwedenLinkoping1111100%105105100%1199ZTU06TurkeyIstanbul444413130115 ZSE29SwedenLinkoping-Teknikringen 22222100%9999100%145ZUK40EnglandBasingstoke - Chineham Park Moto 156562222288 ZTU06TurkeyIstanbul4444100%1313100%0115ZWG85GermanyFlensburg9910101056 ZUK40EnglandBasingstoke - Chineham Park Moto 15656100%2222100%288ZWG87GermanyIdstein 3355225 ZWG85GermanyFlensburg99100%1010100%1056ZWG91GermanyMunich22333188 ZWG87GermanyIdstein 33100%55100%225Total638638717717402219 ZWG91GermanyMunich22100%33100%3188 Total638638100%717717100%402219LocationPM ScheduledPM CompletedCM IdentifiedCM ClosedMAC Moved ProcessedHelpdesk reports Total638638717717402219 TotalPM ScheduledPM CompletedCM IdentifiedCM ClosedMAC Moved ProcessedHelpdesk reports638638717717402219 Quarter 3 PM (Maximo or Manual SpreadsheetCM (Comes through Help Desk or Identified by TeamMAC (Requests through planning or End User Calls/Emails/ etc CountryLocationPM ScheduledPM CompletedCM IdentifiedCM Closed MAC Moved ProcessedHelpdesk reports ChinaTianjin16315815812727180 ChinaBeijing88888801114 SingaporeSingapore888888131179 TaiwanTaiwan Factory8888880037 TaiwanTaiwan Office8888881330211 ChinaChina Branch888888000 ChinaTaiwan88888830164 IndiaIndia8888884019 KoreaKorea 888888000 HongKongHongKong 888888000 JapanJapan 888888140118 FranceZFR29-Saclay, France88888820568 SwedenZSE18-Linkoping, Sweden8888881247 GermanyZWG85-Flensburg, Germany88888821105 GermanyZWG87-Idstein Germany8888883057 GermanyZWG91-Munich, Germany8888882013 PolandZPL17-Warsaw, Poland (SetJam) 88888811100 RussiaZRU17-St Petersburg, Russia88888865423 RussiaZRU18-Moscow, Russia88888872215 South AfriciaZSA18-Woodlands, South Africa8888881051199 SpainZES14-Madrid, Spain88888899145 SwedenZSE24-Norrkoping, Sweden888888130115 SwedenZSE25-Linkoping, Sweden88888822288 SwedenZSE29-Linkoping, Sweden Teknikringen 2888888101056 TurkeyZTU06-Istanbul, Turkey8888885225 EnglandZUK40-Basingstoke, England - Chineham Park Moto 188888833188 Total236323582358837642306 QuartersPM ScheduledPM CompletedCM IdentifiedCM Closed MAC Moved ProcessedHelpdesk reports Q11131751126499351030 Q2487487320320181987 Q3236323582358837642306 Q47657659329321384891 Total Year End 2012 Q1PM ScheduledPM CompletedCM IdentifiedCM Closed MAC Moved ProcessedHelpdesk reports1131751126499351030Q2PM ScheduledPM CompletedCM IdentifiedCM Closed MAC Moved ProcessedHelpdesk reports487487320320181987Q3PM ScheduledPM CompletedCM IdentifiedCM Closed MAC Moved ProcessedHelpdesk reports236323582358837642306Q4PM ScheduledPM CompletedCM IdentifiedCM Closed MAC Moved ProcessedHelpdesk reports7657659329321384891Total Quarter 3 2012 Q3PM ScheduledPM CompletedCM IdentifiedCM Closed MAC Moved ProcessedHelpdesk reports236323582358837642306