tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 53864d1253792439-colidating-data-in-column-column_consolidation_issue_240909
Sheet: Department A

Head Count - Department A
Position | Name | Department | Location | Comments | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00
AA | Z Aoo | A | Beijing |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
AB | Z Boo | A | Beijing | New position - starts in Mar 2010 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
AC | Z Coo | A | Amsterdam |  | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
AC | Z Coo | A | Beijing | Moves to Beijing beg of Jul 2010 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1
AD | Z Doo | A | Amsterdam |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
AE | Z Eoo | A | Amsterdam |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
AF | Z Foo | A | Amsterdam | Position eliminates in Oct 2010 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0
AG | Z Goo | A | Beijing |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
AH | Z Foo | A | Beijing |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Spreadsheet: 54814d1254858667-using-same-range-in-a-formula-for-two-cells-rangequestion
Sheet: Sheet1

Data
1
1
1
1
1
1
1
0
0
1
1
0
0
0
1
1 |  |  | CountA | 16
 |  |  | Count | 11
Spreadsheet: darrell_schoolcraft__7801__imbalsumm0108
Sheet: Oasis

POI  8516
 | Measured | Scheduled | Imbal
1 | -55850 | -55438
2 | -43999 | -43938
3 | -29392 | -29570
4 | -59280 | -59683
5 | -59827 | -59683
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
 | 2001-07-31 00:00:00 |  | 40121
 | 2001-08-05 00:00:00
CBS Dollars
 |  |  | -273307
