tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 599366d1542993800-formula-to-add-one-to-the-previous-column-with-one-exception-da6-working-copy
Sheet: Sheet1

 | Starting situation for the sequence |  | 2018-12-01 00:00:00 | 2018-12-02 00:00:00 | 2018-12-03 00:00:00 | 2018-12-04 00:00:00 | 2018-12-05 00:00:00 | 2018-12-06 00:00:00 | 2018-12-07 00:00:00 | 2018-12-08 00:00:00 | 2018-12-09 00:00:00 | 2018-12-10 00:00:00 | 2018-12-11 00:00:00 | 2018-12-12 00:00:00 | 2018-12-13 00:00:00 | 2018-12-14 00:00:00 | 2018-12-15 00:00:00 | 2018-12-16 00:00:00 | 2018-12-17 00:00:00 | 2018-12-18 00:00:00 | 2018-12-19 00:00:00 | 2018-12-20 00:00:00 | 2018-12-21 00:00:00 | 2018-12-22 00:00:00 | 2018-12-23 00:00:00 | 2018-12-24 00:00:00 | 2018-12-25 00:00:00 | 2018-12-26 00:00:00 | 2018-12-27 00:00:00 | 2018-12-28 00:00:00 | 2018-12-29 00:00:00 | 2018-12-30 00:00:00 | 2018-12-31 00:00:00 | 2019-01-01 00:00:00 | 2019-01-02 00:00:00
Weekend/Holiday (W) |  | W | W | W |  |  |  |  | W | W |  |  |  |  |  |  | W | W |  |  |  |  |  | W | W | W | W |  |  |  | W | W |  | W
[NAME] | 4 | 2
[NAME] | 5 | 4 |  |  |  |  |  |  | 0
Smith | 1 | -1 |  |  |  |  |  |  |  | 0
[NAME] | 0 | 5 |  | 0 |  |  | 0
Brett | 6 | 0
Spreadsheet: 722958d1615466119-formula-copy-number-of-rows-based-on-cell-value-file-1-formula-needed
Sheet: Sheet1

Name | Type |  | Type | Total Active Type 1-10)
[NAME] |  |  | A
[NAME] |  |  | B
Adam |  |  | C
 |  |  | D
 |  |  | E
In need this in next sheet:
[NAME] | A
 | B
 | C
 | D
 | E
[NAME] | A
 | B
 | C
 | D
 | E
Adam | A
 | B
 | C
 | D
 | E
 | …
 | …
 | …
 | …
Spreadsheet: 581434d1531301910-compare-2-sheets-and-show-balance-bbsn
Sheet: ENTRY

CODE | YumNak | Customer Name | Address | DATE | MONTH | YEAR | Date of Keeping | Serial Number | Item Name | Gross Weight | Net Weight | Amount | Remarks | Column1 | Column2 | Column3 | Column4
AS1 | kh | Ranjana | Khabam | 9 | 3 | 2018 |  | 1 | [NAME] | 3 san | 2 san | 10000 | recievedd 200
AS2 | L | [NAME] | mantripukri | 9 | 3 | 2015 |  | 2 | lei |  | 1 san | 20000
AS3 |  |  |  | 9 | 3 | 2018
AS4
[NAME]
Spreadsheet: 754238d1636038791-add-a-cell-to-a-formula-nascondere
Sheet: Foglio1

 | 0
gen | 0 | 0 |  |  |  |  | =IF(AND(B3=0,C3=0),"",SUM(B1,D3,E3))
feb | 0 | 0
[NAME] | 0 | 0
apr | 0 | 0
mag | 0 | 0
[NAME] | 0 | 0
lug | 0 | 0
ago | 0 | 0
set | 0 | 0
ott | 0 | 0
nov | 0 | 0
dic | 0 | 0
Spreadsheet: daeb2ecc-24bf-4a81-8097-ba8f131ef4a7
Sheet: Sheet1

members 2012 | unit type | unit number | Zone | Unit Coordinator | Phone Number | [NAME] | Time & Location | date count | 2013  Presentation Date | New Proposed unit 2013 goal | Raised in 2012 | raised so far 2013
 | Crew | 4501 |  |  |  |  |  |  |  | 100 | 100
9 | Pack | 24 |  |  |  |  |  |  |  | 125 | 55
114 | Pack | 61 |  |  |  |  |  | 1 | 2013-02-24 00:00:00 | 6800 | 6344
88 | Pack | 90 |  |  |  |  |  |  |  | 1000 | 475
12 | Pack | 98 |  |  |  |  |  |  |  | 2000 | 1630
63 | Pack | 230 |  |  |  |  |  | 1 | 2013-03-15 00:00:00 | 2300
21 | Pack | 316 |  |  |  |  |  | 1 | 2013-02-23 00:00:00 | 500 | 350
25 | Pack | 319 |  |  |  |  |  | 1 | 2013-02-23 00:00:00 | 225 | 125
38 | Pack | 343 |  |  |  |  |  | 1 | 2013-02-15 00:00:00 | 200
45 | Pack | 380 |  |  |  |  |  | 1 | 2013-02-08 00:00:00 | 1000 | 670
10 | Pack | 508 |  |  |  |  |  |  |  | 200
14 | Pack | 538 |  |  |  |  |  | 1 | 2013-02-23 00:00:00 | 300 | 340
51 | Pack | 544 |  |  |  |  |  |  |  | 1000 | 1215
6 | Pack | 587 |  |  |  |  |  |  |  | 100
5 | Pack | 1517 |  |  |  |  |  |  |  | 125
5 | Pack | 1616 |  |  |  |  |  |  |  | 100
5 | Pack | 1650 |  |  |  |  |  | 1 | 2013-02-02 00:00:00 | 750 | 375 | 500
7 | Pack | 1869 |  |  |  |  |  | 1 | 2013-02-09 00:00:00 | 435 | 225
23 | Pack | 1909 |  |  |  |  |  |  |  | 500
29 | Pack | 1946 |  |  |  |  |  |  |  | 600 | 350
15 | Pack | 3838 |  |  |  |  |  |  |  | 200
34 | Pack | 4700 |  |  |  |  |  |  |  | 3000 | 250
9 | Troop | 24 |  |  |  |  |  |  |  | 125 | 50
29 | Troop | 61 |  |  |  |  |  | 1 | 2013-04-11 00:00:00 | 2300 | 1237
41 | Troop | 90 |  |  |  |  |  | 1 | 2013-02-20 00:00:00 | 3000 | 1200
35 | Troop | 100 |  |  |  |  |  | 1 | 2013-03-09 00:00:00 | 2000 | 1930
7 | Troop | 316 |  |  |  |  |  | 1 | 2013-02-23 00:00:00 | 500 | 350
25 | Troop | 319 |  |  |  |  |  |  |  | 250 | 100
9 | Troop | 338 |  |  |  |  |  |  |  | 200
19 | Troop | 343 |  |  |  |  |  | 1 | 2013-02-13 00:00:00 | 200 | 87.24
27 | Troop | 380 |  |  |  |  |  | 1 | 2013-04-27 00:00:00 | 1500 | 880 | 500
44 | Troop | 500 |  |  |  |  |  | 1 | 2013-01-28 00:00:00 | 3250 | 1060
10 | Troop | 508 |  |  |  |  |  |  |  | 200
12 | Troop | 524 |  |  |  |  |  |  |  | 500 | 100
10 | Troop | 538 |  |  |  |  |  | 1 | 2013-03-10 00:00:00 | 500 | 295
32 | Troop | 544 |  |  |  |  |  | 1 | 2013-03-02 00:00:00 | 2000 | 705
6 | Troop | 587 |  |  |  |  |  |  |  | 100
13 | Troop | 666 |  |  |  |  |  | 1 | 2013-02-04 00:00:00 | 500 | 485
5 | Troop | 1517 |  |  |  |  |  |  |  | 125
5 | Troop | 1616 |  |  |  |  |  |  |  | 100
5 | Troop | 1650 |  |  |  |  |  | 1 | 2013-02-02 00:00:00 | 250 | 300
6 | Troop | 1869 |  |  |  |  |  | 1 | 2013-02-09 00:00:00 | 200 | 200 | 300
31 | Troop | 1946 |  |  |  |  |  |  |  | 3000 | 2475 | 200
 | Troop | 1027 |  |  |  |  |  |  |  |  |  | 100
1026 | TOTAL |  |  |  |  |  |  | 21 |  | 42360 | 23958.24 | 1600
members | 43 units |  |  |  |  |  |  | dates |  | Sum of Unit Goals | Raised in 2012 | Raised in 2013
Spreadsheet: james_steffes__12926__Exh No BUR-2 Errata 11-26-01
Sheet: Sheet1

 | CITY OF BURBANK
 | CAISO SALES PURSUANT TO DOE ORDER
 | Ancillary Services  (Rev 11/19/01) |  |  |  |  |  | Instructed Energy
 | STL_QTY |  | STL_AMT |  | REFUND |  | MWH Sold |  | STL_AMT |  | Refund
 | MWH |  |  |  |  |  | MWH
