tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 79c77e77-5bb7-400f-935e-1e85a27f0d0d
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-02-06 09:48:07.450000
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.578 | 102.453 | 102.328 | 101.953
4.5 | 101.677 | 101.552 | 101.427 | 101.052 |  | Note: | Refer To Price [NAME]
4.375 | 100.735 | 100.61 | 100.485 | 100.11 |  |  | For all Price Adjs
4.25 | 100.142 | 100.017 | 99.892 | 99.267
4.125 | 99.343 | 99.218 | 99.093 | 98.468
4 | 98.358 | 98.233 | 98.108 | 97.483
3.875 | 97.327 | 97.202 | 97.077 | 96.452
3.75 | 96.452 | 96.327 | 96.202 | 95.577
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4 | 102.875 | 102.75 | 102.625 | 102.25
3.875 | 102.721 | 102.596 | 102.471 | 102.096
3.75 | 102.28 | 102.155 | 102.03 | 101.655
3.625 | 101.88 | 101.755 | 101.63 | 101.255
3.5 | 101.306 | 101.181 | 101.056 | 100.431
3.375 | 100.552 | 100.427 | 100.302 | 99.677
3.25 | 99.75 | 99.625 | 99.5 | 98.875 |  | 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-02-20 09:48:07.450000
30 DAY | 2014-03-07 09:48:07.450000
45 DAY | 2014-03-22 09:48:07.450000
60 DAY | 2014-04-06 09:48:07.450000
90 DAY | 2014-05-06 09:48:07.450000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 93958d1293719147-finding-the-greatest-number-excel-top-5a
Sheet: Sheet1

SOURCE | # of times as source | Top 5 Sources | #'s
[NAME]
Billy | 2
Danielle | 25
George | 69
Sara | 3
Franny
Deb | 4
[NAME] | 88
[NAME] | 591
[NAME] | 6
Carol | 17
Spreadsheet: 72185d1272901785-multiplying-total-hours-worked-by-pay-rate-to-get-total-monthly-pay-timesheet
Sheet: Sheet1

 |  |  | Time Sheet
 | Month -
 | Date | Day | From | To | Total | Comments
 | 1 | Monday | 08:30:00 | 17:30:00 | 09:00:00
 | 2 | Tuesday | 08:30:00 | 17:30:00 | 09:00:00
 | 3 | Wednesday | 08:30:00 | 17:30:00 | 09:00:00
 | 4 | Thursday | 08:30:00 | 17:30:00 | 09:00:00
 | 5 | Friday |  |  | 1900-01-01 00:00:00
 | 6 | Saturday |  |  | 1900-01-01 00:00:00
 | 7 | Sunday |  |  | 1900-01-01 00:00:00
 | 8 | Monday |  |  | 1900-01-01 00:00:00
 | 9 | Tuesday |  |  | 1900-01-01 00:00:00
 | 10 | Wednesday |  |  | 1900-01-01 00:00:00
 | 11 | Thursday |  |  | 1900-01-01 00:00:00
 | 12 | Friday |  |  | 1900-01-01 00:00:00
 | 13 | Saturday |  |  | 1900-01-01 00:00:00
 | 14 | Sunday |  |  | 1900-01-01 00:00:00
 | 15 | Monday |  |  | 1900-01-01 00:00:00
 | 16 | Tuesday |  |  | 1900-01-01 00:00:00
 | 17 | Wednesday |  |  | 1900-01-01 00:00:00
 | 18 | Thursday |  |  | 1900-01-01 00:00:00
 | 19 | Friday |  |  | 1900-01-01 00:00:00
 | 20 | Saturday |  |  | 1900-01-01 00:00:00
 | 21 | Sunday |  |  | 1900-01-01 00:00:00
 | 22 | Monday |  |  | 1900-01-01 00:00:00
 | 23 | Tuesday |  |  | 1900-01-01 00:00:00
 | 24 | Wednesday |  |  | 1900-01-01 00:00:00
 | 25 | Thursday |  |  | 1900-01-01 00:00:00
 | 26 | Friday |  |  | 1900-01-01 00:00:00
 | 27 | Saturday |  |  | 1900-01-01 00:00:00
 | 28 | Sunday |  |  | 1900-01-01 00:00:00
 | 29 | Monday |  |  | 1900-01-01 00:00:00
 | 30 | Tuesday |  |  | 1900-01-01 00:00:00
 | 31 | Wednesday |  |  | 1900-01-01 00:00:00
 |  |  | Total Hours |  | 1904-01-02 12:00:00
 | [NAME] |  | 10
 | Total paid time |  | 15
 | [NAME]
 | Total |  | 15
