tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 548122d1510876799-timesheet-time-calculation-for-multiple-jobs-type-weekly-timesheet-multiple-jobs
Sheet: Weekly Timesheet

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Weekly Time Sheet
 |  |  |  |  |  |  |  | Deprtment |  |  | [Department]
 |  |  |  |  |  |  |  | Employee's ID |  |  | [ABC123456]
 |  |  |  |  |  |  |  | Employee: |  |  | [Name]
 |  |  |  |  |  |  |  | Employee's phone: |  |  | [[PHONE]]
 |  |  |  |  |  |  |  | Employee's e-mail: |  |  | [EMAIL]
 |  |  |  |  |  |  |  | Manager: |  |  | [Name]
 |  |  |  |  |  |  |  | Week Commencing: |  |  | 2013-12-08 00:00:00
 |  |  |  |  |  |  |  | Week Ending:
Customer
Time In |  | 13:00:00 | Total | 08:00:00 | Total | 08:00:00 | Total | 09:00:00 | Total | 09:00:00 | Total |  | Total |  | Total
Time Out |  | 15:00:00 |  | 12:00:00 |  | 12:00:00 |  | 16:00:00 |  | 12:00:00
Customer
Time In |  | 16:00:00 | Total | 15:00:00 | Total | 13:00:00 | Total | 18:00:00 | Total | 14:00:00 | Total |  | Total |  | Total
Time Out |  | 18:00:00 |  | 20:00:00 |  | 16:00:00 |  | 23:00:00 |  | 18:00:00
Customer
Time In |  | 20:00:00 | Total | 22:00:00 | Total | 18:00:00 | Total |  | Total | 19:00:00 | Total |  | Total |  | Total
Time Out |  | 23:00:00 |  | 01:00:00 |  | 00:00:00 |  |  |  | 00:00:00
Customer
Time In |  | 00:00:00 | Total |  | Total |  | Total |  | Total |  | Total |  | Total |  | Total
Time Out |  | 02:00:00
Customer
Time In |  |  | Total |  | Total |  | Total |  | Total |  | Total |  | Total |  | Total
Time Out
Customer
Time In |  |  | Total |  | Total |  | Total |  | Total |  | Total |  | Total |  | Total
Time Out
Customer
Time In |  |  | Total |  | Total |  | Total |  | Total |  | Total |  | Total |  | Total
Time Out
Customer
Time In |  |  | Total |  | Total |  | Total |  | Total |  | Total |  | Total |  | Total
Time Out
Total
Total Reported Hours:
 |  |  |  |  |  |  | Employee's signature |  |  |  |  |  |  | Date
 |  |  |  |  |  |  | Manager's signature |  |  |  |  |  |  | Date
Spreadsheet: 825825d1681559496-correction-of-the-indirect-timetable-formula-2023-draft-dailykode-1-
Sheet: TIMETABLE

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-04-14 00:00:00
GR. 1 | Nr. [NAME]. | ID | Name |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TIME WORKED | TOTAL WORKED
 | 1 | 111 | Jhon |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WORK HOURS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SCREEN HOURS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NIGHT HOURS
 | 2 | 112 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WORK HOURS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SCREEN HOURS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NIGHT HOURS
 | 3 | 113 | Adalyn |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WORK HOURS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SCREEN HOURS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NIGHT HOURS
 | 4 | 114 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WORK HOURS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SCREEN HOURS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NIGHT HOURS
 | 5 | 115 | Beverly |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WORK HOURS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SCREEN HOURS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NIGHT HOURS
Spreadsheet: 822350d1679296695-merging-all-years-based-on-name-book1_name
Sheet: Sheet1

