tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 715742d1611847968-sum-values-by-month-year-example
Sheet: Sheet1

 |  | Stock # | # of Photos | Date | List is sorted by most recent date first | temp-pic | reloaded | not in VA | re-shoot
[NAME] |  | 210035 | 52 | 2021-01-27 00:00:00
[NAME] |  | 210013 | 58 | 2021-01-27 00:00:00 |  |  | Total Cars | Total Pics | Avg Pics/Car
 |  | 2 | 110 |  |  | 2021
[NAME] |  | 210014 | 54 | 2021-01-26 00:00:00 |  | 2021-12-01 00:00:00
[NAME] |  | 210042 | 57 | 2021-01-26 00:00:00 |  | 2021-11-01 00:00:00
[NAME] |  | 201029B | 55 | 2021-01-26 00:00:00 |  | 2021-10-01 00:00:00
[NAME] |  | 210021 | 53 | 2021-01-26 00:00:00 |  | 2021-09-01 00:00:00
[NAME] |  | 201346 | 58 | 2021-01-26 00:00:00 |  | 2021-08-01 00:00:00
[NAME] |  | 210052 | 62 | 2021-01-26 00:00:00 |  | 2021-07-01 00:00:00
 |  | 6 | 339 |  |  | 2021-06-01 00:00:00
[NAME] | modified | 201304 | 4 | 2021-01-25 00:00:00 |  | 2021-05-01 00:00:00
[NAME] |  | 210012 | 53 | 2021-01-25 00:00:00 |  | 2021-04-01 00:00:00
[NAME] |  | 210041 | 55 | 2021-01-25 00:00:00 |  | 2021-03-01 00:00:00
[NAME] |  | 201313 | 58 | 2021-01-25 00:00:00 |  | 2021-02-01 00:00:00
 |  | 4 | 170 |  |  | 2021-01-01 00:00:00
[NAME] |  | 201090J | 10 | 2021-01-22 00:00:00 |  | 2020 | 1369 | 65166 | 48
[NAME] | modified | 201343 | 16 | 2021-01-22 00:00:00 |  | 2020-12-01 00:00:00 | 83 | 3626 | 44
[NAME] |  | 201322 | 58 | 2021-01-22 00:00:00 |  | 2020-11-01 00:00:00 | 119 | 5724 | 48
[NAME] | modified | 201290 | 16 | 2021-01-22 00:00:00 |  | 2020-10-01 00:00:00 | 142 | 6854 | 48
[NAME] | modified | 201184A | 21 | 2021-01-22 00:00:00 |  | 2020-09-01 00:00:00 | 110 | 5610 | 51
[NAME] | modified | 201287 | 13 | 2021-01-22 00:00:00 |  | 2020-08-01 00:00:00 | 116 | 5119 | 44
[NAME] | modified | 201258 | 24 | 2021-01-22 00:00:00 |  | 2020-07-01 00:00:00 | 127 | 6113 | 48
[NAME] |  | 201081a | 52 | 2021-01-22 00:00:00 |  | 2020-06-01 00:00:00 | 146 | 8069 | 55
[NAME] |  | 201341 | 51 | 2021-01-22 00:00:00 |  | 2020-05-01 00:00:00 | 100 | 4578 | 46
 |  | 9 | 261 |  |  | 2020-04-01 00:00:00 | 72 | 3449 | 48
[NAME] |  | 210004 | 52 | 2021-01-21 00:00:00 |  | 2020-03-01 00:00:00 | 118 | 5772 | 49
[NAME] |  | 210026 | 47 | 2021-01-21 00:00:00 |  | 2020-02-01 00:00:00 | 116 | 5304 | 46
[NAME] |  | 210003 | 54 | 2021-01-21 00:00:00 |  | 2020-01-01 00:00:00 | 120 | 4948 | 41
[NAME] |  | 201304 | 46 | 2021-01-21 00:00:00 |  | 2019 | 1353 | 46223 | 34
[NAME] |  | 201331 | 46 | 2021-01-21 00:00:00
[NAME] |  | 210051 | 65 | 2021-01-21 00:00:00
 |  | 6 | 310
Spreadsheet: 219783d1362946493-how-to-count-number-of-overlapping-rows-within-a-time-interval-testjobs
Sheet: Sheet1

