tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 55569d1255685830-restructuring-data-example
Sheet: Sheet1

 | Origional
Line Number: |  |  | 1 | Y-Coordinate: |  |  | 50775 |  | Date: | 15/8/84
Station Number |  | Benthic Profile Data |  |  |  | Time/Dept: Data
 |  | X-Coordinate | Y-Coordinate | Corrected  Depth _m |  | Time | Echo Sound Depth _m
1 |  | 10494 | 52004 | 33.6 |  | 14:18:00 | 7.5
1a |  | 10385 | 52001 | 30.6 |  | 14:20:00 | 9
2 |  | 10300 | 51999 | 30.6 |  | 14:22:00 | 10.9
2a |  | 10213 | 52000 | 33.6 |  | 14:24:00 | 13.3
Line Number: |  |  | 2 | Y-Coordinate: |  |  | 50250 |  | Date: | 16/8/84
Station Number |  | Benthic Profile Data |  |  |  | Time/Dept: Data
 |  | X-Coordinate | Y-Coordinate | Corrected  Depth _m |  | Time | Echo Sound Depth _m
3 |  | 14858 | 50256 | 33.1 |  | 09:52:00 | 33.5
4 |  | 14540 | 50244 | 33.6 |  | 09:54:00 | 34
5 |  | 14220 | 50247 | 33.8 |  | 09:56:00 | 34.2
6 |  | 14046 | 50248 | 30.6 |  | 09:57:00 | 31
7 |  | 13906 | 50249 | 33.4 |  | 09:58:00 | 33.8
 | result
Line Number: | Date: | Station Number | X-Coordinate | Y-Coordinate | Corrected  Depth _m | Time | Echo Sound Depth _m
1 | 15/8/84 | 1 | 10494 | 52004 | 33.6 | 14:18:00 | 7.5
1 | 15/8/84 | 1a | 10385 | 52001 | 30.6 | 14:20:00 | 9
1 | 15/8/84 | 2 | 10300 | 51999 | 30.6 | 14:22:00 | 10.9
1 | 15/8/84 | 2a | 10213 | 52000 | 33.6 | 14:24:00 | 13.3
2 | 16/8/84 | 3 | 14858 | 50256 | 33.1 | 33.1 | 33.5
2 | 16/8/84 | 4 | 14540 | 50244 | 33.6 | 33.6 | 34
2 | 16/8/84 | 5 | 14220 | 50247 | 33.8 | 33.8 | 34.2
2 | 16/8/84 | 6 | 14046 | 50248 | 30.6 | 30.6 | 31
2 | 16/8/84 | 7 | 13906 | 50249 | 33.4 | 33.4 | 33.8
Spreadsheet: eric_saibi__9846__100801
Sheet: Onondaga 03

Owner Name | Aquila Energy Corporation
Station Name | [NAME]
Unit Name | Unit 03 CT/HRSG
NERC Region | NPCC
State | NY
Fuel Type | Natural Gas
Capacity | 27 MW
Start Date | 2001-09-21 00:00:00
End Date | 2001-10-18 00:00:00
Prv. Start Date | 2001-09-21 00:00:00
Prv. End Date | 2001-10-04 00:00:00
Comments | Comb Insp. / Maintenance
SIC | 4931
Plant ID | 1013844
Unit ID | 1011792
Outage ID | 18431
Spreadsheet: 35119d1232636449-conditional-summing-example-conditional-sums
Sheet: Sheet1

 |  |  |  | I am trying to sum values in column C, if:
 |  |  |  |  | Column A is unique
 |  |  |  |  | Column B = Factor1  (or [NAME], or [NAME]…)
Org01 | factor1 | 25 |  |  | In most cases, the number in column C will be the same for the corresponding "Org" variable. However, there are cases where it differs.
Org01 | [NAME] | 25 |  |  | In these cases I would like to be able to take the min (or the [NAME]) number.
Org01 | [NAME] | 25
Org01 | [NAME] | 24 |  |  | so, sum for "factor1" would be the sum of those in yellow
Org01 | factor4 | 25 |  |  | the sum for "[NAME]" would be those in green (if I were to go with the [NAME]).
Org01 | factor5 | 25
Org01 | factor6 | 25 |  |  | this data may not be in any particular order.
Org02 | factor1 | 30
Org02 | [NAME] | 30 |  |  | the "Factor" variable may occur several times for various org's...
Org02 | [NAME] | 30
Org02 | factor4 | 30
Org03 | factor1 | 25
Org03 | [NAME] | 25
Org03 | [NAME] | 25
Org03 | [NAME] | 25
Org03 | factor5 | 25
Org03 | factor6 | 25
Org03 | factor7 | 25
Org03 | factor8 | 25
Spreadsheet: 190171d1351544175-match-and-append-subsets-of-records-from-one-file-to-another-workbookb
Sheet: Sheet1

