{"id":10100,"date":"2022-09-22T07:20:29","date_gmt":"2022-09-22T01:50:29","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-need-help-in-vba\/"},"modified":"2022-09-22T07:20:29","modified_gmt":"2022-09-22T01:50:29","slug":"solved-need-help-in-vba","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-need-help-in-vba\/","title":{"rendered":"[Solved] Need help in VBA"},"content":{"rendered":"

[ad_1]
\n<\/p>\n

\n
\n
<\/div>\n
\n
\n

Count of Shift Combinations within a List of 100 continuous Shifts<\/strong><\/p>\n

This answer is a solution to the revised<\/strong> requirements of the asker.<\/em><\/p>\n

I\u2019m posting this answer as the asker changed the original requirements, and therefore requiring a different solution than the first posted. I decide to leave both solutions for the benefit of other users that might face any of these situations.<\/em><\/p>\n

Requirements<\/strong> : There are 11 Shifts named from a<\/code> to k<\/code> we have a list of 100 turns taken by each shift. The objective is to count how many shift combinations are in the list<\/strong> i.e. How many times the Shift changes from: a<\/code> to b<\/code> and<\/em> b<\/code> to a<\/code>, a<\/code> to c<\/code> and<\/em> c<\/code> to a<\/code>, \u2026 j<\/code> to k<\/code> and<\/em> k<\/code> to j<\/code>. Shifts are continual i.e. Row 2<\/code> is the continuation of Row 1<\/code> and Cell 1<\/code> is the continuation of Cell 100<\/code>.<\/p>\n

Assumptions<\/strong> : The list of shifts is located in the range L11:U21<\/code> with the results posted range AG10:AS22<\/code> (change as required)<\/em><\/p>\n

The code below produces the required count of Shift Combinations<\/em> and additionally a count of the Shifts Turns<\/em> (see Fig. 1)<\/em><\/p>\n

Users interested in having a deeper understanding of the resources used in the code are invited to visit these pages:<\/p>\n

Variables & Constants<\/a>, Excel Objects<\/a>, With Statement<\/a>,<\/p>\n

For…Next Statement<\/a>, For Each…Next Statement<\/a>, GoSub…Return Statement<\/a>,<\/p>\n

Split Function<\/a>, Custom Number Format<\/a>, Range Properties (Excel)<\/a><\/p>\n

I have also included some comments in the code indicating the purpose of each segment within it. Nevertheless, do let me know of any questions about the code and the resources used in it. Happy reading!!!<\/p>\n

Option Explicit\n\nSub Shifts_Combinations_Count()\nConst kShifts As String = \"a,b,c,d,e,f,g,h,i,j,k\"\nDim rSrc As Range, rTrg As Range\nDim sFmlR1C1 As String, sRef1 As String, sRef2 As String, sRef3 As String\nDim rTmp As Range, sShifts As String, iCol As Integer\nDim blFntBld As Boolean, blNbrFmt As Boolean\nDim b1 As Byte, b2 As Byte\nDim sLabel As String\n\n    Application.ScreenUpdating = False\n\n    Rem Set Ranges\n    With ThisWorkbook.Sheets(\"Sht(2)\")  'Change the name of the worksheet as required\n        Set rSrc = .Range(\"L11:U20\")    'Update the range as required\n        Set rTrg = .Range(\"AH11:AR21\")  'Update the range as required\n    End With\n\n    Rem Builts Shift Combinations\n    With rSrc\n\n        Rem Add First Combinations\n        sShifts = \"|\" & .Cells(1).Value2 & .Cells(.Cells.Count).Value2 & \"|\"\n\n        Rem Add Combinations by Row\n        For iCol = 1 To .Columns.Count - 1\n            For Each rTmp In .Columns(iCol).Cells\n                With rTmp\n                    sShifts = sShifts & .Value2 & .Offset(0, 1).Value2 & \"|\"\n        End With: Next: Next\n\n        Rem Add Combinations Cross Rows\n        For b1 = 1 To -1 + .Rows.Count\n            sShifts = sShifts & .Cells(b1, .Columns.Count).Value2 & _\n                .Cells(1 + b1, 1).Value2 & \"|\"\n\n    Next: End With\n\n    Rem Calculate Combinations\n    With rTrg\n\n        Rem Set Titles Rows\n        Set rTmp = .Rows(1).Offset(-1, 0)\n        blFntBld = 1: GoSub Rng_Formatting\n        rTmp.Value = Split(kShifts, Chr(44))\n        rTmp.ColumnWidth = 5\n\n        Rem Set Titles Cols\n        Set rTmp = .Columns(1).Offset(0, -1)\n        blFntBld = 1: GoSub Rng_Formatting\n        rTmp.Value = Application.Transpose(Split(kShifts, Chr(44)))\n\n        Rem Counting Combinations\n        Set rTmp = .Cells\n        blNbrFmt = 1: GoSub Rng_Formatting\n        sRef1 = .Cells(1).Offset(-1, -1).Address(1, 1, xlR1C1)\n        sRef2 = .Cells(1).Offset(0, -1).Address(0, 1, xlR1C1, , .Cells(1))\n        sRef3 = .Cells(1).Offset(-1, 0).Address(1, 0, xlR1C1, , .Cells(1))\n        Set rTmp = .Cells(1).Offset(-1, -1)\n        sLabel = rTmp.Value2\n        Rem rTmp.Font.Color = RGB(255, 255, 255)\n        rTmp.Value = sShifts\n        sFmlR1C1 = \"=( LEN( \" & sRef1 & \" )\" & _\n            \"- LEN( SUBSTITUTE( SUBSTITUTE( \" & sRef1 & _\n            \",\" & sRef2 & \" & \" & sRef3 & \", \"\"\"\" )\" & _\n            \",\" & sRef3 & \" & \" & sRef2 & \", \"\"\"\" ) ) ) \/ 2\"\n        .FormulaR1C1 = sFmlR1C1\n\n        Rem Clear Redundant Cells\n        For b1 = 1 To 11\n            For b2 = 1 To 11\n                If b2 >= b1 Then\n                    With .Cells(b1, b2)\n                        .ClearContents\n                        .Borders.LineStyle = xlNone\n                        .Interior.Color = RGB(216, 216, 216)\n        End With: End If: Next: Next\n\n        Rem Total Shifts\n        Set rTmp = .Columns(1 + .Columns.Count)\n        GoSub Rng_Formatting\n        sRef1 = rSrc.Address(1, 1, xlR1C1)\n        sRef2 = .Cells(1).Offset(0, -1).Address(0, 1, xlR1C1, , .Cells(1))\n        sFmlR1C1 = \"=COUNTIF( \" & sRef1 & \", \" & sRef2 & \" )\"\n        rTmp.FormulaR1C1 = sFmlR1C1\n\n        Rem Grand Total Shifts\n        sFmlR1C1 = \"=CONCATENATE( \"\"Shifts: \"\" , CHAR(10) , \" & _\n            \"SUM( \" & rTmp.Address(1, 0, xlR1C1, , rTmp.Cells(1)) & \") )\"\n        Set rTmp = rTmp.Cells(1).Offset(-1, 0)\n        blFntBld = 1: GoSub Rng_Formatting\n        GoSub Grand_Totals\n        rTmp.ColumnWidth = 6\n\n        Rem Total Combinations\n        Set rTmp = .Rows(1 + .Columns.Count)\n        GoSub Rng_Formatting\n        sRef1 = .Columns(1).Address(1, 0, xlR1C1, , .Cells(1))\n        sFmlR1C1 = \"=SUM( \" & sRef1 & \" )\"\n        rTmp.FormulaR1C1 = sFmlR1C1\n\n        Rem Grand Total Combinations\n        sFmlR1C1 = \"=CONCATENATE( \"\"Combinations: \"\" , CHAR(10) , \" & _\n            \"SUM( \" & rTmp.Address(0, 1, xlR1C1, , rTmp.Cells(1)) & \") )\"\n        Set rTmp = rTmp.Cells(1).Offset(0, -1)\n        blFntBld = 1: GoSub Rng_Formatting\n        GoSub Grand_Totals\n        rTmp.ColumnWidth = 13\n\n        Rem Replace Formulas with values\n        .Calculate\n        .Value = .Value2\n\n        Rem Reset Title\n        Set rTmp = .Cells(1).Offset(-1, -1)\n        rTmp.Value = sLabel\n        Rem blFntBld = 1: GoSub Rng_Formatting\n        Rem rTmp.Font.ColorIndex = xlAutomatic\n\n    End With\n\n    Application.ScreenUpdating = 1\n\nExit Sub\nRng_Formatting:\n    Rem Range Formating\n    With rTmp\n        .Interior.Color = RGB(255, 255, 255)\n        If blNbrFmt Then .NumberFormat = \" # ; -# ;\"\"\"\";@\"\n        If blFntBld Then .Font.Bold = True\n        .HorizontalAlignment = xlCenter\n        .VerticalAlignment = xlCenter\n        .Borders(xlDiagonalDown).LineStyle = xlNone\n        .Borders(xlDiagonalUp).LineStyle = xlNone\n        .Borders.LineStyle = xlContinuous\n        .Borders.Color = RGB(128, 128, 128)\n        .BorderAround Weight:=xlMedium, Color:=RGB(128, 128, 128)\n        .Borders(xlInsideHorizontal).Weight = xlThin\n        .Borders(xlInsideVertical).Weight = xlThin\n    End With\n    blNbrFmt = 0\n    blFntBld = 0\n    Return\n\nGrand_Totals:\n    Rem Grand Totals Formatting\n    With rTmp\n        .FormulaR1C1 = sFmlR1C1\n        .Columns.AutoFit\n        .WrapText = True\n        .Rows.AutoFit\n    End With\n    Return\n\nEnd Sub\n<\/code><\/pre>\n
\"enter<\/a><\/p>\n
Hope you find this answer useful, even if there are some things you don’t quite understand as of now, and hopefully those new things will spark the interest, curiosity in you and motivates you to know more about programming.<\/p>\n<\/p><\/div>\n
<\/div>\n<\/div>\n
            5<\/span> <\/p><\/div>\n<\/div>\n
[ad_2]<\/p>\n
solved Need help in VBA <\/p>\n","protected":false},"excerpt":{"rendered":"
[ad_1] Count of Shift Combinations within a List of 100 continuous Shifts This answer is a solution to the revised requirements of the asker. I\u2019m posting this answer as the asker changed the original requirements, and therefore requiring a different solution than the first posted. I decide to leave both solutions for the benefit of … Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[320],"tags":[400,401],"class_list":["post-10100","post","type-post","status-publish","format-standard","hentry","category-solved","tag-excel","tag-vba"],"yoast_head":"\n[Solved] Need help in VBA - JassWeb<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/jassweb.com\/solved\/solved-need-help-in-vba\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] Need help in VBA - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] Count of Shift Combinations within a List of 100 continuous Shifts This answer is a solution to the revised requirements of the asker. I\u2019m posting this answer as the asker changed the original requirements, and therefore requiring a different solution than the first posted. I decide to leave both solutions for the benefit of ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-need-help-in-vba\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2022-09-22T01:50:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/jassweb.com\/solved\/wp-content\/uploads\/2022\/09\/Solved-Need-help-in-VBA.png\" \/>\n<meta name=\"author\" content=\"Kirat\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kirat\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/solved-need-help-in-vba\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/solved-need-help-in-vba\\\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/#\\\/schema\\\/person\\\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] Need help in VBA\",\"datePublished\":\"2022-09-22T01:50:29+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/solved-need-help-in-vba\\\/\"},\"wordCount\":296,\"publisher\":{\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/solved-need-help-in-vba\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/Solved-Need-help-in-VBA.png\",\"keywords\":[\"excel\",\"vba\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/solved-need-help-in-vba\\\/\",\"url\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/solved-need-help-in-vba\\\/\",\"name\":\"[Solved] Need help in VBA - JassWeb\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/solved-need-help-in-vba\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/solved-need-help-in-vba\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/Solved-Need-help-in-VBA.png\",\"datePublished\":\"2022-09-22T01:50:29+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/solved-need-help-in-vba\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/jassweb.com\\\/solved\\\/solved-need-help-in-vba\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/solved-need-help-in-vba\\\/#primaryimage\",\"url\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/Solved-Need-help-in-VBA.png\",\"contentUrl\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/Solved-Need-help-in-VBA.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/solved-need-help-in-vba\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] Need help in VBA\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/#website\",\"url\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/\",\"name\":\"JassWeb\",\"description\":\"Build High-quality Websites\",\"publisher\":{\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/#organization\",\"name\":\"Jass Web\",\"url\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/jassweb.com\\\/wp-content\\\/uploads\\\/2021\\\/02\\\/jass-website-logo-1.png\",\"contentUrl\":\"https:\\\/\\\/jassweb.com\\\/wp-content\\\/uploads\\\/2021\\\/02\\\/jass-website-logo-1.png\",\"width\":693,\"height\":132,\"caption\":\"Jass Web\"},\"image\":{\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/#\\\/schema\\\/person\\\/65c9c7b7958150c0dc8371fa35dd7c31\",\"name\":\"Kirat\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/wp-content\\\/litespeed\\\/avatar\\\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1777008400\",\"url\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/wp-content\\\/litespeed\\\/avatar\\\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1777008400\",\"contentUrl\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/wp-content\\\/litespeed\\\/avatar\\\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1777008400\",\"caption\":\"Kirat\"},\"sameAs\":[\"http:\\\/\\\/jassweb.com\"],\"url\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/author\\\/jaspritsinghghumangmail-com\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Solved] Need help in VBA - JassWeb","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":"https:\/\/jassweb.com\/solved\/solved-need-help-in-vba\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] Need help in VBA - JassWeb","og_description":"[ad_1] Count of Shift Combinations within a List of 100 continuous Shifts This answer is a solution to the revised requirements of the asker. I\u2019m posting this answer as the asker changed the original requirements, and therefore requiring a different solution than the first posted. I decide to leave both solutions for the benefit of ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-need-help-in-vba\/","og_site_name":"JassWeb","article_published_time":"2022-09-22T01:50:29+00:00","og_image":[{"url":"https:\/\/jassweb.com\/solved\/wp-content\/uploads\/2022\/09\/Solved-Need-help-in-VBA.png","type":"","width":"","height":""}],"author":"Kirat","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirat","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jassweb.com\/solved\/solved-need-help-in-vba\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-need-help-in-vba\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] Need help in VBA","datePublished":"2022-09-22T01:50:29+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-need-help-in-vba\/"},"wordCount":296,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"image":{"@id":"https:\/\/jassweb.com\/solved\/solved-need-help-in-vba\/#primaryimage"},"thumbnailUrl":"https:\/\/jassweb.com\/solved\/wp-content\/uploads\/2022\/09\/Solved-Need-help-in-VBA.png","keywords":["excel","vba"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-need-help-in-vba\/","url":"https:\/\/jassweb.com\/solved\/solved-need-help-in-vba\/","name":"[Solved] Need help in VBA - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"primaryImageOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-need-help-in-vba\/#primaryimage"},"image":{"@id":"https:\/\/jassweb.com\/solved\/solved-need-help-in-vba\/#primaryimage"},"thumbnailUrl":"https:\/\/jassweb.com\/solved\/wp-content\/uploads\/2022\/09\/Solved-Need-help-in-VBA.png","datePublished":"2022-09-22T01:50:29+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-need-help-in-vba\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-need-help-in-vba\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/solved-need-help-in-vba\/#primaryimage","url":"https:\/\/jassweb.com\/solved\/wp-content\/uploads\/2022\/09\/Solved-Need-help-in-VBA.png","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/uploads\/2022\/09\/Solved-Need-help-in-VBA.png"},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-need-help-in-vba\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] Need help in VBA"}]},{"@type":"WebSite","@id":"https:\/\/jassweb.com\/solved\/#website","url":"https:\/\/jassweb.com\/solved\/","name":"JassWeb","description":"Build High-quality Websites","publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jassweb.com\/solved\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/jassweb.com\/solved\/#organization","name":"Jass Web","url":"https:\/\/jassweb.com\/solved\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/","url":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","contentUrl":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","width":693,"height":132,"caption":"Jass Web"},"image":{"@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31","name":"Kirat","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1777008400","url":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1777008400","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1777008400","caption":"Kirat"},"sameAs":["http:\/\/jassweb.com"],"url":"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/"}]}},"_links":{"self":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/10100","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/comments?post=10100"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/10100\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=10100"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=10100"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=10100"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}