tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 756676d1637692352-help-with-nested-if-function-sample-1-
Sheet: Sheet1

 | Range 1 | Range 2 | Value | Actual | Value | Base | Volume | Total
1500 | 1740 | 1950 | 2 | 1060 |  | 10000 |  |  |  | =IF(E2>=B4,IF(E2<C4,D4,IF(E2>B3,IF(E2<C3,D3,IF(E2>B2,IF(E2<C2,D2,""))))))
 | 1590 | 1725 | 1 |  |  |  |  |  |  | =IF(E2>=B5,IF(E2<C5,D5,IF(E2>B6,IF(E2<C6,D6,IF(E2>B7,IF(E2<C7,D7,""))))))
 | 1500 | 1575 | 0
 | 1050 | 1260 | 2 |  |  | 10000
 | 1275 | 1410 | 1
 | 1425 | 1500 | 0
 | desired output
Base | Range 1 | Range 2 | Value | Actual | Value | Base | Volume reduction | Total Amount
1500 | 1050 | 1260 | 2 | 1060 |  | 10000 |  |  |  | if Actual range is between any of the value between B13 to C18, then it should return the value in respective D cell in F13
 | 1275 | 1410 | 1
 | 1425 | 1500 | 0
 | 1500 | 1575 | 0
 | 1590 | 1725 | 1
 | 1740 | 1950 | 2
Spreadsheet: 356582d1415147947-nested-if-function-reorder-formula
Sheet: Sheet1

ROQ | [NAME] | Actual ROQ
10 | 6
4 | 12
7 | 12
4 | 1
1 | 3
20 | 5
4 | 1
2 | 5
8 | 48
5 | 24
1 | 10
21 | 12
5 | 3
7 | 3
5 | 6
5 | 6
3 | 6
3 | 5
6 | 3
1 | 6
1 | 3
15 | 5
10 | 12
1 | 6
47 | 1000
1 | 5
1 | 12
7 | 6
1 | 6
1 | 5
2 | 6
5 | 1
1 | 6
3 | 6
1 | 5
Spreadsheet: 824070d1680274512-result-without-helper-columns-result-without-helper-columns
Sheet: Sheet1 (3)

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 6 | 5 | 4 | 3 | 2 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | test1 |  | 5387651.18 | 196620 | 393240 | 584817.73 | 402001.92 | 737438 | 970968.13 | 3558952.14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <- Answer
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <- Cumulative sum less U123
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <- Ignore negative values
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <- Take the minimum value of this row and row 123
Spreadsheet: 14647e7f-a3f0-407e-928a-8dcf99b8d57e
Sheet: Sheet1

Program Staffing Plan for (name of unit) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
Date of plan: xx/xx/20xx | Name of Agent/Program Assistant
Areas of program focus |  |  |  |  |  |  |  |  |  | Total FTEs
County/District Extension Director
4-H Youth Development Program Management
Adult Development and Aging
Community Development
Crop Production
Family Resource Management
Family Development
Farm Management
Horticulture
Livestock Production
Natural Resources
Nutrition, Food Safety and Health
[NAME]
Youth Development
Total FTEs
Spreadsheet: 79212d1279510993-validation-list-validation-list
Sheet: Page 1

 | Hair
Name | Hairstyle | Color
 | Prep |  |  |  |  |  |  | [NAME]
 | Crop |  |  |  |  |  |  | Crew
 | Receding |  |  |  |  |  |  | Crop
 | Bowl |  |  |  |  |  |  | Bowl
 |  |  |  |  |  |  |  | Receding
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | Long Braids
 |  |  |  |  |  |  |  | Small Afro
 |  |  |  |  |  |  |  | Medium Afro
 |  |  |  |  |  |  |  | Large Afro
 |  |  |  |  |  |  |  | Largest Afro
 |  |  |  |  |  |  |  | Long Twist
 |  |  |  |  |  |  |  | Short Twists
 |  |  |  |  |  |  |  | Long Dreads
 |  |  |  |  |  |  |  | [NAME] Dreads
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | Pulled Dreds
 |  |  |  |  |  |  |  | Floppy
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | Fade
 |  |  |  |  |  |  |  | Side Part
 |  |  |  |  |  |  |  | Mid West
 |  |  |  |  |  |  |  | Curly
 |  |  |  |  |  |  |  | Prep
 |  |  |  |  |  |  |  | Spike
 |  |  |  |  |  |  |  | Over Ears
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | Short Bangs
 |  |  |  |  |  |  |  | 70's
 |  |  |  |  |  |  |  | Medium Bangs
 |  |  |  |  |  |  |  | High Medium Bangs
 |  |  |  |  |  |  |  | Long Bangs
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | Shaved
 |  |  |  |  |  |  |  | Short Forward
 |  |  |  |  |  |  |  | Short Braids