Spreadsheet: benjamin_rogers__1223__UAE's Cost Model with debt structure 04-20-00
Sheet: Summary

 | Enron Return Analysis
 |  | Capacity Price | NPV @ 15% (000's) | IRR
 | 5 Year Lease Structure | 4.5 | 5920.908565226732 | 0.5093535714870081
 |  | 5 | 7738.317058649568 | 0.6075607191815697
 |  | 5.5 | 9555.725552072405 | 0.7026310961257809
 |  | 6 | 11373.13404549524 | 0.7952782325669825
 |  | 6.5 | 13190.54253891807 | 0.8860089720247023
 | 20 Year Lease Structure With Debt | 4.5 | 6754.95945669812 | 0.4152275860309601
 | Refinancing in Year 6 - 20 | 5 | 9596.28950259036 | 0.4928650796413422
 |  | 5.5 | 12114.46006216203 | 0.5604014456272124
 |  | 6 | 14436.02878482811 | 0.6210077226161957
 |  | 6.5 | 16643.34564200493 | 0.6761414825916291
 | 7 Year Debt Structure | 4.5 | -17330.52701719655 | N/A
 |  | 5 | -15033.4310333762 | -0.3125605750828983
 |  | 5.5 | -12736.33504955584 | -0.1772975120693445
 |  | 6 | -10449.61710863003 | -0.09575383365154265
 |  | 6.5 | -8906.356120124372 | -0.0673866242170334
 | 20 Year Debt Structure With Debt | 4.5 | -13521.36638545829 | 0.02466290891170502
 | Refinancing in Year 8-20 | 5 | -10682.15423231613 | 0.04376784265041352
 |  | 5.5 | -8166.101565494549 | 0.06438123285770418
 |  | 6 | -5846.650735578544 | 0.08501639664173127
 |  | 6.5 | -3641.451771151806 | 0.1051890313625336
 | Notes:  Lease Structure
 | Years 1-5: 8.0% Rate; 90/10 D/E: Capacity @ $4.50
 | Years 6-20: 8.75% Rate;
 | Notes:  Debt Structure
 | Years 1-7: 70/30 D/E; 9.5% Rate; 12 year amort.
Spreadsheet: 0430d071-f396-4f98-9be4-732c03503de2
Sheet: Sheet1

BOOTH COOKIE ORDER CALCULATOR | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Enter the number of Booth Sale Hours you want to sign up for: |  | ( Average sale =                              25 pkgs per hour)
 | Pkgs | Cases
Recommended Order: | 0 | 0
[NAME] | 0 | 0 | 0.0676 | Determined per 2013 Sale Statistics as of 9/17/13
Trefoil | 0 | 0 | 0.0733
Do Si Do | 0 | 0 | 0.0674
Samoa | 0 | 0 | 0.297
Tagalong | 0 | 0 | 0.1842
[NAME] | 0 | 0 | 0.3106
 | 0 | 0 | 1.0001
By changing the number of booth sale hours, your estimate order will be adjusted accordingly.  This is a recommended order.  You may adjust your actual order by entering your quantities in e-Budde or by visiting a cookie cupboard.
Spreadsheet: 789209d1658998602-removing-duplicates-and-counting-test-sheet
Sheet: Summary

Summary
Invoice # | Sales person |  | Sales person | Invoice count |  |  | Invoice # | Sales person |  | Sales person | Count
10001 | Adam |  | Adam | 2 |  |  | 10001 | Adam |  | Adam | 2
10002 | [NAME] |  | [NAME] | 3 |  |  | 10002 | [NAME] |  | [NAME] | 3
10003 | [NAME] |  | [NAME] | 3 |  |  | 10003 | [NAME] |  | [NAME] | 3
10004 | [NAME] |  | [NAME] | 1 |  |  | 10004 | [NAME] |  | [NAME] | 1
10005 | [NAME] |  | [NAME] | 1 |  |  | 10005 | [NAME] |  | [NAME] | 1
10006 | Adam |  |  |  |  |  | 10006 | Adam
10007 | [NAME] |  |  |  |  |  | 10007 | [NAME]
10008 | [NAME] |  |  |  |  |  | 10008 | [NAME]
10009 | [NAME] |  |  |  |  |  | 10009 | [NAME]
10010 | [NAME] |  |  |  |  |  | 10010 | [NAME]
Spreadsheet: 94953d1294692203-make-a-calendar-with-noted-birthdays-etc-my2011-23
Sheet: w1

2010-12-27 00:00:00 |  |  |  |  |  | Anniversaries
 |  |  |  |  |  | Sam & Betty wed | 2004-01-07 00:00:00
 |  |  |  |  |  | Mel & Ann wed | 1987-02-05 00:00:00
 |  |  |  |  |  | Tom & Sis wed | 1978-05-12 00:00:00
This is 5 and 1/2 inches wide
So, that would be one page that is 11 inches (landscape mode).
Rows 1 thru 38 will total 8 and 1/2 inches high...  Printing 2 pages (2 weeks) on one standard sheet of paper.
For this discussion, we'll ignore the printer margin requirements.  I can figure that out later.
Spreadsheet: 841309d1693496958-match-date-on-two-different-pages-and-paste-data-in-columns-copy-of-ef-file
Sheet: 12-15 Day

 | CR1 | Priority | Headcount | QI
1 | Alinity RV
2 | Alinity RV
3 | Alinity RV
4 | Alinity RV
5 | Alinity RV
12 | [NAME]
13 | [NAME]
9 | Architect RV
15 | [NAME]
17 | Architect RV | 11 | 0.25 | Ray
 |  |  |  | Ray
31 | Architect RV | 10 | 0.25 | Ray
8 | Architect RV | 9 | 0.25 | Ray
10 | Architect RV | 8 | 0.25 | Ray
11 | [NAME] |  |  | Ray
18 | Architect RV | 7 | 0.25 | Ray
19 | Architect RV | 6 | 0.25 | Ray
20 | [NAME] trays |  |  | Ray
21 | Architect RV | 4 | 0.25 | Ray
22 | Architect RV | 3 | 0.25 | Ray
23 | Architect RV | 2 | 0.25 | Ray
7 | Architect SC | 1 | 0.25 | Ray
Total
 | CR2 | Priority
73 | 8ul | 4 | 0.25 | Belinda
74 | Side Cassette | 3 | 0.25 | Belinda
78 | PP3 | 2 | 0.25 | Nikki
79 | [NAME] | 1 |  | Nikki
77 | Base Cassette PQ | 6 | 1 | Nikki
87 | [NAME] | 5 |  | Belinda
53 | Architect RV | 8 | 0.2 | Nikki
61 | [NAME] | 12 | 0.25 | Nikki
64 | Siemens 1ML | 14 | 0.25 | Nikki
66 | [NAME] | 13 | 0.25 | Nikki
83 | [NAME] |  |  | Nikki
84 | Ceph MB#1 | 10 | 0.25 | Nikki
86 | [NAME] | 11 | 0.25 | Belinda
62 | NP227 |  |  | Nikki
63 |  |  |  | Nikki
67 | [NAME] |  |  | Nikki
88 | [NAME] | 15 | 0.25 | Belinda
106 |  |  |  | Nikki
107 |  |  |  | Nikki
108 | [NAME] | 7 | 0 | Nikki
109 | [NAME] OQ | 9 | 1 | Nikki
Total
 | CR3
201 | Mask | 1 | 3 | Belinda
202 | Mask |  |  | Belinda
203 | Mask |  |  | Belinda
204 | Mask |  |  | Belinda
205 | Mask-rework | 2 | 3 | Belinda
Total
 | Rework |  | 2
Grand Total
Spreadsheet: 123977d1317974044-sum-between-a-time-range-for-unique-list-name-helpfile
Sheet: Compatibility Report

 | Compatibility Report for CULINARY WHO'S WHOMacrofor 03.xls
 | Run on 9/22/2011 12:57
 | The following features in this workbook are not supported by earlier versions of Excel. These features may be lost or degraded when you save this workbook in an earlier file format.
 | Significant loss of functionality |  |  | # of occurrences
 | Some cells have more conditional formats than are supported by the selected file format. Only the first three conditions will be displayed in earlier versions of Excel. |  |  | 2
 |  |  |  | 'Sunday'!X10:DC77
 |  |  |  | 'Sunday'!R10:U131
 | Some cells have overlapping conditional formatting ranges. Earlier versions of Excel will not evaluate all of the conditional formatting rules on the overlapping cells. The overlapping cells will show different conditional formatting. |  |  | 6
 |  |  |  | 'Sunday'!S10:U131
 | One or more cells in this workbook contain a conditional formatting type that is not supported in earlier versions of Excel, such as data bars, color scales, or icon sets. |  |  | 7
 |  |  |  | 'Monday'!F39:I41
 |  |  |  | 'Tuesday'!F39:I41
 |  |  |  | 'Wendsday'!F39:I41
 |  |  |  | 'Thursday'!F39:I41
 |  |  |  | 'Friday'!F39:I41
 |  |  |  | 'Saturday'!F39:I41
 |  |  |  | 'Sunday'!X5:DD5
 | Some cells contain conditional formatting with the 'Stop if True' option cleared. Earlier versions of Excel do not recognize this option and will stop after the first true condition. |  |  | 23
 |  |  |  | 'Sunday'!X10:DC77
 |  |  |  | 'Sunday'!R10:R131
 |  |  |  | 'Sunday'!T10:U131
 |  |  |  | 'Sunday'!S10:S132
 | Minor loss of fidelity
 | A table style is applied to a table in this workbook. Table style formatting cannot be displayed in earlier versions of Excel. |  |  | 1
 |  |  |  | 'Sunday'!R9:U31
 | Some cells or styles in this workbook contain formatting that is not supported by the selected file format. These formats will be converted to the closest format available. |  |  | 181
Spreadsheet: 236845d1369039312-baseball-team-standings-softball-league
Sheet: Home and Away

 | Abu Dhabi Softball League
 | - Schedule - Results -
 | SCHEDULE | Umps | Home | Score | Away | Score
 | 2013-05-14 00:00:00 |  | Round 1
 | 19:00:00 | 3 | [NAME] | 22 | Benchwarmers | 23
 | 20:00:00 | 1 | [NAME] | 2 | Millennium Falcons | 9
 | 21:00:00 | 8 | Mother Falcons | 9 | Blue Jays | 14
 | 10:00 PM | 5 | Ballbarians | 14 | Abu Dhabi Mudcrabs | 13
 | 2013-05-21 00:00:00 |  | Round 2
 | 19:00:00 |  | Benchwarmers | 8 | Blue Jays | 7
 | 20:00:00 |  | [NAME] | 31 | [NAME] | 11
 | 21:00:00 |  | Abu Dhabi Mudcrabs |  | [NAME]
 | 10:00 PM
 | 2013-05-28 00:00:00 |  | Round 3
 | 19:00:00
 | 20:00:00
 | 21:00:00
 | 10:00 PM
 | 2013-06-04 00:00:00 |  | Round 4
 | 19:00:00
 | 20:00:00
 | 21:00:00
 | 10:00 PM
 | 2013-06-11 00:00:00 |  | Round 5
 | 19:00:00
 | 20:00:00
 | 21:00:00
 | 10:00 PM
 | 2013-06-18 00:00:00 |  | Round 6
 | 19:00:00
 | 20:00:00
 | 21:00:00
 | 10:00 PM
 | 2013-06-25 00:00:00 |  | Round 7
 | 19:00:00
 | 20:00:00
 | 21:00:00
 | 10:00 PM
 | 2013-07-02 00:00:00 |  | Round 8
 | 19:00:00
 | 20:00:00
 | 21:00:00
 | 10:00 PM
Spreadsheet: 882968d1731438749-dynamic-drop-down-using-tables-testworkbook
Sheet: Customer

Customer ID | First Name | Surname | Address Line 1 | Address Line 2 | Address Line 3 | County | Post Code | Telephone | [NAME] | Last Job Date | Customer Ref Extended Details | CustomerID For Lookup
 | Fred | Head
 | [NAME] | Bong
 | [NAME] | Thing
 | [NAME] | Station
Spreadsheet: 760943d1640554756-pq-add-row-with-if-cell-formula-how
Sheet: Blad1

 |  |  |  | In PQ add a new column with this result
 |  |  | PO MES | LF ivm RPM | LF | RPM
 |  |  | 2 |  | 8 | 65
 |  |  | 2 |  | 8 | 65
 |  |  | 2 |  | 8 | 65
 |  |  | 3 |  | 8 | 0
 |  |  | 3 |  | 9 | 0
 |  |  | 3 |  | 9 | 65
 |  |  | 3 |  | 9 | 65
 |  |  | 3 |  | 9 | 65
 |  |  | 3 |  | 9 | 65
 |  |  | 3 |  | 9 | 65
 |  |  | 3 |  | 9 | 0
 |  |  | 3 |  | 10 | 0
 |  |  | 3 |  | 10 | 0
 |  |  | 3 |  | 10 | 0
 |  |  | 4 |  | 10 | 65
 |  |  | 4 |  | 10 | 65
 |  |  | 4 |  | 10 | 65
 |  |  | 4 |  | 10 | 65
 |  |  | 4 |  | 10 | 65
 |  |  | 4 |  | 10 | 65
Spreadsheet: 855589d1705104645-creating-custom-charts-my-file-contains-chart-solution-need-to-recreate-it-in-excel-graph-trend-4-
Sheet: billing level

 | Billing Level
Visit Type 3 | Level 5 | Level 4 | Level 3 | Level 2 | Level 1 | Level N/A
OP | 0.1884984025559105 | 0.4036208732694356 | 0.2089456869009585 | 0.03801916932907348 |  | 0.1609158679446219
IP | 0.2525857376156777 | 0.002721829069134458 | 0.7294501905280348 | 0.0065323897659227 | 0.001633097441480675 | 0.007076755579749592
Spreadsheet: 284d70d5-ad87-4d7f-a312-2b207ce179f1
Sheet: Action Items

Project Name |  |  |  | Sponsor
Project Manager |  |  |  | Date Updated
ID | Description | Assigned To | Date Opened | Due Date | Date Closed | Status | Notes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
Spreadsheet: 1e5b4365-85b0-4f77-8d8a-1d39c36d8cb5
Sheet: 04-PE-Po

UNIVERSITETI I PRISHTINËS
Nr. 120
Prishtinë , më 18 . 1 . 2012.
 | Komisioni për lirim nga pagesa e semestrit të studentëve të Universitetit të Prishtinës,në mbledhjen e mbajtur më 16.1. 2012, mori
 | V E N D I M
 | Mbi lirimin nga pagesa e semestrit për [NAME] 2011/2012
 | [NAME] 2011/2012 lirohen nga pagesa e semestrit këta studentë nga
[NAME]
Nr. | Emri, emri i prindit dhe mbiemri | Komuna | Kategoria
1 | [NAME] | Deqan | I
2 | [NAME] | Deqan | I
3 | Egzon Muhamet Haxhosaj | Deqan | I
4 | Egzon Isuf Shala | Peje | III
5 | Egzona [NAME] | Peje | III
6 | [NAME] | Peje | III
7 | [NAME] | Gjakove | III
8 | [NAME] | Peje | III
9 | [NAME] | Peje | III
10 | Mergim [NAME] | Peje | IV
11 | [NAME] | Peje | IV
12 | Sofije Gani Toska | Peje | V
13 | Adelina Sylejman Turkaj | Gjakove | V
14 | [NAME] | Peje | V
15 | Isa Tahir Januzaj | Peje | V
16 | [NAME] | Peje | V
17 | [NAME] | Peje | V
18 | [NAME] | Peje | V
19 | [NAME] | Peje | I
VËREJTJE:
Studentët e liruar në bazë të këtij [NAME] të paraqiten në shërbimin financiar të fakultetit gjegjës për të bërë kërkesë për [NAME] e mjeteve të paguara për semester-ra.
 |  | K O M I S I O N I:
 |  | Prof.Dr.[NAME],kryetar              ________________
 |  | [NAME], anëtar                           ________________
 |  | [NAME], anëtar                         ________________
 |  | [NAME] Samadraxha(MASHT), anëtar ________________
 |  | Fehmi Ibrahimi(MPMS), anëtar          ________________
Spreadsheet: 26b2ac25-5333-4218-bae7-9cf518a56eaa
Sheet: Sheet1

Unnamed: 0 | Pile Volume Calculator | Unnamed: 2 | Unnamed: 3
 |  | Instructions: (1)  Save the spreadsheet to your own computer before entering data.  (If you forgot, try [esc] when you are asked for a password.)  (2)  Enter typical dimensions in the red boxes.  For the 'round footprint' shapes, width is used and any length given is ignored.  For a half-sphere, only pile width is used.
height | 4
width | 8 |  | (3)  Choose the picture whose shape most closely matches that of a typical pile.  The most common shapes are highlighted in orange.
length | 40 |  | (3)  Under the picture read the pile's volume and enter it on the permit application.  It is helpful if you note in the fuel description on the application which shape was used.
 | Mound / Parabola Cross-section | Semi-circle or Oval / Ellipse Cross-section | Rectangular Cross-Section
Round Footprint | Circular paraboloid      (round mound) | Half-sphere | Upright cylinder               (water tank)
 | 100.5309649148734 | 134.0412865531645 | 201.0619298297468
Oval / Ellipse Footprint | Elliptical paraboloid*    (oval mound) | Half-ellipsoid | Upright oval cylinder
 | 502.6548245743669 | 670.2064327658226 | 1005.309649148734
[NAME] | Parabolic half-tube | Horizontal half-cylinder | Box
 | 853.3333333333334 | 1005.309649148734 | 1280
From PNW-GTR-364, "Guidelines for Estimating Volume, Biomass, and Smoke Production for Piled Slash" and other sources
 | [NAME]
[NAME] are in the cube of feet (or of any other linear unit used consistently).
Spreadsheet: 886968d1737049276-find-greater-hour-in-same-date-based-on-id-and-get-a-value-book-alkiviadi
Sheet: Φύλλο1

Timestamp | Name | Action
15 /01 /2025, 16:07:14 | George
15 /01 /2025, 16:41:59 | George
15 /01 /2025, 10:00:00 | [NAME]
15 /01 /2025, 22:00:00 | [NAME]
16 /01 /2025, 10:00:00 | George
16 /01 /2025, 18:00:00 | George
13 /01 /2025, 10:00:00 | [NAME]
13 /01 /2025, 22:00:00 | [NAME]
14 /01 /2025, 10:00:00 | [NAME]
14 /01 /2025, 22:00:00 | [NAME]
16 /01 /2025, 10:00:00 | [NAME]
16 /01 /2025, 22:00:00 | [NAME]
17 /01 /2025, 10:00:00 | [NAME]
17 /01 /2025, 22:00:00 | [NAME]
Spreadsheet: 076a39ca-7e3e-4acf-9d85-e1c2c1a69c60
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 |  |  | Coolhurst LT & SRC
 |  | [NAME] Summer 2010
Preliminary | First Round | Second Round | Quarter Finals | Semi Finals | Final
By end Sat 28 May | By end Friday 3 June | By end Weds 8 June | By end Sun 12 June | By end Thurs 16 June | On Sat 18 June
 | Bloomfield/Russ
 | 1 | Bloomfield/Russ
Khan/Dolman |  | 6-1,6-2
 | Vernon/Shokraj
Shokraj/Vernon |  |  | Bloomfield/Russ
 |  |  | 6-4,6-0
 | Zinkin/Lafferty
 |  | Ballard/Laudis
 |  | 6-2,3-6,6-2
 | Ballard/Laudis
[NAME] | Hayward/Searle |  |  | Budget/Hayes
 | 6-1,6-0
[NAME] |  | Hayward/Searle
 |  | 6-3,6-4
 | Midhage/Clifton
 |  |  | Budget/Hayes
 |  |  | 6-2,6-4
 | Donges/Manshoor
 |  | Budget/Hayes
 |  | 6-1,6-2
 |  |  |  |  | Jackson/S. Searle
 | Budget/Hayes
 | 8
 | Haggert/Brewester
 | 4 | Haggert/Brewester
 |  | 6-0,6-1
 | Moore/Masters |  | Haggert/Brewester
 | Goulborn/Bursell
 |  | Artis/Dexter
 |  | 6-4,6-3
 | Artis/Dexter |  |  | Jackson/S. Searle
 |  |  |  | 6-3,6-7,6-4
 | Rook/Rook
 |  | Burdge/Perfect |  |  |  | Jackson/S. Searle
 |  | 3-6,6-3,6-3
 |  |  |  |  |  | WINNER
 | Burdge/Perfect |  | Jackson/S. Searle
 | Taylor/Kostyuk
 |  | Jackson/S. Searle
 | Jackson/S. Searle
 | 5
Preliminary | First Round | Second Round | Quarter Finals | Semi Finals | Final
By end Sat 28 May | By end Friday 3 June | By end Weds 8 June | By end Sun 12 June | By end Thurs 16 June | On Sat 18 June
 |  |  | Coolhurst LT & SRC
 |  | [NAME] Summer 2010
Preliminary | First Round | Second Round | Quarter Finals | Semi Finals | Final
By end Sat 28 May | By end Friday 3 June | By end Weds 8 June | By end Sun 12 June | By end Thurs 16 June | On Sat 18 June
 | Becker/McChrystal
 | 6 | Becker/McChrystal
 |  | 6-0,6-0
 | Maunder/McCartney |  | Williams/Mbaka
 |  |  | w/o
 | Keverne/Keverne
 |  | Williams/Mbaka
 |  | w/o
 | Williams/Mbaka
Maccrae/Monaghan |  |  |  | Mbaka/Williams
 | Maccrae/Monaghan |  |  | 7-5,1-6,6-1
 | 6-1,6-1
 |  | [NAME]
Williamson/N. Moore |  | 5-7,6-4,6-2
 | Bushe/Beveridge
 |  |  | Ware/Selkirk
 |  |  | 6-2,7-6
 | Ware/Selkirk
 |  | Ware/Selkirk
 |  | w/o
 | Colbourne/Whiteman
 | 3 |  |  |  | Bourne/Hancock
 | Kovar/Penny |  |  |  | w/o
 | 7 | Kovar/Penny
 |  | 6-3,6-1
 | Wilson/Kennedy
[NAME] |  |  | Kovar/Penny
 | [NAME] |  | 6-2,3-6,7-5
 | bye
[NAME] |  | [NAME]
 | [NAME] |  |  | Bourne/Hancock
 |  |  |  | 7-6,7-6
 | Corbett/Bruce
 |  | Corbett/Bruce
 | Beytell/Gardiner |  | Bourne/Hancock
 |  |  | 6-1,6-1
 | De Winter/Berry
 |  | Bourne/Hancock
 |  | 6-0,6-2
 | Bourne/Hancock
 | 2
By end Sat 28 May | By end Friday 3 June | By end Weds 8 June | By end Sun 12 June | By end Thurs 16 June | On Sat 18 June
Preliminary | First Round | Second Round | Quarter Finals | Semi Finals | Final
Spreadsheet: 718207d1613045342-locking-formulas-and-constants-from-sheet-1-in-sheet-2-janine
Sheet: Costing

Ingredients | Purchase size gr/ml | Purchase Cost | Cost per gr/ml | Units needed |  | Cost per serving
Salt | 500gr | 9 |  | 18
Herbs | 18gr | 19 |  | 3.64
Oil | 2L | 50 |  | 750
Vinegar | 750ml | 11 |  | 125
Eggs | 30 | 50 |  | 5
Parsley | 3 | 12 |  | 1
Spring Onion | 8 | 13 |  | 2
[NAME] | 10 | 8 |  | 5 |  |  |  | COST TO MAKE 1L
Packaging
 |  | Purchase Cost | Plus Labelling | Ingredients | Ingredients and bottle | Selling Price | Profit/Loss | Refill
Milk Bottles | 300ml |  |  |  |  |  |  | 30
 | 500ml | 3.5 |  |  |  | 60 |  | 50
 | 1L | 4.5 |  |  |  | 80 |  | 70
[NAME] | [NAME] | 10.5 |  |  |  | 40 |  | 30
 | 500ml | 11.9 |  |  |  | 60 |  | 50
Bucket | 2L | 20 |  |  |  | 160 |  | 150
[NAME] | Small | 2
 | Large | 2.6
[NAME] | Small | 0.35
 | Large | 0.4
Milk Bottle Caps | One Size
Palm leaves | Small | 0.35
 | Large | 0.4
Spreadsheet: phillip_allen__28945__Master0509
Sheet: EXPANSIONS

PIPELINE | DATE | VOLUME | RECEIPT | DELIVERY
Kern | 2001-07-01 00:00:00 | 135000 | Rockies | California
Kern | 2003-05-01 00:00:00 | 900000 | Rockies | California
EPNG - All American | 2001-10-01 00:00:00 | 230000 | Perm | Ehrenburg
Southern Trails | 2002-05-01 00:00:00 | 80000 | South TransColorado | Into SoCal | Maybe as late as July
Wilcox | 2001-08-01 00:00:00 | 130000 | South Mainline | To Mexico
Spreadsheet: 463171d1464342435-split-the-numbers-sample-sheet
Sheet: Data

Date | Vehicle Number | Kgs
2016-06-01 00:00:00 | KA 20 AA 001 | 1420
2016-06-01 00:00:00 | KA 20 AA 002 | 2110
2016-06-01 00:00:00 | KA 20 AA 003 | 17690
2016-06-01 00:00:00 | KA 20 AA 004 | 4100
2016-06-01 00:00:00 | KA 20 AA 005 | 4210
2016-06-01 00:00:00 | KA 20 AA 006 | 5405
2016-06-01 00:00:00 | KA 20 AA 007 | 3900
2016-06-01 00:00:00 | KA 20 AA 008 | 1680
2016-06-01 00:00:00 | KA 20 AA 009 | 4995
2016-06-01 00:00:00 | KA 20 AA 010 | 750
2016-06-01 00:00:00 | KA 20 AA 011 | 1505
2016-06-01 00:00:00 | KA 20 AA 012 | 935
2016-06-01 00:00:00 | KA 20 AA 013 | 11365
2016-06-01 00:00:00 | KA 20 AA 014 | 5240
2016-06-01 00:00:00 | KA 20 AA 015 | 3635
2016-06-01 00:00:00 | KA 20 AA 016 | 1575
2016-06-01 00:00:00 | KA 20 AA 017 | 17475
2016-06-01 00:00:00 | KA 20 AA 018 | 11455
2016-06-01 00:00:00 | KA 20 AA 019 | 12320
2016-06-01 00:00:00 | KA 20 AA 020 | 1125
Spreadsheet: 76181d1276718317-if-function-example1
Sheet: Sheet1

 |  |  |  |  | Year 2004 sales | 10000
 |  |  |  |  | 1st comp entry | 2006
 |  |  |  |  | 2nd comp entry | 2009
 |  |  |  |  | annual growth | 0.1
 |  | Year | Unit sales |  | 1st comp drop | 0.3
 |  | 2004 |  |  | 2nd comp drop | 0.15
 |  | 2005
 |  | 2006
 |  | 2007
 |  | 2008
 |  | 2009
 |  | 2010
 |  | 2011
 |  | 2012
 |  | 2013
Spreadsheet: 873577d1720084142-data-formatting-help-example
Sheet: Data

Original Example - format will be the same but there may be more or fewer rows |  |  |  | Required Output
Product Description | Ingredient | Country of Origin |  | Product Description | Ingredient | Country of Origin
Product 1 | Water | UK |  | Product 1 | Water | UK
 | Fish | Spain |  | Product 1 | Fish | Spain
 | Sugar | UK |  | Product 1 | Sugar | UK
 | Salt | UK, The Netherlands, Portugal, Italy |  | Product 1 | Salt | UK
 | Butter | UK, New Zealand |  | Product 1 | Salt | The Netherlands
 | [NAME] | UK, France |  | Product 1 | Salt | Portugal
 | Eggs | UK |  | Product 1 | Salt | Italy
 | Milk | Uk, Jersey |  | Product 1 | Butter | UK
 |  |  |  | Product 1 | Butter | New Zealand
 |  |  |  | Product 1 | [NAME] | UK
 |  |  |  | Product 1 | [NAME] | France
 |  |  |  | Product 1 | Eggs | UK
 |  |  |  | Product 1 | Milk | Uk
 |  |  |  | Product 1 | Milk | Jersey
Spreadsheet: 329596d1404350415-pokemon-sheet-need-help-retrieving-multiple-results-pokemonedit
Sheet: Type Search

Type 1 & 2 Search |  |  |  |  | Search |  |  |  |  |  |  |  |  |  | Types
Search Type    → | Bug | Type 1 | Type 2 |  | Type 1 | Bug | List of Pokemon
List of Pokemon |  |  |  |  | Type 2 | Flying |  |  |  |  |  |  |  |  | None
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bug
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dark
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dragon
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Electric
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fairy
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fighting
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fire
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Flying
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ghost
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Grass
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ground
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ice
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Normal
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Poison
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Psychic
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rock
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Steel
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Water
Spreadsheet: 783146d1654612445-if-cell-contains-a-specific-text-under-the-same-group-col-a-then-return-true-else-false-example-sheet
Sheet: Sheet1

Serial # | Country | USA and UK | USA and India | Germany and Italy | China and Japan
A1 | Colombia | True | False | False | True
A1 | USA | True | False | False | True
A1 | Australia | True | False | False | True
A1 | China | True | False | False | True
A1 | Japan | True | False | False | True
A1 | UK | True | False | False | True
B1 | Germany | True | False | True | False
B1 | USA | True | False | True | False
B1 | UK | True | False | True | False
B1 | Italy | True | False | True | False
A2 | China | False | False | False | True
A2 | Australia | False | False | False | True
A2 | Japan | False | False | False | True
A1 | China | True | False | False | True
B1 | Japan | True | False | True | False