tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 78664d1279017135-sumproduct-average-test-3-
Sheet: Sheet2

 | Location | Data
 | 1 |  | 2 |  | 3 |  | 4 |  | Total Sum of Payment | Total Average of Payment2
Department | Sum of Payment | Average of Payment2 | Sum of Payment | Average of Payment2 | Sum of Payment | Average of Payment2 | Sum of Payment | Average of Payment2
Finance |  |  | 658 | 658 |  |  |  |  | 658 | 658
HR | 193 | 96.5 |  |  | 123 | 123 |  |  | 316 | 105.3333333333333
IT |  |  | 923 | 461.5 |  |  |  |  | 923 | 461.5
Ops |  |  |  |  |  |  | 102 | 102 | 102 | 102
Grand Total | 193 | 96.5 | 1581 | 527 | 123 | 123 | 102 | 102 | 1999 | 285.5714285714286
Spreadsheet: 760733d1640438651-sum-based-on-criteria-sum-based-on-criteria
Sheet: Sheet1

Employee Name | Emp Code | Month | Description | Amount [USD] | Amount [SAR]
A | 7423 | 2021-11-30 00:00:00 | Hotel Charges | 200 | 750.8
A | 7423 | 2021-11-30 00:00:00 | Airfare Charges | 100 | 375.4
B | 7843 | 2021-11-30 00:00:00 | [NAME] | 3000 | 11250
Total  Hotel Charges |  |  |  | 200
Total  Airfare Charges |  |  |  | 100
Total  Salary Advance |  |  |  | 3000
Spreadsheet: 130494d1322373296-how-to-import-data-from-multiple-worksheets-to-a-single-worksheet-cost-calculation-matrix_combine
Sheet: Electric

 |  |  |  | - Electrical Tests -
Date: | 0
Author: | 0
 | Location : | 1.AQL Wuhu |  | 2.AQL Shanghai |  | 3.Intertek |  | [NAME] |  | 5.ADT |  | 6.AQL Cheongwon |  | 7.Huizhou
 | Type of Lab : | - Electric Test - |  | - Electric Test - |  | - Electric Test - |  | - Electric Test - |  | - Electric Test - |  | - Electric Test - |  | - Electric Test -
 |  | Test available  [yes/no] | Hour rate [Rmb/h]/DUT | Test available  [yes/no] | Hour rate [Rmb/h]/DUT | Test available  [yes/no] | Hour rate [Rmb/h]/DUT | Test available  [yes/no] | Hour rate [Rmb/h]/DUT | Test available  [yes/no] | Hour rate [Rmb/h]/DUT | Test available  [yes/no] | Hour rate [Rmb/h]/DUT | Test available  [yes/no] | Hour rate [Rmb/h]/DUT
Electrical | DC Supply Voltage | yes | 111 | no | not avail. | yes | 270 | yes | 250 | yes | 250 | yes | project-specific | yes | tbd
 | Overvoltage | yes | 111 | no | not avail. | yes | 150 | yes | 250 | yes | 250 | yes | project-specific | yes | tbd
 | [NAME] | yes | 442 | no | not avail. | yes | 255 | yes | 250 | yes | 250 | yes | project-specific | yes | tbd
 | Superimposed alternating voltage | yes | 442 | no | not avail. | yes | 450 | no | not avail. | yes | 250 | yes | project-specific | yes | tbd
 | Slow decrease and increase of supply voltage | yes | 442 | no | not avail. | yes | 255 | yes | 250 | yes | 250 | yes | project-specific | yes | tbd
 | Reversed voltage | yes | 111 | no | not avail. | yes | 255 | yes | 250 | yes | 250 | yes | project-specific | yes | tbd
 | Starting profile | yes | 442 | no | not avail. | yes | 425 | no | not avail. | yes | 250 | yes | project-specific | yes | tbd
 | Load Dump | no | not avail. | no | not avail. | no | not avail. | no | not avail. | yes | 250 | yes | project-specific | yes | tbd
 | Short circuit protection Signal circuits | yes | 111 | no | not avail. | yes | 280 | yes | 250 | yes | 250 | no | not avail. | yes | tbd
 | Short circuit protection Load circuits | yes | 111 | no | not avail. | yes | 280 | yes | 250 | yes | 250 | no | not avail. | yes | tbd
 | Open circuit tests / single line interruption | yes | 111 | no | not avail. | yes | 255 | yes | 250 | yes | 250 | no | not avail. | yes | tbd
 | Open circuit tests / multiple line interruption | yes | 111 | no | not avail. | yes | 255 | yes | 250 | yes | 250 | no | not avail. | yes | tbd
 | Ground reference and supply offsets | yes | 111 | no | not avail. | yes | 450 | yes | 250 | yes | 250 | no | not avail. | yes | tbd
 | Reset behaviour at voltage drop | yes | 442 | no | not avail. | yes | 425 | yes | 250 | yes | 250 | yes | project-specific | yes | tbd
 | [NAME] drop in supply voltage | yes | 442 | no | not avail. | yes | 450 | yes | 250 | yes | 250 | yes | project-specific | yes | tbd
 | Withstand voltage | no | not avail. | no | not avail. | yes | 450 | yes | 250 | yes | 250 | yes | project-specific | yes | tbd
 | Insulation resistance | no | not avail. | no | not avail. | yes | 450 | yes | 250 | yes | 400 | yes | project-specific | yes | tbd
