tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: mary_fischer__25621__77N
Sheet: E-6.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 077N
COMPANY NAME    Marlin Electrical, Inc
ANALYSIS OF PROPERTY, PLANT AND EQUIPMENT
FOR THE 6 MONTHS ENDED 6-30-2001
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-6
 |  | 12-31-2000 Balance |  |  |  |  |  | CHARGED TO I/S
 |  | DR/(CR.) |  |  |  | SALES AND OTHER |  |  |  |  |  |  |  | DETAIL OF |  | ENDING
[NAME] |  | BEGINNING |  | ADDITIONS |  | RETIREMENTS |  | DEPR |  | DEPL |  | OTHER |  | OTHER CHANGES |  | BALANCE
 |  | BALANCE |  | DR/(CR) |  | DR/(CR) |  | 1415 |  | 1416 |  | (List Below-A) |  | (List Below-B) |  | DR/(CR)
Natural Gas Transmission
Electric Generation & Distribution
Construction In Process
O & G Properties
Other |  | 873555 |  |  |  |  |  |  |  |  |  |  |  | 107321
Gross PP & E
Accumulated DD & A |  | -355446 |  |  |  | 5827 |  | -44414 |  |  |  | -13038 |  | -44745
Net PP & E |  |  | * |  | ** |  | ** |  |  |  |  |  |  |  |  |  | *
 |  |  |  |  | ** Pertains to amounts related to normal |  |  |  |  |  |  | (A) |  | (B) | * | [NAME] TO
 |  |  |  |  | operations.  Unusual amounts should be shown |  |  |  |  |  |  |  |  |  |  | HYPERION LINE
 |  |  |  |  | under "Other Changes" with appropriate explanations. |  |  |  |  |  |  |  |  |  |  | NET_TOT_PPE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Asset/Exp  DR/(CR)
 |  |  |  |  |  |  | DETAIL OF OTHER CHANGES     (B)
 |  |  |  |  |  |  |  |  |  |  |  | PP & E |  | ACCUM |  | NET
CHARGED TO OTHER I/S ACCTS     (A) |  |  |  |  |  |  | KEY: |  |  |  |  | DR/(CR) |  | DR/(CR) |  | DR/(CR)
[NAME] |  | HYP ACCT CHGD |  | DR/(CR) |  |  | (PROVIDE DETAIL OF INDIVIDUAL ITEMS
 |  |  |  |  |  |  | IN EXCESS OF $200,000.)
Depreciation Expense in Cost of Sales |  | 1150 |  | 13038 |  |  | (1) Reclassification between property
 |  |  |  |  |  |  | accounts (should net to -0-)
 |  |  |  |  |  |  | (2) Intercompany transfer
 |  |  |  |  |  |  | (list companies):
 |  |  |  |  |  |  |  | MEP Services, Inc |  |  |  | 107321 |  | -44745
 |  | TOTAL
 |  |  |  |  |  |  | (3) Acquisition (disposition)
 |  |  |  |  |  |  | of business
 |  |  |  |  |  |  | (4) Foreign currency
 |  |  |  |  |  |  | translation adjustment
 |  |  |  |  |  |  | (5) Lease impairments -
 |  |  |  |  |  |  | Oil & Gas
 |  |  |  |  |  |  | (6) Other (detail):
 |  |  |  |  |  |  |  |  |  | TOTAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-6
Spreadsheet: 90091d1289845819-find-top-5-most-popular-test
Sheet: Month 3

 |  |  |  | Mr. [NAME] | Mr. [NAME] | Mr. [NAME] | Mrs. [NAME] | Total taught
 |  |  | Maths1 | 32 | 22
 |  |  | Maths2 | 96 | 81
 |  |  | Maths3 | 83
 |  |  | English1 | 9
 |  |  | English2 | 60
 |  |  | English3 | 42
 |  |  | Science1 |  | 10
 |  |  | Science2 |  | 12
 |  |  | Science3 |  |  | 83
 |  |  | History1 |  |  | 28
 |  |  | History2 |  |  |  | 93
 |  |  | History3 |  |  |  | 81
Spreadsheet: 689571d1596522929-nested-if-statement-doesn-t-work-vergleich-klinz
Sheet: pivo jetzt

