tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 92646d1292236001-find-replace-data-into-multiple-cells-from-the-first-row-findreplaceforum-2-
Sheet: Tabelle1

Vorname | Nachname | Applikation | Login | Depot | [01] Controlling | [02] Erfassung | [03] Abrechnung | [04] Dispo ohne Preiserfassung | [05] [NAME] mit Preiserfassung | [06] Paletten | [07] QS | [08] Versicherung | [09] Vertrieb | [10] Eingang/Ausgang | [11] Tarif lesen | [12] Tarif schreiben | [13] Kondition lesen | [14] Kondition schreiben | [15] Partnerstamm | [16] Lager/Hub | [17] EDI Wiederholung | [18] MENU 66 | [19] MENU 77 | [20] MENU 88 | [50] KEYUSER
tgue002 | Ssieverding | Sandra |  |  |  |  | x |  | x |  |  |  |  |  | x |  | x |  |  |  |  |  |  | x
tgue006 | FHanisch | [NAME] |  |  |  |  |  |  |  |  |  |  | x |  | x |  | x
tgue007 | SBroehl | [NAME] |  |  |  | x |  | x |  |  | x | x
tgue014 | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | x |  | x |  |  |  | x | x | x | x | x
[NAME] | ELohmann | Erika |  |  |  | x |  | x
tgue027 | HPoetter | Holger |  |  |  |  | x |  | x |  |  |  |  |  | x |  | x
tgue033 | KMertens | Kerstin |  |  |  | x | x |  |  |  |  |  |  |  |  |  |  |  |  |  | x
tgue040 | SSchulte-Hoffman | [NAME] |  |  |  | x | x
tgue043 | NSielemann | Nina |  |  |  | x | x |  | x |  |  |  |  |  |  |  |  |  |  |  | x
tgue047 | KWeiss | Kerstin |  |  |  | x | x
tgue052 | TBoese | Thorben |  |  |  | x | x |  | x |  |  |  |  |  |  |  |  |  |  |  | x
tgue055 | MFelten | Monika |  |  |  | x |  |  |  | x
tgue061 | AWinter | Andreas |  |  |  |  |  |  |  |  |  |  | x |  |  |  |  |  |  | x
Spreadsheet: 65223d1265917192-countif-with-two-conditions-test
Sheet: Sheet1

Million |  |  | United Kingdom | Millions
12.0 and over | 3 |  | Cumbria | 3.4
8.0-11.9 |  |  | Northumbria | 2.7
4.0-7.9 |  |  | North West | 8.5
Under 4.0 |  |  | Yorkshire | 7.9
 |  |  | Heart of England | 13.6
 |  |  | East of England | 7.8
 |  |  | London | 7.9
 |  |  | South West | 15.1
 |  |  | Southern | 8.8
 |  |  | South East | 6.1
 |  |  | Scotland | 12
 |  |  | Wales | 8.8
 |  |  | Northern Ireland | 1.6
Spreadsheet: 769424d1645534714-search-for-numerical-value-and-in-column-in-a-table-then-return-text-from-another-column-excel-help
Sheet: Week 1

 |  |  |  |  |  |  |  |  |  |  | Total Cost / Meal | Main Meal | Over-order
 |  |  |  |  |  |  |  |  |  |  |  |  | Required: | 13 | 15 | 8 | 12 | 10 | 19 | 12 | 12 | 15 | 19
 |  |  |  |  |  |  |  |  |  |  |  |  | Type
 |  |  |  |  |  |  |  |  |  |  |  |  | Meal | Sausage & Ham Frittata | [NAME] in Creamy Mushroom Sauce | [NAME] in Tomato & Basil Sauce | Sausage & Ham Frittata | Cod in Parsley Sauce | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | MWM
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | Side 1
 |  |  |  |  |  |  |  |  |  |  |  |  | Side 2
 |  |  |  |  |  |  |  |  |  |  |  |  | Price
 |  |  |  |  |  |  |  |  |  |  | Total Cost / Pudding | Pudding | Over-order
 |  |  |  |  |  |  |  |  |  |  |  |  | Required: | 13 | 15 | 8 | 12 | 10 | 19 | 12 | 12 | 15 | 19
 |  |  |  |  |  |  |  |  |  |  |  |  | Type
 |  |  |  |  |  |  |  |  |  |  |  |  | MWM
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | Price
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday
 |  |  |  |  |  |  |  |  |  |  |  |  | 10 | Lunch | Tea | Lunch | Tea | Lunch | Tea | Lunch | Tea | Lunch | Tea
