tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 770385d1646044606-calculate-how-many-days-people-have-from-start-date-until-end-date-from-month-to-month-enddate-aligw-1-
Sheet: English (2)

September |  |  |  |  | Calculation date
 |  | Start date | End date |  | 2021-09-30 00:00:00 | The correct answer would be
 | Anne | 2021-01-01 00:00:00
 | Nina |  | 2021-09-30 00:00:00
 | [NAME] | 2021-03-01 00:00:00 | 2021-08-01 00:00:00
 | [NAME] | 2021-08-07 00:00:00 | 2021-10-31 00:00:00
 | [NAME] |  |  |  | 0
 | Sigrid | 2021-09-09 00:00:00 | 2021-11-30 00:00:00
 | [NAME] | 2019-03-31 00:00:00 | 2021-09-02 00:00:00
 | Heida | 2021-09-02 00:00:00
 | Sandra | 2021-10-03 00:00:00 | 2021-12-31 00:00:00 |  |  | 0 |  |  | 1. If a start date has started the take it in the calculation
 | Eva | 2022-11-03 00:00:00 |  |  |  | 0 |  |  | 2. If neither [NAME] date nor End date is available  then =0
 |  |  |  |  |  |  |  |  | 3. If there is a Start date that has not started then =0
Oktobere |  |  |  |  |  |  |  |  | 4. If there is no [NAME] date but only End date then only consider End date
 |  | Upphafsdagur | Lokadagur |  | 2021-10-31 00:00:00 | The correct answer would be
 | Anne | 2021-01-01 00:00:00 |  |  |  |  | =MAX(MIN(IF(OR(D3="";AND(D3<=Calcul_9;D3-Calcul_9>30));30;-((Calcul_9-30)-D3));30);0)
 | Nina |  | 2021-09-30 00:00:00 | 0 |  |  | =MIN(30;MAX(0;1+MIN(Calcul_9;$D3)-MAX($C3;EOMONTH(Calcul_9;-1)+1))*SIGN(COUNT($C3:$D3)))
 | [NAME] | 2021-03-01 00:00:00 | 2021-08-01 00:00:00 | 0
 | [NAME] | 2021-08-07 00:00:00 | 2021-10-31 00:00:00 | 30
 | [NAME] |  |  | 0
 | Sigrid | 2021-09-09 00:00:00 | 2021-11-30 00:00:00 | 30
 | [NAME] | 2019-03-31 00:00:00 | 2021-09-02 00:00:00 | 0
 | Heida | 2021-09-02 00:00:00 |  | 30
 | Sandra | 2021-10-03 00:00:00 | 2021-12-31 00:00:00 | 28
 | Eva | 2022-11-03 00:00:00 |  | 0
November
 |  | Upphafsdagur | Lokadagur |  | 2021-11-30 00:00:00 | The correct answer would be
 | Anne | 2021-01-01 00:00:00
 | Nina |  | 2021-09-30 00:00:00
 | [NAME] | 2021-03-01 00:00:00 | 2021-08-01 00:00:00
 | [NAME] | 2021-08-07 00:00:00 | 2021-10-31 00:00:00
 | [NAME]
 | Sigrid | 2021-09-09 00:00:00 | 2021-11-30 00:00:00
 | [NAME] | 2019-03-31 00:00:00 | 2021-09-02 00:00:00
 | Heida | 2021-09-02 00:00:00
 | Sandra | 2021-10-03 00:00:00 | 2021-12-31 00:00:00
 | Eva | 2021-11-03 00:00:00
Spreadsheet: 45123d1243894128-creating-a-list-of-selected-items-from-an-order-sheet-sample-order-form
Sheet: Sheet1