Spreadsheet: 66879d1267559434-excel-2007-formulae-to-count-matching-adjacent-cells-example-1-
Sheet: Sheet4

Count of number | Column Labels
Row Labels | 1 | 2 | 3 | 4 | 5 | Grand Total
A | 1 | 1 | 1 | 1 | 1 | 5
B |  |  | 1 |  |  | 1
B | 1 | 1 | 1 | 1 |  | 4
C | 2 |  |  | 1 | 2 | 5
D |  | 2 | 2 | 1 |  | 5
E | 1 | 1 |  | 1 | 1 | 4
Grand Total | 5 | 5 | 5 | 5 | 4 | 24
Spreadsheet: 219212d1362684863-match-multiple-criteria-then-select-the-smallest-value-the-lookup-value-multimatchlookupsampledata
Sheet: Sheet1

IsPro? | Price Schedule | Tier | Break Even Txns
Basic | ERP1 | 720 | 1056.842105263158
Basic | ERP1 | 1440 | 2461.978021978022
Basic | ERP1 | 3300 | 5607.058823529412
Basic | ERP1 | 7200 | 12755.55555555555
Basic | ERP1 | 14400 | 19187.23404255319
Basic | ERP1 | 24000 | 35428.57142857143
Basic | ERP1 | 48000 | 63657.89473684211
Basic | ERP1 | 96000 | 116086.2068965517
Basic | ERP1 | 144000 | 226343.75
Basic | ERP1 | 300000 | 387538.4615384615
Basic | ERP1 | 500000 | 588500
Basic | ERP1 | 750000 | 854062.5
Basic | ERP1 | 1000000 | 10000000
Basic | ERP2 | 3300 | X
Basic | ERP2 | 7200 | X
Basic | ERP2 | 14400 | X
Basic | ERP2 | 24000 | X
Basic | ERP2 | 48000 | X
Basic | ERP2 | 96000 | X
Basic | ERP2 | 144000 | X
Basic | ERP2 | 300000 | X
Basic | ERP2 | 500000 | X
Basic | ERP2 | 750000 | X
Basic | ERP2 | 1000000 | X
Basic | SDK | 180 | 270.1639344262295
Basic | SDK | 360 | 559.047619047619
Basic | SDK | 720 | 1740.689655172414
Basic | SDK | 1440 | 2440
Basic | SDK | 3300 | 4519.512195121952
Basic | SDK | 7200 | 12894.44444444445
Basic | SDK | 14400 | 21573.91304347826
Basic | SDK | 24000 | 35785.71428571428
Basic | SDK | 48000 | 60500
Basic | SDK | 96000 | 120791.6666666667
Basic | SDK | 144000 | 215000
Basic | SDK | 300000 | 375611.1111111111
Basic | SDK | 500000 | 616562.5
Basic | SDK | 750000 | 866071.4285714285
Basic | SDK | 1000000 | 1067000
Basic | SDK | 1500000 | 10000000
Pro | ERP1 | 720 | 1114.444444444444
Pro | ERP1 | 1440 | 2463.529411764706
Pro | ERP1 | 3300 | 5540.853658536585
Pro | ERP1 | 7200 | 12101.96078431373
Pro | ERP1 | 14400 | 19634.375
Pro | ERP1 | 24000 | 33444.44444444445
Pro | ERP1 | 48000 | 67957.62711864407
Pro | ERP1 | 96000 | 115860
Pro | ERP1 | 144000 | 181364.8648648649
Pro | ERP1 | 300000 | 355434.7826086957
Pro | ERP1 | 500000 | 570000
Pro | ERP1 | 750000 | 835769.2307692308
Pro | ERP1 | 1000000 | 10000000
Pro | ERP2 | 3300 | 5906.707317073171
Pro | ERP2 | 7200 | 13572.54901960784
Pro | ERP2 | 14400 | 20988.54166666667
Pro | ERP2 | 24000 | 34666.66666666666
Pro | ERP2 | 48000 | 72533.89830508475
Pro | ERP2 | 96000 | 120260
Pro | ERP2 | 144000 | 180283.7837837838
Pro | ERP2 | 300000 | 353695.652173913
Pro | ERP2 | 500000 | 569473.6842105263
Pro | ERP2 | 750000 | 845000
Pro | ERP2 | 1000000 | 10000000
Pro | SDK | 180 | 380
Pro | SDK | 360 | 724.516129032258
Pro | SDK | 720 | 1382.337662337662
Pro | SDK | 1440 | 2208.656716417911
Pro | SDK | 3300 | 5759.677419354839
Pro | SDK | 7200 | 13137.5
Pro | SDK | 14400 | 22275
Pro | SDK | 24000 | 33516.12903225806
Pro | SDK | 48000 | 65068.96551724138
Pro | SDK | 96000 | 111196.4285714286
Pro | SDK | 144000 | 181000
Pro | SDK | 300000 | 363392.8571428572
Pro | SDK | 500000 | 604772.7272727273
Pro | SDK | 750000 | 843125
Pro | SDK | 1000000 | 1187142.857142857
Pro | SDK | 1500000 | 10000000
Lookup Values: |  |  |  |  |  |  |  |  |  | row match | # of rows | result
Basic | SDK | 19304
It should return 14400 |  |  |  |  | Table above must be sorted for this to work.
 |  |  |  |  | Col A Asc, Col B Asc, Col C Asc
