tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 56472d93-ec80-4ea5-b2f2-ea0156c2f02d
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2014-04-14 09:43:21.340000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.75 | 102.875 | 102.75 | 102.625 | 102.25 |  | and are added to price quote
4.625 | 102.743 | 102.618 | 102.493 | 102.118
4.5 | 101.826 | 101.701 | 101.576 | 101.201 |  | Note: | Refer To Price [NAME]
4.375 | 100.949 | 100.824 | 100.699 | 100.324 |  |  | For all Price Adjs
4.25 | 100.384 | 100.259 | 100.134 | 99.509
4.125 | 99.571 | 99.446 | 99.321 | 98.696
4 | 98.573 | 98.448 | 98.323 | 97.698
3.875 | 97.534 | 97.409 | 97.284 | 96.659
3.75 | 96.659 | 96.534 | 96.409 | 95.784
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.875 | 102.762 | 102.637 | 102.512 | 102.137
3.75 | 102.38 | 102.255 | 102.13 | 101.755
3.625 | 101.981 | 101.856 | 101.731 | 101.356
3.5 | 101.442 | 101.317 | 101.192 | 100.817
3.375 | 100.666 | 100.541 | 100.416 | 99.791
3.25 | 99.902 | 99.777 | 99.652 | 99.027
3.125 | 99.337 | 99.212 | 99.087 | 98.462 |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2014-04-28 09:43:21.340000
30 DAY | 2014-05-13 09:43:21.340000
45 DAY | 2014-05-28 09:43:21.340000
60 DAY | 2014-06-12 09:43:21.340000
90 DAY | 2014-07-12 09:43:21.340000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 100063d1298538796-add-letters-to-numbers-in-column-b-book1_sem
Sheet: Sheet1

1 2 3 4 5 |  | Data 1
1 6 11 16 21 |  | Data 2
1 7 13 19 25 |  | Data 3
1 8 15 17 24 |  | Data 4
1 9 12 20 23 |  | Data 5
1 10 14 18 22 |  | Data 6
2 6 15 19 23 |  | Data 7
2 7 12 17 22 |  | Data 8
2 8 14 20 21 |  | Data 9
2 9 11 18 25 |  | Data 10
2 10 13 16 24 |  | Data 11
3 6 14 17 25 |  | Data 12
3 7 11 20 24 |  | Data 13
3 8 13 18 23 |  | Data 14
3 9 15 16 22 |  | Data 15
3 10 12 19 21 |  | Data 16
4 6 13 20 22 |  | Data 17
4 7 15 18 21 |  | Data 18
4 8 12 16 25 |  | Data 19
4 9 14 19 24 |  | Data 20
4 10 11 17 23 |  | Data 21
5 6 12 18 24 |  | Data 22
5 7 14 16 23 |  | Data 23
5 8 11 19 22 |  | Data 24
5 9 13 17 21 |  | Data 25
5 10 15 20 25 |  | Data 26
6 7 8 9 10 |  | Data 27
11 12 13 14 15 |  | Data 28
16 17 18 19 20 |  | Data 29
21 22 23 24 25 |  | Data 30
Spreadsheet: 33217d1229523012-the-use-of-indirect-in-array-or-sumproduct-formulas-example
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | SUMPRODUCT
 | Here a portion of the sumproduct would be created based on entries in the boxes below. E.g., (Var01=2)*(Var03<>1)  or  (var04=1)*(Var06=3) |  |  |  |  |  |  |  | the sumproduct would consist of two components, one element would be constant, and the other would be the part that is indirect
 |  |  |  |  |  |  |  |  | The issue is that I will have many sumproducts or array formulas that will utilize the indirect portion of the function.
