tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 543567d1508448089-moving-16-week-average-moving-16-week-average-moving-average-tim201110answer
Sheet: Example

Shift | WeekNum | Average
Day | week 26 | 1.78 |  |  |  |  |  | Night | week 26 | 1.78 |  |  |  |  |  |  | Evening | week 26 | 2.01
 | week 27 | 1.73 |  | Example output |  |  |  |  | week 27 | 1.89 |  |  |  |  |  |  |  | week 27 | 2.06
 | week 28 | 1.75 |  |  |  |  |  |  | week 28 | 1.75 |  |  |  |  |  |  |  | week 28 | 1.99
 | week 29 | 1.76 |  |  |  |  |  |  | week 29 | 1.76 |  |  |  |  |  |  |  | week 29 | 1.66
 | week 30 | 1.745 |  |  |  |  |  |  | week 30 | 1.99 |  |  |  |  |  |  |  | week 30 | 1.99
 | week 31 | 1.78 |  |  |  |  |  |  | week 31 | 1.78 |  |  |  |  |  |  |  | week 31 | 1.76
 | week 32 | 1.73 |  |  |  |  |  |  | week 32 | 1.73 |  |  |  |  |  |  |  | week 32 | 2.01
 | week 33 | 1.75 |  |  |  |  |  |  | week 33 | 1.69 |  |  |  |  |  |  |  | week 33 | 2.06
 | week 34 | 1.76 |  |  |  |  |  |  | week 34 | 1.76 |  |  |  |  |  |  |  | week 34 | 1.99
 | week 35 | 1.745 |  |  |  |  |  |  | week 35 | 1.745 |  |  |  |  |  |  |  | week 35 | 1.66
 | week 36 | 1.78 |  |  |  |  |  |  | week 36 | 1.78 |  |  |  |  |  |  |  | week 36 | 1.99
 | week 37 | 1.73 |  |  |  |  |  |  | week 37 | 1.73 |  |  |  |  |  |  |  | week 37 | 1.76
 | week 38 | 1.75 |  |  |  |  |  |  | week 38 | 1.75 |  |  |  |  |  |  |  | week 38 | 1.75
 | week 39 | 1.76 |  |  |  |  |  |  | week 39 | 1.76 |  |  |  |  |  |  |  | week 39 | 1.76
 | week 40 | 1.745 |  |  |  |  |  |  | week 40 | 1.745 |  |  |  |  |  |  |  | week 40 | 1.745
 | week 41 | 1.701 |  |  |  |  |  |  | week 41 | 1.701 |  |  |  |  |  |  |  | week 41 | 1.701
Spreadsheet: 122269d1316704902-excel-2007-vlookup-question-examplespreadsheet_revised
Sheet: CurrentBal

Name | AcctNbr | CurrentBal
Customer 1 | 123456 | 403.35
Customer 2 | 234567 | 1340.14
Customer 2 | 234568 | -3552.3
Customer 2 | 234569 | 946.12
Customer 3 | 987654 | 3355.63
Customer 3 | 987653 | 2106.43
Customer 3 | 987652 | 495.58
Customer 5 | 111111 | 8388.86
Customer 5 | 111111 | -619.95
Customer 4 | 456789 | 2056.3
Spreadsheet: 788060d1658244405-excel-counting-and-removing-duplicates-count-test-5-
Sheet: Results

 | Results |  | Total
 | Unit | Count |  |  | Total count excluding duplicate
Spreadsheet: 832987d1686717849-extract-string-left-of-first-special-character-book4
Sheet: Host - Items Configured