Spreadsheet: 144988d1331238874-excel-2007-categorizing-multiple-words-excelcakes1
Sheet: Sheet1

 |  | SC |  | NC |  | TX |  | GA |  | NY
Part | Category | date | status | date | status | date | status | date | status | date | status |  | Final Status
23 | DI | 2011-01-24 00:00:00 | approved | 2011-01-24 00:00:00 | approved | 2011-01-24 00:00:00 | approved | 2011-01-24 00:00:00 | approved | 2011-01-24 00:00:00 | approved |  | approved
3 | JT | 2011-02-01 00:00:00 | no feedback | 2011-02-01 00:00:00 | approved | 2011-02-01 00:00:00 | approved | 2011-02-01 00:00:00 | approved | 2011-02-01 00:00:00 | approved |  | no feedback
46 | JS | 2011-03-01 00:00:00 | no feedback | 2011-03-01 00:00:00 | rejected | 2011-03-01 00:00:00 | approved | 2011-03-01 00:00:00 | approved | 2011-03-01 00:00:00 | approved |  | rejected
87 | JS | 2011-01-05 00:00:00 | … | 2011-01-05 00:00:00 | … | 2011-01-05 00:00:00 | … | 2011-01-05 00:00:00 | … | 2011-01-05 00:00:00 | … |  | …
12 | DI | 2012-03-02 00:00:00 | … | 2012-03-02 00:00:00 | … | 2012-03-02 00:00:00 | … | 2012-03-02 00:00:00 | … | 2012-03-02 00:00:00 | … |  | …
61 | JS | 2011-06-04 00:00:00 | … | 2011-06-04 00:00:00 | … | 2011-06-04 00:00:00 | … | 2011-06-04 00:00:00 | … | 2011-06-04 00:00:00 | … |  | …
9 | JT | 2011-03-01 00:00:00 | … | 2011-03-01 00:00:00 | … | 2011-03-01 00:00:00 | … | 2011-03-01 00:00:00 | … | 2011-03-01 00:00:00 | … |  | …
Spreadsheet: 737052d1624075513-sum-multiple-column-based-on-multiple-criteria-book1
Sheet: Sheet1

