tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 330219d1404630853-creating-bookmarks-hyperlinks-to-rows-and-columns-bookmark-sample
Sheet: masterdata

S.No | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15
Projects | project 1 | project 2 | project 3 | project 4 | project 5 | project 6 | project 7 | project 8 | project 9 | project 10 | project 11 | project 12 | project 13 | project 14 | project 15
 | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa
 | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa
 | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa
 | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa
 | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa
 | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa
 | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa
 | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa
 | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa
 | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa
 | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa
 | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa | aaa
Spreadsheet: 164941d1340965750-help-adding-up-data-from-a-table-example1
Sheet: Sheet1

Name | Type | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct |  |  | [NAME] | TI | Jan
[NAME] | TI | 221 | 219 | 299 | 180 | 151 | 117 | 289 | 162 | 248 | 300 |  |  | [NAME] | F2F | Feb
[NAME] | F2F | 281 | 188 | 298 | 251 | 279 | 149 | 148 | 243 | 110 | 249 |  |  | [NAME] | Translation | Mar
[NAME] | TI | 227 | 100 | 120 | 258 | 192 | 120 | 171 | 249 | 183 | 232 |  |  |  |  | Apr
[NAME] | TI | 120 | 265 | 222 | 267 | 222 | 172 | 121 | 215 | 290 | 218 |  |  |  |  | May
[NAME] | Translation | 273 | 293 | 289 | 273 | 210 | 254 | 272 | 278 | 253 | 241 |  |  |  |  | Jun
[NAME] | Translation | 276 | 118 | 300 | 157 | 123 | 261 | 272 | 142 | 217 | 260 |  |  |  |  | Jul
[NAME] | Translation | 276 | 170 | 246 | 157 | 295 | 243 | 126 | 150 | 235 | 130 |  |  |  |  | Aug
[NAME] | Translation | 182 | 278 | 157 | 289 | 213 | 174 | 215 | 201 | 277 | 206 |  |  |  |  | Sep
[NAME] | F2F | 196 | 220 | 183 | 164 | 117 | 222 | 236 | 186 | 290 | 119 |  |  |  |  | Oct
[NAME] | F2F | 176 | 221 | 134 | 170 | 221 | 177 | 277 | 263 | 290 | 289
[NAME] | TI | 203 | 292 | 244 | 184 | 290 | 180 | 289 | 275 | 209 | 294
[NAME] | Translation | 100 | 195 | 239 | 138 | 213 | 274 | 155 | 284 | 109 | 104
[NAME] | Translation | 190 | 146 | 201 | 296 | 195 | 110 | 242 | 251 | 129 | 150
[NAME] | F2F | 102 | 278 | 133 | 186 | 125 | 115 | 133 | 277 | 272 | 292
[NAME] | TI | 176 | 151 | 158 | 249 | 114 | 220 | 126 | 211 | 244 | 270
[NAME] | F2F | 176 | 135 | 186 | 185 | 218 | 155 | 254 | 268 | 195 | 134
[NAME] | Translation | 299 | 276 | 282 | 283 | 259 | 241 | 291 | 130 | 257 | 280
[NAME] | Translation | 266 | 245 | 292 | 184 | 285 | 233 | 235 | 292 | 299 | 186
[NAME] | F2F | 237 | 280 | 130 | 205 | 197 | 293 | 138 | 102 | 276 | 258
[NAME] | TI | 110 | 157 | 278 | 148 | 279 | 187 | 219 | 243 | 125 | 178
[NAME] | TI | 125 | 152 | 249 | 195 | 297 | 150 | 178 | 148 | 122 | 239
[NAME] | F2F | 213 | 132 | 299 | 239 | 298 | 276 | 203 | 279 | 176 | 258
[NAME] | TI | 133 | 182 | 275 | 179 | 256 | 280 | 266 | 152 | 298 | 281
[NAME] | TI | 295 | 288 | 201 | 161 | 107 | 241 | 177 | 218 | 241 | 101
[NAME] | Translation | 207 | 278 | 201 | 281 | 180 | 191 | 180 | 218 | 252 | 203
[NAME] | F2F | 212 | 134 | 133 | 116 | 189 | 202 | 146 | 190 | 295 | 258
[NAME] | F2F | 219 | 292 | 118 | 155 | 134 | 213 | 115 | 205 | 231 | 167
[NAME] | TI | 287 | 193 | 140 | 186 | 211 | 273 | 151 | 150 | 162 | 282
[NAME] | F2F | 233 | 281 | 297 | 120 | 196 | 290 | 172 | 115 | 105 | 219
Name | [NAME]
Type | TI
Month | Jan
Spreadsheet: 82442d1282527729-difficulty-creating-charts-from-complex-data-set-copy2-of-sample-workbook
Sheet: Sheet2