Beleg | [NAME] | [NAME] | HES | Pflaster | [NAME] |  |  | [NAME] |  |  |  |  | [NAME] | HES | Pflaster | [NAME]
1 | 2 | 3 | 4 | 5 | 6 |  | 8 | 9 | 10 | 11 | 12 |  | 14 | 15 | 16 | 17
4008670 | MIAM | 1 |  | 1 | 5
4008671 | KLJE | 2 | 3 | 29 | 10
4008721 | BEPO | 1 |  | 6 | 2
4008737 | VOBE | 1 |  | 16 | 5
4008738 | ROMA | 1 |  | 25 | 8
4008756 | KAMO |  |  |  | 1
4008760 | MLNO | 2 | 1 | 33 | 10
4008767 | FRZA | 2 |  | 18
4008768 | KLWU |  |  | 24 | 6
4008769 | ANDI |  |  | 17 | 1
4008777 | ANJA |  |  | 22 | 8
4008788 | GUBE | 1 |  | 28 | 10
4008789 | PEWI | 1 |  | 29 | 10
4008795 | HEME | 1 | 1 | 33 | 10
4008829 | ASGE | 1 | 1 | 13 | 8
4008830 | NIWA |  |  | 19 | 10
4008836 | MALU | 1 |  | 24 | 7
4008844 | ANSI | 2 |  | 18 | 10
4008845 | EVPA | 1 |  | 18 | 8
Spreadsheet: 87993d1287880471-extracting-text-string-with-2-options-end-and-limited-options-extractsolutions-4-christianr
Sheet: Sheet1

 |  | zbor | zbor to # |  | Marcol |  | Contaminated
1 |  |  | #N/A
2 | abcxyz |  | #N/A
3 | CR 256 | 256 | 256 |  | 256 |  | #N/A
4 | CR 256, 278, 296 | 256 | 256 |  | 256 |  | #N/A
5 | CR 2,278,296 | 2 | 2 |  | #N/A |  | #N/A
6 | CR 25; XYZ 412, 478 | 25 | 25 |  | #N/A |  | #N/A
7 | CR 2566, 278, 296; XYZ 412, 478 | 2566 | 2566 |  | 2566 |  | #N/A
8 | ABC 1232, 1468; CR 12345, 1278, 1296 | 12345 | 12345 |  | 1234 |  | #N/A
9 | ABC 1232, 1468; CR 12345678, 1278, 1296; XYZ 412, 478 | 12345678 | 12345678 |  | 1234 |  | #N/A
10 | ABC 1232, 1468; CR 12(a)b.56+II-VI; [NAME], 478 | 12(a)b.56+II-VI | #N/A |  | #N/A |  | #N/A
11 | ABC 1232, 1468; CR [PHONE], 1278, 1296; XYZ 412, 478 | [PHONE] | 123456789012 |  | 1234 |  | #N/A
 | Thanks to Marcol! ;-)
Spreadsheet: 740756d1626538519-calculate-the-total-of-two-different-background-colour-figure-cells-in-same-column-sums-based-on-condition-thiajay-
Sheet: Sheet1

Agent | Alias | Profile ID | Contact Details | Item | Sold By | Cost | Paid | Received | Review Conditions | Review After | Review text | Review Submitted | Review Published | Refund Conditions | Refund Issued | Refund Received | Refund Email
 |  |  |  |  |  | 6.29 | 5.81
 |  |  |  |  |  | 9.98 | 9.39
 |  |  |  |  |  | 16.99 | 16.2
 |  |  |  |  |  |  | 35
 |  |  |  |  |  |  | 5
 |  |  |  |  |  |  | 70
 |  |  |  |  |  | 149.9
 |  |  |  |  |  | 26.99
 |  |  |  |  |  | 99.99
 |  |  |  |  |  | 19.99
 |  |  |  |  |  | 29.99
 |  |  |  |  |  | 52.99
 |  |  |  |  |  | 199.99
 |  |  |  |  |  | 10.99
 |  |  |  |  |  | 19.99
 |  |  |  |  |  | 21.9
 |  |  |  |  |  | 2.99
 |  |  |  |  |  | 7.99
 |  |  |  |  |  | 6.47
