tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 780321d1652384099-conditional-formating-based-on-with-adjecent-coloumn-cf-pivot-table-aligw
Sheet: Sheet2

AAA | BBB | CCC
A | 1 | 2
A | 1 | 1
A | 3 | 1
B | 5 | 3
B | 5 | 3
C | 10 | 1
C | 5 | 1
D | 10 | 1
D | 10 | 19
Spreadsheet: 813671d1673916827-identifying-text-and-sorting-data-accordingly-text_finden_2
Sheet: Tabelle1

Anlieferung 1 |  |  |  | [NAME] |  |  |  | Anlieferung 3 |  |  |  | [NAME] |  |  |  | Anlieferung 5 |  |  |  | Anlieferung 6 |  |  |  |  |  | Freude | B | C | D | E | F
 |  |  | 10 |  |  |  | 15 |  |  |  | 23 |  |  |  | 41 |  |  |  | 7 |  |  |  | 19
Task:
If a cell A1 to X1 contains e.g. text "Anlieferung Freude", then output to column "Freude" Output cell AA2 = A11 to X11
Example:
Cell E1 contains "[NAME]", then the number from H11 (the count is always 3 collums to the right ) needs to be the output in the "Freude" column (cell AA1) in cell AA2.
If, on the other hand, "[NAME]" is in M1, the value of P11 would of course have to be output in the "Freude" column (cell AA1) in cell AA2.
Solution approach: |  | see cell AA2
Spreadsheet: 255d1d53-7ccd-4a35-bf07-699b18e73cc7
Sheet: 15c

 | Swap Dealers/MSPs4 |  | Others
Product1 | Cleared2 | Uncleared | Cleared | Uncleared
Index Tranche | 0 | 139 | 0 | 99
Index/OTHER* | 252041 | 8414 | 220031 | 6362
TOTAL | 252041 | 8553 | 220031 | 6461
*OTHER variable includes exotic credit products, swaptions, and total return swaps.
Spreadsheet: 713950d1611027919-if-date-matches-one-of-the-dates-in-the-row-use-the-data-in-the-corresponding-column-sample-1-
Sheet: Analysis

Delay Date Input | 2021-01-18 00:00:00 |  | 12
Date | List of equipment | Shift Change | Handover | Pre Start | Refuelling | Crib | Positioning | Unplanned maintenace | Planned maintenance | Total | data from column matching B1 | sum of hours up to date in B1 | Comments
2021-01-18 00:00:00 | A
2021-01-18 00:00:00 | B
2021-01-18 00:00:00 | C |  |  | 0.5 |  | 0.5 |  | 4
2021-01-18 00:00:00 | D
2021-01-18 00:00:00 | E
2021-01-18 00:00:00 | F
2021-01-18 00:00:00 | G
2021-01-18 00:00:00 | H
2021-01-18 00:00:00 | I
2021-01-18 00:00:00 | J
2021-01-18 00:00:00 | K
Spreadsheet: 469690d1468064993-working-with-tables-in-powerpivot-copy-of-book1-prc
Sheet: Sheet1

Claim | Amount | Date |  | Claim |  |  |  | Date
1 | 40 | 2014-01-01 00:00:00 |  | 1 |  |  |  | 2014-01-01 00:00:00
1 | 40 | 2014-01-01 00:00:00 |  | 2 |  |  |  | 2014-01-02 00:00:00
1 | 22 | 2014-01-01 00:00:00 |  | 3 |  |  |  | 2014-01-03 00:00:00
2 | 30 | 2014-01-02 00:00:00
2 | 16 | 2014-01-02 00:00:00
2 | 30 | 2014-01-02 00:00:00 |  | Claim |  |  |  | Date
3 | 22 | 2014-01-03 00:00:00 |  | 1 |  |  |  | 2014-01-01 00:00:00
3 | 22 | 2014-01-03 00:00:00 |  | 2 |  |  |  | 2014-01-02 00:00:00
3 | 22 | 2014-01-03 00:00:00 |  | 3 |  |  |  | 2014-01-03 00:00:00
4 | 22 | 2014-01-04 00:00:00 |  | 4 |  |  |  | 2014-01-04 00:00:00
5 | 22 | 2014-01-05 00:00:00 |  | 5 |  |  |  | 2014-01-05 00:00:00
6 | 22 | 2014-01-06 00:00:00 |  | 6 |  |  |  | 2014-01-06 00:00:00
7 | 22 | 2014-01-07 00:00:00 |  | 7 |  |  |  | 2014-01-07 00:00:00
8 | 22 | 2014-01-08 00:00:00 |  | 8 |  |  |  | 2014-01-08 00:00:00
 |  |  |  | Grand Total |  |  |  | Grand Total
