tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 773632d1647965533-suggestions-with-random-groups-book3
Sheet: Sheet1

Student | Score | Quartile |  |  | Q1 | Q2 | Q3 | Q4
a | 90 |  |  | Group1
b | 86 |  |  | Group2
c | 39 |  |  | Group3
d | 27 |  |  | Group4
e | 38 |  |  | Group5
f | 51
g | 49
h | 87
i | 78
j | 5
k | 17
l | 85
m | 74
n | 25
o | 47
p | 36
q | 16
r | 76
s | 2
t | 39
Spreadsheet: 738079d1624810167-delete-all-double-data-copy-of-exampleexcel
Sheet: Sheet1

id | first_name | last_name | profile_link | job_title | company_name | email | phone | address | image_link | tags | contact_status | conversation_status | object_urn | public_identifier | profile_link_public_identifier | last_received_message | last_sent_message | thread | invited_at | connected_at | company_universal_name | company_website | employee_count_start | employee_count_end | industries | location
Spreadsheet: 84411d1284471571-excel-2007-2007-conversion-function-loss-excel-2007-form-test
Sheet: Un-Locked Form1

 |  |  |  | XXXXXXXXX |  | XXXXXXXXX |  | XXXXXXXXX |  | XXXXXXXXX |  | XXXXXXXX
YOUR |  |  |  | TEL # HERE |  | TEL # HERE |  | TEL # HERE |  | TEL # HERE
 |  |  |  | XXXXXXXXX |  | XXXXXXXXX |  | XXXXXXXXX |  | XXXXXXXXX |  | XXXXXXXX
 |  |  |  | TEL # HERE |  | TEL # HERE |  | TEL # HERE |  | TEL # HERE
 |  |  |  | XXXXXXXXX |  | XXXXXXXXX |  | XXXXXXXXX |  | XXXXXXXXX |  | XXXXXXXX
 |  |  |  | TEL # HERE |  | TEL # HERE |  | TEL # HERE |  | TEL # HERE
LOGO HERE |  |  |  |  |  |  |  |  |  |  |  |  | XXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXX
[NAME] |  |  |  |  |  |  |  | XXXXXXXXXXXXXXX
XXXXXXXXXXXXXXX |  |  |  |  |  |  |  | XXXXXXXXXXXXXXX
[NAME] |  |  |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  |  |  | XXXXXXXXXXXXXX
[NAME] |  |  |  |  |  | [NAME] |  |  |  | [NAME]
[NAME] |  |  |  |  | [NAME] |  |  |  |  | [NAME] |  |  | XXXXXXXXXXXXXXXXXXXX
[NAME] |  |  |  | [NAME] |  |  |  |  |  | [NAME] |  |  |  |  |  | XXXXX
[NAME] |  |  |  | [NAME] |  |  |  |  |  | [NAME] |  |  |  |  |  | XXXXX
[NAME] |  |  |  | [NAME] |  |  |  |  |  | [NAME] |  |  |  |  |  | XXXXX
[NAME] |  |  |  | [NAME] |  |  |  |  |  | [NAME] |  |  |  |  |  | XXXXX
XXXXXXXXXXXXXXXXXXXXXX
[NAME]
[NAME]
XXXXXX
XXXXXXXXXXXXXX |  |  |  | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXX |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  | [NAME]
XXXXXXXXXXXXXXX |  |  |  |  |  |  |  |  | [NAME]
XXXXXXXXXXXXX |  | Start | Stop | Suspend | [NAME] |  | XXXXXXXXXXXX |  | X | X | X | X |  | XXXXXXXXX |  | X | X | X | X
XXXXXXXXXXXXX |  |  |  |  |  |  | XXXXXXXXXXXX |  |  |  |  |  |  | XXXXXXXXX
XXXXXXXXXXXXX |  |  |  |  |  |  | XXXXXXXXXXXX |  |  |  |  |  |  | XXXXXXXXX
XXXXXXXXXXXXX |  |  |  |  |  |  | XXXXXXXXXXXX |  |  |  |  |  |  | XXXXXXXXX
XXXXXXXXXXXXX |  |  |  |  |  |  | XXXXXXXXXXXX |  |  |  |  |  |  | XXXXXXXXX
XXXXXXXXXXXXX |  |  |  |  |  |  | XXXXXXXXXXXX |  |  |  |  |  |  | XXXXXXXXX
 |  |  |  |  | XXXXXXXXXXXXXXXXXXXXXXXXXXXXX
 |  |  |  |  |  |  |  |  |  |  | False
XXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | XXXXX
Spreadsheet: 848726d1699378603-combine-aggregated-lists-in-to-a-separate-combined-list-aggregated-lists
Sheet: Desired Output

Ref No | Vehicle | Colour
ABC008 | Car | YELLOW
ABC009 | Car | YELLOW
ABC007 | Car | YELLOW
ABC013 | Car | YELLOW
ABC003 | Train | BLUE
ABC001 | Train | BLUE
Spreadsheet: 0a7c9e99-0b84-44de-bd63-5d1ae5db9c24
Sheet: Sheet1

Democratic | First Congressional District | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
2000-09-12 00:00:00 | [NAME], d | [NAME], d | [NAME]
Albany | 26 | 0 | 1
Alton | 143 | 0 | 1
Auburn | 220 | 0 | 0
[NAME] | 341 | 1 | 1
Barnstead | 177 | 0 | 1
[NAME] | 109 | 0 | 0
Bedford | 701 | 4 | 4
Belmont | 200 | 1 | 3
Brentwood | 118 | 0 | 0
[NAME] | 25 | 0 | 0
Candia | 170 | 0 | 0
Center Harbor | 60 | 0 | 1
Chatham | 7 | 0 | 1
Chester | 98 | 1 | 1
Conway | 264 | 2 | 6
Danville | 117 | 1
[NAME] | 169 | 0 | 1
[NAME] | 788 | 0 | 0
[NAME] | 286 | 2 | 0
[NAME] | 195 | 1 | 1
[NAME] | 366 | 1 | 0
[NAME] | 328 | 1 | 1
[NAME] | 263 | 0 | 1
[NAME] 6 | 273 | 0 | 0
[NAME] | 664 | 1 | 7
East Kingston | 60 | 0 | 0
Eaton | 17 | 1 | 1
[NAME] | 47 | 0 | 0
Epping | 215 | 0 | 3
[NAME] | 193 | 0 | 0
Exeter | 704 | 2 | 2
Farmington | 225 | 0 | 2
Freedom | 62 | 0 | 1
Fremont | 77 | 0
Gilford | 290 | 1 | 2
Gilmanton | 151 | 0 | 1
Goffstown | 801 | 0 | 1
Greenland | 152 | 0 | 5
Hale's Location | 0 | 0 | 1
Hampstead | 270 | 0 | 0
Hampton | 768 | 1 | 6
[NAME] | 71 | 0 | 0
Hart's Location | 2 | 0 | 0
[NAME] | 484 | 0 | 2
[NAME] | 67 | 1 | 1
Kensington | 115 | 0 | 0
Kingston | 178 | 0 | 4
[NAME] | 133 | 0 | 1
[NAME] | 108 | 0 | 2
[NAME] 3 | 118 | 1 | 0
[NAME] | 120 | 0 | 3
[NAME] | 104 | 0 | 2
[NAME] 6 | 100 | 1 | 3
[NAME] | 345 | 1 | 0
[NAME] | 627 | 1 | 2
Madbury | 148 | 1 | 0
[NAME] | 61 | 0 | 0
[NAME] | 662 | 0 | 0
[NAME] | 582 | 0 | 7
[NAME] 3 | 415 | 1 | 4
[NAME] | 411 | 2 | 2
[NAME] | 464 | 2 | 3
[NAME] 6 | 708 | 6 | 2
[NAME] | 537 | 0 | 2
[NAME] 8 | 693 | 4 | 2
[NAME] 9 | 603 | 1 | 1
[NAME] 10 | 602 | 0 | 2
[NAME] 11 | 413 | 2 | 1
[NAME] 12 | 478 | 0 | 8
Meredith | 222 | 0 | 2
Merrimack | 997 | 0 | 8
[NAME] | 71 | 0 | 0
Milton | 145 | 0 | 2
Moultonborough | 160 | 1 | 1
New Castle | 144 | 0 | 0
New Durham | 101 | 0 | 0
New Hampton | 103 | 0 | 1
Newfields | 89 | 0 | 0
Newington | 73
Newmarket | 460 | 1 | 0
Newton | 94 | 0 | 45
[NAME] | 242 | 0 | 3
Northwood | 152 | 1 | 0
[NAME] | 188 | 0 | 0
Ossipee | 98 | 0 | 0
Pittsfield | 144 | 1 | 1
Plaistow | 181 | 1 | 0
Portsmouth Ward 1 | 264 | 0 | 0
Portsmouth Ward 2 | 403 | 1 | 2
Portsmouth Ward 3 | 192 | 1
Portsmouth Ward 4 | 387 | 1 | 0
Portsmouth Ward 5 | 405 | 0 | 0
[NAME] | 299 | 2 | 4
Rye | 443 | 0 | 1
Rochester Ward 1 | 280 | 2 | 0
[NAME] | 196 | 1 | 0
[NAME] 3 | 235 | 4 | 0
Rochester Ward 4 | 293 | 0 | 0
Rochester Ward 5 | 219 | 1 | 0
[NAME] | 156 | 0 | 0
Sandown | 133 | 1 | 0
Sandwich | 149 | 0 | 0
Seabrook | 213 | 0 | 1
[NAME] | 138 | 0 | 0
[NAME] | 138 | 0 | 0
[NAME] 3 | 141 | 0 | 0
[NAME] | 194 | 1 | 0
[NAME] 5 | 137 | 0 | 1
[NAME] | 30 | 0 | 0
[NAME] | 197 | 2 | 0
Stratham | 261 | 0 | 0
Tamworth | 124 | 0 | 0
Tuftonboro | 67 | 3 | 0
Wakefield | 111 | 0 | 0
Wolfeboro | 206 | 0 | 0
Totals | 29164 | 70 | 182
Spreadsheet: 836660d1689575003-using-index-formula-to-summarise-training-database-index
Sheet: Group Ind Record