Sl. # | Host ID | Item Names | Key | Monitoring Category
 | 10524 | Zabbix stats cluster | zabbix[cluster,discovery,nodes]
 | 10531 | CPU utilization | system.cpu.util
 | 10531 | Memory utilization | vm.memory.utilization
 | 10531 | Network interface discovery | net.if.discovery
 | 10531 | Block devices discovery | vfs.dev.discovery
 | 10531 | Interface {#IFNAME}: Inbound packets discarded | net.if.in["{#IFNAME}",dropped]
 | 10532 | Host name of Zabbix agent running | agent.hostname
 | 10532 | System boot time | system.boottime
 | 10533 | CPU utilization | system.cpu.util
 | 10533 | Memory utilization | vm.memory.utilization
 | 10533 | Network interface discovery | net.if.discovery
 | 10533 | Block devices discovery | vfs.dev.discovery
 | 10533 | Mounted filesystem discovery | vfs.fs.discovery
 | 10543 | /usr/local/c9dasdata02: Used space | vfs.fs.size[/usr/local/c9dasdata02,used]
 | 10551 | systemd-networkd-wait-online.service: Get unit info | systemd.unit.get["systemd-networkd-wait-online.service"]
 | 10551 | systemd-networkd-wait-online.service: Active time | systemd.service.uptime["systemd-networkd-wait-online.service"]
 | 10551 | systemd-networkd-wait-online.service: Unit file state | systemd.service.unitfile_state["systemd-networkd-wait-online.service"]
 | 10551 | systemd-networkd-wait-online.service: Load state | systemd.service.load_state["systemd-networkd-wait-online.service"]
 | 10551 | systemd-networkd-wait-online.service: Active state | systemd.service.active_state["systemd-networkd-wait-online.service"]
 | 10784 | System-{#SNMPINDEX}: Temperature sensor condition | sensor.temp.condition[cpqHeTemperatureCondition.System.{#SNMPINDEX}]
Spreadsheet: 96253d1295646580-conditional-formatting-with-color-scales-entire-row-example
Sheet: Sheet1

Date | Client | Volume | Notional
2011-01-21 00:00:00 | CLIENT 1 | 50000000 | 454785211.25
2011-01-21 00:00:00 | CLIENT 2 | 40000000 | 141791552.5
2011-01-21 00:00:00 | CLIENT 3 | 30000000 | 224429212.5
2011-01-21 00:00:00 | CLIENT 4 | 20000000 | 171710975
2011-01-21 00:00:00 | CLIENT 5 | 10000000 | 154737858.4825
2011-01-21 00:00:00 | CLIENT 6 | 9000000 | 120949118.475
2011-01-21 00:00:00 | CLIENT 7 | 8000000 | 99211017.2225
2011-01-21 00:00:00 | CLIENT 8 | 7000000 | 104375871.2
2011-01-21 00:00:00 | CLIENT 9 | 6000000 | 45378856.5
2011-01-21 00:00:00 | CLIENT 10 | 5000000 | 22989768
2011-01-21 00:00:00 | CLIENT 11 | 4000000 | 45980229.86
2011-01-21 00:00:00 | CLIENT 12 | 3000000 | 52339837.475
2011-01-21 00:00:00 | CLIENT 13 | 2000000 | 34746091.93
2011-01-21 00:00:00 | CLIENT 14 | 1000000 | 28724285.25
2011-01-21 00:00:00 | CLIENT 15 | 0 | 18245007.25
2011-01-21 00:00:00 | CLIENT 16 | -1000000 | 20183288.5
2011-01-21 00:00:00 | CLIENT 17 | -2000000 | 20490204.6225
2011-01-21 00:00:00 | CLIENT 18 | -3000000 | 22551374.25
2011-01-21 00:00:00 | CLIENT 19 | -4000000 | 30166842.75
2011-01-21 00:00:00 | CLIENT 20 | -5000000 | 6961249.1025
2011-01-21 00:00:00 | CLIENT 21 | -6000000 | 3342386.94
2011-01-21 00:00:00 | CLIENT 22 | -7000000 | 4022306
2011-01-21 00:00:00 | CLIENT 23 | -8000000 | 127297.5
Spreadsheet: 797653d1664025844-conditional-format-lowest-number-in-a-range-but-some-numbers-divided-by-2-conditional-format-bikes
Sheet: Sheet1

cumulative stock
 |  | jan | feb | [NAME] | apr | may | jun
 | frames | 2 | 2 | 3 | 5 | 7 | 9
2 per bike | wheels | 3 | 4 | 7 | 8 | 12 | 18
 | chains | 2 | 3 | 3 | 4 | 5 | 9
total bikes |  | 1 | 2 | 3 | 4 | 5 | 9
Spreadsheet: 783552d1654898491-deposits-into-respective-month-closest-match-with-multiple-criteria-dynamic-array-dynamic-array-assign-numbers-to-its-appropriate-date-array-with-closest-match-with-multiple-cr
Sheet: Sheet1

Time of Report Date |  | 2022-03-31 00:00:00
North | 1st Deposit | 2nd Deposit | 3rd Deposit |  | South | 1st Deposit | 2nd Deposit | 3rd Deposit |  | East | 1st Deposit | 2nd Deposit | 3rd Deposit |  | West | 1st Deposit | 2nd Deposit | 3rd Deposit
2020-06-01 00:00:00 | 5000 | 15000 | 20000 |  | 2020-06-01 00:00:00 | 5000 | 10000 | 10000 |  | 2021-05-01 00:00:00 | 5000 | 15000 | 20000 |  | 2020-05-01 00:00:00 | 5000 | 10000 | 10000
 |  |  |  |  |  |  |  |  |  | 2021-08-01 00:00:00 | 5000 | 30000 | 40000 |  | 2021-08-01 00:00:00 | 5000 | 15000 | 25000
Region | Sub ID | Sale Date | Total Deposits to Collect | Deposits Collected |  |  | 2022-05-31 00:00:00 | 2022-06-30 00:00:00 | 2022-07-31 00:00:00 | 2022-08-31 00:00:00 | 2022-09-30 00:00:00 | 2022-10-31 00:00:00 | 2022-11-30 00:00:00 | 2022-12-31 00:00:00
 | A | 2020-05-15 00:00:00 | 40000 | 40000 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | return 0 across all date range, since [Deposits Collected] is the Greater Than or Equal To [Total Deposits to Collect] (although [Sale Date] is lesser than 2020-06-01 effective date range A4 to D4)
North | B | 2020-12-10 00:00:00 | 40000 | 5000 |  | 15000 | 20000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | should return 1st column (Apr 2022) and 2nd column (May 2022) on 2nd and 3rd deposit respectively on the 2020-06-01 effective date range (A4 to D4)
South | A | 2022-08-05 00:00:00 | 25000 | 0 |  | 0 | 0 | 0 | 0 | 5000 | 10000 | 10000 | 0 | 0 | should return on it's respective 3 columns starting on Aug 2022 to Oct 2022 on 1st, 2nd and 3rd deposit respectively on the 2020-06-01 effective date range (F4 to I4)
South | B | 2020-10-20 00:00:00 | 25000 | 30000 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | return 0 across all date range, since [Deposits Collected] is the Greater Than or Equal To [Total Deposits to Collect]
East | A | 2021-07-31 00:00:00 | 40000 | 0 |  | 5000 | 15000 | 20000 | 0 | 0 | 0 | 0 | 0 | 0 | should return 1st column (Apr 2022) , 2nd column (May 2022) and 3rd column (Jun 2022) on 1st, 2nd and 3rd deposit respectively on the 2021-05-01 effective date range (K4 to N4)
East | B | 2021-08-01 00:00:00 | 75000 | 35000 |  | 40000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | should return 1st column (Apr 2022) on 3rd deposit on the 2021-08-01 effective date range (K5 to N5)
West | A | 2020-11-04 00:00:00 | 40000 | 39800 |  | double check |  |  |  |  |  |  |  |  | should return "double check" on 1st column (Apr 2022) since remainder deposits does not match any deposits structure on 2020-05-01 effective date range (P4 to S4)
West | B | 2020-01-01 00:00:00 | 25000 | 5000 |  | #N/A |  |  |  |  |  |  |  |  | return N/A on 1st column (Apr 2022) because [Sale Date] is lesser than the MINIMUM 2020-05-01 effective date (P4 to S4)
Spreadsheet: 821771d1678892986-return-most-common-text-in-column-but-add-an-if-formula-help
Sheet: Sheet1

Basket # | Fruit |  | Most Common Fruit:
1 | Apple |  | [NAME]
2 | Pear
3 | Orange
4 | [NAME]
5 | Apple
6 | Apple
7
8
9
10
11
12
13
Spreadsheet: 782842d1654327539-referencing-to-a-cell-in-another-sheet-by-plugging-in-a-ref-in-the-same-sheet-help-with-formula
Sheet: Hoja2

 |  |  | bring values from page #1
 | row # |  | name | Feature 1 | Feature 2 | Feature 3 | Feature 4
group#1 | 2
 | 4
Spreadsheet: 53679d1253615890-vlookup-formula-with-date-string-vlookuptotaltest
Sheet: Data

2008-07-01 00:00:00 | 10000
2008-07-02 00:00:00 | 10001
2008-07-03 00:00:00 | 10002
2008-07-04 00:00:00 | 10003
2008-07-05 00:00:00 | 10004
2008-07-06 00:00:00 | 10005
2008-07-07 00:00:00 | 10006
2008-07-08 00:00:00 | 10007
2008-07-09 00:00:00 | 10008
2008-07-10 00:00:00 | 10009
2008-07-11 00:00:00 | 10010
2008-07-12 00:00:00 | 10011
2008-07-13 00:00:00 | 10012
2008-07-14 00:00:00 | 10013
Spreadsheet: 884946d1734346954-formula-timeline-help-if-and-f-1-b2-f-1-c2-1-0-dashboard-timeline
Sheet: query (6)

Status | WP ID | Work Package Name | Work Package Owner | Project Manager | Work Package Support | Dependency on another project | Start Date | Baseline End Date | Current End Date
 |  | Test 1
 |  | Test 2
 |  | Test 3
 |  | Test 4 |  |  |  |  | 2024-12-02 00:00:00 | 2025-03-28 00:00:00
 |  | Test 5 |  |  |  |  | 2024-12-02 00:00:00 | 2025-04-30 00:00:00
 |  | Test 6 |  |  |  |  | 2024-12-02 00:00:00 | 2025-01-31 00:00:00
 |  | Test 7 |  |  |  |  | 2025-05-01 00:00:00 | 2025-10-31 00:00:00
 |  | Test 8 |  |  |  |  | 2024-12-02 00:00:00 | 2025-01-31 00:00:00
 |  | Test 9 |  |  |  |  | 2024-12-02 00:00:00 | 2025-01-31 00:00:00
 |  | Test 10
 |  | Test 11 |  |  |  |  | 2024-12-02 00:00:00 | 2025-01-31 00:00:00
 |  | Test 12
 |  | Test 13 |  |  |  |  | 2024-12-02 00:00:00 | 2025-06-27 00:00:00
 |  | Test 14 |  |  |  |  | 2024-12-02 00:00:00 | 2024-12-31 00:00:00
 |  | Test 15 |  |  |  |  | 2024-12-02 00:00:00 | 2026-01-01 00:00:00
 |  | Test 16 |  |  |  |  | 2025-06-02 00:00:00 | 2025-06-30 00:00:00
 |  | Test 17 |  |  |  |  | 2024-12-02 00:00:00 | 2025-06-30 00:00:00
 |  | Test 18
 |  | Test 19
 |  | Test 20
 |  | Test 21 |  |  |  |  | 2024-12-02 00:00:00 | 2025-12-31 00:00:00
 |  | Test 22 |  |  |  |  | 2024-12-02 00:00:00 | 2025-01-31 00:00:00
 |  | Test 23 |  |  |  |  | 2024-12-02 00:00:00 | 2025-02-28 00:00:00
 |  | Test 24 |  |  |  |  | 2025-04-01 00:00:00 | 2025-05-30 00:00:00
 |  | Test 25 |  |  |  |  | 2025-04-01 00:00:00 | 2025-07-31 00:00:00
 |  | Test 26
 |  | Test 27 |  |  |  |  | 2025-03-02 00:00:00 | 2025-10-31 00:00:00
 |  | Test 28 |  |  |  |  | 2025-03-03 00:00:00 | 2025-12-31 00:00:00
 |  | Test 29
 |  | Test 30
 |  | Test 31
 |  | Test 32 |  |  |  |  | 2024-12-02 00:00:00 | 2025-03-28 00:00:00
 |  | Test 33 |  |  |  |  | 2024-12-02 00:00:00 | 2025-01-31 00:00:00
 |  | Test 34 |  |  |  |  | 2024-12-02 00:00:00 | 2025-12-31 00:00:00
 |  | Test 35 |  |  |  |  | 2024-12-02 00:00:00 | 2024-12-27 00:00:00
 |  | Test 36 |  |  |  |  | 2025-04-01 00:00:00 | 2025-12-31 00:00:00
Spreadsheet: 217725d1362159909-help-with-match-or-vlookup-function-please-help-1-
Sheet: Sheet4

 | Values
Row Labels | Sum of points | Sum of qualified
a | 45 | 1
b | 454 | 1
c | 454 | 1
d | 5465 | 1
e | 676 | 0
f | 33 | 0
g | 34 | 0
h | 4 | 0
i | 34 | 0
(blank)
Grand Total | 7199 | 4
Spreadsheet: 088df199-2264-4324-bc9e-fa7b8f7b3a3c
Sheet: Sheet1

Combined Bidder Activity Summary Report - May 2013  (Projects bid opened from July 2011 to May 2013, as of 06/05/2013)
Bid Month-YR | Engineer's Estimate | [NAME] | Low Bid vs. EE | Avg. Number of Bidders | Number of Projects Bid Opened | No. of  Projects Under 10% of EE | No. of Projects in ±10% of EE | No. of Projects Over 10% of EE | No. of Projects Within 110% of EE | Percent of  Projects Within ±10% of EE
2011-07-15 00:00:00 | 20365047.05 | 21732970.35 |  | 4.538461538461538 | 13 | 4 | 4 | 5
2011-08-11 00:00:00 | 50010372.81 | 43611191.31 |  | 5 | 21 | 12 | 6 | 3
2011-09-11 00:00:00 | 166458271.63 | 138598077.46 |  | 6.047619047619047 | 21 | 10 | 8 | 3
2011-10-11 00:00:00 | 219152331.31 | 179743459.68 |  | 6.842105263157895 | 38 | 23 | 10 | 5
2011-11-11 00:00:00 | 507700888.35 | 412641487.18 |  | 6.617647058823529 | 34 | 17 | 14 | 3
2011-12-11 00:00:00 | 628320975.9200001 | 552787816.56 |  | 6.461538461538462 | 26 | 14 | 4 | 8
2012-01-12 00:00:00 | 221129881.74 | 184092542.87 |  | 6.90625 | 32 | 13 | 14 | 5
2012-02-12 00:00:00 | 331587021.28 | 245894057.94 |  | 7.319148936170213 | 47 | 22 | 20 | 5
Mar-12 | 276250184.97 | 237008591.52 |  | 6.863636363636363 | 66 | 35 | 24 | 7
2012-04-12 00:00:00 | 264959292.74 | 218489949.23 |  | 5.392857142857143 | 84 | 41 | 33 | 10
May-12 | 219373727.52 | 211766315.17 |  | 5.223404255319149 | 94 | 46 | 34 | 14
2012-06-12 00:00:00 | 106973675.14 | 97462593.67 |  | 6.133333333333334 | 15 | 6 | 5 | 4
Jul 11 to Jun 12
Jul-12 | 324344704.51 | 282565669.1 |  | 5.571428571428571 | 28 | 15 | 9 | 4
Aug-12 | 376864727.33 | 330869927.37 |  | 5.8 | 25 | 14 | 7 | 4
Sep-12 | 510608479.65 | 462439555.66 |  | 5.882352941176471 | 34 | 17 | 16 | 1
Oct-12 | 785008092.5600001 | 706904634.4399998 |  | 5.659090909090909 | 44 | 15 | 21 | 8
*Nov-12 | 205996003.5 | 183958134.77 |  | 6.1 | 31 | 14 | 14 | 3
2012-12-12 00:00:00 | 94032650.61 | 87269637.62 |  | 7.5 | 20 | 7 | 10 | 3
2013-01-13 00:00:00 | 115138540.42 | 105448137.6 |  | 8.1875 | 32 | 15 | 12 | 5
2013-02-13 00:00:00 | 65311825.09 | 62882211.9 |  | 7.513513514 | 37 | 9 | 24 | 4
*Mar-13 | 87355042.32 | 81149458.74 |  | 6.431818182 | 44 | 17 | 22 | 5
*Apr-13 | 125529925.65 | 121961842.06 |  | 5.40789 | 75 | 25 | 36 | 14
2013-05-01 00:00:00 | 160064609.47 | 158571799.49 |  | 5.5 | 62 | 22 | 29 | 11
Jul 12 to April 13
Total
Note: 1) "*", numbers may be different from that in the previous report due to bid rank change(s); 2) Rejected projects are not included in calculations.
Spreadsheet: 870302d1716841036-can-anyone-tell-what-mistake-i-am-doing-in-my-formulas-given-in-the-sample-file-sample-file
Sheet: Table 27