Spreadsheet: 700271d1603107405-sorting-mixed-list-into-two-separate-lists-index-small-if-example-2
Sheet: Desired Output

 | Employee 1 |  |  | Employee 2
 | Employee 3 |  |  | Employee 4
 | Employee 5 |  |  | Employee 6
 | Employee 7 |  |  | Employee 8
 | Employee 9 |  |  | Employee 10
 | Employee 11 |  |  | Employee 12
 | Employee 13 |  |  | Employee 14
 | Employee 15 |  |  | Employee 16
 | Employee 17 |  |  | Employee 18
 | Employee 19 |  |  | Employee 20
 | Employee 21 |  |  | Employee 22
 | Employee 23 |  |  | Employee 24
 | Employee 25 |  |  | Employee 26
 | Employee 27 |  |  | Employee 28
 | Employee 29 |  |  | Employee 30
 | Employee 31 |  |  | Employee 32
 | Employee 33 |  |  | Employee 34
 | Employee 35 |  |  | Employee 36
 | Employee 37 |  |  | Employee 38
 | Employee 39 |  |  | Employee 40
 | Employee 41 |  |  | Employee 42
 | Employee 43 |  |  | Employee 44
 | Employee 45 |  |  | Employee 46
 | Employee 47 |  |  | Employee 48
 | Employee 49 |  |  | Employee 50
Spreadsheet: 136316d1326535233-unable-to-calculate-highlighted-cells-sum_by_color
Sheet: Sheet1

 | Annual | Sick | Hours | Type | Hours | Type | Hours | Type | Hours | Type | Hours | Type | Hours | Type
[NAME] | 10 |  | 5 | A | 2 | S | 10 |  |  |  |  |  |  |  | 7
[NAME] | 10 |  | 4 | A | 5 | B | 10 |  |  |  |  |  |  |  | 10
[NAME] | -1 |  | 4 | A | 5 | B | -1 |  |  |  |  |  |  |  | -1
Spreadsheet: 94979d1294706468-make-a-calendar-with-noted-birthdays-etc-my2011-25
Sheet: w1

2010-12-27 00:00:00 |  |  |  |  |  | Anniversaries
 |  |  |  |  |  | Sam & Betty wed | 2004-01-07 00:00:00
 |  |  |  |  |  | Mel & Ann wed | 1987-02-05 00:00:00
 |  |  |  |  |  | Tom & Sis wed | 1978-05-12 00:00:00
This is 5 and 1/2 inches wide
So, that would be one page that is 11 inches (landscape mode).
Rows 1 thru 38 will total 8 and 1/2 inches high...  Printing 2 pages (2 weeks) on one standard sheet of paper.
For this discussion, we'll ignore the printer margin requirements.  I can figure that out later.
Spreadsheet: 744401d1629218637-count-unique-within-table-book1
Sheet: Sheet1

Location | User |  |  |  | Summary Table
Place A | User1
Place A | User1 |  |  |  | Location | Total Entries | [NAME] | What I want it to say | Column1
Place A | User1 |  |  |  | Place A
Place A | User2 |  |  |  | Place B
Place A | User2 |  |  |  | Place C
Place B | User3
Place B | User3
Place B | User3
Place B | User3
Place C | User4
Place C | User4
Place C | [NAME]
Spreadsheet: 598697d1542658969-rag-rate-student-data-based-on-their-score-from-a-range-of-data-student-data-worksheet
Sheet: STUDENT DATA