part | date | qty | price | date | qty | price |  | date | p1 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
p1 | 2021-01-01 00:00:00 | 10 | 100 | 2021-01-10 00:00:00 | 5 | 60 |  |  | Price | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
p2 | 2020-03-05 00:00:00 | 25 | 150 |  |  |  |  |  | 2020
p3 | 2020-07-24 00:00:00 | 5 | 25 | 2021-01-15 00:00:00 | 150 | 500 |  |  | 2021 | 160
Conditions to sum prices
1) A2:A4 = J1 |  |  | + | 1) A2:A4 = J1 |  |  | +
2) column heading B1:G1 = I1 |  |  |  | 2) column heading B1:G1 = I1
3) Month of B2:B4 = K2:V2 |  |  |  | 3) Month of E2:E4 = K2:V2
4) Year of B2:B4 = J3:J4 |  |  |  | 4) Year of E2:E4 = J3:J4
5) [NAME]:D4 |  |  |  | 5) Sum G2:G4
For cell K3, I would like to sum all price matching the criteria of (Part column (A2 to A4) should be matched with J1, Column heading (B1 to G1) should match with I1, Month and year from date column (B2 to B4) should be mayched with K2 and J3 respectively, price column (D2 to D4)) + (Part column (A2 to A4) should be matched with J1, Column heading (B1 to G1) should match with I1, Month and year from date column (E2 to E4) should be mayched with K2 and J3 respectively, price column (G2 to G4))
MS Excel 2007
Spreadsheet: hunter_shively__12727__NatGasProductLists
Sheet: Central Gas Products

CENTRAL GAS TRADING PRODUCT LAUNCH SCHEDULE
 |  | Phase 1 |  |  |  | Phase 2
 | Type | Location | Period | Trader | Type | Location | Period | Trader
1 |  |  |  |  |  |  | Daily
2 |  |  |  |  |  |  | Daily
3 |  |  |  |  |  |  | Daily
4 |  |  |  |  |  |  | Prompt Month
5 |  |  |  |  |  |  | Season
6 |  |  |  |  |  |  | Prompt Month
7 |  |  |  |  |  |  | Season
8 |  |  |  |  |  |  | Prompt Month
9 |  |  |  |  |  |  | Season
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
54
55
56
57
58
59
60
61
62
63
Spreadsheet: 860458d1708538596-summing-values-from-multiple-workbooks-all-in-the-same-format-sample-7
Sheet: Room3

Project: | x
Area | Room 3
Service  Tested | Measurement | Compliance Score
General Lighting | Lux levels | 2
Ventilation | Supply air volumes | 3
Ventilation | Supply air temperature | 1
Ventilation | Humidity at normal operating conditions | 1
Ventilation | Extract air volumes | 3
Ventilation | Air changes per hour | 3
Spreadsheet: 4d8dca08-f3e4-49ff-98d6-6affcbdf22c4
Sheet: Sheet1