Spreadsheet: 196027d1353793979-fixing-time-values-on-graph-help-needed
Sheet: Sheet8

 |  |  |  |  | kW & KVA Calculations
 |  |  | # | R | Y | B | kW | KVA | Ampire
 |  |  | 00:30:00 | 49 | 46 | 46
 |  |  | 01:00:00 | 53 | 45 | 49
 |  |  | 01:30:00 | 56 | 45 | 52
 |  |  | 02:00:00 | 46 | 40 | 48
 |  |  | 02:30:00 | 52 | 42 | 48
 |  |  | 03:00:00 | 47 | 40 | 50
 |  |  | 03:30:00 | 60 | 47 | 52
 |  |  | 04:00:00 | 59 | 44 | 65
 |  |  | 04:30:00 | 58 | 47 | 39
 |  |  | 05:00:00 | 52 | 45 | 64
 |  |  | 05:30:00 | 49 | 45 | 61
 |  |  | 06:00:00 | 55 | 56 | 51
 |  |  | 06:30:00 | 57 | 54 | 54
 |  |  | 07:00:00 | 49 | 58 | 53
 |  |  | 07:30:00 | 48 | 52 | 53
 |  |  | 08:00:00 | 49 | 48 | 46
 |  |  | 08:30:00
 |  |  | 09:00:00
 |  |  | 09:30:00
 |  |  | 10:00:00
 |  |  | 10:30:00
 |  |  | 11:00:00
 |  |  | 11:30:00
 |  |  | 12:00:00
 |  |  | 12:30:00
 |  |  | 13:00:00
 |  |  | 13:30:00
 |  |  | 14:00:00
 |  |  | 14:30:00
 |  |  | 15:00:00
 |  |  | 15:30:00
 |  |  | 16:00:00
 |  |  | 16:30:00
 |  |  | 17:00:00
 |  |  | 17:30:00
 |  |  | 18:00:00
 |  |  | 18:30:00
 |  |  | 19:00:00
 |  |  | 19:30:00
 |  |  | 20:00:00
 |  |  | 20:30:00
 |  |  | 21:00:00
 |  |  | 21:30:00
 |  |  | 22:00:00
 |  |  | 22:30:00
 |  |  | 23:00:00
 |  |  | 23:30:00
 |  |  | 1900-01-01 00:00:00
Spreadsheet: 35686d1233268360-i-need-help-but-i-dont-even-know-how-to-explain-properly-what-it-is-i-need-subjectsample09
Sheet: Comparison

 |  |  |  | Additional Mathematics | Art | Biology | Chemistry | Child Development | French | Geography | German | History | Home Economics Food | ICT | Music | Physical Education | Physics | Spanish | Technology and Design
 |  |  | Additional Mathematics
 |  |  | Art
 |  |  | Biology
 |  |  | Chemistry
 |  |  | Child Development
 |  |  | French
 |  |  | Geography
 |  |  | German
 |  |  | History
 |  |  | Home Economics Food
 |  |  | ICT
 |  |  | Music
 |  |  | Physical Education
 |  |  | Physics
 |  |  | Spanish
 |  |  | Technology and Design
Spreadsheet: 270118d1381390568-can-i-get-a-list-with-unique-products-fullperiodreport-1
Sheet: Sheet2

LILA | [NAME] code | Total Quantites | total price | color np | color nk | color 050 | color 301 | color 302 | … | … | … | … | …
 |  |  |  | 5 | 5 | 10 | 2 | 3
 |  |  |  | 6 | 4 | 2 | 10 | 8
 |  |  |  | 9 |  | 5
 |  |  |  | 20 |  | 4 | 2 | 10
 |  |  |  | … | … | … | … | …
 |  |  |  | … | … | … | … | …
 |  |  |  | … | … | … | … | …
 |  |  |  | … | … | … | … | …
 |  |  |  | … | … | … | … | …
 |  |  |  | … | … | … | … | …
 |  |  |  | … | … | … | … | …
