tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 25346d1216639915-sum-countif-temp
Sheet: Sayfa1

2 | 10 | 27 | 30 | 32 | 54
 |  |  |  |  |  |  | ADET
24 | 36 | 12 | 23 | 31 | 19
1 | 34 | 39 | 16 | 3 | 26
16 | 24 | 31 | 30 | 5 | 30
25 | 47 | 4 | 28 | 24 | 33
7 | 30 | 29 | 6 | 10 | 47
8 | 3 | 38 | 44 | 32 | 16
11 | 20 | 13 | 48 | 13 | 42
23 | 11 | 19 | 28 | 49 | 4
3 | 9 | 12 | 39 | 18 | 37
48 | 34 | 40 | 13 | 5 | 30
14 | 19 | 4 | 17 | 40 | 5
29 | 36 | 6 | 20 | 16 | 44
20 | 33 | 43 | 27 | 25 | 33
23 | 22 | 29 | 35 | 34 | 20
35 | 25 | 7 | 23 | 37 | 6
3 | 21 | 28 | 23 | 23 | 45
22 | 19 | 42 | 43 | 41 | 10
49 | 12 | 10 | 18 | 18 | 28
18 | 8 | 24 | 10 | 49 | 49
14 | 18 | 49 | 36 | 27 | 32
49 | 47 | 15 | 7 | 9 | 3
34 | 7 | 7 | 49 | 22 | 16
35 | 42 | 10 | 43 | 18 | 27
48 | 22 | 40 | 27 | 31 | 31
29 | 38 | 2 | 33 | 19 | 30
11 | 13 | 33 | 34 | 11 | 3
Spreadsheet: 696992d1601061535-if-vlookup-with-clusters-if-vlookup_updated
Sheet: Sheet1

Alphabet id | Alphabet | Desired Output | Helper1 | Helper2
445592 | TEST_102559 | Y
445593 | TEST_102559 | Y | 3 | 2
278544 | TEST_104994 | Y | 4 | 4
278472 | TEST_104994 | Y | 5 | 4
258939 | TEST_108069 | Y | 6 | 6
258941 | TEST_108069 | Y | 7 | 6
444942 | TEST_11417 | Y | 8 | 8
444950 | TEST_11417 | Y | 9 | 8
513548 | TEST_11679 | X | 10 | 10
513548 | TEST_11679 | X | 10 | 10
513548 | TEST_11679 | X | 10 | 10
513548 | TEST_11679 | X | 10 | 10
513548 | TEST_11679 | X | 10 | 10
513548 | TEST_11679 | X | 10 | 10
513548 | TEST_11679 | X | 10 | 10
513548 | TEST_11679 | X | 10 | 10
449558 | TEST_11779 | Y | 18 | 18
449449 | TEST_11779 | Y | 19 | 18
283163 | TEST_118461 | Y | 20 | 20
281913 | TEST_118860 | Y | 21 | 21
281866 | TEST_118860 | Y | 22 | 21
290367 | TEST_123155 | Y | 23 | 23
513545 | TEST_125471 | Y | 24 | 24
513545 | TEST_125471 | Y | 24 | 24
513545 | TEST_125471 | Y | 24 | 24
100 | TEST_125472 | Y | 27 | 27
100 | TEST_125472 | Y | 27 | 27
100 | TEST_125472 | Y | 27 | 27
100 | TEST_125472 | Y | 27 | 27
5 | TEST_125479 |  | 31 | 31
5 | TEST_125479 |  | 31 | 31
Spreadsheet: 85f3cd64-347e-431e-9327-a7983e04663c
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Žádost o vízum do [NAME]
vyplnujte cesky bez interpunkce (hacku a carek)
osobní údaje
příjmení
dřívější příjmení (za svobodna, pred rozvodem ...)
jméno
pohlaví
 | muž |  | žena
datum narození
[NAME]
země trvalého bydlště
pasové údaje
číslo pasu
datum vydání pasu
datum platnosti pasu
[NAME] pasu
[NAME] pas vydala
národnost dle pasu
(pas by [NAME] ještě minimalne 6 mesicu)
důvod cesty do [NAME]
 |  | turistický
 |  | obchodní