Name | Job Start Time | Job End Time | interval start | interval end
q1 | 2012-02-17 07:00:01.980000 | 2012-02-17 07:00:06.470000 | 07:00:00
q2 | 2012-02-17 07:00:01.690000 | 2012-02-17 07:00:08.250000
q3 | 2012-02-17 07:00:02 | 2012-02-17 07:00:05.640000
q4 | 2012-02-17 07:00:02.860000 | 2012-02-17 07:00:05.010000
q5 | 2012-02-17 07:00:50.910000 | 2012-02-17 07:01:24.040000
q6 | 2012-02-17 07:00:05.460000 | 2012-02-17 07:00:06.340000
q7 | 2012-02-17 07:00:10.780000 | 2012-02-17 07:00:22.960000
q8 | 2012-02-17 07:00:06.500000 | 2012-02-17 07:00:08.300000
q9 | 2012-02-17 07:00:07.100000 | 2012-02-17 07:00:07.750000
q10 | 2012-02-17 07:00:07.380000 | 2012-02-17 07:00:08.510000
q11 | 2012-02-17 07:00:08.450000 | 2012-02-17 07:00:12.360000
q12 | 2012-02-17 07:00:08.530000 | 2012-02-17 07:00:10.870000
q13 | 2012-02-17 07:00:08.390000 | 2012-02-17 07:00:09.030000
q14 | 2012-02-17 07:20:10.230000 | 2012-02-17 07:20:14.400000
q15 | 2012-02-17 07:00:08.990000 | 2012-02-17 07:00:10.770000
q16 | 2012-02-17 07:00:09.110000 | 2012-02-17 07:00:11.320000
q17 | 2012-02-17 07:04:50.270000 | 2012-02-17 07:16:29.970000
q18 | 2012-02-17 07:20:14.400000 | 2012-02-17 07:20:45.460000
Spreadsheet: 111258d1307662846-how-to-use-lookup-command-form14excel
Sheet: SCRIPT

January RT 2011 | A01A, A01B, A01B, A01C
February RT 2011 | B01A, B01B, B01C, B01D
March RT 2011
April RT 2011
May RT 2011
June RT 2011
July RT 2011
August RT 2011
September RT 2011
October RT 2011
November RT 2011
December RT 2011
MSN PRE-EVAL A
MSN PRE-EVAL B
MSN IQT VER
SYS PRE-EVAL A
SYS PRE-EVAL A
SYS IQT VER
Spreadsheet: 03507833-91e9-4c1f-a5d3-a0b73ba7c1bd
Sheet: Sheet1

Product Formulation Sheet (form PFS-02):  Use this form for each manufactured (either by you or for you) or repacked product to appear on your certificate which you will handle.  Please commplete one sheet for each product.  Marketers of organic multi-ingredient products should complete this form only if they own the formulations for the products they will market.  [NAME] cells indicate where data may be entered.       Do not enter values in Red Cells - they will automatically calculate | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Product Name (as it should appear on certificate):
Process type: | Manufacture |  | Repack |  | Market Only
This product is labeled as: | 100% Organic |  | Organic |  | Made With (70%+) |  | Ingredient listing only (<70%)
This product is packaged and sold as: | Retail |  | Nonretail
 | Label Brand Names: |  |  |  |  |  | [NAME]. on Label
Ingredient | % organic content ingredient | % in formulation |  |  | actual organic % of that ingredient/ product
 |  |  |  |  | 0
 |  |  |  |  | 0 |  | OTCO Office Use
 |  |  |  |  | 0
 |  |  |  |  | 0 |  | Date Approved:
 |  |  |  |  | 0 |  | Revision Dates:
 |  |  |  |  | 0 |  | Approval By:
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0 |  | International Cert Requested
 |  |  |  |  | 0 |  | Mark with X if Requested
 |  |  |  |  | 0 |  | EU
 |  |  |  |  | 0 |  | Canada (COR)
 |  |  |  |  | 0 |  | Canada Equiv.
 |  |  |  |  | 0
 |  |  |  |  | 0
Sub-total for non salt and water contents
 |  |  | 0 |  | 0
Salt
Water
List Processing Aids Used
Totals |  |  | 0
Spreadsheet: 538561d1505714572-multi-page-order-sheet-with-summary-page-oeldere-multi-page-
Sheet: Lattice