= | 2
<> |  |  | 1
 | [NAME] | VAR02 | VAR03 | VAR04 | VAR05 | VAR06 | VAR07 |  | {=average(if(indirect(B2)),var07)}
 | 3 | 0 | 1 | 0 | 3 | 1 | 1 |  | {=stdev(if(indirect(B2)),var07)}
 | 4 | 1 | 1 | 4 | 3 | 3 | 1 |  | {=min(if(indirect(B2)),var07)}
 | 3 | 4 | 1 | 3 | 1 | 4 | 0
 | 0 | 3 | 2 | 2 | 4 | 4 | 4 |  | I basically want to be able to change the conditions once and have them apply to all of the formulas.
 | 1 | 4 | 3 | 1 | 4 | 1 | 0
 | 4 | 0 | 3 | 0 | 0 | 2 | 3
 | 4 | 0 | 0 | 0 | 2 | 1 | 0
 | 2 | 0 | 0 | 3 | 0 | 0 | 1
 | 0 | 4 | 4 | 3 | 0 | 2 | 1
 | 0 | 4 | 0 | 2 | 4 | 3 | 0
 | 4 | 2 | 2 | 1 | 2 | 3 | 4
 | 3 | 3 | 4 | 1 | 4 | 1 | 4
 | 1 | 0 | 1 | 3 | 2 | 1 | 1
 | 3 | 1 | 3 | 1 | 2 | 4 | 1
 | 1 | 0 | 4 | 0 | 4 | 1 | 1
Spreadsheet: 691593d1597770578-excel-formula-to-capture-invoice-number-invoice-numbers
Sheet: SALES DATA

Date | Invoice | Customer Number | Name | VAT Number | Order Number | Product Number | Unit Price | Quantity | Gross Amount | VAT % | VAT | Amount Incl VAT |  |  |  |  | C001 | Centenary | 2000123
2020-08-01 00:00:00 | 100 | C001 |  |  | A23 | Maize | 200 | 10 |  | 0.15 |  |  |  |  |  |  | C002 | Dispatch | 2000130
2020-08-01 00:00:00 | 100 | C001 |  |  | A23 | Ground nuts | 100 | 8 |  | 0.15 |  |  |  |  |  |  | C003 | Global | 2000213
2020-08-02 00:00:00 | 101 | C003 |  |  | A24 | Maize | 300 | 10 |  | 0.15 |  |  |  |  |  |  | C004 | Achieve | 2000310
2020-08-03 00:00:00 | 102 | C004 |  |  | A25 | Maize | 150 | 10 |  | 0.15 |  |  |  |  |  |  | C005
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C006
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C007
Spreadsheet: michelle_lokay__26805__imbalsumm
Sheet: williams

 | La Maquina |  | Milgro |  | [NAME] |  | [NAME]
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 92770 | 98790 | 291321 | 284224 | 53647 | 86597 | 191024 | 177549
2 | 96517 | 108908 | 302068 | 280299 | 33559 | 32074 | 188085 | 191427
3 | 99072 | 109543 | 264945 | 255275 | 65700 | 61385 | 194417 | 194246
4 | 93627 | 97636 | 292824 | 307380 | 64081 | 53117 | 206846 | 210626
5 | 96405 | 90469 | 311062 | 315237 | 55777 | 54022 | 159601 | 165280
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
2000-07-31 00:00:00 |  |  |  |  |  |  |  |  | -48032
2000-08-05 00:00:00
Spreadsheet: 583776d1532635975-index-match-for-sheet-name-in-another-workbook-md_de_dash-forum_help
Sheet: 033310-020

07/24/18
10:47 AM |  |  |  |  |  | 12 Month Actual
 |  |  |  |  |  | WMDTFC
033310-020 |  |  |  |  |  | For the Month Ending June 30, 2018
 | July | August | September | October | November | December | January | February | March | April | May | June | Year to Date
Operating Income | 82353 | 76031 | 89316 | 93903 | 88994 | 91133 | 98741 | 83457 | 82534 | 102891 | 97707 | 87273 | 1074333
Personnel Expenses | 41865 | 39688 | 45775 | 50178 | 46108 | 43607 | 46872 | 44024 | 47544 | 46453 | 46756 | 46483 | 545353
Operating Expenses | 41308 | 45679 | 46909 | 50539 | 44624 | 47399 | 39789 | 32743 | 37816 | 50421 | 61609 | 45780 | 544616
Total Direct Expenses | 83173 | 85367 | 92684 | 100717 | 90732 | 91006 | 86661 | 76767 | 85360 | 96874 | 108365 | 92263 | 1089969
 | - | - | - | - | - | - | - | - | - | - | - | - | -
