tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: kate_symes__18305__MeadMktplace (2)
Sheet: MeadMktplace

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME]
 | 2001-04-17 00:00:00 |  | 227.36 | 848 | 96.06 | 2904
 | 2001-04-16 00:00:00 |  | 221.9 | 336 | 121.2 | 768 | 133.03 | 1144 | 80.72 | 1323
 | 2001-04-15 00:00:00 |  | 225 | 800 | 80 | 1200 | 60.05 | 2368 | 44.12 | 1494
 | 2001-04-14 00:00:00 |  | 153.98 | 2736 | 79.16 | 1808 | 101.54 | 2179 | 71.44 | 1068
 | 2001-04-13 00:00:00 |  | 153.98 | 2736 | 79.16 | 1808 | 118.59 | 2350 | 92.08 | 1386
 | 2001-04-12 00:00:00 |  | 163.9 | 4464 | 96.03 | 2832 | 121.22 | 2500 | 98.14 | 1742
 | 2001-04-11 00:00:00 |  | 186.25 | 640 | 102.5 | 400 | 146.66 | 1921 | 101.73 | 1672
 | 2001-04-10 00:00:00 |  | 189.32 | 1184 | 98.94 | 1440 | 146.67 | 2390 | 93.48 | 1552
 | 2001-04-09 00:00:00 |  | 126.46 | 2896 | 105.72 | 1264 | 122.88 | 1015 | 86.46 | 925
 | 2001-04-08 00:00:00 |  | 130 | 0 | 98 | 0 | 97.91 | 2833 | 87.85 | 1659
 | 2001-04-07 00:00:00 |  | 183.6 | 2576 | 92.82 | 1704 | 114.42 | 1980 | 114.75 | 800
 | 2001-04-06 00:00:00 |  | 183.6 | 2576 | 92.93 | 1680 | 147.71 | 1463 | 91.2 | 1429
 | 2001-04-05 00:00:00 |  | 200.55 | 5984 | 102.44 | 2408 | 127.14 | 2549 | 98.45 | 1862
 | 2001-04-04 00:00:00 |  | 199.23 | 4384 | 103.75 | 2232 | 148.64 | 1692 | 81.66 | 1580
 | 2001-04-03 00:00:00 |  | 188.58 | 4064 | 116.57 | 1632 | 117.12 | 1130 | 85.69 | 262
 | 2001-04-02 00:00:00 |  | 238.59 | 1024 | 150.88 | 912 | 137.01 | 2361 | 111.15 | 1000
 | 2001-04-01 00:00:00 |  | 180 | 800 | 107 | 600 | 148.11 | 1110 | 121.38 | 1200
 | 2001-03-31 00:00:00 |  | 154.62 | 624 | 95.02 | 1832 | 208.73 | 2005 | 132.05 | 925
 | 2001-03-30 00:00:00 |  | 154.62 | 624 | 94.91 | 1832 | 157.25 | 2240 | 118.11 | 1415
 | 2001-03-29 00:00:00 |  | 150.35 | 1824 | 96.1 | 1672 | 134.29 | 2045 | 98.07 | 1330
 | 2001-03-28 00:00:00 |  | 133.2 | 3328 | 74.97 | 1544 | 115.44 | 1399 | 82.09 | 1685
 | 2001-03-27 00:00:00 |  | 105.94 | 1104 | 69.87 | 1232 | 119.31 | 1428 | 71.55 | 1817
 | 2001-03-26 00:00:00 |  | 278.99 | 1104 | 158.37 | 712 | 121.58 | 1216 | 59.09 | 901
 | 2001-03-25 00:00:00 |  | 195 | 0 | 150 | 0 | 83.27 | 1706 | 57.7 | 1655
 | 2001-03-24 00:00:00 |  | 240.51 | 624 | 143.75 | 880 | 122.71 | 3765 | 146.16 | 2205
 | 2001-03-23 00:00:00 |  | 240.51 | 624 | 143.75 | 880 | 212.95 | 3035 | 164.51 | 1676
 | 2001-03-22 00:00:00 |  | 282.93 | 464 | 175.42 | 2032 | 299.77 | 1910 | 211.67 | 1390
 | 2001-03-21 00:00:00 |  | 353.67 | 1024 | 220.45 | 880 | 351.62 | 4153 | 259.99 | 1589
 | 2001-03-20 00:00:00 |  | 323.59 | 624 | 221.88 | 1600 | 281.92 | 1957 | 245.43 | 1616
 | 2001-03-19 00:00:00 |  | 291.72 | 1024 | 197.04 | 1272 | 197.2 | 635 | 225 | 20
 | 2001-03-18 00:00:00 |  | 220 | 0 | 182.5 | 0 | 149.33 | 1225 | 119.19 | 980