Year | Name |  | Result |  |  | Merged | NewColumn.Name |  |  |  |  | start | end
2000 | [NAME] |  | 2000-2016 | [NAME] |  | 2000-2016 | Rachel |  |  |  |  | 2000 | 2016
2001 | [NAME] |  | 2006 | [NAME] |  | 2000-2016 | [NAME] |  |  |  |  | 2006 | 2006
2002 | [NAME] |  | 2009-2010 | [NAME] |  | 2000-2016 | [NAME] |  |  |  |  | 2009 | 2010
2003 | [NAME] |  | 2009-2014 | Rachel |  | 2006-2006 | [NAME] |  |  |  |  | 2009 | 2014
2004 | [NAME] |  | 2016-2017 | Rachel |  | 2006-2006 | [NAME] |  |  |  |  | 2016 | 2017
2005 | [NAME] |  |  |  |  | 2009-2010 | Rachel
2006 | [NAME] |  |  |  |  | 2009-2010 | [NAME]
2007 | [NAME] |  |  |  |  | 2009-2010 | [NAME]
2008 | [NAME] |  |  |  |  | 2009-2014 | Rachel
2009 | [NAME] |  |  |  |  | 2009-2014 | [NAME]
2010 | [NAME] |  |  |  |  | 2009-2014 | [NAME]
2011 | [NAME] |  |  |  |  | 2016-2017 | Rachel
2012 | [NAME] |  |  |  |  | 2016-2017 | [NAME]
2013 | [NAME]
2014 | [NAME]
2015 | [NAME]
2016 | [NAME]
2006 | [NAME]
2009 | [NAME]
2010 | [NAME]
2009 | Rachel
2009 | Rachel
2010 | Rachel
2011 | Rachel
2012 | Rachel
2013 | Rachel
2014 | Rachel
2016 | Rachel
2017 | Rachel
Spreadsheet: 49039d1248302263-mileage-tariffs-for-a-taxi-taxi-tarrif
Sheet: Sheet1

Pick Up Cost | $ | [NAME] (by distance) | Cost in $  per mile |  | miles | [NAME] | Total $
Standard Rate | 2.3 | 0 - 1 mile | 1 |  | 0 - 1 | 1 | 1
 |  | 1.1 - 5 miles | 0.8 |  | 1.1 - 2 | 0.8 | 1.8
 |  | 5.1 - 10 miles | 0.75 |  | 2.1 - 3 | 0.8 | 2.6
 |  | 10.1 - 20 miles | 0.7 |  | 3.1 - 4 | 0.8 | 3.4
 |  | Please Enter The Distance Travelled in miles > | 2 |  | 4.1 - 5 | 0.8 | 4.2
 |  |  |  |  | 5.1 - 6 | 0.75 | 4.95
 |  | (New forumla) Tarriff  totaled by each tarrif along the journey in $ | 2 |  | 6.1 - 7 | 0.75 | 5.7
 |  |  |  |  | 7.1 -8 | 0.75 | 6.45
 |  |  |  |  | 8.1 - 9 | 0.75 | 7.2
 |  |  |  |  | 9.1 - 10 | 0.75 | 7.95
 |  | (original formula) Total Final Travel [NAME] cost in $ | 1.6
 |  | 2
Spreadsheet: 862036d1709828975-need-help-with-formula-book1-31-
Sheet: Sheet1

