tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: sally_beck__33954__Weekly Operating Report 2-15
Sheet: EIM New Deals

New Deals for | JANUARY |  |  |  |  |  |  |  | FEBRUARY
 | Week Ending 4 |  | Week Ending 11 |  | Week Ending 18 |  | Week Ending 25 |  | Week Ending 1 |  | Week Ending 8 |  | Week Ending 16 |  | Week Ending 23
 | EOL | Non-EOL | EOL | Non-EOL | EOL | Non-EOL | EOL | Non-EOL | EOL | Non-EOL | EOL | Non-EOL | EOL | Non-EOL | EOL | Non-EOL
Financial
ENA
Gas (Calgary)
Gas (Houston)
Power (Houston)
Power (Calgary)
EIM
Lumber | 0 | 23 | 0 | 7 | 0 | 10 | 0 | 19 | 0 | 19 | 0 | 24 | 0 | 8
Newsprint | 0 | 2 | 2 | 0 | 0 | 2 | 0 | 2 | 0 | 0 | 0 | 10 | 0 | 12
Pulp (recycled paper) | 0 | 1 | 0 | 4 | 0 | 12 | 0 | 10 | 0 | 4 | 0 | 0 | 0 | 0
Steel | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0
EGM
IR/FX
Weather
Liquids
Emissions
Physical
ENA
Gas (Houston)
Gas (Calgary)
Power (Houston)
Power (Calgary)
EIM
Lumber | 1 | 62 | 12 | 107 | 10 | 83 | 2 | 103 | 5 | 62 | 7 | 38 | 4 | 26
Newsprint | 0 | 3 | 0 | 15 | 1 | 6 | 0 | 22 | 0 | 4 | 0 | 2 | 0 | 18
Pulp (recycled paper) | 4 | 1 | 3 | 10 | 0 | 12 | 0 | 9 | 2 | 23 | 4 | 13 | 3 | 12
Steel | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 2
EGM
Liquids
Coal
Spreadsheet: 116887d1312274964-excel-2007-form-a-table-inside-a-table-ex
Sheet: Sheet1

roll no | name | module | grade
1 | a1 | maths | A
 |  | science | A
 |  | Arts | B
2 | b1 | maths | A+
 |  | science | A-
 |  | Arts | B
Spreadsheet: 673446d1587391790-solved-calculating-revolving-inventory-formula-1450-uniform-inventory
Sheet: Sheet1

 |  |  |  |  | Week 1 |  |  | Week 2 |  |  | Week 3 |  |  | Week 4
 |  |  |  |  | 2020-01-03 00:00:00
Locker # | Item Description | Employee | Team | Inventory | Picked Up | Returned | Missing | Picked Up | Returned | Missing | Picked Up | Returned | Missing | Picked Up | Returned | Missing
1 | Coveralls | [NAME] | Maintenance | 8 | 4 | 3 |  | 2 | 2 |  | 3 | 4 |  | 5 | 3
Spreadsheet: 752864d1635023155-reconcile-entries-from-2-sheets-reconcile-1_answer
Sheet: FINAL Result