Project ID | 345678
starts in row | 14
Project Name | Project 3
 | OPEX |  |  | CAPEX |  |  | Total |  |  |  |  | Helpers to construct the Index
 | Budget | Forecast | Actuals | Budget | Forecast | Actuals | Budget | Forecast | Actuals |  | These are the column numbers for the months
2010-07-01 00:00:00 | 333.3333333333333 | 1000 | 3000 | 583.3333333333334 | 4000 | 5000 | 916.6666666666666 | 5000 | 8000 |  | 7 | 8 | 9
2010-08-01 00:00:00 | 333.3333333333333 | 2000 | 0 | 583.3333333333334 | 6000 | 0 | 916.6666666666666 | 8000 | 0 |  | 10 | 11 | 12
2010-09-01 00:00:00 | 333.3333333333333 | 2000 | 0 | 583.3333333333334 | 6500 | 0 | 916.6666666666666 | 8500 | 0 |  | 13 | 14 | 15
2010-10-01 00:00:00 | 333.3333333333333 | 3000 | 0 | 583.3333333333334 | 5000 | 0 | 916.6666666666666 | 8000 | 0 |  | 16 | 17 | 18
2010-11-01 00:00:00 | 333.3333333333333 | 0 | 0 | 583.3333333333334 | 0 | 0 | 916.6666666666666 | 0 | 0 |  | 19 | 20 | 21
2010-12-01 00:00:00 | 333.3333333333333 | 0 | 0 | 583.3333333333334 | 0 | 0 | 916.6666666666666 | 0 | 0 |  | 22 | 23 | 24
2011-01-01 00:00:00 | 333.3333333333333 | 0 | 0 | 583.3333333333334 | 0 | 0 | 916.6666666666666 | 0 | 0 |  | 25 | 26 | 27
2011-02-01 00:00:00 | 333.3333333333333 | 0 | 0 | 583.3333333333334 | 0 | 0 | 916.6666666666666 | 0 | 0 |  | 28 | 29 | 30
2011-03-01 00:00:00 | 333.3333333333333 | 0 | 0 | 583.3333333333334 | 0 | 0 | 916.6666666666666 | 0 | 0 |  | 31 | 32 | 33
2011-04-01 00:00:00 | 333.3333333333333 | 0 | 0 | 583.3333333333334 | 0 | 0 | 916.6666666666666 | 0 | 0 |  | 34 | 35 | 36
2011-05-01 00:00:00 | 333.3333333333333 | 0 | 0 | 583.3333333333334 | 0 | 0 | 916.6666666666666 | 0 | 0 |  | 37 | 38 | 39
2011-06-01 00:00:00 | 333.3333333333333 | 0 | 0 | 583.3333333333334 | 0 | 0 | 916.6666666666666 | 0 | 0 |  | 40 | 41 | 42
Spreadsheet: 99033d1297808550-if-and-vlookup-in-12-sheets-question_2
Sheet: Jahresauswertung

Product | Description | Beginning Inventory
Tennisschläger | rot | 1800
Tennisschläger | schwarz | 1335
Fussball | schwarz | 890
Fussball | weiss | 3100
[NAME] | weiss | 33986
Handtuch | schwarz | 870
Badetuch | gestreift | 580
Badetuch | gelb | 435
Spreadsheet: 240096d1370200159-highlighting-cells-by-date-depending-on-where-i-put-an-x-defects-status-sheet-2013_etaf
Sheet: DEFECTS STATUS SHEET

 | 1 |  | Defects Raised | Defects Completed | Defects Outstanding