Centre No. 15251 |  | Mock [NAME] |  |  |  |  |  | Mock [NAME] |  |  |  |  |  |  | Comp. 2 |  |  | Comp. 1 |  |  |  | [NAME].
Name | MEGs | Q1 | Q2 | Q3 | Q4 | Q5 | Total | Q1 | Q2 | Q3 | Q4 | Q5 | Total | TOTAL | TL | MOD | Total | TL | MOD | Total | TOTAL | TL | MOD | Total
student 1 | 9 | 3 | 3 | 2 | 6 | 21
student 2 | 9 | 4 | 3 | 3 | 6 | 24
student 3 | 9 | 4 | 3 | 2 | 7 | 19
student 4 | 6 | 4 | 6 | 5 | 4 | 27
student 5 | 9 | 3 | 3 | 2 | 8 | 17
student 6 | 9 | 4 | 3 | 3 | 6 | 24
student 7 | 9 | 3 | 2 | 2 | 6 | 20
student 8 | 3 | 4 | 2 | 2 | 6 | 23
student 9 | 2 |  | 6 | 2 | 13 | 27
student 10 | 6 | 4
student 11 | 8 | 3 | 2 | 1 | 6 | 22
student 12 | 2 | 4 | 3 | 3 | 7 | 25
student 13 | 5 | 4 | 7 | 4 | 15 | 32
student 14 | 2 | 4 | 3 | 3 | 8 | 24
student 15 | 3 | 3 | 4 | 4 | 13 | 24
student 16 | 3 | 4 | 3 | 3 | 11 | 23
student 17 | 4 | 3 | 6 | 1 | 15 | 26
student 18 | 4 | 4 | 5 | 5 | 13 | 27
student 19 | 5 | 4 | 4 | 3 | 6 | 26
student 20 | 9 | 3 | 8 | 5 | 16 | 30
student 21 | 6 | 4 | 6 | 4 | 15 | 24
student 22 | 8 | 4 | 2 | 3 | 6 | 21
student 23 | 8 | 4 | 3 | 3 | 13 | 26
student 24 | 8 | 4 | 3 | 2 | 7 | 17
student 25 | 8 | 3 | 7 | 5 | 15 | 34
student 26 | 7 | 4 | 4 | 3 | 7 | 26
student 27 | 5 | 3 | 3 | 3 | 7 | 25
student 28 | 6 | 4 | 2 | 2 | 8 | 19
student 29 | 9 | 4 | 3 | 3 | 12 | 27
student 30 | 4 | 4 | 5 | 3 | 9 | 16
student 31 | 3 | 4 | 3 | 1 | 5 | 0
student 32 | 2 | 4 | 5 | 4 | 9 | 28
student 33 | 6 | 3 | 6 | 2 | 14 | 27
student 34 | 4 | 4 | 2 | 2 | 8 | 23
student 35 | 7 | 0 | 1 | 1 | 6 | 20
Spreadsheet: 263501d1378493485-excel-beginner-formula-help-needed-ks3-tracking
Sheet: Summary

Level | Number of Pupils | % of Pupils | Girls | % Girls | Boys | % Boys
3 | 1 | 0.008620689655172414 | 0 | 0 | 1 | 0.01515151515151515
4 | 0 | 0 | 0 | 0 | 0 | 0
5 | 0 | 0 | 0 | 0 | 0 | 0
6 | 0 | 0 | 0 | 0 | 0 | 0
Level | SEN | % of Pupils |  | Level | FSM/PP | % of Pupils
3 | #N/A |  |  | 3 | #N/A
4 | #N/A |  |  | 4 | #N/A
5 | #N/A |  |  | 5 | #N/A
6 | #N/A |  |  | 6 | #N/A
Level | G&T | % of Pupils
3 | #N/A
4 | #N/A
5 | #N/A
6 | #N/A
Level | Number of Pupils | % of Pupils | Girls | % Girls | Boys | % Boys
3 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
4 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
5 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
6 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
7 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Level | SEN | % of Pupils |  | Level | FSM/PP | % of Pupils
3 | #N/A |  |  | 3 | #N/A
4 | #N/A |  |  | 4 | #N/A
5 | #N/A |  |  | 5 | #N/A
6 | #N/A |  |  | 6 | #N/A
7 | #N/A |  |  | 7 | #N/A
Level | G&T | % of Pupils
3 | #N/A
4 | #N/A
5 | #N/A
6 | #N/A
7 | #N/A
Level | Number of Pupils | % of Pupils | Girls | % Girls | Boys | % Boys
3 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
4 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
5 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
6 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
7 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
8 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Level | SEN | % of Pupils |  | Level | FSM/PP | % of Pupils
3 | #N/A |  |  | 3 | #N/A
4 | #N/A |  |  | 4 | #N/A
5 | #N/A |  |  | 5 | #N/A
6 | #N/A |  |  | 6 | #N/A
7 | #N/A |  |  | 7 | #N/A
8 | #N/A |  |  | 8 | #N/A
Level | G&T | % of Pupils
3 | #N/A
4 | #N/A
5 | #N/A
6 | #N/A
7 | #N/A
8 | #N/A
Spreadsheet: 30beda4a-16ca-4242-b0b0-c9ba4138e3e0
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: |  |  | 2012-02-09 09:19:56.850000
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.25 | 102.082 | 101.957 | 101.832 | 101.457 |  | and are added to price quote
4.125 | 101.683 | 101.558 | 101.433 | 101.058
4 | 101.236 | 101.111 | 100.986 | 100.611 |  | Note: | Refer To Price [NAME]
3.875 | 100.414 | 100.289 | 100.164 | 99.789 |  |  | For all Price Adjs
3.75 | 99.436 | 99.311 | 99.186 | 98.561
3.625 | 98.983 | 98.858 | 98.733 | 98.108
3.5 | 98.478 | 98.353 | 98.228 | 97.603
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.625 | 101.901 | 101.776 | 101.651 | 101.276
3.5 | 101.561 | 101.436 | 101.311 | 100.936
3.375 | 101.03 | 100.905 | 100.78 | 100.405
3.25 | 100.4 | 100.275 | 100.15 | 99.775
3.125 | 99.634 | 99.509 | 99.384 | 98.759
3 | 99.291 | 99.166 | 99.041 | 98.416
2.875 | 98.731 | 98.606 | 98.481 | 97.856 |  | 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 | 2012-02-23 09:19:56.850000
30 DAY | 2012-03-09 09:19:56.850000
45 DAY | 2012-03-24 09:19:56.850000
60 DAY | 2012-04-08 09:19:56.850000
90 DAY | 2012-05-08 09:19:56.850000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 315c579e-0aa6-4b9e-a61c-489e13aef93b
Sheet: Sheet1