Program Operating Margin | -820 | -9336 | -3368 | -6814 | -1738 | 127 | 12080 | 6690 | -2826 | 6017 | -10658 | -4990 | -15636
Program Operating % | -0.00995713574490304 | -0.122792019044863 | -0.0377088091719289 | -0.0725642418240099 | -0.0195294064768411 | 0.00139356764289555 | 0.122340263922788 | 0.0801610410151335 | -0.0342404342452807 | 0.0584793616545665 | -0.109081232665009 | -0.0571769046555063 | -0.200675949592958
 | - | - | - | - | - | - | - | - | - | - | - | - | -
Overhead Expenses | 12817 | 10491 | 12583 | 12071 | 11749 | 12454 | 10057 | 12182 | 10603 | 12276 | 11646 | 13943 | 142872
Total Expenses | 95990 | 95858 | 105267 | 112788 | 102481 | 103460 | 96718 | 88949 | 95963 | 109150 | 120011 | 106206 | 1232841
 | - | - | - | - | - | - | - | - | - | - | - | - | -
Income Over/Under Expenses | -13637 | -19827 | -15951 | -18885 | -13487 | -12327 | 2023 | -5492 | -13429 | -6259 | -22304 | -18933 | -158508
 | = | = | = | = | = | = | = | = | = | = | = | = | =
6020 Population | 16 | 15 | 15 | 14 | 14 | 16 | 15 | 15 | 14 | 15 | 15 | 0
6040 Units | 49 | 49 | 69 | 51 | 44 | 41 | 48 | 87 | 0 | 68 | 7 | 0
6041 Units | 1 | 2 | 2 | 1 | 11 | 4 | 0 | 0 | 0 | 1 | 0 | 0
Spreadsheet: 873528d1720018185-inserted-rows-do-not-have-border-as-expected-boardertest-welchs101-
Sheet: Sheet1

 | Hdr1 | Hdr2 | Hdr3 | HDr4 | Hdr5 | Hdr6 | Hdr62 | Hdr7 | Hdr8 | [NAME] | Hdr10
 | Below is what I want when I insert a row.  See how borders in new row 16 match those in 15
 | Hdr1 | Hdr2 | Hdr3 | HDr4 | Hdr5 | Hdr6 | Hdr6 | Hdr7 | Hdr8 | [NAME] | Hdr10
 | But what I get and I cant figure out why is when I insert row between 3 and 4 (see rows above).  No side borders on cells only the underline.
 | Hdr1 | Hdr2 | Hdr3 | HDr4 | Hdr5 | Hdr6 | Hdr6 | Hdr7 | Hdr8 | [NAME] | Hdr10
Spreadsheet: 263209d1378402397-sum-if-with-multiple-ifs-sumif-plus-and-tlapointe1970-oeldere-
Sheet: Sheet1

number | name | value | choise |  |  |  |  | choise
30101 | You | 15
30101 | you | 18 |  |  |  |  |  | Rijlabels | Som van value
30101 | you | 22.5 |  |  |  |  |  | 30101 | 67
30101 | me | 11.5 |  |  |  |  |  | me | 11.5
30202 | me | 6.25 |  |  |  |  |  | You | 55.5
30202 | you | 11.72 |  |  |  |  |  | 30202 | 84.84
30202 | [NAME] | 15.25 |  |  |  |  |  | [NAME] | 31.8
30202 | [NAME] | 14.33 |  |  |  |  |  | [NAME] | 28.33
30202 | you | 12.99 |  |  |  |  |  | You | 24.71
30202 | [NAME] | 16.55 |  |  |  |  |  | 30303 | 35.1
30202 | [NAME] | 14 |  |  |  |  |  | me | 18.6
30202 | me | 18.95 |  |  |  |  |  | You | 16.5
30303 | you | 16.5 |  |  |  |  |  | Eindtotaal | 186.94
30303 | me | 11.1
30303 | me | 7.5
Spreadsheet: holden_salisbury__12323__PrePay Accounting_1220
Sheet: Midway-Sun