UPC | PK | SIZE | ITEM | CASE PACK | Movement | Cost | Order |  |  | Transfer Key
8265733412 | 270 | 3 LITER | DEER PARK 3 LTR | 1 | 50.95 | 1.25 |  |  |  | 0
8265763111 | 1 | 700 ML | DEER PARK SPORTS  CAP | 28 | 20.45 | 7.99 | 2 |  |  | 1
8265750406 | 1 | 16.9 OZ | DEER PARK SPRING WATER | 24 | 16.6 | 4.29 |  |  |  | 1
8265755561 | 1 | 16.9 OZ. | DEER PARK SPRING WATER | 32 | 144.3 | 5.39 | 1 |  |  | 2
8265750560 | 1 | GAL | DEER PARK SPRING WATER | 6 | 23.8 | 6.49 |  |  |  | 2
8265771002 | 1 | 700 ML | DEER PARK SPRING WATER | 24 | 70.1 | 7.49 |  |  |  | 2
8265750562 | 1 | 1.5LTR | DEER PARK SPRING WATER | 12 | 8.2 | 8.75 | 3 |  |  | 3
8265791439 | 1 | 1 LITER | DEER PARK WATER 1 LITER | 18 | 22.45 | 9.45 |  |  |  | 3
Spreadsheet: 822560d1679416007-match-person-based-on-date-postcode-to-a-location-date-postcode-copy-of-v-matchmaker-1-
Sheet: Result

Date | Location | Person | Postcode | [NAME]
Spreadsheet: 269a5c7a-4b1d-482b-bdd9-b73b6e460288
Sheet: Directions

2011-2012 Work Study [NAME]
Total Work  Study Award: |  |  |  |  |  | 1500
PP # | Begin | End | Pay Rate | Hours | Gross Pay | Award remaining
11 | 2011-08-18 00:00:00 | 2011-08-31 00:00:00 | 7.25 | 14. |  |  |  | TOTAL AWARD REMAINING
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
1
2
3
4
Spreadsheet: 80914d1281087171-interactive-chart-climate_data
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | Data to Plot
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | TemperatureData
 |  |  |  |  |  |  |  |  | Select the cities
 |  |  |  |  |  |  |  |  | FARGO, ND
 |  |  |  |  |  |  |  |  | HONOLULU,HI
 | Average Temperature
 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
FARGO, ND | 6.8 | 14.1 | 27.2 | 43.5 | 57.4 | 66 | 70.6 | 69 | 58 | 45.3 | 27 | 12.5
HONOLULU,HI | 73 | 73 | 74.3 | 75.6 | 77.2 | 79.5 | 80.8 | 81.8 | 81.5 | 80.2 | 77.7 | 74.8
Spreadsheet: 739648d1625842319-formula-for-progressive-tax-rate-tax-calc-forum
Sheet: tariff

Progressive tax tariff
 | threshold | rate | difference
below or = | 10000 | 0
above | 10000 | 0.01
above | 20000 | 0.02
above | 30000 | 0.03
above | 40000 | 0.04
Calc. Example:
income | 10000 | 20000 | 30000 | 40000 | 50000
tax | 0 | 100 | 300 | 600 | 1000
tax computation manually. this is what the formula should be able to calculate
 | 50000
Spreadsheet: 151962d1335198032-extract-word-from-alphanumeric-string-getalphanumeric
Sheet: Sheet1

12345Curt Connely7890 | Curt Connely
584Carl Carlton9874456 | [NAME]
61235467123546Christopher Corey123564234 | [NAME]
AB12 | AB
BDF45 | BDF
RL4 | RL
MTQ345 | MTQ
V5 | V
12345Curt Connely7890 | 123457890
584Carl Carlton9874456 | [PHONE]
61235467123546Christopher Corey123564234 | 61235467123546123564234
AB12 | 12
BDF45 | 45
RL4 | 4
MTQ345 | 345
V5 | 5
Spreadsheet: 867984d1714716081-network-days-formula-not-handling-cases-when-start-date-is-weekend-calculating-time-duration-in-between-working-hours
Sheet: Start and end times