M-EID | Full Name | Notified | Segment | Segment Definition | Reason | OVR | Mo | Day | Date | Start-AZ | End-AZ | Lunch | Hours | Decimal | UTO Hrs | Daily Hrs | Total Hrs |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00
57402 | [NAME] | Yes | LATE | Late-Arrival, Lunch, Break | Dependent Care | No | Jan-24 | Tue | 2024-01-02 00:00:00 | 10:00:00 | 11:00:00 | 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-03-31 00:00:00 |  | 04:00:00
57402 | [NAME] | Yes | LATE | Late-Arrival, Lunch, Break | Personal | No | Jan-24 | Tue | 2024-01-02 00:00:00 | 10:00:00 | 11:00:00 | 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-06-30 00:00:00 |  | 0.5
57402 | [NAME] | Yes | ULE | Unplanned Leave Early | Personal | No | Jan-24 | Tue | 2024-01-02 00:00:00 | 10:00:00 | 12:00:00 | 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-09-30 00:00:00 |  | 1
57402 | [NAME] | No | NCNS | No Call No Show | Personal | No | Jan-24 | Fri | 2024-01-12 00:00:00 | 10:00:00 | 12:00:00 | 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-12-31 00:00:00
57402 | [NAME] | Yes | LATE | Late-Arrival, Lunch, Break | OUT-IN_Internet no/Doc | No | Jan-24 | Mon | 2024-01-15 00:00:00 | 10:00:00 | 12:00:00 | 00:00:00
57402 | [NAME] | Yes | ABS | Absence-Full Day | Personal | No | Feb-24 | Thu | 2024-02-15 00:00:00 | 08:00:00 | 16:30:00 | 00:30:00
57402 | [NAME] | Yes | ABS | Absence-Full Day | Personal | No | Feb-24 | Fri | 2024-02-16 00:00:00 | 08:00:00 | 16:30:00 | 00:30:00
57402 | [NAME] | Yes | LATE | Late-Arrival, Lunch, Break | Personal | No | Feb-24 | Mon | 2024-02-19 00:00:00 | 10:00:00 | 11:30:00 | 00:00:00
533928 | [NAME] | Yes | ABS | Absence-Full Day | Sick-No PSL | No | Jan-24 | Tue | 2024-01-02 00:00:00 | 07:30:00 | 16:00:00 | 00:30:00
533928 | [NAME] | Yes | ABS | Absence-Full Day | Sick-No PSL | No | Feb-24 | Wed | 2024-02-28 00:00:00 | 07:30:00 | 16:00:00 | 00:30:00
533928 | [NAME] | Yes | LATE | Late-Arrival, Lunch, Break | Personal | No | Mar-24 | Fri | 2024-03-01 00:00:00 | 07:30:00 | 07:52:00 | 00:00:00
Spreadsheet: 175108d1345395009-lookup-average-value-over-multiple-sheets-pt-consolidate-excel-20
Sheet: Master

Average cases
Name | Average Cases
Greg | 15
[NAME] | 13.5
[NAME] | 11
[NAME] | 29
[NAME] | 4
Average of Value | Column
Row | Cases | Performance | Grand Total
[NAME] | 13.5 | 0.77 | 7.135
Greg | 15 | 0.8 | 7.9
[NAME] | 29 | 0.85 | 14.925
[NAME] | 4 | 0.37 | 2.185
[NAME] | 11 | 0.78 | 5.89
Grand Total | 13.85714285714286 | 0.7314285714285714 | 7.294285714285714
Spreadsheet: 0f7357e0-961f-4d06-bc16-b941c7b5dd20
Sheet: Sheet1

