tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 648674d1573147114-excel-solver-fantasy-basketball-draft-guide-fbball-19-20-draft-prep-optimization-test-hydr-
Sheet: Roto 19 Prjt

[NAME] | 1 | The Clear First Pick tier
[NAME] | 2 | The I Feel Great About This tier
[NAME] | 3
[NAME] | 4
[NAME] | 5 | END OF TIER 2
Nikola Jokic | 6 | The I'm Getting a First-Round Talent tier
[NAME] | 7
[NAME] | 8
Damian Lillard | 9
Bradley Beal | 10
[NAME] | 11
[NAME] | 12
[NAME] | 13
[NAME] | 14 | END OF TIER 3
[NAME] | 15 | The Comfortable, Top-End Building Blocks tier
[NAME] | 16
[NAME] | 17
[NAME] | 18
[NAME] | 19
[NAME] | 20 | END OF TIER 4
[NAME] | 21 | The I'd Rather Have Them a Round Later But I'm Running Out of Names tier
Pascal Siakam | 22
[NAME] | 23 | END OF TIER 5
Trae Young | 24 | The I'd Be Happier With Them in the Fourth but They Won't Be There tier"
[NAME] | 25
Kristaps Porzingis | 26
[NAME] | 27
Mitchell Robinson | 28
[NAME] | 29
Jrue Holiday | 30
[NAME] | 31
[NAME] | 32
[NAME] | 33
[NAME] | 34
[NAME] | 35
[NAME] | 36
Draymond Green | 37
LaMarcus Aldridge | 38 | END OF TIER 6
[NAME] | 39 | The Now This is Starting to Feel Like Great Value tier
[NAME] | 40
[NAME] | 41
[NAME] | 42
[NAME] | 43
[NAME] | 44
[NAME] | 45
[NAME] | 46
Blake Griffin | 47
[NAME] | 48
[NAME] | 49
De'Aaron Fox | 50
C.J. McCollum | 51
[NAME] | 52
[NAME] | 53 | END OF TIER 7
[NAME] | 54 | The Vastly Underappreciated tier
[NAME] | 55
[NAME] | 56
[NAME] | 57
Derrick Favors | 58
[NAME] | 59
[NAME] | 60
[NAME] | 61 | END OF TIER 8
[NAME] | 62 | The "I'm now willing to take some big swings on astronomical upside" tier
[NAME] | 63
[NAME] | 64
[NAME] | 65
[NAME] | 66
[NAME] | 67 | END OF TIER 9
[NAME] | 68 | The Betting on Talent to Overcome Situation tier
[NAME] | 69
[NAME] | 70
[NAME] | 71
[NAME] | 72
[NAME] | 73
[NAME] | 74
[NAME] | 75
[NAME] | 76
[NAME] | 77
[NAME] | 78
Jerami Grant | 79
[NAME] | 80 | END OF TIER 10
[NAME] | 81 | The Counting on Situation to Elevate Talent tier
[NAME] | 82
[NAME] | 83
[NAME] | 84 | Note: McGee moves into the mid-60s in the wake of [NAME]' injury.
[NAME] | 85
Domantas Sabonis | 86
[NAME] | 87
[NAME] | 88
[NAME] | 89 | END OF TIER 10
[NAME] | 90 | The Go Get Your Guys tier
Enes Kanter | 91
[NAME] | 92
[NAME] | 93
[NAME] | 94
[NAME] | 95
[NAME] | 96
[NAME] | 97
[NAME] | 98 | END OF TIER 11
[NAME] | 99
[NAME] | 100
[NAME] | 101
[NAME] | 102
[NAME] | 103
[NAME] | 104
[NAME] | 105
[NAME] | 106
[NAME] | 107
[NAME] | 108
[NAME] | 109
[NAME] | 110
[NAME] | 111
[NAME] | 112
[NAME] | 113
[NAME] | 114
[NAME] | 115
[NAME] | 116
[NAME] | 117
[NAME] | 118
[NAME] | 119
[NAME] | 120
[NAME] | 121
OG Anunoby | 122
[NAME] | 123
[NAME] | 124
[NAME] | 125
[NAME] | 126
[NAME] | 127
[NAME] | 128
Thaddeus Young | 129
[NAME] | 130
[NAME] | 131
Landry Shamet | 132
[NAME] | 133
[NAME] | 134
[NAME] | 135
[NAME] | 136
[NAME] | 137
[NAME] | 138
[NAME] | 139
[NAME] | 140
[NAME] | 141
[NAME] | 142
[NAME] | 143
[NAME] | 144
RJ [NAME] | 145
[NAME] | 146
[NAME] | 147
[NAME] | 148
Spreadsheet: 694574d1599691462-conditional-formatting-and-ignore-zero-new-microsoft-excel-worksheet
Sheet: Ark1

 |  |  | i want this conditional formatting but it should ignore zeros
 | A | 0.1258947335359615
 | B | 0
 | C | 0.009282448574421094
 | D | 0.3397861434794069
 | E | 0.01175028420942733
 | F | 0.213147420499457
 | G | 0
 | H | 0
 | I | 0
 | J | 0.01197193262140908
 | K | 0.1657776628225797
 | L | 0.04980895911445908
 | M | 0.07258041514287827
 | Total | 1