Spreadsheet: 842081d1694152963-percentage-reference-from-column-to-row-one-sheet-to-another-sheet-book1
Sheet: Sales Payment plan

SAMANA MYKONOS PAYMENT PLAN
PROPERTY DETAILS:
Type : |  | Apartment No :
Total Area : SQ FT |  | Total Price in
 |  | Original Price
Payment Plans/Terms
Description | Date | % of Payment
Down Payment - Installment 1 | 2023-02-21 00:00:00 | 0.2 |  | 100
Installment 2 | 2023-03-21 00:00:00 | 0.01
Installment 3 | 2023-04-21 00:00:00 | 0.01
Installment 4 | 2023-05-21 00:00:00 | 0.01
Installment 5 | 2023-06-21 00:00:00 | 0.01
Installment 6 | 2023-07-21 00:00:00 | 0.01
Installment 7 | 2023-08-20 00:00:00 | 0.1
Installment 8 | 2023-08-21 00:00:00 | 0.01
Installment 9 | 2023-09-21 00:00:00 | 0.01
Installment 10 | 2023-10-21 00:00:00 | 0.01
Installment 11 | 2023-11-21 00:00:00 | 0.01
Installment 12 | 2023-12-21 00:00:00 | 0.01
Installment 13 | 2024-01-21 00:00:00 | 0.01
Installment 14 | 2024-02-16 00:00:00 | 0.04
Installment 15 | 2024-02-21 00:00:00 | 0.01
Installment 16 | 2024-03-21 00:00:00 | 0.01
Installment 17 | 2024-04-21 00:00:00 | 0.01
Installment 18 | 2024-05-21 00:00:00 | 0.01
Installment 19 | 2024-06-21 00:00:00 | 0.01
Installment 20 | 2024-07-21 00:00:00 | 0.01
Installment 21 | 2024-08-14 00:00:00 | 0.1
Installment 22 | 2024-08-21 00:00:00 | 0.01
Installment 23 | 2024-09-21 00:00:00 | 0.01
Installment 24 | 2024-10-21 00:00:00 | 0.01
Installment 25 | 2024-11-21 00:00:00 | 0.01
Installment 26 | 2024-12-21 00:00:00 | 0.01
Installment 27 | 2025-01-21 00:00:00 | 0.01
Installment 28 | 2025-02-21 00:00:00 | 0.01
Installment 29 | 2025-03-21 00:00:00 | 0.01
Installment 30 | 2025-04-21 00:00:00 | 0.01
Installment 31 | 2025-05-21 00:00:00 | 0.01
Installment 32 | 2025-06-21 00:00:00 | 0.01
Installment 33 | 2025-07-21 00:00:00 | 0.01
Installment 34 | 2025-08-21 00:00:00 | 0.01
Installment 35 | 2025-09-21 00:00:00 | 0.01
Installment 36 | 2025-10-21 00:00:00 | 0.01
Installment 37 | 2025-11-21 00:00:00 | 0.01
Installment 38 | 2025-12-21 00:00:00 | 0.01
Installment 39 | 2026-01-21 00:00:00 | 0.01
Installment 40 | 2026-02-21 00:00:00 | 0.01
Installment 41 | 2026-03-21 00:00:00 | 0.01
Installment 42 | 2026-04-21 00:00:00 | 0.01
Installment 43 | 2026-05-21 00:00:00 | 0.01
Installment 44 | 2026-06-21 00:00:00 | 0.01
Installment 45 | 2026-07-21 00:00:00 | 0.01
Installment 46 | 2026-08-21 00:00:00 | 0.01
Installment 47 | 2026-09-21 00:00:00 | 0.01
Installment 48 | 2026-10-21 00:00:00 | 0.01
Installment 49 | 2026-11-21 00:00:00 | 0.01
Installment 50 | 2026-12-21 00:00:00 | 0.01
Installment 51 | 2027-01-21 00:00:00 | 0.01
Installment 52 | 2027-02-21 00:00:00 | 0.01
Installment 53 | 2027-03-21 00:00:00 | 0.01
Installment 54 | 2027-04-21 00:00:00 | 0.01
Installment 55 | 2027-05-21 00:00:00 | 0.01
Installment 56 | 2027-06-21 00:00:00 | 0.01
Installment 57 | 2027-07-21 00:00:00 | 0.01
Installment 58 | 2027-08-21 00:00:00 | 0.01
Installment 59 | 2027-09-21 00:00:00 | 0.01
Installment 60 | 2027-10-21 00:00:00 | 0.01
 | GRAND TOTAL