Red
White
Spreadsheet: 75895d1276512825-average-of-value-in-different-cells-in-multiple-worksheet-test-vsb-reco-201011-and-summary-sheet
Sheet: Jan'11

 |  | [NAME]
 |  | Monthly Reconciliation
 |  | 2011-01-31 00:00:00
 |  | Summary of Stocks
 |  | New Stock | Fully Paid |  | Int. Bearing |  | Free Funded |  | Totals
 |  |  | Units | Value | Units | Value | Units | Value | Units | Value
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Used Stock | Fully Paid |  | Int. Bearing |  | Free Funded |  | Totals |  | Units over | % Of Stock
 |  |  | Units | Value | Units | Value | Units | Value | Units | Value | 70 Days | Overage
 |  | Stock 1 |  |  |  |  |  |  | 0 | 0
 |  | Stock 2 |  |  |  |  |  |  | 0 | 0
 |  | Stock 3 |  |  |  |  |  |  | 0 | 0
 |  | Stock 4 |  |  |  |  |  |  | 0 | 0
 |  | Stock 5 |  |  |  |  |  |  | 0 | 0
 |  | Stock 6 |  |  |  |  |  |  | 0 | 0
 |  | Totals | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 136664d1326774855-formula-ormacro-to-move-numbers-from-cell-11-10-10-9-9-8-etc-low-5-of-last-10-scores
Sheet: Sheet1

 |  |  |  | <<Method 3 using an Array Formula
 |  |  |  | <<Method 1
 |  |  |  | <<Method 2
Date | [NAME] | Fred | [NAME]
2012-01-16 00:00:00 | 85 | 93 | 92
2012-01-09 00:00:00 | 87 | 93 | 76
2012-01-02 00:00:00 | 75 | 79 | 81
2011-12-26 00:00:00 | 95 | 94 | 92
2011-12-19 00:00:00 | 76 | 90 | 76
2011-12-12 00:00:00 | 92 | 84 | 76
2011-12-05 00:00:00 | 81 | 77 | 76
2011-11-28 00:00:00 | 82 | 89 | 88
2011-11-21 00:00:00 | 79 | 88 | 76
2011-11-14 00:00:00 | 90 | 76 | 82
2011-11-07 00:00:00 | 84 | 91 | 80
2011-10-31 00:00:00 | 93 | 90 | 93
2011-10-24 00:00:00 | 91 | 95 | 87
2011-10-17 00:00:00 | 78 | 97 | 85
2011-10-10 00:00:00 | 85 | 78 | 91
2011-10-03 00:00:00 | 93 | 95 | 91
2011-09-26 00:00:00 | 83 | 96 | 80
2011-09-19 00:00:00 | 86 | 85 | 96
2011-09-12 00:00:00 | 94 | 78 | 96
2011-09-05 00:00:00 | 76 | 87 | 83
Spreadsheet: 672648d1586948423-overtime-formula-matrix
Sheet: Cost Matrix

 | EVENT ESTIMATION COST MATRIX
 | Position | Company | Date | Start Time | End Time | Hr | Total Hr | Overtime | Cost / Hr | Qty | Total |  | Doors Open | 14:00:00
 | Medic Service |  |  |  |  |  |  |  |  | 1 |  |  | Show Start | 12:00:00
 | Medical Director |  |  |  |  |  |  |  |  | 1 |  |  | Show End | 19:00:00
 | Crew |  |  |  |  |  |  |  |  | 1
 | Ambulance |  |  |  |  |  |  |  |  | 1 |  |  | Position | Cost | Company | Start | Finish | Start details | End details | Overtime |  | Overtime Cost
 | Parking Supervisor |  |  |  |  |  |  |  |  | 1 |  |  | Crew Chief | 50 | [NAME] |  |  | 05:00:00 | 01:00:00
 | Crew |  |  |  |  |  |  |  |  | 2 |  |  | Crew | 40 | [NAME] |  |  | 01:00:00 | 01:00:00
 | Parking Supervisor |  |  |  |  |  |  |  |  | 1 |  |  | Medical Director | 1500 | GMC Clinic |  |  | 03:00:00 | 01:00:00 | 08:00:00 |  | 150
 |  |  |  |  |  |  |  |  |  |  |  |  | Medic Service | 800 | GMC Clinic |  |  | 03:00:00 | 01:00:00 | 08:00:00 |  | 100
 |  |  |  |  |  |  |  |  |  |  |  |  | Ambulance | 400 | GMC Clinic |  |  | 01:00:00 | 01:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | Parking Supervisor | 60 | [NAME] |  |  | 01:00:00 | 01:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | Parking Marshal | 55 | [NAME] |  |  | 01:00:00 | 01:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | Company | Role | Total
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Event Crew
 |  |  |  |  |  |  |  |  |  |  |  |  | GMC Clinic | Medical
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Parking Marshals
Spreadsheet: 76473d1277029752-double-vlookup-or-index-match-or-something-else-hera
Sheet: Sheet1