CÔNG TY TNHH GE-SHEN VIỆT NAM |  |  |  |  |  |  |  |  |  |  |  | Form  :  HR-F01
GE-SHEN (VIETNAM) CO., LTD. |  |  |  |  |  |  |  |  |  |  |  | Rev    :  C
GHI CHÉP ĐÀO TẠO CÁ NHÂN/ NHÓM GROUP / INDIVIDUAL TRAINING RECORD
Ngày đào tạo Date Of Training |  |  | 2022-01-05 00:00:00 |  |  |  | [NAME] điểm Venue
[NAME] Date End |  |  |  |  |  |  | Người đào tạo Trainer's Name
Số ngày Time/ No. Of Days |  |  |  |  |  |  | Người đào tạo [NAME] | 6S Training
TT No. | [NAME] học viên Attended  Name |  |  | Emp. No | Dept | Khóa đào tạo Training Course |  |  |  | Kết quả đào tạo Result | Chữ ký  Signature | Ghi chú Remarks
1 | name here will be tabulated based on the training title and date above |  |  | lookup value from Database sheet or Employee name | lookup value from Database sheet or Employee name | I.NỘI DUNG ĐÀO TẠO
2 |  |  |  |  |  | 1.Hiểu được 6S là gì
3 |  |  |  |  |  | 2.Lợi ích khi thực hiện 6S
4 |  |  |  |  |  | 3.Quy trình thực hiện để duy trì hoạt
5 |  |  |  |  |  | động 6S
6 |  |  |  |  |  | (Đào tạo trong 30 phút)
7 |  |  |  |  |  | [NAME] tra trong 10 phút
8 |  |  |  |  |  | TỔNG THỜI GIAN ĐÀO TẠO : 40 [NAME]
9
10 |  |  |  |  |  | [NAME]
11 |  |  |  |  |  | 1.Understand what 6S is
12 |  |  |  |  |  | 2.Benefits of implementing 6S
13 |  |  |  |  |  | 3.Process to maintain operation 6S
14 |  |  |  |  |  | (Training for 30 minutes)
15 |  |  |  |  |  | II.Take the test in 10 minutes
16 |  |  |  |  |  | TOTAL TRAINING TIME : 40 MINUTES
17
18
19
20
21
22
23
24
25
26
27
28
29
30
Ghi chép bởi Recorded by |  | : | [NAME]
Spreadsheet: 864840d1711983589-auto-populate-a-range-with-selected-rows-from-a-second-range-but-the-nightmarish-way-stone-inventory
Sheet: HEARTH