DEFECTS - STATUS SHEET
CONVEYOR | Description | Reported | Date | Owner | DATE | Priority
No | Problem Statement | By | Raised |  | Completed | 1 | 2 | 3 | 4
1 | JOB 1 |  | 2013-05-01 00:00:00 |  |  | X
2 | [NAME] |  | 2013-05-15 00:00:00 |  |  |  | X
3 | JOB 3 |  | 2013-05-26 00:00:00 |  |  |  |  | X
4 | JOB 4 |  | 2013-06-01 00:00:00 |  |  |  |  |  | X
5 | JOB 5 |  | 2013-06-02 00:00:00 |  |  | X
 |  |  |  |  | 2013-02-01 00:00:00
 | 1) AND(G2="X", =D2<TODAY()-14) - format red
 | 2) AND(H2="X", =D2<TODAY()-21) - format red
 | 3) F2<>"" - so if the cell is NOT blank - format yellow
Spreadsheet: louise_kitchen__23046__11-07 Short Term Cash
Sheet: Variance

Changes as of 5:00 pm
Current Day Variance
 | 770.21 |  | Projected beginning last night
 | 13.7 |  | [NAME] receipts
 |  |  | Actual Opening Balance
 | -224.25 |  | Business units detailed on schedule
 |  |  | Net A2P2 shown on schedule
 |  |  | Net A1P1 shown on schedule
 | -17.65 |  | End of Day Adjustment
 |  |  | Rounding
 |  |  | Expected Ending 11/7/01
Total Variance
 | 274.1 | 12/31 Forecast as of 11/6
 | 13.7 | Beg. [NAME].
 |  | Current Day BU/Corp Activity
 |  |  | Estimate
 |  | -224.25 | Actual for all operations
 | -17.65 | End of Day adj
 | -0.09 | Rounding
 |  | 12/31 Forecast as of 11/7
Spreadsheet: phillip_m_love__30713__200009_OA
Sheet: WE-FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  ECTR (EGM)
 |  |  | NGP&L |  | CPR Adjustments |  | 3rd Day CPR |  | [NAME] |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron | 67099216 | 353723452
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 15663646 | 79909637
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 82762862 | 433633089
 |  |  | 0 | 0
 | Purchases: |  | 0 | 0
6 |  | 3rd Party / Inter Enron | -65982924 | -346291386
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | -15633799 | -79788414
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 296421 | 1421118
 | Total Purchases: |  | -81320302 | -424658682
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
11 |  | Sales | 1829380 | 9123506
12 |  | Purchases | -1988577 | -9887835
 | Total Intra CTS Sales / Purchases |  | -159197 | -764329
 |  |  | 0 | 0
 | Imbalances: |  | 0 | 0
13 |  | In Kind | -99176 | -467626
14 |  | Cash Out | 0 | 0
15 |  | Cash In | 0 | 0
16 |  | Synthetic Storage | -1377089 | -8512039
 | Total Imbalances: |  | -1476265 | -8979665
 |  |  | 0 | 0
 | Storage: |  | 0 | 0
17 |  | Injection (Sales to Stg) | 238990 | 927899
18 |  | W/D (Purchase from Stg) | -51895 | -198050
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | -51895 | -198050
 | Total Storage: |  | 187095 | 729849
 |  |  | 0 | 0
20 | Linepack: |  | 0 | 0
 |  |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
 |  |  | 0 | 0
22 | UA4: |  | 5807 | 28046.0679
 |  |  | 0 | 0
23 | Fuel: |  | 296421 | 1421118
 |  |  | 0 | 0
 | Transport Expense: |  | 0 | 0
24 |  | Commodity | 0 | -3258713.67
25 |  | Demand | 0 | -1210016.24
 | Total Transport Expense: |  | 0 | -4468729.91
 |  |  | 0 | 0
 | Transport Revenue: |  | 0 | 0
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | 0
 | Total Transport Revenue: |  | 0 | 0
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
28 |  | Transport Expense | 0 | 0
29 |  | Transport Revenue | 0 | 0
 | Total Intra CTS Transport |  | 0 | 0
 |  |  | 0 | 0
 | Tie Out Schedule Items: |  | 0 | 0
 |  | MTM Income: | 0 | 0
