tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 60020d1260538134-sending-data-from-input-sheet-to-other-sheets-in-a-workbook-copy-of-poss-new-budget-planner
Sheet: Next Catalogue

Next Catalogue
Month | Year | Paymet
2008-01-01 00:00:00 | 2008
2008-02-01 00:00:00 | 2008
2008-03-01 00:00:00 | 2008
2008-04-01 00:00:00 | 2008
2008-05-01 00:00:00 | 2008
2008-06-01 00:00:00 | 2008
2008-07-01 00:00:00 | 2008
2008-08-01 00:00:00 | 2008
2008-09-01 00:00:00 | 2008
2008-10-01 00:00:00 | 2008
2008-11-01 00:00:00 | 2008
2008-12-01 00:00:00 | 2008
2009-01-01 00:00:00 | 2009
2009-02-01 00:00:00 | 2009
2009-03-01 00:00:00 | 2009 | 50
2009-04-01 00:00:00 | 2009 | 50
2009-05-01 00:00:00 | 2009 | 50
2009-06-01 00:00:00 | 2009 | 50
2009-07-01 00:00:00 | 2009 | 50
2009-08-01 00:00:00 | 2009 | 50
2009-09-01 00:00:00 | 2009 | 50
2009-10-01 00:00:00 | 2009 | 50
2009-11-01 00:00:00 | 2009
2009-12-01 00:00:00 | 2009
2010-01-01 00:00:00 | 2010
2010-02-01 00:00:00 | 2010
2010-03-01 00:00:00 | 2010
2010-04-01 00:00:00 | 2010
2010-05-01 00:00:00 | 2010
2010-06-01 00:00:00 | 2010
2010-07-01 00:00:00 | 2010
2010-08-01 00:00:00 | 2010
2010-09-01 00:00:00 | 2010
2010-10-01 00:00:00 | 2010
2010-11-01 00:00:00 | 2010
2010-12-01 00:00:00 | 2010
2011-01-01 00:00:00
2011-02-01 00:00:00
2011-03-01 00:00:00
2011-04-01 00:00:00
2011-05-01 00:00:00
2011-06-01 00:00:00
2011-07-01 00:00:00
2011-08-01 00:00:00
2011-09-01 00:00:00
2011-10-01 00:00:00
2011-11-01 00:00:00
2011-12-01 00:00:00
2012-01-01 00:00:00
2012-02-01 00:00:00
2012-03-01 00:00:00
2012-04-01 00:00:00
2012-05-01 00:00:00
2012-06-01 00:00:00
2012-07-01 00:00:00
2012-08-01 00:00:00
2012-09-01 00:00:00
2012-10-01 00:00:00
2012-11-01 00:00:00
2012-12-01 00:00:00
Spreadsheet: 156569d1337348782-excel-timesheet-issue-overtime-sheet-for-forum
Sheet: Sheet1

Complete Network Technology |  |  |  |  | Name :
Overtime Claim Form |  |  |  |  | Claim for Month Ended:
Date | Day | Time From | Time To | Customer | RT No. | Type of Work | SVR No. | SAP REF. | Hours Claimed |  |  | Total Hours | Toil Hours
 |  |  |  |  |  |  |  |  | X 1.5 | X 2 | TOIL | Worked | Only
 | Working Day | 17:00:00 | 19:00:00
 |  | 17:00:00 | 19:00:00
 |  | 17:00:00 | 19:00:00
 | Rules
 | Working day |  | 09:00 to 17:30
 | Toil (time in lieue) |  | 08:00 to 09:00
 |  |  | 17:30 to 19:00
 | All Other time |  | time and half
 | Employee will
 | Populate fields
 |  | Working Day
 |  | Time From
 |  | Time to
 | Want to automatically populate Overtime Field and Toil fields with calculated hours, based on rules above
 | Have managed to get spreadsheet to work for Sat, Sun and Bank Hols as simple.
 | Working day more complex!
Spreadsheet: 790282d1659624305-vlookup-with-ifs-inside-tables-in-multiple-workbooks-pto-tracking-test
Sheet: Smith, John