Hour |  |  |  |  |  |  | Linked Data
Ending
Pacific | Midway physical | From 4C 230 | WAPA Option | WAPA | WAPA | TSGT | To CSU | To San Juan | WAPA | Tristate | WAPA | Balance
Standard | position | WAPA Trans |  | Purch | Purch | Purch | Call Option | WAPA trans | Sale | Sale | Sale
(PST)
 |  |  |  |  |  | 27.75 | 28.9245
100 | 0
200 | 0
300 | 0
400 | 0
500 | 0
600 | 0
700 | 0
800 | 0
900 | 0
1000 | 0
1100 | 0
1200 | 0
1300 | 0
1400 | 0
1500 | 0
1600 | 0 |  |  |  |  | 50
1700 | 0 |  |  |  |  | 70
1800 | 0 |  |  |  |  | 60
1900 | 0 |  |  |  |  | 45
2000 | 0 |  |  |  |  | 20
2100 | 0 |  |  |  |  | 15
2200 | 0
2300 | 0
2400 | 0
Spreadsheet: 126180d1319557473-find-and-replace-indirect-example
Sheet: All Data

Year | Field 1 | Field 2 | Field 3 | Field 4
2011 | Data 1 | 0.56 | 829 | 40809
2011 | Data 2 | 0.51 | 832 | 25348
2011 | Data 3 | 0.09 | 798 | 47459
2011 | Data 4 | 0.77 | 338 | 80282
2011 | Data 5 | 0.47 | 572 | 14400
2011 | Data 6 | 0.21 | 886 | 54539
2011 | Data 7 | 0.16 | 670 | 36503
2011 | Data 8 | 0.45 | 586 | 87728
2011 | Data 9 | 0.94 | 473 | 59363
2011 | Data 10 | 0.22 | 123 | 6436
2012 | Data 11 | 0.97 | 559 | 37290
2012 | Data 12 | 0.23 | 363 | 22421
2012 | Data 13 | 0.38 | 741 | 40212
2012 | Data 14 | 0.61 | 276 | 28109
2012 | Data 15 | 0.11 | 891 | 3224
2012 | Data 16 | 0.48 | 254 | 16752
2012 | Data 17 | 0.64 | 771 | 57651
2012 | Data 18 | 0.66 | 365 | 84694
2012 | Data 19 | 0.75 | 186 | 99839
2012 | Data 20 | 0.6 | 348 | 35272
2013 | Data 21 | 0.23 | 635 | 74234
2013 | Data 22 | 0.87 | 594 | 88591
2013 | Data 23 | 0.78 | 82 | 17206
2013 | Data 24 | 0.79 | 970 | 32779
2013 | Data 25 | 0.82 | 731 | 7898
2013 | Data 26 | 0.05 | 592 | 94077
2013 | Data 27 | 0.33 | 574 | 10568
2013 | Data 28 | 0.91 | 995 | 65856
2013 | Data 29 | 0.77 | 555 | 70463
2013 | Data 30 | 0.26 | 17 | 45528
Spreadsheet: 2cc1cfe0-291a-432f-8cb8-25ba7f74acc4
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16
Přehled plnění daňových výnosů Jihomoravského kraje v letech 2002 - 2007
 |  |  |  | Položka | [NAME] | ROK |  |  |  |  |  | SROVNÁNÍ
 |  |  |  |  |  | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | % | % | % | % | %
 |  |  |  |  |  | v tis. Kč | v tis. Kč | v tis. Kč | v tis. Kč | v tis. Kč | v tis. Kč | 2003/2002 | 2004/2003 | 2005/2004 | 2006/2005 | 2007/2006
 |  |  |  | 1111 | [NAME] příjmu fyzických osob [NAME] činnosti | 261650.98 | 291030.16 | 319567 | 921314.47 | 949689.9 | 1064095.2 | 111.2283852328778 | 109.805457963532 | 288.3008790018994 | 103.0798854163226 | 112.0465954202524
 |  |  |  | 1112 | [NAME] příjmu fyzických osob ze samostatné výdělečné činnosti | 38849.33 | 40233.3 | 46687 | 129226.2 | 92266.88 | 83621.08 | 103.5624037789069 | 116.0406926600602 | 276.7926831880395 | 71.39951495904083 | 90.62957368884696
 |  |  |  | 1113 | [NAME] příjmu fyzických osob z [NAME] | 19556.39 | 19539.27 | 23428 | 52155.84 | 62525.66 | 71935.91 | 99.9124582808995 | 119.9021253096968 | 222.6218200443913 | 119.8823755882371 | 115.0502209812739
 |  |  |  | 1121 | [NAME] (bez daně [NAME]) | 329729.9 | 337113.49 | 367967 | 1097159.22 | 1157253.56 | 1306011.18 | 102.2392843354515 | 109.1522620468258 | 298.1678302673881 | 105.4772670096142 | 112.854367023939
 |  |  |  | 1211 | [NAME] přidané hodnoty | 421109.7 | 507951.72 | 542394 | 1672686.6 | 1868138.6 | 1978288.33 | 120.6221846706452 | 106.7806208038827 | 308.3895839555748 | 111.6849145560202 | 105.8962290057065
 |  |  |  |  | Celkem | 1070896.3 | 1195867.94 | 1300043 | 3872542.33 | 4129874.6 | 4503951.7 | 111.6698171428923 | 108.7112511771158 | 297.8780186501523 | 106.6450473118521 | 109.0578319254536
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Graf č. 1
 |  |  |  | 2002 | 2003 | 2004 | 2005 | 2006 | 2007
 |  | [NAME] činnosti |  | 261650.98 | 291030.16 | 319567 | 921314.47 | 949689.91 | 1064095.2
 |  | [NAME] [NAME] |  | 38849.33 | 40233.3 | 46687 | 129226.2 | 92266.89 | 83621.08
 |  | DPFO - z [NAME] |  | 19556.39 | 19539.27 | 23428 | 52155.84 | 62525.65 | 71935.91
 |  | DPPO(bez daně [NAME]) |  | 329729.9 | 337113.49 | 367967 | 1097159.22 | 1157253.57 | 1306011.18
 |  | DPH |  | 421109.7 | 507951.72 | 542394 | 1672686.6 | 1868138.59 | 1978288.33
 |  | Celkem |  | 1070896.3 | 1195867.94 | 1300043 | 3872542.33 | 4129874.61 | 4503951.7