Spreadsheet: 770004d1645778582-naming-manager-duplication-causing-issues-help-version-24th-feb
Sheet: Bretonnia

 | RACE | Bretonnia |  |  | Total Pts |  |  |  |  |  | ARMY NAME
 | CHARACTERS
 | Unit/s |  |  | Points | Unit size | M | WS | BS | S | T | W | I | A | LD | Default Equipment | Weapons | Pts | Weapons | Pts | [NAME] | Pts | [NAME] | Pts | Mount | Pts | Magic Items | Pts | Misc/Notes | Pts | Gear Total | Total Pts
 | General |  |  |  | 1
 | [NAME] |  |  |  | 1
Spreadsheet: 862102d1709871882-populate-new-or-dropped-data-excel1
Sheet: Sheet1

Table 1 |  |  |  |  |  | Table 2
Month | Product ID | Product Name | Branch Name |  |  | Month | Product ID | Product Name | Branch Name | Status
Dec | 123456 | Product1 | Branch 1 |  |  | Jan | 123460 | Product5 | Branch 5 | [NAME]
Dec | 123457 | Product2 | Branch 2 |  |  | Jan | 123456 | Product1 | Branch 1 | [NAME]
Dec | 123458 | Product3 | Branch 3 |  |  | Jan | 123461 | Product6 | Branch 5 | New
Dec | 123459 | Product4 | Branch 4 |  |  | Feb | 123462 | Product7 | Branch 5 | New
Dec | 123460 | Product5 | Branch 5 |  |  | Mar | 123462 | Product8 | Branch 5 | New
Jan | 123457 | Product2 | Branch 2 |  |  | Apr | 123457 | Product2 | Branch 2 | [NAME]
Jan | 123458 | Product3 | Branch 3
Jan | 123459 | Product4 | Branch 4
Jan | 123461 | Product6 | Branch 5
Feb | 123457 | Product2 | Branch 2
Feb | 123458 | Product3 | Branch 3
Feb | 123459 | Product4 | Branch 4
Feb | 123462 | Product7 | Branch 5
Mar | 123457 | Product2 | Branch 2
Mar | 123458 | Product3 | Branch 3
Mar | 123459 | Product4 | Branch 4
Mar | 123462 | Product7 | Branch 5
Mar | 123462 | Product8 | Branch 5
Apr | 123458 | Product3 | Branch 3
Apr | 123459 | Product4 | Branch 4
Apr | 123462 | Product7 | Branch 5
Apr | 123462 | Product8 | Branch 5
Spreadsheet: 871854d1718252235-summate-count-by-month-summate-average-by-month-ignoring-if-incomplete-data-excel-help-forum-date-lookup-summation-count-and-average
Sheet: Mock Raw Data