Adresseliste fra www.proff.no | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Bransje:Regnskapstjenester
FIRMANAVN | ADRESSE | POSTNR. | POSTSTED | TELEFON | TELEFAKS
Asker og Bærum Revisjon AS | Drengsrudbekken 4 | 1383 | Asker | 66 76 41 00
[NAME] | [NAME] | 1832 | Askim | 941 27 233
AskimConsult ANS | Skolegata 16 | 1831 | Askim | 69 88 50 30 | 69 88 50 35
Astrids Regnskapsservice AS | Kirkegata 1-3 | 0153 | Oslo | 986 03 990
Atenti AS | Telemarksgata 12 | 3724 | Skien | 35 51 92 92
Atenti AS avd Revetal | Revetalgata 9 | 3174 | Revetal | 33 09 71 71 | 33 09 71 61
Athene Registerservice AS | Sandakerveien 138 | 0484 | Oslo | 21 01 22 10 | 22 96 58 70
Athene Regnskap AS | [NAME] | 3264 | Larvik | 400 02 397
[NAME] | Borggata 1 | 0650 | Oslo | 22 04 90 50
Aurskog Regnskapskontor AS | [NAME] | 1930 | [NAME] | 63 85 38 50
Aurskog-Høland Økonomi og Rådgivning | [NAME] 15 | 1940 | Bjørkelangen | 480 65 592
[NAME] | Gamle Trysilveg 4 | 2406 | Elverum | 905 43 636
Avant Økonomi AS | Landfalløya 7 | 3023 | Drammen | 32 82 55 40
Avil DA | Gange-Rolvs gate 6B | 0273 | Oslo | 484 04 486
Axepta Regnskap AS | Dikev. 50 | 1661 | Rolvsøy | 69 33 91 00 | 69 33 91 19
Axera Business Management AS | Haakon VII's gate 6 | 0161 | Oslo | 23 23 98 70 | 23 23 98 71
Aztek Økonomi AS | Ryggeraet 49 | 1580 | Rygge | 906 68 709
B-S Regnskap AS | Stasjonsveien 49 | 1940 | Bjørkelangen | 952 59 022
B.I. Regnskapsservice AS | Kirkeveien 213 | 3140 | Nøtterøy | 950 98 843
BBK Regnskap og [NAME] | [NAME] vei 35 | 0668 | Oslo | 23 17 33 30
BDT Viken Regnskap AS | Hoffsveien 15 | 0275 | Oslo | 22 06 42 40
BDT Viken Regnskap AS | Welhavens gate 2B | 1530 | Moss | 69 20 67 20
BE Data Regnskap Elverhøy | Haresvingen 10A | 1914 | [NAME] | 64 92 51 10
BHL Services AS | Billingstadsletta 19A | 1396 | Billingstad | 66 85 59 00
BK Regnskap AS | Kirkegata 3 | 2317 | Hamar | 400 08 073
Trenger du oppdaterte adresselister til DM /TM? [NAME] (www.forvalt.no) tilbyr ett segmenterings- og uttekksverktøy hvor du [NAME] frem til din målgruppe og eksportere lister til Excel. Du kan gjøre oppslag så ofte du vil, med en begrensning på 3500 selskap per søk. Våre telefonnummere er hentet fra Telefonkatalogen og [NAME].  Med segmenteringsverktøy kan du: - Hente ut adresseliste før en DM utsendelse - Lage ringelister - Hente ut bransjestatistikker - Oppdatere din kundedatabase  Se http://forvalt.no/segmenteringsverktoy/
Spreadsheet: 207566d1358496587-matching-columns-predicament-predicament-attachment
Sheet: Sheet1

User Name | name1 |  | Personnel No. | [NAME]
ZE55395 | Rosemary Adolfo |  | 5834 | [NAME]
ZE7462194 | Mushosho Adonia |  | 2624 | [NAME]
ZE7462194 | Ushendibaba Adonis T |  | 1606 | Gabrial Antipas
[NAME] | [NAME] |  | 5835 | [NAME]
ZE55115 | Gabrial Antipas |  | 6770 | [NAME]
ZE55042 | [NAME] |  | 2522 | Mushosho Adonia
ZE222496 | [NAME] |  | 2733 | Ushendibaba Adonis T
ZE243647 | [NAME] |  | 6683 | Rosemary Adolfo
 | The result should look like this
