tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 000022d0-efe7-44f5-97c1-36c899d9d8d0
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
MLH3K | Test | MLH3K | [NAME], Known Mutation | [NAME], Known Mutation | Polymerase chain reaction (PCR) amplification followed by DNA sequencing is utilized to test for the presence of a specific mutation in the MLH3 gene previously identified in an affected family member. (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | EDTA (lavender-top) tube: EDTA Yellow-Top (ACD) Tube: ACD |  |  | 3 | mL | This test can only be performed if a mutation has previously been identified in a family member of this individual.  [NAME] must arrive within 96 hours of draw.  Container/Tube: Preferred: Lavender top (EDTA) or yellow top (ACD) Acceptable: Any anticoagulant [NAME]: 3 mL	 Collection Instructions:	 1. Invert several times to mix blood. 2. Send specimen in original tube. Forms: 1. Molecular Genetics-Colon Cancer Patient Information Sheet (Supply T521) in Special Instructions 2. New York Clients-Informed consent is required. Please document on the request form or electronic order that a copy is on file. An Informed Consent for Genetic Testing (Supply T576) is available in Special Instructions. | 1 mL | Note: No specimen should be rejected. If specimen not received at appropriate temperature or in wrong anticoagulant, include note to laboratory. If questions, contact laboratory. | An interpretive report will be provided. | Wednesday; 10 a.m. | 10 days | 16 days | 1 | 81479 |  |  |  |  | Rochester
MLH3K | [NAME] | VARIES | Varies |  |  |  | Ambient
MLH3K | Result | 34109 | Reason for Referral | Reason for Referral | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42349-1 | Reason for referral:Find:Pt:^Patient:Nar:
MLH3K | Result | 34110 | Result | Result | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
MLH3K | Result | 34111 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
MLH3K | Result | 34112 | Method | Method | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 49549-9 | Reference lab test method:Type:XXX:Reference lab test:Nar:
MLH3K | Result | 34113 | Amendment | Amendment | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
MLH3K | Result | 34114 | [NAME] | [NAME] | Alphanumeric
MLH3K | Result | 34115 | Source | Source | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2 | [NAME] source:Prid:Pt:[NAME]:Nom:
MLH3K | Result | 34116 | Reviewed By | Reviewed By | Alphanumeric
MLH3K | Result | 34117 | Release Date | Release Date | Alphanumeric
Spreadsheet: 19c27ad6-3ff7-4eda-aac5-4604b68da60c
Sheet: Staffing

 | Number of Schools Licensed by Nevada DOE
Licensed by County | [NAME] | Churchill | [NAME] | [NAME] | Elko | Lyon | Nye | Washoe | Total
Exempt Private | 4 | 3 | 44 | 5 | 1 | 1 | 1 | 15
Private                  (non-exempt) | 1 | 0 | 62 | 1 | 0 | 1 | 1 | 21
 | Number of School Accredited by Outside Agencies
Accredited by County | [NAME] | Churchill | [NAME] | [NAME] | Elko | Lyon | Nye | Washoe | Total
Exempt Private | 1 | 0 | 18 | 0 | 0 | 0 | 0 | 7
Private                  (non-exempt) | 0 | 0 | 20 | 0 | 0 | 0 | 1 | 4
 | Number of Teachers Employed
 | [NAME] | Churchill | [NAME] | [NAME] | Elko | Lyon | Nye | Washoe | Total
Exempt Private | 24 | 11 | 545 | 20 | 8 | 2 | 10 | 145
Private                  (non-exempt) | 11 | 0 | 547 | 8 | 0 | 2 | 2 | 134
 | Teachers by Qualifications
Private                  (non-exempt) | NV License to Teach |  | Out-of-state License to Teach |  | Bachelor's Degree + 3 years Verified Experience + Clear Fingerprints |  | Master's Degree + 1 year Verified Experience + Clear Fingerprints
[NAME] | 11 |  | 0 |  | 0 |  | 0
[NAME] | 211 |  | 81 |  | 118 |  | 112
[NAME] | 8 |  | 0 |  | 0 |  | 0
Lyon | 2 |  | 0 |  | 0 |  | 0
Nye | 1 |  | 0 |  | 0 |  | 1
Washoe | 46 |  | 8 |  | 8 |  | 33
 | All teachers in Private, non-exempt schools MUST qualify by one of the four categories above.
Exempt Private Schools are not required to report teacher qualifications.
Spreadsheet: 787903d1658147364-count-the-number-of-unique-data-with-multiple-conditions-help-7-18
Sheet: Sheet1

 | fruit name | Amount | Date |  |  | Date | Amount 1-10 | Amount 11-20 | Amount 21-50 | Amount 51-100 | Amount100+
 | apple | 53 | 2022-07-01 00:00:00 |  | TABLE B | 2022-07-01 00:00:00 | 0 | 0 | 3 | 4 | 1
 | pear | 33 | 2022-07-01 00:00:00 |  |  | 2022-07-02 00:00:00 | 1 | 0 | 2 | 3 | 2
 | apple | 7 | 2022-07-01 00:00:00 |  |  | 2022-07-03 00:00:00 | 0 | 1 | 3 | 2 | 1
 | banana | 29 | 2022-07-01 00:00:00
 | durian | 27 | 2022-07-01 00:00:00
 | Grape | 67 | 2022-07-01 00:00:00 |  |  | WITHOUT TABLE C  (Just for refer)
 | Grape | 85 | 2022-07-01 00:00:00 |  |  | fruit name | Amount | Date
 | peach | 61 | 2022-07-01 00:00:00 |  |  | apple | 60 | 2022-07-01 00:00:00
 | pear | 46 | 2022-07-01 00:00:00 |  |  | pear | 79 | 2022-07-01 00:00:00
 | longan | 89 | 2022-07-01 00:00:00 |  |  | banana | 29 | 2022-07-01 00:00:00
 | litchi | 23 | 2022-07-01 00:00:00 |  |  | durian | 27 | 2022-07-01 00:00:00
 | apple | 89 | 2022-07-02 00:00:00 |  |  | Grape | 152 | 2022-07-01 00:00:00
 | pear | 61 | 2022-07-02 00:00:00 |  |  | peach | 61 | 2022-07-01 00:00:00
 | apple | 27 | 2022-07-02 00:00:00 |  |  | longan | 89 | 2022-07-01 00:00:00
 | apple | 14 | 2022-07-02 00:00:00 |  |  | litchi | 23 | 2022-07-01 00:00:00
 | banana | 30 | 2022-07-02 00:00:00 |  |  | apple | 130 | 2022-07-02 00:00:00
 | durian | 43 | 2022-07-02 00:00:00 |  |  | pear | 74 | 2022-07-02 00:00:00
 | Grape | 41 | 2022-07-02 00:00:00 |  |  | banana | 30 | 2022-07-02 00:00:00
 | Grape | 6 | 2022-07-02 00:00:00 |  |  | durian | 47 | 2022-07-02 00:00:00
 | durian | 4 | 2022-07-02 00:00:00 |  |  | Grape | 129 | 2022-07-02 00:00:00
 | Grape | 7 | 2022-07-02 00:00:00 |  |  | peach | 85 | 2022-07-02 00:00:00
 | Grape | 75 | 2022-07-02 00:00:00 |  |  | longan | 51 | 2022-07-02 00:00:00
 | peach | 85 | 2022-07-02 00:00:00 |  |  | litchi | 7 | 2022-07-02 00:00:00
 | pear | 13 | 2022-07-02 00:00:00 |  |  | longan | 12 | 2022-07-03 00:00:00
 | longan | 51 | 2022-07-02 00:00:00 |  |  | litchi | 88 | 2022-07-03 00:00:00
 | litchi | 7 | 2022-07-02 00:00:00 |  |  | apple | 28 | 2022-07-03 00:00:00
 | longan | 12 | 2022-07-03 00:00:00 |  |  | pear | 38 | 2022-07-03 00:00:00
 | litchi | 88 | 2022-07-03 00:00:00 |  |  | banana | 39 | 2022-07-03 00:00:00
 | apple | 5 | 2022-07-03 00:00:00 |  |  | durian | 84 | 2022-07-03 00:00:00
 | pear | 38 | 2022-07-03 00:00:00 |  |  | Grape | 129 | 2022-07-03 00:00:00
 | apple | 7 | 2022-07-03 00:00:00
 | apple | 16 | 2022-07-03 00:00:00
 | banana | 39 | 2022-07-03 00:00:00
 | durian | 78 | 2022-07-03 00:00:00
 | Grape | 23 | 2022-07-03 00:00:00
 | Grape | 87 | 2022-07-03 00:00:00
 | durian | 6 | 2022-07-03 00:00:00
 | Grape | 19 | 2022-07-03 00:00:00
 |  | TABLE A
Spreadsheet: 105040d1302525749-capturing-daily-values-from-one-sheet-to-another-save-workbook
Sheet: WORKSHEET 1

HOURLY PRODUCTION SHEET
 |  | DATE: | 2011-04-13 00:00:00 | 2011-04-13 00:00:00 | 2011-04-13 00:00:00 | 2011-04-13 00:00:00 | 2011-04-13 00:00:00 | 2011-04-13 00:00:00 | 2011-04-13 00:00:00
 |  | SIZE | NUMBER PRODUCED | NUMBER REJECTED | # OF MEN IN CELL | DOWNTIME HOURS | DOWNTIME CODE | Pieces Per 1 Labor Hour | Goal Pieces Per Labor Hour
HOUR 1 |  | 200 | 2000 | 5 | 8 | 1 | Setup | 92 | 736
HOUR 2 |  | 200 | 4000 | 8 | 8 | 2 | [NAME] | 92 | 736
HOUR 3 |  | 200 | 3000 | 12 | 8 | 3 | Scheduled Maintenance | 92 | 736
HOUR 4 |  | 45 | 1400 | 8 | 8 | 4 | Not Scheduled | 179 | 1432
HOUR 5 |  | 90 | 1000 | 6 | 8 | 5 | Other | 137 | 1096
HOUR 6 |  | 90 | 1000 | 6 | 8 | 6 | Setup | 137 | 1096
HOUR 7 |  | 90 | 900 | 9 | 8 | 7 | [NAME] | 137 | 1096
HOUR 8 |  | 250 | 500 | 20 | 8 | 8 | Scheduled Maintenance | 76 | 608
2ND SHIFT |  | 500 | 240 | 100 | 4 | 9 | Not Scheduled | 62 | 248
 |  |  | 14040 | 174 | 68 |  |  |  | 7784
 |  |  |  |  | 206.4705882352941 |  |  |  | 114.4705882352941
15 | 222 | Setup |  | 7
25 | 242 | [NAME] |  | 9
32 | 287 | Scheduled Maintenance |  | 11
45 | 179 | Not Scheduled |  | 13
65 | 172 | Other |  | 5
90 | 137
115 | 113
150 | 101
200 | 92
250 | 76
500 | 62
Spreadsheet: 866238d1713199988-help-with-formulas-to-populate-a-calendar-kansas-scheduler-calendar-test-v1
Sheet: Lists

PressList | [NAME] | 3R | Canon | Small HP | Big HP | HS | GS | INDIGO | Cut-Only |  | FabriVu
[NAME] | 2 Pass | 2 Pass | 2-Pass | 2-Pass | 2-Pass | No Smoothing | Light Smoothing | 1-Sided | Heat-Bend |  | [NAME]
3R | 3 Pass | 3 Pass | 3-Pass | 3-Pass | 3-Pass | Light Smoothing | Heavy Smoothing | 2-Sided | Kisscut/Weed/Premask |  | Backlit
Canon | 4 Pass | 5-Pass | 5-Pass | 5-Pass | 5-Pass | Heavy Smoothing | [NAME] |  | Laminate-Gloss
Small HP | Backlit | Backlit | Backlit | Backlit | Backlit | [NAME] | [NAME] |  | Laminate-Matte
Big HP | DS | 2-Sided | 2-Sided | 2-Sided | 2-Sided | [NAME] | [NAME] |  | Laminate-Other
HS | FU or [NAME] |  |  |  |  | [NAME] |  |  | Mount
GS | DS White |  |  |  |  |  |  |  | Shape-Cut
INDIGO | 8 Pass |  |  |  |  |  |  |  | Tape
Cut-Only | 8 Pass + White
 | 5 Layer
Spreadsheet: 96559d1295950502-max-function-test
Sheet: Extracts

 |  |  |  | [NAME]
 |  |  |  |  |  | /Path/ | No of Files
 |  |  |  |  |  |  | 27
 |  |  |  |  | Folder | [NAME] | Min No of Rows
 |  |  |  |  | DealerData | Need function for MAX to go in here
 |  |  |  |  | Directory | Filename | No of Rows
 |  |  |  |  | C:\Production2\ATX\Extracts\201001\AverageData | Book1.csv | 4
 |  |  |  |  | C:\Production2\ATX\Extracts\201001\AverageData | Book2.csv | 4
 |  |  |  |  | C:\Production2\ATX\Extracts\201001\AverageData | Book4.csv | 4
 |  |  |  |  | C:\Production2\ATX\Extracts\201001\AverageData | Book8.csv | 4
 |  |  |  |  | C:\Production2\ATX\Extracts\201001\AverageData | Book1.csv | 4
 |  |  |  |  | C:\Production2\ATX\Extracts\201001\AverageData | Book1.csv | 4
 |  |  |  |  | C:\Production2\ATX\Extracts\201001\AverageData | Book1.csv | 4
 |  |  |  |  | C:\Production2\ATX\Extracts\201001\AverageData | Book1.csv | 4
 |  |  |  |  | C:\Production2\ATX\Extracts\201001\AverageData | Book1.csv | 4
 |  |  |  |  | C:\Production2\ATX\Extracts\201001\AverageData | Book1.csv | 4
 |  |  |  |  | C:\Production2\ATX\Extracts\201001\AverageData | Book1.csv | 4
 |  |  |  |  | C:\Production2\ATX\Extracts\201001\AverageData | Book1.csv | 4
 |  |  |  |  | C:\Production2\ATX\Extracts\201001\AverageData | Book1.csv | 4
 |  |  |  |  | C:\Production2\ATX\Extracts\201001\AverageData | Book1.csv | 4
 |  |  |  |  | C:\Production2\ATX\Extracts\201001\DealerData | Book1.csv | 4
 |  |  |  |  | C:\Production2\ATX\Extracts\201001\DealerData | Book1.csv | 4
 |  |  |  |  | C:\Production2\ATX\Extracts\201001\DealerData | Book1.csv | 4
 |  |  |  |  | C:\Production2\ATX\Extracts\201001\DealerData | Book1.csv | 4
 |  |  |  |  | C:\Production2\ATX\Extracts\201001\DealerData | Book1.csv | 4
 |  |  |  |  | C:\Production2\ATX\Extracts\201001\DealerData | Book1.csv | 4
 |  |  |  |  | C:\Production2\ATX\Extracts\201001\DealerData | Book1.csv | 4
 |  |  |  |  | C:\Production2\ATX\Extracts\201001\DealerData | Book1.csv | 4
 |  |  |  |  | C:\Production2\ATX\Extracts\201001\DealerData | Book1.csv | 4
 |  |  |  |  | C:\Production2\ATX\Extracts\201001\DealerData | Book1.csv | 4
 |  |  |  |  | C:\Production2\ATX\Extracts\201001\DealerData | Book1.csv | 4
 |  |  |  |  | C:\Production2\ATX\Extracts\201001\DealerData | Book1.csv | 4
 |  |  |  |  | C:\Production2\ATX\Extracts\201001\DealerData | Book1.csv | 4
Spreadsheet: 856533d1705745933-date-challenge-transform-effective-date-range-to-day-time-series-date-challenge-transform-to-time-series2-hd
Sheet: Source Data

Source data:
Dep time | Arr time | Day | Effective | Elapsed Time | Flight No
18-30 | 20-30 | 5 | 16.04-29.10 | 02-00 | AB-352
07-40 | 09-20 | 1346 | 01.04-26.10 | 02-10 | CD-982
Maximum effective date range:
01.03-31.10
Spreadsheet: 53887d1253810347-returning-correct-cell-with-variable-information-problem-example
Sheet: Sheet1

 | 1 Insert | 2 Inserts | 3 Inserts | 4 Inserts | 5 Inserts | Total |  | [NAME] | Volume | Weight
Weight | 0.08192645749274913 | 0.1092352766569988 | 0.2508997760715442 | 0.0512040359329682 | 0.1501985054033734 | 0.6434640515576338 |  | Largest 1 | 1121151.666666667 | 0.08192645749274913
Volume | 1121151.666666667 | 5000 | 1121151.666666667 | 50000 | 1121151.666666667 | 3418455 |  | 2 | 1121151.666666667 | 0.08192645749274913
Total | 91851.9843620915 | 546.1763832849941 | 281296.7021089053 | 2560.20179664841 | 168395.3046638344 | 544650.3693147646 |  | 3 | 1121151.666666667 | 0.08192645749274913
% of Total | 0.1686439402908187 | 0.001002801823070733 | 0.5164720671406323 | 0.004700633545644063 | 0.3091805571998342 | 1 |  | 4 | 50000 | 0.0512040359329682
 |  |  |  |  |  |  |  | Smallest 5 | 5000 | 0.1092352766569988
Spreadsheet: 65806d1266464003-summarise-data-in-remote-workbook-book2
Sheet: Sheet1

Sales data in [NAME] 1 |  |  |  |  |  |  |  |  | Summary data in Workbook 2 |  | Sales From | 2010-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  | to | 2010-04-30 00:00:00
Part No | 2010-01-31 00:00:00 | 2010-02-28 00:00:00 | 2010-03-31 00:00:00 | 2010-04-30 00:00:00 | 2010-05-31 00:00:00 | 2010-06-30 00:00:00 |  |  |  |  | Part
1 | 37 | 46 | 32 | 34 | 43 | 46 |  |  |  |  | 2
2 | 42 | 14 | 13 | 24 | 19 | 40 |  |  |  |  | 4
3 | 22 | 22 | 47 | 11 | 50 | 32 |  |  |  |  | 6
6 | 49 | 26 | 13 | 29 | 43 | 38 |  |  |  |  | d
4 | 29 | 34 | 20 | 16 | 31 | 21 |  |  |  |  | a
a | 49 | 14 | 12 | 30 | 21 | 28
d | 40 | 32 | 44 | 26 | 47 | 45
e | 40 | 41 | 24 | 33 | 13 | 14
t | 39 | 28 | 26 | 13 | 14 | 16
h | 38 | 10 | 45 | 16 | 13 | 48
 | 48 | 10 | 29 | 41 | 39 | 23
 | Problem:
 | Summarise the data in Workbook 1 into Workbook 2 between given date criteria matching part numbers
Spreadsheet: 192191d1352332635-combine-line-chart-with-area-graph-copy-of-count-project-2012-1
Sheet: Sheet1

 | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12 | Week 13
2011 | 40759053 | 42835018 | 47269518 | 49128305 | 48041710 | 47377208 | 48152325 | 46956288 | 47316844 | 46402906 | 46825911 | 38500607 | 50793773
2012 | 54095179 | 53155991 | 57692278 | 55648236 | 56709974 | 51343165 | 53198937 | 53683834 | 55779238 | 56747312 | 57095478 | 57926485 | 56544101
2012 Target | 47468519.5725 | 46644382.1025 | 50624973.945 | 48831327.09 | 49763002.18499999 | 45053627.28749999 | 46682067.21749999 | 47107564.33499999 | 48946281.345 | 49795766.27999999 | 50101281.945 | 50830490.5875 | 49617448.6275
Difference | 13336126 | 10320973 | 10422760 | 6519931 | 8668264 | 3965957 | 5046612 | 6727546 | 8462394 | 10344406 | 10269567 | 19425878 | 5750328
% Difference | 0.3271942064012135 | 0.2409470914661458 | 0.2204964307019166 | 0.132712313197046 | 0.1804320454038792 | 0.08371023045511673 | 0.1048051573833662 | 0.1432725261417598 | 0.1788452754794889 | 0.2229258227922191 | 0.2193137683963052 | 0.5045603047245463 | 0.1132093101254754
Spreadsheet: 858442d1707139682-calculating-hours-and-hours-used-chronologically-using-oldest-hours-first-overtime-and-bestemming-uren
Sheet: employee

Year/Month | Overtime Hours | Used Hours | Total Compensation Hours Unused | NL05369
2021-12 |  |  |  |  | Hours | Used in | Hrs left |  | Hours | Used in | Hrs left
2022-01 | 1.25 | 0 |  |  | 1.25 | 2023-01 | 0
2022-02 | 0 | 0
2022-03 | 0 | 0
2022-04 | 0 | 0
2022-05 | 8 | 0 |  |  | 3.75 | 2023-01 | 4.25 |  | 4.25 | 2023-04 | 0
2022-06 | 8 | 0 |  |  | 3.75 | 2023-04 | 4.25
2022-07 | 0 | 0
2022-08 | 0 | 0
2022-09 | 0 | 0
2022-10 | 2.25 | 0
2022-11 | 23.40000000000001 | 0
2022-12 | 16.90000000000001 | 0
2023-01 | 15.25 | 5
2023-02 | 21.15000000000001 | 0
2023-03 | 18 | 0
2023-04 | 34.5 | 8
2023-05 | 38 | 40
2023-06 | 43.5 | 0
2023-07 | 27 | 0
2023-08 | 16.75 | 24
2023-09 | 38 | 0
2023-10 | 46 | 0
2023-11 | 40 | 0
2023-12 | 30 | 0
TOTALS | 426.7 | 85
Spreadsheet: 8384102f-52d0-440a-86ff-c38af97037fe
Sheet: Sheet1

Titel | Inst/Forening | [NAME] | Adresse | Postnummer | By | Telefon | Tilskud i kr.
Renovering af Endelave Kro | Endelave ApS | [NAME] | Kongevejen 59 | 8700 | Endelave | 29 65 87 14 | 200000
Købmandsgården | TUNØ-FONDEN | [NAME] | [NAME] 80, [NAME] | 8300 | Odder | 86 55 30 21 | 200000
Digitalisering af Strynø lokalhistoriske arkiv | [NAME] forening | [NAME] | Nørrevej 1 | 5900 | Rudkøbing | 23 41 07 46 | 15000
[NAME] | [NAME] | [NAME] | [NAME] 17C | 8300 | Odder | 86 55 33 39 | 50000
Renovering af  lagerbygning | [NAME]/korshavn [NAME] | [NAME] | Hovedvejen 42 | 5600 | Faaborg | 62 61 70 57 | 75000
Kvalitetsturisme og oplevelser på Mandø | Den selvejende institution [NAME] | [NAME] | [NAME] Mandø | 6760 | Ribe | 75 44 58 33 | 150000
Betalingsanlæg | Selvejende institution fonden for Omø lystbådehavn | Svend [NAME] | Søvej 34 Omø | 4230 | Skælskør | 58 19 90 08 | 70000
Køl til varebil | Havne Høkeren, [NAME] | [NAME] | Ahornvej 4 | 4990 | Sakskøbing | 54 70 64 02 | 75000
[NAME], renovering af lager og personaletoilet samt udsugning i butik | [NAME] | [NAME] | Lillegade 7, [NAME] | 4230 | Skælskør | 58 19 81 33 | 100000
Indeklima i butik | [NAME] | [NAME] | [NAME] 1 | 6760 | Ribe | 75 44 51 02 | 30000
[NAME] | Småøernes Erhvervs Udviklings Center (SEUC) | Kai Winter | Hjortemosevej 41 | 4944 | Fejø | 54 72 21 21 | 50000
Titel | Inst/Forening | [NAME] | Adresse | Postnummer | By | Telefon | [NAME] i kr.
Toliet anlæg [NAME] | [NAME] | Karin & Renny Rosenlund | Egholmvej 2-4, [NAME] | 4320 | Skælskør | 58 19 80 03 | 53000
Minilæsser til transport - og løfteopgaver på Anholt | Anholt Vognmandsforening ApS | Liselotte Arents Sørensen | Ageren 9 | 8592 | Anholt | 86 31 90 04 | 150000
Toiletter Lyø Camping | [NAME] | [NAME] | [NAME] | 5600 | Faaborg | 62 61 97 39 | 100000
Opgradering af Agersø Camping ApS´s faciliteter | [NAME] | [NAME] | Lillegade 7, [NAME] | 4230 | Skælskør | 58 19 81 33 | 100000
Etablering af selskabslokale i gammel lade | Biosynergy A/S | [NAME] | Østerhovedvej 4, Skarø | 5700 | Svendborg | 62 20 12 01 | 100000
Sikkerhedsstillelse leverandører | [NAME] og [NAME] | [NAME] | Helholmvej 8 | 4230 | Skælskør | 58 019 80 12 | 200000
Spreadsheet: 547340d1510503270-filling-across-a-range-of-sheets-test
Sheet: Bandit

BOAT NAME
OWNER NAME
MOORING TYPE
ADDRESS
HOME TEL
MOBILE TEL
[NAME]
BOAT TYPE
LENGTH
HULL COLOUR
UPPER DECK
TENDER?
DURATION
FEE
NEXT INVOICE DUE DATE | 2017-08-05 00:00:00
INVOICE DUE DATE | INVOICE REMINDER DATE | INVOICE SENT DATE | DATE PAID | NOTES
2017-08-05 00:00:00 |  | 2017-07-07 00:00:00
Spreadsheet: 33127d1229428731-formula-required-matrix-matrix-query
Sheet: Sheet2

Sum of Accounted Sum |  |  | [NAME] required = intercompany balance with company code
Company Code | Intercompany | Grand Total
101 | 0 | 200000
101 | 101 | 3000000
101 | 102 | 5800000 | What is the balance in company code 102 with 101?
101 | 111 | 8600000 | What is the balance in company code 111 with 101?
101 | 112 | 11400000
101 | 113 | 14200000
101 | 114 | 17000000
101 | 115 | 19800000
101 | 116 | 22600000
101 | 117 | 25400000
101 | 118 | 28200000
101 | 119 | 31000000
101 | 122 | 33800000
101 | 123 | 36600000
101 | 124 | 39400000
101 | 181 | 42200000
101 | 182 | 45000000
101 | 201 | 47800000
101 | 221 | 50600000
101 | 301 | 53400000
101 | 302 | 56200000
101 | 312 | 59000000
101 | 313 | 61800000
101 | 401 | 64600000
101 | 461 | 67400000
101 | 462 | 70200000
101 | 501 | 73000000
101 | 502 | 75800000
101 | 550 | 78600000
101 | 601 | 81400000
101 | 661 | 84200000
101 | 801 | 87000000
101 | 901 | 89800000
101 | 902 | 92600000
101 | 999 | 95400000
101 Total |  | -89214730.62999986
102 | 101 | 5800000
102 Total |  | 1583764.71
111 | 0 | 859328.9599999993
111 | 1 | 9078978
111 | 101 | 17298627.04
111 | 111 | 25518276.08
111 | 112 | 33737925.12
111 | 113 | 41957574.16
111 | 114 | 50177223.2
111 | 115 | 58396872.24
111 | 116 | 66616521.28
111 | 117 | 74836170.32
111 | 118 | 83055819.36
111 | 119 | 91275468.4
111 | 121 | 99495117.44
111 | 122 | 107714766.48
111 | 123 | 115934415.52
111 | 124 | 124154064.56
111 | 181 | 132373713.6
111 | 182 | 140593362.64
111 | 201 | 148813011.68
111 | 301 | 157032660.72
111 | 401 | 165252309.76
111 | 461 | 173471958.8
111 | 462 | 181691607.84
111 | 501 | 189911256.88
111 | 502 | 198130905.92
111 | 550 | 206350554.96
111 | 601 | 214570204
111 | 661 | 222789853.04
111 | 801 | 231009502.08
111 | 901 | 239229151.12
111 | 902 | 247448800.16
111 | 999 | 255668449.2
111 Total |  | 14462292.37000005
Spreadsheet: 330728d1404837031-time-analysis-example
Sheet: Sheet1

 | Time Allocated | Customer | In/Out |  | In/Out |  | In/Out |  | In/Out
 | Minutes |  | 2014-06-03 00:00:00 | Difference | 2014-06-10 00:00:00 | Difference | 2014-06-17 00:00:00 | Difference | 2014-06-24 00:00:00 | Difference
1 | 00:45:00 | [NAME] | 16:00:00 |  | 15:40:00 |  | 14:38:00 |  | 16:15:00
 |  | 123 Main Street | 16:30:00 |  | 16:50:00 |  | 16:38:00 |  | 16:50:00
Spreadsheet: 867114d1713993394-highlighting-cells-if-not-blank-and-corresponding-rows-less-than-zero-expired-serial-codes-excel-example
Sheet: Sheet1

Expiration Date | Software B Serial | Software C Serial | Days Remaining
2024-04-22 00:00:00 | [NAME]
2024-04-23 00:00:00 |  | wxyz5678 |  |  |  | Aim:
2024-04-24 00:00:00 |  |  |  |  |  | Only show yellow values if each row has a value in either column B or C
2024-04-25 00:00:00 |  |  |  |  |  | Highlight/colour cells in columns B and C if they are 'expired' - column D value less than 0
2024-04-26 00:00:00 | efgh4567
2024-04-27 00:00:00
2024-04-28 00:00:00 |  | [NAME]
2024-04-29 00:00:00
2024-04-30 00:00:00
Spreadsheet: 93243d1292858369-move-information-over-book1
Sheet: Sheet1

What I Have
17 |  | Cardle Street | Marlborough |  | Townley |  | BG7 8PI
 | 2 |  | Market Way |  |  | Hugh |  | AM9 2FG
[NAME] |  | Heaton |  | Utley |  |  | HG5 3HI
 |  | City Wide Resource | Clarence Close | Bromley | Orgen | Whitby | Scarborough | NW2 1GH
 | 25 | [NAME] | [NAME] |  | Essex
What I Want
17 Cardle Street | Marlborough | Townley | BG7 8PI
2 Market Way | Hugh | AM9 2FG
[NAME] | Heaton | Utley | HG5 3HI
City Wide Resource | Clarence Close | Bromley | Orgen | Whitby | Scarborough | NW2 1GH
25 [NAME] | [NAME] | Essex