tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 16f513ee-b705-4603-8298-c529a6971354
Sheet: Sheet1

2002-11-05 00:00:00 | UNITED STATES SENATOR | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Belknap County | [NAME], r | Shaheen, d | Blevens, l | Smith | [NAME]
Alton | 1330 | 578 | 42 | 18
Barnstead | 775 | 712 | 29 | 4
Belmont | 1164 | 960 | 41 | 12 | 2
Center Harbor | 324 | 186 | 11 | 4
Gilford | 2020 | 1185 | 40 | 15
Gilmanton | 707 | 586 | 28 | 5
[NAME] | 809 | 446 | 14 | 7
[NAME] | 504 | 346 | 14 | 9
[NAME] 3 | 442 | 374 | 12 | 1 | 1
[NAME] | 506 | 385 | 17 | 7
[NAME] | 370 | 322 | 12
[NAME] 6 | 510 | 362 | 16 | 8
Meredith | 1562 | 936 | 44 | 16 | 2
New Hampton | 458 | 335 | 17 | 5
Sanbornton | 636 | 547 | 27 | 4
[NAME] | 541 | 505 | 29 | 6
TOTALS | 12658 | 8765 | 393 | 121 | 5
Carroll County | [NAME], r | Shaheen, d | Blevens, l | Smith | [NAME]
Albany | 109 | 124 | 6
[NAME] | 620 | 689 | 22 | 15
[NAME] | 198 | 113 | 6 | 3
Chatham | 62 | 49 | 2 | 1
Conway | 1378 | 1578 | 41 | 41 | 4
Eaton | 79 | 108 | 2 | 5
[NAME] | 237 | 194 | 17 | 3
Freedom | 377 | 290 | 10 | 3 | 1
Hale's Location | 55 | 13 | 1 | 7
Hart's Location | 10 | 11 | 0
[NAME] | 274 | 296 | 7 | 7
[NAME] | 381 | 445 | 15 | 9
Moultonborough | 1577 | 595 | 41 | 15 | 1
Ossipee | 790 | 605 | 36 | 13
Sandwich | 368 | 393 | 18 | 3
Tamworth | 474 | 519 | 20 | 7
Tuftonboro | 767 | 391 | 22 | 16 | 1
Wakefield | 915 | 599 | 37 | 11 | 2
Wolfeboro | 1979 | 1122 | 32
TOTALS | 10650 | 8134 | 335 | 159 | 9
Spreadsheet: 777113d1650178228-automatically-copy-data-into-summary-book2-summary
Sheet: Sheet1

 |  |  |  | J |  |  |  |  |  |  |  |  |  |  |  |  | L |  |  |  |  |  |  |  |  |  |  |  |  | S |  |  |  |  |  |  |  |  |  |  |  |  | M
 |  |  | Name | Chit | Score | Date |  |  |  |  |  |  |  |  |  | Name | Chit | Score | Date |  |  |  |  |  |  |  |  |  | Name | Chit | Score | Date |  |  |  |  |  |  |  |  |  | Name | Chit | Score | Date
Spreadsheet: 161502d1339531500-excel-2007-ranking-based-on-more-factors-in-2-columns-problem-with-ranking
Sheet: Info

1.Bordopstillinger | 2.Konference passere | 3.Aktivitet | 4.Lokale pris koder | 5.Forplejnings koder | 6.Lokaler
Slettet booking | Slettet booking | Slettet booking | Slettet booking | Slettet booking | Slettet booking
4 borde sammen | [NAME] | Møde | Standard | Minimum | K1
Borde til 4 pax | Ane | Samtale | Inhouse | Standard | K2
Hestesko | Birger | Workshop | Cubion | Inhouse | L2
Inspari rækker | Charlotte | Event | [NAME] ordner | SpeIn | Hems tv
Langbord | Inger |  | SpeIn | Gratis aktivitet | Hems th
Stolerækker | [NAME] |  | Gratis aktivitet | [NAME] ordner | NMH
Rundkreds af stole
Spreadsheet: 63620d1264518169-how-to-validate-two-column-to-get-the-result-example2
Sheet: worksheetB

Name | Data | Output
May | A
May | B
May | C
Eva | A
Eva | B
Eva | D
[NAME] | A
[NAME] | B
[NAME] | C
[NAME] | A
Spreadsheet: 161133d1339425746-item-value-consolidation-item-test
Sheet: Sheet1