Item # | [NAME] | Description
0143-0042 |  | LATTICE PANEL PT BRN;PRIV 4X8X1-3/4"
0143-0043 |  | LATTICE PANEL PT BRN;PRIV PLUS 4"x8'x3/4"
0143-0041 |  | LATTICE PANEL PT BRN;TRAD 4X8X2-5/8"
0143-0036 |  | LATTICE PANEL PT GRN;PRIV 1-3/4X1X8'
0143-0037 |  | LATTICE PANEL PT GRN;PRIV 1-3/4X2X8'
0143-0040 |  | LATTICE PANEL PT GRN;PRIV 1-3/4X4X8'
0143-0038 |  | LATTICE PANEL PT GRN;PRIV 1-3/4X4X8' (HEAVY)
0143-0034 |  | LATTICE PANEL PT GRN;PRIV PLUS 3/4X1X8'
0143-0035 |  | LATTICE PANEL PT GRN;PRIV PLUS 3/4X4X8'
0143-0019 |  | VINYL LATTICE PANEL;BLACK [NAME] 8' (UNFRAMED)
0143-0021 |  | VINYL LATTICE PANEL;BLACK H-TRIM 8'
0143-0020 |  | VINYL LATTICE PANEL;BLACK U-TRIM 8'
0143-0032 |  | VINYL LATTICE PANEL;CLASSIC WHT 2'x8'
0143-0033 |  | VINYL LATTICE PANEL;CLASSIC WHT 4'x8'
0143-0016 |  | VINYL LATTICE PANEL;GREY 4'x 8' (UNFRAMED)
0143-0018 |  | VINYL LATTICE PANEL;GREY H-TRIM 8'
0143-0017 |  | VINYL LATTICE PANEL;GREY U-TRIM 8'
0143-0028 |  | VINYL LATTICE PANEL;KAKI 4'x 8' (UNFRAMED)
0143-0030 |  | VINYL LATTICE PANEL;KAKI H-TRIM 8'
0143-0029 |  | VINYL LATTICE PANEL;KAKI U-TRIM 8'
0143-0025 |  | VINYL LATTICE PANEL;REDWOOD 4'x8' (UNFRAMED)
0143-0027 |  | VINYL LATTICE PANEL;REDWOOD H-TRIM 8'
0143-0026 |  | VINYL LATTICE PANEL;REDWOOD U-TRIM 8'
0143-0022 |  | VINYL LATTICE PANEL;WALNUT 4'x 8' (UNFRAMED)
0143-0024 |  | VINYL LATTICE PANEL;WALNUT H-TRIM 8'
0143-0023 |  | VINYL LATTICE PANEL;WALNUT U-TRIM 8'
0143-0013 |  | VINYL LATTICE PANEL;WHITE 4'x 8' DIA UNFRAME
0143-0015 |  | VINYL LATTICE PANEL;WHITE H-TRIM 8'
0143-0014 |  | VINYL LATTICE PANEL;WHITE U-TRIM 8'
0143-0031 |  | VINYL LATTICE SCREEN;WHITE 32"x 46"
0143-0001 |  | CED LATTICE PANEL;1'x 8' DIA FRAMED
0143-0002 |  | CED LATTICE PANEL;2'x 8' DIA FRAMED
0143-0003 |  | CED LATTICE PANEL;3'x 8' DIA FRAMED
0143-0004 |  | CED LATTICE PANEL;4'x 8' DIA FRAMED
0143-0005 |  | CED LATTICE PANEL;1'x 8' (1X2 SQUARE)
0143-0006 |  | CED LATTICE PANEL;2'x 8' (1x2 SQUARE)
0143-0007 |  | CED LATTICE PANEL;4'x 8' (1X2 SQUARE)
0143-0008 |  | CED LATTICE PANEL;3'x 8' (1X2 SQUARE)
0143-0009 |  | CED LATTICE PANEL;6'x 8' (1X2 SQUARE)
0143-0010 |  | CED LATTICE PANEL;4'x 8' DIA UNFRAMED
0143-0011 |  | CED LATTICE PANEL;1'x 8' DIA UNFRAMED
0143-0012 |  | CED LATTICE PANEL;2'x 8' DIA UNFRAMED
Spreadsheet: 525900d1499001814-countif-function-frequencies
Sheet: Sheet1

 |  |  | AR7 | AR42 | AR43 | AR45 | AR46 | AR36 | AR37 | AR40 | AR51a | AR51b | AR52a | AR15 | AR9 | AR25 | AR20A | AR20B | AR47b | AR1 | AR6 | AR44 | AR10 | AR5 | AR27 | AR35 | AR38 | AR39 | AR41 | [NAME] | AR24 | AR11 | AR12 | AR13 | AR14 | AR16 | AR17 | AR18 | AR31 | AR32 | AR33 | AR49 | AR54 | AR19 | AR22 | AR23 | AR59 | AR57 | AR47 | AR47a | AR48 | AR50 | AR50b
 |  | Frequency
 | Compliant | Not Compliant