COURT OF CHANCERY COURTROOM CALENDAR FOR THE WEEK OF OCTOBER 27, 2014 THROUGH OCTOBER 31, 2014 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
TIME | CASE # | JUDGE | PROCEEDING | CASE CAPTION | SITE
Monday, October 27, 2014
10:00:00 |  | Vice Chancellor [NAME] | Guardianship Hearing |  | [NAME]
10:00:00 | CA#10115-ML | Master [NAME] | Hearing | IMO Gove Real Estate | [NAME]
11:30:00 | CA#8395-VCG | Vice Chancellor Glasscock | Hearing | [NAME] [NAME] | Georgetown
01:00:00 | CA#9026-VCG | Vice Chancellor Glasscock | Hearing | Belendiuk v. Carrion | Georgetown
Tuesday, October 28, 2014
09:30:00 | CA#9211-MA | Master [NAME] | Hearing | Lofland v. [NAME] | Georgetown
10:00:00 | CA#10055-VCG | Vice Chancellor Glasscock | Oral Argument | [NAME] 09 Fam. Trust v. Revelations Perfume & Cosmetics | Georgetown
10:00:00 | CA#9809-VCN | Vice Chancellor [NAME] | Oral Argument | Capella Holdings, Inc. v. [NAME] | Dover
10:30:00 |  | Master [NAME] | Guardianship Hearing |  | Georgetown
02:00:00 | CA#8933-VCG | Vice Chancellor Glasscock | Settlement Hearing | In re Boise, Inc. [NAME] | Georgetown
02:00:00 | CA#9546-ML | [NAME] | Hearing | IMO LW&T of [NAME] | [NAME]
03:00:00 | CA#8897-VCG | Vice Chancellor Glasscock | Oral Argument | [NAME] v. Sagerman | Georgetown
Wednesday, October 29, 2014
10:00:00 | CA#9360-VCN | Vice Chancellor [NAME] | Hearing | Hartley v. Consolidated Glass Holdings, Inc. | Dover
Thursday, October 30, 2014
09:15:00 |  | Chancellor [NAME] | Guardianship Trial |  | [NAME]
09:30:00 | CA#9574-VCL | Vice Chancellor [NAME] | Oral Argument | In the Matter of the Liquidation of Freestone Insurance Company | [NAME]
10:00:00 | CA#6611-VCG | Vice Chancellor Glasscock | Trial | [NAME] vs. [NAME] | Georgetown
01:30:00 | CA#9629-VCN | Vice Chancellor [NAME] | Hearing | JPMorgan Chase Bank, N.A. v. Hartnett | Dover
Friday, October 31, 2014
09:15:00 |  | Chancellor [NAME] | Guardianship Trial |  | [NAME]
10:00:00 | CA#10093-VCL | Vice Chancellor [NAME] | PI Hearing | In re Kinder Morgan Energy Partners LP Unitholders Litigation | [NAME]
10:00:00 | CA#9215-VCP | Vice Chancellor Parsons | Hearing | Kestenbaum v. [NAME] | [NAME]
01:00:00 | CA#9428-VCL | Vice Chancellor [NAME] | Oral Argument | Colfax Corp. S'holder [NAME]. [NAME]. | [NAME]
01:30:00 | CA#8700-VCG | Vice Chancellor Glasscock | Oral Argument | Vansant v. Ocean Dunes Condominium | Georgetown
Spreadsheet: 538177d1505437810-pulling-unique-data-from-a-table-a-certain-number-of-times-advanced-interpretting-data-1-
Sheet: Sandy's Table

Name | Job 1 | Code 1
[NAME] | 247 - Dixon Stage 5 | 08-Other
 | 250 - 132 Kay Rd Subdivision | 02-Roading
 |  | 03-Stormwater
 | 252 - Kay Rd Cutdown | 03-Stormwater
Adam Young Total
[NAME] | 001 - Office | 08-Other
 | 247 - Dixon Stage 5 | 08-Other
 | 250 - 132 Kay Rd Subdivision | 02-Roading
 |  | 03-Stormwater
 |  | 08-Other
[NAME]
[NAME] | 250 - 132 Kay Rd Subdivision | 06-Concrete
 |  | 08-Other
 | 252 - Kay Rd Cutdown | 02-Roading
 |  | 07-Environmental
 |  | 08-Other
[NAME]
Jury [NAME] | 250 - 132 Kay Rd Subdivision | 02-Roading
 |  | 03-Stormwater
 | 252 - Kay Rd Cutdown | 02-Roading
 |  | 07-Environmental
Jury Herewini Total
[NAME] | 250 - 132 Kay Rd Subdivision | 02-Roading
[NAME]
Grand Total
Spreadsheet: 64c88296-1a87-4c92-8780-9b5790a5d66c
Sheet: Sheet1