Spreadsheet: 881076d1728993477-sum-operation-under-many-conditions-book2
Sheet: Sheet1

Table 1
 | SUB.1 |  |  |  | SUB.2
Names | Sun, Sep 8, 2024 | Sun, Sep 15, 2024 | Sun, Sep 22, 2024 | Sun, Sep 29, 2024 | Sun, Oct 6, 2024 | Sun, Oct 13, 2024 | Sun, Oct 20, 2024 | Sun, Oct 27, 2024
[NAME] | 4 | 5 | 2 | 1 | 5 | 1 | 0 | 0
Smith | 4 | 1 | 4 | 5 | 0 | 5 | 7 | 2
[NAME] | 0 | 1 | 0 | 0 | 2 | 0 | 2 | 5
 |  | Table 2
 |  | Names | SUB.1 | SUB.2 | SUB.3
 |  | Jamis | 0 | 0
 |  | [NAME] | 12 | 14
 |  | [NAME] | 0 | 0
 |  | Smith | 14 | 14
 |  | Toney | 1 | 9
Spreadsheet: 680909d1591251551-combining-2-lists-in-2-separate-sheet-into-1-list-on-the-third-sheet-example
Sheet: Data 1

2019 Sales
Client# | Product # | Numer Sold
A | A1 | 10
A | A2 | 15
B | A1 | 50
B | A2 | 20
C | A1 | 5
C | A2 | 1
C | A3 | 21
Spreadsheet: 167064d1341885385-multiple-operations-sepsis-monitoring-7-10-2012-1-
Sheet: Data

Sepsis [NAME]
Pt name | MRN | Location | Admission date | Trigger Date |  | [NAME] | Physician | [NAME] | RR called | [NAME] other than Rapid Response | Additional Comments on Alert Acknowledgement | Indivdiual Acknowledging Alert | Individual's Role Acknowledging Alert | Pt met SIRS criteria per RR assessment? | Lactate level drawn | Lactate level | Name of Physician notified | Adequate Fluid Resuscitation | ATB change | Intubation | Dialysis | Other Orders Y/N | Other Orders (specify) | Outcome | Outcome  Date | [NAME] | Other Comments
 |  |  | 2012-06-18 00:00:00 | 2012-06-21 00:00:00 |  | 12:20:00 |  | BP
 |  |  | 2012-06-16 00:00:00 | 2012-06-20 00:00:00 |  | 02:04:00 |  | Cognitive | Yes
 |  |  | 2012-06-18 00:00:00 | 2012-06-19 00:00:00 |  | 20:56:00 |  | BP | Yes
 |  |  | 2012-06-11 00:00:00 | 2012-06-19 00:00:00 |  | 22:07:00 |  | BP | No
 |  |  | 2012-06-14 00:00:00 | 2012-06-17 00:00:00 |  | 09:56:00 |  | BP | Yes
 |  |  | 2012-06-04 00:00:00 | 2012-06-10 00:00:00 |  | 23:45:00 |  | BP
 |  |  |  |  |  |  |  |  |  | Hospice/Comfort
 |  |  |  |  |  |  |  |  |  | Physician made aware
Totals |  |  |  |  |  |  |  | % BP | % Yes | % Hospice/Comfort |  |  | % RN | % Yes | % Yes |  |  | % Yes | %Yes | %Yes | %Yes |  |  | %Home |  | % Yes
Total # Sepsis Alerts
 |  |  |  |  |  |  |  | % Cognitive | % No | % Physician Notified |  |  | % LPN | %No | %No |  |  | %No |  |  |  |  |  | % xfer higher |  | % No
 |  |  |  |  |  |  |  |  |  | % Physician Made Aware |  |  | % PCT |  |  |  |  |  |  |  |  |  |  | % xfer lower
 |  |  |  |  |  |  |  |  |  | % Primary Nurse Notified |  |  | % Other |  |  |  |  |  |  |  |  |  |  | % expired
