{"id":7918,"date":"2022-06-15t13:15:12","date_gmt":"2022-06-15t17:15:12","guid":{"rendered":"\/\/www.deco-dalles.com\/?p=1812"},"modified":"2024-04-03t11:39:29","modified_gmt":"2024-04-03t15:39:29","slug":"export-p6-resource-assignment-data-excel","status":"publish","type":"post","link":"\/\/www.deco-dalles.com\/export-p6-resource-assignment-data-excel\/","title":{"rendered":"one trick to export p6 resource assignment data to excel"},"content":{"rendered":"

as you know primavera p6 has a lack of graphical features so often we schedulers need to export everything to other software packages (mostly excel) to produce an understandable schedule and graphs. i always had a problem when i export p6 resource assignment<\/a> data to excel with the standard exporting feature on p6 until i found a way to leverage the reports feature.<\/p>\n

here you can use the current screen to develop a report and instead of making it a text report, we can have it produce an excel report<\/a>. this tutorial is good for anyone who wants to develop better resource curves<\/a> and analyze resource assignments.<\/p>\n

so let’s go it.<\/p>\n

export p6 resource assignments to excel with the help of reports<\/h2>\n

step 1 – select the assignment tab<\/h2>\n

\"step<\/p>\n

when you opened the desired project, on the left hand side, you can choose different options. in this case, to see the assignments, you need to select the aasignment tab<\/p>\n

step 2 – resource assignments page<\/h2>\n

\"step<\/p>\n

in this table, we have a resource assignments table on the left hand side and time-distributed data on the right. we can modify these tables in some different ways. i describe my way below:<\/p>\n

step 3 – filter the 世界杯时间比赛时间 <\/h2>\n

\"step<\/p>\n

right-click on the left table and choose filters.<\/p>\n

\"step<\/p>\n

in the filters screen write the following formula:\u00a0\u00a0<where budgeted units\/time is greater than 0><\/strong>.<\/p>\n

in this way you will have only the 世界杯时间比赛时间 that have assignment not all the 世界杯时间比赛时间 that has been defined.<\/p>\n

step 4 – choose spreadsheet fields<\/h2>\n

\"step<\/p>\n

right-click on the right hand table (spreadsheet) and from the menu choose spreadsheet fields<\/strong> and then customize<\/strong>.<\/p>\n

\"step<\/p>\n

in the open menu we have two categories of columns, cumulative and time interval. we\u2019ll select cum. budgeted units<\/strong> from cumulative and budgeted units<\/strong> from the time interval – in this way we will have data for each month separately and cumulatively.<\/p>\n

you can select any kind of data for your report purposes. for this report we do not need any specific column on the left hand table.<\/p>\n

what we need is just the resource name but it is visible that you can add any specific column to that table whenever is needed according to your report requirements.<\/p>\n

now we have data to develop s-curves. now we focus on exporting these data to excel.<\/p>\n

so here’s where the trick part starts. rather than use p6 export to excel feature, we will export p6<\/a> resource assignment data with the help of p6’s internal reporting system.<\/p>\n

step 5 – run the report wizard<\/h2>\n

\"step<\/p>\n

go to tools menu and select report wizard.<\/p>\n

step 6 – use current screen<\/h2>\n

\"step<\/p>\n

in the report wizard menu, select \u201cuse current screen\u201d radio button and hit next.<\/p>\n

step 7 – use time distributed data<\/h2>\n

\"step
\nin this menu tick \u201c time distributed option\u201d and\u00a0 below it select\u00a0 \u201c activity 世界杯时间比赛时间 and role assignment\u201d and hit next.<\/p>\n

step 8 – finishing the report<\/h2>\n

in the following screens, you can simply click next.<\/p>\n

\"step<\/p>\n

\"step<\/p>\n

on this screen you can give a name to your report.<\/p>\n

\"step<\/p>\n

on this screen click \u201crun report\u201d<\/strong>.<\/p>\n

step 9 – change the format of report<\/h2>\n

\"step<\/p>\n

select the \u201cascii text file\u201d<\/strong> radio button and make sure that the \u201cview file when done\u201d<\/strong> box is selected and click ok.<\/p>\n

now you have an export of the p6 resource assignment data in an excel file as shown in the following screenshot:<\/p>\n

\"open<\/p>\n

wrap up<\/h2>\n

the reason that we do all of these efforts to export p6 resource assignment data to excel is as follows:<\/p>\n

    \n
  1. we do not have too much graphical features in p6 so we cannot develop perfect managerial reports in primavera p6 alone.<\/li>\n
  2. resource curves in primavera p6 do not show the percentage progress and monthly increments and this is not good when you look at a curve from a project manager’s perspective.<\/li>\n
  3. if you want to calculate the manpower for each, in p6 you have to divide all man hours for every month to an exact number (for example 208) but as you know the working hours in each month is different because we have different for each month. consequently we will not have a perfect estimation of manpower needed for each month in p6 while we can have an exact estimation in excel.<\/li>\n<\/ol>\n

    in this way you can develop s-curves<\/a> with the use of excel easily.<\/p>\n

    leave us a comment<\/h2>\n

    what do you think about this method of export p6 resource assignment data to excel?<\/p>\n

    what has worked for you in the past?<\/p>\n

    let us know by leaving a comment below.<\/p>\n

    <\/p>\n","protected":false},"excerpt":{"rendered":"

    as you know primavera p6 has a lack of graphical features so often we schedulers need to export everything to…<\/p>\n","protected":false},"author":47,"featured_media":54504,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"content-type":"","_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"footnotes":""},"categories":[26,55,215],"tags":[],"content-topics":[],"class_list":["post-7918","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-primavera-p6-tutorials","category-resource-management"],"acf":[],"yoast_head":"\none trick to export p6 resource assignment data to excel<\/title>\n<meta name=\"description\" content=\"learn the steps to export p6 resource assignment data to excel so you can build s-curves or perform other analysis in excel.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"\/\/www.deco-dalles.com\/export-p6-resource-assignment-data-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_us\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"one trick to export p6 resource assignment data to excel\" \/>\n<meta property=\"og:description\" content=\"learn the steps to export p6 resource assignment data to excel so you can build s-curves or perform other analysis in excel.\" \/>\n<meta property=\"og:url\" content=\"\/\/www.deco-dalles.com\/export-p6-resource-assignment-data-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"世界杯2022亚洲比赛时间 \" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/planacademy\" \/>\n<meta property=\"article:published_time\" content=\"2022-06-15t17:15:12+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-03t15:39:29+00:00\" \/>\n<meta property=\"og:image\" content=\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2022\/06\/manager-industrial-engineer-using-tablet-check-control-automation-robot-arms-machine-scaled.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"2560\" \/>\n\t<meta property=\"og:image:height\" content=\"1115\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"kazem salehiyan\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@planacademy\" \/>\n<meta name=\"twitter:site\" content=\"@planacademy\" \/>\n<meta name=\"twitter:label1\" content=\"written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"kazem salehiyan\" \/>\n\t<meta name=\"twitter:label2\" content=\"est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"article\",\"@id\":\"\/\/www.deco-dalles.com\/export-p6-resource-assignment-data-excel\/#article\",\"ispartof\":{\"@id\":\"\/\/www.deco-dalles.com\/export-p6-resource-assignment-data-excel\/\"},\"author\":{\"name\":\"kazem salehiyan\",\"@id\":\"\/\/www.deco-dalles.com\/#\/schema\/person\/919f7169bc407959b37d46ef2d8fab2a\"},\"headline\":\"one trick to export p6 resource assignment data to excel\",\"datepublished\":\"2022-06-15t17:15:12+00:00\",\"datemodified\":\"2024-04-03t15:39:29+00:00\",\"mainentityofpage\":{\"@id\":\"\/\/www.deco-dalles.com\/export-p6-resource-assignment-data-excel\/\"},\"wordcount\":759,\"publisher\":{\"@id\":\"\/\/www.deco-dalles.com\/#organization\"},\"image\":{\"@id\":\"\/\/www.deco-dalles.com\/export-p6-resource-assignment-data-excel\/#primaryimage\"},\"thumbnailurl\":\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2022\/06\/manager-industrial-engineer-using-tablet-check-control-automation-robot-arms-machine-scaled.jpg\",\"articlesection\":[\"excel\",\"primavera p6 tutorials\",\"resource management\"],\"inlanguage\":\"en-ca\"},{\"@type\":\"webpage\",\"@id\":\"\/\/www.deco-dalles.com\/export-p6-resource-assignment-data-excel\/\",\"url\":\"\/\/www.deco-dalles.com\/export-p6-resource-assignment-data-excel\/\",\"name\":\"one trick to export p6 resource assignment data to excel\",\"ispartof\":{\"@id\":\"\/\/www.deco-dalles.com\/#website\"},\"primaryimageofpage\":{\"@id\":\"\/\/www.deco-dalles.com\/export-p6-resource-assignment-data-excel\/#primaryimage\"},\"image\":{\"@id\":\"\/\/www.deco-dalles.com\/export-p6-resource-assignment-data-excel\/#primaryimage\"},\"thumbnailurl\":\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2022\/06\/manager-industrial-engineer-using-tablet-check-control-automation-robot-arms-machine-scaled.jpg\",\"datepublished\":\"2022-06-15t17:15:12+00:00\",\"datemodified\":\"2024-04-03t15:39:29+00:00\",\"description\":\"learn the steps to export p6 resource assignment data to excel so you can build s-curves or perform other analysis in excel.\",\"breadcrumb\":{\"@id\":\"\/\/www.deco-dalles.com\/export-p6-resource-assignment-data-excel\/#breadcrumb\"},\"inlanguage\":\"en-ca\",\"potentialaction\":[{\"@type\":\"readaction\",\"target\":[\"\/\/www.deco-dalles.com\/export-p6-resource-assignment-data-excel\/\"]}]},{\"@type\":\"imageobject\",\"inlanguage\":\"en-ca\",\"@id\":\"\/\/www.deco-dalles.com\/export-p6-resource-assignment-data-excel\/#primaryimage\",\"url\":\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2022\/06\/manager-industrial-engineer-using-tablet-check-control-automation-robot-arms-machine-scaled.jpg\",\"contenturl\":\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2022\/06\/manager-industrial-engineer-using-tablet-check-control-automation-robot-arms-machine-scaled.jpg\",\"width\":2560,\"height\":1115},{\"@type\":\"breadcrumblist\",\"@id\":\"\/\/www.deco-dalles.com\/export-p6-resource-assignment-data-excel\/#breadcrumb\",\"itemlistelement\":[{\"@type\":\"listitem\",\"position\":1,\"name\":\"blog\",\"item\":\"\/\/www.deco-dalles.com\/\"},{\"@type\":\"listitem\",\"position\":2,\"name\":\"one trick to export p6 resource assignment data to excel\"}]},{\"@type\":\"website\",\"@id\":\"\/\/www.deco-dalles.com\/#website\",\"url\":\"\/\/www.deco-dalles.com\/\",\"name\":\"世界杯2022亚洲比赛时间 \",\"description\":\"project controls training & courses\",\"publisher\":{\"@id\":\"\/\/www.deco-dalles.com\/#organization\"},\"potentialaction\":[{\"@type\":\"searchaction\",\"target\":{\"@type\":\"entrypoint\",\"urltemplate\":\"\/\/www.deco-dalles.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inlanguage\":\"en-ca\"},{\"@type\":\"organization\",\"@id\":\"\/\/www.deco-dalles.com\/#organization\",\"name\":\"世界杯2022亚洲比赛时间 \",\"url\":\"\/\/www.deco-dalles.com\/\",\"logo\":{\"@type\":\"imageobject\",\"inlanguage\":\"en-ca\",\"@id\":\"\/\/www.deco-dalles.com\/#\/schema\/logo\/image\/\",\"url\":\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2023\/11\/cropped-pa-logo-color.png\",\"contenturl\":\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2023\/11\/cropped-pa-logo-color.png\",\"width\":500,\"height\":159,\"caption\":\"世界杯2022亚洲比赛时间 \"},\"image\":{\"@id\":\"\/\/www.deco-dalles.com\/#\/schema\/logo\/image\/\"},\"sameas\":[\"https:\/\/www.facebook.com\/planacademy\",\"https:\/\/x.com\/planacademy\",\"https:\/\/www.linkedin.com\/company\/plan-academy\",\"https:\/\/www.youtube.com\/planacademy\"]},{\"@type\":\"person\",\"@id\":\"\/\/www.deco-dalles.com\/#\/schema\/person\/919f7169bc407959b37d46ef2d8fab2a\",\"name\":\"kazem salehiyan\",\"image\":{\"@type\":\"imageobject\",\"inlanguage\":\"en-ca\",\"@id\":\"\/\/www.deco-dalles.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/1b749cc5038a918ef4f115106f1dec40?s=96&d=mm&r=pg\",\"contenturl\":\"https:\/\/secure.gravatar.com\/avatar\/1b749cc5038a918ef4f115106f1dec40?s=96&d=mm&r=pg\",\"caption\":\"kazem salehiyan\"},\"description\":\"i started working as a scheduler 4 years ago. i have been working for different companies in different industries since then. i am writing tutorials because i believe knowledge and experience should be shared.i do like watching historical documentaries and reading novels.\",\"sameas\":[\"http:\/\/www.linkedin.com\/pub\/kazem-salehian\/45\/967\/8a5\"],\"url\":\"\/\/www.deco-dalles.com\/author\/ksalehiyan\/\"}]}<\/script>\n<!-- \/ yoast seo premium plugin. -->","yoast_head_json":{"title":"one trick to export p6 resource assignment data to excel","description":"learn the steps to export p6 resource assignment data to excel so you can build s-curves or perform other analysis in excel.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"\/\/www.deco-dalles.com\/export-p6-resource-assignment-data-excel\/","og_locale":"en_us","og_type":"article","og_title":"one trick to export p6 resource assignment data to excel","og_description":"learn the steps to export p6 resource assignment data to excel so you can build s-curves or perform other analysis in excel.","og_url":"\/\/www.deco-dalles.com\/export-p6-resource-assignment-data-excel\/","og_site_name":"世界杯2022亚洲比赛时间 ","article_publisher":"https:\/\/www.facebook.com\/planacademy","article_published_time":"2022-06-15t17:15:12+00:00","article_modified_time":"2024-04-03t15:39:29+00:00","og_image":[{"width":2560,"height":1115,"url":"\/\/www.deco-dalles.com\/wp-content\/uploads\/2022\/06\/manager-industrial-engineer-using-tablet-check-control-automation-robot-arms-machine-scaled.jpg","type":"image\/jpeg"}],"author":"kazem salehiyan","twitter_card":"summary_large_image","twitter_creator":"@planacademy","twitter_site":"@planacademy","twitter_misc":{"written by":"kazem salehiyan","est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"article","@id":"\/\/www.deco-dalles.com\/export-p6-resource-assignment-data-excel\/#article","ispartof":{"@id":"\/\/www.deco-dalles.com\/export-p6-resource-assignment-data-excel\/"},"author":{"name":"kazem salehiyan","@id":"\/\/www.deco-dalles.com\/#\/schema\/person\/919f7169bc407959b37d46ef2d8fab2a"},"headline":"one trick to export p6 resource assignment data to excel","datepublished":"2022-06-15t17:15:12+00:00","datemodified":"2024-04-03t15:39:29+00:00","mainentityofpage":{"@id":"\/\/www.deco-dalles.com\/export-p6-resource-assignment-data-excel\/"},"wordcount":759,"publisher":{"@id":"\/\/www.deco-dalles.com\/#organization"},"image":{"@id":"\/\/www.deco-dalles.com\/export-p6-resource-assignment-data-excel\/#primaryimage"},"thumbnailurl":"\/\/www.deco-dalles.com\/wp-content\/uploads\/2022\/06\/manager-industrial-engineer-using-tablet-check-control-automation-robot-arms-machine-scaled.jpg","articlesection":["excel","primavera p6 tutorials","resource management"],"inlanguage":"en-ca"},{"@type":"webpage","@id":"\/\/www.deco-dalles.com\/export-p6-resource-assignment-data-excel\/","url":"\/\/www.deco-dalles.com\/export-p6-resource-assignment-data-excel\/","name":"one trick to export p6 resource assignment data to excel","ispartof":{"@id":"\/\/www.deco-dalles.com\/#website"},"primaryimageofpage":{"@id":"\/\/www.deco-dalles.com\/export-p6-resource-assignment-data-excel\/#primaryimage"},"image":{"@id":"\/\/www.deco-dalles.com\/export-p6-resource-assignment-data-excel\/#primaryimage"},"thumbnailurl":"\/\/www.deco-dalles.com\/wp-content\/uploads\/2022\/06\/manager-industrial-engineer-using-tablet-check-control-automation-robot-arms-machine-scaled.jpg","datepublished":"2022-06-15t17:15:12+00:00","datemodified":"2024-04-03t15:39:29+00:00","description":"learn the steps to export p6 resource assignment data to excel so you can build s-curves or perform other analysis in excel.","breadcrumb":{"@id":"\/\/www.deco-dalles.com\/export-p6-resource-assignment-data-excel\/#breadcrumb"},"inlanguage":"en-ca","potentialaction":[{"@type":"readaction","target":["\/\/www.deco-dalles.com\/export-p6-resource-assignment-data-excel\/"]}]},{"@type":"imageobject","inlanguage":"en-ca","@id":"\/\/www.deco-dalles.com\/export-p6-resource-assignment-data-excel\/#primaryimage","url":"\/\/www.deco-dalles.com\/wp-content\/uploads\/2022\/06\/manager-industrial-engineer-using-tablet-check-control-automation-robot-arms-machine-scaled.jpg","contenturl":"\/\/www.deco-dalles.com\/wp-content\/uploads\/2022\/06\/manager-industrial-engineer-using-tablet-check-control-automation-robot-arms-machine-scaled.jpg","width":2560,"height":1115},{"@type":"breadcrumblist","@id":"\/\/www.deco-dalles.com\/export-p6-resource-assignment-data-excel\/#breadcrumb","itemlistelement":[{"@type":"listitem","position":1,"name":"blog","item":"\/\/www.deco-dalles.com\/"},{"@type":"listitem","position":2,"name":"one trick to export p6 resource assignment data to excel"}]},{"@type":"website","@id":"\/\/www.deco-dalles.com\/#website","url":"\/\/www.deco-dalles.com\/","name":"世界杯2022亚洲比赛时间 ","description":"project controls training & courses","publisher":{"@id":"\/\/www.deco-dalles.com\/#organization"},"potentialaction":[{"@type":"searchaction","target":{"@type":"entrypoint","urltemplate":"\/\/www.deco-dalles.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inlanguage":"en-ca"},{"@type":"organization","@id":"\/\/www.deco-dalles.com\/#organization","name":"世界杯2022亚洲比赛时间 ","url":"\/\/www.deco-dalles.com\/","logo":{"@type":"imageobject","inlanguage":"en-ca","@id":"\/\/www.deco-dalles.com\/#\/schema\/logo\/image\/","url":"\/\/www.deco-dalles.com\/wp-content\/uploads\/2023\/11\/cropped-pa-logo-color.png","contenturl":"\/\/www.deco-dalles.com\/wp-content\/uploads\/2023\/11\/cropped-pa-logo-color.png","width":500,"height":159,"caption":"世界杯2022亚洲比赛时间 "},"image":{"@id":"\/\/www.deco-dalles.com\/#\/schema\/logo\/image\/"},"sameas":["https:\/\/www.facebook.com\/planacademy","https:\/\/x.com\/planacademy","https:\/\/www.linkedin.com\/company\/plan-academy","https:\/\/www.youtube.com\/planacademy"]},{"@type":"person","@id":"\/\/www.deco-dalles.com\/#\/schema\/person\/919f7169bc407959b37d46ef2d8fab2a","name":"kazem salehiyan","image":{"@type":"imageobject","inlanguage":"en-ca","@id":"\/\/www.deco-dalles.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/1b749cc5038a918ef4f115106f1dec40?s=96&d=mm&r=pg","contenturl":"https:\/\/secure.gravatar.com\/avatar\/1b749cc5038a918ef4f115106f1dec40?s=96&d=mm&r=pg","caption":"kazem salehiyan"},"description":"i started working as a scheduler 4 years ago. i have been working for different companies in different industries since then. i am writing tutorials because i believe knowledge and experience should be shared.i do like watching historical documentaries and reading novels.","sameas":["http:\/\/www.linkedin.com\/pub\/kazem-salehian\/45\/967\/8a5"],"url":"\/\/www.deco-dalles.com\/author\/ksalehiyan\/"}]}},"_links":{"self":[{"href":"\/\/www.deco-dalles.com\/wp-json\/wp\/v2\/posts\/7918"}],"collection":[{"href":"\/\/www.deco-dalles.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"\/\/www.deco-dalles.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"\/\/www.deco-dalles.com\/wp-json\/wp\/v2\/users\/47"}],"replies":[{"embeddable":true,"href":"\/\/www.deco-dalles.com\/wp-json\/wp\/v2\/comments?post=7918"}],"version-history":[{"count":0,"href":"\/\/www.deco-dalles.com\/wp-json\/wp\/v2\/posts\/7918\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"\/\/www.deco-dalles.com\/wp-json\/wp\/v2\/media\/54504"}],"wp:attachment":[{"href":"\/\/www.deco-dalles.com\/wp-json\/wp\/v2\/media?parent=7918"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"\/\/www.deco-dalles.com\/wp-json\/wp\/v2\/categories?post=7918"},{"taxonomy":"post_tag","embeddable":true,"href":"\/\/www.deco-dalles.com\/wp-json\/wp\/v2\/tags?post=7918"},{"taxonomy":"content-topics","embeddable":true,"href":"\/\/www.deco-dalles.com\/wp-json\/wp\/v2\/content-topics?post=7918"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}