01110B10 |  |  | 2016-10-13 00:00:00 | 2016-10-13 00:00:00 | 00:00:00 | 2016-10-26 17:46:42 | 00:00:00 | 00:00:00 | 2017-01-16 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2017-02-22 10:02:09 | 2016-07-26 10:46:35 | 00:00:00 | 00:00:00 | 00:00:00 | 2017-02-24 13:51:49 | 2017-04-03 00:00:00 | 2017-04-03 00:00:00 | 00:00:00 | 00:00:00 | 2016-10-26 16:11:24 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2016-12-02 09:41:08 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2017-06-01 12:56:23 | 2016-06-03 10:17:12 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2017-06-01 00:00:00 | 2017-04-20 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2017-05-09 00:00:00 | 2016-11-08 10:21:25 | 2017-03-13 00:00:00 | 00:00:00
Answer | 14 | 4
Spreadsheet: 166819d1341825449-excel-2007-formula-need-few-tweaks-to-handle-blanks-properly-example
Sheet: Example

 | Exanple : NO  BLANKS |  |  |  |  |  |  | Exanple : BLANKS |  |  |  |  | CORRECT                  EXPECTED RESULTS
 | Contruct Number | Results | Tot | P | L |  |  | Contruct Number | Results | Tot | P | L | P | L
 | 100 | 10000 | 1 |  |  |  |  | 100 |  | 1 |  |  | 0 | 0
 | 100 | -9000 | 1 |  |  |  |  | 100 | -9000 | 1 |  |  | 0 | 1
 | 100 | 10000 | 1 |  |  |  |  | 100 | 10000 | 1 |  |  | 1 | 1
 | 101 | -12000 | 2 |  |  |  |  | 101 | -12000 | 2 |  |  | 1 | 2
 | 102 | 12000 | 3 |  |  |  |  | 102 |  | 3 |  |  | 1 | 2
 | 103 | 11000 | 4 |  |  |  |  | 103 | 11000 | 4 |  |  | 2 | 2
 | 104 | -9000 | 5 |  |  |  |  | 104 | -9000 | 5 |  |  | 2 | 3
 | 105 | 10000 | 6 |  |  |  |  | 105 | 10000 | 6 |  |  | 3 | 3
 | 105 | 10000 | 6 |  |  |  |  | 105 | 10000 | 6 |  |  | 4 | 3
 | 106 | 12000 | 7 |  |  |  |  | 106 | 12000 | 7 |  |  | 5 | 3
 | 107 | -9000 | 8 |  |  |  |  | 107 | -9000 | 8 |  |  | 5 | 4
 | 108 | 10000 | 9 |  |  |  |  | 108 |  | 9 |  |  | 5 | 4
 | 109 | 10000 | 10 |  |  |  |  | 109 | 10000 | 10 |  |  | 6 | 4
 | 110 | 12000 | 11 |  |  |  |  | 110 | 12000 | 11 |  |  | 7 | 4
 | 111 | -12000 | 12 |  |  |  |  | 111 | -12000 | 12 |  |  | 7 | 5
 | 112 | 12000 | 13 |  |  |  |  | 112 | 12000 | 13 |  |  | 8 | 5
 | 113 | 11000 | 14 |  |  |  |  | 113 | 11000 | 14 |  |  | 9 | 5
 | 114 | -9000 | 15 |  |  |  |  | 114 | -9000 | 15 |  |  | 9 | 6
 | 115 | -12000 | 16 |  |  |  |  | 115 | -12000 | 16 |  |  | 9 | 7
 | 116 | 12000 | 17 |  |  |  |  | 116 | 12000 | 17 |  |  | 10 | 7
 | 117 | 11000 | 18 |  |  |  |  | 117 | 11000 | 18 |  |  | 11 | 7
 | 118 | -9000 | 19 |  |  |  |  | 118 | -9000 | 19 |  |  | 11 | 8
 | 119 | -9000 | 20 |  |  |  |  | 119 | -9000 | 20 |  |  | 11 | 9
 | 120 | -9000 | 21 |  |  |  |  | 120 | -9000 | 21 |  |  | 11 | 10
 | 121 | -12000 | 22 |  |  |  |  | 121 | -12000 | 22 |  |  | 11 | 11
 | 122 | 12000 | 23 |  |  |  |  | 122 | 12000 | 23 |  |  | 12 | 11
 | 123 | -12000 | 24 |  |  |  |  | 123 | -12000 | 24 |  |  | 12 | 12
 | 124 | 12000 | 25 |  |  |  |  | 124 | 12000 | 25 |  |  | 13 | 12
 | 125 | -12000 | 26 |  |  |  |  | 125 | -12000 | 26 |  |  | 13 | 13
 | 126 | 12000 | 27 |  |  |  |  | 126 | 12000 | 27 |  |  | 14 | 13
 | 127 | -12000 | 28 |  |  |  |  | 127 | -12000 | 28 |  |  | 14 | 14
 | 128 | 12000 | 29 |  |  |  |  | 128 | 12000 | 29 |  |  | 15 | 14
 | 129 | 12000 | 30 |  |  |  |  | 129 | 12000 | 30 |  |  | 16 | 14