30 |  | Current Gross Book Balance | 0 | 1803667
31 |  | Prior Month Book Balance | 0 | -3366769
 |  | Total MTM Income | 0 | -1563102
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | -3942760
34 |  | Originations | 0 | 0
35 |  | Broker Fees | 0 | 0
36 |  | Asset Group Demand Charges | 0 | 0
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 0
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | -357248
 |  | TOTAL INTRA-MTH
FT-West
 |  | Current Month MTM | 0 | -7046936
 |  | Financial Liquidations | 0 | 0
 |  | Originations | 0 | 0
 |  | TOTAL FIRM TRADING
 |  | TOTAL NGPL
Spreadsheet: 720172d1614051348-stuck-on-how-i-can-automate-the-on-time-where-it-follows-certain-conditions-book1
Sheet: Sheet1

Time (Normal Room) | ON/OFF Time |  | Time | Duration(min) | Normal Room
00:00:00 | 0
 | 1
 | 1
 | 0
 | 1
 | 1
Normal Room
ON time (min) | 10
OFF time (min) | 10
Spreadsheet: 56577d1256746841-excel-2007-comparing-cells-to-find-best-results-tech-monthly-report-master
Sheet: Week 1

 |  |  |  | WEEK 1
 | Technician |  |  |  | Work Comp % | QC Pass % | CDV/HSI Jobs | Activation Attemtps | [NAME] | VOD Attempts
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 20
 | 21
 | 22
 | 23
 | 24
 | 25
Spreadsheet: 272938d1382552677-get-the-total-values-based-on-date-question
Sheet: Sheet1

ID | Total Items | Date | Criteria 1 | Difference of total Items last active day
a | 1 | 2013-10-01 00:00:00 | a | 1
b | 2 | 2013-10-01 00:00:00 | b | 2
c | 3 | 2013-10-01 00:00:00 | c | 3
d | 4 | 2013-10-01 00:00:00 | d | 4
e | 5 | 2013-10-01 00:00:00 | e | 5
f | 6 | 2013-10-01 00:00:00 | f | 6
a | 13 | 2013-10-04 00:00:00 | a | 12 |  | The red values should be the answer
b | 15 | 2013-10-04 00:00:00 | b | 13
c | 12 | 2013-10-04 00:00:00 | c | 9
d | 22 | 2013-10-04 00:00:00 | d | 18
e | 9 | 2013-10-04 00:00:00 | e | 4
f | 7 | 2013-10-04 00:00:00 | f | 1
a | 1 | 2013-10-07 00:00:00 | a | 11
b | 2 | 2013-10-07 00:00:00 | b | 11
c | 3 | 2013-10-07 00:00:00 | c | 9
d | 4 | 2013-10-07 00:00:00 | d | 14
e | 3 | 2013-10-07 00:00:00 | e | 1
f | 1 | 2013-10-07 00:00:00 | f | 0
Spreadsheet: 767127d1644309153-xlookup-when-both-the-lookup-value-and-lookup-array-are-separated-by-commas-pq-journal-example-revised-aligw
Sheet: Sheet 2