Spreadsheet: 275820d1383656662-60-60-formula-to-match-fbl1n_fbl5n_2013
Sheet: Sheet1

Document Type | Amount in local currency |  |  | Amount in doc. curr. | Document Type | Document Date
DM | 4309420.7 |  |  | -53680.41 | CI | 2013-10-14 00:00:00
DM | 761686.1 |  |  | -54794.17 | CI | 2013-10-24 00:00:00
DM | 616707.08 |  |  | -55158.73 | CI | 2013-10-28 00:00:00
RV | 113004.65 |  |  | -55710.43 | CI | 2013-10-28 00:00:00
RV | 99996.72 |  |  | -60373.8 | CI | 2013-10-07 00:00:00
RV | 93391.11 |  |  | -62776.04 | CI | 2013-10-03 00:00:00
RV | 74521.46 |  |  | -63252.77 | CI | 2013-10-11 00:00:00
RV | 69011.42 |  |  | -64673.09 | CI | 2013-10-26 00:00:00
RV | 68912.62 |  |  | -65020.65 | CI | 2013-10-04 00:00:00
RV | 67576.87 |  |  | -66923.18 | CI | 2013-10-25 00:00:00
RV | 66923.18 |  |  | -67576.87 | CI | 2013-09-28 00:00:00
RV | 65020.65 |  |  | -68912.62 | CI | 2013-10-15 00:00:00
RV | 64673.09 |  |  | -69011.42 | CI | 2013-10-09 00:00:00
RV | 63252.77 |  |  | -74521.46 | CI | 2013-10-23 00:00:00
RV | 62776.04 |  |  | -93391.11 | CI | 2013-10-21 00:00:00
RV | 60373.8 |  |  | -99996.72 | CI | 2013-10-01 00:00:00
RV | 55710.43 |  |  | -113004.65 | CI | 2013-09-30 00:00:00
RV | 55158.73 |  |  | -616707.08 | KR | 2013-09-28 00:00:00
RV | 54794.17 |  |  | -761686.1 | KR | 2013-09-28 00:00:00
RV | 53680.41 |  |  | -4309420.7 | KR | 2013-09-28 00:00:00
Spreadsheet: 220958d1363327380-formula-to-calculate-hours-worked-in-a-day-shift-schedule
Sheet: Schedule

MONDAY | START |  | FINISH |  | START |  | FINISH |  | START |  | FINISH |  | START |  | FINISH |  | HOURS | EVENTS
[NAME] | 6.00 |  | 8.30 |  | 11.30 |  | 14.00 |  | 16.00 |  | 18.00 |  | 23.00 |  | 1.00 |  | 9
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Del |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Hours |  | 9
Spreadsheet: 216737d1361874576-find-data-betwwen-two-dates-datest
Sheet: Sheet1

DATA SHEET
Incident No. | Description | Assignee Individual | Assigned date | Closed date | Acknowledment time(mins) | Resolution time (hrs) | Effots spent | Resolved within  SLA
32680254 | AAAA | A | 2012-11-02 00:00:00 | 2012-11-02 00:00:00 | 5.4 | 0.74 | 0.65 | Y
33114036 | BBBBB | B | 2012-12-02 02:40:47 | 2012-12-02 03:16:06 | 0.03222222222 | 0.6194444444 | 0.5872222222 | Y
33905199 | CCCCC | C | 2013-01-28 19:46:44 | 2013-01-28 20:42:44 | 0.01638888889 | 0.9494444444 | 0.8847222222 | Y
33991266 | DDDDD | D | 2013-02-03 06:27:27 | 2013-02-03 09:29:59 | 0.1113888889 | 3.153333333 | 3.041944444 | Y
33987989 | EEEEE | E | 2013-02-02 18:50:25 | 2013-02-02 21:05:48 | 0.03555555556 | 2.291666666 | 0.7191666667 | Y
33986990 | GGGGG | F | 2013-02-02 14:02:57 | 2013-02-02 15:13:02 | 0.07138888889 | 1.239166667 | 1.167777778 | Y
34033456 | HHHHH | G | 2013-02-05 20:05:01 | 2013-02-05 20:55:19 | 0.1133333333 | 0.9513888889 | 0.8380555556 | Y
34241957 | IIIIIIIIII | H | 2013-02-19 19:50:58 | 2013-02-19 22:15:57 | 0.06083333333 | 2.476944444 | 2.416111111 | Y
34241953 | [NAME] | I | 2013-02-19 19:50:37 | 2013-02-19 22:12:16 | 0.1038888889 | 2.464444444 | 2.360555556 | Y
34241945 | KKKKKK | J | 2013-02-19 19:50:10 | 2013-02-19 22:07:29 | 0.145 | 2.433333333 | 2.288333333 | Y
Spreadsheet: darron_c_giron__7957__midland_cogen
Sheet: firm9711

