tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 106267d1303425520-how-to-lock-the-1st-drop-down-list-quote-form
Sheet: Sheet1

 |  | Date:
 |  |  |  |  |  | QUOTATION REQUEST
 |  | Prepared For: |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  | Shipment Description: |  |  |  |  |  |  | Consignee | Address and Details:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Transportation | Ground | Dom.Air | Intl.Air | Ocean | Other
 |  | Reference # : |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ground | Small Pack | NDA Early Am | NDA | LCL | See Notes
 |  |  |  |  |  |  | Door to Door |  |  |  |  |  |  |  |  |  |  | Dom.AIR | LTL | NDA | Priority | FCL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Intl.AIR | FTL | 2nd Day | Economy
 |  | Commodity: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ocean | Other | Economy
 |  | Est. Commercial Value: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Other
 |  | Total # Of Pieces: |  |  |  |  |  |  | Freight Charge: |  | USD
 |  | Actual Weight:
 |  | Dimensional Weight:
 |  | Transportation Type: |  |  |  | Dom.AIR | Economy |  | Origin Accessorials:
 |  | Origin: |  |  |  | 89502 |  |  |  |  | USD
 |  | Destination: |  |  |  |  |  |  |  |  | USD
 |  | Shipment Insured ? |  |  |  |  |  |  |  |  | USD
 |  | IncoTerms: |  |  |  | CIF |  |  |  |  | USD
 |  | C/D/T Clearance: |  |  |  | Consignee |  |  | Destination Accessorials:
 |  |  |  |  |  |  |  |  |  |  | USD
 |  | Freight Terms: |  |  |  | Pre-paid |  |  |  |  | USD
 |  |  |  |  |  |  |  |  |  |  | USD
 |  | Shipment Details (In Inches, Total Pounds, Total USD): |  |  |  |  |  |  |  |  | USD
 |  | Pieces | L | W | H | Actual Weight | Ins/Dec Value Total |  | Insurance/Declared Value:
 |  |  |  |  |  |  |  |  | Insurance |  | USD
 |  |  |  |  |  |  |  |  |  | Coverage Amount
 |  |  |  |  |  |  |  |  | Transit Time: |  | Days
 |  | Notes: |  |  |  |  |  |  | Total Price Quoted: |  | USD
 |  |  |  |  |  |  |  |  | **Quote Does Not Include C/D/T Clearance
 |  | Est. Date Freight Will be Ready for PU:
Spreadsheet: 169384d1342801347-arranging-information-into-tables-new-problem-1
Sheet: Sheet3

Sheet Three
"Helper" | Unit/Process | Rating
[NAME] | Outlet works | C
D-4 | Channels | D
A-6 | Effluent Quality | A
C-5 | Sampling Equipment | C
B-4 | Flow | B
A-7 | Solids Levels | A
D-5 | Screen Opereration | D
Spreadsheet: 754234d1636037893-sheet2-b-get-number-reference-from-another-cell-example-sheet
Sheet: Sheet1

Example 1 |  |  | Example 2 |  |  | Example 3
Group |  |  | Group 2 |  |  | Group 3
N = | Text | ID | N = | Text | ID | N = | Text | ID
1 |  | 18 | 1 |  | 10 | 1 |  | 3
2 |  | 20 | 2 |  | 12 | 2 |  | 15
3 |  | 5 | 3 |  | 8 | 3 |  | 6
4 |  | 2 | 4 |  | 1 | 4 |  | 14
5 |  | 9
6 |  | 13
Spreadsheet: ef21cc7e-54fb-49da-b2d0-fd1be4f19125
Sheet: Sheet1

State of New Hampshire - Primary Election | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Sept. 11, 2012 | State Senate District 22 - Republican
 | Morse, r | Czaia, d | [NAME]
Atkinson | 712 |  | 2
[NAME] | 586 | 1
Plaistow | 492 | 4 | 4
Salem | 1936 |  | 10
TOTALS | 3726 | 5 | 16
 | State Senate District 23 - Republican
 | Acton, r | Prescott, r | Croteau, d | [NAME]
Brentwood | 91 | 270
Chester | 109 | 347 |  | 2
Danville | 93 | 256 |  | 1
East Kingston | 56 | 247
Epping | 102 | 335 |  | 1
Exeter | 188 | 867 |  | 5
Fremont | 183 | 239 |  | 3
Kingston | 86 | 467
Sandown | 110 | 383 |  | 3
Totals | 1018 | 3411 |  | 15
 | State Senate District 24 - Republican
 | Stiles, r | Hollingworth, d | [NAME]