ISSN | Title | Journal Type |  |  | ISSN | Title | Journal Type
2208-7958 | Australian journal of general practice | Specialist |  |  | 1234-9887 | [NAME] | Specialist
2095-7505 | Frontiers of Agricultural Science and Engineering | Journal |  |  | 2095-7505 | Frontiers of Agricultural Science and Engineering | Journal
2373-8731 | Transplantation Direct | Journal |  |  | 2096-2703 | Plant Diversity | Journal
2198-6576, 2198-6584 | Rheumatology and therapy | Journal |  |  | 2157-3905 | Sport, Exercise, and Performance Psychology | Specialist
2206-7485, 2208-522X | Emotions: History, Culture, Society | Specialist |  |  | 2157-3913 | Sport, Exercise, and Performance Psychology | Specialist
2469-1178, 1234-9887, 4327-4432 | [NAME] | Specialist |  |  | 2198-6576 | Rheumatology and therapy | Specialist
2377-2484 | Acta oto-[NAME] case reports | Specialist |  |  | 2198-6576 | Rheumatology and therapy | Journal
2548-0839 | European Endodontic Journal | Journal |  |  | 2198-6584 | Rheumatology and therapy | Specialist
2157-3905, 2157-3913 | Sport, Exercise, and Performance Psychology | Specialist |  |  | 2198-6584 | Rheumatology and therapy | Journal
2206-7485 | Emotions: History, Culture, Society | Journal |  |  | 2206-7485 | Emotions: History, Culture, Society | Specialist
2588-2767 | Galen Medical Journal | Specialist |  |  | 2206-7485 | Emotions: History, Culture, Society | Journal
2198-6576, 2198-6584,7896-4563 | Rheumatology and therapy | Specialist |  |  | 2208-522X | Emotions: History, Culture, Society | Specialist
2096-2703 | Plant Diversity | Journal |  |  | 2208-7958 | Australian journal of general practice | Specialist
2666-6359 | Med | Journal |  |  | 2373-8731 | Transplantation Direct | Journal
 |  |  |  |  | 2377-2484 | Acta oto-[NAME] case reports | Specialist
 |  |  |  |  | 2469-1178 | [NAME] | Specialist
 |  |  |  |  | 2548-0839 | European Endodontic Journal | Journal
 |  |  |  |  | 2588-2767 | Galen Medical Journal | Specialist
 |  |  |  |  | 2666-6359 | Med | Journal
 |  |  |  |  | 4327-4432 | [NAME] | Specialist
 |  |  |  |  | 7896-4563 | Rheumatology and therapy | Specialist
Spreadsheet: 680934d1591268024-need-formula-mimic-olympic-medal-award-process-olympic-medal-formula
Sheet: Sheet1

Item # | Organization (e.g., US State) | Priority | Need Formula Which Produces Outputs (e.g., Olympic Medal Process) | [NAME]
1 | CA | 1 | 1
2 | CA | 1 | 1
1 | FL | 1 | 1
2 | FL | 3 | 2
3 | FL | 3 | 2
4 | FL | 4 | 4
1 | IN | 1 | 1
2 | IN | 2 | 2
3 | IN | 5 | 3
4 | IN | 5 | 3
5 | IN | 6 | 5
6 | IN | 6 | 5
1 | KS | 1 | 1
2 | KS | 2 | 2
1 | MN | 2 | 1
2 | MN | 2 | 1
1 | NY | 1 | 1
2 | NY | 2 | 2
3 | NY | 3 | 3
4 | NY | 5 | 4
5 | NY | 5 | 4
6 | NY | 5 | 4
7 | NY | 5 | 4
8 | NY | 5 | 4
9 | NY | 6 | 5
10 | NY | 7 | 10
11 | NY | 9 | 11
1 | TX | 5 | 1
2 | TX | 5 | 1
3 | TX | 5 | 1
4 | TX | 5 | 1
5 | TX | 5 | 1
Spreadsheet: 138002d1327476811-depth-chart-formula-question-excelforum
Sheet: Sheet1

