tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 135702d1326194489-running-totals-and-looking-up-text-dummy-parts
Sheet: PARTS OUTGOING

DATE | SUPPLIER INVOICE NO. | SUPPLIER | PART NO. | PART DESCRIPTION | QTY. | PRICE | VAT AMOUNT | VAT ADDED | TOTAL PRICE | TOTAL VAT AMOUNT | TOTAL VAT ADDED | RUNNING TOTAL PRICE | RUNNING TOTAL VAT AMOUNT | RUNNING TOTAL VAT
2012-01-06 00:00:00 | 648294-6 | FLUFFY ANIMALS | 6493RQ | UNICORN PLUSH | 1 | 32.4
2012-01-07 00:00:00 | 846520 | GAMES COMPANY | R R837. 944. 984 | MONOPOLY | 1 | 27.5
2012-01-06 00:00:00 | 039848 | GAMES COMPANY | T T983. 876. 985 | CLUDEO | 1 | 25
2012-01-06 00:00:00 | 394739 | GAMES COMPANY | G G874. 985 | BATTLESHIPS | 1 | 10
2012-01-07 00:00:00 | 0392874 | TOYS LTD | HGY746 7 | [NAME] | 1 | 17.5
2012-01-06 00:00:00 | 94862 | TOYS LTD | TR 7658 | BEACH BALL | 1 | 5
2012-01-06 00:00:00 | 4393763 | TOYS LTD | TRG 7649 | RUBBER BALL | 3 | 1.95
Spreadsheet: 68117d1268674193-excel-2007-solved-if-function-with-4-conditions-new-microsoft-excel-worksheet
Sheet: INPUT

TODAYS DATE
2010-03-15 00:00:00
Nirav | DOB | AGE |  | A
 |  |  | 100000 | 0
X | 1987-12-09 00:00:00 | 22.27945205479452 | 150000 | 0
 |  |  | 200000
Z | 1990-11-30 00:00:00 | 19.3013698630137 | 250000 | 0
 |  |  | 300000
A | 2006-01-03 00:00:00 | 4.197260273972603 | 350000 | 0
 |  |  | 400000
B | 2010-03-15 00:00:00 | 0 | 450000 | 0
 |  |  | 500000
C | 2010-03-15 00:00:00 | 0 | 600000 | 0
 |  |  | 700000 | 0
D | 2004-01-01 00:00:00 | 6.205479452054795 | 800000 | 0
 |  |  | 900000 | 0
 |  |  | 1000000 | 0
ADULT |  | 2
CHILD |  | 2
[NAME] |  | 22.27945205479452
Spreadsheet: 711799d1609921573-manage-data-using-if-function-sample
Sheet: Sheet1

Sn. | Person Name | AR 1 | AR 2 | AR 3 | AR 4 | AR 5 | ED 1 | ED 2 | ED | ED 4 | ED 5 | ED 6 | SR 1 | SR 2 | CD 1 | Result/ Good or VC(use If function)
1 | A | Yes | Yes | Yes | Yes |  | No | Yes | Yes | No | No | No | No | No | No | Good
 | B |  |  |  |  | Yes |  |  |  |  |  |  |  |  |  | VC
 | C |  |  |  |  |  | Yes |  |  | Yes |  |  |  |  |  | VC
 | D |  |  |  |  |  |  |  |  |  |  |  | Yes |  | Yes | Good
 | E |  |  |  |  |  |  |  |  | Yes |  |  | Yes |  |  | Good
 | F
Spreadsheet: 87307d1287131776-sum-duplicates-parts
Sheet: Sheet3

R/S 61342 | 55
R/S 61847 | 94
R/S 61000 | 25
R/S 62222 | 8
R/S 61002 | 125
R/S 19888 | 47
R/S 48745 | 30
R/S 62488 | 8
R/S 31750 | 105
R/S 38960 | 851
R/S 58711 | 22
R/S 61254 | 68
R/S 29965 | 41
Spreadsheet: 3b47e8d9-94bd-4f80-8a11-b93ada373fc9
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Rezultatet e ankandeve te obligacioneve te qeverise - Results of Governments bonds auctions
(ne mije leke / in 000'ALL)
Data e ankandit | Auction date | 01.03.2012 |  | 20.02.2012 | 07.02.2012 | 07.02.2012 | 16.01.2012 | 04.01.2012
[NAME] I obligacionit | Bond type | Reopen 5vjeçar/5year(fix) | [NAME]) | 2vjeçar/2year | 5vjeçar/5year(fix) | 5vjeçar/5year(float) | 2vjeçar/2year | 3vjeçar/3year
Date Emetimi | Settlement Date | 02.03.2012 | 02.03.2012 | 22.02.2012 | 09.02.2012 | 09.02.2012 | 18.01.2012 | 06.01.2012
Date Maturimi | Maturity date | 09.02.2017 | 09.02.2017 | 22.02.2014 | 09.02.2017 | 09.02.2017 | 18.01.2014 | 06.01.2015
Shuma e shpallur | Ammount offered | 500000 | 1000000 | 3000000 | 1000000 | 4000000 | 2500000 | 1500000
Shuma e shpallur (ndryshim strukture) | Ammount offered (structure's changes) | 300000 | 1168000
Shuma e kerkuar | Ammount requested | 300000 | 1368000 | 1981400 | 1321800 | 5416000 | 1674300 | 1176800
Shuma e pranuar | Ammount accepted | 300000 | 1168000 | 1981400 | 1000000 | 4000000 | 1674300 | 1126800
[NAME] | Competitive pro-rate | 1 | 1 | 1 | 0.391 | 0.584 | 1 | 1
Prorata Jokonkurruese | Non competitive pro-rate |  |  | 1 | 1 | 1 | 1 | 1
[NAME]  Uniform I Pranuar | Uniform accepted  yield |  |  | 0.087 | 0.095 |  | 0.088 | 0.0906
Yieldi Maksimal I Kerkuar | Maximum requested yield |  |  | 0.087 | 0.099 |  | 0.088 | 0.091
[NAME] | Minimum requested yield |  |  | 0.082 | 0.089 |  | 0.081 | 0.085
[NAME] I paster | Neutral price | 98.64889579 | 99.96226744
Interesi I akumuluar | Accrued interest | 0.60694444 | 0.58328
Cmimi bruto | Gross price | 99.25584023 | 100.54554744
Marzhi I skontuar | Discount margin |  | 0.0246
Marzhi uniform I pranuar | Uniform accepted  spread |  |  |  |  | 0.0208
Marzhi maksimal I kerkuar | Maximum requested spread |  |  |  |  | 0.025
Marzhi minimal I kerkuar | Minimum requested  spread |  |  |  |  | 0.0098
Interesi I ndryshueshem | Floating interest rate |  |  |  |  | 0.070496
[NAME] | Cupon rate ( percentage) | 0.095 | 0.091296 | 0.087 | 0.095 | 0.091296 | 0.088 | 0.0906
Raporti shume e kerkuar/shume e ofruar | Cover ratio | 0.6 | 1.368 | 0.6604666666666666 | 1.3218 | 1.354 | 0.66972 | 0.7845333333333333
Spreadsheet: 768283d1644915544-if-function-optimisation-book1-2-
Sheet: Sheet1

Lot | PRICE |  |  |  | Lot | Low | High
1 |  |  |  |  | 1 | 1000 | 2000
2 | 2,000￥ - 3,000￥ |  |  |  | 2 | 2000 | 3000
3 | 5,000￥ - 7,500￥ |  |  |  | 3 | 5000 | 7500
RATE | 14
1= [NAME]
100-120 = USD
121-150 = EUR
Spreadsheet: 115037d1310665809-transpose-and-copy-data-with-vba-loop-example
Sheet: Sheet1

how it is set up right now
[NAME] | data2 | data3 | data4 | data5 | New Column Unique ID | Old Column Unique ID1 | Old Column Unique ID2 | Old Column Unique ID3
a | b | c | d | e |  | 123 | 456 | 789
What I want it to look like!!!
[NAME] | data2 | data3 | data4 | data5 | New Column Unique ID | Old Column Unique ID1 | Old Column Unique ID2 | Old Column Unique ID3
a | b | c | d | e | 123
a | b | c | d | e | 456
a | b | c | d | e | 789
Spreadsheet: 868441d1715175527-sort-function-broken-keep-dreaming-league-standings
Sheet: 1 - JAN

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | W |  | L |  | PTS |  | PF |  | PA
JASON | 4 |  |  | 10 |  |  |  | 4 |  |  | 6 |  |  |  | 10 |  |  | 5
MIKE | 10 |  |  |  | 5 |  |  |  | 10 |  |  | 3 |  |  |  | 0 |  |  | 10
[NAME] |  | 10 |  |  | 10 |  |  | 10 |  |  |  |  | 7 |  |  |  | 10 |  |  | 10
PAUL |  | 1 |  |  |  | 6 |  |  | 6 |  |  |  |  | 5 |  |  |  | 10 |  |  | 6
[NAME] |  |  | 5 |  |  | 10 |  |  |  | 7 |  | 10 |  |  | 6 |  |  |  |  | 5
WAYNE |  |  | 10 |  |  |  | 10 |  |  |  | 10 |  | 10 |  |  | 10 |  |  |  |  | 10
MOUNTNEY |  |  |  | 7 |  |  | 5 |  |  | 10 |  |  |  | 10 |  |  | 7 |  | 7
 | 1-2 | 3-4 | 5-6 | 1-7 | 2-3 | 4-5 | 6-7 | 1-3 | 2-4 | 5-7 | 1-6 | 2-5 | 3-6 | 4-7 | 1-5 | 2-6 | 3-7 | 1-4 | 2-7 | 3-5 | 4-6
Spreadsheet: 855381d1704970012-if-with-averageifs-returning-value-sample-data-29-aligw
Sheet: Sheet1

Month | Project Name | Cash Out Periodic | Forecast Cash Out 3 months rolling | Forecast Cash Out - 3 months rolling YTD
January | Ninja | 4990
February | Ninja | 576
March | Ninja | 0
April | Ninja | 18445
May | Ninja | 20783
June | Ninja | 53402
July | Ninja | 3127
August | Ninja | 8919
September | Ninja | 53512
October | Ninja | 78109
November | Ninja | 70641
December | Ninja | 0
Spreadsheet: 748319d1632070801-time-vs-hours-too-many-hours-and-formula-wont-work-timereport
Sheet: TimeReport

 | Jan - Aug 21 |  |  |  | YEAR TO DATE
 |  |  |  |  |  | Jan - Aug 21 |  |  | double check
100/FABRIC | 1,503:11
200/METAL | 17 days, 15:30:00 |  |  |  | 100/FABRIC | 1,503:11 | seconds dropped |  | 1503
210/METAL-B | 5 days, 21:27:00 |  |  |  | 200/METAL | 17 days, 15:30:00 |  |  | 423
230/METAL-Br | 11 days, 18:50:00 |  |  |  | 210/METAL-B | 5 days, 21:27:00 |  |  | 141
300/F&W | 1,229:58 |  |  |  | 230/METAL-Br | 11 days, 18:50:00 |  |  | 282
309/REWORK | 8:00:00 |  |  |  | 300/F&W | 1,229:58 |  |  | 1229
399/BC & WAR | 4 days, 6:24:00 |  |  |  | 309/REWORK | 8:00:00 |  |  | 8
400/S&P | 9 days, 16:07:00 |  |  |  | 399/BC & WAR | 4 days, 6:24:00 |  |  | 102
500/Assembly | 12 days, 21:13:00 |  |  |  | 400/S&P | 9 days, 16:07:00 |  |  | 232
509/REWORK | 1:15:00 |  |  |  | 500/Assembly | 12 days, 21:13:00 |  |  | 309
600/Shipping | 4 days, 16:12:00 |  |  |  | 509/REWORK | 1:15:00 |  |  | 1
700/Field Work | 8:00:00 |  |  |  | 600/Shipping | 4 days, 16:12:00 |  |  | 112
800/OH | 11 days, 0:08:00 |  |  |  | 700/Field Work | 8:00:00 |  |  | 8
820/Break | 5 days, 12:11:00 |  |  |  | 800/OH | 11 days, 0:08:00 |  |  | 264
830/Holiday | 2 days, 16:00:00 |  |  |  | 820/Break | 5 days, 12:11:00 |  |  | 132
TOTAL | 4,814:26 |  |  |  | 830/Holiday | 2 days, 16:00:00 |  |  | 64
 |  |  |  |  |  |  | WRONG HOURS
CSV Export - no formulas |  |  |  |  | Excel Export
shows correct total
for reference only - I won't use csv |  |  |  |  |  | need this total to work!
Spreadsheet: 792494d1660922655-amalgamating-and-deleting-rows-gk-special-assistance-final
Sheet: Result

Passenger Assist List |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-07-04 00:00:00
 |  |  |  |  |  |  |  |  | [NAME] |  |  |  | Departure
Job | Assigned To | Name | HIP | VIP | W/C | BR W/C | Mob Imp | [NAME] | Time | Head Code | From | [NAME] | Time | Head Code | Destination | [NAME] | Additional Comments
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
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
Spreadsheet: cf9818c3-3043-4959-9326-a7a78fc84e28
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
VLTU | Test | VLTU | Volatile Screen, [NAME] | [NAME], U | Headspace Gas Chromatography-Flame Ionization Detector (HSGC-FID) Includes methanol, ethanol, isopropanol, and acetone. | [NAME]: Urine |  |  | 10 | mL | Container/Tube: Plastic, 10-mL urine tube (Supply T068) [NAME]: 10 mL Collection Instructions:  1. Collect a random urine specimen. 2. No preservative. | 1 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | METHANOL Not detected (Positive results are quantitated.) [NAME] concentration: 10 mg/dL Toxic concentration: > or =10 mg/dL   ETHANOL Not detected (Positive results are quantitated.) [NAME] concentration: 10 mg/dL   ISOPROPANOL Not detected (Positive results are quantitated.) [NAME] concentration: 10 mg/dL Toxic concentration: > or =10 mg/dL   ACETONE Not detected (Positive results are quantitated.) [NAME] concentration: 10 mg/dL Toxic concentration: > or =10 mg/dL | Monday through Sunday; Varies | Same day/1 day | 2 days | 1 | 84600 |  |  |  |  | Rochester
VLTU | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 72 hours
VLTU | Result | 8826 | [NAME], U | [NAME], U | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12983-3 | Volatiles:Prid:Pt:[NAME]:Nom:
VLTU | Result | 30904 | Methanol, U | Methanol, U | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 5695-2 | Methanol:MCnc:Pt:[NAME]:Qn:
VLTU | Result | 30905 | Ethanol, U | Ethanol, U | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 5645-7 | Ethanol:MCnc:Pt:[NAME]:Qn:
VLTU | Result | 30906 | Acetone, U | Acetone, U | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 5570-7 | Acetone:MCnc:Pt:[NAME]:Qn:
VLTU | Result | 30907 | Isopropanol, U | Isopropanol, U | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 9434-2 | Isopropanol:MCnc:Pt:[NAME]:Qn:
VLTU | Result | 34378 | Chain of Custody | Chain of Custody | Numeric
Spreadsheet: 02d0aba9-4e63-4a58-8fe0-010bf1615e85
Sheet: ABC-CLIO

ABC-CLIO
2006-2007
 | 2006-07-01 00:00:00 | 2006-08-01 00:00:00 | 2006-09-01 00:00:00 | 2006-10-01 00:00:00 | 2006-11-01 00:00:00 | 2006-12-01 00:00:00 | 2007-01-01 00:00:00 | 2007-02-01 00:00:00 | 2007-03-01 00:00:00 | 2007-04-01 00:00:00 | 2007-05-01 00:00:00 | 2007-06-01 00:00:00 | Total | 2006-2007 Price | Price per search
[NAME]
Sessions | 53 | 18 | 149 | 312 | 280 | 105 | 55 | 136 | 221 | 316 | 44 | 43
Searches | 61 | 13 | 241 | 359 | 318 | 102 | 65 | 157 | 343 | 509 | 42 | 60 |  | 6720
 | 2006-07-01 00:00:00 | 2006-08-01 00:00:00 | 2006-09-01 00:00:00 | 2006-10-01 00:00:00 | 2006-11-01 00:00:00 | 2006-12-01 00:00:00 | 2007-01-01 00:00:00 | 2007-02-01 00:00:00 | 2007-03-01 00:00:00 | 2007-04-01 00:00:00 | 2007-05-01 00:00:00 | 2007-06-01 00:00:00 | Total | 2006-2007 Price | Price per search
HA Database
Sessions | 23 | 6 | 18 | 65 | 120 | 69 | 10 | 71 | 111 | 115 | 33 | 20
Searches | 27 | 2 | 8 | 58 | 121 | 87 | 10 | 79 | 98 | 126 | 40 | 30 |  | 6720
 | 2006-07-01 00:00:00 | 2006-08-01 00:00:00 | 2006-09-01 00:00:00 | 2006-10-01 00:00:00 | 2006-11-01 00:00:00 | 2006-12-01 00:00:00 | 2007-01-01 00:00:00 | 2007-02-01 00:00:00 | 2007-03-01 00:00:00 | 2007-04-01 00:00:00 | 2007-05-01 00:00:00 | 2007-06-01 00:00:00 | Total | 2006-2007 Price | Price per search
XDB (XDB = Combined AHL and HA Database Activity)
Sessions | 12 | 9 | 7 | 97 | 56 | 14 | 7 | 25 | 37 | 39 | 3 | 11
Searches | 16 | 18 | N/A | 30 | 42 | 14 | 6 | 12 | 47 | 71 | 4 | 7 |  | N/A | N/A
 | 2006-07-01 00:00:00 | 2006-08-01 00:00:00 | 2006-09-01 00:00:00 | 2006-10-01 00:00:00 | 2006-11-01 00:00:00 | 2006-12-01 00:00:00 | 2007-01-01 00:00:00 | 2007-02-01 00:00:00 | 2007-03-01 00:00:00 | 2007-04-01 00:00:00 | 2007-05-01 00:00:00 | 2007-06-01 00:00:00 | Total | 2006-2007 Price | Price per unit
ABC-CLIO databases (all)
Sessions
Searches
COUNTER-Compliant?: | No
Spreadsheet: 456012d1460608342-match-array-and-create-a-unique-id-array_match_unique_id
Sheet: Sheet1

 |  |  |  |  | Results below this column
[NAME] number | [NAME] |  |  | RF-1_RAH
1001 | _SS |  |  | RF-1_RAT
1002 | _ST |  |  | SF-3_FFLT
7003 | _SPD |  |  | SF-3_PFLT
1004 | _FDBK |  |  | RF-1_EAD
 |  |  |  | [NAME] | 7003
 |  |  |  | SF-3_CCV
 |  |  |  | SF-3_HCV
 |  |  |  | SF-3_SSP
 |  |  |  | SF-3_MAT
 |  |  |  | SF-3_SAT
 |  |  |  | SF-4_FFLT
 |  |  |  | SF-3_MAD
 |  |  |  | SF-3_OAD
 |  |  |  | SF-3_SPD | 7103
 |  |  |  | SF-4_PFLT
 |  |  |  | SF-4_SSP
 |  |  |  | SF-4_MAT
 |  |  |  | SF-4_SAT
 |  |  |  | SF-4_CCV
 |  |  |  | SF-4_HCV
 |  |  |  | SF-4_MAD
 |  |  |  | BSP
 |  |  |  | SF-4_OAD
 |  |  |  | SF-4_SPD | 7203
 |  |  |  | [NAME]
 |  |  |  | RF-1_ST | 1002
 |  |  |  | [NAME]
 |  |  |  | SF-3_ST | 1102
 |  |  |  | RF-1_SS | 1001
 |  |  |  | SF-3_SS | 1101
 |  |  |  | SF-4_SS | 1201
 |  |  |  | RF-1_SSD
 |  |  |  | SF-3_HSP
 |  |  |  | SF-3_SSD
 |  |  |  | SF-4_ALM
 |  |  |  | SF-4_HSP
 |  |  |  | SF-4_SSD
 |  |  |  | SF-4_ST | 1202
Spreadsheet: 180970d1347889739-index-match-formula-excel-help3
Sheet: Sheet1

 | Yearly
 | 2007 | 2008 | 2009 | 2010 | 2011
A/R | 125 | 800 | 16000 | 18433 | 21945
Total Sales | 1000 | 10584 | 125840 | 134784 | 200685
DSO
 | Average | Low | Low Date | High | High Date
Yearly
Spreadsheet: stacey_white__38841__West Limits Fax
Sheet: Limits

 | NA WEST POWER VaR
 |  |  |  |  | Increase/ | Average Daily
 | Portfolio | Portfolio | Trader | VaR | (Decrease) | VaR Limits | VaR Limit | Violation
 | Name | Name | Name | ($) | in VaR | ($) | ($)
 | ALL REGIONS
 | NA WEST POWER | POWER-WEST-TOTL | [NAME] | 12092105.83946904 | 1974209.772546893 | 4900000 | 10000000 | VIOLATION
 | WEST-LT | POWER-WEST-LT | [NAME] | 9624998.766867898 | 912207.6152005065 | 3800000 | 7900000 | VIOLATION
 | WEST-LT | POWER-WEST-LT | [NAME] | 9624998.766867898 | 912207.6152005065 | 3800000 | 7900000 | VIOLATION
 | WEST-ST | POWER-WEST-ST1 | [NAME] | 2741743.412692547 | 632783.6388737815 | 1700000 | 3300000
 | CANADA | FT-CAND-PWR-1 | [NAME] | 21251633.41103908 | 205417.2261294127 |  |  | VIOLATION
 | TOTAL WEST POWER |  | [NAME] | 31407415.31402991 | 2175655.766877875
 | WEST POWER LONG TERM
 | MANAGEMENT | POWER-WM-LT | [NAME] | 2461394.598074626 | -1037644.396331719 | 1300000 | 2400000 | VIOLATION
 | CALIFORNIA | POWER-CA-LT | [NAME] | 911085.27494625 | 13806.74470570113 | 1300000 | 2400000
 | NORTHWEST REGION | POWER-NW-LT | [NAME] | 7371080.034075005 | 1711615.62997174 | 3100000 | 6100000 | VIOLATION
 | SOUTHWEST REGION | POWER-SW-LT | [NAME] | 4580291.385260787 | -445381.1991825756 | 1300000 | 2800000 | VIOLATION
 | WEST-LT | POWER-WEST-LT |  | 9624998.766867898 | 912207.6152005065 | 3800000 | 7900000 | VIOLATION
 | WEST POWER SHORT TERM
 | CA-ST | POWER-CA-ST | [NAME] Richter | 1281686.999201369 | 60116.69035716611 | 1000000 | 3000000
 | NW-ST | POWER-NW-ST | [NAME] | 1124010.483540686 | 166068.4847020253 | 1000000 | 1400000
 | SW-ST | POWER-SW-ST | [NAME]/[NAME] | 843311.8349967487 | 236645.7700082047 | 1000000 | 1300000
 | WEST-ST | POWER-WEST-ST1 | [NAME] | 2741743.412692547 | 632783.6388737815 | 1700000 | 3300000
Spreadsheet: 888974d1739626314-simplifing-multiple-formulas-to-one-formula-example
Sheet: Sheet1

1 | 5
text | text
12 | 1
text | text
2 | 7
text | text
 | Total:
Spreadsheet: 36455d1234344617-squash-or-any-sport-win-lose-draw-table-help-zoomer_ads
Sheet: Sheet1

Date | Upcoming Matches |  |  |  | Date | Squash Results |  |  | Winner |  |  | Pl | W | D | L
2009-02-10 00:00:00 | [NAME] | vs | Ric |  | 2009-01-16 00:00:00 | Huw | vs | [NAME] | Huw |  | Huw | 5 | 3 | 1 | 1
2009-02-11 00:00:00 | [NAME] | vs | Ric |  | 2009-01-20 00:00:00 | Huw | vs | Ian | Ian |  | Ian | 3 | 3 | 0 | 0
2009-02-12 00:00:00 | [NAME] | vs | Ian |  | 2009-01-21 00:00:00 | [NAME] | vs | [NAME] | [NAME] |  | [NAME] | 4 | 1 | 0 | 0
2009-02-17 00:00:00 | [NAME] | vs | Ian |  | 2009-01-22 00:00:00 | Huw | vs | [NAME] | Huw |  | [NAME] | 3 | 2 | 0 | 0
2009-02-18 00:00:00 | [NAME] | vs | Ric |  | 2009-01-27 00:00:00 | Ian | vs | Ric | Ian |  | [NAME] | 3 | 0 | 0 | 0
 |  |  |  |  | 2009-01-28 00:00:00 | [NAME] | vs | [NAME] | [NAME] |  | Ric | 2 | 0 | 1 | 1
 |  |  |  |  | 2009-01-29 00:00:00 | Huw | vs | [NAME] | Huw
 |  |  |  |  | 2009-02-03 00:00:00 | [NAME] | vs | Ian | Ian
 |  |  |  |  | 2009-02-04 00:00:00 | Huw | vs | Ric
 |  |  |  |  | 2009-02-05 00:00:00 | [NAME] | vs | [NAME] | [NAME]
Spreadsheet: 002ff8f7-34f1-4f75-ab90-dc7586af3484
Sheet: OB-Other

Off-Balance Exhibit |  |  |  |  |  |  | OB-Other
Insurance Company: |  | Insert Company Name
Program: |  | Insert Program Type
Effective Date: |  | MM/DD/YYYY
Rating Variable |  |  | Coverages
(Add/Delete rows/columns as needed) |  |  | C 1 | C 2 | C 3 | etc | Total
RV 1
RV 2
RV 3
RV 4
RV 5
RV 6
RV 7
RV 8
etc
Coverage Overall Change
Earned Premiums or Earned Exposures
Weight
Overall Total
Insurer Notes:
Notes:
1.  Use a row for each Rating Variable of change (i.e. Base Rates, Territory, Driver Class, etc)
2.  Earned Premium or [NAME] should be used to weight the average premium change by Coverage
3.  The Rating Variable Total value should balance to the Rating Variable Total % Change value in VAR-Other Exhibit
4.  [NAME] exhibit for each Program type being filed
Spreadsheet: 798794d1664731235-tracking-hourly-metrics-hourly-tracker-sample-2
Sheet: Sheet1

Hourly Performance
0700-0800 | Cartons | 1
Goals | Cartons | 1
0800-0900 | Cartons | 1
Goals | Cartons | 1
0900-1000 | Cartons | 1
Goals | Cartons | 1
1000-1100 | Cartons | 1
Goals | Cartons | 1
1100-1200 | Cartons | 1
Goals | Cartons | 1
1200-1300 | Cartons | 1
Goals | Cartons | 1
1300-1400 | Cartons | 1
Goals | Cartons | 1
1400-1500 | Cartons | 1
Goals | Cartons | 1
1500-1600 | Cartons | 1
Goals | Cartons | 1
1600-1700 | Cartons
Goals | Cartons | 1
1700-1800 | Cartons
Goals | Cartons | 1
TOTALS | Cartons
GOALS | Goal | 11
Shift Delta
Current Delta
Spreadsheet: 79316d1279588052-excel-2007-transform-column-to-row-help
Sheet: Sheet1

-0.001
[-0.03]
0.024
[1.11]
0.032
[1.04]
0.025
[0.87]
0.014
[0.70]
0.05
[1.24]
0.023
[0.98]
0.051
[1.35]
0.045
[2.11]*
0.014
[0.30]
0.003
[0.13]
0.048
[1.26]
0.002
[0.13]
0.005
[0.31]
-0.024
[-0.70]
-0.042
[-0.91]
-0.021
[-0.56]
0.033
[1.01]
0.08
[1.43]
0.014
[0.68]
-0.005
[-0.22]
-0.028
[-0.86]
-0.013
[-0.44]
0.044
[1.17]
0.003
[0.10]
0.042
[1.63]
-0.02
[-0.64]
-0.025
[-0.46]
0.07
[2.14]*
0.027
[0.98]
0.02
[0.54]
-0.001
[-0.02]
0.044
[1.80]
-0.003
[-0.09]
0.025
[1.51]
0.03
[1.79]
0.099
[1.99]*
-0.018
[-0.44]
0.009
[0.33]
0.009
[0.37]
0.012
[0.31]
-0.014
[-0.53]
-0.015
[-0.40]
-0.005
[-0.10]
-0.004
[-0.28]
0.028
[0.87]
0.007
[0.27]
0.038
[1.03]
0.032
[1.41]
Spreadsheet: 675644d1588399371-populate-rows-with-cells-that-first-meet-two-conditions-criteria-example
Sheet: Sheet1

DAN | MONDAY | ADRESA | TELEFON | DEO GRADA | DAN | ZELJENO VREME DOSTAVE | PLANIRANO VREME DOSTAVE | BROJ TURE | REDOSLED DOSTAVLJANJA | [NAME] I OSTALE BELESKE
Br | IME NARUCIOCA
Spreadsheet: 30817d1226507327-data-converted-to-scientific-notation-test1
Sheet: Sheet1

I INPUT THIS | EXCEL CONVERTS TO | Function Output | Correct Answer | True/False (B VS C)
248E12 | 248000000000000 | 248E12 | 248E12 | 1
1234E4321 | 1234E4321 | 1234E4321 | 1234E4321 | 1
123E35 | 1.234e+37 | 123E35 | 123E35 | 1
32E54 | 3.2e+55 | 32E54 | 32E54 | 1
2488E99 | 2.488e+102 | 249E100 | 2488E99 | 0
345E21 | 3.45e+23 | 345E21 | 345E21 | 1
123E5 | 12300000 | 123E5 | 123E5 | 1
123E2 | 12300 | 123E2 | 123E2 | 1
1e2 | 100 | 100 | 1e2 | 0
123456789E123456789 | 123456789E123456789 | 123456789E123456789 | 123456789E123456789 | 1
1E654654 | 1E654654 | 1E654654 | 1E654654 | 1
12e122 | 1.2e+123 | 120E121 | 12e122 | 0
1E1234 | 1E1234 | 1E1234 | 1E1234 | 1
1E3 | 1000 | 100E1 | 1E3 | 0
123E3 | 123000 | 123E3 | 123E3 | 1
12E1234 | 12e1234 | 12e1234 | 12E1234 | 1
123E1234 | 123E1234 | 123E1234 | 123E1234 | 1
12E11 | 1200000000000 | 120E10 | 12E11 | 0
9E1234 | 9E1234 | 9E1234 | 9E1234 | 1
220E21 | 2.2e+23 | 220E21 | 220E21 | 1
900E7 | 9000000000 | 900E7 | 900E7 | 1
990E98 | 9.9e+100 | 990E98 | 990E98 | 1
120E8 | 12000000000 | 120E8 | 120E8 | 1
7E3 | 7000 | 700E1 | 7E3 | 0
9E9 | 9000000000 | 900E7 | 9E9 | 0
Spreadsheet: 01e118d2-4d57-43b6-b1bf-5ad2f5dedb28
Sheet: Diesel Tech 1

DIESEL TECHNOLOGY
Associate in Applied Science
Student Name:
ID #
General Education | Semester | Grade
___ Writing/Accessing Information (3)
___[NAME] (3)
___ Natural Science (3)
___ Social/Behavioral Science (3)
___ Heritage/Humanities (3)
___ CIT 105 (3) Introduction to Computers or IC3 Computer Literacy Exam
Technical Core
Required
___ BEX 100 (3) Basic Electricity for Non-Majors
AND ___ BEX 101 (2) Basic Electricity Lab for Non-Majors
OR ___ ADX 120 (3) Basic Automotive Electricity
AND ___ ADX 121 (2) Basic Electiricity Lab
OR ___ ELT 110 (5) Circuits I
___ ADX 170 (3) Climate Control AND ___ ADX 171 (1) Climate Control Lab
___ DIT 103 (2) Preventive Maintenance Lab
___ DIT 110 (3) Introduction to Diesel Engines
AND ___ DIT 111 (2) Introduction to Diesel Engines Lab
OR ___ ADX 150 (3) Engine Repair AND ___ ADX 151 (2) Engine Repair
___ [NAME] (3) Diesel Engine Repair AND ___ DIT 113 (2) Diesel Engine Repair Lab
___ DIT 140 (3) Hydraulics AND ___ DIT 141 Hydraulics Lab
OR ___ FPX 100 (3) Fluid Power AND ___ FPX 101 (2) Fluid Power Lab
___ DIT 150 (3) Power Trains AND ___ DIT 151 (2) Power Trains Lab
___ DIT 190 (3) Electrical Systems for Diesel Equipment
AND ___ DIT 191 (2) Electrical Systems for Diesel Equipment Lab
OR ___ ADX 260 (3) Electrical Systems AND ___ ADX 261 (2) Electrical Systems Lab
Agriculture Diesel Technician Track
___ DIT 152 (3) Powertrain for Construction Equipment
___ DIT 153 (2) Powertrain for Construction Equipment Lab
___ DIT 121 (3) Introduction to Maintenance Welding Lab
OR ___ IMT 100 (3) Welding for Maintenance
AND ___ IMT 101 (2) Welding for [NAME]
OR ___ WLD 120 (3) Shielded Metal Arc Welding (SMAW)
AND ___ WLD 121 (2) Shielded Metal Arc Welding (SMAW) Lab
Southeast Kentucky Community & Technical College | Updated Spring 2013
Spreadsheet: 190174d1351546096-top-3-based-on-3-categories-fruit-example
Sheet: Raw_Data

 | Fruit | Container | Location
 | Apple | Bowl | Bedroom
 | Apple | Cup | Living Room
 | Apple | Cup | Bedroom
 | Apple | Basket | Kitchen
 | Apple | Bowl | Kitchen
 | Apple | Basket | Bedroom
 | Apple | Cup | Kitchen
 | Apple | Basket | Kitchen
 | Apple | Bowl | Kitchen
 | Apple | Basket | Kitchen
 | Orange | Bowl | Bedroom
 | Orange | Cup | Kitchen
 | Orange | Cup | Kitchen
 | [NAME] | Cup | Kitchen
 | [NAME] | Basket | Kitchen
 | [NAME] | Bowl | Kitchen
 | [NAME] | Cup | Kitchen
 | [NAME] | Basket | Living Room
 | [NAME] | Cup | Living Room
 | [NAME] | Basket | Living Room
 | [NAME] | Bowl | Living Room
 | [NAME] | Basket | Bedroom
 | [NAME] | Tub | Bedroom
 | [NAME] | Tub | Bedroom
 | [NAME] | Bowl | Bedroom
Spreadsheet: 721199d1614583165-transfer-data-from-a-table-while-ignoring-empty-cells-sample22-ans
Sheet: Sheet1

Category 1 | Category 2 | Category 3
Subject 1
Subject 2 | 2 | 3
Subject 3
Subject 4 | 4 | 7
What I want