Commercial Construction Permits | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 | Entries made in the last 7 day(s)
Permit |  | Permit Type |  |  | Date Recorded | [NAME] | Job Address | Project |  | Contractor |  | Est Value
14-2279 |  | Commercial Interior |  |  | 2014-08-14 00:00:00 | 110 | 5105 SOUTH NATIONAL DR KNOXVILLE TN 37914 | FRESENIUS MEDICAL STRUCTURAL UPGRADE |  | [NAME], Inc. |  | 800000
14-2878 |  | Commercial Interior |  |  | 2014-10-17 00:00:00 | 131 | 215 #900 CENTER PARK DR KNOXVILLE 37922 | WEST KNOX DENTISTRY |  | Mcbride Co., L.L.C. |  | 95000
14-2819 |  | Commercial Interior |  |  | 2014-10-17 00:00:00 | 138 | 8212 CHAPMAN HWY KNOXVILLE TN 37920 | IANS MARKET # 39 |  | [NAME] |  | 100
14-2820 |  | Commercial Interior |  |  | 2014-10-17 00:00:00 | 038 | 7025 MAYNARDVILLE PIKE KNOXVILLE TN 37918 | IANS MARKET #41 |  | [NAME] |  | 100
14-2746 |  | Commercial Interior |  |  | 2014-10-17 00:00:00 | 089 | 8907 #101 OAK RIDGE HWY KNOXVILLE TN 37931 | [NAME] THRIFT |  | Troy Holcombe |  | 100
14-2852 |  | Commercial Interior |  |  | 2014-10-17 00:00:00 | 118 | 835 INNOVATION DR KNOXVILLE TN 37932 | EMERSON PROCESS MANAGEMENT CONFERENCE ROOM |  | Preen Construction Llc |  | 107700
14-1163 |  | General Permit |  |  | 2014-10-20 00:00:00 | 131 | 10606 KINGSTON PIKE KNOXVILLE TN 37922 | LIBERTY PLAZA DRIVEWAY ENTRANCES |  | Disney Construction Company |  | 0
14-0417 |  | Apartments Bldg Shell |  |  | 2014-10-20 00:00:00 | 049 | 4807 KING GEORGE WAY | THE COTTAGES AT TAZEWELL BLDG 18 |  | [NAME] |  | 385000
14-0151 |  | Apartments Bldg Shell |  |  | 2014-10-20 00:00:00 | 049 | 4708 DEVON SPRINGS WAY | THE COTTAGES AT TAZEWELL BLDG 19 |  | [NAME] |  | 385000
14-0161 |  | Apartments Bldg Shell |  |  | 2014-10-20 00:00:00 | 049 | 4704 DEVON SPRINGS WAY | THE COTTAGES AT TAZEWELL BLDG 20 |  | [NAME] |  | 385000
14-2772 |  | Commercial Interior |  |  | 2014-10-21 00:00:00 | 056 | 2529 W EMORY RD POWELL TN 37849 | [NAME] DDS - INTERIOR & PARKING LOT |  | [NAME] |  | 200000
14-2683 |  | Commercial Interior |  |  | 2014-10-21 00:00:00 | 022 | 8432 WASHINGTON PIKE CORRYTON TN 37721 | HOUSE MOUNTAIN MARKET AND DELI |  | [NAME] |  | 100
14-2025 |  | Commercial Building New |  |  | 2014-10-23 00:00:00 | 077 | 8550 [NAME] | TENNESSEE CHILDREN'S HOME EDUCATION/MULTI PURPOSE |  | Stethen-Smith Construction Com |  | 997990
14-2026 |  | Commercial Building New |  |  | 2014-10-23 00:00:00 | 077 | 8564 [NAME] TN | TENNESSEE CHILDREN'S HOME GROUP HOME #1 |  | Stethen-Smith Construction Com |  | 310100
14-2027 |  | Commercial Building New |  |  | 2014-10-23 00:00:00 | 077 | 8566 [NAME] | TENNESSEE CHILDREN'S HOME GROUP HOME #2 |  | Stethen-Smith Construction Com |  | 310100
14-2910 |  | Sign |  |  | 2014-10-23 00:00:00 | 038 | 7042 MAYNARDVILLE PIKE KNOXVILLE 37918 | H & R BLOCK |  | T And T Signs, Inc. |  | 820
 | Total |  | 16 |  |  |  |  |  |  | Sum | 3977110