Name | Junior Club | D.O.B | Age | H [cm] | W [kg] | Debut | Position[s] | Years | Contract Value
[NAME] Thaiday | Townsville Brothers QLD | 1985-06-12 00:00:00 | 27 | 181 | 110 | 2003 | SR | 1 | 350000 |  | FB
[NAME] | Southern Suburbs QLD | 1985-06-24 00:00:00 | 27 | 189 | 107 | 2005 | LK | 1 | 325000 |  | WI
[NAME] | South Tuggeranong Knights NSW | 1990-05-10 00:00:00 | 22 | 188 | 88 | 2009 | FB | 1 | 250000 |  | CE
[NAME] | [NAME] NSW | 1982-06-11 00:00:00 | 30 | 180 | 100 | 2004 | LK | 1 | 250000 |  | FE
[NAME] | Thirroul NSW | 1987-05-24 00:00:00 | 25 | 190 | 107 | 2008 | LK | 1 | 150000 |  | HB
[NAME] | [NAME] | 1979-08-01 00:00:00 | 33 | 172 | 83 | 2000 | HK | 1 | 150000 |  | PR
[NAME] | Hurstville United NSW | 1991-12-12 00:00:00 | 21 | 188 | 96 | 2010 | WI | RT | 125000 |  | HK
[NAME] | Bilambil Jets NSW | 1991-07-20 00:00:00 | 21 | 189 | 105 | 2010 | PR | RT | 100000 |  | SR
[NAME] | Hurstville United NSW | 1991-02-04 00:00:00 | 21 | 182 | 82 | 2010 | CE | RT | 100000 |  | LK
[NAME] | [NAME] | 1991-07-29 00:00:00 | 21 | 184 | 94 | 2009 | WI | RT | 75000
[NAME] | Burleigh Bears QLD | 1991-12-17 00:00:00 | 21 | 184 | 89 | 2008 | FB | RT | 75000
[NAME] | Campbelltown City NSW | 1991-05-27 00:00:00 | 21 | 190 | 93 | 2011 | CE | RT | 75000
[NAME] | Blackwater Crushers QLD | 1990-03-27 00:00:00 | 22 | 178 | 90 | 2009 | FE | 1 | 75000
[NAME] | [NAME] NSW | 1993-01-09 00:00:00 | 19 | 176 | 81 | 0 | FB | RT | 50000
[NAME] | [NAME] | 1991-03-15 00:00:00 | 21 | 175 | 83 | 2011 | HK | RT | 50000
[NAME] | Mt Albert NZ | 1991-08-05 00:00:00 | 21 | 183 | 100 | 0 | CE | RT | 50000
Tyrone Peachey | Cronulla Carringbah NSW | 00:00:00 | 0 | 186 | 0 | 0 | SR | RT | 50000
[NAME] | Mt Wellington NZ | 1992-01-10 00:00:00 | 20 | 187 | 88 | 0 | FE | RT | 50000
[NAME] | Mt Albert NZ | 1992-03-04 00:00:00 | 20 | 180 | 85 | 0 | FB | RT | 50000
[NAME] | [NAME] NSW | 1991-09-17 00:00:00 | 21 | 180 | 87 | 2010 | HK | RT | 50000
 |  |  | 21.7 | 183.1 | 88.4 |  |  |  | 2450000
Spreadsheet: 723249d1615574013-hyperlinks-how-to-permanently-reference-a-cell-in-a-workbook-book1
Sheet: Sheet2

US Presidents | No. | Presidency | Party
[NAME] | 1 | April 30, 1789 - March 4, 1797 | Unaffiliated
[NAME] | 2 | March 4, 1797 - March 4, 1801 | Federalist
[NAME] | 3 | March 4, 1801 - March 4, 1809 | Democratic-Republican
[NAME] | 24 | March 4, 1885 - March 4, 1889 | Democratic
[NAME] | 26 | September 14, 1901 - March 4, 1909 | Republican
[NAME] | 41 | January 20, 1989 - January 20, 1993 | Republican
[NAME] | 42 | January 20, 1993 - January 20, 2001 | Democratic
Try sorting or filtering by any column.
Spreadsheet: 70979d1271745914-retrieving-values-from-another-worksheet-depending-on-value-range-example
Sheet: Sheet 2

 | Family Income Monthly ($) | Govt [NAME]
 | 15000
 | 2900
 | 2100
 | 3600
 | 4300
 | 4100
 | 1300
 | 2400
 | 4400
 | 2000
 | 3950
 | 5500
 | 9000
 | 4700
 | 8500
 | 7800
 | 6800
 | 7800
 | 4600
 | 4000
 | 1000
 | 3700
 | 3900
 | 6500
 | 6000
 | 2200
 | 1800
 | 11000
 | 4200
 | 2500
Spreadsheet: 685127d1593751651-help-with-a-formula-function-for-totaling-hours-for-a-job-dmferd
Sheet: Employee 1