Spreadsheet: 32062d1228178371-compilation-work-sheet-balance
Sheet: ABC Supply

Date | Qty | Description | Cost | Amount | Credits | Balance
2008-01-05 00:00:00 | 2 | Flashlight Batteries | 1 | 2 |  | 2
2008-01-09 00:00:00 | 6 | Eggs (Dozen) | 1.69 | 10.14 |  | 12.14
2008-01-12 00:00:00 | 1 | Staples (cs) | 6 | 6 |  | 18.14
2008-01-14 00:00:00 | 2 |  | 3 | 6 | 12 | 12.14
Spreadsheet: 542362d1507821861-request-form-help-equipment-request-form-copy
Sheet: Cat A

Asset Tag | Asset Description | Asset Type | Serial No | Model | Category
100728 | 6-figure Micro-balance Acculab | 6-fig balance Acculab | 25605807 |  | Cat A
100734 | 6-fig micro balance | 6-fig balance XP6 | 123456 |  | Cat A
100948 | Andersen Cascade Impactor | Andersen Cascade Impactor | 324 |  | Cat A
100949 | Andersen Cascade Impactor | Andersen Cascade Impactor | 1250 |  | Cat A
100950 | Andersen Cascade Impactor | Andersen Cascade Impactor | 297 |  | Cat A
100951 | Andersen Cascade Impactor | Andersen Cascade Impactor | 1044 |  | Cat A
100952 | Andersen Cascade Impactor | Andersen Cascade Impactor | 264 |  | Cat A
100953 | Andersen Cascade Impactor | Andersen Cascade Impactor | 1043 |  | Cat A
Spreadsheet: 107152d1304364775-excel-2007-paste-current-date-to-a-row-in-a-sheet-service-sample
Sheet: Invoice

Service Invoice |  |  |  | INVOICE
 |  |  |  |  | DATE: | 2011-05-02 00:00:00
 |  |  |  |  | INVOICE #
 |  |  |  |  | Customer ID
Owner: |  |  | Is this a Rental ? |  | #N/A
#N/A | #N/A
#N/A |  |  | Service contract ? |  | #N/A
#N/A
#N/A
#N/A
Serial Number | Instrument | Manufacturer |  |  | TERMS
 | #N/A | #N/A
ITEM # | [NAME] |  |  | QTY | UNIT PRICE | TOTAL
 | #N/A |  |  |  | #N/A | #N/A
 | #N/A |  |  |  | #N/A | #N/A
 | #N/A |  |  |  | #N/A | #N/A
 | #N/A |  |  |  | #N/A | #N/A
 | #N/A |  |  |  | #N/A | #N/A
 | #N/A |  |  |  | #N/A | #N/A
 | #N/A |  |  |  | #N/A | #N/A
 | #N/A |  |  |  | #N/A | #N/A
 | #N/A |  |  |  | #N/A | #N/A
 | #N/A |  |  |  | #N/A | #N/A
 | #N/A |  |  |  | #N/A | #N/A
 | #N/A |  |  |  | #N/A | #N/A
 | #N/A |  |  |  | #N/A | #N/A
 | #N/A |  |  |  | #N/A | #N/A
 | #N/A |  |  |  | #N/A | #N/A
 |  |  |  | 2 | SUBTOTAL | #N/A