Product Name | Category | Product Code | Pack Size | Recommended Portions | [NAME] | Made Without Milk | Vegetarian | Vegan | Price | Price per Meal | Type | Cat | Cost per Meal | Order | Order | Order | Order | Order | Order | Order | Order | Order | Order
Pork Meatballs in Tomato & Herb Sauce | Pork | 328617 | Small | 4 |  |  |  |  | 5.56 |  | Main Meal
Sausage & Ham Frittata | Pork | 328624 | Small | 4 |  |  |  |  | 5.56 |  | Main Meal |  |  | 1 |  |  | 1
[NAME] in Creamy Mushroom Sauce | Poultry | 328443 | Small | 4 | • |  |  |  | 5.56 |  | Main Meal |  |  |  | 1
[NAME] in Tomato & Basil Sauce | Poultry | 328447 | Small | 4 | • |  |  |  | 5.56 |  | Main Meal |  |  |  |  | 1
[NAME] | Poultry | 328448 | Small | 4 |  |  |  |  | 5.56 |  | Main Meal |  |  |  |  |  |  |  | 1
Fish in Cheese Sauce | Fish | 328523 | Small | 4 | • |  |  |  | 5.56 |  | Main Meal
Cod in Parsley Sauce | Fish | 328527 | Small | 4 | • |  |  |  | 5.56 |  | Main Meal |  |  |  |  |  |  | 1
[NAME] | Beef | 328101 | Small | 2 |  |  |  |  | 5.56 |  | Main Meal
Cottage Pie | Beef | 328114 | Small | 2 | • |  |  |  | 5.56 |  | Main Meal
Spreadsheet: 707410d1607253611-need-vlookup-on-images-from-different-table-format-sample
Sheet: improper

 |  | Personalities: | xxxx |  |  | Personalities: | xxxx |  |  | Personalities: | xxxx
 |  | On Sale Date: | 2019-05-12 00:00:00 |  |  | On Sale Date: | 2019-05-12 00:00:00 |  |  | On Sale Date: | 2019-05-12 00:00:00
 |  | Weeks Off Sale: | 6464 |  |  | Weeks Off Sale: | 64 |  |  | Weeks Off Sale: | 654
 |  | Title: | YYY |  |  | Title: |  |  |  | Title:
 |  | Issue Code: | 64522 |  |  | Issue Code: | 68455 |  |  | Issue Code: | 64247
 |  | Cover Price: | 65 |  |  | Cover Price: | 65 |  |  | Cover Price: | 65
Spreadsheet: 167100d1341901330-filtering-one-specific-name-in-excel-2010-copy-of-morning-attendance-2-
Sheet: 16 Jan 2012

Daily Morning Staff |  |  |  |  | Monday
 | 07:30-14:30 |  | 2012-01-16 00:00:00
Name | Staff No. | Title | Time In | Out | Locations | Remarks
Naima Mohamed | 2166 | Client Ralation Supervisor | 07:30:00 | 14:30:00 | EFS
Sheikha [NAME] | 2120 | Reservation Officer | 07:30:00 | 14:30:00 | TOPS
Syed Sultan | 2888 | Supervisor | 07:30:00 | 14:30:00 | EFS
[NAME] | 4143 | Aircraft Team Leader | 07:00:00 | 14:30:00 | EFS
Jalil Nushadi | 1889 | Driver | 05:45:00 | 14:30:00 | EFS
[NAME] | 624 | Driver | 07:30:00 | 14:30:00 | EFS
Soud Sharar | 2097 | [NAME] Officer | 07:30:00 | 14:30:00 | [NAME]
[NAME] | 1897 | Manager | 07:30:00 | 14:30:00 | EFS
[NAME] | 1861 | Duty Officer | 07:30:00 | 14:30:00 | EFS
Spreadsheet: 840394d1692706628-last-8-odd-and-different-numbers-book1-gianfrancopierino-
Sheet: Sheet1