JOB FAMILY BASED TRAINING PROGRAMS
JOB FAMILIES AS PER IC 34/2024 | CATEGORY MAPPING
Corporate Banking | Credit
Retail & MSME Credit | Credit
Agriculture Finance & Financial Inclusion | Credit
Finance & Accounts | Credit
Recovery, NPA management & Credit Monitoring | Credit Monitoring
Strategy & Analytics | Digital
Information Technology | Digital
Digital, FinTech & Payments | Digital
Treasury & Forex | Forex
Resources | FTBM, Customer Relationship Management
Customer Relationship, Sales & Marketing | HR
Human Resources | HR
Operations | Internal Control
Mandatory programs | PPT, CDP, MDP, ODP, Induction
Risk, Compliance & Inspection | Risk Compliance and Internal Control
Spreadsheet: 157426d1337722784-array-formula-to-filter-a-results-set-only-matches-first-value-in-the-array-customer-list-filtering-example-guru-modified-by-tigeravatar-v2-
Sheet: Test Data

KEY | EU Business Name | Purch Mkt Base Product Name | EU Last Name | EU First Name | EU Title | EU Address 1 | EU Address 2 | EU Address 3 | EU City | EU State Province | EU Postal Cd | EU Country ISO Cd | EU Email Address | EU Business Phone | EU Business Phone
 | ABC Corp
 | ABC Corp |  |  | The formula in A2 is an array formula confirmed by CTRL-SHIFT-ENTER
 | ABC Corp |  |  | then the cell is copied down.
 | ABC Corp
 | ABC Corp
 | ABC Corp
 | ABC Corp
 | ABC Corp
 | ABC Corp
 | ABC Corp
 | BCE Inc
 | BCE Inc
 | BCE Inc
 | BCE Inc
 | BCE Inc
 | BCE Inc
 | BCE Inc
 | BCE Inc
 | BCE Inc
 | BCE Inc
 | CDE Ltd
 | CDE Ltd
 | CDE Ltd
 | CDE Ltd
 | CDE Ltd
 | CDE Ltd
 | CDE Ltd
 | CDE Ltd
 | DEF Co.
 | DEF Co.
 | DEF Co.
 | DEF Co.
 | DEF Co.
 | DEF Co.
 | DEF Co.
 | DEF Co.
 | EFG
 | EFG
 | EFG
 | EFG
 | EFG
 | EFG
 | EFG
 | EFG
 | EFG
 | EFG
 | EFG
 | EFG
 | EFG
 | EFG
