Psalm 111/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/111/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/111Ni8QMdjRtxVFj_eAcSD111kgnWmoNTLMZy0zvykIT8ku0/edit?gid=7021114111086#gid=7021114111086

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 1119
  2. Add the DiscourseSheetID property like this:
{{ResourceSite
|DiscourseSheetID=111Ni8QMdjRtxVFj_eAcSD111kgnWmoNTLMZy0zvykIT8ku0
|DiscourseSheet=2PACX-111vS309bCf4RkDjHEczGiDnZtOACqV94-DLwI_bYlzt5hugBM25ddPLVwaRETsZ9SyB46-7SpcGm3U8bX/pub?gid=7021114111086
}}

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/1117TAMP111KpcaMTXBf5qS0C-mflnt-111srgJTWns6bLRD_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

Follow the above instructions and refresh the page. The Discourse Sheet properties have not yet been set.

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

Using stored expanded paraphrase

Text (Hebrew) Verse Expanded Paraphrase
הַ֥לְלוּ יָ֨הּ ׀ אוֹדֶ֣ה יְ֭הוָה בְּכָל־לֵבָ֑ב בְּס֖וֹד יְשָׁרִ֣ים וְעֵדָֽה׃ 1 + Praise Yah, who has promised to rescue us from our enemies, to give us a king, and to give us the nations as our inheritance ! While we wait for YHWH to perform these great deeds, I will praise YHWH whole-heartedly in the council of upright people which is here gathered together, that is, in the congregation.+
גְּ֭דֹלִים מַעֲשֵׂ֣י יְהוָ֑ה דְּ֝רוּשִׁ֗ים לְכָל־חֶפְצֵיהֶֽם׃ 2 + YHWH's deeds, especially his deeds of redemption and acts of covenant faithfulness, are great, studied in Scripture by all who delight in them.+
הוֹד־וְהָדָ֥ר פָּֽעֳל֑וֹ וְ֝צִדְקָת֗וֹ עֹמֶ֥דֶת לָעַֽד׃ 3 + YHWH is our king, and His work is glorious and majestic, and his righteousness endures forever, even to the present day .+
זֵ֣כֶר עָ֭שָׂה לְנִפְלְאֹתָ֑יו חַנּ֖וּן וְרַח֣וּם יְהוָֽה׃ 4 + He has caused his wonderful acts to be recorded in Scripture and thereby remembered. YHWH is, as he said to Moses in the book of Exodus, merciful and compassionate, forgiving our sins and thus sustaining the covenant he made with us.+
טֶ֭רֶף נָתַ֣ן לִֽירֵאָ֑יו יִזְכֹּ֖ר לְעוֹלָ֣ם בְּרִיתֽוֹ׃ 5 + When he brought our ancestors out of Egypt, He gave food — manna and quail — to those who feared him. The reason why he brought them out of Egypt and provided food for them is because of the covenant he had made with our father Abraham, to whose offspring he had promised to give the land of Canaan. And just as he remembered his covenant then, so He will remember his covenant forever and he will keep his promises to us.+
כֹּ֣חַ מַ֭עֲשָׂיו הִגִּ֣יד לְעַמּ֑וֹ לָתֵ֥ת לָ֝הֶ֗ם נַחֲלַ֥ת גּוֹיִֽם׃ 6 + After rescuing his people from Egypt and sustaining them in the wilderness, he continued to do wonderful deeds for his people which demonstrated his power in an even greater way: He showed his people the power of his deeds by keeping his promise to Abraham and giving them nations as an inheritance.+
מַעֲשֵׂ֣י יָ֭דָיו אֱמֶ֣ת וּמִשְׁפָּ֑ט נֶ֝אֱמָנִ֗ים כָּל־פִּקּוּדָֽיו׃ 7 + The deeds of his hands are faithful and just, including his act of giving us the law. All his commandments are enduring,+
סְמוּכִ֣ים לָעַ֣ד לְעוֹלָ֑ם עֲ֝שׂוּיִ֗ם בֶּאֱמֶ֥ת וְיָשָֽׁר׃ 8 + All his commandments are enduring, because they have been established by YHWH to last forever and ever, and so they are practiced even to this day by his people in faithfulness and uprightness. And so, while we wait for YHWH to remember his covenant and perform great deeds once again, we too must remember to keep the covenant requirements YHWH has given us.+
פְּד֤וּת ׀ שָׁ֘לַ֤ח לְעַמּ֗וֹ צִוָּֽה־לְעוֹלָ֥ם בְּרִית֑וֹ קָד֖וֹשׁ וְנוֹרָ֣א שְׁמֽוֹ׃ 9 + When our ancestors were slaves in Egypt, He sent redemption to his people. He brought us out of Egypt to Mt. Sinai, where He gave us the law and commanded that his covenant requirements be observed forever. His name is holy and awesome, which means that his people must be holy and must fear him.+
רֵ֘אשִׁ֤ית חָכְמָ֨ה ׀ יִרְאַ֬ת יְהוָ֗ה שֵׂ֣כֶל ט֭וֹב לְכָל־עֹשֵׂיהֶ֑ם תְּ֝הִלָּת֗וֹ עֹמֶ֥דֶת לָעַֽד׃ 10 + And we should fear YHWH, not only because he is to be feared, but because Fearing YHWH and keeping his commandments is the beginning of wisdom; all who practice them, that is, his commandments, have good insight. Just as his righteousness and covenant faithfulness endure forever, so too His praiseworthiness endures forever which is why I praise him in the congregation today, even as I wait for him to perform great deeds once again.+




(Press Enter to save, or Esc to cancel)

Data check

Extracted from Expanded Paraphrase above

From Text/Verses

Psalm 111/Text/Verses does not yet exist.

Psalm 111/Text/Clauses

 [[:Psalm 111/Text/Clauses]]

Expand for all files for Psalm 111/Text