Numbers |  | Last 8 odd | last 8 even
30
1
1
5
9
18
17
31
6
6
1
0
23
14
5
20
30
20
19
35
20
4
12
20
31
5
2
25
29
8
14
34
20
22
0
14
30
26
21
14
31
33
13
34
22
7
29
25
10
34
9
11
16
29
19
33
8
13
29
35
17
16
7
22
8
20
20
25
15
34
16
15
4
29
0
14
20
7
15
25
9
1
13
34
9
3
2
11
29
35
0
16
31
16
31
15
31
30
31
24
16
27
18
0
30
33
15
25
14
18
2
3
17
36
28
9
3
15
10
14
17
9
12
28
16
32
15
25
11
6
24
32
0
11
33
28
33
27
30
23
8
4
5
5
22
14
21
21
20
25
15
3
31
22
1
11
23
0
2
17
8
36
9
3
29
18
25
25
30
2
29
14
1
7
18
6
15
15
33
20
8
9
22
10
29
36
16
2
12
36
35
25
26
21
6
13
13
27
23
Spreadsheet: 661bd5eb-f3f3-4680-b655-eb8f774fcf3f
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
40195011 | 2014-02-23 10:16:53 | AXIS | 0 | 5 | 6 | 1243217 | [NAME] boy | 12493 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
40195242 | 2014-02-23 10:41:29 | ALLIES | 1 | 6 | 5 | 1243217 | [NAME] boy | 12493 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
40195511 | 2014-02-23 10:57:12 | ALLIES | 1 | 5 | 3 | 1529170 | pierricko | 6160 | western | 1944-06-06 | 1944-06-06 | Sword Beach | Sword Beach
40195656 | 2014-02-23 11:12:35 | AXIS | 1 | 5 | 4 | 1529170 | pierricko | 6160 | western | 1944-06-06 | 1944-06-06 | Sword Beach | Sword Beach
Spreadsheet: 858902d1707400707-help-sumif-multiple-tabs-example2
Sheet: June

Name | NHS | 1st | 2nd | 3rd | Seen | Comments |  |  | Month Summary
Name 66
Name 67
Name 68 |  |  |  |  |  |  |  |  | Done Totals
Name 69 |  |  |  |  |  |  |  |  | Outstanding Totals
Name 70 |  |  |  |  | ee
Name 71
Name 72
Name 73
Name 74
Name 75
Name 76
Name 77
Spreadsheet: 41428d1239894410-dynamic-range-help-example
Sheet: Sheet1