Name | Date of service | Insurance | Service Provider | ETF number | Invoice# | Paid 1 | Paid 2 | Total | Payment Date
Test, Adam | 2021-04-04 00:00:00 | BCD | FO | xx-23 | [NAME] | 34 | 2 |  | 2021-10-05 00:00:00
Test, Adam | 2021-05-05 00:00:00 | BCD | FO
Test, Adam | 2021-09-15 00:00:00 | BCD | FO | xyz-123 | gdf | 5 | 1 |  | 2021-10-05 00:00:00
Test, [NAME] | 2021-04-05 00:00:00 | BCD | FO
Test, [NAME] | 2021-06-05 00:00:00 | BCD | FO | 564-ax | cc | 23 | 3 |  | 2021-10-07 00:00:00
Test, [NAME] | 2021-09-17 00:00:00 | BCD | FO
Test, [NAME] | 2021-04-07 00:00:00 | ADD | OO | zds-234 | fhgf | 25 | 6 |  | 2021-10-05 00:00:00
Test, [NAME] | 2021-08-05 00:00:00 | ADD | OO | azxc-1 | hfgh | 23 | 5 |  | 2021-10-15 00:00:00
Test, [NAME] | 2021-09-27 00:00:00 | ADD | OO | 785-21 | v b | 345 | 4 |  | 2021-10-05 00:00:00
Test, [NAME] | 2021-01-01 00:00:00 | MCR | OO | fhghm-9 | sfw | 12 | 7 |  | 2021-10-05 00:00:00
Test, [NAME] | 2021-04-08 00:00:00 | MCR | OO | sfdfg-3 | ghg | 76 | 8 |  | 2021-10-18 00:00:00
Test, [NAME] | 2021-09-30 00:00:00 | MCR | OO
Test, Mary | 2021-04-06 00:00:00 | ADD | FO | cbnb-56 | 464c\456v | 67 | 3 |  | 2021-10-18 00:00:00
Test, Mary | 2021-07-07 00:00:00 | ADD | FO | cbgn-332 | v b | 4 | 2 |  | 2021-10-05 00:00:00
Test, Mary | 2021-09-27 00:00:00 | ADD | FO | bfghf-23 | cvcv | 23 | 1 |  | 2021-10-07 00:00:00
Tester / Ken | 2021-03-03 00:00:00 | MCR | KH
Tester / Ken | 2021-04-07 00:00:00 | MCR | KH
Tester / Ken | 2021-10-01 00:00:00 | MCR | KH | bfgnm-3 | 4564x | 52 | 4 |  | 2021-10-07 00:00:00
Testing, Brook | 2021-03-04 00:00:00 | MCR | KH | cvn-4567 | 53dc | 3 | 2 |  | 2021-10-07 00:00:00
Testing, Brook | 2021-04-20 00:00:00 | MCR | KH | xcvb-4323 | 354wws | 8 | 2 |  | 2021-10-18 00:00:00
Testing, Brook | 2021-10-05 00:00:00 | MCR | KH | cg-2345 | xvcb4 | 23 | 6 |  | 2021-10-07 00:00:00
Spreadsheet: 0a5288de-93ee-4aa5-abb7-fd679c857fa4
Sheet: Sheet1

Table 8--U.S. cotton textile imports, by origin | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 | July | Aug. | Sep. | Sep.
Region/country | 2012 | 2012 | 2012 | 2011
 | 1,000 pounds 1/
North America | 151065 | 150420.33 | 145729.901 | 157204.648
Canada | 2831.725 | 2674.083 | 2913.548 | 3328.759
Costa Rica | 896.401 | 765 | 723 | 775
Dominican Republic | 6478.147 | 5836.309 | 5707.788 | 6620.725
El Salvador | 22206.778 | 21329.021 | 22698.663 | 20097.597
Guatemala | 8923.176 | 9116.011 | 8594.423 | 8927.619
Haiti | 13211.642 | 14008.598 | 12907.656 | 15388.431
Honduras | 33010.858 | 30932.395 | 31310.109 | 32127.603
Mexico | 48780.919 | 48979.265 | 44187.845 | 50459.637
Nicaragua | 14723.857 | 16777 | 16686.045 | 19460.162
South America | 5183.994 | 4228.816 | 4331.301 | 4236.295
Brazil | 236.376 | 170 | 190 | 258
Colombia | 1936.756 | 1667.182 | 1503.615 | 1637.269
Peru | 2930.678 | 2326.195 | 2572.804 | 2258.394
Europe | 13463.58 | 17281.786 | 13179.888 | 11843.145
Germany | 953.908 | 1082 | 1067.872 | 894
Italy | 1818.162 | 1375.59 | 1043 | 1009.976
Portugal | 1694.938 | 1960.082 | 2036.805 | 1659.639
Turkey | 4995.832 | 9236.557 | 6417.41 | 5595
Asia | 608560.997 | 593843.518 | 557189.433 | 571521.562
Bahrain | 1481.268 | 1603.854 | 1603.281 | 1312.128
Bangladesh | 52601.021 | 49917.431 | 42647.417 | 38038.559
Cambodia | 24132.648 | 22042.556 | 23299.571 | 22682.9
China | 278017.629 | 269902.006 | 267330.067 | 272816.721
Hong Kong | 761.964 | 903 | 749 | 947
India | 58610.942 | 65146.792 | 67441.417 | 57585.799
Indonesia | 34590.68 | 30755.742 | 26726.695 | 31289.363
Israel | 749.548 | 818 | 852 | 603
Japan | 1152.52 | 1354.454 | 920 | 1118.666
Jordan | 5035.892 | 4792.581 | 3969.346 | 4326.312
Malaysia | 2881.054 | 2615.194 | 3182.172 | 2917
Pakistan | 69007.787 | 72110 | 60908.713 | 67286.327
Philippines | 6171.968 | 9410.839 | 5029.055 | 4835.159
South Korea | 6727.069 | 6208.379 | 4803.132 | 6385.705
Sri Lanka | 6318.508 | 6764.815 | 5930.376 | 6611.932
Taiwan | 2562.357 | 2580.963 | 2677.924 | 2678.989
Thailand | 6695.569 | 6859.299 | 6924.272 | 8132.174
Vietnam | 49690.439 | 43402.415 | 40974 | 40295.068
Oceania | 51.074 | 58.213 | 29.429 | 62.975
Africa | 20330.762 | 17852.41 | 14668.868 | 17207.485
Egypt | 9792.71 | 8965.207 | 7509.224 | 7373.785
Kenya | 3024.88 | 2979.749 | 2221.251 | 3691.903
[NAME] | 4444.874 | 3133.42 | 3122.263 | 3589.091
[NAME] | 849.928 | 1130 | 647 | 1114.143
World 2/ | 798654.952 | 783684.875 | 735128.82 | 762081.02
 |  |  |  |  |  |  | 95