UUID | MATERIAL | Code | MATERIAL NAME | Depth | BATCH / SLAB ID | Cost per m2 | SECTION 1 LENGTH | SECTION 1 HEIGHT | SECTION 2 LENGTH | SECTION 2 HEIGHT | SECTION 3 LENGTH | SECTION 3 HEIGHT | SECTION 4 LENGTH | SECTION 4 HEIGHT | AREA  (m2) | NOTES | [NAME]? | Frame / Rack | Shape | Value
2 |  | SGL |  | 30 |  |  | 3000 | 2000 |  |  |  |  |  |  |  |  | F | 1
3 |  | NH |  | 20 |  |  | 3000 | 1950 |  |  |  |  |  |  |  |  | F | 2
Spreadsheet: a79ca1e8-4137-4d2d-b5a1-4133cd30ca0a
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
8655 | 41579 | Ece | [NAME] | TUR | 4 | [NAME] | 00:00:19 | 00:38:57 | 00:00:19 | 00:21:27 | 1 | 01:12:21
8655 | 53569 | Stefania | Ion | [NAME] | 3 | 00:10:50 | 00:00:20 | 00:39:30 | 00:00:20 | [NAME] | 2 | 01:12:39
8655 | 72789 | [NAME] | Irmak | TUR | 2 | 00:11:26 | 00:00:20 | 00:38:56 | [NAME] | 00:22:40 | 3 | 01:13:50
8655 | 41778 | Rositsa | Petrova | BUL | 5 | [NAME] | 00:00:28 | 00:44:04 | 00:00:25 | 00:23:00 | 4 | 01:20:31
Spreadsheet: 166489d1341600190-formula-problem-vlookup-combined-with-if-statement-excel-spreadheet-if-statement-with-vloolup
Sheet: pic_tix % DS

Invoice Number | Billing Specialist | [NAME]
1153089 | [NAME]
1154324 | [NAME]
1154325 | [NAME] |  | I would like this to be [NAME]
1154326 | [NAME] |  | I would like this to be [NAME]
1154327 | [NAME]
1154328 | [NAME]
Spreadsheet: 2d492183-e9ab-42ed-9a0e-6762aff26d50
Sheet: CF

 | ADVANCED MICRO DEVICES, INC.
 | CONSOLIDATED STATEMENT OF CASH FLOWS
 | (Millions)
 |  | Quarter Ended
 |  | Apr. 2,
 |  | 2011
 | Cash flows from operating activities:
 | Net income | 510
 | Adjustments to reconcile net income to net cash used in operating activities:
 | Equity income (loss) and dilution gain in investee | -492
 | Depreciation and amortization | 88
 | Compensation recognized under employee stock plans | 27
 | Non-cash interest expense | 5
 | Provision (benefit) for deferred income taxes | 9
 | Other | 11
 | Changes in operating assets and liabilities:
 | Accounts receivable | -195
 | Inventories | -16
 | Prepaid expenses and other current assets | -11
 | Other assets | 10
 | Accounts payable to GLOBALFOUNDRIES | -78
 | Accounts payable, accrued liabilities and other | -36
 | Net cash used in operating activities | -168
 | Cash flows from investing activities:
 | Purchases of property, plant and equipment | -38
 | Purchases of available-for-sale securities | -393
 | Proceeds from sale and maturity of available-for-sale securities | 434
 | Other | -17
 | Net cash used in investing activities | -14
 | Cash flows from financing activities:
 | Proceeds from borrowings, net of issuance cost | 165
 | Net proceeds from foreign grants | 7
 | Proceeds from issuance of common stock | 9
 | Repayments of debt and capital lease obligations | -1
 | Other | -2
 | Net cash provided by financing activities | 178
 | Net decrease in cash and cash equivalents | -4
 | Cash and cash equivalents at beginning of period | 606
 | Cash and cash equivalents at end of period | 602
Spreadsheet: 195227d1353448283-how-to-stop-value-appearing-rate-calculator
Sheet: Rates