2000-12-14 00:00:00
2000-12-15 00:00:00
2000-12-16 00:00:00
2000-12-17 00:00:00
2000-12-18 00:00:00
2000-12-19 00:00:00
2000-12-20 00:00:00
2000-12-21 00:00:00
2000-12-22 00:00:00
2000-12-23 00:00:00
2000-12-24 00:00:00
2000-12-25 00:00:00
2000-12-26 00:00:00
2000-12-27 00:00:00
2000-12-28 00:00:00
2000-12-29 00:00:00
2000-12-30 00:00:00
2000-12-31 00:00:00
Total
2001-01-01 00:00:00
2001-01-02 00:00:00
2001-01-03 00:00:00
2001-01-04 00:00:00
2001-01-05 00:00:00
2001-01-06 00:00:00
2001-01-07 00:00:00
2001-01-08 00:00:00
2001-01-09 00:00:00
2001-01-10 00:00:00
2001-01-11 00:00:00
2001-01-12 00:00:00
2001-01-13 00:00:00
2001-01-14 00:00:00
2001-01-15 00:00:00
2001-01-16 00:00:00
2001-01-17 00:00:00
2001-01-18 00:00:00
2001-01-19 00:00:00
2001-01-20 00:00:00
2001-01-21 00:00:00
2001-01-22 00:00:00
2001-01-23 00:00:00
2001-01-24 00:00:00
2001-01-25 00:00:00
2001-01-26 00:00:00
2001-01-27 00:00:00
2001-01-28 00:00:00
2001-01-29 00:00:00
2001-01-30 00:00:00
2001-01-31 00:00:00
Total
2001-02-01 00:00:00
2001-02-02 00:00:00
2001-02-03 00:00:00
2001-02-04 00:00:00
2001-02-05 00:00:00
2001-02-06 00:00:00
Total
Total Refund Due during  DOE Order
DOE Order in effect with ISO Certificate
ISO Purchases per DOE Order
Go to Jail Day
Spreadsheet: 261c40a8-63e9-45e2-bf84-705ebc8cc4f5
Sheet: Sheet1

[NAME] Wildkats | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25
 | Player and Team Totals |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Game 1 | Game 2 | Game 3 | Game 4 | Game 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 15 | 14 | 15
Date: | 2011-09-27 00:00:00 |  |  |  |  |  |  | mailto:[EMAIL] |  |  |  |  |  |  |  |  |  |  |  | @ [NAME] | 25 | 25 | 25
 |  | Gm | Serving |  |  |  |  | Attacking |  |  |  |  | Set |  | Blocks |  |  |  |  | Receptions
# | Player Name | P | Att. | Aces | [NAME]. | % | Ace/G | TA | Kills | [NAME]. | % | Kill/G | Asst. | Ast/G | Solo | Asst. | Blk/G | [NAME] | Dig/G | total attmps | on target | off target | play     able | errors | ratio
 | [NAME]