1/ Raw-fiber equivalent.  2/ Totals may not add due to rounding.
Last update:  12/12/12.
Sources: USDA, Economic Research Service; and USDC,
U.S. Census Bureau.
Spreadsheet: 136153d1326438447-excel-2007-monthly-profit-loss-test-14-
Sheet: Sheet1

Date | Entry | Exit | Profit/Loss | Monthly Profit Loss
2011-01-03 00:00:00 | 296.5 | 292.8
2011-01-03 00:00:00 | 296.5 | 293.4
2011-01-04 00:00:00 | 269.85 | 293.4
2011-01-19 00:00:00 | 269.85 | 278.75
2011-01-25 00:00:00 | 253.5 | 278.75
2011-02-02 00:00:00 | 253.5 | 249.8
2011-02-02 00:00:00 | 256 | 249.8
2011-03-02 00:00:00 | 256 | 259.25
2011-08-02 00:00:00 | 245.85 | 259.25
14/2/2011 | 245.85 | 242.7
15/2/2011 | 247.8 | 242.7
15/2/2011 | 247.8 | 241.5
15/2/2011 | 249.1 | 241.5
17/2/2011 | 249.1 | 241
18/2/2011 | 234.2 | 241
25/2/2011 | 234.2 | 240.65
2011-08-03 00:00:00 | 232.2 | 240.65
16/3/2011 | 232.2 | 228.65
16/3/2011 | 228.2 | 228.65
22/3/2011 | 228.2 | 260.2
2011-08-04 00:00:00 | 252.25 | 260.2
18/4/2011 | 252.25 | 248
18/4/2011 | 240.5 | 248
27/4/2011 | 240.5 | 237.5
29/4/2011 | 225.3 | 237.5
13/5/2011 | 225.3 | 222.2
16/5/2011 | 203.5 | 222.2
27/5/2011 | 203.5 | 212.9
2011-08-06 00:00:00 | 188.15 | 212.9
Spreadsheet: 606359d1547578591-transposing-certain-rows-into-columns-excel-help
Sheet: How i would like it

Name | Candidate Identifier | Question Description (BL) | Answer (Choice) (BL)
 |  |  | Consumption, Saving, Labor Markets, Informal Economy (E2) | Financial Economics (G) (e.g., financial markets, banking, corporate finance, behavioral) | International Economics (F) | International Finance (F3) | Macro-structural (e.g., labor, law, climate change, inequality) | Macroeconomic Policy, Macroeconomic Aspects of Public Finance, and General Outlook (E6) | Macroeconomics and Monetary Economics (E) | Microeconomics (D) (e.g., general equilibrium, welfare, behavioral) | Monetary Policy, Central Banking (E5) | Other (e.g., urban, agriculture, personnel) | Prices, Business Fluctuations, and Cycles (E3) | Public Economics (H) (e.g., tax, expenditures, budget and debt) | Trade (F1)