Spreadsheet: 287199d1388693569-staff-scheduler-schedule
Sheet: Sheet1

 | Interval | 2014-01-01 00:00:00 |  | 2014-01-02 00:00:00 |  | 2014-01-03 00:00:00 |  | 2014-01-04 00:00:00 |  | 2014-01-05 00:00:00 |  | 2014-01-06 00:00:00 |  | 2014-01-07 00:00:00 |  | 2014-01-08 00:00:00 |  | 2014-01-09 00:00:00 |  | 2014-01-10 00:00:00 |  | 2014-01-11 00:00:00 |  | 2014-01-12 00:00:00 |  | 2014-01-13 00:00:00 |  | 2014-01-14 00:00:00 |  | 2014-01-15 00:00:00 |  | 2014-01-16 00:00:00 |  | 2014-01-17 00:00:00 |  | 2014-01-18 00:00:00 |  | 2014-01-19 00:00:00 |  | 2014-01-20 00:00:00 |  | 2014-01-21 00:00:00 |  | 2014-01-22 00:00:00 |  | 2014-01-23 00:00:00 |  | 2014-01-24 00:00:00 |  | 2014-01-25 00:00:00 |  | 2014-01-26 00:00:00 |  | 2014-01-27 00:00:00 |  | 2014-01-28 00:00:00 |  | 2014-01-29 00:00:00 |  | 2014-01-30 00:00:00 |  | 2014-01-31 00:00:00
 | 00:00:00
 | 01:00:00
 | 02:00:00
 | 03:00:00
 | 04:00:00
 | 05:00:00
 | 06:00:00
 | 07:00:00
 | 08:00:00
 | 09:00:00
 | 10:00:00
 | 11:00:00
 | 12:00:00
 | 13:00:00
 | 14:00:00
 | 15:00:00
 | 16:00:00
 | 17:00:00
 | 18:00:00
 | 19:00:00
 | 20:00:00
 | 21:00:00
 | 22:00:00
 | 23:00:00
Spreadsheet: 805680d1668829233-search-tab-for-specific-text-then-offset-from-the-cell-containing-that-text-example
Sheet: Fund 1

 | Transaction Links | Dates | 2022-12-31 00:00:00
 |  | Data Item #1 | 0 | 7.897033991517565 | 0 | 6.013480804520922 | 0 | 4.53544394332155 | 0 | 3.431886901881908
 |  | Data Item #2 | 22.43017550062175 | 0 | 173.8117556586841 | 0 | 202.6633774997705 | 0 | 267.6713243095267 | 0
 |  | Data Item #3 | 8.485899289745902 | -0.1362003731834112 | 57.63091617980378 | -0.06897445300892191 | 73.80052705637746 | -2.20400153396699 | 96.91867028270889 | -0.4353141557889346
 |  | Data Item #4 | 0.9926080509970963 | -0.07056994952756433 | 6.849465590579263 | -0.05373802839342566 | 8.968512089571465 | -0.35951927333282 | 11.78152681095504 | -0.09446610722979704
Spreadsheet: 757254d1638162492-i-need-some-help-on-sum-a-criteria-with-a-specific-name-book1
Sheet: Contas a Pagar

Data da Factura | Fornecedor | Discricao | N° Documento | [NAME] | Valor | Data de Pagamento | Status |  | Realçar
2020-02-20 00:00:00 | [NAME] |  | 15968 | Boleto | 1500 |  |  |  | Pago
2020-02-25 00:00:00 | Camila |  | 19536 | Duplicata | 1950 | 2020-02-17 00:00:00
2020-02-15 00:00:00 | [NAME] |  | 16846 | NF | 150
2020-02-15 00:00:00 | João |  | 14964 | NF | 950 | 2021-02-15 00:00:00
2020-01-30 00:00:00 | Camila |  | 19536 | Duplicata | -950 | 2020-01-11 00:00:00
2020-02-15 00:00:00 | Lira |  | 315514 | Duplicata | 50000
 | camila |  | i need total of positive values of camila on that table
 | camila |  | i need total of negative values of camila on that table