ENRON CAPITAL & TRADE RESOURCES
NETBACK AND FIRM CALCULATIONS
1997-11-01 00:00:00
IFGMR (TRKL/TX) |  |  | 3.16 |  |  | No. of Days: | 30
IFGMR (TRKL/LA) |  |  | 3.18
IFGMR (PEPL/TX/OK) |  |  | 3.16
IFGMR (ANR/LA) |  |  | 3.18
IFGMR (HENRY HUB) |  |  | 3.3
MIDLAND COGENERATION VENTURES
CONTRACT #16-60548-302 (Ultramar)
FIXED CONTRACT: | YEAR | PRICE | YEAR | PRICE
 | 1992 | 2.52 | 2001 | 3.93
 | 1993 | 2.4 | 2002 | 4.23
 | 1994 | 2.51 | 2003 | 4.73
 | 1995 | 2.61 | 2004 | 5.07
 | 1996 | 2.53 | 2005 | 5.43
 | 1997 | 2.65 | 2006 | 5.82 | JAN-SEP
 | 1998 | 2.67 | 2006 | 5.95 | OCT-DEC
 | 1999 | 2.9 | 2007 | 6.37
 | 2000 | 3.33
TERM: Through year 2004 ([NAME])  with annual renewal thereafter.
MaxDQ: 8500 MMBtu/DAY
MinDQ: 60% OF MaxDQ F7,000 MMBtu/DAY | DQ for December, January, and February, 80% of MaxDQ for all other months.
MIDLAND COGENERATION VENTURES
CONTRACT #016-60548-305 (Union Pacific)
PEPL VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.45 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS IFGMR(PEPL-TX/OK)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
TERM: JUNE 1, 1996 THROUGH SEPTEMBER 30, 2006
DESIGNATED QUANTITY -PEPL |  | 5000 | MMBTU/D
ANR VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.45 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS IFGMR (ANR/LA)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
TERM: JUNE 1, 1996 THROUGH SEPTEMBER 30, 2006
[NAME] -ANR |  | 4000 | MMBTU/D
TRKL/ LA-TRKL/TX AVG  VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.45 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS AVG IFGMR (TRKL/LA)/IFGMR(TRKL/TX)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
DESIGNATED TRKL TOTAL |  | 6000 | MMBTU/D
*Customer prefers rounding to nearest penny.
Spreadsheet: eric_saibi__9872__102201R
Sheet: Hatch 02

Owner Name |  | Georgia Power Company
Station Name |  | Edwin I Hatch Nuclear Power Station
Unit Name |  | Hatch 02
NERC Region |  | SERC
State |  | GA
Fuel Type |  | Nuclear
Capacity |  | 865 MW
Start Date |  | 2001-09-15 00:00:00
End Date |  | 2001-10-23 00:00:00
Prv. Start Date |  | 2001-09-15 00:00:00
Prv. End Date |  | 2001-10-19 00:00:00
Comments |  | Failed startup due to maintenance difficulties.
SIC |  | 4911
Plant ID |  | 1012040
Unit ID |  | 1004272
Outage ID |  | 8185
Spreadsheet: 39112d1237313497-populate-a-cell-from-data-matched-from-3-other-worksheets-stock-inventory-sheet
Sheet: January 2009