Spreadsheet: 38365d1236531964-frequency-of-associated-numbers-in-a-table-frequency-of-associated-numbers-from-a-table
Sheet: Sheet1

 |  | Frequency Table
 | 1 | 2 | 3 | 4 | 5 | 6 | 7
1 |  | 1 |  |  |  |  | 1 | 1  appears with 2 and 7 once in the data table
2 | 1 |  | 2 | 3 | 1 | 3 | 1 | 2 appears with 1, 5 and 7 once, 3 two times, 4 and 6 three times
3
4 |  |  |  |  |  |  |  | I'm looking for a formula that will calculate the entries in the Frequency Table how many times a number in column A appears with the numbers in row 6, in the Data Table. Not just how many times it appears in the table but how many times the number in column A appears with the numbers in row 6 in each row of the data table.
5
6
7
 |  | Data Table
a | 2 | 7 | 9 | 1 | 46 | 15
b | 23 | 5 | 6 | 9 | 15 | 19
c | 6 | 8 | 11 | 4 | 2 | 5
d | 24 | 23 | 6 | 7 | 55 | 3
e | 2 | 55 | 4 | 67 | 6 | 34
f | 32 | 2 | 56 | 3 | 89 | 7
g | 65 | 72 | 4 | 3 | 2 | 6
Spreadsheet: 682766d1592323981-data-formatting-issue-sample-data
Sheet: Sheet2

[NAME]
 | 2019 |  |  |  | 2020 |  |  |  | 2021
 | Product A | Product B | Product C | Product D | Product A | Product B | Product C | Product D | Product A | Product B | Product C | Product D
India | 100 | 200 | 300 | 400 | 200 | 300 | 400 | 500 | 400 | 500 | 600 | 700
Australia | 101 | 201 | 301 | 401 | 201 | 301 | 401 | 501 | 401 | 501 | 601 | 701
New Zealand | 102 | 202 | 302 | 402 | 202 | 302 | 402 | 502 | 402 | 502 | 602 | 702
England | 103 | 203 | 303 | 403 | 203 | 303 | 403 | 503 | 403 | 503 | 603 | 700
The output should look like this:
Product | Country | Year | Value
Product A | India | 2019 | 100
Product A | Australia | 2019 | 101
Product A | New Zealand | 2019 | 102
Product A | England | 2019 | 103
Product A | India | 2020 | 200
Product A | Australia | 2020 | 201
Product A | New Zealand | 2020 | 202
Product A | England | 2020 | 203
Product A | India | 2021 | 400
Product A | Australia | 2021 | 401
Product A | New Zealand | 2021 | 402
Product A | England | 2021 | 403
Spreadsheet: 139620d1328344130-how-can-i-insert-date-of-today-in-column-c-when-i-enter-data-in-column-b-insert-today-date
Sheet: Sheet1

SN | NameNep | Gender | DateofIssu | NepaliDate | EnglishDate | Signedby
1 | Deepak | #N/A | 2068/10/17 | #N/A | #N/A | 2012-02-03 00:00:00
2 | Sita | #N/A | 2068/10/17 | #N/A | #N/A | 2012-02-03 00:00:00
3 | [NAME] | #N/A | 2068/10/17 | #N/A | #N/A | 2012-02-03 00:00:00
4 | Hari | #N/A | 2068/10/17 | #N/A | #N/A | 2012-02-03 00:00:00
5 | Bina | #N/A | 2068/10/17 | #N/A | #N/A | 2012-02-03 00:00:00
6 | [NAME] | #N/A | 2068/10/18 | #N/A | #N/A | 2012-02-04 00:00:00
7 | [NAME] | #N/A | 2068/10/18 | #N/A | #N/A | 2012-02-04 00:00:00
8 | Ganesh | #N/A | 2068/10/18 | #N/A | #N/A | 2012-02-04 00:00:00
 |  |  | 2008-10-19 00:00:00 |  |  | 1952-02-05 00:00:00
 | When I entered in B column, then I want to insert date of today here.