Adresseliste fra www.proff.no | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
[NAME]:Murere
FIRMANAVN | ADRESSE | POSTNR. | POSTSTED | TELEFON | TELEFAKS
Kristensen & Linløkken | Langnesv. 18 | 9408 | Harstad | 482 49 470
Mur & Flis Geir F Toftaker | Takelvdalen | 9321 | Moen | 915 35 903
Mur & Malerteknikk AS | Markv. 11 | 8402 | Sortland | 977 04 420
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: 884191d1733251911-lookup-formula-that-will-return-a-value-depending-on-the-value-of-a-cell-in-another-column-fruit-shop
Sheet: Sheet1

Table 1 |  |  |  |  | Table 2 |  |  |  | Table 3
Fruit | Store | True/False |  |  | Fruit | Store |  |  | Fruit | Store | True/False
[NAME] |  | 1 |  |  | [NAME] | Riverview |  |  | [NAME] | Thornside | 0
Orange |  | 1 |  |  | Orange | Hitchfield |  |  | [NAME] | Plaize | 1
Apple |  | 1 |  |  | Apple | Green Hill |  |  | Pear | Murchland | 0
[NAME] |  | 0 |  |  | [NAME] |  |  |  | Pear | [NAME] | 1
[NAME] |  | 1 |  |  | Pear
Pear |  | 0 |  |  | Pomegranate | Sandford
Pomegranate |  | 1 |  |  | Blueberry | Yard End
Blueberry |  | 1
Expected Answer
Fruit | Store | True/False
[NAME] | Riverview | 1
Orange | Hitchfield | 1
Apple | Green Hill | 1
[NAME] | Thornside | 0
[NAME] | Plaize | 1
Pear | Murchland | 0
Pomegranate | Sandford | 1
Blueberry | Yard End | 1
Spreadsheet: 454015d1459589119-aging-payable-problem-aging-problem
Sheet: Aging