Labour Costs
 |  |  | 27
 |  |  |  | 18-1013 |  | 20-1001 |  | 19-1011 |  | 19-1013 |  | 19-1015 |  | 19-1020 |  | 19-1021 |  | 19-1022 |  | 19-1026 |  | 19-1029 |  | 19-1032 |  | 19-1035 |  | 19-1036 |  | 20-1002 |  | 20-1003 |  | 20-1004 |  | 20-1005 |  | 20-1006 |  | 20-1007 |  | 20-1008 |  | 20-1009 |  | 20-1010 |  | 20-1011 |  | 20-1012 |  | 20-1013 |  | 20-1014 |  | 20-1015
PP | Pay Period |  | Hours |  | Hours |  | Hours |  | Hours |  | Hours |  | Hours |  | Hours |  | Hours |  | Hours |  | Hours |  | Hours |  | Hours |  | Hours |  | Hours |  | Hours |  | Hours |  | Hours |  | Hours |  | Hours |  | Hours |  | Hours |  | Hours |  |  |  |  |  | Hours |  | Hours |  | Hours
1 | Dec 29-Jan 3 |  |  |  |  |  |  |  |  |  |  |  | 24.5
2 | Jan 5 - 11 |  |  |  |  |  |  |  |  |  |  |  | 45.5
3 | Jan 12-18 |  |  |  |  |  |  |  |  |  |  |  | 46
4 | Jan 19-25 |  |  |  |  |  |  |  |  |  |  |  | 36
5 | Jan 26-Feb 1 |  |  |  |  |  |  |  |  |  |  |  | 45
6 | Feb 2-8 |  |  |  |  |  |  |  |  |  |  |  | 34.5 |  |  |  | 8.5
7 | Feb 9-15 |  |  |  |  |  |  |  |  |  |  |  | 45
8 | Feb 16 - 22 |  |  |  |  |  |  |  |  |  |  |  | 35.5
9 | Feb 23 - 29 |  |  |  |  |  |  |  |  |  |  |  | 41.5
10 | [NAME] |  |  |  |  |  |  |  |  |  |  |  | 12 |  |  |  | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  | 16 |  |  |  |  |  |  |  | 4
11 | [NAME] |  |  |  |  |  |  |  |  |  |  |  | 17.5
12 | [NAME] |  |  |  |  |  | NO WORK
13 | [NAME] |  |  |  |  |  | 36.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
14 | [NAME] |  |  |  |  |  | 9 |  |  |  |  |  | 24.5
15 | Apr 5 - 11
16 | Apr 12 - 18
17 | April 19 - 25 |  |  |  |  |  |  |  | NO WORK
18 | Apr 26 - May 2 |  |  |  |  |  |  |  | NO WORK
19 | May 3 - 9
20 | May 10 - 16 |  |  |  |  |  | 15.5 |  |  |  |  |  |  |  | 4
21 | May 17  - 23 |  |  |  |  |  |  |  |  |  |  |  |  |  | 31
22 | May 24 - 30 |  |  |  |  |  | 15 |  |  |  |  |  | 7.5 |  | 13
23 | May 30 -June 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20
24 | June 7 - 13 |  |  |  |  |  | 2.5
25 | June 14 - 20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24 |  |  |  |  |  | 9
26 | June 21 - 27
27 | June 28 - July 4
28 | July 5 - 11
29 | July 12  18
30 | July 19 - 25
31 | July 26 - Aug 1
32 | Aug 2 - 8
33 | Aug 9 - 15
34 | Aug 16 - 22
35 | Aug 23 - 29
36 | Aug 30-Sept 5
37 | Sept 6 - 12
38 | Sept 13 - 19
39 | Sept 20 - 26
40 | Sept 27 - Oct 3
41 | [NAME]
42 | Oct 11 - 17
43 | Oct 18 - 24
44 | Oct 25 - 31
45 | Nov 1 - 7
46 | Nov 8 - 14
47 | Nov 15 - 21
48 | Nov 22 - 28
49 | Nov 29 - Dec 5
50 | Dec 6 - 12
51 | Dec 13 - 19
52 | Dec 20 - 26
 | Dec 27 - Jan 2