[NAME] | UNIT | RATE
RATE 1 | min charge | 308.46
RATE 2 | [NAME] | 93.61
RATE 3 | min charge | 240.3
RATE 4 | [NAME] | 65.94
RATE 5 | [NAME] | 186.36
RATE 6 | [NAME] | 120.55
RATE 7 | [NAME] | 140.53
RATE 8 | [NAME] | 204.57
Spreadsheet: 211928d1359992347-pull-data-based-on-day-of-week-from-another-workbook-for-previous-three-weeks-salesreport2013
Sheet: 0115

 | Date: | 2013-01-15 00:00:00
 | Day
 | Time | Trans. | Total Sales | Avg. Sales
 | 09:00:00 | 0 | 0
 | 10:00:00 | 10 | 48.61
 | 11:00:00 | 61 | 325.69
 | 12:00:00 | 85 | 471.3
 | 13:00:00 | 74 | 393.53
 | 14:00:00 | 41 | 174.71
 | 15:00:00 | 43 | 244.02
 | 16:00:00 | 39 | 194.45
 | 17:00:00 | 51 | 359.11
 | 18:00:00 | 53 | 362.13
 | 19:00:00 | 42 | 287.44
 | 20:00:00 | 34 | 182.97
 | 21:00:00 | 31 | 175.54
 | 22:00:00 | 18 | 118.02
 | 23:00:00 | 18 | 105.18
 | 1900-01-01 00:00:00 | 10 | 83.95
 | 1900-01-01 01:00:00 | 0 | 0
 | 1900-01-01 02:00:00 | 0 | 0
 | 1900-01-01 03:00:00 | 0 | 0
 | 04:00:00 | 0 | 0
 | Total
Spreadsheet: 173247d1344483598-output-date-from-changing-cell-range-sample
Sheet: Sheet1

Date |  | SO or PO | Status | Qty | Rec | Customer or [NAME] | Running Total |  | ETA |  | Date it would be
 |  |  |  |  |  |  |  |  |  |  |  |  |  | eg. To calculate ETA for SO1
 | Outstanding | SO1 | Open | 10 | 0 | Customer1 | 10 |  |  |  | 2012-08-09 00:00:00 |  |  | if H3 is less than total in H8 then put A8 in J3
 | Outstanding | SO2 | Open | 10 | 0 | Customer2 | 20 |  |  |  | 2012-09-05 00:00:00 |  |  | or, if H3 is greater than H8 but less than H9, then put A9 in J3
 | Outstanding | SO3 | Open | 5 | 0 | Customer3 | 25 |  |  |  | 2012-09-05 00:00:00 |  |  | and so on, and so on
 | Outstanding | SO4 | Open | 6 | 0 | Customer4 | 31 |  |  |  | 2012-09-10 00:00:00 |  |  | hope this makes sense
Date | Status | SO # |  | Total | Supplied |  | Remain
2012-08-01 00:00:00 | Outstanding | SO1 | Open | 8 | 6 | Supplier | 2 |  |  |  |  |  |  | values in column E can be continually changing and the ETA
2012-08-09 00:00:00 | Outstanding | SO2 | Open | 10 | 0 | Supplier | 12 |  |  |  |  |  |  | for orders need to adjust if part of the PO comes in (as shown)
2012-08-28 00:00:00 | Outstanding | SO3 | Open | 4 | 0 | Supplier | 16
2012-09-05 00:00:00 | Outstanding | SO4 | Open | 12 | 0 | Supplier | 28
2012-09-10 00:00:00 | Outstanding | SO5 | Open | 5 | 0 | Supplier | 33
Spreadsheet: 455420d1460328637-next-value-return-data-example
Sheet: Sheet1

Date | Product | Sales
2004-05-01 00:00:00 | Apples | 10
2004-05-01 00:00:00 | Oranges | 5
2004-05-01 00:00:00 | Carrots | 7
2004-05-01 00:00:00 | Bananas | 6
2004-05-10 00:00:00 | Apples | 2
2004-05-10 00:00:00 | Oranges | 11
2004-05-10 00:00:00 | Bananas | 14
2004-05-10 00:00:00 | Carrots | 5
2004-05-20 00:00:00 | Apples | 9
2004-05-20 00:00:00 | Carrots | 6
2004-05-20 00:00:00 | Bananas | 7
2004-05-20 00:00:00 | Oranges | 12
Spreadsheet: 177555d1346345422-tally-chart-using-buttons-example
Sheet: Sheet2