JHHNO | GFR | A1C | VL | CD4
333333 | 60 | 1 | 50 | 400
666666 | 57 | 2 | 1000 | 100
777777 | 60 | 4 | 600 | 250
999999 | 18 | 1 | 100000 | 90
Spreadsheet: 842953d1694944459-keyword-search-for-faqs-spreadsheet-faqs
Sheet: Where is

Where Is - 1 | Location 1
Where Is - 2 | Location 2
Where Is - 3 | Location 3
Where Is - 4 | Location 4
Where Is - 5 | Location 5
Where Is - 6 | Location 6
Where Is - 7 | Location 7
Where Is - 8 | Location 8
Where Is - 9 | Location 9
Where Is - 10 | Location 10
Spreadsheet: 723736d1615864792-i-need-to-count-how-many-times-a-row-had-the-smallest-number-in-a-column-simulation
Sheet: Sheet1

1 |  |  |  |  |  |  |  |  |  |  | COUNT
281.9379740008922 | 286.3740970178127 | 270.2016041696325 | 272.562956266149 | 286.6720755834954 | 276.4338232184189 | 285.7166006213964 | 280.9452892889164 | 288.3251804949542 | 288.1765408579387
269.8679605074503 | 273.6523372610488 | 276.1606969234811 | 273.7304122227851 | 273.9582172700437 | 281.6866412462632 | 274.2560451378088 | 287.6393419694863 | 267.5983065686945 | 274.6369638156929
274.8978592668829 | 285.9445930981041 | 279.1412831846036 | 285.5421353083178 | 282.9734193120921 | 281.0231942060675 | 285.7890257935751 | 270.3181499796656 | 274.696769307147 | 282.749740408897
284.1111157392103 | 290.558737077475 | 290.8885559489358 | 286.3531522448479 | 281.7843398637414 | 275.5099639316256 | 273.0844067510808 | 275.087007070269 | 278.9423935149592 | 275.2594944821709
270.7227749516311 | 288.3307906114226 | 278.9773358458254 | 272.8404133393934 | 275.61123920388 | 286.5313397802283 | 277.2052703217034 | 285.8417867187685 | 281.5024000856152 | 284.4918903893135
285.3587260538276 | 281.1713431181497 | 281.2531468326468 | 296.8906471288579 | 278.1412853020898 | 288.5255921904445 | 274.4295693089445 | 287.6342014869373 | 286.5140334450456 | 286.4808153122104
Spreadsheet: 599357d1542988193-distribute-values-between-two-different-dates-copy-of-loan-calculation-work-sheet-version01-
Sheet: Daily Coll.Cust.Wise Sum.

Collection Updates (Customer Wise) |  |  |  |  |  | Customer Name | [NAME]
 | Branch Information -► |  |  |  |  | Customer Information -► |  |  |  |  | Loan Information -►
Date | Loan Code | Branch Name | Branch Code | Officer Name | Officer Code | Customer Name | NIC Number | Nearest Town | Contact No | Distance to Center(Km) | Date of Loan | Loan Amount (Rs.) | Payment Method | Period (Days) | Effective Interest Rate | Total Interest | Total with Interest | Number of Installments | Loan Instalment | Paid Today
Total
Spreadsheet: 119790d1314741445-variable-averageif-book1
Sheet: Sheet3

 | Monday |  | January
 | Tuesday |  | February
 | Wednesday |  | March
 | Thursday |  | April
 | Friday |  | May
 | Saturday |  | June
 | Sunday |  | July
 |  |  | August
 | Weekday |  | September
 | Weekend |  | October
 |  |  | November
 |  |  | December
 |  |  | All Time
Spreadsheet: 846991d1698107306-formula-for-date-example
Sheet: Sheet1