adresa trvalého bydliště
ulice a číslo
město
PSČ
okres (pro ČR) [NAME] (pro SR)
země
číslo mobilního telefonu
Uvedené nesprávných nebo nepravdivých údajů můž vést k zamítnutí žádosti o vízum !
Žádost vyplnil
Datum vyplnění
Spreadsheet: 777365d1650353113-tracking-detained-product-shipments-and-values-detainment-tracking
Sheet: Netherlands

Firm | Port | Destination | Date of Arrival | Number of Certificates | Certificate Numbers | Value | Reason for Detainment | Number of Relased Certificates | Released Certificate Numbers | Released | Notes
Company A | [NAME] | Netherlands | 1981-01-01 00:00:00 | 14 | EX-80000-A1;EX-80000-A2;EX-80000-A3;EX-80000-A4;EX-80000-A5;EX-80000-A6;EX-80000-A7;EX-80000-A8;EX-80000-A9;EX-80000-A10;EX-80000-A11;EX-80000-A12;EX-80000-A13;EX-80000-A14 | 2939429.06 | jfal;kdjfdsl;kjfjdsklfjdkljfdslkajflkdjfkladjfkdlsjfaklsdjfkldasjfkldj;jkl;fa | 1 | EX-80000-A1 | 100000 | [NAME]
Company B | [NAME] | Netherlands | 1981-01-02 00:00:00 | 1 | EX-80000-A15 | 100000 | fdsadfadfdaad | 0
Spreadsheet: 374bbd9c-77e0-433b-b0ae-2a8f9a7c44e1
Sheet: 14d

 | Swap Dealers/MSPs4 |  |  | Others
Product1 | HY3 | IG | Other |  | IG | Other
Index Tranche | - | - | - | - | - | -
Index/OTHER* | 264 | 283 | 324 | 467 | 320 | 222
TOTAL | 264 | 283 | 324 | 467 | 320 | 222
*OTHER variable includes exotic credit products, swaptions, and total return swaps.
Spreadsheet: 142481d1329858436-if-else-statement-plus-calculations-copy-of-copy-of-example-2-1
Sheet: Sheet2

XFMR Bank ID | Period End | [NAME]
14 | Apr-11 | 19.18
14 | Aug-11 | 20.6
14 | Dec-11 | 36.18
178 | Apr-11 | 43.44
178 | Aug-11 | 61.97
178 | Dec-11 | 35.32
Spreadsheet: 795697d1662870372-true-false-result-row-duplication-duplication-in-row-example
Sheet: Example