A | B |  |  |  | St time | End time |  |  |  |  |  | Holidays
2024-06-23 07:48:30 | 2024-06-24 09:09:11 |  |  |  | 08:00:00 | 18:00:00 |  |  |  |  |  | 2023-05-07 00:00:00
2024-06-22 07:48:30 | 2024-06-22 09:09:11 |  |  |  |  |  |  |  |  |  |  | 2023-08-05 00:00:00
2024-06-27 07:48:30 | 2024-06-29 09:09:11
2024-06-27 07:48:00 | 2024-06-27 09:09:11
2024-06-20 17:48:30 | 2024-06-29 09:09:11
2024-06-18 12:30:00 | 2024-06-23 09:30:00
2024-06-20 12:30:00 | 2024-06-24 09:30:00
2024-01-18 12:33:00 | 2024-01-21 09:30:00
2024-01-20 12:33:00 | 2024-01-21 09:30:00
2024-01-18 12:30:00 | 2024-01-19 09:30:00
2024-06-27 07:48:30 | 2024-06-29 09:09:11
2024-05-10 07:48:00 | 2024-05-13 07:09:00
Spreadsheet: phillip_m_love__31188__NICOR-rec
Sheet: 5-00

 | Fee | Supply |  |  |  |  | Sales |  |  |  |  | [NAME] | NICOR |  |  | Balancing fee based on daily value that is moving balance furthest from zero
Date | Type | Point | Deal # | Volume | Rate | Total | Point | Deal # | Volume | Rate | Total |  | Volume | Rate | Explanation | Supply = Delivery of Gas by HUB
2000-05-23 00:00:00 | Wheeling | NBPL | 255905 | 165 | 3.89 |  |  |  |  |  |  |  | 165 | 0.01 | Inv'd $1.65 | Sales = Receipt of Gas by HUB
 | Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] are pathed together
2000-05-01 00:00:00 | Balancing | NBPL | 255905 | 221 | 3.16 |  |  |  |  |  |  |  | 221
2000-05-12 00:00:00 | Balancing | NBPL | 255905 | 12 | 3.4 |  |  |  |  |  |  |  | 12
2000-05-01 00:00:00 | Balancing | NGPL | 255905 | 14547 | 3.16 |  |  |  |  |  |  |  | 14547
2000-05-02 00:00:00 | Balancing | NGPL | 255905 | 2000 | 3.19 |  |  |  |  |  |  |  | 2000
5/3-5/4 | Balancing | NGPL | 255905 | 13678 | 3.23 |  |  |  |  |  |  |  | 13678
2000-05-05 00:00:00 | Balancing | NGPL | 255905 | 1943 | 3.13 |  |  |  |  |  |  |  | 1943
5/7-5/8 | Balancing | NGPL | 255905 | 979 | 3.18 |  |  |  |  |  |  |  | 979
2000-05-10 00:00:00 | Balancing | NGPL | 255905 | 756 | 3.31 |  |  |  |  |  |  |  | 756
2000-05-12 00:00:00 | Balancing | NGPL | 255905 | 1703 | 3.4 |  |  |  |  |  |  |  | 1703
5/13-5/15 | Balancing | NGPL | 255905 | 10638 | 3.39 |  |  |  |  |  |  |  | 10638
5/21-5/22 | Balancing | NGPL | 255905 | 950 | 3.83 |  |  |  |  |  |  |  | 950
2000-05-24 00:00:00 | Balancing | NGPL | 255905 | 2107 | 3.89 |  |  |  |  |  |  |  | 2107
2000-05-25 00:00:00 | Balancing | NGPL | 255905 | 54 | 4.02 |  |  |  |  |  |  |  | 54
2000-05-30 00:00:00 | Balancing | NGPL | 255905 | 400 | 4.25 |  |  |  |  |  |  |  | 400
 | Total