glass | wa |  |  | 2008-01-01 00:00:00 |  | 2009-01-01 00:00:00
table | review |  |  | 2009-09-01 00:00:00 |  | 2009-02-01 00:00:00
table | wa |  |  | 2008-10-01 00:00:00 |  | 2009-03-01 00:00:00
breadboard | nsw |  |  | 2009-05-01 00:00:00 |  | 2009-04-01 00:00:00
table | qld |  |  | 2009-10-01 00:00:00 |  | 2009-05-01 00:00:00
sink | nsw |  |  | 2009-02-01 00:00:00 |  | 2009-06-01 00:00:00
chair | tas |  |  | 2009-03-01 00:00:00 |  | 2009-07-01 00:00:00
hatstand | tas |  |  | 2009-09-01 00:00:00 |  | 2009-08-01 00:00:00
coffee table | act |  |  | 2008-03-01 00:00:00 |  | 2009-09-01 00:00:00
telephone | nsw |  |  | 2008-04-01 00:00:00 |  | 2009-10-01 00:00:00
sink | [NAME] |  |  | 2008-05-01 00:00:00 |  | 2009-11-01 00:00:00
highchair | sa |  |  | 2008-06-01 00:00:00 |  | 2009-12-01 00:00:00
table | sa |  |  | 2007-07-01 00:00:00 |  | 2010-01-01 00:00:00
Spreadsheet: 01e118d2-4d57-43b6-b1bf-5ad2f5dedb28
Sheet: Comp Infor Tech 2

COMPUTER INFORMATION TECHNOLOGY | Updated Spring 2013
Student Name:
ID #
CISCO Network Associate Exploration Specialization Sequence | Semester | Grade
___ CIT 210 (4) routing [NAME] and Concetps (CISCO II)
___ CIT 211 (4) LAN Switching & Wireless (CISCO III)
___ CIT 212 (4) Accessing the WAN (CISCO IV)
CISCO Networking Associate - Discovery Specialization Sequence
___ CIT 163 (4) Small-Medium Office or ISP
___ CIT 164 (3) Introduction to Routing and Switching
___ CIT 165 (3) Network Design and Support
Applications Track
___ CIT 130 (3) Productivity Software
___ Approved Business or Management Course (3)
___ Approved CIT Technical Course (3)
Completion of Application Track Sequence (12)
Business Software Specialist
___ CIT 234 (3) Advanced Productivity Software
___ CIT 236 (3) Advanced Data Organization
___ CIT 171 (3) SQL I
___ Approved Business or Management Course (3)
Computer Support
___ CIT 232 (3) Help Desk Operations
___ CIT 234 (3) Advanced Productivity Software
___ CIT 236 (3) Advanced Data Organization
___ CIT Technical Course (Approved by Program Coordinator)
Geograpshical Information Systems OR
___ CIT 125 (3) Introduction to GIS
___ CIT 225 (3) GIS Software Tools
___ CIT 229 (3) Selected Topics in GIS
___ CIT 253 (3) Dat- Driven Web Pages: Topic
OR
___ GIS 110 (3) Spatial Data Analysis and Map Interpretation
___ GIS 120 (3) Introduction to Geographic Information Systems
___ GIS 210 (3) Advanced Geographic Information Systems
___ CIT 253 (3) Data-Driven Web Pages: Topic
Software Support
___ CIT 234 (3) Advanced Productivity Software
___ CIT 236 (3) Advanced Data Organization
___ CIT 253 (3) Data-Driven Web Pages: Topic
___ ENG 102 (3) Writing II
OR ___ Oral Communications
Southeast Kentucky Community & Technical College | Updated Spring 2013
Spreadsheet: 33024d1229272678-similar-groups-in-a-column-array-across-columns2
Sheet: Sheet1