Example 1 | Example 2 | Example 3 | Example 4 | Example 5 | Example 6 | Example 7 | Return 1 | Return 2 | Comment - Return 1 | Comment - Return 2
1 | 2 | 3 | 4 | 5 | 6 | 7 | 1 | 1 | 1 = No Duplicate ROW ; First instance of 1-7 | 1 = No Duplicate in ROW |  |  | First instance
4 | 5 | 6 | 7 | 1 | 2 | 3 | 0 | 1 | 0 = Duplicate ROW ; Second instance of 1-7 | 1 = No Duplicate in ROW |  |  | Second instance
2 | 2 | 3 | 4 | 5 | 6 | 7 | 1 | 0 | 1 = No Duplicate ROW ; New set of numbers | 0 = Duplicate in ROW |  |  | Duplicate in Row
12 | 2 | 3 | 4 | 5 | 6 | 7 | 1 | 1 | 1 = No Duplicate ROW ; First instance of 12, 2-7 | 1 = No Duplicate in ROW
3 | 2 | 3 | 4 | 5 | 6 | 7 | 1 | 0 | 1 = No Duplicate ROW ; New set of numbers | 0 = Duplicate in ROW
4 | 2 | 3 | 4 | 5 | 6 | 7 | 1 | 0 | 1 = No Duplicate ROW ; New set of numbers | 0 = Duplicate in ROW
5 | 2 | 3 | 4 | 5 | 6 | 7 | 1 | 0 | 1 = No Duplicate ROW ; New set of numbers | 0 = Duplicate in ROW
6 | 2 | 3 | 4 | 5 | 6 | 7 | 1 | 0 | 1 = No Duplicate ROW ; First instance of 6,2-7 | 0 = Duplicate in ROW
7 | 2 | 3 | 4 | 5 | 6 | 7 | 1 | 0 | 1 = No Duplicate ROW ; New set of numbers | 0 = Duplicate in ROW
8 | 2 | 3 | 4 | 5 | 6 | 7 | 1 | 1 | 1 = No Duplicate ROW ; New set of numbers | 1 = No Duplicate in ROW
4 | 5 | 6 | 7 | 6 | 2 | 3 | 1 | 0 | 1 = No Duplicate ROW ; First instance of 6,2-7 | 0 = Duplicate in ROW
9 | 2 | 3 | 4 | 5 | 6 | 7 | 1 | 1 | 1 = No Duplicate ROW ; New set of numbers | 1 = No Duplicate in ROW
10 | 2 | 4 | 4 | 5 | 6 | 7 | 1 | 0 | 1 = No Duplicate ROW ; New set of numbers | 0 = Duplicate in ROW
11 | 2 | 3 | 4 | 5 | 6 | 7 | 1 | 1 | 1 = No Duplicate ROW ; New set of numbers | 1 = No Duplicate in ROW
4 | 5 | 6 | 7 | 12 | 2 | 3 | 0 | 1 | 0 = Duplicate ROW ; Second instance of 12, 2-7 | 1 = No Duplicate in ROW
Return 1 |  |  |  |  |  |  |  | Return 2
Compare ROW (Columns: Example 1-7) to previous ROWs to return TRUE / FALSE value (1/0) regarding duplication |  |  |  |  |  |  |  | Look at each ROW for Duplication of numbers
Example: |  |  |  |  |  |  |  | Return TRUE / FALSE value (1/0) regarding duplication
ROW 16 is a duplication of ROW 5
Previous ROWs are 2-15 |  |  |  |  |  |  |  | Know how to work Conditional Formatting to locate duplication for individual ROWs
 |  |  |  |  |  |  |  | Unsure how to enlarge for a wider scale
Would need the ability to Drag & Drop Formula otherwise VBA would be great - Not the greatest User of ARRAY ({})formulas
Have tried other formulas but they're not correct / don't work for the scenario
E.G. Incorrect Formula for scenario
Spreadsheet: 301179d1393724677-listing-values-vertically-value-table
Sheet: Sheet1

 | Value | # of Times
 | 57 | 1 |  | 57
 | 56 | 1 |  | 56
 | 53 | 1 |  | 53
 | 52 | 1 |  | 52
 | 51 | 1
 | 49 | 1
 | 48 | 1
 | 47 | 1
 | 46 | 1
 | 45 | 1
 | 44 | 1
 | 43 | 1
 | 42 | 2
 | 41 | 2
 | 40 | 2
 | 39 | 2
 | 38 | 2
 | 37 | 3
 | 35 | 3
 | 33 | 3
 | 32 | 3
 | 31 | 3
 | 30 | 3
 | 29 | 3
 | 28 | 3
 | 26 | 3
 | 25 | 3
 | 23 | 3
 | 22 | 3
 | 21 | 3
 | 19 | 3
 | 17 | 3
 | 15 | 4
 | 13 | 4
 | 12 | 4
 | 11 | 4
 | 9 | 4
 | 8 | 4
 | 7 | 4
 | 6 | 4
 | 5 | 4
 | 4 | 4
 | 3 | 4
 | 2 | 4
 | 1 | 5
