tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 3b39c74e-fd69-471a-b775-bf2365d7d2a4
Sheet: Inputs

Initial Operating Deficit Escrow Calculation Section 232 |  |  | U.S. Department of Housing and Urban Development Office of Residential Care Facilities |  |  |  |  |  | OMB Approval No. 2502-0605 (exp. 03/31/2014)
Public reporting burden for this collection of information is estimated to average 1.5 hours.  This includes the time for collecting, reviewing, and reporting the data.  The information is being collected to obtain the supportive documentation which must be submitted to HUD for approval, and is necessary to ensure that viable projects are developed and maintained.  The Department will use this information to determine if properties meet HUD requirements with respect to development, operation and/or asset management, as well as ensuring the continued marketability of the properties.  This agency may not collect this information, and you are not required to complete this form unless it displays a currently valid OMB control number.     Warning: Any person who knowingly presents a false, fictitious, or fraudulent statement or claim in a matter within the jurisdiction of the U.S. Department of Housing and Urban Development is subject to criminal penalties, civil liability, and administrative sanctions.
Project Name: |  |  |  |  | Date Prepared: |  | [NAME]:
Income & Occupancy Assumptions
Unit Type | [NAME]. Gross Inc. per year | Total # Beds | UW Occupancy | # Occupied Units | EGI per Occp'd Unit | Number of Preleases | Net Monthly Absorption
e.g. Assisted Living
e.g. Memory Care
e.g. [NAME] or Sub-Acute
e.g. Independent Living
Other Income
Totals
Expense Assumptions
 | Total UW | Total UW | Per Res | POU | % of EGI |  | Expense Floor
Category | Exp. per year | Exp. per Month | Day | per year | UW |  | Percentage | Yearly Floor | Monthly Floor
e.g. General & Administrative |  |  |  |  |  |  | 1
e.g. Payroll Taxes and Benefits |  |  |  |  |  |  | 0.8
e.g. Resident Care |  |  |  |  |  |  | 0.3
e.g. Food Services |  |  |  |  |  |  | 0.3
e.g. Activities |  |  |  |  |  |  | 0.3
e.g. Housekeeping  & Laundry |  |  |  |  |  |  | 0.1
e.g. [NAME] |  |  |  |  |  |  | 0.3
e.g. Utilities |  |  |  |  |  |  | 0.5
e.g. Bad Debt |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
Ground Rent |  |  |  |  |  |  | 1
Marketing and Promotion |  |  |  |  |  |  | 1
Insurance (property & liability) |  |  |  |  |  |  | 1
Real Estate (Property) Taxes |  |  |  |  |  |  | 1
Management Fees |  |  |  |  |  |  | 0.8
Replacement Reserves |  |  |  |  |  |  | 1
TOTAL
Debt Service Assumptions
Interest Only |  | per month |  | Debt Service Calculator
[NAME] |  | per month |  | Mortgage Amount
MIP |  | per month |  | Term in Months
 |  |  |  | Annual Interest Rate
 |  |  |  | [NAME] |  | 0.0077
Spreadsheet: 47996d1247169550-adding-mm-ss-schedule-adherence-draft
Sheet: Exceptions

 | Schedule Adherence Exceptions