2023-10-24 06:02:00
24/10/23 06:02 AM
24/10/23 06:02 AM
24/10/23 06:01 AM
23/10/23 03:40 PM
23/10/23 03:39 PM
23/10/23 03:38 PM
23/10/23 03:36 PM
23/10/23 03:35 PM
23/10/23 03:35 PM
19/10/23 11:16 AM
18/10/23 02:55 PM
04/10/23 09:58 AM
04/10/23 09:58 AM
04/10/23 09:48 AM
04/10/23 09:48 AM
04/10/23 09:48 AM
04/10/23 09:47 AM
04/10/23 09:47 AM
04/10/23 09:46 AM
04/10/23 09:46 AM
04/10/23 09:39 AM
04/10/23 09:39 AM
14/09/23 02:29 PM
06/09/23 12:53 PM
06/09/23 12:53 PM
06/09/23 12:52 PM
06/09/23 12:52 PM
06/09/23 12:49 PM
06/09/23 12:49 PM
06/09/23 12:48 PM
04/09/23 01:24 PM
16/08/23 10:28 AM
16/08/23 10:27 AM
09/08/23 10:36 AM
03/08/23 07:42 AM
Spreadsheet: 86938d1286892669-automating-filtered-totals-748971
Sheet: Sheet1

Url | Visible | Internal | Level1 | Level2 | Level3 | Level4
/programme/pm/aaa/iweriw | 56 | 78 | /programme/ | /programme/pm/ | /programme/pm/aaa/ | #N/A
/programme/pm/aaa/sredrf/images | 435 | 787 | /programme/ | /programme/pm/ | /programme/pm/aaa/ | /programme/pm/aaa/sredrf/
/new/oddbin | 23 | 87 | /new/ | #N/A | #N/A | #N/A
/new/bin/new/normal | 235 | 666 | /new/ | /new/bin/ | /new/bin/new/ | #N/A
/new/bin/new/odd | 35 | 46 | /new/ | /new/bin/ | /new/bin/new/ | #N/A
/helo/mouse/1/2 | 32 | 56 | /helo/ | [NAME]/mouse/ | /helo/mouse/1/ | #N/A
/programme/pm/new/ | 55 | 334 | /programme/ | /programme/pm/ | /programme/pm/new/ | #N/A
Spreadsheet: louise_kitchen__22552__Hot List Update 07-11-01
Sheet: E-Commerce -50

Deal Description Sheet - 7/9/01
[NAME]
Project Name | Lead Originator | Counterparty | Description | Potential Valuation | Last Customer Contact | Probability | Expected Closing (Month/Year) | Weekly Updates / Comments
Andex | [NAME] | Andex | Outsourcing- scheduling, balancing, settlement, deal confirmations and measurement & accounting. | 50000 | 2001-05-22 00:00:00 | 0.2 | 2001-07-01 00:00:00 | Andex has elected to pursue other options for their production management.
[NAME] | [NAME] | EOTT | Back office accounting services. | *$500,000 | 2001-05-14 00:00:00 | 0.25 | 2001-10-01 00:00:00 | EOTT met HMS in mid-June.  ENA has reviewed ATS proposal.  ENA will work with ATS to re-submit a more competitive proposal.
[NAME] | [NAME] | Pure Resources | Integrated outsourcing products. | *$250,000 | 2001-06-11 00:00:00 | 0.25 | 2001-12-01 00:00:00 | Met with Pure senior management on 6/29.  Pure executive meeting on 7/2.  Feedback expected by 7/6.
Gather Company | ?? | Gather Company | Monetization and metering services. | 200000 | 2001-05-10 00:00:00 | 0.25 | 2001-12-01 00:00:00 | Follow up meeting in July, 2001.
Running Man | [NAME] | Marathon | Integrated outsourcing products. | *$1,000,000 | 2001-06-11 00:00:00 | 0.1 | 2001-12-01 00:00:00 | Meeting in July.
Callon | [NAME] | Callon | Outsourcing | 100000 | 2001-06-19 00:00:00 | 0.1 | 2001-10-01 00:00:00 | Setting up meeting with COO in July.  Callon already uses ATS software.
 |  |  |  |  |  |  |  | *Accrual
Spreadsheet: 202552d1356626529-if-22-unit-price-is-1620-then-100-unit-is-equal-to-price-book1
Sheet: Sheet1