Spreadsheet: john_griffith__15617__Book1
Sheet: Sheet1

 |  |  | Natural Gas Straddles
 | Month | Strike | Bid | Offer | Mid-Pt. Vol | Net Change
 | M | 4.55 | 0.43 | 0.47 | 0.4841000000000005 | 0.009299999999998976
 | N | 4.65 | 0.71 | 0.74 | 0.5039000000000002 | 0.01019999999999888
 | Q | 4.7 | 0.89 | 0.93 | 0.5065000000000011 | 0.008099999999999108
 | U | 4.75 | 1.07 | 1.11 | 0.513700000000001 | 0.005099999999999438
 | V | 4.8 | 1.2 | 1.24 | 0.5148000000000015 | -0.001199999999999868
 | X | 4.95 | 1.415 | 1.42 | 0.5289000000000013 | 0.001799999999999802
 | Z | 5.15 | 1.59 | 1.61 | 0.5336000000000009 | -0.0005999999999999339
 | F | 5.2 | 1.7 | 1.8 | 0.542000000000001 | 0.001499999999999835
 | G | 5.05 | 1.75 | 1.85 | 0.5423000000000013 | 0.005399999999999405
 | H | 4.85 | 1.6 | 1.7 | 0.4916000000000005 | 0.001199999999999868
 | J | 4.45 | 1.18 | 1.28 | 0.3812000000000005 | -0.002399999999999736
 | K | 4.4 | 1.1 | 1.2 | 0.3512000000000017 | 0.003599999999999604
 |  |  | 2001-05-02 09:49:14.660000
Spreadsheet: 816146d1675398152-n-a-and-auto-formula-na-and-autoformula
Sheet: Sheet1

Mitarbeiterliste |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 Monat | entspricht | 4.34524 | Wochen
Zimmermädchen / Roomboy
[NAME].Nr. | [NAME] | Name | Vorname | Personalnummer | Eintritt | Austritt | Kategorie | AV Std pro Woche | Vertragsart | total hours per Month | Achtung |  |  |  |  |  |  | [NAME]
1 |  |  |  |  |  |  |  |  | Vollzeit |  |  |  |  |  | Vollzeit | 40 | Vollzeit
2 |  |  |  |  |  |  |  |  | Vollzeit |  |  |  |  |  | Teilzeit | 20 | Teilzeit
3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mini Job | 10 | Mini Job
4
5
Spreadsheet: 218173a2-29c6-4c6f-a8a0-e360191b0386
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
NUTH | Test | NUTH | Hazelnut-Food, IgE | Hazelnut-Food, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
NUTH | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
NUTH | Result | NUTH | Hazelnut-Food, IgE | Hazelnut-Food, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6136-6 | Corylus [NAME].IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: 837272d1689976337-formula-help-for-weekly-planner-weekly-planner
Sheet: Sheet1

 | Week 4 |  |  |  |  |  |  |  | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday
 | September |  |  | 2024
 | M | T | W | T | F | S | S
 | January |  | 2023
 | February |  | 2024
 | March
 | April
 | May
 | June
 | July
 | August
 | September
 | October
 | November
 | December
 | Week 1
 | Week 2
 | Week 3
 | Week 4
 | Week 5
 | Week 6
 | Week 7
 | Week 8
 | Week 9
 | Week 10
 | Week 11
 | Week 12
 | Week 13
 | Week 14
 | Week 15
 | Week 16
 | Holidays
Spreadsheet: 696419d1600800541-how-to-efficiently-manage-trapping-value-and-n-a-errors-vault_gw
Sheet: help