2000-05-09 00:00:00 | Balancing |  |  |  |  |  | NGPL | 257324 | 1694 | 3.17 |  |  | 1694
2000-05-16 00:00:00 | Balancing |  |  |  |  |  | NGPL | 257324 | 344 | 3.45 |  |  | 344
2000-05-17 00:00:00 | Balancing |  |  |  |  |  | NGPL | 257324 | 6277 | 3.5 |  |  | 6277
2000-05-18 00:00:00 | Balancing |  |  |  |  |  | NGPL | 257324 | 145 | 3.54 |  |  | 145
2000-05-19 00:00:00 | Balancing |  |  |  |  |  | NGPL | 257324 | 28 | 3.8 |  |  | 28
2000-05-23 00:00:00 | Balancing |  |  |  |  |  | NGPL | 257324 | 15000 | 4.01 |  |  | 14835
2000-05-26 00:00:00 | Balancing |  |  |  |  |  | NGPL | 257324 | 24372 | 4.25 |  |  | 24372
2000-05-28 00:00:00 | Balancing |  |  |  |  |  | NGPL | 257324 | 175 | 4.25 |  |  | 175
2000-05-29 00:00:00 | Balancing |  |  |  |  |  | NGPL | 257324 | 397 | 4.25 |  |  | 397
2000-05-31 00:00:00 | Balancing |  |  |  |  |  | NGPL | 257324 | 2848 | 4.44 |  |  | 2848
 | Total |  |  |  |  |  |  |  |  |  |  |  |  |  | Inv'd $65,284 @ $.09 = $5.875.56
5/1-5/31 | ???? |  |  |  |  |  | NBPL | 251807 | 465000 | 3.125
2000-05-02 00:00:00 | ???? |  |  |  |  |  | NGPL | 257350 | 7255 | 3.185
5/20-5/22 | ???? |  |  |  |  |  | NGPL | 273714 | 12609 | 3.78
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nicor total $5,877.21
Spreadsheet: 89915d1289663136-total-points-week-12-score
Sheet: Who's Paid

Name | Agent | Entry Paid
[NAME] | [NAME] | p
[NAME] | [NAME] | p
[NAME] | [NAME] | p
[NAME] | [NAME] | p
[NAME] | [NAME] | p
[NAME] | [NAME] | p
[NAME] | [NAME] | p
[NAME] | [NAME] | p
[NAME] | [NAME] | p
[NAME] | [NAME] | p
[NAME] | [NAME] | p
[NAME] | [NAME] | p
[NAME] | [NAME] | p
[NAME] | Stuart
0
0
0
0
0
0
Spreadsheet: 194065d1353025582-lock-fields-until-one-field-has-been-filled-in-sample-3-bb-
Sheet: sample

BEAM | WELD | WPS # | WELDER | DATE | NDT | C/DNC | CHECKED | PWHT # | PWHT Report # | HEAT # | HEAT # | W/ WIRE
# | # |  | ID | WELDED | REQUEST # |  |  |  |  | SHS | END PLATES | BATCH #
1 | 1 | 93-1
 | 2 | 93-1
2 | 1 | 93-1
 | 2 | 93-1
3 | 1 | 93-1
 | 2 | 93-1
Spreadsheet: 795675d1662835144-how-to-alternating-stack-a-range-into-a-column-alternatingly-per-stack-eight-column-into-one
Sheet: Sheet1

Source data-1 |  |  |  |  |  |  |  | Source data-2 |  |  |  |  |  |  |  | Source data-3
A |  | B |  |  |  | C |  | I |  |  | J | K
D |  | E |  |  |  | F |  | L |  |  | M | N
 |  | G |  |  |  | H |  | O |  |  | P
 | Desired Output
 | for Source data-1 | for Source data-2 | for Source data-3 | for Source data-4
 | A | I
 | B | J
 | C | K
 | D | L
 | E | M
 | F | N
 | G | O
 | H | P
Spreadsheet: 39414d1237563223-vlookup-and-concatenate-example
Sheet: Sheet1

 |  |  |  |  | Vlookup result | ACTUAL NEEDED RESULT
TP1 | 401493 |  |  | TP1 | 401493 | [NAME]
TP2 | 408523 |  |  | TP2 | 408523 | C21AC408523
TP3 | 406897 |  |  | TP3 | 406897 | Etc
TP4 | 405786 |  |  | TP4 | 405786 | Etc
I need the vlookup to add C21AC before the number
Also is it possible to lookup the number and add 1 then add C21AC
eg | 401493 would be C21AC40194
Spreadsheet: 859959d1708182229-xlookup-maybe-nested-indirect-and-excel-tables-to-get-value-sample-for-xlookup-indirect
Sheet: Main Sheet

