Psalm 23/Expanded Paraphrase

From Psalms: Layer by Layer
Jump to: navigation, search

Build Expanded Paraphrase

Click within the CBC to insert an expansion. A textbox will appear. Type in (or copy into) the textbox and push ESC to cancel or ENTER to save.

Alternatively, you may edit the CBC/insertions alternation directly at Data/23/expanded-paraphrase.json for a final draft. If you're viewing a paraphrase from the wiki, save it as a draft and then modify.

If there is an extra space between two parts...

, you'll need to modify the json file directly. For example, to enable plots: 

	{
		"verse": "1",
		"cbc": "plot",
		"Index": 6,
		"suppressFollowingSpace": true
	},
	{
		"verse": "1",
		"insertion": "s",
		"WordsBefore": 6,
		"Index": 7
	},

If a Google discourse sheet exists...

You may import the Expanded Paraphrase from the sheet by following these instructions.

Prepare the discourse sheet

  1. Open the Discourse Google sheet for this Psalm.
  2. Go to the tab named "Public-Text" (which is likely already made). If it doesn't exist, follow these instructions (you'll need it all by the end of this).

Prepare

To enable this, you must:

  1. Open the Discourse Google sheet for this Psalm.
  2. Add a new tab named "Public-Text" (the name isn't actually critical)
  3. Use as the formula in the top-left cell: ='Discourse Master Sheet'!A:A (or whatever the appropriate code is to select the first column of the master sheet).
  4. Drag the formula over to Column C and down as far as needed to get all the rows.
  5. File > Share > Publish to Web
  6. Instead of Entire Document, choose sheet Public-Text
  7. Instead of Web Page, choose Tab-separated values.
  8. Copy the link starting from after /d/e until before the &single, e.g. https://docs.google.com/spreadsheets/d/e/2PACX-1vTeE2dD9gc2v4rckm23VfBCDdpuLirI3DOxLQE10a2UHWl3puz8wPPCJ2wgBftP4VYqadCPb2pWOUwi/pub?gid=168152279&single=true&output=tsv
  9. Edit the base Psalm page, e.g. Psalm 19
  10. Add the DiscourseSheet property like this:
{{ResourceSite
|DiscourseSheet=2PACX-1vTeE2dD9gc2v4rckm23VfBCDdpuLirI3DOxLQE10a2UHWl3puz8wPPCJ2wgBftP4VYqadCPb2pWOUwi/pub?gid=168152279
|Banner Image=Psalm 19 banner image.jpg
  1. In D2, type "Expanded Paraphrase" as the new header. (This, like the one below, will be used by code to ensure this is what is intended.)
  2. In E2, type "Expanded Paraphrase as JSON" as the new header.

Get the spreadsheet ID

  1. Now you'll need to save the Google spreadsheet ID. This will be used to generate the JSON within the Google environment. (The Google sheet URL, which is likely already stored, will be used to extract the JSON into the Resource Site.)
  2. From the URL, copy the link starting from after /d until before the /edit?, e.g. https://docs.google.com/spreadsheets/d/23Ni8QMdjRtxVFj_eAcSD23kgnWmoNTLMZy0zvykIT8ku0/edit?gid=70223423086#gid=70223423086

Save the spreadsheet ID

(This step can be skipped if you'll only ever manuallly populate this; this goal permits us to bulk populate all discourse spreadsheets.)

  1. Edit the base Psalm page, e.g. Psalm 239
  2. Add the DiscourseSheetID property like this:
{{ResourceSite
|DiscourseSheetID=23Ni8QMdjRtxVFj_eAcSD23kgnWmoNTLMZy0zvykIT8ku0
|DiscourseSheet=2PACX-23vS309bCf4RkDjHEczGiDnZtOACqV94-DLwI_bYlzt5hugBM25ddPLVwaRETsZ9SyB46-7SpcGm3U8bX/pub?gid=70223423086
}}

Populate the Public-Text sheet

  1. Actually extract the bold & italics from the main sheet into the Public-Text sheet. This involves running an Apps Script. First open this: https://script.google.com/u/0/home/projects/237TAMP23KpcaMTXBf5qS0C-mflnt-23srgJTWns6bLRD_l6eNSj9zy4Bxzc/edit.
  2. Now add your discourse sheet id to the end of the list of spreadsheetIDs at the top, remembering to enclose it in double quotation marks and ensuring everything is comma-delimited.
  3. At the top of the page, ensure "extractBoldFromMultipleSpreadsheets" is in the menu bar.
  4. Click Run.
  5. If the Execution Log at the bottom of the page doesn't show "Execution started" and then "Execution completed" then ask Elizabeth for help...

Extract the Public-Text sheet to the Resource Site

This Psalm has the requisite Discourse Sheet info stored.

Use the Save current draft button at the bottom of the page to save.

Using stored expanded paraphrase

Text (Hebrew) Verse Expanded Paraphrase
מִזְמ֥וֹר לְדָוִ֑ד יְהוָ֥ה רֹ֝עִ֗י לֹ֣א אֶחְסָֽר׃ 1 A psalm written by David expressing confidence in YHWH's providence and protection. Like a sheep, I need a shepherd who knows my needs intimately so that he can meet them. I depend upon my shepherd because I cannot meet my needs on my own. Yet, I do not need to worry because YHWH is my shepherd; who provides for all of my needs. Therefore, I will never lack [anything]. When I need food, water, and a place to rest,
בִּנְא֣וֹת דֶּ֭שֶׁא יַרְבִּיצֵ֑נִי עַל־מֵ֖י מְנֻח֣וֹת יְנַהֲלֵֽנִי׃ 2 He makes a way for me to lie down in green pastures where I can eat and rest, and He leads me to water where I can drink and rest.
נַפְשִׁ֥י יְשׁוֹבֵ֑ב יַֽנְחֵ֥נִי בְמַעְגְּלֵי־צֶ֝֗דֶק לְמַ֣עַן שְׁמֽוֹ׃ 3 He is a source of refreshment like no other; when I feel physically deprived of food, water, and rest, He restores my life by giving me nourishment. YHWH, my shepherd, is more than a provider, he is also a guide. I am not lost or aimless because He leads me securely where I should go. Life is fraught with conflict and trial, and the only safe path is following YHWH closely, pursuing righteousness. My security is that he leads me in paths of righteousness which enable me to live a righteous life. My confidence is in knowing that, ultimately, he does this not merely for my sake but, rather, for the sake of his name, because he receives honor when his servants pursue righteousness. His reputation, or name, benefits. He chooses paths that honor him and care for me, because he is a good shepherd. A "right path" does not necessarily mean a safe path. Sheep may need to go on dangerous paths on their way to pasture or water. The safety comes not from the path but from the shepherd's presence, because he protects his sheep.
גַּ֤ם כִּֽי־אֵלֵ֨ךְ בְּגֵ֪יא צַלְמָ֡וֶת לֹא־אִ֘ירָ֤א רָ֗ע כִּי־אַתָּ֥ה עִמָּדִ֑י שִׁבְטְךָ֥ וּ֝מִשְׁעַנְתֶּ֗ךָ הֵ֣מָּה יְנַֽחֲמֻֽנִי׃ 4 Therefore, Even when I walk in a valley of darkness under threat of predators and enemies, I will not fear harm, because you, YHWH, are with me. Your rod defends me against predators and your staff directs me, making it so I always know where to go: because they offer me both protection and guidance, they comfort me.
תַּעֲרֹ֬ךְ לְפָנַ֨י ׀ שֻׁלְחָ֗ן נֶ֥גֶד צֹרְרָ֑י דִּשַּׁ֖נְתָּ בַשֶּׁ֥מֶן רֹ֝אשִׁ֗י כּוֹסִ֥י רְוָיָֽה׃ 5 You care for me even more than a shepherd cares for his sheep, though. You treat me like an honored guest, whom you have chosen to invite under your protection, to provide for all my needs. You act like a gracious host: You arrange a table before me, setting out abundant food and drink. Like the shepherd who ensures both that the sheep eat and drink and also that they are protected from predators, you not only provide food and drink, but you do so in the presence of my adversaries — my enemies get to see your abundant provision for me! Not only can they not harm me, as long as I am under your protection, but they see and know that I am under your care. They would like to attack and defeat me, but you do the opposite: you treat me as an honorable guest: You have anointed my head with fine, spiced oil the way gracious hosts do, and now you fill the table with food and drink. In fact, you provide so much that I cannot even drink it all before you pour more wine. You provide so much that My cup is overflowing.
אַ֤ךְ ׀ ט֤וֹב וָחֶ֣סֶד יִ֭רְדְּפוּנִי כָּל־יְמֵ֣י חַיָּ֑י *וְשִבְתִּי* בְּבֵית־יְ֝הוָ֗ה לְאֹ֣רֶךְ יָמִֽים׃ 6 With you as my shepherd and host, Surely your goodness and loyalty, instead of anything or anyone that could cause me harm, will pursue me all the days of my life, and I will dwell in YHWH's house, that is, I will continue to receive all the privileges and blessings of being your guest, in your presence, for as long as I live.




(Press Enter to save, or Esc to cancel)

Data check

Extracted from Expanded Paraphrase above

From Text/Verses

Hebrew Verse CBC
מִזְמ֥וֹר לְדָוִ֑ד יְהוָ֥ה רֹ֝עִ֗י לֹ֣א אֶחְסָֽר׃ 1 A psalm by David. YHWH is my shepherd; I will never lack [anything].
בִּנְא֣וֹת דֶּ֭שֶׁא יַרְבִּיצֵ֑נִי עַל־מֵ֖י מְנֻח֣וֹת יְנַהֲלֵֽנִי׃ 2 He makes me lie down in green pastures. He leads me to water where I can rest.
נַפְשִׁ֥י יְשׁוֹבֵ֑ב יַֽנְחֵ֥נִי בְמַעְגְּלֵי־צֶ֝֗דֶק לְמַ֣עַן שְׁמֽוֹ׃ 3 He restores my life. He leads me in paths of righteousness for the sake of his name.
גַּ֤ם כִּֽי־אֵלֵ֨ךְ בְּגֵ֪יא צַלְמָ֡וֶת לֹא־אִ֘ירָ֤א רָ֗ע כִּי־אַתָּ֥ה עִמָּדִ֑י שִׁבְטְךָ֥ וּ֝מִשְׁעַנְתֶּ֗ךָ הֵ֣מָּה יְנַֽחֲמֻֽנִי׃ 4 Even when I walk in a valley of darkness, I will not fear harm, because you are with me. Your rod and your staff, they comfort me.
תַּעֲרֹ֬ךְ לְפָנַ֨י ׀ שֻׁלְחָ֗ן נֶ֥גֶד צֹרְרָ֑י דִּשַּׁ֖נְתָּ בַשֶּׁ֥מֶן רֹ֝אשִׁ֗י כּוֹסִ֥י רְוָיָֽה׃ 5 You arrange a table before me in the presence of my adversaries. You have anointed my head with oil. My cup is overflowing.
אַ֤ךְ ׀ ט֤וֹב וָחֶ֣סֶד יִ֭רְדְּפוּנִי כָּל־יְמֵ֣י חַיָּ֑י *וְשִבְתִּי* בְּבֵית־יְ֝הוָ֗ה לְאֹ֣רֶךְ יָמִֽים׃ 6 Surely goodness and loyalty will pursue me all the days of my life, and I will dwell in YHWH’s house for as long as I live.

Expand for all files for Psalm 23/Text