Spreadsheet: 804378d1668026496-make-purchase-order-with-database-in-excel-po-sample
Sheet: Purchase Order 

 | COMPANY LOGO |  |  |  |  |  | PURCHASE ORDER
 |  |  |  |  |  |  |  |  | P.O. NO. | DATE
 |  |  |  |  |  |  |  |  | 1 | 2022-11-09 00:00:00
 | VENDOR / SUPPLIER'S DETAIL
 | ABC Private Ltd. |  |  |  |  |  |  |  | Requested By | SC PERSON
 | Address: xyz |  |  |  |  |  |  |  | Cost Centre | 8824
 | Tel: | 313164 |  |  |  |  |  |  | M/R Ref. No. | 2254
 | [NAME]: |  |  |  |  |  |  |  | Payment Method | 45 Days
 |  |  |  |  |  |  |  |  | Mode of Payment | Bank Transfer
 | SHIPPING TERMS
 | We are pleased to place order the following items:
 | S.# | Item Description |  | Model | Make | Unit | Qty. | Disc.(%) | Unit Price | Amount
 | 1 | Bolts 6x15 |  | ARK | Local | Nos | 100 | 0.1 | 3.5
 | 2 | Masking Tape |  | EZ | Local | Roll | 2 | 0.1 | 250
 | 3 | 4mm flexible cable |  | Single Core | Pioneer | [NAME] | 50 | 0.1 | 150
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 | Terms & Conditions |  |  |  |  |  | Subtotal (Rs.)
 | Payment shall be 30 days upon receipt of the above items . |  |  |  |  |  | Discount (%) |  | 0
 |  |  |  |  |  |  | Sales Tax (%) |  | 12
 |  |  |  |  |  |  | Other Cost |  |  | 0
 |  |  |  |  |  |  | Shipping & Handling |  |  | 800
 |  |  |  |  |  |  | Total Amount
Spreadsheet: 677956d1589622006-autofill-downwards-in-a-sequential-manner-but-only-where-an-adjacent-cell-has-content-autofill-query
Sheet: Before

ITEM |  | QTY | UNIT | RATE | TOTAL
1 | ITEM 1 - WALL WORKS
 | General Allowance - No Detail
 | General Allowance to fire rate gap between slab edge &_x000D_glazing across L1,2 & 3 in lift lobby | 10 | lm | 300
2 | ITEM 2 - INSTALL FIRE SUPPRESSION SYSTEM
 | New Drencher Service - S & I:
 | Allowance for extension of new drencher service to L1_x000D_& 2 openings extended from mains water service | 1 | Item | 40000
 | Allowance for provision of access equipment & EWP | 1 | Item | 900
 | BWICS - Allowance (TBC):
 | Allowance for patching upto 20lm ceilings | 20 | m | 60
 | Allowance for painting works | 20 | m | 10
3 | ITEM 3 - FIRE ENGINEERING FOR LINK_x000D_BRIDGE OPENINGS
 | New Drencher Service - S & I:
 | Allowance for extension of new drencher service to L1_x000D_& 2 openings extended from mains water service | 1 | Item | 40000
 | Allowance for provision of access equipment & EWP | 1 | Item | 900
 | BWICS - Allowance (TBC):
 | Allowance for patching upto 20lm ceilings | 20 | m | 60
 | Allowance for painting works | 20 | m | 10
4 | ITEM 4 - SMOKE CURTAIN
 | Signage - S & I:
 | Allowance for signage "WARNING -DROPPING FIRE CURTAIN" | 1 | Item | 250
 | Fire Services - Allow to:
 | Site Establishment & Travel | 1 | Item |  | INCL
 | Reposition single smoke detector | 2 | no | 500
 | Ceiling Makegood - Allowance:
 | Allowance to patch & paint Ceilings | 1 | Item | 500
5 | ITEM 5 - INFRARED SMOKE DETECTOR
 | Walls & Ceilings - Allow to:
 | Allowance to open ceiling to enable works | 2 | hrs | 50
 | Install New smoke detector | 3 | m2 | 500
 | Allowance to makegood ceiling area including painting | 1 | Item | 600