50 | Q
60 | 0
50 | W
70 | A
70 | B
70 | C
70 | D
70 | E
50 | E
70 | F
70 | G
70 | H
60 | 1
60 | 2
50 | R
60 | 3
60 | 4
60 | 5
12 | M
60 | 7
70 | LALA
12 | A
12 | R
50 | T
12 | T
12 | I
12 | N
60 | 6
100 | OH
100 | LOOK
100 | IT'S
100 | FOUND
100 | ALL
100 | THESE
100 | VALUES
100 | GOODY
100 | JUST
100 | WHAT
100 | I
100 | WANTED
50 | Y
Spreadsheet: 876381d1723056855-table-copied-to-two-sheets-shows-correct-on-one-and-incorrect-on-the-other-table-copy-test
Sheet: Sheet2

DATE | MONTH
PULLING FROM SHEET 1
IN MY ACTUAL DATA SET, THIS SHEET SHOWS CORRECTLY.
Spreadsheet: 744119d1628966642-determine-if-month-falls-between-two-date-ranges-interest_calc
Sheet: 2A.FDs

Month | FD Number | Deposit Date | Maturity Date | Days | ROI | Deposit Amt | Maturity Amt | Interest | TDS Thereon | Net Amt | Status |  | 2021-04-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | Total | Check
2021-07-01 00:00:00 |  | 2021-07-03 00:00:00 |  |  | 0.04 | 500000 |  |  | 0
2021-07-01 00:00:00 |  | 2021-07-03 00:00:00 |  |  | 0.04 | 300000 |  |  | 0
2021-07-01 00:00:00 |  | 2021-07-03 00:00:00 |  |  | 0.035 | 200000 |  |  | 0
2021-07-01 00:00:00 |  | 2021-07-07 00:00:00 |  |  | 0.0275 | 450000 |  |  | 0
 |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
Spreadsheet: 751927d1634457709-unable-to-create-linear-function-to-use-simplex-lp-makespan-hydr-
Sheet: Foglio1

Assign | time | M1 | M2 | M3
1 | 26 | 0 | 1 | 0 |  |  | 1
2 | 16 | 1 | 0 | 0 |  |  | 1
3 | 5 | 0 | 1 | 0 |  |  | 1
4 | 19 | 1 | 0 | 0 |  |  | 1
5 | 52 | 0 | 0 | 1 |  |  | 1
6 | 98 | 1 | 0 | 0 |  |  | 1
7 | 8 | 0 | 0 | 1 |  |  | 1
8 | 36 | 0 | 1 | 0 |  |  | 1
9 | 68 | 0 | 1 | 0 |  |  | 1
10 | 3 | 1 | 0 | 0 |  |  | 1
11 | 75 | 0 | 0 | 1 |  |  | 1
dev+ |  | 0.6666666666666287 | 0 | 0
dev- |  | 0 | 0.3333333333333121 | 0.3333333333333388
MM
Th MM
OF
Spreadsheet: 732210d1620825136-compare-two-lists-and-generate-a-new-list-with-what-is-different-from-the-first-list-excel-file-help
Sheet: Department-VAC Code audit