Agent Login | CSR | 2009-06-01 00:00:00 | 2009-06-02 00:00:00 | 2009-06-03 00:00:00 | 2009-06-04 00:00:00 | 2009-06-05 00:00:00 | 2009-06-08 00:00:00 | 2009-06-09 00:00:00 | 2009-06-10 00:00:00 | 2009-06-11 00:00:00 | 2009-06-12 00:00:00 | 2009-06-15 00:00:00 | 2009-06-16 00:00:00 | 2009-06-17 00:00:00 | 2009-06-18 00:00:00 | 2009-06-19 00:00:00 | 2008-06-22 00:00:00 | 2009-06-23 00:00:00 | 2009-06-24 00:00:00 | 2009-06-25 00:00:00 | 2009-06-26 00:00:00 | 2009-06-29 00:00:00 | 2009-06-30 00:00:00 | Totals
7302 | Enos, [NAME] |  |  | 47 |  |  | 35 |  | 36 |  | 17 |  |  |  |  |  |  |  | 35 | 30 |  | 20 |  | 220
7312 | Wickson, [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
7313 | Chiverton, Pam |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
7314 | Mineo, MaryAnn |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
7317 | Suess, Debbie | 68 | 166 | 63 | 188 | 213 |  | 23 | 48 | 15 | 352 | 210 | 230 | 41 | 233 | 440 |  |  | 70 | 190 | 16 | 56 | 22 | 2644
7322 | Fontes, [NAME] |  |  | 53 |  |  |  |  | 33 |  |  |  |  | 26 |  |  | 30 |  | 75 |  |  | 15 |  | 232
7360 | Boehme, Debbie |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
7377 | Lewis, Pat |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
7378 | Thornton, [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
7379 | [NAME], [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
7813 | [NAME], [NAME] | 33 | 26 | 89 | 30 | 30 |  | 30 | 66 | 17 | 36 | 38 | 23 | 61 | 170 | 200 | 31 | 42 | 105 | 29 | 34 | 40 | 160 | 1290
7816 | Vicochea, [NAME] |  |  | 53 |  |  | 38 |  | 33 | 30 |  |  |  | 26 |  |  |  | 16 | 35 |  |  | 15 |  | 246
7821 | Schultz, Carol |  | 66 | 53 | 65 |  |  | 186 |  |  |  | 60 | 13 | 91 |  |  |  | 46 | 35 |  |  | 15 | 66 | 696
7822 | Stiggin, Caroline | 215 | 187 | 180 | 218 | 123 | 148 | 175 | 124 | 48 | 175 | 154 | 190 | 182 | 17 | 160 | 129 | 110 | 125 | 170 | 100 | 185 | 133 | 3248
7826 | McNeil, [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
7841 | Romo, Christine |  |  | 47 |  |  |  |  | 36 |  |  |  |  | 31 |  |  |  |  | 35 | 30 |  | 15 |  | 194
7855 | Jones, [NAME] |  |  | 47 |  |  | 35 |  | 36 |  |  | 48 |  | 31 |  | 66 |  |  | 75 |  |  | 25 |  | 363
7884 | Rubero, [NAME] | 15 | 15 | 62 | 15 | 15 | 15 |  | 51 | 15 | 15 | 15 | 15 | 46 | 15 | 15 | 15 | 42 | 50 | 15 | 15 | 35 | 15 | 511
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: 757925d1638534109-merging-two-sets-of-data-into-one-output-test-file-1-
Sheet: Sheet1

Data 1 |  |  |  |  | Output
Part Number | Order No | Qty | PO Due |  | Part No | Job No | Qty | Job Due | Order No | Qty | PO Due
ABC123 | 12444 | 100 | 2022-01-01 00:00:00 |  | ABC123 | 100 | 50 | 2022-01-15 00:00:00 | 12444 | 100 | 2022-01-01 00:00:00
ABC123 | 12555 | 50 | 2022-02-01 00:00:00 |  | ABC123 | 101 | 50 | 2022-02-01 00:00:00
ABC123 | 12666 | 50 | 2022-03-01 00:00:00 |  | ABC123 | 102 | 50 | 2022-02-15 00:00:00 | 12555 | 50 | 2022-02-01 00:00:00
DEF456 | 11111 | 100 | 2021-12-01 00:00:00 |  | ABC123 | 103 | 50 | 2022-03-15 00:00:00 | 12666 | 50 | 2022-03-01 00:00:00
DEF456 | 11222 | 100 | 2022-02-01 00:00:00 |  | DEF456 | 104 | 50 | 2021-12-15 00:00:00 | 11111 | 100 | 2021-12-01 00:00:00
GHI789 | 33444 | 50 | 2022-03-01 00:00:00 |  | DEF456 | 105 | 50 | 2022-01-01 00:00:00
 |  |  |  |  | DEF456 | 106 | 50 | 2022-02-15 00:00:00 | 11222 | 100 | 2022-02-01 00:00:00
 |  |  |  |  | DEF456 | 107 | 50 | 2022-03-01 00:00:00
 |  |  |  |  | GHI789 | 108 | 50 | 2022-03-15 00:00:00 | 33444 | 50 | 2022-03-01 00:00:00
Spreadsheet: 850580d1700937345-employee-total-workin-hours-summary-total-working-hours-summary
Sheet: Sheet2

TABLE 1 |  |  |  |  | TABLE 2
James, Scott - ID: 10247
Date | Regular hours | OT hours | Total hours |  |  | Nov 13 | Nov 14 | Nov 15 | Nov 16 | Nov 17 | Nov 18
Week 1: Nov 13 - Nov 19 |  |  |  |  | James, Scott - ID: 10247 | 2.48 |  |  | 3.97 | 4.2
Nov 13 | 2.48 | 0 | 2.48 |  | [NAME], [NAME] - ID: 10301 |  | 7.6 | 7.97 | 7.93 | 8.43 | 6.25
Nov 16 | 3.97 | 0 | 3.97
Nov 17 | 4.2 | 0 | 4.2
[NAME], [NAME] - ID: 10301
Date | Regular hours | OT hours | Total hours
Week 1: Nov 13 - Nov 19
Nov 14 | 7.6 | 0 | 7.6
Nov 15 | 7.97 | 0 | 7.97
Nov 16 | 7.93 | 0 | 7.93
Nov 17 | 8.43 | 0 | 8.43
Nov 18 | 6.25 | 0 | 6.25
Spreadsheet: 215788d1361480479-multiple-evaluations-in-one-formula-utilizing-percentages-adaptive-spreadsheet
Sheet: 2013 Expenses

CY 2013 Revenue Projections |  | Month 01 | Month 02 | Month 03 | Month 04 | Month 05 | Month 06 | Month 07 | Month 08 | Month 09 | Month 10 | Month 11 | Month 12 | TOTAL
Cities contracted this month |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 1 | 1 | 1
 |  | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0
Revenue: handheld licensing fees
Total Revenues
CY 2013 EXPENSES
CY 2013 G&A EXPENSES |  | Month 01 | Month 02 | Month 03 | Month 04 | Month 05 | Month 06 | Month 07 | Month 08 | Month 09 | Month 10 | Month 11 | Month 12 | TOTAL
Liability Insurance | 35000 | 0 | 0 | 0 | 0 | 0
Automobile allowance | 16800 | 0 | 0 | 0 | 0 | 0
Cell phone | 5000 | 0 | 0 | 0 | 0 | 0
Office Supplies | 50000 | 0 | 0 | 0 | 0 | 0
Postage | 1200 | 0 | 0 | 0 | 0 | 0
Travel | 140000 | 0 | 0 | 0 | 0 | 0
Meals & Entertainment | 60000 | 0 | 0 | 0 | 0 | 0
Office lease | 112500 | 0 | 0 | 0 | 0 | 0
G&A Software | 30000 | 0 | 0 | 0 | 0 | 0
Telephone / Internet | 20000 | 0 | 0 | 0 | 0 | 0
Office Equipment | 100000 | 0 | 0 | 0 | 0 | 0
Professional Services |  | 0 | 0 | 0 | 0 | 0
POE (HR)
Bonuses | based on scale | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total G&A Expenses
G&A Payroll
G&A Payroll Burden
Total G&A Payroll Expense
CY 2013 SALES & MARKETING EXPENSES |  | Month 01 | Month 02 | Month 03 | Month 04 | Month 05 | Month 06 | Month 07 | Month 08 | Month 09 | Month 10 | Month 11 | Month 12 | TOTAL
Marketing & Advertising |  | 0 | 0 | 0 | 0 | 0
Consulting fees | 1000000 | 0 | 0 | 0 | 0 | 0 | 0
Dues & Subscriptions |  | 0 | 0 | 0 | 0 | 0
Graphics & Collateral |  | 0 | 0 | 0 | 0 | 0
Printing & Reproduction |  | 0 | 0 | 0 | 0 | 0
Trade Shows & Events |  | 0 | 0 | 0 | 0 | 0
Travel & Entertainment | 275000 | 0 | 0 | 0 | 0 | 0
Website |  | 0 | 0 | 0 | 0 | 0
Commissions - Account transactions | 0.25
Bonus - Hosting contracts
Commissions - Hosting contracts | 0.0002
Total Sales & Marketing Expense
Sales & Marketing Payroll
Sales & Marketing Payroll Burden
Total Sales & Marketing Payroll Expense
CY 2013 NOC EXPENSES |  | Month 01 | Month 02 | Month 03 | Month 04 | Month 05 | Month 06 | Month 07 | Month 08 | Month 09 | Month 10 | Month 11 | Month 12 | TOTAL
Hub/Switches |  | 0 | 0 | 0 | 0 | 0
Routers |  | 0 | 0 | 0 | 0 | 0
VPN |  | 0 | 0 | 0 | 0 | 0
Firewall |  | 0 | 0 | 0 | 0 | 0
Software (ERP, CRM, PCI) |  | 0 | 0 | 0 | 0 | 0
Outside Technical Services |  | 0 | 0 | 0 | 0 | 0
Miscellaenous |  | 0 | 0 | 0 | 0 | 0
Colocation Services |  | 0 | 0 | 0 | 0 | 0
Total NOC EXPENSE
NOC Payroll
NOC Payroll Burden
Total NOC Payroll Expense
2013 COMBINED MONTHLY EXPENSES
 | 0 - 25K = | 35000
 | 25K - 55K = | 65000
 | 55K - 85K = | 90000
 | Over 85K = | 125000
Spreadsheet: 842374d1694467266-if-and-return-value-based-on-2-sets-of-conditions-sample
Sheet: Sheet1

County | Amount Total | purchased in contract | Blue URL | New GN (Listing) | Renewal GN (Listing) | Payment Type (F, M, Q, S) | New SP | Renewal SP | Payment Type (F, M, Q, S)
Yuma | 1000 | get noticed, social, dues |  |  |  |  |  | 1000 | m
Maricopa | 1500 | power listings/dues |  |  |  |  | 1500 |  | M
Maricopa | 3500 | 3rd tier, dues |  |  |  |  |  | 3500 | M
San Diego | 3000 | Tier 3 |  |  | 3000 | M |  | M
Maricopa | 4500 | bottom banner/4th tier |  |  |  |  |  | 4500 | M
San Diego |  | Torch Awards - SD - Table Sponsor $1,000 | https://bluebbb.org/core/manage/?firm=[PHONE] |  |  |  |  | 1125 | f
San Diego | 2200 | Tier 1 |  |  | 2200 | M |  | M
Orange | 5012 | Tier 1 listing |  | 5012 |  | M
Maricopa | 3000 | tier 2 |  |  | 3000 | M
 | 1000 | Renewal SP
 | 1500 | New SP
 | 3500 | Renewal SP
 | 3000 | Renewal GN (Listing)
 | 4500 | Renewal SP
 | 0 | Renewal SP
 | 2200 | Renewal GN (Listing)
 | 5012 | New GN (Listing)
 | 3000 | Renewal GN (Listing)
Spreadsheet: 795332d1662634665-determine-a-due-date-based-on-tasks-achieved-sample-file
Sheet: Sample

Descriptions | WN34 | WN35
Total Number of  Drawings | 125 |  | 125
Achived Drawings | 43 |  | 45
%
Remaining Drawings |  | 5
Due Date |  |  |  | The formula is to be in the yellow cell based on the remaining drawings number calculated from today
 | (5 dwg / week)
Spreadsheet: 36d87667-e3c5-4502-aa9c-3093d4b902aa
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 |  |  |  |  |  | [NAME], [NAME]
 |  |  |  |  |  | [PHONE]
 |  |  |  | BID TABULATION
BID NUMBER 16-13 |  | Napa Auto Parts | [NAME] | The Parts House | Batteries By Fisher | Safe-Start LLC
AUTOMOTIVE BATTERIES |  | 217 N. 20th Street | 7513 [NAME] | 9828 [NAME] | 1124 Omohundro Ave | 12045 34th Street North
 |  | Tampa, FL 33605 | Tampa, FL 33604 | Tampa, FL 33619 | Lakeland, FL 33809 | St. Petersburg, FL 33716
Opened:  8-15-13
Awarded: 9-9-13
Expires: 9-8-14 |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
Term:  One Year Initial Award with option of a one (1)  year renewal period. |  | Phone:  [PHONE] | Phone:  [PHONE] | Phone:  [PHONE] | Phone: [PHONE] | Phone: [PHONE] x1129
 |  | Fax:  [PHONE] | Fax:  [PHONE] | Fax:  [PHONE] | Fax: [PHONE] | Fax: [PHONE]
1st Renewal Expires: |  | Cell:  [PHONE] |  | Cell:  [PHONE] |  | Cell: [PHONE]
 |  | [EMAIL] | [EMAIL] | [EMAIL] |  | [EMAIL]
BOLD AREA INDICATES AN AWARD
DESCRIPTION / SBM# / CCA – RESERVE CAP
65-60    /    6529   /   850 |  | 69.63 | 52.5 | 75.59 | 56 | 64.15
78-61   /   7827   /   770 |  | 56.46 | 47 | 71.49 | 54 | 57.86
75-60   /   7525   /   690 |  | 54.38 | 44 | 68.6 | 48 | 52.74
58R-60   /   58R25   /   550 |  | 60.5 | 42 | 61.99 | 42 | 51.63
94R   /   94R   /   620 |  | 104.92 | 78 | 97.31 | 90 | 94.03
96R   /   96R   /   590 |  | 69.42 | 58 | 75.42 | 61 | 68.81
Disposal Fee Per Battery |  | 0 | 1.5 | 0 | 1.5 | 1.5
Cost Plus on Batteries Not Listed |  | 0.1 | 0.1 | 0.1 | 0.15 | See Attachment
Warranty Information & Procedure: |  | One year Free Replacement of date code, engraved on side of battery. | 24 Month Free Replacement then 12 month Pro-Rata. | All batteries have a free replacement time of 40 months | 12 Month Free Replacement followed by 24 month  Pro Rated | 18 Month Free Replacement with 18 Month Pro Rated from List
Exceptions
Spreadsheet: 29f79f79-57b2-4e80-aa19-062f87dbca50
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
 | Studentsamskipnaden i Bergen
 | Bestillingsskjema for cateringtjenester
Bestiller:
Deres ref. og tilbud: |  |  | [NAME].: | Tlf.: |  |  | Dato:
 |  |  |  | Fax: |  |  | 2007-02-20 15:08:38.400000
Vare/art.nr. | Vare / tjeneste |  |  |  | Kvantum | Enhet | [NAME] | Beløp
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 | Tilbudssum |  |  |  |  |  |  | 0
 |  |  |  | 14% [NAME] |  |  |  | 0
 | 25% m.v.a.
 | Fakturasum |  |  |  |  |  |  | 0
VARENE |  |  |  | Leveringstid:
sendes til:
 |  |  |  | Betalingsbet.: Netto pr. 30 dager.
Att.: |  |  | Tlf.
FAKTURA |  |  |  | Faktura MÅ merkes:
sendes til:
 |  |  |  | _ _ _ _ _ _
 |  |  |  | Bestillerkode (for UiB/HiB)
For bestillingen gjelder: |  |  |  | Signatur:
[NAME] beskrevet i SiB Cateringbrosjyre eller på www.sibcatering.no.
Leveringsvilkår: [NAME]
(gjelder ikke private eller kvelder/helg) |  |  |  | Stempel og signatur
Merknader:
Dato: |  |  |  | Sendes: | Din lokale studentkafe/SiB Catering
 |  |  |  |  | E-post: [EMAIL] / telefax :55277043
Rekvirent:
Spreadsheet: 856968d1706101687-distribution-of-closing-balance-to-open-pending-invoices-vouchers_-for-ageing-formula
Sheet: Sheet1

Ref No | Voucher No | Voucher Type | [NAME] | Ledger Group | Voucher Date | Voucher Value | Negative Values | Code | Dispute | Pending Bills
58 | 58 | Purchase | Astron Chemicals (India) | Sundry Creditors | 2022-04-08 00:00:00 | 16225 |  | TP2
526 | 526 | Purchase | Astron Chemicals (India) | Sundry Creditors | 2022-06-23 00:00:00 | 16225 |  | TP2
644 | 644 | Payment | Astron Chemicals (India) | Sundry Creditors | 2022-07-16 00:00:00 |  | 22642 | TP2
805 | 805 | Purchase | Astron Chemicals (India) | Sundry Creditors | 2022-09-01 00:00:00 | 1711 |  | TP2
1678 | 1678 | Purchase | Astron Chemicals (India) | Sundry Creditors | 2023-01-25 00:00:00 | 1711 |  | TP2
1826 | 1826 | Purchase | Astron Chemicals (India) | Sundry Creditors | 2023-02-11 00:00:00 | 73750 |  | TP2
2153 | 2153 | Purchase | Astron Chemicals (India) | Sundry Creditors | 2023-03-31 00:00:00 | 5263 |  | TP2
 |  |  | Total
 |  |  | Closing Balance
Spreadsheet: 593978d1539452313-listing-noncontiguous-data-without-blanks-excelforum_samplefile_20181013
Sheet: Sheet1

 |  | That's what I have
 |  |  | A
 |  |  | B
 |  |  | A
 |  |  | C
 |  |  | F
 |  |  | D
 |  |  | B
 |  |  | A
 |  |  | F
 |  | That's what I'd like to have by a (matrix) formula
 |  | The A's and B's from Range C4:C12 without gaps:
 |  | A
 |  | B
 |  | A
 |  | B
 |  | A
Spreadsheet: 62274d1263247046-pull-every-instance-index-match-criteria-into-consecutive-rows-directors-intervention-report-template
Sheet: SAP

Date | Notes
Subtype
Reporter
Advocate
Spreadsheet: 826695d1682171693-i-can-not-paste-text-with-the-formula-cue-file-generator-example
Sheet: Main

Track No’s | Replace Your Time Here | Replace Your Track Names Here | Copy The Formula Below | Copy The MS Word Data Here | TRACK XX AUDIO | INDEX XX MS Word Data | TRACK & INDEX
01 | 00:00:00 | 3 Sarabandes (1887): No. 1 |  | 00:00:00
02 | 00:05:33 | 3 Sarabandes (1887): No. 2 |  | 05:33:00
03 | 00:10:33 | 3 Sarabandes (1887): No. 3 |  | 10:33:00
04 | 00:14:47 | 3 Gymnopédies (1889): No. 1: Lent et douloureux |  | 14:47:00
05 | 00:18:27 | 3 Gymnopédies (1889): No. 2: Lent et triste |  | 18:27:00
06 | 00:21:45 | 3 Gymnopédies (1889): No. 3: Lent et grave |  | 21:45:00
07 | 00:24:38 | Gnossiennes 1-3 (1890): No. 1 |  | 1 day, 0:38:00
08 | 00:28:45 | Gnossiennes 1-3 (1890): No. 2 |  | 1 day, 4:45:00
09 | 00:30:45 | Gnossiennes 1-3 (1890): No. 3 |  | 1 day, 6:45:00
10 | 00:34:11 | Gnossiennes 4-6 (1889-1897): No. 4 |  | 1 day, 10:11:00
11 | 00:37:02 | Gnossiennes 4-6 (1889-1897): No. 5 |  | 1 day, 13:02:00
12 | 00:39:53 | Gnossiennes 4-6 (1889-1897): No. 6 |  | 1 day, 15:53:00
13 | 00:41:27 | 2 Préludes du nazaréen (1892): No. 1, assez lent |  | 1 day, 17:27:00
14 | 00:46:09 | 2 Préludes du nazaréen (1892): No. 2, assez lent |  | 1 day, 22:09:00
15 | 00:49:15 | 2 Prélude de la porte [NAME] ciel (1894) |  | 2 days, 1:15:00
16 | 00:53:00 | 2 Pièces froides (1897), No. 1: Airs a faire fuir: D’une manière très particulaire |  | 2 days, 5:00:00
17 | 00:55:59 | 2 Pièces froides (1897), No. 1: Airs a faire fuir: [NAME] |  | 2 days, 7:59:00
18 | 00:57:42 | 2 Pièces froides (1897), No. 1: Airs a faire fuir: S’inviter |  | 2 days, 9:42:00
19 | 01:00:45 | No 2: Danses de travers: En y regardent à deux fois |  | 2 days, 12:45:00
20 | [NAME] | No 2: Danses de travers: Passer |  | 2 days, 13:39:00
21 | 01:02:25 | No 2: Danses de travers: Encore |  | 2 days, 14:25:00
22 | 01:03:47 | Petite ouverture à danser (1900) |  | 2 days, 15:47:00
Spreadsheet: 729769d1619332623-formula-to-search-the-name-of-cell-c7-from-master-sheet-form-for-help_v1
Sheet: MASTER

EMP ID | NAME | DEPARTMENT | JOB LEVEL
100123 | [NAME] | Quality | LV_07
100456 | [NAME] | Production | LV_08
100789 | Mark | Engineering | LV_09
200123 | Clement | Quality | LV_08
200456 | Alvin | Production | LV_07
200789 | Nico | Engineering | LV_09
Spreadsheet: 725756d1616839716-overtime-hours-between-two-datetimes-relative-to-custom-weekly-schedule-overtime
Sheet: Overtime

Table 1
Day of week | WEEKDAY | Work time start | Work time end | Standard hours worked
Noday | 0 | 00:00:00 | 00:00:00 | 0
Monday | 1
Tuesday | 2
Wednesday | 3
Thursday | 4
Friday | 5
Saturday | 6 | 00:00:00 | 00:00:00
Sunday | 7 | 00:00:00 | 00:00:00
Holidays | 2021-03-27 00:00:00
Holidays | 2021-03-30 00:00:00 |  |  | 0
Holidays | 2021-03-31 00:00:00
Table 2 |  |  |  |  |  | Table 3
Start datetime | Stop datetime | Total hours worked | Standard hours worked | Overtime hours worked |  | Total hours worked | Standard hours worked | Overtime hours worked
2021-03-23 05:00:00 | 2021-03-25 06:00:00 |  | 32
2021-03-23 05:00:00 | 2021-03-25 08:00:00 |  | 33.5
2021-03-23 05:00:00 | 2021-03-25 23:00:00 |  | 48
2021-03-22 22:00:00 | 2021-03-25 23:00:00 |  | 48.50000000011642
2021-03-25 22:00:00 | 2021-03-27 14:30:00 |  | 9.5
2021-03-26 03:00:00 | 2021-03-26 16:30:00 |  | 9
2021-03-26 07:00:00 | 2021-03-29 06:30:00 |  | 8.5
2021-03-29 07:00:00 | 2021-03-31 16:30:00 |  | 15.5
2021-03-29 07:00:00 | 2021-03-30 16:30:00 |  | 15.5
2021-03-27 07:00:00 | 2021-03-28 16:30:00 |  | 0
Spreadsheet: 103921d1301574386-max-formula-help
Sheet: Sheet1

 | Hire Date | 2011-03-29 00:00:00
classes | Day # | expected finish date | actual finish date
class 1 | 1 | 2011-03-29 00:00:00 | 2011-03-29 00:00:00 |  |  | 1 | 5
class 2 | 3 | 2011-04-01 00:00:00 | 2011-04-01 00:00:00 |  |  | 2 | 7
class 3 | 4 | 2011-04-04 00:00:00 | 2011-04-12 00:00:00 |  |  | 3 | 4
class 4 | 8 | 2011-04-08 00:00:00 | 2011-04-14 00:00:00
class 5 | 13 | 2011-04-15 00:00:00
 |  | Expected | Actual
 | Finish Date | 2011-08-02 00:00:00 | 2011-08-09 00:00:00
 |  |  | 2011-08-09 00:00:00
Spreadsheet: joe_parks__14522__ngpl storage
Sheet: Sheet1

 | NGPL NSS
 | Company | Contact | Phone | Status
 | El Paso | [NAME] | [PHONE] | spoke w/ [NAME] the 14th & 18th. They have expressed interest,but have not received
 |  |  |  | a term sheet. Called 12/31 left message
 | Duke | [NAME] | [PHONE] | Called 12/21, 26 and 27. 12/31 left message. Out until the 1/2.
 | Coral | [NAME] | [PHONE] | Sent info on the 26th, she is out until the 1/2
 | Ameren | [NAME] | [PHONE] | Have expressed interest in up to 500,000 [NAME]'s. Have advised they have term
 |  |  |  | sheet by Friday January 4th.
 | Entergy - Koch | [NAME] | [PHONE] | Left message on the 18th, 21st and 31st. No response yet.
 | Alberta Energy | [NAME] | [PHONE] | Left message on the 21st and 31st.
 | Reliant | [NAME] | [PHONE] | Spoke with him on the 27th, sent him info called 12/31 left message.
 | [NAME] | [NAME] | [PHONE] | Not interested, "have canceled all K's with Enron."
 | Dynegy | [NAME] | [PHONE] | Not interested "long at those points already"
 | Nicor Hub | Greg Love | [PHONE] | Not interested " bankrupcy concerns".
 | Peoples | [NAME] | [PHONE] | Enovate 14 BCF long NGPL storage looking to monatize it, would consider including
 |  |  |  | the ENA 2 BCF. Called 12/31 for update, left message.
 | Oneok | [NAME] | [PHONE] | Would make a proposal, but wants the payment to come from the $24 MM ENA
 |  |  |  | owes [NAME].
Spreadsheet: 34372d1231553284-macro-to-search-text-and-return-values-book1
Sheet: Sheet1

State | Code | Result
Texas | ASB | TX APPSVC
Texas | ASNB | 0
Florida | NSB | FL NETSVC
Maine | NSNB | 0
Maine | TBN | ME NETTVL
Oregon | TNB | 0
California | ASB | CA APPSVC
California | ASNB | 0
Ohio | TBA | OH APPSVC
Oregon | NSB | OR APPSVC
New York | ASNB | 0
Maine | ASB | ME APPSVC
Nevada | ASB | NV APPSVC
Arizona | TBA | AZ APPTVL
Arizona | ASB | AZ APPSVC