NOTE: | In my organization payments are made to vendoer on random basis.It means payment made to vendor on the basis of their ledger balance and not paid against indiviual invoice.But I want to calculate aging of payable based on invoice date.Below is my working kindly solve my question or suggest me some alternative solution
Custome Invoices |  |  |  |  |  |  |  |  |  | Payment detail of customer
Helping | Date | [NAME] | Amount | Next Invoice Date | Payment [NAME] | Invoice Balance | Question |  |  | Date | Vender Name | Amount
 | 2016-03-01 00:00:00 | Kamran | 5000 |  |  |  | Is this 2000 is cleared in next payments which are made to this vendor  .For this I assume if  any invoice shows a negative balance equal to or greater than 2000 in "Invoice  Balance " collumn  against this customer then that amount should also be deducted from this due balance and net amount should be appeared in collumn K so in my aging report only actual outstanding balance should be appeared against this slip |  |  | 2016-03-15 00:00:00 | Kamran | 2000
 |  | ehsan |  |  |  |  |  |  |  |  | ehsan
 |  | irfan |  |  |  |  |  |  |  |  | irfan
 |  | zeeshan |  |  |  |  |  |  |  |  | zeeshan
 |  | farhan |  |  |  |  |  |  |  |  | farhan
 |  | guddu |  |  |  |  |  |  |  |  | guddu
 |  | Kamran | 30000 |  |  |  |  |  |  | 2016-03-18 00:00:00 | Kamran | 1000
 |  | ehsan |  |  |  |  |  |  |  |  | ehsan
 |  | irfan |  |  |  |  |  |  |  |  | irfan
 |  | zeeshan |  |  |  |  |  |  |  |  | zeeshan
 |  | farhan |  |  |  |  |  |  |  |  | farhan
 |  | guddu |  |  |  |  |  |  |  |  | guddu
 | 2016-04-04 00:00:00 | Kamran |  |  |  |  |  |  |  | 2016-04-03 00:00:00 | Kamran | 32000
 |  | ehsan |  |  |  |  |  |  |  |  | ehsan
 |  | irfan |  |  |  |  |  |  |  |  | irfan
 |  | zeeshan |  |  |  |  |  |  |  |  | zeeshan
 |  | farhan |  |  |  |  |  |  |  |  | farhan
Spreadsheet: 51170d1250711117-help-on-a-work-schedule-696372-help-on-a-work-schedule
Sheet: Week 2

 | Sat |  | Sun |  | Mon |  | [NAME] |  | Wed |  | Thur |  | Fri
 | 2009-08-08 00:00:00 |  | 2009-08-09 00:00:00 |  | 2009-08-10 00:00:00 |  | 2009-08-11 00:00:00 |  | 2009-08-12 00:00:00 |  | 2009-08-13 00:00:00 |  | 2009-08-14 00:00:00 |  | Wk Total
Bqt. Food |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Room Rental |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Bqt. Beverage |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
AV |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Est. Service Charge |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
Daily Est. Rev. | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ttl Hrs | Pay rate | Ttl Wages
[NAME] | 12p | 8 | 7a | 8 | OFF |  | 7a | 8 | OFF |  | 7a | 8 | 7a | 8 | 40 | 16.83 | 673.1999999999999
 | 8p |  | 3p |  |  |  | 3p |  |  |  | 3p |  | 3p
Zane | 2p | 8 | OFF |  | 3p | 8 | OFF |  | OFF |  | 10a | 8 | 3p | 8 | 32 | 9.75 | 312
 | 10p |  |  |  | 11p |  |  |  |  |  | 6p |  | 11p
Cassidy | 2p | 8 | OFF |  |  |  | OFF |  | 4:30p | 5.5 | 10a |  | 3p | 8 | 21.5 | 8.25 | #N/A
 | 10p |  |  |  |  |  |  |  | Server |  | 6p |  | 11p
[NAME] | 12p | 8 | OFF |  | OFF |  | 4p | 6 | 7a | 8 | 10a | 8 | 7a | 8 | 38 | 7.05 | 151.575
 | 8p |  |  |  |  |  | [NAME] |  | 3p |  | 6p |  | 3p
Amber | 3p | 8 | 4:30p | 5.5 | 4:30p | 5.5 | OFF |  | OFF |  | 10a | 8 | OFF |  | 27 | 7.05 | 267.9
 | 11p |  | Server |  | Server |  |  |  |  |  | 6p
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 7.05 | 190.35
[NAME] | 4p | 6 | 4p | 6 | 4p | 6 | 3p | 6 | OFF |  | 4Pm |  | 4p |  | 24 | 7.05 | 0
 | Bartender |  | Bartender |  | Bartender |  | Bartender |  |  |  | Bartender |  | Bartender
[NAME] | 4:30p | 5.5 | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | OFF |  | OFF |  | 5.5 | 7.05 | 169.2
 | Server