Greenland | 291 |  | 1
Hampton | 1099 | 2 | 2
[NAME] | 289
Kensington | 166 | 2 | 3
New Castle | 171 |  | 1
Newton | 194 |  | 2
[NAME] | 432
Rye | 606 |  | 3
Seabrook | 357
[NAME] | 65
Stratham | 830 | 1 | 4
Totals | 4500 | 5 | 16
Spreadsheet: 862938d1710506835-looking-back-at-most-recent-better-or-worse-result-excel-help
Sheet: Records

ALL-TIME RECORDS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GAMES | 11
CONSECUTIVES |  | WINS |  |  | DRAWS |  |  | DEFEATS |  |  |  |  |  | GOALS SCORED |  |  | [NAME] |  |  |  | CURRENT FORM
 |  | TOTAL | TIMES |  | TOTAL | TIMES |  | TOTAL | TIMES |  |  |  |  | TOTAL | TIMES |  | TOTAL | TIMES
ALL COMPS | ALL |  | 1 |  |  | 1 | 2 |  | 1 | 2 | 3 | 4 |  |  | 1 |  |  | 1 |  |  |  | POINTS
 | HOME |  | 1 |  |  | 1 |  |  | 1 |  |  | 2 |  |  | 1 |  |  | 1 |  |  | LEAGUE
 | AWAY |  | 1 | 2 |  | 1 | 2 |  | 1 |  |  |  |  |  | 1 |  |  | 1
LEAGUE ONLY | ALL |  | 1 |  |  | 1 | 2 |  | 1 |  |  |  |  |  | 1 |  |  | 1 |  |  | ALL COMPETITIONS
 | HOME |  | 1 | 2 |  | 1 |  |  | 1 | 2 | 3 | 4 | 5 |  | 1 |  |  | 1
 | AWAY |  | 1 |  |  | 1 |  |  | 1 |  |  |  |  |  | 1 |  |  | 1
LONGEST RUNS |  | WITHOUT DEFEAT |  |  | WITHOUT DRAW |  |  | WITHOUT WIN |  |  |  |  |  | WITHOUT CONCEDING |  |  | WITHOUT SCORING
 |  | TOTAL | TIMES |  | TOTAL | TIMES |  | TOTAL | TIMES |  |  |  |  | TOTAL | TIMES |  | TOTAL | TIMES
ALL COMPS | ALL |  | 1 |  |  | 1 |  |  | 1 |  |  | 2 |  |  | 1 | 2 |  | 1 |  |  | COMPARISON BETTER |  |  | MOST RECENT
 | HOME |  | 1 |  |  | 1 |  |  | 1 |  |  |  |  |  | 1 |  |  | 1
 | AWAY |  | 1 |  |  | 1 |  |  | 1 |  |  |  |  |  | 1 |  |  | 1 | 2 |  | LEAGUE
LEAGUE ONLY | ALL |  | 1 |  |  | 1 |  |  | 1 |  |  | 2 |  |  | 1 | 2 |  | 1
 | HOME |  | 1 |  |  | 1 | 2 |  | 1 |  |  |  |  |  | 1 |  |  | 1 |  |  | ALL COMPETITIONS
 | AWAY |  | 1 |  |  | 1 |  |  | 1 |  |  |  |  |  | 1 |  |  | 1
SEARCH BOX |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | COMPARISON WORSE
CONSECUTIVES |  | WINS |  |  | DRAWS |  |  | DEFEATS |  |  |  |  |  | GOALS SCORED |  |  | [NAME] |  |  |  | LEAGUE
 |  | TOTAL |  |  | TOTAL |  |  | TOTAL |  |  |  |  |  | TOTAL |  |  | TOTAL
ALL COMPS | ALL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ALL COMPETITIONS
 | HOME
 | AWAY
LEAGUE ONLY | ALL
 | HOME
 | AWAY
LONGEST RUNS |  | WITHOUT DEFEAT |  |  | WITHOUT DRAW |  |  | WITHOUT WIN |  |  |  |  |  | WITHOUT CONCEDING |  |  | WITHOUT SCORING
 |  | TOTAL |  |  | TOTAL |  |  | TOTAL |  |  |  |  |  | TOTAL |  |  | TOTAL
ALL COMPS | ALL
 | HOME
 | AWAY
LEAGUE ONLY | ALL
 | HOME
 | AWAY