6 | ITEM 6 - SLAB IMPROVEMENTS
 | Fire separation between slabs - Allow to:
 | Allowance post-tension survey | 4 | items | 400
 | Specialised Labour allowance. | 16 | hrs | 120
 | Misc Materials | 1 | Item | 150
 | Subtotal
Spreadsheet: 727997d1618243512-need-formula-that-shows-the-total-values-at-the-bottom-of-column-if-they-meet-the-criteria-book1
Sheet: Sheet1

 | [NAME] to Pay
1st | Rent | 770 |  | X |  | X |  | X |  | X |  | X |  | X
6th | Microsoft | 11 |  | X |  | X |  | X |  | X |  |  | X |  | X
11th | Cell Phone | 100 |  | X |  |  | X |  | X |  | X |  | X |  | X
12th | Internet | 18 |  | X |  |  | X |  | X |  | X |  | X |  | X
13th | Student Loan | 200 |  | X |  |  | X |  | X |  | X |  | X |  | X
18th | Amazon | 14 |  |  | X |  | X |  | X |  | X |  | X |  |  | X
18th | Auto Insurance | 254 |  |  | X |  | X |  | X |  | X |  | X |  |  | X
19th | Electric | 90 |  |  | X |  | X |  | X |  | X |  | X |  |  | X
19th | Netflix | 15 |  |  | X |  | X |  | X |  | X |  | X |  |  | X
 | Total |  |  |  |  |  |  |  |  |  |  | 790 |  | 770
Spreadsheet: 820623d1678204851-find-last-occurrence-in-a-table-of-specific-text-book2
Sheet: Sheet1

Date | [NAME] | [NAME] | [NAME] | [NAME] | Adam
2023-01-01 00:00:00 | Job 1 | Job 2 | Job 3 | Job 3 | Job 3 |  |  |  | Job 1
2023-01-02 00:00:00 | Job 1 | Job 2 | Job 3 | Job 3 | Job 1 |  |  |  | Job 2
2023-01-03 00:00:00 | Job 2 | Job 2 | Job 3 | Job 1 | Job 1 |  |  |  | Job 3
2023-01-04 00:00:00 | Job 2 | Job 3 | Job 3 | Job 1 | Job 2 |  |  |  | Job 4
2023-01-05 00:00:00 | Job 2 | Job 3 | Job 1 | Job 2 | Job 2 |  |  |  | Job 5
2023-01-06 00:00:00 | Job 2 | Job 3 | Job 1 | Job 2 | Job 2
2023-01-07 00:00:00 | Job 3 | Job 3 | Job 2 | Job 2 | Job 4
2023-01-08 00:00:00 | Job 3 | Job 1 | Job 2 | Job 4 | Job 4
2023-01-09 00:00:00 | Job 3 | Job 1 | Job 2 | Job 4 | Job 4
2023-01-10 00:00:00 | Job 3 | Job 2 | Job 4 | Job 4 | Job 1
2023-01-11 00:00:00 | Job 1 | Job 2 | Job 4 | Job 1 | Job 5
2023-01-12 00:00:00 | Job 1 | Job 2 | Job 4 | Job 5 | Job 5
2023-01-13 00:00:00 | Job 2 | Job 4 | Job 1 | Job 5 | Job 5
2023-01-14 00:00:00 | Job 2 | Job 4 | Job 1 | Job 5 | Job 2
2023-01-15 00:00:00 | Job 2 | Job 4 | Job 1 | Job 2 | Job 2
Spreadsheet: 44027d1242711120-if-formula-book1
Sheet: Sheet1

 |  |  |  |  |  |  | 0 | 180 | 365 | 545
Stock No | Description | Quantity | Cost Price | Value | Last Purch date | Age as at 31-12-08 | <=180 days | > 180 days <= 365 days | > 365 days <= 545 days | > 545 days
a | xyz | 2 | 10.935 | 21.87 | 1900-01-01 00:00:00 | 39814 | 0 | 0 | 0 | 10.935
b | lmn | 1 | 72.76 | 72.76 | 1900-01-01 00:00:00 | 39814 | 0 | 0 | 0 | 72.76
c | pqr | 10 | 36.45 | 364.5 | 1900-01-01 00:00:00 | 39814 | 0 | 0 | 0 | 36.45
d | thj | 2 | 88.88 | 177.76 | 2007-10-06 00:00:00 | 453 | 0 | 0 | 88.88 | 0
e | klj | 2 | 55.46 | 110.92 | 2007-10-06 00:00:00 | 453 | 0 | 0 | 55.46 | 0
Spreadsheet: darrell_schoolcraft__7316__imball0202
Sheet: Amoco Abo

 | [NAME] |  | Amoco Abo fuel del