MR A | 1 | Please select from the list | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y
MR B | 1 | Please select from the list | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y
MR C | 1 | Please select from the list | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y
MS A | 1 | Please select from the list | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y
MS B | 1 | Please select from the list | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y
MS C | 1 | Please select from the list | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y
MS D | 1 | Please select from the list | Y | Y | Y | Y | N | N | N | N | N | N | N | N | N
Spreadsheet: 692890d1598622679-indice-corresp-888
Sheet: Folha1

 |  |  | A | 100 |  |  | B
 |  |  | B | 87 |  |  | E
 |  |  | C | 45 |  |  | F
 |  |  | D | 35 |  |  | G
 |  |  | E | 22 |  |  | AA
 |  |  | F | 15
 |  |  | G | 17
 |  |  | H | 36
 |  |  | I | 38
 |  |  | J | 87
 |  |  | AA | 98
Spreadsheet: sara_shackleton__36638__EXPHALF
Sheet: Sheet1

NYMEX EXPIRATION DAY PROCESSING
OVERVIEW OF MEMBER REQUIREMENTS
 |  |  | REFERENCE
TIME | ACTIVITY | EVENT | NUMBER
15:30:00 | Exercise Notice Submission | Input C21 [NAME] | 1
 | Do Not Exercise Submission | Input C21 [NAME] | 2
15:45:00 | Announce Out-of-the Money Exercise and                    In-the-Money Do Not Exercise Submissions | Fast Facts Notice | 3
16:55:00 | Announce Final Input to C21 Cutoff Time | C21 E-Mail | 4
17:10:00 | [NAME] to C21 Cutoff Time |  | 5
5:10PM | All positions are deemed final | Fast Facts Notice | 6
18:30:00 | Announce Exercise/Assignment Information Available on the Single Position [NAME] | Fast Facts Notice and C21 E-Mail | 7
Spreadsheet: 680665d1591127712-need-a-formula-to-pull-data-from-another-sheets-chart-based-off-age-and-gender-2020-06-02-oeldere3-tbingham-680647d1591120212-need-a-formula-to-pull-data-from-another-sheet
Sheet: Female Pushup

Percent | 20 | 30 | 35 | 40 | 45 | 50 | 55 | 60
99 | 71 | 57 | 59 | 61 | 51 | 32 | 26 | 21
95 | 45 | 39 | 36 | 33 | 30 | 28 | 24 | 20
90 | 42 | 36 | 32 | 28 | 26 | 25 | 21 | 17
85 | 39 | 33 | 29 | 26 | 24 | 23 | 19 | 15
80 | 36 | 31 | 27 | 24 | 22 | 21 | 18 | 14
75 | 34 | 29 | 25 | 21 | 21 | 20 | 17 | 13
70 | 32 | 28 | 24 | 20 | 20 | 19 | 16 | 12
65 | 31 | 26 | 22 | 19 | 19 | 18 | 15 | 11
60 | 30 | 24 | 21 | 18 | 18 | 17 | 14 | 10
55 | 29 | 23 | 20 | 17 | 16 | 15 | 13 | 9
50 | 26 | 21 | 18 | 15 | 14 | 13 | 10 | 8
45 | 25 | 20 | 17 | 14 | 13 | 12 | 9 | 6
40 | 23 | 19 | 16 | 13 | 12 | 11 | 8 | 5
35 | 22 | 17 | 14 | 11 | 11 | 10 | 7 | 4
30 | 20 | 15 | 12 | 10 | 10 | 9 | 6 | 3
25 | 19 | 14 | 11 | 9 | 9 | 8 | 5 | 2
20 | 17 | 11 | 8 | 6 | 6 | 6 | 4 | 2
15 | 15 | 9 | 6 | 4 | 4 | 4 | 2 | 1
10 | 12 | 8 | 5 | 2 | 2 | 1 | 1 | 0
5 | 9 | 4 | 2 | 1 | 1 | 0 | 0 | 0
1 | 4 | 1 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 73442d1274113277-multi-sheet-formula-auto-populate-updated-week-4
Sheet: Week 1

 |  | THE HIT PARADE
 |  | Monday |  |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Sunday
 |  | 2010-04-19 00:00:00 |  |  | 2010-04-20 00:00:00 |  | 2010-04-21 00:00:00 |  | 2010-04-22 00:00:00 |  | 2010-04-23 00:00:00 |  | 2010-04-24 00:00:00 |  | 2010-04-25 00:00:00
 | Player | Hits | Points |  | Hits | Points | Hits | Points | Hits | Points | Hits | Points | Hits | Points | Hits | Points |  |  |  | TOTAL HITS