Department | Account | Rate | OT % | Hours | Total
Z | Exempt | 0 | 0 | 0 | 0
Z | [NAME] | 0 | 0 | 0 | 0
Z | Resident Care Coord | 0 | 0 | 0 | 0
Z | RNs | 27.6143 | 0.03 | 110 | 3037.573
Z | LPNs | 25.1732 | 0.05 | 470 | 11831.404
Z | CNAs | 12.7411 | 0.05 | 1096 | 13964.2456
Z | [NAME] | 15.3161 | 0.05 | 236.992 | 3629.7931712
Z | [NAME] | 13.1428 | 0.05 | 112 | 1471.9936
Z | Other Nurses | 0 | 0.03 | 0 | 0
Z | Training | 16.9538 | 0 | 30 | 508.614
Z | [NAME] | 0 | 0 | 0 | 1635.99900856
Q | Exempt | 19.38 | 0 | 80 | 1550.4
Q | [NAME] | 0 | 0.02 | 0 | 0
Q | Chefs | 0 | 0 | 0 | 0
Q | Cooks | 12.1176 | 0.05 | 118.72 | 1438.601472
Q | Utility Workers | 0 | 0.03 | 0 | 0
Q | Servers | 0 | 0.03 | 0 | 0
Q | Bussers | 10.0674 | 0.06 | 382.13 | 3847.055562
Q | Training | 10.9752 | 0 | 2 | 21.9504
Q | [NAME] | 0 | 0 | 0 | 302.75340732
L | Exempt | 17 | 0 | 40 | 680
L | [NAME] | 0 | 0 | 0 | 0
L | HouseKeepers | 10.4854 | 0.05 | 160 | 1677.664
L | Laundry | 10.197 | 0.05 | 112 | 1142.064
L | Training | 10.3824 | 0 | 5 | 51.91200000000001
L | [NAME] | 0 | 0 | 0 | 140.9864
A | Exempt | 0 | 0 | 0 | 0
A | [NAME] | 18.87475 | 0.06 | 120 | 2264.97
A | [NAME] | 0 | 0 | 0 | 135.8982
Spreadsheet: 0b46330a-f197-4803-8bc7-284ae92fd82b
Sheet: Sheet1

Utilities | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 | January | February | March | April | Totals
Gas | 67 | 100 | 84 | 25 | 276
Water | 37 | 40 | 35 | 35 | 147
Electricity | 154 | 140 | 150 | 125 | 569
Phone | 199 | 219 | 219 | 204 | 841
Cable | 85 | 85 | 85 | 85 | 340
 | 542 | 584 | 573 | 474 | 2173 | Grand Total
Spreadsheet: 5364dc7e-a577-49a4-9446-20401624cef2
Sheet: PPI 002 (WWTF Effluent)

Permit No.: |  | WQ0002284 |  | Facility Name: |  | [NAME] |  |  |  |  | County: | Dare |  | Month: |  |  | Year:
PPI: |  | 002 | Flow Measuring Point: |  |  |  |  |  |  | Parameter Monitoring Point:
Parameter Code |  |  | 50050 | 00310 | 31616 | 00610 | 70300 | 00620 | 00400 | 00530 | 00076 | 00940
Day | ORC Arrival Time | ORC Time On Site | Flow
 | 24-hr | hrs | GPD
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
Average:
Daily Maximum:
Daily Minimum:
Sampling Type: |  |  | Recorder | Composite | Grab | Composite | Composite | Composite | Grab | Recorder | Recorder | Composite
Monthly Limit: |  |  | 350000 | 10 | 14 | 4 |  | 10 |  | 5
Daily Limit: |  |  |  | 15 | 25 | 6 |  |  | 6-9 | 10 | 10
Sample Frequency: |  |  | [NAME] | See Permit | See Permit | See Permit | 3 X Year | See Permit | 5 x Week | See Permit | [NAME] | 3 X Year
Spreadsheet: 189995d1351498512-how-to-consolidate-data-with-different-paramenter-test
Sheet: 2011a

 | 1