Spreadsheet: 869120d1715771231-creating-the-same-graphs-for-multiple-sheets-on-new-tabs-programme-dashboard-template-to-share
Sheet: Dashboard

 | Mar
 | Please select reporting period and click to update forecast
 | Lifetime Spend
 | AFC (excluding contingency)
 | Contingency
 | Approved Funding (Lifetime)
 | Remaining Approved Funding
 | AFC
 | Allocation
 | Under / (Over) Allocation
 | Contingency as a percent of liftetime spend
 | In year spend | Current |  |  |  |  |  |  |  |  |  | Lifetime Spend | Prior Year | Current Year | 25/26 | 26/27 | 27/28 | 28/29 | Totals
 | Forecast spend |  |  |  |  |  |  |  |  |  |  | Baseline
 | Contingency |  |  |  |  |  |  |  |  |  |  | Prior Month
 | Approved Funding |  |  |  |  |  |  |  |  |  |  | Current Month
 | In Year Under / (Over) Spend |  |  |  |  |  |  |  |  |  |  | [NAME]
 | Contingency as a percentage of in year spend
 | In Year Variance to baseline | Current
 | Actual Spend YTD vs Forecasted Spend YTD
 | Movement in Current Year Outturn
 | Movement in Contingency from Baseline
 | Spend Progress | Current
 | Actual Spend to Jul
 | Total forecasted spend
 | Remaining to Spend
 | % Remaining to Spend
 | Stage | % of Total Spending
 | SOBC
 | OBC
 | FBC
 | Delivery
 | Post Completion
 | Revenue
Spreadsheet: 721101d1614494585-row-and-column-matching-column-row-matching
Sheet: Sheet1

General Ledger |  |  |  | Bank
Description | Credit | Reconciliation |  | Description | Debit | Reconcilition
Electrosales | 3384.76 | Matched |  | Halsted | 1415.22 | Matched
Halsted | 1415.22 | Matched |  | Imtt
Powertel | 5438 | Matched |  | Powertel | 5438 | Matched
Salary | 7500 |  |  | Imtt
TM | 1234 |  |  | Electrosales | 3384.76 | Matched
 |  |  |  | Imtt
I am kindly asking for a formula in column C and D, If the amount and description appears in both General Ledger and Bank
the answer will be matched and if does not appear both sides it leaves it blank as the above example.
Spreadsheet: 865564d1712638460-numbering-example-197-aligw
Sheet: Sheet1

 | ACTIVTY A | ACTITY B | ACTIVITY C | SUM | GRADE
 | 0.25 | 0.35 | 0.4
[NAME] | 15 | 36 | 48
A2 DONE | 29 | 42 | 39
A3 DONE | 18 | 53 | 62
Spreadsheet: 33099d1229376554-repetition-file1
Sheet: Sheet1

INPUT |  | OUTPUT
COLIN |  | COLIN
DAVE |  | COLIN
CHRIS |  | COLIN
FRANK |  | COLIN
[NAME] |  | DAVE
[NAME] |  | DAVE
DOUGAL |  | DAVE
 |  | DAVE
 |  | CHRIS
 |  | CHRIS
 |  | CHRIS
 |  | CHRIS
 |  | FRANK
 |  | FRANK
 |  | FRANK
 |  | FRANK
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | DOUGAL
 |  | DOUGAL
 |  | DOUGAL
 |  | DOUGAL
Spreadsheet: 159388d1338607336-soccer-league-in-excel-pt-premier-league-fun
Sheet: Points