Project | Column1 | Date |  | Project A Tasks | Date |  | Project B Tasks | Date
Project A | Task 1 |  |  | Task 1 | 2024-01-05 00:00:00 |  | Task 4 | 2023-12-12 00:00:00
Project A | Task 2 |  |  | Task 2 | 2024-01-20 00:00:00 |  | Task 5 | 2024-01-15 00:00:00
Project A | Task 3 |  |  | Task 3 | 2024-03-30 00:00:00 |  | Task 6 | 2024-02-28 00:00:00
Project B | Task 4
Project B | Task 5 |  |  | Table on "Proj A sheet" |  |  | Table on "Proj B sheet"
Project B | Task 6
Table on main sheet |  | Values above should be:
 | C2 | 2024-01-05 00:00:00
 | [NAME] | 2024-01-20 00:00:00
 | C4 | 2024-03-30 00:00:00
 | C5 | 2023-12-12 00:00:00
 | C6 | 2024-01-15 00:00:00
 | C7 | 2024-02-28 00:00:00
Spreadsheet: 675091d1588159377-automatically-email-individualized-reports-from-excel-email-sample-for-excel-forum-4-29-20
Sheet: Sheet1

 |  | Math |  | ELA |  | Sci |  |  |  | SS
Student | [NAME] | M1 | M2 | E1 | E2 | S1 | S2 | S3 | [NAME] | SS1 | SS2
Student 1 | email 1; email 2 | C
Student 2 | email 1; email 2 |  |  |  |  |  |  |  |  | C | C
Student 3 | email 1; email 2 |  |  | C | C
Student 4 | email 1; email 2 |  |  |  |  |  |  |  |  | A
Student 5 | email 1; email 2 |  | C |  |  |  |  |  |  | C | C
Student 6 | email 1; email 2
Student 7 | email 1; email 2 |  | A |  | A | A
Student 8 | email 1; email 2 |  |  |  |  |  |  |  | C
Student 9 | email 1; email 2 |  |  |  |  | A | C | A
Student 10 | email 1; email 2 | C |  |  |  |  |  |  |  | A
 |  | C = Completed
 |  | A = Attempted
 |  | (Blank) = Not turned in/Missing
Spreadsheet: 219908d1363011609-auto-reapply-autofilter-test
Sheet: Treatments

Detail No. | Quantity | [NAME] | Greasing | Cleansing | Rinsing | Type of Tank | Dying | Cooling | Turning | Heating | Blowing | Other | Total Time (hours) | NOTES
 | 0 |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  | 0
. |  |  |  |  |  |  |  |  |  |  | Grand Total |  | 0
Tanks
Phosphate
Zinc
Blacking
Spreadsheet: daren_farmer__6635__Texas Nat_Gas Ops 0200 O&M Report
Sheet: 2663Detail