3 | Gist, [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
4 | [NAME],Erika12 | 3 | 6 |  |  | 1 | 0 |  |  |  |  | 0 | 5 | 1.666666666666667 |  |  | 0 | 3 | 1 | 3 | 1 | 1 |  | 1 | 1.666666666666667
5 | Cantu,[NAME] | 2 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  | 0 | 3 | 1.5 | 16 | 5 | 3 | 4 | 4 | 1.5625
10 | [NAME],Niki12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
11 | [NAME],Taylor11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
15 | Stenger,Gabrielle12 | 3 | 5 |  |  | 1 | 0 | 4 | 4 |  | 1 | 1.333333333333333 |  | 0 |  |  | 0 | 2 | 0.6666666666666666 | 17 | 5 | 7 | 1 | 4 | 1.764705882352941
20 | Burlage,Hope11 | 3 | 11 | 1 | 1 | 0.9090909090909091 | 0.3333333333333333 | 9 | 3 | 3 | 0 | 1 | 8 | 2.666666666666667 |  |  | 0 |  | 0 | 0
32 | Hanson, [NAME] | 3 | 2 |  |  | 1 | 0 | 1 |  |  | 0 | 0 |  | 0 |  |  | 0 | 2 | 0.6666666666666666 | 5 | 1 |  | 3 | 1 | 1.2
33 | Rowe,Shaun12 | 3 | 7 |  | 1 | 0.8571428571428571 | 0 | 9 | 4 | 1 | 0.3333333333333333 | 1.333333333333333 |  | 0 |  |  | 0 | 5 | 1.666666666666667 | 11 | 3 | 1 | 2 | 5 | 1.181818181818182
34 | [NAME],Haley10 | 3 | 4 |  | 2 | 0.5 | 0 | 7 | 2 | 4 | -0.2857142857142857 | 0.6666666666666666 |  | 0 | 2 |  | 0.6666666666666666 | 3 | 1 | 0
19 | [NAME] | 2 | 2 |  |  | 1 | 0 |  |  |  |  | 0 |  | 0 |  |  | 0 | 1 | 0.5 | 3 | 1 |  | 1 | 1 | 1.333333333333333
20 | Ciera Finberg09 | 2 | 2 |  |  | 1 | 0 |  |  |  |  | 0 |  | 0 | 1 |  | 0.5 | 1 | 0.5 | 1 |  |  |  | 1 | 0
21 | Shannon Hay11 | 1 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 | 0
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Team Totals | 3 | 39 | 1 | 4 | 0.8974358974358975 | 0.3333333333333333 | 30 | 13 | 8 | 0.1666666666666667 | 4.333333333333333 | 13 | 4.333333333333333 | 3 | 0 | 1 | 20 | 6.666666666666667 | 56 | 16 | 12 | 11 | 17 | 1.482142857142857
Spreadsheet: 780285d1652373171-return-multiple-values-across-many-rows-and-columns-20210302-projects
Sheet: Stg1 SIR Weston

 |  | 2020-03-10 00:00:00
 | Task | Description | Contract Amount (ex GST) | Percent Complete | Billed To Date | Previously Billed | Current Billed
 | Stage 1 | Stage 1 SIR Weston | 22500 |  |  | 0 | 3827
 |  | Project Total
 |  |  | Subtotal of This Invoice
 |  |  | GST
 |  |  | Invoice Total (Including GST)
Spreadsheet: 781556d1653413849-12-months-average-2022-05-24-oeldere-hanif
Sheet: Sheet1

Group | Month | Value | average |  | Month | May
202001 | Jan | 5
202002 | Feb | 3.2 |  |  | 202105
202003 | Mar | 1
202004 | Apr | 5.6
202005 | May | 3
202006 | Jun | 7.5 |  |  | Rijlabels | average
202007 | Jul | 6.4 |  |  | 202001
202008 | Aug | 3.1 |  |  | 202002
202009 | Sep | 1.2 |  |  | 202003
202010 | Oct | 5 |  |  | 202004
202011 | Nov | 6 |  |  | 202005
202012 | Dec | 9.1 |  |  | 202006
202101 | Jan | 3.5 |  |  | 202007
202102 | Feb | 6.8 |  |  | 202008
202103 | Mar | 9.4 |  |  | 202009
202104 | Apr | 7.2 |  |  | 202010
202105 | May | 2.4 |  |  | 202011
202106 | Jun | 5.6 |  |  | 202012 | 4.675
202107 | Jul | 6.8 |  |  | 202101 | 4.55
202108 | Aug | 6.2 |  |  | 202102 | 4.85
202109 | Sep | 1 |  |  | 202103 | 5.55
202110 | Oct | 4.9 |  |  | 202104 | 5.683333333333334
202111 | Nov | 8.2 |  |  | 202105 | 5.633333333333333
202112 | Dec | 6.5 |  |  | 202106 | 5.474999999999999
 |  |  |  |  | 202107 | 5.508333333333333
 |  |  |  |  | 202108 | 5.766666666666667
 |  |  |  |  | 202109 | 5.75
 |  |  |  |  | 202110 | 5.741666666666667
 |  |  |  |  | 202111 | 5.925
 |  |  |  |  | 202112 | 5.708333333333333
 |  |  |  |  | Eindtotaal | 5.447435897435897
Spreadsheet: 1f1b1ce4-f60b-448a-a481-66d9dff26d29
Sheet: WebSpirs

WebSPIRS
2004-2005
Metric | 2004-07-01 00:00:00 | 2004-08-01 00:00:00 | 2004-09-01 00:00:00 | 2004-10-01 00:00:00 | 2004-11-01 00:00:00 | 2004-12-01 00:00:00 | 2005-01-01 00:00:00 | 2005-02-01 00:00:00 | 2005-03-01 00:00:00 | 2005-04-01 00:00:00 | 2005-05-01 00:00:00 | 2005-06-01 00:00:00 | Total | 2004-2005 Price | Price per search
TOTAL
Biological Abstracts
Sessions | 76 | 63 | 102 | 253 | 293 | 166 | 61 | 157 | 277 | 424 | 167 | 44
Searches | 292 | 307 | 277 | 816 | 1265 | 617 | 198 | 534 | 956 | 1504 | 654 | 220 |  | 21255
Turnaways | 0 | 0 | 0 | 6 | 6 | 2 | 0 | 0 | 0 | 0 | 0 | 0
Peak usage |  |  |  |  |  |  |  | 3 |  |  | 3 | 1
Metric | 2004-07-01 00:00:00 | 2004-08-01 00:00:00 | 2004-09-01 00:00:00 | 2004-10-01 00:00:00 | 2004-11-01 00:00:00 | 2004-12-01 00:00:00 | 2005-01-01 00:00:00 | 2005-02-01 00:00:00 | 2005-03-01 00:00:00 | 2005-04-01 00:00:00 | 2005-05-01 00:00:00 | 2005-06-01 00:00:00 | Total
TOTAL
Philosopher's Index
Sessions | 12 | 13 | 20 | 31 | 4 | 2 | 0 | 1 | 1 | 1 | 3 | 0
Searches | 18 | 16 | 29 | 34 | 7 | 2 | 0 | 1 | 0 | 1 | 22 | 0 |  | 1900
Turnaways | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Peak usage |  |  |  |  |  |  |  | 1 |  |  | 1 | 0
Spreadsheet: 718845d1613389871-how-do-i-use-if-with-match-to-fill-a-cell-automatically-sampledata
Sheet: TrainingStat

Name | [NAME] | Face2Face Complete Date | GMP Complete LookUp | Last Course Complete Date LookUp(Any Course)
[NAME] | Complete | 2021-01-04 00:00:00 | if name on this sheet is found on course sheet and GMP Complete  "Yes" ifnot "No" | If name is found on course sheet return date value of last course complete
[NAME] | Complete | 2021-01-08 00:00:00 |  | =MAX((tblcourses[Name]=A3)*(tblCourses[datecompleted])) |  | <--- Dirk Diggler DOES have CMP Should be Yes
[NAME] | Incomplete |  |  |  |  | <--- Returns wrong date
[NAME] | Complete | 2021-01-10 00:00:00 |  |  |  | <--- [NAME] DOES have GMP. Should be yes
[NAME] | Not Enrolled |  |  |  |  | <--- Name does not exist in Courses
Spreadsheet: john_zufferli__16697__HedgeSummary
Sheet: Sheet1

 | CONFIDENTIAL:  PPA - POWER AND GAS POSITIONS:
 |  |  |  |  |  |  |  |  | Current to
 |  |  |  |  | Power Price | Aeco Gas Price | Heat Rate | Jan 11/2001 | Beg. Year | Hedgeable Volume | Current Gas Hedges |  | AECO Basis Hedge
 |  | Power (MWh) | Discount Days | Power (MW) | ($/MWh) | ($[NAME]) | (GJ/MWh) | Heat Rates | HR Delta | (contracts/day) | (contracts/day) | % Hedged | (contracts/day)
2002-01-01 00:00:00 | Cal 2002 |  |  |  |  |  |  | 14.25 |  |  | 13.5 |  | 13.5
2003-01-01 00:00:00 | Cal 2003 |  |  |  |  |  |  | 12.03 |  |  | 10.5 |  | 6
2004-01-01 00:00:00 | Cal 2004 |  |  |  |  |  |  | 8.9 |  |  | 9 |  | 5
2005-01-01 00:00:00 | Cal 2005 |  |  |  |  |  |  | 9.06 |  |  | 9 |  | 5
2006-01-01 00:00:00 | Cal 2006 |  |  |  |  |  |  | 7.5 |  |  | 9 |  | 4
2007-01-01 00:00:00 | Cal 2007 |  |  |  |  |  |  | 7.02 |  |  | 9 |  | 4
2008-01-01 00:00:00 | Cal 2008 |  |  |  |  |  |  | 7.09 |  |  | 9 |  | 4
2009-01-01 00:00:00 | Cal 2009 |  |  |  |  |  |  | 7.1 |  |  | 9 |  | 4
2010-01-01 00:00:00 | Cal 2010 |  |  |  |  |  |  | 7.14 |  |  | 9 |  | 4
2011-01-01 00:00:00 | Cal 2011 |  |  |  |  |  |  | 7.11 |  |  | 1 |  | 0
2012-01-01 00:00:00 | Cal 2012 |  |  |  |  |  |  | 7.08 |  |  | 1 |  | 0
2013-01-01 00:00:00 | Cal 2013 |  |  |  |  |  |  | 7.04 |  |  | 1 |  | 0
2014-01-01 00:00:00 | Cal 2014 |  |  |  |  |  |  | 7.03 |  |  | 1 |  | 0
2015-01-01 00:00:00 | Cal 2015 |  |  |  |  |  |  | 7 |  |  | 1 |  | 0
2016-01-01 00:00:00 | Cal 2016 |  |  |  |  |  |  | 7 |  |  | 0 |  | 0
2017-01-01 00:00:00 | Cal 2017 |  |  |  |  |  |  | 7 |  |  | 0 |  | 0
2018-01-01 00:00:00 | Cal 2018 |  |  |  |  |  |  | 7 |  |  | 0 |  | 0
2019-01-01 00:00:00 | Cal 2019 |  |  |  |  |  |  | 7 |  |  | 0 |  | 0
2020-01-01 00:00:00 | Cal 2020 |  |  |  |  |  |  | 7 |  |  | 0 |  | 0
 | Total
 | Note: Power position is 710MW * Availability factor (of 81-87%) - 9% transmission losses - hedges
Spreadsheet: 837137d1689873880-indirect-a1-a5-and-a1-to-spill-a1-from-other-sheets-doesnt-work-how-could-i-do-it-example-2
Sheet: DBParis

Shop | N° Client | Date Liv. | N° Cde | N° B.L | City | Adress | Quantity
1 |  | 2022-02-01 00:00:00 | 1 | 1 | XXXX |  | 1
1 | 1 | 2022-02-01 00:00:00 | 2 | 2 | XXXX | 75000 | 3
1 | 2 | 2022-02-01 00:00:00 | 3 | 3 | XXXX | 76000 | 8
1 | 1 | 2022-02-01 00:00:00 | 4 | 4 | XXXX | 76000 | 6
1 | 2 | 2022-02-01 00:00:00 | 5 | 5 | XXXX | 77000 | 1
1 | 1 | 2022-02-01 00:00:00 | 6 | 6 | XXXX | 77000 | 6
1 | 2 | 2022-02-01 00:00:00 | 7 | 7 | XXXX | 78000 | 10
1 | 1 | 2022-02-01 00:00:00 | 0 | 8 | XXXX | 78000 | 5
1 | 2 | 2022-02-01 00:00:00 | 9 | 9 | XXXX | 79000 | 1
1 | 1 | 2022-02-01 00:00:00 | 10 | 10 | XXXX | 79000 | 1
1 | 2 | 2022-02-01 00:00:00 | 11 | 11 | XXXX | 80000 | 0
1 | 1 | 2022-02-01 00:00:00 | 0 | 12 | XXXX | 80000 | 0
1 | 2 | 2022-02-01 00:00:00 | 13 | 13 | XXXX | 81000 | 0
1 | 1 | 2022-02-01 00:00:00 | 14 | 14 | XXXX | 81000 | 1
1 | 2 | 2022-02-01 00:00:00 | 15 | 15 | XXXX | 82000 | 0
1 | 1 | 2022-02-01 00:00:00 | 16 | 16 | XXXX | 82000 | 0
1 | 2 | 2022-02-01 00:00:00 | 17 | 17 | XXXX | 83000 | 12
1 | 1 | 2022-02-02 00:00:00 | 0 | 18 | XXXX | 83000 | 3
1 | 2 | 2022-02-02 00:00:00 | 19 | 19 | XXXX | 84000 | 12
1 | 1 | 2022-02-02 00:00:00 | 20 | 20 | XXXX | 84000 | 0
1 | 2 | 2022-02-02 00:00:00 | 21 | 21 | XXXX | 85000 | 8
1 | 1 | 2022-02-02 00:00:00 | 22 | 22 | XXXX | 85000 | 1
1 | 2 | 2022-02-02 00:00:00 | 23 | 23 | XXXX | 86000 | 1
1 | 1 | 2022-02-02 00:00:00 | 24 | 24 | XXXX | 86000 | 2
1 | 2 | 2022-02-02 00:00:00 | 0 | 25 | XXXX | 87000 | 1
1 | 1 | 2022-02-02 00:00:00 | 0 | 26 | XXXX | 87000 | 10
1 | 2 | 2022-02-02 00:00:00 | 27 | 27 | XXXX | 88000 | 2
1 | 1 | 2022-02-02 00:00:00 | 28 | 28 | XXXX | 88000 | 0
1 | 2 | 2022-02-02 00:00:00 | 29 | 29 | XXXX | 89000 | 0
1 | 1 | 2022-02-02 00:00:00 | 30 | 30 | XXXX | 89000 | 0
1 | 2 | 2022-02-02 00:00:00 | 31 | 31 | XXXX | 90000 | 13
1 | 1 | 2022-02-02 00:00:00 | 32 | 32 | XXXX | 90000 | 4
1 | 2 | 2022-02-02 00:00:00 | 33 | 33 | XXXX | 91000 | 3
1 | 1 | 2022-02-03 00:00:00 | 34 | 34 | XXXX | 91000 | 1
1 | 2 | 2022-02-03 00:00:00 | 0 | 35 | XXXX | 92000 | 0
1 | 1 | 2022-02-03 00:00:00 | 36 | 36 | XXXX | 92000 | 1
1 | 2 | 2022-02-03 00:00:00 | 37 | 37 | XXXX | 93000 | 1
1 | 1 | 2022-02-03 00:00:00 | 38 | 38 | XXXX | 93000 | 24
1 | 2 | 2022-02-03 00:00:00 | 39 | 39 | XXXX | 94000 | 7
1 | 1 | 2022-02-03 00:00:00 | 40 | 40 | XXXX | 94000 | 15
1 | 2 | 2022-02-03 00:00:00 | 41 | 41 | XXXX | 95000 | 5
1 | 1 | 2022-02-03 00:00:00 | 42 | 42 | XXXX | 95000 | 5
1 | 2 | 2022-02-03 00:00:00 | 43 | 43 | XXXX | 96000 | 3
1 | 1 | 2022-02-03 00:00:00 | 44 | 44 | XXXX | 96000 | 0
1 | 2 | 2022-02-03 00:00:00 | 45 | 45 | XXXX | 97000 | 0
1 | 1 | 2022-02-03 00:00:00 | 46 | 46 | XXXX | 97000 | 2
1 | 2 | 2022-02-03 00:00:00 | 47 | 47 | XXXX | 98000 | 1
1 | 1 | 2022-02-03 00:00:00 | 48 | 48 | XXXX | 98000 | 7
1 | 2 | 2022-02-03 00:00:00 | 49 | 49 | XXXX | 99000 | 2
1 | 1 | 2022-02-03 00:00:00 | 50 | 50 | XXXX | 99000 | 9
Spreadsheet: e6dc3c31-bc40-4651-a1e1-8f3001f8d0a3
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
40827418 | 2014-04-03 20:56:53 | ALLIES | 1 | 4 | 1 | 1096405 | _Samy | 6149 | western | 1944-08-07 | 1944-08-11 | Counter-attack on Mortain | Contre-attaque de Mortain
40827671 | 2014-04-03 21:12:16 | AXIS | 1 | 4 | 3 | 1096405 | _Samy | 6149 | western | 1944-08-07 | 1944-08-11 | Counter-attack on Mortain | Contre-attaque de Mortain
40837811 | 2014-04-04 15:15:48 | ALLIES | 0 | 0 | 4 | 563579 | Amombar | 6149 | western | 1944-08-07 | 1944-08-11 | Counter-attack on Mortain | Contre-attaque de Mortain
40838018 | 2014-04-04 15:42:49 | ALLIES | 1 | 4 | 1 | 1553091 | Toko the 6 | 6149 | western | 1944-08-07 | 1944-08-11 | Counter-attack on Mortain | Contre-attaque de Mortain
40838164 | 2014-04-04 15:54:23 | AXIS | 1 | 4 | 1 | 1553091 | Toko the 6 | 6149 | western | 1944-08-07 | 1944-08-11 | Counter-attack on Mortain | Contre-attaque de Mortain
40842777 | 2014-04-04 22:08:12 | ALLIES | 0 | 2 | 4 | 1553140 | player1553140 | 6149 | western | 1944-08-07 | 1944-08-11 | Counter-attack on Mortain | Contre-attaque de Mortain
40843063 | 2014-04-04 22:18:08 | AXIS | 1 | 4 | 0 | 1553140 | player1553140 | 6149 | western | 1944-08-07 | 1944-08-11 | Counter-attack on Mortain | Contre-attaque de Mortain
40863189 | 2014-04-06 03:55:34 | ALLIES | 1 | 4 | 1 | 767699 | nap1815 | 6149 | western | 1944-08-07 | 1944-08-11 | Counter-attack on Mortain | Contre-attaque de Mortain
40863324 | 2014-04-06 04:13:01 | AXIS | 1 | 4 | 3 | 767699 | nap1815 | 6149 | western | 1944-08-07 | 1944-08-11 | Counter-attack on Mortain | Contre-attaque de Mortain
40893104 | 2014-04-08 01:04:22 | ALLIES | 0 | 2 | 4 | 67493 | [NAME] | 6149 | western | 1944-08-07 | 1944-08-11 | Counter-attack on Mortain | Contre-attaque de Mortain
40893206 | 2014-04-08 01:11:26 | AXIS | 1 | 4 | 0 | 67493 | [NAME] | 6149 | western | 1944-08-07 | 1944-08-11 | Counter-attack on Mortain | Contre-attaque de Mortain
40893280 | 2014-04-08 01:31:49 | ALLIES | 0 | 5 | 7 | 67493 | [NAME] | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
40893486 | 2014-04-08 01:52:40 | AXIS | 1 | 7 | 2 | 67493 | [NAME] | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
40964637 | 2014-04-13 03:28:24 | ALLIES | 0 | 2 | 4 | 414218 | Guderian40 | 6149 | western | 1944-08-07 | 1944-08-11 | Counter-attack on Mortain | Contre-attaque de Mortain
40964792 | 2014-04-13 03:48:01 | AXIS | 1 | 4 | 2 | 414218 | Guderian40 | 6149 | western | 1944-08-07 | 1944-08-11 | Counter-attack on Mortain | Contre-attaque de Mortain
40980325 | 2014-04-14 02:18:53 | ALLIES | 0 | 2 | 4 | 1557992 | Unrealik229 | 6149 | western | 1944-08-07 | 1944-08-11 | Counter-attack on Mortain | Contre-attaque de Mortain
40980481 | 2014-04-14 02:33:06 | AXIS | 1 | 4 | 3 | 1557992 | Unrealik229 | 6149 | western | 1944-08-07 | 1944-08-11 | Counter-attack on Mortain | Contre-attaque de Mortain
Spreadsheet: 819373d1677471904-vlookup-specific-description-from-multiple-tabs-under-specific-header-name-in-one-column-prices-samples
Sheet: Price matched 1

Price File Name: Price_eff123123123
Price [NAME]
No_in_loader | No Price | No in sys | Difference
12 | 0 | 5
Matched_Prices
Code | Date | Part Code | Name | Price 1 | Price 2 | Price 3
ABC | 2023-01-26 00:00:00 |  |  | 69.876 | 68.34 | 67.879
DEF | 2023-01-26 00:00:00 |  |  | 1.989
GHI | 2023-01-26 00:00:00 |  |  | 87.212
JKL | 2023-01-26 00:00:00 |  |  | 3.4234
MNO | 2023-01-26 00:00:00 |  |  | 1.044
Unmatched_Prices
Code | Date | Part Code | Name | Price 1 | Price 2 | Price 3
PQR | 2023-01-26 00:00:00 |  |  | 1.232
STU | 2023-01-26 00:00:00 |  |  | 2.43
VWX | 2023-01-26 00:00:00 |  |  | 1.876
YZA | 2023-01-26 00:00:00 |  |  | 0.08997
AAA | 2023-01-26 00:00:00 |  |  | 0.1231
BBB | 2023-01-26 00:00:00 |  |  | 1.312
CCC | 2023-01-26 00:00:00 |  |  | 4.2342
Spreadsheet: 814580d1674496235-formula-to-list-out-a-list-of-values-with-multiple-quantites-vstack-sequence-long-way-365
Sheet: Sheet1

 |  |  | AMOUNT | QTY |  | COMPLETE LIST |  | DESIRED RESULT
 |  |  | 55.4 | 5 |  |  |  | 55.4
 |  |  | 60.2 | 1 |  | 55.4 |  | 55.4
 |  |  | 22.5 | 1 |  | 55.4 |  | 55.4
 |  |  | 71.85 | 2 |  | 55.4 |  | 55.4
 |  |  | 57.2 | 3 |  | 55.4 |  | 55.4
 |  |  | 51 | 2 |  | 60.2 |  | 60.2
 |  |  | 19.7 | 2 |  | 22.5 |  | 22.5
 |  |  | 66.3 | 1 |  | 71.85 |  | 71.85
 |  |  |  |  |  | 71.85 |  | 71.85
 |  |  |  |  |  | 57.2 |  | 57.2
 |  |  |  |  |  | 57.2 |  | 57.2
 |  |  |  |  |  | 57.2 |  | 57.2
 |  |  |  |  |  | 51 |  | 51
 |  |  |  |  |  | 51 |  | 51
 |  |  |  |  |  | 19.7 |  | 19.7
 |  |  |  |  |  | 19.7 |  | 19.7
 |  |  |  |  |  | 66.3 |  | 66.3