Spreadsheet: 111029d1307544945-more-than-2-options-for-if-statement-budget-sheet
Sheet: Sheet1

ProjectID | Sourcefile Reference | Functional Category | Facility / Project / Organization | Line Item | x | x | x | x | Purpose/Comments | x | FY12 Requested Amount ($) | x | x | x | x | x | x | x | x | x | Planned Amount ($) | Approve Line Item? | Approved Amount ($)
0101 | x | x | x | x | x |  |  |  | x |  | 1800000 |  |  |  |  |  |  | x | x | x |  | NO
0102 | x | x | x | x | x |  |  |  | x |  | 1910000 |  |  |  |  |  |  | x | x | x |  | VARIATION
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | VARIATION
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NO
Spreadsheet: 424357d1444668059-count-consecutive-cells-with-same-value-example3
Sheet: Sheet1

 | 1994 | 1995 | 1996 | 1997 | 1998 | 1999 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 |  | Consecutive Years
Customer 1 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 0
Customer 2 | 3 | 3 | 3 | 3 | 3 | 0
Customer 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
Customer 4 | 3 | 0
Customer 5 | 3 | 3 | 3 | 3 | 0 |  | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
Customer 6 | 3 | 3 | 0
Customer 7 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 0 |  |  |  | 3 | 3 | 3 | 3 | 3
Customer 8 | 3 | 3 | 3 | 3 | 0
Customer 9 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 0
Customer 10 |  |  | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
Spreadsheet: 218600d1362506092-extract-day-from-date-returning-month-instead-of-day-date
Sheet: Sheet1

 |  |  |  | Today's Date is March 5, 2013 |  |  | "=Day(G4)"
 |  |  | Custom | Format is mm/dd/yyyy |  | 2013-05-03 00:00:00 |  | This should be 5
 |  |  | Custom | Format is dd/mm/yyyy |  | 2013-05-03 00:00:00 |  | This should be 5
 |  |  | Date | Format is 3/14/2013 |  | 2013-05-03 00:00:00 |  | This should be 5
 |  |  |  | Todays Date is March 14, 2013
 |  |  | Custom | Format is mm/dd/yyyy |  | 03/14/2013
 |  |  | Custom | Format is dd/mm/yyyy |  | 2013-03-14 00:00:00 |  | Correct
 |  |  | Date | Format is 3/14/2013 |  | 03/14/2013
Spreadsheet: 807499d1669918808-problem-with-data-validation-after-clicking-an-optian-in-a-dependent-dropdown-list-sample-sheet-1-
Sheet: Doelstellingen per opleiding

