tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 92066d1291740026-excel-2007-tie-breakers-in-excel-weekly-update-pub
Sheet: Sheet1

 |  | Top 10 Margin |  |  |  |  | Top 10 UPG |  |  |  |  | Top 10 Discount | % | $ Lost
 | 1 |  |  |  |  | 1 |  |  |  |  | 1
 | 2 |  |  |  |  | 2 |  |  |  |  | 2
 | 3 |  |  |  |  | 3 |  |  |  |  | 3
 | 4 |  |  |  |  | 4 |  |  |  |  | 4
 | 5 |  |  |  |  | 5 |  |  |  |  | 5
 | 6 |  |  |  |  | 6 |  |  |  |  | 6
 | 7 |  |  |  |  | 7 |  |  |  |  | 7
 | 8 |  |  |  |  | 8 |  |  |  |  | 8
 | 9 |  |  |  |  | 9 |  |  |  |  | 9
 | 10 |  |  |  |  | 10 |  |  |  |  | 10
 |  | Bottom 10 Margin |  |  |  |  | Bottom 10 UPG |  |  |  |  | Bottom 10 Discount | %
 | 1 |  |  |  |  | 1 |  |  |  |  | 1
 | 2 |  |  |  |  | 2 |  |  |  |  | 2
 | 3 |  |  |  |  | 3 |  |  |  |  | 3
 | 4 |  |  |  |  | 4 |  |  |  |  | 4
 | 5 |  |  |  |  | 5 |  |  |  |  | 5
 | 6 |  |  |  |  | 6 |  |  |  |  | 6
 | 7 |  |  |  |  | 7 |  |  |  |  | 7
 | 8 |  |  |  |  | 8 |  |  |  |  | 8
 | 9 |  |  |  |  | 9 |  |  |  |  | 9
 | 10 |  |  |  |  | 10 |  |  |  |  | 10
Spreadsheet: 059b15b1-0ab9-4ca8-a028-6dfcf9c94b29
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Taseis | 829987100028 | Ricardo | Unmerited | 2005-05-24 | Compact Disc | Ac | 8.99 | Y | Available
Spreadsheet: 169414d1342813241-excel-2007-combining-four-lists-into-one-automatic-sortv
Sheet: Sheet1

12IA12077QGR1996 A       12IA12078QGR1997 B |  |  |  | 12IA12077QGR1996 A       12IA12078QGR1997 B |  | 12IA12017QGR1933 A     12IA12018QGR1934 B |  | 12GH11066QGR2006 |  | 11V28L1836
12CB12006QGR2027 |  |  |  | 12CB12006QGR2027 |  | 12IA12019QGR1935 A     12IA12020QGR1936 B |  | 12GH12009QGR2008 |  | 11F50L1889
12MH12005QGR2028 |  |  |  | 12MH12005QGR2028 |  | 12IA12041QGR1958 A     12IA12042QGR1959 B |  | 12DH12001QGR2013 |  | 11F53L1892
12IA12079QGR1998 A       12IA12080QGR1999 B |  |  |  | 12IA12079QGR1998 A       12IA12080QGR1999 B |  | 12IA12043QGR1962 A     12IA12044QGR1963 B |  | 12GH11085QGR1902 |  | 12CC11005QGR1893
12GV12005QGR2029 A |  |  |  | 12GV12005QGR2029 A |  | 12IA12045QGR1964 A     12IA12046QGR1965 B |  | 12GH11087QGR2005 |  | 12DH11012QGR1896
12IA12017QGR1933 A     12IA12018QGR1934 B
12IA12019QGR1935 A     12IA12020QGR1936 B
12IA12041QGR1958 A     12IA12042QGR1959 B
12IA12043QGR1962 A     12IA12044QGR1963 B
12IA12045QGR1964 A     12IA12046QGR1965 B
12GH11066QGR2006
12GH12009QGR2008
12DH12001QGR2013
12GH11085QGR1902
12GH11087QGR2005
0
0
Spreadsheet: 98344d1297280686-consolidating-data-on-different-sheets-going-off-of-a-name-pay-roll-temp
Sheet: Year-to-date

Texas
Year-To-Date Totals
[NAME] | Position | Daily Rate | Days On | Gross Pay | Cash Advance | Travel & Visa Reimb. | Medical | Net Pay | Wire and ADP Fees | Other
[NAME] | Master | 550
[NAME] | Master | 350
[NAME] | Chief Officer | 400
[NAME] | 2nd  Officer | 300
[NAME] | Ch Eng | 450
Spreadsheet: 118065d1313418909-value-lookup-based-on-product-code-and-quantity-example1
Sheet: Sheet1