Project Code | M10001 | M10002 | M10005 | M10007 | M10009 | R10141 | R10142 | [NAME] | [NAME] | R10145 | R10146 | Total
Revenue
Government | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 35000 | -122397.64 | 0 | -0.5
Private | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Contract | 0 | -42502.66 | 2307.26 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Revenue Total | 0 | -42502.66 | 2307.26 | 0 | 0 | 0 | 0 | 35000 | -122397.64 | 0 | -0.5
2 - Cost
Prime Costs
Material Usage | 0 | 0 | 0 | 0 | 0 | -12697.16999999997 | -4664.31 | -13.43 | 0 | 0 | 0
Sub-Contractor Fees | 0 | 0 | 0 | 75000 | 0 | -48058.29999999999 | 12965.92 | -1820 | 0 | -13800 | -10406.9
Worker Overtime | 0 | 0 | 0 | 0 | 0 | -14635.6 | -1830.63 | -3944.22 | 0 | 0 | 0
Worker Salary | 0 | -144 | 0 | 0 | 0 | -11975.76 | -4136.03 | -2903.28 | 0 | 0 | 0
Prime Costs Total | 0 | -144 | 0 | 75000 | 0 | -87366.82999999996 | 2334.949999999997 | -8680.93 | 0 | -13800 | -10406.9
Direct Costs
Bad Debts Written off | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Bank Other Charges | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Courier Charges | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Discount Allowed | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Entertainment | 0 | 0 | 0 | 0 | 0 | -388 | 0 | 0 | 0 | 0 | 0
Freight Charges | 0 | 0 | 0 | 0 | 0 | -15000 | 0 | 0 | 0 | 0 | 0
Fuel & Oil Usage | 0 | 0 | 0 | 0 | 0 | -1930.699999999997 | -1109.16 | 0 | 0 | 0 | 0
Hire Charges | 0 | 0 | 0 | 0 | 0 | -19200 | 0 | 0 | 0 | 0 | 0
Printing | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Professional Fees | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Property Rental | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Realized Forex Loss | -1168.87 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Refreshment | 0 | 0 | 0 | 0 | 0 | -841.4 | 0 | -340 | 0 | 0 | -120
Repair Of Machinery | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Stationery | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Telephone And Telefax | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -302.97 | 0 | 0 | 0
Travelling-Accommodation | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Travelling-Fares | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Travelling-Subsist Allowance | 0 | 0 | 0 | 0 | 0 | -50 | 0 | 0 | 0 | 0 | 0
Vehicle Running Exp-Others | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
X-Ray & Radiography | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Direct Costs Total | -1168.87 | 0 | 0 | 0 | 0 | -37410.1 | -1109.16 | -642.97 | 0 | 0 | -120
2 - Cost Total | -1168.87 | -144 | 0 | 75000 | 0 | -124776.9299999999 | 1225.789999999997 | -9323.9 | 0 | -13800 | -10526.9
Total | -1168.87 | -42646.66 | 2307.26 | 75000 | 0 | -124776.9299999999 | 1225.789999999997 | 25676.1 | -122397.64 | -13800 | -10527.4
Spreadsheet: 761495d1640951599-update-range-based-on-lookup-value-cf-lookup-value-aligw
Sheet: Formula

Number of Years: | 15
Years | Notional Calculation
Spreadsheet: 719809d1613831402-how-to-add-sum-of-cells-that-do-not-have-colour-sample
Sheet: Sample

 |  |  |  |  | In | Out
 |  |  |  |  | 120.26
 |  |  |  |  | 21.82
 |  |  |  |  | 16.1
 |  |  |  |  | 22.98
 |  |  |  |  | 16.39
 |  |  |  |  | 34.49
 |  |  |  |  |  | 26.44
 |  |  |  |  | 3.59
 |  |  |  |  | 14.71
 |  |  |  |  | 32.7
 |  |  |  |  | 130
 |  |  |  |  | 10.02
 |  |  |  |  | 7.69
 |  |  |  |  | 178
 |  |  |  |  | 2.02
 |  |  |  |  | 4.99
 |  |  |  |  | 20.16
 |  |  |  |  | 7.27
 |  |  |  |  | 66.27
 |  |  |  |  | 87.46
 |  |  |  |  | 14.3
 |  |  |  |  | 4.19
 |  |  |  |  | 18.76
 |  |  |  |  | 1839.99
 |  |  |  |  |  | 675.99
 |  |  |  |  |  | 200
 |  |  |  |  |  | 400
 |  |  |  |  | 18.24
 |  |  |  |  | 33.62
 |  |  |  |  | 11.47
 |  |  |  |  | 29.81
 |  |  |  |  | 27
 |  |  |  |  | 33.82
 |  |  |  |  | 8.99
 |  |  |  |  | 33.02
 |  |  |  |  | 13.49
 |  |  |  |  | 71.23
 |  |  |  |  | 117.3
 |  |  |  |  | 103.25
 |  |  |  |  | 3.39
 |  |  |  |  | 9.15
 |  |  |  |  | 25.27
 |  |  |  |  | 3.14
 |  |  |  |  | 15
 |  |  |  |  | 4.23
 |  |  |  |  | 34.49
 |  |  |  |  | 25.27
 |  |  |  |  | 107.65
 |  |  |  |  | 12.42
 |  |  |  |  | 202.97
 |  |  |  |  | 14.93
 |  |  |  |  | 34.75
 |  |  |  |  | 6.31
 |  |  |  |  | 5.05
 |  |  |  |  | 11.4
 |  |  |  |  | 5.75
 |  |  |  |  | 150.3
 |  |  |  |  | 10.34
 |  |  |  |  | 86.25
 |  |  |  |  | 25.97
 |  |  |  |  | 6.26
 |  |  |  |  | 33.97
 |  |  |  |  | 14.49
 |  |  |  |  | 14.74
 |  |  |  |  | 8.05
 |  |  |  |  | 26.27
 |  |  |  |  | 335.78
 |  |  |  |  | 64.54
 |  |  |  |  | 5.15
 |  |  |  |  | 25
 |  |  |  |  | 23
 |  |  |  |  | 28.74
 |  |  |  |  | 1.89
 |  |  |  |  | 10.43
 |  |  |  |  | 16.75
 |  |  |  |  | 7.52
 |  |  |  |  | 19
 |  |  |  |  | 19.16
 |  |  |  |  | 33.85
 |  |  |  |  | 48.55
 |  |  |  |  | 86.02
 |  |  |  |  | 9.15
 |  |  |  |  | 18
 |  |  |  |  | 53.28
 |  |  |  |  | 11.49
 |  |  |  |  | 74.27
 |  |  |  |  | 7
 |  |  |  |  | 25.49
 |  |  |  |  | 159.7
 |  |  |  |  | 49.08
 |  |  |  |  | 64.24
 |  |  |  |  | 15.21
 |  |  |  |  | 4.58
 |  |  |  |  | 14.95
 |  |  |  |  | 57.71
 |  |  |  |  | 9.2
 |  |  |  |  | 2.69
 |  |  |  |  | 6.42
 |  |  |  |  | 285.57
 |  |  |  |  | 248.99
 |  |  |  |  |  |  |  | Coumn F Less Column G
 |  |  |  |  |  |  | I would like all of the cells that do not have a colour fill to be added automatically, if it's possoble!
Spreadsheet: 188066d1350668242-get-data-from-another-workbook-to-a-summary-workbook-copy-of-data-for-intercompany-workings-tiernan
Sheet: CAR

INTRAGROUP ASSETS
Reporting Company information
Intragroup Company | E- sigma account |  | Invoicing currency | Balance | Local currency | Balance
 | Code | Description |  | in invoicing Currency |  | in Local Currency
Company B | 173008 | Intra-Group trade receivables | NOK | 39544.214 | NOK
Company A | 173008 | Intra-Group trade receivables | SEK | 40189.598 | NOK
Company G | 173708 | Other intra-Group receivables | NOK | 133.572 | NOK
Company E | 173008 | Intra-Group trade receivables | EUR | 7487.64 | NOK
Company C | 173008 | Intra-Group trade receivables | DKK | 11991.414 | NOK
Company F | 173708 | Other intra-Group receivables | NOK | 38.488 | NOK
Company B | 173408 | Other intra-Group accruals | NOK | 28555.863 | NOK
Company E | 173708 | Other intra-Group receivables | NOK | 45.1 | NOK
Spreadsheet: 847828d1698679063-single-dynamic-function-for-sumproduct-sumpro
Sheet: test

Name |  |  | DataX
Boll
Apple |  |  |  | 49.4001079469233
Orange |  |  |  | 12469.98490726159
Guava |  |  |  | 339.1
Pasta |  |  |  | 372.9
Lolliop |  |  |  | 62.40000000000001
[NAME] |  |  |  | 3019.532533770779
Zone |  |  |  | 2352
Litichi |  |  |  | 2621.32
[NAME] |  |  |  | 373.22
Wole |  |  |  | 52.17
Rispary |  |  |  | 0
Data | MX |  | Boll | Apple | Orange | Guava | Pasta | Lolliop | [NAME] | Zone | Litichi | [NAME] | Wole | Rispary
Amazon | 21.202158938466 |  |  |  | 12 |  |  |  | 2.1
Filipkart | 21.6 |  |  |  | 14.5
On the bay | 63.44 |  |  |  | 63.6 |  |  |  | 3.2
Google | 63 |  |  | 0.26 | 99 | 2.5 |  |  | 44 |  | 6.6 | 1.48
Github | 24 |  |  |  | 45 | 3.6 | 6.6 | 2.6 |  | 98 | 1.23 | 7.26
Hotmail | 66 |  |  |  |  |  | 3.25
Yahoo | 0
Tesla | 34 |  |  | 0.94 | 8.46 | 2.8 |  |  |  |  | 64 | 3.11
Gokul | 11.1 |  |  |  | 12.45 |  |  |  |  |  |  |  | 4.7
Mahalabr | 63 |  |  |  | 1.98
Spreadsheet: kimberly_watson__20552__imbalsumm0108
Sheet: EOG

 | 500249 |  | 500260 |  | 500646 |  | 500598
 | Pronghorn |  | Pitchfork Ranch |  | Tristi Draw
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 26125 | 26316 | 9809 | 8750
2 | 25579 | 26140 | 9577 | 8750 |  |  |  | 176
3 | 25083 | 26316 | 9649 | 8750
4 | 24738 | 26069 | 9083 | 8668
5 | 24635 | 26316 | 9400 | 8750
6 | 24092 | 26316 | 9085 | 8750
7 | 23913 | 26316 | 7801 | 8750 |  |  | 67
8 | 23713 | 26316 | 9583 | 8750
9 | 23424 | 22812 | 9134 | 8248
10 | 23086 | 22816 | 9222 | 8250
11 | 22763 | 22784 | 9130 | 8239
12 | 22799 | 22796 | 9160 | 8243
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-07-31 00:00:00 |  |  |  |  |  |  |  |  | 150097
2001-08-12 00:00:00
CBS Volume
 |  |  | -60022
Spreadsheet: 836723d1689606491-find-true-find-true-1-
Sheet: Blad1

# | [NAME]
 | Look for value A2 in 'column A' on 'sheet2' and return value 'Found' if value A2 is found in 'column A' on 'sheet2'.
6.01
6.02
6.03
6.04 | Found | Found
6.05
6.06
6.07
6.08
6.09
6.10
6.11
6.12
6.13
6.14
6.15
6.16
6.17
6.18
6.19
6.20
6.21
6.22 | Found | Found
6.23
6.24
6.25
6.26
6.27
6.28
6.29
6.30
6.31
6.32
6.33
6.34
6.35
6.36
6.37
6.38
6.39
6.40
6.41 | Found | Found
6.42
6.43
6.44
6.45 | Found | Found
6.46 | Found | Found
6.47 | Found | Found
6.48
6.49
6.50
6.51
6.52
6.53
6.54
6.55
6.56
6.57
6.58
6.59
6.60
6.61
6.62
6.63
6.64 | Found | Found
6.65 | Found | Found
6.66 | Found | Found
6.67 | Found | Found
6.68 | Found | Found
6.69 | Found | Found
6.70
6.71
6.72
6.73
6.74
6.75
6.76
6.77
6.78
6.79
6.80
6.81
6.82
8.83
8.84
8.85
7.01
7.02
7.03
7.04
7.05
7.06
7.07
7.08
7.10
8.01
8.02
8.03
8.04
8.05
8.06
8.07
9.01
9.02
9.03
9.04
9.05
Spreadsheet: 52376d1252070862-conditional-formatting-to-highlight-2-days-before-the-expiry-date-excel-forum-conditional-format-today-2
Sheet: Sheet1