NT1 |  | NT1 |  |  |  |  | [NAME]
ALFA NT2
 |  | Doelstelling | Shortened | Uit module | [NAME] |  | Doelstelling | Module | [NAME] | Onderdeel
 |  | Functioneren Spelling - ET 058 - spellen door een klankzuiver woord in zijn samenstellende klanken te [NAME] [NAME] toe te passen, met name woorden [NAME] het het type mk, km, mkm, mmkm, mkmm, mmkmm, behalve woorden van vreemde oorsprong, woorden met woordtekens |  | Functioneren Spelling | Schrijven zins- en woordfocus |  | BC 001  -  een goede schrijfhouding aannemen | LSV1 | [NAME] schrijven | motoriek
 |  | Functioneren schriftelijk 05 - ET 059 - tweeledig samengestelde woorden correct spellen, [NAME] [NAME], behalve woorden van vreemde oorsprong en woorden met woordtekens |  | Functioneren schriftelijk 05 | Schrijven zins- en woordfocus |  | BC 002  -  een schrijfmotoriek ontwikkelen | LSV2 | [NAME] schrijven | motoriek
 |  | Functioneren schriftelijk 06 - ET 060 - woorden correct spellen volgens het fonetische principe, behalve woorden van vreemde oorsprong en woorden met woordtekens |  | Functioneren schriftelijk 06 | Schrijven zins- en woordfocus |  | BC 003  -  auditief woorden identificeren | LSV1 | [NAME] schrijven | auditieve voorwaarden
 |  | Functioneren schriftelijk 06 - ET 061 - basisinterpunctie toepassen, met name punt, vraagteken, uitroepteken en komma |  | Functioneren schriftelijk 06 | Schrijven zins- en woordfocus |  | BC 004  -  auditief [NAME] identificeren | LSV2 | [NAME] schrijven | auditieve voorwaarden
 |  | Functioneren schriftelijk 05 - ET 062 - hoofdletters gebruiken in eigennamen, plaatsnamen en aan het [NAME] |  | Functioneren schriftelijk 05 | Schrijven zins- en woordfocus |  | BC 005  -  auditief [NAME] | LSV1 | [NAME] schrijven | auditieve voorwaarden
 |  | Functioneren schriftelijk 06 - ET 063 - getallen tot 4 cijfers correct in cijfers schrijven |  | Functioneren schriftelijk 06 | Schrijven zins- en woordfocus |  | BC 006  -  auditief [NAME] | LSV2 | [NAME] schrijven | auditieve voorwaarden
 |  | Functioneren schriftelijk 05 - ET 064 - een herkenbare structuur aanbrengen in een cijferreeks, zoals in een rekeningnummer, in een datum, in een telefoonnummer |  | Functioneren schriftelijk 05 | Schrijven zins- en woordfocus |  | BC 007  -  auditief woorden in [NAME] | LSV1 | [NAME] schrijven | auditieve voorwaarden
 |  | Functioneren Digitale teksten - ET 065 - hulpbronnen gebruiken, zoals een eenvoudige spellinggids |  | Functioneren Digitale teksten | Schrijven zins- en woordfocus |  | BC 008  -  auditief woorden in klanken analyseren | LSV2 | [NAME] schrijven | auditieve voorwaarden
 |  | Functioneren schriftelijk 06 - ET 065 - hulpbronnen gebruiken, zoals een eenvoudige spellinggids |  | Functioneren schriftelijk 06 | Schrijven zins- en woordfocus |  | BC 009  -  auditief klankgroepen tot woorden synthetiseren | LSV1 | [NAME] schrijven | auditieve voorwaarden
Spreadsheet: 141940d1329521589-creating-a-conditional-list-with-multiple-factors-and-sources-amenity1
Sheet: Shopping List (IRD only)

Shopping List - For IRD Colleagues ONLY - Do Not Edit
[NAME] |  | Quantity |  | IRD | Quantity
 |  |  |  | Get Well
 |  |  |  | Night [NAME]
 |  |  |  | Beer & Nuts
 |  |  |  | Movie Night
 |  |  |  | Bees Knees
 |  |  |  | [NAME]
 |  |  |  | Floral Arrangement
 |  |  |  | Small Evian
 |  |  |  | Large Evian
 |  |  |  | Small Badoit
 |  |  |  | Large Badoit
Custom Amenity |  |  |  | MH Chardonnay
 |  |  |  | Blasted Church Pinot Gris
W1 | Fruit in Season |  |  | Road 13 Pinot Noir
[NAME] | [NAME] |  |  | Quails Gate Cabernet Sauvignon
W3 | [NAME] |  |  | 1/2 btl Lake Breeze Pinot Blanc
W4 | Chocolate Delight |  |  | 1/2 btl Lake Breeze Merlot
W5 | Cheese & Grapes |  |  | Sumac Ridge Stellars [NAME]
W6 | Surprise Me! |  |  | Moet & Chandon Brut Champagne