Stock Inventory January 2009 | Stock List | Stock List | Stock List |  |  | Stock List | Stock List | Stock List | Stock List
[NAME] | Category | Description | Unit Price | Previous Stock | Quantity Sold | Quantity in Stock | Total Value | Last Order Date | Notes
 | Desktop | HP DX2300 AMD | 237 | 30 | 5 | 25 | 5925
 | Laptop | HP 6735 AMD | 437 | 2 | 1 | 1 | 437
 | Cables | 3M Cat5 Cable | 4.33 | 10 | 0 | 10 | 43.3
 | Cables | 5M Cat5 Cable | 6.24 | 10 | 0 | 10 | 62.40000000000001
 | Cables | 10M Cat5 Cable | 8.88 | 5 | 0 | 5 | 44.40000000000001
 | Cables | 15M Cat5 Cable | 10.39 | 5 | 0 | 5 | 51.95
 | Power Accessories | 4 Way Power Extension | 6.48 | 5 | 0 | 5 | 32.40000000000001
 | Power Accessories | 6 Way Power Extension | 9.88 | 10 | 0 | 10 | 98.80000000000001
 | Keyboard | KB PS2 105 UK | 4 | 5 | 0 | 5 | 20
 | Keyboard | KB USB 105 UK | 4.5 | 10 | 0 | 10 | 45
 | Laptop Peripherals | Targus Carry Case | 19.5 | 2 | 0 | 2 | 39
 | Laptop Peripherals | Kingston USB 1GB Stick | 33 | 2 | 0 | 2 | 66
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
Spreadsheet: darrell_schoolcraft__7322__imball0202
Sheet: PEPL

 | Hansford
 | 8042
Day | Measured | Scheduled
1 | -28994 | -28956
2 | -58020 | -57711
3 | -57789 | -57711
4 | -57818 | -57711
5 | -29948 | -29013
6 | -17354 | -18500
7 | -38858 | -38303
8 | -23897 | -23492
9 | -66545 | -67340
10 | -67813 | -67340
11 | -67191 | -67340
12 | -36674 | -36088
13 | -47122 | -47000
14 | -45072 | -45048
15 | -33797 | -32900
16 | -57765 | -57276
17 | -57995 | -57276
18 | -57788 | -57276
19
20
21
22
23
24
25
26
27
28
29
30
31
2002-01-31 00:00:00 |  |  | 19592
2002-02-18 00:00:00
CBS Dollars
 |  |  | 186633
Spreadsheet: 697969d1601648958-finding-last-non-blank-cell-for-a-formula-reference-root729-formula-sheet
Sheet: DAILY SUMMARY

Order Date | Item cost (TOTAL) | Sale Price (TOTAL) | Ebay fee (TOTAL) | Ebay promo (TOTAL) | Paypal fee (TOTAL) | Post (TOTAL) | Total cost (TOTAL) | profit (TOTAL) | Cash in (TOTAL) | Profit % (TOTAL)
2020-09-29 00:00:00
2020-09-30 00:00:00
2020-10-01 00:00:00
2020-10-02 00:00:00
2020-10-03 00:00:00
2020-10-04 00:00:00
2020-10-05 00:00:00
2020-10-06 00:00:00
2020-10-07 00:00:00
2020-10-08 00:00:00
2020-10-09 00:00:00
2020-10-10 00:00:00
2020-10-11 00:00:00
2020-10-12 00:00:00
2020-10-13 00:00:00
2020-10-14 00:00:00
Spreadsheet: 544395d1508877356-autopopulate-dates-from-table-to-monthly-calendar-calendar_test
Sheet: Week View

 | ASSIGNMENTS | MONTH VIEW
 | Select Month: | Enter Year: | Select Week #:
 | September |  | Week 1
 | WEEK VIEW
 | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY
Spreadsheet: 754593d1636362879-return-match-of-1st-and-last-in-blocks-book1
Sheet: Edit