No | Team | Played | Won | [NAME] | Lost | Hat Tricks | Win/points | Draw/points | Goals Scored | Red Cards | Own Goals | Hat-trick PTS | Total
1 | Arsenal | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | -2 | 0 | 0 | -1 |  | Arsenal
2 | [NAME] | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 |  | [NAME]
3 | [NAME] | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 |  | [NAME]
4 | [NAME] | 1 | 1 | 0 | 0 | 0 | 3 | 0 | 4 | 0 | 0 | 0 | 7 |  | [NAME]
5 | Chelsea | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 |  | Chelsea
6 | Everton | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | Everton
7 | Liverpool | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 2 |  | Liverpool
8 | Man City | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | Man City
9 | Man Utd | 1 | 1 | 0 | 0 | 0 | 3 | 0 | 2 | 0 | 0 | 0 | 5 |  | Man Utd
10 | Newcastle | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 |  | Newcastle
11 | [NAME] | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 2 |  | [NAME]
12 | QPR | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | -2 | -5 | 0 | -7 |  | QPR
13 | Swansea | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | Swansea
14 | Tottenham | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | Tottenham
15 | West Brom | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | -5 | 0 | -4 |  | West Brom
 | WIN =  +3PT
 | DRAW =  +1PT
 | LOSS=  +0PT |  |  |  |  |  | Row Labels | Sum of Total | <<This is a very simple [NAME] table sorted by Totals
 | PER GOAL SCORED =  +1PT |  |  |  |  |  | [NAME] | 7
 | RED CARD =  -2PT |  |  |  |  |  | Man Utd | 5
 | OWN GOAL =  -5PT |  |  |  |  |  | Liverpool | 2
 | Hat-tricks = +2pt |  |  |  |  |  | [NAME] | 2
 |  |  |  |  |  |  | [NAME] | 1
 |  |  |  |  |  |  | Newcastle | 1
 |  |  |  |  |  |  | [NAME] | 1
 |  |  |  |  |  |  | Chelsea | 1
 |  |  |  |  |  |  | Tottenham | 0
 |  |  |  |  |  |  | Swansea | 0
 |  |  |  |  |  |  | Everton | 0
 |  |  |  |  |  |  | Man City | 0
 |  |  |  |  |  |  | Arsenal | -1
 |  |  |  |  |  |  | West Brom | -4
 |  |  |  |  |  |  | QPR | -7
 |  |  |  |  |  |  | Grand Total | 8
Spreadsheet: phillip_m_love__30147__9910_OA
Sheet: RECLASS

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - RECLASSES
COMPANY:  ALL
REGION: ALL
 |  |  | Total |  | Central |  | Northeast |  | Southeast-LRC |  | Southeast-EGM |  | West |  | Texas-HPLR |  | Texas-EGM |  | Texas-HPLC |  | Storage |  | Ontario |  | Aruba |  | BUG
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  |  |  |  |  | 698599
2 |  | Liquidations |  |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | -71058
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -698599
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron |  |  |  | 0
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME] |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage |  |  |  |  |  | -126950 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1732900
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 573899
25 |  | Demand |  |  |  | 12456 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 0
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | -8162 |  | 0
37 |  | [NAME] |  |  |  |  |  | 25724
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
Spreadsheet: 750048d1633191266-files-status-based-on-dates-dashboard
Sheet: dashboard

 | Reception |  |  | Analyze |  |  | Approve |  |  | Submit |  |  | Done
 | File # | Date |  | File # | Date |  | File # | Date |  | File # | Entry date |  | File # | Date
 | 931 | 2021-10-01 00:00:00 |  | 879 | 2021-09-30 00:00:00 |  | 462 | 2021-09-26 00:00:00 |  | 124 |  |  | 123 | 2021-09-30 00:00:00
 |  |  |  | 932 | 2021-10-02 00:00:00 |  | 856 |  |  | 456
Spreadsheet: 740448d1626344964-match-2-cells-and-total-two-tables-excel-example-1-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Afterschool
Kids name |  |  | Paper Work |  |  |  |  |  | Program |  | Tuition |  |  |  | Kids name |  |  | Paper Work
First Name | Last Name | DOB | Contract | Emergency contact | IMM | DIR | DRI | SF | Afterschool | ElementarySchool | Tuition total |  |  |  | First Name | Last Name | Program | Monday | Tuesday | Wednesday | Thursday | Friday | Tuition | Tuition Reduction
[NAME] | excel |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | excel | [NAME] | x | x | x |  |  | 10
[NAME] | Dupont |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Dupont | 3rd/5th