Master [NAME] |  |  |  |  | Database List Pasted |  |  |  |  | [NAME]
Name | ID | Position | Comp Rate |  | Name | ID | Position | Comp Rate |  | Name | ID | Position | Comp Rate
[NAME] | 1628807 | 10305275 | 25.17 |  | [NAME] | 1628807 | 20209586 | 25.47
[NAME] | 1628813 | 10305276 | 25.17 |  | [NAME] | 1628813 | 10305275 | 25.17
[NAME] | 1628824 | 20209586 | 25.27 |  | [NAME] | 1628824 | 20209586 | 25.47
[NAME] | 1628826 | 20209586 | 25.47 |  | [NAME] | 1628826 | 20209586 | 25.47
[NAME] | 1628830 | 20209586 | 25.37 |  | [NAME] | 1628830 | 20209586 | 25.37
[NAME] | 1628870 | 20209586 | 25.37 |  | [NAME] | 1628870 | 20209586 | 25.37
[NAME] | 1628890 | 10305275 | 25.17 |  | [NAME] | 1628890 | 10305275 | 25.17
[NAME] | 1628898 | 10305276 | 25.17 |  | [NAME] | 1628898 | 10305276 | 25.17
[NAME] | 1628906 | 10305276 | 25.17 |  | [NAME] | 1628906 | 10305276 | 25.17
[NAME] 10 | 1628907 | 10305276 | 25.17 |  | [NAME] 10 | 1628907 | 10305276 | 25.17
[NAME] | 1628911 | 10305276 | 25.27 |  | [NAME] | 1628911 | 10305276 | 25.27
[NAME] | 1628918 | 10305276 | 25.47 |  | [NAME] | 1628918 | 10305276 | 25.47
[NAME] | 1628920 | 20209586 | 25.37 |  | [NAME] | 1628920 | 20209586 | 25.37
[NAME] | 1628930 | 10305276 | 25.17 |  | [NAME] | 1628930 | 10305276 | 25.17
[NAME] 15 | 1628933 | 10305276 | 25.27 |  | [NAME] 15 | 1628933 | 10305276 | 25.27
[NAME] | 1628946 | 10305275 | 25.17 |  | [NAME] | 1628946 | 10305275 | 25.17
[NAME] | 1628959 | 20209586 | 25.37 |  | [NAME] | 1628959 | 20209586 | 25.37
[NAME] | 1628973 | 10305318 | 24.4 |  | [NAME] | 1628973 | 10305318 | 24.4
[NAME] | 1628975 | 20209586 | 25.62 |  | [NAME] | 1628975 | 20209586 | 25.62
[NAME] 20 | 1628978 | 20209586 | 25.47 |  | [NAME] 20 | 1628978 | 20209586 | 25.47
[NAME] 21 | 1628991 | 10305275 | 25.47 |  | [NAME] 21 | 1628991 | 10305275 | 25.47
[NAME] | 1628993 | 10305318 | 24.3 |  | [NAME] | 1628993 | 10305318 | 24.3
[NAME] 23 | 1628994 | 20209586 | 25.37 |  | [NAME] 23 | 1628994 | 20209586 | 25.37
[NAME] | 1628996 | 10305276 | 25.17 |  | [NAME] | 1628996 | 10305276 | 25.17
[NAME] | 1629016 | 20209586 | 25.37 |  | [NAME] | 1629016 | 20209586 | 25.37
[NAME] 26 | 1629018 | 10305275 | 25.27 |  | [NAME] 26 | 1629018 | 10305275 | 25.27
Spreadsheet: 175525d1345560384-formula-to-lookup-and-sum-items-with-same-refrence-number-lookup-and-sum-all-items-that-have-selling-price-greater-than-zero
Sheet: Sheet1

Item |  | AmT. | Selling
Num # | Item Name | Sold | Price
8030 | Large Pepsi | #N/A | 90.13
8030 | Large Pepsi | 18 | 0
8060 | Large Grape | 32 | 90.13
8060 | Large Grape | 22 | 0
8050 | Large Cola | 55 | 0
8050 | Large Cola | 70 | 90.13
8050 | Large Cola | 20 | 0
8050 | Large Cola | 10 | 90.13
8050 | Large Cola | 40 | 90.13
8030 | Large Pepsi | 10 | 90.13
8030 | Large Pepsi | 100 | 0
8060 | Large Grape | 10 | 90.13
9000 | Large Beer | 50 | 0
9000 | Large Beer | 150 | 90.13
9000 | Large Beer | 30 | 90.13
 | Total Sold
Item Name | with sell price greater than Zero
Total Drink Sold | #N/A
Spreadsheet: 777626d1650531120-certain-number-value-with-several-text-combinations-sample_travelexpenses
Sheet: Sheet1 (2)

Week | Date | To work |  |  | Back |  |  | Totaal | Weektotaal
 |  | from | to | km | from | to | km
12 | 2022-03-21 00:00:00 | A | work 1 |  | work 1 | A
 | 2022-03-22 00:00:00 | A | work 2 |  | work 2 | C
 | 2022-03-23 00:00:00 | C | work 1 |  | work 1 | A
 | 2022-03-24 00:00:00 | A | work 1 |  | work 1 | B
 | 2022-03-25 00:00:00 | B | work 1 |  | work 1 | D