PRODUCT | DP | QUANTITY | TOTAL DP | PV | TOTAL PV
RISHI MASHROOM POWDER 22GM | 1620 | 1 |  | 22
RISHI MASHROOM POWDER 70GM | 5000 |  |  | 70
CODYCEPS TABLET | 5200 |  |  | 60
LIONS MANE CANDY | 2150 |  |  | 26
SPIRULINA 120 TAB | 1500 | 1 |  | 20
SPIRULINA 150 TAB | 5250 |  |  | 70
POTENZHI | 2250 |  |  | 21
MONASCOS CAPSULE | 1250 |  |  | 12
COCOZEE | 1550 |  |  | 13
LINGZHI BLACK COFEE | 1120 | 1 |  | 10
LINGZHI CORDYCEPS COFEE | 1600 | 1 |  | 14
LINGZHI 3IN1 COFEE | 1120 | 0 |  | 10
MORINZHI | 1140 | 1 |  | 17
MORINZYEME | 1140 |  |  | 17
MASSAGE OIL [NAME] | 740 | 1 |  | 9
SHAMPOO GANOZHI | 820 |  |  | 11
SOAP GANOZHI | 650 |  |  | 7
TOOTHPASTE GANOZHI | 520 |  |  | 6
TEA TREE CREAM | 580 |  |  | 6
DXN ALEO V AQUA GEL | 1520 |  |  | 14
DXN ALEO V CLEASINING GEL | 780 |  |  | 7
DXN ALEO V HAND&BODY LOTION | 780 |  |  | 7
DXN ALEO V HYDRATING TONER | 780 |  |  | 7
DXN ALEO V NUTRICARE CREAM | 1070 |  |  | 10
TOTAL |  |  |  | PV
 |  | PIECE | RUPEES
Spreadsheet: 6c06e4a0-3e6d-4b4e-9032-58d5a5a8d269
Sheet: Sheet1

athletes_idAthletes | Rk | Nation | Date of Birth | ID Number | Last Name | First Name | Total Pts | Fenc | Swim | Ride | Comb | Swim time
38349 | 1 | CUB | 16/04/92 | W038349 | MOYA | [NAME] | 4100 | 840 | 1096 | 0 | 2164 | 2:22.25
37943 | 2 | HUN | 09/06/93 | W037943 | FOLDHAZI | [NAME] | 4076 | 1000 | 1252 | 0 | 1824 | 2:09.30
39604 | 3 | UKR | 06/08/93 | W039604 | SPAS | Anastasiya | 4064 | 1000 | 1116 | 0 | 1948 | 2:20.62
39127 | 4 | USA | 22/11/93 | W039127 | OLESINSKI | Anna | 3984 | 920 | 1028 | 0 | 2036 | 2:27.69
39219 | 5 | POL | 04/07/93 | W039219 | MALISZEWSKA | Anna | 3952 | 960 | 1052 | 0 | 1940 | 2:25.95
39231 | 6 | LTU | 04/11/92 | W039231 | VENCKAUSKAITE | Gintare | 3920 | 680 | 1048 | 0 | 2192 | 2:26.12
39517 | 7 | CHN | 18/04/93 | [NAME] | ZHU | Wenjing | 3856 | 840 | 1044 | 0 | 1972 | 2:26.54
39575 | 8 | KOR | 15/01/93 | W039575 | CHOI | Min Ji | 3808 | 960 | 1192 | 0 | 1656 | 2:14.01
38145 | 9 | RUS | 14/02/92 | W038145 | GUBAYDULLINA | [NAME] | 3796 | 680 | 1208 | 0 | 1908 | 2:12.87
39422 | 10 | MEX | 15/03/93 | W039422 | VEGA | Tamara | 3796 | 760 | 1072 | 0 | 1964 | 2:24.07
35892 | 11 | ITA | 17/11/93 | W035892 | TOCCHI | Gloria | 3772 | 960 | 1044 | 0 | 1768 | 2:26.64
5421 | 12 | EGY | 04/05/92 | W005421 | EL MIDANY | [NAME] | 3704 | 720 | 1072 | 0 | 1912 | 2:24.01
39209 | 13 | BLR | 03/09/93 | W039209 | MASEIKAVA | Marharyta | 3612 | 640 | 1100 | 0 | 1872 | 2:21.80
38939 | 14 | ESP | 11/02/93 | W038939 | CHAVARRIA | Nuria | 3592 | 1040 | 940 | 0 | 1612 | 2:35.11
37982 | 15 | FRA | 02/12/92 | W037982 | CARPENTIER | Manon | 3580 | 720 | 1068 | 0 | 1792 | 2:24.54
38154 | 16 | CZE | 14/04/93 | W038154 | LENCOVA | [NAME] | 3520 | 1040 | 1016 | 0 | 1464 | 2:28.99
37397 | 17 | GER | 20/01/93 | W037397 | HANKO | Franziska | 3520 | 720 | 992 | 0 | 1808 | 2:30.85
39750 | 18 | SIN | 21/06/93 | W039750 | LIM | [NAME] | 3408 | 560 | 1048 | 0 | 1800 | 2:26.23
38050 | 19 | KAZ | 13/11/92 | W038050 | ILYASOVA | Dilyara | 3396 | 880 | 772 | 0 | 1744 | 2:49.10
39649 | 20 | LAT | 29/08/93 | W039649 | ROGA | Sindija | 3376 | 720 | 1028 | 0 | 1628 | 2:27.96
38086 | 21 | IRL | 20/02/93 | W038086 | [NAME] | Emily | 3356 | 680 | 1096 | 0 | 1580 | 2:22.10
37912 | 22 | BUL | 15/09/93 | W037912 | GENCHEVA | Beatrice | 3336 | 800 | 1080 | 0 | 1456 | 2:23.53
39165 | 23 | SVK | 17/02/93 | W039165 | Ela | SEDILEKOVA | 3300 | 640 | 1004 | 0 | 1656 | 2:29.70
39739 | 24 | BRA | 30/04/92 | W039739 | LAPORTE | [NAME] | 3164 | 720 | 1056 | 0 | 1388 | 2:25.60
Spreadsheet: phillip_allen__29523__Jan00Expense
Sheet: Utilities

Electric | Dec.,1999 | Jan.,2000 | [NAME] | [NAME]
Apt #1-4 | 144.52 | 237.76 | 93.24
Apt #5-8 | 269.18 | 416.38 | 147.2
Apt #9-12 | 122.35 | 224.18 | 101.83
Apt #13 | 58.63 | 125.46 | 66.83 | 25
Apt #14 | 58.95 | 75.11 | 16.16 | 15
Apt #15 | 47.7 | 40.64 | -7.06
Apt #16 | 51.39 | 70.05 | 18.66 | 10
Apt #17 | 48.03 | 80.22 | 32.19 | 20
Apt #18 | 53.47 | 106.38 | 52.91 | 46
Apt #19 | 77.67 | 118.29 | 40.62
Apt #20 | 41.34 | 74.83 | 33.49
Apt #21 | 55.64 | 121.28 | 65.64 | 41
Apt #22 | 63.41 | 104.64 | 41.23 | 25
Apt #23 | 30.63 | 67.27 | 36.64
Apt #24 | 64.23 | 100.94 | 36.71
Apt #25 | 43.52 | 65.64 | 22.12
Apt #26 | 76.3 | 81.85 | 5.55
Apt #27 | 44.65 | 66.79 | 22.14
Apt #28 | 52.38 | 80.87 | 28.49
Apt #29 | 71.95 | 95.23 | 23.28
Apt #30 | 66.25 | 116.38 | 50.13 | 36
Apt #31 | 40.69 | 57.11 | 16.42
Apt #32 | 60.64 | 102.78 | 42.14 | 23
Apt #33 | 38.67 | 56.29 | 17.62
Apt #34 | 55.15 | 85.12 | 29.97
Apt #35 | 63.37 | 127.48 | 64.11 | 27
Apt #36 | 45.04 | 73.31 | 28.27
Apt #37 | 50.31 | 92.46 | 42.15
Apt #38 | 19.48 | 24.86 | 5.38
Apt #39 | 48.4 | 110.08 | 61.68 | 30
Apt #40 | 53.57 | 71.79 | 18.22
Apt #41 | 19.04 | 35.31 | 16.27
Apt #42 | 34.6 | 38.08 | 3.48
Apt #43 | 30.95 | 34.27 | 3.32
Apt #44 | 46.45 | 68.85 | 22.4
HSMTR | 26.66 | 29.88 | 3.22
Total |  |  |  | 298
Water
Apts Seventh | 142.55 | 194.8 | 52.25
Apt #5-8 | 669.55 | 564.25 | -105.3
Apt #30-39 | 175.8 | 223.3 | 47.5
Wtr | 127.34 | 141.59 | 14.25
Apt#41-43 | 66.55 | 95.05 | 28.5
Apt#44 | 51.34 | 51.34 | 0
Total
Gas
Apt#41 | 15.92 | 30.96 | 15.04
Apt #42 | 30.25 | 34.55 | 4.3
Apt #43 | 43.93 | 45.13 | 1.2
Apt #44 | 29.17 | 44.23 | 15.06
L.R. | 26.38 | 29.25 | 2.87
Total
Spreadsheet: 218359d1362434713-combine-multiple-rows-into-one-comma-separated-column-compantexample
Sheet: ori1

CustomerID | Name | UserID | IsActive | FirstName | LastName | Full Name
10000001 | Company Name 1 | 99911 | True | [NAME] | Smith | [NAME]
10000002 | Company Name 2 | 99912 | False | [NAME] | Smith | [NAME]
10000003 | Company Name 3 | 99913 | True | Emily | Smith | [NAME]
10000004 | Company Name 4 | 99914 | True | [NAME] | Smith | [NAME], [NAME]
10000004 | Company Name 4 | 99915 | True | Robyn | Smith
Spreadsheet: 696833d1600999521-taking-a-list-of-data-and-transforming-it-adding-a-drop-down-to-make-it-searchable-excel-help-forum
Sheet: Sheet1

Attribute | Wednesday |  |  |  |  |  | Date
[NAME] | 2.3 |  |  |  |  |  | 2020-09-23 00:00:00
Average Handle Time Actual | 0.01038194444444444
Average Speed of Answer | 0.0004629629629629629
Calls Offered Actual | 427
Forecast Accuracy | 95.6
Forecast Average Handle Time | 0.009317129629629628
Forecast Calls Offered | 408
Handle Time Accuracy | 89.8
Service Level % Actual | 77
Spreadsheet: 98403d1297311738-setting-expiry-date-with-conditional-formatting-records-for-data-input
Sheet: ELECTRICIAN

ELECTRICIANS
 | FIRST AID | BLUE CARD | PTR | EDD | SUB ENTRY | A GRADE NO | [NAME] | POLE INSP | METREL 6 months | CUST OH | HIGH RISK | INDUCT | PESTICIDE | NETWORK ACCESS AUTH | WP REMARKS
ANTHONY MEYER | 2012-01-24 00:00:00 | 226635 | 2012-01-24 00:00:00 | 2012-01-24 00:00:00 | 2011-07-07 00:00:00 | EW156712 29/12/2013 | [NAME] | 2010-10-10 00:00:00 | 23/12/2010 C9-10/02/11 | 31/12/2010 | 2013-09-30 00:00:00 | 2008-04-23 00:00:00 |  | APPLIED | Applied
DANIEL GODDARD | 2012-01-17 00:00:00 | 152661 | 2012-01-17 00:00:00 | 2012-01-17 00:00:00 | 2011-07-07 00:00:00 | EW157120 | 20/02/2013 | NO | 31/03/2011 Applied (1) | 31/12/2010 | 2013-01-16 00:00:00 | NO |  | YES
Spreadsheet: b5df2f18-920b-4cdb-90f6-fcb726c35ea6
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
43960638 | 2014-11-10 13:09:48 | ALLIES | 1 | 6 | 3 | 417473 | aikobo | 12506 | eastern | 1941-07-21 | 1941-07-31 | [NAME] | Percée russe
43994687 | 2014-11-12 20:31:50 | AXIS | 1 | 6 | 4 | 601280 | player601280 | 7669 | pacific | 1941-12-23 | 1941-12-23 | Wake Island | Ile de Wake
43994836 | 2014-11-12 20:49:23 | ALLIES | 0 | 5 | 6 | 601280 | player601280 | 7669 | pacific | 1941-12-23 | 1941-12-23 | Wake Island | Ile de Wake
44063005 | 2014-11-17 12:01:22 | AXIS | 1 | 5 | 3 | 1665571 | Prisss | 6148 | western | 1944-07-25 | 1944-07-26 | Operation Cobra | Opération Cobra
44063138 | 2014-11-17 12:14:59 | ALLIES | 1 | 5 | 0 | 1665571 | Prisss | 6148 | western | 1944-07-25 | 1944-07-26 | Operation Cobra | Opération Cobra
44096019 | 2014-11-19 20:45:20 | ALLIES | 1 | 6 | 2 | 946197 | Groka | 6155 | western | 1944-09-19 | 1944-09-19 | Arracourt | Arracourt
44096305 | 2014-11-19 21:17:08 | ALLIES | 1 | 6 | 4 | 434350 | [NAME] | 12498 | western | 1944-07-11 |  | [Normandy] Bretel Wood | [NAME]
44096681 | 2014-11-19 21:36:53 | AXIS | 0 | 5 | 6 | 434350 | [NAME] | 12498 | western | 1944-07-11 |  | [Normandy] Bretel Wood | [NAME]
44104130 | 2014-11-20 12:01:23 | ALLIES | 0 | 5 | 10 | 1671508 | [NAME] | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
Spreadsheet: 1072e6c4-b534-4c6f-8705-cd3de863c36d
Sheet: Sheet1