[NAME] Class |  | Co |  |  |  | Work Order |  | Invoice # | Vendor# |  | [NAME] |  | Amount
1 | SALARIES AND WAGES
 |  | 12 | 9200 | 999 | 012-008-02 |  |  | SUMMARIZED | LD    0483 |  |  |  | 7871.65
 |  | 12 | 9200 | 999 | 012-008-01 |  |  | SUMMARIZED | LD    0483 |  |  |  | 7838.51
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]: | 15710.16
62 | OVERTIME/WORKING MEALS
 |  | 413 | 9210 | 999 | 2000021100 |  | MEALS |  | 0 |  |  |  | 26.42
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]: | 26.42
175 | PAGER / CELLULAR SYSTEMS
 |  | 413 | 9210 | 999 | 2000021100 |  | PAGER |  | 0 |  |  |  | 4.68
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]: | 4.68
552 | BENEFITS
 |  | 12 | 9260 | 999 | 012-008-02 |  |  | SUMMARIZED | LD    0483 |  |  |  | 459.94
 |  | 12 | 9260 | 999 | 012-008-01 |  |  | SUMMARIZED | LD    0483 |  |  |  | 429.11
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]: | 889.05
557 | PAYROLL TAXES
 |  | 12 | 4081 | 500 | 012-008-02 |  |  | SUMMARIZED | LD    0483 |  |  |  | 11.21
 |  | 12 | 4081 | 500 | 012-008-01 |  |  | SUMMARIZED | LD    0483 |  |  |  | 17.1
 |  | 12 | 4081 | 510 | 012-008-02 |  |  | SUMMARIZED | LD    0483 |  |  |  | 12.61
 |  | 12 | 4081 | 510 | 012-008-01 |  |  | SUMMARIZED | LD    0483 |  |  |  | 33.13
 |  | 12 | 4081 | 520 | 012-008-01 |  |  | SUMMARIZED | LD    0483 |  |  |  | 589.52
 |  | 12 | 4081 | 520 | 012-008-02 |  |  | SUMMARIZED | LD    0483 |  |  |  | 591.96
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]: | 1255.53
 |  |  |  |  |  |  |  |  |  |  |  |  | Field58: | 17885.84
Spreadsheet: 882813d1731297099-filter-vstack-multiple-tables-and-criteria-my-step-by-step-time-sheet-so-i-can-filter-_r3
Sheet: Nov

Trainer Name | Student name: (first name, last name) | What action have you taken? | Session date: | How was the training conducted? | Travel time costs (if any) | Travel mileage (if any) | What was training subject 1? (select from drop down list) | Training subject 1 - how much time () did you train on this today? (select from drop down list) | What was training subject 2? (select from drop down list) | Training subject 2 (if appropriate) - how much time (hours) did you train on this today? | What was training subject 3? (select from drop down list) | Training subject 3 (if appropriate) - how much time (hours) did you train on this today? | Ad-hoc fee - If you completed approved training or a service that is not on the list or is ad-hoc briefly summarise here. Include as much detail as is needed. | Rate | Count | Value
[NAME] | [NAME] | I have completed today's training | 2022-11-01 00:00:00 | Remote training via Zoom video conferencing |  |  | Unit 327 - Business Transactions | 1.5 |  |  |  |  |  | 31.5
[NAME] | [NAME] | I have completed today's training | 2022-11-01 00:00:00 | Remote training via Zoom video conferencing |  |  | Unit 327 - Business Transactions | 1.5 |  |  |  |  |  | 31.5
[NAME] | [NAME] | I am submitting a request for an ad-hoc payment | 2022-11-02 00:00:00 |  |  |  |  |  |  |  |  |  |  | 31.5 | 3
[NAME] | [NAME] | I have completed a student completion report and wish to claim for managing the timetable | 2022-11-10 00:00:00 |  |  |  |  |  |  |  |  |  |  | 60 | 1 | 60
[NAME] | [NAME] | I am submitting a request for an ad-hoc payment | 2022-11-10 00:00:00 |  |  |  |  |  |  |  |  |  | Tranch 1 | 31.5 | 10
[NAME] | [NAME] | I am submitting a request for an ad-hoc payment | 2022-11-10 00:00:00 |  |  |  |  |  |  |  |  |  | Tranch 2 | 31.5 | 5
[NAME] | [NAME] | I am submitting a request for an ad-hoc payment |  |  |  |  |  |  |  |  |  |  |  | 31.5 | 3
[NAME] | [NAME] | I have completed today's training | 2022-11-15 00:00:00 | Student to Trainer |  |  | MS Word | 2 |  |  |  |  |  | 31.5
[NAME] | [NAME] | I have completed today's training | 2022-11-17 00:00:00 | Student to Trainer |  |  | MS Word | 2 |  |  |  |  |  | 31.5
[NAME] | [NAME] | I have completed today's training | 2022-11-22 00:00:00 | Student to Trainer |  |  | [NAME] | 1 |  |  |  |  |  | 31.5
[NAME] | [NAME] | I have completed today's training | 2022-11-24 00:00:00 | Remote training via Zoom video conferencing |  |  | Keyboarding | 2 |  |  |  |  |  | 31.5
[NAME] | [NAME] | I have completed today's training | 2022-11-29 00:00:00 | Remote training via Zoom video conferencing |  |  | Internet Google Chrome | 2 |  |  |  |  |  | 31.5
Spreadsheet: 268027d1380369620-sum-of-cells-with-values-coming-from-a-if-formula-guias-de-remessa
Sheet: Ecomarché