Day | 1 |  | Day | 2 |  | Day | 3 |  | Day | 4 |  | Day | 5 |  | Day | 6 |  | Day | 7
Date | 2012-08-27 00:00:00 |  | Date | 2012-08-28 00:00:00 |  | Date | 2012-08-29 00:00:00 |  | Date | 2012-08-30 00:00:00 |  | Date | 2012-08-31 00:00:00 |  | Date | 2012-09-01 00:00:00 |  | Date | 2012-09-02 00:00:00
Button | Count |  | Button | Count |  | Button | Count |  | Button | Count |  | Button | Count |  | Button | Count |  | Button | Count
Red |  |  | Red |  |  | Red |  |  | Red |  |  | Red |  |  | Red |  |  | Red
Blue |  |  | Blue |  |  | Blue |  |  | Blue |  |  | Blue |  |  | Blue |  |  | Blue
Green |  |  | Green |  |  | Green |  |  | Green |  |  | Green |  |  | Green |  |  | Green
Yellow |  |  | Yellow |  |  | Yellow |  |  | Yellow |  |  | Yellow |  |  | Yellow |  |  | Yellow
Purple |  |  | Purple |  |  | Purple |  |  | Purple |  |  | Purple |  |  | Purple |  |  | Purple
Violet |  |  | Violet |  |  | Violet |  |  | Violet |  |  | Violet |  |  | Violet |  |  | Violet
White |  |  | White |  |  | White |  |  | White |  |  | White |  |  | White |  |  | White
Black |  |  | Black |  |  | Black |  |  | Black |  |  | Black |  |  | Black |  |  | Black
Received |  |  | Received |  |  | Received |  |  | Received |  |  | Received |  |  | Received |  |  | Received
Dispatched |  |  | Dispatched |  |  | Dispatched |  |  | Dispatched |  |  | Dispatched |  |  | Dispatched |  |  | Dispatched
Invoiced |  |  | Invoiced |  |  | Invoiced |  |  | Invoiced |  |  | Invoiced |  |  | Invoiced |  |  | Invoiced
[NAME] |  |  | [NAME] |  |  | [NAME] |  |  | [NAME] |  |  | [NAME] |  |  | [NAME] |  |  | [NAME]
Spreadsheet: darrell_schoolcraft__7761__imbalsumm0106
Sheet: PGETX

 |  |  |  |  | 12283
 | [NAME] |  | Pecos Del |  | Gunpoint #2
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 122911 | 120605 | 50961 | 53638
2 | 145284 | 108474 | 50999 | 88318
3 | 146493 | 108474 | 50983 | 88239
4 | 152546 | 118425 | 44619 | 78318
5 | 117494 | 79555 | 1308 | 38315
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 |  |  |  | 2001-05-31 00:00:00 |  |  | 239578
 |  |  |  | 2001-06-05 00:00:00
Spreadsheet: 144199d1330786999-macro-vba-for-adding-pre-specified-text-to-a-cell-begroting-2012
Sheet: Jaaroverzicht

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Parameters
 |  |  | Maand | Begroting | Uitgave
 |  |  | Januari | 5000.5 | 2850
 |  |  | Februari | 5000.3 | 2910
 |  |  | Maart | 5000.3 | 2700
 |  |  | April | 5000.3 | 2760
 |  |  | [NAME] | 5000.3 | 2810
 |  |  | Juni | 5000.3 | 2920
 |  |  | [NAME] | 5000.3 | 3110
 |  |  | Augustus | 5000.3 | 2800
 |  |  | September
 |  |  | Oktober
 |  |  | November
 |  |  | December