Unnamed: 0 | State of New Hampshire - Primary Election | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
2012-09-11 00:00:00 | Governor - Democratic
Cheshire County | [NAME], d | [NAME], d | [NAME], d | Ovide Lamontagne, r | [NAME], r | [NAME], r | [NAME]
Alstead | 119 | 55 | 12 |  | 1
Chesterfield | 149 | 106 | 17 |  |  |  | 1
Dublin | 100 | 103 | 7
[NAME] | 86 | 80 | 24 |  | 1
Gilsum | 27 | 23 | 4
Harrisville | 165 | 58 | 6 |  | 1
Hinsdale | 75 | 83 | 24
[NAME] | 197 | 155 | 18 | 4 | 1
[NAME] | 104 | 54 | 10 | 2
[NAME] | 281 | 141 | 18 |  |  |  | 1
[NAME] 3 | 218 | 141 | 19 | 1 | 1
[NAME] | 270 | 129 | 19 |  |  |  | 2
[NAME] | 307 | 142 | 25
Marlborough | 141 | 71 | 20 | 1
Marlow | 43 | 23 | 7
[NAME] | 78 | 30 | 1
Richmond | 79 | 27 | 3
Rindge | 99 | 115 | 18 | 2 | 1 | 2
Roxbury | 13 | 13 | 5
Stoddard | 60 | 42 | 3
[NAME] | 37 | 28 | 3
[NAME] | 48 | 39 | 1 | 1
Swanzey | 225 | 162 | 34 | 1 |  |  | 1
Troy | 47 | 53 | 12
Walpole | 194 | 152 | 31 | 1
Westmoreland | 124 | 71 | 8
Winchester | 131 | 72 | 22 |  | 3
TOTALS | 3417 | 2168 | 371 | 13 | 9 | 2 | 5
Spreadsheet: 148295d1333333845-need-correct-formula-to-multiply-numbers-and-keep-accurate-when-using-decimal-places-excel-estimate-form
Sheet: Orig Est 3-31-12

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Internal Estimates
 | Work to be Completed |  |  |  |  |  |  |  |  | Quantity | Unit | Unit Cost | Base Cost |  | Original       Estimated Cost | Factor | Total                   Estimated Cost | Potential Profit
 | Scope:
 | Build ….. |  |  |  |  |  |  |  |  | 1369 | Per SF Bid |  |  |  | 0.12 | 0.38
 | Supply …… |  |  |  |  |  |  |  |  | 10 | Per [NAME] |  |  |  | 185 | 0.251
 | Build ….. |  |  |  |  |  |  |  |  | 20 | Per SF Bid |  |  |  | 0.12 | 0.38
 | Supply …… |  |  |  |  |  |  |  |  | 3 | Per [NAME] |  |  |  | 25 | 0.251
 |  | Notes / Questions:
 |  | In the unit cost column, some items need to disply with two decimals and others with no decimals.
 |  | These are often changing back and forth depending on the item being sold or built
 |  | I need a function that will make sure the math stays accurate in the base cost column regardless of 2 decimals or zero decimals
 |  | Is it possible to use an "IF" function that decides what rounding to use based on the number of decimal places present?
Spreadsheet: 710281d1608820050-need-help-removing-value-from-cells-when-using-a-formula-value-error
Sheet: Sheet1

8 | 5.5 | 1.7 | 8 | 32.6
3 | 5.5 | 1.9 | 9 | 26.5
4 | 1.4 | 1.14 | 9 | 29.6
5 | 34 | 8 | 9 | 32.7
6 | 7.5 | 2.3 | 9 | 33.2
7 | 19 | 4.6 | 9 | 30.1
8 | 11 | 3.1 | 9 | 31.9
1 | 3.2 | 1.8 | 2
Spreadsheet: 0a805602-a27a-4620-9383-c5440c47562a
Sheet: 13c

 | Swap Dealers/MSPs5 |  | Others
Product1 | Cleared2 | Uncleared | Cleared | Uncleared
Index Tranche
Europe | - | 780389 | - | 123859
North America/Asia | - | 881662 | - | 102031
Index
Asia | - | 170716 | - | 37957
Europe | 1531631 | 3438412 | 371952 | 884837
North America | 1941953 | 3107881 | 455208 | 1161153
Other | 20801 | 375484 | 4552 | 52989
Other | -
Exotic/Total Return Swap | - | 60791 | - | 34350
Swaptions | - | 732909 | - | 337563
TOTAL
Spreadsheet: 81944d1282052952-set-up-ongoing-copying-from-one-sheet-to-another-sheet-in-same-workbook-example-1111111111-
Sheet: Sheet1