F4 | G4 | H4 | I4 | Concat | Index |  | Index | Calculation type |  | Comp Number | Index-a | Index-b | Average
number | number | number | number |  | 5 |  | 1 | min(f4, g4)
number | number | number | nv |  | 5 |  | 2 | min(h4, i4)
number | number | number | empty |  | 5 |  | 3 | pending
number | number | nv | number |  | 5 |  | 4 | dash
number | number | nv | nv |  | 1 |  | 5 | average(min(f4, g4), min(h4, i4))
number | number | nv | empty |  | 1
number | number | empty | number |  | 5
number | number | empty | nv |  | 1
number | number | empty | empty |  | 1
number | nv | number | number |  | 5
number | nv | number | nv |  | 5
number | nv | number | empty |  | 5
number | nv | nv | number |  | 5
number | nv | nv | nv |  | 1
number | nv | nv | empty |  | 1
number | nv | empty | number |  | 5
number | nv | empty | nv |  | 1
number | nv | empty | empty |  | 1
number | empty | number | number |  | 5
number | empty | number | nv |  | 5
number | empty | number | empty |  | 5
number | empty | nv | number |  | 5
number | empty | nv | nv |  | 1
number | empty | nv | empty |  | 1
number | empty | empty | number |  | 5
number | empty | empty | nv |  | 1
number | empty | empty | empty |  | 1
nv | number | number | number |  | 5
nv | number | number | nv |  | 5
nv | number | number | empty |  | 5
nv | number | nv | number |  | 5
nv | number | nv | nv |  | 1
nv | number | nv | empty |  | 1
nv | number | empty | number |  | 5
nv | number | empty | nv |  | 1
nv | number | empty | empty |  | 1
nv | nv | number | number |  | 2
nv | nv | number | nv |  | 2
nv | nv | number | empty |  | 2
nv | nv | nv | number |  | 2
nv | nv | nv | nv |  | 4
nv | nv | nv | empty |  | 3
nv | nv | empty | number |  | 2
nv | nv | empty | nv |  | 3
nv | nv | empty | empty |  | 3
nv | empty | number | number |  | 2
nv | empty | number | nv |  | 2
nv | empty | number | empty |  | 2
nv | empty | nv | number |  | 2
nv | empty | nv | nv |  | 3
nv | empty | nv | empty |  | 3
nv | empty | empty | number |  | 2
nv | empty | empty | nv |  | 3
nv | empty | empty | empty |  | 3
empty | number | number | number |  | 5
empty | number | number | nv |  | 5
empty | number | number | empty |  | 5
empty | number | nv | number |  | 5
empty | number | nv | nv |  | 1
empty | number | nv | empty |  | 1
empty | number | empty | number |  | 5
empty | number | empty | nv |  | 1
empty | number | empty | empty |  | 1
empty | nv | number | number |  | 2
empty | nv | number | nv |  | 2
empty | nv | number | empty |  | 2
empty | nv | nv | number |  | 2
empty | nv | nv | nv |  | 3
empty | nv | nv | empty |  | 3
empty | nv | empty | number |  | 2
empty | nv | empty | nv |  | 3
empty | nv | empty | empty |  | 3
empty | empty | number | number |  | 2
empty | empty | number | nv |  | 2
empty | empty | number | empty |  | 2
empty | empty | nv | number |  | 2
empty | empty | nv | nv |  | 3
empty | empty | nv | empty |  | 3
empty | empty | empty | number |  | 2
empty | empty | empty | nv |  | 3
empty | empty | empty | empty |  | 3
Spreadsheet: 805083d1668524394-merging-different-data-sets-with-different-formatting-into-one-based-on-quantity-filter-different-data-sets-_-merge-into-one
Sheet: Data

Fruits | Quantity | Mapping |  | Meat | Sauce | Quantity | [NAME] | Cooked | mapping |  | Carbs | Quantity | mapping
Apple | 500 | red |  | Chicken | Sweet | 15 | 300 | Cooked | white |  | [NAME] | 700 | yellow
Orange | 400 | orange |  | Beef | Mushroom | 18 | 800 | Uncooked | [NAME] |  | [NAME] | 50 | white
[NAME] | 550 | yellow |  | Turkey | [NAME] | 19 | 600 | Cooked | white |  | Pasta | 6 | yellow
Spreadsheet: 696887d1601024782-how-to-increment-a-columns-cell-reference-by-1-then-by-2-then-by-1-etc-1-then-2-pattern-to-cell-references
Sheet: Sheet1

 |  | Step 1 |  | Step 2: build row# |  |  |  | Step 3: Offset test
 |  | Manual |  |  |  | [NAME] |  | With helper |  |  | NO helper
Value |  | Offset # |  | frequent row# | Set of 9 rows | Offset # |  | Value (offset) |  |  | Value (offset)
6 |  | 1
9 |  | 1
2 |  | 1
6 |  | 1
2 |  | 4
8 |  | 1
2 |  | 1
2 |  | 1
9 |  | 1
1 |  | 1
3 |  | 1
8 |  | 1
1 |  | 1
4 |  | 4
2 |  | 1
8 |  | 1
5 |  | 1
6 |  | 1
10 |  | 1
10 |  | 1
4 |  | 1
1 |  | 1
8 |  | 4
 |  | Repeat yellow-blue-yellow-…