Spreadsheet: 490034d1479592162-how-to-make-dropdownt-list-of-unique-items-dependent-on-another-dropdown-list-shops-and-items
Sheet: List1

 |  |  |  |  |  | Shop | Item |  |  |  |  |  | Filtered list 1
 |  |  |  |  |  | Kaufland | glue |  | Shop | [NAME] |  |  | Kaufland
 |  |  |  |  |  | [NAME] | glue |  | Item |  |  |  | [NAME]
 |  |  |  |  |  | [NAME] | scissors |  |  |  |  |  | Tesco
 |  |  |  |  |  | Tesco | pencil |  |  |  |  |  | Kaufland
 |  |  |  |  |  | Kaufland | ruler |  |  |  |  |  | Billa
 |  |  |  |  |  | Billa | scissors
 |  |  |  |  |  | Kaufland | paper
 |  |  |  |  |  | Tesco | ruler
 |  |  |  |  |  | Billa | glue
 |  |  |  |  |  | Billa | rubber
 |  |  |  |  |  | [NAME] | rubber
 |  |  |  |  |  | Kaufland | string
 |  |  |  |  |  | Billa | ink
 |  |  |  |  |  | Tesco | brush
 |  |  |  |  |  | [NAME] | string
 |  |  |  |  |  | Tesco | pencil
 |  |  |  |  |  | [NAME] | glue
 |  |  |  |  |  | Billa | ink
 |  |  |  |  |  | Kaufland | ruler
Spreadsheet: 681139d1591367972-excel-lock-value-once-calculated-book1
Sheet: Sheet3

 |  |  |  |  |  | USER LIST | COLOUM No. | AMOUNT
 |  |  |  |  |  | ALEX | D9 | 1500
USER | D1 | D2 | D3 | D4 | D5 | D6 | D7 | D8 | D9 | D10 | D11 | D12 | D13 | D14 | D15 | D16 | D17 | D18 | [NAME] | D20 | D21 | D22 | D23 | [NAME] | D25 | D26 | D27 | D28 | D29 | D30 | [NAME]
ALEX
FRANK
DONNY
HUBBY
LOVLY
SONY
LG
NICK
JONAS
HULLQ
LOUI
VITTONS
MARQ
 |  | I want to fix the value of S14 in above function. For each time I select path (cell=H2) and user name (Cell=G2) the result will be save as respectivly ???
Spreadsheet: 836614d1689527616-need-help-with-populating-priority-matrix-matrix-4-
Sheet: Matrix

Importance/Criticality | 1.1 | HIGH
 | 2.1 | MEDIUM
 | 3.1 | LOW
 |  |  | LOW | MEDIUM | HIGH
 |  |  | 3.8 | 2.8 | 1.8
 |  |  | Urgency
Spreadsheet: 749925d1633098371-conditional-formatting-how-to-color-other-columns-cf-format-two-columns-aligw
Sheet: Sheet1