[NAME] | OFF |  | OFF |  | OFF |  | 4:30p | 5.5 | 4p | 6 | OFF |  | OFF | 6 | 17.5 | 7.05 | 38.775
 |  |  |  |  |  |  | Server |  | Bartender
[NAME] | 4p | 6 |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 7.05 | 123.375
 | Training
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 7.05 | 42.3
Express Temps |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 10.5 | 0
Labor Finder Temps |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 10.42 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 211.5 |  | #N/A
 |  |  |  |  | Weekly Rev. |  |  | 0
 |  |  |  |  | Weekly Wages |  |  | #N/A
 |  |  |  |  | % of Rev. |  |  | #N/A
 |  |  |  |  | Target % |  |  | 0.2597
 |  |  |  |  | Var. to Target |  |  | #N/A |  | #N/A
Spreadsheet: 13fe95e0-4d10-40bf-9fae-1d04d085d5eb
Sheet: Fall 2014

Hamline University [NAME] for Fall 2014
 |  | 2014-09-03 00:00:00 | 2014-10-01 00:00:00 | 2014-10-22 00:00:00 | 2014-11-20 00:00:00 | 2014-12-13 00:00:00 |  | Last Day to [NAME]
4 credits | 4A | 9/3 - 12/13 |  |  |  | End of Term | 1 start | 2014-09-16 00:00:00
3 credits | 3A | 9/3 - 11/19 |  |  |  |  | 2 starts | 2014-09-12 00:00:00
3 credits | 3B |  | 10/1 - 12/13 |  |  |  |  | 2014-10-11 00:00:00
2 credits | 2A | 9/3 - 10/21 |  |  |  |  | 3 starts | 2014-09-11 00:00:00
2 credits | 2B |  | 10/1 - 11/19 |  |  |  |  | 2014-10-09 00:00:00
2 credits | 2C |  |  | 10/22 - 12/13 |  |  |  | 2014-10-30 00:00:00
1 credit | 1A | 9/3-9/30 |  |  |  |  | 4 starts | 2014-09-11 00:00:00
1 credit | 1B |  | 10/1-10/21 |  |  |  |  | 2014-10-09 00:00:00
1 credit | 1C |  |  | 10/22-11/19 |  |  |  | 2014-10-30 00:00:00
1 credit | 1D |  |  |  | 11/20-12/13 |  |  | 2014-11-23 00:00:00
 |  |  |  |  |  |  | 10 total starts
4 credits = | 14-15 class sessions
3 credits = | 10-12 class sessions
2 credits = | 7-8 class sessions
1 credit = | 3-5 class sessions
Spreadsheet: 841099d1693348216-calculating-hourly-census-with-emergency-room-data-census-spudster656-2-
Sheet: Hourly Census

 | Date-Time | Census | hour | day | month | year
Spreadsheet: 494676d1482571235-dynamic-charts-ef
Sheet: Sheet1

Country | Ant | [NAME] | Cat | Dog |  |  |  |  |  |  |  |  |  | A | B | C | D
Angola |  |  |  |  |  |  |  |  |  |  |  |  | Angola | 7804 | 6327 | 4030 | 1061
Russia |  |  |  |  |  |  |  |  |  |  |  |  | Bahrain | 4287 | 7774 | 7291 | 1073
Pakistan |  |  |  |  |  |  |  |  |  |  |  |  | Russia | 8375 | 1682 | 2781 | 2593
 |  |  |  |  |  |  |  |  |  |  |  |  | Latvia | 3202 | 6282 | 1944 | 2471
 |  |  |  |  |  |  |  |  |  |  |  |  | Ethiopia | 5497 | 7533 | 7143 | 4237
 |  |  |  |  |  |  |  |  |  |  |  |  | Jamaica | 1830 | 7992 | 3025 | 4641
 |  |  |  |  |  |  |  |  |  |  |  |  | Pakistan | 1780 | 7515 | 8713 | 4752
Spreadsheet: d1dc4f14-b309-4b3b-bd01-08746a418323
Sheet: Vendor 2

C R I T E R I A | Total Possible Score |  |  |  |  |  |  |  |  |  |  | Average
Qualification Requirements
Understanding the Problem |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Professional Personnel |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Soundness of Approach |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Terms and Conditions |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Available Facilities |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Value Added Services |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Evaluation of Costs
Cost Rating
Total Qualification & Cost Requirements
Oral Presentation |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Score
Spreadsheet: 53651d1253589167-sort-data-from-one-sheet-to-several-sheets-sample-data
Sheet: Sheet1