Staff | Meeting Start1 | Meeting Finish1 | Meeting Start2 | Meeting Finish2 | 08:00 | 08:15 | 08:30 | 08:45 | 09:00 | 09:15 | 09:30 | 09:45 | 10:00 | 10:15 | 10:30 | 10:45 | 11:00 | 11:15 | 11:30 | 11:45 | 12:00 | 12:15 | 12:30 | 12:45 | 13:00 | 13:15 | 13:30 | 13:45 | 14:00 | 14:15 | 14:30 | 14:45 | 15:00 | 15:15 | 15:30 | 15:45 | 16:00 | 16:15 | 16:30 | 16:45 | 17:00 | 17:15 | 17:30 | 17:45 | 18:00
Name 1 |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | m | m | m | m | m | x | x | x | x | x | m | m | m | m | m | x | x | x | x | x | x | x
Name 2 |  |  |  |  | x | x | x | x | x | x | x | x | x | x | m | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
Name 3 |  |  |  |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
Name 4 |  |  |  |  | m | m | m | m | m | m | m | m | m | m | m | m | m | m | m | m | m | m | m | m | m | m | m | m | m | m | m | m | m | m | m | m | m
Name 5 |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
Name 6 |  |  |  |  |  |  |  |  | x | x | x | x | x | x | m | m | m | x | x | x | x | x | x | x | x | x | x | m | m | m | m | m | m | m | x | x | x | x | x | x | x
Name 7 |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
Name 8 |  |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
Name 9 |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | m | m | m | m | x | x | x | x | x | x | x | x | x | x | x | x
Name 10 |  |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
Name 11 |  |  |  |  |  |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
Name 12 |  |  |  |  |  |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
Name 13 |  |  |  |  |  |  |  |  |  |  |  |  | x | x | m | x | x | x | x | x | x | x | x | x | m | m | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
Name 14 |  |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
Name 15 |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
Spreadsheet: a1458f31-d546-4ef5-b9fc-e9061b611768
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: |  |  | 2011-03-10 14:24:02.690000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
5.25 | 101.75 | 101.75 | 101.625 | 101.125 |  | and are added to price quote
5.125 | 101.596 | 101.596 | 101.471 | 100.971
5 | 101.17 | 101.17 | 101.045 | 100.545 |  | Note: | Refer To Price [NAME]
4.875 | 100.665 | 100.665 | 100.54 | 100.04 |  |  | For all Price Adjs
4.75 | 99.707 | 99.707 | 99.582
4.625 | 98.505 | 98.505 | 98.38
 |  |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  |  | Please note availability of
 |  |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  |  | Will apply.
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4.5 | 101.75 | 101.75 | 101.625 | 101.125
4.375 | 101.576 | 101.576 | 101.451 | 100.951
4.25 | 101.04 | 101.04 | 100.915 | 100.415
4.125 | 99.86099999999999 | 99.86099999999999 | 99.73599999999999 | 99.23599999999999
4 | 99.49199999999999 | 99.49199999999999 | 99.36699999999999
 |  |  |  |  |  | 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: |  |  | 2011-03-10 14:24:02.690000
 |  |  |  |  |  | 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 | 2011-03-24 14:24:02.690000
30 DAY | 2011-04-08 14:24:02.690000
45 DAY | 2011-04-23 14:24:02.690000
60 DAY | 2011-05-08 14:24:02.690000
90 DAY | 2011-06-07 14:24:02.690000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 682310d1591996077-how-to-convert-multiple-column-data-into-two-columns-post-how-to-convert-multiple-column-data-into-two-columns
Sheet: Sheet1

Job1 | Role1 |  | Role3 | Role4 | Role5
Job2 |  | Role2
Job3 | Role1 |  |  | Role4
Job4 |  |  | Role3 |  | Role5
[NAME] | Role1 |  | Role3
 |  |  |  | Job1 | Role1
 |  |  |  | Job1 | Role3
 |  |  |  | Job1 | Role4
 |  |  |  | Job1 | Role5
 |  |  |  | Job2 | Role2
 |  |  |  | Job3 | Role1
 |  |  |  | Job3 | Role4
 |  |  |  | Job4 | Role3
 |  |  |  | Job4 | Role5
 |  |  |  | [NAME] | Role1
 |  |  |  | [NAME] | Role3
Spreadsheet: 841990d1694094004-vlookup-and-list-in-same-cell-want-to-go-back-to-vlookup-if-list-entry-is-cleared-test-57-
Sheet: Data

Table of Data |  |  |  | Table To Look Up Colour
ID | Person | Colour |  | ID/PERSON |  | ID | Person | Colour
1 | [NAME] | Blue |  | [NAME]
2 | [NAME] | Green |  | 3
3 | [NAME] | Orange |  | [NAME]
4 | [NAME] | [NAME]
5 | [NAME] | Red
 | B2-B5 named as "Person"