Item | Price |  |  | Item | Price
2468 | 2 |  |  | 2468 | 20
2468 | 4 |  |  | 369 | 27
2468 | 8 |  |  | 48 | 8
2468 | 6
369 | 3
369 | 10
369 | 14
48 | 2
48 | 6
Spreadsheet: 676689d1588936894-linking-two-cells-to-return-values-in-columns-2312-daily-production-report
Sheet: NewDataStructure

Shift | Department | Machine | Issues | Action | Downtime | Date | Week
1st Shift | 2312 | Lathe Mori #4295 | bar feeder | Main resolved issue | 8 | 2020-04-23 00:00:00
1st Shift | 2312 | Lathe Mori #4295 | bar feeder | Main resolved issue | 10 | 2020-04-22 00:00:00
1st Shift | 2312 | Lathe Mori #4295 | bar feeder | Main resolved issue | 12 | 2020-04-24 00:00:00
1st Shift | 2312 | Lathe Mori #4295 | bar feeder | Main resolved issue | 5 | 2020-04-25 00:00:00
1st Shift | 2312 | Lathe Mori #4295 | bar feeder | Main resolved issue | 6 | 2020-04-25 00:00:00
1st Shift | 2312 | Lathe Mori #4295 | bar feeder | Main resolved issue | 9 | 2020-04-25 00:00:00
2nd Shift | 2312 | [NAME] | Spindle | Maintenance working on issue | 36 | 2020-04-22 00:00:00
2nd Shift | 2312 | [NAME] | Spindle | Maintenance working on issue | 18 | 2020-04-23 00:00:00
2nd Shift | 2312 | [NAME] | Spindle | Maintenance working on issue | 18 | 2020-04-25 00:00:00
3rd Shift | 2312 | 3rd shift Machine | Spindle 3rd shift | Maintenance | 18 | 2020-04-22 00:00:00
3rd Shift | 2312 | 3rd shift Machine | Spindle 3rd shift 2 | Maintenance | 24 | 2020-04-23 00:00:00
3rd Shift | 2312 | 3rd shift Machine | Spindle 3rd shift 3 | Maintenance | 16 | 2020-04-25 00:00:00
Spreadsheet: 107309d1304513807-sum-if-or-vlookup-with-range-sum-if-with-range
Sheet: Sheet2

category 1 | 500
category 1 | 200
category 1 | 100
category 2 | 300
category 3 | 300
category 3 | 200
category 3 | 200
category 3 | 100
category 3 | 500
category 3 | 200
Spreadsheet: rick_buy__32820__DOUG
Sheet: 0901

4
POWER PLANTS  ACCOUNTS RECEIVABLE AGING
AS OF SEPTEMBER 30, 2001
 |  |  | CURRENT |  | 1-30 |  | 31-60 |  | 61-90 |  | OVER 90 |  | TOTAL | COMMENTS
SMITH ENRON | A/R |  | 0 |  | 3995609.14 |  | 4246004.18 |  | 1480001.13 |  | 18408675.15 |  |  | THIS MONTH TOTAL PAYMENTS
 | PER CENT |  |  |  |  |  | 0 |  | 0 |  |  |  |  | 0
PUERTO QUETZAL | A/R |  | 0 |  | 0 |  | 0 |  | 0 |  | 361082.48 |  |  | THIS MONTH TOTAL PAYMENTS
 | PER CENT |  |  |  |  |  |  |  |  |  |  |  |  | 2607998.87
DABHOL POWER CO | A/R |  | 666128.31 |  | 0 |  | 222042.41 |  | 222042.83 |  |  |  |  | THIS MONTH TOTAL PAYMENTS
 | PER CENT |  |  |  |  |  |  |  |  |  |  |  |  | 0
EMPRESA ENERGETICA | A/R |  | 1241186.19 |  | 0 |  | 1395232.05 |  | 0 |  | 74964.58 |  |  | THIS MONTH TOTAL PAYMENTS
 | PER CENT
EGEMINSA | A/R |  | 5724350.44 |  | 4147270.02 |  | 762082.3 |  | 297628.78 |  |  |  |  | THIS MONTH TOTAL PAYMENTS
 | PER CENT