Cubie | [NAME] | 0 |  |  | 1 |  | 2 | 1 | 0 |  | 1 |  | 3 | 1 | 1 |  | 2 |  |  | 8 | 20
 | [NAME] | 0 |  |  | 1 |  | 0 |  | 1 |  | 0 |  | 2 |  | 0 |  |  |  |  | 4
 | [NAME] | 0 |  |  | 1 |  | 3 |  | 3 |  | 0 |  | 1 |  | 0 |  |  |  |  | 8
Dwayne | Chase Utley | 0 |  |  | 2 | 1 | 1 |  | 1 |  | 0 |  | 0 |  | 1 |  | 1 |  |  | 5 | 24
 | [NAME] | 0 |  |  | 2 |  | 1 |  | 3 |  | 2 |  | 0 |  | 0 |  |  |  |  | 8
 | [NAME] | 2 |  |  | 2 |  | 2 |  | 0 |  | 0 |  | 4 |  | 1 |  |  |  |  | 11
[NAME] | [NAME] | 0 |  |  | 2 |  | 1 |  | 1 | 1 | 0 |  | 2 | 1 | 1 |  | 2 |  |  | 7 | 19
 | [NAME] | 0 |  |  | 1 |  | 0 |  | 1 |  | 0 |  | 2 |  | 0 |  |  |  |  | 4
 | [NAME] | 0 |  |  | 1 |  | 3 |  | 3 |  | 0 |  | 1 |  | 0 |  |  |  |  | 8
[NAME] | [NAME] | 0 |  |  | 1 |  | 0 |  | 0 |  | 0 |  | 1 |  | 0 |  | 0 |  |  | 2 | 13
 | [NAME] | 0 |  |  | 3 |  | 2 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  |  | 5
 | [NAME] | 0 |  |  | 0 |  | 2 |  | 0 |  | 2 |  | 1 |  | 1 |  |  |  |  | 6
[NAME] | [NAME] | 0 |  |  | 4 | 1 | 1 | 1 | 1 |  | 2 |  | 0 |  | 1 | 1 | 3 |  |  | 9 | 28
 | Pablo Sandoval | 1 |  |  | 2 |  | 1 |  | 0 |  | 1 |  | 2 |  | 3 |  |  |  |  | 10
 | [NAME] | 0 |  |  | 0 |  | 3 |  | 1 |  | 1 |  | 2 |  | 2 |  |  |  |  | 9
Kent | [NAME] | 0 |  |  | 0 |  | 2 |  | 1 | 1 | 0 |  | 2 |  | 0 |  | 1 |  |  | 5 | 17
 | [NAME] | 0 |  |  | 1 |  | 1 |  | 1 |  | 0 |  | 1 |  | 0 |  |  |  |  | 4
 | [NAME] | 0 |  |  | 2 |  | 0 |  | 3 |  | 1 |  | 1 |  | 1 |  |  |  |  | 8
Nate | [NAME] | 0 |  |  | 1 | 1 | 0 |  | 1 |  | 0 |  | 2 |  | 0 |  | 1 |  |  | 4 | 14
 | [NAME] | 0 |  |  | 2 |  | 1 |  | 1 |  | 0 |  | 2 |  | 1 |  |  |  |  | 7
 | [NAME] | 0 |  |  | 2 |  | 0 |  | 0 |  | 1 |  | 0 |  | 0 |  |  |  |  | 3
[NAME] | [NAME] | 0 |  |  | 1 | 1 | 1 |  | 1 |  | 0 |  | 1 |  | 0 |  | 1 |  |  | 4 | 15
 | [NAME] | 0 |  |  | 2 |  | 0 |  | 3 |  | 1 |  | 1 |  | 1 |  |  |  |  | 8
 | [NAME] | 0 |  |  | 2 |  | 0 |  | 0 |  | 1 |  | 0 |  | 0 |  |  |  |  | 3