53
Spreadsheet: 115657d1311195506-vlookup-not-returning-correct-results-lien-book-example-
Sheet: FY 12 Developer Paydowns

Townhome | 13808
Duplex $299,999 or less | 11987
Duplex $300K-$349K | 13808
SF - Medium | 16338
SF - Large (outside) | 19257
SF - Large | 17449
Date Range Sold:
Parcel ID | Unit Type | Original Total Principal | Sale Date | Sale Amount | Reduced Total Principal | [NAME] Before Sale | Principal Paydown Due | Interest Due | What Interest Should Be | Total Paydown Due
House 1 |  |  |  |  |  |  |  |  | 191.22
House 2 |  |  |  |  |  |  |  |  | 225.77
House 3 |  |  |  |  |  |  |  |  | 121.04
House 4 |  |  |  |  |  |  |  |  | 191.22
House 5 |  |  |  |  |  |  |  |  | 225.77
House 6 |  |  |  |  |  |  |  |  | 0
House 7 |  |  |  |  |  |  |  |  | 0
House 8 |  |  |  |  |  |  |  |  | 0
House 9 |  |  |  |  |  |  |  |  | 121.04
House 10 |  |  |  |  |  |  |  |  | 225.77
House 11 |  |  |  |  |  |  |  |  | 225.77
House 12 |  |  |  |  |  |  |  |  | 225.77
House 13 |  |  |  |  |  |  |  |  | 225.77
Spreadsheet: darrell_schoolcraft__7797__imbalsumm0107
Sheet: DEFS

 | 23995 |  | 22051 |  | 22051
 | 59687 |  | 10703 |  | 78169
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 0 | 0 | 24670 | 23460 | 5859 | 5072
2 | 0 | 0 | 24668 | 23536 | 5831 | 5129
3 | 0 | 0 | 24650 | 24000 | 5360 | 5129
4 |  |  | 24663 | 24000 | 5420 | 5126
5 |  |  | 24668 | 24000 | 5484 | 5124
6 |  |  | 24503 | 24000 | 5429 | 5129
7 |  |  | 24451 | 23999 | 5242 | 5129
8 |  |  | 24468 | 23999 | 5480 | 5129
9 |  |  | 24443 | 23999 | 5410 | 5129
10 |  |  | 24497 | 24000 | 5394 | 5129
11 |  |  | 24479 | 24000 | 5664 | 5129
12 |  |  | 24472 | 24000 | 5778 | 5129
13 |  |  | 24489 | 24000 | 5753 | 5129
14 |  |  | 24484 | 23536 | 5619 | 5129
15 | 1 |  | 23245 | 20840 | 5765 | 5129
16 | 16 |  | 22510 | 23536 | 5860 | 5129
17 |  |  | 22450 | 24000 | 5860 | 5129
18 |  |  | 20394 | 24000 | 4806 | 5129
19 |  |  | 7631 | 11501 | 1872 | 5129
20 |  |  | 22472 | 21941 | 2985 | 3143
21 |  |  | 24856 | 21802 | 2309 | 3554
22 |  |  | 23975 | 21405
23 |  |  | 23607 | 24000
24 |  |  | 24468 | 24000
25 |  |  | 24250 | 24000
26 |  |  | 24501 | 24000
27 |  |  | 24455 | 24000
28 |  |  | 24465 | 23189
29
30
31
2001-06-30 00:00:00 | Balance | -1023092.89 |  |  |  | -436546.2
2001-07-28 00:00:00 | Balance
 |  |  |  | Contract #
 |  |  |  | 22864 |  |  | -58339.66 | Zia
 |  |  |  | 20379 |  |  | -51695.87 | Grayco/Artesia
 |  |  |  | 21459 |  |  | 10570.56
 |  |  |  | 26357 |  |  | 44144.84 | [NAME]
 |  |  |  | 21544 |  |  | 61340.16 | [NAME], [NAME]
 |  |  |  | 24532 |  |  | -671608.5 | 500211,500212,500219,500230 - Coburn points
 |  |  |  | Duke