TOTALS | A/R
 | PER CENT |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL RECEIPTS
Spreadsheet: 796327d1663226465-matching-sales-amount-to-deposit-date-matching-sales-amount-to-deposit-date
Sheet: Sheet1

Bank Statement |  |  | POS Data
Deposit Date | Deposit Amount |  | Sales Date | Sales Amount | Date Banked-in
2022-01-01 00:00:00 |  |  | 2022-01-01 00:00:00 | 439.79
2022-01-02 00:00:00 |  |  |  | 110.85 |  |  |  | Date Banked-in in column F is derived from Deposit Date in column A
2022-01-03 00:00:00 |  |  |  | 306.93 |  |  |  | How do I set a formula in cells F3 onwards to search for Deposit Date in column A and to search only between 7 days from Sales Date?
2022-01-04 00:00:00 |  |  |  | 168.65 |  |  |  | Example, Sales Amount of $439.79 on 01/01/22 must match to Deposit Amount in column B from 01/01/22 to 07/01/22 (7 days).
2022-01-05 00:00:00 |  |  |  | 215.07
2022-01-06 00:00:00 | 439.79 |  |  | 362.52
2022-01-06 00:00:00 | 110.85 |  |  | 479.76
2022-01-08 00:00:00 | 168.65 |  |  | 439.79
2022-01-08 00:00:00 | 215.07 |  |  | 283.3
2022-01-08 00:00:00 | 362.52 |  |  | 396.53
2022-01-08 00:00:00 | 479.76 |  |  | 174.19
2022-01-13 00:00:00 | 439.79
2022-01-13 00:00:00 | 283.3
Spreadsheet: 836446d1689358604-cleanup-of-data-that-is-merged-by-client-and-requires-text-to-columns-and-transposing-cleanup
Sheet: Solution

Client Account | Contact Names | Contact Emails |  | Client Account | Contact Names | Contact Emails
Client 1 | [NAME] | [EMAIL] |  | Client 1 | [NAME] | [EMAIL]
Client 2 | [NAME] | [EMAIL] |  | Client 2 | [NAME] | [EMAIL]
Client 3 | [NAME] | [EMAIL] |  | Client 3 | [NAME] | [EMAIL]
Client 3 | [NAME] | [EMAIL] |  | Client 3 | [NAME] | [EMAIL]
Client 3 | [NAME] | [EMAIL] |  | Client 3 | [NAME] | [EMAIL]
Client 3 | [NAME] | [EMAIL] |  | Client 3 | [NAME] | [EMAIL]
Client 4 | [NAME] | [EMAIL] |  | Client 4 | [NAME] | [EMAIL]
Client 4 | [NAME] 8 | [EMAIL] |  | Client 4 | [NAME] 8 | [EMAIL]
Client 4 | [NAME] 9 | [EMAIL] |  | Client 4 | [NAME] 9 | [EMAIL]
Spreadsheet: 52697d1252525175-excel-table-search-look-up-help-using-if-sample-book-ii
Sheet: Sheet1

 |  |  |  |  |  |  |  | ENTERED
ID NO | Name | Cat | Entry Stat
2206 | [NAME] | IM | Entered |  |  |  | ID NO | CAT
 |  |  |  |  |  |  | 2206 | IM
 |  |  |  |  |  |  | 3456 | IM
 |  |  |  |  |  |  | 3456 | MM
 |  |  |  |  |  |  | 6789 | MM
 | [NAME] | MM | Not Registered
2267 | [NAME] | IM | Not Registered
3456 | [NAME] | IM | Entered
6789 | [NAME] | MM | Entered
 | [NAME] | IM | NR
Before |  |  |  |  |  | After [NAME]
Spreadsheet: 163168d1340211157-lookup-1-60-return-2-5-if-betwen-61-75-and-so-on-help
Sheet: Sheet1