Date | Amount
2010-08-23 00:00:00 | USD
2010-08-23 00:00:00 | USD
2010-08-23 00:00:00 | USD
2010-08-23 00:00:00 | USD
2010-08-23 00:00:00 | USD
2010-08-23 00:00:00 | USD
2010-08-17 00:00:00 | USD
2010-08-23 00:00:00 | USD
2010-08-23 00:00:00 | USD
2010-08-23 00:00:00 | USD
2010-08-23 00:00:00 | USD
2010-08-17 00:00:00 | USD
2010-08-23 00:00:00 | USD
2010-08-23 00:00:00 | USD
2010-08-23 00:00:00 | USD
2010-08-23 00:00:00 | USD
2010-08-17 00:00:00 | USD
2010-08-23 00:00:00 | USD
2010-08-23 00:00:00 | USD
2010-08-17 00:00:00 | AUD
2010-08-17 00:00:00 | AUD
2010-08-31 00:00:00 | AUD
2010-08-26 00:00:00 | AUD
2010-08-18 00:00:00 | AUD
2010-08-18 00:00:00 | AUD
2010-08-17 00:00:00 | AUD
2010-08-17 00:00:00 | AUD
2010-08-17 00:00:00 | AUD
2010-08-17 00:00:00 | AUD
2010-08-30 00:00:00 | AUD
2010-08-31 00:00:00 | AUD
2010-08-26 00:00:00 | AUD
2010-08-18 00:00:00 | AUD
2010-08-18 00:00:00 | AUD
2010-08-17 00:00:00 | AUD
2010-08-17 00:00:00 | AUD
2010-08-19 00:00:00 | CAD
2010-08-19 00:00:00 | CAD
2010-08-19 00:00:00 | CAD
2010-08-19 00:00:00 | CAD
2010-08-19 00:00:00 | CAD
2010-08-19 00:00:00 | CAD
2010-08-19 00:00:00 | CAD
2010-08-19 00:00:00 | CAD
2010-08-19 00:00:00 | USD
2010-08-19 00:00:00 | USD
2010-08-19 00:00:00 | USD
2010-08-19 00:00:00 | USD
2010-08-19 00:00:00 | USD
2010-08-19 00:00:00 | CAD
2010-08-19 00:00:00 | CAD
2010-08-19 00:00:00 | CAD
2010-08-19 00:00:00 | CAD
2010-08-19 00:00:00 | CAD
2010-08-19 00:00:00 | CAD
2010-08-27 00:00:00 | GBP
2010-08-27 00:00:00 | GBP
2010-08-27 00:00:00 | USD
2010-08-23 00:00:00 | USD
2010-08-23 00:00:00 | USD
2010-08-19 00:00:00 | USD
2010-08-19 00:00:00 | USD
2010-08-23 00:00:00 | USD
2010-08-23 00:00:00 | USD
2010-08-23 00:00:00 | USD
2010-08-23 00:00:00 | USD
2010-08-19 00:00:00 | USD
2010-08-19 00:00:00 | USD
2010-08-23 00:00:00 | USD
2010-08-23 00:00:00 | USD
2010-08-23 00:00:00 | USD
2010-08-23 00:00:00 | USD
2010-08-19 00:00:00 | USD
2010-08-19 00:00:00 | USD
2010-08-23 00:00:00 | USD
2010-08-23 00:00:00 | USD
2010-08-17 00:00:00 | GBP
2010-08-17 00:00:00 | GBP
2010-08-17 00:00:00 | GBP
2010-08-17 00:00:00 | GBP
2010-08-17 00:00:00 | GBP
2010-08-25 00:00:00 | GBP
2010-08-25 00:00:00 | GBP
2010-08-17 00:00:00 | GBP
2010-08-17 00:00:00 | GBP
2010-08-17 00:00:00 | GBP
2010-08-17 00:00:00 | GBP
2010-08-19 00:00:00 | GBP
2010-08-19 00:00:00 | GBP
2010-08-27 00:00:00 | GBP
2010-08-19 00:00:00 | GBP
2010-08-27 00:00:00 | GBP
2010-08-19 00:00:00 | GBP
2010-08-19 00:00:00 | GBP
2010-08-31 00:00:00 | ZAR
2010-08-31 00:00:00 | ZAR
2010-08-31 00:00:00 | ZAR
2010-08-31 00:00:00 | ZAR
2010-08-31 00:00:00 | ZAR
2010-08-31 00:00:00 | ZAR
2010-08-31 00:00:00 | ZAR
2010-08-31 00:00:00 | ZAR
2010-08-31 00:00:00 | ZAR
2010-08-31 00:00:00 | ZAR
2010-08-31 00:00:00 | ZAR
2010-08-31 00:00:00 | ZAR
2010-08-31 00:00:00 | ZAR
2010-08-31 00:00:00 | ZAR
2010-08-31 00:00:00 | ZAR
2010-08-31 00:00:00 | ZAR
2010-08-31 00:00:00 | ZAR
2010-08-31 00:00:00 | ZAR
2010-08-31 00:00:00 | ZAR
2010-08-31 00:00:00 | ZAR