tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 129611d1321736484-calculating-vat-6-and-rounding-up-down-calculate-vat-from-price
Sheet: Blad1

Price | VAT
8.8 | 0.49
15.2 | 0.86
16.8 | 0.95
43.2 | 2.44
60.8 | 3.44
What I want is the VAT cells to automatically calculate the VAT (which is 6% in my case) based on the price in the cell that will be on the left side every time.
Then round it either up or down (not sure yet, so would be c00l if you could provide me with both functions). Or as long as the VAT stays be as bove.
Price
8.8 | <-- Choose the cell on the [NAME], calculate the VAT (6%), Round up/down
15.2 | <-- Choose the cell on the [NAME], calculate the VAT (6%), Round up/down
16.8 | <-- Choose the cell on the [NAME], calculate the VAT (6%), Round up/down
43.2 | <-- Choose the cell on the [NAME], calculate the VAT (6%), Round up/down
60.8 | <-- Choose the cell on the [NAME], calculate the VAT (6%), Round up/down
Don't know how to automate the process so it chooses the Price cell on the left, calculate the VAT and then round it either UP or DOWN.
The function below will calculate the VAT, but this cant be used since it isnt working on auto.
Price | VAT
8.8 | 0.4981132075471706
15.2 | 0.8603773584905667
16.8 | 0.9509433962264158
43.2 | 2.445283018867926
60.8 | 3.441509433962267
 | ^ As you can see, I choose the cell manually. Which is taking a lot of time, Hehe.
Spreadsheet: 293537d1391016180-protect-an-excel-sheet-test
Sheet: Sheet1

 | A | B | C | D |  | SAM
SAM | x | x | x
PAT |  |  | x | x
FAT | x | x |  | x
[NAME] |  | x |  | x
VAT | x | x | x | x
Spreadsheet: 45b0449f-b150-42c3-af32-b54bc19812c4
Sheet: Sheet1

１　　　　　　全　　　　国　       統　　　　計 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
(1)　　　年次別統計（平成９年～19年）
ウ　　主 要 漁 業 種 類 ･ 魚 種 別 漁 獲 量
（ニ）  遠  洋  か  つ  お  一  本  釣
 |  |  |  |  |  |  | 単位：ｔ
年次 | 計 | くろまぐろ | びんなが | めばち | きはだ | [NAME] | そうだ がつお類 | 年次
 |  | 1)まぐろ
平．９ | 94386 | - | 24948 | 618 | 345 | 67482 | 3 | 平．９
10 | 94162 | - | 15815 | 153 | 364 | 76797 | 2 | 10
11 | 108957 | 16 | 42968 | 277 | 381 | 64273 | - | 11
12 | 97552 | 0 | 20375 | 290 | 623 | 76010 | 1 | 12
13 | 81418 | 0 | 27365 | 147 | 519 | 53120 | 4 | 13
14 | 98421 | 2 | 43011 | 572 | 642 | 54083 | 4 | 14
15 | 97488 | 0 | 31931 | 148 | 472 | 64637 | 1 | 15
16 | 86762 | 12 | 21072 | 1276 | 745 | 63034 | 1 | 16
17 | 90795 | 35 | 13774 | 588 | 431 | 75670 | 5 | 17
18 | 66257 | 0 | 9471 | 1333 | 721 | 54630 | 1 | 18
19 | 76560 | 3 | 19494 | 474 | 646 | 55771 | 9 | 19
Spreadsheet: 868732d1715400485-work-time-difference-between-two-dates-with-conditions-work-time-ans-2
Sheet: Folha1

Process | Cliente | Ref | Start date | Origin | End Date | Destination | Vehicle | Pax | Driver | Contract | Price | Corrected Start Hour | Corrected End Hour | Time work | Column1 | Column2
 |  |  | 09/05/2024 03:30:00 |  | 09/05/2024 04:30:00 |  |  | 2 | [NAME] |  |  | 03:30:00 | 04:30:00
 |  |  | 09/05/2024 05:00:00 |  | 09/05/2024 06:00:00 |  |  | 2 | Sonia Amaral |  |  |  |  |  |  |  |  | Should be
 |  |  | 09/05/2024 06:15:00 |  | 09/05/2024 07:30:00 |  |  | 4 | [NAME] |  |  | 06:15:00 | 13:00:00 |  |  |  |  | 09:30:00
 |  |  | 09/05/2024 [NAME] |  | 09/05/2024 07:30:00 |  |  | 2 | Sonia Amaral
 |  |  | 09/05/2024 08:50:00 |  | 09/05/2024 10:30:00 |  |  | 6 | [NAME] |  |  | 08:50:00 | 11:00:00
 |  |  | 09/05/2024 09:45:00 |  | 09/05/2024 16:30:00 |  |  | 4 | Sonia Amaral
 |  |  | 10/05/2024 10:45:00 |  | 10/05/2024 11:45:00 |  |  | 6 | [NAME] |  |  | 10:45:00 | 13:00:00
Total
Spreadsheet: 115585d1311165549-lookup-according-to-current-month-and-lead-time-planner
Sheet: PLANNER

Part No. |  | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | 2011-07-01 00:00:00 | 2011-08-01 00:00:00 | 2011-09-01 00:00:00 | 2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00 | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00
[NAME] 1
Qty in Stock | [NAME] | 0 | 0 | 0 | 0 | 349.6666666666667 | 349.6666666666667 | 349.6666666666667 | 349.6666666666667 | 349.6666666666667 | 349.6666666666667 | 349.6666666666667 | 349.6666666666667 | 349.6666666666667 | 349.6666666666667 | 349.6666666666667
2002 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
CBM | Purchase Orders |  |  | 0 | 769 | 24 | 840 | 0 | 420 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0.123 | 4196
[NAME] | Closing Stock | 2002 | 2002 | 2002 | 2002 | 2002 | 2002 | 2002 | 2072.333333333333 | 1722.666666666666 | 1373 | 1023.333333333333 | 673.6666666666661 | 323.9999999999994 | -25.66666666666731 | -375.333333333334
84 | Qty to Order | 0 | 0 | 0 | 0 | 168 | 168 | 168 | 84 | 420 | 756 | 1092 | 1428 | 1848 | 2184 | 2520
[NAME] 2
Qty in Stock | [NAME] | 0 | 0 | 0 | 0 | 85.5 | 85.5 | 85.5 | 85.5 | 85.5 | 85.5 | 85.5 | 85.5 | 85.5 | 85.5 | 85.5
512 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
CBM | Purchase Orders |  |  | 0 | 0 | 0 | 160 | 0 | 160 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0.245 | 1026
[NAME] | Closing Stock | 512 | 512 | 512 | 512 | 512 | 512 | 512 | 586.5 | 501 | 415.5 | 330 | 244.5 | 159 | 73.5 | -12
80 | Qty to Order | 0 | 0 | 0 | 0 | 240 | 240 | 240 | 160 | 240 | 320 | 400 | 480 | 560 | 640 | 720
[NAME] 3
Qty in Stock | [NAME] | 0 | 0 | 0 | 0 | 53.33333333333334 | 53.33333333333334 | 53.33333333333334 | 53.33333333333334 | 53.33333333333334 | 53.33333333333334 | 53.33333333333334 | 53.33333333333334 | 53.33333333333334 | 53.33333333333334 | 53.33333333333334
332 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
CBM | Purchase Orders |  |  | 0 | 0 | 0 | 0 | 0 | 72 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0.064 | 640
[NAME] | Closing Stock | 332 | 332 | 332 | 332 | 332 | 332 | 332 | 350.6666666666667 | 297.3333333333334 | 244 | 190.6666666666667 | 137.3333333333333 | 84 | 30.66666666666666 | -22.66666666666667
72 | Qty to Order | 0 | 0 | 0 | 0 | 144 | 144 | 144 | 144 | 144 | 216 | 288 | 360 | 360 | 432 | 504
[NAME]
Qty in Stock | [NAME] | 0 | 0 | 0 | 0 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16
118 | 14 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
CBM | Purchase Orders |  |  | 0 | 0 | 0 | 60 | 0 | 60 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0.156 | 192
[NAME] | Closing Stock | 118 | 118 | 118 | 118 | 118 | 118 | 118 | 162 | 146 | 130 | 114 | 98 | 82 | 66 | 50
60 | Qty to Order | 0 | 0 | 0 | 0 | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 180 | 180 | 180 | 180
Spreadsheet: 40639d1239036747-excel-2007-vlookup-decimal-problem-cubic-to-square-meter-price
Sheet: Sheet1

Thickness | m3 price | 1000 | £[NAME] | Profit | Total Cost |  |  | 3050x1220 | 2440x1220 | 2400x1200 | 2400x600 | 1200x600
12 | 375 |  |  | 0.09 |  |  | M2 Per sheet | 3.72 | 2.97 | 2.88 | 1.44 | 0.72
12 |  |  | 4.5
m3 after
 |  |  |  |  |  |  | Board [NAME] | 1 | 2 | 3 | 4 | 5
Delivery Area
Board [NAME] | 3
Delivery
M2 for Project | Cost |  | Profit | Total |  |  |  | Thickness | Brds Per pallet |  | Pallets | Delivery Rate
6000 |  |  |  |  |  |  |  | 8 | 60 |  | 0.1 | 90
 |  |  |  |  |  |  |  | 10 | 54 |  | 0.2 | 130
 |  |  |  |  |  |  |  | 12 | 45 |  | 0.3 | 160
Pallet Size |  |  |  |  |  |  |  | 16 | 35 |  | 0.4 | 200
Number Pallets |  |  |  |  |  |  |  | 18 | 30 |  | 0.5 | 210
[NAME] |  |  |  |  |  |  |  |  |  |  | 0.6 | 230
 |  |  |  |  |  |  |  |  |  |  | 0.7 | 300
 |  |  |  |  |  |  |  |  |  |  | 0.8 | 350
 |  |  |  |  |  |  |  |  |  |  | 0.9 | 400
Spreadsheet: 43641d1242287751-copy-x-cell-value-evey-nth-cell-along-on-same-row-test_offset
Sheet: Sheet1

 |  | initial value | Frequency | multiplier | Offset | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019
 | item 1 | 500 | 1 | 250 | 0 | 125000 | 125000 | 125000 | 125000 | 125000 | 125000 | 125000 | 125000 | 125000 | 125000
 | item 2 | 500 | 2 | 250 | 0 | 0 | 125000 | 0 | 125000 | 0 | 125000 | 0 | 125000 | 0 | 125000
 | item 3 | 500 | 2 | 250 | 2 | 0 |  | 125000 |  | 125000 |  | 125000 |  | 125000
Spreadsheet: andy_zipper__461__11_26_01ON
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | NG Z1 | 265 | 13 | 15 | 117.4 | 135.5 | 21.07 | 2001-11-26 10:06:00
 | NG F2 | 285 | 57 | 62 | 87.9 | 95.7 | 16.45 | 2001-11-26 10:06:00
 | NG G2 | 290 | 76 | 81 | 80 | 85.3 | 15.07 | 2001-11-26 10:06:00
 | NG H2 | 285 | 79 | 83 | 70.6 | 74.3 | 12.98 | 2001-11-26 10:06:00
 | NG J2 | 280 | 74 | 79 | 59 | 63.1 | 10.75 | 2001-11-26 10:06:00
 | NG K2 | 285 | 77 | 82 | 54 | 57.5 | 9.99 | 2001-11-26 10:06:00
 | NG M2 | 290 | 84 | 89 | 52.7 | 55.9 | 9.9 | 2001-11-26 10:06:00
 | NG N2 | 290 | 89 | 97 | 52.2 | 57 | 9.95 | 2001-11-26 10:06:00
 | NG Q2 | 295 | 95 | 101 | 51.3 | 54.6 | 9.82 | 2001-11-26 10:06:00
 | NG U2 | 300 | 101 | 107 | 50.7 | 53.8 | 9.85 | 2001-11-26 10:06:00
 | NG V2 | 300 | 107 | 113 | 51.3 | 54.3 | 9.96 | 2001-11-26 10:06:00
 | NG X2 | 315 | 116 | 125 | 50.6 | 54.6 | 10.42 | 2001-11-26 10:06:00
 | [NAME] |  |  |  |  |  |  | 2001-11-20 14:50:00
 | NG H3 |  |  |  |  |  |  | 2001-11-19 14:44:00
 | NG M3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG U3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG Z3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG H4 |  |  |  |  |  |  | 2001-09-17 07:55:00
Spreadsheet: 4c2d7818-ab1c-46c6-9fa9-d0601a6529fc
Sheet: S- M+ T+

Annotations of sequences producing negative Structural (S-), positive MCP (M+), and positive [NAME] (T+) ANN outputs.
Annotations | Structural | MCP_One | MCP_Two | MCP_Three | MCP_Four | MCP_Seven | MCP_Lambda | Tail_One | Tail_Two | Tail_Three | Tail_Four | Tail_Seven | Tail_Lambda | Standard Error | MCP_One | MCP_Two | MCP_Three | MCP_Four | MCP_Seven | MCP_Lambda | Tail_One | Tail_Two | Tail_Three | Tail_Four | Tail_Seven | Tail_Lambda
>gi|326203801|ref|ZP_08193663.1| phage major capsid protein, HK97 family [Clostridium papyrosolvens DSM 2782] | -0.280554 | 0.83771 | 0.76334 | 0.67661 | 0.78194 | 0.47777 | 0.33695 | 0.21557 | -0.16288 | -0.49773 | -0.47701 | -0.47243 | -0.50656 |  | 0.1199 | 0.17882 | 0.084183 | 0.098067 | 0.19565 | 0.39029 | 0.29065 | 0.34419 | 0.29226 | 0.24439 | 0.21188 | 0.17849
>gi|333994198|ref|YP_004526811.1| phage major capsid protein, HK97 family [Treponema azotonutricium ZAS-9] | -0.469513 | 0.39513 | 0.13322 | 0.14525 | -0.045618 | -0.51573 | -0.70073 | 0.22684 | -0.11925 | -0.31828 | -0.4203 | -0.52044 | -0.53105 |  | 0.30244 | 0.47612 | 0.27498 | 0.36704 | 0.23759 | 0.15205 | 0.23238 | 0.16588 | 0.35571 | 0.24804 | 0.1779 | 0.16997
>gi|331082099|ref|ZP_08331227.1| HK97 family phage major capsid protein [[NAME] bacterium 6_1_63FAA] | -0.242404 | 0.27971 | 0.053608 | -0.13271 | -0.14127 | -0.53232 | -0.86819 | 0.22463 | -0.08753 | -0.2576 | -0.51177 | -0.60269 | -0.59674 |  | 0.35759 | 0.30035 | 0.34894 | 0.34354 | 0.14057 | 0.12258 | 0.15014 | 0.39898 | 0.43653 | 0.24688 | 0.21565 | 0.19295
>gi|331270734|ref|YP_004397328.1| major capsid protein [Clostridium botulinum BKT015925] | -0.272409 | 0.6291 | 0.2935 | 0.037518 | 0.097808 | -0.35318 | -0.60706 | 0.66922 | 0.53497 | 0.28261 | 0.17203 | -0.039218 | -0.035431 |  | 0.15919 | 0.4046 | 0.1891 | 0.45434 | 0.19886 | 0.43497 | 0.15435 | 0.17181 | 0.38089 | 0.23153 | 0.23595 | 0.22682
>gi|326797409|ref|YP_004315229.1| major tail tube protein [Marinomonas mediterranea MMB-1] | -0.625494 | 0.8535 | 0.79658 | 0.59182 | 0.65692 | 0.41355 | -0.048305 | 0.48372 | 0.30379 | 0.22013 | -0.13117 | -0.28795 | -0.2264 |  | 0.083621 | 0.10277 | 0.12188 | 0.32428 | 0.20379 | 0.33006 | 0.13219 | 0.16471 | 0.33339 | 0.32084 | 0.1948 | 0.221
Spreadsheet: 819719d1677667160-help-with-complicated-formula-cant-figure-out-why-it-works-so-inconsistently-testing
Sheet: OUTPUT

 | Datum | Opis | Konto | Stranka | Analitika | [NAME] | Zapadlost | [NAME] | Veza | DE | Breme originalna DE | Dobro originalna DE | Breme domača DE | Dobro domača DE | ID transakcije
1
Spreadsheet: 167943d1342164919-i-want-to-send-data-in-multiple-workbook-projcet-05-expense-ledger
Sheet: Supplier-Sami

 |  |  |  |  |  | PROJECT # 05
 |  |  | Supplier-Sand |  |  | Mr.[NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22000 | 33000 | -11000
 |  |  |  |  |  |  |  |  |  |  |  |  |  | A/C Ref #
DATE | B# | P# | L# | V# | A/C | Description | [NAME]# | Qty | Rate | Cheq#/PS | Bank | Book# | [NAME]# | Page# | Ledger# | DEBIT | CREDIT | BALANCE
2011-11-16 00:00:00 | 1 | 25 | CL-10 |  | Material | [NAME],[NAME] | 727 | 1 | 11000 |  |  |  |  |  |  |  | 11000 | -11000
2011-11-16 00:00:00 | 2 | 25 | CL-10 |  | Material | [NAME],[NAME] | 728 | 1 | 11000 |  |  |  |  |  |  |  | 11000 | -22000
2011-11-27 00:00:00 | 3 | 25 | CL-10 |  | Material | [NAME],[NAME] | 745 | 1 | 11000 |  |  |  |  |  |  |  | 11000 | -33000
2011-12-01 00:00:00 | V-01 | 25 | CL-10 |  | Payment | Cheque Paid |  |  |  | 57053500 | HMB | A-6 |  | 85 | BL-02 | 22000 |  | -11000
Spreadsheet: 871157d1717574398-percent-rank-of-an-array-percentrank-aligw
Sheet: Sheet1

 |  | Style Pnts | Surface | Distance | Class |  | PercentRank
 | 1 | 3 | 0.47 | 0 | 0.56
 | 2 | 7 | 0.4 | 0 | 0 |  | 0.8
 | 3 | 0 | 0.44 | 0.56 | 0.5 |  | 0
 | 4
 | 5 | 3 | 0.5 | 0 | 0.83 |  | 0.6
 | 6 | 0 | 0.72 | 0.67 | 0.72 |  | 0.2
 | 7 | 7 | 0.45 | 0.6 | 0.5 |  | 1
Spreadsheet: sally_beck__33824__global standards daily reporting
Sheet: A 02

Quantitative Standards
Daily Exception Reports
Reports Supporting Quantitative Standards A
Report A 02:
Purpose: | To capture transactions that had to be revalued.
Deal # | Date deal was done | Date deal was revalued/ reinput | Description of deal | Quantity | Effect of revaluation gain/ (loss) (state curr) | Reason for revaluation | Key contact (book admin)
Sample | 2000-10-25 00:00:00 | 2000-10-29 00:00:00 | 30 year Brent WTI SWAP | 3000 tons crude per month | 1500000 | Previously, only had 20 of 30 years valued | [NAME]
Spreadsheet: 51752d1251371380-index-and-match-price-lap
Sheet: price lap

 | SUPPLIER
 |  |  | Cuba
 | color |  | size | price
1
2
3
4
5
6
7
8
9
10
Spreadsheet: 200132d1355423953-look-up-across-several-columns-same-row-and-return-value-in-another-cell-lookup-test-file
Sheet: Participation

1 | 2 | 4 | 6 | 8 | 10 | 12 | 14 | 16 | 18 | 20
 |  | Tier | Tier | Tier | Tier | Tier | Tier | Tier | Tier | Tier
MS60261 | Vendor 1 | 2 | 2 | 2 | 2 | 2 | 4 | 5 | 2 | 2
MS60262 | Vendor 2 | 1 | 1 | 1 | 2 | 1 | 1 | 2 | 3 | 1
MS60263 | Vendor 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
CE91091 | Vendor 4 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
CE91092 | Vendor 5 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
MS0293 | Vendor 6 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
MS0292 | Vendor 7 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
Spreadsheet: 646567d1571916322-help-to-count-cells-on-sheets-with-changing-names-example-1
Sheet: TIME SHEET

site name
 |  |  |  |  | sheet name: | 2209
Week Ending | Mon | [NAME] | Wed | Thur | Fri | Sat | Sun | Sub Total | B/Hol | T/Hours | Hols | Notes
20th Oct 2010 | 2019-10-14 00:00:00 | 2019-10-15 00:00:00 | 2019-10-16 00:00:00 | 2019-10-17 00:00:00 | 2019-10-18 00:00:00 | 2019-10-19 00:00:00 | 2019-10-20 00:00:00
Name A |  |  |  |  |  |  |  |  |  |  |  | add 12hr due to error
Name B
Name C
Name D |  |  |  |  |  |  |  |  |  |  |  | deduct 12hr due to error
Name E
Name F
Spreadsheet: 847921d1698764770-summarize-data-on-multiple-sheets-to-one-sheet-corrected-sample
Sheet: Fruit Delivery

Date | Name | Qty | Price | Amount |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Name | QTY | PRICE | AMOUNT
2023-10-01 00:00:00
2023-10-02 00:00:00
2023-10-03 00:00:00
2023-10-04 00:00:00
2023-10-05 00:00:00 | Apple | 100 | 5
2023-10-06 00:00:00
2023-10-07 00:00:00
2023-10-08 00:00:00 | [NAME] | 500 | 2
2023-10-09 00:00:00
2023-10-10 00:00:00 | Pear | 50 | 3
2023-10-11 00:00:00
2023-10-12 00:00:00
2023-10-13 00:00:00
2023-10-14 00:00:00
2023-10-15 00:00:00
2023-10-16 00:00:00
2023-10-17 00:00:00 | Grapes | 200 | 2
2023-10-18 00:00:00
2023-10-19 00:00:00
2023-10-20 00:00:00
2023-10-21 00:00:00 | Watermelon | 60 | 4
2023-10-22 00:00:00
2023-10-23 00:00:00
2023-10-24 00:00:00
2023-10-25 00:00:00
2023-10-26 00:00:00
2023-10-27 00:00:00
2023-10-28 00:00:00
2023-10-29 00:00:00
2023-10-30 00:00:00
2023-10-31 00:00:00
Spreadsheet: 106318d1303489471-excel-2007-calculating-from-one-sheet-to-another-excel-help
Sheet: NEBOSH

NEBOSH National Certificate in Occupational Health & Safety
Candidate Name | U.I.D. | Course Fee | Exam Reg Fee | Date | Buy Online | Payment Plan | 2nd Payment | 3rd Payment | [NAME]
Customer 1 | WGT047 | 395 |  | 2011-03-18 00:00:00 |  |  |  |  | Requests Exams in Hull
Customer 2 | WGT055 | 395 |  | 2011-03-25 00:00:00 |  |  |  |  | `
Customer 3 | WGT058 | 395 |  | 2011-03-31 00:00:00 |  |  | 2011-04-29 00:00:00 | 2011-05-31 00:00:00
NGC Totals:
Spreadsheet: 60350d1260906320-auto-copy-part-of-row-in-a-worksheet-to-another-worksheet-based-on-criteria-case-assignments2010-temp
Sheet: Feb2010

 | Week 1 |  |  |  | Week 2 |  |  |  | Week 3 |  |  |  | Week 4 |  |  |  | Week 5
 | Eval | Defendant | Offense | Code | Eval | Defendant | Offense | Code | Eval | Defendant | Offense | Code | Eval | Defendant | Offense | Code | Eval | Defendant | Offense | Code
 | 2010-02-01 00:00:00 |  |  |  | 2010-02-08 00:00:00 |  |  |  | 2010-02-15 00:00:00 |  |  |  | 2010-02-22 00:00:00 |  |  |  | Monday
1 |  |  |  |  |  |  |  |  |  | Holiday
2
3
4
5
6
7
8
9
 | 2010-02-02 00:00:00 |  |  |  | 2010-02-09 00:00:00 |  |  |  | 2010-02-16 00:00:00 |  |  |  | 2010-02-23 00:00:00 |  |  |  | Tuesday
1
2
3
4
5
6
7
8
9
 | 2010-02-03 00:00:00 |  |  |  | 2010-02-10 00:00:00 |  |  |  | 2010-02-17 00:00:00 |  |  |  | 2010-02-24 00:00:00 |  |  |  | Wednesday
1
2
3
4
5
6
7
8
9
 | 2010-02-04 00:00:00 |  |  |  | 2010-02-11 00:00:00 |  |  |  | 2010-02-17 00:00:00 |  |  |  | 2010-02-25 00:00:00 |  |  |  | Thursday
1
2
3
4
5
6
7
8
9
 | 2010-02-05 00:00:00 |  |  |  | 2010-02-12 00:00:00 |  |  |  | 2010-02-18 00:00:00 |  |  |  | 2010-02-26 00:00:00 |  |  |  | Friday
1
2
3
4
5
6
7
8
9
Spreadsheet: 842378d1694473608-help-with-ifs-statements-cpp-test-spreadsheet
Sheet: Sheet1

 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
Income | 1000 | 1200 | 900 | 1000 | 1100 | 850 | 950 | 1000 | 1150 | 1200 | 950 | 1000 |  | Tax Rate
CPP |  |  |  |  |  |  |  |  | 23.27 |  |  |  |  | 0.0559
Overflow |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
YTD |  |  |  |  |  |  |  |  |  |  |  |  |  | 450
 | 1. if the SUM of the YTD is < O5 ([NAME] amount)  "do nothing"
 | 2. if the SUM of the YTD is > O5 ([NAME] amount) AND < the SUM of the YTD + the next month (only the one where it pass the $450.00 (MAX amount)
 | 3. if the SUM of the YTD is > OS ([NAME] amount) multiply MONTH INCOME by [NAME] (tax rate)
Spreadsheet: 846286d1697550729-calculating-hours-worked-overtime-workbook-with-formulas
Sheet: Alan Semester 1

You must use the format HH:[NAME] (ie 09:00 or 17:00) when entering your time. It reformats the cell if you use any other way (ie 9 or 17 or 9.00 ect) this will change the calculations and the sheet won't be correct.
 |  | Enter start time: 24hr clock | Enter time work over lunch. ie 00:30 minuets worked | Enter finish time: 24hr clock | Hours worked | Running total of overtime. | Enter time taken back as hours:minutes | Final running total of overtime
Date | Day | Start | Lunch | Finish | Hours | Overtime | Time taken back | Total
2027-09-19 00:00:00 | Mon
2027-09-20 00:00:00 | Tue
2027-09-21 00:00:00 | Wed
2027-09-22 00:00:00 | Thu
2027-09-23 00:00:00 | Fri
2027-09-24 00:00:00 | Sat
2027-09-25 00:00:00 | Sun
2027-09-26 00:00:00 | Mon
2027-09-27 00:00:00 | Tue
2027-09-28 00:00:00 | Wed
2027-09-29 00:00:00 | Thu
2027-09-30 00:00:00 | Fri
2027-10-01 00:00:00 | Sat
2027-10-02 00:00:00 | Sun
2027-10-03 00:00:00 | Mon
2027-10-04 00:00:00 | Tue
2027-10-05 00:00:00 | Wed
2027-10-06 00:00:00 | Thu
2027-10-07 00:00:00 | Fri
2027-10-08 00:00:00 | Sat
2027-10-09 00:00:00 | Sun
2027-10-10 00:00:00 | Mon
2027-10-11 00:00:00 | Tue
2027-10-12 00:00:00 | Wed
2027-10-13 00:00:00 | Thu
2027-10-14 00:00:00 | Fri
2027-10-15 00:00:00 | Sat
2027-10-16 00:00:00 | Sun
2027-10-17 00:00:00 | Mon
2027-10-18 00:00:00 | Tue
2027-10-19 00:00:00 | Wed
2027-10-20 00:00:00 | Thu
2027-10-21 00:00:00 | Fri
2027-10-22 00:00:00 | Sat
2027-10-23 00:00:00 | Sun
2027-10-24 00:00:00 | Mon
2027-10-25 00:00:00 | Tue
2027-10-26 00:00:00 | Wed
2027-10-27 00:00:00 | Thu
2027-10-28 00:00:00 | Fri
2027-10-29 00:00:00 | Sat
2027-10-30 00:00:00 | Sun
2027-10-31 00:00:00 | Mon
2027-11-01 00:00:00 | Tue
2027-11-02 00:00:00 | Wed
2027-11-03 00:00:00 | Thu
2027-11-04 00:00:00 | Fri
2027-11-05 00:00:00 | Sat
2027-11-06 00:00:00 | Sun
2027-11-07 00:00:00 | Mon
2027-11-08 00:00:00 | Tue
2027-11-09 00:00:00 | Wed
2027-11-10 00:00:00 | Thu
2027-11-11 00:00:00 | Fri
2027-11-12 00:00:00 | Sat
2027-11-13 00:00:00 | Sun
2027-11-14 00:00:00 | Mon
2027-11-15 00:00:00 | Tue
2027-11-16 00:00:00 | Wed
2027-11-17 00:00:00 | Thu
2027-11-18 00:00:00 | Fri
2027-11-19 00:00:00 | Sat
2027-11-20 00:00:00 | Sun
2027-11-21 00:00:00 | Mon
2027-11-22 00:00:00 | Tue
2027-11-23 00:00:00 | Wed
2027-11-24 00:00:00 | Thu
2027-11-25 00:00:00 | Fri
2027-11-26 00:00:00 | Sat
2027-11-27 00:00:00 | Sun
2027-11-28 00:00:00 | Mon
2027-11-29 00:00:00 | Tue
2027-11-30 00:00:00 | Wed
2027-12-01 00:00:00 | Thu
2027-12-02 00:00:00 | Fri
Spreadsheet: louise_kitchen__22685__Development Site Deal List
Sheet: Sheet1

Development Site Sales
Deal Name | Commercial Lead | Customer | Region | Prob. (%) | Deal Description | Initial Cost Basis | Price | Status/ Follow-up | Status | Date of Last Contact | Completion Date | Margin
COMPLETED:
PLANO | Mitro | PSEG | MAIN | Done | Exclusivity premium for Plano, IL site | 250000 |  |  | Done |  | Q1 | 300000
DOYLE | Tapscott | Doyle | SERC | Done | Distribution from Doyle I, L.L.C. | 1000000 |  |  | Done |  | Q1 | 1684000
HAYWOOD | Booth | AES | SERC | Done | Enron flips Haywood development site to AES with milestone payment for Interconnect Agreement with TVA. | 250000 | 540 MW |  | $5 million received and recognized in Q4 of '00. |  | Q2 | 2734000
HAYWOOD | Booth | AES | SERC | Done | Enron flips Haywood development site to AES -- amendment signed giving Enron an additional $2 MM upside. | 250000 | 540 MW |  | Total realized deal value to date of $9.6 million. Additional $2 million expected in Q4 upon execution of interconnect agreement between TVA and AES. |  | Q3 | 2110000
Total Q1 to Q3 Actuals
PENDING (GREATER THAN 50% PROBABILITY OF CLOSING):
DOYLE | Tapscott | [NAME] | SERC | 0.9 | Enron sells its 50% equity interest in the [NAME] project in Georgia to project partner, [NAME]. | 1000000 | 83 MW |  | Final negotiation of definitive documents.  Upon close, total gross margin realized from [NAME] will be approximately $4.7 million. |  | Q4 | 3000000
HAYWOOD | Booth | AES | SERC | 0.9 | Final milestone payment from AES related to Haywood site sale, due upon execution of Interconnect Agreement between AES and TVA. | 250000 | 119 MW |  | Upon achievement of milestone, total deal value realized will be $11.6 million. |  | Q4 | 2000000
ONONDAGA | Mitro | Various | NPCC | 0.75 | Sale of Enron's cash flow interest in Onondaga plant. | 6900000 |  |  | Have received expressions of interest from two buyers, with an average purchase price of $10 million. In process of negotiating definitive term sheet. |  | Q4 | 3000000
GEORGIA | [NAME] | Calpine | SERC | 0.5 | Sale of Hartwell and Athens, GA sites. | 500000 | 83 MW |  | Have provided definitive documents to Calpine reflecting term sheet executed in Q3. Upon closing, deal is expected to provide $1 million of Q4 income, and up to $7 million in additional milestone payments to be received through Q3 of next year. |  | Q4 | 1000000
MIDWAY | Krause | Various | FRCC | 0.5 | Sale of Midway, Florida site | 1300000 | 119 MW |  | Have issued investment memorandum to various interested parties. Also negotiating tolling arrangements, and have submitted bid into FPL's RFP as an alternative to site sale. Probability % reflects likelihood of Q4 closing only. Q1 closing increases probability to 75%. |  | Q4 | 7000000
Total Projected Q4 (not probability adjusted)
Total Projected Q1 to Q4