1 |  | *+1 cell ref |  |  |  | 12 |  | 0 |  |  |  |  | 0
6 |  |  |  | *+2 cell ref |  | 13 |  | 0 |  |  |  |  | 2
9 |  | *+1 cell ref |  |  |  | 15 |  | 1 |  |  |  |  | 2
14 |  |  |  | *+2 cell ref |  | 16 |  | 1 |  |  |  |  | 4
7 |  | *+1 cell ref |  |  |  | 18 |  | 2 |  |  |  |  | 4
8 |  |  |  | *+2 cell ref |  | 19 |  | 2 |  |  |  |  | 6
3 |  | *+1 cell ref |  |  |  | 21 |  | 3 |  |  |  |  | 6
10 |  |  |  |  |  | 22 |  | 3 |  |  |  |  | 8
5 |  |  |  |  |  |  |  |  |  |  |  |  | 8
2
9
Spreadsheet: 889588d1740465986-converting-decimals-to-dice-rolls-dice-limits
Sheet: Sheet1

 | 0.5477926779041045 | 0.4367489902157193 | 0.3466226332217783 | 0.5303073754276612 | 0.2491469340337321 | 0.6463583564874866 | 0.513186270935622 | 0.7792890097239141 | 0.5373486366995378 | 0.5805956467306749
formula | 42 | 34 | 26 | 41 | 23 | 45 | 36 | 53 | 41 | 42
s/b | 42 | 34 | 26 | 41 | 23 | 45 | 36 | 54 | 41 | 43
 |  | 0 | 11
 |  | 0.02777777777777778 | 11
 |  | 0.05555555555555555 | 12
 |  | 0.08333333333333333 | 13
 |  | 0.1111111111111111 | 14
 |  | 0.1388888888888889 | 15
 |  | 0.1666666666666667 | 16
 |  | 0.1944444444444444 | 21
 |  | 0.2222222222222222 | 22
 |  | 0.25 | 23
 |  | 0.2777777777777778 | 24
 |  | 0.3055555555555556 | 25
 |  | 0.3333333333333333 | 26
 |  | 0.3611111111111111 | 31
 |  | 0.3888888888888889 | 32
 |  | 0.4166666666666667 | 33
 |  | 0.4444444444444444 | 34
 |  | 0.4722222222222222 | 35
 |  | 0.5 | 36
 |  | 0.5277777777777778 | 41
 |  | 0.5555555555555556 | 42
 |  | 0.5833333333333334 | 43
 |  | 0.6111111111111112 | 44
 |  | 0.6388888888888888 | 45
 |  | 0.6666666666666666 | 46
 |  | 0.6944444444444444 | 51
 |  | 0.7222222222222222 | 52
 |  | 0.75 | 53
 |  | 0.7777777777777778 | 54
 |  | 0.8055555555555556 | 55
 |  | 0.8333333333333334 | 56
 |  | 0.8611111111111112 | 61
 |  | 0.8888888888888888 | 62
 |  | 0.9166666666666666 | 63
 |  | 0.9444444444444444 | 64
 |  | 0.9722222222222222 | 65
 |  | 1 | 66
Spreadsheet: 849750d1700148004-similar-to-protection-of-cells-can-you-mark-them-for-bulk-editing-to-refresh-a-report-ms-office-example
Sheet: (8ba) PSI Settings Diesel

 | NFPA 20 Appendix A   14.2.5   [NAME] vs Jockey PSI Calculator (Diesel Sheet)
 | Manufacturers pump data plate |  | PSI | GPM
 | 0% Flow |  |  | 0
 | 100% Flow
 | 150% Flow
 | Estimated maximum water supply
 |  | Start Stop Calcs | PSI | Explaination
 | 1 | Pump Churn Pressure |  | [NAME] Pressure on Curve
 | 2 | Water Supply |  | Estimated Suction Pressure
 | 3 | [NAME] |  | Total of  Lines 1 & 2
 | 4 | [NAME] |  | Line 3 Less 15 PSI
 | 5 | Fire Pump Stop |  | Line 3 Less 10 PSI
 | 6 | Fire Pump Start |  | Line 4 Less 5 PSI
 | 7 | [NAME] at Design Pressure |  | Total of Lines 1 & 2
 | 8 | Fire Pump PSI at Design Flow
Spreadsheet: 96397d1295813585-cross-referencing-excel-spread-sheets-eliminating-redundant-data-broken_seedboxes4-1-
Sheet: 2008