Spreadsheet: 94830d1294592130-extend-index-match-want2learn_billingstatement
Sheet: Sales

 |  |  | 0 |  |  |  |  |  |  |  |  |  |  | This filters when
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Billing Statement'!E7 changes.
Inv # | Sold to: | Inv Date | Subtotal | Tax | Total | Received | SALESPERSON | P.O. # | SHIP DATE | SHIP VIA | F.O.B. | TERMS |  | Invoices | Remove Blanks |  | Customers
661 | ABC |  | 100 | 17.5 | 117.5 | 2010-01-01 00:00:00 |  |  |  |  |  |  |  |  | 662 |  | ABC
662 | [NAME] | 2010-09-24 00:00:00 | 200 | 0 | 200 | 2010-08-31 00:00:00 |  |  |  |  |  |  |  | 662 | 670 |  | [NAME]
663 | Acme Inc | 2010-10-04 00:00:00 | 100 | 0 | 100 |  |  |  |  |  |  |  |  |  | 671 |  | Acme Inc
664 | ABC | 2010-10-04 00:00:00 | 100 | 0 | 100 |  |  |  |  |  |  |  |  |  |  |  | FOSH
664 | Acme Inc | 2010-10-08 00:00:00 | 745.67 | 0 | 745.67
665 | Acme Inc | 2010-10-08 00:00:00 | 1491.34 | 0 | 1491.34
666 | ABC | 2010-10-08 00:00:00 | 745.67 | 0 | 745.67
667 | ABC | 2010-10-08 00:00:00 | 745.67 | 0 | 745.67
668 | Acme Inc | 2010-10-08 00:00:00 | 1491.34 | 0 | 1491.34
669 | FOSH | 2010-10-12 00:00:00 | 385 | 0 | 385
670 | [NAME] | 2011-01-08 00:00:00 | 16.5 | 0 | 16.5 |  |  |  |  |  |  |  |  | 670
671 | [NAME] | 2011-01-08 00:00:00 | 16.5 | 0 | 16.5 |  | bill | a3 | 1 | 2 | 3 | 4 |  | 671
Spreadsheet: 287645d1388920304-unable-to-delete-or-remove-objects-example
Sheet: MATERIALS PROCUREMENT TRACKING 

 | 16 | LIGHTING FIXTURES (INTERIOR)
 | 17 | WIRING DEVICES
 | 18 | BUILDING COMMUNICATION AND DATA (STRUCTURED CABLING SYSTEM)
 | 9 |  |  |  |  |  |  | ü
 | 20
 |  |  |  |  |  |  |  | ü
 | 21 | Saudi Electric Supply Company (SESCO) |  | Hook-up Materials: Tubing & Fittings | 1 | Lot
 | 22 | Saudi Electric Supply Company (SESCO) |  | Junction Boxes | 1 | Lot | ü
 | 23 | CGA/ |  | Instrument Cables | 1 | Lot
 | 24 | CGI/Bentley Nevada |  | VMS | 1 | Lot |  | ü
 |  | Honeywell |  | DCS | 1 | Lot |  | ü
 |  | ELECTRICAL WORKS
 | 25 | ABB Italy |  | Modification MV MCC | 1 | Lot |  | ü
 |  | ABB Italy |  | Modification LV MCC | 1 | Lot |  | ü
 |  | ABB Italy |  | Modification LV MCC | 1 | Lot |  | ü
 | 26 | Saudi Electric Supply Co. |  | Local Control Stations | 1 | Lot | ü
 |  | Remal Electric Power and Automation Solutions |  | LV Distribution Panels | 1 | Lot
 | 27 | CGA/ |  | Lighting Fixtures | 1 | Lot
 | 28 | Eastern Lighting Factory Ltd |  | Lighting Poles & Stanchions | 1 | Lot | ü
 | 29 | Saudi Electric Supply Co. |  | Dry Type Transformers | 1 | Lot | ü
 | 30 | Intertechnos |  | Extension of Plant Communication System | 1 | Lot |  | ü
 | 31 | Sogec |  | Cathodic Protection System | 1 | Lot | ü
 | 32 | Saudi Electric Supply Co. |  | Lighting & Small Power | 1 | Lot | ü
 | 33 | Saudi Cable Company |  | MV Power Cables | 1 | Lot | ü
 | 34 | Middle East Specialized Cables Co. (MESC) |  | LV Power & Control Cables | 1 | Lot | ü
 | 35 | Sigma Control Italy |  | Heat Tracing System for Oil Skimmers V 310SA/B | 1 | Lot |  | ü
 | 36 | CGA/ |  | Cable Trays | 1 | Lot
 | 37 | CGA/ |  | Conduits & Fittings | 1 | Lot
 | 38 | CGA/ |  | Grounding Systems | 1 | Lot
 |  | DESIGN IMPROVEMENT WORKS
 | 39 |  |  | Piping for Chemical Selection Trials & Dosing Equipment Review | 1 | Lot
 | 40 | Eta Process Plant |  | Surge Tank Internals | 1 | Lot |  | ü
 | 41 |  |  | Surge Tank Internal Coating | 1 | Lot
 | 42 | [NAME] |  | Hydro Transporting System & Sludge Handling Unit | 1 | Lot |  | ü
 |  | [NAME] PROC.
 | 43 |  |  | Vendors Representative on Site for Mechanical Equipment | 1 | Lot
 | 44 |  |  | Chemicals | 1 | Lot
 | 45 | Generon IGS, Inc. |  | Nitrogen Genarator System | 1 | Lot |  | ü
 |  | ANY OTHER MATERIAL REQUIRED
 | 46 | [NAME] UK |  | Static Mixers | 5 | Ea |  | ü
 |  |  |  | Valves | 1 | Lot
 |  | CGA/Saudi Electric Industries Co. Ltd (SEICO) |  | Cable Glands | 1 | Lot | ü
 |  | Saudi Cranes and Steelworks Factory Ltd |  | [NAME] | 1 | Lot | ü
 |  | Kirby Building Systems - Kuwait |  | Pump P-901 Shelter & Extension of Chemical Building | 2 | Lot |  | ü
Spreadsheet: 181154d1347948857-conditional-formatting-advanced-sample
Sheet: Sheet2

SURNAME
[NAME] | CBD | EFG | HIJ | LMN | OPQ | RST
Spreadsheet: 188791d1350993833-conditional-formatting-across-rows-format-cells
Sheet: Sheet1

rate | rank | rate | rank | rate
53 | 3 | 52 | 2 | 51
49 | 3 | 57 | 1 | 48
42 | 1 | 44 | 3 | 43
Spreadsheet: 873667d1720180566-if-function-with-sumifs-if-statement-and-sumif-actual-and-forecast
Sheet: Result

 | P1 | P2 | P3 | P4 | P5 | P6 | P7 | P8 | P9 | P10 | P11 | P12
 | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar
Financial Year |  |  |  |  |  |  |  |  |  |  |  |  | Total
Cost 1
Cost 2
Cost 3
Cost 4
Cost 5
Cost 6
Cost 7
Cost 8
Cost 9
Total
Exepected Results
 | ACTUAL | ACTUAL | FORECAST | FORECAST | FORECAST | FORECAST | FORECAST | FORECAST | FORECAST | FORECAST | FORECAST | FORECAST | Total
Cost 1 | 10000 |  | 0 |  | 18000 |  | 25000 |  | 25000
Cost 2
Cost 3
Cost 4
Cost 5 |  | 28000 |  |  | 12000 |  |  | 63000
Cost 6
Cost 7
Cost 8
Cost 9
Total
HI team
Could someone please assist to help me pull through the actual or forecast for specific  month on my expected result-so at any time when the actual or forecast changes by moving the cell from the source data my result tab will update
On the if statement formular my value if criteria should only pick the sum of forecast for specific month if it is not actual.
Actual spend todate
Forecast remaining to spend
Spreadsheet: 41740d1240266919-creating-a-cell-in-colour-book1
Sheet: Sheet1

 |  | 1 | 2 | 3 | 4 | 5 | 6 |  | Each of these cells (c3:h23) in this range (It's a labelled range "Numbers"), have a conditional format that seeks to see if it exists in the input range below ([NAME]:b31) which is labelled "Drawn_Numbers".
 |  | 7 | 8 | 9 | 10 | 11 | 12
 |  | 13 | 14 | 15 | 16 | 17 | 18
 |  | 19 | 20 | 21 | 22 | 23 | 24
 |  | 25 | 26 | 27 | 28 | 29 | 30
 |  | 31 | 32 | 33 | 34 | 35 | 36
 |  | 37 | 38 | 39 | 40 | 41 | 42
 |  | 43 | 44 | 45 | 46 | 47 | 48
 |  | 49 | 50 | 51 | 52 | 53 | 54
 |  | 55 | 56 | 57 | 58 | 59 | 60
 |  | 61 | 62 | 63 | 64 | 65 | 66
 |  | 67 | 68 | 69 | 70 | 71 | 72
 |  | 73 | 74 | 75 | 76 | 77 | 78
 |  | 79 | 80 | 81 | 82 | 83 | 84
 |  | 85 | 86 | 87 | 88 | 89 | 90
 |  | 91 | 92 | 93 | 94 | 95 | 96
 |  | 97 | 98 | 99 | 100 | 101 | 102
 |  | 103 | 104 | 105 | 106 | 107 | 108
 |  | 109 | 110 | 111 | 112 | 113 | 114
 |  | 115 | 116 | 117 | 118 | 119 | 120
 |  | 121 | 122 | 123 | 124 | 125 | 126
 |  | #1