Day | Measured | Scheduled | Measured | Scheduled | Imbal
1 |  |  | -218
2 |  |  | -105
3 |  |  | -155
4 |  |  | -323
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
2002-01-31 00:00:00 |  |  |  |  | 152234.63
2002-02-04 00:00:00
CBS Volume
 |  |  | -368359
Spreadsheet: a5db9a61-0e58-4cea-9640-fe07f5758858
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
38917319 | 2013-12-10 16:54:38 | AXIS | 1 | 6 | 5 | 692398 | Morgiliath | 7364 | mediterranean | 1941-11-25 | 1941-11-25 | Dug in at [NAME] | Retranchés à [NAME]
38917465 | 2013-12-10 17:08:47 | ALLIES | 0 | 5 | 6 | 692398 | Morgiliath | 7364 | mediterranean | 1941-11-25 | 1941-11-25 | Dug in at [NAME] | Retranchés à [NAME]
38917965 | 2013-12-10 17:55:13 | ALLIES | 1 | 6 | 3 | 1053769 | player1053769 | 7365 | mediterranean | 1942-06-14 | 1942-06-14 | [NAME] via the Coastal Road | Retraite britannique
38918106 | 2013-12-10 18:05:13 | AXIS | 0 | 4 | 6 | 1053769 | player1053769 | 7365 | mediterranean | 1942-06-14 | 1942-06-14 | [NAME] via the Coastal Road | Retraite britannique
38918241 | 2013-12-10 18:13:51 | ALLIES | 1 | 6 | 0 | 1458183 | vipsd | 7365 | mediterranean | 1942-06-14 | 1942-06-14 | [NAME] via the Coastal Road | Retraite britannique
38918319 | 2013-12-10 18:21:31 | AXIS | 1 | 6 | 1 | 1458183 | vipsd | 7365 | mediterranean | 1942-06-14 | 1942-06-14 | [NAME] via the Coastal Road | Retraite britannique
38918652 | 2013-12-10 18:59:00 | ALLIES | 0 | 3 | 6 | 320854 | [NAME] | 8043 | eastern | 1939-09-08 | 1939-09-26 | Battle of Warsaw | Bataille de Varsovie
38918885 | 2013-12-10 19:16:21 | AXIS | 0 | 4 | 6 | 320854 | [NAME] | 8043 | eastern | 1939-09-08 | 1939-09-26 | Battle of Warsaw | Bataille de Varsovie
38919150 | 2013-12-10 19:29:26 | AXIS | 0 | 4 | 6 | 842950 | [NAME] | 7365 | mediterranean | 1942-06-14 | 1942-06-14 | [NAME] via the Coastal Road | Retraite britannique
38919312 | 2013-12-10 19:42:04 | ALLIES | 0 | 5 | 6 | 842950 | [NAME] | 7365 | mediterranean | 1942-06-14 | 1942-06-14 | [NAME] via the Coastal Road | Retraite britannique
38919727 | 2013-12-10 20:13:24 | AXIS | 1 | 6 | 4 | 969102 | player969102 | 7364 | mediterranean | 1941-11-25 | 1941-11-25 | Dug in at [NAME] | Retranchés à [NAME]
38919917 | 2013-12-10 20:20:00 | ALLIES | 1 | 6 | 1 | 1404437 | escapen_mistaken | 7365 | mediterranean | 1942-06-14 | 1942-06-14 | [NAME] via the Coastal Road | Retraite britannique
38920011 | 2013-12-10 20:38:05 | AXIS | 1 | 6 | 4 | 1415650 | [NAME] | 7364 | mediterranean | 1941-11-25 | 1941-11-25 | Dug in at [NAME] | Retranchés à [NAME]
38920230 | 2013-12-10 20:54:52 | ALLIES | 0 | 2 | 6 | 1415650 | [NAME] | 7364 | mediterranean | 1941-11-25 | 1941-11-25 | Dug in at [NAME] | Retranchés à [NAME]
38920474 | 2013-12-10 21:21:32 | AXIS | 1 | 7 | 6 | 1448307 | K-ami-case | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
38920847 | 2013-12-10 21:42:47 | ALLIES | 0 | 6 | 7 | 1448307 | K-ami-case | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande