tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 864519d1711650844-xlookup-help-to-produce-a-number-if-not-found-on-prior-tab-sample-file-xlookup
Sheet: 2024

 | 24001 | Pack Price Architecture | NRT Channel Strategy Implementation
 | 24002 | Brand Portfolio Pricing | Theraflu Price Increase
 | 24003 | Pack Price Architecture | Theraflu Bulk Pack
 | 24004 | Promotion Management | Drug Promo Optimization
 | 24005 | Brand Portfolio Pricing | Flonase Price Increase
 | 24006 | Pack Price Architecture | Flonase Ecomm Sensimist Kids 2 pk
 | 24007 | Promotion Management | Flonase Sustainable ClipStrip
 | 24008 | Pack Price Architecture | Flonase Repack Spray
 | 24009 | Brand Portfolio Pricing | Transition Tums 70ct EX Twin pack to 170ct value size at DG
 | 24010 | Brand Portfolio Pricing | Oral Health 2023 Pricing (Sept 15th, 2023)
 | 24011 | Brand Portfolio Pricing | Oral Health 2024 Pricing
 | 24012 | Pack Price Architecture | Specialty Paste PPA Tiers
 | 24013 | Pack Price Architecture | Costco 2.0
 | 24014 | Pack Price Architecture | [NAME] Around (SSD & PN)
 | 24015 | Pack Price Architecture | Twin Paro AGR Whitening
 | 24016 | Pack Price Architecture | 3-Pack Sensodyne Sensitivity & Gum
 | 24017 | Pack Price Architecture | 3-Pack Pronbamel Intensive Enamel Repair
 | 24018 | Pack Price Architecture | Triple Pack Poligrip Hold & Seal
 | 24019 | Pack Price Architecture | Poligrip plus Polident bundle for Club - Sam's
 | 24020 | Pack Price Architecture | Parodontax Club.com
 | 24021 | Active Mix | Portfolio Optimization
 | 24022 | Active Mix | IRI Assortment tools (Paste and Denture)
 | 24023 | Pack Price Architecture | 3-Packs PN [NAME] and SSD Extra Whitening
 | 24024 | Brand Portfolio Pricing | Lower GI brands (excluding GasX & Prep H)
Spreadsheet: 108050d1305149862-auto-populating-excel-calendar-ts1019273743
Sheet: SEP

 | September 2011
 | Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday
 |  |  |  |  |  |  |  |  | 1 |  | 2 |  | 3
 | 4 |  | 5 | Labor Day | 6 |  | 7 |  | 8 |  | 9 |  | 10
 | 11 |  | 12 |  | 13 |  | 14 |  | 15 |  | 16 |  | 17
 | 18 |  | 19 |  | 20 |  | 21 |  | 22 |  | 23 | First Day of Autumn | 24
 | 25 |  | 26 |  | 27 |  | 28 | [NAME] | 29 | [NAME] | 30
 |  |  |  |  |  |  |  | (Sundown)
Spreadsheet: 96756d1296057911-how-to-return-average-of-some-non-zero-nos-from-a-column-excelhelp
Sheet: Sheet1

This is the dataset,
Time1 | Time2 | Avg vehicles
0 | 1 | 0
1 | 2 | 0
2 | 3 | 0
3 | 4 | 10
4 | 5 | 30
5 | 6 | 40
6 | 7 | 60
7 | 8 | 0
8 | 9 | 0
9 | 10 | 20
10 | 11 | 80
11 | 12 | 0
12 | 13 | 0
13 | 14 | 0
14 | 15 | 0
15 | 16 | 10
16 | 17 | 70
17 | 18 | 50
18 | 19 | 0
19 | 20 | 0
20 | 21 | 0
21 | 22 | 0
22 | 23 | 0
23 | 24 | 0
I want to calculate Average vehicles per non zero period ie from time 3 to 7, Total avg vehicles = 10+30+40+60 = 140 and duration = 4 thus return 140/4 = 35 and so on for further time periods thus,
Required set
35
50
43.33333333333334
Note - The avg vehicles change and vary with every iteration so there can be more or less rows in the [NAME] set.
Spreadsheet: 863275d1710834335-rearranging-data-based-on-dates-data-rearrange-version-3-excelforum
Sheet: Sheet1

 | ID | Month | Plan | Actual |  |  | Plan | Actual |  | ID | Plan | Actual |  |  | ID | Plan_ | Actual_
 | A01 | 2024-01-01 00:00:00 | 5 | 4 |  | A01 | 2024-01-01 00:00:00 | 2024-01-01 00:00:00 |  | A01 | 2024-01-01 00:00:00 | 2024-01-01 00:00:00 |  |  | A01 | 2024-01-01 00:00:00 | 2024-01-01 00:00:00
 | A02 | 2024-02-01 00:00:00 | 4 | 6 |  | A01 | 2024-01-01 00:00:00 | 2024-01-01 00:00:00 |  | A01 | 2024-01-01 00:00:00 | 2024-01-01 00:00:00 |  |  | A01 | 2024-01-01 00:00:00 | 2024-01-01 00:00:00
 | A03 | 2024-03-01 00:00:00 | 4 | 0 |  | A01 | 2024-01-01 00:00:00 | 2024-01-01 00:00:00 |  | A01 | 2024-01-01 00:00:00 | 2024-01-01 00:00:00 |  |  | A01 | 2024-01-01 00:00:00 | 2024-01-01 00:00:00
 | A04 | 2024-04-01 00:00:00 | 0 | 3 |  | A01 | 2024-01-01 00:00:00 | 2024-01-01 00:00:00 |  | A01 | 2024-01-01 00:00:00 | 2024-01-01 00:00:00 |  |  | A01 | 2024-01-01 00:00:00 | 2024-01-01 00:00:00
 |  |  |  |  |  | A01 | 2024-01-01 00:00:00 | No Actual |  | A01 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 |  |  | A01 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00
 |  |  |  |  |  | A02 | 2024-02-01 00:00:00 | 2024-02-01 00:00:00 |  | A02 | 2024-02-01 00:00:00 | 2024-02-01 00:00:00 |  |  | A02 | 2024-02-01 00:00:00 | 2024-02-01 00:00:00
 |  |  |  |  |  | A02 | 2024-02-01 00:00:00 | 2024-02-01 00:00:00 |  | A02 | 2024-02-01 00:00:00 | 2024-02-01 00:00:00 |  |  | A02 | 2024-02-01 00:00:00 | 2024-02-01 00:00:00
 |  |  |  |  |  | A02 | 2024-02-01 00:00:00 | 2024-02-01 00:00:00 |  | A02 | 2024-02-01 00:00:00 | 2024-02-01 00:00:00 |  |  | A02 | 2024-02-01 00:00:00 | 2024-02-01 00:00:00
 |  |  |  |  |  | A02 | 2024-02-01 00:00:00 | 2024-02-01 00:00:00 |  | A02 | 2024-02-01 00:00:00 | 2024-02-01 00:00:00 |  |  | A02 | 2024-02-01 00:00:00 | 2024-02-01 00:00:00
 |  |  |  |  |  | A02 | No Plan | 2024-02-01 00:00:00 |  | A02 | No Plan | 2024-02-01 00:00:00 |  |  | A02 | No Plan | 2024-02-01 00:00:00
 |  |  |  |  |  | A02 | No Plan | 2024-02-01 00:00:00 |  | A03 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 |  |  | A02 | No Plan | 2024-02-01 00:00:00
 |  |  |  |  |  | A03 | 2024-03-01 00:00:00 | No Actual |  | A03 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 |  |  | A03 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00
 |  |  |  |  |  | A03 | 2024-03-01 00:00:00 | No Actual |  | A03 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 |  |  | A03 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00
 |  |  |  |  |  | A03 | 2024-03-01 00:00:00 | No Actual |  | A03 | 2024-03-01 00:00:00 | No Actual |  |  | A03 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00
 |  |  |  |  |  | A03 | 2024-03-01 00:00:00 | No Actual |  | A04 | No Plan | No Actual |  |  | A03 | 2024-03-01 00:00:00 | No Actual
 |  |  |  |  |  | A04 | No Plan | 2024-04-01 00:00:00 |  | A04 | No Plan | No Actual |  |  | A04 | No Plan | No Actual
 |  |  |  |  |  | A04 | No Plan | 2024-04-01 00:00:00 |  | A04 | No Plan | No Actual |  |  | A04 | No Plan | No Actual
 |  |  |  |  |  | A04 | No Plan | 2024-04-01 00:00:00 |  |  |  |  |  |  | A04 | No Plan | No Actual
Spreadsheet: 805700d1668846827-horizontal-middle-data-sequencing-horizontal-sequencing-example
Sheet: Sheet1

 | 01.02.21.01 | 01.02.22.01 | 01.02.23.01 | 24 | 25 | 26 | 27 | 28 | 29
 | 01.02.21.02 | 01.02.22.02 | 01.02.23.02 | 24 | 25 | 26 | 27 | 28 | 29
 | 01.02.21.03 | 01.02.22.03 | 01.02.23.03 | 24 | 25 | 26 | 27 | 28 | 29
 | 01.02.21.04 | 01.02.22.04 | 01.02.23.04 | 24 | 25 | 26 | 27 | 28 | 29
 | 01.02.21.05 | 01.02.22.05 | 01.02.23.05 | 24 | 25 | 26 | 27 | 28 | 29
 | 01.02.21.06 | 01.02.22.06 | 01.02.23.06 | 24 | 25 | 26 | 27 | 28 | 29
 | 01.02.21.07 | 01.02.22.07 | 01.02.23.07 | 24 | 25 | 26 | 27 | 28 | 29
 | 01.02.21.08 | 01.02.22.08 | 01.02.23.08 | 24 | 25 | 26 | 27 | 28 | 29
TMS |  |  |  | [NAME] |  |  |  | Hans |  | 01.02.22.01 | 01.02.23.01 | 01.02.24.01 | 01.02.25.01 | 01.02.26.01 | 01.02.27.01 | 01.02.28.01 | 01.02.29.01
 |  |  |  |  |  |  |  |  | 01.02.21.02 | 01.02.22.02 | 01.02.23.02 | 01.02.24.02 | 01.02.25.02 | 01.02.26.02 | 01.02.27.02 | 01.02.28.02 | 01.02.29.02
 |  |  |  |  |  |  |  |  | 01.02.21.03 | 01.02.22.03 | 01.02.23.03 | 01.02.24.03 | 01.02.25.03 | 01.02.26.03 | 01.02.27.03 | 01.02.28.03 | 01.02.29.03
 |  |  |  |  |  |  |  |  | 01.02.21.04 | 01.02.22.04 | 01.02.23.04 | 01.02.24.04 | 01.02.25.04 | 01.02.26.04 | 01.02.27.04 | 01.02.28.04 | 01.02.29.04
 |  |  |  |  |  |  |  |  | 01.02.21.05 | 01.02.22.05 | 01.02.23.05 | 01.02.24.05 | 01.02.25.05 | 01.02.26.05 | 01.02.27.05 | 01.02.28.05 | 01.02.29.05
 |  |  |  |  |  |  |  |  | 01.02.21.06 | 01.02.22.06 | 01.02.23.06 | 01.02.24.06 | 01.02.25.06 | 01.02.26.06 | 01.02.27.06 | 01.02.28.06 | 01.02.29.06
 |  |  |  |  |  |  |  |  | 01.02.21.07 | 01.02.22.07 | 01.02.23.07 | 01.02.24.07 | 01.02.25.07 | 01.02.26.07 | 01.02.27.07 | 01.02.28.07 | 01.02.29.07
 |  |  |  |  |  |  |  |  | 01.02.21.08 | 01.02.22.08 | 01.02.23.08 | 01.02.24.08 | 01.02.25.08 | 01.02.26.08 | 01.02.27.08 | 01.02.28.08 | 01.02.29.08
 |  |  |  |  |  | G'day,
 |  |  |  |  |  | I have a numbering convention that needs to be adhered to and i am able to perform the sequencing vertically since its the last two digits that need to change vertically, but allowing the 3rd set of digits within the cell to sequence horizontally without changing the last set of digits doesn't seem to work for me. The example data is as follows:
 |  |  |  |  |  | 01.01.01.01  01.01.02.01  01.01.03.01
 |  |  |  |  |  | 01.01.01.02  01.01.02.03  01.01.03.02
 |  |  |  |  |  | 01.01.01.03  01.01.02.03  01.01.03.03
 |  |  |  |  |  | When I autofill vertically its fine but it wont let me begin the first cell in the row to sequence horizontally.
 |  |  |  |  |  | Any insight or solutions are greatly appreciated.
Spreadsheet: 3591b6d2-65ca-4a24-b889-077d2b505970
Sheet: Sheet1

Permit No.: | Unnamed: 1 | Unnamed: 2 | WQ0000633 | Unnamed: 4 | Unnamed: 5 | Facility Name: | Unnamed: 7 | Town of Candor WWTP | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | County: | Montgomery | Unnamed: 16 | Month: | Unnamed: 18 | Unnamed: 19 | Year: | Unnamed: 21
Did irrigation occur    at this facility? |  |  |  |  |  | Field Name: |  | 1 |  | Field Name: |  | 2 |  | Field Name: |  | 3 |  | Field Name: |  | 4
 |  |  |  |  |  | Area (acres): |  | 7 |  | Area (acres): |  | 7 |  | Area (acres): |  | 7 |  | Area (acres): |  | 7
 |  |  |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop:
 |  |  |  |  |  | [NAME] (in): |  |  |  | [NAME] (in): |  |  |  | [NAME] (in): |  |  |  | [NAME] (in):
 |  |  |  |  |  | Annual Rate (in): |  | 65 |  | Annual Rate (in): |  | 65 |  | Annual Rate (in): |  | 65 |  | Annual Rate (in): |  | 65
Day | Weather |  |  | Freeboard |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Storage | 5-Day Upset (if applicable) | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading
 |  | ºF | in | ft | ft | gal | min | in | in | gal | min | in | in | gal | min | in | in | gal | min | in | in
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
Monthly Loading:
12 Month Floating Total (in):
Spreadsheet: 750683d1633593733-tracking-product-storage-with-multiple-criteria-edited-storing-products-excel-help
Sheet: Storing

Current results
Date | Method | Product | Quantity | Location | Out of date
 | Storing | Apple |  | Shop1 | 2021-10-05 00:00:00
 | Storing | Apple |  | Shop2 | 2021-10-11 00:00:00
 | Storing | Pear |  | Shop1 | 2021-10-12 00:00:00
 | * when you change the method on 'trade list' to "Stored" it shouldn't pull the data through - it pulls the data elsewhere (formula already correct in the real workbook)
