Psalm 51/Expanded Paraphrase
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/51/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
- Open the Discourse Google sheet for this Psalm.
- 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:
- Open the Discourse Google sheet for this Psalm.
- Add a new tab named "Public-Text" (the name isn't actually critical)
- 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). - Drag the formula over to Column C and down as far as needed to get all the rows.
File > Share > Publish to Web- Instead of Entire Document, choose sheet
Public-Text - Instead of Web Page, choose
Tab-separated values. - 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 - Edit the base Psalm page, e.g.
Psalm 19 - Add the
DiscourseSheetproperty like this:
{{ResourceSite
|DiscourseSheet=2PACX-1vTeE2dD9gc2v4rckm23VfBCDdpuLirI3DOxLQE10a2UHWl3puz8wPPCJ2wgBftP4VYqadCPb2pWOUwi/pub?gid=168152279
|Banner Image=Psalm 19 banner image.jpg
- 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.) - In
E2, type "Expanded Paraphrase as JSON" as the new header.
Get the spreadsheet ID
- 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.) - From the URL, copy the link starting from after /d until before the /edit?, e.g. https://docs.google.com/spreadsheets/d/
51Ni8QMdjRtxVFj_eAcSD51kgnWmoNTLMZy0zvykIT8ku0/edit?gid=70251451086#gid=70251451086
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.)
- Edit the base Psalm page, e.g.
Psalm 519 - Add the
DiscourseSheetIDproperty like this:
{{ResourceSite
|DiscourseSheetID=51Ni8QMdjRtxVFj_eAcSD51kgnWmoNTLMZy0zvykIT8ku0
|DiscourseSheet=2PACX-51vS309bCf4RkDjHEczGiDnZtOACqV94-DLwI_bYlzt5hugBM25ddPLVwaRETsZ9SyB46-7SpcGm3U8bX/pub?gid=70251451086
}}
Populate the Public-Text sheet
- 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/517TAMP51KpcaMTXBf5qS0C-mflnt-51srgJTWns6bLRD_l6eNSj9zy4Bxzc/edit.
- 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.
- At the top of the page, ensure "extractBoldFromMultipleSpreadsheets" is in the menu bar.
- Click
Run. - 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.
(Press Enter to save, or Esc to cancel)
Data check
Extracted from Expanded Paraphrase above
From Text/Verses
| Text (Hebrew) | Verse | Text (CBC) |
|---|---|---|
| לַמְנַצֵּ֗חַ מִזְמ֥וֹר לְדָוִֽד׃ | 1 | For the music director. A psalm. By David. |
| בְּֽבוֹא־אֵ֭לָיו נָתָ֣ן הַנָּבִ֑יא כַּֽאֲשֶׁר־בָּ֝֗א אֶל־בַּת־שָֽׁבַע׃ | 2 | When Nathan the prophet came to him, when he had had sexual intercourse with Bathsheba. |
| חָנֵּ֣נִי אֱלֹהִ֣ים כְּחַסְדֶּ֑ךָ כְּרֹ֥ב רַ֝חֲמֶ֗יךָ מְחֵ֣ה פְשָׁעָֽי׃ | 3 | Show mercy to me, God, according to your loyalty; according to your abundant compassion wipe away my transgressions. |
| הַרְבֵּה כַּבְּסֵ֣נִי מֵעֲוֺנִ֑י וּֽמֵחַטָּאתִ֥י טַהֲרֵֽנִי׃ | 4 | Wash me thoroughly from my iniquity, and cleanse me from my sin, |
| כִּֽי־פְ֭שָׁעַי אֲנִ֣י אֵדָ֑ע וְחַטָּאתִ֖י נֶגְדִּ֣י תָמִֽיד׃ | 5 | because I am [continually] aware of my transgressions, and my sin is constantly in front of me. |
| לְךָ֤ לְבַדְּךָ֨ ׀ חָטָאתִי֮ וְהָרַ֥ע בְּעֵינֶ֗יךָ עָ֫שִׂ֥יתִי לְ֭מַעַן תִּצְדַּ֥ק בְּדָבְרֶ֗ךָ תִּזְכֶּ֥ה בְשָׁפְטֶֽךָ׃ | 6 | Against you alone I have sinned, and I have done what is evil in your eyes, such that you are in the right whenever you speak, [and such that] you are faultless whenever you judge. |
| הֵן־בְּעָו֥וֹן חוֹלָ֑לְתִּי וּ֝בְחֵ֗טְא יֶֽחֱמַ֥תְנִי אִמִּֽי׃ | 7 | Look, I was born in iniquity, and in guilt my mother conceived me. |
| הֵן־אֱ֭מֶת חָפַ֣צְתָּ בַטֻּח֑וֹת וּ֝בְסָתֻ֗ם חָכְמָ֥ה תוֹדִיעֵֽנִי׃ | 8 | Look, you desire truth in the covered places, and you make me know wisdom in the closed-off place. |
| תְּחַטְּאֵ֣נִי בְאֵז֣וֹב וְאֶטְהָ֑ר תְּ֝כַבְּסֵ֗נִי וּמִשֶּׁ֥לֶג אַלְבִּֽין׃ | 9 | [Would you please] purify me with hyssop, so that I will be clean; [would you please] wash me, so that I will be whiter than snow. |
| תַּ֭שְׁמִיעֵנִי שָׂשׂ֣וֹן וְשִׂמְחָ֑ה תָּ֝גֵ֗לְנָה עֲצָמ֥וֹת דִּכִּֽיתָ׃ | 10 | [Would you please] make me hear gladness and joy; [so that] the bones that you have crushed might rejoice. |
| הַסְתֵּ֣ר פָּ֭נֶיךָ מֵחֲטָאָ֑י וְֽכָל־עֲוֺ֖נֹתַ֣י מְחֵֽה | 11 | Hide your face from my sins, and wipe away all my iniquities. |
| לֵ֣ב טָ֭הוֹר בְּרָא־לִ֣י אֱלֹהִ֑ים וְר֥וּחַ נָ֝כ֗וֹן חַדֵּ֥שׁ בְּקִרְבִּֽי׃ | 12 | Create a clean heart for me, God, and renew a steadfast spirit within me. |
| אַל־תַּשְׁלִיכֵ֥נִי מִלְּפָנֶ֑יךָ וְר֥וּחַ קָ֝דְשְׁךָ֗ אַל־תִּקַּ֥ח מִמֶּֽנִּי׃ | 13 | Do not cast me away from before you, and do not take your holy spirit away from me. |
| הָשִׁ֣יבָה לִּ֭י שְׂשׂ֣וֹן יִשְׁעֶ֑ךָ וְר֖וּחַ נְדִיבָ֣ה תִסְמְכֵֽנִי׃ | 14 | Restore to me the gladness that results from your salvation, and [would you please] support me with a willing spirit. |
| אֲלַמְּדָ֣ה פֹשְׁעִ֣ים דְּרָכֶ֑יךָ וְ֝חַטָּאִ֗ים אֵלֶ֥יךָ יָשֽׁוּבוּ׃ | 15 | I intend to teach transgressors your ways, so that sinners will turn back to you. |
| הַצִּ֘ילֵ֤נִי מִדָּמִ֨ים ׀ אֱֽלֹהִ֗ים אֱלֹהֵ֥י תְּשׁוּעָתִ֑י תְּרַנֵּ֥ן לְ֝שׁוֹנִ֗י צִדְקָתֶֽךָ׃ | 16 | Deliver me from bloodshed, God, the God who saves me, [so that] my tongue will shout for joy about your righteousness. |
| אֲ֭דֹנָי שְׂפָתַ֣י תִּפְתָּ֑ח וּ֝פִ֗י יַגִּ֥יד תְּהִלָּתֶֽךָ׃ | 17 | Lord, [would you please] open my lips, so that my mouth will report praise concerning you. |
| כִּ֤י ׀ לֹא־תַחְפֹּ֣ץ זֶ֣בַח וְאֶתֵּ֑נָה ע֝וֹלָ֗ה לֹ֣א תִרְצֶֽה׃ | 18 | For you do not delight in sacrifice[s], or else I would give [them]; you are not pleased with burnt offering[s]. |
| זִֽבְחֵ֣י אֱלֹהִים֮ ר֪וּחַ נִשְׁבָּ֫רָ֥ה לֵב־נִשְׁבָּ֥ר וְנִדְכֶּ֑ה אֱ֝לֹהִ֗ים לֹ֣א תִבְזֶֽה׃ | 19 | The sacrifices [acceptable to] God are broken spirit[s]; a broken and crushed heart, God, you do not despise. |
| הֵיטִ֣יבָה בִ֭רְצוֹנְךָ אֶת־צִיּ֑וֹן תִּ֝בְנֶ֗ה חוֹמ֥וֹת יְרוּשָׁלִָֽם׃ | 20 | Do good to Zion in accord with what pleases you; [would you please] build the walls of Jerusalem. |
| אָ֤ז תַּחְפֹּ֣ץ זִבְחֵי־צֶ֭דֶק עוֹלָ֣ה וְכָלִ֑יל אָ֤ז יַעֲל֖וּ עַל־מִזְבַּחֲךָ֣ פָרִֽים׃ | 21 | Then you will delight in right sacrifices, in burnt offering[s] and whole offering[s]; then [people] will offer up bulls on your altar. |
Expand for all files for Psalm 51/Text