SEASON RECORDS |  | WINS |  |  | DRAWS |  |  | DEFEATS |  |  |  |  |  | GOALS SCORED |  |  | [NAME]
MOST |  | TOTAL | SEASON |  | TOTAL | SEASON |  | TOTAL | SEASON |  |  |  |  | TOTAL | SEASON |  | TOTAL | SEASON
LEAGUE ONLY | ALL
 | HOME
 | AWAY
SEASON RECORDS |  | WINS |  |  | DRAWS |  |  | DEFEATS |  |  |  |  |  | GOALS SCORED |  |  | [NAME]
LEAST |  | TOTAL | SEASON |  | TOTAL | SEASON |  | TOTAL | SEASON |  |  |  |  | TOTAL | SEASON |  | TOTAL | SEASON
LEAGUE ONLY | ALL
 | HOME
 | AWAY
SEASON RECORDS |  | SCORED IN |  |  | DIDN'T SCORE |  |  | CONCEDED IN |  |  |  |  |  | DIDN'T CONCEDE
 |  | TOTAL | SEASON |  | TOTAL | SEASON |  | TOTAL | SEASON |  |  |  |  | TOTAL | SEASON
LEAGUE ONLY | ALL | ALL (16) | 1898/9
 | HOME | ALL | 8 TIMES
 | AWAY | ALL (16) | 1898/9
Spreadsheet: 872953d1719406852-formula-to-look-at-range-and-return-value-bradford-factor-template
Sheet: Sheet1

 | [NAME] points = | 0 - 50 | No action
 |  | 51 - 100 | Informal meeting
 |  | 101 - 150 | Recorded meeting
 |  | 151 - 200 | Verbal warning
 |  | 201 - 250 | Written warning
 |  | 251 - 300 | Final written warning
 |  | 301 - 350 | [NAME]
 | Employee Name | Job Role | Start date | Total number of instance of absence | Total number of absence days | Bradford score
Spreadsheet: 82809d1282828518-indexing-a-row-from-another-worksheet-within-workbook-dummybook
Sheet: Needed

 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24
 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | 2031 | Total
Units: | ***This row must mimic the units in Acq. Cycle, so that when acquisitions change by year/life cycle, this will change accordingly…
Spreadsheet: 86039d1286006287-grouping-amounts-based-on-working-days-map1
Sheet: Pivot

 | Values