Spreadsheet: 21566d1209200551-sum-function-every-nth-row-test
Sheet: Sheet1

1 | 24 |  |  |  |  |  |  |  |  | 1 | 24 |  | 24 | 103
 | 2 |  |  |  |  |  |  |  |  |  | 2 |  | 0
 | 5 |  |  |  |  |  |  |  |  |  | 5 |  | 0
 | 3 |  |  |  |  |  |  |  |  |  | 3 |  | 0
 | 5 |  | so every 10th row I have a critical number that I want summed |  |  |  |  |  |  |  | 5 |  | 0
 | 3 |  | I can do it manually by adding another row as shown on right |  |  |  |  |  |  |  | 3 |  | 0
 | 2 |  | can it be done automatically by excel somehow? |  |  |  |  |  |  |  | 2 |  | 0
 | 6 |  | or even utilizing the 1's I have on the left |  |  |  |  |  |  |  | 6 |  | 0
 | 6 |  | so…even though I know this doesn’t work, but… |  |  |  |  |  |  |  | 6 |  | 0
 | 5 |  | if(Ax=1,add Bx to running summation,don't) |  |  |  |  |  |  |  | 5 |  | 0
1 | 34 |  |  |  |  |  |  |  |  | 1 | 34 |  | 34
 | 2 |  |  |  |  |  |  |  |  |  | 2 |  | 0
 | 6 |  |  |  |  |  |  |  |  |  | 6 |  | 0
 | 4 |  |  |  |  |  |  |  |  |  | 4 |  | 0
 | 3 |  |  |  |  |  |  |  |  |  | 3 |  | 0
 | 6 |  |  |  |  |  |  |  |  |  | 6 |  | 0
 | 7 |  |  |  |  |  |  |  |  |  | 7 |  | 0
 | 4 |  |  |  |  |  |  |  |  |  | 4 |  | 0
 | 7 |  |  |  |  |  |  |  |  |  | 7 |  | 0
 | 3 |  |  |  |  |  |  |  |  |  | 3 |  | 0
1 | 45 |  |  |  |  |  |  |  |  | 1 | 45 |  | 45
 | 8 |  |  |  |  |  |  |  |  |  | 8 |  | 0
 | 5 |  |  |  |  |  |  |  |  |  | 5 |  | 0
 | 5 |  |  |  |  |  |  |  |  |  | 5 |  | 0
 | 7 |  |  |  |  |  |  |  |  |  | 7 |  | 0
 | 3 |  |  |  |  |  |  |  |  |  | 3 |  | 0
 | 7 |  |  |  |  |  |  |  |  |  | 7 |  | 0
 | 3 |  |  |  |  |  |  |  |  |  | 3 |  | 0
 | 4 |  |  |  |  |  |  |  |  |  | 4 |  | 0
 | 3 |  |  |  |  |  |  |  |  |  | 3 |  | 0
 | 7 |  |  |  |  |  |  |  |  |  | 7 |  | 0
Spreadsheet: 137149d1326979363-offset-until-find-the-first-nonblank-cell-example
Sheet: Sheet1

Product | Container | Value
abc | name1 | 37
 | [NAME] | 36
 | name3 | 59
[NAME] | name4 | 87
 | name5 | 92
 | name6 | 5
 | name7 | 8
 | name8 | 16
 | name9 | 90
 | name10 | 5
gzh | name11 | 52
 | name12 | 78
 | name13 | 36
 | name14 | 1
 | [NAME] | 32
 | [NAME] | 12
 | name17 | 14
aaa | name18 | 71
 | name19 | 74
 | name20 | 33
 | [NAME] | 93
 | name22 | 18
 | name23 | 36
 | name24 | 93
bpz | name25 | 21
 | [NAME] | 3
 | name27 | 84
 | name28 | 17
 | name29 | 31
Spreadsheet: 270102d1381381396-count-values-between-dates-and-multiple-criteria-ecompassanalytics_3
Sheet: Sheet1

 |  |  |  |  | Week of | 2013-09-01 00:00:00 | 2013-09-08 00:00:00 | 2013-09-15 00:00:00 | 2013-09-22 00:00:00 | 2013-09-29 00:00:00 | 2013-10-06 00:00:00 | 2013-10-13 00:00:00 | 2013-10-20 00:00:00 | 2013-10-27 00:00:00 | 2013-11-03 00:00:00 | 2013-11-10 00:00:00 | 2013-11-17 00:00:00 | 2013-11-24 00:00:00
 |  |  |  |  | Week End | 2013-09-07 00:00:00 | 2013-09-14 00:00:00 | 2013-09-21 00:00:00 | 2013-09-28 00:00:00 | 2013-10-05 00:00:00 | 2013-10-12 00:00:00 | 2013-10-19 00:00:00 | 2013-10-26 00:00:00 | 2013-11-02 00:00:00 | 2013-11-09 00:00:00 | 2013-11-16 00:00:00 | 2013-11-23 00:00:00 | 2013-11-30 00:00:00
 |  |  |  |  | New Cases Assigned in the week
 |  |  |  |  | Cases closed in the week
 |  |  |  |  | EOW Cases Opened
Spreadsheet: robin_rodrigue__33250__Portfolio
Sheet: Sheet4

FT-CAND-PWR-PRC | #N/A
FT-HPLC-IDX | #N/A
FT-IM-ENOV-IDX | #N/A
FT-INT-CNT-TRAN-IDX | #N/A
FT-INT-CNT-TRAN-PRC | #N/A
FT-TP-HPL-PRC | #N/A
GAS-APEA PREPAY-IDX | #N/A
GAS-APEA PREPAY-PRC | #N/A
GAS-CHA-MAH-IDX | #N/A
GAS-CHA-MAH-PRC | #N/A
GAS-CHASE9-IDX | #N/A
INTRA-DENVER-IDX | #N/A
INTRA-ENOV-BAS | #N/A
INTRA-ENOV-IDX | #N/A
INTRA-ENOV-PRC | #N/A
Spreadsheet: 793263d1661369014-formula-that-subtract-from-available-stock-and-leaving-the-balance-formula-left-stock
Sheet: Sheet1

Item | On Order | On Hand Inv
123 | 10
123 | 5 |  |  | This needs to subtrack the 10, so the balance now is 40, and so on
123 | 10 |  |  | This needs to subtrack the 5, so the balance now is 35, and so on
123 | 10
126 | 10 |  |  | Here Different part number
126 | 5
126 | 5
 |  |  |  | We have a vlookup formula on C that brings the On Hand for the 123 Item. The [NAME] repeasts it self couple of times due the orders Open. Need to have the balance left on the same column taking into consideration that the Item could change
 |  |  |  | As you can see on my example.
 |  |  |  | Need a forumula, that sumifs the other sheet, bring the On Hand, then subtracts from the first order to see what is left On hand.
 |  |  |  | But if the [NAME] change, it brings the next Oh Hand.
Spreadsheet: 795778d1662932075-running-through-the-table-for-unique-security-code-and-date-security-code
Sheet: Sheet1

 | ID | Date | Security Code | Quantity |  |  |  |  | ID | Date | Security Code | Quantity
 | QTP11245 | 2022-09-11 00:00:00 | 6037569 | 800 |  |  |  |  | QTP11245 | 2022-09-11 00:00:00 | 6037569 | 800
 | QTP11245 | 2022-09-10 00:00:00 | 6037569 | 801 |  |  |  |  | QTP11245 | 2022-09-10 00:00:00 | 6037569 | 801
 | QTP11245 | 2022-09-12 00:00:00 | 6543346 | 9090 |  |  |  |  | QTP11245 | 2022-09-12 00:00:00 | 6543346 | 9090
 | QTP11245 | 2022-09-11 00:00:00 | 6543346 | 9090 |  |  |  |  | QTP11245 | 2022-09-11 00:00:00 | 6543346 | 9090
 | QTP11245 | 2022-09-12 00:00:00 | 7690043 | 9090 |  |  |  |  | QTP11245 | 2022-09-12 00:00:00 | 7690043 | 9090
 | QTP11246 | 2022-09-10 00:00:00 | 6672318 | 5567 |  |  |  |  | QTP11246 | 2022-09-10 00:00:00 | 6672318 | 5567
 | QTP11246 | 2022-09-08 00:00:00 | 6672318 | 5560 |  |  |  |  | QTP11246 | 2022-09-08 00:00:00 | 6672318 | 5560
 | QTP11247 | 2022-09-10 00:00:00 | 9802351 | 45776 |  |  |  |  | QTP11247 | 2022-09-10 00:00:00 | 9802351 | 45776
 | QTP11248 | 2022-09-12 00:00:00 | 1264988 | 12 |  |  |  |  | QTP11248 | 2022-09-12 00:00:00 | 1264988 | 12
 | QTP11248 | 2022-09-11 00:00:00 | 1264988 | 13 |  |  |  |  | QTP11248 | 2022-09-11 00:00:00 | 1264988 | 13
 | QTP11248 | 2022-09-12 00:00:00 | 4567209 | 100 |  |  |  |  | QTP11248 | 2022-09-12 00:00:00 | 4567209 | 100
 | QTP11248 | 2022-09-11 00:00:00 | 4567209 | 100 |  |  |  |  | QTP11248 | 2022-09-11 00:00:00 | 4567209 | 100
 | QTP11248 | 2022-09-10 00:00:00 | 4567209 | 100 |  |  |  |  | QTP11248 | 2022-09-10 00:00:00 | 4567209 | 100
 | QTP11249 | 2022-09-09 00:00:00 | 4567209 | 100 |  |  |  |  | QTP11249 | 2022-09-09 00:00:00 | 4567209 | 100
Spreadsheet: 172986d1344402282-identify-gaps-in-dates-within-a-range-excel-book-10
Sheet: Sheet1

Name | Start | End | Comments
Belden | 2010-01-12 00:00:00 | 2011-01-11 00:00:00
[NAME] | 2010-05-12 00:00:00 | 2011-05-11 00:00:00
[NAME] | 2011-07-07 00:00:00 | 2012-07-06 00:00:00 | Gap in coverage
[NAME] | 2012-07-05 00:00:00 | 2013-07-04 00:00:00
Belden | 2011-01-12 00:00:00 | 2012-01-11 00:00:00
Belden | 2012-01-19 00:00:00 | 2013-01-18 00:00:00 | Gap in coverage
[NAME] | 2009-05-12 00:00:00 | 2010-05-11 00:00:00
Spreadsheet: 775668d1649250895-adding-hours-to-date-and-time-stamp-target-sample-060422
Sheet: Sheet2

Priority | Response | Task Priority | Hours
A | Emergency, response time to be 4 hour |  | 4
B | Priority, response time to be 24 hours |  | 24
C | Normal, work to be commenced within 7 days |  | 168
D | Non-urgent, work to be commenced within 28 days |  | 672