item | [NAME] | [NAME] | francis | status
apple |  | 2009-09-09 00:00:00 |  | eat now!!! | incorrect
orange |  |  | 2009-09-10 00:00:00 | eat now!!! | incorrect
candy | 2009-09-10 00:00:00 |  |  | don’t worry | correct
mango |  |  | 2009-09-03 00:00:00 | eat now!!! | correct
banana | 2009-09-11 00:00:00 |  |  | don’t worry | correct
kiwi |  | 2009-09-04 00:00:00 |  | eat now!!! | correct
Conditional Formatting to highlight 2 days before the expiry date - Excel Help Forum
Spreadsheet: 0c8cf9da-92cb-4b08-bf08-6a306ebc7f7d
Sheet: Sheet1

Unnamed: 0 | Center for Workforce Information & Analysis | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 | Revised August 30, 2013
 | Pennsylvania Average Weekly Wage
 | by Calendar Year
 | Calendar | Average
 | Year 1/ | Weekly Wage 2/ |  | % Change
 | 1970 | 137.79 |  | 0.05553853225065115
 | 1971 | 145.69 |  | 0.05733362363016189
 | 1972 | 153.71 |  | 0.05504839041801091
 | 1973 | 163.62 |  | 0.06447205777112743
 | 1974 | 179.4 |  | 0.09644297763109645
 | 1975 | 192.85 |  | 0.07497212931995534
 | 1976 | 206.44 |  | 0.07046927663987557
 | 1977 | 220.33 |  | 0.06728347219531106
 | 1978 | 232.17 |  | 0.0537375754549992
 | 1979 | 251.22 |  | 0.08205194469569717
 | 1980 | 273.7 |  | 0.0894833213916089
 | 1981 | 296.77 |  | 0.08428936792108145
 | 1982 | 312.79 |  | 0.05398119756040044
 | 1983 | 326.11 |  | 0.04258448160107418
 | 1984 | 340.89 |  | 0.04532213056943967
 | 1985 | 354.51 |  | 0.0399542374372965
 | 1986 | 369.59 |  | 0.04253758709204249
 | 1987 | 389.05 |  | 0.0526529397440408
 | 1988 | 410.09 |  | 0.05408045238401224
 | 1989 | 426 |  | 0.03879636177424474
 | 1990 | 447.36 |  | 0.05014084507042257
 | 1991 | 464.91 |  | 0.0392301502145923
 | 1992 | 491.49 |  | 0.05717235593985929
 | 1993 | 500.5 |  | 0.01833201082422835
 | 1994 | 513.61 |  | 0.02619380619380622
 | 1995 | 532.19 |  | 0.03617530811315987
 | 1996 | 552.25 |  | 0.03769330502264218
 | 1997 | 575.58 |  | 0.04224535989135363
 | 1998 | 603.25 |  | 0.04807324785433816
 | 1999 | 625.24 |  | 0.03645254869457109
 | 2000 | 650.17 |  | 0.03987268888746713
 | 2001 | 668.04 |  | 0.02748511927649692
 | 2002 | 683.37 |  | 0.02294772768097725
 | 2003 | 705.81 |  | 0.03283726239079846
 | 2004 | 735.3 |  | 0.04178178263271987
 | 2005 | 756.34 |  | 0.02861417108663141
 | 2006 | 788.47 |  | 0.04248089483565591
 | 2007 | 824.79 |  | 0.04606389589965368
 | 2008 | 846.71 |  | 0.02657646188726836
 | 2009 | 854.55 |  | 0.009259368614992049
 | 2010 | 872.08 |  | 0.02051372067169866
 | 2011 | 896.86 |  | 0.02841482432804327
 | 2012 | 923.69 |  | 0.02991548290703124
 | 1/ Calendar Year begins January 1 and ends December 31.
 | 2/ Excludes Federal Government.