SETEMBRO 2013
Produto  Dia | Bijou | Pão           de     Mistura | Pão            da    Avó | Padas | Trigo 3 Cantos | Cacetes     100g | Sêmeas              [NAME] 0,5Kg | Sêmeas                 Brancas 1Kg | Saloínhos | Cacetes                 Centeio     0,5Kg | Sêmeas                 Centeio    0,5Kg | Sêmeas                 Centeio     Kg | Broas    0,5Kg | Broas     Kg | Fermento | Bolo Rei | [NAME] | [NAME]
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
TOTAL
Spreadsheet: 887365d1737604188-due-dates-formula-for-month-end-close-calendar-month-end-close-due-dates
Sheet: Copy

Revenue Month End Closing Schedule
 | Day - Quarter | Day | Due Date | Frequency
 | 15th | -15 |  | Monthly |  |  | Day 1 of Feb Close
 | 15th | -15 |  | Monthly |  |  | Day 2 of Feb Close
 | 20th | -20 |  | Monthly |  |  | Day 3 of Feb Close
 | D -10 to -5 | -10 |  | Monthly |  |  | Day 4 of Feb Close
 | D -10 to -5 | -5 |  | Monthly
 | D -10 to -5 | -10 |  | Quarterly |  |  | 2/1/25 is a Saturday so needs to be excluded
 | D-1 | -1 |  | Monthly
 | D-1 | -1 |  | Monthly |  |  | For Quarterly items we need to only use the working days of the Quarter excluding Saturday, Sundays and Holidays.
 | D-1 | -1 |  | Monthly |  |  | March close schedule is on the third tab
 | D-1 | -1 |  | Monthly
 | D-1 | -1 |  | Monthly
 | D-1 | -1 |  | Monthly
 | D-1 | -1 |  | Monthly
 | D-1 | -1 |  | Quarterly
 | D1 | 1 |  | Monthly
 | D1 | 1 |  | Monthly
 | D1 | 1 |  | Monthly
 | D1 | -1 |  | Monthly
 | D1 | -1 |  | Monthly
 | D1 | -1 |  | Monthly
 | D1 | -1 |  | Monthly
 | D1 | 1 |  | Quarterly
 | D1 | 1 |  | Quarterly
 | D1 | 1 |  | Quarterly
 | D1 | 1 |  | Quarterly
 | D 1 | -1 |  | Monthly
 | D 1 | -1 |  | Monthly
 | D 1 | -1 |  | Monthly
 | D 1 | -1 |  | Monthly
 | D 1 | -1 |  | Monthly
 | D 1 | 1 |  | Quarterly
 | D 1 | 1 |  | Quarterly
 | D 1 | -1 |  | Monthly
 | D 1 | -1 |  | Monthly
 | D 1 | -1 |  | Monthly
 | D2 | 2 |  | Monthly
 | D2 | 2 |  | Monthly
 | D2 | 2 |  | Quarterly
 | D2 | 2 |  | Monthly
 | D 2 | 2 |  | Monthly
 | D 2 | 2 |  | Monthly
 | D 2 | 2 |  | Monthly
 | D3 | 3 |  | Monthly
 | D3 | 2 |  | Monthly
 | D3 | 3 |  | Monthly
 | D3 | 3 |  | Monthly
 | D3 | 3 |  | Monthly
 | D3 | 3 |  | Monthly
 | D3 | 3 |  | Quarterly
 | D3/D4 | 4 |  | Quarterly
 | D6 | 6 |  | Monthly
 | D6 | 6 |  | Quarterly
 | D6 | 6 |  | Monthly
 | D6 | 6 |  | Monthly
 | D6 | 6 |  | Monthly
 | D6 | 6 |  | Monthly
 | D6 | 6 |  | Monthly
 | D6 | 6 |  | Monthly
 | D6 | 6 |  | Monthly
 | D6 | 6 |  | Monthly
 | D6 | 6 |  | Monthly
 | D6 | 6 |  | Monthly
 | D6 | 6 |  | Monthly
 | D6 | 6 |  | Quarterly
 | D6 | 6 |  | Monthly
 | D6 - D9 | 6 |  | Quarterly
 | D6 - D9 | 6 |  | Quarterly
 | D 6 | 6 |  | Monthly
 | D6 - D9 | 9 |  | Monthly
 | D 6 | 6 |  | Monthly
 | D6 - D9 | 8 |  | Monthly
 | D 6 | 6 |  | Monthly
 | D6 - D9 | 8 |  | Monthly
 | D 6 | 6 |  | Quarterly
 | D6 - D9 | 8 |  | Quarterly
 | D 6 | 6 |  | Quarterly
 | D 6 | 6 |  | Quarterly
 | D 8 | 8 |  | Quarterly
 | D10 | 10 |  | Quarterly
 | D10 | 10 |  | Quarterly
 | D11 | 11 |  | Monthly
 | D20+ | 20 |  | Quarterly
 | D20+ | 20 |  | Quarterly
 | D20+ | 20 |  | Quarterly