Next 30 Day | Most Recent 30 Day |  |  |  | Report Date | 2021-09-15 00:00:00
2021-09-29 00:00:00
2021-10-10 00:00:00
2021-09-07 00:00:00
2021-10-01 00:00:00
2021-10-03 00:00:00
2021-09-16 00:00:00
2021-09-17 00:00:00 | 2021-09-03 00:00:00
2021-09-08 00:00:00
2021-09-25 00:00:00
2021-09-10 00:00:00
2021-09-29 00:00:00
2021-10-11 00:00:00 | 2021-09-03 00:00:00
2021-07-29 00:00:00 | 2021-08-30 00:00:00
Spreadsheet: 069e9432-6128-49ac-9493-5b885932c03e
Sheet: Essex&Genesis

 |  |  |  |  |  |  | 2013 Essex & Genesis F.E.
 | January |  |  |  |  |  | February |  |  |  |  |  | March
 | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr
 |  | 1 | 2 | 3 | 4 |  |  |  |  |  | 1 |  |  |  |  |  | 1
 | 7 | 8 | 9 | 10 | 11 |  | 4 | 5 | 6 | 7 | 8 |  | 4 | 5 | 6 | 7 | 8
 | 14 | 15 | 16 | 17 | 18 |  | 11 | 12 | 13 | 14 | 15 |  | 11 | 12 | 13 | 14 | 15
 | 21 | 22 | 23 | 24 | 25 |  | 18 | 19 | 20 | 21 | 22 |  | 18 | 19 | 20 | 21 | 22
 | 28 | 29 | 30 | 31 |  |  | 25 | 26 | 27 | 28 |  |  | 25 | 26 | 27 | 28 | 29
 | April |  |  |  |  |  | May |  |  |  |  |  | June
 | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr
 | 1 | 2 | 3 | 4 | 5 |  |  |  | 1 | 2 | 3
 | 8 | 9 | 10 | 11 | 12 |  | 6 | 7 | 8 | 9 | 10 |  | 3 | 4 | 5 | 6 | 7
 | 15 | 16 | 17 | 18 | 19 |  | 13 | 14 | 15 | 16 | 17 |  | 10 | 11 | 12 | 13 | 14
 | 22 | 23 | 24 | 25 | 26 |  | 20 | 21 | 22 | 23 | 24 |  | 17 | 18 | 19 | 20 | 21
 | 29 | 30 |  |  |  |  | 27 | 28 | 29 | 30 | 31 |  | 24 | 25 | 26 | 27 | 28
 | July |  |  |  |  |  | August |  |  |  |  |  | September
 | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr
 | 1 | 2 | 3 | 4 | 5 |  |  |  |  | 1 | 2 |  | 2 | 3 | 4 | 5 | 6
 | 8 | 9 | 10 | 11 | 12 |  | 5 | 6 | 7 | 8 | 9 |  | 9 | 10 | 11 | 12 | 13
 | 15 | 16 | 17 | 18 | 19 |  | 12 | 13 | 14 | 15 | 16 |  | 16 | 17 | 18 | 19 | 20
 | 22 | 23 | 24 | 25 | 26 |  | 19 | 20 | 21 | 22 | 23 |  | 23 | 24 | 25 | 26 | 27
 | 29 | 30 | 31 |  |  |  | 26 | 27 | 28 | 29 | 30 |  | 30
 | October |  |  |  |  |  | November |  |  |  |  |  | December
 | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr
 |  | 1 | 2 | 3 | 4 |  |  |  |  |  | 1 |  | 2 | 3 | 4 | 5 | 6
 | 7 | 8 | 9 | 10 | 11 |  | 4 | 5 | 6 | 7 | 8 |  | 9 | 10 | 11 | 12 | 13
 | 14 | 15 | 16 | 17 | 18 |  | 11 | 12 | 13 | 14 | 15 |  | 16 | 17 | 18 | 19 | 20
 | 21 | 22 | 23 | 24 | 25 |  | 18 | 19 | 20 | 21 | 22 |  | 23 | 24 | 25 | 26 | 27
 | 28 | 29 | 30 | 31 |  |  | 25 | 26 | 27 | 28 | 29 |  | 30 | 31
 | 2nd & 4th Fridays.  [NAME] is subject to change.  Call CPFB with questions [PHONE]. Thank you.
 |  |  | Holiday closures. |  |  |  |  | Deliveries. |  |  |  | Inventory - warehouse closures.