Date of Works | Plant | Hours | Details | Cost | Work By
22/9/2009 | Plant 1 | 10 | Test Plant1 | 100 | AB
22/9/2009 | Plant 2 | 11 | Test Plant2 | 110 | AB
22/9/2009 | Plant 3 | 12 | Test Plant3 | 120 | AB
22/9/2009 | Plant 4 | 13 | Test Plant4 | 130 | AB
22/9/2009 | Plant 5 | 14 | Test Plant5 | 14 | AB
22/9/2009 | Plant 6 | 15 | Test Plant6 | 15 | AB
22/9/2009 | Plant 7 | 16 | Test Plant7 | 16 | AB
Spreadsheet: 80942d1281184212-count-days-between-dates-open-jobs-count-only-workdays
Sheet: Sheet1

Open Jobs in Days: | <35 Days | 36-60 Days | 61-90 Days
Legal | 2 | 2 | 0
Finance | 2 | 0 | 0
HR | 1 | 0 | 0
TOTAL JOBS | 5 | 2 | 0
Department | Date of Posting | Workdays since
Legal | 2010-06-07 00:00:00 | 45
Finance | 2010-07-10 00:00:00 | 20
Legal | 2010-07-15 00:00:00 | 17
Finance | 2010-07-20 00:00:00 | 14
HR | 2010-07-25 00:00:00 | 10
Legal | 2010-08-01 00:00:00 | 5
Legal | 2010-06-01 00:00:00 | 49
Spreadsheet: 538840d1505842843-pivot-table-displaying-old-data-s666-newpts-53rd-street-cost-schedule-4
Sheet: Draw 6a - 07.17.17

Description | Line Item | Line Item # | Date | Amount | Payee | Notes |  | Line Item | Sum of Line Item # | Sum of Amount
Retaining Wall Materials | Block/Retaining Walls | 345 | 2017-07-11 00:00:00 | 133.07 | Home Depot | Retaining wall materials |  | Block/Retaining Walls | 2070 | 5081.87
Retaining Wall Materials | Block/Retaining Walls | 345 | 2017-07-12 00:00:00 | 371.18 | Home Depot | Retaining wall materials |  | Erosion Control | 211 | 120
Retaining Wall Labor | Block/Retaining Walls | 345 | 2017-07-13 00:00:00 | 2880 | [NAME] | Retaining wall labor |  | Inspections | 407 | 100
Construction BMP | Erosion Control | 211 | 2017-07-13 00:00:00 | 120 | Art's Trench Plate | Stabilized construction entrance |  | Miscellaneous Costs | 212 | 3400
Grading and Export | Rough Grading | 302 | 2017-07-14 00:00:00 | 5950 | B&M Grading | Grading and export material to [NAME] |  | Rough Grading | 302 | 5950
Retaining Wall Materials | Block/Retaining Walls | 345 | 2017-07-14 00:00:00 | 72.22 | Home Depot | Retaining wall materials |  | Grand Total | 3202 | 14651.87
Retaining Wall Materials | Block/Retaining Walls | 345 | 2017-07-03 00:00:00 | 79.95 | HD Supply | Retaining wall materials
Underground Power Plan | Miscellaneous Costs | 212 | 2017-06-29 00:00:00 | 3400 | EPI Engineers | Underground Electrical Plan
Retaining Wall Survey | Block/Retaining Walls | 345 | 2017-07-17 00:00:00 | 1545.45 | Coffey Engineering | Retaining wall survey
Inspection Fee | Inspections | 407 | 2017-07-21 00:00:00 | 100 | Pacific Premier Bank | Inspection fee for draw #6a and 6b
Spreadsheet: 586975d1534775365-return-multiple-rows-values-for-two-search-criteria-using-index-match-function-register-sample-gk-
Sheet: Data Master

Company | Bank | Status | Entered By | Status Type | Payee
[NAME] | ANZ | Cleared | [NAME] | Active | Supplier
ABC Limited | Bank of America | To be presented | [NAME] | Non-Active | Contractor
DEF LIMITED | DB | Expired | Kelly |  | Depositor
 | ICICI | Bounced | Doug |  | Employee
 |  | Returned |  |  | Bank
 |  | Returned - Replaced with New Cheque