Other Comments or Special Instructions |  |  |  |  | TAX RATE | 0.06875
 |  |  |  |  | TAX | #N/A
 |  |  |  |  | S & H | 0
 |  |  |  |  | OTHER | 0
 |  |  |  |  | TOTAL | #N/A
 |  |  |  |  | Make all checks payable to
If you have any questions about this invoice, please contact
[Name, Phone #, E-mail]
Thank You For Your Business!
Spreadsheet: 130184d1322115561-how-to-use-if-formula-for-change-price-copy-of-december
Sheet: 21

 |  |  |  | 2011-12-21 00:00:00
Newspaper | Price | Quantity | Total
Value | 0.88 |  | 0
Value1 | 0.98 |  | 0
Value2 | 1.22 |  | 0
Value3 | 1.22 |  | 0
Value4 | 0.83 |  | 0
Value5 | 1.01 |  | 0
Value6 | 1.03 |  | 0
Value7 | 1.01 |  | 0
Value8 | 0.8 |  | 0
Value9 | 1.04 |  | 0
Value10 | 1.04 |  | 0
Value11 | 1.04 |  | 0
Total |  |  | 0
 | Grand Total |  | 0
Spreadsheet: 28303d1222363753-figuring-out-skins-for-golf-skins
Sheet: Sheet1

 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | Skins
A | 4 | 5 | 3 | 5 | 5 | 5 | 5 | 5 | 5 | 2
B | 5 | 4 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 1
C | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 0
D | 5 | 5 | 5 | 4 | 5 | 5 | 5 | 4 | 5 | 2
Spreadsheet: 390304-how-to-copy-number-automatically-book-1
Sheet: Journal Enteries

No | Account No | Description | Account | Dr | Cr
1 | 1001 |  | Petty cash | 100000
 | 1002 |  | checks under collection |  | 100000
2 | 2001 |  | Salary Basic | 60000
 | 1002 |  | checks under collection |  | 60000
3 | 10010 |  | Land | 40000
 | 1003 |  | Cash |  | 40000
Spreadsheet: 163240d1340235546-excel-2007-specify-chart-data-range-using-an-if-formula-ef113_dynamic-chart-range
Sheet: Dynamic Data

 | Calculations
 | Selected Chart Option | Area
 | Data for the chart
 | Year | London | Midlands | North | South | London | East Midlands | East of England | West Midlands | North East | North West | Yorkshire | South Central | South East Coast | South West
 | 2010/2011 | 46704307.29212753 | 50142351.29886874 | 49619394.79394341 | 55403361.00466315 | 46704307.29212753 | 12845499.70187608 | 14990824.85 | 22306026.74699266 | 7688393.465270543 | 26133402.7890979 | 15797598.53957497 | 21001351.99 | 15324286.45 | 19077722.56466315
 | 2011/2012 | 48800844.15600471 | 57315497.70278163 | 50751672.59733258 | 62151668.135717 | 48800844.15600471 | 16532260.47882961 | 18576811.47395201 | 22206425.75 | 8423577.889591439 | 25827768.25774114 | 16500326.45 | 20761504.23571699 | 18373706.9 | 23016457
 |  |  |  |  |  |  |  | FILTER, <> #N/A
Spreadsheet: 773235d1647718619-xlookup-hide-data-in-cells-not-yet-looking-up-testing
Sheet: New starters

[NAME] | Staff Name | Job Title | Department | Start Date | Location
[NAME] | Staff Name 1 | Rocket Scientist | Research & Development | 2100-01-04 00:00:00 | London, UK
[NAME] | Staff Name 2 | Astronaut | Launch Team | 2100-03-08 00:00:00 | London, UK
[NAME] | Staff Name 3 | Data Analyst | Number Crunching | 2100-05-10 00:00:00 | London, UK
[NAME] | Staff Name 4 | Mission Commander | Mission Control | 2100-01-04 00:00:00 | London, UK
[NAME] | Staff Name 5 | Builders | Engineering | 2100-03-08 00:00:00 | London, UK
[NAME] | Staff Name 6 | Money Maker | Marketing | 2100-05-10 00:00:00 | London, UK
[NAME] | Staff Name 7 | Psychologist | Health & Wellbeing | 2100-03-08 00:00:00 | Sydney, Australia
[NAME] | Staff Name 8 | Data Analyst | Number Crunching | 2100-03-08 00:00:00 | London, UK
[NAME] | Staff Name 9 | Accountant | Budgeting | 2100-03-08 00:00:00 | London, UK
[NAME] | Staff Name 10 | Builders | Engineering | 2100-01-04 00:00:00 | London, UK
[NAME] | Staff Name 11 | Builders | Engineering | 2100-01-04 00:00:00 | London, UK
[NAME] | Staff Name 12 | Rocket Scientist | Research & Development | 2100-05-10 00:00:00 | London, UK
[NAME] | Staff Name 13 | Data Analyst | Number Crunching | 2100-03-08 00:00:00 | Tokyo, Japan
[NAME] | Staff Name 14 | Astronaut | Launch Team | 2100-05-10 00:00:00 | London, UK
[NAME] | Staff Name 15 | Astronaut | Launch Team | 2100-01-04 00:00:00 | London, UK
[NAME] | Staff Name 16 | Physiotherapist | Health & Wellbeing | 2100-05-10 00:00:00 | London, UK
[NAME] | Staff Name 17 | Rocket Scientist | Research & Development | 2100-01-04 00:00:00 | London, UK
[NAME] | Staff Name 18 | Money Maker | Marketing | 2100-05-10 00:00:00 | London, UK
[NAME] | Staff Name 19 | Builders | Engineering | 2100-01-04 00:00:00 | London, UK
[NAME] | Staff Name 20 | Rocket Scientist | Research & Development | 2100-05-10 00:00:00 | London, UK
[NAME] | Staff Name 21 | Rocket Scientist | Research & Development | 2100-05-10 00:00:00 | London, UK
[NAME] | Staff Name 22 | Builders | Engineering | 2100-01-04 00:00:00 | London, UK
[NAME] | Staff Name 23 | Builders | Engineering | 2100-01-04 00:00:00 | London, UK
[NAME] | Staff Name 24 | Money Maker | Marketing | 2100-01-04 00:00:00 | London, UK
[NAME] | Staff Name 25 | Astronaut | Launch Team | 2100-01-04 00:00:00 | London, UK
[NAME] | Staff Name 26 | Astronaut | Launch Team | 2100-05-10 00:00:00 | London, UK
[NAME] | Staff Name 27 | Astronaut | Launch Team | 2100-05-10 00:00:00 | London, UK
[NAME] | Staff Name 28 | Money Maker | Marketing | 2100-05-10 00:00:00 | London, UK
[NAME] | Staff Name 29 | Data Analyst | Number Crunching | 2100-03-08 00:00:00 | London, UK
[NAME] | Staff Name 30 | Public Speaker | Marketing | 2100-03-08 00:00:00 | London, UK
Spreadsheet: kimberly_watson__20556__imbalsumm0109
Sheet: NGPL

 | 52862 |  | 6828
 | Measured | Scheduled | Measured | Scheduled | Imbalance
1 | 54408 | 54435 | -44839 | -19695
2 | 54768 | 54751 | -48946 | -19695
3 | 52724 | 52734 | -7981 | -19695
4 | 53199 | 54711 | -10328 | -19695
5
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-08-31 00:00:00 |  |  |  |  | 138928
2001-09-04 00:00:00
CBS Dollars
 |  |  | 353581
Spreadsheet: 38761d1236893356-data-validation-list-with-a-chart-hr
Sheet: sec

401 |  | Student | FCAT READ WP | <<< this is the helper table that pulls the data from your Student Data tab
402
403 |  |  |  |  | The formulas in the helper table are array formulas.
404 |  |  |  |  | If you need to change them, you have to highlight C2:C33, then edit the formula
405 |  |  |  |  | in C2 and hit Ctrl-Shift-Enter to confirm. Same for column D.
501
502 |  |  |  |  | If you need another column from the student data, just change the last digit in the formula
503 |  |  |  |  | It currently pulls the 4th column in the range of B1:H1000
504 |  |  |  |  | This is what the   ….. "),[NAME])   means
505 |  |  |  |  | If you need the next column, you can change the 4 to a 5. Remember to highlight the whole array first
DC3 |  |  |  |  | and hit CTRL-SHIFT-Enter to confirm.
DC4
G03
 |  |  |  |  |  | <<<<<<< | Here we calculate how many rows are in the table, because we don't want to
 |  |  |  |  |  |  | graph empty rows.
 |  |  |  |  |  |  | This value is used to define named ranges that dynamically adjusts to this
 |  |  |  |  |  |  | number of rows. The named ranges are
 |  |  |  |  | chart_data | =OFFSET(sec!$C$2,0,0,chart_rows,2)
 |  |  |  |  | chart_labels | =OFFSET(sec!$C$2,0,0,chart_rows,1)
 |  |  |  |  | chart_rows | =sec!$F$7
 |  |  |  |  | chart_series1 | =OFFSET(sec!$C$2,0,1,chart_rows,1)
 |  |  |  |  | The names "chart_labels" and "chart_rows" are then used to define the data of the graph.
 |  |  |  |  | The syntax for using dynamic range names in a chart is
 |  |  |  |  | =filename.xlsx!rangename
 |  |  |  |  | So in the data source definiton of the chart you will see
 |  |  |  |  | ='HR.xlsx'!chart_series1
Spreadsheet: cbee991a-67c6-4f4c-a1e0-8ced24cb8858
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2014-03-04 14:11:25.880000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.75 | 102.875 | 102.75 | 102.625 | 102.25 |  | and are added to price quote
4.625 | 102.506 | 102.381 | 102.256 | 101.881
4.5 | 101.594 | 101.469 | 101.344 | 100.969 |  | Note: | Refer To Price [NAME]
4.375 | 100.629 | 100.504 | 100.379 | 100.004 |  |  | For all Price Adjs
4.25 | 100.049 | 99.924 | 99.799 | 99.174
4.125 | 99.23 | 99.105 | 98.98 | 98.355
4 | 98.215 | 98.09 | 97.965 | 97.34
3.875 | 97.166 | 97.041 | 96.916 | 96.291
3.75 | 96.291 | 96.166 | 96.041 | 95.416
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4 | 102.875 | 102.75 | 102.625 | 102.25
3.875 | 102.368 | 102.243 | 102.118 | 101.743
3.75 | 102.309 | 102.184 | 102.059 | 101.684
3.625 | 101.914 | 101.789 | 101.664 | 101.289
3.5 | 101.377 | 101.252 | 101.127 | 100.502
3.375 | 100.597 | 100.472 | 100.347 | 99.722
3.25 | 99.843 | 99.718 | 99.593 | 98.968 |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2014-03-18 14:11:25.880000
30 DAY | 2014-04-02 14:11:25.880000
45 DAY | 2014-04-17 14:11:25.880000
60 DAY | 2014-05-02 14:11:25.880000
90 DAY | 2014-06-01 14:11:25.880000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 104141d1301784039-excel-2007-need-to-match-data-and-find-missing-my-own-wrksheet
Sheet: Input

 | Referral Id | Referral Since | Last Click | Total Clicks
 | R381066011 | 2011-02-03 00:00:00 | 2011-03-30 00:00:00 | 77
 | R706434262 | 2011-02-12 00:00:00 | 2011-03-31 00:00:00 | 63
 | R211798664 | 2011-02-17 00:00:00 | 2011-03-27 00:00:00 | 56
 | R625254881 | 2011-02-17 00:00:00 | 2011-04-01 00:00:00 | 69
 | R736722731 | 2011-02-17 00:00:00 | 2011-04-02 00:00:00 | 65
 | R116671021 | 2011-02-25 00:00:00 | 2011-03-30 00:00:00 | 49
 | R32274738 | 2011-02-25 00:00:00 | 2011-03-29 00:00:00 | 45
 | R190793213 | 2011-03-02 00:00:00 | 2011-03-28 00:00:00 | 51
 | R499919439 | 2011-03-03 00:00:00 | 2011-03-27 00:00:00 | 34
 | R365730679 | 2011-03-05 00:00:00 | 2011-03-29 00:00:00 | 58
 | R503786093 | 2011-03-07 00:00:00 | 2011-04-02 00:00:00 | 62
 | R702872742 | 2011-03-07 00:00:00 | 2011-04-02 00:00:00 | 55
 | R726330260 | 2011-03-07 00:00:00 | 2011-04-02 00:00:00 | 39
 | R997024027 | 2011-03-07 00:00:00 | 2011-03-30 00:00:00 | 36
 | R450108431 | 2011-03-09 00:00:00 | 2011-03-27 00:00:00 | 31
 | [NAME] | 2011-03-13 00:00:00 | 2011-03-23 00:00:00 | 28
 | R187348970 | 2011-03-13 00:00:00 | 2011-04-02 00:00:00 | 27
 | R240821818 | 2011-03-14 00:00:00 | 2011-04-02 00:00:00 | 30
 | R276515218 | 2011-03-14 00:00:00 | 2011-04-01 00:00:00 | 40
 | R689905083 | 2011-03-15 00:00:00 | 2011-04-02 00:00:00 | 27
 | R56899682 | 2011-03-16 00:00:00 | 2011-03-31 00:00:00 | 40
 | R109718062 | 2011-03-18 00:00:00 | 2011-04-02 00:00:00 | 40
 | R136612190 | 2011-03-18 00:00:00 | 2011-03-31 00:00:00 | 24
 | [NAME] | 2011-03-18 00:00:00 | 2011-04-01 00:00:00 | 23
 | R351331767 | 2011-03-18 00:00:00 | 2011-04-01 00:00:00 | 31
 | R484146237 | 2011-03-18 00:00:00 | 2011-04-02 00:00:00 | 28
 | R559281537 | 2011-03-18 00:00:00 | 2011-04-02 00:00:00 | 23
 | R603923031 | 2011-03-18 00:00:00 | 2011-03-26 00:00:00 | 20
 | R61877240 | 2011-03-18 00:00:00 | 2011-04-02 00:00:00 | 19
 | R694858662 | 2011-03-18 00:00:00 | 2011-03-31 00:00:00 | 24
 | R758914652 | 2011-03-18 00:00:00 | 2011-04-01 00:00:00 | 36
 | R852014999 | 2011-03-18 00:00:00 | 2011-03-31 00:00:00 | 28
 | R863474544 | 2011-03-18 00:00:00 | 2011-03-27 00:00:00 | 20
 | R917457990 | 2011-03-18 00:00:00 | 2011-03-31 00:00:00 | 32
 | R925220175 | 2011-03-18 00:00:00 | 2011-04-02 00:00:00 | 27
 | [NAME] | 2011-03-18 00:00:00 | 2011-04-02 00:00:00 | 32
 | R624970696 | 2011-03-19 00:00:00 | 2011-03-30 00:00:00 | 24
 | R834695544 | 2011-03-19 00:00:00 | 2011-04-02 00:00:00 | 32
 | R619921295 | 2011-03-22 00:00:00 | 2011-04-02 00:00:00 | 32
 | R78833418 | 2011-03-24 00:00:00 | 2011-04-01 00:00:00 | 8
 | R201342238 | 2011-03-27 00:00:00 | 2011-04-02 00:00:00 | 24
 | R285939950 | 2011-03-27 00:00:00 | 2011-04-01 00:00:00 | 12
 | R424000667 | 2011-03-27 00:00:00 | 2011-04-01 00:00:00 | 12
 | R560684694 | 2011-03-29 00:00:00 | 2011-03-29 00:00:00 | 4
 | R284337916 | 2011-03-30 00:00:00 | 2011-04-02 00:00:00 | 4
 | R876667333 | 2011-04-02 00:00:00 | 2001-12-31 00:00:00 | 0
Spreadsheet: 455073d1460090007-count-fields-that-exactly-match-a-list-sample-workbook
Sheet: Sheet1

Display Name | [NAME] | Full address | City | State | Post Code
Person 1 | [EMAIL] | 1 Highway | North Ryde | NSW | 2113
Person 2 | [EMAIL] | 2 Highway | Capalaba | QLD | 4157
Person 3 |  | 3 Highway | Dandenong | VIC | 3175
Person 4 | [EMAIL]
Person 5 | [EMAIL] | 4 Highway | Gateshead | NSW | 2290
Person 6 | [EMAIL] | 5 highway | Otahuhu | NI
Person 7 |  | 6 Highway | North Ryde | NSW | 2113
Person 8
Person 9 | [EMAIL] | 7 Highway | Castlemaine | [NAME] | 3450
Person 10 | [EMAIL] | 8 highway | [NAME] | NSW | 2190
Person 11
Person 12 | [EMAIL] | 9 Highway |  | QLD | 4157
Spreadsheet: 59748d1260311211-conditionally-populating-a-sheet-from-mulitple-sheets-draft-workbook
Sheet: 2009

 | Beginning Balance | Money In | Money Out | Net
1 | 148850 | 25000 | -25500 | 148350
2 | -37450 | 1400 | -25250 | -61300
3 | 29800 | 4000 | -1550 | 32250
4 | -2000 | 500 | -4000 | -5500
Month | Day | Year | Fiscal Year | Entity | Transaction | Payment Type | Payed To | Amount | Intrest Rate %
January | 15 | 2009 | 2008 | 1 |  | a | [NAME] | 25000 | 0.05
January | 15 | 2009 | 2009 | 2 |  | b | 1 | 25000
January | 20 | 2009 | 2009 | 3 |  | c | 2 | 1400
January | 27 | 2009 | 2009 | 4 |  | d | 3 | 4000
Febuary | 15 | 2009 | 2008 | 1 |  | e | 4 | 500
Febuary | 15 | 2009 | 2009 | 2 |  | f | 5 | 250
Febuary | 15 | 2009 | 2009 | 3 |  | g | 6 | 150 | 0.05
Spreadsheet: 837811d1690448328-use-conditional-formatting-to-highlight-variance-between-hours-worked-and-hours-booked-client-timesheets_rev-1
Sheet: Time Sheet

 |  | DAILY TIMESHEET
 |  |  |  | Company:
 |  |  |  | Work Group:
 |  |  |  | PO:
 |  |  |  | Job #: |  |  |  |  |  |  |  |  | Date: | 2023-07-27 00:00:00
 |  | Name | Employee ID # | Position | Start Time | Finish Time | Hours Worked | Work Order | Work Hours | Travel | Travel Hours | [NAME] | LV per Shift | Comments
 | 1 | [NAME] |  | Project Manager | 05:00:00 | 15:30:00 |  |  | 08:00:00 | Travel | 02:30:00
 | 2 | [NAME] |  | Supervisor | 05:00:00 | 15:30:00 |  |  | 08:00:00 | Travel | 02:15:00
 | 3 |  |  |  |  |  |  |  |  | Travel
 | 4 |  |  |  |  |  |  |  |  | Travel
 | 5 |  |  |  |  |  |  |  |  | Travel
 | 6 |  |  |  |  |  |  |  |  | Travel
 | 7 |  |  |  |  |  |  |  |  | Travel
 | 8 |  |  |  |  |  |  |  |  | Travel
 | 9 |  |  |  |  |  |  |  |  | Travel
 | 10 |  |  |  |  |  |  |  |  | Travel
 | 11 |  |  |  |  |  |  |  |  | Travel
 | 12 |  |  |  |  |  |  |  |  | Travel
 | 13 |  |  |  |  |  |  |  |  | Travel
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 20
 |  |  |  |  | Total
 |  | Supervisor / Site Representative
 |  |  |  | Name |  | Signature
Spreadsheet: 37298d1235261065-solved-deleting-specific-rows-boxfilter
Sheet: Sheet1

Box | Content | Key | Remove: | Blue pen |  | Box | Content
1 | Blue pen | 1 |  |  |  | 5 | Measuring rod |  | C = [NAME]'s Helper column
1 | Red pen | 1 |  |  |  | 5 | Paper |  | G/H = Auto Array of answers
1 | Correction pen | 1 |  |  |  | 5 | Eraser
1 | Scissors | 1 |  |  |  | 6 | Red pen
2 | Blue pen | 1 |  |  |  | 6 | Paper
2 | Scissors | 1
3 | Blue pen | 1
4 | Blue pen | 1
4 | Red pen | 1
4 | Correction pen | 1
4 | Scissors | 1
4 | Green pen | 1
4 | Eraser | 1
5 | Measuring rod | 0
5 | Paper | 0
5 | Eraser | 0
6 | Red pen | 0
6 | Paper | 0
Spreadsheet: 882670d1731076186-keep-track-on-unit-prices-in-excel-keep-track-on-unit-prices-in-excel
Sheet: Sheet1

 |  |  |  | Latest Price |  | Initial Price
 | No | Supplier | Product | Unit Price | Effective
 | 1 | ABC | ABC001 |  |  |  | 2020-01-01 00:00:00
 | 2 | ABC | ABC002 |  |  |  | 2020-01-01 00:00:00
 | 3 | XYZ | XYZ001 |  |  |  | 2020-01-01 00:00:00
 |  |  |  | [NAME]
Spreadsheet: 229769d1366566706-terribly-slow-excelsheet-dummyrapportage-20130322-clean
Sheet: Proces grote pilot

 |  |  |  |  |  |  |  |  |  |  | Maand |  | April | grote pilot
[NAME] na maand |  | Processtap | [NAME] | Wie | Doorlooptijd
 |  |  |  |  |  |  |  |  |  | start |  |  |  | eind/verzending |  |  | Planning 2013
van | t/m |  |  |  |  |  |  | dag |  | datum |  | dag |  | datum
1 |  | Opstellen rapportage | [NAME] | FIN | 1 | werkdagen |  |  |  | 2013-05-06 00:00:00 |  |  |  | 2013-05-07 00:00:00 |  |  | Maand | Start | Verzending | Toelichting
 |  | - financiën o.b.v. cognos |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | maandag | woensdag
 |  | [NAME] | [NAME] | Afdelingen | 11 | werkdagen
 |  | - speerpunten |  |  |  |  |  |  |  |  |  |  |  |  |  |  | April | 2013-05-06 00:00:00 | 2013-06-12 00:00:00 | grote pilot; verzending [NAME]. 22-5-2013nog rekening houden met hemelvaart 9+10 mei, pinksteren 20 mei
 |  | - financieel: bijstelling/toelichting |  |  | (8 werkdagen i.v.m. uitval [NAME] feestdagen)
 |  | - indicatoren
 |  | - informatie college aan raad
 |  | - bedrijfsvoering
 |  | - grondexploitatie (OWB)
 |  | Samenstelling rapportage | Programmarapportage | BMO (FIN) | 6 | werkdagen
 |  | - consolitatie
 |  | - toets / verduidelijking
 |  | - toevoegen overall begrotingsbeeld
 |  | - toevoegen overall toelichting
 |  | - beslispunten
 |  | - Verzenden naar DO en college | Afd rapp en progr rapp | BMO (FIN)
 |  | DO en college behandeling |  |  | 3 | werkdagen |  |  |  |  |  |  | maandag |  | behandeling in DO
 |  | - behandeling afd en progr rapp | Afd rapp en progr rapp | DO |  |  |  |  |  |  |  |  | dinsdag |  | behandeling in college
 |  | - behandeling progr rapp | Programmarapportage | College
 |  | Aanpassen en verzending [NAME] | Programmarapportage | BMO (FIN) | 1 | werkdagen |  |  |  |  |  |  |  |  |  |  |  |  |  | week speling mogelijk ([NAME])
 |  |  |  | totaal | 19 | werkdagen
 |  |  |  | totaal | 31 | kalenderdagen