Spreadsheet: 72730d1273463469-errorif-vlookup-and-sum-function-sample
Sheet: July

 | 63 | 67 | 71 | 84 | 93 | 97 | 105 | 111 | 115 | 121 | 126
2010-07-01 00:00:00
 | t
 | t
Monthly Total
6 Month Total
12 Month Total
Spreadsheet: darrell_schoolcraft__7761__imbalsumm0106
Sheet: NNG

NNG
 | Measured | Scheduled | Imbalance
1635 | -641
3531 |  | -70205
60667
60749 |  | -133507
61206
61334 | -22015
62960
INDEX
2001-05-31 00:00:00 |  |  | 1040469
2001-06-05 00:00:00
Spreadsheet: 6d365348-d266-4207-b4ff-f0dd4e2b6082
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
43601978 | 2014-10-16 06:42:22 | AXIS | 1 | 7 | 4 | 1007284 | Temple58 | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
43602117 | 2014-10-16 07:00:43 | ALLIES | 0 | 1 | 7 | 1007284 | Temple58 | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
43629032 | 2014-10-18 07:46:32 | AXIS | 0 | 4 | 6 | 1594070 | [NAME] | 7365 | mediterranean | 1942-06-14 | 1942-06-14 | [NAME] via the Coastal Road | Retraite britannique
43700628 | 2014-10-23 06:51:48 | AXIS | 1 | 6 | 2 | 1059626 | TRC777 | 7271 | western | 1944-12-18 | 1944-12-18 | [NAME] | Villages jumeaux
43700920 | 2014-10-23 07:34:35 | ALLIES | 0 | 5 | 6 | 1059626 | TRC777 | 7271 | western | 1944-12-18 | 1944-12-18 | [NAME] | Villages jumeaux
43743176 | 2014-10-26 07:18:10 | ALLIES | 1 | 5 | 4 | 1620728 | Neustrie | 6148 | western | 1944-07-25 | 1944-07-26 | Operation Cobra | Opération Cobra
43743550 | 2014-10-26 07:46:18 | ALLIES | 0 | 6 | 7 | 385172 | Brode Warrior | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
43800359 | 2014-10-30 04:57:32 | ALLIES | 0 | 4 | 7 | 270329 | andsymo | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
43800542 | 2014-10-30 05:24:12 | AXIS | 1 | 7 | 2 | 270329 | andsymo | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
43814330 | 2014-10-31 06:47:08 | AXIS | 1 | 10 | 7 | 384175 | ssegrubnad | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges