tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 815358d1674900439-i-want-to-apply-one-single-formula-with-25-if-conditions-if-function-issue-v1
Sheet: Sheet1

A | B | Result
1 | 1 | 1 |  | 1) IF A3= 1 & B3=1 then Result Should be 1 (One Formula with all 25 IF conditions) from A3 to A27   I am Trying below [NAME] but its not working from Red highlited portion  =IF(A3>=1,"1",IF(B3>=1,"1",IF(A4>=1,"3",IF(B4>=2,"3",IF(A5>=1,"6",IF(B5>=3,"6",F(A6>=1,"10",IF(B6>=4,"10",IF(A7>=1,"15",IF(B7>=5,"15",IF(A8>=2,"2",IF(B8>=1,"2",IF(A9>=2,"5",IF(B9>=2,"5",IF(A10>=3,"13",IF(B10>=3,"13",IF(A11>=4,"21",IF(B11>=4,"21",IF(A12>=5,"25",IF(B12>=5,"25",IF(A13>=3,"22",IF(B13>=5,"22",IF(A14>=3,"8",IF(B14>=2,"8",IF(A15>=4,"12",IF(B15>=2,"12",IF(A16>=5,"16",IF(B16>=2,"16",IF(A17>=3,"4",IF(B17>=1,"4",IF(A18>=4,"7",IF(B18>=1,"7",IF(A19>=2,"9",IF(B19>=3,"9",IF(A20>=5,"11",IF(B20>=1,"11",IF(A21>=2,"14",IF(B21>=4,"14",IF(A22>=4,"17",IF(B22>=3,"17",IF(A23>=3,"18",IF(B23>=4,"18",IF(A24>=2,"19",IF(B24>=5,"19",IF(A25>=5,"20",IF(B25>=3,"20",IF(A26>=5,"23",IF(B26>=4,"23",IF(A27>=4,"24",IF(B27>=5,"24"))
1 | 2 | 3
1 | 3 | 6
1 | 4 | 10
1 | 5 | 15
2 | 1 | 2
2 | 2 | 5
3 | 3 | 13
4 | 4 | 21
5 | 5 | 25
3 | 5 | 22
3 | 2 | 8
4 | 2 | 12
5 | 2 | 16
3 | 1 | 4
4 | 1 | 7
2 | 3 | 9
5 | 1 | 11
2 | 4 | 14
4 | 3 | 17
3 | 4 | 18
2 | 5 | 19
5 | 3 | 20
5 | 4 | 23
4 | 5 | 24
Spreadsheet: 271549d1381971244-combining-issearch-and-sumif-test
Sheet: Sheet1

Concatenate | 2012 | Trade | CUR | ITD | YTD | Comments |  |  |  |  | Row Labels | Total
 |  | ABC | EUR | 20 | 13 | testing 2012 |  |  |  |  | ABCEUR
 |  | BCD | EUR | 15 | 14 | testing 2012 |  |  |  |  | ABCHKD
 |  | BCD | [NAME] | 45 | 15 | testing 2013 |  |  |  |  | [NAME]
 |  | BCD | EUR | 32 | 16 | testing 2013 |  |  |  |  | BCDHKD
 |  | ABC | EUR | 65 | 17 | testing 2012 |  |  |  |  | BCDJPY
 |  | ABC | HKD | 90 | 18 | testing 2013 |  |  |  |  | BCDPHP
 |  | BCD | HKD | 17 | 19 | testing 2013 |  |  |  |  | Grand Total
 |  | ABC | HKD | 12 | 20 | testing 2013
 |  | BCD | EUR | 14 | 21 | testing 2012
Spreadsheet: 90464d1290175318-excel-2007-showing-values-used-in-calculation-monthly-average-for-dmr
Sheet: Sheet1

Monthly Averages For Discharge Monitoring Report (DMR)
Month of:
D.O.
Flow |  |  | Effluent CBOD |  |  |  | Effluent TSS
[NAME]: | 1.2 |  | Reading 1 |  |  |  | Reading 1
Avg: | 0.62 |  | Reading 2 |  |  |  | Reading 2
 |  |  | [NAME] | 23.2 |  |  | [NAME]
 |  |  | Average | 14.3 |  |  | Average
pH |  |  | Influent CBOD |  |  |  | Influent TSS
Hi: |  |  | Reading 1 |  |  |  | Reading 1
[NAME]: |  |  | Reading 2 |  |  |  | Reading 2
 |  |  | [NAME] |  |  |  | [NAME]
 |  |  | Average |  |  |  | Average
Effluent
CBOD Max Loading (Lbs/Day) - Max CBOD X 8.34 X [NAME] (MGD)
CBOD Average Loading (Lbs/Day) - Avg. CBOD X 8.34 X Average Flow (MGD)
TSS Max Loading (Lbs/Day) - Max TSS X 8.34 X [NAME] (MGD)
TSS Average Loading (Lbs/Day) - Avg. TSS X 8.34 X Avg Flow (MDG)
Influent
CBOD Max Loading (Lbs/Day) - Max CBOD X 8.34 X [NAME] (MGD)
CBOD Average Loading (Lbs/Day) - Avg. CBOD X 8.34 X Average Flow (MGD)
TSS Max Loading (Lbs/Day) - Max TSS X 8.34 X [NAME] (MGD)
TSS Average Loading (Lbs/Day) - Avg. TSS X 8.34 X Avg Flow (MDG)
Population Equivalent
Spreadsheet: chris_germany__1974__ENA-Reliant Prepay
Sheet: Summary

ENA Prepays to Reliant
Reliant RES Cash Group |  | [NAME]  [PHONE]  [EMAIL]
Reliant RES Cash Group |  | [NAME]  [PHONE]  [EMAIL]
 |  |  | Prepayment
 |  | Date | (Purchases) | Comments
 | Wed | 2002-02-06 00:00:00 | 22500
 | Fri | 2002-02-08 00:00:00 | 20000
 | Thu | 2002-02-14 00:00:00 | 26000
 | Thu | 2002-02-21 00:00:00 | 10000
 | Thu | 2002-02-28 00:00:00 | 19000
 |  | Total Prepays Feb 2002
 |  | Feb 2002 Swing Purchases
 |  | Cash Balance on 2/28/02
 | Wed | 2002-03-06 00:00:00 | 42000
 | Thu | 2002-03-14 00:00:00 | 25000
 | Thu |  | 30000 | 3/22/02 9:00AM  verified payment with [NAME]
 | Thu | 2002-03-28 00:00:00 | 40000 | To be applied to Prepayment for FGT and TRKL swing activity.  3/29/02  2:45 PM verfied payment with [NAME]
 | Thu | 2002-03-28 00:00:00 | 701760 | To be applied to Apr 2002 Baseload Purchase on Trunkline.  3/29/02 2:45 PM verified payment with [NAME]
 | Thu | 2002-03-28 00:00:00 | 989700 | To be applied to Apr 2002 Baseload Purchase on Florida.  3/29/02 2:45 PM verified payment with [NAME].
 |  | Total Prepays Mar 2002
 |  | Mar 2002 Swing Purchases
 |  | Cash Balance on 3/31/02
 | Thu | 2002-04-04 00:00:00 | 37000 | 4/8/02 1:45 PM verified payment with [NAME]
 | Fri |  | 22000 | 4/15/02 10:00 AM  verified payment with [NAME].
 | Fri | 2002-04-19 00:00:00 | 17000 | 4/23/02  9:15 AM verified payment with [NAME].
 | Mon | 2002-04-29 00:00:00 | 45000 | 4/30/02  8:20 AM verified payment with [NAME].
 | Tue | 2002-04-30 00:00:00 | 683835.2 | To be applied to May 2002 Baseload Purchase on Trunkline.  4/30/02  3:45 PM verified payment with [NAME].
 | Tue | 2002-04-30 00:00:00 | 1365767 | To be applied to May 2002 Baseload Purchase on Florida.  4/30/02  3:45 PM verified payment with [NAME].
 |  | Total Prepays Apr 2002
 |  | Apr 2002 Baseload Purchase on Trunkline |  | Sitara #1202698
 |  | Apr 2002 Baseload Purchase on Florida |  | Sitara #1203148
 |  | Apr 2002 Swing Purchases |  | Sitara #1203186
 |  | Total Apr 2002 Purchases
 |  | Cash Balance on 4/30/02
 | Fri | 2002-05-03 00:00:00 | 10000 | 5/6/02 2:00 PM verified payment with [NAME].
 | Thu
 | Thu
 | Thu
 | Tue
 |  | Total Prepays May 2002
 |  | May 2002 Baseload Purchase on Trunkline |  | Sitara #1206391
 |  | May 2002 Baseload Purchase on Florida |  | Sitara #1206815
 |  | May 2002 Swing Purchases |  | Sitara #1203186
 |  | Total May 2002 Purchases
 |  | Current Cash Balance
Notes: | 4/9/02  2:30 PM - Per [NAME] at Reliant - purchase formula for the March 1st is using [NAME] instead of GD + $.06.  Fixed formula in spreadsheet, total impact to cash balance is ($120.00)
Spreadsheet: 841091d1693341884-get-dates-based-on-weeks-example-date
Sheet: Sheet1

 | 2023
Week | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
Workdays
Spreadsheet: richard_sanders__32083__attachments
Sheet: Attachment A

Silver Peak Schedules Submitted on May 24, 1999 for Deliveries on May 25, 1999
Notes: | (1) | (1) | (1) | (1) | (2) | (3) | (3) | (3) | (4) | (4) | (5) | (4)
 | NP15 Longs | NW Longs | SP15 Longs | SW Longs | Unconstrained | Initial Preferred | [NAME] | Adjustment | Constrained | Constrained | Congestion | Final
 | MW | MW | MW | MW | MCP | Schedule |  | Bid | SR3 MCP | SP15 MCP | $/MWh | Schedule
0100 |  |  |  |  | 20.6554 |  | F_SILVPK |  | 21.38 | 21.38 |  | 0
0200 |  |  |  |  | 18.3717 |  | F_SILVPK |  | 19.07 | 19.07 |  | 0
0300 |  |  |  |  | 17.504 |  | F_SILVPK |  | 18.41 | 18.41 |  | 0
0400 |  |  |  |  | 14.0569 |  | F_SILVPK |  | 14.36 | 14.36 |  | 0
0500 |  |  |  |  | 18.9964 |  | F_SILVPK |  | 20.45 | 20.45 |  | 0
0600 |  |  |  |  | 24.4967 |  | F_SILVPK |  | 24.4967 | 24.4967 |  | 0
0700 |  |  |  |  | 19.9428 |  | F_SILVPK |  | 19.94 | 38 |  | 3
0800 |  |  |  |  | 25.8947 |  | F_SILVPK |  | 25.89 | 38.99 |  | 3
0900 |  |  |  |  | 26.9196 |  | F_SILVPK |  | 26.91 | 51.92 |  | 3
1000 |  |  |  |  | 27.5973 |  | F_SILVPK |  | 27.59 | 37.6 |  | 3
1100 |  |  |  |  | 28.3814 |  | F_SILVPK |  | 28.38 | 48.38 |  | 3
1200 |  |  |  |  | 28.1807 |  | F_SILVPK |  | 28.18 | 48.18 |  | 3
1300 |  |  |  |  | 27.999 |  | F_SILVPK |  | 27.99 | 48 |  | 3
1400 |  |  |  |  | 28.7672 |  | F_SILVPK |  | 28.76 | 48.77 |  | 3
1500 |  |  |  |  | 28.9763 |  | F_SILVPK |  | 28.97 | 48.98 |  | 3
1600 |  |  |  |  | 28.1041 |  | F_SILVPK |  | 28.1 | 49.99 |  | 3
1700 |  |  |  |  | 28.1997 |  | F_SILVPK |  | 28.19 | 49.99 |  | 3
1800 |  |  |  |  | 27.0583 |  | F_SILVPK |  | 27.05 | 47.06 |  | 3
1900 |  |  |  |  | 26.5752 |  | F_SILVPK |  | 26.57 | 38.99 |  | 3
2000 |  |  |  |  | 25.6897 |  | F_SILVPK |  | 25.68 | 35.69 |  | 3
2100 |  |  |  |  | 29.2826 |  | F_SILVPK |  | 29.28 | 39.5 |  | 3
2200 |  |  |  |  | 26.4872 |  | F_SILVPK |  | 26.48 | 38.99 |  | 3
2300 |  |  |  |  | 25.9942 |  | F_SILVPK |  | 25.99 | 25.99 |  | 0
2400 |  |  |  |  | 24.4942 |  | F_SILVPK |  | 24.5 | 24.5 |  | 0
(1) | Portfolio bids submitted to PX @ 07:00 and accepted based on unconstrained MCP @ 07:15
(2) | Published by PX @ 07:15
(3) | Submitted to PX @ 09:00 as one schedule at the Silver Peak tie point
(4) | Published by PX after ISO calculates congestion charges and publishes final schedules.  Approximately 14:30.
(5) | Published by ISO after running congestion management software and processing adjustment bids.  Approximately 13:30.
Spreadsheet: 147416d1332786009-vlookup-returns-0-book4
Sheet: Sheet1

2061075 | 4296103 | Y |  | 2012-01-24 00:00:00
2121216 | 4392344 | Y |  | 2012-02-21 00:00:00
2121216 | 4392344 |  | Y | 2012-03-01 00:00:00
2121216 | 4392344 |  | Y | 2012-03-09 00:00:00 | 1Z4675E70308224005
2121216 | 4392344 |  | Y | 2012-03-09 00:00:00 | 1Z4675E70308243217
2121217 | 4392344 | Y |  | 2012-02-21 00:00:00
2121217 | 4392344 |  | Y | 2012-03-01 00:00:00 | 1Z2109990345679280
2121218 | 4392344 | Y |  | 2012-02-21 00:00:00
2137057 | 4418534 | Y |  | 2012-03-01 00:00:00
2143083 | 4428302 | Y |  | 2012-03-09 00:00:00
2145002 | 4427732 | Y |  | 2012-03-09 00:00:00
2147343 | 4434607 | Y |  | 2012-03-09 00:00:00
2148477 | 4436868 | Y |  | 2012-03-09 00:00:00
2151052 | 4440988 | Y |  | 2012-03-13 00:00:00
2153558 | 4444889 | Y |  | 2012-03-13 00:00:00
2154507 | 4446576 |  |  | 2012-03-14 00:00:00
2155942 | 4445867 | Y |  | 2012-03-15 00:00:00
2155990 | 4445418 | Y |  | 2012-03-15 00:00:00
2155991 | 4445418 | Y |  | 2012-03-16 00:00:00
2155992 | 4445867 | Y |  | 2012-03-15 00:00:00
2155993 | 4445418 | Y | Y | 2012-03-16 00:00:00 | 1Z4789070328844522
2155994 | 4451299 | Y |  | 2012-03-15 00:00:00
2156007 | 4445867 | Y |  | 2012-03-15 00:00:00
2156830 | 4450419 | Y |  | 2012-03-14 00:00:00
2157381 | 4451334 | Y |  | 2012-03-15 00:00:00
2158018 | 4452350 | Y |  | 2012-03-20 00:00:00
2158312 | 4452890 | Y |  | 2012-03-15 00:00:00
2158692 | 4453382 | Y |  | 2012-03-19 00:00:00
2158775 | 4453540 | Y |  | 2012-03-19 00:00:00
2160274 | 4455153 | Y |  | 2012-03-16 00:00:00
2160275 | 4455153 | Y |  | 2012-03-16 00:00:00
2160300 | 4455153 | Y |  | 2012-03-16 00:00:00
2161870 | 4458594 | Y |  | 2012-03-19 00:00:00
2161942 | 4458636 | Y |  | 2012-03-19 00:00:00
2165009 | 4463621 | Y |  | 2012-03-21 00:00:00
2165010 | 4463621 | Y |  | 2012-03-21 00:00:00
2165011 | 4463621 | Y |  | 2012-03-21 00:00:00
2165012 | 4463621 | Y |  | 2012-03-21 00:00:00
2165061 | 4463752 | Y |  | 2012-03-21 00:00:00
2165063 | 4463752 | Y |  | 2012-03-21 00:00:00
2166207 | 4465815 | Y | Y | 2012-03-21 00:00:00 | 1Z7505640147829615
BDC 73 | 4434607 | Y |  | 2012-03-09 00:00:00
BDC 74 | 4436042 | Y |  | 2012-03-09 00:00:00
BDC 79 | 4446576 |  |  | 2012-03-14 00:00:00
BDC 81 | 4453540 | Y |  | 2012-03-16 00:00:00
BDC 84 | 4455153 | Y |  | 2012-03-19 00:00:00
BDC 86 | 4458636 | Y |  | 2012-03-20 00:00:00
BDC 87 | 4461623 | Y |  | 2012-03-21 00:00:00
BDC 88 | 4466895 | Y |  | 2012-03-21 00:00:00
T 666020 | 4436042 | Y |  | 2012-03-09 00:00:00
T 668986 | 4458594 | Y |  | 2012-03-19 00:00:00
2166262 | 4461625 | Y |  | 2012-03-22 00:00:00
2167931 | 4468764 | Y |  | 2012-03-22 00:00:00
2166573 | 4461625 | Y |  | 2012-03-22 00:00:00
2166601 | 4463207 | Y |  | 2012-03-22 00:00:00
2169408 | 4471372 | Y |  | 2012-03-23 00:00:00
2167930 | 4468764 | Y |  | 2012-03-22 00:00:00
2167930 | 4468764 |  | Y | 2012-03-23 00:00:00 | 1Z7599530351460695
2167931 | 4468764 |  | Y | 2012-03-23 00:00:00 | 1Z29X8X60358369476
2169903 | 4472112 | Y |  | 2012-03-26 00:00:00
2165013 | 4463621 | Y |  | 2012-03-26 00:00:00
2166268 | 4463207 | Y |  | 2012-03-26 00:00:00
Spreadsheet: 731539d1620395754-highlight-date-range-on-calendar-data
Sheet: 3118 Services

 |  |  |  | 3118 |  |  |  |  |  |  | 3118 |  |  |  |  |  |  |  | 3118 |  |  |  |  |  |  |  |  |  | 3118
 |  |  |  | CAT Service - ENGINE No. N5F00981 |  |  |  |  |  |  | Fire Suppression |  |  |  |  |  |  |  | Core Service @ |  | 1000 |  |  |  |  |  |  |  | HF @ | 250
 |  |  |  | Frequency @ hr |  | 500 |  |  |  |  | Frequency @ 12 months
Date | @ 500hrs | Hrs when Serviced | Hrs between service dates | Current Hour | Hrs left to run before 500H | Comment |  | Completed by | Date | [NAME] | Next Service | Comment |  | Date | Completed by | @ 1000hrs | Hrs when Serviced | Hrs ran between service dates | Current Hour | Hrs left to run before 1000H | Comment | CAT Service |  | Date | Completed by | Hrs when HF | Hrs ran between HF dates | Next due @ 250hrs | Book when reached | Comment
 |  |  |  |  |  |  |  |  |  |  |  | Not service or repaired since installed Oct 17 |  | 2021-03-02 00:00:00 | PK |  |  |  |  |  |  |  |  | 2021-03-02 00:00:00 | AE
2021-02-12 00:00:00 |  | 5221 |  | 5251
Spreadsheet: 108880d1305822850-sorting-one-column-to-match-another-color-example
Sheet: Sheet1

Current Data |  |  |  |  | Results Desired
Color 1 |  | Color2 |  |  | Color 1 |  | Color 2
Red |  | Green |  |  | Red |  | Red
Green |  | Red |  |  | Green |  | Green
Blue |  | Purple |  |  | Blue |  | -
Yellow |  | Silver |  |  | Yellow |  | Yellow
Indigo |  | Yellow |  |  | Indigo |  | Indigo
[NAME] |  | Indigo |  |  | [NAME] |  | -
Black |  | Black |  |  | Black |  | Black
Orange |  | Orange |  |  | Orange |  | Orange
Gray |  | White |  |  | Gray |  | -
 |  | Pink
 |  | Violet
Spreadsheet: 38411d1236598118-excel-2007-issue-with-using-formulas-to-pull-data-from-one-sheet-to-another-lwnnsalariesprojections
Sheet: Twins

Minnesota Twins | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 |  | Minnesota Twins | 2009 | 2010 | 2011 | 2012 | 2013 | 2014
Actual |  |  |  |  |  |  |  | Operations
Budget | 90 | 90 | 90 | 90 | 90 | 90
Difference |  |  |  |  |  |  |  | Fan Base Factors
 |  |  |  |  |  |  |  | Record Reward
Cost of Goods
Personnel |  |  |  |  |  |  |  | Income
[NAME], [NAME] | ML | ML | ML | ML | ML | ML |  | From Angels | -0.5 | -0.3 |  |  | -0.1
Duran, [NAME] | ML | ML | ML | ML | ML | ML |  | From Athletics | -1
[NAME], [NAME] | ML | ML | ML | ML | ML | ML |  | From Brewers | -4
Wieland, [NAME] | ML | ML | ML | ML | ML | ML |  | From Cubs | -1.2
[NAME] | ML | ML | ML | ML | ML | ML |  | From Padres | -1.2 | -0.1
[NAME], [NAME] | ML | ML | ML | ML | ML | ML |  | From Phillies | -0.8
[NAME], Jon | ML | ML | ML | ML | ML | ML |  | From Red Sox |  | -0.1
Bailey, [NAME] | ML | ML | ML | ML | ML | ML |  | From Rays | -0.6 |  |  |  | -0.1
Blanks, [NAME] | ML | ML | ML | ML | ML | ML |  | From Royals | -3.2
Bourjos, [NAME] | ML | ML | ML | ML | ML | ML |  | From Yankees | -0.8
[NAME], [NAME] | ML | ML | ML | ML | ML | ML
Cardenas, Adrian | ML | ML | ML | ML | ML | ML |  | Expenses
[NAME], [NAME] | ML | ML | ML | ML | ML | ML |  | [NAME], [NAME] | 1.8
[NAME], Wade | ML | ML | ML | ML | ML | ML |  | Mujica, [NAME] | 0.4
[NAME], [NAME] | ML | ML | ML | ML | ML | ML |  | [NAME], [NAME] | 0.3
Elbert, Scott | ML | ML | ML | ML | ML | ML |  | To Angels | 18.8 | 4.2 | 4.1
Erbe, Brandon | ML | ML | ML | ML | ML | ML |  | To Diamonbacks | 0.7
Feierabend, [NAME] | ML | ML | ML | ML | ML | ML |  | To Dodgers |  | 0.1
Francisco, Juan | ML | ML | ML | ML | ML | ML |  | To Padres | 5.5
Gutierrez, [NAME] | ML | ML | ML | ML | ML | ML
[NAME], [NAME] | ML | ML | ML | ML | ML | ML
[NAME], Shane | ML | ML | ML | ML | ML | ML
Marrero, [NAME] | ML | ML | ML | ML | ML | ML
[NAME], [NAME] | ML | ML | ML | ML | ML | ML
Parker, Jarrod | ML | ML | ML | ML | ML | ML
[NAME], [NAME] | ML | ML | ML | ML | ML | ML
Rasmus, Cory | ML | ML | ML | ML | ML | ML
Raynor, [NAME] | ML | ML | ML | ML | ML | ML
Rogers, Esmil | ML | ML | ML | ML | ML | ML
Romak, [NAME] | ML | ML | ML | ML | ML | ML
Sipp, [NAME] | ML | ML | ML | ML | ML | ML
Stubbs, [NAME] | ML | ML | ML | ML | ML | ML
[NAME], [NAME] | ML | ML | ML | ML | ML | ML
Waring, [NAME] | ML | ML | ML | ML | ML | ML
West, Sean | ML | ML | ML | ML | ML | ML
Berkman, Lance | 19.3 | 19.3 | 19.3 | 19.3
[NAME], Cliff | 17.2 | 17.2 | 17.2 | 17.2
Thome, [NAME] | 15
[NAME], [NAME] | 13.2 | 13.2
[NAME], [NAME] | 3.5 | A3
Penny, [NAME] | 1.7
[NAME], [NAME] | 1.5 | 1.5 | 1.5 | 1.5
[NAME], [NAME] | 1.1 | A2 | A3
Escobar, Yunel | 0.7 | A1 | A2 | A3
Perez, [NAME] | 0.7 | 0.7 | 0.7 | 0.7
[NAME], [NAME] | 0.5 | 0.5
Braden, Dallas | 0.3 | 0.7 | A1 | A2 | A3
[NAME], [NAME] | 0.3 | 0.7 | A1 | A2 | A3
[NAME], [NAME] | 0.3 | 0.7 | A1 | A2 | A3
Sweeney, [NAME] | 0.3 | 0.7 | A1 | A2 | A3
Weathers, [NAME] | 0.1
Spreadsheet: 151711d1335077039-gathering-information-across-multiple-sheets-and-displaying-in-a-master-sheet-products-1-
Sheet: 11042012

No | Name | Total | 1 | 2 | 3 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16
20073 | Car | 11 | 2 |  |  | 1 | 1 | 2 | 1 |  | 2 |  |  | 2
20074 | Truck | 20 |  |  |  |  |  |  | 1 |  | 19
20076 | Plane | 5 | 1 | 1 | 2 |  |  |  |  |  | 1
20077 | Motorcycle | 1 |  |  |  |  |  |  |  |  |  |  |  | 1
20078 | Trailer | 2 |  |  |  |  |  |  |  |  | 2
20082 | Tractor | 2 |  | 1 | 1
20084 | Boat | 35 |  | 1 |  | 8 |  | 8 | 3 |  | 4 |  |  | 10 | 1
Spreadsheet: d949987a-8283-4f4a-8b7f-e433e1bc5482
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | EcoCheck Data: Lower Bay for 2009
Indicator | 2009
Chlorophyll a | 8.213
Aquatic Grasses | 47.4
[NAME] | 87.127
[NAME] | 85
Water Clarity | 21.611
Phytoplankton Index | 59.6489886
Water Quality Index | 38.98366667
Biotic Index | 64.01632953
Bay Health Index | 51.4999981
Spreadsheet: 272700d1382466575-formulas-re-check-or-could-be-a-better-formula-advanced-formula-workbook1-1-
Sheet: Sheet1

Target | Actual | Percentage | Your Output | My Output
1000 | 800 |  | 0
1000 | 820 |  | 12.3
1000 | 900 |  | 67.5
1000 | 950 |  | 118.75
1000 | 1000 |  | 175
1000 | 1100 |  | 313.5
1000 | 1250 |  | 543.75
1000 | 1300 |  | 825.5
1000 | 700 |  | 0
 |  |  |  | [NAME]
 |  |  |  | Percentage | Bonus
 |  |  |  | 0-80% | 0 | 0
 |  |  |  | 81%-90% | 0.75 | 0.75
 |  |  |  | 91%-100% | 0.83333 | 1
 |  |  |  | 101%-110% | 0.95 | 1.1
 |  |  |  | 111% -125% | 0.96666 | 1.5
 |  |  |  | 126 & above | 1.27 | 2
 |  |  |  |  | Revised | Old
 |  |  |  |  | Multiplying | Multiplying
 |  |  |  |  | Factors | Factors
Spreadsheet: 104141d1301784039-excel-2007-need-to-match-data-and-find-missing-my-own-wrksheet
Sheet: Daily Clicks

 | Referral Id | Referral Since | Last Click | 2011-03-31 00:00:00
 | R381066011 | 2011-02-03 00:00:00 | 2011-03-30 00:00:00 | 77
 | R706434262 | 2011-02-12 00:00:00 | 2011-03-26 00:00:00 | 62
 | R211798664 | 2011-02-17 00:00:00 | 2011-03-27 00:00:00 | 56
 | R625254881 | 2011-02-17 00:00:00 | 2011-03-27 00:00:00 | 68
 | R736722731 | 2011-02-17 00:00:00 | 2011-03-29 00:00:00 | 63
 | R116671021 | 2011-02-25 00:00:00 | 2011-03-30 00:00:00 | 49
 | R32274738 | 2011-02-25 00:00:00 | 2011-03-29 00:00:00 | 45
 | R190793213 | 2011-03-02 00:00:00 | 2011-03-28 00:00:00 | 51
 | R499919439 | 2011-03-03 00:00:00 | 2011-03-27 00:00:00 | 34
 | R365730679 | 2011-03-05 00:00:00 | 2011-03-29 00:00:00 | 58
 | R702872742 | 2011-03-07 00:00:00 | 2011-03-29 00:00:00 | 51
 | R503786093 | 2011-03-08 00:00:00 | 2011-03-30 00:00:00 | 59
 | R726330260 | 2011-03-08 00:00:00 | 2011-03-27 00:00:00 | 36
 | R997024027 | 2011-03-08 00:00:00 | 2011-03-30 00:00:00 | 36
 | R450108431 | 2011-03-09 00:00:00 | 2011-03-27 00:00:00 | 31
 | [NAME] | 2011-03-13 00:00:00 | 2011-03-23 00:00:00 | 28
 | R187348970 | 2011-03-13 00:00:00 | 2011-03-27 00:00:00 | 20
 | R240821818 | 2011-03-14 00:00:00 | 2011-03-28 00:00:00 | 23
 | R276515218 | 2011-03-14 00:00:00 | 2011-03-28 00:00:00 | 36
 | R689905083 | 2011-03-15 00:00:00 | 2011-03-28 00:00:00 | 20
 | R56899682 | 2011-03-16 00:00:00 | 2011-03-30 00:00:00 | 36
 | R109718062 | 2011-03-18 00:00:00 | 2011-03-30 00:00:00 | 32
 | R136612190 | 2011-03-18 00:00:00 | 2011-03-26 00:00:00 | 20
 | [NAME] | 2011-03-18 00:00:00 | 2011-03-30 00:00:00 | 16
 | R351331767 | 2011-03-18 00:00:00 | 2011-03-28 00:00:00 | 24
 | R477991926 | 2011-03-18 00:00:00 | 2011-03-26 00:00:00 | 16
 | R484146237 | 2011-03-18 00:00:00 | 2011-03-23 00:00:00 | 20
 | R559281537 | 2011-03-18 00:00:00 | 2011-03-29 00:00:00 | 20
 | R603923031 | 2011-03-18 00:00:00 | 2011-03-26 00:00:00 | 20
 | R61877240 | 2011-03-18 00:00:00 | 2011-03-26 00:00:00 | 16
 | R694858662 | 2011-03-18 00:00:00 | 2011-03-29 00:00:00 | 20
 | R758914652 | 2011-03-18 00:00:00 | 2011-03-29 00:00:00 | 28
 | R852014999 | 2011-03-18 00:00:00 | 2011-03-30 00:00:00 | 24
 | R863474544 | 2011-03-18 00:00:00 | 2011-03-27 00:00:00 | 20
 | R917457990 | 2011-03-18 00:00:00 | 2011-03-27 00:00:00 | 28
 | R925220175 | 2011-03-18 00:00:00 | 2011-03-28 00:00:00 | 24
 | [NAME] | 2011-03-18 00:00:00 | 2011-03-30 00:00:00 | 24
 | R624970696 | 2011-03-19 00:00:00 | 2011-03-30 00:00:00 | 24
 | R834695544 | 2011-03-19 00:00:00 | 2011-03-28 00:00:00 | 24
 | R619921295 | 2011-03-22 00:00:00 | 2011-03-30 00:00:00 | 28
 | R78833418 | 2011-03-24 00:00:00 | 2011-03-28 00:00:00 | 4
 | R201342238 | 2011-03-27 00:00:00 | 2011-03-30 00:00:00 | 12
 | R285939950 | 2011-03-27 00:00:00 | 2011-03-30 00:00:00 | 8
 | R424000667 | 2011-03-27 00:00:00 | 2011-03-29 00:00:00 | 4
 | R560684694 | 2011-03-29 00:00:00 | 2011-03-29 00:00:00 | 4
 | R284337916 | 2011-03-30 00:00:00 | 2001-12-31 00:00:00 | 0
Spreadsheet: phillip_allen__29920__Profit_sharing
Sheet: version 1

Costs |  | 10300000
Equity
Loan
Appraised Value |  | 12000000
LTV % |  | 0.8
Permanent Loan
Permanent Equity |  |  |  |  |  |  |  | 0.15
 |  |  |  |  |  |  |  | Cumulative
 |  |  |  |  |  |  | Cash Avail | Priority | Cash after | Unfunded | Operating Cash Flow |  | Total Cash Flow
Year |  | Equity | NOI(3%) | Debt Service | Cash Flow | Reserve | to Partners | Return | priority | priority | PA & KH | CIS | PA & KH | CIS
1
2 |  |  | 1100000 | -785867
3 |  |  |  | -785867
4 |  |  |  | -785867
5 |  |  |  | -785867
6 |  |  |  | -785867
7 |  |  |  | -785867
8 |  |  |  | -785867
9 |  |  |  | -785867
10 |  |  |  | -785867
11 |  |  |  | -785867
12 |  |  |  | -785867
Spreadsheet: 760974d1640583828-conditional-formatting-rag-icon-changes-based-on-responses-conditional-formatting-1-ans
Sheet: Sheet1

[NAME]. | Time | Is your Investment Paper delayed? Yes/No | Is the delivery of the relevant BPC to Delayed (Yes/No)
Green |  | No | No
Amber |  | Yes | No
Amber |  | No | Yes |  | Unlikely
Red |  | Yes | Yes
[NAME]. | Cost | Do you anticipate there to be any risk to the spend planned to 31/03/22 (RY21/22 in the ABP? | Do you need to forecast spend in the next RY ( RY 2022/23) to complete the project? | Is it factored into the latest ABP Forecast?
Red |  | Yes | Yes | No
Red |  | No | Yes | No
Amber |  | Yes | Yes | Yes
Amber |  | Yes | No | N/A
Green |  | No | No | N/A
Green |  | No | Yes | Yes
[NAME]. | Scope | Has the current scope of the project changed from original BPC? | If yes, is this something which the [NAME] are aware of/has there been engagement with Franchise Management on this?
Green |  | No | - |  | If a no then blank out this cell
Red |  | Yes | No
Amber |  | Yes | Yes
Spreadsheet: 156490d1337308285-timesheet-problem-with-making-certain-time-values-work-timesheet-
Sheet: HoursWorked

 | Date | FRI | SAT | SUN | MON | TUE | WED | THU | TOTAL |  | TRK # | IN | OUT |  | TTL
 | leader1 | 2 | 0 | 8 | 2 | 0 | 0 |  |  |  | 11
 | leader2 | 2 | 0 | 4 | 0 | 5 | 2 |  |  |  | 24
 | leader3 | 0 | 2 | 3 | 2 | 6.5 | 0 |  |  |  | 73
 | helper1 | 2 | 0 | 6 | 2 | 6.5 | 0 |  |  |  | 33
 | helper2 | 0 | 0 | 6 | 2.5 | 10.5 | 0 |  |  |  | 83
 | boss1 | Notes: | district1 |  |  |  |  |  |  |  | Notes:
 | VP
 | leader1 | 4 | 0 | 4 | 0 | 0 | 4.5 |  |  |  | 28
 | leader2 | 0 | 0 | 6 | 0 | 0 | 5.5 |  |  |  | 35
 | leader3 | 0 | 0 | 4 | 2 | 0 | 2 |  |  |  | 178
 | helper1 | 0 | 0 | 2.5 | 0 | 2 | 0 |  |  |  | 151
 | helper2 | 0 | 0 | 2 | 0 | 2.5 | 4.5 |  |  |  | 230
 | boss1 | Notes: | district2 |  |  |  |  |  |  |  | Notes:
 | VP
 | leader1 | 5.5 | 5 | 5 | 6 | 0 | 3 |  |  |  | 25
 | leader2 | 4.5 | 3 | 12 | 3 | 0 | 0 |  |  |  | 20 | 17:00:00 | 18:18:00 |  | 2
 | leader3 | 8.5 | 0 | 8.5 | 3.5 | 2 | 0 |  |  |  | 109
 | helper1 | 8 | 2 | 8.5 | 4.5 | 2.5 | 2 |  |  |  | 36 | 16:30:00 | 18:41:00 |  | 2
 | helper2 | 7.5 | 3.5 | 11.5 | 2 | 2 | 2.5 |  |  |  | 61 | 19:00:00 | 20:25:00 |  | 2
 | boss1 | Notes: | district3 |  |  |  |  |  |  |  | Notes:
 | VP
X | leader1 | 2 | 2 | 7 | 0 | 2 | 0 |  |  |  | 31
 | boss1 | Notes: | [NAME] |  |  |  |  |  |  |  | Notes:
 | vp