Company | Total Current | Total  0-30 | Total 31-60 | Total 61-90 | Total 90 > | Total Outstanding
A |  |  |  | 2700 | 2512 | 5212
B | 2000 | 100 |  | 1815 |  | 3915
Eindtotaal | 2000 | 100 |  | 4515 | 2512 | 9127
Spreadsheet: 854130d1704110585-choose-col-with-with-filter-choose-cols-filter-data-added_glen
Sheet: Sheet3

 | Your expected results:
 | 1 | 75 | The  American Insurance Company Limited. | 3 | 52 | 41
 |  | 3 | Tractors Service Pvt Ltd,Dysneyland |  | 30 | 25
 | 5 | 8 | Carnivalsepal Weight Services Pvt Ltd | 0 | 0 | 3
 | 7 | 9 | [NAME] ([NAME] ( (Main)) | 6 | 45 | 40
 | 8 |  | Myselfi & Associates Trading Pvt.Ltd | 2 | 9 | 11
 | Glen formula:
 |  | 75 | The American Insurance Company Limited. | 30 | 52 | 41
 |  | 3 | Tractors Service Pvt Ltd,Dysneyland |  | 30 | 25
 | 5 | 8 | Carnivalsepal Weight Services Pvt Ltd | 0 | 0 | 3
 | 7 | 9 | [NAME] ([NAME] (Main)) | 60 | 45 | 40
 | 8 |  | Myselfi & Associates Trading Pvt.Ltd | 2 | 9 | 11
 |  |  | Aarti Soap & Chemical Industries Pvt Ltd,Birkune |  | 0 | 0 |  | < this is extracting/pulling which infact we don't require
 |  |  | Aashis Plastic Traders |  | 0 | 0 |  | < this is extracting/pulling which infact we don't require
 |  |  | Alive Pharmaceutical Pvt. Ltd.,Nrt |  | 0 | 0 |  | < this is extracting/pulling which infact we don't require
Spreadsheet: 35439d1233044902-nesting-if-formulas-eg-of-vlookup-and-dynamic-reference-table
Sheet: Calculations

Quantity (units) | Rate (Pounds) | Total (Pounds)
0 | 0 | 0
1 | 1.54 | 1.54
201 | 1.34 | 269.34
401 | 1.22 | 489.22
601 | … | #N/A | this row shows an error because I entered a non-numeric "…" in the Reference Table.
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
Spreadsheet: 807260d1669822424-excel-formula-lookup-values-if-found-then-this-if-not-then-this-book1-1-
Sheet: Sheet1

[NAME] | Query Email | Query Phone # | Manual Name | Manual Email | Manual Phone # | [NAME] | Phone # Result
Employee #1 | [EMAIL] | [PHONE] | Employee #2 | [EMAIL] | [PHONE] |  |  |  |  | [PHONE]
Employee #2 | [EMAIL] | [PHONE] | Employee #5 | [EMAIL] | [PHONE] |  |  |  | [EMAIL] | [PHONE]
Employee #3 | [EMAIL] | [PHONE] | Employee #6 | [EMAIL] | [PHONE] |  |  |  | [EMAIL] | [PHONE]
Employee #4 | [EMAIL] | [PHONE] | Employee #7 | [EMAIL] | [PHONE] |  |  |  | [EMAIL] | [PHONE]
Employee #5 | [EMAIL] | [PHONE] | Employee #11 | [EMAIL] | [PHONE] |  |  |  | [EMAIL] | [PHONE]
Employee #6 | [EMAIL] | [PHONE] | Employee #15 | [NAME] | [PHONE] |  |  |  | [EMAIL] | [PHONE]
Employee #7 | [EMAIL] | [PHONE] |  |  |  |  |  |  | [EMAIL] | [PHONE]
Employee #8 | [EMAIL] | [PHONE] |  |  |  |  |  |  | [EMAIL] | [PHONE]
Employee #9 | [EMAIL] | [PHONE] |  |  |  |  |  |  | [EMAIL] | [PHONE]
Employee #10 | [EMAIL] | [PHONE] |  |  |  |  |  |  | [EMAIL] | [PHONE]
Employee #11 | [EMAIL] | [PHONE] |  |  |  |  |  |  | [EMAIL] | [PHONE]
Employee #12 | [EMAIL] | [PHONE] |  |  |  |  |  |  | [EMAIL] | [PHONE]
Employee #13 | [EMAIL] | [PHONE] |  |  |  |  |  |  | [EMAIL] | [PHONE]
Employee #14 | [EMAIL] | [PHONE] |  |  |  |  |  |  | [EMAIL] | [PHONE]
Employee #15 | [EMAIL] | [PHONE] |  |  |  |  |  |  | [NAME] | [PHONE]
Spreadsheet: 862010d1709814528-summarizing-no-of-orders-from-the-different-sheets-to-a-table-master-plan-202403-rev-2
Sheet: Summary

 | Quantity of Orders
 | Trade | Work Type | 2024
 |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 | MVAC | PM | 5
 |  | CM | 1
 |  | A+A | 1
 | [NAME] | PM | 9
 |  | CM | 1
 |  | A+A
 | UPS | PM | 6
 |  | CM | 1
 |  | A+A | 1
 | Elect | PM
 |  | CM | 2
 |  | A+A
 |  | PITC | 2
 | BA | PM | 1
 |  | CM | 1
 |  | A+A | 1
Spreadsheet: 769968d1645737928-how-to-import-multiple-text-files-in-its-own-unique-column-how-to-import-multiple-text-files-in-its-own-unique-column
Sheet: What I want

File A | File B | File C |  | I manually copy and pasted these data points from the text files individually
20 | 19 | 28 |  | But with the currently job, I have multiple files to load in and manually copy and pasting would take too much time
16 | 21 | 25
15 | 28 | 17 |  | File A, B and C are three separate text files with a single column of numerical data
18 | 5 | 29 |  | Here is an example
20 | 19 | 16
11 | 22 | 30
11 | 27 | 22
3 | 6 | 4
6 | 4 | 7
15 | 20 | 21
19 | 18 | 17
15 | 26 | 8
8 | 6 | 14
18 | 16 | 29
20 | 5 | 15
4 | 6 | 9
5 | 26 | 21
0 | 10 | 4
0 | 23 | 27
10 | 30 | 6
Spreadsheet: 860085d1708320302-try-to-find-optimal-solution-but-did-not-work-paper1
Sheet: Sheet2

L | 4
W0 | 0.064
w1 | 2
R | 250
Kf | 750
cf | 0.1
mf | 0.2
Kp | 500
hp | 0.05
Kr | 100
hr | 0.1
alpha | 6.87
beta | 120
lamda | 0.12
a | 80
b | 0.2
S | 300
pv | 1
pf | 2
pp | 3
pr | 5
x | 0.9
T |  | n | 1
Cost 1
Cost 2
Cost 3
Cost 4
Cost 5
Cost 6
Cost 7
Cost 8
Cost 9
Total cost
Spreadsheet: 189089d1351086640-sum-by-unique-id-and-then-count-sums-greater-than-a-certain-number-studentdataexample
Sheet: Sheet1

Student ID | Class Year | Class | Credits Earned
2001 | 9 | English 1 | 1
2001 | 9 | Math | 0.5 |  |  | Number of Tenth Graders with >1 English Credits (both English 2 and English Literature credits count as "english")
2001 | 9 | Environmental Science | 0 |  |  | ????????
2001 | 9 | Gym | 1
2001 | 9 | French | 1
2001 | 9 | History | 1
2003 | 10 | English Literature | 1
2003 | 10 | Math | 0
2003 | 10 | Science | 1
2003 | 10 | Gym | 1
2003 | 10 | World History | 0.5
2003 | 10 | Spanish | 0
2003 | 10 | English 2 | 1
2495 | 10 | Math 2 | 1
2495 | 10 | American History | 0
2495 | 10 | English 2 | 1
2495 | 10 | Earth Science | 1
2495 | 10 | Gym | 1
2495 | 10 | English Literature | 0
Spreadsheet: 269685d1381248761-lookup-two-criteria-and-return-a-third-criteria-as-result-aaaargh-test_tracker_example_v3
Sheet: Manual Example

TIMETABLE
DATE | DAY | APS | WA | NSW | VIC | QLD | SA | ACT
2013-09-16 00:00:00 | Mon
2013-09-17 00:00:00 | [NAME] |  |  |  |  |  | Client 8
2013-09-18 00:00:00 | Wed
2013-09-19 00:00:00 | Thurs
2013-09-20 00:00:00 | Fri
2013-09-21 00:00:00 | Sat
2013-09-22 00:00:00 | Sun
2013-09-23 00:00:00 | Mon
2013-09-24 00:00:00 | [NAME] |  |  |  |  |  | Client 6
2013-09-25 00:00:00 | Wed
2013-09-26 00:00:00 | Thurs
2013-09-27 00:00:00 | Fri
2013-09-28 00:00:00 | Sat
2013-09-29 00:00:00 | Sun
2013-09-30 00:00:00 | Mon | Client 1 |  |  |  | Client 2
2013-10-01 00:00:00 | [NAME] |  |  |  | Client 5 |  |  | Client 4
2013-10-02 00:00:00 | Wed |  |  |  |  |  |  | Client 3
2013-10-03 00:00:00 | Thurs
2013-10-04 00:00:00 | Fri
2013-10-05 00:00:00 | Sat
2013-10-06 00:00:00 | Sun
Data table
Client | State for delivery | Order No. | Date for delivery | Date copy [NAME] from client | Date copy sent to Artist | Date proof 1 delivered | Proof 1 changes to artist (if applicable) | Date proof 2 delivered (if applicable) | Proof 2 changes to artist (if applicable) | Date proof 3 delivered (if applicable) | Proof 3 changes to artist (if applicable) | Date approved and final
When date/number entered in cell = |  | (Red) | (Orange) | (Yellow) | (Purple) | (Blue) | (Purple) | (Blue) | (Purple) | (Blue) | (Purple) | (Green)
Client 1 | APS | 12176 | 2013-09-30 00:00:00 | 2013-09-24 00:00:00 | 2013-09-25 00:00:00 | 2013-09-25 00:00:00 | 2013-09-27 00:00:00 | 2013-09-27 00:00:00 | 2013-09-27 00:00:00 | 2013-09-28 00:00:00 | 2013-09-28 00:00:00 | 2013-09-28 00:00:00
Client 2 | QLD | 11620 | 2013-09-30 00:00:00 | 2013-09-22 00:00:00 | 2013-09-26 00:00:00 | 2013-09-26 00:00:00
Client 3 | ACT | 12174 | 2013-10-02 00:00:00
Client 4 | ACT | 12100 | 2013-10-01 00:00:00 | 2013-09-25 00:00:00 | 2013-09-28 00:00:00
Client 5 | Vic | 12166 | 2013-10-01 00:00:00 | 2013-09-29 00:00:00
Client 6 | SA | 12168 | 2013-09-24 00:00:00 | 2013-09-20 00:00:00 | 2013-09-22 00:00:00 | 2013-09-22 00:00:00 | 2013-09-23 00:00:00 | 2013-09-23 00:00:00 |  |  |  | 2013-09-23 00:00:00
Client 7 | Vic |  |  |  |  |  |  |  |  |  |  |  |  | Will not be on timetable - no delivery date
Client 8 | SA | 12106 | 2013-09-17 00:00:00 | 2013-09-10 00:00:00
RULES (Conditional Formatting for both data table and timetable)
If col A and B NOT BLANK, but col C IS BLANK |  | Make RED
When col D gets a date |  | Make ORANGE
When col E gets a date |  | Make YELLOW
When col F gets a date |  | Make PURPLE
When col G gets a date |  | Make BLUE
IF col H gets a date | if applicable | Make PURPLE
IF col I gets a date | if applicable | Make BLUE
IF col J gets a date | if applicable | Make PURPLE
IF col K gets a date | if applicable | Make BLUE
IF col L gets a date | if applicable | Make PURPLE
When col M gets a date |  | Make GREEN
Spreadsheet: 39314d1237478545-counting-wins-from-columns-mlbbetsystem-version-5-
Sheet: Series

[NAME] |  | Wins |  |  |  |  |  |  | Starting Bankroll |  | Current Bankroll
[NAME] |  |  |  |  |  |  |  |  | 3000
Date | Bet Unit | Series # | Game # | Bet Team | H/A | VS Team | Line | Risk | To Win | Bankroll | Profit | W/L | Score
2009-04-01 00:00:00 | 1 | 1 | 1 | SEA | AT | CHC | -175 |  |  |  |  | Win
2009-04-01 00:00:00 | 1 | 2 | 1 | BAL | VS | CIN | -154 |  |  |  |  | Loss
2009-04-01 00:00:00 | 1 | 3 | 1 | CHC | AT | FLA | -175 |  |  |  |  | Loss
2009-04-02 00:00:00 | 1 | 2 | 2 | BAL | VS | CIN | -165 |  |  |  |  | Loss
2009-04-02 00:00:00 | 1 | 3 | 2 | CHC | AT | FLA | -144 |  |  |  |  | Loss
2009-04-03 00:00:00 | 1 | 2 | 3 | BAL | VS | CIN | -120 |  |  |  |  | Win
2009-04-03 00:00:00 | 1 | 3 | 3 | CHC | AT | FLA | -150 |  |  |  |  | Win
2009-04-04 00:00:00 | 1 | 4 | 1 | WAS | VS | CIN | 125 |  |  |  |  | Loss
2009-04-04 00:00:00 | 1 | 5 | 1 | ANA | AT | COL | -144 |  |  |  |  | Win
2009-04-05 00:00:00 | 1 | 6 | 1 | BOS | AT | CLE | -180 |  |  |  |  | Loss
2009-04-06 00:00:00 | 1 | 4 | 2 | WAS | VS | CIN | 115 |  |  |  |  | Loss
2009-04-06 00:00:00 | 1 | 6 | 2 | BOS | AT | CLE | -165 |  |  |  |  | Win
2009-04-06 00:00:00 | 1 | 4 | 3 | WAS | VS | CIN | 110 |  |  |  |  | Loss
Spreadsheet: 44936d1243684117-excel-2007-moving-data-into-different-cells-dependant-on-date-excel-forum-help-spreadsheet
Sheet: Oct

 | October 2009
 | INCOME | Invoice Reference | Actual |  | EXPENSES | Reference | Cost
 | Professional Fees |  | 0 |  | Petrol |  | 0
 | Travel Expenses Paid |  | 0 |  | Travel Expenses |  | 0
 | Other |  | 0 |  | Accomodation |  | 0
 | INCOME |  |  |  | Subsistence - Meals |  | 0
 | INCOME | Invoice Reference | Actual |  | NI Contribution |  | 0
 | Professional Fees |  | 0 |  | Phone |  | 0
 | Travel Expenses Paid |  | 0 |  | Internet |  | 0
 | Other |  | 0 |  | Clothing |  | 0
 | INCOME |  |  |  | Books / Periodicals |  | 0
 | INCOME | Invoice Reference | Actual |  | Union Subscription |  | 0
 | Professional Fees |  | 0 |  | Accountant Fees |  | 0
 | Travel Expenses Paid |  | 0 |  | IT Hardware |  | 0
 | Other |  | 0 |  | IT Software |  | 0
 | INCOME |  |  |  | Printing Consumables |  | 0
 | INCOME | Invoice Reference | Actual |  | Stationery |  | 0
 | Professional Fees |  | 0 |  | Postage |  | 0
 | Travel Expenses Paid |  | 0 |  | Marketing |  | 0
 | Other |  | 0 |  | Office Furniture |  | 0
 | INCOME |  |  |  | Other |  | 0
 | INCOME | Invoice Reference | Actual |  | TOTAL EXPENSES
 | Professional Fees |  | 0
 | Travel Expenses Paid |  | 0 |  |  | Key :
 | Other |  | 0 |  |  | Invoice Reference | [NAME]
 | INCOME |  |  |  |  | Invoice Reference | Payment Received
 | INCOME | Invoice Reference | Actual
 | Professional Fees |  | 0
 | Travel Expenses Paid |  | 0 |  |  | Total Income
 | Other |  | 0 |  |  | Total Expenses
 | INCOME |  |  |  |  | NET
Spreadsheet: 126443d1319698291-excel-2007-transpose-records-based-on-date-transpose
Sheet: Sheet1

date | location |  |  | Solution 1
2011-01-23 00:00:00 | 0 |  | location
2010-09-11 00:00:00 | 0 |  | 0
2010-01-09 00:00:00 | 0 |  | 1
2009-08-31 00:00:00 | 0 |  | 2
2011-10-17 00:00:00 | 1 |  | 3
2011-04-21 00:00:00 | 1 |  | 4
2010-11-10 00:00:00 | 1 |  | 5
2010-08-27 00:00:00 | 1 |  | 6
2010-04-30 00:00:00 | 1 |  | 7
2010-02-04 00:00:00 | 1 |  | 8
2009-11-03 00:00:00 | 1 |  | 9
2009-09-28 00:00:00 | 1 |  | 10
2009-07-06 00:00:00 | 1
2011-08-24 00:00:00 | 2
2011-01-17 00:00:00 | 2 |  |  | Note: array formula is used and should be confirmed though Ctrl+Shift+Enter instead of Just Enter
2010-09-20 00:00:00 | 2
2010-06-28 00:00:00 | 2 |  |  | Solution 2
2010-03-08 00:00:00 | 2 |  | 0
2009-11-09 00:00:00 | 2 |  | 1
2009-08-05 00:00:00 | 2 |  | 2
2011-08-18 00:00:00 | 3 |  | 3
2011-01-27 00:00:00 | 3 |  | 4
2010-08-19 00:00:00 | 3 |  | 5
2010-05-24 00:00:00 | 3 |  | 6
2010-02-15 00:00:00 | 3 |  | 7
2009-11-12 00:00:00 | 3 |  | 8
2009-09-23 00:00:00 | 3 |  | 9
2009-07-10 00:00:00 | 3 |  | 10
2011-10-10 00:00:00 | 4
2011-04-28 00:00:00 | 4
2010-04-13 00:00:00 | 4
2010-01-15 00:00:00 | 4
2009-11-19 00:00:00 | 4
2009-09-16 00:00:00 | 4
2009-06-01 00:00:00 | 4
2011-08-19 00:00:00 | 5
2011-04-18 00:00:00 | 5
2011-01-19 00:00:00 | 5
2010-05-10 00:00:00 | 5
2010-01-14 00:00:00 | 5
2009-11-02 00:00:00 | 5
2009-08-20 00:00:00 | 5
2011-08-22 00:00:00 | 6
2011-01-31 00:00:00 | 6
2010-05-26 00:00:00 | 6
2010-02-25 00:00:00 | 6
2009-11-05 00:00:00 | 6
2009-08-21 00:00:00 | 6
2011-09-21 00:00:00 | 7
2011-06-28 00:00:00 | 7
2011-02-03 00:00:00 | 7
2010-03-30 00:00:00 | 7
2009-09-11 00:00:00 | 7
2009-06-29 00:00:00 | 7
2011-07-07 00:00:00 | 8
2011-02-02 00:00:00 | 8
2010-05-31 00:00:00 | 8
2010-02-03 00:00:00 | 8
2009-10-07 00:00:00 | 8
2009-07-01 00:00:00 | 8
2011-09-05 00:00:00 | 9
2011-03-21 00:00:00 | 9
2010-10-06 00:00:00 | 9
2010-04-14 00:00:00 | 9
2010-01-19 00:00:00 | 9
2009-08-18 00:00:00 | 9
2011-07-29 00:00:00 | 10
2011-03-30 00:00:00 | 10
2010-11-30 00:00:00 | 10
2010-06-23 00:00:00 | 10
2010-03-09 00:00:00 | 10
2009-11-16 00:00:00 | 10
2009-07-20 00:00:00 | 10
Spreadsheet: 725393d1616665820-excel-newbie-countifs-dont-count-and-always-shows-0-instead-help
Sheet: Sheet2

No. | Branch Name | Unanswered | Answered | Complain | Didn't make through
 | A
 | B
 | C
 | D
Spreadsheet: 83563d1283526027-combining-scattered-cell-info-thread-spreadsheet
Sheet: Data

 | Existing data |  |  |  |  |  |  | Proposed Results
 | 1 | a | b | c | d |  |  | 1 | a | b | c | d
 |  |  |  |  |  |  |  | 7 | a | b | c | d
 |  |  |  |  |  |  |  | 3 | a |  | c | d
 |  |  |  |  |  |  |  | 4 |  |  |  | d
 |  |  |  |  |  |  |  | 5 | a |  |  | d
 |  |  |  |  |  |  |  | 6 | a | b
 |  |  |  |  |  |  |  | 2 | a |  | c
 |  |  |  |  |  |  |  | 2 |  |  | c | d
 | 7 | a | b | c | d |  |  | 9 | a
 |  |  |  |  |  |  |  | 10 |  | b
 |  |  |  |  |  |  |  |  | 8 is skipped due to no data
 | 3 | a |  | c | d
 | 4 |  |  |  | d
 | 5 | a |  |  | d
 | 8
 | 6 | a | b
 | 2 | a |  | c
 | 2 |  |  | c | d
 | 9 | a
 | 10 |  | b
Spreadsheet: 102572d1300489053-excel-2007-help-replacing-customer-names-from-template-or-using-macro-customers-1-
Sheet: Sheet1

price_grou | stock_refe
[NAME] | 0237
BAD01 | 2002 | [NAME]
BAD01 | 2305 | [NAME]
BAD01 | 0219 | [NAME]
BAD01 | 0266 | [NAME]
BAD01 | 2664 | [NAME]
BEA07 | 1620 | [NAME]
BER01 | 0216 | [NAME]
BER01 | 0237 | [NAME]
BER01 | 0247 | [NAME]
BER01 | 0219 | [NAME]
BER01 | 2330 | [NAME]
BER01 | 2308 | [NAME]
BER01 | 2331 | [NAME]
BER01 | 1626 | [NAME]
BER01 | 2031 | [NAME]
BER01 | 2037 | [NAME]
BER01 | 2902 | [NAME]
BER01 | 2664 | [NAME]
BER01 | 0227 | [NAME]
BER01 | 2305 | [NAME]
BER01 | 1601 | [NAME]
BER01 | 2615 | [NAME]
BER01 | 2661 | [NAME]
BER01 | 0245 | [NAME]
BET02 | 2664 | [NAME]
BLU011 | 0267 | [NAME]
BLU011 | 0219 | [NAME]
BLU03 | 0213 | [NAME]
BRIT05 | 0213 | Adam
BRIT05 | 0217 | Adam
BRIT05 | 0233 | Adam
BRIT05 | 1620 | Adam
BRIT05 | 0257 | Adam
BRIT05 | 1603 | Adam
Spreadsheet: 118543d1313753977-help-with-moving-data-on-criteria-tlgltest
Sheet: WRITTEN

Last Name | First Name | Occp | Dept | Team | Shift | BPD | [NAME] | Interview | Math | Written | Comments | Test Taken On:
Aguilar | [NAME] | T103 | 1701 | 1801 | 1 | 0.8214285714285714 | 0.8461538461538461 | 75 | 80 | 50 | 2,4,5,7,10 | 2010-11-08 00:00:00
Arriaga | [NAME] | T103 | 1102 | 1302 | 2 |  |  |  |  |  | benefits
Babler | [NAME] | T203 | 5001 | 1201 | 1 |  |  |  |  |  | committeeman
 |  |  |  |  |  |  |  |  |  |  |  |  | Retirement effective 2/1/11
 |  |  |  |  |  |  |  |  |  |  |  |  | failed math twice
 |  |  |  |  |  |  |  |  |  |  |  |  | 6/16/11 30%
 |  |  |  |  |  |  |  |  |  |  |  |  | failed math twice
 |  |  |  |  |  |  |  |  |  |  |  |  | failed math twice
 |  |  |  |  |  |  |  |  |  |  |  |  | Retest taken on 2/7/11