loan amount | days to close | fee | total price |  |  | Days to close | fee %
100000 | 30 |  |  |  |  | 60 | 0.0225
100000 | 60 |  |  |  |  | 75 | 0.02
100000 | 65 |  |  |  |  | 105 | 0.015
100000 | 75
100000 | 80
100000 | 105
100000 | 106
100000 | 110
Spreadsheet: 841730d1693906509-data-validation-based-on-index-match-temp_2023
Sheet: Main

 |  | MY COMPANY
 |  | PO/SO No. | Style No. | Qty. | Unit Price | Total
 |  | 4900032870 | W383124030 | 390 | 10 | 3900
 |  | 4900032870 | W373124080 | 195 | 10 | 1950
 |  | 4900032947 | W353128133 | 720 | 40 | 28800
 |  | 4900032947 | W353128133 | 720 | 15 | 10800
 |  | 4900033009 | [NAME] | 800 | 22 | 17600
 |  | 4900033009 | A352124116 | 1000 | 35 | 35000
 |  | 4900032920 | A352126066 | 1150 | 35 | 40250
 |  | 4900032920 | [NAME] | 1850 | 45 | 83250
Spreadsheet: 125710d1319187280-sum-cells-if-a-word-is-repeated-in-sequence-without-more-than-2-interuptions-trendingsmallsample
Sheet: TSI 62% IO Spot Price (2)

Day Count | 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 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 60 | 61 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70 | 71 | 72 | 73 | 74 | 75 | 76 | 77 | 78 | 79 | 80 | 81 | 82 | 83 | 84 | 85 | 86 | 87 | 88 | 89 | 90 | 91 | 92 | 93 | 94 | 95 | 96 | 97 | 98 | 99 | 100 | 101 | 102 | 103 | 104 | 105 | 106 | 107 | 108 | 109 | 110 | 111 | 112 | 113 | 114 | 115 | 116 | 117 | 118 | 119 | 120 | 121 | 122 | 123 | 124 | 125 | 126 | 127 | 128 | 129 | 130 | 131 | 132 | 133 | 134 | 135 | 136 | 137 | 138 | 139 | 140 | 141 | 142 | 143 | 144 | 145 | 146 | 147 | 148 | 149 | 150 | 151 | 152 | 153 | 154 | 155 | 156 | 157 | 158 | 159 | 160 | 161 | 162 | 163 | 164 | 165 | 166 | 167 | 168 | 169 | 170 | 171 | 172 | 173 | 174 | 175 | 176 | 177 | 178 | 179 | 180 | 181 | 182 | 183 | 184 | 185 | 186 | 187 | 188 | 189 | 190 | 191 | 192 | 193 | 194 | 195 | 196 | 197 | 198 | 199 | 200 | 201 | 202 | 203 | 204 | 205 | 206 | 207 | 208 | 209 | 210 | 211 | 212 | 213 | 214 | 215 | 216 | 217 | 218 | 219 | 220 | 221 | 222 | 223 | 224 | 225 | 226 | 227 | 228 | 229 | 230 | 231 | 232 | 233 | 234 | 235 | 236 | 237 | 238 | 239 | 240 | 241 | 242 | 243 | 244 | 245 | 246 | 247 | 248 | 249 | 250 | 251 | 252 | 253 | 254 | 255
Date | 01/06/2009 | 02/06/2009 | 03/06/2009 | 04/06/2009 | 05/06/2009 | 08/06/2009 | 09/06/2009 | 10/06/2009 | 11/06/2009 | 12/06/2009 | 15/06/2009 | 16/06/2009 | 17/06/2009 | 18/06/2009 | 19/06/2009 | 22/06/2009 | 23/06/2009 | 24/06/2009 | 25/06/2009 | 26/06/2009
TSI 62% USD | 65.4 | 65.5 | 65.6 | 66 | 67.8 | 67.8 | 67.8 | 67.8 | 67.8 | 72.1 | 72.4 | 73.1 | 73 | 73 | 74 | 75.7 | 75.7 | 75.7 | 75.7 | 78.2
[NAME]. 24Hrs.
Trend
LN for HV
 |  | 1