turned in spring/summer 2008
count | Box # | Mfg Date | What's Wrong | Warranty Year
1 | 189 | 7/03 | [NAME] | 2008
2 | 699 | 7/03 | [NAME] | 2008
3 | 160 | 7/03 | [NAME] | 2008
4 | 736 | 7/03 | [NAME] | 2008
5 | 293 | 7/03 | [NAME] | 2008
6 | 640 | 7/03 | [NAME] | 2008
7 | 180 | 7/03 | [NAME] | 2008
8 | 890 | 7/03 | [NAME] | 2008
9 | 308 | 7/03 | [NAME] | 2008
10 | 286 | 7/03 | [NAME] | 2008
11 | 716 | 7/03 | [NAME] | 2008
12 | 628 | 7/03 | [NAME] | 2008
13 | 172 | 7/03 | [NAME] | 2008
14 | 400 | 7/03 | [NAME] | 2008
15 | 620 | 7/03 | [NAME] | 2008
16 | 183 | 7/03 | [NAME] | 2008
17 | 30 | 12/02 | [NAME] | 2008
18 | 486 | 7/03 | [NAME] | 2008
19 | 157 | 7/03 | [NAME] | 2008
20 | 734 | 7/03 | [NAME] | 2008
21 | 691 | 7/03 | [NAME] | 2008
22 | 33 | 3/01 | [NAME] | 2008
23 | 627 | 7/03 | [NAME] | 2008
24 | 390 | 7/03 | [NAME] | 2008
25 | 150 | 7/03 | [NAME] | 2008
26 | 639 | 7/03 | [NAME] | 2008
27 | 789 | 7/03 | [NAME] | 2008
28 | 13 | 7/03 | [NAME] | 2008
29 | 643 | 12/02 | [NAME] | 2008
30 | no number | 7/03 | [NAME] | 2008
31 | 10001 | 7/03 | Broken Inside Bar | 2008
32 | 425 | 7/03 | [NAME] | 2008
33 | 849 | 7/03 | [NAME] | 2008
34 | 109 | 7/03 | [NAME] | 2008
35 | 828 | 7/03 | [NAME] and Hole | 2008
36 | 152 | 7/03 | [NAME] | 2008
37 | 512 | 7/03 | [NAME] | 2008
38 | 884 | 7/03 | [NAME] | 2008
39 | no number | 3/01 | [NAME] | 2008
40 | 649 | 7/03 | [NAME] | 2008
41 | 441 | 12/02 | [NAME] | 2008
42 | 715 | 7/03 | [NAME] | 2008
43 | 1147 | 2/04 | [NAME] | 2008
44 | no number | 7/03 | [NAME] | 2008
45 | 892 | 7/03 | [NAME] | 2008
46 | 77 | 7/03 | [NAME] | 2008
47 | 407 | 7/03 | [NAME] | 2008
48 | 60 | 12/02 | [NAME] | 2008
49 | 452 | 7/03 | [NAME] | 2008
50 | 644 | 7/03 | [NAME] | 2008
Spreadsheet: 0612f054-4720-455a-acf4-51001bae7d2e
Sheet: Nitrate Intake Calculator

Calculation of Total Nitrate Intake for Dairy Cattle
enter values in cells with blue text; all other values are calculated
CONTRIBUTION FROM FEED
 | Daily Intake | Moisture | Dry Matter | Daily DMI | Feed Water | Feed NO3-N | NO3-N Intake