Scott | [NAME] | 0 |  |  | 1 |  | 0 |  | 1 | 1 | 0 |  | 2 |  | 0 |  | 1 |  |  | 4 | 17
 | Chase Utley | 0 |  |  | 2 |  | 1 |  | 1 |  | 0 |  | 0 |  | 1 |  |  |  |  | 5
 | [NAME] | 0 |  |  | 1 |  | 3 |  | 3 |  | 0 |  | 1 |  | 0 |  |  |  |  | 8
[NAME] | [NAME] | 11
Not Hitter | [NAME] | 2
Spreadsheet: 03c7529f-799d-4769-81c3-ad6e8efa421c
Sheet: Sheet1

Station Location | Address | # of Stations | Station Type | Price | Payment Method | Terms of Use
Block 19 ramp | 145 East 7th Street | 1 | Eaton - monthly | Monthly  contract | Contract arrangement with ramp -  [NAME] at [PHONE] or [EMAIL] | Monthly contract
[NAME] ramp | 10 W. 6th Street | 4 | Eaton - monthly | Monthly  contract | Contract arrangement with ramp - Jeff at [PHONE] or [EMAIL] | Monthly contract
Lowertown ramp | 317 Jackson Street | 2 | Eaton - monthly | Monthly  contract | Contract arrangement with ramp -  Vern at [PHONE], or  [NAME] at [EMAIL] | Monthly contract
World Trade Center ramp | 477 Cedar Street | 2 | Eaton - monthly | Monthly  contract | Contract arrangement with ramp - Allied Parking, Inc. at [PHONE] or [EMAIL] | Monthly contract
[NAME] | 1600 University Ave. W. | 2 | ChargePoint - hourly and Eaton - monthly | $1 / hour  or  monthly contract | Contact-less credit card;  ChargePass card, register at www.mychargepoint.net;  or call [PHONE]. Contract space - Jason at [PHONE] or [EMAIL] | First come, first serve or Monthly contract
1st National Bank Building | 332 Minnesota Street | 1 | ChargePoint - hourly | $3 / session (up to 4 hrs) | Contact-less credit card;  ChargePass card, register at www.mychargepoint.net;  or call [PHONE] | First come, first serve
RiverCentre ramp | 175 Kellogg Blvd. W. | 2 | ChargePoint - hourly | $3 / session (up to 4 hrs) | Contact-less credit card;  ChargePass card, register at www.mychargepoint.net;  or call [PHONE] | First come, first serve
Smith Avenue ramp | 145 Smith Avenue | 2 | ChargePoint - hourly | $3 / session (up to 4 hrs) | Contact-less credit card;  ChargePass card, register at www.mychargepoint.net;  or call [PHONE] | First come, first serve
Union Depot | Wacouta Street between 4th and Kellogg and in parking ramp | 4 | ChargePoint - hourly | $1 / hour + street parking fee | Contact-less credit card;  ChargePass card, register at www.mychargepoint.net;  or call [PHONE] | First come, first serve
Como Park - SOLAR | 1360 North Lexington Pkwy. | 2 | ChargePoint - hourly | $1 / hour | Contact-less credit card;  ChargePass card, register at www.mychargepoint.net;  or call [PHONE] | First come, first serve
[NAME] at Como - SOLAR | [NAME]. | 2 | ChargePoint - hourly | $1 / hour | Contact-less credit card;  ChargePass card, register at www.mychargepoint.net;  or call [PHONE] | First come, first serve
Sun [NAME] | 2105 Wilson Ave. | 2 | ChargePoint - hourly | $1 / hour | Contact-less credit card;  ChargePass card, register at www.mychargepoint.net;  or call [PHONE] | First come, first serve
Spreadsheet: 794337d1661988133-sumif-formula-with-or-function-example-sum-with-conditions-hd
Sheet: Sheet1

1 | [NAME] | Bonus
2 | [NAME] | Bonus
4 | [NAME]
8 | [NAME] |  | black
16 | [NAME] | Bonus | white
32 | [NAME] | Green | White
64 | [NAME] | Bonus | white
Sum  column A, If anywhere (in column B the name is "[NAME]" AND if in column C is "Bonus") OR if column D is blank
 | <<----
Spreadsheet: 128037d1320757419-excel-2007-drop-down-box-to-read-data-from-a-table-irradiance-calc
Sheet: Sheet1