Date | Overall Outcome (words are created using calculated formula which looks at numerical values) | start score | finish score | Change score (calculate
2024-02-01 00:00:00 | better | 0.16 | 0.66
2024-02-25 00:00:00 | Unchanged | 0.5 | 0.88
2024-02-12 00:00:00 | better | 0.26 | 0.9
2024-03-02 00:00:00 | worse | 0.46 | 0.58
2024-03-11 00:00:00 | better | 0.45 | 0.77
2024-03-23 00:00:00 | Unchanged | 0.77 | 0.76
2024-03-28 00:00:00 | worse | 0.1 | 0.75
2024-04-01 00:00:00 | Unchanged | 0.15 | 0.66
2024-04-10 00:00:00 | better | 0.17 | 0.34
2024-04-12 00:00:00 | Unchanged | 0.18 | 1
2024-04-16 00:00:00 | better | 0.19 | 0.19
2024-04-16 00:00:00 | worse | 0.28 | 0.55
2024-03-31 00:00:00 | Unchanged | 0.39 |  | << would ignore the start score as there is nothing in finish score column
Spreadsheet: 147630d1332893260-need-help-populating-data-on-new-spreadsheet-from-extracted-pdf-information-ef69_for-forum-help
Sheet: Tab I'm trying to make

ID | CLIENT | YR | LOAN_NUMBER | TYPE | date_dt_fmt | TIME | USER_ID | COMMENT
Spreadsheet: 694749d1599774285-populating-table-from-quantity-data-examplesheet
Sheet: Sheet1

Product Name | QTY Size 8 | QTY Size 10 | QTY Size 12
Skirt | 2 | 3 | 2
Top | 1 | 1 | 1
Dress | 2 | 4 | 2
Product Name | Size
Skirt | 8
Skirt | 8
Skirt | 10
Skirt | 10
Skirt | 10
Skirt | 12
Skirt | 12
Top | 8
Top | 10
Top | 12
Dress | 8
Dress | 8
Dress | 10
Dress | 10
Dress | 10
Dress | 10
Dress | 12
Dress | 12
Spreadsheet: 177277d1346250750-row-offset-formula-assistance-trial-workbook
Sheet: Booking Out ITFC

Barcode | Date | Location
esn0000056177 | 2012-08-29 00:00:00 | AT ITFC
Spreadsheet: monika_causholli__28193__Price Forecast
Sheet: Newsprint

Newsprint Forecast |  | $
Firm/Analyst | Units | 2000 | 1Q01 | 2Q01 | 3Q01 | 4Q01 | 2001E | 1Q02 | 2Q02 | 3Q02 | 4Q02 | 2002E | 2003E |  | Date |  | Notes
ABG Sundal Collier US | $/mt | 566 |  |  |  |  | 588 |  |  |  |  | 490 | 532 |  | 2001-09-03 00:00:00
ABG Sundal Collier EUR | $/mt | 529 |  |  |  |  | 626 |  |  |  |  | 610 | 641 |  | 2001-09-03 00:00:00
[NAME] | $/mt | 551 |  |  |  |  | 578 |  |  |  |  | 520 |  |  | 2001-09-26 00:00:00
CIBC Securities | $/mt | 565 |  |  |  |  | 590q |  |  |  |  | 540q |  |  | 2001-09-25 00:00:00 |  | 2001E decreased from 580 to 578 - 2002E decreased from 575 to 520
CS First Boston | $/mt | 506 |  | 613 | 585 | 548 | 588q | 540 |  |  |  | 570q |  |  | 2001-10-01 00:00:00 |  | 2001E decreased from 596 to 588. 2002E decreased from 598 to 570.
[NAME] | $/mt | 545 |  |  |  |  | 615 |  |  |  |  |  |  |  | 2001-02-08 00:00:00
Deutsche Bank | $/mt | 567 | 610 | 625 | 585 | 550 | 589 | 530 | 500 | 500 | 530 | 515q | 575 |  | 2001-09-25 00:00:00 |  | 2002E forecast decreased from 560 to 515
First Associate Investment Inc. | $/mt |  |  |  |  |  | 565 |  |  |  |  | 600 |  |  | 2001-08-20 00:00:00
JP Morgan | $/mt | 564 |  |  |  |  | 590 |  |  |  |  | 575q |  |  | 2001-09-27 00:00:00 |  | 2001E decreased from 600 to 590. 2002E decreased from 615 to 575
Lehman Brothers | $/mt | 558 |  |  |  |  | 576 |  |  |  |  | 583 | 676 |  | 2001-07-16 00:00:00
[NAME] | $/mt
[NAME] | $/mt
Merrill Lynch | $/mt | 564 |  |  | 583 | 540 | 590q | 540 | 600 | 600 | 630 | 593q |  |  | 2001-09-28 00:00:00 |  | 2001E decreased from 611 to 590. 2002E decreased from 623 to 593
Morgan Stanley Dean Witter | $/mt
National Bank of Canada | $/mt | 577 |  | 617 | 580 |  | 580 |  |  |  |  | 535
PPW | $/mt |  |  |  |  |  | 611 |  |  |  |  | 623 |  |  | 2001-08-23 00:00:00
[NAME] | $/mt |  |  |  |  |  | 590 |  |  |  |  | 580 |  |  | 2001-08-22 00:00:00
Salman Partners | $/mt |  |  |  |  |  | 600 |  |  |  |  |  |  |  | 2001-08-01 00:00:00
Salomon Smith Barney | $/mt | 564 |  |  |  |  | 580 |  |  |  |  | 630 | 655 |  | 2001-05-29 00:00:00
Scotiabank | $/mt
TD Securities | $/mt |  |  |  |  |  | 569 |  |  |  |  | 563 |  |  | 2001-08-15 00:00:00
Spreadsheet: 713106d1610554774-redistributing-weighted-score-total-if-multiple-answers-not-given-redistrib-wgtd-score
Sheet: Sheet1

 | Weight | Score | Distribute | Correct
Q1 | 0.25 | 7
Q2 | 0.05
Q3 | 0.05 | 9
Q4 | 0.15
Q5 | 0.25 | 6
Q6 | 0.1 | 10
Q7 | 0.15 | 7
 |  |  |  |  | total
 |  |  |  |  | wgtd avg
 | I am creating a scoring system for a contest and need to redistribute the weight of one or more questions if they do not get scored. For example:
 | Q1 weight 25% |  |  |  |  |  |  | Example score sheet
 | Q2 weight 5%
 | Q3 weight 5% |  |  |  |  |  |  | Q1 - 7
 | Q4 weight 15% |  |  |  |  |  |  | Q2 - not scored
 | Q5 weight 25% |  |  |  |  |  |  | Q3 - 9
 | Q6 weight 10% |  |  |  |  |  |  | Q4 - not scored
 | Q7 weight 15% |  |  |  |  |  |  | Q5 - 6
 | Total 100% possible score |  |  |  |  |  |  | Q6- 10
 |  |  |  |  |  |  |  | Q7 -7
 | Judge would score for each question 1-10
 |  |  |  |  |  |  |  | In this case Q2 and 4 did not get scored so 20% would get divided into the other 5 scores. (4% into each of the other 5 scores)
 |  |  |  |  |  |  |  | How is a formula created for this so that whenever one or more scores are not answered the weight gets redistributed into the others.
 |  |  |  |  |  |  |  | Thank you.
Spreadsheet: 860990d1709010564-formula-to-match-partial-match-formula-to-match-items-with-partial-match-2-1-
Sheet: Creditors

Code | Name | Period Month | Period Year | Reference | Sub-Reference | Date Processed | Outstanding | Due Date | Accounting Group | Ageing | Unmatched Items
XM9854 |  |  |  | INV690643 |  |  | 10.55 | 2024-02-05 00:00:00 | Purchase | 22.14215011573833
XM9854 |  |  |  | INV690639 |  |  | 11.21 | 2024-02-05 00:00:00 | Purchase | 22.14215011573833
XM9854 |  |  |  | INV690641 |  |  | 26.98 | 2024-02-07 00:00:00 | Purchase | 20.14215011573833
XM9854 |  |  |  | 690670 |  |  | 173.32 | 2024-02-09 00:00:00 | Purchase | 18.14215011573833
XM9854 |  |  |  | 690668 |  |  | 11.21 | 2024-02-09 00:00:00 | Purchase | 18.14215011573833
XM9854 |  |  |  | 690703 |  |  | 11.21 | 2024-02-15 00:00:00 | Purchase | 12.14215011573833
XM9854 |  |  |  | 690698 |  |  | 83.33 | 2024-02-15 00:00:00 | Purchase | 12.14215011573833
XM9854 |  |  |  | 690699 |  |  | 74.8 | 2024-02-15 00:00:00 | Purchase | 12.14215011573833
XM9854 |  |  |  | 690746 |  |  | 15.43 | 2024-02-23 00:00:00 | Purchase | 4.142150115738332
Spreadsheet: darron_c_giron__8019__Official Post IDs
Sheet: Sheet1

FT-Central
User ID: | SITARA_PC
Password: | orbix
Date | 2000-10-19 00:00:00
Comm CD | ALL
Port  CD | Book CD | Comment
G | G | FT - Central
I | G | FT - Central |  | Port | Book | Risk | Post ID | Official Flag | Comm
I | A | FT - Central |  | G | G | P | 919864 | 1 | NG
G | L | FT - Central |  | G | G | D | 919865 | 1 | NG
G | D | FT - Central |  | I | G | I | 919866 | 1 | NG
G | 1 | FT-Ont-Central |  | I | A | P | 919867 | 1 | NG
G | 2 | FT-Ontario |  | G | L | P | 919868 | 1 | WTI
G | 3 | FT-Ontario |  | G | D | M | 919870 | 1 | NG
P | A | Peoples |  | G | 1 | P | 919887 | 1 | NG
S | Q | Peoples |  | G | 2 | P | 919888 | 1 | NG
G | # | FT - Peoples |  | G | 2 | D | 919889 | 1 | NG
P | A | Aruba-SPLY |  | G | 2 | I | 919890 | 1 | NG
 |  |  |  | G | 3 | M | 919892 | 1 | NG
 |  |  |  | P | A | M | 868544 | 1 | NG
 |  |  |  | S | Q | M | 920629 | 1 | NG
 |  |  |  | G | # | P | 919899 | 1 | NG
 |  |  |  | G | # | D | 919900 | 1 | NG
 |  |  |  | G | # | I | 919901 | 1 | NG
 |  |  |  | P | A | P | 919902 | 1 | NG
Spreadsheet: 796576d1663356471-sample-data-for-date-and-time-based-on-specific-person-sample-file-etaf2
Sheet: Sheet2

Time | Date | Salesperson |  |  |  |  |  | 2020-08-12 00:00:00 | 2020-08-13 00:00:00 | 2020-08-14 00:00:00 | 2020-08-16 00:00:00 | 2020-08-17 00:00:00 |  |  |  | Sum of Time | Column Labels
00:38:00.010000 | 2020-08-10 00:00:00 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | Row Labels | 2020-08-10 00:00:00 | 2020-08-12 00:00:00 | 2020-08-13 00:00:00 | 2020-08-14 00:00:00 | 2020-08-16 00:00:00 | 2020-08-17 00:00:00 | (blank) | Grand Total
00:20:00.010000 | 2020-08-10 00:00:00 | [NAME] |  |  |  | Nick |  |  |  |  |  |  |  |  |  | [NAME] |  | 0:10:00 |  |  |  |  |  | 0:10:00
00:18:00 | 2020-08-12 00:00:00 | Nick |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  | 0:23:00 |  |  |  | 0:23:00
00:09:59.962000 | 2020-08-12 00:00:00 | [NAME] |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | [NAME] | 0:58:00 |  |  |  |  |  |  | 0:58:00
00:33:59.990000 | 2020-08-13 00:00:00 | [NAME] |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | Nick |  | 0:18:00 |  |  |  | 0:56:00 |  | 1:14:00
00:22:59.981000 | 2020-08-14 00:00:00 | [NAME] |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  | 0:49:00 |  |  | 0:49:00
00:49:00.019000 | 2020-08-16 00:00:00 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  | 0:34:00 |  |  |  |  | 0:34:00
00:56:00.010000 | 2020-08-17 00:00:00 | Nick |  |  |  |  |  |  |  |  |  |  |  |  |  | (blank) |  |  |  |  |  |  | 0:00:00 | 0:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total | 0:58:00 | 0:28:00 | 0:34:00 | 0:23:00 | 0:49:00 | 0:56:00 | 0:00:00 | 4:08:00
 |  |  |  |  |  | For instance on 8/10/20 mike ahs 0:38 and 0:20 hours. I need that to total to 0.58 hour and search the rest of my sales people for time on that day and then total there time  My end result will scroll a month's worth of time and check everyday for time from all my sales people then list them row A through what ever and shows the days across in each column. If I can get the formula to search properly I think I can get the summary sheet figured out.  in my example to get the value in A15 I got this far =SUMIFS($A$3:$A$10, $B$3:$B$10,G3, $C$3:$C$10, $C$3) but I can not figure out how to get it to check the next name listed for the same date and then move to 8/11
Spreadsheet: 843913d1695736973-help-with-populating-data-in-correct-debit-and-credit-fields-jounral-upload-sage-intacct-jenish91-
Sheet: Data

Homes | EndAccrual
ACC | -15325
ACC | -2011.88
ACC | -2665.71
ACC | -1920.54
ACC | -1920.54
ACC | 0
ACC | 0
ACC | 0
ACC | -973
ACC | 0
ACC | 0
ACC | 0
ACC | 0
ACC | -9888
ACC | 0
ACC | 0
ACC | -3143.89
ACC | -4285.71
ACC | 0
ACC | 0
ACC | 0
ACC | 0
ACC | -3157.14
ACC | 0
ACC | 0
ACC | -2914.29
ACC | 0
ACC | 0
ACC | 0
ACC | -1885.71
ACC | -1381.13
ACC | 0
ACC | 0
ACC | 0
ACC | 0
ACC | 0
ACC | 0
ACC | -1920.54
ACC | -1920.54
ACC | -4389.57
ACC | 0
ACC | 0
ACC | 0
ACC | 0
ACC | -4572.46
ACC | 0
ACC | -1292.34
ACC | 0
ACC | -2185.71
ACC | 0
ACC | -2406.25
ACC | 0
ACC | -3181.46
ACC | 0
ACC | -1920.54
ACC | -3120
ACC | -2215.83
ACC | 0
ACC | 0
ACC | 0
ACC | 0
ACC | 0
ACC | -2406.25
ACC | 0
ACC | 0
ACC | -1920.54
ACC | 0
ACC | -5087.29
ACC | 0
ACC | 0
ACC | 0
ACC | 0
ACC | 0
ACC | -1857.14
ACC | -1920.54
ACC | 0
ACC | 0
ACC | 1390.8
ACC | 0
ACC | 0
ACC | 0
ACC | -3928.57
ACC | 0
ACC | 0
ACC | 0
ACC | 0
ACC | -2828.57
ACC | -2193.71
ACC | -2514.29
ACC | 0
ACC | -5892.86
ACC | 0
ACC | 0
ACC | 0
ACC | 0
ACC | 0
ACC | 0
ACC | 0
ACC | -2550
ACC | -1237.34
ACC | -3428.57
ACC | 0
ACC | 0
ACC | -2400
ACC | -3181.46
ACC | 0
ACC | 0
ACC | 0
ACC | 0
ACC | -3258.57
ACC | 0
ACC | -1920.54
ACC | 0
ACC | 0
ACC | -1964.29
ACC | 0
ACC | 0
ACC | 0
ACC | 0
ACC | 0
ACC | 0
ACC | 0
ACC | 0
ACC | 0
ACC | -1920.54
ACC | -2042.86
ACC | -1920.54
ACC | -1894.99
ACC | 0
AMH | -2355.93
AMH | -1853.34
AMH | -2234.5
AMH | 0
AMH | -2234.5
AMH | -2234.5
AMH | 1445.71
AMH | 0
AMH | -2234.5
AMH | -2234.53
AMH | -2234.5
AMH | -2234.5
AMH | -2234.5
AMH | -2234.5
AMH | -2234.5
AMH | -2234.5
AMH | 0
AMH | -2234.5
AMH | -2234.5
AMH | 0
AMH | -2234.5
AMH | -2234.53
AMH | -2234.47
AMH | -1857.93
AMH | -2234.5
AMH | -2234.5
AMH | 1445.86
AMH | -2325.57
AMH | -2234.5
AMH | -2234.5
AMH | -2234.5
AMH | -2234.53
AMH | -2234.53
AMH | -2234.5
AMH | -2234.5
AMH | 0
AMH | -1853.34
AMH | -2234.5
AMH | -2234.5
AMH | -1463.87
AMH | 0
AMH | -2234.5
AMH | -2234.5
AMH | -2234.5
AMH | -2234.5
AMH | 0
AMH | -2234.53
BCH | 488
BCH | 488
BCH | 488
BCH | 488
BCH | 488
BCH | 488
BCH | 488
BCH | 488
BCH | 488
BCH | 488
BCH | 488
BCH | 488
BCH | 488
BCH | 488
BCH | 488
BCH | 488
BCH | 488
BCH | 488
BCH | 488
BCH | 488
BCH | 488
BCH | 488
BCH | 488
BCH | 488
BCH | 488
BCH | 488
BCH | 488
BCH | 488
BCH | 488
BCH | 488
BCH | 488
BCH | 488
BCH | 488
BCH | 488
BCH | 488
BCH | 488
BCH | 488
BCH | 488
BCH | 488
BCH | 488
BCH | 488
BCH | 488
BCH | 488
BCH | 488
BCH | 488
BCH | 488
BCH | 13176
BCH | 488
BCH | 488
BCH | 488
BCH | 488
BCH | 488
BCH | 488
BCH | 488
BCH | 488
BCH | 488
BCH | 488
BCH | 1496
BCH | 488
BCH | 488
BCH | 488
BCH | 488
BCH | 488
BCH | 488
BCH | 488
BCH | 488
BCH | 488
BCH | 488
BCH | 488
BCH | 11497.14
BCH | 488
BCH | 488
BCH | 488
BCH | 488
BCH | 488
BCH | 488
BCH | 488
BCH | 488
BCH | 488
BCH | 488
BCH | 488
BCH | 488
BCH | 488
BCH | 488
ACC | 0
Spreadsheet: 836945d1689751847-how-can-i-make-2-copies-of-an-excel-workbook-that-updates-stock-list-revision-work
Sheet: TRUNK

CASS REF: | PRODUCT | TYPE/CODE | SIZE | QUAN LEFT | OVERFLOW STOCK | MINIMUM STOCK | MIN ORDER | SUPPLIER | COST | [NAME]
TRUNK
[NAME]
TRUNK | BLUE ATTENUATORS | LC/UPC | 3DB | 17 | N/A | 10 | 20 | TURNKEY
TRUNK | BLUE ATTENUATORS | LC/UPC | 5DB | 20 | N/A | 10 | 20 | TURNKEY
TRUNK | BLUE ATTENUATORS | LC/UPC | 7DB | 22 | N/A | 10 | 20 | TURNKEY
TRUNK | BLUE ATTENUATORS | LC/UPC | 10DB | 18 | N/A | 10 | 20 | TURNKEY
TRUNK | BLUE ATTENUATORS | LC/UPC | 15DB | 10 | N/A | 5 | 20 | TURNKEY
TRUNK | GREEN ATTENUATORS | LC/APC | 3DB | 88 | N/A | 20 | 20 | TURNKEY
TRUNK | GREEN ATTENUATORS | LC/APC | 5DB | 65 | N/A | 30 | 20 | TURNKEY
TRUNK | GREEN ATTENUATORS | LC/APC | 7DB | 63 | N/A | 30 | 20 | TURNKEY
TRUNK | GREEN ATTENUATORS | LC/APC | 10DB | 42 | N/A | 10 | 20 | TURNKEY
 | GREEN ATTENUATORS | SC/APC | 4DB | 15
TRUNK | EXFO PROTECTIVE COVERS OTDR & PWR MTR |  |  | 15 |  |  |  | EXFO
TRUNK | FUJI SPLICER ELECTRODES |  |  | 18
TRUNK | FUSION SPLICE CLEANING SWABS |  | N/A | 3 | N/A | 2 | 10 | FUJIKURA
TRUNK | PIANO WIRES | 12/PK | N/A | 21 | N/A |  |  | BLUE HELIX |  |  | Ferrule cleaning wires 125um x 75mm long, pack of 12
TRUNK | LC/UPC - FC/UPC ADAPTORS |  | N/A | 8
TRUNK | [NAME] |  | N/A | 11 | N/A | 5 |  | FUJIKURA
TRUNK | DIVOT CARTRIDGES |  |  | 27 |  |  |  | TURNKEY
TRUNK | DIVOT CERAMIC SLEEVES |  |  | 3 |  | 2 |  | MILLS
TRUNK | UTILITY BLADES |  | S | 50 | N/A | 5 | 5 | N/A
Spreadsheet: kate_symes__18632__SP 15 pages
Sheet: DJ SP15

 |  |  | Firm | Volume | Firm | Volume | Sun & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | 24 HOUR | [NAME]
 | 2001-02-13 00:00:00 |  | 233.43 | 13520 | 159.16 | 7400
 | 2001-02-12 00:00:00 |  | 195.13 | 7760 | 159.51 | 6920
 | 2001-02-11 00:00:00 |  |  |  |  |  | 159.15 | 18960
 | 2001-02-10 00:00:00 |  | 154.29 | 10160 | 124.69 | 6320
 | 2001-02-09 00:00:00 |  | 154.29 | 10160 | 124.69 | 6320
 | 2001-02-08 00:00:00 |  | 175.42 | 14400 | 142.48 | 5160
 | 2001-02-07 00:00:00 |  | 170.73 | 11184 | 140.82 | 10680
 | 2001-02-06 00:00:00 |  | 167.38 | 11280 | 146.9 | 6640
 | 2001-02-05 00:00:00 |  | 165.77 | 7120 | 151.67 | 6392
 | 2001-02-04 00:00:00 |  |  |  |  |  | 152.31 | 20376
 | 2001-02-03 00:00:00 |  | 181.02 | 12256 | 156.16 | 8432
 | 2001-02-02 00:00:00 |  | 179.62 | 13336 | 156.19 | 7512
 | 2001-02-01 00:00:00 |  | 219.11 | 13984 | 176.57 | 4368
 | 2001-01-31 00:00:00 |  | 238.8 | 20288 | 184.92 | 4640
 | 2001-01-30 00:00:00 |  | 222.41 | 19968 | 176.45 | 6240
 | 2001-01-29 00:00:00 |  | 227.4 | 21840 | 181.89 | 4440
 | 2001-01-28 00:00:00 |  |  |  |  |  | 181.89 | 13320
 | 2001-01-27 00:00:00 |  | 211.11 | 21472 | 172.47 | 4456
 | 2001-01-26 00:00:00 |  | 211.11 | 21392 | 172.47 | 4456
 | 2001-01-25 00:00:00 |  | 208.12 | 14880 | 179.01 | 6280
 | 2001-01-24 00:00:00 |  | 222.73 | 18880 | 169.8 | 6240
 | 2001-01-23 00:00:00 |  | 251.47 | 12800 | 171.59 | 5800
 | 2001-01-22 00:00:00 |  | 267.54 | 15440 | 185.36 | 2800
 | 2001-01-21 00:00:00 |  |  |  |  |  | 185 | 2400
 | 2001-01-20 00:00:00 |  | 435.91 | 4400 | 260.09 | 3584
 | 2001-01-19 00:00:00 |  | 435.91 | 4400 | 260.09 | 3584
 | 2001-01-18 00:00:00 |  | 326.07 | 5600 | 216.1 | 3080
 | 2001-01-17 00:00:00 |  | 232.5 | 8000 | 179.95 | 3680
 | 2001-01-16 00:00:00 |  | 181.85 | 13600 | 133.91 | 1880
 | 2001-01-15 00:00:00 |  | 181.85 | 13600 | 133.91 | 1880
 | 2001-01-14 00:00:00 |  |  |  |  |  | 128.51 | 4440
Spreadsheet: 869960d1716481319-multiple-scan-functions-how-to-use-multiple-ranges-within-scan-counting-with-scan
Sheet: Sheet1

 | 1 | 2 | 3 |  | Index 1 |  | Index 2 |  |  |  |  | Index 3
 | data | data | data |  | drag | spill | drag | spill |  |  |  | drag | spill |  |  |  |  |  |  |  | Total Output:
 | 4 | 1 | 1
 |  | 3 | 8 |  |  | 1
 |  |  | 7 |  |  | 1
 | 5 | 2 | 8 |  |  | 2
 |  | 6 | 6 |  |  | 2
 |  |  | 9 |  |  | 2
 |  |  | 1 |  |  | 2
 | 1 | 7 | 3 |  |  | 3
 |  | 2 | 2 |  |  | 3
 |  |  | 3 |  |  | 3
 |  |  |  |  |  |  |  | Question:
 |  |  |  |  |  |  |  | how do I spill when I need to reference two different ranges within the LAMBDA calculation? (as the drag-working on column H references values from both columns B and C)
 |  |  |  |  |  |  |  | multiple SCAN functions or use e.g. MAP combined with SCAN instead?
 | Working: | (all counters start at 1)
 | Index 1: increase counter by one with every data (in Index 1)
 | Index 2: increase counter with every data (or not if no data) and reset when Index 1 contains data
 | Index 3: increase counter with every data (or not if no data, not applicable here) and reset when Index 1 and Index 2 contain data
 |  |  |  |  |  |  |  | WIP:
 |  |  |  |  |  |  |  | Index 2 spilling:
 |  |  |  |  |  |  |  | LAMBDA Function inside SCAN would check if any value in column B and return 1 (to reset the counter), use the previous counter if no value in column C and increase the counter by 1 if there's a value in column C
 |  |  |  |  |  |  |  | how would that be implemeneted in column I?