Spreadsheet: 28555d1222872920-automatic-decimal-format-control-dynamicrounding2
Sheet: Sheet1

 | s | 1.456 | 7.46 |  |  |  | nametable
 |  |  |  |  |  |  | q | 3
 |  |  |  |  |  |  | w | 2
 |  |  |  |  |  |  | e | 1
 |  |  |  |  |  |  | r | 0
 |  |  |  |  |  |  | m | 3
 |  |  |  |  |  |  | s | 2
 |  |  |  |  |  |  | t | 0
 |  |  |  |  |  |  | f | 1
Spreadsheet: 735488d1623030936-traffic-sign-for-kpi-book1
Sheet: Report

 | Financial Report (Yearly) |  |  |  |  | 2011
 | ABC. Inc
 | Key Performance Indicators
 | Net Income |  | Muncipal Tax |  | Service Charge |  | Other Exp |  | Income Tax |  |  |  | Net Profit
 | All Indicators
 | KPIs |  |  |  |  |  | % CHANGE
 | Net Income
 | Muncipal Tax |  | t should be red | `
 | SERvice Chrg
 | Other Exp
 | Income Tax
 | Net Profit
Spreadsheet: 858987d1707470155-excel-formula-split-over-time-periods
Sheet: Sheet1

From | To | Break | Hours | 00:00 to 18:00 | 18:00 to 20:00 | 20:00 to 24:00 | 24:00 to 00:00 | Total | Check
 |  | 00:30:00
 |  | 00:30:00
 |  | 00:30:00
 |  | 00:30:00
 |  | 00:30:00
 |  | 00:30:00
 |  | 00:30:00
 |  | 00:30:00
 |  | 00:30:00
 |  | 00:30:00
 |  | 00:30:00
 |  | 00:30:00
 |  | 00:30:00
 |  | 00:30:00
 |  | 00:30:00
 |  | 00:30:00
 |  | 00:30:00
 |  | 00:30:00
 |  | 00:30:00
 |  | 00:30:00
 |  | 00:30:00
 |  | 00:30:00
 |  | 00:30:00
https://www.excelforum.com/excel-formulas-and-functions/1419338-excel-formula.html
Spreadsheet: 34385d1231608569-matching-name-then-adding-daddy_sum
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Amount Won
[NAME] | 152 | √ | 189 | √ | 180 | √ | 169 | √ | 178 | √ | 168 | √ |  |  |  |  |  |  |  |  |  |  |  |  | 35 | 0
[NAME] |  |  |  |  |  |  | 140 | √ | 188 | √ | 206 | √ | 181 | √ | 132 | √ | 214 | √ | 175 | √ | 215 | √ | 144 | √ | 40 | 40
[NAME] |  |  |  |  |  |  | 170 | √ | 156 | √ | 143 | √ | 170 | √ | 180 | √ | 171 | √ | 164 | √ | 134 | √ | 145 | √ | 0 | 0
Gayle | 209 | √ | 156 | √ | 155 | √ | 176 | √ | 157 | √ | 175 | √ | 201 | √ | 185 | √ | 226 | √ | 156 | √ | 175 | √ | 167 | √ | 0 | 0
George |  |  |  |  |  |  |  |  |  |  |  |  | 183 | √ | 212 | √ | 173 | √ | 212 | √ | 194 | √ | 223 | √ | 80 | 0
Ian T | 216 | √ | 177 | √ | 170 | √ | 220 | √ | 188 | √ | 158 | √ | 224 | √ | 207 | √ | 269 | √ | 199 | √ | 221 | √ | 196 | √ | 160 | 160
Ian |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 146 | √ | 162 | √ | 182 | √ | 0 | 0
[NAME] | 165 | √ | 153 | √ | 173 | √ |  |  |  |  |  |  | 213 | √ | 145 | √ | 184 | √ |  |  |  |  |  |  | 0 | 0
[NAME] | 239 | √ | 182 | √ | 184 | √ | 198 | √ | 163 | √ | 201 | √ | 140 | √ | 146 | √ | 149 | √ | 171 | √ | 175 | √ | 185 | √ | 35 | 35
[NAME] | 212 | √ | 165 | √ | 170 | √ | 170 | √ | 193 | √ | 154 | √ | 194 | √ | 237 | √ | 203 | √ | 196 | √ | 182 | √ | 201 | √ | 80 | 40
[NAME] | 178 | √ | 168 | √ | 201 | √ | 208 | √ | 158 | √ | 166 | √ |  |  |  |  |  |  |  |  |  |  |  |  | 35 | 0
 | [NAME] |  |  |  | 239 | 35 | Ian T |  |  |  | 220 | 40 | Ian T |  |  |  | 224 | 40 | George |  |  |  | 212 | 40
 | [NAME] |  |  |  | 189 | 35 | [NAME] |  |  |  | 193 | 40 | [NAME] |  |  |  | 237 | 40 | Ian T |  |  |  | 221 | 40
 | [NAME] |  |  |  | 201 | 35 | [NAME] |  |  |  | 206 | 40 | Ian T |  |  |  | 269 | 40 | George |  |  |  | 223 | 40
Spreadsheet: 819115d1677226091-calculate-difference-between-2-datetimes-in-hours-excluding-weekends-and-holidays-working-hours-assignment-1-
Sheet: Sheet1

Requested | Solved | Hours Difference | In decimal |  | Holidays |  | Shift Start Time | Shift End Time |  | Working Days |  |  | full hours |  |  | minus from 1st date | minus from 2nd date | Total |  | Full formula (Without helper columns)
2022-08-01 14:54:00 | 2022-09-02 17:13:00 |  |  |  | 2022-08-27 00:00:00 |  | 10:00:00 | 19:00:00 |  | Monday to Friday
2022-08-19 09:43:00 | 2022-09-15 22:02:00 |  |  |  | 2022-08-25 00:00:00
2022-08-19 17:34:00 | 2022-09-01 15:06:00
2022-08-23 14:48:00 | 2022-08-31 17:03:00
2022-08-23 19:52:00 | 2022-09-15 22:01:00
2022-08-24 04:46:00 | 2022-09-14 22:45:00
2022-08-24 17:02:00 | 2022-09-02 17:31:00
2022-08-25 22:19:00 | 2022-08-30 13:21:00
2022-08-26 22:36:00 | 2022-08-31 16:23:00 |  |  |  |  |  |  | FOR EXPLANATION
2022-08-26 23:46:00 | 2022-08-31 14:23:00
2022-08-27 01:22:00 | 2022-08-29 22:02:00
2022-08-27 01:28:00 | 2022-08-30 20:48:00
2022-08-27 01:31:00 | 2022-08-29 22:02:00
2022-08-27 01:34:00 | 2022-08-29 22:03:00
2022-08-27 01:38:00 | 2022-08-29 18:57:00
2023-02-20 20:54:00 | 2023-02-21 10:53:00
2022-12-27 01:56:00 | 2023-01-01 00:00:00
2022-12-27 12:57:00 | 2022-12-28 20:30:00
2022-12-27 15:17:00 | 2022-12-27 18:38:00
2022-12-27 20:05:00 | 2022-12-28 13:14:00
2022-12-27 20:17:00 | 2022-12-28 14:46:00
2022-12-28 00:20:00 | 2022-12-28 13:24:00
2022-12-28 18:47:00 | 2022-12-28 19:13:00
2022-12-28 21:33:00 | 2022-12-28 21:56:00
2022-12-28 22:04:00 | 2022-12-28 22:12:00
 |  |  |  |  |  |  |  |  |  |  | New requested date at 0:00 | New solved date at 0:00 | #hours (full) | time of requested date | time of solved date | Adjustment for requested date | Adjustment for solved date | Total hours
 |  |  |  |  |  |  | I have 2 columns, one is for Requested and another is for Requested (column A) and another is for Solved (Column B). I want difference between solved and requested column in hours. Below are the conditions to calculate this. 1) [NAME] should exclude Saturday & Sundays as those are non-working days for us. 2) [NAME] should exclude Holiday list as shown in column F. 3) [NAME] should consider shift timing as working day instead of default 24 hours. 4) Shift timing can change anytime so that I puted it differently in cell H1 & I1 respectivly.
Spreadsheet: 285587d1387734845-automatic-worksheets-submission-log
Sheet: Questionnare

To be Seen |  |  |  |  | To Be Hidden
SCA Name: |  |  |  |  | Type |  | Kingdom
Legal Name: |  |  |  |  | Pick One |  | Pick One
Address: |  |  |  |  | Name |  | [NAME]
City, State, Zip |  |  |  |  | Device |  | An Tir
 |  |  |  |  | Name & Device |  | Ansteorra
Kingdom | Pick One |  |  |  | Badge |  | Artemisia
Branch Name |  |  |  |  |  |  | Atenveldt
Phone Number |  |  |  |  |  |  | Atlantia
E-mail Address |  |  |  |  |  |  | Caid
Date of Birth |  |  |  |  |  |  | Calontir
 |  |  |  |  |  |  | [NAME]
Consulting Herald |  |  |  |  |  |  | Ealdormere
Herald's E-mail/Phone |  |  |  |  |  |  | East
 |  |  |  |  |  |  | [NAME]
Type of Submission: | Pick One |  |  |  |  |  | Lochac
 |  |  |  |  |  |  | Meridies
 |  |  |  |  |  |  | Middle
 |  |  |  |  |  |  | Northshield
 |  |  |  |  |  |  | Outlands
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | West
Spreadsheet: 822358d1679303624-formula-index-and-match-pontaj-2023-draft
Sheet: APRILIE

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date to Find | 2023-03-19 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Found in
 |  | DATE | 2023-04-01 00:00:00
 |  | NORM |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Row Number
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TODAY
 | Nr. [NAME]. | ID | Name |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NORM HOURS | WORK HOURS | SCREEN HOURS | WEEK HOURS | NIGHT HOURS | CO | CM |  |  | S | P | Z | N | H
 | 1 | 111 | Jhon | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S
 | 2 | 112 | [NAME] | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H
 | 3 | 113 | Adalyn | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N
 | 4 | 114 | [NAME] | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z
 | 5 | 115 | Beverly | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P
Spreadsheet: 101457d1299589593-help-needed-for-advanced-transposing-transpose
Sheet: input

 |  |  |  |  | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00
no1 | grp1 | tech1 | business1 | name1 | 1 | 2 | 3
[NAME] | grp1 | tech2 | business1 | name1 | 4 | 5 | 6
no3 | [NAME] | tech1 | [NAME] | [NAME] | 7 | 8 | 9
no4 | grp3 | tech1 | business1 | name3 | 10 | 11 | 12
no5 | grp4 | [NAME] | [NAME] | name4 | 13 | 14 | 15
Spreadsheet: 823391d1679940336-call-function-of-a-total-column-test3
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | Store: |  |  |  |  |  |  |  |  |  |  | page: |  |  |  | 1 / 1
 | Date: 04.03.2023
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Customers (Tickets) |  |  |  | Check average
 |  | Type |  |  |  | Description |  |  |  |  |  |  | Gross |  |  |  | Net
 |  | 1 |  |  |  | Counter
 |  |  |  |  |  |  | In House |  |  |  |  |  |  | 1 |  |  |  | 1 |  |  | 1 |  |  |  | 1
 |  |  |  |  |  |  | Take Away |  |  |  |  |  |  | 1 |  |  |  | 1 |  |  | 1 |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  | 1 |  |  | 1 |  |  |  | 1
 |  | 2 |  |  |  | Drive
 |  |  |  |  |  |  | In House |  |  |  |  |  |  | 1 |  |  |  | 1 |  |  | 1 |  |  |  | 1
 |  |  |  |  |  |  | Drive |  |  |  |  |  |  | 1 |  |  |  | 1 |  |  | 1 |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  | 1 |  |  | 1 |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  | 2 |  |  | 1 |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Customers (Tickets) |  |  |  | Check average
 |  | Type |  |  |  | Description |  |  |  |  |  |  | Gross |  |  |  | Net
 |  | 0 |  |  |  | In House |  |  |  |  |  |  | 1 |  |  |  | 1 |  |  | 1 |  |  |  | 1
 |  | 1 |  |  |  | Take Away |  |  |  |  |  |  | 1 |  |  |  | 1 |  |  | 1 |  |  |  | 1
 |  | 2 |  |  |  | Drive |  |  |  |  |  |  | 1 |  |  |  | 1 |  |  | 1 |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  |  |  | 1 |  |  | 1 |  |  |  | 1
 |  |  |  |  |  |  |  | 544 / 3
Spreadsheet: 490aa0de-da18-4d9b-84e5-4e58411634a7
Sheet: Sheet1

analytica 2012 - Aussteller Liste | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Suche über Produkt- und Dienstleistungsverzeichnis (5 [NAME]):
 | 5 Labortechnische Geräte 5.4 Labortechnik und Laboreinrichtung 5.4.3 Pumpen, Förder- und Verbindungstechnik 5.4.3.13 Vakuumventile
Nr. | Firma | Land | Ort | PLZ | Halle/Stand
1 | Bürkert GmbH & Co. [NAME] | Deutschland | Ingelfingen | 74653 | A1.304
2 | FESTO AG & Co.KG | Deutschland | Esslingen | 73734 | B1.305
3 | Fluid Automation Systems s.a. | [NAME] | [NAME] | 1290 | A2.417
4 | [NAME] | Deutschland | Köln | 50968 | B1.310
5 | Pfeiffer Vacuum GmbH | Deutschland | Asslar | 35614 | A1.103
Spreadsheet: 141026d1329042524-sum-of-data-from-consecutive-nonconsecutive-dates-example2
Sheet: Sheet2

Date | Score | Con/non-c | Date | Score | Con/non-c |  |  | Con | Non-con | Total
2011-12-27 00:00:00 | 106 | Non-con | 2011-12-28 00:00:00 | 101 | Con |  | Count: | 7 | 16 | 23
2011-12-31 00:00:00 | 84 | Con | 2011-12-30 00:00:00 | 105 | Non-con |  | Sum of Score: | 702 | 1509 | 2211
2012-01-02 00:00:00 | 100 | Non-con | 2012-01-05 00:00:00 | 109 | Non-con
2012-01-03 00:00:00 | 74 | Con | 2012-01-07 00:00:00 | 109 | Con
2012-01-06 00:00:00 | 102 | Con | 2012-01-12 00:00:00 | 111 | Con
2012-01-09 00:00:00 | 106 | Non-con | 2012-01-14 00:00:00 | 93 | Non-con
2012-01-11 00:00:00 | 84 | Non-con | 2012-01-16 00:00:00 | 93 | Non-con
2012-01-20 00:00:00 | 76 | Non-con | 2012-01-18 00:00:00 | 92 | Non-con
2012-01-25 00:00:00 | 97 | Non-con | 2012-01-21 00:00:00 | 121 | Con
2012-01-27 00:00:00 | 83 | Non-con | 2012-02-02 00:00:00 | 77 | Non-con
2012-01-29 00:00:00 | 107 | Non-con | 2012-02-04 00:00:00 | 87 | Non-con
2012-01-31 00:00:00 | 94 | Non-con
Spreadsheet: mary_fischer__25614__32J
Sheet: E11.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
ANALYSIS OF OTHER CURRENT LIABILITIES
FOR THE 3 MONTHS ENDED 3-31-2000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-11
 |  | 12-31-00 Balance
 |  | BEGINNING |  | OTHER |  | 03-31-2001 |  | OTHER |  | 06-30-2001 |  | OTHER |  | 09-30-2001 |  | OTHER |  | 12-31-2001
[NAME] |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE
 |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.)
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Total Other Current Liabilities
(must tie to Hyperion account 655) | * |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *
Income Accts:  DR/(CR)
Reverse signs from Hyperion