Irradiance calc
TILT | 30°
ORIENTATION | SE/SW
SAP CALC | I WANT THE ANSWER FROM THE ABOVE TWO DROP BOXES TO GO HERE!... I.E HORIZONTAL ANS SOUTH WOULD LEAVE "933" IN THIS CELL
 | ORIENTATION
TILT | South | SE/SW | E/W | NE/NW | North
Horizontal | 933 | 933 | 933 | 933 | 933
30° | 1042 | 997 | 886 | 762 | 709
45° | 1023 | 968 | 829 | 666 | 621
60° | 960 | 900 | 753 | 580 | 485
Vertical | 724 | 684 | 565 | 427 | 360
i am aiming to achieve the result from the two drop down boxes picking the relevant information from the table below.  The table would ideally be placed on a seperate sheet but is not essential.
Spreadsheet: 328864d1404122312-sumifs-selecting-a-column-from-a-range-example-sheet
Sheet: Sheet 4

March 2014
Done By | Activity 3 | Activity 4 | Activity 8 | Activity 9 | Activity 10 | Total
AB | 93 | 0 | 0 | 0 | 0
BC | 0 | 0 | 1 | 0 | 0
GH | 28 | 2 | 15 | 1 | 7
IJ | 2 | 0 | 0 | 0 | 0
Totals for Activity
Spreadsheet: 486094d1477322028-variable-lookup-of-data-across-different-tabs-while-skipping-blanks-sample-box-numbering-for-multi-station-process-10-23-16
Sheet: Station E

Station E
Product | Quantity | Expiration Date | [NAME] | Box E2 | Box E3 | [NAME] | Box E5 | [NAME] | [NAME] | Box E8 | [NAME] | Box E10
SKU1 | 15 | 2017-10-10 00:00:00 |  | 4
SKU2 | 15 | 2017-10-20 00:00:00 | 2 |  | 4 |  | 1
SKU3 | 15 | 2017-10-30 00:00:00 |  | 4 | 1 | 3
[NAME] | 15 | 2017-11-10 00:00:00 | 6 |  | 1 |  | 6
[NAME] | 15 | 2017-11-20 00:00:00 |  |  |  | 4
Spreadsheet: daren_farmer__5508__105633
Sheet: 105633

Cost Center - 105633 Texas Trading Support |  |  |  |  |  |  |  | Avg. hours/month (assume 40 hour/week) | 168
POSITIONS | MGR | SSP | SPE | ANA | STA | SCL | CLK | TPC | TOTAL
# of FTE's
ACTIVITIES
RM002 - Routine Trading Monitoring and Reporting
ES001 - Adminstrative Support & Ad Hoc Requests
ES002 - Non Routine Trade Monitoring & Reporting
ES006 - Process Improvements
TOTAL
Check figure
Activity Definitions
RM002 - Routine Trading Monitoring and Reporting | * | daily intelligence gathering, including pipeline information, position worksheets, storage levels, and any other data deemed critical or
 |  | useful to traders/originators
 | * | monitoring day forward trades to ensure books are flat
 | * | monitoring trading activities (internal and external)
 | * | resolving issues that stem from trading (bridge monitoring)
 | * | Reporting for daily, monthly, year to date, etc. trading activities
ES001 - Administrative Support and Ad Hoc Requests | * | projects related to administrative work, ie data cleanup
 | * | preparing/generating reports
 | * | planning and budgeting
 | * | employee training, coaching, evaluation
 | * | HR related tasks; recruiting, PRC, new hires, mentoring, etc.
ES002 - Non Routine Commercial Support and Ad Hoc Requests | * | issue, resolution to traders' questions outside of daily operational issues
 | * | special projects
 | * | preparing/generating reports
ES006 - Technology Maintenance and  Process Improvements | * | system design, development, testing, implementation, and training
 | * | set up and testing of pipes to EDI, using GISB standards
 | * | identifying, coordinating, and implementing opportunities for improvements in our commodity processes
 | * | production or user support (ie Unify, Sitara, Enpower, TAGG, etc)
Spreadsheet: cara_semperger__1470__EPMI NOV
Sheet: HLH