Spreadsheet: mary_fischer__25640__31W - 2001
Sheet: E31.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY 31W
RECONCILIATION OF STOCKHOLDERS' EQUITY AND INVESTMENT IN SUBS
FOR THE 6 MONTHS ENDED 6-30-2001
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-31
 |  |  |  | 12-31-00 Balance |  |  |  | EQUITY IN |  | DIVIDENDS DECLARED |  |  |  | OTHER ACTIVITY
 |  |  |  | DR  (CR) |  | RECLASS 00 NI |  | EARNINGS |  |  |  |  |  |  |  |  |  | DR  (CR)
 |  | Hyp line |  | BEG BALANCE |  | TO BEG RE |  | /LOSSES |  | COMMON |  | PREFERRED |  | DR (CR) |  | (Describe) |  | END BALANCE
Shareholders Equity by Parent |  | Reverse signs from Hyperion
Common Stock |  | 0901 |  | -40000
Paid in Capital |  | 0910
Contribution Received from Parent |  | 0915 |  | -1143428
RE - Beg Bal |  | 0920 |  | -1764000
RE - Net Income |  | 0930
RE - Net Income (Fair Value Adjustment) |  | 0931 |  |  |  |  |  | 2604
Dividends Decl - Preferred Stock |  | 0935
Dividends Decl - Common Stock |  | 0941
Invest in Subs Plug Account |  | 0942 |  |  |  |  |  | -1
Total Shareholders' Equity |  | TOT_SHARE_EQU
Net Income |  | NET_INCOME
PARENT'S CO #
Investment in Consol Sub (on Parent Books) |  |  |  | Same signs as Hyperion
Investment in CS |  | 0215
Investment in PIC (contrib by parent) |  | 0216
Investment in Equity earnings of sub |  | 0217
Total Investment in Consol Sub
Equity in Consol Sub |  | 1505
Difference between SE (on sub) and Invest (on parent)
Reasons for Differences
A schedule will need to be prepared for each subsidiary.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-31
Spreadsheet: 885645d1735456019-create-multiple-vertical-lines-programmatically-from-single-cell-sample-workbook
Sheet: Export

Subject | Start date | Start time | End Date | End Time
Days (Wed off) | 2025-02-03 00:00:00 | 07:30:00 | 2023-11-13 00:00:00 | 18:00:00
Days (Wed off) | 2025-02-04 00:00:00 | 07:30:00 | 2023-11-13 00:00:00 | 18:00:00
Days (Wed off)
Days (Wed off) | 2025-02-06 00:00:00 | 07:30:00 | 2023-11-13 00:00:00 | 18:00:00
Days (Wed off) | 2025-02-07 00:00:00 | 07:30:00 | 2023-11-13 00:00:00 | 18:00:00
Days (Wed off) | 2025-02-08 00:00:00 | 07:30:00 | 2023-11-13 00:00:00 | 18:00:00
Days (Wed off) | 2025-02-09 00:00:00 | 07:30:00 | 2023-11-13 00:00:00 | 18:00:00
Days (Fri Off) | 2025-02-10 00:00:00 | 08:30:00 | 2023-11-14 00:00:00 | 19:00:00
Days (Fri Off) | 2025-02-11 00:00:00 | 09:30:00 | 2023-11-15 00:00:00 | 20:00:00
Days (Fri Off) | 2025-02-12 00:00:00 | 10:30:00 | 2023-11-16 00:00:00 | 21:00:00
Days (Fri Off) | 2025-02-13 00:00:00 | 11:30:00 | 2023-11-17 00:00:00 | 22:00:00
Days (Fri Off)
Days (Fri Off) | 2025-02-15 00:00:00 | 13:30:00 | 2023-11-19 00:00:00 | 1900-01-01 00:00:00
Days (Fri Off) | 2025-02-16 00:00:00 | 14:30:00 | 2023-11-20 00:00:00 | 1900-01-01 01:00:00
Spreadsheet: 781657d1653469563-formula-to-get-data-horizontal-with-collumn-name-example
Sheet: Sheet1

INT | Command_macro | Command_INT | Column1 | Column2 | outcome
G1/0/1 | Other Cell data 1
G1/0/2 | Other Cell data 2
G1/0/3 | Other Cell data 3
G1/0/4 | Other Cell data 4
G1/0/5 | Other Cell data 5
G1/0/6 | Other Cell data 6
G1/0/7 | Other Cell data 7
G1/0/8 | Other Cell data 8
G1/0/9 | Other Cell data 9
G1/0/10 | Other Cell data 10
Spreadsheet: 740875d1626663417-how-to-count-progressive-unique-instances-of-a-value-across-multiple-groups-of-a-pivot-how-to-count-progressive-unique-instances-of-a-value-across-multiple-groups-of-a-pivot
Sheet: josephteh

Value |  | 1 |  |  |  |  |  |  |  | Expected Results:
 | Slot | Radios | Televisions | Phones | Computers | Lightbulbs | Total amount of unique items sold | Increase in total unique items sold |  | Total amount of unique items sold | Increase in total unique items sold
January | Week 1 | 1 | 1 |  |  |  |  |  |  |  | 2
January | Week 2 | 1 |  | 1 | 1 |  |  |  |  | 4
January | Week 3 | 1 | 1 | 1 |  |  |  |  |  | 4
January | Week 4 |  |  |  | 1 | 1 |  |  |  | 5
February | Week 1 | 1 |  |  |  |  |  |  |  | 1
February | Week 2 |  | 1 |  |  |  |  |  |  | 2
February | Week 3 |  |  | 1 |  |  |  |  |  | 3
February | Week 4 |  |  |  | 1 | 1 |  |  |  | 5
March | Week 1 | 1 | 1 |  |  |  |  |  |  | 2
March | Week 2 | 1 | 1 | 1 | 1 |  |  |  |  | 4
March | Week 3 | 1 |  |  |  |  |  |  |  | 4
March | Week 4 |  |  |  |  |  |  |  |  | 4
April | Week 1 | 1 | 1 |  |  |  |  |  |  | 2
April | Week 2 | 1 | 1 | 1 | 1 |  |  |  |  | 4
April | Week 3 | 1 |  |  |  |  |  |  |  | 4
April | Week 4 |  |  |  |  |  |  |  |  | 4
May | Week 1 | 1 |  |  |  |  |  |  |  | 1
May | Week 2 |  | 1 |  |  |  |  |  |  | 2
May | Week 3 |  |  | 1 |  |  |  |  |  | 3
May | Week 4 |  |  |  | 1 | 1 |  |  |  | 5
 | How to count progressive unique instances of a value across multiple groups of a pivot
 | [NAME] row 1 and give values of 1 to Radios, 10 to Televisions, 100 to Phones, 1000 to Computers and 10000 to Bulbs,
 | Total amount of unique items sold at cell H3: =LEN(SUBSTITUTE(SUMPRODUCT((C$3:G3)*($C$1:$G$1)*(A$3:A3=A3)),0,""))
 | Increase in total unique items sold at cell I3: =IF(A3=A2,H3-H2,H3)
Spreadsheet: 116920d1312305760-selective-columns-farthingstone
Sheet: ra