Forages | lb as fed | % | % | lb | lb | [NAME] | mg
Corn Silage | 28.6 | 65 |  |  |  | 1700
MML Haylage | 26.8 | 50 |  |  |  | 460
[NAME]
[NAME] | 20 | 12 |  |  |  | 48
Ration Total
CONTRIBUTION FROM DRINKING WATER
Average daily milk production (lb) |  |  |  | 60
Current temperatures: enter cool or hot |  |  |  | cool
Expected total water intake (lb/d)
Expected drinking water intake (lb/d; total - feed water)
Water NO3-N content (ppm) |  |  |  | 8
NO3-N from drinking water (mg)
TOTAL DAILY INTAKE OF NO3-N (mg)
NO3-N CONTENT OF DIET (% DM)
ADJUSTMENT OF RATION TO CONTROL NO3-N CONTENT
Desired NO3-N level in total ration, including water (ppm) |  |  |  |  | 500
Desired NO3-N level in total ration, including water (% DM)
Content to be reduced (% DM)
Amount to be reduced
Highest NO3-N in forage (ppm)
Lowest NO3-N in forage (ppm)
Difference between high and low (ppm)
Difference between high and low (% DM)
Forage dry matter to be exchanged (lb)
Old intake level for high NO3-N forage (lb DM)
Dry matter % of high NO3-N forage
New intake level for high NO3-N forage (lb DM)
New as fed intake level for high NO3-N forage (lb)
Old intake level for low NO3-N forage (lb DM)
Dry matter % of low NO3-N forage
New intake level for low NO3-N forage (lb DM)
New as fed intake level for low NO3-N forage (lb)
Average cow body weight (lb) |  |  |  | 1300
Maximum intake (lb/cwt BW; table value)
Single meal maximum forage DMI (lb)
Spreadsheet: 862675d1710336819-like-vlookup-but-with-concatenate-results-sample-of-excel-aligw
Sheet: Sheet1

 | =TEXTJOIN(", ",,FILTER(B:B,A:A="Depreciation"))
 | =TEKST.KOMBINER(", ";;FILTRER(B:B;A:A="Depreciation"))
 |  |  |  |  | Account Description | Note
All amounts in NOK 1000 | Note | 2023-03-01 00:00:00 |  |  | Sales revenues | 2.1
Sales revenues |  | 238001.45254 |  |  | Other operating income | 2.2
Other operating income |  | 50446.37224 |  |  | Other revenues | 2.2
Other revenues |  | 51020.1236 |  |  | Revenues | 1.5
Revenues |  | 239467.94838 |  |  | Cost of sales | 2.3
Cost of sales |  | 181987.24508 |  |  | Gross profit | 1.5
Gross profit |  | 107480.7033 |  |  | [NAME] and personnel expenses | 2.4
[NAME] and personnel expenses |  | 126332.75118 |  |  | Other operating expenses | 2.5
Other operating expenses |  | 135409.27006 |  |  | Impairment losses | 2.6
Impairment losses |  | 50027.2359 |  |  | Operating expenses | 1.5
Operating expenses |  | 211769.25714 |  |  | EBITDA | 1.5
EBITDA |  | -54288.55383999999 |  |  | Depreciation and amortisation | 3.2
Depreciation and amortisation |  | 83488.31904 |  |  | EBIT | 1.5
EBIT |  | -87776.87288000001 |  |  | Financial income | 2.7
Financial income |  | 53341.85239 |  |  | Financial expense | 2.7
Financial expense |  | 51942.5634 |  |  | Taxes | 2.8
Net Financial items |  | 51399.28899 |  |  | Depreciation and amortisation | 3.3 | Changed 'z' to 's'.
Profit before tax |  | -86377.58389000001 |  |  | Depreciation and amortisation | 3.4
Taxes |  | 49426.1191
Net result |  | -85803.70298999999
Spreadsheet: 871342d1717729861-filter-function-e1-and-e2
Sheet: D

948 | Cal Industries Pvt Ltd,[NAME] (4000) | 4286.39 | 0 | 0 | 4286.39
646 | American Express  Pvt.Ltd,Los angles (30018) | 5343114.98 | 25 | 65 | 5343114.98
3610 | WHO (43662) | 4869.5 | 0 | 64 | 0
4 | DHL Express (0838) | 0 | 0 | 231664.12 | 0
846 | Lantus Incoporation.,New Airland | -2081323.2 | 634 | 126 | -2081323.2
12 | Jhonson & Johnson Movers  Ltd,Tumbaktu | 1102100 | 400 | 634 | 1102100
724 | [NAME] [P] Ltd (605053) | -223902.7 | 256 | 542 | -223902.7
864 | Ages Future Infrastracture-James Bond | 0 | 76330 | 76330 | 0
New | New Vaccine Corporation,Greenland (25636) | 5263 |  | 256 | 1924111
 | [NAME] | 0 |  |  | -526