[NAME], [NAME] |  | 31.25
 | Start Date: | 2005-08-29 00:00:00
 | Accrual | 224
 | Update Accrual: | N/A
 |  | ACC RATE |  | EARNED |  | USED |  | BALANCE |  | Value
 | Pay Period - Week Ending | PTO Days |  | PTO |  | PTO |  | PTO
 | Beginning Balance |  |  |  |  |  |  | 162.46
17 | 2022-08-12 00:00:00 | 28 |  |  |  | 0
18 |  | 28 |  |  |  | 24
19 |  | 28 |  |  |  | 32
20 |  | 28 |  |  |  | 0
21 |  | 28 |  |  |  | 0
22 |  | 28 |  |  |  | 0
23 |  | 28 |  |  |  | 0
24 |  | 28 |  |  |  | 0
25 |  | 28 |  |  |  | 0
26 |  | 28 |  |  |  | 0
Spreadsheet: 1456ec4d-693a-4cf9-8094-a4adf2448da8
Sheet: Sheet1

Name: [NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Project Name: Women's Dance & Self-Defense for Peace and Empowerment
School: Lewis & Clark College |  |  |  |  |  | TOTAL FUNDS REMAINING:
 |  |  |  |  |  | 0
Total Additional Funding: |  | 4250 |  |  |  | TOTAL EXPENDITURES:
 |  |  |  |  |  | 14250
Student Expenses |  |  |  |  | Project Expenses
Travel (Including Airfare) | Lodging | Communications | Food (Biweekly) | Miscellaneous | Non-Student Travel and Lodging | Direct Equipment and Supplies | Marketing and Event Support | Staffing Costs | Miscellaneous
4220 | 900 | 50 | 280 |  | 1700 | 198 | 10 | 500 | 160
60 |  |  | 280 |  | 500 | 414 | 200 |  | 60
75 |  |  | 200 |  |  | 96
396 |  |  | 180 |  |  | 135
360 |  |  |  |  |  | 735
 |  |  |  |  |  | 200
 |  |  |  |  |  | 95
 |  |  |  |  |  | 1096
 |  |  |  |  |  | 1150
Total | Total | Total | Total | Total | Total | Total | Total | Total | Total
5111 | 900 | 50 | 940 | 0 | 2200 | 4119 | 210 | 500 | 220
Total Student Expenses: |  |  |  |  | Total Project Expenses:
7001 |  |  |  |  | 7249
Spreadsheet: 714045d1611069017-need-help-color-coding-cells-based-on-a-numerical-range-fleet-manager-spreadsheet
Sheet: Sheet1

FLEET NUMBER | MANUFACTURER | SERIAL NUMBER | HOURS | ISSUES | HOURS OF LAST MAINTENANCE | LAST MAINTENACEPERFORMED |  |  |  |  |  |  | NOTES | Location / Job Number | Physical Address | Supervisor | [NAME]
 |  |  |  |  |  | OIL FILTER @ 350 | AIR FILTER @ 500 | OIL @ 350 | PLUGS | HYDR FLUID @ 350 | HYDRO FILTER @ 350 | FUEL FILTER @ 500
JBT-TEL1 | CAT | CATTL1055C | 1254 | HYDRAULIC FORKS WILL NOT RELEASE | 1200 | 1200 | 1000 | 1200 | 700 | 1100 | 1100 | 500
Spreadsheet: 270648d1381568219-formula-for-multiple-matches-to-sum-result-from-another-column-into-another-sheet-justmeok_example
Sheet: Consolidation of gl codes

 | Consolidation of previous years unused codes
OLD GL Code | NEW 2014 GL CODE
6-1274 | same
6-1275 | 6-1250
6-1276 | same
6-2231 | 6-2440
6-2232 | 6-2440
6-2233 | 6-2440
6-2234 | 6-2440
6-2235 | 6-2440
6-2236 | 6-2440
6-2265 | 6-2440
6-2270 | 6-2440
6-2272 | 6-2440
6-2273 | 6-2400
6-2275 | 6-2440
6-2505 | same
6-2520 | same
6-2525 | same
6-2530 | same
6-2540 | same
6-2550 | same
6-2560 | same
6-2565 | same
6-2570 | same
6-2598 | 5-2155
6-2599 | 6-2440
Spreadsheet: 145168d1331331367-way-to-reference-consecutive-column-data-in-subsequent-worksheets-2012-invoice-database_sample
Sheet: Sheet1

 | Hartford Park Homeowners' Association PO Box 140603 [NAME], OK 74014-0006
 |  |  |  |  |  |  |  |  | INVOICE
 |  |  |  |  |  |  |  |  | #N/A
 | Account # |  |  |  |  |  |  |  | Due Date
 |  |  |  |  |  |  |  |  | 2012-05-15 00:00:00
 |  | #N/A | #N/A | #N/A | #N/A | #N/A
 |  | #N/A | #N/A | #N/A | #N/A | #N/A
 |  | #N/A | #N/A | #N/A | #N/A | #N/A
 | Description |  |  |  |  |  |  |  | Sub Total
 | Invoice |  |  |  |  |  |  |  | #N/A
 | Prior Balance |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | Total Balance Due | #N/A
 | Sample
Please detatch the bottom portion and return with your payment
 | Sample |  |  |  |  |  |  |  | Invoice
 |  |  |  |  |  |  |  |  | #N/A
 |  | #N/A |  |  |  |  |  | Due Date | 2012-05-15 00:00:00
 |  | #N/A |  |  |  |  |  | Amount Due | #N/A
 |  | #N/A |  |  |  |  |  | Amount Paid
Spreadsheet: 882204d1730467778-page-merge-page-merge
Sheet: Birleştirme

Durum | [NAME] (Makina) | Kalıp (Alet) | [NAME] (Makina) | [NAME] | [NAME] | [NAME] (Alet) | Sıra No | İşlem [NAME] | İşlem [NAME] | [NAME] (dk) | [NAME] | Tatil (Gün) | Sipariş [NAME] | [NAME] | Miktar | [NAME] | [NAME] | [NAME] | Sipariş [NAME] ([NAME]) | [NAME] | İşEmri No | [NAME] | Gereken | [NAME] | Sipariş
Spreadsheet: 62829d1263836345-is-this-type-of-copy-even-possible-test4-1-
Sheet: TRN

Sub | SOP Name | Identifier | Responsible | Due Date | Authored | Approved | Submitted
DATA346 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA347 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
[NAME] | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA349 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA350 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA351 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA352 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA353 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA354 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA355 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA356 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA357 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA358 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA359 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA360 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA361 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA362 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA363 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA364 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA365 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA366 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA367 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA368 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
[NAME] | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA370 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA371 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
[NAME] | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA373 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA374 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA375 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA376 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA377 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA378 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA379 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA380 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
Spreadsheet: 525519d1498755577-sumif-dont-understand-that-purpose-of-the-offset-inside-sumif-excel_forum_qus
Sheet: Transactions

Transaction History
Account | Date | Num | Payee | Memo | Tag | Category | R | PAYMENT | DEPOSIT | Account Balance | BALANCE
Checking | 2014-01-01 00:00:00 |  |  |  |  | [Balance] | R |  | 875
Savings | 2014-01-01 00:00:00 |  |  |  |  | [Balance] | R |  | 2345
BobsCard | 2014-01-01 00:00:00 |  |  |  |  | [Balance] | R | 256
Checking | 2014-01-01 00:00:00 |  |  |  |  | Wages & Tips | R |  | 1000
Checking | 2014-01-10 00:00:00 |  |  |  |  | Vehicle Payments | R | 115.2
BobsCard | 2014-01-15 00:00:00 |  |  |  |  | Groceries | R | 87.34
BobsCard | 2014-01-18 00:00:00 |  |  |  |  | Gas/Oil | R | 100
Checking | 2014-02-05 00:00:00 |  |  |  |  | Wages & Tips | c |  | 1000
Checking | 2014-02-10 00:00:00 |  |  |  |  | Electricity |  | 23.1
Checking | 2014-02-10 00:00:00 |  |  |  |  | Gas/Oil |  | 45.15
Checking | 2014-02-10 00:00:00 |  |  |  |  | Home/Rental Insurance |  | 25.04
Savings | 2014-02-15 00:00:00 |  | [From Checking] |  |  | [Transfer] |  |  | 200
Checking | 2014-02-15 00:00:00 |  | [To Savings] |  |  | Home/Rental Insurance |  | 100
Checking | 2014-02-15 00:00:00 |  | [To Savings] |  |  | Home/Rental Insurance |  | 50
Checking | 2014-02-15 00:00:00 |  | [To Savings] |  |  | Home/Rental Insurance |  | 50
 |  |  | BobsCard
 |  |  | ***** INCOME *****
=SUMIF(A$3:OFFSET(A4,0,0,1,1),"="&A4,J$3:OFFSET(J4,0,0,1,1))-SUMIF(A$3:OFFSET(A4,0,0,1,1),"="&A4,I$3:OFFSET(I4,0,0,1,1))
 |  | TRIED THE SAME BUT WITHOUT OFFSETS; SAME RESULT
 | 0.08 | 0.005
 |  | 4
Spreadsheet: 694847d1599837205-depreciation-computation-in-a-single-row-depreciation-computation
Sheet: Sheet1

 | Depreciation Computation
 | Shelf Life (years) | 5
 |  | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10 | Total
 | Capex | 46000 | 39000 | 45000 | 23000 | 45000 | 10000 | 21000 | 40000 | 37000 | 43000
 | Depreciation for
 | Year 1 Capex
 | Year 2 Capex
 | Year 3 Capex
 | Year 4 Capex
 | Year 5 Capex
 | Year 6 Capex |  |  |  |  |  |  |  |  |  |  |  |  | this is how I calculate the depreciation
 | Year 7 Capex
 | Year 8 Capex
 | Year 9 Capex
 | Year 10 Capex
 | Total Depreciation
 | Total Depreciation |  |  |  |  |  |  |  |  |  |  |  |  | this single row is what is desired
 |  | formula required to calculate depreciation based on shelf life, without the details in the table above
Spreadsheet: 18cac5fa-3901-407a-adc8-079e7d607e86
Sheet: RESUMEN

CUADRO RESUMEN EVALUACION FINANCIERA - INDICADORES FINANCIEROS
ICFES-CP-006-2013.-OBJETO: [NAME] [NAME] contrato de prestación de servicios de aseo, [NAME] necesarios [NAME] y preservación de los bienes muebles e inmuebles del ICFES, al igual que los servicios de cafetería para brindar el apoyo necesario que contribuya [NAME], incluyendo el suministro de los insumos requeridos [NAME] y el servicio de cafetería, todo lo cual es fundamental [NAME] y óptimo funcionamiento del ICFES.
SUBDIRECCION FINANCIERA Y CONTABLE
PROPONENTE | III.C. CONDICIONES FINANCIERAS MINIMAS |  |  |  |  |  |  |  |  | VERIFICACION INDICADORES FINANCIEROS | VERIFICACION DOCUMENTOS FINANCIEROS
 | CAPITAL DE TRABAJO =  Ó> A 20% VPO ($566,796,100) *(1) |  |  | NIVEL DE ENDEUDAMIENTO = Ò < AL 70% A.T. |  |  | INDICE PATRIMONIAL =  Ò > A 0.5   VECES (CERO PUNTO CINCO VECES)
 | REQUERIDO PLIEGO | CAPITAL DE TRABAJO | EVALUADO | REQUERIDO PLIEGO | % | EVALUADO | REQUERIDO PLIEGO | INDICE | EVALUADO
 |  |  | CUMPLE | =  ó < AL 70% DEL ACTIVO TOTAL |  | CUMPLE | = Ó > A 0.5 (CERO PUNTO CINCO) |  | CUMPLE | CUMPLE | CUMPLE
 |  |  | CUMPLE | =  ó < AL 70% DEL ACTIVO TOTAL |  | CUMPLE | = Ó > A 0.5 (CERO PUNTO CINCO) |  | CUMPLE | CUMPLE | CUMPLE
OBSERVACIONES:
*(1)  El capital de Trabajo se evaluo con [NAME] 20% (igual o mayor), por  principio de favorabilidad según lo informado via correo electrónico por la Subdirección de Abastecimiento.
 | ORIGINAL FIRMADO |  |  |  |  | ORIGINAL FIRMADO
 | [NAME] PLAZAS BONILLA |  |  |  | [NAME]
 | SUBDIRECTOR FINANCIERO Y CONTABLE |  |  |  | PROFESIONAL SUBDIRECCION  FINANCIERA - CONTABLE
2013-05-15 00:00:00
Spreadsheet: sara_shackleton__37814__Orlando Utilities Comm II
Sheet: ANEWSWP2

ISDA SWAP AGREEMENT INFORMATION SHEET
 |  | ATTORNEY:
DATE: | 2001-10-09 00:00:00 | DEAL MAKER: | [NAME]
COUNTERPARTY: | Orlando Utilities Commission | CONTACT:
ADDRESS: | 500 S. Orange Ave. | TITLE:
 | Orlando, Fl  32801 | PHONE:
 |  | FAX:
Incorporation State | political entity | S&P Rating | AA- (mun. bond)
STRUCTURE | COUNTERPARTY | ECT
GUARANTOR (RATING) | NA | Enron Corp (BBB+)
LIMIT $ MILLIONS |  | $15MM
Incorporation State |  | Oregon
COLLATERAL  THRESHOLD
Specify Type of Debt:
COLLATERAL TYPE
Letter of Credit | OK | OK
Cash | OK | OK
MINIMUM TRANSFER $ | 1 | 1
COLLATERAL ROUNDING
Delivery Amount | 250000 | 250000
Return Amount | 250000 | 250000
HOLDING and USE OF COLLATERAL
Permitted
Minimum S & P/Moody's
rating permitted
MATERIAL ADVERSE CHANGE TRIGGERS - if Matrix not applicable
APPLY TO:
-Counterparty | X
-Guarantor |  | X
Debt Ratings Change | X | X
-Below = S&P/Moody's | A | BBB- | S&P
Financial Covenants | "long term debt…" | "long term senior unsecured….."
-Funded debt/Worth
-Minimum Net Worth
-Cash Flow/CMLTD
Non-Specific
-Unilateral
Non-Standard Definitions
-Funded Debt
-Net Worth
EVENTS OF DEFAULT
3rd party debt | X | X
-Counterparty ($[NAME]) | $60MM
-Guarantor ($[NAME]) |  | $100MM
Change in ownership
FINANCIAL STATEMENTS
-Standard | X | X
- Request financials on:
CREDIT DECISION: | APPROVED :  X | DECLINED:
OUTSTANDING SWAP TRANSACTIONS: |  | YES:    X | NO:
ALL SWAPS TO ROLL UP UNDER NEW MASTER: |  | YES:    X | NO:
CREDIT PROVISIONS OF MASTER TO GOVERN: |  | YES:    X | NO:
OTHER COMMENTS:
CREDIT REVIEW  PREPARED BY: |  | [NAME] | x5-3596
Spreadsheet: 114548d1310279977-excel-2007-create-pivot-from-2007-back-in-2003-pivot-exampe
Sheet: Sheet7

Program | (All)
equipment type | (All)
status | (All)
Row Labels | Sum of Asserted | Sum of Recovered
BE
D | 100 | 0
I | 298 | 200
GE
C | 800 | 66
F | 566 | 566
H | 10 | 10
Honeywell
A | 78 | 78
G | 700 | 400
M | 44 | 9
KHI
K | 100 | 100
N | 66 | 7
MHI
L | 88 | 88
Spirit
E | 42 | 42
J | 12 | 0
Trimph
B | 99 | 77
Grand Total | 3003 | 1643
Spreadsheet: 472264d1469522463-converting-data-between-tabs-department-performance-current
Sheet: 349732

TEAM
349732 |  | [NAME]
 |  |  | RCV Goal = 30 PPH |  |  | FH Goal = 30 PPH |  |  | [NAME] = 20 PPH
Week |  |  | RCV Qty | RCV Time | RCV PPH | FH  Qty | FH  Time | FH  PPH | RCH  Qty | RCH  Time | RCH  PPH | Average PPH | Total Time | Notes
2016-07-03 00:00:00 | - |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2016-07-10 00:00:00 | -
2016-07-17 00:00:00 | -
2016-07-24 00:00:00 | -
2016-07-31 00:00:00 | -
2016-08-07 00:00:00 | -
2016-08-14 00:00:00 | -
2016-08-21 00:00:00 | -
2016-08-28 00:00:00 | -
2016-09-04 00:00:00 | -
2016-09-11 00:00:00 | -
2016-09-18 00:00:00 | -
2016-09-25 00:00:00 | -
2016-10-02 00:00:00 | -
2016-10-09 00:00:00 | -
2016-10-16 00:00:00 | -
2016-10-23 00:00:00 | -
2016-10-30 00:00:00 | -
2016-11-06 00:00:00 | -
2016-11-13 00:00:00 | -
2016-11-20 00:00:00 | -
2016-11-27 00:00:00 | -
2016-12-04 00:00:00 | -
2016-12-11 00:00:00 | -
2016-12-18 00:00:00 | -
2016-12-25 00:00:00 | -
 |  | TOTAL
Spreadsheet: 166534d1341610853-filling-a-table-using-a-database-while-finding-the-nearest-value-for-two-parameter-ph
Sheet: Sheet1

 |  |  | X
 |  |  | 10 | 20 | 30 | 40 | 50 | 60
 | Y | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 |  | 6
 |  | 7
 |  |  |  |  |  |  |  |  |  |  | X | Y | Ph
 |  |  |  |  |  |  |  |  |  |  | 10 | 1
 |  |  |  |  |  |  |  |  |  |  | 20 | 5
 |  |  |  |  |  |  |  |  |  |  | 34 | 7
 |  |  |  |  |  |  |  |  |  |  | 42 | 3
 |  |  |  |  |  |  |  |  |  |  | 59 | 4
Spreadsheet: 769122d1645318032-sumifs-formula-not-summing-numerical-range-based-on-date-range-sumifs-test-book
Sheet: 2022 Season Estimates

2022  Actuals | 1 BR Nights | 1 BR Paid | 2 BR Nights | 2 BR Paid | 3 BR Nights | 3 BR Paid | 6 BR Nights | 6 BR Paid
January
February
March
April
May
June
July
August
September
October
November
December
TOTALS
Hash Total
Date | Type | Confirmation Code | Start Date |  |  |  |  | Nights | Guest | Listing | Details | Reference | Currency | Amount | Paid Out | Host Fee | Cleaning Fee
2022-07-08 00:00:00 | Reservation | HM9KC23HZ4 | 2022-08-19 00:00:00 |  |  | 2022-07-07 00:00:00 |  | 3 | [NAME] | 2 BR Apartment Downtown - Pool Opens 8/1 - 10/2 |  |  | USD | 1154.3 |  | 35.7 | 125
2022-07-15 00:00:00 | Reservation | HMDE35XCH8 | 2022-07-07 00:00:00 |  |  | 2022-07-14 00:00:00 |  | 3 | [NAME] | 2 BR Apartment Downtown - Pool Opens 8/1 - 10/2 |  |  | USD | 1154.3 |  | 35.7 | 125
2022-08-18 00:00:00 | Reservation | [NAME] | 2022-08-19 00:00:00 |  |  | 2022-08-17 00:00:00 |  | 3 | [NAME] | 2 BR Apartment Downtown - Pool Opens 8/1 - 10/2 |  |  | USD | 1096.1 |  | 33.9 | 125
2022-07-02 00:00:00 | Reservation | HMC9TFMDDP | 2022-07-01 00:00:00 |  |  | 2022-07-01 00:00:00 |  | 3 | [NAME] | 3 BR Apartment Downtown - Pool Opens 8/1 - 10/2 |  |  | USD | 1678.1 |  | 51.9 | 125
2022-08-20 00:00:00 | Reservation | HMH4TDBH33 | 2022-07-14 00:00:00 |  |  | 2022-08-19 00:00:00 |  | 3 | Vinal [NAME] | 3 BR Apartment Downtown - Pool Opens 8/1 - 10/2 |  |  | USD | 1731.45 |  | 53.55 | 150
2022-08-20 00:00:00 | Reservation |  | 2022-07-06 00:00:00 |  |  |  |  | 3 |  | 1 BR Apartment Downtown - Pool Opens 8/1 - 10/2 |  |  | USD | 843.9 |  | 26.1 | 75
2022-07-08 00:00:00 | Reservation |  | 2022-07-07 00:00:00 |  |  |  |  | 3 |  | 2 BR Apartment Downtown - Pool Opens 8/1 - 10/2 |  |  | USD | 1154.3 |  | 35.7 | 125
2022-08-20 00:00:00 | Reservation |  | 2022-08-19 00:00:00 |  |  |  |  | 3 |  | 3 BR Apartment Downtown - Pool Opens 8/1 - 10/2 |  |  | USD | 1731.45 |  | 53.55 | 150
2022-07-02 00:00:00 | Reservation |  | 2022-07-01 00:00:00 |  |  |  |  | 3 |  | 3 BR Apartment Downtown - Pool Opens 8/1 - 10/2 |  |  | USD | 1678.1 |  | 51.9 | 125
2022-07-15 00:00:00 | Reservation |  | 2022-07-14 00:00:00 |  |  |  |  | 3 |  | 2 BR Apartment Downtown - Pool Opens 8/1 - 10/2 |  |  | USD | 1154.3 |  | 35.7 | 125
2022-07-14 00:00:00 | Reservation |  | 2022-07-13 00:00:00 |  |  |  |  | 4 |  | 3 BR Apartment Downtown - Pool Opens 8/1 - 10/2 |  |  | USD | 2260.1 |  | 69.9 | 150
2022-08-18 00:00:00 | Reservation |  | 2022-08-17 00:00:00 |  |  |  |  | 3 |  | 2 BR Apartment Downtown - Pool Opens 8/1 - 10/2 |  |  | USD | 1096.1 |  | 33.9 | 125
Spreadsheet: 710339d1608854404-help-pulling-data-from-a-range-copy-of-attendance-template-w-formula
Sheet: October

Employee Absence Schedule
October | Dates of Absence
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
Employee Name | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | CI | T | NCNS | Total Points
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Obed Attamah
[NAME]
[NAME]
Keath Grimes
[NAME]
[NAME]
[NAME]
[NAME]
Spreadsheet: 32404d1228516628-vlookup-formula-sample-of-vlooup
Sheet: 1

RECIPE CALCULATOR
ingredient | servings in recipe | serving size as per label | cal / serving | total calories | fat | total fat | sat fat | total sat fat | carbs | total carbs | sugar | total sugar | fiber | total fiber | protein | total protein |  | sodium | total sodium | calcium | total calcium | chol | total cholesterol
Land o Lakes fresh Buttery Taste Spread (14 grams) | 2.5 | 14 | 70 | 8 | 8 | 1.428571428571429 | 2 | 0.3571428571428572 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 80 | 14.28571428571429 | 0 | 0 | 0 | 0 |  | DIRECTIONS:
Apple, raw without skin - 100 grams edible portion |  | 100 | 48 | 0.13 | 0.13 | 0 | 0.021 | 0 | 12.76 | 0 | 10.1 | 0 | 1.3 | 0 | 0.27 | 0 |  | 0 | 0 | 5 | 0 | 0 | 0 |  | this granulated sugar is located above the potato on food list
Vanilla Extract (tsp) | 1 | 1 | 12 | 0 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Sugar, Granulated - 1 cup |  | 1 | 774 | 0 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  | this granulated sugar is located below the vanilla
[NAME] all purpose enriched, unbleached (cup) |  | 1 | 455 | 1.23 | 1.23 | 0 | 0.194 | 0 | 95.39 | 0 | 0.34 | 0 | 3.4 | 0 | 12.91 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0
Vanilla Extract (tsp) |  | 1 | 12 | 0 | 0 | #N/A | 0 | #N/A | 0.53 | #N/A | 0.53 | #N/A | 0 | #N/A | 0 | #N/A |  | 0 | #N/A | 0 | #N/A | 0 | #N/A |  | this vanilla is located at same place on food list as vanilla exract on line 6
Sugar, Granulated - 1 cup |  | 1 | 774 | 0 | 0 | #N/A | 0 | #N/A | 199.96 | #N/A | 199.82 | #N/A | 0 | #N/A | 0 | #N/A |  | 0 | #N/A | 0 | #N/A | 0 | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | this granulated sugar is also located below the vanilla but now the vlookup is working and showing the information instead of #N/A
total calories per recipe ===> | 9.360000000000001
servings per recipe ===>
calories per serving ===>
fat per recipe === > | #N/A
fat per serving ===>
sat fat per recipe ===> | #N/A
sat fat per serving ===>
carbs per recipe ===> | #N/A
carb per serving ===>
sugar per recipe ===> | #N/A
sugar per serving ===>
fiber per recipe ===> | #N/A
fiber per serving ===>
protein per recipe ===> | #N/A
protein per serving ===>
Spreadsheet: 478516d1472828847-multiple-occurences-consolidate-notes-from-multiple-occurrences
Sheet: Sheet1

Name | Date | Notes |  | Name | Output
[NAME] | 2016-04-15 00:00:00 | Quarterly visits required. |  | [NAME] | Quarterly visits required. Absent. Hospitalized.
[NAME] | 2016-04-25 00:00:00 | N/A |  | [NAME] | N/A
[NAME] | 2016-04-26 00:00:00 | Lapse of FF visits. |  | [NAME] | Lapse of FF visits. Lapse of FF visits.
[NAME] | 2016-04-15 00:00:00 | Absent.
[NAME] | 2016-04-10 00:00:00 | Lapse of FF visits.
[NAME] | 2016-04-25 00:00:00 | Hospitalized.
Spreadsheet: rick_buy__32946__raptor2c
Sheet: Summary

 | Raptor II Daily Position Report & Summary
 | Inputs:
 | Trade Date |  | Prior Day
 | Summary:
 | Gains and Losses | Total | Realized | Unrealized
 | Previous Day's Cumulative
 | Today's Activity
 | Cumlative Ending
 | Notional Capacity
 | Credit Capacity
 | Remaining Governance Capacity
Spreadsheet: 2047a074-374d-4a16-916f-3e82e3d8267e
Sheet: FA 22 - Data

[NAME]
Focus Area 22 - Physical Activity and Fitness - Pennsylvania
Objective Number | Objective Title | Baseline Data | Final Data | HP2010 Goal | Target Progress
22-01 | Adults who Engage in no Leisure-Time Physical Activity (age-adjusted percentage) | 24 ± 2 (2001) | 25 ± 1 (2009) | 20 | Moved away from target
22-02 | Adults who Engage in Moderate or Vigorous Physical Activity (age-adjusted percentage) | 47 ± 2 (2001) | 51 ± 2 (2009) | 50 | Met or exceeded target
22-03 | Adults who Engage in Vigorous Physical Activity (age-adjusted percentage) | 25 ± 2 (2001) | 29 ± 2 (2009) | 30 | Moved toward target
Note: The list of objectives above are limited to those for which Pennsylvania data were available.