Expected result |  |  |  |  |  |  | Notes
Date | Method | Product | Quantity | Location | Out of date
 | Storing | Apple | 150 | Shop1 | 2021-10-05 00:00:00 |  | Highlighted red as it is past or equal to todays date (means its OOD) - (would prefer it to flash but red it fine if not)
 | Storing | Apple | 10 | Shop2 | 2021-10-11 00:00:00
 | Storing | Pear | 10 | Shop1 | 2021-10-12 00:00:00
 | Storing | Apple | 19.99 | Shop1 | 2021-10-07 00:00:00 |  | Highlighted red as it is past or equal to todays date (means its OOD) - (would prefer it to flash but red it fine if not)
 | One method that half works (pulls the data but if you change the method on 'Trade List' it ignores the line so theres a gap in the data
 |  | Apple | 150 | 0 | Shop1
 | Storing | Apple | 10 | 0 | Shop2
 | Storing | Pear | 10 | 0 | Shop1
 | Storing | Apple | 19.99 | 0 | Shop1
Spreadsheet: 384535d1426931922-converting-column-listed-data-to-row-listed-but-based-on-a-value-unique-modifier-examples
Sheet: Sheet1

12 Maple Ave | [NAME]
12 Maple Ave | [NAME]
12 Maple Ave | [NAME]
10 Rock Hill St | [NAME]
10 Rock Hill St | [NAME]
 | 2 highlited cells 2 different formulas
 | but all is array formula
Spreadsheet: 82668d1282697206-lookup-copy-of-examplefitchart
Sheet: Sheet1

 | Look up Chart "Size" |  | Value |  | Value
Size | S | Chest | 35 |  | Result
Size | L | Chest | 41 |  | Result
Size | 2XL | Chest | 54 |  | Result
Chart
Size | Slim | Normal | Relaxed
XS | 32 | 33 | 35
S | 35 | 36 | 38
M | 38 | 39 | 41
L | 41 | 42 | 45
XL | 45 | 46 | 49
2XL | 49 | 50 | 53
3XL | 53 | 54 | 57
4XL | 57 | 58 | 61
Spreadsheet: a39047a5-71fe-4324-addd-8a88337043bb
Sheet: Sheet1

analytica 2012 - Aussteller Liste | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Suche über Produkt- und Dienstleistungsverzeichnis (8 [NAME]):
 | 5 Labortechnische Geräte 5.4 Labortechnik und Laboreinrichtung 5.4.5 Trocknungsgeräte
Nr. | Firma | Land | Ort | PLZ | Halle/Stand
1 | AB Umega SNOL | [NAME] | Utena | 28216 | B1.410B
2 | [NAME][NAME] | Deutschland | Königswinter | 53639 | B2.303
3 | Labconco Corporation | USA | Kansas City | MO 64034 | B2.125
4 | [NAME] | Deutschland | Schwabach | 91126 | B2.103
5 | [NAME] | Deutschland | Lilienthal | 28865 | B2.315
6 | [NAME] | Großbritannien | St. [NAME], [NAME] | BR5 4HE | A1.538B
7 | witeg Labortechnik GmbH | Deutschland | Wertheim | 97877 | B1.425
8 | Zirbus Technology GmbH | Deutschland | [NAME] | 37539 | B2.400
Spreadsheet: 841137d1693389287-date-list-to-complete-date-list-showing-no-event-dates-date-list
Sheet: Blad1

Day | Date | Event |  |  | Day | Date |  |  |  | Date | Event
Wednesday | 2023-08-30 00:00:00 | Opkuis |  |  | Wednesday | 2023-08-30 00:00:00 | Opkuis |  | 2023-08-30 00:00:00 | 2023-08-30 00:00:00 | Opkuis
Friday | 2023-09-01 00:00:00 | Opbouw |  |  | Thursday | 2023-08-31 00:00:00 |  |  | 2023-08-31 00:00:00 | 2023-08-31 00:00:00
Saturday | 2023-09-02 00:00:00 | Opkuis |  |  | Friday | 2023-09-01 00:00:00 | Opbouw |  | 2023-09-01 00:00:00 | 2023-09-01 00:00:00 | Opbouw
Sunday | 2023-09-03 00:00:00 | Voorstelling |  |  | Saturday | 2023-09-02 00:00:00 | Opkuis |  | 2023-09-02 00:00:00 | 2023-09-02 00:00:00 | Opkuis
Tuesday | 2023-09-05 00:00:00 | Opkuis |  |  | Sunday | 2023-09-03 00:00:00 | Voorstelling |  | 2023-09-03 00:00:00 | 2023-09-03 00:00:00 | Voorstelling
Wednesday | 2023-09-06 00:00:00 | Opbouw |  |  | Monday | 2023-09-04 00:00:00 |  |  | 2023-09-04 00:00:00 | 2023-09-04 00:00:00
 |  |  |  |  | Tuesday | 2023-09-05 00:00:00 | Opkuis |  | 2023-09-05 00:00:00 | 2023-09-05 00:00:00 | Opkuis
 |  |  |  |  | Wednesday | 2023-09-06 00:00:00 | Opbouw |  | 2023-09-06 00:00:00 | 2023-09-06 00:00:00 | Opbouw
 |  |  |  |  | Thursday | 2023-09-07 00:00:00 |  |  | 2023-09-07 00:00:00 | 2023-09-07 00:00:00
Spreadsheet: fed7bd10-8e6e-45d5-add3-c096ea2711f6
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
44024953 | 2014-11-15 00:50:48 | AXIS | 0 | 1 | 6 | 1009110 | HO-SA-KAI | 12509 | western | 1944-06-06 |  | [Normandy] Vaumicel Manor | Château de Vaumicel
44025078 | 2014-11-15 01:09:09 | ALLIES | 0 | 4 | 6 | 1009110 | HO-SA-KAI | 12509 | western | 1944-06-06 |  | [Normandy] Vaumicel Manor | Château de Vaumicel
44025535 | 2014-11-15 01:59:35 | AXIS | 1 | 7 | 5 | 1007284 | Temple58 | 7661 | eastern | 1944-02-16 | 1944-02-17 | Breakout to Lisyanka | [NAME]
44025703 | 2014-11-15 02:22:01 | ALLIES | 0 | 4 | 7 | 1007284 | Temple58 | 7661 | eastern | 1944-02-16 | 1944-02-17 | Breakout to Lisyanka | [NAME]
44025992 | 2014-11-15 02:46:03 | AXIS | 0 | 4 | 6 | 1670038 | Unrealik279 | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
44026130 | 2014-11-15 03:04:37 | ALLIES | 0 | 2 | 6 | 1670038 | Unrealik279 | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
44052769 | 2014-11-16 19:46:42 | AXIS | 0 | 4 | 6 | 1232294 | decott 59 | 7595 | eastern | 1939-12-16 | 1939-12-16 | Suomussalmi | Suomussalmi
44053008 | 2014-11-16 20:06:29 | ALLIES | 0 | 2 | 6 | 1232294 | decott 59 | 7595 | eastern | 1939-12-16 | 1939-12-16 | Suomussalmi | Suomussalmi
44057289 | 2014-11-17 00:32:08 | AXIS | 1 | 5 | 2 | 1670830 | player1670830 | 6148 | western | 1944-07-25 | 1944-07-26 | Operation Cobra | Opération Cobra
44057586 | 2014-11-17 00:57:04 | AXIS | 0 | 4 | 6 | 1542223 | Barkhorn4 | 7595 | eastern | 1939-12-16 | 1939-12-16 | Suomussalmi | Suomussalmi
44057821 | 2014-11-17 01:15:07 | ALLIES | 1 | 6 | 5 | 1542223 | Barkhorn4 | 7595 | eastern | 1939-12-16 | 1939-12-16 | Suomussalmi | Suomussalmi
44125697 | 2014-11-22 01:37:27 | AXIS | 0 | 6 | 10 | 867821 | b.kuntscher | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
44125925 | 2014-11-22 02:12:46 | ALLIES | 0 | 6 | 10 | 867821 | b.kuntscher | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
44184348 | 2014-11-26 02:05:29 | AXIS | 1 | 6 | 5 | 578329 | Valentin de Ramillies | 6150 | mediterranean | 1944-08-25 | 1944-08-25 | [NAME] | [NAME]
44184451 | 2014-11-26 02:15:46 | ALLIES | 1 | 6 | 2 | 578329 | Valentin de Ramillies | 6150 | mediterranean | 1944-08-25 | 1944-08-25 | [NAME] | [NAME]
44210131 | 2014-11-28 00:10:48 | AXIS | 0 | 4 | 6 | 778385 | Major [NAME] | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
44210260 | 2014-11-28 00:25:20 | ALLIES | 1 | 6 | 1 | 778385 | Major [NAME] | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
Spreadsheet: 124632d1318517201-approximate-break-even-point-with-lookup-analyse-bc
Sheet: klokken-expert

 |  |  |  |  |  |  | [NAME] uren | [NAME] teksten | Week nr (teksten) | Linkbuild uren | [NAME] linkbuilding | Week nr (linkbuilding)
KLOKKEN-EXPERT |  |  |  |  |  |  |  | KLOKKEN-EXPERT |  |  | KLOKKEN-EXPERT
Uurtarief (tekstschrijvers / linkbuilding) | 11.9
RAPPORTAGE JAAR: | 2011
Omschrijving | uren | [NAME]
Totaal aantal tekstschrijfuren
Totaal aantal linkbuilduren |  |  | BreakEven
Totaal
Bruto Marge:
[NAME]
Totaal aantal weken tekstschrijven
Totaal aantal weken linkbuilding
Eerste week tekstschrijven
Eerste week linkbuilding
Weeknummer | Omzet | Bruto Marge | Breakeven Calculation
Spreadsheet: 165000d1340981970-vlookup-problem-rennresultater-test
Sheet: Buschdorf

Date: |  |  |  | Ort: | Buschdorf
Org.:
Classe:
Place | Nr | Nom & Prénom |  | Jury 1 | Class. | Jury 2 | Total
1 | 0 | [NAME] |  | 13 | 0 | 12 | 12
2 | 1 | [NAME] |  | 15 | 3 | 6 | 9
3 | 2 | [NAME] |  | 11 | 0 | 9 | 9
4 | 3 | [NAME] |  | 15 | 2 | 3 | 5
5 | 4 | Reding Fons |  | 9 | 0 | 9 | 9
6 | 5 | [NAME] |  | 12 | 0 | 6 | 6
7 | 6 | 0 |  | 15 | 1 | 0 | 1
8 | 7 | [NAME] |  | 14 | 0 | 0 | 0
9 | 8 | [NAME] |  | 14 | 0 | 0 | 0
10 | 9 | Heck Ronny |  | 9 | 0 | 3 | 3
11 | 10 | Scherer Roland |  | 11 | 0 | 0 | 0
12 | 11 | [NAME] |  | 8 | 0 | 3 | 3
13 | 12 | Neu Pascal |  | 5 | 0 | 3 | 3
14 | 13 | [NAME] |  | 6 | 0 | 0 | 0
2012-06-29 18:58:07
Spreadsheet: 328700d1404034331-index-match-if-function-wonder-why-excel-kept-refer-to-the-wrong-want-formula-error-dgk-2
Sheet: BySea

 | JOB NO.
 | SHIPPER/CONSIGNEE
 | POL
 | POD
 | Itemizing Services |  | Unit Selling Price | Qty LCL | Qty 20' | Qty 40' | Total Amount of Billing |  |  | Notes
 |  |  |  |  |  |  | LCL | 20' | 40'
 | Ocean Freight |  |  |  |  |  |  |  |  | SEA FREIGHT CURRENCY
 | Port Charges at Port Klang |  | Unit S.Rate | LCL | 20' | 40' | LCL | 20' | 40'
 | THC |  |  |  |  |  |  |  |  | AS PER RECEIPT.
 | EDI/IID
 | BL/DO
 | Container Cleaning Fee |  |  | 1 | 1 | 1
 | Container Cleaning Fee
 | Custom Clearance Charges |  | Unit S.Rate | LCL | 20' | 40' | LCL | 20' | 40'
 | SMK |  |  |  |  | 1
 | [NAME]
 | CFS/Warehouse Charges |  | Unit S.Rate | LCL | 20' | 40' | LCL | 20' | 40'
 | Storage
 | Heavy Lifting (3Tons & Above)
 | Transportation |  | Unit S.Rate | LCL | 20' | 40' | LCL | 20' | 40'
 | Haulage
 | Side Loader
 | Depot Gate Charges
 | Accessories Charges |  | Unit S.Rate | LCL | 20' | 40' | LCL | 20' | 40'
 | [NAME]
 | [NAME] Hired
 | Overtime (Min 2hrs)
 | Overtime on Weekends
 | Marine Insurance
 | Insurance Stamping Fee
Spreadsheet: 103447d1301179659-multiplying-letters-and-numbers-example1
Sheet: Sheet1

[NAME] | Compound Participation |  | POSITIVE | NEGATIVE |  |  | Reaction Formula
carbon monoxide | 0
hydrogen | 0
formic acid | 0
acetic acid | 0
propanoic acid | 0
acetone | 1
formaldehyde | 0
acetaldehyde | 0
oxaldehyde | 0
glycol aldehyde | 0
acetal | 0
cellulose acetate | 0
cellobiose | 0
fructose | 0
glucose | -1
furfurol | 0
[NAME] (5-Hydroxymethyl-2-furaldehyde) | 0
furan-2-carbaldehyde | 0
phenol | 0
isoeugenol | 0
eugenol | 0
cresol | 0
xylose | 0
furfural | 0
furfuryl alcohol | 0
methyl furan | 0
tetrahydrofurfural | 0
levulinic acid | 0
[NAME] | 0
gamma valerolactone | 0
1,3-pentanediol | 0
1-pentanol | 0
2-pentanol | 0
methanol | 0
methane | 0
ethane | 0
propane | 0
n-butane | 0
n-octane | 0
[NAME] | 0
propene | 0
but-1-ene | 0
but-2-ene | 0
benzene | 0
toluene | 0
p-xylene | 0
m-xylene | 0
o-xylene | 0
o-cresol | 0
p-cresol | 0
m-cresol | 0
indane | 0
tetralin | 0
n-nonane | 0
n-decane | 0
n-undecane | 0
n-dodecane | 0
n-tridecane | 0
2-methyltetrahydrofuan | 0
ethanol | 2
n-pentane | 0
n-hexane | 0
carbon dioxide | 2
water | 0
glycerol | 0
[NAME] | 0
Wood | 0
BioOil | 0
[NAME] | 0
Pyrolysis Gas | 0
cellulose | 0
hemicellulose | 0
lignin | 0
biomass(woody) | 0
coumaryl alcohol | 0
coniferyl alcohol | 0
sinapyl alcohol | 0
[NAME]-phenylpentanoate | 0
1-Hexene | 0
Propan-1-ol | 0
n-Butanol | 0
CycloHexane | 0
[NAME] | 0
Parrafin | 0
MTBE (tert-Butyl methyl ether ) | 0
Spreadsheet: 06d2e34e-7e25-4145-b186-065706d0b6e0
Sheet: Sheet1

Biosolids Plant Available Nitrogen (PAN) & Agronomic Application Rate | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Calculation Worksheet
NOTE: Gray Cells Require User Input
1 | Calculate Biosolids Organic Nitrogen  (%TKN - (%NH3/4-N) |  |  |  |  |  | %TKN | 3.6
 | Note: if in mg/Kg (ppm) convert to % (pph) before entry (mg/Kg/10,000 =%) |  |  |  |  |  | - %NH4-N | 2.1
 |  |  |  |  |  |  |  | 1.5
2 | Biosolids %NH3/4-N Remaining after Volatilization [(%NH3/4(fv/100))]
 | [NAME] (fv) %
 | Days to Incorporate | Surface-applied |  |  |  | Injected
 |  | Liquid Biosolids | Dewatered Biosolids | [NAME] | Compost or Air Dried | All Biosolids | %NH4-N | 2.1
 | 0 to 2 | 50 - 80 | 55 - 85 | 10 | 100 | 100 | x (fv) | 50
 | 3 to 6 | 30 - 65 | 45 - 75 | 10 | 100 | 100 |  | 1.05
 | over 6+ | 10 - 35 | 20 - 45 | 10 | 100 | 100
3 | Biosolids %Org-N  Mineralized in first year [(%Org N x (fm/100))]
 | 1st Year Estimated Mineralization Rate (fm)
 | Processing |  |  | Moisture Content | Est. of first year Mineralization
 | Anaerobic digestion |  |  | liquid | 20-40
 | Aerobic digestion |  |  | liquid | 30-45 |  | %Org-N | 1.5
 | Aerobic/anaerobic digestion |  |  | liquid | 15-30 |  | x (fm) | 30
 | storage in lagoon > 6 months |  |  | liquid | 15-30 |  |  | 0.45
 | Anaerobic digestion & dewatering |  |  | semi-solid | 25-32
 | Drying bed |  |  | solid | 15-30
 | Heat-dried |  |  | solid | 20-40
 | Compost |  |  | solid | 0-20
 | CSU Average |  |  |  | 27
 |  |  |  |  |  |  | %NO3-N | 0.02
4 | TOTAL % Available N from Biosolids |  |  |  |  |  | + %avail NH4-N | 1.05
 | = %NO3-N + %avail NH4-N + %avail Org-N |  |  |  |  |  | + %avail Org-N | 0.45
 |  |  |  |  |  |  |  | 1.52
5 | Plant Available Nitrogen (PAN) per [NAME] Biosolids |  |  |  |  |  | %avail N | 1.52
 |  |  |  |  |  |  | x 20 | 20
 |  |  |  |  |  |  |  | 30.4
6 | Soil - available N |  |  |  |  |  | # N available in Soil | 0
 |  |  |  |  |  |  | # N available from previous biosolids applications | 0
 |  |  |  |  |  |  | Fertilizer recommendation | 75
 | Crop N requirement (lbs.N/ acre) |  |  |  |  |  | N requirement from biosolids | 75
7
 |  |  |  |  |  |  | dt/ac | 2.467105263157895
8 | Biosolids Agronomic Application Rate, dry tons/acre
9 | Biosolids Agronomic Application Rate |  |  | Biosolids % Total Solids |  |  | [NAME]/ac | 9.137426900584796
 | [NAME]/ac = [(dt/ac)/(%TS)]100 |  |  |  | 27 |  | gallons/ac | 2191.229472562301
 | gallons/ac = [(dt/ac)(2000)/(8.34)(%TS)]100