Spreadsheet: 870072d1716576071-required-multilevel-sequence-serial-numbers-book11-new-1-
Sheet: Sheet2

 | Area-1 | Topic-1
 | Area-1 | Topic-2 |  |  | Area-2
 | Area-1 | Topic-3 |  |  | Area-3
 | Area-1 | Topic-4 |  |  | Area-4
 | Area-1 | Topic-5
 | Area-1 | Topic-6
 | Area-1 | Topic-7
 | Area-1 | Topic-8
 | Area-1 | Topic-9
 | Area-1 | Topic-10
 | Area-2 | Topic-A
 | Area-2 | Topic-B
 | Area-2 | Topic-C
 | Area-2 | Topic-D
 | Area-2 | Topic-E
 | Area-2 | Topic-F
 | Area-3 | Topic-X1
 | Area-3 | Topic-X2
 | Area-3 | Topic-X3
 | Area-3 | Topic-X4
 | Area-3 | Topic-X5
 | Area-3 | Topic-X6
 | Area-3 | Topic-X7
 | Area-3 | Topic-X8
 | Area-3 | Topic-X9
 | Area-3 | Topic-X10
 | Area-3 | Topic-X11
 | Area-3 | Topic-X12
 | Area-3 | Topic-X13
 | Area-3 | Topic-X14
 | Area-4 | Topic-A1
 | Area-4 | Topic-A2
 | Area-4 | Topic-A3
 | Area-4 | Topic-A4
 | Area-4 | Topic-A5
 | Area-4 | Topic-A6
Spreadsheet: 040c2c50-418e-4b08-b5c0-7e008049c73f
Sheet: Sheet1

Private Pesticide Safety Education Program (PSEP) Fee Distribution Form | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 |  | Date Form Prepared:
 |  | County Office Name: |  |  |  |  | Location (City):
Name of Person Who Prepared the Form: |  |  |  |  |  |  |  | Phone Number:
 |  |  | Data Entry Fields |  |  | Dollar Amounts Will Calculate
 |  |  | Training Date | Number of Participants | Fee | Total $ Collected | Ext Office Share ($8 from each $30) |  | Pest Ed Office Share ($22 of each $30)
Private Pesticide Applicators |  |  |  | 0 | 30 | 0 | 0 |  | 0
 |  |  | Training Date | Number of Participants |  | Total $ Collected | Ext Office Share ($15 from each $60) |  | Pest Ed Office Share ($45 of each $60)
Self-Study Private Pesticide Applicators |  |  |  | 0 | 60 | 0 | 0 |  | 0
 |  |  |  | Totals |  | 0 | 0 |  | 0
For Greater Nebraska Business Center Use:
 |  |  | SAP Revenue Posting Date: |  |  |  | SAP RefDocNo:
 |  |  | Name of GNBC Processor:
Extension Office Instructions:
1) | Create receipt(s) and/or registration receipt log for Private Pesticide Safety Education Program fees collected.
2) | Complete the Private PSEP Fee Distribution Form extension office contact information and data entry fields.  The fee distribution shares between the Extension Office and UNL Pest Ed Office will automatically calculate.
3) | Complete Revenue [NAME] to distribute fee shares (suggested wording examples below):
4) | Complete bank deposit process as usual.
5) | Promptly email scanned Revenue [NAME], bank deposit slip(s), bank deposit receipt, and Private PSEP Fee Distribution Form to the IANR Greater Nebraska Business Center mailbox ([EMAIL]).
GNBC Instructions:
1) | Print GNBC mailbox email attachments. Process PSEP deposits into G/L 452510.  Record SAP Reference Document Number and posting date on Private PSEP Fee Distribution Form.
2) | Scan completed Fee Distribution Form.  [NAME] scanned document to [NAME] ([EMAIL]) and [NAME] ([EMAIL]).  [NAME]:  Private PSEP Fee Reimbursement "X" County
Spreadsheet: 701033d1603472279-master-sheet-to-tabs-based-on-number-typed-on-tab-dash-xc-meet-oct-31-20
Sheet: Master

Bib # | First Name | Last Name | Group | Dash Member?
101 | Emma | [NAME] | KG | No
120 | Ray | Gall | 2ndB | No
130 | Cathy | Jones | 4thG | Yes
Spreadsheet: 830261d1684831992-can-i-combine-sumifs-formula-and-rank-sumif-and-rank-ans
Sheet: Sheet1

DATA
Name | Scores |  |  | RANK | Name | Scores
Alpha | 1000 |  |  | 1
Alpha | 1000 |  |  | 2
Alpha | 1000 |  |  | 3
Bravo | 1200 |  |  | 4
Bravo | 1000 |  |  | 5
Bravo | 100
[NAME] | 3500 | changed for test purpose.
[NAME] | 700
[NAME] | 100
[NAME] | 900
Spreadsheet: 328177d1403805993-overtime-over-40-hours-ppe-06-30-14-holman-c-salary-timesheet
Sheet: WJA

 |  |  |  |  |  | Weekly Time Record
 | Western Jet Aviation, Inc.
 | Employee:
 | Period Beginning: | 2014-06-16 00:00:00 |  |  | Period Ending: | 2014-07-01 00:00:00
 | Day | In | Out | In | Out | Regular Hrs. | [NAME]. | [NAME]. | Vacation Hrs. | Holiday Hrs.
 | 2014-06-16 00:00:00 | 07:30:00 | 11:30:00 | 12:00:00 | 16:00:00 | 8 | 0
 | 2014-06-17 00:00:00 | 07:30:00 | 11:30:00 | 12:00:00 | 16:00:00 | 8 | 0
 | 2014-06-18 00:00:00 | 07:30:00 | 11:30:00 | 12:00:00 | 18:00:00 | 8 | 2
 | 2014-06-19 00:00:00 | 07:00:00 | 11:30:00 | 12:00:00 | 16:00:00 | 8 | 0.5
 | 2014-06-20 00:00:00 | 07:00:00 | 11:30:00 | 12:00:00 | 16:00:00 | 8 | 0.5
 | 2014-06-21 00:00:00 | 08:00:00 |  |  | 11:00:00 | 3 | 0
 | 2014-06-22 00:00:00 |  |  |  |  | 0 | 0
 | 2014-06-23 00:00:00 | 07:30:00 | 11:30:00 | 12:00:00 | 16:00:00 | 8 | 0
 | 2014-06-24 00:00:00 | 07:30:00 | 11:30:00 | 12:00:00 | 16:00:00 | 8 | 0
 | 2014-06-25 00:00:00 | 07:30:00 | 11:30:00 | 12:00:00 | 16:30:00 | 8 | 0.5
 | 2014-06-26 00:00:00 | 07:00:00 | 11:30:00 | 12:00:00 | 16:00:00 | 8 | 0.5
 | 2014-06-27 00:00:00 | 07:30:00 | 11:30:00 | 12:00:00 | 16:00:00 | 8 | 0
 | 2014-06-28 00:00:00 |  |  |  |  | 0 | 0
 | 2014-06-29 00:00:00 |  |  |  |  | 0 | 0
 | 2014-06-30 00:00:00 | 07:30:00 | 13:00:00 | 13:30:00 | 16:00:00 | 7.999999999999998 | 0
 | 2014-07-01 00:00:00 |  |  |  |  | 0 | 0
 |  |  |  | Column Totals |  | 91 | 4 | 0 | 0 | 0
 |  |  |  | Total Hours. |  | 95
Spreadsheet: darrell_schoolcraft__7638__imball0201
Sheet: EOG

 | 500249 |  | 500260 |  | 500646 |  | 500598
 | Pronghorn |  | Pitchfork Ranch |  | Tristi Draw |  | EOG/TW Eddy
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 10708 | 11500 | 8161 | 8800 |  | 7800
2 | 10744 | 11500 | 7789 | 8800 | 70 | 7800
3 | 10863 | 11500 | 7744 | 8800 | 3642 | 7800
4 | 10242 | 11500 | 8002 | 8800 | 5606 | 7800
5 | 10778 | 10500 | 8365 | 7800 | 7664 | 7800
6 | 10431 | 10500 | 8128 | 7800 | 7968 | 7800
7 | 10424 | 10500 | 8598 | 7800 | 7887 | 7800
8 | 10274 | 10500 | 7816 | 7800 | 7847 | 7800
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-12-31 00:00:00 |  |  |  |  |  |  |  |  | 4536.21
2002-01-08 00:00:00
CBS Volume
 |  |  | -125538
Spreadsheet: 709625d1608457119-next-due-date-of-my-air-ticket-after-my-leave-days-next-due-days-with-formula2
Sheet: Sheet1

 | AIR TICKET |  |  |  |  |  | AIR TICKET
 | LEAVE DAYS FROM LAST DUE DATE |  |  |  |  |  | LEAVE DAYS FROM LAST DUE DATE
 | LEAVE FROM | LEAVE TO | DAYS |  |  |  | LEAVE FROM | LEAVE TO | DAYS
 | 2019-08-01 00:00:00 | 2019-08-01 00:00:00 |  |  |  |  | 2019-08-01 00:00:00 | 2019-08-03 00:00:00
 | 2019-09-01 00:00:00 | 2019-09-15 00:00:00 |  |  |  |  | 2019-09-01 00:00:00 | 2019-09-15 00:00:00
 | 2019-12-20 00:00:00 | 2019-12-30 00:00:00 |  |  |  |  | 2019-12-20 00:00:00 | 2019-12-30 00:00:00
 | 2020-03-18 00:00:00 | 2020-03-19 00:00:00 |  |  |  |  | 2020-03-18 00:00:00 | 2020-03-19 00:00:00
 | 2020-03-30 00:00:00 | 2020-03-30 00:00:00 |  |  |  |  | 2020-03-30 00:00:00 | 2020-03-30 00:00:00
 | 2020-09-01 00:00:00 | 2020-09-18 00:00:00 |  |  |  |  | 2020-09-01 00:00:00 | 2020-09-18 00:00:00
 | 2020-12-01 00:00:00 | 2020-12-03 00:00:00 |  |  |  |  | 2020-12-01 00:00:00 | 2020-12-03 00:00:00
 | LAST DUE DATE | 2019-02-28 00:00:00 |  |  |  |  | LAST DUE DATE | 2019-02-28 00:00:00
 | DUE DURATION | AFTER LEAVE DAYS 365 WORKED DAYS |  |  |  |  | DUE DURATION | AFTER LEAVE DAYS 365 WORKED DAYS
 | NEXT DUE DATE | ANSWER ??? | <======= | FORMULA NEED |  |  | NEXT DUE DATE | ANSWER ??? | <======= | FORMULA NEED
 |  |  | LEAVE DAYS | DUE DURATION | TOTAL DAYS FOR DUE |  |  |  | LEAVE DAYS | DUE DURATION | TOTAL DAYS FOR DUE
 | CORRECT ANSWER | 2019-03-28 00:00:00 | 29 | 365 |  |  | CORRECT ANSWER | 2020-03-31 00:00:00 | 32 | 365
Spreadsheet: paul_y'barbo__28501__LPG ProCaribe vs Empire Cost to PDVSA
Sheet: Terminal

 |  |  |  |  | Distributor Total Cost of LPG - Exit Terminals in Puerto Rico
 |  |  |  |  | Empire versus ProCaribe
 |  |  |  | Total | Total | Buyer | PDVSA |  | Buyer | Buyer Premium
 |  | Cargo Size | Cargo Size | Transp. Cost | Transp. Cost | CIF Premium | FOB Premium |  | Terminal Cost | Exit the Terminal
 | Buyer | (Barrels) | (MT) | per MT | per [NAME] | per [NAME] | per [NAME] |  | per [NAME] | per [NAME]
 | Empire et al. |  |  |  |  | 0.0875
 | ProCaribe |  |  |  |  |  | 0.025 |  |  | 0.0925
 | ProCaribe |  |  |  |  |  | 0.025 |  |  | 0.0925
 | ProCaribe |  |  |  |  |  | 0.025 |  |  | 0.0925
 | Terminal Cost per Month
 | Empire et al. |  |  | 40000
 |  |  |  | ProCaribe Annual Terminal Fees
 |  |  |  | ProCaribe Annual Volume (Gallons)
 |  |  | 18000000 | 30000000 | 50000000 | 75000000
 | ProCaribe
 | Cargo Size
 | (MT)
Spreadsheet: 694227d1599465357-extract-every-2nd-row-data-based-value-not-blank-and-criteria-in-column-headers-sample-_1
Sheet: Data

data | 2020-09-01 00:00:00 | 2020-09-02 00:00:00 | 2020-09-03 00:00:00 | 2020-09-04 00:00:00 | 2020-09-05 00:00:00 | 2020-09-06 00:00:00 | 2020-09-07 00:00:00 | 2020-09-08 00:00:00 | 2020-09-09 00:00:00 | 2020-09-10 00:00:00 | 2020-09-11 00:00:00 | 2020-09-12 00:00:00 | 2020-09-13 00:00:00 | 2020-09-14 00:00:00 | 2020-09-15 00:00:00 | 2020-09-16 00:00:00 | 2020-09-17 00:00:00 | 2020-09-18 00:00:00 | 2020-09-19 00:00:00 | 2020-09-20 00:00:00 | 2020-09-21 00:00:00 | 2020-09-22 00:00:00 | 2020-09-23 00:00:00 | 2020-09-24 00:00:00 | 2020-09-25 00:00:00 | 2020-09-26 00:00:00 | 2020-09-27 00:00:00 | 2020-09-28 00:00:00 | 2020-09-29 00:00:00 | 2020-09-30 00:00:00
a1 |  |  |  |  |  |  | w1
 |  |  |  |  |  |  | 11:30 - 12:00
a2 |  |  |  |  |  |  | w1
 |  |  |  |  |  |  | 12:00-12:30
b1 |  |  |  |  |  |  | w1
 |  |  |  |  |  |  | 16:30-17:30
b2 |  |  |  |  |  |  | w2
 |  |  |  |  |  |  | 14:15 - 15:00
c1 |  |  |  |  |  |  | w3
c2 |  |  |  |  |  |  | w2
d1 |  |  |  |  |  |  | w4
d2
e1
e2 |  |  |  |  |  |  | w4
 |  |  |  |  |  |  | 9:00 - 11:00
Spreadsheet: 718378d1613128634-required-formula-to-generate-leave-register-additional-requirement-sample_leavebook2
Sheet: Data

 | Date | [NAME] | Micheal | [NAME] | Ahmed | [NAME] | Greg | Micky | Trace | Lisy | Saraham
 | 2021-02-01 00:00:00
 | 2021-02-02 00:00:00 | X
 | 2021-02-03 00:00:00 |  |  | X
 | 2021-02-04 00:00:00 |  |  |  |  |  |  |  | X
 | 2021-02-05 00:00:00
 | 2021-02-06 00:00:00
 | 2021-02-07 00:00:00 |  |  |  |  |  | X
 | 2021-02-08 00:00:00
 | 2021-02-09 00:00:00
 | 2021-02-10 00:00:00 |  |  | X
 | 2021-02-11 00:00:00
 | 2021-02-12 00:00:00
 | 2021-02-13 00:00:00
 | 2021-02-14 00:00:00 |  |  |  |  |  |  |  |  |  | X
 | 2021-02-15 00:00:00
 | 2021-02-16 00:00:00
 | 2021-02-17 00:00:00
 | 2021-02-18 00:00:00
 | 2021-02-19 00:00:00
 | 2021-02-20 00:00:00
 | 2021-02-21 00:00:00 |  |  |  | X |  |  | X
 | 2021-02-22 00:00:00
 | 2021-02-23 00:00:00
 | 2021-02-24 00:00:00
 | 2021-02-25 00:00:00
 | 2021-02-26 00:00:00
 | 2021-02-27 00:00:00
 | 2021-02-28 00:00:00
 | 2021-03-01 00:00:00
 | 2021-03-02 00:00:00 | X
 | 2021-03-03 00:00:00 |  |  | X
 | 2021-03-04 00:00:00
 | 2021-03-05 00:00:00 |  |  |  |  |  | X
 | 2021-03-06 00:00:00
 | 2021-03-07 00:00:00 |  |  |  |  | X
 | 2021-03-08 00:00:00
 | 2021-03-09 00:00:00 |  |  |  |  |  |  |  |  | X
 | 2021-03-10 00:00:00 | H | H | H | H | H | H | H | H | H | H
 | H | Holiday
 | X | Planned Leave
Spreadsheet: 680243d1590873272-how-to-copy-every-10-rows-from-multiple-sheets-to-one-sheet-rezaworksheet
Sheet: sheet6

12
345
654
999
1
23
54
7
9
233
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
Spreadsheet: 75594d1276135801-how-to-convert-data-in-row-to-a-column-by-dragging-down-create-a-row-from-a-column-by-dragging-across-and-visa-versa
Sheet: Workbook 1

 |  | Amounts to be copied
10 | 3000 | 30000
5 | 2563 | 12815
4 | 2456 | 9824
8 | 2516 | 20128
2 | 8625 | 17250
3 | 3513 | 10539
5 | 32513 | 162565
1 | 24865 | 24865
5 | 358 | 1790
8 | 9852 | 78816
9 | 3517 | 31653