contract |  | MW |  |  |  | $$ | start | end |  | path
10642 | EPMI | 50 | HLH |  |  |  | 2001-10-01 00:00:00 | 2006-09-30 00:00:00 |  | epmi bpa epmi(10123) | B/o
22576 | EPMI | 50 | HLH | long | Purch | 29.15 | 2001-10-01 00:00:00 | 2001-12-31 00:00:00 |  | epmi bpa epmi(23636) | B/o
23342 | EPMI | 25 | HLH | long | Purch | 36.95 | 2001-10-01 00:00:00 | 2001-12-31 00:00:00 |  | epmi bpa epmi(10123) | B/o
23397 | EPMI | 25 | HLH | long | Purch | 38 | 2001-10-01 00:00:00 | 2001-12-31 00:00:00 |  | epmi bpa epmi(10123) | B/o
23464 | EPMI | 25 | HLH | long | Purch | 47 | 2001-10-01 00:00:00 | 2001-12-31 00:00:00 |  | epmi bpa epmi(23939) | B/o
24442 | EPMI | 25 | HLH | long | Purch | 27.5 | 2001-11-01 00:00:00 | 2001-11-30 00:00:00 |  | epmi bpa [NAME]) | B/o
24481 | EPMI | 25 | HLH | long | Purch | 29.2 | 2001-11-01 00:00:00 | 2001-11-30 00:00:00 |  | epmi bpa epmi(24414) | B/o
24483 | EPMI | 25 | HLH | long | Purch | 30.4 | 2001-11-01 00:00:00 | 2001-11-30 00:00:00 |  | epmi bpa epmi(24425) | B/o
42022 | EPMI | 2 | HLH |  |  |  | 2001-11-01 00:00:00 | 2001-11-30 00:00:00 |  | epmi bpa epmi(10123) | B/o
42022 | EPMI | 16 | HLH | long | Purch | 47.5 | 2001-11-01 00:00:00 | 2001-11-30 00:00:00
x | EPMI | x | x | x | x | x | x | x | x | x
10123 | EPMI | -25 | HLH | short | Sale | 68 | 2001-10-01 00:00:00 | 2001-12-31 00:00:00 |  | epmi(23342) bpa epmi | B/o
10123 | EPMI | -25 | HLH |  | Sale |  | 2001-10-01 00:00:00 | 2001-12-31 00:00:00 |  | epmi(23397) bpa epmi | B/o
10123 | EPMI | -50 | HLH |  | Sale |  | 2001-10-01 00:00:00 | 2001-12-31 00:00:00 |  | epmi(10642) bpa epmi | B/o
10123 | EPMI | -2 | HLH |  | Sale |  | 2001-10-01 00:00:00 | 2001-12-31 00:00:00 |  | epmi(42022) bpa epmi | B/o
23636 | EPMI | -50 | HLH |  | Sale | 68 | 2001-10-01 00:00:00 | 2001-12-31 00:00:00 |  | epmi(22576) bpa epmi | B/o
23939 | EPMI | -25 | HLH | short | Sale | 222 | 2001-10-01 00:00:00 | 2001-12-31 00:00:00 |  | epmi(23464) bpe epmi | B/o
23953 | EPMI | -25 | HLH | short | Sale |  | 2001-10-01 00:00:00 | 2001-12-31 00:00:00 | exercised | epmi(24442) bpa epmi | B/o
24414 | EPMI | -25 | HLH | short | Sale | 38.25 | 2001-11-01 00:00:00 | 2001-11-30 00:00:00 |  | epmi(24481) bpa epmi | B/o
24425 | EPMI | -25 | HLH | short | Sale | 37.75 | 2001-11-01 00:00:00 | 2001-11-30 00:00:00 |  | epmi(24483) bpa epmi | B/o
24456 | EPMI | -25 | HLH | short | Sale | 27.5 | 2001-11-01 00:00:00 | 2001-11-30 00:00:00
24463 | EPMI | -25 | HLH | short | Sale | 28.25 | 2001-11-01 00:00:00 | 2001-11-30 00:00:00
24466 | EPMI | -25 | HLH | short | Sale | 28.25 | 2001-11-01 00:00:00 | 2001-11-30 00:00:00
24469 | EPMI | -25 | HLH | short | Sale | 28.25 | 2001-11-01 00:00:00 | 2001-11-30 00:00:00
24479 | EPMI | -25 | HLH | short | Sale | 28.7 | 2001-11-01 00:00:00 | 2001-11-30 00:00:00
24491 | EPMI | -25 | HLH | short | Sale | 30.4 | 2001-11-01 00:00:00 | 2001-11-30 00:00:00