PURCHASE ORDER # | STYLE | COLOR | QTY ORDERED | SHIP DATE | DELIVERY DATE |  |  | BUDGET
 | NUMBER | NUMBER |  |  | DELIVERY DATE
1 | PRODUCT1 | WHITE | 98 |  |  |  |  | 158.76
2 | PRODUCT2 | BLACK | 67 |  |  |  |  | 117.25
3 | PRODUCT3 | NAVY | 12 |  |  |  |  | 21.6
 | EA price to produce
STYLE
PRODUCT1 | 1.62
PRODUCT2 | 1.75
PRODUCT3 | 1.8
Spreadsheet: 784657d1655892357-lookup-previous-price-in-price-list-previous-price-to-be-troubleshooted
Sheet: Price List

Date | Site | Supplier | P/N | MOQ | Price | Previous Price With Exact MOQ | Previous Price With Exact Or Closest MOQ
2022-06-21 00:00:00 | Paris | S1 | 123 | 10 | 12 |  |  |  | Task:
2022-06-21 00:00:00 | Paris | S1 | 258 | 30 | 16.5 |  |  |  | Lookup previous price matching with Site, [NAME], P/N and MOQ. If MOQ does not match, look for the closest (= smalest difference) salue in the previous price record instead.
2022-06-21 00:00:00 | Paris | S1 | 258 | 60 | 12.6 |  |  |  | If the previous price does not exist for the criteria above, show "-".
2022-06-21 00:00:00 | Prague | S1 | 456 | 100 | 6.8
2022-06-21 00:00:00 | Prague | S1 | 456 | 1000 | 4.5
2022-06-21 00:00:00 | Prague | S1 | 456 | 10000 | 3.8
2022-06-18 00:00:00 | London | S2 | 147 | 100 | 15
2022-06-18 00:00:00 | Paris | S2 | 123 | 20 | 10.6
2022-06-18 00:00:00 | Paris | S2 | 159 | 1000 | 14
2022-06-18 00:00:00 | Prague | S2 | 369 | 4500 | 13
2022-06-18 00:00:00 | Prague | S2 | 369 | 13500 | 10.1
2022-06-18 00:00:00 | Prague | S2 | 369 | 26000 | 8.2
2022-05-15 00:00:00 | Prague | S3 | 369 | 4500 | 12
2022-05-15 00:00:00 | Prague | S3 | 369 | 26000 | 7.4
2022-04-18 00:00:00 | Paris | S1 | 123 | 10 | 14
2022-04-18 00:00:00 | Paris | S1 | 258 | 30 | 17
2022-04-18 00:00:00 | Paris | S1 | 258 | 60 | 13
2022-04-18 00:00:00 | Prague | S1 | 456 | 100 | 6.8
2022-04-18 00:00:00 | Prague | S1 | 456 | 1000 | 4.2
2022-04-18 00:00:00 | Prague | S1 | 456 | 10000 | 3.8
2022-03-30 00:00:00 | Prague | S3 | 369 | 4500 | 13
2022-03-30 00:00:00 | Prague | S3 | 369 | 26000 | 6.5
2022-03-05 00:00:00 | London | S2 | 147 | 100 | 14
2022-03-05 00:00:00 | Paris | S2 | 123 | 20 | 14.3
2022-03-05 00:00:00 | Paris | S2 | 159 | 500 | 13 |  |  | should return 16,5 from F46
2022-03-05 00:00:00 | Prague | S2 | 369 | 6000 | 12 |  |  | should return 12 from F27
2022-03-05 00:00:00 | Prague | S2 | 369 | 13500 | 9.9 |  |  | should return 9,1 from F44
2022-03-05 00:00:00 | Prague | S2 | 369 | 26000 | 7.2
2022-03-05 00:00:00 | Paris | S2 | 159 | 100 | 20
2022-01-14 00:00:00 | Paris | S1 | 123 | 10 | 13
2022-01-14 00:00:00 | Paris | S1 | 258 | 30 | 16.5 |  |  | should return 11,2 from F33
2022-01-14 00:00:00 | Paris | S1 | 258 | 60 | 11.2
2022-01-14 00:00:00 | Prague | S1 | 159 | 200 | 17
2022-01-14 00:00:00 | Prague | S1 | 456 | 100 | 7
2022-01-14 00:00:00 | Prague | S1 | 456 | 1000 | 4.5
2022-01-14 00:00:00 | Prague | S1 | 456 | 10000 | 2.1
2021-12-22 00:00:00 | Prague | S3 | 369 | 4500 | 11
2021-12-22 00:00:00 | Prague | S3 | 369 | 26000 | 6.3
2021-12-19 00:00:00 | London | S2 | 147 | 100 | 16
2021-12-19 00:00:00 | Paris | S2 | 123 | 20 | 10.6
2021-12-19 00:00:00 | Paris | S2 | 159 | 1000 | 12
2021-12-19 00:00:00 | Prague | S2 | 369 | 4500 | 11
2021-12-19 00:00:00 | Prague | S2 | 369 | 10000 | 9.1
2021-12-19 00:00:00 | Prague | S2 | 369 | 26000 | 8.2
2021-12-19 00:00:00 | Paris | S2 | 159 | 100 | 16.5
Spreadsheet: 843787d1695636410-values-rank-occurrence-based-summarised-by-rank-v2-rank-summary-aligw
Sheet: Foglio1

 | Problem: Given a list of  valus and their rank based on their occurrences
 | show a TOP-DOWN summary of ranks and corresponding values
 |  |  |  |  |  |  |  |  |  |  |  | NOW I'm using the italian version of the newly bought OFFICE 2021 Prof. Plus
 | Values | [NAME] |  |  | Rank |  | Multiple (unwanted)  correspondents |  | Desired single corresp. Rank | Desired single corresp. Pair |  | Summary OK but NO TOP-DOWN !
 | 1417 |  |  |  |  |  |  |  | 4 | 1215 |  |  | 1215 | M6 now amended to  -----> |  |  | =CONTA.SE($B$6:$B$15,N6#)
 | 1215 |  |  |  |  |  |  |  | 2 | 1417 |  | 2 | 1417 |  |  |  | Result: | still no TOP-DOWN!
 | 1523 |  |  |  |  |  |  |  | 1 | 1523 |  | 1 | 1523
 | 1215 |  |  |  |  |  |  |  | 1 | 3144 |  | 1 | 3144
 | 3144 |  |  |  |  |  |  |  | 1 | 7788 |  | 1 | 7788
 | 1417 |  |  |  |  |  |  |  | 1 | 3355 |  | 1 | 3355
 | 1215
 | 7788
 | 3355
 | 1215
Spreadsheet: sally_beck__36212__Weekly Operating Report 5-30
Sheet: EIM Volumes

[NAME] | APRIL |  |  |  | MAY
 | Week Ending 18 |  | Week Ending 25 |  | Week Ending 2 |  | Week Ending 9 |  | Week Ending 16 |  | Week Ending 23 |  | Week Ending 30
 | EOL | Non-EOL | EOL | Non-EOL | EOL | Non-EOL | EOL | Non-EOL | EOL | Non-EOL | EOL | Non-EOL | EOL | Non-EOL
Financial
EIM
Lumber - MBFs | 0 | 6600 | 0 | 62810 | 0 | 11220 | 200 | 5500 | 0 | 32750 | 0 | 5500 | 0 | 7810
Newsprint - MT | 0 | 19000 | 0 | 0 | 36000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Pulp (recycled paper) - MT | 0 | 0 | 0 | 185536 | 0 | 97174 | 0 | 120 | 0 | 7059 | 0 | 145036 | 0 | 6720
Steel - MT |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
Physical
EIM
Lumber - MBFs | 88 | 10071.335 | 440 | 19621.455 | 458 | 14842.525 | 621 | 11552.853 | 528 | 16196.929 | 220 | 14424.014 | 22 | 9344.268
Newsprint - MT | 1500 | 5452 | 40 | 4960 | 0 | 5496 | 1500 | 41980 | 40 | 6140 | 0 | 12570 | 1000 | 1660
Pulp (recycled paper) - MT | 227 | 5299 | 662 | 16406 | 0 | 73018 | 1723 | 15584 | 2264 | 4567 | 480 | 10029 | 454 | 16769
Steel - MT |  |  |  |  |  |  |  |  | 0 | 2758 | 0 | 6549.8396 | 0 | 5586
Total Financial & Physical
Lumber - Converted
Newsprint - MT
Pulp (recycled paper) - MT
Steel - MT
 |  |  |  |  |  |  |  |  |  |  |  | exchange
Spreadsheet: 722653d1615360272-highlight-a-cell-in-a-row-based-on-the-current-sum-of-that-series-bonus-based-on-hours-worked-ans
Sheet: CopyPaste

Employee | Total Hours | Previous Progress | New Progress
[NAME] | 59.43
[NAME] | 81.84
[NAME] | 22.7
[NAME] | 20.03
[NAME] | 44.13
[NAME] | 41.3
[NAME] | 59.17
[NAME] | 72.23
[NAME] | 72.63
[NAME] | 31.2
Spreadsheet: darrell_schoolcraft__7760__imbalsumm0105
Sheet: Citizens-Griffith

 | Citizens-Griffith
 | POI 78069 - Citizens Griffith
Day | Measured | Scheduled
1
2
3
4
5
6
7
8
9
10 | -415
11 |  | -5116
12 | -910 | -21360
13 | -348 | -42302
14 | -3919 | -7808
15 | -1031 | -3637
16 |  | -9375
17
18 | -6856 | -2494
19 | -15915 | -45000
20 | -21225 | -5000
21 | -30111 | -30000
22 | -31779 | -44840
23 | -6099 | -17500
24 | -11652 | -17500
25 | -1020 | -11667
26 | -22493 | -6667
27 | -33194 | -35000
28 | -29826 | -20000
29 | -11924 | -30000
30 | -9350 | -15000
31 | -10905 | -7854
2001-04-30 00:00:00 |  |  | 506028.01
2001-05-31 00:00:00
Spreadsheet: 870654d1717130634-list-up-the-sheet1-to-sheet2-depend-on-condition-list-pump-use-2-4-
Sheet: WORKER 2

 | payee : | worker 2
no | location | customer | Status | quantity
Spreadsheet: 134317d1325192402-vlookup-based-on-two-different-search-factors-but-how-workbook1
Sheet: Sheet1

 | Reference | 2011-11-01 00:00:00 | 2011-12-01 00:00:00
Payment type 1 | 567
Payment type 2 | 345678
The yellow cells above need search for the references displayed in Column C3 and C4 in the statement below and then display the appropriate debit number in the yellow box. How do I do that?? :(
Statement
Date | Description | Credit | Debit
2011-11-01 00:00:00 | Payment ref 1243 | 0 | -99
2011-11-02 00:00:00 | Paypal 567 | 0 | -67
2011-12-05 00:00:00 | Barclays 987654 | 0 | -78
2011-12-10 00:00:00 | [NAME] Lota | 0 | -123
Spreadsheet: 224478d1364579779-how-to-choose-strongest-anchor-from-two-columns-anchors_1
Sheet: Sheet1

Method 1 | Method 2 | Answer |  |  | *Anchors (from weaker to stronger)
SRA 36x690 | SRA 42x840 |  |  |  | SRA 12x195 | 1
SRA 36x690 | SRA 42x840 |  |  |  | SRA 14x235 | 2
SRA 36x690 | SRA 36x690 |  |  |  | SRA 16x275 | 3
SRA 52x950 | SRA 36x690 |  |  |  | SRA 18x305 | 4
SRA 52x950 | SRA 52x950 |  |  |  | SRA 20x360 | 5
SRA 36x690 | SRA 42x840 |  |  |  | SRA 24x400 | 6
SRA 36x690 | SRA 36x690 |  |  |  | SRA 30x505 | 7
SRA 36x690 | SRA 36x690 |  |  |  | SRA 36x690 | 8
SRA 36x690 | SRA 42x840 |  |  |  | SRA 42x840 | 9
SRA 30x505 | SRA 36x690 |  |  |  | SRA 52x950 | 10
Spreadsheet: 679724d1590599543-index-match-table-indexmatchexample-simple
Sheet: Sheet1

fruit | Min Quantity1 | price1 | Min Quantity2 | Price2 | Min quantity3 | Price3
Mango | 10 | 75 | 25 | 70 | 100 | 60
[NAME] | 10 | 100 | 25 | 95 | 100 | 80
Apple | 10 | 125 | 25 | 120 | 100 | 105
Pear | 10 | 150 | 25 | 145 | 100 | 125
 |  |  |  |  | QTY REFERENCE
 |  | FRUIT | Mango |  | QTY | PRICE
 |  | QTY | 100 |  | 1 | Price1
 |  | PRICE |  |  | 25 | Price2
 |  | PRICE |  |  | 100 | Price3
Spreadsheet: 148767d1333550338-conditional-lookup-from-a-list-difficult-formula-needed-sample_ginge_solved
Sheet: Tract Calc

 |  |  |  |  |  | Lease | Tract | Fractional Interest | NMA | ABC | DEF | GHI | JKL | MNO | PQR | STU | VWX | Y | Z | Election
Tract Acreage |  |  |  |  |  | 20 | 1 | 0.5 | 80
1 | 160 |  |  |  |  | unleased | 1 | 0.25 | 40
2 | 160 |  |  |  |  | 34 | 1 | 0.078125 | 12.5
3 | 160 |  |  |  |  | unleased | 1 | 0.078125 | 12.5
4 | 80 |  |  |  |  | 16 | 1 | 0.0625 | 10
5 | 80 |  |  |  |  | 8 | 1 | 0.015625 | 2.5
 | 640 |  |  |  |  | 7 | 1 | 0.015625 | 2.5
 |  |  |  |  |  | 10 | 2 | 0.25 | 40
 |  |  |  |  |  | 21 | 2 | 0.09375 | 15
 |  |  |  |  |  | 22 | 2 | 0.07291666666666667 | 11.66666666666667
 |  |  |  |  |  | 4 | 2 | 0.125 | 20
 |  |  |  |  |  | 11 | 2 | 0.125 | 20
 |  |  |  |  |  | 17 | 2 | 0.1666666666666667 | 26.66666666666666
 |  |  |  |  |  | 6 | 2 | 0.08333333333333333 | 13.33333333333333
 |  |  |  |  |  | 5 | 2 | 0.08333333333333333 | 13.33333333333333
 |  |  |  |  |  | unleased | 3 | 0.00625 | 1
 |  |  |  |  |  | 19 | 3 | 0.03125 | 5
 |  |  |  |  |  | unleased | 3 | 0.03515625 | 5.625
 |  |  |  |  |  | 23 | 3 | 0.0625 | 10
 |  |  |  |  |  | unleased | 3 | 0.0625 | 10
 |  |  |  |  |  | unleased | 3 | 0.052734375 | 8.4375
 |  |  |  |  |  | unleased | 3 | 0.052734375 | 8.4375
 |  |  |  |  |  | 35 | 3 | 0.0234375 | 3.75
 |  |  |  |  |  | 12 | 3 | 0.01041666666666667 | 1.666666666666667
 |  |  |  |  |  | 14 | 3 | 0.01041666666666667 | 1.666666666666667
 |  |  |  |  |  | 13 | 3 | 0.01041666666666667 | 1.666666666666667
 |  |  |  |  |  | 2 | 3 | 0.3125 | 50
 |  |  |  |  |  | 3 | 3 | 0.05625 | 9
 |  |  |  |  |  | 15 | 3 | 0.0625 | 10
 |  |  |  |  |  | 33 | 3 | 0.0625 | 10
 |  |  |  |  |  | 26 | 3 | 0.03125 | 5
 |  |  |  |  |  | 31 | 3 | 0.03125 | 5
 |  |  |  |  |  | 25 | 3 | 0.03125 | 5
 |  |  |  |  |  | 24 | 3 | 0.0078125 | 1.25
 |  |  |  |  |  | 30 | 3 | 0.0078125 | 1.25
 |  |  |  |  |  | 29 | 3 | 0.0078125 | 1.25
 |  |  |  |  |  | 28 | 3 | 0.00390625 | 0.625
 |  |  |  |  |  | 27 | 3 | 0.00390625 | 0.625
 |  |  |  |  |  | unleased | 3 | 0.0234375 | 3.75
 |  |  |  |  |  | 1 | 4 | 0.5 | 40
 |  |  |  |  |  | unleased | 4 | 0.375 | 30
 |  |  |  |  |  | unleased | 4 | 0.0625 | 5
 |  |  |  |  |  | 9 | 4 | 0.03125 | 2.5
 |  |  |  |  |  | 32 | 4 | 0.015625 | 1.25
 |  |  |  |  |  | 18 | 4 | 0.015625 | 1.25
 |  |  |  |  |  | 1 | 5 | 1 | 80
Spreadsheet: 15eeee22-a2d2-49c5-a6e3-95cf22d74731
Sheet: Summary Huila

PRESUPUESTO ENTIDADES EJECUTORAS
HUILA
Nombre Entidad Ejecutora:
Detalle | Presupuesto  Total | Tope Presupuestal
[NAME]
Monitoreo y Evaluación
[NAME] y [NAME]
Total Rubros de Funcionamiento
[NAME]
Total Destinación Específica
PRESUPUESTO TOTAL
XXXXXX
REPRESENTANTE LEGAL
Spreadsheet: 745566d1630001936-calculate-fiscal-year-based-on-todays-date-fiscal-year
Sheet: Sheet1

 | Your date | Client Year Start | Client Year
 | 2021-06-30 00:00:00 | 2021-01-01 00:00:00
 |  | 2021-11-11 00:00:00
 |  | 2021-03-03 00:00:00
Spreadsheet: 165429d1341230306-pull-unique-values-based-on-adjacent-column-0aunique-lists-by-one-criterion
Sheet: Sheet1

Area | Value |  | Helper | Area 1 | Area 2 | Area 3 | Area 4
Area 1 | Value 3
Area 4 | Value 35
Area 3 | Value 7
Area 4 | Value 25
Area 1 | Value 20
Area 2 | Value 21
Area 3 | Value 17
Area 2 | Value 34
Area 3 | Value 20
Area 4 | Value 38
Area 3 | Value 4
Area 1 | Value 5
Area 3 | Value 23
Area 4 | Value 31
Area 2 | Value 25
Area 4 | Value 36
Area 2 | Value 21
Area 2 | Value 21
Area 3 | Value 16
Area 3 | Value 10
Area 2 | Value 4
Area 1 | Value 28
Area 2 | Value 28
Area 4 | Value 24
Area 1 | Value 19
Area 4 | Value 34
Area 1 | Value 18
Area 3 | Value 19
Area 4 | Value 27
Area 1 | Value 21
Area 2 | Value 29
Area 4 | Value 32
Area 3 | Value 12
Area 1 | Value 22
Area 2 | Value 1
Area 3 | Value 6
Area 1 | Value 21
Area 1 | Value 4
Area 1 | Value 21
Area 3 | Value 5
Area 4 | Value 37
Area 1 | Value 15
Area 1 | Value 21
Area 1 | Value 12
Area 4 | Value 26
Area 1 | Value 21
Area 1 | Value 8
Area 3 | Value 15
Area 3 | Value 11
Area 2 | Value 3
Area 3 | Value 14
Area 1 | Value 21
Area 3 | Value 21
Area 2 | Value 32
Area 1 | Value 9
Area 4 | Value 33
Area 3 | Value 9
Area 3 | Value 22
Area 1 | Value 28
Area 2 | Value 2
Area 1 | Value 13
Area 4 | Value 28
Area 4 | Value 29
Area 3 | Value 13
Area 4 | Value 30
Area 2 | Value 28
Area 3 | Value 18
Area 1 | Value 16
Area 2 | Value 28
Area 2 | Value 30
Area 3 | Value 8
Spreadsheet: 776314d1649684109-conditional-formating-based-on-cell-value-test-1-etaf
Sheet: PowerQuery Factures

[NAME] |  |  |  |  | [NAME] (oudated)
Source.Name | Date de facturation | Numéro de facture | Quarter |  | Source.Name | Date de facturation | Numéro de facture | Quarter
Facture 2022-001.xlsm | 2022-01-12 00:00:00 | 2022-001 |  |  | Facture 2021-007.xlsx | 2021-11-29 00:00:00 | 2021-007
Facture 2022-002.xlsm | 2022-01-12 00:00:00 | 2022-002 |  |  | Facture 2021-008.xlsx | 2021-11-29 00:00:00 | 2021-008
Facture 2022-003.xlsm | 2022-01-12 00:00:00 | 2022-003
Facture 2022-004.xlsm | 2022-02-21 00:00:00 | 2022-004
Facture 2022-005.xlsm | 2022-03-10 00:00:00 | 2022-005
Facture 2022-006.xlsm | 2022-04-01 00:00:00 | 2022-006
Facture 2022-007.xlsm | 2022-04-01 00:00:00 | 2022-007
Spreadsheet: 840000d1692352145-formula-for-populating-monthly-direct-debit-payments-dd-query
Sheet: Direct Debits

Office:
Actuals to:
Currency | £
Day Lookup
week lookup
month lookup
Week number
Month Number
Year
Week Ending |  |  | Frequency of |  |  | 2023-07-29 00:00:00
 |  |  | payment if
 |  |  | not monthly
Total Direct Debits | Reference |  | Every x Months |  | Amount
Forecast
Same day every month
 | Test | 2023-08-31 00:00:00 |  |  | 822
Every x months excluding monthend
 | Test | 2023-08-29 00:00:00 | 2 |  | 822
Every x months on last day of the month
 | Test | 2023-07-31 00:00:00 | 2 |  | 822
Payments that fall on a Saturday/Sunday are moved to Monday
 | Test | 2023-08-30 00:00:00 |  |  | 822
Spreadsheet: 92806d1292349650-create-master-file-tempmapping_sheet-1-
Sheet: Data

LDAB_Ref | Attributes | Value | List in Master LDAP
LDAP1 | givenname | [NAME] | yes
LDAP1 | sn | Doe | yes
LDAP1 | mail | [EMAIL] | yes
LDAP1 | phonenumber | 123 | no
LDAP1 | alternatemail | [EMAIL] | yes
LDAP1 | alternatephonenumber | 12345 | yes
LDAP1 | fax | 23456 | yes
LDAP1 | postalCode | Houston | yes
[NAME] | givenname | [NAME]
[NAME] | sn | Smith | yes
[NAME] | mail | [EMAIL] | yes
[NAME] | phonenumber | 4567 | yes
[NAME] | alternatemail | [EMAIL] | yes
[NAME] | alternatephonenumber | 6789 | yes
[NAME] | fax | fax | yes
[NAME] | work city | work city | yes
LDAP3 | givenname | [NAME] | yes
LDAP3 | sn | Latimer | yes
LDAP3 | mail | [EMAIL] | yes
LDAP3 | phonenumber | 9876
LDAP3 | alternatemail | [EMAIL] | yes
LDAP3 | alternatephonenumber | 357 | yes
LDAP3 | fax | 367 | yes
LDAP3 | businessCategory | Dentist | yes
Spreadsheet: 0e26dee2-3d59-4bf4-8733-b59e20dedf48
Sheet: Name merging

KEGG ID | Name of metabolite in model | KEGG ID | Name of metabolite in model | Name of metabolite used in model
C02336 | beta-D-Fructose | C00095 | D-Fructose | beta-D-Fructose
C05345 | beta-D-Fructose 6-phosphate | C00085 | D-Fructose 6-phosphate | beta-D-Fructose 6-phosphate
C00025 | L-Glutamate | C00302 | DL-Glutamate | L-Glutamate
[NAME] | alpha-D-Glucose 6-phosphate | C00092 | D-Glucose 6-phosphate | alpha-D-Glucose 6-phosphate
C00267 | alpha-D-Glucose | C00031 | D-Glucose | alpha-D-Glucose
C05378 | beta-D-Fructose 1,6-bisphosphate | C00354 | D-Fructose 1,6-bisphosphate | beta-D-Fructose 1,6-bisphosphate
C06001 | (S)-3-Hydroxyisobutyrate | C01188 | 3-Hydroxyisobutyrate | (S)-3-Hydroxyisobutyrate
C06002 | (S)-Methylmalonate semialdehyde | [NAME] | Methylmalonate semialdehyde | (S)-Methylmalonate semialdehyde
C15977 | S-(2-Methylpropionyl)-dihydrolipoamide-E | C04424 | S-(2-Methylpropanoyl)-dihydrolipoamide | S-(2-Methylpropionyl)-dihydrolipoamide-E
C15975 | [NAME] | C05119 | [NAME] | [NAME]
C15979 | S-(2-Methylbutanoyl)-dihydrolipoamide-E | C05118 | S-(2-Methylbutanoyl)-dihydrolipoamide | S-(2-Methylbutanoyl)-dihydrolipoamide-E
C16255 | S-Acetyldihydrolipoamide-E | C01136 | S-Acetyldihydrolipoamide | S-Acetyldihydrolipoamide-E
Spreadsheet: d5268c5a-d39b-493e-ae3d-0bdf87b10476
Sheet: BU10

Date | Day | Start Time | Field | Home | Visitor |  | Date | Day | Start Time | Field | Home | Visitor
2013-02-10 00:00:00 | Sunday | 11:00AM | PVF 19 | 104 | 101 |  | 2013-03-10 00:00:00 | Sunday | 11:00AM | PVF 19 | 104 | 106
2013-02-10 00:00:00 | Sunday | 12:15PM | PVF 19 | 106 | 102 |  | 2013-03-10 00:00:00 | Sunday | 12:15PM | PVF 19 | 103 | 102
2013-02-10 00:00:00 | Sunday | 1:30PM | PVF 19 | 105 | 103 |  | 2013-03-10 00:00:00 | Sunday | 1:30PM | PVF 19 | 105 | 101
2013-02-17 00:00:00 | Sunday | 11:00AM | PVF 19 | 101 | 102 |  | 2013-03-17 00:00:00 | Sunday | 11:00AM | PVF 19 | 104 | 101
2013-02-17 00:00:00 | Sunday | 12:15PM | PVF 19 | 106 | 103 |  | 2013-03-17 00:00:00 | Sunday | 12:15PM | PVF 19 | 106 | 102
2013-02-17 00:00:00 | Sunday | 1:30PM | PVF 19 | 105 | 104 |  | 2013-03-17 00:00:00 | Sunday | 1:30PM | PVF 19 | 105 | 103
2013-02-24 00:00:00 | Sunday | 11:00AM | PVF 19 | 102 | 104 |  | 2013-04-07 00:00:00 | Sunday | 11:00AM | PVF 19 | 101 | 102
2013-02-24 00:00:00 | Sunday | 12:15PM | PVF 19 | 101 | 103 |  | 2013-04-07 00:00:00 | Sunday | 12:15PM | PVF 19 | 106 | 103
2013-02-24 00:00:00 | Sunday | 1:30PM | PVF 19 | 106 | 105 |  | 2013-04-07 00:00:00 | Sunday | 1:30PM | PVF 19 | 105 | 104
2013-03-03 00:00:00 | Sunday | 11:00AM | PVF 19 | 103 | 104 |  | 2013-04-14 00:00:00 | Sunday | 11:00AM | PVF 19 | 102 | 104
2013-03-03 00:00:00 | Sunday | 12:15PM | PVF 19 | 102 | 105 |  | 2013-04-14 00:00:00 | Sunday | 12:15PM | PVF 19 | 101 | 103
2013-03-03 00:00:00 | Sunday | 1:30PM | PVF 19 | 101 | 106 |  | 2013-04-14 00:00:00 | Sunday | 1:30PM | PVF 19 | 106 | 105
Spreadsheet: 275480d1383541988-if-statement-woes-ihateyouexcel
Sheet: Test

2014-01-01 00:00:00 | 2014-02-01 00:00:00 | 2014-03-01 00:00:00 | 2014-04-01 00:00:00 | 2014-05-01 00:00:00 | 2014-06-01 00:00:00 | 2014-07-01 00:00:00 | 2014-08-01 00:00:00 | 2014-09-01 00:00:00 | 2014-10-01 00:00:00 | 2014-11-01 00:00:00 | 2014-12-01 00:00:00
Spreadsheet: 759057d1639266151-reporting-sum-of-all-sheets-into-a-master-sheet-example
Sheet: Sheet2

Some text/data | Some text/data | Some text/data |  |  |  |  | 2021-01-22 00:00:00
 |  | Date | 2021-12-06 00:00:00
 | Some text/data in this row | [NAME]
 | Some text/data in this row | [NAME]
 | Some text/data in this row | [NAME]
 | Some text/data in this row | [NAME]
 | Some text/data in this row | [NAME]
 | Some text/data in this row | Weekly summary | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
Protocol | Some text/data in this column | Some text/data in this column | Number of chickens
420065.1 |  |  | 1
420102.1
421012.1 |  |  | 0.25 | 0.5 |  |  |  |  | 7
420076.1 |  |  |  |  |  | 4
420051.1 |  |  | 0.25 | 0.25
421063.1 |  |  |  |  |  |  | 7 |  |  |  | 5
419078.1 |  |  |  | 0.1
421038.1 |  |  | 0.25
421053.1 |  |  |  |  |  |  |  |  |  | 7
420054.1 |  |  |  |  |  |  |  | 44
420139.1
421001.1 |  |  |  | 7
421003.1 |  |  |  | 4 |  | 4 |  | 11
421068.1 |  |  | 0.5 | 0.5 |  |  |  | 8 |  |  | 5
421082.1
421084.1 |  |  |  | 44 |  |  |  |  |  | 5
421085.1 |  |  |  |  | 1
421023.1 |  |  |  |  |  | 5
421071.1
420044.1 |  |  | 1
421096.1 |  |  |  |  |  | 5 |  |  | 1
421097.1
421104.1 |  |  |  |  |  |  |  |  |  | 9
421110.1 |  |  | 0.5 | 1
421105.1 |  |  | 0.5 | 1
621091.1
421117.1 |  |  | 0.25
421118.1 |  |  | 0.25 |  |  |  |  | 1
421126.1
Spreadsheet: 49124d1248378512-lookup-list-function-employee_reg
Sheet: Statement

 |  | PTO Schedule
 |  | Employee: |  | Heather
 |  | 2009 Entitlement: |  |  | 20
 |  | PTO Taken/Pending:
 |  | Date |  |  | Days
 |  |  | 2009-02-27 00:00:00 |  | 1
 |  |  | 2009-04-02 00:00:00 |  | 0.5
 |  |  | 2009-04-03 00:00:00 |  | 1
 |  |  | 2009-05-01 00:00:00 |  | 1
 |  |  | 2009-08-03 00:00:00 |  | 1
 |  |  | 2009-08-04 00:00:00 |  | 1
 |  |  | 2009-08-05 00:00:00 |  | 1
 |  |  | 2009-08-06 00:00:00 |  | 1
 |  |  | 2009-08-07 00:00:00 |  | 1
 |  | PTO Taken/Pending |  |  | 8.5
 |  | 2009 Remaining Entitlement: |  |  | 11.5