Redondo. [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAPPING
hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | points | handicap | handicap | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 18 | 36
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: 10688e21-50c7-42b3-9f2f-b7d2c537a667
Sheet: M

 | COURSES IN RED  ARE GENERAL EDUCATION COURSES FOR FALL 2012 |  | PURPLE J-TERM | GREEN BOTH FALL & J-TERM
Mathematics | AOK designation | CAR designation | Comment
MATH 105 | Natural & Mathematical Sciences-Mathematics
MATH 107 | Natural & Mathematical Sciences-Mathematics | Computing
MATH 111 | Natural & Mathematical Sciences-Math Sci other
MATH 113 | Natural & Mathematical Sciences-Math Sci other | Computing
MATH 120 | Natural & Mathematical Sciences-Mathematics
MATH 123 | Natural & Mathematical Sciences-Mathematics
MATH 131 | Natural & Mathematical Sciences-Mathematics
MATH 132 | Natural & Mathematical Sciences-Mathematics
MATH 141 | Natural & Mathematical Sciences-Mathematics | Computing
MATH 142 | Natural & Mathematical Sciences-Mathematics | Computing
MATH 203 | Natural & Mathematical Sciences-Mathematics | Computing
MATH 220 | Natural & Mathematical Sciences-Mathematics
MATH 270 |  | Experiential-Travel; Non-Western
MATH 415 |  | Capstone
MATH 470 |  | Experiential-Travel
MATH 487 |  | Experiential-Research
MATH 488 |  | Experiential-Research
Music | AOK designation | CAR designation | Comment
MUSC 101 | Arts & Literature-Arts |  | Old course MUSC 110
MUSC 110 | Arts & Literature-Arts |  | New course MUSC 101
MUSC 111 | Arts & Literature-Arts |  | New course MUSC 221
MUSC 200 | Arts & Literature-Arts | Western
MUSC 210 | Arts & Literature-Arts |  | New course MUSC 222
MUSC  211 | Arts & Literature-Arts |  | New course MUSC 321
MUSC 212 | Arts & Literature-Arts
MUSC 215 | Arts & Literature-Arts
MUSC 221 | Arts & Literature-Arts |  | Old course MUSC 111
MUSC 222 | Arts & Literature-Arts |  | Old course MUSC 210
MUSC 230 | Arts & Literature-Arts
MUSC 231 | Arts & Literature-Arts
MUSC 232 | Arts & Literature-Arts
MUSC 240 | Arts & Literature-Arts | Non-Western
MUSC 260 | Arts & Literature-Arts
MUSC 270 |  | Computing
MUSC 278 | Arts & Literature-Arts | Experiential-Travel; Experiential-Research
MUSC 301-309 | Arts & Literature-Arts |  | 3 1-hr courses with same course number
MUSC 310 | Arts & Literature-Arts |  | successfully complete MUSC 310 three times
MUSC 321 | Arts & Literature-Arts
MUSC 322 |  | Computing | Old course MUSC 371
MUSC 371 |  | Computing | old course number MUSC 270
MUSC 381 | Arts & Literature-Arts | Experiential-Travel; Western; Multidisciplinary | J-Term 2010 (Music of the Reformation)
MUSC 420 | Arts & Literature-Arts | Experiential-Research
MUSC 422 | Arts & Literature-Arts | Experiential-Research
MUSC 450 |  | Experiential-Internship
Spreadsheet: 824744d1680796693-sumifs-based-on-4-criteria-and-grouped-by-date-s666-pt-sumifs-4-criteria-grouped-by-date
Sheet: data

Product Number | Serial Number | Region Number | Date | Customer | Sales |  |  |  | Product Number | 25
89 | 70 | 45 | 2022-11-12 00:00:00 | Customer1 | 200 |  |  |  | Serial Number | 23
25 | 23 | 26 | 2022-11-13 00:00:00 | Customer1 | 308 |  |  |  | Region Number | 26
26 | 73 | 80 | 2022-11-14 00:00:00 | Customer2 | 392
78 | 71 | 97 | 2022-11-15 00:00:00 | Customer1 | 279 |  |  |  | Sum of Sales | Date
29 | 40 | 46 | 2022-11-16 00:00:00 | Customer2 | 432 |  |  |  | Customer | 2022-11-13 00:00:00 | 2022-11-14 00:00:00 | 2022-11-17 00:00:00 | 2022-11-18 00:00:00 | 2022-11-21 00:00:00 | Grand Total
25 | 23 | 26 | 2022-11-17 00:00:00 | Customer3 | 137 |  |  |  | Customer1 | 926 |  |  | 315 |  | 1241
22 | 52 | 44 | 2022-11-18 00:00:00 | Customer1 | 521 |  |  |  | Customer2 |  | 611 |  |  |  | 611
68 | 45 | 61 | 2022-11-19 00:00:00 | Customer1 | 526 |  |  |  | Customer3 |  |  | 137 |  | 636 | 773
71 | 51 | 57 | 2022-11-20 00:00:00 | Customer2 | 491 |  |  |  | Grand Total | 926 | 611 | 137 | 315 | 636 | 2625
25 | 23 | 26 | 2022-11-21 00:00:00 | Customer3 | 636
50 | 75 | 25 | 2022-11-12 00:00:00 | Customer1 | 158
25 | 23 | 26 | 2022-11-13 00:00:00 | Customer1 | 618
25 | 23 | 26 | 2022-11-14 00:00:00 | Customer2 | 611
13 | 10 | 33 | 2022-11-16 00:00:00 | Customer2 | 584
77 | 43 | 24 | 2022-11-17 00:00:00 | Customer3 | 166
25 | 23 | 26 | 2022-11-18 00:00:00 | Customer1 | 315
Spreadsheet: 768953d1645210873-conditional-formatting-based-on-amount-of-time-passed-time-cond-frmt-etaf
Sheet: Sheet8

 |  |  |  | 15sec | 1min | 5min
12:13:10
13:13:10
14:13:10
15:13:10
16:13:10
17:13:10
18:13:10
19:13:10