13 | 2022-03-28 00:00:00
 | 2022-03-29 00:00:00
 | 2022-03-30 00:00:00
 | 2022-03-31 00:00:00
 | 2022-04-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | Home | work 1 | work 2
 |  |  |  |  |  |  |  |  |  |  |  | A | 80 | 57
 |  |  |  |  |  |  |  |  |  |  |  | B | 46 | 60
 |  |  |  |  |  |  |  |  |  |  |  | C | 32 | 4
 |  |  |  |  |  |  |  |  |  |  |  | D | 43 | 66
Spreadsheet: 146973d1332443811-formula-query-to-calculate-a-special-offer-increase-sports
Sheet: Sheet1

Cost of all sports | 10
Week 1 | Mon | [NAME] | Wed | Thur | Fri | Sat | Sun | Total customers | Total Income
[NAME] | 10 | 12 | 16 | 14 | 21 | 40 | 52 | 165 | 1650
Donut | 6 | 14 | 8 | 12 | 9 | 20 | 32 | 101 | 1010
Water Skiing | 15 | 18 | 10 | 11 | 12 | 15 | 27 | 108 | 1080
Snorkelling | 10 | 11 | 15 | 21 | 13 | 33 | 31 | 134 | 1340
[NAME] | 7 | 12 | 13 | 15 | 16 | 21 | 33 | 117 | 1170
[NAME] | 17 | 15 | 16 | 14 | 18 | 28 | 37 | 145 | 1450
Week 2
[NAME] | 7 | 12 | 16 | 15 | 18 | 21 | 33 | 122 | 1220
Donut | 15 | 18 | 10 | 11 | 12 | 15 | 27 | 108 | 1080
Water Skiing | 10 | 12 | 16 | 14 | 21 | 40 | 52 | 165 | 1650
Snorkelling | 6 | 14 | 8 | 12 | 9 | 20 | 32 | 101 | 1010
[NAME] | 7 | 12 | 16 | 15 | 18 | 21 | 33 | 122 | 1220
[NAME] | 10 | 11 | 15 | 21 | 13 | 33 | 31 | 134 | 1340
Week 3
[NAME] | 6 | 14 | 8 | 12 | 9 | 20 | 32 | 101 | 1010
Donut | 15 | 18 | 10 | 11 | 12 | 15 | 27 | 108 | 1080
Water Skiing | 10 | 12 | 15 | 14 | 21 | 40 | 52 | 164 | 1640
Snorkelling | 7 | 22 | 16 | 15 | 18 | 21 | 33 | 132 | 1320
[NAME] | 10 | 11 | 15 | 21 | 13 | 33 | 31 | 134 | 1340
[NAME] | 7 | 12 | 16 | 15 | 18 | 21 | 33 | 122 | 1220
Week 4
[NAME] | 10 | 11 | 15 | 21 | 13 | 33 | 31 | 134 | 1340
Donut | 6 | 14 | 8 | 12 | 9 | 20 | 32 | 101 | 1010
Water Skiing | 15 | 22 | 10 | 11 | 12 | 15 | 27 | 112 | 1120
Snorkelling | 7 | 18 | 16 | 15 | 18 | 21 | 33 | 128 | 1280
[NAME] | 10 | 12 | 15 | 14 | 21 | 40 | 52 | 164 | 1640
[NAME] | 6 | 14 | 8 | 12 | 9 | 20 | 32 | 101 | 1010
 |  |  |  |  |  | Total for Month |  | 3023 | 30230 |  | 30229.8
Total Income per sport |  | Reached £5000 pm?
[NAME] | 5220 | Reached
Donut | 4180 | Not Reached
Water Skiing | 5490 | Reached
Snorkelling | 4950 | Not Reached
[NAME] | 5370 | Reached
[NAME] | 5020 | Reached
 |  |  |  | Income
Income if 20% discount offered same customer volume
Income if 20% discount offered with 30% more customers
Income if [NAME] offered at £6 with 50% more customers
Instructions - part 1
Calculate total income for the month
Calculate total customers for month
Indicate which sports have not reached target of £5000 month
Create a graph showing income from each sport for the month
Instructions - part 2
The company is considering a special offer to attract customers.  Use the data to work out the following 'what if' situations:
Income for 1 month if we offer 20% off the price of all sports serving same number of customers
Income for 1 month if we offer 20% off the price of all sports serving 30% more customers
Income for 1 month if sport earning the least income is offered at £6 per session and there are 50% more customers
Spreadsheet: 047412c6-8e3a-4b15-b79d-19c446a97703
Sheet: Information

 | Parcel Transfer Report
This report shows parcel transfer activity that occurred during the indicated timeframe.  If a parcel was transferred more than one time during the timeframe, it is only shown once with the name of the current owner at the time the report was run.
Click on the "Parcel Transfers" tab to see the report.  The report utilizes the auto-filter feature.  You can filter the data by any field on the report.  To limit the list to parcels in a specific city or town, click on the filter icon in the City/Town header cell as shown in the graphic to the right.  Then click on "Select All" to deselect all cities/towns, then select the city/town to display and click on OK.  The table below describes the data included on the report:
Field | Description/Contents
City/Town | City or Township that the property is located in
School | School District that the property is located in
TAGDescription | Tax Authority Group.  A code that identifies a unique combination of taxing districts.
PIN | Property ID Number
AttentionTo | Name and mailing address of the Primary Taxpayer on the parcel as of the date the report was run.  This is not necessarily the address of the property.
OwnerName
MailingAddress1
MailingAddress2
Mailing City/St/Zip
PrimarySitusAddress | Parcel Address.  This is the mailing address city of the property, it is not necessarily the city/town that the property is located in.  Note:  parcels may have multiple property addresses.  Only the first one is provided.  The property address is only used for informational and search purposes, it is not used for mailings.  It may not be a vaild mailing address.  The county may not have a property address for every parcel.
SitusAddress City/StZip
TaxDescription | Description of the property for property tax purposes.  May only be a partial description.
Spreadsheet: darrell_schoolcraft__7805__imbalsumm0108
Sheet: Amoco

 | Florida Plant
Day | Measured | Scheduled | Imbal
1 | 136208 | 142148
2 | 91841 | 120259
3 | 95240 | 97445
4 | 116769 | 114074
5 | 108530 | 114453
6 | 119572 | 113703
7 | 112545 | 111866
8 | 112164 | 113431
9 | 113044 | 111560
10 | 116403 | 112898
11 | 103748 | 104833
12 | 107912 | 106898
13 | 120413 | 125960
14 | 113885 | 111354
15 | 116049 | 114316
16 | 112428 | 116998
17 | 107540 | 109346
18 | 103802 | 104079
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-07-31 00:00:00 |  |  | 54883
2001-08-18 00:00:00
CBS Dollars
 |  |  | 411751.53
Spreadsheet: darrell_schoolcraft__7825__imbalsumm0109
Sheet: Oasis

POI  8516
 | Measured | Scheduled | Imbal
1 | -142080 | -142462
2 | -138699 | -136853
3 | -135130 | -133387
4 | -125244 | -125558
5 | -106895 | -107400
6 | -115168 | -114773
7 | -98089 | -97774
8 | -101801 | -102186
9 | -101660 | -102186
10 | -102426 | -102249
11 | -84075 | -83302
12 | -93592 | -91846
13 | -134859 | -133317
14 | -107262 | -102870
15 | -87749 | -87755
16 | -86408 | -86483
17 | -89993 | -87845
18 | -96590 | -99476
19 | -82421 | -85614
20 | -91217 | -96115
21 | -79481 | -77780
22 | -94780 | -94044
23
24
25
26
27
28
29
30
31
 | 2001-08-31 00:00:00 |  | 47553
 | 2001-09-22 00:00:00
CBS Dollars
 |  |  | -252720.37
Spreadsheet: ed37a321-38ea-4344-99ee-c7c9735f2730
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
5607 | 23650 | [NAME] | Dasse | FRA | 0 | 00:40:57 | 00:06:16 | 01:28:08 | 00:03:04 | 00:54:20 | 1 | 03:12:48
5607 | 25149 | Suzanne | Elbon | USA | 0 | [NAME] | 00:06:39 | 01:28:12 | [NAME] | 00:58:42 | 2 | 03:20:29